/** * 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" />