Ümit Tunç
44 lines
1.6 KiB
PHP
44 lines
1.6 KiB
PHP
<?php
|
|
/**
|
|
* @api-readonly
|
|
* Returns paint matrix info for weld logs
|
|
*/
|
|
$paintMatrixQuery = db("paint_follow_ups")->get();
|
|
$paintMatrix = [];
|
|
|
|
foreach($paintMatrixQuery AS $pmq) {
|
|
if($pmq->line!="") {
|
|
$paintMatrix[$pmq->iso_number][$pmq->spool_no_joint_no] = $pmq;
|
|
}
|
|
|
|
}
|
|
|
|
$isoNumbers = explode(",", post("iso_number"));
|
|
$spoolNumbers = explode(",", post("spool_number"));
|
|
|
|
$weldLogs = db("weld_logs")
|
|
->where("spool_status", "Paint")
|
|
->whereIn("iso_number", $isoNumbers)
|
|
->whereIn("spool_number", $spoolNumbers)
|
|
->groupBy("iso_number","spool_number")
|
|
->get();
|
|
|
|
foreach($weldLogs AS $weldLog) {
|
|
if(isset($paintMatrix[$weldLog->iso_number][$weldLog->spool_number])) {
|
|
$matrixData = $paintMatrix[$weldLog->iso_number][$weldLog->spool_number];
|
|
$weldLog->brend_name_1 = $matrixData->brend_name_1;
|
|
$weldLog->brend_name_2 = $matrixData->brend_name_2;
|
|
$weldLog->brend_name_3 = $matrixData->brend_name_3;
|
|
$weldLog->primer_measured_thickness_1 = $matrixData->primer_measured_thickness_1 != "" ? $matrixData->primer_measured_thickness_1 : $matrixData->thickness_1;
|
|
$weldLog->intermediate_measured_thickness_2 = $matrixData->intermediate_measured_thickness_2 != "" ? $matrixData->intermediate_measured_thickness_2 : $matrixData->thickness_2;
|
|
$weldLog->final_coating_measured_thickness_3 = $matrixData->final_coating_measured_thickness_3 != "" ? $matrixData->final_coating_measured_thickness_3 : $matrixData->thickness_3;
|
|
$weldLog->id = $matrixData->id;
|
|
} else {
|
|
$weldLog->id = "";
|
|
}
|
|
|
|
|
|
}
|
|
echo json_encode_tr($weldLogs);
|
|
|
|
?>
|