EVOLUTION-NINJA

Edit File: Rec_stock.php

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

class Rec_stock extends CI_Controller {

public function __construct() {
parent::__construct();
$this->check_islogin(); //check user login session exist or not
$this->output->set_header('Last-Modified: ' . gmdate("D, d M Y H:i:s") . ' GMT');
$this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
$this->output->set_header('Pragma: no-cache');
$this->output->set_header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
$this->load->model('yarn_model');
$this->load->model('marketing_model');
$this->load->model('planning_yarn');
$this->load->model('planning_shade');
$this->load->model('request_model');
$this->load->model('vendor_model');
$this->load->model('outsource_model');
$this->load->model('store_model');
$this->load->model('stock_model');
date_default_timezone_set('asia/kolkata');
}

public function log()
{
echo $_REQUEST['name'];exit;
echo "login";
}

//Checking the Login or not
private function check_islogin() {
if (!$this->session->userdata('logged_in')) {
redirect(base_url(), 'refresh');
}
}

public function session_data_pass() {
if ($this->session->userdata('logged_in')) {
return $this->yarn_model->get_userdata();
}
}
public function access_details_id()
	{
		$id=$this->session->userdata('logged_in');
	$where=array('id'=>$id);
	$approved_by=$id['userid'];
	$table='employee_details';
	$where=array('id'=>$approved_by);
	$d=$this->marketing_model->fetch_main_data($table,$where);
	$data['user_type_id']=$d->user_type_id;
	
	$table='swansilk_access_controls';
	$where=array('department_id'=>$data['user_type_id']);
	return $this->marketing_model->fetch_main_data($table,$where);
	}
		public function indent_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
			if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'HO Purchase Admin' )  
	 { 
		$d=date('d-m-Y');
		$table='indent_add_indent';
		$where=array('indented_date'=>$d,'insert_notification_status'=>0);
		$indent_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
					
		$d=date('d-m-Y');
		$table='indent_add_indent';
		$where=array('updated_on'=>$d,'update_notification_status'=>0);
		$indent_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		$d=date('d-m-Y');
		$table='indent_add_indent';
		$where=array('approved_date'=>$d,'approval_notification_status'=>0);
		$indent_approval_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		 }	
	  else
	  {
		$indent_insert_rows=0;
		$indent_update_rows=0;
		$indent_approval_rows=0;
	  }
	
		//
	if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin')  	
	 { 
		$d=date('d-m-Y');
		$table='indent_po';
		$where=array('created_date'=>$d,'insert_notification_status'=>0);
		$indent_po_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
	 }
	else
	{
		$indent_po_insert_rows1=0;
	}
	if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'HO Purchase Admin' ) 
	{	
		$d=date('d-m-Y');
		$table='indent_po';
		$where=array('updated_on'=>$d,'update_notification_status'=>0);
		$indent_po_update_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		$d=date('d-m-Y');
		$table='indent_po';
		$where=array('approved_date'=>$d,'approval_notification_status'=>0);
		$indent_po_approval_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
	else
	{
		$indent_po_update_rows1=0;
		$indent_po_approval_rows1=0;
	}	
		$r=$indent_insert_rows + $indent_update_rows + $indent_approval_rows + $indent_po_insert_rows1 + $indent_po_update_rows1 + $indent_po_approval_rows1;
		return $r;
   }
   public function split_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
		if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' || $data['emp_details']->designation == 'ACCOUNTS' || $data['emp_details']->designation == 'Accounts' || $data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin') 
		{
			$ttt1=date('d/m/Y');
                   $ddd1=date('d-m-Y');
		$table='fabric_inspection_details';
		$where=array('received_date'=>$ttt1,'split_noti'=>'Yes','insert_notification_status'=>0);
		$data['stock_split_data_res_count']=$this->vendor_model->fabric_inspection_split_count_amount_get_customerdata($table,$where);

$ttt=date('d/m/Y');
       		$table='fabric_madeups_delivery_confirmation';
		$where=array('rec_date'=>$ttt,'split_noti'=>'Yes','insert_notification_status'=>0);
		$data['stock_madeups_split_data_res_count']=$this->vendor_model->fabric_inspection_split_count_amount_get_customerdata($table,$where);
		}
		else
		{
			$data['stock_split_data_res_count']=0;
			$data['stock_madeups_split_data_res_count']=0;
			
		}
	
		$stock=$data['stock_split_data_res_count'] + $data['stock_madeups_split_data_res_count'];
		return $stock;
   }
   public function stock_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
		if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' || $data['emp_details']->designation == 'ACCOUNTS' || $data['emp_details']->designation == 'Accounts') 
		{
			$d=date('d-m-Y');
			$table='fabric_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='swan_yarn_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows1']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='yarn_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows2']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
		}
		else
		{
			$data['stoct_transfer_rows']=0;
			$data['stoct_transfer_rows1']=0;
			$data['stoct_transfer_rows2']=0;
		}
	
			if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin')
		{ 
		
$ttt1=date('d/m/Y');
       $ddd1=date('d-m-Y');
		$table='fabric_inspection_details';
		$where=array('received_date'=>$ttt1);
		$where1=array('received_date'=>$ddd1);
		$data['stock_split_data']=$this->vendor_model->fabric_inspection_split_count_amount_get_customerdata($table,$where,$where1);

//"(status='live' OR status='dead')"

$d=date('d-m-Y');
			$table='cs_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows3']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
		}
		else
		{
			$data['stoct_transfer_rows3']=0;
$data['stock_split_data']=0;
		}

$stock=$data['stoct_transfer_rows'] + $data['stoct_transfer_rows1'] + $data['stoct_transfer_rows2'] + $data['stoct_transfer_rows3'] + $data['stock_split_data'];
		return $stock;
   }
		
		public function rec_stock_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	   if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin') 
	   {
		   
			//
			$d=date('d-m-Y');
			$table='fabric_transfer';
			$where=array('rec_date'=>$d,'update_notification_status'=>0);
			$data['rec_stoct_transfer_rows']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='swan_yarn_transfer';
			$where=array('rec_date'=>$d,'update_notification_status'=>0);
			$data['rec_stoct_transfer_rows1']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='yarn_transfer';
			$where=array('rec_date'=>$d,'update_notification_status'=>0);
			$data['rec_stoct_transfer_rows2']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
	   }
	   else
	   {
		   $data['rec_stoct_transfer_rows']=0;
		   $data['rec_stoct_transfer_rows1']=0;
		   $data['rec_stoct_transfer_rows2']=0;
	   }
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin') 
		{
			
			$d=date('d-m-Y');
			$table='cs_transfer';
			$where=array('rec_date'=>$d,'update_notification_status'=>0);
			$data['rec_stoct_transfer_rows3']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
		}
		else
		{
			$data['rec_stoct_transfer_rows3']=0;
		}
		//$data['total_rec_stock_notifications']=$data['rec_stoct_transfer_rows'] + $data['rec_stoct_transfer_rows1'] + $data['rec_stoct_transfer_rows2'] + $data['rec_stoct_transfer_rows3'] ;
		
		$rec_stock=$data['rec_stoct_transfer_rows'] + $data['rec_stoct_transfer_rows1'] + $data['rec_stoct_transfer_rows2'] + $data['rec_stoct_transfer_rows3'];
		return $rec_stock;
   }
		public function marketing_page_notifications()
   {
	  $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
	   
	   if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin') 
	   {
		   
			//
			$d=date('d-m-Y');
			$where=$d;
			$data['marketing_rows']=$this->vendor_model->marketing_notification_getsuborder($where);
			$data['marketing_confirm_rows']=$this->vendor_model->marketing_notification_confirm_getsuborder($where);
			$data['marketing_update_num_rows']=$this->vendor_model->marketing_notification_update_getsuborder($where);
			
			$d=date('Y-m-d');
			$where=$d;
			$data['marketing_on_date_rows']=$this->vendor_model->marketing_notification_delivery_date_getsuborder($where);
			
			$befdore_ten=date('Y-m-d',strtotime('+10 days')) . PHP_EOL;		
			$data['marketing_ten_days_rows']=$this->vendor_model->marketing_notification_delivery_date_getsuborder($befdore_ten);
			
			$befdore_thirty=date('Y-m-d',strtotime('+30 days')) . PHP_EOL;
			$data['marketing_thirty_days_rows']=$this->vendor_model->marketing_notification_delivery_date_getsuborder($befdore_thirty);
	   }
	   else
	   {
		   $data['marketing_rows'] = 0;
		   $data['marketing_confirm_rows'] = 0;
		   $data['marketing_update_num_rows'] = 0;
		   $data['marketing_on_date_rows'] = 0;
		   $data['marketing_ten_days_rows'] = 0;
		   $data['marketing_thirty_days_rows'] = 0;
		   
	   }
	   
    	 $mark= $data['marketing_rows'] + $data['marketing_confirm_rows'] + $data['marketing_update_num_rows'] + $data['marketing_on_date_rows'] +  $data['marketing_ten_days_rows'] + $data['marketing_thirty_days_rows'];
		 return $mark;
   }
		
  public function issue_fabric_page_notifications()
   {
		//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
			$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin') 
		{
			$d=date('d-m-Y');
			$table='fabric_addstock';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$f=$this->vendor_model->issue_fabric_count_amount_get_customerdata($table,$where);
		}
		else
		{
			$f=0;
		}
		
    	// $mark= $data['marketing_rows'] + $data['marketing_confirm_rows'] + $data['marketing_update_num_rows'] + $data['marketing_on_date_rows'] +  $data['marketing_ten_days_rows'] + $data['marketing_thirty_days_rows'];
		 return $f;
   }
   
    public function issue_cs_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
			$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin')
		{
			//
			$d=date('d-m-Y');
			$table='cs_addstock';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$cs=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
		else
		{
			$cs=0;
		}
		
		 return $cs;
   }
   public function issue_loom_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' )  
	 { 
		$d=date('d-m-Y');
		$table='issue_loom';
		$where=array('issued_date'=>$d,'insert_notification_status'=>0);
		$indent_insert_rows=$this->vendor_model->count_of_pcs($table,$where);
					
		 $d=date('d-m-Y');
		 $table='issue_loom';
		 $where=array('rements_approved_date'=>$d,'update_notification_status'=>0);
		 $indent_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		 $d=date('d-m-Y');
		 $table='weaving_panel_planning_order';
		 $where=array('issue_approved_date'=>$d,'approval_notification_status'=>0);
		 $indent_approval_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
	  }	
	   else
	   {
		  $indent_insert_rows=0;
		  $indent_approval_rows=0;
		  $indent_update_rows=0;
	   }
	
		
		$r=$indent_insert_rows + $indent_approval_rows + $indent_update_rows;
		
	
		return $r;
		
   }	
     public function planning_page_notifications()
   {
		
		$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'MARKETING' || $data['emp_details']->designation == 'Marketing') 
		{
			
			// //
			 $d=date('d-m-Y');
			 $data['planning_order_rows'] = $this->vendor_model->planning_notification_get_details($d);
			
			$dd=date('Y-m-d');
			$where=$dd;
			
			$data['pallning_outsource_rows']=$this->vendor_model->outsource_planning_notification_get_details($where);
			
			
			$d=date('Y-m-d');
			$where=$d;
			$data['planned_dyeing_on_date_rows']=$this->vendor_model->marketing_notification_deying_date_getsuborder($where);
			$data['planned_weaving_on_date_rows']=$this->vendor_model->marketing_notification_weaving_date_getsuborder($where);
			
			$befdore_seven=date('Y-m-d',strtotime('+7 days')) . PHP_EOL;		
			$data['planned_dyeing_sevenn_days_rows']=$this->vendor_model->marketing_notification_deying_date_getsuborder($befdore_seven);
			  $data['planned_weaving_sevenn_days_rows']=$this->vendor_model->marketing_notification_weaving_date_getsuborder($befdore_seven);
			
			$after_five=date('Y-m-d',strtotime('-5 days')) . PHP_EOL;
			$data['planned_dyeing_five_days_rows']=$this->vendor_model->marketing_notification_deying_date_getsuborder($after_five);
			$data['planned_weaving_five_days_rows']=$this->vendor_model->marketing_notification_weaving_date_getsuborder($after_five);
		}
		else
		{
			$data['planning_order_rows'] =0;
			$data['pallning_outsource_rows']=0;
			$data['planned_dyeing_on_date_rows'] =0;
			$data['planned_dyeing_sevenn_days_rows'] =0;
			$data['planned_dyeing_five_days_rows']=0;
			$data['planned_weaving_on_date_rows'] =0;
			$data['planned_weaving_sevenn_days_rows'] =0;
			$data['planned_weaving_five_days_rows']=0;
			
		}
		
    	
		$p=$data['planning_order_rows'] + $data['pallning_outsource_rows'] + $data['planned_dyeing_on_date_rows'] + $data['planned_dyeing_sevenn_days_rows'] + $data['planned_dyeing_five_days_rows'] +  $data['planned_weaving_on_date_rows'] +  $data['planned_weaving_sevenn_days_rows'] + $data['planned_weaving_five_days_rows'] ;
		
		 return $p;
   }
     public function sample_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$emp_details=$this->vendor_model->get_customerdata($table,$where);
		
		if($emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin')
		{
			//
			$d=date('d-m-Y');
			$table='sample_request';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$sample_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
		else 
		{
			$sample_insert_rows=0;
			
		}
		
		if($emp_details->designation == 'Super Admin')
		{		
			$d=date('d-m-Y');
			$table='sample_request';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$sample_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
		else 
		{
			$sample_update_rows=0;
		}
		
		 $s= $sample_insert_rows + $sample_update_rows ;
		 return $s;
   }
    public function work_order_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'PPC Manager')
		{		
				 //
			$d=date('d-m-Y');
			$table='create_yarntwisting_work_order';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$data['work_order_twisting']=$this->vendor_model->count_amount_work_order_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='workorder_dyeing';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$data['work_order_dyeing']=$this->vendor_model->count_amount_work_order_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='workorder_dyeing_material';
			$where=array('approved_date'=>$d,'insert_notification_status'=>0);
			$data['issue_work_order_dyeing_material_rows']=$this->vendor_model->count_amount_work_order_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='finishing_embroidry';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$data['work_order_fabric_finishing']=$this->vendor_model->count_amount_work_order_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='work_order_twisting';
			$where=array('rec_date'=>$d,'insert_notification_status'=>0);
			$data['work_order_delivery_twisting_finishing']=$this->vendor_model->count_amount_work_order_delivery_twisting_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='work_order_dyeing';
			$where=array('rec_date'=>$d,'insert_notification_status'=>0);
			$data['work_order_delivery_dyeing_finishing']=$this->vendor_model->count_amount_work_order_delivery_dyed_get_customerdata($table,$where);
			
			
			$d=date('d-m-Y');
			$table='weaving_factory_stock';
			$where=array('rec_date'=>$d,'insert_notification_status'=>0);
			$data['work_order_delivery_weaving_finishing']=$this->vendor_model->count_amount_work_order_delivery_weaving_fabric_get_customerdata($table,$where);
			
			$d=date('d/m/Y');
			$table='finishing_embroidry_stock';
			$where=array('received_date'=>$d,'insert_notification_status'=>0);
			$data['work_order_delivery_finishing_finishing']=$this->vendor_model->count_amount_work_order_delivery_fabric_finishing_emp_get_customerdata($table,$where);
		}
		else
		{
			$data['work_order_twisting']=0;
			$data['work_order_dyeing']=0;
			 $data['work_order_fabric_finishing']=0;
			 $data['work_order_delivery_twisting_finishing']=0;
			 $data['work_order_delivery_dyeing_finishing']=0;
			 $data['work_order_delivery_weaving_finishing']=0;
			 $data['work_order_delivery_finishing_finishing']=0;
			 $data['issue_work_order_dyeing_material_rows']=0;
			 
		}
		
						
		$w=$data['work_order_twisting'] + $data['work_order_dyeing'] + $data['work_order_fabric_finishing'] + $data['work_order_delivery_twisting_finishing'] + $data['work_order_delivery_dyeing_finishing'] + $data['work_order_delivery_weaving_finishing'] + $data['work_order_delivery_finishing_finishing'] + $data['issue_work_order_dyeing_material_rows'];
		
		 return $w;
   }
     public function packing_page_notifications()
   {
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'Marketing' || $data['emp_details']->designation == 'MARKETING' || $data['emp_details']->designation == 'HO Marketing' || $data['emp_details']->designation == 'HO Marketing') 
		{
			$d=date('d/m/Y');
			$table='packing_list_data';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$package_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
						
			$d=date('d-m-Y');
			$table='packing_list_data';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$package_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d/m/Y');
			$table='madeups_list_data';
			$where=array('created_at'=>$d,'insert_notification_status'=>0);
			$package_madeups_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
		else
		{
			$package_insert_rows=0;
			$package_update_rows=0;
			$package_madeups_insert_rows=0;
		}
		
		 $packing= $package_insert_rows + $package_update_rows + $package_madeups_insert_rows;
		
		 return $packing;
   }
   
    public function design_weaving_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
			//
		if($data['emp_details']->designation == 'Super Admin') 
		{
				$d=date('d-m-Y');
				$table='design_weave';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$design_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
							
				$d=date('d-m-Y');
				$table='design_weave';
				$where=array('updated_on'=>$d,'update_notification_status'=>0);
				$design_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='design_weave';
				$where=array('finalized_date'=>$d,'finalize_notification_status'=>0);
				$design_finalize_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='design_weave';
				$where=array('approved_date'=>$d,'approval_notification_status'=>0);
				$design_approval_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
		else
		{
			$design_insert_rows=0;
			$design_update_rows=0;
			$design_finalize_rows=0;
			$design_approval_rows=0;
		}
	
		 $design= $design_insert_rows + $design_update_rows + $design_finalize_rows + $design_approval_rows;
		
		 return $design;
   }
   
    public function masters_page_notifications()
   {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
			//
		if($data['emp_details']->designation == 'Super Admin' ) 
		{
			$d=date('d-m-Y');
			$table='import_yarn';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$yarn_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='import_yarn';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$yarn_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
			$d=date('d-m-Y');
			$table='article_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$article_updated_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
					
			$d=date('d-m-Y');
			$table='fabric_master';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$fabric_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='fabric_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$fabric_upadted_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			
			$d=date('d-m-Y');
			$table='shade_master';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$shade_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='shade_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$shade_updated_row=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
			$d=date('d-m-Y');
			$table='color_master';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$color_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='color_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$color_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
			$d=date('d-m-Y');
			$table='customer_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$customer_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='box_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$box_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			
			
			$d=date('d-m-Y');
			$table='madeups_box_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$madeups_box_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
		
			$d=date('d-m-Y');
			$table='product_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$product_master_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		}
		else
		{
			$yarn_insert_rows=0;
			$yarn_insert_rows1=0;
			$article_updated_rows=0;
			$fabric_insert_rows=0;
			$fabric_upadted_rows=0;
			$shade_insert_rows=0;
			$shade_updated_row=0;
			$color_insert_rows=0;
			$color_insert_rows1=0;
			$customer_insert_rows1=0;
			$box_insert_rows1=0;
			$madeups_box_insert_rows1=0;
			$product_master_insert_rows1=0;
			
		}
		
		
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'MARKETING' || $data['emp_details']->designation == 'Marketing' || $data['emp_details']->designation == 'Marketing' || $data['emp_details']->designation == 'HO Marketing' || $data['emp_details']->designation == 'HO Marketing') 
	   {
		   $d=date('d-m-Y');
			$table='article_master';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$article_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='design_master';
			$where=array('created_date'=>$d,'insert_notification_status'=>0);
			$design_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
	   else
	   {
		   $article_insert_rows=0;
		   $design_insert_rows=0;
	   }
	   
	   if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'HO Purchase Admin') 
	   {
		   $d=date('d-m-Y');
			$table='indent_product';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$indent_product_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='indent_vendor_master';
			$where=array('updated_on'=>$d,'update_notification_status'=>0);
			$indent_vednor_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
	   }
	   else
	   {
		   $indent_product_insert_rows1=0;
		   $indent_vednor_insert_rows1=0;
	   }
	   
			
		 if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin')
		 {
				$d=date('d-m-Y');
				$table='design_master';
				$where=array('updated_on'=>$d,'update_notification_status'=>0);
				$design_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='customer_master';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$customer_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='box_master';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$box_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='madeups_box_master';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$madeups_box_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
					
				$d=date('d-m-Y');
				$table='outsource_vendor_master';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$outsource_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='outsource_vendor_master';
				$where=array('updated_on'=>$d,'update_notification_status'=>0);
				$outsource_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
						
				$d=date('d-m-Y');
				$table='indent_vendor_master';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$indent_vednor_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='indent_product';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$indent_product_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				$d=date('d-m-Y');
				$table='product_master';
				$where=array('created_date'=>$d,'insert_notification_status'=>0);
				$product_master_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		 }
		 else
		 {
			 $design_insert_rows1=0;
			 $customer_insert_rows=0;
			 $box_insert_rows=0;
			 $outsource_insert_rows=0;
			 $outsource_insert_rows1=0;
			 $indent_vednor_insert_rows=0;
			 $indent_product_insert_rows=0;
			 $product_master_insert_rows=0;
			 $madeups_box_insert_rows=0;
			 
		 }
		 
		
		$m=$yarn_insert_rows + $yarn_insert_rows1 + $article_insert_rows + $article_updated_rows + $fabric_insert_rows + $fabric_upadted_rows + $shade_updated_row + $design_insert_rows + $design_insert_rows1 + $color_insert_rows + $color_insert_rows1 + $customer_insert_rows + $customer_insert_rows1 + $box_insert_rows + $box_insert_rows1 + $outsource_insert_rows + $outsource_insert_rows1 + $indent_vednor_insert_rows + $indent_vednor_insert_rows1 + $indent_product_insert_rows + $indent_product_insert_rows1 + $product_master_insert_rows + $product_master_insert_rows1 + $madeups_box_insert_rows1 + $madeups_box_insert_rows; 
		
		
		 return $m;
   }
   public function madeups_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
			//
		if($data['emp_details']->designation == 'HO Madeups')
		{
			
				$d=date('d/m/Y');
				$table='fabric_madeups';
				$where=array('created_at'=>$d,'insert_notification_status'=>0);
				$madeups_list_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
							
				$d=date('d/m/Y');
				$table='consumable_madeups';
				$where=array('created_at'=>$d,'insert_notification_status'=>0);
				$madeups_list_madeups_insert_rows=$this->vendor_model->madeups_count_amount_get_customerdata($table,$where);
		}
		else
		{
			$madeups_list_insert_rows=0;
			$madeups_list_madeups_insert_rows=0;
		}
		if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive') 
		{ 
		
				$input=date('d/m/Y');
				
				$datee = explode('/', $input);
				
				$day = $datee[0];
				$month   = $datee[1];
				$year  = $datee[2];
				$rr=substr($month, 0, 1);
				$rr1=substr($month, 1, 2);

$rrr=substr($day, 0, 1);
				$rrr1=substr($day, 1, 2);

if($rr == '0' && $rrr == '0')
				{
					$t=$rrr1 . '/' . $rr1 . '/' . $year;
					//$t=$day . '/' . $rr1 . '/' . $year;
				
					$table='fabric_madeups_delivery_confirmation';
				$where=array('rec_date'=>$t,'insert_notification_status'=>0);
				$madeups_list_madeups_delivery_insert_rows=$this->vendor_model->madeups_count_amount_get_customerdata($table,$where);
				}
				else if($rr == '0' && $rrr != '0')
				{
					//$t=$rrr1 . '/' . $rr1 . '/' . $year;
					$t=$day . '/' . $rr1 . '/' . $year;
				
					$table='fabric_madeups_delivery_confirmation';
				$where=array('rec_date'=>$t,'insert_notification_status'=>0);
				$madeups_list_madeups_delivery_insert_rows=$this->vendor_model->madeups_count_amount_get_customerdata($table,$where);
				}
				else if($rr != '0' && $rrr == '0')
				{
					//$t=$rrr1 . '/' . $rr1 . '/' . $year;
					$t=$rrr1 . '/' . $month . '/' . $year;
				
					$table='fabric_madeups_delivery_confirmation';
				$where=array('rec_date'=>$t,'insert_notification_status'=>0);
				$madeups_list_madeups_delivery_insert_rows=$this->vendor_model->madeups_count_amount_get_customerdata($table,$where);
				}
				else if($rr != '0' && $rrr != '0')
				{
				$table='fabric_madeups_delivery_confirmation';
				$where=array('rec_date'=>$input,'insert_notification_status'=>0);
				$madeups_list_madeups_delivery_insert_rows=$this->vendor_model->madeups_count_amount_get_customerdata($table,$where);
				}
				
		}
		else
		{
			$madeups_list_madeups_delivery_insert_rows=0;
		}
		
	
		
		
					
		$madeups = $madeups_list_insert_rows + $madeups_list_madeups_insert_rows + $madeups_list_madeups_delivery_insert_rows;
		
		
		 return $madeups;
   }
  public function inward_purchases_notifications()
	  {
		$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='date_notification';
		$where=array('status'=>0);
		$date_wise_data=$this->vendor_model->get_customerdata($table,$where);
		$data['date_rel_data']=$this->vendor_model->get_customerdata($table,$where);
		$d=$date_wise_data->req_date;
	
		if($date_wise_data->module_status == 'old')
		{
		
			
			
			if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'PPC Manager' ) 
			{
				$table='indent_yarn_goods_details';
				$where=array('received_date'=>$d);
				$data['yarn_delivery_inserted_rows']=$this->vendor_model->yarn_delivery1_insert_getsuborder1($d);
				$data['yarn_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				//$d=date('d-m-Y');
				$table='indent_cs_goods_details';
				$where=array('received_date'=>$d);
				$data['cs_delivery_inserted_rows1']=$this->vendor_model->cs_delivery_insertt_getsuborder1($d);
				$data['cs_delivery_insert_rows1']=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				
				$newDate = date("d/m/Y", strtotime($d));
				//$d=date('d/m/Y');
				$table='indent_cs_goods_details';
				$where=array('received_date'=>$newDate);
				$data['cs_delivery_inserted_rows']=$this->vendor_model->cs_delivery_insertt_getsuborder1($newDate);
				$data['cs_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where);
				
				
					
					$input=$newDate;
				
				$datee = explode('/', $input);
				
				$day = $datee[0];
				$month   = $datee[1];
				$year  = $datee[2];

$rr=substr($month, 0, 1);
				$rr1=substr($month, 1, 2);

$rrr=substr($day, 0, 1);
				$rrr1=substr($day, 1, 2);

$t1=$rrr1 . '/' . $rr1 . '/' . $year;
					$table='indent_goods_details';
					$where=$t1;
					$where1=array('received_date'=>$t1);
					$data['fabric_delivery_inserted_rows1']=$this->vendor_model->fabric_delivery_goods_insertt_getsuborder1($where);
					$data['fabric_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
				
					$t2=$day . '/' . $rr1 . '/' . $year;
					$table='indent_goods_details';
					$where=$t2;
					$where1=array('received_date'=>$t2);
					$data['fabric_delivery_inserted_rows2']=$this->vendor_model->fabric_delivery_goods_insertt_getsuborder1($where);
					$data['fabric_delivery_insert_rows2']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
				
					$t3=$rrr1 . '/' . $month . '/' . $year;
					$table='indent_goods_details';
					$where=$t3;
					$where1=array('received_date'=>$t3);
					$data['fabric_delivery_inserted_rows3']=$this->vendor_model->fabric_delivery_goods_insertt_getsuborder1($where);
					$data['fabric_delivery_insert_rows3']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
				
				$table='indent_goods_details';
				$where=$input;
					$where1=array('received_date'=>$input);
				$data['fabric_delivery_inserted_rows4']=$this->vendor_model->fabric_delivery_goods_insertt_getsuborder1($where);
				$data['fabric_delivery_insert_rows4']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			}
			else
			{
				$data['yarn_delivery_insert_rows']=0;
				$data['cs_delivery_insert_rows1']=0;
				$data['cs_delivery_insert_rows']=0;
				$data['fabric_delivery_insert_rows']=0;
				$data['fabric_delivery_insert_rows2']=0;
				$data['fabric_delivery_insert_rows3']=0;
				$data['fabric_delivery_insert_rows4']=0;
			}
			
		}
		else 
		{
			
			if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'PPC Manager' ) 
			{
				
		//	$d=date('d-m-Y');
			$table='indent_yarn_goods_details';
			$where=array('received_date'=>$d,'insert_notification_status'=>0);
			$data['yarn_delivery_inserted_rows']=$this->vendor_model->yarn_delivery_insert_getsuborder1($d);
			$data['yarn_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			//$d=date('d-m-Y');
			$table='indent_cs_goods_details';
			$where=array('received_date'=>$d,'insert_notification_status'=>0);
			$data['cs_delivery_inserted_rows1']=$this->vendor_model->cs_delivery_insert_getsuborder1($d);
			$data['cs_delivery_insert_rows1']=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			
			$newDate = date("d/m/Y", strtotime($d));
			//$d=date('d/m/Y');
			$table='indent_cs_goods_details';
			$where=array('received_date'=>$newDate,'insert_notification_status'=>0);
			$data['cs_delivery_inserted_rows']=$this->vendor_model->cs_delivery_insert_getsuborder1($newDate);
			$data['cs_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			
				
				$input=$newDate;
			
			$datee = explode('/', $input);
			
			$day = $datee[0];
			$month   = $datee[1];
			$year  = $datee[2];

$rr=substr($month, 0, 1);
			$rr1=substr($month, 1, 2);

$rrr=substr($day, 0, 1);
			$rrr1=substr($day, 1, 2);

$data['total_res_inward_fabric']=$data['fabric_delivery_insert_rows'] + $data['fabric_delivery_insert_rows2'] + $data['fabric_delivery_insert_rows3'] + $data['fabric_delivery_insert_rows4']  + $data['yarn_delivery_insert_rows'] + $data['cs_delivery_insert_rows'] + $data['cs_delivery_insert_rows1'];
		
		
		$data['page_static']='inward_purchase'; 
		$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];$data['access'] = $this->access_details();
			$data['userdetails'] = $this->session_data_pass();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$rr=substr($month, 0, 1);
			$rr1=substr($month, 1, 2);

$rrr=substr($day, 0, 1);
			$rrr1=substr($day, 1, 2);

$t1=$rrr1 . '/' . $rr1 . '/' . $year;
				$table='indent_goods_details';
				$where=$t1;
				$where1=array('received_date'=>$t1,'insert_notification_status'=>0);
				$data['fabric_delivery_inserted_rows1']=$this->vendor_model->fabric_delivery_goods_insert_getsuborder1($where);
				$data['fabric_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			
				$t2=$day . '/' . $rr1 . '/' . $year;
				$table='indent_goods_details';
				$where=$t2;
				$where1=array('received_date'=>$t2,'insert_notification_status'=>0);
				$data['fabric_delivery_inserted_rows2']=$this->vendor_model->fabric_delivery_goods_insert_getsuborder1($where);
				$data['fabric_delivery_insert_rows2']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			
				$t3=$rrr1 . '/' . $month . '/' . $year;
				$table='indent_goods_details';
				$where=$t3;
				$where1=array('received_date'=>$t3,'insert_notification_status'=>0);
				$data['fabric_delivery_inserted_rows3']=$this->vendor_model->fabric_delivery_goods_insert_getsuborder1($where);
				$data['fabric_delivery_insert_rows3']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			
			$table='indent_goods_details';
			$where=$input;
				$where1=array('received_date'=>$input,'insert_notification_status'=>0);
			$data['fabric_delivery_inserted_rows4']=$this->vendor_model->fabric_delivery_goods_insert_getsuborder1($where);
			$data['fabric_delivery_insert_rows4']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
		
		
		
		$new=$data['fabric_delivery_insert_rows'] + $data['fabric_delivery_insert_rows2'] + $data['fabric_delivery_insert_rows3'] + $data['fabric_delivery_insert_rows4'] +  $data['yarn_delivery_insert_rows'] + $data['cs_delivery_insert_rows'] + $data['cs_delivery_insert_rows1'];
		
			
	//	$new = $fabric_inpection_insert_rows + $fabric_delivery_insert_rows +  $yarn_delivery_insert_rows + $cs_delivery_insert_rows;
		// print_r($new);
		// die();
		
		 return $new;
		 }
		  public function new_stores_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		$table='date_notification';
		$where=array('status'=>0);
		$date_wise_data=$this->vendor_model->get_customerdata($table,$where);
		$data['date_rel_data']=$this->vendor_model->get_customerdata($table,$where);
		$d=$date_wise_data->req_date;
				//
			if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' ) 
			{				//$d=date('d-m-Y');
				$table='fabric_inspection';
				$where=$d;
				$where1=array('created_date'=>$d,'insert_notification_status'=>0);
				$data['fabric_inspection_inserted_rows']=$this->vendor_model->fabric_inspection_update_getsuborder1($where);
				$data['fabric_inspection_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			}
			else
			{
				$data['fabric_inspection_inserted_rows']=array();
				$data['fabric_inspection_rows']=0;
			}
			
			
		
		
		$new= $data['fabric_inspection_rows'] ;
		
			
	//	$new = $fabric_inpection_insert_rows + $fabric_delivery_insert_rows +  $yarn_delivery_insert_rows + $cs_delivery_insert_rows;
		// print_r($new);
		// die();
		
		 return $new;
		 }
		 
		 public function fabric_inspection_notifications()
	  {
		   $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='date_notification';
		$where=array('status'=>0);
		$date_wise_data=$this->vendor_model->get_customerdata($table,$where);
		$data['date_rel_data']=$this->vendor_model->get_customerdata($table,$where);
		$d=$date_wise_data->req_date;
	if($date_wise_data->module_status == 'old')
		{
			if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' ) 
			{			//$d=date('d-m-Y');
				$table='fabric_inspection';
				$where=$d;
				$where1=array('created_date'=>$d);
				$data['fabric_inspection_inserted_rows']=$this->vendor_model->fabric_inspections_update_getsuborder1($where);
				$data['fabric_inspection_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			}
			else
			{
				$data['fabric_inspection_inserted_rows']=array();
				$data['fabric_inspection_rows']=0;
			}
			
			
		
			
		}
		else 
		{
			if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' ) 
			{				//$d=date('d-m-Y');
				$table='fabric_inspection';
				$where=$d;
				$where1=array('created_date'=>$d,'insert_notification_status'=>0);
				$data['fabric_inspection_inserted_rows']=$this->vendor_model->fabric_inspection_update_getsuborder1($where);
				$data['fabric_inspection_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where1);
			}
			else
			{
				$data['fabric_inspection_inserted_rows']=array();
				$data['fabric_inspection_rows']=0;
			}
			
			
		
		}

$data['total_res_fabric']= $data['fabric_inspection_rows'] ;
		
		
		$data['page_static']='fabric_inspection'; 
		$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];$data['access'] = $this->access_details();
			$data['userdetails'] = $this->session_data_pass();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$access_menu_id=$this->access_details_id();

$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function fabric_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
          $RT  = substr($uri, strpos($uri, "/") + 12);
       
        
        if($RT == 'rec_stock/fabric_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/fabric_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/fabric_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/fabric_rec_stock_grid?prop_id=1';
             
             $data['url_val']='2';
             
               $data['ref']='today_dashboard';
			  
        }
       else if($RT == 'rec_stock/fabric_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/fabric_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
			   
		
        }
		else if($RT == 'rec_stock/fabric_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/fabric_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
			
        }
        
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();
		   
		 $m_id=unserialize($access_menu_id->menu_id);
                   $check="";
                   foreach($m_id as $menu_id)
                   {
                           
                           $table='swansilk_menu';
                           $where=array('delete_status'=>'ACTIVE','menu_id'=>$menu_id);
                           $result= $this->marketing_model->fetch_main_data($table,$where);
                           if(!empty($result->reference_url)){
                           if($result->reference_url == $data['val'])
                           {
                                   $check=$data['val'];
                           }
                           }
                           
					}
           if($check != "")
           {
			   
			   //
			    $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
				$table='consumed_at';
				$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
				$data['yarn_type']='fabric';
				$table1='purchase_master';
				$data['producttype']=$this->vendor_model->fetch_where_data($table1);

$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function yarn_raw_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
         $RT  = substr($uri, strpos($uri, "/") + 12);
       
        if($RT == 'rec_stock/yarn_raw_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/yarn_raw_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/yarn_raw_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/yarn_raw_rec_stock_grid?prop_id=1';
            $data['url_val']='2';
             $data['ref']='today_dashboard';
		}
       else if($RT == 'rec_stock/yarn_raw_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/yarn_raw_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
		}
		else if($RT == 'rec_stock/yarn_raw_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/yarn_raw_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
		}                  
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						 if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						 }
						}
				   }
				//----------tiill--------------------
			
			$table='consumed_at';
			$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
			$data['yarn_type']='raw';
			$table1='purchase_master';
			$data['producttype']=$this->vendor_model->fetch_where_data($table1);
	
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

// $access_menu_id=$this->access_details_id();

}
public function yarn_twisting_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
      $RT  = substr($uri, strpos($uri, "/") + 12);
       
        if($RT == 'rec_stock/yarn_twisting_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/yarn_twisting_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/yarn_twisting_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/yarn_twisting_rec_stock_grid?prop_id=1';
            $data['url_val']='2';
             $data['ref']='today_dashboard';
		}
       else if($RT == 'rec_stock/yarn_twisting_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/yarn_twisting_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
		}
		else if($RT == 'rec_stock/yarn_twisting_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/yarn_twisting_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
		}              
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();
		   
		 $m_id=unserialize($access_menu_id->menu_id);
                   $check="";
                   foreach($m_id as $menu_id)
                   {
                           
                           $table='swansilk_menu';
                           $where=array('delete_status'=>'ACTIVE','menu_id'=>$menu_id);
                           $result= $this->marketing_model->fetch_main_data($table,$where);
                            if(!empty($result->reference_url)){
                           if($result->reference_url == $data['val'])
                           {
                                   $check=$data['val'];
                           }
                            }
                           
					}
           if($check != "")
           {
			   
			   //
			    $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
			$table='consumed_at';
			$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
			$data['yarn_type']='twist';
			$table1='purchase_master';
			$data['producttype']=$this->vendor_model->fetch_where_data($table1);
	
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

// $access_menu_id=$this->access_details_id();

}

public function stock_yarn_raw_details()
{		
     $get = $this->uri->segment(3);
	 $fromdate=$this->input->get('fromdate');
    $enddate=$this->input->get('enddate');
	// print_r($enddate);die();

$table='yarn_transfer';
	$update=$this->stock_model->get_transfer_Update($table);

$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);

// $update=$this->stock_model->get_transfer_Update($table);
		// if($update){
			$where=array('status'=>1,'yarn_type'=>'raw');
			$detail=$this->stock_model->get_transfer_data_from_to($table,$where,$fromdate,$enddate);
		// }

}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='yarn_transfer';
        $detail=$this->vendor_model->monthly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$m,$y,$p);
	}
		else if($get == 'syear_dashboard')
	{
	    
	     $table='yarn_transfer';
         $detail=$this->vendor_model->yearly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$y,$p);
	}
	
	
		echo json_encode($detail);
	
}

public function stock_yarn_raw_details_old()
{		
     $get = $this->uri->segment(3);
     
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'raw');
		$detailll=$this->stock_model->get_transfer_data($table,$where);
		
		foreach($detailll as $d)
		{
			$table='yarn_transfer';
			$t_id=$d->transfer_id_val;
			$where=array('transfer_id_val'=>$t_id,'confirm'=>'Yes');
			$det=$this->stock_model->get_data($table,$where);
			
			$table='yarn_transfer';
			$t_id=$d->transfer_id_val;
			$where=array('transfer_id_val'=>$t_id,'confirm'=>'No');
			$det_no=$this->stock_model->get_data($table,$where);
			
			
			if(empty($det))
			{
				$table='yarn_transfer';
				$data=array('grid_status'=>'NOT YET');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			else if(empty($det_no))
			{
				$table='yarn_transfer';
				$data=array('grid_status'=>'COMPLETED');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			else
			{
				$table='yarn_transfer';
				$data=array('grid_status'=>'PARTLY');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			
		}

$m=date('m');
		$y=date('Y');
		$p='Yarn - Raw';
		
	if($get == 'stoday_dashboard')
	{
        $d1=date('d-m-Y');
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'raw','rec_date'=>$d1);
		$detail=$this->vendor_model->get_transfer_data($table,$where);
	}
	else if($get == 'sindent')
	{
	    
	    $table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'raw');
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='yarn_transfer';
        $detail=$this->vendor_model->monthly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$m,$y,$p);
	}
		else if($get == 'syear_dashboard')
	{
	    
	     $table='yarn_transfer';
         $detail=$this->vendor_model->yearly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$y,$p);
	}
	
	
		echo json_encode($detail);
	
}

public function yarn_dyed_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
       $RT  = substr($uri, strpos($uri, "/") + 12);
       
        if($RT == 'rec_stock/yarn_dyed_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/yarn_dyed_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/yarn_dyed_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/yarn_dyed_rec_stock_grid?prop_id=1';
            $data['url_val']='2';
             $data['ref']='today_dashboard';
		}
       else if($RT == 'rec_stock/yarn_dyed_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/yarn_dyed_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
		}
		else if($RT == 'rec_stock/yarn_dyed_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/yarn_dyed_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
		}         
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
			$table='consumed_at';
			$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
			$data['yarn_type']='dyed';
			$table1='purchase_master';
			$data['producttype']=$this->vendor_model->fetch_where_data($table1);
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

// $access_menu_id=$this->access_details_id();

}
public function swan_dyed_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
         $RT  = substr($uri, strpos($uri, "/") + 12);
       
        if($RT == 'rec_stock/swan_dyed_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/swan_dyed_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/swan_dyed_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/swan_dyed_rec_stock_grid?prop_id=1';
            $data['url_val']='2';
             $data['ref']='today_dashboard';
		}
       else if($RT == 'rec_stock/swan_dyed_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/swan_dyed_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
		}
		else if($RT == 'rec_stock/swan_dyed_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/swan_dyed_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
		}            
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
			$table='consumed_at';
			$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
			$data['yarn_type']='swan';
			$table1='purchase_master';
			$data['producttype']=$this->vendor_model->fetch_where_data($table1);
	
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

// $access_menu_id=$this->access_details_id();

}
public function cosumable_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $RT  = substr($uri, strpos($uri, "/") + 12);
       
        
        if($RT == 'rec_stock/cosumable_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/cosumable_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/cosumable_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/cosumable_rec_stock_grid?prop_id=1';
             
             $data['url_val']='2';
             
               $data['ref']='today_dashboard';
		
        }
       else if($RT == 'rec_stock/cosumable_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/cosumable_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
			   
			 
        }
		else if($RT == 'rec_stock/cosumable_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/cosumable_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
			   
			  
        }
              
              
                
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
			$table='consumed_at';
		$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
	$data['yarn_type']='consumable';
	$table1='purchase_master';
	$data['producttype']=$this->vendor_model->fetch_where_data($table1);
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

// $access_menu_id=$this->access_details_id();

}

public function spares_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
          $RT  = substr($uri, strpos($uri, "/") + 12);
       
        
        if($RT == 'rec_stock/spares_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/spares_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/spares_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/spares_rec_stock_grid?prop_id=1';
             
             $data['url_val']='2';
             
               $data['ref']='today_dashboard';
		
        }
       else if($RT == 'rec_stock/spares_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/spares_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
			   
			 
        }
		else if($RT == 'rec_stock/spares_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/spares_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
			   
			  
        }
              
              
                
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
				$table='consumed_at';
		$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
	$data['yarn_type']='spares';
	$table1='purchase_master';
	$data['producttype']=$this->vendor_model->fetch_where_data($table1);
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

// $access_menu_id=$this->access_details_id();

}
public function rec_cs_details()
{		
    $get = $this->uri->segment(3);
    
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Consumables');
		$detailll =$this->stock_model->get_transfer_data($table,$where);
		
		foreach($detailll as $d)
		{
			$table='cs_transfer';
			$t_id=$d->transfer_id_val;
			$where=array('transfer_id_val'=>$t_id,'confirm'=>'Yes');
			$det=$this->stock_model->get_data($table,$where);
			
			$table='cs_transfer';
			$t_id=$d->transfer_id_val;
			$where=array('transfer_id_val'=>$t_id,'confirm'=>'No');
			$det_no=$this->stock_model->get_data($table,$where);
			
			
			if(empty($det))
			{
				$table='cs_transfer';
				$data=array('grid_status'=>'NOT YET');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			else if(empty($det_no))
			{
				$table='cs_transfer';
				$data=array('grid_status'=>'COMPLETED');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			else
			{
				$table='cs_transfer';
				$data=array('grid_status'=>'PARTLY');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			
		}
		
		$m=date('m');
		$y=date('Y');
	
		
	if($get == 'stoday_dashboard')
	{
        $d1=date('d-m-Y');
			$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Consumables','rec_date'=>$d1);
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
	else if($get == 'sindent')
	{
	    
	    	$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Consumables');
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='indent_po';
        $p='Consumables';
        $detail=$this->vendor_model->monthly_stock_rec_stock_cs_res_dashboard_po_list_id($table,$m,$y,$p);
	}
		else if($get == 'syear_dashboard')
	{
	    
	    $table='indent_po';
        $p='Consumables';
        $detail=$this->vendor_model->yearly_stock_rec_stock_cs_res_dashboard_po_list_id($table,$y,$p);
	}
	
	
	
		echo json_encode($detail);
	
}
public function rec_spares_details()
{	
     $get = $this->uri->segment(3);
     
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Spares');
		$detailll =$this->stock_model->get_transfer_data($table,$where);
		
		foreach($detailll as $d)
		{
			$table='cs_transfer';
			$t_id=$d->transfer_id_val;
			$where=array('transfer_id_val'=>$t_id,'confirm'=>'Yes');
			$det=$this->stock_model->get_data($table,$where);
			
			$table='cs_transfer';
			$t_id=$d->transfer_id_val;
			$where=array('transfer_id_val'=>$t_id,'confirm'=>'No');
			$det_no=$this->stock_model->get_data($table,$where);
			
			
			if(empty($det))
			{
				$table='cs_transfer';
				$data=array('grid_status'=>'NOT YET');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			else if(empty($det_no))
			{
				$table='cs_transfer';
				$data=array('grid_status'=>'COMPLETED');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			else
			{
				$table='cs_transfer';
				$data=array('grid_status'=>'PARTLY');
				$where=array('transfer_id_val'=>$t_id);
				$det=$this->stock_model->update_data($where,$table,$data);
			}
			
		}

$m=date('m');
		$y=date('Y');
	
		
	if($get == 'stoday_dashboard')
	{
        $d1=date('d-m-Y');
			$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Spares','rec_date'=>$d1);
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
	else if($get == 'sindent')
	{
	    
	    	$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Spares');
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='indent_po';
        $p='Spares';
        $detail=$this->vendor_model->monthly_stock_rec_stock_cs_res_dashboard_po_list_id($table,$m,$y,$p);
	}
		else if($get == 'syear_dashboard')
	{
	    
	    $table='indent_po';
        $p='Spares';
        $detail=$this->vendor_model->yearly_stock_rec_stock_cs_res_dashboard_po_list_id($table,$y,$p);
	}
	
	
		echo json_encode($detail);
	
}
public function stock_transfer_details()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$data['user_type_id'] = $this->access_id();
			$data['access'] = $this->access_details();
			$data['userdetails'] = $this->session_data_pass();
			$data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['access'] = $this->access_details();

$access_menu_id=$this->access_details_id();

$table='consumed_at';
		$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
	
	$table1='purchase_master';
	$data['producttype']=$this->vendor_model->fetch_where_data($table1);
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$access_menu_id=$this->access_details_id();

$id=$this->session->userdata('logged_in');
$where=array('id'=>$id);
$data['approved_by']=$id['username'];
		
$emp_row=$id['userid'];
$table='chat_message';
$where=array('unread'=>'0','to_id'=>$emp_row);
$data['chatting_count']=$this->vendor_model->count_amount_work_order_delivery_yarn_po_get_customerdata($table,$where);
	
			$this->load->view('templates/header_inside',$data);
			$this->load->view('stock/stcok_received_grid',$data);
			$this->load->view('templates/footer_inside');
}
public function fetch_stock_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$data3=$this->input->post('ids');
	//$data2=$this->input->post('product_type');
	
		$data1=substr($data3, 0, -1);
		$exp=array();
		$path = explode("|", $data1);
		$exp = array_merge($exp, $path);
	
		$data11=array();
		foreach($exp as $val)
		{
			
			$data2=$this->input->post('product_type');
		
			if($data2 == 'Fabrics')
			 {
				
				$table='fabric_inspection_details';
				$where=$val;
				$details=$this->store_model->fetch_where_fabric_row_data($where);
				array_push($data11,$details);
			 }
			  else if($data2 == 'Yarn - Raw')
			  {
				  $where=$val;
				$details = $this->store_model->get_stock_transfer_yarnraw_row_data($where);
				array_push($data11,$details);
			  }
			 else if($data2 == 'Yarn - Twisted')
			 {
				$table='delivery_yarn_twisting';
				 $where=$val;
				$details= $this->store_model->get_stock_transfer_yarntwisting_row_data($table,$where);
				array_push($data11,$details);
			 }
			 else if($data2 == 'Yarn - Dyed')
			 {
				 $where=$val;
				$details = $this->store_model->get_stock_transfer_yarndyed_row_data($where);
				array_push($data11,$details);
			 }
			else if($data2 == 'Consumables')
			 {
				$table='indent_po';
				$where=$val;
				$details=$this->store_model->get_stock_transfer_consumable_row_data($where);
				array_push($data11,$details);
			 }
			 else if($data2 == 'Spares')
			 {
					$table='indent_po';
					 $where=$val;
					$details=$this->store_model->get_stock_transfer_spares_row_data($where);
					array_push($data11,$details);
			 }
			  else if($data2 == 'swan_yarn_dyed')
			 {
					$table='work_order_dyeing';
					 $where=$val;
					$details=$this->store_model->get_stock_transfer_loca_swandyed_row_data($table,$where);
					array_push($data11,$details);
			 }
		}
		$result=$data11;
		// print_r($result);
		// die();
		echo json_encode($result);
		
		
	}
	public function add_transfer_application_form()
	{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$data2=$this->input->post('product_type');
		$product_location=$this->input->post('product_location');
		$transfer_location=$this->input->post('transfer_location');
		$transfer_date=$this->input->post('transfer_date');
		$transfer_by=$this->input->post('transfer_by');
		$remarks=$this->input->post('remarks');
		$transfer_id=$this->input->post('transfer_id');
		
		if($data2 == 'Fabrics')
		{
			
		
			$fabric_id=$this->input->post('fabric_id');
			$fabric_po=$this->input->post('fabric_po');
			$fabric_ssl=$this->input->post('fabric_ssl');
			$fabric_product=$this->input->post('fabric_product');
			$fabric_width=$this->input->post('fabric_width');
			$fabric_design=$this->input->post('fabric_design');
			$fabric_shades=$this->input->post('fabric_shades');
			$fabric_rec_weight=$this->input->post('fabric_rec_weight');
			$fabric_balanced_mtrs=$this->input->post('fabric_balanced_mtrs');
			$fabric_issue_weight=$this->input->post('fabric_issue_weight');
			$fabric_issue_mtrs=$this->input->post('fabric_issue_mtrs');
			$fabric_remaining_weight=$this->input->post('fabric_remaining_weight');
			$fabric_remaining_mtrs=$this->input->post('fabric_remaining_mtrs');
			
			foreach($fabric_id as $key=>$val)
			{
				$data=array('fabric_id'=>$fabric_id[$key],
					'po'=>$fabric_po[$key],
					'ssl_piece_no'=>$fabric_ssl[$key],
					'product'=>$fabric_product[$key],
					'width'=>$fabric_width[$key],
					'design'=>$fabric_design[$key],
					'shades'=>$fabric_shades[$key],
					'rec_weight'=>$fabric_rec_weight[$key],
					'actual_qua'=>$fabric_balanced_mtrs[$key],
					
					'issue_weight'=>$fabric_issue_weight[$key],
					'issue_mtrs'=>$fabric_issue_mtrs[$key],
					'bal_wight'=>$fabric_remaining_weight[$key],
					
					'bal_qua'=>$fabric_remaining_mtrs[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'transfer_id'=>$this->input->post('transfer_id'),
					'status'=>'1',
					);
			$table='fabric_transfer';
			$this->db->insert($table,$data);
			
			$table='fabric_inspection_details';
			$where=array('id'=>$fabric_id[$key]);
			$data=array('rec_weight'=>$fabric_remaining_weight[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			
			$table='fabric_inspection';
			$where=array('goods_id'=>$fabric_id[$key]);
			$data=array('balanced_mtrs'=>$fabric_remaining_mtrs[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			
			}
		}
		 else if($data2 == 'Yarn - Raw')
		 {
			 $raw_id=$this->input->post('raw_id');
			$raw_purpose=$this->input->post('raw_purpose');
			$raw_yarnname=$this->input->post('raw_yarnname');
			$raw_yarndenier=$this->input->post('raw_yarndenier');
			$raw_yarnspec=$this->input->post('raw_yarnspec');
			$raw_lot=$this->input->post('raw_lot');
			$raw_bale=$this->input->post('raw_bale');
			$raw_gross=$this->input->post('raw_gross');
			$raw_net=$this->input->post('raw_net');
			$raw_issue_net=$this->input->post('raw_issue_net');
			$raw_bal_net=$this->input->post('raw_bal_net');
			
			 foreach($raw_id as $key=>$val)
			{
				$data=array('refrence_id'=>$raw_id[$key],
					'purpose'=>$raw_purpose[$key],
					'yarnname'=>$raw_yarnname[$key],
					'yarndenier'=>$raw_yarndenier[$key],
					'yarnspec'=>$raw_yarnspec[$key],
					'lot'=>$raw_lot[$key],
					'bale'=>$raw_bale[$key],
					'gross'=>$raw_gross[$key],
					'net_weight'=>$raw_net[$key],
					'issue_net_weight'=>$raw_issue_net[$key],
					'bal_net_weight'=>$raw_bal_net[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'transfer_id'=>$this->input->post('transfer_id'),
					'status'=>'1',
					'yarn_type'=>'raw',
					);
			$table='yarn_transfer';
			$this->db->insert($table,$data);
			
			$table='indent_yarn_goods_details';
			$where=array('id'=>$raw_id[$key]);
			$data=array('issue_net_weight'=>$raw_bal_net[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			}
			
		 }
		else if($data2 == 'Yarn - Twisted')
		{
		   $t_id=$this->input->post('t_id');
			$t_purpose=$this->input->post('t_purpose');
			$t_name=$this->input->post('t_name');
			$t_den=$this->input->post('t_den');
			$t_spec=$this->input->post('t_spec');
			$t_shades=$this->input->post('t_shade');
			$t_lot=$this->input->post('t_lot');
			$t_bale=$this->input->post('t_bale');
			$t_gross=$this->input->post('t_gross');
			$t_net=$this->input->post('t_net');
			$t_issue_net=$this->input->post('t_issue_net');
			$t_bal_net=$this->input->post('t_bal_net');
			
			foreach($t_id as $key=>$val)
			{
				$data=array('refrence_id'=>$t_id[$key],
					'purpose'=>$t_purpose[$key],
					'yarnname'=>$t_name[$key],
					'yarndenier'=>$t_den[$key],
					'yarnspec'=>$t_spec[$key],
					'shade'=>$t_shades[$key],
					'lot'=>$t_lot[$key],
					'bale'=>$t_bale[$key],
					'gross'=>$t_gross[$key],
					'net_weight'=>$t_net[$key],
					'issue_net_weight'=>$t_issue_net[$key],
					'bal_net_weight'=>$t_bal_net[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'status'=>'1',
					'transfer_id'=>$this->input->post('transfer_id'),
					'yarn_type'=>'twisting',
					);
			$table='yarn_transfer';
			$this->db->insert($table,$data);
			
			$table='delivery_yarn_twisting';
			$where=array('id'=>$t_id[$key]);
			$data=array('issue_net_weight'=>$t_bal_net[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			}
		}
	
		else if($data2 == 'Yarn - Dyed')
		{
			 $d_id=$this->input->post('d_id');
			$d_purpose=$this->input->post('d_purpose');
			$d_name=$this->input->post('d_name');
			$d_den=$this->input->post('d_den');
			$d_spec=$this->input->post('d_spec');
			$d_shade=$this->input->post('d_shade');
			$d_code=$this->input->post('d_code');
			$d_lot=$this->input->post('d_lot');
			$d_bale=$this->input->post('d_bale');
			$d_gross=$this->input->post('d_gross');
			$d_net=$this->input->post('d_net');
			$d_issue_net=$this->input->post('d_issue_net');
			$d_bal_net=$this->input->post('d_bal_net');
			
			foreach($d_id as $key=>$val)
			{
				$data=array('refrence_id'=>$d_id[$key],
					'purpose'=>$d_purpose[$key],
					'yarnname'=>$d_name[$key],
					'yarndenier'=>$d_den[$key],
					'yarnspec'=>$d_spec[$key],
					'shade'=>$d_shade[$key],
					'color_code'=>$d_code[$key],
					'lot'=>$d_lot[$key],
					'bale'=>$d_bale[$key],
					'gross'=>$d_gross[$key],
					'net_weight'=>$d_net[$key],
					'issue_net_weight'=>$d_issue_net[$key],
					'bal_net_weight'=>$d_bal_net[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'transfer_id'=>$this->input->post('transfer_id'),
					'status'=>'1',
					'yarn_type'=>'dyed',
					);
			$table='yarn_transfer';
			$this->db->insert($table,$data);
			
			$table='indent_yarn_goods_details';
			$where=array('id'=>$d_id[$key]);
			$data=array('issue_net_weight'=>$d_bal_net[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			
			}
		}
		
		else if($data2 == 'Consumables')
		{
			 $cs_id=$this->input->post('cs_id');
			$cs_po=$this->input->post('cs_po');
			$cs_product=$this->input->post('cs_product');
			$cs_indent=$this->input->post('cs_indent');
			$cs_dept=$this->input->post('cs_dept');
			$cs_quantity=$this->input->post('cs_quantity');
			$cs_total_quantity=$this->input->post('cs_total_quantity');
			$cs_issue_quantity=$this->input->post('cs_issue_quantity');
			$cs_remaining_quantity=$this->input->post('cs_remaining_quantity');
			
			
			foreach($cs_id as $key=>$val)
			{
				$data=array('refrence_id'=>$cs_id[$key],
					'po_no'=>$cs_po[$key],
					'product'=>$cs_product[$key],
					'indent_no'=>$cs_indent[$key],
					'dept'=>$cs_dept[$key],
					'ordered_qua'=>$cs_quantity[$key],
					'total_qua'=>$cs_total_quantity[$key],
					'issue_qua'=>$cs_issue_quantity[$key],
					'bal_qua'=>$cs_remaining_quantity[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'ref_type'=>'consumable',
					'transfer_id'=>$this->input->post('transfer_id'),
					'status'=>'1',
					);
			$table='cs_transfer';
			$this->db->insert($table,$data);
			
			$table='indent_po';
			$where=array('id'=>$cs_id[$key]);
			$data=array('total_quantity'=>$cs_remaining_quantity[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			
			}
		}
		else if($data2 == 'Spares')
		{
			 $cs_id=$this->input->post('cs_id');
			$cs_po=$this->input->post('cs_po');
			$cs_product=$this->input->post('cs_product');
			$cs_indent=$this->input->post('cs_indent');
			$cs_dept=$this->input->post('cs_dept');
			$cs_quantity=$this->input->post('cs_quantity');
			$cs_total_quantity=$this->input->post('cs_total_quantity');
			$cs_issue_quantity=$this->input->post('cs_issue_quantity');
			$cs_remaining_quantity=$this->input->post('cs_remaining_quantity');
			
			
			foreach($cs_id as $key=>$val)
			{
				$data=array('refrence_id'=>$cs_id[$key],
					'po_no'=>$cs_po[$key],
					'product'=>$cs_product[$key],
					'indent_no'=>$cs_indent[$key],
					'dept'=>$cs_dept[$key],
					'ordered_qua'=>$cs_quantity[$key],
					'total_qua'=>$cs_total_quantity[$key],
					'issue_qua'=>$cs_issue_quantity[$key],
					'bal_qua'=>$cs_remaining_quantity[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'status'=>'1',
					'transfer_id'=>$this->input->post('transfer_id'),
					'ref_type'=>'spares',
					);
			$table='cs_transfer';
			$this->db->insert($table,$data);
			
			$table='indent_po';
			$where=array('id'=>$cs_id[$key]);
			$data=array('total_quantity'=>$cs_remaining_quantity[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			}
		}
		 else if($data2 == 'swan_yarn_dyed')
		 {
			  $s_id=$this->input->post('s_id');
			$s_purpose=$this->input->post('s_purpose');
			$s_issue_no=$this->input->post('s_issue_no');
			$s_quantity=$this->input->post('s_quantity');
			$s_spec=$this->input->post('s_spec');
			$s_den=$this->input->post('s_den');
			$s_shade=$this->input->post('s_shade');
			$s_code=$this->input->post('s_code');
			$s_dyed_q=$this->input->post('s_dyed_q');
			$s_issue_dyed_q=$this->input->post('s_issue_dyed_q');
			$s_bal_dyed_q=$this->input->post('s_bal_dyed_q');
			
			
			foreach($s_id as $key=>$val)
			{
				$data=array('refrence_id'=>$s_id[$key],
					'purpose'=>$s_purpose[$key],
					'issue_no'=>$s_issue_no[$key],
					'yarnname'=>$s_quantity[$key],
					'yarndenier'=>$s_spec[$key],
					'yarnspec'=>$s_den[$key],
					'shade'=>$s_shade[$key],
					'color_code'=>$s_code[$key],
					'dyed_weight'=>$s_dyed_q[$key],
					'issue_dyed_weight'=>$s_issue_dyed_q[$key],
					'bal_dyed_weight'=>$s_bal_dyed_q[$key],
					
					'product_type' => $this->input->post('product_type'),
					'product_location' => $this->input->post('product_location'),
					'transfer_location' => $this->input->post('transfer_location'),
					'transfer_date' => $this->input->post('transfer_date'),
					'transfer_by' => $this->input->post('transfer_by'),
					'remarks'=>$this->input->post('remarks'),
					'transfer_id'=>$this->input->post('transfer_id'),
					'status'=>'1',
					);
			$table='swan_yarn_transfer';
			$this->db->insert($table,$data);
			
			$table='work_order_dyeing';
			$where=array('id'=>$s_id[$key]);
			$data=array('rec_dyed_qua'=>$s_bal_dyed_q[$key]);
			$this->vendor_model->update_access($where,$table,$data);
			}
		 }
	}
	
public function fabric_details()
{		
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='fabric_transfer';
		$where=array('status'=>1);
		$detail=$this->stock_model->get_transfer_data($table,$where);
		echo json_encode($detail);
	
}
public function swan_yarn_details()
{	$get = $this->uri->segment(3);

$fromdate=$this->input->get('fromdate');
    $enddate=$this->input->get('enddate');

$table='swan_yarn_transfer';
	$update=$this->stock_model->get_transfer_Update($table);

$m=date('m');
		$y=date('Y');
	
		
	if($get == 'stoday_dashboard')
	{
        $d1=date('d-m-Y');
		$table='yarn_transfer';
		$where=array('status'=>1,'transfer_date'=>$d1);
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
	else if($get == 'sindent')
	{
	    
	   	$table='swan_yarn_transfer';
		// $update=$this->stock_model->get_transfer_Update($table);
		$where=array('status'=>1);
		$detail=$this->stock_model->get_transfer_data_from_to($table,$where,$fromdate,$enddate);
	}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='yarn_transfer';
        $detail=$this->vendor_model->swan_monthly_stock_rec_result_swan_yarn_dashboard_po_list_id1($table,$m,$y);
	}
		else if($get == 'syear_dashboard')
	{
	    
	     $table='yarn_transfer';
         $detail=$this->vendor_model->swan_yearly_stock_rec_result_swan_yarn_dashboard_po_list_id1($table,$y);
	}
	
		echo json_encode($detail);
	
}
public function cs_details()
{		
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Consumables');
		$detail=$this->stock_model->get_transfer_data($table,$where);
		echo json_encode($detail);
	
}
public function spares_details()
{		
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Spares');
		$detail=$this->stock_model->get_transfer_data($table,$where);
		echo json_encode($detail);
	
}
public function yarn_raw_details()
{		
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'raw');
		$detail=$this->stock_model->get_transfer_data($table,$where);
		echo json_encode($detail);
	
}
public function yarn_twisting_details()
{		
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'twisting');
		$detail=$this->stock_model->get_transfer_data($table,$where);
		echo json_encode($detail);
	
}
public function yarn_dyed_details()
{		
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'dyed');
		$detail=$this->stock_model->get_transfer_data($table,$where);
		echo json_encode($detail);
	
}

public function max_transfer_id()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$data2=$this->input->post('str');
	if($data2 == 'Fabrics')
	 {
		 $table='fabric_transfer';
		$details = $this->store_model->max_select_transfer_no($table);
		$data=$details->transfer_id + 1;
		echo json_encode($data);
	 }
	  else if($data2 == 'Yarn - Raw' || $data2 == 'Yarn - Twisted' || $data2 == 'Yarn - Dyed')
	  {
		   $table='yarn_transfer';
		$details = $this->store_model->max_select_transfer_no($table);
			$data=$details->transfer_id + 1;
		echo json_encode($data);
	  }
	
	else if($data2 == 'Consumables' || $data2 == 'Spares')
	 {
		$table='cs_transfer';
		$details = $this->store_model->max_select_transfer_no($table);
			$data=$details->transfer_id + 1;
		echo json_encode($data);
	 }
	  else if($data2 == 'swan_yarn_dyed')
	 {
			$table='swan_yarn_transfer';
			$details = $this->store_model->max_select_transfer_no($table);
				$data=$details->transfer_id + 1;
		echo json_encode($data);
	 }
}

public function transfer_subgrid() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$get = $this->uri->segment(3);
	preg_match_all('!\d+!', $get, $matches);
	$id="";
	foreach($matches as $matches)
	{
		
		$id=$matches;
	}
	$i= $id[0];
	$table = 'fabric_transfer';
	$where = array('id'=>$i);
	$indent = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	
	
	$data1=$indent->transfer_id;
	// print_r($data1);
	// die();
	 $table = 'fabric_transfer';
	 $where = array('transfer_id'=>$data1,'status'=>1);
	 $getalldata = $this->vendor_model->fetch_where_subgrid_data1($table,$where);
	echo json_encode($getalldata);
}
public function transfer_swan_yarn_subgrid() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$get = $this->uri->segment(3);
	preg_match_all('!\d+!', $get, $matches);
	$id="";
	foreach($matches as $matches)
	{
		
		$id=$matches;
	}
	$i= $id[0];
	$table = 'swan_yarn_transfer';
	$where = array('id'=>$i);
	$indent = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	
	
	$data1=$indent->transfer_id;
	// print_r($data1);
	// die();
	 $table = 'swan_yarn_transfer';
	 $where = array('transfer_id'=>$data1,'status'=>1);
	 $getalldata = $this->vendor_model->fetch_where_subgrid_data1($table,$where);
	echo json_encode($getalldata);
}
public function transfer_yarn_raw_subgrid() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$get = $this->uri->segment(3);
	preg_match_all('!\d+!', $get, $matches);
	$id="";
	foreach($matches as $matches)
	{
		
		$id=$matches;
	}
	$i= $id[0];
	$table = 'yarn_transfer';
	$where = array('id'=>$i);
	$indent = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	
	
	$data1=$indent->transfer_id;
	
	 $table = 'yarn_transfer';
	 $where = array('transfer_id'=>$data1,'status'=>1);
	 $getalldata = $this->vendor_model->fetch_where_subgrid_data1($table,$where);
	echo json_encode($getalldata);
}
public function transfer_cs_subgrid() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$get = $this->uri->segment(3);
	preg_match_all('!\d+!', $get, $matches);
	$id="";
	foreach($matches as $matches)
	{
		
		$id=$matches;
	}
	$i= $id[0];
	$table = 'cs_transfer';
	$where = array('id'=>$i);
	$indent = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	
	
	$data1=$indent->transfer_id;
	// print_r($data1);
	// die();
	 $table = 'cs_transfer';
	 $where = array('transfer_id'=>$data1,'status'=>1);
	 $getalldata = $this->vendor_model->fetch_where_subgrid_data1($table,$where);
	echo json_encode($getalldata);
}
public function add_fabric_yes_confirmation()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("id");
	$remarks=$this->input->post("remarks");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='fabric_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
$rec_qua=$fb_details->issue_mtrs;

$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_mtrs'=>'0.00','rec_mtrs'=>$rec_qua);
	$table= 'fabric_transfer';
	$details = $this->stock_model->update_confirm_fabric($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='fabric_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$bal_wt=$fb_details->bal_wight;
	$bal_qua=$fb_details->bal_qua;
	
	if($bal_wt == '0.00' && $bal_qua == '0.00')
	{
		$fb_id=$fb_details->fabric_id;
		$t_loc=$fb_details->transfer_location;
		
		$table='fabric_inspection_details';
		$where=array('transfer_loc_id'=>$fb_id);
		$fabric_details_data = $this->stock_model->get_customerdata($table,$where);
	
		if(empty($fabric_details_data))
		{
			$table='fabric_inspection_details';
			$where=array('id'=>$fb_id);
			$data=array('consumed_at'=>$t_loc,'rec_weight'=>$fb_details->issue_weight);
			$details = $this->stock_model->update_data($where,$table,$data);
			
			$table='fabric_inspection';
			$where=array('goods_id'=>$fb_id);
			$data=array('transfer_status'=>'1','balanced_mtrs'=>$fb_details->issue_mtrs);
			$details = $this->stock_model->update_data($where,$table,$data);
		}
		else
		{
			// $table='fabric_inspection_details';
			// $where=array('transfer_loc_id'=>$fb_id);
			// $fabric_details_data = $this->stock_model->delete_vendor($table,$where);
			
			$table='fabric_inspection_details';
			$where=array('id'=>$fb_id);
			$data=array('consumed_at'=>$t_loc,'rec_weight'=>$fb_details->issue_weight);
			$details = $this->stock_model->update_data($where,$table,$data);
			
			$table='fabric_inspection';
			$where=array('goods_id'=>$fb_id);
			$data=array('transfer_status'=>'1','balanced_mtrs'=>$fb_details->issue_mtrs);
			$details = $this->stock_model->update_data($where,$table,$data);
		}
		
	}
	else
	{
		$fb_id=$fb_details->fabric_id;
		$t_loc=$fb_details->transfer_location;
		
		
		$table='fabric_inspection_details';
		$where=array('id'=>$fb_id);
		$fabric_details = $this->stock_model->get_customerdata($table,$where);
		
		
		$data=array('po_list_id'=>$fabric_details->po_list_id,
		'po_id'=>$fabric_details->po_id,
		'reference_table'=>$fabric_details->reference_table,
		'refernce_table'=>$fabric_details->refernce_table,
		'po_no'=>$fabric_details->po_no,
		'indent_no'=>$fabric_details->indent_no,
		'quantity'=>$fabric_details->quantity,
		'quantity_approval'=>$fabric_details->quantity_approval,
		'product_name'=>$fabric_details->product_name,
		'p_name'=>$fabric_details->p_name,
		'vendor_name'=>$fabric_details->vendor_name,
		'design'=>$fabric_details->design,
		'shades'=>$fabric_details->shades,
		'width'=>$fabric_details->width,
		'rate'=>$fabric_details->rate,
		'inr'=>$fabric_details->inr,
		'rec_goods'=>$fabric_details->rec_goods,
		'rec_bal_goods'=>$fabric_details->rec_bal_goods,
		'remainning_quantity'=>$fabric_details->remainning_quantity,
		'available_quantity'=>$fabric_details->available_quantity,
		'bal_goods'=>$fabric_details->bal_goods,
		'received_date'=>$fabric_details->received_date,
		'rec_by'=>$fabric_details->rec_by,
		'rec_weight'=>$fb_details->issue_weight,
		'consumed_at'=>$t_loc,
		'piece_no'=>$fabric_details->piece_no,
		'no_type'=>$fabric_details->no_type,
		'no_type_val'=>$fabric_details->no_type_val,
		'indent_approved_by'=>$fabric_details->indent_approved_by,
		'po_approved_by'=>$fabric_details->po_approved_by,
		'orderType'=>$fabric_details->orderType,
		'width_of_size'=>$fabric_details->width_of_size,
		'warpPlandMtr'=>$fabric_details->warpPlandMtr,
		'weftPlandMtr'=>$fabric_details->weftPlandMtr,
		'buyerShade'=>$fabric_details->buyerShade,	
		'status'=>$fabric_details->status,		
		'transfer_loc_id'=>$fb_id,	
		);		
		$table='fabric_inspection_details';
		$insert_id=$this->stock_model->insert_data($table,$data);
		
		
		
		$table='fabric_inspection';
		$where=array('goods_id'=>$fb_id);
		$fabric_goods_details = $this->stock_model->get_customerdata($table,$where);
		
		
		
		 $data=array('goods_id'=>$insert_id,
		 'status'=>0,
		 'sub'=>$fabric_goods_details->sub,
		 'quantity'=>$fabric_goods_details->quantity,
		 'inspected_mtrs'=>$fabric_goods_details->inspected_mtrs,
		 'inspected_weight'=>$fabric_goods_details->inspected_weight,
		 'balanced_mtrs'=>$fb_details->issue_mtrs,
		 'rejected_mtrs'=>$fabric_goods_details->rejected_mtrs,
		 'rejected_weight'=>$fabric_goods_details->rejected_weight,
		 'variance_mtrs'=>$fabric_goods_details->variance_mtrs,
		 'variance_weight'=>$fabric_goods_details->variance_weight,
		 'ssl_pc_no'=>$fabric_goods_details->ssl_pc_no,
		 'sl_ssl_pc_no'=>$fabric_goods_details->sl_ssl_pc_no,
		 'inspected_person'=>$fabric_goods_details->inspected_person,
		 'sys_date'=>$fabric_goods_details->sys_date,
		 'location'=>$fabric_goods_details->location,
		 'remarks'=>$fabric_goods_details->remarks,
		 'status'=>$fabric_goods_details->status,
		 
		 );		
		 $table='fabric_inspection';
		 $insert_id=$this->db->insert($table,$data);
	
	}
	
	$data1=$this->input->post('id');
	//$data1=$indent->transfer_id;
	
	 $table = 'fabric_transfer';
	 $where = array('id'=>$data1);
	 $getalldata = $this->vendor_model->get_customerdata($table,$where);
	echo json_encode($getalldata);
	
	
}
public function add_cs_yes_confirmation()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("id");
	$remarks=$this->input->post("remarks");
	$id=$this->session->userdata('logged_in');
$where=array('id'=>$id1);
	$table='cs_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);

$rec_qua=$fb_details->issue_qua;

$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_qua'=>'0.00','rec_qua'=>$rec_qua);
	
	$table= 'cs_transfer';
	$details = $this->stock_model->update_confirm_cs($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='cs_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$bal_qua=$fb_details->bal_qua;
	if($bal_qua == 0.00)
	{
		
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_cs_goods_details';
		$where=array('po_list_id'=>$fb_id);
		$data=array('consumed_at'=>$t_loc);
		$details = $this->stock_model->update_data($where,$table,$data);
		
		$table='indent_po';
		$where=array('id'=>$fb_id);
		$data=array('total_quantity'=>$fb_details->issue_qua);
		$details = $this->stock_model->update_data($where,$table,$data);
		
			
			
	}
	else
	{
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_po';
		$where=array('id'=>$fb_id);
		$fabric_details = $this->stock_model->get_customerdata($table,$where);
		
		$data=array('po_id'=>$fabric_details->po_id,
			'indent_id'=>$fabric_details->indent_id,
			'po_no'=>$fabric_details->po_no,
			'vendor_name'=>$fabric_details->vendor_name,
			'g_date'=>$fabric_details->g_date,
			'address'=>$fabric_details->address,
			'product_name'=>$fabric_details->product_name,
			'p_name'=>$fabric_details->p_name	,
			'product_id'=>$fabric_details->product_id,
			'product_type'=>$fabric_details->product_type,
			'indent_no'=>$fabric_details->indent_no,
			'shades'=>$fabric_details->shades,
			'width'=>$fabric_details->width,
			'indent_approved_by'=>$fabric_details->indent_approved_by,
			'indent_approved_date'=>$fabric_details->indent_approved_date,
			'department'=>$fabric_details->department,
			
			'purpose'=>$fabric_details->purpose,
			'currency'=>$fabric_details->currency,
			'quantity'=>$fabric_details->quantity,
			'tare_weight'=>$fabric_details->tare_weight,
			'balanced_quantity'=>$fb_details->bal_qua,
			'total_quantity'=>$fb_details->issue_qua,
			'balanced_hanks'=>$fabric_details->balanced_hanks,
			
			'net_weight'=>$fabric_details->net_weight,
			'gross_weight'=>$fabric_details->gross_weight,
			'cgst'=>$fabric_details->cgst,
			'sgst'=>$fabric_details->sgst,
			'igst'=>$fabric_details->igst,
			'quantity_approval'=>$fabric_details->quantity_approval,
			'quantity_approval'=>$fabric_details->quantity_approval,
			
			'indent_unit'=>$fabric_details->indent_unit,
			'inrvalue'=>$fabric_details->inrvalue,
			'gstval'=>$fabric_details->gstval,
			'totalvalue'=>$fabric_details->totalvalue,
			'ot_charges'=>$fabric_details->ot_charges,
			'total_amt'=>$fabric_details->total_amt,
			'discount'=>$fabric_details->discount,
			
			'grand_total'=>$fabric_details->grand_total,
			'rate'=>$fabric_details->rate,
			'inr'=>$fabric_details->inr,
			'received_quantity'=>$fabric_details->received_quantity,
			'modal'=>$fabric_details->modal,
			'note'=>$fabric_details->note,
			'comment'=>$fabric_details->comment,
			
			'bank_details'=>$fabric_details->bank_details,
			'gst_no'=>$fabric_details->gst_no,
			'terms_payment'=>$fabric_details->terms_payment,
			'description'=>$fabric_details->description,
			'confirm'=>$fabric_details->confirm,
			'approved_by'=>$fabric_details->approved_by,
			'approved_date'=>$fabric_details->approved_date,
			'remark'=>$fabric_details->remark,
			'edit'=>$fabric_details->edit,
			'created_by'=>$fabric_details->created_by,
			'indented_by'=>$fabric_details->indented_by,
			'status'=>$fabric_details->status,
			
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='indent_po';
			$insert_id=$this->stock_model->insert_data($table,$data);
			
			
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_cs_goods_details';
		$where=array('po_list_id'=>$fb_id);
		$fabric1_details = $this->stock_model->get_customerdata($table,$where);
		
		$data=array('rec_date'=>$fabric1_details->rec_date,
			'invoice'=>$fabric1_details->invoice,
			'consumed_at'=>$t_loc,
			'received_quality'=>$fabric1_details->received_quality,
			'received_date'=>$fabric1_details->received_date,
			'rec_by'=>$fabric1_details->rec_by,
			'po_list_id'=>$insert_id,
			'po_id'=>$fabric1_details->po_id	,
			'po_no'=>$fabric1_details->po_no,
			'indent_no'=>$fabric1_details->indent_no,
			'quantity'=>$fabric1_details->quantity,
			'received_bal_quality'=>$fabric1_details->received_bal_quality,
			'rate'=>$fabric1_details->rate,
			'inr'=>$fabric1_details->inr,
			'quantity_approval'=>$fabric1_details->quantity_approval,
			'status'=>$fabric1_details->status,
			'transfer_loc_id'=>$fabric1_details->po_list_id,	
			);		
			$table='indent_cs_goods_details';
			$insert_id=$this->stock_model->insert_data($table,$data);
	}
	
	return true;
	
	
}
public function add_yarn_yes_confirmation()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("id");
	$remarks=$this->input->post("remarks");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);

$rec_qua=$fb_details->issue_net_weight;
	$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_net_wt'=>'0.00','rec_net_wt'=>$rec_qua);
	
	$table= 'yarn_transfer';
	$details = $this->stock_model->update_confirm_yarn($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$bal_net_weight=$fb_details->bal_net_weight;
	// $bal_qua=$fb_details->bal_qua;
	
	if($bal_net_weight == 0.00)
	{
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_yarn_goods_details';
		$where=array('id'=>$fb_id);
		$data=array('consumed_at'=>$t_loc,'issue_net_weight'=>$fb_details->issue_net_weight,'net_weight'=>$fb_details->net_weight);
		$details = $this->stock_model->update_data($where,$table,$data);
	}
	else
	{
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_yarn_goods_details';
		$where=array('id'=>$fb_id);
		$fabric_details = $this->stock_model->get_customerdata($table,$where);
		
		
		$data=array('rec_date'=>$fabric_details->rec_date,
		'invoice'=>$fabric_details->invoice,
		'received_date'=>$fabric_details->received_date,
		'lot'=>$fabric_details->lot,
		'bale'=>$fabric_details->bale,
		'po_list_id'=>$fabric_details->po_list_id,
		'gross_weight'=>$fabric_details->gross_weight,
		'net_weight'=>$fb_details->net_weight,
		'issue_gross_weight'=>$fabric_details->issue_gross_weight,
		'issue_net_weight'=>$fb_details->issue_net_weight,
		'tare_weight'=>$fabric_details->tare_weight,
		'mill'=>$fabric_details->mill,
		'grade'=>$fabric_details->grade,
		'consumed_at'=>$fb_details->transfer_location,
		'rec_by'=>$fabric_details->rec_by,
		'yarnname'=>$fabric_details->yarnname,
		'yarndenier'=>$fabric_details->yarndenier,
		'yarnspecification'=>$fabric_details->yarnspecification,
		'quantity_approval'=>$fabric_details->quantity_approval,
		'received_quality'=>$fabric_details->received_quality,
		'status'=>$fabric_details->status,
		'yarn_status'=>$fabric_details->yarn_status,
		
		'transfer_loc_id'=>$fabric_details->id,	
		);		
		$table='indent_yarn_goods_details';
		$insert_id=$this->stock_model->insert_data($table,$data);
		
	}
	
	
	
	return true;
	
	
}
public function rec_yarn_twist_goods_details()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("tr_id");
	$rec_qua=$this->input->post("rec_qua");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$i=$fb_details->issue_net_weight;
	$rem = $i - $rec_qua;
	
	
	
	$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_net_wt'=>$rem,'rec_net_wt'=>$rec_qua);
	
	$table= 'yarn_transfer';
	$details = $this->stock_model->update_confirm_yarn($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$where=array('id'=>$fb_details->refrence_id);
	$table='delivery_yarn_twisting';
	$del_details = $this->stock_model->get_customerdata($table,$where);
	
	
	$fb_id=$del_details->reference_id;
	$fb_table=$del_details->reference_table;
	
	$fb_id1=$fb_details->ref_id;
	$fb_table1=$fb_details->ref_tab;
	
	 //  print_r($fb_id);
	   // die();
	
	$bal_net_weight=$fb_details->bal_net_weight;
	
	$gross=$fb_details->gross;
	$issue_net_weight=$fb_details->issue_net_weight;
	
	if($bal_net_weight == '0.00')
	{
		
		if($fb_table1 == 'work_order_twisting')
		{
			$t_loc=$fb_details->transfer_location;
			$table='work_order_twisting';
			$where=array('id'=>$fb_id1);
			$data=array('location'=>$t_loc,'gross_weight'=>$gross,'net_weight'=>$issue_net_weight);
			$details = $this->stock_model->update_data($where,$table,$data);
		}
		else if($fb_table1 == 'indent_yarn_goods_details')
		{
			$t_loc=$fb_details->transfer_location;
			$table='indent_yarn_goods_details';
			
			//$table='work_order_twisting';
			$where=array('id'=>$fb_id1);
			$data=array('consumed_at'=>$t_loc,'issue_gross_weight'=>$gross,'issue_net_weight'=>$issue_net_weight);
			$details = $this->stock_model->update_data($where,$table,$data);
		}
	}
	else
	{
		// print_r('haiiiiiiiii');
		// die();
		if($fb_table1 == 'work_order_twisting')
		{
			// $fb_id=$del_details->reference_id;
			// $fb_table=$del_details->reference_table;
	
			//$fb_id=$fb_details->refrence_id;
			$t_loc=$fb_details->transfer_location;
			$table='work_order_twisting';
			$where=array('id'=>$fb_id1);
			$fabric_details = $this->stock_model->get_customerdata($table,$where);
			
			
			$data=array('yarn_id'=>$fabric_details->yarn_id,
			'yarn_details'=>$fabric_details->yarn_details,
			'yarndenier'=>$fabric_details->yarndenier,
			'yarnspecification'=>$fabric_details->yarnspecification,
			'ordered_quantity'=>$fabric_details->ordered_quantity,
			'received_date'=>$fabric_details->received_date,
			'invoice'=>$fabric_details->invoice,
			'date'=>$fb_details->date	,
			'lot'=>$fabric_details->lot,
			'bale'=>$fabric_details->bale,
			'gross_weight'=>$fabric_details->gross_weight,
			'net_weight'=>$fb_details->issue_net_weight,
			'tare_weight'=>$fabric_details->tare_weight,
			'mill'=>$fabric_details->mill,
			'grade'=>$fabric_details->grade,
			'location'=>$fb_details->transfer_location,
			'rec_date'=>$fabric_details->rec_date,
			'rec_by'=>$fabric_details->rec_by,
			'status'=>$fabric_details->status,
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='work_order_twisting';
			$insert_id=$this->stock_model->insert_data($table,$data);
			
			
		}
		else if($fb_table1 == 'indent_yarn_goods_details')
		{	
	
			// $fb_id=$del_details->reference_id;
			// $fb_table=$del_details->reference_table;	
			//$fb_id=$fb_details->refrence_id;
			$t_loc=$fb_details->transfer_location;
			$table='indent_yarn_goods_details';
			$where=array('id'=>$fb_id1);
			$fabric_details = $this->stock_model->get_customerdata($table,$where);
			
			
			$data=array('rec_date'=>$fabric_details->rec_date,
			'invoice'=>$fabric_details->invoice,
			'received_date'=>$fabric_details->received_date,
			'lot'=>$fabric_details->lot,
			'bale'=>$fabric_details->bale,
			'po_list_id'=>$fabric_details->po_list_id,
			'gross_weight'=>$fabric_details->gross_weight,
			'net_weight'=>$fb_details->issue_net_weight,
			'issue_net_weight'=>$fb_details->issue_net_weight,
			'issue_gross_weight'=>$fb_details->gross,
			
			'tare_weight'=>$fabric_details->tare_weight,
			'mill'=>$fabric_details->mill,
			'grade'=>$fabric_details->grade,
			'consumed_at'=>$fb_details->transfer_location,
			'rec_by'=>$fabric_details->rec_by,
			'yarnname'=>$fabric_details->yarnname,
			'yarndenier'=>$fabric_details->yarndenier,
			'yarnspecification'=>$fabric_details->yarnspecification,
			'quantity_approval'=>$fabric_details->quantity_approval,
			'received_quality'=>$fabric_details->received_quality,
			'status'=>$fabric_details->status,
			'yarn_status'=>$fabric_details->yarn_status,
			
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='indent_yarn_goods_details';
			$insert_id=$this->stock_model->insert_data($table,$data);
		}
	}
	
	return true;
	
	
}
public function add_yarn_twist_yes_confirmation()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("id");
	$remarks=$this->input->post("remarks");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);

$rec_qua=$fb_details->issue_net_weight;

$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_net_wt'=>'0.00','rec_net_wt'=>$rec_qua);
	
	$table= 'yarn_transfer';
	$details = $this->stock_model->update_confirm_yarn($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$where=array('id'=>$fb_details->refrence_id);
	$table='delivery_yarn_twisting';
	$del_details = $this->stock_model->get_customerdata($table,$where);
	
	
	$fb_id=$del_details->reference_id;
	$fb_table=$del_details->reference_table;
	
	
	$fb_id1=$fb_details->ref_id;
	$fb_table1=$fb_details->ref_tab;
	
	 //  print_r($fb_id);
	   // die();
	
	$bal_net_weight=$fb_details->bal_net_weight;
	
	$gross=$fb_details->gross;
	$issue_net_weight=$fb_details->issue_net_weight;
	
	if($bal_net_weight == '0.00')
	{
		
		if($fb_table1 == 'work_order_twisting')
		{
			$t_loc=$fb_details->transfer_location;
			$table='work_order_twisting';
			$where=array('id'=>$fb_id1);
			$data=array('location'=>$t_loc,'gross_weight'=>$gross,'net_weight'=>$issue_net_weight);
			$details = $this->stock_model->update_data($where,$table,$data);
		}
		else if($fb_table1 == 'indent_yarn_goods_details')
		{
			$t_loc=$fb_details->transfer_location;
			$table='indent_yarn_goods_details';
			
			//$table='work_order_twisting';
			$where=array('id'=>$fb_id1);
			$data=array('consumed_at'=>$t_loc,'issue_gross_weight'=>$gross,'issue_net_weight'=>$issue_net_weight);
			$details = $this->stock_model->update_data($where,$table,$data);
		}
	}
	else
	{
		// print_r('haiiiiiiiii');
		// die();
		if($fb_table1 == 'work_order_twisting')
		{
			// $fb_id=$del_details->reference_id;
			// $fb_table=$del_details->reference_table;
	
			//$fb_id=$fb_details->refrence_id;
			$t_loc=$fb_details->transfer_location;
			$table='work_order_twisting';
			$where=array('id'=>$fb_id1);
			$fabric_details = $this->stock_model->get_customerdata($table,$where);
			
			
			$data=array('yarn_id'=>$fabric_details->yarn_id,
			'yarn_details'=>$fabric_details->yarn_details,
			'yarndenier'=>$fabric_details->yarndenier,
			'yarnspecification'=>$fabric_details->yarnspecification,
			'ordered_quantity'=>$fabric_details->ordered_quantity,
			'received_date'=>$fabric_details->received_date,
			'invoice'=>$fabric_details->invoice,
			'date'=>$fb_details->date	,
			'lot'=>$fabric_details->lot,
			'bale'=>$fabric_details->bale,
			'gross_weight'=>$fabric_details->gross_weight,
			'net_weight'=>$fb_details->issue_net_weight,
			'tare_weight'=>$fabric_details->tare_weight,
			'mill'=>$fabric_details->mill,
			'grade'=>$fabric_details->grade,
			'location'=>$fb_details->transfer_location,
			'rec_date'=>$fabric_details->rec_date,
			'rec_by'=>$fabric_details->rec_by,
			'status'=>$fabric_details->status,
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='work_order_twisting';
			$insert_id=$this->stock_model->insert_data($table,$data);
			
			
		}
		else if($fb_table1 == 'indent_yarn_goods_details')
		{	
	
			// $fb_id=$del_details->reference_id;
			// $fb_table=$del_details->reference_table;	
			//$fb_id=$fb_details->refrence_id;
			$t_loc=$fb_details->transfer_location;
			$table='indent_yarn_goods_details';
			$where=array('id'=>$fb_id1);
			$fabric_details = $this->stock_model->get_customerdata($table,$where);
			
			
			$data=array('rec_date'=>$fabric_details->rec_date,
			'invoice'=>$fabric_details->invoice,
			'received_date'=>$fabric_details->received_date,
			'lot'=>$fabric_details->lot,
			'bale'=>$fabric_details->bale,
			'po_list_id'=>$fabric_details->po_list_id,
			'gross_weight'=>$fabric_details->gross_weight,
			'net_weight'=>$fb_details->issue_net_weight,
			'issue_net_weight'=>$fb_details->issue_net_weight,
			'issue_gross_weight'=>$fb_details->gross,
			
			'tare_weight'=>$fabric_details->tare_weight,
			'mill'=>$fabric_details->mill,
			'grade'=>$fabric_details->grade,
			'consumed_at'=>$fb_details->transfer_location,
			'rec_by'=>$fabric_details->rec_by,
			'yarnname'=>$fabric_details->yarnname,
			'yarndenier'=>$fabric_details->yarndenier,
			'yarnspecification'=>$fabric_details->yarnspecification,
			'quantity_approval'=>$fabric_details->quantity_approval,
			'received_quality'=>$fabric_details->received_quality,
			'status'=>$fabric_details->status,
			'yarn_status'=>$fabric_details->yarn_status,
			
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='indent_yarn_goods_details';
			$insert_id=$this->stock_model->insert_data($table,$data);
		}
	}
	
	return true;
	
	
}
public function add_swan_yarn_yes_confirmation()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("id");
	$remarks=$this->input->post("remarks");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='swan_yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);

$rec_qua=$fb_details->issue_dyed_weight;

public function fabric_preview()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='fabric_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id);
		$table='fabric_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
		
	$data['rec']='0';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$data['rec_mtr']=$this->vendor_model->get_rec_mtr_data($table,$where);

$data['rec']='1';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
$data['indent_p']='indent_preview';	
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$data['rec_mtr']=$this->vendor_model->get_rec_mtr_data($table,$where);

$data['rec']='1';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];$data['indent_p']='today_preview';	
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function fabric_rec_stock_view()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='fabric_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id);
		$table='fabric_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
$data['rec_wei']=$this->vendor_model->get_rec_wei_data($table,$where);

$data['rec_mtr']=$this->vendor_model->get_rec_mtr_data($table,$where);

$data['rec']='1';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];	$data['indent_p']='monthly_preview';	
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function fabric_rec_view()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='fabric_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id);
		$table='fabric_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
$data['rec_wei']=$this->vendor_model->get_rec_wei_data($table,$where);

$data['rec_mtr']=$this->vendor_model->get_rec_mtr_data($table,$where);

$data['rec']='1';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];$data['indent_p']='year_preview';	
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$table='yarn_transfer';
	$update=$this->stock_model->get_transfer_Update($table);
     
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);

$m=date('m');
		$y=date('Y');
		$p='Yarn - Twisted';
		
	if($get == 'stoday_dashboard')
	{
        $d1=date('d-m-Y');
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'twisting','rec_date'=>$d1);
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
	else if($get == 'sindent')
	{
	    
	    	$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'twisting');
		$detail=$this->stock_model->get_transfer_data_from_to($table,$where,$fromdate,$enddate);
	}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='yarn_transfer';
        $detail=$this->vendor_model->monthly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$m,$y,$p);
	}
		else if($get == 'syear_dashboard')
	{
	    
	     $table='yarn_transfer';
         $detail=$this->vendor_model->yearly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$y,$p);
	}
	
	
	
		echo json_encode($detail);
	
}
public function raw_rec_view()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	  $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='yarn_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id,'confirm'=>'Yes');
		$table='yarn_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
		$data['rec_wei']=$this->vendor_model->get_rec_net_data($table,$where);
	$data['rec']='1';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];	$data['indent_p']='year_preview';
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$fromdate=$this->input->get('fromdate');
    $enddate=$this->input->get('enddate');

$table='yarn_transfer';
	$update=$this->stock_model->get_transfer_Update($table);

$m=date('m');
		$y=date('Y');
		$p='Yarn - Dyed';
		
	if($get == 'stoday_dashboard')
	{
        $d1=date('d-m-Y');
		$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'dyed','rec_date'=>$d1);
		$detail=$this->stock_model->get_transfer_data($table,$where);
	}
	else if($get == 'sindent')
	{
	    
	    $table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'dyed');
		$detail=$this->stock_model->get_transfer_data_from_to($table,$where,$fromdate,$enddate);
	}
		else if($get == 'smonth_dashboard')
	{
	    
	     $table='yarn_transfer';
        $detail=$this->vendor_model->monthly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$m,$y,$p);
	}
		else if($get == 'syear_dashboard')
	{
	    
	     $table='yarn_transfer';
         $detail=$this->vendor_model->yearly_stock_rec_stock_yarn_results_dashboard_po_list_id($table,$y,$p);
	}
	
	
		
		echo json_encode($detail);
	
}
public function twisting_rec_stock_preview()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='yarn_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id,'confirm'=>'Yes');
		$table='yarn_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
		$data['rec_wei']=$this->vendor_model->get_rec_net_data($table,$where);
	$data['rec']='1';	
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];	$data['indent_p']='year_preview';		
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function dyed_rec_preview()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='yarn_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id,'confirm'=>'Yes');
		$table='yarn_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
		$data['rec_wei']=$this->vendor_model->get_rec_net_data($table,$where);
		$data['rec']='1';
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
$data['indent_p']='indent_preview';		
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function rec_yarn_dyed_goods_details()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("tr_id");
	$rec_qua=$this->input->post("rec_qua");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='swan_yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$i=$fb_details->issue_dyed_weight;
	$rem = $i - $rec_qua;
	
	$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_dyed_wt'=>$rem,'rec_dyed_wt'=>$rec_qua);
	
	$table= 'swan_yarn_transfer';
	$details = $this->stock_model->update_confirm_swan_yarn($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='swan_yarn_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$dyed_weight=$fb_details->bal_dyed_weight;
	if($dyed_weight == 0.00)
	{
		$where=array('id'=>$id1);
		$table='swan_yarn_transfer';
		$fb_details = $this->stock_model->get_customerdata($table,$where);
		
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='work_order_dyeing';
		$where=array('id'=>$fb_id);
		$data=array('location'=>$t_loc,'rec_dyed_qua'=>$rec_qua);
		$this->stock_model->update_data($where,$table,$data);
	}
	else
	{
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='work_order_dyeing';
		$where=array('id'=>$fb_id);
		$fabric_details = $this->stock_model->get_customerdata($table,$where);
			
		$data=array('dyed_id'=>$fabric_details->dyed_id,
			'work_order'=>$fabric_details->work_order,
			'osl_no'=>$fabric_details->osl_no,
			'issue_no'=>$fabric_details->issue_no,
			'shade'=>$fabric_details->shade,
			'yarn_details'=>$fabric_details->yarn_details,
			'yarn_quality'=>$fabric_details->yarn_quality,
			'yarn_type'=>$fabric_details->yarn_type	,
			'yarnName'=>$fabric_details->yarnName,
			'yarnDenier'=>$fabric_details->yarnDenier,
			'yarnSpecification'=>$fabric_details->yarnSpecification,
			'color_code'=>$fabric_details->color_code,
			'issue_dyed_qua'=>$fb_details->dyed_weight,
			'rec_dyed_qua'=>$rec_qua,
			'degum_loss'=>$fabric_details->degum_loss,
			'degum_loss_per'=>$fabric_details->degum_loss_per,
			'vendor'=>$fabric_details->vendor,
			'rec_date'=>$fabric_details->rec_date,
			'rec_by'=>$fabric_details->rec_by,
			'location'=>$t_loc,
			'status'=>$fabric_details->status,
			'yarn_status'=>$fabric_details->yarn_status,
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='work_order_dyeing';
			$insert_id=$this->stock_model->insert_data($table,$data);
			
	}
	
	return true;
	
	
	
}
public function fetch_net() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$data1=$this->input->post('id');
	//$data1=$indent->transfer_id;
	
	 $table = 'yarn_transfer';
	 $where = array('id'=>$data1);
	 $getalldata = $this->vendor_model->get_customerdata($table,$where);
	echo json_encode($getalldata);
}
public function fetch_swan() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$data1=$this->input->post('id');
	//$data1=$indent->transfer_id;
	
	 $table = 'swan_yarn_transfer';
	 $where = array('id'=>$data1);
	 $getalldata = $this->vendor_model->get_customerdata($table,$where);
	echo json_encode($getalldata);
}
public function fetch_consum() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$data1=$this->input->post('id');
	//$data1=$indent->transfer_id;
	
	 $table = 'cs_transfer';
	 $where = array('id'=>$data1);
	 $getalldata = $this->vendor_model->get_customerdata($table,$where);
	echo json_encode($getalldata);
}
public function fetch_raw_q() {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$data1=$this->input->post('id');
	//$data1=$indent->transfer_id;
	
	 $table = 'fabric_transfer';
	 $where = array('id'=>$data1);
	 $getalldata = $this->vendor_model->get_customerdata($table,$where);
	echo json_encode($getalldata);
}
public function rec_spares_goods_details()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	$id1=$this->input->post("tr_id");
	$rec_qua=$this->input->post("rec_qua");
	$id=$this->session->userdata('logged_in');

$where=array('id'=>$id1);
	$table='cs_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$i=$fb_details->issue_qua;
	$rem = $i - $rec_qua;

$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_qua'=>$rem,'rec_qua'=>$rec_qua);
	
	$table= 'cs_transfer';
	$details = $this->stock_model->update_confirm_cs($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='cs_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$bal_qua=$fb_details->bal_qua;
	if($bal_qua == 0.00)
	{
		
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_cs_goods_details';
		$where=array('po_list_id'=>$fb_id);
		$data=array('consumed_at'=>$t_loc);
		$details = $this->stock_model->update_data($where,$table,$data);
		
		$table='indent_po';
		$where=array('id'=>$fb_id);
		$data=array('total_quantity'=>$fb_details->issue_qua);
		$details = $this->stock_model->update_data($where,$table,$data);
		
			
			
	}
	else
	{
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_po';
		$where=array('id'=>$fb_id);
		$fabric_details = $this->stock_model->get_customerdata($table,$where);
		
		$data=array('po_id'=>$fabric_details->po_id,
			'indent_id'=>$fabric_details->indent_id,
			'po_no'=>$fabric_details->po_no,
			'vendor_name'=>$fabric_details->vendor_name,
			'g_date'=>$fabric_details->g_date,
			'address'=>$fabric_details->address,
			'product_name'=>$fabric_details->product_name,
			'p_name'=>$fabric_details->p_name	,
			'product_id'=>$fabric_details->product_id,
			'product_type'=>$fabric_details->product_type,
			'indent_no'=>$fabric_details->indent_no,
			'shades'=>$fabric_details->shades,
			'width'=>$fabric_details->width,
			'indent_approved_by'=>$fabric_details->indent_approved_by,
			'indent_approved_date'=>$fabric_details->indent_approved_date,
			'department'=>$fabric_details->department,
			
			'purpose'=>$fabric_details->purpose,
			'currency'=>$fabric_details->currency,
			'quantity'=>$fabric_details->quantity,
			'tare_weight'=>$fabric_details->tare_weight,
			'balanced_quantity'=>$fb_details->bal_qua,
			'total_quantity'=>$fb_details->issue_qua,
			'balanced_hanks'=>$fabric_details->balanced_hanks,
			
			'net_weight'=>$fabric_details->net_weight,
			'gross_weight'=>$fabric_details->gross_weight,
			'cgst'=>$fabric_details->cgst,
			'sgst'=>$fabric_details->sgst,
			'igst'=>$fabric_details->igst,
			'quantity_approval'=>$fabric_details->quantity_approval,
			'quantity_approval'=>$fabric_details->quantity_approval,
			
			'indent_unit'=>$fabric_details->indent_unit,
			'inrvalue'=>$fabric_details->inrvalue,
			'gstval'=>$fabric_details->gstval,
			'totalvalue'=>$fabric_details->totalvalue,
			'ot_charges'=>$fabric_details->ot_charges,
			'total_amt'=>$fabric_details->total_amt,
			'discount'=>$fabric_details->discount,
			
			'grand_total'=>$fabric_details->grand_total,
			'rate'=>$fabric_details->rate,
			'inr'=>$fabric_details->inr,
			'received_quantity'=>$fabric_details->received_quantity,
			'modal'=>$fabric_details->modal,
			'note'=>$fabric_details->note,
			'comment'=>$fabric_details->comment,
			
			'bank_details'=>$fabric_details->bank_details,
			'gst_no'=>$fabric_details->gst_no,
			'terms_payment'=>$fabric_details->terms_payment,
			'description'=>$fabric_details->description,
			'confirm'=>$fabric_details->confirm,
			'approved_by'=>$fabric_details->approved_by,
			'approved_date'=>$fabric_details->approved_date,
			'remark'=>$fabric_details->remark,
			'edit'=>$fabric_details->edit,
			'created_by'=>$fabric_details->created_by,
			'indented_by'=>$fabric_details->indented_by,
			'status'=>$fabric_details->status,
			
			'transfer_loc_id'=>$fabric_details->id,	
			);		
			$table='indent_po';
			$insert_id=$this->stock_model->insert_data($table,$data);
			
			
		$fb_id=$fb_details->refrence_id;
		$t_loc=$fb_details->transfer_location;
		$table='indent_cs_goods_details';
		$where=array('po_list_id'=>$fb_id);
		$fabric1_details = $this->stock_model->get_customerdata($table,$where);
		
		$data=array('rec_date'=>$fabric1_details->rec_date,
			'invoice'=>$fabric1_details->invoice,
			'consumed_at'=>$t_loc,
			'received_quality'=>$fabric1_details->received_quality,
			'received_date'=>$fabric1_details->received_date,
			'rec_by'=>$fabric1_details->rec_by,
			'po_list_id'=>$insert_id,
			'po_id'=>$fabric1_details->po_id	,
			'po_no'=>$fabric1_details->po_no,
			'indent_no'=>$fabric1_details->indent_no,
			'quantity'=>$fabric1_details->quantity,
			'received_bal_quality'=>$fabric1_details->received_bal_quality,
			'rate'=>$fabric1_details->rate,
			'inr'=>$fabric1_details->inr,
			'quantity_approval'=>$fabric1_details->quantity_approval,
			'status'=>$fabric1_details->status,
			'transfer_loc_id'=>$fabric1_details->po_list_id,	
			);		
			$table='indent_cs_goods_details';
			$insert_id=$this->stock_model->insert_data($table,$data);
	}
	
	return true;
	
	
}
////////////////////////////////////  17-10-2018  //////////////////////////////////////////////
public function remnants_rec_stock_grid()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
       $RT  = substr($uri, strpos($uri, "/") + 12);
       
        if($RT == 'rec_stock/remnants_rec_stock_grid?prop_id=1')
        {
              $data['url_val']='1';
            $data['val']='rec_stock/remnants_rec_stock_grid?prop_id=1';
            $data['ref']='indent';
        }
        else if($RT == 'rec_stock/remnants_rec_stock_grid?prop_id=2')
        {
             $data['val']='rec_stock/remnants_rec_stock_grid?prop_id=1';
            $data['url_val']='2';
             $data['ref']='today_dashboard';
		}
       else if($RT == 'rec_stock/remnants_rec_stock_grid?prop_id=3')
        {
              $data['url_val']='3';
             $data['val']='rec_stock/remnants_rec_stock_grid?prop_id=1';
               $data['ref']='month_dashboard';
		}
		else if($RT == 'rec_stock/remnants_rec_stock_grid?prop_id=4')
        {
              $data['url_val']='4';
             $data['val']='rec_stock/remnants_rec_stock_grid?prop_id=1';
               $data['ref']='year_dashboard';
		}             
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
	//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
//----------tiill--------------------

$data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();
		   
		 $m_id=unserialize($access_menu_id->menu_id);
                   $check="";
                   foreach($m_id as $menu_id)
                   {
                           
                           $table='swansilk_menu';
                           $where=array('delete_status'=>'ACTIVE','menu_id'=>$menu_id);
                           $result= $this->marketing_model->fetch_main_data($table,$where);
                           
                           if('rec_stock/remnants_rec_stock_grid?prop_id=1' == $data['val'])
                           {
                                   $check=$data['val'];
                           }
                           
					}
           if($check != "")
           {
			   
			   //
			    $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
                  $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
							$menu_id=$arr->menu_id;
							 $table='swansilk_menu';
							$where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
						if(!empty($url->reference_url)){
							if($url->reference_url == $data['val']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
			
			$data['user_type_id'] = $this->access_id();
			$data['access'] = $this->access_details();
			$data['userdetails'] = $this->session_data_pass();
			$data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['access'] = $this->access_details();

$access_menu_id=$this->access_details_id();

$table='consumed_at';
		$data['consumed_at']=$this->vendor_model->fetch_where_data($table);
	$data['yarn_type']='dyed';
	$table1='purchase_master';
	$data['producttype']=$this->vendor_model->fetch_where_data($table1);
	
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$where=array('id'=>$id1);
	$table='remnants_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);

$rec_qua=$fb_details->issued_rem_wt;

$where=array('id'=>$id1);
	$table='remnants_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$i=$fb_details->issued_rem_wt;
	$rem = $i - $rec_qua;
	
	$approved_by=$id['username'];
	$current_date = date("d-m-Y");
	$where1=array('id'=>$id1);
	$data1=array('confirm'=>'Yes','rec_by'=>$approved_by,'rec_date'=>$current_date,'rem_remnant_wt'=>$rem,'rec_remnnats_wt'=>$rec_qua);
	
	$table= 'remnants_transfer';
	$details = $this->stock_model->update_confirm_yarn($data1,$where1);
	
	$where=array('id'=>$id1);
	$table='remnants_transfer';
	$fb_details = $this->stock_model->get_customerdata($table,$where);
	
	$bal_net_weight=$fb_details->bal_rem_wt;
	// $bal_qua=$fb_details->bal_qua;
	
	if($bal_net_weight == 0.00)
	{
		$fb_id=$fb_details->remnants_ref_id;
		$t_loc=$fb_details->transfer_location;
		$table='remnants';
		$where=array('id'=>$fb_id);
		$data=array('remnants_location'=>$t_loc,'rements_stock'=>$fb_details->issued_rem_wt);
		$details = $this->stock_model->update_data($where,$table,$data);
	}
	else
	{
		$fb_id=$fb_details->remnants_ref_id;
		$t_loc=$fb_details->transfer_location;
		$table='remnants';
		$where=array('id'=>$fb_id);
		$fabric_details = $this->stock_model->get_customerdata($table,$where);
		
		
		$data=array('issue_loom_id'=>$fabric_details->issue_loom_id,
		'rements'=>$fabric_details->rements,
		'rements_stock'=>$rec_qua,
		'rements_approval_by'=>$fabric_details->rements_approval_by,
		'rements_approved_date'=>$fabric_details->rements_approved_date,
		'bag'=>$fabric_details->bag,
		'remnants_location'=>$t_loc,
		'status'=>$fb_details->status,
		
		);		
		$table='remnants';
		$insert_id=$this->stock_model->insert_data($table,$data);
		
	}
	
	return true;
	
}
public function rem_rec_preview()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);
	
		$where=array('id'=>$val);
		$table='remnants_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
		$transfer_id=$data['fetch']->remnants_id;
		$where=array('remnants_id'=>$remnants_id,'confirm'=>'Yes');
		$table='remnants_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);
		$data['rec_wei']=$this->vendor_model->get_rec_net_data($table,$where);
		$data['rec']='1';
		
	$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
	$data['indent_p']='indent_preview';		
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function rec_raw_pc()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	 $uri = $_SERVER["REQUEST_URI"]; 
        $val = substr($uri, strpos($uri, "=") + 1);

$where=array('id'=>$val);
		$table='yarn_transfer';
		$data['fetch']=$this->vendor_model->get_customerdata($table,$where);
		
			
		
		$transfer_id=$data['fetch']->transfer_id;
		$where=array('transfer_id'=>$transfer_id);
		$table='yarn_transfer';
		$data['fetch_data']=$this->vendor_model->get_data($table,$where);

$data_fetch_data=$this->vendor_model->get_data($table,$where);

$data11=array();
foreach($data_fetch_data as $f)
{
	$types=$f->yarn_type;
	if($types == 'raw')
	{
		$vals=$f->refrence_id;
		$details = $this->store_model->get_stock_transfer_loca_raw_data_pc($vals);
$data['types']='Yarn-Raw';
		//echo json_encode($details);
	}
	else if($types == 'twisting')
	{
		
	}
	else if($types == 'dyed')
	{
$data['types']='Yarn-Dyed';
		$vals=$f->refrence_id;
		$details = $this->store_model->get_stock_transfer_loca_raw_data_pc($vals);
	}
	array_push($data11,$details);
	
}

$data['result']=$data11;

$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
	$data['indent_p']='indent_preview';		
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$data_fetch_data=$this->vendor_model->get_data($table,$where);

$data11=array();
foreach($data_fetch_data as $f)
{
	$types=$f->refrence_id;
	
		$vals=$f->refrence_id;
		$details = $this->store_model->get_stock_transfer_loca_swan_data_pc($vals);

array_push($data11,$details);
	
}

$data['result']=$data11;

$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
	$data['indent_p']='indent_preview';		
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$data_fetch_data=$this->vendor_model->get_data($table,$where);

$osl_details_result=array();
$data11=array();
foreach($data_fetch_data as $f)
{
	$v=$f->refrence_id;
$table='delivery_yarn_twisting';
$where=array('id'=>$v);
$arrs_res=$this->outsource_model->get_customerdata($table,$where);

if($arrs_res->reference_table == 'indent_yarn_goods_details')
					{
						$vals=$arrs_res->reference_id;
						$arrs_res=$this->outsource_model->get_stock_position_yarn_data($vals);
						array_push($osl_details_result,$arrs_res);
					}
					elseif($arrs_res->reference_table == 'work_order_twisting')
					{
						$vals=$arrs_res->reference_id;
						$arrs=$this->outsource_model->get_stock_position_work_order_twisting_res($vals);
						array_push($osl_details_result,$arrs);
					}

}

$data['result']=$osl_details_result;
$data['types']='Yarn-Twisting';

$data['userdetails'] = $this->session_data_pass();
	  $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
	$data['indent_p']='indent_preview';		
	  $data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function rec_confirm()
{
	$id     =$_POST['id'];
	$table='yarn_transfer';
	$con=array('id'=>$id);
	$data=array('confirm_status'=>"Confirmed");
	$this->vendor_model->update($con,$table,$data);
}

public function dyedrec_confirm()
{
	$id     =$_POST['id'];
	$table='yarn_transfer';
	$con=array('id'=>$id);
	$data=array('confirm_status'=>"Confirmed");
	$this->vendor_model->update($con,$table,$data);
}

public function twistrec_confirm()
{
	$id     =$_POST['id'];
	$table='yarn_transfer';
	$con=array('id'=>$id);
	$data=array('confirm_status'=>"Confirmed");
	$this->vendor_model->update($con,$table,$data);
}

public function swanrec_confirm()
{
	$id     =$_POST['id'];
	$table='swan_yarn_transfer';
	$con=array('id'=>$id);
	$data=array('confirm_status'=>"Confirmed");
	$this->vendor_model->update($con,$table,$data);
}

public function remanantrec_confirm()
{
	$id     =$_POST['id'];
	$table='remnants_transfer';
	$con=array('id'=>$id);
	$data=array('confirm_status'=>"Confirmed");
	$this->vendor_model->update($con,$table,$data);
}

}
?>