$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') {