public function action_Edit($Kid = 0) { //ドロップダウンリストの生成 $select = Model_College::get_list(); $Kid and $this->data['category'] = Model_Category::query()->where('Kid', '=', $Kid)->get(); if (Input::post()) { $val = Model_Category::validate(); if ($val->run()) { $query = DB::update('Category')->set(array('Cid' => Input::post('college'), 'Kname' => Input::post('Kname'), 'Kkana' => Input::post('Kkana'), 'luID' => Auth::get_screen_name()))->where('Kid', '=', $Kid)->execute(); Response::redirect('category'); } else { $this->message = $val->error(); $view = View::forge('categorymanagement/CategoryEdit', $this->data); $view->set_global('message', $this->message, false); //ドロップダウン箇所のセット $view->set_global('select', $select, false); } } else { $view = View::forge('categorymanagement/CategoryEdit', $this->data); $view->set_global('message', $this->message, false); //ドロップダウン箇所のセット $view->set_global('select', $select, false); } return $view; }
public static function get_list() { //Collegeテーブルの呼び出し $college = Model_College::query()->where('df', '=', '0')->get(); //テーブルを配列で回す foreach ($college as $row) { //$dataに、配列'college'を作成 //$変数=['配列名->テーブルのテーブルID']=配列名->テーブルの名前←ここがViewで表示される場所 $data[$row->Cid] = $row->Cname; //全てのデータを取り出したら回すのをやめる } return $data; }
public function action_Edit($Cid = 0) { $Cid and $this->data['coll'] = Model_College::query()->where('Cid', '=', $Cid)->get(); if (Input::post()) { $val = Model_College::validate(); if ($val->run()) { $query = DB::update('College')->set(array('Cname' => Input::post('Cname'), 'Ckana' => Input::post('Ckana'), 'luID' => Auth::get_screen_name()))->where('Cid', '=', $Cid)->execute(); Response::redirect('college'); } else { $this->message = $val->error(); $view = View::forge('collegemanagement/CollEdit', $this->data); $view->set_global('message', $this->message, false); } } else { $view = View::forge('collegemanagement/CollEdit', $this->data); $view->set_global('message', $this->message, false); } return $view; }
public function action_Edit($Did = 0) { $data = array(); $Did and $this->data['galtuka'] = Model_Galtuka::query()->where('Did', '=', $Did)->get(); $select = Model_College::get_list(); if (Input::post()) { $val = Model_Galtuka::validate(); if ($val->run()) { $query = DB::update('Galtuka')->set(array('Did' => Input::post('Did'), 'Cid' => Input::post('college'), 'Dname' => Input::post('Dname'), 'Dkana' => Input::post('Dkana'), 'luID' => Auth::get_screen_name()))->where('Did', '=', $Did)->execute(); Response::redirect('department'); } else { $this->message = $val->error(); $view = View::forge('department/DepEdit', $this->data); $view->set_global('message', $this->message, false); $view->set_global('select', $select, false); } } else { $view = View::forge('department/DepEdit', $this->data); $view->set_global('message', $this->message, false); $view->set_global('select', $select, false); } return $view; }