File manager

File manager - Edit - /home/autoph/public_html/connectv1/lms/app/models/group.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/group.php'; $group_class = new Group(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model']) ){ $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db'=>$db, 'group_class'=>$group_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 add_temporary_group($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; $return_arr['id'] = $group_class->add_temporary_group($user['id'],$db); echo json_encode($return_arr); } function remove_temporary_group($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; $group_id = $request['id']; $return_arr['remove'] = $group_class->remove_temporary_group($group_id,$utility_class,$db); echo json_encode($return_arr); exit; } function group_user_table($param){ $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; $owner_id = intval($request['owner_id']) !== 0 ? $request['owner_id'] : $user['id'] ; // $upper_user_ids_arr = $group_class->get_upper_user_ids_arr($owner_id,$utility_class,$db); // logic // start -> get group owner -> find group owner upper level group -> back to start // bugs: $current_group_id = $request['group_id']; $group_owner_id = 0; while(true){ $group_owner_id = $group_class->get_group_owner_id($current_group_id,$utility_class,$db); // means add new group if(!$utility_class->isNotEmpty($group_owner_id)){ $group_owner_id = $owner_id; } // echo $group_owner_id;exit; $current_group_id = $group_class->get_member_group_id($group_owner_id,$utility_class,$db); // echo $current_group_id;exit; if(!$utility_class->isNotEmpty($current_group_id)){ break; } } $excepted_ids_arr = array($owner_id,$group_owner_id); $excepted_ids_arr = array_unique($excepted_ids_arr); $user_list_array = $group_class->group_user_table($request,$excepted_ids_arr,$utility_class,$db); $json_arr['total'] = $user_list_array[0]; $user_list_obj = $user_list_array[1]; $selected_group_members = json_decode($request['group_members'],true); $selected_group_members = $utility_class->toArrayInt($selected_group_members); // print_r($selected_group_members);exit; $json_arr['rows'] = array(); foreach($user_list_obj as $row){ $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'id_number'=>$row['id_number'], 'name'=>$row['name'], 'status'=> in_array(intval($row['id']), $selected_group_members) ? 1 : 0 , )) ); } echo json_encode($json_arr); } function group_member_table($param){ $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user_list_array = $group_class->group_member_table($request,$utility_class,$param['db']); $json_arr['total'] = $user_list_array[0]; $user_list_obj = $user_list_array[1]; $json_arr['rows'] = array(); foreach($user_list_obj as $row){ $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'id_number'=>$row['id_number'], 'name'=>$row['name'] )) ); } echo json_encode($json_arr); } function group_member_status($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $member_status_obj = $group_class -> read_user_membership($request['group_id'],$request['user_id'],$utility_class,$db); $member_status_arr = array(); foreach($member_status_obj as $row){ $member_status_arr = $row; } if(count($member_status_arr) > 0){ if(intval($member_status_arr['status']) === 1){ $affcted_rows = $group_class -> update_member_status($request['group_id'],$request['user_id'],0,$utility_class,$db); }else{ $affcted_rows = $group_class -> update_member_status($request['group_id'],$request['user_id'],1,$utility_class,$db); } }else{ $affcted_rows = $group_class -> insert_member_status($request['group_id'],$request['user_id'],1,$utility_class,$db); } if(intval($affcted_rows) > 0){ $return_arr['message'] = "Successful."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; }else{ $return_arr['message'] = "Error."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function update_group($param){ if($param['server_method'] !== 'POST'){ echo "Invalid request."; exit; } $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; $owner_id = intval($request['owner_id']) !== 0 ? $request['owner_id'] : $user['id'] ; $group_id = intval($request['id']); $selected_group_members = json_decode($request['group_members'],true); $selected_group_members = $utility_class->toArrayInt($selected_group_members); $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = trim(mb_strtoupper($array_data[$key])); $array_data[$key] = $db->escape($array_data[$key]); } // exit; if($group_id === 0){ $group_id = $group_class->insert_group($array_data,$owner_id,$utility_class,$db); }else{ $affected_rows = $group_class->update_group($group_id,$array_data,$owner_id,$utility_class,$db); } $selected_group_members_query = array(); foreach ($selected_group_members as $member_id){ $selected_group_members_query[] = "($group_id,$member_id,NOW(),1)"; } // echo implode(", ",$selected_group_members_query);exit; if(count($selected_group_members_query) > 0){ $affected_rows_members = $group_class->insert_group_members($group_id,$selected_group_members_query,$owner_id,$utility_class,$db); } $return_arr['message'] = "Group has been saved."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } function group_table($param){ $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; $owner_id = intval($request['added_by']) !== 0 ? $request['added_by'] : $user['id'] ; $group_table_arr = $group_class ->group_table($request,$owner_id,$utility_class,$db); $json_arr['total'] = $group_table_arr[0]; $group_list_obj = $group_table_arr[1]; $json_arr['rows'] = array(); foreach($group_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']), 'added_by'=>intval($row['added_by']), 'added_by_name'=>intval($row['added_by_name']), )) ); } echo json_encode($json_arr); } function remove_group($param){ $db = $param['db']; $group_class = $param['group_class']; $utility_class = $param['utility_class']; $request = $param['request']; $user = $param['user']; if($group_class->remove_group($request['id'],$utility_class,$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; } } ?>

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