Changeset 818 for pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php

Timestamp:

Mar 24, 2015 2:15:02 PM (10 years ago)

Author:

namnd

Message:

 

File:

• pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php (modified) (3 diffs)

pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php

@@ -1 @@
-<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 
 class Paidlog_model extends MY_Model
@@ -37 +37 @@
                         if ($data['paid_type'] ==0){
                                 $sql.=" WHERE paid_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'";
-                                //write_file('./log/sql.log', date("m/d/Y H:i:s")." ".$sql."\n", FOPEN_WRITE_CREATE);
                         }else{
                                 $sql.=" AND paid_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'";
@@ -45 +44 @@
 
         $order = "";
-        if ($data['sorting_order'] != "sorting") {
-            if ($data['sorting_field'] != "money") {
-                $sort = "DESC";
-                if ($data['sorting_order'] == "sorting_asc")
-                    $sort = "ASC";
-                $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
-            }
-        }
-        $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
+                if ($data['sorting_order']){
+                        if ($data['sorting_order'] != "sorting") {
+                                if ($data['sorting_field'] != "money") {
+                                        $sort = "DESC";
+                                        if ($data['sorting_order'] == "sorting_asc")
+                                                $sort = "ASC";
+                                        $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
+                                }
+                        }
+                }
+                if ($data['start']){
+                        $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
+                }
         //return $this->db->query($sql)->result_array();
                 $re = $this->db->query($sql)->result_array();