本文整理匯總了PHP中plgFabrik_Element::getAvgQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP plgFabrik_Element::getAvgQuery方法的具體用法？PHP plgFabrik_Element::getAvgQuery怎麽用？PHP plgFabrik_Element::getAvgQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類plgFabrik_Element的用法示例。
在下文中一共展示了plgFabrik_Element::getAvgQuery方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getAvgQuery
/**
* Build the query for the avg calculation
*
* @param model &$listModel list model
* @param string $label the label to apply to each avg
*
* @return string sql statement
*/
protected function getAvgQuery(&$listModel, $label = "'calc'")
{
$db = $listModel->getDb();
$fields = $listModel->getDBFields($this->getTableName(), 'Field');
$name = $this->getElement()->name;
$field = JArrayHelper::getValue($fields, $name, false);
if ($field !== false && $field->Type == 'time') {
$name = $this->getFullName(false, false, false);
$table = $listModel->getTable();
$joinSQL = $listModel->_buildQueryJoin();
$whereSQL = $listModel->_buildQueryWhere();
return "SELECT SEC_TO_TIME(AVG(TIME_TO_SEC({$name}))) AS value, {$label} AS label FROM " . $db->quoteName($table->db_table_name) . " {$joinSQL} {$whereSQL}";
} else {
return parent::getAvgQuery($listModel, $label);
}
}示例2: getAvgQuery
/**
* build the query for the avg caclculation
* @param model $listModel
* @param string $label the label to apply to each avg
* @return string sql statement
*/
protected function getAvgQuery(&$listModel, $label = "'calc'")
{
$fields = $listModel->getDBFields($this->getTableName(), 'Field');
if ($fields[$this->getElement()->name]->Type == 'time') {
$name = $this->getFullName(false, false, false);
$table =& $listModel->getTable();
$joinSQL = $listModel->_buildQueryJoin();
$whereSQL = $listModel->_buildQueryWhere();
return "SELECT SEC_TO_TIME(AVG(TIME_TO_SEC({$name}))) AS value, {$label} AS label FROM `{$table->db_table_name}` {$joinSQL} {$whereSQL}";
} else {
return parent::getAvgQuery($listModel, $label);
}
}