echo $topic['id'];
?>
','help topic','<?php
echo $topic['topic'];
?>
');">Delete</a> ]</td>
<td width="6%" valign="top"><?php
echo $topic['page'];
?>
</td>
<td width="10%" valign="top"><?php
echo $topic['topic'];
?>
</td>
<td width="70%" valign="top"><?php
echo format_to_length($topic['content'], 200);
?>
</td>
</tr>
<?php
$counter++;
}
?>
</table>
</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</form></td>
function weeklyreport($level, $data = array())
{
switch ($level) {
case 'ppda':
$search_str = ' ';
#Get the paginated list of bid invitations
$results = paginate_list($this, $data, 'weekly_IFB_report', array('orderby' => '', 'searchstring' => '' . $search_str), 1000);
# print_r($results); exit();
$table = "<div>";
if (!empty($results['page_list'])) {
$table .= '<table class="table table-striped table-hover">' . '<thead>' . '<tr>' . '<th width="5%"></th>' . '<th>Procurement Ref. No</th>' . '<th class="hidden-480">Subject of procurement</th>' . '<th class="hidden-480">Bid security</th>' . '<th class="hidden-480">Bid invitation date</th>' . '<th class="hidden-480">Addenda</th>' . '<th>Status</th>' . '<th>Published by</th>' . '<th>Date Added</th>' . '</tr>' . '</thead>' . '</tbody>';
foreach ($results['page_list'] as $row) {
$this->session->unset_userdata('pdeid');
$status_str = '';
$addenda_str = '[NONE]';
$delete_str = '';
$edit_str = '';
if (!empty($level) && $level == 'active') {
$delete_str = '<a title="Delete bid invitation" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'bids/delete_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '\', \'Are you sure you want to delete this bid invitation?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="icon-trash"></i></a>';
$edit_str = '<a title="Edit bid details" href="' . base_url() . 'bids/load_bid_invitation_form/i/' . encryptValue($row['bidinvitation_id']) . '"><i class="icon-edit"></i></a>';
}
if ($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') < 0) {
$status_str = 'Bid evaluation | <a title="Select BEB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[Select BEB]</a>';
} elseif ($row['bid_approved'] == 'N') {
$status_str = 'Not published | <a title="Publish IFB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[Publish IFB]</a>';
} elseif ($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') > 0) {
$status_str = 'Bidding closes in ' . get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') . ' days | <a title="view IFB document" href="' . base_url() . 'bids/view_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[View IFB]</a>';
$addenda_str = '<a title="view addenda list" href="' . base_url() . 'bids/view_addenda/b/' . encryptValue($row['bidinvitation_id']) . '">[View Addenda]</a> | <a title="Add addenda" href="' . base_url() . 'bids/load_ifb_addenda_form/b/' . encryptValue($row['bidinvitation_id']) . '">[Add Addenda]</a>';
} else {
}
$table .= '<tr>' . '<td></td>' . '<td>' . format_to_length($row['procurement_ref_no'], 40) . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 50) . '</td>' . '<td>' . (is_numeric($row['bid_security_amount']) ? number_format($row['bid_security_amount'], 0, '.', ',') . ' ' . $row['bid_security_currency_title'] : (empty($row['bid_security_amount']) ? '<i>N/A</i>' : $row['bid_security_amount'])) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['invitation_to_bid_date']) . '</td>' . '<td>' . $addenda_str . '</td>' . '<td>' . $status_str . '</td>' . '<td>' . (empty($row['approver_fullname']) ? 'N/A' : $row['approver_fullname']) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['bid_dateadded']) . '</td>' . '</tr>';
}
$table .= '</tbody></table>';
$table .= '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $results['rows_per_page'], $results['current_list_page'], base_url() . "bids/manage_bid_invitations/" . $level . "/p/%d") . '</div>';
} else {
$table .= format_notice('WARNING: No bid invitations expiring this week');
}
$table .= "</div>";
$adons = '';
//$entity = $records['pdeid'];
//$this->session->set_userdata('pdeid',$entity);
$datasx = $this->session->set_userdata('level', 'ppda');
$entityname = '';
$entityname = '';
$adons = date('d-m');
$level = "Procurement";
# exit('moooooo');
$titles = "Weekly report on expiring IFBs of ITP";
$body = " " . html_entity_decode($table);
$permission = "view_bid_invitations";
$xcv = 0;
push_permission($titles, $body, $level, $permission);
#end
break;
case 'ifb':
$search_str = '';
# code...
$querys = $this->db->query("select distinct b.pdeid,b.pdename,a.* from pdes b inner join users a on a.pde = b.pdeid ")->result_array();
foreach ($querys as $row => $records) {
#get the PDE ID " Idividual Pde Ids ";"
$search_str = ' AND procurement_plans.pde_id="' . $records['pdeid'] . '"';
$results = paginate_list($this, $data, 'weekly_IFB_report', array('orderby' => '', 'searchstring' => '' . $search_str), 1000);
# print_r($results); exit();
$table = "<div>";
if (!empty($results['page_list'])) {
$table .= '<table class="table table-striped table-hover">' . '<thead>' . '<tr>' . '<th width="5%"></th>' . '<th>Procurement Ref. No</th>' . '<th class="hidden-480">Subject of procurement</th>' . '<th class="hidden-480">Bid security</th>' . '<th class="hidden-480">Bid invitation date</th>' . '<th class="hidden-480">Addenda</th>' . '<th>Status</th>' . '<th>Published by</th>' . '<th>Date Added</th>' . '</tr>' . '</thead>' . '</tbody>';
foreach ($results['page_list'] as $row) {
$this->session->unset_userdata('pdeid');
$status_str = '';
$addenda_str = '[NONE]';
$delete_str = '';
$edit_str = '';
if (!empty($level) && $level == 'active') {
$delete_str = '<a title="Delete bid invitation" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'bids/delete_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '\', \'Are you sure you want to delete this bid invitation?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="icon-trash"></i></a>';
$edit_str = '<a title="Edit bid details" href="' . base_url() . 'bids/load_bid_invitation_form/i/' . encryptValue($row['bidinvitation_id']) . '"><i class="icon-edit"></i></a>';
}
if ($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') < 0) {
$status_str = 'Bid evaluation | <a title="Select BEB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[Select BEB]</a>';
} elseif ($row['bid_approved'] == 'N') {
$status_str = 'Not published | <a title="Publish IFB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[Publish IFB]</a>';
} elseif ($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') > 0) {
$status_str = 'Bidding closes in ' . get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') . ' days | <a title="view IFB document" href="' . base_url() . 'bids/view_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[View IFB]</a>';
$addenda_str = '<a title="view addenda list" href="' . base_url() . 'bids/view_addenda/b/' . encryptValue($row['bidinvitation_id']) . '">[View Addenda]</a> | <a title="Add addenda" href="' . base_url() . 'bids/load_ifb_addenda_form/b/' . encryptValue($row['bidinvitation_id']) . '">[Add Addenda]</a>';
} else {
}
$table .= '<tr>' . '<td></td>' . '<td>' . format_to_length($row['procurement_ref_no'], 40) . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 50) . '</td>' . '<td>' . (is_numeric($row['bid_security_amount']) ? number_format($row['bid_security_amount'], 0, '.', ',') . ' ' . $row['bid_security_currency_title'] : (empty($row['bid_security_amount']) ? '<i>N/A</i>' : $row['bid_security_amount'])) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['invitation_to_bid_date']) . '</td>' . '<td>' . $addenda_str . '</td>' . '<td>' . $status_str . '</td>' . '<td>' . (empty($row['approver_fullname']) ? 'N/A' : $row['approver_fullname']) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['bid_dateadded']) . '</td>' . '</tr>';
}
$table .= '</tbody></table>';
$table .= '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $results['rows_per_page'], $results['current_list_page'], base_url() . "bids/manage_bid_invitations/" . $level . "/p/%d") . '</div>';
} else {
$table .= format_notice('WARNING: No bid invitations expiring this week');
}
$table .= "</div>";
$adons = '';
$entity = $records['pdeid'];
$this->session->set_userdata('pdeid', $entity);
if ($records['usergroup'] > 0) {
$level = $records['usergroup'];
$this->session->set_userdata('usergroup', $records['usergroup']);
// else
// $datasx = $this->session->set_userdata('level','ppda');
}
$entityname = $records['pdename'];
$adons = date('d-m');
$level = "Procurement";
$titles = "Weekly report on expiring IFBs of " . $entityname . $adons;
$body = " " . html_entity_decode($table);
$permission = "view_bid_invitations";
$xcv = 0;
push_permission($titles, $body, $level, $permission, $records['pdeid']);
}
break;
default:
# code...
break;
# exit();
}
}
} else {
$status_str = 'IN PROGRESS';
}
#if multiple providers..
$providername = $row['providernames'];
if (!empty($row['joint_venture'])) {
$providername = '';
$jv_info = $this->db->query('SELECT * FROM joint_venture WHERE jv = "' . $row['joint_venture'] . '"')->result_array();
if (!empty($jv_info[0]['providers'])) {
$providers = $this->db->query('SELECT * FROM providers WHERE providerid IN (' . rtrim($jv_info[0]['providers'], ',') . ')')->result_array();
foreach ($providers as $provider) {
$providername .= (!empty($providername) ? ', ' : '') . $provider['providernames'];
}
}
}
$table_HTML .= '<tr>' . ($formdata['contracts_report_type'] == 'AC' ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . custom_date_format('d M, Y', $row['date_signed']) . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CDC', 'LC')) ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . custom_date_format('d M, Y', $row['completion_date']) . '</td>' : '') . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . format_to_length($row['pdename'], 30) . '</td>' . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . $row['procurement_ref_no'] . '</td>' . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . $row['subject_of_procurement'] . '</td>' . '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . $providername . '</td>' . (in_array($formdata['contracts_report_type'], array('LC')) ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . get_date_diff(empty($row['actual_completion_date']) ? date('Y-m-d') : $row['actual_completion_date'], $row['completion_date'], 'days') . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align: left; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . custom_date_format('d M, Y', $row['actual_completion_date']) . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align: right; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . addCommas($row['total_amount_paid'], 0) . '</td>' : '') . '<td style="text-align: right; border-bottom: solid #000 1px; font-size:12px; font-family: Calibri, arial, sans-serif;">' . addCommas($row['total_price'], 0) . '</td>' . '</tr>';
$grand_contracts_value += $row['total_price'];
$grand_total_amount_paid += $row['total_amount_paid'];
}
$table_HTML .= '<tr>' . ($formdata['contracts_report_type'] == 'AC' ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CDC', 'LC')) ? '<td> </td>' : '') . '<td> </td>' . '<td> </td>' . '<td> </td>' . '<td> </td>' . (in_array($formdata['contracts_report_type'], array('LC')) ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align:right; font-weight:bold; font-size: 14px; font-family: Georgia">' . addCommas($grand_total_amount_paid, 0) . '</td>' : '') . '<td style="text-align:right; font-weight:bold; font-size: 16px; font-family: Georgia">' . addCommas($grand_contracts_value, 0) . '</td>' . '</tr>';
$table_HTML .= '</tbody></table>';
} elseif (!empty($formdata)) {
$table_HTML .= format_notice('Your search criteria does not match any results');
}
} else {
if (!empty($area) && $area == 'procurement_record_details') {
if (!empty($procurement_details)) {
$table_HTML .= '<div class="control-group subject_of_procurement">' . '<label class="control-label">Subject of procurement:</label>' . '<div class="controls">' . (!empty($procurement_details['subject_of_procurement']) ? $procurement_details['subject_of_procurement'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[subject_of_procurement]" value="' . $procurement_details['subject_of_procurement'] . '" />' . '</div>' . '</div>' . '<div class="control-group">' . '<label class="control-label">Financial year:</label>' . '<div class="controls">' . (!empty($procurement_details['financial_year']) ? $procurement_details['financial_year'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[financial_year]" value="' . $procurement_details['financial_year'] . '" />' . '</div>' . '</div>' . '<div class="control-group">' . '<label class="control-label">Source of funding:</label>' . '<div class="controls">' . (!empty($procurement_details['funding_source']) ? $procurement_details['funding_source'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[funding_source]" value="' . $procurement_details['funding_source'] . '"/>' . '</div>' . '</div>';
if (!empty($procurement_details['quantity'])) {
$total_ifb_q = $procurement_details['quantity'] - $procurement_details['total_ifb_quantity'];
$table_HTML .= '<div class="control-group">' . '<label class="control-label">Quantity:</label>' . '<div class="controls">' . (!empty($total_ifb_q) ? $total_ifb_q : '<i>undefined</i>') . '<input type="hidden" id="procurement_details_quantity" name="procurement_details_quantity" value="' . $total_ifb_q . '"/>' . '</div>' . '</div>';
$table_HTML .= "<tr style='" . get_row_color($counter, 2) . "'>" . "<td width='1%' valign='top' nowrap>[ <a href='" . base_url() . "index.php/settings/acravqueries/load_form/id/" . $row['id'] . "'>Edit</a> | <a href=\"javascript:deleteEntity('" . base_url() . "index.php/settings/acravqueries/delete_query_data/id/" . $row['id'] . "','query','" . $row['querycode'] . "');\">Delete</a> ]</td>" . "<td width='1%' valign='top'>" . $row['querycode'] . "</td>" . "<td width='1%' valign='top'>" . $row['description'] . "</td>" . "<td width='97%' valign='top'>" . $row['query'] . "</td>" . "</tr>";
$counter++;
}
} else {
if ($area == 'searchhelp') {
if (isset($inpop)) {
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>";
} else {
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>" . "<tr>" . " <td colspan='4'><hr /></td>" . "</tr>" . "<tr>" . "<td> </td>" . "<td nowrap><b>Page</b></td>" . "<td nowrap><b>Help Topic</b></td>" . "<td nowrap><b>Help Content</b></td>" . "</tr>" . "<tr>" . "<td colspan='4'><hr /></td>" . "</tr>";
}
$counter = 0;
foreach ($searchdata as $row) {
if (isset($inpop)) {
$table_HTML .= "<tr style='" . get_row_color($counter, 2) . "'><td nowrap><a href=\"javascript:showFormLayer('" . base_url() . "index.php/settings/acravhelp/load_form/id/" . $row['id'] . "/ispop/Y/layername/" . $row['id'] . "_div','" . $row['id'] . "_div')\">" . $row['topic'] . "</a><br>" . "<div id='" . $row['id'] . "_div' style='visibility:hidden; height:0px'></div>" . "</td></tr>";
} else {
$table_HTML .= "<tr style='" . get_row_color($counter, 2) . "'>" . "<td width='1%' valign='top' nowrap>[ <a href='" . base_url() . "index.php/settings/acravhelp/load_form/id/" . $row['id'] . "'>Edit</a>" . " | <a href=\"javascript:deleteEntity('" . base_url() . "index.php/settings/acravhelp/delete_help_data/id/" . $row['id'] . "','help topic','" . $row['topic'] . "');\">Delete</a> ]</td>" . "<td width='1%' valign='top'>" . $row['page'] . "</td>" . "<td width='1%' valign='top'>" . $row['topic'] . "</td>" . "<td width='97%' valign='top'>" . format_to_length($row['content'], 200) . "</td>" . "</tr>";
}
$counter++;
}
$table_HTML .= "</table>";
} else {
if ($area == 'searchdetails') {
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>" . "<tr><td><input name='closediv' type='button' id='closediv' value='Close' " . "onclick=\"hideDiv('" . $layername . "')\" class='button'/></td></tr>" . "<tr><td>" . $helpdetails['content'] . "</td></tr>" . "</table>";
} else {
if ($area == 'templaterights') {
$table_HTML = "<table width='100%' border='0' cellspacing='0' cellpadding='4'>" . "<tr><td><b>User Rights for Template \"" . format_user_type($value) . "\"</b></td></tr>";
$i = 0;
#Show the rights
foreach ($rights as $rightdefn) {
$table_HTML .= "<tr style='" . get_row_color($i, 2) . "'><td>" . $rightdefn['definition'] . "</td></tr>";
$i++;
$status_str = '';
$completion_str = '';
if (!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date']) > 0) {
$status_str = '<span class="label label-success label-mini">Completed</span>';
$completion_str = '<a title="Click to view contract completion details" href="' . base_url() . 'contracts/contract_completion_form/c/' . encryptValue($row['id']) . '/v/' . encryptValue('view') . '"><i class="fa fa-eye"></i></a>';
} else {
$status_str = '<span class="label label-warning label-mini">Awarded</span>';
$completion_str = '<a title="Click to enter contract completion details"" href="' . base_url() . 'contracts/contract_completion_form/c/' . encryptValue($row['id']) . '"><i class="fa fa-check"></i></a>';
}
$termintate_str = '<a href="#"><i class="fa fa-times-circle"></i></a>';
$more_actions = '<div class="btn-group" style="font-size:10px">
<a href="#" class="btn btn-primary">more</a><a href="javascript:void(0);" data-toggle="dropdown" class="btn btn-primary dropdown-toggle"><span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu">
<li><a href="#"><i class="fa fa-times-circle"></i></a></li>
<li class="divider"></li>
<li>' . $completion_str . '</li>
</ul>
</div>';
print '<tr>' . '<td>';
if ($this->session->userdata('isadmin') == 'N') {
print $delete_str . ' ' . $edit_str . ' ' . $termintate_str . ' ' . $completion_str;
}
print ' </td>' . '<td>' . custom_date_format('d M, Y', $row['date_signed']) . '</td>' . '<td>' . format_to_length($row['procurement_ref_no'], 30) . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 30) . '</td>' . '<td>' . $status_str . '</td>' . '<td style="text-align:right; font-family:Georgia; font-size:14px">' . addCommas($row['total_price'], 0) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['dateadded']) . ' by ' . format_to_length($row['authorname'], 10) . '</td>' . '</tr>';
}
print '</tbody></table>';
} else {
print format_notice('WARNING: No contracts have been signed in the system');
}
?>
</div>
</div>
<div class="widget">
<div class="widget-title">
<h4><i class="icon-reorder"></i> Manage addenda</h4>
<span class="tools">
<a href="javascript:;" class="icon-chevron-down"></a>
<a href="javascript:;" class="icon-remove"></a>
</span>
</div>
<div class="widget-body" id="results">
<?php
if (!empty($page_list)) {
print '<table class="table table-striped table-hover">' . '<thead>' . '<tr>' . '<th width="5%"></th>' . '<th>Financial year</th>' . '<th>Procurement Ref. No</th>' . '<th class="hidden-480">Procurement subject</th>' . '<th class="hidden-480">Addenda title</th>' . '<th class="hidden-480">Author</th>' . '<th class="hidden-480">Date added</th>' . '<th></th>' . '</tr>' . '</thead>' . '</tbody>';
foreach ($page_list as $row) {
$delete_str = '<a title="Delete addenda" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'bids/delete_addenda/b/' . encryptValue($row['bidid']) . '/i/' . encryptValue($row['addenda_id']) . '\', \'Are you sure you want to delete this addenda?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>';
$edit_str = '<a title="Edit addenda details" href="' . base_url() . 'bids/load_ifb_addenda_form/i/' . encryptValue($row['addenda_id']) . '/b/' . encryptValue($row['bidid']) . '"><i class="fa fa-edit"></i></a>';
$addenda_url = empty($row['fileurl']) ? '<i>N/A</i>' : '<a target="_new" href="' . base_url() . 'uploads/documents/addenda/' . $row['fileurl'] . '">Download current file</a>';
print '<tr>' . '<td>' . $delete_str . ' ' . $edit_str . '</td>' . '<td>' . $row['financial_year'] . '</td>' . '<td>' . $row['procurement_ref_no'] . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 50) . '</td>' . '<td>' . format_to_length($row['title'], 50) . '</td>' . '<td>' . $row['authorname'] . '</td>' . '<td>' . custom_date_format('d M, Y', $row['dateadded']) . '</td>' . '<td>' . $addenda_url . '</td>' . '</tr>';
}
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "bids/manage_bid_invitations/p/%d") . '</div>';
} else {
print format_notice('WARNING: No addenda has been added for the selected IFB. Click <i><a title="view IFB document" href="' . base_url() . 'bids/load_ifb_addenda_form/b/' . $b . '">here</a></i> to add an addendum');
}
?>
</div>
</div>
if (!empty($level) && $level == 'active') {
$delete_str = '<a title="Delete bid invitation" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'bids/delete_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '\', \'Are you sure you want to delete this bid invitation?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>';
$edit_str = '<a title="Edit bid details" href="' . base_url() . 'bids/load_bid_invitation_form/i/' . encryptValue($row['bidinvitation_id']) . '"><i class="fa fa-edit"></i></a>';
}
/*if($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days')<0)
{
$status_str = 'Bid evaluation | <a title="Select BEB" href="'. base_url() .'bids/approve_bid_invitation/i/'.encryptValue($row['bidinvitation_id']).'">[Select BEB]</a>';
} */
if ($row['bid_approved'] == 'N') {
$status_str = 'Not published | <a title="Publish IFB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[Publish IFB]</a>';
} elseif ($row['bid_approved'] == 'Y') {
if (get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') > 0) {
$status_strs = 'Bidding closes in ' . get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') . ' days';
} else {
$status_strs = 'Bidding closed ' . get_date_diff($row['bid_submission_deadline'], date('Y-m-d'), 'days') . ' days ago';
}
$status_str = $status_strs . '| <a title="view IFB document" href="' . base_url() . 'bids/view_bid_invitation/i/' . encryptValue($row['bidinvitation_id']) . '">[View IFB]</a>';
$addenda_str = '<a title="view addenda list" href="' . base_url() . 'bids/view_addenda/b/' . encryptValue($row['bidinvitation_id']) . '">[View Addenda]</a> | <a title="Add addenda" href="' . base_url() . 'bids/load_ifb_addenda_form/b/' . encryptValue($row['bidinvitation_id']) . '">[Add Addenda]</a>';
} else {
}
print '<tr>' . '<td>' . $delete_str . ' ' . $edit_str . '</td>' . '<td>' . format_to_length($row['procurement_ref_no'], 40) . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 50) . '</td>' . '<td>' . (is_numeric($row['bid_security_amount']) ? number_format($row['bid_security_amount'], 0, '.', ',') . ' ' . $row['bid_security_currency_title'] : (empty($row['bid_security_amount']) ? '<i>N/A</i>' : $row['bid_security_amount'])) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['invitation_to_bid_date']) . '</td>' . '<td>' . $addenda_str . '</td>' . '<td>' . $status_str . '</td>' . '<td>' . (empty($row['approver_fullname']) ? 'N/A' : $row['approver_fullname']) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['bid_dateadded']) . '</td>' . '</tr>';
}
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $page_list['rows_per_page'], $page_list['current_list_page'], base_url() . "bids/manage_bid_invitations/" . $level . "/p/%d") . '</div>';
} else {
print format_notice('WARNING: No bid invitations have been added to the system');
}
?>
</div>
</div>
function monthlyreportonexpiringcontracts($level)
{
$urldata = $this->uri->uri_to_assoc(3, array('m', 'p'));
# Pick all assigned data
$data = assign_to_data($urldata);
$data = add_msg_if_any($this, $data);
$data = handle_redirected_msgs($this, $data);
$search_str ='';
# code...
$querys = $this->db->query("select distinct b.pdeid,b.pdename,a.* from pdes b inner join users a on a.pde = b.pdeid ")->result_array();
foreach($querys as $row => $records )
{
$entityname = $records['pdename'];
$search_str = '';
$search_str .= 'AND PP.pde_id ='.$records['pdeid'].' AND C.completion_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 10 DAY)';
$query = $this->Query_reader->get_query_by_code('get_published_contracts', array('orderby'=>'C.date_signed DESC', 'limittext'=>'','searchstring'=>' AND PPE.isactive ="Y" AND BI.isactive = "Y" AND C.isactive="Y"' . $search_str));
$result = $this->db->query($query)->result_array();
print_r($this->db->last_query());
$str = '<style>.tablex tr th{text-align:left; background:#ccc; padding:20px; text-transform:uppercase;} .tablex tr td{border:1px solid #eee; padding:5px; font-size:15px;}</style> <div class="widget-body" id="results" style="width:100%;">';
if(!empty($result))
{
$str .= '<h2 style="width:100%; text-align:center; padding:5px;">CONTRACTS SOON EXPIRING THIS MONTH FOR '.$records['pdename'].'</h2> <table class="table tablex table-striped table-hover" style="width:100%; padding:5px;">'.
'<thead>'.
'<tr style="width:100%; padding:5px; border:1px solid #eee;" >'.
'<th width="94px"></th>';
if($this->session->userdata('isadmin') == 'N')
{
$str .= '<th> Procuring And Diposing Entity </th>';
}
$str .= '<th>Date signed</th>'.
'<th>Procurement Reference Number </th>'.
'<th>Subject of procurement</th>'.
'<th>Status</th>'.
'<th style="text-align:right">Contract amount (UGX)</th>'.
'<th class="hidden-480">Date added</th>'.
'</tr>'.
'</thead>'.
'</tbody>';
foreach ($result as $key => $row) {
# code...
$edit_str = '';
$delete_str = '';
if(!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date'])>0)
{
$delete_str = '<a title="Delete contract details" href="javascript:void(0);" onclick="confirmDeleteEntity(\''.base_url().'contracts/delete_contract/i/'.encryptValue($row['id']).'\', \'Are you sure you want to delete this contract?\nClick OK to confirm, \nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>';
$termintate_str = '';
}else
{
$termintate_str = '<a href="'. base_url() .'contracts/contract_termination/i/'.encryptValue($row['id']) .'" title="Click to terminate contract"><i class="fa fa-times-circle"></i></a>';
$edit_str = '<a title="Edit contract details" href="'. base_url() .'contracts/contract_award_form/i/'.encryptValue($row['id']).'"><i class="fa fa-edit"></i></a>';
}
$status_str = '';
$completion_str = '';
if(!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date'])>0)
{
$status_str = '<span class="label label-success label-mini">Completed</span>';
$completion_str = '<a title="Click to view contract completion details" href="'. base_url() .'contracts/contract_completion_form/c/'.encryptValue($row['id']).'/v/'. encryptValue('view') .'"><i class="fa fa-eye"></i></a>';
}
else
{
$status_str = '<span class="label label-warning label-mini">Awarded</span>';
$completion_str = '<a title="Click to enter contract completion details"" href="'. base_url() .'contracts/contract_completion_form/c/'.encryptValue($row['id']) .'"><i class="fa fa-check"></i></a>';
}
$variations = ' <a class="view_variations" id="view_'.$row['id'].'" data-ref="'. base_url() .'contracts/contract_variation_view/i/'.encryptValue($row['id']) .'" title="Click to view Variations "><i class="fa fa-bars"></i></a> ';
if(empty($row['actual_completion_date']) )
{
$variations .= '<a href="'. base_url() .'contracts/contract_variation_add/i/'.encryptValue($row['id']) .'" title="Click to Add Variations "><i class="fa fa-plus-circle "></i></a> ';
}
$more_actions = '<div class="btn-group" style="font-size:10px">
<a href="#" class="btn btn-primary">more</a><a href="javascript:void(0);" data-toggle="dropdown" class="btn btn-primary dropdown-toggle"><span class="fa fa-caret-down"></span></a>
<ul class="dropdown-menu">
<li><a href="#"><i class="fa fa-times-circle"></i></a></li>
<li class="divider"></li>
<li>'. $completion_str .'</li>
</ul>
</div>';
$str .= '<tr>'.
'<td>';
if($this->session->userdata('isadmin') == 'N')
$str .= $delete_str .' '. $edit_str .' '. $termintate_str .' '.$completion_str.' '.$variations;;
$str .= ' </td>';
if($this->session->userdata('isadmin') == 'N')
{
$str .= '<th> '.$row['pdename'].' </th>';
}
$str .= '<td>'. custom_date_format('d M, Y',$row['date_signed']) .'</td>'.
'<td>'. format_to_length($row['procurement_ref_no'], 30) .'</td>'.
'<td>'. format_to_length($row['subject_of_procurement'], 30).'';
if($row['pmethod'] == 'Framework and Special Contracts' )
{
$str .= '<br/><a href="#" id="'.$row['id'].'" class="togglecalloforders" > Add Call off Order </a> | <a href="#" data-procurement="'.$row['procurement_ref_no'].'" id="'.$row['id'].'" class="viewlistcalloff" >View Call off Orders </a> </br/>';
}
$str .= '</td>'.
'<td>'. $status_str .'</td>'.
'<td style="text-align:right; font-family:Georgia; font-size:14px">'. addCommas($row['total_price'], 0) .'</td>'.
'<td>'. custom_date_format('d M, Y', $row['dateadded']) .' by '. format_to_length($row['authorname'], 10) .'</td>'.
'</tr>';
}
$str .= '</tbody></table>';
}
else
{
$str .="<h2> No Records Expiring soon this month for ".$entityname." </h2>";
}
$str .= '</div>';
$adons = ' | '.date('d-m-y');
$level = "Procurement";
$titles = "Monthly Report on Soon Expiring Contracts for ".$entityname.'| '. $adons;
$body = " ".html_entity_decode($str);
$permission = "view_bid_invitations";
$this-> push_permission($titles,$body,$level,$permission,$records ['pdeid']);
echo $body;
}
}
</script><div class="widget">
<div class="widget-title">
<h4><i class="fa fa-reorder"></i> Manage users</h4>
<span class="tools">
<a href="javascript:;" class="fa fa-chevron-down"></a>
<a href="javascript:;" class="fa fa-remove"></a>
</span>
</div>
<div class="widget-body" id="results">
<?php
if (!empty($page_list)) {
print '<table class="table table-striped table-hover">' . '<thead>' . '<tr>' . '<th width="5%"></th>' . '<th>Name</th>' . '<th class="hidden-480">PDE</th>' . '<th class="hidden-480">User Group</th>' . '<th class="hidden-480">Email Address</th>' . '<th class="hidden-480">Phone No.</th>' . '<th>Date Added</th>' . '</tr>' . '</thead>' . '</tbody>';
foreach ($page_list as $row) {
#user's role(s)
$user_roles_arr_text = get_user_roles_text($this, $row['userid'], $usergroups);
$user_roles_text = !empty($user_roles_arr_text) ? implode(', ', $user_roles_arr_text) : '<i>NONE</i>';
$delete_str = '<a title="Delete user details" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'admin/delete_user/i/' . encryptValue($row['userid']) . '\', \'Are you sure you want to delete this user?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>';
$edit_str = '<a title="Edit user details" href="' . base_url() . 'user/load_user_form/i/' . encryptValue($row['userid']) . '"><i class="fa fa-edit"></i></a>';
print '<tr>' . '<td>' . $delete_str . ' ' . $edit_str . '</td>' . '<td>' . (!empty($row['prefix']) ? $row['prefix'] . ' ' : '') . $row['firstname'] . ' ' . $row['lastname'] . '</td>' . '<td>' . $row['pdename'] . '</td>' . '<td>' . format_to_length($user_roles_text, 50) . '</td>' . '<td>' . $row['emailaddress'] . '</td>' . '<td>' . $row['telephone'] . '</td>' . '<td>' . custom_date_format('d M, Y', $row['dateadded']) . '</td>' . '</tr>';
}
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "admin/manage_users/p/%d") . '</div>';
} else {
print format_notice('WARNING: No users have been added to the system');
}
?>
</div>
</div>
<div class="widget-body" id="results">
<?php
if (!empty($page_list)) {
print '<table class="table table-striped table-hover">' . '<thead>' . '<tr>' . '<th width="5%"></th>' . '<th>Procurement Ref. No</th>' . '<th class="hidden-480">PDE</th>' . '<th class="hidden-480">Procurement subject</th>' . '<th class="hidden-480">Procurement type</th>' . '<th class="hidden-480">Status</th>' . '<th>Date Added</th>' . '</tr>' . '</thead>' . '</tbody>';
foreach ($page_list as $row) {
$delete_str = '<a title="Delete procurement" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'bids/delete_bid_invitation/i/' . encryptValue($row['procurement_id']) . '\', \'Are you sure you want to delete this bid invitation?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="icon-trash"></i></a>';
$edit_str = '<a title="Edit procurement details" href="' . base_url() . 'bids/load_bid_invitation_form/i/' . encryptValue($row['procurement_id']) . '"><i class="icon-edit"></i></a>';
$status_str = '';
if ($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') < 0) {
$status_str = 'Bid evaluation | <a title="Select BEB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bid_invitation_id']) . '">[Select BEB]</a>';
} elseif ($row['bid_approved'] == 'N') {
$status_str = 'Pending Approval | <a title="Approve bid details" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bid_invitation_id']) . '">[Approve invitation]</a>';
} elseif ($row['bid_approved'] == 'Y' && get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') > 0) {
$status_str = 'Bidding expires in ' . get_date_diff(date('Y-m-d'), $row['bid_submission_deadline'], 'days') . ' days | <a title="halt bidding" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bid_invitation_id']) . '">[Halt bidding]</a>';
} elseif ($row['initiation_status'] == 'Y') {
$status_str = 'Procurement initiated | <a title="Create IFB" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bid_invitation_id']) . '">[Create IFB]</a>';
} elseif ($row['initiation_status'] == 'N') {
$status_str = 'Pending initiation approval | <a title="Approve initiation" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bid_invitation_id']) . '">[Approve initiation]</a>';
} else {
$status_str = 'Procurement not initiated | <a title="Initiate procurement" href="' . base_url() . 'bids/approve_bid_invitation/i/' . encryptValue($row['bid_invitation_id']) . '">[Initiate]</a>';
}
print '<tr>' . '<td>' . $delete_str . ' ' . $edit_str . '</td>' . '<td>' . $row['procurement_ref_no'] . '</td>' . '<td>' . $row['pdename'] . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 80) . '</td>' . '<td>' . $row['procurement_type'] . '</td>' . '<td>' . $status_str . '</td>' . '<td>' . custom_date_format('d M, Y', $row['date_procurement_added']) . '</td>' . '</tr>';
}
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "user/dashboard/p/%d") . '</div>';
} else {
print format_notice('WARNING: No procurement entries have been added to the system');
}
?>
</div>
</div>
$delete_str = '';
$edit_str = '';
$create_entry_str = '';
foreach ($procurement['page_list'] as $row) {
if ($delete_rights) {
$delete_str = '<a title="Delete plan" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'procurement/delete_plan/i/' . encryptValue($row['plan_id']) . '\', \'Are you sure you want to delete this plan?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>';
}
if ($edit_rights) {
$edit_str = '<a title="Edit plan details" href="' . base_url() . 'procurement/procurement_plan_form/i/' . encryptValue($row['plan_id']) . '"><i class="fa fa-edit"></i></a>';
}
if ($create_entry_rights) {
$create_entry_str = ' | ' . '<a href="' . base_url() . 'procurement/load_procurement_entry_form/v/' . encryptValue($row['plan_id']) . '">' . 'Create entry' . '</a>';
}
$status_str = '';
$addenda_str = '[NONE]';
print '<tr>' . '<td class="' . $status2 . '">' . $delete_str . ' ' . $edit_str . '</td>' . '<td class="' . $status . '" >' . $row['pdename'] . '</td>' . '<td>' . format_to_length($row['financial_year'], 50) . '</td>' . '<td>' . '<a href="' . base_url() . 'procurement/procurement_plan_entries/v/' . encryptValue($row['plan_id']) . '">' . '<span class="badge badge-info">' . $row['numOfEntries'] . '</span>' . ' Entries' . '</a>' . $create_entry_str . '</td>' . '<td>' . $row['firstname'] . ' ' . $row['lastname'] . '</td>' . '<td>' . custom_date_format('d M, Y', $row['dateadded']) . '</td>' . '</tr>';
}
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $procurement['rows_per_page'], $procurement['current_list_page'], base_url() . "procurement/page/p/%d") . '</div>';
} else {
print format_notice('WARNING: No procurement plan has been created yet. ' . 'Click <a href="' . base_url() . 'procurement/procurement_plan_form">' . ' here</a> to create the first procurement plan');
}
?>
</div>
</div>
<!-- END SAMPLE TABLE widget-->
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
if (!empty($row['actual_completion_date']) && str_replace('-', '', $row['actual_completion_date']) > 0) {
$status_str = 'COMPLETE';
} else {
$status_str = 'IN PROGRESS';
}
#if multiple providers..
$providername = $row['providernames'];
if (!empty($row['joint_venture'])) {
$providername = '';
$jv_info = $this->db->query('SELECT * FROM joint_venture WHERE jv = "' . $row['joint_venture'] . '"')->result_array();
if (!empty($jv_info[0]['providers'])) {
$providers = $this->db->query('SELECT * FROM providers WHERE providerid IN (' . rtrim($jv_info[0]['providers'], ',') . ')')->result_array();
foreach ($providers as $provider) {
$providername .= (!empty($providername) ? ', ' : '') . $provider['providernames'];
}
}
}
print '<tr>' . ($formdata['contracts_report_type'] == 'AC' ? '<td>' . custom_date_format('d M, Y', $row['date_signed']) . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CDC', 'LC')) ? '<td>' . custom_date_format('d M, Y', $row['completion_date']) . '</td>' : '') . '<td>' . format_to_length($row['pdename'], 30) . '</td>' . '<td>' . $row['procurement_ref_no'] . '</td>' . '<td>' . $row['subject_of_procurement'] . '</td>' . '<td>' . format_to_length($providername, 40) . '</td>' . (in_array($formdata['contracts_report_type'], array('LC')) ? '<td>' . get_date_diff(empty($row['actual_completion_date']) ? date('Y-m-d') : $row['actual_completion_date'], $row['completion_date'], 'days') . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td>' . custom_date_format('d M, Y', $row['actual_completion_date']) . '</td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align:right; font-family: Georgia">' . addCommas($row['total_amount_paid'], 0) . '</td>' : '') . '<td style="text-align:right; font-family: Georgia">' . addCommas($row['total_price'], 0) . '</td>' . '</tr>';
$grand_contracts_value += $row['total_price'];
$grand_total_amount_paid += $row['total_amount_paid'];
}
print '<tr>' . ($formdata['contracts_report_type'] == 'AC' ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CDC', 'LC')) ? '<td> </td>' : '') . '<td> </td>' . '<td> </td>' . '<td> </td>' . '<td> </td>' . (in_array($formdata['contracts_report_type'], array('LC')) ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td> </td>' : '') . (in_array($formdata['contracts_report_type'], array('CC')) ? '<td style="text-align:right; font-weight:bold; font-size: 14px; font-family: Georgia">' . addCommas($grand_total_amount_paid, 0) . '</td>' : '') . '<td style="text-align:right; font-weight:bold; font-size: 14px; font-family: Georgia">' . addCommas($grand_contracts_value, 0) . '</td>' . '</tr>';
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $rows_per_page, $current_list_page, base_url() . "#") . '</div>';
} elseif (!empty($formdata)) {
print format_notice('WARNING: Your search criteria does not match any results');
}
?>
</div>
<?php
}
<div class="widget-body" id="results">
<?php
if (!empty($procurement_entries['page_list'])) {
print '<table class="table table-striped table-hover">' . '<thead>' . '<tr>' . '<th width="5%"></th>' . '<th class="hidden-480">Subject of procurement</th>' . '<th class="hidden-480">Source of funding</th>' . '<th class="hidden-480">Estimated amount</th>' . '<th class="hidden-480">QUANTITY</th>' . '<th>Author</th>' . '<th>Date Added</th>' . '</tr>' . '</thead>' . '</tbody>';
$delete_rights = check_user_access($this, 'delete_procurement_entry');
$edit_rights = check_user_access($this, 'edit_procurement_entry');
$delete_str = '';
$edit_str = '';
foreach ($procurement_entries['page_list'] as $row) {
if ($delete_rights) {
$delete_str = '<a title="Delete entry" href="javascript:void(0);" onclick="confirmDeleteEntity(\'' . base_url() . 'procurement/delete_entry/i/' . encryptValue($row['entryid']) . '\', \'Are you sure you want to delete this entry?\\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.\')"><i class="fa fa-trash"></i></a>';
}
if ($edit_rights) {
$edit_str = '<a title="Edit entry details" href="' . base_url() . 'procurement/load_procurement_entry_form/i/' . encryptValue($row['entryid']) . '"><i class="fa fa-edit"></i></a>';
}
print '<tr>' . '<td>' . $delete_str . ' ' . $edit_str . '</td>' . '<td>' . format_to_length($row['subject_of_procurement'], 50) . '</td>' . '<td>' . $row['funding_source'] . '</td>' . '<td>' . (is_numeric($row['estimated_amount']) ? number_format($row['estimated_amount'], 0, '.', ',') . ' ' . $row['currency_abbr'] : $row['estimated_amount']) . '</td>' . '<td>' . (is_numeric($row['estimated_amount']) ? number_format($row['quantity'], 0, '.', ',') : $row['quantity']) . '</td>' . '<td>' . (empty($row['authorname']) ? 'N/A' : $row['authorname']) . '</td>' . '<td>' . custom_date_format('d M, Y', $row['dateadded']) . '</td>' . '</tr>';
}
print '</tbody></table>';
print '<div class="pagination pagination-mini pagination-centered">' . pagination($this->session->userdata('search_total_results'), $procurement_entries['rows_per_page'], $procurement_entries['current_list_page'], base_url() . "procurement/procurement_plan_entries/v/" . $v . "/p/%d") . '</div>';
} else {
print format_notice('WARNING: There are no procurement entries for the ' . $plan_info['financial_year'] . '. <br />' . 'Click <a href="' . base_url() . 'procurement/load_procurement_entry_form/v/' . encryptValue($plan_info['id']) . '">' . '<i>here</i></a> to create the first entry');
}
?>
</div>
</div>
<!-- END SAMPLE TABLE widget-->
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){