Invoice_m.php

function cek_status_tagihan()
        {
            $que = "SELECT * FROM member_trans JOIN invoice ON member_trans.trans_id = invoice.trans_id";
            $query = $this->db->query($que);
            $st = array();
            if ($query->num_rows() > 0) {
                foreach ($query->result() as $q) {
                    if ($q->kd_invoice != null && $q->kd_invoice != '') {
                        $st[$q->trans_id] = "aktif";
                    } else {
                        $st[$q->trans_id] = "tidak aktif";
                    }
                }
            }

            return $st;
        }