MAINHACK

Viewing / Editing File: RegistrationPackagesController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\RegistrationPackage;
use App\Models\Role;
use App\Models\Sale;
use App\Models\Setting;
use App\Models\Translation\RegistrationPackageTranslation;
use Illuminate\Http\Request;

class RegistrationPackagesController extends Controller
{
    public function index()
    {
        $this->authorize('admin_registration_packages_lists');

$query = RegistrationPackage::with([
            'sales' => function ($query) {
                $query->whereNull('refund_at');
            }
        ]);

$packages = deepClone($query)->orderBy('created_at', 'desc')
            ->paginate(10);

$totalPackages = deepClone($query)->count();
        $totalActiveByInstructors = $this->getTotalActiveByInstructors();
        $totalActiveByOrganization = $this->getTotalActiveByOrganization();

$data = [
            'pageTitle' => trans('update.registration_packages'),
            'packages' => $packages,
            'totalPackages' => $totalPackages,
            'totalActiveByInstructors' => $totalActiveByInstructors,
            'totalActiveByOrganization' => $totalActiveByOrganization,
        ];

return view('admin.financial.registration_packages.lists', $data);
    }

private function getTotalActiveByInstructors()
    {
        $this->authorize('admin_registration_packages_lists');

return Sale::whereNotNull('registration_package_id')
            ->whereNull('refund_at')
            ->whereHas('buyer', function ($query) {
                $query->where('role_name', Role::$teacher);
            })
            ->count();
    }

private function getTotalActiveByOrganization()
    {
        $this->authorize('admin_registration_packages_lists');

return Sale::whereNotNull('registration_package_id')
            ->whereNull('refund_at')
            ->whereHas('buyer', function ($query) {
                $query->where('role_name', Role::$organization);
            })
            ->count();
    }

public function create()
    {
        $this->authorize('admin_registration_packages_new');

$data = [
            'pageTitle' => trans('admin/main.new_package'),
        ];

return view('admin.financial.registration_packages.new', $data);
    }

public function store(Request $request)
    {
        $this->authorize('admin_registration_packages_new');

$this->validate($request, [
            'title' => 'required|string',
            'description' => 'required|string',
            'days' => 'required|numeric',
            'price' => 'required|numeric',
            'icon' => 'required|string',
            'role' => 'required|in:instructors,organizations',
            'instructors_count' => 'nullable|numeric',
            'students_count' => 'nullable|numeric',
            'courses_capacity' => 'nullable|numeric',
            'courses_count' => 'nullable|numeric',
            'meeting_count' => 'nullable|numeric',
            'product_count' => 'nullable|numeric',
        ]);

$data = $request->all();

if (empty($data['status']) or !in_array($data['status'], ['disabled', 'active'])) {
            $data['status'] = 'disabled';
        }

$package = RegistrationPackage::create([
            'days' => $data['days'],
            'price' => $data['price'],
            'icon' => $data['icon'],
            'role' => $data['role'],
            'instructors_count' => $data['instructors_count'] ?? null,
            'students_count' => $data['students_count'] ?? null,
            'courses_capacity' => $data['courses_capacity'] ?? null,
            'courses_count' => $data['courses_count'] ?? null,
            'meeting_count' => $data['meeting_count'] ?? null,
            'product_count' => $data['product_count'] ?? null,
            'ai_content_access' => (!empty($data['ai_content_access']) and $data['ai_content_access'] == '1'),
            'status' => $data['status'],
            'created_at' => time(),
        ]);

RegistrationPackageTranslation::updateOrCreate([
            'registration_package_id' => $package->id,
            'locale' => mb_strtolower($data['locale']),
        ], [
            'title' => $data['title'],
            'description' => $data['description'] ?? null,
        ]);

return redirect(route('adminRegistrationPackagesLists'));
    }

public function edit(Request $request, $id)
    {
        $this->authorize('admin_registration_packages_edit');

$package = RegistrationPackage::findOrFail($id);

$locale = $request->get('locale', app()->getLocale());
        storeContentLocale($locale, $package->getTable(), $package->id);

$data = [
            'pageTitle' => trans('admin/main.edit'),
            'package' => $package
        ];

return view('admin.financial.registration_packages.new', $data);
    }

public function update(Request $request, $id)
    {
        $this->authorize('admin_registration_packages_edit');

$package = RegistrationPackage::findOrFail($id);

$data = $request->all();

if (empty($data['status']) or !in_array($data['status'], ['disabled', 'active'])) {
            $data['status'] = 'disabled';
        }

$package->update([
            'days' => $data['days'],
            'price' => $data['price'],
            'icon' => $data['icon'],
            'role' => $data['role'],
            'instructors_count' => $data['instructors_count'] ?? null,
            'students_count' => $data['students_count'] ?? null,
            'courses_capacity' => $data['courses_capacity'] ?? null,
            'courses_count' => $data['courses_count'] ?? null,
            'meeting_count' => $data['meeting_count'] ?? null,
            'product_count' => $data['product_count'] ?? null,
            'ai_content_access' => (!empty($data['ai_content_access']) and $data['ai_content_access'] == '1'),
            'status' => $data['status'],
            'created_at' => time(),
        ]);

return redirect()->back();
    }

public function delete($id)
    {
        $this->authorize('admin_registration_packages_delete');

$package = RegistrationPackage::findOrFail($id);

$package->delete();

return redirect(route('adminRegistrationPackagesLists'));
    }

public function settings()
    {
        $this->authorize('admin_registration_packages_settings');

removeContentLocale();

$names = [Setting::$registrationPackagesGeneralName, Setting::$registrationPackagesInstructorsName, Setting::$registrationPackagesOrganizationsName];

$settings = Setting::whereIn('name', $names)->get()->keyBy('name');

if (count($settings)) {
            foreach ($settings as $setting) {
                $setting->value = json_decode($setting->value, true);
            }
        }

$pageGeneralSettings = (!empty($settings) and !empty($settings[Setting::$registrationPackagesGeneralName])) ? $settings[Setting::$registrationPackagesGeneralName]->value : null;
        $instructorsSettings = (!empty($settings) and !empty($settings[Setting::$registrationPackagesInstructorsName])) ? $settings[Setting::$registrationPackagesInstructorsName]->value : null;
        $organizationsSettings = (!empty($settings) and !empty($settings[Setting::$registrationPackagesOrganizationsName])) ? $settings[Setting::$registrationPackagesOrganizationsName]->value : null;

$data = [
            'pageTitle' => trans('admin/main.settings'),
            'pageGeneralSettings' => $pageGeneralSettings,
            'instructorsSettings' => $instructorsSettings,
            'organizationsSettings' => $organizationsSettings,
        ];

return view('admin.financial.registration_packages.settings.index', $data);
    }

public function reports()
    {
        $this->authorize('admin_registration_packages_reports');

$query = Sale::where('type', Sale::$registrationPackage)
            ->whereNotNull('registration_package_id')
            ->whereNull('refund_at');

$sales = deepClone($query)->with([
            'registrationPackage',
            'buyer'
        ])->orderBy('created_at')
            ->paginate(10);

$totalBuyInstructorsPackages = deepClone($query)->whereHas('registrationPackage', function ($query) {
            $query->where('role', 'instructors');
        })->count();

$totalBuyOrganizationPackages = deepClone($query)->whereHas('registrationPackage', function ($query) {
            $query->where('role', 'organizations');
        })->count();

$data = [
            'pageTitle' => trans('admin/main.reports'),
            'sales' => $sales,
            'totalBuyInstructorsPackages' => $totalBuyInstructorsPackages,
            'totalBuyOrganizationPackages' => $totalBuyOrganizationPackages,
        ];

return view('admin.financial.registration_packages.reports', $data);
    }
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: RegistrationPackagesController.php

Server Info

System Features

User Info