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)