?>
<tr>
<td><?php
echo $no++;
?>
</td>
<td><?php
echo $detail->NM_PRODUK;
?>
</td>
<td><?php
echo $detail->QTY;
?>
</td>
<td><?php
echo konversiGram($detail->BERAT_PRODUK * $detail->QTY);
?>
</td>
<td><?php
echo formatRp($detail->HARGA_PER);
?>
</td>
<td>
<input type="text" name="tersedia[]">
<input type="hidden" name="id_produk[]" value="<?php
echo $detail->ID_PRODUK;
?>
">
</td>
</tr>
<?php
}
}
}
?>
<td colspan="3">Ekspedisi : <?php
echo strtoupper($kr->NAMA_KURIR);
?>
( <?php
echo $kr->PAKET_YANG_DIAMBIL;
?>
) / <?php
echo formatRp($kr->TOTAL);
?>
</td>
<td><?php
echo konversiGram($pro_berat[$f - 1]);
?>
</td>
<td colspan="3">Estimasi : <?php
echo $estimasi;
?>
hari </td>
</tr>
</table>
<?php
for ($n = 0; $n < $i; $n++) {
$pro_harga[$n] += @$pro_harga[$n - 1];
}
$tot_harga[$m] = $pro_harga[$n - 1] + $kr->TOTAL;
?>
<?php
?>
</td>
<td><?php
echo $detail->NM_PRODUK;
?>
</td>
<td><?php
echo $detail->QTY;
?>
buah</td>
<td><?php
echo konversiGram($detail->BERAT_PRODUK);
?>
</td>
<td><?php
echo konversiGram($detail->BERAT_PRODUK * $detail->QTY_TERSEDIA);
?>
</td>
<td><?php
echo formatRp($detail->HARGA_PER);
?>
</td>
<?php
if ($tok->STATUS_TERSEDIA == 1) {
$tp = "text";
$dp = "";
} else {
$tp = "hidden";
$dp = "style='display:none;'";
}
?>
?>
buah</td>
</tr>
<tr>
<td style="padding:8px"><label>Total Ongkos Kirim</label></td>
<td style="padding:8px">:</td>
<td style="padding:8px"><?php
echo formatRp($ongkir);
?>
</td>
</tr>
<tr>
<td style="padding:8px"><label>Total Berat</label></td>
<td style="padding:8px">:</td>
<td style="padding:8px"><?php
echo konversiGram($tot_berat_paling_akhir);
?>
</td>
</tr>
</table>
<br/>
<hr/>
<?php
}
</div> </div> <div class="col-md-6"> <div class="panel panel-default"> <div class="panel-body"> <table width="100%" class=""> <tr> <td><i class="fa fa-eye"></i> Dilihat</td> <td><?php echo $row->HITS; ?> </td> <td><i class="fa fa-archive"></i> Berat</td> <td><?php echo konversiGram($row->BERAT_PRODUK); ?> </td> </tr> <tr> <td><i class="fa fa-star"></i> Min. Pesan</td> <td><?php echo $row->MIN_PESAN; ?> </td> <td><i class="fa fa-money"></i> Terjual</td> <td><?php echo $row->IN_CART; ?> </td> </tr>
echo $pr->ID_PRODUK;
?>
"><?php
echo $pr->NM_PRODUK;
?>
</a></td>
<td><?php
echo $pr->QTY;
?>
</td>
<td><?php
echo konversiGram($pr->BERAT_PRODUK);
?>
</td>
<td><?php
echo konversiGram($pr->QTY * $pr->BERAT_PRODUK);
?>
</td>
<td><?php
echo formatRp($pr->HARGA_SATUAN);
?>
</td>
<td><?php
echo formatRp($pr->QTY * $pr->HARGA_SATUAN);
?>
</td>
</tr>
<?php
}
?>
<tr>
function kirimemail($trans, $toko)
{
$iki = $this->db->query("SELECT * FROM view_detail_transaksi WHERE ID_TRANS='{$trans}' AND ID_TOKO='{$toko}'")->result();
$mai = $this->db->query("SELECT * FROM mp_toko WHERE ID_TOKO='{$toko}'")->row();
$data_login = $this->db->query("SELECT * FROM mp_user WHERE ID_AUTH='{$mai->ID_TOKO}'")->row();
$username = $data_login->USERNAME;
$password = $data_login->PASSWORD;
$isi = "<table cellspacing='0' bordercolor='#000000' cellpadding='4' border='1' style='border: solid 1.5pt black; border-collapse: collapse'>";
$isi .= "<thead>";
$isi .= "<tr>";
$isi .= "<th>No</th>";
$isi .= "<th>Produk</th>";
$isi .= "<th>QTY</th>";
$isi .= "<th>Berat @</th>";
$isi .= "<th>Harga @</th>";
$isi .= "<th>Total Berat</th>";
$isi .= "<th>Total Harga</th>";
$isi .= "<th>Ongkir</th>";
$isi .= "<th>Total</th>";
$isi .= "</tr>";
$isi .= "</thead>";
$isi .= "<tbody>";
$no = 1;
$tot_web = 0;
$tot_pj = 0;
$tot_akh = 0;
$tot_akh_ongkir = 0;
$tot_ongkir = 0;
foreach ($iki as $detail) {
$namatoko = $detail->NM_TOKO;
$tgl_transaksi = $detail->TGL_TRANS;
$isi .= "<tr>";
$isi .= "<td>" . $no++ . "</td>";
$isi .= "<td>" . $detail->NM_PRODUK . "</td>";
$isi .= "<td>" . $detail->QTY . "</td>";
$isi .= "<td>" . $detail->BERAT_PRODUK . "</td>";
$isi .= "<td>" . formatRp($detail->HARGA_PER) . "</td>";
$isi .= "<td>" . konversiGram($detail->BERAT_PRODUK * $detail->QTY) . "</td>";
$totharga = $detail->HARGA_PER * $detail->QTY;
$isi .= "<td>" . formatRp($detail->HARGA_PER * $detail->QTY) . "</td>";
$tot_ongkir += $detail->HARGA_ONGKIR;
$isi .= "<td>" . formatRp($detail->HARGA_ONGKIR) . "</td>";
$tot_akh += $totharga + $detail->HARGA_ONGKIR;
$isi .= "<td>" . formatRp($totharga + $detail->HARGA_ONGKIR) . "</td>";
$isi .= "<tr>";
}
$isi .= "</tbody>";
$isi .= "<tfoot>";
$isi .= "<td colspan='7' align='center'>Jumlah</td>";
$isi .= "<td>" . formatRp($tot_ongkir) . "</td>";
$isi .= "<td>" . formatRp($tot_akh) . "</td>";
$isi .= "</tfoot>";
$isi .= "</table>";
$this->load->library('email');
$config = array("mailtype" => "html");
$this->email->initialize($config);
$this->email->from('*****@*****.**', 'INDOBABA');
$this->email->to($mai->EMAIL);
$this->email->cc('*****@*****.**');
$this->email->bcc('*****@*****.**');
$this->email->subject('Orderan dari indobaba');
$this->email->message("Hai <b>" . $namatoko . "</b> ,<br/><br/> Anda mendapatkan orderan pada tanggal <b>" . tgl_indo_lengkap($tgl_transaksi) . "</b> di ID Transaksi <b>" . $trans . "</b><br/><br/>Silahkan klik link dibawah ini untuk melihat orderan anda<br/><br/> <a href='" . base_url() . "admin_transaksi/detailTransaksiUkmEmail'>" . base_url() . "ukm_info</a><br/><br/>Terima kasih atas perhatiannya. Dimohon segera konfirmasi ketersediaan dan melakukan pengiriman orderan anda.<br/><br/><br/>Salam Indobaba Group");
$this->email->send();
}
