/** * save the form * @param array $data (the jform part of the request data) */ function save($data) { $this->populateState(); $app = JFactory::getApplication(); $user = JFactory::getUser(); $config = JFactory::getConfig(); $date = JFactory::getDate(); $row = $this->getTable(); $id = $data['id']; $row->load($id); $this->setState('list.id', $id); $this->setState('list.form_id', $row->form_id); $feModel = $this->getFEModel(); $formModel = $this->getFormModel(); if (!$row->bind($data)) { $this->setError($row->getError()); return false; } $filter = new JFilterInput(null, null, 1, 1); $introduction = JRequest::getVar('introduction', '', 'post', 'string', JREQUEST_ALLOWRAW); $row->introduction = $filter->clean($introduction); $row->order_by = json_encode(JRequest::getVar('order_by', array(), 'post', 'array')); $row->order_dir = json_encode(JRequest::getVar('order_dir', array(), 'post', 'array')); if (!$row->check()) { $this->setError($row->getError()); return false; } $isNew = true; if ($id == 0) { if ($row->created == '') { $row->created = $date->toMySQL(); } //save the row now $row->store(); $isNew = false; $newtable = trim(JArrayHelper::getValue($data, '_database_name')); // $$$ 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->getFEModel()->databaseTableExists($newtable)) { $this->setError(JText::_('COM_FABRIK_DATABASE_TABLE_ALREADY_EXISTS')); return false; } if (!$this->canCreateDbTable()) { $this->setError(Jtext::_('COM_FABRIK_INSUFFICIENT_RIGHTS_TO_CREATE_TABLE')); return false; } //create fabrik form $formModel =& $this->createLinkedForm(); $row->form_id = $this->getState('list.form_id'); //create fabrik group $groupData = array("name" => $row->label, "label" => $row->label); JRequest::setVar('_createGroup', 1, 'post'); $groupId = $this->createLinkedGroup($groupData, false); if ($newtable == '') { //new fabrik table but existing db table $this->createLinkedElements($groupId); } else { $row->db_table_name = $newtable; $row->db_primary_key = $newtable . '.id'; $row->auto_inc = 1; $res = $feModel->createDBTable($formModel, $newtable); } } // save params - this file no longer exists? do we use models/table.xml instead?? $params = new fabrikParams($row->params, JPATH_COMPONENT . DS . 'xml' . DS . 'table.xml'); 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 = JArrayHelper::getValue($data, 'db_primary_key'); if ($pk == '') { $fields = $row->getFields(); $key = $row->getKeyName(); //store without namequotes as thats db specific $row->db_primary_key = $row->db_table_name . "." . $key; $row->auto_inc = stristr($fields[$key]->Extra, 'auto_increment') ? true : false; } if (!$row->store()) { $this->setError($row->getError()); return false; } $pk = $row->db_primary_key; $this->updateJoins($data); $feModel->setTable($row); //needed to ensure pk field is not quoted if (!$feModel->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); } //make an array of elments and a presumed index size //map is then used in creating indexes $map = array(); $groups =& $this->getFormModel()->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'; } } $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)) { $feModel->addIndex($orderBy, 'tableorder', 'INDEX', $map[$orderBy]); } } } if ($row->group_by !== '' && array_key_exists($row->group_by, $map)) { $feModel->addIndex($row->group_by, 'groupby', 'INDEX', $map["{$row->group_by}"]); } if ($params->get('group_by_order') !== '') { $feModel->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) { if (array_key_exists($field, $map)) { $feModel->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()) { $this->setError(JTEXT::_("Unable to make Joomfish XML file")); return false; } } else { $this->removeJoomfishXML(); } } $pkName = $row->getKeyName(); if (isset($row->{$pkName})) { $this->setState($this->getName() . '.id', $row->{$pkName}); } $this->setState($this->getName() . '.new', $isNew); return true; }
/** * 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 a visualization */ function save() { // Check for request forgeries JRequest::checkToken() or die('Invalid Token'); $task = JRequest::getCmd('task'); $pluginManager =& JModel::getInstance('Pluginmanager', 'FabrikModel'); $className = JRequest::getVar('plugin', 'calendar', 'post'); $pluginModel =& $pluginManager->getPlugIn($className, 'visualization'); $id = JRequest::getInt('id', 0, 'post'); $pluginModel->setId($id); $row =& JTable::getInstance('visualization', 'Table'); $post = JRequest::get('post'); if (!$row->bind($post)) { return JError::raiseWarning(500, $row->getError()); } //$filter = new JFilterInput(null, null, 1, 1); list($dofilter, $filter) = FabrikWorker::getContentFilter(); $intro_text = JRequest::getVar('intro_text', '', 'post', 'string', JREQUEST_ALLOWRAW); $row->intro_text = $dofilter ? $filter->clean($intro_text) : $intro_text; $details = JRequest::getVar('details', array(), 'post', 'array'); $row->bind($details); // save params $pluginModel->attribs =& $row->attribs; $params = $pluginModel->getParams(); $row->attribs = $params->updateAttribsFromParams(JRequest::getVar('params', array(), 'post', 'array')); FabrikHelper::prepareSaveDate($row->publish_down); FabrikHelper::prepareSaveDate($row->created); FabrikHelper::prepareSaveDate($row->publish_up); $user =& JFactory::getUser(); 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(); switch ($task) { case 'apply': $link = 'index.php?option=com_fabrik&c=visualization&task=edit&cid[]=' . $row->id; $msg = JText::_('VISUALIZATION SAVED'); break; case 'save': default: $link = 'index.php?option=com_fabrik&c=visualization'; $msg = JText::_('VISUALIZATION SAVED'); break; } $this->setRedirect($link, $msg); }
/** * 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; }