";print_r($dataBag['checkInvoice']);exit;
        return view('owner.billing.list', $dataBag);
    }

    public function downloadInvoice(Request $request){
       
        $data=[];
        $checkInvoice=DB::table('invoice')
        ->where('id', $request->invoice_id)->first();
        if(empty($request->invoice_id) || empty($checkInvoice)){
        abort(404);
        }
        $pdf = PDF::loadView('owner.billing.invoice_view', ['data'=>$checkInvoice]);
        $currentDate=date('d-m-Y');
        return $pdf->download("invoice_{$currentDate}.pdf");
    }

 
    
    public function optInOutWhatsapp(Request $request)
    {
        try {
            $cwo_id = $request->cwo_id;
            $currentmasterstatus=$request->currentmasterstatus;
            $allowWhatsappInQueue = $request->status_in_queue ?? 0;
            $allowWhatsappCompleted = $request->status_completed ?? 0;
            if($currentmasterstatus==0){
                $updateMaster=DB::table('cwo_master')
                ->where('id', $cwo_id)
                ->update([
                    'allow_whatsapp_service' => 0,
                    'allow_whatsapp_inqueue' => 0,
                    'allow_whatsapp_completed' => 0
                ]);

               $checknewMasterStatus=DB::table('cwo_master')
               ->where('id', $cwo_id)
               ->where('allow_whatsapp_service',0)
               ->where('allow_whatsapp_inqueue',0)
               ->where('allow_whatsapp_completed',0)
               ->count();
               if($checknewMasterStatus==1){
                DB::table('opt_whatsapp_charges')->insert(['cwo_id'=>$cwo_id,'whatsapp_stop_date'=>date('Y-m-d'),'status'=>1,'created_at'=>now()]);
               }
            
            }
            else{
            // Initialize values to prevent undefined variable issues
            $allowWhatsappInQueue = $request->status_in_queue ?? 0;
            $allowWhatsappCompleted = $request->status_completed ?? 0;
    
            // Determine update status based on new logic
            if ($allowWhatsappInQueue == 1 && $allowWhatsappCompleted == 1) {
                $updateStatus = 2;
            } elseif ($allowWhatsappInQueue == 1 && $allowWhatsappCompleted == 0) {
                $updateStatus = 1;
            } elseif ($allowWhatsappInQueue == 0 && $allowWhatsappCompleted == 1) {
                $updateStatus = 1; // New condition to handle this case
            } else {
                $updateStatus = 0; // Default case when both are 0
                
            }
    
            // Update the database
            $checkStatus = DB::table('cwo_master')
                ->where('id', $cwo_id)
                ->update([
                    'allow_whatsapp_service' => $updateStatus,
                    'allow_whatsapp_inqueue' => $allowWhatsappInQueue,
                    'allow_whatsapp_completed' => $allowWhatsappCompleted
                ]);

            //    if($request->currentmasterstatus==1 && ($allowWhatsappInQueue==0   && $allowWhatsappCompleted==0)){
            
            //      DB::table('opt_whatsapp_charges')->insert(['cwo_id'=>$cwo_id,'whatsapp_stop_date'=>date('Y-m-d'),'status'=>1,'created_at'=>now()]);
                
            //    }
                // $checknewAnotherMasterStatus=DB::table('cwo_master')
                // ->where('id', $cwo_id)
                // ->where('allow_whatsapp_service',0)

                // ->count();
                // if($checknewAnotherMasterStatus==1){
                //  DB::table('opt_whatsapp_charges')->insert(['cwo_id'=>$cwo_id,'whatsapp_stop_date'=>date('Y-m-d'),'status'=>1,'created_at'=>now()]);
                // }
    
            // Response based on update result
            if ($checkStatus) {
                return response()->json([
                    'success' => true,
                    'message' => 'Status updated successfully!',
                    'new_status' => $updateStatus
                ]);
            }
    
         
        }
        } catch (\Exception $e) {
            return response()->json([
                'success' => false,
                'message' => 'Error: ' . $e->getMessage()
            ], 500);
        }
    }

    public function listingServices(Request $request){
     $listing=DB::table('car_wash_subscription_details')->orderBy('service_start_date','desc')->where('cwo_id',Auth::user()->cwo_id)->paginate();
     dd($listing);
    }
     public function addService(Request $request){  
        $dataBag['chMenu'] = '';
        $dataBag['cwoid'] = Auth::user()->cwo_id;
        // $dataBag['permission'] = Permission::where('is_active', 1)->orderBy('id', 'asc')->get();
        return view('owner.billing.service',$dataBag);
     }
     public function saveSubscription(Request $request){
        try {
            // Insert new subscription record
            $subscription = DB::table('car_wash_subscription_details')->insertGetId([
                'cwo_id' => $request->cwo_id,
                'subscription_id' => $request->service_type,
                'service_name' => $request->service_type == 1 ? 'In Queue Notification' : 'Wash Completion Notification',
                'service_start_date' => $request->service_start_date ?? null,
                'status' => $request->is_active,
                'created_at' => now(),
                'updated_by' => Auth::id(),
            ]);
    
            // If service_type exists, update the last record's end date
            if ($request->service_type && $request->service_start_date) {
                $previousSubscription = DB::table('car_wash_subscription_details')
                    ->where('subscription_id', $request->service_type)
                    ->where('cwo_id', $request->cwo_id)
                    ->where('service_start_date', '<', $request->service_start_date)
                    ->orderBy('service_start_date','DESC')
                    //->latest('service_start_date') // Ensure we get the most recent entry
                    ->first();
    
                if ($previousSubscription) {
                    DB::table('car_wash_subscription_details')
                        ->where('id', $previousSubscription->id)
                        ->update([
                            'service_end_date' => Carbon::parse($request->service_start_date)->subDay()->format('Y-m-d'),
                            'status' => 0,
                        ]);
                }
            }
    
            return redirect()->route('owner.billing.getSubscription')
                ->with('success', 'Service Type has been added successfully')
                ->with('msg_class', 'alert alert-success');
        } catch (\Exception $e) {
            return redirect()->back()->with('error', 'Something went wrong: ' . $e->getMessage());
        }
    
     }

     public function getSubscription(Request $request)
     {
      //  dd($request->all());
         $service_start_date = $request->start_date ?? '';
         $service_end_date = $request->end_date ?? '';
         $search = $request->search ?? '';
         $dataBag['chMenu'] = "";
         $cwo_id = Auth::user()->cwo_id;
     

         $query = DB::table('car_wash_subscription_details')
             ->where('cwo_id', $cwo_id)
             ->orderBy('service_start_date', 'desc');
         if ($search != '') {
             $query->where('car_wash_subscription_details.subscription_id', '=', $search);
         }
         if ($service_start_date != '') {
             $query->where('car_wash_subscription_details.service_start_date', '>=', $service_start_date);
         }
         if ($service_end_date != '') {
             $query->where('car_wash_subscription_details.service_end_date', '<=', $service_end_date);
         }    
     
         $data = $query->paginate(10); 
     
         $dataCnt = $data->total(); // Get the total count of records
     
         $dataBag['allRecords'] = $dataCnt;
         $dataBag['records'] = $data;
     
         return view('owner.billing.subscription', $dataBag);
     }
     
     
    
    
    
    

}