File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/finance/configurations/dealer_contacts.php

Back
<?php include_once("../../../cfg/db.php"); $type = $db->escape($_POST['type']); if($type == 1){ // add dealer $return_arr = array(); $contact_person = $db->escape($_POST['contact_person']); $dealer_id = $db->escape($_POST['dealer_id']); $mobile_1 = $db->escape($_POST['mobile_1']); $mobile_2 = $db->escape($_POST['mobile_2']); $current_user = $_SESSION['user']['id']; if(intval($db->select("SELECT COUNT(1) FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id'")) > 0){ $return_arr['status'] = 0; //duplicate dealer name $return_arr['message'] = "Dealer already in list. You can update it's contact instead"; echo json_encode($return_arr); } else { $current_date = $db->select("SELECT DATE_FORMAT(CURRENT_DATE(), '%Y-%m_%d') AS date"); $query = ""; if($mobile_1 == ""){ if($mobile_2 == ""){ $query = "INSERT INTO `source_dealer_mobile_contact_finance` (`contact_name`, `dealer_id`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$current_user', '$current_user', '$current_date', 1)"; // echo $query; return; $db->sql_query($query); } else { $query = "INSERT INTO `source_dealer_mobile_contact_finance` (`contact_name`, `dealer_id`, `mobile_number`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$mobile_2', '$current_user', '$current_user', '$current_date', 1)"; // echo $query; return; $db->sql_query($query); } } else { if($mobile_2 == ""){ $query = "INSERT INTO `source_dealer_mobile_contact_finance` (`contact_name`, `dealer_id`, `mobile_number`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$mobile_1', '$current_user', '$current_user', '$current_date', 1)"; // echo $query; return; $db->sql_query($query); } else { $query = "INSERT INTO `source_dealer_mobile_contact_finance` (`contact_name`, `dealer_id`, `mobile_number`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$mobile_1', '$current_user', '$current_user', '$current_date', 1)"; // echo $query; return; $db->sql_query($query); $db->sql_query("INSERT INTO `source_dealer_mobile_contact_finance` (`contact_name`, `dealer_id`, `mobile_number`, `added_by`, `last_modified_by`, `date_modified`, `status`) VALUES('$contact_person', '$dealer_id', '$mobile_2', '$current_user', '$current_user', '$current_date', 1)"); } } $return_arr['status'] = 1; echo json_encode($return_arr); } } else if($type == 2){ // reload / load brand list $dealer_id = $db->escape($_POST['dealer_id']); $arr = array(); $contact_arr = array(); $id_arr = array(); $contact_count = $db->select("SELECT COUNT(1) FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id'"); $arr['contact_person'] = $db->select("SELECT contact_name FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id' LIMIT 1"); $details = "SELECT concat(e1.first_name, ' ', e1.last_name) AS added_by, concat(e2.first_name, ' ', e2.last_name) AS last_modified_by, DATE_FORMAT(sdmcf.date_added, '%b %d, %Y / %h:%i %p') AS date_added, DATE_FORMAT(sdmcf.date_modified, '%b %d, %Y') AS date_modified FROM source_dealer_mobile_contact_finance sdmcf INNER JOIN employee e1 ON e1.id = sdmcf.added_by INNER JOIN employee e2 ON e2.id = sdmcf.last_modified_by WHERE dealer_id = '$dealer_id' LIMIT 1"; $details_list = $db->sql_query($details); foreach($details_list AS $data){ $arr['added_by'] = $data['added_by']; $arr['date_added'] = $data['date_added']; $arr['last_modified_by'] = $data['last_modified_by']; $arr['date_modified'] = $data['date_modified']; } $query = "SELECT id, mobile_number FROM source_dealer_mobile_contact_finance WHERE dealer_id = '$dealer_id'"; $query_list = $db->sql_query($query); foreach($query_list AS $row){ $id = $row['id']; $contact_number = $row['mobile_number']; array_push($id_arr, $id); array_push($contact_arr, $contact_number); } if($contact_count > 1){ $arr['contact_1'] = $contact_arr[0]; $arr['contact_2'] = $contact_arr[1]; $arr['id_1'] = $id_arr[0]; $arr['id_2'] = $id_arr[1]; } else { $arr['contact_1'] = $contact_arr[0]; $arr['contact_2'] = ""; $arr['id_1'] = $id_arr[0]; $arr['id_2'] = ""; } echo json_encode($arr); } else if($type == 3){ // update brand $dealer_id = $db->escape($_POST['dealer_id']); $new_contact_person = $db->escape(trim($_POST['new_contact_person'])); $new_mobile_1 = $db->escape($_POST['new_mobile_1']); $new_mobile_2 = $db->escape($_POST['new_mobile_2']); $old_mobile_1 = $db->escape($_POST['old_mobile_1']); $old_mobile_2 = $db->escape($_POST['old_mobile_2']); $id_1 = $db->escape($_POST['id_1']); $id_2 = $db->escape($_POST['id_2']); $current_user = $_SESSION['user']['id']; // $set_status = 0; // $current_user = $_SESSION['user']['id']; // if($status == "true"){ // $set_status = 1; // } $current_date = $db->select("SELECT DATE_FORMAT(CURRENT_DATE(), '%Y-%m_%d') AS date"); $update_query_1 = $db->sql_query("UPDATE `source_dealer_mobile_contact_finance` SET `contact_name`='$new_contact_person', `mobile_number` = '$new_mobile_1', `last_modified_by`='$current_user', `date_modified` = '$current_date' WHERE `id` = '$id_1'"); $update_query_2 = $db->sql_query("UPDATE `source_dealer_mobile_contact_finance` SET `contact_name`='$new_contact_person', `mobile_number` = '$new_mobile_2', `last_modified_by`='$current_user', `date_modified` = '$current_date' WHERE `id` = '$id_2'"); //echo $update_query; $arr['status'] = 1; //success update echo json_encode($arr); } else if($type == 4){ // get selected dealer name in selected dealer in list (add dealer) $companies = $db->escape($_POST['companies']); $query = "SELECT sdmcf.dealer_id, sd.name AS dealer FROM source_dealer_mobile_contact_finance sdmcf INNER JOIN source_dealer sd ON sd.id = sdmcf.dealer_id GROUP BY sdmcf.dealer_id ORDER BY sd.name ASC"; // echo $query; return; $dealer = $db->return_result($query); //echo $query; return; foreach($dealer as $data){ echo "<option value='{$data['dealer_id']}'>".$data['dealer']."</option>"; } } else if($type == 5){ // search function $search_item = $db->escape(trim($_POST['search_item'])); $search_query = "SELECT sdmcf.dealer_id, sd.name AS dealer FROM source_dealer_mobile_contact_finance sdmcf INNER JOIN source_dealer sd ON sd.id = sdmcf.dealer_id WHERE (sd.name LIKE '%%$search_item%%') AND sdmcf.id != 0 GROUP BY sdmcf.dealer_id ORDER BY sd.name ASC"; //echo $search_query; return; $result = $db->sql_query($search_query); //echo $search_query; return; while($row = $result->fetch_assoc()) { echo '<option value="'.$row['dealer_id'].'">'.$row["dealer"].'</option>'; } } ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.08 | proxy | phpinfo | Settings