public static function switchRank($id1, $id2) { $record1 = StructuredFieldValueLabel::read($id1); $record2 = StructuredFieldValueLabel::read($id2); $offset = sizeOf(StructuredFieldValueLabel::getStructure()) + 2; $rank1 = $record1[$offset]; $rank2 = $record2[$offset]; $query = "UPDATE structured_field_value_label SET rank={$rank2} WHERE id={$id1};"; $result1 = mysql_query($query) or die(sqlError(__FILE__, __LINE__, $query)); $query = "UPDATE structured_field_value_label SET rank={$rank1} WHERE id={$id2};"; $result2 = mysql_query($query) or die(sqlError(__FILE__, __LINE__, $query)); }
$moveRankDown = $_GET['movedown']; if ($moveRankDown) { // move value label down if (strcmp($type, 'value') == 0) { StructuredFieldValueLabel::switchRank($valueLabels[$moveRankUp][0], $valueLabels[$moveRankUp + 1][0]); $valueLabels = StructuredFieldValueLabel::getSorted($id); } else { StructuredFieldAssetLabel::switchRank($assetLabels[$moveRankUp][0], $assetLabels[$moveRankUp + 1][0]); $assetLabels = StructuredFieldAssetLabel::getSorted($id); } } //get default values for the textareas (either from the selecting record, or from the first record) if ($init) { // init with value label if (strcmp($type, 'value') == 0) { $selectedRecord = StructuredFieldValueLabel::read($init); $recordStructure = StructuredFieldValueLabel::getStructure(); } else { $selectedRecord = StructuredFieldAssetLabel::read($init); $recordStructure = StructuredFieldAssetLabel::getStructure(); } $selectedRecordName = displayValue($selectedRecord[2]); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>standupweb CMS - edit list: <?php echo $name; ?>
$id = $_POST["id"]; $id_switch = $_POST["id_switch"]; $values[] = $_POST["value1"]; $values[] = $_POST["value2"]; if ($type) { switch ($type) { case 'create': StructuredFieldValueLabel::create($id); $result = "structured field value label with name={$name} created"; break; case 'update': StructuredFieldValueLabel::update($id, $values); $result = "structured field value label with name={$name} updated"; break; case 'read': $value = StructuredFieldValueLabel::read($id); $result = "The value label with id={$id} is '" . implode(', ', $value) . "'"; break; case 'delete': StructuredFieldValueLabel::delete($id); $result = "structured field value label with id={$id} deleted"; break; case 'getsorted': $valueArray = StructuredFieldValueLabel::getSorted($id); if (!$valueArray) { $result = "no unit for the id={$id}"; } else { foreach ($valueArray as $v) { $vArray[] = implode(",", $v); } $result = "getSorted result:\n" . implode("<br/>", $vArray);