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