public function _getJSON() { $data = array(); $data[] = array(); $id = key($this->dataout); $joins = dbfn::_getJoins($this->table); // Prepare the parameters for the query. $oQ = new formfilterpage($this->table, $joins); #Get filter and pagination data $data[0] = $oQ->_getJSON(); for ($ii = 0; $ii < count($this->dataout[$id]); $ii++) { $data[1][] = "<input type=\"checkbox\" name=\"cid[]\" id=\"cid_{$ii}\" value=\"{$this->dataout[$id][$ii]}\" />"; } foreach ($this->cols as $col_index => $col) { if ($this->params[$col]->visible && $this->params[$col]->qv_enabled) { // make sure column is visible and quickview enabled $temp = array(); foreach ($this->dataout[$col] as $cell_index => $cell_value) { $is_sub = false; // Determine if we are dealing with a substitute value if (empty($this->params[$col]->qv_sub_col)) { # no sub $cid = $this->dataout[$id][$cell_index]; # pid of current row $table_temp = $this->table; $cell_val_temp = strlen($cell_value) <= 100 ? $cell_value : substr($cell_value, 0, 100) . "..."; } else { # sub one or more cols $is_sub = true; $sub_col = $this->params[$col]->qv_sub_col; $cid = $cell_value; #pid of subbed col $table_temp = $this->params[$col]->qv_sub_col_table; $sub_col_temp = explode(",,", $sub_col); $cell_val_temp = array(); foreach ($sub_col_temp as $sub_col_col) { $cell_val_temp[] = $this->dataout[$sub_col_col][$cell_index]; } $cell_val_temp = implode(" - ", $cell_val_temp); } $temp[] = $col_index != 1 && $is_sub === false ? $cell_val_temp : "<a href=\"javascript:void(0)\" rel=\"{$table_temp}__{$cid}\" class=\"qv-a\" tt=\"View more details for: {$cell_val_temp}\">{$cell_val_temp}</a>"; } $data[] = $temp; } } return json_encode($data); }
global $view; $view = req::_('view', $option); $views = explode('|', req::_('view', $option)); $data = array(); // array containing select query db object $formdata = array(); // array containing filter/pagination form data objects /** ** ** ** ** ** ** ** ** ** * INITIALIZE VIEWS FOR EACH TAB */ foreach ($views as $v) { // Set some params $table = TABLEPREFIX . $v; $joins = dbfn::_getJoins($table); // Prepare the parameters for the query. $oQ = new formfilterpage($table, $joins); #Get filter and pagination data $select = $oQ->_getQuery(); #Get query $data[$v] = new db($select); #Perform query and load the results into the data array $oQ->_update($data[$v]); #Update the filter/pagination object $formdata[$v] = $oQ; #Load filter/pagination object into formdata array } /** ** ** ** ** ** ** ** ** ** * LOAD UP THE QUICKVIEW VIEW */ include "views/qv.php"; ?>