<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Reportpackage extends MX_Controller {

    const TOKENPW = 'violet';

    public function __construct() {
        parent::__construct();
        $this->load->helper('cookie');
        $this->load->helper('language');
        $this->lang->load('messages', 'message');
    }

    public function index() {
        $data = array();
        $admin_info = $this->session->userdata('adminInfo');
        if ($admin_info) {
            $data['content'] = $this->getProvince();
            $this->load->view('reportpackage/index', $data);
        } else {
            $this->load->view('login');
        }
    
    }


    public function getProvince($filters = array()) {
        
        $this->load->model('reportmodel');
        $data['month']=date("m");
        $data['year']=date("Y");
        if ($this->input->post('month')) {
          $data['month']=$this->input->post('month');
          $data['year']=$this->input->post('year');
        }
        $data['month_days']=1;
        if("".$data['year']."-".$data['month'].""==date("Y-m"))
        {
        $data['month_days']=date("d");
        }
        else
        {
        $data['month_days']=cal_days_in_month(CAL_GREGORIAN, $data['month'], $data['year']); // 31  
        }
        $data['year_days']=1;
        if($data['year']== date("Y"))
        {
        $data['year_days']=date('z') + 1;
        }
        else
        {
        $data['year_days']=date("z", mktime(0,0,0,12,31,$data['year'])) + 1;
        }
        

        $result=$this->reportmodel->getPackages($data);
        $data['provinces'] = $result['provinces'];
        $data['packages'] = $result['packages'];
        
        if ($this->input->is_ajax_request()) {
            return $this->load->view('reportpackage/province', $data);
        }
        return $this->load->view('reportpackage/province', $data, true);
    }

    private function get_fullname($us_id) {
        $fullname="";
        $src = 'violet';
        $token = md5($us_id . self::TOKENPW);
        $this->load->model('user_model');
        $data = $this->user_model->get_user_info($src, $us_id, $token);
        parse_str($data,$data);
        if (isset($data['fullname']))
        {
            $fullname=$data['fullname'];
        }
        return $fullname;
    }

    public function test() {

            $provinces=lang('_PROVINCES_');
            $sql="SELECT * FROM tbluser";
            $query = $this->db->query ($sql);
		$result = $query->result_array();
            foreach ($result as $user)
            {
                $p=$provinces[rand(0,62)];
                $user['province']=$p;
                $this->db->where('us_id', $user['us_id']);
		$this->db->update('tbluser', $user);
            }
    }

}