public function Getimage() { $this->layout_view = null; $id = $_POST['id']; $table = $_POST['table']; $table_parent = $_POST['table_parent']; $name_space = $_POST['name_space']; $q_relation = AdaptorMysql::queryRow("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "relations WHERE table_parent = '{$table_parent}' AND table_child = '{$table}'"); $config = _ControllerFront::parseConfig($q_relation['config']); $this->view(array('view' => '_image', 'data' => array('id' => $id, 'table' => $table, 'config' => $config, 'name_space' => $name_space))); }
public function getData($table = '') { if ($table != '') { $this->table = $table; } //set necessary variables $table_parent = Utils::setVar("table_parent", ''); $id_parent = Utils::setVar("id_parent", ''); $this->sql = ''; //these should be mapped in from the controller - not set here $sort_dir = Utils::setVar("sort_dir", "DESC"); $offset = Utils::setVar("offset", "0"); $limit = Utils::setVar("limit", "100"); $search = Utils::setVar("search"); $mode = Utils::setVar("mode", "main"); //get table description data $this->tableMeta = AdaptorMysql::query("SHOW COLUMNS FROM {$this->table}", MYSQL_BOTH); $this->key = AdaptorMysql::getPrimaryKey($this->table); $sort_col = Utils::setVar("sort_col", $this->key); //check for config info here $q_col = false; //get configuration data for form $q_c = array(); //get all the base config $tA = Utils::checkArray(_ControllerFront::$config['tables'], array('table_name' => $this->table), true); if (is_array($tA)) { $q_c = $tA; } if ($q_sql = $this->db->query("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "tables WHERE table_name = '{$this->table}' ORDER BY table_name,display_mode")) { $q_c = array_merge($q_c, $q_sql); } if (!$q_col) { if ($mode == 'main') { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => 'main')); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => '')); } } if ($mode == 'related') { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => 'related')); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => '')); } } } //column description information $fields = array(); if ($q_col['cols_default'] == "") { $select_cols = '*'; } else { $select_cols = $q_col['cols_default']; $fields = explode(",", $select_cols); } if ($select_cols == "*") { $fields = array(); for ($i = 0; $i < count($this->tableMeta); $i++) { $row = $this->tableMeta[$i]; $fields[] = $row[0]; } } //filters and WHERE $filterA = array(); $this->filtersA = array(); $whereA = array(); $where = 'WHERE '; $where .= $this->sql; $filterWhere = ''; if ($table == BLACKBIRD_TABLE_PREFIX . 'history') { $filterWhere = $this->sql; $label = '_History_'; } else { if ($table_parent != '') { $relation = AdaptorMysql::queryRow("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "relations WHERE table_parent = '{$table_parent}' AND table_child = '{$table}'"); $q_parent = AdaptorMysql::queryRow("SELECT * FROM {$table_parent} WHERE id = {$id_parent}"); $sql_val = $q_parent[$relation['column_parent']]; $whereA[] = "{$relation['column_child']} = '{$sql_val}'"; $filterWhere = "{$relation['column_child']} = '{$sql_val}'"; //from build in a page if (isset($this->config['sql_where'])) { $whereA[] = $this->config['sql_where']; $filterWhere .= ' AND ' . $this->config['sql_where']; } //from build in remote if (isset($_REQUEST['sql_where'])) { $whereA[] = stripslashes($_REQUEST['sql_where']); $filterWhere .= ' AND ' . stripslashes($_REQUEST['sql_where']); } $label = $relation['label']; } else { $label = $table; } } if ($search != "") { $q = $this->db->query("SHOW COLUMNS FROM {$this->table}", MYSQL_BOTH); $search_fields = array(); for ($i = 0; $i < count($q); $i++) { $row = $q[$i]; $search_fields[] = $row[0]; } //Generate search $mySearch = "'%" . mysql_real_escape_string(stripslashes(trim($search))) . "%'"; $rSearch = AdaptorMysql::generateSearch($search_fields, $mySearch); } $q_filters = AdaptorMysql::query("SELECT column_name FROM " . BLACKBIRD_TABLE_PREFIX . "cols WHERE (table_name = '*' OR table_name = '{$table}') AND filter != ''"); if ($q_filters) { //loop through and find intersections foreach ($q_filters as $filter) { $col = $filter['column_name']; if (in_array($col, $fields)) { $filterA[] = $col; $_filter = array(); if (isset($_REQUEST['filter_' . $col])) { if ($_REQUEST['filter_' . $col] != '') { $t = $_REQUEST['filter_' . $col]; $whereA[] = "{$col} = '{$t}'"; //$this->filtersA[] = array('col'=>$col,'value'=>$t); $_filter['col'] = $col; $_filter['value'] = $t; } } //query up option data $filterWhere != '' ? $w = 'WHERE ' . $filterWhere : ($w = ''); $optionA = array(); $field = $col; if ($q_select = AdaptorMysql::query("SELECT DISTINCT `{$field}` FROM `{$table}` {$w} ORDER BY `{$field}`")) { foreach ($q_select as $row) { $sel = ''; if (isset($_REQUEST['filter_' . $field])) { if ($_REQUEST['filter_' . $field] == $row[$field]) { $sel = 'selected="selected"'; } } $tv = _ControllerFront::formatCol($field, $row[$field], $table); $q_c = AdaptorMysql::query("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "cols WHERE column_name = '{$field}'"); if ($q_c) { $q_col = Utils::checkArray($q_c, array('table_name' => $table)); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => '*')); } if ($q_col) { if ($q_col['filter'] != '') { $tA = _ControllerFront::parseConfig($q_col['filter']); if (isset($tA['filter_length'])) { if (strlen(strip_tags($tv)) > $tA['filter_length']) { $tv = substr(strip_tags($tv), 0, $tA['filter_length']) . '...'; } } } } } $optionA[] = array('value' => $row[$field], 'label' => $tv, 'selected' => $sel); } } //sort it $optionA = Utils::arraySort($optionA, 'label'); $_filter['options'] = $optionA; $this->filtersA[$field] = $_filter; } } } if (count($whereA) > 0) { if ($where != 'WHERE ') { $where .= ' AND '; } $where .= join($whereA, ' AND '); } else { if ($where == 'WHERE ') { $where = ''; } } if ($search == '') { $query_data = AdaptorMysql::query("SELECT {$select_cols} FROM `{$table}` {$where} ORDER BY `{$sort_col}` {$sort_dir} LIMIT {$limit} OFFSET {$offset}"); if ($query_data) { $rT = count($query_data); } else { $rT = 0; } $q2 = AdaptorMysql::query("SELECT * FROM {$table} {$where}"); if ($q2) { $rows_total = count($q2); } else { $rows_total = 0; } } else { if ($where == '') { $where = 'WHERE '; } if ($where != 'WHERE ' && $rSearch != '') { $where .= ' AND ('; $rSearch = $rSearch . ')'; } $query_data = AdaptorMysql::query("SELECT {$select_cols} FROM `{$table}` {$where} {$rSearch} ORDER BY `{$sort_col}` LIMIT {$limit} OFFSET {$offset}"); $rT = count($query_data); $q2 = AdaptorMysql::query("SELECT * FROM `{$table}` {$where} {$rSearch}"); if ($q2) { $rows_total = count($q2); } else { $rows_total = 0; } } $this->recordSet = array(); //build recordSet if ($query_data) { foreach ($query_data as $row) { $tA = array(); for ($j = 0; $j < count($fields); $j++) { $data = _ControllerFront::formatCol($fields[$j], $row[$fields[$j]], $table); $tA[$fields[$j]] = array('col' => $fields[$j], 'value' => $data); } //convert to the key $this->recordSet[$row[$this->key]] = _ControllerFront::injectData($tA, $table, 'body'); } } //headerData $tA = array(); for ($j = 0; $j < count($fields); $j++) { isset($row[$j]) ? $value = $row[$j] : ($value = ''); $data = _ControllerFront::formatCol($fields[$j], $value, $table); $tA[$fields[$j]] = array('col' => $fields[$j], 'value' => $data); } $this->headerData = _ControllerFront::injectData($tA, $table, 'head'); $delete_allowed = false; //if($this->cms->session->privs("delete",$table)){ // $delete_allowed = true; //} return array('headerData' => $this->headerData, 'rowData' => $this->recordSet, 'sort_col' => $sort_col, 'sort_dir' => $sort_dir, 'table' => $this->table, 'rows_total' => $rows_total, 'limit' => $limit, 'offset' => $offset, 'mode' => $mode, 'filtersA' => $this->filtersA, 'filterA' => $filterA, 'search' => $search); }
private function _buildForm() { //the master loopage //do a few things different if we're editing vs inserting a new record.. however not much //use output buffering to feed this to the view... this is a unique controller driven situation //since it's almost entirely logic based and presentation uses markup snippets from the Forms library ob_start(); $_name_space = $this->name_space . '_'; //processing instructions Forms::hidden('name_space', $this->name_space, array('omit_id' => true)); Forms::hidden('mode', $this->mode, array('omit_id' => true)); Forms::hidden('channel', $this->channel, array('omit_id' => true)); Forms::hidden('table', $this->table, array('omit_id' => true)); Forms::hidden('query_action', $this->query_action, array('omit_id' => true)); $recordData = $this->model->data; $row_data = $recordData; //Relation fields if ($this->channel == "related") { $sql = "SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "relations WHERE table_parent = '" . $_POST['table_parent'] . "' AND table_child = '{$this->table}'"; if ($q_relation = AdaptorMysql::queryRow($sql)) { $i = 0; foreach ($recordData as $column) { if ($column['name'] == $q_relation['column_child']) { array_splice($recordData, $i, 1); break; } $i++; } $q_parent = AdaptorMysql::queryRow("SELECT * FROM " . $_POST['table_parent'] . " WHERE id = " . $_POST['id_parent']); Forms::hidden($_name_space . $q_relation['column_child'], $q_parent[$q_relation['column_parent']]); Forms::hidden('table_parent', $_POST['table_parent'], array('omit_id' => true)); Forms::hidden('id_parent', $q_parent[$q_relation['column_parent']], array('omit_id' => true)); } } //loop items foreach ($recordData as $column) { $options = array(); $col_type = strtolower($column['type']); $value = $column['value']; $col_ready = false; $display_name = Utils::titleCase(str_replace('_', ' ', $column['name'])); $options['label'] = $display_name; $options['name_space'] = $_name_space; $options['db'] = AdaptorMysql::getInstance(); $options['nullable'] = AdaptorMysql::isNullable($this->table, $column['name']); //For primary key that's autoincrementing if ($column['name'] == 'id') { if ($this->query_action == "update") { Forms::hidden($_name_space . $column['name'], $value, $options); } $col_ready = true; } //plugins //col_config needs to be created for each column in the model = FAIL if ($column['config'] && !$col_ready) { $q_col = $column['config']; if ($q_col['default_value'] != '' && $this->mode == "insert") { $value = $q_col['default_value']; } if (strlen($q_col['help']) > 1) { $options['tip'] = $q_col['help']; } if ($q_col['display_name'] != '') { $display_name = $q_col['display_name']; } $options['label'] = $display_name; $module = $q_col['edit_module']; if (strlen($q_col['edit_config']) > 1) { $config = _ControllerFront::parseConfig($q_col['edit_config']); $options = array_merge($options, $config); } if ($q_col['validate'] != '') { $options = array_merge($options, _ControllerFront::parseConfig($q_col['validate'])); } if ($module != "") { switch ($module) { case "module": break; case "plugin": $options['table'] = $this->table; $options['mode'] = $this->mode; $options['row_data'] = $row_data; $options['id'] = $this->id; $options['col_name'] = $column['name']; _ControllerFront::pluginColumnEdit($_name_space . $column['name'], $value, $options); $col_ready = true; break; case "position": //build a selectDefault but with special options ehh $options['col_display'] = $column['name']; $options['col_value'] = $column['name']; //do it manual style, to accomodate constraint change or late entries //do a relative selection of position, based upon existing list.. oh! //factor in the contraint if set //factor in null if (isset($config['col_constraint'])) { //check if we're nullable if (AdaptorMysql::isNullable($this->table, $config['col_constraint']) && Utils::isNull($row_data[$config['col_constraint']]['value'])) { $_v = "IS NULL"; } else { $_v = ' = \'' . $row_data[$config['col_constraint']]['value'] . '\''; } $options['select_sql'] = "SELECT * FROM `{$this->table}` WHERE `{$config['col_constraint']}` " . $_v . " ORDER BY `{$column['name']}`"; } else { $options['select_sql'] = "SELECT * FROM `{$this->table}` ORDER BY `{$column['name']}`"; } $options['table'] = $this->table; $options['col_name'] = $column['name']; $options['id'] = $this->id; $options['name_space'] = $_name_space; $options['label'] = $display_name; $options['allow_null'] = false; Forms::selectDefault($_name_space . $column['name'], $value, $options); $col_ready = true; break; case "slug": $source = isset($config['col_source']) ? $_name_space . $config['col_source'] : null; Forms::text($_name_space . $column['name'], $value, $options); print ' <script type="text/javascript"> Event.observe(window,\'load\', function(){createSlug(\'' . $_name_space . $column['name'] . '\',\'' . $source . '\')}, true); </script> '; $col_ready = true; break; case "disabled": $col_ready = true; break; default: $options['table'] = $this->table; $options['col_name'] = $column['name']; $options['id'] = $this->id; $options['name_space'] = $_name_space; $options['label'] = $display_name; //add database datasource for countries and states if ($module == 'selectState') { $options['datasource'] = BLACKBIRD_TABLE_PREFIX . 'states'; } if ($module == 'selectCountry') { $options['datasource'] = BLACKBIRD_TABLE_PREFIX . 'countries'; } Forms::$module($_name_space . $column['name'], $value, $options); $col_ready = true; break; } } } //defaults if (!$col_ready) { switch (true) { case $col_type == 'datetime' || $col_type == 'timestamp': Forms::selectDateTime($_name_space . $column['name'], $value, $options); break; case $col_type == 'date': Forms::selectDate($_name_space . $column['name'], $value, $options); break; case $col_type == 'time': Forms::selectTime($_name_space . $column['name'], $value, $options); break; case $col_type == 'text' || $col_type == 'longtext' || $col_type == 'tinytext' || $col_type == 'mediumtext': Forms::textarea($_name_space . $column['name'], $value, $options); break; default: Forms::text($_name_space . $column['name'], $value, $options); break; } } } $r = ob_get_contents(); ob_end_clean(); return $r; }