$value) {
$$key = trim(stripslashes($value));
}
require_once CROOT."/midware/Webstring.class.php";
require_once CROOT."/midware/Tools.php";
$GLOBALS['helptexts']['source_help1'] = t("Put here any details that clarify your source: title, page number, url, circumstances of your observation, etc.",2);
$GLOBALS['helptexts']['source_help2'] = t("Put here anything special that is needed to alert others editing this object.",2);
// add new company, if...
if (isset($getnewobject)){
include CROOT."/midware/Company.class.php";
$newobject = new Company();
$id = $newobject->create();
$headstr = t('Adding');
} else {
$headstr = t('Editing');
}
// this we need here :-(
$object_source_textfield_default_value = $GLOBALS['helptexts']['source_help1'];
$object_comments_default_value = $GLOBALS['helptexts']['source_help2'];
$source_types = getSource($_SESSION['account_language']);
// get user's long language
$query = sprintf("SELECT coalesce(name_%s, name_en) FROM language WHERE NOT deleted AND isocode = '%s'",
$_SESSION['account_language'], $_SESSION['account_language']);
$user_language = queryOne($query);
// get SORTED category "source"
function getSource($lng){
$query = sprintf("SELECT categoryid, coalesce(name_%s, name_en) AS desc, final,
CASE WHEN NOT (split_part(categoryid, '.', 3) = '') THEN CAST(split_part(categoryid, '.', 3) AS int) ELSE NULL END AS of2
FROM category
WHERE NOT deleted
AND categoryid LIKE 'source.%%'
ORDER BY
split_part(categoryid, '.', 2), of2 NULLS FIRST",
$lng);
// echo $query;
$rows = query($query);
$return = "";
foreach ($rows as $row) {
if (!$row['final']){
$return .= sprintf('', $row['desc']);
} elseif (empty($row['of2'])){
$return .= sprintf('', $row['desc']);
$return .= sprintf('', $row['categoryid'], $disabled, $row['desc']);
} else {
$return .= sprintf('', $row['categoryid'], $disabled, $row['desc']);
}
}
return $return;
}
?>
