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