01.<?php
02.
03.
04.
05.$columns = array('HEADER_ID', 'SCAN_NO', 'DATESCAN','EMP_ID','EMP_TH_LNAME', 'SUB_SECT_CODE','GRP_CODE','DETAIL','DELECT');
06.
07.$query = 'SELECT * from SFCSYS.SFC_LS_WSD_HEADER INNER join HRSYS.PERSONNEL_MASTER_TEMP
08.ON SFCSYS.SFC_LS_WSD_HEADER.EMP_ID = HRSYS.PERSONNEL_MASTER_TEMP.EMP_ID where
09. ';
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.if(isset($_POST["order"]))
25.{
26. $query2 .= 'ORDER BY '.$columns[$_POST['order']['0']['column']].' '.$_POST['order']['0']['dir'].'
27. ';
28.}
29.else
30.{
31. $query2 .= 'ORDER BY SCAN_DATE DESC ';
32.}
33.
34.$query1 = '';
35.
36.if($_POST["length"] != -1)
37.{
38.
39. $query1 = 'ROWNUM BETWEEN ' . $_POST['start'].'AND ' . $_POST['length'];
40.}
41.
42.
43.$objParse = oci_parse($objConnect, $query.$query1.$query2);
44.oci_execute ($objParse,OCI_DEFAULT);
45.
46.$number_filter_row = oci_fetch_all($objParse, $show2, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
47.$data = array();
48.for ($iw = 0; $iw < $number_filter_row ; $iw++) {
49. $sub_array = array();
50. $sub_array[] = '<center><font size="3">'.$show2 [$iw]['HEADER_ID'];
51.$sub_array[] = '<center><font size="3">'.$show2 [$iw]['SCAN_NO'];
52.$sub_array[] = '<center><font size="3">'.$show2 [$iw]['SCAN_DATE'];
53.$sub_array[] = '<center><font size="3">'.$show2 [$iw]['EMP_ID'];
54.$NameEMPLOYEE=$show2 [$iw]['EMP_TH_NAME']." ".$show2 [$iw]['EMP_TH_LNAME'];
55.$sub_array[] = '<center><font size="3">'.$NameEMPLOYEE;
56.$sub_array[] = '<center><font size="3">'.$show2 [$iw]['SUB_SECT_CODE'];
57.$sub_array[] = '<center><font size="3">'.$show2 [$iw]['GRP_CODE'];
58.$sub_array[] = '<center><font size="3"><a href="detailscan.php?idscan='.$show2 [$iw]['HEADER_ID'].'"><center><button type="button" class="btn btn-warning bt-xs t">
59.รายละเอียด</button> </a>';
60.$sub_array[] = '<center><font size="3"><button type="button" name="delete" class="btn btn-warning bt-xs delete" id="'.$show2 [$iw]['HEADER_ID']
61..'"nameE="'.$show2 [$iw]['EMP_TH_NAME']." ".$show2 [$iw]['EMP_TH_LNAME'].'">
62.ลบ</button></a>';
63. $data[] = $sub_array;
64.}
65.
66.function get_all_data($objConnect)
67.{
68. $query = "SELECT * from SFCSYS.SFC_LS_WSD_HEADER INNER join HRSYS.PERSONNEL_MASTER_TEMP
69.ON SFCSYS.SFC_LS_WSD_HEADER.EMP_ID = HRSYS.PERSONNEL_MASTER_TEMP.EMP_ID";
70. $objParse = oci_parse($objConnect, $query);
71. oci_execute ($objParse,OCI_DEFAULT);
72. return oci_fetch_all($objParse, $show2, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
73.}
74.
75.$output = array(
76. "draw" => intval($_POST["draw"]),
77. "recordsTotal" => get_all_data($objConnect),
78. "recordsFiltered" => $number_filter_row,
79. "data" => $data
80.);
81.
82.echo json_encode($output);
83.
84.
85.?>
