function UserDiplomaDrop($idDiploma)
{
$query = "DELETE FROM `usersdiploma` WHERE `idDiploma`='{$idDiploma}';";
if (QueryExcute('', $query)) {
return 1;
}
}
function NotifGetSumNonSeen()
{
$idUser = $_SESSION['user_id'];
$query = "SELECT * FROM `notificationsystem` WHERE `idUser`='{$idUser}' AND `Seen`='0'";
$o = QueryExcute("mysqli_num_rows", $query);
echo $o;
}
function UserExpiranceDrop($idExperience)
{
$query = "DELETE FROM `usersexperience` WHERE `idExperience`='{$idExperience}';";
if (QueryExcute('', $query)) {
return 1;
}
}
function LogExportButton($MinLagneLog)
{
$o = QueryExcute('mysqli_num_rows', 'SELECT * FROM `logsystem`;');
if ($o >= $MinLagneLog) {
echo '<span class="tools"> <a href="export" class="icon-upload-alt" data-original-title="Archivage du log"></a></span>';
}
}
function CompanyInfoUpdate()
{
global $URL;
$idUser = $_SESSION['user_id'];
$user = UserGetInfo($idUser);
if (isset($_POST['RS']) && isset($_POST['Activity']) && isset($_POST['Phone1']) && isset($_POST['Adress'])) {
if (isset($_POST['MF'])) {
$MF = addslashes($_POST['MF']);
} else {
$MF = '';
}
$RS = addslashes($_POST['RS']);
if (isset($_POST['RC'])) {
$RC = addslashes($_POST['RC']);
} else {
$RC = '';
}
$Activity = addslashes($_POST['Activity']);
$Adress = addslashes($_POST['Adress']);
$Phone1 = $_POST['Phone1'];
if (isset($_POST['Phone2'])) {
$Phone2 = addslashes($_POST['Phone2']);
} else {
$Phone2 = '';
}
if (isset($_POST['Fax'])) {
$Fax = addslashes($_POST['Fax']);
} else {
$Fax = '';
}
if (isset($_POST['Email'])) {
$Email = addslashes($_POST['Email']);
} else {
$Email = '';
}
if (isset($_POST['WebSite'])) {
$WebSite = addslashes($_POST['WebSite']);
} else {
$WebSite = '';
}
if (isset($_POST['BankAccount1'])) {
$BankAccount1 = addslashes($_POST['BankAccount1']);
} else {
$BankAccount1 = '';
}
if (isset($_POST['BankAccount2'])) {
$BankAccount2 = addslashes($_POST['BankAccount2']);
} else {
$BankAccount2 = '';
}
QueryExcute("", "UPDATE `company` SET `MF`='{$MF}', `RC`='{$RC}', `RS`='{$RS}', `Activity`='{$Activity}', `Adress`='{$Adress}', `Phone1`='{$Phone1}', `Phone2`='{$Phone2}', `Fax`='{$Fax}',\t`Email`='{$Email}', `WebSite`='{$WebSite}', `BankAccount1`='{$BankAccount1}', `BankAccount2`='{$BankAccount2}' WHERE `id`=1");
NotifAllWrite('', '', '<a href="' . $URL . 'ili-modules/ets/info">' . $user->FamilyName . ' ' . $user->FirstName . ', a modifier les informations de l`entreprise');
LogWrite("Modification des informations de l\\'entreprise");
Redirect('ili-modules/ets/info');
}
}
function ClientDrop($idClient, $O)
{
$query = "DELETE FROM `client` WHERE `idClient`='{$idClient}';";
QueryExcute('', $query);
$user_nom = $_SESSION['user_nom'];
$user_prenom = $_SESSION['user_prenom'];
NotifAllWrite('', '', '<a href="#">' . $user_nom . ' ' . $user_prenom . ' a supprimé le client, ' . $O->FamilyName . ' ' . $O->FirstName);
LogWrite('Suppression de de client ' . $O->FamilyName . ' ' . $O->FirstName);
Redirect('ili-modules/client/liste');
}
function MessageGetSumHeader()
{
$idUser = $_SESSION['user_id'];
$q1 = "SELECT COUNT(*) FROM `message` WHERE `ToUser`='{$idUser}' AND `Seen`='0';";
$q2 = "SELECT COUNT(*) FROM `message`, `discussion`\n\t\t\tWHERE\n\t\t\t(`message`.`ToUser`='{$idUser}' OR `message`.`FromUser`='{$idUser}' )\n AND\n\t\t\t`discussion`.`ToUser`='{$idUser}'\n\t\t\tAND \n\t\t\t`message`.`Seen`='1'\n\t\t\tAND\n\t\t\t`discussion`.`idMessage`=`message`.`idMessage`\n\t\t\tAND\n\t\t\t`discussion`.`ToUser`='{$idUser}'\n\t\t\tAND\n\t\t\t`discussion`.`Seen`='0';";
$o1 = QueryExcute("mysqli_fetch_row", $q1);
$o2 = QueryExcute("mysqli_fetch_row", $q2);
$o = $o1[0] + $o2[0];
echo $o;
}
function Statistique($query, $result_type)
{
$o = QueryExcute("mysqli_fetch_array", $query);
if ($result_type == 'number') {
echo $o[0];
}
if ($result_type == 'currency') {
printf('%0.3f', $o[0]);
}
}
function LogExport()
{
global $URL;
$Timestamp_Log = date("Ymd_His");
$result = QueryExcuteWhile("SELECT * FROM `logsystem`");
while ($o = mysqli_fetch_object($result)) {
if ($o) {
file_put_contents('./' . $Timestamp_Log . '.txt', $o->idLog . ' ' . $o->Timestamp . ' ' . $o->idUser . ' ' . $o->Description . "\n", FILE_APPEND);
QueryExcute('', 'TRUNCATE `logsystem`;');
}
}
Redirect('log/index');
}
function UserInsert()
{
if (isset($_POST['cin']) && isset($_POST['FamilyName']) && isset($_POST['FirstName']) && isset($_POST['Email']) && isset($_POST['Phone']) && isset($_POST['Password']) && isset($_POST['FunctionPost']) && isset($_POST['Adress']) && isset($_POST['BirthDay'])) {
//Recup variable
$cin = addslashes($_POST['cin']);
$FamilyName = addslashes($_POST['FamilyName']);
$FirstName = addslashes($_POST['FirstName']);
$Email = addslashes($_POST['Email']);
$FunctionPost = addslashes($_POST['FunctionPost']);
$Phone = addslashes($_POST['Phone']);
$Adress = addslashes($_POST['Adress']);
$BirthDay = addslashes($_POST['BirthDay']);
$Password = addslashes($_POST['Password']);
if (isset($_POST['fbAccount'])) {
$fbAccount = $_POST['fbAccount'];
} else {
$fbAccount = '';
}
if (isset($_POST['githubAccount'])) {
$githubAccount = $_POST['githubAccount'];
} else {
$githubAccount = '';
}
if (isset($_POST['linkedinAccount'])) {
$linkedinAccount = $_POST['linkedinAccount'];
} else {
$linkedinAccount = '';
}
if (isset($_POST['img_url'])) {
$img_url = $_POST['img_url'];
} else {
$img_url = '';
}
// Function
global $Timestamp, $URL;
$add_by = $_SESSION['user_nom_prenom'];
if (QueryExcute('mysqli_fetch_object', "SELECT * FROM users WHERE idUser='******';")) {
Redirect('ili-users/user_add?message=8');
} else {
if (QueryExcute('mysqli_fetch_object', "SELECT * FROM users WHERE Email='{$Email}';")) {
Redirect('ili-users/user_add?message=9');
} else {
QueryExcute("", "INSERT INTO `users` VALUES ('{$cin}', '2', '{$FamilyName}', '{$FirstName}', '{$Email}', '{$FunctionPost}', '{$Phone}', '{$Adress}', '{$BirthDay}', MD5('{$Password}'), '{$Timestamp}', '{$fbAccount}', '{$githubAccount}', '{$linkedinAccount}', '{$ProfilePhoto}', '{$add_by}', '{$Timestamp}')");
QueryExcute("", "INSERT INTO `usersprivilege` VALUES (NULL, '{$cin}', 'USERS', '1', '0', '0', '0'), (NULL, '{$cin}', 'CLIENTS', '1', '0', '0', '0'), (NULL, '{$cin}', 'CONTRAT', '1', '0', '0', '0'), (NULL, '{$cin}', 'CAISSE', '1', '0', '0', '0')");
NotifAllWrite($cin, '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $cin . '">Nouveau utilisateur, ' . $FamilyName . ' ' . $FirstName);
LogWrite("Creation de l\\'utilisateur : " . $cin);
Redirect('ili-users/users');
}
}
}
}
function ContractRenew()
{
$idUser = $_SESSION['user_id'];
$User = $_SESSION['user_nom_prenom'];
if (isset($_POST['idContract']) && isset($_POST['StartDate']) && isset($_POST['EndDate']) && isset($_POST['Amount']) && isset($_POST['EncashmentDate']) && isset($_POST['PaymentKind'])) {
$idContract = addslashes($_POST['idContract']);
$StartDate = addslashes($_POST['StartDate']);
$EndDate = addslashes($_POST['EndDate']);
$Amount = addslashes($_POST['Amount']);
global $NowEN;
$EncashmentDate = $NowEN;
$PaymentKind = addslashes($_POST['PaymentKind']);
if (isset($_POST['PaymentCode'])) {
$PaymentCode = addslashes($_POST['PaymentCode']);
} else {
$PaymentCode = '';
}
if (isset($_POST['Bank'])) {
$Bank = addslashes($_POST['Bank']);
} else {
$Bank = '';
}
if (isset($_POST['TransferDate'])) {
$TransferDate = addslashes($_POST['TransferDate']);
} else {
$TransferDate = '';
}
$PayementAdd = QueryExcute("", "INSERT INTO `payment` VALUES (NULL, '{$EncashmentDate}', '', '{$PaymentKind}', '{$PaymentCode}', '{$Bank}', '{$TransferDate}', '{$Amount}', '{$idUser}');");
if (!$PayementAdd) {
// recupération idPayment
$ObjectPayement = QueryExcute("mysqli_fetch_array", "SELECT max(`idPayment`) FROM `payment`");
if ($ObjectPayement) {
$idPayment = $ObjectPayement[0];
$ContractcycleAdd = QueryExcute("", "INSERT INTO `contractcycle` VALUES(NULL, '{$idPayment}', '{$idContract}', '{$StartDate}', '{$EndDate}', '{$idUser}');");
if (!$ContractcycleAdd) {
NotifAllWrite("", "", $User . " a renouveler le contrat #" . $idContract);
$user = UserGetInfo($idUser);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-modules/contrat/contrat?id=' . $idContract . '">' . $user->FamilyName . ' ' . $user->FirstName . ', a renouveler le contrat : #' . $idContract . '</a>');
Redirect("ili-modules/contrat/liste");
} else {
Redirect('ili-modules/contrat/renew/renew?id=' . $idContract . '&message=31');
}
}
} else {
Redirect('ili-modules/contrat/renew/renew?id=' . $idContract . '&message=32');
}
}
}
function MessageGetAll()
{
global $URL;
$idUser = $_SESSION['user_id'];
$q = "SELECT * FROM `message`\n\t\t\tWHERE\n\t\t\t(`FromUser`='{$idUser}' OR `ToUser`='{$idUser}')\n\t\t\tORDER BY `idMessage` DESC limit 5;";
$r = QueryExcuteWhile($q);
while ($o = mysqli_fetch_object($r)) {
$info_user = UserGetInfo($o->FromUser);
$idMessage = $o->idMessage;
$q1 = "SELECT * FROM `message`, `discussion`\n\t\t\tWHERE\n\t\t\t`discussion`.`idMessage`=`message`.`idMessage`\n\t\t\tAND\n\t\t\t`message`.`idMessage`='{$idMessage}'\n\t\t\tAND\n\t\t\t`idDiscussion`=(SELECT MAX(`idDiscussion`) FROM `discussion`)\n\t\t\t;";
$o1 = QueryExcute("mysqli_num_rows", $q1);
if ($o1 >= '1') {
$rx = QueryExcuteWhile($q1);
$ox = mysqli_fetch_object($rx);
}
if ($o1 >= '1') {
$idDiscussion = $ox->idDiscussion;
} else {
$idDiscussion = '';
}
echo '
<tr>
<td></td>
<td> <a href="' . $URL . 'ili-users/user_profil?id=' . $o->FromUser . '">' . $info_user->FamilyName . ' ' . $info_user->FirstName . '</a> </td>
<td class="hidden-phone"> <strong> <a href="' . $URL . 'ili-messages/read?id=' . $idMessage . '&id2=' . $idDiscussion . '">' . $o->Subject . '</a> </strong> </td>
<td class="hidden-phone">';
if ($o1 >= '1') {
MessageStatus($ox->idMessage, $idDiscussion);
} else {
MessageStatus($o->idMessage, '');
}
MessageStatusChekIfLocked($o->idMessage);
echo ' </td>
<td class="hidden-phone">';
if ($o1 >= '1') {
DateDifference($ox->TimeStamp);
} else {
DateDifference($o->TimeStamp);
}
echo ' </td>
</tr>
';
}
}
function LogIn($Email, $Password)
{
if ($o = QueryExcute("mysqli_fetch_object", "SELECT * FROM `users`, `usersrank` WHERE `users`.Email='{$Email}' AND `users`.Password='******' AND `users`.idRank=`usersrank`.idRank")) {
if ($o->idRank == '1') {
Redirect("login?message=3");
} else {
$_SESSION['user_id'] = $o->idUser;
$_SESSION['user_nom'] = $o->FamilyName;
$_SESSION['user_prenom'] = $o->FirstName;
$_SESSION['user_nom_prenom'] = $_SESSION['user_nom'] . ' ' . $_SESSION['user_prenom'];
$_SESSION['user_idRank'] = $o->idRank;
$_SESSION['user_img'] = $o->ProfilePhoto;
LogWrite("Connexion");
Redirect("index");
}
} else {
Redirect("login?message=2");
}
}
function AdminInsert()
{
global $URL;
if (isset($_POST['cin']) && isset($_POST['FamilyName']) && isset($_POST['FirstName']) && isset($_POST['Email']) && isset($_POST['Phone']) && isset($_POST['Password']) && isset($_POST['Adress'])) {
//Recup variable
$cin = addslashes($_POST['cin']);
$FamilyName = addslashes($_POST['FamilyName']);
$FirstName = addslashes($_POST['FirstName']);
$Email = addslashes($_POST['Email']);
$FunctionPost = 'ADMINISTRATEUR';
$Phone = addslashes($_POST['Phone']);
$Adress = addslashes($_POST['Adress']);
$Password = addslashes($_POST['Password']);
$BirthDay = addslashes($_POST['BirthDay']);
// Function
global $Timestamp, $URL, $sytem_title;
QueryExcute("", "INSERT INTO `users` VALUES ('{$cin}', '3', '{$FamilyName}', '{$FirstName}', '{$Email}', '{$FunctionPost}', '{$Phone}', '{$Adress}', '{$BirthDay}', MD5('{$Password}'), '{$Timestamp}', '', '', '', '', '{$sytem_title}', '{$Timestamp}')");
echo '<script language="Javascript">document.location.href="' . $URL . 'INSTALL/4"</script>';
}
}
function ClientInsert()
{
//Form Variables
if (isset($_POST['idClient']) && isset($_POST['FamilyName']) && isset($_POST['FirstName']) && isset($_POST['Phone']) && isset($_POST['Adress'])) {
global $URL;
$idClient = addslashes($_POST['idClient']);
$FamilyName = addslashes($_POST['FamilyName']);
$FirstName = addslashes($_POST['FirstName']);
$Phone = addslashes($_POST['Phone']);
$Adress = addslashes($_POST['Adress']);
$idUser = $_SESSION['user_id'];
$User = $_SESSION['user_nom_prenom'];
if (QueryExcute("mysqli_fetch_row", "SELECT * FROM client WHERE idClient='{$idClient}'") == 0) {
QueryExcute("", "INSERT INTO `client` VALUES ('{$idClient}', '{$FamilyName}', '{$FirstName}', '{$Phone}', '{$Adress}', '{$idUser}');");
NotifAllWrite('', '', '<a href="' . $URL . 'ili-modules/client/client?id=' . $idClient . '">' . $User . ' a creé un nouveau client , ' . $FamilyName . ' ' . $FirstName);
LogWrite("Création de client : <a href=\"ili-modules/client/client?id=" . $idClient . "\">" . $idClient . "</a>");
Redirect('ili-modules/client/client?id=' . $idClient);
} else {
Redirect('ili-modules/client/add?message=16');
}
}
}
function MessageStart($idUser)
{
//Form
echo '
<form action="" method="post" class="form-vertical">
<br>
<div class="control-group">
<div class="controls">
<input name="Subject" style="margin-top:-14px" type="text" class="span6" placeholder="Sujet" autofocus required/><br>
<select name="ToUser" class="span6">';
MessageDestinationGetList();
echo '</select>
</div>
</div>
<!-- END SUJET DISTINATAIRE-->
<div class="control-group">
<div class="controls">
<textarea class="span12 ckeditor" name="Containt" rows="4"></textarea><br>
<center>
<input type="reset" value=" Annuler" class="btn btn-info"/>
<input type="submit" value=" Envoyer" class="btn btn-success"/>
</center>
</div>
</div>
<!-- END EDITEUR -->
</form>
';
//Function
if (isset($_POST['Subject']) && isset($_POST['ToUser']) && isset($_POST['Containt'])) {
global $Timestamp;
$Subject = addslashes($_POST['Subject']);
$ToUser = addslashes($_POST['ToUser']);
$Containt = addslashes($_POST['Containt']);
$QueryStartMessage = "INSERT INTO `message` VALUES (NULL, '{$idUser}', '{$ToUser}', '{$Subject}', '{$Containt}', '{$Timestamp}', '0', NULL);";
QueryExcute('', $QueryStartMessage);
Redirect("index");
}
}
function MessageGetReceever($idMessage, $idDiscussion)
{
$idUser = $_SESSION['user_id'];
if ($idDiscussion == '') {
$O1 = QueryExcute("mysqli_fetch_object", "SELECT `FromUser`, `ToUser` FROM `message` WHERE `idMessage`='{$idMessage}';");
if ($O1->FromUser != $idUser) {
echo $O1->FromUser;
} else {
echo $O1->ToUser;
}
} else {
//Get Last idDiscussion From idMessage
$O = QueryExcute("mysqli_fetch_array", "SELECT MAX(`idDiscussion`) FROM `discussion` WHERE `idMessage`='{$idMessage}';");
$MaxidDiscussion = $O[0];
$O2 = QueryExcute("mysqli_fetch_object", "SELECT `FromUser`, `ToUser` FROM `discussion` WHERE `idDiscussion`='{$MaxidDiscussion}';");
if ($O2->FromUser != $idUser) {
echo $O2->FromUser;
} else {
echo $O2->ToUser;
}
}
}
<?php
include "../../ili-functions/functions.php";
Authorization('2');
AuthorizedPrivileges('CAISSE', 'S');
if (isset($_GET['id'])) {
$id = $_GET['id'];
$o = QueryExcute("mysqli_fetch_object", "SELECT * FROM `payment` WHERE `idPayment`='{$id}';");
if (!$o) {
Redirect('index?message=35');
}
} else {
Redirect('index?message=35');
}
?>
<!DOCTYPE html>
<?php
echo $author;
?>
<!--[if IE 8]> <html lang="en" class="ie8"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9"> <![endif]-->
<!--[if !IE]><!-->
<html lang="fr">
<!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
<meta charset="utf-8" />
<title><?php
echo $sytem_title;
?>
</title>
$Bank = '';
}
if (isset($_POST['TransferDate'])) {
$TransferDate = addslashes($_POST['TransferDate']);
} else {
$TransferDate = '';
}
$idUser = $_SESSION['user_id'];
$ajout = QueryExcute("", "INSERT INTO `insurancecontract` VALUES ('{$idContract}', '{$idClient}', '{$TypeContract}', '{$NatureContract}');");
if (!$ajout) {
$ajout2 = QueryExcute("", "INSERT INTO `payment` VALUES (NULL, '{$EncashmentDate}', '', '{$PaymentKind}', '{$PaymentCode}', '{$Bank}', '{$TransferDate}', '{$Amount}', '{$idUser}');");
if (!$ajout2) {
$ObjectPayement = QueryExcute("mysqli_fetch_array", "SELECT max(`idPayment`) FROM `payment`");
if ($ObjectPayement) {
$idPayment = $ObjectPayement[0];
$ajout3 = QueryExcute("", "INSERT INTO `contractcycle` VALUES(NULL, '{$idPayment}', '{$idContract}', '{$StartDate}', '{$EndDate}', '{$idUser}');");
if (!$ajout3) {
$user = UserGetInfo($idUser);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-modules/contrat/contrat?id=' . $idContract . '">' . $user->FamilyName . ' ' . $user->FirstName . ', a crée un nouveau contrat : #' . $idContract . '</a>');
LogWrite("Ajout contract ID : " . $idContract);
Redirect("ili-modules/contrat/liste");
} else {
Redirect('ili-modules/contrat/add/add?clt=' . $id_clt . '&message=26');
}
} else {
Redirect('ili-modules/contrat/add/add?clt=' . $id_clt . '&message=27');
}
} else {
Redirect('ili-modules/contrat/add/add?clt=' . $id_clt . '&message=28');
}
} else {
function CompanyInsert()
{
global $URL;
if (isset($_POST['MF']) && isset($_POST['RC']) && isset($_POST['RS']) && isset($_POST['Activity']) && isset($_POST['Adress']) && isset($_POST['Phone1'])) {
//Recup variable
$MF = addslashes($_POST['MF']);
$RC = addslashes($_POST['RC']);
$RS = addslashes($_POST['RS']);
$Activity = addslashes($_POST['Activity']);
$Adress = addslashes($_POST['Adress']);
$Phone1 = addslashes($_POST['Phone1']);
if (isset($_POST['Phone2'])) {
$Phone2 = $_POST['Phone2'];
} else {
$Phone2 = '';
}
if (isset($_POST['Fax'])) {
$Fax = $_POST['Fax'];
} else {
$Fax = '';
}
if (isset($_POST['Email'])) {
$Email = $_POST['Email'];
} else {
$Email = '';
}
if (isset($_POST['WebSite'])) {
$WebSite = $_POST['WebSite'];
} else {
$WebSite = '';
}
if (isset($_POST['BankAccount1'])) {
$BankAccount1 = $_POST['BankAccount1'];
} else {
$BankAccount1 = '';
}
if (isset($_POST['BankAccount2'])) {
$BankAccount2 = $_POST['BankAccount2'];
} else {
$BankAccount2 = '';
}
UploadImage();
QueryExcute("", "INSERT INTO `company` VALUES ('1', '{$MF}', '{$RC}', '{$RS}', '{$Activity}', '{$Adress}', '{$Phone1}', '{$Phone2}', '{$Fax}', '{$Email}', '{$WebSite}', '{$BankAccount1}', '{$BankAccount2}' );");
echo '<script language="Javascript">document.location.href="' . $URL . 'login"</script>';
}
}
function NotifMakeSee($idNotification)
{
$query = "UPDATE `notificationsystem` SET `Seen` = '1' WHERE `idNotification` ='{$idNotification}';";
QueryExcute('', $query);
}
function ContractGetAllAmount($idContract)
{
$q = "SELECT (SUM(Amount)) as total FROM `insurancecontract`, `contractcycle`, `payment`, `client` \n\tWHERE \n\t`client`.`idClient`=`insurancecontract`.`idClient` \n\tAND \n\t`contractcycle`.`idContract`=`insurancecontract`.`idContract` \n\tAND \n\t`payment`.`idPayment`=`contractcycle`.`idPayment` \n\tAND \n\t`insurancecontract`.`idContract`='{$idContract}'";
$o = QueryExcute("mysqli_fetch_object", $q);
echo sprintf("%.3f", $o->total) . ' TND';
}
function UserDrop($id)
{
QueryExcute('', "DELETE FROM usersprivilege WHERE idUser='******'");
QueryExcute('', "DELETE FROM users WHERE idUser='******'");
}
function UserPrivilegesGetUpdate($idUser)
{
global $URL;
$user = UserGetInfo($idUser);
if ($_SESSION['user_idRank'] >= 3 && $_SESSION['user_id'] != $idUser) {
echo '
<ul class="nav nav-tabs nav-stacked" style="margin-left:-15%;">
<div class="widget-body">
<div class="space10"></div>
<ul id="tree_2" class="tree">
<li>
<a data-toggle="branch" class="tree-toggle" data-role="branch" href="#">Autorisations</a>
<ul class="branch in">';
$query = "SELECT `bloc` FROM `usersprivilege` WHERE `idUser`='{$idUser}'";
$result = QueryExcuteWhile($query);
while ($o = mysqli_fetch_object($result)) {
if ($o->bloc != 'CONTRAT' && $o->bloc != 'CAISSE') {
echo '
<li><a data-toggle="branch" class="tree-toggle closed" data-role="branch" href="#">' . $o->bloc . '</a>';
$query2 = "SELECT * FROM `usersprivilege` WHERE `idUser`='{$idUser}' AND `bloc`='{$o->bloc}';";
$result2 = QueryExcuteWhile($query2);
while ($b = mysqli_fetch_object($result2)) {
echo '
<ul class="branch">
';
if ($b->s) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 's0" value="1">
<input type="checkbox" name="s0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-eye-open"></p></a> Voir
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 's1" value="1" onChange="this.form.submit()">
<a><p class="icon-eye-open"></p></a> Voir
</form>
</li>
';
}
if ($b->c) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'c0" value="1">
<input type="checkbox" name="c0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-plus"></p></a> Créer
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'c1" value="1" onChange="this.form.submit()">
<a><p class="icon-plus"></p></a> Créer
</form>
</li>
';
}
if ($b->u) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'u0" value="1">
<input type="checkbox" name="u0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-edit"></p></a> Modifier
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'u1" value="1" onChange="this.form.submit()">
<a><p class="icon-edit"></p></a> Modifier
</form>
</li>
';
}
if ($b->d) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'd0" value="1">
<input type="checkbox" name="d0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-trash"></p></a> Supprimer
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'd1" value="1" onChange="this.form.submit()">
<a><p class="icon-trash"></p></a> Supprimer
</form>
</li>
';
}
if (isset($_POST[$b->idPrivilege . 's0'])) {
$query = "UPDATE `usersprivilege` SET s='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>VOIR</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege VOIR sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 's1'])) {
$query = "UPDATE `usersprivilege` SET s='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>VOIR</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege VOIR sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'c0'])) {
$query = "UPDATE `usersprivilege` SET c='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>CREER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege CREER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'c1'])) {
$query = "UPDATE `usersprivilege` SET c='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>CREER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege CREER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'u0'])) {
$query = "UPDATE `usersprivilege` SET u='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>MODIFIER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege MODIFIER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'u1'])) {
$query = "UPDATE `usersprivilege` SET u='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>MODIFIER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege MODIFIER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'd0'])) {
$query = "UPDATE `usersprivilege` SET d='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Suppression du privilége <strong>SUPPRIMER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege SUPPRIMER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'd1'])) {
$query = "UPDATE `usersprivilege` SET d='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>SUPPRIMER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege SUPPRIMER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
echo '
</ul>
';
}
}
if ($o->bloc == 'CONTRAT') {
echo '
<li><a data-toggle="branch" class="tree-toggle closed" data-role="branch" href="#">' . $o->bloc . '</a>';
$query2 = "SELECT * FROM `usersprivilege` WHERE `idUser`='{$idUser}' AND `bloc`='{$o->bloc}';";
$result2 = QueryExcuteWhile($query2);
while ($b = mysqli_fetch_object($result2)) {
echo '
<ul class="branch">
';
if ($b->s) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 's0" value="1">
<input type="checkbox" name="s0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-eye-open"></p></a> Voir
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 's1" value="1" onChange="this.form.submit()">
<a><p class="icon-eye-open"></p></a> Voir
</form>
</li>
';
}
if ($b->c) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'c0" value="1">
<input type="checkbox" name="c0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-file"></p></a> Créer
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'c1" value="1" onChange="this.form.submit()">
<a><p class="icon-file"></p></a> Créer
</form>
</li>
';
}
if ($b->u) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'u0" value="1">
<input type="checkbox" name="u0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-repeat"></p></a> Renouveler
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'u1" value="1" onChange="this.form.submit()">
<a><p class="icon-repeat"></p></a> Renouveler
</form>
</li>
';
}
if ($b->d) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'd0" value="1">
<input type="checkbox" name="d0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-trash"></p></a> Supprimer
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'd1" value="1" onChange="this.form.submit()">
<a><p class="icon-trash"></p></a> Supprimer
</form>
</li>
';
}
if (isset($_POST[$b->idPrivilege . 's0'])) {
$query = "UPDATE `usersprivilege` SET s='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>VOIR</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege VOIR sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 's1'])) {
$query = "UPDATE `usersprivilege` SET s='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>VOIR</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege VOIR sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'c0'])) {
$query = "UPDATE `usersprivilege` SET c='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>CREER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege CREER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'c1'])) {
$query = "UPDATE `usersprivilege` SET c='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>CREER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege CREER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'u0'])) {
$query = "UPDATE `usersprivilege` SET u='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>RENOUVELER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege RENOUVELER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'u1'])) {
$query = "UPDATE `usersprivilege` SET u='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>RENOUVELER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege RENOUVELER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'd0'])) {
$query = "UPDATE `usersprivilege` SET d='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Suppression du privilége <strong>SUPPRIMER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege SUPPRIMER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'd1'])) {
$query = "UPDATE `usersprivilege` SET d='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>SUPPRIMER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege SUPPRIMER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
echo '
</ul>
';
}
}
if ($o->bloc == 'CAISSE') {
echo '
<li><a data-toggle="branch" class="tree-toggle closed" data-role="branch" href="#">' . $o->bloc . '</a>';
$query2 = "SELECT * FROM `usersprivilege` WHERE `idUser`='{$idUser}' AND `bloc`='{$o->bloc}';";
$result2 = QueryExcuteWhile($query2);
while ($b = mysqli_fetch_object($result2)) {
echo '
<ul class="branch">
';
if ($b->s) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 's0" value="1">
<input type="checkbox" name="s0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-book"></p></a> Journal
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 's1" value="1" onChange="this.form.submit()">
<a><p class="icon-book"></p></a> Journal
</form>
</li>
';
}
if ($b->c) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'c0" value="1">
<input type="checkbox" name="c0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-signout"></p></a> Décaissement
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'c1" value="1" onChange="this.form.submit()">
<a><p class="icon-signout"></p></a> Décaissement
</form>
</li>
';
}
if ($b->u) {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="hidden" name="' . $b->idPrivilege . 'u0" value="1">
<input type="checkbox" name="u0" value="0" checked onChange="this.form.submit()">
<a><p class="icon-money"></p></a> Echéancier
</form>
</li>
';
} else {
echo '
<li>
<form action="" method="post" style="margin-bottom:-2px;">
<input type="checkbox" name="' . $b->idPrivilege . 'u1" value="1" onChange="this.form.submit()">
<a><p class="icon-money"></p></a> Echéancier
</form>
</li>
';
}
if (isset($_POST[$b->idPrivilege . 's0'])) {
$query = "UPDATE `usersprivilege` SET s='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>JOURNAL</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege VOIR sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 's1'])) {
$query = "UPDATE `usersprivilege` SET s='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>JOURNAL</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege VOIR sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'c0'])) {
$query = "UPDATE `usersprivilege` SET c='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>DECAISSEMENT</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege CREER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'c1'])) {
$query = "UPDATE `usersprivilege` SET c='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>DECAISSEMENT</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege CREER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'u0'])) {
$query = "UPDATE `usersprivilege` SET u='0' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Supprission du privilége <strong>ECHEANCIER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Suppression de privilege RENOUVELER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
if (isset($_POST[$b->idPrivilege . 'u1'])) {
$query = "UPDATE `usersprivilege` SET u='1' WHERE idPrivilege='{$b->idPrivilege}';";
QueryExcute('', $query);
NotifAllWrite('', '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $user->idPrivilege_user . '">Ajout du privilége <strong>ECHEANCIER</strong> sur le bloc <strong>' . $o->bloc . '</strong> de ' . $user->FamilyName . ' ' . $user->FirstName);
LogWrite("Ajout de privilege RENOUVELER sur le bloc " . $o->bloc . " pour l\\'utilisateur : " . $idUser);
echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="user_edit?id=' . $idUser . '"</SCRIPT>';
}
echo '
</ul>
';
}
}
echo '
</li>
';
}
echo '
</ul>
</li>
</ul>
</div>
</ul>
';
}
}
<?php
include "../../../ili-functions/functions.php";
if ($_POST) {
//Récupération des variable depuis le lien
$idClient = $_GET['idClient'];
$Notification = $_GET['Notification'];
$Log = $_GET['Log'];
$Form = $_GET['Form'];
//Récupération des varibales depuis la formulaire
$input = $_POST['input'];
//Exécution de requette
QueryExcute("", "UPDATE `client` SET {$Form} = '{$input}' WHERE `idClient` = '{$idClient}';");
//Récupération des variables pour le log & notification
$idUser = $_SESSION['user_id'];
//Construction des objets pour le log & notification
$User = UserGetInfo($idUser);
$Client = ClientGetInfo($idClient);
//Execution des fonctions
NotifAllWrite('', '', '<a href="' . $URL . 'ili-modules/client/client?id=' . $idClient . '"><b>' . $User->FamilyName . ' ' . $User->FirstName . '</b> ' . $Notification . ' <b>' . $input . '</b>');
LogWrite($Log . ' ' . $input);
}
function CompanyGetInfo()
{
$query = "SELECT * FROM `company`";
if ($o = QueryExcute("mysqli_fetch_object", $query)) {
return $o;
}
}
<!-- BEGIN PAGE CONTENT-->
<div class="row-fluid">
<div class="span12">
<!-- BEGIN EXAMPLE TABLE widget-->
<div class="widget">
<div class="widget-title"><h4><i class="icon-reorder"></i> Recherche Du Chéque</h4></div>
<div class="widget-body">
<div class="span12">
<br/>
<form action="" method="post">
<input type="text" name="PaymentCode" required placeholder="CODE CHEQUE" style="margin-top:10px; margin-right:10px;"><button class="btn btn-success"><i class="icon-search icon-white"></i> Chercher</button></td>
</form>
<?php
if (isset($_POST['PaymentCode'])) {
$PaymentCode = addslashes($_POST['PaymentCode']);
$o = QueryExcute("mysqli_fetch_object", "SELECT * FROM `payment` WHERE `PaymentCode`='{$PaymentCode}'");
if ($o) {
Redirect('ili-modules/caisse/cheque?id=' . $PaymentCode);
} else {
echo '<br/><br> CODE CHEQUE NON TROUVE ';
}
}
?>
</div>
<div class="space5"></div>
</div>
</div>
<!-- END EXAMPLE TABLE widget-->
</div>
function CheckGetTotalAmmountOut($date1, $date2)
{
$o = QueryExcute("mysqli_fetch_array", "SELECT SUM(`Amount`) FROM `payment` WHERE `PaymentKind`='CHEQUE' AND `TransferDate`>='{$date1}' AND `TransferDate`<='{$date2}' AND `Amount`<0;");
printf("%0.3f", $o[0]);
}
function UserDeban($idUser)
{
$QueryUserDeban = "UPDATE users SET idRank='2' WHERE idUser='******' ;";
QueryExcute('', $QueryUserDeban);
}
function Checkout($date1, $date2, $idUser)
{
global $URL;
$sql1 = "SELECT * FROM `payment` WHERE `EncashmentDate` BETWEEN '{$date1}' AND '{$date2}' AND `RecevedBy`='{$idUser}';";
$sql2 = "SELECT * FROM `payment` WHERE `EncashmentDate` BETWEEN '{$date1}' AND '{$date2}';";
if ($idUser) {
$query = $sql1;
} else {
$query = $sql2;
}
$nobre_de_resultat = QueryExcute("mysqli_fetch_row", $query);
$result = QueryExcuteWhile($query);
echo '
<div class="row-fluid">
<table class="table table-striped table-hover">
<thead>
<tr>
<th>#</th>
<th>Contrat</th>
<th class="hidden-480">Designation</th>
<th class="hidden-480">Type</th>
<th class="hidden-480">Date</th>
<th class="hidden-480">Operateur</th>
<th>Total</th>
</tr>
</thead>
';
while ($o = mysqli_fetch_object($result)) {
$PaymentInfo = PaymentInfo($o->idPayment);
$USER2 = UserGetInfo($o->RecevedBy);
echo '
<tbody>
<tr>
<td>' . $o->idPayment . '</td>
<td>';
if ($PaymentInfo) {
echo $PaymentInfo->idContract;
} else {
echo '#';
}
echo '</td>
<td class="hidden-480">';
if ($o->Description) {
echo $o->Description;
} else {
echo '<center>##</center>';
}
echo '</td>
<td class="hidden-480">' . $o->PaymentKind . '</td>
<td class="hidden-480">';
echo FormatEnDateToFr($o->EncashmentDate);
echo '</td>
<td class="hidden-480">';
echo $USER2->FamilyName . ' ' . $USER2->FirstName;
echo '</td>
<td>';
printf('%0.3f', $o->Amount);
echo ' TND</td>
</tr>
';
}
echo '
</tbody>
</table>
</div>
<div class="space20"></div>
<div class="row-fluid">
<div class="span4 invoice-block pull-right">
<ul class="unstyled amounts">
<li><strong>Total Chéque(';
CheckoutGetTotalOperationCash($date1, $date2, $idUser);
echo ') : </strong> ';
CheckoutGetAmmountTotalCash($date1, $date2, $idUser);
echo ' TND</li>
<li><strong>Total Espéce(';
CheckoutGetTotalOperationCheck($date1, $date2, $idUser);
echo ') : </strong> ';
CheckoutGetAmmountTotalCheck($date1, $date2, $idUser);
echo ' TND</li>
<li><strong>Somme(';
CheckoutGetTotalOperation($date1, $date2, $idUser);
echo ') : </strong> ';
CheckoutGetAmmountTotal($date1, $date2, $idUser);
echo ' TND</li>
</ul>
</div>
</div>
';
}
