001.<?php
002.
003.@ini_set('display_errors', '0');
004.include "../../include/mySqlFunc.php";
005.date_default_timezone_set("Asia/Bangkok");
006.query("USE hr_extra");
007.$date_start = '2022-12-01';
008.$date_end = '2022-12-03';
009.$rate_per_day = 325;
010.
011.
012.
013.
014.if ($_GET["Action"] == "Add") {
015.
016. $multiple_advance = $_POST['multiple_advance'];
017. $multiple_ar = $_POST['multiple_ar'];
018.
019.
020.
021.
022.
023.}
024.
025.for ($intern = 0; $intern < sizeof($multiple_advance); $intern++) {
026. if (!empty($multiple_advance[$intern])) {
027. if (empty($where_data)) {
028. $where_data = $multiple_advance[$intern];
029. } else {
030. $where_data .= "," . $multiple_advance[$intern];
031. }
032. }
033.}
034.
035.for ($intern = 0; $intern < sizeof($multiple_ar); $intern++) {
036. if (!empty($multiple_ar[$intern])) {
037. if (empty($where_data2)) {
038. $where_data2 = $multiple_ar[$intern];
039. } else {
040. $where_data2 .= "," . $multiple_ar[$intern];
041. }
042. }
043.}
044.
045.
046.
047.$thai_day_arr = array("อาทิตย์", "จันทร์", "อังคาร", "พุธ", "พฤหัสบดี", "ศุกร์", "เสาร์");
048.
049.$cut_start_date = explode("-", $date_start);
050.$DateStart = $cut_start_date[2];
051.$MonthStart = $cut_start_date[1];
052.$YearStart = $cut_start_date[0];
053.
054.$cut_end_date = explode("-", $date_end);
055.$DateEnd = $cut_end_date[2];
056.$MonthEnd = $cut_end_date[1];
057.$YearEnd = $cut_end_date[0];
058.
059.$End = mktime(0, 0, 0, $MonthEnd, $DateEnd, $YearEnd);
060.$Start = mktime(0, 0, 0, $MonthStart, $DateStart, $YearStart);
061.
062.$DateNum = ceil(($End - $Start) / 86400) + 1;
063.$colspan_table = $DateNum + 5;
064.
065.
066.$color = "#FFB6C1";
067.?>
068.
069.<!DOCTYPE html>
070.<html lang="th">
071.<head>
072. <meta charset="UTF-8">
073. <!-- Title Page-->
074. <title>รายงานสรุปค่าแรง คนสวน</title>
075. <!-- Fontfaces CSS-->
076. <link href="../css/font-face.css" rel="stylesheet" media="all">
077. <!-- Bootstrap CSS-->
078. <link rel="stylesheet" type = "text/css" href = "../bootstrap/bootstrap.min.css">
079. <style type="text/css">
080.
081. @font-face {
082. font-family: 'mn_forsor_ttbold';
083. src: url('../fonts/mn_forsor_tt_bd_v3.2.1-webfont.woff2') format('woff2'),
084. url('../fonts/mn_forsor_tt_bd_v3.2.1-webfont.woff') format('woff');
085. font-weight: normal;
086. font-style: normal;
087. }
088.
089. @font-face {
090. font-family: 'mn_forsor_ttextrabd';
091. src: url('../fonts/mn_forsor_tt_extrabd_v3.2.1-webfont.woff2') format('woff2'),
092. url('../fonts/mn_forsor_tt_extrabd_v3.2.1-webfont.woff') format('woff');
093. font-weight: normal;
094. font-style: normal;
095. }
096.
097. table {
098. font-family: 'mn_forsor_ttbold';
099. font-size: 18px;
100. }
101.
102. .caption table {
103. font-size: 24px;
104. color: black;
105. }
106.
107. .text-center
108. {
109. text-align: left;
110. padding-left: 26%;
111. }
112.
113.@media print
114.{
115.
116. .bodytable{
117. height: auto;
118. }
119.
120.
121. .noprint{
122. visibility: hidden;
123. display: none;
124. }
125.
126. #non-printable
127. {
128. display: none;
129. }
130.
131. #printable { display: block; }
132.}
133.
134..form-control, output {
135. font-size: 20px;
136. line-height: 1.42857143;
137. color: #555;
138. display: block;
139.}
140.
141. </style>
142.</head>
143.<body>
144.<form action="<?=$_SERVER["PHP_SELF"];?>?Action=Add" method="POST" name="report_garden3">
145.<?php
146.print("<input type='hidden' name='date_in' value=\"" . $_POST['date_in'] . "\">");
147.print("<input type='hidden' name='date_end' value=\"" . $_POST['date_end'] . "\">");
148.
149.print("<center>");
150.print("<div class=\"caption\">");
151.print("<table border=\"0\" style=\"text-align:center;\">");
152.print("<tr>");
153.print("<td>");
154.print("บัญชีค่าแรงและวันทำงาน");
155.print("</td>");
156.print("</tr>");
157.print("<tr>");
158.print("<td>");
159.print("ผู้รับเหมาคนสวน");
160.print("</td>");
161.print("</tr>");
162.print("<tr>");
163.print("<td>");
164.print("ประจำวันที่ " . printlongSlateThaiDate($date_start) . " ถึงวันที่ " . printlongSlateThaiDate($date_end));
165.print("</td>");
166.print("</tr>");
167.print("</table>");
168.print("</div>");
169.print("<table border='1' style=\"text-align:center; width:95%;\" >");
170.
171.print("<tr>");
172.
173.print("<td rowspan='3' style=\"width:3%;\">");
174.print("ลำดับที่");
175.print("</td>");
176.print("<td rowspan='3' style=\"width:3%;\">");
177.print("เลขบัตร");
178.print("</td>");
179.
180.print("<td rowspan='3' style=\"width:10%;\">");
181.print("ชื่อ - สกุล");
182.print("</td>");
183.
184.print("<td colspan=\"$DateNum\" style=\"width:50%;\">");
185.print("บันทึกเวลาทำงาน");
186.print("</td>");
187.
188.print("<td rowspan='3' style=\"width:3%;\">");
189.print("จำนวนวันทำงาน");
190.print("</td>");
191.
192.print("<td rowspan='3' style=\"width:5%;\">");
193.print("ค่าจ้าง");
194.print("</td>");
195.
196.print("<td rowspan='3' style=\"width:5%;\">");
197.print("ค่าจ้าง <br>(340)");
198.print("</td>");
199.
200.print("<td colspan='2'>");
201.print("ค่าดำเนินการ");
202.print("</td>");
203.print("<td colspan='4'>");
204.print("วันทำงาน/ค่าล่วงเวลา");
205.print("</td>");
206.
207.print("<td rowspan='3' style=\"width:3%;\">");
208.print("รวมรับ<br>ค่าล่วงเวลา");
209.print("</td>");
210.
211.print("<td rowspan='3' style=\"width:3%;\">");
212.print("ค่าล่วง<br>เวลา 3%");
213.print("</td>");
214.
215.print("<td rowspan='3' style=\"width:3%;\">");
216.print("รวมรับ");
217.print("</td>");
218.print("</tr>");
219.
220.
221.print("<tr>");
222.
223.for ($i = 0; $i < $DateNum; $i++) {
224. $cutdate_show = add_date($date_start, $i, 0, 0);
225. $cutNew_date = explode(" ", $cutdate_show);
226. $c = printThaiNameDate(strtotime($cutNew_date[0]));
227. if ($c == "อา") {
228. print("<td bgcolor=\"$color\" style=\"width:10mm; text-align:center; height:8mm;\">");
229. } else {
230. print("<td bgcolor=\"white\" style=\"width:10mm; text-align:center; height:8mm;\">");
231. }
232. print($c);
233. print("</td>");
234.}
235.print("<td rowspan='2'>");
236.print("ฐานค่าจ้าง<br>(325)");
237.print("</td>");
238.print("<td rowspan='2'>");
239.print("เงินได้25%");
240.print("<td rowspan='2'>");
241.print("วันปกติ<br>(ชม.)");
242.print("</td>");
243.print("<td rowspan='2'>");
244.print("วันหยุด<br>(ชม.)");
245.print("</td>");
246.print("<td rowspan='2'>");
247.print("วันปกติ");
248.print("</td>");
249.print("<td rowspan='2'>");
250.print("วันหยุด");
251.print("</td>");
252.print("</td>");
253.
254.print("</tr>");
255.
256.
257.print("<tr>");
258.$date_show = 0;
259.for ($i = 0; $i < $DateNum; $i++) {
260. $cutdate_show = add_date($date_start, $i, 0, 0);
261. $cutNew_date = explode(" ", $cutdate_show);
262. $c = printThaiNameDate(strtotime($cutNew_date[0]));
263.
264. if ($c == "อา") {
265. print("<td bgcolor=\"$color\" style=\"width:10mm; text-align:center; height:8mm;\">");
266. } else {
267. print("<td bgcolor=\"white\" style=\"width:10mm; text-align:center; height:8mm;\">");
268. }
269. $date_show = ((int) date('d', strtotime($cutNew_date[0])));
270. print("$date_show");
271. print("</td>");
272.}
273.print("</tr>");
274.
275.
276.
277.$get_data = getlist("SELECT * FROM emp_data AS ed WHERE emp_position ='คนสวน'");
278.$order = 0;
279.$result_salary_intern2 = 0;
280.for ($i = 0; $i < sizeof($get_data); $i++) {
281. print("<tr>");
282.
283. print("<td>");
284. print($order = $i + 1);
285.
286. print("</td>");
287.
288. print("<td style=\"text-align:left; padding-left:10px;\">");
289. print($get_data[$i]['emp_id']);
290. print("</td>");
291.
292.
293. print("<td style=\"text-align:left; padding-left:10px;\">");
294. print($get_data[$i]['emp_prefix'] . $get_data[$i]['emp_fname'] . " " . $get_data[$i]['emp_lname']);
295. print("</td>");
296.
297. $show_total_day = 0;
298. $show_total_day_holiday = 0;
299. $show_total_hours = 0;
300.
301. for ($j = 0; $j < $DateNum; $j++) {
302. $cutdate_show = add_date($date_start, $j, 0, 0);
303. $cutNew_date = explode(" ", $cutdate_show);
304. $c = printThaiNameDate(strtotime($cutNew_date[0]));
305.
306.
307.
308. $getlist_cout = getlist("SELECT * FROM emp_process
309. WHERE process_date = '" . $cutNew_date[0] . "' AND emp_id='" . $get_data[$i]['emp_id'] . "' ");
310.
311. if ($c == "อา") {
312. print("<td bgcolor=\"$color\">");
313. } else {
314. print("<td bgcolor=\"white\">");
315. }
316.
317.
318. if (!empty($getlist_cout)) {
319.
320. $sum_ot_hr = 0;
321. $get_time_max_min = getlist("SELECT MAX(process_time) AS time_max , MIN(process_time) AS time_min , process_status AS status
322. FROM emp_process WHERE emp_id='" . $get_data[$i]['emp_id'] . "'
323. AND process_date='" . $cutNew_date[0] . "'");
324.
325.
326.
327. $get_timediff = getlist("SELECT TIMEDIFF('" . $get_time_max_min[0]['time_max'] . "','17:00:00') AS time_less");
328.
329.
330.
331. if ($get_timediff[0]['time_less'] == '00:00:00' && $get_timediff[0]['time_less'] < '01:00:00' && $c != 'อา') {
332. $people_hour = 0;
333. } elseif ($get_timediff[0]['time_less'] >= '02:00:00' && $get_timediff[0]['time_less'] < '02:30:00' && $c != 'อา') {
334. $people_hour = 2;
335. }
336.
337. $sum_ot_hr += $people_hour;
338.
339. print("จำนวน OT(" . $people_hour . ")ชม.<br>");
340.
341.
342.
343.
344. $get_process_midday = getlist("SELECT * FROM emp_process
345. WHERE emp_id='" . $get_data[$i]['emp_id'] . "'
346. AND process_date='" . $cutNew_date[0] . "' ORDER BY process_time");
347.
348.
349. if ($get_time_max_min[0]['time_min'] > '08:00:00' && $c != 'อา') {
350.
351. $time_less = getlist("SELECT TIMEDIFF((SELECT TIMEDIFF('17:00:00','" . $get_time_max_min[0]['time_min'] . "')),'01:00:00') AS time_less");
352.
353.
354. $time_less_result = explode(":", $time_less[0]['time_less']);
355. if ($time_less_result[1] < 30) {
356. $result_late = $time_less_result[0];
357. print($result_late . "");
358. } else if ($time_less_result[1] >= 30) {
359. $result_late = number_format($time_less_result[0]) + 0.5;
360. print($result_late . "ชม.");
361. }
362.
363. $show_total_hours += $result_late;
364. }
365.
366. if ($get_time_max_min[0]['time_min'] > '08:00:00' && $c == 'อา') {
367. print("-");
368. }
369.
370.
371.
372.
373.
374.
375. else if ($get_time_max_min[0]['time_min'] <= '08:00:00' && $c == 'อา') {
376. $result_late = 0;
377. $result_holiday = 0;
378. print("1");
379.
380.
381.
382.
383.
384.
385.
386. $show_total_day += $result_late;
387. $show_total_day_holiday += $result_holiday;
388. }
389.
390.
391. else if ($get_time_max_min[0]['time_min'] <= '08:00:00' && $get_time_max_min[0]['time_max'] < '17:00:00' && $get_time_max_min[0]['time_max'] != $get_time_max_min[0]['time_min']) {
392.
393. $time_less = getlist("SELECT TIMEDIFF((SELECT TIMEDIFF('" . $get_time_max_min[0]['time_max'] . "','08:00:00')),'01:00:00') AS time_less");
394. $result_late = number_format($time_less[0]['time_less']);
395. print($result_late . "ชม.");
396. $show_total_hours += $result_late;
397. }
398.
399.
400. else if ($get_time_max_min[0]['time_min'] <= '08:00:00' && $get_time_max_min[0]['time_max'] < '17:00:00' && $get_time_max_min[0]['time_max'] == $get_time_max_min[0]['time_min']) {
401. $result_late = 1;
402. print("<font color='blue'>" . $result_late . "</font>");
403.
404. $show_total_day += $result_late;
405. }
406.
407.
408. else if (sizeof($get_process_midday) == 4) {
409.
410.
411.
412.
413.
414.
415. if ($get_process_midday[1]['process_time'] < '12:00:00') {
416.
417. $time_midday = getlist("SELECT TIMEDIFF('" . $get_process_midday[1]['process_time'] . "','08:00:00') AS time_midday");
418.
419.
420. $time_midday2 = getlist("SELECT TIMEDIFF('" . $get_process_midday[3]['process_time'] . "','13:00:00') AS time_midday2");
421.
422.
423. $time_midday_explode = explode(":", $time_midday[0]['time_midday']);
424.
425. if ($time_midday_explode[1] >= 30) {
426. $time_midday_explode_minute = 0.5;
427. } else {
428. $time_midday_explode_minute = 0;
429. }
430.
431. $time_midday_total = ($time_midday[0]['time_midday']) + ($time_midday2[0]['time_midday2']);
432. $show_total_hours = $time_midday_total + $time_midday_explode_minute;
433. print($show_total_hours);
434.
435. }
436.
437.
438. if ($get_process_midday[2]['process_time'] > '12:59:00') {
439. $time_less_result = explode(":", $get_process_midday[2]['process_time']);
440.
441.
442. if ($time_less_result[1] >= 1 && $time_less_result[1] <= 30) {
443.
444. $time_cal = ($time_less_result[0] . ":" . "30" . ":" . "00");
445.
446. }
447.
448. else if ($time_less_result[1] >= 31 && $time_less_result[1] <= 59) {
449. $time_less_result[0] += 1;
450. $time_cal = ($time_less_result[0] . ":" . "00" . ":" . "00");
451. }
452. $time_less_2_total = getlist("SELECT TIMEDIFF('" . $time_cal . "','13:00:00') AS time_less_2_total");
453. $time_less_3_total = getlist("SELECT TIMEDIFF('08:00:00','" . $time_less_2_total[0]['time_less_2_total'] . "') AS time_less_3_total");
454.
455. $result_late = ($time_less_3_total[0]['time_less_3_total']);
456.
457. $result_late2 = explode(":", $result_late);
458.
459.
460. if ($result_late2[1] == 30) {
461. $result_late3 = $result_late2[0] + 0.5;
462. }
463.
464. else {
465. $result_late3 = $result_late2[0];
466. }
467.
468. $show_total_hours += $result_late3;
469. print($show_total_hours);
470. }
471.
472. else if ($get_process_midday[1]['process_time'] >= '12:00:00' && $get_process_midday[2]['process_time'] <= '12:59:00') {
473.
474. $result_late = 1;
475. print($result_late);
476. $show_total_day += $result_late;
477. }
478. }
479.
480. else {
481. $result_late = 1;
482. print($result_late);
483.
484.
485.
486.
487.
488.
489. $show_total_day += $result_late;
490. }
491. }
492.
493.
494. else {
495.
496. if ($c == "อา") {
497. print("-");
498. }
499.
500. else {
501. $result_late = 1;
502.
503. print("ไม่มาทำงาน");
504. print("</a>");
505.
506. }
507. }
508. print("</td>");
509. }
510.
511.
512. print("<td style=\"text-align:center; padding-left:0,px;\">");
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523. if ($show_total_hours != 0) {
524.
525. if ($show_total_hours >= 8) {
526. $hours_balance = $show_total_hours - 8;
527. $show_total_day += 1;
528. } else {
529. $hours_balance += $show_total_hours;
530. }
531. print($show_total_day . " วัน");
532. print("<br>" . $hours_balance . " ชม");
533. } else if ($show_total_hours == 0) {
534. print($show_total_day . " วัน");
535. }
536. print("</td>");
537.
538.
539. print("<td>");
540. print("340");
541. print("</td>");
542.
543. print("<td>");
544. $sum_today = $show_total_day * 340;
545. print(number_format($sum_today));
546. print("</td>");
547.
548. print("<td>");
549. $sum_opcost = $show_total_day * 325;
550. print(number_format($sum_opcost));
551. print("</td>");
552.
553. print("<td>");
554. $sum_monney = ($sum_opcost * 25) / 100;
555. print(number_format($sum_monney, 2, '.', ','));
556. print("</td>");
557.
558. print("<td>");
559. print($sum_ot_hr);
560. print("</td>");
561.
562. print("<td>");
563. print($ot_hours_weekend . " ชม.");
564. print("</td>");
565.
566. print("<td>");
567. $sum_ot = ((340 / 8) * 1.5) * $ot_hours;
568. print(number_format($sum_ot, 2, '.', ','));
569. print("</td>");
570.
571. print("<td>");
572. print("325");
573. print("</td>");
574.
575. print("<td>");
576. print("325");
577. print("</td>");
578.
579. print("<td>");
580. print("325");
581. print("</td>");
582.
583.
584. print("<td>");
585. $show_total_hours2 = $hours_balance * 40;
586. print($hours_balance . "<br>");
587. print($show_total_hours2);
588. print("<br>");
589. $result_salary_garden = ($show_total_day * $rate_per_day) + $show_total_hours2;
590. print number_format($result_salary_garden);
591. print("</td>");
592.
593. $result_salary_garden2 += $result_salary_garden;
594. print("</tr>");
595. $hours_balance = 0;
596.
597. $total_today += $sum_today;
598.
599.
600. $total_opcpst += $sum_opcost;
601.
602.
603. $total_money += $sum_monney;
604.
605.}
606.
607.print("<tr>");
608.print("<td colspan=\"$colspan_table\">");
609.print("ยอดรวมทั้งหมด");
610.print("</td>");
611.print("<td>");
612.print number_format($total_today);
613.print("</td>");
614.print("<td>");
615.print number_format($total_opcpst);
616.print("</td>");
617.print("<td>");
618.print(number_format($total_money, 2, '.', ','));
619.print("</td>");
620.print("<td>");
621.print number_format($total_ot);
622.print("</td>");
623.print("<td>");
624.print number_format($result_salary_garden2);
625.print("</td>");
626.print("</tr>");
627.
628.print("<br>");
629.print("<br>");
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.print("</center>");
694.print("</form>");
695.?>
696.</body>
697.</html>
