import os
import sys
from datetime import datetime, date, timedelta
import time
import pytz
from sqlalchemy import text, exists, and_
from lib.utility import Utility
from lib.db import DB
from lib.models import ConfirmedSaleOrder, RequisitionVsPurchase, PurchaseVsPlannedInbound, \
AvailableQtyVsOutbound, DeliveryManifest, DeliveryReturns, HistoricalQoH
from lib.database import Database
utility = Utility()
database = DB()
wrt_session = database.push_session()
def today_confirmed_order_lines(qry_date=False):
vals = []
d, n = 0, 0
copia_date_order = qry_date or date.today().__str__()
params = (copia_date_order, copia_date_order,)
sql = text("""
select
so.id as so_id,
so.name as so_name,
so.date_order as date_order,
so.date_delivery as date_delivery,
prd.id as product_id,
