One Hat Cyber Team

Your IP: 216.73.216.77
Server IP: 13.127.59.50
Server: Linux ip-172-31-46-210 5.15.0-1033-aws #37~20.04.1-Ubuntu SMP Fri Mar 17 11:39:30 UTC 2023 x86_64
Server Software: Apache/2.4.41 (Ubuntu)
PHP Version: 7.4.3-4ubuntu2.29
Buat File | Buat Folder
Dir : ~/var/www/ecommerce_pg/app/Http/Controllers/Admin/
View File Name : ClientUserCrudController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Requests\ClientUserRequest;
use Backpack\CRUD\app\Http\Controllers\CrudController;
use Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade as CRUD;
use Illuminate\Http\Request;

/**
 * Class ClientUserCrudController
 * @package App\Http\Controllers\Admin
 * @property-read \Backpack\CRUD\app\Library\CrudPanel\CrudPanel $crud
 */
class ClientUserCrudController extends CrudController
{
    use \Backpack\CRUD\app\Http\Controllers\Operations\ListOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\CreateOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\UpdateOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\DeleteOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\ShowOperation;

    /**
     * Configure the CrudPanel object. Apply settings to all operations.
     *
     * @return void
     */
    public function setup()
    {
        CRUD::setModel(\App\Models\ClientUser::class);
        CRUD::setRoute(config('backpack.base.route_prefix') . '/clientuser');
        CRUD::setEntityNameStrings('clientuser', 'client_users');
        CRUD::removeAllButtons();
    }

    /**
     * Define what happens when the List operation is loaded.
     *
     * @see  https://backpackforlaravel.com/docs/crud-operation-list-entries
     * @return void
     */
    protected function setupListOperation()
    {
        CRUD::column('created_at');
        CRUD::column('email');
        // CRUD::column('id');
        CRUD::column('name');
        CRUD::column('phone');
        CRUD::column('updated_at');
        CRUD::column([
          'name' => 'user_id',
          'label' => 'UserId'
        ]);

        /**
         * Columns can be defined using the fluent syntax or array syntax:
         * - CRUD::column('price')->type('number');
         * - CRUD::addColumn(['name' => 'price', 'type' => 'number']);
         */
    }

    /**
     * Define what happens when the Create operation is loaded.
     *
     * @see https://backpackforlaravel.com/docs/crud-operation-create
     * @return void
     */
    protected function setupCreateOperation()
    {
        CRUD::setValidation(ClientUserRequest::class);

        CRUD::field('created_at');
        CRUD::field('email');
        CRUD::field('id');
        CRUD::field('name');
        CRUD::field('phone');
        CRUD::field('updated_at');
        CRUD::field('user_id');

        /**
         * Fields can be defined using the fluent syntax or array syntax:
         * - CRUD::field('price')->type('number');
         * - CRUD::addField(['name' => 'price', 'type' => 'number']));
         */
    }

    /**
     * Define what happens when the Update operation is loaded.
     *
     * @see https://backpackforlaravel.com/docs/crud-operation-update
     * @return void
     */
    protected function setupUpdateOperation()
    {
        $this->setupCreateOperation();
    }

    public function clientUserReport(Request $request)
    {
      return view('admin.clientuser.clientUserReport');
    }

    public function clientUserReportData(Request $request)
 {
   $date = $request->date;

   $date = '2021-05-22';

   $q = \DB::table('transactions as t')
           ->whereDate('t.created_at',$date)
           ->leftjoin('client_users as cu','cu.user_id','=','t.user_id')
           ->groupBy('t.user_id')
           ->select(
             \DB::raw('ANY_VALUE(cu.user_id) as UserId'),
             \DB::raw('ANY_VALUE(cu.email) as Email'),
             \DB::raw('ANY_VALUE(cu.phone) as Phone'),
             \DB::raw('ANY_VALUE(cu.name) as Name'),
             \DB::raw('SUM(t.amount) as Amount'),
           );

   return $q->get();
 }
}