$ABR2 = 'CUU'; } if ($suc2 == 'QUERETARO') { $conn2 = Connectqro(); $ABR2 = 'QRO'; } if ($suc2 == 'TUXTLA') { $conn2 = Connecttgz(); $ABR2 = 'TGZ'; } if ($suc2 == 'TIJUANA') { $conn2 = Connecttij(); $ABR2 = 'TIJ'; } if ($suc2 == 'LUCITE') { $conn2 = Connectluc(); $ABR2 = 'LUC'; } if ($ABR2 == 'LUC') { $sqlTop2 = "SELECT first(1) MINVE04.fechaelab, MINVE04.REFER FROM MINVE04 ORDER BY MINVE04.num_mov DESC"; } else { $sqlTop2 = "SELECT first(1) MINVE03.fechaelab, MINVE03.REFER FROM MINVE03 ORDER BY MINVE03.num_mov DESC"; } $rs2 = ibase_query($conn2, $sqlTop2); $T2 = ibase_fetch_row($rs2); $cadena2 = $T2[0]; $fechaTOP2 = $cadena2[8] . $cadena2[9] . $cadena2[7] . $cadena2[5] . $cadena2[6] . $cadena2[4] . $cadena2[0] . $cadena2[1] . $cadena2[2] . $cadena2[3] . $cadena2[10] . $cadena2[11] . $cadena2[12] . $cadena2[13] . $cadena2[14] . $cadena2[15] . $cadena2[16] . $cadena2[17] . $cadena2[18]; echo "{$T2['1']} {$fechaTOP2}"; ?> </td>
} if ($sucu == 'QRO') { $conn = Connectqro(); $almacen = 10; } if ($sucu == 'TGZ') { $conn = Connecttgz(); $almacen = 11; } if ($sucu == 'TIJ') { $conn = Connecttij(); $almacen = 12; } $nbd = '03'; if ($sucu == 'LUC') { $conn = Connectluc(); $almacen = 13; $nbd = '04'; } $conninv = Inventarios(); $nomTXT = 0; $sql = "SELECT MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".CVE_CPTO, MINVE" . $nbd . ".REFER, SUM(MINVE" . $nbd . ".CANT) AS CANT, MINVE" . $nbd . ".ALMACEN, MINVE" . $nbd . ".COSTO FROM MINVE" . $nbd . " WHERE MINVE" . $nbd . ".FECHA_DOCU>='{$fDesde}' and MINVE" . $nbd . ".FECHA_DOCU<='{$fHasta}' AND MINVE" . $nbd . ".CVE_CPTO = 2 GROUP BY MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".REFER, MINVE" . $nbd . ".CVE_CPTO, MINVE" . $nbd . ".ALMACEN, MINVE" . $nbd . ".COSTO ORDER BY MINVE" . $nbd . ".REFER ASC"; $sqlcanc = "SELECT MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".CVE_CPTO, MINVE" . $nbd . ".REFER, SUM(MINVE" . $nbd . ".CANT) AS CANT, MINVE" . $nbd . ".ALMACEN, MINVE" . $nbd . ".COSTO FROM MINVE" . $nbd . " WHERE MINVE" . $nbd . ".FECHA_DOCU>='{$fDesde}' and MINVE" . $nbd . ".FECHA_DOCU<='{$fHasta}' AND MINVE" . $nbd . ".CVE_CPTO = 56 GROUP BY MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".REFER, MINVE" . $nbd . ".CVE_CPTO, MINVE" . $nbd . ".ALMACEN, MINVE" . $nbd . ".COSTO"; $sqlF = "SELECT MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".FECHA_DOCU,MINVE" . $nbd . ".REFER FROM MINVE" . $nbd . " WHERE MINVE" . $nbd . ".CVE_CPTO = 2 AND ((MINVE" . $nbd . ".FECHA_DOCU)>='{$fDesde}') and ((MINVE" . $nbd . ".FECHA_DOCU)<='{$fHasta}') GROUP BY MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".FECHA_DOCU,MINVE" . $nbd . ".REFER ORDER BY MINVE" . $nbd . ".REFER, MINVE" . $nbd . ".CVE_ART, MINVE" . $nbd . ".FECHA_DOCU ASC "; $sqlDoctoE = "SELECT MINVE" . $nbd . ".CVE_ART,MINVE" . $nbd . ".REFER, DOCTOSIGF" . $nbd . ".CVE_DOC_E FROM MINVE" . $nbd . " LEFT JOIN DOCTOSIGF" . $nbd . " ON MINVE" . $nbd . ".REFER=DOCTOSIGF" . $nbd . ".CVE_DOC WHERE MINVE" . $nbd . ".CVE_CPTO = 2 AND ((MINVE" . $nbd . ".FECHA_DOCU)>='{$fDesde}') and ((MINVE" . $nbd . ".FECHA_DOCU)<='{$fHasta}') GROUP BY MINVE" . $nbd . ".CVE_ART,MINVE" . $nbd . ".REFER, DOCTOSIGF" . $nbd . ".CVE_DOC_E ORDER BY MINVE" . $nbd . ".REFER, MINVE" . $nbd . ".CVE_ART ASC "; $sqlCosto = "SELECT INVE01.CVE_ART, INVE01.ULT_COSTO FROM INVE01 ORDER BY INVE01.CVE_ART ASC"; $cedis = ibase_query($conn, $sql); echo "<table border = '1' style='font-family:Arial, Helvetica, sans-serif; font-size:12PX' cellpadding='1' cellspacing='0' align='center'>"; echo "<th align='center'>N°</th>"; echo "<th align='center'>CLAVE</th>"; echo "<th align='center'>MOV.</th>";