def apply_goods(id, count, user_id, created_at=None):
goods = db.goods_get_by_id(id)
if int(count) > int(goods['count']):
raise exception.GoodsIsNotEnoughException()
values = {
'apply_user': user_id,
'apply_goods': id,
'apply_count': count,
'is_approval': 0,
'created_at': created_at if created_at else None
}
return db.application_create(values)
def get_application_by_user_id(role, user_id):
application_list = []
if role == '1':
result = db.application_get_all()
else:
result = db.application_get_by_user_id(user_id)
count = 1
for application in result:
application = dict(application)
application['num'] = count
application['name'] = db.goods_get_by_id(application['apply_goods'])['name']
if application['approval'] == 0 and application['decline'] == 0:
application['status'] = '未处理'
elif application['approval'] == 1 and application['decline'] == 0:
application['status'] = '已通过'
elif application['approval'] == 0 and application['decline'] == 1:
application['status'] = '已拒绝'
application_list.append(application)
count += 1
return application_list
def merchant_account_book(merchant_id, type, year):
goods_name_list = []
goods_list = db.goods_list_asc(merchant_id)
month_list = ['一月', '二月', '三月', '四月', '五月', '六月', '七月', '八月', '九月', '十月', '十一月', '十二月']
data_list = []
for goods in goods_list:
data_dict = {
'goods_name': goods['name'],
'money': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
}
data_list.append(data_dict)
goods_name_list.append(goods['name'])
min_time = str(year) + '-01-01 00:00:00'
max_time = str(year) + '-12-31 23:59:59'
consume_list = db.consume_list_by_created_at(merchant_id, min_time, max_time)
for consume in consume_list:
if consume['goods_id'] == '0':
continue
goods = db.goods_get_by_id(consume['goods_id'])
count = -1
for temp in goods_name_list:
count += 1
if goods['name'] == temp:
break
if type == '0':
data_list[count]['money'][int(str(consume['created_at']).split('-')[1])-1] += consume['consume_money']
elif type == '1':
data_list[count]['money'][int(str(consume['created_at']).split('-')[1]) - 1] += (consume['consume_money'] - goods['price'])
# for data in data_list:
# for mon in range(12):
# total_month_consume_monny = db.consume_money_by_created_at(merchant_id, str(year) + '-%s-01 00:00:00'%(mon+1), str(year) + '-%s-31 23:59:59'%(mon+1))
# if total_month_consume_monny:
# data['money'][mon] = str(data['money'][mon]) + '/' + str(round(data['money'][mon]/total_month_consume_monny*100, 2)) + '%'
# else:
# continue
value_dict = {
'goods_name_list': goods_name_list,
'month_list': month_list,
'data_list': data_list,
}
return value_dict
def update_application(role, application_id, approval):
application = db.application_get_by_id(application_id)
goods = db.goods_get_by_id(application['apply_goods'])
if goods['count'] - application['apply_count'] < 0 and approval == 'True':
raise exception.GoodsIsNotEnoughException()
if application['approval'] == 0 and application['decline'] == 0 and role == '1':
if approval == 'True':
values = {
'approval': 1
}
if approval == 'False':
values = {
'decline': 1
}
res = db.application_update_by_id(application_id, values)
if res:
if approval == 'True':
values = {
'count': goods['count'] - application['apply_count']
}
db.goods_update_by_id(application['apply_goods'], values)
def goods_get_by_id(goods_id):
goods_dict = dict(db.goods_get_by_id(goods_id))
return goods_dict
def get_goods_by_id(id):
goods = db.goods_get_by_id(id)
return dict(goods)