KenSchae
/
openemr
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
6 Commits
1 Branch
0 Tags
6.0 GiB
 
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
openemr/interface/language/lang_definition.php

321 lines
14 KiB
Raw Permalink Blame History

<?php
/**
* lang_definition.php
*
* @package OpenEMR
* @link http://www.open-emr.org
* @author bradymiller <bradymiller>
* @author sunsetsystems <sunsetsystems>
* @author andres_paglayan <andres_paglayan>
* @author Wakie87 <scott@npclinics.com.au>
* @author Robert Down <robertdown@live.com>
* @copyright Copyright (c) 2010-2018 bradymiller <bradymiller>
* @copyright Copyright (c) 2008-2009, 2022 sunsetsystems <sunsetsystems>
* @copyright Copyright (c) 2005 andres_paglayan <andres_paglayan>
* @copyright Copyright (c) 2016 Wakie87 <scott@npclinics.com.au>
* @copyright Copyright (c) 2017-2022 Robert Down <robertdown@live.com>
* @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
*/
use OpenEMR\Common\Acl\AclMain;
use OpenEMR\Common\Csrf\CsrfUtils;
// Ensure this script is not called separately
if ($langModuleFlag !== true) {
die(function_exists('xlt') ? xlt('Authentication Error') : 'Authentication Error');
}
// gacl control
$thisauth = AclMain::aclCheckCore('admin', 'language');
if (!$thisauth) {
echo "<html>\n<body>\n";
echo "<p>" . xlt('You are not authorized for this.') . "</p>\n";
echo "</body>\n</html>\n";
exit();
}
?>
<form name='filterform' id='filterform' method='post'
action='?m=definition&csrf_token_form=<?php echo attr_url(CsrfUtils::collectCsrfToken()); ?>'
onsubmit="return top.restoreSession()">
<input type="hidden" name="csrf_token_form" value="<?php echo attr(CsrfUtils::collectCsrfToken()); ?>" />
<!-- Filter for Constants -->
<div class="form-group">
<label for="filterForConstants"><?php echo xlt('Filter for Constants'); ?>:</label>
<input type='text' class="form-control" id="filterForConstants" name='filter_cons'
size='8' value='<?php echo attr($_POST['filter_cons'] ?? ''); ?>' />
<small class="form-text text-muted">
<?php echo xlt('(% matches any string, _ matches any character)'); ?>
</small>
</div>
<!-- Filter for Definitions -->
<div class="form-group">
<label for="filterForDefinitions"><?php echo xlt('Filter for Definitions'); ?>:</label>
<input type='text' class="form-control" id="filterForDefinitions" name='filter_def'
size='8' value='<?php echo attr($_POST['filter_def'] ?? ''); ?>' />
<small class="form-text text-muted">
<?php echo xlt('(% matches any string, _ matches any character)'); ?>
</small>
</div>
<!-- Select Language -->
<div class="form-group">
<label for="selectLanguage"><?php echo xlt('Select Language') . ":"; ?></label>
<select class="form-control" name='language_select' id="selectLanguage">
<?php
// sorting order of language titles depends on language translation options.
$mainLangID = empty($_SESSION['language_choice']) ? '1' : $_SESSION['language_choice'];
// Use and sort by the translated language name.
$sql = "SELECT ll.lang_id, " .
"IF(LENGTH(ld.definition),ld.definition,ll.lang_description) AS lang_description " .
"FROM lang_languages AS ll " .
"LEFT JOIN lang_constants AS lc ON lc.constant_name = ll.lang_description " .
"LEFT JOIN lang_definitions AS ld ON ld.cons_id = lc.cons_id AND " .
"ld.lang_id=? " .
"ORDER BY IF(LENGTH(ld.definition),ld.definition,ll.lang_description), ll.lang_id";
$res = SqlStatement($sql, array($mainLangID));
// collect the default selected language id, and then display list
$tempLangID = isset($_POST['language_select']) ? $_POST['language_select'] : $mainLangID;
while ($row = SqlFetchArray($res)) {
if ($tempLangID == $row['lang_id']) {
echo "<option value='" . attr($row['lang_id']) . "' selected>" .
text($row['lang_description']) . "</option>";
} else {
echo "<option value='" . attr($row['lang_id']) . "'>" .
text($row['lang_description']) . "</option>";
}
}
?>
</select>
</div>
<!-- Submit Button -->
<div class="form-group">
<input type="submit" class="btn btn-primary" name="edit" value="<?php echo xla('Search'); ?>">
</div>
</form>
<br />
<?php
// set up the mysql collation string to ensure case is sensitive (or insensitive) in the mysql queries
if (!$disable_utf8_flag) {
if (!empty($sqlconf["db_encoding"]) && ($sqlconf["db_encoding"] == "utf8mb4")) {
$case_sensitive_collation = "COLLATE utf8mb4_bin";
$case_insensitive_collation = "COLLATE utf8mb4_general_ci";
} else {
$case_sensitive_collation = "COLLATE utf8_bin";
$case_insensitive_collation = "COLLATE utf8_general_ci";
}
} else {
$case_sensitive_collation = "COLLATE latin1_bin";
$case_insensitive_collation = "COLLATE latin1_swedish_ci";
}
if (!empty($_POST['load'])) {
if (!CsrfUtils::verifyCsrfToken($_POST["csrf_token_form"])) {
CsrfUtils::csrfNotVerified();
}
// query for entering new definitions it picks the cons_id because is existant.
if (!empty($_POST['cons_id'])) {
foreach ($_POST['cons_id'] as $key => $value) {
$value = trim($value);
// do not create new blank definitions
if ($value == "") {
continue;
}
// insert into the main language tables
$sql = "INSERT INTO lang_definitions (`cons_id`,`lang_id`,`definition`) VALUES (?,?,?)";
SqlStatement($sql, array($key, $_POST['lang_id'], $value));
// insert each entry into the log table - to allow persistant customizations
$sql = "SELECT lang_description, lang_code FROM lang_languages WHERE lang_id=? LIMIT 1";
$res = SqlStatement($sql, array($_POST['lang_id']));
$row_l = SqlFetchArray($res);
$sql = "SELECT constant_name FROM lang_constants WHERE cons_id=? LIMIT 1";
$res = SqlStatement($sql, array($key));
$row_c = SqlFetchArray($res);
insert_language_log($row_l['lang_description'], $row_l['lang_code'], $row_c['constant_name'], $value);
$go = 'yes';
}
}
// query for updating preexistant definitions uses def_id because there is no def yet.
// echo ('<pre>'); print_r($_POST['def_id']); echo ('</pre>');
if (!empty($_POST['def_id'])) {
foreach ($_POST['def_id'] as $key => $value) {
$value = trim($value);
// only continue if the definition is new
$sql = "SELECT * FROM lang_definitions WHERE def_id=? AND definition=? " . $case_sensitive_collation;
$res_test = SqlStatement($sql, array($key, $value));
if (!SqlFetchArray($res_test)) {
// insert into the main language tables
$sql = "UPDATE `lang_definitions` SET `definition`=? WHERE `def_id`=? LIMIT 1";
SqlStatement($sql, array($value, $key));
// insert each entry into the log table - to allow persistant customizations
$sql = "SELECT ll.lang_description, ll.lang_code, lc.constant_name ";
$sql .= "FROM lang_definitions AS ld, lang_languages AS ll, lang_constants AS lc ";
$sql .= "WHERE ld.def_id=? ";
$sql .= "AND ll.lang_id = ld.lang_id AND lc.cons_id = ld.cons_id LIMIT 1";
$res = SqlStatement($sql, array($key));
$row = SqlFetchArray($res);
insert_language_log($row['lang_description'], $row['lang_code'], $row['constant_name'], $value);
$go = 'yes';
}
}
}
if ($go == 'yes') {
echo xlt("New Definition set added");
}
}
if (!empty($_POST['edit'])) {
if (!CsrfUtils::verifyCsrfToken($_POST["csrf_token_form"])) {
CsrfUtils::csrfNotVerified();
}
if ($_POST['language_select'] == '') {
exit(xlt("Please select a language"));
}
$lang_id = isset($_POST['language_select']) ? $_POST['language_select'] : '';
$lang_id = (int)$lang_id;
$lang_filter = isset($_POST['filter_cons']) ? $_POST['filter_cons'] : '';
$lang_filter .= '%';
$lang_filter_def = isset($_POST['filter_def']) ? $_POST['filter_def'] : '';
$lang_filter_def .= '%';
$bind_sql_array = array();
array_push($bind_sql_array, $lang_filter);
$sql = "SELECT lc.cons_id, lc.constant_name, ld.def_id, ld.definition, ld.lang_id " .
"FROM lang_definitions AS ld " .
"RIGHT JOIN ( lang_constants AS lc, lang_languages AS ll ) ON " .
"( lc.cons_id = ld.cons_id AND ll.lang_id = ld.lang_id ) " .
"WHERE lc.constant_name " . $case_insensitive_collation . " LIKE ? AND ( ll.lang_id = 1 ";
if ($lang_id != 1) {
array_push($bind_sql_array, $lang_id);
$sql .= "OR ll.lang_id=? ";
$what = "SELECT * from lang_languages where lang_id=? LIMIT 1";
$res = SqlStatement($what, array($lang_id));
$row = SqlFetchArray($res);
$lang_name = $row['lang_description'];
}
// Sort same case together and English/null before other languages.
$sql .= ") ORDER BY lc.constant_name, BINARY lc.constant_name, ld.lang_id " . $case_insensitive_collation;
$res = SqlStatement($sql, $bind_sql_array);
$isResults = false; //flag to record whether there are any results
echo ('<table><form method="post" action="?m=definition&csrf_token_form='
. attr_url(CsrfUtils::collectCsrfToken()) . '" onsubmit="return top.restoreSession()">');
echo ('<input type="hidden" name="csrf_token_form" value="' . attr(CsrfUtils::collectCsrfToken()) . '" />');
// only english definitions
if ($lang_id == 1) {
while ($row = SqlFetchArray($res)) {
$isShow = false; //flag if passes the definition filter
$stringTemp = '<tr><td>' . text($row['constant_name']) . '</td>';
// if there is no definition
if (empty($row['def_id'])) {
$cons_name = "cons_id[" . $row['cons_id'] . "]";
if ($lang_filter_def == '%') {
$isShow = true;
}
// if there is a previous definition
} else {
$cons_name = "def_id[" . $row['def_id'] . "]";
$sql = "SELECT definition FROM lang_definitions WHERE def_id=? AND definition LIKE ?";
$res2 = SqlStatement($sql, array($row['def_id'], $lang_filter_def));
if (SqlFetchArray($res2)) {
$isShow = true;
}
}
$stringTemp .= '<td><input type="text" size="50" NAME="' . attr($cons_name) .
'" value="' . attr($row['definition']) . '">';
$stringTemp .= '</td><td></td></tr>';
if ($isShow) {
//definition filter passed, so show
echo $stringTemp;
$isResults = true;
}
}
echo ('<input type="hidden" name="lang_id" value="' . attr($lang_id) . '">');
// english plus the other
} else {
while ($row = SqlFetchArray($res)) {
if (!empty($row['lang_id']) && $row['lang_id'] != '1') {
// This should not happen, if it does that must mean that this
// constant has more than one definition for the same language!
continue;
}
$isShow = false; //flag if passes the definition filter
$stringTemp = '<tr><td>' . text($row['constant_name']) . '</td>';
if ($row['definition'] == '' or $row['definition'] == 'NULL') {
$def = " " ;
} else {
$def = $row['definition'];
}
$stringTemp .= '<td>' . text($def) . '</td>';
$row = SqlFetchArray($res); // jump one to get the second language selected
if ($row['def_id'] == '' or $row['def_id'] == 'NULL') {
$cons_name = "cons_id[" . $row['cons_id'] . "]";
if ($lang_filter_def == '%') {
$isShow = true;
}
// if there is a previous definition
} else {
$cons_name = "def_id[" . $row['def_id'] . "]";
;
$sql = "SELECT definition FROM lang_definitions WHERE def_id=? AND definition LIKE ?";
$res2 = SqlStatement($sql, array($row['def_id'], $lang_filter_def));
if (SqlFetchArray($res2)) {
$isShow = true;
}
}
$stringTemp .= '<td><input type="text" size="50" name="' . attr($cons_name) . '" value="' .
attr($row['definition']) . '">';
$stringTemp .= '</td></tr>';
if ($isShow) {
//definition filter passed, so show
echo $stringTemp;
$isResults = true;
}
}
echo ('<input type="hidden" name="lang_id" value="' . attr($lang_id) . '">');
}
if ($isResults) {
echo ('<tr><td colspan=3><input type="submit" name="load" Value="' .
xla('Load Definitions') . '"></td></tr>');
?>
<input type="hidden" name="filter_cons" value="<?php echo attr($_POST['filter_cons']); ?>">
<input type="hidden" name="filter_def" value="<?php echo attr($_POST['filter_def']); ?>">
<input type="hidden" name="language_select" value="<?php echo attr($_POST['language_select']); ?>">
<?php
} else {
echo xlt('No Results Found For Search');
}
echo ('</form></table>');
}
?>
<?php echo activate_lang_tab('definition-link'); ?>