/**
* @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;
}
