EVOLUTION-NINJA

Edit File: Upload_xsl.php

<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx as XlsxReader;

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

class Upload_xsl 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('outsource_model');
$this->load->model('request_model');
$this->load->model('vendor_model');
$this->load->database();
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 access_details()
	{
		$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_where_data($table,$where);
	}
	public function access_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);
	return $d->user_type_id;
	}
		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);

$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('vendor_master/notification_page',$data);
	$this->load->view('templates/footer_inside');
	
	
	  }  
 public function inward_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;
				//
			
			
			
		//	$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);

$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 insert_xsl_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);
    
    $date = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
    $created_at = $date->format('Y-m-d H:i:s');

$exists = array();

date_default_timezone_set('Asia/Kolkata');
    require 'vendor/autoload.php'; // Ensure this is the correct path to your Composer autoload file

if (isset($_FILES['excel_format']['name'])) {
        $file_name = $_FILES['excel_format']['name'];
        $ext = pathinfo($file_name, PATHINFO_EXTENSION);

if ($ext == "xlsx" || $ext == "xls") {
            $file_name = $_FILES['excel_format']['tmp_name'];
            $inputFileName = $file_name;

$sheet = $spreadsheet->getSheet(0);
            $highestRow = $sheet->getHighestRow();
            $highestColumn = $sheet->getHighestColumn();

$allDataInSheet = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
            $arrayCount = count($allDataInSheet);
            $table = 'fabric_inspection_details';
            $table1 = 'fabric_inspection';

if (count($allDataInSheet) > 0) {
                for ($i = 2; $i <= $arrayCount; $i++) {
                    $po_no = trim($allDataInSheet[$i]["A"]);
                    $indent_no = trim($allDataInSheet[$i]["B"]);
                    $vendor_name = trim($allDataInSheet[$i]["C"]);
                    $ssl_pc_no = trim($allDataInSheet[$i]["D"]);
                    $piece_no = trim($allDataInSheet[$i]["E"]);
                    $product_name = trim($allDataInSheet[$i]["F"]);
                    $width = trim($allDataInSheet[$i]["G"]);
                    $design = trim($allDataInSheet[$i]["H"]);
                    $shades = trim($allDataInSheet[$i]["I"]);
                    $rec_weight = trim($allDataInSheet[$i]["J"]);
                    $balanced_mtrs = trim($allDataInSheet[$i]["K"]);
                    $rejected_mtrs = trim($allDataInSheet[$i]["L"]);
                    $variance_mtrs = trim($allDataInSheet[$i]["M"]);
                    $consumed_at = trim($allDataInSheet[$i]["N"]);
                    $received_date = trim($allDataInSheet[$i]["O"]);
                    $rec_by = trim($allDataInSheet[$i]["P"]);

$max_id = $this->outsource_model->max_select_upload_id($table);

$data = array(
                        'po_no' => $po_no,
                        'po_list_id' => $indent_no,
                        'indent_no' => $indent_no,
                        'vendor_name' => $vendor_name,
                        'piece_no' => $piece_no,
                        'product_name' => $product_name,
                        'width' => $width,
                        'design' => $design,
                        'shades' => $shades,
                        'rec_weight' => $rec_weight,
                        'rec_goods' => $balanced_mtrs,
                        'consumed_at' => $consumed_at,
                        'received_date' => $received_date,
                        'rec_by' => $rec_by,
                        'status' => 0
                    );
                    $this->db->insert($table, $data);

$id = $this->outsource_model->select_upload_id();
                    $data1 = array(
                        'goods_id' => $id->id,
                        'ssl_pc_no' => $ssl_pc_no,
                        'balanced_mtrs' => $balanced_mtrs,
                        'rejected_mtrs' => $rejected_mtrs,
                        'variance_mtrs' => $variance_mtrs
                    );
                    $this->db->insert($table1, $data1);
                }
            }

$data['userdetails'] = $this->session_data_pass();
            $data['user_type_id'] = $this->access_id();
            $data['total_indent_notifications'] = 0;
            $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('upload_files/upload_xsl_fabric', $data);
            $this->load->view('templates/footer_inside');
        } else {
            echo '<p style="color:red;">Please upload file with xls extension only</p>';
        }
    }
}

public function insert_xsl_twisting_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);
		
		 $date   = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
		$created_at   = $date->format('Y-m-d H:i:s');

$exists = array();

date_default_timezone_set('Asia/Kolkata');
		include 'PHPExcel/IOFactory.php';
		if(isset($_FILES['excel_format']['name']))
		{
			$file_name = $_FILES['excel_format']['name'];
			$ext       = pathinfo($file_name, PATHINFO_EXTENSION);
			if($ext == "xlsx" || $ext == "xls")
			{
				$file_name     = $_FILES['excel_format']['tmp_name'];
				$inputFileName = $file_name;

try 
				{
					$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
					$objReader     = PHPExcel_IOFactory::createReader($inputFileType);
					$objPHPExcel   = $objReader->load($inputFileName);
					return $spreadsheet;
				} 
				catch (Exception $e) 
				{
					die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME)
							. '": ' . $e->getMessage());
				}
				$sheet          = $objPHPExcel->getSheet(0);
				$highestRow     = $sheet->getHighestRow();
				$highestColumn  = $sheet->getHighestColumn();		
			$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);	
			$arrayCount = count($allDataInSheet);
			$table='indent_po';	
			$table1='indent_yarn_goods_details';
			$table2='workorder_yarn_details';			
			if(count($allDataInSheet)>0){		
			for($i=2;$i<=$arrayCount;$i++){		
			  $yarn_quality = trim($allDataInSheet[$i]["A"]);
		 	 $yarnDenier = trim($allDataInSheet[$i]["B"]);
			 $yarnSpecification = trim($allDataInSheet[$i]["C"]);
			 $lot = trim($allDataInSheet[$i]["D"]);
			 $bale = trim($allDataInSheet[$i]["E"]);
			 $balanced_quantity = trim($allDataInSheet[$i]["F"]);
			 $total_quantity = trim($allDataInSheet[$i]["G"]);
			$y=$yarn_quality.' '.$yarnDenier.' '.$yarnSpecification;
			
			$data1=array('product_type'=>'Yarn - Twisted','balanced_hanks'=>$total_quantity);
			$this->db->insert($table,$data1);
			
			 $data=array('yarnName'=>$y,'yarn_details'=>$y,'yarn_quality'=>$yarn_quality,'yarnDenier'=>$yarnDenier,'yarnSpecification'=>$yarnSpecification);
			 $this->db->insert($table2,$data);
			 
			 $id=$this->outsource_model->select_twisting_upload_id();
			$data3=array('po_list_id'=>$id->id,'lot'=>$lot,'bale'=>$bale,'net_weight'=>$balanced_quantity,'yarn_status'=>'Not Completed','yarnname'=>$y,'yarndenier'=>$yarnDenier,'yarnspecification'=>$yarnSpecification);
			 $this->db->insert($table1,$data3);
			
			//$id=$this->outsource_model->select_upload_id();
			//print_r($id->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);

public function insert_xsl_swan_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);
		
	 $date   = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
		$created_at   = $date->format('Y-m-d H:i:s');

$exists = array();

date_default_timezone_set('Asia/Kolkata');
		require 'vendor/autoload.php'; 
		if(isset($_FILES['excel_format']['name']))
		{
			$file_name = $_FILES['excel_format']['name'];
			$ext       = pathinfo($file_name, PATHINFO_EXTENSION);
			if($ext == "xlsx" || $ext == "xls")
			{
				$file_name     = $_FILES['excel_format']['tmp_name'];
				$inputFileName = $file_name;

try 
				{
					$inputFileType = IOFactory::identify($inputFileName);
                    $objReader = IOFactory::createReader($inputFileType);
                    $spreadsheet = $objReader->load($inputFileName);
				} 
				catch (Exception $e) 
				{
					die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME)
							. '": ' . $e->getMessage());
				}
				
                $sheet = $spreadsheet->getSheet(0);
                $highestRow = $sheet->getHighestRow();
                $highestColumn = $sheet->getHighestColumn();
                $allDataInSheet = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
                $arrayCount = count($allDataInSheet);
			
			if(count($allDataInSheet)>0){		
			for($i=2;$i<=$arrayCount;$i++)
			{		
					$work_order = trim($allDataInSheet[$i]["A"]?? '');
					
					$osl_no = trim($allDataInSheet[$i]["B"]?? '');
					$issue_no= trim($allDataInSheet[$i]["C"]?? '');
					$yarnName = trim($allDataInSheet[$i]["D"]?? '');
					$yarnSpecification = trim($allDataInSheet[$i]["E"]?? '');

$yarnDenier = trim($allDataInSheet[$i]["F"]?? '');
					$yarn_type = trim($allDataInSheet[$i]["G"]?? '');
					$yarn_quality = trim($allDataInSheet[$i]["H"]?? '');
					$shade = trim($allDataInSheet[$i]["I"]?? '');
					$color_code = trim($allDataInSheet[$i]["J"]?? '');
					$rec_dyed_qua = trim($allDataInSheet[$i]["K"]?? '');
					$location = trim($allDataInSheet[$i]["L"]?? '');
					$rec_date = trim($allDataInSheet[$i]["M"]?? '');
					$rec_by = trim($allDataInSheet[$i]["N"]?? '');
					$W = trim($allDataInSheet[$i]["A"]?? '');
			
			$table='workorder_dyeing';	
			$yarn_details=$yarnName.' ' .$yarnSpecification. ' ' .$yarnDenier;
			 $data1=array('work_order_no'=>$work_order,'osl_no'=>$osl_no,'yarn_specification'=>$yarn_details,'issue_no'=>$issue_no);
			 $in_id=$this->vendor_model->insert_access($table,$data1);
			 
			 
			 $table='work_order_dyeing';	
			$yarn_details=$yarnName.' ' .$yarnSpecification. ' ' .$yarnDenier;
		
			 $data=array('dyed_id'=>$in_id,'work_order'=>$W,'osl_no'=>$osl_no,'yarn_details'=>$yarn_details,'issue_no'=>$issue_no,'yarnName'=>$yarnName,'yarnSpecification'=>$yarnSpecification,'yarnDenier'=>$yarnDenier,'yarn_type'=>$yarn_type,'yarn_quality'=>$yarn_quality,'shade'=>$shade,'color_code'=>$color_code,'issue_dyed_qua'=>$rec_dyed_qua,'rec_dyed_qua'=>$rec_dyed_qua,'location'=>$location,'rec_date'=>$rec_date,'rec_by'=>$rec_by,'status'=>'COMPLETED','yarn_status'=>0);
			 $this->db->insert($table,$data);
			}				
		}						
		$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 upload_xsl_swan_ho()
{
	
	
	$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['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);

$exists = array();

$allDataInSheet = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
                $arrayCount = count($allDataInSheet);
			$table='indent_po';	
			$table1='indent_yarn_goods_details';
			
			if(count($allDataInSheet)>0){		
			for($i=2;$i<=$arrayCount;$i++){	
			
		$purpose = trim($allDataInSheet[$i]["A"] ?? '');
$po_no = trim($allDataInSheet[$i]["B"] ?? '');
$yarn_deatils = trim($allDataInSheet[$i]["C"] ?? '');
$yarndenier = trim($allDataInSheet[$i]["D"] ?? '');

$yarnspecification = trim($allDataInSheet[$i]["E"] ?? '');
$lot = trim($allDataInSheet[$i]["F"] ?? '');
$bale = trim($allDataInSheet[$i]["G"] ?? '');

$issue_gross_weight = trim($allDataInSheet[$i]["H"] ?? '');
$issue_net_weight = trim($allDataInSheet[$i]["I"] ?? '');
$tare_weight = trim($allDataInSheet[$i]["J"] ?? '');

$mill = trim($allDataInSheet[$i]["K"] ?? '');

$grade = trim($allDataInSheet[$i]["L"]?? '');
			$consumed_at = trim($allDataInSheet[$i]["M"]?? '');
			$rec_date = trim($allDataInSheet[$i]["N"]?? '');
			$rec_by = trim($allDataInSheet[$i]["O"]?? '');
			
			$yarnname=$yarn_deatils.' '.$yarndenier.' '.$yarnspecification;
			
			$data1=array('purpose'=>$purpose,'po_no'=>$po_no,'product_type'=> 'Yarn - Raw');
			$f=$this->vendor_model->insert_access($table,$data1);
			
		
			
			$data3=array('po_list_id'=>$f,'yarnname'=>$yarnname,'lot'=>$lot,'bale'=>$bale,
			'yarndenier'=>$yarndenier,'yarnspecification'=>$yarnspecification,
			'issue_gross_weight'=>$issue_gross_weight,'issue_net_weight'=>$issue_net_weight,
			'gross_weight'=>$issue_gross_weight,'net_weight'=>$issue_net_weight,'tare_weight'=>$tare_weight,'mill'=>$mill,'grade'=>$grade,'consumed_at'=>$consumed_at,'rec_date'=>$rec_date,'rec_by'=>$rec_by,'yarn_deatils'=>$yarn_deatils);
			 $this->db->insert($table1,$data3);
		
			
			
		}				
		}						
		$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);

$exists = array();

date_default_timezone_set('Asia/Kolkata');
		require 'vendor/autoload.php';
		if(isset($_FILES['excel_format']['name']))
		{
			$file_name = $_FILES['excel_format']['name'];
			$ext       = pathinfo($file_name, PATHINFO_EXTENSION);
			if($ext == "xlsx" || $ext == "xls")
			{
				$file_name     = $_FILES['excel_format']['tmp_name'];
				$inputFileName = $file_name;

try 
				{
					$inputFileType = IOFactory::identify($inputFileName);
                    $objReader = IOFactory::createReader($inputFileType);
                    $spreadsheet = $objReader->load($inputFileName);
				} 
				catch (Exception $e) 
				{
					die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME)
							. '": ' . $e->getMessage());
				}
				$sheet = $spreadsheet->getSheet(0);
                $highestRow = $sheet->getHighestRow();
                $highestColumn = $sheet->getHighestColumn();
                $allDataInSheet = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
                $arrayCount = count($allDataInSheet);
			$table='indent_po';	
			$table1='indent_yarn_goods_details';
			$table2='workorder_yarn_details';
			if(count($allDataInSheet)>0){		
			for($i=2;$i<=$arrayCount;$i++){	
			
			$purpose = trim($allDataInSheet[$i]["A"]?? '');
			$po_no = trim($allDataInSheet[$i]["B"]?? '');
			$yarn_deatils= trim($allDataInSheet[$i]["C"]?? '');
			$yarndenier = trim($allDataInSheet[$i]["D"]?? '');

$yarnspecification = trim($allDataInSheet[$i]["E"]?? '');
			$lot = trim($allDataInSheet[$i]["F"]?? '');
			$bale = trim($allDataInSheet[$i]["G"]?? '');

$shades = trim($allDataInSheet[$i]["H"]?? '');
			
			$issue_gross_weight = trim($allDataInSheet[$i]["I"]?? '');
			$issue_net_weight = trim($allDataInSheet[$i]["J"]?? '');
			//$tare_weight = trim($allDataInSheet[$i]["J"]);

//$grade = trim($allDataInSheet[$i]["L"]);
			$consumed_at = trim($allDataInSheet[$i]["K"]?? '');
			$rec_date = trim($allDataInSheet[$i]["L"]?? '');
			$rec_by = trim($allDataInSheet[$i]["M"]?? '');
			
			$yarnname=$yarn_deatils.' '.$yarndenier.' '.$yarnspecification;
			
			$data1=array('shades'=>$shades,'purpose'=>$purpose,'po_no'=>$po_no,'product_type'=> 'Yarn - Twisted');
			$f=$this->vendor_model->insert_access($table,$data1);
			
			$data3=array('po_list_id'=>$f,'yarnname'=>$yarnname,'lot'=>$lot,'bale'=>$bale,'yarndenier'=>$yarndenier,'yarnspecification'=>$yarnspecification,'issue_gross_weight'=>$issue_gross_weight,'issue_net_weight'=>$issue_net_weight,'consumed_at'=>$consumed_at,'rec_date'=>$rec_date,'rec_by'=>$rec_by,'yarn_details'=>$yarn_deatils);
			 $this->db->insert($table1,$data3);
			
			 $data4=array('yarnName'=>$yarnname,'yarn_details'=>$yarnname,'yarn_quality'=>$yarn_deatils,'yarnDenier'=>$yarndenier,'yarnSpecification'=>$yarnspecification);
			 $this->db->insert($table2,$data4);
			 
		}				
		}						
		$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);

$exists = array();

date_default_timezone_set('Asia/Kolkata');
		require 'vendor/autoload.php';
		if(isset($_FILES['excel_format']['name']))
		{
			$file_name = $_FILES['excel_format']['name'];
			$ext       = pathinfo($file_name, PATHINFO_EXTENSION);
			if($ext == "xlsx" || $ext == "xls")
			{
				$file_name     = $_FILES['excel_format']['tmp_name'];
				$inputFileName = $file_name;

try 
				{
					$inputFileType = IOFactory::identify($inputFileName);
                    $objReader = IOFactory::createReader($inputFileType);
                    $spreadsheet = $objReader->load($inputFileName);
				} 
				catch (Exception $e) 
				{
					die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME)
							. '": ' . $e->getMessage());
				}
				$sheet = $spreadsheet->getSheet(0);
                $highestRow = $sheet->getHighestRow();
                $highestColumn = $sheet->getHighestColumn();
                $allDataInSheet = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
                $arrayCount = count($allDataInSheet);
			$table='indent_po';	
			$table1='indent_yarn_goods_details';
			$table2='indent_add_indent';	
			if(count($allDataInSheet)>0){		
			for($i=2;$i<=$arrayCount;$i++){	
			
			$purpose = trim($allDataInSheet[$i]["A"]?? '');
			$po_no = trim($allDataInSheet[$i]["B"]?? '');
			$yarn_deatils= trim($allDataInSheet[$i]["C"]?? '');
			$yarndenier = trim($allDataInSheet[$i]["D"]?? '');

$yarnspecification = trim($allDataInSheet[$i]["E"]?? '');
			$lot = trim($allDataInSheet[$i]["F"]?? '');
			$bale = trim($allDataInSheet[$i]["G"]?? '');

$shades= trim($allDataInSheet[$i]["H"]?? '');
			$color_code = trim($allDataInSheet[$i]["I"]?? '');
			
			$issue_gross_weight = trim($allDataInSheet[$i]["J"]?? '');
			$issue_net_weight = trim($allDataInSheet[$i]["K"]?? '');

// $mill = trim($allDataInSheet[$i]["K"]);
			// $grade = trim($allDataInSheet[$i]["L"]);
			$consumed_at = trim($allDataInSheet[$i]["L"]?? '');
			$rec_date = trim($allDataInSheet[$i]["M"]?? '');
			$rec_by = trim($allDataInSheet[$i]["N"]?? '');
			
			$yarnname=$yarn_deatils.' '.$yarndenier.' '.$yarnspecification;
			
			
			$data2=array('color_code'=>$color_code);
			$ff=$this->vendor_model->insert_access($table2,$data2);
			
			$data1=array('indent_id'=>$ff,'shades'=>$shades,'purpose'=>$purpose,'po_no'=>$po_no,'product_type'=> 'Yarn - Dyed');
			$f=$this->vendor_model->insert_access($table,$data1);
			
		
			
			$data3=array('po_list_id'=>$f,'yarnname'=>$yarnname,'lot'=>$lot,'bale'=>$bale,'yarndenier'=>$yarndenier,'yarnspecification'=>$yarnspecification,'issue_gross_weight'=>$issue_gross_weight,'issue_net_weight'=>$issue_net_weight,'gross_weight'=>$issue_gross_weight,'net_weight'=>$issue_net_weight,'consumed_at'=>$consumed_at,'rec_date'=>$rec_date,'rec_by'=>$rec_by,'yarn_details'=>$yarn_deatils);
			 $this->db->insert($table1,$data3);
			
			
			
		}				
		}						
		$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);

$exists = array();

$allDataInSheet = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
                $arrayCount = count($allDataInSheet);
			$table='fabric_madeups_delivery_confirmation';	
			
			if(count($allDataInSheet)>0){		
			for($i=2;$i<=$arrayCount;$i++){	
			
			$osl = trim($allDataInSheet[$i]["A"]?? '');
			$order_type = trim($allDataInSheet[$i]["B"]?? '');
			$size= trim($allDataInSheet[$i]["C"]?? '');
			$article = trim($allDataInSheet[$i]["D"]?? '');

$description = trim($allDataInSheet[$i]["E"]?? '');
			$design = trim($allDataInSheet[$i]["F"]?? '');
			$shade = trim($allDataInSheet[$i]["G"]?? '');

$ssl_shade= trim($allDataInSheet[$i]["H"]?? '');
			$batch_no = trim($allDataInSheet[$i]["I"]?? '');
			
			$received_qty = trim($allDataInSheet[$i]["J"]?? '');
			$rec_date = trim($allDataInSheet[$i]["K"]?? '');
			$location = trim($allDataInSheet[$i]["L"]?? '');
			$rec_by = trim($allDataInSheet[$i]["M"]?? '');
			
			$data3=array('osl'=>$osl,'order_type'=>$order_type,'size'=>$size,'article'=>$article,'description'=>$description,'design'=>$design,'shade'=>$shade,'ssl_shade'=>$ssl_shade,'batch_no'=>$batch_no,'received_qty'=>$received_qty,'rec_date'=>$rec_date,'rec_by'=>$rec_by,'location'=>$location);
			 $this->db->insert($table,$data3);
			
			
			
		}				
		}						
		$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);

$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 upload_xsl_madeups()
{
	
	
	$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['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);

$this->load->view('templates/header_inside',$data);
	$this->load->view('upload_files/upload_xsl_madeups',$data);
	$this->load->view('templates/footer_inside');	
}
		 public function upload_xsl_dyeing()
{
	
	
	$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['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);

$this->load->view('templates/header_inside',$data);
	$this->load->view('upload_files/upload_xsl_dyeing',$data);
	$this->load->view('templates/footer_inside');	
}
}