zhkt/protected/model/order.php

<?php

Doo::loadCore('db/DooModel');
/**
 * Created by PhpStorm.
 * User: ellisran
 * Date: 2016/9/22
 * Time: 16:20
 */
class Order extends DooModel {
    public $id;
    public $trade_sn;
    public $userid;
    public $username;
    public $useremail;
    public $mobile;
    public $classid;
    public $classname;
    public $price;
    public $ip;
    public $status;
    public $createtime;
    public $paytime;

    public $_table = 'kt_order';
    public $_primarykey = 'id';
    public $_fields = array('id', 'trade_sn', 'userid', 'username', 'useremail', 'mobile', 'classname', 'price', 'classid', 'ip', 'status', 'createtime', 'paytime');

    public function __construct() {
        parent::setupModel(__CLASS__);
    }

    public function getRowsBytrade_id($trade_sn){
        return $this->getOne(array('where' => 'trade_sn="'.$trade_sn.'"', 'asArray' => TRUE));
    }

    public function getorderlist($limit, $status = ''){
        if($status == '') {
            return $this->find(array('desc' => 'createtime', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => 'status='.$status, 'desc' => 'createtime', 'limit' => $limit, 'asArray' => TRUE));
        }
    }

    public function getorderlistbyuserid($uid,$limit){
        return $this->find(array('where' => 'userid='.$uid, 'desc' => 'id', 'limit' => $limit, 'asArray' => TRUE));
    }

    public function getorderlistbySearch($search, $limit, $status = ''){
        if($status == ''){
            return $this->find(array('where' => 'trade_sn=? or username=? or useremail=? or mobile=? or classname=?', 'param' => array($search,$search,$search,$search,$search), 'desc' => 'createtime', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => '(trade_sn=? or username=? or useremail=? or mobile=? or classname=?) and status=?', 'param' => array($search,$search,$search,$search,$search,$status), 'desc' => 'createtime', 'limit' => $limit, 'asArray' => TRUE));
//            $sql = 'select * from ' . $this->_table . ' where trade_sn="'.$search.'" or username="'.$search.'" or useremail="'.$search.'" or mobile="'.$search.'" or classname="'.$search.'" and status='.$status.' order by createtime desc limit '.$limit;
//            $query = Doo::db ()->query ( $sql );
//            $result = $query->fetchAll ();
//            return $result;
        }
    }
}