<?php
namespace Report\Report;


/**
 * Valuation Report.
 * @author andre.fourie
 */
class AdminValuation extends \Utility\Service\Report
{
	/**
	 * @var string
	 */
	protected $_title  = 'Valuation Report';
	/**
	 * @var string
	 */
	protected $_subject = 'Valuations';
	/**
	 * @var string
	 */
	protected $_description = 'Historical report for valuations.';
	/**
	 * @var array
	 */
	protected $_notes = array(
			'Confidential information, generated using Bid 4 Cars, for more information visit bid4cars.com.na'
	);
	/**
	 * @var array
	 */
	protected $_headers = array(
			'Group',
			'Division',
			'Dealer',
			'Customer Name',
			'Customer Surname',
			'Customer Phone Number',
			'Registration Number',
			'Make',
			'Model',
			'Type',
			'MM Code',
			'Year',
			'KM',
			'Trade Price',
			'List Price',
			'Recon costs',
			'Price Offered to Sales',
			'% of Trade',
			'Date created',
			'Creator',
			'Sent to Sales',
			'Sales Person',
			'Manager',
			'Comments',
            'Status',
            'Deal Not Done',
            'Reason',
            'Sent To Stock From'
			);
	/**
	 * @var array
	 */
	protected $_fields = array(
			'companyGroup_name',
			'companyDivision_name',
			'company_name',
			'valuation_firstName',
			'valuation_familyName',
			'valuation_mobile',
			'stock_registrationNumber',
			'make_name',
			'model_name',
			'type_name',
			'type_mmCode',
			'vehicleYear_name',
			'stock_km',
			'stock_tradePrice',
            'stock_listPrice',
			'stock_damageTotal',
			'valuation_amountOffered',
			'percentage_trade',
			'valuation_created',
			'createdBy_fullName',
			'valuation_sentToSales',
			'sales_person',
			'manager',
			'valuation_salesComments',
            'valuation_jobState',
            'dealNotDoneSelection_name',
            'valuation_dealNotDoneReason',
            'sendToStockFrom_name'
			);
	/**
	 * @var array
	 */
	protected $_totals = array(
			'stock_tradePrice',
            'stock_listPrice',
			'stock_damageTotal',
			'stock_highestOffer',
			'valuation_amountOffered'
			);
	/**
	 * @var array
	 */
	protected $_currencyFields = array(
			'stock_tradePrice',
            'stock_listPrice',
			'stock_damageTotal',
			'stock_highestOffer',
			'valuation_amountOffered'
			);



	/**
	 * Build the dataset.
	 */
	public function build()
	{
		#-> Prepare parameters.
		$selection = array(
				'valuation', 'stock', 'createdBy', 'company', 'type', 'model', 'make',
				'vehicleYear', 'salesProfile', 'managerProfile', 'companyGroup', 'companyDivision',
                'sendToStockFrom', 'dealNotDoneSelection'
		);
		$where     = array();
		$params    = array();
		$query = 'SELECT [SELECTION] '
				. 'FROM \Valuation\Entity\Valuation valuation '
				. 'JOIN valuation.stock stock '
				. 'JOIN valuation.createdBy createdBy '
				. 'JOIN stock.company company '
				. 'JOIN stock.vehicleYear vehicleYear '
				. 'JOIN stock.type type '
				. 'JOIN type.model model '
				. 'JOIN model.make make '
				. 'LEFT JOIN valuation.salesProfile salesProfile '
				. 'LEFT JOIN valuation.managerProfile managerProfile '
				. 'LEFT JOIN company.group companyGroup '
				. 'LEFT JOIN company.groupDivision companyDivision '
                . 'LEFT JOIN valuation.sendToStockFrom sendToStockFrom '
                . 'LEFT JOIN valuation.dealNotDoneSelection dealNotDoneSelection '
				. '[WHERE] '
				. 'ORDER BY valuation.created ASC';

		#-> Construct details.
		if (isset($this->_input['dateFrom']) && !empty($this->_input['dateFrom']))
		{
			$this->_queries['Date Range From'] = $this->_input['dateFrom'];
			$where[] = 'valuation.created >= :dateFrom';
			$params['dateFrom'] = new \DateTime($this->_input['dateFrom']);
		}
		if (isset($this->_input['dateTo']) && !empty($this->_input['dateTo']))
		{
			$this->_queries['Date Range Until'] = $this->_input['dateTo'];
			$where[] = 'valuation.created <= :dateTo';
			$params['dateTo'] = new \DateTime($this->_input['dateTo'] . ' 23:59:59');
		}
		if (isset($this->_input['group'])
				&& !empty($this->_input['group'])
				&& 'null' != $this->_input['group'])
		{
			$this->_queries['Group'] = $this->em
				->find('\Company\Entity\Group', $this->_input['group'])
				->name;
			$where[] = 'companyGroup.id = :group';
			$params['group'] = $this->_input['group'];
		}
		if (isset($this->_input['groupDivision'])
				&& !empty($this->_input['groupDivision'])
				&& 'null' != $this->_input['groupDivision'])
		{
			$this->_queries['Division'] = $this->em
				->find('\Company\Entity\GroupDivision', $this->_input['groupDivision'])
				->name;
			$where[] = 'companyDivision.id = :division';
			$params['division'] = $this->_input['groupDivision'];
		}
		if (isset($this->_input['company'])
				&& !empty($this->_input['company'])
				&& 'null' != $this->_input['company'])
		{
			$this->_queries['Dealership'] = $this->em
				->find('\Company\Entity\Company', $this->_input['company'])
				->name;
			$where[] = 'company.id = :company';
			$params['company'] = $this->_input['company'];
		}

		#-> Finalize query.
		$query = str_replace(array(
				'[SELECTION]', '[WHERE]'
			), array(
				implode(', ', $selection) . ' ',
				!empty($where)
					? 'WHERE ' . implode(' AND ', $where) . ' '
					: ' '
			), $query);

		#-> Collect data.
		$query = $this->em->createQuery($query);
		!empty($params)
			&& $query->setParameters($params);

		$this->_data = $query->getScalarResult();
		$this->em->clear();

		foreach ($this->_data as $rowId => $rowData)
		{
//            \Utility\Debug::errorLog('$rowId', $rowId);
//            \Utility\Debug::errorLog('$rowData', $rowData);

			$this->_data[$rowId]['createdBy_fullName'] = $rowData['createdBy_firstName'] . ' ' . $rowData['createdBy_familyName'];
			$this->_data[$rowId]['sales_person'] = isset($rowData['salesProfile_firstName'])
													&& !empty($rowData['salesProfile_firstName'])
				? $rowData['salesProfile_firstName'] . ' ' . $rowData['salesProfile_familyName']
				: '';
			$this->_data[$rowId]['manager'] = isset($rowData['managerProfile_firstName'])
													&& !empty($rowData['managerProfile_firstName'])
				? $rowData['managerProfile_firstName'] . ' ' . $rowData['managerProfile_familyName']
				: '';
			if ($this->_data[$rowId]['stock_tradePrice'] == 0)
			{
				$this->_data[$rowId]['percentage_trade'] = '0 %';
			}
			else
			{
				$this->_data[$rowId]['percentage_trade'] = round(($this->_data[$rowId]['valuation_amountOffered'] * 100) / $this->_data[$rowId]['stock_tradePrice']) . ' %' ;
			}
		}
	}

}