public function printpdf($year, $month)
{
$this->load->helper('pdf_helper');
$query_now_salary = $this->salarypay->get_detail_by_year_and_month($this->user_id, $year, $month);
$data = array();
$data["emp_detail"] = getEmployeeDetail($this->emp_id);
$data["month"] = $month;
$data["month_name"] = get_month_name_thai($month);
$data["year"] = $year;
$data["year_thai"] = year_thai($year);
$data["query_now_salary"] = $query_now_salary->row_array();
$this->load->view('report/Usersalaryprint', $data);
}
public function salary_printpdf($emp_id, $year, $month)
{
$this->load->model("Salary_pay_log_model");
$this->load->helper('pdf_helper');
$data = array();
$data["emp_detail"] = getEmployeeDetail($emp_id);
$data["month"] = $month;
$data["month_name"] = get_month_name_thai($month);
$data["year"] = $year;
$data["year_thai"] = year_thai($year);
$query_now_salary = $this->Salary_pay_log_model->get_detail_by_year_and_month($data['emp_detail']['UserID'], $year, $month);
$data["query_now_salary"] = $query_now_salary->row_array();
$this->load->view('report/Usersalaryprint', $data);
}
?>
</div>
<div class="col s4 m4 l4">แผนก<?php
echo $emp_detail["DepartmentName"];
?>
</div>
<div class="col s4 m4 l4">ตำแหน่ง<?php
echo $emp_detail["PositionName"];
?>
</div>
</div>
<div style="padding: 1px;-color: cadetblue;margin-top: 1%;margin-bottom: 0;">
</div>
<div class="card-panel center-align">
<a href="javascript:void(0);" class="waves-effect waves-teal btn-flat">ปี <?php
echo year_thai($query_pay["otpay_year"]);
?>
</a>
<a href="javascript:void(0);" class="waves-effect waves-teal btn-flat">เดือน <?php
echo get_month_name_thai($query_pay["otpay_month"]);
?>
</a>
<a href="javascript:void(0);" class="waves-effect waves-teal btn-flat">สรุปจำนวนชั่วโมง <?php
echo $query_pay["otpay_hour"];
?>
ชั่วโมง</a>
<a href="javascript:void(0);" class="waves-effect waves-teal btn-flat">สรุปรายได้ <?php
echo $query_pay["otpay_money"];
?>
บาท</a>
</div>
public function printpdf($ot_id)
{
$this->load->helper('pdf_helper');
$query = $this->ot->get_detail_by_id($ot_id);
$query = $query->row_array();
$query_log = $this->otlog->get_list_only_approve($ot_id);
$query_log = $query_log->result_array();
$date = explode("-", $query["wot_date"]);
$month = $date[1];
$year = $date[0];
$day = $date[2];
$data = array();
$data["emp_detail"] = getEmployeeDetailByUserID($query["wot_request_by"]);
//date
$data["day"] = $day;
$data["month"] = $month;
$data["month_name"] = get_month_name_thai($month);
$data["year"] = $year;
$data["year_thai"] = year_thai($year);
//created date
$date1 = explode(" ", $query["wot_request_date"]);
$date = explode("-", $date1[0]);
$month = $date[1];
$year = $date[0];
$day = $date[2];
$data["created_day"] = $day;
$data["created_month"] = $month;
$data["created_month_name"] = get_month_name_thai($month);
$data["created_year"] = $year;
$data["created_year_thai"] = year_thai($year);
$data["query"] = $query;
$data["query_log"] = $query_log;
$this->load->view('report/Overtimedetail', $data);
}
</div>
<div id="modal<?php
echo $i;
?>
" class="modal bottom-sheet history-study">
<div class="modal-content">
<h4><?php
echo $query_history_study[$i]["ehs_academy"];
?>
</h4>
<p>
ปีการศึกษา <?php
echo year_thai($query_history_study[$i]["ehs_year_start"]);
?>
- <?php
echo year_thai($query_history_study[$i]["ehs_year_end"]);
?>
| สาขา<?php
echo $query_history_study[$i]["ehs_major"];
?>
</p>
<p>วุฒิการศึกษา : <?php
echo $query_history_study[$i]["ehs_degree"];
?>
</p>
<p>คณะ : <?php
echo $query_history_study[$i]["ehs_bachelor"];
?>
</p>
<p>เกรดเฉลี่ย : <?php
echo $query_history_study[$i]["ehs_grade_avg"];
function date_thai_format_no_time_full_from_db($date)
{
//date format yyyy-mm-dd hh:ss:ii
//to dd/mm/yyyy
$newDate = '';
if ($date != '0000-00-00 00:00:00') {
$date_time = explode(' ', $date);
$date = explode('-', $date_time[0]);
$time = $date_time[1];
$day = $date[2];
$month = $date[1];
$year = $date[0];
$year_thai = year_thai($year);
$month_name = get_month_name_thai($month);
$newDate = $day . " " . $month_name . " " . $year_thai;
}
return $newDate;
}
public function printpdf($year, $month, $emp_id = "")
{
$this->load->helper('pdf_helper');
if ($emp_id !== "") {
//check can see this profile is_your_headman or is_hr
$user_detail = getEmployeeDetail($emp_id);
$checker = FALSE;
$headman_level = 0;
list($checker, $headman_level) = is_your_headman($user_detail["UserID"], $this->user_id);
if ($checker == TRUE || is_hr()) {
$this->emp_id = $emp_id;
$this->user_id = $user_detail["UserID"];
} else {
$emp_id = "";
}
}
$query = $this->worktime->get_list_by_year_and_month($this->user_id, $year, $month);
$data = array();
$data["emp_detail"] = getEmployeeDetail($this->emp_id);
$data["month"] = $month;
$data["month_name"] = get_month_name_thai($month);
$data["year"] = $year;
$data["year_thai"] = year_thai($year);
$data["query"] = $query->result_array();
$this->load->view('report/Worktime', $data);
}
<th>ปี</th>
<th>เดือน</th>
<th>ลูกทีม</th>
<th>สรุปจำนวนชั่วโมง</th>
<th>สรุปรายได้</th>
</tr>
</thead>
<tbody>
<?php
$sum_ot = 0;
$sum_all_hour = 0;
foreach ($query as $row) {
?>
<tr>
<td><?php
echo year_thai($row["otpay_year"]);
?>
</td>
<td><?php
echo get_month_name_thai($row["otpay_month"]);
?>
</td>
<td><?php
echo $row["empid"] . " - " . $row["EmpFullnameThai"];
?>
</td>
<td><?php
echo $row["otpay_hour"];
?>
</td>
<td><?php
<th rowspan="2" class="center-align">จำนวนเงิน</th>
<th colspan="2" class="center-align">ข้อมูลการจ่ายโบนัส</th>
</tr>
<tr>
<th class="center-align">งวดที่/เดือน</th>
<th class="center-align">จำนวนเงิน</th>
</tr>
</thead>
<tbody>
<!-- bonus data -->
<?php
foreach ($history as $row) {
?>
<tr>
<td><?php
echo year_thai($row['bonus_year']);
?>
</td>
<td><?php
echo $row['bonus_money'];
?>
</td>
<td>งวดที่ <?php
echo $row['bp_period'];
?>
เดือน<?php
echo get_month_name_thai($row['bp_month']);
?>
</td>
<td><?php
echo $row['bp_money'];
<thead>
<tr>
<th>ปี</th>
<th>เดือน</th>
<th>ชื่อรายการ</th>
<th>จำนวนเงิน</th>
<th>วันที่ทำรายการ</th>
</tr>
</thead>
<tbody>
<?php
foreach ($query_log as $row) {
?>
<tr>
<td><?php
echo year_thai($row["SMMYear"]);
?>
</td>
<td><?php
echo get_month_name_thai($row["SMMMonth"]);
?>
</td>
<td><?php
echo $row["SMMTopic"];
?>
</td>
<td><?php
echo $row["SMMMoney"];
?>
</td>
<td><?php
?>
บาท
</h5>
<?php
if ($query_salary["sapay_salary"] == "") {
?>
<br>
<h5 class="header">คุณยังไม่มีข้อมูลรายได้ประจำเดือน</h5>
<?php
} else {
?>
<h4 class="header">รายได้ประจำเดือน <?php
echo get_month_name_thai($query_salary["sapay_month"]);
?>
ปี <?php
echo year_thai($query_salary["sapay_year"]);
?>
</h4>
<br>
<div class="row">
<div class="col s12 m10 offset-m1 l8 offset-l2">
<table class="salary_present">
<tbody>
<tr>
<td>เงินเดือน</td>
<td><?php
echo $query_salary["sapay_salary"];
?>
</td>
<td>-</td>
</tr>