report_searchstrings.php File Reference


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, oxparameter from oxlogs where oxclass = 'search' and oxtime >= '$sTime_from' and oxtime <= '$sTime_to' group by oxparameter order by nrof desc"
 $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 search strings report

Returns:
null


Variable Documentation

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

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

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

$aDataY = array()

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

$aPoints["0"] = 0

$aPoints = array()

$iMax = 0

$iTenth = strlen($iMax) - 1

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

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

$sSQL = "select count(*) as nrof, oxparameter from oxlogs where oxclass = 'search' and oxtime >= '$sTime_from' and oxtime <= '$sTime_to' group by oxparameter order by nrof desc"

$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'] ) )


Generated on Wed Oct 29 23:38:32 2008 for OXID eShop CE by  doxygen 1.5.5