File manager

File manager - Edit - /home/autoph/public_html/connectv1/dmsv2.php

Back
<?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'); ?> <!-- /.navbar --> <!-- 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>DMS 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">DMS 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</h3> </div><!-- /.card-header --> <div class="card-body"> <div class="form-group mb-2" id="" hidden> <label class="p-0 m-0 col-sm-3 col-form-label">DMS<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="dms" name="dms" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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="" hidden> <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_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">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_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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 no.<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="customer-id" name="customer-id" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Corporation Name<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="corporation" name="corporation" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">First Name<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="firstname" name="firstname" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Middle Name<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="middlename" name="middlename" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Last Name<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="lastname" name="lastname" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Suffix Name<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="suffix" name="suffix" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Profession<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="profession" name="profession" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Occupation/Position<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="position" name="position" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Business/Company<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="business" name="business" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Nature of Business<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="nature-of-business" name="nature-of-business" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Affiliation<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="affiliation" name="affiliation" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Car Club<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="car_club" name="car_club" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 42 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">Facebook<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="facebook" name="facebook" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Address 1<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="address-1" name="address-1" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Address 2<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="address-2" name="address-2" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">City<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="city" name="city" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 43 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">Email<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="email" name="email" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Mobile<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="mobile" name="mobile" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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">Business Phone<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="business-phone" name="business-phone" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 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 class="form-group mb-2" id=""> <label class="p-0 m-0 col-sm-3 col-form-label">Birthday<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="birthday" name="birthday" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 21 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">Gender<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="gender" name="gender" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 22 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">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_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 23 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">Model<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="model" name="model" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 24 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">Model Variant<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="model-variant" name="model-variant" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 25 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">Model Year<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="model-year" name="model-year" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 40 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">Color<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="color" name="color" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 26 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">Conduction Sticker<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="cs-no" name="cs-no" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 27 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">Plate Number<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="plate-no" name="plate-no" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 28 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">VIN<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="vin" name="vin" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 29 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">Registration no.<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="reg-no" name="reg-no" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 30 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">Date<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="date" name="date" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 31 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">Release no.<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="release-no" name="release-no" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 32 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">Mode of Sale<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="mode-of-sale" name="mode-of-sale" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 33 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">Type of Payment<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="type-of-payment" name="type-of-payment" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 34 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<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="insurance" name="insurance" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 35 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">Source<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="source" name="source" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 36 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">Offered Vehicle<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="offered-vehicle" name="offered-vehicle" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 37 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">End User<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="end-user" name="end-user" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 41 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">Sales Manager<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="sales-manager" name="sales-manager" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 38 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">Sales Consultant<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="sales-consultant" name="sales-consultant" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 39 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">AHA Registered<label class="p-0 m-0" style="color:red; float-right"></label></label> <select id="aha-registered" name="aha-registered" class="select2 form-control form-control-sm" multiple="multiple" data-placeholder="" style="width: 100%;"> <?php $field = $db -> return_result("SELECT `name` FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = (SELECT id FROM source_dms_fields_v2 WHERE id = 44 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> $(document).ready(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", "#dms", function() { var el = document.getElementsByName('dms')[0]; var field_names = getSelectValues(el); var dms_field_id = "1"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#company", function() { var el = document.getElementsByName('company')[0]; var field_names = getSelectValues(el); var dms_field_id = "2"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#dealer", function() { var el = document.getElementsByName('dealer')[0]; var field_names = getSelectValues(el); var dms_field_id = "3"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#customer-id", function() { var el = document.getElementsByName('customer-id')[0]; var field_names = getSelectValues(el); var dms_field_id = "4"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#corporation", function() { var el = document.getElementsByName('corporation')[0]; var field_names = getSelectValues(el); var dms_field_id = "5"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#firstname", function() { var el = document.getElementsByName('firstname')[0]; var field_names = getSelectValues(el); var dms_field_id = "6"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#middlename", function() { var el = document.getElementsByName('middlename')[0]; var field_names = getSelectValues(el); var dms_field_id = "7"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#lastname", function() { var el = document.getElementsByName('lastname')[0]; var field_names = getSelectValues(el); var dms_field_id = "8"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#suffix", function() { var el = document.getElementsByName('suffix')[0]; var field_names = getSelectValues(el); var dms_field_id = "9"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#profession", function() { var el = document.getElementsByName('profession')[0]; var field_names = getSelectValues(el); var dms_field_id = "10"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#position", function() { var el = document.getElementsByName('position')[0]; var field_names = getSelectValues(el); var dms_field_id = "11"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#business", function() { var el = document.getElementsByName('business')[0]; var field_names = getSelectValues(el); var dms_field_id = "12"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#nature-of-business", function() { var el = document.getElementsByName('nature-of-business')[0]; var field_names = getSelectValues(el); var dms_field_id = "13"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#affiliation", function() { var el = document.getElementsByName('affiliation')[0]; var field_names = getSelectValues(el); var dms_field_id = "14"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#car_club", function() { var el = document.getElementsByName('car_club')[0]; var field_names = getSelectValues(el); var dms_field_id = "42"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#facebook", function() { var el = document.getElementsByName('facebook')[0]; var field_names = getSelectValues(el); var dms_field_id = "15"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#address-1", function() { var el = document.getElementsByName('address-1')[0]; var field_names = getSelectValues(el); var dms_field_id = "16"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#address-2", function() { var el = document.getElementsByName('address-2')[0]; var field_names = getSelectValues(el); var dms_field_id = "17"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#city", function() { var el = document.getElementsByName('city')[0]; var field_names = getSelectValues(el); var dms_field_id = "43"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#email", function() { var el = document.getElementsByName('email')[0]; var field_names = getSelectValues(el); var dms_field_id = "18"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#mobile", function() { var el = document.getElementsByName('mobile')[0]; var field_names = getSelectValues(el); var dms_field_id = "19"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#business-phone", function() { var el = document.getElementsByName('business-phone')[0]; var field_names = getSelectValues(el); var dms_field_id = "20"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#birthday", function() { var el = document.getElementsByName('birthday')[0]; var field_names = getSelectValues(el); var dms_field_id = "21"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#gender", function() { var el = document.getElementsByName('gender')[0]; var field_names = getSelectValues(el); var dms_field_id = "22"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#brand", function() { var el = document.getElementsByName('brand')[0]; var field_names = getSelectValues(el); var dms_field_id = "23"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#model", function() { var el = document.getElementsByName('model')[0]; var field_names = getSelectValues(el); var dms_field_id = "24"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#model-variant", function() { var el = document.getElementsByName('model-variant')[0]; var field_names = getSelectValues(el); var dms_field_id = "25"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#color", function() { var el = document.getElementsByName('color')[0]; var field_names = getSelectValues(el); var dms_field_id = "26"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#cs-no", function() { var el = document.getElementsByName('cs-no')[0]; var field_names = getSelectValues(el); var dms_field_id = "27"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#plate-no", function() { var el = document.getElementsByName('plate-no')[0]; var field_names = getSelectValues(el); var dms_field_id = "28"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#vin", function() { var el = document.getElementsByName('vin')[0]; var field_names = getSelectValues(el); var dms_field_id = "29"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#reg-no", function() { var el = document.getElementsByName('reg-no')[0]; var field_names = getSelectValues(el); var dms_field_id = "30"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#date", function() { var el = document.getElementsByName('date')[0]; var field_names = getSelectValues(el); var dms_field_id = "31"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#release-no", function() { var el = document.getElementsByName('release-no')[0]; var field_names = getSelectValues(el); var dms_field_id = "32"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#mode-of-sale", function() { var el = document.getElementsByName('mode-of-sale')[0]; var field_names = getSelectValues(el); var dms_field_id = "33"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#type-of-payment", function() { var el = document.getElementsByName('type-of-payment')[0]; var field_names = getSelectValues(el); var dms_field_id = "34"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#insurance", function() { var el = document.getElementsByName('insurance')[0]; var field_names = getSelectValues(el); var dms_field_id = "35"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#source", function() { var el = document.getElementsByName('source')[0]; var field_names = getSelectValues(el); var dms_field_id = "36"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#offered-vehicle", function() { var el = document.getElementsByName('offered-vehicle')[0]; var field_names = getSelectValues(el); var dms_field_id = "37"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#end-user", function() { var el = document.getElementsByName('end-user')[0]; var field_names = getSelectValues(el); var dms_field_id = "41"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#sales-manager", function() { var el = document.getElementsByName('sales-manager')[0]; var field_names = getSelectValues(el); var dms_field_id = "38"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#sales-consultant", function() { var el = document.getElementsByName('sales-consultant')[0]; var field_names = getSelectValues(el); var dms_field_id = "39"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#model-year", function() { var el = document.getElementsByName('model-year')[0]; var field_names = getSelectValues(el); var dms_field_id = "40"; // base on database updateField(field_names,dms_field_id); }); $(document.body).on("change", "#aha-registered", function() { var el = document.getElementsByName('aha-registered')[0]; var field_names = getSelectValues(el); var dms_field_id = "44"; // base on database updateField(field_names,dms_field_id); }); function updateField(field_names,dms_field_id){ $.ajax({ url: "app/settings/update_dms_fields_v2.php", method: "POST", dataType: 'json', data: { field_names: field_names, dms_field_id: dms_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; } // $(document.body).on("change","#customer",function(){ // var selected = $("#customer option:selected").val(); // var test = getSelectValues("#customer"); // alert(test) // // alert(selected); // }); // $(function () { // $('#customer').on('select2:select', function (e) { // var selected = $("#customer option:selected").text(); // alert(selected); // }); // }) 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'; } }, // escapeMarkup: function (markup) { // return markup; // }, placeholder: ' Enter field name' //, // ajax: { // url: 'app/misc/get_employee.php', // dataType: 'json', // delay: 250, // data: function (data) { // return { // searchTerm: data.term // search term // }; // }, // processResults: function (response) { // return { // results:response // }; // }, // cache: true // } }); </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