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