function __construct($host, $user, $pass, $database)
{
$this->host = $host;
$this->user = $user;
$this->pass = $pass;
$this->database = $database;
if (!DbConnections::$default) {
DbConnections::$default = $this;
}
}
/**
* 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;
}
/**
* 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;
}
}
}
$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;
}
$oReportTables = new ReportTables();
$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']);
