def do_get(sess): base_name = [] if 'scenario_id' in request.values: scenario_id = req_int('scenario_id') scenario_props = None else: year = req_int("finish_year") month = req_int("finish_month") months = req_int("months") start_date = Datetime(year, month, 1) - \ relativedelta(months=months - 1) scenario_props = { 'scenario_start': start_date, 'scenario_duration': months} scenario_id = None base_name.append('unified_supplies_monthly_duration') site_id = req_int('site_id') if 'site_id' in request.values else None supply_id = req_int('supply_id') if 'supply_id' in request.values else None user = g.user threading.Thread( target=content, args=( scenario_props, scenario_id, base_name, site_id, supply_id, user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): contract_id = req_int('hhdc_contract_id') days_hidden = req_int('days_hidden') args = (contract_id, days_hidden, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(session): user = g.user date = req_date('date') if 'supply_id' in request.values: supply_id = req_int('supply_id') else: supply_id = None if 'mpan_cores' in request.values: mpan_cores_str = req_str('mpan_cores') mpan_cores = mpan_cores_str.splitlines() if len(mpan_cores) == 0: mpan_cores = None else: for i in range(len(mpan_cores)): mpan_cores[i] = parse_mpan_core(mpan_cores[i]) else: mpan_cores = None running_name, finished_name = chellow.dloads.make_names( 'supplies_snapshot.csv', user) args = (running_name, finished_name, date, supply_id, mpan_cores) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_date = req_date('start') finish_date = req_date('finish') contract_id = req_int('mop_contract_id') args = (start_date, finish_date, contract_id, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_date = req_date('start') finish_date = req_date('finish') site_id = req_int('site_id') if 'site_id' in request.values else None args = (start_date, finish_date, site_id, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_post(sess): start_date = req_date('start') finish_date = req_date('finish') supply_id = req_int('supply_id') if 'supply_id' in request.values else None if 'mpan_cores' in request.values: mpan_cores_str = req_str('mpan_cores') mpan_cores = mpan_cores_str.splitlines() if len(mpan_cores) == 0: mpan_cores = None else: for i in range(len(mpan_cores)): mpan_cores[i] = parse_mpan_core(mpan_cores[i]) else: mpan_cores = None if finish_date < start_date: raise BadRequest("The finish date can't be before the start date.") is_zipped = req_bool('is_zipped') user = g.user threading.Thread( target=content, args=( start_date, finish_date, supply_id, mpan_cores, is_zipped, user) ).start() return chellow_redirect("/downloads", 303)
def do_get(sess): supply_id = req_int('supply_id') start_date = req_date('start') finish_date = req_date('finish') args = supply_id, start_date, finish_date, g.user threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_date = req_hh_date('start') finish_date = req_hh_date('finish') supply_id = req_int('supply_id') if 'supply_id' in request.values else None thread = threading.Thread( target=content, args=(supply_id, start_date, finish_date, g.user)) thread.start() return chellow_redirect("/downloads", 303)
def do_get(sess): end_year = req_int('finish_year') end_month = req_int('finish_month') months = req_int('months') contract_id = req_int('supplier_contract_id') args = (contract_id, end_year, end_month, months, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): year = req_int('end_year') month = req_int('end_month') months = req_int('months') supply_id = req_int('supply_id') if 'supply_id' in request.values else None user = g.user threading.Thread( target=content, args=(year, month, months, supply_id, user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_date = req_date('start') finish_date = req_date('finish') g_contract_id = req_int('g_contract_id') threading.Thread(target=content, args=(start_date, finish_date, g_contract_id, g.user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): supply_id = req_int('supply_id') file_name = 'supply_virtual_bills_' + str(supply_id) + '.csv' start_date = req_date('start') finish_date = req_date('finish') args = (supply_id, file_name, start_date, finish_date, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): g_supply_id = req_int("g_supply_id") file_name = "g_supply_virtual_bill_" + str(g_supply_id) + ".csv" start_date = req_date("start") finish_date = req_date("finish") args = (g_supply_id, file_name, start_date, finish_date, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_date = req_date('start') finish_date = req_date('finish') if 'site_id' in request.values: site_id = req_int('site_id') else: site_id = None args = (sess, start_date, finish_date, site_id, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): if "g_batch_id" in request.values: g_batch_id = req_int("g_batch_id") g_bill_id = None elif "g_bill_id" in request.values: g_bill_id = req_int("g_bill_id") g_batch_id = None else: raise BadRequest("The bill check needs a g_batch_id or g_bill_id.") threading.Thread(target=content, args=(g_batch_id, g_bill_id, g.user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): end_year = req_int("end_year") end_month = req_int("end_month") months = req_int("months") contract_id = req_int('hhdc_contract_id') user = g.user threading.Thread( target=content, args=(contract_id, end_year, end_month, months, user) ).start() return chellow_redirect("/downloads", 303)
def do_get(sess): end_year = req_int("end_year") end_month = req_int("end_month") months = req_int("months") contract_id = req_int('dc_contract_id') user = g.user threading.Thread(target=content, args=(contract_id, end_year, end_month, months, user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): show_ignored = req_bool("show_ignored") report_run = ReportRun.insert( sess, FNAME, g.user, FNAME, {}, ) sess.commit() threading.Thread(target=content, args=(g.user, show_ignored, report_run.id)).start() return chellow_redirect(f"/report_runs/{report_run.id}", 303)
def handle_request(mpan_cores=None): start_date = req_date('start') finish_date = req_date('finish') imp_related = req_bool('imp_related') channel_type = req_str('channel_type') is_zipped = req_bool('is_zipped') supply_id = req_int('supply_id') if 'supply_id' in request.values else None user = g.user threading.Thread(target=content, args=(start_date, finish_date, imp_related, channel_type, is_zipped, supply_id, mpan_cores, user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): if 'batch_id' in request.values: batch_id = req_int("batch_id") bill_id = None elif 'bill_id' in request.values: bill_id = req_int("bill_id") batch_id = None else: raise BadRequest("The bill check needs a batch_id or bill_id.") user = g.user threading.Thread(target=content, args=(batch_id, bill_id, user)).start() return chellow_redirect('/downloads', 303)
def do_get(sess): if 'g_batch_id' in request.values: g_batch_id = req_int('g_batch_id') g_bill_id = None elif 'g_bill_id' in request.values: g_bill_id = req_int('g_bill_id') g_batch_id = None else: raise BadRequest("The bill check needs a g_batch_id or g_bill_id.") threading.Thread( target=content, args=(g_batch_id, g_bill_id, g.user)).start() return chellow_redirect('/downloads', 303)
def handle_request(mpan_cores=None): start_date = req_date('start') finish_date = req_date('finish') imp_related = req_bool('imp_related') channel_type = req_str('channel_type') is_zipped = req_bool('is_zipped') supply_id = req_int('supply_id') if 'supply_id' in request.values else None user = g.user threading.Thread( target=content, args=( start_date, finish_date, imp_related, channel_type, is_zipped, supply_id, mpan_cores, user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): months = req_int('months') finish_year = req_int('finish_year') finish_month = req_int('finish_month') finish_date = Datetime(finish_year, finish_month, 1, tzinfo=pytz.utc) + \ relativedelta(months=1) - HH start_date = finish_date + HH - relativedelta(months=months) typ = req_str('type') site_id = req_int('site_id') args = (start_date, finish_date, site_id, typ, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_post(sess): file_item = request.files["file"] file_path = file_item.filename file_head, file_name = os.path.split(file_path) file_title, file_ext = os.path.splitext(file_name) if file_ext != ".zip": raise BadRequest( f"The file name should have the extension .zip, but in fact it " f"has the extension '{file_ext}'.") f = BytesIO(file_item.read()) f.seek(0) threading.Thread(target=content, args=(f, g.user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): months = req_int('months') finish_year = req_int('finish_year') finish_month = req_int('finish_month') finish_date = Datetime(finish_year, finish_month, 1, tzinfo=pytz.utc) + \ relativedelta(months=1) - HH start_date = finish_date + HH - relativedelta(months=months) typ = req_str('type') site_id = req_int('site_id') args = (start_date, finish_date, site_id, typ, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): months = req_int("months") finish_year = req_int("finish_year") finish_month = req_int("finish_month") month_list = list( c_months_u(finish_year=finish_year, finish_month=finish_month, months=months)) start_date, finish_date = month_list[0][0], month_list[-1][-1] typ = req_str("type") site_id = req_int("site_id") args = (start_date, finish_date, site_id, typ, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): year = req_int("finish_year") month = req_int("finish_month") months = req_int("months") st_id = req_int('site_id') if 'site_id' in request.values else None finish_date = Datetime(year, month, 1, tzinfo=pytz.utc) + \ relativedelta(months=1) - HH start_date = Datetime(year, month, 1, tzinfo=pytz.utc) - \ relativedelta(months=months-1) user = g.user threading.Thread( target=long_process, args=( start_date, finish_date, st_id, months, year, month, user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_year = req_int('start_year') start_month = req_int('start_month') start_day = req_int("start_day") finish_year = req_int('finish_year') finish_month = req_int('finish_month') finish_day = req_int('finish_day') is_import = req_bool('is_import') supply_id = req_int('supply_id') threading.Thread( target=content, args=( start_year, start_month, start_day, finish_year, finish_month, finish_day, is_import, supply_id, g.user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): batch_id = bill_id = contract_id = start_date = finish_date = None if "mpan_cores" in request.values: mpan_cores = req_str("mpan_cores").splitlines() else: mpan_cores = [] fname_additional = "" if "batch_id" in request.values: batch_id = req_int("batch_id") batch = Batch.get_by_id(sess, batch_id) fname_additional = f"_batch_{batch.reference}" elif "bill_id" in request.values: bill_id = req_int("bill_id") bill = Bill.get_by_id(sess, bill_id) fname_additional = "bill_" + str(bill.id) elif "contract_id" in request.values: contract_id = req_int("contract_id") contract = Contract.get_by_id(sess, contract_id) start_date = req_date("start_date") finish_date = req_date("finish_date") s = ["contract", str(contract.id)] for dt in (start_date, finish_date): s.append(hh_format(dt).replace(" ", "T").replace(":", "")) fname_additional = "_".join(s) else: raise BadRequest( "The bill check needs a batch_id, a bill_id or a start_date " "and finish_date.") args = ( batch_id, bill_id, contract_id, start_date, finish_date, g.user, mpan_cores, fname_additional, ) print(args) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): batch_id = bill_id = contract_id = start_date = finish_date = None if 'batch_id' in request.values: batch_id = req_int("batch_id") elif 'bill_id' in request.values: bill_id = req_int("bill_id") elif 'contract_id' in request.values: contract_id = req_int("contract_id") start_date = req_date("start_date") finish_date = req_date("finish_date") else: raise BadRequest( "The bill check needs a batch_id, a bill_id or a start_date " "and finish_date.") args = batch_id, bill_id, contract_id, start_date, finish_date, g.user threading.Thread(target=content, args=args).start() return chellow_redirect('/downloads', 303)
def do_get(sess): start_date = req_date('start', 'day') finish_date = req_date('finish', 'day') finish_date = finish_date + relativedelta(days=1) - HH if 'site_id' in request.values: site_id = req_int('site_id') file_name = "sites_hh_data_" + str(site_id) + "_" + \ finish_date.strftime('%Y%m%d%H%M') + ".csv" else: site_id = None file_name = "supplies_hh_data_" + \ finish_date.strftime('%Y%m%d%H%M') + ".zip" content = none_content if site_id is None else site_content args = (site_id, start_date, finish_date, g.user, file_name) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): start_date = req_date('start', 'day') finish_date = req_date('finish', 'day') finish_date = finish_date + relativedelta(days=1) - HH if 'site_id' in request.values: site_id = req_int('site_id') file_name = "sites_hh_data_" + str(site_id) + "_" + \ finish_date.strftime('%Y%m%d%H%M') + ".csv" else: site_id = None file_name = "supplies_hh_data_" + \ finish_date.strftime('%Y%m%d%H%M') + ".zip" content = none_content if site_id is None else site_content args = (site_id, start_date, finish_date, g.user, file_name) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_post(sess): file_item = request.files["file"] file_path = file_item.filename file_head, file_name = os.path.split(file_path) file_title, file_ext = os.path.splitext(file_name) if not file_ext == '.csv': raise BadRequest( "The file name should have the extension .csv, but in fact it " "has the extension '" + file_ext + "'.") idx = file_title.rfind('_') table = file_title[:idx] version = file_title[idx+1:] f = io.StringIO(str(file_item.read(), 'utf8')) f.seek(0) args = (table, version, f, g.user) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_post(sess): user = g.user file_item = request.files["asset_file"] report_run = ReportRun.insert( sess, FNAME, user, FNAME, { "STATUSES_ACTIVE": STATUSES_ACTIVE, "STATUSES_INACTIVE": STATUSES_INACTIVE, "STATUSES_IGNORE": STATUSES_IGNORE, }, ) sess.commit() args = user, StringIO(file_item.read().decode("utf8")), report_run.id threading.Thread(target=content, args=args).start() return chellow_redirect(f"/report_runs/{report_run.id}", 303)
def do_get(sess): finish_year = req_int("finish_year") finish_month = req_int("finish_month") months = req_int("months") site_id = req_int("site_id") if "site_id" in request.values else None if "g_supply_id" in request.values: g_supply_id = req_int("g_supply_id") else: g_supply_id = None if "compression" in request.values: compression = req_bool("compression") else: compression = True user = g.user args = (site_id, g_supply_id, user, compression, finish_year, finish_month, months) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)
def do_get(sess): year = req_int('year') supply_id = req_int('supply_id') if 'supply_id' in request.values else None user = g.user threading.Thread(target=content, args=(year, supply_id, user)).start() return chellow_redirect("/downloads", 303)
def do_post(sess): base_name = [] now = utc_datetime_now() if "scenario_id" in request.values: scenario_id = req_int("scenario_id") scenario = Scenario.get_by_id(sess, scenario_id) scenario_props = scenario.props base_name.append(scenario.name) start_year = scenario_props["scenario_start_year"] start_month = scenario_props["scenario_start_month"] start_date_ct = ct_datetime(now.year, now.month, 1) if start_year is None: scenario_props["scenario_start_year"] = start_date_ct.year if start_month is None: scenario_props["scenario_start_month"] = start_date_ct.month else: year = req_int("finish_year") month = req_int("finish_month") months = req_int("months") start_date, _ = next( c_months_c(finish_year=year, finish_month=month, months=months)) by_hh = req_bool("by_hh") scenario_props = { "scenario_start_year": start_date.year, "scenario_start_month": start_date.month, "scenario_duration": months, "by_hh": by_hh, } base_name.append("monthly_duration") try: site_id = req_int("site_id") if "site_id" in request.values else None if "site_codes" in request.values: site_codes = req_str("site_codes").splitlines() # Check sites codes are valid for site_code in site_codes: Site.get_by_code(sess, site_code) else: site_codes = [] if "supply_id" in request.values: supply_id = req_int("supply_id") else: supply_id = None if "compression" in request.values: compression = req_bool("compression") else: compression = True user = g.user args = ( scenario_props, base_name, site_id, supply_id, user, compression, site_codes, now, ) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303) except BadRequest as e: flash(e.description) now = Datetime.utcnow() month_start = Datetime(now.year, now.month, 1) - relativedelta(months=1) month_finish = Datetime(now.year, now.month, 1) - HH return make_response( render_template( "ods_monthly_duration.html", month_start=month_start, month_finish=month_finish, ), 400, )
def do_get(sess): year = req_int("year") supply_id = req_int("supply_id") if "supply_id" in request.values else None threading.Thread(target=content, args=(year, supply_id, g.user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): site_id = req_int('site_id') if 'site_id' in request.values else None year = req_int('year') threading.Thread(target=content, args=(year, site_id, g.user)).start() return chellow_redirect("/downloads", 303)
def do_get(sess): args = (g.user, ) threading.Thread(target=content, args=args).start() return chellow_redirect("/downloads", 303)