Assalamualaikum,..
Adapun script view , controller dan model nya adalah sebagai berikut :
======================================================================================================================================
View :
<table class="table table-striped" cellspacing="0" width="100%" id="mydata">
<thead>
<tr>
<th style="width:50px;">No</th>
<th>No Faktur</th>
<th>Tanggal</th>
<th>Kode Barang</th>
<th>Nama Barang</th>
<th>Satuan</th>
<th>Harga Jual</th>
<th>Qty</th>
<th>Total</th>
</tr>
</thead>
<tbody>
<?php
$no=0;
foreach ($data->result_array() as $i) {
$no++;
$nofak =$i['jual_nofak'];
$tgl =$i['jual_tanggal'];
$barang_id =$i['d_jual_barang_id'];
$barang_nama =$i['d_jual_barang_nama'];
$barang_satuan=$i['d_jual_barang_satuan'];
$barang_harjul=$i['d_jual_barang_harjul'];
$barang_qty =$i['d_jual_qty'];
$barang_total =$i['d_jual_total'];
?>
<tr>
<td style="text-align:center;"><?php echo $no;?></td>
<td style="padding-left:5px;"><?php echo $nofak;?></td>
<td style="text-align:center;"><?php echo $tgl;?></td>
<td style="text-align:center;"><?php echo $barang_id;?></td>
<td style="text-align:left;"><?php echo $barang_nama;?></td>
<td style="text-align:left;"><?php echo $barang_satuan;?></td>
<td style="text-align:right;">
<?php echo 'Rp '.number_format($barang_harjul);?></td>
<td style="text-align:center;"><?php echo $barang_qty;?></td>
<td style="text-align:right;">
<?php echo 'Rp '.number_format($barang_total);?></td>
</tr>
<?php }?>
</tbody>
<tfoot>
<?php
$b=$jml->row_array();
?>
<tr>
<td colspan="8" bgcolor="#FFFF00" style="text-align:right;"><b>Total Penjualan</b></td>
<td bgcolor="#ADFF2F" style="text-align:right;"><b>
<?php echo 'Rp '.number_format($b['total']);?></b></td>
</tr>
</tfoot>
</table>
===================================================================================================================================
Model :
====================================================================================================================================
function get_data_penjualan(){
$hsl=$this->db->query("SELECT jual_nofak,DATE_FORMAT(jual_tanggal,'%d %M %Y') AS jual_tanggal,jual_total,d_jual_barang_id,d_jual_barang_nama,d_jual_barang_satuan,d_jual_barang_harpok,d_jual_barang_harjul,d_jual_qty,d_jual_total FROM tbl_jual JOIN tbl_detail_jual ON jual_nofak=d_jual_nofak ORDER BY jual_nofak DESC");
return $hsl;
}
function get_total_penjualan(){
$hsl=$this->db->query("SELECT jual_nofak,DATE_FORMAT(jual_tanggal,'%d %M %Y') AS jual_tanggal,jual_total,d_jual_barang_id,d_jual_barang_nama,d_jual_barang_satuan,d_jual_barang_harpok,d_jual_barang_harjul,d_jual_qty,sum(d_jual_total) as total FROM tbl_jual JOIN tbl_detail_jual ON jual_nofak=d_jual_nofak ORDER BY jual_nofak DESC");
return $hsl;
}
==================================================================================================================================
Controller:
function index(){
if($this->session->userdata('akses')=='1'){
$data['data1']=$this->m_barang->tampil_barang();
$data['data']=$this->m_penjualan->get_data_penjualan();
$data['jml']=$this->m_penjualan->get_total_penjualan();
$this->load->view('admin/v_penjualan',$data);
}else{
echo "Halaman tidak ditemukan";
}
}