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