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);
}
