$ABR2 = 'MID';
}
if ($suc2 == 'CHIHUAHUA') {
$conn2 = Connectcuu();
$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];
$almacen = 8;
}
if ($sucu == 'CUU') {
$conn = Connectcuu();
$almacen = 9;
}
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";
