<?php
/**
 * Class that operate on table 'm_finishingpayed'. Database Mysql.
 *
 * @author: http://phpdao.com
 * @date: 2014-09-07 16:06
 */
class MFinishingpayedMySqlExtDAO extends MFinishingpayedMySqlDAO{

	public function updatecondition($mFinishingpayed){
		$sql = 'UPDATE m_finishingpayed SET  del = ?,finishingPayedDate =?,userId=?,branchId=?
		        WHERE finishingPayedId = ?';

		$sqlQuery = new SqlQuery($sql);
		
		$sqlQuery->setNumber($mFinishingpayed->del);
		$sqlQuery->set($mFinishingpayed->finishingPayedDate);
		$sqlQuery->setNumber($mFinishingpayed->userId);
		$sqlQuery->setNumber($mFinishingpayed->branchId);
		$sqlQuery->setNumber($mFinishingpayed->finishingPayedId);
		return $this->executeUpdate($sqlQuery);
	}
	
	public function updatepayed($mFinishingpayed){
		$sql = 'UPDATE m_finishingpayed SET  payed = ?,finishingPayedDate =?,userId=?,branchId=? 
		        WHERE finishingPayedId = ?';

		$sqlQuery = new SqlQuery($sql);
		
		$sqlQuery->set($mFinishingpayed->payed);
		$sqlQuery->set($mFinishingpayed->finishingPayedDate);
		$sqlQuery->setNumber($mFinishingpayed->userId);
		$sqlQuery->setNumber($mFinishingpayed->branchId);
		$sqlQuery->setNumber($mFinishingpayed->finishingPayedId);
		
		return $this->executeUpdate($sqlQuery);
	}
	
	
	public function getPaymentsDataEX($clientId,$Ids){
		$sql = 'SELECT  finishingPayedId,payed,remain,finishingType
				FROM m_finishingpayed
				WHERE clientId = '.$clientId.'
				AND finishingPayedId NOT IN('.$Ids.')
				AND del=0 
				AND finishingType!=1
				ORDER BY payed ';
		$sqlQuery = new SqlQuery($sql);
		//print_r($sqlQuery);
		return $this->getList($sqlQuery);
	}
	
	public function updateFinishingPayedType($finishingType,$remain,$finishingPayedId){
		$sql = 'UPDATE m_finishingpayed SET finishingType = ?,remain = ? WHERE finishingPayedId = ?';
		$sqlQuery = new SqlQuery($sql);
	
		$sqlQuery->setNumber($finishingType);
		$sqlQuery->setNumber($remain);
		$sqlQuery->setNumber($finishingPayedId);
		return $this->executeUpdate($sqlQuery);
	}
}
?>