public function getAll($uuid) { $this->authenticate(); $customers = Customers::findWithUuid($uuid); if (empty($customers)) { throw new Shineisp_Api_Exceptions(400006, ":: 'uuid' not valid"); exit; } $id = $customers['customer_id']; $fields = " o.order_id,o.grandtotal as grandtotal,s.status as status,\n DATE_FORMAT(o.order_date, '%d/%m/%Y') as orderdate, \n DATE_FORMAT(o.expiring_date, '%d/%m/%Y') as expiringdate,\n o.is_renewal as is_renewal, i.number as invoice,\n c.firstname,c.lastname,c.company"; return Orders::getOrdersByCustomerID($id, $fields); }
private function ordersGrid() { $request = Zend_Controller_Front::getInstance()->getRequest(); if (isset($request->id) && is_numeric($request->id)) { $rs = Orders::getOrdersByCustomerID($request->id, "o.order_id, o.order_id as order, o.order_number as order_number, in.formatted_number as invoice, DATE_FORMAT(o.order_date, '%d/%m/%Y') as date, o.grandtotal as total"); if (isset($rs)) { $columns[] = $this->translator->translate('ID'); $columns[] = $this->translator->translate('Number'); $columns[] = $this->translator->translate('Invoice No.'); $columns[] = $this->translator->translate('Date'); $columns[] = $this->translator->translate('Total'); return array('name' => 'orders', 'columns' => $columns, 'records' => $rs, 'edit' => array('controller' => 'orders', 'action' => 'edit')); } } }