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 __init__(self, elem):
Master.__init__(self, elem)
self.footnote_id = Master.process_null(elem.find("footnoteId"))
self.footnote_type_id = Master.process_null(elem.find("footnoteType/footnoteTypeId"))
for elem in elem.findall('.//footnoteDescriptionPeriod'):
self.footnote_description_periods.append(FootnoteDescriptionPeriod(elem, self.footnote_type_id, self.footnote_id))
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 __init__(self, elem, sid):
Master.__init__(self, elem)
self.measure_sid = sid
self.excluded_geographical_area = Master.process_null(
elem.find("geographicalArea/geographicalAreaId"))
self.geographical_area_sid = Master.process_null(
elem.find("geographicalArea/sid"))
def get_data(self):
self.sid = Master.process_null(self.elem.find("sid"))
self.critical_state = Master.process_null(
self.elem.find("criticalState"))
self.critical_threshold = Master.process_null(
self.elem.find("criticalThreshold"))
self.initial_volume = Master.process_null(
self.elem.find("initialVolume"))
self.volume = Master.process_null(self.elem.find("volume"))
self.maximum_precision = Master.process_null(
self.elem.find("maximumPrecision"))
self.quota_order_number_id = Master.process_null(
self.elem.find("quotaOrderNumber/quotaOrderNumberId"))
self.quota_order_number_sid = Master.process_null(
self.elem.find("quotaOrderNumber/sid"))
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
self.get_balance_events()
self.get_sample_comm_codes()
change = QuotaDefinitionChange(self.sid, "Quota definition",
self.operation)
g.change_list.append(change)
def get_data(self):
self.measure_sid = Master.process_null_int(self.elem.find("sid"))
self.measure_generating_regulation_id = Master.process_null(
self.elem.find("measureGeneratingRegulationId"))
self.geographical_area_id = Master.process_null(
self.elem.find("geographicalArea/geographicalAreaId"))
self.goods_nomenclature_item_id = Master.process_null(
self.elem.find("goodsNomenclature/goodsNomenclatureItemId"))
self.measure_type_id = Master.process_null(
self.elem.find("measureType/measureTypeId"))
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
self.ordernumber = Master.process_null(self.elem.find("ordernumber"))
self.additional_code_code = Master.process_null(
self.elem.find("additionalCode/additionalCodeCode"))
self.additional_code_type_id = Master.process_null(
self.elem.find(
"additionalCode/additionalCodeType/additionalCodeTypeId"))
self.additional_code = self.additional_code_type_id + self.additional_code_code
self.get_geographical_area_description()
self.get_measure_type_description()
self.get_measure_components()
self.get_measure_conditions()
self.get_measure_excluded_geographical_areas()
self.get_footnotes()
change = MeasureChange(self.measure_sid,
self.goods_nomenclature_item_id, "Measure",
self.operation)
g.change_list.append(change)
def __init__(self, elem, worksheet, row_count):
Master.__init__(self, elem)
self.elem = elem
self.worksheet = worksheet
self.row_count = row_count
self.get_data()
self.write_data()
def __init__(self, elem, sid):
Master.__init__(self, elem)
self.measure_sid = sid
self.footnote_type_id = Master.process_null(
elem.find("footnote/footnoteType/footnoteTypeId"))
self.footnote_id = Master.process_null(
elem.find("footnote/footnoteId"))
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 __init__(self, elem, worksheet, row_count):
Master.__init__(self, elem)
self.elem = elem
self.worksheet = worksheet
self.row_count = row_count
self.descriptions = []
self.description_string = ""
self.get_data()
def __init__(self, elem, footnote_type_id, footnote_id,
footnote_description_period_sid):
Master.__init__(self, elem)
self.footnote_description_period_sid = footnote_description_period_sid
self.footnote_type_id = footnote_type_id
self.footnote_id = footnote_id
self.description = Master.process_null(elem.find("description"))
self.language_id = Master.process_null(
elem.find("language/languageId"))
def __init__(self, elem, worksheet, row_count):
Master.__init__(self, elem)
self.elem = elem
self.worksheet = worksheet
self.row_count = row_count
self.quota_balance_events = []
self.quota_balance_event_string = ""
self.comm_code_string = ""
self.get_data()
def __init__(self, elem, certificate_type_code, certificate_code,
certificate_description_period_sid):
Master.__init__(self, elem)
self.certificate_description_period_sid = certificate_description_period_sid
self.certificate_type_code = certificate_type_code
self.certificate_code = certificate_code
self.description = Master.process_null(elem.find("description"))
self.language_id = Master.process_null(
elem.find("language/languageId"))
def get_data(self):
self.footnote_id = Master.process_null(self.elem.find("footnoteId"))
self.footnote_type_id = Master.process_null(
self.elem.find("footnoteType/footnoteTypeId"))
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
self.get_descriptions()
def __init__(self, elem, additional_code_type_id, additional_code,
additional_code_sid, additional_code_description_period_sid):
Master.__init__(self, elem)
self.additional_code_description_period_sid = additional_code_description_period_sid
self.additional_code_type_id = additional_code_type_id
self.additional_code = additional_code
self.additional_code_sid = additional_code_sid
self.description = Master.process_null(elem.find("description"))
self.language_id = Master.process_null(
elem.find("language/languageId"))
def get_data(self):
self.certificate_code = Master.process_null(
self.elem.find("certificateCode"))
self.certificate_type_code = Master.process_null(
self.elem.find("certificateType/certificateTypeCode"))
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
self.get_descriptions()
def get_data(self):
if self.operation != "D":
self.footnote_id = Master.process_null(
self.elem.find("footnote/footnoteId"))
self.footnote_type_id = Master.process_null(
self.elem.find("footnote/footnoteType/footnoteTypeId"))
else:
self.footnote_id = ""
self.footnote_type_id = ""
self.footnote = self.footnote_type_id + self.footnote_id
def __init__(self, elem):
Master.__init__(self, elem)
self.certificate_code = Master.process_null(
elem.find("certificateCode"))
self.certificate_type_code = Master.process_null(
elem.find("certificateType/certificateTypeCode"))
for elem in elem.findall('.//certificateDescriptionPeriod'):
self.certificate_description_periods.append(
CertificateDescriptionPeriod(elem, self.certificate_type_code,
self.certificate_code))
def __init__(self, elem, goods_nomenclature_item_id,
goods_nomenclature_sid, productline_suffix):
Master.__init__(self, elem)
self.goods_nomenclature_item_id = goods_nomenclature_item_id
self.goods_nomenclature_sid = goods_nomenclature_sid
self.goods_nomenclature_indent_sid = Master.process_null(
elem.find("sid"))
self.productline_suffix = productline_suffix
self.number_indents = Master.process_null(elem.find("numberIndents"))
self.validity_start_date = Master.process_null(
elem.find("validityStartDate"))
def __init__(self, elem, worksheet, row_count):
Master.__init__(self, elem)
self.elem = elem
self.worksheet = worksheet
self.row_count = row_count
self.combined_duty = ""
self.footnote_string = ""
self.descriptions = []
self.duty_expression_array = []
self.measure_condition_array = []
self.get_data()
def __init__(self, elem, goods_nomenclature_item_id,
goods_nomenclature_sid,
goods_nomenclature_description_period_sid,
productline_suffix):
Master.__init__(self, elem)
self.goods_nomenclature_description_period_sid = goods_nomenclature_description_period_sid
self.goods_nomenclature_item_id = goods_nomenclature_item_id
self.goods_nomenclature_sid = goods_nomenclature_sid
self.productline_suffix = productline_suffix
self.description = Master.process_null(elem.find("description"))
self.language_id = Master.process_null(
elem.find("language/languageId"))
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 get_data(self):
self.sid = Master.process_null(self.elem.find("sid"))
self.geographical_area_id = Master.process_null(
self.elem.find("geographicalAreaId"))
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
self.parent_geographical_area_group_sid = Master.process_null(
self.elem.find("parentGeographicalAreaGroupSid"))
self.get_descriptions()
self.get_members()
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 __init__(self, elem, certificate_type_code, certificate_code):
Master.__init__(self, elem)
self.certificate_type_code = certificate_type_code
self.certificate_code = certificate_code
self.certificate_description_period_sid = Master.process_null(
elem.find("sid"))
self.validity_start_date = Master.process_null(
elem.find("validityStartDate"))
for elem in elem.findall('.//certificateDescription'):
self.certificate_descriptions.append(
CertificateDescription(
elem, self.certificate_type_code, self.certificate_code,
self.certificate_description_period_sid))
def __init__(self, elem):
Master.__init__(self, elem)
self.additional_code_sid = Master.process_null(elem.find("sid"))
self.additional_code = Master.process_null(
elem.find("additionalCodeCode"))
self.additional_code_type_id = Master.process_null(
elem.find("additionalCodeType/additionalCodeTypeId"))
for elem in elem.findall('.//additionalCodeDescriptionPeriod'):
self.additional_code_description_periods.append(
AdditionalCodeDescriptionPeriod(elem,
self.additional_code_type_id,
self.additional_code,
self.additional_code_sid))
def __init__(self, elem, footnote_type_id, footnote_id):
Master.__init__(self, elem)
self.footnote_type_id = footnote_type_id
self.footnote_id = footnote_id
self.footnote_description_period_sid = Master.process_null(
elem.find("sid"))
self.validity_start_date = Master.process_null(
elem.find("validityStartDate"))
for elem in elem.findall('.//footnoteDescription'):
self.footnote_descriptions.append(
FootnoteDescription(elem, self.footnote_type_id,
self.footnote_id,
self.footnote_description_period_sid))
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 __init__(self, elem):
Master.__init__(self, elem)
self.goods_nomenclature_sid = Master.process_null(elem.find("sid"))
self.goods_nomenclature_item_id = Master.process_null(
elem.find("goodsNomenclatureItemId"))
self.producline_suffix = Master.process_null(
elem.find("produclineSuffix"))
self.statistical_indicator = Master.process_null(
elem.find("statisticalIndicator"))
self.validity_end_date = Master.process_null(
elem.find("validityEndDate"))
self.validity_start_date = Master.process_null(
elem.find("validityStartDate"))
# Get description periods
for el in elem.findall('.//goodsNomenclatureDescriptionPeriod'):
self.goods_nomenclature_description_periods.append(
GoodsNomenclatureDescriptionPeriod(
el, self.goods_nomenclature_item_id,
self.goods_nomenclature_sid, self.producline_suffix))
# Get indents
for el in elem.findall('.//goodsNomenclatureIndents'):
self.goods_nomenclature_indents.append(
GoodsNomenclatureIndent(el, self.goods_nomenclature_item_id,
self.goods_nomenclature_sid,
self.producline_suffix))
# Get footnote associations
for el in elem.findall('.//footnoteAssociationGoodsNomenclature'):
self.footnote_association_goods_nomenclatures.append(
FootnoteAssociationGoodsNomenclature(
el, self.goods_nomenclature_item_id,
self.goods_nomenclature_sid, self.producline_suffix))
def get_data(self):
self.application_code = Master.process_null(
self.elem.find("applicationCode"))
self.footnote_type_id = Master.process_null(
self.elem.find("footnoteTypeId"))
self.validity_start_date = Master.process_null(
self.elem.find("validityStartDate"))
self.validity_end_date = Master.process_null(
self.elem.find("validityEndDate"))
footnote_type_description = self.elem.find('footnoteTypeDescription')
if footnote_type_description:
self.description = Master.process_null(
footnote_type_description.find("description"))
else:
self.description = ""
