<?php 
/**
 * @api-readonly
 * Returns NDT paint list
 */
$query = db("weld_logs")->select(
"id",
"iso_number",
"spool_number",
"painting_cycle",
"paint_release_no",
"paint_release_date",
"spool_status",

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


    echo json_encode_tr($query);

?>