?> </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>