PageRenderTime 26ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

/catalog/model/affiliate/affiliate.php

https://gitlab.com/dadangnh/sb1-bon
PHP | 180 lines | 133 code | 45 blank | 2 comment | 10 complexity | ae5621deff68f1b08f2d97f6a2ca132f MD5 | raw file
    

  1. <?php

    2. 

  2. class ModelAffiliateAffiliate extends Model {

    3. 

  3. 	public function addAffiliate($data) {

    4. 

  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']) . "', salt = '" . $this->db->escape($salt = token(9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($data['password'])))) . "', company = '" . $this->db->escape($data['company']) . "', website = '" . $this->db->escape($data['website']) . "', 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_affiliate_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', approved = '" . (int)!$this->config->get('config_affiliate_approval') . "', date_added = NOW()");

    5. 

  5. 

    6. 

  6. 		$affiliate_id = $this->db->getLastId();

    7. 

  7. 

    8. 

  8. 		$this->load->language('mail/affiliate');

    9. 

  9. 

    10. 

  10. 		$subject = sprintf($this->language->get('text_subject'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8'));

    11. 

  11. 

    12. 

  12. 		$message  = sprintf($this->language->get('text_welcome'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8')) . "\n\n";

    13. 

  13. 

    14. 

  14. 		if (!$this->config->get('config_affiliate_approval')) {

    15. 

  15. 			$message .= $this->language->get('text_login') . "\n";

    16. 

  16. 		} else {

    17. 

  17. 			$message .= $this->language->get('text_approval') . "\n";

    18. 

  18. 		}

    19. 

  19. 

    20. 

  20. 		$message .= $this->url->link('affiliate/login', '', true) . "\n\n";

    21. 

  21. 		$message .= $this->language->get('text_services') . "\n\n";

    22. 

  22. 		$message .= $this->language->get('text_thanks') . "\n";

    23. 

  23. 		$message .= html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8');

    24. 

  24. 

    25. 

  25. 		$mail = new Mail();

    26. 

  26. 		$mail->protocol = $this->config->get('config_mail_protocol');

    27. 

  27. 		$mail->parameter = $this->config->get('config_mail_parameter');

    28. 

  28. 		$mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname');

    29. 

  29. 		$mail->smtp_username = $this->config->get('config_mail_smtp_username');

    30. 

  30. 		$mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8');

    31. 

  31. 		$mail->smtp_port = $this->config->get('config_mail_smtp_port');

    32. 

  32. 		$mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout');

    33. 

  33. 

    34. 

  34. 		$mail->setTo($this->request->post['email']);

    35. 

  35. 		$mail->setFrom($this->config->get('config_email'));

    36. 

  36. 		$mail->setSender(html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8'));

    37. 

  37. 		$mail->setSubject($subject);

    38. 

  38. 		$mail->setText($message);

    39. 

  39. 		$mail->send();

    40. 

  40. 

    41. 

  41. 		// Send to main admin email if new affiliate email is enabled

    42. 

  42. 		if (in_array('affiliate', (array)$this->config->get('config_mail_alert'))) {

    43. 

  43. 			$message  = $this->language->get('text_signup') . "\n\n";

    44. 

  44. 			$message .= $this->language->get('text_store') . ' ' . html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8') . "\n";

    45. 

  45. 			$message .= $this->language->get('text_firstname') . ' ' . $data['firstname'] . "\n";

    46. 

  46. 			$message .= $this->language->get('text_lastname') . ' ' . $data['lastname'] . "\n";

    47. 

  47. 

    48. 

  48. 			if ($data['website']) {

    49. 

  49. 				$message .= $this->language->get('text_website') . ' ' . $data['website'] . "\n";

    50. 

  50. 			}

    51. 

  51. 

    52. 

  52. 			if ($data['company']) {

    53. 

  53. 				$message .= $this->language->get('text_company') . ' '  . $data['company'] . "\n";

    54. 

  54. 			}

    55. 

  55. 

    56. 

  56. 			$message .= $this->language->get('text_email') . ' '  .  $data['email'] . "\n";

    57. 

  57. 			$message .= $this->language->get('text_telephone') . ' ' . $data['telephone'] . "\n";

    58. 

  58. 

    59. 

  59. 			$mail->setTo($this->config->get('config_email'));

    60. 

  60. 			$mail->setSubject(html_entity_decode($this->language->get('text_new_affiliate'), ENT_QUOTES, 'UTF-8'));

    61. 

  61. 			$mail->setText($message);

    62. 

  62. 			$mail->send();

    63. 

  63. 

    64. 

  64. 			// Send to additional alert emails if new affiliate email is enabled

    65. 

  65. 			$emails = explode(',', $this->config->get('config_alert_email'));

    66. 

  66. 

    67. 

  67. 			foreach ($emails as $email) {

    68. 

  68. 				if (utf8_strlen($email) > 0 && filter_var($email, FILTER_VALIDATE_EMAIL)) {

    69. 

  69. 					$mail->setTo($email);

    70. 

  70. 					$mail->send();

    71. 

  71. 				}

    72. 

  72. 			}

    73. 

  73. 		}

    74. 

  74. 

    75. 

  75. 		return $affiliate_id;

    76. 

  76. 	}

    77. 

  77. 

    78. 

  78. 	public function editAffiliate($data) {

    79. 

  79. 		$affiliate_id = $this->affiliate->getId();

    80. 

  80. 

    81. 

  81. 		$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']) . "', website = '" . $this->db->escape($data['website']) . "', 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)$affiliate_id . "'");

    82. 

  82. 	}

    83. 

  83. 

    84. 

  84. 	public function editPayment($data) {

    85. 

  85. 		$affiliate_id = $this->affiliate->getId();

    86. 

  86. 

    87. 

  87. 		$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)$affiliate_id . "'");

    88. 

  88. 	}

    89. 

  89. 

    90. 

  90. 	public function editPassword($email, $password) {

    91. 

  91. 		$this->db->query("UPDATE " . DB_PREFIX . "affiliate SET salt = '" . $this->db->escape($salt = token(9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($password)))) . "' WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'");

    92. 

  92. 	}

    93. 

  93. 

    94. 

  94. 	public function getAffiliate($affiliate_id) {

    95. 

  95. 		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE affiliate_id = '" . (int)$affiliate_id . "'");

    96. 

  96. 

    97. 

  97. 		return $query->row;

    98. 

  98. 	}

    99. 

  99. 

    100. 

  100. 	public function getAffiliateByEmail($email) {

    101. 

  101. 		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'");

    102. 

  102. 

    103. 

  103. 		return $query->row;

    104. 

  104. 	}

    105. 

  105. 

    106. 

  106. 	public function getAffiliateByCode($code) {

    107. 

  107. 		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE code = '" . $this->db->escape($code) . "'");

    108. 

  108. 

    109. 

  109. 		return $query->row;

    110. 

  110. 	}

    111. 

  111. 

    112. 

  112. 	public function getTotalAffiliatesByEmail($email) {

    113. 

  113. 		$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "affiliate WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'");

    114. 

  114. 

    115. 

  115. 		return $query->row['total'];

    116. 

  116. 	}

    117. 

  117. 

    118. 

  118. 	public function addTransaction($affiliate_id, $amount = '', $order_id = 0) {

    119. 

  119. 		$affiliate_info = $this->getAffiliate($affiliate_id);

    120. 

  120. 

    121. 

  121. 		if ($affiliate_info) {

    122. 

  122. 			$this->load->language('mail/affiliate');

    123. 

  123. 

    124. 

  124. 			$this->db->query("INSERT INTO " . DB_PREFIX . "affiliate_transaction SET affiliate_id = '" . (int)$affiliate_id . "', order_id = '" . (float)$order_id . "', description = '" . $this->db->escape($this->language->get('text_order_id') . ' #' . $order_id) . "', amount = '" . (float)$amount . "', date_added = NOW()");

    125. 

  125. 

    126. 

  126. 			$affiliate_transaction_id = $this->db->getLastId();

    127. 

  127. 

    128. 

  128. 			$message  = sprintf($this->language->get('text_transaction_received'), $this->currency->format($amount, $this->config->get('config_currency'))) . "\n\n";

    129. 

  129. 			$message .= sprintf($this->language->get('text_transaction_total'), $this->currency->format($this->getTransactionTotal($affiliate_id), $this->config->get('config_currency')));

    130. 

  130. 

    131. 

  131. 			$mail = new Mail();

    132. 

  132. 			$mail->protocol = $this->config->get('config_mail_protocol');

    133. 

  133. 			$mail->parameter = $this->config->get('config_mail_parameter');

    134. 

  134. 			$mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname');

    135. 

  135. 			$mail->smtp_username = $this->config->get('config_mail_smtp_username');

    136. 

  136. 			$mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8');

    137. 

  137. 			$mail->smtp_port = $this->config->get('config_mail_smtp_port');

    138. 

  138. 			$mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout');

    139. 

  139. 

    140. 

  140. 			$mail->setTo($affiliate_info['email']);

    141. 

  141. 			$mail->setFrom($this->config->get('config_email'));

    142. 

  142. 			$mail->setSender(html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8'));

    143. 

  143. 			$mail->setSubject(sprintf($this->language->get('text_transaction_subject'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8')));

    144. 

  144. 			$mail->setText($message);

    145. 

  145. 			$mail->send();

    146. 

  146. 

    147. 

  147. 			return $affiliate_transaction_id;

    148. 

  148. 		}

    149. 

  149. 	}

    150. 

  150. 

    151. 

  151. 	public function deleteTransaction($order_id) {

    152. 

  152. 		$this->db->query("DELETE FROM " . DB_PREFIX . "affiliate_transaction WHERE order_id = '" . (int)$order_id . "'");

    153. 

  153. 	}

    154. 

  154. 

    155. 

  155. 	public function getTransactionTotal($affiliate_id) {

    156. 

  156. 		$query = $this->db->query("SELECT SUM(amount) AS total FROM " . DB_PREFIX . "affiliate_transaction WHERE affiliate_id = '" . (int)$affiliate_id . "'");

    157. 

  157. 

    158. 

  158. 		return $query->row['total'];

    159. 

  159. 	}

    160. 

  160. 	

    161. 

  161. 	public function addLoginAttempt($email) {

    162. 

  162. 		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate_login WHERE email = '" . $this->db->escape(utf8_strtolower((string)$email)) . "' AND ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "'");

    163. 

  163. 

    164. 

  164. 		if (!$query->num_rows) {

    165. 

  165. 			$this->db->query("INSERT INTO " . DB_PREFIX . "affiliate_login SET email = '" . $this->db->escape(utf8_strtolower((string)$email)) . "', ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "', total = 1, date_added = '" . $this->db->escape(date('Y-m-d H:i:s')) . "', date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "'");

    166. 

  166. 		} else {

    167. 

  167. 			$this->db->query("UPDATE " . DB_PREFIX . "affiliate_login SET total = (total + 1), date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "' WHERE affiliate_login_id = '" . (int)$query->row['affiliate_login_id'] . "'");

    168. 

  168. 		}

    169. 

  169. 	}

    170. 

  170. 

    171. 

  171. 	public function getLoginAttempts($email) {

    172. 

  172. 		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "affiliate_login` WHERE email = '" . $this->db->escape(utf8_strtolower($email)) . "'");

    173. 

  173. 

    174. 

  174. 		return $query->row;

    175. 

  175. 	}

    176. 

  176. 

    177. 

  177. 	public function deleteLoginAttempts($email) {

    178. 

  178. 		$this->db->query("DELETE FROM `" . DB_PREFIX . "affiliate_login` WHERE email = '" . $this->db->escape(utf8_strtolower($email)) . "'");

    179. 

  179. 	}	

    180. 

  180. }
    181.