/** * 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'); }