?HAMA

Navigation

Breadcrumbs

/ / home / byroehnu / cnggold.com.ng / app / Repositories / Admin

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 4.28 KB

/home/byroehnu/cnggold.com.ng/app/Repositories/Admin/CategoryRepository.php

Text Base64

<?php

namespace App\Repositories\Admin;

use App\Models\Category;
use App\Models\CategoryContent;
use App\Models\Post;
use App\Models\Setting;
use App\Repositories\Traits\ModelRepositoryTraits;
use Illuminate\Http\Request;
use Illuminate\Pagination\LengthAwarePaginator;

class CategoryRepository
{
    use ModelRepositoryTraits;

/**
     * Object model will be used to modify categories table
     */
    protected Category $model;

/**
     *  Constructor for Category repository
     */
    public function __construct(Category $category)
    {
        $this->model = $category;
    }

/**
     * Get search result with paginate
     */
    public function paginateSearchResult($search, array $sort = []): LengthAwarePaginator
    {
        $query = $this->model->with('content')->newQuery();

// search category
        if (isset($search)) {
            $query->whereHas('contents', function ($q) use ($search) {
                $q->where('language_code', app()->getLocale())
                    ->where('title', 'like', '%' . $search . '%');
            });
        }

// sort category
        if (isset($sort['column'])) {
            switch ($sort['column']) {
                case 'title':
                    $query->orderBy(CategoryContent::select($sort['column'])
                        ->whereColumn('categories.id', 'category_contents.category_id')
                        ->where('language_code', app()->getLocale()), $sort['order']);
                case 'post_count':
                    $query->withCount('posts')
                        ->orderBy('posts_count', $sort['order']);
                    break;
                default:
                    $query->orderBy($sort['column'], $sort['order']);
                    break;
            }
        }

return $query->paginate(30)
            ->appends(array_filter([
                'search' => $search,
                'sort' => $sort,
                'lang' => app()->getLocale(),
            ]));
    }

/**
     * Create category
     */
    public function create(Request $request): void
    {
        $category = $this->model->create([
            'parent_id' => $request->input('parent_id'),
        ]);

$languages = json_decode(Setting::pull('languages'), true);
        $content = array_map(function ($language) use ($request) {
            $languageCode = $language['code'];

return [
                'language_code' => $languageCode,
                'title' => $request->input($languageCode . '_title'),
            ];
        }, $languages);
        $category->contents()->createMany($content);
    }

/**
     * Get edited data
     */
    public function getEditData(Category $category): array
    {
        $data = [
            'id' => $category->id,
            'parent_id' => $category->parent_id,
        ];
        $contents = $category->contents;
        $languages = json_decode(Setting::pull('languages'), true);

foreach ($languages as $language) {
            $langCode = $language['code'];
            $data[$langCode . '_title'] = '';
        }

foreach ($contents as $content) {
            $langCode = $content->language_code;
            if (array_key_exists($langCode . '_title', $data)) {
                $data[$langCode . '_title'] = $content->title;
            }
        }

return $data;
    }

/**
     * Category update
     *
     * @throws \Exception
     */
    public function update(Request $request, Category $category): void
    {
        $category->update([
            'parent_id' => $request->input('parent_id')
        ]);

$languages = json_decode(Setting::pull('languages'), true);

foreach ($languages as $language) {
            $languageCode = $language['code'];
            $title = $request->input($languageCode . '_title', '');

$category->contents()->updateOrCreate(
                ['language_code' => $languageCode],
                ['title' => $title],
            );
        }
    }

/**
     * Delete category
     *
     * @throws \Exception
     */
    public function destroy(Category $category): void
    {
        $category->delete();
    }

/**
     * Bulk category delete
     */
    public function bulkDelete($ids): void
    {
        $idArray = explode(',', $ids);
        $this->model->destroy($idArray);
    }
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 0 × Files: 38

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
AuthRepository.php	713 B	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive
BrandRepository.php	3.94 KB	lrw-r--r--	2025-07-19 07:29:54	Edit Download recursive recursive
CaseStudyCategoryRepository.php	3.67 KB	lrw-r--r--	2025-05-22 03:36:31	Edit Download recursive recursive
CaseStudyRepository.php	8.83 KB	lrw-r--r--	2025-07-08 07:16:36	Edit Download recursive recursive
CategoryRepository.php	4.28 KB	lrw-r--r--	2025-05-15 11:40:33	Edit Download recursive recursive
CommentRepository.php	1.27 KB	lrw-r--r--	2025-04-19 04:22:16	Edit Download recursive recursive
ContactRepository.php	3.81 KB	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive
CouponRepository.php	2.42 KB	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive
CustomizeRepository.php	1.11 KB	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive
DashboardRepository.php	1.58 KB	lrw-r--r--	2025-04-22 07:44:34	Edit Download recursive recursive
FormResponseRepository.php	1.18 KB	lrw-r--r--	2025-05-05 10:37:43	Edit Download recursive recursive
LanguageRepository.php	11.35 KB	lrw-r--r--	2025-04-19 04:42:55	Edit Download recursive recursive
ManualPaymentRepository.php	5.59 KB	lrw-r--r--	2025-05-15 11:24:11	Edit Download recursive recursive
MenuRepository.php	982 B	lrw-r--r--	2025-04-19 04:22:17	Edit Download recursive recursive
OrderRepository.php	5.26 KB	lrw-r--r--	2025-04-19 04:22:16	Edit Download recursive recursive
PageRepository.php	8.24 KB	lrw-r--r--	2025-07-08 07:16:36	Edit Download recursive recursive
PaymentHistoryRepository.php	1.40 KB	lrw-r--r--	2025-04-19 04:22:16	Edit Download recursive recursive
PortfolioCategoryRepository.php	3.67 KB	lrw-r--r--	2025-05-22 03:36:31	Edit Download recursive recursive
PortfolioRepository.php	9.08 KB	lrw-r--r--	2025-07-08 07:16:36	Edit Download recursive recursive
PostRepository.php	7.70 KB	lrw-r--r--	2025-04-19 04:22:16	Edit Download recursive recursive
PricingPlanRepository.php	5.04 KB	lrw-r--r--	2025-05-15 11:24:11	Edit Download recursive recursive
ProductCategoryRepository.php	4.14 KB	lrw-r--r--	2025-07-19 07:29:54	Edit Download recursive recursive
ProductRepository.php	8.30 KB	lrw-r--r--	2025-07-19 07:29:54	Edit Download recursive recursive
ProductTagRepository.php	1.34 KB	lrw-r--r--	2025-05-22 13:45:40	Edit Download recursive recursive
ReviewRepository.php	653 B	lrw-r--r--	2025-04-19 04:22:17	Edit Download recursive recursive
RolePermissionRepository.php	3.79 KB	lrw-r--r--	2025-05-04 10:44:46	Edit Download recursive recursive
SeoRepository.php	2.27 KB	lrw-r--r--	2025-04-26 10:16:33	Edit Download recursive recursive
ServiceCategoryRepository.php	3.63 KB	lrw-r--r--	2025-05-22 03:36:31	Edit Download recursive recursive
ServiceRepository.php	8.73 KB	lrw-r--r--	2025-07-08 07:16:36	Edit Download recursive recursive
SmsGatewayRepository.php	723 B	lrw-r--r--	2025-04-19 04:22:16	Edit Download recursive recursive
SubscribeRepository.php	2.42 KB	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive
TagRepository.php	1.21 KB	lrw-r--r--	2025-05-22 13:45:40	Edit Download recursive recursive
TeamRepository.php	7.49 KB	lrw-r--r--	2025-07-08 07:16:36	Edit Download recursive recursive
TestimonialRepository.php	4.42 KB	lrw-r--r--	2025-05-01 06:16:57	Edit Download recursive recursive
ThemeRepository.php	1017 B	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive
TicketRepository.php	2.63 KB	lrw-r--r--	2025-04-13 07:02:31	Edit Download recursive recursive
TranslateRepository.php	3.51 KB	lrw-r--r--	2025-04-19 04:22:16	Edit Download recursive recursive
UserRepositories.php	2.51 KB	lrw-r--r--	2025-04-08 04:12:56	Edit Download recursive recursive