431 lines
15 KiB
PHP
431 lines
15 KiB
PHP
<?php
|
|
class The_qr extends MY_Controller
|
|
{
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
}
|
|
public function get_one_row($sql, $param = false)
|
|
{
|
|
if ($param) {
|
|
$qry = $this->db->query($sql, $param);
|
|
} else {
|
|
$qry = $this->db->query($sql);
|
|
}
|
|
if (!$qry) {
|
|
return ["status" => -1];
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0) {
|
|
return ["status" => 0];
|
|
}
|
|
return ["status" => 1, "data" => $rows[0]];
|
|
}
|
|
public function get_rows($sql, $param = false)
|
|
{
|
|
if ($param) {
|
|
$qry = $this->db->query($sql, $param);
|
|
} else {
|
|
$qry = $this->db->query($sql);
|
|
}
|
|
if (!$qry) {
|
|
return ["status" => -1];
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0) {
|
|
return ["status" => 0];
|
|
}
|
|
return ["status" => 1, "data" => $rows];
|
|
}
|
|
public function v1($orderHeaderID, $date = "")
|
|
{
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$r = $rows[0];
|
|
|
|
$msg = <<<EOF
|
|
{$r["T_OrderHeaderLabNumber"]}
|
|
{$r["M_PatientName"]}
|
|
EOF;
|
|
$msg = trim($msg);
|
|
$msg .= "\n";
|
|
foreach ($rows as $r) {
|
|
$msg .=
|
|
$r["T_TestNameAA"] .
|
|
" : " .
|
|
str_replace("</br>", "", $r["T_OrderDetailResult"]) .
|
|
"\n";
|
|
}
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $msg);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
public function post($url, $data)
|
|
{
|
|
$ch = curl_init($url);
|
|
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
|
|
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
|
|
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
|
|
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
|
|
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
|
|
curl_setopt($ch, CURLOPT_HTTPHEADER, [
|
|
"Content-Type: application/text",
|
|
"Content-Length: " . strlen($data),
|
|
]);
|
|
$result = curl_exec($ch);
|
|
|
|
if (curl_error($ch) != "") {
|
|
return "ERROR Accessing QrCode : " . curl_error($ch) . "\n";
|
|
}
|
|
curl_close($ch);
|
|
return $result;
|
|
}
|
|
public function post_gz($url, $data)
|
|
{
|
|
$ch = curl_init($url);
|
|
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
|
|
$zdata = gzdeflate($data, 9);
|
|
curl_setopt($ch, CURLOPT_POSTFIELDS, $zdata);
|
|
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
|
|
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
|
|
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
|
|
curl_setopt($ch, CURLOPT_HTTPHEADER, [
|
|
"Content-Type: application/octet",
|
|
"Content-Length: " . strlen($zdata),
|
|
]);
|
|
$result = curl_exec($ch);
|
|
|
|
if (curl_error($ch) != "") {
|
|
return "ERROR Accessing QrCode : " . curl_error($ch) . "\n";
|
|
}
|
|
curl_close($ch);
|
|
return $result;
|
|
}
|
|
public function post_debug($url, $data)
|
|
{
|
|
$ch = curl_init($url);
|
|
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
|
|
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
|
|
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
|
|
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
|
|
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
|
|
curl_setopt($ch, CURLOPT_HTTPHEADER, [
|
|
"Content-Type: application/text",
|
|
"Content-Length: " . strlen($data),
|
|
]);
|
|
$result = curl_exec($ch);
|
|
|
|
if (curl_error($ch) != "") {
|
|
return "ERROR Accessing QrCode : " . curl_error($ch) . "\n";
|
|
}
|
|
curl_close($ch);
|
|
return $result;
|
|
}
|
|
public function v2($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$secretToken = "--!!Super!!Suket#@!1231456";
|
|
$j_result = json_encode($rows);
|
|
$jwtToken = JWT::encode($j_result, $secretToken);
|
|
|
|
$rst = $this->post(
|
|
"https://result.pramita.co.id/one-api/verify/shortener",
|
|
$jwtToken
|
|
);
|
|
$j_rst = json_decode($rst, true);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$url = $j_rst["url"];
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $url);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
|
|
public function v3_old($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$secretToken = "--!!Super!!Suket#@!1231456";
|
|
$j_result = json_encode($rows);
|
|
$jwtToken = JWT::encode($j_result, $secretToken);
|
|
|
|
$rst = $this->post(
|
|
"https://result.pramita.co.id/one-api/verify/shortener_v2",
|
|
$jwtToken
|
|
);
|
|
$j_rst = json_decode($rst, true);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$url = $j_rst["url"];
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $url);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
public function v3_dual($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$sql = "select count(*) tot
|
|
from t_orderheaderaddon
|
|
where T_OrderHeaderAddOnIsActive = 'Y'
|
|
and T_OrderHeaderAddOnSecondM_LangID = 2
|
|
and T_OrderHeaderAddOnT_OrderHeaderID = ?";
|
|
$qry = $this->db->query($sql, [$orderHeaderID]);
|
|
if (!$qry) {
|
|
echo "Error : " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
$xrows = $qry->result_array();
|
|
$flag_have_en = "N";
|
|
if ($xrows[0]["tot"] > 0) {
|
|
$flag_have_en = "Y";
|
|
$sql = "call sp_rpt_t_hasil_eng(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
$rows_en = $rs["data"];
|
|
$result_en = [];
|
|
$test_en = [];
|
|
|
|
foreach ($rows_en as $r) {
|
|
list($dob_en, $age_en) = explode(
|
|
"/",
|
|
$r["T_OrderHeaderM_PatientAge"]
|
|
);
|
|
$age_en = trim($age_en);
|
|
$sex_en = $r["M_SexName"];
|
|
$name_en = $r["M_PatientName"];
|
|
$testID = $r["T_TestID"];
|
|
$result_en[$testID] = $r["T_OrderDetailResult"];
|
|
$test_en[$testID] = $r["T_TestNameAA"];
|
|
}
|
|
}
|
|
foreach ($rows as $idx => $r) {
|
|
$rows[$idx]["HaveEnglish"] = $flag_have_en;
|
|
$testID = $r["T_TestID"];
|
|
if ($flag_have_en == "Y") {
|
|
$rows[$idx]["M_PatientName_en"] = $name_en;
|
|
$rows[$idx]["Umur_en"] = $age_en . " / " . $sex_en;
|
|
$rows[$idx]["T_OrderDetailResult_en"] = $result_en[$testID];
|
|
$rows[$idx]["T_TestNameAA_en"] = $test_en[$testID];
|
|
} else {
|
|
$rows[$idx]["Umur_en"] = "";
|
|
$rows[$idx]["T_OrderDetailResult_en"] = "";
|
|
$rows[$idx]["T_TestNameAA_en"] = "";
|
|
$rows[$idx]["M_PatientName_en"] = "";
|
|
}
|
|
}
|
|
|
|
$secretToken = "--!!Super!!Suket#@!1231456";
|
|
$j_result = json_encode($rows);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$jwtToken = JWT::encode($j_result, $secretToken);
|
|
$rst = $this->post_gz(
|
|
"https://result.pramita.co.id/one-api/verify/shortener_v2_gz",
|
|
$jwtToken
|
|
);
|
|
$j_rst = json_decode($rst, true);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$url = $j_rst["url"];
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $url);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
public function v3($orderHeaerID, $date = "") {
|
|
$this->v3_dual($orderHeaerID,$date);
|
|
}
|
|
public function v3_en($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil_eng(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$secretToken = "--!!Super!!Suket#@!1231456";
|
|
$j_result = json_encode($rows);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$jwtToken = JWT::encode($j_result, $secretToken);
|
|
$rst = $this->post_gz(
|
|
"https://result.pramita.co.id/one-api/verify/shortener_v2_gz",
|
|
$jwtToken
|
|
);
|
|
$j_rst = json_decode($rst, true);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$url = $j_rst["url"];
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $url);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
|
|
public function v3_show($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
print_r($rs);
|
|
}
|
|
public function v3_show_en($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil_eng(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
print_r($rs);
|
|
}
|
|
public function v3_before_dual($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$secretToken = "--!!Super!!Suket#@!1231456";
|
|
$j_result = json_encode($rows);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$jwtToken = JWT::encode($j_result, $secretToken);
|
|
$rst = $this->post_gz(
|
|
"https://result.pramita.co.id/one-api/verify/shortener_v2_gz",
|
|
$jwtToken
|
|
);
|
|
$j_rst = json_decode($rst, true);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
$url = $j_rst["url"];
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $url);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
|
|
public function v3b($orderHeaderID, $date = "")
|
|
{
|
|
$this->load->library("Jwt");
|
|
$sql = "call sp_rpt_t_hasil2(?,'admin')";
|
|
$rs = $this->get_rows($sql, [$orderHeaderID]);
|
|
$this->clean_mysqli_connection($this->db->conn_id);
|
|
if ($rs["status"] == -1) {
|
|
echo "Error : sp_rpt | " . $this->db->error()["message"];
|
|
exit();
|
|
}
|
|
if ($rs["status"] == 0) {
|
|
echo "Error : No Order found.";
|
|
exit();
|
|
}
|
|
$rows = $rs["data"];
|
|
$secretToken = "--!!Super!!Suket#@!1231456";
|
|
$j_result = json_encode($rows);
|
|
$jwtToken = JWT::encode($j_result, $secretToken);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Encode Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
echo strlen($jwtToken) . "\n";
|
|
$rst = $this->post(
|
|
"https://result.pramita.co.id/one-api/verify/shortener_v2",
|
|
$jwtToken
|
|
);
|
|
echo $rst;
|
|
$j_rst = json_decode($rst, true);
|
|
if (json_last_error_msg() != "No error") {
|
|
echo "Error Json Token : " . json_last_error_msg();
|
|
exit();
|
|
}
|
|
exit();
|
|
$url = $j_rst["url"];
|
|
$img_qrcode = $this->post("http://localhost/charts/qrtext.php", $url);
|
|
header("Content-type: image/png");
|
|
echo $img_qrcode;
|
|
exit();
|
|
}
|
|
}
|