Ümit Tunç
21 lines
633 B
PHP
21 lines
633 B
PHP
<?php
|
|
use Carbon\Carbon;
|
|
|
|
|
|
$welder_tests = db("welder_tests")
|
|
|
|
->where("naks_id", get("welder_id"))
|
|
//->groupBy("wpq_document_no")
|
|
->get();
|
|
|
|
$expired_date = setting("WelderQualitificationStatusExpiredDate");
|
|
$today = Carbon::now();
|
|
foreach($welder_tests AS $q) {
|
|
$naksValidty = Carbon::parse($q->naks_validity);
|
|
$weldingDate = Carbon::parse($q->welding_date);
|
|
$q->remaining_days = $today->diffInDays($naksValidty, false);
|
|
$q->expired_days = $today->diffInDays($naksValidty, false) + $expired_date;
|
|
$q->expired_date = $weldingDate->addDays($expired_date)->format("Y-m-d");
|
|
}
|
|
echo json_encode_tr($welder_tests);
|
|
?>
|