<?php

$link_base =mysqli_connect("74.208.26.126:3310", "master", "padt6457");

mysqli_select_db($link_base, "caronteerp");

$pagos_siniestros =  mysqli_query($link_base, "SELECT idmovimiento FROM autotransportes_pagossinsiniestro ORDER BY id DESC LIMIT 1"); 
$pagos = [];
if(mysqli_num_rows($pagos_siniestros)>0){
	$pagos = get_pagos_by_id();
}else{
	$pagos = get_all_pagos();
}


if(count($pagos)>0){
	foreach($pagos as $pago){
		mysqli_query($link_base,"INSERT INTO autotransportes_pagossinsiniestro VALUES (".$pago['idmovimiento'].",".$pago['idpermisionario'].",".$pago['idoperador'].",".$pago['nombreoperador'].",".$pago['monto'].",".$pago['folio'].",".$pago['empresalog'].",".$pago['cancelado'].",".$pago['usuario'].",".$pago['fecha'].",".$pago['hora'],",".$pago['folioOpe'].",".$pago['folioPer'].",".$pago['corte'].",".$pago['notas'].")");
		exit();
	}
}

function get_pagos_by_id($id_movimiento){
	$link = mysqli_connect("spsc.dynalias.net:3306", "root", "ercom");
	mysqli_select_db($link, "autotransportes");
	$result = mysqli_query($link, "SELECT * FROM pagosinsiniestro WHERE idmovimiento >".$id_movimiento);
	$data = [];
	if(mysqli_num_rows($result)>0){
		foreach ($result as $item){
			$data[] = $item;
		}
	}else{
		$data=[];
	}
	return $data;
	mysqli_close($link);
}
function get_all_pagos(){
	$link = mysqli_connect("spsc.dynalias.net:3306", "root", "ercom");
	mysqli_select_db($link, "autotransportes");
	$result = mysqli_query($link, "SELECT * FROM pagosinsiniestro WHERE YEAR(fecha)>2018");
	$data = [];
	if(mysqli_num_rows($result)>0){
		foreach ($result as $item){
			$data[] = $item;
		}
	}else{
		$data=[];
	}
	return $data;
	mysqli_close($link);
}
 


mysqli_close($link_base);