/** * get database connection list */ public function getDbConnectionsList() { if (!isset($_SESSION['PROCESS'])) { $_SESSION['PROCESS'] = $_POST['PRO_UID']; } G::LoadClass('dbConnections'); $proUid = $_POST['PRO_UID']; $dbConn = new DbConnections(); $dbConnections = $dbConn->getConnectionsProUid($proUid); $defaultConnections = array(array('DBS_UID' => 'workflow', 'DBS_NAME' => 'Workflow'), array('DBS_UID' => 'rp', 'DBS_NAME' => 'REPORT')); $dbConnections = array_merge($defaultConnections, $dbConnections); return $dbConnections; }
$Fields['PME_A'] = $_GET['A']; $Fields['PME_PRO_UID'] = $proUid; $Fields['PME_XMLNODE_NAME_OLD'] = isset($Fields['PME_XMLNODE_NAME']) ? $Fields['PME_XMLNODE_NAME'] : ''; $G_PUBLISH = new Publisher(); if (!(isset($fields->Fields['XMLNODE_NAME']) && $fields->Fields['XMLNODE_NAME'] !== '')) { $type = strtolower($_GET['TYPE']); } else { $type = strtolower($fields->Fields['TYPE']); } if ($type == 'suggest' || $type == 'checkgroup' || $type == 'dropdown' || $type == 'radiogroup' || $type == 'text' || $type == 'listbox' || $type == 'currency' || $type == 'percentage' || $type == 'textarea' || $type == 'hidden') { $aDefaultConnections = array(); $aDBConn = array(); G::LoadClass('dbConnections'); $oDBConn = new DbConnections(); $aDefaultConnections = array(array('DBS_UID' => '', 'DBS_NAME' => ''), array('DBS_UID' => 'dbarray', 'DBS_NAME' => 'dbarray'), array('DBS_UID' => 'workflow', 'DBS_NAME' => 'Workflow'), array('DBS_UID' => 'rbac', 'DBS_NAME' => 'RBAC'), array('DBS_UID' => 'rp', 'DBS_NAME' => 'REPORT')); $aDBConn = $oDBConn->getConnectionsProUid($proUid); $aDbConnections = array_merge($aDefaultConnections, $aDBConn); $_DBArray['DB_CONNECTIONS'] = $aDbConnections; $_SESSION['_DBArray'] = $_DBArray; } if (!(isset($fields->Fields['XMLNODE_NAME']) && $fields->Fields['XMLNODE_NAME'] !== '')) { $type = strtolower($_GET['TYPE']); $Fields['PME_TYPE'] = $type; $G_PUBLISH->AddContent('xmlform', 'xmlform', 'dynaforms/fields/' . $type, '', $Fields, SYS_URI . 'dynaforms/fields_Save', SYS_URI . 'dynaforms/fields_Ajax'); } else { $Fields['PME_LABEL'] = $form->fields[$fields->Fields['XMLNODE_NAME']]->label; if (isset($form->fields[$fields->Fields['XMLNODE_NAME']]->code)) { $Fields['PME_CODE'] = $form->fields[$fields->Fields['XMLNODE_NAME']]->code; } $options = isset($form->fields[$fields->Fields['XMLNODE_NAME']]->option) ? $form->fields[$fields->Fields['XMLNODE_NAME']]->option : array(); if (!is_array($options) || count($options) == 0) {
/** * get database connection list */ public function getDbConnectionsList () { if (! isset( $_SESSION['PROCESS'] )) { $_SESSION['PROCESS'] = $_POST['PRO_UID']; } G::LoadClass( 'dbConnections' ); $proUid = $_POST['PRO_UID']; $dbConn = new DbConnections(); $dbConnections = $dbConn->getConnectionsProUid( $proUid, array('mysql') ); $workSpace = new workspaceTools(SYS_SYS); $workspaceDB = $workSpace->getDBInfo(); if ($workspaceDB['DB_NAME'] == $workspaceDB['DB_RBAC_NAME']) { $defaultConnections = array (array ('DBS_UID' => 'workflow','DBS_NAME' => 'Workflow')); } else { $defaultConnections = array (array ('DBS_UID' => 'workflow','DBS_NAME' => 'Workflow'), array ('DBS_UID' => 'rp','DBS_NAME' => 'REPORT')); } $dbConnections = array_merge( $defaultConnections, $dbConnections ); return $dbConnections; }
$aVars = $oReportTables->getTableVars($_POST['REP_TAB_UID']); $aFields['FIELDS'] = array(); foreach ($aTheFields as $aField) { if (in_array($aField['sName'], $aVars)) { $aResultFields[] = array('FIELD_UID' => $aField['sName'] . '-' . $aField['sType'], 'FIELD_NAME' => $aField['sName'], 'FIELD_DYNAFORM' => $aField['sName']); } } $result->success = true; $result->data = $aResultFields; echo G::json_encode($result); break; case 'getDbConnectionsList': G::LoadClass('dbConnections'); $proUid = $_POST['PRO_UID']; $dbConn = new DbConnections(); $dbConnections = $dbConn->getConnectionsProUid($proUid); $defaultConnections = array(array('DBS_UID' => 'workflow', 'DBS_NAME' => 'Workflow'), array('DBS_UID' => 'rp', 'DBS_NAME' => 'REPORT')); echo G::json_encode(array_merge($defaultConnections, $dbConnections)); break; case 'getProcessList': require_once 'classes/model/Process.php'; $process = new Process(); echo G::json_encode($process->getAll()); break; case 'save': require_once 'classes/model/AdditionalTables.php'; require_once 'classes/model/Fields.php'; try { $data = $_POST; $data['columns'] = G::json_decode($_POST['columns']); //decofing data columns