$gdl = 0;
$mty = 0;
$pue = 0;
$ver = 0;
$cun = 0;
$mid = 0;
$cuu = 0;
$qro = 0;
$tgz = 0;
$count = 0;
while ($S = ibase_fetch_row($sal)) {
$diferencia = 0;
$fechasal = $S[2];
$maskSAL = $fechasal[8] . $fechasal[9] . $fechasal[7] . $fechasal[5] . $fechasal[6] . $fechasal[4] . $fechasal[0] . $fechasal[1] . $fechasal[2] . $fechasal[3];
//CONECTA MEXICO
$conn1 = Connectmex();
$sql1 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC ";
$ent1 = ibase_query($conn1, $sql1);
while ($MX = ibase_fetch_row($ent1)) {
if ($S[3] == $MX[3] and $S[0] == $MX[0]) {
$mex = 1;
}
}
//CONECTA LEON
$conn2 = Connectgto();
$sql2 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC ";
$ent2 = ibase_query($conn2, $sql2);
while ($GTO = ibase_fetch_row($ent2)) {
if ($S[3] == $GTO[3] and $S[0] == $GTO[0]) {
$gto = 1;
}
echo "<th align='center'>FECHA </th>";
echo "<th align='center'>MOV. </th>";
echo "<th align='center'>SUCURSAL</th>";
$x = 0;
$count = 0;
$dif = 0;
$num_suc = 0;
$sumacant = 0;
$restacant = 0;
$numId = 0;
$idArray = 0;
$num = 0;
include "conex.php";
while ($num_suc <= 10) {
if ($num_suc == 0) {
$conn = Connectmex();
$ABR = 'MEX';
}
if ($num_suc == 1) {
$conn = Connectgto();
$ABR = 'GTO';
}
if ($num_suc == 2) {
$conn = Connectgdl();
$ABR = 'GDL';
}
if ($num_suc == 3) {
$conn = Connectmty();
$ABR = 'MTY';
}
if ($num_suc == 4) {
$cadena = $T[0];
$fechaTOP = $cadena[8] . $cadena[9] . $cadena[7] . $cadena[5] . $cadena[6] . $cadena[4] . $cadena[0] . $cadena[1] . $cadena[2] . $cadena[3] . $cadena[10] . $cadena[11] . $cadena[12] . $cadena[13] . $cadena[14] . $cadena[15] . $cadena[16] . $cadena[17] . $cadena[18];
echo "{$T['1']} {$fechaTOP}";
?>
</td>
</tr>
<tr>
<td class="contentfac" align="right">Ult. Mov. de respaldo : <?php
echo "{$suc2}";
?>
</td>
<td class="contentfac" align="left">
<?php
if ($suc2 == 'MEXICO') {
$conn2 = Connectmex();
$ABR2 = 'MEX';
}
if ($suc2 == 'LEON') {
$conn2 = Connectgto();
$ABR2 = 'GTO';
}
if ($suc2 == 'GUADALAJARA') {
$conn2 = Connectgdl();
$ABR2 = 'GDL';
}
if ($suc2 == 'MONTERREY') {
$conn2 = Connectmty();
$ABR2 = 'MTY';
}
if ($suc2 == 'PUEBLA') {
