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";
?>
