File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/customer_update/assign_dealer_user.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_update.php"); include_once("../controllers/utility.php"); $customer = new Customer_update(); $utility = new Utility(); // $logger = new Logger(); if (!isset($_SESSION['user']['id'])) { echo "Session Expired."; exit; } $my_customer_record_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 COMPANY if($apiKey ==='mRLAZ8te7cnv') { // $companies = $db -> return_result("SELECT `id`,`name`, `code` FROM `source_company` WHERE status != '0' "); // $json = []; // foreach($companies as $company){ // $json[] = ['id'=>$company['id'], 'text'=>$company['code'].' - '.$company['name']]; // } // echo json_encode($json); // }elseif ($apiKey==='f5AHTwg8MF9c') { // $com_id = $_REQUEST['cid']; // $dealers = $db->return_result("SELECT c.id AS com_id, c.code AS com_code, c.name AS company_name,sc.id as dealer_id, // sc.code AS dealer_code,sc.name AS dealer_name,scd.id as company_dealer_id // FROM source_company c // LEFT JOIN source_company_dealer scd ON c.id = scd.company_id // LEFT JOIN source_dealer sc ON scd.dealer_id = sc.id // WHERE scd.company_id = '$com_id' AND scd.type =1 AND c.status =1 AND sc.status =1 AND sc.status =1"); // $json = []; // foreach($dealers as $dealer){ // $json[] = ['id'=>$dealer['company_dealer_id'], 'text'=>$dealer['dealer_code'].' - '.$dealer['dealer_name']]; // } // unset($dealer); // echo json_encode($json); }elseif(base64_decode($apiKey)==='wefnmw4gmo'){ $user_id = base64_decode($_REQUEST['cdi']); $current_employee_id = $_SESSION['user']['employee_id']; // $com_id = base64_decode($_REQUEST['cid']); // $sci = $db->return_result("select company_dealer_id from employee where id=".$user_id); // foreach($sci as $source_company_id){ // $scd_id = $source_company_id['company_dealer_id']; // }unset($dealer); $cu_user = $db->run_query("SELECT user_group FROM cu_sc_users WHERE primary_user='$current_employee_id'"); if($cu_user->num_rows ===1) { $imploded_user_list=''; foreach ($cu_user as $cu) { $user_groups = explode(',', $cu['user_group']); $quoted_user_groups = "'" . implode("','", $user_groups) . "'"; $imploded_user_list .= $quoted_user_groups . ','; } unset($cu); $imploded_user_list = rtrim($imploded_user_list, ','); // // echo $imploded_user_list; // echo "SELECT e.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.status != '0' AND e.employee_id IN(".$imploded_user_list.")";exit; // $users = $db -> return_result("SELECT e.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 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)"); $users = $db -> return_result("SELECT e.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.status != '0' AND e.employee_id IN(".$imploded_user_list.")"); $json = []; foreach($users as $key => $user){ if($user['employee_id'] =='$current_employee_id') { unset($user[$key]); continue; } $json[] = ['id'=>$user['employee_id'], 'text'=>$user['fullname'].' - '.$user['position']]; } unset($user); echo json_encode($json); } }elseif(base64_decode($apiKey)=='OG6ZWd2z8k4nof1'){ //ASSIGN TO USER MANUALLY $ref_num_header =''; $customer_id = ''; $user_id = ''; $assign_by = $_SESSION['user']['id']; $today = date('Y-m-d h:i:s'); $availabe_cu =0; $total_avl_cu = $db->return_result("SELECT count(id) as total FROM inactive_customer where id NOT IN (select customer_id from cu_assign)"); if(count($total_avl_cu)>0) { foreach($total_avl_cu as $avl_cu) { $availabe_cu= $avl_cu['total']; }unset($avl_cu); } $cu_header=''; $check_rand_str =false; do{ $cu_header = randomStr(); $check_ = $db->return_result("SELECT ref_num_header FROM cu_assign WHERE ref_num_header ='". $cu_header."'"); if(count($check_)<=0){ $check_rand_str = true; } }while(!$check_rand_str); //BATCH NUMBER FROM HEADER $batch_no =0; $batch_type=1; $batch_query = $db->return_result("SELECT batch_no FROM cu_batch_header WHERE active =1 order by id desc limit 1"); if(count($batch_query)>0) { foreach($batch_query as $b) { $batch_no= intval($b['batch_no']) +1; }unset($b); } $total_dealers_count = 0; $dealers = $db -> return_result("SELECT sc.id as dealer_id,sc.code AS dealer_code,sc.name AS dealer_name FROM source_company_dealer scd INNER JOIN source_dealer sc ON scd.dealer_id = sc.id WHERE scd.dealer_id NOT IN (SELECT cxd.dealer_id FROM cu_exclude_dealer cxd WHERE cxd.status =1 AND cxd.dealer_id =sc.id ) AND sc.id NOT IN(select customer_id from cu_assigned_history where dealer_id = sc.id) AND sc.active =1 GROUP BY sc.id ORDER BY sc.id"); if(count($dealers)>0) { $no_of_available_dealers = count($dealers); $division = intdiv( $availabe_cu, $no_of_available_dealers); $ret = array_fill(0, $no_of_available_dealers, $division); if($division != $availabe_cu / $no_of_available_dealers){ $ret[count($ret)-1] = $ret[0] + ( $availabe_cu % $no_of_available_dealers); } $process =0; $success =0; try { $db->transBegin(); foreach ($ret as $key => $cu_count_number) { $dealer_id = $dealers[$key]['dealer_id']; $new_cu_header = $cu_header.'-'.$dealers[$key]['dealer_code']; $cu_ids = $db->return_result("SELECT id FROM inactive_customer WHERE id NOT IN (SELECT customer_id FROM cu_assign WHERE active=1) ORDER BY RAND() LIMIT " . $cu_count_number); if (count($cu_ids) > 0) { foreach ($cu_ids as $key=> $cu) { $process++; //BATCH TYPE 1=auto assigned, 2=manully assigned $qry = $db->run_query("INSERT INTO `cu_assign`(`ref_num_header`, `customer_id`, `dealer_id`,`batch_no`,`batch_type`,`active`,`created_at`) VALUES ('" . $new_cu_header . "','" . $cu['id'] . "' ,'" . $dealer_id . "','".$batch_no."','".$batch_type."',1,'".date("Y-m-d h:i:s")."')"); if($qry){$success++;} } } else { echo ('{"msg":"No Inactive Customer available to assign in dealer.","status":0}');exit; } } $description='Description'; $hdr_qry =$db->run_query("INSERT INTO `cu_batch_header`(`ref_num`,`batch_no`,`batch_type`, `description`, `active`,`created_at`) VALUES ('" .$cu_header. "','".$batch_no."','".$batch_type."','".$description."',1,'".date('Y-m-d h:i:s')."')"); if($process == $success && $hdr_qry) { $db->transCommit(); echo('{"msg": "Inactive Customer Successfully assigned to","no_of_dealers":"'.$no_of_available_dealers.'","dealer":"Dealers","no_assign":"'.$availabe_cu.'","status":1}'); } unset($cu_count_number); } catch (\Throwable $e) { $db->transRollback(); echo '{"msg" :'.$e.',"status":0}';exit; } } else{ echo ('{"msg":"No Available Dealer.","status":0}');exit; } }elseif(base64_decode($apiKey) ==='0GADHHAB9G'){ //RESET ASSIGNMENT // try{ // $db->transBegin(); // $q = $db->sql_query("INSERT INTO cu_assigned_history (ref_num_header,hid,customer_id,dealer_id,batch_type) SELECT ref_num_header,hid,customer_id,dealer_id,batch_type FROM cu_assign"); // $qd = $db->sql_query("DELETE FROM cu_assign WHERE SUBSTR(ref_num_header, 1, 5) = SUBSTR(ref_num_header, 1, 5)"); // $db->transCommit(); // echo('{"msg": "Dealer assignment successfully reset","status":1}'); // }catch (\Throwable $e) { // $db->transRollback(); // echo '{"msg" :'.$e.',"status":0}';exit; // } }elseif(base64_decode($apiKey) ==='9lb7ha66ak'){ $com_id =$_REQUEST['cm']; $dealer_id = $_REQUEST['dlr']; $user_id = $_REQUEST['usr']; $no_of_assign = $_REQUEST['nos']; $total_avl_cu = $db->return_result("SELECT count(id) as total FROM inactive_customer where id NOT IN (select customer_id from cu_assign)"); if(count($total_avl_cu)>0) { $cu_header=''; $check_rand_str =false; do{ $cu_header = randomStr(); $check_ = $db->return_result("SELECT ref_num_header FROM cu_assign WHERE ref_num_header ='". $cu_header."'"); if(count($check_)<=0){ $check_rand_str = true; } }while(!$check_rand_str); //BATCH NUMBER $batch_no =0; // $batch_type=2; MANUAL $batch_query = $db->return_result("SELECT batch_no FROM cu_assign WHERE active =1"); if(count($batch_query)>0) { foreach($batch_query as $b) { $batch_no= $b['batch_no'] +1; }unset($b); } //DEALER CODE $dealer_code =''; $dealer_name =''; $dealer_qry = $db->return_result("SELECT scd.dealer_id,sc.code,sc.name FROM source_company_dealer scd LEFT JOIN source_dealer sc ON scd.dealer_id = sc.id WHERE scd.status =1 AND scd.id=".$dealer_id); if(count($dealer_qry)>0) { foreach($dealer_qry as $d) { $dealer_code=$d['code']; $dealer_name = $d['name']; }unset($d); $process=0; $success=0; $new_cu_header = $cu_header.'-'.$dealer_code; $cu_ids = $db->return_result("SELECT id FROM inactive_customer WHERE id NOT IN (SELECT customer_id FROM cu_assign WHERE active=1) ORDER BY RAND() LIMIT " .$no_of_assign); if (count($cu_ids) > 0) { $db->transBegin(); foreach ($cu_ids as $key=> $cu) { $process++; //BATCH TYPE 1=auto assigned, 2=manully assigned $qry = $db->run_query("INSERT INTO `cu_assign`(`ref_num_header`,`customer_id`, `dealer_id`,`batch_no`,`batch_type`,`active`,`created_at`) VALUES ('" . $new_cu_header . "','" . $cu['id'] . "' ,'" . $dealer_id . "','".$batch_no."',2,1,'".date("Y-m-d h:i:s")."')"); $success++; } $db->transCommit(); echo('{"nos":"'.$no_of_assign.'","msg":"Successfully assigned to ","dealer":"'.$dealer_name.'","status":1}'); } else { echo ('{"msg":"No Inactive Customer available to assign in dealer.","status":0}');exit; } } else { echo ('{"msg":"Unable to assign to dealer. Please contact system administrator","status":0}');exit; }//has dealer } }elseif(base64_decode($apiKey) ==='xq2443ugxa'){ $user_id =$_REQUEST['uid']; $hdr = $_REQUEST['hdr']; $db->transBegin(); $qry = $db->run_query("INSERT INTO `cu_assigned_user`(`ref_num_header`,`user_id`,`created_at`) VALUES ('" . $hdr . "','" . $user_id . "' ,'".date("Y-m-d h:i:s")."')"); if($qry){ $db->transCommit(); echo('{"msg":"User successfully assigned","status":1}'); }else{ $db->transRollback(); echo '{"msg" :"User unsuccessfully assigned,"status":0}';exit; } }elseif(base64_decode($apiKey) ==='qpms3k82vn'){ $dealer_qry = $db->run_query("SELECT scd.dealer_id,sd.code,sd.id,sd.name,scd.status,(SELECT dealer_id FROM cu_exclude_dealer WHERE dealer_id = scd.dealer_id AND status =1) AS exd_dealer_id FROM source_company_dealer scd LEFT JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE scd.status =1 AND scd.type =1"); $json = []; foreach($dealer_qry as $dealer){ $json[] = ['id'=>$dealer['id'], 'text'=>$dealer['code'].' - '.$dealer['name'],'check'=>($dealer['exd_dealer_id']>0 ? '' : 'checked')]; } // print_r($json); echo json_encode($json); }elseif(base64_decode($apiKey) ==='r8wkrhisl2'){ $data = $_REQUEST['attr']; $process =0; $success =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}'); } }elseif($apiKey==='8666264351338448'){ $json_arr=[]; $current_user_employee_id = $_SESSION['user']['employee_id']; $dealer_id = $_SESSION['user']['dealer']; // echo'<pre>';print_r($_SESSION['user']);echo'</pre>';exit; $query1 = "SELECT count(cu.customer_id) AS total_icu FROM cu_assigned_user cu WHERE cu.customer_id NOT IN (select customer_id from cu_dealer_users_assign where is_removed=0) AND cu.dealer_id = ".$dealer_id." AND user_id='".$current_user_employee_id."'"; // echo $query1; $counts = $db->run_query($query1); $tot_inactive_icu =0; $json_arr['total_icu_assigned']=0; foreach ($counts as $count) { $tot_inactive_icu = $count['total_icu']; $json_arr['total_icu_assigned'] = number_format($count['total_icu']); }unset($count); echo json_encode($json_arr); }elseif(base64_decode($apiKey) ==='a1q7jyuj8s'){ //GET SOURCE $dealer_id = $_SESSION['user']['dealer']; $qry = $db->run_query("SELECT ref_num_header,dealer_id,batch_no,batch_type,active FROM cu_assign cu WHERE cu.dealer_id = ".$dealer_id." AND cu.active =1 GROUP BY ref_num_header"); $json_arr=[]; if($qry->num_rows>0){ foreach($qry as $dealer_hdr) { $json_arr[] = ['id'=>$dealer_hdr['ref_num_header'],'text'=> $dealer_hdr['ref_num_header']] ; } unset($dealer_hdr); } echo json_encode($json_arr); }elseif(base64_decode($apiKey)==='6sa3r7ieb8'){ $ref_num_header = $_REQUEST['hdr']; $dealer_id = $_SESSION['user']['dealer']; // $qry = $db->run_query("SELECT ref_num_header,dealer_id,batch_no,batch_type,customer_id,active FROM cu_assign cu WHERE cu.ref_num_header='".$ref_num_header."' AND cu.dealer_id = ".$dealer_id." AND cu.active =1 "); $json_arr= $total_counts = 0; $qry = $db->run_query("SELECT ref_num_header,dealer_id,batch_no,batch_type,customer_id,active FROM cu_assign cu WHERE cu.ref_num_header='".$ref_num_header."' AND cu.dealer_id = ".$dealer_id." AND cu.active =1 "); if($qry->num_rows>0) { $total_counts = $qry->num_rows; $json_arr = ['total_avl_customer' => $total_counts]; } echo json_encode($json_arr); }elseif(base64_decode($apiKey)==='qx79v7wxjt'){ //ASSIGN TO USERS UNDER PRIMARY ASSIGNED USER $ref_num_header = $_REQUEST['hdr']; $user_id =$_REQUEST['uid']; //assign to $assign_no =$_REQUEST['nos']; $dealer_id = $_SESSION['user']['dealer']; $assigned_by= $_SESSION['user']['id']; $employee_id = $_SESSION['user']['employee_id']; $dealer_header=''; $check_rand_str =false; if($user_id =='') { echo json_encode(['msg'=>"Failed to assign Customer DB. User field is required!.",'status'=>0]);exit; } do{ $dealer_header = randomStr(); $check_ = $db->return_result("SELECT dealer_ref_header FROM cu_dealer_users_assign WHERE dealer_ref_header ='". $dealer_header."'"); if(count($check_)<=0){ $check_rand_str = true; } }while(!$check_rand_str); //BATCH NUMBER $dealer_batch_no =1; // $batch_type=2; MANUAL $batch_query = $db->return_result("SELECT dealer_batch_no FROM cu_dealer_users_assign ORDER BY id desc limit 1"); if(count($batch_query)>0) { foreach($batch_query as $b) { $dealer_batch_no= $b['dealer_batch_no'] +1; }unset($b); } $process =0; $success =0; $qry = $db->run_query("SELECT cua.id,cua.ref_num_header,cua.dealer_id,cua.batch_no,cua.customer_id FROM cu_assigned_user cua WHERE cua.user_id='$employee_id' AND cua.ref_num_header='".$ref_num_header."' AND cua.dealer_id = ".$dealer_id." AND cua.customer_id NOT IN (select customer_id from cu_dealer_users_assign where ref_num_header='".$ref_num_header."' AND dealer_id = ".$dealer_id." AND is_removed=0) AND cua.active =1 ORDER BY RAND() LIMIT ".$assign_no); if($qry->num_rows>0) { foreach($qry as $icu_row){ $batch_no = $icu_row['batch_no']; try{ $process++; $customer_id =$icu_row['customer_id']; $db->transBegin(); $insert =$db->run_query("INSERT INTO `cu_dealer_users_assign`(`cu_assigned_user_id`,`ref_num_header`,`batch_no`,`dealer_ref_header`,`dealer_batch_no`,`dealer_id`,`customer_id`,`user_id`,`created_at`,`assigned_by`) VALUES ('" . $icu_row['id'] . "','" . $ref_num_header . "' ,'".$batch_no."','".$dealer_header."','".$dealer_batch_no."','".$dealer_id."','".$customer_id."','".$user_id."','".date("Y-m-d h:i:s")."','".$assigned_by."')"); if($insert){$success++;} }catch(\Throwable $e){ echo('{"msg":"Unable to update record."' .$e.',"status":0}'); } } unset($icu_row); } else { echo('{"msg":"Unable to update record. No avalilable customer to be assign.","status":0}');exit; } if($process==$success) { $db->transCommit(); $msg = ($assign_no> 1 ? $assign_no.' customers successfully assigned' : $assign_no.' customer successfully assigned'); echo('{"msg": "'.$msg.'","status":1}'); } else { $db->transRollback(); echo('{"msg":"Unable to update record.","status":0}'); } }elseif(base64_decode($apiKey)==='ZmtDl9SkyB'){ //Remove assignment $param = $utility->str_decrypt($_REQUEST['val']); $assigned_user_id = $param['user_id']; $dealer_id = $param['dealer_id']; // $ref_num_header = $param['ref_num_header']; $dealer_ref_header = $param['dealer_ref_header']; $current_user_id = $_SESSION['user']['id']; // echo'<pre';print_r($param);echo'</pre>';return; try{ $db->transBegin(); $update = $db->sql_query("UPDATE cu_dealer_users_assign SET is_removed =1, removed_by=".$current_user_id." WHERE user_id='".$assigned_user_id."' AND dealer_id=".$dealer_id." AND dealer_ref_header='". $dealer_ref_header."'"); if($update){ $db->transCommit(); echo '{"msg" :"Record successfully updated.","status":1}'; }else{ $db->transRollback(); // echo "INSERT INTO `all_activity_log`(`description`,`owner_id`,`target_id`,`code`) VALUES ('$log_desc',NULLIF('$id',''),'$customer_id','$code')";exit; echo '{"msg" :"Unable to remove assignment. Please contact system administrator.","status":0}';exit; } }catch (\Throwable $e) { $db->transRollback(); echo '{"msg" :"Unable to create logs "'.$e.',"status":0}';exit; } } }

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