Admin

name	type	size	perms	modified	actions
[parent directory]
LookupImport.php	file	2,989 B	0664	2026-08-24 21:46:04	edit
OrderImport.php	file	10,773 B	0664	2026-08-24 21:46:04	edit
QurbanPeriodImport.php	file	1,489 B	0664	2026-08-24 21:46:04	edit
RoleImport.php	file	1,267 B	0664	2026-08-24 21:46:04	edit
UserImport.php	file	2,499 B	0664	2026-08-24 21:46:04	edit

editing: OrderImport.php

<?php

namespace App\Imports;

use DB;
use Carbon\Carbon;
use App\Models\Order;
use App\Utils\LogUtil;
use App\Domain\OrderData;
use App\Domain\MessageData;
use App\Jobs\GenerateQRJob;
use App\Services\OrderService;
use App\Models\OrderItemDetail;
use Illuminate\Validation\Rule;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\SkipsEmptyRows;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithValidation;
use Maatwebsite\Excel\Concerns\WithBatchInserts;

class OrderImport implements ToCollection, WithHeadingRow, WithValidation, WithBatchInserts, SkipsEmptyRows
{
    use Importable;

private $counter = 0;
    private MessageData $objMsg;
    private $params;

public function __construct($params)
    {
        $this->params = $params;
        $this->objMsg = new MessageData();
    }

protected function cleanDataImport($text)
    {
        if (is_string($text)) {
            $text = trim($text);
            $text = ltrim($text, '\'');
        }

return $text;
    }

$item['category'] = strtoupper($this->cleanDataImport($item['kategori']));
                $item['item'] = strtoupper($this->cleanDataImport($item['item']));
                $item['variant'] = strtoupper($this->cleanDataImport($item['variant']));

return $item;
            })->mapToGroups(function ($item, $key) {
                return [
                    $this->cleanDataImport($item['kode_order']) => $item
                ];
            })->all();
        DB::beginTransaction();
        try {
            foreach ($raws as $key => $row) {
                $last = $row->last();
                $order = Order::where('code', $key)->first();
                $updateData = [
                    'period_id' => $period->id,
                    'cust_name' => $last['nama'],
                    'cust_email' => $last['email'] ??= '',
                    'cust_phone' => $last['phone'],
                    'total_qty' => 0,
                    'order_date' => $last['tanggal_order'],
                    'source' => $last['source'] ? strtoupper($last['source']) : $this->params->source,
                    'note' => $this->cleanDataImport('')
                ];
                if ($order) {
                    $oldData = $order->toArray();
                    $order->update($updateData);
                    LogUtil::logChanges(
                        model: $order,
                        oldData: $oldData,
                        desc: 'Data order berubah dari import'
                    );
                }else {
                    $updateData['code'] = $key;
                    $order = Order::create($updateData);
                }

$orderItems = $row->groupBy(function ($item) {
                    return $item['category'] . '|' . $item['item'];
                })->toArray();

foreach ($orderItems as $key => $orderItem) {
                    $keys = explode("|", $key);
                    $category = $keys[0];
                    $item = $keys[1];

$check = $order->items()->firstOrCreate([
                        'category' => $category,
                        'item' => $item,
                    ], [
                        'qty' => 0,
                        'variant' => last($orderItem)['variant'],
                    ]);

foreach ($orderItem as $detail) {
                        $orderItemDetail = $check->details()->where([
                            'qurban_name' => $detail['nama_shohibul_qurban'],
                        ])->get();

if ($orderItemDetail->isEmpty()) {
                            for ($i = 0; $i < $detail['qty']; $i++) {
                                $orderItemDetail = $check->details()->create([
                                    'qurban_name' => $detail['nama_shohibul_qurban'],
                                    'order_id' => $check->order_id,
                                    'delivery' => $detail['penyaluran'],
                                    'delivery_address' => $detail['alamat'],
                                    'delivery_district' => $detail['kecamatan'],
                                    'delivery_sub_district' => $detail['kelurahan'],
                                    'city' => $detail['kota'],
                                    'qurban_process' => $detail['proses_penyembelihan'],
                                    'presence' => $detail['kehadiran'],
                                    'qurban_date' => $detail['jadwal_sembelih'],
                                    'note' => $detail['special_request'],
                                    'notice' => $detail['notes'],
                                ]);
                            }
                        }else {
                            foreach ($orderItemDetail as $p0) {
                                $oldData = $p0->toArray();
                                $p0->update([
                                    'delivery' => $detail['penyaluran'],
                                    'delivery_address' => $detail['alamat'],
                                    'delivery_district' => $detail['kecamatan'],
                                    'delivery_sub_district' => $detail['kelurahan'],
                                    'city' => $detail['kota'],
                                    'qurban_process' => $detail['proses_penyembelihan'],
                                    'presence' => $detail['kehadiran'],
                                    'qurban_date' => $detail['jadwal_sembelih'],
                                    'note' => $detail['special_request'],
                                    'notice' => $detail['notes'],
                                ]);
                                LogUtil::logChanges(
                                    model: $p0,
                                    oldData: $oldData,
                                    desc: 'Update data qurban dari import'
                                );
                            }
                        }
                    }
                }
            }

DB::statement('update order_items a
            set qty = c.QtyDetail
            from (
                select b.order_item_id, count(b.id) as QtyDetail
                from order_item_details b
                inner join orders b2 on b2.id = b.order_id
                where b2.period_id = ?
                group by b.order_item_id
            ) as c where c.order_item_id = a.id', [
                current_period()?->id
            ]);
            DB::commit();
            $this->objMsg->status = true;
            $this->objMsg->message = 'OK';
        } catch (\Exception $ex) {
            DB::rollBack();
            $this->objMsg->status = false;
            $this->objMsg->message = 'Failed! ' . $ex->getMessage();
            throw $ex;
        }

(new OrderService)->syncQurban();
        GenerateQRJob::dispatch('order')->afterCommit();
    }

function rules(): array
    {
        return [
            'kode_order' => [
                'required',
                'max:255'
            ],
            'nama' => [
                'required',
                'max:255'
            ],
            'email' => [
                'nullable',
                'max:255'
            ],
            'phone' => [
                'required',
                'max:15'
            ],
            'kehadiran' => [
                'nullable',
                Rule::in(OrderData::attendanceOptions()),
            ],
            'penyaluran' => [
                'required',
                Rule::in(OrderData::deliveryOptions())
            ],
            'alamat' => [
                'nullable',
                'max:255'
            ],
            'kelurahan' => [
                'nullable',
                'max:255'
            ],
            'kecamatan' => [
                'nullable',
                'max:255'
            ],
            'kota' => [
                'nullable',
                'max:255'
            ],
            'nama_shohibul_qurban' => [
                'required',
                'max:255'
            ],
            'proses_penyembelihan' => [
                'required',
                'max:255',
                // Rule::in(OrderData::qurbanProcessOptions()),
            ],
            // 'hari' => [
            //     'required'
            // ],
            // 'jam' => 'required',
            'tempat_pelaksanaan' => [
                'nullable',
                'max:255'
            ],
            'kategori' => [
                'required',
                Rule::in(OrderData::categoryOptions())
            ],
            'item' => 'required',
            'variant' => 'required',
            'qty' => 'required|integer',
            'tanggal_order' => 'required',
            'special_request' => 'nullable',
            'notes' => 'nullable',
            'jadwal_sembelih' => [
                'nullable',
            ],
            'source' => [
                'nullable',
                'max:255'
            ],
        ];
    }

/**
     * @return array
     */
    public function customValidationMessages()
    {
        return [
            // 'name.unique' => 'Isian pada baris :row kolom :attribute sudah ada sebelumnya',
        ];
    }

function batchSize(): int
    {
        return 500;
    }
}

cancel