File manager - Edit - /home/autoph/public_html/connectv1/app/company_dealer/designate_dealer.php
Back
<?php include_once("../../cfg/db.php"); // $get_dealer_id = $_POST['dealer_id']; // $dealer_id_conv = implode("", $get_dealer_id); $dealer_id = $db->escape(trim($_POST['dealer_id'])); // $get_company_id = $_POST['company_id']; // $company_id_conv = implode("", $get_company_id); $company_id = $db->escape(trim($_POST['company_id'])); $type = $db->escape(trim($_POST['type'])); //$query = "SELECT id FROM source_dealer WHERE code='$dealer_code'"; $check_query = "SELECT status FROM source_company_dealer WHERE dealer_id='$dealer_id' AND company_id='$company_id'"; $check_record = $db->sql_query($check_query)->num_rows; if($check_record > 0){ $get_status = $db->sql_query($check_query); foreach($get_status as $data){ $status = $data['status']; if($status == 0){ $activate_dealer = "UPDATE source_company_dealer SET `status` = '1', `type` = '1' WHERE dealer_id='$dealer_id' AND company_id='$company_id'"; $dealer_info = $db->sql_query($activate_dealer); $arr_status['status'] = 1; //clear echo json_encode($arr_status); } else if($status == 1){ $arr_status['status'] = 0; //clear echo json_encode($arr_status); } else { //no record found $arr_status['status'] = 2; //clear echo json_encode($arr_status); } } } else { $insert_query = "INSERT INTO source_company_dealer(`dealer_id`, `company_id`, `type`, `status`) VALUES('$dealer_id', '$company_id', '1', 1)"; $dealer_info = $db->sql_query($insert_query); $arr_status['status'] = 1; //clear echo json_encode($arr_status); } // while($row = $company_info->fetch_assoc()) { // echo '<option value="'.$row['id'].'">'.$row["code"].' - '.$row["name"].'</option>'; // } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings