![(please configure the [header_logo] section in trac.ini)](/space/chrome/site/your_project_logo.png){kind=logo}
- Timestamp:
- Apr 7, 2015 1:52:40 PM (10 years ago)
- Location:
- pro-violet-viettel/sourcecode/application/modules/admin/models
- Files:
-
- 3 edited
-
paidlog_model.php (modified) (3 diffs)
-
reportmodel.php (modified) (3 diffs)
-
user_model.php (modified) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php
r818 r883 13 13 } 14 14 function getPaidlogs($data) { 15 15 16 if ($data['paid_type'] == 0){ 16 17 $sql = "SELECT SUM(amount) as total_amount FROM tblpaidlog"; … … 19 20 } 20 21 $r = $this->db->query($sql)->row_array(); 22 21 23 $total_amount = (int)$r['total_amount']; 22 24 $sql = "SELECT * FROM " . $this->table_name. " INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id "; … … 54 56 } 55 57 } 56 if ($data['start']){ 58 59 //if ($data['start']){ 60 57 61 $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " "; 58 } 62 //} 63 59 64 //return $this->db->query($sql)->result_array(); 60 65 $re = $this->db->query($sql)->result_array(); 66 61 67 $result['paid_logs'] = $re; 68 62 69 $result['total_amount'] = $total_amount; 63 70 return $result; -
pro-violet-viettel/sourcecode/application/modules/admin/models/reportmodel.php
r838 r883 28 28 $provinces = lang ( '_PROVINCES_' ); 29 29 // Tinh doanh thu theo tinh theo nam 30 $sql = "SELECT *,SUM(amount) as total FROM tblpaidlog LEFT JOIN tbluser ON tbluser.us_id=tblpaidlog.us_id WHERE tblpaidlog.paid_time >= '" . $input ['year'] . "-01-01' AND tblpaidlog.paid_time <= '" . ($input ['year'] + 1) . "-01-01' GROUP BY tbluser.province"; 30 //$sql = "SELECT *,SUM(amount) as total FROM tblpaidlog LEFT JOIN tbluser ON tbluser.us_id=tblpaidlog.us_id WHERE tblpaidlog.paid_time >= '" . $input ['year'] . "-01-01' AND tblpaidlog.paid_time <= '" . ($input ['year'] + 1) . "-01-01' GROUP BY tbluser.province"; 31 $sql = "SELECT *,SUM(amount) as total FROM tblpaidlog LEFT JOIN tbluser ON tbluser.us_id=tblpaidlog.us_id WHERE tblpaidlog.paid_time >= '" . $input ['year'] . "-01-01 00:00:00' AND tblpaidlog.paid_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" .$input['to_date']. " 23:59:59' GROUP BY tbluser.province"; 31 32 $query = $this->db->query ( $sql ); 32 33 $dtns = $query->result_array (); … … 46 47 47 48 // Tinh thue bao theo tinh theo nam 48 $sql = "SELECT *,count(us_id) as total FROM tbluser WHERE tbluser.created_time >= '" . $input ['year'] . "-01-01 00:00:00' AND tbluser.created_time <= '" . ($input ['year'] + 1) . "-01-01 23:59:59' GROUP BY tbluser.province";49 $ query = $this->db->query ( $sql );50 write_file('./log/test.log', date('d-m-Y H:i:s').": ".$sql."\n", FOPEN_WRITE_CREATE);49 //$sql = "SELECT *,count(us_id) as total FROM tbluser WHERE tbluser.created_time >= '" . $input ['year'] . "-01-01 00:00:00' AND tbluser.created_time <= '" . ($input ['year'] + 1) . "-01-01 23:59:59' GROUP BY tbluser.province"; 50 $sql = "SELECT *,count(us_id) as total FROM tbluser WHERE tbluser.created_time >= '" . $input ['year'] . "-01-01 00:00:00' AND tbluser.created_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" .$input['to_date']. " 23:59:59' GROUP BY tbluser.province"; 51 $query = $this->db->query ( $sql ); 51 52 $tbns = $query->result_array (); 52 53 … … 146 147 // tinh thue bao theo thang 147 148 //$sql = "SELECT * FROM tbluser LEFT JOIN tblservicepackage ON tbluser.p_id=tblservicepackage.p_id LEFT JOIN tblregisterpackagelog ON tbluser.cellphone = tblregisterpackagelog.username WHERE tbluser.updated_time >= '" . $input ['year'] . "-" . $input ['month'] . "-" . $input ['date'] . "' AND tbluser.updated_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" . $input ['to_date'] . "' AND tblregisterpackagelog.created_time >= '" . $input ['year'] . "-" . $input ['month'] . "-" . $input ['date'] . "' AND tblregisterpackagelog.created_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" . $input ['to_date'] . "' AND tblservicepackage.p_period > 0 "; 148 $sql = "SELECT * FROM tbluser LEFT JOIN tblregisterpackagelog ON tbluser.cellphone = tblregisterpackagelog.username WHERE tbluser.updated_time >= '" . $input ['year'] . "-" . $input ['month'] . "-" . $input ['date'] . " ' AND tbluser.updated_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" . $input ['to_date'] . "' AND tblregisterpackagelog.created_time >= '" . $input ['year'] . "-" . $input ['month'] . "-" . $input ['date'] . "' AND tblregisterpackagelog.created_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" . $input ['to_date'] . "'";149 $sql = "SELECT * FROM tbluser LEFT JOIN tblregisterpackagelog ON tbluser.cellphone = tblregisterpackagelog.username WHERE tbluser.updated_time >= '" . $input ['year'] . "-" . $input ['month'] . "-" . $input ['date'] . " 00:00:00' AND tbluser.updated_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" . $input ['to_date'] . " 23:59:59' AND tblregisterpackagelog.created_time >= '" . $input ['year'] . "-" . $input ['month'] . "-" . $input ['date'] . " 00:00:00' AND tblregisterpackagelog.created_time <= '" . $input ['to_year'] . "-" . $input ['to_month'] . "-" . $input ['to_date'] . " 23:59:59'"; 149 150 $query = $this->db->query ( $sql ); 150 151 $users = $query->result_array (); 152 //write_file('./log/sql.log', date("d-m-Y H:i:s").": ".$sql."\n", FOPEN_WRITE_CREATE); 151 153 152 154 $sql = "SELECT * FROM tblservicepackage WHERE p_period>0"; -
pro-violet-viettel/sourcecode/application/modules/admin/models/user_model.php
r818 r883 40 40 if (strlen($data['keyword'])>0){ 41 41 if ($data['status']==0){ 42 if (strlen($data['province_code'])>0){ 43 if(strlen($data['daterange_start'])>0){ 44 $sql.=" WHERE province = '".$data['province_code']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 42 if (strlen($data['province'])>0){ 43 if (strlen($data['district'])>0){ 44 if(strlen($data['daterange_start'])>0){ 45 $sql.=" WHERE province = '".$data['province']."' AND district = '".$data['district']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 46 } 47 }else{ 48 if(strlen($data['daterange_start'])>0){ 49 $sql.=" WHERE province = '".$data['province']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 50 } 45 51 } 46 52 }else{ … … 54 60 }else 55 61 { 56 if (strlen($data['province_code'])>0){ 57 if(strlen($data['daterange_start'])>0){ 58 $sql.=" AND province = '".$data['province_code']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 59 }else{ 60 $sql.=" AND province = '".$data['province_code']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') "; 61 } 62 if (strlen($data['province'])>0){ 63 if (strlen($data['district'])>0){ 64 if(strlen($data['daterange_start'])>0){ 65 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 66 }else{ 67 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') "; 68 } 69 }else{ 70 if(strlen($data['daterange_start'])>0){ 71 $sql.=" AND province = '".$data['province']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 72 }else{ 73 $sql.=" AND province = '".$data['province']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') "; 74 } 75 } 76 62 77 } 63 78 } … … 66 81 if(strlen($data['daterange_start'])>0){ 67 82 if ($data['status']==0){ 68 if (strlen($data['province_code'])>0){ 69 $sql.=" WHERE province = '".$data['province_code']."' AND created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'"; 83 if (strlen($data['province'])>0){ 84 if (strlen($data['district'])>0){ 85 $sql.=" WHERE province = '".$data['province']."' AND district = '".$data['district']."' AND created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'"; 86 }else{ 87 $sql.=" WHERE province = '".$data['province']."' AND created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'"; 88 } 70 89 }else{ 71 90 $sql.=" WHERE (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 72 91 } 73 92 }else{ 74 if (strlen($data['province_code'])>0){ 75 $sql.=" AND province = '".$data['province_code']."' AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 93 if (strlen($data['province'])>0){ 94 if (strlen($data['district'])>0){ 95 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."' AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 96 }else{ 97 $sql.=" AND province = '".$data['province']."' AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 98 } 76 99 }else{ 77 100 $sql.=" AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 78 101 } 102 79 103 } 80 104 } 81 105 else{ 82 106 if ($data['status']==0){ 83 if (strlen($data['province_code'])>0){ 84 $sql.=" WHERE province = '".$data['province_code']."'"; 85 } 86 }else{ 87 if (strlen($data['province_code'])>0){ 88 $sql.=" AND province = '".$data['province_code']."'"; 89 } 107 if (strlen($data['province'])>0){ 108 if (strlen($data['district'])>0){ 109 $sql.=" WHERE province = '".$data['province']."' AND district = '".$data['district']."'"; 110 }else{ 111 $sql.=" WHERE province = '".$data['province']."'"; 112 } 113 } 114 }else{ 115 if (strlen($data['province'])>0){ 116 if (strlen($data['district'])>0){ 117 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."'"; 118 }else{ 119 $sql.=" AND province = '".$data['province']."'"; 120 121 } 122 } 123 90 124 } 91 125 } 92 126 } 93 127 } 128 94 129 $order = ""; 130 95 131 if ($data['sorting_order'] != "sorting") { 96 132 if($data['sorting_field'] != "status"){ … … 101 137 } 102 138 } 103 write_file('./log/test.log', date("d-m-Y: H:i:s"). ": ".$sql." ".$order." LIMIT ".$data['start'].", ".$data['perpage'], FOPEN_WRITE_CREATE);139 //write_file('./log/sql.log', date("d-m-Y: H:i:s"). ": ".$sql." ".$order." LIMIT ".$data['start'].", ".$data['perpage']."\n" , FOPEN_WRITE_CREATE); 104 140 return $this->db->query($sql." ".$order." LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array(); 105 141 } … … 126 162 if (strlen($data['keyword'])>0){ 127 163 if ($data['status']==0){ 128 if (strlen($data['province_code'])>0){ 129 if(strlen($data['daterange_start'])>0){ 130 $sql.=" WHERE province = '".$data['province_code']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 131 } 164 if (strlen($data['province'])>0){ 165 if (strlen($data['district'])>0){ 166 if(strlen($data['daterange_start'])>0){ 167 $sql.=" WHERE province = '".$data['province']."' AND district = '".$data['district']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 168 } 169 }else{ 170 if(strlen($data['daterange_start'])>0){ 171 $sql.=" WHERE province = '".$data['province']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 172 } 173 } 174 132 175 }else{ 133 176 if(strlen($data['daterange_start'])>0){ … … 140 183 }else 141 184 { 142 if (strlen($data['province_code'])>0){ 143 if(strlen($data['daterange_start'])>0){ 144 $sql.=" AND province = '".$data['province_code']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 145 }else{ 146 $sql.=" AND province = '".$data['province_code']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') "; 185 if (strlen($data['province'])>0){ 186 if (strlen($data['district'])>0){ 187 if(strlen($data['daterange_start'])>0){ 188 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 189 }else{ 190 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') "; 191 } 192 }else{ 193 if(strlen($data['daterange_start'])>0){ 194 $sql.=" AND province = '".$data['province']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 195 }else{ 196 $sql.=" AND province = '".$data['province']."' AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%' OR district LIKE '%".$data['keyword']."%' OR province LIKE '%".$data['keyword']."%') "; 197 } 147 198 } 148 199 } … … 152 203 if(strlen($data['daterange_start'])>0){ 153 204 if ($data['status']==0){ 154 if (strlen($data['province_code'])>0){ 155 $sql.=" WHERE province = '".$data['province_code']."' AND created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'"; 205 if (strlen($data['province'])>0){ 206 if (strlen($data['district'])>0){ 207 $sql.=" WHERE province = '".$data['province']."' AND district = '".$data['district']."' AND created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'"; 208 }else{ 209 $sql.=" WHERE province = '".$data['province']."' AND created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'"; 210 } 156 211 }else{ 157 212 $sql.=" AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 158 213 } 159 214 }else{ 160 if (strlen($data['province_code'])>0){ 161 $sql.=" AND province = '".$data['province_code']."' AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 215 if (strlen($data['province'])>0){ 216 if (strlen($data['district'])>0){ 217 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."' AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 218 }else{ 219 $sql.=" AND province = '".$data['province']."' AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; 220 } 162 221 }else{ 163 222 $sql.=" AND (created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."')"; … … 167 226 else{ 168 227 if ($data['status']==0){ 169 if (strlen($data['province_code'])>0){ 170 $sql.=" WHERE province = '".$data['province_code']."'"; 171 } 172 }else{ 173 if (strlen($data['province_code'])>0){ 174 $sql.=" AND province = '".$data['province_code']."'"; 228 if (strlen($data['province'])>0){ 229 if (strlen($data['district'])>0){ 230 $sql.=" WHERE province = '".$data['province']."' AND district = '".$data['district']."'"; 231 }else{ 232 $sql.=" WHERE province = '".$data['province']."'"; 233 } 234 } 235 }else{ 236 if (strlen($data['province'])>0){ 237 if (strlen($data['district'])>0){ 238 $sql.=" AND province = '".$data['province']."' AND district = '".$data['district']."'"; 239 }else{ 240 $sql.=" AND province = '".$data['province']."'"; 241 } 175 242 } 176 243 } … … 191 258 } 192 259 260 public function getDistrictByProvince($provinceId){ 261 $sql = "SELECT * FROM tbldistrict WHERE province_id = ?"; 262 $query = $this->db->query ( $sql, array ( 263 $provinceId 264 ) ); 265 $results = $query->result_array(); 266 return $results; 267 } 268 269 public function getDistrictByIdAndProvince($districtId, $provinceId){ 270 $sql = "SELECT * FROM tbldistrict WHERE district_id = ? AND province_id = ?"; 271 $query = $this->db->query ( $sql,array ($districtId, $provinceId) ); 272 if ($query->num_rows () > 0) { 273 $row = $query->row_array (); 274 return $row; 275 } 276 277 } 193 278 }
Note: See TracChangeset
for help on using the changeset viewer.
