var app;(function(){"use strict";angular.module("app",["app.services","app.models","app.search"])})(),function(n){var t;(function(n){var t=function(){function n(n,t,i){this.$scope=n;this.$http=t;this.SearchService=i;this.showLoading=!0;this.load();this.outputPreferences=[{id:1,preference:"Analytical Results"},{id:2,preference:"Sample/Results"},{id:4,preference:"Summary of Findings"},{id:6,preference:"Summary of Findings by Origin"},{id:7,preference:"Summary of Findings by Claim"}];this.selectedOutputPreference=this.outputPreferences[0];this.resultsPreferences=[{id:2,preference:"Positive Detects Only"},{id:1,preference:"All Positive Detects + Non-Detects"},{id:4,preference:"Presumptive Tolerance Violations Only"}];this.selectedResultsPreference=this.resultsPreferences[0];this.checkAllCommodities=True;this.checkAllPesticides=True;this.checkSpecificTestClass=!1;this.checkAllYears=True;this.showLoading=!1;this.makeSearchPanelVisible()}return n.prototype.specificClassChange=function(){this.allPesticidesChange(this.checkSpecificTestClass)},n.prototype.allPesticidesChange=function(){for(var n=0;n<this.pesticides.length;n++)this.pesticides[n].isChecked=this.checkAllPesticides},n.prototype.allCommoditiesChange=function(){for(var n=0;n<this.commodities.length;n++)this.commodities[n].isChecked=this.checkAllCommodities},n.prototype.allYearsChange=function(){for(var n=0;n<this.years.length;n++)this.years[n].isChecked=this.checkAllYears},n.prototype.search=function(){this.showLoading=!0;var u=function(n){return n.isChecked},n=_.filter(this.commodities,u),t=_.filter(this.pesticides,u),i=_.filter(this.testClasses,u),r=_.filter(this.years,u);switch(this.selectedOutputPreference.id){case 1:this.getAnalyticalResults1(n,t,i,r,this.selectedResultsPreference.id);break;case 2:this.getSampleResults1(n,t,i,r,this.selectedResultsPreference.id);break;case 3:this.getSummaryOfNdLods(n,t,i,r);break;case 4:this.getSummaryOfFindings1(n,t,i,r);break;case 5:this.getSummaryOfFindingsByLod(n,t,i,r);break;case 6:this.getSummaryOfFindingsByCountryOfOrigin1(n,t,i,r);break;case 7:this.getSummaryOfFindingsByClaim1(n,t,i,r)}},n.prototype.getAnalyticalResults=function(n,t,i,r,u){var f=this;this.SearchService.getAnalyticalResults(n,t,i,r,u).then(function(n){f.analyticalResults=n;f.showResultsPanel=!0;f.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#analyticalResultsGrid").jqGrid({datatype:"local",data:f.analyticalResults,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#analyticalResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:185,frozen:!0},{label:"Com",name:"commodity",width:50},{label:"Pest Code",name:"pesticideCode",width:50},{label:"Pest Name",name:"pesticideName",width:140},{label:"Tst",name:"testClass",width:45},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:50},{label:"Co1",name:"confirmationMethod",width:50},{label:"Co2",name:"confirmationMethod2",width:50},{label:"Ann",name:"annotate",width:50},{label:"Qua",name:"quantitate",width:50},{label:"Mean",name:"mean",width:50},{label:"Ext",name:"extract",width:50},{label:"Det",name:"determinative",width:50},{label:"Tol (ppm)",name:"tol",width:60}],viewrecords:!0,toolbarfilter:!0,caption:"<p align='center'><b>Analytical Results<\/b><\/p>"})})},n.prototype.getAnalatycalData=function(n,t,i,r,u){var f=this;this.SearchService.getAnalyticalResults(n,t,i,r,u).then(function(n){f.analyticalResults=n})},n.prototype.getAnalyticalResults1=function(n,t,i,r,u){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#analyticalResultsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetAnalyticalResults1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,altRows:!0,pager:"#analyticalResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:185,frozen:!0},{label:"Com",name:"commod",width:50},{label:"Pest Code",name:"pesticideCode",width:50},{label:"Pest Name",name:"pesticideName",width:140},{label:"Tst",name:"testClass",width:45},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp_",width:50},{label:"Co1",name:"confirm1",width:50},{label:"Co2",name:"confirm2",width:50},{label:"Ann",name:"annotate",width:50},{label:"Qua",name:"quantitate",width:50},{label:"Mean",name:"mean",width:50},{label:"Ext",name:"extract",width:50},{label:"Det",name:"determ",width:50},{label:"Tol (ppm)",name:"tol",width:65}],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,emptyrecords:"Scroll to bottom to retrieve new page",caption:"<p align='center'><b>Analytical Results<\/b><\/p>"});$("#analyticalResultsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#analyticalResultsGrid").jqGrid("navGrid","#analyticalResultsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#analyticalResultsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var f=jQuery(this).jqGrid("getGridParam"),e={commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u};$.post("/PDP/api/Info/ExportToExcelAnalyticalResults1/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u,filter:f.postData.filters,search:f.postData._search},function(n){var u=typeof n!="object"?JSON.parse(n):n,o="",f="",i,r,t,s,h,c,e;for(t in u[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"Sampleid":t="Sample ID";break;case"Pesticidecode":t="Pesticide Code";break;case"Pesticidename":t="Pesticide Name";break;case"Testclass":t="Test Class";break;case"Lod":t="LOD";break;case"Confirm1":t="Confirm 1";break;case"Confirm2":t="Confirm 2";break;case"Pp_":t="pp_";break;case"Tol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<u.length;i++){r="";for(t in u[i])r!=""&&(r+=","),r+=u[i][t];o+=r+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="AnalyticalResults.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSampleResults=function(n,t,i,r,u){var f=this;this.SearchService.getSampleResults(n,t,i,r,u).then(function(n){f.sampleResults=n;f.showResultsPanel=!0;f.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#sampleResultsGrid").jqGrid({datatype:"local",data:f.sampleResults,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,rowList:[100,500,1e3],pager:"#sampleResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:175},{label:"Com",name:"commodity",width:50},{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:35},{label:"Ann",name:"annotate",width:45},{label:"Mean",name:"mean",width:50},{label:"Type",name:"commodityType",width:50},{label:"Variety",name:"variety",width:75},{label:"Clm",name:"commodityClaim",width:40},{label:"Fac",name:"facilityType",width:40},{label:"Origin",name:"origin",width:40},{label:"Country",name:"country",width:55},{label:"State",name:"state",width:40},{label:"Qty",name:"quantity",width:40},{label:"Tol (ppm)]",name:"tol",width:60}],viewrecords:!0,gridview:!0,caption:"<p align='center'><b>Sample/Results<\/b><\/p>"})})},n.prototype.getSampleResults1=function(n,t,i,r,u){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#sampleResultsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSampleResults1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,altRows:!0,pager:"#sampleResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:175},{label:"Com",name:"commodity",width:50},{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:35},{label:"Ann",name:"annotate",width:45},{label:"Mean",name:"mean",width:50},{label:"Type",name:"commodityType",width:50},{label:"Variety",name:"variety",width:75},{label:"Clm",name:"commodityClaim",width:40},{label:"Fac",name:"facilityType",width:40},{label:"Origin",name:"origin",width:40},{label:"Country",name:"country",width:55},{label:"State",name:"state",width:40},{label:"Qty",name:"quantity",width:40},{label:"Tol (ppm)]",name:"tol",width:60}],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,emptyrecords:"Scroll to bottom to retrieve new page",caption:"<p align='center'><b>Sample/Results<\/b><\/p>"});$("#sampleResultsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#sampleResultsGrid").jqGrid("navGrid","#sampleResultsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#sampleResultsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var f=jQuery(this).jqGrid("getGridParam");f.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSampleResults1/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u,filter:f.postData.filters,search:f.postData._search},function(n){var u=typeof n!="object"?JSON.parse(n):n,o="",f="",i,r,t,s,h,c,e;for(t in u[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"Sampleid":t="Sample ID";break;case"Commoditytype":t="Commodity Type";break;case"Pesticidename":t="Pesticide Name";break;case"Pestcode":t="Pesticide Code";break;case"concentration":t="Concentration";break;case"Lod":t="LOD";break;case"annotate":t="Annotate";break;case"quantitate":t="Quantitate";break;case"Pp":t="pp_";break;case"mean":t="Mean";break;case"Commoditytype":t="Commod Type";break;case"variety":t="Variety";break;case"Commodityclaim":t="Commodity Claim";break;case"Facilitytype":t="Facility Type";break;case"origin":t="Origin";break;case"country":t="Country";break;case"state":t="State";break;case"quantity":t="Unit Count";break;case"Tol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<u.length;i++){r="";for(t in u[i])r!=""&&(r+=","),r+='"'+u[i][t]+'"';o+=r+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SampleResults.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSampleResults2=function(){this.showResultsPanel=!0;this.showSearchPanel=!1;var n={sortColumns:[],filterColumns:[]};this.$scope.gridResul={enableFiltering:!0,enableGridMenu:!0,exporterMenuCsv:!0,paginationPageSize:500,useExternalPagination:!0,useExternalSorting:!0,columnDefs:[{field:"PDP_Sample_ID",displayName:"Sample Id",visible:!1,enableSorting:!1},{field:"PdpYear",displayName:"Pdp Yr",filter:{term:"2014"},width:80},{field:"Com",width:70},{field:"Pest_Code",width:105},{field:"Pesticide_Name",displayName:"Pest Name",width:100},{field:"Concen",width:80},{field:"LOD",visible:!1},{field:"pp_"},{field:"Ann",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Qua"},{field:"Mean",enableFiltering:!1},{field:"Type",enableFiltering:!1},{field:"Variety",width:75},{field:"Clm",enableSorting:!1,enableFiltering:!1},{field:"Fac",enableSorting:!1,enableFiltering:!1},{field:"Origin",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Country",enableSorting:!1,enableFiltering:!1},{field:"State",enableSorting:!1,enableFiltering:!1},{field:"Qty",enableSorting:!1,enableFiltering:!1},{field:"Tol_ppm",enableSorting:!1,enableFiltering:!1}],onRegisterApi:function(t,i,r){this.$scope.gridApi=r;this.$scope.gridApi.core.on.sortChanged(this.$scope,function(r,u){this.getPage&&(n.sortColumns=[],u.length>0&&u.forEach(function(t){n.sortColumns.push(t.name+"#"+t.sort.direction)}),this.getPage(t,i,r.options.paginationCurrentPage,r.options.paginationPageSize,n))});this.$scope.gridApi.core.on.filterChanged(this.$scope,function(){if(this.getPage){n.filterColumns=[];var r=this.grid;angular.forEach(r.columns,function(t){var r=t.field,i=t.filters[0].term;i&&n.filterColumns.push(r+"#"+i)});n.filterColumns.length<1;this.getPage(t,i,r.options.paginationCurrentPage,r.options.paginationPageSize,n)}});r.pagination.on.paginationChanged(this.$scope,function(r,u){this.getPage&&this.getPage(t,i,r,u,n)});r.edit.on.afterCellEdit(this.$scope,function(n,t,i,r){this.editCellPut(n,t,i,r);this.$scope.apply()})},gridMenuCustomItems:[{title:"Export Filtered Data As CSV",order:100,action:function(){}}]};this.init(this.$http,this.$scope,n)},n.prototype.init=function(n,t,i){i.filterColumns.push("PdpYear#2013");this.getPage(n,t,1,500,i)},n.prototype.getPage=function(n,t,i,r,u){var e=(i-1)*r,f="http://PdpApi/api/ResultsData?FirstRow="+e+"&PageSize="+r,o;return u.filterColumns&&(f+="&Filter="+encodeURIComponent(u.filterColumns)),u.sortColumns&&(f+="&Sort="+encodeURIComponent(u.sortColumns)),o=t,n.get(f).success(function(n){alert(n.RecordCount);t.gridResul.totalItems=n.RecordCount;t.gridResul.data=n.Data}).error(function(n){alert("error getting data: "+n.ExceptionMessage)}).finally(function(){})},n.prototype.editCellPut=function(n,t,i,r){if(i!=r){var u=n.SamplePK+"|"+n.Pest_Code+"|"+n.PdpYear+"|"+n.Com;return this.$http.put("http://PdpApi/api/ResultsData",{rowkey:u,col:t.name,val:i}).success(function(){this.$scope.msg="successfully updated  row key:"+u+" Column:"+t.name+" newValue:"+i+" oldValue:"+r}).error(function(n){alert("error updating data: "+(n.ExceptionMessage?n.ExceptionMessage:n.Message))}).finally(function(){this.$scope.loading=!1})}},n.prototype.getSummaryOfNdLods=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfNdLods(n,t,i,r).then(function(n){u.summaryOfNd=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfNdGrid").jqGrid({datatype:"local",data:u.summaryOfNd,height:250,autowidth:!0,rowNum:100,pager:"#summaryOfNdGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName"},{label:"Commodity",name:"commodity"},{label:"Test Lab",name:"testLab"},{label:"Reported LOD",name:"reportedLod"},{label:"Unit pp_",name:"unitPp"},{label:"Number of Samples",name:"numberOfSamples"}],viewrecords:!0,caption:"Summary of LODs for Non-Detects"})})},n.prototype.getSummaryOfFindings=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindings(n,t,i,r).then(function(n){u.summaryOfFindings=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsGrid").jqGrid({datatype:"local",data:u.summaryOfFindings,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:175},{label:"Commodity",name:"commodity",width:175},{label:"# of Samples Analyzed",name:"samplesNumber",width:105},{label:"# of Samples W/Detects",name:"samplesDetects",width:105},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:110},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:115},{label:"Unit pp_",name:"unitPp",width:75},{label:"Tol (ppm)",name:"epatol",width:55},],viewrecords:!0,caption:"<p align='center'><b>Summary of Findings<\/b><\/p>"})})},n.prototype.getSummaryOfFindings1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindings1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:175},{label:"Commodity",name:"commodity",width:175},{label:"# of Samples Analyzed",name:"samplesNumber",width:105},{label:"# of Samples W/Detects",name:"samplesDetects",width:105},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:110},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:115},{label:"Unit pp_",name:"unitPp",width:75},{label:"Tol (ppm)",name:"epatol",width:55},],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,caption:"<p align='center'><b>Summary of Findings<\/b><\/p>"});$("#summaryOfFindingsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsGrid").jqGrid("navGrid","#summaryOfFindingsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindings1/",{commodities:n,pesticides:t,testClasses:i,years:r,filter:u.postData.filters,search:u.postData._search},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindings.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSummaryOfFindingsByLod=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByLod(n,t,i,r).then(function(n){u.summaryOfFindingsByLod=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByLodGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByLod,height:250,autowidth:!0,rowNum:100,pager:"#summaryOfFindingsByLodGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName"},{label:"Commodity",name:"commodity"},{label:"Distinct LOD",name:"distinctLod"},{label:"Unit pp_",name:"unitPp"},{label:"# of Samples Analyzed",name:"samplesNumber"},{label:"# of Samples Detects",name:"samplesDetects"},{label:"% of Samples Detects",name:"sampleDetectsPercent"},{label:"Min Value",name:"minValue"},{label:"Max Value",name:"maxValue"},{label:"Avg Value",name:"avgValue"},],viewrecords:!0,caption:"Summary of Findings by LOD"})})},n.prototype.getSummaryOfFindingsByCountryOfOrigin=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByCountryOfOrigin(n,t,i,r).then(function(n){u.summaryOfFindingsByCountry=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByCountryGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByCountry,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsByCountryGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:125},{label:"Origin",name:"origin",width:55},{label:"Country",name:"country",width:120},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:50},{label:"Tol (ppm)",name:"epatol",width:55}],viewrecords:!0,caption:"<p align='center'><b>Summary of Findings by Country of ORIGIN<\/b><\/p>"})})},n.prototype.getSummaryOfFindingsByCountryOfOrigin1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByCountryGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindingsByCountryOfOrigin1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsByCountryGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:125},{label:"Origin",name:"origin",width:55},{label:"Country",name:"country",width:120},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:50},{label:"Tol (ppm)",name:"epatol",width:55}],sortname:"pesticideName",sortorder:"desc",viewrecords:!0,scroll:1,caption:"<p align='center'><b>Summary of Findings by Country of ORIGIN<\/b><\/p>"});$("#summaryOfFindingsByCountryGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsByCountryGrid").jqGrid("navGrid","#summaryOfFindingsByCountryGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsByCountryGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindingsByCountryOfOrigin1/",{commodities:n,pesticides:t,testClasses:i,years:r},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"country":t="Country";break;case"origin":t="Origin";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindingsByCountry.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSummaryOfFindingsByClaim=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByClaim(n,t,i,r).then(function(n){u.summaryOfFindingsByClaim=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByClaimGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByClaim,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsByClaimGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:100},{label:"CLAIM on Product",name:"claim",width:125},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:40},{label:"Tol (ppm)",name:"epatol",width:65}],viewrecords:!0,caption:"<p align='center'><b>Summary of Findings by Product CLAIM<\/b><\/p>"})})},n.prototype.getSummaryOfFindingsByClaim1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByClaimGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindingsByClaim1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsByClaimGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:100},{label:"CLAIM on Product",name:"claim",width:125},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:40},{label:"Tol (ppm)",name:"epatol",width:65}],sortname:"pesticideName",sortorder:"desc",viewrecords:!0,caption:"<p align='center'><b>Summary of Findings by Product CLAIM<\/b><\/p>"});$("#summaryOfFindingsByClaimGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsByClaimGrid").jqGrid("navGrid","#summaryOfFindingsByClaimGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsByClaimGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindingsByClaim1/",{commodities:n,pesticides:t,testClasses:i,years:r},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"Claim":t="Claim on Product";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindingsByClaim.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.makeSearchPanelVisible=function(){this.showResultsPanel=!1;this.showSearchPanel=!0},n.prototype.makeResultsPanelVisible=function(){this.showSearchPanel=!1;this.showResultsPanel=!0},n.prototype.loadCommodities=function(){var n=this;this.SearchService.getCommodities().then(function(t){n.commodities=t})},n.prototype.loadPesticides=function(){var n=this;this.SearchService.getPesticides().then(function(t){n.pesticides=t})},n.prototype.loadTestClasses=function(){var n=this;this.SearchService.getTestClasses().then(function(t){n.testClasses=t})},n.prototype.loadYears=function(){var n=this;this.SearchService.getYears().then(function(t){n.years=t})},n.prototype.load=function(){this.loadPesticides();this.loadCommodities();this.loadTestClasses();this.loadYears()},n.$inject=["$scope","$http","app.services.SearchService"],n}();n.SearchController=t;angular.module("app.search",["ui.grid","ui.grid.edit","ui.grid.pagination","ui.grid.selection","ui.grid.resizeColumns","ui.grid.exporter"]).controller("app.search.SearchController",["$scope","$http","app.services.SearchService",t]).controller("MainCtrl",function(n,t){function f(){i.filterColumns.push("PdpYear#2013");r(1,n.gridResul.paginationPageSize,i)}var i={sortColumns:[],filterColumns:[]},r,u;n.gridResul={enableFiltering:!0,enableGridMenu:!0,exporterMenuCsv:!0,paginationPageSize:500,useExternalPagination:!0,useExternalSorting:!0,columnDefs:[{field:"PDP_Sample_ID",displayName:"Sample Id",visible:!1,enableSorting:!1},{field:"PdpYear",displayName:"Pdp Yr",filter:{term:"2014"},width:80},{field:"Com",width:70},{field:"Pest_Code",width:105},{field:"Pesticide_Name",displayName:"Pest Name",width:100},{field:"Concen",width:80},{field:"LOD",visible:!1},{field:"pp_"},{field:"Ann",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Qua"},{field:"Mean",enableFiltering:!1},{field:"Type",enableFiltering:!1},{field:"Variety",width:75},{field:"Clm",enableSorting:!1,enableFiltering:!1},{field:"Fac",enableSorting:!1,enableFiltering:!1},{field:"Origin",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Country",enableSorting:!1,enableFiltering:!1},{field:"State",enableSorting:!1,enableFiltering:!1},{field:"Qty",enableSorting:!1,enableFiltering:!1},{field:"Tol_ppm",enableSorting:!1,enableFiltering:!1}],exporterAllDataFn:function(){return r(1,n.gridResul.totalItems,i).then(function(){r=null})},onRegisterApi:function(t){n.gridApi=t;n.gridApi.core.on.sortChanged(n,function(n,t){r&&(i.sortColumns=[],t.length>0&&t.forEach(function(n){i.sortColumns.push(n.name+"#"+n.sort.direction)}),r(n.options.paginationCurrentPage,n.options.paginationPageSize,i))});n.gridApi.core.on.filterChanged(n,function(){if(r){i.filterColumns=[];var n=this.grid;angular.forEach(n.columns,function(n){var r=n.field,t=n.filters[0].term;t&&i.filterColumns.push(r+"#"+t)});i.filterColumns.length<1;r(n.options.paginationCurrentPage,n.options.paginationPageSize,i)}});t.pagination.on.paginationChanged(n,function(n,t){r&&r(n,t,i)});t.edit.on.afterCellEdit(n,function(t,i,r,f){u(t,i,r,f);n.$apply()})},gridMenuCustomItems:[{title:"Export Filtered Data As CSV",order:100,action:function(){}}]};r=function(i,r,u){var e=(i-1)*r,f="http://PdpApi/api/ResultsData?FirstRow="+e+"&PageSize="+r,o;return u.filterColumns&&(f+="&Filter="+encodeURIComponent(u.filterColumns)),u.sortColumns&&(f+="&Sort="+encodeURIComponent(u.sortColumns)),o=n,n.loading=!0,n.msg="",t.get(f).success(function(t){n.gridResul.totalItems=t.RecordCount;n.gridResul.data=t.Data}).error(function(n){alert("error getting data: "+n.ExceptionMessage)}).finally(function(){n.loading=!1})};u=function(i,r,u,f){if(u==f){n.msg="Value did not change";return}var e=i.SamplePK+"|"+i.Pest_Code+"|"+i.PdpYear+"|"+i.Com;return n.loading=!0,t.put("http://PdpApi/api/ResultsData",{rowkey:e,col:r.name,val:u}).success(function(){n.msg="successfully updated  row key:"+e+" Column:"+r.name+" newValue:"+u+" oldValue:"+f}).error(function(n){alert("error updating data: "+(n.ExceptionMessage?n.ExceptionMessage:n.Message))}).finally(function(){n.loading=!1})};f()})})(t=n.search||(n.search={}))}(app||(app={})),function(){"use strict";angular.module("app.models",[])}(),function(){"use strict";angular.module("app.search",[])}(),function(){"use strict";angular.module("app.services",[])}(),function(n){var t;(function(){"use strict"})(t=n.models||(n.models={}))}(app||(app={})),function(n){var t;(function(n){var t=function(){function n(n,t,i){this.$scope=n;this.$http=t;this.SearchService=i;this.showLoading=!0;this.load();this.outputPreferences=[{id:1,preference:"Analytical Results"},{id:2,preference:"Sample/Results"},{id:4,preference:"Summary of Findings"},{id:6,preference:"Summary of Findings by Origin"},{id:7,preference:"Summary of Findings by Claim"}];this.selectedOutputPreference=this.outputPreferences[0];this.resultsPreferences=[{id:2,preference:"Positive Detects Only"},{id:1,preference:"All Positive Detects + Non-Detects"},{id:4,preference:"Presumptive Tolerance Violations Only"}];this.selectedResultsPreference=this.resultsPreferences[0];this.checkAllCommodities=!1;this.checkAllPesticides=!1;this.checkSpecificTestClass=!1;this.checkAllYears=!1;this.showLoading=!1;this.makeSearchPanelVisible()}return n.prototype.specificClassChange=function(){this.allPesticidesChange(this.checkSpecificTestClass)},n.prototype.allPesticidesChange=function(){for(var n=0;n<this.pesticides.length;n++)this.pesticides[n].isChecked=this.checkAllPesticides},n.prototype.allCommoditiesChange=function(){for(var n=0;n<this.commodities.length;n++)this.commodities[n].isChecked=this.checkAllCommodities},n.prototype.allYearsChange=function(){for(var n=0;n<this.years.length;n++)this.years[n].isChecked=this.checkAllYears},n.prototype.search=function(){this.showLoading=!0;var u=function(n){return n.isChecked},n=_.filter(this.commodities,u),t=_.filter(this.pesticides,u),i=_.filter(this.testClasses,u),r=_.filter(this.years,u);switch(this.selectedOutputPreference.id){case 1:this.getAnalyticalResults1(n,t,i,r,this.selectedResultsPreference.id);break;case 2:this.getSampleResults1(n,t,i,r,this.selectedResultsPreference.id);break;case 3:this.getSummaryOfNdLods(n,t,i,r);break;case 4:this.getSummaryOfFindings1(n,t,i,r);break;case 5:this.getSummaryOfFindingsByLod(n,t,i,r);break;case 6:this.getSummaryOfFindingsByCountryOfOrigin1(n,t,i,r);break;case 7:this.getSummaryOfFindingsByClaim1(n,t,i,r)}},n.prototype.getAnalyticalResults=function(n,t,i,r,u){var f=this;this.SearchService.getAnalyticalResults(n,t,i,r,u).then(function(n){f.analyticalResults=n;f.showResultsPanel=!0;f.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#analyticalResultsGrid").jqGrid({datatype:"local",data:f.analyticalResults,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#analyticalResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:185,frozen:!0},{label:"Com",name:"commodity",width:50},{label:"Pest Code",name:"pesticideCode",width:50},{label:"Pest Name",name:"pesticideName",width:140},{label:"Tst",name:"testClass",width:45},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:50},{label:"Co1",name:"confirmationMethod",width:50},{label:"Co2",name:"confirmationMethod2",width:50},{label:"Ann",name:"annotate",width:50},{label:"Qua",name:"quantitate",width:50},{label:"Mean",name:"mean",width:50},{label:"Ext",name:"extract",width:50},{label:"Det",name:"determinative",width:50},{label:"Tol (ppm)",name:"tol",width:60}],viewrecords:!0,toolbarfilter:!0,caption:"<p align='center'><b>Analytical Results<\/b><\/p>"})})},n.prototype.getAnalatycalData=function(n,t,i,r,u){var f=this;this.SearchService.getAnalyticalResults(n,t,i,r,u).then(function(n){f.analyticalResults=n})},n.prototype.getAnalyticalResults1=function(n,t,i,r,u){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#analyticalResultsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetAnalyticalResults1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,altRows:!0,pager:"#analyticalResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:185,frozen:!0},{label:"Com",name:"commod",width:50},{label:"Pest Code",name:"pesticideCode",width:50},{label:"Pest Name",name:"pesticideName",width:140},{label:"Tst",name:"testClass",width:45},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp_",width:50},{label:"Co1",name:"confirm1",width:50},{label:"Co2",name:"confirm2",width:50},{label:"Ann",name:"annotate",width:50},{label:"Qua",name:"quantitate",width:50},{label:"Mean",name:"mean",width:50},{label:"Ext",name:"extract",width:50},{label:"Det",name:"determ",width:50},{label:"Tol (ppm)",name:"tol",width:65}],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,emptyrecords:"Scroll to bottom to retrieve new page",caption:"<p align='center'><b>Analytical Results<\/b><\/p>"});$("#analyticalResultsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#analyticalResultsGrid").jqGrid("navGrid","#analyticalResultsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#analyticalResultsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var f=jQuery(this).jqGrid("getGridParam"),e={commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u};$.post("/PDP/api/Info/ExportToExcelAnalyticalResults1/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u,filter:f.postData.filters,search:f.postData._search},function(n){var u=typeof n!="object"?JSON.parse(n):n,o="",f="",i,r,t,s,h,c,e;for(t in u[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"Sampleid":t="Sample ID";break;case"Pesticidecode":t="Pesticide Code";break;case"Pesticidename":t="Pesticide Name";break;case"Testclass":t="Test Class";break;case"Lod":t="LOD";break;case"Confirm1":t="Confirm 1";break;case"Confirm2":t="Confirm 2";break;case"Pp_":t="pp_";break;case"Tol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<u.length;i++){r="";for(t in u[i])r!=""&&(r+=","),r+=u[i][t];o+=r+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="AnalyticalResults.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSampleResults=function(n,t,i,r,u){var f=this;this.SearchService.getSampleResults(n,t,i,r,u).then(function(n){f.sampleResults=n;f.showResultsPanel=!0;f.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#sampleResultsGrid").jqGrid({datatype:"local",data:f.sampleResults,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,rowList:[100,500,1e3],pager:"#sampleResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:175},{label:"Com",name:"commodity",width:50},{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:35},{label:"Ann",name:"annotate",width:45},{label:"Mean",name:"mean",width:50},{label:"Type",name:"commodityType",width:50},{label:"Variety",name:"variety",width:75},{label:"Clm",name:"commodityClaim",width:40},{label:"Fac",name:"facilityType",width:40},{label:"Origin",name:"origin",width:40},{label:"Country",name:"country",width:55},{label:"State",name:"state",width:40},{label:"Qty",name:"quantity",width:40},{label:"Tol (ppm)]",name:"tol",width:60}],viewrecords:!0,gridview:!0,caption:"<p align='center'><b>Sample/Results<\/b><\/p>"})})},n.prototype.getSampleResults1=function(n,t,i,r,u){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#sampleResultsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSampleResults1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,altRows:!0,pager:"#sampleResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:175},{label:"Com",name:"commodity",width:50},{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:35},{label:"Ann",name:"annotate",width:45},{label:"Mean",name:"mean",width:50},{label:"Type",name:"commodityType",width:50},{label:"Variety",name:"variety",width:75},{label:"Clm",name:"commodityClaim",width:40},{label:"Fac",name:"facilityType",width:40},{label:"Origin",name:"origin",width:40},{label:"Country",name:"country",width:55},{label:"State",name:"state",width:40},{label:"Qty",name:"quantity",width:40},{label:"Tol (ppm)]",name:"tol",width:60}],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,emptyrecords:"Scroll to bottom to retrieve new page",caption:"<p align='center'><b>Sample/Results<\/b><\/p>"});$("#sampleResultsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#sampleResultsGrid").jqGrid("navGrid","#sampleResultsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#sampleResultsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var f=jQuery(this).jqGrid("getGridParam");f.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSampleResults1/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u,filter:f.postData.filters,search:f.postData._search},function(n){var u=typeof n!="object"?JSON.parse(n):n,o="",f="",i,r,t,s,h,c,e;for(t in u[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"Sampleid":t="Sample ID";break;case"Commoditytype":t="Commodity Type";break;case"Pesticidename":t="Pesticide Name";break;case"Pestcode":t="Pesticide Code";break;case"concentration":t="Concentration";break;case"Lod":t="LOD";break;case"annotate":t="Annotate";break;case"quantitate":t="Quantitate";break;case"Pp":t="pp_";break;case"mean":t="Mean";break;case"Commoditytype":t="Commod Type";break;case"variety":t="Variety";break;case"Commodityclaim":t="Commodity Claim";break;case"Facilitytype":t="Facility Type";break;case"origin":t="Origin";break;case"country":t="Country";break;case"state":t="State";break;case"quantity":t="Unit Count";break;case"Tol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<u.length;i++){r="";for(t in u[i])r!=""&&(r+=","),r+='"'+u[i][t]+'"';o+=r+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SampleResults.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSampleResults2=function(){this.showResultsPanel=!0;this.showSearchPanel=!1;var n={sortColumns:[],filterColumns:[]};this.$scope.gridResul={enableFiltering:!0,enableGridMenu:!0,exporterMenuCsv:!0,paginationPageSize:500,useExternalPagination:!0,useExternalSorting:!0,columnDefs:[{field:"PDP_Sample_ID",displayName:"Sample Id",visible:!1,enableSorting:!1},{field:"PdpYear",displayName:"Pdp Yr",filter:{term:"2014"},width:80},{field:"Com",width:70},{field:"Pest_Code",width:105},{field:"Pesticide_Name",displayName:"Pest Name",width:100},{field:"Concen",width:80},{field:"LOD",visible:!1},{field:"pp_"},{field:"Ann",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Qua"},{field:"Mean",enableFiltering:!1},{field:"Type",enableFiltering:!1},{field:"Variety",width:75},{field:"Clm",enableSorting:!1,enableFiltering:!1},{field:"Fac",enableSorting:!1,enableFiltering:!1},{field:"Origin",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Country",enableSorting:!1,enableFiltering:!1},{field:"State",enableSorting:!1,enableFiltering:!1},{field:"Qty",enableSorting:!1,enableFiltering:!1},{field:"Tol_ppm",enableSorting:!1,enableFiltering:!1}],onRegisterApi:function(t,i,r){this.$scope.gridApi=r;this.$scope.gridApi.core.on.sortChanged(this.$scope,function(r,u){this.getPage&&(n.sortColumns=[],u.length>0&&u.forEach(function(t){n.sortColumns.push(t.name+"#"+t.sort.direction)}),this.getPage(t,i,r.options.paginationCurrentPage,r.options.paginationPageSize,n))});this.$scope.gridApi.core.on.filterChanged(this.$scope,function(){if(this.getPage){n.filterColumns=[];var r=this.grid;angular.forEach(r.columns,function(t){var r=t.field,i=t.filters[0].term;i&&n.filterColumns.push(r+"#"+i)});n.filterColumns.length<1;this.getPage(t,i,r.options.paginationCurrentPage,r.options.paginationPageSize,n)}});r.pagination.on.paginationChanged(this.$scope,function(r,u){this.getPage&&this.getPage(t,i,r,u,n)});r.edit.on.afterCellEdit(this.$scope,function(n,t,i,r){this.editCellPut(n,t,i,r);this.$scope.apply()})},gridMenuCustomItems:[{title:"Export Filtered Data As CSV",order:100,action:function(){}}]};this.init(this.$http,this.$scope,n)},n.prototype.init=function(n,t,i){i.filterColumns.push("PdpYear#2013");this.getPage(n,t,1,500,i)},n.prototype.getPage=function(n,t,i,r,u){var e=(i-1)*r,f="http://PdpApi/api/ResultsData?FirstRow="+e+"&PageSize="+r,o;return u.filterColumns&&(f+="&Filter="+encodeURIComponent(u.filterColumns)),u.sortColumns&&(f+="&Sort="+encodeURIComponent(u.sortColumns)),o=t,n.get(f).success(function(n){alert(n.RecordCount);t.gridResul.totalItems=n.RecordCount;t.gridResul.data=n.Data}).error(function(n){alert("error getting data: "+n.ExceptionMessage)}).finally(function(){})},n.prototype.editCellPut=function(n,t,i,r){if(i!=r){var u=n.SamplePK+"|"+n.Pest_Code+"|"+n.PdpYear+"|"+n.Com;return this.$http.put("http://PdpApi/api/ResultsData",{rowkey:u,col:t.name,val:i}).success(function(){this.$scope.msg="successfully updated  row key:"+u+" Column:"+t.name+" newValue:"+i+" oldValue:"+r}).error(function(n){alert("error updating data: "+(n.ExceptionMessage?n.ExceptionMessage:n.Message))}).finally(function(){this.$scope.loading=!1})}},n.prototype.getSummaryOfNdLods=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfNdLods(n,t,i,r).then(function(n){u.summaryOfNd=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfNdGrid").jqGrid({datatype:"local",data:u.summaryOfNd,height:250,autowidth:!0,rowNum:100,pager:"#summaryOfNdGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName"},{label:"Commodity",name:"commodity"},{label:"Test Lab",name:"testLab"},{label:"Reported LOD",name:"reportedLod"},{label:"Unit pp_",name:"unitPp"},{label:"Number of Samples",name:"numberOfSamples"}],viewrecords:!0,caption:"Summary of LODs for Non-Detects"})})},n.prototype.getSummaryOfFindings=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindings(n,t,i,r).then(function(n){u.summaryOfFindings=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsGrid").jqGrid({datatype:"local",data:u.summaryOfFindings,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:175},{label:"Commodity",name:"commodity",width:175},{label:"# of Samples Analyzed",name:"samplesNumber",width:105},{label:"# of Samples W/Detects",name:"samplesDetects",width:105},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:110},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:115},{label:"Unit pp_",name:"unitPp",width:75},{label:"Tol (ppm)",name:"epatol",width:55},],viewrecords:!0,caption:"<p align='center'><b>Summary of Findings<\/b><\/p>"})})},n.prototype.getSummaryOfFindings1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindings1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:175},{label:"Commodity",name:"commodity",width:175},{label:"# of Samples Analyzed",name:"samplesNumber",width:105},{label:"# of Samples W/Detects",name:"samplesDetects",width:105},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:110},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:115},{label:"Unit pp_",name:"unitPp",width:75},{label:"Tol (ppm)",name:"epatol",width:55},],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,caption:"<p align='center'><b>Summary of Findings<\/b><\/p>"});$("#summaryOfFindingsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsGrid").jqGrid("navGrid","#summaryOfFindingsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindings1/",{commodities:n,pesticides:t,testClasses:i,years:r,filter:u.postData.filters,search:u.postData._search},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindings.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSummaryOfFindingsByLod=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByLod(n,t,i,r).then(function(n){u.summaryOfFindingsByLod=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByLodGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByLod,height:250,autowidth:!0,rowNum:100,pager:"#summaryOfFindingsByLodGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName"},{label:"Commodity",name:"commodity"},{label:"Distinct LOD",name:"distinctLod"},{label:"Unit pp_",name:"unitPp"},{label:"# of Samples Analyzed",name:"samplesNumber"},{label:"# of Samples Detects",name:"samplesDetects"},{label:"% of Samples Detects",name:"sampleDetectsPercent"},{label:"Min Value",name:"minValue"},{label:"Max Value",name:"maxValue"},{label:"Avg Value",name:"avgValue"},],viewrecords:!0,caption:"Summary of Findings by LOD"})})},n.prototype.getSummaryOfFindingsByCountryOfOrigin=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByCountryOfOrigin(n,t,i,r).then(function(n){u.summaryOfFindingsByCountry=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByCountryGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByCountry,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsByCountryGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:125},{label:"Origin",name:"origin",width:55},{label:"Country",name:"country",width:120},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:50},{label:"Tol (ppm)",name:"epatol",width:55}],viewrecords:!0,caption:"<p align='center'><b>Summary of Findings by Country of ORIGIN<\/b><\/p>"})})},n.prototype.getSummaryOfFindingsByCountryOfOrigin1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByCountryGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindingsByCountryOfOrigin1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsByCountryGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:125},{label:"Origin",name:"origin",width:55},{label:"Country",name:"country",width:120},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:50},{label:"Tol (ppm)",name:"epatol",width:55}],sortname:"pesticideName",sortorder:"desc",viewrecords:!0,scroll:1,caption:"<p align='center'><b>Summary of Findings by Country of ORIGIN<\/b><\/p>"});$("#summaryOfFindingsByCountryGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsByCountryGrid").jqGrid("navGrid","#summaryOfFindingsByCountryGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsByCountryGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindingsByCountryOfOrigin1/",{commodities:n,pesticides:t,testClasses:i,years:r},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"country":t="Country";break;case"origin":t="Origin";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindingsByCountry.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSummaryOfFindingsByClaim=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByClaim(n,t,i,r).then(function(n){u.summaryOfFindingsByClaim=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByClaimGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByClaim,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsByClaimGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:100},{label:"CLAIM on Product",name:"claim",width:125},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:40},{label:"Tol (ppm)",name:"epatol",width:65}],viewrecords:!0,caption:"<p align='center'><b>Summary of Findings by Product CLAIM<\/b><\/p>"})})},n.prototype.getSummaryOfFindingsByClaim1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";$("#summaryOfFindingsByClaimGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindingsByClaim1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsByClaimGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:100},{label:"CLAIM on Product",name:"claim",width:125},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:40},{label:"Tol (ppm)",name:"epatol",width:65}],sortname:"pesticideName",sortorder:"desc",viewrecords:!0,caption:"<p align='center'><b>Summary of Findings by Product CLAIM<\/b><\/p>"});$("#summaryOfFindingsByClaimGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsByClaimGrid").jqGrid("navGrid","#summaryOfFindingsByClaimGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsByClaimGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindingsByClaim1/",{commodities:n,pesticides:t,testClasses:i,years:r},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"Claim":t="Claim on Product";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindingsByClaim.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.makeSearchPanelVisible=function(){this.showResultsPanel=!1;this.showSearchPanel=!0},n.prototype.makeResultsPanelVisible=function(){this.showSearchPanel=!1;this.showResultsPanel=!0},n.prototype.loadCommodities=function(){var n=this;this.SearchService.getCommodities().then(function(t){n.commodities=t})},n.prototype.loadPesticides=function(){var n=this;this.SearchService.getPesticides().then(function(t){n.pesticides=t})},n.prototype.loadTestClasses=function(){var n=this;this.SearchService.getTestClasses().then(function(t){n.testClasses=t})},n.prototype.loadYears=function(){var n=this;this.SearchService.getYears().then(function(t){n.years=t})},n.prototype.load=function(){this.loadPesticides();this.loadCommodities();this.loadTestClasses();this.loadYears()},n.$inject=["$scope","$http","app.services.SearchService"],n}();n.SearchController=t;angular.module("app.search",["ui.grid","ui.grid.edit","ui.grid.pagination","ui.grid.selection","ui.grid.resizeColumns","ui.grid.exporter"]).controller("app.search.SearchController",["$scope","$http","app.services.SearchService",t]).controller("MainCtrl",function(n,t){function f(){i.filterColumns.push("PdpYear#2013");r(1,n.gridResul.paginationPageSize,i)}var i={sortColumns:[],filterColumns:[]},r,u;n.gridResul={enableFiltering:!0,enableGridMenu:!0,exporterMenuCsv:!0,paginationPageSize:500,useExternalPagination:!0,useExternalSorting:!0,columnDefs:[{field:"PDP_Sample_ID",displayName:"Sample Id",visible:!1,enableSorting:!1},{field:"PdpYear",displayName:"Pdp Yr",filter:{term:"2014"},width:80},{field:"Com",width:70},{field:"Pest_Code",width:105},{field:"Pesticide_Name",displayName:"Pest Name",width:100},{field:"Concen",width:80},{field:"LOD",visible:!1},{field:"pp_"},{field:"Ann",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Qua"},{field:"Mean",enableFiltering:!1},{field:"Type",enableFiltering:!1},{field:"Variety",width:75},{field:"Clm",enableSorting:!1,enableFiltering:!1},{field:"Fac",enableSorting:!1,enableFiltering:!1},{field:"Origin",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Country",enableSorting:!1,enableFiltering:!1},{field:"State",enableSorting:!1,enableFiltering:!1},{field:"Qty",enableSorting:!1,enableFiltering:!1},{field:"Tol_ppm",enableSorting:!1,enableFiltering:!1}],exporterAllDataFn:function(){return r(1,n.gridResul.totalItems,i).then(function(){r=null})},onRegisterApi:function(t){n.gridApi=t;n.gridApi.core.on.sortChanged(n,function(n,t){r&&(i.sortColumns=[],t.length>0&&t.forEach(function(n){i.sortColumns.push(n.name+"#"+n.sort.direction)}),r(n.options.paginationCurrentPage,n.options.paginationPageSize,i))});n.gridApi.core.on.filterChanged(n,function(){if(r){i.filterColumns=[];var n=this.grid;angular.forEach(n.columns,function(n){var r=n.field,t=n.filters[0].term;t&&i.filterColumns.push(r+"#"+t)});i.filterColumns.length<1;r(n.options.paginationCurrentPage,n.options.paginationPageSize,i)}});t.pagination.on.paginationChanged(n,function(n,t){r&&r(n,t,i)});t.edit.on.afterCellEdit(n,function(t,i,r,f){u(t,i,r,f);n.$apply()})},gridMenuCustomItems:[{title:"Export Filtered Data As CSV",order:100,action:function(){}}]};r=function(i,r,u){var e=(i-1)*r,f="http://PdpApi/api/ResultsData?FirstRow="+e+"&PageSize="+r,o;return u.filterColumns&&(f+="&Filter="+encodeURIComponent(u.filterColumns)),u.sortColumns&&(f+="&Sort="+encodeURIComponent(u.sortColumns)),o=n,n.loading=!0,n.msg="",t.get(f).success(function(t){n.gridResul.totalItems=t.RecordCount;n.gridResul.data=t.Data}).error(function(n){alert("error getting data: "+n.ExceptionMessage)}).finally(function(){n.loading=!1})};u=function(i,r,u,f){if(u==f){n.msg="Value did not change";return}var e=i.SamplePK+"|"+i.Pest_Code+"|"+i.PdpYear+"|"+i.Com;return n.loading=!0,t.put("http://PdpApi/api/ResultsData",{rowkey:e,col:r.name,val:u}).success(function(){n.msg="successfully updated  row key:"+e+" Column:"+r.name+" newValue:"+u+" oldValue:"+f}).error(function(n){alert("error updating data: "+(n.ExceptionMessage?n.ExceptionMessage:n.Message))}).finally(function(){n.loading=!1})};f()})})(t=n.search||(n.search={}))}(app||(app={})),function(n){var t;(function(n){var t=function(){function n(n,t,i){this.$scope=n;this.$http=t;this.SearchService=i;this.showLoading=!0;this.load();this.outputPreferences=[{id:1,preference:"Analytical Results"},{id:2,preference:"Sample/Results"},{id:4,preference:"Summary of Findings"},{id:6,preference:"Summary of Findings by Origin"},{id:7,preference:"Summary of Findings by Claim"}];this.selectedOutputPreference=this.outputPreferences[0];this.resultsPreferences=[{id:2,preference:"Positive Detects Only"},{id:1,preference:"All Positive Detects + Non-Detects"},{id:4,preference:"Presumptive Tolerance Violations Only"}];this.selectedResultsPreference=this.resultsPreferences[0];this.checkAllCommodities=!1;this.checkAllPesticides=!1;this.checkSpecificTestClass=!1;this.checkAllYears=!1;this.showLoading=!1;this.makeSearchPanelVisible()}return n.prototype.specificClassChange=function(){this.allPesticidesChange(this.checkSpecificTestClass)},n.prototype.allPesticidesChange=function(){for(var n=0;n<this.pesticides.length;n++)this.pesticides[n].isChecked=this.checkAllPesticides},n.prototype.allCommoditiesChange=function(){for(var n=0;n<this.commodities.length;n++)this.commodities[n].isChecked=this.checkAllCommodities},n.prototype.allYearsChange=function(){for(var n=0;n<this.years.length;n++)this.years[n].isChecked=this.checkAllYears},n.prototype.back=function(){this.showResultsPanel=!1;this.showSearchPanel=!0;this.showLoading=!1},n.prototype.search=function(){this.showLoading=!0;var u=function(n){return n.isChecked},n=_.filter(this.commodities,u),t=_.filter(this.pesticides,u),i=_.filter(this.testClasses,u),r=_.filter(this.years,u);switch(this.selectedOutputPreference.id){case 1:this.getAnalyticalResults1(n,t,i,r,this.selectedResultsPreference.id);break;case 2:this.getSampleResults1(n,t,i,r,this.selectedResultsPreference.id);break;case 3:this.getSummaryOfNdLods(n,t,i,r);break;case 4:this.getSummaryOfFindings1(n,t,i,r);break;case 5:this.getSummaryOfFindingsByLod(n,t,i,r);break;case 6:this.getSummaryOfFindingsByCountryOfOrigin1(n,t,i,r);break;case 7:this.getSummaryOfFindingsByClaim1(n,t,i,r)}},n.prototype.getAnalyticalResults=function(n,t,i,r,u){var f=this;this.SearchService.getAnalyticalResults(n,t,i,r,u).then(function(n){f.analyticalResults=n;f.showResultsPanel=!0;f.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#analyticalResultsGrid").jqGrid({datatype:"local",data:f.analyticalResults,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#analyticalResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:185,frozen:!0},{label:"Com",name:"commodity",width:50},{label:"Pest Code",name:"pesticideCode",width:50},{label:"Pest Name",name:"pesticideName",width:140},{label:"Tst",name:"testClass",width:45},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:50},{label:"Co1",name:"confirmationMethod",width:50},{label:"Co2",name:"confirmationMethod2",width:50},{label:"Ann",name:"annotate",width:50},{label:"Qua",name:"quantitate",width:50},{label:"Mean",name:"mean",width:50},{label:"Ext",name:"extract",width:50},{label:"Det",name:"determinative",width:50},{label:"Tol (ppm)",name:"tol",width:60}],viewrecords:!0,toolbarfilter:!0,loadBeforeSend:function(){$("#analyticalResultsGrid").show();t.hide()},loadComplete:function(){var i=$("#analyticalResultsGrid").getGridParam(),n=$("#analyticalResultsGrid")[0];n.p.reccount===0?($("#analyticalResultsGrid").hide(),t.show()):($("#analyticalResultsGrid").show(),t.hide())},caption:"<p align='center'><b>Analytical Results<\/b><\/p>"});t.insertAfter($("#analyticalResultsGrid").parent())})},n.prototype.getAnalatycalData=function(n,t,i,r,u){var f=this;this.SearchService.getAnalyticalResults(n,t,i,r,u).then(function(n){f.analyticalResults=n})},n.prototype.getAnalyticalResults1=function(n,t,i,r,u){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var f=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#analyticalResultsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetAnalyticalResults1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,altRows:!0,pager:"#analyticalResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:185,frozen:!0},{label:"Com",name:"commod",width:50},{label:"Pest Code",name:"pesticideCode",width:50},{label:"Pest Name",name:"pesticideName",width:140},{label:"Tst",name:"testClass",width:45},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp_",width:50},{label:"Co1",name:"confirm1",width:50},{label:"Co2",name:"confirm2",width:50},{label:"Ann",name:"annotate",width:50},{label:"Qua",name:"quantitate",width:50},{label:"Mean",name:"mean",width:50},{label:"Ext",name:"extract",width:50},{label:"Det",name:"determ",width:50},{label:"Tol (ppm)",name:"tol",width:65}],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,loadBeforeSend:function(){$("#analyticalResultsGrid").show();f.hide()},loadComplete:function(){var t=$("#analyticalResultsGrid").getGridParam(),n=$("#analyticalResultsGrid")[0];n.p.reccount===0?($("#analyticalResultsGrid").hide(),f.show()):($("#analyticalResultsGrid").show(),f.hide())},caption:"<p align='center'><b>Analytical Results<\/b><\/p>"});f.insertAfter($("#analyticalResultsGrid").parent());$("#analyticalResultsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#analyticalResultsGrid").jqGrid("navGrid","#analyticalResultsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#analyticalResultsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var f=jQuery(this).jqGrid("getGridParam"),e={commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u};$.post("/PDP/api/Info/ExportToExcelAnalyticalResults1/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u,filter:f.postData.filters,search:f.postData._search},function(n){var u=typeof n!="object"?JSON.parse(n):n,o="",f="",i,r,t,s,h,c,e;for(t in u[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"Sampleid":t="Sample ID";break;case"Pesticidecode":t="Pesticide Code";break;case"Pesticidename":t="Pesticide Name";break;case"Testclass":t="Test Class";break;case"Lod":t="LOD";break;case"Confirm1":t="Confirm 1";break;case"Confirm2":t="Confirm 2";break;case"Pp_":t="pp_";break;case"Tol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<u.length;i++){r="";for(t in u[i])r!=""&&(r+=","),r+=u[i][t];o+=r+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="AnalyticalResults.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSampleResults=function(n,t,i,r,u){var f=this;this.SearchService.getSampleResults(n,t,i,r,u).then(function(n){f.sampleResults=n;f.showResultsPanel=!0;f.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#sampleResultsGrid").jqGrid({datatype:"local",data:f.sampleResults,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,rowList:[100,500,1e3],pager:"#sampleResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:175},{label:"Com",name:"commodity",width:50},{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:35},{label:"Ann",name:"annotate",width:45},{label:"Mean",name:"mean",width:50},{label:"Type",name:"commodityType",width:50},{label:"Variety",name:"variety",width:75},{label:"Clm",name:"commodityClaim",width:40},{label:"Fac",name:"facilityType",width:40},{label:"Origin",name:"origin",width:40},{label:"Country",name:"country",width:55},{label:"State",name:"state",width:40},{label:"Qty",name:"quantity",width:40},{label:"Tol (ppm)]",name:"tol",width:60}],viewrecords:!0,gridview:!0,loadBeforeSend:function(){$("#sampleResultsGrid").show();t.hide()},loadComplete:function(){var i=$("#sampleResultsGrid").getGridParam(),n=$("#sampleResultsGrid")[0];n.p.reccount===0?($("#sampleResultsGrid").hide(),t.show()):($("#sampleResultsGrid").show(),t.hide())},caption:"<p align='center'><b>Sample/Results<\/b><\/p>"});t.insertAfter($("#sampleResultsGrid").parent())})},n.prototype.getSampleResults1=function(n,t,i,r,u){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var f=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#sampleResultsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSampleResults1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,altRows:!0,pager:"#sampleResultsGridPager",colModel:[{label:"Sample ID#",name:"sampleId",width:175},{label:"Com",name:"commodity",width:50},{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Concen",name:"concentration",width:75},{label:"LOD",name:"lod",width:75},{label:"pp_",name:"pp",width:35},{label:"Ann",name:"annotate",width:45},{label:"Mean",name:"mean",width:50},{label:"Type",name:"commodityType",width:50},{label:"Variety",name:"variety",width:75},{label:"Clm",name:"commodityClaim",width:40},{label:"Fac",name:"facilityType",width:40},{label:"Origin",name:"origin",width:40},{label:"Country",name:"country",width:55},{label:"State",name:"state",width:40},{label:"Qty",name:"quantity",width:40},{label:"Tol (ppm)]",name:"tol",width:60}],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,loadBeforeSend:function(){$("#sampleResultsGrid").show();f.hide()},loadComplete:function(){var t=$("#sampleResultsGrid").getGridParam(),n=$("#sampleResultsGrid")[0];n.p.reccount===0?($("#sampleResultsGrid").hide(),f.show()):($("#sampleResultsGrid").show(),f.hide())},caption:"<p align='center'><b>Sample/Results<\/b><\/p>"});f.insertAfter($("#sampleResultsGrid").parent());$("#sampleResultsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#sampleResultsGrid").jqGrid("navGrid","#sampleResultsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#sampleResultsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var f=jQuery(this).jqGrid("getGridParam");f.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSampleResults1/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u,filter:f.postData.filters,search:f.postData._search},function(n){var u=typeof n!="object"?JSON.parse(n):n,o="",f="",i,r,t,s,h,c,e;for(t in u[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"Sampleid":t="Sample ID";break;case"Commoditytype":t="Commodity Type";break;case"Pesticidename":t="Pesticide Name";break;case"Pestcode":t="Pesticide Code";break;case"concentration":t="Concentration";break;case"Lod":t="LOD";break;case"annotate":t="Annotate";break;case"quantitate":t="Quantitate";break;case"Pp":t="pp_";break;case"mean":t="Mean";break;case"Commoditytype":t="Commod Type";break;case"variety":t="Variety";break;case"Commodityclaim":t="Commodity Claim";break;case"Facilitytype":t="Facility Type";break;case"origin":t="Origin";break;case"country":t="Country";break;case"state":t="State";break;case"quantity":t="Unit Count";break;case"Tol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<u.length;i++){r="";for(t in u[i])r!=""&&(r+=","),r+='"'+u[i][t]+'"';o+=r+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SampleResults.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSampleResults2=function(){this.showResultsPanel=!0;this.showSearchPanel=!1;var n={sortColumns:[],filterColumns:[]};this.$scope.gridResul={enableFiltering:!0,enableGridMenu:!0,exporterMenuCsv:!0,paginationPageSize:500,useExternalPagination:!0,useExternalSorting:!0,columnDefs:[{field:"PDP_Sample_ID",displayName:"Sample Id",visible:!1,enableSorting:!1},{field:"PdpYear",displayName:"Pdp Yr",filter:{term:"2014"},width:80},{field:"Com",width:70},{field:"Pest_Code",width:105},{field:"Pesticide_Name",displayName:"Pest Name",width:100},{field:"Concen",width:80},{field:"LOD",visible:!1},{field:"pp_"},{field:"Ann",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Qua"},{field:"Mean",enableFiltering:!1},{field:"Type",enableFiltering:!1},{field:"Variety",width:75},{field:"Clm",enableSorting:!1,enableFiltering:!1},{field:"Fac",enableSorting:!1,enableFiltering:!1},{field:"Origin",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Country",enableSorting:!1,enableFiltering:!1},{field:"State",enableSorting:!1,enableFiltering:!1},{field:"Qty",enableSorting:!1,enableFiltering:!1},{field:"Tol_ppm",enableSorting:!1,enableFiltering:!1}],onRegisterApi:function(t,i,r){this.$scope.gridApi=r;this.$scope.gridApi.core.on.sortChanged(this.$scope,function(r,u){this.getPage&&(n.sortColumns=[],u.length>0&&u.forEach(function(t){n.sortColumns.push(t.name+"#"+t.sort.direction)}),this.getPage(t,i,r.options.paginationCurrentPage,r.options.paginationPageSize,n))});this.$scope.gridApi.core.on.filterChanged(this.$scope,function(){if(this.getPage){n.filterColumns=[];var r=this.grid;angular.forEach(r.columns,function(t){var r=t.field,i=t.filters[0].term;i&&n.filterColumns.push(r+"#"+i)});n.filterColumns.length<1;this.getPage(t,i,r.options.paginationCurrentPage,r.options.paginationPageSize,n)}});r.pagination.on.paginationChanged(this.$scope,function(r,u){this.getPage&&this.getPage(t,i,r,u,n)});r.edit.on.afterCellEdit(this.$scope,function(n,t,i,r){this.editCellPut(n,t,i,r);this.$scope.apply()})},gridMenuCustomItems:[{title:"Export Filtered Data As CSV",order:100,action:function(){}}]};this.init(this.$http,this.$scope,n)},n.prototype.init=function(n,t,i){i.filterColumns.push("PdpYear#2013");this.getPage(n,t,1,500,i)},n.prototype.getPage=function(n,t,i,r,u){var e=(i-1)*r,f="http://PdpApi/api/ResultsData?FirstRow="+e+"&PageSize="+r,o;return u.filterColumns&&(f+="&Filter="+encodeURIComponent(u.filterColumns)),u.sortColumns&&(f+="&Sort="+encodeURIComponent(u.sortColumns)),o=t,n.get(f).success(function(n){alert(n.RecordCount);t.gridResul.totalItems=n.RecordCount;t.gridResul.data=n.Data}).error(function(n){alert("error getting data: "+n.ExceptionMessage)}).finally(function(){})},n.prototype.editCellPut=function(n,t,i,r){if(i!=r){var u=n.SamplePK+"|"+n.Pest_Code+"|"+n.PdpYear+"|"+n.Com;return this.$http.put("http://PdpApi/api/ResultsData",{rowkey:u,col:t.name,val:i}).success(function(){this.$scope.msg="successfully updated  row key:"+u+" Column:"+t.name+" newValue:"+i+" oldValue:"+r}).error(function(n){alert("error updating data: "+(n.ExceptionMessage?n.ExceptionMessage:n.Message))}).finally(function(){this.$scope.loading=!1})}},n.prototype.getSummaryOfNdLods=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfNdLods(n,t,i,r).then(function(n){u.summaryOfNd=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfNdGrid").jqGrid({datatype:"local",data:u.summaryOfNd,height:250,autowidth:!0,rowNum:100,pager:"#summaryOfNdGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName"},{label:"Commodity",name:"commodity"},{label:"Test Lab",name:"testLab"},{label:"Reported LOD",name:"reportedLod"},{label:"Unit pp_",name:"unitPp"},{label:"Number of Samples",name:"numberOfSamples"}],viewrecords:!0,loadBeforeSend:function(){$("#summaryOfNdGrid").show();t.hide()},loadComplete:function(){var i=$("#summaryOfNdGrid").getGridParam(),n=$("#summaryOfNdGrid")[0];n.p.reccount===0?($("#summaryOfNdGrid").hide(),t.show()):($("#summaryOfNdGrid").show(),t.hide())},caption:"Summary of LODs for Non-Detects"});t.insertAfter($("#summaryOfNdGrid").parent())})},n.prototype.getSummaryOfFindings=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindings(n,t,i,r).then(function(n){u.summaryOfFindings=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsGrid").jqGrid({datatype:"local",data:u.summaryOfFindings,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:175},{label:"Commodity",name:"commodity",width:175},{label:"# of Samples Analyzed",name:"samplesNumber",width:105},{label:"# of Samples W/Detects",name:"samplesDetects",width:105},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:110},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:115},{label:"Unit pp_",name:"unitPp",width:75},{label:"Tol (ppm)",name:"epatol",width:55},],viewrecords:!0,loadBeforeSend:function(){$("#summaryOfFindingsGrid").show();t.hide()},loadComplete:function(){var i=$("#summaryOfFindingsGrid").getGridParam(),n=$("#summaryOfFindingsGrid")[0];n.p.reccount===0?($("#summaryOfFindingsGrid").hide(),t.show()):($("#summaryOfFindingsGrid").show(),t.hide())},caption:"<p align='center'><b>Summary of Findings<\/b><\/p>"});t.remove();t.insertAfter($("#summaryOfFindingsGrid").parent())})},n.prototype.getSummaryOfFindings1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var u=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindings1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:175},{label:"Commodity",name:"commodity",width:175},{label:"# of Samples Analyzed",name:"samplesNumber",width:105},{label:"# of Samples W/Detects",name:"samplesDetects",width:105},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:110},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:115},{label:"Unit pp_",name:"unitPp",width:75},{label:"Tol (ppm)",name:"epatol",width:55},],sortname:"sampleId",sortorder:"desc",viewrecords:!0,scroll:1,loadBeforeSend:function(){$("#summaryOfFindingsGrid").show();u.hide()},loadComplete:function(){var t=$("#summaryOfFindingsGrid").getGridParam(),n=$("#summaryOfFindingsGrid")[0];n.p.reccount===0?($("#summaryOfFindingsGrid").hide(),u.show()):($("#summaryOfFindingsGrid").show(),u.hide())},caption:"<p align='center'><b>Summary of Findings<\/b><\/p>"});u.insertAfter($("#summaryOfFindingsGrid").parent());$("#summaryOfFindingsGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsGrid").jqGrid("navGrid","#summaryOfFindingsGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindings1/",{commodities:n,pesticides:t,testClasses:i,years:r,filter:u.postData.filters,search:u.postData._search},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindings.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSummaryOfFindingsByLod=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByLod(n,t,i,r).then(function(n){u.summaryOfFindingsByLod=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsByLodGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByLod,height:250,autowidth:!0,rowNum:100,pager:"#summaryOfFindingsByLodGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName"},{label:"Commodity",name:"commodity"},{label:"Distinct LOD",name:"distinctLod"},{label:"Unit pp_",name:"unitPp"},{label:"# of Samples Analyzed",name:"samplesNumber"},{label:"# of Samples Detects",name:"samplesDetects"},{label:"% of Samples Detects",name:"sampleDetectsPercent"},{label:"Min Value",name:"minValue"},{label:"Max Value",name:"maxValue"},{label:"Avg Value",name:"avgValue"},],viewrecords:!0,loadBeforeSend:function(){$("#summaryOfFindingsByLodGrid").show();t.hide()},loadComplete:function(){var i=$("#summaryOfFindingsByLodGrid").getGridParam(),n=$("#summaryOfFindingsByLodGrid")[0];n.p.reccount===0?($("#summaryOfFindingsByLodGrid").hide(),t.show()):($("#summaryOfFindingsByLodGrid").show(),t.hide())},caption:"Summary of Findings by LOD"});t.insertAfter($("#summaryOfFindingsByLodGrid").parent())})},n.prototype.getSummaryOfFindingsByCountryOfOrigin=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByCountryOfOrigin(n,t,i,r).then(function(n){u.summaryOfFindingsByCountry=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsByCountryGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByCountry,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsByCountryGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:125},{label:"Origin",name:"origin",width:55},{label:"Country",name:"country",width:120},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:50},{label:"Tol (ppm)",name:"epatol",width:55}],viewrecords:!0,loadBeforeSend:function(){$("#summaryOfFindingsByCountryGrid").show();t.hide()},loadComplete:function(){var i=$("#summaryOfFindingsByCountryGrid").getGridParam(),n=$("#summaryOfFindingsByCountryGrid")[0];n.p.reccount===0?($("#summaryOfFindingsByCountryGrid").hide(),t.show()):($("#summaryOfFindingsByCountryGrid").show(),t.hide())},caption:"<p align='center'><b>Summary of Findings by Country of ORIGIN<\/b><\/p>"});t.insertAfter($("#summaryOfFindingsByCountryGrid").parent())})},n.prototype.getSummaryOfFindingsByCountryOfOrigin1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var u=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsByCountryGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindingsByCountryOfOrigin1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsByCountryGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:125},{label:"Origin",name:"origin",width:55},{label:"Country",name:"country",width:120},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:50},{label:"Tol (ppm)",name:"epatol",width:55}],sortname:"pesticideName",sortorder:"desc",viewrecords:!0,scroll:1,loadBeforeSend:function(){$("#summaryOfFindingsByCountryGrid").show();u.hide()},loadComplete:function(){var t=$("#summaryOfFindingsByCountryGrid").getGridParam(),n=$("#summaryOfFindingsByCountryGrid")[0];n.p.reccount===0?($("#summaryOfFindingsByCountryGrid").hide(),u.show()):($("#summaryOfFindingsByCountryGrid").show(),u.hide())},caption:"<p align='center'><b>Summary of Findings by Country of ORIGIN<\/b><\/p>"});u.insertAfter($("#summaryOfFindingsByCountryGrid").parent());$("#summaryOfFindingsByCountryGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsByCountryGrid").jqGrid("navGrid","#summaryOfFindingsByCountryGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsByCountryGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindingsByCountryOfOrigin1/",{commodities:n,pesticides:t,testClasses:i,years:r},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"country":t="Country";break;case"origin":t="Origin";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindingsByCountry.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.getSummaryOfFindingsByClaim=function(n,t,i,r){var u=this;this.SearchService.getSummaryOfFindingsByClaim(n,t,i,r).then(function(n){u.summaryOfFindingsByClaim=n;u.showResultsPanel=!0;u.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var t=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsByClaimGrid").jqGrid({datatype:"local",data:u.summaryOfFindingsByClaim,height:340,autowidth:!0,shrinkToFit:!1,width:780,rowNum:100,pager:"#summaryOfFindingsByClaimGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:100},{label:"CLAIM on Product",name:"claim",width:125},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:40},{label:"Tol (ppm)",name:"epatol",width:65}],viewrecords:!0,loadBeforeSend:function(){$("#summaryOfFindingsByClaimGrid").show();t.hide()},loadComplete:function(){var i=$("#summaryOfFindingsByClaimGrid").getGridParam(),n=$("#summaryOfFindingsByClaimGrid")[0];n.p.reccount===0?($("#summaryOfFindingsByClaimGrid").hide(),t.show()):($("#summaryOfFindingsByClaimGrid").show(),t.hide())},caption:"<p align='center'><b>Summary of Findings by Product CLAIM<\/b><\/p>"});t.insertAfter($("#summaryOfFindingsByClaimGrid").parent())})},n.prototype.getSummaryOfFindingsByClaim1=function(n,t,i,r){this.showResultsPanel=!0;this.showSearchPanel=!1;$.jgrid.defaults.responsive=!0;$.jgrid.defaults.styleUI="Bootstrap";var u=$("<div><BR><BR><BR><P>No data was found for the selected search criteria.  Please review the Commodity History and/or Pesticide History tabs at top to see which years included your commodity or pesticide of interest.<\/P><\/div>");$("#summaryOfFindingsByClaimGrid").jqGrid({datatype:"json",url:"/PDP/api/Info/GetSummaryOfFindingsByClaim1/",postData:{commodities:n,pesticides:t,testClasses:i,years:r},beforeRequest:function(){var n=jQuery(this).jqGrid("getGridParam"),t=n.url.split("?").shift(),i={page:n.page,rows:n.rowNum,sidx:n.postData.sidx,sord:n.postData.sord,search:n.postData._search,filter:n.postData.filters};n.url=t+"?"+jQuery.param(i)},mtype:"POST",height:500,autowidth:!0,shrinkToFit:!1,width:780,rowNum:1e3,pager:"#summaryOfFindingsByClaimGridPager",colModel:[{label:"Pesticide Name",name:"pesticideName",width:140},{label:"Commodity",name:"commodity",width:100},{label:"CLAIM on Product",name:"claim",width:125},{label:"# of Samples Analyzed",name:"samplesNumber",width:100},{label:"# of Samples W/Detects",name:"samplesDetects",width:100},{label:"% of Samples W/Detects",name:"sampleDetectsPercent",width:100},{label:"Min Detect",name:"minValue",width:75},{label:"Max Detect",name:"maxValue",width:75},{label:"Range of LODs",name:"rangeOfLods",width:75},{label:"Unit pp_",name:"unitPp",width:40},{label:"Tol (ppm)",name:"epatol",width:65}],sortname:"pesticideName",sortorder:"desc",viewrecords:!0,loadBeforeSend:function(){$("#summaryOfFindingsByClaimGrid").show();u.hide()},loadComplete:function(){var t=$("#summaryOfFindingsByClaimGrid").getGridParam(),n=$("#summaryOfFindingsByClaimGrid")[0];n.p.reccount===0?($("#summaryOfFindingsByClaimGrid").hide(),u.show()):($("#summaryOfFindingsByClaimGrid").show(),u.hide())},caption:"<p align='center'><b>Summary of Findings by Product CLAIM<\/b><\/p>"});u.insertAfter($("#summaryOfFindingsByClaimGrid").parent());$("#summaryOfFindingsByClaimGrid").jqGrid("filterToolbar",{autosearch:!0,stringResult:!0,searchOnEnter:!0,defaultSearch:"cn"});$("#summaryOfFindingsByClaimGrid").jqGrid("navGrid","#summaryOfFindingsByClaimGridPager",{search:!0,add:!1,edit:!1,del:!1,refresh:!0}).navButtonAdd("#summaryOfFindingsByClaimGridPager",{caption:"Export to Excel",buttonicon:"ui-icon-disk",onClickButton:function(){var u=jQuery(this).jqGrid("getGridParam");u.reccount<1e5;$.post("/PDP/api/Info/ExportToExcelSummaryOfFindingsByClaim1/",{commodities:n,pesticides:t,testClasses:i,years:r},function(n){var r=typeof n!="object"?JSON.parse(n):n,o="",f="",i,u,t,s,h,c,e;for(t in r[0]){t=t.charAt(0).toUpperCase()+t.substring(1).toLowerCase();switch(t){case"commodity":t="Commodity";break;case"Claim":t="Claim on Product";break;case"Samplesnumber":t="Number of Samples Analyzed";break;case"Pesticidename":t="Pesticide Name";break;case"Samplesdetects":t="Number of Samples with Detects";break;case"Sampledetectspercent":t="Pct of Samples with Detects";break;case"Minvalue":t="Min Detect";break;case"Maxvalue":t="Max Detect";break;case"Rangeoflods":t="LOD Range";break;case"Unitpp":t="pp_";break;case"Epatol":t="EPA Tolerance (ppm)"}f+=t+","}for(f=f.slice(0,-1),o+=f+"\r\n",i=0;i<r.length;i++){u="";for(t in r[i])u!=""&&(u+=","),u+=r[i][t]==null?'" "':'"'+r[i][t]+'"';o+=u+"\r\n"}s=new Blob([o],{type:"text/csv;charset=utf8;"});h="SummaryOfFindingsByClaim.csv";window.navigator.msSaveOrOpenBlob?window.navigator.msSaveOrOpenBlob(s,h):(c=URL.createObjectURL(s),e=document.createElement("a"),e.href=c,e.setAttribute("download",h),e.click())})},position:"last"})},n.prototype.makeSearchPanelVisible=function(){this.showResultsPanel=!1;this.showSearchPanel=!0},n.prototype.makeResultsPanelVisible=function(){this.showSearchPanel=!1;this.showResultsPanel=!0},n.prototype.loadCommodities=function(){var n=this;this.SearchService.getCommodities().then(function(t){n.commodities=t})},n.prototype.loadPesticides=function(){var n=this;this.SearchService.getPesticides().then(function(t){n.pesticides=t})},n.prototype.loadTestClasses=function(){var n=this;this.SearchService.getTestClasses().then(function(t){n.testClasses=t})},n.prototype.loadYears=function(){var n=this;this.SearchService.getYears().then(function(t){n.years=t})},n.prototype.loadAboutMessage=function(){var n=this;this.SearchService.getAboutMessage().then(function(t){n.aboutMessage=t})},n.prototype.load=function(){this.loadPesticides();this.loadCommodities();this.loadTestClasses();this.loadYears();this.loadAboutMessage()},n.$inject=["$scope","$http","app.services.SearchService"],n}();n.SearchController=t;angular.module("app.search",["ui.grid","ui.grid.edit","ui.grid.pagination","ui.grid.selection","ui.grid.resizeColumns","ui.grid.exporter"]).controller("app.search.SearchController",["$scope","$http","app.services.SearchService",t]).controller("MainCtrl",function(n,t){function f(){i.filterColumns.push("PdpYear#2013");r(1,n.gridResul.paginationPageSize,i)}var i={sortColumns:[],filterColumns:[]},r,u;n.gridResul={enableFiltering:!0,enableGridMenu:!0,exporterMenuCsv:!0,paginationPageSize:500,useExternalPagination:!0,useExternalSorting:!0,columnDefs:[{field:"PDP_Sample_ID",displayName:"Sample Id",visible:!1,enableSorting:!1},{field:"PdpYear",displayName:"Pdp Yr",filter:{term:"2014"},width:80},{field:"Com",width:70},{field:"Pest_Code",width:105},{field:"Pesticide_Name",displayName:"Pest Name",width:100},{field:"Concen",width:80},{field:"LOD",visible:!1},{field:"pp_"},{field:"Ann",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Qua"},{field:"Mean",enableFiltering:!1},{field:"Type",enableFiltering:!1},{field:"Variety",width:75},{field:"Clm",enableSorting:!1,enableFiltering:!1},{field:"Fac",enableSorting:!1,enableFiltering:!1},{field:"Origin",visible:!1,enableSorting:!1,enableFiltering:!1},{field:"Country",enableSorting:!1,enableFiltering:!1},{field:"State",enableSorting:!1,enableFiltering:!1},{field:"Qty",enableSorting:!1,enableFiltering:!1},{field:"Tol_ppm",enableSorting:!1,enableFiltering:!1}],exporterAllDataFn:function(){return r(1,n.gridResul.totalItems,i).then(function(){r=null})},onRegisterApi:function(t){n.gridApi=t;n.gridApi.core.on.sortChanged(n,function(n,t){r&&(i.sortColumns=[],t.length>0&&t.forEach(function(n){i.sortColumns.push(n.name+"#"+n.sort.direction)}),r(n.options.paginationCurrentPage,n.options.paginationPageSize,i))});n.gridApi.core.on.filterChanged(n,function(){if(r){i.filterColumns=[];var n=this.grid;angular.forEach(n.columns,function(n){var r=n.field,t=n.filters[0].term;t&&i.filterColumns.push(r+"#"+t)});i.filterColumns.length<1;r(n.options.paginationCurrentPage,n.options.paginationPageSize,i)}});t.pagination.on.paginationChanged(n,function(n,t){r&&r(n,t,i)});t.edit.on.afterCellEdit(n,function(t,i,r,f){u(t,i,r,f);n.$apply()})},gridMenuCustomItems:[{title:"Export Filtered Data As CSV",order:100,action:function(){}}]};r=function(i,r,u){var e=(i-1)*r,f="http://PdpApi/api/ResultsData?FirstRow="+e+"&PageSize="+r,o;return u.filterColumns&&(f+="&Filter="+encodeURIComponent(u.filterColumns)),u.sortColumns&&(f+="&Sort="+encodeURIComponent(u.sortColumns)),o=n,n.loading=!0,n.msg="",t.get(f).success(function(t){n.gridResul.totalItems=t.RecordCount;n.gridResul.data=t.Data}).error(function(n){alert("error getting data: "+n.ExceptionMessage)}).finally(function(){n.loading=!1})};u=function(i,r,u,f){if(u==f){n.msg="Value did not change";return}var e=i.SamplePK+"|"+i.Pest_Code+"|"+i.PdpYear+"|"+i.Com;return n.loading=!0,t.put("http://PdpApi/api/ResultsData",{rowkey:e,col:r.name,val:u}).success(function(){n.msg="successfully updated  row key:"+e+" Column:"+r.name+" newValue:"+u+" oldValue:"+f}).error(function(n){alert("error updating data: "+(n.ExceptionMessage?n.ExceptionMessage:n.Message))}).finally(function(){n.loading=!1})};f()})})(t=n.search||(n.search={}))}(app||(app={})),function(n){var t;(function(n){"use strict";function i(n){return new t(n)}var t=function(){function n(n){this.$http=n}return n.prototype.getPesticides=function(){return this.$http.get("/PDP/api/Info/GetPesticides/").then(function(n){return n.data})},n.prototype.getCommodities=function(){return this.$http.get("/PDP/api/Info/GetCommodities/").then(function(n){return n.data})},n.prototype.getTestClasses=function(){return this.$http.get("/PDP/api/Info/GetTestClasses/").then(function(n){return n.data})},n.prototype.getYears=function(){return this.$http.get("/PDP/api/Info/GetYears/").then(function(n){return n.data})},n.prototype.getAboutMessage=function(){return this.$http.get("/PDP/api/Info/GetAboutMessage/").then(function(n){return n.data})},n.prototype.getAnalyticalResults=function(n,t,i,r,u){return this.$http.post("/PDP/api/Info/GetAnalyticalResults/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u}).then(function(n){return n.data})},n.prototype.getSampleResults=function(n,t,i,r,u){return this.$http.post("/PDP/api/Info/GetSampleResults/",{commodities:n,pesticides:t,testClasses:i,years:r,resultOptionId:u}).then(function(n){return n.data})},n.prototype.getSummaryOfNdLods=function(n,t,i,r){return this.$http.post("/PDP/api/Info/GetSummaryOfNdLods/",{commodities:n,pesticides:t,testClasses:i,years:r}).then(function(n){return n.data})},n.prototype.getSummaryOfFindings=function(n,t,i,r){return this.$http.post("/PDP/api/Info/GetSummaryOfFindings/",{commodities:n,pesticides:t,testClasses:i,years:r}).then(function(n){return n.data})},n.prototype.getSummaryOfFindingsByLod=function(n,t,i,r){return this.$http.post("/PDP/api/Info/GetSummaryOfFindingsByLod/",{commodities:n,pesticides:t,testClasses:i,years:r}).then(function(n){return n.data})},n.prototype.getSummaryOfFindingsByCountryOfOrigin=function(n,t,i,r){return this.$http.post("/PDP/api/Info/GetSummaryOfFindingsByCountryOfOrigin/",{commodities:n,pesticides:t,testClasses:i,years:r}).then(function(n){return n.data})},n.prototype.getSummaryOfFindingsByClaim=function(n,t,i,r){return this.$http.post("/PDP/api/Info/GetSummaryOfFindingsByClaim/",{commodities:n,pesticides:t,testClasses:i,years:r}).then(function(n){return n.data})},n}();n.SearchService=t;angular.module("app.services").factory("app.services.SearchService",["$http",i])})(t=n.services||(n.services={}))}(app||(app={}))