Ignore:
Timestamp:
Apr 23, 2015 12:00:06 PM (10 years ago)
Author:
namnd
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r838 r906  
    4949    function getAllCollaboratorUser($from,$id=false)
    5050    {
    51         $from = date("Y-m-d 00:00:00",$from);
     51        $from = date("Y-m-d 00:00:00",$from);
     52                $order = "";
     53        if ($data['sorting_order'] != "sorting") {
     54           
     55                $sort = "DESC";
     56                if ($data['sorting_order'] == "sorting_asc")
     57                    $sort = "ASC";
     58                $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
     59           
     60        }
    5261        $where="";
    5362        if ($id)
    5463        {
    55             $where = " AND tbluser.collaborator = $id ";
     64            //$where = " AND tbluser.collaborator = $id ";
     65                        $where = " AND tblcollaborator.id = $id ";
    5666        }
    5767        //$sql="SELECT *,tblcollaborator.created_time as collaborator_created_time, tbluser.created_time as user_created_time  FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.collaborator = tblcollaborator.id WHERE tbluser.created_time > '".$from."'".$where."";
    5868                $sql="SELECT *,tblcollaborator.created_time as collaborator_created_time, tbluser.created_time as user_created_time  FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.collaborator = tblcollaborator.cellphone WHERE tbluser.created_time > '".$from."'".$where."";
    59 
     69               
    6070        $result = $this->db->query($sql)->result_array();
    6171        foreach ($result as $index=>$paidlog)
    … …  
    120130       
    121131                $sql="SELECT *,tblcollaborator.created_time as collaborator_created_time,tblcollaborator.cellphone as collaborator_cellphone, tbluser.created_time as user_created_time, COUNT(tbluser.collaborator) as total_user  FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.collaborator = tblcollaborator.cellphone ".$where." GROUP BY tblcollaborator.id ".$order." LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
    122 
     132               
    123133        $result = $this->db->query($sql)->result_array();
    124134        foreach ($result as $index=>$paidlog)
    … …  
    153163                }else{
    154164                        $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.cellphone ".$where." AND tblcollaborator.id = ".$data['id']." ".$order."";
    155                 }       
     165                }
     166                //write_file('./log/sql.log', date('d-m-Y H:i:s').": ".$sql."\n", FOPEN_WRITE_CREATE);         
    156167                $result = $this->db->query($sql)->result_array();
     168               
    157169        foreach ($result as $index=>$paidlog)
    158170        {
    159171            $result[$index]['time']=  strtotime($paidlog['user_created_time']);
    160172        }
    161 
     173               
    162174        return count($result);
    163175    }
    164         function getCountCollaboratorUsers($data)
     176       
     177        function getCountCollaboratorUsers($data)
    165178    {
    166179        $order = "";
    167         if ($data['sorting_order'] != "sorting") {
    168            
     180        if ($data['sorting_order'] != "sorting") {       
    169181                $sort = "DESC";
    170182                if ($data['sorting_order'] == "sorting_asc")
    … …  
    174186        }
    175187        $where="";
     188               
    176189        if ($data['keyword']) {
    177190            if ($data['search_field'] == "cellphone") {
    … …  
    179192            }
    180193        }
     194               
    181195       // $from = date("Y-m-d 00:00:00",$from);
    182196       // $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'] . " ";
    183                 if(strlen($data['daterange_start'])>0){
    184                         $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.cellphone ".$where." AND (tbluser.created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."') AND tblcollaborator.id = ".$data['id']." ".$order." LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
     197           
     198                if($data['daterange_start']){
     199                       
     200                        if ($data['perpage']){
     201                                $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.cellphone ".$where." AND (tbluser.created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."') AND tblcollaborator.id = ".$data['id']." ".$order." LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
     202                        }else{
     203                                $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.cellphone ".$where." AND (tbluser.created_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."') AND tblcollaborator.id = ".$data['id']." ".$order;
     204                        }
    185205                }else{
    186                         $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.cellphone ".$where." AND tblcollaborator.id = ".$data['id']." ".$order." LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
     206                        if ($data['perpage']){
     207                                $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.cellphone ".$where." AND tblcollaborator.id = ".$data['id']." ".$order." LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
     208                        }else{
     209                                $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.cellphone ".$where." AND tblcollaborator.id = ".$data['id']." ".$order;
     210                        }
    187211                }
    188212                $result = $this->db->query($sql)->result_array();
    … …  
    454478        }
    455479       
     480        public function createRandomPassword()
     481        {
     482                $alphabet = "0123456789";
     483                $pass = array ();
     484                $alphaLength = strlen ( $alphabet ) - 1;
     485                for($i = 0; $i < 6; $i ++) {
     486                        $n = rand ( 0, $alphaLength );
     487                        $pass [] = $alphabet [$n];
     488                }
     489                return implode ( $pass );
     490        }
    456491}
Note: See TracChangeset for help on using the changeset viewer.