zhkt/protected/model/ktclass.php

<?php

Doo::loadCore('db/DooModel');
/**
 * Created by PhpStorm.
 * User: ellisran
 * Date: 2016/9/22
 * Time: 16:20
 */
class Ktclass extends DooModel {
    public $classid;
    public $classname;
    public $classnum;
    public $classtime;
    public $stoptime;
    public $avatar;
    public $price;
    public $description;
    public $createtime;
    public $ishow;


    public $_table = 'kt_class';
    public $_primarykey = 'classid';
    public $_fields = array('classid', 'classname', 'classnum', 'classtime', 'stoptime', 'avatar', 'price', 'description', 'createtime', 'ishow', 'watch_videoid', 'watch_time');

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

    public function getRowbyId($id){
        return $this->getOne(array('where' => 'classid='.$id, 'asArray' => true));
    }

    public function getRowishowbyId($id){
        return $this->getOne(array('where' => 'ishow=1 and classid='.$id, 'asArray' => true));
    }

    public function getclasslist($limit){
        return $this->find(array('desc' => 'createtime', 'limit' => $limit, 'asArray' => true));
    }

    public function getclasslistbyshow($limit){
        return $this->find(array('where' => 'ishow=1', 'desc' => 'createtime', 'limit' => $limit, 'asArray' => true));
    }

    public function getnamebyId($id){
        return $this->getOne(array('select' => 'classname', 'where' => 'classid='.$id, 'asArray' => TRUE));
    }

    public function getclassbySearch($search){
        return $this->find(array('where' => 'ishow=1 and classname="'.$search.'"', 'asArray' => TRUE));
    }

}