Example #1
0
function pmaAllWorkRequestsTable($atts)
{
    $results = determineTixQuery();
    global $wp;
    $curUrl = rtrim(home_url(add_query_arg(array(), $wp->request)), "/");
    $str = "<table cellpadding='0' cellspacing='0' id='PmaWorkRequestsTable'><tr><th>id</th><th><a href='{$curUrl}?sort=tix.last_name&ad={$results[2]}&StatusType={$results[3]}'>requestor</a></th><th>title</th><th><a href='{$curUrl}?sort=tix.due_date&ad={$results[2]}&StatusType={$results[3]}'>due date<a/></th><th><a href='{$curUrl}?sort=ta.last_name&ad={$results[2]}&StatusType={$results[3]}'>assigned</a></th><th><a href='{$curUrl}?sort=st.status&ad={$results[2]}&StatusType={$results[3]}'>status</a></th><th><a href='{$curUrl}?sort=tix.date_submitted&ad={$results[2]}&StatusType={$results[3]}'>date submitted</a></th></tr>";
    $a = shortcode_atts(array('id' => '', 'sortby' => '', 'ad' => ''), $atts);
    $sql = 'call sp_getTicketsInOrder(' . $a['id'] . ',' . $results[3] . ',"' . ($results[0] == '' ? $a['sortby'] : $results[0]) . '","' . ($results[1] == '' ? $a['ad'] : $results[1]) . '")';
    $dbo = PmaPdoDb::getInstance();
    $dbo->connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
    $rows = $dbo->queryForObjs($sql);
    if (count($rows) > 0) {
        foreach ($rows as $row) {
            $str .= '<tr><td>' . $row['id'] . '</td><td>' . $row['requestor'] . '</td><td><a href="./edit-work-request/?workrequestid=' . $row['id'] . '">' . stripslashes($row['request_title']) . '</a></td><td>' . $row['due_date'] . '</td><td>' . $row['assignedTo'] . '</td><td>' . $row['status'] . '</td><td>' . $row['date_submitted'] . '</td></tr>';
        }
    } else {
        $str .= '<tr><td colspan="7">no records found</td></tr>';
    }
    $str .= '</table>';
    return $str;
}
Example #2
0
function pmaAllWorkRequestsTable($atts)
{
    $results = determineTixQuery();
    if ($results[3] != null) {
        global $wp;
        $curUrl = rtrim(home_url(add_query_arg(array(), $wp->request)), "/");
        $a = shortcode_atts(array('id' => '', 'sortby' => '', 'ad' => ''), $atts);
        $totalRecords = 0;
        $sql = 'call sp_getTicketsInOrder(' . $a['id'] . ',' . $results[3] . ',' . $results[4] . ',' . ($results[5] == '' ? "''" : "'" . $results[5] . "'") . ',"' . ($results[0] == '' ? $a['sortby'] : $results[0]) . '","' . ($results[1] == '' ? $a['ad'] : $results[1]) . '",' . $results[6] . ',' . $results[7] . ',@outrecs)';
        //echo $sql . ";";
        //die();
        $dbo = PmaPdoDb::getInstance();
        $dbo->connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
        $rows = $dbo->queryForObjs($sql);
        $tots = $dbo->queryForObjs("select @outrecs");
        //get the output parameter of the proc for the total number of records sans the LIMIT/OFFSET
        $numRecs = $tots[0][0];
        $lateCss = "";
        $str = $numRecs . ' records found.';
        $str .= "<table class='responsive-stacked-table' cellpadding='0' cellspacing='0' id='PmaWorkRequestsTable'><thead><tr><th>id</th><th><a href='{$curUrl}?sort=tix.last_name&ad={$results[2]}&StatusType={$results[3]}&agent={$results[4]}&commentSearch={$results[5]}&pge={$results[8]}'>requestor</a></th><th width='33%'>title</th><th><a href='{$curUrl}?sort=tix.due_date&ad={$results[2]}&StatusType={$results[3]}&agent={$results[4]}&commentSearch={$results[5]}&pge={$results[8]}'>due date<a/></th><th><a href='{$curUrl}?sort=ta.last_name&ad={$results[2]}&StatusType={$results[3]}&agent={$results[4]}&commentSearch={$results[5]}&pge={$results[8]}'>assigned</a></th><th><a href='{$curUrl}?sort=st.status&ad={$results[2]}&StatusType={$results[3]}&agent={$results[4]}&commentSearch={$results[5]}&pge={$results[8]}'>status</a></th><th><a href='{$curUrl}?sort=tix.date_submitted&ad={$results[2]}&StatusType={$results[3]}&agent={$results[4]}&commentSearch={$results[5]}&pge={$results[8]}'>date submitted</a></th></tr></thead>";
        if ($numRecs > 0) {
            foreach ($rows as $row) {
                $lateCss = "";
                if ($row['status_id'] != 3 && $row['is_old'] != null) {
                    $lateCss = 'overdue';
                }
                $str .= '<tr><td data-label="ID">' . $row['id'] . '</td><td data-label="requestor">' . $row['requestor'] . '</td><td data-label="title"><a target="WorkRequest" href="./edit-work-request/?workrequestid=' . $row['id'] . '">' . stripslashes($row['request_title']) . '</a></td><td data-label="due date" class="' . $lateCss . '">' . $row['due_date'] . '</td><td data-label="assigned">' . $row['assignedTo'] . '</td><td data-label="status">' . $row['status'] . '</td><td data-label="date submitted">' . $row['date_submitted'] . '</td></tr>';
                if ($results[5] != '') {
                    $str .= '<tr><td colspan="7">' . str_ireplace($results[5], '<span class="highlight">' . $results[5] . '</span>', str_replace("\\n", "<br/>", $row["comments"])) . '</td></tr>';
                }
            }
            /*Pagination */
            $str .= '</tr>';
            $str .= '<tr><td colspan="7" align="center">' . determinePaging($numRecs, $results) . '</td></tr>';
        } else {
            $str .= '<tr><td colspan="7">no records found</td></tr>';
        }
        $str .= '</table>';
        return $str;
    }
}