Ümit Tunç
613 lines
25 KiB
PHP
613 lines
25 KiB
PHP
<?php
|
||
/**
|
||
* @api-readonly
|
||
* Returns NDT calculation data (no cache)
|
||
*/
|
||
$lineTypeWelderToIso = lineTypeWelderToIso();
|
||
$query = apply_welded_filter(db("weld_logs"));
|
||
$repairLogs = db("repair_logs")
|
||
|
||
->where("repair_status", "Not Done");
|
||
|
||
if(isset($type))
|
||
{
|
||
$_GET['type'] = $type;
|
||
}
|
||
|
||
if(isset($test_package_no))
|
||
{
|
||
$_GET['test_package_no'] = $test_package_no;
|
||
}
|
||
|
||
if(isset($iso_number2))
|
||
{
|
||
$_GET['iso_number2'] = $iso_number2;
|
||
}
|
||
|
||
|
||
if(!getesit("iso_number","")) {
|
||
$query = $query->where("iso_number", "like", "%" . get("iso_number") . "%");
|
||
}
|
||
|
||
if(!getesit("iso_number2","")) {
|
||
$query = $query->where("iso_number", get("iso_number2"));
|
||
}
|
||
|
||
|
||
|
||
if(!getesit("test_package_no", ""))
|
||
{
|
||
$query = $query->where("test_package_no", get("test_package_no"));
|
||
$repairLogs = $repairLogs->where("test_package_no", get("test_package_no"));
|
||
}
|
||
$query = $query
|
||
//->where("no_of_the_joint_as_per_as_built_survey", "not like", "%R%")
|
||
->get();
|
||
|
||
$repairLogs = $repairLogs->get();
|
||
|
||
$data = [];
|
||
$dataTotal = [];
|
||
$acceptTotal = [];
|
||
$pwhtYesTotal = [];
|
||
$pwhtNoTotal = [];
|
||
$pwhtDate = [];
|
||
$ferriteTotal = [];
|
||
$pmiTotal = [];
|
||
$rtTotal = [];
|
||
$logTypes = array_keys(log_test_types());
|
||
|
||
$jointsTotals = [];
|
||
|
||
$totalWeldedJoints = [];
|
||
|
||
$notAcceptTotal = [];
|
||
$repairTotal = [];
|
||
|
||
$requestNDT = [];
|
||
|
||
$rejCutResults = ['Cut / Резать', 'Reject / Reject', 'Repair / Ремонт'];
|
||
$accResults = ['Accept / Годен'];
|
||
$accResultsExtend = ['', 'Accept / Годен'];
|
||
$totalWithoutRejCut = [];
|
||
|
||
$isoToTP = [];
|
||
$isoToProject = [];
|
||
$isoToDesignArea = [];
|
||
|
||
|
||
foreach($query AS $q) {
|
||
$maxWelderNo = 2;
|
||
if($q->welder_1 == $q->welder_2) {
|
||
$maxWelderNo = 1;
|
||
}
|
||
|
||
$isoToTP[$q->line_number] = $q->test_package_no;
|
||
$isoToProject[$q->line_number] = $q->project;
|
||
$isoToDesignArea[$q->line_number] = $q->design_area;
|
||
|
||
|
||
|
||
for($welderNo = 1; $welderNo<=$maxWelderNo; $welderNo++) {
|
||
$arrayQ = (array) $q;
|
||
$welderName = get_welder_id($arrayQ['welder_'.$welderNo]);
|
||
|
||
if($welderName != "") {
|
||
|
||
foreach($logTypes AS $logType) {
|
||
$requestDate = $logType . '_request_date';
|
||
$testing_date = $logType . '_test_date';
|
||
$result_no = $logType . '_result';
|
||
if(!isset($requestNDT[$logType][$welderName][$q->line_number][$q->type_of_welds])) $requestNDT[$logType][$welderName][$q->line_number][$q->type_of_welds] = 0;
|
||
if(!rejected_date($q->$requestDate)) {
|
||
if($q->$testing_date == "") {
|
||
if($q->$result_no == "") {
|
||
|
||
$requestNDT[$logType][$welderName][$q->line_number][$q->type_of_welds]++;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
if(!isset($data[$welderName][$q->line_number][$q->type_of_welds]))
|
||
$data[$welderName][$q->line_number][$q->type_of_welds] = [];
|
||
|
||
if(!isset($data[$welderName][$q->line_number][$q->type_of_welds]['total']))
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['total'] = 0;
|
||
|
||
if(!isset($data[$welderName][$q->line_number][$q->type_of_welds]['total_acc']))
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['total_acc'] = 0;
|
||
|
||
if(!isset($data[$welderName][$q->line_number][$q->type_of_welds]['without_welding_total']))
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['without_welding_total'] = 0;
|
||
|
||
if(!isset($dataTotal[$q->line_number][$q->type_of_welds]))
|
||
$dataTotal[$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
foreach($logTypes AS $logType) {
|
||
if(!isset($acceptTotal[$welderName][$q->line_number][$q->type_of_welds][$logType]))
|
||
$acceptTotal[$welderName][$q->line_number][$q->type_of_welds][$logType] = 0;
|
||
$notAcceptTotal[$welderName][$q->line_number][$q->type_of_welds][$logType] = 0;
|
||
}
|
||
|
||
|
||
if(!isset($pwhtYesTotal[$q->line_number][$q->type_of_welds]))
|
||
$pwhtYesTotal[$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
if(!isset($pwhtNoTotal[$q->line_number][$q->type_of_welds]))
|
||
$pwhtNoTotal[$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
if(!isset($pwhtDate[$q->line_number]))
|
||
$pwhtDate[$q->line_number] = 0;
|
||
|
||
if(!isset($ferriteTotal[$q->line_number]))
|
||
$ferriteTotal[$q->line_number] = 0;
|
||
|
||
if(!isset($totalWeldedJoints[$q->type_of_welds]))
|
||
$totalWeldedJoints[$q->type_of_welds] = 0;
|
||
|
||
if($q->welding_date!="") {
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['total']++;
|
||
} else {
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['without_welding_total']++;
|
||
}
|
||
|
||
if(!isset($jointsTotals[$q->line_number][$q->type_of_welds]))
|
||
$jointsTotals[$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
$jointsTotals[$q->line_number][$q->type_of_welds]++;
|
||
|
||
if(!isset($totalWithoutRejCut[$welderName][$q->line_number][$q->type_of_welds]))
|
||
$totalWithoutRejCut[$welderName][$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
|
||
if(!in_array($q->rt_result, $rejCutResults)) {
|
||
$totalWithoutRejCut[$welderName][$q->line_number][$q->type_of_welds]++;
|
||
}
|
||
|
||
if(!isset($totalAcc[$welderName][$q->line_number][$q->type_of_welds]))
|
||
$totalAcc[$welderName][$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
if(in_array($q->rt_result, $accResults)) {
|
||
$totalAcc[$welderName][$q->line_number][$q->type_of_welds]++;
|
||
}
|
||
|
||
if(!isset($totalAccExtend[$welderName][$q->line_number][$q->type_of_welds]))
|
||
$totalAccExtend[$welderName][$q->line_number][$q->type_of_welds] = 0;
|
||
|
||
if(in_array($q->rt_result, $accResultsExtend)) {
|
||
$totalAccExtend[$welderName][$q->line_number][$q->type_of_welds]++;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['total_acc']++;
|
||
}
|
||
|
||
$dataTotal[$q->line_number][$q->type_of_welds]++;
|
||
|
||
if($q->pwht == "YES") {
|
||
$pwhtYesTotal[$q->line_number][$q->type_of_welds]++;
|
||
} else {
|
||
$pwhtNoTotal[$q->line_number][$q->type_of_welds]++;
|
||
}
|
||
|
||
if($q->pwht_date != "") {
|
||
$pwhtDate[$q->line_number]++;
|
||
}
|
||
|
||
if($q->ferrite_scope == 100) {
|
||
$ferriteTotal[$q->line_number]++;
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
$vtScope = 100;
|
||
foreach($logTypes AS $logType) {
|
||
$aq = (Array) $q;
|
||
if($aq[$logType . '_result'] == "Accept / Годен") {
|
||
$acceptTotal[$welderName][$q->line_number][$q->type_of_welds][$logType]++;
|
||
} elseif($aq[$logType . '_result'] != "") {
|
||
if($q->welding_date != "") {
|
||
$notAcceptTotal[$welderName][$q->line_number][$q->type_of_welds][$logType]++;
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
|
||
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['vt_scope'] = $vtScope;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['rt_scope'] = (int) $q->rt_scope ? $q->rt_scope : 0;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['ut_scope'] = (int) $q->ut_scope ? $q->ut_scope : 0;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['pt_scope'] = (int) $q->pt_scope ? $q->pt_scope : 0;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['mt_scope'] = (int) $q->mt_scope ? $q->mt_scope : 0 ;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['ht_scope'] = (int) $q->ht_scope ? $q->ht_scope : 0 ;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['pmi_scope'] = $q->pmi_scope ? $q->pmi_scope : 0;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['ferrite_scope'] = (int) $q->ferrite_scope ? $q->ferrite_scope : 0;
|
||
$data[$welderName][$q->line_number][$q->type_of_welds]['pwht']= $q->pwht;
|
||
}
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
|
||
}
|
||
|
||
foreach($repairLogs AS $repairLog) {
|
||
|
||
if(!isset($repairTotal[$repairLog->welder_1][$repairLog->line_number][$repairLog->type_of_welds]))
|
||
$repairTotal[$repairLog->welder_1][$repairLog->line_number][$repairLog->type_of_welds] = 0;
|
||
|
||
$repairTotal[$repairLog->welder_1][$repairLog->line_number][$repairLog->type_of_welds]++;
|
||
|
||
if($repairLog->welder_2 != "") {
|
||
|
||
if($repairLog->welder_1 != $repairLog->welder_2) {
|
||
|
||
if(!isset($repairTotal[$repairLog->welder_2][$repairLog->line_number][$repairLog->type_of_welds]))
|
||
$repairTotal[$repairLog->welder_2][$repairLog->line_number][$repairLog->type_of_welds] = 0;
|
||
|
||
$repairTotal[$repairLog->welder_2][$repairLog->line_number][$repairLog->type_of_welds]++;
|
||
}
|
||
}
|
||
|
||
}
|
||
|
||
|
||
|
||
|
||
$refactoringData = [];
|
||
$refactoringData2 = [];
|
||
$manageData = [];
|
||
$scopeData = [];
|
||
|
||
$cols = [
|
||
'RT/UT',
|
||
'PT/MT',
|
||
'PMI',
|
||
'Ferrit',
|
||
'PWHT',
|
||
'Total Welded Joints',
|
||
];
|
||
$rows = [
|
||
'BW',
|
||
'FW',
|
||
'SW',
|
||
];
|
||
|
||
foreach($cols AS $col) {
|
||
foreach($rows AS $row) {
|
||
$manageData[$col][$row] = 0;
|
||
}
|
||
}
|
||
|
||
foreach($data AS $welder => $isoData) {
|
||
foreach($isoData AS $lineNumber => $weldData) {
|
||
$refactoringData[$welder][$lineNumber] = $weldData;
|
||
foreach($weldData AS $weldName => $subData) {
|
||
|
||
$grandTotal = $subData['total'];
|
||
$jointsTotal = $subData['without_welding_total'];
|
||
$pwhtScopeTotal = $pwhtYesTotal[$lineNumber][$weldName];
|
||
$pwhtDateTotal = $pwhtDate[$lineNumber];
|
||
$totalWeldedJoints[$weldName] += $grandTotal;
|
||
/*
|
||
if(isset($rtTotal[$welder][$lineNumber]))
|
||
// $subData['rt_scope'] = $rtTotal[$welder][$lineNumber];
|
||
*/
|
||
|
||
if(isset($acceptTotal[$welder][$lineNumber][$weldName])) {
|
||
$thisAcceptTotal = $acceptTotal[$welder][$lineNumber][$weldName];
|
||
}
|
||
|
||
if(isset($notAcceptTotal[$welder][$lineNumber][$weldName])) {
|
||
$thisNotAcceptTotal = $notAcceptTotal[$welder][$lineNumber][$weldName];
|
||
}
|
||
|
||
$rtScopeCalc = ceil( ( ( $subData['rt_scope'] * $subData['total_acc']) /100 - $thisNotAcceptTotal['rt'] ) );
|
||
|
||
if($weldName == "SW") {
|
||
$swTotal = $dataTotal[$lineNumber][$weldName];
|
||
$rtScopeCalc = ceil($subData['rt_scope'] * ($swTotal - $thisNotAcceptTotal['rt']) /100);
|
||
$rtTotal[$welder][$lineNumber] = $subData['rt_scope'];
|
||
//burası debuging yapılacak pmidaki gibi tüm alanlarda aynı değer
|
||
}
|
||
|
||
|
||
|
||
|
||
$thisFerriteTotal = 0;
|
||
if(isset($ferriteTotal[$lineNumber])) {
|
||
$thisFerriteTotal = $ferriteTotal[$lineNumber];
|
||
}
|
||
|
||
if($subData['pwht']=="NO" || $subData['pwht']=="") {
|
||
$pwhtBacklog = 0;
|
||
$htBacklog = 0;
|
||
} else {
|
||
$pwhtBacklog = ($grandTotal - $thisNotAcceptTotal['pwht']) - $thisAcceptTotal['pwht'];
|
||
$htBacklog = ($grandTotal - $thisNotAcceptTotal['ht']) - $thisAcceptTotal['ht'];
|
||
}
|
||
|
||
if($rtScopeCalc<0) {
|
||
$rtScopeCalc = 0;
|
||
}
|
||
|
||
|
||
$refactoringData[$welder][$lineNumber][$weldName]['rt_backlog'] = $rtScopeCalc;
|
||
|
||
$refactoringData[$welder][$lineNumber][$weldName]['vt_backlog'] = ceil($subData['vt_scope'] * ($grandTotal - $thisNotAcceptTotal['vt']) /100) - $thisAcceptTotal['vt'];
|
||
$refactoringData[$welder][$lineNumber][$weldName]['ut_backlog'] = ceil($subData['ut_scope'] * ($grandTotal - $thisNotAcceptTotal['ut']) /100) - $thisAcceptTotal['ut'];
|
||
$refactoringData[$welder][$lineNumber][$weldName]['pt_backlog'] = ceil($subData['pt_scope'] * ($grandTotal - $thisNotAcceptTotal['pt']) /100) - $thisAcceptTotal['pt'];
|
||
$refactoringData[$welder][$lineNumber][$weldName]['mt_backlog'] = ceil($subData['mt_scope'] * ($grandTotal - $thisNotAcceptTotal['mt']) /100) - $thisAcceptTotal['mt'];
|
||
$refactoringData[$welder][$lineNumber][$weldName]['ht_backlog'] = $htBacklog;
|
||
|
||
if(strpos($subData['pmi_scope'], "*") !== false) {
|
||
$subData['pmi_scope'] = str_replace("*", "", $subData['pmi_scope']);
|
||
if($grandTotal >= 2) {
|
||
$subData['pmi_scope'] = 2;
|
||
} elseif($grandTotal < 2) {
|
||
$subData['pmi_scope'] = 1;
|
||
}
|
||
$pmiBacklog = $subData['pmi_scope'] - $thisAcceptTotal['pmi'];
|
||
$pmiTotal[$welder][$lineNumber] = $subData['pmi_scope'];
|
||
//buraya joint type dan bağımsız olarak bir toplam yapmalıyız üstte değişken tanımı yapıldı.
|
||
|
||
} else {
|
||
|
||
if(isset($pmiTotal[$welder][$lineNumber]))
|
||
$subData['pmi_scope'] = $pmiTotal[$welder][$lineNumber];
|
||
|
||
$pmiBacklog = ceil($subData['pmi_scope'] * ($grandTotal - $thisNotAcceptTotal['pmi']) /100) - $thisAcceptTotal['pmi'];
|
||
}
|
||
|
||
$thisRepairTotal = 0;
|
||
if(isset($repairTotal[$welder][$lineNumber][$weldName])) {
|
||
$thisRepairTotal = $repairTotal[$welder][$lineNumber][$weldName];
|
||
}
|
||
|
||
|
||
|
||
|
||
$refactoringData[$welder][$lineNumber][$weldName]['pmi_backlog'] = $pmiBacklog;
|
||
|
||
$refactoringData[$welder][$lineNumber][$weldName]['pwht_backlog'] = $pwhtBacklog;
|
||
$refactoringData[$welder][$lineNumber][$weldName]['ferrite_backlog'] = ceil($subData['ferrite_scope'] * ($grandTotal - $thisNotAcceptTotal['ferrite']) /100) - $thisAcceptTotal['ferrite'];//ceil($thisFerriteTotal * $grandTotal /100) - $thisAcceptTotal;
|
||
|
||
$rowData = [
|
||
'welder' => $welder,
|
||
'line_number' => $lineNumber,
|
||
'project' => $isoToProject[$lineNumber] ?? null,
|
||
'design_area' => $isoToDesignArea[$lineNumber] ?? null,
|
||
'iso_number' => $lineTypeWelderToIso[$lineNumber . '|' . $weldName . '|' . $welder] ?? null,
|
||
'weld_name' => $weldName,
|
||
'vt_scope' => $subData['vt_scope'],
|
||
'rt_scope' => $subData['rt_scope'],
|
||
'ut_scope' => $subData['ut_scope'],
|
||
'pt_scope' => $subData['pt_scope'],
|
||
'mt_scope' => $subData['mt_scope'],
|
||
'pmi_scope' => $subData['pmi_scope'],
|
||
// 'ferrit_scope' => $thisFerriteTotal,
|
||
|
||
'pwht' => $subData['pwht'],
|
||
'vt_backlog' => ceil($subData['vt_scope'] * ($grandTotal - $thisNotAcceptTotal['vt']) /100) - $thisAcceptTotal['vt'],
|
||
'vt_rq' => $requestNDT['vt'][$welder][$lineNumber][$weldName],
|
||
'vt_balance' => (ceil($subData['vt_scope'] * ($grandTotal - $thisNotAcceptTotal['vt']) /100) - $thisAcceptTotal['vt']) - $requestNDT['vt'][$welder][$lineNumber][$weldName],
|
||
|
||
'rt_backlog' => $rtScopeCalc - $thisAcceptTotal['rt'],
|
||
'rt_rq' => $requestNDT['rt'][$welder][$lineNumber][$weldName],
|
||
'rt_balance' => ($rtScopeCalc - $thisAcceptTotal['rt']) - $requestNDT['rt'][$welder][$lineNumber][$weldName],
|
||
|
||
'ut_backlog' => ceil($subData['ut_scope'] * ($grandTotal - $thisNotAcceptTotal['ut']) /100) - $thisAcceptTotal['ut'],
|
||
'ut_rq' => $requestNDT['ut'][$welder][$lineNumber][$weldName],
|
||
'ut_balance' => (ceil($subData['ut_scope'] * ($grandTotal - $thisNotAcceptTotal['ut']) /100) - $thisAcceptTotal['ut']) - $requestNDT['ut'][$welder][$lineNumber][$weldName],
|
||
|
||
'pt_backlog' => ceil($subData['pt_scope'] * ($grandTotal - $thisNotAcceptTotal['pt']) /100) - $thisAcceptTotal['pt'],
|
||
'pt_rq' => $requestNDT['pt'][$welder][$lineNumber][$weldName],
|
||
'pt_balance' => (ceil($subData['pt_scope'] * ($grandTotal - $thisNotAcceptTotal['pt']) /100) - $thisAcceptTotal['pt']) - $requestNDT['pt'][$welder][$lineNumber][$weldName],
|
||
|
||
'mt_backlog' => ceil($subData['mt_scope'] * ($grandTotal - $thisNotAcceptTotal['mt']) /100) - $thisAcceptTotal['mt'],
|
||
'mt_rq' => $requestNDT['mt'][$welder][$lineNumber][$weldName],
|
||
'mt_balance' => (ceil($subData['mt_scope'] * ($grandTotal - $thisNotAcceptTotal['mt']) /100) - $thisAcceptTotal['mt']) - $requestNDT['mt'][$welder][$lineNumber][$weldName],
|
||
|
||
'ht_backlog' => $htBacklog,
|
||
'ht_rq' => array_sum($requestNDT['ht'][$welder][$lineNumber]),
|
||
'ht_balance' => $htBacklog - array_sum($requestNDT['ht'][$welder][$lineNumber]),
|
||
|
||
'pmi_backlog' => $pmiBacklog,
|
||
'pmi_rq' => array_sum($requestNDT['pmi'][$welder][$lineNumber]),
|
||
'pmi_balance' => $pmiBacklog - array_sum($requestNDT['pmi'][$welder][$lineNumber]),
|
||
|
||
'ferrite_backlog' => ceil($subData['ferrite_scope'] * ($grandTotal - $thisNotAcceptTotal['ferrite']) /100) - $thisAcceptTotal['ferrite'],
|
||
'ferrite_rq' => array_sum($requestNDT['ferrite'][$welder][$lineNumber]),
|
||
'ferrite_balance' => (ceil($subData['ferrite_scope'] * ($grandTotal - $thisNotAcceptTotal['ferrite']) /100) - $thisAcceptTotal['ferrite']) - array_sum($requestNDT['ferrite'][$welder][$lineNumber]),
|
||
|
||
'pwht_backlog' => $pwhtBacklog,
|
||
'pwht_rq' => array_sum($requestNDT['pwht'][$welder][$lineNumber]),
|
||
'pwht_balance' => $pwhtBacklog - array_sum($requestNDT['pwht'][$welder][$lineNumber]),
|
||
'remaining_repair' => $thisRepairTotal,
|
||
'grand_total' => $grandTotal,
|
||
'joints_total' => $jointsTotals[$lineNumber][$weldName],
|
||
'total_without_rej_cut' => $totalWithoutRejCut[$welder][$lineNumber][$weldName],
|
||
'total_acc' => $totalAcc[$welder][$lineNumber][$weldName],
|
||
'total_by_weld' => $totalWeldedJoints[$weldName],
|
||
// 'accept_total' => $thisAcceptTotal,
|
||
];
|
||
|
||
$refactoringData2[] = $rowData;
|
||
$pmiScope = $subData['pmi_scope'];
|
||
if($subData['pmi_scope'] == 1) $pmiScope = 100;
|
||
|
||
$scopeData['RT/UT'] = "{$subData['rt_scope']} / {$subData['ut_scope']}";
|
||
$scopeData['PT/MT'] = "{$subData['pt_scope']} / {$subData['mt_scope']}";
|
||
$scopeData['PMI'] = $pmiScope;
|
||
$scopeData['Ferrit'] = "$thisFerriteTotal";
|
||
$scopeData['PWHT'] = "{$subData['pwht']}";
|
||
$scopeData['Total Welded Joints'] = "";
|
||
|
||
if(in_array($weldName, $rows)) {
|
||
$manageData['RT/UT'][$weldName] += $rtScopeCalc - $thisAcceptTotal['rt'];
|
||
$manageData['RT/UT'][$weldName] += ceil($subData['ut_scope'] * ($grandTotal - $thisNotAcceptTotal['ut']) /100) - $thisAcceptTotal['ut'];
|
||
$manageData['PT/MT'][$weldName] += ceil($subData['pt_scope'] * ($grandTotal - $thisNotAcceptTotal['pt']) /100) - $thisAcceptTotal['pt'];
|
||
$manageData['PT/MT'][$weldName] += ceil($subData['mt_scope'] * ($grandTotal - $thisNotAcceptTotal['mt']) /100) - $thisAcceptTotal['mt'];
|
||
$manageData['Ferrit'][$weldName] += ceil($thisFerriteTotal * ($grandTotal - $thisNotAcceptTotal['ferrite']) /100) - $thisAcceptTotal['ferrite'];
|
||
$manageData['PWHT'][$weldName] += $pwhtBacklog;
|
||
$manageData['Total Welded Joints'][$weldName] = $totalWeldedJoints[$weldName];
|
||
|
||
|
||
}
|
||
|
||
|
||
|
||
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
|
||
|
||
|
||
if(getisset("iso_number") && !getisset("all")) {
|
||
|
||
|
||
|
||
$stats = [];
|
||
foreach($cols AS $col) {
|
||
$stats[] = [
|
||
'NDE' => @$col,
|
||
'Scope' => @$scopeData[$col],
|
||
'BW' => @$manageData[$col]['BW'],
|
||
'FW' => @$manageData[$col]['FW'],
|
||
'SW' => @$manageData[$col]['SW']
|
||
];
|
||
|
||
}
|
||
|
||
|
||
echo json_encode_tr($stats);
|
||
} else {
|
||
if(getesit("type", "backlogs")) {
|
||
$json = [];
|
||
$total = [];
|
||
$testTypes = array_keys(log_test_types());
|
||
unset($testTypes[0]); //ht
|
||
unset($testTypes[7]); //ferrite
|
||
foreach($refactoringData2 AS $data) {
|
||
foreach($testTypes AS $testType) {
|
||
if(!isset($total[$testType])) $total[$testType] = 0;
|
||
|
||
if($data[$testType . '_backlog']>0) {
|
||
$total[$testType] += $data[$testType . '_backlog'];
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
foreach($testTypes AS $testType) {
|
||
if($total[$testType] > 0) {
|
||
$json[] = [
|
||
'TYPE' => strtoupper($testType),
|
||
'BACKLOG' => $total[$testType]
|
||
];
|
||
} elseif($total[$testType]==0) {
|
||
$json[] = [
|
||
'TYPE' => strtoupper($testType),
|
||
'BACKLOG' => $total[$testType]
|
||
];
|
||
}
|
||
|
||
}
|
||
setting_put("ndtCalculationBacklogs", $json);
|
||
echo json_encode_tr($json);
|
||
|
||
} elseif(getesit("type", "test_packs")) {
|
||
$tpStats = [];
|
||
$tpISOStats = [];
|
||
foreach($refactoringData2 AS $row)
|
||
{
|
||
// Doğru ISO/TP ilişkisini kullanarak TP numarasını al
|
||
$tpNo = "";
|
||
if(isset($row['line_number']) && isset($isoToTP[$row['line_number']])) {
|
||
$tpNo = trim($isoToTP[$row['line_number']]);
|
||
} else if(isset($row['iso_number']) && isset($isoToTP[$row['iso_number']])) {
|
||
$tpNo = trim($isoToTP[$row['iso_number']]);
|
||
}
|
||
|
||
if($tpNo != "")
|
||
{
|
||
$testTypes = array_keys(log_test_types());
|
||
|
||
if(!isset($tpStats[$tpNo]))
|
||
{
|
||
$tpStats[$tpNo]['test_package_no'] = $tpNo;
|
||
foreach($testTypes AS $testType)
|
||
{
|
||
$tpStats[$tpNo][$testType] = 0;
|
||
}
|
||
}
|
||
|
||
if(!isset($tpISOStats[$tpNo][$row['iso_number']]))
|
||
{
|
||
$tpISOStats[$tpNo][$row['iso_number']]['test_package_no'] = $tpNo;
|
||
$tpISOStats[$tpNo][$row['iso_number']]['iso_number'] = $row['iso_number'];
|
||
foreach($testTypes AS $testType)
|
||
{
|
||
$tpISOStats[$tpNo][$row['iso_number']][$testType] = 0;
|
||
}
|
||
}
|
||
|
||
foreach($testTypes AS $testType)
|
||
{
|
||
// Backlog değeri kontrolü ve negatif değerleri sıfıra dönüştürme
|
||
$backlogValue = 0;
|
||
if(isset($row[$testType . '_backlog'])) {
|
||
$backlogValue = max(0, (int)$row[$testType . '_backlog']);
|
||
}
|
||
|
||
if($backlogValue > 0)
|
||
{
|
||
$tpStats[$tpNo][$testType] += $backlogValue;
|
||
$tpISOStats[$tpNo][$row['iso_number']][$testType] += $backlogValue;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
$tpStatsRefactor = [];
|
||
foreach($tpStats AS $tpStat)
|
||
{
|
||
$tpStatsRefactor[] = $tpStat;
|
||
}
|
||
|
||
$tpISOStatsRefactor = [];
|
||
foreach($tpISOStats AS $tpNo => $data)
|
||
{
|
||
foreach($data AS $d)
|
||
{
|
||
$tpISOStatsRefactor[] = $d;
|
||
}
|
||
|
||
}
|
||
|
||
|
||
$tpDatas = [
|
||
'tp_base' => $tpStatsRefactor,
|
||
'tp_base_iso' => $tpISOStatsRefactor,
|
||
'tpStats' => $tpStats,
|
||
'tpISOStats' => $tpISOStats,
|
||
];
|
||
$json = json_encode_tr($tpDatas);
|
||
setting_put("ndtCalculationTestPack", $json);
|
||
echo $json;
|
||
} else {
|
||
$json = json_encode_tr($refactoringData2);
|
||
setting_put("ndtCalculation", $json);
|
||
echo $json;
|
||
|
||
}
|
||
|
||
}
|
||
|
||
?>
|