class AdminBookView(TemplateView):
template_name = 'Store/admin/books/books.html'
book_dao = BookDao()
publisher_dao = PublisherDao()
genre_dao = GenreDao()
author_dao = AuthorDao()
@never_cache
def get(self, request):
context = {}
if 'user_id' in request.session:
if request.session['user_is_staff'] == 1:
# Create forms for Django to handle
books = self.book_dao.get_all()
context = {'books': books, 'num_books': len(books)}
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return render(request, self.template_name, context)
else:
return redirect(reverse('home'))
else:
return redirect(reverse('login'))
@never_cache
def post(self, request):
return redirect(reverse('adminaddbook'))
class AdminPublisherIndexView(TemplateView):
template_name = 'Store/admin/publishers/publishers.html'
pdao = PublisherDao()
@never_cache
def get(self, request):
publishers = self.pdao.get_all()
apublisher = PublisherForm()
context = {'publishers': publishers, 'apublisher': apublisher}
user_id = request.session['user_id']
username = request.session['username']
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return render(request, self.template_name, context)
@never_cache
def post(self, request):
user_id = request.session['user_id']
username = request.session['username']
context = {}
apublisher = PublisherForm(request.POST)
if 'create-publisher' in request.POST:
if apublisher.is_valid():
p = Publisher()
p.company_name = apublisher.cleaned_data['company_name']
p.city = apublisher.cleaned_data['city']
p.state_code = apublisher.cleaned_data['state_code']
p.zip_code = apublisher.cleaned_data['zip_code']
p.phone_number = apublisher.cleaned_data['phone_number']
p.contact_name = apublisher.cleaned_data['contact_name']
self.pdao.create(p)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return redirect(reverse('adminpublisherindex'))
class AdminBookDetailView(TemplateView):
template_name = 'Store/admin/books/details.html'
book_dao = BookDao()
image_dao = ImageDao()
inventory_dao = InventoryDao()
publisher_dao = PublisherDao()
genre_dao = GenreDao()
author_dao = AuthorDao()
# This gets the choices for the author, publisher, and genre dropdowns
authors = []
authors.append(("default", {
'label': "Choose an author",
'disabled': True
}))
for author in author_dao.get_all():
author_val = (str(author.author_id),
str(author.last_name) + ", " + str(author.first_name))
authors.append(author_val)
publishers = []
publishers.append(("default", {
'label': "Choose a publisher",
'disabled': True
}))
for publisher in publisher_dao.get_all():
publisher_val = (str(publisher.publisher_id),
str(publisher.company_name))
publishers.append(publisher_val)
genres = []
genres.append(("default", {'label': "Choose a genre", 'disabled': True}))
for genre in genre_dao.get_all():
genre_val = (str(genre.genre_id), str(genre.genre))
genres.append(genre_val)
@never_cache
def get(self, request, book_id):
book = self.book_dao.get_byid(book_id)
images = self.image_dao.get_byid(book_id)
inventory = self.inventory_dao.get_byid(book_id)
initial_data = {
'title': book.title,
'authors': book.author.author_id,
'isbn10': book.isbn10,
'isbn13': book.isbn13,
'copyright_date': book.copyRightDate,
'edition': book.edition,
'publishers': book.publisher.publisher_id,
'book_type': book.type,
'num_pages': book.numberOfPages,
'genres': book.genre.genre_id,
'quantity_on_hand': inventory.quantity_on_hand,
'cost': inventory.cost,
'retail_price': inventory.retail_price
}
book_form = BookForm(initial_data,
author_choices=self.authors,
publisher_choices=self.publishers,
genre_choices=self.genres)
image_form = BookImageForm()
context = {
'book': book,
'images': images,
'book_form': book_form,
'image_form': image_form
}
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return render(request, self.template_name, context)
def post(self, request, book_id):
user_id = request.session['user_id']
username = request.session['username']
book_form = BookForm(request.POST,
author_choices=self.authors,
publisher_choices=self.publishers,
genre_choices=self.genres)
book = self.book_dao.get_byid(book_id)
context = {'book': book}
if 'update-book' in request.POST:
if book_form.is_valid():
updated_book = Book()
updated_book.book_id = book_id
updated_book.title = book_form.cleaned_data['title']
updated_book.isbn10 = book_form.cleaned_data['isbn10']
updated_book.isbn13 = book_form.cleaned_data['isbn13']
updated_book.copyRightDate = book_form.cleaned_data[
'copyright_date']
updated_book.edition = book_form.cleaned_data['edition']
updated_book.numberOfPages = book_form.cleaned_data[
'num_pages']
updated_book.type = book_form.cleaned_data['book_type']
author = Author()
author.author_id = int(book_form.cleaned_data['authors'])
updated_book.author = author
publisher = Publisher()
publisher.publisher_id = int(
book_form.cleaned_data['publishers'])
updated_book.publisher = publisher
genre = Genre()
genre.genre_id = int(book_form.cleaned_data['genres'])
updated_book.genre = genre
x = self.inventory_dao.get_byid(book_id)
updated_inventory = Inventory()
updated_inventory.book_id = book_id
updated_inventory.quantity_on_hand = book_form.cleaned_data[
'quantity_on_hand']
updated_inventory.quantity_ordered = x.quantity_ordered
updated_inventory.retail_price = book_form.cleaned_data[
'retail_price']
updated_inventory.cost = book_form.cleaned_data['cost']
self.book_dao.update(updated_book)
self.inventory_dao.update(updated_inventory)
context['notification'] = "Book updated successfully!"
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return redirect(
reverse(('adminbookdetail'), kwargs={'book_id': book_id}))
else:
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
context['notification'] = "Not a valid submission."
elif 'delete-book' in request.POST:
book_id = int(request.POST.get('delete-book'))
self.book_dao.delete(book_id)
if 'add-image' in request.POST:
image_form = BookImageForm(request.POST, request.FILES)
if image_form.is_valid():
image_file = request.FILES['image']
fs = FileSystemStorage()
filename = fs.save(image_file.name, image_file)
uploaded_file_url = fs.url(filename)
image = Image()
image.image_url = uploaded_file_url
image.caption = ''
image.book.book_id = book_id
self.image_dao.create(image)
context['notification'] = filename
return redirect(
reverse(('adminbookdetail'), kwargs={'book_id': book_id}))
else:
context['notification'] = "Not a valid submission."
return render(request, self.template_name, context)
class AdminAddBookView(TemplateView):
template_name = 'Store/admin/books/addbook.html'
book_dao = BookDao()
publisher_dao = PublisherDao()
genre_dao = GenreDao()
author_dao = AuthorDao()
authors = []
publishers = []
genres = []
# This gets the choices for the author, publisher, and genre dropdowns
def get_dropdown_data(self):
self.authors = []
self.publishers = []
self.genres = []
self.authors.append(("default", {
'label': "Choose an author",
'disabled': True
}))
for author in self.author_dao.get_all():
author_val = (str(author.author_id), str(author.last_name) + ", " +
str(author.first_name))
self.authors.append(author_val)
self.publishers.append(("default", {
'label': "Choose a publisher",
'disabled': True
}))
for publisher in self.publisher_dao.get_all():
publisher_val = (str(publisher.publisher_id),
str(publisher.company_name))
self.publishers.append(publisher_val)
self.genres.append(("default", {
'label': "Choose a genre",
'disabled': True
}))
for genre in self.genre_dao.get_all():
genre_val = (str(genre.genre_id), str(genre.genre))
self.genres.append(genre_val)
@never_cache
def get(self, request):
context = {}
if 'user_id' in request.session:
if request.session['user_is_staff'] == 1:
self.get_dropdown_data()
# Create forms for Django to handle
book_form = BookForm(author_choices=self.authors,
publisher_choices=self.publishers,
genre_choices=self.genres)
publisher_form = PublisherForm()
author_form = AuthorForm()
genre_form = GenreForm()
context = {
'book_form': book_form,
'publisher_form': publisher_form,
'author_form': author_form,
'genre_form': genre_form
}
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return render(request, self.template_name, context)
else:
return redirect(reverse('home'))
else:
return redirect(reverse('login'))
def post(self, request):
context = {}
self.get_dropdown_data()
# Handle POST requests
if 'create-book' in request.POST:
sub_book_form = BookForm(request.POST,
author_choices=self.authors,
publisher_choices=self.publishers,
genre_choices=self.genres)
book = Book()
if sub_book_form.is_valid():
book.title = sub_book_form.cleaned_data['title']
book.isbn10 = sub_book_form.cleaned_data['isbn10']
book.isbn13 = sub_book_form.cleaned_data['isbn13']
book.copyRightDate = sub_book_form.cleaned_data[
'copyright_date']
book.edition = sub_book_form.cleaned_data['edition']
book.numberOfPages = sub_book_form.cleaned_data['num_pages']
book.type = sub_book_form.cleaned_data['book_type']
author = Author()
author.author_id = int(sub_book_form.cleaned_data['authors'])
book.author = author
publisher = Publisher()
publisher.publisher_id = int(
sub_book_form.cleaned_data['publishers'])
book.publisher = publisher
genre = Genre()
genre.genre_id = int(sub_book_form.cleaned_data['genres'])
book.genre = genre
book.inventory.quantity_on_hand = sub_book_form.cleaned_data[
'quantity_on_hand']
book.inventory.cost = sub_book_form.cleaned_data['cost']
book.inventory.retail_price = sub_book_form.cleaned_data[
'retail_price']
self.book_dao.create(book)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
context['notification'] = "Book saved successfully!"
return redirect(reverse('adminbookindex'))
else:
context['notification'] = "Not a valid submission."
elif 'create-publisher' in request.POST:
sub_publisher_form = PublisherForm(request.POST)
publisher = Publisher()
if sub_publisher_form.is_valid():
publisher.company_name = sub_publisher_form.cleaned_data[
'company_name']
publisher.city = sub_publisher_form.cleaned_data['city']
publisher.state_code = sub_publisher_form.cleaned_data[
'state_code']
publisher.zip_code = sub_publisher_form.cleaned_data[
'zip_code']
publisher.phone_number = sub_publisher_form.cleaned_data[
'phone_number']
publisher.contact_name = sub_publisher_form.cleaned_data[
'contact_name']
self.publisher_dao.create(publisher)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
context['notification'] = "Publisher saved successfully!"
return redirect(reverse('adminaddbook'))
else:
context['notification'] = "Not a valid submission."
elif 'create-author' in request.POST:
sub_author_form = AuthorForm(request.POST)
author = Author()
if sub_author_form.is_valid():
author.first_name = sub_author_form.cleaned_data['first_name']
author.last_name = sub_author_form.cleaned_data['last_name']
self.author_dao.create(author)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
context['notification'] = "Author saved successfully!"
return redirect(reverse('adminaddbook'))
else:
context['notification'] = "Not a valid submission."
elif 'create-genre' in request.POST:
sub_genre_form = GenreForm(request.POST)
genre = Genre()
if sub_genre_form.is_valid():
genre.genre = sub_genre_form.cleaned_data['genre']
self.genre_dao.create(genre)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
context['notification'] = "Genre saved successfully!"
return redirect(reverse('adminaddbook'))
else:
context['notification'] = "Not a valid submission."
else:
return redirect(reverse('adminaddbook'))
class AdminPublisherDetailView(TemplateView):
template_name = 'Store/admin/publishers/details.html'
pdao = PublisherDao()
bdao = BookDao()
idao = InventoryDao()
@never_cache
def get(self, request, publisher_id):
publisher = self.pdao.get_byid(publisher_id)
books = self.idao.getInventoryByPublisher(publisher_id)
initial_data = {
'company_name': publisher.company_name,
'city': publisher.city,
'state_code': publisher.state_code,
'zip_code': publisher.zip_code,
'phone_number': publisher.phone_number,
'contact_name': publisher.contact_name
}
epublisher = PublisherForm(initial_data)
context = {
'publisher': publisher,
'books': books,
'epublisher': epublisher,
'sum':
self.pdao.getTotalPublisherRevenueByPublisherID(publisher_id),
'sum_inventory':
self.pdao.getTotalInventoryByPublisherID(publisher_id)
}
user_id = request.session['user_id']
username = request.session['username']
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return render(request, self.template_name, context)
@never_cache
def post(self, request, publisher_id):
user_id = request.session['user_id']
username = request.session['username']
context = {}
epublisher = PublisherForm(request.POST)
if 'update-publisher' in request.POST:
if epublisher.is_valid():
p = Publisher()
p.company_name = epublisher.cleaned_data['company_name']
p.city = epublisher.cleaned_data['city']
p.state_code = epublisher.cleaned_data['state_code']
p.zip_code = epublisher.cleaned_data['zip_code']
p.phone_number = epublisher.cleaned_data['phone_number']
p.contact_name = epublisher.cleaned_data['contact_name']
p.publisher_id = publisher_id
self.pdao.update(p)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return redirect(
reverse(('adminpublisherdetail'),
kwargs={'publisher_id': publisher_id}))
if 'delete-publisher' in request.POST:
self.pdao.delete(publisher_id)
context['user_id'] = request.session['user_id'],
context['username'] = request.session['username']
return redirect(reverse('adminpublisherindex'))