/**
* [getPolicyByUserId get policy by relete with user id]
* @return [array] [collect of policy]
*/
public static function getPolicyByUserId()
{
$role_id = Usernhc::getRoleName()->role_id;
$rs = DB::table('role_policy')->join('policy', 'role_policy.policy_id', '=', 'policy.id')->where('role_policy.role_id', '=', $role_id)->orderBy('policy.id', 'asc')->select('policy.id', 'policy.policy_content', 'policy.author', 'policy.status', 'policy.policy_duty')->distinct()->get();
//var_dump($rs);exit;
return $rs;
}
/**
* [getData get data at the status data is ture]
* @return [array] [return set of data status is true]
*/
public static function getData()
{
$user_role = new Usernhc();
$role_id = $user_role->getRoleName()->role_id;
//Get role id
$rs_policy = RolePolicy::where('role_id', '=', $role_id)->select('policy_id')->get()->toArray();
//Get relate policy
$policy_id = $rs_policy[0]['policy_id'];
//Policy id
$data_id = DataPolicy::where('policy_id', '=', $policy_id)->select('data_id')->get()->toArray();
$data_id = array_flatten($data_id);
// Data id that relate with policy
$rs_dataid = DataPrivacy::where('status', '=', true)->whereIn('data_id', $data_id)->distinct()->get(array('data_id'));
foreach ($rs_dataid->toArray() as $key => $value) {
$id[] = $value['data_id'];
}
//$dataid_set = implode("','", $id); //Displays 'A', 'B', 'C'
return $id;
}
