/**
* @author Bui Dang <*****@*****.**>
* action load ss list - ajax
*/
public function action_ss_list()
{
$data = array();
$partner_id = Input::post('partner_id');
$addr1 = Input::post('addr1', null);
$flag = Input::post('flag', null);
$mss = new \Model_Mss();
if ($addr1 && $partner_id == null) {
$model_partner = new \Model_Mpartner();
$config = array('addr1' => $addr1, 'type' => 1);
$list_partner = $model_partner->get_filter_partner($config);
$list_partner_code = array();
if ($list_partner) {
foreach ($list_partner as $partner) {
$list_partner_code[] = $partner['partner_code'];
}
}
if ($list_partner_code) {
$data['list_ss'] = $mss->get_all_ss_by_list_partner_code($list_partner_code);
}
} else {
$data['list_ss'] = $mss->get_ss_partner($partner_id);
if ($flag && $partner_id == null) {
$data['list_ss'] = $mss->get_ss_partner($partner_id, true);
}
}
return json_encode($data);
}
/**
* @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 <*****@*****.**>
* action list ss
*/
public function action_index()
{
$filters = Input::get();
$query_string = empty($filters) ? '' : '?' . http_build_query($filters);
Session::set('sslist_url', Uri::base() . 'master/sslist' . $query_string);
$m_ss = new \Model_Mss();
$data = array();
$data['count_ss'] = $m_ss->count_data($filters);
$pagination = \Uospagination::forge('pagination', array('pagination_url' => Uri::base() . 'master/sslist' . $query_string, 'total_items' => $data['count_ss'], '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['ss'] = $m_ss->get_data($filters);
$data['addr1'] = \Constants::get_search_address();
$data['filters'] = $filters;
$data['pagination'] = $pagination;
$this->template->title = 'UOS求人システム';
$this->template->content = View::forge('sslist', $data);
}
/**
* get all data ss
* @return array
*/
private function _get_data_ss()
{
$result = array();
$list = \Model_Mss::find_all();
foreach ($list as $ss) {
$result[$ss['ss_id']]['partner_code'] = $ss['partner_code'];
$result[$ss['ss_id']]['ss_name'] = $ss['ss_name'];
}
return $result;
}
/**
* Start append ss list
*
* @author Ha Huu Don<*****@*****.**>
* @date 16/09/2015
*/
public function view()
{
$model_group = new \Model_Mgroups();
$model_ss = new Model_Mss();
$model_partner = new \Model_Mpartner();
$data['listgroup1'] = array();
$list_partner1 = $model_partner->get_list_by_type();
if ($list_partner1) {
$data['listgroup1'] = $model_group->get_list_by_partner($list_partner1);
}
$data['listss'] = array();
$data['listpartner'] = array();
$ss_id = $this->ss_id;
$data['ss_id_selected'] = 0;
$data['partner_code_selected'] = 0;
$data['group_id_selected'] = 0;
$partner_code = 0;
$group_id = 0;
if ($ss_id) {
$ss_info = $model_ss->find_by_pk($ss_id);
if ($ss_info) {
$partner_code = $ss_info['partner_code'];
}
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, 1);
}
$config['where'] = array('partner_code' => $partner_code);
$data['listss'] = $model_ss->find($config);
}
}
$data['stt_selected'] = $this->stt;
$data['ss_id_selected'] = $ss_id;
$data['partner_code_selected'] = $partner_code;
$data['group_id_selected'] = $group_id;
$this->data = $data;
}
public function action_ssinfo()
{
if (\Input::method() != 'POST') {
return false;
}
$ss_id = \Input::post('ss_id');
$data['ssinfo'] = \Model_Mss::get_ss_info($ss_id);
$data['addr1'] = null;
if ($data['ssinfo']) {
$addr1 = $data['ssinfo'][0]['addr1'];
$data['addr1'] = isset(\Constants::$address_1[$addr1]) ? \Constants::$address_1[$addr1] : null;
}
$content_type = array('Content-type' => 'application/json', 'SUCCESS' => 0);
echo new \Response(json_encode($data), 200, $content_type);
return false;
}
/**
* @author Thuanth6589 <*****@*****.**>
* list, create, update sssale
*/
public function action_index()
{
$data = array();
$sssale = new \Model_Sssale();
$data['ss_id'] = Input::get('ss_id', null);
$ss_name = Input::get('ss_name');
$data['ss_name'] = Input::get('ss_name') ? urldecode($ss_name) : null;
if (!isset($data['ss_id']) || !isset($data['ss_name']) || !\Model_Mss::find_by_pk($data['ss_id'])) {
Session::set_flash('error', '売上形態は存在しません');
return Response::redirect('/master/sslist');
}
Session::set('sssale_url', Uri::current() . '?ss_id=' . $data['ss_id'] . '&ss_name=' . $ss_name);
if (Input::method() == 'POST') {
$sssale_id = Input::post('sssale_id', null);
if ($sssale_id and !\Model_Sssale::find_by_pk($sssale_id)) {
Session::set_flash('error', '売上形態は存在しません');
return Response::redirect(Session::get('sssale_url'));
}
$fields = $sssale->set_data(Input::post());
$check = true;
$message = \Constants::$message_create_error;
if (!$sssale->check_data_null($fields)) {
$check = false;
$message = '入力内容がありません。';
}
if ($check == true && $sssale->save_data($fields)) {
Session::set_flash('success', \Constants::$message_create_success);
return Response::redirect(Session::get('sssale_url'));
}
if (!isset($sssale_id)) {
$data['action'] = 'add';
}
Session::set_flash('error-' . Input::post('panel_index'), $message);
}
$data['sale_type'] = \Constants::$sale_type;
$data['hours'] = \Constants::$hours;
$data['minutes'] = \Constants::$minutes;
$data['sssales'] = $sssale->get_data($data['ss_id']);
$this->template->title = 'UOS求人システム';
$this->template->content = View::forge('sssale', $data);
}
/**
* @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;
}
}
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;
}
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 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;
}
/*Select SS*/
if (isset($customdata) and $edit_ss_id = isset($customdata['edit_ss_id']) ? $customdata['edit_ss_id'] : array()) {
$arr_sss = array_column($edit_ss_id, 'ss_name', 'ss_id');
$arr_sss = $default_ss + $arr_sss;
}
?>
<p></p>
<?php
echo Form::select('ss_id', isset($customdata['ss_id']) ? $customdata['ss_id'] : '', $arr_sss, array('class' => 'form-control'));
?>
<?php
if ($is_diff_ss && isset($customdata['label_ss_id'])) {
?>
<span class="edit-before edit-before-ss">
<?php
echo Model_Mss::find_by_pk($customdata['label_ss_id'])->ss_name;
?>
</span>
<?php
}
}
if ($step >= 4) {
/*Select SSsale*/
if (isset($customdata) and $edit_ss_sale = isset($customdata['edit_ss_sale']) ? $customdata['edit_ss_sale'] : array()) {
$arr_ss_sale = array();
foreach ($edit_ss_sale as $ss_sale) {
if (isset($ss_sale['sale_type']) and $ss_sale['sale_type']) {
$sale_type = $ss_sale['sale_type'];
} else {
$sale_type = '';
}
?>
</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>
/**
* @author Thuanth6589 <*****@*****.**>
* @param array $data
* @return bool
* @throws \Exception
*/
public function save_data()
{
$data = $this->fields;
if (empty($data)) {
return false;
}
$data['updated_at'] = date('Y-m-d H:i:s', time());
if (!isset($data['ss_id'])) {
$data['created_at'] = date('Y-m-d H:i:s', time());
$data['is_available'] = 0;
$ss = Model_Mss::forge();
} else {
$ss = Model_Mss::find_by_pk($data['ss_id']);
if (!isset($ss)) {
return false;
}
$ss->is_new(false);
}
$ss->set($data);
if ($ss->save()) {
return true;
}
return false;
}
public function action_get_m_ss_access()
{
$ss_id = \Fuel\Core\Input::post('ss_id');
$model_ss = new \Model_Mss();
$info_ss = $model_ss->get_ss_info($ss_id);
return new \Response($info_ss['0']['access'], 200, array());
}
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 : '');
}
/**
* @author Thuanth6589 <*****@*****.**>
* action delete ss
*/
public function action_delete()
{
if (Input::method() == 'POST') {
$ss_id = Input::post('ss_id', null);
$result = 'error';
if (!\Model_Mss::find_by_pk($ss_id)) {
$message = 'SSは存在しません';
} else {
$message = \Constants::$message_delete_error;
if (\Model_Uss::delete_ss($ss_id)) {
$result = 'success';
$message = \Constants::$message_delete_success;
}
}
Session::set_flash($result, $message);
}
$url = Session::get('sslist_url') ? Session::get('sslist_url') : Uri::base() . 'master/sslist';
return Response::redirect($url);
}
public function get_list_ss_by_department($list_ss)
{
$list_all_ss = array();
if ($list_ss) {
$config['where'][] = array('ss_id', 'in', $list_ss);
$list_all_ss = \Model_Mss::find($config) ? \Model_Mss::find($config) : array();
}
$list_partner_code = array();
foreach ($list_all_ss as $ss_item) {
$list_partner_code[] = $ss_item->partner_code;
}
$list_all_ss_id = array();
if ($list_partner_code) {
$config_partner['where'][] = array('partner_code', 'in', $list_partner_code);
$list_all_ss_temp = \Model_Mss::find($config_partner);
foreach ($list_all_ss_temp as $temp) {
$list_all_ss_id[] = $temp->ss_id;
}
}
return $list_all_ss_id;
}
<div class="row">
<div class="col-md-2">
<label class="control-label">都道府県</label>
</div>
<div class="col-md-4">
<?php
echo Form::select('address_1', \Fuel\Core\Input::get('address_1'), Constants::$address_1, array('class' => 'form-control', 'style' => 'width:132px'));
?>
</div>
<div class="col-md-2">
<label class="control-label">市区町村</label>
</div>
<div class="col-md-4">
<?php
//get list ss
$model_ss = new \Model_Mss();
$listss = $model_ss->get_list_all_ss();
$addr_2 = array('' => '全て') + array_column($listss, 'addr2', 'addr2');
echo \Fuel\Core\Form::select('address_2', \Fuel\Core\Input::get('address_2'), $addr_2, array('class' => 'form-control', 'style' => 'width:132px'));
?>
</div>
</div>
<div class="row">
<div class="col-md-2">
<label class="control-label">取引先担当部門</label>
</div>
<div class="col-md-4">
<?php
echo \Fuel\Core\Form::select('department_id', Fuel\Core\Input::get('department_id'), Constants::get_search_department(), array('class' => 'form-control'));
?>
</div>
