cld/protected/model/receipt.php

<?php
Doo::loadCore ( 'db/DooModel' );
class receipt extends DooModel {
	public $rid;
	public $accountItem;
	public $loanItem;
	public $staff;
	public $sum;
	public $date;
	public $pastDate;
	public $executeDate;
	public $loanDate;
	public $cid;
	public $status;
	public $Rtype;
	public $isBK;
	public $loanSum;
	public $loanRid;
	public $reviseDetail;
	public $revisePrice;
	public $receiptOrder;
	public $verify;
	public $verifyStaff;
	public $executeCopy;
	public $executeStaff;
	public $verifyBreakup;
	public $nowStaff;
	public $explanation;
	public $implementOpinions;
	public $notice;
	public $amount;
	public $remittanceName;
	public $bankName;
	public $bankNumber;
	public $coupletNumber;
	public $remittanceBankType;
	public $_table = 'CLD_receipt';
	public $_primarykey = 'rid';
	public $_fields = array (
			'aid',
			'accountItem',
			'staff',
			'sum',
			'date',
			'pastDate',
			'cid',
			'status',
			'reviseDetail',
			'revisePrice',
			'verify',
			'verifyStaff',
			'nowStaff',
			'receiptOrder',
			'explanation',
			'notice',
			'Rtype',
			'loanItem',
			'loanRid',
			'loanSum',
			'implementOpinions',
			'isBK',
			'executeCopy',
			'executeStaff',
			'verifyBreakup',
			'executeDate',
			'amount',
			'loanDate',
			'remittanceName',
			'bankName',
			'bankNumber',
			'coupletNumber',
			'remittanceBankType' 
	);
	function receiptByYear($dateCondition, $sid) {
		$sql = "select sum(sum) as sum from " . $this->_table . " where staff= '" . $sid . "' " . $dateCondition . " and status=2 ";
		// echo '<div style="display:none">'.$sql.'</div>';
		$query = Doo::db ()->query ( $sql );
		$result = $query->fetch ();
		
		return $result;
	}
	function getReceiptBySid($sid = '', $year = '', $month = '') {
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		
		if (empty ( $sid ))
			return array ();
		$sql = 'select a.*
				from ' . $this->_table . ' as a left join CLD_receiptDetail as b on b.rid=a.rid
				where b.staff =' . $sid . ' and Month(b.pastDate)=' . $month . ' and Year(b.pastDate)=' . $year . ' and b.status=1
				GROUP BY b.rid';
		
		$query = Doo::db ()->query ( $sql );
		$list = $query->fetchAll ();
		
		foreach ( $list as $key => $value ) {
			$list [$key] ['ridKey'] = $XDeode->encode ( $value ['rid'] );
		}
		return $list;
	}
	function getReceiptByRid($rid = '') {
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		
		Doo::loadModel ( 'L_category' );
		$Lcategory = new L_category ();
		Doo::loadModel ( 'staff' );
		$staff = new staff ();
		
		if (! is_numeric ( $rid ))
			$rid = $XDeode->decode ( $rid );
		
		
		$rinfo = $this->getOne ( array (
				'where' => 'rid=' . $rid,
				'asArray' => true 
		) );
		
		$rinfo['ridKey']=$XDeode->encode ( $rinfo ['rid'] );
		
		$rinfo['category']=$Lcategory->getCategoryById($rinfo['cid']);
		$rinfo['staffDetail']=$staff->getStaffBySid($rinfo['staff']);
		
		return $rinfo;
	}
	
	
}

?>