把所有模块的导入模板和导出问题都解决了

feige

2023-05-17 4efd39b4696db81789d3d92a54d197f1e85ecdf2

 ruoyi-ui/src/views/bignote/index.vue

@@ -38,7 +38,7 @@
          v-model="queryParams.address"
          placeholder="请输入地点"
          clearable
          style="width: 197px;
          style=" width:197px;
height: 30px;
background: #FFFFFF;
border-radius: 14px 14px 14px 14px;
@@ -51,13 +51,13 @@
      <el-form-item label="时间">
        <el-date-picker
          v-model="dateRange"
          style=" width: 197px;
          style="width:  197px;
height: 30px;
background: #FFFFFF;
border-radius: 14px 14px 14px 14px;
opacity: 0.5;
border: 1px solid rgba(0,0,0,0.25);"
          value-format="yyyy-MM-dd HH-MM"
          value-format="yyyy-MM-dd"
          type="daterange"
          range-separator="-"
          start-placeholder="开始日期"
@@ -65,8 +65,10 @@
        ></el-date-picker>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
        <el-button size="mini" @click="handleQuery" style=" width: 65px; height: 32px;background: #FFDDE3;
          border-radius: 6px 6px 6px 6px;opacity:1; " >搜索</el-button>
        <el-button  size="mini" @click="resetQuery" style=" width: 65px; height: 32px;background: #FFDDE3;
          border-radius: 6px 6px 6px 6px;opacity:1; " >重置</el-button>
      </el-form-item>
    </el-form>

@@ -112,26 +114,72 @@
          v-hasPermi="['family:note:export']"
        >导出</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
          @click="handleExportTemplate"
          v-hasPermi="['family:note:export']"
        >导入模板下载</el-button>
      </el-col>
      <el-col :span="1.2">

        <el-upload
          action=""

          class="upload-demo"
          :show-file-list="false"
          :http-request="handleEnport"
        >
          <el-button size="mini"   type="primary"
                     plain
                     icon="el-icon-plus" >导入</el-button>

        </el-upload>
      </el-col>

      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>
    <!-- 序号、时间、人物、地点、大事标题、电子文件、备注 -->
    <!-- 这里有个familyList数组 是在data()中定义的 -->
    <el-table v-loading="loading"  :data="familyList" @selection-change="handleSelectionChange" >
      <el-table-column type="selection" width="55"  align="center" />
      <el-table-column label="序号" prop="id" sortable width="120" />
    <el-table v-loading="loading"  :data="familyList" :row-key="getRowId" ref="multipleTable" @selection-change="handleSelectionChange"  :row-class-name="tableRowClassName">
      <el-table-column type="selection"  :reserve-selection="true" width="55"  align="center" />

      <el-table-column label="时间" align="center" sortable prop="createTime" width="180">
        <template slot-scope="scope">
          <span>{{ parseTime(scope.row.createTime) }}</span>
        </template>
      <el-table-column  label="序号" sortable type="index" :index="(queryParams.pageNum-1)*queryParams.pageSize+1" width="120"/>
      <el-table-column label="发生时间" prop="happenTime" sortable width="100" align="center">
        <template slot-scope="scope">{{scope.row.happenTime? scope.row.happenTime: '————'}}</template>
      </el-table-column>
      <el-table-column label="人物" prop="people" sortable width="100" />
      <el-table-column label="地点" prop="address" sortable width="100" />
      <el-table-column label="大事标题" prop="title" sortable :show-overflow-tooltip="true" width="150" />

      <el-table-column label="备注" prop="remark" sortable width="100" />
      <el-table-colum label="电子文件" prop="fujian" sortable width="100"/>
      <el-table-column label="家庭号" prop="familyId" sortable width="100" />
      <el-table-column label="备注" prop="remark" sortable width="100" >
        <template slot-scope="scope">{{scope.row.remark? scope.row.remark: '————'}}</template>
      </el-table-column>

      <!-- <el-table-column label="家庭号" prop="familyId" sortable width="100" /> -->
      <el-table-column label="电子文件" prop="url" width="160" >
        <template slot-scope="scope" >
          <img
            class="el-upload-list__item-thumbnail"
            src="../../assets/images/deviceLis.png"
            alt=""
            style="width: 35px; height: 35px;"
            fit="cover"
            v-if="scope.row.url !== null"
          >
          <img
            class="el-upload-list__item-thumbnail"
            src="../../assets/images/deviceA.png"
            alt=""
            style="width: 35px; height: 35px;"
            fit="cover"
            v-if="scope.row.url === null"
          >
        </template>
      </el-table-column>
      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope" v-if="scope.row.roleId !== 1">
          <el-button
@@ -139,7 +187,7 @@
            type="text"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
            v-hasPermi="['system:role:edit']"
            v-hasPermi="['familymodel:bignote:list']"
          >修改</el-button>
          <el-button
            size="mini"
@@ -148,7 +196,7 @@
            @click="handleDelete(scope.row)"
            v-hasPermi="['system:role:remove']"
          >删除</el-button>
          <el-dropdown size="mini" @command="(command) => handleCommand(command, scope.row)" v-hasPermi="['system:role:edit']">
          <el-dropdown size="mini" @command="(command) => handleCommand(command, scope.row)" v-hasPermi="['familymodel:bignote:list']">
            <el-button size="mini" type="text" icon="el-icon-d-arrow-right"  @click="handleCheck(scope.row)">查看详情</el-button>

          </el-dropdown>
@@ -162,6 +210,7 @@
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
      style="background: #FEF7FC;"
    />

    <!-- 添加或修改资产信息配置对话框 -->
@@ -181,9 +230,13 @@
          <el-input v-model="formDat.address" placeholder="请输入地点" clearable :style="{width: '100%'}" >
          </el-input>
        </el-form-item>
        <el-form-item label="家庭号" prop="familyId">
          <el-input v-model="formDat.familyId" placeholder="请输入家庭号" clearable :style="{width: '100%'}" >
          </el-input>

        <el-form-item label="发生时间" prop="happenTime">
          <el-date-picker
            v-model='formDat.happenTime'
            type='date'
            placeholder='选择日期'
          ></el-date-picker>
        </el-form-item>
        <el-form-item label="备注" prop="remark">
          <el-input v-model="formDat.remark" placeholder="请输入备注" clearable :style="{width: '100%'}" ></el-input>
@@ -249,7 +302,7 @@
      <h4 class="form-header"> </h4>

      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitDataScope">确 定</el-button>
        <el-button type="primary" @click="submitDataScope">保 存</el-button>
        <el-button @click="cancelData">取 消</el-button>
      </div>
    </el-dialog>
@@ -269,9 +322,10 @@
import { treeselect as menuTreeselect, roleMenuTreeselect } from "@/api/system/menu";


import { Notification, MessageBox, Message, Loading } from 'element-ui'

//在system/note/index.js中导入接口函数  --接好了
import {listFamilyevent , getFamilyeventInfo , delFamilyevent  , addFamilyevent , uploadPic} from "@/api/bignote/index";
import {listFamilyevent,enload, delFamilyevent  , addFamilyevent , uploadPic} from "@/api/bignote/index";
export default {
  name: "Role",
  dicts: ['sys_normal_disable'],
@@ -316,13 +370,14 @@
      dsb:true,
      btn:false,
      formDat: {
        type: undefined,
        // type: undefined,
        title: undefined,
        location: undefined,
        holder: undefined,
        address: undefined,
        remark: undefined,
        familyId:undefined,
        happenTime:undefined,
        url: undefined,
      },
      // 菜单列表
@@ -336,7 +391,8 @@
        title:undefined,
        people:undefined,
        address:undefined,
        createTime:undefined
        happenStartTime:undefined,
        happenEndTime:undefined
      },
      // 表单参数
      form: {},
@@ -367,7 +423,7 @@
          message: '请输入家庭号',
          trigger: 'blur'
        }],
        createTime: [{
        happenTime: [{
          required: true,
          message: '请选择日期选择',
          trigger: 'change'
@@ -387,31 +443,34 @@
      this.open = false;
      this.reset();
    },

    getRowId(row)
    {
      return row.id
    },
    //隔行变色
    tableRowClassName({ row, rowIndex }) {
      if (rowIndex % 2 == 0) {
        return "statistics-warning-row1";
      } else {
        return "statistics-warning-row";
      }
    },

    //   methods: {
    //   tableRowClassName({row, rowIndex}) {
    //     if (rowIndex === 1)  //=>这里可以改成 rowIndex%2=== 1，后面直接else即可达到隔行变色效果。
    //     {
    //       return 'warning-row';
    //     } else if (rowIndex === 3) {
    //       return 'success-row';
    //     }
    //     return '';
    //   }
    // },

    /** 查询角色列表 */
    //列表显示家大事记

    getList() {
      this.loading = true;
       console.log(this.queryParams)
      console.log(this.queryParams)
      this.queryParams.happenStartTime = this.dateRange.length > 0 && this.dateRange[0]
      this.queryParams.happenEndTime = this.dateRange.length > 0 && this.dateRange[1]

      //  listProperty(this.addDateRange(this.queryParams, this.dateRange)).then(response => {
      listFamilyevent(this.queryParams).then(response => {
            
         //    console.log(response.data.data)
          //  alert(123)
          //   console.log(response.data.data)
          // alert(response.data.data[1].url)
          this.familyList = response.data.data;

          this.total = response.data.total;
@@ -456,7 +515,6 @@
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;

      this.getList();
    },
    /** 重置按钮操作 */
@@ -468,7 +526,7 @@
    // 多选框选中数据
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.id)
      console.log(this.ids)
    //  alert(this.ids)
      this.single = selection.length!=1
      this.multiple = !selection.length
    },
@@ -484,8 +542,7 @@
    /** 查看详细信息 */
    handleCheck(row){
      const id = row.id;

      this.$router.push("/family1/bignote/familyeventInfo/" + id);
      this.$router.push("/familymodel/bignote/familyeventInfo/" + id);
    },
    /** 修改按钮操作 */
    handleUpdate(row) {
@@ -493,7 +550,7 @@
      let jd = true

      this.$router.push({
        path:"/family1/bignote/familyeventInfo/" + id,
        path:"/familymodel/bignote/familyeventInfo/" + id,
        query:{
          detail:jd
        }
@@ -552,19 +609,64 @@
    /** 删除按钮操作 */
    handleDelete(row) {
      const Ids = row.id || this.ids;
      this.$modal.confirm('是否确认删除序号为"' + Ids + '"的数据项？').then(function() {

      this.$modal.confirm('是否确认删除所选中数据项？').then(function() {
        return delFamilyevent(Ids);
      }).then(() => {
        this.getList();
        this.ids = []
        this.$modal.msgSuccess("删除成功");
      }).catch(() => {});
    },
    /** 导出按钮操作 */
    handleExport() {
        const Ids = this.ids;

      if(Ids.length==0)
      {
      this.download('/family/zfEvent/export', {
        ...this.queryParams
      }, `zfEvent_${new Date().getTime()}.xlsx`)
      }
      else{
        this.download('/family/zfEvent/export1/'+Ids, {
        }, `zfEvent_${new Date().getTime()}.xlsx`)
      }
      },
        /** 导入模板下载操作*/
    handleExportTemplate()
    {
     this.download('/family/zfEvent/model', {

      }, `zfEvent_${new Date().getTime()}.xlsx`)
    },
    /** 导入操作*/
    handleEnport(params){
      var file = params.file;
      var formData = new FormData();
      formData.append('excelImport', file);
      let _this = this
      enload(formData).then(response => {
        _this.getList();
        Message({ message: "导入成功", type: 'warning' })

      }).catch(err)
      {
        Message({ message: "导入失败", type: 'error' })
      }

    }

  }
};
</script>
<style>
.el-table__row.statistics-warning-row {
  background: #E0EEFE;

}
.el-table__row.statistics-warning-row1 {
  background: #FFEFF2;

}
</style>