function add_author() { global $current_user; $this->ca(); $id_person = (int) $_POST['id_author']; $id_book = (int) $_POST['id']; $id_role = (int) $_POST['id_role']; if ($id_role && $id_person && $id_book) { $persons = Persons::getInstance()->getByIdsLoaded(array($id_person)); if (!isset($persons[$id_person]) || !$persons[$id_person]->id) { $this->data['item_id'] = $id_person; $this->data['success'] = 0; $this->data['error'] = 'Нет такого автора'; return; } $query = 'INSERT INTO `book_persons` SET `id_book`=' . $id_book . ' , `id_person`=' . $id_person . ', `person_role`=' . $id_role; $r = Database::query($query, false); if ($r) { $this->data['success'] = 1; $this->data['item_id'] = $id_person; $this->data['name'] = $persons[$id_person]->getName(); $this->data['role'] = Config::$person_roles[$id_role]; BookLog::addLog(array('id_person' => $id_person, 'person_role' => $id_role), array('id_person' => 0, 'person_role' => 0), $id_book); $log_id = BookLog::saveLog($id_book, BookLog::TargetType_book, $current_user->id, BiberLog::BiberLogType_bookEditPerson); BookLog::saveLogLink($log_id, $id_person, BookLog::TargetType_person, $current_user->id, BiberLog::BiberLogType_bookEditPerson, $copy = 1); $search = Search::getInstance(); /* @var $search Search */ $search->updateBook(new Book($id_book)); Notify::notifyAuthorNewBook($id_person, $id_book); } else { $this->data['error'] = 'Автор уже есть в списке авторов'; } return; } $this->data['item_id'] = $id_person; $this->data['success'] = 0; }
function newBook() { // добавляем книгу global $current_user; /* @var $current_user CurrentUser */ $fields = array('title' => 'title', 'subtitle' => 'subtitle', 'isbn' => 'ISBN', 'year' => 'year', 'lang_code' => 'id_lang', 'annotation' => 'description', 'rightholder' => 'id_rightholder'); Request::$post['lang_code'] = Config::$langs[Request::$post['lang_code']]; Request::$post['title'] = trim(prepare_review(Request::$post['title'], '')); Request::$post['annotation'] = trim(prepare_review(Request::$post['annotation'], false, '<img>')); if (!Request::$post['title']) { throw new Exception('title missed'); } foreach ($fields as $field => $bookfield) { if (!isset(Request::$post[$field])) { throw new Exception('field missed #' . $field); } $to_update[$bookfield] = Request::$post[$field]; } if (Request::$post['n'] && Request::$post['m']) { $to_update['book_type'] = Book::BOOK_TYPE_MAGAZINE; $to_update['title'] = Database::sql2single('SELECT `title` FROM `magazines` WHERE `id`=' . (int) Request::$post['m']); } $q = array(); foreach ($to_update as $field => $value) { if (in_array($field, array('year'))) { $value = (int) $value; } $q[] = '`' . $field . '`=' . Database::escape($value) . ''; } if (count($q)) { $q[] = '`add_time`=' . time(); $query = 'INSERT INTO `book` SET ' . implode(',', $q); Database::query($query); if ($lid = Database::lastInsertId()) { if (Request::$post['n'] && Request::$post['m']) { // журнал - вставляем $query = 'INSERT INTO `book_magazines` SET `id_book`=' . $lid . ',id_magazine=' . (int) Request::$post['m'] . ',`year`=' . $to_update['year'] . ',`n`=' . (int) Request::$post['n']; Database::query($query, false); $query = 'UPDATE `magazines` SET `books_count`=(SELECT COUNT(1) FROM `book_magazines` WHERE `id_magazine`=' . (int) Request::$post['m'] . ') WHERE `id`=' . (int) Request::$post['m']; Database::query($query); } if (isset(Request::$post['author_id']) && Request::$post['author_id']) { $query = 'INSERT INTO `book_persons` SET `id_book`=' . $lid . ',`id_person`=' . (int) Request::$post['author_id'] . ',`person_role`=' . Book::ROLE_AUTHOR; Database::query($query, false); BookLog::addLog(array('id_person' => (int) Request::$post['author_id'], 'person_role' => Book::ROLE_AUTHOR), array('id_person' => 0, 'person_role' => 0), $lid); BookLog::saveLog($lid, BookLog::TargetType_book, $current_user->id, BiberLog::BiberLogType_bookEditPerson); Notify::notifyAuthorNewBook((int) Request::$post['author_id'], $lid); } if (isset($_FILES['cover']) && $_FILES['cover']['tmp_name']) { $folder = Config::need('static_path') . '/upload/covers/' . ceil($lid / 5000); @mkdir($folder); // inserting new cover $query = 'INSERT INTO `book_covers` SET `id_book`=' . $lid; Database::query($query); $cover_id = Database::lastInsertId(); // generating file names $filename_normal = $folder . '/default_' . $lid . '_' . $cover_id . '.jpg'; $filename_small = $folder . '/small_' . $lid . '_' . $cover_id . '.jpg'; $filename_big = $folder . '/big_' . $lid . '_' . $cover_id . '.jpg'; $filename_orig = $folder . '/orig_' . $lid . '_' . $cover_id . '.jpg'; $to_update['is_cover'] = $cover_id; $thumb = new Thumb(); $thumb->createThumbnails($_FILES['cover']['tmp_name'], array($filename_small, $filename_normal, $filename_big, $filename_orig), self::$cover_sizes); $query = 'UPDATE `book` SET `is_cover`=' . $cover_id . ' WHERE `id`=' . $lid; Database::query($query); $current_user->gainActionPoints('books_add_cover', $lid, BiberLog::TargetType_book); } // file loading if (isset($_FILES['file']) && isset($_FILES['file']['tmp_name']) && $_FILES['file']['tmp_name']) { $filetype_ = explode('.', $_FILES['file']['name']); $filetype_ = isset($filetype_[count($filetype_) - 1]) ? $filetype_[count($filetype_) - 1] : ''; $fts = Config::need('filetypes'); $filetype = false; foreach ($fts as $ftid => $ftname) { if ($ftname == $filetype_) { $filetype = $ftid; } } if (!$filetype) { throw new Exception('wrong filetype:' . $filetype_); } $destinationDir = Config::need('files_path') . DIRECTORY_SEPARATOR . getBookFileDirectory($book->id, $filetype); @mkdir($destinationDir, 0755); // добавляем запись в базу $filesize = $_FILES['file']['size']; $query = 'INSERT INTO `book_files` SET `id_book`=' . $book->id . ', `filetype`=' . $filetype . ', `id_file_author`=' . $current_user->id . ', `modify_time`=' . time() . ', `filesize`=' . $filesize; Database::query($query); $id_file = Database::lastInsertId(); BookLog::addLog(array('id_file' => $id_file, 'filetype' => $filetype, 'id_file_author' => $current_user->id, 'filesize' => $filesize), array('id_file' => 0, 'filetype' => 0, 'id_file_author' => 0, 'filesize' => 0), $lid); $to_update_ = array(); if ($id_file) { $to_update_['id_main_file'] = $id_file; $destinationFile = getBookFilePath($id_file, $book->id, $filetype, Config::need('files_path')); if (!move_uploaded_file($_FILES['file']['tmp_name'], $destinationFile)) { throw new Exception('Cant save file to ' . $destinationFile); } if ($filetype == 1) { // FB2 $parser = new FB2Parser($destinationFile); $parser->parseDescription(); $toc = $parser->getTOCHTML(); $to_update_['description'] = $parser->getProperty('annotation'); $to_update_['title'] = $parser->getProperty('book-title'); $to_update_['table_of_contents'] = $toc; } $q = array(); foreach ($to_update_ as $field => &$value) { if (in_array($field, array('year'))) { $value = is_numeric($value) ? $value : 0; } $q[] = '`' . $field . '`=' . Database::escape($value) . ''; } if (count($q)) { $query = 'UPDATE `book` SET ' . implode(',', $q) . ' WHERE `id`=' . $lid; Database::query($query); BookLog::addLog($to_update_, $book->data, $book->id); } $to_update = array_merge($to_update, $to_update_); } } else { // it is no any files! Ocr::afterBookCreate($lid, $current_user->id); } BookLog::addLog($to_update, array(), $lid); BookLog::saveLog($lid, BookLog::TargetType_book, $current_user->id, BiberLog::BiberLogType_bookNew); ob_end_clean(); $event = new Event(); $event->event_BooksAdd($current_user->id, $lid); $event->push(); $search = Search::getInstance(); /* @var $search Search */ $search->updateBook(new Book($lid)); Books::getInstance()->dropCache($lid); header('Location:' . Config::need('www_path') . '/b/' . $lid); Database::query('COMMIT'); $current_user->gainActionPoints('books_new_nofile', $lid, BiberLog::TargetType_book); exit; } } }