<?php 


class Application extends CI_Model
{
    public function __construct() {
        parent::__construct();
    }

    public function record_count() {
        return $this->db->count_all("career_application_tb");
    }

    public function fetch_application($limit, $start) {
    	
        $this->db->limit($limit, $start);
        $query = $this->db->get("career_application_tb")->result_array();

        return $query;
   }
   
   public function volunteer_app_record_count() {
        return $this->db->count_all("volunteer_application");
    }

    public function volunteer_application($limit, $start) {
    	$this->db->order_by("v_id","desc");
        $this->db->limit($limit, $start);
        $query = $this->db->get("volunteer_application")->result_array();

        return $query;
   }
   
   public function medical_app_record_count() {
        return $this->db->count_all("medical_elective_tb");
    }

    public function medical_application($limit, $start) {
    	$this->db->order_by("mid","desc");
        $this->db->limit($limit, $start);
        $query = $this->db->get("medical_elective_tb")->result_array();

        return $query;
   }
   
    public function subscribers_record_count() {
        return $this->db->count_all("subscribers_tb");
    }

    public function subscribers($limit, $start) {
    	$this->db->order_by("id","desc");
        $this->db->limit($limit, $start);
        $query = $this->db->get("subscribers_tb")->result_array();

        return $query;
   }
   
   public function reportsrecord_count() {
        return $this->db->count_all("downloaded_users_tb");
    }

    public function reports_users($limit, $start) {
    	$this->db->order_by("user_id","desc");
        $this->db->limit($limit, $start);
        $query = $this->db->get("downloaded_users_tb")->result_array();

        return $query;
   }
}