Как сделать без .menu ради уменьшения количества SQL запросов?

Larrikin 13.03.2011 22:04

@getStatHash[week][w]
	^if($week){
		$result[^hash::create[]]
		^week.menu{
			$w($week.n)
			$result.$w[^oSql.hash{
				SELECT
					app_id
					,COUNT(*) AS cnt
				FROM
					weekly
				WHERE
					dt > '$week.from'
				AND
					dt < '$week.to'
				GROUP BY
					app_id
			}]
			$result.$w.total(^oSql.int{
				SELECT
					COUNT(*)
				FROM
					weekly
				WHERE
					dt > '$week.from'
				AND
					dt < '$week.to'
			})
			$result.total($result.total+$result.$w.total)
		}
	}{
		^throw[bad.param;getStatHash;Wrong param]
	}