50 lines
1.5 KiB
PHP
50 lines
1.5 KiB
PHP
<?php
|
|
|
|
class Re_normal extends MY_Controller
|
|
{
|
|
var $db_smartone;
|
|
|
|
public function index()
|
|
{
|
|
echo "RE Normal API";
|
|
}
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->db_smartone = $this->load->database("onedev", true);
|
|
}
|
|
|
|
public function update()
|
|
{
|
|
$prm = $this->sys_input;
|
|
$od_id = $prm["order_detail_id"];
|
|
$sql = "call sp_re_update_normal(?)";
|
|
$this->db_smartone->query($sql, array($od_id));
|
|
$this->clean_mysqli_connection($this->db_smartone->conn_id);
|
|
|
|
$sql_norm = "select T_OrderDetailMinValue, T_OrderDetailMaxValue,
|
|
T_OrderDetailMinValueInclusive, T_OrderDetailMaxValueInclusive,
|
|
Nat_TestFlagLow, Nat_TestFlagHigh,
|
|
T_OrderDetailNat_NormalValueID,
|
|
T_OrderDetailNat_MethodeID, T_OrderDetailNormalValueNote,
|
|
Nat_MethodeName
|
|
from t_orderdetail
|
|
join t_test on T_OrderDetailT_TestID = T_TestID
|
|
join nat_methode on T_OrderDetailNat_MethodeID = Nat_MethodeID
|
|
join nat_test on T_TestNat_TestID = Nat_TestID and T_TestIsActive = 'Y'
|
|
where T_OrderDetailID = ? ";
|
|
$qry = $this->db_smartone->query($sql_norm,array($od_id));
|
|
if ( $qry) {
|
|
$rows = $qry->result_array();
|
|
if(count($rows) > 0 ) {
|
|
$result = array("status"=>"OK","records" => $rows[0]);
|
|
$this->sys_ok($result);
|
|
exit;
|
|
}
|
|
}
|
|
|
|
$this->sys_error_db("Change Methode", $this->db_smartone);
|
|
}
|
|
}
|