PHP DAO::fetchStaffTypeName Examples

Example #1

File: getContent.php Project: a4501150/CS425

    $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) . '&nbsp &nbsp 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) . '&nbsp &nbsp type: ' . $dao->fetchStaffTypeName($dao->fetchstaffType($col_values)) . ' schedule: ' . $dao->fetchStaffStartTime($col_values) . '&nbsp' . $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();

Example #2

File: staff.php Project: a4501150/CS425

function displayStaffsNeedsToAssign()
{
    $dao = new DAO();
    $rs = $dao->fetchNoScheduleStaff();
    echo 'Avalible to assign Schedule: <br>';
    echo '<table border=0>';
    foreach ($rs as $row) {
        foreach ($row as $id) {
            echo '<tr>';
            $changeLink = "<a href=\"schedule.php?cmd=as&workerID={$id}\">" . 'assign' . '</a>';
            echo '<td> STAFF: ' . $dao->fetchStaffName($id) . '</td><td>' . $dao->fetchStaffTypeName($dao->fetchStaffType($id)) . '</td><td> ' . $changeLink . '</td><td>';
            echo '</tr>';
        }
    }
    echo '</table>';
}