| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548 |
- <template>
- <el-dialog
- :title="title"
- :visible.sync="dialogVisible"
- :close-on-click-modal="false"
- :close-on-press-escape="false"
- :show-close="false"
- append-to-body
- fullscreen
- class="dialog paper-detail-dialog"
- top="0"
- >
- <div slot="title" class="dialog-title">
- <span>{{ title }}</span>
- <div>
- <ibps-toolbar :actions="toolbars" @action-event="handleActionEvent" />
- </div>
- </div>
- <div class="container">
- <div class="main">
- <div class="form">
- <el-form ref="form" :model="form" label-width="120px" :rules="rules">
- <el-row>
- <el-col :span="8">
- <el-form-item label="类型:" prop="lei_xing_">
- <el-select v-model="form.lei_xing_" placeholder="请选择" size="mini" style="width:80%">
- <el-option
- v-for="(value,key) in config"
- :key="key"
- :label="key.split('-')[1]"
- :value="key"
- />
- </el-select>
- </el-form-item>
- </el-col>
- </el-row>
- <el-row v-if="isShowDevice">
- <el-col :span="12">
- <el-form-item label="设备编号:">
- <ibps-custom-dialog
- v-model="form.she_bei_bian_hao_"
- size="mini"
- template-key="sbxzmcgl"
- :multiple="true"
- :disabled="false"
- type="dialog"
- class="custom-dialog"
- placeholder="请选择设备"
- icon="el-icon-search"
- style="width:80%"
- />
- </el-form-item>
- </el-col>
- </el-row>
- <el-alert
- title="默认数据,配置详情中的同名字段为空则使用以下默认数据"
- type="success"
- :closable="false"
- />
- <el-row>
- <el-col :span="12">
- <el-form-item label="部门:">
- <ibps-user-selector
- v-model="form.bian_zhi_bu_men_"
- size="mini"
- type="position"
- readonly-text="text"
- :disabled="false"
- :multiple="false"
- style="width:80%"
- />
- </el-form-item>
- </el-col>
- <el-col :span="12">
- <el-form-item label="监测岗位:">
- <el-select v-model="form.gang_wei_" placeholder="请选择" size="mini" style="width:80%">
- <el-option
- v-for="item in jianCeGangWeiList"
- :key="item.id_"
- :label="item.wei_hu_gang_wei_"
- :value="item.wei_hu_gang_wei_"
- />
- </el-select>
- </el-form-item>
- </el-col>
- </el-row>
- <el-row>
- <el-col :span="12">
- <el-form-item label="监测周期:">
- <el-select v-model="form.zhou_qi_" placeholder="请选择" size="mini" style="width:80%">
- <el-option
- v-for="item in period"
- :key="item.value"
- :label="item.label"
- :value="item.value"
- />
- </el-select>
- </el-form-item>
- </el-col>
- </el-row>
- <el-row v-if="form.zhou_qi_!==''">
- <el-col :span="12">
- <el-form-item :label="labelShow">
- <el-checkbox-group v-if="form.zhou_qi_==='每日'" v-model="dayCheck">
- <el-checkbox :label="1">周一</el-checkbox>
- <el-checkbox :label="2">周二</el-checkbox>
- <el-checkbox :label="3">周三</el-checkbox>
- <el-checkbox :label="4">周四</el-checkbox>
- <el-checkbox :label="5">周五</el-checkbox>
- <el-checkbox :label="6">周六</el-checkbox>
- <el-checkbox :label="7">周日</el-checkbox>
- </el-checkbox-group>
- <template v-if="form.zhou_qi_==='每周'">
- <el-radio v-model="weekCheck" :label="1">周一</el-radio>
- <el-radio v-model="weekCheck" :label="2">周二</el-radio>
- <el-radio v-model="weekCheck" :label="3">周三</el-radio>
- <el-radio v-model="weekCheck" :label="4">周四</el-radio>
- <el-radio v-model="weekCheck" :label="5">周五</el-radio>
- <el-radio v-model="weekCheck" :label="6">周六</el-radio>
- <el-radio v-model="weekCheck" :label="7">周日</el-radio>
- </template>
- <el-select v-if="form.zhou_qi_==='每月'" v-model="monthCheck" placeholder="请选择">
- <el-option
- v-for="item in 28"
- :key="item"
- :label="`第${item}天`"
- :value="item"
- />
- </el-select>
- <el-select v-if="form.zhou_qi_==='每季度'" v-model="quarterCheck" placeholder="请选择">
- <el-option
- v-for="item in 3"
- :key="item"
- :label="`第${item}个月`"
- :value="item"
- />
- </el-select>
- <el-select v-if="form.zhou_qi_==='每半年'" v-model="halfYearCheck" placeholder="请选择">
- <el-option
- v-for="item in 6"
- :key="item"
- :label="`第${item}个月`"
- :value="item"
- />
- </el-select>
- <el-select v-if="form.zhou_qi_==='每年'" v-model="yearCheck" placeholder="请选择">
- <el-option
- v-for="item in 12"
- :key="item"
- :label="`第${item}个月`"
- :value="item"
- />
- </el-select>
- </el-form-item>
- </el-col>
- <el-col v-if="nextDate" :span="12">
- <el-form-item label="下次监测日期为:">
- <el-tag>{{ nextDate }}</el-tag>
- </el-form-item>
- </el-col>
- </el-row>
- <el-row>
- <el-col :span="12">
- <el-form-item label="控制条件:">
- <el-input v-model="form.tiao_jian_" type="textarea" :rows="2" size="mini" style="width:80%" />
- </el-form-item>
- </el-col>
- </el-row>
- <el-row>
- <el-col :span="12">
- <el-form-item v-if="labelText.label1" :label="labelText.label1">
- <el-input-number v-model="form.temperatureMin" size="mini" controls-position="right" :min="-100" :max="form.temperatureMax" :step="1" />
- 至
- <el-input-number v-model="form.temperatureMax" size="mini" controls-position="right" :min="form.temperatureMin" :max="100" :step="1" />
- (℃)
- </el-form-item>
- </el-col>
- <el-col :span="12">
- <el-form-item v-if="labelText.label2" :label="labelText.label2">
- <el-input-number v-model="form.humidityMin" size="mini" controls-position="right" :min="-100" :max="form.humidityMax" :step="1" />
- 至
- <el-input-number v-model="form.humidityMax" size="mini" controls-position="right" :min="form.humidityMin" :max="100" :step="1" />
- (%)
- </el-form-item>
- </el-col>
- </el-row>
- </el-form>
- </div>
- <el-divider />
- <div class="table">
- <div class="hearder">
- <div v-if="isEdit" class="search">
- <div class="search-item">
- <span>部门</span>
- <ibps-user-selector
- v-model="search.buMen"
- type="position"
- readonly-text="text"
- :disabled="false"
- :multiple="false"
- style="width:100%"
- size="mini"
- />
- </div>
- <div class="search-item">
- <span>区域</span>
- <el-input v-model="search.quYu" size="mini" style="width:100%" placeholder="请输入" />
- </div>
- <div class="search-item">
- <span>房间</span>
- <el-input v-model="search.fangJian" size="mini" style="width:100%" placeholder="请输入" />
- </div>
- <div class="search-item">
- <span>监测周期</span>
- <el-input v-model="search.zhouQi" size="mini" style="width:66%" placeholder="请输入" />
- </div>
- <div class="search-item">
- <span>监测岗位</span>
- <el-select v-model="search.gangWei" placeholder="请选择" size="mini" style="width:66%" :clearable="true">
- <el-option
- v-for="item in jianCeGangWeiList"
- :key="item.id_"
- :label="item.wei_hu_gang_wei_"
- :value="item.wei_hu_gang_wei_"
- />
- </el-select>
- </div>
- <div class="search-item">
- <el-button size="mini" type="primary" icon="el-icon-search" @click="goSearch">查询</el-button>
- </div>
- </div>
- <div class="btn">
- <el-upload
- ref="uploadRef"
- class="upload-demo"
- action=""
- accept=".xlsx,.xls"
- :auto-upload="false"
- :show-file-list="false"
- :on-change="handleUploadChange"
- >
- <el-button type="primary" size="mini" icon="el-icon-upload2">导入</el-button>
- </el-upload>
- <el-button type="primary" size="mini" icon="el-icon-download" @click="exportExcel">导出</el-button>
- <el-button type="success" size="mini" icon="el-icon-plus" @click="openDialog">添加</el-button>
- <el-button type="danger" size="mini" icon="el-icon-delete" @click="removeItem">删除</el-button>
- <el-button v-if="trueList.length>0" type="info" size="mini" icon="el-icon-setting" @click="settingData">使用默认数据</el-button>
- </div>
- </div>
- <el-table
- :data="showPaperList"
- style="width: 100%"
- border
- @selection-change="handleSelectionChange"
- >
- <el-table-column
- width="50"
- type="selection"
- />
- <el-table-column
- prop=""
- label="序号"
- width="50"
- type="index"
- :index="showIndex"
- />
- <el-table-column
- prop="bu_men_"
- label="部门"
- width="100"
- >
- <template slot-scope="{row}">
- <ibps-user-selector
- type="position"
- :value="row.bu_men_"
- readonly-text="text"
- :disabled="true"
- :multiple="true"
- />
- </template>
- </el-table-column>
- <el-table-column
- prop="qu_yu_"
- label="区域"
- />
- <el-table-column
- prop="fang_jian_"
- label="房间"
- />
- <el-table-column
- v-if="isShowDevice"
- prop="deviceno1_"
- label="被控设备编号"
- />
- <el-table-column
- v-if="isShowDevice"
- prop="devicename1_"
- label="被控设备名称"
- />
- <el-table-column
- prop="deviceno2_"
- label="监控设备"
- />
- <el-table-column
- prop="jian_ce_zhou_qi_"
- label="监测周期"
- width="80"
- />
- <el-table-column
- prop="jian_ce_ri_qi_"
- label="监测日期"
- width="110"
- />
- <el-table-column
- prop="jian_ce_gang_wei_"
- label="监测岗位"
- />
- <el-table-column
- prop="shi_fou_qi_yong_"
- label="是否启用"
- width="80"
- >
- <template slot-scope="{row}">
- <el-tag v-if="row.shi_fou_qi_yong_==='1'">启用</el-tag>
- <el-tag v-if="row.shi_fou_qi_yong_==='0'" type="danger">停用</el-tag>
- </template>
- </el-table-column>
- <el-table-column
- fixed="right"
- prop=""
- label="操作栏目"
- >
- <template slot-scope="{row}">
- <el-button type="primary" icon="el-icon-edit" size="mini" @click="openDialog(row)">编辑</el-button>
- </template>
- </el-table-column>
- </el-table>
- <el-pagination
- style="margin-top: 5px; padding-bottom: 10px"
- :current-page="currentPage"
- :page-sizes="[10, 20,30, 50]"
- :page-size="pageSize"
- layout="prev,pager,next,jumper,sizes,->,total"
- :total="trueList.length"
- @size-change="handleSizeChange"
- @current-change="handleCurrentChange"
- />
- </div>
- </div>
- </div>
- <FecDialog ref="FecDialogRef" @onSubmit="sonSubmit" />
- </el-dialog>
- </template>
- <script>
- import IbpsAttachment from '@/business/platform/file/attachment/selector'
- import ibpsUserSelector from '@/business/platform/org/selector'
- import xlsx from 'xlsx'
- import fs from 'file-saver'
- import FecDialog from './fecDialog.vue'
- export default {
- components: {
- ibpsUserSelector,
- IbpsAttachment,
- FecDialog,
- IbpsCustomDialog: () => import('@/business/platform/data/templaterender/custom-dialog')
- },
- props: {
- parentData: {
- type: [Object, Array],
- default: () => {}
- },
- visible: {
- type: Boolean,
- default: false
- }
- },
- data () {
- const { userId, level = {}} = this.$store.getters || {}
- return {
- search: {
- buMen: '',
- quYu: '',
- fangJian: '',
- gangWei: '',
- zhouQi: ''
- },
- searchData: [],
- isSearch: false,
- level: level.second || level.first,
- userId: userId,
- pageSize: 10,
- currentPage: 1,
- multipleSelection: [],
- nextDate: '',
- rules: {
- lei_xing_: [
- { required: true, message: '请选择类型', trigger: 'blur' }
- ]
- },
- jianCeGangWeiList: [],
- dialogVisible: true,
- title: '设施环境配置表',
- toolbars: [{ key: 'save', label: '保存' }, { key: 'cancel', label: '退出' }],
- dayCheck: [],
- weekCheck: '',
- monthCheck: '',
- quarterCheck: '',
- halfYearCheck: '',
- yearCheck: '',
- form: {
- temperatureMin: 0,
- temperatureMax: 0,
- humidityMin: 0,
- humidityMax: 0,
- di_dian_: level.second || level.first,
- bian_zhi_ren_: userId,
- lei_xing_: '',
- bian_zhi_bu_men_: '',
- zhou_qi_: '',
- gang_wei_: '',
- tiao_jian_: '',
- default_environme: '',
- she_bei_bian_hao_: '', // 设备编号
- jian_ce_ri_qi_: '',
- ri_qi_lie_biao_: '',
- mo_kuai_lu_jing_: ''
- },
- subForm: [
- ],
- period: [
- { label: '日监测', value: '每日' },
- { label: '周监测', value: '每周' },
- { label: '月监测', value: '每月' },
- { label: '季度监测', value: '每季度' },
- { label: '半年监测', value: '每半年' },
- { label: '年监测', value: '每年' }
- ],
- config: {
- '01-室内温湿度监控': {
- keyword: '',
- path: '/sshjgl/wdjc/snwsdjkcd'
- },
- '02-冰箱温度监控': {
- keyword: '冰箱,冰柜,冷藏,冷冻,低温,恒温,生化培养箱',
- path: '/sshjgl/wdjc/bxwdjc',
- showDevice: true
- },
- '03-温浴箱温度监控': {
- keyword: '',
- path: '/sshjgl/wdjc/wyxwdjkywh',
- showDevice: true
- },
- '04-阴凉柜温度监控': {
- keyword: '',
- path: '/sshjgl/wdjc/ylgwdjc',
- showDevice: true
- },
- '05-纯水机水质监测': {
- keyword: '',
- path: '/sshjgl/csjszjcb',
- showDevice: true
- },
- '06-每日安全检查': {
- keyword: '',
- path: '/sshjgl/aqgl/mraqjc'
- },
- // '07-每月安全检查': {
- // keyword: '',
- // path: '/sshjgl/aqgl/myaqjc'
- // },
- '08-含氯有效性监测': {
- keyword: '',
- path: '/sshjgl/aqgl/hlyxxjc'
- },
- // '09-紫外灯辐照测定': {
- // keyword: '',
- // path: '/sshjgl/aqgl/zwdfzd',
- // showDevice: true
- // },
- '10-洗眼器检查': {
- keyword: '',
- path: '/sshjgl/aqgl/xyqjc',
- showDevice: true
- },
- '11-紧急淋浴器检查': {
- keyword: '',
- path: '/sshjgl/aqgl/jjlyqjc',
- showDevice: true
- },
- '12-紫外灯消毒': {
- keyword: '',
- path: '/sshjgl/aqgl/jykzwdxdjlb',
- showDevice: true
- },
- '13-高压灭菌': {
- keyword: '',
- path: '/sshjgl/aqgl/gymjjlb',
- showDevice: true
- },
- '14-空气消毒机': {
- keyword: '',
- path: '/sshjgl/aqgl/xdjsyjlb',
- showDevice: true
- }
- },
- listHander: {
- bu_men_: '部门',
- qu_yu_: '区域',
- fang_jian_: '房间',
- deviceno1_: '被控设备编号',
- devicename1_: '被控设备名称',
- deviceno2_: '监控设备编号',
- jian_ce_zhou_qi_: '监测周期',
- jian_ce_ri_qi_: '监测日期',
- jian_ce_gang_wei_: '监测岗位',
- kong_zhi_tiao_jia: '控制条件',
- xiu_zheng_shi_du_: '湿度修正值',
- xiu_zheng_wen_du_: '温度修正值'
- },
- subIdList: [],
- isFirstDevice: true
- }
- },
- computed: {
- // 分页结果
- showPaperList () {
- const start = (this.currentPage - 1) * this.pageSize
- const end = start + this.pageSize
- return this.trueList.slice(start, end)
- },
- // 过滤结果
- trueList () {
- return this.isSearch ? this.searchData : this.subForm
- },
- isShowDevice () {
- return this.form.lei_xing_ !== '01-室内温湿度监控' && this.form.lei_xing_ !== '06-每日安全检查' && this.form.lei_xing_ !== '08-含氯有效性监测'
- },
- isEdit () {
- return this.parentData instanceof Object && this.parentData.mainId
- },
- labelShow () {
- return this.form.zhou_qi_.split('每')[1] + '监测日期:'
- },
- labelText () {
- switch (this.form.lei_xing_) {
- case '02-冰箱温度监控':
- return { label1: '冷藏温度范围限值:', label2: '冷冻温度范围限值:' }
- case '03-温浴箱温度监控':
- case '04-阴凉柜温度监控':
- return { label1: '温度范围限值:', label2: '' }
- case '05-纯水机水质监测':
- case '06-每日安全检查':
- case '08-含氯有效性监测':
- case '10-洗眼器检查':
- case '11-紧急淋浴器检查':
- case '13-高压灭菌':
- case '14-空气消毒机':
- case '12-紫外灯消毒':
- return { label1: '', label2: '' }
- default:
- return { label1: '温度范围限值:', label2: '湿度范围限值:' }
- }
- }
- },
- watch: {
- 'form.temperatureMin' (val) {
- this.form.default_environme = this.formatEnv(this.form.temperatureMax, this.form.temperatureMin, this.form.humidityMax, this.form.humidityMin)
- },
- 'form.temperatureMax' (val) {
- this.form.default_environme = this.formatEnv(this.form.temperatureMax, this.form.temperatureMin, this.form.humidityMax, this.form.humidityMin)
- },
- 'form.humidityMin' (val) {
- this.form.default_environme = this.formatEnv(this.form.temperatureMax, this.form.temperatureMin, this.form.humidityMax, this.form.humidityMin)
- },
- 'form.humidityMax' (val) {
- this.form.default_environme = this.formatEnv(this.form.temperatureMax, this.form.temperatureMin, this.form.humidityMax, this.form.humidityMin)
- },
- 'form.she_bei_bian_hao_' (val) {
- if (!this.isFirstDevice) {
- const sql = `select yuan_she_bei_bian,she_bei_ming_cheng_ from t_sbdj where find_in_set(id_, '${val}')`
- this.$common.request('sql', sql).then(res => {
- const { data = [] } = res.variables || {}
- data.forEach(item => {
- const bianHao = item.yuan_she_bei_bian
- const mingChneg = item.she_bei_ming_cheng_
- const t = this.subForm.find(sub => sub.deviceno1_ === bianHao)
- if (!t) {
- this.subForm.push({
- deviceno1_: bianHao,
- devicename1_: mingChneg,
- shi_fou_qi_yong_: '1',
- bu_men_: this.form.bian_zhi_bu_men_,
- jian_ce_gang_wei_: this.form.gang_wei_,
- jian_ce_zhou_qi_: this.form.zhou_qi_,
- kong_zhi_tiao_jia: this.form.tiao_jian_,
- environment_range: this.form.default_environme,
- xiu_zheng_shi_du_: '',
- xiu_zheng_wen_du_: '',
- fang_jian_: '',
- qu_yu_: '',
- deviceno2_: '',
- jian_ce_ri_qi_: this.form.jian_ce_ri_qi_,
- ri_qi_lie_biao_: this.form.ri_qi_lie_biao_,
- zi_wai_deng_wai_j: this.$utils.guid()
- })
- }
- })
- })
- }
- },
- 'form.lei_xing_' (val) {
- this.form.mo_kuai_lu_jing_ = this.config[val].path
- },
- 'form.zhou_qi_' (val) {
- this.dayCheck = []
- this.weekCheck = ''
- this.monthCheck = ''
- this.quarterCheck = ''
- this.halfYearCheck = ''
- this.yearCheck = ''
- this.nextDate = ''
- },
- dayCheck: {
- handler: function (val, oldVal) {
- this.formatRiQi()
- if (val.length === 0) {
- this.nextDate = ''
- return
- }
- const temp_val = JSON.parse(JSON.stringify(val))
- const today = new Date()
- temp_val.sort(function (a, b) {
- return a - b
- })
- const num = temp_val.findIndex(e => e > today.getDay())
- if (temp_val.length > 0 && num !== -1) {
- this.nextDate = this.getDayDate(temp_val[num], 0)
- } else if (temp_val.length > 0 && num === -1) {
- this.nextDate = this.getDayDate(temp_val[0], 1)
- } else {
- this.nextDate = ''
- }
- },
- immediate: true
- },
- weekCheck: {
- handler: function (val, oldVal) {
- this.formatRiQi()
- if (val === '') {
- this.nextDate = ''
- return
- }
- const today = new Date()
- const weekNum = []
- weekNum.push(val)
- const num = weekNum.findIndex(e => e > today.getDay())
- if (val !== '' && num !== -1) {
- this.nextDate = this.getDayDate(weekNum[0], 0)
- } else if (val !== '' && num === -1) {
- this.nextDate = this.getDayDate(weekNum[0], 1)
- } else {
- this.nextDate = ''
- }
- },
- immediate: true
- },
- monthCheck: {
- handler: function (val, oldVal) {
- this.formatRiQi()
- if (val === '') {
- this.nextDate = ''
- return
- }
- const today = new Date()
- const day = today.getDate()
- const nextMonth = this.getNextMonthDate(today, val, 1)
- const currentMonth = this.getNextMonthDate(today, val, 0)
- this.nextDate = val > day ? currentMonth : nextMonth
- }
- // immediate: true
- },
- quarterCheck: {
- handler: function (val, oldVal) {
- this.formatRiQi()
- if (val === '') {
- this.nextDate = ''
- return
- }
- const quarterList = [[1, 2, 3], [4, 5, 6], [7, 8, 9], [10, 11, 12]]
- const today = new Date()
- const month = today.getMonth() + 1
- const qu = this.getQuarter(today)
- const nowM = quarterList[qu - 1][val - 1]
- const nextM = quarterList[qu % 4][val - 1]
- const endMonth = month >= nowM ? nextM : nowM
- const yearPJ = today.getFullYear()
- const monthPJ = endMonth > 9 ? endMonth : '0' + endMonth
- this.nextDate = yearPJ + '-' + monthPJ + '-01'
- }
- // immediate: true
- },
- halfYearCheck: {
- handler: function (val, oldVal) {
- this.formatRiQi()
- if (val === '') {
- this.nextDate = ''
- return
- }
- const midList = [[1, 2, 3, 4, 5, 6], [7, 8, 9, 10, 11, 12]]
- const today = new Date()
- const month = today.getMonth() + 1
- const qu = month > 6 ? 2 : 1
- const nowM = midList[qu - 1][val - 1]
- const nextM = midList[qu % 2][val - 1]
- const endMonth = month >= nowM ? nextM : nowM
- const yearPJ = today.getFullYear()
- const monthPJ = endMonth > 9 ? endMonth : '0' + endMonth
- this.nextDate = yearPJ + '-' + monthPJ + '-01'
- }
- // immediate: true
- },
- yearCheck: {
- handler: function (val, oldVal) {
- this.formatRiQi()
- if (val === '') {
- this.nextDate = ''
- return
- }
- const today = new Date()
- const month = today.getMonth() + 1
- const year = today.getFullYear()
- const qu = month >= val ? year + 1 : year
- const monthPJ = val > 9 ? val : '0' + val
- this.nextDate = qu + '-' + monthPJ + '-01'
- }
- // immediate: true
- }
- },
- mounted () {
- this.init()
- if (this.isEdit) {
- this.loadData()
- this.loadSubData()
- } else {
- this.isFirstDevice = false
- }
- },
- methods: {
- init () {
- this.loadSelectorData()
- },
- loadSelectorData () {
- const pos = this.$store.getters.level.second ? this.$store.getters.level.second : this.$store.getters.level.first
- const sql = `select * from t_sbwhgwpzb where di_dian_='${pos}'`
- this.$common.request('sql', sql).then(res => {
- const { data = [] } = res.variables || {}
- this.jianCeGangWeiList = data
- })
- },
- loadData () {
- const sql = `select * from t_sshjpzb where id_=${this.parentData.mainId}`
- this.$common.request('sql', sql).then(res => {
- const { data = [] } = res.variables || {}
- // console.log('主表', data)
- if (!data.length) {
- return this.$message.warning(``)
- }
- this.form = data[0]
- const jian_ce_ri_qi_ = data[0].jian_ce_ri_qi_
- if (this.form.default_environme) {
- const { humidity, temperature } = JSON.parse(this.form.default_environme)
- this.$set(this.form, 'temperatureMin', +temperature.min)
- this.$set(this.form, 'temperatureMax', +temperature.max)
- this.$set(this.form, 'humidityMin', +humidity.min)
- this.$set(this.form, 'humidityMax', +humidity.max)
- }
- if (this.form.jian_ce_ri_qi_) {
- this.$nextTick(() => {
- switch (this.form.zhou_qi_) {
- case '每日':
- if (jian_ce_ri_qi_ === '每天') {
- this.dayCheck = [1, 2, 3, 4, 5, 6, 7]
- } else {
- this.dayCheck = jian_ce_ri_qi_.split('每周')[1].split(',').map(item => +item)
- }
- break
- case '每周':
- this.weekCheck = +jian_ce_ri_qi_.split('每周')[1]
- break
- case '每月':
- this.monthCheck = +jian_ce_ri_qi_.split('每个月第')[1].split('天')[0]
- break
- case '每季度':
- this.quarterCheck = +jian_ce_ri_qi_.split('每季度第')[1].split('个月')[0]
- break
- case '每半年':
- this.halfYearCheck = +jian_ce_ri_qi_.split('每半年第')[1].split('个月')[0]
- break
- case '每年':
- this.yearCheck = +jian_ce_ri_qi_.split('每年第')[1].split('个月')[0]
- break
- default:
- break
- }
- })
- }
- this.$nextTick(() => {
- this.isFirstDevice = false
- })
- })
- },
- loadSubData () {
- const sql = `select * from t_sshjpzxq where parent_id_=${this.parentData.mainId}`
- this.$common.request('sql', sql).then(res => {
- const { data = [] } = res.variables || {}
- // console.log('子表', data)
- if (!data.length) {
- return this.$message.warning(``)
- }
- this.subForm = data
- this.subIdList = data.map(item => item.zi_wai_deng_wai_j)
- })
- },
- formatEnv (temperatureMax, temperatureMin, humidityMax, humidityMin) {
- const temp_environment_range = {
- temperature: {
- max: temperatureMax,
- min: temperatureMin
- },
- humidity: {
- max: humidityMax,
- min: humidityMin
- }
- }
- return JSON.stringify(temp_environment_range)
- },
- formatRiQi () {
- switch (this.form.zhou_qi_) {
- case '每日':
- if (!this.dayCheck || this.dayCheck.length === 0) {
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- } else if (this.dayCheck.length === 7) {
- this.form.jian_ce_ri_qi_ = '每天'
- this.form.ri_qi_lie_biao_ = '1,2,3,4,5,6,7'
- } else {
- const temp_dayCheck = JSON.parse(JSON.stringify(this.dayCheck))
- temp_dayCheck.sort(function (a, b) {
- return a - b
- })
- this.form.ri_qi_lie_biao_ = temp_dayCheck.join(',')
- this.form.jian_ce_ri_qi_ = '每周' + temp_dayCheck.join(',')
- }
- break
- case '每周':
- if (this.weekCheck) {
- this.form.jian_ce_ri_qi_ = '每周' + this.weekCheck
- this.form.ri_qi_lie_biao_ = this.weekCheck + ''
- } else {
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- }
- break
- case '每月':
- if (this.monthCheck) {
- this.form.jian_ce_ri_qi_ = '每个月第' + this.monthCheck + '天'
- this.form.ri_qi_lie_biao_ = this.monthCheck + ''
- } else {
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- }
- break
- case '每季度':
- if (this.quarterCheck) {
- this.form.jian_ce_ri_qi_ = '每季度第' + this.quarterCheck + '个月'
- this.form.ri_qi_lie_biao_ = this.quarterCheck + ''
- } else {
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- }
- break
- case '每半年':
- if (this.halfYearCheck) {
- this.form.jian_ce_ri_qi_ = '每半年第' + this.halfYearCheck + '个月'
- this.form.ri_qi_lie_biao_ = this.halfYearCheck + ''
- } else {
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- }
- break
- case '每年':
- if (this.yearCheck) {
- this.form.jian_ce_ri_qi_ = '每年第' + this.yearCheck + '个月'
- this.form.ri_qi_lie_biao_ = this.yearCheck + ''
- } else {
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- }
- break
- default:
- this.form.jian_ce_ri_qi_ = ''
- this.form.ri_qi_lie_biao_ = ''
- break
- }
- },
- // 当前页码改变
- handleCurrentChange (val) {
- this.currentPage = val
- },
- // 页码选择器改变
- handleSizeChange (val) {
- this.pageSize = val
- this.currentPage = 1
- },
- // 分页连续序号
- showIndex (index) {
- return index + 1 + (this.currentPage - 1) * this.pageSize
- },
- handleActionEvent ({ key }) {
- switch (key) {
- case 'cancel':
- this.dialogVisible = false
- break
- case 'save':
- this.saveResult()
- break
- default:
- break
- }
- },
- // 使用默认数据
- settingData () {
- this.$confirm('使用默认数据后子表中为空的字段将会被以上数据代替,是否继续?', '提示', {
- confirmButtonText: '确定',
- cancelButtonText: '取消',
- type: 'warning'
- })
- .then(() => {
- this.subForm.forEach(item => {
- if (item.bu_men_ === '') {
- item.bu_men_ = this.form.bian_zhi_bu_men_
- }
- if (item.jian_ce_gang_wei_ === '') {
- item.jian_ce_gang_wei_ = this.form.gang_wei_
- }
- if (item.kong_zhi_tiao_jia === '') {
- item.kong_zhi_tiao_jia = this.form.tiao_jian_
- }
- if (item.environment_range === '' || item.environment_range === this.formatEnv(0, 0, 0, 0)) {
- item.environment_range = this.form.default_environme
- }
- if (item.jian_ce_ri_qi_ === '') {
- item.jian_ce_ri_qi_ = this.form.jian_ce_ri_qi_
- }
- if (item.ri_qi_lie_biao_ === '') {
- item.ri_qi_lie_biao_ = this.form.ri_qi_lie_biao_
- }
- if (item.jian_ce_zhou_qi_ === '') {
- item.jian_ce_zhou_qi_ = this.form.zhou_qi_
- }
- })
- })
- },
- // 子表单添加/编辑按钮
- openDialog (row) {
- if (this.form.lei_xing_ === '') {
- return this.$message.warning('请先选择类型!')
- }
- this.$refs.FecDialogRef.open(row, this.jianCeGangWeiList, this.form, { dayCheck: this.dayCheck, weekCheck: this.weekCheck, monthCheck: this.monthCheck, quarterCheck: this.quarterCheck, halfYearCheck: this.halfYearCheck, yearCheck: this.yearCheck })
- },
- // 子表的提交事件
- sonSubmit (data) {
- const { dayCheck, weekCheck, monthCheck, quarterCheck, halfYearCheck, yearCheck, form, isEdit, row } = data
- const temp_form = JSON.parse(JSON.stringify(form))
- const temp_environment_range = {
- temperature: {
- max: temp_form.temperatureMax,
- min: temp_form.temperatureMin
- },
- humidity: {
- max: temp_form.humidityMax,
- min: temp_form.humidityMin
- }
- }
- // 温度湿度格式化
- temp_form.environment_range = JSON.stringify(temp_environment_range)
- // 监测日期格式化
- switch (temp_form.jian_ce_zhou_qi_) {
- case '每日':
- if (!dayCheck || dayCheck.length === 0) {
- temp_form.jian_ce_ri_qi_ = ''
- temp_form.ri_qi_lie_biao_ = ''
- } else if (dayCheck.length === 7) {
- temp_form.jian_ce_ri_qi_ = '每天'
- temp_form.ri_qi_lie_biao_ = '1,2,3,4,5,6,7'
- } else {
- dayCheck.sort(function (a, b) {
- return a - b
- })
- temp_form.jian_ce_ri_qi_ = '每周' + dayCheck.join(',')
- temp_form.ri_qi_lie_biao_ = dayCheck.join(',')
- }
- break
- case '每周':
- if (weekCheck) {
- temp_form.jian_ce_ri_qi_ = '每周' + weekCheck
- temp_form.ri_qi_lie_biao_ = weekCheck + ''
- } else {
- temp_form.jian_ce_ri_qi_ = ''
- temp_form.ri_qi_lie_biao_ = ''
- }
- break
- case '每月':
- if (monthCheck) {
- temp_form.jian_ce_ri_qi_ = '每个月第' + monthCheck + '天'
- temp_form.ri_qi_lie_biao_ = monthCheck + ''
- } else {
- temp_form.jian_ce_ri_qi_ = ''
- temp_form.ri_qi_lie_biao_ = ''
- }
- break
- case '每季度':
- if (quarterCheck) {
- temp_form.jian_ce_ri_qi_ = '每季度第' + [quarterCheck] + '个月'
- temp_form.ri_qi_lie_biao_ = quarterCheck + ''
- } else {
- temp_form.jian_ce_ri_qi_ = ''
- temp_form.ri_qi_lie_biao_ = ''
- }
- break
- case '每半年':
- if (halfYearCheck) {
- temp_form.jian_ce_ri_qi_ = '每半年第' + [halfYearCheck] + '个月'
- temp_form.ri_qi_lie_biao_ = halfYearCheck + ''
- } else {
- temp_form.jian_ce_ri_qi_ = ''
- temp_form.ri_qi_lie_biao_ = ''
- }
- break
- case '每年':
- if (yearCheck) {
- temp_form.jian_ce_ri_qi_ = '每年第' + [yearCheck] + '个月'
- temp_form.ri_qi_lie_biao_ = yearCheck + ''
- } else {
- temp_form.jian_ce_ri_qi_ = ''
- temp_form.ri_qi_lie_biao_ = ''
- }
- break
- default:
- break
- }
- // 是否启用格式化
- temp_form.shi_fou_qi_yong_ = temp_form.shi_fou_qi_yong_ ? '1' : '0'
- // 删除多余项
- delete temp_form.temperatureMax
- delete temp_form.humidityMax
- delete temp_form.temperatureMin
- delete temp_form.humidityMin
- if (isEdit === true) {
- Object.assign(row, temp_form)
- } else {
- this.subForm.push(temp_form)
- }
- this.isEdit && this.goSearch()
- this.$refs.FecDialogRef.close()
- },
- // 关闭当前窗口
- closeDialog () {
- this.dialogVisible = false
- this.$emit('close', false)
- },
- // 子表删除
- removeItem () {
- if (this.multipleSelection.length === 0) {
- return this.$message.warning('请选择要删除的数据!')
- } else {
- this.$confirm('请确认是否删除所选项?', '提示', {
- confirmButtonText: '确定',
- cancelButtonText: '取消',
- type: 'warning'
- }).then(() => {
- this.multipleSelection.forEach(item => {
- const index = this.subForm.indexOf(item)
- this.subForm.splice(index, 1)
- })
- this.isEdit && this.goSearch()
- this.$message.success('删除成功!')
- this.multipleSelection = []
- }).catch(() => {
- this.$message({
- type: 'info',
- message: '已取消删除'
- })
- })
- }
- },
- // table复选框
- handleSelectionChange (val) {
- this.multipleSelection = val
- },
- submit () {
- if (this.subForm.length === 0) {
- return this.$message.warning('请添加子表数据')
- }
- for (var i = 0; i < this.subForm.length; i++) {
- const item = this.subForm[i]
- if (item.bu_men_ === '') {
- return this.$message.warning(`子表第${i + 1}行部门信息缺失!`)
- }
- if (item.jian_ce_ri_qi_ === '') {
- return this.$message.warning(`子表第${i + 1}行监测日期信息缺失!`)
- }
- if (item.jian_ce_gang_wei_ === '') {
- return this.$message.warning(`子表第${i + 1}行监测岗位信息缺失!`)
- }
- }
- delete this.form.temperatureMax
- delete this.form.humidityMax
- delete this.form.temperatureMin
- delete this.form.humidityMin
- // console.log('主表', this.form)
- // console.log('子表', this.subForm)
- const allUid = this.subForm.map(item => item.zi_wai_deng_wai_j)
- const existUid = this.subIdList
- const addList = this.subForm.filter(item => !existUid.includes(item.zi_wai_deng_wai_j))
- const deleteList = existUid.filter(item => !allUid.includes(item))
- const updateList = this.subForm.filter(item => existUid.includes(item.zi_wai_deng_wai_j))
- // console.log('原来数据', existUid)
- // console.log('全部数据', allUid)
- // console.log('需要添加', addList)
- // console.log('需要更新', updateList)
- // console.log('需要删除', deleteList)
- // return
- // 主表修改
- if (this.isEdit) {
- const params = {
- tableName: 't_sshjpzb',
- updList: [
- {
- where: {
- id_: this.parentData.mainId
- },
- param: {
- lei_xing_: this.form.lei_xing_,
- bian_zhi_bu_men_: this.form.bian_zhi_bu_men_,
- zhou_qi_: this.form.zhou_qi_,
- gang_wei_: this.form.gang_wei_,
- tiao_jian_: this.form.tiao_jian_,
- default_environme: this.form.default_environme,
- she_bei_bian_hao_: this.form.she_bei_bian_hao_,
- jian_ce_ri_qi_: this.form.jian_ce_ri_qi_,
- ri_qi_lie_biao_: this.form.ri_qi_lie_biao_,
- mo_kuai_lu_jing_: this.form.mo_kuai_lu_jing_
- }
- }
- ]
- }
- this.$common.request('update', params).then(() => {
- console.log('主表更新数据成功')
- if (addList.length) {
- const params = {
- tableName: 't_sshjpzxq',
- paramWhere: addList.map(item => {
- return { ...item, parent_id_: this.parentData.mainId }
- })
- }
- this.$common.request('add', params).then(() => { console.log('子表添加数据成功') })
- }
- if (updateList.length) {
- const params = {
- tableName: 't_sshjpzxq',
- updList: updateList.map(item => ({
- where: {
- zi_wai_deng_wai_j: item.zi_wai_deng_wai_j
- },
- param: {
- qu_yu_: item.qu_yu_,
- fang_jian_: item.fang_jian_,
- bu_men_: item.bu_men_,
- deviceno1_: item.deviceno1_,
- devicename1_: item.devicename1_,
- deviceno2_: item.deviceno2_, // 监控设备
- jian_ce_zhou_qi_: item.jian_ce_zhou_qi_,
- jian_ce_gang_wei_: item.jian_ce_gang_wei_,
- shi_fou_qi_yong_: item.shi_fou_qi_yong_,
- kong_zhi_tiao_jia: item.kong_zhi_tiao_jia,
- environment_range: item.environment_range,
- xiu_zheng_shi_du_: item.xiu_zheng_shi_du_,
- xiu_zheng_wen_du_: item.xiu_zheng_wen_du_,
- jian_ce_ri_qi_: item.jian_ce_ri_qi_,
- ri_qi_lie_biao_: item.ri_qi_lie_biao_
- }
- }))
- }
- this.$common.request('update', params).then(() => { console.log('子表更新数据成功') })
- }
- if (deleteList.length) {
- const params = {
- tableName: 't_sshjpzxq',
- paramWhere: { zi_wai_deng_wai_j: deleteList.join(',') }
- }
- this.$common.request('delete', params).then(() => { console.log('子表删除数据成功') })
- }
- this.$nextTick(() => {
- this.$message.success('修改成功!')
- this.closeDialog()
- })
- })
- } else {
- const params = {
- tableName: 't_sshjpzb',
- paramWhere: [this.form]
- }
- this.$common.request('add', params).then((res) => {
- console.log('主表新增数据成功')
- const { cont = [] } = res.variables || {}
- if (addList.length) {
- const params = {
- tableName: 't_sshjpzxq',
- paramWhere: addList.map(item => {
- return { ...item, parent_id_: cont[0].id_ }
- })
- }
- this.$common.request('add', params).then(() => {
- this.$message.success('添加成功!')
- console.log('子表添加数据成功')
- this.closeDialog()
- })
- }
- })
- }
- // 紫外灯数据同步更新紫外灯消毒记录表
- if (this.form.lei_xing_.includes('12')) {
- const tableName = 't_jykzwdxdjlbsc'
- // 生成添加请求参数
- const addParams = addList.length ? {
- tableName,
- paramWhere: addList.map(item => ({
- di_dian_: this.level,
- bian_zhi_bu_men_: item.bu_men_,
- bian_zhi_ren_: this.userId,
- zi_wai_deng_ming_: item.deviceName1,
- she_shi_id_: item.zi_wai_deng_wai_j
- }))
- } : null
- // 生成更新请求参数
- const updateParams = updateList.length ? {
- tableName,
- updList: updateList.map(item => ({
- where: {
- she_shi_id_: item.zi_wai_deng_wai_j
- },
- param: {
- bian_zhi_bu_men_: item.bu_men_,
- zi_wai_deng_ming_: item.deviceName1
- }
- }))
- } : null
- // 生成删除请求参数
- const deleteParams = deleteList.length ? {
- tableName,
- paramWhere: { she_shi_id_: deleteList.map(item => item.sheShiId).join(',') }
- } : null
- // 合并所有请求
- const allRequests = []
- if (addParams) {
- allRequests.push(this.$common.request('add', addParams).then(() => console.log('添加紫外灯数据成功')))
- }
- if (updateParams) {
- allRequests.push(this.$common.request('update', updateParams).then(() => console.log('更新紫外灯数据成功')))
- }
- if (deleteParams) {
- allRequests.push(this.$common.request('delete', deleteParams).then(() => console.log('删除紫外灯数据成功')))
- }
- // 执行所有请求
- Promise.all(allRequests)
- .then(() => console.log('所有请求完成'))
- .catch(error => console.error('请求出错:', error))
- }
- },
- saveResult () {
- this.$refs.form.validate((valid) => {
- if (valid) {
- this.submit()
- } else {
- this.$message.warning('请填写必填项')
- return false
- }
- })
- },
- /* 读取文件 */
- readFile (file) {
- return new Promise(resolve => {
- const reader = new FileReader()
- reader.readAsBinaryString(file)
- reader.onload = ev => {
- resolve(ev.target.result)
- }
- })
- },
- // 获取 excel 的 json 数据
- async handleUploadChange (file) {
- const dataBinary = await this.readFile(file.raw)
- const workBook = xlsx.read(dataBinary, { type: 'binary', cellDates: true })
- const workSheet = workBook.Sheets[workBook.SheetNames[0]]
- const data = xlsx.utils.sheet_to_json(workSheet)
- if (data.length === 0) {
- return this.$message.warning('文件内容为空!')
- }
- data.forEach(item => {
- this.subForm.push({
- deviceno1_: item['被控设备编号'] || '',
- devicename1_: item['被控设备名称'] || '',
- shi_fou_qi_yong_: '1',
- bu_men_: this.switchDeptid(item['部门']),
- jian_ce_gang_wei_: item['监测岗位'] || '',
- jian_ce_zhou_qi_: item['监测周期'] || '',
- kong_zhi_tiao_jia: item['控制条件'] || '',
- environment_range: '',
- xiu_zheng_shi_du_: item['湿度修正值'] || '',
- xiu_zheng_wen_du_: item['温度修正值'] || '',
- fang_jian_: item['房间'] || '',
- qu_yu_: item['区域'] || '',
- deviceno2_: item['监控设备编号'] || '',
- jian_ce_ri_qi_: '',
- ri_qi_lie_biao_: '',
- zi_wai_deng_wai_j: this.$utils.guid()
- })
- })
- this.$message.success('导入成功!')
- },
- // 部门id转部门
- switchDept (dep) {
- const userList = this.$store.getters.userList
- for (let i = 0; i < userList.length; i++) {
- const user = userList[i]
- const positionId = user.positionId.split(',')
- const positions = user.positions.split(',')
- const pos = positionId.findIndex(p => p === dep)
- if (pos >= 0) {
- return positions[pos]
- }
- }
- },
- // id 转部门
- switchDeptid (id) {
- const userList = this.$store.getters.userList
- for (let i = 0; i < userList.length; i++) {
- const user = userList[i]
- const positionId = user.positionId.split(',')
- const positions = user.positions.split(',')
- const pos = positions.findIndex(p => p === id)
- if (pos >= 0) {
- return positionId[pos]
- }
- }
- return ''
- },
- // 导出
- exportExcel () {
- const temp_subForm = JSON.parse(JSON.stringify(this.subForm))
- temp_subForm.forEach(item => {
- item.bu_men_ = this.switchDept(item.bu_men_)
- })
- this.xlsx(temp_subForm, this.listHander, '设施环境配置表')
- this.$message.success('导出成功!')
- },
- xlsx (json, fields, filename = '.xlsx') { // 导出xlsx
- json.forEach(item => {
- for (const i in item) {
- if (fields.hasOwnProperty(i)) {
- item[fields[i]] = item[i]
- }
- delete item[i] // 删除原先的对象属性
- }
- })
- const sheetName = filename // excel的文件名称
- const wb = xlsx.utils.book_new() // 工作簿对象包含一SheetNames数组,以及一个表对象映射表名称到表对象。XLSX.utils.book_new实用函数创建一个新的工作簿对象。
- const ws = xlsx.utils.json_to_sheet(json, { header: Object.values(fields) }) // 将JS对象数组转换为工作表。
- wb.SheetNames.push(sheetName)
- wb.Sheets[sheetName] = ws
- const defaultCellStyle = { font: { name: 'Verdana', sz: 13, color: 'FF00FF88' }, fill: { fgColor: { rgb: 'FFFFAA00' }}}// 设置表格的样式
- const wopts = { bookType: 'xlsx', bookSST: false, type: 'binary', cellStyles: true, defaultCellStyle: defaultCellStyle, showGridLines: false } // 写入的样式
- const wbout = xlsx.write(wb, wopts)
- const blob = new Blob([this.s2ab(wbout)], { type: 'application/octet-stream' })
- fs.saveAs(blob, filename + '.xlsx')
- },
- s2ab (s) {
- let buf
- if (typeof ArrayBuffer !== 'undefined') {
- buf = new ArrayBuffer(s.length)
- const view = new Uint8Array(buf)
- for (let i = 0; i !== s.length; ++i) view[i] = s.charCodeAt(i) & 0xff
- return buf
- } else {
- buf = new Array(s.length)
- for (let i = 0; i !== s.length; ++i) buf[i] = s.charCodeAt(i) & 0xFF
- return buf
- }
- },
- getDayDate (type, dates) {
- const now = new Date()
- const nowTime = now.getTime()
- const day = now.getDay()
- const longTime = 24 * 60 * 60 * 1000
- const n = longTime * 7 * (dates || 0)
- let dd = nowTime - (day - type) * longTime + n
- dd = new Date(dd)
- const y = dd.getFullYear()
- let m = dd.getMonth() + 1
- let d = dd.getDate()
- m = m < 10 ? '0' + m : m
- d = d < 10 ? '0' + d : d
- const daynow = y + '-' + m + '-' + d
- return daynow
- },
- // 获取往后几个月相应的日期
- // currentDate:当前日期
- // dayOfMonth:获取几号
- // val:往后几个月
- getNextMonthDate (currentDate, dayOfMonth, val) {
- const currentYear = currentDate.getFullYear()
- const currentMonth = currentDate.getMonth()
- const nextMonth = currentMonth + val
- const nextMonthDate = new Date(currentYear, nextMonth, dayOfMonth)
- const formattedDate = nextMonthDate.toLocaleString('zh-CN', { year: 'numeric', month: '2-digit', day: '2-digit' }).replace(/\//g, '-')
- return formattedDate
- },
- // 获取当前季度
- getQuarter (date) {
- return Math.floor(date.getMonth() / 3) + 1
- },
- // 查询
- goSearch () {
- console.log(this.search)
- if (!this.search.buMen && !this.search.quYu && !this.search.fangJian && !this.search.zhouQi && !this.search.gangWei) {
- this.isSearch = false
- } else {
- // 条件过滤
- const searchData = this.subForm
- .filter(item => item.bu_men_.indexOf(this.search.buMen) > -1)
- .filter(item => item.qu_yu_.indexOf(this.search.quYu) > -1)
- .filter(item => item.fang_jian_.indexOf(this.search.fangJian) > -1)
- .filter(item => item.jian_ce_zhou_qi_.indexOf(this.search.zhouQi) > -1)
- .filter(item => item.jian_ce_gang_wei_.indexOf(this.search.gangWei) > -1)
- this.isSearch = true
- this.searchData = searchData
- }
- }
- }
- }
- </script>
- <style lang="scss" scoped>
- .paper-detail-dialog {
- ::v-deep {
- .el-dialog__header {
- text-align: center;
- }
- }
- .dialog-title{
- display: flex;
- align-items: center;
- justify-content: center;
- div{
- position: absolute;
- right:20px;
- }
- }
- .container {
- display: flex;
- width: 100%;
- justify-content: center;
- .main{
- width: 80%;
- height: calc(100vh - 70px);
- box-shadow: 0 2px 12px 0 rgba(0, 0, 0, 0.1);
- padding:20px;
- // overflow-y: auto;
- .form{
- .el-row{
- margin: 10px 0;
- }
- }
- .btn{
- display: flex;
- .upload-demo{
- margin-right: 10px;
- }
- }
- }
- .table{
- .search{
- display: flex;
- align-items: center;
- .search-item{
- span{
- width: 60px;
- margin-right: 10px;
- }
- display: flex;
- align-items: center;
- width: 200px;
- margin: 0 10px 0 10px;
- }
- }
- }
- }
- }
- </style>
|