while ($GDL = ibase_fetch_row($ent3)) {
if ($S[3] == $GDL[3] and $S[0] == $GDL[0]) {
$gdl = 1;
}
}
//CONECTA MONTERREY
$conn4 = Connectmty();
$sql4 = "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 ";
$ent4 = ibase_query($conn4, $sql4);
while ($MTY = ibase_fetch_row($ent4)) {
if ($S[3] == $MTY[3] and $S[0] == $MTY[0]) {
$mty = 1;
}
}
//CONECTA PUEBLA
$conn5 = Connectpue();
$sql5 = "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 ";
$ent5 = ibase_query($conn5, $sql5);
while ($PUE = ibase_fetch_row($ent5)) {
if ($S[3] == $PUE[3] and $S[0] == $PUE[0]) {
$pue = 1;
}
}
//CONECTA VERACRUZ
$conn6 = Connectver();
$sql6 = "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 ";
$ent6 = ibase_query($conn6, $sql6);
while ($VER = ibase_fetch_row($ent6)) {
if ($S[3] == $VER[3] and $S[0] == $VER[0]) {
$ver = 1;
}
$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) {
$conn = Connectpue();
$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) {
$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') {
$conn2 = Connectpue();
$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') {
