userAttendanceTotal-updateAll.jsp 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
  2. <%@include file="/context/mytags.jsp"%>
  3. <t:base type="jquery,easyui,tools,DatePicker,autocomplete"></t:base>
  4. <link rel="stylesheet" type="text/css" href="css/commoncss.css"/>
  5. <!-- <script src="plug-in/layer/layer.js"></script>
  6. -->
  7. <script>
  8. function back2list(){
  9. var url = 'userAttendanceTotalController.do?listAll&queryParams='+encodeURI('${queryParams}');
  10. window.location.href=url;
  11. }
  12. function btn_ok(){
  13. //校验所有的数据, 校验通过后退出行编辑状态, 然后将数据提交 跳转至确认页面
  14. var endsuccess = allrowsEndEdit();
  15. if(endsuccess){
  16. var uprows = $('#' + gridname).datagrid("getChanges");
  17. var jsonarray= getchangeFiled(uprows);
  18. $.ajax({
  19. url : 'userAttendanceDetailController.do?doUpdate',
  20. async : true,
  21. cache : false,
  22. type : 'POST',
  23. data : jsonarray,
  24. success : function(data) {
  25. var d = data; // ------ $.parseJSON(data);
  26. if (d.success) {
  27. var url = 'userAttendanceTotalController.do?goUpdateAll&conform=listAll&id='+'${userAttendanceTotalPage.id}&queryParams='+encodeURI('${queryParams}');
  28. window.location.href=url;
  29. }else{
  30. tip(d.msg);
  31. }
  32. }
  33. });
  34. }
  35. }
  36. function callback(data){
  37. if(data.success){
  38. layer.alert(data.msg, function(index){
  39. window.location.href="userAttendanceTotalController.do?listAll"
  40. layer.close(index);
  41. });
  42. }
  43. else{
  44. layer.alert(data.msg);
  45. }
  46. }
  47. </script>
  48. <script type="text/javascript">
  49. //编写自定义JS代码
  50. </script>
  51. <div id ='userattendancedetaillisttb' >
  52. 员工姓名:${userAttendanceTotalPage.userrealName} 考勤年月: ${userAttendanceTotalPage.yearmonth}
  53. </div>
  54. <div >
  55. <div id='userattendancedatagrid' style=" width:98% ; height:93% ;">
  56. <div class="easyui-layout" fit="true">
  57. <div region="center" style="padding:0px;border:0px">
  58. <t:datagrid name="userattendancedetaillist"
  59. onDblClick="startorendrowedit"
  60. autoLoadData="true" checkbox="false" fitColumns="true"
  61. pagination = 'false'
  62. extendParams="queryParams:{attendanceId:'${userAttendanceTotalPage.id}',userId:'${userAttendanceTotalPage.userId}',yearmonth:'${userAttendanceTotalPage.yearmonth}'},"
  63. actionUrl="userAttendanceDetailController.do?datagrid" idField="id" fit="true" queryMode="group">
  64. <t:dgCol sortable="false" title="主键" field="id" hidden="true" queryMode="single" width="120"></t:dgCol>
  65. <t:dgCol sortable="false" title="json字段" field="jsonObj" hidden="true" queryMode="single" width="120"></t:dgCol>
  66. <t:dgCol sortable="false" title="dto字段" field="dtoinfo" formatterjs="json2string" hidden="true" queryMode="single" width="120"></t:dgCol>
  67. <t:dgCol sortable="false" title="主键attendanceId" field="attendanceId" hidden="true" width="120"></t:dgCol>
  68. <t:dgCol sortable="false" title="日期" field="ymdDate" formatter="yyyy-MM-dd" extendParams="align:'center'," queryMode="single" width="120"></t:dgCol>
  69. <t:dgCol sortable="false" title="状态" field="status" hidden="false" queryMode="single" extendParams="align:'center', editor:'combobox'" dictionary="attendance_status_edit" width="80"></t:dgCol>
  70. <t:dgCol sortable="false" title="出勤时间" field="attendanceDate" formatter="MM-dd hh:mm" extendParams="align:'center',editor:'AttendWdateboxTime'" queryMode="single" width="120"></t:dgCol>
  71. <t:dgCol sortable="false" title="退勤时间" field="retreatDate" formatter="MM-dd hh:mm" extendParams="align:'center',editor:'AttendWdateboxTime'" queryMode="single" width="120"></t:dgCol>
  72. <t:dgCol sortable="false" title="班次" field="dutyId" queryMode="single" extendParams="editor:'combobox'" dictionary="t_bus_arrange_duty,id,duty_name, and delete_flag <> '1' and ( pid is null or pid='${userAttendanceTotalPage.pid}' ) order by create_date" width="120"></t:dgCol>
  73. <t:dgCol sortable="false" title="应出勤时长" field="datumDate" formatterjs="minsToHoursandMinsfmt" style="text-align:right," queryMode="single" width="120"></t:dgCol>
  74. <t:dgCol sortable="false" title="时间差" field="timeDifference" formatterjs="minsToHoursandMinsfmt" style="text-align:right," queryMode="single" width="120"></t:dgCol>
  75. <t:dgCol sortable="false" title="临时借调项目" style="fmstatus" field="borrowspid" dictionary="t_s_depart,id,departname, and org_type != '1' " queryMode="single" width="120"></t:dgCol>
  76. <t:dgCol sortable="false" title="调整类型" field="fineTuningType" extendParams="editor:'combobox'" dictionary="attendance_timeFineTuning" width="120"></t:dgCol>
  77. <t:dgCol sortable="false" title="调整理由" field="adjustReason" extendParams="editor:'text'" queryMode="single" width="120"></t:dgCol>
  78. <%--
  79. <t:dgCol sortable="false" title="常班餐补(顿)" field="jsonregularShift" formatterjs="hdaytypefmt6" queryMode="single" width="120"></t:dgCol>
  80. <t:dgCol sortable="false" title="超时加班计算" field="temp1" formatterjs="hdaytypefmt" queryMode="single" width="120"></t:dgCol>
  81. <t:dgCol sortable="false" title="月度基准时间" field="temp3" formatterjs="hdaytypefmt3" queryMode="single" width="120"></t:dgCol>
  82. <t:dgCol sortable="false" title="国定休日" field="temp4" formatterjs="hdaytypefmt4" queryMode="single" width="120"></t:dgCol>
  83. <t:dgCol sortable="false" title="工作日" field="temp5" formatterjs="hdaytypefmt5" queryMode="single" width="120"></t:dgCol>
  84. --%>
  85. <%-- <t:dgCol sortable="false" title="temp2" field="temp2" formatterjs="hdaytypefmt1" queryMode="single" width="520"></t:dgCol>
  86. --%> <!-- <!-- extendParams="editor:'micchange'" -->
  87. <!-- 临时显示字段 -->
  88. <%-- <t:dgCol title="迟到" field="belate" formatterjs="belatefmt" queryMode="single" width="120"></t:dgCol>
  89. <t:dgCol sortable="false" title="休假类型" field="hdaytype" formatterjs="hdaytypefmt" queryMode="single" width="120"></t:dgCol>
  90. <t:dgCol title="借调项目" field="borrowspid" queryMode="single" width="120"></t:dgCol>
  91. <t:dgCol title="早退" field="leaveEarly" formatterjs="leaveEarlyfmt" queryMode="single" width="120"></t:dgCol>
  92. <t:dgCol title="旷工" field="absenteeism" formatterjs="absenteeismfmt" queryMode="single" width="120"></t:dgCol>
  93. <t:dgCol title="当天加班状态" field="ihadDuty" formatterjs="ihadDutyfmt" queryMode="single" width="120"></t:dgCol>
  94. <t:dgCol title="实际时间for月度" field="datumAttendanceDate" formatterjs="datumAttendanceDatefmt" queryMode="single" width="120"></t:dgCol>
  95. <t:dgCol title="事假分钟数" field="thingLeaveMins" formatterjs="thingLeaveMinsfmt" queryMode="single" width="120"></t:dgCol>
  96. --%> <!-- 临时显示字段 -->
  97. </t:datagrid>
  98. </div></div>
  99. </div>
  100. </div>
  101. <div style="padding-top: 10px;padding-left: 80%;">
  102. <td height="50px" align="center" colspan="4" >
  103. <div style="display:none"><input type="submit" id ="btnsub" value=""/></div>
  104. <a style="margin-left:80px" href="#" class="easyui-linkbutton l-btn" iconcls="icon-confirm" onclick="btn_ok()">确定</a>
  105. <a href="#" class="easyui-linkbutton l-btn" plain="true" iconcls="icon-return" onclick="back2list()">返回</a>
  106. </td>
  107. </div>
  108. <script type="text/javascript">
  109. var gridname = 'userattendancedetaillist';
  110. $(function(){
  111. // alert(""+ '${queryParams}'+"");
  112. // $('#userattendancedetaillist').datagrid( {rownumbers : false});
  113. // //--author:zhaohualong-----start----date:20170906--------for:------初始化editor
  114. // $.extend($.fn.datagrid.defaults.editors, {
  115. // WdateboxTime: {
  116. // init: function (container, options) {
  117. // if(!options){
  118. // options = {};
  119. // }
  120. // var minDate= "1900-01-01 00:00:00";
  121. // var maxDate="2099-12-31 23:59:59";
  122. // if(undefined!=options.minDate&&''!=options.minDate){
  123. // minDate= options.minDate;
  124. // }
  125. // if(undefined!=options.maxDate&&''!=options.maxDate){
  126. // maxDate = options.maxDate;
  127. // }
  128. // var input = $(' <input type="text" class="Wdate" onClick=\'WdatePicker({readOnly:true,minDate: "'+minDate+'",maxDate: "'+maxDate+'",dateFmt: "yyyy-MM-dd HH:mm"})\' />').appendTo(container);
  129. // return input;
  130. // },
  131. // destroy: function (target) {
  132. // },
  133. // getValue: function (target) {
  134. // return $(target).val();
  135. // },
  136. // setValue: function (target, value) {
  137. // value = new Date().format('yyyy-MM-dd hh:mm',value);
  138. // return $(target).val(value);//获得旧值
  139. // },
  140. // resize : function(target, width) {
  141. // var input = $(target);
  142. // if ($.boxModel == true) {
  143. // input.width(width - (input.outerWidth() - input.width()));
  144. // } else {
  145. // input.width(width);
  146. // }
  147. // }
  148. // },
  149. // });
  150. //--author:zhaohualong-----start----date:20170906--------for:------初始化editor
  151. });
  152. function startorendrowedit(rowIndex,rowData){
  153. var gname = 'userattendancedetaillist';
  154. //判断当前行的编辑状态
  155. var rowEdting = IsEditing(rowIndex);
  156. if(rowEdting){
  157. //结束行编辑
  158. endrowEdit(rowData);
  159. }else{
  160. //开始行编辑
  161. var options = {};
  162. var effectiveStime = rowData.dtoinfo.effectiveStime;
  163. var ymdDate = rowData.dtoinfo.ymdDate;
  164. if(undefined!=effectiveStime){
  165. options.minDate = (new Date(effectiveStime)).Format('yyyy-MM-dd hh:mm:ss');
  166. }
  167. var effectiveEtime = rowData.dtoinfo.effectiveEtime;
  168. if(undefined!=effectiveEtime){
  169. options.maxDate= (new Date(effectiveEtime)).Format('yyyy-MM-dd hh:mm:ss');
  170. }
  171. if(undefined!=ymdDate&&(undefined==effectiveStime||null==effectiveStime)){
  172. var ymt = new Date(ymdDate);
  173. var ymttomorrow = new Date((ymt/1000+86400*1)*1000);//明天
  174. options.minDate = ymt.Format('yyyy-MM-dd 00:00:00');
  175. options.maxDate = ymttomorrow.Format('yyyy-MM-dd 23:59:00');
  176. }
  177. var datas = getusercurrentStatus(rowData);
  178. $('#'+gname).datagrid('addEditor', {
  179. field : 'status',
  180. editor : {
  181. type:'combobox',
  182. options:{
  183. valueField:'typecode',
  184. textField:'typename',
  185. data:datas,
  186. editable:false,
  187. panelHeight:'auto',
  188. required:true}
  189. }
  190. });
  191. $('#'+gname).datagrid('addEditor', {
  192. field : 'attendanceDate',
  193. editor : {
  194. type : 'AttendWdateboxTime',
  195. options : options
  196. }
  197. });
  198. $('#'+gname).datagrid('addEditor', {
  199. field : 'retreatDate',
  200. editor : {
  201. type : 'AttendWdateboxTime',
  202. options : options
  203. }
  204. });
  205. $('#'+gname).datagrid('beginEdit', rowIndex);
  206. }
  207. }
  208. // 所有数据退出行编辑状态
  209. function allrowsEndEdit(){
  210. var endsuccess =true;
  211. var rows=$('#'+gridname).datagrid("getRows");
  212. for(var i=0;i<rows.length;i++){
  213. if(endsuccess){
  214. endsuccess =endrowEdit(rows[i]);
  215. }
  216. }
  217. return endsuccess;
  218. }
  219. /*
  220. 获取当前人在当天的请假状态信息
  221. */
  222. function getusercurrentStatus(rowData){
  223. var zc = {'typecode':'10','typename':'正常'};
  224. var jqlist = {
  225. "0": {'typecode':'0','typename':'事假'},
  226. "1": {'typecode':'1','typename':'病假'},
  227. "2": {'typecode':'2','typename':'年假'},
  228. "3": {'typecode':'3','typename':'丧假'},
  229. "4": {'typecode':'4','typename':'婚假'},
  230. "5": {'typecode':'5','typename':'产假'},
  231. "6": {'typecode':'6','typename':'陪产假'},
  232. "7": {'typecode':'7','typename':'调休'}
  233. };
  234. var result = [];
  235. result.push(zc);
  236. var userHolidayEntities = rowData.dtoinfo.userHolidayEntities;
  237. if([]!=userHolidayEntities){
  238. $.each(userHolidayEntities, function(index, userHolidayEntity) {
  239. try{
  240. result.push(jqlist[userHolidayEntity.holidayType]);
  241. }catch(e){}
  242. });
  243. }
  244. return result ;
  245. }
  246. //结束行编辑
  247. //对用户输入的数据 与原始数据进行比对, 当没改变任何字段时, 将行编辑取消
  248. function endrowEdit(row){
  249. var rowIndex= $('#'+gridname).datagrid('getRowIndex', row);
  250. var attendanceDate = getdatabyfildname(row,'attendanceDate');
  251. var retreatDate = getdatabyfildname(row,'retreatDate');
  252. var adjustReason = getdatabyfildname(row,'adjustReason');
  253. var dutyId = getdatabyfildname(row,'dutyId');
  254. var status = getdatabyfildname(row,'status');
  255. var fineTuningType = getdatabyfildname(row,'fineTuningType');
  256. var ysattendanceDate = new Date().format('yyyy-MM-dd hh:mm',row.attendanceDate);
  257. var ysretreatDate = new Date().format('yyyy-MM-dd hh:mm',row.retreatDate);
  258. var ysstatus = row.status;
  259. var ysdutyid = row.dutyId;
  260. var ysfineTuningType = row.fineTuningType;
  261. var ysadjustReason = row.adjustReason;
  262. if(null==ysadjustReason){
  263. ysadjustReason = '';
  264. }
  265. if((ysattendanceDate==attendanceDate)
  266. &&(ysretreatDate==retreatDate)
  267. &&(ysstatus==status)
  268. &&(ysfineTuningType==fineTuningType)
  269. &&(ysadjustReason==adjustReason)
  270. &&(ysdutyid==dutyId)
  271. ){
  272. $('#'+gridname).datagrid('cancelEdit', rowIndex);
  273. return true;
  274. }
  275. if((attendanceDate == null || ''==attendanceDate)&&(null==retreatDate||''==retreatDate)){
  276. alerLayerTip('出勤时间和退勤时间不能同时为空');
  277. return false;
  278. }
  279. if((null!=attendanceDate&&''!=attendanceDate)&&(null!=retreatDate&&''!=retreatDate)){
  280. if(attendanceDate > retreatDate){
  281. alerLayerTip('退勤时间不得早于出勤时间');
  282. return false;
  283. }
  284. }
  285. if($('#'+gridname).datagrid('validateRow', rowIndex))
  286. {
  287. $('#'+gridname).datagrid('endEdit', rowIndex);
  288. return true;
  289. }else{
  290. alerLayerTip('请选择调整类型');
  291. return false;
  292. }
  293. }
  294. function belatefmt(value,rec,index){
  295. var data=JSON.parse(rec.jsonObj);
  296. return data.belate;
  297. }
  298. function hdaytypefmt1(value,rec,index){
  299. var dtoinfo=rec.dtoinfo;
  300. return JSON.stringify(dtoinfo);
  301. }
  302. function hdaytypefmt3(value,rec,index){
  303. var dtoinfo=rec.dtoinfo;
  304. value = rec.jsonObj;
  305. value =JSON.parse(value);
  306. var gdjr = '';
  307. if(value.worktype == '2'){
  308. gdjr = "国定休日:"+value.actDatumDate;
  309. }else{
  310. gdjr = "国定休日:0";
  311. }
  312. var gzr = '';
  313. if(value.worktype == '0'){
  314. gzr = " 工作日 :1*8*60" ;
  315. }else{
  316. gzr = " 工作日 :0" ;
  317. }
  318. value =value.actDatumDate ;
  319. return value;
  320. }
  321. function hdaytypefmt6(value,rec,index){
  322. var dtoinfo=rec.dtoinfo;
  323. value = rec.jsonObj;
  324. value =JSON.parse(value);
  325. value =value.regularShift;
  326. return value;
  327. }
  328. function hdaytypefmt5(value,rec,index){
  329. var dtoinfo=rec.dtoinfo;
  330. value = rec.jsonObj;
  331. value =JSON.parse(value);
  332. var gdjr = '';
  333. if(value.worktype == '2'){
  334. gdjr = " "+value.actDatumDate;
  335. }else{
  336. gdjr = " 0";
  337. }
  338. var gzr = '';
  339. if(value.worktype == '0'){
  340. gzr = " 480" ;
  341. }else{
  342. gzr = " 0" ;
  343. }
  344. value =gzr;
  345. return value;
  346. }
  347. function hdaytypefmt4(value,rec,index){
  348. var dtoinfo=rec.dtoinfo;
  349. value = rec.jsonObj;
  350. value =JSON.parse(value);
  351. var gdjr = '';
  352. if(value.worktype == '2'){
  353. gdjr = " "+value.actDatumDate;
  354. }else{
  355. gdjr = " 0";
  356. }
  357. var gzr = '';
  358. if(value.worktype == '0'){
  359. gzr = " 工作日 :1*8*60" ;
  360. }else{
  361. gzr = " 工作日 :0" ;
  362. }
  363. value =gdjr;
  364. return value;
  365. }
  366. function hdaytypefmt(value,rec,index){
  367. var dtoinfo=rec.dtoinfo;
  368. value = rec.jsonObj;
  369. value =JSON.parse(value);
  370. var gdjr = '';
  371. if(value.worktype == '2'){
  372. gdjr = "国定休日:"+value.actDatumDate;
  373. }else{
  374. gdjr = "国定休日:0";
  375. }
  376. var gzr = '';
  377. if(value.worktype == '0'){
  378. gzr = " 工作日 :1*8*60" ;
  379. }else{
  380. gzr = " 工作日 :0" ;
  381. }
  382. value = "月度应出勤时长:"+value.actDatumDate+gdjr+gzr;
  383. // value = '<a title= '+value+'>'+ value.substring(0,10)+'...';
  384. // value = " 未打卡 :"+value.noPunchCard ;
  385. return value;
  386. }
  387. function json2string(value,rec,index){
  388. var data=JSON.stringify(value);
  389. return data;
  390. }
  391. function leaveEarlyfmt(value,rec,index){
  392. var data=JSON.parse(rec.jsonObj);
  393. return data.leaveEarly;
  394. }
  395. function absenteeismfmt(value,rec,index){
  396. var data=JSON.parse(rec.jsonObj);
  397. return data.absenteeism;
  398. }
  399. function ihadDutyfmt(value,rec,index){
  400. var data=JSON.parse(rec.jsonObj);
  401. return data.ihadDuty;
  402. }
  403. function datumAttendanceDatefmt(value,rec,index){
  404. var data=JSON.parse(rec.jsonObj);
  405. return data.datumAttendanceDate;
  406. }
  407. function thingLeaveMinsfmt(value,rec,index){
  408. var data=JSON.parse(rec.jsonObj);
  409. return data.thingLeaveMins;
  410. }
  411. //判断当前行是否处于行编辑模式
  412. function IsEditing(row) {
  413. var nameEditor = $('#' + gridname).datagrid('getEditor', {
  414. index : row,
  415. field : "status"
  416. });
  417. if (undefined == nameEditor || null == nameEditor) {
  418. return false;
  419. } else {
  420. return true;
  421. }
  422. }
  423. //根据字段名称获取字段内容
  424. function getdatabyfildname(row, field) {
  425. var rowIndex= $('#'+gridname).datagrid('getRowIndex', row);
  426. var nameEditor = $('#' + gridname).datagrid('getEditor', {
  427. index : rowIndex,
  428. field : field
  429. });
  430. if (undefined == nameEditor || null == nameEditor) {
  431. return row[field];
  432. }
  433. var name = nameEditor.target.val();
  434. if('status'==field||'fineTuningType'==field){
  435. try{
  436. name =$(nameEditor.target).combobox('getValue');
  437. }catch(e){}
  438. }
  439. return name;
  440. }
  441. function getchangeFiled(rows){
  442. var jsonarray = [];
  443. $.each(rows, function(index, row) {
  444. var json = {
  445. 'id':row['id'],
  446. 'status':row['status'],
  447. 'dutyId':row['dutyId'],
  448. 'attendanceDate':row['attendanceDate'],
  449. 'retreatDate':row['retreatDate'],
  450. 'fineTuningType':row['fineTuningType'],
  451. 'adjustReason':row['adjustReason'],
  452. };
  453. jsonarray.push(json);
  454. });
  455. var result = {
  456. attendanceId:'${userAttendanceTotalPage.id}',
  457. userId:'${userAttendanceTotalPage.userId}',
  458. yearmonth:'${userAttendanceTotalPage.yearmonth}',
  459. userAttendanceDetails:jsonarray};
  460. return result;
  461. }
  462. </script>