File manager

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

Back
<?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); include_once("../../cfg/db.php"); // include_once("../controllers/customer.php"); include_once("../controllers/customer_update.php"); // include_once("../controllers/religion.php"); // include_once("../controllers/interest_hobbies.php"); // include_once("../controllers/affiliations.php"); // include_once("../controllers/school.php"); // include_once("../controllers/car_club.php"); // include_once("../controllers/political_club.php"); // include_once("../controllers/unit_association.php"); // include_once("../controllers/network_marketing.php"); // include_once("../controllers/media_publication.php"); // include_once("../controllers/sme_group.php"); // include_once("../controllers/fraternities_sororities.php"); // include_once("../controllers/facebook_group.php"); // include_once("../controllers/celebrity_influencer.php"); // include_once("../controllers/company_dealer.php"); // include_once("../controllers/company.php"); // include_once("../controllers/dealer.php"); // include_once("../controllers/dms.php"); // include_once("../controllers/nature_of_business.php"); // include_once("../controllers/profession.php"); // include_once("../controllers/mode_of_contact.php"); include_once("../controllers/utility.php"); // include_once("../controllers/logger.php"); $customer = new Customer_update(); // $religion = new Religion(); // $interest_hobbies = new InterestHobbies(); // $affiliations = new Affiliations(); // $school = new School(); // $car_club = new CarClub(); // $unit_association = new UnitAssociation(); // $political_club = new PoliticalClub(); // $network_marketing = new NetworkMarketing(); // $media_publication = new MediaPublication(); // $sme_group = new SmeGroup(); // $fraternities_sororities = new FraternitiesSororities(); // $facebook_group = new FacebookGroup(); // $celebrity_influencer = new CelebrityInfluencer(); // $company_dealer = new CompanyDealer(); // $dms = new DMS(); // $company = new Company(); // $dealer = new Dealer(); // $nature_of_business = new NatureOfBusiness(); // $profession = new Profession(); // $mode_of_contact = new ModeOfContact(); $utility = new Utility(); // $logger = new Logger(); if (!isset($_SESSION['user']['id'])) { echo "Session Expired."; exit; } $date_now = date('Y-m-d h:i:s'); $current_user_id = $_SESSION['user']['id']; $server_method = $_SERVER["REQUEST_METHOD"]; $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1'; $fields_permissions = isset($_SESSION['user']['fields_permissions']['customer_fields']) ? $_SESSION['user']['fields_permissions']['customer_fields'] : false; if (isset($_REQUEST['apiKey'])) { $apiKey = $_REQUEST['apiKey']; function randomStr() { $rand=str_shuffle("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"); $cu_header =substr($rand, -5); return $cu_header; } // LOAD DEALERSHIP if($apiKey ==='mRLAZ8te7cnv') { $dealers = $db->return_result("SELECT scd.id as scd_id,scd.dealer_id,sd.id,sd.code,sd.name from source_company_dealer scd LEFT JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE scd.TYPE=1 AND scd.STATUS =1 ORDER BY sd.name"); $json = []; foreach($dealers as $dealer){ $json[] = ['id'=>$dealer['dealer_id'], 'text'=>$dealer['code'].' - '.$dealer['name'],'data_scd_id' => $dealer['scd_id']]; } echo json_encode($json); }elseif ($apiKey==='f5AHTwg8MF9c') { $scd_id= $_REQUEST['did']; $user_managers = $db->return_result("SELECT e.company_dealer_id as scd_id,e.id,e.asa_id,e.employee_id, e.company_dealer_id,concat(e.first_name,' ',e.last_name) as fullname,ep.position_name as position FROM employee e LEFT JOIN employee_position ep ON e.position_id = ep.id WHERE e.company_dealer_id='".$scd_id."' AND e.status != '0' AND ep.id IN(29,31,32,33,34,37,38,39,41,42,75,84)"); $json = []; foreach($user_managers as $user_manager){ $json[] = ['id'=>$user_manager['employee_id'], 'text'=>$user_manager['fullname'],'data_id'=>$user_manager['scd_id']]; } unset($user_managers); echo json_encode($json); }elseif($apiKey==='L9T6kZfc8K4D'){ $sm_id= $_REQUEST['smid']; $scd_id = $_REQUEST['scdid']; $user_scs = $db->return_result("SELECT e.company_dealer_id as scd_id,e.id,e.asa_id,e.employee_id, e.company_dealer_id,concat(e.first_name,' ',e.last_name) as fullname,ep.position_name as position FROM employee e LEFT JOIN employee_position ep ON e.position_id = ep.id WHERE e.employee_id !='".$sm_id."' AND e.company_dealer_id='".$scd_id."' AND e.status != '0' AND ep.id IN(29,31,32,33,34,37,38,39,41,42,75,84)"); $json = []; foreach($user_scs as $sc){ $json[] = ['id'=>$sc['employee_id'], 'text'=>$sc['fullname'],'data_id'=>$sc['scd_id']]; } unset($sc); echo json_encode($json); }elseif(base64_decode($apiKey) ==='r8wkrhisl2'){ $data = (isset($_REQUEST['attr']) ? $_REQUEST['attr'] : ''); $process =0; $success =0; if(is_array($data) && count($data)>0) { foreach($data as $dealer) { $dealer_id = $dealer['did']; $active = $dealer['active']; $process++; $chk_qry = $db->run_query("select dealer_id from cu_exclude_dealer where dealer_id =".$dealer_id); if($chk_qry->num_rows >0) { try{ $db->transBegin(); $update =$db->run_query("UPDATE cu_exclude_dealer SET status =0 WHERE dealer_id=".$dealer_id); $insert =$db->run_query("INSERT INTO `cu_exclude_dealer`(`dealer_id`,`active`,`status`,`created_at`) VALUES ('" . $dealer_id . "' ,'".$active."','".$active."','".date("Y-m-d h:i:s")."')"); if($update && $insert) { $success++; $db->transCommit(); } }catch(\Throwable $e){ echo('{"msg":"Unable to update record : "'.$e.',"status":0}'); } } else { $db->transBegin(); $qry = $db->run_query("INSERT INTO `cu_exclude_dealer`(`dealer_id`,`active`,`created_at`) VALUES ('" . $dealer_id . "' ,'".$active."','".date("Y-m-d h:i:s")."')"); if($qry) { $success++; $db->transCommit(); }else{ $db->transRollback(); } } }unset($dealer); if($process==$success) { $db->transCommit(); echo('{"msg":"Record successfully updated.","status":1}'); }else{ $db->transRollback(); echo('{"msg":"Unable to update record.","status":0}'); } }else{ echo('{"msg":"Unable to update record. Please select dealer.","status":0}'); } }elseif(base64_decode($apiKey) === 'Qifl39Wkll'){ //insert user $dealer_id = $_REQUEST['did']; $smid = $_REQUEST['smid']; $scid = implode(',',$_REQUEST['sc']); $id =(isset($_REQUEST['id_']) ? $_REQUEST['id_'] : NULL);//for update // echo $id; $action = $_REQUEST['action']; if($action =='Create') { $check = $db->sql_query("SELECT primary_user FROM cu_sc_users where primary_user='$smid'"); if($check->num_rows > 0) { echo json_encode(["msg" => "User group already exist.", "status" =>2 ]); } else { try{ $db->transBegin(); $insert = $db->sql_query("INSERT INTO `cu_sc_users` (`dealer_id`,`primary_user`,`user_group`,`created_at`,`created_by`) VALUES('".$dealer_id."','".$smid."','".$scid."','$date_now',".$current_user_id.")"); $db->transCommit(); echo json_encode(["msg" => "Record successfully saved", "status" => 1]); }catch (\Throwable $e) { $db->transRollback(); echo '{"msg" :'.$e.',"status":0}';exit; } } } else { // echo 'aa'.$id; if($id===NULL) { // echo '{"msg" :'.$e.',"status":0}';exit; echo json_encode(["msg" => "Failed to update record.", "status" => 1]);exit; } try{ $db->transBegin(); // echo "UPDATE cu_sc_users SET dealer_id ='".$dealer_id."',primary_user='".$smid."',user_group='".$scid."',updated_at='$date_now',updated_by=".$current_user_id." WHERE id=".$id;exit; $update =$db->run_query("UPDATE cu_sc_users SET dealer_id ='".$dealer_id."',primary_user='".$smid."',user_group='".$scid."',updated_at='$date_now',updated_by=".$current_user_id." WHERE id=".$id); $db->transCommit(); echo json_encode(["msg" => "Record successfully updated.", "status" => 1]); }catch (\Throwable $e) { $db->transRollback(); echo '{"msg" :'.$e.',"status":0}';exit; } } }elseif(base64_decode($apiKey) === 'xbd3l39Wkll'){ //remove user $id = $_REQUEST['id']; try{ $db->transBegin(); $db->sql_query("DELETE FROM cu_sc_users WHERE id=".$id); $db->transCommit(); echo json_encode(["msg" => "Record successfully deleted.", "status" => 1]); }catch (\Throwable $e) { $db->transRollback(); echo '{"msg" :'.$e.',"status":0}';exit; } } }

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