Assalamualaikum,.. mas. oleh sebab karena tidak berhasil makanya saya tanya lagi mas. sudah saya coba saran mas tersebut. gak ada efek mas. munkin ada yang salah kali ya mas coba dibantu mas.
ini bagian application\views\reseller\mod_penjualan\view_penjualan.php
<div class="col-xs-12">
<div class="box">
<div class="box-header">
<h3 class="box-title">Data Transaksi Penjualan / Orderan Konsumen</h3>
<a class='pull-right btn btn-primary btn-sm' href='<?php echo base_url(); ?>reseller/tambah_penjualan'>Tambah Penjualan</a>
</div><!-- /.box-header -->
<div class="box-body">
<div class='table-responsive'>
<table id="example1" class="table table-bordered table-striped table-condensed">
<thead>
<tr>
<th style='width:40px'>No</th>
<th>Kode Transaksi</th>
<th>Nama Konsumen</th>
<th>Kurir</th>
<th>Status</th>
<th>Total + Ongkir</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
foreach ($record->result_array() as $row){
if ($row['proses']=='0'){ $proses = '<i class="text-danger">Pending</i>'; $status = 'Proses'; $icon = 'star-empty'; $ubah = 1; }elseif($row['proses']=='1'){ $proses = '<i class="text-success">Proses</i>'; $status = 'Pending'; $icon = 'star text-yellow'; $ubah = 0; }else{ $proses = '<i class="text-info">Konfirmasi</i>'; $status = 'Proses'; $icon = 'star'; $ubah = 1; }
$total = $this->db->query("SELECT sum((a.harga_jual*a.jumlah)-a.diskon) as total FROM `rb_penjualan_detail` a where a.id_penjualan='$row[id_penjualan]'")->row_array();
echo "<tr><td>$no</td>
<td>$row[kode_transaksi]</td>
<td><a href='".base_url()."reseller/detail_konsumen/$row[id_konsumen]'>$row[nama_lengkap]</a></td>
<td><span style='text-transform:uppercase'>$row[kurir]</span> - $row[service]</td>
<td>$proses</td>
<td style='color:red;'>Rp ".rupiah($total['total']+$row['ongkir'])."</td>
<td><center>
<a class='btn btn-success btn-xs' title='Detail Data' href='".base_url()."reseller/detail_penjualan/$row[id_penjualan]'><span class='glyphicon glyphicon-search'></span> Detail</a>
<a class='btn btn-primary btn-xs' title='$status Data' href='".base_url()."reseller/proses_penjualan/$row[id_penjualan]/$ubah' onclick=\"return confirm('Apa anda yakin untuk ubah status jadi $status?')\"><span class='glyphicon glyphicon-$icon'></span></a>
<a class='btn btn-warning btn-xs' title='Edit Data' href='".base_url()."reseller/edit_penjualan/$row[id_penjualan]'><span class='glyphicon glyphicon-edit'></span></a>
<a class='btn btn-danger btn-xs' title='Delete Data' href='".base_url()."reseller/delete_penjualan/$row[id_penjualan]' onclick=\"return confirm('Apa anda yakin untuk hapus Data ini?')\"><span class='glyphicon glyphicon-remove'></span></a>
</center></td>
</tr>";
$no++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
ini yang bagian application\views\phpmu-tigo\reseller\view_reseller_detail.php
<p class='sidebar-title text-danger produk-title'>Detail Data Pedagang</p>
<div class='panel-body'>
<ul id='myTabs' class='nav nav-tabs' role='tablist'>
<li role='presentation' class='active'><a href='#profile' id='profile-tab' role='tab' data-toggle='tab' aria-controls='profile' aria-expanded='true'>Data Pedagang </a></li>
<li role='presentation' class=''><a href='#rekening' role='tab' id='rekening-tab' data-toggle='tab' aria-controls='rekening' aria-expanded='false'>No Rekening</a></li>
<li role='presentation' class=''><a href='#pembelian' role='tab' id='pembelian-tab' data-toggle='tab' aria-controls='pembelian' aria-expanded='false'>History Penjualan</a></li>
</ul><br>
<div id='myTabContent' class='tab-content'>
<div role='tabpanel' class='tab-pane fade active in' id='profile' aria-labelledby='profile-tab'>
<div class='col-md-12'>
<table class='table table-condensed'>
<tbody>
<?php
if (!file_exists("asset/foto_user/$rows[foto]") OR
$rows['foto']==''){ $foto_user = "blank.png";
}else{
$foto_user = $rows['foto'];
}
?>
<tr class='hidden-xs' bgcolor='#e3e3e3'><td rowspan='12' width='110px'><?php echo "<img style='border:1px solid #cecece; height:85px; width:85px' src='".base_url()."asset/foto_user/$foto_user' class='img-circle img-thumbnail'>"; ?></td></tr>
<tr><th scope='row' width='140px'>Nama Pedagang</th> <td><?php echo $rows['nama_reseller']?></td></tr>
<tr><th scope='row'>Jenis Kelamin</th> <td><?php echo $rows['jenis_kelamin']?></td></tr>
<?php if ($this->sesion->id_konsumen!=''){ ?>
<tr><th scope='row'>Alamat</th> <td><?php echo $rows['alamat_lengkap']?></td></tr>
<tr><th scope='row'>No Hp</th> <td><?php echo $rows['no_telpon']?></td></tr>
<?php } ?>
<tr><th scope='row'>Alamat Email</th> <td><?php echo $rows['email']?></td></tr>
<tr><th scope='row'>Kode Pos</th> <td><?php echo $rows['kode_pos']?></td></tr>
<tr><th scope='row'>Keterangan</th> <td><?php echo $rows['keterangan']?></td></tr>
<tr><th scope='row'>Tanggal Daftar</th> <td><?php echo tgl_indo($rows['tanggal_daftar']); ?></td></tr>
</tbody>
</table>
</div>
<div style='clear:both'></div>
</div>
<div role='tabpanel' class='tab-pane fade' id='rekening' aria-labelledby='rekening-tab'>
<div class='col-md-12'>
<div class='alert alert-warning'><b>PENTING!</b> - Silahkan transfer pembayaran anda hanya ke rekening dibawah ini saja.</div>
<table class='table table-hover table-condensed'>
<thead>
<tr>
<th width="20px">No</th>
<th>Nama Bank</th>
<th>No Rekening</th>
<th>Atas Nama</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
foreach ($rekening->result_array() as $row){
if ($row['proses']=='0'){ $proses = '<i class="text-danger">Pending</i>'; $status = 'Proses'; $icon = 'star-empty'; $ubah = 1; }else{ $proses = '<i class="text-success">Proses</i>'; $status = 'Pending'; $icon = 'star text-yellow'; $ubah = 0; }
$total = $this->db->query("SELECT sum((a.harga_jual*a.jumlah)-a.diskon) as total FROM `rb_penjualan_detail` a where a.id_penjualan='$row[id_penjualan]'")->row_array();
echo "<tr><td>$no</td>
<td>$row[nama_bank]</td>
<td>$row[no_rekening]</td>
<td>$row[pemilik_rekening]</td>
</tr>";
$no++;
}
?>
</tbody>
</table>
</div>
</div>
<div role='tabpanel' class='tab-pane fade' id='pembelian' aria-labelledby='pembelian-tab'>
<div class='col-md-12'>
<table class='table table-hover table-condensed'>
<thead>
<tr>
<th width="20px">No</th>
<th>Nama Pembeli</th>
<th>Total Belanja</th>
<th>Status</th>
<th>Waktu Transaksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
foreach ($record->result_array() as $row){
if ($row['proses']=='0'){ $proses = '<i class="text-danger">Pending</i>'; $status = 'Proses'; $icon = 'star-empty'; $ubah = 1; }else{ $proses = '<i class="text-success">Proses</i>'; $status = 'Pending'; $icon = 'star text-yellow'; $ubah = 0; }
$total = $this->db->query("SELECT sum((a.harga_jual*a.jumlah)-a.diskon) as total FROM `rb_penjualan_detail` a where a.id_penjualan='$row[id_penjualan]'")->row_array();
echo "<tr><td>$no</td>
<td><b>$row[nama_lengkap]</b></td>
<td style='color:red;'>Rp ".rupiah($total['total'])."</td>
<td>$proses</td>
<td>$row[waktu_transaksi]</td>
</tr>";
$no++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
