PageRenderTime 35ms CodeModel.GetById 9ms RepoModel.GetById 1ms app.codeStats 0ms

/catalog/model/affiliate/affiliate.php

https://bitbucket.org/monobasic/shop.volero.ch
PHP | 63 lines | 50 code | 13 blank | 0 comment | 0 complexity | 190343e778f7f48712cbda956b2cef67 MD5 | raw file
  1. <?php
  2. class ModelAffiliateAffiliate extends Model {
  3. public function addAffiliate($data) {
  4. $this->db->query("INSERT INTO " . DB_PREFIX . "affiliate SET firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', email = '" . $this->db->escape($data['email']) . "', telephone = '" . $this->db->escape($data['telephone']) . "', fax = '" . $this->db->escape($data['fax']) . "', password = '" . $this->db->escape(md5($data['password'])) . "', company = '" . $this->db->escape($data['company']) . "', address_1 = '" . $this->db->escape($data['address_1']) . "', address_2 = '" . $this->db->escape($data['address_2']) . "', city = '" . $this->db->escape($data['city']) . "', postcode = '" . $this->db->escape($data['postcode']) . "', country_id = '" . (int)$data['country_id'] . "', zone_id = '" . (int)$data['zone_id'] . "', code = '" . $this->db->escape(uniqid()) . "', commission = '" . (float)$this->config->get('config_commission') . "', tax = '" . $this->db->escape($data['tax']) . "', payment = '" . $this->db->escape($data['payment']) . "', cheque = '" . $this->db->escape($data['cheque']) . "', paypal = '" . $this->db->escape($data['paypal']) . "', bank_name = '" . $this->db->escape($data['bank_name']) . "', bank_branch_number = '" . $this->db->escape($data['bank_branch_number']) . "', bank_swift_code = '" . $this->db->escape($data['bank_swift_code']) . "', bank_account_name = '" . $this->db->escape($data['bank_account_name']) . "', bank_account_number = '" . $this->db->escape($data['bank_account_number']) . "', status = '1', date_added = NOW()");
  5. $this->language->load('mail/affiliate');
  6. $subject = sprintf($this->language->get('text_subject'), $this->config->get('config_name'));
  7. $message = sprintf($this->language->get('text_welcome'), $this->config->get('config_name')) . "\n\n";
  8. $message .= $this->language->get('text_approval') . "\n";
  9. $message .= $this->url->link('affiliate/login', '', 'SSL') . "\n\n";
  10. $message .= $this->language->get('text_services') . "\n\n";
  11. $message .= $this->language->get('text_thanks') . "\n";
  12. $message .= $this->config->get('config_name');
  13. $mail = new Mail();
  14. $mail->protocol = $this->config->get('config_mail_protocol');
  15. $mail->parameter = $this->config->get('config_mail_parameter');
  16. $mail->hostname = $this->config->get('config_smtp_host');
  17. $mail->username = $this->config->get('config_smtp_username');
  18. $mail->password = $this->config->get('config_smtp_password');
  19. $mail->port = $this->config->get('config_smtp_port');
  20. $mail->timeout = $this->config->get('config_smtp_timeout');
  21. $mail->setTo($this->request->post['email']);
  22. $mail->setFrom($this->config->get('config_email'));
  23. $mail->setSender($this->config->get('config_name'));
  24. $mail->setSubject($subject);
  25. $mail->setText($message);
  26. $mail->send();
  27. }
  28. public function editAffiliate($data) {
  29. $this->db->query("UPDATE " . DB_PREFIX . "affiliate SET firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', email = '" . $this->db->escape($data['email']) . "', telephone = '" . $this->db->escape($data['telephone']) . "', fax = '" . $this->db->escape($data['fax']) . "', company = '" . $this->db->escape($data['company']) . "', address_1 = '" . $this->db->escape($data['address_1']) . "', address_2 = '" . $this->db->escape($data['address_2']) . "', city = '" . $this->db->escape($data['city']) . "', postcode = '" . $this->db->escape($data['postcode']) . "', country_id = '" . (int)$data['country_id'] . "', zone_id = '" . (int)$data['zone_id'] . "' WHERE affiliate_id = '" . (int)$this->affiliate->getId() . "'");
  30. }
  31. public function editPayment($data) {
  32. $this->db->query("UPDATE " . DB_PREFIX . "affiliate SET tax = '" . $this->db->escape($data['tax']) . "', payment = '" . $this->db->escape($data['payment']) . "', cheque = '" . $this->db->escape($data['cheque']) . "', paypal = '" . $this->db->escape($data['paypal']) . "', bank_name = '" . $this->db->escape($data['bank_name']) . "', bank_branch_number = '" . $this->db->escape($data['bank_branch_number']) . "', bank_swift_code = '" . $this->db->escape($data['bank_swift_code']) . "', bank_account_name = '" . $this->db->escape($data['bank_account_name']) . "', bank_account_number = '" . $this->db->escape($data['bank_account_number']) . "' WHERE affiliate_id = '" . (int)$this->affiliate->getId() . "'");
  33. }
  34. public function editPassword($email, $password) {
  35. $this->db->query("UPDATE " . DB_PREFIX . "affiliate SET password = '" . $this->db->escape(md5($password)) . "' WHERE email = '" . $this->db->escape($email) . "'");
  36. }
  37. public function getAffiliate($affiliate_id) {
  38. $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE affiliate_id = '" . (int)$affiliate_id . "'");
  39. return $query->row;
  40. }
  41. public function getAffiliateByCode($code) {
  42. $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE code = '" . $this->db->escape($code) . "'");
  43. return $query->row;
  44. }
  45. public function getTotalAffiliatesByEmail($email) {
  46. $query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "affiliate WHERE email = '" . $this->db->escape($email) . "'");
  47. return $query->row['total'];
  48. }
  49. }
  50. ?>