/** * @author Bui Dang <*****@*****.**> * action login */ public function action_index() { if (\Fuel\Core\Session::get('login_info')) { \Fuel\Core\Response::redirect(($uri = \Fuel\Core\Session::get('uri_before_login')) ? $uri : \Fuel\Core\Uri::base()); } if (\Fuel\Core\Input::post()) { $login_id = \Fuel\Core\Input::post('login_id'); $pass = \Fuel\Core\Input::post('password'); if ($user = Model_Muser::find_one_by(array('login_id' => $login_id, 'pass' => hash('SHA256', $pass)))) { $login_info = array('department_id' => $user['department_id'], 'division_type' => $user['division_type'], 'name' => $user['name'], 'login_id' => $user['login_id'], 'email' => $user['mail'], 'user_id' => $user['user_id'], 'expired' => time() + 30 * 60); \Fuel\Core\Session::set('login_info', $login_info); $url = \Fuel\Core\Uri::base(); if ($user['division_type'] == 2) { $url = \Fuel\Core\Uri::base() . '?division=2'; } if ($user['division_type'] == 3) { $url = \Fuel\Core\Uri::base() . '?division=3'; } \Fuel\Core\Response::redirect(($uri = \Fuel\Core\Session::get('uri_before_login')) ? $uri : $url); } \Fuel\Core\Session::set_flash('error', 'ログインIDもしくはパスワードが正しくありません'); } $this->template->title = 'UOS求人システム'; $this->template->content = \View::forge('login/index'); }
public static function get_email_user($user_id) { if (!isset($user_id) or !\Model_Muser::find_by_pk($user_id)) { return null; } return \Model_Muser::find_by_pk($user_id)->mail; }
/** * @author Thuanth6589 <*****@*****.**> * action list user */ public function action_index() { $filters = Input::get(); $query_string = empty($filters) ? '' : '?' . http_build_query($filters); Session::set('users_url', Uri::base() . 'master/users' . $query_string); $m_user = new \Model_Muser(); $data = array(); $data['count_user'] = $m_user->count_data($filters); $pagination = \Uospagination::forge('pagination', array('pagination_url' => Uri::base() . 'master/users' . $query_string, 'total_items' => $data['count_user'], 'per_page' => \Constants::$default_limit_pagination, 'num_links' => \Constants::$default_num_links, 'uri_segment' => 'page', 'show_last' => true)); $filters['offset'] = $pagination->offset; $filters['limit'] = $pagination->per_page; $data['filters'] = $filters; $data['pagination'] = $pagination; $data['department'] = \Constants::get_search_department(); $data['division_type'] = \Constants::$division_type; $data['users'] = $m_user->get_data($filters); $this->template->title = 'UOS求人システム'; $this->template->content = View::forge('users', $data); }
/** * @author Thuanth6589 <*****@*****.**> * action delete user */ public function action_delete() { if (Input::method() == 'POST') { $user_id = Input::post('user_id', null); $result = 'error'; if (!\Model_Muser::find_by_pk($user_id)) { $message = 'ユーザーは存在しません'; } else { $message = \Constants::$message_delete_error; $user = new \Model_Muser(); if ($user->delete_data($user_id)) { $result = 'success'; $message = \Constants::$message_delete_success; } } Session::set_flash($result, $message); } $url = Session::get('users_url') ? Session::get('users_url') : Uri::base() . 'master/users'; return Response::redirect($url); }
/** * get all data user * @return array */ private function _get_data_user() { $result = array(); $list = \Model_Muser::find_all(); foreach ($list as $user) { $result[$user['user_id']]['name'] = $user['name']; $result[$user['user_id']]['department_id'] = $user['department_id']; } return $result; }
public function action_index() { $data = array(); $model_par = new \Model_Mpartner(); $model_ss = new \Model_Mss(); $model_job = new \Model_Job(); $model_or = new \Model_Orders(); $m_user = new Model_Muser(); $m_person = new Model_Person(); $data['m_partner'] = $model_par->count_data(array('status' => 1)); $data['m_ss'] = $model_ss->count_data(array('status' => '0')); $data['job'] = $model_job->count_data(); $data['or'] = count($model_or->get_all_order_list(null, null, array('unapproved' => '0'))); $data['person_inactive'] = $m_person->count_data(array('status' => '0')); $this->template->title = 'UOS求人システム'; $this->template->content = View::forge('default/top', $data); $user_info = \Fuel\Core\Session::get('login_info'); $division = $user_info['division_type']; $department_id = $user_info['department_id']; if ($division == 2) { $data['count_partner'] = $model_par->count_data(array('department_id' => $department_id, 'status' => '1')); $data['count_ss'] = $model_ss->count_data(array('department_id' => $department_id, 'status' => '0')); $data['count_job'] = $model_job->count_job_department_id(array('department_id' => $department_id, 'status' => '0')); $data['count_order'] = count($model_or->get_all_order_list(null, null, array('department_id' => $department_id, 'unapproved' => '0'))); $data['list_user'] = $m_user->get_data(array('department_id' => $department_id, 'order_by_time' => 1)); $data['link_partner'] = \Fuel\Core\Uri::base() . 'master/partners?department_id=' . $department_id . '&status=1'; $data['link_ss'] = \Fuel\Core\Uri::base() . 'master/sslist?department_id=' . $department_id . '&status=0'; $data['link_job'] = \Fuel\Core\Uri::base() . 'job/jobs?department_id=' . $department_id . '&status=0'; $data['link_order'] = \Fuel\Core\Uri::base() . 'job/orders?department_id=' . $department_id . '&unapproved=0&flag=1'; $array_user = array(); foreach ($data['list_user'] as $user) { $array_user[] = $user->user_id; } $list_person = $m_person->get_person_division_2($array_user); foreach ($list_person as $person) { foreach ($array_user as $k => $v) { if ($person['interview_user_id'] == $v || $person['agreement_user_id'] == $v || $person['training_user_id'] == $v || $person['partner_user_id'] == $v) { if ($person['contact_result'] == 0) { $data['count'][$v]['contact_result'] = isset($data['count'][$v]['contact_result']) ? $data['count'][$v]['contact_result'] + 1 : 1; } if ($person['review_date'] == '') { $data['count'][$v]['review_date'] = isset($data['count'][$v]['review_date']) ? $data['count'][$v]['review_date'] + 1 : 1; } if ($person['review_result'] == 0) { $data['count'][$v]['review_result'] = isset($data['count'][$v]['review_result']) ? $data['count'][$v]['review_result'] + 1 : 1; } if ($person['adoption_result'] == 0) { $data['count'][$v]['adoption_result'] = isset($data['count'][$v]['adoption_result']) ? $data['count'][$v]['adoption_result'] + 1 : 1; } if ($person['contract_date'] == '') { $data['count'][$v]['contract_date'] = isset($data['count'][$v]['contract_date']) ? $data['count'][$v]['contract_date'] + 1 : 1; } if ($person['contract_result'] == 0) { $data['count'][$v]['contract_result'] = isset($data['count'][$v]['contract_result']) ? $data['count'][$v]['contract_result'] + 1 : 1; } if ($person['hire_date'] == '') { $data['count'][$v]['hire_date'] = isset($data['count'][$v]['hire_date']) ? $data['count'][$v]['hire_date'] + 1 : 1; } if ($person['employee_code'] == '') { $data['count'][$v]['employee_code'] = isset($data['count'][$v]['employee_code']) ? $data['count'][$v]['employee_code'] + 1 : 1; } if ($person['work_confirmation'] == 0) { $data['count'][$v]['work_confirmation'] = isset($data['count'][$v]['work_confirmation']) ? $data['count'][$v]['work_confirmation'] + 1 : 1; } } } } $data['pagination'] = \Uospagination::forge('pagination', array('pagination_url' => Uri::base() . '?division=2', 'total_items' => count($data['list_user']), 'per_page' => \Constants::$default_limit_pagination, 'num_links' => \Constants::$default_num_links, 'uri_segment' => 'page', 'show_last' => true)); $this->template->content = View::forge('default/division2', $data); } elseif ($division == 3) { $this->division3(); } else { $this->template->content = View::forge('default/top', $data); } }
public function _where($filter = array()) { $is_where = DB::select('person.*', DB::expr('person.name as p_name'), 'employment.contact_result', 'employment.review_date', 'employment.classification', 'employment.adoption_result', 'employment.registration_expiration', 'employment.rank', 'employment.register_date', 'employment.contract_date', 'employment.contract_result', 'employment.hire_date', 'employment.work_confirmation', 'employment.employee_code', 'employment.code_registration_date', 'm_ss.ss_name', 'm_partner.branch_name', 'job.job_id', DB::expr('m_group.name as g_name'), 'm_partner.department_id', 'm_user.name', 'sssale.sale_name', 'sssale.sale_type', array('m_group.name', 'm_group_name'), array('sssale2.sale_name', 'job_sale_name'), array('m_ss2.ss_name', 'job_ss_name'))->from('person')->join('job', 'LEFT')->on('job.job_id', '=', 'person.job_id'); $is_where->join('sssale', 'LEFT')->on('person.sssale_id', '=', 'sssale.sssale_id'); $is_where->join('m_ss', 'LEFT')->on('m_ss.ss_id', '=', 'sssale.ss_id'); $is_where->join('m_partner', 'LEFT')->on('m_partner.partner_code', '=', 'm_ss.partner_code'); $is_where->join('m_group', 'LEFT')->on('m_partner.m_group_id', '=', 'm_group.m_group_id'); $is_where->join('employment', 'LEFT')->on('employment.person_id', '=', 'person.person_id'); $is_where->join('m_user', 'LEFT')->on('m_partner.user_id', '=', 'm_user.user_id'); $is_where->join(array('sssale', 'sssale2'), 'LEFT')->on('job.sssale_id', '=', 'sssale2.sssale_id'); $is_where->join(array('m_ss', 'm_ss2'), 'LEFT')->on('sssale2.ss_id', '=', 'm_ss2.ss_id'); $is_where->order_by('person_id', 'desc'); $is_where->group_by('person_id'); if (isset($filter['addr1']) && $filter['addr1'] != '') { $is_where->and_where('person.addr1', 'like', '%' . $filter['addr1'] . '%'); } if (isset($filter['addr2']) && $filter['addr2'] != '') { $arr_addr = array_filter(preg_split('/\\s|\\s+| /', trim($filter['addr2']))); $is_where->and_where_open(); $is_where->and_where_open(); foreach ($arr_addr as $k => $v) { $is_where->where(\Fuel\Core\DB::expr('CONCAT(person.addr2, person.addr3)'), 'like', '%' . $v . '%'); } $is_where->and_where_close(); $is_where->and_where_close(); } if (isset($filter['status']) && $filter['status'] != '') { $is_where->where('person.status', '=', $filter['status']); } if (isset($filter['email']) && $filter['email'] != '') { $is_where->and_where_open(); $is_where->where('mail_addr1', 'LIKE', '%' . $filter['email'] . '%')->or_where('mail_addr2', 'LIKE', '%' . $filter['email'] . '%'); $is_where->and_where_close(); } if (isset($filter['name']) && $filter['name'] != '') { $is_where->and_where_open(); $is_where->where('person.name', 'LIKE', '%' . $filter['name'] . '%'); $is_where->or_where('person.name_kana', 'LIKE', '%' . $filter['name'] . '%'); $is_where->and_where_close(); } if (isset($filter['phone']) && $filter['phone'] != '') { $is_where->and_where_open(); $is_where->where('person.tel', 'LIKE', '%' . $filter['phone'] . '%')->or_where('person.mobile', 'LIKE', '%' . $filter['phone'] . '%'); $is_where->and_where_close(); } if (isset($filter['group_id']) && $filter['group_id'] != '') { $is_where->and_where_open(); $is_where->where('m_partner.m_group_id', '=', $filter['group_id']); $is_where->and_where_close(); } if (isset($filter['partner_code']) && $filter['partner_code'] != '') { $is_where->and_where_open(); $is_where->where('m_ss.partner_code', '=', $filter['partner_code']); $is_where->and_where_close(); } if (isset($filter['ss_id']) && $filter['ss_id'] != '') { $is_where->and_where_open(); $is_where->where('sssale.ss_id', '=', $filter['ss_id']); $is_where->and_where_close(); } if (isset($filter['ss_name']) && $filter['ss_name'] != '') { $is_where->and_where_open(); $is_where->where('ss_name', 'LIKE', '%' . $filter['ss_name'] . '%'); $is_where->and_where_close(); } if (isset($filter['branch_name']) && $filter['branch_name'] != '') { $is_where->and_where_open(); $is_where->where('branch_name', 'LIKE', '%' . $filter['branch_name'] . '%'); $is_where->and_where_close(); } if (isset($filter['to_date']) && $filter['to_date'] != '') { $filter_date = strtotime($filter['to_date']) + 86399; $date_to = date('Y-m-d H:i:s', $filter_date); } if (isset($filter['from_date']) && isset($filter['to_date']) && $filter['from_date'] != '' && $filter['to_date'] == '') { $is_where->and_where_open(); $is_where->where('application_date', '>=', $filter['from_date']); $is_where->and_where_close(); } if (isset($filter['to_date']) && $filter['from_date'] == '' && $filter['to_date'] != '') { $is_where->and_where_open(); $is_where->and_where('application_date', '<=', $date_to); $is_where->and_where_close(); } if (isset($filter['from_date']) && $filter['from_date'] != '' && $filter['to_date'] != '') { $is_where->and_where_open(); $is_where->where('application_date', '>=', $filter['from_date']); $is_where->and_where('application_date', '<=', $date_to); $is_where->and_where_close(); } if (isset($filter['gender']) && $filter['gender'] != '') { $is_where->and_where_open(); $is_where->where('gender', 'IN', $filter['gender']); $is_where->and_where_close(); } if (isset($filter['age_from']) && $filter['age_from'] != '' && $filter['age_to'] != '' && isset($filter['age_to'])) { $is_where->and_where_open(); $is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '>=', $filter['age_from']); $is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '<=', $filter['age_to']); $is_where->and_where_close(); } elseif (isset($filter['age_from']) && $filter['age_from'] != '' && $filter['age_to'] == '') { $is_where->and_where_open(); $is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '>=', $filter['age_from']); $is_where->and_where_close(); } elseif (isset($filter['age_to']) && $filter['age_to'] != '' && $filter['age_from'] == '') { $is_where->and_where_open(); $is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '<=', $filter['age_to']); $is_where->and_where_close(); } $datas = array(); for ($i = 1; $i <= 3; $i++) { $datas['license' . $i] = ''; if (isset($filter['license' . $i])) { $is_where->and_where_open(); foreach ($filter['license' . $i] as $key => $value) { $datas['license' . $i] .= ',' . $value; } if (isset($datas['license' . $i]) && $datas['license' . $i] != '') { $x = explode(',', $datas['license' . $i]); unset($x[0]); foreach ($x as $key => $value) { $is_where->or_where(DB::expr('FIND_IN_SET("' . $value . '",license' . $i . ')')); } } $is_where->and_where_close(); } } if (isset($filter['review_result']) && $filter['review_result'] != '') { $is_where->and_where_open(); if (isset($filter['review_result'][0]) && !isset($filter['review_result'][1])) { $is_where->where('review_result', '=', 1); } elseif (!isset($filter['review_result'][0]) && isset($filter['review_result'][1])) { $is_where->where('review_result', '<>', 1); $is_where->or_where('review_result', 'is', null); } else { $is_where->where(DB::expr(1, '=', 1)); } $is_where->and_where_close(); } if (isset($filter['rank']) && $filter['rank'] != '') { $is_where->and_where_open(); $is_where->where('rank', 'IN', $filter['rank']); $is_where->and_where_close(); } if (isset($filter['contract_result']) && $filter['contract_result'] != '') { $is_where->and_where_open(); $is_where->where('contract_result', 'IN', $filter['contract_result']); $is_where->and_where_close(); } if (isset($filter['adoption_result']) && $filter['adoption_result'] != '') { $is_where->and_where_open(); $is_where->where('adoption_result', 'IN', $filter['adoption_result']); $is_where->and_where_close(); } if (isset($filter['user_id']) && $filter['user_id'] != '') { $is_where->and_where_open(); $is_where->where('m_partner.user_id', '=', $filter['user_id']); $is_where->and_where_close(); } if (isset($filter['department']) && $filter['department'] != '' && $filter['user_id'] == '') { $list_user_id = array(); $model_user = new \Model_Muser(); $list_users = $model_user->get_list_user_by_departmentid($filter['department']); foreach ($list_users as $key => $val) { $list_user_id[] = $val['user_id']; } if (count($list_user_id)) { $is_where->and_where_open(); $is_where->where('m_partner.user_id', 'in', $list_user_id); $is_where->and_where_close(); } } if (isset($filter['media_name']) && $filter['media_name'] != '') { $model_m_media = new \Model_Mmedia(); $model_m_post = new \Model_Mpost(); $model_order = new \Model_Orders(); $media_id_list = $model_m_media->get_media_id_list_by_name($filter['media_name']); if (count($media_id_list) == 0) { $is_where->and_where_open(); $is_where->where('person.order_id', '=', '-1'); $is_where->and_where_close(); return $is_where; } foreach ($media_id_list as $key => $value) { $media_id_list[$key] = $value['m_media_id']; } $post_id_list = $model_m_post->get_list_post_id($media_id_list); if (count($post_id_list) == 0) { $is_where->and_where_open(); $is_where->where('person.order_id', '=', '-1'); $is_where->and_where_close(); return $is_where; } foreach ($post_id_list as $key => $value) { $post_id_list[$key] = $value['post_id']; } $order_id_list = $model_order->get_order_id_list($post_id_list); if (count($order_id_list) == 0) { $is_where->and_where_open(); $is_where->where('person.order_id', '=', '-1'); $is_where->and_where_close(); return $is_where; } foreach ($order_id_list as $key => $value) { $order_id_list[$key] = $value['order_id']; } $is_where->and_where_open(); $is_where->where('person.order_id', 'in', $order_id_list); $is_where->and_where_close(); } if (isset($filter['job_id']) && !empty($filter['job_id'])) { $is_where->where('person.job_id', '=', $filter['job_id']); } if (isset($filter['order_id']) && $filter['order_id']) { $is_where->where('person.order_id', '=', $filter['order_id']); } if (isset($filter['array_person'])) { $filter['array_person'] = empty($filter['array_person']) ? array(0) : $filter['array_person']; $is_where->where('person.person_id', 'in', $filter['array_person']); } if (isset($filter['reprinted_via']) && $filter['reprinted_via']) { $is_where->where('person.reprinted_via', '=', $filter['reprinted_via']); } if (isset($filter['sale_type']) && $filter['sale_type']) { $sql = 'select sssale_id from sssale where sale_type = ' . $filter['sale_type']; $rs = \Fuel\Core\DB::query($sql)->execute(); $sssale_id = [-1]; foreach ($rs as $item) { $sssale_id[] = $item['sssale_id']; } $is_where->where('person.sssale_id', 'in', $sssale_id); } if (isset($filter['limit'])) { $is_where->limit($filter['limit']); } if (isset($filter['offset'])) { $is_where->offset($filter['offset']); } return $is_where; }
<div>(2)<?php echo $register['mail2']; ?> </div> <?php } ?> </td> <td> <?php if ($register['status'] == 1) { ?> <span class="label label-default">対応済</span> <?php echo isset($register['update_at']) ? substr($register['update_at'], 0, 16) . ' - ' : ''; if (isset($register['user_id']) && ($muser = Model_Muser::find_by_pk($register['user_id']))) { echo $muser->name; } ?> <?php } else { ?> <span class="label label-danger">未対応</span> <?php } ?> </td> <td> <div class="btn-group"> <a href="#" data-toggle="dropdown" class="btn dropdown-toggle btn-sm btn-success" aria-expanded="false">
public static function person_field($data) { $model_post = new Model_Mpost(); $model_order = new Model_Orders(); $model_media = new Model_Mmedia(); $model_user = new Model_Muser(); $model_partner = new Model_Mpartner(); $cl_23 = ''; $p_l_1 = ''; $p_l_2 = ''; $p_l_3 = ''; $w_t = ''; if ($data['order_id'] != null) { $cl_3 = 'オーダー'; } elseif ($data['job_id'] != null) { $cl_3 = '求人情報'; } else { $cl_3 = 'その他'; } $arr_media_id = array(); $arr_media_name = array(); //$arr_sales_user_id = array(); $config_post['where'][] = array('post_id', '=', $data['post_id']); $list_media_id = $model_post->get_list_data($config_post); foreach ($list_media_id as $row) { $arr_media_id = $row['m_media_id']; } $media_name = $model_media->get_media_name($arr_media_id); foreach ($media_name as $row) { $arr_media_name = $row['media_name']; } $u_name = ''; $t_name = ''; $i_name = ''; $business_user_name = $model_user->get_user_name($data['business_user_id']); if (count($business_user_name)) { $u_name = $business_user_name['0']['name']; } $interview_user_name = $model_user->get_user_name($data['interview_user_id']); if (count($interview_user_name)) { $i_name = $interview_user_name['0']['name']; } $training_user_name = $model_user->get_user_name($data['training_user_id']); if (count($training_user_name)) { $t_name = $training_user_name['0']['name']; } $transportation = explode(',', $data['transportation']); foreach ($transportation as $key => $value) { if (isset(\Constants::$transportation[$value])) { $cl_23 .= \Constants::$transportation[$value] . '、'; } } $cl_23 = rtrim($cl_23, '、'); $license1 = explode(',', $data['license1']); foreach ($license1 as $key => $value) { if (isset(\Constants::$person_licenses[1][$value])) { $p_l_1 .= \Constants::$person_licenses[1][$value] . '、'; } } $p_l_1 = rtrim($p_l_1, '、'); $license2 = explode(',', $data['license2']); foreach ($license2 as $key => $value) { if (isset(\Constants::$person_licenses[2][$value])) { $p_l_2 .= \Constants::$person_licenses[2][$value] . '、'; } } $p_l_2 = rtrim($p_l_2, '、'); $license3 = explode(',', $data['license3']); foreach ($license3 as $key => $value) { if (isset(\Constants::$person_licenses[3][$value])) { $p_l_3 .= \Constants::$person_licenses[3][$value] . '、'; } } $p_l_3 = rtrim($p_l_3, '、'); $work_type = explode(',', $data['work_type']); foreach ($work_type as $key => $value) { if (isset(\Constants::$work_type[$value])) { $w_t .= \Constants::$work_type[$value] . '、'; } } $w_t = rtrim($w_t, '、'); if ($data['application_date'] != null) { $application_date = date_create($data['application_date']); $a_d = date_format($application_date, "Y-m-d"); } else { $a_d = ''; } $data['is_failure_existence'] == 1 ? $is_failure_existence = 'あり' : ($is_failure_existence = 'なし'); $data['is_country'] == 1 ? $is_country = '○' : ($is_country = '空欄'); return array('応募者ID' => $data['person_id'], '応募日時' => $a_d, '実績区分' => $cl_3, 'オーダーID' => $data['order_id'], '求人情報ID' => $data['job_id'], '媒体' => count($arr_media_name) !== 0 ? $arr_media_name : '', '氏名' => $data['p_name'], 'ふりがな' => $data['name_kana'], '生年月日' => $data['birthday'], '応募時年齢' => self::birthday($data['birthday'], ''), '現在年齢' => self::birthday($data['birthday'], $data['application_date']), '性別' => $data['gender'] != null ? $data['gender'] == 0 ? '男' : '女' : '', '郵便番号' => $data['zipcode'], '都道府県' => \Constants::$address_1[$data['addr1']], '市区町村' => $data['addr2'], '以降の住所' => $data['addr3'], '携帯電話' => $data['tel'], '固定電話' => $data['mobile'], 'メールアドレス1' => $data['mail_addr1'], 'メールアドレス2' => $data['mail_addr2'], '現在職業' => \Constants::$occupation_now[$data['occupation_now']], '現在職業補足' => $data['repletion'], '交通手段' => $cl_23, '通勤時間' => $data['walk_time'], '保有資格1' => $p_l_1, '保有資格2' => $p_l_2, '保有資格3' => $p_l_3, '勤務可能時間帯' => $w_t, '就業可能時期' => $data['employment_time'], '健康状態' => $data['health'], '障害有無' => $is_failure_existence, '障害部位' => $data['failure_existence'], '国籍(外国籍' => $is_country, '国籍・会話など' => $data['country'], 'メモ1' => $data['memo_1'], 'メモ2' => $data['memo_2'], '取引先グループ' => $data['g_name'], '取引先' => $data['branch_name'], 'SS' => $data['ss_name'], '営業所' => isset(\Constants::$department[$data['department_id']]) ? \Constants::$department[$data['department_id']] : '', '部門コード' => $data['department_id'], '売上形態' => isset(\Constants::$sale_type[$data['sale_type']]) ? \Constants::$sale_type[$data['sale_type']] : '', '連絡結果' => isset(\Constants::$_contact_result[$data['contact_result']]) ? \Constants::$_contact_result[$data['contact_result']] : '', '面接日' => $data['review_date'], '分類' => isset(\Constants::$_classification[$data['classification']]) ? \Constants::$_classification[$data['classification']] : '', '採否結果' => isset(\Constants::$_adoption_result[$data['adoption_result']]) ? \Constants::$_adoption_result[$data['adoption_result']] : '', '登録有効期限' => $data['registration_expiration'], '登録ランク' => isset(\Constants::$_rank[$data['rank']]) ? \Constants::$_rank[$data['rank']] : '', '登録更新日' => $data['register_date'], '契約締結日' => $data['contract_date'], '契約結果' => isset(\Constants::$_contract_result[$data['contract_result']]) ? \Constants::$_contract_result[$data['contract_result']] : '', '入社日' => $data['hire_date'], '勤務確認' => isset(\Constants::$_work_confirmation[$data['work_confirmation']]) ? \Constants::$_work_confirmation[$data['work_confirmation']] : '', '社員コード' => $data['employee_code'], '社員コード登録日' => $data['code_registration_date'], '営業担当者' => $u_name, '面接担当者' => $i_name, '研修担当者' => $t_name); }
/** * @author NamNT * action index */ public function action_index() { $data = array(); $is_view = array(); $model = new \Model_Person(); $employment = new \Model_Employment(); $model_job = new \Model_Job(); $model_order = new \Model_Orders(); $model_user = new \Model_Muser(); $sssale_id = null; $sssale_id_view = null; $order_id = null; $post_id = null; $data['person_info'] = null; $data['edit_person'] = null; $data['post_id'] = null; $data['job_id'] = $model_job->get_list_id(); $data['person_id'] = \Input::get('person_id'); $data['listusers_interview'] = array(); $data['listusers_agreement'] = array(); $data['listusers_training'] = array(); $data['listusers_business'] = array(); if (\Input::get('order_id')) { $order_id = \Input::get('order_id'); $od = $model_order->get_order_info($order_id); $post_id = $od['post_id']; $data['post_id'] = $post_id; $data['order'] = $od; $data['order'] = $model_user->get_user_info_path($od['interview_user_id'], 'interview', $data['order']); $data['order'] = $model_user->get_user_info_path($od['agreement_user_id'], 'agreement', $data['order']); $data['order'] = $model_user->get_user_info_path($od['training_user_id'], 'training', $data['order']); } if (\Input::get('person_id')) { $person_info = \Model_Person::find(\Input::get('person_id')); $data['edit_person'] = $person_info; $data['edit_person']['interview_department_id'] = ''; $data['edit_person']['agreement_department_id'] = ''; $data['edit_person']['training_department_id'] = ''; $data['edit_person']['business_department_id'] = ''; $data['edit_person']['listusers_interview'] = array(); $data['edit_person']['listusers_agreement'] = array(); $data['edit_person']['listusers_training'] = array(); $data['edit_person']['listusers_business'] = array(); $data['edit_person'] = $model_user->get_user_info_path($person_info->interview_user_id, 'interview', $data['edit_person']); $data['edit_person'] = $model_user->get_user_info_path($person_info->agreement_user_id, 'agreement', $data['edit_person']); $data['edit_person'] = $model_user->get_user_info_path($person_info->training_user_id, 'training', $data['edit_person']); $data['edit_person'] = $model_user->get_user_info_path($person_info->business_user_id, 'business', $data['edit_person']); $data['person_info'] = $data['edit_person']; if ($edit_data = $person_info->edit_data) { $person_info['application_date'] = substr($person_info['application_date'], 0, 16); $data['edit_person'] = json_decode($edit_data, true); $data['edit_person']['interview_user_id'] = isset($data['edit_person']['interview_user_id']) ? $data['edit_person']['interview_user_id'] : ''; $data['edit_person']['agreement_user_id'] = isset($data['edit_person']['agreement_user_id']) ? $data['edit_person']['agreement_user_id'] : ''; $data['edit_person']['training_user_id'] = isset($data['edit_person']['training_user_id']) ? $data['edit_person']['training_user_id'] : ''; $data['edit_person']['business_user_id'] = isset($data['edit_person']['business_user_id']) ? $data['edit_person']['business_user_id'] : ''; $data['edit_person']['interview_department_id'] = ''; $data['edit_person']['agreement_department_id'] = ''; $data['edit_person']['business_department_id'] = ''; $data['edit_person']['training_department_id'] = ''; $data['edit_person']['listusers_interview'] = array(); $data['edit_person']['listusers_agreement'] = array(); $data['edit_person']['listusers_training'] = array(); $data['edit_person']['listusers_business'] = array(); $data['edit_person'] = $model_user->get_user_info_path($data['edit_person']['interview_user_id'], 'interview', $data['edit_person']); $data['edit_person'] = $model_user->get_user_info_path($data['edit_person']['agreement_user_id'], 'agreement', $data['edit_person']); $data['edit_person'] = $model_user->get_user_info_path($data['edit_person']['training_user_id'], 'training', $data['edit_person']); $data['edit_person'] = $model_user->get_user_info_path($data['edit_person']['business_user_id'], 'business', $data['edit_person']); $data['is_view'] = \Utility::compare_json_data($person_info, $edit_data); } } $data_filter['field'] = array('step' => 4, 'type' => 1, 'label' => array('group' => 'グループ', 'partner' => '取引先(受注先)', 'ss' => 'SS', 'sslist' => '売上形態')); if ($data['edit_person']) { $sssale_id = $data['edit_person']['sssale_id']; } if ($data['person_info']) { $sssale_id_view = $data['person_info']['sssale_id']; } $data_filter['datafilter'] = \Presenter_Group_Filter::edit($data_filter['field']['step'], $data_filter['field']['type'], $sssale_id, $sssale_id_view); if (\Input::method() == 'POST') { $datas = array(); $dataPost = \Input::post(); $datas = $model->get_person_data($dataPost); $action = 'add'; foreach (\Input::post() as $key => $value) { if (\Input::post($key) == '') { $datas[$key] = null; } } if (!\Model_Sssale::find_by_pk($datas['sssale_id'])) { Session::set_flash('error', '売上形態は存在しません'); } else { if (\Input::get('person_id')) { $action = 'edit'; if (!($model = $model->find(\Input::get('person_id')))) { Session::set_flash('error', '応募者は存在しません'); Response::redirect('job/persons'); } $model->status = \Constants::$_status_person['pending']; $data_temp = Input::post(); if (!$data_temp['business_user_id']) { $data_temp['business_user_id'] = $this->get_default_business_user_id($data_temp['sssale_id']); } if (!$data_temp['interview_user_id']) { $data_temp['interview_user_id'] = $this->get_default_business_user_id($data_temp['sssale_id']); } if (!$data_temp['agreement_user_id']) { $data_temp['agreement_user_id'] = $this->get_default_business_user_id($data_temp['sssale_id']); } $model->edit_data = json_encode($model->get_person_data($data_temp)); if ($model->save()) { Session::set_flash('success', \Constants::$message_create_success); Response::redirect(Uri::base() . 'job/persons'); } } else { $datas['created_at'] = date('Y-m-d H:i:s'); if (!$datas['business_user_id']) { $datas['business_user_id'] = $this->get_default_business_user_id($datas['sssale_id']); } if (!$datas['interview_user_id']) { $datas['interview_user_id'] = $this->get_default_business_user_id($datas['sssale_id']); } if (!$datas['agreement_user_id']) { $datas['agreement_user_id'] = $this->get_default_business_user_id($datas['sssale_id']); } $model->set($datas); if ($model->save()) { if ($action == 'add') { $person_obj = $model->find($model->person_id); $sssale_id_mail = $person_obj->sssale_id != '' ? $person_obj->sssale_id : 0; $person_data = $model->get_data_for_mail($sssale_id_mail); if (count($person_data)) { //send mail $model_user = new \Model_Muser(); $department_id = $person_data['0']['department_id'] ? $person_data['0']['department_id'] : 0; $list_email_department = $model_user->get_list_mail_department($department_id); $datamail_department = array('m_group' => isset($person_data['0']['name']) ? $person_data['0']['name'] : '', 'branch_name' => isset($person_data['0']['branch_name']) ? $person_data['0']['branch_name'] : '', 'ss_name' => isset($person_data['0']['ss_name']) ? $person_data['0']['ss_name'] : '', 'sale_name' => isset($person_data['0']['sale_name']) ? $person_data['0']['sale_name'] : '', 'list_emails' => $list_email_department, 'last_id' => $model->person_id); $model->sendmail_department($datamail_department); } } Session::set_flash('success', \Constants::$message_create_success); } else { Session::set_flash('error', \Constants::$message_create_error); } } } if (\Fuel\Core\Cookie::get('person_url')) { Response::redirect(\Fuel\Core\Cookie::get('person_url')); } else { Response::redirect('job/persons'); } } $this->template->title = 'UOS求人システム'; $this->template->content = \View::forge('persons/person', $data); $this->template->content->filtergroup = \Presenter::forge('group/filter')->set('custom', $data_filter); }
public function action_get_users() { if (\Input::method() != 'POST') { return false; } $department_id = \Input::post('department_id'); $model_user = new \Model_Muser(); $data['list_user'] = $model_user->get_list_user_by_departmentid($department_id, false, true); $content_type = array('Content-type' => 'application/json', 'SUCCESS' => 0); echo new \Response(json_encode($data), 200, $content_type); return false; }
public function action_update_status() { if (\Input::method() == 'POST') { $status = \Input::post('status'); $order_id = \Input::post('order_id'); $reason = \Input::post('reason', null); $result = 'error'; $message = '保存に失敗しました。'; $model_orders = new \Model_Orders(); $order_info = \Model_Orders::find_by_pk($order_id); if (!$order_info) { return 'failed'; } if ($status == 2) { if ($user_login = Session::get('login_info')) { $model_orders->order_update(array('order_user_id' => $user_login['user_id']), $order_id); } } $db_status = array('status' => $status); if ($model_orders->order_update($db_status, $order_id)) { if ($status == 1 || $status == -1) { //get list media $model_media = new \Model_Mmedia(); $listmedias = $model_media->get_list_all_media(); $media_name = null; if ($order_info->post_id && $listmedias != null) { $listmedias = array_column($listmedias, 'media_name', 'm_media_id'); $post_info = \Model_Mpost::find_by_pk($order_info->post_id); if ($post_info) { $media_id = $post_info->m_media_id; $media_name = isset($listmedias[$media_id]) ? $listmedias[$media_id] : null; } } //get list ss $model_ss = new \Model_Mss(); $listss = $model_ss->get_list_all_ss(); $ssitem = null; if ($order_info->ss_list && $listss != null) { $listss_name = array_column($listss, 'ss_name', 'ss_id'); $ss_list_item = explode(',', trim($order_info->ss_list, ',')); foreach ($ss_list_item as $key => $value) { if (array_key_exists($value, $listss_name)) { $ssitem .= $listss_name[$value] . ','; } } } $ssitem = trim($ssitem, ','); $agreement_type = null; if ($order_info->agreement_type) { $agreement = \Model_Sssale::find_by_pk($order_info->agreement_type); } $agreement_type = isset($agreement->sale_name) ? $agreement->sale_name : null; if ($order_info->ss_id) { $ss_info = \Model_Mss::find_by_pk($order_info->ss_id); $ss_name = isset($ss_info->ss_name) ? $ss_info->ss_name : null; } $model_user = new \Model_Muser(); //user logging $user_login = \Session::get('login_info'); $user_id = $user_login['user_id']; $user_info = $model_user->get_user_info($user_id); $department_id = $user_login['department_id']; if ($user_info) { $department_id = $user_info['department_id']; } $list_emails = $model_user->get_list_email_by_departmentid($department_id, $user_id, 1); $maildata = array('order_id' => $order_id, 'list_media_name' => $media_name, 'agreement_type' => $agreement_type, 'ss_name' => $ss_name, 'ss_list_name' => $ssitem, 'reason' => $reason, 'list_emails' => $list_emails); $model_orders->sendmail($status, $maildata, $order_info->create_id); } $result = 'success'; switch ($status) { case -1: $message = '非承認しました'; break; case 1: $message = '承認しました'; break; case 2: $message = '確定しました。'; break; case 3: $message = '停止しました。'; break; default: $message = '非承認しました'; break; } } \Session::set_flash($result, $message); return 'true'; } }
public function get_ss_info($ss_id, $get_partner = false) { //get partner and group by ss_id $ss_info = \Model_Mss::find_by_pk($ss_id); if ($ss_info) { $ss_partner = \Model_Mpartner::find_by_pk($ss_info->partner_code); if ($ss_partner) { $group_info = \Model_Mgroups::find_by_pk($ss_partner->m_group_id); $user_info = \Model_Muser::find_by_pk($ss_partner->user_id); $department = isset(\Constants::$department[$ss_partner->department_id]) ? \Constants::$department[$ss_partner->department_id] : ''; if ($get_partner) { return $ss_partner; } } } return array('group_info_name' => isset($group_info->name) ? $group_info->name : '', 'ss_partner_name' => isset($ss_partner->branch_name) ? $ss_partner->branch_name : '', 'ss_info_ss_name' => isset($ss_info->ss_name) ? $ss_info->ss_name : '', 'department_name' => isset($department) ? $department : '', 'department_id' => isset($ss_partner->department_id) ? $ss_partner->department_id : '', 'user_info_name' => isset($user_info->name) ? $user_info->name : ''); }
<td><?php echo $contact['mobile']; ?> </td> <td><?php echo $contact['mail']; ?> </td> <td> <?php if ($contact['status'] == 1) { ?> <span class="label label-default">対応済</span> <?php echo isset($contact['update_at']) ? substr($contact['update_at'], 0, 16) . ' - ' : ''; if (isset($contact['user_id']) && ($muser = Model_Muser::find_by_pk($contact['user_id']))) { echo $muser->name; } ?> <?php } else { ?> <span class="label label-danger">未対応</span> <?php } ?> </td> <td> <div class="btn-group"> <a href="#" data-toggle="dropdown" class="btn dropdown-toggle btn-sm btn-success"> 処理
} else { $first_ss .= ',' . $listss_item[$value]; } } } } echo $first_ss; ?> </td> <td><?php echo $items['user_name']; ?> </td> <td> <?php if (isset($items['order_user_id']) and $order_user = Model_Muser::find_by_pk($items['order_user_id'])) { echo $order_user->name; } ?> </td> <td><?php echo $items['post_date']; ?> </td> <td class="text-right"><?php echo number_format($items['price']); ?> 円</td> <td class="text-center"> <span class="label label-<?php echo \Constants::$order_status_class[$items['status']];
public static function get_department_user($user_id = null) { $department_id = null; if (!isset($user_id)) { return false; } if (\Model_Muser::find_by_pk($user_id)) { $department_id = \Model_Muser::find_by_pk($user_id)->department_id; } return $department_id; }