Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function infaq ($p=array(),$count=FALSE){
- $total = 0;
- $month = date('m');
- $year = date('Y');
- $tanggal= date('Y-m-d');
- // $this->db->select('transaksi.*');
- // $this->db->where('trxDesc', 'DONASI');
- // $this->db->where('(date(dateTransaction) >= '.$p['date_from'].' and date(dateTransaction) <= '.$p['date_to'].')');
- // $this->db->where('produk', 'DONASI');
- // $this->db->where('jenisProduk', 'INFAQ');
- // $this->db->join('agent','agent.noreg=transaksi.noregAdminBmt','LEFT');
- $query = "SELECT *,t.namaLoket as username, a.namaLengkap as Baitull
- FROM transaksi t
- JOIN agent a on a.noregAdminBmt = t.noregAdminBmt
- LEFT JOIN agent b ON b.namaLoket = t.namaLoket
- where (date(dateTransaction) >= '".$p['date_from']."' and date(dateTransaction) <= '".$p['date_to']."')
- AND jenisProduk = 'INFAQ'
- AND produk = 'donasi'
- AND a.namaLengkap LIKE '%Baitul Maal%' ";
- if (strlen($p['keyword']) > 0) {
- if ($p['keyword'] != '') {
- $query .= "and ".$p['column']." like '%".$p['keyword']."%'";
- }
- }
- $result['query'] = $this->db->query($query);
- $query = $this->db->query($query);
- if ($query) {
- $result['jumlah_data'] = $query->num_rows();
- $result['data'] = $query->result();
- $result['query'] = $this->db->last_query();
- return $result;
- }else {
- return $this->db->_error_message();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement