PHP MemberModel::get_member_base_info_id方法代码示例

 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']);
//.........这里部分代码省略.........

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