otherConfig.php 9.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. if (!defined('IS_INITPHP')) exit('Access Denied!');
  3. /**
  4. * 用于在配置流的列表
  5. * 命名规则 I和D要注册大小写
  6. * 命名规则 I_name I是通过URL获取内容
  7. * 命名规则 D_name D是通过上一条数据获取内容 verifi
  8. * 'demo' => array(
  9. '{"nodeType":"data|pass|if|verifi",parameter:"[para1,pa]","resultType":"autoid|entity|boolean|return|list|rows","sqlType":"select|update|insert|delete","sqlString":"select hospitalId,hospitalName,hospLevel,hospPhoto,favoriteNum,commentNum from hz_hospitalinfo where status =0"}'
  10. ),
  11. * nodeType:pass 为验证如果返回结果为空则可以进入下一步
  12. * nodeType:if 如为if 在parameter里只能有一个为IF|参数 sqlString sql语句里 <if>条件</if>
  13. * "nodeType":"verifi" 如果节点为verifi 那就执行下面两条语句,一个节点返回true的执行,一个节点返回为false的执行
  14. * 该方法是要写整体方法,不能用公用的
  15. */
  16. $otherConfig = array(
  17. //病历查询带参数
  18. /*'emrMasterListMore' => array(
  19. '{"nodeType":"step1","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_status,I_zzStatus,I_applyType,I_consType","resultType":"rows","sqlType":"select","sqlString":"SELECT COUNT(DISTINCT emrId) AS rows FROM hz_view_emr_owner t WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' and status=\'{I_status}\' END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' and status=\'{I_status}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' and status=\'{I_status}\' END ) AND CASE WHEN \'{I_consType}\'=\'1\' THEN consType = \'1\' ELSE 1=1 END AND CASE WHEN \'{I_applyType}\'=\'1\' THEN applyType = \'1\' ELSE 1=1 END AND CASE WHEN \'{I_zzStatus}\'=\'\' THEN 1=1 ELSE zzStatus=\'{I_zzStatus}\' END {OhterSql} ","infoString":"没有权限读该病历"}',
  20. '{"nodeType":"step2","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_status,I_zzStatus,I_applyType,I_consType,P_rowed,P_pageSize","resultType":"list","sqlType":"select","sqlString":"select DISTINCT emrId,itemCont,emrType,emrTypeId,hospitalId,status,createDate,updateDate from hz_view_emr_owner WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' and status=\'{I_status}\' END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' and status=\'{I_status}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' and status=\'{I_status}\' END ) AND CASE WHEN \'{I_consType}\'=\'1\' THEN consType = \'1\' ELSE 1=1 END AND CASE WHEN \'{I_applyType}\'=\'1\' THEN applyType = \'1\' ELSE 1=1 END AND CASE WHEN \'{I_zzStatus}\'=\'\' THEN 1=1 ELSE zzStatus=\'{I_zzStatus}\' END {OhterSql} ORDER BY updateDate desc {P_rowed}{P_pageSize} ","infoString":"未检查到数据"}',
  21. ),
  22. */
  23. 'emrMasterListMore' => array(
  24. '{"nodeType":"step1","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_groupType,I_workStyle,I_applyType,I_consType","resultType":"rows","sqlType":"select","sqlString":"SELECT COUNT(DISTINCT emrId) AS rows FROM hz_view_emr_owner t WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' AND consStatus< 2 END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' END ) AND CASE WHEN \'{I_groupType}\' = \'0\' THEN STATUS = \'0\' ELSE groupType=\'{I_groupType}\' AND workStyle in ({I_workStyle}) END AND CASE WHEN \'{I_consType}\'=\'1\' THEN consType = \'1\' ELSE 1=1 END AND CASE WHEN \'{I_applyType}\'=\'1\' THEN applyType = \'1\' ELSE 1=1 END {OhterSql} ","infoString":"没有权限读该病历"}',
  25. '{"nodeType":"step2","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_groupType,I_workStyle,I_applyType,I_consType,P_rowed,P_pageSize","resultType":"list","sqlType":"select","sqlString":"select DISTINCT emrId,itemCont,emrType,emrTypeId,hospitalId,status,createDate,updateDate from hz_view_emr_owner WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' AND consStatus< 2 END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' END ) AND CASE WHEN \'{I_groupType}\' = \'0\' THEN STATUS = \'0\' ELSE groupType=\'{I_groupType}\' AND workStyle in ({I_workStyle}) END AND CASE WHEN \'{I_consType}\'=\'1\' THEN consType = \'1\' ELSE 1=1 END AND CASE WHEN \'{I_applyType}\'=\'1\' THEN applyType = \'1\' ELSE 1=1 END {OhterSql} ORDER BY updateDate desc {P_rowed}{P_pageSize} ","infoString":"未检查到数据"}',
  26. ),
  27. //病历管理(整合)
  28. 'emrComposite' => array(
  29. '{"nodeType":"step1","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_emrId","resultType":"entity","sqlType":"select","sqlString":"SELECT DISTINCT emrId FROM hz_view_emr_owner t WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END )","infoString":"没有权限读该病历"}',
  30. '{"nodeType":"step2","parameter":"I_emrId,I_idNo","resultType":"entity","sqlType":"select","sqlString":"select emrId from hz_view_emr_owner where emrId=\'{I_emrId}\' and idNo=\'{I_idNo}\'","infoString":"查询不相关数据"}',
  31. '{"nodeType":"step3","parameter":"I_emrId","arrItem":"\'BCJL_BCDJ\',\'BCJL_BCDJ_SYS\',\'HZ_HZJL\',\'ZZ_ZZJL\',\'LIS_ITEM_SYS\',\'PACS_ITEM_SYS\',\'LIS_ITEM_IMG\',\'PACS_ITEM_IMG\',\'PACS_ITEM_DICOM\',\'OTHER_ITEM_FJ\',\'OTHER_FUJ\'","resultType":"list","sqlType":"select","sqlString":"SELECT d.* FROM hz_emr_detail d,hz_dict_emr_item i WHERE d.itemName=i.ename and d.emrId=\'{I_emrId}\' {OhterSql} ORDER BY i.sort,d.emrId ","infoString":"查询不相关数据"}',
  32. ),
  33. //病历管理(整合分享PS:注意上面的内容与上面的内容一致)
  34. 'emrShare' => array(
  35. '{"nodeType":"","parameter":"","arrItem":"\'BCJL_BCDJ\',\'BCJL_BCDJ_SYS\',\'HZ_HZJL\',\'ZZ_ZZJL\',\'LIS_ITEM_SYS\',\'PACS_ITEM_SYS\',\'LIS_ITEM_IMG\',\'PACS_ITEM_IMG\',\'PACS_ITEM_DICOM\',\'OTHER_ITEM_FJ\',\'OTHER_FUJ\'","resultType":"list","sqlType":"select","sqlString":"SELECT d.* FROM hz_emr_detail d,hz_dict_emr_item i WHERE d.itemName=i.ename {OhterSql} ORDER BY i.sort,d.emrId ","infoString":"查询不相关数据"}',
  36. ),
  37. //添加会诊流程
  38. //先判断有没有病历的权限,再添加OWER表里的数据
  39. 'emrConsultation' => array(
  40. //'{"nodeType":"step1","parameter":"M_userName,I_emrId","resultType":"entity","sqlType":"select","sqlString":"select emrId,status from hz_view_emr_owner_master where ownerId=\'{M_userName}\' and emrId=\'{I_emrId}\'","infoString":"没有权限读该病历"}',
  41. '{"nodeType":"step1","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_emrId","resultType":"entity","sqlType":"select","sqlString":"SELECT DISTINCT emrId,status FROM hz_view_emr_owner t WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END )","infoString":"没有权限读该病历"}',
  42. '{"nodeType":"step2","parameter":"I_emrId,json,I_invitedDoctor,I_applyDoctor,I_exStatus,F_timenow","resultType":"autoid","sqlType":"insert","sqlString":"","infoString":"添加数据失败"}',
  43. ),
  44. //会诊评价
  45. 'emrConsultation' => array(
  46. '{"nodeType":"step1","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_emrId","resultType":"entity","sqlType":"select","sqlString":"SELECT DISTINCT emrId,status FROM hz_view_emr_owner t WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END )","infoString":"没有权限读该病历"}',
  47. '{"nodeType":"step2","parameter":"I_emrId,I_commentInfo","resultType":"entity","sqlType":"","sqlString":"","infoString":"更新数据失败"}',
  48. ),
  49. //转诊申请
  50. 'emrReferralApply' => array(
  51. '{"nodeType":"step1","parameter":"M_userName,M_userType,M_hospitalId,M_deptId,I_emrId","resultType":"entity","sqlType":"select","sqlString":"SELECT DISTINCT emrId,status FROM hz_view_emr_owner t WHERE (CASE WHEN \'{M_userType}\'=\'1\' THEN ownerId=\'{M_userName}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'2\' THEN deptId=\'{M_deptId}\' AND hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END OR CASE WHEN \'{M_userType}\'=\'3\' THEN hospitalId=\'{M_hospitalId}\' and emrId=\'{I_emrId}\' END ) and status =\'0\' and zzStatus in(\'0\',\'2\')","infoString":"该病历未达到转诊要求"}',
  52. '{"nodeType":"step2","parameter":"I_emrId,I_idNo,I_hospitalId,I_deptId,I_doctorId","resultType":"","sqlType":"","sqlString":"","infoString":"添加数据失败"}',
  53. ),
  54. );
  55. ?>