EVOLUTION-NINJA

Edit File: Store_model.php

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class store_model extends CI_Model {

public function __construct() {
        parent::__construct();
    }

public function location_insert($location_data) {
        $locationinsert = $this->db->insert('location_master', $location_data);
        if ($locationinsert) {
            return true;
        } else {
            return false;
        }
    }
	
	  public function display_location_data() {
        $query = $this->db->get('location_master');
        return $query->result();
    }
	public function display_location($id) {
		
        $query = $this->db->get_where('location_master', array('id' => $id));
		
		//print_r($query->result());exit;
        return $query->result();
    }
	public function get_details($table){
    	
    	$this->db->select('*');
    	$this->db->from($table);
    	$query= $this->db->get();
		return $query->result();
    
    }
    	public function get_fabric_details($table){
    	
    	$this->db->select('*');
    	$this->db->from($table);
    	$this->db->order_by('id','desc');
    	$query= $this->db->get();
		return $query->result();
    
    }
public function display_fabric_inspection_order_embroidryinspection_date()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection_details.consumed_at,fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date,fabric_inspection_details.customer_id,fabric_inspection.created_by,indent_goods_details.no_type_val');
		$this->db->order_by('fabric_inspection.id','desc');
$this->db->group_by('fabric_inspection.ssl_pc_no');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_goods_details', 'fabric_inspection_details.po_list_id = indent_goods_details.po_list_id','');
		$this->db->where('fabric_inspection_details.status','0');
		// $this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
        // $this->db->where('fabric_inspection.balanced_mtrs !=','');
		// $this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	}  	
	
	public function display_fabric_inspection_order_embroidryinspection_date_row($val)
	{
		//$this->db->distinct();
		$this->db->select('madeups_work_order.wo_number,fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection_details.consumed_at,fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date,fabric_inspection_details.customer_id,fabric_inspection.created_by,indent_goods_details.no_type_val');
	    //$this->db->select('fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection_details.consumed_at,fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date,fabric_inspection_details.customer_id,fabric_inspection.created_by');
	
		$this->db->order_by('fabric_inspection.id','desc');
$this->db->group_by('fabric_inspection.ssl_pc_no');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_goods_details', 'fabric_inspection_details.po_list_id = indent_goods_details.po_list_id','left');
		$this->db->join('madeups_work_order', 'fabric_inspection_details.work_order_id = madeups_work_order.id','left');
		$this->db->where('fabric_inspection_details.status','0');
		 $this->db->where('fabric_inspection_details.id',$val);
        // $this->db->where('fabric_inspection.balanced_mtrs !=','');
		// $this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	} 
	
	
public function display_split_fabric_inspe_data_embroidryinspection($where)
	{
		$this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date,fabric_inspection.created_by');
		//$this->db->select('*');
		$this->db->from('fabric_inspection_details');
$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.id ',$where);
		$query=$this->db->get();
		return $query->row();
	} 
public function count_get_data_gross_fetch($where)
    {
		$this->db->select('sum(indent_yarn_goods_details.gross_weight)as gross_weight');
    	$this->db->distinct();
		
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
		$this->db->where($where);
		$query=$this->db->get();
		return $query->row();
    }
	
	  public function count_get_data_net_fetch($where)
    {
		$this->db->select('sum(indent_yarn_goods_details.net_weight)as net_weight');
    	$this->db->distinct();
		
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
		$this->db->where($where);
		$query=$this->db->get();
		return $query->row();
    }
	public function max_select_sl_pc_no($table)
    {
    	$this->db->select_max('sl_ssl_pc_no');
    	$this->db->from($table);
    	$query = $this->db->get();
    	return $query->row();
    }

public function get_data_fetch($table,$where)
    {
    	$this->db->select('*');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query=$this->db->get();
    	return $query->result();
    }
    
    public function get_data_fetch_new($table,$where)
    {
    	$this->db->select('*');
    	$this->db->from($table);
    	$this->db->where($where);
    	$this->db->order_by('id','DESC');
    	$query=$this->db->get();
    	return $query->result();
    }
    
    public function getproduct_data_fetch($table,$where)
    {
    	$this->db->select('product_name,quantity,width,shades');
    	$this->db->distinct();
    	$this->db->from($table);
    	$this->db->where($where);
    	$query=$this->db->get();
    	return $query->result();
    }
    public function fetch_where_subgrid_data($table,$where)
    {
    	$this->db->select("*");
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
    
public function count_get_rec_data_fetch($table,$where)
    {
    	
$this->db->select_sum('rec_weight');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query=$this->db->get();
    	return $query->row();
    }
     public function count_get_data_fetch($table,$where)
    {
    	
$this->db->select_sum('rec_goods');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query=$this->db->get();
    	return $query->row();
    }
     public function count_get_data_fetch_new($table,$where)
    {
    	
        $this->db->select('rec_goods,product_name');
       
    	$this->db->from($table);
    	 $this->db->distinct();
    	$this->db->where($where);
    	$query=$this->db->get();
    	return $query->result();
    }
	public function fetch_where_subgrid_dataa($table,$where)
    {
    	$this->db->select_max('id');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
	
  // public function display_fabricinspection()
	// {
		// $this->db->distinct();
		// $this->db->select('indent_po.purpose,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight');
		// $this->db->from('fabric_inspection_details');
		// $this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id');
		// //$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		// $this->db->where('fabric_inspection_details.status','1');
		// $query=$this->db->get();
		// return $query->result();
	// }  
	
	
	public function display_fabricinspection()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->from('fabric_inspection_details');
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
		
		$query=$this->db->get();
		return $query->result();
	}

public function display_fabricinspectio1()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,madeups_work_order.wo_number,
		fabric_inspection_details.vendor_name,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.rec_width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_pcs,fabric_inspection_details.rec_weight,fabric_inspection_details.design,fabric_inspection_details.consumed_at,fabric_inspection_details.rec_by,fabric_inspection_details.customer_id');
		$this->db->join('fabric_madeups_workorder', 'fabric_madeups_workorder.id = fabric_inspection_details.work_order_id','left');
		$this->db->join('madeups_work_order', 'madeups_work_order.id = fabric_madeups_workorder.plan_id','left');
		$this->db->order_by('fabric_inspection_details.id','desc');
		$this->db->from('fabric_inspection_details');
		$this->db->where('status','1');
		$query=$this->db->get();
		return $query->result();
	}  
	
	
	public function update_data($where,$table,$data)
	{
		$this->db->where($where);
		$this->db->update($table,$data);
	}
	 public function fetch_where_subgrid_data1($table,$where)
    {
    	$this->db->select("*");
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->result();
    }
	public function fetch_yarn_data($where)
	{
		$this->db->distinct();
		$this->db->select('*');
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->where($where);
		$query=$this->db->get();
		return $query->result();
	}  
	
	public function fetch_where_rec_goods_total($table,$where)
    {
    	$this->db->select_sum('rec_goods');
    	//$this->db->select('quantity');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////	
	public function display_fabric_fabricinspection($where)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->from('fabric_inspection_details');
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('fabric_inspection_details.id',$where);
		$query=$this->db->get();
		return $query->result();
	}  
	
	public function display_fabric_embroidry_fabricinspection($where)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.po_list_id,fabric_inspection_details.po_id,fabric_inspection_details.indent_no,fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection.variance_mtrs,fabric_inspection_details.available_quantity,fabric_inspection_details.remainning_quantity,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->from('fabric_inspection_details');
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('fabric_inspection_details.id',$where);
		$query=$this->db->get();
		return $query->row();
	}  
		public function get_data_cs_fetch($where,$data2)
	{
		//$this->db->distinct();
		$this->db->select('indent_po.product_name,indent_po.quantity,indent_po.purpose,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description');
			$this->db->from('indent_cs_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_cs_goods_details.po_list_id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('indent_po.po_id',$where);
		$this->db->where('indent_po.financ_year',$data2);
			$this->db->where('indent_cs_goods_details.quantity_approval !=','Not Yet');
		$query=$this->db->get();
		return $query->result();
	}
	
	public function get_data_cs_fetch_details($where,$data2)
	{
		$this->db->select('indent_po.product_name,indent_po.product_id,indent_po.unit,indent_po.currency,indent_po.cgst,indent_po.sgst,indent_po.igst,indent_po.quantity,indent_po.purpose,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description');
		$this->db->from('indent_cs_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_cs_goods_details.po_list_id');
		$this->db->where('indent_po.po_id',$where);
		$this->db->where('indent_po.financ_year',$data2);
		$this->db->where('indent_cs_goods_details.quantity_approval !=','Not Yet');
		$this->db->group_by('indent_po.product_name');
		$query=$this->db->get();
		return $query->result();
	}  
	
public function get_data_cs_fetchs($where)
	{
		//$this->db->distinct();
		$this->db->select('indent_po.product_name,indent_po.quantity,indent_po.purpose,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description');
			$this->db->from('indent_cs_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_cs_goods_details.po_list_id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('indent_po.po_id',$where);
			$this->db->where('indent_cs_goods_details.quantity_approval !=','Not Yet');
		$query=$this->db->get();
		return $query->row();
	}  
	 public function display_ho_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
			$this->db->where('fabric_inspection_details.consumed_at','HO');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->result();
	}  
public function display_fabric_embroidryinspection_date()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date');
		$this->db->order_by('fabric_inspection.id','desc');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
        $this->db->where('fabric_inspection.balanced_mtrs !=','');

$this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	}  
public function display_fabric_embroidryinspection()
	{
	
		$this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,
		fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,
		fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,
		fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,
		fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,
		fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,
		fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,
		fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,
		fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
	
		$query=$this->db->get();
		return $query->result();
	}  
	
	public function display_fabric_embroidryinspection_with_zero()
	{
		//$this->db->distinct();
		$this->db->select('(fabric_inspection.updated_unit * fabric_inspection.balanced_mtrs) as val,indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.updated_unit,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id','left');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection_details.consumed_at !=','0');
// 		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
//         $this->db->where('fabric_inspection.balanced_mtrs !=','');
//         $this->db->where('fabric_inspection.balanced_mtrs >', 0);	
		$query=$this->db->get();
		return $query->result();
	}  
	
public function display_peenya_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.consumed_at','PEENYA - DYEING');
		$this->db->where('fabric_inspection_details.status','0');
			
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->result();
	}   
	
	public function display_nandi_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
			$this->db->where('fabric_inspection_details.consumed_at','NANDI');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->result();
	}   
	
	public function display_tailoring_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
			$this->db->where('fabric_inspection_details.consumed_at','PEENYA - TAILORING');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->result();
	}   
	public function get_data_cs_res_fetch($where)
	{
		//$this->db->distinct();
		$this->db->select('sum(indent_cs_goods_details.received_quality) as received_quality');
			$this->db->from('indent_cs_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_cs_goods_details.po_list_id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('indent_po.po_id',$where);
			$this->db->where('indent_cs_goods_details.quantity_approval !=','Not Yet');
		$query=$this->db->get();
		return $query->row();
	}  
	public function fetch_yarn_new_data($where)
	{
		$this->db->distinct();
		$this->db->select('indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.hank_cones,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade');
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
		$this->db->where($where);
		$query=$this->db->get();
		return $query->result();
	}  
	public function fetch_fabric_new_data($val1,$financ_year)
	{
		$this->db->distinct();
		$this->db->select('indent_po.*,indent_goods_details.*');
		$this->db->from('indent_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_goods_details.po_list_id');
//$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
		$this->db->where('indent_po.po_id',$val1);
		$this->db->where('indent_po.financ_year',$financ_year);
		$query=$this->db->get();
		return $query->result();
	}  
	
	public function display_fabric_ho_grid_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id','left');
		$this->db->where('fabric_inspection_details.consumed_at','HO');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		$this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	}  
	
	
public function display_fabric_peenya_grid_embroidryinspection()
{
    $this->db->select('po.unit, fid.splited_piece_no, fid.received_date, fid.id, 
                      fid.vendor_name, fid.consumed_at, fid.piece_no, fid.po_no, 
                      fid.product_name, fid.width, fid.shades, fid.rec_goods, 
                      fid.rec_weight, fi.inspected_mtrs, fi.rejected_mtrs, 
                      fi.ssl_pc_no, fi.quantity, fid.bal_goods, 
                      fid.remainning_quantity, fid.available_quantity, 
                      fi.variance_mtrs, fi.balanced_mtrs, fid.design, 
                      fid.customer_id');

// Order by indexed or frequently searched column
    $this->db->order_by('fid.id');
    
    // Use table aliases for better readability
    $this->db->from('fabric_inspection_details fid');
    $this->db->join('fabric_inspection fi', 'fi.goods_id = fid.id');
    $this->db->join('indent_po po', 'po.id = fid.po_list_id', 'left');
    
    // Optimize the WHERE clause
    $this->db->where([
        'fid.consumed_at' => 'PEENYA - DYEING',
        'fid.status' => '0',
        'fi.balanced_mtrs >' => 0
    ]);
    
    $query = $this->db->get();
    return $query->result();
}

public function display_fabric_nandi_grid_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id','left');
	$this->db->where('fabric_inspection_details.consumed_at','NANDI');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		$this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	}  
	
	public function display_fabric_tailoring_grid_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id','left');
			$this->db->where('fabric_inspection_details.consumed_at','PEENYA - TAILORING');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		$this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	}  
	
	public function display_fabric_preview_embroidryinspection($val)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.rec_by,fabric_inspection.remarks');
		//$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
			$this->db->where('fabric_inspection_details.id',$val);
		// $this->db->where('fabric_inspection_details.status','0');
		// $this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->row();
	}  
	
	public function display_yarn_preview_grid_data($val)
	{
		$this->db->select('*');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		//$this->db->where('indent_po.product_type', 'Yarn - Raw');
			$this->db->where('indent_yarn_goods_details.id',$val);
		//	$this->db->like('indent_yarn_goods_details.yarnname' ,$v);
		$query=$this->db->get();
		return $query->row();
	}
	public function display_yarn_twisting_preview_grid_data()
	{
		$this->db->distinct();
		$this->db->select('*');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->where('indent_po.product_type', 'Yarn - Twisted');
		$this->db->where('indent_yarn_goods_details.id',$val);
		//$this->db->like('indent_yarn_goods_details.yarnname' ,$v);
		$query=$this->db->get();
		return $query->result();
	}
	
	public function get_work_order_swan_grid_data($table,$where)
	{
		$this->db->select('*');
		//$this->db->group_by('work_order_no','vendor_name','date','delivery_date');
	//	$this->db->order_by('work_order_no');
		$this->db->from($table);
		$this->db->where($where);
		$query=$this->db->get();
		 return $query->row();
	}
	public function delivery_yarn_twisting_detailed_grid_data($val)
	{
		$this->db->select('*');
		$this->db->from('delivery_yarn_twisting');
		// $this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		// //$this->db->where('indent_po.product_type', 'Yarn - Raw');
			$this->db->where('id',$val);
		//	$this->db->like('indent_yarn_goods_details.yarnname' ,$v);
		$query=$this->db->get();
		return $query->row();
	}
		public function display_swan_yarn_preview_grid_data($val)
	{
		$this->db->select('*');
		$this->db->from(' work_order_dyeing');
		$this->db->where('id',$val);
		$query=$this->db->get();
		return $query->row();
	}
	
	public function display_fabric_stock_grid_embroidryinspection($product_location)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.consumed_at',$product_location);
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->result();
	}  
public function display_fabric_embroidry_location($location)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
$this->db->where('fabric_inspection.balanced_mtrs !=','');
		$this->db->where('fabric_inspection_details.consumed_at',$location);
		
		$query=$this->db->get();
		return $query->result();
	}  
	
public function display_issue_fabric_location($location)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.consumed_at',$location);
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		
		$query=$this->db->get();
		return $query->result();
	}  
public function display_stock_transfer_data($location)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		$this->db->where('fabric_inspection_details.consumed_at',$location);
		$query=$this->db->get();
		return $query->result();
	}  
	
	
		public function get_stock_transfer_loca_data($location)
	{
		 $this->db->distinct('indent_cs_goods_details.po_id');
		$this->db->select('indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date');
		 $this->db->from('indent_cs_goods_details');
        $this->db->join('indent_po','indent_cs_goods_details.po_list_id=indent_po.id');
		$this->db->where('indent_po.product_type','Consumables');
		$this->db->where('indent_po.confirm','Yes');
		$this->db->where('indent_po.total_quantity !=','0.00');
		$this->db->where('indent_cs_goods_details.consumed_at',$location);
		$query=$this->db->get();
		 return $query->result();
	}
	
	public function get_stock_transfer_loca_spares_data($location)
	{
		 $this->db->distinct('indent_cs_goods_details.po_id');
		$this->db->select('indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date');
		 $this->db->from('indent_cs_goods_details');
        $this->db->join('indent_po','indent_cs_goods_details.po_list_id=indent_po.id');
		$this->db->where('indent_po.product_type','Spares');
		$this->db->where('indent_po.confirm','Yes');
		$this->db->where('indent_po.total_quantity !=','0.00');
		$this->db->where('indent_cs_goods_details.consumed_at',$location);
		$query=$this->db->get();
		 return $query->result();
	}
	public function get_stock_transfer_loca_raw_data($location)
	{
		$this->db->select('*');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->where('indent_po.product_type', 'Yarn - Raw');
			$this->db->where('indent_yarn_goods_details.issue_gross_weight !=' ,'0');
			$this->db->where('indent_yarn_goods_details.issue_net_weight >' ,'0');
	$this->db->where('indent_yarn_goods_details.consumed_at',$location);
		$query=$this->db->get();
		return $query->result();
	}
	 public function get_stock_transfer_loca_twisting_data($table,$where,$location)
    {
    	$this->db->select('*');
    	$this->db->from($table);
    	$this->db->where($where);
    	$this->db->where('consumed_at',$location);
    	$query=$this->db->get();
    	return $query->result();
    }
	public function get_stock_transfer_loca_dyed_data($v)
	{
		$this->db->select('indent_yarn_goods_details.id,indent_yarn_goods_details.ssl_shade,indent_add_indent.shades,indent_po.purpose,indent_add_indent.color_code,indent_yarn_goods_details.yarnname,indent_yarn_goods_details.yarndenier,indent_yarn_goods_details.yarnspecification,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.issue_gross_weight,indent_yarn_goods_details.issue_net_weight,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_date');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->join('indent_add_indent', 'indent_po.indent_id = indent_add_indent.id');
		$this->db->where('indent_po.product_type', 'Yarn - Dyed');
		$this->db->where('indent_yarn_goods_details.issue_gross_weight !=', '0');
		$this->db->where('indent_yarn_goods_details.issue_net_weight >' ,'0');
   	$this->db->like('indent_yarn_goods_details.consumed_at' ,$v);
		$query=$this->db->get();
	//	$query=$this->db->get();
		return $query->result();
	}
	
	public function get_stock_transfer_loca_swan_dyed_data($table,$where,$location)
	{
		$this->db->select('*');
		//$this->db->group_by('work_order_no','vendor_name','date','delivery_date');
	//	$this->db->order_by('work_order_no');
		$this->db->from($table);
		$this->db->where($where);
		$this->db->where('location',$location);
		$query=$this->db->get();
		 return $query->result();
	}

public function fetch_where_fabric_row_data($where)
    {
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.id',$where);
		//$this->db->where('fabric_inspection_details.status','0');
		//$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		//$this->db->where('fabric_inspection_details.consumed_at',$location);
		$query=$this->db->get();
		return $query->row();
	}
	public function get_stock_transfer_yarnraw_row_data($where)
	{
		$this->db->select('*');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->where('indent_po.product_type', 'Yarn - Raw');
		$this->db->where('indent_yarn_goods_details.id',$where);
		$query=$this->db->get();
		return $query->row();
	}
	 public function get_stock_transfer_yarntwisting_row_data($table,$where)
    {
    	$this->db->select('*');
    	$this->db->from($table);
    	  	$this->db->where('id',$where);
    	$query=$this->db->get();
    	return $query->row();
    }
	
	public function get_stock_transfer_yarndyed_row_data($where)
	{
		$this->db->select('indent_yarn_goods_details.id,indent_yarn_goods_details.ssl_shade,indent_add_indent.shades,indent_po.purpose,indent_add_indent.color_code,indent_yarn_goods_details.yarnname,indent_yarn_goods_details.yarndenier,indent_yarn_goods_details.yarnspecification,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.issue_gross_weight,indent_yarn_goods_details.issue_net_weight,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_date');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->join('indent_add_indent', 'indent_po.indent_id = indent_add_indent.id');
		$this->db->where('indent_po.product_type', 'Yarn - Dyed');
			$this->db->like('indent_yarn_goods_details.id' ,$where);
		$query=$this->db->get();
	//	$query=$this->db->get();
		return $query->row();
	}
		public function get_stock_transfer_consumable_row_data($where)
	{
		 $this->db->distinct('indent_cs_goods_details.po_id');
		$this->db->select('indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date');
		 $this->db->from('indent_cs_goods_details');
        $this->db->join('indent_po','indent_cs_goods_details.po_list_id=indent_po.id');
		$this->db->where('indent_po.id',$where);
		$query=$this->db->get();
		 return $query->row();
	}
	public function get_stock_transfer_spares_row_data($where)
	{
		 $this->db->distinct('indent_cs_goods_details.po_id');
		$this->db->select('indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date');
		 $this->db->from('indent_cs_goods_details');
        $this->db->join('indent_po','indent_cs_goods_details.po_list_id=indent_po.id');
		$this->db->where('indent_po.product_type','Spares');
		$this->db->where('indent_po.id',$where);
		$query=$this->db->get();
		 return $query->row();
	}
	public function get_stock_transfer_loca_swandyed_row_data($table,$where)
	{
		$this->db->select('*');
		$this->db->from($table);
		$this->db->where('id',$where);
		$query=$this->db->get();
		 return $query->row();
	}
	
	public function max_select_transfer_no($table)
    {
    	$this->db->select_max('transfer_id_val');
    	$this->db->from($table);
    	$query = $this->db->get();
    	return $query->row();
    }	
public function display_fabric_kumara_grid_embroidryinspection()
{

$this->db->select([
        'indent_po.unit',
        'fabric_inspection_details.splited_piece_no',
        'fabric_inspection_details.received_date',
        'fabric_inspection_details.id',
        'fabric_inspection_details.vendor_name',
        'fabric_inspection_details.consumed_at',
        'fabric_inspection_details.piece_no',
        'fabric_inspection_details.po_no',
        'fabric_inspection_details.product_name',
        'fabric_inspection_details.width',
        'fabric_inspection_details.shades',
        'fabric_inspection_details.rec_goods',
        'fabric_inspection_details.rec_weight',
        'fabric_inspection.inspected_mtrs',
        'fabric_inspection.rejected_mtrs',
        'fabric_inspection.ssl_pc_no',
        'fabric_inspection.quantity',
        'fabric_inspection_details.bal_goods',
        'fabric_inspection_details.remainning_quantity',
        'fabric_inspection_details.available_quantity',
        'fabric_inspection.variance_mtrs',
        'fabric_inspection.balanced_mtrs',
        'fabric_inspection_details.design',
        'fabric_inspection_details.customer_id'
    ]);

$this->db->from('fabric_inspection_details');
    $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
    $this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id', 'left');

$this->db->where('fabric_inspection_details.consumed_at', 'KUMARA PARK');
    $this->db->where('fabric_inspection_details.status', '0');
    $this->db->where('fabric_inspection.balanced_mtrs >', 0);

$this->db->order_by('fabric_inspection_details.id');
    
  
    $query = $this->db->get();
    return $query->result();
}

public function display_fabric_BYATRANPURA_grid_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id','left');
		$this->db->where('fabric_inspection_details.consumed_at','BYATRANPURA');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		$this->db->where('fabric_inspection.balanced_mtrs >', 0);
		$query=$this->db->get();
		return $query->result();
	}

public function display_fabric_VIJAYAPURA_grid_embroidryinspection()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->join('indent_po', 'indent_po.id = fabric_inspection_details.po_list_id','left');
		$this->db->where('fabric_inspection_details.consumed_at','VIJAYAPURA');
		$this->db->where('fabric_inspection_details.status','0');
		$this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
		$this->db->where('fabric_inspection.balanced_mtrs >', 0);
		$query=$this->db->get();
		return $query->result();
	}

public function display_fabric_DODDAJALA_grid_embroidryinspection()
{
    // Select only necessary columns
    $this->db->select([
        'fabric_inspection_details.splited_piece_no',
        'fabric_inspection_details.received_date',
        'fabric_inspection_details.id',
        'fabric_inspection_details.vendor_name',
        'fabric_inspection_details.consumed_at',
        'fabric_inspection_details.piece_no',
        'fabric_inspection_details.po_no',
        'fabric_inspection_details.product_name',
        'fabric_inspection_details.width',
        'fabric_inspection_details.shades',
        'fabric_inspection_details.rec_goods',
        'fabric_inspection_details.rec_weight',
        'fabric_inspection.inspected_mtrs',
        'fabric_inspection.rejected_mtrs',
        'fabric_inspection.ssl_pc_no',
        'fabric_inspection.quantity',
        'fabric_inspection_details.bal_goods',
        'fabric_inspection_details.remainning_quantity',
        'fabric_inspection_details.available_quantity',
        'fabric_inspection.variance_mtrs',
        'fabric_inspection.balanced_mtrs',
        'fabric_inspection_details.design',
        'fabric_inspection_details.customer_id'
    ]);

$this->db->from('fabric_inspection_details');
    $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');

$this->db->where('fabric_inspection_details.consumed_at', 'DODDAJALA');
    $this->db->where('fabric_inspection_details.status', '0');
    $this->db->where('fabric_inspection.balanced_mtrs >', 0);

$this->db->order_by('fabric_inspection_details.id');
    
   
    $query = $this->db->get();
    return $query->result();
}

public function fabric_inspection_history_piece_card($val)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.inspected_weight,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date,fabric_inspection.remarks');
		$this->db->order_by('fabric_inspection.id','desc');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.id',$val);

$query=$this->db->get();
		return $query->row();
	}  
public function display_split_fabric_embroidryinspection($where)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.id',$where);
		$query=$this->db->get();
		return $query->row();
	}  
	public function display_split_fabric_embroidryinspection_merge($where)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design');
		$this->db->order_by('fabric_inspection_details.id');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where_in('fabric_inspection_details.id',$where);
		$query=$this->db->get();
		//print_r($this->db->last_query());
		//die();
		return $query->result();
	}  
public function display_split_fabric_detailsembroidryinspection($where)
	{
		//$this->db->distinct();
		$this->db->select('*');
		$this->db->from('fabric_inspection_details');
		$this->db->where('id',$where);
		$query=$this->db->get();
		return $query->row();
	}  
	
	public function display_split_fabric_inspe_embroidryinspection($where)
	{
		//$this->db->distinct();
		$this->db->select('*');
		$this->db->from('fabric_inspection');
		$this->db->where('goods_id ',$where);
		$query=$this->db->get();
		return $query->row();
	} 
public function display_fabric_inspection_embroidryinspection_date()
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date');
		$this->db->order_by('fabric_inspection.id','desc');
		$this->db->from('fabric_inspection_details');
		
		
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.status','0');
		// $this->db->where('fabric_inspection.balanced_mtrs !=','0.00');
// $this->db->where('fabric_inspection.balanced_mtrs !=','');
		// $this->db->where('fabric_inspection.balanced_mtrs >',0);
		$query=$this->db->get();
		return $query->result();
	}  
public function get_stock_po_transfer_spares_row_data($where)
	{
		
		$this->db->select('*');
		$this->db->from('indent_po');
        $this->db->join('fabric_inspection_details','fabric_inspection_details.po_list_id=indent_po.id');
		$this->db->join('indent_add_indent','indent_po.indent_id=indent_add_indent.id');
		$this->db->join('orders','orders.oslNo=indent_add_indent.purpose');
		$this->db->where('fabric_inspection_details.id',$where);
		$query=$this->db->get();
		 return $query->row();
	}
public function fetch_where_qua_goods_total($table,$where)
    {
    	$this->db->select_sum('issue_quantity');
    	//$this->db->select('quantity');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
public function fetch_where_stock_goods_total($table,$where)
    {
    	$this->db->select_sum('issue_stock');
    	//$this->db->select('quantity');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
/////////////////////////////////   28-8-2018 /////////////////////////////////////////
public function edit_display_fabric_embroidryinspection($val)
	{
		//$this->db->distinct();
		$this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id');
		$this->db->from('fabric_inspection_details');
		$this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		$this->db->where('fabric_inspection_details.id',$val);	
		$query=$this->db->get();
		return $query->row();
	}

public function custom_osl()
{
$this->db->select('*')->group_by('po_no')->from('fabric_inspection_details')->like('po_no' ,'OSL');
$query=$this->db->get();
		return $query->result();
}
public function custom_get_details($table)
{
    	$this->db->select('*');
$this->db->order_by('customerID');
    	$this->db->from($table);
    	$query= $this->db->get();
	return $query->result();
    
}

public function date_wise_inspected_reports_1()
 {
		// $this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date');
		// $this->db->order_by('fabric_inspection.id','desc');
// $this->db->group_by('fabric_inspection.ssl_pc_no');
		// $this->db->from('fabric_inspection_details');
		
		
		// $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		// $this->db->where('fabric_inspection_details.status','0');
		 // $this->db->where('fabric_inspection.sys_date >=',$from_date);
 // $this->db->where('fabric_inspection.sys_date <=',$to_date);
			// $query=$this->db->get();
		// return $query->result();
	
		$select = "select madeups_work_order.wo_number,fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date";
        $from   = " from fabric_inspection,fabric_inspection_details,madeups_work_order";
        $where  = " where ";
       $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";
       
       $where .= " and fabric_inspection_details.work_order_id = madeups_work_order.id";

$where .= " and fabric_inspection_details.status = '0'";
        
        // $where .= " and STR_TO_DATE(fabric_inspection.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
        // $where .=" and STR_TO_DATE(fabric_inspection.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
        // if($consumed_at == "all")
        // {
        //  $where .=" and fabric_inspection_details.consumed_at !=''";
        // }
        // else
        // {
        //     $where .=" and fabric_inspection_details.consumed_at='$consumed_at'";
        // }
        
		$where .=" GROUP BY fabric_inspection.ssl_pc_no";
		$where .=" ORDER BY fabric_inspection.id desc";
        $sql    = $select.$from.$where;
        //print_r($sql);
        //die();
        $result = $this->db->query($sql);
		return $result->result();

}
 
 public function date_wise_inspected_reportss_2()
 {
// $f=date('d/m/Y',strtotime($from_date));
// $t=date('d/m/Y',strtotime($to_date));

// $this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date');
		// $this->db->order_by('fabric_inspection.id','desc');
// $this->db->group_by('fabric_inspection.ssl_pc_no');
		// $this->db->from('fabric_inspection_details');
		
		
		// $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		// $this->db->where('fabric_inspection_details.status','0');
		 // $this->db->where('fabric_inspection.sys_date >=',$from_date);
 // $this->db->where('fabric_inspection.sys_date <=',$to_date);
			// $query=$this->db->get();
		// return $query->result();
		
		$select = "select fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date";
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and fabric_inspection_details.status = '0'";
        
        // $where .= " and STR_TO_DATE(fabric_inspection.sys_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
        // $where .=" and STR_TO_DATE(fabric_inspection.sys_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";
        // $where .=" and fabric_inspection_details.consumed_at ='$consumed_at'";
        
		$where .=" GROUP BY fabric_inspection.ssl_pc_no";
		$where .=" ORDER BY fabric_inspection.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result();

}
 
public function date_wise_inspected_reports($from_date,$to_date,$consumed_at)
 {
		// $this->db->select('fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date');
		// $this->db->order_by('fabric_inspection.id','desc');
// $this->db->group_by('fabric_inspection.ssl_pc_no');
		// $this->db->from('fabric_inspection_details');
		
		
		// $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		// $this->db->where('fabric_inspection_details.status','0');
		 // $this->db->where('fabric_inspection.sys_date >=',$from_date);
 // $this->db->where('fabric_inspection.sys_date <=',$to_date);
			// $query=$this->db->get();
		// return $query->result();
	
		$select = "select fabric_inspection.inspected_weight,fabric_inspection.rejected_weight,fabric_inspection_details.splited_piece_no,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date";
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
       $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and fabric_inspection_details.status = '0'";
        $where .= " and STR_TO_DATE(fabric_inspection.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
        if($consumed_at == "all")
        {
         $where .=" and fabric_inspection_details.consumed_at !=''";
        }
        else
        {
            $where .=" and fabric_inspection_details.consumed_at='$consumed_at'";
        }
		$where .=" GROUP BY fabric_inspection.ssl_pc_no";
		$where .=" ORDER BY fabric_inspection.id desc";
        $sql    = $select.$from.$where;
        //print_r($sql);
        //die();
        $result = $this->db->query($sql);
		return $result->result();

}
 
 public function inspected_reports($id,$fin_year)
 {
		
	
        $select = "select fabric_inspection.inspected_weight,fabric_inspection_details.no_type_val,fabric_inspection.rejected_weight,fabric_inspection_details.splited_piece_no,fabric_inspection_details.invoice,fabric_inspection_details.id,fabric_inspection_details.received_date,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection.sys_date";
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";
        
        
        $where .= " and fabric_inspection_details.status = '0'";
        $where .= " and fabric_inspection_details.po_id = '$id'";
        $where .= " and fabric_inspection.fina_year = '$fin_year'";
        
		$where .=" GROUP BY fabric_inspection.ssl_pc_no";
		$where .=" ORDER BY fabric_inspection.id desc";
        $sql    = $select.$from.$where;
        //print_r($sql);
        //die();
        $result = $this->db->query($sql);
		return $result->result();

}
public function date_wise_inspected_reports_XSL($from_date,$to_date)
 {
		// $this->db->select_SUM('fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs');
		// $this->db->order_by('fabric_inspection.id','desc');
// $this->db->group_by('fabric_inspection.ssl_pc_no');
		// $this->db->from('fabric_inspection_details');
		
		
		// $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		// $this->db->where('fabric_inspection_details.status','0');
		 // $this->db->where('fabric_inspection.sys_date >=',$from_date);
 // $this->db->where('fabric_inspection.sys_date <=',$to_date);
			// $query=$this->db->get();
		// return $query->result();
		
		$select = "select SUM(fabric_inspection_details.rec_goods) as rec_goods";
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

}
public function display_fabric_reports_grid_embroidryinspection($from_date,$to_date)
	{
		$select = "select fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id";
		
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and fabric_inspection_details.status = '0'";
		$where .= " and fabric_inspection.balanced_mtrs != '0.00'";
		$where .= " and fabric_inspection.balanced_mtrs > '0'";
        $where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
		$where .=" ORDER BY fabric_inspection_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	
public function display_fabric_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc)
	{
		$select = "select indent_po.unit,fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id";
		
        $from   = " from fabric_inspection,fabric_inspection_details,indent_po";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and fabric_inspection_details.status = '0'";
		$where .= " and fabric_inspection.balanced_mtrs != '0.00'";
		$where .= " and fabric_inspection.balanced_mtrs > '0'";
$where .= " and fabric_inspection_details.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
         $where .=" or indent_po.id = fabric_inspection_details.po_list_id";
		$where .=" ORDER BY fabric_inspection_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function display_madeups_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc)
	{
		$select = "select fabric_madeups_delivery_confirmation.*";
		
        $from   = " from fabric_madeups_delivery_confirmation";
        $where  = " where ";
      
        $where .= " fabric_madeups_delivery_confirmation.received_qty > '0'";
	$where .= " and fabric_madeups_delivery_confirmation.location = '$loc'";
        $where .= " and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
       $where .=" and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_consumable_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type)
	{
		$select = "select indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date";
		
        $from   = " from indent_po,indent_cs_goods_details";
        $where  = " where ";
        $where .= "indent_cs_goods_details.po_list_id = indent_po.id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_yarn_goods_details.issue_net_weight > '0'";
		$where .= " and indent_yarn_goods_details.issue_gross_weight != '0'";
$where .= " and indent_yarn_goods_details.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	
	
	public function display_twist_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type)
	{
		$select = "select delivery_yarn_twisting.*";
		
        $from   = " from delivery_yarn_twisting";
        $where  = " where ";
      
        $where .= " delivery_yarn_twisting.status = '1'";
		
$where .= " and delivery_yarn_twisting.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_swan_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type)
	{
		$select = "select work_order_dyeing.*,workorder_dyeing.work_order_no";
		
        $from   = " from work_order_dyeing JOIN workorder_dyeing on work_order_dyeing.dyed_id = workorder_dyeing.id";
        $where  = " where ";
      
        $where .= " work_order_dyeing.status = 'COMPLETED'";
		 $where .= " and work_order_dyeing.yarn_status = '0'";
		 $where .= " and work_order_dyeing.rec_dyed_qua > '0'";
$where .= " and work_order_dyeing.location = '$loc'";
        $where .= " and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	
	
	}  
	public function display_twist_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc,$type)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));

$select = "select delivery_yarn_twisting.*";
		
        $from   = " from delivery_yarn_twisting";
        $where  = " where ";
      
        $where .= " delivery_yarn_twisting.status = '1'";
		
$where .= " and delivery_yarn_twisting.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
 
        $where .=" and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_raw_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc,$type)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));
		$select = "select indent_po.*,indent_yarn_goods_details.*";
		
        $from   = " from indent_po,indent_yarn_goods_details";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_yarn_goods_details.issue_net_weight > '0'";
		$where .= " and indent_yarn_goods_details.issue_gross_weight != '0'";
$where .= " and indent_yarn_goods_details.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
 
        $where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$select = "select indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date";
		
        $from   = " from indent_po,indent_cs_goods_details";
        $where  = " where ";
        $where .= "indent_cs_goods_details.po_list_id = indent_po.id";

//	$where .=" DISTINCT indent_cs_goods_details.po_id";
		
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_fabric_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));

$select = "select fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id";
		
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$where .=" ORDER BY fabric_inspection_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function date_wise_inspected_reportss($from_date,$to_date,$consumed_at)
 {
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));

$where .= " and fabric_inspection_details.status = '0'";
        $where .= " and STR_TO_DATE(fabric_inspection.sys_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection.sys_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";
        $where .=" and fabric_inspection_details.consumed_at ='$consumed_at'";
		$where .=" GROUP BY fabric_inspection.ssl_pc_no";
		$where .=" ORDER BY fabric_inspection.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result();

}
public function date_wise_inspected_reports_XSLl($from_date,$to_date)
 {
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));
		// $this->db->select_SUM('fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs');
		// $this->db->order_by('fabric_inspection.id','desc');
// $this->db->group_by('fabric_inspection.ssl_pc_no');
		// $this->db->from('fabric_inspection_details');
		
		
		// $this->db->join('fabric_inspection', 'fabric_inspection.goods_id = fabric_inspection_details.id');
		// $this->db->where('fabric_inspection_details.status','0');
		 // $this->db->where('fabric_inspection.sys_date >=',$from_date);
 // $this->db->where('fabric_inspection.sys_date <=',$to_date);
			// $query=$this->db->get();
		// return $query->result();
		
		$select = "select SUM(fabric_inspection_details.rec_goods) as rec_goods,SUM(fabric_inspection_details.rec_weight) as rec_weight,SUM(fabric_inspection.inspected_mtrs) as inspected_mtrs,
		SUM(fabric_inspection.rejected_mtrs) as rejected_mtrs,
		SUM(fabric_inspection.quantity) as quantity,
		SUM(fabric_inspection_details.bal_goods) as bal_goods,
		SUM(fabric_inspection_details.remainning_quantity) as remainning_quantity,
		SUM(fabric_inspection_details.available_quantity) as available_quantity,
		SUM(fabric_inspection.variance_mtrs) as variance_mtrs,
		SUM(fabric_inspection.balanced_mtrs) as balanced_mtrs";
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and fabric_inspection_details.status = '0'";
        $where .= " and STR_TO_DATE(fabric_inspection.sys_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection.sys_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";
		$where .=" GROUP BY fabric_inspection.ssl_pc_no";
		$where .=" ORDER BY fabric_inspection.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row();

}
public function display_swan_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type)
	{
		$select = "select work_order_dyeing.*,workorder_dyeing.work_order_no";
		
        $from   = " from work_order_dyeing JOIN workorder_dyeing on work_order_dyeing.dyed_id = workorder_dyeing.id";
        $where  = " where ";
     
        $where .= " work_order_dyeing.status = 'COMPLETED'";
		 $where .= " and work_order_dyeing.yarn_status = '0'";
		 $where .= " and work_order_dyeing.rec_dyed_qua > '0'";
//$where .= " and work_order_dyeing.location = '$loc'";
        $where .= " and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result();

}  
public function display_fabric_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc)
	{
		$select = "select fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id";
		
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
        $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$where .=" ORDER BY fabric_inspection_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_raw_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type)
	{
		$select = "select indent_po.*,indent_yarn_goods_details.*";
		
        $from   = " from indent_po,indent_yarn_goods_details";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_yarn_goods_details.issue_net_weight > '0'";
		$where .= " and indent_yarn_goods_details.issue_gross_weight != '0'";
//$where .= " and indent_yarn_goods_details.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_raw_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc,$type)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));
		$select = "select indent_po.*,indent_yarn_goods_details.*";
		
        $from   = " from indent_po,indent_yarn_goods_details";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_yarn_goods_details.issue_net_weight > '0'";
		$where .= " and indent_yarn_goods_details.issue_gross_weight != '0'";
//$where .= " and indent_yarn_goods_details.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
 
        $where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_twist_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type)
	{
		$select = "select delivery_yarn_twisting.*";
		
        $from   = " from delivery_yarn_twisting";
        $where  = " where ";
      
        $where .= " delivery_yarn_twisting.status = '1'";
		
//$where .= " and delivery_yarn_twisting.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_twist_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc,$type)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));

$select = "select delivery_yarn_twisting.*";
		
        $from   = " from delivery_yarn_twisting";
        $where  = " where ";
      
        $where .= " delivery_yarn_twisting.status = '1'";
		
//$where .= " and delivery_yarn_twisting.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
 
        $where .=" and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_consumable_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type)
	{
		$select = "select indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date";
		
        $from   = " from indent_po,indent_cs_goods_details";
        $where  = " where ";
        $where .= "indent_cs_goods_details.po_list_id = indent_po.id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_po.confirm= 'Yes'";
		$where .= " and indent_po.total_quantity != '0.00'";
//$where .= " and indent_cs_goods_details.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(indent_cs_goods_details.received_date,'%d/%m/%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
 //$where .= " or STR_TO_DATE(indent_cs_goods_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
        $where .=" and STR_TO_DATE(indent_cs_goods_details.received_date,'%d/%m/%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
//$where .=" or STR_TO_DATE(indent_cs_goods_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
	//	$where .=" DISTINCT indent_cs_goods_details.po_id";
		
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_consumable_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc,$type)
	{
$f=date('d-m-Y',strtotime($from_date));
$t=date('d-m-Y',strtotime($to_date));

//	$where .=" DISTINCT indent_cs_goods_details.po_id";
		
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_madeups_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc)
	{
		$select = "select fabric_madeups_delivery_confirmation.*";
		
        $from   = " from fabric_madeups_delivery_confirmation";
        $where  = " where ";
      
        $where .= " fabric_madeups_delivery_confirmation.received_qty > '0'";
	//$where .= " and fabric_madeups_delivery_confirmation.location = '$loc'";
        $where .= " and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
       $where .=" and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_po_reports_loc_grid_embroidryinspection_data($from_date,$to_date)
	{
		$select = "select indent_po.*";
		
        $from   = " from indent_po";
        $where  = " where ";
      
        $where .= " STR_TO_DATE(indent_po.created_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
       $where .=" and STR_TO_DATE(indent_po.created_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY indent_po.po_id";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_po_reports_loc_grid_embroidryinspection_data_group($from_date,$to_date)
	{
		$select = "select SUM(indent_po.grand_total) as g_total,indent_po.currency";
		
        $from   = " from indent_po";
        $where  = " where ";
      
        $where .= " STR_TO_DATE(indent_po.created_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
       $where .=" and STR_TO_DATE(indent_po.created_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
 $where .=" GROUP BY indent_po.currency";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function get_data_customer_group($table)
	{
		$this->db->select("*");
$this->db->group_by('po_id');
		$this->db->from($table);
		
		$query = $this->db->get();
		return $query->result();
	}
public function get_data_fabric_fetch()
	{
        $this->db->select("*");
        $this->db->from('finishing_embroidry');
        
        
        $this->db->join('finishing_embroidry_stock', 'finishing_embroidry_stock.fin_emb_id = finishing_embroidry.id');
        $this->db->where('finishing_embroidry.status',1);
        $query = $this->db->get();
        return $query->result();
	}
	
	public function date_madeups_workorder_data($from_date,$to_date,$consumed_at)
	{

// $to_date1 = date($from_date);
    //     //$this->db->select("madeups_work_order.*,fabric_madeups_workorder.f_osl,fabric_madeups_workorder.f_ssl_piece,fabric_madeups_workorder.size,fabric_madeups_workorder.article,fabric_madeups_workorder.design,fabric_madeups_workorder.f_shade,
    //     //fabric_madeups_workorder.recieved_mtrs,fabric_madeups_workorder.recieved_estimate_pcs,fabric_madeups_workorder.f_issue_mtrs,fabric_madeups_workorder.est_pcs,fabric_madeups_workorder.f_width,fabric_madeups_workorder.article as art,fabric_madeups_workorder.design as des,fabric_madeups_workorder.shades");
    //     $this->db->select("madeups_work_order.*,madeups_work_order.id as id_val,fabric_madeups_workorder.*,f_wo.rec_mtrs as sum_rec_mtrs,f_wo.rec_width as sum_width,f_wo.processed_mtrs as sum_processed_mtrs,f_wo.rec_pcs as sum_est_pcs,f_wo.rec_weight as sum_rec_weight,f_wo.vari_e_width as sum_variance,f_wo.type_recieved,f_wo.invoice as inv,f_wo.received_date");
    //     $this->db->from('madeups_work_order');
        
       
        
    //     //$this->db->group_by('madeups_work_order.id');
        
    //     $this->db->join('fabric_madeups_workorder', 'fabric_madeups_workorder.plan_id = madeups_work_order.id');
    //     $this->db->join('wo_inspection_details f_wo', 'fabric_madeups_workorder.id = f_wo.work_order_id','left');
        
      
    //     $this->db->where('STR_TO_DATE(REPLACE(f_wo.received_date, "/", "-"),"%d-%m-%Y") >=', 'STR_TO_DATE("01-01-2024", "%d-%m-%Y")');
    //     $this->db->where('STR_TO_DATE(REPLACE(f_wo.received_date, "/", "-"),"%d-%m-%Y") <=', 'STR_TO_DATE("26-02-2024", "%d-%m-%Y")');
 
 
    //     $this->db->group_by('fabric_madeups_workorder.id');
    //     $this->db->order_by('madeups_work_order.id','DESC');
    //     $query = $this->db->get();
        
        $sql = "
                SELECT 
                    `madeups_work_order`.*, 
                    `madeups_work_order`.`id` as id_val, 
                    `fabric_madeups_workorder`.*, 
                    `f_wo`.`rec_mtrs` as sum_rec_mtrs, 
                    `f_wo`.`rec_width` as sum_width, 
                    `f_wo`.`processed_mtrs` as sum_processed_mtrs, 
                    `f_wo`.`rec_pcs` as sum_est_pcs, 
                    `f_wo`.`rec_weight` as sum_rec_weight, 
                    `f_wo`.`vari_e_width` as sum_variance, 
                    `f_wo`.`type_recieved`, 
                    `f_wo`.`invoice` as inv, 
                    `f_wo`.`received_date`
                FROM 
                    `madeups_work_order`
                JOIN 
                    `fabric_madeups_workorder` ON `fabric_madeups_workorder`.`plan_id` = `madeups_work_order`.`id`
                LEFT JOIN 
                    `wo_inspection_details` f_wo ON `fabric_madeups_workorder`.`id` = `f_wo`.`work_order_id`
                WHERE 
                    STR_TO_DATE(REPLACE(f_wo.received_date, '/', '-'), '%d-%m-%Y') >= STR_TO_DATE('$from_date', '%d-%m-%Y')
                    AND STR_TO_DATE(REPLACE(f_wo.received_date, '/', '-'), '%d-%m-%Y') <= STR_TO_DATE('$to_date', '%d-%m-%Y')
                GROUP BY 
                    `fabric_madeups_workorder`.`id`
                ORDER BY 
                    `madeups_work_order`.`id` DESC;
                ";
        
        // print_r($this->db->last_query());
        // die();
        
         $result = $this->db->query($sql);
		return $result->result(); 
       
    
        
        
        //return $query->result();
	}
	
	public function madeups_workorder_data()
	{
        //$this->db->select("madeups_work_order.*,fabric_madeups_workorder.f_osl,fabric_madeups_workorder.f_ssl_piece,fabric_madeups_workorder.size,fabric_madeups_workorder.article,fabric_madeups_workorder.design,fabric_madeups_workorder.f_shade,
        //fabric_madeups_workorder.recieved_mtrs,fabric_madeups_workorder.recieved_estimate_pcs,fabric_madeups_workorder.f_issue_mtrs,fabric_madeups_workorder.est_pcs,fabric_madeups_workorder.f_width,fabric_madeups_workorder.article as art,fabric_madeups_workorder.design as des,fabric_madeups_workorder.shades");
        $this->db->select("madeups_work_order.*,madeups_work_order.id as id_val,fabric_madeups_workorder.*,f_wo.rec_mtrs as sum_rec_mtrs,f_wo.rec_width as sum_width,f_wo.processed_mtrs as sum_processed_mtrs,f_wo.rec_pcs as sum_est_pcs,f_wo.rec_weight as sum_rec_weight,f_wo.vari_e_width as sum_variance,f_wo.type_recieved,f_wo.invoice as inv,f_wo.received_date");
        $this->db->from('madeups_work_order');
        
       
        
        //$this->db->group_by('madeups_work_order.id');
        
        $this->db->join('fabric_madeups_workorder', 'fabric_madeups_workorder.plan_id = madeups_work_order.id');
        $this->db->join('wo_inspection_details f_wo', 'fabric_madeups_workorder.id = f_wo.work_order_id','left');
        $this->db->group_by('fabric_madeups_workorder.id');
        $this->db->order_by('madeups_work_order.id','DESC');
        $query = $this->db->get();
        
        //print_r($this->db->last_query());
        //die();
        return $query->result();
	}

public function display_emb_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc)
	{
		$select = "select finishing_embroidry.*,finishing_embroidry_stock.*";
		
        $from   = " from finishing_embroidry,finishing_embroidry_stock";
        $where  = " where ";
        $where .= "finishing_embroidry_stock.fin_emb_id = finishing_embroidry.id";

$where .= " and finishing_embroidry.status = '1'";
		
$where .= " and finishing_embroidry_stock.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(finishing_embroidry_stock.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

$where .=" and STR_TO_DATE(finishing_embroidry_stock.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_emb_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));

$select = "select finishing_embroidry.*,finishing_embroidry_stock.*";
		
        $from   = " from finishing_embroidry,finishing_embroidry_stock";
        $where  = " where ";
        $where .= "finishing_embroidry_stock.fin_emb_id = finishing_embroidry.id";

$where .=" and STR_TO_DATE(finishing_embroidry_stock.received_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_emb_reports_loc_grid_embroidryinspections($from_date,$to_date,$loc)
	{
		$select = "select finishing_embroidry.*,finishing_embroidry_stock.*";
		
        $from   = " from finishing_embroidry,finishing_embroidry_stock";
        $where  = " where ";
        $where .= "finishing_embroidry_stock.fin_emb_id = finishing_embroidry.id";

$where .= " and finishing_embroidry.status = '1'";
		
//$where .= " and finishing_embroidry_stock.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(finishing_embroidry_stock.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

$where .=" and STR_TO_DATE(finishing_embroidry_stock.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_emb_reports_loc_grid_embroidryinspectionns($from_date,$to_date,$loc)
	{
$f=date('d/m/Y',strtotime($from_date));
$t=date('d/m/Y',strtotime($to_date));

$where .=" and STR_TO_DATE(finishing_embroidry_stock.received_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_fab_reports($from_date,$to_date)
	{
		$select = "select fabric_transfer.*";
		
        $from   = " from fabric_transfer";
        $where  = " where ";
       
       
        $where .= " fabric_transfer.status= '1'";

$where .= " and STR_TO_DATE(fabric_transfer.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(fabric_transfer.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_raw_reports($from_date,$to_date,$type)
	{
		$select = "select yarn_transfer.*";
		
        $from   = " from yarn_transfer";
        $where  = " where ";
       
       
        $where .= " yarn_transfer.status= '1'";
$where .= " and yarn_transfer.yarn_type= '$type'";
        $where .= " and STR_TO_DATE(yarn_transfer.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(yarn_transfer.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function date_wise_swan_reports($from_date,$to_date)
	{
		$select = "select swan_yarn_transfer.*";
		
        $from   = " from swan_yarn_transfer";
        $where  = " where ";
       
       
        $where .= " swan_yarn_transfer.status= '1'";
//$where .= " and yarn_transfer.yarn_type= '$type'";
        $where .= " and STR_TO_DATE(swan_yarn_transfer.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(swan_yarn_transfer.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_consumable_reports($from_date,$to_date,$type)
	{
		$select = "select cs_transfer.*";
		
        $from   = " from cs_transfer";
        $where  = " where ";
       
       
        $where .= " cs_transfer.status= '1'";
$where .= " and cs_transfer.product_type= '$type'";
        $where .= " and STR_TO_DATE(cs_transfer.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
        $where .=" and STR_TO_DATE(cs_transfer.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function fetch_madeups_data()
{
$this->db->select('pm.id,o.oslNo,o.fileNo,o.deliveryDate,so.unit,s_m.shadeName,pm.pieceLength,so.subOrderType,so.articleNo,so.quality,so.design,so.description,sos.buyerShade,sos.quantity,so.width,sos.issue_stock,sos.consumable_stock,pm.confirm,pm.issue_status,pm.add_stock_status,f_m.*');
        $this->db->from('sub_order_shades sos');
        $this->db->join('sub_orders so', 'sos.subOrderID = so.id');
       $this->db->join('orders o', 'so.orderID = o.id');
	    $this->db->join('planned_order pm', 'sos.shadeID = pm.subNo');
		$this->db->join('shade_master s_m', 'pm.sslShade=s_m.shadeID');
		$this->db->join('fabric_madeups f_m', 'pm.id=f_m.plan_id');
$this->db->where('pm.confirm', 'No');
       $this->db->where('so.subOrderType !=', 'FABRIC');
		$this->db->where('sos.planningStatus','planned');
        $query = $this->db->get();
        return $query->result_array();
}

public function date_wise_madeups_reports($f,$t)
	{

$select = "select pm.id,o.oslNo,o.fileNo,o.deliveryDate,so.unit,s_m.shadeName,pm.pieceLength,so.subOrderType,so.articleNo,so.quality,so.design,so.description,sos.buyerShade,sos.quantity,so.width,sos.issue_stock,sos.consumable_stock,pm.confirm,pm.issue_status,pm.add_stock_status,f_m.*";
		
        $from   = " from sub_order_shades sos,sub_orders so,orders o,planned_order pm,shade_master s_m,fabric_madeups f_m";
        $where  = " where ";
        $where .= "sos.subOrderID = so.id";
		$where .= " and so.orderID = o.id";
		$where .= " and sos.subOrderID = so.id";
		$where .= " and sos.shadeID = pm.subNo";
		$where .= " and pm.sslShade=s_m.shadeID";
		$where .= " and pm.id=f_m.plan_id";
		
        $where .= " and pm.confirm = 'No'";
		 $where .= " and so.subOrderType != 'FABRIC'";
		  $where .= " and sos.planningStatus = 'planned'";
		
//$where .= " and finishing_embroidry_stock.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_madeups_reportss($f,$t)
	{

$select = "select SUM(f_m.f_issue_mtrs) as f_total,SUM(f_m.est_pcs) as est_pcs,so.subOrderType";
		
		
		
        $from   = " from sub_order_shades sos,sub_orders so,orders o,planned_order pm,shade_master s_m,fabric_madeups f_m";
        $where  = " where ";
        $where .= "sos.subOrderID = so.id";
		$where .= " and so.orderID = o.id";
		$where .= " and sos.subOrderID = so.id";
		$where .= " and sos.shadeID = pm.subNo";
		$where .= " and pm.sslShade=s_m.shadeID";
		$where .= " and pm.id=f_m.plan_id";
		
        $where .= " and pm.confirm = 'No'";
		 $where .= " and so.subOrderType != 'FABRIC'";
		  $where .= " and sos.planningStatus = 'planned'";
		
//$where .= " and finishing_embroidry_stock.consumed_at = '$loc'";
        $where .= " and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";
$where .= " GROUP BY so.subOrderType";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function date_wise_dyeing_reports($f,$t)
	{

$select = "select workorder_dyeing.work_order_no,workorder_dyeing.date,workorder_dyeing.vendor as d,work_order_dyeing.*,workorder_dyeing_material.issue_stock as issue_s,workorder_dyeing.dyed_wt as dyed_wt,workorder_dyeing_material.lot,workorder_dyeing_material.bale,workorder_dyeing_material.issue_stock,workorder_dyeing.article";
		
        $from   = " from workorder_dyeing,workorder_dyeing_material,work_order_dyeing";
        $where  = " where ";
        $where .= " workorder_dyeing.issue_no= workorder_dyeing_material.issue_no";
		$where .= " and work_order_dyeing.issue_no= workorder_dyeing.issue_no";
		
		
        $where .= " and workorder_dyeing.status = '0'";
		 $where .= " and workorder_dyeing.dyeing_status = '1'";
		 
        $where .= " and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";
$where .= " GROUP BY work_order_dyeing.issue_no";
$where .= " ORDER BY work_order_dyeing.id DESC";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}
public function get_ywisting_issue_data()
{
$this->db->select('create_materialissue_work_order.*,create_yarntwisting_work_order.*');
        $this->db->from('create_yarntwisting_work_order');
        $this->db->join('create_materialissue_work_order', 'create_yarntwisting_work_order.work_order_no= create_materialissue_work_order.work_order_no');
  
//$this->db->where('create_materialissue_work_order.status', '0');
      
        $query = $this->db->get();
        return $query->result();

}
public function date_wise_twisting_issue_reports($f,$t)
	{

$select = "select create_materialissue_work_order.*,create_yarntwisting_work_order.*";
		
        $from   = " from create_materialissue_work_order,create_yarntwisting_work_order";
        $where  = " where ";
       
		$where .= " create_yarntwisting_work_order.work_order_no= create_materialissue_work_order.work_order_no";
	
		 
        $where .= " and STR_TO_DATE(create_materialissue_work_order.date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(create_materialissue_work_order.date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	} 
public function get_ywisting_receipt_data()
{
//$this->db->select('work_order_twisting.*,create_yarntwisting_work_order.*,create_materialissue_work_order.process_type');
$this->db->select('work_order_twisting.*,create_yarntwisting_work_order.*');
        $this->db->from('create_yarntwisting_work_order');
        $this->db->join('work_order_twisting', 'create_yarntwisting_work_order.id= work_order_twisting.yarn_id');
        
       // $this->db->join('create_materialissue_work_order','create_yarntwisting_work_order.work_order=create_materialissue_work_order.work_order');
       // $this->db->group_by('create_materialissue_work_order.work_order_no');
        
//$this->db->where('create_materialissue_work_order.status', '0');
      
        $query = $this->db->get();
        return $query->result();

}
public function date_wise_twisting_receipt_reports($f,$t)
	{

$select = "select work_order_twisting.*,create_yarntwisting_work_order.*";
		
        $from   = " from work_order_twisting,create_yarntwisting_work_order";
        $where  = " where ";
       
		$where .= " create_yarntwisting_work_order.id= work_order_twisting.yarn_id";
	
		 
        $where .= " and STR_TO_DATE(work_order_twisting.received_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(work_order_twisting.received_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	} 
public function get_issue_loom_details()
{
$this->db->select('weaving_panel_planning_order.*,issue_loom.*');
        $this->db->from('weaving_panel_planning_order');
        $this->db->join('issue_loom', 'weaving_panel_planning_order.id= issue_loom.weaving_panel_id');
  
//$this->db->where('create_materialissue_work_order.status', '0');
      
        $query = $this->db->get();
        return $query->result();

}
public function date_wise_issue_to_loom_reports($f,$t)
	{

$select = "select weaving_panel_planning_order.*,issue_loom.*";
		
        $from   = " from weaving_panel_planning_order,issue_loom";
        $where  = " where ";
       
		$where .= " weaving_panel_planning_order.id= issue_loom.weaving_panel_id";
	
		 
        $where .= " and STR_TO_DATE(issue_loom.issued_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(issue_loom.issued_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	} 
public function get_packing_list_data()
{
$this->db->select('packing_list_data.*');
        $this->db->from('packing_list_data');
       
$this->db->where('packing_list_data.status', '0');
        $query = $this->db->get();
        return $query->result();

}
public function get_madeups_list_data()
{
$this->db->select('madeups_list_data.invoice as invoice_num,madeups_list_data.sys_date,madeups_list_data.report_total_value,madeups_list_data.customer_name,madeups_list_data.tot_qty,madeups_list_data.units,madeups_list_data.type,madeups_list_data.total_value,madeups_list_data.currency,madeups_list_data.country,madeups_list_data.confirm,madeups_list_data.shipped');
        $this->db->from('madeups_list_data');
      
$this->db->where('madeups_list_data.status', '0');
      
        $query = $this->db->get();
        return $query->result();

}
public function date_wise_packing_list_data($from_date,$to_date)
	{
		$select = "select packing_list_data.*";
		
        $from   = " from packing_list_data";
        $where  = " where ";
       
        $where .= " packing_list_data.status = '0'";
		
  $where .= " and packing_list_data.country != ''";
        $where .= " and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

$where .=" and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
//$where .=" GROUP BY  packing_list_data.country,packing_list_data.currency";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_madeups_list_data($from_date,$to_date)
	{
		$select = "select madeups_list_data.*";
		
        $from   = " from madeups_list_data";
        $where  = " where ";
       
        $where .= " madeups_list_data.status = '0'";
	$where .= " and madeups_list_data.country != ''";

$where .= " and STR_TO_DATE(madeups_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

$where .=" and STR_TO_DATE(madeups_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
//$where .=" GROUP BY  madeups_list_data.country,madeups_list_data.currency";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function date_wise_packing_list_data1($from_date,$to_date)
	{
		$select = "select SUM(packing_list_data.total_value) as total_value,packing_list_data.currency,packing_list_data.country,packing_list_data.customer_name,packing_list_data.tot_qty,packing_list_data.invoice_num,packing_list_data.sys_date";
		
        $from   = " from packing_list_data";
        $where  = " where ";
       
        $where .= " packing_list_data.status = '0'";

$where .= " and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

$where .=" and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY packing_list_data.currency";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_madeups_list_data1($from_date,$to_date)
	{
		$select = "select SUM(madeups_list_data.total_value) as total_value,madeups_list_data.currency,madeups_list_data.country,madeups_list_data.customer_name,madeups_list_data.tot_qty,madeups_list_data.invoice,madeups_list_data.sys_date";
		
        $from   = " from madeups_list_data";
        $where  = " where ";
       
        $where .= " madeups_list_data.status = '0'";

$where .= " and STR_TO_DATE(madeups_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

$where .=" and STR_TO_DATE(madeups_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY madeups_list_data.currency";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	} 
public function fetch_group_data($table)
	{
		$select = "select SUM(billing_report_data.total_value) as total_value,billing_report_data.currency,billing_report_data.country,billing_report_data.customer_name,billing_report_data.tot_qty,billing_report_data.invoice_no,billing_report_data.sys_date";
		
        $from   = " from billing_report_data";
        $where  = " where ";
       
        $where .= " billing_report_data.status = '0'";
		
  //$where .= " and billing_report_data.country != ''";
   //     $where .= " and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

//     $where .=" and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY  billing_report_data.country,billing_report_data.currency";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function fetch_group_data1($table)
	{
		$select = "select SUM(billing_report_data.total_value) as total_value,billing_report_data.currency,billing_report_data.country,billing_report_data.customer_name,billing_report_data.tot_qty,billing_report_data.invoice_no,billing_report_data.sys_date";
		
        $from   = " from billing_report_data";
        $where  = " where ";
       
        $where .= " billing_report_data.status = '0'";
		
 // $where .= " and billing_report_data.country != ''";
   //     $where .= " and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

//     $where .=" and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY  billing_report_data.currency";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}
public function fetch_group_data2($table)
	{
		$select = "select SUM(billing_report_data.total_value) as total_value,billing_report_data.currency,billing_report_data.country,billing_report_data.customer_name,billing_report_data.tot_qty,billing_report_data.invoice_no,billing_report_data.sys_date";
		
        $from   = " from billing_report_data";
        $where  = " where ";
       
        $where .= " billing_report_data.status = '0'";
		
  //$where .= " and billing_report_data.country != ''";
   //     $where .= " and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

//     $where .=" and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY  billing_report_data.customer_name,billing_report_data.country";
$where .=" ORDER BY  billing_report_data.total_value desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}
public function fetch_group_data3($table)
	{
		$select = "select SUM(billing_report_data.total_value) as total_value,billing_report_data.currency,billing_report_data.country,billing_report_data.customer_name,billing_report_data.tot_qty,billing_report_data.invoice_no,billing_report_data.sys_date";
		
        $from   = " from billing_report_data";
        $where  = " where ";
       
        $where .= " billing_report_data.status = '0'";
		
  //$where .= " and billing_report_data.country != ''";
   //     $where .= " and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";

//     $where .=" and STR_TO_DATE(packing_list_data.sys_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY  billing_report_data.currency";
$where .=" ORDER BY  billing_report_data.total_value desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}
public function OSL_NUMBER_getorder_reports_old() {

$this->db->select('sub_orders.id,sub_orders.articleNo,sub_orders.unit,sub_orders.width,sub_orders.subOrderType,sub_orders.description,
sub_orders.orderConfirm,sub_orders.design,sub_orders.quality,sub_orders.contractType,sub_orders.article_type,sub_orders.weave,orders.*,orders.deliveryDate as des,customer_master.customerName,customer_master.customerID,sub_order_shades.*');
    	$this->db->from('sub_orders');
    $this->db->join('orders', 'orders.id= sub_orders.orderID');
  $this->db->join('sub_order_shades', 'sub_order_shades.subOrderID= sub_orders.id');
     $this->db->join('customer_master', 'customer_master.customerID= orders.fileNo');
		$this->db->where('sub_orders.status', 0);
$this->db->order_by('orders.oslNo', "asc");
		$this->db->where('orders.status',0);
		$this->db->where('orders.orderType','DTL');
//$this->db->where('orders.confirm_status','CONFIRMED');

$query = $this->db->get();
    	return $query->result();

}	
public function OSL_NUMBER_getorder_reports() {

$this->db->select('sub_orders.id,sub_orders.articleNo,sub_orders.unit,sub_orders.width,sub_orders.subOrderType,sub_orders.description,
sub_orders.orderConfirm,sub_orders.design,sub_orders.quality,sub_orders.contractType,sub_orders.article_type,sub_orders.weave,orders.*,orders.oslNo,orders.deliveryDate as des,customer_master.customerName,customer_master.customerID,sub_order_shades.*');
    	$this->db->from('sub_orders');
		$this->db->group_by('sub_order_shades.shadeID');
		 $this->db->join('orders', 'orders.id= sub_orders.orderID');
		  $this->db->join('customer_master', 'customer_master.customerID= orders.fileNo');
		  $this->db->join('sub_order_shades', 'sub_orders.id = sub_order_shades.subOrderId');
		$this->db->join('planned_order', 'sub_order_shades.shadeID = planned_order.subNo');
		$this->db->join('shade_master', 'shade_master.shadeID = planned_order.sslShade');
		//$this->db->where('sub_orders.orderId', $subOrderID);
		$this->db->where('sub_orders.status', 0);
$this->db->order_by('orders.orderDate', "desc");
		$this->db->where('orders.status',0);
$this->db->where('sub_orders.status', 0);
$this->db->where('orders.orderType','DTL');
    	$query = $this->db->get();
    	return $query->result();

}	
public function date_wise_OSL_NUMBER_getorder_reports($f,$t) {

$this->db->select('sub_orders.id,sub_orders.articleNo,sub_orders.unit,sub_orders.width,sub_orders.subOrderType,sub_orders.description,
sub_orders.orderConfirm,sub_orders.design,sub_orders.quality,sub_orders.contractType,sub_orders.article_type,sub_orders.weave,orders.*,orders.deliveryDate as des,customer_master.customerName,customer_master.customerID,sub_order_shades.*');
    	$this->db->from('sub_orders');
		$this->db->group_by('sub_order_shades.shadeID');
	
		 $this->db->join('orders', 'orders.id= sub_orders.orderID');
		  $this->db->join('customer_master', 'customer_master.customerID= orders.fileNo');
		  $this->db->join('sub_order_shades', 'sub_orders.id = sub_order_shades.subOrderId');
		$this->db->join('planned_order', 'sub_order_shades.shadeID = planned_order.subNo');
		$this->db->join('shade_master', 'shade_master.shadeID = planned_order.sslShade');
		//$this->db->where('sub_orders.orderId', $subOrderID);
		$this->db->where('sub_orders.status', 0);
$this->db->order_by('orders.oslNo', "desc");
		$this->db->where('orders.status',0);
$this->db->where('sub_orders.status', 0);
$this->db->where('orders.orderType','DTL');

$this->db->where('orders.orderDate >=',$f);
$this->db->where('orders.orderDate <=',$t);

$query = $this->db->get();
    	return $query->result();
    }
    
    
public function fetch_total_value_res($f,$t) {
//$this->db->select('sum(sub_orders.totalValue)as totalValue,orders.currency');
       $this->db->select('sum(sub_order_shades.foreignValue)as totalValue,orders.currency');
     /*	$this->db->from('sub_orders');
        $this->db->join('orders', 'orders.id= sub_orders.orderID');
        $this->db->join('sub_order_shades', 'sub_order_shades.subOrderID= sub_orders.id');
        $this->db->join('customer_master', 'customer_master.customerID= orders.fileNo');
        $this->db->join('planned_order', 'sub_order_shades.shadeID = planned_order.subNo');
		$this->db->join('shade_master', 'shade_master.shadeID = planned_order.sslShade');
		$this->db->where('sub_orders.status', 0);
        $this->db->order_by('orders.oslNo', "desc");
		$this->db->where('orders.status',0);
		$this->db->where('orders.orderType','DTL');
        $this->db->where('orders.orderDate >=',$f);
        $this->db->where('orders.orderDate <=',$t);
        $this->db->group_by('orders.currency');

$query = $this->db->get();
    	return $query->result();*/
    	
    	$this->db->from('sub_orders');		
		 $this->db->join('orders', 'orders.id= sub_orders.orderID');
		  $this->db->join('customer_master', 'customer_master.customerID= orders.fileNo');
		  $this->db->join('sub_order_shades', 'sub_orders.id = sub_order_shades.subOrderId');
		$this->db->join('planned_order', 'sub_order_shades.shadeID = planned_order.subNo');
		$this->db->join('shade_master', 'shade_master.shadeID = planned_order.sslShade');
		//$this->db->where('sub_orders.orderId', $subOrderID);
		$this->db->where('sub_orders.status', 0);
        $this->db->order_by('orders.oslNo', "desc");
        $this->db->where('orders.status',0);
        $this->db->where('sub_orders.status', 0);
        $this->db->where('orders.orderType','DTL');
        
        $this->db->where('orders.orderDate >=',$f);
        $this->db->where('orders.orderDate <=',$t);
          $this->db->group_by('orders.currency','sub_order_shades.shadeID');
        $query = $this->db->get();
    	return $query->result();
    	
    
    }
    
public function date_wise_OSL_NUMBER_getorder_reports_OLD($f,$t) {

$this->db->where('orders.orderDate >=',$f);
$this->db->where('orders.orderDate <=',$t);
$this->db->where('orders.status',0);
$query = $this->db->get();
    	return $query->result();
    }

public function fetch_order_summary($f,$t) {

$this->db->select('sum(sub_order_shades.quantity)as totalQuantity,sub_orders.subOrderType');
    	//$this->db->select('sub_orders.*');
    	$this->db->from('sub_orders');
    $this->db->join('orders', 'orders.id= sub_orders.orderID');
  $this->db->join('sub_order_shades', 'sub_order_shades.subOrderID= sub_orders.id');
     $this->db->join('customer_master', 'customer_master.customerID= orders.fileNo');
		$this->db->where('sub_orders.status', 0);
$this->db->order_by('orders.oslNo', "desc");
		$this->db->where('orders.status',0);
		$this->db->where('orders.orderType','DTL');

$this->db->where('orders.orderDate >=',$f);
$this->db->where('orders.orderDate <=',$t);
$this->db->group_by('sub_orders.subOrderType','article_type');
$this->db->where('orders.status',0);
$query = $this->db->get();
    	return $query->result();

}

public function fetch_yarn_po_receipt_data()
	{
		$this->db->distinct();
		$this->db->select('indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade');
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
		$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
$this->db->where('indent_po.product_type','Yarn - Raw');
		//$this->db->where($where);
		$query=$this->db->get();
		return $query->result();
	}  
	public function date_wise_po_receipt_getorder_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade";
		
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Raw'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
	} 
public function date_wise_po_receipt_getorder_po_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade";
		
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Raw'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  	
	public function date_wise_po_receipt_getorder_po_reports_net_wt($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select SUM(indent_yarn_goods_details.net_weight) as net_weight";
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Raw'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row(); 
		
	}
///////////////////////////////////  10-9-2018 //////////////////////////////////////

public function date_wise_po_fabric_receipt_getorder_sum_po_reports($from_date,$to_date)
	{
		$f=date('d/m/Y',strtotime($from_date));
		$t=date('d/m/Y',strtotime($to_date));
		
		$select = "select SUM(indent_goods_details.rec_goods) as rec_goods,SUM(indent_goods_details.rec_weight) as rec_weight";
		
		
        $from   = " from indent_goods_details";
        $where  = " where ";
       // $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		// $where .= " and indent_add_indent.id = indent_po.indent_id";

$where .= " STR_TO_DATE(indent_goods_details.received_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";

$where .=" and STR_TO_DATE(indent_goods_details.received_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row(); 
		
	}

public function date_wise_po_fabric_receipt_getorder_po_reports($from_date,$to_date)
	{
		$f=date('d/m/Y',strtotime($from_date));
		$t=date('d/m/Y',strtotime($to_date));
		
		$select = "select indent_goods_details.*";
		
		
        $from   = " from indent_goods_details";
        $where  = " where ";
       // $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		// $where .= " and indent_add_indent.id = indent_po.indent_id";

$where .= " STR_TO_DATE(indent_goods_details.received_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";

$where .=" and STR_TO_DATE(indent_goods_details.received_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";
        $where .=" ORDER BY indent_goods_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function fetch_yarn_new_po_twisting_data()
	{

$this->db->distinct();
		$this->db->select('indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade');
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
		$this->db->where('indent_po.product_type','Yarn - Twisted');
		$query=$this->db->get();
		return $query->result();
	}

public function date_wise_po_receipt_getorder_po_twisting_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade";
		
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Twisted'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  	
public function date_wise_po_receipt_getorder_po_twisting_sum_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select SUM(indent_yarn_goods_details.net_weight) as net_weight";
		
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Twisted'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row(); 
		
	}  	
  
public function fetch_yarn_new_po_dyed_data()
	{

$this->db->distinct();
		$this->db->select('indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade');
		$this->db->from('indent_yarn_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_yarn_goods_details.po_list_id');
$this->db->join('indent_add_indent', 'indent_add_indent.id = indent_po.indent_id');
		$this->db->where('indent_po.product_type','Yarn - Dyed');
		$query=$this->db->get();
		return $query->result();
	}

public function date_wise_po_receipt_getorder_po_dyed_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select indent_po.*,indent_add_indent.shades as shade,indent_yarn_goods_details.tare_weight,indent_yarn_goods_details.net_weight,indent_yarn_goods_details.gross_weight,indent_yarn_goods_details.invoice,indent_yarn_goods_details.lot,indent_yarn_goods_details.bale,indent_yarn_goods_details.rec_date,indent_yarn_goods_details.mill,indent_yarn_goods_details.consumed_at,indent_yarn_goods_details.rec_by,indent_add_indent.color_code,indent_add_indent.yarn_dyed_shade";
		
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Dyed'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  	
public function date_wise_po_receipt_getorder_po_dyed_sum_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select SUM(indent_yarn_goods_details.net_weight) as net_weight";
		
		
        $from   = " from indent_po,indent_yarn_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Yarn - Dyed'";
        $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row(); 
		
	}  	
public function get_data_cs_po_fetchs()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.product_name,indent_po.quantity,indent_po.purpose,indent_po.unit,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description,indent_po.quantity_approval,indent_po.po_no,indent_po.vendor_name');
			$this->db->from('indent_cs_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_cs_goods_details.po_list_id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('indent_po.product_type ','Consumables');
			$this->db->where('indent_cs_goods_details.quantity_approval !=','Not Yet');
		$query=$this->db->get();
		return $query->result();
	}  
public function date_wise_po_receipt_getorder_po_consumables_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select indent_po.product_name,indent_po.quantity,indent_po.purpose,indent_po.unit,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description,indent_po.quantity_approval,indent_po.po_no,indent_po.vendor_name";
		
		
        $from   = " from indent_po,indent_cs_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_cs_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Consumables'";
$where .= " and indent_cs_goods_details.quantity_approval != 'Not Yet'";
        $where .= " and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  	
public function date_wise_po_receipt_getorder_po_consumables_sum_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select SUM(indent_cs_goods_details.received_quality) as received_quality";
		
		
        $from   = " from indent_po,indent_cs_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_cs_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Consumables'";
$where .= " and indent_cs_goods_details.quantity_approval != 'Not Yet'";
        $where .= " and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row(); 
		
	}

public function get_data_spares_po_fetchs()
	{
		//$this->db->distinct();
		$this->db->select('indent_po.product_name,indent_po.quantity,indent_po.purpose,indent_po.unit,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description,indent_po.quantity_approval,indent_po.po_no,indent_po.vendor_name');
			$this->db->from('indent_cs_goods_details');
		$this->db->join('indent_po', 'indent_po.id = indent_cs_goods_details.po_list_id');
	//	$this->db->join('indent_add_indent', 'indent_add_indent.indent_no = indent_po.indent_no');
		
		$this->db->where('indent_po.product_type ','Spares');
			$this->db->where('indent_cs_goods_details.quantity_approval !=','Not Yet');
		$query=$this->db->get();
		return $query->result();
	}  
public function date_wise_po_receipt_getorder_po_spares_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select indent_po.product_name,indent_po.quantity,indent_po.purpose,indent_po.unit,indent_cs_goods_details.rec_by,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_quality,indent_cs_goods_details.invoice,indent_cs_goods_details.rec_date,indent_po.product_type,indent_po.description,indent_po.quantity_approval,indent_po.po_no,indent_po.vendor_name";
		
		
        $from   = " from indent_po,indent_cs_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_cs_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Spares'";
$where .= " and indent_cs_goods_details.quantity_approval != 'Not Yet'";
        $where .= " and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  	
public function date_wise_po_receipt_getorder_po_spares_sum_reports($from_date,$to_date)
	{
		$f=date('d-m-Y',strtotime($from_date));
		$t=date('d-m-Y',strtotime($to_date));
		
		$select = "select SUM(indent_cs_goods_details.received_quality) as received_quality";
		
		
        $from   = " from indent_po,indent_cs_goods_details,indent_add_indent";
        $where  = " where ";
        $where .= " indent_po.id = indent_cs_goods_details.po_list_id";
		 $where .= " and indent_add_indent.id = indent_po.indent_id";
$where .= " and indent_po.product_type = 'Spares'";
$where .= " and indent_cs_goods_details.quantity_approval != 'Not Yet'";
        $where .= " and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

$where .=" and STR_TO_DATE(indent_cs_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->row(); 
		
	}
/////////////////  16-11-2018 /////////////
public function display_po_reports_xsls_loc_grid_embroidryinspection_data()
	{

$this->db->select("*");
$this->db->group_by('po_id');
		$this->db->from('indent_po');
		
		$query = $this->db->get();
		return $query->result();

}  
public function display_po_reports_xsls_loc_grid_embroidryinspection_data_group()
	{
$this->db->select('SUM(indent_po.grand_total) as g_total,indent_po.currency');
$this->db->group_by('currency');
		$this->db->from('indent_po');
		
		$query = $this->db->get();
		return $query->result();

}
///////////////////////////////////////

public function date_wise_madeups_fetch_reports()
	{

$select = "select pm.id,o.oslNo,o.deliveryDate,so.unit,s_m.shadeName,pm.pieceLength,so.subOrderType,so.articleNo,so.quality,so.design,so.description,sos.buyerShade,sos.quantity,so.width,sos.issue_stock,sos.consumable_stock,pm.confirm,pm.issue_status,pm.add_stock_status,f_m.*";
		
        $from   = " from sub_order_shades sos,sub_orders so,orders o,planned_order pm,shade_master s_m,fabric_madeups f_m";
        $where  = " where ";
        $where .= "sos.subOrderID = so.id";
		$where .= " and so.orderID = o.id";
		$where .= " and sos.subOrderID = so.id";
		$where .= " and sos.shadeID = pm.subNo";
		$where .= " and pm.sslShade=s_m.shadeID";
		$where .= " and pm.id=f_m.plan_id";
		
        $where .= " and pm.confirm = 'No'";
		 $where .= " and so.subOrderType != 'FABRIC'";
		  $where .= " and sos.planningStatus = 'planned'";
		
//$where .= " and finishing_embroidry_stock.consumed_at = '$loc'";
        //$where .= " and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

// $where .=" and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function date_wise_madeups_fetch_reportss()
	{

$select = "select SUM(f_m.f_issue_mtrs) as f_total,SUM(f_m.est_pcs) as est_pcs,so.subOrderType";
		
		
		
        $from   = " from sub_order_shades sos,sub_orders so,orders o,planned_order pm,shade_master s_m,fabric_madeups f_m";
        $where  = " where ";
        $where .= "sos.subOrderID = so.id";
		$where .= " and so.orderID = o.id";
		$where .= " and sos.subOrderID = so.id";
		$where .= " and sos.shadeID = pm.subNo";
		$where .= " and pm.sslShade=s_m.shadeID";
		$where .= " and pm.id=f_m.plan_id";
		
        $where .= " and pm.confirm = 'No'";
		 $where .= " and so.subOrderType != 'FABRIC'";
		  $where .= " and sos.planningStatus = 'planned'";
		
//$where .= " and finishing_embroidry_stock.consumed_at = '$loc'";
     //   $where .= " and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')>=STR_TO_DATE('$f','%d-%m-%Y')";

//  $where .=" and STR_TO_DATE(f_m.issue_date,'%d-%m-%Y')<=STR_TO_DATE('$t','%d-%m-%Y')";
$where .= " GROUP BY so.subOrderType";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}       
///////////////////////////////////////////////////////////////  16-11-2018 afternoon //////////////////////////////////////////////////
public function display_fabric_reports_loc_grid_embroidryinspections($loc)
	{
		$select = "select fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id";
		
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

$where .= " and fabric_inspection_details.status = '0'";
		$where .= " and fabric_inspection.balanced_mtrs != '0.00'";
		$where .= " and fabric_inspection.balanced_mtrs > '0'";
$where .= " and fabric_inspection_details.consumed_at = '$loc'";
$where .=" GROUP BY fabric_inspection_details.id";
       // $where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
       // $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$where .=" ORDER BY fabric_inspection_details.id desc";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_fabric_reports_loc_grid_embroidryinspectionns($loc)
	{

//$where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d/%m/%Y')>=STR_TO_DATE('$f','%d/%m/%Y')";
       // $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d/%m/%Y')<=STR_TO_DATE('$t','%d/%m/%Y')";
$where .=" GROUP BY fabric_inspection_details.id";
		$where .=" ORDER BY fabric_inspection_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_fabric_reports_loc_grid_embroidryinspections_data($loc)
	{
		$select = "select fabric_inspection_details.splited_piece_no,fabric_inspection_details.received_date,fabric_inspection_details.id,fabric_inspection_details.vendor_name,fabric_inspection_details.consumed_at,fabric_inspection_details.piece_no,fabric_inspection_details.po_no,fabric_inspection_details.product_name,fabric_inspection_details.width,fabric_inspection_details.shades,fabric_inspection_details.rec_goods,fabric_inspection_details.rec_weight,fabric_inspection.inspected_mtrs,fabric_inspection.rejected_mtrs,fabric_inspection.ssl_pc_no,fabric_inspection.quantity,fabric_inspection_details.bal_goods,fabric_inspection_details.remainning_quantity,fabric_inspection_details.available_quantity,fabric_inspection.variance_mtrs,fabric_inspection.balanced_mtrs,fabric_inspection_details.design,fabric_inspection_details.customer_id";
		
        $from   = " from fabric_inspection,fabric_inspection_details";
        $where  = " where ";
        $where .= "fabric_inspection.goods_id = fabric_inspection_details.id";

//  $where .= " and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
       // $where .=" and STR_TO_DATE(fabric_inspection_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY fabric_inspection_details.id";
		$where .=" ORDER BY fabric_inspection_details.id desc";
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_fabric_reports_loc_grid_embroidryinspectionns_data($loc)
	{

public function display_raw_reports_loc_grid_embroidryinspections($loc,$type)
	{
		$select = "select indent_po.*,indent_yarn_goods_details.*";
		
        $from   = " from indent_po,indent_yarn_goods_details";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_yarn_goods_details.issue_net_weight > '0'";
		$where .= " and indent_yarn_goods_details.issue_gross_weight != '0'";
$where .= " and indent_yarn_goods_details.consumed_at = '$loc'";
      //  $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
       // $where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_raw_reports_loc_grid_embroidryinspections_data($loc,$type)
	{
		$select = "select indent_po.*,indent_yarn_goods_details.*";
		
        $from   = " from indent_po,indent_yarn_goods_details";
        $where  = " where ";
        $where .= " indent_po.id = indent_yarn_goods_details.po_list_id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_yarn_goods_details.issue_net_weight > '0'";
		$where .= " and indent_yarn_goods_details.issue_gross_weight != '0'";
//$where .= " and indent_yarn_goods_details.consumed_at = '$loc'";
      //  $where .= " and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
       // $where .=" and STR_TO_DATE(indent_yarn_goods_details.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_twist_reports_loc_grid_embroidryinspections_data($loc,$type)
	{
		$select = "select delivery_yarn_twisting.*";
		
        $from   = " from delivery_yarn_twisting";
        $where  = " where ";
      
        $where .= " delivery_yarn_twisting.status = '1'";
		
//$where .= " and delivery_yarn_twisting.consumed_at = '$loc'";
        //$where .= " and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
      //  $where .=" and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
	public function display_twist_reports_loc_grid_embroidryinspections($loc,$type)
	{
		$select = "select delivery_yarn_twisting.*";
		
        $from   = " from delivery_yarn_twisting";
        $where  = " where ";
      
        $where .= " delivery_yarn_twisting.status = '1'";
		
$where .= " and delivery_yarn_twisting.consumed_at = '$loc'";
        //$where .= " and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
       // $where .=" and STR_TO_DATE(delivery_yarn_twisting.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}

public function display_swan_reports_loc_grid_embroidryinspections_data($loc,$type)
	{
	/*	$select = "select work_order_dyeing.*,workorder_dyeing.work_order_no";
		
        $from   = " from work_order_dyeing,workorder_dyeing";
        $where  = " where ";
        $where .= " work_order_dyeing.dyed_id = workorder_dyeing.id";
        $where .= " work_order_dyeing.status = 'COMPLETED'";
		 $where .= " and work_order_dyeing.yarn_status = '0'";
		 $where .= " and work_order_dyeing.rec_dyed_qua > '0'";
//$where .= " and work_order_dyeing.location = '$loc'";
        //$where .= " and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
      //  $where .=" and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); */
		
// 		$this->db->select('A.*,B.work_order_no');
//     	$this->db->from('work_order_dyeing A');
//     	$this->db->join('workorder_dyeing B', 'A.dyed_id=B.id','left');
//     	$this->db->where('A.status', 'COMPLETED');
//     	$this->db->where('A.yarn_status', '0');
//     	$this->db->where('A.rec_dyed_qua', '0');
//     	$query = $this->db->get();
//     	return $query->result();

$select = "select work_order_dyeing.*,workorder_dyeing.work_order_no,(work_order_dyeing.updated_unit*work_order_dyeing.rec_dyed_qua) as val";
		
        $from   = " from work_order_dyeing JOIN workorder_dyeing on work_order_dyeing.dyed_id = workorder_dyeing.id";
        $where  = " where ";
      
        $where .= " work_order_dyeing.status = 'COMPLETED'";
		 $where .= " and work_order_dyeing.yarn_status = '0'";
		 $where .= " and work_order_dyeing.rec_dyed_qua > '0'";
		 
		     //$where .= " and work_order_dyeing.location = '$loc'";

// $where .= " and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
 
      //  $where .=" and STR_TO_DATE(work_order_dyeing.rec_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";

$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	
	
	}  
public function display_swan_reports_loc_grid_embroidryinspections($loc,$type)
	{
		$select = "select work_order_dyeing.*,workorder_dyeing.work_order_no";
		
        $from   = " from work_order_dyeing JOIN workorder_dyeing on work_order_dyeing.dyed_id = workorder_dyeing.id";
        $where  = " where ";
      
        $where .= " work_order_dyeing.status = 'COMPLETED'";
		 $where .= " and work_order_dyeing.yarn_status = '0'";
		 $where .= " and work_order_dyeing.rec_dyed_qua > '0'";
		 
		     $where .= " and work_order_dyeing.location = '$loc'";

//	$where .=" DISTINCT indent_cs_goods_details.po_id";
		
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}
public function display_consumable_reports_loc_grid_embroidryinspections($loc,$type)
	{
		$select = "select indent_po.*,indent_cs_goods_details.consumed_at,indent_cs_goods_details.received_date";
		
        $from   = " from indent_po,indent_cs_goods_details";
        $where  = " where ";
        $where .= "indent_cs_goods_details.po_list_id = indent_po.id";

$where .= " and indent_po.product_type = '$type'";
		$where .= " and indent_po.confirm= 'Yes'";
		$where .= " and indent_po.total_quantity != '0.00'";
$where .= " and indent_cs_goods_details.consumed_at = '$loc'";
      //  $where .= " and STR_TO_DATE(indent_cs_goods_details.received_date,'%d/%m/%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
 //$where .= " or STR_TO_DATE(indent_cs_goods_details.received_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
    //    $where .=" and STR_TO_DATE(indent_cs_goods_details.received_date,'%d/%m/%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
//$where .=" or STR_TO_DATE(indent_cs_goods_details.received_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
	//	$where .=" DISTINCT indent_cs_goods_details.po_id";
		
        $sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_madeups_reports_loc_grid_embroidryinspections_data($loc)
	{
		$select = "select fabric_madeups_delivery_confirmation.*";
		
        $from   = " from fabric_madeups_delivery_confirmation";
        $where  = " where ";
      
        $where .= " fabric_madeups_delivery_confirmation.received_qty > '0'";
	//$where .= " and fabric_madeups_delivery_confirmation.location = '$loc'";
        //$where .= " and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
      // $where .=" and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
public function display_madeups_reports_loc_grid_embroidryinspections($loc)
	{
		$select = "select fabric_madeups_delivery_confirmation.*";
		
        $from   = " from fabric_madeups_delivery_confirmation";
        $where  = " where ";
      
        $where .= " fabric_madeups_delivery_confirmation.received_qty > '0'";
	$where .= " and fabric_madeups_delivery_confirmation.location = '$loc'";
       // $where .= " and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')>=STR_TO_DATE('$from_date','%d/%m/%Y')";
       //$where .=" and STR_TO_DATE(fabric_madeups_delivery_confirmation.rec_date,'%d/%m/%Y')<=STR_TO_DATE('$to_date','%d/%m/%Y')";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	}  
////////////////////////////////////////  23-11-2018  ////////////////////////////////////////

public function get_stock_transfer_loca_raw_data_pc($val)
	{
		$this->db->select('*');
		$this->db->from('indent_po');
		$this->db->join('indent_yarn_goods_details', 'indent_po.id = indent_yarn_goods_details.po_list_id');
//$this->db->join('yarn_transfer', 'yarn_transfer.refrence_id= indent_yarn_goods_details.id');
		
	$this->db->where('indent_yarn_goods_details.id',$val);
		$query=$this->db->get();
		return $query->row();
	}
public function get_stock_transfer_loca_swan_data_pc($val)
	{
		$this->db->select('*');
		$this->db->from('work_order_dyeing');
		//$this->db->join('work_order_dyeing', 'swan_yarn_transfer.id = work_order_dyeing.id');
$this->db->where('work_order_dyeing.id',$val);
		$query=$this->db->get();
		return $query->row();
	}
	
	public function max_select_ids_transfer_no($table)
    {
    	$this->db->select_max('id');
    	$this->db->from($table);
    	$query = $this->db->get();
    	return $query->row();
    }	
    	public function max_years_select_sl_pc_no($table,$where)
    {
    	$this->db->select_max('sl_ssl_pc_no');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
    public function get_data_new_customer_group($table)
	{
		$this->db->select("*");
$this->db->group_by(array('financ_year','po_id'));
		$this->db->from('indent_po');
		
		$query = $this->db->get();
		return $query->result();
	}
	public function display_po_new_reports_loc_grid_embroidryinspection_data($from_date,$to_date)
	{
		$select = "select indent_po.*";
		
        $from   = " from indent_po";
        $where  = " where ";
      
        $where .= " STR_TO_DATE(indent_po.created_date,'%d-%m-%Y')>=STR_TO_DATE('$from_date','%d-%m-%Y')";
       $where .=" and STR_TO_DATE(indent_po.created_date,'%d-%m-%Y')<=STR_TO_DATE('$to_date','%d-%m-%Y')";
$where .=" GROUP BY indent_po.financ_year,indent_po.po_id";
	$sql    = $select.$from.$where;
        $result = $this->db->query($sql);
		return $result->result(); 
		
	} 
	
	public function madeup_report()
	{
	 	$this->db->distinct();
		$this->db->select('*');
		$this->db->from('madeups_list_data');
		$this->db->join('madeups_packing', 'madeups_list_data.id = madeups_packing.madeups_id');
		$this->db->where('madeups_packing.status',0);
		$query=$this->db->get();
		return $query->result();   
	}
	
	public function fabric_report()
	{
	 	$this->db->distinct();
		$this->db->select('packing_list_data.*,package_packing.*,packing_list_data.customer_name name');
		$this->db->from('packing_list_data');
		$this->db->join('package_packing', 'packing_list_data.invoice = package_packing.invoice');
		$this->db->where('packing_list_data.financ_year = package_packing.financ_year');
		$query=$this->db->get();
		return $query->result();   
	}
	
	public function fabric_report_new($from_date,$to)
	{
		$select = "select A.*,B.width,B.buyer_shades,B.ssl_pc_no,B.exp_qty,B.article,B.shades,B.order_type,B.po_no,B.pack_id,B.design";
        $from   = " from packing_list_data A JOIN  package_packing B ON B.invoice_num=A.invoice_num";
        $where  = " where ";
       	$where .= " A.financ_year = B.financ_year";
        if(!empty($from_date))
        {
        	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$from_date','%d-%m-%Y')";
    	} else
    	{
    	    $d=01;
    	    date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
            $month =date('m');
            $year=date('Y');
            $froms=$d.'-'.$month.'-'.$year;
            	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$froms','%d-%m-%Y')";
    	}
    	if(!empty($to))
    	{
        	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') <= STR_TO_DATE('$to','%d-%m-%Y')";
    	}
    	
    	
        $where .= "  order by STR_TO_DATE(A.sys_date,'%d-%m-%Y') DESC";
        $sql    = $select.$from.$where;
       	$this->db->query($sql);
        $result = $this->db->query($sql);
        $data= $result->result();

$final_array=array();
		if(!empty($data))
		{
			foreach ($data as $key => $value) 
			{

$this->db->select('S.*');
				$this->db->from('invoice_packing S');
				$this->db->where('S.invoice_num',$value->invoice_num);
				$this->db->where('S.design',$value->design);
				$this->db->where('S.article',$value->article);
				$this->db->where('S.width',$value->width);
				$this->db->where('S.shades',$value->shades);
				//$this->db->group_by(array('S.shades'));
				$query=$this->db->get();
				$dats= $query->result();
				
				$hsn_code=array();
				$unitprice=array();
				$contarct_type=array();

if(!empty($dats))
				{
					foreach($dats as $vals)
					{
						if(!empty($vals->hsn_code))
						{
							array_push($hsn_code,$vals->hsn_code);
							
						}
						else
						{
							//unset($hsn_code);
						}
						if(!empty($vals->unitprice))
						{
							
							array_push($unitprice,$vals->unitprice);
						}
						else
						{
							//unset($hsn_code);
						}
						if(!empty($vals->contarct_type))
						{
							
							array_push($contarct_type,$vals->contarct_type);
						}
						else
						{
							//unset($hsn_code);
						}
					}
					
				}
				else
					{
						unset($hsn_code);
							$hsn_code=array();
							unset($unitprice);
							$unitprice=array();

unset($contarct_type);
							$contarct_type=array();

}

$this->db->select('X.*');
				$this->db->from('invoice_packing X');
				$this->db->where('X.pack_id',$value->pack_id);
				$this->db->where('X.design',$value->design);
				$this->db->where('X.article',$value->article);
				$this->db->where('X.width',$value->width);
				$this->db->where('X.shades',$value->shades);
				$query=$this->db->get();
				$datsd= $query->result();
				
				$ordertype=array();
				
				if(!empty($datsd))
				{
					foreach($datsd as $vals)
					{
						if(!empty($vals->ordertype))
						{
							array_push($ordertype,$vals->ordertype);
						}
						else
						{

}
					}

}else
				{
					unset($ordertype);
							$ordertype=array();
				}

$total_value=array();
				if(!empty($datsd))
				{
					foreach($datsd as $vals)
					{
						if(!empty($vals->values_es))
						{
							array_push($total_value,$vals->values_es);
						}
						else
						{

}
					}

}else
				{
					unset($total_value);
							$total_value=array();
				}

$this->db->select('Y.*,Z.description');
				$this->db->from('orders Y');
				$this->db->join('sub_orders Z', 'Z.orderID = Y.id');
				$this->db->join('sub_order_shades K', 'K.subOrderID = Z.id');
				$this->db->where('Y.oslNo',$value->po_no);
				$this->db->where('K.buyerShade',$value->buyer_shades);
				$this->db->where('Z.design',$value->design);
				$this->db->where('Z.articleNo',$value->article);
				$query=$this->db->get();
				$datsds= $query->result();
				$description=array();
				$customer_order=array();
				
				if(!empty($datsds))
				{

foreach($datsds as $vals)
					{
						if(!empty($vals->orderNo))
						{
							
							array_push($customer_order,$vals->orderNo);

}
						else
						{
							//array_push($hsn_code,"");
						}
						if(!empty($vals->description))
						{
							array_push($description,$vals->description);

}
						else
						{
							//array_push($hsn_code,"");
						}
					}
					
				}else
					{
						unset($description);
							$description=array();

}

$datav['id']=$value->id;
				$datav['invoice']=$value->invoice;
				$datav['invoice_num']=$value->invoice_num;
				$datav['financ_year']=$value->financ_year;
				$datav['sys_date']=$value->sys_date;
				$datav['customer_name']=$value->customer_name;
				$datav['customerID']=$value->customerID;
				$datav['order_date']=$value->order_date;
				$datav['order_no']=$customer_order;
				$datav['delivery_date']=$value->delivery_date;
				$datav['units']=$value->units;
				$datav['confirm']=$value->confirm;
				$datav['shipped']=$value->shipped;
				$datav['shipping_bill_date']=$value->shipping_bill_date;
				$datav['shipping_bill_num']=$value->shipping_bill_num;
				$datav['shipping_port_code']=$value->shipping_port_code;
				$datav['hsn_code']=$hsn_code;
				$datav['width']=$value->width;
				$datav['article']=$value->article;
				$datav['shades']=$value->shades;
				$datav['buyer_shades']=$value->buyer_shades;
				$datav['ssl_pc_no']=$value->ssl_pc_no;
				$datav['exp_qty']=$value->exp_qty;
				$datav['units']=$value->units;
				$datav['type']=$unitprice;
				$datav['total_value']=$total_value;
				$datav['currency']=$value->currency;
				$datav['country']=$value->country;
				$datav['contarct_type']=$contarct_type;
				$datav['payment']=$value->payment;
				if(!empty($description)){
					$datav['description']=$description;
				}else{
					$datav['description']=$value->description;
				}
				
				$datav['order_type']=$ordertype;
				
				array_push($final_array,$datav);
				unset($hsn_code);
				unset($customer_order);
				
				//unset($hsn_code);
			}
		}
	
		return $final_array;
	}
	
	
public function madeups_report_new($from_date,$to)
	{
		$select = "select A.*,B.shades,B.osl_no,B.exp_qty,B.article,B.order_type,B.orderNo,C.customerID,B.design,B.	batch_no,B.ssl_shade,B.size,B.description";
        $from   = " from madeups_list_data A JOIN  madeups_packing B ON B.invoice=A.invoice and A.financ_year = B.financ_year JOIN customer_master C ON A.customer_name=C.customerName";
        $where  = " where ";
        $where .= " A.financ_year = B.financ_year";
        if(!empty($from_date)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$from_date','%d-%m-%Y')";
    	}else
    	{
    	    $d=01;
    	    date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
            $month =date('m');
            $year=date('Y');
            $froms=$d.'-'.$month.'-'.$year;
            	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$froms','%d-%m-%Y')";
    	}
    	if(!empty($to)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') <= STR_TO_DATE('$to','%d-%m-%Y')";
    	}
    	
    	
         $where .= " order by STR_TO_DATE(A.sys_date,'%d-%m-%Y') DESC";
        $sql    = $select.$from.$where;
       	$this->db->query($sql);
        $result = $this->db->query($sql);
        $data= $result->result(); 
       
		$final_array=array();
		if(!empty($data))
		{
			foreach ($data as $key => $value) 
			{

$this->db->select('S.*');
				$this->db->from('madeups_invoice_packing S');
				$this->db->where('S.invoice',$value->invoice);
				
				$this->db->where('S.design',$value->design);
				$this->db->where('S.article',$value->article);
				$this->db->where('S.batch_no',$value->batch_no);
				$this->db->where('S.ssl_shades',$value->ssl_shade);
				$query=$this->db->get();
				$dats= $query->result();
				
				
				$hsn_code=array();
				$buyershade=array();
				$contarct_type=array();
				$unitprice=array();

if(!empty($dats))
				{
					foreach($dats as $vals)
					{
						if(!empty($vals->hsn_code))
						{
							array_push($hsn_code,$vals->hsn_code);
						}
						else
						{
							//array_push($hsn_code,"");
						}
						if(!empty($vals->buyershade))
						{
							array_push($buyershade,$vals->buyershade);
						}
						else
						{
							//array_push($hsn_code,"");
						}
						
						if(!empty($vals->unitprice))
						{
							
							array_push($unitprice,$vals->unitprice);
						}
						else
						{
							//unset($hsn_code);
						}
					}
					
				}else
				{

unset($buyershade);
				unset($hsn_code);
				$hsn_code=array();
				$buyershade=array();
				
				unset($unitprice);
				$unitprice=array();
				}
				if(!empty($dats))
				{
					foreach($dats as $vals)
					{
						
						if(!empty($vals->contarct_type))
						{
							
							array_push($contarct_type,$vals->contarct_type);
						}
						else
						{
							//unset($hsn_code);
						}
						
					}
					
				}else
				{

unset($contarct_type);
				$contarct_type=array();
				
				}
				
				$datav['id']=$value->id;
				$datav['invoice']=$value->invoice;
				$datav['invoice_num']=$value->invoice_num;
				$datav['financ_year']=$value->financ_year;
				$datav['sys_date']=$value->sys_date;
				$datav['customer_name']=$value->customer_name;
				$datav['customerID']=$value->customerID;
				$datav['confirm']=$value->confirm;
		
				$datav['unitprice']=$unitprice;
				$datav['shipped']=$value->shipped;
				$datav['payment']=$value->payment;
				$datav['shipping_bill_date']=$value->shipping_bill_date;
				$datav['shipping_bill_num']=$value->shipping_bill_num;
				$datav['shipping_port_code']=$value->shipping_port_code;
				$datav['hsn_code']=$hsn_code;
				
				$datav['article']=$value->article;
				$datav['shades']=$value->ssl_shade;
				$datav['buyer_shades']=$buyershade;
				$datav['ssl_pc_no']=$value->osl_no;
				$datav['exp_qty']=$value->exp_qty;
				$datav['batch_no']=$value->batch_no;
				$datav['contarct_type']=$contarct_type;
				$datav['size']=$value->size;
				$datav['type']=$value->type;
				$datav['total_value']=$value->total_value;
				$datav['currency']=$value->currency;
				$datav['country']=$value->country;
				$datav['order_no']=$value->orderNo;
				$datav['description']=$value->description;
				$datav['order_type']=$value->order_type;
				
				array_push($final_array,$datav);
				unset($hsn_code);
			}
		}
	
		return $final_array;
	}
	
	
	public function get_packing_list_data_new($from_date,$to)
{

$select = "select A.*,B.currency as new_currency";
        $from   = " from packing_list_data A LEFT JOIN  invoice_packing B ON B.invoice_num=A.invoice_num";
        $where  = " where ";
        $where .= " A.status = 0";
        if(!empty($from_date)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$from_date','%d-%m-%Y')";
    	}else
    	{
    	    $d=01;
    	    date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
            $month =date('m');
            $year=date('Y');
            $froms=$d.'-'.$month.'-'.$year;
            	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$froms','%d-%m-%Y')";
    	}
    	if(!empty($to)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') <= STR_TO_DATE('$to','%d-%m-%Y')";
    	}
    	
    	
        $where .= " group by A.id order by STR_TO_DATE(A.sys_date,'%d-%m-%Y') DESC ";
        $sql    = $select.$from.$where;
       	$this->db->query($sql);
        $result = $this->db->query($sql);
        return $data= $result->result();

}
public function get_madeups_list_data_new($from_date,$to)
{
	$select = "select A.total_value, A.invoice as invoice_num,A.sys_date,A.report_total_value,A.customer_name,A.tot_qty,A.units,A.type,A.total_value,A.country,A.confirm,A.shipped,A.shipping_currency,A.shipping_customs_ex_rate,A.shipping_customs_inr_val,A.shipping_bill_date,A.shipping_bill_num,A.shipping_port_code,A.payment_approved_by,A.	payment_currency,A.payment_amount_received,A.payment_bank_charged,A.payment_bank_realisation_rate,A.payment_inr_value,A.	payment_remark,A.payment_received_date,A.bank_reference,A.discount,A.other_charges,A.payment,B.currency as new_currency,A.all_stock_qty,A.total_invoice";
        $from   = " from madeups_list_data A  LEFT JOIN  madeups_invoice_packing B ON B.invoice=A.invoice";
        $where  = " where ";
        $where .= " A.status = 0";
        if(!empty($from_date)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$from_date','%d-%m-%Y')";
    	}else
    	{
    	    $d=01;
    	    date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
            $month =date('m');
            $year=date('Y');
            $froms=$d.'-'.$month.'-'.$year;
            	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$froms','%d-%m-%Y')";
    	}
    	if(!empty($to)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') <= STR_TO_DATE('$to','%d-%m-%Y')";
    	}
    	
    	
        $where .= " group by A.id order by STR_TO_DATE(A.sys_date,'%d-%m-%Y') DESC";
        $sql    = $select.$from.$where;
       	$this->db->query($sql);
        $result = $this->db->query($sql);
        return $data= $result->result();

}

public function get_packing_list_data_hsn($from_date,$to)
{

$select = "select A.*,B.currency as new_currency,B.	design,B.article,B.width,B.shades,B.stock_wt,B.unitprice,B.contarct_type,B.hsn_code,A.approved_by,B.values_es";
        $from   = " from invoice_packing B LEFT JOIN packing_list_data A  ON B.invoice_num=A.invoice_num";
        $where  = " where ";
        $where .= " A.status = 0 and B.hsn_code!=''";
        if(!empty($from_date)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$from_date','%d-%m-%Y')";
    	}else
    	{
    	    $d=01;
    	    date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
            $month =date('m');
            $year=date('Y');
            $froms=$d.'-'.$month.'-'.$year;
            	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$froms','%d-%m-%Y')";
    	}
    	if(!empty($to)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') <= STR_TO_DATE('$to','%d-%m-%Y')";
    	}
    	
    	
        $where .= "order by STR_TO_DATE(A.sys_date,'%d-%m-%Y') DESC ";
        $sql    = $select.$from.$where;
        
       	$this->db->query($sql);
        $result = $this->db->query($sql);
        return $data= $result->result();

}
public function get_madeups_list_data_hsn($from_date,$to)
{
	$select = "select A.invoice as invoice_num,A.sys_date,A.report_total_value,A.customer_name,A.tot_qty,A.units,A.type,A.total_value,A.country,A.confirm,A.shipped,A.shipping_currency,A.shipping_customs_ex_rate,A.shipping_customs_inr_val,A.shipping_bill_date,A.shipping_bill_num,A.shipping_port_code,A.payment_approved_by,A.	payment_currency,A.payment_amount_received,A.payment_bank_charged,A.payment_bank_realisation_rate,A.payment_inr_value,A.	payment_remark,A.payment_received_date,A.bank_reference,A.discount,A.other_charges,A.payment,B.currency as new_currency,A.all_stock_qty,A.total_invoice,B.	design,B.article,B.width,B.ssl_shades as shades,B.stock_wt,B.unitprice,B.contarct_type,B.hsn_code,A.approved_by,B.values_es";
        $from   = " from  madeups_invoice_packing B LEFT JOIN  madeups_list_data A ON B.invoice=A.invoice";
        $where  = " where ";
        $where .= " A.status = 0 and B.hsn_code!=''";
        if(!empty($from_date)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$from_date','%d-%m-%Y')";
    	}else
    	{
    	    $d=01;
    	    date_default_timezone_set("Asia/Kolkata");   //India time (GMT+5:30)
            $month =date('m');
            $year=date('Y');
            $froms=$d.'-'.$month.'-'.$year;
            	$where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') >= STR_TO_DATE('$froms','%d-%m-%Y')";
    	}
    	if(!empty($to)){
        $where .= " and STR_TO_DATE(A.sys_date,'%d-%m-%Y') <= STR_TO_DATE('$to','%d-%m-%Y')";
    	}
    	
    	
        $where .= " group by A.id order by STR_TO_DATE(A.sys_date,'%d-%m-%Y') DESC";
        $sql    = $select.$from.$where;
       	$this->db->query($sql);
        $result = $this->db->query($sql);
        return $data= $result->result();

}