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 $trainId;
	public $trainLoanRid;
	public $invoiceTrainId;
	
	
	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',
			'trainId',
			'trainLoanRid',
			'invoiceTrainId'
	);
	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['trainLoanRidKey']=$XDeode->encode ( $rinfo ['trainLoanRid'] );
		$XDeode = new XDeode ( 7 );
		$rinfo['ridKey7']=$XDeode->encode ( $rinfo ['rid'] );
		
		$rinfo['category']=$Lcategory->getCategoryById($rinfo['cid']);
		$rinfo['staffDetail']=$staff->getStaffBySid($rinfo['staff']);
		
		//$rinfo['sum']=number_format ($rinfo['sum'],2);
		
		return $rinfo;
	}
	
	function getReceiptByinvoiceTrainId($invoiceTrainId = '') {
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
	
		Doo::loadModel ( 'L_category' );
		$Lcategory = new L_category ();
		Doo::loadModel ( 'staff' );
		$staff = new staff ();
	
		if (! is_numeric ( $invoiceTrainId ))
			$invoiceTrainId = $XDeode->decode ( $invoiceTrainId );
	
	
			$rinfo = $this->getOne ( array (
					'where' => 'invoiceTrainId=' . $invoiceTrainId,
					'asArray' => true
			) );
	
			if (empty($rinfo)){
				return array();
			}
			
			$rinfo['ridKey']=$XDeode->encode ( $rinfo ['rid'] );
			$rinfo['trainLoanRidKey']=$XDeode->encode ( $rinfo ['trainLoanRid'] );
			$XDeode = new XDeode ( 7 );
			$rinfo['ridKey7']=$XDeode->encode ( $rinfo ['rid'] );
	
			$rinfo['category']=$Lcategory->getCategoryById($rinfo['cid']);
			$rinfo['staffDetail']=$staff->getStaffBySid($rinfo['staff']);
	
			return $rinfo;
	}
	
	
	/**
	 * 默认获得10条
	 * @param unknown $sid
	 * @param unknown $cid
	 * @param unknown $limit
	 */
	function getReceiptLoanByStatus($sid,$cid,$status,$limit=10){
		$sql='';
		if ($sid!==false&&is_numeric($sid)){
			$sql.=' and staff='.$sid;
		}
		if ($cid!==false&&is_numeric($cid)){
			$sql.=' and cid='.$cid;
		}
		
		$list = $this->find ( array (
				'where' => 'Rtype=1 and status=' . $status.$sql,
				'asArray' => true
		) );
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		foreach ($list as $key=>$value){
			$list[$key]['ridKey']=$XDeode->encode ( $list[$key] ['rid'] );
		}
		return $list;
	}
	
	/**
	 * 获得需要记录流水的费用
	 * @param unknown $status
	 * @return string
	 */
	function getReceiptByWaste(){
		
		$list = $this->find ( array (
				'where' => 'status=2 or status=6 or status=1',
				'asArray' => true
		) );
		Doo::loadClass ( 'XDeode' );
		$XDeode = new XDeode ( 5 );
		$XDeode7 = new XDeode ( 7 );
		Doo::loadModel ( 'wasteBook' );
		$wasteBook = new wasteBook ();
		
		$accountType=0;
		foreach ($list as $key=>$value){
			$list[$key]['ridKey7']=$XDeode7->encode ( $list[$key] ['rid'] );
			$list[$key]['ridKey']=$XDeode->encode ( $list[$key] ['rid'] );
			
			if ($list[$key] ['Rtype']==0){
				$accountType=3;
			}elseif ($list[$key] ['Rtype']==1){
				if($list[$key] ['Rtype']==0){
					$accountType=1;
				}elseif($list[$key] ['Rtype']==1){
					$accountType=2;
				}
			}elseif ($list[$key] ['Rtype']==2){
				$accountType=4;
			}elseif ($list[$key] ['Rtype']==3){
				$accountType=12;
			}
			//是否已经生成流水
			$wbDetail=array();
			if (!empty($accountType)){
				$wbDetail=$wasteBook->getWateBookByAD($accountType,$list[$key] ['rid']);
				if (!empty($wbDetail)){
					unset($list[$key]);
				}
			}else{
				unset($list[$key]);
			}
		}
		return $list;
	}
	
	/**
	 * 根据参数字段更新相应字段（主键ID必须传）
	 * @param array $item 相关需要更新的字段信息
	 * @return number 返回发票ID
	 */
	public function setReceiptByCondition($item = array(), $rid = "") {
		$lid = 0;
	
		if (is_array ( $item ) && ! empty ( $item )) {
			foreach ( $item as $key => $value ) {
				$this->$key = $value;
			}
				
			if (! empty ( $isid )) {
				$condition = array (
						'where' => "rid in (" . $rid . ")",
						'asArray' => TRUE
				);
				$this->update ( $condition );
			} else
				$lid = $this->update ();
		}
		return $lid;
	}
	
}

?>