<?php
/**
 * Class that operate on table 'dailyentrydebtor'. Database Mysql.
 *
 * @author: http://phpdao.com
 * @date: 2016-04-04 09:53
 */
class DailyentrydebtorMySqlExtDAO extends DailyentrydebtorMySqlDAO{

	public function queryByDailyentryidEX($value){
		$sql = 'SELECT dailyentrydebtor.* ,concat(dailyentrydebtor.accountstreeid,"-",accountstree.name) as accountstreeName
		FROM dailyentrydebtor 
		join accountstree on accountstree.id = dailyentrydebtor.accountstreeid
		WHERE dailyentryid = ?';
		$sqlQuery = new SqlQuery($sql);
		$sqlQuery->setNumber($value);
		return $this->getList($sqlQuery);
	}
}
?>