public function getDataByAgencyId($agencycode) { $agency_obj = new Agency(); $rs_agency_info = $agency_obj->getAgecyInfoByCode($agencycode); $agencydata_obj = new DataPrivacy(); $rs = $agencydata_obj->getDataByAgencyId($rs_agency_info[0]->id); return View::make('requestdata.ajax_databyagency')->with('all_data', $rs); }
/** * [getCondtionType retun set of conditoni at the data privacy is TRUE] * @return [array] [collection of data type] */ public static function getCondtionType() { $dataid_str = DataPrivacy::getData(); $condition = QueryData::whereIn('data_id', $dataid_str)->where('policy_status', '=', true)->where('condition', '!=', "")->distinct()->orderBy('cond_id', 'ASC')->get(array('cond_id', 'cond_name')); //->toSql(); //var_dump($dataid_str); //var_dump($condition);exit; return $condition; }
/** * [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.'); }
/** * [dataPeerPrivacy return information of agency's privacy] * @param [integer] $agency_id [agency id] * @return [type] [description] */ public function dataPeerPrivacy($agency_id) { $dataprivacy = new DataPrivacy(); //$rs index is agency_id $rs = $dataprivacy->getDataPrivacyByAgencyId($agency_id); // $rs_alldata = Data::all()->toArray(); // // var_dump(Data::all()->toArray()); // var_dump($rs_alldata); // var_dump($rs); // exit; return View::make('peer.ajax_agencylist')->with('agency_dataprivacy', $rs); }
/** * [dataPeerPrivacy return information of agency's privacy] * @param [integer] $agency_id [agency id] * @return [type] [description] */ public function dataPeerPrivacy($agency_id) { $dataprivacy = new DataPrivacy(); //$rs index is agency_id $rs = $dataprivacy->getDataPrivacy($agency_id); // var_dump(Data::all()->toArray()); // var_dump($rs);exit; return View::make('peer.ajax_dataprivacy')->with('agency_dataprivacy', $rs)->with('data_info', Data::all()->toArray()); }