$rs = getThreadContent($_REQUEST['tid']); $dao = new DAO(); foreach ($rs as $rows) { echo ""; foreach ($rows as $col_values) { echo "Comment/discussion Content: " . $dao->fetchThreadContent($col_values) . '    ThreadName: ' . $dao->fetchThreadName($col_values) . '<br>'; } } } if ($ttid != null) { $dao = new DAO(); $rs = getStaffID($_REQUEST['ttid']); foreach ($rs as $rows) { echo ""; foreach ($rows as $col_values) { echo "Staffs on duty on mondays: " . $dao->fetchStaffName($col_values) . '    type: ' . $dao->fetchStaffTypeName($dao->fetchstaffType($col_values)) . ' schedule: ' . $dao->fetchStaffStartTime($col_values) . ' ' . $dao->fetchStaffEndTime($col_values) . '<br>'; } } } function getStaffID($tid) { $dao = new DAO(); $q = "select workerid from schedule where theatreid = {$tid} and q8(workerid)>0"; $stid = oci_parse($dao->con, $q); oci_execute($stid, OCI_DEFAULT); oci_fetch_all($stid, $rs); return $rs; } function getThreadContent($TID) { $dao = new DAO();
function displayManagerInfo() { $dao = new DAO(); $rs = $dao->fetchManagerIDsWithoutRights(); echo 'Manager have not rights to update movie: <br>'; echo '<table border=0>'; foreach ($rs as $row) { foreach ($row as $id) { echo '<tr>'; $changeLink = "<a href=\"staff.php?cmd=addRight&staffid={$id}\">" . 'addRights' . '</a>'; echo '<td> Manager: ' . $dao->fetchStaffName($id) . '</td><td> ' . $changeLink . '</td><td>'; echo '</tr>'; } } echo '</table>'; $rss = $dao->fetchManagerIDsWithRights(); echo 'Manager have rights to update movie: <br>'; echo '<table border=0>'; foreach ($rss as $row) { foreach ($row as $id) { echo '<tr>'; $changeLink = "<a href=\"staff.php?cmd=delRight&staffid={$id}\">" . 'delRights' . '</a>'; echo '<td> Manager: ' . $dao->fetchStaffName($id) . '</td><td> ' . $changeLink . '</td><td>'; echo '</tr>'; } } echo '</table>'; }