";
        print_r($detail_value_arr);
        echo $detail_value_arr_json;
        die('stop');*/

     
        $branchIds = implode(',', $request->input('branch_id'));
        $data = [
            'price_list_name' => $request->price_list_name ?? NULL,
            'is_csd' => $request->is_csd == 'Yes'? 'Yes':'No',
            'rto_type' => implode(" ,",$request->rto_type) ?? null,
            'car_model' => $request->car_name ?? NULL,
            'fule_type' => $request->fule_type ?? NULL,
            'car_variant' => $request->veriant ?? NULL,
            'rto_custome_handling_charges' =>$request->rto_custome_handling_charges,
            'colour_type' => $request->color_tone ?? NULL,
            'branch_id' => $branchIds ?? NULL,
            'transmission' => $request->transmission ?? NULL,
            'basic' => $request->basic ?? NULL,
            'csd_selling_price' => $request->csd_selling_price ?? null,
            'ls_order_amount' =>$request->ls_order_amount ?? null,
            'outstanding_amount' => $request->outstanding_amount ?? null,
            'gst_percentage' => $request->gst_percentage ?? NULL,
            'gst_amount' => $request->gst_amount ?? NULL,
            'cess_percentage' => $request->cess_percentage ?? NULL,
            'cess_amount' => $request->cess_amount ?? NULL,
            'ex_showroom_price' => $request->ex_showroom_price ?? NULL,
            'tcs' => $request->tcs ?? NULL,
            'registration_individual_charges' => $request->registration_individual_charges ?? NULL,
            'registration_corporate_charges' => $request->registration_corporate_charges ?? NULL,
            'insurance' => $request->insurance ?? NULL,
            'fasttag' => $request->fasttag ?? NULL,
            'on_road_individual_charges' => $request->on_road_individual_charges ?? NULL,
            'on_road_corporate_charges' => $request->on_road_corporate_charges ?? NULL,
            'total_road_individual_charges' => $request->total_road_individual_charges ?? NULL,
            'total_road_corporate_charges' => $request->total_road_corporate_charges ?? NULL,
            'rsa_master' => $request->rsa_master ?? NULL,
            'other_details_1' => implode(" ,",$request->other_details_1) ?? null,
            'other_details_2' => implode(" ,",$request->other_details_2) ?? null,
            'extended_warranty' => $request->extended_warranty ?? NULL,
            'convinience_program' => $request->convinience_program ?? NULL,
            'detail_value' => $detail_value_arr_json,
            'on_road_price_individual' => $request->on_road_price_individual ?? NULL,
            'on_road_price_corporate' => $request->on_road_price_corporate ?? NULL,
            'product_id' => $request->product_id ?? NULL,
            'created_at' => date('Y-m-d H:i:s'),
            // 'statutory_charges' => $request->statutory_charges ?? NULL,
            //'accessories_kit' => implode(" ,",$request->accessories_kit) ?? null,      
        ];

        $last_id = DB::table('pricelist_master')->insertGetId($data);

        if ($last_id)
            return redirect()->route('pricelist')->with('success', 'Record inserted successfully');
        else
            return redirect()->back()->with('error', 'Failed to insert record')->withInput();
    }
    /** insert */

    /** view */
     public function view(Request $request)
    {
        $id = base64_decode($request->id);

        $categories = Category::select('id', 'name')->where(['status' => 'active'])->get();
        $branches = Branch::select('id', 'name')->where(['status' => 'active'])->get();
        $data = Inventory::where(['id' => $id])->first();

        return view('inventory.view')->with(['data' => $data, 'branches' => $branches, 'categories' => $categories]);
    }
    /** view */

    /** edit */
    public function edit(Request $request)
    {
        $id = base64_decode($request->id);

        // var_dump($id);
        
        $tone = Colortone::where(['status' => 'active'])->get();  
        $data = DB::table('pricelist_master')->where(['id' => $id])->first();
        $mcp = Mcp::where(['status' => 'active'])->get(); 

        $extanded_warranty = ExtandWarranty::select('id' , 'years' ,'amount')->where(['status' => 'active'])->get();

        $rsa = RSA::where(['status' => 'active','deleted_at' => 0])->get();
        /*$Carmodel = Product::select('car_model.name as car_name','products.id as car_id','car_varient.name as varient_name','exteriorcolor.name as exterior_color', 'interiorcolor.name as interior_color')
                   ->leftjoin('car_model', 'car_model.id', 'products.car_model')
                    ->leftjoin('car_varient', 'car_varient.id', 'products.veriant')
                    ->leftjoin('interiorcolor', 'interiorcolor.id', 'products.interior_color')
                    ->leftjoin('exteriorcolor', 'exteriorcolor.id', 'products.exterior_color')
                    ->where('products.status', '=', 'active')
                    ->get();*/

        // $fule = pricelist::select('*','fule_type.title as fule_type')
        // ->leftjoin('fule_type', 'fule_type.id', 'pricelist_master.fule_type')
        // ->where('pricelist_master.fule_type', '=', $data->fule_type)
        // ->first();

        $fule_data = Fuletype::select('*')->where('status', '=', 'active')->get();


                    // dd($data->product_id);

        $Product_data = Product::where('id',$data->product_id)->where('status', '=', 'active')->first();  

        $Carmodel_arr = Carmodel::where(['status' => 'active'])->get();  

        $accessory = Accessory::select('id' , 'name' ,'price')->where(['status' => 'active'])->get();
        $fasttag = Fasttag::select('id' , 'brand_name' ,'amount')->where(['status' => 'active'])->get();

        $Branch_data = Branch::where(['status' => 'active'])->get();  
        $car_variant = Carvarient::where(['status' => 'active','car_model' => $data->car_model,'fule_type'=>$data->fule_type])->get();  
        $transmission = Transmission::where(['status' => 'active'])->get();  

        $OtherOne = OtherOne::where(['status' => 'active'])->get();  
            
        $OtherTwo = OtherTwo::where(['status' => 'active'])->get();
        $branchIds = explode(',', $data->branch_id);
        
        $convinience_program = Mcp::where(['status' => 'active'])->get();  
        
        $rto_master = rto_master::select('rto_master.*')->where('rto_type',$data->rto_type)->first();
        
        
        return view('pricelist.edit')->with(['data' => $data,'car_variant'=>$car_variant, 'accessory' => $accessory ,'fasttag' => $fasttag,'Carmodel_arr' => $Carmodel_arr,'Branch_data' => $Branch_data, 'transmission' => $transmission, 'tone' => $tone, 'mcp' => $mcp, 'extanded_warranty' => $extanded_warranty, 'rsa' => $rsa, 'OtherOne' => $OtherOne, 'OtherTwo' => $OtherTwo, 'fule_data' => $fule_data,'branchIds' => $branchIds,'convinience_program'=>$convinience_program,'rto_master'=>$rto_master]);
    }
    /** edit */
    
    
    /** inventorystock */
    public function inventorystock(Request $request)
    {
        if ($request->ajax()) {
            $data = DB::table('inventory as i')
                
                ->select('b.name as branch',DB::raw('count(i.id) as total_stock'))
                ->join('branches as b', 'b.id', 'i.branch_id')
               
                ->groupby('b.id')
               
                ->get();

            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('action', function ($data) {
                    $return = '
';

                    // if (auth()->user()->can('inventory-view')) {
                    //     $return .=  '
                    //                                 
                    //                               ';
                    // }

                    // if (auth()->user()->can('inventory-edit')) {
                    //     if ($data->status == 'sold') {
                    //         $return .= '';
                    //     }else{
                    //         $return .= '
                    //             
                    //               ';

                    //     }
                    // }

                    // if (auth()->user()->can('inventory-delete')) {
                    //     if ($data->status == 'pdi_hold') {
                    //         $return .= '
                    //                                     
                    //                                   
                    //                                 
';

                    //         $return .= '
Active
                    //                                     
Inactive
                    //                                     
Delete
                    //                                 
';
                    //     } else if ($data->status == 'sold') {
                    //         $return .= '';
                    //     } else {
                    //         $return .= '
                    //         
                    //       
                    //     
';

                    //         if ($data->status == 'active') {
                    //             $return .= '
Assign
';
                    //         }

                    //         $return .= '
Active
                    //         
Inactive
                    //         
Delete
                    //     
';
                    //     }
                    // }

                    $return .= '
';

                    return $return;
                })
                // ->editColumn('status', function ($data) {
                //     if ($data->status == 'active') {
                //         return 'Active';
                //     } else if ($data->status == 'inactive') {
                //         return 'Inactive';
                //     } else if ($data->status == 'deleted') {
                //         return 'Deleted';
                //     } else if ($data->status == 'pdi_hold') {
                //         return 'PDI Hold';
                //     } else if ($data->status == 'sold') {
                //         return 'Sold';
                //     } else {
                //         return '-';
                //     }
                // })
                // ->rawColumns(['action', 'status'])
                ->make(true);
        }
        return view('inventory.branchstock');
    }
    /** inventorystock */

    /** update */
    public function update(Request $request)
    {
        
        // if ($request->ajax()) {
        //     return true;
        // }

        /*var_dump($request->accessories_kit);
        die('s');*/

       /* if(empty($request->accessories_kit)){
            $request->accessories_kit = [];
        }*/

        if(empty($request->detail_field)){
            $request->detail_field = [];
        }

        if(empty($request->value_field)){
            $request->value_field = [];
        }

        if(empty($request->other_details_1)){
            $request->other_details_1 = [];
        }

        if(empty($request->other_details_2)){
            $request->other_details_2 = [];
        }

        $detail_value_arr = [];
        for ($i=0; $i < count($request->detail_field); $i++) { 
           if($request->detail_field[$i] != '' && $request->value_field[$i] != ''){
                $detail_value_sub_arr = [];
                $detail_value_sub_arr['detail_field'] = $request->detail_field[$i];
                $detail_value_sub_arr['value_field'] = $request->value_field[$i]; 
                $detail_value_arr[] = $detail_value_sub_arr; 
           }           
        }

        $detail_value_arr_json = json_encode($detail_value_arr);

        $branchIds = implode(',', $request->input('branch_id'));
        $data = [
            'price_list_name' => $request->price_list_name ?? NULL,
            'is_csd' => $request->is_csd == 'Yes'? 'Yes':'No',
            'rto_type' => implode(" ,",$request->rto_type) ?? null,
            'car_model' => $request->car_name ?? NULL,
            'fule_type' => $request->fule_type ?? NULL,
            'car_variant' => $request->veriant ?? NULL,
            'rto_custome_handling_charges' =>$request->rto_custome_handling_charges,
            'colour_type' => $request->color_tone ?? NULL,
            'branch_id' => $branchIds ?? NULL,
            'transmission' => $request->transmission ?? NULL,
            'basic' => $request->basic ?? NULL,
            'csd_selling_price' => $request->csd_selling_price ?? null,
            'ls_order_amount' =>$request->ls_order_amount ?? null,
            'outstanding_amount' => $request->outstanding_amount ?? null,
            'gst_percentage' => $request->gst_percentage ?? NULL,
            'gst_amount' => $request->gst_amount ?? NULL,
            'cess_percentage' => $request->cess_percentage ?? NULL,
            'cess_amount' => $request->cess_amount ?? NULL,
            'ex_showroom_price' => $request->ex_showroom_price ?? NULL,
            'tcs' => $request->tcs ?? NULL,
            'registration_individual_charges' => $request->registration_individual_charges ?? NULL,
            'registration_corporate_charges' => $request->registration_corporate_charges ?? NULL,
            'insurance' => $request->insurance ?? NULL,
            'fasttag' => $request->fasttag ?? NULL,
            'on_road_individual_charges' => $request->on_road_individual_charges ?? NULL,
            'on_road_corporate_charges' => $request->on_road_corporate_charges ?? NULL,
            'total_road_individual_charges' => $request->total_road_individual_charges ?? NULL,
            'total_road_corporate_charges' => $request->total_road_corporate_charges ?? NULL,
            'rsa_master' => $request->rsa_master ?? NULL,
            'other_details_1' => implode(" ,",$request->other_details_1) ?? null,
            'other_details_2' => implode(" ,",$request->other_details_2) ?? null,
            'extended_warranty' => $request->extended_warranty ?? NULL,
            'convinience_program' => $request->convinience_program ?? NULL,
            'detail_value' => $detail_value_arr_json,
            'on_road_price_individual' => $request->on_road_price_individual ?? NULL,
            'on_road_price_corporate' => $request->on_road_price_corporate ?? NULL,
            'product_id' => $request->product_id ?? NULL,
            'created_at' => date('Y-m-d H:i:s'),
            // 'statutory_charges' => $request->statutory_charges ?? NULL,
            //'accessories_kit' => implode(" ,",$request->accessories_kit) ?? null,
        ];
        
        // \DB::enableQueryLog(); 
        $update = DB::table('pricelist_master')->where(['id' => $request->id])->update($data);

        /*var_dump($update);    
        die('s');*/

        // dd(\DB::getQueryLog()); 

        if ($update)
            return redirect()->route('pricelist')->with('success', 'Record updated successfully');
        else
            return redirect()->back()->with('error', 'Failed to update record')->withInput();
    }
    /** update */

    /** change-status */
    public function change_status(Request $request)
    {
        if (!$request->ajax()) {
            exit('No direct script access allowed');
        }

        $id = base64_decode($request->id);

        $data = pricelist::where(['id' => $id])->first();

        if (!empty($data)) {
            $update = pricelist::where(['id' => $id])->update(['status' => $request->status, 'updated_at' => date('Y-m-d H:i:s')]);

            if ($update)
                return response()->json(['code' => 200]);
            else
                return response()->json(['code' => 201]);
        } else {
            return response()->json(['code' => 201]);
        }
    }
    /** change-status */

      /** Import */
        public function import(Request $request){
            $import = Excel::import(new ImportPriceList(), $request->file('file'));    
            if($import){
                Excel::store(new ImportPriceList(), 'Pricelist_'.Date('YmdHis').'.xlsx' ,'excel_import');
                return redirect()->route('pricelist')->with('sucess' ,'File Imported Sucessfully');
            }
        }
    /** Import */
    
    /** Export */
        public function export(Request $request){
            $slug = $request->slug;
            $name = 'Pricelist'.Date('YmdHis').'.xlsx';
    
            try {
                return Excel::download(new ExportPriceList($slug), $name);
            }catch(\Exception $e){
                return redirect()->back()->with('error', $e->getMessage());
            }
        }
    /** Export */

    /** accept */
    public function accept(Request $request, $id = '')
    {
        if (isset($id) && $id != '' && $id != null)
            $id = base64_decode($id);
        else
            return redirect()->back()->with('error', 'Something went wrong');
        $product = Product::select('products.id')->leftjoin('inventory', 'products.name', 'inventory.name')->where(['inventory.id' => $id])->get();

        if ($product->isNotEmpty()) {
            $product = $product->toArray();
            $ids = array_map(
                function ($element) {
                    return $element['id'];
                },
                $product
            );

            $data = OBF::select('obf.id', 'obf.customer_name as name')->where(['obf.status' => 'account_accepted'])->whereIn('obf.product_id', $ids)->get();

            if ($data->isNotEmpty()) {
                return view('inventory.accept')->with(['data' => $data, 'id' => $id]);
            } else {
                return redirect()->route('inventory')->with('error', 'No Data Found In User!');
            }
        } else {
            return redirect()->route('inventory')->with('error', 'No Data Found For This Car!');
        }
    }
    /** accept */

    /** accepted */
    public function accepted(InventoryAcceptRequest $request)
    {
        if ($request->ajax()) {
            return true;
        }

        DB::beginTransaction();
        try {
            $inventory = Inventory::where(['id' => $request->id])->update(['status' => 'sold', 'updated_by' => auth()->user()->id, 'updated_at' => date('Y-m-d H:i:s')]);

            if (!$inventory)
                return redirect()->back()->with(['error' => 'something went wrong, please try later']);

            $obf = OBF::where(['id' => $request->obf_id])->update(['status' => 'completed', 'updated_by' => auth()->user()->id, 'updated_at' => date('Y-m-d H:i:s')]);

            if (!$obf)
                return redirect()->back()->with(['error' => 'something went wrong, please try later']);

            $order = Order::where(['obf_id' => $request->obf_id])->update(['status' => 'delivered', 'updated_by' => auth()->user()->id, 'updated_at' => date('Y-m-d H:i:s')]);

            if (!$order)
                return redirect()->back()->with(['error' => 'something went wrong, please try later']);

            DB::commit();
            return redirect()->route('inventory')->with(['success' => 'Assign completed']);
        } catch (\Throwable $th) {
            DB::rollback();
            return redirect()->back()->with('error', 'something went wrong, please try again later')->withInput();
        }
    }
    /** accepted */
    /**carvarient */
        public function car_drop_down_get(Request $request){ 
            $id = ($request->id);

            $data = [];

            $Carvarient_arr = [];
            if($request->option_table == 'rsa'){
                $RSA = RSA::where(['car_model' => $request->id,'status' => 'active'])->get();
                
                foreach ($RSA as $value) {
                    $color_data = [];
                    $color_data['id'] = $value->id;
                    $color_data['name'] = $value->name;
                    $color_data['amount'] = $value->amount;
                    $Carvarient_arr[] = $color_data;
                }  
            }
            $data['Carvarient_arr'] = $Carvarient_arr;

            return json_encode(array('status'=> true ,'data' => $data));
        }
    /** carvarient */

    /** Get Fule Type */
        public function car_fuel_type_get(Request $request){ 
            $id = ($request->id);

            $fuel_type_id = Carvarient::select('fule_type')
            ->where('id', $id)
            ->where('status', '=', 'active')
            ->first();

            die($fuel_type_id);
            /*$data = [];

            $Carvarient_arr = [];
            if($request->option_check == 'Carvarient'){
                $Carvarient = Carvarient::where(['car_model' => $request->id,'status' => 'active'])->get();
                
                foreach ($Carvarient as $value) {
                    $color_data = [];
                    $color_data['id'] = $value->id;
                    $color_data['name'] = $value->name;
                    $Carvarient_arr[] = $color_data;                    
                }  
            }
            $data['Carvarient_arr'] = $Carvarient_arr;  */

            
            
            return json_encode(array('status'=> true ,'data' => $data));
        }
    /** Get Fule Type */
    
    public function getpricelist(Request $request)
    {
        $vehicle_type = $request->vehicle_type;
        $pricelist_data = DB::table('pricelist_master')->where('id', $request->id)->where('vehicle_type',$vehicle_type)->first();
        
        dd($pricelist_data);
        
        
        
        
        // $rto_custome_handling_charges = $pricelist_data->rto_custome_handling_charges ?? 0;
        // if (isset($request->customer_type)) {
            
        //     if ($rto_custome_handling_charges == 0) {
        //         $pricelist_data = DB::table('rto_master')
        //             ->select('rto_type', 'rto_tax_individual', 'rto_tax_company', 'totali_individual_charges', 'totalcharges')
        //             ->where('rto_type', 'like', $request->customer_type . '%')
        //             ->orderBy('id', 'DESC')
        //             ->first();
        //     } else {
        //         $rto_data = DB::table('rto_master')
        //             ->select('rto_type', 'rto_tax_individual', 'rto_tax_company', 'totali_individual_charges', 'totalcharges','temporary_registration', 'smart_card_fee', 'hypothecation', 'fresh_permit', 'new_registion', 'crtem', 'agent_charges')
        //             ->where('rto_type', 'like', $request->customer_type . '%')
        //             ->orderBy('id', 'DESC')
        //             ->first();
    
        //         $totalcharges = ($rto_data->temporary_registration ?? 0) +
        //                         ($rto_data->smart_card_fee ?? 0) +
        //                         ($rto_data->hypothecation ?? 0) +
        //                         ($rto_data->fresh_permit ?? 0) +
        //                         ($rto_data->new_registion ?? 0) +
        //                         ($rto_data->crtem ?? 0) +
        //                         ($rto_data->agent_charges ?? 0);
        //         $pricelist_data = [
        //             'rto_type' => $rto_data->rto_type,
        //             'rto_tax_individual' => $rto_data->rto_tax_individual,
        //             'rto_tax_company' => $rto_data->rto_tax_company,
        //             'totali_individual_charges' => $rto_data->totali_individual_charges,
        //             'totalcharges' => $totalcharges,
        //             'rto_custome_handling_charges' => $rto_custome_handling_charges,
        //         ];
        //     }
        // }
    
        return response()->json($pricelist_data);
    }
}