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(); }