<?php 
/**
 * @api-readonly
 * Returns NDT paint list field data
 */
$query = db("weld_logs")->select(
"id",
"iso_number",
"no_of_the_joint_as_per_as_built_survey AS joint_no",
"painting_cycle",
"paint_release_no",
"paint_release_date",
"tp_status",

)
->groupBy("iso_number", "spool_number")
->whereNotNull("paint_release_no")
->get();


    echo json_encode_tr($query);

?>