<?php

Doo::loadCore('db/DooModel');

/**
 * 变更用户申报清单关联表
 */
class ChangeAudit extends DooModel {

    public $id;
    public $pid;
    public $stid;
    public $pmid;
    public $cid;
    public $times;
    public $usite;
    public $usort;
    public $uid;
    public $company;
    public $jobs;
    public $name;
    public $status;
    public $sdesc;
    public $sintime;
    public $list_json;
    public $_table = 'jl_change_audit';
    public $_primarykey = 'id';
    public $_fields = array('id', 'pid', 'stid', 'pmid', 'cid', 'times', 'usite', 'usort', 'uid', 'company', 'jobs', 'name', 'status', 'sdesc', 'sintime', 'list_json');

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

    public function insertChangeAudit($auditArray,$status,$sort,$time = '')
    {
        $this->pid = $auditArray['pid'];
        $this->stid = $auditArray['stid'];
        $this->pmid = $auditArray['pmid'];
        $this->cid = $auditArray['cid'];
        $this->times = !empty($time) ? $time : $auditArray['times'];
        $this->usite = $auditArray['usite'];
        $this->usort = $sort;
        $this->uid = $auditArray['uid'];
        $this->company = $auditArray['company'];
        $this->jobs = $auditArray['jobs'];
        $this->jobs = $auditArray['jobs'];
        $this->name = $auditArray['name'];
        $this->status = $status;
        $this->insert();
    }

    public function getOneChangeAudit($uid,$cid,$times)
    {
        return $this->getOne(array('where' => 'cid=? and uid=? and times=? and usite!=0', 'desc' => 'usort', 'param' => array($cid,$uid,$times), 'asArray' => TRUE));
    }

    public function updateChangeAudit($uid,$cid,$times,$status,$desc,$time, $list = '')
    {
        $oneaudit = $this->getOneChangeAudit($uid,$cid,$times);

        $this->id = $oneaudit['id'];
        $this->status = $status;
        $this->sdesc = $desc;
        $this->sintime = $time;
        $this->list_json = $list;
        $this->update();
    }

    public function getChangeAuditsbycidtime($cid,$times)
    {
        return $this->find(array('where' => 'cid=? and times=? and usite!=0', 'groupby' => 'usite', 'asc' => 'usort', 'param' => array($cid,$times), 'asArray' => TRUE));
    }

    public function getChangeAuditbylastlist($cid,$times)
    {
        $sql = 'SELECT * FROM (SELECT MAX(usort) as ust FROM `jl_change_audit` WHERE cid='.$cid.' and times='.$times.' and usite!=0 GROUP BY usite ) as b JOIN `jl_change_audit` as a ON a.usort = b.ust WHERE cid='.$cid.' and times='.$times.' and usite!=0 ORDER BY usite';
        $query = Doo::db ()->query ( $sql );

        $result = $query->fetchAll ();

        return $result;
    }

    public function getChangeAuditsbycid($cid)
    {
        return $this->find(array('where' => 'cid=?', 'asc' => 'id', 'param' => array($cid), 'asArray' => TRUE));
    }

    public function getChangeAuditsbycidtimeWithout($cid,$times,$lastuid,$uid){
        return $this->find(array('where' => 'cid=? and times=? and usite!=0 and uid not in(?,?) and status="uncheck"', 'asc' => 'usort', 'param' => array($cid,$times,$lastuid,$uid), 'asArray' => TRUE));
    }

    public function getChangeAuditbycidsitetime($cid,$times,$sort)
    {
        return $this->getOne(array('where' => 'cid=? and times=? and usite=?', 'desc' => 'usort', 'param' => array($cid,$times,$sort), 'asArray' => TRUE));
    }
    //默认取最后一个审批人，site取0则取最后一个创建人
    public function getChangeAuditLastUser($cid,$site = 1)
    {
        $sql = $site == 0 ? ' and usite=0' : '';
        return $this->getOne(array('where' => 'cid=?'.$sql, 'desc' => 'usort', 'param' => array($cid), 'asArray' => TRUE));
    }

    public function deleteChangeAuditthisTime($cid,$times)
    {
        return $this->delete(array('where' => 'cid=? and times=? and usite!=0', 'param' => array($cid,$times)));
    }
}

?>