EVOLUTION-NINJA

Edit File: Reports.php

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

class Reports 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('store_model');
$this->load->model('request_model');
$this->load->model('stock_model');
$this->load->model('outsource_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 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 session_data_pass() {
	if ($this->session->userdata('logged_in')) {
		return $this->yarn_model->get_userdata();
	}
}
public function details_fetch_sys_date()
{
	$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details = $this->store_model->display_fabric_inspection_order_embroidryinspection_date();

echo json_encode($details);
}
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 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 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 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 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 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 inspected_fabric() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function inspected_data() 
{
$table='inspected_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$location=$this->input->post('location');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='inspected_reports';
$data=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$location);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_inspected_details_new() 
{
// $table='inspected_reports';
// $where=array('status'=>0);
// $r=$this->vendor_model->get_customerdata($table,$where);
// //print_r($r);
// //die();
// $from_date  =$r->from_date;
// $to_date =$r->to_date;
// $consumed_at =$r->location;

$table='fabric_inspection_details';
$details_r = $this->store_model->date_wise_inspected_reports_1();
$detailss = $this->store_model->date_wise_inspected_reportss_2();
$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}

public function date_wise_inspected_details() 
{
$table='inspected_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$consumed_at =$r->location;

$table='fabric_inspection_details';
$details_r = $this->store_model->date_wise_inspected_reports($from_date  ,$to_date, $consumed_at);
$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date, $consumed_at);
$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function date_wise_inspected_details_XSL() 
{
$table='inspected_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;

$data['from_dates']  =$r->from_date;
$data['to_dates'] =$r->to_date;

//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$data['details'] = $this->store_model->date_wise_inspected_reports($from_date  ,$to_date );
$data['details_total'] = $this->store_model->date_wise_inspected_reports_XSL($from_date  ,$to_date );

//print_r($data['details_total']);
//die();

echo json_encode($data);
}
public function faric_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);
			
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$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('reports/fabric_stock',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function yarn_remnants_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $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('reports/yarn_remnants',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function yarn_stock_reports() 
{
    
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $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('reports/yarn_stock',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function consumables_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $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('reports/cs_stock',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function spares_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $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('reports/spares_stock',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function madeups_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function fabric_stock_data() 
{
$table='fabric_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='fabric_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function location_wise_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='fabric_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
if($loc == 'all' && $from_date == '' && $to_date == '')
{

$table='fabric_inspection_details';
	$details= $this->store_model->display_fabric_reports_loc_grid_embroidryinspections_data($loc);
//$detailss = $this->store_model->display_fabric_reports_loc_grid_embroidryinspectionns_data($loc);

//$details=array_merge($details_r,$detailss);
}
else if($loc == 'all' && $from_date != '' && $to_date != '')
{

$table='fabric_inspection_details';
	$details_r = $this->store_model->display_fabric_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc);
$detailss = $this->store_model->display_fabric_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc);

$details=array_merge($details_r,$detailss);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table='fabric_inspection_details';
	$details= $this->store_model->display_fabric_reports_loc_grid_embroidryinspections($loc);
//$detailss = $this->store_model->display_fabric_reports_loc_grid_embroidryinspectionns($loc);

//$details=array_merge($details_r,$detailss);

}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

$table='fabric_inspection_details';
	$details_r = $this->store_model->display_fabric_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc);
$detailss = $this->store_model->display_fabric_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc);

$details=array_merge($details_r,$detailss);

}

echo json_encode($details);

}

public function madeups_stock_data() 
{
$table='madeups_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='madeups_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function location_wise_madeups_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='madeups_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
if($loc == 'all' && $from_date == '' && $to_date == '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$getalldata = $this->store_model->display_madeups_reports_loc_grid_embroidryinspections_data($loc);

echo json_encode($getalldata);
}
else if($loc == 'all' && $from_date != '' && $to_date != '')
{

echo json_encode($getalldata);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$getalldata = $this->store_model->display_madeups_reports_loc_grid_embroidryinspections($loc);

echo json_encode($getalldata);
}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

echo json_encode($getalldata);

}

public function consumable_stock_data() 
{
$table='consumable_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='consumable_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function location_wise_consumable_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='consumable_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Consumables';
if($loc == 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$details_r = $this->store_model->display_consumable_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_consumable_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
else if($loc == 'all' && $from_date == '' && $to_date == '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail = $this->store_model->display_consumable_reports_loc_grid_embroidryinspectionns_data($loc,$type);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail= $this->store_model->display_consumable_reports_loc_grid_embroidryinspections($loc,$type);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$details_r = $this->store_model->display_consumable_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_consumable_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}

}
public function spares_stock_data() 
{
$table='spares_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='spares_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function location_wise_spares_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='spares_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Spares';
if($loc == 'all' && $from_date != '' && $to_date != '')
{

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
else if($loc == 'all' && $from_date == '' && $to_date == '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail= $this->store_model->display_consumable_reports_loc_grid_embroidryinspectionns_data($loc,$type);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$details_r = $this->store_model->display_consumable_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_consumable_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}

}

public function raw_stock_data() 
{
$table='raw_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='raw_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function location_wise_raw_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='raw_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Yarn - Raw';
if($loc == 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$detail= $this->store_model->display_raw_reports_loc_grid_embroidryinspections_data($from_date,$to_date,$loc,$type);

echo json_encode($detail);
}
else if($loc == 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$details_r = $this->store_model->display_raw_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_raw_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$detail= $this->store_model->display_raw_reports_loc_grid_embroidryinspections($loc,$type);

echo json_encode($detail);

}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$details_r = $this->store_model->display_raw_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_raw_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}

}

public function yarn_dyed_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='dyed_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function location_wise_dyed_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='dyed_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Yarn - Dyed';
if($loc == 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$detail= $this->store_model->display_raw_reports_loc_grid_embroidryinspections_data($loc,$type);

echo json_encode($detail);
}
else if($loc == 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$detail= $this->store_model->display_raw_reports_loc_grid_embroidryinspections($loc,$type);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
}

public function yarn_twist_stock_reports() 
{
     $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);
	}
    
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$this->load->view('templates/header_inside',$data);
				$this->load->view('reports/twist_yarn_stock',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function twist_stock_data() 
{
$table='twist_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='twist_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function location_wise_twist_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='twist_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Yarn - Twisted';
if($loc == 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail= $this->store_model->display_twist_reports_loc_grid_embroidryinspections_data($loc,$type);

echo json_encode($detail);
}
else if($loc == 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$details_r = $this->store_model->display_twist_reports_loc_grid_embroidryinspection_data($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_twist_reports_loc_grid_embroidryinspectionn_data($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail= $this->store_model->display_twist_reports_loc_grid_embroidryinspections($loc,$type);

echo json_encode($detail);
}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$details_r = $this->store_model->display_twist_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc,$type);
$detailss = $this->store_model->display_twist_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc,$type);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
}

public function yarn_swan_stock_reports() 
{
	$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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='swan_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function location_wise_swan_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='swan_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Yarn - Twisted';
if($loc == 'all' && $from_date == '' && $to_date == '')
{

$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail = $this->store_model->display_swan_reports_loc_grid_embroidryinspections_data($loc,$type);
//    $detail = $this->store_model->display_swan_reports_loc_grid_embroidryinspections($loc,$type);

echo json_encode($detail);
}
else if($loc == 'all' && $from_date != '' && $to_date != '')
{

echo json_encode($detail);
}
else if($loc != 'all' && $from_date == '' && $to_date == '')
{
$table = 'fabric_madeups_delivery_confirmation';
		$where=array('received_qty >' => 0,'location'=>$loc);
	$detail = $this->store_model->display_swan_reports_loc_grid_embroidryinspections($loc,$type);

echo json_encode($detail);

}
else if($loc != 'all' && $from_date != '' && $to_date != '')
{

echo json_encode($detail);

}

public function pdf_print(){
		
		$table='inspected_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;

$details_r = $this->store_model->date_wise_inspected_reports($from_date  ,$to_date );
$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
$details=array_merge($details_r,$detailss);

include("https://swansilk.co/assets/mpdf60/mpdf.php");
print_r($r);
die();	
		$mpdf=new mPDF('A4'); 
		$mpdf->mirrorMargins = 1;
		$final_amt=0;
		$html = '';
		$index = 1;
		$date=date('d-m-Y');
		$html=$html.'<html>';
	$html=$html.'<head>';
		$html=$html.'<title></title>';
	$html=$html.'</head>';

$html=$html.'<body style="width: 800px;">';
	
	
	
		$html=$html.'<table style="border-bottom: 1px solid #000;width:100%;">';
		$html=$html.'<thead><tr><th>SL No.</th><th>Vendor Name / Factory</th> <th>PO# / OSL No.</th> <th>SSL Piece No</th> <th>Supplier Piece No</th> <th>Article(PRODUCT)</th> <th>Width</th> <th>Design</th> <th>Shade</th><th>Received Mtr</th><th>Received Weight</th><th>Inspected Mtrs</th><th>Rejected Mtrs</th><th>Variance Mtrs</th><th>Received Date</th></tr></thead>';
		$count =1;
 if(!empty($details)){
		foreach($details as $key=>$vas) { 
		
		 
		$html=$html.'<tr><td>' . $count . '</td> <td>' . $vas->vendor_name . '</td> <td>' . $vas->po_no . '</td> <td>' . $vas->ssl_pc_no . '</td> <td>' . $vas->piece_no;
		$html=$html.'</td><td>' . $vas->product_name . '</td> <td>' . $vas->width . '</td><td>' . $vas->design . '</td><td>' . $vas->shades . '</td><td>' . $vas->rec_goods;
		$html=$html.'</td> <td>' . $vas->rec_weight . '</td><td>' . $vas->inspected_mtrs . '</td><td>' . $vas->rejected_mtrs . '</td><td>' . $vas->variance_mtrs;
		$html=$html.'</td><td>' . $vas->sys_date . '</td></tr>';
		}
}
		$html=$html.'</body></html>';

$mpdf->SetDisplayMode('fullpage');

//$mpdf->SetWatermarkText('Quotation');
		$mpdf->watermark_font = 'DejaVuSansCondensed';
		$mpdf->showWatermarkText = true;
$name='inspected';
		$mpdf->WriteHTML($html);
		$data = date('d-M-y H:i');

//$pdf=$mpdf->Output("/pdffiles/".$name, 'F');
		//exit;
		
			
	}

//////////////////////////////////////  reports//////////////////////////////////////////////
public function po_report() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

////////////////////////////////  10-6-2018 //////////////////////////////////////////////

public function po_reports_details() 
{
$table='po_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');

$table='po_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');

$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function date_wise_po_details() 
{
$table='po_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;

//$details= $this->store_model->display_po_reports_loc_grid_embroidryinspection_data($from_date,$to_date );
$details= $this->store_model->display_po_new_reports_loc_grid_embroidryinspection_data($from_date,$to_date );
	echo json_encode($details);
}
public function date_wise_po_xsl_details() 
{
$table='po_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;

$data['details']= $this->store_model->display_po_reports_loc_grid_embroidryinspection_data($from_date,$to_date );
$data['total_res']= $this->store_model->display_po_reports_loc_grid_embroidryinspection_data_group($from_date,$to_date );

echo json_encode($data);
}

/////////////////???????????????????????????????????????????/////////////////////////////////////////

public function madeups_workorder_report() 
{
            $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'];
            
            $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
            
            $data['userdetails'] = $this->session_data_pass();
            $data['user_type_id'] = $this->access_id();
            $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('reports/madeups_workorder_report' == $data['val'])
                           {
                                   $check=$data['val'];
                           }
                           
           }
           if($check != "")
           {
                $id=$this->session->userdata('logged_in');
                $where=array('id'=>$id);
                $data['approved_by']=$id['username'];
                
                $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
                $table='consumed_at';
                $where=array('status'=>1);
                $data['loc']=$this->marketing_model->fetch_where_data($table,$where);
                $data['userdetails'] = $this->session_data_pass();
                $data['user_type_id'] = $this->access_id();
                $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('reports/madeups_workorder_report',$data);
                $this->load->view('templates/footer_inside');
           }
           else
            {  
                $this->session->sess_destroy();
                redirect(base_url());
           }
}
public function madeups_workorder_details() 
{
        $table='inspected_reports';
        $this->db->from($table); 
        $this->db->truncate(); 
        
        $this->db->truncate($table);
        
        $from_date=$this->input->post('from_delivery_date_required_on');
        $to_date=$this->input->post('to_delivery_date_required_on');
        $location=$this->input->post('location');
        $data['from_dates']=$this->input->post('from_delivery_date_required_on');
        $data['to_dates']=$this->input->post('to_delivery_date_required_on');
        $data['location']=$this->input->post('location');
        $table='inspected_reports';
        $data=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$location);
        $this->db->insert($table,$data);
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
        
        $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
        $data['from_dates']=$this->input->post('from_delivery_date_required_on');
        $data['to_dates']=$this->input->post('to_delivery_date_required_on');
        $data['userdetails'] = $this->session_data_pass();
        $data['user_type_id'] = $this->access_id();
        $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);
        $table1='consumed_at';
        $where1=array('status'=>1);
        $data['loc']=$this->marketing_model->fetch_where_data($table1,$where1);
        
		$data['access'] = $this->access_details();
		$this->load->view('templates/header_inside',$data);
		$this->load->view('reports/madeups_workorder_report_date',$data);
		$this->load->view('templates/footer_inside');

}

public function fabric_finishing_emb() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function datewise_madeups_workorder_data()
{
    $table='inspected_reports';
    $where=array('status'=>0);
    $r=$this->vendor_model->get_customerdata($table,$where);
    //print_r($r);
    //die();
    $from_date  =$r->from_date;
    $to_date =$r->to_date;
    $consumed_at =$r->location;

$detail=$this->store_model->date_madeups_workorder_data($from_date,$to_date,$consumed_at);
    echo json_encode($detail);
}

public function madeups_workorder_data()
{

$detail=$this->store_model->madeups_workorder_data();
    echo json_encode($detail);
}

public function fabric_finshing_deatils() 
{
$table='emb_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$loc=$this->input->post('location');

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$data['location']=$this->input->post('location');
$table='emb_reports';
$dataf=array('from_date'=>$from_date,'to_date'=>$to_date,'location'=>$loc);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$table='consumed_at';
$where=array('status'=>1);
$data['loc']=$this->marketing_model->fetch_where_data($table,$where);

$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['location']=$this->input->post('location');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function location_wise_emb_data()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$table='emb_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  =$r->from_date;
$to_date =$r->to_date;
$loc =$r->location;
$type='Yarn - Twisted';
if($loc == 'all')
{

$details_r = $this->store_model->display_emb_reports_loc_grid_embroidryinspections($from_date,$to_date,$loc);
$detailss = $this->store_model->display_emb_reports_loc_grid_embroidryinspectionns($from_date,$to_date,$loc);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}
else
{

$details_r = $this->store_model->display_emb_reports_loc_grid_embroidryinspection($from_date,$to_date,$loc);
$detailss = $this->store_model->display_emb_reports_loc_grid_embroidryinspectionn($from_date,$to_date,$loc);

$detail=array_merge($details_r,$detailss);

echo json_encode($detail);
}

}

/////////////////////////////////////////////////////    ////////////////////////////////////////////////////////////////////

public function rec_fabric_report() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function rec_fab_data() 
{
$table='rec_fab_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_fab_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_rec_fab_details() 
{
$table='rec_fab_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;

$details= $this->store_model->date_wise_fab_reports($from_date ,$to_date );
//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function rec_fabric_data() 
{
 $table='fabric_transfer';
		$where=array('status'=>1);
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}

public function rec_raw_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function rec_raw_data() 
{
$table='rec_raw_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_raw_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_rec_raw_details() 
{
$table='rec_raw_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='raw';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_raw_reports($from_date ,$to_date,$type );
//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function rec_raw_yarn_data() 
{

$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'raw');
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}

//////////////////////////////////////////////////////////////////////////////////////////////////////
public function rec_twist_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function rec_twist_data() 
{
$table='rec_twist_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_twist_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

}

public function date_wise_rec_twist_details() 
{
$table='rec_twist_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='twisting';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'twisting');
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}

//////////////////////////////////////////////////////////////////////////////////////////////////////
public function rec_dyed_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

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

public function rec_dyed_data() 
{
$table='rec_dyed_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_dyed_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_rec_dyed_details() 
{
$table='rec_dyed_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='dyed';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$table='yarn_transfer';
		$where=array('status'=>1,'yarn_type'=>'dyed');
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}

//////////////////////////////////////////////////////////////////////////////////////////////////////
public function rec_swan_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function rec_swan_data() 
{
$table='rec_swan_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_swan_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_rec_swan_details() 
{
$table='rec_swan_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='dyed';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_swan_reports($from_date ,$to_date);
//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function rec_swan_yarn_data() 
{

$table='swan_yarn_transfer';
		$where=array('status'=>1);
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}
//////////////////////////////////////////////////////////////////////////////////////////////////////
public function rec_consumable_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function rec_consumable_data() 
{
$table='rec_consum_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_consum_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_rec_consumable_details() 
{
$table='rec_consum_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Consumables';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_consumable_reports($from_date ,$to_date,$type);
//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function rec_consumable_yarn_data() 
{

$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Consumables');
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}
//////////////////////////////////////////////////////////////////////////////////////////////////////
public function rec_spares_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function rec_spares_data() 
{
$table='rec_spares_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_spares_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_rec_spares_details() 
{
$table='rec_spares_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$table='cs_transfer';
		$where=array('status'=>1,'product_type'=>'Spares');
		$details=$this->store_model->get_data_fetch($table,$where);
echo json_encode($details);
}

//////////////////////////////////////////////////////////////////////////////////////////////////////
public function madeups_report() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

}
public function madeups_data() 
{
$table='rec_madeups';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_madeups';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_madeups_details() 
{
$table='rec_madeups';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_madeups_reports($from_date ,$to_date);

//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function date_wise_madeups_detailss() 
{
$table='rec_madeups';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$data['details']= $this->store_model->date_wise_madeups_reports($from_date ,$to_date);
$data['details_res']= $this->store_model->date_wise_madeups_reportss($from_date ,$to_date);

//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($data);
}
//////////////////////////////////////////////////////////////////////////////////////////////////////
public function rec_deying_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='rec_dyeing';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

}
public function date_wise_dyeing_details() 
{
$table='rec_dyeing';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_dyeing_reports($from_date,$to_date);
//$data['details_res']= $this->store_model->date_wise_madeups_reportss($from_date ,$to_date);

//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}

public function twisting_issues() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $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('reports/twisting_issue_report',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function twisting_receipt() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

//$table='yarn_transfer';
		//$where=array('status'=>1,'yarn_type'=>'dyed');
		$details=$this->store_model->get_ywisting_issue_data();

echo json_encode($details);
}
public function twisting_issue_data() 
{
$table='twisting_issue_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='twisting_issue_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function twisting_datas() 
{
$table='twisting_issue_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_twisting_issue_reports($from_date,$to_date);
//$data['details_res']= $this->store_model->date_wise_madeups_reportss($from_date ,$to_date);

//$table='yarn_transfer';
		//$where=array('status'=>1,'yarn_type'=>'dyed');
		$details=$this->store_model->get_ywisting_receipt_data();

echo json_encode($details);
}
public function twisting_receipt_data() 
{
$table='twisting_receipt_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='twisting_receipt_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

}
public function twisting_receipt_grid_datas() 
{
$table='twisting_receipt_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_twisting_receipt_reports($from_date,$to_date);
//$data['details_res']= $this->store_model->date_wise_madeups_reportss($from_date ,$to_date);

//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}
public function issued_to_loom_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$table='weaving_panel_planning_order';
		//$where=array('status'=>1,'yarn_type'=>'dyed');
		$details=$this->store_model->get_issue_loom_details();

echo json_encode($details);
}
public function issue_loom_data() 
{
$table='issue_loom_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='issue_loom_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function date_wise_issue_to_loom_details() 
{
$table='issue_loom_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';
//if($from_date != "")
	//	{
		//	$date       = new DateTime($from_date);
        	//$from_date  = $date->format('d-m-Y');
		//}
//if($to_date != "")
		//{
		//	$date       = new DateTime($to_date );
        	//$to_date = $date->format('d-m-Y');
		//}
$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_issue_to_loom_reports($from_date,$to_date);
//$data['details_res']= $this->store_model->date_wise_madeups_reportss($from_date ,$to_date);

//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($details);
}

public function billing_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$table='packing_list_data';
$where=array('total_value'=>0,'report_total_value' =>0);
$p_ress= $this->store_model->get_data_fetch($table,$where);

$table='packing_list_data';
$where=array('total_value !='=>0,'report_total_value' =>0);
$p_ress_not_empty= $this->store_model->get_data_fetch($table,$where);
foreach($p_ress_not_empty as $pss)
{
	$where = array('invoice'=>$pss->invoice,'status'=>'0');
	$table='invoice_packing';

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);

$table='packing_list_data';
	$where = array('invoice'=>$pss->invoice,'status'=>'0');
	$datat=array('report_total_value'=>$pss->total_value);
	$this->store_model->update_data($where,$table,$datat);
}

foreach($p_ress as $ps)
{
	
	$where = array('invoice'=>$ps->invoice,'status'=>'0');
	$table='invoice_packing';

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);
	
	$table='packing_list_data';
	$where = array('invoice'=>$ps->invoice,'status'=>'0');
	$datat=array('report_total_value'=>$fetch_sum_amt_invoice->values_es);
	$this->store_model->update_data($where,$table,$datat);
	
	
}

$table='madeups_list_data';
$where=array('total_value'=>0,'report_total_value' =>0);
$p_ress= $this->store_model->get_data_fetch($table,$where);

$table='madeups_list_data';
$where=array('total_value !='=>0,'report_total_value' =>0);
$p_ress_not_empty= $this->store_model->get_data_fetch($table,$where);
foreach($p_ress_not_empty as $pss)
{
	$where = array('invoice_num'=>$pss->invoice_num,'status'=>'0');
	$table='madeups_invoice_packing';

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);

$table='madeups_list_data';
	$where = array('invoice_num'=>$pss->invoice_num,'status'=>'0');
	$datat=array('report_total_value'=>$pss->total_value);
	$this->store_model->update_data($where,$table,$datat);
	
	
}

foreach($p_ress as $ps)
{
	$where = array('invoice_num'=>$ps->invoice_num,'status'=>'0');
	$table='madeups_invoice_packing';

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);
	
	$table='madeups_list_data';
	$where = array('invoice_num'=>$ps->invoice_num,'status'=>'0');
	$datat=array('report_total_value'=>$fetch_sum_amt_invoice->values_es);
	$this->store_model->update_data($where,$table,$datat);
}

$table='packing_list_data';
$where=array('status'=>0,'tot_qty'=>0);

$p_res= $this->store_model->get_data_fetch($table,$where);

foreach($p_res as $p)
{
$table='invoice_packing';
$where = array('invoice'=>$p->invoice,'status'=>'0');
$total_invoice_qty_data = $this->outsource_model->fetch_where_subgrid_qty_total_data($table,$where);
$currency_data = $this->store_model->fetch_where_subgrid_data($table,$where);
if(empty($total_invoice_qty_data))
{
		
}
else
{
	$table='packing_list_data';
$where = array('invoice'=>$p->invoice,'status'=>'0');
$datat=array('tot_qty'=>$total_invoice_qty_data->stock_wt);
$this->store_model->update_data($where,$table,$datat);
}
if(empty($currency_data))
{
		
}
else
{
	$table='packing_list_data';
$where = array('invoice'=>$p->invoice,'status'=>'0');
$datat=array('currency'=>$currency_data->currency);
$this->store_model->update_data($where,$table,$datat);
}

}

$table='madeups_list_data';
$where=array('status'=>0,'tot_qty'=>0);
$m_res= $this->store_model->get_data_fetch($table,$where);

foreach($m_res as $m)
{
$table='madeups_invoice_packing';
$where = array('invoice_num'=>$m->invoice_num,'status'=>'0');
$total_invoice_qty_data1 = $this->outsource_model->fetch_where_subgrid_qty_total_datas_po($table,$where);
$currency_data1 = $this->store_model->fetch_where_subgrid_data($table,$where);

if(empty($total_invoice_qty_data1))
{
		
}
else
{
	$table='madeups_list_data';
$where = array('invoice_num'=>$m->invoice_num,'status'=>'0');
$datatt=array('tot_qty'=>$total_invoice_qty_data1->stock_wt);
$this->store_model->update_data($where,$table,$datatt);
}
if(empty($currency_data1))
{
		
}
else
{
	$table='madeups_list_data';
$where = array('invoice_num'=>$m->invoice_num,'status'=>'0');
$datatt=array('currency'=>$currency_data1->currency);
$this->store_model->update_data($where,$table,$datatt);
}

}

$details1= $this->store_model->get_packing_list_data();
$details2= $this->store_model->get_madeups_list_data();

$details=array_merge($details1,$details2);
	echo json_encode($details);

}
public function billing_insert_data()
{
$table='billing_report';
$this->db->from($table); 
$this->db->truncate(); 
$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='billing_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);

$details=1;
echo json_encode($details);

}

public function country_wise_preview() 
{
	$table='billing_report_data';
$this->db->from($table); 
$this->db->truncate(); 
$this->db->truncate($table);
	
	$where=array('status'=>0);
	$table='billing_report';
	$r=$this->store_model->fetch_where_subgrid_data($table,$where);
		
		$from_date  =$r->from_date;
	$to_date =$r->to_date;

$data['paking_details']= $this->store_model->date_wise_packing_list_data($from_date,$to_date);
	$data['madeups_details']= $this->store_model->date_wise_madeups_list_data($from_date,$to_date);

$data['paking_details1']= $this->store_model->date_wise_packing_list_data1($from_date,$to_date);
	$data['madeups_details1']= $this->store_model->date_wise_madeups_list_data1($from_date,$to_date);

$data_paking_details= $this->store_model->date_wise_packing_list_data($from_date,$to_date);
	$data_madeups_details= $this->store_model->date_wise_madeups_list_data($from_date,$to_date);

$data_paking_details1= $this->store_model->date_wise_packing_list_data1($from_date,$to_date);
	$data_madeups_details1= $this->store_model->date_wise_madeups_list_data1($from_date,$to_date);

foreach($data_paking_details as $d)
	{
		$rs=array('country'=>$d->country,
		'currency'=>$d->currency,
		'total_value'=>$d->total_value,
		'customer_name'=>$d->customer_name,
		'tot_qty'=>$d->tot_qty,
	'invoice_no'=>$d->invoice_num,
	'sys_date'=>$d->sys_date,
		);
			$table='billing_report_data';
			$this->db->insert($table,$rs);
	}
	foreach($data_madeups_details as $d)
	{
		$rs=array('country'=>$d->country,
		'currency'=>$d->currency,
		'total_value'=>$d->total_value,
		'customer_name'=>$d->customer_name,
		'tot_qty'=>$d->tot_qty,
		'invoice_no'=>$d->invoice,
	'sys_date'=>$d->sys_date,
		);
			$table='billing_report_data';
			$this->db->insert($table,$rs);
	}
	$table='billing_report_data';
	$data['p']=$this->store_model->fetch_group_data($table);
	$data['pp']=$this->store_model->fetch_group_data1($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);

$data['paking_details']= $this->store_model->date_wise_packing_list_data($from_date,$to_date);
	$data['madeups_details']= $this->store_model->date_wise_madeups_list_data($from_date,$to_date);

$data['paking_details1']= $this->store_model->date_wise_packing_list_data1($from_date,$to_date);
	$data['madeups_details1']= $this->store_model->date_wise_madeups_list_data1($from_date,$to_date);

$data_paking_details= $this->store_model->date_wise_packing_list_data($from_date,$to_date);
	$data_madeups_details= $this->store_model->date_wise_madeups_list_data($from_date,$to_date);

$data_paking_details1= $this->store_model->date_wise_packing_list_data1($from_date,$to_date);
	$data_madeups_details1= $this->store_model->date_wise_madeups_list_data1($from_date,$to_date);

foreach($data_paking_details as $d)
	{
		$rs=array('country'=>$d->country,
		'currency'=>$d->currency,
		'total_value'=>$d->total_value,
		'customer_name'=>$d->customer_name,
		'tot_qty'=>$d->tot_qty,
	'invoice_no'=>$d->invoice_num,
	'sys_date'=>$d->sys_date,
		);
			$table='billing_report_data';
			$this->db->insert($table,$rs);
	}
	foreach($data_madeups_details as $d)
	{
		$rs=array('country'=>$d->country,
		'currency'=>$d->currency,
		'total_value'=>$d->total_value,
		'customer_name'=>$d->customer_name,
		'tot_qty'=>$d->tot_qty,
		'invoice_no'=>$d->invoice,
	'sys_date'=>$d->sys_date,
		);
			$table='billing_report_data';
			$this->db->insert($table,$rs);
	}
	$table='billing_report_data';
	$data['p']=$this->store_model->fetch_group_data2($table);
	$data['pp']=$this->store_model->fetch_group_data3($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);

$data['paking_details']= $this->store_model->date_wise_packing_list_data($from_date,$to_date);
	$data['madeups_details']= $this->store_model->date_wise_madeups_list_data($from_date,$to_date);

$data['paking_details1']= $this->store_model->date_wise_packing_list_data1($from_date,$to_date);
	$data['madeups_details1']= $this->store_model->date_wise_madeups_list_data1($from_date,$to_date);

$data_paking_details= $this->store_model->date_wise_packing_list_data($from_date,$to_date);
	$data_madeups_details= $this->store_model->date_wise_madeups_list_data($from_date,$to_date);

$data_paking_details1= $this->store_model->date_wise_packing_list_data1($from_date,$to_date);
	$data_madeups_details1= $this->store_model->date_wise_madeups_list_data1($from_date,$to_date);

foreach($data_paking_details as $d)
	{
		$rs=array('country'=>$d->country,
		'currency'=>$d->currency,
		'total_value'=>$d->total_value,
		'customer_name'=>$d->customer_name,
		'tot_qty'=>$d->tot_qty,
	'invoice_no'=>$d->invoice_num,
	'sys_date'=>$d->sys_date,
		);
			$table='billing_report_data';
			$this->db->insert($table,$rs);
	}
	foreach($data_madeups_details as $d)
	{
		$rs=array('country'=>$d->country,
		'currency'=>$d->currency,
		'total_value'=>$d->total_value,
		'customer_name'=>$d->customer_name,
		'tot_qty'=>$d->tot_qty,
		'invoice_no'=>$d->invoice,
		'sys_date'=>$d->sys_date,
	
		);
			$table='billing_report_data';
			$this->db->insert($table,$rs);
	}
	$table='billing_report_data';
	$data['p']=$this->store_model->fetch_group_data($table);
	$data['pp']=$this->store_model->fetch_group_data1($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);

$data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

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

echo json_encode($getalldata);

}
public function date_wise_marketing_details()
{
$table='marketing_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;

$table='fabric_inspection_details';
	//	$details = $this->store_model->display_fabric_embroidryinspection_date();

$details= $this->store_model->date_wise_OSL_NUMBER_getorder_reports($from_date,$to_date );

echo json_encode($details);

}

public function marketing_details() 
{
$table='marketing_reports';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function ordre_qty_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='marketing_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='marketing_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function total_order_val_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='marketing_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='marketing_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}

public function ordre_qty_summary()
{
$table='marketing_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$data['res']=$this->store_model->fetch_order_summary($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

$data['userdetails'] = $this->session_data_pass();
	$data['user_type_id'] = $this->access_id();
	$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

$data['res']=$this->store_model->fetch_total_value_res($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

echo json_encode($getalldata);

}
public function po_receipt_details() 
{
$table='po_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function date_wise_po_receipt_details()
{
	$table='po_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$details=$this->store_model->date_wise_po_receipt_getorder_po_reports($f,$t);

echo json_encode($details);

}	
public function ordre_qty_po_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='po_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='po_receipt_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function po_receipts_preview()
{
$table='po_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;
$data['from_d']=$f;
$data['to_d']=$t;
$data['res']=$this->store_model->date_wise_po_receipt_getorder_po_reports($f,$t);
$data['res_net']=$this->store_model->date_wise_po_receipt_getorder_po_reports_net_wt($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

public function po_fabric_receipt() 
{
	$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'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
				$this->load->view('templates/header_inside',$data);
				$this->load->view('reports/po_fabric_receipt',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}
public function po_fabric_receipt_data()
{
//$data=array('confirm_status' => 'CONFIRMED');
$table='indent_goods_details';
$getalldata = $this->store_model->get_fabric_details($table);

echo json_encode($getalldata);

}
public function date_wise_po_fabric_receipt_details()
{
	$table='po_fabric_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$details=$this->store_model->date_wise_po_fabric_receipt_getorder_po_reports($f,$t);

echo json_encode($details);

}	
public function po_fabric_receipt_details() 
{
$table='po_fabric_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function ordre_qty_po_fabric_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='po_fabric_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='po_fabric_receipt_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function po_fabric_receipts_preview()
{
$table='po_fabric_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;
$data['from_d']=$f;
$data['to_d']=$t;
$data['res']=$this->store_model->date_wise_po_fabric_receipt_getorder_po_reports($f,$t);
$data['res_net']=$this->store_model->date_wise_po_fabric_receipt_getorder_sum_po_reports($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

public function po_twisting_receipt() 
{
	$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'];

$getalldata = $this->store_model->fetch_yarn_new_po_twisting_data();

echo json_encode($getalldata);

}
public function date_wise_po_twisting_receipt_details()
{
	$table='po_twisting_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$details=$this->store_model->date_wise_po_receipt_getorder_po_twisting_reports($f,$t);

echo json_encode($details);

}	
public function po_twisting_receipt_details() 
{
$table='po_twisting_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function ordre_qty_po_twisting_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='po_twisting_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='po_twisting_receipt_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function po_twisting_receipts_preview()
{
$table='po_twisting_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;
$data['from_d']=$f;
$data['to_d']=$t;
$data['res']=$this->store_model->date_wise_po_receipt_getorder_po_twisting_reports($f,$t);
$data['res_net']=$this->store_model->date_wise_po_receipt_getorder_po_twisting_sum_reports($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

public function po_dyed_receipt() 
{
	$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'];

$getalldata = $this->store_model->fetch_yarn_new_po_dyed_data();
echo json_encode($getalldata);

}
public function date_wise_po_dyed_receipt_details()
{
	$table='po_dyed_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$details=$this->store_model->date_wise_po_receipt_getorder_po_dyed_reports($f,$t);

echo json_encode($details);

}	
public function po_dyed_receipt_details() 
{
$table='po_dyed_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function ordre_qty_po_dyed_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='po_dyed_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='po_dyed_receipt_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function po_dyed_receipts_preview()
{
$table='po_dyed_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;
$data['from_d']=$f;
$data['to_d']=$t;
$data['res']=$this->store_model->date_wise_po_receipt_getorder_po_dyed_reports($f,$t);
$data['res_net']=$this->store_model->date_wise_po_receipt_getorder_po_dyed_sum_reports($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

public function po_consumables_receipt() 
{
	$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'];

$getalldata = $this->store_model->get_data_cs_po_fetchs();
echo json_encode($getalldata);

}
public function date_wise_po_consumables_receipt_details()
{
	$table='po_consumables_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$details=$this->store_model->date_wise_po_receipt_getorder_po_consumables_reports($f,$t);

echo json_encode($details);

}	
public function po_consumables_receipt_details() 
{
$table='po_consumables_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function ordre_qty_po_consumables_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='po_consumables_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='po_consumables_receipt_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function po_consumables_receipts_preview()
{
$table='po_consumables_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;
$data['from_d']=$f;
$data['to_d']=$t;
$data['res']=$this->store_model->date_wise_po_receipt_getorder_po_consumables_reports($f,$t);
$data['res_net']=$this->store_model->date_wise_po_receipt_getorder_po_consumables_sum_reports($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

public function po_spares_receipt() 
{
	$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'];

$getalldata = $this->store_model->get_data_spares_po_fetchs();
echo json_encode($getalldata);

}
public function date_wise_po_spares_receipt_details()
{
	$table='po_spares_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;

$details=$this->store_model->date_wise_po_receipt_getorder_po_spares_reports($f,$t);

echo json_encode($details);

}	
public function po_spares_receipt_details() 
{
$table='po_spares_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function ordre_qty_po_spares_summary_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='po_spares_receipt_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='po_spares_receipt_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function po_spares_receipts_preview()
{
$table='po_spares_receipt_reports';
$where=array('status'=>0);
$row_val=$this->store_model->fetch_where_subgrid_data($table,$where);

$f=$row_val->from_date;
$t=$row_val->to_date;
$data['from_d']=$f;
$data['to_d']=$t;
$data['res']=$this->store_model->date_wise_po_receipt_getorder_po_spares_reports($f,$t);
$data['res_net']=$this->store_model->date_wise_po_receipt_getorder_po_spares_sum_reports($f,$t);

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

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];

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

///////////////////////////////////// 6-11-2018  ///////////////////////////////////

public function weaving_receipt() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

}

public function weaving_receipt_data() 
{
   $details=$this->vendor_model->fetch_weaving_receipt_details();
   echo json_encode($details);
}

public function woven_report_data() 
{
$table='weaving_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='weaving_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_woven_receipt_details() 
{
$table='weaving_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';

$details= $this->vendor_model->fetch_weaving_receipt_report_details($from_date,$to_date);

echo json_encode($details);
}

public function madeups_receipt() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

}

public function madeups_receipt_data() 
{
   $details=$this->vendor_model->fetch_madeups_receipt_details();
   echo json_encode($details);
}

public function madeups_report_data() 
{
$table='madeups_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='madeups_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_madeups_receipt_details() 
{
$table='madeups_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';

$details= $this->vendor_model->date_wise_madeups_reports($from_date,$to_date);

echo json_encode($details);
}

//////////////////////////////  12-11-2018  //////////////////////////////////////////

public function sample_request_reports() 
{
	$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();

public function sample_request_receipt_data() 
{
$table='sample_request';
   $details=$this->vendor_model->get_data_date_dsc_customer($table);
   echo json_encode($details);
}

public function reports_hangerpreview()
{
	$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='sample_request';
$where=array('id'=>$val);
$data['fetch_data']=$this->request_model->fetch_where_data($table,$where);

$w=$data['fetch_data']->article;

$table='article_master';
$where=array('articleNo'=>$w);
$data['weight']=$this->request_model->fetch_where_data($table,$where);
 $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
	  $data['access'] = $this->access_details();
	   $data['indent_p']='indent_preview';
$data['back_preview']='reports';
	  	 
		$this->load->view('request/hanger_preview',$data);
	  
	
}
public function reports_cusionpreview()
{
	$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='sample_request';
$where=array('id'=>$val);
$data['fetch_data']=$this->request_model->fetch_where_data($table,$where);
 $data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['back_preview']='reports';
	  $data['access'] = $this->access_details();
	   $data['indent_p']='indent_preview';
	$this->load->view('request/cusion_previw',$data);
	  
	
}
public function reports_view_all_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);
		
	$uri = $_SERVER["REQUEST_URI"]; 
$val = substr($uri, strpos($uri, "=") + 1);
$table='sample_request';
$where=array('id'=>$val);
$data['fetch_data']=$this->request_model->fetch_where_data($table,$where);
$w=$data['fetch_data']->article;
$d = $data['fetch_data']->date; // Pull your date from the db
		$date = new DateTime($d);
		$data['day'] = $date->format('d') ; // Creates date number
		$data['month'] = $date->format('m'); // Creates month number
		$data['year'] = $date->format('Y');

$table='article_master';
$where=array('articleNo'=>$w);
$data['weight']=$this->request_model->fetch_where_data($table,$where);
$data['user_type_id'] = $this->access_id();
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
	  $data['access'] = $this->access_details();
	   $data['back_preview']='reports';
	  	   $data['indent_p']='indent_preview';
		$this->load->view('request/view_all_data',$data);
	  
	
}
public function reports_edit_form()
        {
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
        	$uri = $_SERVER["REQUEST_URI"];
        	$val = substr($uri, strpos($uri, "=") + 1);
        	$table='sample_request';
        	$where=array('id'=>$val);
        	$data['edit_data']=$this->request_model->fetch_where_data($table,$where);
        	$d = $data['edit_data']->date; // Pull your date from the db
        	$date = new DateTime($d);
        	$data['day'] = $date->format('d') ; // Creates date number
        	$data['month'] = $date->format('m'); // Creates month number
        	$data['year'] = $date->format('Y');
        	$data['articles'] = $this->marketing_model->display_article_data();
        	$data['quality'] = $this->marketing_model->display_article_data();
        	$data['designdata'] = $this->marketing_model->display_design_data();
        	$data['product'] = $this->request_model->fetch_data();
        	$data['outsource'] = $this->request_model->display_product_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();

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

public function sample_report_data() 
{
$table='sample_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$from_date=$this->input->post('from_delivery_date_required_on');
$to_date=$this->input->post('to_delivery_date_required_on');
$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
$table='sample_report';
$data=array('from_date'=>$from_date,'to_date'=>$to_date);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}

public function date_wise_sample_receipt_details() 
{
$table='sample_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';

$details= $this->vendor_model->date_wise_sample_reports($from_date,$to_date);

echo json_encode($details);
}
///////////////////////////////////   14-11-2018   ////////////////////////////////////////////

public function inhouse_planning_report() 
{
	$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'];

public function inhouse_planning_receipt_data() 
{
$table='sample_request';
   $details=$this->vendor_model->get_data_inhouse_planning_data();
  
   echo json_encode($details);
}
public function outsource_planning_report() 
{
	$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'];

public function outsource_planning_receipt_data() 
{

$table='sample_request';
   $details=$this->vendor_model->get_data_outsource_planning_data();
   echo json_encode($details);
}

public function inhouse_report_data() 
{
$table='inhouse_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));
$table='inhouse_report';
$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function inhouse_planning_receipt_details() 
{
$table='inhouse_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';

$details= $this->vendor_model->date_wise_inhouse_reports($from_date,$to_date);

echo json_encode($details);
}
public function outsource_report_data() 
{
$table='outsource_report';
	$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));
$table='outsource_report';
$data=array('from_date'=>$f,'to_date'=>$t);
$this->db->insert($table,$data);
$id=$this->session->userdata('logged_in');
				$where=array('id'=>$id);
				$data['approved_by']=$id['username'];

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			$data['from_dates']=$this->input->post('from_delivery_date_required_on');
$data['to_dates']=$this->input->post('to_delivery_date_required_on');
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
				$data['access'] = $this->access_details();
$table='employee_details';
$data['user_list']=$this->vendor_model->fetch_where_data($table);

}
public function outsource_planning_receipt_details() 
{
$table='outsource_report';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;
$type='Spares';

$details= $this->vendor_model->date_wise_outsource_reports($from_date,$to_date);

echo json_encode($details);
}
public function date_wise_po_reports_xsl_details() 
{
//$table='po_reports';
//$where=array('status'=>0);
//$r=$this->vendor_model->get_customerdata($table,$where);

$from_date  ='';
$to_date ='';

$data['details']= $this->store_model->display_po_reports_xsls_loc_grid_embroidryinspection_data();
$data['total_res']= $this->store_model->display_po_reports_xsls_loc_grid_embroidryinspection_data_group();

echo json_encode($data);
}

///////////////////////////////
public function date_wise_fetch_madeups_detailss() 
{

$data['details']= $this->store_model->date_wise_madeups_fetch_reports();
$data['details_res']= $this->store_model->date_wise_madeups_fetch_reportss();

//$detailss = $this->store_model->date_wise_inspected_reportss($from_date  ,$to_date );
//$details=array_merge($details_r,$detailss);
	echo json_encode($data);
}

public function delievry_date_data()
{
$from_date=$this->input->post('f');
$to_date=$this->input->post('t');

$table='delivery_marketing_reports';
$this->db->from($table); 
$this->db->truncate();

$this->db->truncate($table);

$table='delivery_marketing_reports';

$f=date('Y-m-d',strtotime($from_date));
$t=date('Y-m-d',strtotime($to_date));

$datas=array('from_date'=>$f,'to_date'=>$t);

$this->db->insert($table,$datas);

echo json_encode($datas);

}
public function delivery_date_marketing_details() 
{
$table='delivery_marketing_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);

$from_date=$r->from_date;
$to_date=$r->to_date;

$f=date('d-m-Y',strtotime($from_date));
$t=date('d-m-Y',strtotime($to_date));

$data['from_dates']=$f;
$data['to_dates']=$t;

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

}
public function delivery_date_wise_marketing_details()
{
$table='delivery_marketing_reports';
$where=array('status'=>0);
$r=$this->vendor_model->get_customerdata($table,$where);
//print_r($r);
//die();
$from_date  =$r->from_date;
$to_date =$r->to_date;

$details= $this->store_model->delivery_date_wise_OSL_NUMBER_getorder_reports($from_date,$to_date );

echo json_encode($details);

}

public function billing_fabrics_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function billing_madeups_reports() 
{
	$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'];
        
$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

public function billing_fabrics_data() 
{
    ini_set('memory_limit', '512M');

$getalldata = $this->store_model->fabric_report();

echo json_encode($getalldata);

}

public function billing_madeups_data() 
{

ini_set('memory_limit', '1024M');

$details2= $this->store_model->madeup_report();
	echo json_encode($details2);

}

public function billing_fabric_export_reports() 
{

$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'];
    
	$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
		
    $data['userdetails'] = $this->session_data_pass();
    $data['user_type_id'] = $this->access_id();
    $data['access'] = $this->access_details();
      
    $access_menu_id=$this->access_details_id();

}

public function billing_fabrics_report_data() 
{

$from=$_POST['from'];
$to=$_POST['to'];
$details2= $this->store_model->fabric_report_new($from,$to);
if($details2){
	echo json_encode(array("result"=>1,"message"=>$details2));
}else
{
	echo json_encode(array("result"=>0,"message"=>"No data found"));
}

}

public function billing_madeups_export_reports() 
{

}

public function billing_madeups_report_data() 
{

$from=$_POST['from'];
$to=$_POST['to'];
$details2= $this->store_model->madeups_report_new($from,$to);
if($details2){
	echo json_encode(array("result"=>1,"message"=>$details2));
}else
{
	echo json_encode(array("result"=>0,"message"=>"No data found"));
}

}

public function billing_data_new() 
{
    
    $table='packing_list_data';
$where=array('total_value'=>0,'report_total_value' =>0);
$p_ress= $this->store_model->get_data_fetch($table,$where);

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);

$table='packing_list_data';
	$where = array('invoice'=>$pss->invoice,'status'=>'0');
	$datat=array('report_total_value'=>$pss->total_value);
	$this->store_model->update_data($where,$table,$datat);
}

foreach($p_ress as $ps)
{
	
	$where = array('invoice'=>$ps->invoice,'status'=>'0');
	$table='invoice_packing';

$table='madeups_list_data';
$where=array('total_value'=>0,'report_total_value' =>0);
$p_ress= $this->store_model->get_data_fetch($table,$where);

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);

foreach($p_ress as $ps)
{
	$where = array('invoice_num'=>$ps->invoice_num,'status'=>'0');
	$table='madeups_invoice_packing';

$table='packing_list_data';
$where=array('status'=>0,'tot_qty'=>0);

$p_res= $this->store_model->get_data_fetch($table,$where);

}

$table='madeups_list_data';
$where=array('status'=>0,'tot_qty'=>0);
$m_res= $this->store_model->get_data_fetch($table,$where);

}

$table='packing_list_data';
$where=array('status'=>0);
$p_data_all= $this->store_model->get_data_fetch($table,$where);
foreach($p_data_all as $pss)
{
	$table='invoice_packing';
	$where = array('invoice_num'=>$pss->invoice_num,'status'=>'0');
	$fetch_sum_pcs_invoice=$this->vendor_model->sum_get_customerdata($table,$where);

$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);
	
	$datas=array('all_stock_qty'=>$fetch_sum_pcs_invoice->stock_wt,'total_invoice'=>$fetch_sum_amt_invoice->values_es);
	$table='packing_list_data';

$this->store_model->update_data($where,$table,$datas);
}

$table='madeups_list_data';
$where=array('status'=>0);
$p_data_all= $this->store_model->get_data_fetch($table,$where);
foreach($p_data_all as $pss)
{
	$table='madeups_invoice_packing';
	$where = array('invoice_num'=>$pss->invoice_num,'status'=>'0');
	$fetch_sum_pcs_invoice=$this->vendor_model->sum_get_customerdata_new11($table,$where);
	$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);
	$datas=array('all_stock_qty'=>$fetch_sum_pcs_invoice->stock_qty,'total_invoice'=>$fetch_sum_amt_invoice->values_es);
	$table='madeups_list_data';

$this->store_model->update_data($where,$table,$datas);
}

$from=$_GET['from_date'];
	$to=$_GET['to_date'];

$details1= $this->store_model->get_packing_list_data_new($from,$to);
$details2= $this->store_model->get_madeups_list_data_new($from,$to);
$details=array_merge($details1,$details2);

foreach ($details as $key => $row)
{
	//$sys_date[$key]==field name with key
    $sys_date[$key]  = $row->sys_date;
} 
$det=array_multisort($sys_date, SORT_DESC, $details);
	echo json_encode($details);

}

public function hsn_report() 
{

}

public function report_value_analysis() 
{
	    $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'];
        
			
         $data['userdetails'] = $this->session_data_pass();
          $data['user_type_id'] = $this->access_id();
          $data['access'] = $this->access_details();
          
           $access_menu_id=$this->access_details_id();

$data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
                
                $table='consumed_at';
                $where=array('status'=>1);
                $data['loc']=$this->marketing_model->fetch_where_data($table,$where);
                			
                				$data['userdetails'] = $this->session_data_pass();
                				$data['user_type_id'] = $this->access_id();
                				$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);
                
                
                $data['fabric'] = $this->outsource_model->display_fabric_embroidryinspection_sum('all');
                $data['yarn_raw'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('all');
                $table='delivery_yarn_twisting';
                $where=array('status'=>1,'issue_net_weight >'=>0);
                $data['yarn_twisting'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'all');
                $data['dyed_yarn'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('all');
                $data['swan_yarn_dyed'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('all');
                
                
                
                
                 $this->db->truncate('delivery_yarn_twisting');
	 $this->db->empty_table('delivery_yarn_twisting');
	
	
	$data1 = $this->outsource_model->display_yarn_twisting_grid_detailed_data();
	foreach($data1 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);
	}
    
                
                
                // year wise
                $data['fabric_2020'] = $this->outsource_model->display_fabric_embroidryinspection_sum('2020');
                $data['fabric_2021'] = $this->outsource_model->display_fabric_embroidryinspection_sum('2021');
                $data['fabric_2022'] = $this->outsource_model->display_fabric_embroidryinspection_sum('2022');
                $data['fabric_2023'] = $this->outsource_model->display_fabric_embroidryinspection_sum('2023');
                $data['fabric_2024'] = $this->outsource_model->display_fabric_embroidryinspection_sum('2024');
                $data['fabric_2025'] = $this->outsource_model->display_fabric_embroidryinspection_sum('2025');
                
                $data['yarn_raw_2020'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('2020');
                $data['yarn_raw_2021'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('2021');
                $data['yarn_raw_2022'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('2022');
                $data['yarn_raw_2023'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('2023');
                $data['yarn_raw_2024'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('2024');
                $data['yarn_raw_2025'] = $this->outsource_model->display_yarn_raw_grid_data_group_sum('2025');
                 
                $data['yarn_twisting_2020'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'2020');
                $data['yarn_twisting_2021'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'2021');
                $data['yarn_twisting_2022'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'2022'); 
                $data['yarn_twisting_2023'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'2023');
                $data['yarn_twisting_2024'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'2024');
                $data['yarn_twisting_2025'] = $this->outsource_model->get_embroidery_data_sum($table,$where,'2025');
                
                $data['dyed_yarn_2020'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('2020');
                $data['dyed_yarn_2021'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('2021');
                $data['dyed_yarn_2022'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('2022');
                $data['dyed_yarn_2023'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('2023');
                $data['dyed_yarn_2024'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('2024');
                $data['dyed_yarn_2025'] = $this->outsource_model->display_yarn_dyed_grid_detailed_data_group_sum('2025');
                
                
                $data['swan_yarn_dyed_2020'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('2020');
                $data['swan_yarn_dyed_2021'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('2021');
                $data['swan_yarn_dyed_2022'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('2022');
                $data['swan_yarn_dyed_2023'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('2023');
                $data['swan_yarn_dyed_2024'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('2024');
                $data['swan_yarn_dyed_2025'] = $this->outsource_model->display_swan_reports_loc_grid_embroidryinspections_data_sum('2025');
                   
        
                	
				$this->load->view('templates/header_inside',$data);
				$this->load->view('reports/stock_analysis',$data);
				$this->load->view('templates/footer_inside');
           }
           else
            {  
                   $this->session->sess_destroy();
        redirect(base_url());
           }
}

public function hsn_report_details() 
{

$this->store_model->update_data($where,$table,$datas);
}

$table='madeups_list_data';
$where=array('status'=>0);
$p_data_all= $this->store_model->get_data_fetch($table,$where);
foreach($p_data_all as $pss)
{
	$table='madeups_invoice_packing';
	$where = array('invoice_num'=>$pss->invoice_num,'status'=>'0');
	$fetch_sum_pcs_invoice=$this->vendor_model->sum_get_customerdata($table,$where);
	$fetch_sum_amt_invoice=$this->vendor_model->sum_amount_get_customerdata($table,$where);
	$datas=array('all_stock_qty'=>$fetch_sum_pcs_invoice->stock_wt,'total_invoice'=>$fetch_sum_amt_invoice->values_es);
	$table='madeups_list_data';

$this->store_model->update_data($where,$table,$datas);
}

$from=$_GET['from_date'];
	$to=$_GET['to_date'];

$details1= $this->store_model->get_packing_list_data_hsn($from,$to);
$details2= $this->store_model->get_madeups_list_data_hsn($from,$to);
$details=array_merge($details1,$details2);

$sys_date = [];

foreach ($details as $key => $row) {
    if (isset($row->sys_date)) {  
        $sys_date[$key] = $row->sys_date;
    } else {
       
        $sys_date[$key] = null; 
    }
}
if (is_array($sys_date)) {
    array_multisort($sys_date, SORT_DESC, $details);
    echo json_encode($details);
} else {
    echo 'Error: $sys_date is not an array!';
}
}
}
?>