function listeDesCdes($defaut = '', $magasin = '') { $userName = getField('LOGIN', $_SESSION['GL_USER']['LOGIN'], 'LOGIN', 'compte'); $ilang = getCodelangue($userName); isset($defaut) ? $where = " AND CDE_LIBELLE LIKE '{$defaut}%'" : ($where = ""); $sql = "SELECT * FROM commande INNER JOIN fournisseur ON (commande.CODE_FOUR=fournisseur.CODE_FOUR)\r\n\tWHERE commande.CODE_MAGASIN LIKE '" . addslashes($magasin) . "' AND commande.CDE_STATUT=1 {$where} ORDER BY CDE_DATE DESC;"; try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); die($error->getMessage() . ' ' . __LINE__); } $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $list = ''; $i = 0; while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $in = ''; $where = ''; $i % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow"); if (IsDelivery($row['CODE_COMMANDE'])) { $list .= '<tr class="' . $col . '"> <td align="left" valign="middle" class="text"><a href="#" onClick="pickUp(\'' . $row['CODE_COMMANDE'] . '\',\'' . addslashes($row['CDE_LIBELLE']) . '\',\'' . addslashes($row['CODE_FOUR']) . '\',\'' . addslashes($row['FOUR_NOM']) . '\');">' . $row['CODE_COMMANDE'] . '</a></td> <td align="center" valign="middle" class="text"><a href="#" onClick="pickUp(\'' . $row['CODE_COMMANDE'] . '\',\'' . addslashes($row['CDE_LIBELLE']) . '\',\'' . addslashes($row['CODE_FOUR']) . '\',\'' . addslashes($row['FOUR_NOM']) . '\');">' . frFormat2($row['CDE_DATE']) . '</a></td> <td class="text" ><a href="#" onClick="pickUp(\'' . $row['CODE_COMMANDE'] . '\',\'' . addslashes($row['CDE_LIBELLE']) . '\',\'' . addslashes($row['CODE_FOUR']) . '\',\'' . addslashes($row['FOUR_NOM']) . '\');">' . $row['CDE_LIBELLE'] . '</a></td> </tr>'; $i++; } } if ($ilang == '1' && $ilang != '') { if ($list == '') { $list = ' <tr class="tableOddRow"> <td height="22" align="left" valign="middle" class="text" colspan="4">Aucun produit disponible ...</td> </tr>'; } } if ($ilang == '2' && $ilang != '') { if ($list == '') { $list = ' <tr class="tableOddRow"> <td height="22" align="left" valign="middle" class="text" colspan="4">No data ...</td> </tr>'; } } if ($ilang == '3' && $ilang != '') { if ($list == '') { $list = ' <tr class="tableOddRow"> <td height="22" align="left" valign="middle" class="text" colspan="4">Nenhum dado ...</td> </tr>'; } } return $list; }
//Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data CDE_STATUT $_SESSION['DATA_DEC'] = array('xid' => $row['CODE_DECLASS'], 'exercice' => $row['ID_EXERCICE'], 'datedeclassement' => frFormat2($row['DCL_DATE']), 'refdeclassement' => $row['REF_DECLAS'], 'natdeclassement' => $row['CODENATDECLASS'], 'raison' => $row['LIBNATDECLASS'], 'libelle' => $row['DCL_LIBELLE'], 'cabinet' => $row['DCL_CABINET'], 'refrapport' => $row['DCL_REFRAPPORT'], 'datevalid' => frFormat($row['DCL_DATEVALID']), 'statut' => $row['DCL_VALIDE'], 'nbreLigne' => 0); //LIGNES PERTE $sql = "SELECT detdeclass.*, produit.CODE_PRODUIT, produit.PRD_LIBELLE FROM `detdeclass`\r\n\t\tINNER JOIN produit ON (produit.CODE_PRODUIT LIKE detdeclass.CODE_PRODUIT) WHERE CODE_DECLASS LIKE '" . addslashes($split[0]) . "'\r\n\t\tORDER BY ID_DETDECLASS ASC;"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_DEC']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_DEC']['ligne'], array('code_detdeclass' => $row['CODE_DETDECLASS'], 'monlot' => $row['DECL_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['DECL_QTE'], 'unite' => $row['DECL_UNITE'], 'prix' => $row['DECL_PA'], 'reflot' => $row['DECL_REFLOT'], 'dateperemp' => preg_replace('[-]', '/', frFormat2($row['DECL_DATEPEREMP'])))); } $_SESSION['DATA_DEC']['nbreLigne'] = $query->rowCount(); header('location:validdeclassement.php?selectedTab=bds&rs=3'); break; case 'annul': isset($_POST['xid']) ? $xid = $_POST['xid'] : ($xid = ''); isset($_POST['oldcode']) ? $oldcode = $_POST['oldcode'] : ($oldcode = ''); try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); }
// ENTREE $sortie = $bonsortie['QTE'] + $Declassement['QTE'] + $reportSortie['QTE'] + $transfetSort['QTE']; //SORTIE $ecart = $inventmoins['QTE'] + $inventplus['QTE']; $rest = $entree - $sortie + $ecart; if ($rest == 0) { $sql2 = "SELECT MAX(`MVT_DATE`) AS D_DATE from mouvement\r\n\t\t\t\t\tWHERE MVT_TYPE LIKE 'S' AND CODE_PRODUIT LIKE '" . addslashes($row['CODE_PRODUIT']) . "';"; $query2 = $cnx->prepare($sql2); //Prepare the SQL $query2->execute(); //Execute prepared SQL => $query $row2 = $query2->fetch(PDO::FETCH_ASSOC); isset($row2['D_DATE']) && $row2['D_DATE'] != '' ? $ddebut = $row2['D_DATE'] : ($ddebut = $_SESSION['GL_USER']['EXERCICE'] . '-01-01'); $j = NbJours($ddebut, date('Y-m-d')); // echo $ddebut, ' ', date('Y-m-d'), ' ',$j; array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'stocks' => $rest, 'unite' => $row['ID_UNITE'], 'date' => frFormat2($row2['D_DATE']), 'jour' => $j, 'semaine' => $j / 7, 'mois' => $j / 30)); $_SESSION['DATA_ETAT']['nbreLigne'] += 1; } } header('location:raprupture1.php?selectedTab=int'); break; case 'rapportmensuel': //Par produit $where = " mouvement.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND "; $whereAll = ""; isset($_POST['exercice']) && $_POST['exercice'] != '' ? $where .= "mouvement.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($where .= ""); isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $where .= "mouvement.MVT_DATE <= '" . addslashes(mysqlFormat(trim($_POST['datedebut']))) . "' AND " : ($where .= ""); $wherePeriode = " mouvement.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND "; isset($_POST['exercice']) && $_POST['exercice'] != '' ? $wherePeriode .= "mouvement.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($wherePeriode .= ""); isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $wherePeriode .= "mouvement.MVT_DATE > '" . addslashes(mysqlFormat(trim($_POST['datedebut']))) . "' AND " : ($wherePeriode .= ""); isset($_POST['datefin']) && $_POST['datefin'] != '' ? $wherePeriode .= "mouvement.MVT_DATE <= '" . addslashes(mysqlFormat(trim($_POST['datefin']))) . "' AND " : ($wherePeriode .= "");
$query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data CDE_STATUT $_SESSION['DATA_BDS'] = array('xid' => $row['CODE_BONSORTIE'], 'exercice' => $row['ID_EXERCICE'], 'datebonsortie' => frFormat2($row['SOR_DATE']), 'refbonsortie' => stripslashes($row['REF_BONSORTIE']), 'idbeneficiaire' => $row['CODE_BENEF'], 'beneficiaire' => stripslashes($row['BENEF_NOM']), 'libelle' => stripslashes($row['SOR_LIBELLE']), 'statut' => $row['SOR_VALIDE'], 'nbreLigne' => 0); //LIGNES $sql = "SELECT * FROM `detbonsortie` INNER JOIN produit ON (detbonsortie.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE CODE_BONSORTIE LIKE '" . addslashes($split[0]) . "' ORDER BY ID_DETBONSORTIE ASC;"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_BDS']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $dispo = ProduitsQte($row['CODE_PRODUIT'], $valid = 1, $type = 'E') - ProduitsQte($row['CODE_PRODUIT'], $valid = 1, $type = 'S'); array_push($_SESSION['DATA_BDS']['ligne'], array('code_detbonsortie' => $row['CODE_DETBONSORTIE'], 'monlot' => $row['BSPRD_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['BSPRD_QTE'], 'dispo' => $dispo, 'unite' => $row['BSPRD_UNITE'], 'magasin' => $row['CODE_MAGASIN'], 'prix' => $row['BSPRD_PV'], 'reflot' => $row['BSPRD_REFLOT'], 'dateperemp' => preg_replace('[-]', '/', frFormat2($row['BSPRD_DATEPEREMP'])))); } $_SESSION['DATA_BDS']['nbreLigne'] = $query->rowCount(); header('location:validbonsortie.php?selectedTab=bds&rst=1'); break; case 'delete': isset($_POST['rowSelection']) ? $id = $_POST['rowSelection'] : ($id = array()); try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } foreach ($id as $key => $val) {
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //COMMANDE $sql = "SELECT * FROM `livraison` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `ID_LIVRAISON` = '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data $_SESSION['DATA_LOT'] = array('xid' => $row['ID_LIVRAISON'], 'exercice' => $row['ID_EXERCICE'], 'datelivraison' => frFormat2($row['LVR_DATE']), 'commande' => $row['ID_COMMANDE'], 'codelivraison' => stripslashes($row['CODE_LIVRAISON']), 'statut' => $row['LVR_VALIDE'], 'nbreLigne' => 0); //LIGNES COMMANDE $sql = "SELECT * FROM `prd_livraison` INNER JOIN produit\r\n\t\tON (prd_livraison.CODE_PRODUIT LIKE produit.CODE_PRODUIT) WHERE ID_LIVRAISON = '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_LOT']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_LOT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['LVR_PRDQTE'], 'qtelvr' => $row['LVR_PRDRECU'], 'unite' => $row['LVR_UNITE'], 'mag' => $row['magasin'])); } $_SESSION['DATA_LOT']['nbreLigne'] = $query->rowCount(); header('location:validlivraison.php?selectedTab=bde&rst=1'); break; case 'delete':
$_SESSION['DATA_ETAT']['STOCK'] = $StockPrecedent; $sql = "SELECT * FROM mouvement INNER JOIN produit ON (mouvement.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\t\t {$whereAll} ORDER BY produit.PRD_LIBELLE, mouvement.ID_MOUVEMENT, mouvement.MVT_DATE ASC; "; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query while ($row = $query->fetch(PDO::FETCH_ASSOC)) { //echo 'Ent'.$entree.' Sort'.$sortie.'<br>'; if (isset($row['MVT_TYPE']) && $row['MVT_TYPE'] == 'E') { $StockPrecedent += $row['MVT_QUANTITE']; array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'reflot' => $row['MVT_REFLOT'], 'produit' => addslashes($row['PRD_LIBELLE']), 'nature' => $row['MVT_NATURE'], 'typemvt' => $row['MVT_TYPE'], 'qteentree' => $row['MVT_QUANTITE'], 'qtesortie' => 0, 'dateentree' => frFormat2($row['MVT_DATE']), 'dateperemp' => $row['MVT_DATEPEREMP'], 'pa' => $row['MVT_PA'], 'pv' => $row['MVT_PV'], 'unite' => $row['ID_UNITE'], 'stock' => $StockPrecedent, 'etat' => $row['MVT_VALID'])); $tEntree += $row['MVT_QUANTITE']; } if (isset($row['MVT_TYPE']) && $row['MVT_TYPE'] == 'S') { $StockPrecedent -= $row['MVT_QUANTITE']; array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'reflot' => $row['MVT_REFLOT'], 'produit' => addslashes($row['PRD_LIBELLE']), 'nature' => $row['MVT_NATURE'], 'typemvt' => $row['MVT_TYPE'], 'qteentree' => 0, 'qtesortie' => $row['MVT_QUANTITE'], 'dateentree' => frFormat2($row['MVT_DATE']), 'dateperemp' => $row['MVT_DATEPEREMP'], 'pa' => $row['MVT_PA'], 'pv' => $row['MVT_PV'], 'unite' => $row['ID_UNITE'], 'stock' => $StockPrecedent, 'etat' => $row['MVT_VALID'])); $tSortie += $row['MVT_QUANTITE']; } $_SESSION['DATA_ETAT']['PRODUIT'] = addslashes($row['PRD_LIBELLE']); } $_SESSION['DATA_ETAT']['nbreLigne'] = $query->rowCount(); $_SESSION['DATA_ETAT']['QTE_T_ENTREE'] = $tEntree; $_SESSION['DATA_ETAT']['QTE_T_SORTIE'] = $tSortie; //print_r($_SESSION['DATA_ETAT']); header('location:rapficheproduit1.php?selectedTab=rap'); break; case 'fillSousCatProduitFiche': $list = '<select name="produit[]" name="produit[]" class="formStyle" size="10" multiple="multiple">'; if (isset($_POST["souscategorie"])) { isset($_POST["souscategorie"]) && $_POST["souscategorie"] == 'TOUS' ? $where = '' : ($where = " WHERE produit.CODE_SOUSCATEGORIE ='" . $_POST["souscategorie"] . "'"); //SQL
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //COMMANDE $sql = "SELECT * FROM `commande` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `CODE_COMMANDE` LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data CDE_STATUT $_SESSION['DATA_CDE'] = array('xid' => $row['CODE_COMMANDE'], 'exercice' => $row['ID_EXERCICE'], 'datecommande' => frFormat2($row['CDE_DATE']), 'refcommande' => $row['REF_COMMANDE'], 'libellecde' => $row['CDE_LIBELLE'], 'fournisseur' => $row['CODE_FOUR'], 'statut' => $row['CDE_STATUT'], 'nbreLigne' => 0); //LIGNES COMMANDE $sql = "SELECT * FROM `prd_cde` INNER JOIN produit ON (prd_cde.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE CODE_COMMANDE LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_CDE']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_CDE']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['CDEPRD_QTE'], 'unite' => $row['CDEPRD_UNITE'], 'prix' => $row['CDEPRD_PA'])); } $_SESSION['DATA_CDE']['nbreLigne'] = $query->rowCount(); header('location:validcommande.php?selectedTab=bde&rs=3'); break; case 'delete':
$ligne = 6; for ($i = 1; $i <= $_SESSION['DATA_ETAT']['nbreLigne']; $i++) { isset($data[$i - 1]['codeproduit']) ? $codeproduit = $data[$i - 1]['codeproduit'] : ($codeproduit = ''); isset($data[$i - 1]['reflot']) ? $reflot = $data[$i - 1]['reflot'] : ($reflot = ''); isset($data[$i - 1]['produit']) ? $produit = $data[$i - 1]['produit'] : ($produit = ''); isset($data[$i - 1]['dateentree']) ? $dateentree = $data[$i - 1]['dateentree'] : ($dateentree = ''); isset($data[$i - 1]['dateperemp']) ? $dateperemp = $data[$i - 1]['dateperemp'] : ($dateperemp = ''); isset($data[$i - 1]['qte']) ? $qte = $data[$i - 1]['qte'] : ($qte = ''); isset($data[$i - 1]['unite']) ? $unite = $data[$i - 1]['unite'] : ($unite = ''); isset($data[$i - 1]['prix']) && $data[$i - 1]['prix'] > 0 ? $prix = $data[$i - 1]['prix'] : ($prix = 0); //($prix>0 ? $Aprix = number_format($prix,0,',', ' ') : $Aprix=''); $total = $prix * $qte; //($total>0 ? $Atotal = number_format($total,0,',', ' ') : $Atotal=''); //($qte>0 ? $Aqte = number_format($qte,0,',', ' ') : $Aqte=''); $dateperemp = frFormat2($dateperemp); $dateentree = frFormat2($dateentree); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $ligne, stripslashes($reflot))->setCellValue('B' . $ligne, stripslashes($codeproduit))->setCellValue('C' . $ligne, stripslashes($produit))->setCellValue('D' . $ligne, stripslashes($dateentree))->setCellValue('E' . $ligne, stripslashes($dateperemp))->setCellValue('F' . $ligne, stripslashes($qte))->setCellValue('G' . $ligne, stripslashes($unite)); $ligne++; } $fichier = '../download/Exp_RapportProduitPerime_' . date('YmdHis') . '.xlsx'; $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save($fichier); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META HTTP-EQUIV="refresh" CONTENT="" > <title><?php echo TITLE; ?>
try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } $sql = "SELECT reversement.*, programmation.CODE_MAGASIN FROM `reversement` INNER JOIN programmation ON (programmation.ID_PROGR=reversement.ID_PROGR) WHERE programmation.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `ID_REVERSEMENT` = '" . addslashes($id) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); $mnt = totalReversement($row['ID_PROGR'], $row['ID_EXERCICE']); $_SESSION['DATA_REV'] = array('xid' => $row['ID_REVERSEMENT'], 'exercice' => $row['ID_EXERCICE'], 'datereversement' => frFormat2($row['REV_DATE']), 'programmation' => $row['ID_PROGR'], 'mnttotal' => $row['REV_MNTTOTAL'], 'mntverse' => $row['REV_MNTVERSE'], 'quittance' => $row['REV_QUITTANCE'], 'mntregle' => $mnt, 'mntrestant' => $row['REV_MNTTOTAL'] - $mnt, 'statut' => $row['REV_VALID'], 'nbreLigne' => 0, 'ligne' => array()); $sql = "SELECT * FROM prg_bareme INNER JOIN bareme ON (bareme.ID_BAREME=prg_bareme.ID_BAREME) WHERE ID_PROGR= " . addslashes($row['ID_PROGR']); $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_REV']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_REV']['ligne'], array('codeproduit' => $row['ID_BAREME'], 'produit' => $row['BAR_LIBELLE'], 'unite' => $row['ID_UNITE'], 'prix' => $row['BAR_PRIX'], 'mixte' => $row['PRG_MIXTE'], 'ration1' => $row['PRG_RATION1'], 'ration2' => $row['PRG_RATION2'], 'qte1' => $row['PRG_QTE1'], 'qte2' => $row['PRG_QTE2'], 'nbreplat1' => $row['NBRE_PLAT1'], 'nbreplat2' => $row['NBRE_PLAT2'], 'reversement' => $row['PRG_REVERSEMENT'], 'mixte' => $row['BAR_MIXTE'])); } $_SESSION['DATA_REV']['nbreLigne'] = $query->rowCount(); header('location:validreversement.php?selectedTab=prg&rst=1'); break; case 'delete': isset($_POST['rowSelection']) ? $id = $_POST['rowSelection'] : ($id = array());
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //DECLASSEMENT $sql = "SELECT * FROM `recondit` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `ID_RECONDIT` = '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data CDE_STATUT $_SESSION['DATA_RECD'] = array('xid' => $row['ID_RECONDIT'], 'exercice' => $row['ID_EXERCICE'], 'datesortie' => frFormat2($row['REC_DATESORTIE']), 'dateentree' => frFormat2($row['REC_DATERETOUR']), 'codereconditionnement' => $row['CODE_RECOND'], 'raison' => $row['REC_RAISON'], 'statut' => $row['REC_VALIDE'], 'controleur' => $row['REC_CONTROLEUR'], 'libelle' => $row['REC_LIBELLE'], 'nbreLigne' => 0, 'ligne' => array()); //LIGNES RECONDITIONNEMENT $sql = "SELECT * FROM `prd_recond` INNER JOIN produit ON (prd_recond.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE ID_RECONDIT = '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_RECD']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_RECD']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'cause' => $row['PRDREC_CAUSE'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['PRDREC_QTES'], 'qtelivr' => $row['PRDREC_QTEE'], 'typeemballage' => $row['PRDREC_TYPEEMB'], 'colissage' => $row['PRDREC_COLISSAGE'], 'unite' => $row['PRDREC_UNITES'])); } $_SESSION['DATA_RECD']['nbreLigne'] = $query->rowCount(); header('location:validreconditionnement.php?selectedTab=bds&rst=1'); break; case 'annul':
header("location:accessinterdit.php?selectedTab=home"); } require_once '../lib/phpfuncLib.php'; //All commun functions require_once 'menus.php'; require_once 'funclocalite.php'; $droit = getDroit('GRP_PERSONNEL ,GRP_UTILISATEUR, GRP_GROUPE, GRP_LOG, GRP_CATEGORIE, GRP_PRODUIT, GRP_CONDITIONNEMENT, GRP_UNITE, GRP_BAREME, GRP_REGION, GRP_PROVINCE, GRP_TYPESERVICE, GRP_SERVICE, GRP_MAGASIN, GRP_RESPONSABLE, GRP_FOURNISSEUR, GRP_TYPEBENEFICIAIRE, GRP_BENEFICIAIRE, GRP_AFFECTATION, GRP_DONNANNUELLE, GRP_EXERCICE, GRP_TYPEDOTATION, GRP_PARAMETRE, GRP_DB', $_SESSION['GL_USER']['GROUPE']); $droitTOPMENUS = getDroitTOPMENUS($_SESSION['GL_USER']['GROUPE']); $droitMAJ = getDroitMAJ('GRP_LOCALITE', $_SESSION['GL_USER']['GROUPE']); isset($_SESSION['DATA_REP']['ID_RESPO']) ? $idresp = $_SESSION['DATA_REP']['ID_RESPO'] : ($idresp = ''); isset($_SESSION['DATA_REP']['NUM_MLLE']) ? $personnel = $_SESSION['DATA_REP']['NUM_MLLE'] : ($personnel = ''); isset($_SESSION['DATA_REP']['CODE_MAGASIN']) ? $magasin = $_SESSION['DATA_REP']['CODE_MAGASIN'] : ($magasin = ''); isset($_SESSION['DATA_REP']['RES_DATEDEBUT']) ? $datedebut = $_SESSION['DATA_REP']['RES_DATEDEBUT'] : ($datedebut = ''); isset($_SESSION['DATA_REP']['RES_DATEFIN']) ? $datefin = $_SESSION['DATA_REP']['RES_DATEFIN'] : ($datefin = ''); $datedebut = frFormat2($datedebut); $datefin = frFormat2($datefin); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META HTTP-EQUIV="refresh" CONTENT="" > <title><?php echo TITLE; ?> </title> <LINK REL="SHORTCUT ICON" HREF="../images/favicon0.ico"> <link href="../css/neutralcss.css" rel="stylesheet" type="text/css"> <link href="../lib/JQuerySpinBtn.css" rel="stylesheet" type="text/css"> <link href="../lib/jquery.alerts.css" rel="stylesheet" type="text/css"> <!-- Begin of JS code -->
//Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //DECLASSEMENT $sql = "SELECT * FROM `recondit` WHERE `ID_RECONDIT` = '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data CDE_STATUT //Data CDE_STATUT $_SESSION['DATA_RECD'] = array('xid' => $row['ID_RECONDIT'], 'exercice' => $row['ID_EXERCICE'], 'datesortie' => frFormat2($row['REC_DATESORTIE']), 'codereconditionnement' => $row['CODE_RECOND'], 'raison' => $row['REC_RAISON'], 'statut' => $row['REC_VALIDE'], 'nbreLigne' => $nbreLigne, 'ligne' => array()); //LIGNES RECONDITIONNEMENT SORTIE $sql = "SELECT * FROM `recond_sorte` WHERE ID_RECONDIT = '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_RECD']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_RECD']['ligne'], array('codeproduit' => $row['ID_CONDIT'], 'produit' => getConditionnement($row['ID_CONDIT']), 'qte' => $row['CNDREC_QTES'], 'unite' => $row['CNDREC_UNITES'])); } $_SESSION['DATA_RECD']['nbreLigne'] = $query->rowCount(); header('location:validreconditionnements.php?selectedTab=mvt&rst=1'); break; case 'delete':
function ligneEtatrapmvtdestinaire($nbre = 1, $data = array()) { $ret = ''; for ($i = 1; $i <= $nbre; $i++) { isset($data[$i - 1]['reflot']) ? $reflot = $data[$i - 1]['reflot'] : ($reflot = ''); isset($data[$i - 1]['codeproduit']) ? $codeproduit = $data[$i - 1]['codeproduit'] : ($codeproduit = ''); isset($data[$i - 1]['produit']) ? $produit = $data[$i - 1]['produit'] : ($produit = ''); isset($data[$i - 1]['dateperemp']) ? $dateperemp = $data[$i - 1]['dateperemp'] : ($dateperemp = ''); isset($data[$i - 1]['datesortie']) ? $datesortie = $data[$i - 1]['datesortie'] : ($datesortie = ''); isset($data[$i - 1]['qte']) && $data[$i - 1]['qte'] != 0 ? $qte = number_format($data[$i - 1]['qte'], 0, '', ' ') : ($qte = ''); $d = preg_replace('/-/', '/', $dateperemp); $d = substr($d, 0, 7); $col = ''; $ret .= ' <tr align="left" valign="middle" class="' . $col . '"> <td class="botBorderTdall" align="center" nowrap>' . $i . ' - </td> <td class="botBorderTdall" align="left">' . stripslashes($reflot) . ' </td> <td class="botBorderTdall" align="left" >' . stripslashes($codeproduit) . ' </td> <td class="botBorderTdall" align="left" >' . stripslashes($produit) . ' </td> <td class="botBorderTdall" align="center" >' . frFormat2($datesortie) . ' </td> <td class="botBorderTdall" align="right" >' . stripslashes($qte) . ' </td> <td class="botBorderTdall" align="center">' . stripslashes($d) . ' </td> </tr>'; } return $ret; }
//Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data $_SESSION['DATA_LVR'] = array('xid' => $row['CODE_LIVRAISON'], 'exercice' => $row['ID_EXERCICE'], 'datelivraison' => frFormat2($row['LVR_DATE']), 'reflivraison' => stripslashes($row['REF_LIVRAISON']), 'commande' => stripslashes($row['CODE_COMMANDE']), 'libcommande' => getField('CODE_COMMANDE', $row['CODE_COMMANDE'], 'CDE_LIBELLE', 'commande'), 'fournisseur' => getField('CODE_FOUR', $row['CODE_FOUR'], 'FOUR_NOM', 'fournisseur'), 'idfournisseur' => $row['CODE_FOUR'], 'libelle' => stripslashes($row['LVR_LIBELLE']), 'statut' => $row['LVR_VALIDE'], 'nbreLigne' => 0); //LIGNES COMMANDE $sql = "SELECT * FROM `detlivraison` INNER JOIN produit\r\n\t\tON (detlivraison.CODE_PRODUIT LIKE produit.CODE_PRODUIT) WHERE CODE_LIVRAISON = '" . addslashes($split[0]) . "' ORDER BY detlivraison.ID_DETLIVRAISON ASC"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_LVR']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_LVR']['ligne'], array('code_detlivraison' => $row['CODE_DETLIVRAISON'], 'code_detlivraison' => $row['ID_DETLIVRAISON'], 'monlot' => $row['LVR_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['LVR_PRDQTE'], 'qtelvr' => $row['LVR_PRDRECU'], 'unite' => $row['LVR_UNITE'], 'mag' => $row['LVR_MAGASIN'], 'prix' => $row['LVR_PA'], 'reflot' => $row['LVR_REFLOT'], 'dateperemp' => preg_replace('[-]', '/', frFormat2($row['LVR_DATEPEREMP'])))); } $_SESSION['DATA_LVR']['nbreLigne'] = $query->rowCount(); if ($_SESSION['DATA_LVR']['commande'] != '') { header('location:validlivraison1.php?selectedTab=bde&rs=3'); } else { header('location:validlivraison2.php?selectedTab=bde&rs=3'); } break; case 'delete': isset($_POST['rowSelection']) ? $id = $_POST['rowSelection'] : ($id = array()); try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error
function ligneConlot($wh = '', $ord = '', $sens = 'ASC', $page = 1, $nelt) { $returnHTML = ''; $returnTble = array(); //HTML, nbreTotal, //Where clause $where = ''; isset($wh) and $wh != '' ? $where = " WHERE {$wh} " : ($where = ""); //Oerder condition $order = ''; isset($ord) and $ord != '' ? $order = " ORDER BY {$ord} {$sens}" : ($order = " ORDER BY livraison.LVR_DATE DESC"); //Nombre d'éléments $returnTble['NE'] = nombreDetLivraison($where); if ($returnTble['NE'] > 0) { //Calcule des limites $i = ($page - 1) * $nelt; $sql = "SELECT * FROM prd_livraison\r\n\t\tINNER JOIN livraison ON (prd_livraison.ID_LIVRAISON=livraison.ID_LIVRAISON)\r\n\t\tINNER JOIN produit ON (prd_livraison.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\t{$where} {$order} LIMIT {$i}, {$nelt};"; //Exécution try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $i = 0; $j = 6; while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $i % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow"); if ($row['LVRLOT_VALIDE'] == '0') { $imgCl = '<img src="../images/encours.gif" title="En cours" width="16" height="16">'; } elseif ($row['LVRLOT_VALIDE'] == '2') { $imgCl = '<img src="../images/cancel.png" title="Annulée" width="16" height="16">'; } else { $imgCl = '<img src="../images/valider.gif" title="Validée" width="16" height="16">'; } $i++; $returnHTML .= ' <tr align="left" valign="middle" class="' . $col . '"> <td class="text" align="center">' . $i . '</td> <td><input type="checkbox" name="rowSelection[]" value="' . $row['ID_LIVRAISON'] . '@' . $row['LVRLOT_VALIDE'] . '@' . $j . '" onClick="IsValider(' . $row['LVRLOT_VALIDE'] . ',' . $j . ');"></td> <td class="text" align="center">' . $imgCl . '</td> <td class="text">' . stripslashes($row['CODE_LIVRAISON']) . ' </td> <td class="text" >' . stripslashes($row['CODE_PRODUIT']) . ' </td> <td class="text" >' . stripslashes($row['PRD_LIBELLE']) . ' </td> <td class="text" > </td> <td class="text" > </td> <td class="text" align="center">' . stripslashes($row['LVR_PRDRECU'] . ' ' . $row['LVR_UNITE']) . ' </td> <td class="text" align="center" nowrap="nowrap"><a href="dlot.php?do=detail&xid=' . $row['ID_LIVRAISON'] . '&codeprd=' . $row['CODE_PRODUIT'] . '" class="morelink">' . stripslashes('Détails lot') . '</a></td> </tr>'; $sql3 = "SELECT * FROM lot\r\n\t\t\tINNER JOIN livraison ON (livraison.ID_LIVRAISON=lot.ID_LIVRAISON)\r\n\t\t\tINNER JOIN produit ON (lot.CODE_PRODUIT LIKE produit.CODE_PRODUIT) WHERE lot.ID_LIVRAISON=" . $row['ID_LIVRAISON']; $query = $cnx->prepare($sql3); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $k = 1; while ($row3 = $query->fetch(PDO::FETCH_ASSOC)) { $k % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow"); $returnHTML .= ' <tr align="left" valign="middle" class="' . $col . '"> <td class="text" align="center">' . $k . '</td> <td class="text" align="center" colspan="3"> </td> <td class="text" >' . stripslashes($row3['CODE_PRODUIT']) . ' </td> <td class="text" >' . stripslashes($row3['PRD_LIBELLE']) . ' </td> <td class="text" align="center" >' . stripslashes($row3['REF_LOT']) . ' </td> <td class="text" align="center" >' . stripslashes(frFormat2($row3['DATE_PEREMPTION'])) . ' </td> <td class="text" align="center">' . stripslashes($row3['LOT_PRDQTE'] . ' ' . $row3['LOT_UNITE']) . ' </td> <td class="text" > </td> </tr>'; $k++; } $j++; } } else { $returnHTML .= '<tr><td colspan="4" class="text">Aucune donnée</td></tr>'; } $returnTble['L'] = $returnHTML; return $returnTble; }
//Top Menu $selectedTab = $_GET['selectedTab']; $menu = topMenus($selectedTab, $_SESSION['GL_USER']['DROIT']); //Left Menu $leftMenu = parametersMenus($selectedTab, $_SESSION['GL_USER']['DROIT']); //DOIT MAJ $droitMAJ = $_SESSION['GL_USER']['DROIT']['par_bud']; isset($_SESSION['DATA_EX']['ID_EXERCICE']) ? $codeexercice = $_SESSION['DATA_EX']['ID_EXERCICE'] : ($codeexercice = ''); isset($_SESSION['DATA_EX']['EX_LIBELLE']) ? $exercice = $_SESSION['DATA_EX']['EX_LIBELLE'] : ($exercice = ''); isset($_SESSION['DATA_EX']['EX_DATEDEBUT']) ? $datedebut = $_SESSION['DATA_EX']['EX_DATEDEBUT'] : ($datedebut = ''); isset($_SESSION['DATA_EX']['EX_DATEFIN']) ? $datefin = $_SESSION['DATA_EX']['EX_DATEFIN'] : ($datefin = ''); isset($_SESSION['DATA_EX']['EX_CLOTURE']) ? $cloture = $_SESSION['DATA_EX']['EX_CLOTURE'] : ($cloture = ''); isset($_SESSION['DATA_EX']['EX_DATECLOTURE']) ? $datecloture = $_SESSION['DATA_EX']['EX_DATECLOTURE'] : ($datecloture = ''); $datefin != '0000-00-00' ? $datedebut = frFormat2($datedebut) : ($datedebut = ''); $datefin != '0000-00-00' ? $datefin = frFormat2($datefin) : ($datefin = ''); $datefin != '0000-00-00' ? $datecloture = frFormat2($datecloture) : ($datecloture = ''); $cloture == 1 ? $checked = 'checked="checked"' : ($checked = ''); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META HTTP-EQUIV="refresh" CONTENT="" > <title><?php echo TITLE; ?> </title> <LINK REL="SHORTCUT ICON" HREF="../images/favicon0.ico"> <link href="../css/neutralcss.css" rel="stylesheet" type="text/css"> <link href="../lib/JQuerySpinBtn.css" rel="stylesheet" type="text/css"> <link href="../lib/jquery.alerts.css" rel="stylesheet" type="text/css">
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //REPORT $sql = "SELECT * FROM `report` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `CODE_REPORT` LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data $_SESSION['DATA_REP'] = array('xid' => $row['CODE_REPORT'], 'exercice' => $row['ID_EXERCICE'], 'datereport' => frFormat2($row['REP_DATE']), 'statut' => $row['REP_VALIDE'], 'nbreLigne' => 0, 'ligne' => array()); //LIGNES REPORT $sql = "SELECT detreport.*, produit.CND_LIBELLE FROM `detreport` INNER JOIN produit ON (detreport.CODE_PRODUIT =produit.CODE_PRODUIT)\r\n\t\tWHERE CODE_REPORT LIKE '" . addslashes($id) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_REP']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_REP']['ligne'], array('code_detreport' => $row['CODE_DETREPORT'], 'monlot' => $row['REP_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'stocks' => $row['REP_PRDQTE'], 'unite' => $row['REP_UNITE'], 'prix' => $row['REP_PA'], 'reflot' => $row['REP_REFLOT'], 'dateperemp' => $row['REP_DATEPEREMP'])); } $_SESSION['DATA_REP']['nbreLigne'] = $query->rowCount(); header('location:validreport.php?selectedTab=bds&rst=1'); break; case 'delete':
function ligneEtatListeInventarie($wh = '', $ord = '', $sens = 'ASC') { $returnHTML = ''; //Where clause $where = ''; isset($wh) and $wh != '' ? $where = " WHERE {$wh} " : ($where = ""); //Oerder condition $order = ''; isset($ord) and $ord != '' ? $order = " ORDER BY {$ord} {$sens}" : ($order = " ORDER BY INV_DATE DESC"); //Nombre d'éléments $nbre = nombreInventaire($where); if ($nbre > 0) { $sql = "SELECT * FROM inventaire {$where} {$order};"; //Exécution try { $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $i = 1; while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $row['INV_VALID'] == '0' ? $imgCl = '<img src="../images/encours.gif" title="En cours" width="16" height="16">' : ($imgCl = '<img src="../images/valider.gif" title="Validée" width="16" height="16">'); $returnHTML .= ' <tr align="left" valign="middle"> <td class="botBorderTdall" align="center">' . $i . '</td> <td class="botBorderTdall" align="center">' . $imgCl . '</td> <td height="22" class="botBorderTdall">' . stripslashes($row['CODE_INVENTAIRE']) . ' </td> <td class="botBorderTdall" >' . stripslashes(frFormat2($row['INV_DATE'])) . ' </td> <td class="botBorderTdall" >' . stripslashes($row['INV_LIBELLE']) . ' </td> </tr>'; $i++; } } else { $returnHTML .= '<tr><td colspan="4" class="text">Aucune donnée</td></tr>'; } return $returnHTML; }
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //INVENTAIRE $sql = "SELECT * FROM `inventaire` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "'\r\n\t\tAND `CODE_INVENTAIRE` LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data $_SESSION['DATA_INV'] = array('xid' => $row['CODE_INVENTAIRE'], 'exercice' => $row['ID_EXERCICE'], 'refinventaire' => $row['REF_INVENTAIRE'], 'dateinventaire' => frFormat2($row['INV_DATE']), 'inventaire' => $row['INV_LIBELLE'], 'statut' => $row['INV_VALID'], 'nbreLigne' => 0, 'ligne' => array()); //LIGNES INVENTAIRE $sql = "SELECT * FROM `detinventaire` INNER JOIN produit ON (detinventaire.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE CODE_INVENTAIRE LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_INV']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_INV']['ligne'], array('code_detinventaire' => $row['CODE_DETINVENTAIRE'], 'monlot' => $row['INV_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qteentre' => '', 'qtesortie' => '', 'stockst' => $row['STOCK_THEO'], 'stocksp' => $row['STOCK_PHYSIQUE'], 'unite' => $row['INV_UNITE'], 'prix' => $row['INV_PA'], 'reflot' => $row['INV_REFLOT'], 'dateperemp' => $row['INV_DATEPEREMP'])); } $_SESSION['DATA_INV']['nbreLigne'] = $query->rowCount(); header('location:validinventaire.php?selectedTab=int&rs=3'); break; case 'delete':
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); //Connexion to database } catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); header('location:errorPage.php'); } //TRANSFERT $sql = "SELECT * FROM `transfert` WHERE (CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "') AND `CODE_TRANSFERT` LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); //Data CDE_STATUT $_SESSION['DATA_TRS'] = array('xid' => $row['CODE_TRANSFERT'], 'exercice' => $row['ID_EXERCICE'], 'datetransfert' => frFormat2($row['TRS_DATE']), 'reftransfert' => $row['REF_TRANSFERT'], 'magasin' => $row['CODE_MAGASIN'], 'magasin_srce' => $row['MAG_CODE_MAGASIN_SRCE'], 'magasin_dest' => $row['MAG_CODE_MAGASIN_DEST'], 'libelleetat' => $row['TRS_LIBELLE'], 'nature' => $row['TRS_NATURE'], 'statut' => $row['TRS_VALIDE'], 'nbreLigne' => 0); //LIGNES TRANSFERT $sql = "SELECT * FROM `dettransfert` INNER JOIN produit ON (produit.CODE_PRODUIT LIKE dettransfert.CODE_PRODUIT)\r\n\t\tWHERE CODE_TRANSFERT LIKE '" . addslashes($split[0]) . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query //Ligne $_SESSION['DATA_TRS']['ligne'] = array(); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { array_push($_SESSION['DATA_TRS']['ligne'], array('code_dettransfert' => $row['CODE_DETTRANSFERT'], 'monlot' => $row['TRS_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => $row['PRD_LIBELLE'], 'qte' => $row['TRS_PRDQTE'], 'prix' => $row['TRS_PV'], 'unite' => $row['TRS_UNITE'], 'reflot' => $row['TRS_REFLOT'], 'dateperemp' => $row['TRS_DATEPEREMP'])); } $_SESSION['DATA_TRS']['nbreLigne'] = $query->rowCount(); if ($_SESSION['DATA_TRS']['nature'] == 1) { header('location:validtransfert1.php?selectedTab=bds&rs=3'); } elseif ($_SESSION['DATA_TRS']['nature'] == 2) {
} catch (PDOException $error) { //Treat error //("Erreur de connexion : " . $error->getMessage() ); die($error->getMessage() . ' ' . __LINE__); } $sql = "SELECT * FROM `exercice` WHERE `ID_EXERCICE` = '" . $exercice . "'"; $query = $cnx->prepare($sql); //Prepare the SQL $query->execute(); //Execute prepared SQL => $query $row = $query->fetch(PDO::FETCH_ASSOC); $_SESSION['GL_USER']['EXERCICE'] = $exercice; $_SESSION['GL_USER']['EX_LIBELLE'] = $row['EX_LIBELLE']; $_SESSION['GL_USER']['STATUT_EXERCICE'] = $row['EX_CLOTURE']; $_SESSION['GL_USER']['DEBUT_EXERCICE'] = frFormat2($row['EX_DATEDEBUT']); $_SESSION['GL_USER']['FIN_EXERCICE'] = frFormat2($row['EX_DATEFIN']); $olcantine = $_SESSION['GL_USER']['MAGASIN']; $_SESSION['GL_USER']['PROVINCE'] = $province; $_SESSION['GL_USER']['MAGASIN'] = $cantine; updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], 'Changement de l\'exercice budgétaire (' . $olexercice . ', ' . $exercice . ' / ' . $olcantine . ', ' . $cantine . ')'); //updateLog($username, $idcust, $action='' ) header('location:home.php?selectedTab=home'); } else { updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], 'Changement de l\'exercice budgétaire a entrainé une déconnexion'); //updateLog($username, $idcust, $action='' ) header('location:dbuser.php?do=logout'); } break; case 'fillService': $list = '<option value="0"></option>'; if (isset($_POST["province"]) && $_POST["province"] != '0') {
require_once 'functypedotation.php'; $INFO = getInfoGenerale($_SESSION['GL_USER']['MAGASIN']); $nommag = getField('CODE_MAGASIN', $_SESSION['GL_USER']['MAGASIN'], 'SER_NOM', 'magasin'); isset($INFO['ID']) ? $id = $INFO['ID'] : ($id = ''); isset($INFO['INF_CLIENT']) ? $client = $INFO['INF_CLIENT'] : ($client = ''); isset($INFO['INF_DATEACQ']) ? $dateacq = $INFO['INF_DATEACQ'] : ($dateacq = ''); isset($INFO['INF_LICENCE']) ? $licence = $INFO['INF_LICENCE'] : ($licence = ''); isset($INFO['INF_MINISTERE']) && $INFO['INF_MINISTERE'] != '' ? $ministere = $INFO['INF_MINISTERE'] : ($ministere = ''); isset($INFO['INF_SECRETARIAT']) && $INFO['INF_SECRETARIAT'] != '' ? $secretariat = '<div align="center">-----------------</div>' . $INFO['INF_SECRETARIAT'] : ($secretariat = ''); isset($INFO['INF_DIRECTION']) && $INFO['INF_DIRECTION'] != '' ? $direction = '<div align="center">-----------------</div>' . $INFO['INF_DIRECTION'] : ($direction = ''); isset($INFO['INF_SERVICE']) && $INFO['INF_SERVICE'] != '' ? $service = '<div align="center">-----------------</div>' . $INFO['INF_SERVICE'] : ($service = ''); isset($INFO['INF_CSPS']) && $INFO['INF_CSPS'] != '' ? $csps = '<div align="center">-----------------</div>' . $INFO['INF_CSPS'] : ($csps = ''); isset($INFO['INF_PAYS']) ? $pays = $INFO['INF_PAYS'] : ($pays = ''); isset($INFO['INF_VILLE']) ? $ville = $INFO['INF_VILLE'] : ($ville = ''); isset($INFO['INF_DEVISE']) ? $devise = $INFO['INF_DEVISE'] : ($devise = ''); $dateacq == '0000-00-00' ? $dateacq = '' : ($dateacq = frFormat2($dateacq)); $libellecde = 'Liste des types de dotation'; //Ligne if (isset($_SESSION['WHERE']) && $_SESSION['WHERE'] != '') { $ligne = ligneEtatTypeDotation($_SESSION['WHERE']); } else { $ligne = ligneEtatTypeDotation('', '', ''); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META HTTP-EQUIV="refresh" CONTENT="" > <title><?php echo TITLE;
//$objPHPExcel->getActiveSheet()->getStyle('N'.$ligne)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK); //$objPHPExcel->getActiveSheet()->getStyle('O'.$ligne)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK); $ligne = 6; for ($i = 1; $i <= $_SESSION['DATA_ETAT']['nbreLigne']; $i++) { isset($data[$i - 1]['reflot']) ? $reflot = $data[$i - 1]['reflot'] : ($reflot = ''); isset($data[$i - 1]['codeproduit']) ? $codeproduit = $data[$i - 1]['codeproduit'] : ($codeproduit = ''); isset($data[$i - 1]['produit']) ? $produit = $data[$i - 1]['produit'] : ($produit = ''); isset($data[$i - 1]['datesortie']) ? $datesortie = $data[$i - 1]['datesortie'] : ($datesortie = ''); isset($data[$i - 1]['nature']) ? $nature = $data[$i - 1]['nature'] : ($nature = ''); isset($data[$i - 1]['datevalid']) ? $datevalid = $data[$i - 1]['datevalid'] : ($datevalid = ''); isset($data[$i - 1]['dateperemp']) ? $dateperemp = $data[$i - 1]['dateperemp'] : ($dateperemp = ''); isset($data[$i - 1]['qte']) ? $qte = $data[$i - 1]['qte'] : ($qte = ''); isset($data[$i - 1]['unite']) ? $unite = $data[$i - 1]['unite'] : ($unite = ''); $datesortie = frFormat2($datesortie); $datevalid = frFormat2($datevalid); $dateperemp = frFormat2($dateperemp); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $ligne, stripslashes($reflot))->setCellValue('B' . $ligne, stripslashes($codeproduit))->setCellValue('C' . $ligne, stripslashes($produit))->setCellValue('D' . $ligne, stripslashes($nature))->setCellValue('E' . $ligne, stripslashes($datevalid))->setCellValue('F' . $ligne, stripslashes($datesortie))->setCellValue('G' . $ligne, stripslashes($qte))->setCellValue('H' . $ligne, stripslashes($dateperemp))->setCellValue('I' . $ligne, stripslashes($unite)); $ligne++; } $fichier = '../download/Exp_RapportMouvementDest_' . date('YmdHis') . '.xlsx'; $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save($fichier); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META HTTP-EQUIV="refresh" CONTENT="" > <title><?php echo TITLE; ?>