app.controller('CustomQueryCtrl', ['$scope', 'YPJBXXGL', '$uibModal', '$sessionStorage', '$state', '$http', 'mainUrl', 'wyOdataNodeService', 'stConfig', '$timeout', function ($scope, YPJBXXGL, $uibModal, $sessionStorage, $state, $http, mainUrl, wyOdataNodeService, stConfig, $timeout) { $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": "RWNF" }, { "type": 1, "mytext": "抽样单编号", "PY": "CYDBH" }, { "type": 1, "mytext": "任务编号", "PY": "RWBH" }, { "type": 1, "mytext": "流水号", "PY": "LSH" }, { "type": 1, "mytext": "任务来源", "PY": "RWLY" }, { "type": 1, "mytext": "任务类别", "PY": "RWLX" }, { "type": 1, "mytext": "任务性质", "PY": "RWXZ" }, { "type": 1, "mytext": "被抽样人信息(名称)", "PY": "BCYRMC" }, { "type": 1, "mytext": "执行年月", "PY": "ZXNY" }, //-----------新食品分类---------------------------- { "type": 1, "mytext": "食品大类", "PY": "SP_DL" }, { "type": 1, "mytext": "食品亚类", "PY": "SP_YL" }, { "type": 1, "mytext": "食品品种", "PY": "SP_PZ" }, { "type": 1, "mytext": "食品细类", "PY": "SP_XL" }, //------------------------------------------------- //-----------原食品分类---------------------------- { "type": 1, "mytext": "原食品分类", "PY": "OldYPFL" }, //------------------------------------------------------- { "type": 1, "mytext": "区域类型", "PY": "QYLX" }, { "type": 1, "mytext": "地址（市）", "PY": "DZ_S" }, { "type": 1, "mytext": "地址（区（县））", "PY": "DZ_QX" }, { "type": 1, "mytext": "地址（街道（镇）", "PY": "DZ_Z" }, { "type": 1, "mytext": "地址（弄）", "PY": "DZ_N" }, { "type": 1, "mytext": "地址（号）", "PY": "DZ_H" }, { "type": 1, "mytext": "地址（室）", "PY": "DZ_S1" }, { "type": 1, "mytext": "连贯地址", "PY": "BCYDWMC" }, { "type": 1, "mytext": "法人代表", "PY": "FRDB" }, { "type": 1, "mytext": "年销售额", "PY": "NXSE" }, { "type": 1, "mytext": "营业执照号", "PY": "YYZZH" }, { "type": 1, "mytext": "联系人", "PY": "LXR1" }, { "type": 1, "mytext": "许可证号", "PY": "JYXKZ" }, { "type": 1, "mytext": "电话", "PY": "DH1" }, { "type": 1, "mytext": "传真", "PY": "CZ" }, { "type": 1, "mytext": "邮编", "PY": "YX" }, { "type": 1, "mytext": "抽样地点", "PY": "CYDD" }, { "type": 1, "mytext": "抽样地点类型", "PY": "CYDDLX" }, { "type": 1, "mytext": "样品来源", "PY": "YPLY" }, { "type": 1, "mytext": "样品属性", "PY": "YPSX" }, { "type": 1, "mytext": "样品类型", "PY": "YPLX" }, { "type": 1, "mytext": "样品名称", "PY": "YPMC" }, { "type": 1, "mytext": "商标", "PY": "SB" }, { "type": 1, "mytext": "生产/ 加工\n购进日期", "PY": "SCJGGJRQ" }, { "type": 1, "mytext": "规格型号", "PY": "GGXH" }, { "type": 1, "mytext": "样品批号", "PY": "YPPH" }, { "type": 1, "mytext": "保质期", "PY": "BZQ" }, { "type": 1, "mytext": "执行标准/技术文件", "PY": "ZXBZ" }, { "type": 1, "mytext": "质量等级", "PY": "ZLDJ" }, { "type": 1, "mytext": "生产许可证编号", "PY": "SCXKZBH" }, { "type": 1, "mytext": "单价", "PY": "DJ" }, { "type": 1, "mytext": "是否出口", "PY": "SFCK" }, { "type": 1, "mytext": "抽样基数/批量", "PY": "CYJS" }, { "type": 1, "mytext": "抽样数量(含备样)", "PY": "CYSL" }, { "type": 1, "mytext": "备样数量", "PY": "BYSL" }, { "type": 1, "mytext": "样品形态", "PY": "YPXT" }, { "type": 1, "mytext": "包装分类", "PY": "BZFL" }, { "type": 1, "mytext": "生产者名称", "PY": "SCZMC" }, { "type": 1, "mytext": "生产者地址_省", "PY": "SCZDZ_S" }, { "type": 1, "mytext": "生产者地址_市", "PY": "SCZDZ_s" }, { "type": 1, "mytext": "生产者地址_区县", "PY": "SCZDZ_Q" }, { "type": 1, "mytext": "生产者地址", "PY": "SCZDZ" }, { "type": 1, "mytext": "联系电话", "PY": "LXDH" }, { "type": 1, "mytext": "(标称)样品储存条件", "PY": "YPCCTJ" }, { "type": 1, "mytext": "寄、送样品截止日期", "PY": "YPJZRQ" }, { "type": 1, "mytext": "寄送样品地址", "PY": "JSYPDZ" }, { "type": 1, "mytext": "抽样样品包装", "PY": "CYYPBZ" }, { "type": 1, "mytext": "抽样方式", "PY": "CYFS" }, { "type": 1, "mytext": "抽样单位信息（单位名称）", "PY": "CYDWMC" }, { "type": 1, "mytext": "抽样单位信息（地址）", "PY": "CYDWDZ" }, { "type": 1, "mytext": "抽样单位信息（联系人）", "PY": "CYDWLXR" }, { "type": 1, "mytext": "抽样单位信息（电话）", "PY": "CYDWDH" }, { "type": 1, "mytext": "抽样单位信息（传真）", "PY": "CYDWCZ" }, { "type": 1, "mytext": "抽样单位信息（邮编）", "PY": "CYDWYB" }, { "type": 1, "mytext": "备注", "PY": "QT" }, { "type": 1, "mytext": "被抽样单位签名", "PY": "BCYDWQM" }, { "type": 1, "mytext": "被抽样单位签名时间", "PY": "BCYDWSJ" }, { "type": 1, "mytext": "抽样人", "PY": "CYRQM" }, { "type": 1, "mytext": "抽样单位", "PY": "CYDW" }, { "type": 1, "mytext": "抽样时间", "PY": "CYSJ" }, { "type": 1, "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" }, ]; //、定性值、、、、限量值、限量值单位、检测值、检测值单位、判定 $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); }); //页面加载 表格中的数据 //YPJBXXGL.get(function (data) { // $scope.myData = data.value; // //首先判断是否是检测机构如果是检测机构的话那么就只显示检测机构的数据 // switch ($sessionStorage.user.type) { // case 4: // case 5: // $scope.myData = Enumerable.From($scope.myData).Where("$.JCDW.indexOf('" + $sessionStorage.user.name + "')>-1").ToArray(); // break; // default: // } // $scope.myttt = data.value.length; //}); 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; } 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": //$http.get("/home/GetShiPinLeiBie?cengji=1", {}) // .success(function (Ldata) { // $scope.RELYdata.push({ "mytext": "" + Ldata[0] + "", "PY": "GJZJ" }) // for (var i1 = 1; i1 < Ldata.length; i1++) { // $scope.RELYdata.push({ "mytext": "" + Ldata[i1] + "", "PY": "SHZJ" }) // } // }); $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" }) } } } ////如果已经选择 则 选择亚类时 嵌入条件 食品大类 //var wherestr1 = ""; //if (shangjixinxi1) { // wherestr1 = "&shangji=" + shangjixinxi1.CXNR; //} //$http.get("/home/GetShiPinLeiBie?cengji=2" + wherestr1, {}) // .success(function (Ldata) { // $scope.RELYdata.push({ "mytext": "" + Ldata[0] + "", "PY": "GJZJ" }) // for (var i1 = 1; i1 < Ldata.length; i1++) { // $scope.RELYdata.push({ "mytext": "" + Ldata[i1] + "", "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" }) } } } ////如果已经选择 则 选择品种类时 嵌入条件 食品亚类 //var wherestr2 = ""; //if (shangjixinxi2) { // wherestr2 = "&shangji=" + shangjixinxi2.CXNR; //} //$http.get("/home/GetShiPinLeiBie?cengji=3" + wherestr2, {}) // .success(function (Ldata) { // $scope.RELYdata.push({ "mytext": "" + Ldata[0] + "", "PY": "GJZJ" }) // for (var i1 = 1; i1 < Ldata.length; i1++) { // $scope.RELYdata.push({ "mytext": "" + Ldata[i1] + "", "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.RELYdata = []; ////查看是否已选择 食品亚类 //var shangjixinxi = Enumerable.From($scope.TJTable).Where(function (x) { return x.CXTJ == "食品亚类" }).FirstOrDefault(); ////如果已经选择 则 选择品种类时 嵌入条件 食品亚类 //var wherestr3 = ""; //if (shangjixinxi) { // wherestr3 = "&shangji=" + shangjixinxi.CXNR; //} //$http.get("/home/GetShiPinLeiBie?cengji=4" + wherestr3, {}) // .success(function (Ldata) { // $scope.RELYdata.push({ "mytext": "" + Ldata[0] + "", "PY": "GJZJ" }) // for (var i1 = 1; i1 < Ldata.length; i1++) { // $scope.RELYdata.push({ "mytext": "" + Ldata[i1] + "", "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 "RWLY": $scope.RELYdata = [ { "mytext": "国家食品药品监督管理总局", "PY": "GJZJ" }, { "mytext": "上海市食品药品监督管理局", "PY": "SHZJ" }, { "mytext": "上海市市场监督管理局", "PY": "GJZJ" }, { "mytext": "国家市场监督管理总局", "PY": "GJZJ" }, ]; $scope.isdate = false; $scope.RWLYSHOW = true; $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; default: $scope.isdate = false; $scope.RWLYSHOW = false; $scope.SouSuoShow = true; } $timeout(function () { $("#dept").trigger("chosen:updated"); }, 100, false); } /////*******************总的查询*****************/ //$scope.ChaXun = function () { // $scope.searchSql = ''; // angular.forEach($scope.TJTable, function (data) { // // console.log(angular.toJson(data)); // if (data.CXTJ == "检测项目" || (data.CXTJ == "检测标准") || (data.CXTJ == "评价标准") || (data.CXTJ == "检测方法") || (data.CXTJ == "检测机构") || (data.CXTJ == "检测报告编号")) { // if (data.CXLXid == 2) { // $scope.searchSql = $scope.searchSql + " indexof(" + "JCXXX." + data.CXTJPY + ",'" + data.CXNR + "') ge 0 and " // } else { // $scope.searchSql = $scope.searchSql + "JCXXX." + data.CXTJPY + " eq '" + data.CXNR + "' and " // } // } else { // if (data.CXLXid == 2) { // $scope.searchSql = $scope.searchSql + " indexof(" + data.CXTJPY + ",'" + data.CXNR + "') ge 0 and " // } else { // $scope.searchSql = $scope.searchSql + data.CXTJPY + " eq '" + data.CXNR + "' and " // } // } // }) // $scope.searchSql = $scope.searchSql.substring(0, $scope.searchSql.length - 4); // // console.log(angular.toJson($scope.searchSql)); // $scope.getService($scope.tableState, $scope.searchSql); /////*******************总的查询*****************/ $scope.ChaXun = function () { var wherestr = angular.toJson($scope.TJTable); if ($scope.TJTable.length <= 0) { wherestr = ""; } $scope.wherestr = wherestr; $scope.tableState.pagination.start = 0; $scope.getService($scope.tableState, null); //增加日志20211109 addlog("MGO查询", "查询[" + wherestr + "]") //$http({ // method: "GET", // url: '/home/GetTaMadeZuHeChaXun', // data: { "wherestr":angular.toJson($scope.TJTable), "pagesize": 10, "pageindex": 1 }, //}).success(function (data, status, headers, config) { // //当相应准备就绪时调用 //}).error(function (data, status, headers, config) { // //当响应错误状态返回时调用 //}) //var jcxxxlist=["检测项目","检测标准","评价标准","检测方法","检测机构","检测报告编号"]; //$scope.searchSql = ''; //angular.forEach($scope.TJTable, function (data) { // switch (data.CXLX){ // case "包含": // $scope.searchSql+=" indexof(" // if (jcxxxlist.indexOf(data.CXTJ)>=0) { // $scope.searchSql+="JCXXX."; // } // $scope.searchSql+=data.CXTJPY; // $scope.searchSql+="," // $scope.searchSql+="'"+data.CXNR+"'"; // $scope.searchSql+=") ge 0 and" // break; // case "等于": // if (jcxxxlist.indexOf(data.CXTJ)>=0) { // $scope.searchSql+=" JCXXX."; // } // $scope.searchSql+=data.CXTJPY ; // $scope.searchSql+=" eq " // $scope.searchSql+="'"+data.CXNR+"'"; // $scope.searchSql += " and" // break; // case "大于": // if (jcxxxlist.indexOf(data.CXTJ)>=0) { // $scope.searchSql+=" JCXXX."; // } // $scope.searchSql+=data.CXTJPY ; // $scope.searchSql+=" gt " // $scope.searchSql+="'"+data.CXNR+"'"; // $scope.searchSql+=" and" // break; // case "小于": // if (jcxxxlist.indexOf(data.CXTJ)>=0) { // $scope.searchSql+=" JCXXX."; // } // $scope.searchSql+=data.CXTJPY ; // $scope.searchSql+=" lt " // $scope.searchSql+="'"+data.CXNR+"'"; // $scope.searchSql += " and" // break; // case "大于等于": // if (jcxxxlist.indexOf(data.CXTJ)>=0) { // $scope.searchSql+=" JCXXX."; // } // $scope.searchSql+=data.CXTJPY ; // $scope.searchSql+=" ge " // $scope.searchSql+="'"+data.CXNR+"'"; // $scope.searchSql += " and" // break; // case "小于等于": // if (jcxxxlist.indexOf(data.CXTJ)>=0) { // $scope.searchSql+=" JCXXX."; // } // $scope.searchSql+=data.CXTJPY ; // $scope.searchSql+=" le " // $scope.searchSql+="'"+data.CXNR+"'"; // $scope.searchSql += " and" // break; // } //}) //$scope.searchSql = $scope.searchSql.substring(0, $scope.searchSql.length - 4); //console.log(angular.toJson($scope.searchSql)); //$scope.getService($scope.tableState, $scope.searchSql); } $scope.ChaXun2 = function () { var wherestr = angular.toJson($scope.TJTable); if ($scope.TJTable.length <= 0) { wherestr = ""; } $scope.wherestr = wherestr; $scope.tableState.pagination.start = 0; $scope.getService2($scope.tableState, null); //增加日志20211109 addlog("MGO查询", "查询2[" + wherestr + "]") } $scope.DaoChu = function () { var wherestr = angular.toJson($scope.TJTable); //$http.get(Gaddress + '/home/GetTaMadeZuHeChaXun_DAOCHU?wherestr=' + wherestr,{}).success(function (mydata) { // alert("导出成功"); // return mydata; //}) //增加日志20211109 addlog("MGO查询", "查询_导出[" + wherestr + "]") window.location.href = '/home/GetTaMadeZuHeChaXun_DAOCHU?wherestr=' + wherestr; } /********************************************/ ////加载方法 //$scope.jiazai = function (filter) { // YPJBXXGL.getAll({ $filter: filter }, function (data) { // console.log(angular.toJson(data.value.length)); // $scope.myData = data.value; // 首先判断是否是检测机构如果是检测机构的话那么就只显示检测机构的数据 // switch ($sessionStorage.user.type) { // case 4: // case 5: // $scope.myData = Enumerable.From($scope.myData).Where("$.JCDW.indexOf('" + $sessionStorage.user.name + "')>-1").ToArray(); // break; // default: // } // $scope.myttt = data.value.length; // }) //} /**************************************************************************************/ //通过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]; //这个参数进行分页页面上面的每页多少条的设置 $scope.curpageNumber = 10; //这个参数传递当前的每页多少条的数据 //任何动作都会触发服务端的接口 $scope.getService = function (tableState, ctrl) { //if (!wherestr || !wherestr) { // wherestr = ""; //} if (!tableState.pagination.number) { tableState.pagination.number = $scope.curpageNumber; } //alert('ser' + $scope.curpageNumber); //$http.get(Gaddress + '/home/GetTaMadeZuHeChaXun?wherestr=' + wherestr + '&pagesize=10&pageindex=1', {}).success(function (mydata) { $http.get(Gaddress + '/home/GetTaMadeZuHeChaXun?wherestr=' + $scope.wherestr + '&tiaoguo=' + tableState.pagination.start + '&huoqu=' + tableState.pagination.number, {}).success(function (mydata) { $scope.displayed = mydata.MYJsonDB; $scope.zongxiangcishu = mydata.MYZongXiangCi; $scope.isShow = false; //当前页面的ID号数组 $scope.ids = Enumerable.From($scope.displayed).Select(function (x) { return x._id }).ToArray(); //计算当前界面 项次数合计 $scope.xiangciheji = Enumerable.From($scope.displayed).Select(function (x) { return x.JCXXX.length }).Sum(); //表格数量 $scope.myttt = mydata.MYCount; tableState.count = mydata.MYCount; tableState.pagination.numberOfPages = Math.ceil(mydata.MYCount / $scope.curpageNumber); $scope.inputPage = tableState.pagination.numberOfPages; $scope.tableState = tableState; $scope.$broadcast('checkini'); }) //count:13079 pagination:{start: 30, number: 10, numberOfPages: 1308} search:{}sort:{} //$scope.tableState = tableState; //if (!$scope.tableState.pagination.number) { // $scope.tableState.pagination.number = $scope.curpageNumber; //} //$scope.isShow = true; //wyOdataNodeService.getData('http://172.28.3.129:5000/', 'YPJBXXGL_DB', $scope.tableState, $scope.searchSql).then(function (data) { // $scope.displayed = data; // $scope.isShow = false; // //当前页面的ID号数组 // $scope.ids = Enumerable.From($scope.displayed).Select(function (x) { return x.id }).ToArray(); // //表格数量 // $scope.myttt = tableState.count; // $scope.$broadcast('checkini'); // //console.log($scope.ids); //}); }; $scope.getService2 = function (tableState, ctrl) { //if (!wherestr || !wherestr) { // wherestr = ""; //} if (!tableState.pagination.number) { tableState.pagination.number = $scope.curpageNumber; } $http.get(Gaddress + '/home/GetTaMadeZuHeChaXun?wherestr=' + $scope.wherestr + '&tiaoguo=' + tableState.pagination.start + '&huoqu=' + tableState.pagination.number, {}).success(function (mydata) { $scope.displayed = mydata.MYJsonDB; $scope.zongxiangcishu = mydata.MYZongXiangCi; $scope.isShow = false; //当前页面的ID号数组 $scope.ids = Enumerable.From($scope.displayed).Select(function (x) { return x._id }).ToArray(); //计算当前界面 项次数合计 $scope.xiangciheji = Enumerable.From($scope.displayed).Select(function (x) { return x.JCXXX.length }).Sum(); //表格数量 $scope.myttt = mydata.MYCount; tableState.count = mydata.MYCount; tableState.pagination.numberOfPages = Math.ceil(mydata.MYCount / $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); } /**************************************************************************************/ $scope.XiuGai = function (id, cyd) { console.log('这是芒果',id,cyd) //$state.go("app.SampleInspect", { id: id, CYDBH: '' }); dLayer.open({ type: 2, area: ['1200px', '700px'], content: '../index.html#/SampleInspectdialog/' + id + "/" + cyd //这里content是一个URL，如果你不想让iframe出现滚动条，你还可以content: ['http://sentsin.com', 'no'] }); } $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 } ) } }]) app.controller('uibModalInstanceCtrl', ['$scope', '$uibModalInstance', 'items', 'ST', function ($scope, $uibModalInstance, items, ST) { //alert(items); $scope.mytext = "未检测到结果"; $scope.tj = [ { name: "检测项目", py: "JCXM" }, { name: "检测标准编号", py: "JCBZBH" }, { name: "检测标准名称", py: "JCBZMC" }, { name: "方法序号", py: "FFXH" }, { name: "方法名称", py: "FFMC" }, { name: "检测仪器", py: "JCYQ" }, { name: "检测定性限", py: "JCDXX" }, { name: "样品综合判定", py: "YPZHPD" } ] $scope.Ptj = [ { name: ">" }, { name: "=" }, { name: "<" }, ] var f1 = "YPBH eq " + items; ST.getAll({ $filter: f1 }, function (data) { $scope.myData2 = data.value[0].JCXXX $scope.mytext = "总共检测的项目数量：" + $scope.myData2.length + "项"; }) //查询的方法 $scope.wocao = function () { $scope.mys; $scope.myt; var curname = $scope.mys.py; if ($scope.myt != undefined || $scope.myt != "") { var dT2 = Enumerable.From($scope.myData2).Where("$." + curname + ".indexOf('" + $scope.myt + "')>-1").ToArray(); $scope.myData2 = dT2; var a = (dT2.length / $scope.myData2.length) * 100; $scope.mytext = $scope.mys.name + "-检测-" + $scope.myt + "的判定合格率为" + a + "%" + "符合条件的数据有：" + $scope.myData2.length + "条"; //$scope.mytext = "查询出符合条件的数据：" + $scope.myData.length; } else { var f1 = "YPBH eq " + items; ST.getAll({ $filter: f1 }, function (data) { alert(angular.toJson(data.value[0].JCXXX)) $scope.myData2 = data.value[0].JCXXX }) } } $scope.Ok = function () { $uibModalInstance.close("界面已经保存并且关闭"); } }])