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