beacon下实现一个简单的ajax的案例 - 深圳全飞鸿

<?php
class txcheckin extends tpage {
/*
* 构造函数：暂时什么都不做！
*/
function txcheckin($app) {
parent::__construct($app); //一定要添加这一句
}
function index(){
global $smarty,$config;
$this->prepareDictionary();
//$this->app->getUser();
$this->printBodyScale(); //需要用到页面自适应
$this->app->printAjx(); //需要用界面ajax
$this->app->printAjdb();//需要用界面ajdb
$this->app->printConfirmFun();
$this->app->printAlertFun();
$this->app->printMsgBox("提示",
"1. 如果清溪有正常扫描Check_Out, 则塘厦可以不扫Check_in;<BR>
2. 如果清溪漏扫Check_Out, 则塘厦可以在此处补扫;");
}
function prepareDictionary(){
//1. 如果是中国，则直接退出
if($this->app->language=="CN") return;
//2. 中国以外的国家，必须有英语
_D("提示","Hint"); _D("注意","Attention"); _D("警告","Warning");
//3. 中国，英国之外的国家，可以适当的添加字典
if($this->app->language=="VN"){
//添加越南的字典
}
}
/*
* 打印自适应功能
*/
function printBodyScale(){
global $smarty;
//方案一：
//$js="<script>function bodyScale() {var devicewidth = document.documentElement.clientWidth;if(devicewidth>1366){var scale = devicewidth / 1366; document.body.style.zoom = scale;}}window.onload = window.onresize = function () {bodyScale();};</script>";
//$smarty->assign("bodyscale", $js);
//方案二：
$css="<style>
@media only screen and (min-width: 1300px){
#mymain{
width: 1280px !important;
margin: 0 auto !important;
position: relative !important;
}
}
</style>";
$smarty->assign("bodyscale", $css);
}
function GetRealData($data){
$data=str_replace("--","",$data);
$data=str_replace(";","",$data);
$data=str_replace("'","",$data);
$data=str_replace("\"","",$data);
return $data;
}
/*
* 创建工单
*/
function action_get_trsn($param){
$this->app->AjaxFail('action_get_trsn已执行，但未返回结果!');
$jsdata=array();
$trsninfo=array();
$trsninfo["R107"]="";
$trsninfo["R108"]="";
$trsninfo["INPUT"]="";
$trsninfo["TR_SN"]="";
$this->app->jsdata["data"]=$trsninfo; //先初始化，成不成功，都会传这些内容
//读取参数
$data=$param["ed_trsn"];
$trsn=$this->GetRealData($data);
if(strlen($trsn)<1){
$this->app->AjaxFail("条码不能为空!", 100);
return;
}
$trsninfo["TR_SN"]=$trsn;
$this->app->jsdata["data"]=$trsninfo;
//
//---
$db = mysqli_connect("10.0.10.29", "root", "****");
if (!$db) {
die();
$this->app->AjaxFail("mysqli_connect异常: ".iconv("GBK", "UTF-8//IGNORE", mysqli_connect_error()), 100);
return;
}
$this->app->prepare_mes();
//R107
$sqlstr="select serial_number from sfc.r_wip_tracking_t where serial_number='{$trsn}'";
$data=$this->app->mes->getRow($sqlstr);
if($data){
$trsninfo["R107"]="OK, 已经存在，无需处理！";
$this->app->jsdata["data"]=$trsninfo; //就算是错，也要回显示
}else{
$sql="select * from sfc.r_wip_tracking_t where serial_number='{$trsn}'";
$result = mysqli_query($db,$sql);
if (!$result) {
$trsninfo["R107"]="execute sql: ".mysqli_error($db);
}else{
if($row = mysqli_fetch_assoc($result)){
$mysql1="insert ignore into sfc.`r_wip_tracking_t` (`SERIAL_NUMBER`, `SECTION_FLAG`, `MO_NUMBER`, `MODEL_NAME`, `TYPE`, `VERSION_CODE`, `LINE_NAME`, `SECTION_NAME`,
`GROUP_NAME`, `STATION_NAME`, `LOCATION`, `STATION_SEQ`, `ERROR_FLAG`, `IN_STATION_TIME`, `IN_LINE_TIME`, `OUT_LINE_TIME`, `SHIPPING_SN`, `WORK_FLAG`,
`FINISH_FLAG`, `ENC_CNT`, `SPECIAL_ROUTE`, `PALLET_NO`, `CONTAINER_NO`, `QA_NO`, `QA_RESULT`, `SCRAP_FLAG`, `NEXT_STATION`, `CUSTOMER_NO`,
`BOM_NO`, `BILL_NO`, `TRACK_NO`, `PO_NO`, `KEY_PART_NO`, `CARTON_NO`, `WARRANTY_DATE`, `REWORK_NO`, `REPAIR_CNT`, `EMP_NO`, `PO_LINE`,
`PALLET_FULL_FLAG`, `PMCC`, `GROUP_NAME_CQC`, `MO_NUMBER_OLD`, `ERP_MO`, `ATE_STATION_NO`, `MSN`, `IMEI`, `JOB`, `MCARTON_NO`, `SO_NUMBER`,
`SO_LINE`, `STOCK_NO`, `TRAY_NO`, `SHIP_NO`, `WIP_GROUP`, `SHIPPING_SN2`)
values
('".$row["SERIAL_NUMBER"]."',NULL,'".$row["MO_NUMBER"]."','".$row["MODEL_NAME"]."',NULL,'".$row["VERSION_CODE"]."','".$row["LINE_NAME"]."','".$row["SECTION_NAME"]."','".$row["GROUP_NAME"]."','".$row["STATION_NAME"]."','".$row["LOCATION"]."','".$row["STATION_SEQ"]."','".$row["ERROR_FLAG"]."',
str_to_date('".$row["IN_STATION_TIME"]."','%Y%m%d%H%i%s'),'".$row["IN_LINE_TIME"]."',NULL,'".$row["SHIPPING_SN"]."','".$row["WORK_FLAG"]."','".$row["FINISH_FLAG"]."','".$row["ENC_CNT"]."','".$row["SPECIAL_ROUTE"]."','".$row["PALLET_NO"]."','".$row["CONTAINER_NO"]."','".$row["QA_NO"]."','".$row["QA_RESULT"]."','".$row["SCRAP_FLAG"]."','".$row["NEXT_STATION"]."',
'".$row["CUSTOMER_NO"]."','".$row["BOM_NO"]."',NULL,'".$row["TRACK_NO"]."',
NULL,'".$row["KEY_PART_NO"]."','".$row["CARTON_NO"]."',NULL,'".$row["REWORK_NO"]."','0','".$row["EMP_NO"]."',NULL,'".$row["PALLET_FULL_FLAG"]."',NULL,NULL,NULL,NULL,'',
'N/A','N/A','N/A',NULL,'','','".$row["STOCK_NO"]."','".$row["TRAY_NO"]."','".$row["SHIP_NO"]."','".$row["WIP_GROUP"]."','".$row["SHIPPING_SN2"]."')";
$this->app->mes->execute($mysql1);
$trsninfo["R107"]="OK！";
}else{
$trsninfo["R107"]="无此数据! {$trsn}";
}
}
}
//R108
$sqlstr="select serial_number from sfc.r_wip_keyparts_t where serial_number='{$trsn}'";
$data=$this->app->mes->getRow($sqlstr);
if($data){
$trsninfo["R108"]="OK, 已经存在，无需处理！";
$this->app->jsdata["data"]=$trsninfo; //就算是错，也要回显示
}else{
$sql="select * from sfc.r_wip_keyparts_t where serial_number='{$trsn}'";
$result = mysqli_query($db,$sql);
if (!$result) {
$trsninfo["R108"]="execute sql: ".mysqli_error($db);
}else{
$icount=0;
while($row = mysqli_fetch_assoc($result)){
$icount=$icount+1;
$mysql1="insert ignore into sfc.`r_wip_keyparts_t` (`EMP_NO`, `SERIAL_NUMBER`, `KEY_PART_NO`, `KEY_PART_SN`, `KP_RELATION`, `GROUP_NAME`, `CARTON_NO`, `WORK_TIME`, `VERSION`, `PART_MODE`, `KP_CODE`, `MO_NUMBER`) values ('".$row["EMP_NO"]."','".$row["SERIAL_NUMBER"]."','".$row["KEY_PART_NO"]."','".$row["KEY_PART_SN"]."','".$row["KP_RELATION"]."','".$row["GROUP_NAME"]."','".$row["CARTON_NO"]."','".$row["WORK_TIME"]."','".$row["VERSION"]."',NULL,'N/A','".$row["MO_NUMBER"]."')";
$this->app->mes->execute($mysql1);
$trsninfo["R108"]="OK！同步{$icount}条";
};
if($icount<1){
$trsninfo["R108"]="无此数据! {$trsn}";
}
}
}
//INPUT
$sqlstr="select sn from sfc.mes_data_key_t where sn='{$trsn}'";
$data=$this->app->mes->getRow($sqlstr);
if($data){
$trsninfo["INPUT"]="OK, 已经存在，无需处理！";
$this->app->jsdata["data"]=$trsninfo; //就算是错，也要回显示
}else{
$sql="select * from sfc.mes_data_key_t where sn='{$trsn}'";
$result = mysqli_query($db,$sql);
if (!$result) {
$trsninfo["INPUT"]="execute sql: ".mysqli_error($db);
}else{
function _LL($str){
if(is_string($str)){
return "'{$str}',";
} else {
return "NULL,";
}
}
if($row = mysqli_fetch_assoc($result)){
$mysql1="insert ignore into sfc.`mes_data_key_t` (`MO`, `SN`, `MODEL_NAME`, `DATA_TYPE`, `MAC`, `ID1`, `ID2`, `ID3`, `ID4`, `ID5`, `ID6`, `ID7`, `ID8`, `ID9`, `ID10`, `ID11`, `ID12`, `ID13`, `ID14`, `ID15`, `IN_DATE`, `PRINT_FLAG`, `PRINT_TIME`, `PRINT_COUNT`) values(".
_LL($row["MO"]).
_LL($row["SN"]).
_LL($row["MODEL_NAME"]).
_LL($row["DATA_TYPE"]).
_LL($row["MAC"]).
_LL($row["ID1"]).
_LL($row["ID2"]).
_LL($row["ID3"]).
_LL($row["ID4"]).
_LL($row["ID5"]).
_LL($row["ID6"]).
_LL($row["ID7"]).
_LL($row["ID8"]).
_LL($row["ID9"]).
_LL($row["ID10"]).
_LL($row["ID11"]).
_LL($row["ID12"]).
_LL($row["ID13"]).
_LL($row["ID14"]).
_LL($row["ID15"]).
_LL($row["IN_DATE"]).
_LL($row["PRINT_FLAG"]).
_LL($row["PRINT_TIME"])."'0')";
$this->app->mes->execute($mysql1);
$trsninfo["INPUT"]="OK！";
}else{
$trsninfo["INPUT"]="无此数据! {$trsn}";
}
}
}
$this->app->AjaxOK($trsninfo,"已处理，明细见下表! {$trsn}");
}
}

复制代码