def get_data(self):
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
self.hjid_of_member = int(
Master.process_null(self.elem.find("geographicalAreaGroupSid")))
self.get_member_description()
self.tbl = [
"Membership start date",
Master.format_date(self.validity_start_date),
"HJID",
self.hjid_of_member,
]
if self.validity_end_date == "":
self.membership_string = Master.format_date(
self.validity_start_date
) + " : " + self.member_description + "\n"
self.current_membership_string = Master.format_date(
self.validity_start_date
) + " : " + self.member_description + "\n"
else:
self.membership_string = Master.format_date(
self.validity_start_date) + " to " + Master.format_date(
self.validity_end_date
) + " : " + self.member_description + "\n"
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0, self.operation_text + " quota order number", g.excel.format_wrap)
self.worksheet.write(self.row_count, 1, self.quota_order_number_sid, g.excel.format_wrap)
self.worksheet.write(self.row_count, 2, self.quota_order_number_id, g.excel.format_wrap)
self.worksheet.write(self.row_count, 3, Master.format_date(self.validity_start_date), g.excel.format_wrap)
self.worksheet.write(self.row_count, 4, Master.format_date(self.validity_end_date), g.excel.format_wrap)
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0,
self.operation_text + " definition",
g.excel.format_wrap)
self.worksheet.write(self.row_count, 1, self.quota_order_number_id,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 2,
self.quota_balance_event_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 3, self.comm_code_string,
g.excel.format_force_text)
self.worksheet.write(self.row_count, 4, self.sid, g.excel.format_wrap)
self.worksheet.write(self.row_count, 5, self.critical_state,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 6, self.critical_threshold,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 7, self.initial_volume,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 8, self.volume,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 9, self.maximum_precision,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 10,
Master.format_date(self.validity_start_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 11,
Master.format_date(self.validity_end_date),
g.excel.format_wrap)
def get_data(self):
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.description = Master.process_null(
self.elem.find("geographicalAreaDescription/description"))
self.tbl = [
"Description start date",
Master.format_date(self.validity_start_date),
"Description",
self.description,
]
self.description_string = Master.format_date(
self.validity_start_date) + " : " + self.description + "\n"
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0,
self.operation_text + " footnote type",
g.excel.format_wrap)
self.worksheet.write(self.row_count, 1, self.footnote_type_id,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 2, self.application_code,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 3,
Master.format_date(self.validity_start_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 4,
Master.format_date(self.validity_end_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 5, self.description,
g.excel.format_wrap)
def get_data(self):
self.new_balance = Master.process_null(self.elem.find("newBalance"))
self.old_balance = Master.process_null(self.elem.find("oldBalance"))
self.occurrence_timestamp = Master.format_date(
self.elem.find("occurrenceTimestamp").text)
self.quota_balance_event_string = str(
self.occurrence_timestamp) + " - New: " + str(
self.new_balance) + " : " + "Old: " + str(self.old_balance)
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0,
self.operation_text + " certificate",
g.excel.format_wrap)
self.worksheet.write(self.row_count, 1, self.certificate_type_code,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 2, self.certificate_code,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 3,
Master.format_date(self.validity_start_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 4,
Master.format_date(self.validity_end_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 5, self.description_string,
g.excel.format_wrap)
def get_data(self):
if self.operation != "D":
self.validity_start_date = Master.process_null(self.elem.find("validityStartDate"))
self.description = Master.process_null(self.elem.find("goodsNomenclatureDescription/description"))
self.tbl = [
"Description start date", Master.format_date(self.validity_start_date),
"Description", self.description,
]
self.description_string = self.description
else:
self.tbl = None
self.description_string = ""
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0,
self.operation_text + " commodity",
g.excel.format_wrap)
self.worksheet.write(self.row_count, 1,
self.goods_nomenclature_item_id,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 2, self.product_line_suffix,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 3, self.description_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 4,
Master.format_date(self.validity_start_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 5,
Master.format_date(self.validity_end_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 6, self.statistical_indicator,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 7, self.goods_nomenclature_sid,
g.excel.format_wrap)
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0,
self.operation_text + " geographical area",
g.excel.format_wrap)
self.worksheet.write(self.row_count, 1, self.geographical_area_id,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 2, self.sid, g.excel.format_wrap)
self.worksheet.write(self.row_count, 3,
Master.format_date(self.validity_start_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 4,
Master.format_date(self.validity_end_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 5, self.description_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 6, self.current_membership_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 7, self.membership_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 8,
self.parent_geographical_area_group_sid,
g.excel.format_wrap)
def write_data(self):
# Write the Excel
self.worksheet.write(self.row_count, 0,
self.operation_text + " measure",
g.excel.format_wrap)
self.worksheet.write(self.row_count, 1,
self.goods_nomenclature_item_id,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 2, self.additional_code,
g.excel.format_wrap)
self.worksheet.write(
self.row_count, 3,
self.measure_type_id + " (" + self.measure_type_description + ")",
g.excel.format_wrap)
self.worksheet.write(
self.row_count, 4, self.geographical_area_id + " (" +
self.geographical_area_description + ")", g.excel.format_wrap)
self.worksheet.write(self.row_count, 5, self.ordernumber,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 6,
Master.format_date(self.validity_start_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 7,
Master.format_date(self.validity_end_date),
g.excel.format_wrap)
self.worksheet.write(self.row_count, 8, self.combined_duty,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 9, self.exclusion_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 10, self.footnote_string,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 11,
self.measure_condition_string_excel,
g.excel.format_wrap)
self.worksheet.write(self.row_count, 12, self.measure_sid,
g.excel.format_wrap)