function get_contract_price_info_by_contract($passed_id, $param) { //if NO ID if ($passed_id == '') { return NULL; } else { //get user info $query = $this->db->select()->from($this->_tablename)->where('contract_id', $passed_id)->get(); //echo $this->db->last_query(); if ($query->result_array()) { foreach ($query->result_array() as $row) { //filter results switch ($param) { case 'id': $result = $row['id']; break; case 'amount': $result = $row['amount']; break; case 'xrate': $result = $row['xrate']; break; case 'rate': $result = $row['xrate']; break; case 'currency_id': $result = $row['currency_id']; break; case 'currency': $result = get_currency_info_by_id($row['currency_id'], 'abbrv'); break; case 'dateadded': $result = $row['dateadded']; break; default: $result = $query->result_array(); } } return $result; } } }
<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> </div> </div>
<td><?php echo $entry['subject_of_procurement']; ?> </td> <td class="hidden-480"><?php echo get_procurement_type_info_by_id($entry['procurement_type'], 'title'); ?> </td> <td class="hidden-480"><?php echo get_source_funding_info_by_id($entry['funding_source'], 'title'); ?> </td> <td><?php echo $entry['estimated_amount'] . ' ' . get_currency_info_by_id($entry['currency'], 'abbrv'); ?> </td> </tr> <?php } ?> </tbody> </table> <?php } else { echo info_template('Plan has no entries yet'); echo check_my_access('add_procurement_entry') == TRUE ? '<a class="btn btn-xs btn-primary" href="' . base_url() . $this->uri->segment(1) . '/new_entry/m/' . $this->uri->segment(3) . '">Add entry</a>' : '';
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; } }