EVOLUTION-NINJA

Edit File: Madeups_billing.php

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

class Madeups_billing 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('outsource_model');
$this->load->model('marketing_model');
$this->load->model('planning_yarn');
$this->load->model('planning_shade');
$this->load->model('request_model');
$this->load->model('vendor_model');
$this->load->model('store_model');
$this->load->model('madeups_model');
$this->load->helper(array('form', 'url'));
$this->load->helper('array');
$this -> load -> library('form_validation');
$this->load->helper('date');
date_default_timezone_set('asia/kolkata');
}

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

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

public function session_data_pass() {
if ($this->session->userdata('logged_in')) {
return $this->yarn_model->get_userdata();
}
}
public function access_details_id()
	{
		$id=$this->session->userdata('logged_in');
	$where=array('id'=>$id);
	$approved_by=$id['userid'];
	$table='employee_details';
	$where=array('id'=>$approved_by);
	$d=$this->marketing_model->fetch_main_data($table,$where);
	$data['user_type_id']=$d->user_type_id;
	
	$table='swansilk_access_controls';
	$where=array('department_id'=>$data['user_type_id']);
	return $this->marketing_model->fetch_main_data($table,$where);
	}
public function access_details()
	{
		$id=$this->session->userdata('logged_in');
	$where=array('id'=>$id);
	$approved_by=$id['userid'];
	$table='employee_details';
	$where=array('id'=>$approved_by);
	$d=$this->marketing_model->fetch_main_data($table,$where);
	$data['user_type_id']=$d->user_type_id;
	
	$table='swansilk_access_controls';
	$where=array('department_id'=>$data['user_type_id']);
	return $this->marketing_model->fetch_where_data($table,$where);
	}
		public function indent_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
			if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'HO Purchase Admin' )  
	 { 
		$d=date('d-m-Y');
		$table='indent_add_indent';
		$where=array('indented_date'=>$d,'insert_notification_status'=>0);
		$indent_insert_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
					
		$d=date('d-m-Y');
		$table='indent_add_indent';
		$where=array('updated_on'=>$d,'update_notification_status'=>0);
		$indent_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		$d=date('d-m-Y');
		$table='indent_add_indent';
		$where=array('approved_date'=>$d,'approval_notification_status'=>0);
		$indent_approval_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		 }	
	  else
	  {
		$indent_insert_rows=0;
		$indent_update_rows=0;
		$indent_approval_rows=0;
	  }
	
		//
	if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin')  	
	 { 
		$d=date('d-m-Y');
		$table='indent_po';
		$where=array('created_date'=>$d,'insert_notification_status'=>0);
		$indent_po_insert_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
	 }
	else
	{
		$indent_po_insert_rows1=0;
	}
	if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'HO Purchase Admin' ) 
	{	
		$d=date('d-m-Y');
		$table='indent_po';
		$where=array('updated_on'=>$d,'update_notification_status'=>0);
		$indent_po_update_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		$d=date('d-m-Y');
		$table='indent_po';
		$where=array('approved_date'=>$d,'approval_notification_status'=>0);
		$indent_po_approval_rows1=$this->vendor_model->count_amount_get_customerdata($table,$where);
		}
	else
	{
		$indent_po_update_rows1=0;
		$indent_po_approval_rows1=0;
	}	
		$r=$indent_insert_rows + $indent_update_rows + $indent_approval_rows + $indent_po_insert_rows1 + $indent_po_update_rows1 + $indent_po_approval_rows1;
		return $r;
   }
   public function issue_loom_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
		if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin' || $data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' )  
	 { 
		$d=date('d-m-Y');
		$table='issue_loom';
		$where=array('issued_date'=>$d,'insert_notification_status'=>0);
		$indent_insert_rows=$this->vendor_model->count_of_pcs($table,$where);
					
		 $d=date('d-m-Y');
		 $table='issue_loom';
		 $where=array('rements_approved_date'=>$d,'update_notification_status'=>0);
		 $indent_update_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
		
		 $d=date('d-m-Y');
		 $table='weaving_panel_planning_order';
		 $where=array('issue_approved_date'=>$d,'approval_notification_status'=>0);
		 $indent_approval_rows=$this->vendor_model->count_amount_get_customerdata($table,$where);
	  }	
	   else
	   {
		  $indent_insert_rows=0;
		  $indent_approval_rows=0;
		  $indent_update_rows=0;
	   }
	
		
		$r=$indent_insert_rows + $indent_approval_rows + $indent_update_rows;
		
	
		return $r;
		
   }	
   public function stock_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		//
		if($data['emp_details']->designation == 'PPC Manager' || $data['emp_details']->designation == 'PPC Executive' || $data['emp_details']->designation == 'ACCOUNTS' || $data['emp_details']->designation == 'Accounts') 
		{
			$d=date('d-m-Y');
			$table='fabric_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='swan_yarn_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows1']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
			
			$d=date('d-m-Y');
			$table='yarn_transfer';
			$where=array('transfer_date'=>$d,'insert_notification_status'=>0);
			$data['stoct_transfer_rows2']=$this->vendor_model->count_amount_notification_get_customerdata($table,$where);
		}
		else
		{
			$data['stoct_transfer_rows']=0;
			$data['stoct_transfer_rows1']=0;
			$data['stoct_transfer_rows2']=0;
		}
	
			if($data['emp_details']->designation == 'Super Admin' || $data['emp_details']->designation == 'Admin')
		{ 
		
$ttt1=date('d/m/Y');
       $ddd1=date('d-m-Y');
		$table='fabric_inspection_details';
		$where=array('received_date'=>$ttt1);
		$where1=array('received_date'=>$ddd1);
		$data['stock_split_data']=$this->vendor_model->fabric_inspection_split_count_amount_get_customerdata($table,$where,$where1);

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

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

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

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

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

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

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

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

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

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

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

$this->load->view('templates/header_inside',$data);
	$this->load->view('vendor_master/notification_page',$data);
	$this->load->view('templates/footer_inside');
	
	
	  }  
 public function inward_page_notifications()
   {
	    $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		$table='date_notification';
		$where=array('status'=>0);
		$date_wise_data=$this->vendor_model->get_customerdata($table,$where);
		$data['date_rel_data']=$this->vendor_model->get_customerdata($table,$where);
		$d=$date_wise_data->req_date;
				//
			
			
			
		//	$d=date('d-m-Y');
			$table='indent_yarn_goods_details';
			$where=array('received_date'=>$d,'insert_notification_status'=>0);
			$data['yarn_delivery_inserted_rows']=$this->vendor_model->yarn_delivery_insert_getsuborder1($d);
			$data['yarn_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			//$d=date('d-m-Y');
			$table='indent_cs_goods_details';
			$where=array('received_date'=>$d,'insert_notification_status'=>0);
			$data['cs_delivery_inserted_rows1']=$this->vendor_model->cs_delivery_insert_getsuborder1($d);
			$data['cs_delivery_insert_rows1']=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			
			$newDate = date("d/m/Y", strtotime($d));
			//$d=date('d/m/Y');
			$table='indent_cs_goods_details';
			$where=array('received_date'=>$newDate,'insert_notification_status'=>0);
			$data['cs_delivery_inserted_rows']=$this->vendor_model->cs_delivery_insert_getsuborder1($newDate);
			$data['cs_delivery_insert_rows']=$this->vendor_model->count_amount_get_customerdata($table,$where);
			
			
				
				$input=$newDate;
			
			$datee = explode('/', $input);
			
			$day = $datee[0];
			$month   = $datee[1];
			$year  = $datee[2];

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

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

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

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

$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 access_id()
	{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
		$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 request_details()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
			$rs=$this->input->post('reference_value');	
	if($rs == 'indent')
	{
	   $data['indent_po'] = 'indent_preview';
	   
	}
	else if($rs == 'today_dashboard')
	{
    	$data['indent_po'] = 'today_preview';
	}
	else if($rs == 'month_dashboard')
	{
	    $data['indent_po'] = 'monthly_preview';
	}
	else if($rs == 'year_dashboard')
	{
	    $data['indent_po'] = 'year_preview';
	}
	
	$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();
	$table='sample_request';
	$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();

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

public function index() 
{
    $table='sub_orders';
    $where=array('subOrderType'=>'FABRIC','orders_Type'=>' ');
    $order_typesd=$this->vendor_model->get_where_dataa($table,$where);

if(empty($order_typesd))
        {
        }
    else
    {
        foreach($order_typesd as $t)
        {

$table='sub_orders';
            $where=array('id'=>$t->id);
            $update_data=array('orders_Type'=>'FABRIC');
            $this->vendor_model->update_data($where,$table,$update_data);
        }
    }
 
    $table='sub_orders';
    $where=array('subOrderType !='=>'FABRIC','orders_Type'=>' ');
    $order_types_madeups=$this->vendor_model->get_where_dataa($table,$where);

if(empty($order_types_madeups))
    {
    
    }
    else
    {
        foreach($order_types_madeups as $tt)
        {

$table='sub_orders';
            $where=array('id'=>$tt->id);
            $update_data=array('orders_Type'=>'MADEUPS');
            $this->vendor_model->update_data($where,$table,$update_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"]; 
         
               $RT  = substr($uri, strpos($uri, "/") + 12);
       
        if($RT == 'madeups_billing?prop_id=1')
        {
              
            $data['url_val']='4';
            $data['val']='madeups_billing?prop_id=1';
            $data['ref']='year_dashboard';
        }
        else if($RT == 'madeups_billing/')
        {
              
            $data['url_val']='4';
            $data['val']='madeups_billing?prop_id=1';
            $data['ref']='year_dashboard';
        }
			   	
        
        
                
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
        
		//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
	//----------tiill--------------------
	
        $data['userdetails'] = $this->session_data_pass();
        $data['user_type_id'] = $this->access_id();
        $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
        $data['access'] = $this->access_details();
          
        $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
                   $check="";
                   foreach($m_id as $menu_id)
                   {
                           
                           $table='swansilk_menu';
                           $where=array('delete_status'=>'ACTIVE','menu_id'=>$menu_id);
                           $result= $this->marketing_model->fetch_main_data($table,$where);
                           
                           if($result->reference_url  == $data['val'])
                           {
                                   $check = $data['val'];
                           }
                           
           }
           //echo $check;
           
           if($check != "")
           {
			    //
			    $access_menu_id = $this->access_details_id();

if(empty($order_typesd))
        {
        }
    else
    {
        foreach($order_typesd as $t)
        {

if(empty($order_types_madeups))
    {
    
    }
    else
    {
        foreach($order_types_madeups as $tt)
        {

$table='sub_orders';
            $where=array('id'=>$tt->id);
            $update_data=array('orders_Type'=>'MADEUPS');
            $this->vendor_model->update_data($where,$table,$update_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"]; 
         
        $RT  = substr($uri, strpos($uri, "/") + 12);
       
       
              
            $data['url_val']='4';
            $data['val']='madeups_billing?prop_id=1';
            $data['ref']='year_dashboard';
       
			   	
        
        
                
        $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
        
		//
		 $id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $approved_id=$id['userid'];
		
		$table='employee_details';
		$where=array('id'=>$approved_id);
		$dept_id_row=$this->vendor_model->get_where_row($table,$where);
		
		$user_type_id_row=$dept_id_row->user_type_id;
	
	//----------tiill--------------------
	
        $data['userdetails'] = $this->session_data_pass();
        $data['user_type_id'] = $this->access_id();
        $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
			
        $data['access'] = $this->access_details();
          
        $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
                   //print_r($m_id);
                   $data1=array();
                   foreach($m_id as $menu_id)
                   {
					   $table='access_action_rights';
						$where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
						$arr=$this->vendor_model->get_where_row($table,$where);
						//print_r($this->db->last_query());
						if(empty($arr))
						{
							
						}
						else
						{	//print_r($arr); 
                            $menu_id=$arr->menu_id;
                            $table='swansilk_menu';
                            $where=array('menu_id'=>$menu_id);
							$url=$this->vendor_model->get_where_row($table,$where);
    						if(!empty($url->reference_url)){
    						    
    							if($url->reference_url == $data['val']) 
    							{
    								$data['access_row']=$arr;
    							} 
    						    
						    }
						}
				   }
				//   print_r($data['access_row']);
				//   die();
				//----------tiill--------------------
				
       	  	    $data['getalldata'] = $this->marketing_model->display_transaction_data();
				//echo '<pre>';print_R($data['getalldata']);exit;
				$data['userdetails'] = $this->session_data_pass();
				$data['user_type_id'] = $this->access_id();
                $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
                			
                $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'];
                $data['usertype']=$id['usertype'];
                
                //$data['designation'] = $id['designation'];
                
                $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['access'] = $this->access_details();
				$this->load->view('templates/header_inside',$data);
				$this->load->view('debit_note/madeups_billing_new', $data);
				$this->load->view('templates/footer_inside');
            }
            else
            {  
                $this->session->sess_destroy();
                redirect(base_url()); 
            }
}
public function order_list_details() {
     
    $get = $this->uri->segment(3);
	$table='sub_orders';
	$dd='DTL';
	$getalldata=$this->madeups_model->order_list_details($table,$dd);
   
	echo json_encode($getalldata);
}
public function subgrid1() {
    $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $data['approved_by']=$id['username'];
    
    $emp_row=$id['userid'];
    $table='employee_details';
    $where=array('id'=>$emp_row);
    $data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
    
    $get = $this->uri->segment(3);
    preg_match_all('!\d+!', $get, $matches);
    $id="";
    foreach($matches as $matches)
    {
    
    $id=$matches;
    }
    $i= $id[0];
    
    $getalldata = $this->madeups_model->getsuborder_update($i);
    //$getalldata = $this->marketing_model->input_preview_input_suborder($i);
    //print_r($getalldata);
   //  die();
    echo json_encode($getalldata);
}
public function subgrid2() {
    $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $data['approved_by']=$id['username'];
    
    $emp_row=$id['userid'];
    $table='employee_details';
    $where=array('id'=>$emp_row);
    $data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
    
    $get = $this->uri->segment(3);
    preg_match_all('!\d+!', $get, $matches);
    $id="";
    foreach($matches as $matches)
    {
    
    $id=$matches;
    }
    $i= $id[0];
    
    $getalldata = $this->madeups_model->getsuborder_update_new($i);
    
    //print_r($this->db->last_query());
   // die();
    $array =array();
    foreach($getalldata as $val){
        
        $num = $val->quantity/$val->piececase;
        $i = 0;
        for($i= 0; $i<$num; $i++){
            $data['orderID'] = $val->orderID;
            $data['id'] = $val->id.','.$val->ourShade;
            $data['articleNo'] = $val->articleNo;
            $data['unit'] = $val->unit;
            $data['width'] = $val->width;
            $data['subOrderType'] = $val->subOrderType;
            $data['description'] = $val->description;
            $data['totalQuantity'] = $val->totalQuantity;
            $data['totalValue'] = $val->totalValue;
            $data['orderConfirm'] = $val->orderConfirm;
            $data['edit'] = $val->edit;
            $data['delete'] = $val->delete;
            $data['confirm_by'] = $val->confirm_by;
            $data['created_by'] = $val->created_by;
              
            $data['design'] = $val->design;
            $data['quality'] = $val->quality;
            
            $data['weave'] = $val->weave;
            $data['shipping_status'] = $val->shipping_status;
            
            $data['quantity'] = $val->quantity;
            $data['unitPrice'] = $val->unitPrice;
            
            $data['foreignValue'] = $val->foreignValue;
            $data['shipped_by'] = $val->shipped_by;
            
            $data['ourShade'] = $val->ourShade;
            //$data['ourShade'] = 'hel';
            $data['net_wt'] = $val->net_wt;
            
            $data['gross_wt'] = $val->gross_wt;
            $data['box_dimention'] = $val->box_dimention;
            
            $data['piececase'] = $val->piececase;
            
    	
            array_push($array,$data);
        }
        
        
        
    }
    //$getalldata = $this->marketing_model->input_preview_input_suborder($i);
    //print_r($getalldata);
   //  die();
    echo json_encode($array);
}
public function add_suborders($get=''){
    $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $data['approved_by']=$id['username'];
    
    $emp_row=$id['userid'];
    $table='employee_details';
    $where=array('id'=>$emp_row);
    $data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
    $uri = $_SERVER["REQUEST_URI"]; 
     
           $RT  = substr($uri, strpos($uri, "/") + 13);;
		//    $get = $this->uri->segment(3);
    
        
              
            $data['url_val']='4';
            $data['val']='madeups_billing?prop_id=1';
            $data['ref']='year_dashboard';
    
    
            
    $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $data['approved_by']=$id['username'];
    
    //
     $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $approved_id=$id['userid'];
    
    $table='employee_details';
    $where=array('id'=>$approved_id);
    $dept_id_row=$this->vendor_model->get_where_row($table,$where);
    
    $user_type_id_row=$dept_id_row->user_type_id;

//----------tiill--------------------

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

$m_id=unserialize($access_menu_id->menu_id);
			   
               $check="";
               foreach($m_id as $menu_id)
               {
                       
                       $table='swansilk_menu';
                       $where=array('delete_status'=>'ACTIVE','menu_id'=>$menu_id);
                       $result= $this->marketing_model->fetch_main_data($table,$where);
                    //    print_r($result->reference_url);
					//    die();
                       if($result->reference_url  == $data['val'])
                       {
                               $check=$data['val'];
                       }
                       
       }
       if($check != "")
       {
            //
            $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
               $data1=array();
               foreach($m_id as $menu_id)
               {
                   $table='access_action_rights';
                    $where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
                    $arr=$this->vendor_model->get_where_row($table,$where);
                    if(empty($arr))
                    {
                        
                    }
                    else
                    {	//print_r($arr); 
                        $menu_id=$arr->menu_id;
                        $table='swansilk_menu';
                        $where=array('menu_id'=>$menu_id);
                        $url=$this->vendor_model->get_where_row($table,$where);
                        if(!empty($url->reference_url)){
                            
                            if($url->reference_url == $data['val']) 
                            {
                                $data['access_row']=$arr;
                            } 
                            
                        }
                    }
               }
            //----------tiill--------------------
            
                 $data['getalldata'] = $this->marketing_model->display_transaction_data();
            //echo '<pre>';print_R($data['getalldata']);exit;
            $data['userdetails'] = $this->session_data_pass();
            $data['user_type_id'] = $this->access_id();
            $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
                        
            $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'];
            $data['usertype']=$id['usertype'];
			$dd='DTL';
            $data['result'] = $this->madeups_model->list_details($get,$dd);
           // print_r($data['result']);
            //echo  $this->madeups_model->list_details($get,$dd);
           //die();
            //$data['designation'] = $id['designation'];
            
            $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['access'] = $this->access_details();
            // print_r($data);
            // die();
            $this->load->view('templates/header_inside',$data);
            $this->load->view('debit_note/add_suborder_madeups', $data);
            $this->load->view('templates/footer_inside');
        }
        else
        {  
            $this->session->sess_destroy();
            redirect(base_url());
        }
}
public function get_autofill()
{
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	// $table='fabric_madeups';
	$id=$this->input->post("id");
	$where=$id;
	//$data['quantity'] = $this->vendor_model->fetch_where_subgrid_data($table,$where);
	
	$data['quantity'] = $this->madeups_model->add_stock_value_planned_details($where);
	
	
	
	$table='fabric_madeups_delivery_confirmation';
	$id=$this->input->post("id");
	$where=array('ref_id'=>$id);
	$r= $this->madeups_model->delivery_rec_qua($table,$where);
	$row= $this->madeups_model->delivery_batch_no($table);

$d=$row->batch_id;

$data['batch']= $d+1;
	
	if(empty($r))
	{
		$rr=0;
		
	}
	else
	{
		$rr=$r;
	}
	$table6='madeups_box_master';
	$data['delievry_quantity']=$this->madeups_model->fetch_where_data($table6);
	
	// print_r($data['delievry_quantity']);
	// die();
	
$id=$this->session->userdata('logged_in');
	$where=array('id'=>$id);
	$data['approved_by']=$id['username'];

$where=array('id'=>$id['userid']);
	 $table='employee_details';
	$data['emp_loc']=$this->vendor_model-> get_customerdata($table,$where);
	$data['i']=$this->input->post("i");
	// print_r($data);
	// die();
	echo json_encode($data);
}

public function madeus_box_data()
{
	$table6='madeups_box_master';
	$data=$this->madeups_model->fetch_where_data($table6);
	echo json_encode($data);
}
public function add_suborder_form()
{			
//     echo '<pre>';
//     print_r($_POST);
//     echo '</pre>';
//   die();
	$id=$this->session->userdata('logged_in');
        $where=array('id'=>$id);
        $data['approved_by']=$id['username'];
		
		$emp_row=$id['userid'];
		$table='employee_details';
		$where=array('id'=>$emp_row);
		$data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
		
	    $submited_by =  $data['emp_details']->name;
		$ref_id =$this->input->post('ref_id');					
		$oslNo= $this->input->post('oslno');			
		$orderType= $this->input->post('ordertype');
		$width=$this->input->post('width');
		$article= $this->input->post('article');
		$design= $this->input->post('design');
		$buyerShade= $this->input->post('buyershade');
		$sslShade= $this->input->post('ssl_shade');
		$quantity= $this->input->post('quty');
		$net_wt= $this->input->post('net_wt');
		$gross_wt= $this->input->post('gross_wt');
		$box_dimention= $this->input->post('boxdimen');
		$case= $this->input->post('case');
		$sequence=$this->input->post('sequence');
		$sku=$this->input->post('sku');
		$customer=$this->input->post('customer');
		$desc=$this->input->post('desc');
	    $date = date('Y-m-d');
	    
	    $composition = $this->input->post('composition');
        $hsn_code = $this->input->post('hsn_code');
        $dbk_si = $this->input->post('dbk_si');
        $p_category = $this->input->post('p_category');
        $hs_code = $this->input->post('hs_code');
        $customs_declaration = $this->input->post('customs_declaration');
        $buyer_description = $this->input->post('custom_description');
        
        $buyer_product_name = $this->input->post('buyer_product_name');
        $barcode = $this->input->post('barcode');
        $vendor_item = $this->input->post('vendor_item');
    //     echo '<pre>';
	   // print_r($_POST);
	   // echo '<pre>';
	   // die();
	    
	foreach($ref_id as $key => $val)
	{
		$data=array('ref_id'=>$val,
            		'oslNo'=>$oslNo[$key],
            		'orderType'=>$orderType[$key],
            		'width'=>$width[$key],
            		'article'=>$article[$key],
            		'design'=>$design[$key],
            		'buyerShade'=>$buyerShade[$key],
            		'sslShade'=>$sslShade[$key],
            		'quantity'=>$quantity[$key],
            		'net_wt'=>$net_wt[$key],
            		'gross_wt'=>$gross_wt[$key],
            		'box_dimention'=>$box_dimention[$key],
            		'Case'=>$case[$key],
            		'sequence'=>$sequence[$key],
            		'sku_no'=>$sku[$key],
            		'customer_id'=>$customer[$key],
            		'description'=>$desc[$key],
            		'submited_date'=>$date,
            		'submited_by'=>$submited_by,
            		
                    'composition' => $composition[$key],
                    'hsn_code' => $hsn_code[$key],
                    'dbk_si' => $dbk_si[$key],	
                    'p_category' => $p_category[$key],
                    'hs_code' => $hs_code[$key],
                    'customs_declaration' => $customs_declaration[$key],
                    'buyer_description' => $buyer_description[$key],
                    
                    'buyer_product_name' => $buyer_product_name[$key],
                    'barcode' => $barcode[$key],
                    'vendor_item' => $vendor_item[$key],
                    
            		
		);
		$table='madeups_billing';
	    $insert_id=$this->madeups_model->insert_data($table,$data);
	   // echo '<pre>';
	   // print_r($_POST);
	   // echo '<pre>';
	   // print_r($this->db->last_query());
	}
	foreach($ref_id as $key=>$val){
		$mid=$val;
	
	$table3='planned_order';
	$where3=array('id'=>$mid);
	$sub_no=$this->madeups_model->fetch_sub_no($table3,$where3);
	
	$table5='sub_order_shades';
	$where5=array('shadeID'=>$sub_no);
	$data5=array('planned_status'=>1);
	$this->madeups_model->insert_status($table5,$where5,$data5);
	
	}
if($insert_id){
   echo json_encode(array('result'=>1));
}else{
     echo json_encode(array('result'=>0));
}
}
public function update_suborder_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);
		$tab_id=$this->input->post('tab_id');	
		$ref_id =$this->input->post('ref_id');					
		$oslNo= $this->input->post('oslno');			
		$orderType= $this->input->post('ordertype');
		$width=$this->input->post('width');
		$article= $this->input->post('article');
		$design= $this->input->post('design');
		$buyerShade= $this->input->post('buyershade');
		$sslShade= $this->input->post('ssl_shade');
		$quantity= $this->input->post('quty');
		$net_wt= $this->input->post('net_wt');
		$gross_wt= $this->input->post('gross_wt');
		$box_dimention= $this->input->post('boxdimen');
		$case= $this->input->post('case');
		$sequence=$this->input->post('sequence');
		$sku=$this->input->post('sku');
		$customer=$this->input->post('customer');
		$desc=$this->input->post('desc');
	    $date = date('Y-m-d');
		// print_r($_POST);
		// die();
	foreach($ref_id as $key => $val)
	{
		$data=array('ref_id'=>$val,
            		'oslNo'=>$oslNo[$key],
            		'orderType'=>$orderType[$key],
            		'width'=>$width[$key],
            		'article'=>$article[$key],
            		'design'=>$design[$key],
            		'buyerShade'=>$buyerShade[$key],
            		'sslShade'=>$sslShade[$key],
            		'quantity'=>$quantity[$key],
            		'net_wt'=>$net_wt[$key],
            		'gross_wt'=>$gross_wt[$key],
            		'box_dimention'=>$box_dimention[$key],
            		'Case'=>$case[$key],
            		'sequence'=>$sequence[$key],
            		'sku_no'=>$sku[$key],
            		'customer_id'=>$customer[$key],
            		'description'=>$desc[$key],
            		'submited_date'=>$date
		);
// 		print_r($_POST);
// 		die();
        if($tab_id[$key]=='new'){
			$table='madeups_billing';
			$insert_id=$this->madeups_model->insert_data($table,$data);
		}else{
    		$table='madeups_billing';
    		$where=array('id'=>$tab_id[$key]);
    		$edit_id=$this->madeups_model->insert_status($table,$where,$data);
		}
// 		print_r($data);
// 		die();	
	}	
	
if($edit_id!=''){
   echo json_encode(array('result'=>1));
}else{
     echo json_encode(array('result'=>0));
}
}
public function fetch_billing($table,$where){
        $this->db->select('*');
        $this->db->from($table);
        $this->db->where('id',$where);
        $query = $this->db->get();
        return $query->result();
    }
     public function get_cust_id($table,$where){
    $this->db->select('customerID');
    $this->db->from($table);
    	$this->db->where($where);
    	$query=$this->db->get();
		$ret = $query->row();
        return $ret->customerID;
 }
 public function customer_check(){
    $id=$this->input->post('id');
	$insert_id=$this->madeups_model->check_if_planned($id);
	$table='madeups_billing';
	$where=array('ref_id'=>$insert_id);
	$data=$this->madeups_model->get_data($table,$where);
	if($data){
		echo json_encode(array('result'=>1,'message'=>$data));
	 }else{
		  echo json_encode(array('result'=>0,'message'=>$data));
	 }
 }
 public function edit_form($get=''){
    $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $data['approved_by']=$id['username'];
    
    $emp_row=$id['userid'];
    $table='employee_details';
    $where=array('id'=>$emp_row);
    $data['emp_details']=$this->vendor_model->get_customerdata($table,$where);
    $uri = $_SERVER["REQUEST_URI"]; 
     
           $RT  = substr($uri, strpos($uri, "/") + 13);;
		//    $get = $this->uri->segment(3);
    
   
           $data['url_val']='4';
            $data['val']='madeups_billing?prop_id=1';
            $data['ref']='year_dashboard';
    
    
            
    $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $data['approved_by']=$id['username'];
    
    //
     $id=$this->session->userdata('logged_in');
    $where=array('id'=>$id);
    $approved_id=$id['userid'];
    
    $table='employee_details';
    $where=array('id'=>$approved_id);
    $dept_id_row=$this->vendor_model->get_where_row($table,$where);
    
    $user_type_id_row=$dept_id_row->user_type_id;

//----------tiill--------------------

$m_id=unserialize($access_menu_id->menu_id);
			   
               $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);
                    //    print_r($result->reference_url);
					//    die();
                       if($result->reference_url  == $data['val'])
                       {
                               $check=$data['val'];
                       }
                       
       }
       if($check != "")
       {
            //
            $access_menu_id=$this->access_details_id();

$m_id=unserialize($access_menu_id->menu_id);
               $data1=array();
               foreach($m_id as $menu_id)
               {
                   $table='access_action_rights';
                    $where=array('menu_id'=>$menu_id,'department_id'=>$user_type_id_row);
                    $arr=$this->vendor_model->get_where_row($table,$where);
                    if(empty($arr))
                    {
                        
                    }
                    else
                    {	//print_r($arr); 
                        $menu_id=$arr->menu_id;
                        $table='swansilk_menu';
                        $where=array('menu_id'=>$menu_id);
                        $url=$this->vendor_model->get_where_row($table,$where);
                        if(!empty($url->reference_url)){
                            
                            if($url->reference_url == $data['val']) 
                            {
                                $data['access_row']=$arr;
                            } 
                            
                        }
                    }
               }
            //----------tiill--------------------
            
                 $data['getalldata'] = $this->marketing_model->display_transaction_data();
            //echo '<pre>';print_R($data['getalldata']);exit;
            $data['userdetails'] = $this->session_data_pass();
            $data['user_type_id'] = $this->access_id();
            $data['total_indent_notifications'] = 0; //  $this->indent_page_notifications();notifications'];
                        
            $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'];
            $data['usertype']=$id['usertype'];
			$dd='DTL';
			$data['result']=array();
            $pmid = $this->madeups_model->fetch_madeups_planned_id($get);
			// print_r($pmid);
			foreach($pmid as $val1){
				foreach($val1 as $val){
				$where2=array('ref_id'=>$val);
				$table2='madeups_billing';
				$mad=$this->madeups_model->get_data($table2,$where2);
				array_push($data['result'],$mad);
			}}
            //echo  $this->madeups_model->list_details($get,$dd);
           // die();
            //$data['designation'] = $id['designation'];
            
            $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['access'] = $this->access_details();
            // print_r($data);
            // die();
            $this->load->view('templates/header_inside',$data);
            $this->load->view('debit_note/edit_suborder_madeups', $data);
            $this->load->view('templates/footer_inside');
        }
        else
        {  
            $this->session->sess_destroy();
            redirect(base_url());
        }
    }
    public function delete_planned_data(){
        $id=$this->input->post('id');
        $table="madeups_billing";
        $where=array('id'=>$id);
        $fdata=$this->madeups_model->delete_row_data($table,$where);
        
        echo json_encode($fdata);
    	
    }
    public function delete_planned_data_all(){
        $ids = array();
        $id = $this->input->post('id');
        $ids = explode("w",$id);
       
        for($i = 0; $i < count($ids); $i++){
            $table="madeups_billing";
            $where=array('id'=>$ids[$i]);
            $fdata = $this->madeups_model->delete_row_data($table,$where);
        }
        echo json_encode($fdata);
    }
}