private function getFirstRuleOnQueryForm()
{
$html = '';
if (count($this->arrayAliasSetInQuery) && $this->numAffectedRows) {
$arFields = array();
$objMyForm = new OPF_myForm($idForm = $this->idList . 'QueryForm');
$objMyForm->cellPadding = 0;
$objMyForm->styleTypeHelp = 2;
$objMyForm->selectUseFirstValue = false;
++$this->numRuleQuery;
$html .= '<table border="0" id="rule_gp_' . $this->idList . '_' . $this->numRuleQuery . '" width="100%" cellpadding="0" cellspacing="0">';
$html .= '<tr>';
$html .= '<td width="10%" align="center"><div id="status_' . $this->idList . '_' . $this->numRuleQuery . '" class="rule_cancel" id=""></div></td>';
$objMyForm->addHelp('logic_' . $this->numRuleQuery, LABEL_LOGIC_FIELD_ADD_RULE_FORM);
$html .= '<td width="20%" align="center">' . $objMyForm->getHidden('logic_' . $this->numRuleQuery, 'AND') . '</td>';
foreach ($this->arrayFieldsOnQuery as $field) {
if (!isset($this->arrayEventOnColumn[$field]) && isset($this->arrayAliasSetInQuery[$field])) {
$etq = $field;
if (isset($this->arrayAliasSetInQuery[$field])) {
$data = $this->arrayAliasSetInQuery[$field];
} else {
$data = $field;
}
$arFields[$field] = $etq;
}
}
$objMyForm->addHelp('field_' . $this->numRuleQuery, LABEL_FIELD_LIST_ADD_RULE_FORM);
$html .= '<td width="20%" align="center">' . $objMyForm->getSelect('field_' . $this->numRuleQuery, $arFields) . '</td>';
$spaCha = ' ';
$objMyForm->addEvent('relation_' . $this->numRuleQuery, 'onchange', 'MYLIST_caseSensitiveCheckBox', 'case_sensitive_' . $this->numRuleQuery, 'relation_' . $this->numRuleQuery);
$objMyForm->addHelp('relation_' . $this->numRuleQuery, LABEL_RELATION_FIELD_ADD_RULE_FORM);
$html .= '<td width="20%" align="center">' . $objMyForm->getSelect('relation_' . $this->numRuleQuery, $this->myDinamicListRel) . '</td>';
$objMyForm->addHelp('value_' . $this->numRuleQuery, LABEL_FIELD_VALUE_ADD_RULE_FORM);
$objMyForm->addHelp('case_sensitive_' . $this->numRuleQuery, LABEL_CASE_SENSITIVE_LIST_ADD_RULE_FORM);
$html .= '<td width="20%" align="center"><table cellpadding="0" border="0" cellspacing="0"><tr><td>' . $objMyForm->getText('value_' . $this->numRuleQuery, NULL, 12) . '</td><td>' . $objMyForm->getCheckBox('case_sensitive_' . $this->numRuleQuery) . '</td></tr></table></td>';
$objMyForm->addHelp($this->idList . '_remove_rule_' . $this->numRuleQuery, LABEL_HELP_REM_RULE_FORM);
$objMyForm->addEvent($this->idList . '_remove_rule_' . $this->numRuleQuery, 'onclick', 'MYLIST_removeRuleQuery', $this->idList, $this->numRuleQuery);
$html .= '<td align="center">' . $objMyForm->getButton($this->idList . '_remove_rule_' . $this->numRuleQuery, NULL, 'remove.gif') . '</td>';
$html .= '</tr>';
$html .= '</table>';
}
return $html;
}
public static function formNewScaffStep1()
{
$myForm = new OPF_myForm('formNewScaffStep1');
$myForm->addComment('cm1:3', '');
$myForm->addComment('cm2:3', '');
$myForm->addComment('cm3:3', '');
$myForm->addComment('cm4:3', '');
$myForm->addComment('cm5:3', '');
$myForm->addComment('cm6:3', '');
$myForm->addComment('cm7:3', '');
$table = '';
if (isset($_SESSION['temp_scaff_info']['table_name'])) {
$table = $_SESSION['temp_scaff_info']['table_name'];
}
$myForm->addHelp('table_name', OPF_myLang::getPhrase('OPF_SCAFF_39'));
$myForm->addText(OPF_myLang::getPhrase('OPF_SCAFF_38'), 'table_name:3', $table);
$myForm->addComment('cm8:3', '');
$myForm->addComment('cm9:3', '');
$myForm->addComment('cm10:3', '');
$myForm->addComment('cm11:3', '');
$myForm->addComment('cm12:3', '');
$myForm->addComment('cm13:3', '');
$myForm->addComment('cm14:3', '');
$myForm->addComment('cm15', '');
$myForm->addComment('cm16', '');
$myForm->addButton('btn1', OPF_myLang::getPhrase('OPF_SCAFF_14'), 'next.gif');
$myForm->addEvent('btn1', 'onclick', 'toScaffStep2');
return $myForm->getForm(3);
}
/**
* Abre una ventana modal con un formulario que permite agregar una regla a la consulta actual de la lista dinamica.
* @ignore
* @param $datForm Datos de form
* @param $idList Id lista
* @return string
*/
public function MYLIST_addRuleQuery($datForm, $idList, $showFirstRule)
{
$objList = new OPF_myList($idList);
$arAlsInQry = $objList->getVar('arrayAliasSetInQuery');
if ($objList->getVar('numAffectedRows')) {
if (count($arAlsInQry)) {
$objMyForm = new OPF_myForm($idForm = $idList . 'QueryForm');
$objMyForm->cellPadding = 0;
$objMyForm->styleTypeHelp = 2;
$objMyForm->selectUseFirstValue = false;
$arFields = array();
$arFldOnQry = $objList->getVar('arrayFieldsOnQuery');
$arEvnOnClm = $objList->getVar('arrayEventOnColumn');
$objList->setVar('numRuleQuery', $numRuleQuery = $objList->getVar('numRuleQuery') + 1);
$html = '<table border="0" id="rule_gp_' . $idList . '_' . $numRuleQuery . '" width="100%" cellpadding="0" cellspacing="0">';
$html .= '<tr>';
$html .= '<td width="10%" align="center"><div id="status_' . $idList . '_' . $numRuleQuery . '" class="rule_cancel" id=""></div></td>';
$objMyForm->addHelp('logic_' . $numRuleQuery, LABEL_LOGIC_FIELD_ADD_RULE_FORM);
$html .= '<td width="20%" align="center">' . $objMyForm->getSelect('logic_' . $numRuleQuery, array('AND' => LABEL_RELATION_OPTAND_ADD_RULE_FORM, 'OR' => LABEL_RELATION_OPTOR_ADD_RULE_FORM)) . '</td>';
foreach ($arFldOnQry as $field) {
if (!isset($arEvnOnClm[$field]) && isset($arAlsInQry[$field])) {
$etq = $field;
if (isset($arAlsInQry[$field])) {
$data = $arAlsInQry[$field];
} else {
$data = $field;
}
$arFields[$field] = $etq;
}
}
$objMyForm->addHelp('field_' . $numRuleQuery, LABEL_FIELD_LIST_ADD_RULE_FORM);
$html .= '<td width="20%" align="center">' . $objMyForm->getSelect('field_' . $numRuleQuery, $arFields) . '</td>';
$spaCha = ' ';
$objMyForm->addEvent('relation_' . $numRuleQuery, 'onchange', 'MYLIST_caseSensitiveCheckBox', 'case_sensitive_' . $numRuleQuery, 'relation_' . $numRuleQuery);
$objMyForm->addHelp('relation_' . $numRuleQuery, LABEL_RELATION_FIELD_ADD_RULE_FORM);
$html .= '<td width="20%" align="center">' . $objMyForm->getSelect('relation_' . $numRuleQuery, $this->myDinamicListRel) . '</td>';
$objMyForm->addHelp('value_' . $numRuleQuery, LABEL_FIELD_VALUE_ADD_RULE_FORM);
$objMyForm->addHelp('case_sensitive_' . $numRuleQuery, LABEL_CASE_SENSITIVE_LIST_ADD_RULE_FORM);
$html .= '<td width="20%" align="center"><table cellpadding="0" border="0" cellspacing="0"><tr><td>' . $objMyForm->getText('value_' . $numRuleQuery, NULL, 12) . '</td><td>' . $objMyForm->getCheckBox('case_sensitive_' . $numRuleQuery) . '</td></tr></table></td>';
$objMyForm->addHelp($idList . '_remove_rule_' . $numRuleQuery, LABEL_HELP_REM_RULE_FORM);
$objMyForm->addEvent($idList . '_remove_rule_' . $numRuleQuery, 'onclick', 'MYLIST_removeRuleQuery', $idList, $numRuleQuery);
$html .= '<td align="center">' . $objMyForm->getButton($idList . '_remove_rule_' . $numRuleQuery, NULL, 'remove.gif') . '</td>';
$html .= '</tr>';
$html .= '</table>';
$this->append('rule_for_' . $idList, 'innerHTML', $html);
$chkPref = 'case_sensitive_';
$len = strlen($chkPref);
foreach ($datForm as $id => $value) {
if (!strcmp(substr($id, 0, $len), $chkPref)) {
if ($datForm[$id]) {
$this->assign($id, 'checked', true);
}
} else {
$this->assign($id, 'value', $value);
}
}
if (!$showFirstRule) {
$this->script("blockFirstElementForm('" . $idForm . "')");
}
} else {
$this->notificationWindow(MSG_FAILED_SHOW_FILTER_MUST_PROVIDE_REAL_NAME, 4, 'warning');
}
} else {
$this->notificationWindow(MSG_FAILED_SHOW_FILTER_NO_RECORDS_FOUND, 4, 'warning');
}
return $this->response;
}
