home/autoph/public_html/connectv1/api/controllers/role.php 0000644 00000010077 15031046135 0017772 0 ustar 00 '' && $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){
}
}
?>