main.html 68 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454
  1. <!doctype html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title></title>
  6. <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
  7. <link href="css/mui.css" rel="stylesheet" />
  8. <script src="assets/js/jquery-3.1.0.js"></script>
  9. <script src="assets/js/jquery.base64.js"></script>
  10. <script src="CommonJS/Config_JS/Config_Load.js"></script>
  11. <script src="CommonJS/DBUtil_JS/WsCommonClassJava.js"></script>
  12. <script src="CommonJS/Data_ProcessJS/CommonData.js"></script>
  13. <script src="CommonJS/HTML_ElementCommonJS/Select_Common.js"></script>
  14. <script src="js/mui.min.js"></script>
  15. <style>
  16. .leftimg{
  17. margin-top: 0.9375rem;
  18. }
  19. .maintext{
  20. /* float: left; */
  21. }
  22. .delebtn{
  23. width: 1.5625rem;
  24. margin-top: 1.25rem;
  25. }
  26. .title{
  27. background-color:gainsboro;
  28. height: 3.125rem;
  29. }
  30. .maincontent{
  31. margin-top: 3.75rem;
  32. }
  33. .headimg{
  34. float: left;
  35. margin-left: 0.3rem;
  36. margin-top: 0.8rem;
  37. }
  38. .headimg img{
  39. width: 2.1875rem;
  40. }
  41. li{
  42. display:block;
  43. /* float:left; */
  44. width:100%;
  45. margin-right:8px;
  46. white-space:normal;
  47. word-break : break-all;
  48. word-wrap: break-word;
  49. }
  50. .table {
  51. border: 1px solid #cad9ea;
  52. color: #666;
  53. }
  54. .table th {
  55. background-repeat: repeat-x;
  56. height: 30px;
  57. }
  58. .table td,
  59. .table th {
  60. border: 1px solid #cad9ea;
  61. padding: 0 1em 0;
  62. }
  63. .table tr.alter {
  64. background-color: #f5fafe;
  65. }
  66. #popover{
  67. position: absolute !important;
  68. top: 43% !important;
  69. left: 17% !important;
  70. }
  71. .mui-popover-arrow{
  72. display: none;
  73. }
  74. </style>
  75. <script>
  76. $(document).on("click", '#mainpage', function() {
  77. window.location="main.html?date="+getDateStr();
  78. });
  79. $(document).on("click", '#addpage', function() {
  80. // mui.alert('模块更新中 敬请期待!!!', '系统提示', function() {});
  81. window.location="add.html?date="+getDateStr();
  82. });
  83. $(document).on("click", '#exit', function() {
  84. var btnArray = ['否', '是'];
  85. mui.confirm('是否确认退出登录?', '系统提示', btnArray, function(e) {
  86. if (e.index == 1) {
  87. window.location="login.html";
  88. localStorage.clear();
  89. } else {
  90. }
  91. })
  92. });
  93. var idleTime = 30 * 60 * 1000; // 时间毫秒数
  94. // 最后一次用户交互的时间变量
  95. var lastInteraction = new Date().getTime();
  96. // 设置一个定时器来检查用户是否空闲
  97. setInterval(function() {
  98. var currentTime = new Date().getTime();
  99. var timeSinceLastInteraction = currentTime - lastInteraction;
  100. // 如果用户在指定的空闲时间内没有进行任何操作,清空缓存
  101. if (timeSinceLastInteraction > idleTime) {
  102. localStorage.clear();
  103. // sessionStorage.clear();
  104. console.log('缓存已清空');
  105. //跳转到登录页面
  106. window.location="login.html";
  107. }
  108. }, 1000); // 每隔一秒检查一次
  109. // 监听用户交互事件来更新lastInteraction的时间
  110. window.onload = function() {
  111. var events = ['mousedown', 'mousemove', 'keydown', 'scroll', 'touchstart'];
  112. events.forEach(function(event) {
  113. document.addEventListener(event, function() {
  114. lastInteraction = new Date().getTime();
  115. }, true);
  116. });
  117. };
  118. mui.init({
  119. //swipeBack: true //启用右滑关闭功能
  120. });
  121. (function($) {
  122. $('#scroll').scroll({
  123. indicators: true //是否显示滚动条
  124. });
  125. var segmentedControl = document.getElementById('segmentedControl');
  126. $('.mui-input-group').on('change', 'input', function() {
  127. if (this.checked) {
  128. var styleEl = document.querySelector('input[name="style"]:checked');
  129. var colorEl = document.querySelector('input[name="color"]:checked');
  130. if (styleEl && colorEl) {
  131. var style = styleEl.value;
  132. var color = colorEl.value;
  133. segmentedControl.className = 'mui-segmented-control' + (style ? (' mui-segmented-control-' + style) : '') + ' mui-segmented-control-' + color;
  134. }
  135. }
  136. });
  137. })(mui);
  138. function createNewDataList(content, address, username, idcard,id,ppzt,sex,major,street,xjzt,zdpc) {
  139. var str = "";
  140. var str1="";
  141. /* "<li id='newdatalist' class='mui-table-view-cell mui-media'>" +
  142. "<a class='mui-navigate-right'>" +
  143. "<img class='mui-media-object mui-pull-left' src='../assets/images/test.png'>" +
  144. "<div class='mui-media-body'>" +
  145. "<span class='mui-ellipsis' style='font-size: 16px;font-family: PingFang;'>" + typeName + "</span>" +
  146. "<span class='mui-ellipsis mui-pull-right' style='font-size: 13px;font-family: PingFang;'>" + time + "</span>" +
  147. "<p id='dataID' class='mui-ellipsis mui-pull-right' style='font-size: 0px;font-family: PingFang;'>" + id + "</p>" +
  148. "<p class='mui-ellipsis'>" +
  149. "<span class='mui-ellipsis' style='font-size: 13px;font-family: PingFang;'>" + projectName + "</span>" +
  150. "<span class='mui-ellipsis mui-pull-right' style='font-size: 13px;font-family: PingFang;'>" + status + "</span>" +
  151. "</p></div></a></li> "; */
  152. var enable = "";
  153. var strzt="";
  154. var strimage="";
  155. if(zdpc=="0"){
  156. strimage="<img class='mui-media-object mui-pull-left leftimg' src='assets/image/tupian.png'>" ;
  157. }
  158. if(zdpc=="1"){
  159. strimage="<img class='mui-media-object mui-pull-left leftimg' src='assets/image/tupian2.png'>" ;
  160. }
  161. if(towncode == null || towncode==""){
  162. enable =" disabled='disabled'";
  163. }else{
  164. enable = "";
  165. }
  166. if(ppzt=='1'){
  167. strzt="街道已匹配";
  168. }else{
  169. if(ppzt==''){
  170. strzt="街道未匹配";
  171. }else{
  172. strzt="街道已匹配";
  173. }
  174. }
  175. if(towncode != null && towncode!=""){
  176. str1="";
  177. }else{
  178. str1="<p id='txt_ppzt' class='mui-ellipsis' >"+strzt+"</p>";
  179. }
  180. /* str = "<li id='list' class='mui-table-view-cell mui-media'>"+
  181. "<a href='javascript:;'>"+
  182. "<img class='mui-media-object mui-pull-left leftimg' src='assets/image/tupian.png'>"+
  183. "<div class=' mui-pull-right'>"+
  184. "<div><span class='mui-badge mui-badge-success'>"+content+"</span></div>"+
  185. "<div><img src='assets/image/lajit.png' class='delebtn'/></div>"+
  186. "</div>"+
  187. "<div class='mui-media-body maintext' >"+
  188. "<p id='txt_add' class='mui-ellipsis-5' style='width: 95%;'>"+address+"</p>"+
  189. "<p id='txt_name' class='mui-ellipsis'>"+username+"</p>"+
  190. "<p id='txt_idcard' class='mui-ellipsis'>"+idcard+"</p>"+
  191. "<p id='txt_id' class='mui-ellipsis' style='display:none'>"+id+"</p>"+str1+
  192. "</div>"+
  193. "</a>"+
  194. "</li>"; */
  195. if(role=="3" || role=="21") {
  196. var str1="";
  197. var str2="";
  198. if(xjzt!=""){
  199. if(xjzt=="执业中"){
  200. str1="<div><span class='mui-badge mui-badge-danger'>" + xjzt + "</span></div>" ;
  201. }else{
  202. str1="<div><span class='mui-badge mui-badge-success'>" + xjzt + "</span></div>" ;
  203. }
  204. }
  205. if(content>0){
  206. if(xjzt=="执业中"){
  207. str2="<span class='mui-badge mui-badge-danger' >" + content + "</span>";
  208. }else{
  209. str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
  210. }
  211. }else{
  212. str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
  213. }
  214. str = "<li id='list' class='mui-table-view-cell mui-media'>" +
  215. "<a href='javascript:;'>" +strimage+
  216. "<div class=' mui-pull-right'>" +
  217. "<div onclick='conclusionPopover("+id+")'>" +str2+
  218. "</div>" +str1+
  219. //"<div><img src='assets/image/lajit.png' class='delebtn'/></div>"+
  220. "</div>" +
  221. "<div class='mui-media-body maintext' id='listDiv'>" +
  222. "<p id='txt_add' class='mui-ellipsis-5' style='width: 95%;'>" + address + "</p>" +
  223. "<p id='txt_name' class='mui-ellipsis'>" + username + "</p>" +
  224. "<p id='txt_idcard' class='mui-ellipsis'>" + idcard + "</p>" +
  225. "<p id='txt_id' class='mui-ellipsis' style='display:none'>" + id + "</p>" +
  226. "<p id='txt_sex' class='mui-ellipsis' style='display:none'>" + sex + "</p>" +
  227. "<p id='txt_major' class='mui-ellipsis' style='display:none'>" + major + "</p>" +
  228. "</div>" +
  229. "</a>" +
  230. "</li>";
  231. }else {
  232. var str1="";
  233. var str2="";
  234. var str3="";
  235. if(xjzt=="执业中"){
  236. str3="<div class='mui-media-body maintext' id='listDiv' onclick='onclickRead("+id+")'>" ;
  237. }else{
  238. str3="<div class='mui-media-body maintext' id='listDiv'>" ;
  239. }
  240. if(xjzt!=""){
  241. if(xjzt=="执业中"){
  242. str1="<div><span class='mui-badge mui-badge-danger'>" + xjzt + "</span></div>" ;
  243. }else{
  244. str1="<div><span class='mui-badge mui-badge-success'>" + xjzt + "</span></div>" ;
  245. }
  246. }
  247. if(content>0){
  248. if(xjzt=="执业中"){
  249. str2="<span class='mui-badge mui-badge-danger' >" + content + "</span>";
  250. }else{
  251. str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
  252. }
  253. }else{
  254. str2="<span class='mui-badge mui-badge-success' >" + content + "</span>";
  255. }
  256. str = "<li id='list' class='mui-table-view-cell mui-media'>" +
  257. "<a href='javascript:;'>" +strimage+
  258. "<div class=' mui-pull-right'>" +
  259. "<div onclick='conclusionPopover("+id+")'>" +str2+
  260. "</div>" +str1+
  261. //"<div><img src='assets/image/lajit.png' class='delebtn'/></div>"+
  262. "</div>" +str3+
  263. "<p id='txt_street' class='mui-ellipsis-5' style='width: 95%;'>" + street + "</p>" +
  264. "<p id='txt_add' class='mui-ellipsis-5' style='width: 95%;'>" + address + "</p>" +
  265. "<p id='txt_name' class='mui-ellipsis'>" + username + "</p>" +
  266. "<p id='txt_major' class='mui-ellipsis'>" + major + "</p>" +
  267. "<p id='txt_idcard' class='mui-ellipsis'>" + idcard + "</p>" +
  268. "<p id='txt_id' class='mui-ellipsis' style='display:none'>" + id + "</p>" +
  269. "<p id='txt_sex' class='mui-ellipsis' style='display:none'>" + sex + "</p>" +
  270. "</div>" +
  271. "</a>" +
  272. "</li>";
  273. }
  274. $("#newDataUl").append(str);
  275. }
  276. $(document).on("click", '#listDiv', function() {
  277. // mui.show("fasdfasdfasd");
  278. var listid = $(this).find('#txt_idcard').text();
  279. localStorage.setItem("name",$(this).find('#txt_name').text());
  280. localStorage.setItem("idcard",$(this).find('#txt_idcard').text());
  281. localStorage.setItem("address",$(this).find('#txt_add').text());
  282. localStorage.setItem("caseid",$(this).find('#txt_id').text());
  283. localStorage.setItem("sex",$(this).find('#txt_sex').text());
  284. localStorage.setItem("major",$(this).find('#txt_major').text());
  285. //增加判断:四小时内不能重复提交
  286. var strSql = "select count(t.ID) num from 巡检状态 t where t.一户一档ID = '"+$(this).find('#txt_id').text()+"' and t.时间 > (sysdate-(4.0/24))";
  287. new WsCommonClass("QueryDataBaseJson", ["sql"], [strSql], (evt)=>{
  288. var num = Number(evt.data[0].NUM);
  289. if(num > 0){
  290. mui.alert('四小时内不能重复提交!','提示',['确定'],null,'');
  291. return;
  292. }else{
  293. var html = "approveNew.html";
  294. // var html = "./mFAHomepageParticulars.html?id=" + listid;
  295. if(role=="3" ||role=="21"){
  296. $(location).attr('href', html);
  297. }
  298. }
  299. }, "queryCount");
  300. // alert(listid);
  301. // var html = "approveNew.html";
  302. // // var html = "./mFAHomepageParticulars.html?id=" + listid;
  303. // if(role=="3" ||role=="21"){
  304. // $(location).attr('href', html);
  305. // }else{
  306. //
  307. // }
  308. // var webview_sub = plus.webview.create(
  309. // html,
  310. // 'mFAHomepageParticulars', {}, {
  311. // name: 'davis'
  312. // }); //后台创建webview并打开页面
  313. // webview_sub.show('slide-in-right', 150);
  314. });
  315. var towncode;
  316. var towncode1;
  317. var districtcode;
  318. var role;
  319. var town;
  320. window.onload = function load(){
  321. //判断用户是否登录
  322. if(localStorage.getItem("username") == null){
  323. console.log('用户未登录');
  324. //跳转到登录页面
  325. window.location="login.html";
  326. return;
  327. }
  328. var district = localStorage.getItem("district");
  329. districtcode = localStorage.getItem("districtcode");
  330. town = localStorage.getItem("town");
  331. towncode = localStorage.getItem("towncode");
  332. var town1 = localStorage.getItem("town1");
  333. towncode1 = localStorage.getItem("towncode1");
  334. role = localStorage.getItem("ROLE");
  335. // alert(district+"/"+town);
  336. $("#towninfo").attr("placeholder",district+"/"+town);//.val("aaaa");//district+"/"+town);
  337. // 巡查员用户&区级管理员用户
  338. if(role=="3" ||role=="21"){
  339. document.getElementById("streetDiv").style.display="none";
  340. $("#div_totalcon").hide();
  341. getListInfo(towncode);
  342. queryPatrolStatus();
  343. }
  344. // 区级用户
  345. else if(role=="2"){
  346. $("#div_totalcon").show();
  347. //queryQXList(districtcode);
  348. //getListDistrictInfo(districtcode);
  349. queryPatrolStatus();
  350. queryQXListDistrict(districtcode);
  351. queryInspectorFind(district);
  352. //totalInfoArea1();
  353. }
  354. // 市级用户
  355. else if(role=="1"){
  356. $("#div_totalcon").show();
  357. // $("#item1").removeClass("mui-active");
  358. // $("#item2").addClass("mui-active");
  359. // $("#segmentedControl a").eq(1)[0].className="mui-control-item mui-active";//第二个tab设置当前页
  360. // $("#segmentedControl a").eq(0)[0].remove();//删第一个tab
  361. // 获取巡检状态
  362. queryPatrolStatus();
  363. // 获取任务清单
  364. queryQXListDistrict("");
  365. totalInfoCity();
  366. queryInspectorFindByCity( );
  367. }
  368. };
  369. function queryQXList(districtcode){
  370. var strSql = "";
  371. if(districtcode == "310")
  372. strSql = "select distinct(t.district) town,t.districtcode towncode from 系统用户信息表 t where t.districtcode !='310' order by districtcode ";
  373. else
  374. strSql = "select * from 系统用户信息表 t where districtcode='"+districtcode+"' order by towncode ";
  375. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryQXList");
  376. }
  377. function queryQXListDistrict(districtcode) {
  378. /* var strSql="select t.towncode,t.town from 系统用户信息表 t where districtcode='"+districtcode+"' " +
  379. "union select 0 towncode,to_char('未匹配') town from dual";
  380. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryQXListDis"); */
  381. // var strSql="select distinct t.towncode,to_char(t.town) town from 系统用户信息表新 t where t.districtcode='"+districtcode+"' and t.town is not null " +
  382. // "union select 0 towncode,to_char('未匹配') town from dual";
  383. var strSql="select distinct t.towncode,to_char(t.town) town from 系统用户信息表新 t where t.town is not null ";
  384. if(districtcode!=""){
  385. strSql += "and t.districtcode='"+districtcode+"'";
  386. }
  387. strSql += " union select 0 towncode,to_char('未匹配') town from dual ";
  388. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryQXListDis");
  389. }
  390. function queryPatrolStatus() {
  391. var strSql="select * from 编码表巡检状态 t where t.id!=5";
  392. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryPatrolStatus");
  393. }
  394. function queryInspectorFindByCity() {
  395. document.getElementById("newDataUlFind").innerHTML="";
  396. var datet = new Date();
  397. var monthstr = datet.getMonth()+1;
  398. var where="";
  399. /*if(monthstr=='1' || monthstr=='2' ||monthstr=='3'){
  400. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
  401. }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
  402. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
  403. }
  404. else if(monthstr=='7' ||monthstr=='8' ||monthstr=='9'){
  405. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
  406. }else if(monthstr=='10' || monthstr=='11' ||monthstr=='12'){
  407. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
  408. }*/
  409. if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
  410. where="1,2,3"
  411. }
  412. if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
  413. where="4,5,6"
  414. }
  415. if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
  416. where="7,8,9"
  417. }
  418. if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
  419. where="10,11,12"
  420. }
  421. //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";
  422. var strSql="select t.num 身份证,t.name 姓名,t.registere 执业地址," +
  423. "t.专业 从事专业,t.street 街道,t.时间 上报时间,t.手机 MOBILE from health.view_巡检 t " +
  424. "where t.sendyear="+datet.getFullYear()+
  425. " and t.sendmonth in ("+where+") and t.source=4 and t.sourcesub=1";
  426. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryInspectorFindByCity");
  427. }
  428. function queryInspectorFind(district) {
  429. var aa=district.substring(0, 2);
  430. document.getElementById("newDataUlFind").innerHTML="";
  431. var datet = new Date();
  432. var monthstr = datet.getMonth()+1;
  433. var where="";
  434. /* if(datet.getFullYear()=='2021'){
  435. if(monthstr=='6'){
  436. where=" and to_char(t.上报时间,'yyyy/mm') between '2021/01' and '2021/06'";
  437. }else if(monthstr=='7' || monthstr=='8' ||monthstr=='9'){
  438. where=" and to_char(t.上报时间,'yyyy/mm') between '2021/03' and '2021/09'";
  439. }else if(monthstr=='10' || monthstr=='11' ||monthstr=='12'){
  440. where=" and to_char(t.上报时间,'yyyy/mm') between '2021/05' and '2021/12'";
  441. }
  442. }else {
  443. if(monthstr=='1'||monthstr=='2'||monthstr=='3'){
  444. where=" and to_char(t.上报时间,'yyyy/mm') between '"+(datet.getFullYear()-1)+"/07' and '"+datet.getFullYear()+"/03'";
  445. }else if(monthstr=='4'||monthstr=='5'||monthstr=='6'){
  446. where=" and to_char(t.上报时间,'yyyy/mm') between '"+(datet.getFullYear()-1)+"/10' and '"+datet.getFullYear()+"/06'";
  447. }else if(monthstr=='7'||monthstr=='8'||monthstr=='9'){
  448. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/09'";
  449. }else if(monthstr=='10'||monthstr=='11'||monthstr=='12'){
  450. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/12'";
  451. }
  452. }
  453. 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";
  454. console.log(strSql)
  455. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryInspectorFind");
  456. */
  457. if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
  458. where="1,2,3"
  459. }
  460. if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
  461. where="4,5,6"
  462. }
  463. if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
  464. where="7,8,9"
  465. }
  466. if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
  467. where="10,11,12"
  468. }
  469. /*if(monthstr=='1' || monthstr=='2' ||monthstr=='3'){
  470. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
  471. }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
  472. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
  473. }
  474. else if(monthstr=='7' ||monthstr=='8' ||monthstr=='9'){
  475. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
  476. }else if(monthstr=='10' || monthstr=='11' ||monthstr=='12'){
  477. where=" and to_char(t.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
  478. }*/
  479. // 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";
  480. var strSql="select t.num 身份证,t.name 姓名,t.registere 执业地址," +
  481. "t.专业 从事专业,t.street 街道,t.时间 上报时间,t.手机 MOBILE from health.view_巡检 t " +
  482. "where t.sendyear="+datet.getFullYear()+
  483. " and t.sendmonth in ("+where+") and t.source=4 and t.sourcesub=1 and t.COUNTYSSTRING='"+district.substring(0, 2)+"'";
  484. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryInspectorFind");
  485. }
  486. function getListInfo(townCode){
  487. var datet = new Date();
  488. var monthstr = datet.getMonth()+1;
  489. var monthstr1 = "";
  490. if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
  491. monthstr1="1,2,3"
  492. }
  493. if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
  494. monthstr1="4,5,6"
  495. }
  496. if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
  497. monthstr1="7,8,9"
  498. }
  499. if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
  500. monthstr1="10,11,12"
  501. }
  502. var whereStr = "";
  503. if(town=="全街镇"){
  504. whereStr+=" and t.county='"+districtcode+"'";
  505. }else if(towncode!="" && towncode1!=""){
  506. whereStr=" and (t.streetid='"+towncode+"' or t.streetid='"+towncode1+"')";
  507. }else{
  508. whereStr=" and t.streetid='"+towncode+"'";
  509. }
  510. if(document.getElementById("select_source").value!='0' ){
  511. whereStr+=" and t.source="+document.getElementById("select_source").value;
  512. }
  513. if(document.getElementById("select_patrol").value!='-1'){
  514. if(document.getElementById("select_patrol").value=='0'){
  515. whereStr+=" and t.巡检状态ID is not null ";
  516. }else {
  517. whereStr+=" and t.巡检状态ID is null ";
  518. }
  519. }
  520. if(document.getElementById("select_conclusion").value){
  521. if(document.getElementById("select_conclusion").value!='-1'){
  522. whereStr+=" and t.巡检状态ID="+document.getElementById("select_conclusion").value;
  523. }
  524. }
  525. var strSql = " select * "+
  526. "from (select to_char(t.id) id, "+
  527. "to_char(t.NAME) name, "+
  528. "to_char(t.REGISTERE) REGISTERE, "+
  529. "to_char(t.NUM) NUM, "+
  530. // "0 conent, "+
  531. "to_char(nvl(aa.content, '0')) conent, "+
  532. "'巡检' as type,t.专业,t.sex,t.street 街镇,t.巡检状态,t.排序,t.ZDPC "+
  533. "from VIEW_巡检 t "+
  534. "left join (select count(0) content, t.一户一档id "+
  535. "from 巡检状态 t where t.时间 between ADD_MONTHS(sysdate, -3) and sysdate "+
  536. "group by t.一户一档id) aa "+
  537. "on t.id = aa.一户一档id "+
  538. "where 1=1 "+whereStr+
  539. "and t.sendyear = '"+datet.getFullYear() +"' "+
  540. "and t.sendmonth in ("+monthstr1+") "+
  541. //"and (t.sendmonth = '1' or t.sendmonth = '2' or t.sendmonth = '3') "+
  542. ") t where 1=1 "+
  543. "order by t.排序 ";
  544. console.log(strSql)
  545. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryUser");
  546. // 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 ";
  547. }
  548. function getListDistrictInfo(townCode){
  549. document.getElementById("newDataUl").innerHTML="";
  550. var datet = new Date();
  551. var monthstr = datet.getMonth()+1;
  552. var monthstr1 = "";
  553. if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
  554. monthstr1="1,2,3"
  555. }
  556. if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
  557. monthstr1="4,5,6"
  558. }
  559. if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
  560. monthstr1="7,8,9"
  561. }
  562. if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
  563. monthstr1="10,11,12"
  564. }
  565. var whereStr = "";
  566. console.log("streetid", document.getElementById("select_street").value);
  567. if(document.getElementById("select_street").value!='-1' ){
  568. if(document.getElementById("select_street").value=="0"){
  569. whereStr+=" and streetid is null ";
  570. }else{
  571. whereStr+=" and streetid='"+document.getElementById("select_street").value+"' ";
  572. }
  573. }
  574. if(document.getElementById("select_source").value!='0' ){
  575. whereStr+=" and source="+document.getElementById("select_source").value;
  576. }
  577. if(document.getElementById("select_patrol").value!='-1'){
  578. if(document.getElementById("select_patrol").value=='0'){
  579. whereStr+=" and 巡检状态ID is not null ";
  580. }else {
  581. whereStr+=" and 巡检状态ID is null ";
  582. }
  583. }
  584. console.log("巡检状态ID", document.getElementById("select_conclusion").value);
  585. // if (document.getElementById("select_conclusion").value != '-1') {
  586. // whereStr += " and 巡检状态ID=" + document.getElementById("select_conclusion").value;
  587. // }
  588. let xc_value = document.getElementById("select_conclusion").value;
  589. if (xc_value != '-1' && xc_value != "") {
  590. whereStr += " and 巡检状态ID=" + document.getElementById("select_conclusion").value;
  591. }
  592. var strSql = " select * "+
  593. "from (select to_char(t.id) id, "+
  594. "to_char(t.NAME) name, "+
  595. " to_char(t.streetid) street, "+
  596. "to_char(t.REGISTERE) REGISTERE, "+
  597. "to_char(t.NUM) NUM, "+
  598. // "0 conent, "+
  599. "to_char(nvl(aa.content, '0')) conent, "+
  600. "'巡检' type, " +
  601. "to_char(t.streetid) streetid,t.专业,t.sex,t.street 街镇,t.巡检状态,t.排序,t.ZDPC " +
  602. "from VIEW_巡检 t "+
  603. "left join (select count(0) content, t.一户一档id "+
  604. "from 巡检状态 t where t.时间 between ADD_MONTHS(sysdate, -3) and sysdate "+
  605. "group by t.一户一档id) aa "+
  606. "on t.id = aa.一户一档id where 1=1 ";
  607. // 市级不过滤
  608. if(role != "1"){
  609. strSql += "and t.county like '"+districtcode+"%' ";
  610. }
  611. strSql += "and t.sendyear = '"+datet.getFullYear() +"' "+
  612. "and t.sendmonth in ("+monthstr1+") "+ whereStr +
  613. //"and t.sendmonth in (1,2,3) "+ whereStr +
  614. " order by t.排序,t.streetid) t where 1=1";
  615. console.log(strSql)
  616. // 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 ";
  617. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"queryUser");
  618. $("#total").html("总计0条");
  619. }
  620. function querySuccess(evt,token){
  621. var jsonData = evt.data;
  622. if(jsonData != null){
  623. switch (token){
  624. case "queryUser":
  625. //console.log(jsonData)
  626. $("#total").html("总计"+jsonData.length+"条");
  627. document.getElementById("newDataUl").innerHTML="";
  628. for(var i=0;i<jsonData.length;i++){
  629. var address ;
  630. var name;
  631. var idcarid;
  632. var addressInfo = jsonData[i].REGISTERE.toString();
  633. if(addressInfo.indexOf("身份证:")>0){
  634. idcarid = addressInfo.substr(addressInfo.indexOf("身份证")+4,18);
  635. address = addressInfo.substr(addressInfo.indexOf("身份证")+22,addressInfo.length-1);
  636. }else{
  637. idcarid = jsonData[i].NUM;
  638. address = jsonData[i].REGISTERE;
  639. }
  640. name = jsonData[i].NAME;
  641. // 巡查员用户&区级管理员用户
  642. if(role=="3" ||role=="21"){
  643. //createNewDataList(jsonData[i].conent,address,name,idcarid,jsonData[i].id,'0');
  644. createNewDataList(jsonData[i].CONENT,address,name,idcarid,jsonData[i].ID,'0',jsonData[i].SEX,jsonData[i].专业,jsonData[i].街镇,jsonData[i].巡检状态,jsonData[i].ZDPC);
  645. }else{
  646. if(jsonData[i].type=='推送'){
  647. //createNewDataList(jsonData[i].conent,address,name,idcarid,jsonData[i].id,'1');
  648. createNewDataList(jsonData[i].CONENT,address,name,idcarid,jsonData[i].ID,'1',jsonData[i].SEX,jsonData[i].专业,jsonData[i].街镇,jsonData[i].巡检状态,jsonData[i].ZDPC);
  649. }else{
  650. //createNewDataList(jsonData[i].conent,address,name,idcarid,jsonData[i].id,jsonData[i].streetid);
  651. 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);
  652. }
  653. }
  654. }
  655. break;
  656. case "queryQXList":
  657. Select_DyCreate("select_jd",jsonData,"towncode","town",true);
  658. // Select_DyCreate("select_jd1",jsonData,"towncode","town",true);
  659. break;
  660. case "queryQXListDis" :
  661. Select_DyCreate("select_street",jsonData,"TOWNCODE","TOWN",true);
  662. //区级
  663. if(role=="2"){
  664. // 获取完成情况
  665. totalInfoArea();
  666. getListDistrictInfo(districtcode);
  667. }else{
  668. getListDistrictInfo("");
  669. }
  670. break;
  671. case "queryPatrolStatus":
  672. Select_DyCreate("select_conclusion",jsonData,"ID","状态",true);
  673. break;
  674. case "queryConclusion":
  675. if(jsonData.length>0){
  676. document.getElementById("newDataUl1").innerHTML="";
  677. for(var i=0;i<jsonData.length;i++) {
  678. var strTask="";
  679. var xc="";
  680. if(jsonData[i].现场查见=='1'){
  681. xc="在联";
  682. }
  683. if(jsonData[i].现场查见=='0'){
  684. xc="失联";
  685. }
  686. var zy="";
  687. if(jsonData[i].内科=='1'){
  688. zy+="内科,"
  689. }
  690. if(jsonData[i].牙科=='1'){
  691. zy+="牙科,"
  692. }
  693. if(jsonData[i].医美=='1'){
  694. zy+="医美,"
  695. }
  696. if(jsonData[i].其他=='1'){
  697. zy+=jsonData[i].内容;
  698. }
  699. var height=40;
  700. if(jsonData[i].状态!="已搬离"){
  701. if(zy=="" &&xc==""){
  702. height=40;
  703. }else{
  704. strTask="<label style='width: 65%'>"+zy+"</label><label style='width: 35%'>"+xc+"</label>";
  705. height=80;
  706. }
  707. }
  708. var str = " <div class='mui-input-row' style='height:"+height+"px;'>"+
  709. "<label style='width: 65%'>"+jsonData[i].时间.substr(0,11)+"</label><label style='width: 35%'>"+jsonData[i].状态+"</label>"+strTask+
  710. "</div>";
  711. $("#newDataUl1").append(str);
  712. }
  713. mui("#conclusionpopover").popover('toggle', document.getElementById("ta"));
  714. }
  715. break;
  716. case "totalInfo":
  717. for(var i=0;i<jsonData.length;i++){
  718. var table = "<tr><td>"+jsonData[i].所属街道.toString()+"</td>"+
  719. "<td>"+jsonData[i].下发数.toString()+"</td>"+
  720. "<td>"+jsonData[i].已排查.toString()+"</td>"+
  721. "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
  722. $("#tablebody").append(table);
  723. }
  724. break;
  725. case "queryInspectorFindByCity":{
  726. for(var i=0;i<jsonData.length;i++) {
  727. var sfz='';
  728. if(jsonData[i].身份证=="undefined" ||jsonData[i].身份证==''){
  729. sfz='';
  730. }else{
  731. sfz=jsonData[i].身份证;
  732. }
  733. var str = "<li id='list' class='mui-table-view-cell mui-media'>" +
  734. "<a href='javascript:;'>" +
  735. /*"<div class=' mui-pull-right'>" +
  736. "</div>" +*/
  737. "<div class='mui-media-body maintext' >" +
  738. "<p class='mui-ellipsis'>" +
  739. "<table style='font-size: 14px;color: grey;'>" +
  740. "<tr><td>所属街道:</td><td>"+jsonData[i].街道+"</td></tr>" +
  741. "<tr><td>行医人姓名:</td><td>"+jsonData[i].姓名+"</td></tr>" +
  742. "<tr><td>地址:</td><td>"+jsonData[i].执业地址+"</td></tr>" +
  743. "<tr><td>专业:</td><td>"+jsonData[i].从事专业+"</td></tr>" +
  744. "<tr><td>身份证:</td><td>"+sfz+"</td></tr>" +
  745. "<tr><td>上报时间:</td><td>"+jsonData[i].上报时间.substring(0,19)+"</td></tr>" +
  746. "<tr><td>巡查员手机:</td><td>"+jsonData[i].MOBILE+"</td></tr>" +
  747. "</table>" +
  748. "</p>"+
  749. "</div>" +
  750. "</a>" +
  751. "</li>";
  752. $("#newDataUlFind").append(str);
  753. }
  754. break;
  755. }
  756. case "queryInspectorFind":
  757. /* for(var i=0;i<jsonData.length;i++) {
  758. var str = "<li id='list' class='mui-table-view-cell mui-media'>" +
  759. "<a href='javascript:;'>" +
  760. "<div class='mui-media-body maintext' >" +
  761. "<p class='mui-ellipsis-'>" + jsonData[i].街道 + "</p>" +
  762. "<p class='mui-ellipsis'>" + jsonData[i].姓名 + "</p>" +
  763. "<p class='mui-ellipsis'>" + jsonData[i].执业地址 + "</p>" +
  764. "<p class='mui-ellipsis'>" + jsonData[i].从事专业 + "</p>" +
  765. "<p class='mui-ellipsis' >" + jsonData[i].身份证 + "</p>" +
  766. "<p class='mui-ellipsis' >" + jsonData[i].上报时间 + "</p>" +
  767. "<p class='mui-ellipsis' >" + jsonData[i].MOBILE + "</p>" +
  768. "</div>" +
  769. "</a>" +
  770. "</li>";
  771. $("#newDataUlFind").append(str);
  772. } */
  773. for(var i=0;i<jsonData.length;i++) {
  774. var sfz='';
  775. if(jsonData[i].身份证=="undefined" ||jsonData[i].身份证==''){
  776. sfz='';
  777. }else{
  778. sfz=jsonData[i].身份证;
  779. }
  780. var str = "<li id='list' class='mui-table-view-cell mui-media'>" +
  781. "<a href='javascript:;'>" +
  782. /*"<div class=' mui-pull-right'>" +
  783. "</div>" +*/
  784. "<div class='mui-media-body maintext' >" +
  785. "<p class='mui-ellipsis'>" +
  786. "<table style='font-size: 14px;color: grey;'>" +
  787. "<tr><td>所属街道:</td><td>"+jsonData[i].街道+"</td></tr>" +
  788. "<tr><td>行医人姓名:</td><td>"+jsonData[i].姓名+"</td></tr>" +
  789. "<tr><td>地址:</td><td>"+jsonData[i].执业地址+"</td></tr>" +
  790. "<tr><td>专业:</td><td>"+jsonData[i].从事专业+"</td></tr>" +
  791. "<tr><td>身份证:</td><td>"+sfz+"</td></tr>" +
  792. "<tr><td>上报时间:</td><td>"+jsonData[i].上报时间.substring(0,19)+"</td></tr>" +
  793. "<tr><td>巡查员手机:</td><td>"+jsonData[i].MOBILE+"</td></tr>" +
  794. "</table>" +
  795. "</p>"+
  796. /*"<p class='mui-ellipsis'>所属街道:" + jsonData[i].街道 + "</p>" +
  797. "<p class='mui-ellipsis'>行医人姓名:" + jsonData[i].姓名 + "</p>" +
  798. "<p class='mui-ellipsis'>地址:" + jsonData[i].执业地址 + "</p>" +
  799. "<p class='mui-ellipsis'>专业:" + jsonData[i].从事专业 + "</p>" +
  800. "<p class='mui-ellipsis' >身份证:" + jsonData[i].身份证 + "</p>" +
  801. "<p class='mui-ellipsis' >上报时间:" + jsonData[i].上报时间 + "</p>" +
  802. "<p class='mui-ellipsis' >巡查员手机:" + jsonData[i].MOBILE + "</p>" +*/
  803. "</div>" +
  804. "</a>" +
  805. "</li>";
  806. $("#newDataUlFind").append(str);
  807. }
  808. break;
  809. case "totalInfoCity":{
  810. var xfs=0;
  811. var ybc=0;
  812. var xcy=0;
  813. for(var i=0;i<jsonData.length;i++){
  814. if(jsonData[i].街道.toString()==""){
  815. var table="<li class='mui-table-view-cell mui-media'>"+
  816. "<div class='mui-media-body'>"+
  817. "<span style='font-size: 16px'>未匹配</span>"+
  818. "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
  819. "<tr>" +
  820. "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
  821. "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
  822. "</tr>" +
  823. "<tr>" +
  824. "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" +
  825. "<td style='border:80px'>巡查员发现:0</td>" +
  826. "</tr>" +
  827. "</table></p>"+
  828. "</div>"+
  829. "</li>";
  830. $("#tablebody").append(table);
  831. }else{
  832. var table="<li class='mui-table-view-cell mui-media'>"+
  833. "<div class='mui-media-body'>"+
  834. "<span style='font-size: 16px'>区域:"+jsonData[i].街道.toString()+"</span>"+
  835. "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
  836. "<tr>" +
  837. "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
  838. "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
  839. "</tr>" +
  840. "<tr>" +
  841. "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" +
  842. "<td style='border:80px'>巡查员发现:"+jsonData[i].巡查员发现.toString()+"</td>" +
  843. "</tr>" +
  844. "</table></p>"+
  845. "</div>"+
  846. "</li>";
  847. $("#tablebody").append(table);
  848. }
  849. xfs+=jsonData[i].下发数-0;
  850. ybc+=jsonData[i].已排查-0;
  851. xcy+=jsonData[i].巡查员发现-0;
  852. }
  853. /*var table = "<tr><td>合计</td>"+
  854. "<td>"+xfs+"</td>"+
  855. "<td>"+ybc+"</td>"+
  856. "<td>"+(ybc/xfs*100).toFixed(1)+"%</td>" +
  857. "<td>"+xcy+"</td>" +
  858. "</tr>";*/
  859. var table="<li class='mui-table-view-cell mui-media'>"+
  860. "<div class='mui-media-body'>"+
  861. "<span style='font-size: 16px'>合计</span>"+
  862. "<p class='mui-ellipsis'style='margin-left: 22%'><span>下发数:"+xfs+" </span><span style='margin-left: 30%'>已巡查:"+ybc+"</span></p>"+
  863. "<p class='mui-ellipsis'style='margin-left: 22%'><span>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</span><span style='margin-left: 22%'>巡查员发现:"+xcy+"</span></p>"+
  864. "</div>"+
  865. "</li>";
  866. var table="<li class='mui-table-view-cell mui-media'>"+
  867. "<div class='mui-media-body'>"+
  868. "<span style='font-size: 16px'>合计</span>"+
  869. "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
  870. "<tr>" +
  871. "<td style='width: 40%'>下发数:"+xfs+"</td>" +
  872. "<td style='border:80'>已巡查:"+ybc+"</td>" +
  873. "</tr>" +
  874. "<tr>" +
  875. "<td style='width: 40%'>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</td>" +
  876. "<td style='border:80px'>巡查员发现:"+xcy+"</td>" +
  877. "</tr>" +
  878. "</table></p>"+
  879. "</div>"+
  880. "</li>";
  881. $("#tablebody").append(table);
  882. break
  883. }
  884. case "totalInfoArea":
  885. // var xfs=0;
  886. // var ybc=0;
  887. // var xcy=0;
  888. /* for(var i=0;i<jsonData.length;i++){
  889. var table = "<tr><td>"+jsonData[i].COUNTYSSTRING.toString()+"</td>"+
  890. "<td>"+jsonData[i].下发数.toString()+"</td>"+
  891. "<td>"+jsonData[i].已排查.toString()+"</td>"+
  892. "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
  893. $("#tablebody").append(table);
  894. } */
  895. /* for(var i=0;i<jsonData.length;i++){
  896. if(jsonData[i].STREET.toString()==""){
  897. var table = "<tr><td>未匹配</td>"+
  898. "<td>"+jsonData[i].下发数.toString()+"</td>"+
  899. "<td>"+jsonData[i].已排查.toString()+"</td>"+
  900. "<td>"+jsonData[i].巡查率.toString()+"</td>" +
  901. "<td>0</td>" +
  902. "</tr>";
  903. $("#tablebody").append(table);
  904. }else{
  905. var table = "<tr><td>"+jsonData[i].STREET.toString()+"</td>"+
  906. "<td>"+jsonData[i].下发数.toString()+"</td>"+
  907. "<td>"+jsonData[i].已排查.toString()+"</td>"+
  908. "<td>"+jsonData[i].巡查率.toString()+"</td>" +
  909. "<td>"+jsonData[i].巡查员发现.toString()+"</td>" +
  910. "</tr>";
  911. $("#tablebody").append(table);
  912. }
  913. xfs+=jsonData[i].下发数-0;
  914. ybc+=jsonData[i].已排查-0;
  915. xcy+=jsonData[i].巡查员发现-0;
  916. }
  917. var table = "<tr><td>合计</td>"+
  918. "<td>"+xfs+"</td>"+
  919. "<td>"+ybc+"</td>"+
  920. "<td>"+(ybc/xfs*100).toFixed(1)+"%</td>" +
  921. "<td>"+xcy+"</td>" +
  922. "</tr>";
  923. $("#tablebody").append(table);
  924. getListDistrictInfo(districtcode); */
  925. var xfs=0;
  926. var ybc=0;
  927. var xcy=0;
  928. for(var i=0;i<jsonData.length;i++){
  929. if(jsonData[i].STREET.toString()==""){
  930. var table="<li class='mui-table-view-cell mui-media'>"+
  931. "<div class='mui-media-body'>"+
  932. "<span style='font-size: 16px'>未匹配</span>"+
  933. "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
  934. "<tr>" +
  935. "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
  936. "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
  937. "</tr>" +
  938. "<tr>" +
  939. "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" + "<td style='border:80px'>巡查员发现:0</td>" +
  940. "<td style='border:80px'>巡查员发现:0</td>" +
  941. "</tr>" +
  942. "</table></p>"+
  943. "</div>"+
  944. "</li>";
  945. $("#tablebody").append(table);
  946. }else{
  947. var table="<li class='mui-table-view-cell mui-media'>"+
  948. "<div class='mui-media-body'>"+
  949. "<span style='font-size: 16px'>区域:"+jsonData[i].STREET.toString()+"</span>"+
  950. "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
  951. "<tr>" +
  952. "<td style='width: 40%'>下发数:"+jsonData[i].下发数.toString()+"</td>" +
  953. "<td style='border:80px'>已巡查:"+jsonData[i].已排查.toString()+"</td>" +
  954. "</tr>" +
  955. "<tr>" +
  956. "<td style='width: 40%'>巡查率:"+(jsonData[i].已排查/jsonData[i].下发数*100).toFixed(1)+"%</td>" +
  957. "<td style='border:80px'>巡查员发现:"+jsonData[i].巡查员发现.toString()+"</td>" +
  958. "</tr>" +
  959. "</table></p>"+
  960. "</div>"+
  961. "</li>";
  962. $("#tablebody").append(table);
  963. }
  964. xfs+=jsonData[i].下发数-0;
  965. ybc+=jsonData[i].已排查-0;
  966. xcy+=jsonData[i].巡查员发现-0;
  967. }
  968. /*var table = "<tr><td>合计</td>"+
  969. "<td>"+xfs+"</td>"+
  970. "<td>"+ybc+"</td>"+
  971. "<td>"+(ybc/xfs*100).toFixed(1)+"%</td>" +
  972. "<td>"+xcy+"</td>" +
  973. "</tr>";*/
  974. var table="<li class='mui-table-view-cell mui-media'>"+
  975. "<div class='mui-media-body'>"+
  976. "<span style='font-size: 16px'>合计</span>"+
  977. "<p class='mui-ellipsis'style='margin-left: 22%'><span>下发数:"+xfs+" </span><span style='margin-left: 30%'>已巡查:"+ybc+"</span></p>"+
  978. "<p class='mui-ellipsis'style='margin-left: 22%'><span>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</span><span style='margin-left: 22%'>巡查员发现:"+xcy+"</span></p>"+
  979. "</div>"+
  980. "</li>";
  981. var table="<li class='mui-table-view-cell mui-media'>"+
  982. "<div class='mui-media-body'>"+
  983. "<span style='font-size: 16px'>合计</span>"+
  984. "<p class='mui-ellipsis'style='margin-left: 22%'><table style='margin-left: 22%;font-size: 14px;color: grey;border-collapse:collapse;width: 100%'>" +
  985. "<tr>" +
  986. "<td style='width: 40%'>下发数:"+xfs+"</td>" +
  987. "<td style='border:80'>已巡查:"+ybc+"</td>" +
  988. "</tr>" +
  989. "<tr>" +
  990. "<td style='width: 40%'>巡查率:"+(ybc/xfs*100).toFixed(1)+"%</td>" +
  991. "<td style='border:80px'>巡查员发现:"+xcy+"</td>" +
  992. "</tr>" +
  993. "</table></p>"+
  994. "</div>"+
  995. "</li>";
  996. $("#tablebody").append(table);
  997. // getListDistrictInfo(districtcode);
  998. break;
  999. case "totalInfoArea1":
  1000. for(var i=0;i<jsonData.length;i++){
  1001. var table = "<tr><td>"+jsonData[i].TOWN.toString()+"</td>"+
  1002. "<td>"+jsonData[i].下发数.toString()+"</td>"+
  1003. "<td>"+jsonData[i].已排查.toString()+"</td>"+
  1004. "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
  1005. $("#tablebody1").append(table);
  1006. }
  1007. break;
  1008. case "totalInfo1":
  1009. for(var i=0;i<jsonData.length;i++){
  1010. var table = "<tr><td>"+jsonData[i].TOWN.toString()+"</td>"+
  1011. "<td>"+jsonData[i].下发数.toString()+"</td>"+
  1012. "<td>"+jsonData[i].已排查.toString()+"</td>"+
  1013. "<td>"+jsonData[i].未排查.toString()+"</td></tr>";
  1014. $("#tablebody1").append(table);
  1015. }
  1016. break;
  1017. case "updateRead":
  1018. getListDistrictInfo(districtcode);
  1019. break;
  1020. default:
  1021. break;
  1022. }
  1023. }
  1024. }
  1025. function jdchange(){
  1026. $("#tablebody").html('');
  1027. if(Select_GetSelectText("select_jd") == "全部"){
  1028. document.getElementById("tablebody").innerHTML="";
  1029. totalInfoArea("全部");
  1030. getListDistrictInfo(districtcode);
  1031. }else{
  1032. document.getElementById("tablebody").innerHTML="";
  1033. totalInfo(Select_GetSelectValue("select_jd"));
  1034. }
  1035. }
  1036. function totalInfoArea() {
  1037. var datet = new Date();
  1038. var monthstr = datet.getMonth()+1;
  1039. var monthstr1 = "";
  1040. if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
  1041. monthstr1="1,2,3"
  1042. }
  1043. if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
  1044. monthstr1="4,5,6"
  1045. }
  1046. if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
  1047. monthstr1="7,8,9"
  1048. }
  1049. if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
  1050. monthstr1="10,11,12"
  1051. }
  1052. var where = "";
  1053. var where1="";
  1054. if(monthstr=='1' || monthstr=='2' || monthstr=='3'){
  1055. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
  1056. }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
  1057. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
  1058. }
  1059. else if(monthstr=='7' || monthstr=='8' ||monthstr=='9'){
  1060. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
  1061. }else if(monthstr=='10' ||monthstr=='11' ||monthstr=='12'){
  1062. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
  1063. }
  1064. var strSql ="select aa.STREET,aa.下发数,NVL(bb.已排查,0) 已排查,round(NVL(bb.已排查, 0)/NVL(aa.下发数, 0),3)*100 || '%' 巡查率,NVL(巡查员发现,0) 巡查员发现 from ( "+
  1065. "select count(1) 下发数,t.STREETID 街道编码,t.STREET from view_巡检 t where t.sendyear='"+new Date().getFullYear()+"' " +
  1066. "and t.sendmonth in ("+datet.getMonth()+","+monthstr+","+monthstr1+") and t.county like '"+districtcode+"%' group by t.STREET,t.STREETID) aa "+
  1067. //"and t.sendmonth in (1,2,3) and t.county like '"+districtcode+"%' group by t.STREET,t.STREETID) aa "+
  1068. "left join (select count(1) 已排查,t.STREETID 街道编码 from (select distinct(t.一户一档id) from 巡检状态 t ) aa left join view_巡检 t on t.id=aa.一户一档id "+
  1069. "where t.sendyear='"+new Date().getFullYear()+"' and t.county like '"+districtcode+"%' and t.sendmonth in ("+monthstr1+") group by t.STREETID) bb "+
  1070. //"where t.sendyear='"+new Date().getFullYear()+"' and t.county like '"+districtcode+"%' and t.sendmonth in (1,2,3) group by t.STREETID) bb "+
  1071. "on aa.街道编码=bb.街道编码 " +
  1072. " left join (select yy.街道 ,count(yy.街道) 巡查员发现 from 巡检新增 yy "+where1+" group by yy.街道) cc on aa.STREET=cc.街道 order by aa.STREET";
  1073. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfoArea");
  1074. }
  1075. function totalInfoCity() {
  1076. var datet = new Date();
  1077. var monthstr = datet.getMonth()+1;
  1078. var monthstr1 = "";
  1079. if(monthstr=="1" ||monthstr=="2" ||monthstr=="3" ){
  1080. monthstr1="1,2,3"
  1081. }
  1082. if(monthstr=="4" ||monthstr=="5" ||monthstr=="6" ){
  1083. monthstr1="4,5,6"
  1084. }
  1085. if(monthstr=="7" ||monthstr=="8" ||monthstr=="9" ){
  1086. monthstr1="7,8,9"
  1087. }
  1088. if(monthstr=="10" ||monthstr=="11" ||monthstr=="12" ){
  1089. monthstr1="10,11,12"
  1090. }
  1091. var where = "";
  1092. var where1="";
  1093. if(monthstr=='1' || monthstr=='2' || monthstr=='3'){
  1094. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/01' and '"+datet.getFullYear()+"/03'";
  1095. }else if(monthstr=='4' || monthstr=='5' ||monthstr=='6'){
  1096. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/04' and '"+datet.getFullYear()+"/06'";
  1097. }
  1098. else if(monthstr=='7' || monthstr=='8' ||monthstr=='9'){
  1099. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/07' and '"+datet.getFullYear()+"/09'";
  1100. }else if(monthstr=='10' ||monthstr=='11' ||monthstr=='12'){
  1101. where1=" where to_char(yy.上报时间,'yyyy/mm') between '"+datet.getFullYear()+"/10' and '"+datet.getFullYear()+"/12'";
  1102. }
  1103. var strSql ="select aa.街道,aa.下发数,NVL(bb.已排查,0) 已排查,round(NVL(bb.已排查, 0)/NVL(aa.下发数, 0),3)*100 || '%' 巡查率,NVL(巡查员发现,0) 巡查员发现 from ( "+
  1104. "select count(1) 下发数,t.COUNTYSSTRING 街道 ,t.COUNTY from view_巡检 t where t.sendyear='"+new Date().getFullYear()+"' " +
  1105. "and t.sendmonth in ("+datet.getMonth()+","+monthstr+","+monthstr1+") group by t.COUNTYSSTRING,t.COUNTY) aa "+
  1106. "left join (select count(1) 已排查,t.county 街道编码 from (select distinct(t.一户一档id) from 巡检状态 t ) aa left join view_巡检 t on t.id=aa.一户一档id "+
  1107. "where t.sendyear='"+new Date().getFullYear()+"' and t.sendmonth in ("+monthstr1+") group by t.county) bb "+
  1108. "on aa.county=bb.街道编码 " +
  1109. " left join (select yy.区县 ,count(yy.区县) 巡查员发现 from 巡检新增 yy "+where1+" group by yy.区县) cc on '%'||aa.county||'%' like cc.区县 order by aa.county";
  1110. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfoCity");
  1111. }
  1112. function totalInfo(street){
  1113. var where = "";
  1114. if(street == "全部"){
  1115. where = " and streetid like '"+districtcode+"%'";
  1116. }else{
  1117. where = " and streetid like '"+street+"%'";
  1118. }
  1119. /* 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"+
  1120. " left join "+
  1121. " (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"+
  1122. " on aa.所属街道=bb.所属街道 order by aa.towncode asc"; */
  1123. 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"+
  1124. " left join "+
  1125. " (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"+
  1126. " on aa.所属街道=bb.所属街道 order by aa.towncode asc";
  1127. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfo");
  1128. }
  1129. function jdchange1(){
  1130. /* $("#tablebody1").html('');
  1131. if(Select_GetSelectText("select_jd1") == "全部"){
  1132. document.getElementById("tablebody1").innerHTML="";
  1133. totalInfoArea1("全部");
  1134. }else{
  1135. document.getElementById("tablebody1").innerHTML="";
  1136. totalInfo1(Select_GetSelectValue("select_jd1"));
  1137. } */
  1138. $("#tablebody1").html('');
  1139. if(Select_GetSelectText("select_jd1") == "全部"){
  1140. document.getElementById("tablebody1").innerHTML="";
  1141. totalInfoArea1("全部");
  1142. }else{
  1143. document.getElementById("tablebody1").innerHTML="";
  1144. totalInfo1(Select_GetSelectValue("select_jd1"));
  1145. }
  1146. }
  1147. function totalInfoArea1() {
  1148. var datet = new Date();
  1149. var monthstr = datet.getMonth()+1;
  1150. var where = "";
  1151. /* var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属区县代码 from 系统推送信息 a where 1=1 "+
  1152. "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码) t "+
  1153. "left join (select count(a.所属区县代码) 已排查,a.所属区县代码 from JSWGISDATA.系统推送信息 a "+
  1154. "left join (select distinct t.一户一档id from 巡检状态 t "+
  1155. "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
  1156. "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码 "+
  1157. ") t1 on t.所属区县代码=t1.所属区县代码 "+
  1158. "left join (select distinct(t.district) town,t.districtcode countysstring from 系统用户信息表 t where t.districtcode !='310' order by districtcode) y "+
  1159. "on t.所属区县代码=y.countysstring"; */
  1160. var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属区县代码 from 系统推送信息 a where 1=1 "+
  1161. "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码) t "+
  1162. "left join (select count(a.所属区县代码) 已排查,a.所属区县代码 from 系统推送信息 a "+
  1163. "left join (select distinct t.一户一档id from 巡检状态 t "+
  1164. "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
  1165. "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate group by a.所属区县代码 "+
  1166. ") t1 on t.所属区县代码=t1.所属区县代码 "+
  1167. "left join (select distinct(t.district) town,t.districtcode countysstring from 系统用户信息表 t where t.districtcode !='310' order by districtcode) y "+
  1168. "on t.所属区县代码=y.countysstring";
  1169. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfoArea1");
  1170. }
  1171. function totalInfo1(street){
  1172. var where = "";
  1173. /* if(street == "全部"){
  1174. where = " and streetid like '"+districtcode+"%'";
  1175. }else{
  1176. where = " and 所属街道代码 like '"+street+"%' ";
  1177. } */
  1178. if(street == "全部"){
  1179. where = " and streetid like '"+districtcode+"%'";
  1180. }else{
  1181. where = " and 所属街道代码 like '"+street+"%' ";
  1182. }
  1183. /* var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属街道代码 from 系统推送信息 a where 1=1 "+
  1184. "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码) t "+
  1185. "left join (select count(a.所属街道代码) 已排查,a.所属街道代码 from JSWGISDATA.系统推送信息 a "+
  1186. "left join (select distinct t.一户一档id from 巡检状态 t "+
  1187. "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
  1188. "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码 "+
  1189. ") t1 on t.所属街道代码=t1.所属街道代码 "+
  1190. "left join (select distinct(t.town) town,t.towncode from 系统用户信息表 t where t.districtcode !='310' order by t.towncode) y "+
  1191. "on t.所属街道代码=y.towncode"; */
  1192. var strSql ="select t.下发数,y.town,NVL(t1.已排查,0) 已排查,NVL(t.下发数,0)-NVL(t1.已排查,0) 未排查 from (select count(*) 下发数,a.所属街道代码 from 系统推送信息 a where 1=1 "+
  1193. "and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码) t "+
  1194. "left join (select count(a.所属街道代码) 已排查,a.所属街道代码 from 系统推送信息 a "+
  1195. "left join (select distinct t.一户一档id from 巡检状态 t "+
  1196. "where 1 = 1 and t.时间 between ADD_MONTHS(sysdate, -2) and sysdate ) aa on a.id = aa.一户一档id "+
  1197. "where 1 = 1 and a.推送时间 between ADD_MONTHS(sysdate,-2) and sysdate "+where+" group by a.所属街道代码 "+
  1198. ") t1 on t.所属街道代码=t1.所属街道代码 "+
  1199. "left join (select distinct(t.town) town,t.towncode from 系统用户信息表 t where t.districtcode !='310' order by t.towncode) y "+
  1200. "on t.所属街道代码=y.towncode";
  1201. new WsCommonClass("QueryDataBaseJson",["sql"],[strSql],querySuccess,"totalInfo1");
  1202. }
  1203. function conditionSearch(){
  1204. // if( role=="1"){
  1205. // mui.alert('模块更新中 敬请期待!!!', '系统提示', function() {});
  1206. // }else{
  1207. // mui("#popover").popover('toggle', document.getElementById("ta"));
  1208. // }
  1209. mui("#popover").popover('toggle', document.getElementById("ta"));
  1210. }
  1211. function conclusionPopover(id) {
  1212. var sql="select t.时间,y.状态,y1.WHETHERINSCENE 现场查见," +
  1213. "INTERNALMEDICINE 内科,DENTAL 牙科,MEDICAKBEAUTY 医美," +
  1214. "MEDICINEOTHER 其他,MEDICINEOTHERCONTENT 内容 from 巡检状态 t " +
  1215. "left join 编码表巡检状态 y on t.状态=y.id " +
  1216. "left join PATROLSTATUS y1 on t.id=y1.PATROLSTATUSID where t.一户一档id="+id;
  1217. new WsCommonClass("QueryDataBaseJson",["sql"],[sql],querySuccess,"queryConclusion");
  1218. }
  1219. function onclickRead(id) {
  1220. mui.confirm('是否已读','提示',['取消','确定'],function (e) {
  1221. if(e.index==1){
  1222. var sql="update 一户一档 t set t.read=1 where id="+id;
  1223. new WsCommonClass("QueryDataBaseJson",["sql"],[sql],querySuccess,"updateRead");
  1224. }else{
  1225. return
  1226. }
  1227. });
  1228. }
  1229. function closeSearch() {
  1230. // if( role=="2"){
  1231. if( role=="2" || role=="1"){
  1232. getListDistrictInfo('');
  1233. }else if(role=="21" || role=="3"){
  1234. getListInfo('');
  1235. }
  1236. mui('#popover').popover('hide');
  1237. }
  1238. function changePass(){
  1239. window.location="changePass.html?date="+getDateStr();
  1240. }
  1241. function help(){
  1242. window.location="help.html?date="+getDateStr();
  1243. }
  1244. </script>
  1245. </head>
  1246. <body>
  1247. <header class="mui-bar mui-bar-nav" style="height: 3.75rem;">
  1248. <div style="float: left;margin-top: 0.6rem;margin-left:-0.4375rem;">
  1249. <input type="text" id="towninfo" class="mui-input-clear" placeholder="青浦区/华新镇" style="width: 8.75rem;" disabled="disabled">
  1250. </div>
  1251. <div id="total" style="margin-top: 1.3rem;margin-left: 0.3rem;width:4.6875rem;float: left;font-size: 15px">
  1252. 总计0条
  1253. </div>
  1254. <div class="headimg">
  1255. <img onclick="conditionSearch()" src="assets/image/sousuo.png" />
  1256. </div>
  1257. <div class="headimg">
  1258. <img onclick="help()" src="assets/image/help.png"/>
  1259. </div>
  1260. <div class="headimg" >
  1261. <img onclick="changePass()" src="assets/image/update.png"/>
  1262. </div>
  1263. </header>
  1264. <div class="maincontent">
  1265. <div style="padding: 10px 10px;display:none" id="div_totalcon" >
  1266. <div id="segmentedControl" class="mui-segmented-control">
  1267. <a class="mui-control-item mui-active" href="#item1">任务清单</a>
  1268. <a class="mui-control-item" href="#item2">完成情况</a>
  1269. <a class="mui-control-item" href="#item3">巡查员发现</a>
  1270. </div>
  1271. </div>
  1272. <div id="item1" class="mui-control-content mui-active" style="padding-bottom: 3.125rem;">
  1273. <ul class="mui-table-view" id="newDataUl"></ul>
  1274. </div>
  1275. <div id="item2" class="mui-control-content" style="padding-left: 0.3125rem;padding-right: 0.3125rem;padding-bottom: 3.125rem">
  1276. <!-- <select id="select_jd" onchange="jdchange()" ></select> -->
  1277. <ul width="100%" id="tablebody" class="mui-table-view" style="line-height:25px;"></ul>
  1278. <!-- <table width="100%" class="table" id="tablevalue">
  1279. <tr>
  1280. <th width=40%>区域</th>
  1281. <th width=20%>下发数</th>
  1282. <th width=20%>已巡查</th>
  1283. <th width=20%>巡查率</th>
  1284. <th width=20%>巡查员发现</th>
  1285. </tr>
  1286. <tbody id="tablebody"></tbody>
  1287. </table> -->
  1288. </div>
  1289. <div id="item3" class="mui-control-content" style="padding-left: 0.3125rem;padding-right: 0.3125rem;padding-bottom: 3.125rem">
  1290. <!-- <select id="select_jd1" onchange="jdchange1()" ></select> -->
  1291. <ul class="mui-table-view" id="newDataUlFind"></ul>
  1292. <!-- <table width="100%" class="table" id="tablevalue1">
  1293. <tr>
  1294. <th width=40%>区域</th>
  1295. <th width=20%>下发数</th>
  1296. <th width=20%>已排查</th>
  1297. <th width=20%>未排查</th>
  1298. </tr>
  1299. <tbody id="tablebody1"></tbody>
  1300. </table> -->
  1301. </div>
  1302. </div>
  1303. <nav class="mui-bar mui-bar-tab">
  1304. <a href="firstPage.html" id="mainpage" class="mui-tab-item mui-active">
  1305. <span class="mui-icon mui-icon-home"></span>
  1306. <span class="mui-tab-label">主页</span>
  1307. </a>
  1308. <a href="projectInfo.html" id="addpage" class="mui-tab-item">
  1309. <span class="mui-icon mui-icon-chatboxes"></span>
  1310. <span class="mui-tab-label">添加</span>
  1311. </a>
  1312. <a href="myInfo.html" id="exit" class="mui-tab-item">
  1313. <span class="mui-icon mui-icon-gear"></span>
  1314. <span class="mui-tab-label">退出</span>
  1315. </a>
  1316. </nav>
  1317. <div id="popover" class="mui-popover " style="height:100px;">
  1318. <form class="mui-input-group" style="border-radius: 8px;">
  1319. <!-- <div class="mui-input-row">
  1320. <label>地址</label>
  1321. <input type="text" class="mui-input-clear" placeholder="请输入地址" id="address">
  1322. </div>
  1323. <div class="mui-input-row">
  1324. <label>姓名</label>
  1325. <input type="text" class="mui-input-clear" placeholder="请输入姓名" id="name">
  1326. </div>
  1327. <div class="mui-button-row">
  1328. <button type="button" class="mui-btn mui-btn-primary" onclick="closeSearch('')">确认</button>
  1329. </div> -->
  1330. <div class="mui-input-row" id="streetDiv">
  1331. <label>街镇</label>
  1332. <select id="select_street" ></select>
  1333. </div>
  1334. <div class="mui-input-row">
  1335. <label>任务来源</label>
  1336. <select id="select_source" >
  1337. <option value="0">全部</option>
  1338. <option value="1">一户一档</option>
  1339. <option value="2">迁移比对</option>
  1340. <option value="3">既往未巡查</option>
  1341. <option value="4">其他</option>
  1342. <option value="5">区所新增</option>
  1343. </select>
  1344. </div>
  1345. <div class="mui-input-row">
  1346. <label>是否巡查</label>
  1347. <select id="select_patrol" >
  1348. <option value="-1">全部</option>
  1349. <option value="0">已巡查</option>
  1350. <option value="1">未巡查</option>
  1351. </select>
  1352. </div>
  1353. <div class="mui-input-row">
  1354. <label>巡查结论</label>
  1355. <select id="select_conclusion" ></select>
  1356. </div>
  1357. <div class="mui-button-row">
  1358. <button type="button" class="mui-btn mui-btn-primary" onclick="closeSearch('')">确认</button>
  1359. </div>
  1360. </form>
  1361. </div>
  1362. <div id="conclusionpopover" class="mui-popover " style="height:100px;">
  1363. <form class="mui-input-group" style="border-radius: 8px;" id="newDataUl1">
  1364. </form>
  1365. </div>
  1366. <nav class="mui-bar mui-bar-tab" style="margin: 0 auto;margin-bottom: 100%;border: #6641E2;width: 0px;height: 0px;" id="ta">
  1367. </nav>
  1368. </body>
  1369. </html>