File manager

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

Back
<?php 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']); // // $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); // $users = $db -> return_result("SELECT `id`,`employee_id`, `company_dealer_id`,concat(`first_name`,' ',`last_name`) as fullname FROM `employee` WHERE company_dealer_id='".$scd_id."' AND status != '0' "); // $json = []; // foreach($users as $user){ // $json[] = ['id'=>$user['employee_id'], 'text'=>$user['fullname']]; // } // 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; 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(); echo('{"msg":"Record successfully updated.","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']; $current_user_id = $_SESSION['user']['id']; // echo'<pre';print_r($param);echo'</pre>'; try{ // echo"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 ref_num_header='".$ref_num_header."'";exit; $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='".$ref_num_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