需求 #1341
新增 建档统计
开始日期:
2022-07-12
计划完成日期:
% 完成:
0%
预期时间:
描述
查询项目:编号、儿童姓名、母亲姓名、建档人、建档日期(包括开始日期-结束日期)、区内外;
功能:报表导出
sql:
select childnumber as 编号,childname as 儿童姓名,childsex as 性别,visitNo as 门诊号
,idNumberType as 证件类别,idnumber as 证件号码,childBrithDay as 出生日期,phone as 电话,Nation as 民族
,area as 区内外, childArea as 户籍地
,houseCommittee as 户籍地址补充, childTown as 现住址,nowCommittee as 现居地补充,childproduce as 胎次
,childFetus as 产次,childMothName as 母亲姓名,childMothIdNumber as 母亲身份证号,childFatherName as 父亲姓名
,childFatherIdnumber as 父亲身份证号 ,riskContent as 高危建档,childBuidName as 建档人,childBuildDay as 建档日期
,childBuildHospital as 医院 from child_childbase
子任务
相关的问题