U 2j@sdZddlmZdddZdS)z$Mesa table queries scoped by tenant.)conectardcCs>t}|jdd}|d||f|}|||S)NT) dictionarya SELECT chave AS id, nropedido AS mesanro, UPPER(COALESCE(status_mesa, '')) AS status_mesa, produto, preco, quantidade, codigoproduto, classe, id_cliente, COALESCE(lancamento, nrolancamento) AS lancamento, COALESCE(lancamento, nrolancamento) AS nrolancamento, obs_item, dados_item FROM pedido_diarios WHERE origem = 'MESA' AND id_cliente = %s AND UPPER(COALESCE(status_pedido, '')) <> 'ITEM_REMOVIDO' AND UPPER(COALESCE(status_mesa, '')) <> 'RECEBIDO' ORDER BY chave DESC LIMIT %s )rcursorexecutefetchallclose) id_clientelimitconncurrowsr2/var/www/html/LojaOnline/repositories/mesa_repo.pyfetch_mesa_recent_for_clients rN)r)__doc__databaserrrrrrs