function listeDesvilles($defaut = '')
{
isset($defaut) ? $where = " AND LOC_NOM LIKE '{$defaut}%'" : ($where = "");
$sql = "SELECT * FROM localite INNER JOIN groupelocalite ON (localite.ID_GRPLOC LIKE groupelocalite.ID_GRPLOC)\r\n\tWHERE localite.ID_GRPLOC='VL' {$where} ORDER BY GRPLOC_LIBELLE,LOC_NOM ASC;";
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
$list = '';
$i = 0;
$categorie = "";
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$i % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow");
$list .= '<tr class="' . $col . '">
<td align="center" valign="middle" class="text"><a href="#" onClick="pickUp(\'' . $row['ID_LOCALITE'] . '\',\'' . addslashes($row['LOC_NOM']) . '\');">' . $row['ID_LOCALITE'] . '</a></td>
<td class="text" ><a href="#" onClick="pickUp(\'' . $row['ID_LOCALITE'] . '\',\'' . addslashes($row['LOC_NOM']) . '\');">' . $row['LOC_NOM'] . '</a></td>
<td align="left" valign="middle" class="text" ><a href="#" onClick="pickUp(\'' . $row['ID_LOCALITE'] . '\',\'' . addslashes($row['LOC_NOM']) . '\');">' . $row['GRPLOC_LIBELLE'] . '</a></td>
<td width="10%" align="left" valign="middle" class="text" ><a href="#" onClick="pickUp(\'' . $row['ID_LOCALITE'] . '\',\'' . addslashes($row['LOC_NOM']) . '\');">' . getDependance($row['LOC_LIEN']) . '</a></td>
</tr>';
$i++;
}
if ($list == '') {
$list = '
<tr class="tableOddRow">
<td height="22" align="left" valign="middle" class="text" colspan="4">Aucun article disponible ...</td>
</tr>';
}
return $list;
}
function ligneConLocalite($wh = '', $ord = '', $sens = 'ASC', $page = 1, $nelt)
{
$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 localite.ID_GRPLOC, ID_LOCALITE ASC");
//Nombre d'éléments
$returnTble['NE'] = nombreLocalite($where);
if ($returnTble['NE'] > 0) {
//Calcule des limites
$i = ($page - 1) * $nelt;
$sql = "SELECT * FROM localite INNER JOIN groupelocalite ON (localite.ID_GRPLOC LIKE groupelocalite.ID_GRPLOC) {$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");
//Is use
$magasin = isUseNow('ID_LOCALITE', 'magasin', "WHERE ID_LOCALITE =" . $row['ID_LOCALITE']);
$magasin > 0 ? $Use = 1 : ($Use = 0);
$returnHTML .= '
<tr align="left" valign="middle" class="' . $col . '">
<td><input type="checkbox" name="rowSelection[]" value="' . $row['ID_LOCALITE'] . ' ' . $Use . '"></td>
<td class="text" align="center">' . $row['ID_LOCALITE'] . '</td>
<td class="text" >' . stripslashes($row['LOC_NOM']) . '</td>
<td class="text" >' . stripslashes($row['GRPLOC_LIBELLE']) . '</td>
<td class="text" >' . stripslashes(getDependance($row['LOC_LIEN'])) . '</td>
</tr>';
$i++;
$j++;
}
} 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>';
}
}
$returnTble['L'] = $returnHTML;
return $returnTble;
}
}
if ($_SESSION['GL_USER']['DROIT']['par_uti']['MODIF'] != 1) {
header("location:accessinterdit.php?selectedTab=home");
}
require_once '../lib/phpfuncLib.php';
//All commun functions
require_once 'menus.php';
require_once 'funcdecoupage.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_LOC']['ID_DECOUPAGE']) ? $codelocalite = $_SESSION['DATA_LOC']['ID_DECOUPAGE'] : ($codelocalite = '');
isset($_SESSION['DATA_LOC']['ID_GRPLOC']) ? $grplocalite = $_SESSION['DATA_LOC']['ID_GRPLOC'] : ($grplocalite = '');
isset($_SESSION['DATA_LOC']['LOC_DECOUPAGE']) ? $decoupage = $_SESSION['DATA_LOC']['LOC_DECOUPAGE'] : ($decoupage = '');
isset($_SESSION['DATA_LOC']['LOC_LIEN']) ? $dependance = $_SESSION['DATA_LOC']['LOC_LIEN'] : ($dependance = '');
$xdependance = getDependance($dependance);
?>
<!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 -->
