1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420 |
- <!doctype html>
- <html>
- <head>
- <meta charset="utf-8">
- <title></title>
- <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
- <link href="css/mui.css" rel="stylesheet" />
- <script src="assets/js/jquery-3.1.0.js"></script>
- <script src="assets/js/jquery.base64.js"></script>
- <script src="CommonJS/Config_JS/Config_Load.js"></script>
- <script src="CommonJS/DBUtil_JS/WsCommonClassJava.js"></script>
- <script src="CommonJS/Data_ProcessJS/CommonData.js"></script>
- <script src="CommonJS/HTML_ElementCommonJS/Select_Common.js"></script>
- <script src="js/mui.min.js"></script>
- <style>
- .leftimg{
- margin-top: 0.9375rem;
- }
- .maintext{
- /* float: left; */
- }
- .delebtn{
- width: 1.5625rem;
- margin-top: 1.25rem;
- }
- .title{
- background-color:gainsboro;
- height: 3.125rem;
- }
- .maincontent{
- margin-top: 3.75rem;
- }
- .headimg{
- float: left;
- margin-left: 0.3rem;
- margin-top: 0.8rem;
- }
- .headimg img{
- width: 2.1875rem;
- }
- li{
- display:block;
- /* float:left; */
- width:100%;
- margin-right:8px;
- white-space:normal;
- word-break : break-all;
- word-wrap: break-word;
- }
- .table {
- border: 1px solid #cad9ea;
- color: #666;
- }
- .table th {
- background-repeat: repeat-x;
- height: 30px;
- }
- .table td,
- .table th {
- border: 1px solid #cad9ea;
- padding: 0 1em 0;
- }
- .table tr.alter {
- background-color: #f5fafe;
- }
- #popover{
- position: absolute !important;
- top: 43% !important;
- left: 17% !important;
- }
- .mui-popover-arrow{
- display: none;
- }
- </style>
- <script>
- $(document).on("click", '#mainpage', function() {
- window.location="main.html?date="+getDateStr();
- });
- $(document).on("click", '#addpage', function() {
- // mui.alert('模块更新中 敬请期待!!!', '系统提示', function() {});
- window.location="add.html?date="+getDateStr();
- });
- $(document).on("click", '#exit', function() {
- var btnArray = ['否', '是'];
- mui.confirm('是否确认退出登录?', '系统提示', btnArray, function(e) {
- if (e.index == 1) {
- window.location="login.html";
- } else {
- }
- })
- });
- mui.init({
- //swipeBack: true //启用右滑关闭功能
- });
- (function($) {
- $('#scroll').scroll({
- indicators: true //是否显示滚动条
- });
- var segmentedControl = document.getElementById('segmentedControl');
- $('.mui-input-group').on('change', 'input', function() {
- if (this.checked) {
- var styleEl = document.querySelector('input[name="style"]:checked');
- var colorEl = document.querySelector('input[name="color"]:checked');
- if (styleEl && colorEl) {
- var style = styleEl.value;
- var color = colorEl.value;
- segmentedControl.className = 'mui-segmented-control' + (style ? (' mui-segmented-control-' + style) : '') + ' mui-segmented-control-' + color;
- }
- }
- });
- })(mui);
- function createNewDataList(content, address, username, idcard,id,ppzt,sex,major,street,xjzt,zdpc) {
- var str = "";
- var str1="";
- /* "<li id='newdatalist' class='mui-table-view-cell mui-media'>" +
- "<a class='mui-navigate-right'>" +
- "<img class='mui-media-object mui-pull-left' src='../assets/images/test.png'>" +
- "<div class='mui-media-body'>" +
- "<span class='mui-ellipsis' style='font-size: 16px;font-family: PingFang;'>" + typeName + "</span>" +
- "<span class='mui-ellipsis mui-pull-right' style='font-size: 13px;font-family: PingFang;'>" + time + "</span>" +
- "<p id='dataID' class='mui-ellipsis mui-pull-right' style='font-size: 0px;font-family: PingFang;'>" + id + "</p>" +
- "<p class='mui-ellipsis'>" +
- "<span class='mui-ellipsis' style='font-size: 13px;font-family: PingFang;'>" + projectName + "</span>" +
- "<span class='mui-ellipsis mui-pull-right' style='font-size: 13px;font-family: PingFang;'>" + status + "</span>" +
- "</p></div></a></li> "; */
- var enable = "";
- var strzt="";
- var strimage="";
- if(zdpc=="0"){
- strimage="<img class='mui-media-object mui-pull-left leftimg' src='assets/image/tupian.png'>" ;
- }
- if(zdpc=="1"){
- strimage="<img class='mui-media-object mui-pull-left leftimg' src='assets/image/tupian2.png'>" ;
- }
- if(towncode == null || towncode==""){
- enable =" disabled='disabled'";
- }else{
- enable = "";
- }
- if(ppzt=='1'){
- strzt="街道已匹配";
- }else{
- if(ppzt==''){
- strzt="街道未匹配";
- }else{
- strzt="街道已匹配";
- }
- }
- if(towncode != null && towncode!=""){
- str1="";
- }else{
- str1="<p id='txt_ppzt' class='mui-ellipsis' >"+strzt+"</p>";
- }
- /* str = "<li id='list' class='mui-table-view-cell mui-media'>"+
- "<a href='javascript:;'>"+
- "<img class='mui-media-object mui-pull-left leftimg' src='assets/image/tupian.png'>"+
- "<div class=' mui-pull-right'>"+
- "<div><span class='mui-badge mui-badge-success'>"+content+"</span></div>"+
- "<div><img src='assets/image/lajit.png' class='delebtn'/></div>"+
- "</div>"+
- "<div class='mui-media-body maintext' >"+
- "<p id='txt_add' class='mui-ellipsis-5' style='width: 95%;'>"+address+"</p>"+
- "<p id='txt_name' class='mui-ellipsis'>"+username+"</p>"+
- "<p id='txt_idcard' class='mui-ellipsis'>"+idcard+"</p>"+
- "<p id='txt_id' class='mui-ellipsis' style='display:none'>"+id+"</p>"+str1+
- "</div>"+
- "</a>"+
- "</li>"; */
- if(role=="3" || role=="21") {
- var str1="";
- var str2="";
- if(xjzt!=""){
- if(xjzt=="执业中"){
- str1="<div><span class='mui-badge mui-badge-danger'>" + xjzt + "</span></div>" ;
- }else{
- str1="<div><span class='mui-badge mui-badge-success'>" + xjzt + "</span></div>" ;
- }
- }
- if(content>0){
- if(xjzt=="执业中"){
- str2="<span class='mui-badge mui-badge-danger' >" + content + "</span>";
- }else{
- str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
- }
- }else{
- str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
- }
- str = "<li id='list' class='mui-table-view-cell mui-media'>" +
- "<a href='javascript:;'>" +strimage+
- "<div class=' mui-pull-right'>" +
- "<div onclick='conclusionPopover("+id+")'>" +str2+
- "</div>" +str1+
- //"<div><img src='assets/image/lajit.png' class='delebtn'/></div>"+
- "</div>" +
- "<div class='mui-media-body maintext' id='listDiv'>" +
- "<p id='txt_add' class='mui-ellipsis-5' style='width: 95%;'>" + address + "</p>" +
- "<p id='txt_name' class='mui-ellipsis'>" + username + "</p>" +
- "<p id='txt_idcard' class='mui-ellipsis'>" + idcard + "</p>" +
- "<p id='txt_id' class='mui-ellipsis' style='display:none'>" + id + "</p>" +
- "<p id='txt_sex' class='mui-ellipsis' style='display:none'>" + sex + "</p>" +
- "<p id='txt_major' class='mui-ellipsis' style='display:none'>" + major + "</p>" +
- "</div>" +
- "</a>" +
- "</li>";
- }else {
- var str1="";
- var str2="";
- var str3="";
- if(xjzt=="执业中"){
- str3="<div class='mui-media-body maintext' id='listDiv' onclick='onclickRead("+id+")'>" ;
- }else{
- str3="<div class='mui-media-body maintext' id='listDiv'>" ;
- }
- if(xjzt!=""){
- if(xjzt=="执业中"){
- str1="<div><span class='mui-badge mui-badge-danger'>" + xjzt + "</span></div>" ;
- }else{
- str1="<div><span class='mui-badge mui-badge-success'>" + xjzt + "</span></div>" ;
- }
- }
- if(content>0){
- if(xjzt=="执业中"){
- str2="<span class='mui-badge mui-badge-danger' >" + content + "</span>";
- }else{
- str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
- }
- }else{
- str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
- }
- str = "<li id='list' class='mui-table-view-cell mui-media'>" +
- "<a href='javascript:;'>" +strimage+
- "<div class=' mui-pull-right'>" +
- "<div onclick='conclusionPopover("+id+")'>" +str2+
- "</div>" +str1+
- //"<div><img src='assets/image/lajit.png' class='delebtn'/></div>"+
- "</div>" +str3+
- "<p id='txt_street' class='mui-ellipsis-5' style='width: 95%;'>" + street + "</p>" +
- "<p id='txt_add' class='mui-ellipsis-5' style='width: 95%;'>" + address + "</p>" +
- "<p id='txt_name' class='mui-ellipsis'>" + username + "</p>" +
- "<p id='txt_major' class='mui-ellipsis'>" + major + "</p>" +
- "<p id='txt_idcard' class='mui-ellipsis'>" + idcard + "</p>" +
- "<p id='txt_id' class='mui-ellipsis' style='display:none'>" + id + "</p>" +
- "<p id='txt_sex' class='mui-ellipsis' style='display:none'>" + sex + "</p>" +
- "</div>" +
- "</a>" +
- "</li>";
- }
- $("#newDataUl").append(str);
- }
- $(document).on("click", '#listDiv', function() {
- // mui.show("fasdfasdfasd");
- var listid = $(this).find('#txt_idcard').text();
- localStorage.setItem("name",$(this).find('#txt_name').text());
- localStorage.setItem("idcard",$(this).find('#txt_idcard').text());
- localStorage.setItem("address",$(this).find('#txt_add').text());
- localStorage.setItem("caseid",$(this).find('#txt_id').text());
- localStorage.setItem("sex",$(this).find('#txt_sex').text());
- localStorage.setItem("major",$(this).find('#txt_major').text());
- //增加判断:四小时内不能重复提交
- var strSql = "select count(t.ID) num from 巡检状态 t where t.一户一档ID = '"+$(this).find('#txt_id').text()+"' and t.时间 > (sysdate-(4.0/24))";
- new WsCommonClass("QueryDataBaseJson", ["sql"], [strSql], (evt)=>{
- var num = Number(evt.data[0].NUM);
- if(num > 0){
- mui.alert('四小时内不能重复提交!','提示',['确定'],null,'');
- return;
- }else{
- var html = "approveNew.html";
- // var html = "./mFAHomepageParticulars.html?id=" + listid;
- if(role=="3" ||role=="21"){
- $(location).attr('href', html);
- }
- }
- }, "queryCount");
- // alert(listid);
- // var html = "approveNew.html";
- // // var html = "./mFAHomepageParticulars.html?id=" + listid;
- // if(role=="3" ||role=="21"){
- // $(location).attr('href', html);
- // }else{
- //
- // }
- // var webview_sub = plus.webview.create(
- // html,
- // 'mFAHomepageParticulars', {}, {
- // name: 'davis'
- // }); //后台创建webview并打开页面
- // webview_sub.show('slide-in-right', 150);
- });
- var towncode;
- var towncode1;
- var districtcode;
- var role;
- var town;
- window.onload = function load(){
- var district = localStorage.getItem("district");
- districtcode = localStorage.getItem("districtcode");
- town = localStorage.getItem("town");
- towncode = localStorage.getItem("towncode");
- var town1 = localStorage.getItem("town1");
- towncode1 = localStorage.getItem("towncode1");
- role = localStorage.getItem("ROLE");
- // alert(district+"/"+town);
- $("#towninfo").attr("placeholder",district+"/"+town);//.val("aaaa");//district+"/"+town);
- // 巡查员用户&区级管理员用户
- if(role=="3" ||role=="21"){
- document.getElementById("streetDiv").style.display="none";
- $("#div_totalcon").hide();
- getListInfo(towncode);
- queryPatrolStatus();
- }
- // 区级用户
- else if(role=="2"){
- $("#div_totalcon").show();
- //queryQXList(districtcode);
- //getListDistrictInfo(districtcode);
- queryPatrolStatus();
- queryQXListDistrict(districtcode);
- queryInspectorFind(district);
- //totalInfoArea1();
- }
- // 市级用户
- else if(role=="1"){
- $("#div_totalcon").show();
- // $("#item1").removeClass("mui-active");
- // $("#item2").addClass("mui-active");
- // $("#segmentedControl a").eq(1)[0].className="mui-control-item mui-active";//第二个tab设置当前页
- // $("#segmentedControl a").eq(0)[0].remove();//删第一个tab
- // 获取巡检状态
- queryPatrolStatus();
- // 获取任务清单
- queryQXListDistrict("");
- totalInfoCity();
- queryInspectorFindByCity( );
- }
- };
- function queryQXList(districtcode){
- var strSql = "";
- if(districtcode == "310")
- strSql = "select distinct(t.district) town,t.districtcode towncode from 系统用户信息表 t where t.districtcode !='310' order by districtcode ";
- else
- strSql = "select * from 系统用户信息表 t where districtcode='"+districtcode+"' order by towncode ";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryQXList");
- }
- function queryQXListDistrict(districtcode) {
- /* var strSql="select t.towncode,t.town from 系统用户信息表 t where districtcode='"+districtcode+"' " +
- "union select 0 towncode,to_char('未匹配') town from dual";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryQXListDis"); */
- // var strSql="select distinct t.towncode,to_char(t.town) town from 系统用户信息表新 t where t.districtcode='"+districtcode+"' and t.town is not null " +
- // "union select 0 towncode,to_char('未匹配') town from dual";
- var strSql="select distinct t.towncode,to_char(t.town) town from 系统用户信息表新 t where t.town is not null ";
- if(districtcode!=""){
- strSql += "and t.districtcode='"+districtcode+"'";
- }
- strSql += " union select 0 towncode,to_char('未匹配') town from dual ";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryQXListDis");
- }
- function queryPatrolStatus() {
- var strSql="select * from 编码表巡检状态 t where t.id!=5";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryPatrolStatus");
- }
- function queryInspectorFindByCity() {
- document.getElementById("newDataUlFind").innerHTML="";
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var where="";
- /*if(monthstr=='1' || monthstr=='2' ||monthstr=='3'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
- }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
- }
- else if(monthstr=='7' ||monthstr=='8' ||monthstr=='9'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
- }else if(monthstr=='10' || monthstr=='11' ||monthstr=='12'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
- }*/
- if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
- where="1,2,3"
- }
- if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
- where="4,5,6"
- }
- if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
- where="7,8,9"
- }
- if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
- where="10,11,12"
- }
- //var strSql="select t.*,y.username,y.mobile from 巡检新增 t left join 系统用户信息表新 y on t.巡查员id=y.id where 1=1 "+where+" order by y.district";
- var strSql="select t.num 身份证,t.name 姓名,t.registere 执业地址," +
- "t.专业 从事专业,t.street 街道,t.时间 上报时间,t.手机 MOBILE from health.view_巡检 t " +
- "where t.sendyear="+datet.getFullYear()+
- " and t.sendmonth in ("+where+") and t.source=4 and t.sourcesub=1";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryInspectorFindByCity");
- }
- function queryInspectorFind(district) {
- var aa=district.substring(0, 2);
- document.getElementById("newDataUlFind").innerHTML="";
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var where="";
- /* if(datet.getFullYear()=='2021'){
- if(monthstr=='6'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '2021/01' and '2021/06'";
- }else if(monthstr=='7' || monthstr=='8' ||monthstr=='9'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '2021/03' and '2021/09'";
- }else if(monthstr=='10' || monthstr=='11' ||monthstr=='12'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '2021/05' and '2021/12'";
- }
- }else {
- if(monthstr=='1'||monthstr=='2'||monthstr=='3'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+(datet.getFullYear()-1)+"/07' and '"+datet.getFullYear()+"/03'";
- }else if(monthstr=='4'||monthstr=='5'||monthstr=='6'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+(datet.getFullYear()-1)+"/10' and '"+datet.getFullYear()+"/06'";
- }else if(monthstr=='7'||monthstr=='8'||monthstr=='9'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/09'";
- }else if(monthstr=='10'||monthstr=='11'||monthstr=='12'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/12'";
- }
- }
- var strSql="select t.*,y.username,y.mobile from 巡检新增 t left join 系统用户信息表 y on t.巡查员id=y.id where t.区县='"+district+"' "+where+" order by y.towncode";
- console.log(strSql)
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryInspectorFind");
- */
- if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
- where="1,2,3"
- }
- if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
- where="4,5,6"
- }
- if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
- where="7,8,9"
- }
- if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
- where="10,11,12"
- }
- /*if(monthstr=='1' || monthstr=='2' ||monthstr=='3'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
- }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
- }
- else if(monthstr=='7' ||monthstr=='8' ||monthstr=='9'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
- }else if(monthstr=='10' || monthstr=='11' ||monthstr=='12'){
- where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
- }*/
- // var strSql="select t.*,y.username,y.mobile from 巡检新增 t left join 系统用户信息表新 y on t.巡查员id=y.id where t.区县='"+district+"' "+where+" order by y.towncode";
- var strSql="select t.num 身份证,t.name 姓名,t.registere 执业地址," +
- "t.专业 从事专业,t.street 街道,t.时间 上报时间,t.手机 MOBILE from health.view_巡检 t " +
- "where t.sendyear="+datet.getFullYear()+
- " and t.sendmonth in ("+where+") and t.source=4 and t.sourcesub=1 and t.COUNTYSSTRING='"+district.substring(0, 2)+"'";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryInspectorFind");
- }
- function getListInfo(townCode){
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var monthstr1 = "";
- if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
- monthstr1="1,2,3"
- }
- if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
- monthstr1="4,5,6"
- }
- if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
- monthstr1="7,8,9"
- }
- if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
- monthstr1="10,11,12"
- }
- var whereStr = "";
- if(town=="全街镇"){
- whereStr+=" and t.county='"+districtcode+"'";
- }else if(towncode!="" && towncode1!=""){
- whereStr=" and (t.streetid='"+towncode+"' or t.streetid='"+towncode1+"')";
- }else{
- whereStr=" and t.streetid='"+towncode+"'";
- }
- if(document.getElementById("select_source").value!='0' ){
- whereStr+=" and t.source="+document.getElementById("select_source").value;
- }
- if(document.getElementById("select_patrol").value!='-1'){
- if(document.getElementById("select_patrol").value=='0'){
- whereStr+=" and t.巡检状态ID is not null ";
- }else {
- whereStr+=" and t.巡检状态ID is null ";
- }
- }
- if(document.getElementById("select_conclusion").value){
- if(document.getElementById("select_conclusion").value!='-1'){
- whereStr+=" and t.巡检状态ID="+document.getElementById("select_conclusion").value;
- }
- }
- var strSql = " select * "+
- "from (select to_char(t.id) id, "+
- "to_char(t.NAME) name, "+
- "to_char(t.REGISTERE) REGISTERE, "+
- "to_char(t.NUM) NUM, "+
- // "0 conent, "+
- "to_char(nvl(aa.content, '0')) conent, "+
- "'巡检' as type,t.专业,t.sex,t.street 街镇,t.巡检状态,t.排序,t.ZDPC "+
- "from VIEW_巡检 t "+
- "left join (select count(0) content, t.一户一档id "+
- "from 巡检状态 t where t.时间 between ADD_MONTHS(sysdate, -3) and sysdate "+
- "group by t.一户一档id) aa "+
- "on t.id = aa.一户一档id "+
- "where 1=1 "+whereStr+
- "and t.sendyear = '"+datet.getFullYear() +"' "+
- "and t.sendmonth in ("+monthstr1+") "+
- //"and (t.sendmonth = '1' or t.sendmonth = '2' or t.sendmonth = '3') "+
- ") t where 1=1 "+
- "order by t.排序 ";
- console.log(strSql)
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryUser");
- // strSql = "select * from (select to_char(t.id) id, to_char(t.NAME) name, to_char(t.REGISTERE) REGISTERE, to_char(t.NUM) NUM, 0 conent, '巡检' as type from VIEW_巡检 t where t.streetid = '310118107001' and t.sendyear = '2020' and (t.sendmonth = '7' or t.sendmonth = '8') union all select to_char(a.id) as id, to_char(a.系统标题) as name, to_char(a.系统内容) as registere, '' as num, 0 conent, '推送' as type from 系统推送信息 a where a.所属街道代码 = '310118107001' ) t where 1=1 order by nlssort(t.name, 'NLS_SORT=SCHINESE_PINYIN_M') desc ";
- }
- function getListDistrictInfo(townCode){
- document.getElementById("newDataUl").innerHTML="";
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var monthstr1 = "";
- if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
- monthstr1="1,2,3"
- }
- if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
- monthstr1="4,5,6"
- }
- if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
- monthstr1="7,8,9"
- }
- if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
- monthstr1="10,11,12"
- }
- var whereStr = "";
- console.log("streetid", document.getElementById("select_street").value);
- if(document.getElementById("select_street").value!='-1' ){
- if(document.getElementById("select_street").value=="0"){
- whereStr+=" and streetid is null ";
- }else{
- whereStr+=" and streetid='"+document.getElementById("select_street").value+"' ";
- }
- }
- if(document.getElementById("select_source").value!='0' ){
- whereStr+=" and source="+document.getElementById("select_source").value;
- }
- if(document.getElementById("select_patrol").value!='-1'){
- if(document.getElementById("select_patrol").value=='0'){
- whereStr+=" and 巡检状态ID is not null ";
- }else {
- whereStr+=" and 巡检状态ID is null ";
- }
- }
- console.log("巡检状态ID", document.getElementById("select_conclusion").value);
- // if (document.getElementById("select_conclusion").value != '-1') {
- // whereStr += " and 巡检状态ID=" + document.getElementById("select_conclusion").value;
- // }
- let xc_value = document.getElementById("select_conclusion").value;
- if (xc_value != '-1' && xc_value != "") {
- whereStr += " and 巡检状态ID=" + document.getElementById("select_conclusion").value;
- }
- var strSql = " select * "+
- "from (select to_char(t.id) id, "+
- "to_char(t.NAME) name, "+
- " to_char(t.streetid) street, "+
- "to_char(t.REGISTERE) REGISTERE, "+
- "to_char(t.NUM) NUM, "+
- // "0 conent, "+
- "to_char(nvl(aa.content, '0')) conent, "+
- "'巡检' type, " +
- "to_char(t.streetid) streetid,t.专业,t.sex,t.street 街镇,t.巡检状态,t.排序,t.ZDPC " +
- "from VIEW_巡检 t "+
- "left join (select count(0) content, t.一户一档id "+
- "from 巡检状态 t where t.时间 between ADD_MONTHS(sysdate, -3) and sysdate "+
- "group by t.一户一档id) aa "+
- "on t.id = aa.一户一档id where 1=1 ";
- // 市级不过滤
- if(role != "1"){
- strSql += "and t.county like '"+districtcode+"%' ";
- }
- strSql += "and t.sendyear = '"+datet.getFullYear() +"' "+
- "and t.sendmonth in ("+monthstr1+") "+ whereStr +
- //"and t.sendmonth in (1,2,3) "+ whereStr +
- " order by t.排序,t.streetid) t where 1=1";
- console.log(strSql)
- // strSql = "select * from (select to_char(t.id) id, to_char(t.NAME) name, to_char(t.REGISTERE) REGISTERE, to_char(t.NUM) NUM, 0 conent, '巡检' as type from VIEW_巡检 t where t.streetid = '310118107001' and t.sendyear = '2020' and (t.sendmonth = '7' or t.sendmonth = '8') union all select to_char(a.id) as id, to_char(a.系统标题) as name, to_char(a.系统内容) as registere, '' as num, 0 conent, '推送' as type from 系统推送信息 a where a.所属街道代码 = '310118107001' ) t where 1=1 order by nlssort(t.name, 'NLS_SORT=SCHINESE_PINYIN_M') desc ";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryUser");
- $("#total").html("总计0条");
- }
- function querySuccess(evt,token){
- var jsonData = evt.data;
- if(jsonData != null){
- switch (token){
- case "queryUser":
- //console.log(jsonData)
- $("#total").html("总计"+jsonData.length+"条");
- document.getElementById("newDataUl").innerHTML="";
- for(var i=0;i<jsonData.length;i++){
- var address ;
- var name;
- var idcarid;
- var addressInfo = jsonData[i].REGISTERE.toString();
- if(addressInfo.indexOf("身份证:")>0){
- idcarid = addressInfo.substr(addressInfo.indexOf("身份证")+4,18);
- address = addressInfo.substr(addressInfo.indexOf("身份证")+22,addressInfo.length-1);
- }else{
- idcarid = jsonData[i].NUM;
- address = jsonData[i].REGISTERE;
- }
- name = jsonData[i].NAME;
- // 巡查员用户&区级管理员用户
- if(role=="3" ||role=="21"){
- //createNewDataList(jsonData[i].conent,address,name,idcarid,jsonData[i].id,'0');
- createNewDataList(jsonData[i].CONENT,address,name,idcarid,jsonData[i].ID,'0',jsonData[i].SEX,jsonData[i].专业,jsonData[i].街镇,jsonData[i].巡检状态,jsonData[i].ZDPC);
- }else{
- if(jsonData[i].type=='推送'){
- //createNewDataList(jsonData[i].conent,address,name,idcarid,jsonData[i].id,'1');
- createNewDataList(jsonData[i].CONENT,address,name,idcarid,jsonData[i].ID,'1',jsonData[i].SEX,jsonData[i].专业,jsonData[i].街镇,jsonData[i].巡检状态,jsonData[i].ZDPC);
- }else{
- //createNewDataList(jsonData[i].conent,address,name,idcarid,jsonData[i].id,jsonData[i].streetid);
- createNewDataList(jsonData[i].CONENT,address,name,idcarid,jsonData[i].ID,jsonData[i].STREETID,jsonData[i].SEX,jsonData[i].专业,jsonData[i].街镇,jsonData[i].巡检状态,jsonData[i].ZDPC);
- }
- }
- }
- break;
- case "queryQXList":
- Select_DyCreate("select_jd",jsonData,"towncode","town",true);
- // Select_DyCreate("select_jd1",jsonData,"towncode","town",true);
- break;
- case "queryQXListDis" :
- Select_DyCreate("select_street",jsonData,"TOWNCODE","TOWN",true);
- //区级
- if(role=="2"){
- // 获取完成情况
- totalInfoArea();
- getListDistrictInfo(districtcode);
- }else{
- getListDistrictInfo("");
- }
- break;
- case "queryPatrolStatus":
- Select_DyCreate("select_conclusion",jsonData,"ID","状态",true);
- break;
- case "queryConclusion":
- if(jsonData.length>0){
- document.getElementById("newDataUl1").innerHTML="";
- for(var i=0;i<jsonData.length;i++) {
- var strTask="";
- var xc="";
- if(jsonData[i].现场查见=='1'){
- xc="在联";
- }
- if(jsonData[i].现场查见=='0'){
- xc="失联";
- }
- var zy="";
- if(jsonData[i].内科=='1'){
- zy+="内科,"
- }
- if(jsonData[i].牙科=='1'){
- zy+="牙科,"
- }
- if(jsonData[i].医美=='1'){
- zy+="医美,"
- }
- if(jsonData[i].其他=='1'){
- zy+=jsonData[i].内容;
- }
- var height=40;
- if(jsonData[i].状态!="已搬离"){
- if(zy=="" &&xc==""){
- height=40;
- }else{
- strTask="<label style='width: 65%'>"+zy+"</label><label style='width: 35%'>"+xc+"</label>";
- height=80;
- }
- }
- var str = " <div class='mui-input-row' style='height:"+height+"px;'>"+
- "<label style='width: 65%'>"+jsonData[i].时间.substr(0,11)+"</label><label style='width: 35%'>"+jsonData[i].状态+"</label>"+strTask+
- "</div>";
- $("#newDataUl1").append(str);
- }
- mui("#conclusionpopover").popover('toggle', document.getElementById("ta"));
- }
- break;
- case "totalInfo":
- for(var i=0;i<jsonData.length;i++){
- var table = "<tr><td>"+jsonData[i].所属街道.toString()+"</td>"+
- "<td>"+jsonData[i].下发数.toString()+"</td>"+
- "<td>"+jsonData[i].已排查.toString()+"</td>"+
- "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
- $("#tablebody").append(table);
- }
- break;
- case "queryInspectorFindByCity":{
- for(var i=0;i<jsonData.length;i++) {
- var sfz='';
- if(jsonData[i].身份证=="undefined" ||jsonData[i].身份证==''){
- sfz='';
- }else{
- sfz=jsonData[i].身份证;
- }
- var str = "<li id='list' class='mui-table-view-cell mui-media'>" +
- "<a href='javascript:;'>" +
- /*"<div class=' mui-pull-right'>" +
- "</div>" +*/
- "<div class='mui-media-body maintext' >" +
- "<p class='mui-ellipsis'>" +
- "<table style='font-size: 14px;color: grey;'>" +
- "<tr><td>所属街道:</td><td>"+jsonData[i].街道+"</td></tr>" +
- "<tr><td>行医人姓名:</td><td>"+jsonData[i].姓名+"</td></tr>" +
- "<tr><td>地址:</td><td>"+jsonData[i].执业地址+"</td></tr>" +
- "<tr><td>专业:</td><td>"+jsonData[i].从事专业+"</td></tr>" +
- "<tr><td>身份证:</td><td>"+sfz+"</td></tr>" +
- "<tr><td>上报时间:</td><td>"+jsonData[i].上报时间.substring(0,19)+"</td></tr>" +
- "<tr><td>巡查员手机:</td><td>"+jsonData[i].MOBILE+"</td></tr>" +
- "</table>" +
- "</p>"+
- "</div>" +
- "</a>" +
- "</li>";
- $("#newDataUlFind").append(str);
- }
- break;
- }
- case "queryInspectorFind":
- /* for(var i=0;i<jsonData.length;i++) {
- var str = "<li id='list' class='mui-table-view-cell mui-media'>" +
- "<a href='javascript:;'>" +
- "<div class='mui-media-body maintext' >" +
- "<p class='mui-ellipsis-'>" + jsonData[i].街道 + "</p>" +
- "<p class='mui-ellipsis'>" + jsonData[i].姓名 + "</p>" +
- "<p class='mui-ellipsis'>" + jsonData[i].执业地址 + "</p>" +
- "<p class='mui-ellipsis'>" + jsonData[i].从事专业 + "</p>" +
- "<p class='mui-ellipsis' >" + jsonData[i].身份证 + "</p>" +
- "<p class='mui-ellipsis' >" + jsonData[i].上报时间 + "</p>" +
- "<p class='mui-ellipsis' >" + jsonData[i].MOBILE + "</p>" +
- "</div>" +
- "</a>" +
- "</li>";
- $("#newDataUlFind").append(str);
- } */
- for(var i=0;i<jsonData.length;i++) {
- var sfz='';
- if(jsonData[i].身份证=="undefined" ||jsonData[i].身份证==''){
- sfz='';
- }else{
- sfz=jsonData[i].身份证;
- }
- var str = "<li id='list' class='mui-table-view-cell mui-media'>" +
- "<a href='javascript:;'>" +
- /*"<div class=' mui-pull-right'>" +
- "</div>" +*/
- "<div class='mui-media-body maintext' >" +
- "<p class='mui-ellipsis'>" +
- "<table style='font-size: 14px;color: grey;'>" +
- "<tr><td>所属街道:</td><td>"+jsonData[i].街道+"</td></tr>" +
- "<tr><td>行医人姓名:</td><td>"+jsonData[i].姓名+"</td></tr>" +
- "<tr><td>地址:</td><td>"+jsonData[i].执业地址+"</td></tr>" +
- "<tr><td>专业:</td><td>"+jsonData[i].从事专业+"</td></tr>" +
- "<tr><td>身份证:</td><td>"+sfz+"</td></tr>" +
- "<tr><td>上报时间:</td><td>"+jsonData[i].上报时间.substring(0,19)+"</td></tr>" +
- "<tr><td>巡查员手机:</td><td>"+jsonData[i].MOBILE+"</td></tr>" +
- "</table>" +
- "</p>"+
- /*"<p class='mui-ellipsis'>所属街道:" + jsonData[i].街道 + "</p>" +
- "<p class='mui-ellipsis'>行医人姓名:" + jsonData[i].姓名 + "</p>" +
- "<p class='mui-ellipsis'>地址:" + jsonData[i].执业地址 + "</p>" +
- "<p class='mui-ellipsis'>专业:" + jsonData[i].从事专业 + "</p>" +
- "<p class='mui-ellipsis' >身份证:" + jsonData[i].身份证 + "</p>" +
- "<p class='mui-ellipsis' >上报时间:" + jsonData[i].上报时间 + "</p>" +
- "<p class='mui-ellipsis' >巡查员手机:" + jsonData[i].MOBILE + "</p>" +*/
- "</div>" +
- "</a>" +
- "</li>";
- $("#newDataUlFind").append(str);
- }
- break;
- case "totalInfoCity":{
- var xfs=0;
- var ybc=0;
- var xcy=0;
- for(var i=0;i<jsonData.length;i++){
- if(jsonData[i].街道.toString()==""){
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>未匹配</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
- "<tr>" +
- "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
- "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
- "</tr>" +
- "<tr>" +
- "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" +
- "<td style='border:80px'>巡查员发现:0</td>" +
- "</tr>" +
- "</table></p>"+
- "</div>"+
- "</li>";
- $("#tablebody").append(table);
- }else{
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>区域:"+jsonData[i].街道.toString()+"</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
- "<tr>" +
- "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
- "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
- "</tr>" +
- "<tr>" +
- "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" +
- "<td style='border:80px'>巡查员发现:"+jsonData[i].巡查员发现.toString()+"</td>" +
- "</tr>" +
- "</table></p>"+
- "</div>"+
- "</li>";
- $("#tablebody").append(table);
- }
- xfs+=jsonData[i].下发数-0;
- ybc+=jsonData[i].已排查-0;
- xcy+=jsonData[i].巡查员发现-0;
- }
- /*var table = "<tr><td>合计</td>"+
- "<td>"+xfs+"</td>"+
- "<td>"+ybc+"</td>"+
- "<td>"+(ybc/xfs*100).toFixed(1)+"%</td>" +
- "<td>"+xcy+"</td>" +
- "</tr>";*/
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>合计</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><span>下发数:"+xfs+" </span><span style='margin-left: 30%'>已巡查:"+ybc+"</span></p>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><span>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</span><span style='margin-left: 22%'>巡查员发现:"+xcy+"</span></p>"+
- "</div>"+
- "</li>";
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>合计</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
- "<tr>" +
- "<td style='width: 40%'>下发数:"+xfs+"</td>" +
- "<td style='border:80'>已巡查:"+ybc+"</td>" +
- "</tr>" +
- "<tr>" +
- "<td style='width: 40%'>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</td>" +
- "<td style='border:80px'>巡查员发现:"+xcy+"</td>" +
- "</tr>" +
- "</table></p>"+
- "</div>"+
- "</li>";
- $("#tablebody").append(table);
- break
- }
- case "totalInfoArea":
- // var xfs=0;
- // var ybc=0;
- // var xcy=0;
- /* for(var i=0;i<jsonData.length;i++){
- var table = "<tr><td>"+jsonData[i].COUNTYSSTRING.toString()+"</td>"+
- "<td>"+jsonData[i].下发数.toString()+"</td>"+
- "<td>"+jsonData[i].已排查.toString()+"</td>"+
- "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
- $("#tablebody").append(table);
- } */
- /* for(var i=0;i<jsonData.length;i++){
- if(jsonData[i].STREET.toString()==""){
- var table = "<tr><td>未匹配</td>"+
- "<td>"+jsonData[i].下发数.toString()+"</td>"+
- "<td>"+jsonData[i].已排查.toString()+"</td>"+
- "<td>"+jsonData[i].巡查率.toString()+"</td>" +
- "<td>0</td>" +
- "</tr>";
- $("#tablebody").append(table);
- }else{
- var table = "<tr><td>"+jsonData[i].STREET.toString()+"</td>"+
- "<td>"+jsonData[i].下发数.toString()+"</td>"+
- "<td>"+jsonData[i].已排查.toString()+"</td>"+
- "<td>"+jsonData[i].巡查率.toString()+"</td>" +
- "<td>"+jsonData[i].巡查员发现.toString()+"</td>" +
- "</tr>";
- $("#tablebody").append(table);
- }
- xfs+=jsonData[i].下发数-0;
- ybc+=jsonData[i].已排查-0;
- xcy+=jsonData[i].巡查员发现-0;
- }
- var table = "<tr><td>合计</td>"+
- "<td>"+xfs+"</td>"+
- "<td>"+ybc+"</td>"+
- "<td>"+(ybc/xfs*100).toFixed(1)+"%</td>" +
- "<td>"+xcy+"</td>" +
- "</tr>";
- $("#tablebody").append(table);
- getListDistrictInfo(districtcode); */
- var xfs=0;
- var ybc=0;
- var xcy=0;
- for(var i=0;i<jsonData.length;i++){
- if(jsonData[i].STREET.toString()==""){
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>未匹配</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
- "<tr>" +
- "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
- "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
- "</tr>" +
- "<tr>" +
- "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" + "<td style='border:80px'>巡查员发现:0</td>" +
- "<td style='border:80px'>巡查员发现:0</td>" +
- "</tr>" +
- "</table></p>"+
- "</div>"+
- "</li>";
- $("#tablebody").append(table);
- }else{
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>区域:"+jsonData[i].STREET.toString()+"</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
- "<tr>" +
- "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
- "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
- "</tr>" +
- "<tr>" +
- "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" +
- "<td style='border:80px'>巡查员发现:"+jsonData[i].巡查员发现.toString()+"</td>" +
- "</tr>" +
- "</table></p>"+
- "</div>"+
- "</li>";
- $("#tablebody").append(table);
- }
- xfs+=jsonData[i].下发数-0;
- ybc+=jsonData[i].已排查-0;
- xcy+=jsonData[i].巡查员发现-0;
- }
- /*var table = "<tr><td>合计</td>"+
- "<td>"+xfs+"</td>"+
- "<td>"+ybc+"</td>"+
- "<td>"+(ybc/xfs*100).toFixed(1)+"%</td>" +
- "<td>"+xcy+"</td>" +
- "</tr>";*/
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>合计</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><span>下发数:"+xfs+" </span><span style='margin-left: 30%'>已巡查:"+ybc+"</span></p>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><span>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</span><span style='margin-left: 22%'>巡查员发现:"+xcy+"</span></p>"+
- "</div>"+
- "</li>";
- var table="<li class='mui-table-view-cell mui-media'>"+
- "<div class='mui-media-body'>"+
- "<span style='font-size: 16px'>合计</span>"+
- "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
- "<tr>" +
- "<td style='width: 40%'>下发数:"+xfs+"</td>" +
- "<td style='border:80'>已巡查:"+ybc+"</td>" +
- "</tr>" +
- "<tr>" +
- "<td style='width: 40%'>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</td>" +
- "<td style='border:80px'>巡查员发现:"+xcy+"</td>" +
- "</tr>" +
- "</table></p>"+
- "</div>"+
- "</li>";
- $("#tablebody").append(table);
- // getListDistrictInfo(districtcode);
- break;
- case "totalInfoArea1":
- for(var i=0;i<jsonData.length;i++){
- var table = "<tr><td>"+jsonData[i].TOWN.toString()+"</td>"+
- "<td>"+jsonData[i].下发数.toString()+"</td>"+
- "<td>"+jsonData[i].已排查.toString()+"</td>"+
- "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
- $("#tablebody1").append(table);
- }
- break;
- case "totalInfo1":
- for(var i=0;i<jsonData.length;i++){
- var table = "<tr><td>"+jsonData[i].TOWN.toString()+"</td>"+
- "<td>"+jsonData[i].下发数.toString()+"</td>"+
- "<td>"+jsonData[i].已排查.toString()+"</td>"+
- "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
- $("#tablebody1").append(table);
- }
- break;
- case "updateRead":
- getListDistrictInfo(districtcode);
- break;
- default:
- break;
- }
- }
- }
- function jdchange(){
- $("#tablebody").html('');
- if(Select_GetSelectText("select_jd") == "全部"){
- document.getElementById("tablebody").innerHTML="";
- totalInfoArea("全部");
- getListDistrictInfo(districtcode);
- }else{
- document.getElementById("tablebody").innerHTML="";
- totalInfo(Select_GetSelectValue("select_jd"));
- }
- }
- function totalInfoArea() {
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var monthstr1 = "";
- if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
- monthstr1="1,2,3"
- }
- if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
- monthstr1="4,5,6"
- }
- if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
- monthstr1="7,8,9"
- }
- if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
- monthstr1="10,11,12"
- }
- var where = "";
- var where1="";
- if(monthstr=='1' || monthstr=='2' || monthstr=='3'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
- }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
- }
- else if(monthstr=='7' || monthstr=='8' ||monthstr=='9'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
- }else if(monthstr=='10' ||monthstr=='11' ||monthstr=='12'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
- }
- var strSql ="select aa.STREET,aa.下发数,NVL(bb.已排查,0) 已排查,round(NVL(bb.已排查, 0)/NVL(aa.下发数, 0),3)*100 || '%' 巡查率,NVL(巡查员发现,0) 巡查员发现 from ( "+
- "select count(1) 下发数,t.STREETID 街道编码,t.STREET from view_巡检 t where t.sendyear='"+new Date().getFullYear()+"' " +
- "and t.sendmonth in ("+datet.getMonth()+","+monthstr+","+monthstr1+") and t.county like '"+districtcode+"%' group by t.STREET,t.STREETID) aa "+
- //"and t.sendmonth in (1,2,3) and t.county like '"+districtcode+"%' group by t.STREET,t.STREETID) aa "+
- "left join (select count(1) 已排查,t.STREETID 街道编码 from (select distinct(t.一户一档id) from 巡检状态 t ) aa left join view_巡检 t on t.id=aa.一户一档id "+
- "where t.sendyear='"+new Date().getFullYear()+"' and t.county like '"+districtcode+"%' and t.sendmonth in ("+monthstr1+") group by t.STREETID) bb "+
- //"where t.sendyear='"+new Date().getFullYear()+"' and t.county like '"+districtcode+"%' and t.sendmonth in (1,2,3) group by t.STREETID) bb "+
- "on aa.街道编码=bb.街道编码 " +
- " left join (select yy.街道 ,count(yy.街道) 巡查员发现 from 巡检新增 yy "+where1+" group by yy.街道) cc on aa.STREET=cc.街道 order by aa.STREET";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfoArea");
- }
- function totalInfoCity() {
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var monthstr1 = "";
- if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
- monthstr1="1,2,3"
- }
- if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
- monthstr1="4,5,6"
- }
- if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
- monthstr1="7,8,9"
- }
- if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
- monthstr1="10,11,12"
- }
- var where = "";
- var where1="";
- if(monthstr=='1' || monthstr=='2' || monthstr=='3'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
- }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
- }
- else if(monthstr=='7' || monthstr=='8' ||monthstr=='9'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
- }else if(monthstr=='10' ||monthstr=='11' ||monthstr=='12'){
- where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
- }
- var strSql ="select aa.街道,aa.下发数,NVL(bb.已排查,0) 已排查,round(NVL(bb.已排查, 0)/NVL(aa.下发数, 0),3)*100 || '%' 巡查率,NVL(巡查员发现,0) 巡查员发现 from ( "+
- "select count(1) 下发数,t.COUNTYSSTRING 街道 ,t.COUNTY from view_巡检 t where t.sendyear='"+new Date().getFullYear()+"' " +
- "and t.sendmonth in ("+datet.getMonth()+","+monthstr+","+monthstr1+") group by t.COUNTYSSTRING,t.COUNTY) aa "+
- "left join (select count(1) 已排查,t.county 街道编码 from (select distinct(t.一户一档id) from 巡检状态 t ) aa left join view_巡检 t on t.id=aa.一户一档id "+
- "where t.sendyear='"+new Date().getFullYear()+"' and t.sendmonth in ("+monthstr1+") group by t.county) bb "+
- "on aa.county=bb.街道编码 " +
- " left join (select yy.区县 ,count(yy.区县) 巡查员发现 from 巡检新增 yy "+where1+" group by yy.区县) cc on '%'||aa.county||'%' like cc.区县 order by aa.county";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfoCity");
- }
- function totalInfo(street){
- var where = "";
- if(street == "全部"){
- where = " and streetid like '"+districtcode+"%'";
- }else{
- where = " and streetid like '"+street+"%'";
- }
- /* var strSql = "select aa.*,NVL(bb.已排查,0) 已排查,NVL(aa.下发数,0)-NVL(bb.已排查,0) 未排查 from (select count(1) 下发数,aa.town 所属街道,aa.towncode from (select streetid,town,towncode from view_巡检 t left join 系统用户信息表 x on t.streetid=x.towncode where t.sendyear='"+new Date().getFullYear()+"' "+where+") aa group by aa.town,aa.towncode) aa"+
- " left join "+
- " (select count(1) 已排查,x.town 所属街道 from (select distinct(t.一户一档id) from 巡检状态 t ) aa left join view_巡检 t on t.id=aa.一户一档id left join 系统用户信息表 x on t.streetid=x.towncode where t.sendyear='"+new Date().getFullYear()+"' "+where+" group by x.town ) bb"+
- " on aa.所属街道=bb.所属街道 order by aa.towncode asc"; */
- var strSql = "select aa.*,NVL(bb.已排查,0) 已排查,NVL(aa.下发数,0)-NVL(bb.已排查,0) 未排查 from (select count(1) 下发数,aa.town 所属街道,aa.towncode from (select streetid,town,towncode from view_巡检 t left join 系统用户信息表 x on t.streetid=x.towncode where t.sendyear='"+new Date().getFullYear()+"' "+where+") aa group by aa.town,aa.towncode) aa"+
- " left join "+
- " (select count(1) 已排查,x.town 所属街道 from (select distinct(t.一户一档id) from 巡检状态 t ) aa left join view_巡检 t on t.id=aa.一户一档id left join 系统用户信息表 x on t.streetid=x.towncode where t.sendyear='"+new Date().getFullYear()+"' "+where+" group by x.town ) bb"+
- " on aa.所属街道=bb.所属街道 order by aa.towncode asc";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfo");
- }
- function jdchange1(){
- /* $("#tablebody1").html('');
- if(Select_GetSelectText("select_jd1") == "全部"){
- document.getElementById("tablebody1").innerHTML="";
- totalInfoArea1("全部");
- }else{
- document.getElementById("tablebody1").innerHTML="";
- totalInfo1(Select_GetSelectValue("select_jd1"));
- } */
- $("#tablebody1").html('');
- if(Select_GetSelectText("select_jd1") == "全部"){
- document.getElementById("tablebody1").innerHTML="";
- totalInfoArea1("全部");
- }else{
- document.getElementById("tablebody1").innerHTML="";
- totalInfo1(Select_GetSelectValue("select_jd1"));
- }
- }
- function totalInfoArea1() {
- var datet = new Date();
- var monthstr = datet.getMonth()+1;
- var where = "";
- /* var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属区县代码 from 系统推送信息 a where 1=1 "+
- "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码) t "+
- "left join (select count(a.所属区县代码) 已排查,a.所属区县代码 from JSWGISDATA.系统推送信息 a "+
- "left join (select distinct t.一户一档id from 巡检状态 t "+
- "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
- "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码 "+
- ") t1 on t.所属区县代码=t1.所属区县代码 "+
- "left join (select distinct(t.district) town,t.districtcode countysstring from 系统用户信息表 t where t.districtcode !='310' order by districtcode) y "+
- "on t.所属区县代码=y.countysstring"; */
- var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属区县代码 from 系统推送信息 a where 1=1 "+
- "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码) t "+
- "left join (select count(a.所属区县代码) 已排查,a.所属区县代码 from 系统推送信息 a "+
- "left join (select distinct t.一户一档id from 巡检状态 t "+
- "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
- "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码 "+
- ") t1 on t.所属区县代码=t1.所属区县代码 "+
- "left join (select distinct(t.district) town,t.districtcode countysstring from 系统用户信息表 t where t.districtcode !='310' order by districtcode) y "+
- "on t.所属区县代码=y.countysstring";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfoArea1");
- }
- function totalInfo1(street){
- var where = "";
- /* if(street == "全部"){
- where = " and streetid like '"+districtcode+"%'";
- }else{
- where = " and 所属街道代码 like '"+street+"%' ";
- } */
- if(street == "全部"){
- where = " and streetid like '"+districtcode+"%'";
- }else{
- where = " and 所属街道代码 like '"+street+"%' ";
- }
- /* var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属街道代码 from 系统推送信息 a where 1=1 "+
- "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码) t "+
- "left join (select count(a.所属街道代码) 已排查,a.所属街道代码 from JSWGISDATA.系统推送信息 a "+
- "left join (select distinct t.一户一档id from 巡检状态 t "+
- "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
- "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码 "+
- ") t1 on t.所属街道代码=t1.所属街道代码 "+
- "left join (select distinct(t.town) town,t.towncode from 系统用户信息表 t where t.districtcode !='310' order by t.towncode) y "+
- "on t.所属街道代码=y.towncode"; */
- var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属街道代码 from 系统推送信息 a where 1=1 "+
- "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码) t "+
- "left join (select count(a.所属街道代码) 已排查,a.所属街道代码 from 系统推送信息 a "+
- "left join (select distinct t.一户一档id from 巡检状态 t "+
- "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
- "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码 "+
- ") t1 on t.所属街道代码=t1.所属街道代码 "+
- "left join (select distinct(t.town) town,t.towncode from 系统用户信息表 t where t.districtcode !='310' order by t.towncode) y "+
- "on t.所属街道代码=y.towncode";
- new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfo1");
- }
- function conditionSearch(){
- // if( role=="1"){
- // mui.alert('模块更新中 敬请期待!!!', '系统提示', function() {});
- // }else{
- // mui("#popover").popover('toggle', document.getElementById("ta"));
- // }
- mui("#popover").popover('toggle', document.getElementById("ta"));
- }
- function conclusionPopover(id) {
- var sql="select t.时间,y.状态,y1.WHETHERINSCENE 现场查见," +
- "INTERNALMEDICINE 内科,DENTAL 牙科,MEDICAKBEAUTY 医美," +
- "MEDICINEOTHER 其他,MEDICINEOTHERCONTENT 内容 from 巡检状态 t " +
- "left join 编码表巡检状态 y on t.状态=y.id " +
- "left join PATROLSTATUS y1 on t.id=y1.PATROLSTATUSID where t.一户一档id="+id;
- new WsCommonClass("QueryDataBaseJson",["sql"],[sql],querySuccess,"queryConclusion");
- }
- function onclickRead(id) {
- mui.confirm('是否已读','提示',['取消','确定'],function (e) {
- if(e.index==1){
- var sql="update 一户一档 t set t.read=1 where id="+id;
- new WsCommonClass("QueryDataBaseJson",["sql"],[sql],querySuccess,"updateRead");
- }else{
- return
- }
- });
- }
- function closeSearch() {
- // if( role=="2"){
- if( role=="2" || role=="1"){
- getListDistrictInfo('');
- }else if(role=="21" || role=="3"){
- getListInfo('');
- }
- mui('#popover').popover('hide');
- }
- function changePass(){
- window.location="changePass.html?date="+getDateStr();
- }
- function help(){
- window.location="help.html?date="+getDateStr();
- }
- </script>
- </head>
- <body>
- <header class="mui-bar mui-bar-nav" style="height: 3.75rem;">
- <div style="float: left;margin-top: 0.6rem;margin-left:-0.4375rem;">
- <input type="text" id="towninfo" class="mui-input-clear" placeholder="青浦区/华新镇" style="width: 8.75rem;" disabled="disabled">
- </div>
- <div id="total" style="margin-top: 1.3rem;margin-left: 0.3rem;width:4.6875rem;float: left;font-size: 15px">
- 总计0条
- </div>
- <div class="headimg">
- <img onclick="conditionSearch()" src="assets/image/sousuo.png" />
- </div>
- <div class="headimg">
- <img onclick="help()" src="assets/image/help.png"/>
- </div>
- <div class="headimg" >
- <img onclick="changePass()" src="assets/image/update.png"/>
- </div>
- </header>
- <div class="maincontent">
- <div style="padding: 10px 10px;display:none" id="div_totalcon" >
- <div id="segmentedControl" class="mui-segmented-control">
- <a class="mui-control-item mui-active" href="#item1">任务清单</a>
- <a class="mui-control-item" href="#item2">完成情况</a>
- <a class="mui-control-item" href="#item3">巡查员发现</a>
- </div>
- </div>
- <div id="item1" class="mui-control-content mui-active" style="padding-bottom: 3.125rem;">
- <ul class="mui-table-view" id="newDataUl"></ul>
- </div>
- <div id="item2" class="mui-control-content" style="padding-left: 0.3125rem;padding-right: 0.3125rem;padding-bottom: 3.125rem">
- <!-- <select id="select_jd" onchange="jdchange()" ></select> -->
- <ul width="100%" id="tablebody" class="mui-table-view" style="line-height:25px;"></ul>
- <!-- <table width="100%" class="table" id="tablevalue">
- <tr>
- <th width=40%>区域</th>
- <th width=20%>下发数</th>
- <th width=20%>已巡查</th>
- <th width=20%>巡查率</th>
- <th width=20%>巡查员发现</th>
- </tr>
- <tbody id="tablebody"></tbody>
- </table> -->
- </div>
- <div id="item3" class="mui-control-content" style="padding-left: 0.3125rem;padding-right: 0.3125rem;padding-bottom: 3.125rem">
- <!-- <select id="select_jd1" onchange="jdchange1()" ></select> -->
- <ul class="mui-table-view" id="newDataUlFind"></ul>
- <!-- <table width="100%" class="table" id="tablevalue1">
- <tr>
- <th width=40%>区域</th>
- <th width=20%>下发数</th>
- <th width=20%>已排查</th>
- <th width=20%>未排查</th>
- </tr>
- <tbody id="tablebody1"></tbody>
- </table> -->
- </div>
- </div>
- <nav class="mui-bar mui-bar-tab">
- <a href="firstPage.html" id="mainpage" class="mui-tab-item mui-active">
- <span class="mui-icon mui-icon-home"></span>
- <span class="mui-tab-label">主页</span>
- </a>
- <a href="projectInfo.html" id="addpage" class="mui-tab-item">
- <span class="mui-icon mui-icon-chatboxes"></span>
- <span class="mui-tab-label">添加</span>
- </a>
- <a href="myInfo.html" id="exit" class="mui-tab-item">
- <span class="mui-icon mui-icon-gear"></span>
- <span class="mui-tab-label">退出</span>
- </a>
- </nav>
- <div id="popover" class="mui-popover " style="height:100px;">
- <form class="mui-input-group" style="border-radius: 8px;">
- <!-- <div class="mui-input-row">
- <label>地址</label>
- <input type="text" class="mui-input-clear" placeholder="请输入地址" id="address">
- </div>
- <div class="mui-input-row">
- <label>姓名</label>
- <input type="text" class="mui-input-clear" placeholder="请输入姓名" id="name">
- </div>
- <div class="mui-button-row">
- <button type="button" class="mui-btn mui-btn-primary" onclick="closeSearch('')">确认</button>
- </div> -->
- <div class="mui-input-row" id="streetDiv">
- <label>街镇</label>
- <select id="select_street" ></select>
- </div>
- <div class="mui-input-row">
- <label>任务来源</label>
- <select id="select_source" >
- <option value="0">全部</option>
- <option value="1">一户一档</option>
- <option value="2">迁移比对</option>
- <option value="3">既往未巡查</option>
- <option value="4">其他</option>
- <option value="5">区所新增</option>
- </select>
- </div>
- <div class="mui-input-row">
- <label>是否巡查</label>
- <select id="select_patrol" >
- <option value="-1">全部</option>
- <option value="0">已巡查</option>
- <option value="1">未巡查</option>
- </select>
- </div>
- <div class="mui-input-row">
- <label>巡查结论</label>
- <select id="select_conclusion" ></select>
- </div>
- <div class="mui-button-row">
- <button type="button" class="mui-btn mui-btn-primary" onclick="closeSearch('')">确认</button>
- </div>
- </form>
- </div>
- <div id="conclusionpopover" class="mui-popover " style="height:100px;">
- <form class="mui-input-group" style="border-radius: 8px;" id="newDataUl1">
- </form>
- </div>
- <nav class="mui-bar mui-bar-tab" style="margin: 0 auto;margin-bottom: 100%;border: #6641E2;width: 0px;height: 0px;" id="ta">
- </nav>
- </body>
- </html>
|