cld/protected/model/cld/longle_log_cld.php

<?php

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

class longle_log_cld extends DooModel {
	
	public $logid;
	public $status;
	public $statusT;
	public $lid;
	public $sell_client;
	public $client;
	public $clientid;
	public $responsible;
	public $operator;
	public $product_id;
	public $product;
	public $category;
	public $new_key_num;
	public $mark;
	public $dateline;
	
	public $_table = 'CLD_longlelog';
	public $_primarykey = 'logid';
	public $_fields = array ('logid','lid', 'status','statusT', 'sell_client', 'client','clientid','responsible','operator','product_id','product','category','new_key_num','mark','dateline' );
	
// 	TODO 2021-01-22年软件锁日志表加入记录时间
// 	以后的统计时间开始是2021-01-23开始-方法待完成
	public function GetSoftwareCountByUsername($data){
		
		$startYear=$data['year']."-01-01";
		$endYear=$data['year']."-12-31";
		
		"dateline>='".startYear."' and dateline<='".endYear."'";
		
		$sql = "  operator = ? and status=? and untreadStatus=?  and isDelete=0 ";
		$list = $this->find ( array (
				'where' => $sql,
				'param' => array (
						$trainId ,
						$status,
						$untreadStatus
				),
				'asArray' => TRUE
		) );
		return $list;
	}
	
	public function getLongleByLid($lid){
		return $this->find ( array ('where' => "lid= '".$lid."'", 'desc' => 'logid', 'asArray' => TRUE ) );
	}
	
	public function getLongleByName($name){
		return $this->find ( array ('where' => "new_key_num= '".$name."'", 'desc' => 'logid', 'asArray' => TRUE ) );
	}
	
	public function getUser() {
		return $this->find ( array ('asc' => 'uid', 'asArray' => TRUE ) );
	}

	public function getUserByIdList($puid){
		return $this->find ( array ('where' => "uid= '".$puid."'", 'asArray' => TRUE ) );
	}
	
}

?>