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