One Hat Cyber Team

Edit File: Booking.php

<?php
namespace Modules\Booking\Models;

use App\BaseModel;
use Eluceo\iCal\Component\Calendar;
use Eluceo\iCal\Component\Event;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Mail;
use Mockery\Exception;
use Modules\Booking\Emails\NewBookingEmail;
use Modules\Booking\Emails\StatusUpdatedEmail;
use Modules\Booking\Events\BookingUpdatedEvent;
use Modules\Booking\Traits\HasPassenger;
use Modules\Coupon\Models\CouponBookings;
use Modules\Hotel\Models\HotelRoomBooking;
use Modules\Space\Models\Space;
use Modules\Tour\Models\Tour;
use App\User;
use Illuminate\Database\Eloquent\SoftDeletes;
use Modules\User\Models\Wallet\Transaction;
use Modules\Booking\Models\BookingTimeSlots;

class Booking extends BaseModel
{
    use SoftDeletes;
    use HasPassenger;
    protected $table      = 'bravo_bookings';
    protected $cachedMeta = [];
    //protected $cachedMetaArr = [];
    const DRAFT      = 'draft'; // New booking, before payment processing
    const UNPAID     = 'unpaid'; // Require payment
    const PROCESSING = 'processing'; // like offline - payment
    const CONFIRMED  = 'confirmed'; // after processing -> confirmed (for offline payment)
    const COMPLETED  = 'completed'; //
    const CANCELLED  = 'cancelled';
    const PAID       = 'paid'; //
    const PARTIAL_PAYMENT       = 'partial_payment'; //

protected $casts = [
        'commission' => 'array',
        'vendor_service_fee' => 'array',
    ];

public static $notAcceptedStatus = [
        'draft','cancelled','unpaid'
    ];

public function getGatewayObjAttribute()
    {
        return $this->gateway ? get_payment_gateway_obj($this->gateway) : false;
    }

public function getStatusNameAttribute()
    {
        return booking_status_to_text($this->status);
    }

public function getStatusClassAttribute()
    {
        switch ($this->status) {
            case "processing":
                return "primary";
                break;
            case "completed":
                return "success";
                break;
            case "confirmed":
                return "info";
                break;
            case "cancelled":
                return "danger";
                break;
            case "paid":
                return "info";
                break;
            case "partial_payment":
                return "warning";
                break;
        }
    }

public function service()
    {
        $all = get_bookable_services();
        if ($this->object_model and !empty($all[$this->object_model])) {
            return $this->hasOne($all[$this->object_model], 'id', 'object_id');
        }
        return null;
    }

public function payment()
    {
        return $this->hasOne(Payment::class, 'id', 'payment_id');
    }

public function getCheckoutUrl()
    {
        $is_api = request()->segment(1) == 'api';
        return url(($is_api ? 'api/' : '').app_get_locale(false,false , "/").config('booking.booking_route_prefix') . '/' . $this->code . '/checkout');
    }

public function getDetailUrl($full = true)
    {
        $is_api = request()->segment(1) == 'api';
        if (!$full) {
            return ($is_api ? 'api/' : '').app_get_locale(false,false , "/").config('booking.booking_route_prefix') . '/' . $this->code;
        }
        if($is_api){
            return route('booking.thankyou',['code'=>$this->code,'token'=>request()->input('token')]);
        }
        return url(($is_api ? 'api/' : '').app_get_locale(false,false , "/").config('booking.booking_route_prefix') . '/' . $this->code);
    }

public function getAllMeta()
    {
        $meta = DB::table('bravo_booking_meta')->select(['name','val'])->where([
            'booking_id' => $this->id,
        ])->get();
        if (!empty($meta)) {
            return $meta;
        }
        return false;
    }

public function getMeta($key, $default = '')
    {
        //if(isset($this->cachedMeta[$key])) return $this->cachedMeta[$key];
        $val = DB::table('bravo_booking_meta')->where([
            'booking_id' => $this->id,
            'name'       => $key
        ])->first();
        if (!empty($val)) {
            //$this->cachedMeta[$key]  = $val->val;
            return $val->val;
        }
        return $default;
    }

public function getJsonMeta($key, $default = [])
    {
        $meta = $this->getMeta($key, $default);
        if(empty($meta)) return false;
        return json_decode($meta, true);
    }

public function addMeta($key, $val, $multiple = false)
    {

if (is_object($val) or is_array($val))
            $val = json_encode($val);
        if ($multiple) {
            return DB::table('bravo_booking_meta')->insert([
                'name'       => $key,
                'val'        => $val,
                'booking_id' => $this->id
            ]);
        } else {
            $old = DB::table('bravo_booking_meta')->where([
                'booking_id' => $this->id,
                'name'       => $key
            ])->first();
            if ($old) {

return DB::table('bravo_booking_meta')->where('id', $old->id)->update([
                    'val' => $val
                ]);

} else {
                return DB::table('bravo_booking_meta')->insert([
                    'name'       => $key,
                    'val'        => $val,
                    'booking_id' => $this->id
                ]);
            }
        }
    }

public function batchInsertMeta($metaArrs = [])
    {
        if (!empty($metaArrs)) {
            foreach ($metaArrs as $key => $val) {
                $this->addMeta($key, $val, true);
            }
        }
    }

public function generateCode()
    {
        return md5(uniqid() . rand(0, 99999));
    }

public function save(array $options = [])
    {
        if (empty($this->code))
            $this->code = $this->generateCode();

if (!empty($this->coupon_amount))
            $this->updateStatusCoupons();

return parent::save($options); // TODO: Change the autogenerated stub
    }

public function markAsProcessing($payment, $service)
    {

$this->status = static::PROCESSING;
        $this->save();
        event(new BookingUpdatedEvent($this));
    }

public function markAsPaid()
 {
 if($this->paid < $this->total){
 $this->status = static::PARTIAL_PAYMENT;
 }else{
 $this->status = static::PAID;
 }

$this->save();
        event(new BookingUpdatedEvent($this));
    }

public function markAsPaymentFailed(){

$this->status = static::UNPAID;
        $this->tryRefundToWallet();
        $this->save();
        event(new BookingUpdatedEvent($this));

}

public function sendNewBookingEmails()
    {
        try {
            // To Admin
            Mail::to(setting_item('admin_email'))->send(new NewBookingEmail($this, 'admin'));

// to Vendor
            Mail::to(User::find($this->vendor_id))->send(new NewBookingEmail($this, 'vendor'));

// To Customer
            Mail::to($this->email)->send(new NewBookingEmail($this, 'customer'));

}catch (\Exception | \Swift_TransportException $exception){

Log::warning('sendNewBookingEmails: '.$exception->getMessage());
        }
    }

public function sendStatusUpdatedEmails(){
        // Try to update locale
        $old = app()->getLocale();

$bookingLocale = $this->getMeta('locale');
        if($bookingLocale){
            app()->setLocale($bookingLocale);
        }
        try{
            // To Admin
            Mail::to(setting_item('admin_email'))->send(new StatusUpdatedEmail($this,'admin'));

// to Vendor
            Mail::to(User::find($this->vendor_id))->send(new StatusUpdatedEmail($this,'vendor'));

// To Customer
            Mail::to($this->email)->send(new StatusUpdatedEmail($this,'customer'));

app()->setLocale($old);

} catch(\Exception $e){

Log::warning('sendStatusUpdatedEmails: '.$e->getMessage());

}

app()->setLocale($old);
    }

/**
     * Get Location
     *
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function vendor()
    {
        return $this->hasOne(User::class, "id", 'vendor_id');
    }

public static function getRecentBookings($limit = 10,$vendor_id = false)
    {
        $q = parent::where('status', '!=', 'draft');
        if(!empty($vendor_id)){
            $q->where('vendor_id', $vendor_id);
        }
        return $q->orderBy('id', 'desc')->limit($limit)->get();
    }

public static function getTopCardsReport()
    {

$res = [];
        $total_data = parent::selectRaw('sum(`total`) as total_price , sum( `total` - `total_before_fees` + `commission` - `vendor_service_fee_amount` ) AS total_earning ')->whereNotIn('status',static::$notAcceptedStatus)->first();
        $total_booking = parent::whereNotIn('status',static::$notAcceptedStatus)->count('id');
        $total_service = 0;
        $services = get_bookable_services();
        if(!empty($services))
        {
            foreach ($services as $service){
                $total_service += $service::where('status', 'publish')->count('id');
            }
        }
        $res[] = [
            'size'   => 6,
            'size_md'=>3,
            'title'  => __("Revenue"),
            'amount' => format_money_main($total_data->total_price),
            'desc'   => __("Total revenue"),
            'class'  => 'purple',
            'icon'   => 'icon ion-ios-cart'
        ];
        $res[] = [
            'size'   => 6,
            'size_md'=>3,
            'title'  => __("Earning"),
            'amount' => format_money_main($total_data->total_earning),
            'desc'   => __("Total Earning"),
            'class'  => 'pink',
            'icon'   => 'icon ion-ios-gift'
        ];
        $res[] = [

'size'   => 6,
            'size_md'=>3,
            'title'  => __("Bookings"),
            'amount' => $total_booking,
            'desc'   => __("Total bookings"),
            'class'  => 'info',
            'icon'   => 'icon ion-ios-pricetags'
        ];
        $res[] = [

'size'   => 6,
            'size_md'=>3,
            'title'  => __("Services"),
            'amount' => $total_service,
            'desc'   => __("Total bookable services"),
            'class'  => 'success',
            'icon'   => 'icon ion-ios-flash'
        ];
        return $res;
    }

public static function getDashboardChartData($from, $to)
 {
 $data = [
 'labels' => [],
 'datasets' => [
 [
 'label' => __("Total Revenue"),
 'data' => [],
 'backgroundColor' => '#8892d6',
 'stack' => 'group-total',
 ],
 [
 'label' => __("Total Earning"),
 'data' => [],
 'backgroundColor' => '#F06292',
 'stack' => 'group-extra',
 ]
 ]
 ];
 $sql_raw[] = 'sum(`total`) as total_price';
 $sql_raw[] = 'sum( `total` - `total_before_fees` + `commission` - `vendor_service_fee_amount` ) AS total_earning';
 if (($to - $from) / DAY_IN_SECONDS > 90) {
 $year = date("Y", $from);
 // Report By Month
 for ($month = 1; $month <= 12; $month++) {
 $day_last_month = date("t", strtotime($year . "-" . $month . "-01"));
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->whereBetween('created_at', [
 $year . '-' . $month . '-01 00:00:00',
 $year . '-' . $month . '-' . $day_last_month . ' 23:59:59'
 ])->whereNotIn('status',static::$notAcceptedStatus);
 if (!empty($customer_id)) {
 $dataBooking = $dataBooking->where('customer_id', $customer_id);
 }
 if (!empty($vendor_id)) {
 $dataBooking = $dataBooking->where('vendor_id', $vendor_id);
 }
 $dataBooking = $dataBooking->first();
 $data['labels'][] = date("F", strtotime($year . "-" . $month . "-01"));
 $data['datasets'][0]['data'][] = $dataBooking->total_price ?? 0;
 $data['datasets'][1]['data'][] = $dataBooking->total_earning ?? 0;
 }
 } elseif (($to - $from) <= DAY_IN_SECONDS) {
 // Report By Hours

for ($i = strtotime(date('Y-m-d', $from)); $i <= strtotime(date('Y-m-d 23:59:59', $to)); $i += HOUR_IN_SECONDS) {
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->whereBetween('created_at', [
 date('Y-m-d H:i:s', $i),
 date('Y-m-d H:i:s', $i + HOUR_IN_SECONDS - 1),
 ])->whereNotIn('status',static::$notAcceptedStatus);
 if (!empty($customer_id)) {
 $dataBooking = $dataBooking->where('customer_id', $customer_id);
 }
 if (!empty($vendor_id)) {
 $dataBooking = $dataBooking->where('vendor_id', $vendor_id);
 }
 $dataBooking = $dataBooking->first();
 $data['labels'][] = date('H:i', $i);
 $data['datasets'][0]['data'][] = $dataBooking->total_price ?? 0;
 $data['datasets'][1]['data'][] = $dataBooking->total_earning ?? 0;
 }
 } else {
 // Report By Day
 $period = periodDate(date('Y-m-d', $from),date('Y-m-d 23:59:59', $to));
 foreach ($period as $dt){
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->whereBetween('created_at', [
 $dt->format('Y-m-d 00:00:00'),
 $dt->format('Y-m-d 23:59:59'),
 ])->whereNotIn('status',static::$notAcceptedStatus);
 if (!empty($customer_id)) {
 $dataBooking = $dataBooking->where('customer_id', $customer_id);
 }
 if (!empty($vendor_id)) {
 $dataBooking = $dataBooking->where('vendor_id', $vendor_id);
 }
 $dataBooking = $dataBooking->first();
 $data['labels'][] = display_date($dt->getTimestamp());
 $data['datasets'][0]['data'][] = $dataBooking->total_price ?? 0;
 $data['datasets'][1]['data'][] = $dataBooking->total_earning ?? 0;
 }
 }
 return $data;
 }

public static function getBookingHistory($booking_status = false, $customer_id_or_name = false , $vendor_id = false , $service = false , $from = false ,  $to = false )
    {
        $list_booking = parent::query()->orderBy('id', 'desc');
        if (!empty($booking_status)) {
            $list_booking->where("status", $booking_status);
        }else{
            $list_booking->where('status','!=','draft');
        }
        if (!empty($customer_id_or_name)) {
            $list_booking->where(function($q) use($customer_id_or_name){
                $q->orWhere('customer_id',$customer_id_or_name)->orWhere('first_name','like',"%$customer_id_or_name%")->orWhere('last_name','like',"%$customer_id_or_name%");
            });
        }
        if (!empty($vendor_id)) {
            $list_booking->where("vendor_id", $vendor_id);
        }
        if (!empty($service)) {
            $list_booking->where("object_model", $service);
        }
        if(!empty($from) and !empty($to)){
            $list_booking->whereBetween('created_at', [
                $from." 00:00",
                $to." 23:59",
            ]);
        }

$list_booking->whereIn('object_model', array_keys(get_bookable_services()));
        return $list_booking->paginate(10);
    }

public static function getTopCardsReportForVendor($user_id)
    {

$res = [];
        $total_money = parent::selectRaw('sum( `total_before_fees` - `commission` + `vendor_service_fee_amount` ) AS total_price , sum( CASE WHEN `status` = "completed" THEN `total_before_fees` - `commission` + `vendor_service_fee_amount` ELSE NULL END ) AS total_earning')->whereNotIn('status',static::$notAcceptedStatus)->where("vendor_id", $user_id)->first();
        $total_booking = parent::whereNotIn('status',static::$notAcceptedStatus)->where("vendor_id", $user_id)->count('id');
        $total_service = 0;
        $services = get_bookable_services();
        if(!empty($services))
        {
            foreach ($services as $service){
                $total_service += $service::where('status', 'publish')->where("create_user", $user_id)->count('id');
            }
        }
        $res[] = [
            'title'  => __("Pending"),
            'amount' => format_money_main($total_money->total_price - $total_money->total_earning),
            'desc'   => __("Total pending"),
            'class'  => 'purple',
            'icon'   => 'icon ion-ios-cart'
        ];
        $res[] = [
            'title'  => __("Earnings"),
            'amount' => format_money_main($total_money->total_earning ?? 0),
            'desc'   => __("Total earnings"),
            'class'  => 'info',
            'icon'   => 'icon ion-ios-gift'
        ];
        $res[] = [
            'title'  => __("Bookings"),
            'amount' => $total_booking,
            'desc'   => __("Total bookings"),
            'class'  => 'pink',
            'icon'   => 'icon ion-ios-pricetags'
        ];
        $res[] = [
            'title'  => __("Services"),
            'amount' => $total_service,
            'desc'   => __("Total bookable services"),
            'class'  => 'success',
            'icon'   => 'icon ion-ios-flash'
        ];
        return $res;
    }

public static function getEarningChartDataForVendor($from, $to, $user_id)
 {
 $data = [
 'labels' => [],
 'datasets' => [
 [
 'label' => __("Total Earning"),
 'data' => [],
 'backgroundColor' => '#F06292'
 ],
 [
 'label' => __("Total Pending"),
 'data' => [],
 'backgroundColor' => '#8892d6'
 ]
 ]
 ];
 $sql_raw[] = 'sum( `total_before_fees` - `commission` + `vendor_service_fee_amount`) AS total_price';
 $sql_raw[] = 'sum( CASE WHEN `status` = "completed" THEN `total_before_fees` - `commission` + `vendor_service_fee_amount` ELSE NULL END ) AS total_earning';
 if (($to - $from) / DAY_IN_SECONDS > 90) {
 $year = date("Y", $from);
 // Report By Month
 for ($month = 1; $month <= 12; $month++) {
 $day_last_month = date("t", strtotime($year . "-" . $month . "-01"));
 $data['labels'][] = date("F", strtotime($year . "-" . $month . "-01"));
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->where("vendor_id", $user_id)->whereBetween('created_at', [
 $year . '-' . $month . '-01 00:00:00',
 $year . '-' . $month . '-' . $day_last_month . ' 23:59:59'
 ])->whereNotIn('status',static::$notAcceptedStatus);
 $dataBooking = $dataBooking->first();
 $data['datasets'][1]['data'][] = $dataBooking->total_price - $dataBooking->total_earning;
 $data['datasets'][0]['data'][] = $dataBooking->total_earning ?? 0;
 }
 } elseif (($to - $from) <= DAY_IN_SECONDS) {
 // Report By Hours
 for ($i = strtotime(date('Y-m-d', $from)); $i <= strtotime(date('Y-m-d 23:59:59', $to)); $i += HOUR_IN_SECONDS) {
 $data['labels'][] = date('H:i', $i);
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->where("vendor_id", $user_id)->whereBetween('created_at', [
 date('Y-m-d H:i:s', $i),
 date('Y-m-d H:i:s', $i + HOUR_IN_SECONDS - 1),
 ])->whereNotIn('status',static::$notAcceptedStatus);
 $dataBooking = $dataBooking->first();
 $data['datasets'][1]['data'][] = $dataBooking->total_price - $dataBooking->total_earning;
 $data['datasets'][0]['data'][] = $dataBooking->total_earning ?? 0;
 }
 } else {
 // Report By Day
 for ($i = strtotime(date('Y-m-d', $from)); $i <= strtotime(date('Y-m-d 23:59:59', $to)); $i += DAY_IN_SECONDS) {
 $data['labels'][] = display_date($i);
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->where("vendor_id", $user_id)->whereBetween('created_at', [
 date('Y-m-d 00:00:00', $i),
 date('Y-m-d 23:59:59', $i),
 ])->whereNotIn('status',static::$notAcceptedStatus);
 $dataBooking = $dataBooking->first();
 $data['datasets'][1]['data'][] = $dataBooking->total_price - $dataBooking->total_earning;
 $data['datasets'][0]['data'][] = $dataBooking->total_earning ?? 0;
 }
 }
 return $data;
 }

public static function countBookingByServiceID($service_id = false, $user_id = false, $status = false)
    {
        if (empty($service_id))
            return false;
        $count = parent::query()->where("object_id", $service_id);

if (!empty($status)) {
            if(is_array($status)){
                $count->whereIn("status", $status);
            }else{
                $count->where("status", $status);
            }
        }

if (!empty($user_id)) {
            $count->where("customer_id", $user_id);
        }
        return $count->count("id");
    }

public static function getAcceptedBookingQuery($service_id,$object_type){

$q = static::query();

return $q->where([
            ['object_id','=',$service_id],
            ['object_model','=',$object_type],
        ])->whereNotIn('status',static::$notAcceptedStatus);

}

public static function clearDraftBookings($day = 2)
    {
        return true;
    }

public static function getStatisticChartData($from, $to, $statuses = false, $customer_id = false, $vendor_id = false)
 {
 // fix ver 1.5.1
 if ($statuses) {
 $list_statuses = [];
 foreach ($statuses as $status) {
 if(!in_array($status , static::$notAcceptedStatus) ){
 $list_statuses[] = $status;
 }
 }
 $statuses = $list_statuses;
 }
 $data = [
 "chart" => [
 'labels' => [],
 'datasets' => [
 [
 'label' => __("Total Revenue"),
 'data' => [],
 'backgroundColor' => '#8892d6',
 'stack' => 'group-total',
 ],
 [
 'label' => __("Total Fees"),
 'data' => [],
 'backgroundColor' => '#45bbe0',
 'stack' => 'group-extra',
 ],
 [
 'label' => __("Total Commission"),
 'data' => [],
 'backgroundColor' => '#F06292',
 'stack' => 'group-extra',
 ]
 ]
 ],
 "detail" => [
 "total_booking" => [
 "title" => __("Total Booking"),
 "val" => 0,
 ],
 "total_price" => [
 "title" => __("Total Revenue"),
 "val" => 0,
 ],
 "total_commission" => [
 "title" => __("Total Commission"),
 "val" => 0,
 ],
 "total_fees" => [
 "title" => __("Total Fees"),
 "val" => 0,
 ],
 "total_earning" => [
 "title" => __("Total Earning"),
 "val" => 0,
 ],
 ]
 ];
 $sql_raw[] = 'sum(`total`) as total_price';
 $sql_raw[] = 'sum( CASE WHEN `total_before_fees` > 0 THEN `total` - `total_before_fees` - `vendor_service_fee_amount` ELSE null END ) AS total_fees';
 $sql_raw[] = 'sum( `commission` ) AS total_commission';
 if ($statuses) {
 $sql_raw[] = "count( CASE WHEN `status` != 'draft' THEN id ELSE NULL END ) AS total_booking";
 foreach ($statuses as $status) {
 if(!in_array($status , static::$notAcceptedStatus) ){
 $sql_raw[] = "count( CASE WHEN `status` = '{$status}' THEN id ELSE NULL END ) AS {$status}";
 }
 }
 }
 if (($to - $from) / DAY_IN_SECONDS > 90) {
 $year = date("Y", $from);
 // Report By Month
 for ($month = 1; $month <= 12; $month++) {
 $day_last_month = date("t", strtotime($year . "-" . $month . "-01"));
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->whereBetween('created_at', [
 $year . '-' . $month . '-01 00:00:00',
 $year . '-' . $month . '-' . $day_last_month . ' 23:59:59'
 ])->whereNotIn('status',static::$notAcceptedStatus);
 if (!empty($customer_id)) {
 $dataBooking = $dataBooking->where('customer_id', $customer_id);
 }
 if (!empty($vendor_id)) {
 $dataBooking = $dataBooking->where('vendor_id', $vendor_id);
 }
 $dataBooking = $dataBooking->first();
 $data['chart']['labels'][] = date("F", strtotime($year . "-" . $month . "-01"));
 $data['chart']['datasets'][0]['data'][] = $dataBooking->total_price ?? 0; // for total price
 $data['chart']['datasets'][1]['data'][] = $dataBooking->total_fees ?? 0; // for total fees
 $data['chart']['datasets'][2]['data'][] = $dataBooking->total_commission ?? 0; // for total commission
 $data['detail']['total_price']['val'] += ($dataBooking->total_price ?? 0);
 $data['detail']['total_booking']['val'] += $dataBooking->total_booking ?? 0;
 $data['detail']['total_commission']['val'] += $dataBooking->total_commission ?? 0;
 $data['detail']['total_fees']['val'] += $dataBooking->total_fees ?? 0;
 $data['detail']['total_earning']['val'] += ( $dataBooking->total_fees + $dataBooking->total_commission );
 if ($statuses) {
 foreach ($statuses as $status) {
 $data['detail'][$status]['title'] = booking_status_to_text($status);
 $data['detail'][$status]['val'] = ($data['detail'][$status]['val'] ?? 0) + $dataBooking->$status ?? 0;
 }
 }
 }
 } elseif (($to - $from) <= DAY_IN_SECONDS) {
 // Report By Hours
 for ($i = strtotime(date('Y-m-d', $from)); $i <= strtotime(date('Y-m-d 23:59:59', $to)); $i += HOUR_IN_SECONDS) {
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->whereBetween('created_at', [
 date('Y-m-d H:i:s', $i),
 date('Y-m-d H:i:s', $i + HOUR_IN_SECONDS - 1),
 ])->whereNotIn('status',static::$notAcceptedStatus);
 if (!empty($customer_id)) {
 $dataBooking = $dataBooking->where('customer_id', $customer_id);
 }
 if (!empty($vendor_id)) {
 $dataBooking = $dataBooking->where('vendor_id', $vendor_id);
 }
 $dataBooking = $dataBooking->first();
 $data['chart']['labels'][] = date('H:i', $i);
 $data['chart']['datasets'][0]['data'][] = $dataBooking->total_price ?? 0; // for total price
 $data['chart']['datasets'][1]['data'][] = $dataBooking->total_fees ?? 0; // for total fees
 $data['chart']['datasets'][2]['data'][] = $dataBooking->total_commission ?? 0; // for total commission
 $data['detail']['total_price']['val'] += ($dataBooking->total_price ?? 0);
 $data['detail']['total_booking']['val'] += $dataBooking->total_booking ?? 0;
 $data['detail']['total_commission']['val'] += $dataBooking->total_commission ?? 0;
 $data['detail']['total_fees']['val'] += $dataBooking->total_fees ?? 0;
 $data['detail']['total_earning']['val'] += ( $dataBooking->total_fees + $dataBooking->total_commission );
 if ($statuses) {
 foreach ($statuses as $status) {
 $data['detail'][$status]['title'] = booking_status_to_text($status);
 $data['detail'][$status]['val'] = ($data['detail'][$status]['val'] ?? 0) + $dataBooking->$status ?? 0;
 }
 }
 }
 } else {
 // Report By Day
 for ($i = strtotime(date('Y-m-d', $from)); $i <= strtotime(date('Y-m-d 23:59:59', $to)); $i += DAY_IN_SECONDS) {
 $dataBooking = parent::selectRaw(implode(",", $sql_raw))->whereBetween('created_at', [
 date('Y-m-d 00:00:00', $i),
 date('Y-m-d 23:59:59', $i),
 ])->whereNotIn('status',static::$notAcceptedStatus);
 if (!empty($customer_id)) {
 $dataBooking = $dataBooking->where('customer_id', $customer_id);
 }
 if (!empty($vendor_id)) {
 $dataBooking = $dataBooking->where('vendor_id', $vendor_id);
 }
 $dataBooking = $dataBooking->first();
 $data['chart']['labels'][] = display_date($i);
 $data['chart']['datasets'][0]['data'][] = $dataBooking->total_price ?? 0; // for total price
 $data['chart']['datasets'][1]['data'][] = $dataBooking->total_fees ?? 0; // for total fees
 $data['chart']['datasets'][2]['data'][] = $dataBooking->total_commission ?? 0; // for total commission
 $data['detail']['total_price']['val'] += ($dataBooking->total_price ?? 0);
 $data['detail']['total_booking']['val'] += $dataBooking->total_booking ?? 0;
 $data['detail']['total_commission']['val'] += $dataBooking->total_commission ?? 0;
 $data['detail']['total_fees']['val'] += $dataBooking->total_fees ?? 0;
 $data['detail']['total_earning']['val'] += ( $dataBooking->total_fees + $dataBooking->total_commission );
 if ($statuses) {
 foreach ($statuses as $status) {
 $data['detail'][$status]['title'] = booking_status_to_text($status);
 $data['detail'][$status]['val'] = ($data['detail'][$status]['val'] ?? 0) + $dataBooking->$status ?? 0;
 }
 }
 }
 }
 $data['detail']['total_price']['val'] = format_money_main($data['detail']['total_price']['val']);
 $data['detail']['total_commission']['val'] = format_money_main($data['detail']['total_commission']['val']);
 $data['detail']['total_fees']['val'] = format_money_main($data['detail']['total_fees']['val']);
 $data['detail']['total_earning']['val'] = format_money_main($data['detail']['total_earning']['val']);
 return $data;
 }

public function getDurationNightsAttribute(){

$days = max(1,floor((strtotime($this->end_date) - strtotime($this->start_date)) / DAY_IN_SECONDS));

return $days;
    }
    public function getDurationDaysAttribute(){

$days = max(1,floor((strtotime($this->end_date) - strtotime($this->start_date)) / DAY_IN_SECONDS) + 1 );
        return $days;
    }
    public function getDurationHoursAttribute(){

$days = max(1,floor((strtotime($this->end_date) - strtotime($this->start_date)) / HOUR_IN_SECONDS) );
        return $days;
    }

public function  checkMaximumBooking($date){

}

public static function getBookingInRanges($object_id,$object_model,$from,$to,$object_child_id = false){

$query = parent::selectRaw(" * , SUM( total_guests ) as total_guests ")->where([
 'object_id'=>$object_id,
 'object_model'=>$object_model,
 ])->whereNotIn('status',static::$notAcceptedStatus)
 ->where('end_date','>=',$from)
 ->where('start_date','<=',$to)
 ->groupBy('start_date')
 ->take(200);

if($object_child_id){
            $query->where('object_child_id',$object_child_id);
        }

return $query->get();
    }
    public static function getAllBookingInRanges($object_id,$object_model,$from,$to){

$query = parent::selectRaw("*")->where([
 'object_id'=>$object_id,
 'object_model'=>$object_model,
 ])->whereNotIn('status',static::$notAcceptedStatus)
 ->where('end_date','>=',$from)
 ->where('start_date','<=',$to)
 ->take(200);
 return $query->get();
 }
 public function getCommissionVendor(){
 $vendorId = $this->vendor_id;
 $total = $this->total_before_fees;
 $returnArray=[
 'commission'=>0,
 'commission_type'=>'',
 ];
 if (setting_item('vendor_enable') == 1) {
 $vendor = User::find($vendorId);
 if (!empty($vendor)) {
 $commission = [];
 $commission['amount'] = setting_item('vendor_commission_amount', 10);
 $commission['type'] = setting_item('vendor_commission_type', 'percent');

if($vendor->vendor_commission_type){
                    $commission['type'] = $vendor->vendor_commission_type;
                }
                if($vendor->vendor_commission_amount){
                    $commission['amount'] = $vendor->vendor_commission_amount;
                }

if($commission['type'] == 'disable'){
                    return $returnArray;
                }

if ($commission['type'] == 'percent') {
                    $returnArray['commission'] = (float)($total / 100) * $commission['amount'];
                } else {
                    $returnArray['commission']= (float)min($total,$commission['amount']);
                }
                $returnArray['commission_type'] = json_encode($commission);
            }
        }
        return $returnArray;
    }

public function calculateCommission(){
        $data = $this->getCommissionVendor();

$this->commission = $data['commission'];
        $this->commission_type = $data['commission_type'];
    }

public static function getContentCalendarIcal($service_type,$id,$module){
		$proid = config('app.name') . ' ' . $_SERVER['SERVER_NAME'];
		$calendar = new Calendar($proid);
		$data = app()->make($module)::find($id);
		if (!empty($data)) {
 $availabilityData = $data->availabilityClass::where(['target_id'=>$id,'active'=>0])->get();
 if(!empty($availabilityData)){
 foreach ($availabilityData as $availabilityDatum){
 $eventCalendar = new Event();
 $eventCalendar
 ->setUniqueId($data->id.time())
 ->setCategories(ucfirst($service_type))
 ->setDtStart(new \DateTime($availabilityDatum->start_date))
 ->setDtEnd(new \DateTime($availabilityDatum->end_date))
 ->setSummary($data->title . '#'.$id.' Blocked')
 ->setNoTime(false);
 $calendar->addComponent($eventCalendar);
 }
 }
			$bookingData = self::where('object_id', $id)->where('object_model', $service_type)
				->whereNotIn('status', self::$notAcceptedStatus)
				->where('start_date','>=',now())
				->get();
			if($service_type=='room'){
				$bookingData = HotelRoomBooking::where('room_id',$id)->whereHas('booking',function (Builder $query){
					$query->whereNotIn('status', self::$notAcceptedStatus)
						->where('start_date','>=',now());
				})->get();
			}
			if (!empty($bookingData)) {
				foreach ($bookingData as $item => $value) {
					if($service_type=='room'){
						$customerName = $value->fist_name . ' ' . $value->last_name;
						$description = 'Name:' . $customerName . '
 Email:' . $value->email . '
 Phone:' . $value->phone . '
 Address:' . $value->address . '
 Customer notes:' . $value->customer_notes . '
 Total guest:' . $value->number . '';
						$eventCalendar = new Event();
						$eventCalendar
							->setUniqueId($value->id.time())
							->setCategories(ucfirst($service_type))
							->setDtStart(new \DateTime($value->start_date))
							->setDtEnd(new \DateTime($value->end_date))
							->setSummary($customerName . ' Booking ' . ucfirst($service_type) . ' ' . $data->title)
							->setNoTime(false)
							->setDescriptionHTML($description);
						$calendar->addComponent($eventCalendar);
					}else{

$customerName = $value->fist_name . ' ' . $value->last_name;
					$description = 'Name:' . $customerName . '
 Email:' . $value->email . '
 Phone:' . $value->phone . '
 Address:' . $value->address . '
 Customer notes:' . $value->customer_notes . '
 Total guest:' . $value->total_guests . '';
					$eventCalendar = new Event();
 if($service_type=='space'){
 $byNight = $value->getMeta('booking_type');
 if($byNight=='by_night'){
 $value->end_date = date("Y-m-d H:i:s",strtotime($value->end_date." -1day"));
 }
 }

$endDate = new \DateTime($value->end_date);

$eventCalendar
						->setUniqueId($value->code)
						->setCategories(ucfirst($service_type))
						->setDtStart(new \DateTime($value->start_date))
						->setDtEnd($endDate)
						->setSummary($customerName . ' Booking ' . ucfirst($service_type) . ' ' . $data->title)
						->setNoTime(false)
						->setDescriptionHTML($description);
					$calendar->addComponent($eventCalendar);
					}

}
			}

}
		return $calendar->render();
	}

public function getTotalBeforeExtraPriceAttribute(){
		$extra_price = $this->getJsonMeta('extra_price');

if(empty($extra_price) or !is_array($extra_price)) return $this->total_before_discount;

$extra_price_collection = collect($extra_price);

return $this->total_before_discount - $extra_price_collection->sum('total');
	}

public function wallet_transaction(){
        return $this->belongsTo(Transaction::class,'wallet_transaction_id')->withDefault();
    }

public function tryRefundToWallet($checkStatus = true){
        if($checkStatus and in_array($this->status,[self::CANCELLED]) ){
            return;
        }

if( $this->customer_id and $this->wallet_transaction_id && !$this->is_refund_wallet){
            $user = User::find($this->customer_id);
            if($user) {
                $transaction = $this->wallet_transaction;
                if ($transaction->amount) {
                    $user->deposit($transaction->amount, ['type' => 'booking_refund_wallet'], $this->id);

$this->is_refund_wallet = 1;
                    $this->save();
                }
            }
        }
    }

public function time_slots()
    {
        return $this->hasMany( BookingTimeSlots::class, 'booking_id');
    }

public function coupons()
    {
        return $this->hasMany( CouponBookings::class, 'booking_id');
    }

public function reloadCalculateTotalBooking(){
        // Get amount before discount
        $total_booking = $this->total_before_discount;
        // Get amount total coupon
        $this->coupon_amount = CouponBookings::where('booking_id',$this->id)->sum('coupon_amount');

// Calculate total booking
 $total_booking = $total_booking - $this->coupon_amount;
 if($total_booking < 0 ){
 $total_booking = 0;
 }
 // Set amount before fees after deducting coupon
 $this->total_before_fees = $total_booking;

//reload calculate buyer fees for admin
        $total_buyer_fee = 0;
        if(!empty($list_fees = $this->buyer_fees)){
            $list_fees = json_decode($list_fees,true);
            $total_buyer_fee = $this->service->calculateServiceFees($list_fees , $this->total_before_fees , $this->total_guests);
            $total_booking += $total_buyer_fee;
        }
        //reload calculate service fees for vendor
        $total_service_fee = 0;
        if(!empty($list_fees = $this->vendor_service_fee)){
            $total_service_fee = $this->service->calculateServiceFees($list_fees , $this->total_before_fees , $this->total_guests);
            $total_booking += $total_service_fee;
        }
        $this->vendor_service_fee_amount = $total_service_fee;

// reload calculate commission
        $this->calculateCommission();
        $this->total = $total_booking;

// reload calculate deposit
        if (!empty($deposit_info = $this->getMeta("deposit_info"))) {
            $deposit_info = json_decode($deposit_info , true);
            $booking_deposit_fomular = $deposit_info['fomular'];
            $tmp_price_total = $this->total;
            if ($booking_deposit_fomular == "deposit_and_fee") {
                $tmp_price_total = $this->total_before_fees;
            }
            switch ( $deposit_info['type'] ) {
                case "percent":
                    $this->deposit = $tmp_price_total * $deposit_info['amount'] / 100;
                    break;
                default:
                    $this->deposit = $deposit_info['amount'];
                    break;
            }
            if ($booking_deposit_fomular == "deposit_and_fee") {
                $this->deposit = $this->deposit + $total_buyer_fee + $total_service_fee;
            }
        }
        $this->save();
    }

public function updateStatusCoupons(){
        CouponBookings::where('booking_id', $this->id)->update(['booking_status' => $this->status]);
    }

public function calTotalPassenger(){
        if(empty( setting_item('booking_enable_ticket_guest_info',0))){
            return 0;
        }
        switch ($this->object_model){
            case "car":
            case "boat":
                return 0;
            case "tour":
            default:
                return $this->total_guests;

}
    }
}