middleware('permission:pricelist-create', ['only' => ['create']]); $this->middleware('permission:pricelist-edit', ['only' => ['edit']]); // $this->middleware('permission:inventory-view', ['only' => ['view']]); $this->middleware('permission:pricelist-delete', ['only' => ['delete']]); } /** construct */ /** index */ public function index(Request $request) { if ($request->ajax()) { /*$data = DB::table('pricelist_master') ->select('*') ->get();*/ /* error_reporting(E_ALL); ini_set('display_errors', 1);*/ $data = DB::table('pricelist_master') ->select('pricelist_master.id', 'pricelist_master.price_list_name','car_model.name as product', 'car_varient.name as car_variant_name','colortone.name as color_type','transmission.name as t_name', 'pricelist_master.ex_showroom_price', 'pricelist_master.statutory_charges', 'pricelist_master.registration_corporate_charges', 'pricelist_master.registration_individual_charges', 'pricelist_master.status', 'pricelist_master.created_at') ->leftjoin('car_model', 'car_model.id', 'pricelist_master.car_model') ->leftjoin('transmission', 'transmission.id', 'pricelist_master.transmission') ->leftjoin('car_varient', 'car_varient.id', 'pricelist_master.car_variant') ->leftjoin('colortone', 'colortone.id', 'pricelist_master.colour_type') ->where('pricelist_master.status','!=','deleted') ->orderBy('pricelist_master.id', 'desc'); return Datatables::of($data) ->addIndexColumn() ->addColumn('action', function ($data) { $return = '
'; // if (auth()->user()->can('inventory-view')) { // $return .= ' // //  '; // } if(auth()->user()->can('pricelist-edit')){ $return .= '  '; } // if (auth()->user()->can('inventory-delete')) { // if ($data->status == 'pdi_hold') { // $return .= ' // //   // '; // } else if ($data->status == 'sold') { // $return .= ''; // } else { // $return .= ' // //   // '; // } // } if(auth()->user()->can('pricelist-delete')){ $return .= '   '; } $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 '-'; // } // }) ->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 { return '-'; } }) ->editColumn('created_at', function ($data) { return date("d-m-Y",strtotime($data->created_at)); }) ->rawColumns(['action','status','created_at']) ->make(true); } $customer_name = OBF::select('obf.id','obf.customer_name')->get(); $kec_name = User::select(DB::raw("CONCAT(users.first_name,' ',users.last_name) As kec_name",'users.id'))->get(); $product = Carmodel::select('name','id')->where('status','active')->get(); $price = OBF::select('on_road_price','id')->get(); $varient = Carvarient::select('name','id')->where('status','active')->get(); $branch = Branch::select('name','id')->where('status','active')->get(); return view('pricelist.index')->with(['product'=>$product,'price'=>$price,'varient'=>$varient,'branch'=>$branch]); } /** index */ /** create */ public function create(Request $request) { $accessory = Accessory::select('id' , 'name' ,'price')->where(['status' => 'active'])->get(); $fasttag = Fasttag::select('id' , 'brand_name' ,'amount')->where(['status' => 'active'])->get(); $tone = Colortone::where(['status' => 'active'])->get(); $Cardata = 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(); $extanded_warranty = ExtandWarranty::select('id' , 'years' ,'amount')->where(['status' => 'active'])->get(); $Carmodel_arr = Carmodel::where(['status' => 'active'])->get(); $rsa = RSA::where(['status' => 'active','deleted_at' => 0])->get(); $Branch_data = Branch::where(['status' => 'active'])->get(); $transmission = Transmission::where(['status' => 'active'])->get(); $mcp = Mcp::where(['status' => 'active'])->get(); $OtherOne = OtherOne::where(['status' => 'active'])->get(); $OtherTwo = OtherTwo::where(['status' => 'active'])->get(); $fuel_type = Fuletype::select('*')->where('status','=','active')->get(); return view('pricelist.create')->with(['Cardata' => $Cardata,'accessory' => $accessory ,'fasttag' => $fasttag,'Carmodel_arr' => $Carmodel_arr,'Branch_data' => $Branch_data, 'transmission' => $transmission, 'tone' => $tone, 'extanded_warranty' => $extanded_warranty, 'rsa' => $rsa, 'OtherOne' => $OtherOne,'OtherTwo' => $OtherTwo, 'mcp' => $mcp,'fuel_type'=>$fuel_type]); } /** create */ /** Car Fuel Type **/ public function car_fuel_type(Request $request){ $id = ($request->id); $fuel_type_id = Carvarient::select('fule_type') ->where('id', $id) ->where('status', '=', 'active') ->first(); $fule_type_get = 0; if(!empty($fuel_type_id)){ $fule_type_get = $fuel_type_id->fule_type; } $fule_data = Fuletype::select('*')->where('status', '=', 'active')->get(); $ExtandWarranty_arr = []; $ExtandWarranty_data = ExtandWarranty::where(['car_model' => $request->model_id,'fule_type' => $fule_type_get,'status' => 'active'])->orderBy('years', 'asc')->get(); foreach ($ExtandWarranty_data as $value) { $arr_sub = []; $arr_sub['id'] = $value->id; $arr_sub['amount'] = $value->amount; $arr_sub['years'] = $value->years; $ExtandWarranty_arr[] = $arr_sub; } return json_encode(array('status'=> true ,'data' => $fule_data,'ExtandWarranty_arr' => $ExtandWarranty_arr, 'id' => $fuel_type_id)); } /** Car Fuel Type **/ /** insert */ public function insert(Request $request) { if ($request->ajax()) { return true; } if(empty($request->branch_id) && $request->branch_id == ''){ return redirect()->back()->with('error', 'Please select Branch Name')->withInput(); } if(empty($request->fasttag) && $request->fasttag == ''){ return redirect()->back()->with('error', 'Please select Fasttag')->withInput(); } 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); /*echo "
";
        print_r($detail_value_arr);
        echo $detail_value_arr_json;
        die('stop');*/

     
        $branchIds = implode(',', $request->input('branch_id'));
        $data = [
            'rto_type' => implode(" ,",$request->rto_type) ?? null,
            'price_list_name' => $request->price_list_name ?? NULL,
            'car_model' => $request->car_name ?? NULL,
            'car_variant' => $request->veriant ?? NULL,
            'fule_type' => $request->fule_type ?? NULL,
            'colour_type' => $request->color_tone ?? NULL,
            'product_id' => $request->product_id ?? NULL,
            'branch_id' => $branchIds ?? NULL,
            'transmission' => $request->transmission ?? NULL,
            'ex_showroom_price' => $request->ex_showroom_price ?? NULL,
            'basic' => $request->basic ?? 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,
            'tcs' => $request->tcs ?? NULL,
            // 'statutory_charges' => $request->statutory_charges ?? 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,
            'extended_warranty' => $request->extended_warranty ?? NULL,
            'convinience_program' => $request->convinience_program ?? 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,
            'on_road_price_individual' => $request->on_road_price_individual ?? NULL,
            'on_road_price_corporate' => $request->on_road_price_corporate ?? NULL,
            //'accessories_kit' => implode(" ,",$request->accessories_kit) ?? null,
            'total_road_individual_charges' => $request->total_road_individual_charges ?? NULL,
            'total_road_corporate_charges' => $request->total_road_corporate_charges ?? NULL,
            'detail_value' => $detail_value_arr_json,
            'rto_custome_handling_charges' =>$request->rto_custome_handling_charges,
            'created_at' => date('Y-m-d H:i:s'),
            'is_csd' => $request->is_csd == 'Yes'?1:0,
            'ls_order_amount' =>$request->ls_order_amount?? null,
            'csd_selling_price' => $request->csd_selling_price?? null,
            'outstanding_amount' => $request->outstanding_amount?? 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);

        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]);
    }
    /** 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 .= '
                    //                                     
                    //                                   
                    //                                 ';
                    //     } else if ($data->status == 'sold') {
                    //         $return .= '';
                    //     } else {
                    //         $return .= '
                    //         
                    //       
                    //     ';
                    //     }
                    // }

                    $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,
            'product_id' => $request->product_id ?? NULL,
             'fule_type' => $request->fule_type ?? NULL,
            'branch_id' => $branchIds ?? NULL,
            'colour_type' => $request->color_tone ?? NULL,
            'car_model' => $request->car_name ?? NULL,
            'car_variant' => $request->veriant ?? NULL,
            'transmission' => $request->transmission ?? NULL,
            'ex_showroom_price' => $request->ex_showroom_price ?? NULL,
            'basic' => $request->basic ?? 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,
            'tcs' => $request->tcs ?? NULL,
            // 'statutory_charges' => $request->statutory_charges ?? 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,
            'extended_warranty' => $request->extended_warranty ?? NULL,
            'convinience_program' => $request->convinience_program ?? 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,
            'on_road_price_individual' => $request->on_road_price_individual ?? NULL,
            'on_road_price_corporate' => $request->on_road_price_corporate ?? NULL,
            //'accessories_kit' => implode(" ,",$request->accessories_kit) ?? null,
            'total_road_individual_charges' => $request->total_road_individual_charges ?? NULL,
            'total_road_corporate_charges' => $request->total_road_corporate_charges ?? NULL,
            'detail_value' => $detail_value_arr_json,
            'created_at' => date('Y-m-d H:i:s'),
           // 'updated_by' => auth('sanctum')->user()->id

        ];
        
        // \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 */
}