\n";
if ($EmptyItem) {
echo $EmptyItem;
} else {
echo "\n";
}
if ($result) {
for ($rec = 0; $rec < sizeof($result); $rec++) {
$ID = $result[$rec][$TABLE_KeyColumn];
$NAME = ($result[$rec][$TABLE_ValueColumn]);
$selected = ($DefaultKey == $ID) ? "selected" : "";
echo "\n";
}
}
echo "\n";
}
/*
* generic function - used to generate `select' on some table
* arguments:
* $tablename table name
* $IDFormFieldName name of select field
* $keyfieldname uniq field used to create option values
* $valuefieldname field used to create option names
* $defaultkey default (selected) key value
*/
/*
* generic function - used to generate `select' on some table
* arguments:
* $tablename table name
* $IDFormFieldName name of select field
* $keyfieldname uniq field used to create option values
* $valuefieldname field used to create option names
* $defaultkey default (selected) key value
* $orderbyID :)
* $show_keys :)
* $EmptyItem
* $viewkey
* $AdditionalPreOrderFieldName
* $onaction onaction (may be " onchange='OnSelectSomeItem()' ")
*/
function GenerateSelectList($tablename, $IDFormFieldName, $keyfieldname, $valuefieldname, $defaultkey, $orderbyID = 1, $show_keys = 0, $EmptyItem = "", $viewkey = "", $AdditionalPreOrderFieldName = "") {
global $DB;
if ($AdditionalPreOrderFieldName != "") {
$AdditionalPreOrderFieldName = "$AdditionalPreOrderFieldName, ";
}
if ($orderbyID) {
$SQL = "select distinct $keyfieldname, $valuefieldname";
if ($viewkey != "") {
$SQL .= ", $viewkey";
}
$SQL .= " from $tablename order by $AdditionalPreOrderFieldName $keyfieldname";
} else {
$SQL = "select distinct $keyfieldname, $valuefieldname";
if ($viewkey != "") {
$SQL .= ", $viewkey";
}
$SQL .= " from $tablename order by $AdditionalPreOrderFieldName $valuefieldname";
}
$result = GetArray($DB, $SQL);
echo "\n";
}
function GenerateSelectList2($tablename, $IDFormFieldName, $keyfieldname, $valuefieldname, $defaultkey, $orderbyID = 1, $show_keys = 0, $EmptyItem = "", $viewkey = "", $AdditionalPreOrderFieldName = "", $onaction = "") {
global $DB;
if ($AdditionalPreOrderFieldName != "") {
$AdditionalPreOrderFieldName = "$AdditionalPreOrderFieldName, ";
}
if ($orderbyID) {
$SQL = "select distinct $keyfieldname, $valuefieldname";
if ($viewkey != "") {
$SQL .= ", $viewkey";
}
$SQL .= " from $tablename order by $AdditionalPreOrderFieldName $keyfieldname";
} else {
$SQL = "select distinct $keyfieldname, $valuefieldname";
if ($viewkey != "") {
$SQL .= ", $viewkey";
}
$SQL .= " from $tablename order by $AdditionalPreOrderFieldName $valuefieldname";
}
$result = GetArray($DB, $SQL);
echo "\n";
}
/*
* * generic selector
* * args:
* * $selectorname - select name
* * $currentvalue - default value
* * $dataarray - values array
* * $nitems - values array size
* * $keys - keys array
* * $keysasindex - Keys array formed from index
* *
* * usage DrawSelector($sn,$cv,$da,$ni) - keys as dataarray
* * usage DrawSelector($sn,$cv,$da,$ni,$keys) - keys as $keys
* * usage DrawSelector($sn,$cv,$da,$ni,1,1) - keys formed from index
*/
function GenericSelector($selectorname, $currentvalue, $dataarray, $KeyEqValue = 0, $ExtraClass = "", $Quote = true, $KStyle = false) {
$selectorID = str_replace('[', '_', $selectorname);
$selectorID = str_replace(']', '', $selectorID);
echo "\n";
}
function DrawSelector($selectorname, $currentvalue, $dataarray, $nitems, $keys = 0, $keysasindex = 0, $ExtraClass = "") {
echo "\n";
}
function DrawSelector2($selectorname, $currentvalue, $dataarray, $nitems) {
echo "\n";
}
function DrawSelector3($selectorname, $currentvalue, $dataarray, $nitems, $keys = 0, $keysasindex = 0, $onaction = "", $use1stvalue = 0) {
echo "\n";
}
$GenericColorSelectorJavaScriptDone = 0;
function PrintGenericColorSelectorJavaScript() {
global $GenericColorSelectorJavaScriptDone;
if ($GenericColorSelectorJavaScriptDone) {
return;
}
$GenericColorSelectorJavaScriptDone = 1;
$DATA = <<
EOD;
// GenericColorSelector('Test', '', 0x40);
echo $DATA;
}
/*
* * generic color selector
*/
function ColorSelector($SelectorName, $DefaultValue = "", $Step = 0x80) {
PrintGenericColorSelectorJavaScript();
$DATA = <<
EOD;
echo $DATA;
}
/*
* * Generic Language selector
*/
function LanguageSelector($SelectorName = 'Lang', $DefaultValue = 'En') {
$Lang['En'] = 'English';
$Lang['Ru'] = 'Russian';
GenericSelector($SelectorName, $DefaultValue, $Lang);
}
/*
* * Table selector....
*/
function TableSelector($Form_SelectorName, $DefaultValue) {
global $DB;
$SQL = "show tables";
MakeSelectorList(
$SQL, $Form_SelectorName, $TABLE_KeyColumn = "Tables_in_${DB}", $TABLE_ValueColumn = "Tables_in_${DB}", $DefaultValue, $EmptyItem = "", $ExtraStyle = ""
);
}
// TableSelector($Form_SelectorName, $DefaultValue)
function TableColumnSelector($Form_SelectorName, $TableName, $DefaultValue) {
global $DB;
if ($TableName == "")
return;
$SQL = "describe $TableName";
MakeSelectorList(
$SQL, $Form_SelectorName, $TABLE_KeyColumn = "Field", $TABLE_ValueColumn = "Field", $DefaultValue, $EmptyItem = "", $ExtraStyle = ""
);
}
// TableColumnSelector($Form_SelectorName, $TableName, $DefaultValue)
?>