<?php
class ControllerAccountFeedback extends Controller {
	private $error = array();

	public function index() {
		if (!$this->customer->isLogged()) {
			if(isset($_GET['sid'])){ 
				$this->session->data['redirect'] = $this->url->link('account/feedback', 'sid=' . $_GET["sid"], 'SSL'); 
			}else{
				$this->session->data['redirect'] = $this->url->link('account/feedback', '', 'SSL');
			}
			$this->redirect($this->url->link('account/login', '', 'SSL'));
		}

		$this->language->load('account/feedback');
		
		$this->document->setTitle($this->language->get('heading_title'));
		
		$this->load->model('account/customer');
		
		if (($this->request->server['REQUEST_METHOD'] == 'POST')) {
			$this->model_account_customer->add_sketch_content($this->request->post);
			
			$sid_url = $_GET['sid'];
			
			$mailcmd = $this->db->query("SELECT d.email,d.dispname,sm.sketch_id from " . DB_PREFIX . "designer d," . DB_PREFIX . "sketches_master sm where d.designer_id = sm.designer_id and sm.sketch_id = '" . (int)$sid_url  . "'");
			
			$link = HTTP_SERVER.'index.php?route=desaccount/feedback&sid='.$mailcmd->row['sketch_id'];
			
			if($mailcmd->num_rows != 0)
			{
			$storelogo = $this->db->query("SELECT value FROM `contest_sketch_assignment` a, contest_master b , setting c where a.contest_id=b.contest_id and a.sketch_id=" .  (int)$sid_url  . " and c.`key` = 'config_logo' and c.store_id=b.store_id limit 1 ");
			
//			$message = "<img src='http://tresorjewellery.com.au/image/data/logo/logo.jpg' /><br><br>";
			$message = "<img src='".HTTP_SERVER."\image\\" . $storelogo->row['value'] . "' /><br><br>";			
			
			$message .= 'Hi '.$mailcmd->row['dispname'] . ',<br><br>';
			
			$message .= $this->customer->getFirstName() . "&nbsp;&nbsp;" .'just gave you feedback on design#'.$mailcmd->row['sketch_id'].'<br><br>';
			
			$message .= 'View the comment and reply.' . "&nbsp;&nbsp;" . $link . '<br><br>';
			
			$message .= 'Regards <br><br>';
			$message .= 'Customer Service Team <br><br>';
			
			
			$mail = new Mail();
			$mail->protocol = $this->config->get('config_mail_protocol');
			$mail->parameter = $this->config->get('config_mail_parameter');
			$mail->hostname = $this->config->get('config_smtp_host');
			$mail->username = $this->config->get('config_smtp_username');
			$mail->password = $this->config->get('config_smtp_password');
			$mail->port = $this->config->get('config_smtp_port');
			$mail->timeout = $this->config->get('config_smtp_timeout');				
			$mail->setTo($mailcmd->row['email']);
	  		$mail->setFrom($this->config->get('config_email'));
	  		$mail->setSender($this->config->get('config_name')); 
	  		$mail->setSubject(sprintf('Feedback from customer'));
	  		$mail->setHtml((html_entity_decode($message, ENT_QUOTES, 'UTF-8')));
      		$mail->send();
			
			
			$this->session->data['success'] = $this->language->get('text_success');

			//$this->redirect($this->url->link('account/overall', '', 'SSL'));
			$this->url->link('account/feedback', 'sid=' . $_GET["sid"], 'SSL');
		}
		}

      	$this->data['breadcrumbs'] = array();

      	$this->data['breadcrumbs'][] = array(
        	'text'      => $this->language->get('text_home'),
			'href'      => $this->url->link('common/home'),     	
        	'separator' => false
      	); 

      	$this->data['breadcrumbs'][] = array(
        	'text'      => $this->language->get('text_account'),
			'href'      => $this->url->link('account/account', '', 'SSL'),        	
        	'separator' => $this->language->get('text_separator')
      	);

      	$this->data['breadcrumbs'][] = array(
        	'text'      => $this->language->get('text_edit'),
			'href'      => $this->url->link('account/feedback', '', 'SSL'),       	
        	'separator' => $this->language->get('text_separator')
      	);
		
		$this->data['heading_title'] = $this->language->get('heading_title');
		

		$this->data['text_your_details'] = $this->language->get('text_your_details');

		$this->data['entry_firstname'] = $this->language->get('entry_firstname');
		$this->data['entry_lastname'] = $this->language->get('entry_lastname');
		$this->data['entry_email'] = $this->language->get('entry_email');
		$this->data['entry_fax'] = $this->language->get('entry_fax');
		$this->data['entry_password'] = $this->language->get('entry_password');
    	$this->data['entry_confirm'] = $this->language->get('entry_confirm');
    	$this->data['entry_dispname'] = $this->language->get('entry_dispname');
    	$this->data['entry_profpic'] = $this->language->get('entry_profpic');
		$this->data['text_browse'] = $this->language->get('text_browse');
		$this->data['text_clear'] = $this->language->get('text_clear');	
		$this->data['entry_gender'] = $this->language->get('entry_gender');	
		$this->data['text_male'] = $this->language->get('text_male');	
		$this->data['text_female'] = $this->language->get('text_female');	
		$this->data['text_english'] = $this->language->get('text_english');	
		$this->data['text_french'] = $this->language->get('text_french');	
		$this->data['text_italin'] = $this->language->get('text_italin');	
		$this->data['entry_yourself'] = $this->language->get('entry_yourself');	
		$this->data['entry_langknown'] = $this->language->get('entry_langknown');	
		$this->data['text_image_manager'] = $this->language->get('text_image_manager');
		$this->data['text_cheque'] = $this->language->get('text_cheque');
		$this->data['text_paypal'] = $this->language->get('text_paypal');
		$this->data['text_money'] = $this->language->get('text_money');
		$this->data['text_bank'] = $this->language->get('text_bank');
		$this->data['entry_paypalemail'] = $this->language->get('entry_paypalemail');

		$this->data['button_continue'] = $this->language->get('button_continue');
		$this->data['button_back'] = $this->language->get('button_back');

		if (isset($this->error['warning'])) {
			$this->data['error_warning'] = $this->error['warning'];
		} else {
			$this->data['error_warning'] = '';
		}

		if (isset($this->error['firstname'])) {
			$this->data['error_firstname'] = $this->error['firstname'];
		} else {
			$this->data['error_firstname'] = '';
		}

		if (isset($this->error['lastname'])) {
			$this->data['error_lastname'] = $this->error['lastname'];
		} else {
			$this->data['error_lastname'] = '';
		}
		
		if (isset($this->error['email'])) {
			$this->data['error_email'] = $this->error['email'];
		} else {
			$this->data['error_email'] = '';
		}	
	
		
		if (isset($this->error['password'])) { 
			$this->data['error_password'] = $this->error['password'];
		} else {
			$this->data['error_password'] = '';
		}

		if (isset($this->error['confirm'])) { 
			$this->data['error_confirm'] = $this->error['confirm'];
		} else {
			$this->data['error_confirm'] = '';
		}

		$this->data['action'] = $this->url->link('account/feedback', 'sid=' . $_GET["sid"], 'SSL');
		
		$this->data['selected_sketchid'] = $_GET["sid"];
		
		$this->data['customer_id'] = $this->customer->getid();
		
		$this->load->model('account/customer');
		
		$this->data['customer_name'] = $this->model_account_customer->getcustomername($this->data['customer_id']);
		
		$this->data['passing_sketchids'] = array();
		
		$this->load->model('account/customer');
		$this->load->model('tool/image');
		
		$results = $this->model_account_customer->getsinglesketches($this->data['selected_sketchid']);
		
		foreach ($results as $result) {
		
			if ($result['image']) {
				$image = $this->model_tool_image->resize($result['image'], 400, 400);
			} else {
				$image = false;
			}
			
			$this->data['designer_email'] = $this->model_account_customer->getdesigneremail($result['designer_id']);
			
			$this->data['passing_sketchids'][] = array(
					'designer_id'  => $result['designer_id'],
					'sketch_assg_id'  =>	$this->model_account_customer->get_sketch_assg_id($this->data['selected_sketchid']),
					'designer_name'  => $this->model_account_customer->getdesignername($result['designer_id']),
					'thumb'       => $image
				);
		}
		
		$this->data['passing_comments'] = array();
		
		$this->data['sketch_assignment_id'] = $this->model_account_customer->get_sketch_assg_id($this->data['selected_sketchid']);
		
		$results = $this->model_account_customer->get_feedback_comments($this->data['sketch_assignment_id']);
		foreach ($results as $result) {
			
			$this->data['passing_comments'][] = array(
					'name'  => $result['name'],
					'is_customer'  => $result['is_customer'],
					'creation_date_time'  => $result['creation_date_time'],
					'comment'  => $result['comment']
				);
		}
				
		if (isset($this->request->post['comment'])) {
    		$this->data['comment'] = $this->request->post['comment'];
		} else {
			$this->data['comment'] = '';
		}
		
				
		if (isset($this->request->post['sketch_assignment_id'])) {
    		$this->data['sketch_assignment_id'] = $this->request->post['sketch_assignment_id'];
		} else {
			$this->data['sketch_assignment_id'] = '';
		}
		
				
		if (isset($this->request->post['name'])) {
    		$this->data['name'] = $this->request->post['name'];
		} else {
			$this->data['name'] = '';
		}
		

		if ($this->request->server['REQUEST_METHOD'] != 'POST') {
			$customer_info = $this->model_account_customer->getCustomer($this->customer->getId());
		}

		if (isset($this->request->post['firstname'])) {
			$this->data['firstname'] = $this->request->post['firstname'];
		} elseif (isset($customer_info)) {
			$this->data['firstname'] = $customer_info['firstname'];
		} else {
			$this->data['firstname'] = '';
		}

		if (isset($this->request->post['lastname'])) {
			$this->data['lastname'] = $this->request->post['lastname'];
		} elseif (isset($customer_info)) {
			$this->data['lastname'] = $customer_info['lastname'];
		} else {
			$this->data['lastname'] = '';
		}

		if (isset($this->request->post['email'])) {
			$this->data['email'] = $this->request->post['email'];
		} elseif (isset($customer_info)) {
			$this->data['email'] = $customer_info['email'];
		} else {
			$this->data['email'] = '';
		}

		if (isset($this->request->post['newsletter'])) {
			$this->data['newsletter'] = $this->request->post['newsletter'];
		} else {
			$this->data['newsletter'] = '';
		}
		
		if (isset($this->request->post['password'])) {
    		$this->data['password'] = $this->request->post['password'];
		} else {
			$this->data['password'] = '';
		}

		if (isset($this->request->post['confirm'])) {
    		$this->data['confirm'] = $this->request->post['confirm'];
		} else {
			$this->data['confirm'] = '';
		}
		
		// address Starts
		
		$this->data['button_edit'] = $this->language->get('button_edit');
		$this->data['entry_newsletter'] = $this->language->get('entry_newsletter');
    	$this->data['button_delete'] = $this->language->get('button_delete');
		
		$this->data['addresses'] = array();
		$this->load->model('account/address');
		$results = $this->model_account_address->getAddresses();

    	foreach ($results as $result) {
			if ($result['address_format']) {
      			$format = $result['address_format'];
    		} else {
				$format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}';
			}
		
    		$find = array(
	  			'{firstname}',
	  			'{lastname}',
	  			'{company}',
      			'{address_1}',
      			'{address_2}',
     			'{city}',
      			'{postcode}',
      			'{zone}',
				'{zone_code}',
      			'{country}'
			);
	
			$replace = array(
	  			'firstname' => $result['firstname'],
	  			'lastname'  => $result['lastname'],
	  			'company'   => $result['company'],
      			'address_1' => $result['address_1'],
      			'address_2' => $result['address_2'],
      			'city'      => $result['city'],
      			'postcode'  => $result['postcode'],
      			'zone'      => $result['zone'],
				'zone_code' => $result['zone_code'],
      			'country'   => $result['country']  
			);

      		$this->data['addresses'][] = array(
        		'address_id' => $result['address_id'],
        		'address'    => str_replace(array("\r\n", "\r", "\n"), '<br />', preg_replace(array("/\s\s+/", "/\r\r+/", "/\n\n+/"), '<br />', trim(str_replace($find, $replace, $format)))),
        		'update'     => $this->url->link('account/address/update', 'address_id=' . $result['address_id'], 'SSL'),
				'delete'     => $this->url->link('account/address/delete', 'address_id=' . $result['address_id'], 'SSL')
      		);
    	}
		
		$this->data['newsletter'] = $this->customer->getNewsletter();
		$this->data['text_yes'] = $this->language->get('text_yes');
		$this->data['text_no'] = $this->language->get('text_no');
		
		// address Ends

		$this->data['back'] = $this->url->link('account/account', '', 'SSL');

		if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/account/feedback.tpl')) {
			$this->template = $this->config->get('config_template') . '/template/account/feedback.tpl';
		} else {
			$this->template = 'default/template/account/feedback.tpl';
		}
		
		$this->children = array(
			'common/column_left',
			'common/column_right',
			'common/content_top',
			'common/content_bottom',
			'common/footer',
			'common/header'	
		);
						
		$this->response->setOutput($this->render());	
	}

	private function validate() {
		if ((utf8_strlen($this->request->post['firstname']) < 1) || (utf8_strlen($this->request->post['firstname']) > 32)) {
			$this->error['firstname'] = $this->language->get('error_firstname');
		}

		if ((utf8_strlen($this->request->post['lastname']) < 1) || (utf8_strlen($this->request->post['lastname']) > 32)) {
			$this->error['lastname'] = $this->language->get('error_lastname');
		}

		if ((utf8_strlen($this->request->post['email']) > 96) || !preg_match('/^[^\@]+@.*\.[a-z]{2,6}$/i', $this->request->post['email'])) {
			$this->error['email'] = $this->language->get('error_email');
		}
		
		if (($this->customer->getEmail() != $this->request->post['email']) && $this->model_account_customer->getTotalCustomersByEmail($this->request->post['email'])) {
			$this->error['warning'] = $this->language->get('error_exists');
		}


		if (!$this->error) {
			return true;
		} else {
			return false;
		}
	}
}
?>