function getmarketAdminData($id) { $category = trim($this->session->userdata('vehicle')); $this->datatables->select('item_id,company_id,company_type,producer_name,type_of_poduct,brand_name,production,date_of_sample_collection,sample_collection_location,store_type,date_received_lab,expiry_date,labelled_as_fortified,sample_amount_taken,date_of_analysis,average_result'); $this->datatables->unset_column('item_id'); $this->datatables->unset_column('company_id'); $this->datatables->join('mkt_results', 'mkt_results.id = market_samples_table.item_id', 'left'); $this->datatables->unset_column('company_type'); $this->datatables->edit_column('sample_amount_taken', '$1', 'format_values(sample_amount_taken)'); $this->datatables->edit_column('date_received_lab', '$1', 'format_disp_date(date_received_lab)'); $this->datatables->edit_column('date_of_sample_collection', '$1', 'format_disp_date(date_of_sample_collection)'); $this->datatables->edit_column('expiry_date', '$1', 'format_disp_date(expiry_date)'); $this->datatables->edit_column('date_of_analysis', '$1', 'format_disp_date(date_of_analysis)'); // if ($id > 1) { $this->datatables->where('company_id', $id); $this->datatables->add_column('Actions', get_buttons_editWheat1('$1'), 'WheatProductionID'); } $this->datatables->from('market_samples_table'); echo $this->datatables->generate(); }
function getwheatData($id) { $category = trim($this->session->userdata('vehicle')); if ($category !== "MOPHS") { $this->datatables->select('WheatProductionID,year,prod_month,opening_balance,qty_delivered,supplier,qty_rejected,qty_issued,closing_balance,dosage_rate,theoretical_prod,actual_prod,production_unfort,exp_fort')->unset_column('WheatProductionID')->edit_column('opening_balance', '$1', 'format_values(opening_balance)')->edit_column('qty_delivered', '$1', 'format_values(qty_delivered)')->edit_column('qty_rejected', '$1', 'format_values(qty_rejected)')->edit_column('qty_issued', '$1', 'format_values(qty_issued)')->edit_column('closing_balance', '$1', 'format_values(closing_balance)')->edit_column('dosage_rate', '$1', 'format_values(dosage_rate)')->edit_column('theoretical_prod', '$1', 'format_values(theoretical_prod)')->edit_column('actual_prod', '$1', 'format_values(actual_prod)')->edit_column('production_unfort', '$1', 'format_values(production_unfort)')->edit_column('exp_fort', '$1', 'format_values(exp_fort)')->add_column('Actions', get_buttons_editWheat1('$1'), 'WheatProductionID')->where('company_id', $id)->from('wheat_productiontable'); } else { if ($id > 1 && $category === "MOPHS") { $this->datatables->select('WheatProductionID,year,prod_month,opening_balance,qty_delivered,supplier,qty_rejected,qty_issued,closing_balance,dosage_rate,theoretical_prod,actual_prod,production_unfort,exp_fort')->unset_column('WheatProductionID')->edit_column('opening_balance', '$1', 'format_values(opening_balance)')->edit_column('qty_delivered', '$1', 'format_values(qty_delivered)')->edit_column('qty_rejected', '$1', 'format_values(qty_rejected)')->edit_column('qty_issued', '$1', 'format_values(qty_issued)')->edit_column('closing_balance', '$1', 'format_values(closing_balance)')->edit_column('dosage_rate', '$1', 'format_values(dosage_rate)')->edit_column('theoretical_prod', '$1', 'format_values(theoretical_prod)')->edit_column('actual_prod', '$1', 'format_values(actual_prod)')->edit_column('production_unfort', '$1', 'format_values(production_unfort)')->edit_column('exp_fort', '$1', 'format_values(exp_fort)')->where('company_id', $id)->add_column('Actions', get_buttons_editWheat('$1'), 'WheatProductionID')->from('wheat_productiontable'); } else { if ($id === "" && $category === "MOPHS") { $this->datatables->select('WheatProductionID,year,prod_month,opening_balance,qty_delivered,supplier,qty_rejected,qty_issued,closing_balance,dosage_rate,theoretical_prod,actual_prod,production_unfort,exp_fort')->edit_column('opening_balance', '$1', 'format_values(opening_balance)')->edit_column('qty_delivered', '$1', 'format_values(qty_delivered)')->edit_column('qty_rejected', '$1', 'format_values(qty_rejected)')->edit_column('qty_issued', '$1', 'format_values(qty_issued)')->edit_column('closing_balance', '$1', 'format_values(closing_balance)')->edit_column('dosage_rate', '$1', 'format_values(dosage_rate)')->edit_column('theoretical_prod', '$1', 'format_values(theoretical_prod)')->edit_column('actual_prod', '$1', 'format_values(actual_prod)')->edit_column('production_unfort', '$1', 'format_values(production_unfort)')->edit_column('exp_fort', '$1', 'format_values(exp_fort)')->unset_column('WheatProductionID')->where('company_id', $id)->add_column('Actions', get_buttons_editWheat('$1'), 'WheatProductionID')->from('wheat_productiontable'); } else { $this->datatables->select('WheatProductionID,year,prod_month,opening_balance,qty_delivered,supplier,qty_rejected,qty_issued,closing_balance,dosage_rate,theoretical_prod,actual_prod,production_unfort,exp_fort')->edit_column('opening_balance', '$1', 'format_values(opening_balance)')->edit_column('qty_delivered', '$1', 'format_values(qty_delivered)')->edit_column('qty_rejected', '$1', 'format_values(qty_rejected)')->edit_column('qty_issued', '$1', 'format_values(qty_issued)')->edit_column('closing_balance', '$1', 'format_values(closing_balance)')->edit_column('dosage_rate', '$1', 'format_values(dosage_rate)')->edit_column('theoretical_prod', '$1', 'format_values(theoretical_prod)')->edit_column('actual_prod', '$1', 'format_values(actual_prod)')->edit_column('production_unfort', '$1', 'format_values(production_unfort)')->edit_column('exp_fort', '$1', 'format_values(exp_fort)')->unset_column('WheatProductionID')->add_column('Actions', get_buttons_editWheat('$1'), 'WheatProductionID')->from('wheat_productiontable'); } } } echo $this->datatables->generate(); }