File manager

File manager - Edit - /home/autoph/public_html/connectv1/api/lms/lms.php

Back
<?php include_once("../../cfg/db.php"); include_once("../controllers/lms.php"); include_once("../controllers/utility.php"); $lms_class = new LMS(); $utility = new Utility(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '3861178282616384' ){ //Read Company List $corporation_name = isset($_REQUEST['corporation_name']) ? $db -> escape($_REQUEST['corporation_name']) : '' ; $first_name = isset($_REQUEST['first_name']) ? $db -> escape($_REQUEST['first_name']) : '' ; $middle_name = isset($_REQUEST['middle_name']) ? $db -> escape($_REQUEST['middle_name']) : '' ; $last_name = isset($_REQUEST['last_name']) ? $db -> escape($_REQUEST['last_name']) : '' ; $suffix_id = isset($_REQUEST['suffix_id']) ? $db -> escape($_REQUEST['suffix_id']) : '' ; $gender_id = isset($_REQUEST['gender_id']) ? $db -> escape($_REQUEST['gender_id']) : '' ; $date_of_birth = isset($_REQUEST['date_of_birth']) ? $db -> escape($_REQUEST['date_of_birth']) : '' ; $mobile = isset($_REQUEST['mobile']) ? $utility->fix_mobile_format($utility->alphaNumericOnly($db -> escape($_REQUEST['mobile']))) : '' ; $email = isset($_REQUEST['email']) ? $db -> escape($_REQUEST['email']) : '' ; $facebook = isset($_REQUEST['facebook']) ? $db -> escape($_REQUEST['facebook']) : '' ; $inquired_unit = isset($_REQUEST['inquired_unit']) ? $db -> escape($_REQUEST['inquired_unit']) : '' ; $brand_id = isset($_REQUEST['brand_id']) ? $db -> escape($_REQUEST['brand_id']) : '' ; $model_id = isset($_REQUEST['model_id']) ? $db -> escape($_REQUEST['model_id']) : '' ; $model_variant_id = isset($_REQUEST['model_variant_id']) ? $db -> escape($_REQUEST['model_variant_id']) : '' ; $asked_discount = isset($_REQUEST['asked_discount']) ? $db -> escape($_REQUEST['asked_discount']) : '' ; $approve_discount = isset($_REQUEST['approve_discount']) ? $db -> escape($_REQUEST['approve_discount']) : '' ; $follow_up_date = isset($_REQUEST['follow_up_date']) ? $db -> escape($_REQUEST['follow_up_date']) : '' ; $lead_type = isset($_REQUEST['lead_type']) ? $db -> escape($_REQUEST['lead_type']) : '' ; $lead_status = isset($_REQUEST['lead_status']) ? $db -> escape($_REQUEST['lead_status']) : '' ; $activity = isset($_REQUEST['activity']) ? $db -> escape($_REQUEST['activity']) : '' ; $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; $added_by = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : '' ; $source_id = isset($_REQUEST['source_id']) ? $db -> escape($_REQUEST['source_id']) : '' ; $lead_id = $utility->generate_uuid($db); //validations if(!$utility->isNotEmpty($asa_id)){ $return_arr["status"]=0; $return_arr["message"]="ASA ID is required."; echo json_encode($return_arr); exit; } // if(intval($lead_type) === 1){ // if(!($utility->isNotEmpty($first_name) && $utility->isNotEmpty($last_name))){ // $return_arr["status"]=0; // $return_arr["message"]="Lead name is required."; // echo json_encode($return_arr); // exit; // } // }else if(intval($lead_type) === 2){ // if(!$utility->isNotEmpty($corporation_name)){ // $return_arr["status"]=0; // $return_arr["message"]="Lead name is required."; // echo json_encode($return_arr); // exit; // } // }else{ // $return_arr["status"]=0; // $return_arr["message"]="Lead type is required."; // echo json_encode($return_arr); // exit; // } if($utility->isNotEmpty($first_name) && $utility->isNotEmpty($last_name)){ $lead_type = 1; }else{ $lead_type = 2; } if(!$utility->isNotEmpty($mobile)){ $return_arr["status"]=0; $return_arr["message"]="Lead mobile is required."; echo json_encode($return_arr); exit; } if($utility->isNotEmpty($email)){ if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $return_arr["status"]=0; $return_arr["message"]="Email is invalid."; echo json_encode($return_arr); exit; } } if(!$utility->isNotEmpty($lead_status)){ $return_arr["status"]=0; $return_arr["message"]="Lead status is required."; echo json_encode($return_arr); exit; } $lead_status_id = $db->select("SELECT id FROM `lms_lead_status` WHERE (name = '$lead_status' or code = '$lead_status') AND status = 1 LIMIT 1 "); if(intval($lead_status_id) === 0){ $return_arr["status"]=0; $return_arr["message"]="Lead status is invalid."; echo json_encode($return_arr); exit; } if(!$utility->isNotEmpty($inquired_unit)){ $return_arr["status"]=0; $return_arr["message"]="Lead inquired unit is required."; echo json_encode($return_arr); exit; } $affected_rows_lead = $lms_class -> create_leads($lead_id,$corporation_name,$first_name,$middle_name,$last_name,$suffix_id,$gender_id,$date_of_birth,$lead_type,$added_by,$asa_id,$source_id,'1',$utility, $db); if(intval($affected_rows_lead) < 1 ){ $return_arr["status"]=0; $return_arr["message"]="Lead Data Not Inserted"; echo json_encode($return_arr); exit; } $affected_rows_contact = $lms_class -> create_leads_contact($lead_id,$mobile,$email,$facebook,$utility,$db); if(intval($affected_rows_contact) < 1 ){ $lms_class -> delete_leads($lead_id,$db); $return_arr["status"]=0; $return_arr["message"]="Lead Contact Not Inserted"; echo json_encode($return_arr); exit; } $inquire_id = $lms_class ->create_leads_inquire_vehicle($lead_id,$added_by,$asa_id,$brand_id,$model_id,$model_variant_id,$inquired_unit,$asked_discount,$approve_discount,$db); if(intval($inquire_id) < 1){ $lms_class -> delete_leads_contact($lead_id,$db); $return_arr["status"]=0; $return_arr["message"]="Lead inquired data not inserted."; echo json_encode($return_arr); exit; } $affected_rows_activity = $lms_class ->create_leads_activity($inquire_id,$lead_status_id,$activity,$follow_up_date,'1',$utility,$db); if(intval($affected_rows_activity) > 0){ $return_arr["status"]=1; $return_arr["message"]="New record has been saved."; }else{ $return_arr["status"]=0; $return_arr["message"]="Lead Data Not Inserted"; } echo json_encode($return_arr); }else if($apiKey === '6243416033562479'){ //Read Company List $corporation_name = isset($_REQUEST['corporation_name']) ? $db -> escape($_REQUEST['corporation_name']) : '' ; $first_name = isset($_REQUEST['first_name']) ? $db -> escape($_REQUEST['first_name']) : '' ; $middle_name = isset($_REQUEST['middle_name']) ? $db -> escape($_REQUEST['middle_name']) : '' ; $last_name = isset($_REQUEST['last_name']) ? $db -> escape($_REQUEST['last_name']) : '' ; $suffix_id = isset($_REQUEST['suffix_id']) ? $db -> escape($_REQUEST['suffix_id']) : '' ; $gender_id = isset($_REQUEST['gender_id']) ? $db -> escape($_REQUEST['gender_id']) : '' ; $date_of_birth = isset($_REQUEST['date_of_birth']) ? $db -> escape($_REQUEST['date_of_birth']) : '' ; $mobile = isset($_REQUEST['mobile']) ? $utility->fix_mobile_format($utility->alphaNumericOnly($db -> escape($_REQUEST['mobile']))) : '' ; $email = isset($_REQUEST['email']) ? $db -> escape($_REQUEST['email']) : '' ; $facebook = isset($_REQUEST['facebook']) ? $db -> escape($_REQUEST['facebook']) : '' ; $inquired_unit = isset($_REQUEST['inquired_unit']) ? $db -> escape($_REQUEST['inquired_unit']) : '' ; $brand_id = isset($_REQUEST['brand_id']) ? $db -> escape($_REQUEST['brand_id']) : '' ; $model_id = isset($_REQUEST['model_id']) ? $db -> escape($_REQUEST['model_id']) : '' ; $model_variant_id = isset($_REQUEST['model_variant_id']) ? $db -> escape($_REQUEST['model_variant_id']) : '' ; $asked_discount = isset($_REQUEST['asked_discount']) ? $db -> escape($_REQUEST['asked_discount']) : '' ; $approve_discount = isset($_REQUEST['approve_discount']) ? $db -> escape($_REQUEST['approve_discount']) : '' ; $follow_up_date = isset($_REQUEST['follow_up_date']) ? $db -> escape($_REQUEST['follow_up_date']) : '' ; // $lead_type = isset($_REQUEST['lead_type']) ? $db -> escape($_REQUEST['lead_type']) : '' ; $lead_status = isset($_REQUEST['lead_status']) ? $db -> escape($_REQUEST['lead_status']) : '' ; $activity = isset($_REQUEST['activity']) ? $db -> escape($_REQUEST['activity']) : '' ; $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; $modified_by = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : '' ; $source_id = isset($_REQUEST['source_id']) ? $db -> escape($_REQUEST['source_id']) : '' ; $lead_id = isset($_REQUEST['lead_id']) ? $db -> escape($_REQUEST['lead_id']) : '' ; //validations if(!$utility->isNotEmpty($asa_id)){ $return_arr["status"]=0; $return_arr["message"]="ASA ID is required."; echo json_encode($return_arr); exit; } if(!$utility->isNotEmpty($lead_id)){ $return_arr["status"]=0; $return_arr["message"]="Lead ID is required."; echo json_encode($return_arr); exit; } $lead_type = $lms_class ->get_lead_type($lead_id,$db); // if(intval($lead_type) === 1){ // if(!($utility->isNotEmpty($first_name) && $utility->isNotEmpty($last_name))){ // $return_arr["status"]=0; // $return_arr["message"]="Lead name is required."; // echo json_encode($return_arr); // exit; // } // }else if(intval($lead_type) === 2){ // if(!$utility->isNotEmpty($corporation_name)){ // $return_arr["status"]=0; // $return_arr["message"]="Lead name is required."; // echo json_encode($return_arr); // exit; // } // }else{ // $return_arr["status"]=0; // $return_arr["message"]="Lead type is required."; // echo json_encode($return_arr); // exit; // } if(!$utility->isNotEmpty($mobile)){ $return_arr["status"]=0; $return_arr["message"]="Lead mobile is required."; echo json_encode($return_arr); exit; } if($utility->isNotEmpty($email)){ if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $return_arr["status"]=0; $return_arr["message"]="Email is invalid."; echo json_encode($return_arr); exit; } } if(!$utility->isNotEmpty($lead_status)){ $return_arr["status"]=0; $return_arr["message"]="Lead status is required."; echo json_encode($return_arr); exit; } $lead_status_id = $db->select("SELECT id FROM `lms_lead_status` WHERE (name = '$lead_status' or code = '$lead_status') AND status = 1 LIMIT 1 "); if(intval($lead_status_id) === 0){ $return_arr["status"]=0; $return_arr["message"]="Lead status is invalid."; echo json_encode($return_arr); exit; } //end // if(!$utility->isNotEmpty($inquired_unit)){ // $return_arr["status"]=0; // $return_arr["message"]="Lead inquired unit is required."; // echo json_encode($return_arr); // exit; // } $affected_rows_lead = $lms_class -> update_leads($lead_id,$corporation_name,$first_name,$middle_name,$last_name,$suffix_id,$gender_id,$date_of_birth,$lead_type,$modified_by,$asa_id,$source_id,'1',$utility, $db); // if(intval($affected_rows_lead) < 1 ){ // $return_arr["status"]=0; // $return_arr["message"]="Lead Data Not Inserted"; // echo json_encode($return_arr); // exit; // } $affected_rows_contact = $lms_class -> update_leads_contact($lead_id,$mobile,$email,$facebook,$utility,$db); $affected_rows_inquire = $lms_class -> update_leads_inquiry($lead_id,$asa_id,$asked_discount,$approve_discount,$inquired_unit,$utility,$db); // if(intval($affected_rows_contact) < 1 ){ // $lms_class -> delete_leads($lead_id,$db); // $return_arr["status"]=0; // $return_arr["message"]="Lead Contact Not Inserted"; // echo json_encode($return_arr); // exit; // } $affected_rows_status = $lms_class -> update_leads_latest_activity_status($lead_id,$asa_id,$lead_status_id,$db); // $inquire_id = $lms_class ->create_leads_inquire_vehicle($lead_id,$added_by,$asa_id,$brand_id,$model_id,$model_variant_id,$inquired_unit,$db); // if(intval($inquire_id) < 1){ // $lms_class -> delete_leads_contact($lead_id,$db); // $return_arr["status"]=0; // $return_arr["message"]="Lead inquired data not inserted."; // echo json_encode($return_arr); // exit; // } // $affected_rows_activity = $lms_class ->create_leads_activity($inquire_id,$lead_status_id,$activity,$follow_up_date,'1',$utility,$db); // if(intval($affected_rows_activity) > 0){ // $return_arr["status"]=1; // $return_arr["message"]="Lead Inserted"; // }else{ // $return_arr["status"]=0; // $return_arr["message"]="Lead Data Not Inserted"; // } if($utility->isNotEmpty($activity)){ $inquire_id = $db->select("SELECT MAX(id) FROM lms_lead_inquire_details WHERE lead_id = '$lead_id' AND asa_id = '$asa_id' "); $latest_status = $db->sql_query("SELECT lla.lead_status_id FROM lms_leads ll INNER JOIN lms_lead_contacts llc ON ll.id = llc.lead_id INNER JOIN lms_lead_inquire_details lld ON ll.id = lld.lead_id INNER JOIN lms_lead_activities lla ON lla.id = ( SELECT MAX(llas.id) AS maxsign FROM lms_lead_activities llas INNER JOIN lms_lead_inquire_details llids ON llas.inquire_id = llids.id WHERE llids.id = lld.id GROUP BY llas.inquire_id ) INNER JOIN lms_lead_status lls ON lla.lead_status_id = lls.id WHERE 1 AND lld.id = $inquire_id "); foreach($latest_status as $row){ $lead_status_id= $row['lead_status_id']; } $lms_class ->create_leads_activity($inquire_id,$lead_status_id,$activity,$follow_up_date,'1',$utility,$db); } $return_arr["status"]=1; $return_arr["message"]="Record has been updated."; echo json_encode($return_arr); }else if($apiKey === '3305556125130471' ){ //Read Company List $activity = isset($_REQUEST['activity']) ? $db -> escape($_REQUEST['activity']) : '' ; $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; $lead_id = isset($_REQUEST['lead_id']) ? $db -> escape($_REQUEST['lead_id']) : '' ; $follow_up_date = isset($_REQUEST['follow_up_date']) ? $db -> escape($_REQUEST['follow_up_date']) : '' ; if(!$utility->isNotEmpty($asa_id)){ $return_arr["status"]=0; $return_arr["message"]="ASA ID is required."; echo json_encode($return_arr); exit; } if(!$utility->isNotEmpty($lead_id)){ $return_arr["status"]=0; $return_arr["message"]="Lead ID is required."; echo json_encode($return_arr); exit; } if(!$utility->isNotEmpty($activity)){ $return_arr["status"]=0; $return_arr["message"]="Lead Activity is required."; echo json_encode($return_arr); exit; } $inquire_id = $db->select("SELECT MAX(id) FROM lms_lead_inquire_details WHERE lead_id = '$lead_id' AND asa_id = '$asa_id' "); // $latest_status = $db->sql_query("SELECT `inquire_id` , MAX(lms_lead_activities.added_date) max_time,lead_status_id // FROM lms_lead_activities // INNER JOIN lms_lead_inquire_details // ON lms_lead_activities.inquire_id = lms_lead_inquire_details.id // WHERE lms_lead_inquire_details.id = '$inquire_id' // GROUP BY lms_lead_activities.inquire_id LIMIT 1"); $latest_status = $db->sql_query("SELECT lla.lead_status_id FROM lms_leads ll INNER JOIN lms_lead_contacts llc ON ll.id = llc.lead_id INNER JOIN lms_lead_inquire_details lld ON ll.id = lld.lead_id INNER JOIN lms_lead_activities lla ON lla.id = ( SELECT MAX(llas.id) AS maxsign FROM lms_lead_activities llas INNER JOIN lms_lead_inquire_details llids ON llas.inquire_id = llids.id WHERE llids.id = lld.id GROUP BY llas.inquire_id ) INNER JOIN lms_lead_status lls ON lla.lead_status_id = lls.id WHERE 1 AND lld.id = $inquire_id "); foreach($latest_status as $row){ $lead_status_id= $row['lead_status_id']; } $affected_rows_activity = $lms_class ->create_leads_activity($inquire_id,$lead_status_id,$activity,$follow_up_date,'1',$utility,$db); if(intval($affected_rows_activity) > 0){ $return_arr["status"]=1; $return_arr["message"]="Record has been updated."; }else{ $return_arr["status"]=0; $return_arr["message"]="Activity Not Inserted"; } echo json_encode($return_arr); }else if($apiKey === '5598938757318588' ){ $search = isset($_REQUEST['search']) ? $db -> escape($_REQUEST['search']) : '' ; $offset = isset($_REQUEST['offset']) ? $db -> escape($_REQUEST['offset']) : '' ; $limit = isset($_REQUEST['limit']) ? $db -> escape($_REQUEST['limit']) : '' ; $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; //specific asa $lead_id = isset($_REQUEST['lead_id']) ? $db -> escape($_REQUEST['lead_id']) : '' ; //specific lead record $offset_limit = ($utility->isNotEmpty($offset) && $utility->isNotEmpty($limit)) ? " LIMIT $offset,$limit " : '' ; // echo $offset_limit;exit; $json_arr['rows'] = array(); if($utility->isNotEmpty($search)){ $lead_status = ""; $search = " AND (( CONCAT( ll.corporation_name, ' ', ll.first_name, ' ', ll.last_name , ' ', ll.first_name, ' ', ll.middle_name, ' ', ll.last_name, ' ', concat('0',SUBSTRING(llc.mobile, 4)), '',llc.mobile ) ) LIKE '%$search%' OR llc.email = '".$search."') "; }else{ $lead_status = " AND lls.id IN (2,3,4) "; } if($utility->isNotEmpty($lead_id)){ $lead_id = " AND ll.id = '$lead_id' "; } if($utility->isNotEmpty($asa_id)){ $asa_id = " AND lld.asa_id = '$asa_id' "; } $fields = " t1.asa_id, t1.lead_id, t1.corporation_name, t1.first_name, t1.last_name, t1.middle_name, t1.lead_type, t1.email, t1.mobile, t1.facebook, t1.inquired_unit, t1.asked_discount, t1.approve_discount, t1.lead_status, t1.follow_up_date "; $query_main = "SELECT %s FROM (".$lms_class->getAllInOneLMSQuery()." %s /seach/ %s /asaid/ %s /leadid/ %s /lead_status/ GROUP BY ll.id ) as t1 WHERE 1 %s /limit/ "; // echo sprintf($query_main,$fields,$search,$asa_id,$lead_id,$offset_limit);exit; $list = $db->sql_query(sprintf($query_main,$fields,$search,$asa_id,$lead_id,$lead_status,$offset_limit)); $list_count = $db->sql_num_rows(sprintf($query_main, ' 1 ' ,$search,$asa_id,$lead_id,$lead_status,'')); foreach($list as $row){ $row = array_map(function($v){ return (is_null($v)) ? "" : $v; //replace blank the null values },$row); $json_arr['rows'] = array_merge($json_arr['rows'] ,array( array( 'asa_id' => $row['asa_id'], 'lead_id' => $row['lead_id'], 'full_name' => (intval($row['lead_type']) === 1) ? $row['first_name']. ' '.$row['last_name'] : $row['corporation_name'], 'corporation_name' => $row['corporation_name'], 'first_name' => $row['first_name'], 'middle_name' => $row['middle_name'], 'last_name' => $row['last_name'], 'lead_type' => $row['lead_type'], 'email' => $row['email'], 'mobile' => $row['mobile'], 'facebook' => $row['facebook'], 'inquired_unit' => $row['inquired_unit'], 'asked_discount' => $row['asked_discount'], 'approve_discount' => $row['approve_discount'], 'lead_status' => $row['lead_status'], 'follow_up_date' => $row['follow_up_date'], ) )); } // print_r($list);exit; $json_arr['total'] = intval($list_count); $json_arr['result'] = intval($list_count) > 0 ? true : false ; echo json_encode($json_arr); }else if($apiKey === '9741148350787394' ){ $search = isset($_REQUEST['search']) ? $db -> escape($_REQUEST['search']) : '' ; $offset = isset($_REQUEST['offset']) ? $db -> escape($_REQUEST['offset']) : '' ; $limit = isset($_REQUEST['limit']) ? $db -> escape($_REQUEST['limit']) : '' ; $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; //specific asa $lead_id = isset($_REQUEST['lead_id']) ? $db -> escape($_REQUEST['lead_id']) : '' ; //specific lead record $offset_limit = ($utility->isNotEmpty($offset) && $utility->isNotEmpty($limit)) ? " LIMIT $offset,$limit " : '' ; $json_arr['rows'] = array(); if(!$utility->isNotEmpty($asa_id)){ $return_arr["status"]=0; $return_arr["message"]="ASA ID is required."; echo json_encode($return_arr); exit; } if(!$utility->isNotEmpty($lead_id)){ $return_arr["status"]=0; $return_arr["message"]="Lead ID is required."; echo json_encode($return_arr); exit; } $fields = " * "; $query_main = " SELECT %s FROM `lms_lead_activities` lla INNER JOIN lms_lead_inquire_details llid ON lla.inquire_id = llid.id WHERE llid.lead_id = '$lead_id' AND llid.asa_id = '$asa_id' ORDER BY lla.added_date DESC %s "; $list = $db->sql_query(sprintf($query_main,$fields,$offset_limit)); $list_count = $db->sql_num_rows(sprintf($query_main, ' 1 ' ,'')); foreach($list as $row){ $json_arr['rows'] = array_merge($json_arr['rows'] ,array( array( 'asa_id' => $row['asa_id'], 'lead_id' => $row['lead_id'], 'activity' => $row['activity'], 'follow_up_date' => $row['follow_up_date'], 'added_date' => $row['added_date'], ) )); } $json_arr['total'] = intval($list_count); $json_arr['result'] = intval($list_count) > 0 ? true : false ; echo json_encode($json_arr); }else if($apiKey === '7525120319997186' ){ $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; //specific asa if($utility->isNotEmpty($asa_id)){ $asa_id = " AND lld.asa_id = '$asa_id' "; } $json_arr['data'] = array(); $fields = " SUM(t1.cold) as cold, SUM(t1.warm) as warm, SUM(t1.hot) as hot, SUM(t1.loss) as loss, SUM(t1.win) as win, (SUM(t1.cold)+SUM(t1.warm)+SUM(t1.hot)) as total "; $query_main = "SELECT %s FROM (".$lms_class->getAllInOneLMSQuery()." %s /asaid/ GROUP BY ll.id ) as t1 WHERE 1 "; // echo sprintf($query_main,$fields,$asa_id);exit; $list = $db->sql_query(sprintf($query_main,$fields,$asa_id)); foreach($list as $row){ $row = array_map(function($v){ return (is_null($v)) ? "0" : $v; //replace blank the null values },$row); $json_arr['data'] = array_merge($json_arr['data'] ,array( array( 'cold' => $row['cold'], 'warm' => $row['warm'], 'hot' => $row['hot'], 'win' => $row['win'], 'loss' => $row['loss'], 'total' => $row['total'], ) )); } echo json_encode($json_arr); }else if($apiKey === '7734011385868294' ){ $asa_id = isset($_REQUEST['asa_id']) ? $db -> escape($_REQUEST['asa_id']) : '' ; //specific asa $lead_id = isset($_REQUEST['lead_id']) ? $db -> escape($_REQUEST['lead_id']) : '' ; //specific asa if(!$utility->isNotEmpty($lead_id)){ $json_arr['status'] = 0; $json_arr['message'] = "Lead ID is required."; echo json_encode($json_arr); exit; } $db -> sql_query("UPDATE lms_leads SET status = 0 WHERE id = '$lead_id' "); $json_arr['status'] = 1; $json_arr['message'] = "Lead has been removed."; echo json_encode($json_arr); }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } ?>

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