File manager

File manager - Edit - /home/autoph/public_html/tasks/cis.tar

Back
create_cis_record.php��0000644��00000013224�15025116146�0010717 0��ustar�00��<?php include_once("../../cfg/db.php");; include_once("../../api/controllers/affiliations.php"); include_once("../../api/controllers/cis.php"); include_once("../../api/controllers/utility.php"); $affiliations = new Affiliations(); $cis = new CIS(); $utility = new Utility(); $generated_id = $db -> select("SELECT UUID_SHORT()"); $dealer = $db->escape(trim($_POST['dealer_id'])); $vin = $db->escape(trim($_POST['vin'])); $cs_number = $db->escape(trim($_POST['cs_number'])); $customer_type = $db->escape(trim($_POST['cust_type'])); $payment_type = $db->escape(trim($_POST['payment_type'])); $mop_bank = $db->escape(trim($_POST['mop_bank'])); $mop_terms = $db->escape(trim($_POST['mop_terms'])); $brand_id = $db->escape(trim($_POST['brand_id'])); $model_id = $db->escape(trim($_POST['model_id'])); $source_of_release = $db->escape(trim($_POST['source_of_release'])); $insurance = $db->escape(trim($_POST['insurance'])); $color = $db->escape(trim($_POST['color'])); $sales_consultant = $db->escape(trim($_POST['sales_consultant'])); $delivery_date = $db->escape(trim($_POST['delivery_date'])); $registered_name = $db->escape(trim($_POST['registered_name'])); $group_manager = $db->escape(trim($_POST['group_manager'])); $end_user_name = $db->escape(trim($_POST['end_user_name'])); $own_email = $db->escape(trim($_POST['own_email'])); $own_address = $db->escape(trim($_POST['own_address'])); $own_mobile_1 = $db->escape(trim($_POST['own_mobile_1'])); $own_mobile_2 = $db->escape(trim($_POST['own_mobile_2'])); $gender_id = $db->escape(trim($_POST['gender_id'])); $status = $db->escape(trim($_POST['status'])); $no_of_children = $db->escape(trim($_POST['no_of_children'])); $birthdate = $db->escape(trim($_POST['birth_date'])); $nationality = $db->escape(trim($_POST['nationality'])); $fb_handle = $db->escape(trim($_POST['fb_handle'])); $employee = $db->escape(trim($_POST['employee'])); $brands_offered = $db->escape(trim($_POST['brands_offered'])); $position_title = $db->escape(trim($_POST['position_title'])); $company_name = $db->escape(trim($_POST['company_name'])); $company_email = $db->escape(trim($_POST['company_email'])); $company_address = $db->escape(trim($_POST['company_address'])); $company_mobile_1 = $db->escape(trim($_POST['company_mobile_1'])); $company_mobile_2 = $db->escape(trim($_POST['company_mobile_2'])); $landline = $db->escape(trim($_POST['landline'])); $industrial_classification = $db->escape(trim($_POST['industrial_classification'])); $fleet = $db->escape(trim($_POST['fleet'])); $customer_name = $db->escape(trim($_POST['customer_name'])); $insert_cis_personal_query = " INSERT INTO cis (`id`, `registered_name`, `end_user_name`, `email`, `address`, `mobile_1`, `mobile_2`, `gender_id`, `marital_status_id`, `no_of_children`, `birthdate`, `nationality_id`, `facebook_handle`, `employee_type`, `brands_offered`) VALUES('$generated_id', '$registered_name', '$end_user_name', '$own_email', '$own_address', '$own_mobile_1', '$own_mobile_2', '$gender_id', '$status', '$no_of_children', '$birthdate', '$nationality', '$fb_handle', '$employee', '$brands_offered')"; $insert_cis_sales_query = " INSERT INTO cis_sale_details (`cis_id`, `source_dealer`, `vin`, `cs_number`, `brand_id`, `model_id`, `color`, `delivery_date`, `account_type`, `mode_of_payment`, `mop_bank`, `mop_terms`, `source_of_release`, `insurance`, `sales_consultant`, `group_manager`, `fleet_sales`) VALUES ('$generated_id', '$dealer', '$vin', '$cs_number', '$brand_id', '$model_id', '$color', '$delivery_date', '$customer_type', '$payment_type', '$mop_bank', '$mop_terms', '$source_of_release', '$insurance', '$sales_consultant', '$group_manager', '$fleet')"; $insert_cis_company_query = " INSERT INTO cis_company_details (`cis_id`, `position_title`, `company_name`, `email`, `address`, `mobile_1`, `mobile_2`, `landline`, `industrial_classification`) VALUES ('$generated_id', '$position_title', '$company_name', '$company_email', '$company_address', '$company_mobile_1', '$company_mobile_2', '$landline', '$industrial_classification')"; $personal = $db->sql_query_num_inserted($insert_cis_personal_query); $sales = $db->sql_query_num_inserted($insert_cis_sales_query); $company = $db->sql_query_num_inserted($insert_cis_company_query); $customer_affiliations = isset($_REQUEST['affiliations']) ? $_REQUEST['affiliations'] : '' ; $customer_affiliations_array = array(); if($customer_affiliations <> ''){ $customer_affiliations = array_map(array($utility, 'upperCaseNestedArray'), $customer_affiliations); $customer_affiliations = array_map(array($db, 'escape'), $customer_affiliations); foreach ($customer_affiliations as $customer_affiliation){ $affiliations_category_id = $customer_affiliation['Category']; $affiliations_name = ($customer_affiliation['Affiliations']); $affiliations_id = $affiliations->read_affiliations_id_by_name($affiliations_category_id,$affiliations_name,$db); if(!$utility->isNotEmpty($affiliations_id)){ $affiliations_id = $affiliations->create_affiliations($affiliations_category_id,$affiliations_name,$db); } $customer_affiliations_array[] = "('".$affiliations_id."','$generated_id', '1')"; } $customer_affiliations_to_insert = implode(',',$customer_affiliations_array); $cis->create_customer_affiliations_list($customer_affiliations_to_insert, $db); } if($personal == 0 && $sales == 0 && $company == 0){ $arr['status'] = 0; $arr['message'] = "Something went wrong"; echo json_encode($arr); } else { $arr['status'] = 1; $arr['message'] = "Customer details submitted"; echo json_encode($arr); } ?>��load_sc.php��0000644��00000001004�15025116146�0006655 0��ustar�00��<?php include_once("../../cfg/db.php"); $group_manager_id = $_POST['group_manager_id']; $query = " SELECT sc.id, sc.first_name, sc.last_name FROM `sales_consultant` sc INNER JOIN sales_group sg ON sg.sc_id = sc.id WHERE sg.gm_id = '$group_manager_id' AND sg.gm_id != 0 AND sg.status != 0 ORDER BY sc.id ASC"; $sc = $db -> return_result($query); //echo $query; return; foreach($sc as $data){ echo "<option value='{$data['id']}'>".$data['first_name'] . " " . $data['last_name']."</option>"; } ?>��load_model.php��0000644��00000000543�15025116146�0007357 0��ustar�00��<?php include_once("../../cfg/db.php"); $brand_id = $_POST['brand_id']; $query = "SELECT `id`, `name` FROM `source_car_model` WHERE brand_id = '$brand_id' AND id != 0 ORDER BY name ASC"; $model = $db -> return_result($query); //echo $query; return; foreach($model as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?>��

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