File manager

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

Back
<?php include('cfg/db.php'); // include('app/security/security.php'); if(!isset($_SESSION['user']['id'])){ header('location:signin.php'); } // $check_page = new CheckPage(); // $check_page->start($db); // if(!(isset($_SESSION['user']['action_permissions']['4']['sub_18_1']) && // $_SESSION['user']['action_permissions']['4']['sub_18_1'])){ // header('location:signin.php'); // } if(isset($_GET['dms']) && isset($_GET['type'])){ $source_dms_id = intval($db -> escape($_GET['dms'])); if($db -> sql_query("SELECT id FROM source_dms WHERE status <> 0 AND id = '$source_dms_id' AND status =1 ") -> num_rows < 1){ header('location:dms.php'); } $source_dms_type_id = intval($db -> escape($_GET['type'])); if($db -> sql_query("SELECT id FROM source_dms_type WHERE id = '$source_dms_type_id' AND status =1 ") -> num_rows < 1){ header('location:dms.php'); } }else{ $source_dms_id = (int) $db -> select ("SELECT id FROM source_dms WHERE status <> 0 ORDER BY name ASC LIMIT 1"); $source_dms_type_id = (int) $db -> select ("SELECT `id`, `name` FROM `source_dms_type` WHERE `status` = 1 ORDER BY name ASC LIMIT 1"); } $_SESSION['selected_dms_id'] = $source_dms_id; $_SESSION['selected_dms_type_id'] = $source_dms_type_id; ?> <!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 card-tabs"> <div class="card-header p-0 pt-1"> <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist"> <?php $dms = $db -> return_result("SELECT `id`, `name` FROM `source_dms` WHERE status=1 ORDER BY name ASC"); $count = 0; foreach($dms as $data){ ?> <li class="nav-item"> <a onclick= "getDmsId(<?php echo $data['id']; ?>)" class="nav-link <?php if($data['id']==$_SESSION['selected_dms_id']){echo 'active'; } ?>" id="<?php echo $data['id']; ?>" name="<?php echo $data['id']; ?>" data-toggle="pill" href="#<?php echo $data['id']; ?>" role="tab" aria-controls="<?php echo $data['id']; ?>" aria-selected="true"><?php echo $data['name']; ?></a> </li> <?php $count++; } ?> </ul> </div> <div class="overlay" id="loader" style="display:none;"> <div class="fas fa-2x fa-sync-alt fa-spin "> </div> <strong><span class="ml-2" id="loading-message"> Loading, please wait...</span></strong> </div> <div class="overlay" id="loader-main" style="display:;"> <div class="fas fa-2x fa-sync-alt fa-spin "> </div> <strong><span class="ml-2" id="loading-message-grid"> Loading, please wait...</span></strong> </div> <div class="card-body"> <div class="card card-primary card-outline card-tabs"> <div class="card-header p-0 pt-1 border-bottom-0"> <ul class="nav nav-tabs" id="custom-tabs-three-tab" role="tablist"> <?php $db_type = $db -> return_result("SELECT `id`, `name` FROM `source_dms_type` WHERE `status` = 1 ORDER BY name ASC"); $count1 = 0; $db_type_ids = array(); foreach($db_type as $data1){ $db_type_ids = array_merge($db_type_ids,array($data1['id'])); ?> <li class="nav-item"> <a onclick= "getDmsTypeId(<?php echo $data1['id']; ?>)" class="nav-link <?php if($data1['id']==$_SESSION['selected_dms_type_id'] ){echo 'active'; } ?>" id="db-tab-<?php echo $data1['id']; ?>" name="<?php echo $data1['id']; ?>" data-toggle="pill" href="#db-<?php echo $data1['id']; ?>" role="tab" aria-controls="db-<?php echo $data1['id']; ?>" aria-selected="true"><?php echo $data1['name']; ?></a> </li> <?php $count1++; } //print_r($db_type_ids); ?> </ul> </div> <div class="card-body"> <div class="tab-content" id="custom-tabs-three-tabContent"> <div class="tab-pane fade show <?php if($_SESSION['selected_dms_type_id'] == 1){echo "active";} ?>" id="db-<?php echo $db_type_ids[0]; ?>" role="tabpanel" aria-labelledby="db-tab-<?php echo $db_type_ids[0]; ?>"> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Customer ID<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 1 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Salutation</label> <div class="col-sm-8"> <select id="salutation" name="salutation" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 2 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Firstname<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 3 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Middlename</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 4 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Lastname<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 5 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Suffix</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 110 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Customer Name (Corporation)<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="customername" name="customername" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 6 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Gender</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 7 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Birthday</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 8 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Nationality</label> <div class="col-sm-8"> <select id="nationality" name="nationality" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 10 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Marital Status</label> <div class="col-sm-8"> <select id="maritalstatus" name="maritalstatus" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 11 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">No. of children</label> <div class="col-sm-8"> <select id="noofchildren" name="noofchildren" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 12 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Hobby</label> <div class="col-sm-8"> <select id="hobby" name="hobby" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 13 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Affiliations</label> <div class="col-sm-8"> <select id="affiliations" name="affiliations" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 123 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Spouse</label> <div class="col-sm-8"> <select id="spouse" name="spouse" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 14 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Religion</label> <div class="col-sm-8"> <select id="religion" name="religion" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 124 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Occupation/Position</label> <div class="col-sm-8"> <select id="occupation" name="occupation" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 15 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Nature of Work/Business</label> <div class="col-sm-8"> <select id="nature_of_work" name="nature_of_work" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 131 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Profession</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 132 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Email 1 <!-- <label style="color:red; float-right"></label>--></label> <div class="col-sm-8"> <select id="email1" name="email1" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 16 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Email 2</label> <div class="col-sm-8"> <select id="email2" name="email2" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 17 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Mobile 1</label> <div class="col-sm-8"> <select id="mobile1" name="mobile1" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 18 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Mobile 2</label> <div class="col-sm-8"> <select id="mobile2" name="mobile2" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 19 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Fax</label> <div class="col-sm-8"> <select id="fax" name="fax" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 20 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Business Phone</label> <div class="col-sm-8"> <select id="businessphone" name="businessphone" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 109 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Home Phone</label> <div class="col-sm-8"> <select id="residential" name="residential" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 21 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Viber</label> <div class="col-sm-8"> <select id="viber" name="viber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 125 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Telegram</label> <div class="col-sm-8"> <select id="telegram" name="telegram" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 126 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Facebook Username</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 127 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Instagram Username</label> <div class="col-sm-8"> <select id="instagram" name="instagram" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 128 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Whatsapp</label> <div class="col-sm-8"> <select id="whatsapp" name="whatsapp" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 129 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Website </label> <div class="col-sm-8"> <select id="website" name="website" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 130 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Address 1</label> <div class="col-sm-8"> <select id="address1" name="address1" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 108 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">City 1</label> <div class="col-sm-8"> <select id="city1" name="city1" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 22 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">State 1</label> <div class="col-sm-8"> <select id="state1" name="state1" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 23 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Postal 1</label> <div class="col-sm-8"> <select id="postal1" name="postal1" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 24 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Address 2</label> <div class="col-sm-8"> <select id="address2" name="address2" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 25 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">City 2</label> <div class="col-sm-8"> <select id="city2" name="city2" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 26 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">State 2</label> <div class="col-sm-8"> <select id="state2" name="state2" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 27 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Postal 2</label> <div class="col-sm-8"> <select id="postal2" name="postal2" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 28 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Source of Inquire</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 29 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Business/Company Name</label> <div class="col-sm-8"> <select id="businessname" name="businessname" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 30 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Contact Person</label> <div class="col-sm-8"> <select id="contactperson" name="contactperson" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 32 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Date Created</label> <div class="col-sm-8"> <select id="datecreated" name="datecreated" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 33 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Time Created</label> <div class="col-sm-8"> <select id="timecreated" name="timecreated" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 34 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">DMS Assigned</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 145 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Company Assigned</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 134 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Dealer Assigned</label> <div class="col-sm-8"> <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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=1 AND id = 114 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="tab-pane fade show <?php if($_SESSION['selected_dms_type_id'] == 2){echo "active";} ?>" id="db-<?php echo $db_type_ids[1]; ?>" role="tabpanel" aria-labelledby="db-tab-<?php echo $db_type_ids[1]; ?>"> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Customer ID<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="2customerid" name="2customerid" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 35 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Plate Number<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="2platenumber" name="2platenumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 46 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Conduction Sticker<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="2conductionsticker" name="2conductionsticker" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 50 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Color</label> <div class="col-sm-8"> <select id="2color" name="2color" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 36 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Brand</label> <div class="col-sm-8"> <select id="2brand" name="2brand" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 37 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Model Name</label> <div class="col-sm-8"> <select id="2model" name="2model" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 38 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Model Variant</label> <div class="col-sm-8"> <select id="2modeldescription" name="2modeldescription" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 45 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" style="display: none;"> <label class="col-sm-3 col-form-label">Model No.</label> <div class="col-sm-8"> <select id="2modelno" name="2modelno" 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` // WHERE // `dms_id` = '$source_dms_id' AND // `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 122 LIMIT 1) // ORDER BY name ASC "); // foreach($field as $data){ // echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; // } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Engine Type</label> <div class="col-sm-8"> <select id="2engine" name="2engine" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 39 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Gas Type</label> <div class="col-sm-8"> <select id="2gas" name="2gas" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 40 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Insurance Company</label> <div class="col-sm-8"> <select id="2insurancecompany" name="2insurancecompany" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 41 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Insurance Type</label> <div class="col-sm-8"> <select id="2insurancetype" name="2insurancetype" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 42 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Insurance Expiration Date</label> <div class="col-sm-8"> <select id="2insuranceexpirationdate" name="2insuranceexpirationdate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 43 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Finance Company</label> <div class="col-sm-8"> <select id="2financecompany" name="2financecompany" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 44 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Chassis Number</label> <div class="col-sm-8"> <select id="2chassisnumber" name="2chassisnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 47 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Serial Number</label> <div class="col-sm-8"> <select id="2serialnumber" name="2serialnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 48 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">VIN Number</label> <div class="col-sm-8"> <select id="2vinnumber" name="2vinnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 49 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Registration Number</label> <div class="col-sm-8"> <select id="2regno" name="2regno" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 133 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Who Drives</label> <div class="col-sm-8"> <select id="2whodrives" name="2whodrives" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 51 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Purchase Car As</label> <div class="col-sm-8"> <select id="2purchasecaras" name="2purchasecaras" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 52 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Delivery Date</label> <div class="col-sm-8"> <select id="2deliverydate" name="2deliverydate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 53 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Year Model</label> <div class="col-sm-8"> <select id="2yearmodel" name="2yearmodel" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 54 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Description</label> <div class="col-sm-8"> <select id="2description" name="2description" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 55 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Transmission</label> <div class="col-sm-8"> <select id="2transmission" name="2transmission" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 56 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Service Advisor</label> <div class="col-sm-8"> <select id="2serviceadvisor" name="2serviceadvisor" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 57 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Sales Person</label> <div class="col-sm-8"> <select id="2salesperson" name="2salesperson" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 58 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Modify Date</label> <div class="col-sm-8"> <select id="2modifydate" name="2modifydate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 59 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Notes</label> <div class="col-sm-8"> <select id="2notes" name="2notes" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 60 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Date Created</label> <div class="col-sm-8"> <select id="2datecreated" name="2datecreated" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 61 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Time Created</label> <div class="col-sm-8"> <select id="2timecreated" name="2timecreated" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 62 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">DMS Assigned</label> <div class="col-sm-8"> <select id="2dms" name="2dms" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 146 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Company Assigned</label> <div class="col-sm-8"> <select id="2company" name="2company" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 135 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Dealer Assigned</label> <div class="col-sm-8"> <select id="2dealer" name="2dealer" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=2 AND id = 115 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="tab-pane fade show <?php if($_SESSION['selected_dms_type_id'] == 3){echo "active";} ?>" id="db-<?php echo $db_type_ids[2]; ?>" role="tabpanel" aria-labelledby="db-tab-<?php echo $db_type_ids[2]; ?>"> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Customer ID<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="3customerid" name="3customerid" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 63 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">RO Number<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="3ronumber" name="3ronumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 64 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">RO Date</label> <div class="col-sm-8"> <select id="3rodate" name="3rodate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 65 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">RO Total</label> <div class="col-sm-8"> <select id="3rototal" name="3rototal" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 66 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Brand</label> <div class="col-sm-8"> <select id="3brand" name="3brand" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 111 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Model Name</label> <div class="col-sm-8"> <select id="3model" name="3model" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 112 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Model Description</label> <div class="col-sm-8"> <select id="3modeldescription" name="3modeldescription" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 120 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Plate Number<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="3platenumber" name="3platenumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 67 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Conduction Sticker<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="3conductionsticker" name="3conductionsticker" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 68 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Serial Number</label> <div class="col-sm-8"> <select id="3serialnumber" name="3serialnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 69 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Mileage</label> <div class="col-sm-8"> <select id="3mileage" name="3mileage" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 70 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Recommendation</label> <div class="col-sm-8"> <select id="3recommendation" name="3recommendation" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 71 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Insurance Paid Account</label> <div class="col-sm-8"> <select id="3insurancepaidaccount" name="3insurancepaidaccount" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 72 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Start Date of Service</label> <div class="col-sm-8"> <select id="3startdateofservice" name="3startdateofservice" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 73 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">End Date of Service</label> <div class="col-sm-8"> <select id="3enddateofservice" name="3enddateofservice" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 74 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Service Advisor</label> <div class="col-sm-8"> <select id="3serviceadvisor" name="3serviceadvisor" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 75 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Job Code</label> <div class="col-sm-8"> <select id="3jobcode" name="3jobcode" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 76 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Notes</label> <div class="col-sm-8"> <select id="3notes" name="3notes" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 77 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Problem Cause</label> <div class="col-sm-8"> <select id="3problemcause" name="3problemcause" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 78 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Correction</label> <div class="col-sm-8"> <select id="3correction" name="3correction" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 79 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Job Summary</label> <div class="col-sm-8"> <select id="3jobsummary" name="3jobsummary" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 80 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Customer Paid Amount</label> <div class="col-sm-8"> <select id="3paidamount" name="3paidamount" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 81 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">DMS Assigned</label> <div class="col-sm-8"> <select id="3dms" name="3dms" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 147 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Company Assigned</label> <div class="col-sm-8"> <select id="3company" name="3company" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 136 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Dealer Assigned</label> <div class="col-sm-8"> <select id="3dealer" name="3dealer" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=3 AND id = 116 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="tab-pane fade show <?php if($_SESSION['selected_dms_type_id'] == 4){echo "active";} ?>" id="db-<?php echo $db_type_ids[3]; ?>" role="tabpanel" aria-labelledby="db-tab-<?php echo $db_type_ids[3]; ?>"> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Customer ID<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="4customerid" name="4customerid" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 82 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Brand</label> <div class="col-sm-8"> <select id="4brand" name="4brand" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 118 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Model Name</label> <div class="col-sm-8"> <select id="4model" name="4model" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 119 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Model Description</label> <div class="col-sm-8"> <select id="4modeldescription" name="4modeldescription" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 121 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Plate Number</label> <div class="col-sm-8"> <select id="4platenumber" name="4platenumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 113 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Conduction Sticker<label style="color:red; float-right"></label></label> <div class="col-sm-8"> <select id="4conductionsticker" name="4conductionsticker" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 83 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Order Number<label style="color:red; float-right">*</label></label> <div class="col-sm-8"> <select id="4ordernumber" name="4ordernumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 84 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Serial Number</label> <div class="col-sm-8"> <select id="4serialnumber" name="4serialnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 85 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Engine Number</label> <div class="col-sm-8"> <select id="4enginenumber" name="4enginenumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 86 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">PO Number</label> <div class="col-sm-8"> <select id="4ponumber" name="4ponumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 87 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Floor Plan Amount</label> <div class="col-sm-8"> <select id="4floorplanamount" name="4floorplanamount" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 88 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Sales Date</label> <div class="col-sm-8"> <select id="4activitydate" name="4activitydate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 89 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Sales Cost</label> <div class="col-sm-8"> <select id="4salescost" name="4salescost" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 90 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Sales Price</label> <div class="col-sm-8"> <select id="4salesprice" name="4salesprice" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 91 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Insurance Company</label> <div class="col-sm-8"> <select id="4insurancecompany" name="4insurancecompany" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 92 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Insurance Type</label> <div class="col-sm-8"> <select id="4insurancetype" name="4insurancetype" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 93 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Insurance Expiration Date</label> <div class="col-sm-8"> <select id="4insuranceexpirationdate" name="4insuranceexpirationdate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 95 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Finance Company</label> <div class="col-sm-8"> <select id="4financecompany" name="4financecompany" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 94 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Finance Expiration Date</label> <div class="col-sm-8"> <select id="4financeexpiration" name="4financeexpiration" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 144 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Mode of Contact</label> <div class="col-sm-8"> <select id="4modeofcontact" name="4modeofcontact" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 96 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Source of Sale</label> <div class="col-sm-8"> <select id="4sourceofinquire" name="4sourceofinquire" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 97 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Warehouse</label> <div class="col-sm-8"> <select id="4warehouse" name="4warehouse" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 98 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Stock Number</label> <div class="col-sm-8"> <select id="4stocknumber" name="4stocknumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 99 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Age Unit</label> <div class="col-sm-8"> <select id="4ageofunit" name="4ageofunit" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 100 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Claim Amount</label> <div class="col-sm-8"> <select id="4claimamount" name="4claimamount" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 101 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Claim Number</label> <div class="col-sm-8"> <select id="4claimnumber" name="4claimnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 102 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Body Size Code</label> <div class="col-sm-8"> <select id="4bodysizecode" name="4bodysizecode" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 103 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Deal Number</label> <div class="col-sm-8"> <select id="4dealnumber" name="4dealnumber" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 104 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">Deal Date</label> <div class="col-sm-8"> <select id="4dealdate" name="4dealdate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 105 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Group Manager</label> <div class="col-sm-8"> <select id="4groupmanager" name="4groupmanager" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 140 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Sales Person</label> <div class="col-sm-8"> <select id="4salesperson" name="4salesperson" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 106 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Delivery Date</label> <div class="col-sm-8"> <select id="4deliverydate" name="4deliverydate" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 107 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Mode of Sale</label> <div class="col-sm-8"> <select id="4modeofsale" name="4modeofsale" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 138 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Type of Payment</label> <div class="col-sm-8"> <select id="4typeofsale" name="4typeofsale" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 139 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Sales Discount</label> <div class="col-sm-8"> <select id="4salesdiscount" name="4salesdiscount" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 141 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">End User</label> <div class="col-sm-8"> <select id="4enduser" name="4enduser" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 142 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Driver</label> <div class="col-sm-8"> <select id="4driver" name="4driver" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 143 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" > <label class="col-sm-3 col-form-label">Future Vehicle</label> <div class="col-sm-8"> <select id="4vehicleoffered" name="4vehicleoffered" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 149 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0" hidden> <label class="col-sm-3 col-form-label">DMS Assigned</label> <div class="col-sm-8"> <select id="4dms" name="4dms" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 148 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Company Assigned</label> <div class="col-sm-8"> <select id="4company" name="4company" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 137 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="form-group row mt-0 mb-0"> <label class="col-sm-3 col-form-label">Dealer Assigned</label> <div class="col-sm-8"> <select id="4dealer" name="4dealer" 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` WHERE `dms_id` = '$source_dms_id' AND `dms_field_id` = (SELECT id FROM source_dms_fields WHERE dms_type_id=4 AND id = 117 LIMIT 1) ORDER BY name ASC "); foreach($field as $data){ echo "<option value='{$data['name']}' selected>".$data['name']."</option>"; } ?> </select> </div> </div> </div> </div> <!--Custom-tabs-three-tabConten --> </div> <!-- /.card --> </div> </div><!-- /.col-md --> </div><!-- /.row --> </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(); }); }); var dms_id = <?php echo $_SESSION['selected_dms_id'];?>; var dms_type_id = <?php echo $_SESSION['selected_dms_type_id']; ?>; $(document.body).on("change","#customer-id",function(){ var el = document.getElementsByName('customer-id')[0]; var field_names = getSelectValues(el); var dms_field_id = "1"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#salutation",function(){ var el = document.getElementsByName('salutation')[0]; var field_names = getSelectValues(el); var dms_field_id = "2"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#firstname",function(){ var el = document.getElementsByName('firstname')[0]; var field_names = getSelectValues(el); var dms_field_id = "3"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#middlename",function(){ var el = document.getElementsByName('middlename')[0]; var field_names = getSelectValues(el); var dms_field_id = "4"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#lastname",function(){ var el = document.getElementsByName('lastname')[0]; var field_names = getSelectValues(el); var dms_field_id = "5"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#suffix",function(){ var el = document.getElementsByName('suffix')[0]; var field_names = getSelectValues(el); var dms_field_id = "110"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#customername",function(){ var el = document.getElementsByName('customername')[0]; var field_names = getSelectValues(el); var dms_field_id = "6"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#gender",function(){ var el = document.getElementsByName('gender')[0]; var field_names = getSelectValues(el); var dms_field_id = "7"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#birthday",function(){ var el = document.getElementsByName('birthday')[0]; var field_names = getSelectValues(el); var dms_field_id = "8"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#nationality",function(){ var el = document.getElementsByName('nationality')[0]; var field_names = getSelectValues(el); var dms_field_id = "10"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#maritalstatus",function(){ var el = document.getElementsByName('maritalstatus')[0]; var field_names = getSelectValues(el); var dms_field_id = "11"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#noofchildren",function(){ var el = document.getElementsByName('noofchildren')[0]; var field_names = getSelectValues(el); var dms_field_id = "12"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#hobby",function(){ var el = document.getElementsByName('hobby')[0]; var field_names = getSelectValues(el); var dms_field_id = "13"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#affiliations",function(){ var el = document.getElementsByName('affiliations')[0]; var field_names = getSelectValues(el); var dms_field_id = "123"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#spouse",function(){ var el = document.getElementsByName('spouse')[0]; var field_names = getSelectValues(el); var dms_field_id = "14"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#religion",function(){ var el = document.getElementsByName('religion')[0]; var field_names = getSelectValues(el); var dms_field_id = "124"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#occupation",function(){ var el = document.getElementsByName('occupation')[0]; var field_names = getSelectValues(el); var dms_field_id = "15"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#nature_of_work",function(){ var el = document.getElementsByName('nature_of_work')[0]; var field_names = getSelectValues(el); var dms_field_id = "131"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#profession",function(){ var el = document.getElementsByName('profession')[0]; var field_names = getSelectValues(el); var dms_field_id = "132"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#email1",function(){ var el = document.getElementsByName('email1')[0]; var field_names = getSelectValues(el); var dms_field_id = "16"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#email2",function(){ var el = document.getElementsByName('email2')[0]; var field_names = getSelectValues(el); var dms_field_id = "17"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#mobile1",function(){ var el = document.getElementsByName('mobile1')[0]; var field_names = getSelectValues(el); var dms_field_id = "18"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#mobile2",function(){ var el = document.getElementsByName('mobile2')[0]; var field_names = getSelectValues(el); var dms_field_id = "19"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#fax",function(){ var el = document.getElementsByName('fax')[0]; var field_names = getSelectValues(el); var dms_field_id = "20"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#businessphone",function(){ var el = document.getElementsByName('businessphone')[0]; var field_names = getSelectValues(el); var dms_field_id = "109"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#residential",function(){ var el = document.getElementsByName('residential')[0]; var field_names = getSelectValues(el); var dms_field_id = "21"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#viber",function(){ var el = document.getElementsByName('viber')[0]; var field_names = getSelectValues(el); var dms_field_id = "125"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#telegram",function(){ var el = document.getElementsByName('telegram')[0]; var field_names = getSelectValues(el); var dms_field_id = "126"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#facebook",function(){ var el = document.getElementsByName('facebook')[0]; var field_names = getSelectValues(el); var dms_field_id = "127"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#instagram",function(){ var el = document.getElementsByName('instagram')[0]; var field_names = getSelectValues(el); var dms_field_id = "128"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#whatsapp",function(){ var el = document.getElementsByName('whatsapp')[0]; var field_names = getSelectValues(el); var dms_field_id = "129"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#website",function(){ var el = document.getElementsByName('website')[0]; var field_names = getSelectValues(el); var dms_field_id = "130"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#address1",function(){ var el = document.getElementsByName('address1')[0]; var field_names = getSelectValues(el); var dms_field_id = "108"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#city1",function(){ var el = document.getElementsByName('city1')[0]; var field_names = getSelectValues(el); var dms_field_id = "22"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#state1",function(){ var el = document.getElementsByName('state1')[0]; var field_names = getSelectValues(el); var dms_field_id = "23"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#postal1",function(){ var el = document.getElementsByName('postal1')[0]; var field_names = getSelectValues(el); var dms_field_id = "24"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#address2",function(){ var el = document.getElementsByName('address2')[0]; var field_names = getSelectValues(el); var dms_field_id = "25"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#city2",function(){ var el = document.getElementsByName('city2')[0]; var field_names = getSelectValues(el); var dms_field_id = "26"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#state2",function(){ var el = document.getElementsByName('state2')[0]; var field_names = getSelectValues(el); var dms_field_id = "27"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#postal2",function(){ var el = document.getElementsByName('postal2')[0]; var field_names = getSelectValues(el); var dms_field_id = "28"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#source",function(){ var el = document.getElementsByName('source')[0]; var field_names = getSelectValues(el); var dms_field_id = "29"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#businessname",function(){ var el = document.getElementsByName('businessname')[0]; var field_names = getSelectValues(el); var dms_field_id = "30"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#contactperson",function(){ var el = document.getElementsByName('contactperson')[0]; var field_names = getSelectValues(el); var dms_field_id = "32"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#datecreated",function(){ var el = document.getElementsByName('datecreated')[0]; var field_names = getSelectValues(el); var dms_field_id = "33"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#timecreated",function(){ var el = document.getElementsByName('timecreated')[0]; var field_names = getSelectValues(el); var dms_field_id = "34"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2customerid",function(){ var el = document.getElementsByName('2customerid')[0]; var field_names = getSelectValues(el); var dms_field_id = "35"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2color",function(){ var el = document.getElementsByName('2color')[0]; var field_names = getSelectValues(el); var dms_field_id = "36"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2brand",function(){ var el = document.getElementsByName('2brand')[0]; var field_names = getSelectValues(el); var dms_field_id = "37"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2model",function(){ var el = document.getElementsByName('2model')[0]; var field_names = getSelectValues(el); var dms_field_id = "38"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2modelno",function(){ var el = document.getElementsByName('2modelno')[0]; var field_names = getSelectValues(el); var dms_field_id = "122"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2engine",function(){ var el = document.getElementsByName('2engine')[0]; var field_names = getSelectValues(el); var dms_field_id = "39"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2gas",function(){ var el = document.getElementsByName('2gas')[0]; var field_names = getSelectValues(el); var dms_field_id = "40"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2insurancecompany",function(){ var el = document.getElementsByName('2insurancecompany')[0]; var field_names = getSelectValues(el); var dms_field_id = "41"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2insurancetype",function(){ var el = document.getElementsByName('2insurancetype')[0]; var field_names = getSelectValues(el); var dms_field_id = "42"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2insuranceexpirationdate",function(){ var el = document.getElementsByName('2insuranceexpirationdate')[0]; var field_names = getSelectValues(el); var dms_field_id = "43"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2financecompany",function(){ var el = document.getElementsByName('2financecompany')[0]; var field_names = getSelectValues(el); var dms_field_id = "44"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2modeldescription",function(){ var el = document.getElementsByName('2modeldescription')[0]; var field_names = getSelectValues(el); var dms_field_id = "45"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3modeldescription",function(){ var el = document.getElementsByName('3modeldescription')[0]; var field_names = getSelectValues(el); var dms_field_id = "120"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4modeldescription",function(){ var el = document.getElementsByName('4modeldescription')[0]; var field_names = getSelectValues(el); var dms_field_id = "121"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2platenumber",function(){ var el = document.getElementsByName('2platenumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "46"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2chassisnumber",function(){ var el = document.getElementsByName('2chassisnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "47"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2serialnumber",function(){ var el = document.getElementsByName('2serialnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "48"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2vinnumber",function(){ var el = document.getElementsByName('2vinnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "49"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2regno",function(){ var el = document.getElementsByName('2regno')[0]; var field_names = getSelectValues(el); var dms_field_id = "133"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2conductionsticker",function(){ var el = document.getElementsByName('2conductionsticker')[0]; var field_names = getSelectValues(el); var dms_field_id = "50"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2whodrives",function(){ var el = document.getElementsByName('2whodrives')[0]; var field_names = getSelectValues(el); var dms_field_id = "51"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2purchasecaras",function(){ var el = document.getElementsByName('2purchasecaras')[0]; var field_names = getSelectValues(el); var dms_field_id = "52"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2deliverydate",function(){ var el = document.getElementsByName('2deliverydate')[0]; var field_names = getSelectValues(el); var dms_field_id = "53"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2yearmodel",function(){ var el = document.getElementsByName('2yearmodel')[0]; var field_names = getSelectValues(el); var dms_field_id = "54"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2description",function(){ var el = document.getElementsByName('2description')[0]; var field_names = getSelectValues(el); var dms_field_id = "55"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2transmission",function(){ var el = document.getElementsByName('2transmission')[0]; var field_names = getSelectValues(el); var dms_field_id = "56"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2serviceadvisor",function(){ var el = document.getElementsByName('2serviceadvisor')[0]; var field_names = getSelectValues(el); var dms_field_id = "57"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2salesperson",function(){ var el = document.getElementsByName('2salesperson')[0]; var field_names = getSelectValues(el); var dms_field_id = "58"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2modifydate",function(){ var el = document.getElementsByName('2modifydate')[0]; var field_names = getSelectValues(el); var dms_field_id = "59"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2notes",function(){ var el = document.getElementsByName('2notes')[0]; var field_names = getSelectValues(el); var dms_field_id = "60"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2datecreated",function(){ var el = document.getElementsByName('2datecreated')[0]; var field_names = getSelectValues(el); var dms_field_id = "61"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2timecreated",function(){ var el = document.getElementsByName('2timecreated')[0]; var field_names = getSelectValues(el); var dms_field_id = "62"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2timecreated",function(){ var el = document.getElementsByName('2timecreated')[0]; var field_names = getSelectValues(el); var dms_field_id = "62"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3customerid",function(){ var el = document.getElementsByName('3customerid')[0]; var field_names = getSelectValues(el); var dms_field_id = "63"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3ronumber",function(){ var el = document.getElementsByName('3ronumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "64"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3rodate",function(){ var el = document.getElementsByName('3rodate')[0]; var field_names = getSelectValues(el); var dms_field_id = "65"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3rototal",function(){ var el = document.getElementsByName('3rototal')[0]; var field_names = getSelectValues(el); var dms_field_id = "66"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3brand",function(){ var el = document.getElementsByName('3brand')[0]; var field_names = getSelectValues(el); var dms_field_id = "111"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3model",function(){ var el = document.getElementsByName('3model')[0]; var field_names = getSelectValues(el); var dms_field_id = "112"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3platenumber",function(){ var el = document.getElementsByName('3platenumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "67"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3conductionsticker",function(){ var el = document.getElementsByName('3conductionsticker')[0]; var field_names = getSelectValues(el); var dms_field_id = "68"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3serialnumber",function(){ var el = document.getElementsByName('3serialnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "69"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3mileage",function(){ var el = document.getElementsByName('3mileage')[0]; var field_names = getSelectValues(el); var dms_field_id = "70"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3recommendation",function(){ var el = document.getElementsByName('3recommendation')[0]; var field_names = getSelectValues(el); var dms_field_id = "71"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3insurancepaidaccount",function(){ var el = document.getElementsByName('3insurancepaidaccount')[0]; var field_names = getSelectValues(el); var dms_field_id = "72"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3startdateofservice",function(){ var el = document.getElementsByName('3startdateofservice')[0]; var field_names = getSelectValues(el); var dms_field_id = "73"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3enddateofservice",function(){ var el = document.getElementsByName('3enddateofservice')[0]; var field_names = getSelectValues(el); var dms_field_id = "74"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3serviceadvisor",function(){ var el = document.getElementsByName('3serviceadvisor')[0]; var field_names = getSelectValues(el); var dms_field_id = "75"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3jobcode",function(){ var el = document.getElementsByName('3jobcode')[0]; var field_names = getSelectValues(el); var dms_field_id = "76"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3notes",function(){ var el = document.getElementsByName('3notes')[0]; var field_names = getSelectValues(el); var dms_field_id = "77"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3problemcause",function(){ var el = document.getElementsByName('3problemcause')[0]; var field_names = getSelectValues(el); var dms_field_id = "78"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3correction",function(){ var el = document.getElementsByName('3correction')[0]; var field_names = getSelectValues(el); var dms_field_id = "79"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3jobsummary",function(){ var el = document.getElementsByName('3jobsummary')[0]; var field_names = getSelectValues(el); var dms_field_id = "80"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3paidamount",function(){ var el = document.getElementsByName('3paidamount')[0]; var field_names = getSelectValues(el); var dms_field_id = "81"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4customerid",function(){ var el = document.getElementsByName('4customerid')[0]; var field_names = getSelectValues(el); var dms_field_id = "82"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4brand",function(){ var el = document.getElementsByName('4brand')[0]; var field_names = getSelectValues(el); var dms_field_id = "118"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4model",function(){ var el = document.getElementsByName('4model')[0]; var field_names = getSelectValues(el); var dms_field_id = "119"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4platenumber",function(){ var el = document.getElementsByName('4platenumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "113"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4conductionsticker",function(){ var el = document.getElementsByName('4conductionsticker')[0]; var field_names = getSelectValues(el); var dms_field_id = "83"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4ordernumber",function(){ var el = document.getElementsByName('4ordernumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "84"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4serialnumber",function(){ var el = document.getElementsByName('4serialnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "85"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4enginenumber",function(){ var el = document.getElementsByName('4enginenumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "86"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4ponumber",function(){ var el = document.getElementsByName('4ponumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "87"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4floorplanamount",function(){ var el = document.getElementsByName('4floorplanamount')[0]; var field_names = getSelectValues(el); var dms_field_id = "88"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4activitydate",function(){ var el = document.getElementsByName('4activitydate')[0]; var field_names = getSelectValues(el); var dms_field_id = "89"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4salescost",function(){ var el = document.getElementsByName('4salescost')[0]; var field_names = getSelectValues(el); var dms_field_id = "90"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4salesprice",function(){ var el = document.getElementsByName('4salesprice')[0]; var field_names = getSelectValues(el); var dms_field_id = "91"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4insurancecompany",function(){ var el = document.getElementsByName('4insurancecompany')[0]; var field_names = getSelectValues(el); var dms_field_id = "92"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4insurancetype",function(){ var el = document.getElementsByName('4insurancetype')[0]; var field_names = getSelectValues(el); var dms_field_id = "93"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4financecompany",function(){ var el = document.getElementsByName('4financecompany')[0]; var field_names = getSelectValues(el); var dms_field_id = "94"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4financeexpiration",function(){ var el = document.getElementsByName('4financeexpiration')[0]; var field_names = getSelectValues(el); var dms_field_id = "144"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4insuranceexpirationdate",function(){ var el = document.getElementsByName('4insuranceexpirationdate')[0]; var field_names = getSelectValues(el); var dms_field_id = "95"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4modeofcontact",function(){ var el = document.getElementsByName('4modeofcontact')[0]; var field_names = getSelectValues(el); var dms_field_id = "96"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4sourceofinquire",function(){ var el = document.getElementsByName('4sourceofinquire')[0]; var field_names = getSelectValues(el); var dms_field_id = "97"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4warehouse",function(){ var el = document.getElementsByName('4warehouse')[0]; var field_names = getSelectValues(el); var dms_field_id = "98"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4stocknumber",function(){ var el = document.getElementsByName('4stocknumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "99"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4ageofunit",function(){ var el = document.getElementsByName('4ageofunit')[0]; var field_names = getSelectValues(el); var dms_field_id = "100"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4claimamount",function(){ var el = document.getElementsByName('4claimamount')[0]; var field_names = getSelectValues(el); var dms_field_id = "101"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4claimnumber",function(){ var el = document.getElementsByName('4claimnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "102"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4bodysizecode",function(){ var el = document.getElementsByName('4bodysizecode')[0]; var field_names = getSelectValues(el); var dms_field_id = "103"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4dealnumber",function(){ var el = document.getElementsByName('4dealnumber')[0]; var field_names = getSelectValues(el); var dms_field_id = "104"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4dealdate",function(){ var el = document.getElementsByName('4dealdate')[0]; var field_names = getSelectValues(el); var dms_field_id = "105"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4salesperson",function(){ var el = document.getElementsByName('4salesperson')[0]; var field_names = getSelectValues(el); var dms_field_id = "106"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4groupmanager",function(){ var el = document.getElementsByName('4groupmanager')[0]; var field_names = getSelectValues(el); var dms_field_id = "140"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4deliverydate",function(){ var el = document.getElementsByName('4deliverydate')[0]; var field_names = getSelectValues(el); var dms_field_id = "107"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4modeofsale",function(){ var el = document.getElementsByName('4modeofsale')[0]; var field_names = getSelectValues(el); var dms_field_id = "138"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4typeofsale",function(){ var el = document.getElementsByName('4typeofsale')[0]; var field_names = getSelectValues(el); var dms_field_id = "139"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4salesdiscount",function(){ var el = document.getElementsByName('4salesdiscount')[0]; var field_names = getSelectValues(el); var dms_field_id = "141"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4enduser",function(){ var el = document.getElementsByName('4enduser')[0]; var field_names = getSelectValues(el); var dms_field_id = "142"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4driver",function(){ var el = document.getElementsByName('4driver')[0]; var field_names = getSelectValues(el); var dms_field_id = "143"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4vehicleoffered",function(){ var el = document.getElementsByName('4vehicleoffered')[0]; var field_names = getSelectValues(el); var dms_field_id = "149"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#dealer",function(){ var el = document.getElementsByName('dealer')[0]; var field_names = getSelectValues(el); var dms_field_id = "114"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2dealer",function(){ var el = document.getElementsByName('2dealer')[0]; var field_names = getSelectValues(el); var dms_field_id = "115"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3dealer",function(){ var el = document.getElementsByName('3dealer')[0]; var field_names = getSelectValues(el); var dms_field_id = "116"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4dealer",function(){ var el = document.getElementsByName('4dealer')[0]; var field_names = getSelectValues(el); var dms_field_id = "117"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#company",function(){ var el = document.getElementsByName('company')[0]; var field_names = getSelectValues(el); var dms_field_id = "134"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2company",function(){ var el = document.getElementsByName('2company')[0]; var field_names = getSelectValues(el); var dms_field_id = "135"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3company",function(){ var el = document.getElementsByName('3company')[0]; var field_names = getSelectValues(el); var dms_field_id = "136"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4company",function(){ var el = document.getElementsByName('4company')[0]; var field_names = getSelectValues(el); var dms_field_id = "137"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#dms",function(){ var el = document.getElementsByName('dms')[0]; var field_names = getSelectValues(el); var dms_field_id = "145"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#2dms",function(){ var el = document.getElementsByName('2dms')[0]; var field_names = getSelectValues(el); var dms_field_id = "146"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#3dms",function(){ var el = document.getElementsByName('3dms')[0]; var field_names = getSelectValues(el); var dms_field_id = "147"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_id}, success:function(result) {} }); }); $(document.body).on("change","#4dms",function(){ var el = document.getElementsByName('4dms')[0]; var field_names = getSelectValues(el); var dms_field_id = "148"; // base on database $.ajax({ url:"app/settings/update_dms_fields.php", method:"POST", dataType: 'json', data: {field_names:field_names,dms_field_id:dms_field_id,dms_id:dms_id,dms_type_id:dms_type_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.01 | proxy | phpinfo | Settings