<?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);


?>