File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/controllers/role.php

Back
<?php class Role { function read_roles($search,$offset,$limit,$db){ $offset_limit = ''; if($offset <> '' && $limit <> ''){ $offset_limit = " LIMIT $offset,$limit"; } $query="SELECT * FROM `employee_role` WHERE name LIKE '%$search%' AND status = 1 /AND id <> 1/ ORDER BY name ASC $offset_limit"; // echo $query; return $db -> return_result($query); } function read_role_by_id($role_id,$db){ $query="SELECT * FROM `employee_role_access` WHERE employee_role_id = '$role_id' AND status = 1"; // print_r( $db -> return_result($query)); return $db -> return_result($query); } function create_company_access_role($role_id,$data_to_insert,$db){ $query = "INSERT INTO `employee_role_access`(`employee_role_id`, `company_permissions`, `status`) VALUES ('$role_id','$data_to_insert','1')"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function update_company_access_role($role_id,$data_to_insert,$db){ $query = "UPDATE `employee_role_access` SET `company_permissions`='$data_to_insert',`timestamp`= NOW() WHERE employee_role_id = '$role_id'"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } //modify function update_dealer_access_role($role_id,$data_to_insert,$db){ // echo "UPDATE `employee_role_access` SET `dealer_permissions`='$data_to_insert',`timestamp`= NOW() WHERE employee_role_id = '$role_id'" $query = "UPDATE `employee_role_access` SET `dealer_permissions`='$data_to_insert',`timestamp`= NOW() WHERE employee_role_id = '$role_id'"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function create_access_role($role_id,$data_to_insert,$db){ $query = "INSERT INTO `employee_role_access`(`employee_role_id`, `action_permissions`, `status`) VALUES ('$role_id','$data_to_insert','1')"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function create_access_fields($role_id,$data_to_insert,$db){ $query = "INSERT INTO `employee_role_access`(`employee_role_id`, `fields_permissions`, `status`) VALUES ('$role_id','$data_to_insert','1')"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function delete_role($role_id,$db){ $query = "UPDATE `employee_role` SET `status`= '0' WHERE `id` = '$role_id' "; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function update_access_role($role_id,$data_to_insert,$db){ $query = "UPDATE `employee_role_access` SET `action_permissions`='$data_to_insert',`timestamp`= NOW() WHERE employee_role_id = '$role_id'"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function update_access_fields($role_id,$data_to_insert,$db){ $query = "UPDATE `employee_role_access` SET `fields_permissions`='$data_to_insert',`timestamp`= NOW() WHERE employee_role_id = '$role_id'"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function update_role_name($role_id,$name,$db){ $query = "UPDATE `employee_role` SET `name`='$name' WHERE id = '$role_id'"; $rows_affected = $db->sql_query_num_inserted($query); return $rows_affected; } function read_user_account_by_role_id($role_id,$db){ $query = "SELECT count(id) FROM `employee_account` WHERE `employee_role_id` = '$role_id' "; return $db->select($query); } function read_company_access_role_by_id($id,$db){ } } ?>

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