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