report_top_clicked_categories.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, oxcategories.oxtitle from oxlogs, oxcategories where oxlogs.oxclass = 'alist' and oxlogs.oxcnid = oxcategories.oxid and oxlogs.oxtime >= '$sTime_from' and oxlogs.oxtime <= '$sTime_to' group by oxcategories.oxtitle 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).'"'

---

Function Documentation

graph1

(

)

Current week top viewed categories report

Returns:

null

Definition at line 93 of file report_top_clicked_categories.php.

---

Variable Documentation

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

Definition at line 57 of file report_top_clicked_categories.php.

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

Definition at line 55 of file report_top_clicked_categories.php.

$aAligns["0"] = 'report_searchstrings_scale_aligns_left"'

Definition at line 50 of file report_top_clicked_categories.php.

$aDataY = array()

Definition at line 25 of file report_top_clicked_categories.php.

$aPoints["".$iMax.""] = $iMax

Definition at line 56 of file report_top_clicked_categories.php.

$aPoints["0"] = 0

Definition at line 49 of file report_top_clicked_categories.php.

$aPoints = array()

Definition at line 48 of file report_top_clicked_categories.php.

$iMax = 0

Definition at line 42 of file report_top_clicked_categories.php.

$iTenth = strlen($iMax) - 1

Definition at line 51 of file report_top_clicked_categories.php.

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

Definition at line 27 of file report_top_clicked_categories.php.

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

Definition at line 32 of file report_top_clicked_categories.php.

$sSQL = "select count(*) as nrof, oxcategories.oxtitle from oxlogs, oxcategories where oxlogs.oxclass = 'alist' and oxlogs.oxcnid = oxcategories.oxid and oxlogs.oxtime >= '$sTime_from' and oxlogs.oxtime <= '$sTime_to' group by oxcategories.oxtitle order by nrof desc limit 0, 25"

Definition at line 31 of file report_top_clicked_categories.php.

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

Definition at line 28 of file report_top_clicked_categories.php.

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

Definition at line 29 of file report_top_clicked_categories.php.