涉及到string_trans字段的js代码如下 function setFilterAndRender() { var restriction = new Ab.view.Restriction(); var sqlRest = ''; var console = View.panels.get('abLocalizationEditLangFiles_consolePanel');
var language = $('language').value; if (language != '') { restriction.addClause('lang_files.language', language + '%', 'LIKE'); sqlRest += "lang_files.language LIKE '" + language + "%' AND "; }
var fileTypeObj = $('filetype'); var fileType= fileTypeObj.options[fileTypeObj.selectedIndex].value; if (fileType != '') { if (fileType == '%.js'){ restriction.addClause('lang_files.constant', '%||%', 'LIKE'); sqlRest += "lang_files.constant LIKE ''" + '%||% ' + "' AND "; } restriction.addClause('lang_files.filename', fileType, 'LIKE'); sqlRest += "lang_files.filename LIKE '" + fileType + "' AND "; }
var report = View.panels.get('abLocalizationEditLangFiles_detailsPanel'); if ($('abLocalizationEditLangFiles.longStrings').checked){ sqlRest += 'length(lang_files.string_trans) > 2000'; report.refresh(sqlRest); } else { report.refresh(restriction); } report.show(true); }
<title translatable="true">File Strings - Translate</title>
<action id="abLocalizationEditLangFiles_save">
<title translatable="true">Save</title>
<command type="saveForm"/>
<command type="showPanel" panelId="abLocalizationEditLangFiles_detailsPanel" applyParentRestriction="false"/>
<command type="closeDialog"/>
</action>
<!-- action id="abLocalizationEditLangFiles_delete">
<title translatable="true">Delete</title>
<command type="deleteRecord"/>
<command type="showPanel" panelId="abLocalizationEditLangFiles_popupPanel" show="false"/>
<command type="showPanel" panelId="abLocalizationEditLangFiles_detailsPanel" applyParentRestriction="false"/>
</action -->
<action id="delete">
<title translatable="true">Delete</title>
<command type="deleteRecord"/>
<command type="showPanel" panelId="abLocalizationEditLangFiles_detailsPanel" applyParentRestriction="false"/>
<command type="closeDialog"/>
</action>
<action id="abLocalizationEditLangFiles_cancel">
<title translatable="true">Cancel</title>
<command type="closeDialog"/>
</action>
<field name="string_english" table="lang_files"/>
<field name="string_trans" table="lang_files" style="height:100; width:400;"/>
<field name="constant" table="lang_files"/>
<field name="filename" table="lang_files" readOnly="true"/>
<field name="language" table="lang_files"/>
<field name="transfer_status" table="lang_files"/>
<field name="date_last_updated" table="lang_files"/>
<field name="reference_info" table="lang_files" readOnly="false" style="height:20px; width:400px;"/>
</panel>
var restriction = new Ab.view.Restriction();
var sqlRest = '';
var console = View.panels.get('abLocalizationEditLangFiles_consolePanel');
var language = $('language').value;
if (language != '') {
restriction.addClause('lang_files.language', language + '%', 'LIKE');
sqlRest += "lang_files.language LIKE '" + language + "%' AND ";
}
var fileTypeObj = $('filetype');
var fileType= fileTypeObj.options[fileTypeObj.selectedIndex].value;
if (fileType != '') { if (fileType == '%.js'){
restriction.addClause('lang_files.constant', '%||%', 'LIKE');
sqlRest += "lang_files.constant LIKE ''" + '%||% ' + "' AND ";
}
restriction.addClause('lang_files.filename', fileType, 'LIKE');
sqlRest += "lang_files.filename LIKE '" + fileType + "' AND ";
}
var report = View.panels.get('abLocalizationEditLangFiles_detailsPanel');
if ($('abLocalizationEditLangFiles.longStrings').checked){
sqlRest += 'length(lang_files.string_trans) > 2000';
report.refresh(sqlRest);
} else {
report.refresh(restriction);
} report.show(true);
}