/**
* Check if the order become from an upgrade
*
* @param integer $orderid
*/
public static function isUpgrade($orderid)
{
$orderDetails = Orders::getDetails($orderid);
foreach ($orderDetails as $orderDetail) {
$parent_orderid = intval($orderDetail['parent_orderid']);
if ($parent_orderid != 0) {
return $parent_orderid;
}
}
return false;
}
private function orderdetailGrid()
{
$request = $this->getRequest();
if (isset($request->id) && is_numeric($request->id)) {
$rs = Orders::getDetails($request->id, "detail_id,\n\t\t\t DATE_FORMAT(d.date_start, '" . Settings::getMySQLDateFormat('dateformat') . "') as date-start,\n\t\t\t DATE_FORMAT(d.date_end, '" . Settings::getMySQLDateFormat('dateformat') . "') as date-end,\n\t\t\t d.quantity, \n\t\t\t\t\t\t\t\t d.description, \n\t\t\t d.setupfee, \n\t\t\t CONCAT(d.discount, ' %') as discount, \n\t\t\t\t\t\t\t\t d.price, \n\t\t d.vat,\n\t\t\t\t\t\t\t\t d.subtotal,\n\t\t\t CONCAT(dm.domain, '.',ws.tld) as domain");
if (isset($rs)) {
$columns = array();
$columns[] = $this->translator->translate('Quantity');
$columns[] = $this->translator->translate('Description');
$columns[] = $this->translator->translate('Setup fees');
$columns[] = $this->translator->translate('Price');
$columns[] = $this->translator->translate('VAT');
$columns[] = $this->translator->translate('Subtotal');
$columns[] = $this->translator->translate('Start data');
$columns[] = $this->translator->translate('End data');
$columns[] = $this->translator->translate('Discount');
$columns[] = $this->translator->translate('Domain');
return array('columns' => $columns, 'records' => $rs, 'delete' => array('controller' => 'ordersitems', 'action' => 'confirm'), 'edit' => array('controller' => 'ordersitems', 'action' => 'edit'), 'actions' => array('/admin/services/edit/id/' => $this->translator->translate('Service')), 'pager' => true);
}
}
}
