zhkt/protected/model/classuser.php

<?php

Doo::loadCore('db/DooModel');
/**
 * Created by PhpStorm.
 * User: ellisran
 * Date: 2016/9/22
 * Time: 16:20
 */
class Classuser extends DooModel {
    public $id;
    public $userid;
    public $classid;
    public $seetime;
    public $price;
    public $issuccess;
    public $watch_videoid;
    public $watch_wyid;
    public $watch_time;
    public $lasttime;

    public $_table = 'kt_class_user';
    public $_primarykey = 'id';
    public $_fields = array('id', 'userid', 'classid', 'seetime', 'price', 'issuccess', 'watch_videoid', 'watch_wyid', 'watch_time','lasttime');

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

    public function getNumbyClassid($id) {
        return $this->count(array('where' => 'classid='.$id));
    }

    public function getuserlist($id,$limit,$sort = 0) {
        if($sort == 0){
            return $this->find(array('where' => 'classid='.$id, 'desc' => 'seetime', 'asc' => 'userid', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => 'classid='.$id, 'asc' => 'seetime', 'asc' => 'userid', 'limit' => $limit, 'asArray' => TRUE));
        }
    }

    public function getuserlist2($id,$limit,$sort) {
        if($sort == 'id'){
            return $this->find(array('where' => 'classid='.$id, 'asc' => 'userid', 'limit' => $limit, 'asArray' => TRUE));
        }elseif($sort == 'progress'){
            return $this->find(array('where' => 'classid='.$id, 'desc' => 'seetime', 'asc' => 'userid', 'limit' => $limit, 'asArray' => TRUE));
        }elseif($sort == 'time'){
            return $this->find(array('where' => 'classid='.$id,  'desc' => 'lasttime', 'asc' => 'userid', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => 'classid='.$id, 'asc' => 'userid', 'limit' => $limit, 'asArray' => TRUE));
        }
    }

    public function getclassbyuserid($id) {
        return $this->find(array('where' => 'userid='.$id, 'asc' => 'classid', 'asArray' => TRUE));
    }

    public function gethasbyuserandclass($uid,$sid) {
        return $this->getOne(array('where' => 'userid=? and classid=?', 'param' => array($uid,$sid), 'asArray' => TRUE));
    }

    public function getNumbyuserid($userid) {
        return $this->count(array('where' => 'userid='.$userid, 'asArray' => TRUE));
    }

    public function  getAllpricebyid($userid) {
        $result = $this->find(array('where' => 'userid='.$userid, 'asArray' => TRUE));
        $price = 0;
        if(!empty($result)){
            foreach($result as $k => $v){
                $price += $v['price'];
            }
        }
        return $price;
    }

    public function gettimebyClassid($cid) {
        return $this->find(array('select' => 'seetime', 'where' => 'classid='.$cid, 'asArray' => TRUE));
    }
}