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; }
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; } }