Page MenuHomeIn-Portal Phabricator
Files F1171390

sql_query.tpl
No OneTemporary
Actions

File Metadata

Created
Sun, Sep 28, 12:55 AM

sql_query.tpl
View Options

<inp2:m_include t="incs/header"/>
<inp2:m_RenderElement name="combined_header" prefix="adm" section="in-portal:service" title_preset="sql_query"/>
<!-- ToolBar -->
<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
<tbody>
<tr>
<td>
<script type="text/javascript">
a_toolbar = new ToolBar();
a_toolbar.AddButton(
new ToolBarButton(
'query_database',
'<inp2:m_phrase label="la_ToolTip_RunSQL" escape="1"/>',
function() {
submit_event('adm','OnSqlQuery');
}
)
);
a_toolbar.Render();
</script>
</td>
</tr>
</tbody>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="4" class="bordered">
<inp2:m_RenderElement name="subsection" title="la_prompt_sqlquery_header"/>
<tr class="<inp2:m_odd_even odd='table-color1' even='table-color2'/>">
<td colspan="3">
<inp2:m_inc param="tab_index" by="1"/>
<span class="hint"><img src="img/smicon7.gif" align="absmiddle" height="14" width="14">
<inp2:m_Phrase label="la_text_db_warning"/>
</span>
</td>
</tr>
<tr class="<inp2:m_odd_even odd='table-color1' even='table-color2'/>">
<inp2:m_inc param="tab_index" by="1"/>
<td valign="top" style="width:100px;">
<span class="text" ID="prompt_sql_query"><inp2:m_Phrase label="la_prompt_sqlquery"/>
</td>
<td valign="top" width="400" style="width:auto">
<style type="text/css">
.CodeMirror {
background-color: white;
}
</style>
<textarea name="sql" cols="100" rows="10"><inp2:m_Get var="sql"/></textarea>
<script src="<inp2:m_TemplatesBase/>/incs/code_mirror/lib/codemirror.js"></script>
<link rel="stylesheet" href="<inp2:m_TemplatesBase/>/incs/code_mirror/lib/codemirror.css">
<inp2:adm_IncludeCodeMirrorFilesByLanguage language="mysql" render_as="code_mirror_resource"/>
<script type="text/javascript">
var $editor = CodeMirror.fromTextArea(document.kernel_form.sql, {mode: "mysql", tabindex: <inp2:m_Get name="tab_index"/>, indentWithTabs: true, indentUnit: 4, lineWrapping: true, lineNumbers: true});
$editor.setSize(null, 155);
</script>
</td>
<td align="left" valign="top" style="width:250px">
<span class="text">
<inp2:m_if check="m_Get" var="query_status">
<inp2:m_Phrase label="la_SQLRuntime"/>:&nbsp;<inp2:m_Get var="sql_time"/> sec.<br />
<inp2:m_if check="m_Get" var="sql_has_affected">
<br /><inp2:m_Phrase label="la_SQLAffectedRows"/>: <inp2:m_Get var="sql_affected"/>
</inp2:m_if>
</inp2:m_if>
</span>
</td>
</tr>
</table>
<inp2:m_if check="m_Get" var="query_status">
<inp2:m_if check="m_Get" var="sql_has_rows">
<br/>
<table width="100%" cellspacing="0" cellpadding="0" class="bordered">
<tr class="<inp2:m_odd_even odd='table-color1' even='table-color2'/>">
<inp2:m_inc param="tab_index" by="1"/>
<td colspan="3">
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr class="grid-header-row-0">
<inp2:m_DefineElement name="sql_column_title">
<td width="100%" nowrap="nowrap">
<span class="columntitle_small">
<img title="" src="../../admin/images/list_arrow_rt.gif" align="absmiddle" border="0">
<inp2:m_param name="value"/>
</span>
</td>
</inp2:m_DefineElement>
<inp2:adm_PrintSqlCols render_as="sql_column_title"/>
</tr>
<inp2:m_DefineElement name="sql_row">
<tr class="<inp2:m_odd_even odd='table-color1' even='table-color2'/>">
<inp2:m_param name="cells"/>
</tr>
</inp2:m_DefineElement>
<inp2:adm_PrintSqlRows render_as="sql_row"/>
</table>
</td>
</tr>
</table>
</inp2:m_if>
</inp2:m_if>
<inp2:m_include t="incs/footer"/>

Event Timeline

In-Portal CMS · In-Portal Community Pages · In-Portal Issue Tracker · In-Portal Repository Browser · Quality Assurance · In-Portal CI Server