<div class="right">
<a href="?p=newsdetail&id=<?php
echo $r['id'];
?>
"><?php
echo $r['judul'];
?>
</a>
<span class="summary">
<?php
echo getExcerpt(html_entities_decode($r['content']), 50);
?>
</span>
<small><?php
echo showDateTime($r['createdate']);
?>
</small>
</div>
<div class="clr"></div>
</div>
<?php
}
}
?>
<div class="clr"></div>
<div class="paging clr">
<?php
echo $pagination;
?>
function sendmail_confirm($id)
{
$doSql = "SELECT a.*, b.nama_lengkap `member`, b.email,\n\t\tb.alamat, b.kota, b.kode_pos, b.telepon\n\t\tFROM `order` a\n\t\tLEFT JOIN member b ON b.id=a.member_id\n\t\tWHERE a.id='" . $id . "'";
$doQry = mysql_query($doSql);
$r = mysql_fetch_array($doQry);
$content = '
<p>Pembayaran anda telah kami terima, kami akan segera memproses pesanan anda<br>
dan mengirimkannya ke alamat anda dalam waktu 2x24 jam</p><br>
<p><strong>Detail Order</strong></p><br>
<table width="700" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="226">No. Order</td>
<td width="8">:</td>
<td width="672">' . $r['no_order'] . '</td>
</tr>
<tr>
<td>Tanggal Order</td>
<td>:</td>
<td>' . showDateTime($r['tgl_order']) . '</td>
</tr>
<tr>
<td width="226">Pembeli / Member</td>
<td width="8">:</td>
<td width="672">' . $r['member'] . '</td>
</tr>
<tr>
<td width="226">Alamat Pengiriman</td>
<td width="8">:</td>
<td width="672">' . $r['alamat'] . '<br>' . $r['kota'] . ' ' . $r['kode_pos'] . '</td>
</tr>
<tr>
<td width="226">Contact</td>
<td width="8">:</td>
<td width="672">' . $r['telepon'] . '</td>
</tr>
</table><hr>
<table width="700" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC" id="tableDetail">
<thead>
<tr>
<td width="111" align="center" bgcolor="#EEEEEE">Nama Produk</td>
<td width="105" align="center" bgcolor="#EEEEEE">Pilihan</td>
<td width="81" align="right" bgcolor="#EEEEEE">Harga</td>
<td width="55" align="center" bgcolor="#EEEEEE"> Disc (%)</td>
<td width="79" align="right" bgcolor="#EEEEEE">Total</td>
<td width="46" align="center" bgcolor="#EEEEEE">Qty</td>
<td width="90" align="right" bgcolor="#EEEEEE">Sub Total</td>
</tr>
</thead>
<tbody>';
$dQry = "SELECT a.*, b.nama, b.gambar,\n\t\t(SELECT c.nama FROM produk_atribut c WHERE c.id=a.atribut_id) pilihan \n\t\tFROM order_detail a \n\t\tLEFT JOIN produk b ON b.id=a.produk_id\n\t\tWHERE a.order_id='" . $r['id'] . "'";
$dRes = mysql_query($dQry);
while ($row = mysql_fetch_array($dRes)) {
$vTotal = $row['harga'] - $row['diskon'] / 100 * $row['harga'];
$content .= '
<tr>
<td align="center" bgcolor="#FFFFFF">' . $row['nama'] . '</td>
<td align="center" bgcolor="#FFFFFF">' . ($row['pilihan'] == '' ? '-' : $row['pilihan']) . '</td>
<td align="right" bgcolor="#FFFFFF">' . number_format($row['harga']) . '</td>
<td align="center" bgcolor="#FFFFFF">' . $row['diskon'] . '%</td>
<td align="right" bgcolor="#FFFFFF">' . number_format($vTotal) . '</td>
<td align="center" bgcolor="#FFFFFF">' . $row['qty'] . '</td>
<td align="right" bgcolor="#FFFFFF">' . number_format($row['subtotal']) . '</td>
</tr>';
}
$content .= '
<tr>
<td align="left" colspan="6" bgcolor="#F5F5F5">Total Order</td>
<td align="right" bgcolor="#F5F5F5">' . number_format($r['total_order']) . '</td>
</tr>
</tbody>
</table><br>
<p>Terima Kasih atas kepercayaan anda pada kami.</p>
<p><strong>W2F Catering</strong></p>
<p> </p>';
$mail = new PHPMailer();
$mail->SMTPKeepAlive = true;
$mail->Mailer = "smtp";
$mail->IsSMTP();
// telling the class to use SMTP
$mail->CharSet = 'utf-8';
$mail->SMTPDebug = 2;
$mail->SMTPAuth = true;
$mail->SMTPSecure = "tls";
$mail->Host = "smtp.gmail.com";
$mail->Port = 587;
$mail->Username = gmailaccount;
$mail->Password = gmailpassword;
$mail->Subject = $r['no_order'] . " Pembayaran diterima - W2F Catering";
$mail->MsgHTML($content);
$mail->setFrom('*****@*****.**', 'W2F Catering');
$mail->addReplyTo('*****@*****.**', 'W2F Catering');
$mail->AddAddress($r['email']);
if (!$mail->Send()) {
return false;
die('Mailer error: ' . $mail->ErrorInfo);
} else {
return true;
}
}
<td width="213" align="left" valign="top"><?php
echo $r['no_order'];
?>
</td>
<td width="123" align="left" valign="top">Nama Member</td>
<td width="3" align="left" valign="top">:</td>
<td width="341" align="left" valign="top"><?php
echo $r['nama_lengkap'];
?>
</td>
</tr>
<tr>
<td align="left" valign="top">Tanggal Order</td>
<td align="left" valign="top">:</td>
<td align="left" valign="top"><?php
echo showDateTime($r['tgl_order']);
?>
</td>
<td align="left" valign="top">Telepon</td>
<td align="left" valign="top">:</td>
<td align="left" valign="top"><?php
echo $r['telepon'];
?>
</td>
</tr>
<tr>
<td align="left" valign="top">Status </td>
<td align="left" valign="top">:</td>
<td align="left" valign="top"><?php
echo $r['status'] == 2 ? 'COMPLETED' : ($r['status'] == 1 ? 'PENDING' : 'CANCELLED');
?>
function showInterval($date1, $date2, $format, $nosecs = '')
{
$diff = timediff($date1, $date2, $format, $nosecs);
$ret = "";
if ($diff['days']) {
$ret = $diff['days'] . ' ' . getLT('days');
}
if ($diff['hours']) {
$ret .= " " . $diff['hours'] . ' ' . getLT('hours');
}
if ($diff['mins']) {
$ret .= " " . $diff['mins'] . ' ' . getLT('minutes');
}
if ($diff['secs'] && $nosecs == "yes") {
$ret .= " " . $diff['secs'] . ' ' . getLT('seconds');
}
$indate1 = explode(" ", $date1);
$dateArr1 = explode("-", $indate1[0]);
$hourArr1 = explode(":", $indate1[1]);
$indate2 = explode(" ", $date2);
$dateArr2 = explode("-", $indate2[0]);
$hourArr2 = explode(":", $indate2[1]);
if ($date2 == '0000-00-00 00:00:00') {
$ret = "";
}
if ($date1 == '0000-00-00 00:00:00') {
$ret = "";
}
if ($ret == "") {
$ret = getLT('amoment');
}
$ret2 = "";
if ($indate1[0] == $indate2[0] && $indate1[0] != "0000-00-00") {
$ret2 = showDate($indate1[0], $format);
if ($nosecs == '') {
$ret2 .= " " . $hourArr1[0] . ":" . $hourArr1[1] . "-" . $hourArr2[0] . ":" . $hourArr2[1];
} else {
$ret2 .= " " . $indate1[1] . "-" . $indate2[1];
}
} else {
$t1 = showDateTime($date1, $format, $nosecs);
$t2 = showDateTime($date2, $format, $nosecs);
$ret2 .= $t1;
if ($t1 != "" && $t2 != "") {
$ret2 .= "[-]";
}
$ret2 .= $t2;
}
$ret2 .= " (" . $ret . ")";
return $ret2;
}