def user_have_order():
id_worker = id_handler.IdWorker()
user_list = provider_user.User.select_old_user()
new_user_list = []
img_id_list = []
user_id_map = {}
for user_row in user_list:
header_img = user_row[6]
img_id_list.append(header_img)
img_id_map = service_base.Base.user_img(img_id_list)
for user_row in user_list:
user_id = user_row[0]
new_user_id = id_worker.get_id()
user_id_map[user_id] = new_user_id
header_img = user_row[6]
new_header_img = None
if header_img in img_id_map:
new_header_img = img_id_map[header_img]
new_user_list.append((new_user_id, user_row[1], '',
user_row[2], new_header_img, None,
user_row[3], user_row[9], user_row[8], user_row[4], user_row[7]))
coupon_id_map = service_order.Order.user_coupon(user_id_map)
service_order.Order.user_address(user_id_map)
provider_user.User.insert_batch_new_user(new_user_list) # 批量添加用户
goods_id_map, accessory_id_map, meal_id_map, new_goods_list, new_accessory_list, new_meal_list = User.operate_goods()
order_id_map = service_order.Order.user_order(user_id_map, coupon_id_map)
service_order.Order.order_item(order_id_map, goods_id_map, meal_id_map, accessory_id_map, new_goods_list, new_accessory_list, new_meal_list)
goods_id_map.update(accessory_id_map)
goods_id_map.update(meal_id_map)
service_goods.Goods.goods_judge(user_id_map, goods_id_map, order_id_map)
service_goods.Goods.meal_judge(user_id_map, goods_id_map, order_id_map)
return user_id_map, goods_id_map
def back_history():
id_worker = id_handler.IdWorker()
back_list = provider_order.Order.select_old_back()
new_back_list = []
for back_row in back_list:
mark_id = back_row[0]
order_no = back_row[1]
add_time = back_row[2]
pay_status = back_row[3]
cid = back_row[4]
new_back_list.append((id_worker.get_id(),order_no,add_time,pay_status,cid))
provider_order.Order.insert_batch_new_back(new_back_list)
def user_img(img_id_list):
id_worker = id_handler.IdWorker()
img_list = provider_base.Base.select_old_img(str(tuple(img_id_list)))
new_img_list = []
img_id_map = {}
for img_row in img_list:
img_id = img_row[0]
new_img_id = id_worker.get_id()
img_id_map[img_id] = new_img_id
img_path = img_row[1]
new_img_list.append((new_img_id, img_path, img_path.split('.')[1]))
provider_base.Base.insert_batch_new_img(new_img_list)
return img_id_map
def accessory_img(accessory_id_map):
id_worker = id_handler.IdWorker()
img_list = provider_base.Base.select_old_accessory_img(
str(tuple(accessory_id_map)))
new_img_list = []
accessory_img_map = {}
for img_row in img_list:
img_id = img_row[0]
new_img_id = id_worker.get_id()
img_path = img_row[1]
accessory_id = img_row[2]
accessory_img_map[accessory_id] = new_img_id
new_img_list.append((new_img_id, img_path, img_path.split('.')[1]))
provider_base.Base.insert_batch_new_img(new_img_list)
return accessory_img_map
def order_item(order_id_map, goods_id_map, meal_id_map, accessory_id_map, new_goods_list, new_accessory_list, new_meal_list):
id_worker = id_handler.IdWorker()
item_list = provider_order.Order.select_old_item(str(tuple(order_id_map)))
new_item_list = []
for item_row in item_list:
mark_id = item_row[0]
order_mark = item_row[1]
goods_mark = item_row[2]
if goods_mark in goods_id_map:
product_id = goods_id_map[goods_mark]
product_type = 0
for goods_row in new_goods_list:
if goods_row[0] == product_id:
product_name = goods_row[1]
break
elif goods_mark in accessory_id_map:
product_id = accessory_id_map[goods_mark]
product_type = 3
for accessory_row in new_accessory_list:
if accessory_row[1] == product_id:
product_name = accessory_row[1]
break
elif goods_mark in meal_id_map:
product_id = meal_id_map[goods_mark]
product_type = 2
for meal_row in new_meal_list:
if meal_row[0] == product_id:
product_name = meal_row[1]
break
quantity = item_row[3]
pay_price = item_row[4]
base_price = item_row[5]
cost_price = item_row[6]
exchange_mark = item_row[7]
coupon_count = item_row[8]
new_item_list.append(
(id_worker.get_id(), order_id_map[order_mark], product_id, product_type, product_name, None, quantity,
cost_price / 100.00, base_price / 100.00, pay_price / 100.00, exchange_mark))
provider_order.Order.insert_new_item(new_item_list)
def user_coupon(user_id_map):
id_worker = id_handler.IdWorker()
coupon_list = provider_order.Order.select_old_coupon(str(tuple(user_id_map)))
new_coupon_list = []
coupon_id_map = {}
for coupon_row in coupon_list:
coupon_id = coupon_row[0]
name = coupon_row[1]
user_mark = coupon_row[2]
create_time = coupon_row[3]
use_time = coupon_row[4]
end_time = coupon_row[5]
server_status = 0
if use_time is not None:
server_status = 1
limit_size = coupon_row[6]
coupon_size = coupon_row[7]
new_coupon_id = id_worker.get_id()
coupon_id_map[coupon_id] = new_coupon_id
new_coupon_list.append((new_coupon_id, user_id_map[user_mark],server_status, create_time, end_time,
use_time, limit_size / 100.00, coupon_size / 100.00, name, 1))
provider_order.Order.insert_batch_new_coupon(new_coupon_list)
return coupon_id_map
def user_no_order():
id_worker = id_handler.IdWorker()
user_list = provider_user.User.select_old_user_no()
new_user_list = []
img_id_list = []
user_id_map = {}
for user_row in user_list:
header_img = user_row[6]
img_id_list.append(header_img)
img_id_map = service_base.Base.user_img(img_id_list)
for user_row in user_list:
user_id = user_row[0]
new_user_id = id_worker.get_id()
user_id_map[user_id] = new_user_id
header_img = user_row[6]
new_header_img = None
if header_img in img_id_map:
new_header_img = img_id_map[header_img]
new_user_list.append((new_user_id, user_row[1].replace('\\', '\\\\').replace('\"', '\\"'), '',
user_row[2], new_header_img, None, user_row[3], user_row[9], user_row[8], user_row[4], user_row[7]))
service_order.Order.user_coupon(user_id_map)
service_order.Order.user_address(user_id_map)
provider_user.User.insert_batch_new_user(new_user_list)
return user_id_map
def user_order(user_id_map, coupon_id_map):
id_worker = id_handler.IdWorker()
order_list = provider_order.Order.select_old_order(str(tuple(user_id_map)))
new_order_list = []
order_id_map = {}
new_delivery_list = []
for order_row in order_list:
new_order_id = id_worker.get_id()
order_id = order_row[0]
order_id_map[order_id] = new_order_id
order_no = order_row[1]
add_time = order_row[2]
cannel_time = order_row[3]
delivery_time = order_row[4]
arrive_time = order_row[5]
remark = order_row[6]
user_mark = order_row[7]
base_price = order_row[8]
pay_price = order_row[9]
freight_price = order_row[10]
server_status = order_row[11]
server_type = order_row[12]
pay_type = order_row[13]
if server_type == 0 or server_type == 1 or server_type == 2:
order_type = 1
else:
order_type = 2
client_status = order_row[14]
user_coupon_mark = order_row[19]
coupon_id = None
if user_coupon_mark in coupon_id_map:
coupon_id = coupon_id_map[user_coupon_mark]
order_source = order_row[20]
pay_time = None
cancel_time = None
if server_status == 0:
cancel_time = cannel_time
else:
pay_time = cannel_time
order_status = None
if server_status == -3:
order_status = 'OT11'
elif server_status == -2:
order_status = 'OT09'
elif server_status == -1:
order_status = 'OT07'
elif server_status == 0 and cannel_time is not None:
order_status = 'OT10'
elif server_status == 0:
order_status = 'OT01'
elif server_status == 1:
order_status = 'OT02'
elif server_status == 2:
order_status = 'OT03'
elif server_status == 3:
order_status = 'OT04'
elif server_status == 4:
order_status = 'OT05'
elif server_status == 5:
order_status = 'OT06'
new_order_list.append((new_order_id, order_no, user_id_map[user_mark], base_price / 100.00,
freight_price / 100.00, (pay_price + freight_price) / 100.00,
add_time, pay_time, cancel_time, delivery_time, None, arrive_time, remark,
order_type, order_status, coupon_id, order_source))
user_address = order_row[15]
user_name = order_row[16]
user_area = order_row[17]
user_phone = order_row[18]
new_delivery_list.append((id_worker.get_id(), new_order_id, user_name, delivery_time, user_phone,
user_address, user_area, remark, 0))
provider_order.Order.insert_new_order(new_order_list)
provider_order.Order.insert_new_delivery(new_delivery_list)
return order_id_map
def user_address(user_id_map):
area_info_list = provider_base.Base.select_area()
area_map = {}
for area in area_info_list:
num = area[0]
name = area[1]
area_map[name] = num
id_worker = id_handler.IdWorker()
address_list = provider_user.User.select_old_address(str(tuple(user_id_map)))
new_address_list = []
for address_row in address_list:
mark_id = address_row[0]
name = address_row[1]
phone = address_row[2]
province = address_row[3].strip()
if province == '重庆':
province = '重庆市'
if province == '广西壮族':
province = '广西壮族自治区'
if province == '新疆':
province = '新疆维吾尔自治区'
if province == '内蒙古':
province = '内蒙古自治区'
if province in area_map:
province = area_map[province]
else :
continue
city = address_row[4].strip()
if city == '重庆':
city = '重庆市'
if city in area_map:
city = area_map[city]
else :
continue
area = address_row[5].strip()
if area == '龙华民治片区':
area = '龙华区'
if area == '宝安中心区':
area = '宝安区'
if area == '布吉':
area = '龙岗区'
if area == '永川区':
area = '永川市'
if area == '郫县':
area = '郫 县'
if area == '梅县':
area = '梅 县'
if area == '城区':
area = '城 区'
if area == '渠县':
area = '渠 县'
if area in area_map:
area = area_map[area]
else:
continue
address = address_row[6]
user_mark = address_row[7]
user_id = None
if user_mark in user_id_map:
user_id = user_id_map[user_mark]
else:
continue
clint_status = address_row[8]
server_status = None
default_or = 0
if clint_status == -1:
server_status = 0
elif clint_status == 0:
server_status = 1
elif clint_status == 1:
default_or = 1
server_status = 1
clint_type = address_row[9]
new_address_list.append((
id_worker.get_id(), name, phone, area, city, province, address, clint_type, user_id,
None, default_or, server_status))
provider_user.User.insert_batch_new_address(new_address_list)
def delete(self, sql, arg):
conn = pymysql.connect(host=str(self.host),
port=3306,
user=str(self.user),
passwd=str(self.passwd),
db=str(self.db),
charset="utf8")
cur = conn.cursor()
try:
cur.execute(sql, arg)
cur.close()
conn.commit()
conn.close()
except Exception as err:
print("MySQL Error :unable to delete data " + err)
if __name__ == "__main__":
id_worker = id_handler.IdWorker()
mysql_operate = MysqlOperate('localhost', 'root', '123456',
't_hands_formal')
# result = mysqloperate.execute_select_all('select * from t_order_info')
# for row in result:
# print(row)
# print(id_worker.get_id('jenho'))
result = mysql_operate.search(
"select * from t_order_info where mark_id='fffe4b2f-d69a-4dc5-b0b9-b63c439dd3b3'"
)
print(result)
