/**
* Check cron table if need and send some letters
*/
public function check()
{
if (!Config::get('main.cron') or !Config::get('main.selfCron')) {
return false;
}
$ids = array();
$result = DB::select()->from(Config::get('main.tableCron'))->limit(Config::get('main.selfCron'))->as_object()->execute();
foreach ($result as $obj) {
$ids[] = $obj->id;
Email::send($obj->subject, $obj->text, $obj->email);
}
if (count($ids)) {
DB::delete(Config::get('main.tableCron'))->where('id', 'IN', $ids)->execute();
}
}
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');
}
Files::deleteImage($this->image, $page->image);
DB::delete($this->tablename)->where('id', '=', $id)->execute();
DB::delete('prices')->where('afisha_id', '=', $id)->execute();
Message::GetMessage(1, 'Данные удалены!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
public function deleteSpecificationValueAction()
{
$post = $_POST;
// Check data
$id = Arr::get($post, 'id');
if (!$id) {
die(json_encode(array('success' => false, 'error' => 'Вы ввели не все данные')));
}
// Trying to delete value
$result = DB::delete('specifications_values')->where('id', '=', $id)->execute();
// Error if failed saving
if (!$result) {
die(json_encode(array('success' => false, 'error' => 'Ошибка на сервере. Повторите попытку позднее')));
}
// Answer
die(json_encode(array('success' => true)));
}
public function clear()
{
DB::delete('carts')->where("id", "=", $this->_cart_id)->execute();
$this->_cart_id = 0;
$this->_cart = array();
Cookie::delete('cart');
$this->recount();
}
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');
}
$countChildGroups = DB::select(array(DB::expr('COUNT(id)'), 'count'))->from('catalog_tree')->where('parent_id', '=', $id)->count_all();
if ($countChildGroups) {
Message::GetMessage(0, 'Нельзя удалить эту группу, так как у нее есть подгруппы!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
$countChildItems = DB::select(array(DB::expr('COUNT(id)'), 'count'))->from('catalog')->where('parent_id', '=', $id)->count_all();
if ($countChildItems) {
Message::GetMessage(0, 'Нельзя удалить эту группу, так как в ней содержатся товары!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
Files::deleteImage($this->image, $page->image);
DB::delete($this->tablename)->where('id', '=', $id)->execute();
Message::GetMessage(1, 'Данные удалены!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
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');
}
function deleteAction()
{
$id = (int) Route::param('id');
if (!$id) {
Message::GetMessage(0, 'Данные не существуют!');
HTTP::redirect('backend/afisha_orders/index');
}
$page = DB::select()->from($this->tablename)->where('id', '=', $id)->find();
if (!$page) {
Message::GetMessage(0, 'Данные не существуют!');
HTTP::redirect('backend/afisha_orders/index');
}
// Change statuses for all places
$viewKeys = array_filter(explode(',', $page->seats_keys));
if (count($viewKeys)) {
$prices = DB::select()->from('prices')->where('afisha_id', '=', $page->afisha_id)->find_all();
if (count($prices)) {
$pricesIds = array();
foreach ($prices as $key => $value) {
$pricesIds[] = $value->id;
}
Common::update('seats', array('status' => 1, 'reserved_at' => null))->where('view_key', 'IN', $viewKeys)->where('price_id', 'IN', $pricesIds)->execute();
}
}
DB::delete($this->tablename)->where('id', '=', $id)->execute();
Message::GetMessage(1, 'Данные удалены!');
HTTP::redirect('backend/afisha_orders/index');
}
/**
* @param mixed $value - value
* @param string $field - field
* @return object
*/
public static function delete($value, $field = 'id')
{
return DB::delete(static::$table)->where($field, '=', $value)->execute();
}
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)->as_object()->execute()->current();
if (!$page) {
Message::GetMessage(0, 'Данные не существуют!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
DB::update($this->tablename)->set(array('parent_id' => $page->parent_id))->where('parent_id', '=', $id)->execute();
DB::delete($this->tablename)->where('id', '=', $id)->execute();
Message::GetMessage(1, 'Данные удалены!');
HTTP::redirect('backend/' . Route::controller() . '/index');
}
