Go to the source code of this file.
Functions | |
graph1 () | |
Variables | |
$aDataX = array() | |
$aDataY = array() | |
$oSmarty = $this->getSmarty() | |
$sTime_from = $oDb->quote( date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_from'] ) ) ) | |
$sTime_to = $oDb->quote( date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_to'] ) ) ) | |
$sSQL = "select count(*) as nrof, oxarticles.oxtitle from oxlogs, oxarticles where oxlogs.oxclass = 'details' and oxlogs.oxanid = oxarticles.oxid and oxlogs.oxtime >= $sTime_from and oxlogs.oxtime <= $sTime_to group by oxlogs.oxanid order by nrof desc limit 0, 25" | |
$rs = $oDb->execute( $sSQL) | |
$iMax = 0 | |
$aPoints = array() | |
$aPoints [0] = 0 | |
$aAligns [0] = 'report_searchstrings_scale_aligns_left"' | |
$iTenth = strlen($iMax) - 1 | |
$aAligns [(round(($iMax/2)))] = 'report_searchstrings_scale_aligns_center" width="'.(720/3).'"' | |
$aPoints [$iMax] = $iMax | |
$aAligns [$iMax] = 'report_searchstrings_scale_aligns_right" width="'.(720/3).'"' | |
$aDataVals = array() | |
$aDataVals [$iCtr]['nm'] = $aDataY[$iCtr] |
graph1 | ( | ) |
Current week top viewed products report
Definition at line 99 of file report_top_viewed_products.php.
$aAligns[$iMax] = 'report_searchstrings_scale_aligns_right" width="'.(720/3).'"' |
Definition at line 58 of file report_top_viewed_products.php.
$aAligns[(round(($iMax/2)))] = 'report_searchstrings_scale_aligns_center" width="'.(720/3).'"' |
Definition at line 56 of file report_top_viewed_products.php.
$aAligns[0] = 'report_searchstrings_scale_aligns_left"' |
Definition at line 51 of file report_top_viewed_products.php.
$aDataVals[$iCtr]['nm'] = $aDataY[$iCtr] |
Definition at line 77 of file report_top_viewed_products.php.
$aDataVals = array() |
Definition at line 73 of file report_top_viewed_products.php.
$aDataX = array() |
Definition at line 25 of file report_top_viewed_products.php.
$aDataY = array() |
Definition at line 26 of file report_top_viewed_products.php.
$aPoints[$iMax] = $iMax |
Definition at line 57 of file report_top_viewed_products.php.
$aPoints[0] = 0 |
Definition at line 50 of file report_top_viewed_products.php.
$aPoints = array() |
Definition at line 49 of file report_top_viewed_products.php.
$iMax = 0 |
Definition at line 43 of file report_top_viewed_products.php.
$iTenth = strlen($iMax) - 1 |
Definition at line 52 of file report_top_viewed_products.php.
$oSmarty = $this->getSmarty() |
Definition at line 28 of file report_top_viewed_products.php.
$rs = $oDb->execute( $sSQL) |
Definition at line 33 of file report_top_viewed_products.php.
$sSQL = "select count(*) as nrof, oxarticles.oxtitle from oxlogs, oxarticles where oxlogs.oxclass = 'details' and oxlogs.oxanid = oxarticles.oxid and oxlogs.oxtime >= $sTime_from and oxlogs.oxtime <= $sTime_to group by oxlogs.oxanid order by nrof desc limit 0, 25" |
Definition at line 32 of file report_top_viewed_products.php.
$sTime_from = $oDb->quote( date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_from'] ) ) ) |
Definition at line 29 of file report_top_viewed_products.php.
$sTime_to = $oDb->quote( date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_to'] ) ) ) |
Definition at line 30 of file report_top_viewed_products.php.