Created
July 27, 2022 22:58
-
-
Save devnullone/bee0e9d2525e3fdec2cc219df8cb9424 to your computer and use it in GitHub Desktop.
Example CI4 MVC
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!-- Header Start--> | |
| <?php include('includes/header.php');?> | |
| <!-- Header End--> | |
| <!--begin::Content--> | |
| <div class="content d-flex flex-column flex-column-fluid" id="kt_content"> | |
| <!--begin::Container--> | |
| <!-- breadcrumb start --> | |
| <?php include('includes/breadcrumb.php');?> | |
| <!-- breadcrumb end --> | |
| <!-- begin:Entry --> | |
| <div class="d-flex flex-column-fluid"> | |
| <!--begin::Container--> | |
| <div class="container"> | |
| <div class="d-lg-flex flex-row-fluid"> | |
| <!-- Navbar Start--> | |
| <?php include('includes/navbar.php');?> | |
| <!-- Navbar End--> | |
| <div class="content-wrapper flex-row-fluid"> | |
| <div class="card card-custom"> | |
| <div class="card-header flex-wrap border-0 pt-6 pb-0"> | |
| <h2>Clients</h2> | |
| <div class="card-toolbar"> | |
| <!--begin::Button--> | |
| <a href="#" class="btn btn-primary font-weight-bolder" data-toggle="modal" data-target="#addModal"> | |
| <span class="svg-icon svg-icon-md"> | |
| <!--begin::Svg Icon | path:assets/media/svg/icons/Design/Flatten.svg--> | |
| <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"> | |
| <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"> | |
| <rect x="0" y="0" width="24" height="24"></rect> | |
| <circle fill="#000000" cx="9" cy="15" r="6"></circle> | |
| <path d="M8.8012943,7.00241953 C9.83837775,5.20768121 11.7781543,4 14,4 C17.3137085,4 20,6.6862915 20,10 C20,12.2218457 18.7923188,14.1616223 16.9975805,15.1987057 C16.9991904,15.1326658 17,15.0664274 17,15 C17,10.581722 13.418278,7 9,7 C8.93357256,7 8.86733422,7.00080962 8.8012943,7.00241953 Z" fill="#000000" opacity="0.3"></path> | |
| </g> | |
| </svg> | |
| <!--end::Svg Icon--> | |
| </span>Ajouter</a> | |
| <!--end::Button--> | |
| </div> | |
| </div> | |
| <div class="card-body"> | |
| <!--begin: Search Form--> | |
| <!--begin::Search Form--> | |
| <div class="mb-7"> | |
| <div class="row align-items-center"> | |
| <div class="col-lg-9 col-xl-8"> | |
| <div class="row align-items-center"> | |
| <div class="col-md-8 my-2 my-md-0"> | |
| <div class="input-icon"> | |
| <input type="text" class="form-control" placeholder="" id="kt_datatable_search_query"> | |
| <span> | |
| <i class="flaticon2-search-1 text-muted"></i> | |
| </span> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="col-lg-3 col-xl-4 mt-5 mt-lg-0"> | |
| <a href="#" class="btn btn-light-primary px-6 font-weight-bold">Search</a> | |
| </div> | |
| </div> | |
| </div> | |
| <!--end::Search Form--> | |
| <!--end: Search Form--> | |
| <!--begin: Datatable--> | |
| <div class="datatable datatable-bordered datatable-head-custom datatable-default datatable-primary datatable-loaded" id="kt_datatable" style=""> | |
| <table class="datatable-table" style="display: block;" id="clientTable"> <!--clientTable--> | |
| <thead class="datatable-head"> | |
| <tr class="datatable-row" style="left: 0px;"> | |
| <th data-field="RecordID" class="datatable-cell-center datatable-cell datatable-cell-check"> | |
| <span style="width: 20px;"> | |
| <label class="checkbox checkbox-single checkbox-all"> | |
| <input type="checkbox"> | |
| <span></span> | |
| </label> | |
| </span> | |
| </th> | |
| <th data-field="OrderID" class="datatable-cell datatable-cell-sort"> | |
| <span style="width: 100px;">Nom Prenom</span> | |
| </th> | |
| <th data-field="Status" class="datatable-cell datatable-cell-sort"> | |
| <span style="width: 70;">Telephone</span> | |
| </th> | |
| <th data-field="Type" data-autohide-disabled="false" class="datatable-cell datatable-cell-sort"> | |
| <span style="width: 150px;">Adresse</span> | |
| </th> | |
| <th data-field="Type" data-autohide-disabled="false" class="datatable-cell datatable-cell-sort"> | |
| <span style="width: 80px;">montant</span> | |
| </th> | |
| <th data-field="Actions" data-autohide-disabled="false" class="datatable-cell datatable-cell-sort"> | |
| <span style="width: 120px;">Actions</span> | |
| </th> | |
| </tr> | |
| </thead> | |
| <tbody class="datatable-body" style=""> | |
| <?php foreach($client_detail as $row){ | |
| ?> | |
| <tr id="<?php echo $row['id']; ?>" data-row="0" class="datatable-row" style="left: 0px;"> | |
| <td class="datatable-cell-center datatable-cell datatable-cell-check" data-field="RecordID" aria-label="1"> | |
| <span style="width: 20px;"> | |
| <label class="checkbox checkbox-single"> | |
| <input type="checkbox" value="<?php echo $row['id']; ?>"> <span></span> | |
| </label> | |
| </span> | |
| </td> | |
| <td data-field="nomprenom" aria-label="<?php echo $row['nom']; ?> <?php echo $row['prenom']; ?>" class="datatable-cell"> | |
| <span style="width: 100px;"> | |
| <?php echo $row['nom']; ?> <?php echo $row['prenom']; ?> | |
| </span> | |
| </td> | |
| <td data-field="telephone" aria-label="6" class="datatable-cell"> | |
| <span class="" style="width: 70px;"> | |
| <?php echo $row['telephone']; ?> | |
| </span> | |
| </td> | |
| <td data-field="adresse" data-autohide-disabled="false" aria-label="2" class="datatable-cell"> | |
| <span class="" style="width: 150px;"> | |
| <?php echo $row['adresse']; ?> | |
| </span> | |
| </td> | |
| <td data-field="montant" aria-label="6" class="datatable-cell"> | |
| <span class="" style="width: 70px;"> | |
| <?php echo $row['montant']; ?> | |
| </span> | |
| </td> | |
| <td data-field="Actions" data-autohide-disabled="false" aria-label="null" class="datatable-cell"> | |
| <span style="overflow: visible; position: relative; width: 120px;"> | |
| <a data-id="<?php echo $row['id']; ?>" class="btn btn-sm btn-clean btn-icon mr-2 btnVoir" title="Voir"> | |
| <span class="svg-icon svg-icon-md"><!--begin::Svg Icon | path:C:\wamp64\www\keenthemes\legacy\metronic\theme\html\demo9\dist/../src/media/svg/icons\General\Visible.svg--><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"><g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><rect x="0" y="0" width="24" height="24"/><path d="M3,12 C3,12 5.45454545,6 12,6 C16.9090909,6 21,12 21,12 C21,12 16.9090909,18 12,18 C5.45454545,18 3,12 3,12 Z" fill="#000000" fill-rule="nonzero" opacity="0.3"/><path d="M12,15 C10.3431458,15 9,13.6568542 9,12 C9,10.3431458 10.3431458,9 12,9 C13.6568542,9 15,10.3431458 15,12 C15,13.6568542 13.6568542,15 12,15 Z" fill="#000000" opacity="0.3"/></g></svg><!--end::Svg Icon--></span> | |
| </a> | |
| <a id="btnEdit" data-id="<?php echo $row['id']; ?>" class="btn btn-sm btn-clean btn-icon mr-2 btnEdit" title="Modifier"> | |
| <span class="svg-icon svg-icon-md"><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"> | |
| <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"> | |
| <rect x="0" y="0" width="24" height="24"></rect> | |
| <path d="M8,17.9148182 L8,5.96685884 C8,5.56391781 8.16211443,5.17792052 8.44982609,4.89581508 L10.965708,2.42895648 C11.5426798,1.86322723 12.4640974,1.85620921 13.0496196,2.41308426 L15.5337377,4.77566479 C15.8314604,5.0588212 16,5.45170806 16,5.86258077 L16,17.9148182 C16,18.7432453 15.3284271,19.4148182 14.5,19.4148182 L9.5,19.4148182 C8.67157288,19.4148182 8,18.7432453 8,17.9148182 Z" fill="#000000" fill-rule="nonzero" transform="translate(12.000000, 10.707409) rotate(-135.000000) translate(-12.000000, -10.707409) "></path> | |
| <rect fill="#000000" opacity="0.3" x="5" y="20" width="15" height="2" rx="1"></rect> | |
| </g></svg> | |
| </span> | |
| </a> | |
| <a href="#" id="btn_delete" data-id="<?php echo $row['id']; ?>" class="btn btn-sm btn-clean btn-icon btn_delete" title="Supprimer"> | |
| <span class="svg-icon svg-icon-md"> | |
| <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"> | |
| <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"> | |
| <rect x="0" y="0" width="24" height="24"></rect> | |
| <path d="M6,8 L6,20.5 C6,21.3284271 6.67157288,22 7.5,22 L16.5,22 C17.3284271,22 18,21.3284271 18,20.5 L18,8 L6,8 Z" fill="#000000" fill-rule="nonzero"></path> | |
| <path d="M14,4.5 L14,4 C14,3.44771525 13.5522847,3 13,3 L11,3 C10.4477153,3 10,3.44771525 10,4 L10,4.5 L5.5,4.5 C5.22385763,4.5 5,4.72385763 5,5 L5,5.5 C5,5.77614237 5.22385763,6 5.5,6 L18.5,6 C18.7761424,6 19,5.77614237 19,5.5 L19,5 C19,4.72385763 18.7761424,4.5 18.5,4.5 L14,4.5 Z" fill="#000000" opacity="0.3"></path> | |
| </g> | |
| </svg> | |
| </span> | |
| </a> | |
| </span> | |
| </td> | |
| </tr> | |
| <?php } | |
| ?> | |
| </tbody> | |
| </table> | |
| <div class="datatable-pager datatable-paging-loaded"> | |
| <ul class="datatable-pager-nav my-2 mb-sm-0"> | |
| <li> | |
| <a title="First" class="datatable-pager-link datatable-pager-link-first datatable-pager-link-disabled" data-page="1" disabled="disabled"> | |
| <i class="flaticon2-fast-back"></i> | |
| </a> | |
| </li> | |
| <li> | |
| <a title="Previous" class="datatable-pager-link datatable-pager-link-prev datatable-pager-link-disabled" data-page="1" disabled="disabled"> | |
| <i class="flaticon2-back"></i></a> | |
| </li> | |
| <li style="display: none;"> | |
| <input type="text" class="datatable-pager-input form-control" title="Page number"> | |
| </li> | |
| <li> | |
| <a class="datatable-pager-link datatable-pager-link-number datatable-pager-link-active" data-page="1" title="1">1</a> | |
| </li> | |
| <li> | |
| <a class="datatable-pager-link datatable-pager-link-number" data-page="2" title="2">2</a> | |
| </li> | |
| <li> | |
| <a class="datatable-pager-link datatable-pager-link-number" data-page="3" title="3">3</a> | |
| </li> | |
| <li> | |
| <a class="datatable-pager-link datatable-pager-link-number" data-page="4" title="4">4</a> | |
| </li> | |
| <li> | |
| <a class="datatable-pager-link datatable-pager-link-number" data-page="5" title="5">5</a> | |
| </li> | |
| <li> | |
| <a title="Next" class="datatable-pager-link datatable-pager-link-next" data-page="2"> | |
| <i class="flaticon2-next"></i> | |
| </a> | |
| </li> | |
| <li> | |
| <a title="Last" class="datatable-pager-link datatable-pager-link-last" data-page="10"><i class="flaticon2-fast-next"></i></a> | |
| </li> | |
| </ul> | |
| <div class="datatable-pager-info my-2 mb-sm-0"> | |
| <span class="datatable-pager-detail">Showing 1 - 10 of 100</span> | |
| </div> | |
| </div> | |
| </div> | |
| <!--end: Datatable--> | |
| <!--Ajouter Modal--> | |
| <div class="modal fade" id="addModal" data-backdrop="static" tabindex="-1" role="dialog" aria-labelledby="staticBackdrop" aria-hidden="true"> | |
| <div class="modal-dialog modal-dialog-centered" role="document"> | |
| <div class="modal-content"> | |
| <div class="modal-header"> | |
| <h5 class="modal-title" id="addModal">Ajouter Client</h5> | |
| <button type="button" class="close" data-dismiss="modal" aria-label="Close"> | |
| <i aria-hidden="true" class="ki ki-close"></i> | |
| </button> | |
| </div> | |
| <div class="modal-body"> | |
| <form id="addClient" name="addClient" action="<?php echo site_url('client/store');?>" method="post"> | |
| <div class="form-group row"> | |
| <div class="col-sm-6"> | |
| <label>Nom:</label> | |
| <input type="text" id="nom" class="form-control" placeholder="ALI" name="nom"> | |
| </div> | |
| <div class="col-sm-6"> | |
| <label>Prenom:</label> | |
| <input type="text" id="prenom" class="form-control" placeholder="Grace" name="prenom" > | |
| </div> | |
| </div> | |
| <div class="form-group row"> | |
| <div class="col-sm-6"> | |
| <label>Téléphone:</label> | |
| <div class="input-group"> | |
| <input type="tel" id="telephone" class="form-control" placeholder="+228 90 85 53 01" name="telephone"> | |
| <div class="input-group-append"> | |
| <span class="input-group-text"> | |
| <i class="la la-phone"></i> | |
| </span> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="col-sm-6"> | |
| <label>Adresse:</label> | |
| <div class="input-group"> | |
| <input type="text" id="adresse" class="form-control" placeholder="53 Rue de la Liberation" name="adresse"> | |
| <div class="input-group-append"> | |
| <span class="input-group-text"> | |
| <i class="la la-map-marker"></i> | |
| </span> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="modal-footer"> | |
| <button type="reset" class="btn btn-light-primary font-weight-bold" data-dismiss="modal">Annuler</button> | |
| <button type="submit" name="submitButton" class=" btn btn-primary font-weight-bold">Enregistrer</button> | |
| </div> | |
| </form> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <!--Voir Modal--> | |
| <div class="modal fade" id="viewModal" data-backdrop="static" tabindex="-1" role="dialog" aria-labelledby="staticBackdrop" aria-hidden="true"> | |
| <div class="modal-dialog modal-dialog-centered" role="document"> | |
| <div class="modal-content"> | |
| <div class="modal-header"> | |
| <h5 class="modal-title" id="viewModal">Aperçu Client</h5> | |
| <button type="button" class="close" data-dismiss="modal" aria-label="Close"> | |
| <i aria-hidden="true" class="ki ki-close"></i> | |
| </button> | |
| </div> | |
| <div class="modal-body"> | |
| <div class="card card-custom gutter-b"> | |
| <!--begin::Body--> | |
| <div class="card-body pt-4"> | |
| <!--begin::Separator--> | |
| <div class="d-flex justify-content-end mb-5"> | |
| </div> | |
| <!--end::Separator--> | |
| <!--begin::User--> | |
| <div class="d-flex align-items-center"> | |
| <div class="symbol symbol-60 symbol-xxl-100 mr-5 align-self-start align-self-xxl-center"> | |
| <span class="symbol symbol-35"> | |
| <span class="symbol-label font-size-h5 font-weight-bold text-black bg-green-o-30"><i class="fa fa-user"></i></span> | |
| </span> | |
| <!-- <i class="symbol-badge bg-success"></i> --> | |
| </div> | |
| <div> | |
| <a class="font-weight-bold font-size-h5 text-dark-75 text-hover-primary"><span class="nom_view"></span> <span class="prenom_view"></span></a> | |
| <div class="text-muted">Client</div> | |
| </div> | |
| </div> | |
| <!--end::User--> | |
| <!--begin::View--> | |
| <div class="pt-8 pb-6"> | |
| <div class="d-flex align-items-center justify-content-between mb-2"> | |
| <span class="font-weight-bold mr-2">IDENTIFIANT:</span> | |
| <span class="text-muted"><span class="id_view"></span></span> | |
| </div> | |
| <div class="d-flex align-items-center justify-content-between mb-2"> | |
| <span class="font-weight-bold mr-2">TELEPHONE:</span> | |
| <span class="text-muted"><span class="telephone_view"></span></span> | |
| </div> | |
| <div class="d-flex align-items-center justify-content-between mb-2"> | |
| <span class="font-weight-bold mr-2">ADRESSE:</span> | |
| <span class="text-muted"><span class="adresse_view"></span></span> | |
| </div> | |
| <div class="d-flex align-items-center justify-content-between mb-2"> | |
| <span class="font-weight-bold mr-2">MONTANT:</span> | |
| <a class="text-muted text-hover-primary"><span class="montant_view"></span> <span>CFA</span></a> | |
| </div> | |
| </div> | |
| <!--end::View--> | |
| </div> | |
| <!--end::Body--> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <!--Modifier Modal--> | |
| <div class="modal fade" id="updateModal" data-backdrop="static" tabindex="-1" role="dialog" aria-labelledby="staticBackdrop" aria-hidden="true"> | |
| <div class="modal-dialog modal-dialog-centered" role="document"> | |
| <div class="modal-content"> | |
| <div class="modal-header"> | |
| <h5 class="modal-title" id="updateModal">Modification</h5> | |
| <button type="button" class="close" data-dismiss="modal" aria-label="Close"> | |
| <i aria-hidden="true" class="ki ki-close"></i> | |
| </button> | |
| </div> | |
| <div class="modal-body"> | |
| <form id="updateClient" name="updateClient" action="<?php echo site_url('client/update');?>" method="post"> | |
| <input type="hidden" name="hdnClientId" id="hdnClientId"/> | |
| <div class="form-group row"> | |
| <div class="col-sm-6"> | |
| <label>Nom:</label> | |
| <input type="text" id="txtNom" class="form-control" placeholder="" name="txtNom"> | |
| </div> | |
| <div class="col-sm-6"> | |
| <label>Prénom:</label> | |
| <input type="text" id="txtPrenom" class="form-control" placeholder="" name="txtPrenom" > | |
| </div> | |
| </div> | |
| <div class="form-group row"> | |
| <div class="col-sm-6"> | |
| <label>Telphone:</label> | |
| <div class="input-group"> | |
| <input type="tel" id="txtTelephone" class="form-control" placeholder="" name="txtTelephone"> | |
| <div class="input-group-append"> | |
| <span class="input-group-text"> | |
| <i class="la la-phone"></i> | |
| </span> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="col-sm-6"> | |
| <label>Adresse:</label> | |
| <div class="input-group"> | |
| <input type="text" id="txtAdresse" class="form-control" placeholder="" name="txtAdresse"> | |
| <div class="input-group-append"> | |
| <span class="input-group-text"> | |
| <i class="la la-map-marker"></i> | |
| </span> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="form-group row"> | |
| <div class="col-sm-12"> | |
| <label>Montant:</label> | |
| <div class="input-group"> | |
| <input type="tel" id="txtMontant" class="form-control" placeholder="" name="txtMontant"> | |
| <div class="input-group-append"> | |
| <span class="input-group-text"> | |
| <i class="la la-dollar-sign"></i> | |
| </span> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="modal-footer"> | |
| <button type="reset" class="btn btn-light-primary font-weight-bold" data-dismiss="modal">Annuler</button> | |
| <button type="submit" name="submitButton" class=" btn btn-primary font-weight-bold">Modifier</button> | |
| </div> | |
| </form> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <!--Suprimer Modal--> | |
| <div class="modal fade" id="deleteModal" data-backdrop="static" tabindex="-1" role="dialog" aria-labelledby="staticBackdrop" aria-hidden="true"> | |
| <div class="modal-dialog modal-dialog-centered" role="document"> | |
| <div class="modal-content"> | |
| <div class="modal-header"> | |
| <h5 class="modal-title" id="deleteModal">Supprimer Client</h5> | |
| <button type="button" class="close" data-dismiss="modal" aria-label="Close"> | |
| <i aria-hidden="true" class="ki ki-close"></i> | |
| </button> | |
| </div> | |
| <div class="modal-body"> | |
| <form id="addClient" name="addClient" action="<?php echo site_url('client/store');?>" method="post"> | |
| <div class="form-group row"> | |
| <div class="col-sm-12"> | |
| <input type="hidden" id="client_del_id" class="form-control"> | |
| </div> | |
| </div> | |
| </form> | |
| <h5>Veuillez confirmer la suppression</h5> | |
| </div> | |
| <div class="modal-footer"> | |
| <button type="reset" class="btn btn-light-primary font-weight-bold" data-dismiss="modal">Annuler</button> | |
| <button type="submit" id ="deleteconfirmed" name="submitButton" class=" btn btn-primary font-weight-bold deleteconfirmed">Supprimer</button> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <!--end::Container--> | |
| </div> | |
| <!-- End:Entry --> | |
| <!--end::Container--> | |
| </div> | |
| <!--end::Content--> | |
| <script> | |
| $(document).ready(function () { | |
| //Ajouter Client | |
| $("#addClient").validate({ | |
| rules: { | |
| nom: "required", | |
| prenom: "required", | |
| telephone: "required", | |
| adresse: "required", | |
| }, | |
| messages: { | |
| }, | |
| submitHandler: function(form) { | |
| var form_action = $("#addClient").attr("action"); | |
| $.ajax({ | |
| data: $('#addClient').serialize(), | |
| url: form_action, | |
| type: "POST", | |
| dataType: 'json', | |
| success: function (res) { | |
| var client = '<tr id="'+res.data.id+'" data-row="0" class="datatable-row" style="left: 0px;">'; | |
| client += '<td class="datatable-cell-center datatable-cell datatable-cell-check" data-field="RecordID" aria-label="1"><span style="width: 20px;"><label class="checkbox checkbox-single"><input type="checkbox" value="' + res.data.id + '"> <span></span></label></span></td>'; | |
| client += '<td data-field="nomprenom" aria-label="" class="datatable-cell"><span style="width: 122px;">' + res.data.nom + + res.data.prenom + '</span></td>'; | |
| client += '<td data-field="telephone" aria-label="" class="datatable-cell"><span class="" style="width: 150px;">' + res.data.telephone + '</span></td>'; | |
| client += '<td data-field="adresse" data-autohide-disabled="false" aria-label="2" class="datatable-cell"> <span class="" style="width: 180px;">' + res.data.address + '</span></td>'; | |
| client += '<td data-field="montant" data-autohide-disabled="false" aria-label="2" class="datatable-cell"> <span class="" style="width: 180px;">' + res.data.montant + '</span></td>'; | |
| client += '<td data-field="Actions" data-autohide-disabled="false" aria-label="2" class="datatable-cell> <span style="overflow: visible; position: relative; width: 120px;"><a data-id="' + res.data.id + ' class="btn btn-sm btn-clean btn-icon mr-2" title="Modifier" ><i class="fa fa-home"></i></a> <a data-id="' + res.data.id + '" class="btn btn-sm btn-clean btn-icon" title="Supprimer"><i class="fa fa-home"></i></a></td>'; | |
| client += '<td><a data-id="' + res.data.id + '" class="btn btn-primary btnVoir">Voir</a> <a href="#" data-id="' + res.data.id + '" class="btn btn-danger btn_delete">Modifier</a><a data-id="' + res.data.id + '" class="btn btn-danger btnDelete">Supprimer</a></td>'; | |
| client += '</tr>'; | |
| $('#clientTable tbody').prepend(client); | |
| $('#addClient')[0].reset(); | |
| $('#addModal').modal('hide'); | |
| }, | |
| error: function (data) { | |
| } | |
| }); | |
| } | |
| }); | |
| }); | |
| </script> | |
| <script> | |
| // Modifier Client | |
| $('body').on('click', '#btnEdit', function () { | |
| var client_id = $(this).attr('data-id'); | |
| //alert(client_id); | |
| $.ajax({ | |
| url: 'client/edit/'+client_id, | |
| type: "GET", | |
| dataType: 'json', | |
| success: function (res) { | |
| $('#updateModal').modal('show'); | |
| $('#updateClient #hdnClientId').val(res.data.id); | |
| $('#updateClient #txtNom').val(res.data.nom); | |
| $('#updateClient #txtPrenom').val(res.data.prenom); | |
| $('#updateClient #txtTelephone').val(res.data.telephone); | |
| $('#updateClient #txtAdresse').val(res.data.adresse); | |
| $('#updateClient #txtMontant').val(res.data.montant); | |
| }, | |
| error: function (data) { | |
| } | |
| }); | |
| }); | |
| // Maj Client | |
| $("#updateClient").validate({ | |
| rules: { | |
| txtNom: "required", | |
| txtPrenom: "required", | |
| txtTelephone: "required" | |
| }, | |
| messages: { | |
| }, | |
| submitHandler: function(form) { | |
| var form_action = $("#updateClient").attr("action"); | |
| $.ajax({ | |
| data: $('#updateClient').serialize(), | |
| url: form_action, | |
| type: "POST", | |
| dataType: 'json', | |
| success: function (res) { | |
| var client = '<tr id="'+res.data.id+'" data-row="0" class="datatable-row" style="left: 0px;">'; | |
| client += '<td class="datatable-cell-center datatable-cell datatable-cell-check" data-field="" aria-label="1"><span style="width: 20px;"><label class="checkbox checkbox-single"><input type="checkbox" value="' + res.data.id + '"> <span></span></label></span></td>'; | |
| client += '<td data-field="nomprenom" aria-label="" class="datatable-cell"><span style="width: 100px;">' + res.data.nom + ' ' + res.data.prenom + '</span></td>'; | |
| client += '<td data-field="telephone" aria-label="" class="datatable-cell"><span class="" style="width: 70px;">' + res.data.telephone + '</span></td>'; | |
| client += '<td data-field="adresse" data-autohide-disabled="false" aria-label="2" class="datatable-cell"> <span class="" style="width: 150px;">' + res.data.adresse + '</span></td>'; | |
| client += '<td data-field="montant" data-autohide-disabled="false" aria-label="2" class="datatable-cell"> <span class="" style="width: 70px;">' + res.data.montant + '</span></td>'; | |
| client += '<td data-field="Actions" data-autohide-disabled="false" aria-label="null" class="datatable-cell"><span style="overflow: visible; position: relative; width: 120px;"><a data-id="' + res.data.id + '" class="btn btn-sm btn-clean btn-icon mr-2 btnVoir" title="Voir" ><span class="svg-icon svg-icon-md"><!--begin::Svg Icon | path:C:\wamp64\www\keenthemes\legacy\metronic\theme\html\demo9\dist/../src/media/svg/icons\General\Visible.svg--><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"><g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><rect x="0" y="0" width="24" height="24"/><path d="M3,12 C3,12 5.45454545,6 12,6 C16.9090909,6 21,12 21,12 C21,12 16.9090909,18 12,18 C5.45454545,18 3,12 3,12 Z" fill="#000000" fill-rule="nonzero" opacity="0.3"/><path d="M12,15 C10.3431458,15 9,13.6568542 9,12 C9,10.3431458 10.3431458,9 12,9 C13.6568542,9 15,10.3431458 15,12 C15,13.6568542 13.6568542,15 12,15 Z" fill="#000000" opacity="0.3"/></g></svg><!--end::Svg Icon--></span></a> <a id="btnEdit" data-id="' + res.data.id + '" class="btn btn-sm btn-clean btn-icon mr-2 btnEdit" title="Modifier"><span class="svg-icon svg-icon-md"><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"><g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><rect x="0" y="0" width="24" height="24"></rect><path d="M8,17.9148182 L8,5.96685884 C8,5.56391781 8.16211443,5.17792052 8.44982609,4.89581508 L10.965708,2.42895648 C11.5426798,1.86322723 12.4640974,1.85620921 13.0496196,2.41308426 L15.5337377,4.77566479 C15.8314604,5.0588212 16,5.45170806 16,5.86258077 L16,17.9148182 C16,18.7432453 15.3284271,19.4148182 14.5,19.4148182 L9.5,19.4148182 C8.67157288,19.4148182 8,18.7432453 8,17.9148182 Z" fill="#000000" fill-rule="nonzero" transform="translate(12.000000, 10.707409) rotate(-135.000000) translate(-12.000000, -10.707409) "></path><rect fill="#000000" opacity="0.3" x="5" y="20" width="15" height="2" rx="1"></rect></g></svg> </span></a><a id="btn_delete" data-id="' + res.data.id + '" class="btn btn-sm btn-clean btn-icon btn_delete" title="Supprimer" ><span class="svg-icon svg-icon-md"><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"> <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><rect x="0" y="0" width="24" height="24"></rect><path d="M6,8 L6,20.5 C6,21.3284271 6.67157288,22 7.5,22 L16.5,22 C17.3284271,22 18,21.3284271 18,20.5 L18,8 L6,8 Z" fill="#000000" fill-rule="nonzero"></path><path d="M14,4.5 L14,4 C14,3.44771525 13.5522847,3 13,3 L11,3 C10.4477153,3 10,3.44771525 10,4 L10,4.5 L5.5,4.5 C5.22385763,4.5 5,4.72385763 5,5 L5,5.5 C5,5.77614237 5.22385763,6 5.5,6 L18.5,6 C18.7761424,6 19,5.77614237 19,5.5 L19,5 C19,4.72385763 18.7761424,4.5 18.5,4.5 L14,4.5 Z" fill="#000000" opacity="0.3"></path></g></svg></span></a></span></td>'; | |
| client += '</tr>'; | |
| $('#clientTable tbody #'+ res.data.id).html(client); | |
| $('#updateClient')[0].reset(); | |
| $('#updateModal').modal('hide'); | |
| }, | |
| error: function (data) { | |
| } | |
| }); | |
| } | |
| }); | |
| // Voir Client | |
| $('body').on('click', '.btnVoir', function () { | |
| var client_id = $(this).attr('data-id'); | |
| //alert(client_id); | |
| $.ajax({ | |
| method: "POST", | |
| url: "client/view", | |
| dataType: 'json', | |
| data: { | |
| 'client_id':client_id, | |
| }, | |
| success: function(response){ | |
| //console.log(response); | |
| $.each(response, function(key, clientview){ | |
| //console.log(clientview['nom']); | |
| $('.id_view').text(clientview['id']); | |
| $('.nom_view').text(clientview['nom']); | |
| $('.prenom_view').text(clientview['prenom']); | |
| $('.telephone_view').text(clientview['telephone']); | |
| $('.adresse_view').text(clientview['adresse']); | |
| $('.montant_view').text(clientview['montant']); | |
| $('#viewModal').modal('show'); | |
| }); | |
| } | |
| }); | |
| }); | |
| </script> | |
| <script> | |
| // Suppresion | |
| $('body').on('click', '.btn_delete', function () { | |
| var client_id = $(this).attr('data-id'); | |
| //alert(client_id); | |
| $('#client_del_id').val(client_id); | |
| $('#deleteModal').modal('show'); | |
| }); | |
| $('body').on('click', '#deleteconfirmed', function () { | |
| var client_id = $('#client_del_id').val(); | |
| //alert(client_id); | |
| $.get('client/delete/'+client_id, function (data) { | |
| $('#clientTable tbody #'+ client_id).remove(); | |
| }) | |
| $('#deleteModal').modal('hide'); | |
| }); | |
| </script> | |
| <!-- Footer Start--> | |
| <?php include('includes/footer.php');?> | |
| <!-- Footer End--> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| namespace App\Controllers; | |
| use App\Models\ClientModel; | |
| class Client extends BaseController | |
| { | |
| public $appname = 'Systeme de Collecte Automatiser des Déchets'; | |
| public $appnameshort = 'SYCAD'; | |
| public function index() | |
| { | |
| $session = session(); | |
| $data['titre'] = "Profil"; | |
| $data['nom'] = $session->get('nom'); | |
| $data['admin_id'] = $session->get('id'); | |
| $data['prenom'] = $session->get('prenom'); | |
| $data['telephone'] = $session->get('telephone'); | |
| $data['adresse'] = $session->get('adresse'); | |
| $data['email'] = $session->get('email'); | |
| $model = new ClientModel(); | |
| $data['client_detail'] = $model->orderBy('id', 'DESC')->findAll(); | |
| $data['appname'] = $this->appname; | |
| $data['appnameshort'] = $this->appnameshort; | |
| $data['titre'] = "Client"; | |
| return view('client', $data); | |
| } | |
| public function store() | |
| { | |
| helper(['form', 'url']); | |
| $model = new ClientModel(); | |
| $data = [ | |
| 'nom' => $this->request->getVar('nom'), | |
| 'prenom' => $this->request->getVar('prenom'), | |
| 'telephone' => $this->request->getVar('telephone'), | |
| 'adresse' => $this->request->getVar('adresse'), | |
| //'montant' => $this->request->getVar('montant'), | |
| //'admin_id' => $this->request->getVar('admin_id'), | |
| ]; | |
| $save = $model->insert_data($data); | |
| if($save != false){ | |
| $data = $model->where('id', $save)->first(); | |
| //echo json_encode(array("status" => true , 'data' => $data)); | |
| return redirect()->to('/client'); | |
| }else{ | |
| //echo json_encode(array("status" => false , 'data' => $data)); | |
| //return redirect()->to('/signin'); | |
| } | |
| } | |
| public function edit($id = null) | |
| { | |
| $model = new ClientModel(); | |
| $data = $model->where('id', $id)->first(); | |
| if($data){ | |
| echo json_encode(array("status" => true , 'data' => $data)); | |
| }else{ | |
| echo json_encode(array("status" => false)); | |
| } | |
| } | |
| public function update(){ | |
| helper(['form', 'url']); | |
| $model = new ClientModel(); | |
| $id = $this->request->getVar('hdnClientId'); //id | |
| $data = [ | |
| 'nom' => $this->request->getVar('txtNom'), //nom | |
| 'prenom' => $this->request->getVar('txtPrenom'), | |
| 'telephone' => $this->request->getVar('txtTelephone'), | |
| 'adresse' => $this->request->getVar('txtAdresse'), | |
| 'montant' => $this->request->getVar('txtMontant'), | |
| ]; | |
| $update = $model->update($id,$data); | |
| if($update != false) | |
| { | |
| $data = $model->where('id', $id)->first(); | |
| echo json_encode(array("status" => true , 'data' => $data)); | |
| }else{ | |
| echo json_encode(array("status" => false , 'data' => $data)); | |
| } | |
| } | |
| public function view() | |
| { | |
| $model = new ClientModel(); | |
| $client_id = $this->request->getPost('client_id'); | |
| $data['uClient'] = $model->find($client_id); | |
| return $this->response->setJSON($data); | |
| } | |
| public function delete($id = null){ | |
| $model = new ClientModel(); | |
| $delete = $model->where('id', $id)->delete(); | |
| if($delete) | |
| { | |
| echo json_encode(array("status" => true)); | |
| }else{ | |
| echo json_encode(array("status" => false)); | |
| } | |
| } | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| namespace App\Models; | |
| use CodeIgniter\Database\ConnectionInterface; | |
| use CodeIgniter\Model; | |
| Class ClientModel extends Model{ | |
| protected $table = 'clients'; | |
| protected $allowedFields = [ | |
| 'nom', | |
| 'prenom', | |
| 'telephone', | |
| 'adresse', | |
| 'montant', | |
| 'creer_le', | |
| 'modifier_le', | |
| 'admin_id', | |
| ]; | |
| public function __construct() { | |
| parent::__construct(); | |
| //$this->load->database(); | |
| $db = \Config\Database::connect(); | |
| $builder = $db->table('clients'); | |
| } | |
| public function insert_data($data) { | |
| if($this->db->table($this->table)->insert($data)) | |
| { | |
| return $this->db->insertID(); | |
| } | |
| else | |
| { | |
| return false; | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment