vc_jlzf/protected/model/category.php

<?php

Doo::loadCore('db/DooModel');
/**
 * Created by PhpStorm.
 * User: ellisran
 * Date: 2016/9/22
 * Time: 16:20
 */
class Category extends DooModel {
    public $cateid;
    public $catename;
    public $parentid;
    public $itemid;

    public $_table = 'fc_category';
    public $_primarykey = 'cateid';
    public $_fields = array('cateid', 'catename', 'parentid', 'itemid');

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

    public function getAlllist($itemid = 0) {
        return $this->find(array('select' => 'cateid,catename', 'where' => 'itemid='.$itemid, 'asArray' => TRUE));
    }

    public function getparentlist($itemid = 0) {
        return $this->find(array('select' => 'cateid,catename', 'where' => 'parentid=0 and itemid='.$itemid, 'asArray' => TRUE));
    }

    public function getRowbylimit($limit,$itemid = 0) {
        return $this->find(array('where' => 'itemid='.$itemid, 'desc' => 'cateid', 'limit' => $limit, 'asArray' => TRUE));
    }

    public function getnamebyid($id) {
        $cate = $this->getOne(array('select' => 'catename', 'where' => 'cateid='.$id, 'asArray' => TRUE));
        return $cate['catename'];
    }

    public function getchildbyparent($parentid) {
        return $this->find(array('select' => 'cateid', 'where' => 'parentid='.$parentid, 'asArray' => TRUE));
    }

    public function hadChild($parentid) {
        $total = $this->count(array('where' => 'parentid='.$parentid, 'asArray' => TRUE));
        if($total == 0){
            return 0;
        }else{
            return 1;
        }
    }

    public function getChildList($parentid) {
        return $this->find(array('select' => 'cateid,catename','where' => 'parentid='.$parentid, 'asArray' => TRUE));
    }

}