Ignore:
Timestamp:
Jan 30, 2015 6:49:37 PM (10 years ago)
Author:
quyenla
Message:

user

File:
1 edited

Legend:

Unmodified
Added
Removed
  • pro-violet-viettel/sourcecode/application/modules/admin/models/reportmodel.php

    r702 r728  
    6767            }
    6868        }
     69       
    6970        return $provinces;
    7071    }
     
    7475        $provinces = lang('_PROVINCES_');
    7576        // tinh thue bao theo thang
    76         $sql = "SELECT * FROM tbluser LEFT JOIN tblservicepackage ON tbluser.p_id=tblservicepackage.p_id  WHERE tbluser.created_time >'".$input['year']."-".$input['month']."-01' AND tbluser.created_time <'".$input['year']."-".$input['month']."-31' AND tblservicepackage.p_period > 0 " ;
     77        $sql = "SELECT * FROM tbluser LEFT JOIN tblservicepackage ON tbluser.p_id=tblservicepackage.p_id  WHERE tbluser.created_time >'" . $input['year'] . "-" . $input['month'] . "-01' AND tbluser.created_time <'" . $input['year'] . "-" . $input['month'] . "-31' AND tblservicepackage.p_period > 0 ";
    7778        $query = $this->db->query($sql);
    7879        $users = $query->result_array();
     
    9697
    9798        foreach ($provinces as $index => $province) {
    98             $provinces[$index]['stt']=$index+1;
     99            $provinces[$index]['stt'] = $index + 1;
    99100            $provinces[$index]['total'] = 0;
    100101            $totaluser = 0;
     
    123124            }
    124125        }
    125      
    126         $data['packages']=$packages;
    127         $data['provinces']=$provinces;
     126
     127        $data['packages'] = $packages;
     128        $data['provinces'] = $provinces;
    128129        return $data;
    129130    }
Note: See TracChangeset for help on using the changeset viewer.