Ümit Tunç
29 lines
887 B
PHP
29 lines
887 B
PHP
<?php
|
|
$id = $request['key'];
|
|
|
|
// Get the updated subcontractor record
|
|
$subcontractor = db("subcontractors")->where("id", $id)->first();
|
|
dump($subcontractor);
|
|
|
|
if ($subcontractor) {
|
|
// Update work_permit_documents table to sync job_description and sign_order
|
|
$updateWorkPermitDocuments = db("work_permit_documents")
|
|
->where("company", $subcontractor->company_name_ru)
|
|
->update([
|
|
'job_description' => $subcontractor->job_description,
|
|
'company_sign_order' => $subcontractor->sign_order
|
|
]);
|
|
|
|
dump([
|
|
"message" => "Subcontractor data synced to work_permit_documents",
|
|
"updated_records" => $updateWorkPermitDocuments,
|
|
"company" => $subcontractor->company_name_ru
|
|
]);
|
|
} else {
|
|
dump([
|
|
"message" => "Subcontractor not found",
|
|
"company" => $subcontractor->company_name_ru
|
|
]);
|
|
}
|
|
?>
|