Файл: databasr/templates/table/view.tpl
Строк: 144
{extends file="templates/index/index.tpl"}
{block
name="content"}
<div class="container">
<div class="row margin-bottom-small">
<div
class="col-sm-4">
<div class="widget
bg-white">
<div class="widget-icon
bg-blue pull-left fa fa-th-list"></div>
<div class="overflow-hidden">
<span
class="widget-title">{$table.data|count}</span>
<span class="widget-subtitle">records in
this table</span>
</div>
</div>
</div>
<div
class="col-sm-4">
<div class="widget
bg-white">
<div class="widget-icon
bg-blue pull-left fa fa-columns"></div>
<div class="overflow-hidden">
<span
class="widget-title">{$table.fields|count}</span>
<span class="widget-subtitle">fields per
record</span>
</div>
</div>
</div>
<div
class="col-sm-4">
<div class="widget
bg-white">
<div class="widget-icon
bg-blue pull-left fa fa-database"></div>
<div class="overflow-hidden">
<span class="widget-title">{$table.size}</span>
<span class="widget-subtitle">Table
size</span>
</div>
</div>
</div>
</div>
<div class="row">
<div
class="col-sm-8">
<div
class="panel">
<div
class="panel-heading border">
{$table.name} Query Builder
</div>
<div class="panel-body">
<form action="{url controller=table action=query}"
method="post">
<textarea
name="query" class="form-control" cols="30"
rows="10">SELECT * FROM {$table.name};</textarea>
<div class="margin-top-small
text-right">
<input
type="hidden" name="table_name"
value="{$table.name}" />
<button type="submit" class="btn btn-info">Run
query</button>
</div>
</form>
</div>
</div>
</div>
<div
class="col-sm-4">
<div
class="panel">
<div
class="panel-heading border">
Fast
actions
</div>
<div
class="panel-body">
<ul
class="list-actions">
<li><a href="{url controller=table action=insert
table=$table.name}"><i class="fa
fa-angle-right"></i> Insert new record</a></li>
<li><a
data-toggle="confirmation" data-href="{url controller=table
action=truncatetable table=$table.name}"><i class="fa
fa-angle-right"></i> Truncate table</a></li>
<li><a data-toggle="confirmation"
data-href="{url controller=table action=drop
table=$table.name}"><i class="fa
fa-angle-right"></i> Drop table</a></li>
<li><a href="{url controller=table
action=structure table=$table.name}"><i class="fa
fa-angle-right"></i> Display table
structure</a></li>
<li><a
href="{url controller=table action=data
table=$table.name}"><i class="fa
fa-angle-right"></i> Refresh data</a></li>
</ul>
</div>
</div>
</div>
</div>
<div class="row">
<div
class="col-sm-12">
<div
class="panel">
<div
class="panel-heading border">
<div class="row">
<div
class="col-xs-6">{$table.name} Data - {$table.data|count}
records</div>
<div
class="col-xs-6 text-right">
<a href="{url controller=table action=insert
table=$table.name}" class="btn btn-info">Add
record</a>
</div>
</div>
</div>
<div class="panel-body">
{strip}
<table data-update-url="{url controller=table
action=update}">
<tr>
{foreach $table.fields as $field}
<th>{$field->name|ucfirst}</th>
{/foreach}
<th></th>
</tr>
{foreach $table.data as $data}
<tr>
{foreach $table.fields as
$field}
<td>
{if $field->type == "tinyint"
&& $field->max_length == 1 && {$data.{$field->name}}
== 1}
<span
class="pill pill-green"></span>
{elseif $field->type == "tinyint"
&& $field->max_length == 1 && {$data.{$field->name}}
== 0}
<span
class="pill pill-red"></span>
{else}
{{$data.{$field->name}}|trim|strip_tags|truncate:30:'..':true}
{/if}
</td>
{/foreach}
<td>
<ul class="table-options">
<li><a href="{url controller=table
action=editrecord table=$table.name
internalId=$data@iteration}"><i class="fa
fa-pencil"></i></a></li>
<li><a data-toggle="confirmation"
data-href="{url controller=table action=droprecord table=$table.name
internalId=$data@iteration}"><i class="fa
fa-trash"></i></a></li>
</ul>
</td>
</tr>
{foreachelse}
<tr>
<td colspan="{$table.fields|count+2}"
class="text-center text-info">There is no content
here.</td>
</tr>
{/foreach}
</table>
{/strip}
</div>
</div>
</div>
</div>
</div>
{/block}