xqmanage.js 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197
  1. define(function (require) {
  2. return function (context) {
  3. var $grid1, $form;
  4. // 导出
  5. function exportExcel() {
  6. var row = $grid1.rowData();
  7. if (!row) {
  8. $.yvan.msg('请先选择一行数据');
  9. return;
  10. }
  11. var queryForm = $form.formGet();
  12. $.yvan.download({
  13. method: 'post',
  14. url: api('/sweepCode/export?queryProperties=' + queryForm.queryProperties + '&dateSta=' + queryForm.dateSta + '&dateEnd=' + queryForm.dateEnd),
  15. fileName: '进出管理-' + $.yvan.getMoment().format('YYYY-MM-DD HH:mm:ss') + '.xlsx'
  16. });
  17. }
  18. // 输入搜索文本后点击回车按钮查询列表
  19. function enterQueryGrid1(e) {
  20. if (e.keyCode === 13) {
  21. var tmp = $(this).val();
  22. $form.formSet({queryProperties: tmp});
  23. queryGrid1();
  24. }
  25. }
  26. // 检索条件查询
  27. function queryGrid1() {
  28. var queryUrl = '/sweepCode/selectCode';// 自行替换此参数
  29. var queryForm = $form.formGet();
  30. queryForm.roleCode = App.currentRoleCode;
  31. $grid1.reload({
  32. mtype: 'POST',
  33. url: api(queryUrl),
  34. queryParams: queryForm
  35. }, true);
  36. }
  37. // 搜索按钮
  38. var queryToolbarTitle = '进出管理';// 自行替换此参数
  39. var queryToolbar = {
  40. xtype: 'toolbar', title: queryToolbarTitle, items: [
  41. {
  42. text: '查询', iconCls: 'fa fa-search', onClick: function () {
  43. queryGrid1();
  44. }
  45. }, {
  46. text: '重置', iconCls: 'fa fa-refresh', onClick: function () {
  47. $form.formClear();
  48. queryGrid1();
  49. }
  50. }, {
  51. text: '关闭', iconCls: 'fa fa-times-circle', onClick: function () {
  52. App.closeMe(this);
  53. }
  54. }
  55. ]
  56. };
  57. // 搜索条件
  58. var queryFormPrompt = '名称';// 自行替换此参数
  59. var queryForm = {
  60. onRender: function () {
  61. $form = $(this);
  62. },
  63. xtype: 'form',
  64. items: [[
  65. {
  66. xtype: 'textbox',
  67. label: '小区名称',
  68. name: 'queryProperties',
  69. prompt: queryFormPrompt,
  70. labelWidth: 'auto',
  71. events: {keydown: enterQueryGrid1}, width: 350
  72. },
  73. {
  74. xtype: 'datebox',
  75. name: 'dateSta',
  76. label: '进出时间',
  77. labelWidth: 'auto',
  78. width: 230,
  79. onChange: function (data) {
  80. /* var expDateStart = $form.formGet().nextRepairDate;
  81. var expDateEnd = $form.formGet().expDateEnd;
  82. var expDateStart = new Date(expDateStart.replace("-", "/"));
  83. var expDateEnd = new Date(expDateEnd.replace("-", "/"));
  84. if (expDateStart > expDateEnd) {
  85. $.yvan.msg('起止日期必须大于起始日期');
  86. return;
  87. }*/
  88. }
  89. },
  90. {
  91. xtype: 'datebox', label: '--', name: 'dateEnd', labelWidth: 'auto', width: 180,
  92. onChange: function (data) {
  93. /* var expDateStart = $form.formGet().nextRepairDate;
  94. var expDateEnd = $form.formGet().expDateEnd;
  95. var expDateStart = new Date(expDateStart.replace("-", "/"));
  96. var expDateEnd = new Date(expDateEnd.replace("-", "/"));
  97. if (expDateStart > expDateEnd) {
  98. $.yvan.msg('起止日期必须大于起始日期');
  99. return;
  100. }*/
  101. }
  102. }
  103. ]]
  104. };
  105. var gridToolbarTitle = '出入列表';// 自行替换此参数
  106. var gridToolbar = {
  107. xtype: 'toolbar',
  108. title: gridToolbarTitle,
  109. items: [
  110. {
  111. text: '导出', iconCls: 'fa fa-cloud-upload', onClick: function () {
  112. exportExcel();
  113. }
  114. },
  115. ]
  116. };
  117. return {
  118. north: {
  119. height: 88,
  120. /* split: true,
  121. border: false,*///底框是否可变动
  122. items: [
  123. queryToolbar,
  124. queryForm
  125. ]
  126. },
  127. center: {
  128. height: '60%',
  129. split: true,
  130. items:
  131. {
  132. onRender: function () {
  133. $grid1 = $(this);
  134. queryGrid1()
  135. },
  136. xtype: 'grid',
  137. toolbar:
  138. gridToolbar,
  139. idField: 'joId',
  140. autoSizeColumns: true,//序号多 正确显示
  141. columns:
  142. [
  143. [
  144. {field: 'uptownId', title: '小区id', maxWidth: 200, align: 'left', hidden: true},
  145. {field: 'uptownName', title: '小区名称', maxWidth: 200, align: 'left',},
  146. {field: 'ridgepole', title: '楼栋', maxWidth: 200, align: 'left',},
  147. {field: 'unit', title: '单元', maxWidth: 200,},
  148. {
  149. field: 'doorplate',
  150. title: '房间号', maxWidth: 200,
  151. },
  152. {
  153. field: 'linkman',
  154. title: '用户名',
  155. },
  156. {
  157. field: 'doorName',
  158. title: '小区大门',
  159. align: 'left',
  160. },
  161. {
  162. field: 'date',
  163. title: '进出时间',
  164. align: 'left',
  165. },
  166. {
  167. field: 'inType',
  168. title: '记录状态',
  169. align: 'center',
  170. formatter:function (value) {
  171. if(value==1){
  172. return "进入"
  173. }else if(value ==2){
  174. return "外出"
  175. }
  176. }
  177. }
  178. ]
  179. ]
  180. }
  181. }
  182. };
  183. };
  184. }
  185. );