/** * [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; }
/** * [privacyDataSave save method for user privacy * @param [integer] $agency_id [agency id] * @param [integer] $user_id [user id] * @return [none] [redirect to user privacy page] */ public function privacyDataSave($agency_id, $user_id) { $data = Input::all(); //var_dump($data);exit; //Get all data type $data_type = Data::all(); foreach ($data as $key => $value) { if ($key != "_token") { list($data_id, $table_info) = explode(":", $key); $value == 'on' ? $status = true : ($status = false); // echo $status; // echo "<br />"; $priv_data['data_id'] = $data_id; $priv_data['agency_id'] = $agency_id; $priv_data['status'] = $status; $privacy_data[] = $priv_data; } } // var_dump($privacy_data); // exit; DataPrivacy::where('agency_id', '=', $agency_id)->delete(); DataPrivacy::insert($privacy_data); return Redirect::to('/privacy/' . $user_id)->with('success', 'Your data privacy saved.'); }