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;
?>
