增加导出员工

yijiusmile

2021-02-18 26fff9451114b1508faf7d67f67507564c31e667

增加导出员工

 src/views/user/inemployees.vue

@@ -1244,7 +1244,8 @@
              <el-upload
                ref="upload"
                class="upload-demo"
                action="https://jsonplaceholder.typicode.com/posts/"
                action="hr/empBaseInfo/importEmp"
                :headers="headers()"
                :file-list="fileList"
                :auto-upload="false"
              >
@@ -1307,174 +1308,176 @@
      <table id="dcygTable" width="100%">
        <tr>
          <td colspan="6" style="text-align: left;">
            <el-checkbox />
            <el-checkbox v-model="checkAll" :indeterminate="isIndeterminate" @change="handleCheckAllChange" />
            全部字段
          </td>
        </tr>
        <tr>
          <td>档案号</td>
          <td>
            <el-checkbox />
          </td>
          <td>姓名</td>
          <td>
            <el-checkbox />
          </td>
          <td>性别</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>部门(护卫点)</td>
          <td>
            <el-checkbox />
          </td>
          <td>所属岗位</td>
          <td>
            <el-checkbox />
          </td>
          <td>员工类别</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>民族</td>
          <td>
            <el-checkbox />
          </td>
          <td>身份证号码</td>
          <td>
            <el-checkbox />
          </td>
          <td>年龄</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>婚姻状况</td>
          <td>
            <el-checkbox />
          </td>
          <td>身份证有效期</td>
          <td>
            <el-checkbox />
          </td>
          <td>身高</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>政治面貌</td>
          <td>
            <el-checkbox />
          </td>
          <td>出生日期</td>
          <td>
            <el-checkbox />
          </td>
          <td>最高学历</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>籍贯</td>
          <td>
            <el-checkbox />
          </td>
          <td>户籍地址</td>
          <td>
            <el-checkbox />
          </td>
          <td>户籍地址</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>保安员证号</td>
          <td>
            <el-checkbox />
          </td>
          <td>保安员回执</td>
          <td>
            <el-checkbox />
          </td>
          <td>档案情况</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>银行名称</td>
          <td>
            <el-checkbox />
          </td>
          <td>银行账号</td>
          <td>
            <el-checkbox />
          </td>
          <td>电话号码</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>入职日期</td>
          <td>
            <el-checkbox />
          </td>
          <td>保险类型</td>
          <td>
            <el-checkbox />
          </td>
          <td>社保电脑号</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>招聘介绍人</td>
          <td>
            <el-checkbox />
          </td>
          <td>入司工龄</td>
          <td>
            <el-checkbox />
          </td>
          <td>工作证</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>相关证件</td>
          <td>
            <el-checkbox />
          </td>
          <td>紧急联系电话</td>
          <td>
            <el-checkbox />
          </td>
          <td>员工手册</td>
          <td>
            <el-checkbox />
          </td>
        </tr>
        <tr>
          <td>家庭成员及关系</td>
          <td>
            <el-checkbox />
          </td>
          <td />
          <td />
          <td />
          <td />
        </tr>
        <el-checkbox-group v-model="checkedCities" @change="handleCheckedCitiesChange">
          <tr>
            <td>档案号</td>
            <td>
              <el-checkbox label="archivesNumb"><span /></el-checkbox>
            </td>
            <td>姓名</td>
            <td>
              <el-checkbox label="empName"><span /></el-checkbox>
            </td>
            <td>性别</td>
            <td>
              <el-checkbox label="sex"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>部门(护卫点)</td>
            <td>
              <el-checkbox label="deptName"><span /></el-checkbox>
            </td>
            <td>所属岗位</td>
            <td>
              <el-checkbox label="jobName"><span /></el-checkbox>
            </td>
            <td>员工类别</td>
            <td>
              <el-checkbox label="empType"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>民族</td>
            <td>
              <el-checkbox label="nation"><span /></el-checkbox>
            </td>
            <td>身份证号码</td>
            <td>
              <el-checkbox label="certificateNumb"><span /></el-checkbox>
            </td>
            <td>年龄</td>
            <td>
              <el-checkbox label="age"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>婚姻状况</td>
            <td>
              <el-checkbox label="marriage"><span /></el-checkbox>
            </td>
            <td>身份证有效期</td>
            <td>
              <el-checkbox label="certificateValidity"><span /></el-checkbox>
            </td>
            <td>身高</td>
            <td>
              <el-checkbox label="stature"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>政治面貌</td>
            <td>
              <el-checkbox label="politics"><span /></el-checkbox>
            </td>
            <td>出生日期</td>
            <td>
              <el-checkbox label="birthdate"><span /></el-checkbox>
            </td>
            <td>最高学历</td>
            <td>
              <el-checkbox label="education"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>籍贯</td>
            <td>
              <el-checkbox label="nativePlace"><span /></el-checkbox>
            </td>
            <td>户籍地址</td>
            <td>
              <el-checkbox label="censusAddress"><span /></el-checkbox>
            </td>
            <td>现住址</td>
            <td>
              <el-checkbox label="currentAddress"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>保安员证号</td>
            <td>
              <el-checkbox label="guardNumb"><span /></el-checkbox>
            </td>
            <td>保安员回执</td>
            <td>
              <el-checkbox label="returnReceipt"><span /></el-checkbox>
            </td>
            <td>档案情况</td>
            <td>
              <el-checkbox label="archivesStatus"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>银行名称</td>
            <td>
              <el-checkbox label="bankName"><span /></el-checkbox>
            </td>
            <td>银行账号</td>
            <td>
              <el-checkbox label="bankNumb"><span /></el-checkbox>
            </td>
            <td>电话号码</td>
            <td>
              <el-checkbox label="telePhone"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>入职日期</td>
            <td>
              <el-checkbox label="entryDate"><span /></el-checkbox>
            </td>
            <td>保险类型</td>
            <td>
              <el-checkbox label="insuranceType"><span /></el-checkbox>
            </td>
            <td>社保电脑号</td>
            <td>
              <el-checkbox label="socialNumb"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>招聘介绍人</td>
            <td>
              <el-checkbox label="introducer"><span /></el-checkbox>
            </td>
            <td>入司工龄</td>
            <td>
              <el-checkbox label="seniority"><span /></el-checkbox>
            </td>
            <td>工作证</td>
            <td>
              <el-checkbox label="empCardStatus"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>相关证件</td>
            <td>
              <el-checkbox label="certificateList"><span /></el-checkbox>
            </td>
            <td>紧急联系电话</td>
            <td>
              <el-checkbox label="urgencyPhone"><span /></el-checkbox>
            </td>
            <td>员工手册</td>
            <td>
              <el-checkbox label="handbookStatus"><span /></el-checkbox>
            </td>
          </tr>
          <tr>
            <td>家庭成员及关系</td>
            <td>
              <el-checkbox label="family"><span /></el-checkbox>
            </td>
            <td />
            <td />
            <td />
            <td />
          </tr>
        </el-checkbox-group>
      </table>
      <div slot="footer" class="dialog-footer">
        <el-button @click="showDcyg(1)">取 消</el-button>
@@ -1693,6 +1696,11 @@
      dialogShowYgdg: false,
      dialogShowDryg: false,
      dialogShowGbda: false,
      exportUrl: '',
      checkAll: false,
      isIndeterminate: false,
      cityOptions: ['sex', 'empName', 'archivesNumb', 'deptName', 'jobName', 'empType', 'nation', 'certificateNumb', 'age', 'marriage', 'certificateValidity', 'stature', 'politics', 'birthdate', 'education', 'nativePlace', 'censusAddress', 'currentAddress', 'guardNumb', 'returnReceipt', 'archivesStatus', 'bankName', 'bankNumb', 'telePhone', 'entryDate', 'insuranceType', 'socialNumb', 'introducer', 'seniority', 'empCardStatus', 'certificateList', 'urgencyPhone', 'handbookStatus', 'family'],
      checkedCities: [],
      tableData: []
    }
  },
@@ -1948,6 +1956,15 @@
        this.dialogShowXzyg = false
      }
    },
    handleCheckAllChange(val) {
      this.checkedCities = val ? this.cityOptions : []
      this.isIndeterminate = false
    },
    handleCheckedCitiesChange(value) {
      const checkedCount = value.length
      this.checkAll = checkedCount === this.cityOptions.length
      this.isIndeterminate = checkedCount > 0 && checkedCount < this.cityOptions.length
    },
    showDcyg(operate) {
      switch (operate) {
        case 0:
@@ -1955,6 +1972,16 @@
          break
        case 1:
          this.dialogShowDcyg = false
          break
        case 2:
          debugger
          var params = { exportField: this.checkedCities.join(',') }
          this.$download('hr/empBaseInfo/export', { ...params }, '在职员工列表.xls').then(() => {
            this.$message({
              message: '下载成功!',
              type: 'success'
            })
          })
          break
      }
    },
@@ -2254,5 +2281,6 @@
  text-align: center;
  border: 1px solid darkgray;
  height: 30px;
  font-size:15px;
}
</style>

 src/views/user/search.vue

@@ -62,7 +62,7 @@
            <el-col :span="3">护卫点：
              <el-input v-model="queryParams.deptName" size="small" maxlength="20" style="width:100px" />
            </el-col>
            <el-col :span="8">入职日期：
            <el-col :span="9">入职日期：
              <el-date-picker
                v-model="queryParams.entryDateStr"
                size="small"
@@ -79,7 +79,7 @@
            </el-col>
          </el-row>
          <el-row>
            <el-col :span="8">离职日期：
            <el-col :span="9">离职日期：
              <el-date-picker
                v-model="queryParams.dimissionDateStr"
                size="small"