<?php
$title->appendChild($document->createTextNode('index page'));
$frame = new FWSRFrame($document, $content);
$frame->addObject(new FWSRQuery('reg_count', "\r\n\tSELECT Fct2009_Areas.Col005 as [АТЕ], SUM(CASE WHEN class = '11' THEN 1 ELSE 0 END), SUM(CASE WHEN class = '12' THEN 1 ELSE 0 END)\r\n\tFROM Fct2009_Students INNER JOIN\r\n\t Fct2009_Schools ON Fct2009_Students.school = Fct2009_Schools.Col004 INNER JOIN\r\n\t Fct2009_Areas ON Fct2009_Schools.Col010 = Fct2009_Areas.Col004\r\n\tGROUP BY Fct2009_Areas.Col005\r\n\tORDER BY Fct2009_Areas.Col005", $mymonbase));
$frame->addObject(new FWSRTable('reg_table', 'reg_count'));
<?php
//This is automated created file "1.php" for menu item "1"
$title->appendChild($document->createTextNode('index page'));
$frame = new FWSRFrame($document, $content);
$frame->addObject(new FWSRQuery('stat', "\r\n SELECT\r\n [Общее кол-во об-ся], Round(CONVERT(real, 100) * [не явились] / [Общее кол-во об-ся], 2) AS [% не яв-ся],\r\n [Кол-во писавших], \r\n Round(CONVERT(real, 100) * [5] / [Кол-во писавших], 2) AS [5], \r\n Round(CONVERT(real, 100) * [4] / [Кол-во писавших], 2) AS [4], \r\n Round(CONVERT(real, 100) * [3] / [Кол-во писавших], 2) AS [3], \r\n Round(CONVERT(real, 100) * [2] / [Кол-во писавших], 2) AS [2], \r\n Round(CONVERT(real, 100) * ([5] + [4] + [3]) / [Кол-во писавших], 2) AS [Усп-ть], \r\n Round(CONVERT(real, 100) * ([5] + [4]) / [Кол-во писавших], 2) AS [Кач-во], \r\n [Средний балл]\r\n FROM (\r\n SELECT\r\n COUNT(*) AS [Общее кол-во об-ся],\r\n SUM(CASE WHEN rate IS NULL THEN 1 ELSE 0 END) AS [не явились],\r\n SUM(CASE WHEN rate IS NOT NULL THEN 1 ELSE 0 END) AS [Кол-во писавших], SUM(CASE WHEN rate = 5 THEN 1 ELSE 0 END) AS [5], \r\n SUM(CASE WHEN rate = 4 THEN 1 ELSE 0 END) AS [4], SUM(CASE WHEN rate = 3 THEN 1 ELSE 0 END) AS [3], \r\n SUM(CASE WHEN rate = 2 THEN 1 ELSE 0 END) AS [2], Round(AVG(rate), 2) AS [Средний балл]\r\n FROM [dbo].[Table]\r\n ) AS r ", $Nine2009));
$frame->addObject(new FWSRTable('tabletest', 'stat'));
<?php
$title->appendChild($document->createTextNode('index page'));
$frame = new FWSRFrame($document, $content);
$frame->addObject(new FWSRQuery('groups_q', "SELECT id,name FROM groups ORDER BY name", $_SESSION['db']));
$frame->addObject(new FWSRSelectMenu('groups_s', 'groups_q'));
$frame->addObject(new FWSRQuery('users_q', "SELECT *, 1 as test FROM groupuser inner join users on groupuser.value = users.id and groupuser.id = \$(groups_s>value)", $_SESSION['db']));
$frame->addObject(new FWSRTable('tabletest', 'users_q'));
