01.var json_data = JSON.stringify(data);
02. $.post("ta_document_shift_hr_query.php", {
03. data1: 'table_main',
04. data2: json_data},
05. function(result){
06. $('#tbl_main').DataTable().fnClearTable();
07. console.log(result);
08. var data = JSON.parse(result);
09.
10. var tb_count = 0;
11. for(var obj in data){
12.
13. $('#tbl_main').DataTable().fnAddData([
14. '<input type="checkbox" class="form-control" value="">',
15. tb_count+1,
16. data[obj].em_code,
17. data[obj].em_name,
18. data[obj].pos_name,
19. data[obj].shift_name,
20. '<select class="form-control sel_new_shift" id="new_shift_type'+tb_count+'">'+
21. '<option value="">ทั้งหมด</option>'+
22. <?php while($objResuut = sqlsrv_fetch_array($shiftQuery))
23. { ?>
24. '<option value="<?php echo $objResuut["id"];?>"><?php echo $objResuut["shift_name"];?></option>'+
25. <?php
26. }
27. ?>
28. '</select>',
29. '<input type="text" id="txtdate_start_2'+tb_count+'" class="form-control dp_st" name="" data-mask="99/99/9999" placeholder="วว/ดด/ปปปป">',
30. '<input type="text" id="txtdate_end_2'+tb_count+'" class="form-control dp_en" name="" data-mask="99/99/9999" placeholder="วว/ดด/ปปปป">'
31. ]);
32. var st=$('#txtdate_start').val();
33. var parts = st.split("/");
34. var day = parts[0];
35. var month = parts[1];
36. var year = parts[2];
37. <?php if($_SESSION['lang'] == "TH"){ ?>
38. var date_for_dp = day+'/'+month+'/'+(parseInt(year));
39. <?php }else{ ?>
40. var date_for_dp = day+'/'+month+'/'+(parseInt(year)+543);
41. <?php } ?>
42.
43. var en=$('#txtdate_end').val();
44. var parts2 = en.split("/");
45. var day2 = parts2[0];
46. var month2 = parts2[1];
47. var year2 = parts2[2];
48. <?php if($_SESSION['lang'] == "TH"){ ?>
49. var date_for_dp2 = day2+'/'+month2+'/'+(parseInt(year2));
50. <?php }else{ ?>
51. var date_for_dp2 = day2+'/'+month2+'/'+(parseInt(year2)+543);
52. <?php } ?>
53.
54. $("#txtdate_start_2"+tb_count).datepicker();
55. $("#txtdate_start_2"+tb_count).datepicker('setDate', date_for_dp);
56. $("#txtdate_end_2"+tb_count).datepicker();
57. $("#txtdate_end_2"+tb_count).datepicker('setDate', date_for_dp2);
58.
59. $('#new_shift_type'+tb_count).val($('#shift_type').val());
60.
61. tb_count++;
62. }
63. })
Load balance : Server 03
