generate_document_pdf.php
<![CDATA[<?php include_once("checklogin.php"); ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Lekjew.com</title>
<link rel="stylesheet" type="text/css" href="css/jquery.dataTables.css">
<link rel="stylesheet" type="text/css" href="css/dataTables.bootstrap4.css">
<link rel="stylesheet" type="text/css" href="css/responsive.dataTables.css">
<link rel="stylesheet" href="assets/css/bootstrap-select.css" />
<link rel="stylesheet" type="text/css" media="screen" href="assets/css/bootstrap-datetimepicker.css">
<link rel="stylesheet" type="text/css" media="screen" href="assets/css/bootstrap-datetimepicker.min.css">
<link type="text/css" href="//gyrocode.github.io/jquery-datatables-checkboxes/1.2.11/css/dataTables.checkboxes.css" rel="stylesheet" />
<?php include_once("include/style.php"); ?>
<style>
#tableA tr th, #tableA tr td {font-size:14px !important;}
</style>
</head>
<body class="adminbody">
<?php include_once("include/header_login.php"); ?>
<div class='' id="main" >
<?php include_once("leftmenu.php"); ?>
<div class="content-page"><div class="col-md-12">
<div class="content">
<div class="card pd-10">
<div class="row">
<div class="col-md-12">
<div class="col-md-12"><h3>Slip / สลิป </h3></div>
</div>
<div class="col-md-5 col-xl-5">
<div class="row">
<div class="col-md-12">
<div class="col-md-6"><div class="row">
<div class="input-group mb-2 input-group-sm">
<div class="input-group-prepend"><span class="input-group-text ">Slip Month</span></div>
<input type="text" class="form-control form-control-sm form_date" name="slipmonth" id="slipmonth" data-format='yy-mm-dd' value="2024-11-01" onchange="CallSlip();">
</div>
</div></div>
</div>
<div class="col-md-12" id="showdoing"></div>
<div class="table-responsive" id="showtbody1">
<table id="tableA" class="table table-bordered table-layout nowrap tablec" cellspacing="0" border="1" width="100%">
<thead>
<tr>
<th class='hide'>#</th>
<th class='nowrap'>#</th>
<th class='nowrap'>pdf</th>
<th class='nowrap'>Employee Code</th>
<th class='nowrap'>Employee Name</th>
<th class='nowrap'>Position</th>
<th class='nowrap'>BirthDay</th>
<th class='nowrap'>amount</th>
</tr>
<tr>
<td class='hide'>#</td>
<td class='nowrap'>#</td>
<td class='nowrap'>pdf</td>
<td class='nowrap'>Employee Code</td>
<td class='nowrap'>Employee Name</td>
<td class='nowrap'>Position</td>
<td class='nowrap'>BirtdDay</td>
<td class='nowrap'>amount</td>
</tr>
</thead>
<tbody id="showtbody">
</tbody>
</table>
</div>
</div>
</div><!-- end col-md-5 -->
<div class="col-md-7 col-xl-7" style="background-color: #f1f1f1;">
<div class="row">
<iframe id="ifm" frameborder="0" scrolling="yes" style="width:100%; height:700px;" ></iframe>
</div>
</div><!-- end col-md-7 -->
</div><!-- end row -->
</div>
</div>
</div>
</div>
</div>
<div id="ModalDELETE" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Delete</h5>
<button type="button" class="btn-close closemodaldel" data-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<input type="hidden" name="RUNNO_DELETE" id="RUNNO_DELETE" class="form-control">
<div id="showdel"></div>
<div class='text-danger' id='showerr'></div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary closemodaldel" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary" onclick="DeleteChemicalType();">Confirm Delete</button>
</div>
</div>
</div>
</div>
</body>
</html>
<?php include_once("include/js.php"); ?>
<script type="text/javascript" src="assets/js/bootstrap-datetimepicker.js" charset="UTF-8"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.bootstrap4.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script> <!-- excel -->
<script src="https://cdn.datatables.net/select/1.4.0/js/dataTables.select.min.js"></script>
<script type="text/javascript" src="//gyrocode.github.io/jquery-datatables-checkboxes/1.2.11/js/dataTables.checkboxes.min.js"></script>
<script>
RefreshTable();
$('#slipmonth').click();
$('.ui-datepicker-calendar').removeClass('ui-state-highlight');
$('.form_date').datetimepicker({
language: 'en',
weekStart: 1,
todayBtn: 1,
autoclose: 1,
todayHighlight: 1,
startView: 3,
minView: 3,
format: 'mm-yyyy',
forceParse: 0
});
function CallSlip(){
var slipmonth = $('#slipmonth').val();
var slip = (slipmonth).split('-');
var month = slip[0];
var year = slip[1];
var form_data = new FormData();
form_data.append("slip_year", year );
form_data.append("slip_month", month );
$.ajax({
url: "generate_document_data.php",
async: false,
cache: false,
contentType: false,
processData: false,
data: form_data,
type: 'POST',
dataType: "text",
beforeSend: function() {
$("#showtbody").html("<tr><td class='hide'></td><td colspan='7' class='text-center'><i class='fa fa-spinner fa-pulse fa-2x'></i></td></tr>");
},
success: function(data) {
$('button').removeClass('noclick');
var tr_str = "";
var tripno = "";
var JsonData = JSON.parse(data);
var resL = JsonData['result'].length;
if(resL>0){
for (var i = 0; i < resL; i++) {
tr_str = tr_str + "<tr class='row"+i+"'>";
tr_str = tr_str + "<td class='hide'>1</td>";
tr_str = tr_str + "<td><input type='checkbox' name='' ></td>";
tr_str = tr_str + "<td>";
if(typeof JsonData['result'][i]['slip_pdf'] !== "undefined" && JsonData['result'][i]['slip_pdf'] !== null ){ tr_str = tr_str + "<a href='"+JsonData['result'][i]['slip_pdf']+"' target='_blank'><i class='fa fa-file-pdf-o'></i></a>"; }
tr_str = tr_str + "</td>";
tr_str = tr_str + "<td>";
if(typeof JsonData['result'][i]['slip_emcode'] !== "undefined" && JsonData['result'][i]['slip_emcode'] !== null ){ tr_str = tr_str + JsonData['result'][i]['slip_emcode']; }
tr_str = tr_str + "</td>";
tr_str = tr_str + "<td>";
if(typeof JsonData['result'][i]['slip_emname'] !== "undefined" && JsonData['result'][i]['slip_emname'] !== null ){ tr_str = tr_str + JsonData['result'][i]['slip_emname']; }
tr_str = tr_str + "</td>" ;
tr_str = tr_str + "<td>";
if(typeof JsonData['result'][i]['slip_position'] !== "undefined" && JsonData['result'][i]['slip_position'] !== null ){ tr_str = tr_str + JsonData['result'][i]['slip_position']; }
tr_str = tr_str + "</td>" ;
tr_str = tr_str + "<td>";
if(typeof JsonData['result'][i]['slip_birthday'] !== "undefined" && JsonData['result'][i]['slip_birthday'] !== null ){ tr_str = tr_str + JsonData['result'][i]['slip_birthday']; }
tr_str = tr_str + "</td>" ;
tr_str = tr_str + "<td class='text-right'>";
if(typeof JsonData['result'][i]['slip_netamt'] !== "undefined" && JsonData['result'][i]['slip_netamt'] !== null ){ tr_str = tr_str + JsonData['result'][i]['slip_netamt']; }
tr_str = tr_str + "</td>" ;
tr_str = tr_str + "</tr>";
}
}
$('#tableA').DataTable().destroy();
$("#showtbody").html(tr_str);
RefreshTable(year, month);
} ,
error : function(data){
alert(data);
$('button').removeClass('noclick');
}
});
}
function RefreshTable(year, month){
$('#tableA thead tr:eq(0) th').empty();
$('#tableA thead tr:eq(0) th').each( function (i) {
if(i>2){
var title = $(this).text();
$(this).html( '<input type="text" class="form-control form-control-sm search'+i+' section-no-print">' );
$( 'input', this ).on( 'keyup change', function () {
if ( table.column(i).search() !== this.value ) {
table
.column(i)
.search( this.value )
.draw();
}
});
}
} );
var table = $('#tableA').DataTable( {
dom: 'Btip',
paging: true,
searching: true,
bProcessing: true,
ordering: false,
lengthMenu: [[10, 25, 50, -1], [10, 25, 50, "All"]],
iDisplayLength: -1,
scrollY: "500px",
scrollCollapse: true,
scrollX: true,
responsive: false,
select: true,
select: { 'style': 'multi' },
columnDefs: [{ 'targets': 1, 'checkboxes': {'selectRow': true} }],
buttons:[{
extend: 'excelHtml5',
autoFilter: true,
footer: true,
filename: 'ExportC1',
title: 'เอกสาร C1',
className: "btn btn-success btn-sm",
text: '<i class="fa fa-file-excel-o"></i> สลิปเงินเดือนพนักงาน เดือน '+month +' ปี '+year,
exportOptions: { columns: ':not(.section-no-print)' }
},
{
extend: "selected",
className: "btn btn-warning btn-sm ",
text: '<i class="fa fa-eye"></i> View',
selector: ':not(.notselect)',
action: function () {
var numrow = $('#tableA tbody tr').length;
for(var j=0;j<numrow;j++){
$('.notselect').removeClass('selected');
}
var dataem = [];
var rows = table.rows( { selected: true } ).data().each(
element => dataem.push( { "EM_CODE" : element[3], "EM_NAME" : element[4], "EM_POSITION" : element[5], "EM_BIRTHDATH" : element[6] })
);
$("#ifm").contents().find("body").html('');
var form_data = new FormData();
form_data.append("slip_month", month);
form_data.append("slip_year", year);
form_data.append("EM", JSON.stringify(dataem));
$.ajax({
url: "generate_document_print.php",
async: false,
cache: false,
contentType: false,
processData: false,
data: form_data,
type: 'POST',
dataType: "text",
success: function(data) {
$("#ifm").contents().find("body").html(data);
},
error: function(data){
$('#showPrint').html(data);
}
});
}
},
{
extend: "selected",
className: "btn btn-danger btn-sm ",
text: '<i class="fa fa-file-pdf-o"></i> CREATE PDF',
selector: ':not(.notselect)',
action: function () {
var numrow = $('#tableA tbody tr').length;
for(var j=0;j<numrow;j++){
$('.notselect').removeClass('selected');
}
var dataem = [];
var rows = table.rows( { selected: true } ).data().each(
element => dataem.push( { "EM_CODE" : element[3], "EM_NAME" : element[4], "EM_POSITION" : element[5], "EM_BIRTHDATH" : element[6] })
);
var form_data = new FormData();
form_data.append("slip_month", month);
form_data.append("slip_year", year);
var num = dataem.length;
var errname = "";
var numerr = 0;
if(num>0){
for(var em=0; em < num; em++){
// console.log(dataem[em]["EM_CODE"]);
form_data.append("slip_emcode", dataem[em]["EM_CODE"]);
$.ajax({
url: "generate_document_create_pdf.php",
contentType: false,
processData: false,
cache: false,
data: form_data,
dataType: "text",
type: 'post',
success: function(data) {
var JsonData = JSON.parse(data);
var resL = JsonData['result'].length;
for(var i =0; i<resL; i++){
if(typeof JsonData['result'][i]['ERR'] !== "undefined" && JsonData['result'][i]['ERR'] !== null && JsonData['result'][i]['ERR'] != ""){
errname = errname + JsonData['result'][i]['ERR'];
numerr++;
}
}
var numerr = errname.length;
if(numerr==0){
showSuccessAlert("สำเร็จ");
}else{
showFailAlert(errname);
}
CallSlip();
},
error: function(data){
showFailAlert(data);
}
});
}
}
}
}
]
});
$('#tableA thead tr:eq(0)').empty();
$('.dataTables_scrollBody #tableA tr:eq(0) ').empty();
}
function showSuccessAlert(data) {
$('#resultalert').html(data);
$("#success-alert").fadeTo(2000, 300).slideUp(300, function(){
$("#success-alert").slideUp(300);
});
}
function showFailAlert(data) {
$('#resultfailalert').html(data);
$("#fail-alert").fadeTo(2000, 300).slideUp(300, function(){
$("#fail-alert").slideUp(300);
});
}
</script>]]> generate_document_data.php
<![CDATA[<?php
include('connectDBMS.php');
$data = array();
$slip_year = $_POST['slip_year'];
$slip_month = $_POST['slip_month'];
$sql = "SELECT *
FROM slip_header as sp
WHERE slip_year = '$slip_year'
and slip_month = '$slip_month'
";
$rsc = sqlsrv_query($ConnDB, $sql);
while($rowp = sqlsrv_fetch_object($rsc)) {
$data[] = array( "slip_id" => $rowp->slip_id
, "slip_emcode" => $rowp->slip_emcode
, "slip_emname" => $rowp->slip_emname
, "slip_position" => $rowp->slip_position
, "slip_birthday" => $rowp->slip_birthday
, "slip_netamt" => $rowp->slip_netamt
, "slip_pdf" => $rowp->slip_pdf
, "slip_status" => $rowp->slip_status
);
}
$json = array('result' => $data);
echo json_encode($json, JSON_UNESCAPED_UNICODE);
sqlsrv_close($ConnDB);
?>]]>generate_document_print.php
<![CDATA[<?php
include_once("connectDBMS.php");
$day_now=date("Y-m-d");
$Y=substr(date('Y')+543,2,2);
$m=sprintf("%02d", date('m')-1);
$daysearch = $Y.$m;
$showdaynow=date("d/m/Y");
$prev7 = date('Y-m-d',strtotime( "-7 days"));
$showprev7 = date('d/m/Y',strtotime( "-7 days"));
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=0.96">
<title>Lekjew.com</title>
<link rel="stylesheet" type="text/css" href="css/jquery.dataTables.css">
<link rel="stylesheet" type="text/css" href="css/dataTables.bootstrap4.css">
<link rel="stylesheet" type="text/css" href="css/responsive.dataTables.css">
<link rel="stylesheet" href="assets/css/bootstrap-select.css" />
<link rel="stylesheet" type="text/css" media="screen" href="assets/css/bootstrap-datetimepicker.css">
<link rel="stylesheet" type="text/css" media="screen" href="assets/css/bootstrap-datetimepicker.min.css">
<link type="text/css" href="//gyrocode.github.io/jquery-datatables-checkboxes/1.2.11/css/dataTables.checkboxes.css" rel="stylesheet" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Sarabun">
<?php include_once("include/style.php"); ?>
<style>
body {
font:normal 13px Tahoma, sans-serif !important;
background-color: #f1f1f1;
padding-bottom: 50px;
font-family: 'Sarabun', sans-serif !important;
color:#202020 !important;
}
.card {background-color:#ffffff !important; border:0px !important;}
.card-body{padding:0.2rem;}
.m-top-10{margin-top:10px;}
.m-top-20{margin-top:20px;}
.m-bottom-10{margin-bottom:10px;}
.m-bottom-20{margin-bottom:20px;}
.head1{ background-color:#f1f1f1;border:1px solid #555;}
.body1{ border-left:1px solid #555; border-right:1px solid #555; margin-top:-10px; height:300px;}
.pd-5{padding:5px;}
</style>
<style media="print">
@charset "UTF-8";
@page {
size:A4 Portrait;
margin-left: 10px;
margin-right: 10px;
margin-top: 10px;
margin-bottom: 10px;
-webkit-print-color-adjust: exact;
}
@media all {
.page-break { display: block; page-break-after: always; }
}
@media print {
body {-webkit-print-color-adjust: exact;
font-family: 'Sarabun', sans-serif; font-size:13px;
color:#202020 !important;
}
page[size="A4"] {
box-shadow: 0;
width: 21cm;
margin-left: 10px;
margin-right: 10px;
margin-top: 10px;
margin-bottom: 10px;
-webkit-print-color-adjust: exact;
height: 100%;
color:#202020 !important;
}
.setscaled { transform: scale(1); transform-origin: top left;margin-top: 5px; zoom: 1; /* Old IE only */ -moz-transform: scale(1);-webkit-transform: scale(1);}
.page-break { display: block; page-break-after: always; }
.hideprint {display:none;}
.card {background-color:#ffffff !important; border:0px !important;}
.card-body{padding:0.2rem;}
.m-top-5{margin-top:5px;}
.m-top-20{margin-top:20px;}
.m-bottom-10{margin-bottom:10px;}
.m-bottom-20{margin-bottom:20px;}
.head1{ background-color:#f1f1f1;border:1px solid #555;}
.body1{ border-left:1px solid #555; border-right:1px solid #555; margin-top:-10px;height:300px;}
.pd-5{padding:5px;}
}
</style>
</head>
<body>
<div class="col-md-12 m-top-20 " id="">
<div class="btn btn-info btn-sm hideprint" onClick="window.print();return false;">Print PayRoll</div>
<?php
// $GETDATA = array();
// $slip_month = "11";
// $slip_year = "2024";
$slip_month = $_POST["slip_month"];
$slip_year = $_POST["slip_year"];
$slip_yearth= $slip_year+543;
$GETDATA = $_POST["EM"];
$EM = json_decode($GETDATA,true);
$numdvn = sizeof($EM);
for($k=0;$k<$numdvn;$k++){
$sql = "SELECT * FROM slip_header WHERE slip_month='".$slip_month."' and slip_year='".$slip_year."' and slip_emcode='".$EM[$k]["EM_CODE"]."' ";
$i=0;
$data_show="2";
$rse = sqlsrv_query($ConnDB, $sql);
while ($rowe = sqlsrv_fetch_object($rse)) {
$i=$i+1;
?>
<?php if($i%$data_show==0){ ?>
<page size="A4" class="setscaled">
<div class="m-10 m-top-20 m-bottom-20 page-break">
<?php } ?>
<div class=" card m-top-40 m-bottom-20">
<br><br>
<div class="col-md-12 m-top-20"><div class="row">
<div class="col-md-12 text-center">บริษัท Lekjew.com จำกัด</div>
</div></div>
<div class="col-md-12 m-top-10"><div class="row">
<div style="width:1%"></div>
<div style="width:15%">ชื่อ-สกุล</div>
<div style="width:35%"><?php echo $rowe->slip_accountname; ?></div>
<div style="width:10%"></div>
<div style="width:15%">ตำแหน่ง</div>
<div style="width:20%"><?php echo $rowe->slip_position; ?></div>
</div></div>
<div class="col-md-12 m-top-10"><div class="row">
<div style="width:1%"></div>
<div style="width:15%">เลขที่บัญชี</div>
<div style="width:35%"><?php echo $rowe->slip_accountno; ?></div>
<div style="width:10%"></div>
<div style="width:15%">ประจำเดือน</div>
<div style="width:20%"><?php echo CallMonth($rowe->slip_month); ?> <?php echo $slip_yearth; ?></div>
</div></div>
<div class="row m-top-10">
<div style="width:1%"></div>
<div style="width:48%">
<div class="head1"><div class="col-md-12 text-center pd-5">รายได้</div></div>
<div class="body1">
<div class="row m-top-10">
<div style="width:23%">รวมรายได้</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_workday_amt,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">ค่าครองชีพ</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_food_amt,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:23%">วันทำงาน</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_workday,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">ค่าเดินทาง</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_travel_amt,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:23%">OT 1.5 เท่า</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot1_5_amt,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">เบี้ยขยัน</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_deligence,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:23%">จำนวนชั่วโมง</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot1_5,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">ค่ากะ</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_shiftfee_amt,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:23%">OT 1 เท่า</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot1_amt,2); ?></div>
<div style="width:1%"></div>
<div style="width:29%">incentive/ประกัน</div>
<div style="width:18%" class="text-right"><?php echo number_format($rowe->slip_income_insurance,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:23%">จำนวนชั่วโมง</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot1,2); ?></div>
<div style="width:1%"></div>
<div style="width:29%">ค่ากล่อง/ค่าแรงตก</div>
<div style="width:18%" class="text-right"><?php echo number_format($rowe->slip_box,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:23%">OT 2 เท่า</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot2_amt,2); ?></div>
<div style="width:1%"></div>
<div style="width:30%">ค่าที่พัก/ค่าตำแหน่ง</div>
<div style="width:17%" class="text-right"><?php //echo number_format($rowe->slip_room,2); ?>1000.00</div>
</div>
<div class="row m-top-10">
<div style="width:23%">จำนวนชั่วโมง</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot2,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:23%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:23%">OT 3 เท่า</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot3_amt,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:23%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:23%">จำนวนชั่วโมง</div>
<div style="width:23%" class="text-right"><?php echo number_format($rowe->slip_ot3,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:23%" class="text-right"></div>
</div>
<div class="row m-top-10"></div>
</div>
</div>
<div style="width:48%">
<div class="head1"><div class="col-md-12 text-center pd-5">รายการหัก</div></div>
<div class="col-md-12 body1">
<div class="row m-top-10">
<div style="width:28%">ประกันสังคม</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_social,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">ค่าเช่าห้อง</div>
<div style="width:22%" class="text-right"><?php echo number_format($rowe->slip_roomrent,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:28%">หัก ณ ที่จ่าย</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_tax,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">ค่าน้ำ-ค่าไฟ</div>
<div style="width:22%" class="text-right"><?php echo number_format($rowe->slip_water_electricity_bill,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:28%">เบิกล่วงหน้า 25</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_advance25,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">ค่าเสียหาย</div>
<div style="width:22%" class="text-right"><?php echo number_format($rowe->slip_damages,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:28%">เบิกนอกรอบ</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_advance,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%">อื่นๆ</div>
<div style="width:22%" class="text-right"><?php echo number_format($rowe->slip_deduct_other,2); ?></div>
</div>
<div class="row m-top-10">
<div style="width:28%">เงินกู้ยืม</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_loan,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:22%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:28%">เงินมัดจำ</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_deposit,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:22%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:28%">ค่าธรรมเนียม</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_fee,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:22%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:28%">เงินช่วยค่าทำศพ</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_funeral_donation,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:22%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:28%">ค่าแรงเกิน</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_overpaid,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:22%" class="text-right"></div>
</div>
<div class="row m-top-10">
<div style="width:28%">ค่าอุปกรณ์เซฟตี้</div>
<div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_safetyfee,2); ?></div>
<div style="width:1%"></div>
<div style="width:23%"></div>
<div style="width:22%" class="text-right"></div>
</div>
<div class="row m-top-10"></div>
</div>
</div>
</div>
<div class="row">
<div style="width:1%"></div>
<div style="width:48%">
<div class="head1">
<div class="row pd-5"><div style="width:30%" class="text-left">รวมรายได้ทั้งหมด</div><div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_income,2); ?></div></div>
</div>
</div>
<div style="width:48%">
<div class="head1">
<div class="row pd-5"><div style="width:30%" class="text-left">รวมรายจ่ายทั้งหมด</div><div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_sum_deduct,2); ?></div></div>
</div>
</div>
<div style="width:1%"></div>
<div style="width:48%;">
<div class="head1" style=" height:32px;">
<div class="col-md-12 text-center pd-5"><div class="row"><div class="col-md-4 text-left"></div><div class="col-md-2"></div></div></div>
</div>
</div>
<div style="width:48%">
<div class="head1">
<div class="row pd-5"><div style="width:30%" class="text-left">รวมรายได้สุทธิ</div><div style="width:20%" class="text-right"><?php echo number_format($rowe->slip_netamt,2); ?></div></div>
</div>
</div>
</div>
<div class="col-md-12 m-top-20"><div class="row">
</div></div>
<?php if($i%$data_show!=0){ ?>
<br><br><br><br><br><br>
<?php } ?>
</div>
<?php if($i%$data_show==0){ ?>
</div>
</page>
<?php }
}
} ?>
</div>
</body>
</html>
<?php
function CallMonth($slipmonth){
switch($slipmonth){
case "01" : $mon="มกราคม"; break;
case "02" : $mon="กุมภาพันธ์"; break;
case "03" : $mon="มีนาคม"; break;
case "04" : $mon="เมษายน"; break;
case "05" : $mon="พฤษภาคม"; break;
case "06" : $mon="มิถุนายน"; break;
case "07" : $mon="กรกฎาคม"; break;
case "08" : $mon="สิงหาคม"; break;
case "09" : $mon="กันยายน"; break;
case "10" : $mon="ตุลาคม"; break;
case "11" : $mon="พฤศจิกายน"; break;
case "12" : $mon="ธันวาคม"; break;
}
return $mon;
}
?>
]]> generate_document_create_pdf.php
<![CDATA[<?php
include_once("connectDBMS.php");
if(!$ConnDB){ echo "not connect database.";
exit();
}
$result = array();
$slip_month = $_POST["slip_month"];
$slip_year = $_POST["slip_year"];
$slip_emcode = $_POST["slip_emcode"];
// $slip_month = "11";
// $slip_year = "2024";
// $slip_emcode= "121060127";
$slip_yearth= $slip_year+543; //2567
$shortyear = substr($slip_yearth,2,2); //67
require('FPDF_Protection.php');
$pdf = new FPDF_Protection();
$sql = "SELECT *, Convert(nvarchar(10), DATEADD(YEAR, +543, cast(slip_birthday as date)), 104) as slip_pwd
FROM slip_header as sh
WHERE sh.slip_month='".$slip_month."' and sh.slip_year='".$slip_year."' and sh.slip_emcode='".$slip_emcode."' ";
$rsh = sqlsrv_query($ConnDB, $sql);
while( $rh = sqlsrv_fetch_object($rsh)) {
$pwd = $rh->slip_pwd;
$pdf->SetProtection(array('print'),$pwd); //in place of password user your password
$pdf->SetMargins(10, 10, 0);
$pdf->AddPage();
$pdf->AliasNbPages();
$pdf->AddFont('THSarabunNew','','THSarabunNew.php');
$pdf->SetFont('THSarabunNew','',8);
$pdf->Cell(0,6,iconv( 'UTF-8','TIS-620',$pdf->PageNo()." "),0,1,"R");
$pdf->Ln(4);
$pdf->SetFont('THSarabunNew','',14);
$pdf->Cell(0,6,iconv( 'UTF-8','TIS-620','บริษัท lekjew.com จำกัด'),0,1,"C");
$pdf->Ln(4);
$pdf->SetFont('THSarabunNew','',13);
$pdf->Cell(25, 6, iconv( 'UTF-8','TIS-620','ชื่อ-สกุล') ,0, 0 , 'L');
$pdf->Cell(98, 6, iconv( 'UTF-8','TIS-620',$rh->slip_emname) ,0, 0 , 'L');
$pdf->Cell(20, 6, iconv( 'UTF-8','TIS-620', 'ตำแหน่ง') ,0, 0 , 'L');
$pdf->Cell(50, 6, iconv( 'UTF-8','TIS-620', $rh->slip_position) ,0, 0 , 'L');
$pdf->Ln(6);
$pdf->Cell(25, 6, iconv( 'UTF-8','TIS-620','เลขที่บัญชี') ,0, 0 , 'L');
$pdf->Cell(98, 6, iconv( 'UTF-8','TIS-620',$rh->slip_bankaccountno) ,0, 0 , 'L');
$pdf->Cell(20, 6, iconv( 'UTF-8','TIS-620', 'ประจำเดือน') ,0, 0 , 'L');
$pdf->Cell(50, 6, iconv( 'UTF-8','TIS-620', CallMonth($slip_month) ." ". $slip_yearth) ,0, 0 , 'L');
$pdf->Ln(10);
$pdf->setFillColor(230,230,230);
$slipnoi=array(iconv( 'UTF-8','TIS-620','รายได้'),iconv( 'UTF-8','TIS-620','รายการหัก'));
$x=array(95, 95);
for($j=0;$j<count($slipnoi);$j++){
$pdf->Cell($x[$j],7,$slipnoi[$j],1,0,'C', 'TRUE');
}
$pdf->Ln(7);
$pdf->SetFont('THSarabunNew','',12);
$pdf->Cell(95, 54, iconv( 'UTF-8','TIS-620','') ,1, 0 , 'L');
$pdf->Cell(95, 54, iconv( 'UTF-8','TIS-620','') ,1, 0 , 'L');
$pdf->Ln(2);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','รวมรายได้') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_workday_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','ค่าครองชีพ') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_food_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','ประกันสังคม') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_social,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','ค่าเช่าห้อง') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_roomrent,2)) ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','วันทำงาน') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_workday,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','ค่าเดินทาง') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_travel_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','หัก ณ ที่จ่าย') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_tax,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','ค่าน้ำ-ค่าไฟ') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_water_electricity_bill,2)) ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','OT 1.5 เท่า') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot1_5_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','เบี้ยขยัน') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_deligence,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','เบิกล่วงหน้า 25') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_advance25,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','ค่าเสียหาย') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_damages,2)) ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','จำนวนชั่วโมง') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot1_5,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','ค่ากะ') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_shiftfee_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','เบิกนอกรอบ') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_advance,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','อื่นๆ') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_deduct_other,2)) ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','OT 1 เท่า') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot1_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','Incentive/ประกัน') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_income_insurance,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','เงินกู้ยืม') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_loan,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','จำนวนชั่วโมง') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot1,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','ค่ากล่อง/ค่าแรงตก') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_box,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','เงินมัดจำ') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_deposit,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','OT 2 เท่า') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot2_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','ค่าที่พัก/ค่าตำแหน่ง') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_room,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','ค่าธรรมเนียม') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_fee,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','จำนวนชั่วโมง') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot2,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','เงินช่วยค่าทำศพ') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_funeral_donation,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','OT 3 เท่า') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot3_amt,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','ค่าแรงเกิน') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_overpaid,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Ln(5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','จำนวนชั่วโมง') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_ot3,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(33, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(12, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','ค่าอุปกรณ์เซฟตี้') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_safetyfee,2)) ,0, 0 , 'R');
$pdf->Cell(3, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(30, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'R');
$pdf->Ln(6.5);
$pdf->setFillColor(230,230,230);
$slipnoi=array(iconv( 'UTF-8','TIS-620',''),iconv( 'UTF-8','TIS-620',''));
$x=array(95, 95);
for($j=0;$j<count($slipnoi);$j++){
$pdf->Cell($x[$j],7,$slipnoi[$j],1,0,'C', 'TRUE');
}
$pdf->Ln(0.5);
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','รวมรายได้ทั้งหมด') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_income,2)) ,0, 0 , 'R'); //อันเดิมใช้ slip_sum_income
$pdf->Cell(51, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','รวมรายจ่ายทั้งหมด') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_sum_deduct,2)) ,0, 0 , 'R');
$pdf->Ln(6.5);
$pdf->setFillColor(230,230,230);
$slipnoi=array(iconv( 'UTF-8','TIS-620',''),iconv( 'UTF-8','TIS-620',''));
$x=array(95, 95);
for($j=0;$j<count($slipnoi);$j++){
$pdf->Cell($x[$j],7,$slipnoi[$j],1,0,'C', 'TRUE');
}
$pdf->Ln(0.5);
$pdf->Cell(96, 5, iconv( 'UTF-8','TIS-620','') ,0, 0 , 'L');
$pdf->Cell(35, 5, iconv( 'UTF-8','TIS-620','รวมรายได้สุทธิ') ,0, 0 , 'L');
$pdf->Cell(10, 5, iconv( 'UTF-8','TIS-620',number_format($rh->slip_netamt,2)) ,0, 0 , 'R');
$pdfname = "PDF/".$shortyear.$slip_month."_".trim($slip_emcode)."_".trim($rh->slip_emname).".pdf";
$upd = "UPDATE slip_header SET slip_pdf='".$pdfname."' WHERE slip_id = '".$rh->slip_id."' ";
$rsd = sqlsrv_query($ConnDB, $upd);
$pdf->Output(iconv( 'UTF-8','TIS-620', $pdfname ),"F");
if(!$rsd){
$result[] = array("ERR" => "Fail".$upd);
}
}
// $pdf->Output();
//I ดู PDF ผ่าน Browser
//D เมื่อมีการรันหน้า page จะมันจะสร้างเอกสาร PDF แล้วโหลดลงเครื่องผู้ใช้งาน อยู่ใน Folder Download
//F เอาไฟล์ PDF ไปวางที่ Folder ที่เราต้องการ
//S ส่งคืนเอกสาร
$json = array('result' => $result );
echo json_encode($json, JSON_UNESCAPED_UNICODE);
function CallMonth($slipmonth){
switch($slipmonth){
case "01" : $month="มกราคม"; break;
case "02" : $month="กุมภาพันธ์"; break;
case "03" : $month="มีนาคม"; break;
case "04" : $month="เมษายน"; break;
case "05" : $month="พฤษภาคม"; break;
case "06" : $month="มิถุนายน"; break;
case "07" : $month="กรกฎาคม"; break;
case "08" : $month="สิงหาคม"; break;
case "09" : $month="กันยายน"; break;
case "10" : $month="ตุลาคม"; break;
case "11" : $month="พฤศจิกายน"; break;
case "12" : $month="ธันวาคม"; break;
}
return $month;
}
?>]]>font.php
<![CDATA[<?php
require('makefont/makefont.php'); // แทรกไฟล์สร้างฟอนต์จากโฟลเดอร์ makefont มาใช้งาน
MakeFont('C:\inetpub\wwwroot\lekjew\font\THSarabunNew.ttf','cp874'); // MakeFont('พาธของฟอนต์','Encode ของฟอนต์');
MakeFont('C:\inetpub\wwwroot\lekjew\font\THSarabunNew Bold.ttf','cp874'); // MakeFont('พาธของฟอนต์','Encode ของฟอนต์');
MakeFont('C:\inetpub\wwwroot\lekjew\font\THSarabunNew BoldItalic.ttf','cp874'); // MakeFont('พาธของฟอนต์','Encode ของฟอนต์');
MakeFont('C:\inetpub\wwwroot\lekjew\font\THSarabunNew Italic.ttf','cp874'); // MakeFont('พาธของฟอนต์','Encode ของฟอนต์');
?>]]>