示例#1
0
def item_buy(request, pk):
	cur = ADMIN_CURSOR.cursor()
	req = "select * from catalog_view where catalog_id=" + str(pk)
	cur.execute(req)
	items = [Item(list(cur)[0])]
	if request.POST:
		count = request.POST.get('count', '')
		try:
			count = int(count)
			if count > items[0].count:
				log_error = "We haven't got so much!"
			else:
				user_name = "'" + str(request.COOKIES['user_nickname']) + "'"

				cur.callproc('user_order', [str(request.COOKIES['user_nickname']), items[0].id, count,
				                            items[0].price, items[0].catalog_id])
				items[0].count -= count
				log_error = "We accepted your order. Reservation expire after 48 hours.\nWe're waiting you!"
		except ValueError:
			log_error = "Input a number"

		return render(request, 'catalog_list.html', {'items': items,
		                                             'can_buy': True, 'log_error': log_error})

	return render(request, 'catalog_list.html', {'items': items,
	                                             'can_buy': True})
示例#2
0
def create_order(request):
	cur = ADMIN_CURSOR.cursor()
	cur.execute("select * from items")
	items = [Item(i) for i in cur]

	cur.execute("select * from providers")
	providers = [Provider(i) for i in cur]
	log_error = ''
	if request.POST:
		item_id = request.POST.get('item_id', '')
		provider_id = request.POST.get('provider_id', '')
		qty = request.POST.get('qty', '')
		print(item_id)
		print(provider_id)
		print(qty)
		try:
			qty = int(qty)
			cur.callproc('insert_order', [item_id, provider_id, qty])
			return redirect('/admin/adminPanel/')
		except ValueError:
			log_error = "QTY not a number"

	return render(request, 'new_order.html', {'items': items,
	                                          'providers': providers,
	                                          'log_error': log_error})
示例#3
0
def user_detail(request):
	cur = ADMIN_CURSOR.cursor()
	log = "'" + str(request.COOKIES['user_nickname']) + "'"
	req = "select * from user_view where login="******"POST":
		old = request.POST.get('old_password', '')
		new = request.POST.get('new_password', '')
		confirm = request.POST.get('confirm_password', '')
		print(new)
		print(confirm)
		if old != user.password:
			login_error = "Wrong old password"
		elif new != confirm:
			login_error = "Passwords don't match"
		else:
			new_user = cur.callproc('update_user', [user.id, user.role_id, user.login, new])
			print list(new_user)
			login_error = "Password saved"

	req = "select * from sales_view where user_id=" + str(user.id)
	cur.execute(req)
	sales = [SaleTable(i) for i in cur]
	has_sales = len(sales)
	return render(request, 'user_detail.html',
	              {'user': user, 'sales': sales,
	               'has_sales': has_sales,
	               'login_error': login_error})
示例#4
0
def login(request):
	if request.method == "POST":
		user_name = request.POST.get('login', '')
		user_pass = request.POST.get('password', '')

		cur = ADMIN_CURSOR.cursor()
		user_exist = cur.callfunc('auth_user', cx_Oracle.NUMBER, [user_name, user_pass])

		if user_exist == -1:
			return render(request, 'login.html', {'login_error': "This login does't exist"})
		elif user_exist == 0:
			return render(request, 'login.html', {'login_error': "Wrong password"})
		else:
			print "all right"
			req = "select * from users where id=" + str(int(user_exist))
			cur.execute(req)
			user = list(cur)[0]

			response = redirect('/')
			response.set_cookie(key='priority', value=user[1])
			response.set_cookie(key='user_nickname', value=user[2])

			cur.close()
			return response
	return render(request, 'login.html', {})
示例#5
0
def create_provider(request):
	if request.POST:
		name = request.POST.get('name', '')
		type = request.POST.get('address', '')
		notes = request.POST.get('phone', '')

		cur = ADMIN_CURSOR.cursor()
		cur.callproc('insert_provider', [name, type, notes])
		return redirect('/admin/adminPanel/')
	return render(request, 'new_provider.html')
示例#6
0
def create_item(request):
	if request.POST:
		name = request.POST.get('name', '')
		type = request.POST.get('type', '')
		notes = request.POST.get('notes', '')

		cur = ADMIN_CURSOR.cursor()
		cur.callproc('insert_item', [name, type, notes])
		return redirect('/admin/adminPanel/')
	return render(request, 'new_item.html')
示例#7
0
def provider_detail(request, pk):
	cur = ADMIN_CURSOR.cursor()
	req = "select * from providers where id=" + str(pk)
	cur.execute(req)
	provider = Provider(list(cur)[0])
	if request.POST:
		provider_name = request.POST.get('name', '')
		provider_type = request.POST.get('address', '')
		provider_notes = request.POST.get('phone', '')
		cur.callproc('update_provider', [provider.id, provider_name, provider_type, provider_notes])
		return redirect('/admin/adminPanel/')
	return render(request, 'provider_detail.html', {'provider': provider})
示例#8
0
def admin_user_detail(request, pk):
	cur = ADMIN_CURSOR.cursor()
	req = "select * from user_view where id=" + str(pk)
	cur.execute(req)
	user = User(list(cur)[0])
	req = "select * from sales_view where user_id=" + str(user.id)
	cur.execute(req)
	sales = [SaleTable(i) for i in cur]
	has_sales = len(sales)

	cur.execute("select * from roles")
	roles = [{'id': i[0], 'discription': i[1]} for i in cur]

	return render(request, 'user_detail.html',
	              {'user': user, 'sales': sales,
	               'has_sales': has_sales, 'roles': roles})
示例#9
0
def adminPanel(request):
	cur = ADMIN_CURSOR.cursor()
	cur.execute("select * from user_view")
	users = [User(i) for i in cur]
	cur.execute("select * from providers")
	providers = [Provider(i) for i in cur]
	cur.execute("select * from site_item_view")
	sites = [Site(i) for i in cur]
	cur.execute("select * from invoices_view")
	invoices = [Invoice(i) for i in cur]
	cur.execute("select * from sales_view")
	sales = [SaleTable(i) for i in cur]
	cur.execute("select * from items")
	items = [Item(i) for i in cur]
	return render(request, 'adminPanel.html', {'users': users, 'providers': providers,
	                                           'sites': sites, 'invoices': invoices,
	                                           'sales': sales, 'items': items})
示例#10
0
def item_detail(request, pk):
	# if request.COOKIES['priority'] == 1:
	cur = ADMIN_CURSOR.cursor()
	# else:
	# 	cur = cx_Oracle.connect('auth_user1128@localhost:1521/xe').cursor()
	req = "select * from items where id=" + str(pk)
	cur.execute(req)
	item = Item(list(cur)[0])
	if request.POST:
		item_name = request.POST.get('name', '')
		item_type = request.POST.get('type', '')
		item_notes = request.POST.get('notes', '')
		cur.callproc('update_item', [item.id, item_name, item_type, item_notes])
		item.name = item_name
		item.type = item_type
		item.notes = item_notes
		return redirect('/admin/adminPanel/')
	return render(request, 'item_detail.html', {'item': item})
示例#11
0
def register(request):
	if request.method == "POST":
		user_name = request.POST.get('login', '')
		user_pass = request.POST.get('password', '')

		cur = ADMIN_CURSOR.cursor()
		user_exist = cur.callfunc('auth_user', cx_Oracle.NUMBER, [user_name, user_pass])

		if user_exist != -1:
			return render(request, 'register.html', {'login_error': "This login already used"})
		elif user_exist == -1:
			new_user = cur.callproc('insert_user', [user_name, user_pass])
			print list(new_user)
			response = redirect('/')
			response.set_cookie(key='priority', value=3)
			response.set_cookie(key='user_nickname', value=user_name)
			return response
	return render(request, 'register.html', {})
示例#12
0
def create_invoice(request):
	cur = ADMIN_CURSOR.cursor()
	cur.execute("select * from items")
	items = [Item(i) for i in cur]

	cur.execute("select * from providers")
	providers = [Provider(i) for i in cur]
	log_error = ''
	if request.POST:
		item_id = request.POST.get('item_id', '')
		provider_id = request.POST.get('provider_id', '')
		amount = request.POST.get('amount', '')
		price = request.POST.get('price', '')

		try:
			amount = int(amount)
			price = int(price)

			cur.execute("select * from invoices_view")
			invoices = [Invoice(i) for i in cur]

			for i in invoices:
				if (i.provider_id == int(provider_id) and
						    i.item_id == int(item_id) and
					    ((i.invoice_date is None and
							      i.invoice_amount is None) or
							     i.invoice_amount < i.order_qty)
				    ):
					print(i.order_id)
					cur.callproc('insert_invoice', [i.order_id, amount, price])
					return redirect('/admin/adminPanel/')
			log_error = 'Order to this item not found'
		except ValueError:
			log_error = "Amount or Price not a number"
	return render(request, 'new_invoice.html', {'items': items,
	                                            'providers': providers,
	                                            'log_error': log_error})
示例#13
0
def item_delete(request, pk):
	cur = ADMIN_CURSOR.cursor()
	req = "delete from items where id=" + str(pk)
	cur.execute(req)
	return request
示例#14
0
def show_items_catalog(request):
	cur = ADMIN_CURSOR.cursor()
	cur.execute('select * from catalog_view')
	items = [Item(i) for i in cur]
	return render(request, 'catalog_list.html', {'items': items})