Ümit Tunç
59 lines
1.8 KiB
PHP
59 lines
1.8 KiB
PHP
<?php
|
|
|
|
namespace App\Services\LineListTriggers\Triggers;
|
|
|
|
use App\Services\LineListTriggers\Base\BaseLineListTrigger;
|
|
use Illuminate\Support\Facades\Log;
|
|
|
|
/**
|
|
* Isolation Sync Trigger
|
|
*
|
|
* Syncs external_finish_type from Line List to:
|
|
* - Test Packages (isolation field)
|
|
* Triggered when external_finish_type field changes in Line List
|
|
*/
|
|
class IsolationSyncTrigger extends BaseLineListTrigger
|
|
{
|
|
public function getName(): string
|
|
{
|
|
return 'Isolation Sync';
|
|
}
|
|
|
|
public function getDependentFields(): array
|
|
{
|
|
return ['external_finish_type'];
|
|
}
|
|
|
|
protected function process($lineListData, $beforeData, array $context): array
|
|
{
|
|
// Update 'isolation' field in test_packages table where p_id matches line_no
|
|
// 1. Get test_package_no's from test_pack_base_statuses where drawing_no matches line_no
|
|
$testPackageNos = db('test_pack_base_statuses')
|
|
->where('drawing_no', $lineListData->line_no)
|
|
->pluck('test_package_no')
|
|
->toArray();
|
|
|
|
// 2. Update test_packages where test_package_no matches the found ones
|
|
if (!empty($testPackageNos)) {
|
|
$result = db("test_packages")
|
|
->whereIn("test_package_number", $testPackageNos)
|
|
->update([
|
|
'isolation' => $lineListData->external_finish_type
|
|
]);
|
|
} else {
|
|
$result = 0;
|
|
}
|
|
|
|
Log::info("Line List Isolation Sync completed", [
|
|
'line_no' => $lineListData->line_no,
|
|
'external_finish_type' => $lineListData->external_finish_type,
|
|
'updated' => $result,
|
|
]);
|
|
|
|
return [
|
|
'success' => true,
|
|
'test_packages_updated' => $result,
|
|
];
|
|
}
|
|
}
|