function weeklybebreport($level)
{
switch ($level) {
case 'ppda':
# code...
//fetch beb weekly report ::
$urldata = $this->uri->uri_to_assoc(3, array('m'));
# Pick all assigned data
$data = assign_to_data($urldata);
$searchstring = '';
$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 ";"
$searchstring = ' AND a.pde_id='. $records['pdeid'] .' AND ( bestevaluatedbidder.beb_expiry_date > DATE_SUB(NOW() - INTERVAL 7 DAY , INTERVAL 1 WEEK) AND bestevaluatedbidder.beb_expiry_date <= CURDATE() ) ';
$query = $this->Query_reader->get_query_by_code('fetchbebs', array('SEARCHSTRING' => $searchstring.' and bestevaluatedbidder.ispublished = "Y" and receipts.beb="Y" order by bestevaluatedbidder.dateadded DESC','limittext'=>''));
# print_r($query);
# exit();
$result = $this ->db->query($query)->result_array();
if(!empty($result))
{
$st = ' <table><tr>
<th> <b>Date Posted</b> </th> <th > <b>Procuring/Disposing Entity</b></th>
<th> <b>Procurement Reference Number</b> </th>
<th> <b>Selected Provider</b> </th> <th > <b>Subject </b> </th>
<th> <b>Date BEB Expires</b> </th> <th > <b>Status</b> </th><th> <b>BEB Price </b></th>
</tr>';
foreach ($result as $key => $row) {
# code...
$st .= '<tr><td >'.
custom_date_format('d M, Y', $row['dateadded']).
'</td> <td class="col-md-2">'.$row['pdename'].
'</td><td class="col-md-2">'.$row['procurement_ref_no'].
' </td> <td class="col-md-2">';
if(((strpos($row['providernames'] ,",")!== false)) || (preg_match('/[0-9]+/', $row['providernames'] )))
{
$label = '';
$providers = rtrim($row['providernames'],",");
$rows= mysql_query("SELECT * FROM `providers` where providerid in ($providers) ") or die("".mysql_error());
$provider = "";
$x = 0;
$xl = 0;
while($vaue = mysql_fetch_array($rows))
{
$x ++;
if(mysql_num_rows($rows) > 1)
{
$lead = '';
#print_r($provider_array);
if ($row['providerlead'] == $vaue['providerid']) {
$lead = ' <span class="label" title="Project Lead " style="cursor:pointer;background:#fff;color:orange;padding:0px;margin:0px; margin-left:-15px; font-size:18px; " >*</span>';
#break;
}
else{
$lead = '';
}
$provider .= "<li>";
$provider .= strpos($vaue['providernames'] ,"0") !== false ? '' : $lead.$vaue['providernames'];
$provider .= "</li>";
}else{
$provider .=strpos($vaue['providernames'] ,"0") !== false ? '' : $vaue['providernames'];
}
}
if(mysql_num_rows($rows) > 1){
$provider .= "</ul>";}
else{
$provider = rtrim($provider,' ,');
}
if($x > 1)
$label = '<span class="label label-info">Joint Venture</span>';
$st .=$provider.' '.$label;
$x = 0 ;
$label = '';
}
else{ $st .=$row['providernames'];}
$st .= '</td> <td class="col-md-1">'.$row['subject_of_procurement'].
' </td> <td class="col-md-1">';
$st .= $row['beb_expiry_date'].
// date("d M, Y",strtotime($row['beb_expiry_date'])).
'</td> <td class="col-md-1">';
switch($row['isreviewed'])
{
case 'Y':
$st .=" <span class='label label-info '> For Admin Review </span> <br/> <span class='label label-success'>".$row['review_level']." </span> <br/>";
# print "<span class='label label-info'".$row['review_level']."</span>";
//class="label label-info"
break;
case 'N':
$st .=" <span class='btn btn-xs btn-success'> Active </span>";
break;
default:
$st .="-";
break;
}
$st .= '</td> <td class="col-md-2">';
$readout = mysql_query("SELECT * FROM readoutprices WHERE receiptid=".$row['receiptid']."");
if(mysql_num_rows($readout) > 0 )
{
$st .="<ul>";
while ( $valsue = mysql_fetch_array($readout)) {
if($valsue['readoutprice']<=0)
continue;
# code...
$st .= "<li>".number_format($valsue['readoutprice']).$valsue['currence']."</li>";
}
$st .= "</ul>";
}
$st .= ' </td> </tr>';
}
$st .='</table></div>';
print_r($st);
//push notificationss ::
$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 Best Evaluated Bidders of ".$entityname.$adons;
$body = " ".html_entity_decode($st);
$permission = "view_bid_invitations";
$xcv = 0;
push_permission($titles,$body,$level,$permission,$records['pdeid']);
}
else
{
}
// print_r($result);
}
break;
default:
# code...
break;
}
}
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();
}
}
function procurement_record_details()
{
# Get the passed details into the url data array if any
$urldata = $this->uri->uri_to_assoc(3, array('m', 'b'));
# Pick all assigned data
$data = assign_to_data($urldata);
$notify = 0;
if (!empty($data['notification'])) {
$notify = 1;
}
if ($this->input->post('proc_id')) {
$_POST = clean_form_data($_POST);
$app_select_str = ' procurement_plan_entries.isactive="Y" ';
if ($this->session->userdata('isadmin') == 'N') {
$userdetails = $this->db->get_where('users', array('userid' => $this->session->userdata('userid')))->result_array();
$app_select_str .= ' AND procurement_plans.pde_id ="' . $userdetails[0]['pde'] . '"';
}
#$query = $this->Query_reader->get_query_by_code('ProcurementPlanDetails', array('searchstring'=>$app_select_str . ' AND procurement_plan_entries.id="'. $_POST['proc_id'] .'"', 'limittext'=>'', 'orderby'=>' procurement_plan_entries.dateadded ' ));
#print_r($query); exit();
//procurement details
#$data['procurement_details'] = $this->Query_reader->get_row_as_array('ProcurementPlanDetails', array('searchstring'=>$app_select_str . ' AND receipts.beb="Y" AND procurement_plan_entries.id="'. $_POST['proc_id'] .'"', 'limittext'=>'', 'orderby'=>' procurement_plan_entries.dateadded ' ));
$data['procurement_details'] = $this->Query_reader->get_row_as_array('ProcurementPlanDetails', array('searchstring' => $app_select_str . ' AND procurement_plan_entries.id="' . $_POST['proc_id'] . '"', 'limittext' => '', 'orderby' => ' procurement_plan_entries.dateadded '));
#get provider info
if (!empty($data['b'])) {
$data['provider'] = $this->Query_reader->get_row_as_array('get_IFB_BEB', array('searchstring' => ' AND BI.procurement_id="' . $_POST['proc_id'] . '" AND beb="Y"'));
if (!empty($data['provider']) && empty($data['provider']['providerid'])) {
$jv_info = $this->db->query('SELECT * FROM joint_venture WHERE jv = "' . $data['provider']['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();
$data['provider']['providernames'] = '';
foreach ($providers as $provider) {
$data['provider']['providernames'] .= (!empty($data['provider']['providernames']) ? ', ' : '') . $provider['providernames'];
}
}
}
#exit($this->db->last_query());
}
}
// $data['area'] = 'procurement_record_details';
// $this->load->view('includes/add_ons', $data);
if ($notify == 1) {
print_r($data['provider']['providername']);
if (!empty($data['provider']['providername'])) {
print_r($data['provider']['providerid']);
$providerid = $data['provider']['providerid'];
if (is_numeric($providerid)) {
$procurementdetails = $this->db->query('SELECT * FROM providers WHERE providerid IN (' . rtrim($data['provider']['providerid'], ',') . ') ')->result_array();
} else {
#$query = 'SELECT * FROM providers WHERE providerid IN (SELECT TRIM(TRAILING "," FROM providers) FROM joint_venture WHERE jv = "'.$data['provider']['providername'].'" ) ';
#echo $query;
$procurementdetails = $this->db->query('SELECT * FROM providers WHERE providerid IN (SELECT TRIM(TRAILING "," FROM providers) FROM joint_venture WHERE jv = "' . $data['provider']['providername'] . '" ) ')->result_array();
}
#print_r($procurementdetails);
$providers = '<ul>';
$xc = '';
#$suspended = '';
$status = 0;
foreach ($procurementdetails as $key => $value) {
#check provider
$xc = searchprovidervalidity($value['providernames']);
if (!empty($xc)) {
$status = 1;
$providers .= "<li> " . $value['providernames'] . " " . '</li>';
# $suspended .= $value['providernames'].',';
}
}
$providers .= '<ul>';
$rand = rand(23454, 83938);
$this->session->set_userdata('level', 'ppda');
$userid = $this->session->userdata('userid');
$query1 = $this->db->query("SELECT CONCAT(firstname,',',lastname) AS names FROM users WHERE userid=" . $userid . " limit 1")->result_array();
$level = "Disposal";
$entity = $this->session->userdata('pdeid');
$query = $this->db->query("SELECT * FROM pdes WHERE pdeid=" . $entity . " limit 1")->result_array();
$entityname = $query[0]['pdename'];
$titles = " Attemp to award a contract to suspended provider(s) by " . $entityname . " -CO " . $rand . " ";
$body = " <h2> SUSPENDED PROVIDER</H2> ";
$body .= "<table><tr><th> Organisation(S) </th><td>" . $providers . " </td></tr>";
$body .= "<tr><th>Admininstrator </th><td>" . $query1[0]['names'] . " </td></tr>";
$body .= "<tr><th> Date </th><td>" . Date('Y m-d') . " </td></tr>";
$body .= "</table>";
$permission = "view_disposal_plans";
push_permission($titles, $body, $level, $permission);
}
} else {
$data['area'] = 'procurement_record_details';
$this->load->view('includes/add_ons', $data);
}
}
