def __init__(self, sheet_index, base_name, xl_out_path, app_echo=True, save_per_worker=False):
super(LaborHourDataXLWriter, self).__init__(xl_out_path, app_echo, save_per_worker)
self.base_name = base_name
self.lh_sheet = self.xl_app.Sheets((base_name + config.lh_suffix).decode('utf-8').encode('gbk'))
self.w_sheet = self.xl_app.Sheets((base_name + config.w_suffix).decode('utf-8').encode('gbk'))
self.m_sheet = self.xl_app.Sheets(u'首页'.encode('gbk'))
xl_operator = ExcelOperator(config.XLS_PATH)
self.worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(sheet_index))
self.main_worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(0))
self.write_dates()
def __init__(self, sheet_index, base_name, xl_out_path, app_echo=True, save_per_worker=False):
super(PerformanceXLWriter, self).__init__(xl_out_path, app_echo, save_per_worker)
self.perf_sheet = self.xl_app.Sheets((base_name + config.p_suffix).decode('utf-8').encode('gbk'))
xl_operator = ExcelOperator(config.XLS_PATH)
self.worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(sheet_index))
self.main_worker_dict_x = dict(xl_operator.get_id_name_pairs_with_row_number(0))
worker_dict = xl_operator.get_id_name_pairs(sheet_index)
self.perf_data_provider = PerformanceDataProvider('',
dict(worker_dict),dict(worker_dict),
dict(xl_operator.get_attended_days_count_pairs()),
dict(xl_operator.get_work_performance(
config.p_index_offset + sheet_index
)))