1188 lines
54 KiB
HTML
1188 lines
54 KiB
HTML
|
||
<html>
|
||
|
||
<head>
|
||
<meta charset="utf-8" />
|
||
<script src="../lib/jquery/dist/jquery.js"></script>
|
||
<meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0, user-scalable=0">
|
||
<title></title>
|
||
<link rel="stylesheet" href="../Content/bootstrap.min.css">
|
||
<script src="../Scripts/bootstrap.min.js"></script>
|
||
|
||
<script src="../lib/vuejs/vue.js"></script>
|
||
<script src="../lib/vuejs/axios.min.js"></script>
|
||
<script src="../lib/elementui/index.js"></script>
|
||
<link href="../lib/elementui/index.css" rel="stylesheet" />
|
||
<!-- <script src="Scripts/jquery-3.4.1.js"></script>-->
|
||
<!-- <script src="Scripts/jquery.signalR-2.2.2.js"></script>-->
|
||
<!-- <script src="../signalr/hubs"></script>-->
|
||
</head>
|
||
|
||
<body>
|
||
<div id="app" >
|
||
<div style=" margin-top: 50px;">
|
||
<el-form :inline="true" class="demo-form-inline" style="overflow:auto;">
|
||
<div class="demo-input-suffix" style="margin-left: 11%;">
|
||
<el-select v-model="ruleForm.leibie" filterable placeholder="请选择类别">
|
||
<el-option v-for="(item,index) in Myjson" :key="index" :label="item.mytext"
|
||
:value="item.mytext" />
|
||
</el-select>
|
||
<el-select style="width: 150px;" v-model="ruleForm.tiaojian" placeholder="请选择条件">
|
||
<el-option v-for="(item,index) in Myjson1" :key="index" :label="item.mytext"
|
||
:value="item.mytext" />
|
||
</el-select>
|
||
<el-input style="width: 200px;" v-model="ruleForm.neirong" placeholder="请输入内容"
|
||
clearable></el-input>
|
||
<el-button plain @click="btnFuntion('and')">and</el-button>
|
||
<el-button plain @click="btnFuntion('or')">or</el-button>
|
||
<el-button plain @click="kuoHaoFuntion('(')">(</el-button>
|
||
<el-button plain @click="kuoHaoFuntion(')')">)</el-button>
|
||
</div>
|
||
|
||
<div style="width: 70%;margin: 50px; margin-left: 17%;margin-top:20px;">
|
||
<el-form-item label="需要导出的列">
|
||
<el-select v-model="selectStr" size="mini" filterable multiple placeholder="请选择需要导出的列">
|
||
<el-option v-for="item in wordStr" :key="item.TableName" :label="item.TableName"
|
||
:value="item.TableName">
|
||
</el-option>
|
||
</el-select>
|
||
</el-form-item>
|
||
<el-form-item label="需要转换的列">
|
||
<el-select v-model="selectStr2" size="mini" filterable multiple placeholder="请选择需要转换的列">
|
||
<el-option v-for="item in wordStr2" :key="item.TableName" :label="item.TableName"
|
||
:value="item.TableName">
|
||
</el-option>
|
||
</el-select>
|
||
</el-form-item>
|
||
</div>
|
||
|
||
<div>
|
||
<el-table :data="ruleData" style="width: 70%; margin: 50px; margin-left: 15%; margin-top: 20px;">
|
||
<el-table-column prop="leibie" label="类别">
|
||
</el-table-column>
|
||
<el-table-column prop="tiaojian" label="条件">
|
||
</el-table-column>
|
||
<el-table-column prop="neirong" label="内容">
|
||
</el-table-column>
|
||
<el-table-column prop="fangshi" label="方式">
|
||
</el-table-column>
|
||
<el-table-column label="操作">
|
||
<template slot-scope="scope">
|
||
<el-button @click="deleteFunction(scope.row)" type="text" size="small">
|
||
删除
|
||
</el-button>
|
||
</template>
|
||
</el-table-column>
|
||
</el-table>
|
||
</div>
|
||
|
||
<div>
|
||
<el-row style="padding: 10px">
|
||
<el-input type="textarea"
|
||
:rows="10"
|
||
placeholder="替换操作状态提示"
|
||
v-model="textarea">
|
||
</el-input>
|
||
</el-row>
|
||
</div>
|
||
|
||
</el-form>
|
||
|
||
<el-button style="width: 100px; display: block; margin-left: auto; margin-right: auto; "
|
||
@click="search(1)">导出</el-button>
|
||
<div style=" color: red; margin-left: 20px;">
|
||
<span v-if="numStr==1" id="spanStr"></span>
|
||
<span v-if="numStr==2">导出成功！！</span>
|
||
</div>
|
||
|
||
<div v-if="numStr==1||numStr==2">
|
||
<div class="progress progress-striped active">
|
||
<div class="progress-bar progress-bar-info" role="progressbar" id="divProgress"
|
||
aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
|
||
style="width: 1%;">
|
||
<span class="sr-only"></span>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</body>
|
||
|
||
</html>
|
||
|
||
<script>
|
||
var app = new Vue({
|
||
el: '#app',
|
||
data() {
|
||
return {
|
||
textarea:'',
|
||
Myjson:
|
||
[
|
||
{ "mytext": "年份", "PY": "RWNF" },
|
||
{ "mytext": "抽样单编号", "PY": "CYDBH" },
|
||
{ "mytext": "任务编号", "PY": "RWBH" },
|
||
{ "mytext": "流水号", "PY": "LSH" },
|
||
{ "mytext": "任务来源", "PY": "RWLY" },
|
||
{ "mytext": "任务类型", "PY": "RWLX" },
|
||
{ "mytext": "任务性质", "PY": "RWXZ" },
|
||
{ "mytext": "被抽样人信息(名称)", "PY": "BCYRMC" },
|
||
{ "mytext": "执行年月开始", "PY": "ZXNY_KS" },
|
||
{ "mytext": "执行年月结束", "PY": "ZXNY_JS" },
|
||
//-----------新食品分类----------------------------
|
||
{ "mytext": "食品大类", "PY": "SP_DL" },
|
||
{ "mytext": "食品亚类", "PY": "SP_YL" },
|
||
{ "mytext": "食品品种", "PY": "SP_PZ" },
|
||
{ "mytext": "食品细类", "PY": "SP_XL" },
|
||
//-------------------------------------------------
|
||
|
||
//-----------原食品分类----------------------------
|
||
{ "mytext": "原食品分类", "PY": "OldYPFL" },
|
||
//-------------------------------------------------------
|
||
{ "mytext": "区域类型", "PY": "QYLX" },
|
||
{ "mytext": "地址（市）", "PY": "DZ_S" },
|
||
{ "mytext": "地址（区（县））", "PY": "DZ_QX" },
|
||
{ "mytext": "地址（街道（镇）", "PY": "DZ_Z" },
|
||
{ "mytext": "地址（弄）", "PY": "DZ_N" },
|
||
{ "mytext": "地址（号）", "PY": "DZ_H" },
|
||
{ "mytext": "地址（室）", "PY": "DZ_S1" },
|
||
{ "mytext": "连贯地址", "PY": "BCYDWMC" },
|
||
{ "mytext": "法人代表", "PY": "FRDB" },
|
||
{ "mytext": "年销售额", "PY": "NXSE" },
|
||
{ "mytext": "营业执照号", "PY": "YYZZH" },
|
||
{ "mytext": "联系人", "PY": "LXR1" },
|
||
{ "mytext": "经营许可证", "PY": "JYXKZ" },
|
||
{ "mytext": "电话", "PY": "DH1" },
|
||
{ "mytext": "传真", "PY": "CZ" },
|
||
{ "mytext": "邮编", "PY": "YX" },
|
||
{ "mytext": "抽样地点", "PY": "CYDD" },
|
||
{ "mytext": "抽样地点类型", "PY": "CYDDLX" },
|
||
{ "mytext": "样品来源", "PY": "YPLY" },
|
||
{ "mytext": "样品属性", "PY": "YPSX" },
|
||
{ "mytext": "样品类型", "PY": "YPLX" },
|
||
{ "mytext": "样品名称", "PY": "YPMC" },
|
||
{ "mytext": "商标", "PY": "SB" },
|
||
{ "mytext": "生产/ 加工\n购进日期", "PY": "SCJGGJRQ" },
|
||
{ "mytext": "规格型号", "PY": "GGXH" },
|
||
{ "mytext": "样品批号", "PY": "YPPH" },
|
||
{ "mytext": "保质期", "PY": "BZQ" },
|
||
{ "mytext": "执行标准/技术文件", "PY": "ZXBZ" },
|
||
{ "mytext": "质量等级", "PY": "ZLDJ" },
|
||
{ "mytext": "生产许可证编号", "PY": "SCXKZBH" },
|
||
{ "mytext": "单价", "PY": "DJ" },
|
||
{ "mytext": "是否出口", "PY": "SFCK" },
|
||
{ "mytext": "抽样基数/批量", "PY": "CYJS" },
|
||
{ "mytext": "抽样数量(含备样)", "PY": "CYSL" },
|
||
{ "mytext": "备样数量", "PY": "BYSL" },
|
||
{ "mytext": "样品形态", "PY": "YPXT" },
|
||
{ "mytext": "包装分类", "PY": "BZFL" },
|
||
{ "mytext": "生产者名称", "PY": "SCZMC" },
|
||
{ "mytext": "生产者地址_省", "PY": "SCZDZ_S" },
|
||
{ "mytext": "生产者地址_市", "PY": "SCZDZ_s" },
|
||
{ "mytext": "生产者地址_区县", "PY": "SCZDZ_Q" },
|
||
{ "mytext": "生产者地址", "PY": "SCZDZ" },
|
||
{ "mytext": "联系电话", "PY": "LXDH" },
|
||
{ "mytext": "(标称)样品储存条件", "PY": "YPCCTJ" },
|
||
{ "mytext": "寄、送样品截止日期", "PY": "YPJZRQ" },
|
||
{ "mytext": "寄送样品地址", "PY": "JSYPDZ" },
|
||
{ "mytext": "抽样样品包装", "PY": "CYYPBZ" },
|
||
{ "mytext": "抽样方式", "PY": "CYFS" },
|
||
{ "mytext": "抽样单位信息（单位名称）", "PY": "CYDWMC" },
|
||
{ "mytext": "抽样单位信息（地址）", "PY": "CYDWDZ" },
|
||
{ "mytext": "抽样单位信息（联系人）", "PY": "CYDWLXR" },
|
||
{ "mytext": "抽样单位信息（电话）", "PY": "CYDWDH" },
|
||
{ "mytext": "抽样单位信息（传真）", "PY": "CYDWCZ" },
|
||
{ "mytext": "抽样单位信息（邮编）", "PY": "CYDWYB" },
|
||
//{ "mytext": "备注", "PY": "QT" },
|
||
{ "mytext": "被抽样单位签名", "PY": "BCYDWQM" },
|
||
{ "mytext": "被抽样单位签名时间", "PY": "BCYDWSJ" },
|
||
{ "mytext": "抽样人", "PY": "CYRQM" },
|
||
{ "mytext": "抽样单位", "PY": "CYDW" },
|
||
{ "mytext": "抽样人签名时间", "PY": "CYSJ" },
|
||
{ "mytext": "检测机构", "PY": "JCDW" },
|
||
{ "type": 0, "mytext": "----以下样品检验信息----", "PY": "1" },
|
||
{ "type": 2, "mytext": "检测大类", "PY": "JCDL" },
|
||
{ "type": 2, "mytext": "检测亚类", "PY": "JCYL" },
|
||
{ "type": 2, "mytext": "检测小类", "PY": "JCXL" },
|
||
{ "type": 2, "mytext": "检验项目", "PY": "JCXM" },
|
||
{ "type": 2, "mytext": "检测标准", "PY": "JCBZ" },
|
||
{ "type": 2, "mytext": "评价标准", "PY": "PJBZ" },
|
||
{ "type": 2, "mytext": "检测方法", "PY": "JCFF" },
|
||
|
||
{ "type": 2, "mytext": "方法名称", "PY": "JCMC" },
|
||
{ "type": 2, "mytext": "定性值", "PY": "ffjcx" },
|
||
{ "type": 2, "mytext": "定性值单位", "PY": "ffjcxDW" },
|
||
{ "type": 2, "mytext": "定量值", "PY": "ffdlx" },
|
||
{ "type": 2, "mytext": "定量值单位", "PY": "ffdlxDW" },
|
||
{ "type": 2, "mytext": "限量值", "PY": "bzz" },
|
||
{ "type": 2, "mytext": "限量值单位", "PY": "xlzDW" },
|
||
{ "type": 2, "mytext": "检测值", "PY": "jcz" },
|
||
{ "type": 2, "mytext": "检测值单位", "PY": "jczDW" },
|
||
{ "type": 2, "mytext": "单项判定", "PY": "Yzhen" },
|
||
{ "type": 2, "mytext": "备注", "PY": "QT" },
|
||
{ "type": 0, "mytext": "----以下样品检验结果信息----", "PY": "1" },
|
||
{ "type": 2, "mytext": "检测结果", "PY": "JieGuo" },
|
||
{ "type": 2, "mytext": "是否进口", "PY": "SFJK" },
|
||
{ "type": 2, "mytext": "原产地", "PY": "YCD" },
|
||
{ "type": 2, "mytext": "网络平台名称", "PY": "WLPTMC" },
|
||
{ "type": 2, "mytext": "检验机构简称", "PY": "JYJGJC" },
|
||
]
|
||
,//条件查询内容
|
||
Myjson1: [
|
||
{ "mytext": "等于" },
|
||
{ "mytext": "不等于" },
|
||
{ "mytext": "包含" },
|
||
{ "mytext": "不包含" },
|
||
{ "mytext": "大于" },
|
||
{ "mytext": "小于" },
|
||
{ "mytext": "大于等于" },
|
||
{ "mytext": "小于等于" },
|
||
]
|
||
,//条件查询判断
|
||
ruleForm: {
|
||
leibie: '',
|
||
tiaojian: '',
|
||
neirong: '',
|
||
fangshi: '',
|
||
},
|
||
//条件查询数组
|
||
ruleData: [],
|
||
wordStr: [
|
||
{
|
||
"TableName": "流水号",
|
||
"FieldName": "LSH"
|
||
},
|
||
{
|
||
"TableName": "抽样单编号",
|
||
"FieldName": "CYDBH"
|
||
},
|
||
{
|
||
"TableName": "任务编号",
|
||
"FieldName": "RWBH"
|
||
},
|
||
{
|
||
"TableName": "任务来源",
|
||
"FieldName": "RWLY"
|
||
},
|
||
{
|
||
"TableName": "任务类型",
|
||
"FieldName": "RWLX"
|
||
},
|
||
{
|
||
"TableName": "被抽样人信息名称",
|
||
"FieldName": "BCYRMC"
|
||
},
|
||
{
|
||
"TableName": "区域类型",
|
||
"FieldName": "QYLX"
|
||
},
|
||
{
|
||
"TableName": "被抽样单位省市自治区",
|
||
"FieldName": "DZ_S"
|
||
},
|
||
{
|
||
"TableName": "被抽样单位县市区",
|
||
"FieldName": "DZ_QX"
|
||
},
|
||
{
|
||
"TableName": "地址街道镇",
|
||
"FieldName": "DZ_Z"
|
||
},
|
||
{
|
||
"TableName": "地址弄",
|
||
"FieldName": "DZ_N"
|
||
},
|
||
{
|
||
"TableName": "地址号",
|
||
"FieldName": "DZ_H"
|
||
},
|
||
{
|
||
"TableName": "地址室",
|
||
"FieldName": "DZ_S1"
|
||
},
|
||
{
|
||
"TableName": "被抽样单位地址",
|
||
"FieldName": "BCYDWMC"
|
||
},
|
||
{
|
||
"TableName": "法人代表",
|
||
"FieldName": "FRDB"
|
||
},
|
||
{
|
||
"TableName": "年销售额",
|
||
"FieldName": "NXSE"
|
||
},
|
||
{
|
||
"TableName": "营业执照号",
|
||
"FieldName": "YYZZH"
|
||
},
|
||
{
|
||
"TableName": "联系人",
|
||
"FieldName": "LXR1"
|
||
},
|
||
{
|
||
"TableName": "经营许可证",
|
||
"FieldName": " JYXKZ"
|
||
},
|
||
{
|
||
"TableName": "电话",
|
||
"FieldName": "DH1"
|
||
},
|
||
{
|
||
"TableName": "传真",
|
||
"FieldName": "CZ"
|
||
},
|
||
{
|
||
"TableName": "邮编",
|
||
"FieldName": "YX"
|
||
},
|
||
{
|
||
"TableName": "抽样地点",
|
||
"FieldName": " CYDD"
|
||
},
|
||
{
|
||
"TableName": "抽样地点类型",
|
||
"FieldName": "CYDDLX"
|
||
},
|
||
{
|
||
"TableName": "样品来源",
|
||
"FieldName": "YPLY"
|
||
},
|
||
{
|
||
"TableName": "样品属性",
|
||
"FieldName": "YPSX"
|
||
},
|
||
{
|
||
"TableName": "样品类型",
|
||
"FieldName": "YPLX"
|
||
},
|
||
{
|
||
"TableName": "样品名称",
|
||
"FieldName": "YPMC"
|
||
},
|
||
{
|
||
"TableName": "商标",
|
||
"FieldName": "SB"
|
||
},
|
||
{
|
||
"TableName": "生产加工购进日期",
|
||
"FieldName": "SCJGGJRQ"
|
||
},
|
||
{
|
||
"TableName": "规格型号",
|
||
"FieldName": "GGXH"
|
||
},
|
||
{
|
||
"TableName": "样品批号",
|
||
"FieldName": " YPPH"
|
||
},
|
||
{
|
||
"TableName": "保质期",
|
||
"FieldName": " BZQ"
|
||
},
|
||
{
|
||
"TableName": "执行标准技术文件",
|
||
"FieldName": "ZXBZ"
|
||
},
|
||
{
|
||
"TableName": "质量等级",
|
||
"FieldName": "ZLDJ"
|
||
},
|
||
{
|
||
"TableName": "生产许可证编号",
|
||
"FieldName": "SCXKZBH"
|
||
},
|
||
{
|
||
"TableName": "单价",
|
||
"FieldName": "DJ"
|
||
},
|
||
{
|
||
"TableName": "是否出口",
|
||
"FieldName": "SFCK"
|
||
},
|
||
{
|
||
"TableName": "抽样基数批量",
|
||
"FieldName": "CYJS"
|
||
},
|
||
{
|
||
"TableName": "抽样数量含备样",
|
||
"FieldName": "CYSL"
|
||
},
|
||
{
|
||
"TableName": "备样数量",
|
||
"FieldName": "BYSL"
|
||
},
|
||
{
|
||
"TableName": "样品形态",
|
||
"FieldName": " YPXT"
|
||
},
|
||
{
|
||
"TableName": "包装分类",
|
||
"FieldName": "BZFL"
|
||
},
|
||
{
|
||
"TableName": "生产者名称",
|
||
"FieldName": "SCZMC"
|
||
},
|
||
{
|
||
"TableName": "生产者地址省",
|
||
"FieldName": "SCZDZ_S"
|
||
},
|
||
{
|
||
"TableName": "生产者地址市",
|
||
"FieldName": "SCZDZ_SS"
|
||
},
|
||
{
|
||
"TableName": "生产者地址区县",
|
||
"FieldName": "SCZDZ_Q"
|
||
},
|
||
{
|
||
"TableName": "生产者地址",
|
||
"FieldName": "SCZDZ"
|
||
},
|
||
{
|
||
"TableName": "联系电话",
|
||
"FieldName": "LXDH"
|
||
},
|
||
{
|
||
"TableName": "标称样品储存条件",
|
||
"FieldName": "YPCCTJ"
|
||
},
|
||
{
|
||
"TableName": "寄送样品截止日期",
|
||
"FieldName": "YPJZRQ"
|
||
},
|
||
{
|
||
"TableName": "寄送样品地址",
|
||
"FieldName": "JSYPDZ"
|
||
},
|
||
{
|
||
"TableName": "抽样样品包装",
|
||
"FieldName": "CYYPBZ"
|
||
},
|
||
{
|
||
"TableName": "抽样方式",
|
||
"FieldName": "CYFS"
|
||
},
|
||
{
|
||
"TableName": "抽样单位信息单位名称",
|
||
"FieldName": "CYDWMC"
|
||
},
|
||
{
|
||
"TableName": "抽样单位信息地址",
|
||
"FieldName": "CYDWDZ"
|
||
},
|
||
{
|
||
"TableName": "抽样单位信息联系人",
|
||
"FieldName": "CYDWLXR"
|
||
},
|
||
{
|
||
"TableName": "抽样单位信息电话",
|
||
"FieldName": " CYDWDH"
|
||
},
|
||
{
|
||
"TableName": "抽样单位信息传真",
|
||
"FieldName": "CYDWCZ"
|
||
},
|
||
{
|
||
"TableName": "抽样单位信息邮编",
|
||
"FieldName": "CYDWYB"
|
||
},
|
||
{
|
||
"TableName": "备注",
|
||
"FieldName": "QT"
|
||
},
|
||
{
|
||
"TableName": "被抽样单位签名",
|
||
"FieldName": "BCYDWQM"
|
||
},
|
||
{
|
||
"TableName": "被抽样单位签名时间",
|
||
"FieldName": "BCYDWSJ"
|
||
},
|
||
{
|
||
"TableName": "抽样人",
|
||
"FieldName": "CYRQM"
|
||
},
|
||
{
|
||
"TableName": "抽样单位",
|
||
"FieldName": "CYDW"
|
||
},
|
||
{
|
||
"TableName": "抽样人签名时间",
|
||
"FieldName": " CYSJ"
|
||
},
|
||
{
|
||
"TableName": "检测机构",
|
||
"FieldName": "JCDW"
|
||
},
|
||
{
|
||
"TableName": "结论",
|
||
"FieldName": "JieGuo"
|
||
},
|
||
{
|
||
"TableName": "原样品分类",
|
||
"FieldName": "OldYPFL"
|
||
},
|
||
{
|
||
"TableName": "样品分类",
|
||
"FieldName": "NewYPFL"
|
||
},
|
||
{
|
||
"TableName": "任务性质",
|
||
"FieldName": "RWXZ"
|
||
},
|
||
{
|
||
"TableName": "第三方企业名称",
|
||
"FieldName": "DSFQYMC"
|
||
},
|
||
{
|
||
"TableName": "第三方企业地址",
|
||
"FieldName": "DSFQYDZ"
|
||
},
|
||
{
|
||
"TableName": "第三方企业性质",
|
||
"FieldName": "DSFQYXZ"
|
||
},
|
||
{
|
||
"TableName": "第三方企业许可证编号",
|
||
"FieldName": "DSFQYXKZBH"
|
||
},
|
||
{
|
||
"TableName": "网络平台名称",
|
||
"FieldName": "WLPTMC"
|
||
},
|
||
{
|
||
"TableName": "网络平台营业执照号",
|
||
"FieldName": "WLPTYYZZH"
|
||
},
|
||
{
|
||
"TableName": "网抽平台所在地省",
|
||
"FieldName": "WLPTSZDS"
|
||
},
|
||
{
|
||
"TableName": "平台地址",
|
||
"FieldName": "PTDZ"
|
||
},
|
||
{
|
||
"TableName": "平台网址",
|
||
"FieldName": "PTWZ"
|
||
},
|
||
{
|
||
"TableName": "网店网址",
|
||
"FieldName": "WDWZ"
|
||
},
|
||
{
|
||
"TableName": "平台订单编号",
|
||
"FieldName": "PTDDBH"
|
||
},
|
||
{
|
||
"TableName": "温度",
|
||
"FieldName": "WD"
|
||
},
|
||
{
|
||
"TableName": "湿度",
|
||
"FieldName": "SD"
|
||
},
|
||
{
|
||
"TableName": "食品大类",
|
||
"FieldName": "SP_DL"
|
||
},
|
||
{
|
||
"TableName": "食品亚类",
|
||
"FieldName": "SP_YL"
|
||
},
|
||
{
|
||
"TableName": "食品品种",
|
||
"FieldName": "SP_PZ"
|
||
},
|
||
{
|
||
"TableName": "食品细类",
|
||
"FieldName": "SP_XL"
|
||
},
|
||
{
|
||
"TableName": "执行年月开始",
|
||
"FieldName": "ZXNY_KS"
|
||
},
|
||
{
|
||
"TableName": "执行年月结束",
|
||
"FieldName": "ZXNY_JS"
|
||
},
|
||
{
|
||
"TableName": "报告书编号",
|
||
"FieldName": "BGSBH"
|
||
},
|
||
{
|
||
"TableName": "原产地",
|
||
"FieldName": "YCD"
|
||
},
|
||
{
|
||
"TableName": "是否进口",
|
||
"FieldName": "SFJK"
|
||
},
|
||
{
|
||
"TableName": "任务年份",
|
||
"FieldName": "RWNF"
|
||
}
|
||
],//信息全字段
|
||
wordStr2: [
|
||
{
|
||
"TableName": "检验项目",
|
||
"FieldName": "JCXM"
|
||
},
|
||
{
|
||
"TableName": "检测大类",
|
||
"FieldName": "JCDL"
|
||
},
|
||
{
|
||
"TableName": "检测亚类",
|
||
"FieldName": "JCYL"
|
||
},
|
||
{
|
||
"TableName": "检测小类",
|
||
"FieldName": "JCXL"
|
||
},
|
||
{
|
||
"TableName": "检验依据",
|
||
"FieldName": "JCBZ"
|
||
},
|
||
{
|
||
"TableName": "检测方法",
|
||
"FieldName": "JCFF"
|
||
},
|
||
{
|
||
"TableName": "方法名称",
|
||
"FieldName": "JCMC"
|
||
},
|
||
{
|
||
"TableName": "检出限",
|
||
"FieldName": "ffjcx"
|
||
},
|
||
{
|
||
"TableName": "检出限单位",
|
||
"FieldName": "ffjcxDW"
|
||
},
|
||
{
|
||
"TableName": "定量限",
|
||
"FieldName": "ffdlx"
|
||
},
|
||
{
|
||
"TableName": "定量限单位",
|
||
"FieldName": "ffdlxDW"
|
||
},
|
||
{
|
||
"TableName": "判定依据",
|
||
"FieldName": "PJBZ"
|
||
},
|
||
{
|
||
"TableName": "限量值",
|
||
"FieldName": "bzz"
|
||
},
|
||
{
|
||
"TableName": "限量值单位",
|
||
"FieldName": "bzzdw"
|
||
},
|
||
{
|
||
"TableName": "检验结果",
|
||
"FieldName": "jcz"
|
||
},
|
||
{
|
||
"TableName": "检验结果备注",
|
||
"FieldName": "jczbz"
|
||
},
|
||
{
|
||
"TableName": "检测值单位",
|
||
"FieldName": "jczDW"
|
||
},
|
||
{
|
||
"TableName": "结果判定",
|
||
"FieldName": "Yzhen"
|
||
}
|
||
],//检验项目检测结果全字段
|
||
moRenStr: "抽样单编号,任务编号,流水号,任务来源,任务类型,被抽样人信息名称,区域类型,被抽样单位省市自治区,被抽样单位县市区,地址街道镇,地址弄,地址号,地址室,被抽样单位地址,法人代表,年销售额,营业执照号,联系人,经营许可证,电话,传真,邮编,抽样地点,抽样地点类型,样品来源,样品属性,样品类型,样品名称,商标,生产加工购进日期,规格型号,样品批号,保质期,执行标准技术文件,质量等级,生产许可证编号,单价,是否出口,抽样基数批量,抽样数量含备样,备样数量,样品形态,包装分类,生产者名称,生产者地址省,生产者地址市,生产者地址区县,生产者地址,联系电话,标称样品储存条件,寄送样品截止日期,寄送样品地址,抽样样品包装,抽样方式,抽样单位信息单位名称,抽样单位信息地址,抽样单位信息联系人,抽样单位信息电话,抽样单位信息传真,抽样单位信息邮编,备注,被抽样单位签名,被抽样单位签名时间,抽样人,抽样单位,抽样人签名时间,检测机构,结论,原样品分类,样品分类,任务性质,第三方企业名称,第三方企业地址,第三方企业性质,第三方企业许可证编号,网络平台名称,网络平台营业执照号,网抽平台所在地省,平台地址,平台网址,网店网址,平台订单编号,温度,湿度,食品大类,食品亚类,食品品种,食品细类,执行年月开始,执行年月结束,报告书编号,原产地,是否进口",//默认信息全字段
|
||
moRenStr2: "检验项目,检测大类,检测亚类,检测小类,检验依据,检测方法,方法名称,检出限,检出限单位,定量限,定量限单位,判定依据,限量值,限量值单位,检验结果,检验结果备注,检测值单位,结果判定",//默认检验项目检测结果全字段
|
||
selectStr: [], //信息全字段--选择
|
||
selectStr2: [],//检验项目检测结果全字段--选择
|
||
numStr: 0,//导出显示
|
||
}
|
||
},
|
||
mounted() {
|
||
|
||
|
||
},
|
||
methods: {
|
||
//显示进度内容
|
||
addNote(str) {
|
||
var aData = new Date().toLocaleString();
|
||
this.textarea = aData + " " + str + '\r\n' + this.textarea;
|
||
},
|
||
search(val) {//查询导出
|
||
|
||
var _this = this; //this指向vue
|
||
|
||
var dT = _this.ruleData;
|
||
var HaveWhere = false
|
||
let sqlstr = "";
|
||
var kuohaoNum = 0;
|
||
var kuohaoI = 1;
|
||
dT.forEach(function (item, index) {
|
||
var lianjieleixing = " ";
|
||
if (HaveWhere)//已有筛选条件 则将传来的 And OR 添加到查询语句
|
||
{
|
||
lianjieleixing = item.fangshi;
|
||
}
|
||
|
||
HaveWhere = true;//进入循环 则立刻变为 有 筛选条件
|
||
|
||
|
||
var shuxingmingE = ""//"mytext": "年份", "PY": "RWNF"
|
||
_this.Myjson.forEach(function (item2, index) {
|
||
if (item2.mytext == item.leibie) {
|
||
shuxingmingE = item2.PY;
|
||
}
|
||
})
|
||
let tiaojianzhi = item.neirong;
|
||
let yunxuanfu = item.tiaojian;
|
||
switch (yunxuanfu) {
|
||
case "(":
|
||
if (sqlstr.length) {
|
||
sqlstr = sqlstr + " and " + yunxuanfu + " ";
|
||
} else {
|
||
sqlstr = sqlstr + yunxuanfu + " ";
|
||
}
|
||
|
||
kuohaoNum = 1;
|
||
kuohaoI = 0;
|
||
//console.log("222", kuohaoNum);
|
||
break;
|
||
case ")":
|
||
sqlstr = sqlstr + yunxuanfu + " ";
|
||
kuohaoNum = 2;
|
||
break;
|
||
case "包含":
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" like '%" + tiaojianzhi + "%' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" like '%" + tiaojianzhi + "%' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" like '%" + tiaojianzhi + "%' ";
|
||
}
|
||
break;
|
||
case "不包含":
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" not like '%" + tiaojianzhi + "%' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" not like '%" + tiaojianzhi + "%' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" not like '%" + tiaojianzhi + "%' ";
|
||
}
|
||
|
||
break;
|
||
case "等于":
|
||
if (shuxingmingE != "jcz") {
|
||
//console.log("1");
|
||
if (kuohaoNum == 1) {
|
||
//console.log("11");
|
||
if (kuohaoI == 0) {
|
||
//console.log("111");
|
||
sqlstr += " \"" + shuxingmingE + "\" = '" + tiaojianzhi + "' ";
|
||
} else {
|
||
//console.log("1111");
|
||
sqlstr += " or \"" + shuxingmingE + "\" = '" + tiaojianzhi + "' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
//console.log("11111", kuohaoNum);
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" = '" + tiaojianzhi + "' ";
|
||
}
|
||
|
||
}
|
||
else {
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" = " + tiaojianzhi + " ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" = " + tiaojianzhi + " ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" = " + tiaojianzhi + " ";
|
||
}
|
||
}
|
||
break;
|
||
case "不等于":
|
||
if (shuxingmingE != "jcz") {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" <> '" + tiaojianzhi + "' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" <> '" + tiaojianzhi + "' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" <> '" + tiaojianzhi + "' ";
|
||
}
|
||
}
|
||
else {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" <> " + tiaojianzhi + " ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" <> " + tiaojianzhi + " ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" <> " + tiaojianzhi + " ";
|
||
}
|
||
}
|
||
break;
|
||
case "大于":
|
||
if (shuxingmingE != "jcz") {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" > '" + tiaojianzhi + "' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" > '" + tiaojianzhi + "' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" > '" + tiaojianzhi + "' ";
|
||
}
|
||
}
|
||
else {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" > " + tiaojianzhi + " ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" > " + tiaojianzhi + " ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" > " + tiaojianzhi + " ";
|
||
}
|
||
}
|
||
break;
|
||
case "小于":
|
||
if (shuxingmingE != "jcz") {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" < '" + tiaojianzhi + "' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" < '" + tiaojianzhi + "' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" < '" + tiaojianzhi + "' ";
|
||
}
|
||
}
|
||
else {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" < " + tiaojianzhi + " ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" < " + tiaojianzhi + " ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" < " + tiaojianzhi + " ";
|
||
}
|
||
}
|
||
break;
|
||
case "大于等于":
|
||
if (shuxingmingE != "jcz") {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" >= '" + tiaojianzhi + "' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" >= '" + tiaojianzhi + "' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" >= '" + tiaojianzhi + "' ";
|
||
}
|
||
}
|
||
else {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" >= " + tiaojianzhi + " ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" >= " + tiaojianzhi + " ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" >= " + tiaojianzhi + " ";
|
||
}
|
||
}
|
||
break;
|
||
case "小于等于":
|
||
if (shuxingmingE != "jcz") {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\" <= '" + tiaojianzhi + "' ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\" <= '" + tiaojianzhi + "' ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"" + shuxingmingE + "\" <= '" + tiaojianzhi + "' ";
|
||
}
|
||
}
|
||
else {
|
||
|
||
if (kuohaoNum == 1) {
|
||
if (kuohaoI == 0) {
|
||
sqlstr += " \"" + shuxingmingE + "\"\" <= " + tiaojianzhi + " ";
|
||
} else {
|
||
sqlstr += " or \"" + shuxingmingE + "\"\" <= " + tiaojianzhi + " ";
|
||
}
|
||
kuohaoI++;
|
||
} else {
|
||
sqlstr += lianjieleixing + " \"\"" + shuxingmingE + "\"\" <= " + tiaojianzhi + " ";
|
||
}
|
||
}
|
||
break;
|
||
}
|
||
|
||
|
||
})
|
||
|
||
var str = "";
|
||
var dT2 = _this.selectStr;
|
||
dT2.forEach(function (item, index) {
|
||
str = str + _this.strFunction(item) + ",";
|
||
})
|
||
var str2 = "";
|
||
var dT3 = _this.selectStr2;
|
||
dT3.forEach(function (item, index) {
|
||
str2 = str2 + _this.strFunction(item) + ",";
|
||
})
|
||
str = str.substring(0, str.length - 1);
|
||
str2 = str2.substring(0, str2.length - 1);
|
||
if (str == "") {
|
||
str = _this.moRenStr
|
||
}
|
||
if (str2 == "") {
|
||
str2 = _this.moRenStr2
|
||
}
|
||
|
||
//这一块重新改写成前端进行各个接口操作，并且在服务端生成相应的文件可供下载的方式
|
||
|
||
//定义当前的服务端文件名称；
|
||
let curFileName="";
|
||
let strTemp="";
|
||
let strHeadAll="";
|
||
let strFixHeadTable="";
|
||
let strFixHeadField="";
|
||
let strSelectedConvertTable="";
|
||
let strSelectedConvertField="";
|
||
|
||
let arrLSH=[];
|
||
|
||
//对应服务端的方法
|
||
const ProjectInit=async ()=>{
|
||
return await axios.get('../HangLieConvert/ProjectInit')
|
||
}
|
||
|
||
//获取头部的表格
|
||
// encodeURIComponent(sqlstr)
|
||
const GetCSVHeader=async()=>{
|
||
return await axios.post('../HangLieConvert/GetCSVHeader',
|
||
{
|
||
'filename':curFileName,
|
||
'header1':str,
|
||
'header2':str2,
|
||
'strsql':sqlstr
|
||
})
|
||
}
|
||
|
||
//获取有多少的数据需要行列转换
|
||
const GetCVSRows=async()=>{
|
||
return await axios.post('../HangLieConvert/GetCVSRows',
|
||
{
|
||
strsql:sqlstr
|
||
})
|
||
}
|
||
|
||
//获取每一条数据,移动到方法体内部使用
|
||
const GetCVSRow=async (curLSH)=>{
|
||
var curUrl='../HangLieConvert/GetCVSRow?filename='+ curFileName +
|
||
'&strTemp=' + strTemp +
|
||
'&strHeadAll=' + strHeadAll +
|
||
'&strFixHeadField=' + strFixHeadField +
|
||
'&strSelectedConvertField=' + strSelectedConvertField +
|
||
'&curLSH=' + curLSH +
|
||
'&strsql' + encodeURIComponent(strsql)
|
||
var curpostData={
|
||
filename:curFileName,
|
||
strTemp:strTemp,
|
||
strHeadAll:strHeadAll,
|
||
strFixHeadField:strFixHeadField,
|
||
strSelectedConvertField:strFixHeadField,
|
||
curLSH:curLSH,
|
||
strsql:encodeURIComponent(strsql)
|
||
}
|
||
return await axios.post('../HangLieConvert/GetCVSRow',curpostData)
|
||
}
|
||
|
||
//增加一个下载文件的方法
|
||
const downloadHLZHFile=()=> {
|
||
setTimeout(function(){
|
||
window.open(
|
||
'../data/hlzh/' + curFileName,
|
||
'_self'
|
||
);
|
||
},10000);
|
||
|
||
}
|
||
//对应服务端的方法完成
|
||
|
||
|
||
ProjectInit().then(res=>{
|
||
curFileName=res.data
|
||
console.log('dT1',curFileName)
|
||
this.addNote("初始化文件"+curFileName+"成功,开始进行表头字段整理")
|
||
//开始获取头部的表格字段
|
||
GetCSVHeader().then(res=>{
|
||
console.log('dT2',res)
|
||
strFixHeadField=res.data.arrFixHeadField.join(',');
|
||
strFixHeadTable=res.data.arrFixHeadTable.join(',');
|
||
strHeadAll=res.data.arrHeadAll.join(',');
|
||
strSelectedConvertField=res.data.arrSelectedConvertField.join(',');
|
||
strSelectedConvertTable=res.data.arrSelectedConvertTable.join(',');
|
||
strTemp=res.data.strTemp;
|
||
this.addNote("获取表头字段成功,共有" + res.data.arrHeadAll.length + "个字段，开始进行数据转换数据集收集")
|
||
//开始获取多少流水号需要进行行转换
|
||
GetCVSRows().then(res=>{
|
||
console.log('dT3',res)
|
||
this.addNote("数据转换数据集收集成功,共有" +res.data.count + "条流水号数据进行行列转换操作，开始进行数据转换")
|
||
arrLSH=res.data.data;
|
||
console.log('arrLSH',arrLSH);
|
||
|
||
(async()=>{
|
||
console.log('arrLSH.length',arrLSH.length)
|
||
console.log('sqlstr',sqlstr)
|
||
for (var i = 0; i < arrLSH.length; i++) {
|
||
|
||
// var curUrl='../HangLieConvert/GetCVSRow?filename='+ curFileName +
|
||
// '&strTemp=' + strTemp +
|
||
// '&strHeadAll=' + strHeadAll +
|
||
// '&strFixHeadField=' + strFixHeadField +
|
||
// '&strSelectedConvertField=' + strSelectedConvertField +
|
||
// '&curLSH=' + arrLSH[i].toString() +
|
||
// '&strsql=' + encodeURIComponent(sqlstr)
|
||
var curpostData={
|
||
filename:curFileName,
|
||
strTemp:strTemp,
|
||
strHeadAll:strHeadAll,
|
||
strFixHeadField:strFixHeadField,
|
||
strSelectedConvertField:strSelectedConvertField,
|
||
curLSH:arrLSH[i].toString(),
|
||
strsql:sqlstr
|
||
}
|
||
await axios.post('../HangLieConvert/GetCVSRow',curpostData).then(res=>{
|
||
this.addNote("开始转换流水号为" + arrLSH[i].toString()+ "的数据集,进度" + (i+1).toString() + "/" + arrLSH.length + "条进行操作")
|
||
})
|
||
|
||
}
|
||
this.addNote("行列转换操作顺利完成，开始下载文件")
|
||
|
||
downloadHLZHFile();
|
||
})();
|
||
})
|
||
})
|
||
})
|
||
|
||
//第一步，先申请一个文件可供服务端写的唯一id编号
|
||
|
||
//第二步，先生成表头
|
||
|
||
//第三步，获取所有的rows的数据
|
||
|
||
//第四步，进行循环生成
|
||
|
||
|
||
|
||
|
||
},
|
||
|
||
|
||
downloadFunction(id2) { //下载
|
||
var _this = this; //this指向vue
|
||
axios.get('./home/getRanks?id=' + id2).then(function (res) {
|
||
//console.log(res);
|
||
if (res.data.state == 1) {
|
||
_this.numStr = 2
|
||
window.location.href = '/home/exportExcel?addr=' + res.data.url;
|
||
} else {
|
||
setTimeout(() => {
|
||
_this.downloadFunction(id2);
|
||
}, 1000)
|
||
}
|
||
})
|
||
.catch(function (err) {
|
||
console.log(err);
|
||
});
|
||
|
||
},
|
||
strFunction(a) { //字符串格式调整
|
||
b = a.replace(",", "，").replace("(", "（").replace(")", "）").replace("\r", "").replace("\n", "");
|
||
return a;
|
||
},
|
||
//括号新增
|
||
kuoHaoFuntion(a) {
|
||
//this.ruleForm.fangshi = a;
|
||
var dT = {
|
||
leibie: "",
|
||
tiaojian: a,
|
||
neirong: "",
|
||
fangshi: ""
|
||
};
|
||
this.ruleData.push(dT);
|
||
},
|
||
//组合查询条件
|
||
btnFuntion(a) {
|
||
|
||
this.ruleForm.fangshi = a;
|
||
|
||
var dT = {
|
||
leibie: this.ruleForm.leibie,
|
||
tiaojian: this.ruleForm.tiaojian,
|
||
neirong: this.ruleForm.neirong,
|
||
fangshi: this.ruleForm.fangshi
|
||
};
|
||
this.ruleData.push(dT);
|
||
//console.log(this.ruleData);
|
||
},
|
||
//删除组合查询
|
||
deleteFunction(a) {
|
||
var aa = this.ruleData.indexOf(a);
|
||
this.ruleData.splice(aa, 1);
|
||
},
|
||
// test() {
|
||
// notify();
|
||
// }
|
||
}
|
||
})
|
||
|
||
</script>
|
||
<style>
|
||
.el-drawer {
|
||
height: 500px;
|
||
}
|
||
</style>
|