#\u4E3B\u8BCA\u65AD\u4E0B\u7684\u4E0D\u826F\u53CD\u5E94
disUe=match(d:Disease)-[r:\u4E0D\u826F\u53CD\u5E94]->(u:UntowardEffect) where d.name = 'disName' return d.name as dis,collect(u.name) as ueCollect
#\u67E5\u627E\u4E3B\u8BCA\u65AD
mainDis=match(c:Chronic)-[r:\u4E0A\u7EA7]->(k:Chronic) where c.name='disName' return c.sing as sign,k.sing as ksign,k.name as kname
#\u89C4\u5219\u627E\u7C7B
medicationRule=match(h)-[r:\u8BCA\u65AD\u4F9D\u636E]->(c:Condition) \n \
where (h:HistoryDiagnose or h:LISResult) and \n \
h.name in filds \n \
with c,count(distinct r)>=c.path as hh \n \
where hh =true \n \
with c \n \
match(c)-[r:\u63A8\u8350]->(t:TreatCollection) \n \
return c.name as name,c.design as design,r.p as p,r.category as category,r.disName as disName,t.name as collection order by p
#\u89C4\u5219\u627E\u836F
searchMedication_rule=unwind drugs as row match(m:Medicine)-[r:\u5C5E\u4E8E]->(d:Drugs) where d.name=row \n \
with m,d \n \
match(m:Medicine)-[r:\u5C5E\u4E8E]->(h:Drugs) where d.bigDrugs=h.name \n \
with h,d,m \n \
match(m)<-[R:\u614E\u7528|:\u5FCC\u7528]-(i) where i.name in filds \n \
return h.name as big,d.name as sub,m.name as med,type(R) as ty \n \
union \n \
unwind drugs as row match(m:Medicine)-[r:\u5C5E\u4E8E]->(d:Drugs) where d.name=row \n \
with m,d \n \
match(m:Medicine)-[r:\u5C5E\u4E8E]->(h:Drugs) where d.bigDrugs=h.name \n \
return h.name as big,d.name as sub,m.name as med,null as ty
#\u89C4\u5219\u4E0D\u7B26\u5408\u7528\u836F
searchMedication=match(h:Disease{name:disName})-[r:\u6CBB\u7597\u65B9\u6848]->(t:Treat)-[r2:\u63A8\u8350]->(m:Medicine)-[r1:\u5C5E\u4E8E]->(d:Drugs)\n \
with t,m,d\n \
match(t)-[r:\u63A8\u8350]->(m)-[r1:\u5C5E\u4E8E]->(h:Drugs)\n \
where d.name=h.bigDrugs \n \
with t,m,d,h\n \
match(m)<-[R:\u614E\u7528|:\u5FCC\u7528]-(i) where i.name in filds\n \
return t.name as treat,d.name as big,h.name as sub,m.name as med,type(R) as ty\n \
order by h.p\n \
union\n \
match(h:Disease{name:disName})-[r:\u6CBB\u7597\u65B9\u6848]->(t:Treat)-[r2:\u63A8\u8350]->(m:Medicine)-[r1:\u5C5E\u4E8E]->(d:Drugs)\n \
with t,m,d\n \
match(t)-[r:\u63A8\u8350]->(m)-[r1:\u5C5E\u4E8E]->(h:Drugs)\n \
where d.name=h.bigDrugs \n \
return t.name as treat,d.name as big,h.name as sub, m.name as med,null as ty\n \
order by h.p
# \u5224\u65AD\u8BCA\u65AD\u662F\u4EC0\u4E48\u7C7B\u578B
judgeDiseaseType=match(d:Disease) where d.name='disName' return d.sign as design