function getPlanState($workflowID, $formName) { $table = 'workflowState'; $where = 'workflowid=' . $workflowID; $field = 'state'; $workflowPlan = dbs::selrecord($field, $table, $where, false, 2); return unserialize(stripslashes($workflowPlan[0])); }
function addArchiveWorkflowUnit($workflowID) { $table = 'workflowArchive'; $archiveValues = array(); $archiveValues['workflowid'] = $workflowID; $archiveValues['timestamp'] = dbs::selattribute('timestamp', 'workflow', 'workflowId=' . $workflowID); $archiveValues['plan'] = addslashes(serialize(graphPlanDatabaseAccess::getPlanGraphList($workflowID))); //$planValues['state'] = addslashes(serialize($plans)); dbs::irrecord($table, $archiveValues, false); }
function updateDatabases($xmlPackage, $workflowId, $formData, $goal) { global $db; $db = connect($xmlPackage->getDb()); debug::message("connect to db:" . $xmlPackage->getDb() . '<br>'); $newDataItem = new coreWorkflowDataPacket($workflowId, array()); $tables = $xmlPackage->getTables(); if (sizeof($tables) > 0) { //For each table for ($tableIndex = 0; $tableIndex < sizeof($tables); $tableIndex++) { $table = $tables[$tableIndex]->getTableName(); $valsArray['workflowId'] = $workflowId; $fields = $tables[$tableIndex]->getDbFields(); //The fields specificed for ($index = 0; $index < sizeof($fields); $index++) { $field = $fields[$index]; $valsArray[$field] = addslashes($formData[$field]); } //Does this workflow item already exist in the table $sql_query = "workflowId='{$workflowId}'"; if (dbpear::numRecords($table, "{$sql_query}")) { $keyName = dbs::getprimarykey($table); $keyValue = dbpear::selAttribute($keyName, $table, $sql_query); dbs::updaterecord($table, $valsArray, $keyName, $keyValue); } else { dbs::irrecord($table, $valsArray, false); } $db = connect('iWFMS'); } $xmlParser = new XMLtoArray("jobSpecification.xml"); $xmlTree = $xmlParser->process(); //Package the xml data $xmlPackage = xmlPackage::package($xmlTree); if (!$goal) { //We are not at the goal node //Display the data as HTML xmlPackage::displayItem($xmlPackage, $workflowId, 'workflow', 'Current workflow item'); } else { //We are at the goal node xmlPackage::displayArchiveItem($xmlPackage, $workflowId, 'workflowArchive', 'Current archived workflow item', 'archive'); } } else { $xmlParser = new XMLtoArray("jobSpecification.xml"); $xmlTree = $xmlParser->process(); //Package the xml data $xmlPackage = xmlPackage::package($xmlTree); //Display the data as HTML xmlPackage::displayItem($xmlPackage, $workflowId, 'workflow', 'Current workflow item'); } }
function getallmembers($groupid) { $field = 'members'; $resultsarray = array(); if (is_array($groupid)) { foreach ($groupid as $group) { $result = dbs::selrecord($field, 'groups', 'groupid=' . $group, '0', '1'); $memberlist = arrays::array_explode($result[$field], ','); if ($memberslist) { array_merge($resultsarray, $memberlist); } } } else { $result = dbs::selrecord($field, 'groups', 'groupid=' . $groupid, '0', '1'); $resultsarray = arrays::array_explode($result[$field], ','); } return $resultsarray; }
/** * @return Boolean * @param String $mode * @param String $username * @param String $password * @desc Checks the users password and if valid adds their username to the session */ function authenticateLogin($mode, $username, $password) { if ($mode == 'login') { // encode password to check against what's stored in the db //$password = dbs::passencdec($password,$salt,'1'); // query database to authenticate user - check username / password combo $result = dbs::selrecord('*', 'users', "username = '******' and password = '******'", '0', '1'); // check if an entry exists in the db if (sizeof($result)) { // password/username authenticated - register the user session $_SESSION['valid_user'] = $result[0]['username']; $_SESSION['authentic_user'] = true; return true; } else { return false; } } else { return false; } }
function dbmanagement_simple($table, $key, &$keyvalue, &$mode, $process, $vals) { global $sql_debug; if ($process == 'delete') { // Delete the record from table dbs::delrecord($table, $key, $keyvalue); $mesg = DELETED; $mode = 'preview'; } elseif ($process == 'add' || $process == 'edit') { // generate table column field names $cols = dbs::genfieldnames($table, '0'); if (!empty($keyvalue)) { /* this is an existing record adjust the columns and values parts of the replace sql statement */ $cols = "`" . $key . "`, " . $cols; $vals = "'" . $keyvalue . "', " . $vals; $request = "REPLACE"; } else { // this is a new record so set the insert sql statement $request = "INSERT"; } // run the sql for the live database echo $cols; echo $vals; dbs::irrecord($request, $table, $cols, $vals); $mesg = SAVED; // get the primary key for the previously inserted record if (empty($keyvalue)) { $row = dbs::getlast(); $keyvalue = $row[0]; } // set return mode $mode = "edit"; } return $mesg; }
$result = dbs::selrecord('*', $table, $sql, 'name ASC LIMIT ' . $start . ',' . $end, '0'); $final = dbs::numrecords($result); } else { $check = dbs::selrecord('*', $table, '0', '0', '0'); $count = dbs::numrecords($check); $result = dbs::selrecord('*', $table, '0', 'name ASC LIMIT ' . $start . ',' . $end, '0'); $final = dbs::numrecords($result); } if ($count > 0) { hr(2); ?> <tr> <td class="bodybold">GROUPNAME</td><td class="bodybold" align="right">ACTIONS</td> </tr> <?php while ($row = dbs::fetchrecord($result)) { hr(2); ?> <tr> <td valign="top" class="bodybold" title="ID: <?php echo $row[$key]; ?> "><?php echo $row[$identifier]; ?> </td> <td align="right" valign="top" class="body"><span class="edit"><a class="whitelink" href="<?php echo $pageref; ?> ?<?php echo $key;
function saveCachePlans($planGraphList, $workflowKey, $modelId) { $planValuesCollection = array(); $planWorkflowValuesCollection = array(); $planValues = array(); $planWorkflowValues = array(); for ($index = 0; $index < sizeof($planGraphList); $index++) { $plan = addslashes(serialize($planGraphList[$index])); $planValues['modelId'] = $modelId; $planValues['plan'] = $plan; array_push($planValuesCollection, $planValues); //dbs::irrecord('workflowcachingstore',$planValues, false); $planWorkflowValues['workflowid'] = $workflowKey; $planWorkflowValues['plan'] = $plan; array_push($planWorkflowValuesCollection, $planWorkflowValues); //dbs::irrecord('plans',$planWorkflowValues, false); } dbs::irrecordArray('plans', $planWorkflowValuesCollection, false); dbs::irrecordArray('workflowcachingstore', $planValuesCollection, false); }
<?php if (${$key} != 'new') { // it's an existing record so pull the details from the db $row = dbs::selrecord('*', $table, $key . '=' . ${$key}, '0', '1'); //print_r($row); } ?> <table border="0" cellspacing="1" cellpadding="1" width="100%"> <tr> <td class="bodybold" colspan="2"><a href="<?php echo $pageref; ?> ">Groups</a> <?php if (${$key} != 'new') { // this is not a new record echo " ~ " . string::up($row[$identifier]); } ?> </td> </tr> <?php hr(2); if (isset($mesg)) { html_displaymesg($mesg, 2); } ?>
function displayWorkflow($workflowID) { $data['text1'] = dbs::selrecord('text1', 'text1', 'workflowid=' . $workflowID, 0, 3); $data['text2'] = dbs::selrecord('text2', 'text2', 'workflowid=' . $workflowID, 0, 3); html_display($data, $workflowID); }
function displayArchiveItem($xmlPackage, $workflowId, $table, $title, $mode) { global $db; $workflowIDs = array($workflowId); $workflowTimestamp = dbs::selrecord('timestamp', $table, 'workflowId=' . $workflowId, 0, 3); $db = connect($xmlPackage->getDb()); debug::message("connect to db:" . $xmlPackage->getDb()); workflowDisplayHTML::archiveTableHead($xmlPackage->getDisplayFields(), "", $title); xmlPackage::__testDatabaseFields($workflowIDs, $workflowTimestamp, $xmlPackage, $mode); //workflowDisplayHTML::tableMainOpen(); workflowDisplayHTML::tableMainClose(); $db = connect('iWFMS'); }
<?php include '../includes/config/database.php'; include_once '../includes/library/library_db_mysql.php'; include_once '../includes/library/library_arrays.php'; $table = 'text1'; $field = 'text1'; $key = 'text1id'; $updatearray['workflowId'] = 1; $updatearray[$field] = ${$field}; dbs::irrecord($table, $updatearray, false); dbs::updaterecord($table, $updatearray, $key, $keyvalue); header("Location: ../mockup/index.php");
/** * @return String * @param String $table * @desc return the primary key of table */ function getprimarykey($table) { $result = dbs::selrecord('*', $table, '0', '0', '0'); $i = 0; while ($i < mysql_num_fields($result)) { $meta = mysql_fetch_field($result); if (!$meta) { errors::errorMessage("No information available<br />\n"); mysql_free_result($result); return false; } //multiple_key: $meta->multiple_key //primary_key: $meta->primary_key //unique_key: $meta->unique_key if (!$meta->multiple_key && $meta->primary_key) { $primkey = $meta->name; mysql_free_result($result); return $primkey; } elseif ($meta->multiple_key) { errors::errorMessage('Support for multiple keys is not setup'); } $i++; } }
/** * @return unknown * @param unknown $name * @param unknown $dbfield * @param unknown $current * @param unknown $datasource * @param unknown $populate * @param unknown $where * @param unknown $orderby * @desc get the data for multiple radio buttons */ function getdata_radiobtns($name, $dbfield, $current, $datasource, $populate, $where, $orderby) { if (!is_array($datasource)) { // populate values from a database table //$datasource = table //$populate = display $default = true; // first item assumed default $index = 0; $radios = dbs::selrecord($dbfield . ',' . $populate, $datasource, $where, $orderby, '0'); while ($radio = dbs::fetchrecord($radios)) { $result[$index]['radiobtn'] = formdata::getdata_radiobtn($name, $current, $radio[$dbfield], $radio[$populate], $default); $default = false; $index++; } } else { // populate values from an array if (sizeof($datasource) != 0) { $default = true; // first item assumed default $index = 0; foreach ($datasource as $populateitem) { $result[$index]['radiobtn'] = formdata::getdata_radiobtn($name, $current, $populateitem, $populate[$index], $default); $default = false; $index++; } } else { $result = false; } } return $result; }
function testDatabaseInsertDelete() { $this->assertFalse(dbs::irrecord('', array(), false)); $this->assertFalse(dbs::irrecord('table', array(), false)); }
$root = "../"; $pageref = "admin_groups.php"; $sql_debug = true; include_once '../includes/commonPages/system_header.php'; // Database setup variables $table = "groups"; $key = "groupid"; $identifier = "name"; $mesg = ''; if ($process) { switch ($process) { case 'delete': dbs::delrecord($table, $key, ${$key}); $mesg = 'Deleted!'; break; case 'add': $vals['name'] = $name; $vals['members'] = $groupmembers; dbs::irrecord($table, $vals, false); $mesg = 'Added!'; break; } } if (!isset($mode) || $mode == 'preview') { // show preview page include_once 'preview/' . str_replace('.php', '', $pageref) . '_preview.php'; } elseif ($mode == 'add' || $mode == 'edit') { // show edit page include_once 'edit/' . str_replace('.php', '', $pageref) . '_edit.php'; } include_once '../includes/commonPages/system_footer.php';