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)); isset($INFO['INF_SIGNATEUR1']) ? $magasinier = $INFO['INF_SIGNATEUR1'] : ($magasinier = ''); isset($INFO['INF_SIGNATEUR2']) ? $chef = $INFO['INF_SIGNATEUR2'] : ($chef = ''); isset($INFO['INF_NOMSIGNATEUR2']) ? $nomchef = $INFO['INF_NOMSIGNATEUR2'] : ($nomchef = ''); isset($INFO['INF_NOMSIGNATEUR3']) ? $directeur = $INFO['INF_SIGNATEUR3'] : ($directeur = ''); isset($INFO['INF_NOMSIGNATEUR3']) ? $nomdirecteur = $INFO['INF_NOMSIGNATEUR3'] : ($nomdirecteur = ''); isset($INFO['INF_SIGNATEUR3']) ? $gestionnaire = $INFO['INF_SIGNATEUR3'] : ($gestionnaire = ''); isset($INFO['INF_SIGNATEUR4']) ? $daf = $INFO['INF_SIGNATEUR4'] : ($daf = ''); isset($_SESSION['DATA_TRS']['exercice']) ? $exercice = $_SESSION['DATA_TRS']['exercice'] : ($exercice = ''); isset($_SESSION['DATA_TRS']['nbreLigne']) ? $nbreLigne = $_SESSION['DATA_TRS']['nbreLigne'] : ($nbreLigne = ''); isset($_SESSION['DATA_TRS']['service_srce']) ? $serviceemetteur = getService($_SESSION['DATA_TRS']['service_srce']) : ($serviceemetteur = ''); isset($_SESSION['DATA_TRS']['magasin_srce']) ? $magsource = getmagasinName($_SESSION['DATA_TRS']['magasin_srce']) : ($magsource = ''); isset($_SESSION['DATA_TRS']['magasin_dest']) ? $magdest = getmagasinName($_SESSION['DATA_TRS']['magasin_dest']) : ($magdest = ''); isset($_SESSION['DATA_TRS']['libelleetat']) && $_SESSION['DATA_TRS']['libelleetat'] != '' ? $libelle = $_SESSION['DATA_TRS']['libelleetat'] : ($libelle = $libel . ' : ' . $magsource . ' -> ' . $magdest); isset($_SESSION['DATA_TRS']['codetransfert']) ? $code = $_SESSION['DATA_TRS']['codetransfert'] : ($code = ''); isset($_SESSION['DATA_TRS']['datetransfert']) ? $date = $_SESSION['DATA_TRS']['datetransfert'] : ($date = ''); isset($_SESSION['DATA_TRS']['camion']) ? $camion = $_SESSION['DATA_TRS']['camion'] : ($camion = ''); isset($_SESSION['DATA_TRS']['ligne']) ? $data = $_SESSION['DATA_TRS']['ligne'] : ($data = array()); //Ligne $ligne = ligneEtatTransfert($nbreLigne, $data); ?> <!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;
function ligneEtatListeTransfert($wh = '', $ord = '')
{
$userName = getField('LOGIN', $_SESSION['GL_USER']['LOGIN'], 'LOGIN', 'compte');
$ilang = getCodelangue($userName);
$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 TRS_DATE DESC");
//Nombre d'éléments
$nbre = nombreTransfert($where);
if ($nbre > 0) {
//Calcule des limites
$sql = "SELECT * FROM transfert {$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;
$tranfert = array(1 => 'Transfert sortant', 2 => 'Transfert entrant');
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
//($i%2 == 0 ? $col = "tableOddRow" : $col = "tableEvenRow");
$d1 = frFormat($row['TRS_DATE']);
//Return $ret = array(); // DFR, TFR
if ($row['TRS_VALIDE'] == '0') {
$imgCl = '<img src="../images/encours.gif" title="En cours" width="16" height="16">';
} elseif ($row['TRS_VALIDE'] == '2') {
$imgCl = '<img src="../images/cancel.png" title="Annulé" width="16" height="16">';
} else {
$imgCl = '<img src="../images/valider.gif" title="Validé" width="16" height="16">';
}
$t = $row['TRS_NATURE'];
$returnHTML .= '
<tr align="left" valign="middle">
<td class="botBorderTdall" align="center">' . $i . '</td>
<td class="botBorderTdall">' . stripslashes($row['CODE_TRANSFERT']) . ' </td>
<td class="botBorderTdall">' . stripslashes($d1['DFR']) . ' </td>
<td class="botBorderTdall">' . stripslashes($tranfert[$t]) . ' </td>
<td class="botBorderTdall">' . stripslashes(getmagasinName($row['MAG_CODE_MAGASIN_SRCE'])) . ' </td>
<td class="botBorderTdall">' . stripslashes(getmagasinName($row['MAG_CODE_MAGASIN_DEST'])) . ' </td>
</tr>';
$i++;
}
} else {
if ($ilang == '1' && $ilang != '') {
$returnHTML .= '<tr><td colspan="4" class="text">Aucune donnée...</td></tr>';
}
if ($ilang == '2' && $ilang != '') {
$returnHTML .= '<tr><td colspan="4" class="text">No data...</td></tr>';
}
if ($ilang == '3' && $ilang != '') {
$returnHTML .= '<tr><td colspan="4" class="text">Nenhum dado...</td></tr>';
}
}
return $returnHTML;
}
