File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/lms/app/models/user.php

Back
<?php if(isset($_REQUEST['api'])){ include_once dirname(__FILE__) . '/../../cfg/db_api.php'; }else{ include_once dirname(__FILE__) . '/../../cfg/db.php'; if(!intval($global_user_status)){ echo $global_user_message; exit; } } include_once dirname(__FILE__) . '/../../app/controllers/user.php'; include_once dirname(__FILE__) . '/../../app/controllers/lead.php'; $user_class = new User(); $lead_class = new Lead(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model']) ){ $function_name = $db->escape($_REQUEST['model']); // call_user_func_array($function_name, array($db,$user_class,$utility_class,$server_method,$_REQUEST)); $parameters = array( 'db'=>$db, 'user_class'=>$user_class, 'lead_class'=>$lead_class, 'utility_class'=>$utility_class, 'server_method'=>$server_method, 'user_id'=>$session_user_id, 'user_dealer_id'=>$session_user_dealer_id, 'user'=>$session_user, 'request'=>$_REQUEST, ); call_user_func($function_name,$parameters); }else{ echo "Invalid request."; exit; } function signup($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $request = $param['request']; $db = $param['db']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ if($key != 'password'){ $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); } } //check dup id no. $id_no_count = $param['user_class']->read_id_number_count($array_data['id_no'],$param['utility_class'],$db); if(intval($id_no_count) > 0){ $return_arr['message'] = "ID number already exist."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } $email_count = $param['user_class']->read_email_count($array_data['email'],$param['utility_class'],$db); if(intval($email_count) > 0){ $return_arr['message'] = "Email address already exist."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } $mobile_count = $param['user_class']->read_mobile_count($array_data['mobile'],$param['utility_class'],$db); if(intval($mobile_count) > 0){ $return_arr['message'] = "Mobile number already exist."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if($param['user_class']->insert_user_details($array_data,$param['utility_class'],$db) === 2){ $return_arr['message'] = "Account successfully created."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Account not created. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function signin($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $utility_class = $param['utility_class']; $array_data = json_decode($param['request']['json_data'],true); $where_statement = " AND (uc.email = '".$array_data['username']."' OR ua.username = '".$array_data['username']."') "; $result_arr = $param['user_class'] -> system_user_security($where_statement,$array_data,'login',$utility_class,$db); echo json_encode($result_arr); } function signout($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } if(isset($_SESSION['crm_user'])){ session_destroy(); }else{ echo "No Session Found."; } } function user_login_info($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } // print_r($_SESSION['crm_user']); echo json_encode($_SESSION['crm_user']); } function user_notification_info($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $user_id = $param['user_id']; $notification_obj = $user_class->get_user_notification_info($user_id,$utility_class,$db); $notification_arr['data'] = array(); $total_count = 0; foreach($notification_obj as $row){ $total_count += intval($row['total']); $notification_arr['data'] = array_merge( $notification_arr['data'], array(array( 'id'=>$row['id'], 'count'=>$row['total'], 'type'=>$row['name'], 'ago'=>$utility_class->time_elapsed_string($row['ago_time']), ))); } $notification_arr['total'] = $total_count; // print_r($notification_arr); echo json_encode($notification_arr); } function user_notification($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $lead_class = $param['lead_class']; $request = $param['request']; $user_id = $param['user_id']; $type_id = $request['type_id']; $offset = $request['offset']; $limit = $request['limit']; $notification_obj = $user_class->get_user_notification_list($user_id,$type_id,$offset,$limit,$utility_class,$db); $notification_arr['data'] = array(); foreach($notification_obj as $row){ //get target name $target_info = ''; $ntype_id = intval($row['notification_type_id']); if($ntype_id === 1 \|\| $ntype_id === 2){ $target_info = $lead_class->read_name_by_id($row['target_id'],$db); } $replace_parameter_content = array( '[from]'=>ucfirst(strtolower($row['firstname'])).' '.strtoupper(substr($row['lastname'],0,1)), '[target]'=>ucwords(strtolower($target_info)),// ucfirst(strtolower($row['firstname'])).' '.strtoupper(substr($row['lastname'],0,1)), ); $notification_arr['data'] = array_merge($notification_arr['data'], array(array( 'id'=>$row['notif_id'], 'type_id'=>$ntype_id, 'description'=>$row['description'], 'description'=> strtr($row['description'],$replace_parameter_content), 'date_added'=>$row['date_addedf'], 'is_read'=>$row['is_read'], ))); } // print_r($notification_arr); echo json_encode($notification_arr); } function mark_as_read_notification($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_id = $param['user_id']; $type_id = $request['type_id']; $user_class->mark_as_read_notification($user_id,$type_id,$utility_class,$db); $return_arr['message'] = "Updated."; $return_arr['status'] = 1; echo json_encode($return_arr); } function add_temporary_role($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $user_id = $param['user_id']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $return_arr['id'] = $user_class->insert_temporary_role($request,$user_id,$param['utility_class'],$param['db']); echo json_encode($return_arr); exit; } function remove_temporary_role($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $user_id = $param['user_id']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $return_arr['remove'] = $user_class->delete_temporary_role($request,$user_id,$param['utility_class'],$param['db']); echo json_encode($return_arr); exit; } function update_role($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $user_id = $param['user_id']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $array_data = json_decode($param['request']['json_data'],true); $role_menus_array = array(); foreach ($array_data as $key => $value){ $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $param['db']->escape($array_data[$key]); if(substr( $key, 0, 3 ) === "ra_" && intval($value) === 1){ $role_menus_array[] = intval(substr( $key, 3, 4 )); } } $affected_rows = $user_class->update_role( $request['id'],$array_data,$user_id,$param['utility_class'],$param['db']); $user_class -> update_role_menus($request['id'],json_encode($role_menus_array),$param['utility_class'],$param['db']); $return_arr['message'] = "Role has been added."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function role_dealer_list($param){ $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $dealer_list_array = $param['user_class']->role_dealer_list($request,$param['utility_class'],$param['db']); $json_arr['total'] = $dealer_list_array[0]; $dealer_list_obj = $dealer_list_array[1]; $json_arr['rows'] = array(); foreach($dealer_list_obj as $row){ $role_dealers = $user_class -> read_role_dealers($request['role_id'],$param['utility_class'],$param['db']); $role_dealers_array = json_decode($role_dealers,true); $dealer_id = $row['d_id']; if(in_array($dealer_id, $role_dealers_array)){ $status = 1; }else{ $status = 0; } $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'c_id'=>$row['c_id'], 'c_code'=>$row['c_code'], 'c_name'=>$row['c_name'], 'd_id'=>$row['d_id'], 'd_code'=>$row['d_code'], 'd_name'=>$row['d_name'], 'dealer'=>$row['d_name'].' ('.$row['d_code'].')', 'status'=>$status, )) ); } echo json_encode($json_arr); } function role_change_status($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $role_dealers = $user_class -> read_role_dealers($request['role_id'],$param['utility_class'],$param['db']); $role_dealers_array = json_decode($role_dealers,true); $dealer_id = $request['dealer_id']; if(in_array($dealer_id, $role_dealers_array)){ //remove dealer if (($key = array_search($dealer_id, $role_dealers_array)) !== false) { unset($role_dealers_array[$key]); $role_dealers_array = array_values($role_dealers_array); } }else{ //add dealer $role_dealers_array[] = intval($dealer_id); } $affcted_rows = $user_class -> update_role_dealers($request['role_id'],json_encode($role_dealers_array),$param['utility_class'],$param['db']); if(intval($affcted_rows) > 0){ $return_arr['message'] = "Role has been updated."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Role not updated."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function role_list($param){ $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $role_list_array = $param['user_class']->role_list($request,$param['utility_class'],$param['db']); $json_arr['total'] = $role_list_array[0]; $role_list_obj = $role_list_array[1]; $json_arr['rows'] = array(); foreach($role_list_obj as $row){ $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'name'=>$row['name'], 'user_count'=>intval($row['user_count']), 'menu_access'=>$row['json_menus'], )) ); } echo json_encode($json_arr); } function remove_role($param){ $user_class = $param['user_class']; if($user_class->remove_role($param['request']['id'],$param['utility_class'],$param['db']) === 1){ $return_arr['message'] = "Successfully removed."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Not removed. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function get_user_dealers($param){ $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; $user_dealers = $user['dealer_access']; echo json_encode($user_dealers); } ?>

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