/** * Save group */ function save() { // Check for request forgeries JRequest::checkToken() or die('Invalid Token'); $db =& JFactory::getDBO(); $row =& JTable::getInstance('Group', 'FabrikTable'); $post = JRequest::get('post'); if (!$row->bind($post)) { return JError::raiseWarning(500, $row->getError()); } // save params $params = new fabrikParams($row->attribs, JPATH_COMPONENT . DS . 'xml' . DS . 'group.xml'); $row->attribs = $params->updateAttribsFromParams(JRequest::getVar('params', array(), 'post', 'array')); if (!$row->store()) { return JError::raiseWarning(500, $row->getError()); } $row->checkin(); $task = JRequest::getCmd('task'); //update the group's element table definitons, currently used for database join element //which if part of a repeat group should revert to varchar(255) regardless of what table //field it joins to $groupModel =& JModel::getInstance('Group', 'FabrikModel'); $groupModel->setId($row->id); $elements =& $groupModel->getMyElements(); $c = 0; foreach ($elements as $element) { if ($c === 0) { $tableModel =& $element->getTableModel(); // $$$ hugh - this was screwing up if it's a joined group, tried to modify // columns on main form's table instead of joined table! // So if it's a joined group, need to get table name from join model if ($groupModel->isJoin()) { $joinModel =& $groupModel->getJoinModel(); $joinTable =& $joinModel->getJoin(); $tableName = $joinTable->table_join; } else { $table =& $tableModel->getTable(); $tableName = $table->db_table_name; } // $$$ hugh - at the moment, connection details will be same even it's a join, as // we don't do cross database joins. But at some point may need to modify this // this bit as well to get connection from join. $fabrikDb =& $tableModel->getDb(); } $elementName = $element->getElement()->name; $objtype = $element->getFieldDescription(); // $$$ hugh - changed this to use $tableName derived above instead of $table->db_table_name $query = "ALTER TABLE " . FabrikString::safeColName($tableName) . " CHANGE " . $fabrikDb->nameQuote($elementName) . " " . $fabrikDb->nameQuote($elementName) . " {$objtype}"; $fabrikDb->setQuery($query); $fabrikDb->query(); $c++; } switch ($task) { case 'apply': $link = 'index.php?option=com_fabrik&c=group&task=edit&cid[]=' . $row->id; break; case 'save': default: $link = 'index.php?option=com_fabrik&c=group'; break; } $cache =& JFactory::getCache('com_fabrik'); $cache->clean(); $this->setRedirect($link, JText::_('GROUP SAVED')); }
/** * Save package */ function save() { // Check for request forgeries JRequest::checkToken() or die('Invalid Token'); jimport('joomla.utilities.date'); $now = new JDate(); $now = $now->toUnix(); $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $row =& JTable::getInstance('package', 'Table'); $post = JRequest::get('post'); if (!$row->bind($post)) { return JError::raiseWarning(500, $row->getError()); } // save params $params = new fabrikParams($row->attribs, JPATH_COMPONENT . DS . 'xml' . DS . 'package.xml'); $row->attribs = $params->updateAttribsFromParams(JRequest::getVar('params', array(), 'post', 'array')); $row->tables = implode(",", JRequest::getVar('tables', array(), 'post')); if ($row->id == 0) { $row->created = $now; } else { $row->modified = $now; $row->modified_by = $user->get('id'); } if (!$row->store()) { return JError::raiseWarning(500, $row->getError()); } $row->checkin(); $task = JRequest::getCmd('task'); $msg = JText::_('PACKAGE SAVED'); switch ($task) { case 'apply': $link = 'index.php?option=com_fabrik&c=package&task=edit&cid[]=' . $row->id; break; case 'save': default: $link = 'index.php?option=com_fabrik&c=package'; break; } $this->setRedirect($link, $msg); }
protected function updateMetaSettings($model, $tmpldata = array()) { $db =& JFactory::getDBO(); if ($model === false) { $db->setQuery("select id from #__fabrik_tables where db_table_name = " . $db->Quote($this->tbl)); $tid = $db->loadResult(); $model = JModel::getInstance('table', 'FabrikModel'); $model->setId($tid); } $elements = $model->getForm()->getFormGroups(); foreach ($tmpldata as $fullElName => $data) { $shortName = array_pop(explode("___", $fullElName)); $filterType = JArrayHelper::getValue($data, 'filter_type'); foreach ($elements as $el) { if ($el->name == $shortName) { $db->setQuery("update #__elements set filter_type = " . $db->Quote($filterType) . " where id = " . (int) $el->id); $db->Query(); } } } //set the search type $table = $model->getTable(); $attribs = $table->attribs; $params = new fabrikParams($attribs, JPATH_COMPONENT . DS . 'xml' . DS . 'table.xml'); $aparams = $params->toArray(); $aparams['search-mode'] = $this->searchMode ? 'OR' : 'AND'; $params->empty_data_msg = 'No records found'; $table->attribs = $params->updateAttribsFromParams($aparams); $table->store(); }
/** * Save cron */ function save() { // Check for request forgeries JRequest::checkToken() or die('Invalid Token'); jimport('joomla.utilities.date'); $user =& JFactory::getUser(); $db =& JFactory::getDBO(); $row =& JTable::getInstance('cron', 'Table'); $post = JRequest::get('post'); // $$$ hugh - published state is checkbox, so doesn't seem to be in post array if not selected if (!isset($post['state'])) { $post['state'] = '0'; } if (!$row->bind($post)) { return JError::raiseWarning(500, $row->getError()); } $now = new JDate(); if ($row->id == 0) { $row->created = $now->toMySQL(); $row->created_by = $user->get('id'); $row->created_by_alias = $user->get('username'); } else { $row->modified = $now->toMySQL(); $row->modified_by = $user->get('id'); } //set the lastrun date to be that shown in the date selections echo JRequest::getVar('lastrun'); // save params $params = new fabrikParams($row->attribs, JPATH_COMPONENT . DS . 'xml' . DS . 'cron.xml'); $row->attribs = $params->updateAttribsFromParams(JRequest::getVar('params', array(), 'post', 'array')); $this->crontab_set($row->frequency, $row->unit); if (!$row->store()) { return JError::raiseWarning(500, $row->getError()); } $row->checkin(); $task = JRequest::getCmd('task'); switch ($task) { case 'apply': $link = 'index.php?option=com_fabrik&c=cron&task=edit&cid[]=' . $row->id; break; case 'save': default: $link = 'index.php?option=com_fabrik&c=cron'; break; } $this->setRedirect($link, JText::_('CRON SAVED')); }
/** * Save a connection */ function save() { // Check for request forgeries JRequest::checkToken() or die('Invalid Token'); // clear form from session $session =& JFactory::getSession(); $session->clear('com_fabrik.admin.form.edit.model'); jimport('joomla.utilities.date'); $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $formModel =& JModel::getInstance('Form', 'FabrikModel'); $formModel->setId(JRequest::getInt('id')); $formModel->getForm(); $row =& JTable::getInstance('form', 'Table'); $post = JRequest::get('post'); if (!$row->bind($post)) { return JError::raiseWarning(500, $row->getError()); } list($dofilter, $filter) = FabrikWorker::getContentFilter(); //$filter = new JFilterInput(null, null, 1, 1); $intro = JRequest::getVar('intro', '', 'post', 'string', JREQUEST_ALLOWRAW); $row->intro = $dofilter ? $filter->clean($intro) : $intro; $details = JRequest::getVar('details', array(), 'post', 'array'); $row->bind($details); FabrikHelper::prepareSaveDate($row->publish_down); FabrikHelper::prepareSaveDate($row->created); FabrikHelper::prepareSaveDate($row->publish_up); // save params $params = new fabrikParams($row->attribs, JPATH_COMPONENT . DS . 'model' . DS . 'form.xml'); $row->attribs = $params->updateAttribsFromParams(JRequest::getVar('params', array(), 'post', 'array')); if ($row->id != 0) { $datenow =& JFactory::getDate(); $row->modified = $datenow->toMySQL(); $row->modified_by = $user->get('id'); } if (!$row->store()) { return JError::raiseWarning(500, $row->getError()); } $row->checkin(); $formModel->_id = $row->id; $formModel->_form =& $row; $formModel->saveFormGroups(); $task = JRequest::getCmd('task'); switch ($task) { case 'apply': $link = 'index.php?option=com_fabrik&c=form&task=edit&cid[]=' . $row->id; break; case 'save': default: $link = 'index.php?option=com_fabrik&c=form'; break; } $cache =& JFactory::getCache('com_fabrik'); $cache->clean(); $this->setRedirect($link, JText::_('FORM SAVED')); //for prefab return $formModel; }
/** * save the table from admin * * @return Jerror if not saved true if saved ok */ function save() { $session =& JFactory::getSession(); $app =& JFactory::getApplication(); $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $config =& JFactory::getConfig(); $id = JRequest::getInt('id', 0, 'post'); $this->setId($id); $row =& $this->getTable(false, false); $formModel =& JModel::getInstance('Form', 'FabrikModel'); $post = JRequest::get('post'); if (!$row->bind($post)) { return JError::raiseWarning(500, $row->getError()); } list($dofilter, $filter) = FabrikWorker::getContentFilter(); $introduction = JRequest::getVar('introduction', '', 'post', 'string', JREQUEST_ALLOWRAW); $row->introduction = $dofilter ? $filter->clean($introduction) : $introduction; $details = JRequest::getVar('details', array(), 'post', 'array'); $row->bind($details); $aOrderBy = JRequest::getVar('order_by', array(), 'post', 'array'); $row->order_by = implode(GROUPSPLITTER2, $aOrderBy); $aOrderDir = JRequest::getVar('order_dir', array(), 'post', 'array'); $row->order_dir = implode(GROUPSPLITTER2, $aOrderDir); if (!$row->check()) { $app->setError($row->getError()); return JError::raiseWarning(500, $row->getError()); } if ($id == 0) { $newtable = trim(JRequest::getVar('_database_name', '', 'post')); // $$$ hugh - added some more sanity checking on table name, get rid of non-alphanumeric and _ // @TODO - should prolly use a helper for this, like FabrikString::clean() // but need to think about case issues first $newtable = preg_replace('#[^0-9a-zA-Z_]#', '_', $newtable); //check the entered database table doesnt already exist if ($newtable != '' && $this->databaseTableExists($newtable)) { return JError::raiseWarning(500, JText::_('DATABASE TABLE ALREADY EXISTS')); } if (!$this->canCreateDbTable()) { return JError::raiseWarning(500, Jtext::_('YOUR_DB_USER_HAS_INSUFFICIENT_RIGHTS_TO_CREATE_TABLE')); } //create fabrik form $formModel =& $this->_createLinkedForm(); //create fabrik group $groupData = array("name" => $row->label, "label" => $row->label); JRequest::setVar('_createGroup', 1, 'post'); if ($newtable != '') { $groupId = $this->_createLinkedGroup($groupData, false); $row->db_table_name = $newtable; $row->db_primary_key = "`" . $newtable . '`.`id`'; $row->auto_inc = 1; $res = $this->createDBTable($formModel, $newtable); } else { // 2.0.5 balsamiq to fabrik tmpl generator sets up group properties in session, if we find those lets make // n groups each with their own groupid $groupDatas = array($groupData); if ($session->has('com_fabrik.list.create.groupmap')) { $groupDatas =& $session->get('com_fabrik.list.create.groupmap'); } $groupMap = array(); foreach ($groupDatas as $x => $groupData) { $groupId = $this->_createLinkedGroup($groupData, false); $groupMap[$x] = $groupId; } //set element group ids if ($session->has('com_fabrik.list.create.elementmap')) { $map = (array) $session->get('com_fabrik.list.create.elementmap'); foreach ($map as &$m) { $groupMapId = array_key_exists('groupid', $m) ? $m['groupid'] : 0; $m['groupid'] = $groupMap[$groupMapId]; } $session->set('com_fabrik.list.create.elementmap', $map); } // save elements in group foreach ($groupMap as $groupId) { $this->_createLinkedElements($groupId, $post); } } // set the tables form id $this->_updateFormId($formModel->_form->id); } // save params - this file no longer exists? do we use models/table.xml instead?? $params = new fabrikParams($row->attribs, JPATH_COMPONENT . DS . 'xml' . DS . 'table.xml'); $row->attribs = $params->updateAttribsFromParams(JRequest::getVar('params', array(), 'post', 'array')); $row->rows_per_page = JRequest::getInt('rows_per_page', 10, 'post'); if ($row->id != 0) { $datenow =& JFactory::getDate(); $row->modified = $datenow->toMySQL(); $row->modified_by = $user->get('id'); } FabrikHelper::prepareSaveDate($row->publish_down); FabrikHelper::prepareSaveDate($row->created); FabrikHelper::prepareSaveDate($row->publish_up); $pk = JRequest::getVar('db_primary_key'); if ($pk == '') { $aKey = $this->getPrimaryKeyAndExtra(); $aKey = $aKey[0]; $row->db_primary_key = "`" . $row->db_table_name . "`.`" . $aKey['colname'] . "`"; $row->auto_inc = stristr($aKey['extra'], 'auto_increment') ? true : false; } if (!$row->store()) { return JError::raiseWarning(500, $row->getError()); } // load in all the tables data - even if it wasnt in the post data $table =& $this->getTable(); //needed if saving a table for first time (otherwise id = 0) $this->setId($table->id); $this->updateJoins(); if (!$this->isView()) { // this was only run on a new table - but I've put it here so that if you upload a new table you can ensure that its columns are fixed $this->makeSafeTableColumns(); $this->updatePrimaryKey($row->db_primary_key, $row->auto_inc); } $row->checkin(); //make an array of elments and a presumed index size //map is then used in creating indexes $map = array(); $groups =& $this->getForm()->getGroupsHiarachy(); foreach ($groups as $groupModel) { $elementModels =& $groupModel->getMyElements(); foreach ($elementModels as $element) { //int elements cant have a index size attrib // $$$ hugh neither can DATETIME $coltype = $element->getFieldDescription(); if (JString::stristr($coltype, 'int')) { $size = ''; } else { if (JString::stristr($coltype, 'datetime')) { $size = ''; } else { $size = 10; // $$$ hugh - adding index will barf if key size > varchar size. $matches = array(); if (preg_match('/varchar\\((\\d+)\\)/i', $coltype, $matches)) { $varchar_size = (int) $matches[1]; if ($varchar_size < 10) { $size = $varchar_size; } } } } $map[$element->getFullName(false, false, false)] = $size; $map[$element->getElement()->id] = $size; } } //update indexes (added array_key_exists check as these may be during after CSV import) if (!empty($aOrderBy) && array_key_exists($row->order_by, $map)) { foreach ($aOrderBy as $orderBy) { if (array_key_exists($orderBy, $map)) { $this->addIndex($orderBy, 'tableorder', 'INDEX', $map[$orderBy]); } } } if ($row->group_by !== '' && array_key_exists($row->group_by, $map)) { $this->addIndex($row->group_by, 'groupby', 'INDEX', $map["{$row->group_by}"]); } if ($params->get('group_by_order') !== '') { $this->addIndex($params->get('group_by_order'), 'groupbyorder', 'INDEX', $map[$params->get('group_by_order')]); } $afilterFields = $params->get('filter-fields', '', '_default', 'array'); foreach ($afilterFields as $field) { $field = str_replace('`', '', $field); $this->addIndex($field, 'prefilter', 'INDEX', $map[$field]); } if (JFolder::exists(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_joomfish' . DS . 'contentelements')) { if ($params->get('allow-data-translation')) { if (!$this->makeJoomfishXML()) { JError::raiseNotice('E_ERROR', JTEXT::_("Unable to make Joomfish XML file")); } } else { $this->removeJoomfishXML(); } } return true; }