<?php

	if (!defined('BASEPATH')) exit('No direct script access allowed');

	class QueryLogger
	{
		private $ci;
		private $types;

		public function __construct()
		{
			$this->ci    =& get_instance();
			$this->types = $this->ci->config->item('query_types');
		}

		public function save()
		{
			if ($this->can_saved()) {
				$key = random_string('md5');
				foreach ($this->ci->db->queries as $query) {
					$query = str_replace("\n", ' ', $query);
					$type  = $this->get_type($query);

					if ($type !== '') {
						$this->ci->db->insert('query_logs', [
							'key'       => $key,
							'type'       => $type,
							'query'      => $query,
							'path'       => $this->ci->router->fetch_class() . '/' . $this->ci->router->fetch_method(),
							//'admin_id' => $this->ci->session->admin_id,
							'member_id'  => $_SESSION['member_id'],
							'session_id' => session_id(),
							'order_id'   => $_SESSION['order_id'],
							'createdate' => date('Y-m-d H:i:s')
						]);
					}
				}
			}

		}

		public function can_saved()
		{
			//if (count($this->ci->db->queries) > 0 && $this->ci->session->has_userdata('admin_id')) {
			if (count($this->ci->db->queries) > 0 && true) {
				return true;
			}

			return false;
		}

		public function get_type($query)
		{
			$types = $this->ci->config->item('query_types');

			/*return implode('', array_filter($this->types, function ($type) use ($query) {
				return stristr($query, $type);
			}));*/

			foreach ($types as $type){
				if(stristr($query, $type)){
					return $type;
				}
			}

		}
	}