File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/sales_consultant/reload_sales_consultant.php

Back
<?php include_once("../../cfg/db.php"); $type = $_POST['type']; if($type == 1){ $query = "SELECT `id`, `employee_id`, `first_name`, `last_name` FROM `sales_consultant` WHERE id != 0 AND status = 1"; $sales_consultant = $db -> return_result($query); //echo $query; return; foreach($sales_consultant as $data){ echo "<option value='{$data['id']}'>" . $data['first_name']. " " . $data['last_name'] ."</option>"; } } else if($type == 2){ //if(isset($_POST['sc_id'])){ $sc_id = $_POST['sc_id']; $query = " SELECT id, first_name, last_name, employee_id, DATE_FORMAT(date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, type, mobile_1, mobile_2, email_1, email_2 FROM `sales_consultant` /INNER JOIN employee e ON e.id = cac.added_by/ WHERE id != 0 AND id = '$sc_id' AND status = 1"; //echo $query; return; $sales_consultant_details = $db -> return_result($query); foreach($sales_consultant_details AS $data){ $arr['employee_id'] = $data['employee_id']; $arr['first_name'] = $data['first_name']; $arr['last_name'] = $data['last_name']; $arr['date_added'] = $data['date_added']; $arr['type'] = $data['type']; $arr['mobile_1'] = $data['mobile_1']; $arr['mobile_2'] = $data['mobile_2']; $arr['email_1'] = $data['email_1']; $arr['email_2'] = $data['email_2']; } echo json_encode($arr); //} } else if($type == 3){ $search_item = $db->escape(trim($_POST['search_item'])); $search_query = "SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE CONCAT(IFNULL(employee_id,''),' ',first_name,' ',last_name,' ',first_name) LIKE '%$search_item%' AND status = 1 AND id != 0 "; $result = $db->sql_query($search_query); //echo $search_query; return; while($row = $result->fetch_assoc()) { echo '<option value="'.$row['id'].'">'. $row['first_name'] . " " . $row['last_name'].'</option>'; } } else if($type == 4){ $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 AND type = 0 AND assigned = 0/GROUP BY sc.id/ LIMIT 10"; //echo $query; return; $scs = $db -> return_result($query); foreach($scs as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } else if($type == 5){ //refresh add sc list $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 /GROUP BY sc.id/"; //echo $query; return; $scs = $db -> return_result($query); foreach($scs as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } else if($type == 6){ //reload designate GM list $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 AND type = 1/GROUP BY sc.id/"; //echo $query; return; $gms = $db -> return_result($query); foreach($gms as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } else if($type == 7){ $search_item = $db -> escape(trim($_POST['search_item'])); $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 AND type = 0 AND assigned = 0 AND CONCAT(IFNULL(employee_id,''),' ',first_name,' ',last_name,' ',first_name) LIKE '%$search_item%' /GROUP BY sc.id/ LIMIT 10"; //echo $query; return; $scs = $db -> return_result($query); foreach($scs as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } ?>

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