public function __construct()
{
Registry::get('Language')->loadIniFile('modules/Dashboard/Customers.php');
$this->_title = OSCOM::getDef('admin_indexmodules_customers_title');
$this->_title_link = OSCOM::getLink(null, 'Customers');
if (Access::hasAccess(OSCOM::getSite(), 'Customers')) {
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' . ' <thead>' . ' <tr>' . ' <th>' . OSCOM::getDef('admin_indexmodules_customers_table_heading_customers') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_customers_table_heading_date') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_customers_table_heading_status') . '</th>' . ' </tr>' . ' </thead>' . ' <tbody>';
$Qcustomers = Registry::get('Database')->query('select customers_id, customers_gender, customers_lastname, customers_firstname, customers_status, date_account_created from :table_customers order by date_account_created desc limit 6');
$Qcustomers->execute();
$counter = 0;
while ($Qcustomers->next()) {
$customer_icon = osc_icon('people.png');
if (ACCOUNT_GENDER > -1) {
switch ($Qcustomers->value('customers_gender')) {
case 'm':
$customer_icon = osc_icon('user_male.png');
break;
case 'f':
$customer_icon = osc_icon('user_female.png');
break;
}
}
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' . ' <td>' . osc_link_object(OSCOM::getLink(null, 'Customers', 'cID=' . $Qcustomers->valueInt('customers_id') . '&action=save'), $customer_icon . ' ' . $Qcustomers->valueProtected('customers_firstname') . ' ' . $Qcustomers->valueProtected('customers_lastname')) . '</td>' . ' <td>' . $Qcustomers->value('date_account_created') . '</td>' . ' <td align="center">' . osc_icon($Qcustomers->valueInt('customers_status') === 1 ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif', null, null) . '</td>' . ' </tr>';
$counter++;
}
$this->_data .= ' </tbody>' . '</table>';
}
}
public static function hasAccess($application)
{
if (!isset($_SESSION[OSCOM::getSite()]['id'])) {
$redirect = false;
if ($application != 'Login') {
$_SESSION[OSCOM::getSite()]['redirect_origin'] = $application;
$redirect = true;
}
if ($redirect === true) {
osc_redirect_admin(OSCOM::getLink(null, 'Login'));
}
}
return Access::hasAccess(OSCOM::getSite(), $application);
}
public function __construct()
{
Registry::get('Language')->loadIniFile('modules/Dashboard/Reviews.php');
$this->_title = OSCOM::getDef('admin_indexmodules_reviews_title');
$this->_title_link = OSCOM::getLink(null, 'Reviews');
if (Access::hasAccess(OSCOM::getSite(), 'Reviews')) {
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' . ' <thead>' . ' <tr>' . ' <th>' . OSCOM::getDef('admin_indexmodules_reviews_table_heading_products') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_reviews_table_heading_language') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_reviews_table_heading_rating') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_reviews_table_heading_date') . '</th>' . ' </tr>' . ' </thead>' . ' <tbody>';
$Qreviews = Registry::get('Database')->query('select r.reviews_id, r.products_id, greatest(r.date_added, greatest(r.date_added, r.last_modified)) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.code as languages_code from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by date_last_modified desc limit 6');
$Qreviews->execute();
$counter = 0;
while ($Qreviews->next()) {
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' . ' <td>' . osc_link_object(OSCOM::getLink(null, 'Reviews', 'rID=' . $Qreviews->valueInt('reviews_id') . '&action=save'), osc_icon('reviews.png') . ' ' . $Qreviews->value('products_name')) . '</td>' . ' <td align="center">' . Registry::get('Language')->showImage($Qreviews->value('languages_code')) . '</td>' . ' <td align="center">' . osc_image('../images/stars_' . $Qreviews->valueInt('reviews_rating') . '.png', $Qreviews->valueInt('reviews_rating') . '/5') . '</td>' . ' <td>' . $Qreviews->value('date_last_modified') . '</td>' . ' </tr>';
$counter++;
}
$this->_data .= ' </tbody>' . '</table>';
}
}
public function __construct()
{
Registry::get('Language')->loadIniFile('modules/Dashboard/Orders.php');
$this->_title = OSCOM::getDef('admin_indexmodules_orders_title');
$this->_title_link = OSCOM::getLink(null, 'Orders');
if (Access::hasAccess(OSCOM::getSite(), 'Orders')) {
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' . ' <thead>' . ' <tr>' . ' <th>' . OSCOM::getDef('admin_indexmodules_orders_table_heading_orders') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_orders_table_heading_total') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_orders_table_heading_date') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_orders_table_heading_status') . '</th>' . ' </tr>' . ' </thead>' . ' <tbody>';
$Qorders = Registry::get('Database')->query('select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, "1970-01-01")) 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->bindInt(':language_id', Registry::get('Language')->getID());
$Qorders->execute();
$counter = 0;
while ($Qorders->next()) {
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' . ' <td>' . osc_link_object(OSCOM::getLink(null, 'Orders', 'oID=' . $Qorders->valueInt('orders_id') . '&action=save'), osc_icon('orders.png') . ' ' . $Qorders->valueProtected('customers_name')) . '</td>' . ' <td>' . strip_tags($Qorders->value('order_total')) . '</td>' . ' <td>' . $Qorders->value('date_last_modified') . '</td>' . ' <td>' . $Qorders->value('orders_status_name') . '</td>' . ' </tr>';
$counter++;
}
$this->_data .= ' </tbody>' . '</table>';
}
}
public function __construct()
{
Registry::get('Language')->loadIniFile('modules/IndexModules/AdministratorsLog.php');
$this->_title = OSCOM::getDef('admin_indexmodules_administratorslog_title');
$this->_title_link = OSCOM::getLink(null, 'AdministratorsLog');
if (Access::hasAccess(OSCOM::getSite(), 'AdministratorsLog')) {
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' . ' <thead>' . ' <tr>' . ' <th>' . OSCOM::getDef('admin_indexmodules_administratorslog_table_heading_users') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_administratorslog_table_heading_module') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_administratorslog_table_heading_date') . '</th>' . ' </tr>' . ' </thead>' . ' <tbody>';
$Qlog = Registry::get('Database')->query('select count(al.id) as total, al.id, al.module, a.user_name, al.datestamp from :table_administrators_log al, :table_administrators a where al.module in (":modules") and al.administrators_id = a.id group by al.id order by al.id desc limit 6');
$Qlog->bindRaw(':modules', implode('", "', array_keys($_SESSION[OSCOM::getSite()]['access'])));
$Qlog->execute();
$counter = 0;
while ($Qlog->next()) {
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' . ' <td>' . osc_link_object(OSCOM::getLink(null, 'AdministratorsLog&lID=' . $Qlog->valueInt('id') . '&action=info'), osc_icon('log.png') . ' ' . $Qlog->valueProtected('user_name')) . '</td>' . ' <td>' . $Qlog->value('module') . ' (' . $Qlog->valueInt('total') . ')</td>' . ' <td>' . $Qlog->value('datestamp') . '</td>' . ' </tr>';
$counter++;
}
$this->_data .= ' </tbody>' . '</table>';
}
}
public function __construct()
{
Registry::get('Language')->loadIniFile('modules/IndexModules/ErrorLog.php');
$this->_title = OSCOM::getDef('admin_indexmodules_errorlog_title');
$this->_title_link = OSCOM::getLink(null, 'ErrorLog');
if (Access::hasAccess(OSCOM::getSite(), 'ErrorLog')) {
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' . ' <thead>' . ' <tr>' . ' <th>' . OSCOM::getDef('admin_indexmodules_errorlog_table_heading_date') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_errorlog_table_heading_message') . '</th>' . ' </tr>' . ' </thead>' . ' <tbody>';
if (ErrorHandler::getTotalEntries() > 0) {
$counter = 0;
foreach (ErrorHandler::getAll(6) as $row) {
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' . ' <td style="white-space: nowrap;">' . Registry::get('Template')->getIcon(16, 'errorlog.png') . ' ' . DateTime::getShort(DateTime::fromUnixTimestamp($row['timestamp']), true) . '</td>' . ' <td>' . osc_output_string_protected(substr($row['message'], 0, 60)) . '..</td>' . ' </tr>';
$counter++;
}
} else {
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');">' . ' <td colspan="2">' . osc_icon('tick.png') . ' ' . OSCOM::getDef('admin_indexmodules_errorlog_no_errors_found') . '</td>' . ' </tr>';
}
$this->_data .= ' </tbody>' . '</table>';
}
}
public function __construct()
{
Registry::get('Language')->loadIniFile('modules/Dashboard/Products.php');
$this->_title = OSCOM::getDef('admin_indexmodules_products_title');
$this->_title_link = OSCOM::getLink(null, 'Products');
if (Access::hasAccess(OSCOM::getSite(), 'Products')) {
if (!isset($osC_Currencies)) {
if (!class_exists('osC_Currencies')) {
include 'includes/classes/currencies.php';
}
$osC_Currencies = new osC_Currencies();
}
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' . ' <thead>' . ' <tr>' . ' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_products') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_price') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_date') . '</th>' . ' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_status') . '</th>' . ' </tr>' . ' </thead>' . ' <tbody>';
$Qproducts = Registry::get('PDO')->query('select products_id, greatest(products_date_added, products_last_modified) as date_last_modified from :table_products where parent_id is null order by date_last_modified desc limit 6');
$Qproducts->execute();
$counter = 0;
while ($Qproducts->fetch()) {
$data = osC_Products_Admin::get($Qproducts->valueInt('products_id'));
$products_icon = osc_icon('products.png');
$products_price = $data['products_price'];
if (!empty($data['variants'])) {
$products_icon = osc_icon('attach.png');
$products_price = null;
foreach ($data['variants'] as $variant) {
if ($products_price === null || $variant['data']['price'] < $products_price) {
$products_price = $variant['data']['price'];
}
}
if ($products_price === null) {
$products_price = 0;
}
}
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' . ' <td>' . osc_link_object(OSCOM::getLink(null, 'Products', 'id=' . (int) $data['products_id'] . '&action=save'), $products_icon . ' ' . osc_output_string_protected($data['products_name'])) . '</td>' . ' <td>' . (!empty($data['variants']) ? 'from ' : '') . $osC_Currencies->format($products_price) . '</td>' . ' <td>' . $Qproducts->value('date_last_modified') . '</td>' . ' <td align="center">' . osc_icon((int) $data['products_status'] === 1 ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif', null, null) . '</td>' . ' </tr>';
$counter++;
}
$this->_data .= ' </tbody>' . '</table>';
}
}
public static function hasAccess($application) {
return isset($_SESSION[OSCOM::getSite()]['id']) && Access::hasAccess(OSCOM::getSite(), $application);
}
public function __construct() {
$OSCOM_Language = Registry::get('Language');
$OSCOM_Language->loadIniFile('modules/Dashboard/Products.php');
$this->_title = OSCOM::getDef('admin_indexmodules_products_title');
$this->_title_link = OSCOM::getLink(null, 'Products');
if ( Access::hasAccess(OSCOM::getSite(), 'Products') ) {
if ( !Registry::exists('Currencies') ) {
Registry::set('Currencies', new Currencies());
}
$OSCOM_Currencies = Registry::get('Currencies');
$data = array('language_id' => $OSCOM_Language->getID(),
'batch_pageset' => 1,
'batch_max_results' => 6);
$result = OSCOM::callDB('Admin\Products\GetAll', $data);
foreach ( $result['entries'] as &$p ) {
if ( $p['has_children'] === 1 ) {
$p['products_price_formatted'] = $OSCOM_Currencies->format($p['products_price_min']);
if ( $p['products_price_min'] != $p['products_price_max'] ) {
$p['products_price_formatted'] .= ' - ' . $OSCOM_Currencies->format($p['products_price_max']);
}
$p['products_quantity'] = '(' . $p['products_quantity_variants'] . ')';
} else {
$p['products_price_formatted'] = $OSCOM_Currencies->format($p['products_price']);
}
}
$this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' .
' <thead>' .
' <tr>' .
' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_products') . '</th>' .
' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_price') . '</th>' .
' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_date') . '</th>' .
' <th>' . OSCOM::getDef('admin_indexmodules_products_table_heading_status') . '</th>' .
' </tr>' .
' </thead>' .
' <tbody>';
/*
$Qproducts = Registry::get('PDO')->query('select products_id, greatest(products_date_added, products_last_modified) as date_last_modified from :table_products where parent_id is null order by date_last_modified desc limit 6');
$Qproducts->execute();
$counter = 0;
while ( $Qproducts->fetch() ) {
$data = osC_Products_Admin::get($Qproducts->valueInt('products_id'));
$products_icon = osc_icon('products.png');
$products_price = $data['products_price'];
if ( !empty($data['variants']) ) {
$products_icon = osc_icon('attach.png');
$products_price = null;
foreach ( $data['variants'] as $variant ) {
if ( ($products_price === null) || ($variant['data']['price'] < $products_price) ) {
$products_price = $variant['data']['price'];
}
}
if ( $products_price === null ) {
$products_price = 0;
}
}
*/
$counter = 0;
foreach ( $result['entries'] as $p ) {
if ( $p['has_children'] === 1 ) {
$products_icon = HTML::icon('products.png');
} else {
$products_icon = HTML::icon('attach.png');
}
$this->_data .= ' <tr onmouseover="$(this).addClass(\'mouseOver\');" onmouseout="$(this).removeClass(\'mouseOver\');"' . ($counter % 2 ? ' class="alt"' : '') . '>' .
' <td>' . HTML::link(OSCOM::getLink(null, 'Products', 'Save&id=' . (int)$p['products_id']), $products_icon . ' ' . HTML::outputProtected($p['products_name'])) . '</td>' .
' <td>' . $p['products_price_formatted'] . '</td>' .
' <td>' . $p['products_last_modified'] . '</td>' .
' <td align="center">' . HTML::icon(((int)$p['products_status'] === 1) ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif', null, null) . '</td>' .
' </tr>';
$counter++;
}
$this->_data .= ' </tbody>' .
'</table>';
}
}
