<?php

namespace App\Http\Controllers;

use App\Http\Models\AnamnesisClinicalCheckup;
use App\Http\Models\AnamnesisMedicalItem;
use App\Http\Models\CartService;
use App\Http\Models\CartServiceDetail;
use App\Http\Models\CartServiceWorkOrder;
use App\Http\Models\GeneralCheckupSignature;
use Carbon\Carbon;
use Illuminate\Database\QueryException;
use DB;
use Illuminate\Http\Request;
use Illuminate\Support\Str;
use Validator;
use App\Http\Models\OrderContactInformation;
use App\Http\Models\OrderOutletInformation;
use App\Http\Models\Transaction;
use Illuminate\Support\Facades\Log;


class CartServiceController extends Controller
{
    public function index(Request $request)
    {
        $limit = $request->has('limit') ? $request->input('limit') : 10;

        $data = CartService::select(
            "cart_services.cart_service_id",
            "cart_services.cart_service_type",
            "cart_services.site_id",
            "cart_services.order_code",
            "cart_services.pet_id",
            "cart_services.doctor_schedule_id",
            "cart_services.grooming_location_schedule_id",
            "cart_services.boarding_schedule_id",
            "cart_services.payment_complete",
            "cart_services.has_anamnesis",
            "cart_services.take_action",
            "cart_services.is_invoice",
            "cart_services.order_date",
            "cart_services.cart_service_status",
            "cart_services.cart_canceled_at",
            "cart_services.created_at",
            "cart_services.updated_at",
            "cart_services.service_type"
        );

        $data = $data->with('items')->whereDate('order_date', $request->input('date'))
            ->where('cart_service_type', $request->input('cart_service_type'))
            ->where('site_id', $request->input('site_id'))->with('medicalItems');
        // ->where('is_invoice', false);

        if ($request->filled('doctor_id')) {
            $data = $data->where('has_anamnesis', true)
                ->where('take_action', false)
                ->where('doctor_schedule_id', '<>', 0);
        }

        if (!$request->filled('doctor_id') && $request->cart_service_type == '2') {
            /**
             * 1. get  all cart_service_detail where site == req->site_id & order_status <> 3
             * 2. group by cart_service_id
             * 3. select cart_service_id
             */
            $uncomplete_items = CartServiceDetail::where('site_id', $request->input('site_id'))
                ->where('order_status', '<>', '3')
                ->groupBy('cart_service_id')
                ->get()
                ->pluck('cart_service_id');

            $cart_uncomplete = CartService::whereIn('cart_service_id', $uncomplete_items)
                ->whereDate('order_date', $request->input('date'))
                ->where('cart_service_type', '2')
                ->get()
                ->pluck('cart_service_id');

            // return $uncomplete_items;
            $data = $data->where('cart_services.is_invoice', false);

            if (count($cart_uncomplete) != 0) {
                $data = $data->orWhere('cart_service_id', $cart_uncomplete);
            }
        } else {
            $data = $data->where('cart_services.is_invoice', false);
        }
        $data = $data->orderBy('created_at', 'desc');
        $data = $this->paging($data->paginate($limit));

        $doctor_schedules = implode(',', collect($data['items'])->pluck('doctor_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $grooming_location_schedules = implode(',', collect($data['items'])->pluck('grooming_location_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $boarding_schedules = implode(',', collect($data['items'])->pluck('boarding_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $pets = implode(',', collect($data['items'])->pluck('pet_id')->toArray());

        $doctorResponse = null;
        $groomingLocationResponse = null;
        $boardingResponse = null;
        $petResponse = null;
        if (!empty($doctor_schedules)) {
            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $doctor_schedules);
        }

        if (!empty($grooming_location_schedules)) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $grooming_location_schedules);
        }

        if (!empty($boarding_schedules)) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $boarding_schedules);
        }

        if (!empty($pets)) {
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/bulk/' . $pets);
        }
        $data['items'] = collect($data['items'])->map(function ($item) use ($petResponse, $doctorResponse, $groomingLocationResponse, $boardingResponse) {
            if ($petResponse['STATUS_CODE'] == '200') {
                $item->pet = collect($petResponse['DATA'])->where('pet_id', $item->pet_id)->first();
            }
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $item->doctor_schedule = collect($doctorResponse['DATA'])->where('doctor_schedule_id', $item->doctor_schedule_id)->first();
            } else {
                $item->doctor_schedule = [
                    "name" => "",
                    "doctor_schedule_id" => 0,
                    "staff_id" => 0,
                    "reservation_id" => 0,
                    "pet_id" => 0,
                    "schedule_date" => "",
                    "schedule_time" => "",
                    "schedule_times" => [],
                ];
            }
            if ($groomingLocationResponse['STATUS_CODE'] == '200') {
                $item->grooming_location_schedule = collect($groomingLocationResponse['DATA'])->where('grooming_location_schedule_id', $item->grooming_location_schedule_id)->first();
            } else {
                $item->grooming_location_schedule = [
                    "location_name" => "",
                    "grooming_location_schedule_id" => 0,
                    "grooming_location_id" => 0,
                    "reservation_id" => 0,
                    "customer_id" => 0,
                    "pet_id" => 0,
                    "schedule_date" => "",
                    "schedule_time" => "",
                ];
            }
            if ($boardingResponse['STATUS_CODE'] == '200') {
                $item->boarding_schedule = collect($boardingResponse['DATA'])->where('cage_schedule_id', $item->boarding_schedule_id)->first();
            } else {
                $item->boarding_schedule = [
                    "cage_name" => "",
                    "cage_price" => 0,
                    "cage_schedule_id" => 0,
                    "cage_id" => 0,
                    "reservation_id" => 0,
                    "customer_id" => 0,
                    "pet_id" => 0,
                    "schedule_date_from" => "",
                    "schedule_date_until" => "",
                ];
            }

            return $item;
        });

        $data['items'] = collect($data['items'])->filter(function ($item) use ($request) {
            if ($request->filled('doctor_id')) {
                return $item->doctor_schedule['staff_id'] == $request->doctor_id;
            }
            return $item;
        })->values();
        // $estimatedTotal = 0;
        // foreach($data['items'] as $ddd) {
        //     if(!empty($ddd->items)){
        //         foreach($ddd->items as $d){
        //             $estimatedTotal = $estimatedTotal+$d->price_after_tax;
        //         }
        //     }
        // }
        // $data['estimated_total']=$estimatedTotal;
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    /**
     * Map external Turboly IDs to a local cart service
     * @api POST /external/cart/map
     */
    public function externalMap(Request $request)
    {
        $input = $request->all();
        $validate = CartService::isValid($input, [
            'cart_service_id' => 'required|numeric',
        ]);
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $cart = CartService::where('cart_service_id', $request->cart_service_id)->first();
        if (!$cart) {
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Cart Service not found';
            return $json;
        }

        $update = [];
        foreach (
            [
                'turboly_service_reservation_id',
                'turboly_service_order_id',
                'turboly_service_invoice_id',
                'turboly_service_work_order_id',
                'source',
                'platform',
            ] as $col
        ) {
            if ($request->filled($col)) {
                $update[$col] = $request->input($col);
            }
        }
        if (!empty($update)) {
            $cart->fill($update);
            $cart->save();
        }

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $cart;
        return $json;
    }

    /**
     * Resolve local cart_service_id by external Turboly IDs
     * @api POST /external/cart/resolve
     */
    public function externalResolve(Request $request)
    {
        // Try reservation/order/invoice first
        $cart = null;
        if ($request->filled('turboly_service_reservation_id')) {
            $cart = CartService::where('turboly_service_reservation_id', $request->turboly_service_reservation_id)->first();
        } elseif ($request->filled('turboly_service_order_id')) {
            $cart = CartService::where('turboly_service_order_id', $request->turboly_service_order_id)->first();
        } elseif ($request->filled('turboly_service_invoice_id')) {
            $cart = CartService::where('turboly_service_invoice_id', $request->turboly_service_invoice_id)->first();
        }
        if (!$cart && $request->filled('turboly_service_work_order_id')) {
            $wo = CartServiceWorkOrder::where('turboly_service_work_order_id', $request->turboly_service_work_order_id)->first();
            if ($wo) {
                $cart = CartService::where('cart_service_id', $wo->wo_cart_service_id)->first();
            }
        }

        if (!$cart) {
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Mapping not found';
            return $json;
        }

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = ['cart_service_id' => $cart->cart_service_id];
        return $json;
    }

    /**
     * Reservation status update by external ID
     * @api POST /external/cart/reservation/status
     */
    public function externalReservationStatus(Request $request)
    {
        Log::info('externalReservationStatus called', ['request' => $request->all()]);

        $event = strtolower($request->event ?? '');
        if (empty($event)) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'event is required';
            return $json;
        }

        $status = null;
        if (in_array($event, ['confirm', 'confirmed'])) {
            $status = 0;
        }
        if (in_array($event, ['cancel', 'canceled', 'cancelled'])) {
            $status = 1;
        }
        if ($status === null) {
            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Ignored event: ' . $event;
            return $json;
        }

        // Find cart by turboly_service_reservation_id
        $cart = null;
        if ($request->filled('turboly_service_reservation_id')) {
            $cart = CartService::where('turboly_service_reservation_id', $request->turboly_service_reservation_id)->first();
        }

        if (!$cart) {
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Cart Service not found for reservation_id: ' . $request->turboly_service_reservation_id;
            return $json;
        }

        $cart->cart_service_status = (int) $status;
        $cart->cart_canceled_at = $status == 1 ? date('Y-m-d H:i:s') : NULL;

        // Store cancel reason if provided
        if ($status == 1) {
            if ($request->filled('cancel_reason_type_id'))
                $cart->cancel_reason_type_id = $request->cancel_reason_type_id;
            if ($request->filled('cancel_reason_type_name'))
                $cart->cancel_reason_type_name = $request->cancel_reason_type_name;
            if ($request->filled('cancel_reason_notes'))
                $cart->cancel_reason_notes = $request->cancel_reason_notes;
        }

        // Store ref_code if provided (Primary identifier)
        if ($request->filled('ref_code')) {
            //  $cart->note = $request->ref_code;
        }

        $cart->save();

        Log::info('externalReservationStatus updated cart', ['cart_service_id' => $cart->cart_service_id, 'status' => $status]);

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $cart;
        return $json;
    }

    /**
     * Order approved by external ID -> start work (job=2)
     * @api POST /external/cart/order/start
     */
    public function externalOrderStart(Request $request)
    {
        Log::info('externalOrderStart called', ['request' => $request->all()]);

        $event = strtolower($request->event ?? '');
        if (!in_array($event, ['approve', 'approved', 'created'])) {
            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Ignored event: ' . $event;
            return $json;
        }

        // Find cart - prefer cart_service_id if already resolved by turboly service
        $cart = null;
        if ($request->filled('cart_service_id')) {
            $cart = CartService::find($request->cart_service_id);
        }
        if (!$cart && $request->filled('turboly_service_reservation_id')) {
            $cart = CartService::where('turboly_service_reservation_id', $request->turboly_service_reservation_id)->first();
        }
        if (!$cart && $request->filled('turboly_service_order_id')) {
            $cart = CartService::where('turboly_service_order_id', $request->turboly_service_order_id)->first();
        }

        if (!$cart) {
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Cart Service not found';
            Log::warning('externalOrderStart cart not found', [
                'cart_service_id' => $request->cart_service_id,
                'turboly_service_order_id' => $request->turboly_service_order_id,
            ]);
            return $json;
        }

        // Store the service_order_id if provided
        if ($request->filled('turboly_service_order_id') && empty($cart->turboly_service_order_id)) {
            $cart->turboly_service_order_id = $request->turboly_service_order_id;
        }

        // Store ref_code if provided (Primary identifier)
        if ($request->filled('ref_code')) {
            //   $cart->note = $request->ref_code;
        }
        $cart->save();

        Log::info('externalOrderStart processing', ['cart_service_id' => $cart->cart_service_id, 'event' => $event]);

        // Only start work on 'approved'
        if (in_array($event, ['approve', 'approved'])) {
            $req = new Request(['job' => 2]);
            return $this->setCartJob($req, $cart->cart_service_id);
        }

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $cart;
        return $json;
    }

    /**
     * Work order status by external ID
     * @api POST /external/cart/work-order/status
     */
    public function externalWorkOrderStatus(Request $request)
    {
        Log::info('externalWorkOrderStatus called', ['request' => $request->all()]);

        $event = strtolower($request->event ?? $request->aasm_state ?? '');
        if (empty($event)) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'event is required';
            return $json;
        }

        // Map Turboly aasm_state / event to job number
        $job = null;
        if (in_array($event, ['in_progress', 'progress', 'started'])) {
            $job = 2;
        } elseif (in_array($event, ['waiting_for_qc', 'checking', 'check', 'qc'])) {
            $job = 3;
        } elseif (in_array($event, ['done', 'completed', 'finished'])) {
            $job = 4;
        }

        // Find cart - prefer cart_service_id if already resolved by turboly service
        $cart = null;
        if ($request->filled('cart_service_id')) {
            $cart = CartService::find($request->cart_service_id);
        }
        if (!$cart && $request->filled('turboly_service_work_order_id')) {
            $cart = CartService::where('turboly_service_work_order_id', $request->turboly_service_work_order_id)->first();
        }
        if (!$cart && $request->filled('turboly_service_order_id')) {
            $cart = CartService::where('turboly_service_order_id', $request->turboly_service_order_id)->first();
        }
        if (!$cart && $request->filled('turboly_service_reservation_id')) {
            $cart = CartService::where('turboly_service_reservation_id', $request->turboly_service_reservation_id)->first();
        }

        if (!$cart) {
            Log::warning('externalWorkOrderStatus cart not found', [
                'cart_service_id' => $request->cart_service_id,
                'turboly_service_work_order_id' => $request->turboly_service_work_order_id,
                'turboly_service_order_id' => $request->turboly_service_order_id,
            ]);
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Cart Service not found';
            return $json;
        }

        // Store the work order ID if provided
        if ($request->filled('turboly_service_work_order_id') && empty($cart->turboly_service_work_order_id)) {
            $cart->turboly_service_work_order_id = $request->turboly_service_work_order_id;
            $cart->save();
        }

        // Store the service order ID if provided
        if ($request->filled('turboly_service_order_id') && empty($cart->turboly_service_order_id)) {
            $cart->turboly_service_order_id = $request->turboly_service_order_id;
        }

        // Store ref_code if provided (Primary identifier)
        if ($request->filled('ref_code')) {
            //      $cart->note = $request->ref_code;
        }
        $cart->save();

        // Check if work orders exist, create if not
        $wo = CartServiceWorkOrder::where('wo_cart_service_id', $cart->cart_service_id)->first();
        if (!$wo) {
            $cartServiceDetail = CartServiceDetail::where('cart_service_id', $cart->cart_service_id)->get();
            foreach ($cartServiceDetail as $valGc) {
                CartServiceWorkOrder::create([
                    'wo_cart_service_id' => $valGc->cart_service_id,
                    'wo_cart_service_detail_id' => $valGc->cart_service_detail_id,
                    'wo_title' => $valGc->service_name,
                    'wo_name' => $valGc->service_name,
                    'wo_image' => 'http://178.128.62.50/rotary/api/public/images/noimages.png',
                    'wo_done_at' => '',
                    'wo_result_json' => '[]',
                    'wo_status' => 0,
                    'turboly_work_order_id' => $request->turboly_service_work_order_id,
                ]);
            }
            Log::info('externalWorkOrderStatus created work orders', ['cart_service_id' => $cart->cart_service_id]);
        }

        // Handle specific detail IDs if provided
        if ($request->filled(['cart_service_detail_ids', 'order_status'])) {
            $req = new Request([
                'job' => $job ?? 2,
                'cart_service_detail_ids' => (array) $request->cart_service_detail_ids,
                'order_status' => (int) $request->order_status,
            ]);
            return $this->setOrderStatus($req);
        }

        // Set job status if we have a valid job mapping
        if ($job !== null) {
            Log::info('externalWorkOrderStatus setting job', ['cart_service_id' => $cart->cart_service_id, 'job' => $job]);
            $req = new Request(['job' => $job]);
            return $this->setCartJob($req, $cart->cart_service_id);
        }

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Ignored event: ' . $event;
        return $json;
    }
    /**
     * Invoice completion by external ID
     * @api POST /external/cart/invoice/status
     */
    public function externalInvoiceStatus(Request $request)
    {
        Log::info('externalInvoiceStatus called', ['request' => $request->all()]);

        $event = strtolower($request->event ?? '');
        if (!in_array($event, ['complete', 'completed'])) {
            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Ignored event: ' . $event;
            return $json;
        }

        $cart = null;
        if ($request->filled('cart_service_id')) {
            $cart = CartService::find($request->cart_service_id);
        }

        if (!$cart && $request->filled('turboly_service_invoice_id')) {
            $cart = CartService::where('turboly_service_invoice_id', $request->turboly_service_invoice_id)->first();
        }


        if (!$cart) {
            Log::warning('externalInvoiceStatus cart not found', [
                'cart_service_id' => $request->cart_service_id,
                'turboly_service_invoice_id' => $request->turboly_service_invoice_id,
            ]);
            // Discord notification for debugging
            $this->sendTransactionWebhookNotification('? Cart NOT FOUND', [
                'cart_service_id' => $request->cart_service_id,
                'ref_code' => $request->ref_code,
                'turboly_service_invoice_id' => $request->turboly_service_invoice_id,
                'request' => $request->all(),
            ]);
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Cart Service not found';
            return $json;
        }

        // Store IDs and ref_code
        if ($request->filled('turboly_service_invoice_id')) {
            $cart->turboly_service_invoice_id = $request->turboly_service_invoice_id;
        }
        if ($request->filled('ref_code')) {
            $cart->turboly_sri_ref_code = $request->ref_code;
        }

        // Sync local flags to match "Closed/Paid/Invoiced" state
        $cart->is_invoice = 1;
        $cart->payment_complete = 1;
        $cart->status_completed = 1;
        $cart->save();

        // Sync child items to match "Invoiced" state
        CartServiceDetail::where('cart_service_id', $cart->cart_service_id)
            ->update(['is_invoice' => 1]);

        AnamnesisMedicalItem::where('cart_service_id', $cart->cart_service_id)
            ->update(['is_invoice' => 1]);

        // Get amount_paid (may be 0 if not provided, we'll still mark as completed)
        $amountPaid = $request->amount_paid ?? 0;

        $transaction = Transaction::where('cart_service_id', $cart->cart_service_id)->first();

        if ($transaction) {
            $transaction->paid_amount = $amountPaid;

            $transaction->payment_status = '3'; // Paid
            $transaction->service_return_date = Carbon::now()->addDays(30); // Added


            // Only update totals if they are zero or significantly different?
            // User requested not to overwrite indiscriminately. 
            // We'll update outstanding balance logic if needed, but for now just updating paid amount is safer.
            // If total_transaction is 0 locally, maybe we populate it.
            // Sync totals with the amount actually paid in the webhook
            if ($amountPaid > 0) {
                $transaction->total_transaction = $amountPaid;
                $transaction->price_before_tax = $amountPaid;
            }
            $transaction->save();
        } else {
            $transaction_data = [
                'transaction_invoice_code' => '#INV-' . time() . '-' . $cart->customer_id,
                'customer_id' => $cart->customer_id,
                'customer_name' => $cart->customer_name,
                'site_id' => $cart->site_id,
                'payment_status' => '3',
                // 'service_return_date' => Carbon::now()->addDays(30), 

                'paid_amount' => $amountPaid,
                'price_before_tax' => $amountPaid, // Fallback for new transaction
                'total_transaction' => $amountPaid, // Fallback for new transaction
                // 'service_return_date' => Carbon::now()->addDays(30), // Added
                'created_by' => 0,
                'staff_id' => 0,
                'cart_service_id' => $cart->cart_service_id,
                'staff_name' => 'turboly webhook',
            ];

            // Use create method to get the object back
            $transaction = Transaction::create($transaction_data);

            // --- OUTLET INFO POPULATION (Enriched Payload) ---
            $populateStatus = ['outlet' => false, 'contact' => false];
            try {
                // 1. Outlet Info (from enriched payload)
                $outletInfo = $request->input('outlet_info', []);
                if (!empty($outletInfo)) {
                    OrderOutletInformation::create([
                        'transaction_id' => $transaction->transaction_id,
                        'site_id' => $outletInfo['site_id'] ?? $cart->site_id, // Prefer payload, fallback to cart
                        'store_id' => $outletInfo['store_id'] ?? $request->store_id ?? 0,
                        'outlet_name' => $outletInfo['outlet_name'] ?? 'Turboly Store',
                        'display_name' => $outletInfo['display_name'] ?? null,
                        'outlet_address' => $outletInfo['outlet_address'] ?? '-',
                        'province' => $outletInfo['province'] ?? '-',
                        'city' => $outletInfo['city'] ?? '-',
                        'date' => date('Y-m-d'),
                        'time' => date('H:i:s'),
                    ]);
                    $populateStatus['outlet'] = true;
                } else {
                    Log::warning('Webhook payload missing outlet_info', ['cart_service_id' => $cart->cart_service_id]);
                }

                // 2. Contact Info (from enriched payload)
                $customerInfo = $request->input('customer_info', []);

                // Fallback to cart data if payload missing (defensive)
                $contactName = $customerInfo['name'] ?? $cart->customer_name;
                $contactPhone = $customerInfo['contact'] ?? $cart->phone ?? '';

                OrderContactInformation::create([
                    'transaction_id' => $transaction->transaction_id,
                    'name' => $contactName,
                    'contact' => $contactPhone,
                    'email' => $customerInfo['email'] ?? '',
                    'address' => $customerInfo['address'] ?? '',
                ]);
                $populateStatus['contact'] = true;

            } catch (\Throwable $e) {
                Log::error('Failed to populate outlet info in webhook (Payload Method)', [
                    'error' => $e->getMessage(),
                    'cart_service_id' => $cart->cart_service_id
                ]);
            }
        }

        Log::info('externalInvoiceStatus completing job', ['cart_service_id' => $cart->cart_service_id]);

        // Discord notification for success
        $this->sendTransactionWebhookNotification('? Transaction UPDATED to PAID', [
            'cart_service_id' => $cart->cart_service_id,
            'transaction_id' => $transaction->transaction_id ?? 'NEW',
            'payment_status' => 3,
            'amount_paid' => $amountPaid,
            'info_population' => $populateStatus ?? 'N/A'
        ]);

        $req = new Request(['job' => 4]);
        return $this->setCartJob($req, $cart->cart_service_id);
    }

    /**
     * Vehicle update by external Turboly webhook
     * Updates customer_pet with next service recommendation from Turboly
     * @api POST /external/cart/vehicle/update
     */
    public function externalVehicleUpdate(Request $request)
    {
        Log::info('externalVehicleUpdate called', ['request' => $request->all()]);

        $turbolyVehicleId = $request->turboly_vehicle_id;
        $turbolyCustomerId = $request->turboly_customer_id;
        $event = strtolower($request->event ?? '');

        if (empty($turbolyVehicleId)) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'turboly_vehicle_id is required';
            return $json;
        }

        // For now, just log the vehicle webhook. 
        // In the future, we can update customer_pet table with next service info
        // This requires calling sitepat-customer service or direct DB access

        Log::info('externalVehicleUpdate received', [
            'turboly_vehicle_id' => $turbolyVehicleId,
            'turboly_customer_id' => $turbolyCustomerId,
            'event' => $event,
            'next_service_date' => $request->next_service_date,
            'next_odometer' => $request->next_odometer,
            'next_service_notes' => $request->next_service_notes,
        ]);

        // TODO: Call customer service to update vehicle next service info
        // $this->POST(env('CUSTOMER') . 'customers/pet/update-next-service', [...]);

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Vehicle webhook received';
        $json['DATA'] = [
            'turboly_vehicle_id' => $turbolyVehicleId,
            'event' => $event,
        ];
        return $json;
    }

    public function detail(Request $request, $id)
    {
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Successfa';
        $json['DATA'] = CartService::where('cart_service_id', $id)->first();
        return $json;
    }
    public function print(Request $request, $id)
    {
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = CartService::where('cart_service_id', $id)->with([
            'service_grooming',
            'service_boarding',
            'medicalItems'
        ])->first();
        return $json;
    }
    /**
     * Create Customer & Pet to Cart
     *
     * @api POST /cart/service
     *
     * @param Integer pet_id
     * @param Integer created_by
     *
     * @author tukangbasic
     */

    public function createCart(Request $request)
    {
        date_default_timezone_set('Asia/Bangkok');
        $input = $request->except(['general_checkup']);
        if ($request->filled('time')) {
            $input['order_time'] = $request->input('time');
        }
        $validate = CartService::isValid($input, [
            'cart_service_id' => 'required',
            // 'pet_id' => 'required',
            'site_id' => 'required',
            'created_by' => 'required',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $json['STATUS_CODE'] = '200';
        if ($request->has('pet_id') && $request->input('pet_id') != 0) {
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $request->input('pet_id'));
            if ($petResponse['STATUS_CODE'] == '200') {
                $input['pet_name'] = $petResponse['DATA']['pet_name'];
                $input['customer_id'] = $petResponse['DATA']['customer_id'];
                $input['customer_name'] = $petResponse['DATA']['customer_name'];
                $input['plat_no'] = $petResponse['DATA']['pet_color'];
                $input['car_color'] = $petResponse['DATA']['pet_race'];
            }
        } else {
            $input['pet_name'] = "";
            $input['customer_id'] = 0;
            $input['customer_name'] = "";
            $input['plat_no'] = "";
            $input['car_color'] = "";
        }

        DB::beginTransaction();

        if ($request->cart_service_id == 0) {
            $input['order_code'] = 'R#' . time() . '-' . "NOCUST";
            $input['has_anamnesis'] = true;
            $input['complaint'] = '';
            $input['doctor_schedule_id'] = 0;
            if ($request->input('complaint') != null && $request->input('complaint') != "") {
                $input['complaint'] = $request->input('complaint');
            }
            if ($request->input('service_type') != null && $request->input('service_type') != "") {
                $input['service_type'] = $request->input('service_type');
            }
            // if(isset($request->input('service_type'))){
            // }
            if (!isset($input['order_date'])) {
                $input['order_date'] = date('Y-m-d');
            }
            $exist = CartService::create($input);

            if ($request->has('general_checkup') && $request->input('general_checkup') != '') {
                foreach ($request->input('general_checkup') as $key => $val) {

                    $checkUp = CartServiceDetail::create([
                        'cart_service_id' => $exist->cart_service_id,
                        'site_id' => $exist->site_id,
                        'service_type' => 1,
                        'service_id' => $val['medical_id'],
                        'service_name' => $val['medical_name'],
                        'service_price' => $val['medical_price'],
                        'service_qty' => 1,
                        'order_status' => 1,
                        'sku' => '',
                        'medical_services' => '',
                        'follow_up_at' => Carbon::now(),
                        'is_general_checkup' => $val['medical_type']
                    ]);
                    $woData = false;
                    foreach ($val['medical_services'] as $valGc) {
                        if ($valGc != '') {
                            $woData[] = new CartServiceWorkOrder([
                                'wo_cart_service_id' => $exist->cart_service_id,
                                'wo_cart_service_detail_id' => $checkUp->cart_service_detail_id,
                                'wo_name' => $valGc,
                                'wo_done_at' => '',
                                'wo_status' => 0
                            ]);
                        }
                    }

                    if ($woData)
                        $checkUp->workOrders()->saveMany($woData);
                }
            }

            $json['MESSAGE'] = 'SUCCESS, Created data';
        } else {
            if ($request->has('pet_id') && $request->input('pet_id') != 0) {
                $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $request->input('pet_id'));

                if ($petResponse['STATUS_CODE'] == '200') {
                    $arrayInput['pet_id'] = $request->input('pet_id');
                    $arrayInput['pet_name'] = $petResponse['DATA']['pet_name'];
                    $arrayInput['customer_id'] = $petResponse['DATA']['customer_id'];
                    $arrayInput['customer_name'] = $petResponse['DATA']['customer_name'];
                    $arrayInput['plat_no'] = $petResponse['DATA']['pet_color'];
                    $arrayInput['car_color'] = $petResponse['DATA']['pet_race'];
                }
                $update = CartService::where('cart_service_id', $request->cart_service_id)
                    ->update($arrayInput);
            }
            $exist = CartService::where('cart_service_id', $request->cart_service_id)
                ->first();
            $json['MESSAGE'] = 'SUCCESS, Exist data';
        }

        $data = CartService::with([
            'service_medical.workOrders',
            'generalCheckup.workOrders',
            'workOrder.workOrders',
            'workChecking.workOrders',
            'service_grooming',
            'service_boarding',
            'medicalItems.bundles'
        ])->where('cart_service_id', $exist->cart_service_id)->first();

        if ($data->doctor_schedule_id != 0) {

            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $data->doctor_schedule_id);
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $data->doctor_schedule = collect($doctorResponse['DATA'])->first();
            }
        } else {
            $data->doctor_schedule = [
                "name" => "",
                "doctor_schedule_id" => 0,
                "staff_id" => 0,
                "reservation_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
                "schedule_times" => [],
            ];
        }

        if ($data->grooming_location_schedule_id != 0) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $data->grooming_location_schedule_id);
            if ($groomingLocationResponse['STATUS_CODE'] == '200') {
                $data->grooming_location_schedule = collect($groomingLocationResponse['DATA'])->first();
            }
        } else {
            $data->grooming_location_schedule = [
                "location_name" => "",
                "grooming_location_schedule_id" => 0,
                "grooming_location_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
            ];
        }

        if ($data->boarding_schedule_id != 0) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $data->boarding_schedule_id);
            if ($boardingResponse['STATUS_CODE'] == '200') {
                $data->boarding_schedule = collect($boardingResponse['DATA'])->first();
            }
        } else {
            $data->boarding_schedule = [
                "cage_name" => "",
                "cage_price" => 0,
                "cage_schedule_id" => 0,
                "cage_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date_from" => "",
                "schedule_date_until" => "",
            ];
        }

        DB::commit();
        $data->customer = [];
        if ($request->has('pet_id') && $request->input('pet_id') != 0) {
            /**
             * Get Pet & Customer
             */
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $input['pet_id']);
            if ($petResponse['STATUS_CODE'] == '200') {
                $data->pet = $petResponse['DATA'];
                $customerResponse = $this->GET(env('CUSTOMER') . 'customers/' . $data->customer_id);
                if ($customerResponse['STATUS_CODE'] == '200') {
                    $data->customer = $customerResponse['DATA'];
                } else {
                    $json['STATUS_CODE'] = '400';
                    $json['MESSAGE'] = 'Failed, Customer cannot loaded';
                    return $json;
                }
            } else {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Failed, Car cannot loaded';
                return $json;
            }
        } else {
            $data->customer = [];
        }
        $json['DATA'] = $data;
        return $json;
    }

    public function createCartApi(Request $request)
    {
        date_default_timezone_set('Asia/Bangkok');
        $input = $request->except(['general_checkup']);
        if ($request->filled('time')) {
            $input['order_time'] = $request->input('time');
        }
        $validate = CartService::isValid($input, [
            'cart_service_id' => 'required',
            // 'pet_id' => 'required',
            'site_id' => 'required',
            'created_by' => 'required',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $json['STATUS_CODE'] = '200';
        if ($request->has('pet_id') && $request->input('pet_id') != 0) {
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $request->input('pet_id'));
            if ($petResponse['STATUS_CODE'] == '200') {
                $input['pet_name'] = $petResponse['DATA']['pet_name'];
                $input['customer_id'] = $petResponse['DATA']['customer_id'];
                $input['customer_name'] = $petResponse['DATA']['customer_name'];
                $input['plat_no'] = $petResponse['DATA']['pet_color'];
                $input['car_color'] = $petResponse['DATA']['pet_race'];
            }
        } else {
            $input['pet_name'] = "";
            $input['customer_id'] = 0;
            $input['customer_name'] = "";
            $input['plat_no'] = "";
            $input['car_color'] = "";
        }

        DB::beginTransaction();

        if ($request->cart_service_id == 0) {
            $input['order_code'] = 'R#' . time() . '-' . "NOCUST";
            $input['has_anamnesis'] = true;
            $input['complaint'] = '';
            $input['doctor_schedule_id'] = 0;
            if ($request->input('complaint') != null && $request->input('complaint') != "") {
                $input['complaint'] = $request->input('complaint');
            }
            if ($request->input('service_type') != null && $request->input('service_type') != "") {
                $input['service_type'] = $request->input('service_type');
            }
            // if(isset($request->input('service_type'))){
            // }
            if (!isset($input['order_date'])) {
                $input['order_date'] = date('Y-m-d');
            }
            $exist = CartService::create($input);

            if ($request->has('general_checkup') && $request->input('general_checkup') != '') {
                foreach ($request->input('general_checkup') as $key => $val) {

                    $checkUp = CartServiceDetail::create([
                        'cart_service_id' => $exist->cart_service_id,
                        'site_id' => $exist->site_id,
                        'service_type' => 1,
                        'service_id' => $val['medical_id'],
                        'service_name' => $val['medical_name'],
                        'service_price' => $val['medical_price'],
                        'service_qty' => 1,
                        'order_status' => 1,
                        'sku' => '',
                        'medical_services' => '',
                        'follow_up_at' => Carbon::now(),
                        'is_general_checkup' => $val['medical_type']
                    ]);
                    $woData = false;
                    foreach ($val['medical_services'] as $valGc) {
                        if ($valGc != '') {
                            $woData[] = new CartServiceWorkOrder([
                                'wo_cart_service_id' => $exist->cart_service_id,
                                'wo_cart_service_detail_id' => $checkUp->cart_service_detail_id,
                                'wo_name' => $valGc,
                                'wo_done_at' => '',
                                'wo_status' => 0
                            ]);
                        }
                    }

                    if ($woData)
                        $checkUp->workOrders()->saveMany($woData);
                }
            }

            $json['MESSAGE'] = 'SUCCESS, Created data';
        } else {
            if ($request->has('pet_id') && $request->input('pet_id') != 0) {
                $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $request->input('pet_id'));

                if ($petResponse['STATUS_CODE'] == '200') {
                    $arrayInput['pet_id'] = $request->input('pet_id');
                    $arrayInput['pet_name'] = $petResponse['DATA']['pet_name'];
                    $arrayInput['customer_id'] = $petResponse['DATA']['customer_id'];
                    $arrayInput['customer_name'] = $petResponse['DATA']['customer_name'];
                    $arrayInput['plat_no'] = $petResponse['DATA']['pet_color'];
                    $arrayInput['car_color'] = $petResponse['DATA']['pet_race'];
                }
                $update = CartService::where('cart_service_id', $request->cart_service_id)
                    ->update($arrayInput);
            }
            $exist = CartService::where('cart_service_id', $request->cart_service_id)
                ->first();
            $json['MESSAGE'] = 'SUCCESS, Exist data';
        }

        $data = CartService::with([
            'service_medical.workOrders',
            'generalCheckup.workOrders',
            'workOrder.workOrders',
            'workChecking.workOrders',
            'service_grooming',
            'service_boarding',
            'medicalItems.bundles'
        ])->where('cart_service_id', $exist->cart_service_id)->first();

        if ($data->doctor_schedule_id != 0) {

            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $data->doctor_schedule_id);
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $data->doctor_schedule = collect($doctorResponse['DATA'])->first();
            }
        } else {
            $data->doctor_schedule = [
                "name" => "",
                "doctor_schedule_id" => 0,
                "staff_id" => 0,
                "reservation_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
                "schedule_times" => [],
            ];
        }

        if ($data->grooming_location_schedule_id != 0) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $data->grooming_location_schedule_id);
            if ($groomingLocationResponse['STATUS_CODE'] == '200') {
                $data->grooming_location_schedule = collect($groomingLocationResponse['DATA'])->first();
            }
        } else {
            $data->grooming_location_schedule = [
                "location_name" => "",
                "grooming_location_schedule_id" => 0,
                "grooming_location_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
            ];
        }

        if ($data->boarding_schedule_id != 0) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $data->boarding_schedule_id);
            if ($boardingResponse['STATUS_CODE'] == '200') {
                $data->boarding_schedule = collect($boardingResponse['DATA'])->first();
            }
        } else {
            $data->boarding_schedule = [
                "cage_name" => "",
                "cage_price" => 0,
                "cage_schedule_id" => 0,
                "cage_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date_from" => "",
                "schedule_date_until" => "",
            ];
        }

        DB::commit();
        $data->customer = [];
        if ($request->has('pet_id') && $request->input('pet_id') != 0) {
            /**
             * Get Pet & Customer
             */
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $input['pet_id']);
            if ($petResponse['STATUS_CODE'] == '200') {
                $data->pet = $petResponse['DATA'];
                $customerResponse = $this->GET(env('CUSTOMER') . 'customers/' . $data->customer_id);
                if ($customerResponse['STATUS_CODE'] == '200') {
                    $data->customer = $customerResponse['DATA'];
                } else {
                    $json['STATUS_CODE'] = '400';
                    $json['MESSAGE'] = 'Failed, Customer cannot loaded';
                    return $json;
                }
            } else {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Failed, Car cannot loaded';
                return $json;
            }
        } else {
            $data->customer = [];
        }





        $json['DATA'] = $data;
        return $json;
    }


    public function createCartHome(Request $request)
    {
        date_default_timezone_set('Asia/Bangkok');
        $input = $request->except(['general_checkup']);
        if ($request->filled('time')) {
            $input['order_time'] = $request->input('time');
        }
        $validate = CartService::isValid($input, [
            'cart_service_id' => 'required',
            'pet_id' => 'required',
            'site_id' => 'required',
            'created_by' => 'required',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $json['STATUS_CODE'] = '200';
        $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $request->input('pet_id'));

        if ($petResponse['STATUS_CODE'] == '200') {
            $input['pet_name'] = $petResponse['DATA']['pet_name'];
            $input['customer_id'] = $petResponse['DATA']['customer_id'];
            $input['customer_name'] = $petResponse['DATA']['customer_name'];
            $input['plat_no'] = $petResponse['DATA']['pet_color'];
            $input['car_color'] = $petResponse['DATA']['pet_race'];
        }
        DB::beginTransaction();

        if ($request->cart_service_id == 0) {
            $input['order_code'] = 'R#' . time() . '-' . $input['pet_id'];
            $input['has_anamnesis'] = true;
            $input['complaint'] = '';
            $input['doctor_schedule_id'] = 0;
            if ($request->input('complaint') != null && $request->input('complaint') != "") {
                $input['complaint'] = $request->input('complaint');
            }
            $input['service_type'] = $request->input('service_type');
            $input['latitude'] = $request->input('latitude');
            $input['longitude'] = $request->input('longitude');
            $input['note'] = $request->input('note');
            $input['address'] = $request->input('address');
            // if(isset($request->input('service_type'))){
            // }
            if (!isset($input['order_date'])) {
                $input['order_date'] = date('Y-m-d');
            }
            $exist = CartService::create($input);

            if ($request->has('general_checkup') && $request->input('general_checkup') != '') {
                foreach ($request->input('general_checkup') as $key => $val) {

                    $checkUp = CartServiceDetail::create([
                        'cart_service_id' => $exist->cart_service_id,
                        'site_id' => $exist->site_id,
                        'service_type' => 2,
                        'service_id' => $val['medical_id'],
                        'service_name' => $val['medical_name'],
                        'service_price' => $val['medical_price'],
                        'service_qty' => 1,
                        'order_status' => 1,
                        'sku' => '',
                        'medical_services' => '',
                        'follow_up_at' => Carbon::now(),
                        'is_general_checkup' => $val['medical_type']
                    ]);
                    $woData = false;
                    foreach ($val['medical_services'] as $valGc) {
                        if ($valGc != '') {
                            $woData[] = new CartServiceWorkOrder([
                                'wo_cart_service_id' => $exist->cart_service_id,
                                'wo_cart_service_detail_id' => $checkUp->cart_service_detail_id,
                                'wo_name' => $valGc,
                                'wo_done_at' => '',
                                'wo_status' => 0
                            ]);
                        }
                    }

                    if ($woData)
                        $checkUp->workOrders()->saveMany($woData);
                }
            }

            $json['MESSAGE'] = 'SUCCESS, Created data';
        } else {
            $exist = CartService::where('cart_service_id', $request->cart_service_id)
                ->first();
            $json['MESSAGE'] = 'SUCCESS, Exist data';
        }

        $data = CartService::with([
            'service_medical.workOrders',
            'generalCheckup.workOrders',
            'workOrder.workOrders',
            'workChecking.workOrders',
            'service_grooming',
            'service_boarding',
            'medicalItems'
        ])->where('cart_service_id', $exist->cart_service_id)->first();

        if ($data->doctor_schedule_id != 0) {

            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $data->doctor_schedule_id);
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $data->doctor_schedule = collect($doctorResponse['DATA'])->first();
            }
        } else {
            $data->doctor_schedule = [
                "name" => "",
                "doctor_schedule_id" => 0,
                "staff_id" => 0,
                "reservation_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
                "schedule_times" => [],
            ];
        }

        if ($data->grooming_location_schedule_id != 0) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $data->grooming_location_schedule_id);
            if ($groomingLocationResponse['STATUS_CODE'] == '200') {
                $data->grooming_location_schedule = collect($groomingLocationResponse['DATA'])->first();
            }
        } else {
            $data->grooming_location_schedule = [
                "location_name" => "",
                "grooming_location_schedule_id" => 0,
                "grooming_location_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
            ];
        }

        if ($data->boarding_schedule_id != 0) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $data->boarding_schedule_id);
            if ($boardingResponse['STATUS_CODE'] == '200') {
                $data->boarding_schedule = collect($boardingResponse['DATA'])->first();
            }
        } else {
            $data->boarding_schedule = [
                "cage_name" => "",
                "cage_price" => 0,
                "cage_schedule_id" => 0,
                "cage_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date_from" => "",
                "schedule_date_until" => "",
            ];
        }

        DB::commit();

        /**
         * Get Pet & Customer
         */
        //$petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $input['pet_id']);
        if ($petResponse['STATUS_CODE'] == '200') {
            $data->pet = $petResponse['DATA'];
            $customerResponse = $this->GET(env('CUSTOMER') . 'customers/' . $data->customer_id);
            if ($customerResponse['STATUS_CODE'] == '200') {
                $data->customer = $customerResponse['DATA'];
            } else {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Failed, Customer cannot loaded';
                return $json;
            }
        } else {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Car cannot loaded';
            return $json;
        }
        $json['DATA'] = $data;
        $json['payload'] = $request->all();
        return $json;
    }

    /**
     * Add Service
     *
     * @api POST /cart/service/add
     *
     * @param Integer cart_service_id
     * @param Integer service_id
     * @param String service_name
     * @param String service_price
     * @param Enum service_type
     * @param Integer created_by
     * @author tukangbasic
     */
    public function addService(Request $request)
    {
        try {
            DB::beginTransaction();

            $input = $request->all();
            $validate = CartServiceDetail::isValid($input, [
                'cart_service_id' => 'required',
                'service_type' => 'required',
                'site_id' => 'required',
                'service_id' => 'required',
                'service_name' => 'required',
                'service_price' => 'required',
                'created_by' => 'required'
            ]);

            /**
             * Validate Model
             */
            if (!$validate[0]) {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Failed, Some field getting errors';
                $json['ERROR'] = $validate[1];
                return response($json, 400);
            }

            $exist = CartServiceDetail::where('cart_service_id', $request->cart_service_id)
                ->where('service_type', $request->service_type)
                ->where('service_id', $request->service_id)
                ->first();
            if (!$exist) {
                $input['service_qty'] = 1;
                $input['follow_up_at'] = Carbon::now();
                $input['medical_services'] = '';
                $input['tax_value'] = $input['service_price'] * $input['tax_rate'];
                $input['price_after_tax'] = $input['service_price'] + $input['tax_value'];
                $exist = CartServiceDetail::create($input);

                if (!$exist) {
                    DB::rollBack();
                    $json['STATUS_CODE'] = '400';
                    $json['MESSAGE'] = 'FAILED';
                    return response($json, 400);
                } else {
                    $cartService = CartService::find($request->cart_service_id);

                    if ($request->service_type == '1' && $request->service_id == '1') {
                        $cartService->has_anamnesis = true;
                    }
                    $cartService->take_action = true;
                    $cartService->odometer = $request->odometer;

                    $cartService->save();
                    $cekWorkOrders = CartServiceDetail::where('cart_service_id')->get();
                    if (isset($cekWorkOrders)) {
                        // if ($request->has('medical_services')) {
                        foreach ($cekWorkOrders as $wo) {
                            if ($wo != '') {
                                $woData[] = new CartServiceWorkOrder([
                                    'wo_cart_service_id' => $cartService->cart_service_id,
                                    'wo_cart_service_detail_id' => $exist->cart_service_detail_id,
                                    'wo_name' => $wo->service_name,
                                    'wo_done_at' => '',
                                    'wo_status' => 0
                                ]);
                            }
                        }

                        if (isset($woData))
                            $exist->workOrders()->saveMany($woData);
                    }
                    DB::commit();
                    Log::info('SUCCESS ADDED');

                    // Create Turboly service reservation after successful service addition
                    // $turbolyResp = $this->createTurbolyReservation($cartService, $request);
                    // if (is_array($turbolyResp) && isset($turbolyResp['status']) && ($turbolyResp['status'] == 200 || $turbolyResp['status'] == 201)) {
                    //     // On success, convert to reservation
                    //     $toResReq = new Request([
                    //         'cart_service_id' => $cartService->cart_service_id,
                    //         'created_by' => $request->created_by,
                    //         'site_id' => $cartService->site_id,
                    //         'pet_id' => $cartService->pet_id,
                    //     ]);
                    //     $toRes = $this->toReservation($toResReq);
                    //     if (!is_array($toRes) || ($toRes['STATUS_CODE'] ?? '200') !== '200') {
                    //         $json['STATUS_CODE'] = '400';
                    //         $json['MESSAGE'] = 'Failed converting to reservation';
                    //         $json['ERROR'] = $toRes;
                    //         return response($json, 400);
                    //     }

                    //     // After reservation success, add cart service to invoice
                    //     $invReq = new Request([
                    //         'cart_service_id' => $cartService->cart_service_id,
                    //         'site_id' => $cartService->site_id,
                    //         'created_by' => $request->created_by,
                    //         'pet_id' => $cartService->pet_id,
                    //     ]);
                    //     $txCtrl = new TransactionController();
                    //     $invRes = $txCtrl->addCartServiceToInvoice($invReq);
                    //     Log::info('Adding cart service to invoice', [
                    //         'cart_service_id' => $cartService->cart_service_id,
                    //         'site_id' => $cartService->site_id,
                    //         'created_by' => $request->created_by,
                    //         'response' => $invRes,
                    //     ]);
                    //     if (!is_array($invRes) || ($invRes['STATUS_CODE'] ?? '200') !== '200') {
                    //         $json['STATUS_CODE'] = '400';
                    //         $json['MESSAGE'] = 'Failed adding cart service to invoice';
                    //         $json['ERROR'] = $invRes;
                    //         return response($json, 400);
                    //     }
                    // } else {
                    //     $json['STATUS_CODE'] = '400';
                    //     $json['MESSAGE'] = 'Failed creating Turboly service reservation';
                    //     $json['ERROR'] = $turbolyResp ?? null;
                    //     return response($json, 400);
                    // }

                    $json['STATUS_CODE'] = '200';
                    $json['MESSAGE'] = 'SUCCESS ADDED';
                    $json['DATA'] = $exist;
                    return response($json, 200);
                }
            } else {
                DB::rollBack();
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'SHOPPING CART OR SERVICE WAS ALREADY EXIST!';
                $json['DATA'] = $exist;
                return response($json, 400);
            }
        } catch (\Exception $e) {
            DB::rollBack();
            \Log::error('Error in addService: ' . $e->getMessage());
            $json['STATUS_CODE'] = '500';
            $json['MESSAGE'] = 'Internal Server Error';
            $json['ERROR'] = $e->getMessage();
            return response($json, 500);
        }
    }

    /**
     * Delete Service
     *
     * @api POST /cart/service/delete
     *
     * @param Integer cart_service_id
     * @param Integer service_id
     * @param Enum service_type
     *
     * @author tukangbasic
     */
    public function deleteService(Request $request)
    {
        $input = $request->all();
        $validate = CartServiceDetail::isValid($input, [
            'cart_service_id' => 'required',
            'service_type' => 'required',
            'service_id' => 'required',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }
        $exist = CartServiceDetail::where('cart_service_id', $request->cart_service_id)
            ->where('service_id', $request->service_id)
            ->where('service_type', $request->service_type)
            ->first();
        if ($exist) {
            $idDetail = $exist->cart_service_detail_id;
            $saved = $exist->forceDelete();
            if (!$saved) {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Failed when delete service';
            } else {
                $cartService = CartService::find($request->cart_service_id);

                if ($request->service_type == '3') {
                    $responseDelete = $this->GET(env('SERVICE') . 'cages/schedules/' . $cartService->boarding_schedule_id . '/delete');

                    if ($responseDelete['STATUS_CODE'] == '200') {
                        $cartService->boarding_schedule_id = 0;
                    }
                }

                if ($request->service_type == '1' && $request->service_id == '1') {
                    $cartService->has_anamnesis = false;
                }

                $cartService->save();

                // DELETE WO
                $wo = CartServiceWorkOrder::where('wo_cart_service_detail_id', $idDetail)->delete();

                $json['STATUS_CODE'] = '200';
                $json['MESSAGE'] = 'Success delete service';
            }
        } else {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Service not found in cart';
        }
        return $json;
    }

    /**
     * Convert Cart Service
     *
     * @api POST /cart/service/reservation
     *
     *
     * @author tukangbasic
     */
    public function toReservation(Request $request)
    {
        $exist = CartService::where('cart_service_id', $request->cart_service_id)
            ->where('payment_complete', false)
            ->first();

        $response_schedule_doctor = null;
        $response_schedule_grooming_location = null;
        $response_schedule_cage = null;
        $schedules = '';
        if ($exist) {
            if ($request->filled(['doctor_schedule_date', 'doctor_schedule_time', 'doctor_id'])) {
                $times = [];
                if (is_array($request->doctor_schedule_time)) {
                    foreach ($request->doctor_schedule_time as $time) {
                        $times[] = $time;
                    }
                } else {
                    $times[] = $request->doctor_schedule_time;
                }
                $data_doctor_schedule = [
                    'staff_id' => $request->doctor_id,
                    'reservation_id' => $exist->cart_service_id,
                    'pet_id' => $exist->pet_id,
                    'schedule_date' => $request->doctor_schedule_date,
                    'schedule_time' => $times,
                    'created_by' => $request->created_by,
                ];
                // hit api schedule doctor
                $response_schedule_doctor = $this->POST(env('STAFF') . 'staffs/doctors/schedules', $data_doctor_schedule);
                if ($response_schedule_doctor['STATUS_CODE'] == '200') {
                    $schedules .= ' Doctor';
                    $dsId = [];
                    foreach ($response_schedule_doctor['DATA'] as $data) {
                        $dsId[] = $data['doctor_schedule_id'];
                    }
                    $exist->doctor_schedule_id = $request->doctor_id == 0 ? 0 : $response_schedule_doctor['DATA'][0]['doctor_schedule_id'];
                    $exist->mechanic_schedule_id = $request->doctor_id == 0 ? 0 : implode(',', $dsId);
                } else {
                    $json = $response_schedule_doctor;
                    return $json;
                }
            } else if ($request->filled(['doctor_id'])) {
                $response_schedule_doctor = $this->POST(env('STAFF') . 'staffs/doctors/schedules', ['staff_id' => $request->doctor_id, 'reservation_id' => $exist->cart_service_id]);
                $exist->doctor_schedule_id = $request->doctor_id;
                $exist->has_anamnesis = false;
                $exist->take_action = false;
                $schedules = ',';
            }

            if ($request->filled(['grooming_location_date', 'grooming_location_time', 'grooming_location_id'])) {
                $data_grooming_location_schedule = [
                    'grooming_location_id' => $request->grooming_location_id,
                    'reservation_id' => $exist->cart_service_id,
                    'pet_id' => $exist->pet_id,
                    'schedule_date' => $request->grooming_location_date,
                    'schedule_time' => $request->grooming_location_time,
                    'created_by' => $request->created_by,
                ];

                // hit api schedule service
                $response_schedule_grooming_location = $this->POST(env('SERVICE') . 'groomings/locations/schedules', $data_grooming_location_schedule);

                if ($response_schedule_grooming_location['STATUS_CODE'] == '200') {
                    $schedules .= ', Grooming Location';
                    $exist->grooming_location_schedule_id = $request->grooming_location_id == 0 ? 0 : $response_schedule_grooming_location['DATA']['grooming_location_schedule_id'];
                } else {
                    // cancel doctor if exist
                    if ($response_schedule_doctor != null && $request->doctor_id != 0) {
                        // hit api cancel doctor sechedule
                        $this->GET(env('STAFF') . 'staffs/doctors/schedules/' . $response_schedule_doctor['DATA']['doctor_schedule_id'] . '/delete');
                    }

                    $json = $response_schedule_grooming_location;
                    return $json;
                }
            } else if ($request->filled(['grooming_location_id'])) {
                $response_schedule_grooming_location = $this->POST(env('SERVICE') . 'groomings/locations/schedules', ['grooming_location_id' => $request->grooming_location_id, 'reservation_id' => $exist->cart_service_id]);
                $exist->grooming_location_schedule_id = $request->grooming_location_id;
                $schedules = ',';
            }

            if ($request->filled(['cage_id', 'cage_schedule_date_from', 'cage_schedule_date_until', 'cage_price', 'cage_name'])) {
                $data_cage_schedule = [
                    'cage_id' => $request->cage_id,
                    'reservation_id' => $exist->cart_service_id,
                    'pet_id' => $exist->pet_id,
                    'schedule_date_from' => $request->cage_schedule_date_from,
                    'schedule_date_until' => $request->cage_schedule_date_until,
                    'created_by' => $request->created_by,

                ];
                // hit api schedule cage and add cage to service
                $response_schedule_cage = $this->POST(env('SERVICE') . 'cages/schedules', $data_cage_schedule);
                if ($response_schedule_cage['STATUS_CODE'] == '200') {
                    $schedules .= ', Boarding';
                    // create service cage in cart here.
                    CartServiceDetail::where('cart_service_id', $exist->cart_service_id)->where('service_type', '3')->forceDelete();
                    if ($request->cage_id != 0) {
                        $service_qty = Carbon::parse($request->cage_schedule_date_until)->diffInDays(Carbon::parse($request->cage_schedule_date_from));
                        $cage_service = [
                            'cart_service_id' => $exist->cart_service_id,
                            'service_type' => '3',
                            'site_id' => $request->site_id,
                            'service_id' => $request->cage_id,
                            'service_qty' => $service_qty == 0 ? 1 : $service_qty,
                            'service_name' => $request->cage_name,
                            'service_price' => $request->cage_price,
                            'created_by' => $request->created_by,
                            'follow_up_at' => Carbon::now()
                        ];
                        // delete all boarding
                        // create boarding
                        CartServiceDetail::create($cage_service);
                    }
                    $exist->boarding_schedule_id = $request->cage_id == 0 ? 0 : $response_schedule_cage['DATA']['cage_schedule_id'];
                } else {
                    // cancel doctor if exist
                    if ($response_schedule_doctor != null && $request->doctor_id != 0) {
                        // hit api cancel
                        $this->GET(env('STAFF') . 'staffs/doctors/schedules/' . $response_schedule_doctor['DATA']['doctor_schedule_id'] . '/delete');
                    }

                    // cancel grooming location if exist
                    if ($response_schedule_grooming_location != null && $request->grooming_location_id != 0) {
                        // hit api cancel
                        $this->GET(env('SERVICE') . 'groomings/locations/schedules/' . $response_schedule_grooming_location['DATA']['grooming_location_schedule_id'] . '/delete');
                    }
                    $json = $response_schedule_cage;
                    return $json;
                }
            } else if ($request->filled(['cage_id'])) {
                // if cage_id == 0
                if ($request->cage_id == 0 && $exist->boarding_schedule_id != 0) {
                    // @TODO delete
                    $response_delete_schedule_cage = $this->GET(env('SERVICE') . 'cages/schedules/' . $exist->boarding_schedule_id . '/delete');
                    if ($response_delete_schedule_cage['STATUS_CODE'] == '200') {

                        $serviceCage = CartService::with('service_boarding')->where('cart_service_id', $exist->cart_service_id)->first();

                        if (count($serviceCage->service_boarding) > 0) {
                            $cartServiceDetail = CartServiceDetail::where('service_type', '3')
                                ->where('service_id', $serviceCage->service_boarding[0]->service_id)->delete();
                            $exist->boarding_schedule_id = 0;
                        }
                    }
                    $schedules = ',';
                } else {
                    $response_schedule_cage = $this->POST(env('SERVICE') . 'cages/schedules', ['cage_id' => $request->cage_id, 'reservation_id' => $exist->cart_service_id]);
                    $exist->boarding_schedule_id = $request->cage_id;
                    $schedules = ',';
                }
            }

            if (!empty($schedules)) {
                $exist->cart_service_type = $request->cart_service_type;
                $exist->order_date = $request->order_date;
                $exist->save();
                $json['STATUS_CODE'] = '200';
                $json['MESSAGE'] = 'Success Add' . $schedules . ' Schedule';
            } else {
                $json['STATUS_CODE'] = '200';
                $json['MESSAGE'] = 'Nothing to add';
            }
            $json['DATA'] = CartService::with(['service_medical', 'service_grooming', 'service_boarding'])->where('cart_service_id', $exist->cart_service_id)->first();
            /**
             * Get Pet & Customer
             */
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $request->pet_id);
            if ($petResponse['STATUS_CODE'] == '200') {
                $json['DATA']['pet'] = $petResponse['DATA'];
            } else {
                $json['DATA']['pet'] = [];
                // $json['STATUS_CODE'] = '400';
                // $json['MESSAGE'] = 'Failed, Pet cannot loaded';
                return $json;
            }
        } else {

            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Cart Service not found!';
        }
        return $json;
    }

    public function delete($id)
    {
        $exist = CartService::find($id);
        if ($exist) {
            if ($exist->doctor_schedule_id != 0) {
                $this->GET(env('STAFF') . 'staffs/doctors/schedules/' . $exist->doctor_schedule_id . '/delete');
            }

            if ($exist->grooming_location_schedule_id != 0) {
                $this->GET(env('SERVICE') . 'groomings/locations/schedules/' . $exist->grooming_location_schedule_id . '/delete');
            }

            if ($exist->boarding_schedule_id != 0) {
                $this->GET(env('SERVICE') . 'cages/schedules/' . $exist->boarding_schedule_id . '/delete');
            }

            CartServiceDetail::where('cart_service_id', $exist->cart_service_id)->forceDelete();
            CartService::find($id)->forceDelete();

            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Cart Service deleted!';
        } else {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Cart Service not found!';
        }

        return $json;
    }

    public function reservationToOrder(Request $request)
    {
        if ($request->filled('cart_service_id')) {
            $exist = CartService::find($request->input('cart_service_id'));
            // deleted_services
            if ($request->filled('deleted_services')) {
                $deleted_cart_service_detail_id = $request->deleted_services;
                foreach ($deleted_cart_service_detail_id as $deleted_id) {
                    $item = CartServiceDetail::find($deleted_id)->delete();
                    // @todo : Delete details;
                }
                $countMedicalItems = CartServiceDetail::where('cart_service_id', $request->cart_service_id)
                    ->where('service_type', '1') // 1 => medical;
                    ->count();
                $countGroomingItems = CartServiceDetail::where('cart_service_id', $request->cart_service_id)
                    ->where('service_type', '2') // 2 => grooming;
                    ->count();
                $countBoardingItems = CartServiceDetail::where('cart_service_id', $request->cart_service_id)
                    ->where('service_type', '3') // 3 => boarding;
                    ->count();
                if ($countMedicalItems == 0) {
                    if ($exist->doctor_schedule_id != 0) {
                        $delete_schedule_doctor = $this->GET(env('STAFF') . 'staffs/doctors/schedules/' . $exist->doctor_schedule_id . '/delete');
                        if ($delete_schedule_doctor['STATUS_CODE'] == '200') {
                            $exist->doctor_schedule_id = 0;
                            $exist->save();
                        }
                    }
                }

                if ($countGroomingItems == 0) {
                    if ($exist->grooming_location_schedule_id != 0) {
                        $delete_schedule_grooming = $this->GET(env('SERVICE') . 'groomings/locations/schedules/' . $exist->grooming_location_schedule_id . '/delete');
                        if ($delete_schedule_grooming['STATUS_CODE'] == '200') {
                            $exist->grooming_location_schedule_id = 0;
                            $exist->save();
                        }
                    }
                }

                if ($countBoardingItems == 0) {
                    if ($exist->boarding_schedule_id != 0) {
                        $delete_schedule_boarding = $this->GET(env('SERVICE') . 'cages/schedules/' . $exist->boarding_schedule_id . '/delete');
                        if ($delete_schedule_boarding['STATUS_CODE'] == '200') {
                            $exist->boarding_schedule_id = 0;
                            $exist->save();
                        }
                    }
                }
            }

            if ($exist) {
                $exist->cart_service_type = '2';
                $exist->save();
                $json['DATA'] = $exist->only('pet_id', 'customer_id', 'customer_name', 'pet_name', 'plat_no', 'car_color');
                $json['STATUS_CODE'] = '200';
                $json['MESSAGE'] = 'Cart Service to Order!';
            } else {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Cart Service not found!';
            }
        } else {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'cart_service_id is required!';
        }
        return $json;
    }

    public function orderList(Request $request, $cartServiceType = '2')
    {

        $limit = $request->has('limit') ? $request->input('limit') : 10;
        $data = CartService::where('cart_service_type', $cartServiceType); //->with('items');
        if ($request->filled('site_id')) {
            $data = $data->where('site_id', $request->site_id);
        }

        $data = $data->whereNotNull('turboly_srv_ref_code')
            ->where('turboly_srv_ref_code', '!=', '');

        if ($request->has('order_code') || $request->has('turboly_srv_ref_code')) {
            $code = $request->input('order_code') ?: $request->input('turboly_srv_ref_code');
            $data = $data->where(function ($q) use ($code) {
                $q->where('turboly_srv_ref_code', 'LIKE', '%' . $code . '%');
            });
        }

        if ($request->has('customer_name')) {
            $data = $data->where('customer_name', 'LIKE', '%' . $request->input('customer_name') . '%');
        }

        if ($request->has('pet_name')) {
            $data = $data->where('pet_name', 'LIKE', '%' . $request->input('pet_name') . '%');
        }
        if ($request->has('plat_no')) {
            $data = $data->where('plat_no', 'LIKE', '%' . $request->input('plat_no') . '%');
        }

        $query_total_service = $cartServiceType === '1'
            ? $this->getServiceDetailSubtotalSql()
            : 'SELECT SUM(cart_service_detail.service_qty * cart_service_detail.service_price) FROM cart_service_detail
                                WHERE cart_service_detail.cart_service_id = cart_services.cart_service_id';
        $query_total_anamnesis = 'SELECT SUM(anamnesis_medical_item.product_qty * anamnesis_medical_item.product_price - anamnesis_medical_item.discount_amount) FROM anamnesis_medical_item
                                WHERE anamnesis_medical_item.cart_service_id = cart_services.cart_service_id';

        if ($request->has('total')) {
            $data = $data->whereRaw('(' . $query_total_service . ')+IFNULL(IF(has_anamnesis = 1,(' . $query_total_anamnesis . '),0),0) LIKE ?', ['%' . $request->input('total') . '%']);
        }

        $data->orderBy('created_at', 'desc');


        $data = $data->select(
            [
                'is_invoice',
                'payment_complete',
                'cart_service_type',
                'turboly_srv_ref_code',
                'turboly_srv_ref_code as order_code',
                'plat_no',
                'customer_name',
                'customer_id',
                'pet_id',
                'pet_name',
                'order_date',
                'updated_at',
                'has_anamnesis',
                'cart_service_id',
                'status_completed',
                DB::raw(
                    '(' . $query_total_service . ')+IFNULL(IF(has_anamnesis = 1,(' . $query_total_anamnesis . '),0),0) as total'
                )
            ]
        );

        if ($request->has('start_date') && $request->has('end_date')) {
            $from = date($request->input('start_date'));
            $to = date($request->input('end_date'));
            $data = $data->whereBetween('updated_at', [$from, $to . ' 23:59:59']);
        }
        $data = $data->orderBy('order_date', 'desc');

        $all = clone $data;

        $data = $this->paging($data->paginate($limit));
        $all = $all->get();

        $data['total_order'] = $all->count();
        $data['total'] = $all->sum('total');

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function reservationList(Request $request)
    {
        return $this->orderList($request, '1');
    }

    public function orderDetail($id, $cartServiceType = '2')
    {
        $data = CartService::where('cart_service_id', $id)->where('cart_service_type', $cartServiceType)->with('items')->first();
        $pets = $data->pet_id;

        $petResponse = null;
        $doctorResponse = null;
        $groomingLocationResponse = null;
        $boardingResponse = null;

        if (!empty($pets)) {
            $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/bulk/' . $pets);
        }

        if (!empty($data->doctor_schedule_id != 0)) {
            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $data->doctor_schedule_id);
        }

        if (!empty($data->grooming_location_schedule_id != 0)) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $data->grooming_location_schedule_id);
        }

        if (!empty($data->boarding_schedule_id != 0)) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $data->boarding_schedule_id);
        }

        if ($petResponse['STATUS_CODE'] == '200') {
            $data->pet = collect($petResponse['DATA'])->where('pet_id', $data->pet_id)->first();
        }

        $data->order_code = $data->turboly_srv_ref_code ?: $data->order_code;
        if ($doctorResponse['STATUS_CODE'] == '200') {
            $data->doctor_schedule = collect($doctorResponse['DATA'])->where('doctor_schedule_id', $data->doctor_schedule_id)->first();
        }
        if ($groomingLocationResponse['STATUS_CODE'] == '200') {
            $data->grooming_schedule = collect($groomingLocationResponse['DATA'])->where('grooming_location_schedule_id', $data->grooming_location_schedule_id)->first();
        }
        if ($boardingResponse['STATUS_CODE'] == '200') {
            $data->boarding_schedule = collect($boardingResponse['DATA'])->where('cage_schedule_id', $data->boarding_schedule_id)->first();
        }

        $medical_items = collect();
        $exams = collect();
        if ($data->has_anamnesis) {
            $medical_items = AnamnesisMedicalItem::where('cart_service_id', $data->cart_service_id)->get();
            $medical_items->map(function ($item) {
                $item->sub_total = $item->product_price * $item->product_qty - $item->discount_amount;
                return $item;
            });
        }

        $data->items = $data->items->map(function ($item) use ($cartServiceType) {
            if ($cartServiceType === '1') {
                $lineExTax = ($item['service_qty'] ?? 1) * ($item['service_price'] ?? 0);
                $subTotal = $this->calculateServiceDetailSubtotal($item);
                $item['sub_total'] = $subTotal;
                $item['tax_amount'] = max(0, $subTotal - $lineExTax);
            } else {
                $item['sub_total'] = ($item['service_qty'] ?? 1) * ($item['service_price'] ?? 0);
            }
            return $item;
        });

        $data->medical_items = $medical_items;
        $data->exams = $exams;

        if ($cartServiceType === '1') {
            $data->subtotal_ex_tax = $data->items->sum(function ($item) {
                return ($item['service_qty'] ?? 1) * ($item['service_price'] ?? 0);
            }) + $data->medical_items->sum(function ($item) {
                return ($item->product_price * $item->product_qty) - $item->discount_amount;
            });
            $data->tax = $data->items->sum('tax_amount');
            $data->total = $data->items->sum('sub_total') + $data->medical_items->sum('sub_total');
        } else {
            $data->total = $data->items->sum('sub_total') + $data->medical_items->sum('sub_total');
        }
        $data->disc = $data->medical_items->sum('discount_amount');
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function reservationDetail($id)
    {
        return $this->orderDetail($id, '1');
    }

    public function orderAccept($id)
    {
        try {
            $data = CartService::find($id);
            if (!$data) {
                $json['STATUS_CODE'] = '404';
                $json['MESSAGE'] = 'Data not Found';
                $json['DATA'] = (object) null;
                return $json;
            }
            $data->status_completed = 1;
            $data->save();
            if ($data) {
                $json['STATUS_CODE'] = '200';
                $json['MESSAGE'] = 'Success';
                $json['DATA'] = $data;
                return $json;
            }
        } catch (\Exception $exception) {
            if ($exception instanceof QueryException) {
                $json['STATUS_CODE'] = '212';
                $json['MESSAGE'] = $exception->getMessage();
                $json['DATA'] = (object) null;
                return $json;
            }
            $json['STATUS_CODE'] = '500';
            $json['MESSAGE'] = $exception->getMessage() . ' - ' . $exception->getFile() . ' - L ' . $exception->getLine();
            $json['DATA'] = (object) null;
            return $json;
        }
    }

    public function petTreatmentRecord($id)
    {
        $data = CartService::join('cart_service_detail', 'cart_service_detail.cart_service_id', 'cart_services.cart_service_id')
            ->where('cart_service_detail.is_invoice', true)
            ->where('pet_id', $id)
            ->limit(5)
            ->get(['doctor_schedule_id', 'grooming_location_schedule_id', 'pet_id', 'order_code', 'order_date', 'cart_service_detail.service_type', 'service_name', 'service_id']);
        $service_type = [1 => 'Medical', 2 => 'Grooming', 3 => 'Boarding'];

        $grooming_location_schedules = implode(',', $data->pluck('grooming_location_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $doctor_schedules = implode(',', $data->pluck('doctor_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());

        $doctors = collect();
        $grooming_locations = collect();

        if (!empty($doctor_schedules)) {
            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $doctor_schedules);
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $doctors = collect($doctorResponse['DATA']);
            }
        }

        if (!empty($grooming_location_schedules)) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $grooming_location_schedules);
            if ($groomingLocationResponse['STATUS_CODE'] == '200') {
                $grooming_locations = collect($groomingLocationResponse['DATA']);
            }
        }
        $data->map(function ($item) use ($service_type, $doctors, $grooming_locations) {
            $grooming_location = $grooming_locations->where('grooming_location_schedule_id', $item->grooming_location_schedule_id)->first();
            $item->doctor_name = $doctors->where('doctor_schedule_id', $item->doctor_schedule_id)->first()['name'];
            $item->service_text = $item->service_type == '1' ? $item->doctor_name : '';
            $item->service_text = $item->service_type == '2' ? $grooming_location['location_name'] : $item->service_text;
            $item->service_text = $item->service_type == '3' ? $item->service_name : $item->service_text;
            $item['service_type'] = $service_type[$item['service_type']];

            return $item;
        });

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function recordMedical(Request $request, $id)
    {
        $limit = $request->has('limit') ? $request->input('limit') : 10;

        // CartServiceAnamnesis
        $data = CartService::join('cart_service_detail', 'cart_service_detail.cart_service_id', 'cart_services.cart_service_id')
            ->join('cart_service_anamnesis', 'cart_service_anamnesis.cart_service_id', 'cart_services.cart_service_id')
            // ->where('cart_service_detail.is_invoice', true)
            ->where('pet_id', $id)
            ->where('cart_service_detail.service_type', '1')
            ->where('cart_service_detail.service_id', '1')
            ->select([
                'pet_id',
                'cart_services.cart_service_id',
                'doctor_schedule_id',
                'order_code',
                'order_date',
                'cart_service_detail.service_type',
                'service_name',
                'service_id',
                'anamnesis',
                'diagnosis'
            ]);
        $data = $this->paging($data->paginate($limit));

        $doctor_schedules = implode(',', collect($data['items'])->pluck('doctor_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $doctors = collect();
        if (!empty($doctor_schedules)) {
            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $doctor_schedules);
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $doctors = collect($doctorResponse['DATA']);
            }
        }

        collect($data['items'])->map(function ($item) use ($doctors) {
            $item->clinical_checkup_text = AnamnesisClinicalCheckup::where('cart_service_id', $item->cart_service_id)
                // ->get([DB::raw('concat(concat(clinical_checkup_name," "),concat(value," "),clinical_checkup_unit) as text')])
                ->get([DB::raw('concat(concat(clinical_checkup_name," "),concat(value," ")) as text')])
                ->implode('text', ', ');
            $item->treatment_text = CartServiceDetail::where('cart_service_id', $item->cart_service_id)
                ->where('service_type', '1')
                ->get(['service_name'])
                ->implode('service_name', ', ');
            ;
            $item->doctor_name = $doctors->where('doctor_schedule_id', $item->doctor_schedule_id)->first()['name'];
            return $item;
        });

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function recordGrooming(Request $request, $id)
    {
        $limit = $request->has('limit') ? $request->input('limit') : 10;

        $data = CartService::join('cart_service_detail', 'cart_service_detail.cart_service_id', 'cart_services.cart_service_id')
            // ->where('cart_service_detail.is_invoice', true)
            ->where('pet_id', $id)
            ->where('cart_service_detail.service_type', '2')
            ->groupBy('order_code')
            ->select([
                'pet_id',
                'cart_services.cart_service_id',
                'grooming_location_schedule_id',
                'order_code',
                'order_date',
                'cart_service_detail.service_type',
                DB::raw("GROUP_CONCAT(service_name SEPARATOR ', ') as service_text"),
            ]);

        $data = $this->paging($data->paginate($limit));

        $grooming_location_schedules = implode(',', collect($data['items'])->pluck('grooming_location_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $grooming_locations = collect();
        if (!empty($grooming_location_schedules)) {
            $grooming_locationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $grooming_location_schedules);
            if ($grooming_locationResponse['STATUS_CODE'] == '200') {
                $grooming_locations = collect($grooming_locationResponse['DATA']);
            }
        }
        $data['items'] = collect($data['items'])->map(function ($item) use ($grooming_locations) {
            $grooming_location = $grooming_locations->where('grooming_location_schedule_id', $item->grooming_location_schedule_id)->first();
            $item->grooming_location_schedule = $grooming_location;
            return $item;
        });
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function recordBoarding(Request $request, $id)
    {
        $limit = $request->has('limit') ? $request->input('limit') : 10;

        $data = CartService::join('cart_service_detail', 'cart_service_detail.cart_service_id', 'cart_services.cart_service_id')
            // ->where('cart_service_detail.is_invoice', true)
            ->where('pet_id', $id)
            ->where('cart_service_detail.service_type', '3')
            ->select([
                'pet_id',
                'cart_services.cart_service_id',
                'boarding_schedule_id',
                'order_code',
                'order_date',
                'service_type',
                'service_name',
                'service_id'
            ]);
        $data = $this->paging($data->paginate($limit));

        $boarding_schedules = implode(',', collect($data['items'])->pluck('boarding_schedule_id')->filter(function ($val, $key) {
            return $val > 0;
        })->toArray());
        $boardings = collect();
        if (!empty($boarding_schedules)) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $boarding_schedules);
            if ($boardingResponse['STATUS_CODE'] == '200') {
                $boardings = collect($boardingResponse['DATA']);
            }
        }

        $data['items'] = collect($data['items'])->map(function ($item) use ($boardings) {
            $boarding = $boardings->where('cage_schedule_id', $item->boarding_schedule_id)->first();
            $item->boarding_schedule = $boarding;
            return $item;
        });
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function setOrderStatus(Request $request)
    {
        if ($request->filled(['order_status', 'cart_service_detail_ids', 'job'])) {

            $input = $request->all();
            $validate = CartService::isValid($input, [
                'job' => 'required|in:1,2,3',
                'cart_service_detail_ids' => 'required|array',
                'order_status' => 'required|in:1,2,3'
            ]);

            /**
             * Validate Model
             */
            if (!$validate[0]) {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Failed, Some field getting errors';
                $json['ERROR'] = $validate[1];
                return $json;
            }

            // JOB IN
            // 1: General Checkup
            // 2: Take Action
            // 3: Work Checking

            DB::beginTransaction();

            $cartServiceDetail = CartServiceDetail::whereIn('cart_service_detail_id', $request->cart_service_detail_ids)
                ->update([
                    'follow_up_at' => Carbon::now(),
                    'order_status' => $request->order_status
                ]);

            // CHECK STATUS
            $cartId = CartServiceDetail::find($request->cart_service_detail_ids[0]);
            $cartService = CartService::where("cart_service_id", $cartId->cart_service_id)->first();

            if ($request->order_status == 3) {
                if ($request->job == 1) {
                    $cartService->general_checkup_finish = date('Y-m-d H:i:s');
                } else if ($request->job == 2) {
                    $cartService->take_action_finish = date('Y-m-d H:i:s');
                } else if ($request->job == 3) {
                    $cartService->work_checking_finish = date('Y-m-d H:i:s');
                }

                $cartService->save();
            }



            //  $count = CartServiceDetail::where('order_status','!=',3)->where('cart_service_id', $cartId->cart_service_id)->count();

            //  if ($count == 0) {
            //     $cartService = CartService::where("cart_service_id", $cartId->cart_service_id)->update([
            //         'cart_service_status' => $request->order_status
            //     ]);
            //  }

            DB::commit();

            $json['DATA'] = $cartService;
            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Success';
            return $json;
        } else if ($request->filled(['cart_service_detail_id', 'order_status'])) {

            DB::beginTransaction();

            $cartServiceDetail = CartServiceDetail::find($request->cart_service_detail_id);
            if ($cartServiceDetail == null) {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Cart Service Detail not found';
                return $json;
            }
            $cartServiceDetail->follow_up_at = Carbon::now();
            $cartServiceDetail->order_status = $request->order_status;
            $cartServiceDetail->save();

            // CHECK STATUS
            $cartId = CartServiceDetail::find($request->cart_service_detail_id);
            $count = CartServiceDetail::where('order_status', '!=', 3)->where('cart_service_id', $cartId->cart_service_id)->count();

            if ($count == 0) {
                $cartService = CartService::where("cart_service_id", $cartId->cart_service_id)->update([
                    'cart_service_status' => 3
                ]);
            }

            DB::commit();

            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Success';
            return $json;
        }

        $json['STATUS_CODE'] = '400';
        $json['MESSAGE'] = 'Some field is missing';
        return $json;
    }

    public function setWoDone(Request $request)
    {
        $input = $request->all();
        $validate = CartServiceWorkOrder::isValid($input, [
            'is_done' => 'required|in:0,1',
            'wo_id' => 'required|numeric',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $wo = CartServiceWorkOrder::where('wo_id', $request->wo_id)->first();

        if (!$wo) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Data Work Order Not Found.';
            return $json;
        }

        if ($request->input('is_done') == 1) {
            $wo->wo_done_at = date('Y-m-d H:i:s');
            $wo->wo_status = 1;
        } else {
            $wo->wo_done_at = '';
            $wo->wo_status = 0;
        }
        $wo->save();

        $json['DATA'] = $wo;
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        return $json;
    }

    public function complaint(Request $request)
    {
        $input = $request->all();
        $validate = CartService::isValid($input, [
            'cart_service_id' => 'required|numeric',
            'complaint' => 'required',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $cart = CartService::where('cart_service_id', $request->cart_service_id)->first();

        if (!$cart) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Cart Service Not Found.';
            return $json;
        }

        $cart->complaint = $request->complaint;
        $cart->save();

        $json['DATA'] = $cart;
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        return $json;
    }

    /**
     * Rollback Cart Service
     * @api POST /cart/service/rollback
     * 
     * @param cart_service_id
     * @param medical_service_old[]
     * @param grooming_service_old[]
     */
    public function rollback(Request $request)
    {
        if (!$request->has('cart_service_id')) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'cart_service_id is required';
            return $json;
        }

        DB::beginTransaction();
        try {
            $cart_service = CartService::find($request->cart_service_id);
            if ($cart_service == null) {
                $json['STATUS_CODE'] = '400';
                $json['MESSAGE'] = 'Card service not found';
                return $json;
            }

            $cart_service->has_anamnesis = false;
            $clear_all_service = CartServiceDetail::where('cart_service_id', $cart_service->cart_service_id)
                ->forceDelete();

            if ($request->has('medical_service_old') && count($request->medical_service_old) >= 1) {
                $medical_service = $request->medical_service_old;
                CartServiceDetail::insert($medical_service);
                $cart_service->has_anamnesis = true;
            }

            if ($request->has('grooming_service_old') && count($request->grooming_service_old) >= 1) {
                $grooming_service = $request->grooming_service_old;
                CartServiceDetail::insert($grooming_service);
            }

            $cart_service->save();
            DB::commit();

            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Success rollback cart service';
            return $json;
        } catch (\Exception $e) {
            DB::rollback();
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Error when rollback Cart Service ' . $e->getMessage();
            return $json;
        }
    }

    function medical_record(Request $request, $pet_id)
    {
        $data = CartService::join('cart_service_detail', 'cart_service_detail.cart_service_id', 'cart_services.cart_service_id')
            ->where('cart_service_detail.is_invoice', true)
            ->where('pet_id', $pet_id)
            ->limit(5)
            ->groupBy('cart_services.cart_service_id')
            ->get([
                'cart_services.cart_service_id',
                'order_code',
                'customer_name',
                DB::raw("GROUP_CONCAT(cart_service_detail.service_name SEPARATOR ', ') AS service_text"),
                'order_date'
            ]);


        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }


    /**
     * Update Cart Service Status
     * @api POST /cart/service/status
     * 
     * @param cart_service_id
     * @param status 0: On progress|1: Canceled
     */
    public function updateCartServiceStatus(Request $request)
    {
        $input = $request->all();
        $validate = CartService::isValid($input, [
            'cart_service_id' => 'required',
            'status' => 'required|in:0,1',
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $cartService = CartService::where('cart_service_id', $request->cart_service_id)->first();
        if (!$cartService) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Cart service not found';
            return $json;
        }

        $cartService->cart_service_status = (int) $request->status;
        if ($cartService->cart_service_status == 1) {
            $cartService->cart_canceled_at = date('Y-m-d H:i:s');
        } else {
            $cartService->cart_canceled_at = NULL;
        }
        $cartService->save();

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $cartService;
        return $json;
    }


    /**
     * Get Detail
     * @api GET /cart/service/show/{id}
     * 
     * @param id
     */

    public function show(Request $request, $id)
    {
        $cartService = CartService::with([
            'items'
        ])->find($id);
        if ($cartService == null) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Cart Service Detail not found';
            return $json;
        }
        $json['DATA'] = $cartService;
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        return $json;
    }

    public function setCartJob(Request $request, $id)
    {
        $input = $request->all();
        $validate = CartService::isValid($input, [
            'job' => 'required|in:1,2,3,4'
        ]);

        /**
         * Validate Model
         */
        if (!$validate[0]) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Failed, Some field getting errors';
            $json['ERROR'] = $validate[1];
            return $json;
        }

        $data = CartService::where('cart_service_id', $id)->first();
        if (!$data) {
            $json['STATUS_CODE'] = '400';
            $json['MESSAGE'] = 'Cart service not found.';
        }

        if ($request->job == 1) {
            if (empty($data->general_checkup_start)) {
                $data->general_checkup_start = date('Y-m-d H:i:s');
                $data->work_status = 1;
            }
        } else if ($request->job == 2) {
            if (empty($data->take_action_start)) {
                $data->take_action_start = date('Y-m-d H:i:s');
                $data->work_status = 2;
            }
        } else if ($request->job == 3) {
            if (empty($data->work_checking_start) && empty($data->work_checking_finish)) {
                $data->work_checking_start = date('Y-m-d H:i:s');
                $data->work_status = 3;
            }
        } else if ($request->job == 4) {
            if (empty($data->done_at)) {
                $data->done_at = date('Y-m-d H:i:s');
                $data->work_status = 4;
                $data->cart_service_status = 3;
                $data->take_action = 1;
            }
        }

        $data->save();

        $json['DATA'] = $data;
        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Cart service successfully updated.';
        return $json;
    }
    public function uploadSignature(Request $request)
    {
        date_default_timezone_set('Asia/Bangkok');
        $input = $request->except('workChecklist');

        $exist = GeneralCheckupSignature::where('cart_service_id', $request->cart_service_id)
            ->first();
        if (!$exist) {
            $newData = new GeneralCheckupSignature();
            $newData->signature_image = $request->signature_image;
            $newData->cart_service_id = $request->cart_service_id;
            $newData->user_id = $request->login_id;
            $newData->site_id = $request->site_id;
            $newData->created_at = Carbon::now();
            $newData->updated_at = Carbon::now();
            $save = $newData->save();
            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Success';
            $json['DATA'] = (object) [];
            return $json;
        } else {
            $exist->signature_image = $request->signature_image;
            $exist->cart_service_id = $request->cart_service_id;
            $exist->user_id = $request->login_id;
            $exist->site_id = $request->site_id;
            $exist->updated_at = Carbon::now();
            $save = $exist->save();
            $json['STATUS_CODE'] = '200';
            $json['MESSAGE'] = 'Success';
            $json['DATA'] = (object) [];
            return $json;
        }

        $json['STATUS_CODE'] = '400';
        $json['MESSAGE'] = 'Failed';
        $json['DATA'] = (object) [];
        return $json;
    }
    public function updateCartV2(Request $request)
    {
        date_default_timezone_set('Asia/Bangkok');
        $input = $request->except('workChecklist');
        $json['STATUS_CODE'] = '200';

        $exist = CartService::where('cart_service_id', $request->cart_service_id)->first();
        // $exist = CartServiceDetail::where('cart_service_id', $request->cart_service_id)->where('service_id',1)
        //     ->first();
        if (!$exist) {
            $json['STATUS_CODE'] = '404';
            $json['MESSAGE'] = 'Not found';
            return $json;
        }
        DB::beginTransaction();
        // CartServiceDetail::where('cart_service_id', $request->cart_service_id)->where('service_id',1)->update([
        //     'updated_at' => Carbon::now()
        // ]);
        // CartServiceWorkOrder::where('wo_cart_service_detail_id',$exist->cart_service_detail_id)->delete();
        foreach ($input['general_checkup'] as $valGc) {
            if ($valGc != '') {
                $woData[] = [
                    'wo_cart_service_id' => $request->cart_service_id,
                    'wo_cart_service_detail_id' => 0,
                    'wo_title' => 'Vehicle Image',
                    'wo_name' => $valGc['wo_name'],
                    'wo_image' => $valGc['wo_image'] != "" ? $valGc['wo_image'] : null,
                    'wo_result_json' => !empty($valGc['wo_result_json']) ? json_encode($valGc['wo_result_json']) : json_encode([]),
                    'wo_done_at' => '',
                    'wo_status' => 3
                ];
            }
        }
        CartServiceWorkOrder::where('wo_cart_service_id', $request->cart_service_id)->delete();
        CartServiceWorkOrder::insert($woData);
        // if ($woData) $saveWo = $exist->workOrders()->saveMany($woData);
        DB::commit();
        $json['MESSAGE'] = 'SUCCESS, Exist data';

        $data = CartService::with([
            'service_medical.workOrders',
            'generalCheckup.workOrders',
            'vehicleImage',
            'signatureImage',
            'workOrder.workOrders',
            'workChecking.workOrders',
            'service_grooming',
            'service_boarding',
            'medicalItems',
            'generalCheckup.signature'
        ])->where('cart_service_id', $request->cart_service_id)->first();

        if ($data->doctor_schedule_id != 0) {

            $doctorResponse = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $data->doctor_schedule_id);
            if ($doctorResponse['STATUS_CODE'] == '200') {
                $data->doctor_schedule = collect($doctorResponse['DATA'])->first();
            }
        } else {
            $data->doctor_schedule = [
                "name" => "",
                "doctor_schedule_id" => 0,
                "staff_id" => 0,
                "reservation_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
                "schedule_times" => [],
            ];
        }

        if ($data->grooming_location_schedule_id != 0) {
            $groomingLocationResponse = $this->GET(env('SERVICE') . 'grooming-location/schedules/bulk/' . $data->grooming_location_schedule_id);
            if ($groomingLocationResponse['STATUS_CODE'] == '200') {
                $data->grooming_location_schedule = collect($groomingLocationResponse['DATA'])->first();
            }
        } else {
            $data->grooming_location_schedule = [
                "location_name" => "",
                "grooming_location_schedule_id" => 0,
                "grooming_location_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date" => "",
                "schedule_time" => "",
            ];
        }

        if ($data->boarding_schedule_id != 0) {
            $boardingResponse = $this->GET(env('SERVICE') . 'cages/schedules/bulk/' . $data->boarding_schedule_id);
            if ($boardingResponse['STATUS_CODE'] == '200') {
                $data->boarding_schedule = collect($boardingResponse['DATA'])->first();
            }
        } else {
            $data->boarding_schedule = [
                "cage_name" => "",
                "cage_price" => 0,
                "cage_schedule_id" => 0,
                "cage_id" => 0,
                "reservation_id" => 0,
                "customer_id" => 0,
                "pet_id" => 0,
                "schedule_date_from" => "",
                "schedule_date_until" => "",
            ];
        }

        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $data;
        return $json;
    }

    public function mekanikOrderList(Request $request)
    {

        $limit = $request->has('limit') ? $request->input('limit') : 10;
        $data = CartService::where('cart_service_type', '2'); //->with('items');
        if ($request->filled('site_id')) {
            $data = $data->where('site_id', $request->site_id);
        }

        $data = $data->whereNotNull('turboly_srv_ref_code')
            ->where('turboly_srv_ref_code', '!=', '');

        if ($request->has('order_code') || $request->has('turboly_srv_ref_code')) {
            $code = $request->input('order_code') ?: $request->input('turboly_srv_ref_code');
            $data = $data->where(function ($q) use ($code) {
                $q->where('turboly_srv_ref_code', 'LIKE', '%' . $code . '%');
            });
        }

        if ($request->has('customer_name')) {
            $data = $data->where('customer_name', 'LIKE', '%' . $request->input('customer_name') . '%');
        }

        if ($request->has('pet_name')) {
            $data = $data->where('pet_name', 'LIKE', '%' . $request->input('pet_name') . '%');
        }
        if ($request->has('plat_no')) {
            $data = $data->where('plat_no', 'LIKE', '%' . $request->input('plat_no') . '%');
        }

        $query_total_service = 'SELECT SUM(cart_service_detail.service_qty * cart_service_detail.service_price) FROM cart_service_detail
                                WHERE cart_service_detail.cart_service_id = cart_services.cart_service_id';
        $query_total_anamnesis = 'SELECT SUM(anamnesis_medical_item.product_qty * anamnesis_medical_item.product_price - anamnesis_medical_item.discount_amount) FROM anamnesis_medical_item
                                WHERE anamnesis_medical_item.cart_service_id = cart_services.cart_service_id';

        if ($request->has('total')) {
            $data = $data->whereRaw('(' . $query_total_service . ')+IFNULL(IF(has_anamnesis = 1,(' . $query_total_anamnesis . '),0),0) LIKE ?', ['%' . $request->input('total') . '%']);
        }

        $data->orderBy('created_at', 'desc');


        $data = $data->select(
            [
                'is_invoice',
                'payment_complete',
                'cart_service_type',
                'turboly_srv_ref_code',
                'turboly_srv_ref_code as order_code',
                'plat_no',
                'customer_name',
                'customer_id',
                'pet_id',
                'pet_name',
                'order_date',
                'updated_at',
                'doctor_schedule_id',
                'has_anamnesis',
                'cart_service_id',
                'status_completed',
                DB::raw(
                    '(' . $query_total_service . ')+IFNULL(IF(has_anamnesis = 1,(' . $query_total_anamnesis . '),0),0) as total'
                )
            ]
        );

        if ($request->has('start_date') && $request->has('end_date')) {
            $from = date($request->input('start_date'));
            $to = date($request->input('end_date'));
            $data = $data->whereBetween('order_date', [$from, $to]);
        }
        $data = $data->orderBy('order_date', 'desc');

        $all = clone $data;

        $data = $this->paging($data->paginate($limit));
        $data = json_decode(json_encode($data), true);
        foreach ($data['items'] as &$value) {
            $value['doctor'] = true;
            if ($value['doctor_schedule_id'] != 0) {
                $doc = $this->GET(env('STAFF') . 'staffs/doctors/schedules/bulk/' . $value['doctor_schedule_id']);
                if ($doc['STATUS_CODE'] == '200') {
                    $value['doctor_schedule'] = collect($doc['DATA'])->where('doctor_schedule_id', $value['doctor_schedule_id'])->first();
                }
            }
        }

        $br['page'] = $data['page'];
        $br['last_page'] = $data['last_page'];
        $br['total_item'] = $data['total_item'];
        $br['limit'] = $data['limit'];
        $br['items'] = $data['items'];




        $all = $all->get();

        $br['total_order'] = $all->count();
        $br['total'] = $all->sum('total');

        $json['STATUS_CODE'] = '200';
        $json['MESSAGE'] = 'Success';
        $json['DATA'] = $br;
        return $json;
    }
    public function finalizeService(Request $request)
    {
        if (!$request->filled('cart_service_id')) {
            return ['STATUS_CODE' => '400', 'MESSAGE' => 'cart_service_id is required'];
        }
        $cartService = CartService::find($request->cart_service_id);
        if (!$cartService) {
            return ['STATUS_CODE' => '404', 'MESSAGE' => 'Cart service not found'];
        }
        // Call createTurbolyReservation
        $turbolyResp = $this->createTurbolyReservation($cartService, $request);
        if (!is_array($turbolyResp) || !isset($turbolyResp['status']) || !in_array($turbolyResp['status'], [200, 201])) {
            Log::error('Turboly reservation failed in finalizeService', [
                'cart_service_id' => $cartService->cart_service_id,
                'response' => $turbolyResp,
            ]);
            return [
                'STATUS_CODE' => '400',
                'MESSAGE' => 'Turboly reservation failed',
                'ERROR' => $turbolyResp['error'] ?? $turbolyResp['data'] ?? $turbolyResp
            ];
        }
        // Call addCartServiceToInvoice
        $invReq = new Request(['cart_service_id' => $cartService->cart_service_id, 'site_id' => $cartService->site_id, 'created_by' => $request->created_by, 'pet_id' => $cartService->pet_id]);
        $txCtrl = new TransactionController();
        $invRes = $txCtrl->addCartServiceToInvoice($invReq);
        if (!is_array($invRes) or ($invRes['STATUS_CODE'] ?? '200') !== '200') {
            return ['STATUS_CODE' => '400', 'MESSAGE' => 'Invoice creation failed', 'ERROR' => $invRes];
        }
        return ['STATUS_CODE' => '200', 'MESSAGE' => 'Service finalized successfully', 'DATA' => $invRes['DATA']];
    }

    /**
     * Create Turboly Service Reservation
     * 
     * @param CartService $cartService
     * @param Request $request
     * @return void
     */
    private function createTurbolyReservation($cartService, $request)
    {
        try {
            // Get cart service details to build service items
            $serviceDetails = CartServiceDetail::where('cart_service_id', $cartService->cart_service_id)->get();

            $serviceItems = [];
            foreach ($serviceDetails as $detail) {
                $serviceItems[] = [
                    'description' => $detail->service_name ?? 'Service',
                ];
            }

            // Resolve customer_id from CUSTOMER microservice (avoid local DB table)
            $customerId = null;
            $petId = (int) ($cartService->pet_id ?? 0);
            if ($petId > 0) {
                $petResponse = $this->GET(env('CUSTOMER') . 'customers/pet/' . $petId);
                if (is_array($petResponse) && ($petResponse['STATUS_CODE'] ?? '') === '200') {
                    $customerId = $petResponse['DATA']['customer_id'] ?? null;
                } else {
                    Log::warning('Cannot load pet from CUSTOMER service for Turboly reservation', [
                        'cart_service_id' => $cartService->cart_service_id,
                        'pet_id' => $petId,
                        'response' => $petResponse ?? null,
                    ]);
                }
            }
            // Fallback to existing customer_id on cart if available
            if (!$customerId && !empty($cartService->customer_id)) {
                $customerId = $cartService->customer_id;
            }
            if (!$customerId) {
                Log::error('Cannot create Turboly reservation: customer_id not resolvable', [
                    'cart_service_id' => $cartService->cart_service_id,
                    'pet_id' => $cartService->pet_id,
                ]);
                return [
                    'status' => 400,
                    'error' => 'Customer ID not resolvable',
                    'data' => [
                        'STATUS_CODE' => '400',
                        'MESSAGE' => 'Cannot resolve customer_id for Turboly reservation'
                    ]
                ];
            }
            Log::info('Creating Turboly service reservation', [
                'request all' => $request->all(),
            ]);
            // Prepare payload
            $planDate = $cartService->order_date ?? date('Y-m-d');
            $planTime = $cartService->order_time ?? null;

            $payload = [
                'cart_service_id' => $cartService->cart_service_id,
                'customer_id' => $customerId,
                'pet_id' => $cartService->pet_id,
                'site_id' => $cartService->site_id,

                'plan_service_date' => date('Y-m-d', strtotime($planDate)),
                'plan_service_time' => $planTime ?: date('H:i', strtotime($planDate)),
                'service_items' => $serviceItems,
                'odometer' => $request->odometer,
                'notes' => '',
            ];

            // Call sitepat-turboly endpoint
            $turbolyUrl = env('TURBOLY_SERVICE_URL', env('TURBOLY_URL'));
            $url = $turbolyUrl . '/api/v1/service-reservation/create';

            Log::info('Calling Turboly service reservation', [
                'url' => $url,
                'payload' => $payload,
            ]);

            // Use try-catch for Guzzle call since it throws on 4xx/5xx
            try {
                $response = $this->CPostJson($url, $payload, [
                    'Authorization' => $request->header('Authorization'),
                    'Accept' => 'application/json',
                    'Content-Type' => 'application/json',
                ]);
            } catch (\GuzzleHttp\Exception\ClientException $e) {
                $errorBody = $e->getResponse() ? $e->getResponse()->getBody()->getContents() : $e->getMessage();
                Log::error('Turboly service reservation HTTP error', [
                    'cart_service_id' => $cartService->cart_service_id,
                    'status' => $e->getCode(),
                    'error' => $errorBody,
                ]);
                return [
                    'status' => $e->getCode(),
                    'error' => $errorBody,
                    'data' => [
                        'STATUS_CODE' => (string) $e->getCode(),
                        'MESSAGE' => 'Turboly API error',
                        'ERROR' => json_decode($errorBody, true) ?? $errorBody
                    ]
                ];
            } catch (\GuzzleHttp\Exception\ServerException $e) {
                $errorBody = $e->getResponse() ? $e->getResponse()->getBody()->getContents() : $e->getMessage();
                Log::error('Turboly service reservation server error', [
                    'cart_service_id' => $cartService->cart_service_id,
                    'status' => $e->getCode(),
                    'error' => $errorBody,
                ]);
                return [
                    'status' => $e->getCode(),
                    'error' => $errorBody,
                    'data' => [
                        'STATUS_CODE' => (string) $e->getCode(),
                        'MESSAGE' => 'Turboly server error',
                        'ERROR' => json_decode($errorBody, true) ?? $errorBody
                    ]
                ];
            }

            if (isset($response['status']) && ($response['status'] == 200 || $response['status'] == 201)) {
                Log::info('Turboly service reservation created successfully', [
                    'cart_service_id' => $cartService->cart_service_id,
                    'response' => $response['data'] ?? [],
                ]);

                // Extract and store the ref_code and service_reservation_id
                $responseData = $response['data'] ?? [];

                // Navigate through the nested structure to get ref_code and reservation_id
                $refCode = null;
                $reservationId = null;

                if (isset($responseData['DATA']['response']['service_reservation'])) {
                    $sr = $responseData['DATA']['response']['service_reservation'];
                    $refCode = $sr['ref_code'] ?? null;
                    $reservationId = $sr['id'] ?? null;
                } elseif (isset($responseData['response']['service_reservation'])) {
                    $sr = $responseData['response']['service_reservation'];
                    $refCode = $sr['ref_code'] ?? null;
                    $reservationId = $sr['id'] ?? null;
                } elseif (isset($responseData['service_reservation'])) {
                    $sr = $responseData['service_reservation'];
                    $refCode = $sr['ref_code'] ?? null;
                    $reservationId = $sr['id'] ?? null;
                } else {
                    $refCode = $responseData['ref_code'] ?? null;
                    $reservationId = $responseData['id'] ?? $responseData['service_reservation_id'] ?? null;
                }

                $updated = false;
                if (!empty($refCode)) {
                    //  $cartService->note = $refCode;
                    $cartService->turboly_srv_ref_code = $refCode;
                    $updated = true;
                    Log::info('Stored Turboly ref_code in note', ['ref_code' => $refCode]);
                }
                if (!empty($reservationId)) {
                    $cartService->turboly_service_reservation_id = $reservationId;
                    $updated = true;
                    Log::info('Stored Turboly service_reservation_id', ['reservation_id' => $reservationId]);
                }
                if ($updated) {
                    $cartService->save();
                }
                if (empty($refCode) && empty($reservationId)) {
                    Log::warning('Ref code and reservation_id not found in Turboly response', ['data' => $responseData]);
                }

                return $response;
            } else {
                Log::warning('Turboly service reservation failed', [
                    'cart_service_id' => $cartService->cart_service_id,
                    'response' => $response,
                ]);
                return $response;
            }
        } catch (\Exception $e) {
            Log::error('Error creating Turboly service reservation', [
                'cart_service_id' => $cartService->cart_service_id ?? null,
                'error' => $e->getMessage(),
                'trace' => $e->getTraceAsString(),
            ]);
            // Return error response instead of silently failing
            return [
                'status' => 500,
                'error' => $e->getMessage(),
                'data' => [
                    'STATUS_CODE' => '500',
                    'MESSAGE' => 'Exception creating Turboly reservation',
                    'ERROR' => $e->getMessage()
                ]
            ];
        }
    }

    private function calculateServiceDetailSubtotal($item): float
    {
        $qty = (float) ($item['service_qty'] ?? 1);
        $priceExTax = (float) ($item['service_price'] ?? 0);
        $taxValue = (float) ($item['tax_value'] ?? 0);
        $taxRate = (float) ($item['tax_rate'] ?? 0);
        $priceAfterTax = (float) ($item['price_after_tax'] ?? 0);
        $lineExTax = $qty * $priceExTax;

        if ($priceAfterTax > 0) {
            if ($priceAfterTax >= $lineExTax) {
                return $priceAfterTax;
            }

            return $qty * $priceAfterTax;
        }

        if ($taxValue > 0) {
            return $lineExTax + $taxValue;
        }

        if ($taxRate > 0) {
            return $lineExTax * (1 + $taxRate);
        }

        return $lineExTax;
    }

    private function getServiceDetailSubtotalSql(): string
    {
        return 'SELECT SUM(
            IF(
                cart_service_detail.price_after_tax > 0,
                IF(
                    cart_service_detail.price_after_tax >= (cart_service_detail.service_qty * cart_service_detail.service_price),
                    cart_service_detail.price_after_tax,
                    cart_service_detail.service_qty * cart_service_detail.price_after_tax
                ),
                IF(
                    cart_service_detail.tax_value > 0,
                    (cart_service_detail.service_qty * cart_service_detail.service_price) + cart_service_detail.tax_value,
                    IF(
                        cart_service_detail.tax_rate > 0,
                        (cart_service_detail.service_qty * cart_service_detail.service_price) * (1 + cart_service_detail.tax_rate),
                        cart_service_detail.service_qty * cart_service_detail.service_price
                    )
                )
            )
        ) FROM cart_service_detail WHERE cart_service_detail.cart_service_id = cart_services.cart_service_id';
    }

    /**
     * Send Discord notification for transaction webhook debugging
     */
    protected function sendTransactionWebhookNotification(string $title, array $data): void
    {
        try {
            $webhookUrl = 'https://discord.com/api/webhooks/1460167872427986956/HlZpS_6hb2YnApVf_bKl0kptDtE6zvqhZ-3qOqgYzcEM9C9VgBNjqzrVfheBym8Hd6c8';

            $content = "**{$title}**\n```json\n" . json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES) . "\n```";

            $client = new \GuzzleHttp\Client(['timeout' => 5, 'http_errors' => false]);
            $client->post($webhookUrl, [
                'json' => [
                    'content' => substr($content, 0, 2000), // Discord limit
                ],
            ]);
        } catch (\Throwable $e) {
            Log::warning('Discord notification failed', ['error' => $e->getMessage()]);
        }
    }
}

