保存自定义报表配置
<h5>简要描述</h5>
<ul>
<li>无</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>http://localhost:19002/configBasicReport/saveReportConfigData</code> </li>
</ul>
<h5>请求方式</h5>
<ul>
<li>post</li>
</ul>
<h5>Header</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">header</th>
<th style="text-align: left;">必选</th>
<th>类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">Accept</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">Accept-Language</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">Connection</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">Content-Type</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">Cookie</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">Origin</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">Referer</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">User-Agent</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
<tr>
<td style="text-align: left;">X-Token</td>
<td style="text-align: left;">是</td>
<td>string</td>
<td>无</td>
</tr>
</tbody>
</table>
<h5>请求参数示例</h5>
<pre><code>{
&quot;configBasicReportEntity&quot;: {
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;basicReportName&quot;: &quot;全部汇总--预约例数报表&quot;,
&quot;reportType&quot;: &quot;system_default&quot;,
&quot;contextMenuId&quot;: &quot;12345&quot;,
&quot;sqlContent&quot;: &quot;SELECT \ta.DAY_SURGERY_ID AS daySurgeryId,a.INPATIENT_HOS_AREA_CODE AS inpatientHosAreaCode,\ta.PATIENT_STATUS_DICT AS patientStatusDict ,b.PATIENT_NAME AS patientName,\tb.PATIENT_SEX_DICT AS sex, DATEDIFF(yy,b.PATIENT_BIRTHDAY,GETDATE()) AS age,c.SURGERY_PLAN_DATE as surgeryPlanDate FROM\tASMC_BUSI_PATIENT_DAY_SURGERY a INNER JOIN ASMC_BUSI_PATIENT_BASE_INFO b ON a.PATIENT_ID= b.PATIENT_ID\tLEFT JOIN ASMC_BUSI_PATIENT_SURGERY_APPLY c ON a.DAY_SURGERY_ID=c.DAY_SURGERY_ID &quot;,
&quot;reportSourceType&quot;: &quot;sql&quot;
},
&quot;queryConditionList&quot;: [
{
&quot;dictMappingList&quot;: [],
&quot;reportQueryConditionId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;queryConditionName&quot;: &quot;统计区间&quot;,
&quot;sqlFieldCode&quot;: &quot;surgeryPlanDate&quot;,
&quot;queryConditionType&quot;: &quot;date&quot;,
&quot;fieldDefaultValue&quot;: &quot;7&quot;,
&quot;sortNo&quot;: 1
},
{
&quot;dictMappingList&quot;: [],
&quot;reportQueryConditionId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;queryConditionName&quot;: &quot;所属院区&quot;,
&quot;sqlFieldCode&quot;: &quot;inpatientHosAreaCode&quot;,
&quot;queryConditionType&quot;: &quot;select&quot;,
&quot;fieldDefaultValue&quot;: &quot;&quot;,
&quot;sortNo&quot;: 2
},
{
&quot;dictMappingList&quot;: [
{
&quot;dictMappingId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;dictMappingType&quot;: &quot;1&quot;,
&quot;sqlFieldCode&quot;: &quot;patientStatusDict&quot;,
&quot;queryFieldValue&quot;: &quot;applyEd&quot;,
&quot;fieldMappingValue&quot;: &quot;日间申请&quot;
},
{
&quot;dictMappingId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;dictMappingType&quot;: &quot;1&quot;,
&quot;sqlFieldCode&quot;: &quot;patientStatusDict&quot;,
&quot;queryFieldValue&quot;: &quot;center_registerEd&quot;,
&quot;fieldMappingValue&quot;: &quot;中心登记&quot;
}
],
&quot;reportQueryConditionId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;queryConditionName&quot;: &quot;日间状态&quot;,
&quot;sqlFieldCode&quot;: &quot;patientStatusDict&quot;,
&quot;queryConditionType&quot;: &quot;select&quot;,
&quot;fieldDefaultValue&quot;: &quot;applyEd&quot;,
&quot;sortNo&quot;: 3
}
],
&quot;summaryList&quot;: [
{
&quot;dictMappingList&quot;: [],
&quot;displaySummaryId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;summaryTitleName&quot;: &quot;预约汇总&quot;,
&quot;displaySummaryCondition&quot;: &quot; FORMAT(surgeryPlanDate, 'yyyy-MM')&quot;,
&quot;summaryColumnName&quot;: &quot;拟手术日期&quot;,
&quot;sqlFieldCode&quot;: &quot;statisticsDate&quot;,
&quot;sqlSummaryStyle&quot;: &quot;MAX&quot;,
&quot;sqlSummaryStyleExtend&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
},
{
&quot;dictMappingList&quot;: [],
&quot;displaySummaryId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;summaryTitleName&quot;: &quot;预约汇总&quot;,
&quot;displaySummaryCondition&quot;: &quot;FORMAT(surgeryPlanDate, 'yyyy-MM')&quot;,
&quot;summaryColumnName&quot;: &quot;预约例数&quot;,
&quot;sqlFieldCode&quot;: &quot;totalNum&quot;,
&quot;sqlSummaryStyle&quot;: &quot;count&quot;,
&quot;sqlSummaryStyleExtend&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
}
],
&quot;detailList&quot;: [
{
&quot;dictMappingList&quot;: [],
&quot;displayDetailId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;detailTitleName&quot;: &quot;预约明细&quot;,
&quot;displaySummaryCondition&quot;: &quot;&quot;,
&quot;detailColumnName&quot;: &quot;日间序号&quot;,
&quot;sqlFieldCode&quot;: &quot;daySurgeryId&quot;,
&quot;urlJumpType&quot;: &quot;1&quot;,
&quot;urlAddress&quot;: &quot;http:\/\/www.baidu.com&quot;,
&quot;memo&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
},
{
&quot;dictMappingList&quot;: [],
&quot;displayDetailId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;detailTitleName&quot;: &quot;预约明细&quot;,
&quot;displaySummaryCondition&quot;: &quot;&quot;,
&quot;detailColumnName&quot;: &quot;姓名&quot;,
&quot;sqlFieldCode&quot;: &quot;patientName&quot;,
&quot;urlJumpType&quot;: &quot;1&quot;,
&quot;urlAddress&quot;: &quot;http:\/\/www.baidu.com&quot;,
&quot;memo&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
},
{
&quot;dictMappingList&quot;: [
{
&quot;dictMappingId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;dictMappingType&quot;: &quot;3&quot;,
&quot;sqlFieldCode&quot;: &quot;sex&quot;,
&quot;queryFieldValue&quot;: &quot;1&quot;,
&quot;fieldMappingValue&quot;: &quot;男&quot;
},
{
&quot;dictMappingId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;dictMappingType&quot;: &quot;3&quot;,
&quot;sqlFieldCode&quot;: &quot;sex&quot;,
&quot;queryFieldValue&quot;: &quot;2&quot;,
&quot;fieldMappingValue&quot;: &quot;女&quot;
}
],
&quot;displayDetailId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;detailTitleName&quot;: &quot;预约明细&quot;,
&quot;displaySummaryCondition&quot;: &quot;&quot;,
&quot;detailColumnName&quot;: &quot;性别&quot;,
&quot;sqlFieldCode&quot;: &quot;sex&quot;,
&quot;urlJumpType&quot;: &quot;1&quot;,
&quot;urlAddress&quot;: &quot;http:\/\/www.baidu.com&quot;,
&quot;memo&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
},
{
&quot;dictMappingList&quot;: [],
&quot;displayDetailId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;detailTitleName&quot;: &quot;预约明细&quot;,
&quot;displaySummaryCondition&quot;: &quot;&quot;,
&quot;detailColumnName&quot;: &quot;年龄&quot;,
&quot;sqlFieldCode&quot;: &quot;age&quot;,
&quot;urlJumpType&quot;: &quot;1&quot;,
&quot;urlAddress&quot;: &quot;http:\/\/www.baidu.com&quot;,
&quot;memo&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
},
{
&quot;dictMappingList&quot;: [],
&quot;displayDetailId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;detailTitleName&quot;: &quot;预约明细&quot;,
&quot;displaySummaryCondition&quot;: &quot;&quot;,
&quot;detailColumnName&quot;: &quot;拟手术日期&quot;,
&quot;sqlFieldCode&quot;: &quot;surgeryPlanDate&quot;,
&quot;urlJumpType&quot;: &quot;1&quot;,
&quot;urlAddress&quot;: &quot;http:\/\/www.baidu.com&quot;,
&quot;memo&quot;: &quot;&quot;,
&quot;columnWidth&quot;: &quot;50px&quot;,
&quot;sortNo&quot;: 1
}
],
&quot;chartInfoList&quot;: [
{
&quot;chartInfoId&quot;: &quot;&quot;,
&quot;basicReportCode&quot;: &quot;&quot;,
&quot;chartTitleName&quot;: &quot;例数汇总&quot;,
&quot;dataCategoryColumn&quot;: &quot;数据分类，图表的横坐标 group by&quot;,
&quot;chartColumnName&quot;: &quot;预约例数&quot;,
&quot;sqlFieldCode&quot;: &quot;&quot;,
&quot;sqlSummaryStyle&quot;: &quot;max&quot;,
&quot;sortNo&quot;: 4
}
]
}
</code></pre>