vc_jlzf/protected/model/report.php

<?php

Doo::loadCore('db/DooModel');
/**
 * Created by PhpStorm.
 * User: ellisran
 * Date: 2016/9/22
 * Time: 16:20
 */
class Report extends DooModel {
    public $reportid;
    public $reportname;
    public $areacate;
    public $itemid;
    public $cateid;
    public $parentid;
    public $userid;
    public $edittime;
    public $lastedit;
    public $lastuser;

    public $_table = 'fc_report';
    public $_primarykey = 'reportid';
    public $_fields = array('reportid', 'reportname', 'areacate', 'itemid', 'cateid', 'parentid', 'userid','edittime','lastedit','lastuser');

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

    public function getitemRowbylimit($limit,$itemid = 0,$sort = '',$sql = ''){
        if($sort == 'report'){
            return $this->find(array('where' => 'itemid='.$itemid.$sql, 'asc' => 'reportname', 'limit' => $limit, 'asArray' => TRUE));
        }elseif($sort == 'edit'){
            return $this->find(array('where' => 'itemid='.$itemid.$sql, 'desc' => 'lastedit', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => 'itemid='.$itemid.$sql, 'desc' => 'edittime', 'limit' => $limit, 'asArray' => TRUE));
        }
    }

    public function getAllitemRowbylimit($limit,$sort = ''){
        if($sort == 'report'){
            return $this->find(array('where' => 'itemid!=0', 'asc' => 'reportname', 'limit' => $limit, 'asArray' => TRUE));
        }elseif($sort == 'edit'){
            return $this->find(array('where' => 'itemid!=0', 'desc' => 'lastedit', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => 'itemid!=0', 'desc' => 'edittime', 'limit' => $limit, 'asArray' => TRUE));
        }
    }

    public function getcateRowbylimit($limit,$cateid = 0,$sql = '',$sort = ''){
        if($sort == 'report') {
            return $this->find(array('where' => 'itemid=0 and (cateid=' . $cateid . ' or parentid=' . $cateid . ')' . $sql, 'asc' => 'reportname', 'limit' => $limit, 'asArray' => TRUE));
        }elseif($sort == 'edit') {
            return $this->find(array('where' => 'itemid=0 and (cateid=' . $cateid . ' or parentid=' . $cateid . ')' . $sql, 'desc' => 'lastedit', 'limit' => $limit, 'asArray' => TRUE));
        }else{
            return $this->find(array('where' => 'itemid=0 and (cateid=' . $cateid . ' or parentid=' . $cateid . ')' . $sql, 'desc' => 'edittime', 'limit' => $limit, 'asArray' => TRUE));
        }
    }

    public function getRowbyid($id){
        return $this->getOne(array('where' => 'reportid='.$id, 'asArray' => TRUE));
    }

}