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());
}