Ümit Tunç
46 lines
1.3 KiB
PHP
46 lines
1.3 KiB
PHP
<?php
|
|
use Carbon\Carbon;
|
|
$qcWeldlogs = [];
|
|
|
|
if(getisset("iso_number")) {
|
|
$qcWeldlogs = db("weld_logs")
|
|
->select(
|
|
"id",
|
|
"iso_number",
|
|
"iso_rev",
|
|
"type_of_joint",
|
|
"no_of_the_joint_as_per_as_built_survey AS joint_no",
|
|
"welding_date",
|
|
"welder_1",
|
|
"welder_2",
|
|
"certificate_no_1",
|
|
"wpq_report_1",
|
|
"certificate_no_2",
|
|
"wpq_report_2",
|
|
"ru_material_group_1 AS ru_1",
|
|
"ru_material_group_2 AS ru_2",
|
|
"outside_diameter_1 AS odmm",
|
|
"wall_thickness_1 AS tck",
|
|
"welding_method AS wm",
|
|
)
|
|
->where("iso_number", "like", "%" . get("iso_number") . "%")
|
|
->whereNotNull("welding_date")
|
|
// ->where("no_of_the_joint_as_per_as_built_survey", get("joint_no"))
|
|
->get();
|
|
|
|
foreach($qcWeldlogs AS $data) {
|
|
if($data->welder_1 != "") $data->welder_1 = get_welder_id($data->welder_1);
|
|
if($data->welder_2 != "") $data->welder_2 = get_welder_id($data->welder_2);
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
echo json_encode_tr($qcWeldlogs);
|
|
|
|
|
|
?>
|