db->select("no_kwitansi,tgl_kwitansi,nama_pelanggan,replace(alamat_pelanggan,'\n',' ') as alamat_pelanggan,sum(total_bayar) as total_bayar, CONCAT('',GROUP_CONCAT(''),'

Kode	Barang	Jml.	Harga Satuan	Total
',kode_barang,'	',nama_barang,'	',kuantitas,'	Rp. ',convert(format(harga_satuan,0, 'id_ID') USING latin1),'	Rp. ',convert(format(total_bayar,0, 'id_ID') USING latin1),'

') as data_invoice"); $this->db->group_by("no_kwitansi,tgl_kwitansi,nama_pelanggan,alamat_pelanggan"); $query=$this->db->get($this->ViewInvoice); if($query->num_rows()>0){ return $query->result_array(); } } }