while ($CUN = ibase_fetch_row($ent7)) {
if ($S[3] == $CUN[3] and $S[0] == $CUN[0]) {
$cun = 1;
}
}
//CONECTA MERIDA
$conn8 = Connectmid();
$sql8 = "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 ";
$ent8 = ibase_query($conn8, $sql8);
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;
}
$ABR = 'PUE';
}
if ($num_suc == 5) {
$conn = Connectver();
$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 ";
}
$ABR2 = 'PUE';
}
if ($suc2 == 'VERACRUZ') {
$conn2 = Connectver();
$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') {
