PHP FabrikWorker::getConnection方法代码示例

 /**
  * Install sample data
  *
  * @return  void
  */
 public function installSampleData()
 {
     $cnn = FabrikWorker::getConnection();
     $defaultDb = $cnn->getDb();
     $db = FabrikWorker::getDbo(true);
     $group = $this->getTable('Group');
     $config = $this->config;
     $dbTableName = $config->get('dbprefix') . "fb_contact_sample";
     echo "<div style='text-align:left;border:1px dotted #cccccc;padding:10px;'>" . "<h3>Installing data...</h3><ol>";
     $group->name = "Contact Details";
     $group->label = "Contact Details";
     $group->published = 1;
     if (!$group->store()) {
         return JError::raiseWarning(500, $group->getError());
     }
     $groupId = $db->insertid();
     $defaultDb->dropTable($dbTableName);
     echo "<li>Group 'Contact Details' created</li>";
     echo "<li>Element 'Email' added to group 'Contact Details'</li>";
     $group = $this->getTable('Group');
     $group->name = "Your Enquiry";
     $group->label = "Your Enquiry";
     $group->published = 1;
     $group->store();
     $group2Id = $db->insertid();
     echo "<li>Group 'Your Enquiry' created</li>";
     echo "<li>Element 'Message' added to group 'Your Enquiry'</li>";
     $form = $this->getTable('Form');
     $form->label = "Contact Us";
     $form->record_in_database = 1;
     $form->intro = "This is a sample contact us form, that is stored in a database table";
     $form->submit_button_label = "Submit";
     $form->published = 1;
     $form->form_template = "default";
     $form->view_only_template = "default";
     $form->store();
     echo "<li>Form 'Contact Us' created</li>";
     $formId = $db->insertid();
     $query = $db->getQuery(true);
     $query->insert('#__{package}_formgroup')->set(array('form_id=' . (int) $formId, 'group_id=' . (int) $groupId, 'ordering=0'));
     $db->setQuery($query);
     $db->execute();
     $query = $db->getQuery(true);
     $query->insert('#__{package}_formgroup')->set(array('form_id=' . (int) $formId, 'group_id=' . (int) $group2Id, 'ordering=1'));
     $db->setQuery($query);
     $db->execute();
     echo "<li>Groups added to 'Contact Us' form</li>";
     $listModel = JModelLegacy::getInstance('List', 'FabrikAdminModel');
     $list = $this->getTable('List');
     $list->label = "Contact Us Data";
     $list->introduction = "This table stores the data submitted in the contact us form";
     $list->form_id = $formId;
     $list->connection_id = $cnn->getConnection()->id;
     $list->db_table_name = $dbTableName;
     // Store without name quotes as that's db specific
     $list->db_primary_key = $dbTableName . '.id';
     $list->auto_inc = 1;
     $list->published = 1;
     $list->rows_per_page = 10;
     $list->params = $listModel->getDefaultParams();
     $list->template = 'default';
     $list->store();
     echo "<li>Table for 'Contact Us' created</li></div>";
     $form->store();
     $formModel = JModelLegacy::getInstance('Form', 'FabrikFEModel');
     $formModel->setId($form->id);
     $formModel->form = $form;
     $listModel->setState('list.id', $list->id);
     $listModel->getItem();
     $elements = array('id' => array('plugin' => 'internalid', 'label' => 'id', 'group_id' => $groupId), 'first_name' => array('plugin' => 'field', 'label' => 'First Name', 'group_id' => $groupId), 'last_name' => array('plugin' => 'field', 'label' => 'Last Name', 'group_id' => $groupId), 'email' => array('plugin' => 'field', 'label' => 'Email', 'group_id' => $groupId), 'message' => array('plugin' => 'textarea', 'group_id' => $group2Id));
     return $listModel->createDBTable($list->db_table_name, $elements);
 }

 /**
  * Load the database object associated with the list
  *
  * @since   3.0b
  *
  * @return  object database
  */
 public function &getDb()
 {
     $listId = $this->getState('list.id');
     $item = $this->getItem($listId);
     return FabrikWorker::getConnection($item)->getDb();
 }

 /**
  * After having saved the form we
  * 1) Create a new group if none selected in edit form list
  * 2) Delete all old form_group records
  * 3) Recreate the form group records
  * 4) Make a list view if needed
  *
  * @param   array $data jForm data
  *
  * @throws Exception
  *
  * @return  bool  True if you should display the form list, False if you're
  * redirected elsewhere
  */
 public function saveFormGroups($data)
 {
     // These are set in parent::save() and contain the updated form id and if the form is a new form
     $formId = (int) $this->getState($this->getName() . '.id');
     $isNew = (bool) $this->getState($this->getName() . '.new');
     /** @var FabrikAdminModelList $listModel */
     $listModel = JModelLegacy::getInstance('List', 'FabrikAdminModel');
     $item = $listModel->loadFromFormId($formId);
     $listModel->set('form.id', $formId);
     $listModel->setState('list.form_id', $formId);
     $recordInDatabase = $data['record_in_database'];
     $dbTableName = $this->safeTableName($isNew, $data, $item);
     $fields = $this->getInsertFields($isNew, $data, $listModel, $dbTableName);
     if ($recordInDatabase != '1') {
         return;
     }
     $dbTableExists = $listModel->databaseTableExists($dbTableName);
     if (!$dbTableExists) {
         $listModel->createDBTable($dbTableName, $fields);
     }
     if (!$dbTableExists || $isNew) {
         $connection = FabrikWorker::getConnection(-1);
         $item->set('id', null);
         $item->set('label', $data['label']);
         $item->set('form_id', $formId);
         $item->set('connection_id', $connection->getConnection()->id);
         $item->set('db_table_name', $dbTableName);
         // Store key without quoteNames as that is db specific which we no longer want
         $item->set('db_primary_key', $dbTableName . '.id');
         $item->set('auto_inc', 1);
         $item->set('published', $data['published']);
         $item->set('created', $data['created']);
         $item->set('created_by', $data['created_by']);
         $item->set('access', 1);
         $item->set('params', $listModel->getDefaultParams());
         $item->store();
         $this->contentTypeModel->finalise($item);
     } else {
         // Update existing table (seems to need to reload here to ensure that _table is set)
         $listModel->loadFromFormId($formId);
         $listModel->ammendTable();
         $currentGroups = (array) FArrayHelper::getValue($data, 'current_groups');
         $this->_makeFormGroups($currentGroups);
     }
 }

 /**
  * Get the lists connection object
  * sets $this->connection to the lists connection
  *
  * @deprecated since 3.0b use FabrikWorker::getConnection() instead
  *
  * @return  object	connection
  */
 public function &getConnection()
 {
     $this->connection = FabrikWorker::getConnection($this->getTable());
     return $this->connection;
 }

 /**
  * After having saved the form we
  * 1) Create a new group if none selected in edit form list
  * 2) Delete all old form_group records
  * 3) Recreate the form group records
  * 4) Make a table view if needed
  *
  * @param   array  $data  jform data
  *
  * @return  bool  True if you should display the form list, False if you're
  * redirected elsewhere
  */
 public function saveFormGroups($data)
 {
     // These are set in parent::save() and contain the updated form id and if the form is a new form
     $formid = $this->getState($this->getName() . '.id');
     $isnew = $this->getState($this->getName() . '.new');
     $db = FabrikWorker::getDbo(true);
     $currentGroups = (array) JArrayHelper::getValue($data, 'current_groups');
     $record_in_database = $data['record_in_database'];
     $createGroup = $data['_createGroup'];
     $form = $this->getForm();
     $fields = array('id' => 'internalid', 'date_time' => 'date');
     // If new and record in db and group selected then we want to get those groups elements to create fields for in the db table
     if ($isnew && $record_in_database) {
         $groups = JArrayHelper::getValue($data, 'current_groups');
         if (!empty($groups)) {
             $query = $db->getQuery(true);
             $query->select('plugin, name')->from('#__fabrik_elements')->where('group_id IN (' . implode(',', $groups) . ')');
             $db->setQuery($query);
             $rows = $db->loadObjectList();
             foreach ($rows as $row) {
                 $fields[$row->name] = $row->plugin;
             }
         }
     }
     if ($createGroup) {
         $group = FabTable::getInstance('Group', 'FabrikTable');
         $group->name = $data['label'];
         $group->published = 1;
         $group->store();
         $currentGroups[] = $db->insertid();
     }
     $this->_makeFormGroups($data, $currentGroups);
     if ($record_in_database == '1') {
         $listModel = JModel::getInstance('List', 'FabrikModel');
         $item = $listModel->loadFromFormId($formid);
         if ($isnew) {
             $dbTableName = $data['db_table_name'] !== '' ? $data['db_table_name'] : $data['label'];
             // Mysql will force db table names to lower case even if you set the db name to upper case - so use clean()
             $dbTableName = FabrikString::clean($dbTableName);
             // Otherwise part of the table name is taken for element names
             $dbTableName = str_replace('___', '_', $dbTableName);
         } else {
             $dbTableName = $item->db_table_name == '' ? $data['database_name'] : $item->db_table_name;
         }
         $dbTableExists = $listModel->databaseTableExists($dbTableName);
         if (!$dbTableExists) {
             /**
              * @TODO - need to sanitize table name (get rid of non alphanumeirc or _),
              * just not sure whether to do it here, or above (before we test for existinance)
              * $$$ hugh - for now, just do it here, after we test for the 'unsanitized', as
              * need to do some more testing on MySQL table name case sensitivity
              * BUT ... as we're potentially changing the table name after testing for existance
              * we need to test again.
              * $$$ rob - was replacing with '_' but if your form name was 'x - y' then this was
              * converted to x___y which then blows up element name code due to '___' being presumed to be the element splitter.
              */
             $dbTableName = preg_replace('#[^0-9a-zA-Z_]#', '', $dbTableName);
             if ($listModel->databaseTableExists($dbTableName)) {
                 return JError::raiseWarning(500, JText::_("COM_FABRIK_DB_TABLE_ALREADY_EXISTS"));
             }
             $listModel->set('form.id', $formid);
             $listModel->createDBTable($dbTableName, $fields);
         }
         if (!$dbTableExists || $isnew) {
             $connection = FabrikWorker::getConnection(-1);
             $item->id = null;
             $item->label = $data['label'];
             $item->form_id = $formid;
             $item->connection_id = $connection->getConnection()->id;
             $item->db_table_name = $dbTableName;
             // Store key without quoteNames as thats db specific *which we no longer want
             $item->db_primary_key = $dbTableName . '.id';
             $item->auto_inc = 1;
             $item->published = $data['published'];
             $item->created = $data['created'];
             $item->created_by = $data['created_by'];
             $item->access = 1;
             $item->params = $listModel->getDefaultParams();
             $res = $item->store();
         } else {
             // Update existing table (seems to need to reload here to ensure that _table is set
             $item = $listModel->loadFromFormId($formid);
             $listModel->ammendTable();
         }
     }
 }

 /**
  * function get the tables connection object
  * sets $this->_oConn to the tables connection
  * @deprecated since 3.0b use FabrikWorker::getConnection() instead
  * @return object connection
  */
 function &getConnection()
 {
     $this->_oConn = FabrikWorker::getConnection($this->getTable());
     return $this->_oConn;
 }

 /**
  * Load the database object associated with the list
  *
  * @since   3.0b
  *
  * @return  object database
  */
 public function &getDb()
 {
     return FabrikWorker::getConnection($this->getItem())->getDb();
 }