function getUserRedemption($promotion_id, $status_id, $hide_expired = 0, $search_word = '')
{
$this->db->order_by('voucher', 'asc');
if ($hide_expired == 1) {
$this->db->where('expired_date >=', get_part_of_date('all'));
}
$redeem_query = $this->db->get_where('user_redemption', array('advertise_id' => $promotion_id, 'status_id' => $status_id));
$result = $redeem_query->result_array();
$return = array();
foreach ($result as $row) {
if (!empty($search_word)) {
$user_info = $this->m_custom->getUserInfo($row['user_id']);
if (searchWord($user_info['id'], $search_word) || searchWord($user_info['name'], $search_word) || searchWord($user_info['email'], $search_word) || searchWord($row['voucher'], $search_word)) {
$return[] = $row;
}
} else {
$return[] = $row;
}
}
return $return;
}
public function remove_row_log($the_table, $the_id, $do_by = NULL, $do_by_type = NULL)
{
$query = $this->db->get_where('table_row_activity', array('table_type' => $the_table, 'table_row_id' => $the_id), 1);
if ($query->num_rows() == 0) {
$this->insert_row_log($the_table, $the_id, $do_by, $do_by_type);
$query = $this->db->get_where('table_row_activity', array('table_type' => $the_table, 'table_row_id' => $the_id), 1);
}
$activity_row = $query->row();
$admin_login_as = $this->session->userdata('admin_login_as');
//If is admin login as this user
$the_data = array('hide_time' => get_part_of_date('all'), 'hide_by' => $do_by, 'hide_by_type' => $do_by_type, 'admin_login_as' => $admin_login_as == 0 ? NULL : $admin_login_as);
$this->db->where('activity_id', $activity_row->activity_id);
$this->db->update('table_row_activity', $the_data);
}
public function promotion_admin_redemption_done($redeem_id, $mark_expired = 0, $mark_active = 0)
{
if ($this->m_admin->check_is_any_admin(71)) {
$login_id = $this->ion_auth->user()->row()->id;
$login_type = $this->session->userdata('user_group_id');
$status_id = $this->config->item('voucher_used');
if ($mark_expired == 1) {
$status_id = $this->config->item('voucher_expired');
}
if ($mark_active == 1) {
$status_id = $this->config->item('voucher_active');
}
$the_data = array('status_id' => $status_id, 'redeem_at_date' => get_part_of_date('all'), 'done_by' => $login_id, 'done_by_type' => $login_type);
$this->db->where('redeem_id', $redeem_id);
if ($this->db->update('user_redemption', $the_data)) {
return TRUE;
}
}
return FALSE;
}
function analysis_report($search_month = NULL, $search_year = NULL, $search_adv_type = NULL, $search_new_user = NULL)
{
$message_info = '';
if (check_correct_login_type($this->main_group_id)) {
//$this->data['charts'] = $this->getChart($merchant_id);
$merchant_id = $this->ion_auth->user()->row()->id;
$merchant_data = $this->m_custom->getUser($merchant_id);
if (isset($_POST) && !empty($_POST)) {
if ($this->input->post('button_action') == "search_history") {
$search_month = $this->input->post('the_month');
$search_year = $this->input->post('the_year');
$search_adv_type = $this->input->post('the_adv_type');
$search_new_user = $this->input->post('the_new_user');
}
}
$year_list = generate_number_option(get_part_of_date('year', $merchant_data['created_on'], 1), get_part_of_date('year'));
$this->data['year_list'] = $year_list;
$this->data['the_year'] = array('name' => 'the_year', 'id' => 'the_year');
$selected_year = empty($search_year) ? get_part_of_date('year') : $search_year;
$this->data['the_year_selected'] = $selected_year;
$month_list = $this->m_custom->month_group_list();
$this->data['month_list'] = $month_list;
$this->data['the_month'] = array('name' => 'the_month', 'id' => 'the_month');
$selected_month = empty($search_month) ? get_part_of_date('month') : $search_month;
$this->data['the_month_selected'] = $selected_month;
$adv_type_list = array('' => 'All Advertise', 'hot' => 'Food & Beverage', 'pro' => 'Promotion');
$this->data['adv_type_list'] = $adv_type_list;
$this->data['the_adv_type'] = array('name' => 'the_adv_type', 'id' => 'the_adv_type');
$this->data['the_adv_type_selected'] = empty($search_adv_type) ? "" : $search_adv_type;
$new_user_list = array('' => 'All User', '1' => 'New User Only');
$this->data['new_user_list'] = $new_user_list;
$this->data['the_new_user'] = array('name' => 'the_new_user', 'id' => 'the_new_user');
$this->data['the_new_user_selected'] = empty($search_new_user) ? "" : $search_new_user;
$first_day = displayDate(getFirstLastTime($selected_year, $selected_month));
$last_day = displayDate(getFirstLastTime($selected_year, $selected_month, 1));
$this->data['first_day'] = $first_day;
$this->data['last_day'] = $last_day;
$this->data['message'] = $this->session->flashdata('message');
$this->data['page_path_name'] = 'merchant/analysis_report';
$this->load->view('template/index', $this->data);
} else {
redirect('/', 'refresh');
}
}
function analysis_report_user($search_month = NULL, $search_year = NULL)
{
$message_info = '';
if (!$this->m_admin->check_is_any_admin(63)) {
redirect('/', 'refresh');
}
if (isset($_POST) && !empty($_POST)) {
if ($this->input->post('button_action') == "search_history") {
$search_month = $this->input->post('the_month');
$search_year = $this->input->post('the_year');
}
}
$year_list = generate_number_option(2015, get_part_of_date('year'));
$this->data['year_list'] = $year_list;
$this->data['the_year'] = array('name' => 'the_year', 'id' => 'the_year');
$selected_year = empty($search_year) ? get_part_of_date('year') : $search_year;
$this->data['the_year_selected'] = $selected_year;
$month_list = $this->m_custom->month_group_list();
$this->data['month_list'] = $month_list;
$this->data['the_month'] = array('name' => 'the_month', 'id' => 'the_month');
$selected_month = empty($search_month) ? get_part_of_date('month') : $search_month;
$this->data['the_month_selected'] = $selected_month;
$first_day = displayDate(getFirstLastTime($selected_year, $selected_month));
$last_day = displayDate(getFirstLastTime($selected_year, $selected_month, 1));
$this->data['first_day'] = $first_day;
$this->data['last_day'] = $last_day;
$this->data['message'] = $this->session->flashdata('message');
$this->data['page_path_name'] = 'admin/analysis_report_user';
$this->load->view('template/index', $this->data);
}
function displayLastDay($year = '', $month = '', $until_today = 0)
{
if (empty($month)) {
$month = date('m');
}
if (empty($year)) {
$year = date('Y');
}
$add_argument = '+1 month';
if ($until_today == 1 && $month == date('m') && $year == date('Y')) {
$add_argument = "+" . get_part_of_date('day') . " day";
}
$result = strtotime("{$year}-{$month}-01");
$result = strtotime('-1 second', strtotime($add_argument, $result));
return date('d-m-Y', $result);
}
