$table_HTML .= '<div class="control-group">' . '<label class="control-label">Quantity:</label>' . '<div class="controls">' . (!empty($total_ifb_q) ? $total_ifb_q : '<i>undefined</i>') . '<input type="hidden" id="procurement_details_quantity" name="procurement_details_quantity" value="' . $total_ifb_q . '"/>' . '</div>' . '</div>';
}
$table_HTML .= '<div class="control-group">' . '<label class="control-label">Method of procurement:</label>' . '<div class="controls">' . (!empty($procurement_details['procurement_method']) ? $procurement_details['procurement_method'] : '<i>undefined</i>') . '<input type="hidden" name="procurement_details[procurement_method]" value="' . $procurement_details['procurement_method'] . '" />' . '</div>' . '</div>';
if (!empty($procurement_details['providers'])) {
#$st = 'SELECT * FROM providers WHERE providerid in('.$procurement_details['providers'].')';
# print_r($st);
$procurementdetails = $this->db->query('SELECT * FROM providers WHERE providerid IN (' . $procurement_details['providers'] . ') ')->result_array();
#print_r($procurementdetails);
$providers = '<ul>';
$xc = '';
# $suspended = '';
$status = 0;
foreach ($procurementdetails as $key => $value) {
# code...
//check provider
$xc = searchprovidervalidity($value['providernames']);
if (!empty($xc)) {
$status = 1;
$providers .= "<li><div class='label label-warning' title='Suspended Provider' >" . $value['providernames'] . "</div>" . ' <div class="alert alert-important " style="width:150px; margin-left:5px;"> <button data-dismiss="alert" class="close">×</button> This is a suspended provider </div> </li>';
# $suspended .= $value['providernames'].',';
} else {
$providers .= "<li>" . $value['providernames'] . "</li>";
}
}
$providers .= '<ul>';
# print_r($procurement_details);
$str = '';
if ($procurement_details['bidvalidity'] == 'y') {
$enddatebidvalidity = strtotime($procurement_details['bidvalidityperiod']);
#echo "<BR/>:::::::<BR/>";
#print_r($enddatebidvalidity);
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);
}
}
