?>
</td>
<td align="left"><?php
echo $val2['postcode'];
?>
</td>
<td align="left"><?php
echo $val2['Ref1'];
?>
</td>
<td align="left"><?php
echo $val2['Ref2'];
?>
</td>
<td align="left"><?php
echo Thaidate::date($val2['receiptdate'], 'DD MM YYYY');
?>
</td>
<td align="right"><?php
echo $val2['price'];
?>
</td>
<td align="center">
<?php
echo $val2['seatNo'];
?>
</td>
</tr>
<?php
}
<td class="fronttext"> เป็นชื่อคนปัจจุบัน </td>
</tr>
<?php
foreach ($changelist as $_changelist) {
//master trainee prefix
if ($_changelist['mprefix'] == 7) {
$mprefix = $_changelist['mpreother'];
} else {
$mprefix = $_changelist['mtitle'];
}
//Change Date
$cDate = $_changelist['changedatetime'];
if ($cDate == "0000-00-00 00:00:00" or $cDate == "0000-00-00" or $cDate == "") {
$changeDate = "ไม่ได้ระบุวันที่";
} else {
$changeDate = Thaidate::date($cDate, "DD MM YYYY");
}
//master trainee name
$mastertrainee = $mprefix . " " . $_changelist['mname'] . " " . $_changelist['mlastname'];
//Changed trainee name
if ($_changelist['tcprefix'] == 7) {
$tcprefix = $_changelist['tcpreother'];
} else {
$tcprefix = $_changelist['tctitle'];
}
$changetrainee = $tcprefix . " " . $_changelist['name'] . " " . $_changelist['lastname'];
?>
<tr valign="top" bgcolor="#FFFFFF">
<td><?php
echo $changeDate;
?>
<td align="left" height="30"><p class="fronttext">ระยะเวลาการอบรม </p></td>
<td align="left" height="30"><p class="fronttext"> หัวข้อหลักสูตร </p></td>
<td align="center" height="30"><p class="fronttext"> เปิดลงทะเบียน</p></td>
<td align="center" height="30"><p class="fronttext"> ลงทะเบียน</p></td>
<td align="center" height="30"><p class="fronttext">พิมพ์ใบประกาศนียบัตร </p></td>
</tr>
<?php
$i = 1;
foreach ($data as $val) {
$sDate = $val['startdate'];
$eDate = $val['enddate'];
if ($sDate == "0000-00-00 00:00:00" or $sDate == "0000-00-00" or $sDate == "" or $eDate == "0000-00-00 00:00:00" or $eDate == "0000-00-00" or $eDate == "") {
$date = "ไม่ได้ระบุวันที่อบรม";
} else {
$scDate = Thaidate::date($sDate, "DD MM YY");
$ecDate = Thaidate::date($eDate, "DD MM YY");
$date = $scDate . '-' . $ecDate;
}
$course = $val['coursecode'] . ':' . $val['coursename'];
$generation = $val['generation'];
$traninees = $val['limittrainees'];
//$registration = $val['CntReg'];
if (is_null($val['CntReg'])) {
$registration = 0;
} else {
$registration = $val['CntReg'];
}
$courseID = $val['courseID'];
if ($i % 2 == 0) {
$bgcolor = '#eeeeee';
} else {
function getConfirmQueue($regisID = 0)
{
header('Content-type: text/html; charset=utf-8');
$this->load->model('register/user_m', 'user_m');
$res = $this->user_m->getBillingInfo($regisID);
$data = array();
$total = 1;
$data = $res[0];
$content = file_get_contents('template_email/confirmqueuemail.htm');
$content = str_replace('<!--name-->', $data['name'] . ' ' . $data['lastname'], $content);
$content = str_replace('<!--regDate-->', Thaidate::date($data['registerdatetime'], 'DD MM YYYY'), $content);
$content = str_replace('<!--period-->', Thaidate::date($data['startdate'], 'DD MM YYYY') . ' - ' . Thaidate::date($data['enddate'], 'DD MM YYYY'), $content);
$content = str_replace('<!--place-->', $data['place'], $content);
$content = str_replace('<!--course_name-->', $data['coursename'] . '(' . $data['coursecode'] . ')', $content);
if ((int) $data['registerBy'] == 3) {
$representive = $this->user_m->getRepresentive($regisID);
$total = count($representive);
$arrGroup = array();
foreach ($representive as $key => $val) {
$arrGroup[] = ' คุณ ' . $val['name'] . ' ' . $val['lastname'];
}
$groupName = implode(',', $arrGroup);
$content = str_replace('<!--group_name-->', $groupName, $content);
}
$content = str_replace('<!--total-->', $total, $content);
return $content;
}
<title><?php
echo setting::$WINDOW_TITLE;
?>
</title>
</head>
<body><br/>
<?php
if (!empty($data)) {
//$receiptname = trim($data[0]['name']);
$receiptname = str_replace("อื่นๆ ", "", trim($data[0]['name']));
$receiptaddr = $data[0]['address'];
$ref1 = $data[0]['billing_ref1'];
$ref2 = $data[0]['billing_ref2'];
$pID = $data[0]['paymentid'];
$receipt_date = Thaidate::date($data[0]['receipt_date'], "DD MM YYYY");
} else {
$receiptname = "";
$receiptaddr = "";
$ref1 = "";
$ref2 = "";
$pID = 0;
$receipt_date = "";
}
?>
<table border="0" cellspacing="1" cellpadding="1">
<tr valign="middle" align="left">
<td class="info"><font class="title">สถานะการชำระเงิน</font></td>
</tr>
<tr valign="middle" align="left">
<td class="info"><font class="bottomtext">วันที่รับชำระ : </font><?php
width="438" height="70" border="0"></td>
<td align="right"><br>
<h1>Report : ออกใบเสร็จ</h1>
<?php
if (!empty($coursename)) {
?>
<h3><?php
echo $coursename;
?>
</h3>
<?php
}
?>
พิมพ์วันที่
<?php
echo Thaidate::date(date("Y-m-d H:i:s"), 'DD MM YYYY');
?>
<?php
if (!empty($courseID)) {
$cID = $courseID;
$typeID = $typeID;
if ($typeID == 1) {
$typename = "สำหรับออกใบเสร็จในนามรายบุคคล";
} elseif ($typeID == 3) {
$typename = "สำหรับออกใบเสร็จในนามโรงพยาบาล";
} else {
$typename = "สำหรับออกใบเสร็จ";
}
} else {
$cID = 0;
$typeID = 0;
<div id="leftcolumn1"> <div id="imgdetails"></div> <div id="header">รายละเอียดการประชุมและการอบรม </div> <br> <div id="warningtop"><?php echo $data['coursecode'] . ":" . $data['coursename'] . " รุ่น " . $data['generation']; ?> </div> <br> <font class="smtext">วันที่อบรม: </font> <?php echo Thaidate::date($data['startdate'], 'DD MM YYYY'); ?> ถึง: <?php echo Thaidate::date($data['enddate'], 'DD MM YYYY'); ?> <br> <font class="smtext">ระยะเวลาการอบรม </font> <?php echo $data['days']; ?> วัน <br> <font class="smtext">จำนวนเปิดลงทะเบียน </font> <?php echo $data['limittrainees']; ?> คน <br> <font class="smtext">จำนวนคนลงทะเบียนแล้ว </font> <?php echo $C_reg; ?> คน <br>
function remind()
{
header('Content-type: text/html; charset=utf-8');
$this->load->model('register/mail_m', 'mail_m');
$res = $this->mail_m->getListRemind();
foreach ($res as $val) {
$fullname = $val['name'] . ' ' . $val['lastname'];
$dateregist = Thaidate::date($val['registerdatetime'], 'DD MM YYYY');
$dateregistend = Thaidate::date(date('Y-m-d H:i:s'), 'DD MM YYYY');
$course = $val['coursename'] . '(' . $val['coursecode'] . ')';
$coursedate = Thaidate::date($val['startdate'], 'DD MM YYYY') . ' - ' . Thaidate::date($val['enddate'], 'DD MM YYYY');
$courseplace = $val['place'];
if ($val['refType'] == '0') {
$total = 1;
$list = '';
} else {
$dataRepresentative = util::getRepresentiveList($val['registrationID']);
$total = count($dataRepresentative);
$listName = array();
foreach ($dataRepresentative as $keyP => $valP) {
$listName[] = ' ' . $valP['name'] . ' ' . $valP['lastname'];
}
$list = implode(',', $listName);
}
// email
$mailFrom = '*****@*****.**';
$mailTo = $val['email'];
$subject = 'แจ้งเตือนการชำระเงิน';
$content = $this->remindContent($fullname, $dateregist, $dateregistend, $course, $coursedate, $courseplace, $total, $list);
//echo $content;
util::sendEmail($mailFrom, array($mailTo), $subject, $content, 'html');
}
exit;
}
//register date
$regDate = $reg['registerdatetime'];
if ($regDate == "0000-00-00 00:00:00" or $regDate == "0000-00-00" or $regDate == "") {
$registeredDate = "ยังไม่ได้ลงทะเบียน";
} else {
$registeredDate = Thaidate::date($regDate, "DD MM YY");
}
//Payment
if ($reg['IsPaid'] == 1) {
//payment date
$pDate = $reg['receipt_date'];
if ($pDate == "0000-00-00 00:00:00" or $pDate == "0000-00-00" or $pDate == "") {
//$paiddate = "รอชำระเงิน";
$paiddate = "-";
} else {
$paiddate = Thaidate::date($pDate, "DD MM YY");
}
} else {
//$paiddate = "รอชำระเงิน";
$paiddate = "-";
}
//Status
$bgWait = "";
if ($reg['IsPaid'] == 1) {
$status = "ชำระเงินแล้ว";
} else {
if ($reg['IsPaid'] == 2 || $reg['IsPaid'] == 0) {
$status = "รอการชำระ";
$bgWait = "background-color:#FA9090";
} else {
if ($reg['IsPaid'] == 4) {
<?php
$rowC = 0;
foreach ($list_course as $keyC => $valC) {
$rowC++;
?>
<tr valign="top">
<td align="left" class="tab"><?php
echo $rowC;
?>
</td>
<td align="left" class="info" height="30"><?php
echo Thaidate::date($valC['startdate'], "DD MM YYYY");
?>
- <?php
echo Thaidate::date($valC['enddate'], "DD MM YYYY");
?>
</td>
<td align="left" class="info"><?php
echo $valC['coursecode'];
?>
: <?php
echo $valC['coursename'];
?>
รุ่นที่ <?php
echo $valC['generation'];
?>
</td>
<td align="center" class="info"><?php
echo $valC['typename'];
?>
<div id="space"></div>
<?php
$last_row = count($course);
$rowCourse = 0;
foreach ($course as $key => $val) {
$rowCourse++;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td align="left" width="10"><img src="images/butt_brown.gif" width="6" height="12" border="0"></td>
<td align="left">ลงทะเบียนได้ตั้งแต่วันที่<br>
<?php
echo Thaidate::date($val['registstartdate'], 'DD MM YYYY') . ' - ' . Thaidate::date($val['registenddate'], 'DD MM YYYY');
?>
<br>
<a href="<?php
echo setting::$BASE_URL . '/member/course_detail/' . $val['courseID'];
?>
"><?php
echo $val['coursecode'] . ': ' . $val['coursename'];
?>
</a></td>
</tr>
</table>
<?php
if ($last_row != $rowCourse) {
?>
<div class="hr dotted"></div>
<tr valign="top" bgcolor="#0062a9">
<td align="left"><img src="images/blank.gif" alt="" width="150" height="1"
border="0"></td>
<td align="left"><img src="images/blank.gif" alt="" width="400" height="1"
border="0"></td>
<td align="left"><img src="images/blank.gif" alt="" width="150" height="1"
border="0"></td>
</tr>
<tr valign="top">
<td align="left" class="tab">ระยะเวลาการอบรม</td>
<td align="left" class="tab">หัวข้อหลักสูตร</td>
<td align="center" class="tab">ดูรายละเอียด</td>
</tr>
<?php
foreach ($list_course as $key => $val) {
$date = Thaidate::date($val['startdate'], 'DD MM') . ' - ' . Thaidate::date($val['enddate'], 'DD MM YYYY');
$courseName = $val['coursecode'] . ': ' . $val['coursename'];
$gen = $val['generation'];
?>
<tr valign="top">
<td align="left" class="info"><?php
echo $date;
?>
</td>
<td align="left" class="info"><?php
echo $courseName;
?>
<br/>
รุ่นที่ <?php
$gen;
?>
<strong>ระยะเวลาการอบรม</strong>
<?php
echo Thaidate::date($last_course['startdate'], "DD MM YYYY");
?>
- <?php
echo Thaidate::date($last_course['enddate'], "DD MM YYYY");
?>
<br/>
<strong>วันที่รับสมัคร</strong>
<?php
echo Thaidate::date($last_course['registstartdate'], "DD MM YYYY");
?>
- <?php
echo Thaidate::date($last_course['registenddate'], "DD MM YYYY");
?>
<br/>
<strong>วิทยากร</strong>
<?php
echo $last_course['speaker'];
?>
<br/>
<strong>สถานที่ </strong>
<?php
echo $last_course['place'];
?>
<br/>
<strong>ค่าลงทะเบียน</strong>
ท่านละ <?php
echo $last_course['price'];
<td align="left" class="fronttext">no.</td>
<td align="left" class="fronttext" height="30"> ระยะเวลา</td>
<td align="left" class="fronttext"> หัวข้อหลักสูตร</td>
<!-- <td align="center" class="fronttext"> ประเภท<br/>การสมัคร</td>-->
</tr>
<?php
$rowC = 0;
foreach ($list_course as $keyC => $valC) {
$rowC++;
//Course Date
$sDate = $valC['startdate'];
$eDate = $valC['enddate'];
if ($sDate == "0000-00-00 00:00:00" or $sDate == "0000-00-00" or $sDate == "" or $eDate == "0000-00-00 00:00:00" or $eDate == "0000-00-00" or $eDate == "") {
$CourseDate = "ไม่ได้ระบุวันที่อบรม";
} else {
$CourseDate = Thaidate::date($sDate, "DD MM YYYY") . ' - ' . Thaidate::date($eDate, "DD MM YYYY");
}
?>
<tr valign="top">
<td align="left" bgcolor="#a0cdf9"><p class="fronttext"><?php
echo $rowC;
?>
</p></td>
<td align="left" class="info" height="30"><?php
echo $CourseDate;
?>
</td>
<td align="left" class="info"><?php
echo $valC['coursecode'];
?>
: <?php
echo Thaidate::date($val['registenddate'], 'DD MM YYYY');
?>
<br/>
<strong> วันที่สมัคร </strong><?php
echo Thaidate::date($val['registerdatetime'], 'DD MM YYYY');
?>
<br/>
<strong> สถานะการชำระเงิน: </strong>
<?php
if ($val['IsPaid'] == 1) {
//echo 'ชำระเรียบร้อย | ใบเสร็จ ';
echo '<font color="#FF0000"><strong>ชำระเงินเรียบร้อยแล้ว</strong> </font> <br> <strong>ได้รับเงินวันที่:</strong> ';
//echo $val['coursecode']; else:
echo Thaidate::date($val['paiddatetime'], 'DD MM YYYY');
if ($val['registerBy'] == 1) {
$dataSeats = util::getSeat($val['registrationID']);
if (count($dataSeats) > 0) {
// var_dump($dataSeats);
echo ' <br><strong>เลขที่นั่ง: </strong> ' . $dataSeats[0]['seatNo'];
}
} else {
$dataRepresent1 = util::getRepresentiveList($val['registrationID']);
$arrSeat = array();
foreach ($dataRepresent1 as $k1 => $v1) {
$dataSeats1 = util::getSeat($v1['registrationID']);
$arrSeat[] = $dataSeats1[0]['seatNo'];
}
$txtSeat = implode(", ", $arrSeat);
echo ' <br><strong>เลขที่นั่ง: </strong> ' . $txtSeat;
function getBilling($regisID = 0)
{
header('Content-type: text/html; charset=utf-8');
$amount = 0;
$this->load->model('register/user_m', 'user_m');
$res = $this->user_m->getBillingInfo($regisID);
$data = array();
$data = $res[0];
if ((int) $data['registerBy'] == 3) {
$representive = $this->user_m->getRepresentive($regisID);
$price = (double) $data['price'];
$sum_rep = count($representive);
$amount = (double) ($price * $sum_rep);
$data['sum_register'] = $sum_rep;
} else {
$amount = (double) $data['price'];
$data['sum_register'] = '1';
}
$price_format = (double) $data['price'];
$data['amount'] = number_format($amount, 2);
$data['price_format'] = number_format($price_format, 2);
$data['txt_price'] = util::num2thai($amount);
//$data['ref1'] = '1' . str_pad($data['traineeID'], 5, '0', STR_PAD_LEFT);
$data['ref1'] = str_pad($data['traineeID'], 5, '0', STR_PAD_LEFT);
$date = explode(' ', $data['startdate']);
$date = explode('-', $date[0]);
$month = $date[1];
$year = (int) $date[0] + 543;
//$data['ref2'] = substr($data['coursecode'], 2, 3) . substr($data['generation'], 0, 1) . $month . substr($year, 2, 2) . str_pad($data['registrationID'], 4, '0', STR_PAD_LEFT);
$data['ref2'] = substr($data['coursecode'], 2, 3) . substr($data['generation'], 0, 1) . str_pad($data['registrationID'], 5, '0', STR_PAD_LEFT);
// var_dump($data);
// exit;
$content = file_get_contents('template_email/bill.html');
$content = str_replace('<!--date-->', date('d/m/Y'), $content);
$content = str_replace('<!--company_id-->', $data['hospitalID'], $content);
//$content = str_replace('<!--name-->', $data['name'] . ' ' . $data['lastname'], $content);
$content = str_replace('<!--name-->', $data['receipt_name'], $content);
$content = str_replace('<!--ref1-->', $data['ref1'], $content);
$content = str_replace('<!--ref2-->', $data['ref2'], $content);
$content = str_replace('<!--amount-->', $data['amount'], $content);
$content = str_replace('<!--txt_price-->', $data['txt_price'], $content);
$content = str_replace('<!--sum_register-->', $data['sum_register'], $content);
$content = str_replace('<!--period-->', Thaidate::date($data['startdate'], 'DD MM YYYY') . ' - ' . Thaidate::date($data['enddate'], 'DD MM YYYY'), $content);
$content = str_replace('<!--place-->', $data['place'], $content);
$content = str_replace('<!--course_name-->', $data['coursename'] . '(' . $data['coursecode'] . ')', $content);
$content = str_replace('<!--course_day-->', $data['days'], $content);
$content = str_replace('<!--price-->', $data['price_format'], $content);
$content = str_replace('<!--dd-->', date('d'), $content);
$content = str_replace('<!--mm-->', Thaidate::thaiMonth(date('n')), $content);
$content = str_replace('<!--yy-->', (int) date('Y') + 543, $content);
// update ref no.
$this->user_m->updateRegistrationRefNo($data['registrationID'], $data['ref1'], $data['ref2']);
return $content;
}
$bg = false;
foreach ($data as $key => $val) {
if ($bg) {
$bgcolor = 'bgcolor="#eeeeee"';
$bg = false;
} else {
$bgcolor = '';
$bg = true;
}
?>
<tr valign="top" <?php
echo $bgcolor;
?>
>
<td align="left" class="info"><?php
echo Thaidate::date($val['registstartdate'], "DD MM YYYY") . ' - ' . Thaidate::date($val['registenddate'], "DD MM YYYY");
?>
</td>
<td align="left" class="info"> <?php
echo $val['coursecode'] . ': ' . $val['coursename'];
?>
|
รุ่นที่ <?php
echo $val['generation'];
?>
</td>
<td align="center" class="info"><a href="<?php
echo setting::$BASE_URL . '/member/course_detail/' . $val['courseID'];
?>
"><img
src="images/view.gif" width="92" height="21" border="0"/></a></td>
function getemailcontent($regID, $refID, $rType, $method)
{
header('Content-type: text/html; charset=utf-8');
$this->load->model('register/course_m', 'course_m');
$course = $this->course_m->getCourseDetails($regID);
$reglist = $this->course_m->getTraineesDetails($regID, $rType, $refID);
$data = array();
$data = $course[0];
$data['sum_register'] = count($reglist);
$registrationlist = "";
$i = 1;
foreach ($reglist as $val) {
$registrationlist .= $i . ". " . $val['name'] . " " . $val['lastname'] . "<br />";
$i++;
}
if ($method == "del") {
$content = file_get_contents('template_email/cancel.htm');
} else {
$content = file_get_contents('template_email/requeue.htm');
}
$content = str_replace('<!--name-->', $data['name'] . ' ' . $data['lastname'], $content);
$content = str_replace('<!--registrationdate-->', Thaidate::date($data['registerdatetime'], 'DD MM YYYY'), $content);
$content = str_replace('<!--duedate-->', Thaidate::date($data['duedate'], 'DD MM YYYY'), $content);
$content = str_replace('<!--course_name-->', $data['coursename'] . '(' . $data['coursecode'] . ')', $content);
$content = str_replace('<!--period-->', Thaidate::date($data['startdate'], 'DD MM YYYY') . ' - ' . Thaidate::date($data['enddate'], 'DD MM YYYY'), $content);
$content = str_replace('<!--place-->', $data['place'], $content);
$content = str_replace('<!--sum_register-->', $data['sum_register'], $content);
$content = str_replace('<!--registrationlist-->', $registrationlist, $content);
return $content;
}
<div id="warningtop">รายละเอียดการสมัครครั้งนี้
<br/>
ชื่อการอบรม <?php
echo $course['coursename'];
?>
รุ่น <?php
echo $course['generation'];
?>
<br/>
วันที่อบรม: <?php
echo Thaidate::date($course['startdate'], "DD MM YYYY");
?>
ถึง: : <?php
echo Thaidate::date($course['enddate'], "DD MM YYYY");
?>
<br/>
ระยะเวลาการอบรม <?php
echo $course['days'];
?>
วัน
<br/>
ค่าลงทะเบียน <?php
echo $course['price'];
?>
บาท
</div>
<br>
</table>
<!--article-->
<table border="0" cellspacing="2" cellpadding="2" align="center">
<tr>
<td align="left" class="info" colspan="2">
<table border="0" cellspacing="3" cellpadding="3">
<tr valign="middle">
<td class="info">
<strong>วันที่อบรม: </strong>
</td>
<td colspan="2"><?php
echo Thaidate::date($data['startdate'], "DD MM YYYY");
?>
<strong>ถึง:</strong> <?php
echo Thaidate::date($data['enddate'], "DD MM YYYY");
?>
</td>
<td>
</td>
</tr>
<tr valign="middle">
<td class="info"><strong>ระยะเวลาการอบรม</strong></td>
<td colspan="3"><?php
echo $data['days'];
?>
วัน</td>
</tr>
<tr valign="middle">
<td class="info"><strong>จำนวนเปิดลงทะเบียน</strong></td>
