<tr> <td>-</td> <td><?php echo $entry['subject_of_procurement']; ?> </td> <td><?php echo get_procurement_type_info_by_id($entry['procurement_type'], 'title'); ?> </td> <td><?php echo get_procurement_method_info_by_id($entry['procurement_type'], 'title'); ?> </td> <td><?php echo get_source_funding_info_by_id($entry['funding_source'], 'title'); ?> </td> <td style="text-align: right;"><?php echo number_format($entry['estimated_amount']); ?> <?php echo get_currency_info_by_id($entry['currency'], 'title'); ?> </td> </tr> <?php } ?> </tbody> </table>
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; } }