public function get_mt($type = 0)
{
$lang = \CORE::lng();
$mt = array();
$DB = \DB::init();
$type = $this->selected_type;
if ($DB->connect()) {
if ($type > 0) {
$sql = "SELECT * FROM `mt` WHERE `mt-type`=:type ORDER BY `mt-name-" . $lang . "`;";
$sth = $DB->dbh->prepare($sql);
$sth->execute(array('type' => $type));
} else {
$sql = "SELECT * FROM `mt` ORDER BY `mt-type`,`mt-name-" . $lang . "`;";
$sth = $DB->dbh->prepare($sql);
$sth->execute();
}
$DB->query_count();
if ($sth->rowCount() > 0) {
while ($r = $sth->fetch()) {
$mt[$r['mt-id']] = $r;
}
}
}
return $mt;
}
public function get_translations($module = 'all')
{
$translations = array();
$lang = \CORE::lng();
$DB = \DB::init();
if ($DB->connect()) {
$sql = "SELECT * FROM `mt-translation` WHERE `t-module`=:module;";
$sth = $DB->dbh->prepare($sql);
$sth->execute(array('module' => $module));
$DB->query_count();
if ($sth->rowCount() > 0) {
while ($r = $sth->fetch()) {
$translations[$r['t-alias']] = array('module' => $r['t-module'], 'ru' => $r['t-ru'], 'tj' => $r['t-tj']);
}
}
}
return $translations;
}
public function main($model)
{
$lang = \CORE::lng();
$UI = \CORE\UI::init();
$result = '<div><h4>' . \CORE::t('mt', 'Образовательные учреждения') . ':</h4></div>';
$mt = $model->get_mt();
$mt_types = $model->get_mt_types();
$mt_count = count($mt);
$result .= '<p><strong>' . \CORE::t('filter', 'Фильтр') . ':</strong> ' . \CORE::t('types', 'Типы') . '
' . $UI->html_list($mt_types, '', ' id="type"', $model->selected_type, '-- ' . \CORE::t('all', 'Все') . ' --') . '<p>';
$result .= '<p>' . $UI->bootstrap_modal_btn('show_newModal', 'newModal', \CORE::t('add_mt', 'Добавить учреждение')) . '</p>';
if ($mt_count > 0) {
$geo = $model->get_geo_objects();
$result .= '
<table class="table table-bordered table-hover" style="width:auto;">
<thead>
<tr>
<th>№</th>
<th>' . \CORE::t('type', 'Тип') . '</th>
<th>' . \CORE::t('mt_name', 'Название учреждения') . '</th>
<th>ID</th>
<th>' . \CORE::t('geo', 'География') . '</th>
<th>' . \CORE::t('address', 'Адрес') . '</th>
<th class="text-center">' . \CORE::t('action', 'Действие') . '</th>
</tr>
</thead>
<tbody>
';
$cnt = 0;
foreach ($mt as $mt_id => $mt_val) {
$cnt++;
$mt_type = '';
if (isset($mt_types[$mt_val['mt-type']])) {
$mt_type = $mt_types[$mt_val['mt-type']];
}
$mt_geo = '';
if (isset($geo[$mt_val['mt-geo-id']])) {
$mt_geo = $geo[$mt_val['mt-geo-id']];
}
$result .= '
<tr>
<td>' . $cnt . '</td>
<td>' . $mt_type . '</td>
<td>' . $mt_val['mt-name-' . $lang] . '</td>
<td>' . $mt_id . '</td>
<td>' . $mt_geo . '</td>
<td>' . $mt_val['mt-address'] . '</td>
<td>
<div id="' . $mt_id . '" class="btn-group btn-group-xs">
<button type="button" class="btn btn-default edit" data-toggle="modal" data-target="#editModal">' . \CORE::t('edit', 'изменить') . '</button>
<button type="button" class="btn btn-default delete">' . \CORE::t('delete', 'удалить') . '</button>
</div>
</td>
</tr>
';
}
$result .= '</tbody>
</table>
';
} else {
\CORE::msg('info', \CORE::t('no_mt', 'В базе не найдены образовательные учреждения'));
}
$geo_info = '';
$geo_list = $model->get_gid_geo_objects();
if (count($geo_list) > 0) {
// totdo !!! change for all groups - gid
$geo_info = '
<div class="form-group">
<label for="new_geo">' . \CORE::t('location', 'Расположение') . '</label>
' . $UI->html_list($geo_list, '', ' id="new_geo" class="form-control"') . '
</div>';
}
$new_body = $geo_info . '
<div class="form-group">
<label for="new_type">' . \CORE::t('type', 'Тип') . '</label>
' . $UI->html_list($mt_types, '', ' id="new_type" class="form-control"', $model->selected_type) . '
</div>
<div class="form-group">
<label for="new_name_ru">' . \CORE::t('mt_name', 'Название учреждения') . ' (RU)</label>
<input type="text" class="form-control" id="new_name_ru" placeholder="Название">
</div>
<div class="form-group">
<label for="new_name_tj">' . \CORE::t('mt_name', 'Название учреждения') . ' (TJ)</label>
<input type="text" class="form-control" id="new_name_tj" placeholder="Номи муассиса">
</div>
<div class="form-group">
<label for="new_director">Директор</label>
<input type="text" class="form-control" id="new_director" placeholder="Ф.И.О.">
</div>
<div class="form-group">
<label for="new_address">' . \CORE::t('address', 'Адрес') . '</label>
<input type="text" class="form-control" id="new_address" placeholder="' . \CORE::t('address', 'Адрес') . '">
</div>
<div class="form-group">
<label for="new_phone">Телефон</label>
<input type="text" class="form-control" id="new_phone" placeholder="">
</div>
<div class="form-group">
<label for="new_mobile">' . \CORE::t('mobile', 'Мобильный') . '</label>
<input type="text" class="form-control" id="new_mobile" placeholder="9XXXXXXXX">
</div>
<hr>
<div class="form-group">
<div class="row">
<div class="col-md-6">
<label for="new_geo_lat">Latitude</label>
<input type="text" class="form-control" id="new_geo_lat" placeholder="38.XXXXXXX">
</div>
<div class="col-md-6">
<label for="new_geo_lng">Longitude</label>
<input type="text" class="form-control" id="new_geo_lng" placeholder="68.XXXXXXX">
</div>
</div>
</div>
';
$result .= $UI->bootstrap_modal('newModal', \CORE::t('new_mt', 'Новое учреждение') . ':', '', $new_body, 'addNew', \CORE::t('add', 'Добавить'));
$UI->pos['js'] .= '
<script>
$(document).ready(function() {
$("#type").change(function(){
var sel_type = $(this).val();
if(sel_type>0){
window.location.href="./?c=mt&type="+sel_type;
} else {
window.location.href="./?c=mt";
}
});
$("#addNew").click(function(e){
e.preventDefault();
alert("add...");
});
$(".edit").click(function(){
var edit_id = $(this).parent("div").attr("id");
});
$(".delete").click(function(){
var del_id = $(this).parent("div").attr("id");
if(confirm("' . \CORE::t('delete', "Удалить") . '?")){
$.post("./?c=mt&act=del&ajax", {id: del_id}, function(data){
if(data=="deleted"){
location.reload();
} else {
alert("Error, check js log...");
console.log(data);
}
});
}
});
});
</script>
';
return $result;
}
<?php
$pages = array('home' => 'home', 'user' => 'user', 'admin' => 'admin', 'about' => 'about', 'about_opendata' => 'about_opendata', 'team' => 'team');
\CORE\UI::init()->set_pages($pages);
\CORE::init()->set_modules(array('mt' => 1, 'frm' => 1, 'stat' => 1, 'map' => 1, 'vs' => 1, 'od' => 1, 'apps' => 1, 'translation' => 1));
$USER = \USER::init();
if ($USER->auth()) {
// for authorized users (!) because of $DB->connect()
// load translations from DB
$new_lng = array();
$c_lang = \CORE::lng();
$DB = \DB::init();
if ($DB->connect()) {
if (\CORE::get_c() != '') {
$sql = "SELECT * FROM `mt-translation` WHERE `t-module`=:module OR `t-module`='all';";
$sth = $DB->dbh->prepare($sql);
$sth->execute(array('module' => \CORE::get_c()));
} else {
$sql = "SELECT * FROM `mt-translation` WHERE `t-module`='all';";
$sth = $DB->dbh->prepare($sql);
$sth->execute();
}
$DB->query_count();
if ($sth->rowCount() > 0) {
while ($r = $sth->fetch()) {
$new_lng[$r['t-alias']] = $r['t-' . $c_lang];
}
}
}
\CORE::msg('debug', 'load translations from DB');
\CORE::set_lng($new_lng);
