/** * [privacyFrm show privacy page] * @param [integer] $id [user id] */ public function privacyFrm($id) { //get user's privacy by user id $priv_user = new Privacy(); $user = $priv_user->getUserPrivacy($id); //var_dump($user);exit; //get user's info by user id $usernhc_obj = new Usernhc(); $usernhc = $usernhc_obj->getUsernhcById($id); //get data relate with agency $agency_data = new AgencyData(); $rs_agency_data = $agency_data->getDataByAgency($usernhc[0]->agency_id); // var_dump($rs_agency_data);//exit; //get agency's data privacy by agency id $priv_data = new DataPrivacy(); $data = $priv_data->getDataPrivacy($usernhc[0]->agency_id); // var_dump($data);exit; //get all data name $data_table = Data::all(); foreach ($data_table as $key => $value) { $raws[$value['id']][] = $value; } // var_dump($raws);exit; //get all period for each data_id $period_data = RetainData::all(); //var_dump($period_data);exit; $privacy_init = PrivacyInit::all()->toArray(); $period = array(array('name' => 'ระยะเก็บรักษาข้อมูล 1 วัน', 'value' => '1:day'), array('name' => 'ระยะเก็บรักษาข้อมูล 1 เดือน', 'value' => '1:month'), array('name' => 'ระยะเก็บรักษาข้อมูล 3 เดือน', 'value' => '3:month'), array('name' => 'ระยะเก็บรักษาข้อมูล 6 เดือน', 'value' => '6:month'), array('name' => 'ระยะเก็บรักษาข้อมูล 1 ปี', 'value' => '1:year'), array('name' => 'ระยะเก็บรักษาข้อมูล 3 ปี', 'value' => '3:year'), array('name' => 'ระยะเก็บรักษาข้อมูล 5 ปี', 'value' => '5:year'), array('name' => 'ระยะเก็บรักษาข้อมูล 7 ปี', 'value' => '7:year'), array('name' => 'ระยะเก็บรักษาข้อมูล 10 ปี', 'value' => '10:year')); $rt = new RetainData(); $rs = $rt->listRetain(); //var_dump($period_data->toArray());exit; return View::make('privacy.privacy')->with('priv_user', $user[0])->with('priv_data', $data)->with('user_info', $usernhc[0])->with('src_table', $raws)->with('period', $period)->with('period_data', $period_data)->with('active_status', $this->active_status)->with('privacy_init', $privacy_init)->with('retain_data', $rs)->with('period_text', $this->period_text)->with('agency_data', $rs_agency_data); }
/** * [peerDataList return list of agency by data] * @param [type] $data_id [rainfall ,waterlevel,dam,temp etc.] * @return [type] [description] */ public function peerDataList($data_id) { //var_dump($type);exit; // list ($table,$data_field,$date_field) = explode("-", $type); // $agency_id = Data::getAgencyByDataType($table); //print_r($agency_id);exit; //$rs = Agency::getAgency($agency_id); $agency_data = new AgencyData(); $rs = $agency_data->getAgenyByDataId($data_id); // var_dump($rs);exit; return View::make('peer.ajax_datalist')->with('result', $rs); }
/** * [agencyDataAdd description] * @return [type] [description] */ public function agencyDataAdd() { $data = Input::all(); //var_dump($data);exit; $rules = array('agency_id' => 'required', 'data_id' => 'required'); // Build the custom messages array. $messages = array('agency_id.required' => 'กรุณาระบุชื่อหน่วยงาน', 'data_id.required' => 'กรุณาระบุชื่อข้อมูล'); // Create a new validator instance. $validator = Validator::make($data, $rules, $messages); if ($validator->passes()) { $agencydata_obj = new AgencyData(); $agencydata_obj->removeAgencyData($data['agency_id']); foreach ($data['data_id'] as $key => $value) { $arrInsert = array('agency_id' => $data['agency_id'], 'data_id' => $value); $arrInserts[] = $arrInsert; } $agencydata_obj->insert($arrInserts); return Redirect::route('agencydata')->with('success', 'บันทึกสำเร็จ'); } else { // $errors = $validator->messages(); return Redirect::back()->withErrors($validator); } }
/** * [removeAgencyData description] * @param [type] $agency_id [description] * @return [type] [description] */ public function removeAgencyData($agency_id) { AgencyData::where('agency_id', '=', $agency_id)->delete(); }