Ümit Tunç
122 lines
3.4 KiB
PHP
122 lines
3.4 KiB
PHP
<?php
|
||
use Carbon\Carbon;
|
||
use App\Models\WelderLocation;
|
||
$naksLists = [];
|
||
|
||
if(getisset("iso_number")) {
|
||
$weldLogNaks = db("weld_logs")
|
||
// ->where("iso_number", get("iso_number"))
|
||
// ->where("no_of_the_joint_as_per_as_built_survey", get("no_of_the_joint_as_per_as_built_survey"))
|
||
->get();
|
||
|
||
foreach($weldLogNaks AS $data) {
|
||
if($data->welder_1 != "") $naksLists[] = get_welder_id($data->welder_1);
|
||
if($data->welder_2 != "") $naksLists[] = get_welder_id($data->welder_2);
|
||
}
|
||
}
|
||
|
||
$welder_locations = welder_locations();
|
||
|
||
$weldmap = db("weld_logs")
|
||
->select(
|
||
"welder_1",
|
||
"welder_2",
|
||
"welding_date",
|
||
"nps_1",
|
||
)
|
||
// ->selectRaw("SUM(nps_1) AS wdi")
|
||
// ->whereDate("welding_date", get("welding_date"))
|
||
// ->whereRaw("NULLIF(welder_1, '') IS NOT NULL")
|
||
->whereNotNull("welding_date")
|
||
// ->groupBy("welder_1", "welding_date")
|
||
->get();
|
||
|
||
$data = [];
|
||
|
||
foreach($weldmap AS $w) {
|
||
$date = date("Y-m-d", strtotime($w->welding_date));
|
||
$bolum = ($w->welder_2 != "") ? 2 : 1;
|
||
$nps1 = str_replace(',', '.', $w->nps_1);
|
||
|
||
// Her kaynak işlemi için detaylı log
|
||
$originalNps = $nps1;
|
||
$dividedNps = is_numeric($nps1) ? number_format((float)$nps1 / $bolum, 3, '.', '') : 0;
|
||
|
||
if ($w->welder_1 != "") {
|
||
$welder = get_welder_id($w->welder_1);
|
||
if (!isset($data[$welder][$date])) {
|
||
$data[$welder][$date] = 0;
|
||
}
|
||
if (is_numeric($nps1)) {
|
||
$data[$welder][$date] += (float)$dividedNps;
|
||
}
|
||
}
|
||
|
||
if ($w->welder_2 != "") {
|
||
$welder = get_welder_id($w->welder_2);
|
||
if (!isset($data[$welder][$date])) {
|
||
$data[$welder][$date] = 0;
|
||
}
|
||
if (is_numeric($nps1)) {
|
||
$data[$welder][$date] += (float)$dividedNps;
|
||
}
|
||
}
|
||
|
||
|
||
|
||
|
||
/*
|
||
if($welder == "BXH0") {
|
||
if($date == "2023-11-21") {
|
||
Log::debug("BXH0 {$w->nps_1}");
|
||
}
|
||
}
|
||
*/
|
||
|
||
|
||
}
|
||
|
||
|
||
$result = [];
|
||
|
||
foreach($data AS $welder => $subData) {
|
||
foreach($subData AS $date => $nps) {
|
||
$result[] = [
|
||
'welder' => $welder,
|
||
'wdi' => $nps,
|
||
'loc' => @$welder_locations[$welder],
|
||
'welding_date' => $date
|
||
];
|
||
}
|
||
|
||
}
|
||
|
||
/*
|
||
foreach($weldmap AS &$w) {
|
||
|
||
if($w->welder_1 != "") {
|
||
$w->welder = get_welder_id($w->welder_1);
|
||
}
|
||
|
||
if($w->welder_2 != "") {
|
||
$w->welder = get_welder_id($w->welder_2);
|
||
}
|
||
|
||
$location = WelderLocation::where("naks_id", $w->welder)->first();
|
||
|
||
if($location) {
|
||
$w->loc = $location->location;
|
||
}
|
||
|
||
|
||
|
||
}
|
||
*/
|
||
|
||
|
||
|
||
|
||
echo json_encode_tr($result);
|
||
|
||
|
||
?>
|