1147 lines
37 KiB
JavaScript
1147 lines
37 KiB
JavaScript
/// <reference path="C:\Users\Administrator\Desktop\WEI.UIPro\WEI.UIPro20160726\WEI.UIPro\WEI.UIPro\WEI.UIPro\Scripts/linq.js" />
|
||
|
||
|
||
/**************************折线图******************************/
|
||
app.controller('ShiPinShengChanJingYingXuKeCtrl', ['$scope', 'YPJBXXGL', '$uibModal', '$sessionStorage', '$state', '$http', '$filter', 'mainUrl', 'wyOdataNodeService', 'stConfig', '$timeout', function ($scope, YPJBXXGL, $uibModal, $sessionStorage, $state, $http, $filter, mainUrl, wyOdataNodeService, stConfig, $timeout, $uibModalInstance, item) {
|
||
|
||
|
||
//$scope.openPiLiangShanChuChongFu = function () {
|
||
// var index = layer.open({
|
||
// type: 2,
|
||
// content: '../piliangshanchuchongfu.html',
|
||
// area: ['320px', '195px'],
|
||
// maxmin: true
|
||
// });
|
||
// layer.full(index);
|
||
//}
|
||
|
||
|
||
var OldThreeData;
|
||
//新增加的20230527
|
||
//修改数据方法
|
||
$scope.ValueEdit = function (item) {
|
||
//console.log('新方法的值', item);
|
||
//OldThreeData = item;
|
||
$scope.FormData = item;
|
||
}
|
||
|
||
$scope.SaveData = function () {
|
||
//UpdateData
|
||
$http.get('./ShiPinShengChan/UpdateData?data=' + JSON.stringify($scope.FormData), {}).success(function (res) {
|
||
|
||
|
||
console.log('获取结果', res);
|
||
dLayer.msg("修改完成")
|
||
|
||
})
|
||
|
||
}
|
||
|
||
|
||
//替换方法
|
||
$scope.PiLiangTiHuan = function () {
|
||
//新的打开替换的方法
|
||
dLayer.open({
|
||
type: 2,
|
||
area: ['1200px', '700px'],
|
||
content: '../tihuan_shipinshengchan.html'
|
||
});
|
||
}
|
||
|
||
|
||
|
||
|
||
|
||
$scope.SaveThreeValueByID = function () {
|
||
$http.get("../strreplace/ReplaceThreeData?jc_id=" + $scope.ThreeData.JC_id + "&JCXM=" + $scope.ThreeData.JCXM + "&JCBZ=" + $scope.ThreeData.JCBZ + "&jczbz=" + $scope.ThreeData.jczbz + "&jcz=" + $scope.ThreeData.jcz + "&jczDW=" + $scope.ThreeData.jczDW).success(function (res) {
|
||
console.log('结果展示', res);
|
||
if (res.data != null && res.data != "") {
|
||
console.log('结果判断', res.data);
|
||
//刷新页面
|
||
console.log("三值修改", "从" + JSON.stringify($scope.OldThreeData) + "修改为" + JSON.stringify($scope.ThreeData))
|
||
//写日志
|
||
addlog("三值修改", "ID[" + OldThreeData.JC_id +
|
||
"]从[" + OldThreeData.JCBZ + "|" +
|
||
OldThreeData.jcz + "|" +
|
||
OldThreeData.jczDW + "]修改为[" +
|
||
$scope.ThreeData.JCBZ + "|" +
|
||
$scope.ThreeData.jcz + "|" +
|
||
$scope.ThreeData.jczDW + "]")
|
||
|
||
$scope.ChaXun();
|
||
dLayer.msg('更新成功,刷新页面')
|
||
}
|
||
})
|
||
}
|
||
|
||
|
||
$scope.GOjc = function (id, CYDBH) {
|
||
//$state.go("app.SampleTest", { id: id, CYDBH: CYDBH });
|
||
dLayer.open({
|
||
type: 2,
|
||
area: ['1200px', '700px'],
|
||
content: '../index.html#/SampleTestdialog/' + id + '/' + CYDBH
|
||
});
|
||
}
|
||
|
||
$scope.myttt = "等待查询结果";
|
||
$scope.Myjson = [
|
||
{ "type": 1, "mytext": "许可证编号", "PY": "XKZBH" },
|
||
{ "type": 1, "mytext": "有效期起", "PY": "YXQQ" },
|
||
{ "type": 1, "mytext": "有效期止", "PY": "YXQZ" },
|
||
{ "type": 1, "mytext": "经营者名称", "PY": "JYZMC" },
|
||
{ "type": 1, "mytext": "经营场所地址", "PY": "JYCS" },
|
||
{ "type": 1, "mytext": "统一社会信用代码", "PY": "SHXYDM" },
|
||
{ "type": 1, "mytext": "发证机构名称", "PY": "FZJGMC" },
|
||
{ "type": 1, "mytext": "企业所在区", "PY": "AREA_ID" },
|
||
{ "type": 1, "mytext": "注销日期", "PY": "ZXRQ" },
|
||
//证书状态,XKZZT
|
||
{ "type": 1, "mytext": "证书状态", "PY": "XKZZT" },
|
||
//环节增加,HUANJIE
|
||
{ "type": 1, "mytext": "环节", "PY": "HUANJIE" },
|
||
//主体业态
|
||
{ "type": 1, "mytext": "主体业态", "PY": "ZTYTMC" },
|
||
|
||
|
||
|
||
|
||
|
||
];
|
||
|
||
//、定性值、限量值、限量值单位、检测值、检测值单位、判定
|
||
$scope.Myjson1 = [
|
||
{ "myvalue": 1, "mytext": "等于" },
|
||
{ "myvalue": 7, "mytext": "不等于" },
|
||
{ "myvalue": 2, "mytext": "包含" },
|
||
{ "myvalue": 8, "mytext": "不包含" },
|
||
{ "myvalue": 3, "mytext": "大于" },
|
||
{ "myvalue": 4, "mytext": "小于" },
|
||
{ "myvalue": 5, "mytext": "大于等于" },
|
||
{ "myvalue": 6, "mytext": "小于等于" },
|
||
]
|
||
|
||
var shipinleibieshuju = [
|
||
];
|
||
//加载所有 的食品分类
|
||
//加载所有 的食品分类
|
||
var shipinleibieshuju = {};
|
||
//$http.get(mongoApi, {}).success(function (Ldata) {
|
||
// //alert(Ldata.Data.name);
|
||
// shipinleibieshuju = angular.fromJson(Ldata.Data.name);
|
||
//});
|
||
//加载所有 的检测项目分类
|
||
var jiancexiangmu = {};
|
||
$http.get(pubserver + "JCXM_DB", {}).success(function (Ldata) {
|
||
//alert(Ldata.Data.name);
|
||
jiancexiangmu = angular.fromJson(Ldata.value);
|
||
});
|
||
|
||
|
||
|
||
function add0(m) { return m < 10 ? '0' + m : m }
|
||
function format(shijianchuo) {
|
||
//shijianchuo是整数，否则要parseInt转换
|
||
var time = new Date(shijianchuo);
|
||
var y = time.getFullYear();
|
||
var m = time.getMonth() + 1;
|
||
var d = time.getDate();
|
||
//var h = time.getHours();
|
||
//var mm = time.getMinutes();
|
||
//var s = time.getSeconds();
|
||
return y + '/' + add0(m) + '/' + add0(d);// + ' ' + add0(h) + ':' + add0(mm) + ':' + add0(s);
|
||
}
|
||
|
||
|
||
|
||
/***********************样品综合查询**************************/
|
||
//添加条件
|
||
$scope.TJTable = [];
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = true;
|
||
$scope.addTJ = function (tjtype) {
|
||
if ($scope.TJTable.length <= 0) {
|
||
tjtype = "";
|
||
}
|
||
if (!$scope.isdate) {
|
||
var str = $("#dept").val();
|
||
if (str != "? undefined:undefined ?") {
|
||
$scope.mytxt = str;
|
||
}
|
||
var aa = {
|
||
"lianjietype": tjtype,
|
||
"CXTJPY": $scope.mysel.PY,
|
||
"CXTJ": $scope.mysel.mytext,
|
||
"CXLX": $scope.mysel1.mytext,
|
||
"CXLXid": $scope.mysel1.myvalue,
|
||
"CXNR": $scope.mytxt,
|
||
}
|
||
if (aa.CXTJ == "选择" || aa.CXLX == "选择" || (str == "" && $scope.RWLYSHOW)) {
|
||
return;
|
||
}
|
||
//console.log(aa);
|
||
var myll = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == aa.CXTJ && x.CXLX == aa.CXLX && x.CXNR == aa.CXNR }).ToArray();
|
||
if (myll.length > 0) {
|
||
alert("您已经添加过此条件");
|
||
} else {
|
||
$scope.TJTable.push(aa);
|
||
//$scope.TJTable = Enumerable.From($scope.TJTable).ToArray();
|
||
|
||
//console.log(angular.toJson($scope.TJTable));
|
||
}
|
||
} else {
|
||
var kaishishijian = format($scope.datebegin);
|
||
var jieshushijian = format($scope.dateend);
|
||
var aa1 = {
|
||
"lianjietype": tjtype,
|
||
"CXTJPY": $scope.mysel.mytext == "执行年月" ? "ZXNY_KS" : $scope.mysel.PY,
|
||
"CXTJ": $scope.mysel.mytext == "执行年月" ? "执行年月开始" : $scope.mysel.mytext,
|
||
"CXLX": "大于等于",
|
||
"CXLXid": 5,
|
||
"CXNR": kaishishijian,
|
||
}
|
||
var aa2 = {
|
||
"lianjietype": "and",
|
||
"CXTJPY": $scope.mysel.mytext == "执行年月" ? "ZXNY_JS" : $scope.mysel.PY,
|
||
"CXTJ": $scope.mysel.mytext == "执行年月" ? "执行年月结束" : $scope.mysel.mytext,
|
||
"CXLX": "小于等于",
|
||
"CXLXid": 6,
|
||
"CXNR": jieshushijian,
|
||
}
|
||
$scope.TJTable.push(aa1);
|
||
$scope.TJTable.push(aa2);
|
||
//$scope.TJTable = Enumerable.From($scope.TJTable).ToArray();
|
||
}
|
||
|
||
}
|
||
//删除条件
|
||
$scope.deleteTJ = function (index) {
|
||
var aa = $scope.TJTable.indexOf(index);
|
||
$scope.TJTable.splice(aa, 1);
|
||
}
|
||
|
||
//改变事件
|
||
$scope.MyjsonChange = function () {
|
||
$scope.RELYdata = [];
|
||
$scope.myselpublic = undefined;
|
||
$scope.mytxt = "";
|
||
switch ($scope.mysel.PY) {
|
||
/////////////////////////////////////////////////最新食品分类(以2016年为准)//////////////////////////////////////////////////
|
||
case "SP_DL":
|
||
|
||
|
||
$scope.RELYdata = [];
|
||
var dldata = Enumerable.From(shipinleibieshuju).Select(function (a) { return a.spdlName }).ToArray();
|
||
$scope.RELYdata.push({ "mytext": "" + dldata[0] + "", "PY": "GJZJ" })
|
||
for (var i1 = 1; i1 < dldata.length; i1++) {
|
||
$scope.RELYdata.push({ "mytext": "" + dldata[i1] + "", "PY": "SHZJ" })
|
||
}
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
|
||
break;
|
||
case "SP_YL":
|
||
$scope.RELYdata = [];
|
||
//查看是否已选择 食品大类
|
||
var shangjixinxi1 = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品大类" }).FirstOrDefault();
|
||
if (shangjixinxi1) {
|
||
var yldatas = Enumerable.From(shipinleibieshuju).Where(function (x) { return x.spdlName == shangjixinxi1.CXNR }).Select(function (a) { return a.spylName }).ToArray();
|
||
for (var i2 = 0; i2 < yldatas.length; i2++) {
|
||
var yldata = Enumerable.From(yldatas[i2]).Select(function (a) { return a.spylName }).ToArray();
|
||
for (var i3 = 0; i3 < yldata.length; i3++) {
|
||
$scope.RELYdata.push({ "mytext": "" + yldata[i3] + "", "PY": "SHZJ" })
|
||
}
|
||
|
||
}
|
||
} else {
|
||
var yldatas = Enumerable.From(shipinleibieshuju).Select(function (a) { return a.spylName }).ToArray();
|
||
for (var i2 = 0; i2 < yldatas.length; i2++) {
|
||
var yldata = Enumerable.From(yldatas[i2]).Select(function (a) { return a.spylName }).ToArray();
|
||
for (var i3 = 0; i3 < yldata.length; i3++) {
|
||
$scope.RELYdata.push({ "mytext": "" + yldata[i3] + "", "PY": "SHZJ" })
|
||
}
|
||
|
||
}
|
||
}
|
||
|
||
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "SP_PZ":
|
||
$scope.RELYdata = [];
|
||
//查看是否已选择 食品大类
|
||
var shangjixinxi2 = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品大类" }).FirstOrDefault();
|
||
//查看是否已选择 食品亚类
|
||
var shangjixinxi3 = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品亚类" }).FirstOrDefault();
|
||
var yldatas = Enumerable.From(shipinleibieshuju).ToArray();
|
||
if (shangjixinxi2) {
|
||
yldatas = Enumerable.From(yldatas).Where(function (x) { return x.spdlName == shangjixinxi2.CXNR }).Select(function (a) { return a.spylName }).ToArray();
|
||
} else {
|
||
yldatas = Enumerable.From(yldatas).Select(function (a) { return a.spylName }).ToArray();
|
||
}
|
||
|
||
for (var i2 = 0; i2 < yldatas.length; i2++) {
|
||
var zldatas = Enumerable.From(yldatas[i2]).Where(function (a) { return !shangjixinxi3 ? true : a.spylName == shangjixinxi3.CXNR }).Select(function (a) { return a.spzlName }).ToArray();
|
||
for (var i3 = 0; i3 < zldatas.length; i3++) {
|
||
var zldata = Enumerable.From(zldatas[i3]).Select(function (a) { return a.spzlNames }).ToArray();
|
||
for (var i4 = 0; i4 < zldata.length; i4++) {
|
||
$scope.RELYdata.push({ "mytext": "" + zldata[i4] + "", "PY": "SHZJ" })
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
|
||
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "SP_XL":
|
||
$scope.RELYdata = [];
|
||
//查看是否已选择 食品大类
|
||
var shangjixinxi2 = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品大类" }).FirstOrDefault();
|
||
//查看是否已选择 食品亚类
|
||
var shangjixinxi3 = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品亚类" }).FirstOrDefault();
|
||
//查看是否已选择 食品品种
|
||
var shangjixinxi4 = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品品种" }).FirstOrDefault();
|
||
|
||
|
||
var yldatas = Enumerable.From(shipinleibieshuju).Where(function (x) { return !shangjixinxi2 ? true : x.spdlName == shangjixinxi2.CXNR }).Select(function (a) { return a.spylName }).ToArray();
|
||
for (var i2 = 0; i2 < yldatas.length; i2++) {
|
||
var zldatas = Enumerable.From(yldatas[i2]).Where(function (a) { return !shangjixinxi3 ? true : a.spylName == shangjixinxi3.CXNR }).Select(function (a) { return a.spzlName }).ToArray();
|
||
for (var i3 = 0; i3 < zldatas.length; i3++) {
|
||
var xldatas = Enumerable.From(zldatas[i3]).Where(function (a) { return !shangjixinxi4 ? true : a.spzlNames == shangjixinxi4.CXNR }).Select(function (a) { return a.spxlNames }).ToArray();
|
||
for (var i4 = 0; i4 < xldatas.length; i4++) {
|
||
for (var i5 = 0; i5 < xldatas[i4].length; i5++) {
|
||
$scope.RELYdata.push({ "mytext": "" + xldatas[i4][i5] + "", "PY": "SHZJ" })
|
||
}
|
||
}
|
||
|
||
}
|
||
|
||
}
|
||
|
||
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
////////////////////////////////////////////////////////////////////////////////////////////////////////////
|
||
case "ZXNY":
|
||
|
||
$scope.isdate = true;
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "SCJGGJRQ":
|
||
$scope.isdate = true;
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "YPJZRQ":
|
||
$scope.isdate = true;
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "BCYDWSJ":
|
||
$scope.isdate = true;
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "CYSJ":
|
||
$scope.isdate = true;
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
|
||
|
||
|
||
//检测类型
|
||
case "RWLX":
|
||
$scope.RELYdata = [
|
||
{ "mytext": "风险监测", "PY": "GJZJ" },
|
||
{ "mytext": "监督抽检", "PY": "SHZJ" },
|
||
{ "mytext": "评价性抽检", "PY": "SHZJ" },
|
||
];
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
//抽样方式
|
||
case "CYFS":
|
||
$scope.RELYdata = [
|
||
{ "mytext": "无菌抽样", "PY": "GJZJ" },
|
||
{ "mytext": "非无菌抽样", "PY": "SHZJ" }
|
||
];
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
|
||
//样品型态
|
||
case "YPXT":
|
||
$scope.RELYdata = [
|
||
{ "mytext": "固体", "PY": "GJZJ" },
|
||
{ "mytext": "半固体", "PY": "SHZJ" },
|
||
{ "mytext": "液体", "PY": "SHZJ" },
|
||
{ "mytext": "气体", "PY": "SHZJ" }
|
||
];
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
case "JieGuo":
|
||
//合格，不合格，问题，不作评价，不合格 / 问题
|
||
$scope.RELYdata = [
|
||
{ "mytext": "合格", "PY": "GJZJ" },
|
||
{ "mytext": "不合格", "PY": "SHZJ" },
|
||
{ "mytext": "不作评价", "PY": "SHZJ" },
|
||
{ "mytext": "问题", "PY": "SHZJ" },
|
||
{ "mytext": "不合格/问题", "PY": "SHZJ" }
|
||
];
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
|
||
//常规监测、专项监测、应急监测、监督抽检/专项抽检、应急抽检、常规抽检
|
||
case "RWXZ":
|
||
$scope.RELYdata = [
|
||
{ "mytext": "常规监测", "PY": "GJZJ" },
|
||
{ "mytext": "专项监测", "PY": "SHZJ" },
|
||
{ "mytext": "应急监测", "PY": "SHZJ" },
|
||
{ "mytext": "监督抽检", "PY": "SHZJ" },
|
||
{ "mytext": "专项抽检", "PY": "SHZJ" },
|
||
{ "mytext": "应急抽检", "PY": "SHZJ" },
|
||
{ "mytext": "常规抽检", "PY": "SHZJ" },
|
||
];
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
|
||
//抽样方式
|
||
case "HUANJIE":
|
||
$scope.RELYdata = [
|
||
{ "mytext": "生产环节", "PY": "GJZJ" },
|
||
{ "mytext": "餐饮环节", "PY": "GJZJ" },
|
||
{ "mytext": "销售环节", "PY": "GJZJ" },
|
||
];
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = true;
|
||
$scope.SouSuoShow = false;
|
||
break;
|
||
|
||
////主体业态名称
|
||
//case "ZTYTMC":
|
||
// $scope.RELYdata = [
|
||
// { "mytext": "生产环节", "PY": "GJZJ" },
|
||
// { "mytext": "餐饮环节", "PY": "GJZJ" },
|
||
// { "mytext": "销售环节", "PY": "GJZJ" },
|
||
// ];
|
||
// $scope.isdate = false;
|
||
// $scope.RWLYSHOW = true;
|
||
// $scope.SouSuoShow = false;
|
||
// break;
|
||
|
||
|
||
|
||
|
||
default:
|
||
$scope.isdate = false;
|
||
$scope.RWLYSHOW = false;
|
||
$scope.SouSuoShow = true;
|
||
}
|
||
|
||
$timeout(function () {
|
||
$("#dept").trigger("chosen:updated");
|
||
}, 100, false);
|
||
|
||
}
|
||
|
||
|
||
/////*******************总的查询*****************/
|
||
|
||
$scope.wherestr = "";
|
||
|
||
|
||
$scope.ChaXun = function () {
|
||
|
||
var wherestr = angular.toJson($scope.TJTable);
|
||
if ($scope.TJTable.length <= 0) {
|
||
wherestr = "";
|
||
}
|
||
wherestr = wherestr.replace('+', '%2B');
|
||
console.log(wherestr);
|
||
$scope.wherestr = wherestr;
|
||
$scope.tableState.pagination.start = 0;
|
||
$scope.getService($scope.tableState, null);
|
||
|
||
//增加日志20211109
|
||
addlog("SQL查询", "查询[" + wherestr + "]")
|
||
}
|
||
$("#delete").hide();
|
||
$("#delete2").hide();
|
||
$("#tihuan").hide();
|
||
var Uname = sessionStorage.getItem('userName');
|
||
if (Uname == 'yushenghao') {
|
||
$("#delete").show();
|
||
$("#delete2").show();
|
||
$("#tihuan").show();
|
||
}
|
||
|
||
//导出表头集合
|
||
$scope.dictData = [
|
||
|
||
{
|
||
"TableName": "主键",
|
||
"FieldName": "ID"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "关联ID",
|
||
"FieldName": "SQID"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "申请事项代码",
|
||
"FieldName": "SQSXDM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "许可证编号",
|
||
"FieldName": "XKZBH"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "发证机构",
|
||
"FieldName": "FZJG"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "有效期起",
|
||
"FieldName": "YXQQ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "有效期止",
|
||
"FieldName": "YXQZ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "经营者名称",
|
||
"FieldName": "JYZMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "经营场所地址",
|
||
"FieldName": "JYCS"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "住所地址",
|
||
"FieldName": "ZS"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "法定代表人，负责人",
|
||
"FieldName": "FDDBR_FZR"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "统一社会信用代码",
|
||
"FieldName": "SHXYDM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "主体业态",
|
||
"FieldName": "ZTYT"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "经营项目",
|
||
"FieldName": "JYXM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "日常监管机构",
|
||
"FieldName": "RCJGJG"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "日常监管人员",
|
||
"FieldName": "RCJGRY"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "签发人",
|
||
"FieldName": "QFR"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "签发时间",
|
||
"FieldName": "QFSJ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "证书状态",
|
||
"FieldName": "XKZZT"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "证书类型",
|
||
"FieldName": "ZSZL"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "注销日期",
|
||
"FieldName": "ZXRQ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "失效日期",
|
||
"FieldName": "SXRQ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "食品类别",
|
||
"FieldName": "SPLB"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "所属省份",
|
||
"FieldName": "SSSF"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "所属市",
|
||
"FieldName": "SSS"
|
||
},
|
||
|
||
|
||
// {
|
||
// "TableName": "所属区县",
|
||
// "FieldName": "AREA_ID"
|
||
// },
|
||
|
||
|
||
{
|
||
"TableName": "所在街镇",
|
||
"FieldName": "JYCSJD"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "生产产品类别编码",
|
||
"FieldName": "SCCPLBBM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "小类名称",
|
||
"FieldName": "SQSXMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "证照类型",
|
||
"FieldName": "ZZLX"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "法人中文名",
|
||
"FieldName": "FRMC_ZW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "法人英文名",
|
||
"FieldName": "FRMC_YW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "注册地址中文",
|
||
"FieldName": "ZCDZ_ZW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "注册地址英文",
|
||
"FieldName": "ZCDZ_YW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "生产地址中文",
|
||
"FieldName": "SCDZ_ZW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "生产地址英文",
|
||
"FieldName": "SCDZ_YW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "产品范围类别",
|
||
"FieldName": "CPFWLB"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "产品范围中文",
|
||
"FieldName": "CPFW_ZW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "产品范围英文",
|
||
"FieldName": "CPFW_YW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "创建时间",
|
||
"FieldName": "CJSJ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "更新时间",
|
||
"FieldName": "GXSJ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "许可证唯一ID",
|
||
"FieldName": "XKZWYID"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "申请产品类别",
|
||
"FieldName": "SQCPLB"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "是否食品贮存",
|
||
"FieldName": "SFSPZC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "食品贮存详情",
|
||
"FieldName": "SPZCXQ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "是否食品运输",
|
||
"FieldName": "SFSPYS"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "食品运输详情",
|
||
"FieldName": "SPYSXQ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "证件号码",
|
||
"FieldName": "ZJHM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "网站名称",
|
||
"FieldName": "WZMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "域名",
|
||
"FieldName": "YM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "发证机关机构代码",
|
||
"FieldName": "DWDM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "变更内容",
|
||
"FieldName": "BGNR"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "新证老证",
|
||
"FieldName": "XZLZ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "经营项目代码",
|
||
"FieldName": "JYXMDM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "日常监管机构名称",
|
||
"FieldName": "RCJGJGMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "主体业态名称",
|
||
"FieldName": "ZTYTMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "受理机构名称",
|
||
"FieldName": "SLJGMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "发证机构名称",
|
||
"FieldName": "FZJGMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "注销原因",
|
||
"FieldName": "ZXYY"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "生产产品类别名称",
|
||
"FieldName": "SCCPLBMC"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "主体业态代码",
|
||
"FieldName": "ZTYTDM"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "集体用餐配送单位",
|
||
"FieldName": "JTYCPSDW"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "上海经营使用 一证多址",
|
||
"FieldName": "YZDZ"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "申请类型",
|
||
"FieldName": "SQLX"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "主体类型",
|
||
"FieldName": "ENTITY_TYPE"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "相关许可证号",
|
||
"FieldName": "RELATION_CODE"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "售卖类型",
|
||
"FieldName": "SALE_TYPE"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "主体类型名称",
|
||
"FieldName": "ENTITY_TYPE_NAME"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "食品许可证有效起日",
|
||
"FieldName": "CATER_START_TIME"
|
||
},
|
||
|
||
|
||
{
|
||
"TableName": "食品许可证有效止日",
|
||
"FieldName": "CATER_END_TIME"
|
||
},
|
||
|
||
{
|
||
"TableName": "所属区县",
|
||
"FieldName": "AREA_ID"
|
||
},
|
||
|
||
{
|
||
"TableName": "环节",
|
||
"FieldName": "HUANJIE"
|
||
},
|
||
|
||
|
||
|
||
];
|
||
|
||
//弹处窗口导出部分的全部选择
|
||
$scope.selectExportAll = function () {
|
||
var fruits = document.getElementsByName("dictName");
|
||
for (var i = 0; i < fruits.length; i++) {
|
||
fruits[i].checked = true;
|
||
}
|
||
}
|
||
//弹处窗口导出部分的取消全选
|
||
$scope.unselectExportAll = function () {
|
||
var fruits = document.getElementsByName("dictName");
|
||
for (var i = 0; i < fruits.length; i++) {
|
||
fruits[i].checked = false;
|
||
}
|
||
}
|
||
|
||
$scope.daochuData = [];
|
||
//$scope.selectDt = "抽样单编号,任务编号,流水号,任务来源,任务类型,任务年份,被抽样人信息名称,区域类型,被抽样单位省市自治区,被抽样单位县市区,地址街道镇,地址弄,地址号,地址室,被抽样单位地址,法人代表,年销售额,营业执照号,联系人,经营许可证,电话,传真,邮编,抽样地点,抽样地点类型,样品来源,样品属性,样品类型,样品名称,商标,生产加工购进日期,规格型号,样品批号,保质期,执行标准技术文件,质量等级,生产许可证编号,单价,是否出口,抽样基数批量,抽样数量含备样,备样数量,样品形态,包装分类,生产者名称,生产者地址省,生产者地址市,生产者地址区县,生产者地址,联系电话,标称样品储存条件,寄送样品截止日期,寄送样品地址,抽样样品包装,抽样方式,抽样单位信息单位名称,抽样单位信息地址,抽样单位信息联系人,抽样单位信息电话,抽样单位信息传真,抽样单位信息邮编,备注,被抽样单位签名,被抽样单位签名时间,抽样人,抽样单位,抽样人签名时间,检测机构,结论,原样品分类,样品分类,任务性质,第三方企业名称,第三方企业地址,第三方企业性质,第三方企业许可证编号,网络平台名称,网络平台营业执照号,网抽平台所在地省,平台地址,平台网址,网店网址,平台订单编号,温度,湿度,食品大类,食品亚类,食品品种,食品细类,执行年月开始,执行年月结束,报告书编号,原产地,是否进口,检验项目,原始检验项目,检测大类,检测亚类,检测小类,检验依据,检测方法,方法名称,检出限,检出限单位,定量限,定量限单位,判定依据,限量值,限量值单位,检验结果,检验结果备注,检测值单位,结果判定,国抽ID,被抽样单位地区(市、州、盟),单位,抽样工具,单位级别,收检日期,报告日期,电话(检验机构),电子邮箱(检验机构),抽样单位所在省份,保质期单位,报送分类2,报送分类1,生产企业联系人,备注(检验机构),样品状态,不合格报告上传时间,报告分类,许可证,是否委托生产,委托省(市、自治区)*,委托地区(市、州、盟),委托县(市、区),委托联系人,委托电话,入网许可证号或ICP经营许可证,网抽平台所在地市,网抽平台所在地县,平台联系人,平台联系电话,最小允许限*,最小允许限单位*,最大允许限,最大允许限单位,说明,数据来源ID,数据来源名称,国抽创建时间,国抽更新时间,检验信息创建时间,检验信息更新时间,年度,更新时间2";
|
||
//导出生成excel
|
||
$scope.DaoChu = function () {
|
||
var wherestr = angular.toJson($scope.TJTable);
|
||
var fruits = document.getElementsByName("dictName");
|
||
$scope.daochuData = [];
|
||
//增加日志20211109
|
||
addlog("食品生产经营许可", "查询_导出[" + JSON.stringify(wherestr) + "]")
|
||
var numDC = 0;
|
||
for (var i = 0; i < fruits.length; i++) {
|
||
if (fruits[i].checked == true) {
|
||
numDC++;
|
||
$scope.daochuData.push(fruits[i].value);
|
||
}
|
||
|
||
}
|
||
|
||
//debugger
|
||
|
||
var dTT = $scope.daochuData;
|
||
if (numDC == 0) {
|
||
dTT = $scope.selectDt.split(",");
|
||
}
|
||
var sql = "";
|
||
for (var i = 0; i < dTT.length; i++) {
|
||
var ddd = Enumerable.From($scope.dictData).Where(function (x) { return x.TableName == dTT[i] }).FirstOrDefault();
|
||
|
||
if (i == dTT.length - 1) {
|
||
sql = sql + " " + ddd.FieldName + " ";
|
||
} else {
|
||
sql = sql + " " + ddd.FieldName + ",";
|
||
}
|
||
// if (i == dTT.length - 1) {
|
||
// sql = sql + " " + ddd.FieldName + " as '" + ddd.TableName + "' ";
|
||
// } else {
|
||
// sql = sql + " " + ddd.FieldName + " as '" + ddd.TableName + "',";
|
||
// }
|
||
}
|
||
|
||
window.location.href = './ShiPinShengChan/ExportAsExcel?name=食品生产经营许可&strsql=select ' + sql + ' from ShiPinShengChanXuKeQiYe&wherestr=' + wherestr;
|
||
|
||
}
|
||
|
||
//导入文档
|
||
$scope.ImportAll = function (file) {
|
||
//下载时候字符串
|
||
debugger;
|
||
var myid = new Date().valueOf();
|
||
$scope.uploadImg = "";
|
||
$scope.isShow = true;
|
||
console.log('checkinok!!!')
|
||
|
||
Upload.upload({
|
||
//服务端接收
|
||
url: '/ShiPinShengChan/Import',
|
||
//上传的同时带的参数
|
||
data: {'username': $sessionStorage.user.UserName, "FileName": myid.toString(), module: 'xlz'},
|
||
file: file[0]
|
||
}).progress(function (evt) {
|
||
//进度条
|
||
$scope.uploadImg = parseInt(100 * evt.loaded / evt.total) + "%";
|
||
|
||
}).success(function (data, status, headers, config) {
|
||
//上传成功
|
||
alert("导入成功！");
|
||
|
||
$scope.ChaXun();
|
||
$scope.isShow = false;
|
||
//增加日志20211109
|
||
addlog("食品生产经营许可", "数据_导入" + myid.toString())
|
||
})
|
||
}
|
||
|
||
|
||
$("#exprotText1").hide();
|
||
$("#exprotText2").hide();
|
||
|
||
|
||
/********************************************/
|
||
|
||
|
||
|
||
/**************************************************************************************/
|
||
//通过STMATETable 分页显示数据
|
||
//以下的参数每个控制器都要有一份
|
||
tableState = { counrt: 0, pagination: { start: 0 }, search: {}, sort: {} }; //这个参数后面会让每次访问服务器后进行同步返回的值赋值,作为中间值使用
|
||
$scope.selectList = []; //这个参数会让每次选中或者没有选中的条目直接暴露在这个值里面
|
||
$scope.searchSql = ""; //这个参数是自己组合相关的复杂查询条件
|
||
$scope.isShow = false; //这个参数主要进行页面加载的loading显示的directive的值得操作
|
||
$scope.itemsOptions = [5, 10, 20, 50, 100, 200, 500, 1000]; //这个参数进行分页页面上面的每页多少条的设置
|
||
$scope.curpageNumber = 10; //这个参数传递当前的每页多少条的数据
|
||
|
||
|
||
|
||
|
||
$scope.getService = function (tableState, ctrl) {
|
||
//if (!wherestr || !wherestr) {
|
||
// wherestr = "";
|
||
//}
|
||
if (!tableState.pagination.number) {
|
||
tableState.pagination.number = $scope.curpageNumber;
|
||
}
|
||
console.log($scope.wherestr);
|
||
|
||
$http.get('./ShiPinShengChan/GetSearch?wherestr=' + $scope.wherestr + '&page=' + tableState.pagination.start + '&limit=' + tableState.pagination.number, {}).success(function (res) {
|
||
|
||
|
||
console.log('获取结果',res);
|
||
|
||
$scope.displayed = res.data;
|
||
$scope.qiyeshuliang = res.qiyetotal;
|
||
$scope.isShow = false;
|
||
|
||
//当前页面的ID号数组
|
||
//$scope.ids = Enumerable.From($scope.displayed).Select(function (x) { return x._id }).ToArray();
|
||
//表格数量
|
||
$scope.myttt = res.total;
|
||
tableState.count = res.total;
|
||
tableState.pagination.numberOfPages = Math.ceil(res.total / $scope.curpageNumber);
|
||
$scope.inputPage = tableState.pagination.numberOfPages;
|
||
$scope.tableState = tableState;
|
||
$scope.$broadcast('checkini');
|
||
})
|
||
|
||
|
||
};
|
||
//模板的分页选择触发操作
|
||
$scope.setPageNumber = function (pageNo) {
|
||
tableState.pagination.number = pageNo;
|
||
$scope.getService($scope.tableState, null);
|
||
}
|
||
|
||
//查询参数的调用
|
||
$scope.search = function () {
|
||
$scope.searchSql = [$scope.sql];
|
||
$scope.getA($scope.tableState);
|
||
}
|
||
//新的删除操作20230828单独删除SQLSERVER的数据
|
||
//SQLDeleteOne
|
||
$scope.SQLDeleteOne = function (id) {
|
||
|
||
|
||
dLayer.confirm('您确定删除编号[' + id + "]的单条数据信息?", {
|
||
btn: ['确定', '取消'] //按钮
|
||
}, function (index) {
|
||
console.log('Execute');
|
||
dLayer.close(index);
|
||
$http.get('/ShiPinShengChan/RemoveData?id=' + id).success(function (mydata) {
|
||
|
||
//curLayer.msg('删除成功,请刷新!');
|
||
dLayer.alert("删除成功,请刷新!");
|
||
|
||
})
|
||
}, function () {
|
||
dLayer.msg('操作取消')
|
||
return;
|
||
})
|
||
|
||
|
||
}
|
||
|
||
|
||
|
||
/**************************************************************************************/
|
||
|
||
|
||
|
||
$scope.items = 0;
|
||
$scope.open = function (YPBH) {
|
||
$scope.items = YPBH;
|
||
var modalInstance = $uibModal.open({
|
||
animation: true,
|
||
backdrop: false, // 不让点击背景关闭系统
|
||
templateUrl: 'app/model/modalTemplate.html',
|
||
controller: 'uibModalInstanceCtrl',
|
||
size: 'lg',
|
||
//windowTopClass:'dialog'
|
||
resolve: {
|
||
items: function () {
|
||
return $scope.items;
|
||
}
|
||
}
|
||
});
|
||
modalInstance.result.then(
|
||
function (nclose) { $scope.returnData = nclose },
|
||
function (ndismiss) { $scope.returnData = ndismiss }
|
||
)
|
||
}
|
||
|
||
$scope.JYXM = [];
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
}])
|
||
|