function display($tmpl = null) { $document = JFactory::getDocument(); $document->addScript(JURI::root() . 'media' . DS . 'com_jmm' . DS . 'js' . DS . 'jquery-1.7.2.min.js'); $document->addScript(JURI::root() . 'media' . DS . 'com_jmm' . DS . 'js' . DS . 'export.js'); $action = JRequest::getString('action', ''); $limit = JRequest::getInt('limit', 15); $limitstart = JRequest::getInt('limitstart', 0); $pagination = '&limit=' . $limit . '&limitstart=' . $limitstart; $filter_order = JRequest::getString('filter_order', null); $filter_order_Dir = JRequest::getString('filter_order_Dir', null); if (isset($filter_order) && isset($filter_order_Dir)) { $pagination .= '&filter_order=' . $filter_order . '&filter_order_Dir=' . $filter_order_Dir; } $tbl = JRequest::getString('tbl'); $filter_browsetable = JRequest::getVar('filter_browsetable', ''); if (isset($_REQUEST['dbname'])) { $dbname = JRequest::getVar('dbname'); $urlString = '&dbname=' . $dbname; } else { $urlString = ''; } if ($filter_browsetable != '') { JFactory::getApplication()->redirect('index.php?option=com_jmm&view=tables&action=browse&tbl=' . $filter_browsetable . $urlString . $pagination, 'Table Data of ' . $filter_browsetable); } $filter_tablestructure = JRequest::getVar('filter_tablestructure'); if ($filter_tablestructure != '') { JFactory::getApplication()->redirect('index.php?option=com_jmm&view=tables&action=structure&tbl=' . $filter_tablestructure . $urlString, 'Table Structure of ' . $filter_tablestructure); } $filter_chnagedatabase = JRequest::getVar('filter_chnagedatabase', ''); if ($filter_chnagedatabase != '') { JFactory::getApplication()->redirect('index.php?option=com_jmm&view=tables&dbname=' . $filter_chnagedatabase, 'Database Switched to ' . $filter_chnagedatabase); } switch ($action) { case 'structure': $this->items = JMMCommon::showTableStructure($tbl); JFactory::getApplication()->enqueueMessage('Table Structure of ' . $tbl, 'message'); break; case 'browse': $this->items = $this->get('Items'); JFactory::getApplication()->enqueueMessage('Table Data of ' . $tbl, 'message'); break; default: $this->items = JMMCommon::showTableLists(); JFactory::getApplication()->enqueueMessage('Table Lists', 'message'); break; } $this->tables = $this->get('Tables'); $this->databases = $this->get('Databases'); $this->pagination = $this->get('Pagination'); $this->state = $this->get('State'); $this->addToolbar(); parent::display($tmpl); }
public function getInput() { $table = JRequest::getVar('tbl'); $dbname = JRequest::getVar('dbname'); $tableFields = JMMCommon::showTableStructure($table); for ($i = 0; $i < count($tableFields); $i++) { $field = $tableFields[$i]; $tmp = explode('(', $field['Type']); $name = $field['Field']; $type = $tmp[0]; $length = (int) str_replace(')', '', $tmp[1]); $length += 1; $id = 'jform_' . $name; $label_name = ucwords($name) . ' (' . $type . ')'; $label_id = 'jform_' . $name . '-lbl'; $this->drawForm("jform[{$name}]", $type, $id, $label_name, $label_id, $length); } return $this->formData; }