from datetime import datetime, timedelta
import os
import json
import pprint
dir_path = os.path.dirname(os.path.realpath(__file__))
dir_path = '/var/www/html/orders_details'
OrdersDb = 'OrdersDetails.json'


def JgnDateToUTC(DateString):
    JgnTimeStr = DateString.split("<br/>")[0].replace(' ', '')
    JgnDateDayStr = DateString.split(
        "<br/>")[1].split('-')[0].replace('st', '')
    JgnDateDayStr = JgnDateDayStr.replace('th', '')
    JgnDateDayStr = JgnDateDayStr.replace('rd', '')
    JgnDateDayStr = JgnDateDayStr.replace('nd', '')
    JgnDateStr = DateString.split(
        "<br/>")[1].split('-')[1] + " " + DateString.split("<br/>")[1].split('-')[2]
    return datetime.strptime(JgnDateDayStr + " " + JgnDateStr + " " + JgnTimeStr, '%d %B %Y %I:%M%p') - timedelta(hours=1)


def get_cop_order_details(coupon_client_ids):

    #open db file
    with open(dir_path + "/" + OrdersDb, 'r') as QooxyOrdersDb:
        QooxyOrders = json.loads((QooxyOrdersDb.read()).replace("'", "\'"))

    coupon_client_ids = json.loads(coupon_client_ids)
    print ( coupon_client_ids )
    AllclientsOrders = []
    for coupon_client_id in coupon_client_ids :
        
        FiltredApplidOfferUserData = [x for x in QooxyOrders if  str(x[13]["user_id"]) == coupon_client_id]
        AllclientsOrders = AllclientsOrders + FiltredApplidOfferUserData.copy()

    return AllclientsOrders