loadConstants('modules/summary/products.php'); } class osC_Summary_products extends osC_Summary { /* Class constructor */ function osC_Summary_products() { $this->_title = MODULE_SUMMARY_PRODUCTS_TITLE; $this->_title_link = osc_href_link_admin(FILENAME_DEFAULT, 'products'); if ( osC_Access::hasAccess( 'products' ) ) { $this->_setData(); } } /* Private methods */ function _setData() { global $osC_Database, $osC_Language, $osC_Currencies; if (!isset($osC_Currencies)) { if (!class_exists('osC_Currencies')) { include('../includes/classes/currencies.php'); } $osC_Currencies = new osC_Currencies(); } $this->_data = '' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' '; $Qproducts = $osC_Database->query('select p.products_id, pd.products_name, p.products_price, greatest(p.products_date_added, p.products_last_modified) as date_last_modified, p.products_status from :table_products p, :table_products_description pd where p.products_id = pd.products_id and pd.language_id = :language_id order by date_last_modified desc, pd.products_name limit 6'); $Qproducts->bindTable(':table_products', TABLE_PRODUCTS); $Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); $Qproducts->bindInt(':language_id', $osC_Language->getID()); $Qproducts->execute(); while ($Qproducts->next()) { $this->_data .= ' ' . ' ' . ' ' . ' ' . ' ' . ' '; } $Qproducts->freeResult(); $this->_data .= ' ' . '

' . MODULE_SUMMARY_PRODUCTS_HEADING_PRODUCTS . '	' . MODULE_SUMMARY_PRODUCTS_HEADING_PRICE . '	' . MODULE_SUMMARY_PRODUCTS_HEADING_DATE . '	' . MODULE_SUMMARY_PRODUCTS_HEADING_STATUS . '
' . osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, 'products&pID=' . $Qproducts->valueInt('products_id') . '&action=new'), osc_icon('products.png', ICON_PREVIEW) . ' ' . $Qproducts->value('products_name')) . '	' . $osC_Currencies->format($Qproducts->value('products_price')) . '	' . $Qproducts->value('date_last_modified') . '	' . osc_icon(($Qproducts->valueInt('products_status') === 1) ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif', null, null) . '

'; } } ?>