1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / wavoo / nirvakam / model / setting /
Filename : wavoo.php
back
<?php
class ModelSettingWavoo extends Model {


	public function get_total_gold_rates() {

		$sql = "select rate_date from oc_wv_gold_rates group by rate_date, timing";

		$query = $this->db->query($sql);

		return count($query->rows);

	}

	public function get_gold_rates($data = array()) {

		$sql = "select * from oc_wv_gold_rates";


		$implode = array();

		
		if (!empty($data['filter_date'])) {
			$implode[] = "rate_date = '".$this->db->escape($data['filter_date'])."'";
		}

		if ($implode) {
			$sql .= " WHERE " . implode(" AND ", $implode);
		}

		$sql .= " order by rate_date desc";


		/*if (isset($data['start']) || isset($data['limit'])) {
			if ($data['start'] < 0) {
				$data['start'] = 0;
			}

			if ($data['limit'] < 1) {
				$data['limit'] = 20;
			}

			$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
		}*/





		$query = $this->db->query($sql);

		return $query->rows;
	}

	

	public function update_price_details($rate_date, $type, $amount, $timing = 1) {
		$this->db->query("INSERT INTO `" . DB_PREFIX . "wv_gold_rates` (rate_date, type, amount, timing) VALUES('$rate_date', '$type', '$amount', '$timing') ON DUPLICATE KEY UPDATE amount='$amount'");
	}


	public function get_price_details($rate_date, $timing = 1) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_gold_rates` WHERE `rate_date` = '" . $rate_date . "' and timing = $timing");

		return $query->rows;
	}

	public function get_price_details_by_type($rate_date, $type, $timing = 1) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_gold_rates` WHERE `rate_date` = '" . $rate_date . "' and type = $type and timing = $timing");

		if(isset($query->row['amount']))
			return $query->row['amount'];
		else
			return "0";
	}



	public function create_new_scheme_details($customer_id, $group_name, $amount, $customer_name = '', $address = '', $createdTime) {
		//$this->db->query("INSERT INTO `" . DB_PREFIX . "wv_saving_scheme` (customer_id, group_name, amount, status, createdTime) VALUES('$customer_id', '$group_name', '$amount', '1', '$createdTime')");

		$this->db->query("INSERT INTO `" . DB_PREFIX . "wv_saving_scheme` (customer_id, group_name, amount, customer_name, address, status, createdTime) VALUES('$customer_id', '$group_name', '$amount', '$customer_name', '$address', '1', '$createdTime')");

		return $scheme_id = $this->db->getLastId();
	}


	public function get_scheme_members($data = array()) {

		$sql = "select * from oc_wv_saving_scheme s, oc_customer c where c.customer_id = s.customer_id and s.status = 1";


		$implode = array();

		if (!empty($data['filter_name'])) {
			$implode[] = "CONCAT(c.firstname, ' ', c.lastname) LIKE '%" . $this->db->escape($data['filter_name']) . "%'";
		}
		if (!empty($data['filter_membership'])) {
			$implode[] = "s.scheme_id = '".$this->db->escape($data['filter_membership'])."'";
		}
		if (!empty($data['filter_group'])) {
			$implode[] = "s.group_name = '".$this->db->escape($data['filter_group'])."'";
		}
		if (!empty($data['filter_amount'])) {
			$implode[] = "s.amount = '".$this->db->escape($data['filter_amount'])."'";
		}

		if ($implode) {
			$sql .= " and " . implode(" AND ", $implode);
		}


		if (isset($data['start']) || isset($data['limit'])) {
			if ($data['start'] < 0) {
				$data['start'] = 0;
			}

			if ($data['limit'] < 1) {
				$data['limit'] = 20;
			}

			$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
		}


		$query = $this->db->query($sql);

		return $query->rows;
	}

	public function get_total_scheme_members() {
		$query = $this->db->query("select count(*) as total from oc_wv_saving_scheme where status = 1");

		return $query->row['total'];
	}

	public function get_scheme_amount_by_id($scheme_id) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_saving_scheme` WHERE `scheme_id` = '" . $scheme_id . "'");

		return $query->row['amount'];
	}


	public function get_scheme_payment_by_id($scheme_id) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_saving_scheme_payment` WHERE `scheme_id` = '" . $scheme_id . "' and status = 1 order by payment_id asc");

		return $query->rows;
	}
	public function get_total_scheme_payment_by_id($scheme_id) {
		$query = $this->db->query("SELECT count(*) as total FROM `" . DB_PREFIX . "wv_saving_scheme_payment` WHERE `scheme_id` = '" . $scheme_id . "' and status = 1 order by payment_id asc");

		return $query->row['total'];
	}


	public function get_month_payment_details($scheme_id, $month, $year) {
		$query = $this->db->query("SELECT count(*) as total FROM `" . DB_PREFIX . "wv_saving_scheme_payment` WHERE `scheme_id` = '" . $scheme_id . "' and MONTH(payment_date) = '$month' and YEAR(payment_date) = '$year' and status = 1");

		return $query->row['total'];
	}


	public function get_scheme_by_scheme_id($scheme_id) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_saving_scheme` WHERE `scheme_id` = '" . (int)$scheme_id . "' and status = 1 order by scheme_id asc");

		return $query->row;
	}

	public function get_last_payment_by_scheme_id($scheme_id) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_saving_scheme_payment` WHERE `scheme_id` = '" . (int)$scheme_id . "' and status = 1 order by payment_date desc");

		if(isset($query->row['payment_date']))
			return $query->row['payment_date'];
		else
			return false;
	}

	public function get_payment_by_payment_id($payment_id) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "wv_saving_scheme_payment` WHERE `payment_id` = '" . (int)$payment_id . "' and status = 1");

		return $query->row;
	}



	public function create_scheme_payment($scheme_id, $gold_rate, $grams, $payment_date, $payment_amount, $payment_mode, $transaction_details, $status, $createdBy, $createdTime) {
		$this->db->query("INSERT INTO `" . DB_PREFIX . "wv_saving_scheme_payment` (`scheme_id`, `gold_rate`, `grams`, `payment_date`, `payment_amount`, `payment_mode`, `transaction_details`, `status`, `createdBy`, `createdTime`) VALUES('$scheme_id',  ' $gold_rate',  ' $grams',  ' $payment_date', '$payment_amount', ' $payment_mode',  '$transaction_details', '$status',  ' $createdBy',  ' $createdTime')");


		return $payment_id = $this->db->getLastId();
	}

	
}