/**
* @author Thuanth6589 <*****@*****.**>
* action delete ss
* @param null $ss_id
* @return bool
*/
public static function delete_ss($ss_id = null)
{
if (!isset($ss_id)) {
return false;
}
$ss = Model_Mss::find_by_pk($ss_id);
if (!isset($ss)) {
return false;
}
try {
\Fuel\Core\DB::start_transaction();
$sssale = new Model_Sssale();
$delete = $sssale->delete_by_ss($ss_id);
if (!isset($delete)) {
return false;
}
if (!$ss->delete()) {
\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 <*****@*****.**>
* delete sssale
*/
public function action_delete()
{
if (Input::method() == 'POST') {
$sssale_id = Input::post('sssale_id');
$result = 'error-' . Input::post('panel_index');
$message = \Constants::$message_delete_error;
if (isset($sssale_id) && ($sssale = \Model_Sssale::find_by_pk($sssale_id))) {
if ($sssale->delete_data()) {
$result = 'success';
$message = \Constants::$message_delete_success;
}
}
Session::set_flash($result, $message);
}
$url = Session::get('sssale_url') ? Session::get('sssale_url') : Uri::base() . 'master/sslist';
return Response::redirect($url);
}
?>
</div>
<div>
<?php
if (isset($person->mobile) and $person->mobile != null) {
echo '(固定)' . $person->mobile;
}
?>
</div>
</td>
</tr>
<tr>
<th class="text-right">対象SS</th>
<td colspan="3">
<?php
if (isset($person->sssale_id)) {
$ss_id = Model_Sssale::find_by_pk($person->sssale_id)->ss_id;
$partner_code = Model_Mss::find_by_pk($ss_id)->partner_code;
$m_group_id = Model_Mpartner::find_by_pk($partner_code)->m_group_id;
$group_name = Model_Mgroups::find_by_pk($m_group_id)->name;
$partner_name = Model_Mpartner::find_by_pk($partner_code)->branch_name;
$ss_name = Model_Mss::find_by_pk($ss_id)->ss_name;
$sssale_name = Model_Sssale::find_by_pk($person->sssale_id)->sale_name;
echo $group_name . $partner_name . $ss_name . $sssale_name;
}
?>
</td>
</tr>
</table>
</div>
</div>
public function get_division_3()
{
$data = array('sssale_list' => array(), 'person_list' => array(), 'employment_list' => array());
$user_info = \Fuel\Core\Session::get('login_info');
$order_obj = new Model_Orders();
$partner_obj = new Model_Mpartner();
$mss_obj = new Model_Mss();
$person_obj = new Model_Person();
$employment_obj = new Model_Employment();
$sssale_obj = new Model_Sssale();
$list_order_id = array();
$list_sssale_id = array();
$order_list = $order_obj->get_list_oders_login($user_info['user_id']);
/*where 1*/
if (count($order_list)) {
foreach ($order_list as $row) {
$list_order_id[] = $row['order_id'];
}
}
/*where 2*/
$list_partner_code = array();
$list_ss_id = array();
$partner_list = $partner_obj->get_list_partner_login($user_info['user_id']);
if (count($partner_list)) {
foreach ($partner_list as $row) {
$list_partner_code[] = $row['partner_code'];
}
}
if (count($list_partner_code)) {
$mss_list = $mss_obj->get_all_ss_by_list_partner_code($list_partner_code);
$mss_list_id = '';
$sssale_array = array();
if (count($mss_list)) {
foreach ($mss_list as $row) {
$mss_list_id .= $row['ss_id'] . ',';
$ss_array_list[$row['ss_id']] = $row['ss_name'];
}
$sssale_list = $sssale_obj->get_list_sssale('ss_id IN (' . trim($mss_list_id, ',') . ')');
foreach ($sssale_list as $row) {
$list_sssale_id[] = $row['sssale_id'];
}
}
}
$person_list = $person_obj->get_person_division_3($list_sssale_id, $list_order_id);
$list_person_id = array();
if (count($person_list)) {
$list_sssale_id = array();
foreach ($person_list as $row) {
$list_person_id[] = $row['person_id'];
$list_sssale_id[] = (int) $row['sssale_id'];
}
$list_employment = $employment_obj->get_list_data($list_person_id);
$list_sssale_of_person = $sssale_obj->get_list_sssale('sssale_id IN (' . implode(',', $list_sssale_id) . ')');
$list_employment_array = array();
$list_sssale = array();
foreach ($list_employment as $row) {
$list_employment_array[$row['person_id']] = $row;
}
$list_ss_id = array();
$list_sssale_of_ss = array();
foreach ($list_sssale_of_person as $row) {
$list_ss_id[] = (int) $row['ss_id'];
$list_sssale_of_ss[$row['sssale_id']] = (int) $row['ss_id'];
}
$list_ss_of_person = $mss_obj->get_list_ss('ss_id IN (' . implode(',', $list_ss_id) . ')');
$list_ss_name = array();
foreach ($list_ss_of_person as $row) {
$list_ss_name[$row['ss_id']] = $row['ss_name'];
}
$list_person_ss_name = array();
foreach ($list_sssale_of_ss as $sssale_id => $ss_id) {
$list_person_ss_name[$sssale_id] = $list_ss_name[$ss_id];
}
$data['person_list'] = $person_list;
$data['sssale_list'] = $list_person_ss_name;
$data['employment_list'] = $list_employment_array;
}
return $data;
}
/**
* create data order
* @param $filters
* @param $orders
* @param $all_ss
* @param $all_partner
* @param $all_group
* @param $all_user
* @param $all_sssale
* @param $all_post
* @param $all_media
* @return array
*/
private function _create_data_order($filters, $orders, $all_ss, $all_partner, $all_group, $all_user, $all_sssale, $all_post, $all_media)
{
$data = array();
foreach ($orders as $order) {
$double = 1;
$count_ss_list = trim($order['ss_list'], ',') != '' ? count(explode(',', trim($order['ss_list'], ','))) : 0;
$price = 0;
$residuals = 0;
if ($order['post_id'] != '' && isset($all_post[$order['post_id']])) {
if ($all_media[$all_post[$order['post_id']]['m_media_id']]['is_web_reprint'] == 1) {
$double = 2;
}
$post_price = $all_post[$order['post_id']]['price'] == '' ? 0 : $all_post[$order['post_id']]['price'];
$price = (int) ($post_price / ((1 + $count_ss_list) * $double));
$residuals = $post_price % ((1 + $count_ss_list) * $double);
}
$arr_ss = $count_ss_list > 0 ? array_merge(array($order['ss_id']), explode(',', trim($order['ss_list'], ','))) : array($order['ss_id']);
$arr_ss = $double == 2 ? array_merge($arr_ss, $arr_ss) : $arr_ss;
foreach ($arr_ss as $k => $v) {
$filters['ss_id'] = $v;
$list_sssale = \Model_Sssale::find_by('ss_id', $v, '=');
$filters['sssale_id'] = array();
if (isset($list_sssale)) {
foreach ($list_sssale as $value) {
$filters['sssale_id'][] = $value['sssale_id'];
}
}
if ($k > $count_ss_list) {
$filters['reprinted_via'] = 1;
}
$filters['main'] = 0;
if ($v == $arr_ss[0]) {
$filters['main'] = 1;
}
$tmp[0] = 'オーダー';
$tmp[1] = $order['order_id'];
$tmp[2] = trim($order['ss_list'], ',') != '' ? count(explode(',', trim($order['ss_list'], ','))) : 0;
$tmp[3] = $k > $count_ss_list ? $this->m_person->count_data(array('array_person' => $this->_array_person($filters), 'reprinted_via' => 1)) ? '○' : '' : '';
$tmp[4] = '';
$group_name = '';
$branch_name = '';
$ss_name = '';
if (isset($all_ss[$v])) {
$group_name = $all_group[$all_partner[$all_ss[$v]['partner_code']]['m_group_id']]['name'];
$branch_name = $all_partner[$all_ss[$v]['partner_code']]['branch_name'];
$ss_name = $all_ss[$v]['ss_name'];
}
$tmp[5] = $group_name;
$tmp[6] = $branch_name;
$tmp[7] = $ss_name;
$department_text = '';
$department_id = '';
$username = '';
if (isset($all_ss[$v]) && $all_partner[$all_ss[$v]['partner_code']]['user_id'] != '') {
if (isset(\Constants::$department[$all_partner[$all_ss[$v]['partner_code']]['department_id']])) {
$department_text = \Constants::$department[$all_partner[$all_ss[$v]['partner_code']]['department_id']];
$department_id = $all_partner[$all_ss[$v]['partner_code']]['department_id'];
}
if (isset($all_user[$all_partner[$all_ss[$v]['partner_code']]['user_id']])) {
$username = $all_user[$all_partner[$all_ss[$v]['partner_code']]['user_id']]['name'];
}
}
$tmp[8] = $department_text;
$tmp[9] = $department_id;
$tmp[10] = $username;
$tmp[11] = isset($all_user[$order['interview_user_id']]['name']) ? $all_user[$order['interview_user_id']]['name'] : '';
$tmp[12] = $order['agreement_type'] != '' ? isset($all_sssale[$order['agreement_type']]) ? \Constants::$sale_type[$all_sssale[$order['agreement_type']]['sale_type']] : '' : '';
$tmp[13] = $order['apply_date'];
$tmp[14] = $order['post_date'];
$media_type_text = '';
$media_budget_type_text = '';
$media_classification_text = '';
$is_web_reprint_text = '';
$media_id = '';
$media_name = '';
$media_version_name = '';
$post_name = '';
$branch_name = '';
$web_post = $k > $count_ss_list ? 'WEB転載' : '';
if ($order['post_id'] != '' && isset($all_post[$order['post_id']])) {
$media_type_text = \Constants::$media_type[$all_media[$all_post[$order['post_id']]['m_media_id']]['type']];
$media_budget_type_text = \Constants::$media_budget_type[$all_media[$all_post[$order['post_id']]['m_media_id']]['budget_type']];
$media_classification_text = \Constants::$media_classification[$all_media[$all_post[$order['post_id']]['m_media_id']]['classification']];
$is_web_reprint_text = \Constants::$is_web_reprint[$all_media[$all_post[$order['post_id']]['m_media_id']]['is_web_reprint']];
$media_id = $all_post[$order['post_id']]['m_media_id'];
$media_name = $all_media[$all_post[$order['post_id']]['m_media_id']]['media_name'] . $web_post;
$media_version_name = $all_media[$all_post[$order['post_id']]['m_media_id']]['media_version_name'];
$post_name = $all_post[$order['post_id']]['name'];
$branch_name = $all_partner[$all_media[$all_post[$order['post_id']]['m_media_id']]['partner_code']]['branch_name'];
}
$tmp[15] = $media_type_text;
$tmp[16] = $media_budget_type_text;
$tmp[17] = $media_classification_text;
$tmp[18] = $is_web_reprint_text;
$tmp[19] = $media_id;
$tmp[20] = $media_name;
$tmp[21] = $media_version_name;
$tmp[22] = $post_name;
$tmp[23] = $branch_name;
$tmp[24] = $k == 0 ? $price + $residuals : $price;
$tmp[25] = $order['post_id'] != '' ? $k == 0 && isset($all_post[$order['post_id']]) ? $all_post[$order['post_id']]['price'] : '' : '';
$filters['person_id'] = $this->_array_person($filters);
$tmp[26] = count($filters['person_id']);
unset($filters['ss_id']);
unset($filters['sssale_id']);
$count_person = $this->_count_person($filters, $this->type[0]);
$tmp[27] = $count_person['count_review_result_0'];
$tmp[28] = $count_person['count_contact_result_2'];
$tmp[29] = $count_person['count_review_result_3'];
$tmp[30] = $count_person['count_review_result_2'];
$tmp[31] = $count_person['count_review_result_5'];
$tmp[32] = $count_person['count_review_result_4'];
$tmp[33] = $count_person['count_review_result_6'];
$tmp[34] = $count_person['count_review_result_7'];
$tmp[35] = $count_person['count_review_result_8'];
$tmp[36] = $count_person['count_review_result_9'];
$tmp[37] = $count_person['count_review_result_10'];
$tmp[38] = $count_person['count_review_result_11'];
$tmp[39] = $count_person['count_review_result_12'];
$tmp[40] = $count_person['count_review_result_13'];
$tmp[41] = $count_person['count_adoption_result_1'];
$tmp[42] = $count_person['count_adoption_result_2'];
$tmp[43] = $count_person['count_adoption_result_3'];
$data[] = $tmp;
}
}
return $data;
}
public function get_default_business_user_id($sssale_id)
{
$business_user_id = 0;
$sssale_obj = new \Model_Sssale();
$ss_obj = new \Model_Mss();
$partner_obj = new \Model_Mpartner();
$sssale_info = $sssale_obj->get_sssale_info($sssale_id);
$ss_id = $sssale_info['ss_id'];
$ss_info = current($ss_obj->get_ss_info($ss_id));
$partner_code = $ss_info['partner_code'];
if ($partner_code) {
$partner_info = $partner_obj->get_list_partner('partner_code ="' . $partner_code . '"');
$partner_info = $partner_info->as_array();
$partner_info = current($partner_info);
$business_user_id = $partner_info['user_id'];
}
return $business_user_id;
}
public function action_index()
{
$data = array();
$ujob_obj = new \Model_Ujob();
$job_id = \Fuel\Core\Input::get('job_id', '');
$copy_job_id = \Fuel\Core\Input::get('copy_job_id', '');
$job_id_get_data = $copy_job_id ? $copy_job_id : $job_id;
$data_default = $ujob_obj->get_info_job($job_id_get_data);
if ($data_default['job_id'] == null && $job_id) {
\Fuel\Core\Response::redirect(\Fuel\Core\Uri::base() . 'job/job');
}
if ($copy_job_id) {
$data_default['edit_data'] = null;
}
$data = $data_default;
$data['old_data'] = $data_default;
$data['old_data']['job_add'] = array();
$data['old_data']['job_recruit'] = array();
$data['old_data']['m_image'] = array();
$data['job_add'] = array();
$data['job_recruit'] = array();
$data['m_image'] = array();
$label = array('group' => 'グループ', 'partner' => '取引先(受注先)', 'ss' => 'SS', 'sslist' => '売上形態');
$data_filter['field'] = array('step' => 4, 'type' => 1, 'label' => $label);
if (\Fuel\Core\Input::method() == 'POST') {
$data_post = \Fuel\Core\Input::post();
if (!isset($data_post['employment_mark'])) {
$data_post['employment_mark'] = array();
}
if (!isset($data_post['work_time_view'])) {
$data_post['work_time_view'] = array();
}
if (!isset($data_post['trouble'])) {
$data_post['trouble'] = array();
}
$check = true;
if (!\Model_Sssale::find_by_pk($data_post['sssale_id'])) {
\Fuel\Core\Session::set_flash('report', '売上形態は存在しません');
$check = false;
}
foreach ($data_post['media_list'] as $k => $v) {
if ($v == '') {
unset($data_post['media_list'][$k]);
continue;
}
if (!\Model_Mmedia::find_by_pk($v)) {
\Fuel\Core\Session::set_flash('report', '媒体は存在しません');
$check = false;
break;
}
}
if ($check) {
$this->save($ujob_obj, $job_id, $data_post);
}
}
if ($data_default['edit_data']) {
$data = json_decode($data_default['edit_data'], true);
$data_default_edit = $ujob_obj->get_info_job('');
$data = $data + $data_default_edit;
$data = \Utility::set_standard_data_job($data, false);
$ujob_obj->convert_job_add_recruit($data);
$data['m_image'] = $ujob_obj->get_list_m_image($data['image_list']);
/*Get old data*/
$data['old_data'] = $data_default;
$data['old_data']['job_add'] = $ujob_obj->get_list_job_add($job_id);
$data['old_data']['job_recruit'] = $ujob_obj->get_list_job_recruit($job_id);
$data['old_data']['m_image'] = $ujob_obj->get_list_m_image($data['old_data']['image_list']);
} else {
if ($job_id_get_data) {
$data['job_add'] = $ujob_obj->get_list_job_add($job_id_get_data);
$data['job_recruit'] = $ujob_obj->get_list_job_recruit($job_id_get_data);
$data['m_image'] = $ujob_obj->get_list_m_image($data['image_list']);
$data['old_data']['job_add'] = $data['job_add'];
$data['old_data']['job_recruit'] = $data['job_recruit'];
$data['old_data']['m_image'] = $data['m_image'];
}
}
$data['is_show_old'] = array();
if ($job_id) {
$data['is_show_old'] = $this->_compare_other_data_json($data['old_data'], $data_default['edit_data']);
}
$data_filter['datafilter'] = \Presenter_Group_Filter::edit($data_filter['field']['step'], $data_filter['field']['type'], $data['sssale_id'], $data['old_data']['sssale_id']);
$data['interview_des'] = '面接は勤務地または近隣にて行います。';
$data['apply_method'] = '下記のフリーダイヤルまたは「応募する」ボタンより、応募シートに必要事項を入力の上、送信して下さい。※応募書類は返却致しません。ご了承ください。';
$data['apply_process'] = '追って、こちらからご連絡差し上げます。※ご連絡は平日に致します。★ネット応募は24ｈ受付中!!';
$this->template->title = 'UOS求人システム';
$this->template->content = \Fuel\Core\View::forge('job/index', $data);
$this->template->content->filtergroup = \Presenter::forge('group/filter')->set('custom', $data_filter);
}
public function action_worktype()
{
if (\Input::method() != 'POST') {
return false;
}
$sssale_id = \Input::post('sssale_id');
$work_type = trim(\Input::post('work_type'), ',');
$agreement_type = trim(\Input::post('agreement_type'));
$status = \Input::post('status');
$action = \Input::post('action');
$work_active = array();
if ($work_type != null) {
$work_active = explode(',', $work_type);
}
$model = new \Model_Sssale();
$sssale_info = $model->get_sssale_info($sssale_id);
if ($sssale_info && $agreement_type) {
echo '<div class="row">
<div class="col-md-3">
<label class="checkbox-inline"><input name="work_type[]" value="1" type="checkbox" ';
if (($status == 2 || $status == 3) && $action != 'copy') {
echo 'disabled ';
}
if ($agreement_type == $sssale_id && in_array(1, $work_active)) {
echo 'checked';
}
echo '>時間フリー</label>
</div>
<div class="col-md-3">';
if ($sssale_info['free_hourly_wage']) {
echo number_format($sssale_info['free_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['free_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['free_start_time'], $sssale_info['free_end_time']) . '<input type="text" name="worktype" size="5" style="width:1px;border:none" readonly="readonly" /></div>
</div>
<div class="row">
<div class="col-md-3">
<label class="checkbox-inline"><input name="work_type[]" value="2" type="checkbox" ';
if (($status == 2 || $status == 3) && $action != 'copy') {
echo 'disabled ';
}
if ($agreement_type == $sssale_id && in_array(2, $work_active)) {
echo 'checked';
}
echo '>時間制約</label>
</div>
<div class="col-md-3">';
if ($sssale_info['constraint_hourly_wage']) {
echo number_format($sssale_info['constraint_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['constraint_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['constraint_start_time'], $sssale_info['constraint_end_time']) . '</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="checkbox-inline"><input name="work_type[]" value="3" type="checkbox" ';
if (($status == 2 || $status == 3) && $action != 'copy') {
echo 'disabled ';
}
if ($agreement_type == $sssale_id && in_array(3, $work_active)) {
echo 'checked';
}
echo '>年少者・高校生</label>
</div>
<div class="col-md-3">';
if ($sssale_info['minor_hourly_wage']) {
echo number_format($sssale_info['minor_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['minor_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['minor_start_time'], $sssale_info['minor_end_time']) . '</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="checkbox-inline"><input name="work_type[]" value="4" type="checkbox" ';
if (($status == 2 || $status == 3) && $action != 'copy') {
echo 'disabled ';
}
if ($agreement_type == $sssale_id && in_array(4, $work_active)) {
echo 'checked';
}
echo '>夜勤</label>
</div>
<div class="col-md-3">';
if ($sssale_info['night_hourly_wage']) {
echo number_format($sssale_info['night_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['night_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['night_start_time'], $sssale_info['night_end_time']) . '</div>
</div>';
}
return false;
}
public function action_worktype()
{
if (\Input::method() != 'POST') {
echo '';
die;
}
$sssale_id = \Input::post('sssale_id');
$model = new \Model_Sssale();
$sssale_info = $model->get_sssale_info($sssale_id);
if ($sssale_info) {
echo '<div class="row">
<div class="col-md-3">
<label class="checkbox-inline">時間フリー</label>
</div>
<div class="col-md-3">';
if ($sssale_info['free_hourly_wage']) {
echo number_format($sssale_info['free_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['free_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['free_start_time'], $sssale_info['free_end_time']) . '</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="checkbox-inline">時間制約</label>
</div>
<div class="col-md-3">';
if ($sssale_info['constraint_hourly_wage']) {
echo number_format($sssale_info['constraint_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['constraint_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['constraint_start_time'], $sssale_info['constraint_end_time']) . '</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="checkbox-inline">年少者・高校生</label>
</div>
<div class="col-md-3">';
if ($sssale_info['minor_hourly_wage']) {
echo number_format($sssale_info['minor_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['minor_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['minor_start_time'], $sssale_info['minor_end_time']) . '</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="checkbox-inline">夜勤</label>
</div>
<div class="col-md-3">';
if ($sssale_info['night_hourly_wage']) {
echo number_format($sssale_info['night_hourly_wage']) . '円';
}
echo '</div>
<div class="col-md-3">' . $sssale_info['night_recruit_attr'] . '</div>
<div class="col-md-3">' . \Utility::sssale_start_end_time($sssale_info['night_start_time'], $sssale_info['night_end_time']) . '</div>
</div>';
}
echo '';
die;
}
/**
* @author Bui Dang <*****@*****.**>
* @params: send data edit presenter
*/
public static function edit($step = null, $type = null, $id = null, $id_label = null)
{
$p_partner = new \Model_Mpartner();
$p_mss = new \Model_Mss();
$p_sssale_id = new \Model_Sssale();
if ($order_id = \Fuel\Core\Input::get('order_id') and \Fuel\Core\Uri::current() == \Fuel\Core\Uri::base() . 'job/person') {
$sssale_id_order = Model_Orders::find_by_pk($order_id)->agreement_type;
if (!isset($order_id) or $order_id != 0) {
$ss_id_order = Model_Orders::find_by_pk($order_id)->ss_id;
}
}
switch ($step) {
case 2:
$label_arr_id = array();
$arr_id = array();
$arr_edit = array();
$partner_code = $id;
$label_partner_code = $id_label;
if (isset($id_label)) {
$label_group_id = Model_Mpartner::find_by_pk($label_partner_code)->m_group_id;
$label_arr_id = array('label_m_group_id' => $label_group_id, 'label_partner_code' => $label_partner_code);
}
if ($m_partner = \Model_Mpartner::find_by_pk($partner_code)) {
$group_id = $m_partner->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_id = array('m_group_id' => $group_id, 'partner_code' => $partner_code);
$arr_edit = array('edit_partner' => $arr_edit_partner);
}
return array_merge($arr_id, $arr_edit, $label_arr_id);
break;
case 3:
$label_arr_id = array();
$arr_id = array();
$arr_edit = array();
$label_ss_id = $id_label;
$ss_id = $id;
if (!isset($type) || $type == '') {
return false;
}
if (isset($id_label)) {
$label_partner_code = \Model_Mss::find_by_pk($label_ss_id)->partner_code;
$label_group_id = Model_Mpartner::find_by_pk($label_partner_code)->m_group_id;
$label_arr_id = array('label_ss_id' => $label_ss_id, 'label_m_group_id' => $label_group_id, 'label_partner_code' => $label_partner_code);
}
if ($m_ss = \Model_Mss::find_by_pk($ss_id) and $m_group = \Model_Mpartner::find_by_pk($m_ss->partner_code)) {
$partner_code = $m_ss->partner_code;
$group_id = $m_group->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_edit_ss_id = $p_mss->get_ss_partner($partner_code);
$arr_id = array('ss_id' => $ss_id, 'partner_code' => $partner_code, 'm_group_id' => $group_id);
$arr_edit = array('edit_partner' => $arr_edit_partner, 'edit_ss_id' => $arr_edit_ss_id);
}
return array_merge($label_arr_id, $arr_id, $arr_edit);
break;
case 4:
$label_arr_id = array();
$arr_id = array();
$arr_edit = array();
$sssale_id = $id;
if (!isset($sssale_id) and isset($sssale_id_order) and $sssale_id_order != 0) {
$sssale_id = $sssale_id_order;
}
$label_sssale_id = $id_label;
if (!isset($type) || $type == '') {
return false;
}
if (isset($id_label)) {
$label_ss_id = \Model_Sssale::find_by_pk($label_sssale_id)->ss_id;
$label_partner_code = \Model_Mss::find_by_pk($label_ss_id)->partner_code;
$label_group_id = Model_Mpartner::find_by_pk($label_partner_code)->m_group_id;
$label_arr_id = array('label_sssale_id' => $label_sssale_id, 'label_ss_id' => $label_ss_id, 'label_m_group_id' => $label_group_id, 'label_partner_code' => $label_partner_code);
}
if ($m_ss_sale = \Model_Sssale::find_by_pk($sssale_id) and $m_ss = \Model_Mss::find_by_pk($m_ss_sale->ss_id) and $m_partner = \Model_Mpartner::find_by_pk($m_ss->partner_code)) {
$ss_id = $m_ss_sale->ss_id;
$partner_code = $m_ss->partner_code;
$group_id = $m_partner->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_edit_ss_id = $p_mss->get_ss_partner($partner_code);
$arr_edit_ss_sale = $p_sssale_id->get_sssale_ss($ss_id);
$arr_id = array('sssale_id' => $sssale_id, 'ss_id' => $ss_id, 'partner_code' => $partner_code, 'm_group_id' => $group_id);
$arr_edit = array('edit_partner' => $arr_edit_partner, 'edit_ss_id' => $arr_edit_ss_id, 'edit_ss_sale' => $arr_edit_ss_sale);
} else {
if (isset($ss_id_order) and $m_ss = \Model_Mss::find_by_pk($ss_id_order) and $m_partner = \Model_Mpartner::find_by_pk($m_ss->partner_code)) {
$ss_id = $ss_id_order;
$partner_code = $m_ss->partner_code;
$group_id = $m_partner->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_edit_ss_id = $p_mss->get_ss_partner($partner_code);
$arr_edit_ss_sale = $p_sssale_id->get_sssale_ss($ss_id);
$arr_id = array('sssale_id' => $sssale_id, 'ss_id' => $ss_id, 'partner_code' => $partner_code, 'm_group_id' => $group_id);
$arr_edit = array('edit_partner' => $arr_edit_partner, 'edit_ss_id' => $arr_edit_ss_id, 'edit_ss_sale' => $arr_edit_ss_sale);
}
}
return array_merge($label_arr_id, $arr_id, $arr_edit);
break;
default:
return false;
break;
}
}
/**
* @author Thuanth6589 <*****@*****.**>
* create/update sssale
* @param array $data
* @return bool
* @throws Exception
*/
public function save_data($data = array())
{
if (empty($data)) {
return false;
}
$data['updated_at'] = date('Y-m-d H:i:s', time());
if (!isset($data['sssale_id'])) {
$data['created_at'] = date('Y-m-d H:i:s', time());
$sssale = Model_Sssale::forge();
} else {
$sssale = Model_Sssale::find_by_pk($data['sssale_id']);
}
if (!isset($sssale)) {
return false;
}
$sssale->set($data);
if ($sssale->save()) {
return true;
}
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 approve_data($id)
{
try {
$obj = static::forge()->find_by_pk($id);
$data = array();
if (count($obj)) {
$data_old = $obj->_data;
$data_job_add = array();
$data_job_rec = array();
if ($data_old['edit_data']) {
$data = json_decode($data_old['edit_data'], true);
if (!Model_Sssale::find_by_pk($data['sssale_id'])) {
return 0;
}
$data_job_add = Utility::set_data_job_add_recruit($data, $id);
$data_job_rec = Utility::set_data_job_add_recruit($data, $id, 'job_recruit_sub_title', 'job_recruit_text');
$data = Utility::set_standard_data_job($data, true, $this->_data_default);
} else {
$data['updated_at'] = date('Y-m-d H:i');
$data['status'] = 1;
$obj->set($data);
$obj->is_new(false);
return (bool) $obj->save();
}
DB::start_transaction();
$data['is_available'] = $data_old['is_available'];
$data['status'] = 1;
$data['edit_data'] = null;
$obj->set($data);
$obj->is_new(false);
$res = (bool) $obj->save();
if ($res) {
$obj_add = new Model_Jobadd();
$obj_rec = new Model_Jobrecruit();
$res_flag = false;
if ($obj_add->delete_data($id) >= 0) {
$res_flag = true;
}
if ($res_flag && $obj_add->insert_multi_data($data_job_add, $this) === false) {
$res_flag = false;
}
if ($res_flag && $obj_rec->delete_data($id) >= 0) {
$res_flag = true;
} else {
$res_flag = false;
}
if ($res_flag && $obj_rec->insert_multi_data($data_job_rec, $this) === false) {
$res_flag = false;
}
if ($res_flag) {
\DB::commit_transaction();
return true;
} else {
\DB::rollback_transaction();
return false;
}
}
return false;
}
return false;
} catch (Exception $e) {
\DB::rollback_transaction();
throw $e;
return false;
}
}
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;
}
$sale_type = '';
}
$arr_ss_sale[$ss_sale['sssale_id']] = Constants::$sale_type[$sale_type] . ' ' . $ss_sale['sale_name'];
}
$arr_ss_sale = $default_ss_sale + $arr_ss_sale;
}
?>
<?php
echo Form::select('sssale_id', isset($customdata['sssale_id']) ? $customdata['sssale_id'] : '', $arr_ss_sale, array('class' => 'form-control'));
?>
<?php
if ($is_diff_ss && isset($customdata['label_sssale_id'])) {
?>
<span class="edit-before edit-before-ss">
<?php
echo Constants::$sale_type[Model_Sssale::find_by_pk($customdata['label_sssale_id'])->sale_type] . ' ' . Model_Sssale::find_by_pk($customdata['label_sssale_id'])->sale_name;
?>
</span>
<?php
}
}
?>
</div>
<script type="text/javascript">
/*get type if type = 1 ss, type = 2 media*/
var type = <?php
echo $type;
?>
/*Custom label*/
var l_group = '<?php
/**
* @author Bui Dang <*****@*****.**>
* action load ss sale list - ajax
*/
public function action_ss_sale_list()
{
$data = array();
$ss_id = Input::post('ss_id');
$sssale = new Model_Sssale();
$data['list_ss_sale'] = $sssale->get_sssale_ss($ss_id);
return json_encode($data);
}
