shop.balmet.com

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

recurring.php (5169B)

      1 <?php
      2 class ModelCatalogRecurring extends Model {
      3 	public function addRecurring($data) {
      4 		$this->db->query("INSERT INTO `" . DB_PREFIX . "recurring` SET `sort_order` = " . (int)$data['sort_order'] . ", `status` = " . (int)$data['status'] . ", `price` = " . (float)$data['price'] . ", `frequency` = '" . $this->db->escape($data['frequency']) . "', `duration` = " . (int)$data['duration'] . ", `cycle` = " . (int)$data['cycle'] . ", `trial_status` = " . (int)$data['trial_status'] . ", `trial_price` = " . (float)$data['trial_price'] . ", `trial_frequency` = '" . $this->db->escape($data['trial_frequency']) . "', `trial_duration` = " . (int)$data['trial_duration'] . ", `trial_cycle` = '" . (int)$data['trial_cycle'] . "'");
      5 
      6 		$recurring_id = $this->db->getLastId();
      7 
      8 		foreach ($data['recurring_description'] as $language_id => $recurring_description) {
      9 			$this->db->query("INSERT INTO `" . DB_PREFIX . "recurring_description` (`recurring_id`, `language_id`, `name`) VALUES (" . (int)$recurring_id . ", " . (int)$language_id . ", '" . $this->db->escape($recurring_description['name']) . "')");
     10 		}
     11 
     12 		return $recurring_id;
     13 	}
     14 
     15 	public function editRecurring($recurring_id, $data) {
     16 		$this->db->query("DELETE FROM `" . DB_PREFIX . "recurring_description` WHERE recurring_id = '" . (int)$recurring_id . "'");
     17 
     18 		$this->db->query("UPDATE `" . DB_PREFIX . "recurring` SET `price` = '" . (float)$data['price'] . "', `frequency` = '" . $this->db->escape($data['frequency']) . "', `duration` = '" . (int)$data['duration'] . "', `cycle` = '" . (int)$data['cycle'] . "', `sort_order` = '" . (int)$data['sort_order'] . "', `status` = '" . (int)$data['status'] . "', `trial_price` = '" . (float)$data['trial_price'] . "', `trial_frequency` = '" . $this->db->escape($data['trial_frequency']) . "', `trial_duration` = '" . (int)$data['trial_duration'] . "', `trial_cycle` = '" . (int)$data['trial_cycle'] . "', `trial_status` = '" . (int)$data['trial_status'] . "' WHERE recurring_id = '" . (int)$recurring_id . "'");
     19 
     20 		foreach ($data['recurring_description'] as $language_id => $recurring_description) {
     21 			$this->db->query("INSERT INTO `" . DB_PREFIX . "recurring_description` (`recurring_id`, `language_id`, `name`) VALUES (" . (int)$recurring_id . ", " . (int)$language_id . ", '" . $this->db->escape($recurring_description['name']) . "')");
     22 		}
     23 	}
     24 
     25 	public function copyRecurring($recurring_id) {
     26 		$data = $this->getRecurring($recurring_id);
     27 
     28 		$data['recurring_description'] = $this->getRecurringDescription($recurring_id);
     29 
     30 		foreach ($data['recurring_description'] as &$recurring_description) {
     31 			$recurring_description['name'] .= ' - 2';
     32 		}
     33 
     34 		$this->addRecurring($data);
     35 	}
     36 
     37 	public function deleteRecurring($recurring_id) {
     38 		$this->db->query("DELETE FROM `" . DB_PREFIX . "recurring` WHERE recurring_id = " . (int)$recurring_id . "");
     39 		$this->db->query("DELETE FROM `" . DB_PREFIX . "recurring_description` WHERE recurring_id = " . (int)$recurring_id . "");
     40 		$this->db->query("DELETE FROM `" . DB_PREFIX . "product_recurring` WHERE recurring_id = " . (int)$recurring_id . "");
     41 		$this->db->query("UPDATE `" . DB_PREFIX . "order_recurring` SET `recurring_id` = 0 WHERE `recurring_id` = " . (int)$recurring_id . "");
     42 	}
     43 
     44 	public function getRecurring($recurring_id) {
     45 		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "recurring` WHERE recurring_id = '" . (int)$recurring_id . "'");
     46 
     47 		return $query->row;
     48 	}
     49 
     50 	public function getRecurringDescription($recurring_id) {
     51 		$recurring_description_data = array();
     52 
     53 		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "recurring_description` WHERE `recurring_id` = '" . (int)$recurring_id . "'");
     54 
     55 		foreach ($query->rows as $result) {
     56 			$recurring_description_data[$result['language_id']] = array('name' => $result['name']);
     57 		}
     58 
     59 		return $recurring_description_data;
     60 	}
     61 
     62 	public function getRecurrings($data = array()) {
     63 		$sql = "SELECT * FROM `" . DB_PREFIX . "recurring` r LEFT JOIN " . DB_PREFIX . "recurring_description rd ON (r.recurring_id = rd.recurring_id) WHERE rd.language_id = '" . (int)$this->config->get('config_language_id') . "'";
     64 
     65 		if (!empty($data['filter_name'])) {
     66 			$sql .= " AND rd.name LIKE '" . $this->db->escape($data['filter_name']) . "%'";
     67 		}
     68 
     69 		$sort_data = array(
     70 			'rd.name',
     71 			'r.sort_order'
     72 		);
     73 
     74 		if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
     75 			$sql .= " ORDER BY " . $data['sort'];
     76 		} else {
     77 			$sql .= " ORDER BY rd.name";
     78 		}
     79 
     80 		if (isset($data['order']) && ($data['order'] == 'DESC')) {
     81 			$sql .= " DESC";
     82 		} else {
     83 			$sql .= " ASC";
     84 		}
     85 
     86 		if (isset($data['start']) || isset($data['limit'])) {
     87 			if ($data['start'] < 0) {
     88 				$data['start'] = 0;
     89 			}
     90 
     91 			if ($data['limit'] < 1) {
     92 				$data['limit'] = 20;
     93 			}
     94 
     95 			$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
     96 		}
     97 
     98 		$query = $this->db->query($sql);
     99 
    100 		return $query->rows;
    101 	}
    102 
    103 	public function getTotalRecurrings() {
    104 		$query = $this->db->query("SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "recurring`");
    105 
    106 		return $query->row['total'];
    107 	}
    108 }