/**
* Delete image
* @param string $mainFolder - name of th block in Config/images.php
* @param string $filename - name of the file we delete
* @return bool
*/
public static function deleteImage($mainFolder, $filename)
{
$need = Config::get('images.' . $mainFolder);
if (!$need) {
return false;
}
foreach ($need as $one) {
$file = HOST . HTML::media('/images/' . $mainFolder . '/' . Arr::get($one, 'path') . '/' . $filename);
@unlink($file);
}
return true;
}
public function getItemsAction()
{
$id = Arr::get($_POST, 'parent_id');
$result = DB::select('catalog.*', 'catalog_images.image')->from('catalog')->join('catalog_images')->on('catalog_images.catalog_id', '=', 'catalog.id')->on('catalog_images.main', '=', DB::expr(1))->where('parent_id', '=', $id)->order_by('created_at', 'DESC')->find_all();
$data = array();
foreach ($result as $obj) {
$data[] = array('image' => is_file(HOST . HTML::media('images/catalog/medium/' . $obj->image)) ? HTML::media('images/catalog/medium/' . $obj->image) : '', 'name' => $obj->name, 'cost' => $obj->cost, 'id' => $obj->id);
}
die(json_encode(array('success' => true, 'result' => $data)));
}
public function moreAffisheAction()
{
$page = (int) Arr::get($_POST, 'page');
if (!isset($page)) {
$this->error('Ошибка загрузки');
}
// list posts
if (isset($_SESSION['idCity'])) {
// select places id
$places = DB::select('id')->from('places')->where('city_id', '=', $_SESSION['idCity'])->where('status', '=', DB::expr(1))->as_object()->execute();
$ids = array();
foreach ($places as $key => $value) {
$ids[] = $value->id;
}
if (count($ids) == 0) {
$ids[] = 0;
}
}
$dbObj = DB::select('afisha.*', array('places.name', 'p_name'), array(DB::expr('MIN(prices.price)'), 'p_from'), array(DB::expr('MAX(prices.price)'), 'p_to'))->from('afisha')->join('places', 'left outer')->on('afisha.place_id', '=', 'places.id')->on('places.status', '=', DB::expr(1))->join('prices', 'left outer')->on('afisha.id', '=', 'prices.afisha_id')->where('afisha.status', '=', 1)->where('afisha.event_date', '>', DB::expr(time()));
if (isset($_SESSION['idCity'])) {
$dbObj->where_open()->where('afisha.place_id', 'IN', $ids)->or_where('afisha.city_id', '=', $_SESSION['idCity'])->where_close();
}
$result = $dbObj->group_by('afisha.id')->order_by('afisha.event_date')->limit(Config::get('limit'))->offset(($page - 1) * (int) Config::get('limit'))->execute()->as_array();
foreach ($result as $key => $value) {
$result[$key]['p_name'] = Afisha\Models\Afisha::getItemPlace($value, true);
$result[$key]['cost'] = Afisha\Models\Afisha::getItemPrice($value, true);
$result[$key]['event_date'] = date('j', $value['event_date']) . ' ' . Dates::month(date('n', $value['event_date'])) . ' ' . date('Y', $value['event_date']);
if (!is_file(HOST . HTML::media('images/afisha/medium/' . $value['image']))) {
$result[$key]['image'] = false;
}
}
// Count of all posts
$dbObj = DB::select(array(DB::expr('COUNT(afisha.id)'), 'count'))->from('afisha');
if (isset($_SESSION['idCity'])) {
$dbObj->where_open()->where('afisha.place_id', 'IN', $ids)->or_where('afisha.city_id', '=', $_SESSION['idCity'])->where_close();
}
$count = $dbObj->where('afisha.status', '=', 1)->where('afisha.event_date', '>', DB::expr(time()))->as_object()->execute()->current()->count;
// Set view button more load
$showBut = true;
if ($count <= Config::get('limit') * $page) {
$showBut = false;
}
// Render template
$this->success(array('result' => $result, 'showBut' => $showBut));
}
Изображение
</div>
</div>
<div class="widgetContent">
<div class="form-vertical row-border">
<div class="form-group">
<div class="">
<?php
if (is_file(HOST . \Core\HTML::media('images/afisha/medium/' . $obj->image))) {
?>
<a href="<?php
echo \Core\HTML::media('images/afisha/medium/' . $obj->image);
?>
" rel="lightbox">
<img src="<?php
echo \Core\HTML::media('images/afisha/medium/' . $obj->image);
?>
" style="max-width: 100%;"/>
</a>
<br />
<a href="/backend/<?php
echo \Core\Route::controller();
?>
/delete_image/<?php
echo $obj->id;
?>
">Удалить изображение</a>
<?php
} else {
?>
<input type="file" name="file" style="max-width: 100%;" />
function deleteAction()
{
$id = (int) Route::param('id');
if (!$id) {
Message::GetMessage(0, 'Данные не существуют!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
$page = DB::select()->from($this->tablename)->where('id', '=', $id)->find();
if (!$page) {
Message::GetMessage(0, 'Данные не существуют!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
$images = DB::select()->from('catalog_images')->where('catalog_id', '=', $id)->find_all();
foreach ($images as $im) {
@unlink(HOST . HTML::media('images/catalog/small/' . $im->image));
@unlink(HOST . HTML::media('images/catalog/medium/' . $im->image));
@unlink(HOST . HTML::media('images/catalog/big/' . $im->image));
@unlink(HOST . HTML::media('images/catalog/original/' . $im->image));
}
DB::delete($this->tablename)->where('id', '=', $id)->execute();
Message::GetMessage(1, 'Данные удалены!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
<script src="<?php
echo HTML::media("js/jquery-1.11.0.min.js");
?>
"></script>
<script src="<?php
echo HTML::media("js/plugins.js");
?>
"></script>
<script src="<?php
echo HTML::media("js/init.js");
?>
"></script>
<script type="text/javascript" src="<?php
echo HTML::media('js/noty/jquery.noty.js');
?>
"></script>
<script type="text/javascript" src="<?php
echo HTML::media('js/noty/layouts/massageOutput.js');
?>
"></script>
<script type="text/javascript" src="<?php
echo HTML::media('js/noty/themes/default.js');
?>
"></script>
<script src="<?php
echo HTML::media("js/prog.js");
?>
"></script>
</div>
</div>
<div class="widgetContent">
<div class="form-vertical row-border">
<div class="form-group">
<label class="control-label">Изображение</label>
<div class="">
<?php
if (is_file(HOST . \Core\HTML::media('images/articles/original/' . $obj->image))) {
?>
<a href="<?php
echo \Core\HTML::media('images/articles/original/' . $obj->image);
?>
" rel="lightbox">
<img src="<?php
echo \Core\HTML::media('images/articles/small/' . $obj->image);
?>
" />
</a>
<br />
<a href="/backend/<?php
echo \Core\Route::controller();
?>
/delete_image/<?php
echo $obj->id;
?>
">Удалить изображение</a>
<?php
} else {
?>
<input type="file" name="file" />
