report_top_viewed_products.php File Reference

Go to the source code of this file.

Functions

 graph1 ()

Variables

 $aDataY = array()
 $oSmarty = oxUtilsView::getInstance()->getSmarty()
 $sTime_from = date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_from'] ) )
 $sTime_to = 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 = oxDb::getDb()->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]


Function Documentation

graph1 (  ) 

Current week top viewed products report

Returns:
null

Definition at line 95 of file report_top_viewed_products.php.


Variable Documentation

$aAligns[$iMax] = 'report_searchstrings_scale_aligns_right" width="'.(720/3).'"'

Definition at line 56 of file report_top_viewed_products.php.

$aAligns[(round(($iMax/2)))] = 'report_searchstrings_scale_aligns_center" width="'.(720/3).'"'

Definition at line 54 of file report_top_viewed_products.php.

$aAligns[0] = 'report_searchstrings_scale_aligns_left"'

Definition at line 49 of file report_top_viewed_products.php.

$aDataVals[$iCtr]['nm'] = $aDataY[$iCtr]

Definition at line 75 of file report_top_viewed_products.php.

$aDataVals = array()

Definition at line 71 of file report_top_viewed_products.php.

$aDataY = array()

Definition at line 24 of file report_top_viewed_products.php.

$aPoints[$iMax] = $iMax

Definition at line 55 of file report_top_viewed_products.php.

$aPoints[0] = 0

Definition at line 48 of file report_top_viewed_products.php.

$aPoints = array()

Definition at line 47 of file report_top_viewed_products.php.

$iMax = 0

Definition at line 41 of file report_top_viewed_products.php.

$iTenth = strlen($iMax) - 1

Definition at line 50 of file report_top_viewed_products.php.

$oSmarty = oxUtilsView::getInstance()->getSmarty()

Definition at line 26 of file report_top_viewed_products.php.

$rs = oxDb::getDb()->execute( $sSQL)

Definition at line 31 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 30 of file report_top_viewed_products.php.

$sTime_from = date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_from'] ) )

Definition at line 27 of file report_top_viewed_products.php.

$sTime_to = date( "Y-m-d H:i:s", strtotime( $oSmarty->_tpl_vars['time_to'] ) )

Definition at line 28 of file report_top_viewed_products.php.


Generated on Wed Apr 22 12:26:32 2009 for OXID eShop CE by  doxygen 1.5.5