1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157
| if(!isset($_SESSION['TAB2']) || $_GET['init'] == 1){
$tableau = array($_GET['f_numero_lot'],$_GET['emplacement'],$_GET['designation_stock'],$_GET['reference_stock'],$_GET['statut'],$_GET['zone']);
$_SESSION['TAB2'] = $tableau;
}
//format date pour un input date avec value: YYYY-MM-DD
$requete1 = "SELECT POP_STOCK.ID_STOCk as ID_STOCK,DATE_RECEPTION,NUM_EN_COURS_DEG,REFERENCE,DESIGNATION,INDICE,
QTE_PIECE_OK,QTE_PIECE_DRG,QTE_PIECE_NOK,TO_CHAR(DATE_RECEPTION,'DD/MM/YYYY') as DATE_RECEPTION,NOM_PERSONNE,NOM_EMPLACEMENT,ZONE,
LOT_PSO,NOM_FOURNISSEUR,POP_STOCK.COMMENTAIRE AS COMMENTAIRE,NUM_PROJET,NUM_AFFAIRE,ID_STATUT_VALIDATION_QUALITE,QUANTITE_RECU,
NB_PIECE_OK,NB_PIECE_DRG,NB_PIECE_NOK,SPLITER,POP_STOCK.ID_EN_COURS AS ID_EN_COURS,COMMENTAIRE_STOCK,POP_EN_COURS.COMMENTAIRE AS COMMENTAIRE_EN_COURS,
NUM_ISSUS_LOT
FROM POP_STOCK
LEFT JOIN POP_PERSONNE ON POP_STOCK.ID_PERSONNE = POP_PERSONNE.ID_PERSONNE
LEFT JOIN POP_EN_COURS ON POP_EN_COURS.ID_EN_COURS = POP_STOCK.ID_EN_COURS
LEFT JOIN POP_FOURNISSEUR ON POP_FOURNISSEUR.ID_FOURNISSEUR = POP_EN_COURS.ID_FOURNISSEUR
LEFT JOIN POP_EMPLACEMENT ON POP_EMPLACEMENT.ID_EMPLACEMENT = POP_STOCK.ID_EMPLACEMENT
LEFT JOIN POP_PROJET ON POP_PROJET.ID_PROJET = POP_EN_COURS.ID_PROJET
LEFT JOIN POP_DM ON POP_DM.ID_DM = POP_EN_COURS.ID_DM
WHERE 1=1 AND LOT_ANNULE = '0' ";
/*if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][4] != null && $_SESSION['TAB2'][4] != -1){
if ($_SESSION['TAB2'][4] == 2){
$statut_un = 1;
$requete1 .= " AND (QTE_PIECE_OK <= '0' AND QTE_PIECE_DRG <= '0' AND QTE_PIECE_NOK <= '0') ";
$requete1 .= " AND ID_STATUT_VALIDATION_QUALITE = '2'";
}
elseif($_SESSION['TAB2'][4] == 1){
$requete1 .= " AND ((QTE_PIECE_OK > '0' OR QTE_PIECE_DRG > '0' OR QTE_PIECE_NOK > '0') AND ID_STATUT_VALIDATION_QUALITE = '2')";
$requete1 .= " OR ID_STATUT_VALIDATION_QUALITE = '1'";
}
else{
$requete1 .= " AND ((QTE_PIECE_OK > '0' OR QTE_PIECE_DRG > '0' OR QTE_PIECE_NOK > '0') AND ID_STATUT_VALIDATION_QUALITE = '2')";
$requete1 .= " OR ID_STATUT_VALIDATION_QUALITE = '1'";
}
}*/
var_dump($_SESSION['TAB2']);
switch (true) {
case ($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0'):
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0')
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";
break;
case($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0'):
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0')
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";
break;
case($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0'):
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0')
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";
break;
case($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0'):
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0')
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";
break;
case($_SESSION['TAB2'][4] != null && $_SESSION['TAB2'][4] != 0):
if ($_SESSION['TAB2'][4] == 2){
$requete1 .= " AND (QTE_PIECE_OK <= '0' AND QTE_PIECE_DRG <= '0' AND QTE_PIECE_NOK <= '0') ";
$requete1 .= " AND ID_STATUT_VALIDATION_QUALITE = '2'";
}
elseif($_SESSION['TAB2'][4] == 1){
$requete1 .= " AND ((QTE_PIECE_OK > '0' OR QTE_PIECE_DRG > '0' OR QTE_PIECE_NOK > '0') AND ID_STATUT_VALIDATION_QUALITE = '2')";// problème ici voir le signe supérieur pourquoi pas interprété?
$requete1 .= " OR ID_STATUT_VALIDATION_QUALITE = '1'";
}
if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0')
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";
break;
case($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0'):
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";
if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
break;
default:
if($_SESSION['TAB2'][0] != null && $_SESSION['TAB2'][0] != '0')
$requete1 .= " AND NUM_EN_COURS_DEG LIKE '%".$_SESSION['TAB2'][0]."%'";
if($_SESSION['TAB2'][1] != null && $_SESSION['TAB2'][1] != '0')
$requete1 .= " AND POP_EMPLACEMENT.ID_EMPLACEMENT= ".$_SESSION['TAB2'][1];
if($_SESSION['TAB2'][2] != null && $_SESSION['TAB2'][2] != '0')
$requete1 .= " AND UPPER(DESIGNATION) LIKE UPPER('%".$_SESSION['TAB2'][2]."%')";
if($_SESSION['TAB2'][3] != null && $_SESSION['TAB2'][3] != '0')
$requete1 .= " AND UPPER(REFERENCE) LIKE UPPER('%".$_SESSION['TAB2'][3]."%')";
if($_SESSION['TAB2'][4] != null && $_SESSION['TAB2'][4] != -1){
if ($_SESSION['TAB2'][4] == 2){
$statut_un = 1;
$requete1 .= " AND (QTE_PIECE_OK <= 0 AND QTE_PIECE_DRG <= 0 AND QTE_PIECE_NOK <= 0) ";
$requete1 .= " AND ID_STATUT_VALIDATION_QUALITE = '2'";
}
elseif($_SESSION['TAB2'][4] == 1){
$requete1 .= " AND ((QTE_PIECE_OK > '0' OR QTE_PIECE_DRG > '0' OR QTE_PIECE_NOK > '0') AND ID_STATUT_VALIDATION_QUALITE = '2')";
$requete1 .= " OR ID_STATUT_VALIDATION_QUALITE = '1'";
}
else{
$requete1 .= " AND ((QTE_PIECE_OK > '0' OR QTE_PIECE_DRG > '0' OR QTE_PIECE_NOK > '0') AND ID_STATUT_VALIDATION_QUALITE = '2')";
$requete1 .= " OR ID_STATUT_VALIDATION_QUALITE = '1'";
}
}
/*if($_SESSION['TAB2'][5] != null && $_SESSION['TAB2'][5] != '0')
$requete1 .= " AND UPPER(ZONE) LIKE UPPER('%".$_SESSION['TAB2'][5]."%')";*/
}
$requete1 .= "ORDER BY NUM_EN_COURS_DEG DESC"; echo $requete1;
$statement1 = oci_parse($conn, $requete1);
oci_execute($statement1,OCI_COMMIT_ON_SUCCESS);
$requete2 = "SELECT ID_SITE,CODE_SITE,LABEL_SITE FROM POP_SITE ORDER BY CODE_SITE ASC";
$statement2 = oci_parse($conn, $requete2);
oci_execute($statement2,OCI_COMMIT_ON_SUCCESS); |
Partager