source: pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportprovince.php @ 707

<?php

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

class Reportprovince 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('reportprovince/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;
        }
        
     
        $data['provinces'] = $this->reportmodel->getProvinces($data);

        foreach ($data['provinces'] as $index => $paidlog) {
            $data['provinces'][$index]['username'] = @$this->get_fullname($paidlog['us_id']); 
        }

        if ($this->input->is_ajax_request()) {
            return $this->load->view('reportprovince/province', $data);
        }
        return $this->load->view('reportprovince/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);
            }
    }

}