<template>
  <div class="app-container">
    <el-card class="box-card" shadow="always">
      <div slot="header" class="clearfix">
        <div style="float: right;">
          <el-button type="primary" size="mini" icon="el-icon-download" @click="exportWord">导出</el-button>
          <el-button size="mini" icon="el-icon-back" @click="showCard">返回</el-button>
        </div>

      </div>
      <div class="body-wrapper">
        <h4 style="text-align: center;">{{ date }}{{ data.checkReportType === 'structure' ? '结构符合性' : '内容符合性' }}检测结果报告</h4>
        <el-divider content-position="left"><h3>检测指标统计分析</h3></el-divider>
        <el-row :gutter="20">
          <div>
            <el-row :gutter="20">
              <el-col :span="6">
                <div>
                  <el-statistic
                    group-separator=","
                    :precision="0"
                    :value="data.checkTotalCount"
                    title="检测表总数"
                  ></el-statistic>
                </div>
              </el-col>
              <el-col :span="6">
                <div>
                  <el-statistic title="检测总耗时（毫秒）">
                    <template slot="formatter">
                      {{ data.checkTimeConsuming }}
                    </template>
                  </el-statistic>
                </div>
              </el-col>
              <el-col :span="6">
                <div>
                  <el-statistic
                    group-separator=","
                    :precision="0"
                    decimal-separator="."
                    :value="data.checkErrorCount"
                    title="不合规总数"
                  >
                    <template slot="prefix">
                      <i class="el-icon-s-flag" style="color: red"></i>
                    </template>
                  </el-statistic>
                </div>
              </el-col>
              <el-col :span="6">
                <div>
                  <el-statistic title="不合规率">
                    <template slot="prefix">
                      <span class="like">
                        <i class="el-icon-star-on" style="color:red"></i>
                      </span>
                    </template>
                    <template slot="formatter">
                      {{ (data.checkErrorCount / data.checkTotalCount * 100) + '%' }}
                    </template>
                  </el-statistic>
                </div>
              </el-col>
            </el-row>
          </div>
        </el-row>
        <el-divider content-position="left"><h3>不合规统计分析</h3></el-divider>
        <el-row :gutter="20">
          <el-col :span="10">
            <h5>按数据源统计不合规数量</h5>
            <el-table
              :data="reportTableData1"
              :span-method="objectSpanMethod1"
              border
              default-expand-all
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="ruleLevelName" label="规则级别" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center">
                <template slot-scope="scope">
                  <el-progress :percentage="scope.row.checkErrorCount" :stroke-width="20" :text-inside="true" :color="colorFormat(scope.row.ruleLevelName)" :format="cellFormat" />
                </template>
              </el-table-column>
            </el-table>
          </el-col>
          <el-col :span="10" :offset="4">
            <h5>按用例类型统计不合规数量</h5>
            <el-table
              :data="reportTableData2"
              :span-method="objectSpanMethod2"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleTypeName" label="用例类型" align="center" />
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center">
                <template slot-scope="scope">
                  <el-badge :value="scope.row.ruleLevelName" :type="typeFormat(scope.row.ruleLevelName)">
                    {{ scope.row.checkErrorCount }}
                  </el-badge>
                </template>
              </el-table-column>
            </el-table>
          </el-col>
        </el-row>
        <el-divider content-position="left"><h3>用例类型统计分析</h3></el-divider>
        <el-row>
          <el-col :span="24">
            <h5>表字段标准检测</h5>
            <el-table
              :data="table_key"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_table_key"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="trueTableName" label="实际表名" align="center" />
                  <el-table-column prop="standardTableName" label="标准表名" align="center" />
                  <el-table-column prop="trueColumn" label="实际字段" align="center" />
                  <el-table-column prop="standardColumn" label="标准字段" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>长度标准检测</h5>
            <el-table
              :data="length_key"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_length_key"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="standardColumn" label="标准字段" align="center" />
                  <el-table-column prop="standardLength" label="标准长度" align="center" />
                  <el-table-column prop="trueLength" label="实际长度" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>空值标准检测</h5>
            <el-table
              :data="null_key"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_null_key"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="standardColumn" label="标准字段" align="center" />
                  <el-table-column prop="standardNull" label="标准字段是否空值" align="center" />
                  <el-table-column prop="trueColumn" label="实际字段" align="center" />
                  <el-table-column prop="trueNull" label="实际字段是否空值" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>主键标准检测</h5>
            <el-table
              :data="pk_key"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_pk_key"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="standardColumn" label="标准字段" align="center" />
                  <el-table-column prop="standardPk" label="标准字段是否主键" align="center" />
                  <el-table-column prop="trueColumn" label="实际字段" align="center" />
                  <el-table-column prop="truePk" label="实际字段是否主键" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>外键标准检测</h5>
            <el-table
              :data="fk_key"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_fk_key"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="standardColumn" label="标准字段" align="center" />
                  <el-table-column prop="standardFk" label="标准字段是否外键" align="center" />
                  <el-table-column prop="trueColumn" label="实际字段" align="center" />
                  <el-table-column prop="trueFk" label="实际字段是否外键" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>完整性标准检测</h5>
            <el-table
              :data="integrity"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_integrity"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="trueColumn" label="字段名称" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>准确性标准检测</h5>
            <el-table
              :data="accuracy"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_accuracy"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="trueColumn" label="字段名称" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>一致性标准检测</h5>
            <el-table
              :data="consistent"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_consistent"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="trueColumn" label="字段名称" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <h5>正则表达式标准检测</h5>
            <el-table
              :data="regular"
              border
              tooltip-effect="dark"
              :max-height="250"
              style="width: 100%; margin: 15px 0;"
            >
              <el-table-column prop="ruleName" label="用例名称" align="center" />
              <el-table-column prop="ruleSourceName" label="数据源" align="center" />
              <el-table-column prop="version" label="版本" align="center" />
              <el-table-column prop="checkTotalCount" label="检测数" align="center" />
              <el-table-column prop="checkErrorCount" label="不合规数" align="center" />
            </el-table>
            <el-collapse accordion>
              <el-collapse-item>
                <template slot="title">
                  <i class="el-icon-document"></i>&nbsp;不合规明细
                </template>
                <el-table
                  :data="no_regular"
                  border
                  tooltip-effect="dark"
                  :max-height="250"
                  style="width: 100%; margin: 15px 0;"
                >
                  <el-table-column prop="caseName" label="用例名称" align="center" />
                  <el-table-column prop="source" label="数据源" align="center" />
                  <el-table-column prop="tableName" label="数据表" align="center" />
                  <el-table-column prop="trueColumn" label="字段名称" align="center" />
                  <el-table-column prop="dataColumn" label="字段值" align="center" />
                  <el-table-column prop="notDetail" label="不合规原因" align="center" />
                </el-table>
              </el-collapse-item>
            </el-collapse>
          </el-col>
        </el-row>
      </div>
    </el-card>
  </div>
</template>

<script>
  import { getReportBySource, getReportByType, getReportDetail } from '@/api/quality/checkreport'
  import moment from 'moment'
  import dataJson from './Data.json'
  export default {
    name: 'CheckReportStructure',
    props: {
      data: {
        type: Object,
        default: function() {
          return {}
        }
      }
    },
    data() {
      return {
        queryParams: {
          checkDate: ''
        },
        pickerOption: {
          disabledDate(date) {
            return date.getTime() > Date.now()
          }
        },
        date: '',
        // 展示切换
        showOptions: {
          data: {},
          showList: true,
          showDetail: false
        },
        spanArr1: [],
        position1: 0,
        reportTableData1: [],
        spanArr2: [],
        position2: 0,
        reportTableData2: [],
        // 唯一性核查数据
        uniqueTableData: [],
        // 完整性核查数据
        integrityTableData: [],
        // 准确性核查数据
        accuracyTableData: [],
        // 一致性核查数据
        consistentTableData: [],
        // 关联性核查数据
        relevanceTableData: [],
        // 及时性核查数据
        timelinessTableData: [],

        // 表字段标准检测
        table_key: [],
        no_table_key: [],
        // 长度标准检测
        length_key: [],
        no_length_key: [],
        // 空值标准检测
        null_key: [],
        no_null_key: [],
        // 主键标准检测
        pk_key: [],
        no_pk_key: [],
        // 外键标准检测
        fk_key: [],
        no_fk_key: [],
        // 完整性标准检测
        integrity: [],
        no_integrity: [],
        // 准确性标准检测
        accuracy: [],
        no_accuracy: [],
        // 一致性标准检测
        consistent: [],
        no_consistent: [],
        // 正则表达式标准检测
        regular: [],
        no_regular: [],
        // 检测表总数
        checkTotalCount: null,
        // 检测总耗时
        checkTimeConsuming: null,
        // 不合规总数
        checkErrorCount: null,

        like: true,
        value1: 4154.564,
        totalTables: 1314,
        title: '增长人数'
      }
    },
    created() {
      this.queryParams.checkDate = moment(this.data.checkDate).format('YYYY-MM-DD')
      this.handleQuery()
    },
    mounted () {
      // 表字段标准检测
      this.table_key = dataJson.caseType.table_key
      this.no_table_key = dataJson.caseType.no_table_key
        // 长度标准检测
      this.length_key = dataJson.caseType.length_key
      this.no_length_key = dataJson.caseType.no_length_key
        // 空值标准检测
      this.null_key = dataJson.caseType.null_key
      this.no_null_key = dataJson.caseType.no_null_key
        // 主键标准检测
      this.pk_key = dataJson.caseType.pk_key
      this.no_pk_key = dataJson.caseType.no_pk_key
        // 外键标准检测
      this.fk_key = dataJson.caseType.fk_key
      this.no_fk_key = dataJson.caseType.no_fk_key
        // 完整性标准检测
      this.integrity = dataJson.caseType.integrity
      this.no_integrity = dataJson.caseType.no_integrity
        // 准确性标准检测
      this.accuracy = dataJson.caseType.accuracy
      this.no_accuracy = dataJson.caseType.no_accuracy
        // 一致性标准检测
      this.consistent = dataJson.caseType.consistent
      this.no_consistent = dataJson.caseType.no_consistent
        // 正则表达式标准检测
      this.regular = dataJson.caseType.regular
      this.no_regular = dataJson.caseType.no_regular

      // 初始化按数据源统计不合规数量
      this.spanArr1 = []
      this.spanArr2 = []
      this.reportTableData1 = dataJson.dataReport.reportTableData1
      this.reportTableData2 = dataJson.dataReport.reportTableData2
      this.rowspan1()
      this.rowspan2()
    },
    methods: {
      showCard() {
        this.$emit('showCard', this.showOptions)
      },
      handleQuery() {
        this.spanArr1 = []
        this.spanArr2 = []
        // this.getReportData1()
        this.getReportData2()
        this.getReportData3()
        this.date = moment(this.queryParams.checkDate).format('YYYY年MM月DD日')
      },
      // getReportData1() {
      //   getReportBySource({ checkDate: this.queryParams.checkDate }).then(response => {
      //     if (response.success) {
      //       this.reportTableData1 = response.data
      //       console.log('reportTableData1==', this.reportTableData1)
      //       this.rowspan1()
      //     }
      //   })
      // },
      // getReportData2() {
      //   getReportByType({ checkDate: this.queryParams.checkDate }).then(response => {
      //     if (response.success) {
      //       this.reportTableData2 = response.data
      //       console.log('this.reportTableData2===', this.reportTableData2)
      //       this.rowspan2()
      //     }
      //   })
      // },
      rowspan1() {
        this.reportTableData1.forEach((item, index) => {
          if (index === 0) {
            this.spanArr1.push(1)
            this.position1 = 0
          } else {
            if (this.reportTableData1[index].ruleSourceId === this.reportTableData1[index - 1].ruleSourceId) {
              this.spanArr1[this.position1] += 1
              this.spanArr1.push(0)
            } else {
              this.spanArr1.push(1)
              this.position1 = index
            }
          }
        })
      },
      objectSpanMethod1({ row, column, rowIndex, columnIndex }) {
        if (columnIndex === 0) {
          const _row = this.spanArr1[rowIndex]
          const _col = _row > 0 ? 1 : 0
          return {
            rowspan: _row,
            colspan: _col
          }
        }
      },
      rowspan2() {
        this.reportTableData2.forEach((item, index) => {
          if (index === 0) {
            this.spanArr2.push(1)
            this.position2 = 0
          } else {
            if (this.reportTableData2[index].ruleTypeId === this.reportTableData2[index - 1].ruleTypeId) {
              this.spanArr2[this.position2] += 1
              this.spanArr2.push(0)
            } else {
              this.spanArr2.push(1)
              this.position2 = index
            }
          }
        })
      },
      objectSpanMethod2({ row, column, rowIndex, columnIndex }) {
        if (columnIndex === 0) {
          const _row = this.spanArr2[rowIndex]
          const _col = _row > 0 ? 1 : 0
          return {
            rowspan: _row,
            colspan: _col
          }
        }
      },
      colorFormat(level) {
        if (level === '低') {
          return '#409eff'
        } else if (level === '中') {
          return '#e6a23c'
        } else {
          return '#f56c6c'
        }
      },
      cellFormat(percentage) {
        return `${percentage}`
      },
      typeFormat(level) {
        if (level === '低') {
          return 'primary'
        } else if (level === '中') {
          return 'warning'
        } else {
          return 'danger'
        }
      },
      getReportData3() {
        getReportDetail({ checkDate: this.queryParams.checkDate }).then(response => {
          if (response.success) {
            this.uniqueTableData = response.data.unique
            this.integrityTableData = response.data.integrity
            this.accuracyTableData = response.data.accuracy
            this.consistentTableData = response.data.consistent
            this.relevanceTableData = response.data.relevance
            this.timelinessTableData = response.data.timeliness
          }
        })
      },
      exportWord() {
        const filePath = './static/your-word-document.docx'
        const link = document.createElement('a')
        link.href = filePath
        link.download = '测结果报告.docx'
        document.body.appendChild(link)
        link.click()
        document.body.removeChild(link)
      }
    }
  }
</script>

<style lang="scss" scoped>
  .el-card ::v-deep .el-card__body {
    height: calc(100vh - 230px);
    overflow-y: auto;
  }
  .form-inline {
    ::v-deep .el-form-item {
      margin-bottom: 0px;
    }
  }
  ::v-deep .el-badge__content {
    margin-top: 10px;
    right: 0px;
  }
  ::v-deep .el-table__header th {
    background-color: #f5f5f5 !important;
  }
</style>
