function display($tpl = null)
{
$task = JRequest::getWord('task');
TOOLBAR_enmasse::_SMENU();
$nNumberOfDeals = JModel::getInstance('deal', 'enmasseModel')->countAll();
if ($nNumberOfDeals == 0) {
TOOLBAR_enmasse::_DEAL_EMPTY();
} else {
TOOLBAR_enmasse::_SALE_REPORTS();
}
$filter = JRequest::getVar('filter');
$filter['code'] = isset($filter['code']) ? $filter['code'] : '';
$filter['name'] = isset($filter['name']) ? $filter['name'] : '';
$filter['saleperson_id'] = isset($filter['saleperson_id']) ? $filter['saleperson_id'] : '';
$filter['merchant_id'] = isset($filter['merchant_id']) ? $filter['merchant_id'] : '';
$filter['fromdate'] = isset($filter['fromdate']) ? $filter['fromdate'] : '';
$filter['todate'] = isset($filter['todate']) ? $filter['todate'] : '';
$currency_prefix = JModel::getInstance('setting', 'enmasseModel')->getCurrencyPrefix();
$dealList = JModel::getInstance('salereports', 'enmasseModel')->search($filter['code'], $filter['name'], $filter['saleperson_id'], $filter['merchant_id'], $filter['fromdate'], $filter['todate']);
/// load pagination
$pagination = JModel::getInstance('salereports', 'enmasseModel')->getPagination($filter['code'], $filter['name'], $filter['saleperson_id'], $filter['merchant_id'], $filter['fromdate'], $filter['todate']);
$state = $this->get('state');
for ($i = 0; $i < count($dealList); $i++) {
$dealCategoryIdList = JModel::getInstance('dealcategory', 'enmasseModel')->getCategoryByDealId($dealList[$i]->id);
$dealLocationIdList = JModel::getInstance('deallocation', 'enmasseModel')->getLocationByDealId($dealList[$i]->id);
//----------------------------------------------
// get list of category name
if (count($dealCategoryIdList) != 0) {
$categoryList = JModel::getInstance('category', 'enmasseModel')->getCategoryListInArrId($dealCategoryIdList);
} else {
$categoryList = null;
}
//----------------------------------------------
// get list of location name
if (count($dealLocationIdList) != 0) {
$locationList = JModel::getInstance('location', 'enmasseModel')->getLocationListInArrId($dealLocationIdList);
} else {
$locationList = null;
}
if (count($locationList) != 0 && $locationList != null) {
$dealList[$i]->location_name = $locationList;
} else {
$dealList[$i]->location_name = null;
}
if (count($categoryList) != 0 && $categoryList != null) {
$dealList[$i]->category_name = $categoryList;
} else {
$dealList[$i]->category_name = null;
}
$dealList[$i]->sales_person_name = JModel::getInstance('salesPerson', 'enmasseModel')->retrieveName($dealList[$i]->sales_person_id);
$dealList[$i]->merchant_name = JModel::getInstance('merchant', 'enmasseModel')->retrieveName($dealList[$i]->merchant_id);
}
$this->assignRef('filter', $filter);
$this->statusList = EnmasseHelper::$DEAL_STATUS_LIST;
$this->salePersonList = JModel::getInstance('salesPerson', 'enmasseModel')->listAllPublished();
$this->merchantList = JModel::getInstance('merchant', 'enmasseModel')->listAllPublished();
$this->assignRef('dealList', $dealList);
$this->assignRef('pagination', $pagination);
$this->assignRef('order', $order);
$this->assignRef('currency_prefix', $currency_prefix);
parent::display($tpl);
}
