ms-imputedhours-core 0.0.13

No project description provided

MS Jira hours imputed services

This repository is a suite of methods necessary to extract and calculate information about the allocated hours of employees and their work agreements.

Hours agreement

The hours that an employee must do are recorded in a Google Sheet where the hours needed by office are indicated for each day.

How to use the agreements service?

---

In order for us to connect to Google services, we need to register a series of environment variables:

export GOOGLE_SHEET_CREDENTIALS=<SERVICE_ACCOUNT_BASE64_CONTENT>

where we will store in Base64 the content of the JSON of our Google service account that has the credentials to authenticate us.

export GOOGLE_SHEET_AGREEMENTS_SPREADSHEET_ID=<ID_FOR_GOOGLE_SHEET>

It will be the Google sheet ID where the work agreements will be.

Usage example

Getting agreement hours for a month

from ms_imputedhours_core.agreements import Agreement

month = 9
year = 2022
sheet_name = 'Sheet 1'
spreadsheet_id = '111111'

service = Agreements(spreadsheet_id)

service.get_hours_by_month(month, year, sheet_name)

Getting agreement hours by a dates range

from ms_imputedhours_core.agreements import Agreement

spreadsheet_id = '111111'
from_date = datetime.strptime('12/09/2022', '%d/%m/%Y')
to_date = datetime.strptime('17/09/2022', '%d/%m/%Y')
sheet_name = 'SHEET_NAME_TEST'

service = Agreements(spreadsheet_id)

service.get_hours_by_range(from_date, to_date, sheet_name)

Getting all office names

from ms_imputedhours_core.agreements import Agreement

spreadsheet_id = '111111'

service = Agreements(spreadsheet_id)

service..get_all_office_names()