EVOLUTION-NINJA
Edit File: Yarn_model.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Yarn_model extends CI_Model { public function __construct() { parent::__construct(); } //insert yarn quality here public function yarn_qty_insert($quality_data) { $qualityinsert=$this->db->insert('import_yarn',$quality_data); $lastinsertid=$this->db->insert_id(); //insert warp data start for ($i = 0; $i < count($this->input->post('stage')); $i++) { $yarn_data = array( 'yarnID' => $lastinsertid, 'stage' => $this->input->post('stage')[$i], 'direction' => $this->input->post('direction')[$i], 'count' => $this->input->post('count')[$i], ); $this->db->insert('yarn_stage',$yarn_data); } if($qualityinsert) { return true; } else { return false; } } //display yarn data here public function display_yarnqty_data() { $query=$this->db->get('import_yarn'); return $query->result(); } //display yarn quality here public function display_yarnQuality() { $query=$this->db->query('SELECT DISTINCT(yarnName) FROM import_yarn'); return $query->result(); } //display yarn quality here public function display_articleNumber() { $this->db->order_by("articleNo", "asc"); $query=$this->db->get('article_master'); return $query->result(); } public function update_yarns($table,$data,$where) { $this->db->where($where); $this->db->update($table,$data); } public function display_shadeName() { $query=$this->db->get('shade_master'); return $query->result(); } //display yarn denier here public function display_yarndenier() { $query=$this->db->query('SELECT DISTINCT(yarnDenier) FROM import_yarn'); return $query->result(); } //display warp yarn denier here public function display_yarndenier_warp() { $query=$this->db->query('SELECT DISTINCT(yarnName) FROM import_yarn where yarnType="Warp"'); return $query->result(); } //display weft yarn denier here public function display_yarndenier_weft() { $query=$this->db->query('SELECT DISTINCT(yarnName) FROM import_yarn where yarnType="Weft"'); return $query->result(); } //checking where specification is exists or not public function check_spec_exists() { //$query=$this->db->query('SELECT DISTINCT yarnQuality FROM '); $query = $this->db->get('import_yarn'); if ($query->num_rows() > 0) { return $query->result(); } else { return false; } } //insert supplier master here public function supplier_insert($supplier_data) { $suppinsert=$this->db->insert('supplier_details',$supplier_data); if($suppinsert) { return true; } else { return false; } } //update public function update_quantity($qty_data,$licencse) { //$query=$this->db->query('SELECT recieved_quantity FROM masters_import where license_no="123"'); //echo $qty=$query->result();exit; $qtyupdate=$this->db->where('license_no', $licencse); $qtyupdate=$this->db->update('masters_import', $qty_data); //$suppupdate=$this->db->update('supplier_details', $supplier_data, array('id' => $id)); if($qtyupdate) { return true; } else { return false; } } //update supplier master here public function supplier_update($supplier_data,$id) { $suppupdate=$this->db->where('id', $id); $suppupdate=$this->db->update('supplier_details', $supplier_data); //$suppupdate=$this->db->update('supplier_details', $supplier_data, array('id' => $id)); if($suppupdate) { return true; } else { return false; } } public function get_userdata() { $query = $this->db->get_where('employee_details', array('id' => $this->session->userdata['logged_in']['userid'])); return $query->row(); } //update advanced auth public function advanced_auth_update($auth_data,$id) { $authupdate=$this->db->where('id', $id); $authupdate=$this->db->update('advance_auth', $auth_data); //$suppupdate=$this->db->update('supplier_details', $supplier_data, array('id' => $id)); if($authupdate) { return true; } else { return false; } } //update incentive scheem public function incentive_update($incentive_data,$id) { $incupdate=$this->db->where('id', $id); $incupdate=$this->db->update('incentive_schemes', $incentive_data); //$suppupdate=$this->db->update('supplier_details', $supplier_data, array('id' => $id)); if($incupdate) { return true; } else { return false; } } //display supplier quality data here public function display_supplier_data() { $query=$this->db->get('supplier_details'); return $query->result(); } //display supplier name and address based on filenor public function get_name_address($fileno) { $query = $this->db->get_where('supplier_details', array('import_fileno' => $fileno)); return $query->result(); } //insert advaced authorization here public function advance_auth_insert($auth_data) { $aainsert=$this->db->insert('advance_auth',$auth_data); if($aainsert) { return true; } else { return false; } } //display advanced authorisation data here public function display_aa_data() { $query=$this->db->get('advance_auth'); return $query->result(); } //display incentive schema data here public function display_incntiveschema_data() { $query=$this->db->get('incentive_schemes'); return $query->result(); } //insert incentive schema here public function incentive_insert($incentive_data) { $qualityinsert=$this->db->insert('incentive_schemes',$incentive_data); if($qualityinsert) { return true; } else { return false; } } //insert masters import here public function masterimort_insert($masters_data) { $miinsert=$this->db->insert('masters_import',$masters_data); if($miinsert) { return true; } else { return false; } } //insert masters import here duplicate public function masterimort_insert1($masters_data,$booking_data,$final_lc,$shipping_data,$goodsdetails_data,$invoice_data) { $miinsert=$this->db->insert('masters_import',$masters_data); $miinsert1=$this->db->insert('mi_bookingDetails',$booking_data); if($final_lc!="") { $miinsert2=$this->db->insert('mi_lcDetails',$final_lc); } if($shipping_data!="")//insert shipping details if everything is filled { $miinsert3=$this->db->insert('mi_shippingDetails',$shipping_data); } if($goodsdetails_data!="")//insert goods details if everything is filled { $miinsert4=$this->db->insert('mi_goodsDetails',$goodsdetails_data); if($miinsert4) { $goodsid=$this->db->insert_id(); $licensenor = $this->input->post('licensenor'); for($i = 0; $i<count($licensenor);$i++){ //update quality and quantity start /*if($this->input->post('exrate')!="") {*/ $tablename=$this->input->post('selectcategory')[$i]; if($tablename=="advance_auth") { $datatogetexisting_quality = array('license_no' => $this->input->post('licensenor')[$i],'quality' => $this->input->post('quality') ); } else { $datatogetexisting_quality = array('scheme_no' => $this->input->post('licensenor')[$i]); } $query=$this->db->get_where($tablename, $datatogetexisting_quality); $results=$query->row(); //get selected license number quality and quantity here. based on selecting fields of licenseno,quality in import module. if($tablename=="advance_auth") { $final_quantity=$results->balanceQuantity-$this->input->post('recievedquantity')[$i]; //existing quantity 'minus' recived quantity entered in import module //$final_balance_indollar=$results->balance_cif_dollar-$this->input->post('fcvalue');//balanceInDollar After deduction:existing b.c.d-fcvalue entered in import module $final_balance_indollar=$results->balance_cif_dollar-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')); //$final_balance_inCNR=$results->balance_cif_inr-$this->input->post('inrvalue');//balanceInDollar After deduction:existing b.c.INR-fcvalue entered in import module $final_balance_inCNR=$results->balance_cif_inr-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')*$this->input->post('exrate')); $updatevals = array( 'balanceQuantity' => $final_quantity, 'balance_cif_dollar' => $final_balance_indollar, 'balance_cif_inr' => $final_balance_inCNR ); } else { //$final_balance=$results->balance_availaible-$this->input->post('inrvalue'); //$final_balance=$results->balance_availaible-($this->input->post('exrate')*$this->input->post('unitprice')*$this->input->post('recievedquantity')[$i]); //exRate*unitprice*Recievedquantity $final_balance=$results->balance_availaible-($this->input->post('incentcustduty')[$i]); $updatevals = array('balance_availaible' => $final_balance); } $this->db->update($tablename, $updatevals, array('id' => $results->id)); //} //update quality and quantity end $license_reciveddata = array('category' => $this->input->post('selectcategory')[$i],'goods_details_id' => $goodsid,'license_no' => $this->input->post('licensenor')[$i],'recieved_quantity' => $this->input->post('recievedquantity')[$i],'customduty' => $this->input->post('incentcustduty')[$i]); //insert license number and recieved quantity start $this->db->insert('mi_goods_license_recieved',$license_reciveddata); //insert license number and recieved quantity end } } } if($invoice_data!="")//insert invoice details if everything is filled { $miinsert5=$this->db->insert('mi_invoice',$invoice_data); } if($miinsert) { return true; } else { return false; } } //check consignment public function check_lc_existed($finalimport_no) { $query = $this->db->get_where('mi_lcdetails', array('mi_id' => $finalimport_no)); return $query->row(); } //check goods details public function check_goods_existed($finalimport_no) { $query = $this->db->get_where('mi_goodsdetails', array('mi_id' => $finalimport_no)); return $query->row(); } //check booking public function check_booking_existed($finalimport_no) { $query = $this->db->get_where('mi_bookingdetails', array('mi_id' => $finalimport_no)); return $query->row(); } //get booking data public function getbookingdata($finalimport_no) { $query = $this->db->get_where('mi_bookingdetails', array('mi_id' => $finalimport_no)); return $query->result(); } //check lc data is existed when click on next button in import module public function check_masterdata_exist($importfilenor) { $query = $this->db->get_where('masters_import', array('import_file_no' => $importfilenor)); return $query->result(); } //get editable data in import module public function getMiEditData($id) { $query = $this->db->get_where('masters_import', array('id' => $id)); return $query->row(); } //get editable data from booking details in import module public function getBDNewEditData($id) { $query = $this->db->get_where('mi_bookingdetails', array('master_id' => $id)); return $query->row(); } //get editable data from shipping details in import module public function getSDNewEditData($id) { $query = $this->db->get_where('mi_shippingDetails', array('master_id' => $id)); return $query->row(); } //get editable data from Goods details in import module public function getGDNewEditData($id) { $query = $this->db->get_where('mi_goodsdetails', array('master_id' => $id)); return $query->row(); } //get editable data from invoice details in import module public function getinvoicedata($id) { $query = $this->db->get_where('mi_invoice', array('master_id' => $id)); return $query->row(); } //get editable data from Goods licence recieved details in import module public function getGdRNewEditData($id) { $query = $this->db->get_where('mi_goods_license_recieved', array('goods_details_id' => $id)); return $query->result(); } //get last id from master import public function masterimportLastID() { $query=$this->db->query("SELECT * FROM masters_import order BY id desc"); return $query->row(); } //display master module data here public function display_mastermodule_data() { $query=$this->db->query("SELECT DISTINCT(import_file_no),consignment_no,file_no,name,address,import_type FROM masters_import GROUP BY import_file_no"); //$query=$this->db->get('masters_import'); return $query->result(); } //display master module data based on import file nor public function display_mm_importfilenor($ifilenor) { $query = $this->db->get_where('masters_import', array('id' => $ifilenor)); return $query->result(); } //display_advanced_auth data based on id public function display_advanced_auth($id) { $query = $this->db->get_where('advance_auth', array('id' => $id)); return $query->result(); } //display_advanced_auth data based on license_no public function getadvaceAuthdata($id) { $query = $this->db->get_where('advance_auth', array('license_no' => $id)); return $query->row(); } //display_incentive data based on license_no public function getincentiveschemedata($id) { $query = $this->db->get_where('incentive_schemes', array('scheme_no' => $id)); return $query->row(); } //display incentive schema based on id public function display_incentive_schema($id) { $query = $this->db->get_where('incentive_schemes', array('id' => $id)); return $query->result(); } //display supplier_data schema based on id public function display_supply_data($id) { $query = $this->db->get_where('supplier_details', array('id' => $id)); return $query->result(); } //display pdf data here public function getpdfdata($tablename) { $query=$this->db->get($tablename); return $query->result(); } //get countries from country tablename public function getcountries() { $this->db->order_by("country", "ASC"); $query=$this->db->get("country"); return $query->result(); } //check login here // public function login($username,$password) // { // $this -> db -> select('id,username'); // $this -> db -> from("user_management"); // $this -> db -> where('username', $username); // $this -> db -> where('password', $password); // $this -> db -> limit(1); // $query = $this -> db -> get(); // if($query->num_rows()== 1) // { // return $query->result(); // } // else // { // return false; // } // } public function login($username,$password) { $this -> db -> select('id,username,access_role,user_type_id'); $this -> db -> from("employee_details"); $this -> db -> where('username', $username); $this -> db -> where('password', $password); $this -> db -> limit(1); $query = $this -> db -> get(); if($query->num_rows()== 1) { return $query->result(); } else { return false; } } //get supplier master edit data public function get_supplier_editdata($id) { $query = $this->db->get_where('supplier_details', array('id' => $id)); return $query->row(); } //get advanced auth edit data public function get_advanedauth_editdata($id) { $query = $this->db->get_where('advance_auth', array('id' => $id)); return $query->row(); } //get advanced auth edit data public function get_incentive_editdata($id) { $query = $this->db->get_where('incentive_schemes', array('id' => $id)); return $query->row(); } //display denier data based on quality from yarn public function getdenier_quality($req_qty) { $query=$this->db->query("SELECT DISTINCT(yarnDenier) FROM import_yarn where yarnQuality='$req_qty'"); return $query->result(); } //display specification data based on denier from yarn public function getspecf_denier($req_denier) { $query=$this->db->query("SELECT DISTINCT(yarnSpecification) FROM import_yarn where yarnDenier='$req_denier'"); return $query->result(); } public function get_import_transactions($id) { if($id == "") { return false; } else { $this -> db -> select('*'); $this -> db -> from("masters_import"); $this -> db -> where('id', $id); $this -> db -> limit(1); $query = $this -> db -> get(); if($query->num_rows()== 1) { return $query->row(); } else { return false; } } } public function masterimort_update($masters_data,$booking_data,$shipping_data,$cherw_shping,$invoice_data,$id) { //start test $checkexist=mysql_query("SELECT * FROM mi_goodsDetails WHERE master_id='$id'"); $cherw=mysql_num_rows($checkexist); if($cherw!=1 && $this->input->post('goodsrecieveddate') && $this->input->post('noofbalebox')) { $goodsdetails_data=array( 'master_id' => $id, 'mi_id' => $this->input->post('importfileno'), 'RecievedDate' => explode("/",$this->input->post('goodsrecieveddate'))[2].'-'.explode("/",$this->input->post('goodsrecieveddate'))[1].'-'.explode("/",$this->input->post('goodsrecieveddate'))[0], 'NoofBaleBox' => $this->input->post('noofbalebox'), ); $insertthis=$this->db->insert('mi_goodsDetails',$goodsdetails_data); if($insertthis) { $goodsid=$this->db->insert_id(); $licensenor = $this->input->post('licensenor'); for($i = 0; $i<count($licensenor);$i++) { //update quality and quantity start $tablename=$this->input->post('selectcategory')[$i]; if($tablename=="advance_auth") { $datatogetexisting_quality = array('license_no' => $this->input->post('licensenor')[$i],'quality' => $this->input->post('quality') ); } else { $datatogetexisting_quality = array('scheme_no' => $this->input->post('licensenor')[$i]); } $query=$this->db->get_where($tablename, $datatogetexisting_quality); $results=$query->row(); //get selected license number quality and quantity here. based on selecting fields of licenseno,quality in import module. if($tablename=="advance_auth") { $final_quantity=$results->balanceQuantity-$this->input->post('recievedquantity')[$i]; //existing quantity 'minus' recived quantity entered in import module //$final_balance_indollar=$results->balance_cif_dollar-$this->input->post('fcvalue');//balanceInDollar After deduction:existing b.c.d-fcvalue entered in import module $final_balance_indollar=$results->balance_cif_dollar-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')); //$final_balance_inCNR=$results->balance_cif_inr-$this->input->post('inrvalue');//balanceInDollar After deduction:existing b.c.INR-fcvalue entered in import module $final_balance_inCNR=$results->balance_cif_inr-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')*$this->input->post('exrate')); $updatevals = array( 'balanceQuantity' => $final_quantity, 'balance_cif_dollar' => $final_balance_indollar, 'balance_cif_inr' => $final_balance_inCNR ); } else { //$final_balance=$results->balance_availaible-$this->input->post('inrvalue'); //$final_balance=$results->balance_availaible-($this->input->post('exrate')*$this->input->post('unitprice')*$this->input->post('recievedquantity')[$i]); //exRate*unitprice*Recievedquantity $final_balance=$results->balance_availaible-($this->input->post('incentcustduty')[$i]); $updatevals = array('balance_availaible' => $final_balance); } $this->db->update($tablename, $updatevals, array('id' => $results->id)); /*if($tablename=="advance_auth" && $this->input->post('exrate')!="") { $final_quantity=$results->balanceQuantity-$this->input->post('recievedquantity')[$i]; //existing quantity 'minus' recived quantity entered in import module $final_balance_indollar=$results->balance_cif_dollar-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')); //$final_balance_inCNR=$results->balance_cif_inr-$this->input->post('inrvalue');//balanceInDollar After deduction:existing b.c.INR-fcvalue entered in import module $final_balance_inCNR=$results->balance_cif_inr-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')*$this->input->post('exrate')); $updatevals = array( 'balanceQuantity' => $final_quantity, 'balance_cif_dollar' => $final_balance_indollar, 'balance_cif_inr' => $final_balance_inCNR ); $this->db->update($tablename, $updatevals, array('id' => $results->id)); } else if($tablename=="incentive_schemes" && $this->input->post('exrate')!="") { //$final_balance=$results->balance_availaible-$this->input->post('inrvalue'); $final_balance=$results->balance_availaible-($this->input->post('exrate')*$this->input->post('unitprice')*$this->input->post('recievedquantity')[$i]); $updatevals = array('balance_availaible' => $final_balance); $this->db->update($tablename, $updatevals, array('id' => $results->id)); }*/ //update quality and quantity end $license_reciveddata = array('category' => $this->input->post('selectcategory')[$i],'goods_details_id' => $goodsid,'license_no' => $this->input->post('licensenor')[$i],'recieved_quantity' => $this->input->post('recievedquantity')[$i],'customduty' => $this->input->post('incentcustduty')[$i]); //insert license number and recieved quantity start $this->db->insert('mi_goods_license_recieved',$license_reciveddata); //insert license number and recieved quantity end } } } else if($cherw==1 && $this->input->post('goodsrecieveddate') && $this->input->post('noofbalebox')) { //if already goods details there but now exrate entered start $licensenor = $this->input->post('licensenor'); for($i = 0; $i<count($licensenor);$i++) { //update quality and quantity start //$tablename=$this->input->post('selectcategory')[$i]; /*if($tablename=="advance_auth" && $this->input->post('exrate')!="") { $datatogetexisting_quality = array('license_no' => $this->input->post('licensenor')[$i],'quality' => $this->input->post('quality') ); } else if($tablename=="incentive_schemes" && $this->input->post('exrate')!="") { $datatogetexisting_quality = array('scheme_no' => $this->input->post('licensenor')[$i]); } $query=$this->db->get_where($tablename, $datatogetexisting_quality); $results=$query->row(); //get selected license number quality and quantity here. based on selecting fields of licenseno,quality in import module. */ /*if($tablename=="advance_auth" && $this->input->post('exrate')!="") { $final_quantity=$results->balanceQuantity-$this->input->post('recievedquantity')[$i]; //existing quantity 'minus' recived quantity entered in import module $final_balance_indollar=$results->balance_cif_dollar-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')); //$final_balance_inCNR=$results->balance_cif_inr-$this->input->post('inrvalue');//balanceInDollar After deduction:existing b.c.INR-fcvalue entered in import module $final_balance_inCNR=$results->balance_cif_inr-($this->input->post('recievedquantity')[$i]*$this->input->post('unitprice')*$this->input->post('exrate')); $updatevals = array( 'balanceQuantity' => $final_quantity, 'balance_cif_dollar' => $final_balance_indollar, 'balance_cif_inr' => $final_balance_inCNR ); $this->db->update($tablename, $updatevals, array('id' => $results->id)); } else if($tablename=="incentive_schemes" && $this->input->post('exrate')!="") { //$final_balance=$results->balance_availaible-$this->input->post('inrvalue'); $final_balance=$results->balance_availaible-($this->input->post('exrate')*$this->input->post('unitprice')*$this->input->post('recievedquantity')[$i]); $updatevals = array('balance_availaible' => $final_balance); $this->db->update($tablename, $updatevals, array('id' => $results->id)); }*/ //insert license number and recieved quantity end } //if already goods details there but now exrate entered end } //end test $qtyupdate=$this->db->update('masters_import', $masters_data, array('id' => $id)); $qtyupdate1=$this->db->update('mi_bookingDetails', $booking_data, array('master_id' => $id)); $qtyupdate2=$this->db->update('mi_invoice', $invoice_data, array('master_id' => $id)); if($cherw_shping==1) { //update $this->db->update('mi_shippingDetails', $shipping_data, array('master_id' => $id)); } else { if($this->input->post('billentryno') && $this->input->post('billentrydate') && $this->input->post('billloadingno') && $this->input->post('billloadingdate') && $this->input->post('port') && $this->input->post('eta')) { //insert $this->db->insert('mi_shippingDetails',$shipping_data); } } //$qtyupdate=$this->db->where('id', $id); //$qtyupdate=$this->db->update('masters_import', $masters_data); //$qtyupdate1=$this->db->where('master_id', $id); //$qtyupdate1=$this->db->update('mi_bookingDetails', $booking_data); if($qtyupdate) { return true; } else { return false; } } //check license and quality unique in database here public function uniquelicensequality($licenceno, $quality) { $this -> db -> select('id,license_no'); $this -> db -> from("advance_auth"); $this -> db -> where('license_no', $licenceno); //$this -> db -> where('quality', $quality); $this -> db -> limit(1); $query = $this -> db -> get(); if($query->num_rows()== 1) { return $query->result(); } else { return false; } } //check license and quality unique in database here public function uniquescheemano($scheemeno) { $this -> db -> select('id,scheme_no'); $this -> db -> from("incentive_schemes"); $this -> db -> where('scheme_no', $scheemeno); $this -> db -> limit(1); $query = $this -> db -> get(); if($query->num_rows()== 1) { return $query->result(); } else { return false; } } //display multiple consigments based on import file number_format public function getmulti_consignments($filenor) { //$query=$this->db->query('SELECT masters_import.import_file_no,masters_import.consignment_no,masters_import.file_no,masters_import.name,masters_import.address,masters_import.import_type,mi_bookingDetails.quality FROM masters_import inner join mi_bookingDetails ON masters_import.import_file_no=mi_bookingDetails.mi_id where masters_import.import_file_no="IMP00001"'); $query = $this->db->get_where('masters_import', array('import_file_no' => $filenor)); return $query->result(); } public function getdenierdata($yarnname) { $query=$this->db->query("SELECT DISTINCT(yarnDenier) FROM import_yarn WHERE yarnName='$yarnname'"); //$query = $this->db->get_where('import_yarn', array('yarnName' => $yarnname)); return $query->result(); } public function getIMPfileDATA($impfileno) { $query=$this->db->query("SELECT mi.name,mi.consignment_no, mi.id, mi.import_type, mb.quality, mb.dinear, mb.grade, mb.mill_no, mb.booking_date, mb.sales_contract_no, mb.quantity_booked, mb.box_no_of_bale, mb.unit_price, ms.billLoadingNo, ms.billLoadingDate, ms.port, ml.lc_no, mg.RecievedDate,mg.id as goodsdetid, minv.PaymentDate, minv.TotalValue,minv.AverageRate, SUM( mgl.recieved_quantity ) AS goodsrcvdcount FROM masters_import AS mi LEFT JOIN mi_bookingDetails AS mb ON mb.master_id = mi.id LEFT JOIN mi_shippingDetails AS ms ON ms.master_id = mi.id LEFT JOIN mi_lcDetails AS ml ON ml.master_id = mi.id LEFT JOIN mi_goodsDetails AS mg ON mg.master_id = mi.id LEFT JOIN mi_goods_license_recieved AS mgl ON mgl.goods_details_id = mg.id LEFT JOIN mi_invoice AS minv ON minv.master_id = mi.id WHERE mi.import_file_no = '$impfileno' GROUP BY mi.id"); //$query=$this->db->query("SELECT masters_import.name,masters_import.consignment_no,mi_bookingDetails.sales_contract_no,mi_bookingDetails.booking_date,mi_bookingDetails.quantity_booked,mi_bookingDetails.box_no_of_bale,mi_bookingDetails.unit_price,mi_shippingDetails.billLoadingNo,mi_shippingDetails.billLoadingDate,mi_shippingDetails.port,mi_invoice.PaymentDate FROM masters_import //INNER JOIN mi_bookingDetails ON masters_import.id=mi_bookingDetails.master_id //INNER JOIN mi_shippingDetails ON masters_import.id=mi_shippingDetails.master_id //INNER JOIN mi_invoice ON masters_import.id=mi_invoice.master_id WHERE masters_import.import_file_no='$impfileno'"); //$query=$this->db->query("SELECT "); return $query->result(); } public function fetch_main_data($table,$where) { $this->db->select("*"); $this->db->from($table); $this->db->where($where); $query = $this->db->get(); return $query->row(); } public function fetch_where_data($table,$where) { $this->db->select("*"); $this->db->from($table); $this->db->where($where); $query = $this->db->get(); return $query->result(); } public function insert($table,$data) { $this->db->insert($table,$data); } public function update($table,$data,$where) { $this->db->where($where); $this->db->update($table,$data); } public function delete($table,$where) { $this->db->where($where); $this->db->delete($table); } public function planning_preview($id,$where1) { $this->db->select('orders.oslNo,sub_orders.id, sub_orders.quality,sub_orders.articleNo,sub_orders.width,planned_order.selWidth, planned_order.warpPlandMtr,planned_order.weftPlandMtr,planned_order.pieceLength, article_master.reed,article_master.finishedWeight, weft_data.Weft_Quality,weft_data.PPC,weft_data.Weft_Specification, sub_order_shades.ourShade,sub_order_shades.deliveryDate,sub_order_shades.shadeID,shade_master.shadeName '); $this->db->from('sub_orders '); $this->db->where('orderID', $id); $this->db->where('sub_order_shades.planningStatus','planned'); $this->db->join('sub_order_shades', 'sub_order_shades.subOrderID = sub_orders.id'); $this->db->join('orders', 'orders.id = sub_orders.orderID'); $this->db->join('planned_order', 'planned_order.oslNo = orders.oslNo'); $this->db->join('shade_master', 'shade_master.shadeID = planned_order.sslShade'); //$this->db->join('sm_weft', 'sm_weft.shadeID = sub_order_shades.shadeID'); $this->db->join('article_master', 'article_master.articleNo = sub_orders.articleNo'); $this->db->join('weft_data', 'weft_data.article_id = article_master.articleID'); //$this->db->join('warp_data', 'warp_data.article_id = article_master.articleID', 'INNER'); $query = $this->db->get(); return $query->result(); } public function display_weft_yarnqty_data() { $this->db->where('yarnType', 'Weft'); $query=$this->db->get('import_yarn'); return $query->result(); } public function display_warp_yarnqty_data() { $this->db->where('yarnType', 'Warp'); $query=$this->db->get('import_yarn'); return $query->result(); } } ?>