public function make_form_project_area($regist_area = []) { $ViewModel = new ViewModel(); $data = $ViewModel->get_area_type(); if (!empty($regist_area)) { $defaults_area = array(); foreach ($regist_area as $key => $value) { if (!empty($value)) { $defaults_area = array_merge($defaults_area, array('area_type' . ($key + 1) => $value)); } } $this->form->setDefaults($defaults_area); } $this->form->addElement('select', 'area_type1', 'エリア1:', $data); $this->form->addElement('select', 'area_type2', 'エリア2:', $data); $this->form->addElement('select', 'area_type3', 'エリア3:', $data); }
public function get_project($project_id, $member_id = "") { try { $sql = "SELECT * FROM project WHERE id = :id limit 1"; $stmh = $this->pdo->prepare($sql); $stmh->bindValue(':id', $project_id, PDO::PARAM_INT); $stmh->execute(); $row = $stmh->fetch(PDO::FETCH_ASSOC); $row['action'] = 0; if ($member_id != "") { $ActionModel = new ActionModel(); if ($ActionModel->check_member_action($member_id, $project_id)) { $row['action'] = 1; } } $ViewModel = new ViewModel(); $project = $ViewModel->get_project_type(); $area = $ViewModel->get_area_type(); $company = $ViewModel->get_company_name(); $row['project_type'] = $project[$row['project_type']]; $row['area_type'] = $area[$row['area_type']]; $row['company_name'] = $company[$row['company_id']]; } catch (PDOException $Exception) { print "エラー" . $Exception->getMessage(); } return $row; }