array( '{"nodeType":"data|pass|if|verifi",parameter:"[para1,pa]","resultType":"autoid|entity|boolean|return|list","sqlType":"select|update|insert|delete","sqlString":"select hospitalId,hospitalName,hospLevel,hospPhoto,favoriteNum,commentNum from hz_hospitalinfo where status =0"}' ), * nodeType:pass 为验证如果返回结果为空则可以进入下一步 * nodeType:if 如为if 在parameter里只能有一个为IF|参数 sqlString sql语句里 条件 * "nodeType":"verifi" 如果节点为verifi 那就执行下面两条语句，一个节点返回true的执行，一个节点返回为false的执行 * */ $hisConfig = array( 'getTimeRegInfo' => array( '{"nodeType":"xml","parameter":"I_hospitalId,I_deptId,I_doctorId,I_regDate,I_timeFlag","funcName":"getTimeRegInfo","resultType":"list","dataType":"","xmlString":"{I_hospitalId}{I_deptId}{I_doctorId}{I_regDate}{I_timeFlag}","replaceXmlData":"scheduleCode,startTime,endTime,regTotalCount,regLeaveCount","returnXmlData":"list"}' ), //返回最近一次挂号日期 'getLastClinicDate' => array( '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId,I_hospitalId","resultType":"entity","dataType":"","sqlType":"select","sqlString":"SELECT c.patientId FROM hz_customerfamily f,hz_customercard c WHERE f.id=c.customerFamilyId AND c.patientId<>\'\' and f.id=\'{I_customerFamilyId}\' AND f.customerUserId=\'{M_id}\' and c.hospitalId=\'{I_hospitalId}\'","infoString":"查询不到绑定卡的数据，请绑定"}', '{"nodeType":"xml","parameter":"D_patientId,I_hospitalId","funcName":"getLastClinicDate","resultType":"entity","dataType":"","xmlString":"{I_hospitalId}{D_patientId}","replaceXmlData":"dateTime,clinicCode","returnXmlData":"one"}' ), 'labTestList' => array( '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId,I_hospitalId","resultType":"entity","dataType":"","sqlType":"select","sqlString":"SELECT c.patientId FROM hz_customerfamily f,hz_customercard c WHERE f.id=c.customerFamilyId AND c.patientId<>\'\' and f.id=\'{I_customerFamilyId}\' AND f.customerUserId=\'{M_id}\' and c.hospitalId=\'{I_hospitalId}\'","infoString":"查询不到绑定卡的数据，请绑定"}', '{"nodeType":"xml","parameter":"D_patientId,I_hospitalId,I_dateTime,I_clinicCode","funcName":"labTestList","resultType":"list","dataType":"","xmlString":"{I_hospitalId}{D_patientId}{I_dateTime}{I_clinicCode}","replaceXmlData":"testNO,subject,status,requestedDateTime,resultsRptDateTime","returnXmlData":"list"}' ), 'labTestInfo' => array( '{"nodeType":"xml","parameter":"I_hospitalId,I_testNo","funcName":"labTestInfo","resultType":"list","dataType":"","xmlString":"{I_hospitalId}{I_testNo}","replaceXmlData":"itemNo,reportItemName,abnormalIndicator,result,units,lowerLimit,upperLimit","returnXmlData":"list"}' ), 'examList' => array( '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId,I_hospitalId","resultType":"entity","dataType":"","sqlType":"select","sqlString":"SELECT c.patientId FROM hz_customerfamily f,hz_customercard c WHERE f.id=c.customerFamilyId AND c.patientId<>\'\' and f.id=\'{I_customerFamilyId}\' AND f.customerUserId=\'{M_id}\' and c.hospitalId=\'{I_hospitalId}\'","infoString":"查询不到绑定卡的数据，请绑定"}', '{"nodeType":"xml","parameter":"D_patientId,I_hospitalId,I_dateTime,I_clinicCode","funcName":"examList","resultType":"list","dataType":"","xmlString":"{I_hospitalId}{D_patientId}{I_dateTime}{I_clinicCode}","replaceXmlData":"examNo,examClass,examSubClass,status,reqDateTime,reportDateTime","returnXmlData":"list"}' ), 'examInfo' => array( '{"nodeType":"xml","parameter":"I_hospitalId,I_examNo","funcName":"examInfo","resultType":"list","dataType":"","xmlString":"{I_hospitalId}{I_examNo}","replaceXmlData":"description,abnormal,imperssion,recommedation,examClass,reportDateTime","returnXmlData":"list"}' ), //取消挂号 'cancelOrder' => array( '{"nodeType":"sql","parameter":"I_orderId,","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,orderIdHis FROM hz_appointsorder t WHERE t.orderId=\'{I_orderId}\' AND t.resultCode=\'0\' AND t.cancelFlag=\'1\' AND t.payFlag=\'1\' and t.returnFlag=\'1\'","infoString":"查询无数据或该订单已取消"}', '{"nodeType":"sql","parameter":"I_hospitalId,I_orderId,F_timenow,I_cancelReason,M_id,I_customerFamilyId","resultType":"autoid","dataType":"add","sqlType":"insert","sqlString":"INSERT INTO hz_cancelorder(hospitalId,orderId,cancelTime,cancelReason,customerUserId,customerFamilyId) VALUES (\'{I_hospitalId}\',\'{I_orderId}\',\'{F_timenow}\',\'{I_cancelReason}\',\'{M_id}\',\'{I_customerFamilyId}\')","infoString":"添加退号订单失败，请再试"}', '{"nodeType":"sql","parameter":"D_autoid,","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,hospitalId,orderId,cancelTime,cancelReason FROM hz_cancelorder WHERE id=\'{D_autoid}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,I_orderId,D_orderIdHis,D_cancelTime,D_cancelReason","funcName":"cancelOrder","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{I_orderId}{D_orderIdHis}{D_cancelTime}{D_cancelReason}","replaceXmlData":"resultCode,resultDesc","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"D_id,D_resultCode,D_resultDesc","resultType":"entity","dataType":"add","sqlType":"update","sqlString":"UPDATE hz_cancelorder SET resultCode = \'{D_resultCode}\',resultDesc = \'{D_resultDesc}\' WHERE id = \'{D_id}\'","infoString":"更新数据失败"}', '{"nodeType":"sql","parameter":"I_orderId","resultType":"return","dataType":"","sqlType":"update","sqlString":"UPDATE hz_appointsorder SET cancelFlag = \'0\' WHERE orderId = \'{I_orderId}\'","infoString":"取消预约成功"}', ), //添加付费 'payOrder' => array( '{"nodeType":"sql","parameter":"I_orderId,","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,orderIdHis FROM hz_appointsorder t WHERE t.orderId=\'{I_orderId}\' AND t.resultCode=\'0\' AND t.cancelFlag=\'1\' AND t.payFlag=\'1\' and t.returnFlag=\'1\'","infoString":"查询无数据或该订单已支付"}', '{"nodeType":"sql","parameter":"I_hospitalId,I_orderId,F_orderId,I_payCardNum,I_payAmout,I_payMode,F_timenow,M_id,I_customerFamilyId","resultType":"autoid","dataType":"add","sqlType":"insert","sqlString":"INSERT INTO hz_payorder (hospitalId,orderId,orderIdPAY,payCardNum,payAmout,payMode,payTime,customerUserId,customerFamilyId) VALUES (\'{I_hospitalId}\',\'{I_orderId}\',\'{F_orderId}\',\'{I_payCardNum}\',\'{I_payAmout}\',\'{I_payMode}\',\'{F_timenow}\',\'{M_id}\',\'{I_customerFamilyId}\')","infoString":"添加支付订单失败，请再试"}', '{"nodeType":"sql","parameter":"D_autoid,","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT orderIdPAY,payCardNum,payAmout,payMode,payTime FROM hz_payorder WHERE id=\'{D_autoid}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,I_orderId,D_orderIdHis,I_patientId,D_orderIdPAY,D_payCardNum,D_payAmout,D_payMode,D_payTime","funcName":"payOrder","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{I_orderId}{D_orderIdHis}{D_orderIdPAY}{D_payCardNum}{I_patientId}{D_payAmout}{D_payMode}{D_payTime}","replaceXmlData":"resultCode,resultDesc,clinicCode","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"D_autoid,D_resultCode,D_resultDesc,D_clinicCode","resultType":"entity","dataType":"add","sqlType":"update","sqlString":"UPDATE hz_payorder SET resultCode = \'{D_resultCode}\',resultDesc = \'{D_resultDesc}\',clinicCode = \'{D_clinicCode}\' WHERE id = \'{D_autoid}\'","infoString":"更新数据失败"}', '{"nodeType":"sql","parameter":"I_orderId,D_clinicCode","resultType":"return","dataType":"","sqlType":"update","sqlString":"UPDATE hz_appointsorder SET payFlag = \'0\',clinicCode = \'{D_clinicCode}\' WHERE orderId = \'{I_orderId}\'","infoString":"支付成功"}', ), //退费 'returnPay' => array( '{"nodeType":"sql","parameter":"I_orderId,","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,orderIdHis,clinicCode FROM hz_appointsorder t WHERE t.orderId=\'{I_orderId}\' AND t.resultCode=\'0\' AND t.cancelFlag=\'1\' AND t.payFlag=\'0\' and t.returnFlag=\'1\' ","infoString":"查询无数据或该订单已支付"}', '{"nodeType":"sql","parameter":"I_hospitalId,I_orderId,F_orderId,I_payAmout,I_returnReason,F_timenow,M_id,I_customerFamilyId","resultType":"autoid","dataType":"add","sqlType":"insert","sqlString":"INSERT INTO hz_returnpay (hospitalId,orderId,orderIdPAY,returnFee,returnReason,returnTime,customerUserId,customerFamilyId) VALUES (\'{I_hospitalId}\',\'{I_orderId}\',\'{F_orderId}\',\'{I_payAmout}\',\'{I_returnReason}\',\'{F_timenow}\',\'{M_id}\',\'{I_customerFamilyId}\')","infoString":"添加支付订单失败，请再试"}', '{"nodeType":"sql","parameter":"D_autoid,","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT orderId,orderIdPAY,returnFee,returnReason,returnTime FROM hz_returnpay WHERE id=\'{D_autoid}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,I_orderId,D_orderIdPAY,I_patientId,D_clinicCode,D_returnFee,D_returnTime,D_returnReason","funcName":"returnPay","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{I_orderId}{D_orderIdPAY}{I_patientId}{D_clinicCode}{D_returnFee}{D_returnTime}{D_returnReason}","replaceXmlData":"resultCode,resultDesc","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"D_autoid,D_resultCode,D_resultDesc","resultType":"entity","dataType":"add","sqlType":"update","sqlString":"UPDATE hz_returnpay SET resultCode = \'{D_resultCode}\',resultDesc = \'{D_resultDesc}\' WHERE id = \'{D_autoid}\'","infoString":"更新数据失败"}', '{"nodeType":"sql","parameter":"I_hospitalId,I_orderId,D_orderIdPAY,F_timenow,M_id,I_customerFamilyId","resultType":"autoid","dataType":"add","sqlType":"insert","sqlString":"INSERT INTO hz_cancelorder(hospitalId,orderId,cancelTime,cancelReason,customerUserId,customerFamilyId,resultCode,resultDesc) VALUES (\'{I_hospitalId}\',\'{I_orderId}\',\'{F_timenow}\',\'{D_orderIdPAY}\',\'{M_id}\',\'{I_customerFamilyId}\',\'0\',\'取消预约成功\')","infoString":"添加支付订单失败，请再试"}', '{"nodeType":"sql","parameter":"I_orderId","resultType":"return","dataType":"","sqlType":"update","sqlString":"UPDATE hz_appointsorder SET returnFlag = \'0\',cancelFlag=\'0\' WHERE orderId = \'{I_orderId}\'","infoString":"退费成功"}', ), 'register' => array( '{"nodeType":"sql","parameter":"I_loginName,I_code","resultType":"return","dataType":"","sqlType":"select","sqlString":"SELECT id FROM hz_verifysmscode t WHERE t.phone=\'{I_loginName}\' AND t.code=\'{I_code}\' and type=\'0\' AND t.createtime>=DATE_SUB(SYSDATE(),INTERVAL 20 MINUTE) ","infoString":"验证码输入不正确或验证码过期"}', '{"nodeType":"xml","parameter":"I_hospitalId,I_idNo,I_trueName","funcName":"confirmPatient","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{I_idNo}{I_trueName}","replaceXmlData":"resultCode,resultDesc","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"I_loginName","resultType":"boolean","isPass":"pass","sqlType":"select","sqlString":"select id,encrypt from hz_customeruser where phone = \'{I_loginName}\'","infoString":"用户名已存在"}', '{"nodeType":"sql","parameter":"I_loginName,I_password,I_code,F_ip,F_timenow,I_idNo,I_trueName,I_birthDay,I_sex","resultType":"autoid","sqlType":"insert","sqlString":"insert into hz_customeruser(phone,PASSWORD,ENCRYPT,regIp,regTime,trueName,idNo,birthDay,sex) VALUES(\'{I_loginName}\',MD5(CONCAT(MD5(\'{I_password}\'),\'{I_code}\')),\'{I_code}\',\'{F_ip}\',\'{F_timenow}\',\'{I_trueName}\',\'{I_idNo}\',\'{I_birthDay}\',\'{I_sex}\');","infoString":"用户名注册失败"}', '{"nodeType":"sql","parameter":"D_autoid,I_loginName,I_idNo,I_trueName,I_birthDay,I_sex,F_timenow","resultType":"autoid","sqlType":"insert","sqlString":"insert into hz_customerfamily (customerUserId,phone,idNo,trueName,ownership,status,createDate,birthDay,sex) VALUES (\'{D_autoid}\',\'{I_loginName}\',\'{I_idNo}\',\'{I_trueName}\',\'本人\',\'0\',\'{F_timenow}\',\'{I_birthDay}\',\'{I_sex}\')","infoString":"添加数据失败"}', '{"nodeType":"sql","parameter":"D_autoid","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,customerUserId FROM hz_customerfamily WHERE id=\'{D_autoid}\' ","infoString":"查找不到相应数据"}', '{"nodeType":"sql","parameter":"D_customerUserId,D_id","resultType":"return","dataType":"add","sqlType":"update","sqlString":"update hz_customeruser set customerfamilyId=\'{D_id}\' where id=\'{D_customerUserId}\'","infoString":"注册成功未绑定用户"}', '{"nodeType":"sql","parameter":"D_id","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,trueName,idNo,sex FROM hz_customerfamily WHERE id=\'{D_id}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,I_idNo,I_trueName","funcName":"confirmPatient","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{I_idNo}{I_trueName}","replaceXmlData":"patientId,cardId","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"D_id,I_hospitalId,D_cardId,D_patientId,F_timenow","resultType":"return","sqlType":"insert","sqlString":"insert into hz_customercard (customerFamilyId,hospitalId,cardType,cardId,patientId,createTime) VALUES (\'{D_id}\',\'{I_hospitalId}\',\'1\',\'{D_cardId}\',\'{D_patientId}\',\'{F_timenow}\')","infoString":"添加数据失败"}' ), 'registerNew' => array( '{"nodeType":"sql","parameter":"I_loginName,I_code","resultType":"return","dataType":"","sqlType":"select","sqlString":"SELECT id FROM hz_verifysmscode t WHERE t.phone=\'{I_loginName}\' AND t.code=\'{I_code}\' and type=\'0\' AND t.createtime>=DATE_SUB(SYSDATE(),INTERVAL 20 MINUTE) ","infoString":"验证码输入不正确或验证码过期"}', '{"nodeType":"sql","parameter":"I_loginName","resultType":"boolean","isPass":"pass","sqlType":"select","sqlString":"select id,encrypt from hz_customeruser where phone = \'{I_loginName}\'","infoString":"用户名已存在"}', '{"nodeType":"sql","parameter":"I_loginName,I_password,I_code,F_ip,F_timenow,I_idNo,I_trueName,I_birthDay,I_sex","resultType":"autoid","sqlType":"insert","sqlString":"insert into hz_customeruser(phone,PASSWORD,ENCRYPT,regIp,regTime,trueName,idNo,birthDay,sex) VALUES(\'{I_loginName}\',MD5(CONCAT(MD5(\'{I_password}\'),\'{I_code}\')),\'{I_code}\',\'{F_ip}\',\'{F_timenow}\',\'{I_trueName}\',\'{I_idNo}\',\'{I_birthDay}\',\'{I_sex}\');","infoString":"用户名注册失败"}', '{"nodeType":"sql","parameter":"D_autoid,I_loginName,I_idNo,I_trueName,I_birthDay,I_sex,F_timenow","resultType":"autoid","sqlType":"insert","sqlString":"insert into hz_customerfamily (customerUserId,phone,idNo,trueName,ownership,status,createDate,birthDay,sex) VALUES (\'{D_autoid}\',\'{I_loginName}\',\'{I_idNo}\',\'{I_trueName}\',\'本人\',\'0\',\'{F_timenow}\',\'{I_birthDay}\',\'{I_sex}\')","infoString":"添加数据失败"}', '{"nodeType":"sql","parameter":"D_autoid","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT id,customerUserId FROM hz_customerfamily WHERE id=\'{D_autoid}\' ","infoString":"查找不到相应数据"}', '{"nodeType":"sql","parameter":"D_customerUserId,D_id","resultType":"return","dataType":"add","sqlType":"update","sqlString":"update hz_customeruser set customerfamilyId=\'{D_id}\' where id=\'{D_customerUserId}\'","infoString":"注册成功未绑定用户"}', '{"nodeType":"sql","parameter":"D_id","resultType":"return","dataType":"","sqlType":"select","sqlString":"SELECT id,trueName,idNo,sex FROM hz_customerfamily WHERE id=\'{D_id}\'","infoString":"查询无数据"}', ), 'customerCardAdd' => array( '{"nodeType":"sql","parameter":"I_hospitalId,I_customerFamilyId","resultType":"return","isPass":"pass","dataType":"","sqlType":"select","sqlString":"SELECT id FROM hz_customercard WHERE customerFamilyId=\'{I_customerFamilyId}\' AND hospitalId=\'{I_hospitalId}\'","infoString":"该医院已绑定数据"}', '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT trueName,idNo,sex FROM hz_customerfamily WHERE id=\'{I_customerFamilyId}\' AND customerUserId=\'{M_id}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,D_idNo,D_trueName,D_sex,I_cardId","funcName":"confirmCard","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{D_idNo}{D_trueName}{D_sex}{I_cardId}","replaceXmlData":"resultCode,resultDesc,patientId","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"I_customerFamilyId,I_hospitalId,I_cardType,I_cardId,D_patientId,F_timenow","resultType":"return","sqlType":"insert","sqlString":"insert into hz_customercard (customerFamilyId,hospitalId,cardType,cardId,patientId,createTime) VALUES (\'{I_customerFamilyId}\',\'{I_hospitalId}\',\'{I_cardType}\',\'{I_cardId}\',\'{D_patientId}\',\'{F_timenow}\')","infoString":"添加数据失败"}' ), 'customerCardEdit' => array( '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT trueName,idNo,sex FROM hz_customerfamily WHERE id=\'{I_customerFamilyId}\' AND customerUserId=\'{M_id}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,D_idNo,D_trueName,D_sex,I_cardId","funcName":"confirmCard","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{D_idNo}{D_trueName}{D_sex}{I_cardId}","replaceXmlData":"resultCode,resultDesc,patientId","returnXmlData":"one"}', '{"nodeType":"sql","parameter":"I_id,I_customerFamilyId,I_cardType,I_cardId,D_patientId,F_timenow","resultType":"return","sqlType":"update","sqlString":"update hz_customercard set cardType=\'{I_cardType}\',cardId=\'{I_cardId}\',patientId=\'{D_patientId}\',createTime=\'{F_timenow}\' where id=\'{I_id}\' and customerFamilyId=\'{I_customerFamilyId}\'","infoString":"更新数据失败"}' ), 'confirmPatient' => array( '{"nodeType":"xml","parameter":"I_hospitalId,I_idNo,I_trueName","funcName":"confirmPatient","dataType":"","resultType":"entity","xmlString":"{I_hospitalId}{I_idNo}{I_trueName}","replaceXmlData":"phone","returnXmlData":"one"}' ), 'cardMoney' => array( '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT trueName,ownership,id AS customerFamilyId FROM hz_customerfamily WHERE id=\'{I_customerFamilyId}\' AND customerUserId=\'{M_id}\'","infoString":"查询无数据"}', '{"nodeType":"sql","parameter":"I_hospitalId,I_customerFamilyId","resultType":"entity","dataType":"add","sqlType":"select","sqlString":"SELECT c.patientId,c.cardId,c.patientId,h.hospitalId,h.hospitalName FROM hz_customercard c,hz_hospitalinfo h WHERE c.hospitalId=h.hospitalId and c.customerFamilyId=\'{I_customerFamilyId}\' AND c.hospitalId=\'{I_hospitalId}\'","infoString":"查询无数据"}', '{"nodeType":"xml","parameter":"I_hospitalId,D_patientId,D_cardId","funcName":"cardMoney","dataType":"add","resultType":"entity","xmlString":"{I_hospitalId}{D_patientId}{D_cardId}","replaceXmlData":"money","returnXmlData":"one"}', ), //排除候诊 'waitingQueue' => array( '{"nodeType":"sql","parameter":"M_id,I_customerFamilyId,I_hospitalId","resultType":"entity","dataType":"","sqlType":"select","sqlString":"SELECT patientId FROM hz_customerfamily f,hz_customercard c WHERE f.id=c.customerFamilyId AND c.patientId<>\'\' and f.id=\'{I_customerFamilyId}\' AND f.customerUserId=\'{M_id}\' and c.hospitalId=\'{I_hospitalId}\'","infoString":"查询不到绑定卡的数据，请绑定"}', '{"nodeType":"xml","parameter":"D_patientId,I_hospitalId","funcName":"waitingQueue","resultType":"entity","dataType":"","xmlString":"{I_hospitalId}{D_patientId}","replaceXmlData":"dateTime,clinicCode,patName,admLoc,admDoc,waitingNumber","returnXmlData":"one"}' ), ); ?>