loadIniFile('modules/summary/products.php'); $this->_title = $osC_Language->get('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 .= ' ' . ' ' . ' ' . ' ' . ' ' . ' '; } $this->_data .= ' ' . '

' . $osC_Language->get('summary_products_table_heading_products') . '	' . $osC_Language->get('summary_products_table_heading_price') . '	' . $osC_Language->get('summary_products_table_heading_date') . '	' . $osC_Language->get('summary_products_table_heading_status') . '
' . osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, 'products&pID=' . $Qproducts->valueInt('products_id') . '&action=save'), osc_icon('products.png') . ' ' . $Qproducts->value('products_name')) . '	' . $osC_Currencies->format($Qproducts->value('products_price')) . '	' . osC_DateTime::getShort($Qproducts->value('date_last_modified')) . '	' . osc_icon(($Qproducts->valueInt('products_status') === 1) ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif', null, null) . '

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