function formatHarga()
{
$formatRupiah = $this->input->post('nominal');
echo formatRp($formatRupiah);
}
<div class="col-md-6">
<div class="panel panel-default">
</div>
</div>
<div class="col-md-6">
<div class="panel panel-default">
<div class="panel-body" style="display:none">
<!-- <h2><?php
echo formatRp($aslitot - $tg);
$saldo = $aslitot - $tg;
?>
</h2> -->
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="panel-body">
<h2><?php
echo formatRp($tg);
?>
</h2>
</div>
</div>
</div>
<div class="col-md-6">
<div class="panel panel-default">
<div class="panel-heading">
Total Pemasukan Indobaba
</div>
<div class="panel-body">
<h2><?php
echo formatRp($pjs);
?>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-12">
<?php
if ($pembeli->ID_STATUS == 2) {
?>
<a href="#" onclick="barang_ada(<?php
echo $pembeli->NO_TRANS;
?>
<?php
$g = $this->db->query("SELECT * FROM mp_galeri_pro WHERE ID_PRODUK = '{$key->ID_PRODUK}' limit 1")->row();
?>
<img alt="" width="100" src="<?php
echo site_url('assets-admin/img/produk/rs.php?ok=' . $g->FT_PRODUK);
?>
" />
</div>
</div>
<div class="col-xs-8 col-sm-8 no-margin keranjang-puji">
<div class="title"><?php
echo $key->NM_PRODUK;
?>
</div>
<div class="price"><?php
echo formatRp($key->HARGA);
?>
</div>
<div class="price"><?php
echo $key->QTY;
?>
Buah</div>
</div>
</div>
</div>
</li>
<?php
}
}
?>
<li>
</tr>
<tr>
<td><p>Kode Unik</p></td>
<td><p> : </p></td>
<td><p><?php
// $kode_unik = kodeUnik($tk->ID_TRANS);
// echo $kode_unik;
echo $this->session->userdata("kode_unik");
?>
</p></td>
</tr>
</table>
<br>
<p>Total Bayar :</p>
<p style="font-size:35px; color:#F27A24;"><?php
echo formatRp($tot_tag[$l - 1] + $this->session->userdata("kode_unik"));
?>
</p>
<?php
echo anchor("user_checkout/checkout_cart", "Checkout", array('class' => 'btn btn-success'));
?>
</div>
</div>
</div>
<?php
} else {
?>
<div class="container">
<div class="row">
<div class="col-md-12">
public function checkout_tabl()
{
$akun = $this->session->userdata("id_akun_user");
$order = $this->input->post('order_tab');
if ($order == 1) {
$sts = 1;
$sts1 = 0;
} elseif ($order == 2) {
$sts = 2;
$sts1 = 3;
} elseif ($order == 3) {
$sts = 4;
$sts1 = 0;
} elseif ($order == 4) {
$sts = 5;
$sts1 = 0;
} elseif ($order == 5) {
$sts = 9;
$sts1 = 0;
}
$tampil = $this->producthomemodel->outdata('view_checkout', $akun, $sts, 'ID_TRANS', $sts1);
if (count($tampil) > 0) {
$json_data = array('status' => 'yes');
$i = 0;
foreach ($tampil as $row) {
$json_data['data'][$i]['NO_TRANS'] = $row->NO_TRANS;
$json_data['data'][$i]['ID_TRANS'] = $row->ID_TRANS;
$json_data['data'][$i]['TGL_TRANS'] = $row->TGL_TRANS;
$json_data['data'][$i]['WKT_TRANS'] = $row->WKT_TRANS;
if ($row->STS_BAYAR == 0) {
$stts = "belum bayar";
} else {
$stts = "sudah bayar";
}
$toko = $this->db->query("SELECT * FROM view_checkout WHERE ID_AKUN = '{$akun}' AND NO_TRANS = '{$row->NO_TRANS}' GROUP BY ID_TOKO")->result();
$k = 0;
foreach ($toko as $tk) {
$m = 0;
$alamat = $this->db->query("SELECT * FROM view_checkout WHERE ID_AKUN = '{$akun}' AND ID_TOKO = '{$tk->ID_TOKO}' AND NO_TRANS = '{$row->NO_TRANS}' GROUP BY ID_ALAMAT")->result();
foreach ($alamat as $al) {
$kurir = $this->db->query("SELECT * FROM view_checkout WHERE ID_AKUN = '{$akun}' AND ID_TOKO = '{$tk->ID_TOKO}' AND ID_ALAMAT = '{$al->ID_ALAMAT}' AND NO_TRANS = '{$row->NO_TRANS}' GROUP BY ID_ONGKIR")->result();
foreach ($kurir as $kr) {
$f = 0;
$pro = $this->db->query("SELECT * FROM view_checkout WHERE ID_AKUN = '{$akun}' AND ID_TOKO = '{$tk->ID_TOKO}' AND ID_ALAMAT = '{$al->ID_ALAMAT}' AND ID_ONGKIR = '{$kr->ID_ONGKIR}' AND NO_TRANS = '{$row->NO_TRANS}'")->result();
foreach ($pro as $pr) {
$pro_harga[$f] = $pr->QTY * $pr->HARGA_SATUAN;
$f++;
}
for ($n = 0; $n < $f; $n++) {
$pro_harga[$n] += @$pro_harga[$n - 1];
}
$tot_harga[$m] = $pro_harga[$n - 1] + $kr->TOTAL;
$m++;
}
}
for ($j = 0; $j < $m; $j++) {
$tot_harga[$j] += @$tot_harga[$j - 1];
}
$tot_tag[$k] = @$tot_harga[$j - 1];
$k++;
}
for ($l = 0; $l < $k; $l++) {
$tot_tag[$l] += @$tot_tag[$l - 1];
}
$json_data['data'][$i]['TOT_BAY'] = formatRp(@$tot_tag[$l - 1] + $tk->KODE_UNIK);
$json_data['data'][$i]['STS_BAYAR'] = $stts;
$tanggap = $this->db->query("SELECT STS_TANGGAP FROM view_checkout WHERE ID_AKUN = '{$akun}' AND ID_TRANS = '{$row->ID_TRANS}' AND STS_TANGGAP = 1 GROUP BY ID_TOKO");
$json_data['data'][$i]['STS_TANGGAP'] = $tanggap->num_rows();
$resi = $this->db->query("SELECT STS_RESI FROM view_checkout WHERE ID_AKUN = '{$akun}' AND ID_TRANS = '{$row->ID_TRANS}' AND STS_RESI = 1 GROUP BY ID_TOKO");
$json_data['data'][$i]['STS_RESI'] = $resi->num_rows();
$jum_tk = $this->db->query("SELECT STS_TANGGAP FROM view_checkout WHERE ID_AKUN = '{$akun}' AND ID_TRANS = '{$row->ID_TRANS}' GROUP BY ID_TOKO");
$json_data['data'][$i]['JUM_TOKO'] = $jum_tk->num_rows();
$i++;
}
} else {
$json_data = array('status' => 'no');
}
// for ($b=0; $b < 7; $b++) {
// if ($b == 3){
// $jml = $this->db->query('SELECT COUNT(NO_TRANS) as JML FROM mp_transaksi WHERE (ID_STATUS = 4 OR ID_STATUS = 6) AND ID_AKUN = '.$akun.' ORDER BY NO_TRANS DESC')->row();
// }
// else{
// $jml = $this->producthomemodel->tampilData('mp_transaksi', 'COUNT(NO_TRANS) as JML', array('ID_AKUN' => $akun, 'ID_STATUS' => ($b+1)), TRUE);
// }
// $json_data['jml'][$b] = $jml->JML;
// $json_data['sts'][$b] = ($b+1);
// }
echo json_encode($json_data);
}
<td><?php
echo formatRp($pr->QTY * $pr->HARGA_SATUAN);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">Ekspedisi : <?php
echo strtoupper($kr->NAMA_KURIR);
?>
( <?php
echo $kr->PAKET_YANG_DIAMBIL;
?>
) / <?php
echo formatRp($kr->TOTAL);
?>
</td>
</tr>
</table>
<?php
}
?>
<?php
}
?>
</div>
</div>
</div>
</div>
<h2 align="center"><?php
echo formatRp($tg);
?>
</h2>
</div>
</div>
</div>
<div class="col-md-6">
<div class="panel panel-info">
<div class="panel-heading">
<center>Masuk Ke Saldo Pembeli Dari Transaksi Ini</center>
</div>
<div class="panel-body">
<h2 align="center"><?php
$saldo = $aslitot - $tg;
echo formatRp($saldo);
?>
</h2>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<a href="<?php
echo site_url('admin_transaksi/tabel/2');
?>
" class="btn btn-danger">Kembali</a>
</div>
</div>
echo $tampilprov->PROVINSI;
?>
</td>
<td><?php
echo $tampilkota->KOKAB;
?>
</td>
<td><?php
echo $tampilkecamatan->KECAMATAN;
?>
</td>
<td><?php
echo formatRp($tampil->HARGA);
?>
</td>
<td><?php
echo anchor("admin_ekspedisi/editHarga/{$tampil->ID_HRG_EKS}", "Edit", array("class" => "btn btn-success"));
?>
</td>
</tr>
<?php
}
?>
</tbody>
function tghn()
{
$tg = $this->input->post("tg");
echo formatRp($tg);
}
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();
}
?>
<td><p>Saldo dari transaksi ini</p></td>
<td><p> : </p></td>
<td><p><?php
echo formatRp($saldo->SALDO);
?>
</p></td>
</tr>
<?php
}
?>
</table>
<br>
<p>Total Bayar :</p>
<p style="font-size:35px; color:#F27A24;"><?php
echo formatRp($tot_tag[$l - 1] + $tk->KODE_UNIK);
?>
</p>
<?php
if ($stat->ID_STATUS == 1 && $stat->STS_BAYAR == 0) {
?>
<div class="form-group">
<button type="button" class="btn btn-info" data-toggle="modal" data-target="#bayarModal">Pembayaran</button>
</div>
<?php
include 'bayar_modal.php';
} elseif ($stat->ID_STATUS == 5 && $stat->STS_BAYAR == 1) {
?>
<div class="form-group">
<button type="button" class="btn btn-info" data-toggle="modal" data-target="#bayarModal">Pembayaran</button>
$ongkir = 0;
foreach ($ongk as $ss) {
//echo $ss->ID_ONGKIR."-";
$ongkir += $ss->TOTAL_ONGKIR_REALISASI;
}
} else {
$ongk = $this->db->query("SELECT * FROM view_trans_batal WHERE ID_TRANS='{$row->ID_TRANS}' AND ID_TOKO = '{$row->ID_TOKO}' AND STS_TAMPIL=1 GROUP BY ID_ONGKIR")->result();
$ongkir = 0;
foreach ($ongk as $ss) {
//echo $ss->ID_ONGKIR."-";
$ongkir += $ss->HARGA_ONGKIR;
}
}
$unik = $this->db->query("SELECT * FROM mp_bukti WHERE NO_TRANS='{$row->NO_TRANS}'")->row();
$hasil_akhir = $h + $ongkir - $ind;
echo formatRp($hasil_akhir);
?>
</td>
<td><?php
if ($id == 4) {
?>
<a target="_detail" href="<?php
echo site_url("ukm_info/ubahdata/2/" . base64_encode_fix($row->ID_TRANS));
?>
" class="btn btn-info">Ubah Data</a><?php
}
?>
<a target="_detail" href="<?php
echo site_url("ukm_info/detailTransaksi/{$id}/" . base64_encode_fix($row->ID_TRANS));
?>
" class="btn btn-success">Detail</a></td>
echo $link;
?>
"><?php
echo $row->NM_PRODUK;
?>
</a>
</div>
</div>
<div class="prices">
<div class="price-current text-center"><?php
$h_grosir = explode("|", $row->HARGA);
$hh_grosir = explode("-", $h_grosir[0]);
if ($row->STS_GROSIR == 0) {
echo formatRp($row->HARGA);
} else {
echo formatRp($hh_grosir[2]);
}
?>
</div>
</div>
<div class="hover-area">
<div class="add-cart-button">
<a href="single-product.html" class="le-button">Selengkapnya</a>
</div>
<div class="wish-compare">
<?php
foreach ($this->producthomemodel->tampilData("mp_toko", "NM_TOKO", array("ID_TOKO" => $row->ID_TOKO)) as $row_namaukm) {
$nama_toko = str_replace(" ", "-", $row_namaukm->NM_TOKO);
echo anchor("Home_controller/ukm/{$nama_toko}", $row_namaukm->NM_TOKO, 'class="btn-add-to-wishlist"');
}
?>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">
Dibayar Ke UKM
</div>
<div class="panel-body">
<h2><?php
echo formatRp($tot_harga2 + $ongkir - ($ku_web + $ku_pj));
?>
</h2>
</div>
</div>
</div>
</div>
</div>
<br/>
<hr/>
<br/>
<?php
}
?>
<!-- <div class="row">
<div class="col-md-6">
<div class="panel panel-default">
<div class="panel-heading">
Total Tagihan ke pembeli
</div>
<div class="panel-body">
<h2><?php
echo formatRp($tg);
?>
</h2>
</div>
</div>
</div>
</div> -->
</div>
</form>
<script>
function kirimemail(trans,toko)
{
$.ajax( {
type :"POST",
url :"<?php
echo site_url('admin_transaksi/kirimemail');
?>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<?php
$grosir = $row->HARGA;
$harga_satuan = "";
if ($row->STS_GROSIR == 0) {
$harga_satuan = formatRp($grosir);
echo '<div style="text-align:center;"><h1>' . $harga_satuan . '</h1></div>';
} else {
$data = explode('|', $grosir);
$i = 0;
$data2 = explode('-', $data[0]);
echo '<div style="text-align:center;"><h1 style="color:orange">' . formatRp($data2[2]) . '</h1></div>';
}
?>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">
<h4><i class="fa fa-home"></i> Info Produsen</h4>
</div>
<div class="panel-body">
<?php
$id_toko = '';
foreach ($this->produkmodel->tampilData("mp_toko", "*", array("ID_TOKO" => $row->ID_TOKO)) as $row_ukm) {
?>
?>
</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
}
?>
<tr>
function hargacariprodukukm($harga, $status)
{
$h_grosir = explode("|", $harga);
$hh_grosir = explode("-", $h_grosir[0]);
if ($status == 0) {
return formatRp($harga);
} else {
return formatRp($hh_grosir[2]);
}
}
$ind = 0;
foreach ($hit as $ke) {
$h += $ke->HARGA_PER * $ke->QTY_TERSEDIA;
$keu = $this->db->query("SELECT * FROM mp_keuntungan LIMIT 1")->ROW();
$keuntungan1 = $keu->KEUNTUNGAN_UKM / 100 * ($ke->HARGA_PER * $ke->QTY_TERSEDIA);
$keuntungan2 = $keu->KEUNTUNGAN_PJ / 100 * ($ke->HARGA_PER * $ke->QTY_TERSEDIA);
$ind += $keuntungan1 + $keuntungan2;
}
$ongk = $this->db->query("SELECT * FROM view_detail_transaksi WHERE ID_TRANS='{$row->ID_TRANS}' AND STS_TAMPIL=1 GROUP BY ID_ONGKIR")->result();
$ongkir = 0;
foreach ($ongk as $ss) {
//echo $ss->ID_ONGKIR."-";
$ongkir += $ss->TOTAL_ONGKIR_REALISASI;
}
$unik = $this->db->query("SELECT * FROM mp_bukti WHERE NO_TRANS='{$row->NO_TRANS}'")->row();
echo formatRp($h + $ongkir + $unik->KODE_UNIK);
?>
</td>
<td><a target="_detail" href="<?php
echo site_url('admin_transaksi/detailTransaksi/' . base64_encode_fix($row->ID_TRANS));
?>
" class="btn btn-success">Detail</a></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
<script type="text/javascript">
<td style="padding:8px">:</td>
<td style="padding:8px"><?php
echo konversiGram($tot_berat_paling_akhir);
?>
</td>
</tr>
</table>
<hr/>
<table >
<tr>
<td ><strong>Total Tagihan ke Indobaba</strong></td>
<td style="padding:4px">:</td>
<td style="font-size:30px; color: #688744"><?php
echo formatRp($tot_harga2 - ($ku_web + $ku_pj) + $ongkir);
?>
</td>
</tr>
</table>
</div>
</div>
<?php
}
?>
