OwlCyberSecurity - MANAGER

Edit File: LogisticHaveOfficeNumberResource.php

<?php

namespace App\Filament\Resources;

use App\Filament\Resources\LogisticHaveOfficeNumberResource\Pages;
use App\Helpers\LogisticGlobalSearch;
use App\Models\Carrier;
use App\Models\Invoice;
use App\Models\InvoiceDescription;
use App\Models\Logistic;
use Filament\Forms\Components\DatePicker;
use Filament\Forms\Components\Grid;
use Filament\Forms\Components\Placeholder;
use Filament\Forms\Components\Select;
use Filament\Forms\Components\Textarea;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Form;
use Filament\Notifications\Notification;
use Filament\Resources\Resource;
use Filament\Support\RawJs;
use Filament\Tables\Actions\Action;
use Filament\Tables\Table;
use Filament\Tables\Actions\BulkAction;
use Filament\Tables\Actions\EditAction;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Filters\Filter;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;

class LogisticHaveOfficeNumberResource extends Resource
{
    use LogisticGlobalSearch;

protected static ?string $model = Logistic::class;

protected static ?string $navigationIcon = 'heroicon-o-rectangle-stack';

protected static ?string $modelLabel = 'ثبت ترک دبی';

protected static ?string $pluralModelLabel = 'ثبت ترک دبی';

protected static ?string $slug = 'logistic-set-dubai-track-number';

protected static ?string $navigationGroup = 'لاجیستیک';

protected static ?int $navigationSort = 3;

public static function getEloquentQuery(): Builder
    {
//        return parent::getEloquentQuery()
//            ->whereNotNull('logistics.officenumber')
//            ->where('logistics.officenumber', '!=', '')
//            ->whereNotNull('logistics.deliverydate')
//            ->where(fn($query) => $query->wherenull('logistics.dubaitracknumber')->orwherenull('logistics.dubaiestimatedarivedate'))
//            ->where(fn($query) => $query->wherenull('logistics.iscancel')->orwhere('logistics.iscancel', '=', 0));

return parent::getEloquentQuery()
            ->where('logistics.status_id', 3)
            ->where(fn($query) => $query->wherenull('logistics.iscancel')->orwhere('logistics.iscancel', '=', 0));

}

public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Grid::make(1)->schema([
                    Placeholder::make('invoice_id')->label('کد رهگیری')
                        ->content(fn(Logistic $record): string => $record->invoice->code),
                    DatePicker::make('dubaiestimatedarivedate')->label('تاریخ تخمینی رسیدن به دوبی')->displayFormat('Y-m-d')->required(),
                    TextInput::make('dubaitracknumber')->label('ترک کد دوبی')->required(),
                    Select::make('carrier_id')->required()->label('حامل')->options(Carrier::all()->pluck('name', 'id')->toArray()),
//                    TextInput::make('shipping_cost')->label('هزینه ارسال (ریال)')->required()->minValue(0)->mask(RawJs::make('$money($input)'))
//                        ->dehydrateStateUsing(fn(string $state): string => preg_replace("/[^0-9]/", "", $state)),
//                    TextInput::make('declared_value')->label('ارزش اعلامی (ریال)')->required()->minValue(0)->mask(RawJs::make('$money($input)'))
//                        ->dehydrateStateUsing(fn(string $state): string => preg_replace("/[^0-9]/", "", $state)),
                    Textarea::make('invoiceDescriptionLevelOfficerNumberTaken')->label('توضیحات'),
                ]),
            ]);
    }

public static function table(Table $table): Table
    {
        return $table
            ->columns([
                TextColumn::make('invoice.code')->label('کد رهگیری')->copyable(),
                TextColumn::make('invoiceItem.name')->label('نام کالا')->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('price')->label('قیمت'),
                TextColumn::make('exchange.name')->label('ارز'),
                TextColumn::make('singleItemfullprice')->label('قیمت ریالی')->money('IRR'),
                TextColumn::make('orderId')->label('شماره سفارش'),
                TextColumn::make('base.title')->label('بیس'),
                TextColumn::make('buyingdate')->label('تاریخ خرید'),
                TextColumn::make('tracknumber')->label('ترک نامبر'),
                TextColumn::make('officenumber')->label('شماره دفتری'),
            ])
            ->filters([
                Filter::make('code')->form([
                    TextInput::make('code')->label('کد رهگیری'),
                ])->query(fn(Builder $query, array $data): Builder => $query->when(
                    $data['code'],
                    fn(Builder $query, $data): Builder => $query->whereHas(
                        'invoice',
                        fn($q) => $q->where('invoices.code', 'like', '%' . $data . '%')),
                )),

Filter::make('orderId')->form([
                    TextInput::make('orderId')->label('شماره سفارش'),
                ])->query(function (Builder $query, array $data): Builder {
                    return $query->when(
                        $data['orderId'],
                        fn(Builder $query, $data): Builder => $query->where('orderId', 'like', '%' . $data . '%')
                    );
                }),
                Filter::make('buyingdate')->form([
                    TextInput::make('buyingdate')->label('شماره دفتری'),
                ])->query(function (Builder $query, array $data): Builder {
                    return $query->when(
                        $data['buyingdate'],
                        fn(Builder $query, $data): Builder => $query->where('buyingdate', 'like', '%' . $data . '%')
                    );
                }),
                Filter::make('tracknumber')->form([
                    TextInput::make('tracknumber')->label('ترک نامبر'),
                ])->query(fn(Builder $query, array $data): Builder => $query->when(
                    $data['tracknumber'],
                    fn(Builder $query, $data): Builder => $query->where('tracknumber', 'like', '%' . $data . '%')
                )),

Filter::make('name')->form([
                    TextInput::make('name')->label('نام کالا'),
                ])->query(fn(Builder $query, array $data): Builder => $query->when(
                    $data['name'],
                    fn(Builder $query, $data): Builder => $query->whereHas(
                        'invoiceItem',
                        fn($q) => $q->where('invoice_items.name', 'like', '%' . $data . '%')),
                )),
            ])
            ->actions([
                Action::make('final-factor')->label('مشاهده فاکتور')->color('primary')->icon('heroicon-o-currency-dollar')
                    ->url(fn(Logistic $item) => config('app.url') . "/admin/invoice-search/view-factor/" . "{$item->invoice_id}")
                    ->openUrlInNewTab()
                    ->icon('heroicon-o-link')
                    ->color('primary'),
                EditAction::make()->label('ثبت')->using(function (Logistic $record, array $data) {

self::updateRecord($record, $data);

return $record;
                }),

Action::make('invoiceDescription')->label('توضیحات')->icon('heroicon-o-chat-bubble-bottom-center-text')->color('grey')
                    ->mountUsing(function (Form $form, Logistic $record) {
                        $form->fill([
                            'invoiceDescriptionLevelBuyInvoice' => $record->invoiceDescriptionLevelBuyInvoice()->first()?->description,
                            'invoiceDescriptionLevelSetTrackNumber' => $record->invoiceDescriptionLevelSetTrackNumber()->first()?->description,
                            'invoiceDescriptionLevelSetOfficeNumber' => $record->invoiceDescriptionLevelSetOfficeNumber()->first()?->description,
                            'invoiceDescriptionLevelSetDubaiTrackNumber' => $record->invoiceDescriptionLevelSetDubaiTrackNumber()->first()?->description,
                            'invoiceDescriptionLevelIsInDubai' => $record->invoiceDescriptionLevelIsInDubai()->first()?->description,
                            'invoiceDescriptionLevelSendToTehran' => $record->invoiceDescriptionLevelSendToTehran()->first()?->description,
                            'invoiceDescriptionLevelIsInTehran' => $record->invoiceDescriptionLevelIsInTehran()->first()?->description,
                        ]);
                    })
                    ->form([
                        Textarea::make('invoiceDescriptionLevelBuyInvoice')->label('توضیحات مرحله خرید')->disabled(),
                        Textarea::make('invoiceDescriptionLevelSetTrackNumber')->label('توضیحات ثبت ترک نامبر')->disabled(),
                        Textarea::make('invoiceDescriptionLevelSetOfficeNumber')->label('توضیحات ثبت شماره دفتری')->disabled(),
                        Textarea::make('invoiceDescriptionLevelSetDubaiTrackNumber')->label('توضیحات ثبت ترک دبی')->disabled(),
                        Textarea::make('invoiceDescriptionLevelIsInDubai')->label('توضیحات درون دبی')->disabled(),
                        Textarea::make('invoiceDescriptionLevelSendToTehran')->label('توضیحات ارسال به تهران')->disabled(),
                        Textarea::make('invoiceDescriptionLevelIsInTehran')->label('توضیحات درون تهران')->disabled(),
                    ])
                    ->modalCancelAction(false)
                    ->modalSubmitAction(false)
                    ->action(function (array $data) {
                    }),
                Action::make('back')->label('برگشت به مرحله قبل')->icon('heroicon-o-arrow-uturn-left')
                    ->form([

Placeholder::make('code')->label('آیا برای بازگشت سفارش با کد رهگیری زیر به مرحله قبل مطمعن هستین؟')
                            ->content(fn(Logistic $record): string => $record->invoice->code)

])
                    ->action(function (Logistic $record, array $data) {

$record->update([
                            'status_id' => $record->status_id - 1,
                        ]);

}),
            ])
            ->bulkActions([
                BulkAction::make('edition')->label('ثبت گروهی')
                    ->form([
                        DatePicker::make('dubaiestimatedarivedate')->label('تاریخ تخمینی رسیدن به دوبی')->displayFormat('Y-m-d')->required(),
                        TextInput::make('dubaitracknumber')->label('ترک کد دوبی')->required(),
                        Select::make('carrier_id')->required()->label('حامل')->options(Carrier::all()->pluck('name', 'id')->toArray()),
//                        TextInput::make('shipping_cost')->label('هزینه ارسال (ریال)')->required()->minValue(0)->mask(RawJs::make('$money($input)'))
//                            ->dehydrateStateUsing(fn(string $state): string => preg_replace("/[^0-9]/", "", $state)),
//                        TextInput::make('declared_value')->label('ارزش اعلامی (ریال)')->required()->minValue(0)->mask(RawJs::make('$money($input)'))
//                            ->dehydrateStateUsing(fn(string $state): string => preg_replace("/[^0-9]/", "", $state)),
                        Textarea::make('invoiceDescriptionLevelOfficerNumberTaken')->label('توضیحات'),
                    ])
                    ->action(function (Collection $records, array $data) {
                        foreach ($records as $record) {
                            self::updateRecord($record, $data);
                        }
                        return $records;
                    })
            ])
            ->defaultSort('updated_at', 'desc');
    }

public static function getPages(): array
    {
        return [
            'index' => Pages\ListLogisticHaveOfficeNumbers::route('/'),
        ];
    }

private static function updateRecord($record, $data)
    {
        if (!$record->invoice->submit_factor) {
            Notification::make()->title('سفارش در مرحله سفارش میباشد ابتدا تمام آیتم های این سفارش باید خرید یا لغو شوند سپس سفارش ثبت فاکتور شود .')->danger()->send();
            return $record;
        }
        InvoiceDescription::updateOrCreate([
            'logistics_id' => $record->id,
            'level' => 'set-dubai-track-number',
        ], [
            'invoice_id' => $record->invoice_id,
            'invoice_item_id' => $record->invoice_item_id,
            'description' => $data['invoiceDescriptionLevelOfficerNumberTaken'],
            'agent_id' => auth()->id(),
        ]);

$record->update([
            'status_id' => 4,
            'dubaitracknumber' => $data['dubaitracknumber'],
            'dubaiestimatedarivedate' => $data['dubaiestimatedarivedate'],
            'carrier_id' => $data['carrier_id'],
//            'shipping_cost' => $data['shipping_cost'],
//            'declared_value' => $data['declared_value'],
        ]);
        Invoice::where('id', $record->invoice_id)->update(['status' => 'ارسال به دوبی']);
        return $record;
    }

public static function canViewAny(): bool
    {
        return auth()->user()->can('logistic-set-dubai-track-number::view');
    }
}