447 lines
8.3 KiB
Plaintext
447 lines
8.3 KiB
Plaintext
{
|
|
"Version":"6.3.0.1",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Weight":400,
|
|
"Charset":134
|
|
},
|
|
"Printer":{
|
|
"Oriention":"Landscape",
|
|
"LeftMargin":1,
|
|
"TopMargin":0.5,
|
|
"RightMargin":1,
|
|
"BottomMargin":0.5
|
|
},
|
|
"DetailGrid":{
|
|
"CenterView":true,
|
|
"AppendBlankRow":true,
|
|
"Recordset":{
|
|
"QuerySQL":"SELECT o.dept_name,o.p_name,o.sex, CONCAT(o.age,'岁') as age,o.id_number,o.patient_id,o.disease,d.drug_name,d.drug_type,od.quantity,od.order_unit,od.charge_Date,r.operator,r.operation_time from order_info o inner join order_detail od on o.order_no=od.order_no inner JOIN drug_info d on od.drug_id=d.drug_id inner join dm_machine_record r on o.order_no=r.invoice_id where r.type=2 AND r.`machine_id` = :machine_id\r\n AND r.`operation_time` > :startDate\r\n AND r.`operation_time` < :endDate",
|
|
"Field":[
|
|
{
|
|
"Name":"药品名称",
|
|
"DBFieldName":"drug_name"
|
|
},
|
|
{
|
|
"Name":"数量",
|
|
"DBFieldName":"quantity"
|
|
},
|
|
{
|
|
"Name":"处方科室",
|
|
"DBFieldName":"dept_name"
|
|
},
|
|
{
|
|
"Name":"患者姓名",
|
|
"DBFieldName":"p_name"
|
|
},
|
|
{
|
|
"Name":"性别",
|
|
"DBFieldName":"sex"
|
|
},
|
|
{
|
|
"Name":"年龄",
|
|
"DBFieldName":"age"
|
|
},
|
|
{
|
|
"Name":"身份证号",
|
|
"DBFieldName":"id_number"
|
|
},
|
|
{
|
|
"Name":"病历号",
|
|
"DBFieldName":"patient_id"
|
|
},
|
|
{
|
|
"Name":"诊断",
|
|
"DBFieldName":"disease"
|
|
},
|
|
{
|
|
"Name":"药品性质",
|
|
"DBFieldName":"drug_type"
|
|
},
|
|
{
|
|
"Name":"单位",
|
|
"DBFieldName":"order_unit"
|
|
},
|
|
{
|
|
"Name":"处方日期",
|
|
"DBFieldName":"charge_Date"
|
|
},
|
|
{
|
|
"Name":"发药人",
|
|
"DBFieldName":"operator"
|
|
},
|
|
{
|
|
"Name":"发药时间",
|
|
"DBFieldName":"operation_time"
|
|
},
|
|
{
|
|
"Name":"Field1"
|
|
}
|
|
]
|
|
},
|
|
"Column":[
|
|
{
|
|
"Name":"处方科室",
|
|
"Width":3.38667
|
|
},
|
|
{
|
|
"Name":"患者姓名",
|
|
"Width":1.79917
|
|
},
|
|
{
|
|
"Name":"性别",
|
|
"Width":0.978958
|
|
},
|
|
{
|
|
"Name":"年龄",
|
|
"Width":1.21708
|
|
},
|
|
{
|
|
"Name":"身份证号",
|
|
"Width":5.3975
|
|
},
|
|
{
|
|
"Name":"病历号",
|
|
"Width":2.40771
|
|
},
|
|
{
|
|
"Name":"诊断",
|
|
"Width":4.52438
|
|
},
|
|
{
|
|
"Name":"药品名称",
|
|
"Width":5.26521
|
|
},
|
|
{
|
|
"Name":"药品性质",
|
|
"Width":2.59292
|
|
},
|
|
{
|
|
"Name":"数量",
|
|
"Width":1.21708
|
|
},
|
|
{
|
|
"Name":"单位",
|
|
"Width":1.19063
|
|
},
|
|
{
|
|
"Name":"处方日期",
|
|
"Width":2.93688
|
|
},
|
|
{
|
|
"Name":"发药人",
|
|
"Width":1.66688
|
|
},
|
|
{
|
|
"Name":"发药时间",
|
|
"Width":3.99521
|
|
}
|
|
],
|
|
"ColumnContent":{
|
|
"Height":1.00542,
|
|
"ColumnContentCell":[
|
|
{
|
|
"Column":"处方科室",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"处方科室"
|
|
},
|
|
{
|
|
"Column":"患者姓名",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"患者姓名"
|
|
},
|
|
{
|
|
"Column":"性别",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"性别"
|
|
},
|
|
{
|
|
"Column":"年龄",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"年龄"
|
|
},
|
|
{
|
|
"Column":"身份证号",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"身份证号"
|
|
},
|
|
{
|
|
"Column":"病历号",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"病历号"
|
|
},
|
|
{
|
|
"Column":"诊断",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"诊断"
|
|
},
|
|
{
|
|
"Column":"药品名称",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"药品名称"
|
|
},
|
|
{
|
|
"Column":"药品性质",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"药品性质"
|
|
},
|
|
{
|
|
"Column":"数量",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"数量"
|
|
},
|
|
{
|
|
"Column":"单位",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"单位"
|
|
},
|
|
{
|
|
"Column":"处方日期",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"处方日期"
|
|
},
|
|
{
|
|
"Column":"发药人",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"发药人"
|
|
},
|
|
{
|
|
"Column":"发药时间",
|
|
"TextAlign":"MiddleCenter",
|
|
"DataField":"发药时间"
|
|
}
|
|
]
|
|
},
|
|
"ColumnTitle":{
|
|
"Height":1.40229,
|
|
"RepeatStyle":"OnPage",
|
|
"ColumnTitleCell":[
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"处方科室",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"处方科室"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"患者姓名",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"患者\r\n姓名"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"性别",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"性\r\n别"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"年龄",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"年龄"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"身份证号",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"身份证号"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"病历号",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"病历号"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"诊断",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"诊断"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"药品名称",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"药品名称"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"药品性质",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"药品性质"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"数量",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"数量"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"单位",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"单位"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"处方日期",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"处方日期"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"发药人",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"发药人"
|
|
},
|
|
{
|
|
"GroupTitle":false,
|
|
"Column":"发药时间",
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":105000,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"发药时间"
|
|
}
|
|
]
|
|
}
|
|
},
|
|
"Parameter":[
|
|
{
|
|
"Name":"startDate",
|
|
"DataType":"DateTime",
|
|
"Format":"yyyy/MM/dd hh:mm:ss",
|
|
"Value":"2023/1/1"
|
|
},
|
|
{
|
|
"Name":"endDate",
|
|
"DataType":"DateTime",
|
|
"Format":"yyyy/MM/dd hh:mm:ss",
|
|
"Value":"2023/4/28 23:59:59"
|
|
},
|
|
{
|
|
"Name":"machine_id",
|
|
"Value":"DM1"
|
|
},
|
|
{
|
|
"Name":"p_department"
|
|
}
|
|
],
|
|
"ReportHeader":[
|
|
{
|
|
"Name":"ReportHeader1",
|
|
"Height":4.39208,
|
|
"Control":[
|
|
{
|
|
"Type":"MemoBox",
|
|
"Name":"MemoBox2",
|
|
"Center":"Both",
|
|
"Left":13.2027,
|
|
"Top":1.5875,
|
|
"Width":12.1973,
|
|
"Height":1.19063,
|
|
"Font":{
|
|
"Name":"宋体",
|
|
"Size":217500,
|
|
"Bold":true,
|
|
"Charset":134
|
|
},
|
|
"TextAlign":"MiddleCenter",
|
|
"Text":"住院药房毒麻精药品发药情况查询"
|
|
},
|
|
{
|
|
"Type":"MemoBox",
|
|
"Name":"MemoBox4",
|
|
"Left":0.211667,
|
|
"Top":3.59833,
|
|
"Width":12.991,
|
|
"Height":0.608542,
|
|
"Text":"统计时间：[#{startDate}#]-[#{endDate}#]"
|
|
}
|
|
],
|
|
"RepeatOnPage":true
|
|
}
|
|
]
|
|
} |