$csvout = 'N'; $csvout_checked = ''; if (isset($_REQUEST['csvout'])) { $csvout = $_REQUEST['csvout']; $csvout_checked = $csvout == 'Y' ? 'checked' : ''; } //pagehead2("Presence list to $afko $year $description");//,$scripts); $prj_id_selector = $prjSel->getSelector(); $selection_details = $prjSel->getSelectionDetails(); $sql = "select st.snummer,roepnaam||coalesce(' '||voorvoegsel||' ',' ')||achternaam as name," . " '#'||task_number||': '||apt.afko||': '||apt.description as checktitle,\n" . " pt.name as task_name,\n" . " coalesce(grade::text,mark) as check, ptc.comment as title,photo,grp_num \n" . " from prj_grp join all_prj_tutor apt using(prjtg_id)\n" . " natural join student st \n" . " join portrait tp using (snummer) \n" . " join project_task pt using(prj_id)\n" . " left join project_task_completed_latest ptc using(snummer,task_id)\n" . " where prj_id={$prj_id} \n" . " order by grp_num,achternaam,roepnaam, task_number\n"; $dbConn->log($sql); $page = new PageContainer(); include 'js/balloonscript.php'; $page->setTitle('Overview of tasks completed'); $page->addHeadComponent(new Component("<style type='text/css'>\n *.notered { \n\tbackground-image:url('images/redNote.png');\n }\n *.notegreen { \n\tbackground-image:url('images/greenNote.png');\n }\n *.noteblue { \n\tbackground-image:url('images/blueNote.png');\n }\n </style>")); $page_opening = "Task completed list for project {$afko} {$description} prj_id {$prj_id}"; $nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening); $page->addBodyComponent($nav); $tableBuilder = new TableBuilder($dbConn, new TaskRowFactory()); $task_table = $tableBuilder->getTable($sql, 'snummer'); $templatefile = 'templates/taskoverview.html'; $template_text = file_get_contents($templatefile, true); $text = ''; if ($template_text === false) { $text = "<strong>cannot read template file {$templatefile}</strong>"; } else { eval("\$text = \"{$template_text}\";"); } $page->addBodyComponent(new Component($text)); $page->addBodyComponent(new Component('<!-- db_name=' . $db_name . '-->')); $page->show();
<div id='navmain' style='padding:1em;'> <?php echo $prjSel->getWidget(); ?> <fieldset><legend>Select task</legend> <form method="post" name="activity" action="<?php echo $PHP_SELF; ?> "> Select task: <input type='hidden' name='prjm_id' value='<?php echo $prjm_id; ?> '/> <input type='hidden' name='task_id' value='<?php echo $task_id; ?> '/> <?php echo $task_id_selector; ?> <input type='submit' name='sbm' value='Get'> <?php echo $tableBuilder->getTable($sql, 'snummer'); ?> <input type='submit' name='bsubmit' value='submit'/> </form> </fieldset> </div> </body> </html>