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)
Example #3
0
 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)
Example #4
0
 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)
Example #6
0
 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)
Example #7
0
 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)
Example #8
0
 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)
Example #10
0
 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)