EVOLUTION-NINJA

Edit File: Planning_shade.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Planning_shade extends CI_Model 
{
	public function __construct()
    {
        parent::__construct();
    }
	//insert planning yarn here
	public function planning_shade_insert($quality_data)
	{
		$qualityinsert=$this->db->insert('shade_master',$quality_data);
		$lastinsertid=$this->db->insert_id();
		$type=$this->input->post('shadetype');
		
		/*if($type=="Plain")
		{	
			for ($i = 0; $i < count($this->input->post('warpcolor1')); $i++) {
				if($this->input->post('warpcolor1')!='' && $this->input->post('warpcode1')!='')
				{
					$shade_warp = array( 
					'shadeID' => $lastinsertid,
					'warpColor' => $this->input->post('warpcolor1')[$i],
					'warpCode' => $this->input->post('warpcode1')[$i],
					
					
					);
					$this->db->insert('sm_warp',$shade_warp);
				}
			}
			
			for ($i = 0; $i < count($this->input->post('weftcolor1')); $i++) {
				if($this->input->post('weftcolor1')!='' && $this->input->post('weftcode1')!='')
				{
					$shade_weft = array( 
						'shadeID' => $lastinsertid,
						'weftColor' => $this->input->post('weftcolor1')[$i],
						'weftCode' => $this->input->post('weftcode1')[$i],
						
						
					);
				
					$this->db->insert('sm_weft',$shade_weft);
				}
			}
		}
		else
		{*/
			for ($i = 0; $i < count($this->input->post('warpcolor')); $i++) {
				if($this->input->post('warpcolor')!='' && $this->input->post('warpcode')!='')
				{
					$shade_warp = array( 
					'shadeID' => $lastinsertid,
					'warpColor' => $this->input->post('warpcolor')[$i],
					'warpCode' => $this->input->post('warpcode')[$i],
					
					
					);
					$this->db->insert('sm_warp',$shade_warp);
				}
			}
			
			for ($i = 0; $i < count($this->input->post('weftcolor')); $i++) {
				if($this->input->post('weftcolor')!='' && $this->input->post('weftcode')!='')
				{
					$shade_weft = array( 
						'shadeID' => $lastinsertid,
						'weftColor' => $this->input->post('weftcolor')[$i],
						'weftCode' => $this->input->post('weftcode')[$i],
						
						
					);
				
					$this->db->insert('sm_weft',$shade_weft);
				}
			}
		/*}*/
		
		if($qualityinsert) { return true; } else { return false; }
	}
	public function color_insert($color_data)
	{
		$qualityinsert=$this->db->insert('color_master',$color_data);
		if($qualityinsert) { return true; } else { return false; }
	}
	//checking where specification is exists or not
	public function check_spec_exists()
	{
		$query = $this->db->get('planning_shade');
		if ($query->num_rows() > 0)
		{
		return $query->result();
		}
		else { return false; }
	}
	//display yarn quality data here
	public function display_yarnqty_data()
	{
		$query=$this->db->get('shade_master');
		return $query->result();
	}
	
	public function fabricdetails()
	{
		$query=$this->db->get('fabric_master');
		return $query->result();
	}
	
	public function display_article_data()
	{
		$this->db->order_by("articleNo", "asc");
		$query=$this->db->get('article_master');
		return $query->result();
	}
	public function planning_outsource_order_insert($paln_data,$name,$shadeID)
	{
	   
	
			$updateData = array(
				'planningStatus' => 'planned',
					'planned_by' => $name
			);

$this->db->where('shadeID', $shadeID);
		$planinsert=	$this->db->update('sub_order_shades', $updateData);
	
		$planinsert=$this->db->insert('planned_order',$paln_data);
		$lastinsertid=$this->db->insert_id();
		
		
		//for ($i = 0; $i < count($paln_data->PlndMtr); $i++) {
			if($paln_data['PlndMtr']!='' && $paln_data['unit']!='')
			{
				$po_plan = array( 
				'planningOrderID' => $lastinsertid,
				'plannedMtr' => $paln_data['PlndMtr'],
				'unitName' => $paln_data['unit'],
				);
				
				$this->db->insert('po_plan',$po_plan);
			}
	//	}
		/*for ($i = 1; $i <= count($this->input->post('warp_wt')); $i++) {
			if($this->input->post('warp_wt')!='')
			{
				$po_warp = array( 
				'planningOrderID' => $lastinsertid,
				'warpWt' => $this->input->post('warp_wt')[$i],
				'warpHanks' => $this->input->post('warp_hanks')[$i],
				);
				//print_r($po_warp);exit;
				$this->db->insert('po_warp',$po_warp);
			}
		}*/
		
	/*	for ($i = 1; $i <= count($this->input->post('weft_wt')); $i++) {
			if($this->input->post('weft_wt')!='')
			{
				$po_weft = array( 
				'planningOrderID' => $lastinsertid,
				'weftWt' => $this->input->post('weft_wt')[$i],
				'weftHanks' => $this->input->post('weft_hanks')[$i],
				);
				//print_r($po_warp);exit;
				$this->db->insert('po_weft',$po_weft);
			}
		}
		*/
		
		
		
		if($planinsert) { return true; } else { return false; }
	}
	
	public function display_color()
	{
	$this->db->order_by("color","asc");
		$query=$this->db->get('color_master');
		return $query->result();
	}
	
	public function display_shade_name()
	{
		$query=$this->db->get('shade_master');
		return $query->result();
	}
	
	public function getshadenames($stringget)
	{
		$this->db->like('shadeName', $stringget, 'after'); 
        $query=$this->db->get('shade_master');
        return $query->result();
	}
	
	public function getdesign_quality($articlenor)
	{
		$query=$this->db->get_where('article_master', array('articleID' => $articlenor));
		return $query->row();
	}
	
	public function getfabric($fabric)
	{
		$query=$this->db->get_where('fabric_master', array('fabricType' => $fabric));
		return $query->row();
	}
	public function out_plan_outsourcegetordershade($shadeID)
	{
		$this->db->select('sub_orders.subOrderType,sub_order_shades.ourShade,sub_order_shades.buyerShade,indent_product.product_description as quality,sub_orders.articleNo,sub_orders.width,sub_orders.unit,sub_order_shades.quantity,sub_orders.marketingInst,sub_orders.weave,sub_orders.design,sub_orders.description,sub_order_shades.quantity') ;
		$this->db->from('sub_orders');
		
		$this->db->join('sub_order_shades', 'sub_order_shades.subOrderID = sub_orders.id');
//$this->db->join('planned_order', 'planned_order.subNo= sub_order_shades.shadeID');

$this->db->join('indent_product', 'sub_orders.articleNo = indent_product.product');
		$this->db->join('product_master pm', 'pm.fabricType = sub_orders.subOrderType');
$this->db->where('sub_order_shades.shadeID', $shadeID);
		$query = $this->db->get();
	
	
		$result = $query->row_array();
		return $result;
	}
	
	
	public function display_customer($id)
	{
		$query = $this->db->get_where('customer_master', array('id' => $id));
		return $query->result();
	}
	
	//display shade details based on id
	public function display_shade($id)
	{
		$query = $this->db->get_where('shade_master', array('shadeID' => $id));
		return $query->result();
	}
	
		
	//display smwarp details based on id
	public function display_smwarp($id)
	{
		$query = $this->db->get_where('sm_warp', array('shadeID' => $id));
		return $query->result();
	}
	
	//display smweft details based on id
	public function display_smweft($id)
	{
		$query = $this->db->get_where('sm_weft', array('shadeID' => $id));
		return $query->result();
	}
	
	//display article details based on id
	public function display_article($id)
	{
		$query = $this->db->get_where('article_master', array('articleID' => $id));
		return $query->result();
	}
	
	//display warp details based on id
	public function display_warp($id)
	{
		$this->db->order_by('id','asc');
		$query = $this->db->get_where('warp_data', array('article_id' => $id));
		return $query->result();
	}
	
	public function display_warpdata($id)
	{
		$this->db->select('*');
		$this->db->from('warp_data');
		$this->db->join('article_master','warp_data.article_id=article_master.articleID');
		$this->db->where('article_master.articleNo',$id);
		$query = $this->db->get();
		return $query->result();
	}
	
	public function display_warp_group($id)
	{
		$this->db->select('Warp_Quality,yarnQuality,sum(composition) as compo');
		$this->db->join('import_yarn','import_yarn.yarnName=warp_data.Warp_Quality');
		$this->db->group_by('yarnQuality');
		$query = $this->db->get_where('warp_data', array('article_id' => $id));
		return $query->result();
	}
	
	public function total_composition($id)
	{
		$this->db->select('yarnQuality,sum(composition.composition) as sum');
		$this->db->join('yarn','composition.quality = yarn.yarnName');
		$this->db->group_by('yarnQuality');
		$query = $this->db->get_where('composition', array('article_id' => $id));
		return $query->result();
	}
	
	
	
	//display weft details based on id
	public function display_weft($id)
	{
		$query = $this->db->get_where('weft_data', array('article_id' => $id));
		return $query->result();
	}
	
	public function display_weft_group($id)
	{
		$this->db->select('Weft_Quality,yarnQuality,sum(composition) as compo');
		$this->db->join('import_yarn','import_yarn.yarnName=weft_data.Weft_Quality');
		$this->db->group_by('yarnQuality');
		$query = $this->db->get_where('weft_data', array('article_id' => $id));
		return $query->result();
	}
	
	//display article details based on id
	public function display_article_all()
	{	$this->db->order_by("articleNo", "asc");
		$query = $this->db->get('article_master');
		return $query->result();
	}
	
	public function display_article_data_details($warpingfinal,$wearingfinal)
	{	
	    $this->db->select('*,(warpTotalEnds * '.$warpingfinal.') as warp, (weftPicks * '.$wearingfinal.') as weft');
		$this->db->from('article_master');
		$this->db->order_by("articleNo", "asc");
		$query = $this->db->get();
		return $query->result();
	}
	
	public function display_warp_all_details()
	{	
	    $this->db->select('sum(c.rate * b.Kora_Wt) as warprates, b.article_id as article');
		$this->db->from('article_master a');
		$this->db->join('warp_data b', 'b.article_id = a.articleID');
		$this->db->join('import_yarn c', 'c.yarnSpecification = b.Warp_Specification AND c.yarnName = b.Warp_Quality AND c.yarnDenier = b.Warp_Denier');
		$this->db->where('c.yarnType', 'Warp');
		$this->db->group_by("b.article_id");
		$this->db->order_by("articleNo", "asc");
		$query = $this->db->get();
		return $query->result();
	}
	
	public function display_weft_all_details()
	{	
	    $this->db->select('sum(c.rate * b.Kora_Wt) as weftrates, b.article_id as article');
		$this->db->from('article_master a');
		$this->db->join('weft_data b', 'b.article_id = a.articleID');
		$this->db->join('import_yarn c', 'c.yarnSpecification = b.Weft_Specification AND c.yarnName = b.Weft_Quality AND c.yarnDenier = b.Weft_Denier');
		$this->db->where('c.yarnType', 'Weft');
		$this->db->group_by("b.article_id");
		$this->db->order_by("articleNo", "asc");
		$query = $this->db->get();
		return $query->result();
	}

public function warping_wearing_all()
	{	
		$query = $this->db->get('warping_wearing');
		return $query->result();
	}
	
	
	//display warp details based on id
	public function display_warp_all()
	{
	
		$query = $this->db->get('warp_data');
		return $query->result();
	}
	
	//display weft details based on id
	public function display_weft_all()
	{
		$query = $this->db->get('weft_data');
		return $query->result();
	}
	
	public function import_yarn()
	{
		$this->db->select('yarnQuality,yarnName');
		$this->db->from('import_yarn');
		$this->db->group_by('yarnName');
		$query = $this->db->get();
		return $query->result();
	}
	
	public function planning_order_insert($paln_data,$name)
	{
		//print_r($this->input->post('weft_wt'));exit;
		//print_r($plan_data);exit;
		$shadeID=$this->input->post('subNo');
		//$update = $this->db->query('update sub_order_shades set planningStatus="planned" where shadeID="'.$shadeID.'"');
        //$update->result();
		
		if(count($this->input->post('plannedMtr'))>0)
		{
			$updateData = array(
				'planningStatus' => 'Pending',
					'planned_by' => $name
			);

$this->db->where('shadeID', $shadeID);
			$this->db->update('sub_order_shades', $updateData);
		}
		$planinsert=$this->db->insert('planned_order',$paln_data);
		$lastinsertid=$this->db->insert_id();
		for ($i = 0; $i < count($this->input->post('plannedMtr')); $i++) {
			if($this->input->post('plannedMtr')!='' && $this->input->post('unitName')!='')
			{
				$po_plan = array( 
				'planningOrderID' => $lastinsertid,
				'plannedMtr' => $this->input->post('plannedMtr')[$i],
				'unitName' => $this->input->post('unitName')[$i],
				);
				
				$this->db->insert('po_plan',$po_plan);
			}
		}
		for ($i = 1; $i <= count($this->input->post('warp_wt')); $i++) {
			if($this->input->post('warp_wt')!='')
			{
				$po_warp = array( 
				'planningOrderID' => $lastinsertid,
				'warpWt' => $this->input->post('warp_wt')[$i],
				'warpHanks' => $this->input->post('warp_hanks')[$i],
				);
				//print_r($po_warp);exit;
				$this->db->insert('po_warp',$po_warp);
			}
		}
		
		for ($i = 1; $i <= count($this->input->post('weft_wt')); $i++) {
			if($this->input->post('weft_wt')!='')
			{
				$po_weft = array( 
				'planningOrderID' => $lastinsertid,
				'weftWt' => $this->input->post('weft_wt')[$i],
				'weftHanks' => $this->input->post('weft_hanks')[$i],
				);
				//print_r($po_warp);exit;
				$this->db->insert('po_weft',$po_weft);
			}
		}
		
		
		
		
		if($planinsert) { return true; } else { return false; }
	}
	
	public function planning_order_update($paln_data)
	{
		$subNo=$this->input->post('subNo');
		
		$this->db->where('subNo', $subNo);
		$this->db->update('planned_order', $paln_data);
		
		$query = $this->db->get_where('planned_order', array('subNo' => $subNo));
		$result=$query->row();
		$plnningOrderID=$result->id;
		
		$query = $this->db->get_where('po_plan', array('planningOrderID' => $plnningOrderID));
		$resultid=$query->result();
		
		
		for ($i = 0; $i < count($this->input->post('plannedMtr')); $i++) {
			if($this->input->post('plannedMtr')!='' && $this->input->post('unitName')!='')
			{
			    $id=$resultid[$i]->id;
				$updateData = array(
					'plannedMtr' => $this->input->post('plannedMtr')[$i],
					'unitName' => $this->input->post('unitName')[$i],
				);

$this->db->where('id', $id);
				$this->db->update('po_plan', $updateData);

}
		}
		
	
		$query = $this->db->get_where('po_warp', array('planningOrderID' => $plnningOrderID));
		$resultwarp=$query->result();
	
		$j=0;
		for ($i = 1; $i <= count($this->input->post('warp_wt')); $i++) {
			if($this->input->post('warp_wt')!='')
			{
				$id=$resultwarp[$j]->id;
				$updateData1 = array( 
				'warpWt' => $this->input->post('warp_wt')[$i],
				'warpHanks' => $this->input->post('warp_hanks')[$i],
				);
				
				$this->db->where('id', $id);
				$this->db->update('po_warp', $updateData1);
				$j++;
			}
		}
		
		$query = $this->db->get_where('po_weft', array('planningOrderID' => $plnningOrderID));
		$resultweft=$query->result();
		//print_r($resultweft);exit;
		$j=0;
		for ($i = 1; $i <= count($this->input->post('weft_wt')); $i++) {
			if($this->input->post('weft_wt')!='')
			{
			    
				$id=$resultweft[$j]->id;
				$updateData2 = array( 
				'weftWt' => $this->input->post('weft_wt')[$i],
				'weftHanks' => $this->input->post('weft_hanks')[$i],
				);
				$this->db->where('id', $id);
				$this->db->update('po_weft', $updateData2);
				$j++;
			}
		}
		
		return true;
	}
        
        public function get_planned_shade_details($subNumber){
        $this->db->select('po.*,so.*,sos.*,pm.*,am.quality,am.loomWidth,am.finishWidth,am.articleID,sm.shadeName');
        $this->db->from('planned_order po');
        $this->db->where('po.subNo', $subNumber);
        $this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
        $this->db->join('sub_orders so', 'so.id = sos.subOrderID');
        $this->db->join('article_master am', 'so.articleNo = am.articleNo');
		$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
        $query = $this->db->get();
        //echo $this->db->last_query();exit;
        $result = $query->row_array();
        return $result;
    }
    
    public function get_outsourceplanned_shade_details($subNumber){
    	 
    	$this->db->from('planned_order po');
    	$this->db->where('po.subNo', $subNumber);
    	$this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
    	$this->db->join('sub_orders so', 'so.id = sos.subOrderID');
    	$this->db->join('indent_product am', 'so.articleNo = am.product');
    	$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
    	$query = $this->db->get();
    	//echo $this->db->last_query();exit;
    	$result = $query->row_array();
    	return $result;
    
    }
     public function get_planned_suborder_shade_details($subNumber){
		 		 $this->db->select('po.*,sm.*,o.orderType,so.subOrderType');
		 $this->db->select('po.*,sm.*');
        $this->db->from('planned_order po');
        $this->db->where('po.subNo', $subNumber);
        $this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
        $this->db->join('sub_orders so', 'so.id = sos.subOrderID');
		$this->db->join('orders o', 'o.id = so.orderID');
        $this->db->join('article_master am', 'so.articleNo = am.articleNo');
		$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
		$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
        $query = $this->db->get();
        //echo $this->db->last_query();exit;
        $result = $query->row_array();
        return $result;
        
    }
     public function get_planned_order_details($subNumber,$id)
    {
    	$article_id=$id;
    	$this->db->select('so.id,so.width,am.articleID,po.oslNo,am.finish_grams_squaremeter,po.weavingDate,po.articleNo,po.warpPlandMtr,po.weftPlandMtr,sm.shadeName,so.design,po.selWidth,so.quality,sos.shadeID,am.reed,am.reedWidth,am.loomWidth,po.pieceLength');
		$this->db->distinct();		
    	$this->db->from('planned_order po');		
		$this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
		$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
        $this->db->join('sub_orders so', 'so.id = sos.subOrderID');
		$this->db->join('orders o', 'o.id = so.orderID');
        $this->db->join('article_master am', 'so.articleNo = am.articleNo','left');
		$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
		$this->db->group_by('sos.shadeID');
    	$this->db->where('o.id', $subNumber);    	
    	$this->db->where('sos.planningStatus','planned');
		$this->db->order_by('po.id');
    	$query=$this->db->get();
    	return $query->result();
	
    }
	
    
    public function subdetails($subNumber)
    {
    	$this->db->select('design,quality,so.id');
    	$this->db->from('orders o');
    	$this->db->join('sub_orders so','o.id = so.orderID');
    	$this->db->where('o.oslNo', $subNumber);
    	
    	$query=$this->db->get();
    	return $query->result();
    }
    
    public function planned_mtrs($subNumber)
    {
    	
    	$this->db->select('po.warpPlandMtr,po.weftPlandMtr,po.selWidth,sm.shadeID,sm.shadeName,po.articleNo,po.pieceLength,sm.articleID,po.oslNo');
    	$this->db->from('planned_order po');
    	
    	$this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
    	$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
    	$this->db->where('sos.planningStatus','planned');
    	$this->db->where('po.oslNo', $subNumber);
    	$query=$this->db->get();
    	 
    	return $query->result();
    
    }
    
    public function planned_totalmtrs($subNumber)
    {
    	 
    	$this->db->select('sum(warpPlandMtr) as WAM,sum(weftPlandMtr) as WEM');
    	$this->db->from('planned_order po');
    	 
    	$this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
    	$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
    	$this->db->where('sos.planningStatus','planned');
    	$this->db->where('po.oslNo', $subNumber);
    	$query=$this->db->get();
    
    	return $query->result();
    
    }
    
    
    
    public function get_planned_order_detailsrow($subNumber)
    {
        
    	$this->db->select('so.id,po.dyeingDate,po.weavingDate,po.plannedDate,am.articleID,po.sslShade,sm.shadeName,po.oslNo,po.articleNo,po.warpPlandMtr,po.weftPlandMtr,sos.ourShade,so.design,po.selWidth,so.quality,so.id,
    			we.Weft_Quality,we.Weft_Specification,we.Kora_Wt as weftWt,wa.Warp_Quality,wa.Warp_Specification,wa.Kora_Wt as warpWt'); //swa.warpCode,swe.weftCode
    	$this->db->from('planned_order po');
    	
    	$this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
    	$this->db->join('sub_orders so', 'so.id = sos.subOrderID');
    	$this->db->join('orders o', 'o.id = so.orderID');
    	$this->db->join('article_master am', 'so.articleNo = am.articleNo');
    	//$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
    	$this->db->join('warp_data wa', 'wa.article_id = am.articleID');
    	$this->db->join('weft_data we', 'we.article_id = wa.article_id');
    	$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
    //	$this->db->join('sm_warp swa', 'swa.shadeID = po.sslShade');
    //	$this->db->join('sm_weft swe', 'swe.shadeID = po.sslShade');
    	$this->db->where('o.id', $subNumber);
    	//$this->db->where('po.sslShade', $shade);
    	$this->db->where('sos.planningStatus','planned');
        $this->db->where('sos.add_suborder',0);
        //$this->db->limit('10');
    	$query=$this->db->get();
    	$result= $query->result();
    	$array=array();
    	foreach($result as $res)
    	{
    	    $data['id']=$res->id ;
    	    $data['dyeingDate']=$res->dyeingDate ;
    	    $data['weavingDate']=$res->weavingDate ;
    	    $data['plannedDate']=$res->plannedDate ;
    	    $data['articleID']=$res->articleID ;
    	    $data['sslShade']=$res->sslShade ;
    	    $data['shadeName']=$res->shadeName ;
    	    $data['oslNo']=$res->oslNo ;
    	    $data['articleNo']=$res->articleNo ;
    	    $data['warpPlandMtr']=$res->warpPlandMtr ;
    	    $data['weftPlandMtr']=$res->weftPlandMtr ;
    	    $data['ourShade']=$res->ourShade ;
    	    $data['design']=$res->design ;
    	    $data['selWidth']=$res->selWidth ;
    	    $data['quality']=$res->quality ;
    	    $data['Weft_Quality']=$res->Weft_Quality ;
    	    $data['Weft_Specification']=$res->Weft_Specification ;
    	    $data['weftWt']=$res->weftWt ;
    	    $data['Warp_Quality']=$res->Warp_Quality ;
    	    $data['Warp_Specification']=$res->Warp_Specification ;
    	    $data['warpWt']=$res->warpWt ;
    	    $query = $this->db->query('SELECT sm_warp.warpCode FROM sm_warp where shadeID=' . $res->sslShade);
    	    $det= $query->row();
    	    $query1 = $this->db->query('SELECT sm_weft.weftCode FROM sm_weft where shadeID=' . $res->sslShade);
    	    $dets= $query1->row();
    	    $data['warpCode']=$det ;
    	    $data['weftCode']=$dets ;
    	   // array_push($array, $data);
    	}
    	return $data;
    }
    
    public function get_planned_warp_wt($subNo){
        $this->db->select('pow.*');
        $this->db->from('po_warp pow');
        $this->db->join('planned_order po', 'po.id=pow.planningOrderID');
        $this->db->where('po.subNo', $subNo);
        $query = $this->db->get();
        //echo $this->db->last_query();exit;
        $result = $query->result_array();
        return $result;
        
    }
    
    public function get_reed($article)
    {
    	 $this->db->select('*');
        $this->db->from('article_master');
        $this->db->where('articleID', $article);
        $query = $this->db->get();
        //echo $this->db->last_query();exit;
        $result = $query->result_array();
        return $result;
    }
    
    public function get_plannedwarpwt($subNo){
    	$this->db->select('pow.*');
    	$this->db->from('po_warp pow');
    	$this->db->join('planned_order po', 'po.id=pow.planningOrderID');
    	$this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
    	$this->db->where('sos.planningStatus','planned');
    	$this->db->where('po.oslNo', $subNo);
    	$query = $this->db->get();
    	//echo $this->db->last_query();exit;
    	$result = $query->result_array();
    	return $result;
    
    }

public function get_planned_weft_wt($subNo){
    	$this->db->select('pow.*');
    	$this->db->from('po_weft pow');
    	$this->db->join('planned_order po', 'po.id=pow.planningOrderID');
    	$this->db->where('po.subNo', $subNo);
    	$query = $this->db->get();
    	//echo $this->db->last_query();exit;
    	$result = $query->result_array();
    	return $result;
    
    }
    public function date_display($subNo)
    {
    	$this->db->select('*');
    	$this->db->from('planned_order po');
    	 $this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
        $this->db->where('sos.planningStatus','planned');
        $this->db->where('po.oslNo', $subNo);
    	$query = $this->db->get();
    	return $query->result();
    	 
    }
    
    public function get_plannedweftwt($subNo){
    	$this->db->select('pow.*');
    	$this->db->from('po_weft pow');
    	$this->db->join('planned_order po', 'po.id=pow.planningOrderID');
    	$this->db->where('po.oslNo', $subNo);
    	$query = $this->db->get();
    	//echo $this->db->last_query();exit;
    	$result = $query->result_array();
    	return $result;
    
    }
    public function get_ssl_shadeID($shadeID){
        $this->db->select('sslShade');
        $this->db->from('planned_order');
        $this->db->where('subNo', $shadeID);
        $query = $this->db->get();
        $result = $query->row();
        return $result->sslShade;
    }
    
    public function get_fabricdata($table,$where)
    {
    	$this->db->select("*");
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
    
    public function insert($table,$data)
    {
    	$this->db->insert($table,$data);
    }
    
    public function get_dataa_orders_only_dlt($table,$where)
    {
        $string='SAM0';
         $sql    = "SELECT * FROM palnned_shade_details WHERE oslNo NOT LIKE "."'%".$string."%' order by oslNo DESC";
        $result = $this->db->query($sql);
		return $result->result();
    	/*$this->db->select('*');

$this->db->from($table);
    	$this->db->where($where);
    	
    	$this->db->order_by('oslno_id','DESC');
        $this->db->order_by('oslNo','DESC');
        $query=$this->db->get();
    	return $query->result();*/
    
    }
    public function get_dataa_orders_only_sam($table,$where)
    {
        $string='SAM0';
         $sql    = "SELECT * FROM palnned_shade_details WHERE oslNo LIKE "."'%".$string."%' order by oslNo DESC";
        $result = $this->db->query($sql);
		return $result->result();
    	
    
    }
    public function get_dataa_orders($table,$where)
    {
    	$this->db->select('*');

$this->db->from($table);
    	$this->db->where($where);
    	
    	$this->db->order_by('oslno_id','DESC');
        $this->db->order_by('oslNo','DESC');
        $query=$this->db->get();
    	return $query->result();
    
    }
    public function get_dataa($table,$where)
    {
    	$this->db->select('*');
    	$this->db->from($table);
    	$this->db->where($where);
    	$this->db->order_by('id','DESC');
    	//	$this->db->order_by('oslno_id','DESC');
        // $this->db->order_by('oslNo','DESC');
    	$query=$this->db->get();
    	return $query->result();
    
    }
    public function update($table,$insert_values,$update_cond)
    {
    	$this->db->where($update_cond);
    	$this->db->update($table,$insert_values);
    }
    public function fetch_max_id_orders()
    {
    	$this->db->select('*');
    
    	$this->db->from('sub_orders');
    	$this->db->order_by('id','DESC');
    	$this->db->limit(1);
    	$query = $this->db->get();
    
    	return $query->row();
    
    }
    public function get_where_data($table,$where)
    {
    	$this->db->select('*');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query=$this->db->get();
    	return $query->row();
    
    }
    
    public function fetch_max_id_orders1($table,$where)
    {
    	$this->db->select('*');
    
    	$this->db->from($table);
    	$this->db->where($where);
    	$this->db->order_by('subCode','DESC');
    	$this->db->limit(1);
    	$query = $this->db->get();
    
    	return $query->row();
    
    }
	
 public function shade_master_details($where,$where1)
    {
    	$this->db->select('sm_weft.weftColor,sm_weft.weftCode,weft_data.Weft_Quality,weft_data.Weft_Denier,weft_data.Weft_Specification,weft_data.Kora_Wt,weft_data.Hanks') ;
    	$this->db->from('sm_weft');
		$this->db->join('shade_master', 'sm_weft.shadeID = shade_master.shadeID');
		$this->db->join('weft_data', 'weft_data.article_id = shade_master.articleID');
		$this->db->join('article_master', 'article_master.articleID = shade_master.articleID');
    	$this->db->where('sm_weft.shadeID', $where);
		$this->db->where('shade_master.articleID', $where1);
    	$this->db->group_by('sm_weft.id');
		
		
    	$query = $this->db->get();
        return $query->result();
    }
	 public function shade_master_details1($where,$where1)
    {
    	$this->db->select('sm_warp.warpColor,sm_warp.warpCode,warp_data.Warp_Quality,warp_data.Warp_Denier,warp_data.Warp_Specification,warp_data.Kora_Wt,warp_data.Hanks') ;
    	$this->db->from('shade_master');
    	$this->db->where('shade_master.shadeID', $where);
		$this->db->where('articleID', $where1);
    	$this->db->join('warp_data', 'warp_data.article_id = shade_master.articleID');
		$this->db->join('sm_warp', 'sm_warp.shadeID = shade_master.shadeID');
		$this->db->group_by('sm_warp.id');
    	$query = $this->db->get();
        return $query->result();
    }
	 
	public function fetch_main_data($table,$where)
{
	$this->db->select("*");
	$this->db->from($table);
	$this->db->where($where);
	$query = $this->db->get();
	return $query->row();
}
public function update_new($data,$where)
		{
    	$this->db->where($where);
		$this->db->update('shade_master',$data);
    
    }
	public function update_new_weft_data($data,$where)
		{
    	$this->db->where($where);
		$this->db->update('sm_weft',$data);
    
    }
	public function update_new_warp_data($data,$where)
		{
    	$this->db->where($where);
		$this->db->update('sm_warp',$data);
    
    }
	 public function delete($table,$where)
    {
    	$this->db->where($where);
    	$this->db->delete($table);
    }
    
    public function display_vendor_details()
    {
    	$this->db->select("*");
    	$this->db->from('indent_vendor_master');
        $this->db->order_by('name','asc');
    	$query = $this->db->get();
    	return $query->result();
    }
    
    public function dyeing_smweft($sm_weft)
    {
    	$this->db->select("*");
    	$this->db->from('sm_weft');
    	$this->db->where_in('shadeID',$sm_weft);
    	$query = $this->db->get();
	   	return $query->result();
    }
      public function fetch_shadename($table,$where)
    {
    	$this->db->select('*');
    	//$this->db->select('quantity');
    	$this->db->from($table);
    	$this->db->where($where);
    	$query = $this->db->get();
    	return $query->row();
    }
	 public function shade_master_details_1($where,$where1)
    {
    	$this->db->select('sm_weft.weftColor,sm_weft.weftCode,weft_data.Weft_Quality,weft_data.Weft_Denier,weft_data.Weft_Specification,weft_data.Kora_Wt,weft_data.Hanks') ;
    	$this->db->from('sm_weft');
		$this->db->join('shade_master', 'sm_weft.shadeID = shade_master.shadeID');
		$this->db->join('weft_data', 'weft_data.article_id = shade_master.articleID');
		$this->db->join('article_master', 'article_master.articleID = shade_master.articleID');
    	$this->db->where('sm_weft.shadeID', $where);
		$this->db->where('shade_master.articleID', $where1);
    	$this->db->group_by('weft_data.id');
		
		
    	$query = $this->db->get();
        return $query->result();
    }
	 public function shade_master_details1_1($where,$where1)
    {
    	$this->db->select('warp_data.article_id,warp_data.id,warpColor,sm_warp.warpCode,warp_data.Warp_Quality,warp_data.Warp_Denier,warp_data.Warp_Specification,warp_data.Kora_Wt,warp_data.Hanks') ;
    	$this->db->from('shade_master');
    	$this->db->where('shade_master.shadeID', $where);
		$this->db->where('articleID', $where1);
    	$this->db->join('warp_data', 'warp_data.article_id = shade_master.articleID');
		$this->db->join('sm_warp', 'sm_warp.shadeID = shade_master.shadeID');
		$this->db->group_by('warp_data.id');
    	$query = $this->db->get();
        return $query->result();
    }
	
    public function dyeing_smwarp($sm_weft)
    {
    	$this->db->select("*");
    	$this->db->from('sm_warp');
    	$this->db->where_in('shadeID',$sm_weft);
    	$query = $this->db->get();
    	return $query->result();
    }
	 public function insert_planning_data($table,$data)
    {
      $query=	$this->db->insert($table,$data);
		return $this->db->insert_id();
    }
	
		public function planning_modal_order_insert($paln_data,$name,$result,$warp_wt,$warp_hank,$weft_wt,$weft_hank)
	{
		//print_r($this->input->post('weft_wt'));exit;
		//print_r($plan_data);exit;
		$shadeID=$result;
		//$update = $this->db->query('update sub_order_shades set planningStatus="planned" where shadeID="'.$shadeID.'"');
        //$update->result();
		
		if(count($this->input->post('plannedMtr'))>0)
		{
			$updateData = array(
				'planningStatus' => 'Pending',
					'planned_by' => $name
			);

$this->db->where('shadeID', $shadeID);
			$this->db->update('sub_order_shades', $updateData);
		}
		$planinsert=$this->db->insert('planned_order',$paln_data);
		$lastinsertid=$this->db->insert_id();
		if(isset($warp_wt))
		{
			for ($i = 0; $i <= count($warp_wt); $i++) {
			if($this->input->post('warp_wt')!='')
			{
				$po_warp = array( 
				'planningOrderID' => $lastinsertid,
				'warpWt' => $warp_wt[$i],
				'warpHanks' => $warp_hank[$i],
				);
				
				$po_weft = array( 
				'planningOrderID' => $lastinsertid,
				'weftWt' => $weft_wt[$i],
				'weftHanks' => $weft_hank[$i],
				);
				//print_r($po_warp);exit;
				$this->db->insert('po_weft',$po_weft);
				
				//print_r($po_warp);exit;
				$this->db->insert('po_warp',$po_warp);
			}
		}
		}
		
		// if(isset($weft_wt))
		// {
		// for ($i = 0; $i <= count($weft_wt); $i++) {
			// if($weft_wt != '')
			// {
				// $po_weft = array( 
				// 'planningOrderID' => $lastinsertid,
				// 'weftWt' => $weft_wt[$i],
				// 'weftHanks' => $weft_hank[$i],
				// );
				// //print_r($po_warp);exit;
				// $this->db->insert('po_weft',$po_weft);
			// }
		// }
		// }
		for ($i = 0; $i < count($this->input->post('plannedMtr')); $i++) {
			if($this->input->post('plannedMtr')!='' && $this->input->post('unitName')!='')
			{
				$po_plan = array( 
				'planningOrderID' => $lastinsertid,
				'plannedMtr' => $this->input->post('plannedMtr')[$i],
				'unitName' => $this->input->post('unitName')[$i],
				);
				
				$this->db->insert('po_plan',$po_plan);
			}
		}
		
		
		if($planinsert) { return true; } else { return false; }
	}
public function get_planned_pending_shade_details($subNumber){
        $this->db->select('po.*,so.*,sos.*,pm.*,am.quality,am.loomWidth,am.finishWidth,am.articleID,sm.shadeName,sos.shadeID as id');
        $this->db->from('planned_order po');
        $this->db->where('po.subNo', $subNumber);
        $this->db->join('sub_order_shades sos', 'sos.shadeID = po.subNo');
		$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
        $this->db->join('sub_orders so', 'so.id = sos.subOrderID');
        $this->db->join('article_master am', 'so.articleNo = am.articleNo');
		$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
        $query = $this->db->get();
        //echo $this->db->last_query();exit;
        $result = $query->row_array();
        return $result;
        
    }	
public function planned_shade_det()
{
$this->db->select('o.oslNo,o.oslno_id,sm.shadeName,wa.*,pow.*,am.articleNo,po.dyeingDate,po.weavingDate,sw.warpColor,sw.warpCode');
//	 $this->db->from('orders o');
	// $this->db->from('orders o');
    //  $this->db->join('sub_orders so', 'so.orderID = o.id');
	//  $this->db->join('sub_order_shades sos', 'so.id = sos.subOrderID');
	//	$this->db->join('planned_order po', 'sos.shadeID = po.subNo');
	//	$this->db->join('shade_master sm', 'po.sslShade = sm.shadeID');
	//$this->db->join('article_master am', 'so.articleNo = am.articleNo');
	//	$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
		//$this->db->join('warp_data wo', 'am.articleID = wo.article_id');
	//	$this->db->join('weft_data we', 'am.articleID = we.article_id');
	
	$this->db->from('orders o');
    $this->db->join('sub_orders so', 'so.orderID = o.id');
	$this->db->join('sub_order_shades sos', 'so.id = sos.subOrderID');
	$this->db->join('article_master am', 'so.articleNo = am.articleNo');
	$this->db->join('warp_data wa', 'am.articleID = wa.article_id');
	//$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
	$this->db->join('planned_order po', 'sos.shadeID = po.subNo');
	$this->db->join('shade_master sm', 'sm.shadeID = po.sslShade');
$this->db->join('sm_warp sw', 'sw.shadeID = sm.shadeID');
	 $this->db->join('po_warp pow', 'po.id=pow.planningOrderID');
	//$this->db->join('weft_data we', 'am.articleID = we.article_id');
			$query=$this->db->get();
    		return $query->result();
}
public function planned_shade_weft_det	()
{
$this->db->select('o.oslNo,o.oslno_id,sm.shadeName,wa.*,pow.*,am.articleNo,po.dyeingDate,po.weavingDate,sw.weftColor,sw.weftCode,po.id');

$this->db->from('orders o');
    $this->db->join('sub_orders so', 'so.orderID = o.id');
	$this->db->join('sub_order_shades sos', 'so.id = sos.subOrderID');
	$this->db->join('article_master am', 'so.articleNo = am.articleNo');
	$this->db->join('weft_data wa', 'am.articleID = wa.article_id');
	//$this->db->join('product_master pm', 'pm.fabricType = so.subOrderType');
	$this->db->join('planned_order po', 'sos.shadeID = po.subNo');
	$this->db->join('shade_master sm', 'sm.shadeID = po.sslShade');
$this->db->join('sm_weft sw', 'sw.shadeID = sm.shadeID');
	 $this->db->join('po_weft pow', 'po.id=pow.planningOrderID');
	//$this->db->join('weft_data we', 'am.articleID = we.article_id');
			$query=$this->db->get();
    		return $query->result();
}

public function group_import_yarn($table,$where)
	{
		$this->db->select('*');
		$this->db->from($table);
		$this->db->group_by(['Quality','Specification','Denier']);
                $this->db->where($where);
		$query = $this->db->get();
		return $query->result();
	}
public function group_import_qua_yarn($table,$where)
	{
		$this->db->select('sum(Dyed_Wt) as Dyed_Wt,Quality,Specification,Denier');
//$this->db->order_by('id','asc');
		$this->db->from($table);
		$this->db->where($where);
		$query = $this->db->get();
		return $query->row();
	}
public function group_total_import_yarn($table,$where)
	{
		$this->db->select('sum(Dyed_Wt) as Dyed_Wt,Code,type,Quality,Specification,Denier,Color');
		$this->db->from($table);
		$this->db->group_by(['code','type']);
		$this->db->order_by('id','asc');
                $this->db->where($where);
		$query = $this->db->get();
		return $query->result();
	}

}
?>