?HAMA

Navigation

Breadcrumbs

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

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 3.67 KB

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

Text Base64

<?php

namespace App\Repositories\Admin;

use App\Http\Requests\Admin\CaseStudyCategoryStoreRequest;
use App\Http\Requests\Admin\CaseStudyCategoryUpdateRequest;
use App\Models\CaseStudy;
use App\Models\CaseStudyCategory;
use App\Models\Setting;
use App\Repositories\Traits\ModelRepositoryTraits;
use Illuminate\Http\Request;
use Illuminate\Pagination\LengthAwarePaginator;

class CaseStudyCategoryRepository
{
    use ModelRepositoryTraits;

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

/**
     *  Constructor for Category repository
     */
    public function __construct(CaseStudyCategory $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'])) {
            $query->orderBy($sort['column'], $sort['order']);
        }

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

/**
     * Store category
     */
    public function store(CaseStudyCategoryStoreRequest $request): void
    {
        $testimonial = $this->model->create($request->all());

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

return [
                'language_code' => $langCode,
                'title' => $request[$langCode . '_title'],
            ];
        }, $languages);

$testimonial->contents()->createMany($content);
    }

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

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

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

return $data;
    }

/**
     * Update category
     */
    public function update(CaseStudyCategory $caseStudyCategory, CaseStudyCategoryUpdateRequest $request): void
    {
        $languages = json_decode(Setting::pull('languages'), true);
        foreach ($languages as $language) {
            $langCode = $language['code'];

$caseStudyCategory->contents()->updateOrCreate(
                ['language_code' => $langCode],
                [
                    'title' => $request[$langCode . '_title'],
                ],
            );
        }
    }

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

/**
     * Bulk 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