File manager

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

Back
home/autoph/public_html/connectv1/finance_fields.php��0000644��00000112302�15025046265�0016644 0��ustar�00��<?php include('cfg/db.php'); // include('app/security/security.php'); if(!isset($_SESSION['user']['id'])){ header('location:signin.php'); } // if(!(isset($_SESSION['user']['action_permissions']['4']['sub_27_1']) && // $_SESSION['user']['action_permissions']['4']['sub_27_1'])){ // 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']; ?> \| DMS 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"> <!-- Select2 --> <link rel="stylesheet" href="plugins/select2/css/select2.min.css"> <link rel="stylesheet" href="plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> </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'); ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> <h1>Finance 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">Finance Settings</li> </ol> </div> </div> </div><!-- /.container-fluid --> </section> <!-- Main content --> <section class="content"> <div class="container-fluid"> <div class="row"> <!-- left column --> <div class="col-md"> <!-- general form elements --> <div class="card card-primary"> <div class="card-header"> <h3 class="card-title">Spreadsheet Fields (Finance)</h3> </div><!-- /.card-header --> <div class="card-body"> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">BRAND<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="brand" name="brand" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 2 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Place / CS Number<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="place-cs-number" name="place-cs-number" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 1 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Company<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="company" name="company" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 7 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Dealer<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="dealer" name="dealer" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 8 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Customer Mobile<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="customer-mobile" name="customer-mobile" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 4 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Customer Email<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="customer-email" name="customer-email" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 5 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Customer Fullname<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="customer-fullname" name="customer-fullname" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 3 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Customer Full Address<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="customer-full-address" name="customer-full-address" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 6 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Insurance Company<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="insurance-company" name="insurance-company" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 9 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Policy No.<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="policy-number" name="policy-number" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 10 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Policy Issue Date<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="policy-issue-date" name="policy-issue-date" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 11 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Policy Start Date<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="policy-start-date" name="policy-start-date" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 12 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Policy End Date<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="policy-end-date" name="policy-end-date" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 13 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Insurance Type<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="insurance-type" name="insurance-type" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 14 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Bank<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="bank" name="bank" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 15 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">SC Fullname<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="sc-fullname" name="sc-fullname" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 16 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Locked In<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="locked-in" name="locked-in" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 17 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Locked In Years<label class="p-0 m-0" style="color:red; float-right">*</label></label> <select id="locked-in-years" name="locked-in-years" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 18 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Paid Amount<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="paid-amount" name="paid-amount" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 19 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> <div class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Terms<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="terms" name="terms" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db->return_result("SELECT `name` FROM `source_finance_fields_name` WHERE `finance_field_id` = (SELECT id FROM source_finance_fields WHERE id = 20 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div><!-- /.card-body --> </div> </div><!-- /.container-fluid --> </section> <!-- /.content --> <!-- /.content-wrapper --> <!-- INSERT FOOTER --> </div><!-- ./cointent-wrapper --> <?php include('include/footer.php'); ?> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Control sidebar content goes here --> </aside> <!-- /.control-sidebar --> </div><!-- ./wrapper --> <!-- 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> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.min.js"></script> <script src="dist/js/main.js"></script> <script> $(function() { $('#loader-main').hide(); $('ul#custom-tabs-one-tab li').click(function(e) { $('#loader-main').show(); }); $('ul#custom-tabs-three-tab li').click(function(e) { $('#loader-main').show(); }); }); $(document.body).on("change", "#brand", function() { var el = document.getElementsByName('brand')[0]; var field_names = getSelectValues(el); var finance_field_id = "2"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#place-cs-number", function() { var el = document.getElementsByName('place-cs-number')[0]; var field_names = getSelectValues(el); var finance_field_id = "1"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#company", function() { var el = document.getElementsByName('company')[0]; var field_names = getSelectValues(el); var finance_field_id = "7"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#dealer", function() { var el = document.getElementsByName('dealer')[0]; var field_names = getSelectValues(el); var finance_field_id = "8"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#customer-mobile", function() { var el = document.getElementsByName('customer-mobile')[0]; var field_names = getSelectValues(el); var finance_field_id = "4"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#customer-email", function() { var el = document.getElementsByName('customer-email')[0]; var field_names = getSelectValues(el); var finance_field_id = "5"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#customer-fullname", function() { var el = document.getElementsByName('customer-fullname')[0]; var field_names = getSelectValues(el); var finance_field_id = "3"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#customer-full-address", function() { var el = document.getElementsByName('customer-full-address')[0]; var field_names = getSelectValues(el); var finance_field_id = "6"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#insurance-company", function() { var el = document.getElementsByName('insurance-company')[0]; var field_names = getSelectValues(el); var finance_field_id = "9"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#policy-number", function() { var el = document.getElementsByName('policy-number')[0]; var field_names = getSelectValues(el); var finance_field_id = "10"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#policy-issue-date", function() { var el = document.getElementsByName('policy-issue-date')[0]; var field_names = getSelectValues(el); var finance_field_id = "11"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#policy-start-date", function() { var el = document.getElementsByName('policy-start-date')[0]; var field_names = getSelectValues(el); var finance_field_id = "12"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#policy-end-date", function() { var el = document.getElementsByName('policy-end-date')[0]; var field_names = getSelectValues(el); var finance_field_id = "13"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#insurance-type", function() { var el = document.getElementsByName('insurance-type')[0]; var field_names = getSelectValues(el); var finance_field_id = "14"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#bank", function() { var el = document.getElementsByName('bank')[0]; var field_names = getSelectValues(el); var finance_field_id = "15"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#sc-fullname", function() { var el = document.getElementsByName('sc-fullname')[0]; var field_names = getSelectValues(el); var finance_field_id = "16"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#locked-in", function() { var el = document.getElementsByName('locked-in')[0]; var field_names = getSelectValues(el); var finance_field_id = "17"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#locked-in-years", function() { var el = document.getElementsByName('locked-in-years')[0]; var field_names = getSelectValues(el); var finance_field_id = "18"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#paid-amount", function() { var el = document.getElementsByName('paid-amount')[0]; var field_names = getSelectValues(el); var finance_field_id = "19"; // base on database updateField(field_names, finance_field_id); }); $(document.body).on("change", "#terms", function() { var el = document.getElementsByName('terms')[0]; var field_names = getSelectValues(el); var finance_field_id = "20"; // base on database updateField(field_names, finance_field_id); }); function updateField(field_names, finance_field_id){ $.ajax({ url: "app/settings/update_finance_fields.php", method: "POST", dataType: 'json', data: { field_names: field_names, finance_field_id: finance_field_id, }, success: function(result) {} }); } function getSelectValues(select) { var result = []; var options = select && select.options; var opt; for (var i = 0, iLen = options.length; i < iLen; i++) { opt = options[i]; if (opt.selected) { result.push(opt.value \|\| opt.text); } } return result; } function getSelectValues(select) { var result = []; var options = select && select.options; var opt; for (var i = 0, iLen = options.length; i < iLen; i++) { opt = options[i]; if (opt.selected) { result.push(opt.value \|\| opt.text); } } return result; } </script> <!-- Page specific script --> <script type="text/javascript"> $('.select2').select2({ tags: true, "language": { "noResults": function() { return 'Enter field name'; } }, placeholder: ' Enter field name' }); </script> <script> function getDmsId(id) { dms_id = id; $('.overlay').fadeIn() window.location.href = "dms.php?dms=" + dms_id + "&type=" + dms_type_id; } function getDmsTypeId(id) { dms_type_id = id; $('.overlay').fadeIn() window.location.href = "dms.php?dms=" + dms_id + "&type=" + dms_type_id; } </script> </body> </html>��

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