<?php
	class lcs_db_grid {
		
		public $html = '';
		private $columns = array();
		private $column_ctr = 0;
		private $sub_column_ctr = 1;
		private $width = 0;
		private $scrollbar_width = 0;
		private $spacer_width = 0;
		private $uid = 0;
		private $old_uid = 0;
		private $sort_col = 1;
		private $sort_order = 0;
		private $search_str = '';
		private $filter_cols = array();
		private $filter = false;
		private $div = '';
		private $call = '';
		private $func = '';
		private $ix_form = '';
		private $parm1 = '';
		private $parm2 = '';
		private $parm3 = '';
		private $block_html = '';
		private $block_count = 0;
		private $block_row = 0;
		private $block_limit = 200;
		private $appear_trigger = 190;
		private $load_method = 'lazy3';		/* lazy1 - background renedering, lazy2 - lazy rendering, lazy3 - lazy loading and rendering */
		private $ar_blocks = array();
		
		public function __construct() {
			$this->uid = str_replace(' ', '', microtime());
			$this->uid = str_replace('.', '', $this->uid);
			$this->scrollbar_width = intval($_GET['scrollbar_width']);
			$this->spacer_width = intval($_GET['spacer_width']);
			if (!empty($_GET['load_method'])) :
				$this->load_method = intval($_GET['load_method']);
			endif;
			if (!empty($_GET['old_uid'])) :
				$this->old_uid = intval($_GET['old_uid']);
			endif;
			if (!empty($_GET['sort_col'])) :
				$this->sort_col = intval($_GET['sort_col']);
			endif;
			if (!empty($_GET['sort_order'])) :
				$this->sort_order = intval($_GET['sort_order']);
			endif;
			if (!empty($_GET['search_str'])) :
				$this->search_str = trim($_GET['search_str']);
			endif;
			if (!empty($_GET['filter_cols'])) :
				$this->filter_cols = explode(',',trim($_GET['filter_cols']));
			endif;
			if (!empty($_GET['div'])) :
				$this->div = trim($_GET['div']);
			endif;
			if (!empty($_GET['call'])) :
				$this->call = trim($_GET['call']);
			endif;
			if (!empty($_GET['func'])) :
				$this->func = trim($_GET['func']);
			endif;
			if (!empty($_GET['ix_form'])) :
				$this->ix_form = trim($_GET['ix_form']);
			endif;
			if (!empty($_GET['parm1'])) :
				$this->parm1 = trim($_GET['parm1']);
				$_GET['parm1'] = xls_sql_decrypt($_GET['parm1']);
			endif;
			if (!empty($_GET['parm2'])) :
				$this->parm2 = trim($_GET['parm2']);
				$_GET['parm2'] = xls_sql_decrypt($_GET['parm2']);
			endif;
			if (!empty($_GET['parm3'])) :
				$this->parm3 = trim($_GET['parm3']);
				$_GET['parm3'] = xls_sql_decrypt($_GET['parm3']);
			endif;
			/*
			if (!empty($this->ix_form)) :
				$ar_url = explode('&', $_GET['ix_form']);
				foreach($ar_url as &$value) :
					if (substr($value, 0, 4) == 'ref=') :
						$value .= urlencode('&search_'.$this->div.'='.$this->search_str.'&scol_'.$this->div.'='.$this->sort_col.'&sorder_'.$this->div.'='.$this->sort_order);
					endif;
				endforeach;
				$_GET['ix_form'] = implode('&', $ar_url);
			endif;
			*/
		}
		
		public function start_header_section() {
			$this->html .= '<div class="lcs_dbg_header_section" id="lcs_dbg_header_'.$this->uid.'">';
		}

		public function end_header_section() {
			$this->html .= '</div>';
		}
		
		public function start_data_section() {
			$this->html .= '<div class="lcs_dbg_data_section" id="lcs_dbg_data_'.$this->uid.'" onscroll="lcs_db_scroll(\''.$this->uid.'\', \''.$this->div.'\');">';
		}

		public function end_data_section() {
			$this->block_count++;
			$this->ar_blocks[$this->block_count] = $this->block_html;
			$this->html .= '</div>';
		}
		
		public function start_header() {
			$this->column_ctr = 0;
			$this->html .= '<div class="lcs_dbg_header">';
		}

		public function end_header() {
			$this->html .= '<div class="lcs_dbg_cell_spacer" style="width:'.$this->scrollbar_width.'px!important;"></div>';
			$this->html .= '</div>';
			if ($this->filter) :
				$this->html .= '<div class="lcs_dbg_header_filter">';
				foreach ($this->columns as $key => $value) :
					if ($key > 1) :
						$this->html .= '<div class="lcs_dbg_cell_spacer"><div class="lcs_dbg_cell_spacer_abs"></div></div>';
					endif;
					$this->html .= '<div class="lcs_dbg_filter_cell" style="width:'.$value['width'].';" >';
					if ($value['filter']) :
						$filter_action = 'onclick="lcs_db_toggle_filter(\''.$this->div.'\', \''.$this->call.'\', \''.$this->func.'\', \''.$this->ix_form.'\', '.$this->sort_col.', '.$this->sort_order.', \''.$this->search_str.'\', \''.$this->parm1.'\', \''.$this->parm2.'\', \''.$this->parm3.'\', \''.implode(',', $this->filter_cols).'\','.$key.');"';
						$filter_class = '';
						if ($this->filter_cols[$key - 1] == 1) :
							$filter_class = ' class="filtered"  ';
						endif;
						$this->html .= '<img src="img/filter_icon.png" '.$filter_class.' '.$filter_action.' />';
					endif;
					$this->html .= '</div>';
				endforeach;
				$this->html .= '</div>';
			endif;
		}
		
		public function start_sub_header() {
			$this->sub_column_ctr = 1;
			$this->html .= '<div class="lcs_dbg_header_filter">';
		}

		public function end_sub_header() {
			for ($i = $this->sub_column_ctr; $i <= $this->column_ctr; $i++) :
				if ($i > 1) :
					$this->html .= '<div class="lcs_dbg_cell_spacer"><div class="lcs_dbg_cell_spacer_abs"></div></div>';
				endif;
				$this->html .= '<div class="lcs_dbg_filter_cell" style="width:'.$this->columns[$i]['width'].';" >';
				$this->html .= '</div>';
			endfor;
			//$this->html .= '<div class="lcs_dbg_cell_spacer" style="width:'.$this->scrollbar_width.'px!important;"></div>';
			$this->html .= '</div>';
		}
		
		public function add_sub_column($args) {
			$defaults = array(
								'start'				=> 1,
								'cols'				=> 1,
								'align'				=> 'center',  /** left, center, right **/
								'label'				=> '',
							);
			$args = array_merge($defaults, array_intersect_key($args, $defaults));
			for ($i = $this->sub_column_ctr; $i < $args['start']; $i++) :
				if ($i > 1) :
					$this->html .= '<div class="lcs_dbg_cell_spacer"><div class="lcs_dbg_cell_spacer_abs"></div></div>';
				endif;
				$this->html .= '<div class="lcs_dbg_filter_cell" style="width:'.$this->columns[$i]['width'].';" >';
				$this->html .= '</div>';
			endfor;
			$width = 0;
			for ($i = $args['start']; $i < $args['start'] + $args['cols']; $i++) :
				$width += intval($this->columns[$i]['width']);
			endfor;
			$width += ($args['cols'] - 1) * $this->spacer_width;
			if ($i > 1) :
				$this->html .= '<div class="lcs_dbg_cell_spacer"><div class="lcs_dbg_cell_spacer_abs"></div></div>';
			endif;
			$this->html .= '<div class="lcs_dbg_sub_header_cell" style="width:'.$width.'px; text-align:'.$args['align'].'; max-width:none;" >';
			$this->html .= $args['label'];
			$this->html .= '</div>';
			$this->sub_column_ctr = $args['start'] + $args['cols'];
		}
		
		public function start_row() {
			$this->column_ctr = 0;
			if ($this->block_row >= $this->block_limit) :
				$this->block_count++;
				$this->ar_blocks[$this->block_count] = $this->block_html;
				$this->block_row = 0;
				$this->block_html = '';
			endif;
			//$this->html .= '<div class="lcs_dbg_row" style="width:'.$this->width.'px">';
			$appear_class = '';
			if ($this->block_row == $this->appear_trigger) :
				$appear_class = ' lcs_appear';
			endif;
			$this->block_row++;
			$this->block_html .= '<div class="lcs_dbg_row'.$appear_class.'">';
			//$this->block_html .= '<div class="lcs_dbg_row" style="width:'.$this->width.'px">';
		}

		public function end_row() {
			//$this->html .= '</div>';
			$this->block_html .= '</div>';
		}
		
		public function add_column($args) {
			$defaults = array(
								'label'				=> '',
								'dbcol'				=> '',
								'datatype'			=> 'text',  /** text, number, currency, date, time, datetime, checkbox, image **/
								'align'				=> 'left',  /** left, center, right **/
								'width'				=> '',
								'sortable'			=> true,
								'searchable'		=> true,
								'href'				=> '',
								'filter'			=> false,
							);
			$args = array_merge($defaults, array_intersect_key($args, $defaults));
			$this->column_ctr++;
			$this->columns[$this->column_ctr] = $args;
			if ($this->column_ctr > 1) :
				$this->width += $this->spacer_width;
				$this->html .= '<div class="lcs_dbg_cell_spacer"></div>';
			endif;
			$this->width += intval($this->columns[$this->column_ctr]['width']);
			$sort_class = '';
			$sort_action = '';
			if ($this->columns[$this->column_ctr]['sortable']) :
				$sort_class .= ' lcs_dbg_sortable ';
				$sort_direction = 0;
				if ($this->column_ctr == $this->sort_col) :
					if ($this->sort_order == 0) :
						$sort_class .= 'lcs_dbg_sorting_asc';
						$sort_direction = 1;
					else :
						$sort_class .= 'lcs_dbg_sorting_desc';
					endif;
				endif;
				$sort_action .= 'onclick="lcs_db_load(\''.$this->div.'\', \''.$this->call.'\', \''.$this->func.'\', \''.$this->ix_form.'\', '.$this->column_ctr.', '.$sort_direction.', \''.$this->search_str.'\', \''.$this->parm1.'\', \''.$this->parm2.'\', \''.$this->parm3.'\', \''.implode(',', $this->filter_cols).'\');"';
			endif;
			$this->html .= '<div class="lcs_dbg_header_cell '.$sort_class.'" style="width:'.$this->columns[$this->column_ctr]['width'].'" '.$sort_action.'>';
			$this->html .= $args['label'];
			$this->html .= '</div>';
	        //list($label, $datatype, $align) = array_values($args);
			if ($args['filter']) :
				$this->filter = true;
			endif;
			if ($this->filter_cols[$this->column_ctr - 1] != '1') :
				$this->filter_cols[$this->column_ctr - 1] = '0';
			endif;
		}

		public function add_cell($str) {
			if ($str == '') :
				$str = '&nbsp;';
			endif;
			$this->column_ctr++;
			if ($this->column_ctr > 1) :
				//$this->html .= '<div class="lcs_dbg_cell_spacer"><div class="lcs_dbg_cell_spacer_abs"></div></div>';
				$this->block_html .= '<div class="lcs_dbg_cell_spacer"><div class="lcs_dbg_cell_spacer_abs"></div></div>';
			endif;
			//$this->html .= '<div class="lcs_dbg_data_cell" style="width:'.$this->columns[$this->column_ctr]['width'].'; text-align:'.$this->columns[$this->column_ctr]['align'].';">';
			//$this->html .= $str;
			//$this->html .= '</div>';
			$this->block_html .= '<div class="lcs_dbg_data_cell" style="width:'.$this->columns[$this->column_ctr]['width'].'; text-align:'.$this->columns[$this->column_ctr]['align'].';">';
			$this->block_html .= $str;
			$this->block_html .= '</div>';
		}

		public function sort_spec() {
			if ($this->sort_order == 0) :
				$sort_order = 'ASC';
			else :
				$sort_order = 'DESC';
			endif;
			$sort_spec = " ".$this->columns[$this->sort_col]['dbcol']." ".$sort_order." ";
			//$_SESSION['appstack'][count($_SESSION['appstack']) - 1]['scol_'.$this->div] = $this->sort_col;
			//$_SESSION['appstack'][count($_SESSION['appstack']) - 1]['sorder_'.$this->div] = $this->sort_order;
			return $sort_spec;
		}

		public function search_spec() {
			$db = $GLOBALS['db'];
			$ar_tokens = array();
			$si = 0;
			$search_spec = '';
			$filter_spec = '';
			for ($i=1; $i<=$this->column_ctr; $i++) :
				if ($this->columns[$i]['searchable']) :
					$si++;
					if ($this->columns[$i]['datatype'] == 'number' || $this->columns[$i]['datatype'] == 'currency') :
						$search_token = " (".$this->columns[$i]['dbcol']." = ".floatval($this->search_str).") ";
					else :
						$search_token = " (".$this->columns[$i]['dbcol']." LIKE ".$db->quote('%'.htmlspecialchars_decode($this->search_str, ENT_QUOTES).'%').") ";
					endif;
					$ar_tokens[$si] = $search_token;
				endif;
				if ($this->columns[$i]['filter']) :
					if ($this->filter_cols[$i - 1] == '1') :
						$filter_spec .= " AND ".$this->columns[$i]['dbcol']." = 1 ";
					endif;
				endif;
			endfor;
			if ($si > 0) :
				$search_spec = " (".implode(' OR ', $ar_tokens).") ";
				//$_SESSION['appstack'][count($_SESSION['appstack']) - 1]['search_'.$this->div] = $this->search_str;
			else :
				$search_spec = ' (1=1) ';
			endif;
			//echo ' *** search spec *** '.$search_spec.' *** ';
			return $search_spec.$filter_spec;
		}

		public function get_html() {
			$this->width += $this->scrollbar_width;
			$this->html = '<div class="lcs_dbg_wrapper" style="width:'.$this->width.'px;">'.$this->html.'</div>';
			$this->html .= '<script>';
			$this->html .= 'var '.$this->div.'_sort_col = '.$this->sort_col.';';
			$this->html .= 'var '.$this->div.'_sort_order = '.$this->sort_order.';';
			$this->html .= 'var '.$this->div.'_search_str = "'.$this->search_str.'";';
			$this->html .= 'var '.$this->div.'_filter_cols = "'.implode(',', $this->filter_cols).'";';
			$this->html .= 'var '.$this->div.'_parm1 = "'.$this->parm1.'";';
			$this->html .= 'var '.$this->div.'_parm2 = "'.$this->parm2.'";';
			$this->html .= 'var '.$this->div.'_parm3 = "'.$this->parm3.'";';
			$this->html .= 'var '.$this->div.'_call = "'.$this->call.'";';
			$this->html .= 'var '.$this->div.'_func = "'.$this->func.'";';
			$this->html .= 'var '.$this->div.'_ix_form = "'.$this->ix_form.'";';
			$this->html .= 'window["'.$this->div.'_block_count"] = '.$this->block_count.';';
			$this->html .= 'window["'.$this->div.'_current_block"] = 1;';
			$this->html .= 'window["'.$this->div.'_uid"] = "'.$this->uid.'";';
			$this->html .= 'window["'.$this->div.'_load_method"] = "'.$this->load_method.'";';
			$this->html .= 'window["'.$this->div.'_ar_blocks"] = [];';
			$this->html .= 'if (typeof appstack_switch_param == "function") { ';
			$this->html .= 'appstack_switch_param("search_'.$this->div.'", "'.$this->search_str.'");';
			$this->html .= 'appstack_switch_param("scol_'.$this->div.'", "'.$this->sort_col.'");';
			$this->html .= 'appstack_switch_param("sorder_'.$this->div.'", "'.$this->sort_order.'");';
			$this->html .= 'appstack_switch_param("fcols_'.$this->div.'", "'.implode(',', $this->filter_cols).'");';
			$this->html .= ' } ';
			switch ($this->load_method):
				case 'lazy1' :
					for ($i=1; $i<=$this->block_count; $i++) :
						$this->html .= 'window["'.$this->div.'_ar_blocks"]['.$i.'] = '.json_encode($this->ar_blocks[$i]).';';
					endfor;
					$this->html .= 'setTimeout(function() { lcs_db_lazy_load1(1, '.$this->block_count.', "'.$this->uid.'", "'.$this->div.'"); }, 50);';
					break;
				case 'lazy2' :
					for ($i=1; $i<=$this->block_count; $i++) :
						$this->html .= 'window["'.$this->div.'_ar_blocks"]['.$i.'] = '.json_encode($this->ar_blocks[$i]).';';
					endfor;
					//$this->html .= 'setTimeout(function() { lcs_db_lazy_load2("'.$this->uid.'", "'.$this->div.'"); }, 50);';
					break;
				case 'lazy3' :
					$_SESSION['lcs_db_grid_blocks_'.$this->old_uid] = NULL;
					unset($_SESSION['lcs_db_grid_blocks_'.$this->old_uid]);
					$_SESSION['lcs_db_grid_blocks_'.$this->uid] = array();
					for ($i=1; $i<=$this->block_count; $i++) :
						$_SESSION['lcs_db_grid_blocks_'.$this->uid][$i] = gzcompress($this->ar_blocks[$i], 6);
					endfor;
					if (!isset($_SESSION['lcs_db_grid_keep_alive']) || !is_array($_SESSION['lcs_db_grid_keep_alive'])) :
						$_SESSION['lcs_db_grid_keep_alive'] = array();
					endif;
					foreach ($_SESSION['lcs_db_grid_keep_alive'] as $key=>$value) :
						if (($value + 300) < time()) :
							$_SESSION['lcs_db_grid_blocks_'.$key] = NULL;
							unset($_SESSION['lcs_db_grid_blocks_'.$key]);
						endif;
					endforeach;
					$_SESSION['lcs_db_grid_keep_alive'][$this->uid] = time();
					$this->ar_blocks = NULL;
					//$this->html .= 'setTimeout(function() { lcs_db_lazy_load3("'.$this->uid.'", "'.$this->div.'"); }, 50);';
					break;
			endswitch;
			$this->html .= '</script>';
			return $this->html;
		}
		
	}
?>