backoffice/application/views/demande.php

1596 lines
52 KiB
PHP
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<!-- DataTables -->
<link rel="stylesheet" href="<?= base_url('bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css') ?>">
<div class="content-wrapper">
<section class="content">
<div class="row">
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-aqua"><i class="ion ion-android-arrow-down"></i></span>
<div class="info-box-content">
<span class="info-box-text"><?= $this->lang->line('Temps moyen de traitement entrant'); ?> </span>
<span class="info-box-number">
<?php
if($temp_moyen!=false){
if(duree($temp_moyen)==""){
echo "0s";
}else{
echo duree($temp_moyen);
}
}else{
echo $this->lang->line('Aucune demande traitée');
}
?>
</span>
</div>
</div>
</div>
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-aqua"><i class="ion ion-android-time"></i></span>
<div class="info-box-content">
<?php
if($this->session->userdata('category') == "super"){
if(isset($nameOfcurentGeolocatedUser))
echo "<span class='info-box-number'>".$nameOfcurentGeolocatedUser."</span>";
}
?>
<span class="info-box-text"> <?= $this->lang->line('Période') ?> </span>
<span class="info-box-number">
<input id="picker" style="background: #fff; cursor: pointer; padding: 1px 1px; border: 1px solid #ccc; width: 100%" type="text" name="daterange" data-lang="<?= $this->session->userdata('site_lang') ?>"
data-type="<?= $demand_type?>" data-category="<?= $this->session->userdata('category') ?>"
value="<?= ($debut!=null & $fin != null) ? $debut. ' - '.$fin : ''?>"
/>
</span>
<span> Format : <?= $this->session->userdata('site_lang') === 'french' ? 'Jour - Mois - Année ' : 'Year - Month - Day'?> </span>
</div>
</div>
</div>
<?php if($this->session->userdata('category')=='super' && $type!=$this->lang->line('Adhésion')){ ?>
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-green"><i class="ion ion-android-arrow-up"></i></span>
<div class="info-box-content">
<span class="info-box-text"><?= $this->lang->line('Temps moyen de traitement sortant'); ?></span>
<span class="info-box-number">
<?php
if($temp_moyen_mine!=false){
if(duree($temp_moyen_mine)==""){
echo "0s";
}else{
echo duree($temp_moyen_mine);
}
}else{
echo $this->lang->line('Aucune demande traitée');
}
?>
</span>
</div>
</div>
</div>
<?php } ?>
</div>
<div class="row">
<?php
if($this->session->userdata('category')=='super' && $type!=$this->lang->line('Adhésion')){
?>
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('entrantes'); ?> </h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$list;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeMembres1" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Statut')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>".$this->lang->line('Telephone')."</th>
<th>".$this->lang->line('Emetteur')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Statut')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
if($type==$this->lang->line('Adhésion')){
$etat = $this->lang->line("Non traitée");
if($row->etat==1){
$etat = $this->lang->line("traitée");
}
$code = $row->code_membre;
if($row->code_membre==$this->session->userdata('member_code')){
$code = $this->lang->line('Vous');
}
echo "<tr>
<td> $row->phone </td>
<td>$code</td>
<td>$row->dateAjout </td>
<td > $row->dateModif</td>
<td>$etat</td>
<td>".traitementTemps($row->temps,$row->dateAjout)."</td>
</tr>";}else{
$etat = $this->lang->line("Non traitée");
if($row->statut==1){
$etat = $this->lang->line("Acceptée");
}else if($row->statut == 2){
$etat = $this->lang->line("Annulée");
}
$origin = $row->codeMembre;
$destination = $row->codeParrain;
if($row->codeMembre==$this->session->userdata('member_code')){
$origin = $this->lang->line('Vous');
}
if($row->codeParrain==$this->session->userdata('member_code')){
$destination = $this->lang->line('Vous');
}
echo "<tr>
<td> $row->phone</td>
<td >$origin </td>
<td > $row->montant</td>
<td>$row->dateAjout </td>
<td > $row->dateModif</td>
<td>$etat</td>
<td>".traitementTemps($row->temps,$row->dateAjout)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('Sortantes'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$mydem;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeMembres2" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Catégorie')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Statut')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Statut')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
if($type==$this->lang->line('Adhésion')){
$etat = $this->lang->line("Non traitée");
if($row->etat==1){
$etat = $this->lang->line("traitée");
}
$code = $row->code;
if($row->code==$this->session->userdata('member_code')){
$code = $this->lang->line('Vous');
}
echo "<tr>
<td> $row->phone </td>
<td >$row->categorie </td>
<td>$code</td>
<td>$row->dateAjout </td>
<td > $row->dateModif</td>
<td>$etat</td>
<td>".traitementTemps($row->temps,$row->dateAjout)."</td>
</tr>";}else{
$etat = $this->lang->line("Non traitée");
if($row->statut==1){
$etat = $this->lang->line("Acceptée");
}else if($row->statut == 2){
$etat = $this->lang->line("Annulée");
}
$origin = $row->codeMembre;
$destination = $row->codeParrain;
if($row->codeMembre==$this->session->userdata('member_code')){
$origin = $this->lang->line('Vous');
}
if($row->codeParrain==$this->session->userdata('member_code')){
$destination = $this->lang->line('Vous');
}
echo "<tr>
<td > $row->montant</td>
<td>$row->dateAjout </td>
<td > $row->dateModif</td>
<td>$etat</td>
<td>".traitementTemps($row->temps,$row->dateAjout)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
?>
</table>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('entrantes'); ?> <?= $this->lang->line('les plus rapidement traitées'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$tab_fastDemande;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeDemandesRapides" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Catégorie')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Membre')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
$superviseur = $row->superviseur;
if($row->superviseur==$this->session->userdata('member_code')){
$superviseur = $this->lang->line('Vous');
}
if($type==$this->lang->line('Adhésion')){
$etat = $this->lang->line("Non traitée");
if($row->etat==1){
$etat = $this->lang->line("traitée");
}
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";}else{
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->montant</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('Sortantes'); ?> <?= $this->lang->line('les plus rapidement traitées'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$tab_fastDemande_s;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeDemandesRapides" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Membre')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
$superviseur = $row->superviseur;
if($row->superviseur==$this->session->userdata('member_code')){
$superviseur = $this->lang->line('Vous');
}
if($type==$this->lang->line('Adhésion')){
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";}else{
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->montant</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('entrantes'); ?> <?= $this->lang->line('les plus tardivement traitées'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$tab_slowDemande;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeDemandesTardives" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Contact')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Membre')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
$superviseur = $row->superviseur;
if($row->superviseur==$this->session->userdata('member_code')){
$superviseur = $this->lang->line('Vous');
}
if($type==$this->lang->line('Adhésion')){
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";}else{
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->montant</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('Sortantes'); ?> <?= $this->lang->line('les plus tardivement traitées'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$tab_slowDemande_s;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeDemandesTardives" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Contact')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Membre')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
$superviseur = $row->superviseur;
if($row->superviseur==$this->session->userdata('member_code')){
$superviseur = $this->lang->line('Vous');
}
if($type==$this->lang->line('Adhésion')){
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";}else{
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->montant</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
<?php
}else{
?>
<div class="col-md-12">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$list;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeMembres" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Catégorie')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Statut')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>".$this->lang->line('Reseau')."</th>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Emetteur')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Statut')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
if($type==$this->lang->line('Adhésion')){
$etat = $this->lang->line("Non traitée");
if($row->etat==1){
$etat = $this->lang->line("traitée");
}
$code = $row->code_membre;
if($row->code_membre==$this->session->userdata('member_code')){
$code = $this->lang->line('Vous');
}
echo "<tr>
<td> $row->phone </td>
<td >Super </td>
<td>$row->code_membre</td>
<td>$row->date_creation </td>
<td > $row->date_modified</td>
<td>$etat</td>
<td>".traitementTemps($row->temps,$row->date_creation)."</td>
</tr>";}else{
$etat = $this->lang->line("Non traitée");
if($row->statut==1){
$etat = $this->lang->line("Acceptée");
}else if($row->statut == 2){
$etat = $this->lang->line("Annulée");
}
$origin = $row->codeMembre;
$destination = $row->codeParrain;
if($row->codeMembre==$this->session->userdata('member_code')){
$origin = $this->lang->line('Vous');
}
if($row->codeParrain==$this->session->userdata('member_code')){
$destination = $this->lang->line('Vous');
}
echo "<tr>
<td> $row->reseau</td>
<td> $row->phone </td>
<td >$origin </td>
<td>$destination</td>
<td > $row->montant</td>
<td>$row->dateAjout </td>
<td > $row->dateModif</td>
<td>$etat</td>
<td>".traitementTemps($row->temps,$row->dateAjout)."</td>
</tr>";}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
?>
</table>
</div>
</div>
</div>
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('les plus rapidement traitées'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$tab_fastDemande;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeDemandesRapides" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Téléphone utilisateur')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Membre')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
$superviseur = $row->superviseur;
if($row->superviseur==$this->session->userdata('member_code')){
$superviseur = $this->lang->line('Vous');
}
if($type==$this->lang->line('Adhésion')){
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";}else{
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->montant</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
<div class="col-md-6">
<div class="box">
<?php
if($alert=="ok") {
if(!$success=="ok"){
?>
<div class='alert alert-danger alert-dismissible'>
<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button>
<h4><i class='icon fa fa-ban'></i> Error!</h4>
<?= $message; ?>
</div>
<?php
} else {
?>
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
<?= $message; ?>
</div>
<?php
}
}
?>
<div class="box-header with-border">
<h3 class="box-title"><?= $this->lang->line('Demandes'); ?> <?= $type ?> <?= $this->lang->line('les plus tardivement traitées'); ?></h3>
</div>
<div class="box-body" style="overflow-x:auto;">
<?php
$result=$tab_slowDemande;
if($result!=false){
$numrows=$result->num_rows();
$num = 0;
if ($numrows > 0) {
?>
<table id="listeDemandesTardives" class="table table-bordered table-striped table-modified">
<thead>
<?php
if($type==$this->lang->line('Adhésion')){
echo "
<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Contact')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>"; }else{
echo "<tr class='label-primary'>
<th>N°</th>
<th>".$this->lang->line('Membre')."</th>
<th>".$this->lang->line('Parrain')."</th>
<th>".$this->lang->line('Montant')."</th>
<th>".$this->lang->line('Date de la demande')."</th>
<th>".$this->lang->line('Date de traitement')."</th>
<th>".$this->lang->line('Délai de traitement')."</th>
</tr>";
}
?>
</thead>
<tbody>
<?php
$site_url = base_url();
$url = base_url('Listes_members/modif');
// output data of each row
foreach($result->result() as $row) {
$num++;
$superviseur = $row->superviseur;
if($row->superviseur==$this->session->userdata('member_code')){
$superviseur = $this->lang->line('Vous');
}
if($type==$this->lang->line('Adhésion')){
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";}else{
echo "<tr>
<td>$num</td>
<td>$row->emetteur</td>
<td>$superviseur</td>
<td>$row->montant</td>
<td>$row->dateA</td>
<td>$row->dateM</td>
<td>".duree($row->temps)."</td>
</tr>";
}
}
?>
</tbody>
<?php
} else {
echo $this->lang->line('Aucune demande');
}
}else{
echo $this->lang->line('Aucune demande');
}
$this->db->close();
?>
</table>
</div>
</div>
</div>
<?php
}
?>
</div>
</section>
</div>
<!-- jQuery 3 -->
<script src="<?= base_url('bower_components/jquery/dist/jquery.min.js') ?>"></script>
<!-- Bootstrap 3.3.7 -->
<script src="<?= base_url('bower_components/bootstrap/dist/js/bootstrap.min.js') ?>"></script>
<!-- DataTables -->
<script src="<?= base_url('bower_components/datatables.net/js/jquery.dataTables.min.js') ?>"></script>
<script src="<?= base_url('bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js') ?>"></script>
<!-- SlimScroll -->
<script src="<?= base_url('bower_components/jquery-slimscroll/jquery.slimscroll.min.js') ?>"></script>
<!-- FastClick -->
<script src="<?= base_url('bower_components/fastclick/lib/fastclick.js') ?>"></script>
<!-- AdminLTE App -->
<script src="<?= base_url('dist/js/adminlte.min.js') ?>"></script>
<!-- AdminLTE for demo purposes -->
<script src="<?= base_url('dist/js/demo.js') ?>"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment-with-locales.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/plug-ins/1.10.19/sorting/datetime-moment.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/plug-ins/1.10.20/dataRender/datetime.js"></script>
<script>
$(function () {
const lang = $('#picker').data('lang');
const format = lang === 'french' ? 'fr' : 'en';
moment.updateLocale(moment.locale(format), { invalidDate: "" }); // Blank text when is invalid date
$('#listeMembres').DataTable({
"aaSorting": [[ 3, "desc" ]]
});
$('#listeDemandesRapides').DataTable({
searching: false, paging: false, info: false,
"aaSorting": [[ 4, "desc" ]],
"columnDefs": [ {
targets: [4,5],
render: $.fn.dataTable.render.moment( 'YYYY-MM-DD HH:mm:ss' , 'D MMMM YYYY HH:mm:ss', format)
}]
});
$('#listeDemandesTardives').DataTable({
searching: false, paging: false, info: false,
"aaSorting": [[ 3, "desc" ]],
"columnDefs": [ {
targets: [4,5],
render: $.fn.dataTable.render.moment( 'YYYY-MM-DD HH:mm:ss' , 'D MMMM YYYY HH:mm:ss', format)
}]
});
$('#listeMembres1').DataTable({
"aaSorting": [[ 3, "desc" ]],
"columnDefs": [ {
targets: [3,4],
render: $.fn.dataTable.render.moment( 'YYYY-MM-DD HH:mm:ss' , 'D MMMM YYYY HH:mm:ss', format),
"defaultContent": ""
}]
});
$('#listeMembres2').DataTable({
"aaSorting": [[ 1, "desc" ]],
"columnDefs": [ {
targets: [1,2],
render: $.fn.dataTable.render.moment( 'YYYY-MM-DD HH:mm:ss' , 'D MMMM YYYY HH:mm:ss', format)
}]
});
});
</script>
<script type="text/javascript">
var startDate;
var endDate;
function GetURLParameter(sParam)
{
var sPageURL = window.location.search.substring(1);
var sURLVariables = sPageURL.split('&');
for (var i = 0; i < sURLVariables.length; i++)
{
var sParameterName = sURLVariables[i].split('=');
if (sParameterName[0] == sParam)
{
return decodeURIComponent(sParameterName[1]);
}
}
}
$(function() {
var start = moment().subtract(29, 'days');
var end = moment();
startDate = start;
endDate = end;
function cb(start, end) {
$('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
startDate = start;
endDate = end;
}
$('#reportrange').daterangepicker({
startDate: start,
endDate: end,
ranges: {
'Today': [moment(), moment()],
'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days': [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month': [moment().startOf('month'), moment().endOf('month')],
'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
}
}, cb);
cb(start, end);
});
$(function() {
const type = $('#picker').data('type');
const category = $('#picker').data('category');
const lang = $('#picker').data('lang');
$('input[name="daterange"]').daterangepicker({
opens: 'left',
autoUpdateInput: false,
locale: {
format: lang === 'french' ? 'DD-MM-YYYY' : 'YYYY-MM-DD',
cancelLabel: 'Clear'
}
}, function(start, end, label) {
const debut = start.format('YYYY-MM-DD');
const fin = end.format('YYYY-MM-DD');
const user_geo = GetURLParameter("u");
if(category == 'super'){
if(type == 'credit'){
window.location.replace("<?= base_url('Superviseur_dash/getDemandes')?>"+"?d="+debut+"&f="+fin+"&u="+user_geo);
}else if (type == 'adhesion'){
window.location.replace("<?= base_url('Superviseur_dash/getDemandesAd')?>"+"?d="+debut+"&f="+fin);
}
}else if (category == 'hyper'){
if(type == 'credit'){
window.location.replace("<?= base_url('Hyperviseur_dash/getDemandes')?>"+"?d="+debut+"&f="+fin+"&u="+user_geo);
}else if (type == 'adhesion'){
window.location.replace("<?= base_url('Hyperviseur_dash/getDemandesAd')?>"+"?d="+debut+"&f="+fin);
}
}
});
$('input[name="daterange"]').on('cancel.daterangepicker', function(ev, picker) {
//do something, like clearing an input
$('#daterange').val('');
if(category == 'super'){
if(type == 'credit'){
window.location.replace("<?= base_url('Superviseur_dash/getDemandes')?>"+"?d="+debut+"&f="+fin+"&u="+user_geo);
}else if (type == 'adhesion'){
window.location.replace("<?= base_url('Superviseur_dash/getDemandesAd')?>"+"?d="+debut+"&f="+fin);
}
}else if (category == 'hyper'){
if(type == 'credit'){
window.location.replace("<?= base_url('Hyperviseur_dash/getDemandes')?>"+"?d="+debut+"&f="+fin+"&u="+user_geo);
}else if (type == 'adhesion'){
window.location.replace("<?= base_url('Hyperviseur_dash/getDemandesAd')?>"+"?d="+debut+"&f="+fin);
}
}
});
});
</script>
<script type='text/javascript'>
$(document).ready(function(){
$('#pays').change(function(){
var pays = $(this).val();
$.ajax({
url:'<?= base_url('Admin/getHypByPays')?>',
type: 'post',
data: {pays: pays},
dataType: 'json',
success: function(data){
var len = data.length;
if(len > 0){
var select = document.getElementById('hyper');
if(select===null){
var grpPays = document.getElementById('grp-pays');
$(grpPays).empty();
$(grpPays).append("<select class='form-control input-lg' name='hyper' required id='hyper'></select>");
select = document.getElementById('hyper');
}
$(select).empty();
for (var i in data) {
$(select).append('<option value=' + data[i].code_membre + '>' + data[i].lastname +'-' + data[i].network + ' ('+ data[i].code_membre +')</option>');
}
var code = data[0].code_membre;
$.ajax({
url:'<?= base_url('Admin/getVilleByHyp')?>',
type: 'post',
data: {code: code,pays:pays},
dataType: 'json',
success: function(list){
var len = list.length;
if(len > 0){
var select = document.getElementById('ville');
if(select===null){
var grpVille = document.getElementById('grp-ville');
$(grpVille).empty();
$(grpVille).append("<select class='form-control input-lg' name='ville' required id='ville'></select>");
select = document.getElementById('ville');
}
$(select).empty();
for (var i in list) {
$(select).append('<option value=' + list[i].town_id + '>' + list[i].town +'</option>');
}
}else{
var select = document.getElementById('ville');
$(select).empty();
}
}
});
}else{
var select = document.getElementById('hyper');
$(select).empty();
var select2 = document.getElementById('ville');
$(select2).empty();
}
}
});
});
$('#hyper').change(function(){
var code = $(this).val();
$.ajax({
url:'<?= base_url('Admin/getVilleByHyp')?>',
type: 'post',
data: {code: code},
dataType: 'json',
success: function(list){
var len = list.length;
if(len > 0){
var select = document.getElementById('ville');
$(select).empty();
for (var i in list) {
$(select).append('<option value=' + list[i].town_id + '>' + list[i].town +'</option>');
}
}else{
var select = document.getElementById('ville');
$(select).empty();
}
}
});
});
});
</script>