<?php
	Class Controller_Front_Newsletter extends GeneralAction {
		function beforeExec() {
			parent::beforeExec();
			parent::$moduleName = "Newsletter";
			parent::$isAdmin = false;
			parent::$btnAction = true;
			parent::$mapping = parent::generateMapping("Newsletter");
							
			parent::$prefix = "nlet";
			parent::$table = "newsletter";
			parent::$pathupload = "../Assets/img/";
		}
		protected function do_show() {
			parent::do_show("/Templates/Admin/default1Grid.html");
		}
		protected function do_save($post = false, $createTimeBy = false) {
			$cekEmail = Database::build()->getAllDbOne("SELECT nletEmail FROM newsletter WHERE LOWER(nletEmail) = '".strtolower($_POST['txtEmail'])."'");
			if(empty($cekEmail['nletEmail'])) {
				$post = $_POST + array("slStatus" => 0);
				$save = parent::do_save($post);
				return $save;
			}else{
				return array("status" => "error", "error" => array("The email you are using is already registered"));
			}
		}
		
		protected function do_update($post = false, $id = false) {
			$cekEmail = Database::build()->getAllDbOne("SELECT nletEmail FROM newsletter WHERE nletId != '".$_POST['txtId']."' AND LOWER(nletEmail) = '".strtolower($_POST['txtEmail'])."'");
			if(empty($cekEmail['nletEmail'])) {
				$save = parent::do_update();
				return $save;
			}else{
				return array("status" => "error", "error" => array("The email you are using is already registered"));
			}
		}
	}