| Approver |
Date |
Action |
Reason |
';
?>
addDataParam('i', $vendor_id);
$rs = $wrapperObj->executeQuery($sql, $data_params);
if ($rs === false) {
showierror($sql);
}
$sql = 'SELECT FOUND_ROWS() AS total';
$data_params = new QueryData();
$total_count = $wrapperObj->executeQuery($sql, $data_params);
if ($total_count === false) {
showierror($sql);
}
$total_count_row = $total_count[0];
$total = $total_count_row['total'];
$pageNum = $pageRecord ? ceil($total/$pageRecord) : 0;
if (count($rs) > 0) {
foreach ($rs as $row) {
$row_class = (++$rci & 1) ? '' : 'alt';
$varTable .='
| '.($row['approved_by'] ? $oa_users[$row['approved_by']] : ($row['rejected_by'] ? $oa_users[$row['rejected_by']] : "")).' |
'.$row['date_changed'].' |
'.($row['approved_by'] ? "Accept" : ($row['rejected_by'] ? "Reject" : "")).' |
'.($row['rejected_by'] ? $row['reason_of_rejection'] : "").' |
';
}
}else{
$varTable .='| No Contract Approval History |
';
}
$varTable .='';
if ($total && $viewall) {
echo paginate($page, $pageRecord, $pageNum, $varQueryString);
}
?>