public static function getDetailWhereGrouping($sqlWhere, $currentGroup, $detailFieldInfo)
{
$sqlWhere = empty($sqlWhere) ? " WHERE (1=1)" : $sqlWhere;
switch ($detailFieldInfo['grouping']) {
case "Detail":
//************************************************//
//*****Calculate Detail Extended Where Clause*****//
//************************************************//
$detailGroupWhereExtensionQuery = asol_ReportsGenerationFunctions::getDetailGroupWhereExtensionQuery($sqlWhere, $detailFieldInfo['field'], $currentGroup);
$subGroup = $detailGroupWhereExtensionQuery["subGroup"];
$sqlDetailWhere = $detailGroupWhereExtensionQuery["sqlDetailWhere"];
break;
case "Minute Detail":
case "Quarter Hour Detail":
case "Hour Detail":
case "Day Detail":
case "DoW Detail":
case "WoY Detail":
case "Month Detail":
case "Natural Quarter Detail":
case "Fiscal Quarter Detail":
case "Natural Year Detail":
case "Fiscal Year Detail":
//**************************************************************//
//***Calculate Month/DoW/WoY/Day Detail Extended Where Clause***//
//**************************************************************//
$monthDayDetailGroupWhereExtensionQuery = asol_ReportsGenerationFunctions::getDateDetailGroupWhereExtensionQuery($sqlWhere, $detailFieldInfo['field'], $detailFieldInfo['grouping'], $currentGroup);
$subGroup = $monthDayDetailGroupWhereExtensionQuery["subGroup"];
$sqlDetailWhere = $monthDayDetailGroupWhereExtensionQuery["sqlDetailWhere"];
break;
}
return array('subGroup' => $subGroup, 'sqlDetailWhere' => $sqlDetailWhere);
}