Ümit Tunç
50 lines
1.1 KiB
PHP
50 lines
1.1 KiB
PHP
<?php
|
|
/**
|
|
* @api-readonly
|
|
* Returns RFI tasks
|
|
*/
|
|
use Carbon\Carbon;
|
|
|
|
$tasks = db("r_f_i_s");
|
|
|
|
if(!getesit("d1", ""))
|
|
{
|
|
$tasks = $tasks->whereBetween("inspection_date", [get("d1"), get("d2")]);
|
|
} else {
|
|
// Geçerli tarihi al
|
|
$today = Carbon::today();
|
|
|
|
// Bir hafta öncesinin tarihini al
|
|
$oneWeekAgo = $today->subDays(10);
|
|
$today = Carbon::today()->addDays(10);
|
|
$d1 = $oneWeekAgo->format('Y-m-d');
|
|
$d2 = $today->format('Y-m-d');
|
|
// Sorguyu güncelle
|
|
$tasks = $tasks->whereBetween("inspection_date", [$d1, $d2]);
|
|
}
|
|
|
|
if(!getesit("discipline", ""))
|
|
{
|
|
$tasks = $tasks->where("discipline", get("discipline"));
|
|
}
|
|
|
|
if(!getesit("contractor", ""))
|
|
{
|
|
$tasks = $tasks->where("subcontractor", get("contractor"));
|
|
}
|
|
|
|
$tasks = $tasks->get();
|
|
|
|
foreach ($tasks as &$task) {
|
|
if (isset($task->inspection_date)) {
|
|
// Use Carbon to parse and format the date
|
|
$task->inspection_date = Carbon::parse($task->inspection_date)->format('d.m.Y');
|
|
}
|
|
|
|
if (empty($task->status)) {
|
|
$task->status = "Inspection Waiting";
|
|
}
|
|
}
|
|
|
|
echo json_encode_tr($tasks)
|
|
?>
|