109 lines
3.7 KiB
PHP
109 lines
3.7 KiB
PHP
<?php
|
|
class Fitness extends MY_Controller
|
|
{
|
|
var $db;
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
}
|
|
|
|
public function index()
|
|
{
|
|
echo "GET RESULT";
|
|
}
|
|
function generate($Mgm_McuID, $orderHeaderID)
|
|
{
|
|
$sql = "SELECT
|
|
Mcu_ResumeID,
|
|
Mcu_ResumeT_OrderHeaderID,
|
|
Mcu_ResumeMcu_FitnessID,
|
|
Mcu_FitnessName,
|
|
Mcu_ResumeVerification
|
|
FROM mcu_resume
|
|
LEFT JOIN mcu_fitness
|
|
ON Mcu_ResumeMcu_FitnessID = Mcu_FitnessID
|
|
WHERE Mcu_ResumeT_OrderHeaderID = ?";
|
|
$qry = $this->db->query($sql, array($orderHeaderID));
|
|
if (!$qry) {
|
|
$this->sys_error_db("select fitness", $this->db);
|
|
exit;
|
|
}
|
|
$data = $qry->result_array();
|
|
// print_r($data);
|
|
if (count($data) > 0) {
|
|
$order = $data[0];
|
|
if ($order['Mcu_ResumeVerification'] == 'Y' && $order['Mcu_ResumeMcu_FitnessID'] > 0) {
|
|
// print_r("Masuk order");
|
|
$sql = "UPDATE one_etl.mcu_order
|
|
SET Mcu_OrderMcu_FitnessID = ?,
|
|
Mcu_OrderMcu_FitnessName = ?,
|
|
Mcu_OrderStatusFitness = 'Y',
|
|
Mcu_OrderStatusFitnessDateTime = NOW(),
|
|
Mcu_OrderLastUpdated = NOW()
|
|
WHERE Mcu_OrderT_OrderHeaderID = ?
|
|
AND Mcu_OrderMgm_McuID = ?";
|
|
$qry = $this->db->query($sql, array(
|
|
$order['Mcu_ResumeMcu_FitnessID'],
|
|
$order['Mcu_FitnessName'],
|
|
$orderHeaderID,
|
|
$Mgm_McuID
|
|
));
|
|
if (!$qry) {
|
|
$this->sys_error_db("select fitness", $this->db);
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
$this->statusDone($Mgm_McuID, $orderHeaderID);
|
|
|
|
|
|
echo json_encode(["status" => "OK", "message" => "Success"]);
|
|
}
|
|
|
|
function statusDone($Mgm_McuID, $orderHeaderID)
|
|
{
|
|
$sql = "SELECT
|
|
Mcu_OrderStatusLab,
|
|
Mcu_OrderStatusNonLab,
|
|
Mcu_OrderStatusFisik,
|
|
Mcu_OrderStatusRiwayat,
|
|
Mcu_OrderStatusFitness
|
|
FROM one_etl.mcu_order
|
|
WHERE Mcu_OrderT_OrderHeaderID = ?
|
|
AND Mcu_OrderMgm_McuID = ?";
|
|
$qry = $this->db->query($sql, array(
|
|
$orderHeaderID,
|
|
$Mgm_McuID
|
|
));
|
|
if (!$qry) {
|
|
$this->sys_error_db("Update status done", $this->db);
|
|
exit;
|
|
}
|
|
$cek = $qry->result_array();
|
|
if (count($cek) > 0) {
|
|
$data = $cek[0];
|
|
if (
|
|
$data['Mcu_OrderStatusLab'] == 'Y'
|
|
&& $data['Mcu_OrderStatusNonLab'] == 'Y'
|
|
&& $data['Mcu_OrderStatusFisik'] == 'Y'
|
|
&& $data['Mcu_OrderStatusRiwayat'] == 'Y'
|
|
&& $data['Mcu_OrderStatusFitness'] == 'Y'
|
|
) {
|
|
$sql = "UPDATE one_etl.mcu_order
|
|
SET Mcu_OrderStatus = 'Y',
|
|
Mcu_OrderLastUpdated = NOW()
|
|
WHERE Mcu_OrderT_OrderHeaderID = ?
|
|
AND Mcu_OrderMgm_McuID = ?";
|
|
$qry = $this->db->query($sql, array(
|
|
$orderHeaderID,
|
|
$Mgm_McuID
|
|
));
|
|
if (!$qry) {
|
|
$this->sys_error_db("Update status done", $this->db);
|
|
exit;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|