<p>You can select documents uploaded by students.
The links in the table take you to the critique pages.</p>
<p>You can also <button onClick='location.href="zipit.php?prjm_id=<?php
echo $prjm_id;
?>
"'>zip and download</button> all files (total uncompressed <?php
echo $zip_filesize;
?>
bytes).</p>
<?php
$sql = "select afko,ut.description as doc_desc,apt.description as description,\n" . "prj_id,year,milestone,apt.grp_num,tutor_grp.grp_num as viewergrp,\n" . "apt.grp_num as authorgrp,rtrim(alias) as alias,rtrim(long_name) as long_name,\n" . "rtrim(title) as title,\n" . "rel_file_path,mime_type,due,\n" . "to_char(uploadts,'YYYY-MM-DD HH24:MI:SS')::text as uploadts,\n" . "case when uploadts::date > pd.due then 'late' else 'early' end as late_or_early,\n" . "vers,ut.doctype,ut.description as dtdescr,upload_id,\n" . "snummer, roepnaam,voorvoegsel,achternaam,student_class.sclass as klas,u.upload_id as doc_id,\n" . "doc_count,critique_count as crits,u.rights[0:2],filesize\n " . "from uploads u\n" . "join all_prj_tutor apt using (prjtg_id,prjm_id)\n" . "join uploaddocumenttypes ut using(prj_id,doctype)\n" . "join project_deliverables pd using(prjm_id,doctype)\n" . "join upload_group_count using(prjtg_id)\n" . "join student using(snummer) \n" . "join student_class using (class_id)\n" . "left join document_critique_count on (upload_id=doc_id)\n" . "left join (select prjtg_id,grp_num from prj_tutor where prjtg_id={$prjtg_id} and tutor='{$tutor_code}') tutor_grp\n" . " using(prjtg_id)\n" . "where prjm_id = {$prjm_id} " . "order by apt.grp_num,ut.doctype,achternaam,vers desc,doc_id desc,achternaam,roepnaam ";
//$dbConn->log( $sql );
if (isset($doctype)) {
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with <pre>' . $sql . "</pre>\n");
} else {
documentFoldersPreExecuted($resultSet, 'doctype=' . $doctype);
}
} else {
echo "No documents avaliable for this project";
}
?>
</div>
<!-- $Id: auditorview.php 1825 2014-12-27 14:57:05Z hom $ -->
<!-- db_name=<?php
echo $db_name;
?>
-->
</body>
</html>
$deliverable_count = 0;
?>
<div style='padding:1em;'>
<?php
$isTutorBool = $isTutor ? 'true' : 'false';
$sql = "select rtrim(afko) as afko,apt.description as description,apt.prj_id,year,apt.milestone,\n" . "grp_num as author_grp_num,long_name,grp_num as viewergrp,title,rel_file_path,\n" . "to_char(uploadts,'YYYY-MM-DD HH24:MI')::text as uploadts,pd.due,rtrim(mime_type) as mime_type,\n" . "case when uploadts::date > pd.due then 'late' else 'early' end as late_or_early,\n" . "vers,ut.doctype,ut.description as dtdescr,upload_id,({$peer_id}=u.snummer or {$peer_id}=aud.reader or {$isTutorBool}) as link,\n" . "u.snummer, roepnaam,voorvoegsel,achternaam,sclass as sclass,doc_count,critique_count as crits,u.rights[0:2],\n" . "filesize from uploads u \n" . "join all_prj_tutor apt using(prjtg_id,prjm_id)\n" . "join student s on(u.snummer=s.snummer)\n" . "join student_class using (class_id)\n" . "join uploaddocumenttypes ut using(prj_id,doctype)\n" . "join project_deliverables pd using(prjm_id,doctype)\n" . "join student_upload_count suc on(ut.prj_id=suc.prj_id and apt.milestone=suc.milestone and suc.snummer=u.snummer)\n" . "left join document_critique_count on (upload_id=doc_id)\n" . "left join (select upload_id,prjm_id,reader,reader_role from document_audience\n" . "where prjm_id={$prjm_id} and reader={$peer_id}) aud using(upload_id,prjm_id)\n" . "where u.snummer={$snummer} order by afko,ut.doctype,vers desc";
// echo "<pre>$sql</pre>\n";
$resultSet = $dbConn->Execute($sql);
if ($resultSet === false) {
die('Error: ' . $dbConn->ErrorMsg() . ' with <pre>' . $sql . "</pre>");
} else {
if (!$resultSet->EOF) {
?>
<h2 class='normal'>Your portfolio contains</h2>
<?php
echo documentFoldersPreExecuted($resultSet);
?>
<?php
} else {
?>
<h1>Your portfolio is empty</h1><?php
}
}
?>
</div>
</div>
<br/>
<!-- $Id: portfolio.php 1825 2014-12-27 14:57:05Z hom $ -->
<!-- db_name=<?php
echo $db_name;
?>
