Ignore:
Timestamp:
Nov 12, 2014 9:28:43 AM (11 years ago)
Author:
quyenla
Message:

thong ke

Location:
pro-violet-viettel/sourcecode/application
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • pro-violet-viettel/sourcecode/application/config/routes.php

    r471 r478  
    8585$route['admin/thong_ke_cong_tac_vien'] = 'admin/reportAsistant';
    8686$route['admin/thong_ke_cong_tac_vien/trang'] = 'admin/reportAsistant/getCollaborators/1';
     87$route['admin/thong_ke_cong_tac_vien/trang_ctv/:any/:any'] = 'admin/reportAsistant/getCollaboratorsUsers/$1';
     88$route['admin/thong_ke_cong_tac_vien/trang_ctv/:any'] = 'admin/reportAsistant/getCollaboratorsUsers/$1';
    8789$route['admin/thong_ke_cong_tac_vien/trang/:any'] = 'admin/reportAsistant/getCollaborators/$1';
    8890$route['admin/thong_ke_cong_tac_vien/them'] = 'admin/reportAsistant/addSmstemplate';
    8991$route['admin/thong_ke_cong_tac_vien/:any'] = 'admin/reportAsistant/viewAsistant';
    9092
    91 $route['admin/thong_ke_cong_tac_vien/test'] = 'admin/reportAsistant/test';
    92 $route['admin/thong_ke_cong_tac_vien/xem/:any'] = 'admin/reportAsistant/viewSms';
    93 $route['admin/thong_ke_cong_tac_vien/sua/:any'] = 'admin/reportAsistant/editSms';
    94 $route['admin/thong_ke_cong_tac_vien/xoa/:any'] = 'admin/reportAsistant/deleteSms';
    95 $route['admin/thong_ke_cong_tac_vien/xoa_tin_nhan'] = 'admin/reportAsistant/dodeleteSms';
    96 $route['admin/thong_ke_cong_tac_vien/cap_nhat'] = 'admin/reportAsistant/updateSms';
    9793
    9894
  • pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportAsistant.php

    r464 r478  
    2727    {
    2828        $data = array();
    29         $id=$this->uri->segment(3);
     29       
    3030        $admin_info = $this->session->userdata('adminInfo');
    3131        if ($admin_info) {
     32            $id=$this->uri->segment(3);
     33             $data['id']=$id;
    3234            $data['statistics'] = $this->getStatistics($id);
    3335            $data['content'] = $this->getCollaboratorsUsers(array(),$id);
    34             $this->load->view('reportAsistant/index', $data);
     36            $this->load->view('reportAsistant/indexCollaborator', $data);
    3537        } else {
    3638            $this->load->view('login');
     
    149151   
    150152    public function getCollaboratorsUsers($filters = array(),$id=false) {
    151 
     153   
    152154        $this->load->helper('pagging');
    153155        $this->load->model('collabolator_model');
    154         $data['current_page'] = $this->uri->segment(4, 1);
     156        $data['current_page'] = $this->uri->segment(5, 1);
     157 
    155158        $data['itemsoptions'] = array(10, 25, 50, 100);
    156159        $data['perpage'] = 10;
     160        if (!$id)
     161        {
     162            $data['id']= $this->uri->segment(4, 1);
     163        }
     164        else {
    157165        $data['id']=$id;
     166        }
     167             
    158168        $data['keyword'] = "";
    159169        $data['sorting_order'] = "sorting_desc";
     
    182192        $data['paidlogs'] = $this->collabolator_model->getCountCollaboratorUsers($data);
    183193
    184         $data['paging_url'] = base_url() . "/admin/thong_ke_cong_tac_vien/trang/";
     194        $data['paging_url'] = base_url() . "/admin/thong_ke_cong_tac_vien/trang_ctv/".$data['id'];
    185195        $data['num_links'] = 2;
    186196        $data['paging'] = pagging($data);
     
    197207        $this->load->model('user_model');
    198208        $data = $this->user_model->get_user_info($src, $us_id, $token);
     209       
    199210        if (strlen($data) > 0) {
    200211            $arr_users = explode("&", $data);
  • pro-violet-viettel/sourcecode/application/modules/admin/models/collabolator_model.php

    r464 r478  
    123123        if ($data['keyword']) {
    124124            if ($data['search_field'] == "cellphone") {
    125                 $where.=" WHERE (tblcollaborator.cellphone LIKE '%" . $data['keyword'] . "%')";
    126             } else {
    127                 $where.=" WHERE (full_name LIKE '%" . $data['keyword'] . "%' OR login_name LIKE '%" . $data['keyword'] . "%') ";
     125                $where.=" WHERE (tbluser.cellphone LIKE '%" . $data['keyword'] . "%')";
    128126            }
    129127        }
     
    153151        if ($data['keyword']) {
    154152            if ($data['search_field'] == "cellphone") {
    155                 $where.=" WHERE (tblcollaborator.cellphone LIKE '%" . $data['keyword'] . "%')";
    156             } else {
    157                 $where.=" WHERE (full_name LIKE '%" . $data['keyword'] . "%' OR login_name LIKE '%" . $data['keyword'] . "%') ";
    158             }
     153                $where.=" WHERE (tbluser.cellphone LIKE '%" . $data['keyword'] . "%')";
     154            }
    159155        }
    160156       // $from = date("Y-m-d 00:00:00",$from);
    161157        $sql="SELECT *,tblcollaborator.created_time as collaborator_created_time,tbluser.cellphone as user_cellphone,tblcollaborator.cellphone as collaborator_cellphone, tbluser.created_time as user_created_time  FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.collaborator = tblcollaborator.id ".$where." AND tbluser.collaborator = ".$data['id']." ".$order." LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
    162    
    163158        $result = $this->db->query($sql)->result_array();
    164159        foreach ($result as $index=>$paidlog)
Note: See TracChangeset for help on using the changeset viewer.