db->query($sql, [$nolab,$nolab]);
if (!$qry) {
echo json_encode([
"status" => "ERR",
"message" => print_r($this->db->error(), true),
]);
exit();
}
$rows = $qry->result_array();
if (count($rows) == 0) {
echo $this->db->last_query();
echo "No record";
exit();
}
$orderHeaderID = $rows[0]["T_OrderHeaderID"];
$sql = "select count(*) xtot
from
t_orderheaderaddon
where T_OrderHeaderAddOnT_OrderHeaderID=? and T_OrderHeaderAddOnSecondM_LangID = 2";
$qry = $this->db->query($sql, [$orderHeaderID]);
if (!$qry) {
echo json_encode([
"status" => "ERR",
"message" => print_r($this->db->error(), true),
]);
exit();
}
$xrows = $qry->result_array();
$flag_have_en = true;
if (count($xrows) == 0) {
$flag_have_en = false;
}
foreach($rows as $idx => $r) {
unset($rows[$idx]["T_OrderHeaderID"]);
$rows[$idx]["English"] = $flag_have_en ? "Requested" : "Not Requested";
}
$this->print_table_style();
$this->print_table($rows, array_keys($rows[0]));
echo "
";
$url_barcode = "/one-api/chart/the_qr/v3_dual/$orderHeaderID/" . date("Y-m-dHis");
echo "
";
if ($flag_have_en) {
echo "Call sp_rpt_t_hasil_eng($orderHeaderID,'admin'), hasil :
\n";
$sql = "call sp_rpt_t_hasil_eng(?,'admin')";
$qry = $this->db->query($sql,[$orderHeaderID]);
if (!$qry) {
echo json_encode([
"status" => "ERR",
"message" => print_r($this->db->error(), true),
]);
exit();
}
$rows = $qry->result_array();
print_r($rows);
}
}
public function print_table_style()
{
echo "
";
}
public function print_table($rows, $keys)
{
$this->print_table_style();
echo "";
echo "";
foreach ($keys as $k) {
echo "| $k | ";
}
echo "
\n";
foreach ($rows as $r) {
echo "";
foreach ($keys as $k) {
echo "| " . $r[$k] . " | ";
}
echo "
";
}
echo "
";
}
}