diff options
Diffstat (limited to 'public/admin/model/extension/openbay/ebay_template.php')
| -rw-r--r-- | public/admin/model/extension/openbay/ebay_template.php | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/public/admin/model/extension/openbay/ebay_template.php b/public/admin/model/extension/openbay/ebay_template.php new file mode 100644 index 0000000..b367059 --- /dev/null +++ b/public/admin/model/extension/openbay/ebay_template.php @@ -0,0 +1,51 @@ +<?php +class ModelExtensionOpenBayEbayTemplate extends Model { + public function add($data) { + $this->db->query("INSERT INTO `" . DB_PREFIX . "ebay_template` SET `name` = '" . $this->db->escape($data['name']) . "', `html` = '" . $this->db->escape($data['html']) . "'"); + return $this->db->getLastId(); + } + + public function edit($id, $data) { + $this->db->query("UPDATE `" . DB_PREFIX . "ebay_template` SET `name` = '" . $this->db->escape($data['name']) . "', `html` = '" . $this->db->escape($data['html']) . "' WHERE `template_id` = '" . (int)$id . "' LIMIT 1"); + } + + public function delete($id) { + $qry = $this->db->query("DELETE FROM `" . DB_PREFIX . "ebay_template` WHERE `template_id` = '" . (int)$id . "' LIMIT 1"); + + if ($qry->countAffected() > 0) { + return true; + }else{ + return false; + } + } + + public function get($id) { + $qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "ebay_template` WHERE `template_id` = '" . (int)$id . "' LIMIT 1"); + + if ($qry->num_rows) { + $row = $qry->row; + $row['link_edit'] = $this->url->link('extension/openbay/ebay_template/edit&user_token=' . $this->session->data['user_token'] . '&template_id=' . $row['template_id'], true); + $row['link_delete'] = $this->url->link('extension/openbay/ebay_template/delete&user_token=' . $this->session->data['user_token'] . '&template_id=' . $row['template_id'], true); + + return $row; + }else{ + return false; + } + } + + public function getAll() { + $qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "ebay_template`"); + + $templates = array(); + + if($qry->num_rows) { + foreach($qry->rows as $row) { + $row['link_edit'] = $this->url->link('extension/openbay/ebay_template/edit&user_token=' . $this->session->data['user_token'] . '&template_id=' . $row['template_id'], true); + $row['link_delete'] = $this->url->link('extension/openbay/ebay_template/delete&user_token=' . $this->session->data['user_token'] . '&template_id=' . $row['template_id'], true); + $templates[] = $row; + } + } + + return $templates; + } +} |