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;
}
/**
* @author: Bui Cong Dang (dangbcd6591@seta-asia.com.vn)
* @params: Action edit and create partner
**/
public function action_index($id_partner = null)
{
$is_view = array();
$data = array();
$department_id = null;
if ($id_partner) {
$data['partner_code'] = $id_partner;
if (!($data_partner = \Model_Mpartner::find_by_pk($id_partner))) {
Session::set_flash('error', '取引先は存在しません');
Response::redirect('master/partners');
}
$data['edit_partner'] = $data_partner;
$data['partner'] = $data_partner;
if ($edit_data = $data_partner->edit_data) {
$data['partner'] = json_decode($edit_data);
//If exits edit_data, get edit_data
$is_view = \Utility::compare_json_data($data_partner, $edit_data);
}
}
if (Input::post()) {
$arr_partner_code = array();
$arr_partner = \Model_Mpartner::_set(Input::post());
$um_partner = new \Model_Umpartner();
if (isset($id_partner)) {
if ($is_save = $um_partner->edit_partner($id_partner, $arr_partner)) {
Session::set_flash('success', \Constants::$message_create_success);
Response::redirect('master/partners?' . Session::get('url_filter_partner'));
}
Session::set_flash('error', \Constants::$message_create_error);
} else {
if ($is_save = $um_partner->save_partner($arr_partner, $arr_partner_code)) {
Session::set_flash('success', \Constants::$message_create_success);
Response::redirect('master/partners?' . Session::get('url_filter_partner'));
}
Session::set_flash('error', \Constants::$message_create_error);
}
}
//Get lisst partner name
$partner = new \Model_Mpartner();
$data['partner_name'] = $partner->get_partner_name();
//Define variable form load database from database
$group = new \Model_Mgroups();
$data['is_view'] = $is_view;
$first_group = array('' => '取引先グループを選択して下さい');
$arr_group = array_column($group->get_all(), 'name', 'm_group_id');
$data['form']['arr_group'] = $first_group + $arr_group;
$this->template->title = 'UOS求人システム';
$this->template->content = \View::forge('partner/index', $data);
}
public function edit_partner($id, $arr_partner)
{
if (empty($arr_partner) || !($partner = \Model_Mpartner::find_by_pk($id))) {
Session::set_flash('error', '取引先は存在しません');
Response::redirect('master/partners');
}
$data_json = json_encode($arr_partner);
$partner->updated_at = date('Y-m-d H:i:s');
$partner->status = \Constants::$_status_partner['pending'];
$partner->edit_data = $data_json;
if ($partner != null && $partner->save() >= 0) {
return true;
} else {
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);
}
/**
* @author Thuanth6589 <*****@*****.**>
* action create/update ss
*/
public function action_index()
{
$ss_id = Input::get('ss_id');
$filter_group = $this->filter_group;
$data_filter['field'] = $filter_group;
if (isset($ss_id)) {
$ss = \Model_Mss::find_by_pk($ss_id);
if (!isset($ss)) {
Session::set_flash('error', 'SSは存在しません');
return Response::redirect('/master/sslist');
}
$data['ss'] = $ss;
$data['json'] = $ss->edit_data != '' ? json_decode($ss->edit_data) : $ss;
$data_filter['datafilter'] = \Presenter_Group_Filter::edit($filter_group['step'], $filter_group['type'], $data['json']->partner_code);
$partner = \Model_Mpartner::find_by_pk($ss->partner_code);
$group = \Model_Mgroups::find_by_pk($partner->m_group_id);
$data['branch_name'] = $partner->branch_name;
$data['group_name'] = $group->name;
$data['is_view'] = $this->_compare_data_json($ss, $ss->edit_data);
}
$submit = Input::post('submit');
if (isset($submit)) {
$url = Session::get('sslist_url') ? Session::get('sslist_url') : Uri::base() . 'master/sslist';
$ss = new \Model_Mss();
$ss->set_data(Input::post());
if (isset($ss->fields['ss_id']) && !\Model_Mss::find_by_pk($ss->fields['ss_id'])) {
Session::set_flash('error', 'SSは存在しません');
return Response::redirect($url);
}
if (!\Model_Mpartner::find_by_pk(Input::post('partner_code'))) {
Session::set_flash('error', '取引先(受注先)は存在しません');
} else {
if ($ss->save_data()) {
Session::set_flash('success', \Constants::$message_create_success);
return Response::redirect($url);
}
Session::set_flash('error', \Constants::$message_create_error);
}
}
$data['address1'] = \Constants::get_create_address();
$this->template->title = 'UOS求人システム';
$this->template->content = View::forge('ss', $data);
$this->template->content->filtergroup = \Presenter::forge('group/filter')->set('custom', $data_filter);
}
/**
* 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;
}
?>
</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_remaining_cost($apply_date, $list_ss, $ss_id, $order = array())
{
//get ss_info
$ss_info = \Model_Mss::find_by_pk($ss_id);
//get list ss by partner_code
$list_ss_primary = array();
if ($ss_info) {
$model_mss = new \Model_Mss();
$partner = \Model_Mpartner::find_by_pk($ss_info->partner_code);
if ($partner) {
$department_id = $partner->department_id;
}
$list_ss_partner_code = $model_mss->get_list_all_ss(array('partner_code' => $ss_info->partner_code));
if ($list_ss_partner_code) {
$list_ss_primary = array_column($list_ss_partner_code, 'ss_id');
}
}
$department_id = isset($partner->department_id) ? $partner->department_id : '';
//get price for order
$cost_of_order = 0;
if ($order) {
$check = true;
if ($order['status'] == 2) {
$check = false;
}
if ($order['status'] == 2 && $order['action'] == 'copy') {
$check = true;
}
if ($check == true) {
$cost_of_order = \Model_Orders::cost_of_order($order, $list_ss_primary, true);
}
}
//get list orders by list_ss_id
$list_orders = \Model_Orders::get_list_order_in_listss($list_ss_primary, $apply_date);
$total_price = 0;
foreach ($list_orders as $key => $value) {
$total_price = $total_price + \Model_Orders::cost_of_order($value, $list_ss_primary, true);
}
//get plan job_cost
$job_cost = \Model_Plan::get_info_by_startdate($apply_date, $department_id);
$remaining_cost = $job_cost - $total_price - $cost_of_order;
return $remaining_cost;
}
/**
* @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 <*****@*****.**>
* approve ss
* @param $ss_id
* @return bool
*/
public function approve($ss_id)
{
if ($ss = static::find_by_pk($ss_id)) {
$this->fields = array();
$edit_data = $ss->edit_data;
if ($edit_data != '') {
$this->fields = json_decode($edit_data, true);
if (!Model_Mpartner::find_by_pk($this->fields['partner_code'])) {
Session::set_flash('error', '取引先は存在しません');
$url = Session::get('sslist_url') ? Session::get('sslist_url') : Uri::base() . 'master/sslist';
return Response::redirect($url);
}
}
$this->fields['ss_id'] = $ss_id;
$this->fields['status'] = self::$status['accept'];
$this->fields['edit_data'] = '';
if ($this->save_data()) {
return true;
}
}
return false;
}
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 : '');
}
public function approval_partner($partner_id)
{
if (!isset($partner_id) || !($partner = \Model_Mpartner::find_by_pk($partner_id))) {
Session::set_flash('error', '取引先は存在しません');
Response::redirect('master/partners/?' . Session::get('url_filter_partner'));
}
//Get json from field edit_data
$edit_data = json_decode($partner->edit_data, true);
//Set array partner to save array field
//Check group in json exits
if ($edit_data and !Model_Mgroups::find_by_pk($edit_data['m_group_id'])) {
Session::set_flash('error', '取引先グループは存在しません');
Response::redirect('master/partners/?' . Session::get('url_filter_partner'));
}
if (isset($edit_data)) {
$arr_partner = \Model_Mpartner::_set($edit_data);
}
$arr_partner['status'] = \Constants::$_status_partner['approval'];
$arr_partner['edit_data'] = null;
$partner->set($arr_partner);
if ($partner->save()) {
return true;
}
return false;
}
if ($step >= 2) {
/*Select partner*/
if (isset($customdata) and $edit_partner = isset($customdata['edit_partner']) ? $customdata['edit_partner'] : array()) {
$arr_partner = array_column($edit_partner, 'branch_name', 'partner_code');
$arr_partner = $default_partner + $arr_partner;
}
?>
<?php
echo Form::select('partner_code', isset($customdata['partner_code']) ? $customdata['partner_code'] : '', $arr_partner, array('class' => 'form-control'));
?>
<?php
if ($is_diff_ss && isset($customdata['label_partner_code'])) {
?>
<span class="edit-before edit-before-ss">
<?php
echo Model_Mpartner::find_by_pk($customdata['label_partner_code'])->branch_name;
?>
</span>
<?php
}
}
if ($step >= 3) {
/*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'));
