EVOLUTION-NINJA

Edit File: Stock_history_details.php

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

class stock_history_details 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('vendor_model');
$this->load->model('outsource_model');
$this->load->model('stock_model');
$this->load->model('store_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 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 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 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);

public function fabric_stock_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);
		
        $uri = $_SERVER["REQUEST_URI"]; 
                $data['val']  = substr($uri, strpos($uri, "/") + 12);
                
                
        $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;
		
         $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();

// $table='fabric_inspection_details';
// 	$where=array('customer_id'=>'');
// 	$details_res = $this->store_model->get_data_fetch($table,$where);
	
// 	foreach($details_res as $res)
// 	{
// 		$osl=$res->po_no;
// 		$where=array('oslNo'=>$osl);
// 		$table='orders';
// 		$orders_val = $this->store_model->fetch_where_subgrid_data($table,$where);
// 		if(empty($orders_val))
// 		{
		
// 		}
// 		else
// 		{
// 			$where=array('id'=>$res->id);
// 			$dataa=array('customer_id'=>$orders_val->fileNo);
// 			$table='fabric_inspection_details';
// 			$this->store_model->update_data($where,$table,$dataa);
// 		}
// 	}
	
	
// 	$table='fabric_inspection_details';
// 	$where=array('customer_id'=>'','osl_like'=>'PO');
// 	$details_res_po = $this->store_model->get_data_fetch($table,$where);
// 	foreach($details_res_po as $res_po)
// 	{
// 		if($res_po->po_list_id == 0)
// 		{
			
// 		}
// 		else
// 		{
// 			$where=$res_po->id;
// 			$orders_val = $this->store_model->get_stock_po_transfer_spares_row_data($where);
// 			if(empty($orders_val))
// 			{
			
// 			}
// 			else
// 			{
// 				$where=array('id'=>$res_po->id);
// 				$dataa=array('customer_id'=>$orders_val->fileNo);
// 				$table='fabric_inspection_details';
// 				$this->store_model->update_data($where,$table,$dataa);
// 			}
// 		}
		
// 	}
		
				
	$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);

public function yarn_stock_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);
 // $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);
// 		$data['access_dept_id_row']=$this->vendor_model->get_where_row($table,$where);
		
// 		$user_type_id_row=$dept_id_row->user_type_id;
	
		//----------tiill--------------------
		 $uri = $_SERVER["REQUEST_URI"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
 $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['vall'])
                           {
                                   $check=$data['vall'];
                           }
                           	 }
                           
           }
           if($check != "")
           {
// 	$data['get_yarn_raw_data'] = $this->outsource_model->display_yarn_raw_data1();
// 	$val1 = $this->outsource_model->display_yarn_raw_data1();

/*	$data['get_yarn_twisting_data'] = $this->outsource_model->display_yarn_twisting_data1();
	$val2 = $this->outsource_model->display_yarn_twisting_data1();
	
	$data['get_yarn_dyed_data'] = $this->outsource_model->display_yarn_dyed_data1();
	$val3 = $this->outsource_model->display_yarn_dyed_data1();*/
	
// 	$data1=array();
// 		foreach($val1 as $val)
// 		{
// 			$yarn=$val->yarnname;
// 		//	$arr['yarnName']=$val->yarnName;
// 			$table='workorder_yarn_details';
// 			$where=array('yarn_details'=>$yarn);
// 			$arr=$this->outsource_model->fetch_where_row_data($table,$where);
	
// 			array_push($data1,$arr);
		
// 		}
// 	$data['raw']=$data1;
	
	/*$data2=array();
		foreach($val2 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr1=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data2,$arr1);
		
		}
	$data['twist']=$data2;
	
	$data3=array();
		foreach($val3 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr2=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data3,$arr2);
		
		}
	$data['dyed']=$data3;*/
	
	$table='work_order_dyeing';
	$where=array('status'=>'COMPLETED','yarn_status'=>0);
	$data['raw_mat']=$this->outsource_model->get_work_order_grid_data($table,$where);
	// print_r($data['raw_mat']);

$this->load->view('templates/header_inside',$data);
	$this->load->view('stock_details/yarn_stock_details',$data);
	$this->load->view('templates/footer_inside');
           }
           else
            {  
        $this->session->sess_destroy();
        redirect(base_url());
           }
}

public function yarn_stock_details_dyed()
{
	$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"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
 
 
 $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);
		$data['access_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['vall'])
                           {
                                   $check=$data['vall'];
                           }
                           	 }
                           
           }
           if($check != "")
           {

/*	$data['get_yarn_raw_data'] = $this->outsource_model->display_yarn_raw_data1();
	$val1 = $this->outsource_model->display_yarn_raw_data1();

$data['get_yarn_twisting_data'] = $this->outsource_model->display_yarn_twisting_data1();
	$val2 = $this->outsource_model->display_yarn_twisting_data1();*/
	
	$data['get_yarn_dyed_data'] = $this->outsource_model->display_yarn_dyed_data1();
	$val3 = $this->outsource_model->display_yarn_dyed_data1();
	
/*	$data1=array();
		foreach($val1 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data1,$arr);
		
		}
	$data['raw']=$data1;
	
	$data2=array();
		foreach($val2 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr1=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data2,$arr1);
		
		}
	$data['twist']=$data2;*/
	
	$data3=array();
		foreach($val3 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr2=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data3,$arr2);
		
		}
	$data['dyed']=$data3;
	
	$table='work_order_dyeing';
	$where=array('status'=>'COMPLETED','yarn_status'=>0);
	$data['raw_mat']=$this->outsource_model->get_work_order_grid_data($table,$where);
	// print_r($data['raw_mat']);
	// die();
	
	
	//$data=$details;

/* $this->db->truncate('delivery_yarn_twisting');
	 $this->db->empty_table('delivery_yarn_twisting');
	
	
	$data = $this->outsource_model->display_yarn_twisting_grid_detailed_data();
	foreach($data as $d)
	{
		$r=array('purpose'=>$d->purpose,
		 'yarnname' => $d->yarnname,
		 'reference_table' => 'indent_yarn_goods_details',
		 'reference_id' => $d->id,
 'yarndenier' => $d->yarndenier,
 'yarnspecification' => $d->yarnspecification,
			'rec_date' => $d->rec_date,
 'lot' => $d->lot,
 'bale'=> $d-> bale,
			'issue_gross_weight'=>$d->issue_gross_weight,
			'issue_net_weight'=>$d->issue_net_weight,
			'consumed_at'=>$d->consumed_at,
			'shades'=>$d->shades);
			$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}
	
	
	//$table='create_yarntwisting_work_order'
	//$where=array('quantity_approval'=>'Completed');
	$f=$this->outsource_model->display_yarn_twisting_delivery_grid_detailed_data();
	
	foreach($f as $dd)
	{
		$r=array('purpose'=>'',
		 'yarnname' => $dd->yarn_name,
		 'reference_table' => 'work_order_twisting',
		 'reference_id' => $dd->id,
 'yarndenier' => $dd->yarn_denier,
 'yarnspecification' => $dd->yarn_specification,
			'rec_date' => $dd->rec_date,
 'lot' => $dd->lot,
 'bale'=> $dd-> bale,
			'issue_gross_weight'=>$dd->gross_weight,
			'issue_net_weight'=>$dd->net_weight,
			'consumed_at'=>$dd->location,
			'shades'=>'');
		$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}
*/
	//
	 $uri = $_SERVER["REQUEST_URI"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
			 $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['vall']) 
							{
								$data['access_row']=$arr;
							}
						}
						}
				   }
				//----------tiill--------------------
	// print_r($data['access_row']);
// die();	
	 $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();
				
			$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['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$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_details/yarn_stock_details_dyed',$data);
	$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}

public function yarn_stock_details_twisting()
{
	$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"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
 
 
 $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);
		$data['access_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['vall'])
                           {
                                   $check=$data['vall'];
                           }
                           	 }
                           
           }
           if($check != "")
           {

// 	$data['get_yarn_twisting_data'] = $this->outsource_model->display_yarn_twisting_data1();
// 	$val2 = $this->outsource_model->display_yarn_twisting_data1();
	
/*	$data['get_yarn_dyed_data'] = $this->outsource_model->display_yarn_dyed_data1();
	$val3 = $this->outsource_model->display_yarn_dyed_data1();
		$data['get_yarn_raw_data'] = $this->outsource_model->display_yarn_raw_data1();
	$val1 = $this->outsource_model->display_yarn_raw_data1();
	
	$data1=array();
		foreach($val1 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data1,$arr);
		
		}
	$data['raw']=$data1;

$data3=array();
		foreach($val3 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr2=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data3,$arr2);
		
		}
	$data['dyed']=$data3;*/
	
// 		$data2=array();
// 		foreach($val2 as $val)
// 		{
// 			$yarn=$val->yarnname;
// 		//	$arr['yarnName']=$val->yarnName;
// 			$table='workorder_yarn_details';
// 			$where=array('yarn_details'=>$yarn);
// 			$arr1=$this->outsource_model->fetch_where_row_data($table,$where);
	
// 			array_push($data2,$arr1);
		
// 		}
// 	$data['twist']=$data2;
	
/*	$table='work_order_dyeing';
	$where=array('status'=>'COMPLETED','yarn_status'=>0);
	$data['raw_mat']=$this->outsource_model->get_work_order_grid_data($table,$where);
	// print_r($data['raw_mat']);
	// die();
	*/
	
	//$data=$details;

$this->db->truncate('delivery_yarn_twisting');
	 $this->db->empty_table('delivery_yarn_twisting');
	
	
	$data = $this->outsource_model->display_yarn_twisting_grid_detailed_data();
	foreach($data as $d)
	{
		$r=array('purpose'=>$d->purpose,
		 'yarnname' => $d->yarnname,
		  'reference_table' => 'indent_yarn_goods_details',
		  'reference_id' => $d->id,
            'yarndenier' => $d->yarndenier,
            'yarnspecification' => $d->yarnspecification,
			'rec_date' => $d->rec_date,
           'lot' => $d->lot,
           'bale'=> $d-> bale,
			'issue_gross_weight'=>$d->issue_gross_weight,
			'issue_net_weight'=>$d->issue_net_weight,
			'consumed_at'=>$d->consumed_at,
			'shades'=>$d->shades,
			'unit'=>$d->unit,
			'updated_unit'=>$d->updated_unit,
			'po_no'=>$d->po_no,
			'indent_po'=>$d->id1,
			'indent_yarn_goods_details'=>$d->id,
			);
			$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}
	
	
	//$table='create_yarntwisting_work_order'
	//$where=array('quantity_approval'=>'Completed');
	$f=$this->outsource_model->display_yarn_twisting_delivery_grid_detailed_data();
	
	foreach($f as $dd)
	{
		$r=array('purpose'=>'',
		 'yarnname' => $dd->yarn_name,
		  'reference_table' => 'work_order_twisting',
		  'reference_id' => $dd->id,
            'yarndenier' => $dd->yarn_denier,
            'yarnspecification' => $dd->yarn_specification,
			'rec_date' => $dd->rec_date,
           'lot' => $dd->lot,
           'bale'=> $dd-> bale,
			'issue_gross_weight'=>$dd->gross_weight,
			'issue_net_weight'=>$dd->net_weight,
			'updated_unit'=>$dd->updated_unit,
			'consumed_at'=>$dd->location,
			'shades'=>'',
			'work_order_twisting'=>$dd->id,
			'create_yarntwisting_work_order'=>$dd->id1);
		$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}

//
	 $uri = $_SERVER["REQUEST_URI"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
			 $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_details/yarn_stock_details_twisting',$data);
	$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}

public function yarn_stock_details_swan_dyed()
{
	$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"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
 
 
 $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);
		$data['access_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['vall'])
                           {
                                   $check=$data['vall'];
                           }
                           	 }
                           
           }
           if($check != "")
           {

/*				
	$data['get_yarn_raw_data'] = $this->outsource_model->display_yarn_raw_data1();
	$val1 = $this->outsource_model->display_yarn_raw_data1();

/*	 $this->db->truncate('delivery_yarn_twisting');
	 $this->db->empty_table('delivery_yarn_twisting');
	
	
	$data = $this->outsource_model->display_yarn_twisting_grid_detailed_data();
	foreach($data as $d)
	{
		$r=array('purpose'=>$d->purpose,
		 'yarnname' => $d->yarnname,
		  'reference_table' => 'indent_yarn_goods_details',
		  'reference_id' => $d->id,
            'yarndenier' => $d->yarndenier,
            'yarnspecification' => $d->yarnspecification,
			'rec_date' => $d->rec_date,
           'lot' => $d->lot,
           'bale'=> $d-> bale,
			'issue_gross_weight'=>$d->issue_gross_weight,
			'issue_net_weight'=>$d->issue_net_weight,
			'consumed_at'=>$d->consumed_at,
			'shades'=>$d->shades);
			$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}
	
	
	//$table='create_yarntwisting_work_order'
	//$where=array('quantity_approval'=>'Completed');
	$f=$this->outsource_model->display_yarn_twisting_delivery_grid_detailed_data();
	
	foreach($f as $dd)
	{
		$r=array('purpose'=>'',
		 'yarnname' => $dd->yarn_name,
		  'reference_table' => 'work_order_twisting',
		  'reference_id' => $dd->id,
            'yarndenier' => $dd->yarn_denier,
            'yarnspecification' => $dd->yarn_specification,
			'rec_date' => $dd->rec_date,
           'lot' => $dd->lot,
           'bale'=> $dd-> bale,
			'issue_gross_weight'=>$dd->gross_weight,
			'issue_net_weight'=>$dd->net_weight,
			'consumed_at'=>$dd->location,
			'shades'=>'');
		$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}*/

//
// 	 $uri = $_SERVER["REQUEST_URI"]; 
// $data['vall'] = substr($uri, strpos($uri, "/") + 12);
// 			 $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['vall']) 
// 							{
// 								$data['access_row']=$arr;
// 							}
// 						}
// 						}
// 				   }
				//----------tiill--------------------
	// print_r($data['access_row']);
// die();	
	 $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();
				
			$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['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$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);
// print_r($data);
// die();
	$this->load->view('templates/header_inside',$data);
	$this->load->view('stock_details/yarn_stock_details_swan_dyed',$data);
	$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}

public function yarn_stock_details_remnant()
{
	$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"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
 
 
 $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);
		$data['access_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['vall'])
                           {
                                   $check=$data['vall'];
                           }
                           	 }
                           
           }
           if($check != "")
           {

/*				
				
	$data['get_yarn_raw_data'] = $this->outsource_model->display_yarn_raw_data1();
	$val1 = $this->outsource_model->display_yarn_raw_data1();

$data['get_yarn_twisting_data'] = $this->outsource_model->display_yarn_twisting_data1();
	$val2 = $this->outsource_model->display_yarn_twisting_data1();
	
	$data['get_yarn_dyed_data'] = $this->outsource_model->display_yarn_dyed_data1();
	$val3 = $this->outsource_model->display_yarn_dyed_data1();
	
	$data1=array();
		foreach($val1 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data1,$arr);
		
		}
	$data['raw']=$data1;
	
	$data2=array();
		foreach($val2 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr1=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data2,$arr1);
		
		}
	$data['twist']=$data2;
	
	$data3=array();
		foreach($val3 as $val)
		{
			$yarn=$val->yarnname;
		//	$arr['yarnName']=$val->yarnName;
			$table='workorder_yarn_details';
			$where=array('yarn_details'=>$yarn);
			$arr2=$this->outsource_model->fetch_where_row_data($table,$where);
	
			array_push($data3,$arr2);
		
		}
	$data['dyed']=$data3;
	
	$table='work_order_dyeing';
	$where=array('status'=>'COMPLETED','yarn_status'=>0);
	$data['raw_mat']=$this->outsource_model->get_work_order_grid_data($table,$where);
	// print_r($data['raw_mat']);
	// die();
	
	
	//$data=$details;

$this->db->truncate('delivery_yarn_twisting');
	 $this->db->empty_table('delivery_yarn_twisting');
	
	
	$data = $this->outsource_model->display_yarn_twisting_grid_detailed_data();
	foreach($data as $d)
	{
		$r=array('purpose'=>$d->purpose,
		 'yarnname' => $d->yarnname,
		  'reference_table' => 'indent_yarn_goods_details',
		  'reference_id' => $d->id,
            'yarndenier' => $d->yarndenier,
            'yarnspecification' => $d->yarnspecification,
			'rec_date' => $d->rec_date,
           'lot' => $d->lot,
           'bale'=> $d-> bale,
			'issue_gross_weight'=>$d->issue_gross_weight,
			'issue_net_weight'=>$d->issue_net_weight,
			'consumed_at'=>$d->consumed_at,
			'shades'=>$d->shades);
			$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}
	
	
	//$table='create_yarntwisting_work_order'
	//$where=array('quantity_approval'=>'Completed');
	$f=$this->outsource_model->display_yarn_twisting_delivery_grid_detailed_data();
	
	foreach($f as $dd)
	{
		$r=array('purpose'=>'',
		 'yarnname' => $dd->yarn_name,
		  'reference_table' => 'work_order_twisting',
		  'reference_id' => $dd->id,
            'yarndenier' => $dd->yarn_denier,
            'yarnspecification' => $dd->yarn_specification,
			'rec_date' => $dd->rec_date,
           'lot' => $dd->lot,
           'bale'=> $dd-> bale,
			'issue_gross_weight'=>$dd->gross_weight,
			'issue_net_weight'=>$dd->net_weight,
			'consumed_at'=>$dd->location,
			'shades'=>'');
		$table='delivery_yarn_twisting';
		$this->db->insert($table,$r);
	}*/

//
	 $uri = $_SERVER["REQUEST_URI"]; 
 $data['vall'] = substr($uri, strpos($uri, "/") + 12);
			 $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_details/yarn_stock_details_remnant',$data);
	$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}

public function cs_stock_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);
		
 $uri = $_SERVER["REQUEST_URI"]; 
 $data['val'] = substr($uri, strpos($uri, "/") + 12);
 
 
 $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();

$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);

$where=array('ref_id'=>$val);
	$table='inspection_qc';
	$data['inspection_qc_details']=$this->store_model->fetch_where_subgrid_data($table,$where);

$po_id=$data['goods_id']->po_id;

$data['details'] = $this->store_model->display_fabric_preview_embroidryinspection($val);
	
	print_r($po_id);
	die();
	
	if($po_id == '0')
	{
		$data['prpose_details']='';
	}
	else
	{
		$table1='indent_po';
		$where1=array('po_id'=>$po_id);
		$data['prpose_details']=$this->store_model->fetch_where_subgrid_data($table1,$where1);
	}
	
	//print_r($data['prpose_details']);
	//die();
	$v_address=$data['goods_id']->vendor_name;
	$where=array('name'=>$v_address);
	$table='indent_vendor_master';
	$data['fetch_address']=$this->vendor_model->get_customerdata($table,$where);
		
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

$where=array('ref_id'=>$val);
	$table='inspection_qc';
	$data['inspection_qc_details']=$this->store_model->fetch_where_subgrid_data($table,$where);

$po_id=$data['goods_id']->po_id;
	
	$data['details'] = $this->store_model->display_fabric_preview_embroidryinspection($val);
	
	// print_r($po_id);
	// die();
	
	if($po_id == '0')
	{
		$data['prpose_details']='';
	}
	else
	{
		$table1='indent_po';
		$where1=array('po_id'=>$po_id);
		$data['prpose_details']=$this->store_model->fetch_where_subgrid_data($table1,$where1);
	}
	
	//print_r($data['prpose_details']);
	//die();
	$v_address=$data['goods_id']->vendor_name;
	$where=array('name'=>$v_address);
	$table='indent_vendor_master';
	$data['fetch_address']=$this->vendor_model->get_customerdata($table,$where);
		
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

public function yarn_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='indent_yarn_goods_details';
	$data['goods_id']=$this->store_model->fetch_where_subgrid_data($table,$where);
	$po_id=$data['goods_id']->po_list_id;
	
	//$data = $this->outsource_model->display_yarn_raw_grid_data();
	
	$data['details']  = $this->store_model->display_yarn_preview_grid_data($val);
	
	
	$table1='indent_po';
	$where1=array('id'=>$po_id);
	$data['prpose_details']=$this->store_model->fetch_where_subgrid_data($table1,$where1);
	
	$v_address=$data['prpose_details']->vendor_name;
	$where=array('name'=>$v_address);
	$table='indent_vendor_master';
	$data['fetch_address']=$this->vendor_model->get_customerdata($table,$where);
		
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

public function yarn_stock_reject()
{
	$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);
		$ids=$this->input->post('id');
    	$wheres=array('id'=>$ids);
    	$tables='indent_yarn_goods_details';
    	$datas=array('reject_status'=>"REJECTED");
        $this->store_model->update_data($wheres,$tables,$datas);
        
	  }
	  
	  public function yarn_remenant_reject()
{
	    $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);
	    $ids=$this->input->post('id');
    	$wheres=array('id'=>$ids);
    	$tables='remnants';
    	$datas=array('reject_status'=>"REJECTED");
        $this->store_model->update_data($wheres,$tables,$datas);
        
	  }

public function yarn_stock_twist_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='delivery_yarn_twisting';
	$data['goods_id']=$this->store_model->fetch_where_subgrid_data($table,$where);
	$po_id=$data['goods_id']->reference_id;
	
	//$data = $this->outsource_model->display_yarn_raw_grid_data();
	
	$data['details']  = $this->store_model->display_yarn_preview_grid_data($po_id);
	
	
	$table1='indent_po';
	$where1=array('id'=>$po_id);
	$data['prpose_details']=$this->store_model->fetch_where_subgrid_data($table1,$where1);
	if(empty($data['prpose_details']))
	{
		
	}
	else{
		
	$v_address=$data['prpose_details']->vendor_name;
	$where=array('name'=>$v_address);
	$table='indent_vendor_master';
	$data['fetch_address']=$this->vendor_model->get_customerdata($table,$where);
	}	
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

public function cs_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);
		
		//print_r($val);
	$where=array('id'=>$val);
	$table='indent_po';
	$data['goods_id']=$this->store_model->fetch_where_subgrid_data($table,$where);
	
	//print_r($data['goods_id']);
	//die();
	$data['details']  = $this->store_model->display_yarn_preview_grid_data($val);
	
	
	 $v_address=$data['goods_id']->vendor_name;
	 $where=array('name'=>$v_address);
	 $table='indent_vendor_master';
	 $data['fetch_address']=$this->vendor_model->get_customerdata($table,$where);
		
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

public function yarn_stock_swan_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);
	
	$table='work_order_dyeing';
	$where=array('id'=>$val);
	$data['details']=$this->store_model->get_work_order_swan_grid_data($table,$where);
	$details1=$this->store_model->get_work_order_swan_grid_data($table,$where);
	// print_r($details1);
	// die();
	if($details1->dyed_id == 0)
	{
		$vendor_details='Empty';
	}
	else
	{
			$table='workorder_dyeing';
	$where=array('id'=>$data['details']->dyed_id);
	$vendor_details=$this->store_model->get_work_order_swan_grid_data($table,$where);
	}
	
	$data['ven_details']=$vendor_details;
	
	// print_r($data['ven_details']);
	// die();
	
	
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

$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_details/yarn_swan_preview',$data);
	$this->load->view('templates/footer_inside');
	  
}
public function yarn_stock_modal_val()
{
	$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);
		
	$v=$_REQUEST['id'];
	$data['f'] = $this->store_model->display_yarn_preview_grid_data($v);
	
		$id=$this->session->userdata('logged_in');
			$where=array('id'=>$id);
			$approved_by=$id['userid'];
			$table='employee_details';
			 $where=array('id'=>$approved_by);
			 $data['d']=$this->marketing_model->fetch_main_data($table,$where);
			 
		
		 // print_r($data);
		 // die();
	echo json_encode($data);
	
}
public function yarn_stock_modal_yarn_val()
{
	$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);
		
	$v=$_REQUEST['id'];
	 // print_r($v);
	 // die();
	$data['f'] = $this->store_model->delivery_yarn_twisting_detailed_grid_data($v);
	
		$id=$this->session->userdata('logged_in');
			$where=array('id'=>$id);
			$approved_by=$id['userid'];
			$table='employee_details';
			 $where=array('id'=>$approved_by);
			 $data['d']=$this->marketing_model->fetch_main_data($table,$where);
			 
		
		 // print_r($data);
		 // die();
	echo json_encode($data);
	
}
public function add_gross_zero_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);
		
	$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$data=array('issue_gross_weight'=>0);
	$table='indent_yarn_goods_details';
	$this->store_model->update_data($where,$table,$data);
	
}
public function add_dyed_zero_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);
		
	$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$data=array('rec_dyed_qua'=>0);
	$table='work_order_dyeing';
	$this->store_model->update_data($where,$table,$data);
	
}
public function add_net_zero_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);
		
	$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$data=array('issue_net_weight'=>0);
	$table='indent_yarn_goods_details';
	$this->store_model->update_data($where,$table,$data);
	
}

public function add_gross_zero_yarn_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);
		
	$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$table='delivery_yarn_twisting';
	$result=$this->outsource_model->get_customerdata($table,$where);
	
	if($result->reference_table == 'indent_yarn_goods_details')
	{
		$data=array('issue_gross_weight'=>0);
		$where=array('id'=>$result->reference_id);
		$table='indent_yarn_goods_details';
		$this->store_model->update_data($where,$table,$data);
	}
	else if($result->reference_table == 'work_order_twisting')
	{
		$data=array('gross_weight'=>0);
		$where=array('id'=>$result->reference_id);
		$table='work_order_twisting';
		$this->store_model->update_data($where,$table,$data);
	}
	
	$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$data=array('issue_gross_weight'=>0);
	$table='delivery_yarn_twisting';
	$this->store_model->update_data($where,$table,$data);
	
}
public function add_net_zero_yarn_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);
		
		$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$table='delivery_yarn_twisting';
	$result=$this->outsource_model->get_customerdata($table,$where);
	
	if($result->reference_table == 'indent_yarn_goods_details')
	{
		$data=array('issue_net_weight'=>0);
		$where=array('id'=>$result->reference_id);
		$table='indent_yarn_goods_details';
		$this->store_model->update_data($where,$table,$data);
	}
	else if($result->reference_table == 'work_order_twisting')
	{
		$data=array('net_weight'=>0);
		$where=array('id'=>$result->reference_id);
		$table='work_order_twisting';
		$this->store_model->update_data($where,$table,$data);
	}
	
	$v=$_REQUEST['id'];
	$where=array('id'=>$v);
	$data=array('issue_net_weight'=>0);
	$table='delivery_yarn_twisting';
	$this->store_model->update_data($where,$table,$data);
	
}
public function outsource_consumable_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"]; 
        $val1 = substr($uri, strpos($uri, "=") + 1);
		$arr = explode('/',trim($val1));
	
	//print_r($arr[1]);
		$data['location']=$arr[0];
		$data['yarn_type']=$arr[1];
		$data['preview_id']=$arr[2];
		
	 $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
	  $data['access'] = $this->access_details();
		$data['userdetails'] = $this->session_data_pass();
	
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	  	 
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

public function madeups_stock_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);
		
 $uri = $_SERVER["REQUEST_URI"]; 
 $data['val'] = substr($uri, strpos($uri, "/") + 12);
 
 
 $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='consumed_at';
		$where=array('status'=>1);
		$data['emp_loc']=$this->vendor_model->get_data($table,$where);

$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--------------------
				
       		$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);

echo json_encode($getalldata);
}

public function madeups_selected_stock() {
	
	$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);
		
		$stock = $this->input->post('stock');
		$array=array();
		foreach($stock as $key=>$stock)
          {
             
             
	        $details = $this->vendor_model->fetch_each_orderid_dese($stock);
            
            if($details)
            {
              $data['id'] = $details[0]->id;
              $data['osl'] = $details[0]->osl;
              $data['order_type'] = $details[0]->order_type;
              $data['size'] = $details[0]->size;
              $data['article'] = $details[0]->article;
              $data['batch_no'] = $details[0]->batch_no;
              $data['design'] = $details[0]->design;
               $data['shade'] = $details[0]->shade;
              $data['received_wt'] = $details[0]->received_wt;
              $data['received_qty'] = $details[0]->received_qty;
               $data['sequence'] = $details[0]->sequence;
             
              array_push($array, $data);
            }
          }

echo json_encode($array);
}

public function ho_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
$where=array('location'=>'HO','received_qty >' => 0);
	$where='HO';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);
	echo json_encode($getalldata);
}
public function tailoring_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
//$where=array('location'=>'PEENYA - TAILORING','received_qty >' => 0);
//	$getalldata = $this->vendor_model->get_where_dataa($table,$where);

$where='PEENYA - TAILORING';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);
	echo json_encode($getalldata);
}
public function nandi_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
//$where=array('location'=>'NANDI','received_qty >' => 0);
	//$getalldata = $this->vendor_model->get_where_dataa($table,$where);

$where='NANDI';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);

echo json_encode($getalldata);
}
public function byatranpura_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
//$where=array('location'=>'BYATRANPURA','received_qty >' => 0);
	//$getalldata = $this->vendor_model->get_where_dataa($table,$where);

$where='BYATRANPURA';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);
	echo json_encode($getalldata);
}
public function vijayapura_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
//$where=array('location'=>'VIJAYAPURA','received_qty >' => 0);
	//$getalldata = $this->vendor_model->get_where_dataa($table,$where);

$where='VIJAYAPURA';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);
	echo json_encode($getalldata);
}

public function doddajala_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
//$where=array('location'=>'DODDAJALA','received_qty >' => 0);
//	$getalldata = $this->vendor_model->get_where_dataa($table,$where);

$where='DODDAJALA';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);
	echo json_encode($getalldata);
}
public function kumara_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
///$where=array('location'=>'KUMARA PARK','received_qty >' => 0);
	//$getalldata = $this->vendor_model->get_where_dataa($table,$where);

$where='KUMARA PARK';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);

echo json_encode($getalldata);
}
public function dyeing_madeups_stock() {
	
	$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_madeups_delivery_confirmation';
//$where=array('location'=>'PEENYA - DYEING','received_qty >' => 0);
//	$getalldata = $this->vendor_model->get_where_dataa($table,$where);
$where='PEENYA - DYEING';
	$getalldata = $this->vendor_model->fetch_orderid_dese_location($where);
	echo json_encode($getalldata);
}
public function madeups_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='fabric_madeups_delivery_confirmation';
	$data['goods_id']=$this->store_model->fetch_where_subgrid_data($table,$where);
//print_r($data['goods_id']);
//die();

$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

echo json_encode($data);
	  
}
public function fabric_stock_merge()
{
	$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);
		
	$no_of_split=$this->input->post('no_of_split');
	$ref_id = $this->input->post('ref_id');
	$id_array = explode(",",$ref_id);
	$data['no_of_split']=$no_of_split;
	
	$data['getalldata']= $this->store_model->display_split_fabric_embroidryinspection_merge($id_array);
	//print_r($data['getalldata']);
	//die();
	echo json_encode($data);
	  
}

public function insert_madeups_split_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);
		
		$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$approved_by=$id['username'];
		
		$created_At=date('d/m/Y');
	
		
	 $table_ref_id = $this->input->post('table_ref_id');
	$table_split = $this->input->post('table_split');
	
	
 $r=$this->store_model->display_split_fabric_inspe_data_embroidryinspection($table_ref_id);
$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
	//print_r(sizeof($ssl_pc));
		
		//die();
 unset($rt);		
$rt='';	
$c=0;	
	 foreach($ssl_pc as $key=>$val)
	 {
		 if(sizeof($ssl_pc)-1 == $key )
		 {
			 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' ';
		 }
		 else
		 {
			 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' and ';
		 }
	$c++;	
	 }
	
			
	$this->load->library('email');
	 $this->email->set_mailtype('html');	
 //$msgs = '' . "Dear Sir / Madam, " . '' . ' ' . "OSL# ". $r->po_no . ", Width " . $r->width . ", " . $r->product_name . ", " . $r->shades . ", " . $r->ssl_pc_no . ", ". $r->balanced_mtrs . "MTR / " . $r->rec_weight . "WT" . ' has been splitted as '. $table_split . ' PCS by '. $approved_by . ' ' . ' The details are below:' . ' ' . 
//$rt . " Thank you" . ' ' . "SwanSilk (P) Ltd."; 
$actual_qty=$this->input->post('actual_qty');

$msgs="";	
$msgs .= "Dear Sir / Madam,".' ';	
$msgs .= "The following Fabric Stock has been splitted,".' ';
$msgs .= '<table class="table" border="1" cellpadding="0" cellspacing="0" style="border-collapse:collapse;">';
$msgs .= '<tr><td>'."Customer".'</td>';
$msgs .= '<td>'.$r->vendor_name.'</td></tr>';
$msgs .= '<tr><td>'."Order / PO #".'</td>';
$msgs .= '<td>'. $r->po_no .'</td></tr>';
$msgs .= '<tr><td>'."Width".'</td>';
$msgs .= '<td>'.$r->width.'</td></tr>';
$msgs .= '<tr><td>'."Article".'</td>';
$msgs .= '<td>' .$r->product_name.'</td></tr>';
$msgs .= '<tr><td>'."Design".'</td>';
$msgs .= '<td>'.$r->design.'</td></tr>';
$msgs .= '<tr><td>'."Shade".'</td>';
$msgs .= '<td>'.$r->shades.'</td></tr>';
$msgs .= '<tr><td>'."SSL PC#".'</td>';
$msgs .= '<td>'.$r->ssl_pc_no.'</td></tr>';
$msgs .= '<tr><td>'."Quantity".'</td>';
$msgs .= '<td>'.$actual_qty.'</td></tr>';
$msgs .= '<tr><td>'."Weight".'</td>';
$msgs .= '<td>'. $r->rec_weight .'</td></tr>';
$msgs .= '<tr><td>'."No.of PCS".'</td>';
$msgs .= '<td>'. $c.'</td></tr>';
$msgs .= '<tr><td>'."Created By".'</td>';
$msgs .= '<td>'. $approved_by .'</td></tr>';
$msgs .= '</table> ';

$msgs .= ''."The details are below:".' ';
$msgs .= '<table class="table" border="1" cellpadding="0" cellspacing="0" style="border-collapse:collapse;">';
$msgs .= '<tr><th>'."SSl PC#".'</th>';
$msgs .= '<th>'."Quantity".'</td></th>';
unset($rt);		
$rt='';	
	
	 foreach($ssl_pc as $key=>$val)
	 {
		 if(sizeof($ssl_pc)-1 == $key )
		 {
		//	 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' ';
			 $msgs .= '<tr><td>'.$ssl_pc[$key].'</td>';
 $msgs .= '<td>'.$qtty[$key].'</td></tr>';
		 }
		 else
		 {
		//	 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' and ';
				 $msgs .= '<tr><td>'.$ssl_pc[$key].'</td>';
 $msgs .= '<td>'.$qtty[$key].'</td></tr>';
		 }
		
	 }

$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
		
		
		foreach($refe_ids as $key=>$val)
		{			
			$where=$refe_ids[$key];
			$alldata= $this->store_model->display_split_fabric_detailsembroidryinspection($where);
		
			$data_link=array('po_list_id'=>$alldata->po_list_id,
						'po_id'=>$alldata->po_id,
						'insert_goods_id'=>$alldata->insert_goods_id,
						'reference_table'=>$alldata->reference_table,
						'refernce_table'=>$alldata->refernce_table,
						'po_no'=>$alldata->po_no,
						'osl_like'=>$alldata->osl_like,
						'indent_no'=>$alldata->indent_no,
						'quantity'=>$alldata->quantity,
						'quantity_approval'=>$alldata->quantity_approval,
						'product_name'=>$alldata->product_name,
						'p_name'=>$alldata->p_name,
						'vendor_name'=>$alldata->vendor_name,
						'design'=>$alldata->design,
						'shades'=>$alldata->shades,
						'width'=>$alldata->width,
						'splited_piece_no'=>$ssl_pc[$key],
						'rate'=>$alldata->rate,
						'inr'=>$alldata->inr,
						'rec_goods'=>$alldata->rec_goods,
						'rec_bal_goods'=>$alldata->rec_bal_goods,
						'remainning_quantity'=>$alldata->remainning_quantity,
						'available_quantity'=>$alldata->available_quantity,
						'rec_by'=>$approved_by,
						'received_date'=>$created_At,
						'bal_goods'=>$alldata->bal_goods,
						'rec_weight'=>$wei[$key],
						'consumed_at'=>$alldata->consumed_at,
						'piece_no'=>$alldata->piece_no,
						'no_type'=>$alldata->no_type,
						'no_type_val'=>$alldata->no_type_val,
						'indent_approved_by'=>$alldata->indent_approved_by,
						'po_approved_by'=>$alldata->po_approved_by,
						
						'orderType'=>$alldata->orderType,
						'rec_width'=>$alldata->rec_width,
						'width_of_size'=>$alldata->width_of_size,
						'warpPlandMtr'=>$alldata->warpPlandMtr,
						'weftPlandMtr'=>$alldata->weftPlandMtr,
						'buyerShade'=>$alldata->buyerShade,
						
						'transfer_loc_id'=>$alldata->transfer_loc_id,
						'pklist_id'=>$alldata->pklist_id,
						'exp_qty'=>$alldata->exp_qty,
						'exp_wt'=>$alldata->exp_wt,
						'status'=>$alldata->status,
'split_noti'=>'yes',
					
						
				 );
			$table_link='fabric_inspection_details';
		$this->db->insert($table_link,$data_link);
		$return_id=$this->db->insert_id();
		
		
		$where=$refe_ids[$key];
			$alldata= $this->store_model->display_split_fabric_inspe_embroidryinspection($where);
		
			$data=array('goods_id'=>$return_id,
						'sub'=>$alldata->sub,
						'quantity'=>$alldata->quantity,
						'inspected_mtrs'=>$alldata->inspected_mtrs,
						'inspected_weight'=>$alldata->inspected_weight,
						'balanced_mtrs'=>$qtty[$key],
						'rejected_mtrs'=>$alldata->rejected_mtrs,
						'rejected_weight'=>$alldata->rejected_weight,
						'variance_mtrs'=>$alldata->variance_mtrs,
						'variance_weight'=>$alldata->variance_weight,
						'ssl_pc_no'=>$alldata->ssl_pc_no,
						'sl_ssl_pc_no'=>$alldata->sl_ssl_pc_no,
						'inspected_person'=>$alldata->inspected_person,
						'sys_date'=>$alldata->sys_date,
						'location'=>$alldata->location,
						'remarks'=>$alldata->remarks,
						
						'transfer_status'=>$alldata->transfer_status,
						'status'=>$alldata->status,
						
				 );
			$table='fabric_inspection';
		$this->db->insert($table,$data);
		
		
		
		}
		$r=$this->input->post('table_ref_id');
		
		
		
		$where=array('id'=>$r);
		$tale='fabric_inspection_details';
		$this->vendor_model->delete_vendor($table,$where);
		
		$r=$this->input->post('table_ref_id');
		$where=array('goods_id'=>$r);
		$tale='fabric_inspection';
		$this->vendor_model->delete_vendor($table,$where);
		
		 echo json_encode($data);
		 
		 
	}
	public function insert_madeups_split_data_cut_width()
	{
	 //print_r($_POST);
	 // die();
	$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);
		
		$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$approved_by=$id['username'];
		
		$created_At=date('d/m/Y');
	
		
	 $table_ref_id = $this->input->post('table_ref_id');
	$table_split = $this->input->post('table_split');
	
	
 $r=$this->store_model->display_split_fabric_inspe_data_embroidryinspection($table_ref_id);
$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
			$cut_width = $this->input->post('cut_width');
	//print_r(sizeof($ssl_pc));
		
		//die();
 unset($rt);		
$rt='';	
$c=0;	
	 foreach($ssl_pc as $key=>$val)
	 {
		 if(sizeof($ssl_pc)-1 == $key )
		 {
			 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' ';
		 }
		 else
		 {
			 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' and ';
		 }
	$c++;	
	 }
	
			
	$this->load->library('email');
	 $this->email->set_mailtype('html');	
 //$msgs = '' . "Dear Sir / Madam, " . '' . ' ' . "OSL# ". $r->po_no . ", Width " . $r->width . ", " . $r->product_name . ", " . $r->shades . ", " . $r->ssl_pc_no . ", ". $r->balanced_mtrs . "MTR / " . $r->rec_weight . "WT" . ' has been splitted as '. $table_split . ' PCS by '. $approved_by . ' ' . ' The details are below:' . ' ' . 
//$rt . " Thank you" . ' ' . "SwanSilk (P) Ltd."; 
$actual_qty=$this->input->post('actual_qty');

$msgs .= ''."The details are below:".' ';
$msgs .= '<table class="table" border="1" cellpadding="0" cellspacing="0" style="border-collapse:collapse;">';
$msgs .= '<tr><th>'."SSl PC#".'</th>';
$msgs .= '<th>'."Quantity".'</th>';
$msgs .= '<th>'."Width".'</th>';
unset($rt);		
$rt='';	
	
	 foreach($ssl_pc as $key=>$val)
	 {
		 if(sizeof($ssl_pc)-1 == $key )
		 {
		//	 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' ';
			 $msgs .= '<tr><td>'.$ssl_pc[$key].'</td>';
 $msgs .= '<td>'.$qtty[$key].'</td>';
 $msgs .= '<td>'.$cut_width[$key].'CMS'.'</td></tr>';
		 }
		 else
		 {
		//	 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' and ';
				 $msgs .= '<tr><td>'.$ssl_pc[$key].'</td>';
 $msgs .= '<td>'.$qtty[$key].'</td>';
 $msgs .= '<td>'.$cut_width[$key].'CMS'.'</td></tr>';
		 }
		
	 }

$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
		
		
		foreach($refe_ids as $key=>$val)
		{			
			$where=$refe_ids[$key];
			$alldata= $this->store_model->display_split_fabric_detailsembroidryinspection($where);
		
			$data_link=array('po_list_id'=>$alldata->po_list_id,
						'po_id'=>$alldata->po_id,
						'insert_goods_id'=>$alldata->insert_goods_id,
						'reference_table'=>$alldata->reference_table,
						'refernce_table'=>$alldata->refernce_table,
						'po_no'=>$alldata->po_no,
						'osl_like'=>$alldata->osl_like,
						'indent_no'=>$alldata->indent_no,
						'quantity'=>$alldata->quantity,
						'quantity_approval'=>$alldata->quantity_approval,
						'product_name'=>$alldata->product_name,
						'p_name'=>$alldata->p_name,
						'vendor_name'=>$alldata->vendor_name,
						'design'=>$alldata->design,
						'shades'=>$alldata->shades,
						'width'=>$cut_width[$key].'CMS',
						'splited_piece_no'=>$ssl_pc[$key],
						'rate'=>$alldata->rate,
						'inr'=>$alldata->inr,
						'rec_goods'=>$alldata->rec_goods,
						'rec_bal_goods'=>$alldata->rec_bal_goods,
						'remainning_quantity'=>$alldata->remainning_quantity,
						'available_quantity'=>$alldata->available_quantity,
						'rec_by'=>$approved_by,
						'received_date'=>$created_At,
						'bal_goods'=>$alldata->bal_goods,
						'rec_weight'=>$wei[$key],
						'cut_width'=>$cut_width[$key].'CMS',
						'consumed_at'=>$alldata->consumed_at,
						'piece_no'=>$alldata->piece_no,
						'no_type'=>$alldata->no_type,
						'no_type_val'=>$alldata->no_type_val,
						'indent_approved_by'=>$alldata->indent_approved_by,
						'po_approved_by'=>$alldata->po_approved_by,
						
						'orderType'=>$alldata->orderType,
						'rec_width'=>$alldata->rec_width,
						'width_of_size'=>$alldata->width_of_size,
						'warpPlandMtr'=>$alldata->warpPlandMtr,
						'weftPlandMtr'=>$alldata->weftPlandMtr,
						'buyerShade'=>$alldata->buyerShade,
						
						'transfer_loc_id'=>$alldata->transfer_loc_id,
						'pklist_id'=>$alldata->pklist_id,
						'exp_qty'=>$alldata->exp_qty,
						'exp_wt'=>$alldata->exp_wt,
						'status'=>$alldata->status,
'split_noti'=>'yes',
					
						
				  );
			$table_link='fabric_inspection_details';
		$this->db->insert($table_link,$data_link);
		$return_id=$this->db->insert_id();
		
		//print_r($this->db->last_query());
	//	die();
		
	
		$where=$refe_ids[$key];
			$alldata= $this->store_model->display_split_fabric_inspe_embroidryinspection($where);
		
			$data=array('goods_id'=>$return_id,
						'sub'=>$alldata->sub,
						'quantity'=>$alldata->quantity,
						'inspected_mtrs'=>$alldata->inspected_mtrs,
						'inspected_weight'=>$alldata->inspected_weight,
						'balanced_mtrs'=>$qtty[$key],
						'rejected_mtrs'=>$alldata->rejected_mtrs,
						'rejected_weight'=>$alldata->rejected_weight,
						'variance_mtrs'=>$alldata->variance_mtrs,
						'variance_weight'=>$alldata->variance_weight,
						'ssl_pc_no'=>$alldata->ssl_pc_no,
						'sl_ssl_pc_no'=>$alldata->sl_ssl_pc_no,
						'inspected_person'=>$alldata->inspected_person,
						'sys_date'=>$alldata->sys_date,
						'location'=>$alldata->location,
						'remarks'=>$alldata->remarks,
						
						'transfer_status'=>$alldata->transfer_status,
						'status'=>$alldata->status,
						
				  );
			$table='fabric_inspection';
		$this->db->insert($table,$data);
		
		
		
		}
		$r=$this->input->post('table_ref_id');
		
		
		
		$where=array('id'=>$r);
 		$tale='fabric_inspection_details';
 		$this->vendor_model->delete_vendor($table,$where);
		
 		$r=$this->input->post('table_ref_id');
 		$where=array('goods_id'=>$r);
		$tale='fabric_inspection';
		$this->vendor_model->delete_vendor($table,$where);
		
		 echo json_encode($data);
		 
		 
	}
	public function insert_madeups_merge()
	{
	    //print_r($_POST);
	    //die();
	$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);
		
		$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$approved_by=$id['username'];
		
		$created_At=date('d-m-Y');
	
		
	 $table_ref_id = $this->input->post('table_ref_id');
	$table_split = $this->input->post('table_split');
	
	$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
		$width=$this->input->post('width');
	
	
 $r=$this->store_model->display_split_fabric_inspe_data_embroidryinspection($table_ref_id);
 
//$where=$refe_ids[0];
//$r = $this->store_model->display_split_fabric_inspe_data_embroidryinspection($refe_ids[0]);

$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
			//$cut_width = $this->input->post('cut_width');
	//print_r(sizeof($ssl_pc));
		
		//die();
 unset($rt);		
$rt='';	
$c=0;	
	 foreach($ssl_pc as $key=>$val)
	 {
		 if(sizeof($ssl_pc)-1 == $key )
		 {
			 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' ';
		 }
		 else
		 {
			 $rt.=$ssl_pc[$key] . ', Qty ' . $qtty[$key] . 'Mtrs/' . $wei[$key] . 'Wt' . ' and ';
		 }
	$c++;	
	 }
	
			
	$this->load->library('email');
	 $this->email->set_mailtype('html');	
 //$msgs = '' . "Dear Sir / Madam, " . '' . ' ' . "OSL# ". $r->po_no . ", Width " . $r->width . ", " . $r->product_name . ", " . $r->shades . ", " . $r->ssl_pc_no . ", ". $r->balanced_mtrs . "MTR / " . $r->rec_weight . "WT" . ' has been splitted as '. $table_split . ' PCS by '. $approved_by . ' ' . ' The details are below:' . ' ' . 
//$rt . " Thank you" . ' ' . "SwanSilk (P) Ltd."; 
$actual_qty=$this->input->post('actual_qty');

$msgs .= '<tr><td>'."Quantity".'</td>';
$msgs .= '<td>'.$actual_qty.'</td></tr>';

$msgs .= '<tr><td>'."Weight".'</td>';
$msgs .= '<td>'. $r->rec_weight .'</td></tr>';
$msgs .= '<tr><td>'."No.of PCS".'</td>';
$msgs .= '<td>'. $c.'</td></tr>';
$msgs .= '<tr><td>'."Created By".'</td>';
$msgs .= '<td>'. $approved_by .'</td></tr>';
$msgs .= '</table> ';

$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
		$width=$this->input->post('width');
		
		
		foreach($refe_ids as $key=>$val)
		{			
			$where=$refe_ids[$key];
			$alldata= $this->store_model->display_split_fabric_detailsembroidryinspection($where);
		
			$data_link=array('po_list_id'=>$alldata->po_list_id,
						'po_id'=>$alldata->po_id,
						'insert_goods_id'=>$alldata->insert_goods_id,
						'reference_table'=>$alldata->reference_table,
						'refernce_table'=>$alldata->refernce_table,
						'po_no'=>$alldata->po_no,
						'osl_like'=>$alldata->osl_like,
						'indent_no'=>$alldata->indent_no,
						'quantity'=>$alldata->quantity,
						'quantity_approval'=>$alldata->quantity_approval,
						'product_name'=>$alldata->product_name,
						'p_name'=>$alldata->p_name,
						'vendor_name'=>$alldata->vendor_name,
						'design'=>$alldata->design,
						'shades'=>$alldata->shades,
						'width'=>$width[$key].'CMS',
						'splited_piece_no'=>$ssl_pc[$key],
						'rate'=>$alldata->rate,
						'inr'=>$alldata->inr,
						'rec_goods'=>$alldata->rec_goods,
						'rec_bal_goods'=>$alldata->rec_bal_goods,
						'remainning_quantity'=>$alldata->remainning_quantity,
						'available_quantity'=>$alldata->available_quantity,
						'rec_by'=>$approved_by,
						'received_date'=>$created_At,
						'bal_goods'=>$alldata->bal_goods,
						'rec_weight'=>$wei[$key],
						//'cut_width'=>$cut_width[$key].'CMS',
						'consumed_at'=>$alldata->consumed_at,
						'piece_no'=>$alldata->piece_no,
						'no_type'=>$alldata->no_type,
						'no_type_val'=>$alldata->no_type_val,
						'indent_approved_by'=>$alldata->indent_approved_by,
						'po_approved_by'=>$alldata->po_approved_by,
						
						'orderType'=>$alldata->orderType,
						'rec_width'=>$alldata->rec_width,
						'width_of_size'=>$alldata->width_of_size,
						'warpPlandMtr'=>$alldata->warpPlandMtr,
						'weftPlandMtr'=>$alldata->weftPlandMtr,
						'buyerShade'=>$alldata->buyerShade,
						
						'transfer_loc_id'=>$alldata->transfer_loc_id,
						'pklist_id'=>$alldata->pklist_id,
						'exp_qty'=>$alldata->exp_qty,
						'exp_wt'=>$alldata->exp_wt,
						'status'=>$alldata->status,
'split_noti'=>'yes',
					
						
				 );
			$table_link='fabric_inspection_details';
		$this->db->insert($table_link,$data_link);
		$return_id=$this->db->insert_id();
		
		//print_r($this->db->last_query());
		//die();
		
	
		$where=$refe_ids[$key];
			$alldata= $this->store_model->display_split_fabric_inspe_embroidryinspection($where);
		
			$data=array('goods_id'=>$return_id,
						'sub'=>$alldata->sub,
						'quantity'=>$alldata->quantity,
						'inspected_mtrs'=>$alldata->inspected_mtrs,
						'inspected_weight'=>$alldata->inspected_weight,
						'balanced_mtrs'=>$qtty[$key],
						'rejected_mtrs'=>$alldata->rejected_mtrs,
						'rejected_weight'=>$alldata->rejected_weight,
						'variance_mtrs'=>$alldata->variance_mtrs,
						'variance_weight'=>$alldata->variance_weight,
						'ssl_pc_no'=>$alldata->ssl_pc_no,
						'sl_ssl_pc_no'=> 'JF '.$alldata->sl_ssl_pc_no,
						'inspected_person'=>$alldata->inspected_person,
						'sys_date'=>$alldata->sys_date,
						'location'=>$alldata->location,
						'remarks'=>$alldata->remarks,
						
						'transfer_status'=>$alldata->transfer_status,
						'status'=>$alldata->status,
						
				 );
			$table='fabric_inspection';
		$this->db->insert($table,$data);
		
		
		
		}
		$r=$this->input->post('table_ref_id');
		
		$arr = array();
		$arr = explode(",",$r);
		
		$i = 0;
		for($i = 0; $i < count($arr); $i++){
		 $id = $arr[$i];
		 $where=array('id'=>$id);
		 
		 
		 $table = 'fabric_inspection_details';
		 $data=array('merge_fabric'=>$return_id);
		 $this->store_model->update_data($where,$table,$data);
		 
		 
		}
		
		$i = 0;
		
		for($i = 0; $i < count($arr); $i++){
		 $id = $arr[$i];
		 $where = array('goods_id'=>$id);
		 
		 $table='fabric_inspection';
		 $data=array('balanced_mtrs'=>'0');
		 $this->store_model->update_data($where,$table,$data);
		 
		 
		}
		
		 echo json_encode($data);
		 
		 
	}
public function madeups_bar_code_generate()
	{
	$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);
		$data['url_id']=$val;
			
		$table='fabric_madeups_delivery_confirmation';
		$where=array('id'=>$val);
		$data['fetch_goods_data']=$this->outsource_model->fetch_where_row_data($table,$where);

$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);

public function madeups_stock_split()
{
	$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);
		
	$no_of_split=$this->input->post('no_of_split');
	$ref_id=$this->input->post('ref_id');
	
	$data['no_of_split']=$no_of_split;
	
	$table = 'fabric_madeups_delivery_confirmation';
	$where=array('id' => $ref_id);
	$data['getalldata'] = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	//print_r($data['no_of_split']);
	//die();
	//$data['getalldata']= $this->store_model->display_split_fabric_embroidryinspection($ref_id);

echo json_encode($data);
	  
}
public function insert_madeups_madeups_split_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);
		
		$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$approved_by=$id['username'];
		
		$created_At=date('d/m/Y');
	
		
	
		$refe_ids = $this->input->post('r_ids');
		$wei=$this->input->post('rec_wt');
		$qtty=$this->input->post('rec_qt');
		$ssl_pc=$this->input->post('ssl_pc');
		
		//ssl_pc
		
		foreach($refe_ids as $key=>$val)
		{			
			$table = 'fabric_madeups_delivery_confirmation';
			$where=array('id' => $refe_ids[$key]);
			$alldata = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	
		//	$where=$refe_ids[$key];
		//	$alldata= $this->store_model->display_split_fabric_detailsembroidryinspection($where);
		
			$data=array('ref_id'=>$alldata->ref_id,
						'osl'=>$alldata->osl,
						'order_type'=>$alldata->order_type,
						'size'=>$alldata->size,
						'pklist_id'=>$alldata->pklist_id,
						'exp_qty'=>$alldata->exp_qty,
						'exp_wt'=>$alldata->exp_wt,
						'article'=>$alldata->article,
						'design'=>$alldata->design,
						'shade'=>$alldata->shade,
						'description'=>$alldata->description,
						'ssl_shade'=>$alldata->ssl_shade,
						'order_qty'=>$alldata->order_qty,
						'received_qty'=>$qtty[$key],
						'received_wt'=>$wei[$key],
						'received_qty_ref'=>$alldata->received_qty_ref,
						
						'bal_qty'=>$alldata->bal_qty,
						'batch_no'=>$alldata->batch_no,
						'box_data'=>$alldata->box_data,
						'batch_id'=>$alldata->batch_id,
						'in_dc_no'=>$alldata->in_dc_no,
						'in_dc_val'=>$alldata->in_dc_val,
						'rec_by'=>$approved_by,
						'rec_date'=>$created_At,
						'location'=>$alldata->location,
						//'rec_weight'=>$wei[$key],
						'remarks'=>$alldata->remarks,
						'balance_pakg_qty'=>$alldata->balance_pakg_qty,
						'status'=>$alldata->status,
						'issue_mtrs'=>$alldata->issue_mtrs,
						'edit_list'=>$alldata->edit_list,
						'all_stock_data'=>$alldata->all_stock_data,
						'batch_split'=>$ssl_pc[$key],
						'madeups_custom_status'=>$alldata->madeups_custom_status,
						'insert_notification_status'=>$alldata->insert_notification_status,
					'split_noti'=>'Yes',
					
						
				  );
			$table='fabric_madeups_delivery_confirmation';
		$this->db->insert($table,$data);
		$return_id=$this->db->insert_id();
		
		
		
		
		}
		$r=$this->input->post('table_ref_id');
		
		$where=array('id'=>$r);
		$tale='fabric_madeups_delivery_confirmation';
		$this->vendor_model->delete_vendor($table,$where);
		
		 echo json_encode($data);
		 
	}
	
	public function insert_madeups_sequence_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);
		
		$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$approved_by=$id['username'];
		
		$created_At=date('d/m/Y');
	
		$seq_id = $this->input->post('seq_id');
		$rec_wt=$this->input->post('rec_wt');
		$rec_qty=$this->input->post('rec_qty');
		$seq=$this->input->post('seq');
		
		//ssl_pc
		
		foreach($seq_id as $key=>$val)
		{			
			$data=array(
						'received_qty'=>$rec_qty[$key],
						'received_wt'=>$rec_wt[$key],
					    'sequence'=>$seq[$key],
				  );
		    $where=array('id' => $seq_id[$key]);
			$table='fabric_madeups_delivery_confirmation';
    		$this->vendor_model->update_data($where,$table,$data);
    
		}
	
		 echo json_encode($data);
		 
	}
	
	
	
////////////////////////////////////////  edit option  of stock ////////////////////////////////////////////////////////////
public function fabric_stock_edit()
{
	$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"]; 
         $uri = $_SERVER["REQUEST_URI"]; 
        $data['val'] = substr($uri, strpos($uri, "=") + 1);
	$vall = substr($uri, strpos($uri, "=") + 1);
$data['res_val']=$this->store_model->edit_display_fabric_embroidryinspection($vall);	
	//$where=array('id'=>$val);
$table='orders';
$where=array('confirm_status'=>'CONFIRMED','orderType'=>'DTL');
	$data['result']=$this->store_model->get_data_fetch_new($table,$where);

$table='customer_master';
	$data['customer_result']=$this->store_model->custom_get_details($table);
	
	$id=$this->session->userdata('logged_in');
  $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

$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_details/fabric_edit');
	$this->load->view('templates/footer_inside');
	  
}
public function insert_new_osl_data()
{
	$ref_id=$this->input->post('ref_id');
   $osl_num=$this->input->post('osl_num');
    $fileNo=$this->input->post('fileNo');
    $product_name=$this->input->post('product_name');
   $width=$this->input->post('width');
    $design=$this->input->post('design');
    $shades=$this->input->post('shades');
   $rec_weight=$this->input->post('rec_weight');
    $balanced_mtrs=$this->input->post('balanced_mtrs');
  
  $table='fabric_inspection_details';
  $where=array('id'=>$ref_id);
  $fab_details=$this->store_model->fetch_where_subgrid_data($table,$where);
  
  
  
 
 $data_det=array('po_list_id' =>  $fab_details->po_list_id,
    'po_id' =>  $fab_details->po_id,
    'insert_goods_id' => $fab_details->insert_goods_id,
    'reference_table' =>  $fab_details->reference_table,
    'refernce_table' =>  $fab_details->refernce_table,
    'customer_id' =>  $fileNo,
    'po_no' =>  $osl_num,
    'osl_like' =>  $fab_details->osl_like,
    'indent_no' =>  $fab_details->indent_no,
    'unit' =>  $fab_details->unit,
    'units_val' =>  $fab_details->units_val,
    'quantity' =>  $fab_details->quantity,
    'quantity_approval' =>  $fab_details->quantity_approval,
    'product_name' =>  $product_name ,   //$fab_details->product_name,
    'p_name' =>  $fab_details->p_name,
    'vendor_name' =>  $fab_details->vendor_name,
    'design' =>  $design,       //$fab_details->design,
    'shades' =>  $shades,       //$fab_details->shades,
    'width' =>  $width,        //$fab_details->width,
    'rate' =>  $fab_details->rate,
    'inr' =>  $fab_details->inr,
    'rec_goods' =>  $fab_details->rec_goods,
    'rec_bal_goods' =>  $fab_details->rec_bal_goods,
    'remainning_quantity' =>  $fab_details->remainning_quantity,
    'available_quantity' =>  $fab_details->available_quantity,
    'bal_goods' =>  $fab_details->bal_goods,
    'received_date' =>  $fab_details->received_date,
    'rec_by' =>  $fab_details->rec_by,
    'rec_weight' =>  $rec_weight,     //$fab_details->rec_weight,
    'consumed_at' =>  $fab_details->consumed_at,
    'piece_no' =>  $fab_details->piece_no,
    'splited_piece_no' =>  $fab_details->splited_piece_no,
    'no_type' =>  $fab_details->no_type,
    'no_type_val' =>  $fab_details->no_type_val,
    'indent_approved_by' =>  $fab_details->indent_approved_by,
    'po_approved_by' =>  $fab_details->po_approved_by,
    'orderType' =>  $fab_details->orderType,
    'rec_width' =>  $fab_details->rec_width,
    'width_of_size' => $fab_details->width_of_size,
    'warpPlandMtr' =>  $fab_details->warpPlandMtr,
    'weftPlandMtr' =>  $fab_details->weftPlandMtr,
    'buyerShade' =>  $fab_details->buyerShade,
    'transfer_loc_id' =>  $fab_details->transfer_loc_id,
    'pklist_id' =>  $fab_details->pklist_id,
    'exp_qty' =>  $fab_details->exp_qty,
    'exp_wt' =>  $fab_details->exp_wt,
    'status' =>  $fab_details->status,
	);
  
   $table='fabric_inspection_details';
  $this->db->insert($table,$data_det);
 $t=$this->db->insert_id();
  
$where=array('ref_id'=>$ref_id);
	$table='inspection_qc';
$data_qc=array('ref_id'=>$t);
$this->store_model->update_data($where,$table,$data_qc);

$table='fabric_inspection';
 $where=array('goods_id'=>$ref_id); 
 $fab_inspection=$this->store_model->fetch_where_subgrid_data($table,$where);
 
 $data_ins=array('goods_id' => $t,
 'sub' => $fab_inspection->sub,
 'quantity' => $fab_inspection->quantity,
 'inspected_mtrs' => $fab_inspection->inspected_mtrs,
 'inspected_weight' => $fab_inspection->inspected_weight,
 'balanced_mtrs' => $balanced_mtrs, //$fab_inspection->balanced_mtrs,
 'rejected_mtrs' => $fab_inspection->rejected_mtrs,
 'rejected_weight' => $fab_inspection->rejected_weight,
 'variance_mtrs' => $fab_inspection->variance_mtrs,
 'variance_weight' => $fab_inspection->variance_weight,
 'ssl_pc_no' => $fab_inspection->ssl_pc_no,
 'sl_ssl_pc_no' => $fab_inspection->sl_ssl_pc_no,
 'inspected_person' => $fab_inspection->inspected_person,
 'sys_date' => $fab_inspection->sys_date,
 'location' => $fab_inspection->location,
 'remarks' => $fab_inspection->remarks,
 'transfer_status' => $fab_inspection->transfer_status,
 'created_by' => $fab_inspection->created_by,
 'created_date' => $fab_inspection->created_date,
 'status' => $fab_inspection->status,
 'insert_notification_status' => $fab_inspection->insert_notification_status,
	);
	
 $table='fabric_inspection';
 $this->db->insert($table,$data_ins);
 
 $table='fabric_inspection_details';
 $where=array('id'=>$ref_id);
 $data_ins_update=array('rec_weight' => 0.00);
 $this->store_model->update_data($where,$table,$data_ins_update);
 
 $table='fabric_inspection';
 $where=array('goods_id'=>$ref_id);
 $data_det_update=array('balanced_mtrs' => 0.00);
 $this->store_model->update_data($where,$table,$data_det_update);
 
 $osl_num=$this->input->post('osl_num');
 $fileNo=$this->input->post('fileNo');
	$ol_osl = $fab_details->po_no;
	$customer_id = $fab_details->customer_id;
	
	
	 $rec_weight = $fab_details->rec_weight;
	 $balanced_mtrs = $fab_inspection->balanced_mtrs;
	 $product_name = $fab_details->product_name;
 $p_name = $fab_details->p_name;
 
 $design = $fab_details->design;
 $shades = $fab_details->shades;
 $width = $fab_details->width;
	
	 $id=$this->session->userdata('logged_in');
 $where=array('id'=>$id);
 $approved_by=$id['username']; 
 $this->load->library('email');
 $this->email->set_mailtype('html');	
 //$msgs = '' . "Dear Sir / Madam, " . '' . ' ' . "OSL# ". $ol_osl . ", Customer ID " . $customer_id . " has been changed to " . "OSL# " . $osl_num . " & Customer ID" . $fileNo . " By " . $approved_by . " having a details of Article" . $product_name . ", Shade ". $shades . ", Width " . $width . ", Design " . $design . " & " . $balanced_mtrs . "MTR / " . $rec_weight . "WT" . ' ' . " Thank you" . ' ' . "Deco-Textil";

$msgs="";	
$msgs .= "Dear Sir / Madam,".' ';	
$msgs .= "The following , Fabric Stock ,".' ';
$msgs .= '<table class="table" border="1" cellpadding="0" cellspacing="0" style="border-collapse:collapse;">';
$msgs .= '<tr><td>'."Customer ID".'</td>';
$msgs .= '<td>'.$customer_id.'</td></tr>';
$msgs .= '<tr><td>'."Order / PO #".'</td>';
$msgs .= '<td>'. $osl_num .'</td></tr>';
$msgs .= '<tr><td>'."Width".'</td>';
$msgs .= '<td>'.$width.'</td></tr>';
$msgs .= '<tr><td>'."Article".'</td>';
$msgs .= '<td>' .$product_name.'</td></tr>';
$msgs .= '<tr><td>'."Design".'</td>';
$msgs .= '<td>'.$design.'</td></tr>';
$msgs .= '<tr><td>'."Shade".'</td>';
$msgs .= '<td>'.$shades.'</td></tr>';
$msgs .= '<tr><td>'."SSL PC#".'</td>';
$msgs .= '<td>'.$fab_inspection->ssl_pc_no.'</td></tr>';
$msgs .= '<tr><td>'."Quantity".'</td>';
$msgs .= '<td>'. $fab_details->quantity .'</td></tr>';
$msgs .= '<tr><td>'."Weight".'</td>';
$msgs .= '<td>'. $rec_weight .'</td></tr>';
$msgs .= '<tr><td>'."No.of PCS".'</td>';
$msgs .= '<td>'. $fab_inspection->sl_ssl_pc_no.'</td></tr>';
$msgs .= '<tr><td>'."Created By".'</td>';
$msgs .= '<td>'. $fab_inspection->created_by .'</td></tr>';
$msgs .= '</table> ';

$msgs .= '<tr><td>'.$fab_inspection->ssl_pc_no.'</td>';
$msgs .= '<td>'.$fab_details->quantity.'</td></tr>';

$msgs .= '</table> ';
$msgs .= "Thank you,".' ';
$msgs .= "Regards,".' ';
$msgs .= "Swan Silk / Deco Textil.".' ';
$msgs .= ''."Note: Please do not reply to this mail as this is as automated mail service.".'';
	
	// $this->email->from('swansilkhouse@gmail.com', 'swansilk123');
	$this->email->from('ERP@swansilk.com', 'Swan Silk (P) Ltd');
	 $this->email->to('navin@swansilk.com');
	 $this->email->cc('ppc@swansilk.com');
	 $this->email->subject('Swan / Deco Fabric Stock Split Details');	
	 
	 $data['message'] = $msgs;
	 $this->email->message($msgs);
	 $this->email->send(); 
 $res=1;
 echo json_encode($res);
}
public function yarn_remnants_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='issue_loom';
	$data['details']= $this->outsource_model->history_rements_rows_desc_dyeing_grid_data($val);
	
	$id=$this->session->userdata('logged_in');
 $where=array('id'=>$id);
	$data['approved_by']=$id['username'];
	
	$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);

$table='remnants';
$where=array('id'=>$id);
$remnnats_rows=$this->outsource_model->get_customerdata($table,$where);

if($remnnats_rows->ref_table == 'weaving')
{

$table='create_weaving_work_order';
$wheres=array('id'=>$remnnats_rows->issue_loom_id);
$data_weaving=array('remnants'=>'','rem_location'=>'','bag'=>'','rements_approval_by'=>'','rements_approved_date'=>'');		
$this->outsource_model->update_data($wheres,$table,$data_weaving);

$table='remnants';
$where=array('id'=>$id);
$this->outsource_model->delete_vendor($table,$where);

}
else if($remnnats_rows->ref_table == 'issue loom')
{
$table='remnants';
$where=array('id'=>$id);
$table_val_fetch=$this->outsource_model->back_to_remnants_val($id);

$table_id=$table_val_fetch->yarn_ids;
     
       
       $arr = preg_match_all('/([0-9]+|[a-zA-Z]+)/',$table_id,$matches);
       $first_input_field = $matches[0];    
       $second_input_field = $matches[1];

if($second_input_field[0] == 'r')
       {
          $table='indent_yarn_goods_details';
          $where=array('id'=>$second_input_field[1]);
          $data=array('issue_net_weight'=>0);
           $data=$this->vendor_model->update_po_list_confirm_purchase($table,$data,$where);
       }
       else if($second_input_field[0] == 't')
       {
          $table='delivery_yarn_twisting';
          $where=array('id'=>$second_input_field[1]);
          $data=array('issue_net_weight'=>0);
           $data=$this->vendor_model->update_po_list_confirm_purchase($table,$data,$where);
       }
       else if($second_input_field[0] == 'd')
       {
          $table='indent_yarn_goods_details';
          $where=array('id'=>$second_input_field[1]);
          $data=array('issue_net_weight'=>0);
           $data=$this->vendor_model->update_po_list_confirm_purchase($table,$data,$where);
       }
        else if($second_input_field[0] == 's')
       {
          $table='work_order_dyeing';
          $where=array('id'=>$second_input_field[1]);
          $data=array('rec_dyed_qua'=>0);
           $data=$this->vendor_model->update_po_list_confirm_purchase($table,$data,$where);
       }

$table='issue_loom';
$wheres=array('id'=>$table_val_fetch->issue_loom_id);
$details_val=array('rements'=>'',
'rements_stock'=>'',
'issue_net_wt'=>'',
'balanced_stock_wt'=>'',
'rements_approval_by'=>'',
'rements_approved_date'=>'',
'bag'=>'',
'remnants_location'=>'');

$details=$this->outsource_model->update_data($wheres,$table,$details_val);

$table='remnants';
$where=array('id'=>$id);
$this->outsource_model->delete_vendor($table,$where);
}
else
{

}

$results='success';
 echo json_encode($results);
}
////////////////////// 22-11-2018 //////////////////////////
public function stock_piece_card()
{
	$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('checked_ids');
	$checked_radios=$this->input->post('checked_radios');

if($checked_radios == 'raw_yarn')
	{

if($data2 == '')
			{

$data['result']=array();
				
			}
			else
			{

$data1=substr($data2, 0, -1);
				$exp=array();
				$path = explode("|", $data1);
				$exp = array_merge($exp, $path);
				$expp = array_merge($exp, $path);
			
				$w_mtrs=array();
				$osl_details=array();
				foreach($exp as $val)
				{
					$table='work_order_dyeing';
					$where=$val;
					$arr=$this->outsource_model->get_work_raw_yarn_order_grid_data($where);
					array_push($osl_details,$arr);
				}
				
				
				$data['result']=$osl_details;
$data['types'] = 'Yarn-Raw';
			}

$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$data['approved_by']=$id['username'];

$id=$this->session->userdata('logged_in');
		  $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);

}
else if($checked_radios == 'twisted_yarn')
	{
		if($data2 == '')
			{
				$data['result']=array();
				
			}
			else
			{
				$data1=substr($data2, 0, -1);
				$exp=array();
				$path = explode("|", $data1);
				$exp = array_merge($exp, $path);
				$expp = array_merge($exp, $path);
			
				$w_mtrs=array();
				$osl_details=array();
				foreach($exp as $val)
				{
					$table='delivery_yarn_twisting';
					$where=array('id'=>$val);
					$arr=$this->outsource_model->get_embroidery_twisting_data($table,$where);
	
					array_push($osl_details,$arr);
				}
				
				
				$data['result']=$osl_details;
				$osl_details_res=$osl_details;
				$data['types'] = 'Yarn-Twisted';
				
				$osl_details_result=array();
				foreach($osl_details_res as $val)
				{
					if($val->reference_table == 'indent_yarn_goods_details')
					{
						$vals=$val->reference_id;
						$arrs_res=$this->outsource_model->get_stock_position_yarn_data($vals);
						array_push($osl_details_result,$arrs_res);
					}
					elseif($val->reference_table == 'work_order_twisting')
					{
						$vals=$val->reference_id;
						$arrs=$this->outsource_model->get_stock_position_work_order_twisting_res($vals);
						array_push($osl_details_result,$arrs);
					}
					
					
				}
			}
		$data['result_po']=$osl_details_result;
		
		
		$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);
		$data['approved_by']=$id['username'];

else if($checked_radios == 'remnant_yarn')
	{
		if($data2 == '')
			{
				$data['result']=array();
				
			}
			else
			{
				$data1=substr($data2, 0, -1);
				$exp=array();
				$path = explode("|", $data1);
				$exp = array_merge($exp, $path);
				$expp = array_merge($exp, $path);
			
				$w_mtrs=array();
				$osl_details=array();
				foreach($exp as $val)
				{

$table='remnants';
					$where=array('id'=>$val);
$arr_remnants=$this->outsource_model->get_customerdata($table,$where);

if($arr_remnants->ref_table == 'issue loom')
{
$where=$val;
$arr=$this->outsource_model->history_rements_desc_dyeing_grid_data_val($where);
}
else
{
$where=$val;
$arr=$this->outsource_model->history_rements_desc_weaving_grid_data_val($where);
}

//$table='work_order_dyeing';
					//$where=$val;
					//$arr=$this->outsource_model->display_yarn_dyed_grid_stock_detailed_data_group($where);
	
					array_push($osl_details,$arr);
				}
				
				$data['result']=$osl_details;
				$data['types'] = 'Remnants';

}

$id=$this->session->userdata('logged_in');
		$where=array('id'=>$id);
		$data['approved_by']=$id['username'];

}
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 edit_madeups_rec_wt()
{
	$table = 'fabric_madeups_delivery_confirmation';

$id=$_REQUEST['id'];
	$received_wt=$_REQUEST['received_wt'];

$data = array(
			'id' => $id,
			'received_wt' => $received_wt,
	);
	$table='fabric_madeups_delivery_confirmation';
	$where=array('id'=>$id);

$this->vendor_model->update_po_list_confirm_purchase($table,$data,$where);
}
}