function procurement_plan_ref_number_hint($pde, $procurement_type, $financial_year, $procurement_plan)
{
$ci =& get_instance();
$ci->load->model('procurement_plan_entry_m');
//number sections
$pde_abbrv = get_pde_info_by_id($pde, 'abbrv');
$procurement_type = get_procurement_type_info_by_id($procurement_type, 'title');
switch ($procurement_type) {
case 'Works':
$procurement_type = 'WRKS';
break;
case 'Supplies':
$procurement_type = 'SUPPLS';
break;
case 'Services':
$procurement_type = 'SRVCS';
break;
case 'Non consultancy services':
$procurement_type = 'NCSRVCS';
break;
}
$where = array('procurement_plan_id' => $procurement_plan);
$last_instance = $ci->procurement_plan_entry_m->last_entered_procurement_ref_number($where);
//echo $last_instance;
$str = '';
//if there is an instance
if ($last_instance) {
$pieces = explode('/', $last_instance);
$str .= '000';
$str .= $pieces[3] + 1;
$instance = $str;
} else {
$instance = '0001';
}
return $pde_abbrv . '/' . $procurement_type . '/' . $financial_year . '/' . $instance;
}
if (!in_array($row['pdeid'], $pdes)) {
$pdes[] = $row['pdeid'];
}
//procurement types
if ($row['procurement_type']) {
$procurement_types[] = get_procurement_plan_entry_info($row['procurement_id'], 'procurement_type');
}
//expired bids
if (strtotime($row['bid_submission_deadline']) < now()) {
$expired_bids[] = $row['id'];
}
//less than threshhold
if (strtotime($row['bid_submission_deadline']) - strtotime($row['invitation_to_bid_date']) < $threshold) {
$less_than_thresh_hold[] = $row['id'];
}
if (date('d', strtotime($row['bid_submission_deadline']) - strtotime($row['invitation_to_bid_date'])) != get_procurement_type_info_by_id(get_procurement_plan_entry_info($row['procurement_id'], 'procurement_type'), 'evaluation_time')) {
$inconsitent_evalution[] = $row['id'];
}
//get suspended provoders
if (check_live_server()) {
foreach ($rop_suspended_providers as $provider) {
//if names match
if ($provider == get_provider_info_by_id($row['providerid'], 'title')) {
if (!in_array($row['providerid'], $suspended_providers)) {
$suspended_providers[] = $row['providerid'];
}
}
}
}
}
$occurence_procurement_types = array_count_values($procurement_types);
}
?>
<td><?php
echo $row['procurement_ref_no'];
?>
</td>
<td><?php
echo $row['subject_of_procurement'];
?>
</td>
<td><?php
echo get_procurement_method_info_by_id($row['procurement_method'], 'title');
?>
</td>
<td><?php
echo get_procurement_type_info_by_id($row['procurement_type'], 'title');
?>
</td>
<td><?php
echo get_beb_by_bid($row['bidinvitation_id'], 'title');
?>
</td>
<td><?php
echo custom_date_format('d.F.Y', $row['dateofconfirmationoffunds']);
?>
</td>
<td>
<?php
echo custom_date_format('d.F.Y', $row['date_signed']);
?>
</td>
function get_plan_entry_info_by_ref_num($id = '', $param = '')
{
if ($id == '') {
return NULL;
} else {
$this->db->cache_on();
$query = $this->db->select()->from($this->_tablename)->where('procurement_ref_no', $id)->get();
}
if ($query->result_array()) {
foreach ($query->result_array() as $row) {
switch ($param) {
case 'title':
$result = $row['subject_of_procurement'];
break;
case 'subject_of_procurement':
$result = $row['subject_of_procurement'];
break;
case 'procurement_type_id':
$result = $row['procurement_type'];
break;
case 'procurement_type':
$result = get_procurement_type_info_by_id($row['procurement_type'], 'title');
break;
case 'procurement_method_id':
$result = $row['procurement_method'];
break;
case 'procurement_method':
$result = get_procurement_method_info_by_id($row['procurement_method'], 'title');
break;
case 'department_id':
$result = $row['pde_department'];
break;
case 'department':
$result = get_pde_department_info_by_id($row['pde_department'], 'title');
break;
case 'funding_source_id':
$result = $row['funding_source'];
break;
case 'funding_source':
$result = get_source_funding_info_by_id($row['funding_source'], 'title');
break;
case 'source_funding_id':
$result = $row['funding_source'];
break;
case 'source_funding':
$result = get_source_funding_info_by_id($row['funding_source'], 'title');
break;
case 'id':
$result = $row['id'];
break;
case 'estimated_amount':
$result = $row['estimated_amount'];
break;
case 'currency':
$result = $result = get_currency_info_by_id($row['currency'], 'abbrv');
break;
case 'currency_id':
$result = $result = $row['currency'];
break;
case 'pre_bid_events_date':
$result = $row['pre_bid_events_date'];
break;
case 'pre_bid_events_duration':
$result = $row['pre_bid_events_duration'];
break;
case 'contracts_committee_approval_date':
$result = $row['contracts_committee_approval_date'];
break;
case 'contracts_committee_approval_date_duration':
$result = $row['contracts_committee_approval_date_duration'];
break;
case 'publication_of_pre_qualification_date':
$result = $row['publication_of_pre_qualification_date'];
break;
case 'publication_of_pre_qualification_date_duration':
$result = $row['publication_of_pre_qualification_date_duration'];
break;
case 'proposal_submission_date':
$result = $row['proposal_submission_date'];
break;
case 'proposal_submission_date_duration':
$result = $row['proposal_submission_date_duration'];
break;
case 'contracts_committee_approval_of_shortlist_date':
$result = $row['contracts_committee_approval_of_shortlist_date'];
break;
case 'contracts_committee_approval_of_shortlist_date_duration':
$result = $row['contracts_committee_approval_of_shortlist_date_duration'];
break;
case 'bid_issue_date_duration':
$result = $row['bid_issue_date_duration'];
break;
case 'bid_submission_opening_date':
$result = $row['bid_submission_opening_date'];
break;
case 'bid_submission_opening_date_duration':
$result = $row['bid_submission_opening_date_duration'];
break;
case 'bid_issue_date':
$result = $row['bid_issue_date'];
break;
case 'secure_necessary_approval_date':
$result = $row['secure_necessary_approval_date'];
break;
case 'secure_necessary_approval_date_duration':
$result = $row['secure_necessary_approval_date_duration'];
break;
case 'contract_award':
$result = $row['contract_award'];
break;
case 'contract_award_duration':
$result = $row['contract_award_duration'];
break;
case 'best_evaluated_bidder_date':
$result = $row['best_evaluated_bidder_date'];
break;
case 'best_evaluated_bidder_date_duration':
$result = $row['best_evaluated_bidder_date_duration'];
break;
case 'contract_sign_date':
$result = $row['bid_issue_date'];
break;
case 'contract_sign_date_duration':
$result = $row['contract_sign_duration'];
break;
case 'cc_approval_of_evaluation_report':
$result = $row['cc_approval_of_evaluation_report'];
break;
case 'cc_approval_of_evaluation_report_duration':
$result = $row['cc_approval_of_evaluation_report_duration'];
break;
case 'negotiation_date':
$result = $row['negotiation_date'];
break;
case 'negotiation_date_duration':
$result = $row['negotiation_date_duration'];
break;
case 'negotiation_approval_date':
$result = $row['negotiation_approval_date'];
break;
case 'negotiation_approval_date_duration':
$result = $row['negotiation_approval_date_duration'];
break;
case 'advanced_payment_date':
$result = $row['advanced_payment_date'];
break;
case 'advanced_payment_date_duration':
$result = $row['advanced_payment_date_duration'];
break;
case 'mobilise_advance_payment':
$result = $row['mobilise_advance_payment'];
break;
case 'mobilise_advance_payment_duration':
$result = $row['mobilise_advance_payment_duration'];
break;
case 'substantial_completion':
$result = $row['substantial_completion'];
break;
case 'substantial_completion_duration':
$result = $row['substantial_completion_duration'];
break;
case 'final_acceptance':
$result = $row['final_acceptance'];
break;
case 'final_acceptance_duration':
$result = $row['final_acceptance_duration'];
break;
case 'procurement_plan_id':
$result = $row['procurement_plan_id'];
break;
case 'procurement_plan':
$result = get_procurement_plan_info($row['procurement_plan_id'], 'title');
break;
case 'pde_id':
$result = get_procurement_plan_info($row['procurement_plan_id'], 'pde_id');
break;
case 'pde':
$result = get_procurement_plan_info($row['procurement_plan_id'], 'pde');
break;
case 'author_id':
$result = $row['author'];
break;
case 'updated_by':
$result = $row['updated_by'];
break;
case 'author':
$result = get_user_info($row['author'], 'fullname');
break;
case 'isactive':
$result = $row['active'];
break;
case 'dateadded':
$result = $row['dateadded'];
break;
default:
$result = $query->result_array();
}
}
return $result;
} else {
return NULL;
}
}
