public function screen_member_modify($auth = "") { $btn1 = ""; $btn2 = ""; $area = ""; $project = ""; if ($this->action == "view" && $this->is_system) { $MemberModel = new MemberModel(); $_SESSION[_MEMBER_AUTHINFO] = $MemberModel->get_member_base_info_id($_GET['id']); } $birthday_defaults = array('Y' => substr($_SESSION[_MEMBER_AUTHINFO]['birthday'], 0, 4), 'm' => substr($_SESSION[_MEMBER_AUTHINFO]['birthday'], 4, 2), 'd' => substr($_SESSION[_MEMBER_AUTHINFO]['birthday'], 6, 2)); $hope_start_defaults = array('Y' => substr($_SESSION[_MEMBER_AUTHINFO]['hope_start'], 0, 4), 'm' => substr($_SESSION[_MEMBER_AUTHINFO]['hope_start'], 4, 2), 'd' => substr($_SESSION[_MEMBER_AUTHINFO]['hope_start'], 6, 2)); $regist_area = $_SESSION[_MEMBER_AUTHINFO]['area_type']; $regist_area = explode('/', $regist_area); $this->make_form_project_area($regist_area); $regist_project = $_SESSION[_MEMBER_AUTHINFO]['project_type']; $regist_project = explode('/', $regist_project); $this->make_form_project_type($regist_project); $this->form->setDefaults(array('mail' => $_SESSION[_MEMBER_AUTHINFO]['mail'], 'last_name' => $_SESSION[_MEMBER_AUTHINFO]['last_name'], 'first_name' => $_SESSION[_MEMBER_AUTHINFO]['first_name'], 'birthday' => $birthday_defaults, 'gender' => array('gender' => $_SESSION[_MEMBER_AUTHINFO]['gender']), 'hope_start' => $hope_start_defaults, 'expe_appeal' => $_SESSION[_MEMBER_AUTHINFO]['expe_appeal'])); $this->make_member_regist_form_no_pass(); $this->make_member_regist_add_form(); if (isset($_POST['re'])) { $data = $this->form->getSubmitValues(); } if (isset($data)) { if (!$this->check_area($data, 3)) { $this->area = '希望のエリアを一つ以上選択してください'; $this->action = "form"; } if (!$this->check_project_member($data)) { $this->project = '希望の職種は一つ以上選択してください'; $this->action = "form"; } if (!$this->form->validate()) { $this->action = "form"; } } else { if ($this->action != "view") { $this->action = "form"; } } if ($this->action == "view" && $this->is_system) { $this->file = "system_member_detail.tpl"; $this->title = "登録情報"; $this->message = "--サイトメンバーの詳細を表示しています--"; $regist_project = $this->make_view_project_type($_SESSION[_MEMBER_AUTHINFO]['project_type']); $this->view->assign('id', $_SESSION[_MEMBER_AUTHINFO]['id']); $this->view->assign('birthday', $_SESSION[_MEMBER_AUTHINFO]['birthday']); $this->view->assign('gender', $_SESSION[_MEMBER_AUTHINFO]['gender']); $this->view->assign('hope_start', $_SESSION[_MEMBER_AUTHINFO]['hope_start']); $this->view->assign('data', $regist_project); $btn1 = "更新"; $btn2 = "削除"; $this->form->freeze(); } if ($this->action == "form") { $this->file = "member_modify.tpl"; $this->title = "登録情報の修正"; $this->message = "登録された情報の修正できます!"; $this->next_type = "modify"; $this->next_action = "confirm"; $btn1 = "確認"; $btn2 = ""; } else { if ($this->action == "confirm") { $this->form->freeze(); $this->file = "member_modify_freeze.tpl"; $this->title = "登録情報の修正"; $this->message = "下記で宜しいでしょうか?"; $this->next_type = "modify"; $this->next_action = "complete"; $btn1 = "登録"; $btn2 = "戻る"; } else { if ($this->action == "complete" && isset($_POST['submit2']) && $_POST['submit2'] == "戻る") { $this->file = "member_modify.tpl"; $this->title = "登録情報の修正"; $this->message = "登録された情報の修正できます!"; $this->next_type = "modify"; $this->next_action = "confirm"; $btn1 = "確認"; $btn2 = ""; } else { if ($this->action == "complete" && isset($_POST['submit1']) && $_POST['submit1'] == "登録") { $MemberModel = new MemberModel(); $PrememberModel = new PrememberModel(); if ($_SESSION[_MEMBER_AUTHINFO]['mail'] != $data['mail'] && ($MemberModel->check_member($data) || $PrememberModel->check_member($data))) { $this->file = "member_modify.tpl"; $this->title = "登録画面"; $this->message = "!!!すでにこのメールアドレスは登録されています!!!"; $this->next_type = "modify"; $this->next_action = "confirm"; $btn1 = "確認"; $btn2 = ""; } else { $data['birthday'] = sprintf("%04d%02d%02d", $data['birthday']['Y'], $data['birthday']['m'], $data['birthday']['d']); $data['gender'] = sprintf("%1d", $data['gender']['gender']); $data['area_type'] = $this->data_area_input($data); $data['project_type'] = $this->data_project_input($data); $data['hope_start'] = sprintf('%04d%02d%02d', $data['hope_start']['Y'], $data['hope_start']['m'], $data['hope_start']['d']); $data['id'] = $_SESSION[_MEMBER_AUTHINFO]['id']; $MemberModel->modify_member($data); if ($this->is_system) { $this->title = "更新完了"; $this->message = "会員情報を更新しました"; $this->URL = "system.php?type=member_list"; $this->URL .= $this->add_pageID(); } else { $this->auth->auth_member_ok($data); $this->title = "登録情報の修正が完了しました。"; $this->message = "下記よりトップ画面へお戻りください"; } $this->file = "message.tpl"; } } } } } $this->view->assign('area_error', $area); $this->view->assign('project_error', $project); $this->form->addElement('submit', 'submit1', $btn1); $this->form->addElement('submit', 'submit2', $btn2); $this->form->addElement('reset', 'reset', '取り消し'); $this->view_display(); }
public function get_base_applicant_list($data) { $MemberModel = new MemberModel(); $CustomerModel = new CustomerModel(); $array = array(); for ($i = 0; $i < count($data); $i++) { $project_data = $CustomerModel->get_project($data[$i]['project_id']); $member_data = $MemberModel->get_member_base_info_id($data[$i]['member_id']); $array[$i]['action_id'] = $data[$i]['id']; $array[$i]['project_title'] = $project_data['title']; $array[$i]['project_reg_date'] = $project_data['reg_date']; $array[$i]['member_last_name'] = $member_data['last_name']; $now = date('Ymd'); $array[$i]['member_age'] = floor(($now - $member_data['birthday']) / 10000); $array[$i] = array_merge($array[$i], $data[$i]); } return $array; }
public function system_get_detail_message_messsage_id($message_id) { try { $sql = " SELECT * FROM message \n WHERE\n id = :message_id \n limit 1 "; $stmh = $this->pdo->prepare($sql); $stmh->bindValue(':message_id', $message_id, PDO::PARAM_INT); $stmh->execute(); $i = 0; $data = array(); $MemberModel = new MemberModel(); $CustomerModel = new CustomerModel(); $ActionModel = new ActionModel(); $data = $stmh->fetch(PDO::FETCH_ASSOC); $action_data = $ActionModel->get_action_id($data['action_id']); $customer_data = $CustomerModel->get_customer_authinfo_id($data['company_id']); $member_data = $MemberModel->get_member_base_info_id($data['member_id']); $project_data = $CustomerModel->get_project_title($data['project_id']); $data['action_reg_date'] = $action_data['reg_date']; $data['company_name'] = $customer_data['company_name']; $data['member_name'] = $member_data['last_name'] . ' ' . $member_data['first_name']; $data['title'] = $project_data; $data['body'] = htmlspecialchars($data['body'], ENT_QUOTES); $data['body'] = nl2br($data['body']); $i++; } catch (PDOException $Exception) { print "エラー" . $Exception->getMessage(); } return $data; }