def get_all_info(cls):
all_info = []
query = SQL_SELECT_COMPANY_INFO
answer = Sql.exec(query=query)
for que in answer:
query = SQL_SELECT_INFO_COURIER_IN_COMPANY.format(id=que["id"])
answers = Sql.exec(query=query)
info_company = []
for qu in answers:
query = SQL_SELECT_ORDERS_COURIER.format(id=qu["id"])
qu["orders"] = Sql.exec(query=query)
info_company.append(qu)
all_info.append({"name": que.get("name"), "requisites": que.get('requisites'), "data": info_company})
return all_info
def post_courier_gps(cls, courier_id, lat, lon):
query = SQL_UPDATE_COURIER_GPS.format(id=courier_id, lat=lat, lon=lon)
try:
answer = Sql.exec(query=query)[0]["bool"]
except:
answer = False
return answer
def update_status_orders(cls):
query = SQL_SELECT_ORDER_STATUS
answer = Sql.exec(query=query)
client = sbp_client.SBPClient()
secret = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJNQTQ3MzI3MSIsImp0aSI6IjIwOWI3MjNkLTdmZm' \
'ItNDZhZi05YzU4LWFmZjFiMWI4YzRlNSJ9.lLZtvflKgxHPTmaZbH4cnOw2_1NE_f4LFP7fbVVnOSc'
client.add_secret_key(secret)
client.add_merchant_id('MA0000000279')
print(str(answer))
for ans in answer:
answ = client.get_status(ans["qr_id"])
if "ACWP" in answ:
print(str(answ))
quer = SQL_UPDATE_OREDER_STATUS.format(pays="ACWP",
id=ans["id"])
courier_id = Sql.exec(query=quer)[0]["number_courier"]
quer = SQL_UPDATE_STATUS_COURIER.format(id=courier_id,
status=False)
Sql.exec(query=quer)
def get_courier_orders(cls, courier_id):
query = SQL_SELECT_ORDERS_COURIER.format(id=courier_id)
return Sql.exec(query=query)
def get_couriers_info(cls):
query = SQL_SELECT_INFO_COURIERS
return Sql.exec(query=query)
def get_courier_info(cls, courier_id):
query = SQL_SELECT_INFO_COURIER.format(id=courier_id)
return Sql.exec(query=query)
def create_order(cls, args):
quer = SQL_UPDATE_STATUS_COURIER.format(id=args["number_courier"],
status=True)
Sql.exec(query=quer)
query = SQL_INSERT_ORDER_CREATE.format(**args)
return Sql.exec(query=query)
def get_client_info(cls, client_id):
query = SQL_SELECT_INFO_CLIENT.format(id=client_id)
return Sql.exec(query=query)
def get_clients_info(cls):
query = SQL_SELECT_INFO_CLIENTS
return Sql.exec(query=query)
def get_active_orders(cls):
query = SQL_SELECT_ACTIVE_ORDERS
return Sql.exec(query=query)
def get_gps_couriers(cls):
query = SQL_SELECT_ALL_COURIERS
return Sql.exec(query=query)
from code.sql.sql_query import * from code.base.base_sql import Sql id = 1 query = SQL_SELECT_INFO_CLIENT.format(id=id) answer = Sql.exec(query=query) print(answer)