PHP Dosya Yöneticisi

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

public function index() {
		$this->load->language('emticket/tickets');

$this->document->setTitle($this->language->get('heading_title'));

$this->load->model('emticket/tickets');

$this->getList();
	}
	
	public function add() {
		$this->load->language('emticket/tickets');

$this->document->setTitle($this->language->get('heading_title'));

$this->load->model('emticket/tickets');

if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validateForm()) {
			
			//echo "<pre>";
			//print_r($this->request->post);die();
		
			$this->model_emticket_tickets->addTicket($this->request->post);

$this->session->data['success'] = $this->language->get('text_success');

$url = '';

if (isset($this->request->get['sort'])) {
				$url .= '&sort=' . $this->request->get['sort'];
			}

if (isset($this->request->get['order'])) {
				$url .= '&order=' . $this->request->get['order'];
			}

if (isset($this->request->get['page'])) {
				$url .= '&page=' . $this->request->get['page'];
			}

$this->response->redirect($this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . $url, true));
		}

$this->getForm();
	}

public function edit() {
		$this->load->language('emticket/tickets');

$this->document->setTitle($this->language->get('heading_title'));

$this->load->model('emticket/tickets');
		
		if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validateForm()) {
			
			
			//print_r($this->request->post);die();
			
			$this->model_emticket_tickets->editTicket($this->request->get['ticket_id'], $this->request->post);

$this->session->data['success'] = $this->language->get('text_success');

$url = '';

if (isset($this->request->get['sort'])) {
				$url .= '&sort=' . $this->request->get['sort'];
			}

if (isset($this->request->get['order'])) {
				$url .= '&order=' . $this->request->get['order'];
			}

if (isset($this->request->get['page'])) {
				$url .= '&page=' . $this->request->get['page'];
			}

$this->response->redirect($this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . $url, true));
		}

$this->getForm();
	}

public function delete() {
		$this->load->language('emticket/tickets');

$this->document->setTitle($this->language->get('heading_title'));

$this->load->model('emticket/tickets');

if (isset($this->request->post['selected']) && $this->validateDelete()) {
			foreach ($this->request->post['selected'] as $department_id) {
				$this->model_emticket_tickets->deleteTicket($department_id);
			}

$this->session->data['success'] = $this->language->get('text_success');

$url = '';

if (isset($this->request->get['sort'])) {
				$url .= '&sort=' . $this->request->get['sort'];
			}

if (isset($this->request->get['order'])) {
				$url .= '&order=' . $this->request->get['order'];
			}

if (isset($this->request->get['page'])) {
				$url .= '&page=' . $this->request->get['page'];
			}

$this->response->redirect($this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . $url, true));
		}

$this->getList();
	}

protected function getList() {
		
		if (isset($this->request->get['filter_email'])) {
			$filter_email = $this->request->get['filter_email'];
		} else {
			$filter_email = null;
		}

if (isset($this->request->get['filter_ticket_id'])) {
			$filter_ticket_id = $this->request->get['filter_ticket_id'];
		} else {
			$filter_ticket_id = null;
		}

if (isset($this->request->get['filter_subject'])) {
			$filter_subject = $this->request->get['filter_subject'];
		} else {
			$filter_subject = null;
		}

if (isset($this->request->get['filter_priority'])) {
			$filter_priority = $this->request->get['filter_priority'];
		} else {
			$filter_priority = null;
		}

if (isset($this->request->get['filter_department'])) {
			$filter_department = $this->request->get['filter_department'];
		} else {
			$filter_department = null;
		}

if (isset($this->request->get['filter_ticket_status'])) {
			$filter_ticket_status = $this->request->get['filter_ticket_status'];
		} else {
			$filter_ticket_status = null;
		}

if (isset($this->request->get['filter_date_added'])) {
			$filter_date_added = $this->request->get['filter_date_added'];
		} else {
			$filter_date_added = null;
		}

if (isset($this->request->get['filter_date_modified'])) {
			$filter_date_modified = $this->request->get['filter_date_modified'];
		} else {
			$filter_date_modified = null;
		}

if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'name';
		}

if (isset($this->request->get['order'])) {
			$order = $this->request->get['order'];
		} else {
			$order = 'ASC';
		}

if (isset($this->request->get['page'])) {
			$page = $this->request->get['page'];
		} else {
			$page = 1;
		}

$url = '';
		
		
		if (isset($this->request->get['filter_ticket_id'])) {
			$url .= '&filter_ticket_id=' . urlencode(html_entity_decode($this->request->get['filter_ticket_id'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_subject'])) {
			$url .= '&filter_subject=' . urlencode(html_entity_decode($this->request->get['filter_subject'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_email'])) {
			$url .= '&filter_email=' . urlencode(html_entity_decode($this->request->get['filter_email'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_priority'])) {
			$url .= '&filter_priority=' . urlencode(html_entity_decode($this->request->get['filter_priority'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_department'])) {
			$url .= '&filter_department=' . urlencode(html_entity_decode($this->request->get['filter_department'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_ticket_status'])) {
			$url .= '&filter_ticket_status=' . urlencode(html_entity_decode($this->request->get['filter_ticket_status'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_date_added'])) {
			$url .= '&filter_date_added=' . urlencode(html_entity_decode($this->request->get['filter_date_added'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_date_modified'])) {
			$url .= '&filter_date_modified=' . urlencode(html_entity_decode($this->request->get['filter_date_modified'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['sort'])) {
			$url .= '&sort=' . $this->request->get['sort'];
		}

if (isset($this->request->get['order'])) {
			$url .= '&order=' . $this->request->get['order'];
		}

if (isset($this->request->get['page'])) {
			$url .= '&page=' . $this->request->get['page'];
		}

$data['breadcrumbs'] = array();

$data['breadcrumbs'][] = array(
			'text' => $this->language->get('text_home'),
			'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true)
		);

$data['breadcrumbs'][] = array(
			'text' => $this->language->get('heading_title'),
			'href' => $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . $url, true)
		);

$data['add'] = $this->url->link('emticket/tickets/add', 'user_token=' . $this->session->data['user_token'] . $url, true);
		$data['delete'] = $this->url->link('emticket/tickets/delete', 'user_token=' . $this->session->data['user_token'] . $url, true);

$data['tickets'] = array();

$filter_data = array(
			'filter_ticket_id'              => $filter_ticket_id,
			'filter_email'             => $filter_email,
			'filter_subject' => $filter_subject,
			'filter_priority'            => $filter_priority,
			'filter_department'          => $filter_department,
			'filter_ticket_status'        => $filter_ticket_status,
			'filter_date_added'                => $filter_date_added,
			'filter_date_modified'                => $filter_date_modified,
			'sort'  => $sort,
			'order' => $order,
			'start' => ($page - 1) * $this->config->get('config_limit_admin'),
			'limit' => $this->config->get('config_limit_admin')
		);
		$language_id =	(int)$this->config->get('config_language_id');
		$ticket_total = $this->model_emticket_tickets->getTotaltickets();

$results = $this->model_emticket_tickets->getTickets($filter_data);
		
			/* echo "<pre>";	
		print_r($results); */

foreach ($results as $result) {
			
				$priority = $this->model_emticket_tickets->getPriorityNameById($result['priority']);
				$department = $this->model_emticket_tickets->getDepartmentNameById($result['department']);
				$ticket_status = $this->model_emticket_tickets->getTicketstatusNameById($result['ticket_status']);
			
			 $data['tickets'][] = array(
				 'ticket_id' => $result['ticket_id'],
				 'name' =>		$result['firstname']." ".$result['lastname'],
				 'email'      => $result['email'],
				 'subject'      => $result['subject'],
				 'priority'      => $priority,
				 'department'      => $department,
				 'ticket_status'      => $ticket_status,
				 'date_added'      => $result['date_added'],
				 'date_modified'      => $result['date_modified'],
				 
				 'edit'            => $this->url->link('emticket/tickets/edit', 'user_token=' . $this->session->data['user_token'] . '&ticket_id=' . $result['ticket_id'] . $url, true),
				 'view'            => $this->url->link('emticket/emticketview', 'user_token=' . $this->session->data['user_token'] . '&ticket_id=' . $result['ticket_id'] . $url, true)
			 );
		 } 
		 
		 
		 
		// fetching priority, status, department
		
			$this->load->model('emticket/empriority');
			$this->load->model('emticket/emstatus');
			$this->load->model('emticket/emdepartment');
			
			$priority_total = $this->model_emticket_empriority->getTotalPrioritys();

$prioritys = $this->model_emticket_empriority->getPrioritys($filter_data);

foreach ($prioritys as $priorit) {

$info =	json_decode($priorit['info'], true);

$data['prioritys'][] = array(
					 'priority_id' => $priorit['priority_id'],
					 'name'            => $info[$language_id]['name'],
					 'sort_order'      => $priorit['sort_order'],
					 'edit'            => $this->url->link('emticket/empriority/edit', 'user_token=' . $this->session->data['user_token'] . '&priority_id=' . $priorit['priority_id'] . $url, true),
					 
				 );
			} 
			
			
			$statuss = $this->model_emticket_emstatus->getStatuss($filter_data);
				
				
			  foreach ($statuss as $stat) {
				
				$info =	json_decode($stat['info'], true);
				
				$label_bg = "transparent";
				$label_clr = "";
				if(isset($info['label_bg'])){
					$label_bg = $info['label_bg'];
				}
				if(isset($info['label_clr'])){
					$label_clr = $info['label_clr'];
				}
				
				
				 $getToalTichetByStatus = $this->model_emticket_emstatus->getToalTichetByStatus($stat['id']);
				
				 $data['statuss'][] = array(
					 'id' => $stat['id'],
					 'name'            => $info[$language_id]['name'],
					 'sort_order'      => $stat['sort_order'],
					 'getToalTichetByStatus'      => $getToalTichetByStatus,
					 'label_clr'      => $label_clr,
					 'label_bg'      => $label_bg,
					 'edit'            => $this->url->link('emticket/emstatus/edit', 'user_token=' . $this->session->data['user_token'] . '&id=' . $stat['id'] . $url, true)
				 );
			 }
			 
			/*  echo "<pre>";
			print_r($data['statuss']);	 */
			 
			 $departments = $this->model_emticket_emdepartment->getDepartments($filter_data);

foreach ($departments as $departmen) {
				
				$department_description	=	$this->model_emticket_emdepartment->getDepartmentDescriptions($departmen['department_id']);	
				
				 $data['departments'][] = array(
					 'department_id' => $departmen['department_id'],
					 'name'            => $department_description[$language_id]['name'],
					 'sort_order'      => $departmen['sort_order'],
					 'edit'            => $this->url->link('emticket/emdepartment/edit', 'user_token=' . $this->session->data['user_token'] . '&department_id=' . $departmen['department_id'] . $url, true)
				 );
			 }
		
		
		
		// fetching priority, status, department end

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

$data['text_list'] = $this->language->get('text_list');
		$data['text_no_results'] = $this->language->get('text_no_results');
		$data['text_confirm'] = $this->language->get('text_confirm');
		$data['text_loading'] = $this->language->get('text_loading');

$data['column_name'] = $this->language->get('column_name');
		$data['column_id'] = $this->language->get('column_id');
		$data['column_subject'] = $this->language->get('column_subject');
		$data['column_email'] = $this->language->get('column_email');
		$data['column_priority'] = $this->language->get('column_priority');
		$data['column_ticket_status'] = $this->language->get('column_ticket_status');
		$data['column_department'] = $this->language->get('column_department');
		$data['column_date_added'] = $this->language->get('column_date_added');
		$data['column_date_modified'] = $this->language->get('column_date_modified');
		$data['column_action'] = $this->language->get('column_action');
		
		$data['entry_name'] = $this->language->get('entry_name');
		$data['entry_ticket_id'] = $this->language->get('entry_ticket_id');
		$data['entry_subject'] = $this->language->get('entry_subject');
		$data['entry_email'] = $this->language->get('entry_email');
		$data['entry_priority'] = $this->language->get('entry_priority');
		$data['entry_ticket_status'] = $this->language->get('entry_ticket_status');
		$data['entry_department'] = $this->language->get('entry_department');
		$data['entry_date_added'] = $this->language->get('entry_date_added');
		$data['entry_date_modified'] = $this->language->get('entry_date_modified');
		$data['entry_action'] = $this->language->get('entry_action');
		$data['entry_attachment'] = $this->language->get('entry_attachment');

$data['button_add'] = $this->language->get('button_add');
		$data['button_edit'] = $this->language->get('button_edit');
		$data['button_view'] = $this->language->get('button_view');
		$data['button_delete'] = $this->language->get('button_delete');
		$data['button_filter'] = $this->language->get('button_filter');
		$data['button_upload'] = $this->language->get('button_upload');

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

if (isset($this->session->data['success'])) {
			$data['success'] = $this->session->data['success'];

unset($this->session->data['success']);
		} else {
			$data['success'] = '';
		}

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

if (isset($this->request->get['filter_subject'])) {
			$url .= '&filter_subject=' . urlencode(html_entity_decode($this->request->get['filter_subject'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_email'])) {
			$url .= '&filter_email=' . urlencode(html_entity_decode($this->request->get['filter_email'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_priority'])) {
			$url .= '&filter_priority=' . urlencode(html_entity_decode($this->request->get['filter_priority'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_department'])) {
			$url .= '&filter_department=' . urlencode(html_entity_decode($this->request->get['filter_department'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_ticket_status'])) {
			$url .= '&filter_ticket_status=' . urlencode(html_entity_decode($this->request->get['filter_ticket_status'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_date_added'])) {
			$url .= '&filter_date_added=' . urlencode(html_entity_decode($this->request->get['filter_date_added'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_date_modified'])) {
			$url .= '&filter_date_modified=' . urlencode(html_entity_decode($this->request->get['filter_date_modified'], ENT_QUOTES, 'UTF-8'));
		}

if ($order == 'ASC') {
			$url .= '&order=DESC';
		} else {
			$url .= '&order=ASC';
		}

if (isset($this->request->get['page'])) {
			$url .= '&page=' . $this->request->get['page'];
		}

$data['sort_id'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=ticket_id' . $url, true);
		$data['customer'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=customer' . $url, true);
		$data['sort_subject'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=subject' . $url, true);
		$data['sort_email'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=email' . $url, true);
		$data['sort_priority'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=priority' . $url, true);
		$data['sort_ticket_status'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=ticket_status' . $url, true);
		$data['sort_department'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=department' . $url, true);
		$data['sort_date_added'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=date_added' . $url, true);
		$data['sort_date_modified'] = $this->url->link('emticket/tickets', 'user_token=' . $this->session->data['user_token'] . '&sort=date_modified' . $url, true);