public function access()
{
if (!User::info()) {
return false;
}
$this->_access = User::caccess();
if (in_array(Route::controller(), array('ajax', 'form')) or in_array(Route::action(), array('printTicket', 'print', 'createOrder')) or Route::controller() == 'orders' && Route::action() == 'delete') {
return true;
}
if ($this->_access == 'no') {
$this->no_access();
}
if ($this->_access == 'view' && Route::action() != 'index' && Route::action() != 'edit') {
$this->no_access();
}
}
function innerAction()
{
if (User::info()->role_id != 2 && User::info()->id != Route::param('id')) {
$this->no_access();
}
// Select current user
$organizer = Model::getOrganizerById(Route::param('id'), 1);
if (!$organizer) {
$this->no_access();
}
$this->_seo['h1'] = 'Отчет организатора: ' . $organizer->name;
$this->_seo['title'] = 'Отчет организатора: ' . $organizer->name;
$this->setBreadcrumbs('Отчет организатора: ' . $organizer->name);
// Set filter vars
$date_s = NULL;
$date_po = NULL;
$eventId = null;
$status = null;
if (Arr::get($_GET, 'date_s')) {
$date_s = strtotime(Arr::get($_GET, 'date_s'));
}
if (Arr::get($_GET, 'date_po')) {
$date_po = strtotime(Arr::get($_GET, 'date_po'));
}
if (Arr::get($_GET, 'event') != 0) {
$eventId = Arr::get($_GET, 'event');
}
if (Arr::get($_GET, 'status') != 'null') {
$status = Arr::get($_GET, 'status');
}
$filter = array('date_s' => $date_s, 'date_po' => $date_po, 'status' => $status, 'event_id' => $eventId, 'organizer_id' => $organizer->id, 'order' => array('created_at', 'DESC'));
$posters = Model::getPosters($filter);
// Make array with all need data
$result = array();
foreach ($posters as $poster) {
$result[$poster->id]['poster'] = $poster;
$result[$poster->id]['detailed'] = Model::getDetailed($poster);
}
// Rendering
$this->_content = View::tpl(array('result' => $result, 'pay_statuses' => $this->pay_statuses, 'events' => DB::select()->from('afisha')->where('place_id', 'IS NOT', null)->where('organizer_id', '=', $organizer->id)->find_all(), 'tpl_folder' => $this->tpl_folder), $this->tpl_folder . '/Inner');
}
function editAction()
{
if (!User::admin()) {
HTTP::redirect('backend/' . Route::controller() . '/login');
}
$user = User::info();
if ($_POST) {
$post = $_POST;
if (strlen(Arr::get($post, 'password')) < $this->password_length or strlen(Arr::get($post, 'new_password')) < $this->password_length or strlen(Arr::get($post, 'confirm_password')) < $this->password_length or !User::factory()->check_password(Arr::get($post, 'password'), $user->password) or Arr::get($post, 'new_password') != Arr::get($post, 'confirm_password')) {
Message::GetMessage(0, 'Вы что-то напутали с паролями!');
HTTP::redirect('backend/' . Route::controller() . '/edit');
}
if (!strlen(trim(Arr::get($post, 'name')))) {
Message::GetMessage(0, 'Имя не может быть пустым!');
HTTP::redirect('backend/' . Route::controller() . '/edit');
}
if (!strlen(trim(Arr::get($post, 'login')))) {
Message::GetMessage(0, 'Логин не может быть пустым!');
HTTP::redirect('backend/' . Route::controller() . '/edit');
}
$count = DB::select(array(DB::expr('COUNT(id)'), 'count'))->from('users')->where('id', '!=', $user->id)->where('login', '=', Arr::get($post, 'login'))->count_all();
if ($count) {
Message::GetMessage(0, 'Пользователь с таким логином уже существует!');
HTTP::redirect('backend/' . Route::controller() . '/edit');
}
$data = array('name' => Arr::get($post, 'name'), 'login' => Arr::get($post, 'login'), 'password' => User::factory()->hash_password(Arr::get($post, 'new_password')));
Common::factory('users')->update($data, $user->id);
Message::GetMessage(1, 'Вы успешно изменили данные!');
HTTP::redirect('backend/' . Route::controller() . '/edit');
}
$this->_toolbar = Widgets::get('Toolbar/EditSaveOnly');
$this->_seo['h1'] = 'Мой профиль';
$this->_seo['title'] = 'Редактирование личных данных';
$this->setBreadcrumbs('Мой профиль', 'backend/' . Route::controller() . '/' . Route::action());
$this->_content = View::tpl(array('obj' => $user), 'Auth/Edit');
}
function createOrderAction()
{
if (User::get_access_for_controller('afisha_brone') != 'edit') {
$this->no_access();
}
$key = Route::param('key');
$keys = (array) explode(',', $key);
$keys = array_filter($keys);
if (count($keys) == 0) {
Message::GetMessage(0, 'Места не выбраны!');
HTTP::redirect('backend/afisha/index');
}
$afisha = DB::select('afisha.*', array('places.name', 'place'), 'places.filename', 'places.address')->from('afisha')->join('places')->on('afisha.place_id', '=', 'places.id')->where('afisha.id', '=', (int) Route::param('id'))->find();
if (!$afisha) {
return Config::error();
}
// Get prices by afisha ID
$prices = DB::select('id')->from('prices')->where('afisha_id', '=', $afisha->id)->find_all();
if (count($prices) == 0) {
Message::GetMessage(0, 'Ошибка создания заказа (выборка цен)');
HTTP::redirect('backend/afisha/index');
}
$pricesIds = array();
foreach ($prices as $price) {
$pricesIds[] = $price->id;
}
// Generate seats id from places list
$seats = DB::select('id')->from('seats')->where('view_key', 'IN', $keys)->where('price_id', 'IN', $pricesIds)->and_where_open()->where('status', '=', 1)->or_where_open()->where('status', '=', 2)->where('reserved_at', '<', time() - 60 * 60 * 24 * Config::get('reserved_days'))->or_where_close()->and_where_close()->find_all();
if (count($seats) == 0) {
Message::GetMessage(0, 'Ошибка создания заказа (выборка мест)');
HTTP::redirect('backend/afisha/index');
}
$seatsId = array();
foreach ($seats as $seat) {
$seatsId[] = $seat->id;
}
$orderType = (int) Route::param('orderType');
$data = array('afisha_id' => $afisha->id, 'is_admin' => User::info()->role_id == 2 ? 1 : 0, 'admin_brone' => $orderType, 'creator_id' => User::info()->id, 'seats_keys' => implode(',', $keys), 'created_at' => time(), 'first_created_at' => time(), 'status' => '');
$res = DB::insert('afisha_orders', array_keys($data))->values(array_values($data))->execute();
if ($res) {
// Update status
$res2 = DB::update('seats')->set(array('status' => $orderType == 1 ? 3 : 2, 'reserved_at' => time()))->where('id', 'IN', $seatsId)->execute();
Message::GetMessage(1, 'Заказ успешно создан!');
HTTP::redirect('backend/afisha_orders/edit/' . $res[0]);
} else {
Message::GetMessage(0, 'Ошибка создания заказа!');
HTTP::redirect('backend/afisha/index');
}
}
public function updateOrderStatusAction()
{
$post = $_POST;
$afisha_id = $post['afisha_id'];
$status = $post['status'];
if ($status == '') {
$status = null;
}
if ($status == 'success') {
$seatsStatus = 3;
} else {
$seatsStatus = 2;
}
$data = array('status' => $seatsStatus);
if ($seatsStatus == 2) {
$data['reserved_at'] = time();
}
if (!$afisha_id) {
die(json_encode(array('success' => false, 'message' => 'Ошибка получения данных')));
}
if ($status != 'success' && User::info()->role_id != 2) {
die(json_encode(array('success' => false, 'message' => 'У Вас нет прав для изменения статуса')));
}
$orderData = array('status' => $status);
if ($status == 'success') {
$orderData['payer_id'] = User::info()->id;
$orderData['payed_at'] = time();
$orderData['printed_seats'] = '';
} else {
$orderData['payer_id'] = 0;
}
\Core\Common::update('afisha_orders', $orderData)->where('id', '=', (int) $afisha_id)->execute();
// Get current order
$afisha = DB::select()->from('afisha_orders')->where('id', '=', (int) $afisha_id)->find();
$prices = DB::select('id')->from('prices')->where('afisha_id', '=', $afisha->afisha_id)->find_all();
$pricesArr = array();
if (count($prices)) {
foreach ($prices as $key => $value) {
$pricesArr[] = $value->id;
}
$res2 = \Core\Common::update('seats', $data)->where('view_key', 'IN', array_filter(explode(',', $afisha->seats_keys)))->where('price_id', 'IN', $pricesArr)->execute();
}
die(json_encode(array('success' => true, 'message' => 'Данные сохранены', 'reload' => true)));
}
function innerAction()
{
if (User::info()->role_id != 2 && User::info()->id != Route::param('id') && User::info()->see_all_cashier_stat == 0) {
$this->no_access();
}
// Set filter vars
$date_s = NULL;
$date_po = NULL;
$status = NULL;
$eventId = null;
$creatorId = null;
if (Arr::get($_GET, 'date_s')) {
$date_s = strtotime(Arr::get($_GET, 'date_s'));
}
if (Arr::get($_GET, 'date_po')) {
$date_po = strtotime(Arr::get($_GET, 'date_po'));
}
if (isset($this->pay_statuses[Arr::get($_GET, 'status')])) {
$status = Arr::get($_GET, 'status', 1);
}
if (Arr::get($_GET, 'status') == 'null') {
$status = 'null';
}
if (Arr::get($_GET, 'event') != 0) {
$eventId = Arr::get($_GET, 'event');
}
if (Arr::get($_GET, 'creator_id') != 0) {
$creatorId = Arr::get($_GET, 'creator_id');
}
// Select current user
$cassier = DB::select()->from($this->tablename)->where($this->tablename . '.id', '=', Route::param('id'))->find();
$this->_seo['h1'] = 'Статистика по ' . $cassier->name;
$this->_seo['title'] = 'Статистика по ' . $cassier->name;
$this->setBreadcrumbs('Статистика по ' . $cassier->name);
$ordersQuery = DB::select()->from('afisha_orders')->where('payer_id', '=', $cassier->id);
$this->setFilter($ordersQuery, $date_s, $date_po, $status, $eventId, $creatorId, 'afisha_orders');
$orders = $ordersQuery->order_by('created_at', 'DESC')->find_all();
// Make array with all need data
$afishaGroups = array();
foreach ($orders as $order) {
$afisha = DB::select()->from('afisha')->where('id', '=', $order->afisha_id)->find();
$afishaGroups[$order->afisha_id]['afisha'] = $afisha;
$afishaGroups[$order->afisha_id]['orders'][$order->id] = $order;
}
// Rendering
$this->_content = View::tpl(array('afishaGroups' => $afishaGroups, 'pay_statuses' => $this->pay_statuses, 'events' => DB::select()->from('afisha')->where('place_id', 'IS NOT', null)->find_all(), 'creators' => array(), 'pager' => '', 'tpl_folder' => $this->tpl_folder), $this->tpl_folder . '/Inner');
}
function printAction()
{
if (User::get_access_for_controller('afisha_brone') != 'edit') {
$this->no_access();
}
$seats = (array) $_POST['SEATS'];
$printType = $_POST['print-type'] ? $_POST['print-type'] : 'base';
if (count($seats) == 0) {
Message::GetMessage(0, 'Места не выбраны!');
HTTP::redirect('backend/afisha_orders/edit/' . Route::param('id'));
}
$order = DB::select()->from($this->tablename)->where('id', '=', Route::param('id'))->find();
if (!$order) {
return Config::error();
}
$afisha = DB::select('afisha.*', array('places.name', 'place'), 'places.filename', 'places.address', 'places.city_id')->from('afisha')->join('places')->on('afisha.place_id', '=', 'places.id')->where('afisha.id', '=', $order->afisha_id)->find();
if (!$afisha) {
return Config::error();
}
$city = DB::select()->from('cities')->where('id', '=', $afisha->city_id)->find();
$seatStr = array();
$termoSeatStr = array();
try {
$dom = Map::factory()->loadFile($afisha->filename)->getDomInstance();
$gTag = $dom->getElementsByTagName('g');
foreach ($gTag as $el) {
$id = $el->getAttribute('id');
if (in_array($id, $seats)) {
if ($el->parentNode->hasAttribute('data-plase')) {
$originalPlace = $el->parentNode->getAttribute('data-plase');
} elseif ($el->parentNode->parentNode->hasAttribute('data-plase')) {
$originalPlace = $el->parentNode->parentNode->getAttribute('data-plase');
}
if ($originalPlace) {
$place = str_replace('(левая сторона)', '(лев. сторона)', $originalPlace);
$place = str_replace('(правая сторона)', '(пр. сторона)', $place);
$place = str_replace(',', '<br />', $place);
$place = str_replace('ряд', 'ряд:', $place);
$seatStr[$id] = str_replace(array('места', 'Места'), 'место', $place);
$dataInit = json_decode($el->getAttribute('data-init'));
$seatStr[$id] .= $dataInit->seat;
// For termo print
preg_match('#^(.*)?, ряд ([0-9]+)#', $originalPlace, $matches);
$termoSeatStr[$id]['block'] = $matches[1];
$termoSeatStr[$id]['row'] = $matches[2];
$termoSeatStr[$id]['seat'] = $dataInit->seat;
$termoSeatStr[$id]['block'] = str_replace('(левая сторона)', '(лев. сторона)', $termoSeatStr[$id]['block']);
$termoSeatStr[$id]['block'] = str_replace('(правая сторона)', '(пр. сторона)', $termoSeatStr[$id]['block']);
}
}
}
} catch (\Exception $e) {
die('Ошибка загрузки карты');
}
$tickets = array();
foreach ($seats as $seat) {
if (User::info()->role_id != 2 && User::get_access_for_controller('afisha_print_unlimit') == 'edit' && strpos($order->printed_seats, $seat) !== false) {
continue;
}
$priceRow = DB::select('price')->from('prices')->join('seats', 'LEFT')->on('prices.id', '=', 'seats.price_id')->where('afisha_id', '=', $order->afisha_id)->where('seats.view_key', '=', $seat)->find();
$tickets[] = Arr::to_object(array('event_name' => $afisha->name, 'print_name' => $afisha->print_name, 'print_name_small' => $afisha->print_name_small, 'event_date' => date('d', $afisha->event_date) . ' ' . Dates::month(date('m', $afisha->event_date)) . ' ' . date('Y', $afisha->event_date) . ' в ' . $afisha->event_time, 'event_place' => $afisha->place, 'event_just_date' => date('j', $afisha->event_date) . ' ' . Dates::month(date('m', $afisha->event_date)) . ' ' . date('Y', $afisha->event_date), 'event_time' => $afisha->event_time, 'event_address' => $afisha->address, 'place_string' => $seatStr[$seat], 'place_block' => $termoSeatStr[$seat]['block'], 'place_row' => $termoSeatStr[$seat]['row'], 'place_seat' => $termoSeatStr[$seat]['seat'], 'price' => $priceRow->price, 'phone' => $city->phone, 'barcode' => $afisha->id . '-' . $order->id . '-' . $seat));
}
// Update print seats keys
if (User::info()->role_id != 2 && User::get_access_for_controller('afisha_print_unlimit') == 'edit') {
$oldSeats = $order->printed_seats;
$newSeats = array();
if (strlen($oldSeats)) {
$oldSeats = explode(',', $oldSeats);
if (count($oldSeats)) {
$newSeats = (array) $oldSeats;
}
}
foreach ($seats as $seat) {
$newSeats[] = $seat;
}
$newSeats = array_filter(array_unique($newSeats));
$newSeats = implode(',', $newSeats);
DB::update($this->tablename)->set(array('printed_seats' => $newSeats))->where('id', '=', $order->id)->execute();
}
// Update order status
$newOrder = DB::select()->from('afisha_orders')->where('id', '=', $order->id)->find();
$printedAllSeats = true;
$printedSeats = array_filter(explode(',', $newOrder->printed_seats));
foreach (array_filter(explode(',', $newOrder->seats_keys)) as $seat) {
if (!in_array($seat, $printedSeats)) {
$printedAllSeats = false;
}
}
if (User::info()->role_id != 2 && $printedAllSeats) {
\Core\Common::update('afisha_orders', array('status' => 'success'))->where('id', '=', (int) $order->id)->execute();
$prices = DB::select('id')->from('prices')->where('afisha_id', '=', $order->afisha_id)->find_all();
$pricesArr = array();
if (count($prices)) {
foreach ($prices as $key => $value) {
$pricesArr[] = $value->id;
}
\Core\Common::update('seats', array('status' => 3))->where('view_key', 'IN', array_filter(explode(',', $order->seats_keys)))->where('price_id', 'IN', $pricesArr)->execute();
}
}
if ($printType == 'base') {
echo View::tpl(array('tickets' => $tickets), 'Afisha_orders/Print');
} else {
echo View::tpl(array('tickets' => $tickets), 'Afisha_orders/PrintTermo');
}
die;
}
/**
* Check if user want to remember his password
* If true - auth him
*/
public function is_remember()
{
if (User::info()) {
return false;
}
if (!isset($_COOKIE[$this->_session])) {
return false;
}
$cookie = Cookie::getArray($this->_session);
if (!isset($cookie['remember']) || (int) $cookie['remember'] == 0) {
return false;
}
if (!isset($cookie['id']) || (int) $cookie['id'] == 0) {
return false;
}
if (isset($cookie['exit']) && (int) $cookie['exit'] == 1) {
return false;
}
if (!isset($cookie['exit'])) {
Cookie::set($this->_session, array('remember' => (int) $cookie['remember'], 'exit' => 0, 'id' => $cookie['id']), 60 * 60 * 24 * 7);
}
$user = DB::select($this->_tbl . '.*', array($this->_tbl_roles . '.alias', 'role'))->from($this->_tbl)->join($this->_tbl_roles)->on($this->_tbl . '.role_id', '=', $this->_tbl_roles . '.id')->where($this->_tbl . '.status', '=', 1)->where($this->_tbl . '.id', '=', $cookie['id']);
if (APPLICATION) {
$user->where($this->_tbl_roles . '.alias', '!=', 'user');
} else {
$user->where($this->_tbl_roles . '.alias', '=', 'user');
}
$user = $user->find();
if (!$user) {
return false;
}
if ($this->auth($user, $cookie['remember'])) {
HTTP::redirect(Arr::get($_SERVER, 'REQUEST_URI'));
}
return false;
}