File manager

File manager - Edit - /home/autoph/public_html/tasks/nature_of_business_settings.php.tar

Back
home/autoph/public_html/connectv1/nature_of_business_settings.php��0000644��00000064347�15025005266�0021543 0��ustar�00��<?php include('cfg/db.php'); // include('app/security/security.php'); if(!isset($_SESSION['user']['id'])){ header('location:signin.php'); } if(!(isset($global_action_permissions['4']['25']) && in_array("1", $global_action_permissions['4']['25']))){ header('location:signin.php'); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title> <?php echo $variable['site_name']; ?> \| Nature of Business Settings </title> <!-- Google Font: Source Sans Pro --> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback"> <!-- Font Awesome --> <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <!-- Select2 --> <link rel="stylesheet" href="plugins/select2/css/select2.min.css"> <link rel="stylesheet" href="plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css"> <!-- Toastr --> <link rel="stylesheet" href="plugins/toastr/toastr.min.css"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon"/> <!-- iCheck for checkboxes and radio inputs --> <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css"> <!-- Bootstrap Table --> <link href="plugins/bootstrap-table/css/bootstrap-table.min.css" rel="stylesheet"> <style> fieldset { margin-left: 2px; margin-right: 2px; padding-top: 0.35em; padding-bottom: 0.625em; padding-left: 0.75em; padding-right: 0.75em; border: 1px solid gray; border-radius: 3%; } legend { font-size: 100%; font-weight: bold; color: blue; } .big-letter { text-transform: uppercase; } </style> </head> <body class="hold-transition sidebar-mini text-sm layout-fixed"> <div class="wrapper"> <!-- INCLUDE HEADER --> <?php include('include/header.php'); ?> <?php include('include/sidebar.php'); ?> <div class="content-wrapper"> <section class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> <h1>Nature Of Business Settings</h1> </div> <div class="col-sm-6"> <ol class="breadcrumb float-sm-right"> <li class="breadcrumb-item"><a href="home.php">Home</a></li> <li class="breadcrumb-item active">Nature of Business Settings</li> </ol> </div> </div> </div><!-- /.container-fluid --> </section> <section id="" class="content"> <div class="container-fluid"> <div class="card card-primary card-tabs"> <div class="card-header p-0 pt-1"> <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist"> <li class="nav-item"> <a class="nav-link active" id="custom-tabs-one-crud-tab" data-toggle="pill" href="#custom-tabs-one-crud" role="tab" aria-controls="custom-tabs-one-crud" aria-selected="true">CRUD</a> </li> <li class="nav-item"> <a class="nav-link" id="custom-tabs-one-category-tab" data-toggle="pill" href="#custom-tabs-one-category" role="tab" aria-controls="custom-tabs-one-category" aria-selected="false">Category List View</a> </li> </ul> </div> <div class="card-body"> <div class="tab-content" id="custom-tabs-one-tabContent"> <div class="tab-pane fade show active" id="custom-tabs-one-crud" role="tabpanel" aria-labelledby="custom-tabs-one-crud-tab"> <div class="row"> <div class="form-group"> <input type="button" name="details-add-nature" id="details-add-nature" value="New Nature of Business" data-toggle="modal" data-target="#modal-add-nature" class="float-right btn btn-primary btn-xs"> </div><!--form-group--> </div> <div class="row"> <div class="col-sm-4 mt-3"> <div class="form-group"> <div class="row"> <div class="col-sm-6"> <label>Nature of Business</label> </div> <div class="col-sm-6"> <input type="text" name="search-nature" id="search-nature" placeholder="Search Nature of Business" class="form-control form-control-sm"> </div> </div> <div class="mt-1"> <select id="nature-list" size="8" class="form-control form-control-sm"> <?php $query = " SELECT id, name FROM source_nature_of_business WHERE id != 0 /AND status = 1/"; $nature = $db->return_result($query); foreach($nature as $data){ ?> <option value="<?php echo $data['id'];?>"><?php echo $data['name'];?></option> <?php } ?> </select> </div> </div> </div> <div class="col-sm-8"> <fieldset class="card"> <legend>Nature of Business Details</legend> <div class="row mb-2"> <div class="col-sm-8"> <div class="form-group form-control-sm"> <label class="lbl-forms mx-0 my-0">NoB Name</label> <input id="details-nature-name" type="text" class="big-letter lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> <div class="col-sm-4"> <div id="checkbox-status" class="form-group form-control-sm"> <label class="lbl-forms mx-0 my-0">NoB Status</label><br> <input type="checkbox" id="nature-status-checkbox" name="nature-status-checkbox" checked data-bootstrap-switch> </div> </div> </div> <div class="row"> <div class="col-sm-12"> <div class="form-group form-control-sm"> <label class="lbl-forms mx-0 my-0">Category</label> <select id="details-nature-category" class="form-control"> <option value="0">NONE</option> <?php $sql = "SELECT `id`, `name` FROM `source_nature_of_business` WHERE `status` = 1 AND `is_parent` = 1 ORDER BY `name` ASC"; $nob_category_list = $db->sql_query($sql); foreach($nob_category_list AS $data){ echo '<option value="'.$data['id'].'">'.$data['name'].'</option>'; } ?> </select> </div> </div> </div> <div class="row"> <div class="col-sm-4 mt-4"> <div class="form-group"> <span class="span-labels"><strong>Added by: &nbsp</strong></span><br> <span id="details-nature-added-by" class="span-values"></span> </div> </div> <div class="col-sm-4 mt-4"> <div class="form-group"> <span class="span-labels"><strong>Last modified by: &nbsp</strong></span><br> <span id="details-nature-last-modified-by" class="span-values"></span> </div> </div> <div class="col-sm-4 mt-4"> <div class="form-group"> <span class="span-labels"><strong>Date added: &nbsp</strong></span><br> <span id="details-nature-date-added" class="span-values"></span> </div> </div> </div> <br> <div class="row"> <div class="col-8"> <div class="alert alert-info" role="alert" id="modify-company-error-alert" style="display: none;"> <span id="modify-company-error-icon" class="icon fas fa-info" style="margin-top: -20%;"> </span> <span id="modify-company-alert-message"></span></a> </div> </div> <div class="col-4"> <div class="form-group"> <input type="button" name="details-update-nature" id="details-update-nature" value="Update" class="float-right btn btn-success btn-xs"> </div><!--form-group--> </div> </div> </fieldset> </div> </div> </div> <div class="tab-pane fade show" id="custom-tabs-one-category" role="tabpanel" aria-labelledby="custom-tabs-one-category-tab"> <div class="row"> <div class="col-sm-3"> <select id="filter-dd" class="form-control form-control-sm select2"> <option value="-1">ALL</option> <option value="0">NONE</option> <?php $sql = "SELECT `id`, `name` FROM `source_nature_of_business` WHERE `status` = 1 AND `is_parent` = 1 ORDER BY `name`"; $nob = $db->sql_query($sql); foreach($nob AS $row){ echo '<option value="'.$row['id'].'">'.$row['name'].'</option>'; } ?> </select> </div> <div class="col-sm-3"> </div> <div class="col-sm-3"> </div> <div class="col-sm-3 float-right"> <div class="col-12"> <div class="row"> <input id="search-nob" type="text" class="form-control form-control-sm" placeholder="Search here"> <button id="generate-cat-report" class="bg bg-primary" hidden>Create Report</button> </div> </div> </div> </div> <div id="nob-div-table" class="table-responsive mt-2"> <table id="nob-table" class="table table-sm" data-toggle="table" data-url="" data-pagination="true" data-search="false" data-show-toggle="false" data-show-columns="false" data-show-columns-toggle-all="false" data-show-export="false" data-side-pagination="server" data-page-list="[10, 100]" data-minimum-count-columns="2" data-show-pagination-switch="false" data-pagination="true" data-query-params="queryParamsNobTable" data-click-to-select="false"> <thead> <tr> <th class="main-header-table" data-formatter="" data-field="nob">Nature of Business</th> <th class="main-header-table text-center" data-formatter="formatterDropdown" data-field="category">Category</th> </tr> </thead> </table> </div> </div> </div> </div> </div> </div><!--container-fluid--> <!-- Modal --> <div class="modal fade" id="modal-add-nature" tabindex="-1" data-backdrop="static" aria-labelledby="exampleModalCenterTitle" aria-hidden="true"> <div class="modal-dialog modal-dialog-centered modal-sm" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="exampleModalCenterTitle"><span id="modal-title">ADD NoB</span></h5> <div class="fas fa-2x fa-sync-alt fa-spin customer-modal-overlay" hidden></div> <button id="close-modal" type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <div class="row"> <div class="col-sm-12"> <div class="form-group"> <div class="form-group"> <label class="lbl-forms mx-0 my-0">NoB Name</label> <input type="text" name="new-nature-name" id="new-nature-name" placeholder="ENTER NEW NoB" class="big-letter form-control form-control-sm"> </div> </div> </div> </div> <div class="row"> <div class="col-md-12"> <div class="form-group"> <input type="button" name="submit-nature" id="submit-nature" value="Add NoB" class="float-right btn btn-success btn-xs"> </div><!--form-group--> </div><!--form-group--> </div> </div><!--modal body--> </div><!--modal content--> </div> </div> </section> </div><!--cointent-wrapper --> <?php include('include/footer.php'); ?> <aside class="control-sidebar control-sidebar-dark"> </aside> </div> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- Bootstrap Switch --> <script src="plugins/bootstrap-switch/js/bootstrap-switch.min.js"></script> <!-- bs-custom-file-input --> <script src="plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.min.js"></script> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <!-- Bootstrap Table --> <script src="/plugins/bootstrap-table/js/tableExport.min.js"></script> <script src="/plugins/bootstrap-table/js/bootstrap-table.min.js"></script> <script src="/plugins/bootstrap-table/js/bootstrap-table-en-US.js"></script> <script src="/plugins/bootstrap-table/js/bootstrap-table-export.min.js"></script> <!-- <script src="dist/js/nob/nob_crud.js"></script> --> <script> var nature_id_selected = ""; var search_nob = ""; var filter_dd = -1; $(function(){ $('#nature-status-checkbox').bootstrapSwitch('disabled', true); // initTable(); refreshTable(); }); // initializations $("input[data-bootstrap-switch]").each(function(){ $(this).bootstrapSwitch('state', $(this).prop('checked')); }); $('#filter-dd').select2({ allowClear: false }); $('#details-nature-category').select2({ allowClear: false }); function initTable() { var $table = $('#nob-table') $table.bootstrapTable('destroy').bootstrapTable({ onLoadSuccess: function(result) { selectListener(); } }) } function refreshTable(){ var $table = $('#nob-table') $(function() { $table.bootstrapTable('refresh', { url: 'app/nob_tagging/nob_tagging.php' }); }) } function queryParamsNobTable(params) { return { search: search_nob, offset: params.offset, limit: params.limit, filter: filter_dd, table: 1, type: 1 }; } function formatterDropdown(value, row, index) { return ` <select name="nob-filter" id="nob_` + row.id + `" class="form-control form-control-sm select2 nob-dd" data-bootstrap-select data-row-id="` + row.id + `" data-category-id="` + row.category + `" style="width: 100%;" > <option value="0">NONE</option> ` + '<?php $nature = $db->return_result("SELECT id, name FROM source_nature_of_business WHERE status = 1 AND `is_parent` = 1 ORDER BY name ASC"); foreach($nature AS $data){ echo "<option value=" . $data['id'] . ">" . $data['name'] . "</option>"; } ?>' + ` </select> `; } function selectListener() { $("select[data-bootstrap-select]").each(function() { var clickedId = this.id; var nob_id = $(this).attr('data-row-id'); var val = $(this).attr('data-category-id'); $('#' + clickedId).val(parseInt(val)).trigger('change'); $('.nob-dd').select2({ allowClear: false }); $('#' + clickedId).on('select2:select', function (e) { var data = e.params.data; // alert(data.id); return; $.ajax({ url: "app/nob_tagging/nob_tagging.php", method: "POST", data: { table: 0, // not a table category_id: data.id, nob_id: nob_id, type: 1 // 'operation' 1 }, beforeSend: function() { toastr.remove(); toastr.info('Updating status...'); }, success: function(data) { if(data.nob_cat == 0){ toastr.remove(); toastr.error("There's something wrong in updating", "Update failed"); } else { toastr.remove(); toastr.success("NoB's category updated", "Update success"); refreshTable(); } } }); }); }); } function refreshNatureList(){ $.ajax({ url:"app/nature_of_business/reload_nature.php", type:"POST", data: { type: 1 }, beforeSend: function(){ }, success: function(result) { $('#nature-list').html(''); $('#nature-list').append("\"" + result + "\""); }, }) } function delay(callback, ms) { var timer = 0; return function() { var context = this, args = arguments; clearTimeout(timer); timer = setTimeout(function() { callback.apply(context, args); }, ms \|\| 0); }; } $('#search-nob').on('keyup', delay(function(e) { search_nob = $(this).val(); refreshTable(); }, 1000)); $('#filter-dd').on('change', function(){ filter_dd = $('#filter-dd').val(); refreshTable(); }); $('#submit-nature').on('click', function(){ var new_nature = $('#new-nature-name').val(); if(new_nature == ""){ toastr.remove(); toastr.error('NoB name field is empty'); return; } $.ajax({ url:"app/nature_of_business/add_nature.php", type:"POST", dataType: 'json', data: { new_nature: new_nature }, beforeSend: function(){ }, success: function(result) { if(result.status == 0){ toastr.remove(); toastr.error(result.message); } else if(result.status == 1){ toastr.remove(); toastr.success("New NoB added successfully"); $('#new-nature-name').val(""); $('#modal-add-nature').modal('hide'); refreshNatureList(); } }, }); }); $('#nature-list').on('change', function(){ nature_id_selected = $('#nature-list').val(); $.ajax({ url:"app/nature_of_business/reload_nature.php", type:"POST", dataType: 'json', data: { nature_id: nature_id_selected, type: 2 }, beforeSend: function(){ }, success: function(result) { // alert(result.category); $('#details-nature-name').val(result.name); $('#details-nature-category').val(parseInt(result.category)).trigger('change'); $('#details-nature-added-by').text(result.creator + "\n" + result.add_source); $('#details-nature-last-modified-by').text(result.last_modifier); $('#details-nature-date-added').text(result.date_added); $('#nature-status-checkbox').bootstrapSwitch('disabled', false); $('#nature-status-checkbox').bootstrapSwitch('state', result.status); }, }) }); $('#details-update-nature').on('click', function (){ var update_nature_name = $('#details-nature-name').val(); var update_nature_category = $('#details-nature-category').val(); var status = $('#nature-status-checkbox').bootstrapSwitch('state'); if(nature_id_selected == ""){ toastr.remove(); toastr.error("Please select NoB name to be modified first"); return; } if(update_nature_name == ""){ toastr.remove(); toastr.error("NoB name is empty"); return; } $.ajax({ url:"app/nature_of_business/update_nature_of_business.php", type:"POST", dataType: 'json', data: { nature_id: nature_id_selected, new_nature_name: update_nature_name, new_nature_category: update_nature_category, status: status }, beforeSend: function(){ }, success: function(result) { if(result.status == 0){ toastr.remove(); toastr.error("NoB already existing"); return; } if(result.status == 1){ // success update toastr.remove(); toastr.success("NoB name successfully updated"); refreshNatureList(); $('#details-nature-name').val(""); $('#details-nature-category').val(0).trigger('change'); $('#details-nature-added-by').text(""); $('#details-nature-date-added').text(""); $('#details-nature-last-modified-by').text(""); $('#nature-status-checkbox').bootstrapSwitch('disabled', true); $('#search-nature').val(""); return; } else if(result.status == 2) { // failed update toastr.remove(); toastr.error("There's something wrong in updating", "Update failed"); return; } else if(result.status == 3){ // nothing changes toastr.remove(); toastr.info("Nothing changes"); return; } }, }) }); $('#search-nature').on('keyup', delay(function (e){ var search_nature = $('#search-nature').val(); nature_id_selected = ""; $.ajax({ url:"app/nature_of_business/reload_nature.php", type:"POST", data: { type: 3, search_item: search_nature }, beforeSend: function(){ }, success: function(result){ $('#nature-list').html(''); $('#nature-list').append("\"" + result + "\""); } }); }, 500)); $('#close-modal').click(function(){ $('#modal-add-nature').modal('hide'); $('#new-nature-name').val(""); }); $('#custom-tabs-one-category-tab').on('click', function(){ $('#search-nob').val(""); refreshTable(); }); $('#generate-cat-report').on('click', function(){ window.open('print_nobcat_report.php'); }); </script> </body> </html> ��

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings