public function ajaxclasse() { $json = array(); $view = new View(); //Onglet 1 $eleves = $this->Inscription->getInscrits($this->request->idclasse, $this->session->anneeacademique); $view->Assign("eleves", $eleves); //Renvoyer un tableau contenant les id des eleve redoublant $array_of_redoublants = $this->Classe->getRedoublants($this->request->idclasse, $this->session->anneeacademique, true); $view->Assign("array_of_redoublants", $array_of_redoublants); $json[0] = $view->Render("classe" . DS . "ajax" . DS . "onglet1", false); //Onglet 2 $enseignants = $this->Enseignement->getEnseignements($this->request->idclasse); $view->Assign("enseignants", $enseignants); $json[1] = $view->Render("classe" . DS . "ajax" . DS . "onglet2", false); //Onglet 3 $ens = $this->Emplois->getEmplois($this->request->idclasse); $view->Assign("enseignements", $ens); $horaire = $this->Horaire->selectAll(); $heure_debut = array(); foreach ($horaire as $line) { $heure_debut[] = substr($line["HEUREDEBUT"], 0, strlen($line["HEUREDEBUT"]) - 3); } $view->Assign("horaire", $horaire); $view->Assign("heure_debut", json_encode($heure_debut)); # Onglet 4 $soldes = $this->Classe->getSoldeEleves($this->request->idclasse); $view->Assign("soldes", $soldes); $montanfraisapplicable = $this->Frais->getTotalFraisApplicables($this->request->idclasse)['MONTANTAPPLICABLE']; $view->Assign("montanfraisapplicable", $montanfraisapplicable); $json[2] = $view->Render("classe" . DS . "ajax" . DS . "onglet3", false); # Rendu des onglets $json[3] = $view->Render("classe" . DS . "ajax" . DS . "onglet4", false); $classe_parametre = $this->Classeparametre->findSingleRowBy(["CLASSE" => $this->request->idclasse]); $json[4] = $classe_parametre['NOMPERSONNEL'] . " " . $classe_parametre['PRENOMPERSONNEL']; $json[5] = $classe_parametre['NOMRESPONSABLE'] . " " . $classe_parametre['PRENOMRESPONSABLE']; $json[6] = $classe_parametre['NOMADMIN'] . " " . $classe_parametre['PRENOMADMIN']; $json[7] = count($eleves); $json[8] = moneyString($this->Frais->getClasseTotalFrais($this->request->idclasse)['TOTALFRAIS']) . " fcfa"; # onglet 5 : Notification financiere ou lettre de rappel $notifications = $this->Messagerappel->selectAll(); $view->Assign("notifications", $notifications); $json[9] = $view->Render("classe" . DS . "ajax" . DS . "notificationfinanciere", false); echo json_encode($json); }
?> </div> <div id="onglet2" class="onglet" style="display: none; height: 90%;"> <table class="dataTable" id="tableTotaux"> <thead><tr><th>Montant non validée</th><th>Montant perçu</th><th>Montant validé</th></tr></thead> <tbody> <tr style="text-align: right;"><td><?php echo moneyString($totaux['MONTANTNONVALIDE']); ?> </td> <td><?php echo moneyString($totaux['MONTANTNONPERCU']); ?> </td> <td><?php echo moneyString($totaux['MONTANTVALIDE']); ?> </td> </tr> </tbody> </table> </div> <div id="onglet3" class="onglet" style="display: none; height: 90%;"> <?php echo $operationSupprimes; ?> </div> </div> <div class="navigation"> </div>
# date de recu $pdf->SetFillColor(211, 211, 211); # $this->SetTextColor(255); $pdf->SetDrawColor(128, 0, 0); $d = new DateFR($operation['DATETRANSACTION']); # Classe de l'eleve $pdf->WriteHTMLCell(0, 0, $x + 135, $y + 3, "<b>Classe : " . $classe['NIVEAUHTML'] . "</b>"); $daterecu = '<b>' . $d->getDate() . " " . $d->getMois(3) . " " . $d->getYear() . " " . $d->getTime() . '</b>'; $pdf->WriteHTMLCell(0, 0, $x + 135, $y + 10, "<b>Montant : # " . moneyString($operation['MONTANT']) . "#</b>", 1, 1, true); $pdf->WriteHTMLCell(0, 0, $x + 135, $y + 15, $daterecu); $contenu = '<span style="width: 20%; text-align: left">Reçu de </span> : ' . $operation['NOMEL'] . " " . $operation['PRENOMEL'] . '<br/> <span style="width: 20%; text-align: left">Pour </span> : <span class="recu_libelle" >' . $operation['DESCRIPTION'] . '</span><br/> <span style="width: 20%;text-align: left">MONTANT</span> : ' . moneyString($operation['MONTANT']) . ' <em>fcfa</em> <span style="font-size: 12px"><i>(' . enLettre($operation['MONTANT']) . ' franc cfa)</i></span><br/> <span style="width: 20%;text-align: left">RESTE</span> : ' . moneyString($restant) . ' <em>fcfa</em> <span style="font-size: 12px"><i>(' . enLettre($restant) . ' franc cfa)</i></span><br/>'; $pdf->WriteHTMLCell(0, 0, $x, $y + 22, $contenu); $infosresp = 'S/C ' . $operation['CIVILITEREP'] . " " . $operation['NOMREP'] . " " . $operation['PRENOMREP'] . '<br/>Tél : ' . $operation['PORTABLEREP']; $pdf->WriteHTMLCell(0, 0, $x, $y + 50, $infosresp); /* $barrecode = SITE_ROOT . "public/tmp/barcode_upca.png"; $pdf->Image($barcode, 80, 50, 30, '', '', '', 'T', false, 300, '', false, false, 0, false, false, false); //echo $barcode; */ $pdf->write1DBarcode($operation['REFCAISSE'], 'C128A', $x + 60, $y + 60, '', 8, 0.4); $pdf->setFont("Times", "", 8); $pdf->WriteHTMLCell(0, 0, $x + 130, $y + 40, "Enreg. par : " . $enregistreur['CIVILITE'] . ' ' . $enregistreur['NOM']); $pdf->WriteHTMLCell(0, 0, $x + 130, $y + 55, "Perçu. par : " . $percepteur['CIVILITE'] . ' ' . $percepteur['NOM']); $d->setSource($operation['DATEPERCEPTION']); $pdf->WriteHTMLCell(0, 0, $x + 150, $y + 60, $d->getDate() . " " . $d->getMois(3) . " " . $d->getYear() . " " . $d->getTime()); $pdf->setFont("Times", "", 7); $d->setSource(date("Y-m-d H:i:s", time()));
$d = new DateFR($f['ECHEANCES']); $echeance = $d->getJour(3) . " " . $d->getDate() . "-" . $d->getMois() . "-" . $d->getYear(); echo "<tr><td>" . $f['DESCRIPTION'] . "</td><td align='right'>" . moneyString($f['MONTANT']) . "</td><td>" . $echeance . "</td>" . "<td align = 'center'>"; if (isAuth(510)) { echo "<img style = 'cursor:pointer' src = \"" . SITE_ROOT . "public/img/delete.png\" " . "onclick = \"supprimerFrais('" . $f['IDFRAIS'] . "')\" /> "; } if (isAuth(511)) { echo "<img id = 'img-edit' style = 'cursor:pointer' src = '" . img_edit() . "' " . "onclick = \"openEditForm('" . $f['IDFRAIS'] . "')\" />"; # Ajout des input hidden pour la modification echo "<input type='hidden' name='description" . $f['IDFRAIS'] . "' value='" . $f['DESCRIPTION'] . "' />"; echo "<input type='hidden' name='montant" . $f['IDFRAIS'] . "' value ='" . $f['MONTANT'] . "' />"; echo "<input type='hidden' name='echeances" . $f['IDFRAIS'] . "' value='" . $f['ECHEANCES'] . "' />"; } echo "</td></tr>"; } echo "<tr><td>TOTAL</td><td align='right'>" . moneyString($montanttotal) . "</td><td><td></tr>"; ?> </tbody> </table> <script> if (!$.fn.DataTable.isDataTable("#fraisTable")) { $("#fraisTable").DataTable({ "bInfo": false, "scrollY": $(".page").height() - 100, "searching": false, "paging": false, "columns": [ null, {"width": "15%"}, {"width": "20%"},
<?php if (!empty($info)) { echo $info; } ?> </blink></div> <table class="dataTable" id="sauvegardeTable"> <thead><tr><th>N°</th><th>Description</th><th>Taille</th><th></th><th></th></tr></thead> <tbody> <?php $i = 1; $d = new DateFR(); if (!empty($sauvegardes)) { foreach ($sauvegardes as $save) { $d->setSource($save['DATESAUVEGARDE']); echo "<tr><td style='text-align:center'>" . $i . "</td><td>Sauvegarde des données " . $save['DESCRIPTION'] . " : " . $d->getDate() . " " . $d->getMois(3) . " " . $d->getYear() . " à " . $d->getTime() . "</td>" . "<td style='text-align:right'>" . substr(moneyString($save['TAILLE']), 0, -3) . "KB</td>" . "<td style='text-align:center'>" . "<img title='Telecharger cette sauvegarde' style='cursor:pointer' " . "onclick='telechargerSauvegarde(" . $save['IDSAUVEGARDE'] . ")' src='" . img_download() . "' />" . " <img title='Restaurer cette sauvegarde' src='" . img_restaure() . "' style='cursor:pointer' " . "onclick='restaurerSauvegarde(" . $save['IDSAUVEGARDE'] . ")' /></td>" . "<td style='text-align:center'><img style='cursor:pointer' onclick='supprimerSauvegarde(" . $save['IDSAUVEGARDE'] . ")' src='" . img_delete() . "'>" . "</td></tr>"; $i++; } } ?> </tbody> </table> <div style="margin: 10px;text-align: center"> <input style="width: 350px; border: 2px outset buttonface; margin:0" type="button" value="Effectuer une nouvelle sauvegarde" onclick="nouvelleSauvegarde()"/> </div> <script> $(document).ready(function () { if (!$.fn.DataTable.isDataTable("#sauvegardeTable")) { $("#sauvegardeTable").DataTable({ bInfo: false,
} } else { echo "<img style='cursor:pointer' src='" . img_valider_disabled() . "' /> "; } if (peutSupprimerLesOperationsCaisses()) { echo "<img style='cursor:pointer' src='" . img_delete() . "' " . "onclick=\"document.location='" . Router::url("caisse", "delete", $op['IDCAISSE']) . "'\" />"; } else { echo "<img src='" . img_delete_disabled() . "' />"; } echo "</td></tr>"; $montant += intval($op['MONTANT']); } ?> <tr><td></td><td style='font-weight: bold'>TOTAL</td><td></td><td></td> <td style="text-align: right"><?php echo moneyString($montant); ?> </td> <td></td><td></td><td></td></tr> </tbody> </table> <script> $(document).ready(function () { if (!$.fn.DataTable.isDataTable("#tableOperation")) { $("#tableOperation").DataTable({ scrollY : $(".page").height() - 175, columns: [ {"width": "7%"}, null, {"width": "12%"}, null,
<th width="5%">N°</th><th width ="10%">Mle</th><th width ="35%">Noms & Prénoms</th> <th width ="15%">Redoublant.</th><th align="center" width ="15%">Total versé</th> <th width ="15%" align="center">Solde</th> <th width ="7%"></th></tr></thead><tbody> EOD; if (!is_array($array_of_redoublants)) { $array_of_redoublants = array(); } $i = 1; foreach ($soldes as $scol) { if (in_array($scol['IDELEVE'], $array_of_redoublants)) { $redoublant = "OUI"; } else { $redoublant = "NON"; } $corps .= '<tr><td width="5%">' . $i . '</td><td width ="10%" style = "border-bottom:1px solid #000">' . $scol['MATRICULE'] . '</td>' . '<td width ="35%" style = "border-bottom:1px solid #000">' . $scol['NOM'] . ' ' . $scol['PRENOM'] . '</td>' . '<td align="center" width ="15%" style = "border-bottom:1px solid #000">' . $redoublant . '</td>' . '<td align="right" width ="15%" style = "border-bottom:1px solid #000">' . moneyString($scol['MONTANTPAYE']) . '</td>'; $corps .= '<td align="right" width ="15%" style = "border-bottom:1px solid #000">' . moneyString($scol['MONTANTPAYE'] - $montanfraisapplicable) . '</td>'; if ($scol['MONTANTPAYE'] >= $montanfraisapplicable) { $corps .= '<td width ="7%" style="background-color:#99ff99;text-align:center;border-bottom:1px solid #000">#C#</td>'; } else { $corps .= '<td width ="7%" style="background-color:#ff9999;text-align:center;border-bottom:1px solid #000">#D#</td>'; } $corps .= '</tr>'; $i++; } $corps .= "</tbody></table>"; $pdf->SetFont("Times", '', 10); //Impression du tableau //$pdf->writeHTML($corps, true, false, false, false, ' '); $pdf->WriteHTMLCell(0, 5, 10, $y + 35, $corps); $pdf->Output();
</div> <?php } ?> <table class="dataTable" id="tableOperation"> <thead><tr><th>Date</th><th>Ref. Transac.</th><th>Ref. Caisse</th><th>Description</th><th>Montant</th> <th>Statut</th><th></th><th></th></tr></thead> <tbody> <?php $d = new DateFR(); foreach ($operations as $op) { $d->setSource($op['DATETRANSACTION']); # $type = ($op['TYPE'] == "C" ? "CREDIT" : "DEBIT"); $type = $op['TYPE']; echo "<tr><td>" . $d->getDate() . '-' . $d->getMois(3) . "-" . $d->getYear(2) . "</td>" . "<td>" . $op['NIVEAUHTML'] . ' ' . $op['REFTRANSACTION'] . "</td><td>" . $op['REFCAISSE'] . "</td>" . '<td>' . $op['DESCRIPTION'] . '</td><td align="right">' . moneyString($op['MONTANT']) . "</td>"; if ($op['VALIDE'] == 0) { echo "<td style='background-color:#ff9999' align='center'>En cours</td>"; } else { echo "<td style='background-color:#99ff99' align='center'>Validée</td>"; } echo "<td align='center'><img onclick = \"tooltip_on(event,'" . $op['IDCAISSE'] . "')\"" . " style='cursor:pointer' src='" . img_info() . "' />"; # Droit d'impression des recu if (isAuth(522)) { if (!empty($op['PERCUPAR'])) { echo " <img style='cursor:pointer' title='Imprimer le recu de cette operation caisse' " . "src='" . img_print() . "' onclick=\"document.location='" . Router::url("caisse", "recu", $op['IDCAISSE']) . "'\">"; } else { echo " <img style='cursor:pointer' title='Certifier que vous avez recu ce montant' " . "src='" . img_accept() . "' onclick=\"percuRecu(" . $op['IDCAISSE'] . ")\">"; } } echo "</td>";
} else { $balance -= $op['DEBIT']; $totalperiode -= $op['DEBIT']; } $d->setSource($op['DATETR']); $corps .= '<tr> <td width ="' . $col[0] . '%" >' . $d->getDate() . " " . $d->getMois(3) . " " . $d->getYear() . '</td> <td width ="' . $col[1] . '%" >' . $op['REFCAISSE'] . '</td> <td width ="' . $col[2] . '%" >' . $op['REFTRANSACTION'] . '/' . $op['NIVEAUHTML'] . '</td> <td width ="' . $col[3] . '%" >' . $op['LIBELLE'] . '</td> <td align="right" width ="' . $col[4] . '%" >' . moneyString($op['DEBIT']) . '</td> <td align="right" width ="' . $col[5] . '%" >' . moneyString($op['CREDIT']) . '</td> <td align="right" width ="' . $col[6] . '%" >' . moneyString(abs($balance)); if ($balance > 0) { $corps .= " cr"; } $corps .= '</td></tr>'; $month = date("n", strtotime($op['DATETR'])); } $corps .= '<tr style="font-weight:bold"> <td colspan="2" style="border-top:1px solid #000;border-bottom:1px solid #000;">' . $compte['CODE'] . '</td> <td colspan="4" align="center" style="border-top:1px solid #000;border-bottom:1px solid #000;"><b>Total pour compte </b></td> <td align="right" style="border-top:1px solid #000;border-bottom:1px solid #000;" >' . moneyString(abs($balance)); if ($balance > 0) { $corps .= " cr"; } $corps .= '</td></tr>'; $corps .= '</tbody></table>'; $pdf->WriteHTMLCell(0, 5, $x, $y + 20, $corps); $pdf->lastPage(); $pdf->Output();
<thead><tr><th>Matricule</th><th>Noms et Prénoms</th> <th>Redoublant</th><th>Total versé</th><th>Solde</th><th></th><th></th></tr></thead> <tbody> <?php if (!is_array($array_of_redoublants)) { $array_of_redoublants = array(); } foreach ($soldes as $el) { echo "<tr><td>" . $el['MATRICULE'] . "</td><td>" . $el['NOM'] . " " . $el['PRENOM'] . "</td>"; if (in_array($el['IDELEVE'], $array_of_redoublants)) { echo "<td align = 'center'><input type = 'checkbox' disabled checked /></td>"; } else { echo "<td align = 'center'><input type = 'checkbox' disabled /></td>"; } echo "<td align ='right'>" . moneyString($el['MONTANTPAYE']) . "</td>"; echo "<td align ='right'>" . moneyString($el['MONTANTPAYE'] - $montanfraisapplicable) . "</td>"; if ($el['MONTANTPAYE'] >= $montanfraisapplicable) { echo "<td style='background-color:#99ff99;text-align:center'>#C#</td>"; } else { echo "<td style='background-color:#ff9999;text-align:center'>#D#</td>"; } echo "<td align ='center'><img style='cursor:pointer' title='Imprimer le compte de cet élèves' " . "src='" . img_print() . "' onclick=\"imprimerCompte(" . $el['IDELEVE'] . ")\"></td>"; echo "</tr>"; } ?> </tbody> </table> <script> $(document).ready(function () { if (!$.fn.DataTable.isDataTable("#tableFinance")) { $("#tableFinance").DataTable({
$cols = [5, 10, 45, 10, 10, 10]; //Corps du PDF $corps = '<table border = "1" cellpadding = "5"><thead><tr style = "font-weight:bold"> <th width="' . $cols[0] . '%">N°</th><th width ="' . $cols[1] . '%">Mle</th>' . '<th width ="' . $cols[2] . '%">Noms & Prénoms</th> <th width ="' . $cols[3] . '%">Classes.</th>' . ' <th width ="' . $cols[3] . '%">Total Frais</th>' . '<th width ="' . $cols[4] . '%">Total payé</th> <th width ="' . $cols[5] . '%" align="center">Reste</th></tr></thead><tbody>'; $i = 1; $applicables = getMontantFraisApplicable($montantfraisapplicable); foreach ($soldes as $scol) { $condition = $scol['MONTANTPAYE'] < $applicables[$scol['IDCLASSE']]; if ($type === "credit") { $condition = !$condition; } if ($condition) { $corps .= '<tr><td width="' . $cols[0] . '%">' . $i . '</td>' . '<td width ="' . $cols[1] . '%" >' . $scol['MATRICULE'] . '</td>' . '<td width ="' . $cols[2] . '%" >' . $scol['NOM'] . ' ' . $scol['PRENOM'] . '</td>' . '<td width ="' . $cols[3] . '%" >' . $scol['NIVEAUHTML'] . '</td>' . '<td width ="' . $cols[3] . '%" align="right" >' . moneyString($applicables[$scol['IDCLASSE']]) . '</td>' . '<td width ="' . $cols[4] . '%" align="right" >' . moneyString($scol['MONTANTPAYE']) . '</td>'; $corps .= '<td width ="' . $cols[5] . '%" align="right">' . moneyString($scol['MONTANTPAYE'] - $applicables[$scol['IDCLASSE']]) . '</td>'; $corps .= '</tr>'; $i++; } } $corps .= "</tbody></table>"; $pdf->SetFont("Times", '', 8); //Impression du tableau //$pdf->writeHTML($corps, true, false, false, false, ' '); $pdf->WriteHTMLCell(0, 5, 20, $y + 10, $corps); $pdf->Output(); function getMontantFraisApplicable($montantfraisapplicable) { $applicable = array(); foreach ($montantfraisapplicable as $montant) { $applicable[$montant['CLASSE']] = $montant['MONTANTAPPLICABLE'];
$middle = PDF_MIDDLE; $d = new DateFR(); $dd = new DateFR(); $i = 0; foreach ($eleves as $el) { if ($el['MONTANTPAYE'] < $montantfraisapplicable['MONTANTAPPLICABLE']) { $i++; $pdf->SetFontSize(8); $pdf->writeHTMLCell(70, 50, LEFT_UP_CORNER, $y - 47 + 5, $header_gauche); $pdf->Image($pdf->getLogo(), 95, $y - 47 + 5, 35, '', '', '', 'T', false, 300, '', false, false, 0, false, false, false); $pdf->writeHTMLCell(50, 5, 156, $y - 47 + 5, $header_droit); $d->setSource($frais['ECHEANCES']); # Cmt creer une tabulation $pdf->setFont("Times", '', 12); $pdf->WriteHTMLCell(0, 5, $middle - 13, $y - 10, '<b style="text-decoration:underline">Lettre de rappel</b>'); $corps = '<p style="text-align:justify"> ' . ' ' . 'Cher parent de l\'élève <b>' . $el['NOM'] . ' ' . $el['PRENOM'] . '</b> de la classe de ' . $el['NIVEAUHTML'] . '; <b> Bien vouloir </b> s\'acquitter du frais <b>' . $frais['DESCRIPTION'] . ' (' . moneyString($montantfraisapplicable['MONTANTAPPLICABLE'] - $el['MONTANTPAYE']) . ')</b> ' . 'dont la date est fixée ce <b>' . $d->getJour() . ' ' . $d->getDate() . ' ' . $d->getMois() . ' ' . $d->getYear() . '</b>. ' . 'Passé ce delai, l\'administration de l\'établissement sera dans l\'obligation de <b>'; if ($el['SEXE'] === "M") { $corps .= 'le '; } else { $corps .= 'la '; } $corps .= 'mettre hors des cours.<b>'; $pdf->setFont("Times", '', 10); $pdf->WriteHTMLCell(0, 5, $x, $y, $corps); $corps = '<b>Sincère amitiés pour votre bonne compréhension.</b>'; $pdf->WriteHTMLCell(0, 5, $x + 50, $y + 15, $corps); $pdf->WriteHTMLCell(0, 5, $x + 120, $y + 20, 'Fait à Nkolfoulou1 le , ' . $dd->getDate() . ' ' . $dd->getMois(3) . ' ' . $dd->getYear()); $pdf->setFont("Times", '', 12); $pdf->WriteHTMLCell(0, 5, $x + 120, $y + 25, '<b style="text-decoration:underline">LA DIRECTRICE</b>'); if ($i === 3) { $pdf->AddPage();
<span style="width: 80px; text-align: left">Pour </span> : <span class="recu_libelle" ><?php echo $operation['DESCRIPTION']; ?> </span><br/> <span style="width: 80px;text-align: left">MONTANT</span> : <?php echo moneyString($operation['MONTANT']); ?> <em>fcfa</em> <span style="font-size: 14px"><i>(<?php echo enLettre($operation['MONTANT']); ?> franc cfa)</i></span><br/> <span style="width: 80px;text-align: left">RESTE</span> : <?php echo moneyString($restant); ?> <em>fcfa</em> <span style="font-size: 14px"><i>(<?php echo enLettre($restant); ?> franc cfa)</i></span><br/> </div> <div style="text-align: left !important;"> <span style="display: inline-block; float: left; width: 250px;top: 10px; position: relative;">S/C <?php echo $operation['CIVILITEREP'] . " " . $operation['NOMREP'] . " " . $operation['PRENOMREP']; ?> <br/> Tél : <?php echo $operation['PORTABLEREP']; ?>