Ümit Tunç
31 lines
1.3 KiB
PHP
31 lines
1.3 KiB
PHP
<?php
|
|
// Get the test package that is being deleted
|
|
$testPackage = db("test_packages")->where("id", $request['key'])->first();
|
|
|
|
if ($testPackage) {
|
|
try {
|
|
// Check if there are any weld_logs records with this test_package_number
|
|
$weldLogsCount = db("weld_logs")
|
|
->where("test_package_no", $testPackage->test_package_number)
|
|
->count();
|
|
|
|
if ($weldLogsCount > 0) {
|
|
dump("Cannot delete test_pack_base_statuses. Found $weldLogsCount weld_logs records for test_package_no: " . $testPackage->test_package_number);
|
|
} else {
|
|
// Delete related test_pack_base_statuses records based on test_package_number
|
|
$deletedCount = db("test_pack_base_statuses")
|
|
->where("test_package_no", $testPackage->test_package_number)
|
|
->delete();
|
|
|
|
dump("Deleted $deletedCount test_pack_base_statuses records for test_package_no: " . $testPackage->test_package_number);
|
|
}
|
|
|
|
} catch (\Throwable $th) {
|
|
dump("Error deleting test_pack_base_statuses: " . $th->getMessage());
|
|
Log::error("DeleteTrigger test_packages error: " . $th->getMessage());
|
|
}
|
|
} else {
|
|
dump("Test package not found with id: " . $request['key']);
|
|
}
|
|
?>
|