One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/var/www/muhasebe/modules/Tour/Admin/

Edit File: BookingController.php

<?php
namespace Modules\Tour\Admin;

use Illuminate\Http\Request;
use Modules\AdminController;
use Modules\Tour\Models\Tour;
use Modules\Tour\Models\TourCategory;

class BookingController extends AdminController
{
    protected $tourClass;
    public function __construct()
    {
        $this->setActiveMenu(route('tour.admin.index'));
        $this->tourClass = Tour::class;
    }

public function index(Request $request){

$this->checkPermission('tour_create');

$q = $this->tourClass::select("bravo_tours.*");

if($request->query('s')){
            $q->where('title','like','%'.$request->query('s').'%');
        }

if ($cat_id = $request->query('cat_id')) {
            $cat = TourCategory::find($cat_id);
            if(!empty($cat)) {
                $q->join('bravo_tour_category', function ($join) use ($cat) {
                    $join->on('bravo_tour_category.id', '=', 'bravo_tours.category_id')
                        ->where('bravo_tour_category._lft','>=',$cat->_lft)
                        ->where('bravo_tour_category._rgt','>=',$cat->_lft);
                });
            }
        }

if(!$this->hasPermission('tour_manage_others')){
            $q->where('author_id',$this->currentUser()->id);
        }

$q->orderBy('bravo_tours.id','desc');

$rows = $q->paginate(10);

$current_month = time();

if($request->query('month')){
            $date = date_create_from_format('m-Y',$request->query('month'));
            if(!$date){
                $current_month = time();
            }else{
                $current_month = $date->getTimestamp();
            }
        }

$prev_url = route('tour.admin.booking.index',array_merge($request->query(),[
           'month'=> date('m-Y',$current_month - MONTH_IN_SECONDS)
        ]));
        $next_url = route('tour.admin.booking.index',array_merge($request->query(),[
           'month'=> date('m-Y',$current_month + MONTH_IN_SECONDS)
        ]));

$tour_categories = TourCategory::where('status', 'publish')->get()->toTree();
        $breadcrumbs = [
            [
                'name' => __('Tours'),
                'url'  => route('tour.admin.index')
            ],
            [
                'name'  => __('Booking'),
                'class' => 'active'
            ],
        ];
        $page_title = __('Tour Booking History');
        return view('Tour::admin.booking.index',compact('rows','tour_categories','breadcrumbs','current_month','page_title','request','prev_url','next_url'));
    }
    public function test(){
        $d = new \DateTime('2019-07-04 00:00:00');

$d->modify('+ 4 hours');
        echo $d->format('Y-m-d H:i:s');
    }
}