static function edit($option, $tabpane, $pkg, $ids, $caller) { global $database; JArrayHelper::toInteger($ids); $database = JFactory::getDBO(); $row = new facileFormsForms($database); if ($ids[0]) { $row->load($ids[0]); } else { $row->package = $pkg; $row->class1 = 'content_outline'; $row->width = 400; $row->widthmode = 0; $row->height = 500; $row->heightmode = 0; $row->pages = 1; $row->emailntf = 1; $row->mb_emailntf = 1; $row->emaillog = 1; $row->mb_emaillog = 1; $row->emailxml = 0; $row->mb_emailxml = 0; $row->dblog = 1; $row->script1cond = 0; $row->script2cond = 0; $row->piece1cond = 0; $row->piece2cond = 0; $row->piece3cond = 0; $row->piece4cond = 0; $row->published = 1; $row->runmode = 0; $row->prevmode = 2; $row->prevwidth = 400; $row->custom_mail_subject = ''; $row->mb_custom_mail_subject = ''; $row->alt_mailfrom = ''; $row->mb_alt_mailfrom = ''; $row->alt_fromname = ''; $row->mb_alt_fromname = ''; $row->email_type = 0; $row->mb_email_type = 0; $row->email_custom_html = 0; $row->mb_email_custom_html = 0; $row->email_custom_template = ''; $row->mb_email_custom_template = ''; $row->salesforce_token = ''; $row->salesforce_enabled = 0; $row->salesforce_fields = ''; $row->salesforce_username = ''; $row->salesforce_password = ''; $row->dropbox_email = ''; $row->dropbox_password = ''; $row->dropbox_folder = ''; $row->dropbox_submission_enabled = 0; $row->dropbox_submission_types = 'pdf'; $row->tags_form = ''; $row->tags_content = ''; $row->tags_content_template = ''; $row->tags_content_template_default_element = 0; $row->tags_content_default_category = 1; $row->tags_content_default_state = 1; $row->tags_content_default_access = 1; $row->tags_content_default_language = '*'; $row->tags_content_default_featured = 0; $row->tags_content_default_publishup = ''; $row->tags_content_default_publishdown = ''; $row->autoheight = 0; $database->setQuery("select max(ordering)+1 from #__facileforms_forms"); $row->ordering = $database->loadResult(); } // if if ($row->tags_content_default_publishup == '0000-00-00 00:00:00') { $row->tags_content_default_publishup = ''; } if ($row->tags_content_default_publishdown == '0000-00-00 00:00:00') { $row->tags_content_default_publishdown = ''; } $row->dropbox_submission_types = explode(',', $row->dropbox_submission_types); $row->salesforce_types = array(); $row->salesforce_type_fields = array(); $row->breezingforms_fields = array(); $row->salesforce_error = ''; if ($row->salesforce_enabled && $ids[0]) { try { define("BF_SOAP_CLIENT_BASEDIR", JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_breezingforms' . DS . 'libraries' . DS . 'salesforce'); if (!class_exists('SforcePartnerClient')) { require_once BF_SOAP_CLIENT_BASEDIR . '/SforcePartnerClient.php'; } if (!class_exists('SforceHeaderOptions')) { require_once BF_SOAP_CLIENT_BASEDIR . '/SforceHeaderOptions.php'; } $mySforceConnection = new SforcePartnerClient(); $mySoapClient = $mySforceConnection->createConnection(BF_SOAP_CLIENT_BASEDIR . '/partner.wsdl.xml'); $mylogin = $mySforceConnection->login($row->salesforce_username, $row->salesforce_password . $row->salesforce_token); $row->salesforce_types = $mySforceConnection->describeGlobal()->sobjects; // retrieve fields from Lead by default $sobjects = array(); if ($row->salesforce_type == '') { $row->salesforce_type = 'Lead'; $sobjects = $mySforceConnection->describeSObject('Lead')->fields; } else { $sobjects = $mySforceConnection->describeSObject($row->salesforce_type)->fields; } $row->salesforce_type_fields = $sobjects; $row->salesforce_fields = explode(',', $row->salesforce_fields); $database->setQuery("Select `title`,`name` From #__facileforms_elements Where form = " . $ids[0] . " And `title` Not In ('bfFakeTitle','bfFakeTitle2','bfFakeTitle3','bfFakeTitle4','bfFakeTitle5') Order By ordering"); $row->breezingforms_fields = $database->loadObjectList(); } catch (Exception $e) { $row->salesforce_error = $e->getMessage(); } } $lists = array(); $database->setQuery("select id, concat(package,'::',name) as text " . "from #__facileforms_scripts " . "where published=1 and type='Form Init' " . "order by text, id desc"); $lists['init'] = $database->loadObjectList(); $database->setQuery("select id, concat(package,'::',name) as text " . "from #__facileforms_scripts " . "where published=1 and type='Form Submitted' " . "order by text, id desc"); $lists['submitted'] = $database->loadObjectList(); $database->setQuery("select id, concat(package,'::',name) as text " . "from #__facileforms_pieces " . "where published=1 and type='Before Form' " . "order by text, id desc"); $lists['piece1'] = $database->loadObjectList(); $database->setQuery("select id, concat(package,'::',name) as text " . "from #__facileforms_pieces " . "where published=1 and type='After Form' " . "order by text, id desc"); $lists['piece2'] = $database->loadObjectList(); $database->setQuery("select id, concat(package,'::',name) as text " . "from #__facileforms_pieces " . "where published=1 and type='Begin Submit' " . "order by text, id desc"); $lists['piece3'] = $database->loadObjectList(); $database->setQuery("select id, concat(package,'::',name) as text " . "from #__facileforms_pieces " . "where published=1 and type='End Submit' " . "order by text, id desc"); $lists['piece4'] = $database->loadObjectList(); $order = JHTML::_('list.genericordering', "select ordering as value, title as text " . "from #__facileforms_forms " . "where package = " . $database->quote($pkg) . " " . "order by ordering"); $lists['ordering'] = JHTML::_('select.genericlist', $order, 'ordering', 'class="inputbox" size="1"', 'value', 'text', intval($row->ordering)); HTML_facileFormsForm::edit($option, $tabpane, $pkg, $row, $lists, $caller); }