public static function switchRank($id1, $id2) { $record1 = StructuredField::readRecord($id1); $record2 = StructuredField::readRecord($id2); $rank1 = $record1[2]; $rank2 = $record2[2]; $query = "UPDATE structured_field SET rank={$rank2} WHERE id={$id1};"; $result1 = mysql_query($query) or die(sqlError(__FILE__, __LINE__, $query)); $query = "UPDATE structured_field SET rank={$rank1} WHERE id={$id2};"; $result2 = mysql_query($query) or die(sqlError(__FILE__, __LINE__, $query)); }
if ($type) { switch ($type) { case 'createRecord': $rank = StructuredField::createRecord($id, $name, $rank); $result = "Record for unit with id {$id} at rank={$rank} with name={$name} has been created"; break; case 'updateRecord': $rank = StructuredField::updateRecord($id, $name, $rank); $result = "Record {$id} has been updated with rank={$rank}, and name={$name}"; break; case 'moveRankUp': StructuredField::moveRankUp($id, $rank); $result = "rank #{$rank} has been freed"; break; case 'readRecord': $record = StructuredField::readRecord($id); if ($record) { $result = implode(",", $record); } else { $result = "no record found"; } break; case 'getSortedRecords': $recordArray = StructuredField::getSortedRecords($id); if (!$recordArray) { $result = "no record for the unit with id={$id}"; } else { foreach ($recordArray as $record) { $recordFields[] = implode(",", $record); } $result = implode("<br/>", $recordFields);
} // rename/lock/unlock record if ($save) { $recordName = $_POST['recordName']; $selectedRecord = StructuredField::readRecord($init); if ($isAdmin) { $lockVal = $_POST['lock']; } else { $lockVal = $selectedRecord[4]; } StructuredField::updateRecord($selectedRecord[0], $recordName, $selectedRecord[2], $lockVal); $records = StructuredField::getSortedRecords($id, $isAdmin); } //get default values for the textareas (either from the selecting record, or from the first record) if ($init) { $selectedRecord = StructuredField::readRecord($init); } else { $selectedRecord = $records[0]; $init = $selectedRecord[0]; } if ($init) { $textArray = StructuredFieldValue::getValues($init); $assetArray = StructuredFieldAsset::getAssets($init); $selectedRecordName = displayValue($selectedRecord[3]); // don't show locked record for non-admin users or there is no record name in the URL $lock = $selectedRecord[4]; if (empty($name) || $lock == 1 && !$isAdmin) { header('location:index.php'); } } ?>