loadIniFile('modules/summary/orders.php'); $this->_title = $osC_Language->get('summary_orders_title'); $this->_title_link = osc_href_link_admin(FILENAME_DEFAULT, 'orders'); if ( osC_Access::hasAccess('orders') ) { $this->_setData(); } } /* Private methods */ function _setData() { global $osC_Database, $osC_Language; $this->_data = '' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' '; $Qorders = $osC_Database->query('select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from :table_orders o, :table_orders_total ot, :table_orders_status s where o.orders_id = ot.orders_id and ot.class = "total" and o.orders_status = s.orders_status_id and s.language_id = :language_id order by date_last_modified desc limit 6'); $Qorders->bindTable(':table_orders', TABLE_ORDERS); $Qorders->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL); $Qorders->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qorders->bindInt(':language_id', $osC_Language->getID()); $Qorders->execute(); while ( $Qorders->next() ) { $this->_data .= ' ' . ' ' . ' ' . ' ' . ' ' . ' '; } $this->_data .= ' ' . '

' . $osC_Language->get('summary_orders_table_heading_orders') . '	' . $osC_Language->get('summary_orders_table_heading_total') . '	' . $osC_Language->get('summary_orders_table_heading_date') . '	' . $osC_Language->get('summary_orders_table_heading_status') . '
' . osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, 'orders&oID=' . $Qorders->valueInt('orders_id') . '&action=save'), osc_icon('orders.png') . ' ' . $Qorders->valueProtected('customers_name')) . '	' . strip_tags($Qorders->value('order_total')) . '	' . osC_DateTime::getShort($Qorders->value('date_last_modified')) . '	' . $Qorders->value('orders_status_name') . '

'; $Qorders->freeResult(); } } ?>