<?php
include "../../../ili-functions/functions.php";
Authorization('2');
AuthorizedPrivileges('CLIENTS', 'S');
function ClientGetListSearch()
{
global $URL;
$q = "SELECT * FROM client";
$r = QueryExcuteWhile($q);
while ($o = mysqli_fetch_object($r)) {
echo '
<tr id="tr" onclick="document.location=\'' . $URL . 'ili-modules/contrat/add/add?clt=' . $o->idClient . '\'">
<td><input type="checkbox" class="checkboxes" value="1" /></td>
<td>' . $o->idClient . '</td>
<td class="hidden-phone">' . $o->FamilyName . ' ' . $o->FirstName . '</td>
<td class="hidden-phone">' . $o->Phone . '</td>
</tr>
';
}
}
?>
<!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]-->
<?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>
<?php
include "../ili-functions/functions.php";
function UserDeban($idUser)
{
$QueryUserDeban = "UPDATE users SET idRank='2' WHERE idUser='******' ;";
QueryExcute('', $QueryUserDeban);
}
Authorization('2');
AuthorizedPrivileges('USERS', 'U');
$idUser = $_GET['id'];
$user = UserGetInfo($idUser);
if ($user == '') {
Redirect('index?message=14');
} else {
UserDeban($idUser);
$idUserSession = $_SESSION['user_id'];
$UserUpdated = UserGetInfo($idUser);
$UserUpdater = UserGetInfo($idUserSession);
NotifAllWrite($idUser, '', '<a href="' . $URL . 'ili-users/user_profil?id=' . $idUser . '">' . $UserUpdater->FamilyName . ' ' . $UserUpdater->FirstName . ' a débanni ' . $UserUpdated->FamilyName . ' ' . $UserUpdated->FirstName);
LogWrite("Utilisateur : " . $user->idUser . " a ete debanni");
Redirect('ili-users/user_edit?id=' . $idUser);
}
<?php
include "../../ili-functions/functions.php";
Authorization('2');
AuthorizedPrivileges('CONTRAT', 'S');
function ListContract()
{
global $URL;
$sql = "\n\tSELECT `insurancecontract`.`idContract`, `FirstName`, `FamilyName`, `TypeContract`, `KindContract`, MAX(`StartDate`), MAX(`EndDate`), `Amount`, `idCycle`,`client`.`idClient`\n\tFROM `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\tGROUP BY `insurancecontract`.`idContract`\n\t";
$result = QueryExcuteWhile($sql);
while ($o = mysqli_fetch_array($result)) {
$idContract = $o[0];
echo '
<tr class="odd gradeX" id="tr" onclick="document.location=\'' . $URL . 'ili-modules/contrat/contrat?id=' . $o[0] . '\'">
<td>' . $o[0] . '</td>
<td>' . $o[2] . ' ' . $o[1] . '</td>
<td>' . $o[4] . '</td>
<td>' . $o[3] . '</td>
<td>' . $o[5] . '</td>
<td>' . $o[6] . '</td>
<td>';
ExpireIn($o[6]);
echo '</td>
</tr>
';
}
}
?>
<!DOCTYPE html>
<?php
echo $author;