Model

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 ($query) {
                # code...
                $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();
        }


    }