Esempio n. 1
0
 while ($VER = ibase_fetch_row($ent6)) {
     if ($S[3] == $VER[3] and $S[0] == $VER[0]) {
         $ver = 1;
     }
 }
 //CONECTA CANCUN
 $conn7 = Connectcun();
 $sql7 = "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  ";
 $ent7 = ibase_query($conn7, $sql7);
 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;
     }
Esempio n. 2
0
     $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) {
     $conn = Connectcuu();
     $ABR = 'CUU';
 }
 if ($num_suc == 9) {
     $conn = Connectqro();
     $ABR = 'QRO';
 }
 if ($num_suc == 10) {
     $conn = Connecttgz();
     $ABR = 'TGZ';
 }
 if ($clave == '') {
Esempio n. 3
0
    $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') {
    $conn2 = Connectcuu();
    $ABR2 = 'CUU';
}
if ($suc2 == 'QUERETARO') {
    $conn2 = Connectqro();
    $ABR2 = 'QRO';
}
if ($suc2 == 'TUXTLA') {
    $conn2 = Connecttgz();
    $ABR2 = 'TGZ';
}
if ($suc2 == 'TIJUANA') {