onericcomputing / mmanager-module-builder

			return $this->db->get_row("SELECT name FROM oc_tickets_issue_types WHERE id = '{$id}'")->name;

		}

	}

	public function getTicketAdditionalEmailsToNotify() {

		$list = [];

		$results = $this->db->get_results("SELECT id, email FROM users");

		if ($results) {

			foreach ($results as $user) {

				array_push($list, array('id' => $user->id, 'text' => $user->email));

			}

		}

		return $list;

	}

	public function getTicketCannedResponsesCategories() {

		$list = [];

		}

		return $list;

	}

	public function getTicketCannedResponsesCategories() {

		$list = [];

		$results = $this->db->get_results("SELECT id, category_name FROM oc_tickets_canned_responses_categories");

		if ($results) {

			foreach ($results as $cat) {

				array_push($list, array('id' => $cat->id, 'text' => $cat->category_name));

			}

		}

		return $list;

	}

	public function getTicketCannedResponses() {

		$list = [];

		}

		return $list;

	}

	public function getTicketCannedResponses() {

		$list = [];

		$results = $this->db->get_results("SELECT id, ticket_canned_response_title FROM oc_tickets_canned_responses");

		if ($results) {

			foreach ($results as $response) {

				array_push($list, array('id' => $response->id, 'text' => $response->ticket_canned_response_title));

			}

		}

		return $list;

	}

	public function getTicketResponseCategoryId($name) {

		$name = addslashes($name);

		return $this->db->get_row("SELECT id FROM oc_tickets_canned_responses_categories where category_name LIKE '{$name}'")->id;