ของ database
โค้ด: เลือกทั้งหมด
public function FSaMPHWGetDataByID($paData){
try{
$tPhwCode = $paData['FTPhwCode'];
$tSQL = " SELECT
PHW.FTPhwCode AS rtPhwCode,
PHW.FTPhwName AS rtPhwName,
PHW.FTPhwConnType AS rtConnType,
PHW.FTPhwConnRef AS rtConnRef,
PHW.FTPhwCodeRef AS rtCodeRef,
PHW.FNPhwSeq AS rtPhwSeq
-- POS.FTPosCode AS rtPosCode,
-- POSHW.FTShwCode AS rtShwCode,
FROM [TCNMPosHW] PHW
LEFT JOIN [TCNMPos] POS ON PHW.FTPhwCode = POS.FTPosCode
LEFT JOIN [TSysPosHW] POSHW ON PHW.FTShwCode = POSHW.FTShwCode
WHERE 1=1 AND PHW.FTPhwCode = '$tPhwCode' ";
$oQuery = $this->db->query($tSQL);
if ($oQuery->num_rows() > 0){
$aDetail = $oQuery->row_array();
$aResult = array(
'raItems' => $aDetail,
'rtCode' => '1',
'rtDesc' => 'success',
);
}else{
$aResult = array(
'rtCode' => '800',
'rtDesc' => 'Data not found.',
);
}
return $aResult;
}catch(Exception $Error){
echo $Error;
}
}
ของ javascript
โค้ด: เลือกทั้งหมด
function JSvCallPageSaleMachineDeviceEdit(ptPhwCode){
JCNxOpenLoading();
JStCMMGetPanalLangSystemHTML ('JSvCallPageSaleMachineDeviceEdit',ptPhwCode);
// var tPhwCode = $('#oetPhwCode').val();
$.ajax({
type: "POST",
url: "salemachinedevicePageEdit",
data:{'tPhwCode' : ptPhwCode },
cache: false,
timeout: 0,
success: function(tResult){
if(tResult != ''){
$('#oliPhwTitleAdd').hide();
$('#oliPhwTitleEdit').show();
$('#odvBtnPhwInfo').hide();
$('#odvBtnAddEdit').show();
$('#odvContentPageSaleMachineDevice').html(tResult);
$('#oetPhwCode').addClass('xCNDisable');
$('#oetPhwCode').attr('readonly', true);
$('.xCNBtnGenCode').attr('disabled', true);
}
JCNxLayoutControll();
JCNxCloseLoading();
},
error: function(jqXHR, textStatus, errorThrown) {
JCNxResponseError(jqXHR, textStatus, errorThrown);
}
});
}