Example #1
0
 while ($GTO = ibase_fetch_row($ent2)) {
     if ($S[3] == $GTO[3] and $S[0] == $GTO[0]) {
         $gto = 1;
     }
 }
 //CONECTA GUADALAJARA
 $conn3 = Connectgdl();
 $sql3 = "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  ";
 $ent3 = ibase_query($conn3, $sql3);
 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;
     }
Example #2
0
include "conex.php";
while ($num_suc <= 10) {
    if ($num_suc == 0) {
        $conn = Connectmex();
        $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) {
Example #3
0
							<td class="contentfac" align="left">
								<?php 
if ($suc2 == 'MEXICO') {
    $conn2 = Connectmex();
    $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') {