report_top_viewed_products.php File Reference

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]

---

Function Documentation

graph1

(

)

Current week top viewed products report

Returns:

null

Definition at line 99 of file report_top_viewed_products.php.

---

Variable Documentation

$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.