000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use App\LocalUserMapping;
use App\SparePartsMaster;
use App\TrcStock;
use App\HistoryTrcStock;
use App\SparePartsInStock;
use App\StockInCircleStore;
use App\WarehouseInventory;
use App\HistoryOfStockInCircleStore;
use DB;
use Maatwebsite\Excel\Facades\Excel;

use App\Exports\TestControllerExport;

class TestController extends Controller
{

public $data; 
    public function get_common(){
    	if(Auth::check()){
    		$user = Auth::user();
    		$this->data['userInfo'] = LocalUserMapping::where('LoginID',$user->loginId)->first();
    	}
    }

public function addSpareMaster() {     
        dd('stop');   
        $row = 1;
        if(($handle = fopen("ssparee_poarts_masters_2023_09_06.csv", "r")) !== FALSE) {
            while (($data = fgetcsv($handle, 2500, ",")) !== FALSE) {            
                if($row > 1) {

if($data[2] !='' && isset($data[2])) {
                        // $spare = new SparePartsMaster();
                        // $spare->hsn = $data[1];
                        // $spare->code = $data[2];
                        // $spare->name = $data[3];
                        // $spare->description = $data[4];
                        // $spare->uom = $data[5];
                        // $spare->type = $data[6];
                        // $spare->rate = $data[7];
                        // $spare->repaired_rate = $data[8];
                        // $spare->gst_slab_rates = $data[9];
                        // $spare->category = $data[10];
                        // $spare->product_type = $data[11];
                        // $spare->save();                     
                    }                    
                }

$row++;
            }
        }
        echo "total rows are : ".$row;
    }

public function update_warehouse_data() {
        dd('stopupdate_warehouse_duplicate');    
        $row = 1;
        if(($handle = fopen("warehouse_data_2023_2308_223923.csv", "r")) !== FALSE) {

while (($data = fgetcsv($handle, 2500, ",")) !== FALSE) {
 
 
 if($row > 1){ 
 // print_r($data);
 // exit;
 if($data[1] != '' && $data[3] != '') {
 // $stock = new StockInCircleStore();
 // $stock->warehouse = $data[1];
 // $stock->spare_code = $data[3]; 
 // $stock->fresh_qty = $data[4];
 // $stock->rate = $data[5];
 // $stock->user_id = \Auth::user()->id;
 // $stock->save(); 
 
 // $inventory = new WarehouseInventory();
 // $inventory->warehouse = $data[1];
 // $inventory->item_type = strtolower($data[2]);
 // $inventory->entry_type = $data[1];
 // $inventory->spare_code = $data[3];
 // $inventory->in_qty = $data[4];
 // $inventory->available_qty = $data[4];
 // $inventory->rate = $data[5];
 // $inventory->lot_no = 'OPENING/GRN/'.$data[1];
 // $inventory->save();
 } 
 } 
 // if($row > 1882 && $row < 1890) {
 // print_r($data);
 // }
 $row++; 
 } 
 } 
 }

public function update_warehouse_inventory() {
        $row = 1;
        dd('stop');
        if (($handle = fopen("Warehouse_Inventory_OM.csv", "r")) !== FALSE) {
            
            $notFoundArr = array();
            while (($data = fgetcsv($handle, 11000, ",")) !== FALSE) {
                if($row > 1){                                    
                    $warehouse_spare = \DB::table('warehouse_inventory')->where('spare_code', $data[2])->where('warehouse', $data[0])->where('item_type', strtolower($data[1]))->first();
                    
                    if(is_null($warehouse_spare)) {
                        // $res = \DB::table('warehouse_inventory')->where('spare_code', $data[2])->where('warehouse', $data[0])->where('item_type', strtolower($data[1]))->update(['available_qty'=>$data[3]]);
                        // echo  $res;
                        // exit;                      
                        array_push($notFoundArr, $data);
                    }                                           
                }                               
                
                $row++;            
            }

return Excel::download(new TestControllerExport($notFoundArr), 'warehouse_inventory.xlsx');

echo "not found array ";                
            print_r($notFoundArr);
            echo "row are : ".$row;
        }
    }

public function update_stock_in_circle_store() {
        $row = 0;
        dd('stop');
        if (($handle = fopen("Stock_in_Circle_Stores_OM.csv", "r")) !== FALSE) {
            
            $notFoundArr = array();
            while (($data = fgetcsv($handle, 11000, ",")) !== FALSE) {
                if($row > 0){                   
                  
                    $warehouse_spare = \DB::table('stock_in_circle_stores')->where('spare_code', $data[1])->where('warehouse', $data[0])->first();                    
                    // dd($data);
                    // dd('stop');
                    if(is_null($warehouse_spare)) {
                        // $res = \DB::table('stock_in_circle_stores')->where('spare_code', $data[1])->where('warehouse', $data[0])->update(['fresh_qty'=>$data[2], 'faulty_qty'=>$data[3], 'repaired_qty'=>$data[4]]);
                        // echo  $res;
                        // exit;                      
                        array_push($notFoundArr, $data);

} 
                    // else {
                    //     array_push($notFoundArr, $row);
                    // }                           
                }
                // print_r($data);
                // exit;                
                
                $row++;            
            }

return Excel::download(new TestControllerExport($notFoundArr), 'stock_in_circle_store_not_found.xlsx');

echo "not found array ";                
            print_r($notFoundArr);
            echo "row are : ".$row;
        }
    }

public function update_spare_parts_master() {       
        $row = 0;
        if (($handle = fopen("Spare_Pardfdft_Master.csv", "r")) !== FALSE) {
            
            // while (($data = fgetcsv($handle, 11000, ",")) !== FALSE) {
                               
            //     if($row > 0){

//         // $res = \DB::table('spare_parts_masters')->where('code', $data[2])->update(['type' => $data[6], 'rate'=>$data[7], 'repaired_rate'=>$data[8], 'category'=>$data[10], 'product_type'=>$data[11]]);                    
            //         // echo "hello";
            //         // echo "res".$res;
            //         // exit;
            //     }
            //     // print_r($data);
            //     // exit;                
                
            //     $row++;            
            // }
            echo "row are : ".$row;
        }
    }

public function update_localuser_mapping() {       
        $row = 0;
        if (($handle = fopen("local_usedfr_mapping_update_user_type.csv", "r")) !== FALSE) {
            
            while (($data = fgetcsv($handle, 11000, ",")) !== FALSE) {
               
                
                // if($row > 1){
                //     // var_dump($data[5]);
                //     if($data[5] != 'NULL') {
                        
                //         \DB::table('local_user_mapping')->where('StaffCode', $data[3])->update(['UserType' => $data[5]]); 
                //         // $row++;                                  
                //     }                   
                // // print_r($data);
                // // exit;
                // }
                
                $row++;            
            }
            echo "row are : ".$row;
        }
    }

public function update_delivery_transactions() {       
        $row = 0;
        if (($handle = fopen("delivery_transactions_update.csv", "r")) !== FALSE) {
            
            while (($data = fgetcsv($handle, 11000, ",")) !== FALSE) {
               
                
                if($row > 0){
                //    \DB::table('delivery_transactions')->where('type', 2)->where('id', $data[0])->update(['site_product' => $data[13]]);
                // print_r($data);
                // exit;
                }
                
                $row++;            
            }
            echo "row are : ".$row;
        }
    }

public function update_engineer_inventory() {       
        $row = 0;
        if (($handle = fopen("engineer_spare_parts_update.csv", "r")) !== FALSE) {
            
            while (($data = fgetcsv($handle, 11000, ",")) !== FALSE) {
               
                
                if($row > 0){
                //    \DB::table('engineer_spare_parts')->where('id', $data[0])->update(['site_product' => $data[9]]);
                // print_r($data);
                // exit;
                }
                
                $row++;            
            }
            echo "row are : ".$row;
        }
    }

public function updateSiteMaster(){
        echo "inside update site master";
        dd('stop');
       $row = 1;
       $notInsertedArr = array();
     
       if (($handle = fopen("site_master_da.csv", "r")) !== FALSE) {
           while (($data = fgetcsv($handle, 15000, ",")) !== FALSE) {                
               if($row > 1){                             
                   DB::table('sitedf_master')->insert(
                    [
                        'Circle' => $data[0],
                        'Site_id' => $data[1],
                        'WH_code' => $data[45],
                        'WH_location' => $data[46],
                        'Site_Name' => $data[4],
                        'Site_Address' => $data[5],
                        'Eng_code' => $data[6],
                        'Contact_no' => $data[7],
                        'eng_name' => $data[8],
                        'SEM_AMC' => $data[9],
                        'product' => $data[10],
                        'ProductGroup' => $data[11],
                        'ModifyDate' => $data[12],
                        'Customer' => $data[14],
                        'District' => $data[15],
                        'Cluster' => $data[16],
                        'CluserLeadCode' => $data[17],
                        'ClusterLeadName' => '',
                        'ClusterLeadCantact' => '',
                        'ClusterLeadEmail' => $data[20],
                        'OMECompanyName' => $data[21],
                        'OMETechName' => $data[22],
                        'OMETechContact' => $data[23],
                        'ServiceCordName' => $data[24],
                        'ServiceCordConact' => $data[25],
                        'ServiceCordEmail' => $data[26],
                        'ServiceManagerName' => $data[27],
                        'ServiceManagerContact' => $data[28],
                        'ServiceManagerEmail' => $data[29],
                        'PNSManagerName' => $data[30],
                        'PNSManagerContact' => $data[31],
                        'PNSManagerEmail' => $data[32],
                        'COHName' => '',
                        'NServiceHeadName' => $data[32],
                        'NServiceHeadContact' => $data[33],
                        'NServiceHeadEmail' => $data[34],
                        'MISCoordName' => $data[37],
                        'MISCoordContact' => $data[38],
                        'MISCoordEmail' => $data[39],
                        'ERPCoordName' => $data[40],
                        'ERPCoordContact' => $data[41],
                        'ERPCoordEmail' => $data[41],
                        'StoreCoordName' => $data[42],                        
                        'StoreCoordContact' => $data[43],                        
                        'StoreCoordEmail' => $data[44],                        
                        'CustomerSiteId' => '',                        
                        'ProductCount' => ''                      
                    ]
                   );   
               
               }                           
            
              $row++;               
           }
           // echo "Not iserted id is ";
        //    print_r($notInsertedArr);
           echo "row is :".$row;
       }
   }

public function correct_delivery_challan() {
        echo "inside correct delivery challan page ";
        // dd('stop');
        // array('INDIMEAMD', 'INDIMEAMR', 'INDIMEASR', 'INDIMEBAT', 'INDIMEBAY', 'INDIMEFZP', 'INDIMEHSP', 'INDIMEPTL');
        $warehouse = '';
        $series = '';

$delivery_data = DB::table('delivery_transactions')->select(DB::raw('count(warehouse) as warehouse'),  'id', 'delivery_challan_no', 'warehouse', 'session', 'series')->where(DB::raw('date(created_at)'), '>=', '2022-04-01')->where('session', '2122')->where('warehouse', $warehouse)->orderBy('id', 'asc')->get();

dd($delivery_data);

if(!$delivery_data->isEmpty()) {
            dd($delivery_data);
        }

}

public function updateDeliveryTransactioerwn() {
        // dd('stop');
        
        $warehouse = 'INDIMEPTL';
        $series = '1';
        $session = '2223';
        
        $delivery_transaction = DB::table('delivery_transactions')->where(DB::raw('date(created_at)'), '>=', '2022-04-01')->where('session', '2122')->where('warehouse', $warehouse)->orderBy('id', 'asc')->get();
        
        // print_r($delivery_transaction);
        
        foreach($delivery_transaction as $key=>$dev_tr) {
            $challan_no = $dev_tr->delivery_challan_no;
            $challanArr = explode('/', $challan_no);
            // print_r($challanArr);
            // $challanArr[2] = $series;
            $challanArr[3] = $session;
            // print_r($challanArr);
            $challan = implode('/', $challanArr);
            
            DB::table('delivery_transactions')->where('id', $dev_tr->id)->update(array('delivery_challan_no'=>$challan, 'session'=>$session));
            // $series++;
        }
    }

public function updateDeliveryTransaction1() {
        $warehouse = 'SERASM';
        $series = '1';
        $session = '2223';
        
        $delivery_transaction = DB::table('delivery_transactions')->where(DB::raw('date(created_at)'), '>=', '2022-04-01')->where('session', '2122')->where('warehouse', $warehouse)->orderBy('id', 'asc')->get();
        
        $data = DB::select("SELECT * FROM `delivery_transactions` WHERE `warehouse` LIKE '".$warehouse."' AND session = '2223' ORDER BY `id` DESC LIMIT 1");
        
        if(count($data) > 0){
            echo "series is :".$series = $data[0]->series + 1;                
        }
        
        foreach($delivery_transaction as $key=>$dev_tr) {
            $challan_no = $dev_tr->delivery_challan_no;
            $challanArr = explode('/', $challan_no);
            $challanArr[2] = $series;
            $challanArr[3] = $session;
            $challan = implode('/', $challanArr);
            
            DB::table('delivery_transactions')->where('id', $dev_tr->id)->update(array('delivery_challan_no'=>$challan, 'session'=>$session, 'series'=>$series));
            $series++;
        }
    }

public function copyy_delivery_challan() {
        $delivery_transaction = DB::table('delivery_transactions')->where(DB::raw('date(created_at)'), '>=', '2022-04-01')->where('session', '2122')->get();
        
        foreach($delivery_transaction as $key=>$del_trans) {
            DB::table('delivery_transactions')->where('id', $del_trans->id)->update(array('delivery_challan_no_old'=>$del_trans->delivery_challan_no));
        }
    }

public function upload_spare_master() {
        echo "insdie upload_spare_master";
        $row = 0;
        // dd('stop');
        if (($handle = fopen("spare_masdsdsster_new.csv", "r")) !== FALSE) {
           
            $arr = array();
            while (($data = fgetcsv($handle, 3000, ",")) !== FALSE) {                
                if($row > 0){
                    $spare_master = new SparePartsMaster();
                    $spare_master->code  = $data[2];
                    $spare_master->name  = $data[3];
                    $spare_master->description  = $data[4];
                    $spare_master->uom  = $data[5];
                    $spare_master->type  = $data[6];
                    $spare_master->rate  = $data[7];
                    $spare_master->gst_slab_rates  = $data[9];
                    $spare_master->category  = $data[10];
                    $spare_master->product_type  = $data[11];
                    $spare_master->save();
                    if($spare_master->save()) {
                       echo $data[0];
                    } else {
                        array_push($arr, $data[2]);
                    }

} 
                
                // if($row == 1) 
                // {
                //     dd('stop');
                // }
                
                $row++;
            }
            print_r($arr);
            echo "row are : ".$row;
        } 
    }

public function upload_circle_store_data() {
        dd('stop');
        $row = 0;
        if (($handle = fopen("new_circle_daaaata.csv", "r")) !== FALSE) {
            
            while (($data = fgetcsv($handle, 3000, ",")) !== FALSE) {
                dd('stop');
                if($row > 0){
                    // print_r($data);
                    // dd('stop');
                    $StockInCircleStore = new \App\StockInCircleStore();
                    $StockInCircleStore->warehouse = $data[1];
                    $StockInCircleStore->spare_code = $data[4];
                    $StockInCircleStore->user_id = 57;
                    $StockInCircleStore->fresh_qty = $data[5];
                    // $StockInCircleStore->faulty_qty = $data[6];
                    // $StockInCircleStore->repaired_qty = $data[7];
                    $StockInCircleStore->rate = $data[8];
                    $StockInCircleStore->save();

$warehouseInventory = new \App\WarehouseInventory();
                    $warehouseInventory->warehouse = $data[1];
                    $warehouseInventory->item_type = 'fresh';
                    $warehouseInventory->entry_type = 'opening_stock';
                    $warehouseInventory->spare_code = $data[4];
                    $warehouseInventory->in_qty = $data[5];
                    $warehouseInventory->available_qty = $data[5];
                    $warehouseInventory->rate = $data[8];
                    $warehouseInventory->lot_no = 'OPENING/'.$data[1];
                    $warehouseInventory->save();

//     echo "this is upload ";
                //    dd('stop');
                }
                
                $row++;
                // print_r($data);
                // if($row == 2) {
                //     dd('stop');
                // }
            }
            echo "row are : ".$row;
        }
    }

public function correct_stn() {
        dd('stop');
        $sql = "select * from stock_transfer_notes where date(created_at) > '2022-03-31' and from_warehouse = 'SERPNT' order by id ";
        $data = DB::select($sql);

$a = array();
        $i = 1;
        foreach ($data as $key => $value) {

echo $i." ".$value->stn_no." ==>";
 list($a[0], $a[1], $a[2], $a[3]) = explode('/', $value->stn_no);
 $a[2] = $i;
 echo implode('/', $a)." ";

$sql1 = DB::table('stock_transfer_notes')
                    ->where('id', $value->id)
                    ->update(['series' => $i, 'session'=>2223, 'stn_no'=> implode('/', $a)]);

$sql3 = "select * from stock_transfer_receipts where stn_no like '$value->stn_no' ";

// dd($sql3);
            $data3 = DB::select($sql3);
            if(count($data3) > 0 ) {
                DB::table('stock_transfer_receipts')->where('stn_no', 'like', $value->id)->update(['stn_no'=>implode('/', $a)]);
                echo "inside str";
            }
            
            // dd($data3);

$i++;
        }

// dd($data);

}

public function correct_sto() {
        $sql = "select * from stock_transfer_orders where date(created_at) > '2022-03-31' order by id ";
        $data = DB::select($sql);

// dd($data);

$a = [];
 $i = 1;
 foreach ($data as $key => $value) {
 echo $value->sto_number." ==>";
 list($a[0], $a[1], $a[2], $a[3]) = explode('/', $value->sto_number);
 $a[2] = '00'.$i;
 echo implode('/',$a)." ";

$sql1 = DB::table('stock_transfer_orders')
                    ->where('id', $value->id)
                    ->update(['series' => '00'.$i, 'session'=>2223, 'sto_number'=> implode('/', $a)]);

$i++;
        }
       
    }

public function correct_indent() {
 
 $sql = "select * from indents where business_type = 'Service' and date(created_at) > '2022-03-31' and ware_house = 'SERWBL' order by id ";
 $data = DB::select($sql);
 //dd($data);
 $a = array();
 
 $i = 1;
 foreach($data as $key=>$value) {
 // echo "indent no :".$value->indent_no;
 
 list($a[0], $a[1], $a[2], $a[3], $a[4]) = explode('/', $value->indent_no);
 
 $a[3] = '00'.$i;
 echo implode('/', $a)." ";
 
 $sql1 = DB::table('indents')
 ->where('id', $value->id)
 ->update(['series' => '00'.$i, 'session'=>2223, 'indent_no'=> implode('/', $a)]);
 
 $data1 = DB::table('stock_transfer_orders')->where('indent_id', $value->id)->get();
 
 if(count($data1) > 0) {
 $data3 = DB::table('stock_transfer_orders')->where('indent_id', $value->id)->update(['indent_no'=>implode('/', $a)]);
 
 
 }
 
 
 
 
 // echo "customer no :".$value->customer_name;
 $i++;
 }
 
 //$data = DB::table('indents')->where('business_type', 'PT')->where(DB::raw('date(created_at)', '>', '2022-03-31'))->orderBy('id')->get();
 // dd($data);
 
 }

public function correct_series() {

$sql = "SELECT * FROM `omc_requests` WHERE date(created_at) > '2022-03-31' and warehouse = 'SERWBL' ORDER BY id asc";

$data = DB::select($sql);
 // dd($data);
 $i = 1;
 foreach ($data as $key => $value) {
 //echo $key." ";
 $a = array();
 //echo $value->series." ";
 list($a[0], $a[1], $a[2], $a[3]) = explode('/', $value->mr_no);
 //print_r($a);
 $a[2] = '00'.$i;
 // implode('/', $a);
 $var = implode('/', $a);
 echo $value->id." ".$value->mr_no." ";
 //dd('stop');
 $affected = DB::table('omc_requests')
 ->where('id', $value->id)
 ->update(['mr_no' => $var, 'series'=>$i, 'session'=>2223]);
 echo "$value->id ";
 echo $value->id." ".$value->mr_no." ";
 // exit;
 $i++;
 }
 dd($data);

dd('stop');
    }

public function revert_stn(){
        $stn_id = 'STN/PNT/298/2122';
        dd('stop');
        $get_stn = \App\StockTransferNote::where('stn_no',$stn_id)->first();
    
        if($get_stn != null){
            $get_stn_items = \App\StnItem::where('stn_id',$get_stn->id)->get();
            foreach($get_stn_items as $stn_item){
                
                if($stn_item->fresh_qty != 0){
                    $StockInCircleStore = \App\StockInCircleStore::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->from_warehouse)->first();
                    $StockInCircleStore->fresh_qty = $StockInCircleStore->fresh_qty + $stn_item->fresh_qty;

$StockInCircleStore->save();

$warehouseInventory = \App\WarehouseInventory::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->from_warehouse)->where('item_type','fresh')->where('lot_no',$stn_item->lot_no)->first();
                    $warehouseInventory->available_qty = $warehouseInventory->available_qty + $stn_item->fresh_qty;
                    $warehouseInventory->save();

}

if($stn_item->repaired_qty != 0){
                     $StockInCircleStore = \App\StockInCircleStore::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->from_warehouse)->first();
                    $StockInCircleStore->repaired_qty = $StockInCircleStore->repaired_qty + $stn_item->repaired_qty;

$StockInCircleStore->save();

$warehouseInventory = \App\WarehouseInventory::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->from_warehouse)->where('item_type','repaired')->where('lot_no',$stn_item->lot_no)->first();
                    $warehouseInventory->available_qty = $warehouseInventory->available_qty + $stn_item->repaired_qty;
                    $warehouseInventory->save();
                }

if($stn_item->faulty_qty != 0){
                     $StockInCircleStore = \App\StockInCircleStore::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->from_warehouse)->first();
                    $StockInCircleStore->faulty_qty = $StockInCircleStore->faulty_qty + $stn_item->faulty_qty;

$StockInCircleStore->save();

$warehouseInventory = \App\WarehouseInventory::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->from_warehouse)->where('item_type','faulty')->where('lot_no',$stn_item->lot_no)->first();
                    $warehouseInventory->available_qty = $warehouseInventory->available_qty + $stn_item->faulty_qty;
                    $warehouseInventory->save();
                }
                $stn_item->delete();
            }

$get_stn->delete();

echo 'STN deleted Successfully';
        }
        
    }

public function revert_str(){
        $str_id = 'STR/PNT/95/2122';
        dd('stop');
        $str = \App\StockTransferReceipt::where('str_no',$str_id)->first();
        if($str != null){

$get_stn = \App\StockTransferNote::where('stn_no',$str->stn_no)->first();

if($get_stn != null){

$get_stn_items = \App\StnItem::where('stn_id',$get_stn->id)->get();

foreach($get_stn_items as $stn_item){
                    
                    if($stn_item->fresh_qty != 0){
                        $StockInCircleStore = \App\StockInCircleStore::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->to_warehouse)->first();
                        $StockInCircleStore->fresh_qty = $StockInCircleStore->fresh_qty - $stn_item->fresh_qty;

$StockInCircleStore->save();

}

if($stn_item->repaired_qty != 0){
                         $StockInCircleStore = \App\StockInCircleStore::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->to_warehouse)->first();
                        $StockInCircleStore->repaired_qty = $StockInCircleStore->repaired_qty - $stn_item->repaired_qty;

$StockInCircleStore->save();

$warehouseInventory = \App\WarehouseInventory::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->to_warehouse)->where('item_type','repaired')->where('lot_no',$stn_item->lot_no)->first();
                        $warehouseInventory->available_qty = $warehouseInventory->available_qty - $stn_item->repaired_qty;
                        $warehouseInventory->save();
                    }

if($stn_item->faulty_qty != 0){
                         $StockInCircleStore = \App\StockInCircleStore::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->to_warehouse)->first();
                        $StockInCircleStore->faulty_qty = $StockInCircleStore->faulty_qty - $stn_item->faulty_qty;

$StockInCircleStore->save();

$warehouseInventory = \App\WarehouseInventory::where('spare_code',$stn_item->spare_code)->where('warehouse',$get_stn->to_warehouse)->where('item_type','faulty')->where('lot_no',$stn_item->lot_no)->first();
                        $warehouseInventory->available_qty = $warehouseInventory->available_qty - $stn_item->faulty_qty;
                        $warehouseInventory->save();
                    }
                    
                }
                
            }
            $str->delete();
            echo 'STN deleted Successfully';
        }
    }

public function eng_check(){
        dd('stop');
		$this->get_common();
        $loginId = Auth::user()->loginId;
        $warehouses = DB::table('local_user_mapping')
             ->select('local_user_mapping.fieldUserCodes')
             ->where('StoreCoordinatorCircleCodes', $loginId)
             ->groupBy('fieldUserCodes')
             ->get();
        $current_warehouse = $warehouses[0]->fieldUserCodes;
        $engineers = LocalUserMapping::where('role','field_user')->where('StoreCoordinatorCircleCodes',$loginId)->where('fieldUserCodes',$current_warehouse)->get();

foreach ($engineers as $key => $value) {
 	echo $value->LoginID.' ';
 	DB::table('engineer_inventory')->where('engineer_id',$value->LoginID)->delete();
 	DB::table('engineer_spare_parts')->where('engineer_id',$value->LoginID)->delete();
 }
	}

public function upload(){
     dd('stop');
        $row = 1;
        $notInsertedArr = array();

if (($handle = fopen("INDIMEPTLll2323.csv", "r")) !== FALSE) {
            while (($data = fgetcsv($handle, 1700, ",")) !== FALSE) {                
                if($row > 1){
                    // print_r($data); 
                    // dd('stop'); 
                    // $user = DB::table('site_master')->find($data[0]);                        
                    // if($user) {
                    //     DB::table("site_master")->where('id', $data[0])->update(array("WH_code"=>$data[3], 'WH_location'=>$data[4]));         
                    // } else {
                    //     array_push($notInsertedArr, $data[0]);            
                    // }                                                 
                }                           
             
               $row++;               
            }
            // echo "Not iserted id is ";
            print_r($notInsertedArr);
            echo "row is :".$row;
        }
    }

public function uploadSpareMasterDate(){
        dd('stop');
           $row = 1;
           $notInsertedArr = array();
   
           if (($handle = fopen("Sdataaaa.csv", "r")) !== FALSE) {
               while (($data = fgetcsv($handle, 2000, ",")) !== FALSE) {                
                   if($row > 3){
                       //print_r($data); 
                    //    dd('stop'); 
                    //    $spare = DB::table('spare_parts_masters')->where('code', $data[2])->first();                        
                    //    if(is_null($spare)) {
                    //        DB::table("spare_parts_masters")->insert(
                    //         array(
                    //             'code' => $data[2],
                    //             'name' => $data[3],
                    //             'description' => $data[4],
                    //             'uom' => strtoupper($data[5]),
                    //             'type' => $data[6],
                    //             'rate' => $data[7],
                    //             'gst_slab_rates' => $data[9],
                    //             'category' => $data[10],
                    //             'repaired_rate' => 0.00
                    //         ));   
                    //         // dd('stop');      
                    //    } else {
                    //        array_push($notInsertedArr, $data[2]);            
                    //    }                                                 
                       //print_r($notInsertedArr);
                    //    dd('stop');
                   }                           
                   
                  $row++;               
               }
               // echo "Not iserted id is ";
               print_r($notInsertedArr);
               echo "row is :".$row;
           }
       }

public function asset_data_upload(){
     dd('stop');
        $row = 1;
        if (($handle = fopen("mpd.csv", "r")) !== FALSE) {
            while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                $num = count($data);
                if($row > 1){
                   
                    $warehouse = 'SER'.$data[1];
                    $code = $data[0];
                    $type = $data[3];
                    $qty = $data[6];
                    $rate = $data[7];
                    $entry_of = $data[2];

//  dd($data);

if($data[3] == 'FRESH'){

\DB::table('warehouse_inventory')->insertGetId([
                        'warehouse' => $warehouse,
                        'item_type' => 'fresh',
                        'entry_type' => $entry_of,
                        'spare_code' => $code,
                        'in_qty' =>$qty,
                        'available_qty' => $qty,
                        'rate' =>  $rate,
                        'lot_no' => 'OPENING/GRN/'.$data[1]
                        ]);

$asset = \DB::table('stock_in_circle_stores')->where('warehouse',$warehouse)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('stock_in_circle_stores')->where('warehouse',$warehouse)->where('spare_code',$code)
                            ->update([
                                'fresh_qty' => ($asset->fresh_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('stock_in_circle_stores')->insertGetId([
                            'warehouse' => $warehouse,
                            'user_id' => 21,
                            'spare_code' => $code,
                            'fresh_qty' =>$qty
                            ]);
                        }

}elseif($data[3] == 'TRC'){

\DB::table('warehouse_inventory')->insertGetId([
                        'warehouse' => $warehouse,
                        'item_type' => 'repaired',
                        'entry_type' => $entry_of,
                        'spare_code' => $code,
                        'in_qty' =>$qty,
                        'available_qty' => $qty,
                        'rate' =>  $rate,
                        'lot_no' => 'OPENING/GRN/'.$data[1]
                        ]);

$asset = \DB::table('stock_in_circle_stores')->where('warehouse',$warehouse)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('stock_in_circle_stores')->where('warehouse',$warehouse)->where('spare_code',$code)
                            ->update([
                                'repaired_qty' => ($asset->repaired_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('stock_in_circle_stores')->insertGetId([
                            'warehouse' => $warehouse,
                            'user_id' => 21,
                            'spare_code' => $code,
                            'repaired_qty' =>$qty
                            ]);
                        }

}elseif($data[3] == 'FAULTY'){

\DB::table('warehouse_inventory')->insertGetId([
                        'warehouse' => $warehouse,
                        'item_type' => 'faulty',
                        'entry_type' => $entry_of,
                        'spare_code' => $code,
                        'in_qty' =>$qty,
                        'available_qty' => $qty,
                        'rate' =>  $rate,
                        'lot_no' => 'OPENING/GRN/'.$data[1]
                        ]);

$asset = \DB::table('stock_in_circle_stores')->where('warehouse',$warehouse)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('stock_in_circle_stores')->where('warehouse',$warehouse)->where('spare_code',$code)
                            ->update([
                                'faulty_qty' => ($asset->faulty_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('stock_in_circle_stores')->insertGetId([
                            'warehouse' => $warehouse,
                            'user_id' => 21,
                            'spare_code' => $code,
                            'faulty_qty' =>$qty
                            ]);
                        }

}elseif($data[3] == 'PT'){

if($data[5] == 'FRESH'){

\DB::table('pt_inventory')->insertGetId([
                            'warehouse' => $warehouse,
                            'item_type' => 'fresh',
                            'entry_type' => 'open',
                            'spare_code' => $code,
                            'in_qty' =>$qty,
                            'available_qty' => $qty,
                            'rate' =>  $rate,
                            'lot_no' => 'OPENING/GRN/'.$data[1]
                            ]);

$asset = \DB::table('pt_stocks')->where('warehouse',$warehouse)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('pt_stocks')->where('warehouse',$warehouse)->where('spare_code',$code)
                            ->update([
                                'fresh_qty' => ($asset->fresh_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('pt_stocks')->insertGetId([
                            'warehouse' => $warehouse,
                            'spare_code' => $code,
                            'fresh_qty' =>$qty
                            ]);
                        }

}elseif($data[5] == 'REPAIRED'){

\DB::table('pt_inventory')->insertGetId([
                            'warehouse' => $warehouse,
                            'item_type' => 'repaired',
                            'entry_type' => $entry_of,
                            'spare_code' => $code,
                            'in_qty' =>$qty,
                            'available_qty' => $qty,
                            'rate' =>  $rate,
                            'lot_no' => 'OPENING/GRN/'.$data[1]
                            ]);

$asset = \DB::table('pt_stocks')->where('warehouse',$warehouse)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('pt_stocks')->where('warehouse',$warehouse)->where('spare_code',$code)
                            ->update([
                                'repaired_qty' => ($asset->repaired_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('pt_stocks')->insertGetId([
                            'warehouse' => $warehouse,
                            'spare_code' => $code,
                            'repaired_qty' =>$qty
                            ]);
                        }

}

}else{

$engineer_id = $data[3];

if($data[5] == 'FRESH'){

\DB::table('engineer_inventory')->insertGetId([
                            'warehouse' => $warehouse,
                            'engineer_id' => $engineer_id,
                            'item_type' => 'fresh',
                            'entry_type' => 'open',
                            'spare_code' => $code,
                            'in_qty' =>$qty,
                            'available_qty' => $qty,
                            'rate' =>  $rate,
                            'lot_no' => 'OPENING/GRN/'.$data[1]
                            ]);

$asset = \DB::table('engineer_spare_parts')->where('engineer_id',$engineer_id)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('engineer_spare_parts')->where('engineer_id',$engineer_id)->where('spare_code',$code)
                            ->update([
                                'fresh_qty' => ($asset->fresh_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('engineer_spare_parts')->insertGetId([
                            'warehouse' => $warehouse,
                            'engineer_id' => $engineer_id,
                            'spare_code' => $code,
                            'fresh_qty' =>$qty
                            ]);
                        }

}elseif($data[5] == 'REPAIRED'){

\DB::table('engineer_inventory')->insertGetId([
                                'warehouse' => $warehouse,
                            'engineer_id' => $engineer_id,
                            'item_type' => 'repaired',
                            'entry_type' => 'open',
                            'spare_code' => $code,
                            'in_qty' =>$qty,
                            'available_qty' => $qty,
                            'rate' =>  $rate,
                            'lot_no' => 'OPENING/GRN/'.$data[1]
                            ]);

$asset = \DB::table('engineer_spare_parts')->where('engineer_id',$engineer_id)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('engineer_spare_parts')->where('engineer_id',$engineer_id)->where('spare_code',$code)
                            ->update([
                                'repaired_qty' => ($asset->repaired_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('engineer_spare_parts')->insertGetId([
                            'warehouse' => $warehouse,
                            'engineer_id' => $engineer_id,
                            'spare_code' => $code,
                            'repaired_qty' =>$qty
                            ]);
                        }

}elseif($data[5] == 'FAULTY'){
                            \DB::table('engineer_inventory')->insertGetId([
                                'warehouse' => $warehouse,
                            'engineer_id' => $engineer_id,
                            'item_type' => 'faulty',
                            'entry_type' => 'open',
                            'spare_code' => $code,
                            'in_qty' =>$qty,
                            'available_qty' => $qty,
                            'rate' =>  $rate,
                            'lot_no' => 'OPENING/GRN/'.$data[1]
                            ]);

$asset = \DB::table('engineer_spare_parts')->where('engineer_id',$engineer_id)->where('spare_code',$code)->first();
                        if($asset != null) {
                            \DB::table('engineer_spare_parts')->where('engineer_id',$engineer_id)->where('spare_code',$code)
                            ->update([
                                'faulty_qty' => ($asset->faulty_qty + $qty)
                            ]);
                           
                        }else{

\DB::table('engineer_spare_parts')->insertGetId([
                            'warehouse' => $warehouse,
                            'engineer_id' => $engineer_id,
                            'spare_code' => $code,
                            'faulty_qty' =>$qty
                            ]);
                        }

}
                    }

}
                $row++;
            }
        }

}
    
    //item code & lot no base update  item rate.
    public function rate_correction(){
        dd("stop");
        $row = 1;
       if (($handle = fopen("avantika.csv", "r")) !== FALSE) {
           while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
               $num = count($data);
               if($row > 1){
                
                   $item_code = $data[0];
                   $lot_no = $data[3];
               
                   
                   $WarehouseInventories = \App\WarehouseInventory::where('spare_code',$item_code)->where('lot_no',$lot_no)->get();
               
                   foreach($WarehouseInventories as $wi){
                        $WarehouseInventory = \App\WarehouseInventory::find($wi->id);
                       if($WarehouseInventory->item_type == 'faulty'){
                           $WarehouseInventory->rate = $data[4];
                       }
                       if($WarehouseInventory->item_type == 'repaired'){
                           $WarehouseInventory->rate = $data[5];
                       }
                       if($WarehouseInventory->item_type == 'fresh'){
                           $WarehouseInventory->rate = $data[6];
                       }

$WarehouseInventory->save();

}

$engineerInventories = \App\EngineerInventory::where('spare_code',$item_code)->where('lot_no',$lot_no)->get();
              
                   foreach($engineerInventories as $ei){
                       $engineerInventory = \App\EngineerInventory::find($ei->id);
                       if($engineerInventory->item_type == 'faulty'){
                           $engineerInventory->rate = $data[4];
                       }
                       if($engineerInventory->item_type == 'repaired'){
                           $engineerInventory->rate = $data[5];
                       }
                       if($engineerInventory->item_type == 'fresh'){
                           $engineerInventory->rate = $data[6];
                       }

$engineerInventory->save();
                        
                   }

$pt_inventories = \App\PtInventory::where('spare_code',$item_code)->where('lot_no',$lot_no)->get();
              
                   foreach($pt_inventories as $pi){
                       $pt_inventory = \App\PtInventory::find($pi->id);
                       if($pt_inventory->item_type == 'faulty'){
                           $pt_inventory->rate = $data[4];
                       }
                       if($pt_inventory->item_type == 'repaired'){
                           $pt_inventory->rate = $data[5];
                       }
                       if($pt_inventory->item_type == 'fresh'){
                           $pt_inventory->rate = $data[6];
                       }

$pt_inventory->save();
                        
                   }

$trc_inventories = \App\TrcInventory::where('spare_code',$item_code)->where('lot_no',$lot_no)->get();
              
                   foreach($trc_inventories as $ti){
                       $trc_inventory = \App\TrcInventory::find($ti->id);
                       if($trc_inventory->item_type == 'faulty'){
                           $trc_inventory->rate = $data[4];
                       }
                       if($trc_inventory->item_type == 'repaired'){
                           $trc_inventory->rate = $data[5];
                       }
                       if($trc_inventory->item_type == 'fresh'){
                           $trc_inventory->rate = $data[6];
                       }

$trc_inventory->save();
                        
                   }

}

$row++;
           
       }
   }
   }

}