<?php
$mg = db::get_string("SELECT * FROM `MAIL` WHERE (`USERS` LIKE ? OR `ADM_ID` = ?) AND `ID` = ? LIMIT 1", ['%:'.user('ID').':%', user('ID'), intval(get('id'))]);
acms_header(lg('Вложения групповой беседы %s', tabs($mg['NAME'])), 'users');
if (!isset($mg['ID'])) {
error('Неверная директива');
redirect('/account/mail/');
}
if (get('get') == 'videos') {
$root = 'videos';
$f = null;
$v = 'h';
$m = null;
$fl = null;
}elseif (get('get') == 'music') {
$root = 'music';
$f = null;
$v = null;
$m = 'h';
$fl = null;
}elseif (get('get') == 'files') {
$root = 'files';
$f = null;
$v = null;
$m = null;
$fl = 'h';
}else{
$root = 'photos';
$f = 'h';
$v = null;
$m = null;
$fl = null;
}
?>
<div class='menu-nav-content'>
<a class='menu-nav <?=$f?>' href='/account/mail/group_attachments/?id=<?=$mg['ID']?>'>
<?=lg('Фото')?>
</a>
<a class='menu-nav <?=$v?>' href='/account/mail/group_attachments/?id=<?=$mg['ID']?>&get=videos'>
<?=lg('Видео')?>
</a>
<a class='menu-nav <?=$m?>' href='/account/mail/group_attachments/?id=<?=$mg['ID']?>&get=music'>
<?=lg('Музыка')?>
</a>
<a class='menu-nav <?=$fl?>' href='/account/mail/group_attachments/?id=<?=$mg['ID']?>&get=files'>
<?=lg('Файлы')?>
</a>
</div>
<?
$column = db::get_column("SELECT COUNT(DISTINCT `ATTACHMENTS`.`ID`) AS `count` FROM `MAIL_GROUPS_MESSAGE` LEFT JOIN `ATTACHMENTS` ON (`MAIL_GROUPS_MESSAGE`.`ID` = `ATTACHMENTS`.`ID_POST`) WHERE `MAIL_GROUPS_MESSAGE`.`GROUP_ID` = ? AND `ATTACHMENTS`.`TYPE` = ? AND `ATTACHMENTS`.`TYPE_POST` = ?", [$mg['ID'], $root, 'group_message']);
$spage = spage($column, PAGE_SETTINGS);
$page = page($spage);
$limit = PAGE_SETTINGS * $page - PAGE_SETTINGS;
if ($column == 0){
html::empty('Пока пусто');
}else{
?><div class='list-body'><?
}
$data = db::get_string_all("SELECT `ATTACHMENTS`.`TYPE`,`ATTACHMENTS`.`OBJECT_ID` FROM `MAIL_GROUPS_MESSAGE` LEFT JOIN `ATTACHMENTS` ON (`MAIL_GROUPS_MESSAGE`.`ID` = `ATTACHMENTS`.`ID_POST`) WHERE `MAIL_GROUPS_MESSAGE`.`GROUP_ID` = ? AND `ATTACHMENTS`.`TYPE` = ? AND `ATTACHMENTS`.`TYPE_POST` = ? GROUP BY `ATTACHMENTS`.`ID` ORDER BY `MAIL_GROUPS_MESSAGE`.`TIME` DESC LIMIT ".$limit.", ".PAGE_SETTINGS, [$mg['ID'], $root, 'group_message']);
while ($list = $data->fetch()){
if ($list['TYPE'] == 'photos') {
$photo = db::get_string("SELECT `ID`,`SHIF`,`NAME` FROM `PHOTOS` WHERE `ID` = ? LIMIT 1", [$list['OBJECT_ID']]);
if (isset($photo['ID'])) {
?>
<a href="/m/photos/show/?id=<?=$photo['ID']?>">
<div class="list-menu hover">
<div class="files-info-list">
<div class="files-ext">
<img src="/files/upload/photos/150x150/<?=$photo['SHIF']?>.jpg" style="max-width: 60px" class="img">
</div>
<div class="files-info">
<b><font color="#484F54"><?=crop_text(tabs($photo['NAME']), 0, 25)?></font></b>
</div>
</div>
</div>
</a>
<?
}else{
?>
<div class="list-menu">
<?=lg('Файл был удален')?>
</div>
<?
}
}
if ($list['TYPE'] == 'videos') {
$video = db::get_string("SELECT `NAME`,`ID`,`EXT` FROM `VIDEOS` WHERE `ID` = ? LIMIT 1", [$list['OBJECT_ID']]);
if (isset($video['ID'])) {
?>
<a href="/m/videos/show/?id=<?=$video['ID']?>">
<div class="list-menu hover">
<div class="files-info-list">
<div class="files-ext">
<?=file::ext($video['EXT'])?>
</div>
<div class="files-info">
<b><font color="#484F54"><?=crop_text(tabs($video['NAME']), 0, 25)?></font></b>
</div>
</div>
</div>
</a>
<?
}else{
?>
<div class="list-menu">
<?=lg('Файл был удален')?>
</div>
<?
}
}
if ($list['TYPE'] == 'music') {
$music = db::get_string("SELECT `ARTIST`,`NAME`,`EXT`,`ID` FROM `MUSIC` WHERE `ID` = ? LIMIT 1", [$list['OBJECT_ID']]);
if (isset($music['ID'])) {
?>
<a href="/m/music/show/?id=<?=$music['ID']?>">
<div class="list-menu hover">
<div class="files-info-list">
<div class="files-ext">
<?=file::ext($music['EXT'])?>
</div>
<div class="files-info">
<b><font color="#484F54"><?=crop_text(tabs($music['ARTIST']), 0, 25)?> - <?=crop_text(tabs($music['NAME']), 0, 25)?></font></b>
</div>
</div>
</div>
</a>
<?
}else{
?>
<div class="list-menu">
<?=lg('Файл был удален')?>
</div>
<?
}
}
if ($list['TYPE'] == 'files') {
$files = db::get_string("SELECT `NAME`,`EXT`,`ID` FROM `FILES` WHERE `ID` = ? LIMIT 1", [$list['OBJECT_ID']]);
if (isset($files['ID'])) {
?>
<a href="/m/files/show/?id=<?=$files['ID']?>">
<div class="list-menu hover">
<div class="files-info-list">
<div class="files-ext">
<?=file::ext($files['EXT'])?>
</div>
<div class="files-info">
<b><font color="#484F54"><?=crop_text(tabs($files['NAME']), 0, 25)?></font></b>
</div>
</div>
</div>
</a>
<?
}else{
?>
<div class="list-menu">
<?=lg('Файл был удален')?>
</div>
<?
}
}
}
if ($column > 0){
?></div><?
}
get_page('/account/mail/group_attachments/?id='.$mg['ID'].'&get='.$root.'&', $spage, $page, 'list');
back('/account/mail/messages_group/?id='.$mg['ID']);
acms_footer();