while ($MID = ibase_fetch_row($ent8)) {
if ($S[3] == $MID[3] and $S[0] == $MID[0]) {
$mid = 1;
}
}
//CONECTA CHIHUAHUA
$conn9 = Connectcuu();
$sql9 = "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 ";
$ent9 = ibase_query($conn9, $sql9);
while ($CUU = ibase_fetch_row($ent9)) {
if ($S[3] == $CUU[3] and $S[0] == $CUU[0]) {
$cuu = 1;
}
}
//CONECTA QUERETARO
$conn10 = Connectqro();
$sql10 = "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 ";
$ent10 = ibase_query($conn10, $sql10);
while ($QRO = ibase_fetch_row($ent10)) {
if ($S[3] == $QRO[3] and $S[0] == $QRO[0]) {
$qro = 1;
}
}
//CONECTA TUXTLA
$conn11 = Connecttgz();
$sql11 = "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 ";
$ent11 = ibase_query($conn11, $sql11);
while ($TGZ = ibase_fetch_row($ent11)) {
if ($S[3] == $TGZ[3] and $S[0] == $TGZ[0]) {
$tgz = 1;
}
$ABR = 'VER';
}
if ($num_suc == 6) {
$conn = Connectcun();
$ABR = 'CUN';
}
if ($num_suc == 7) {
$conn = Connectmid();
$ABR = 'MID';
}
if ($num_suc == 8) {
$conn = Connectcuu();
$ABR = 'CUU';
}
if ($num_suc == 9) {
$conn = Connectqro();
$ABR = 'QRO';
}
if ($num_suc == 10) {
$conn = Connecttgz();
$ABR = 'TGZ';
}
if ($clave == '') {
$sql = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, MINVE03.CANT AS CANTIDAD, MINVE03.EXISTENCIA FROM MINVE03 WHERE MINVE03.REFER ='{$folio}' ORDER BY MINVE03.CVE_ART DESC ";
} else {
$sql = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, MINVE03.CANT AS CANTIDAD, MINVE03.EXISTENCIA FROM MINVE03 WHERE MINVE03.REFER ='{$folio}' and MINVE03.CVE_ART='{$clave}' ORDER BY MINVE03.CVE_ART DESC ";
}
$conexsuc = ibase_query($conn, $sql);
while ($CS = ibase_fetch_row($conexsuc)) {
$fechasal = $CS[2];
$maskSAL = $fechasal[8] . $fechasal[9] . $fechasal[7] . $fechasal[5] . $fechasal[6] . $fechasal[4] . $fechasal[0] . $fechasal[1] . $fechasal[2] . $fechasal[3];
$ABR2 = 'VER';
}
if ($suc2 == 'CANCUN') {
$conn2 = Connectcun();
$ABR2 = 'CUN';
}
if ($suc2 == 'MERIDA') {
$conn2 = Connectmid();
$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') {
