File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/sms/sms_lto.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']); $contact_1 = $db->escape($_POST['contact_1']); $contact_2 = $db->escape($_POST['contact_2']); $email = $db->escape($_POST['email']); $current_user = $_SESSION['user']['first_name'] . " " . $_SESSION['user']['last_name']; if(intval($db->select("SELECT COUNT(1) FROM source_lto_dealer_contacts WHERE dealer_id = '$dealer_id'")) > 0){ $return_arr['status'] = 2; //duplicate dealer name echo json_encode($return_arr); } else { $current_date = $db->select("SELECT DATE_FORMAT(NOW(), '%M %d, %Y / %h:%i:%s %p') AS date"); $added_by = $current_user . " (" . $current_date . ")"; $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `contact1`, `contact2`, `email`, `added_by`, `modified_by`, `active`, `status`) VALUES('$contact_person', '$dealer_id', '$contact_1', '$contact_2', '$email', '$added_by', '', 1, 1)"; // if($contact_1 == ""){ // if($contact_2 == ""){ // $added_by = $current_user . " (" . $current_date . ")"; // $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `added_by`, `modified_by`, `status`) VALUES('$contact_person', '$dealer_id', '$added_by', '', 1)"; // // echo $query; return; // $db->sql_query($query); // } // else { // $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `contact2`, `added_by`, `modified_by`, `status`) VALUES('$contact_person', '$dealer_id', '$contact_2', '$current_user', '', 1)"; // // echo $query; return; // $db->sql_query($query); // } // } // else { // if($mobile_2 == ""){ // $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `dealer_id`, `contact1`, `added_by`, `last_modified_by`, `status`) VALUES('$contact_person', '$dealer_id', '$contact1', '$current_user', '', 1)"; // // echo $query; return; // $db->sql_query($query); // } // else { // $query = "INSERT INTO `source_lto_dealer_contacts` (`contact_person`, `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)"); // } // } $update_query_execute = $db->sql_query_num_inserted($query); if($update_query_execute > 0){ $return_arr['status'] = 1; echo json_encode($return_arr); } else { $return_arr['status'] = 0; echo json_encode($return_arr); } } } else if($type == 2){ // reload / load dealer contact $dealer_id = $db->escape($_POST['dealer_id']); $details = "SELECT sldc.contact_person, sldc.contact1, sldc.contact2, sldc.email, sldc.added_by, sldc.modified_by, sldc.status FROM source_lto_dealer_contacts sldc INNER JOIN source_dealer sd ON sd.id = sldc.dealer_id WHERE sldc.dealer_id = '$dealer_id' LIMIT 1"; // echo $details; exit; $details_list = $db->sql_query($details); foreach($details_list AS $data){ $arr['contact_person'] = $data['contact_person']; $arr['contact1'] = $data['contact1']; $arr['contact2'] = $data['contact2']; $arr['email'] = $data['email']; $arr['added_by'] = $data['added_by']; $arr['modified_by'] = $data['modified_by']; $arr['status'] = $data['status']; } echo json_encode($arr); } else if($type == 3){ // update dealer contact $dealer_id = $db->escape($_POST['dealer_id']); $new_contact_person = $db->escape(trim($_POST['new_contact_person'])); $new_contact_1 = $db->escape($_POST['new_contact_1']); $new_contact_2 = $db->escape($_POST['new_contact_2']); $new_email = $db->escape($_POST['new_email']); $current_user = $_SESSION['user']['first_name'] . " " . $_SESSION['user']['last_name']; $current_date = $db->select("SELECT DATE_FORMAT(NOW(), '%M %d, %Y / %h:%i:%s %p') AS date"); $modified_by = $current_user . " (" . $current_date . ")"; // $set_status = 0; // $current_user = $_SESSION['user']['id']; // if($status == "true"){ // $set_status = 1; // } $update_query = "UPDATE `source_lto_dealer_contacts` SET `contact_person` = '$new_contact_person', `contact1` = '$new_contact_1', `contact2` = '$new_contact_2', `email` = '$new_email', `modified_by` = '$modified_by' WHERE `dealer_id` = '$dealer_id '"; $update_query_execute = $db->sql_query_num_inserted($update_query); if($update_query_execute > 0){ $arr['status'] = 1; //success update echo json_encode($arr); } else { $arr['status'] = 0; //success failed 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 sldc.dealer_id, sd.name AS dealer FROM source_lto_dealer_contacts sldc INNER JOIN source_dealer sd ON sd.id = sldc.dealer_id GROUP BY sldc.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 sldc.dealer_id, sd.name AS dealer FROM source_lto_dealer_contacts sldc INNER JOIN source_dealer sd ON sd.id = sldc.dealer_id WHERE (sd.name LIKE '%%$search_item%%') AND sldc.id != 0 GROUP BY sldc.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 | proxy | phpinfo | Settings