function recursiveRender()
{
$inv = $this->add('xepan\\commerce\\Model_SalesInvoice');
$inv->setOrder('due_date', 'asc');
$inv->addCondition('status', 'Due');
$inv_count = $inv->count()->getOne();
$this->view->template->trySet('count', $inv_count);
$this->view->template->trySet('title', 'Unpaid Invoices');
$this->view->template->trySet('icon-class', 'fa fa-shopping-cart');
$this->view->js('click')->_selector('#' . $this->view->name)->univ()->frameURL("Unpaid Invoice", $this->api->url('xepan_commerce_salesinvoice', ['status' => 'Due']));
return Parent::recursiveRender();
}
function recursiveRender()
{
$odr = $this->add('xepan\\commerce\\Model_SalesOrder');
$odr->setOrder('due_date', 'asc');
$odr->addCondition('status', 'OnlineUnpaid');
$odr_count = $odr->count()->getOne();
$this->view->template->trySet('count', $odr_count);
$this->view->template->trySet('title', 'Online Unpaid Orders');
$this->view->template->trySet('icon-class', 'fa fa-shopping-cart');
$this->view->js('click')->_selector('#' . $this->view->name)->univ()->frameURL("Unpaid Orders", $this->api->url('xepan_commerce_salesorder', ['status' => 'OnlineUnpaid']));
return Parent::recursiveRender();
}
function recursiveRender()
{
$customer = $this->add('xepan\\commerce\\Model_Customer');
$customer->addExpression('online_unpaid_order')->set($customer->refSQL('QSPMaster')->addCondition('status', 'OnlineUnpaid')->count());
$customer->addCondition('online_unpaid_order', '>', 0);
$count = $customer->count()->getOne();
$this->view->template->trySet('count', $count);
$this->view->template->trySet('title', 'Online Unpaid Customers');
$this->view->template->trySet('icon-class', 'fa fa-user');
$this->view->js('click')->_selector('#' . $this->view->name)->univ()->frameURL("Online Unpaid Customers", $this->api->url($this->customer_v_page->getUrl()));
return Parent::recursiveRender();
}
function recursiveRender()
{
$so = $this->add('xepan\\commerce\\Model_SalesOrder');
$so->setOrder('created_at', 'desc');
if (isset($this->report->start_date)) {
$so->addCondition('created_at', '>', $this->report->start_date);
}
if (isset($this->report->end_date)) {
$so->addCondition('created_at', '<', $this->app->nextDate($this->report->end_date));
}
$this->grid->setModel($so);
$this->grid->template->trySet('heading', 'Due Orders');
$this->grid->addPaginator('5');
return Parent::recursiveRender();
}
function recursiveRender()
{
$inv = $this->add('xepan\\commerce\\Model_SalesInvoice');
$inv->setOrder('due_date', 'asc');
$inv->addCondition('status', 'Due');
if (isset($this->report->start_date)) {
$inv->addCondition('created_at', '>', $this->report->start_date);
}
if (isset($this->report->end_date)) {
$inv->addCondition('created_at', '<', $this->app->nextDate($this->report->end_date));
}
$this->grid->setModel($inv);
$this->grid->template->trySet('heading', 'Due Invoices');
$this->grid->addPaginator(5);
return Parent::recursiveRender();
}
function recursiveRender()
{
$start_date = $this->report->start_date;
$end_date = $this->app->nextDate($this->report->end_date);
$salesinvoice_m = $this->add('xepan\\commerce\\Model_SalesInvoice');
$salesinvoice_m->setOrder('created_at', 'desc');
$salesinvoice_m->addExpression('monthyear')->set('DATE_FORMAT(created_at,"%M %Y")');
$salesinvoice_m->addExpression('count', 'count(*)');
$salesinvoice_m->_dsql()->group('monthyear');
if ($this->report->start_date) {
$salesinvoice_m->addCondition('created_at', '>=', $start_date);
}
if ($this->report->end_date) {
$salesinvoice_m->addCondition('created_at', '<=', $end_date);
}
$this->grid->setModel($salesinvoice_m);
$this->grid->addPaginator('5');
$this->grid->js('click')->_selector('.xepan-invoice-count')->univ()->frameURL('Invoice', [$this->api->url('xepan_commerce_salesinvoice'), 'from_date' => $start_date, 'to_date' => $end_date, 'monthyear' => $this->js()->_selectorThis()->closest('[data-id]')->data('id')]);
return Parent::recursiveRender();
}
