/**
* @author Thuanth6589 <*****@*****.**>
* delete media
* @param $media_id
* @return bool
*/
public function delete_media($media_id)
{
$media = Model_Mmedia::find_by_pk($media_id);
if ($media) {
try {
$media_in_job = Model_Job::count('job_id', false, array(array('media_list', 'like', '%,' . $media_id . ',%')));
$media_in_order = Model_Orders::count('order_id', false, array(array('media_list', 'like', '%,' . $media_id . ',%')));
if ($media_in_job || $media_in_order) {
return false;
}
\Fuel\Core\DB::start_transaction();
$post = new Model_Mpost();
$delete_post = $post->delete_by_media($media_id);
if (!isset($delete_post)) {
\Fuel\Core\DB::rollback_transaction();
return false;
}
if ($media->delete() != 1) {
\Fuel\Core\DB::rollback_transaction();
return false;
}
\Fuel\Core\DB::commit_transaction();
return true;
} catch (Exception $e) {
\Fuel\Core\DB::rollback_transaction();
}
}
return false;
}
/**
* @author Thuanth6589 <*****@*****.**>
* list media
*/
public function action_index()
{
$m_group = new \Model_Mgroups();
$m_partner = new \Model_Mpartner();
$tmp = array('' => 'その他');
$data['groups'] = $tmp + (new \Model_Mgroups())->get_type(2);
$data['partners'] = $this->_partners;
$filters = Input::get();
$query_string = empty($filters) ? '' : '?' . http_build_query($filters);
Session::set('medias_url', Uri::base() . 'master/medias' . $query_string);
if (isset($filters['m_group_id']) && $filters['m_group_id']) {
$data['partners'] += array_column($m_partner->get_partner_group($filters['m_group_id'], $this->_partner_type), 'branch_name', 'partner_code');
}
$m_media = new \Model_Mmedia();
$m_post = new \Model_Mpost();
$data['count_media'] = $m_media->count_data($filters);
$pagination = \Uospagination::forge('pagination', array('pagination_url' => Uri::base() . 'master/medias' . $query_string, 'total_items' => $data['count_media'], '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;
$medias = $m_media->get_data($filters);
foreach ($medias as $media) {
$media->count_post = $m_post->count_by_media_id($media->m_media_id);
}
$data['pagination'] = $pagination;
$data['medias'] = $medias;
$data['type'] = \Constants::$media_type;
$data['classification'] = \Constants::get_search_media_classification();
$data['filters'] = $filters;
$this->template->title = 'UOS求人システム';
$this->template->content = View::forge('medias', $data);
}
public function view()
{
$model_group = new \Model_Mgroups();
$model_media = new \Model_Mmedia();
$model_partner = new \Model_Mpartner();
$model_post = new Model_Mpost();
$data['listgroup2'] = array();
$list_partner2 = $model_partner->get_list_by_type(2);
if ($list_partner2) {
$data['listgroup2'] = $model_group->get_list_by_partner($list_partner2);
}
$data['listpost'] = array();
$data['listmedia'] = array();
$data['listpartner'] = array();
$post_id = $this->post_id;
$data['post_id_selected'] = 0;
$data['media_id_selected'] = 0;
$data['partner_code_selected'] = 0;
$data['group_id_selected'] = 0;
$media_id = 0;
$partner_code = 0;
$group_id = 0;
$data['media_name'] = null;
if ($post_id) {
$post_info = $model_post->find_by_pk($post_id);
if ($post_info) {
$media_id = $post_info['m_media_id'];
} else {
$data['no_data'] = true;
}
if ($media_id) {
$media_info = $model_media->find_by_pk($media_id);
if ($media_info) {
$partner_code = $media_info['partner_code'];
$data['media_name'] = $media_info['media_name'];
} else {
$data['no_data'] = true;
}
if ($partner_code) {
$partner_info = $model_partner->find_by_pk($partner_code);
if ($partner_info) {
$group_id = $partner_info['m_group_id'];
$data['listpartner'] = $model_partner->get_partner_group($group_id, 2);
$config['where'] = array('partner_code' => $partner_code);
$data['listmedia'] = $model_media->get_search_data($config);
} else {
$data['no_data'] = true;
}
}
$config['where'] = array('m_media_id' => $media_id);
$data['listpost'] = $model_post->get_search_data($config);
}
}
$data['post_id_selected'] = $post_id;
$data['media_id_selected'] = $media_id;
$data['partner_code_selected'] = $partner_code;
$data['group_id_selected'] = $group_id;
$this->data = $data;
}
public function action_postinfo()
{
if (\Input::method() != 'POST') {
return false;
}
$post_id = \Input::post('post_id');
$data['postcount'] = \Model_Mpost::get_count_by_id($post_id);
$content_type = array('Content-type' => 'application/json', 'SUCCESS' => 0);
echo new \Response(json_encode($data), 200, $content_type);
return false;
}
/**
* @author Thuanth6589 <*****@*****.**>
* action create/edit media
*/
public function action_index()
{
$m_media_id = Input::get('id', null);
$filter_group = $this->filter_group;
$datafilter['field'] = $filter_group;
$media = new \Model_Mmedia();
if (isset($m_media_id)) {
$media = \Model_Mmedia::find_by_pk($m_media_id);
if (!isset($media)) {
Session::set_flash('error', '媒体は存在しません');
return Response::redirect('/master/medias');
}
$datafilter['datafilter'] = \Presenter_Group_Filter::edit($filter_group['step'], $filter_group['type'], $media->partner_code);
$data['media'] = $media;
$data['posts'] = \Model_Mpost::find_by_m_media_id($m_media_id);
}
$data['media_name_existed'] = $media->get_list_media('media_name');
$data['media_version_name_existed'] = $media->get_list_media('media_version_name');
if (Input::method() == 'POST') {
$url = Session::get('medias_url') ? Session::get('medias_url') : Uri::base() . 'master/medias';
$m_media_id = Input::post('m_media_id', null);
if ($m_media_id && !\Model_Mmedia::find_by_pk($m_media_id)) {
Session::set_flash('error', '媒体は存在しません');
return Response::redirect($url);
}
if (!\Model_Mpartner::find_by_pk(Input::post('partner_code'))) {
Session::set_flash('error', '取引先(受注先)は存在しません');
} else {
$media = new \Model_Mmedia();
$media_data = $media->set_data(Input::post());
$umedia = new \Model_Umedia();
$posts = Input::post('post') != null ? Input::post('post') : array();
if ($umedia->save_media($media_data, $posts, Input::post('m_media_id'))) {
Session::set_flash('success', \Constants::$message_create_success);
return Response::redirect($url);
}
Session::set_flash('error', \Constants::$message_create_error);
}
}
$data['classification'] = \Constants::get_create_media_classification();
$this->template->title = 'UOS求人システム';
$this->template->content = View::forge('media', $data);
$this->template->content->filtergroup = \Presenter::forge('group/filter')->set('custom', $datafilter);
}
/**
* get all data post
* @return array
*/
private function _get_data_post()
{
$result = array();
$list = \Model_Mpost::find_all();
foreach ($list as $post) {
$result[$post['post_id']]['m_media_id'] = $post['m_media_id'];
$result[$post['post_id']]['name'] = $post['name'];
$result[$post['post_id']]['price'] = $post['price'];
}
return $result;
}
?>
</td>
<td><?php
echo $media->branch_name;
?>
</td>
<td><?php
echo $media->media_name;
?>
</td>
<td><?php
echo $media->media_version_name;
?>
</td>
<td class="text-right"><?php
echo Model_Mpost::count_by_media_id($media->m_media_id);
?>
</td>
<td>
<div class="btn-group">
<a class="btn dropdown-toggle btn-sm btn-success" data-toggle="dropdown" href="#">
処理
<span class="caret"></span>
</a>
<ul class="dropdown-menu" name="add-pulldown">
<input type="hidden" value="<?php
echo $media->m_media_id;
?>
"/>
<li><a href="<?php
echo \Fuel\Core\Uri::base();
/**
* @author Thuanth6589 <*****@*****.**>
* save post
* @param array $data
* @return mixed
* @throws Exception
*/
public function save_data($data = array())
{
$post = Model_Mpost::forge();
$post->set($data);
return $post->save();
}
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;
}
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);
}
public function action_index()
{
$this->template->title = 'UOS求人システム';
$order_id = \Input::get('order_id');
$action = \Input::get('action');
//presenter group settings
$datafilter['field'] = array('step' => 3, 'type' => 1, 'label' => array('group' => 'グループ', 'partner' => '取引先(受注先)'));
$model_orders = new \Model_Orders();
$model_user = new \Model_Muser();
$data = array();
$data['remaining_cost'] = 0;
$data['listusers_sales'] = array();
$data['listusers_interview'] = array();
$data['listusers_agreement'] = array();
$data['listusers_training'] = array();
$data['listusers_author'] = array();
$data['info'] = $model_orders->get_order_info($order_id);
//user logging
$user_login = Session::get('login_info');
if ($order_id) {
if (empty($data['info']['order_id'])) {
\Response::redirect(\Uri::base() . 'job/orders?lost=true');
}
//permision
/*
if($action != 'copy' && $data['info']['status'] == 3)
{
\Response::redirect(\Uri::base().'job/orders?permission=false');
}
*
*/
$datafilter['datafilter'] = \Presenter_Group_Filter::edit($datafilter['field']['step'], $datafilter['field']['type'], $data['info']['ss_id']);
$data = $model_user->get_user_info_path($data['info']['author_user_id'], 'author', $data);
//$data = $model_user->get_user_info_path($data['info']['sales_user_id'],'sales',$data);
$data = $model_user->get_user_info_path($data['info']['interview_user_id'], 'interview', $data);
$data = $model_user->get_user_info_path($data['info']['agreement_user_id'], 'agreement', $data);
$data = $model_user->get_user_info_path($data['info']['training_user_id'], 'training', $data);
}
//get list ss
$model_ss = new \Model_Mss();
$data['listss'] = $model_ss->get_list_all_ss();
$model_group = new \Model_Mgroups();
$data['listgroup'] = $model_group->get_all();
$result = 'error';
$message = '保存に失敗しました。';
if (\Input::method() == 'POST') {
if ($order_id && !\Model_Orders::find_by_pk($order_id)) {
\Session::set_flash($result, 'オーダーは存在しません');
return \Response::redirect('job/orders');
}
$post = \Input::post();
$check = true;
$post['ss_list'] = isset($post['ss_list']) ? $post['ss_list'] : array();
foreach ($post['ss_list'] as $k => $v) {
if ($v != '' && !\Model_Mss::find_by_pk($v)) {
$message = 'SSは存在しません';
$check = false;
break;
}
}
if (!\Model_Mpost::find_by_pk($post['list_post'])) {
$message = '媒体は存在しません';
$check = false;
}
if (!\Model_Mss::find_by_pk($post['ss_id'])) {
$message = 'SSは存在しません';
$check = false;
}
if ($check && ($last = $model_orders->order_save($post, $action, $order_id))) {
if ($order_id == null || $action == 'copy') {
$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, 99);
$maildata = array('order_id' => $last[0], 'department_name' => isset($user_info['department_id']) ? \Constants::$department[$user_info['department_id']] : '', 'list_emails' => $list_emails);
$maildata['m_user_name'] = isset($user_info['name']) ? $user_info['name'] : '';
$model_orders->sendmail(99, $maildata, $user_id);
}
$result = 'success';
$message = '保存しました';
}
\Session::set_flash($result, $message);
$return_url_search = \Cookie::get('return_url_search');
if ($return_url_search) {
return \Fuel\Core\Response::redirect($return_url_search);
}
return \Response::redirect('job/orders');
}
$data['post_id_isset'] = false;
if ($data['info']['post_id']) {
if (\Model_Mpost::find_by_pk($data['info']['post_id'])) {
$data['post_id_isset'] = true;
}
}
$data['properties'] = $model_orders->data_default;
$this->template->content = \View::forge('orders/input', $data);
$this->template->content->filtergroup = \Presenter::forge('group/filter')->set('custom', $datafilter);
}
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 csv_process($list_orders)
{
if (empty($list_orders)) {
return array();
}
$csv_all_data = array();
$stt = 0;
foreach ($list_orders as $order) {
$csv_data = array();
$total_price = 0;
$order_ss_list = trim($order['ss_list'], ',');
$ss_list = explode(',', $order_ss_list);
//get media info
$price_int = $price_blance = '';
if ($order['post_id']) {
$post = \Model_Mpost::find_by_pk($order['post_id']);
if ($post) {
$media = \Model_Mmedia::find_by_pk($post->m_media_id);
if ($media) {
if ($media->type == 1) {
$type = '自力';
}
if ($media->type == 2) {
$type = '他力';
}
if ($media->budget_type == 1) {
$budget_type = '求人費';
}
if ($media->budget_type == 2) {
$budget_type = '販促費';
}
if ($media->is_web_reprint == 1) {
$is_web_reprint = 'あり';
}
if ($media->is_web_reprint == 0) {
$is_web_reprint = 'なし';
}
$classification = isset(\Constants::$media_classification[$media->classification]) ? \Constants::$media_classification[$media->classification] : '';
$partner = \Model_Mpartner::find_by_pk($media->partner_code);
$media_name = $media->media_name;
$total_ss = 1 + count($ss_list);
if ($media->is_web_reprint == 1) {
$total_ss = (1 + count($ss_list)) * 2;
}
$post_price = $post->price != null ? $post->price : 0;
$price = $post_price / $total_ss;
$price_int = (int) $price;
$price_blance = $price_int + $post_price % $total_ss;
}
}
}
//get partner and group by ss_id
$data_ss = $this->get_ss_info($order['ss_id']);
//ss_sale info
if ($order['agreement_type']) {
$ss_sale = \Model_Sssale::find_by_pk($order['agreement_type']);
if ($ss_sale) {
$sale_name = $ss_sale->sale_name;
if ($ss_sale->sale_name == null) {
$sale_name = isset(\Constants::$sale_type[$ss_sale->sale_type]) ? \Constants::$sale_type[$ss_sale->sale_type] : '';
}
}
}
$csv_data[$order['order_id']][] = array($order['order_id'], $data_ss['group_info_name'], $data_ss['ss_partner_name'], $data_ss['ss_info_ss_name'], $data_ss['department_name'], $data_ss['department_id'], $data_ss['user_info_name'], isset($sale_name) ? $sale_name : '', $order['request_date'] != null ? date('Y/m/d', strtotime($order['request_date'])) : '', $order['post_date'] != null ? date('Y/m/d', strtotime($order['post_date'])) : '', isset($type) ? $type : '', isset($budget_type) ? $budget_type : '', isset($classification) ? $classification : '', isset($is_web_reprint) ? $is_web_reprint : '', isset($media->m_media_id) ? $media->m_media_id : '', 'media_name' => isset($media_name) ? $media_name : '', isset($media->media_version_name) ? $media->media_version_name : '', isset($post->name) ? $post->name : '', isset($partner->branch_name) ? $partner->branch_name : '', 'price' => $stt == 0 ? $price_blance : $price_int, isset($post_price) ? $post_price : 0, $order['notes']);
//if ss_list
if ($order['ss_list']) {
$order_ss_list = trim($order['ss_list'], ',');
$ss_list = explode(',', $order_ss_list);
foreach ($ss_list as $ss_key => $ss_item_id) {
$data_ss_id = $this->get_ss_info($ss_item_id);
$csv_data[$order['order_id']][] = array($order['order_id'], $data_ss_id['group_info_name'], $data_ss_id['ss_partner_name'], $data_ss_id['ss_info_ss_name'], $data_ss_id['department_name'], $data_ss_id['department_id'], $data_ss_id['user_info_name'], isset($sale_name) ? $sale_name : '', $order['request_date'] != null ? date('Y/m/d', strtotime($order['request_date'])) : '', $order['post_date'] != null ? date('Y/m/d', strtotime($order['post_date'])) : '', isset($type) ? $type : '', isset($budget_type) ? $budget_type : '', isset($classification) ? $classification : '', isset($is_web_reprint) ? $is_web_reprint : '', isset($media->m_media_id) ? $media->m_media_id : '', 'media_name' => isset($media_name) ? $media_name : '', isset($media->media_version_name) ? $media->media_version_name : '', isset($post->name) ? $post->name : '', isset($partner->branch_name) ? $partner->branch_name : '', 'price' => isset($price_int) ? $price_int : '', isset($post_price) ? $post_price : 0, $order['notes']);
}
}
if (isset($media->is_web_reprint) && $media->is_web_reprint == 1) {
foreach ($csv_data as $key => $val) {
foreach ($val as $k => $v) {
$v['media_name'] = $v['media_name'] . '(WEB転載)';
$csv_data[$key][] = $v;
}
}
foreach ($csv_data as $key => $val) {
$blance_2 = count($val) / 2;
$csv_data[$key][$blance_2]['price'] = $price_int;
}
}
$csv_all_data[$order['order_id']] = $csv_data;
$stt++;
}
return $csv_all_data;
}
public function action_post_list()
{
if (!\Input::method() == 'POST') {
return false;
}
$media_id = \Input::post('media_id');
$model_post = new Model_Mpost();
$data['list_post'] = $model_post->get_list_by_media($media_id);
$content_type = array('Content-type' => 'application/json', 'SUCCESS' => 0);
echo new \Response(json_encode($data), 200, $content_type);
}
