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