<commit_before>#!/usr/bin/python
import os
import sys
import datetime
import dateutil.parser

from people_filter_criteria import ProductCriteria, FunctionalGroupCriteria, IsInternCriteria, IsExpatCriteria, \
    FeatureTeamCriteria, IsCrossFuncCriteria, ManagerCriteria, IsTBHCriteria, LocationCriteria, IsManagerCriteria, \
    IsProductManagerCriteria, ManagerEmptyCriteria

from spreadsheet_parser import SpreadsheetParser


__author__ = 'doreper'

NOT_SET = "!!NOT SET!!"


class PeopleDataKeys:
    def __init__(self):
        pass

    MANAGER = "Manager"
    NAME = "Name"
    NICK_NAME = NAME
    LEVEL = "Level"
    FUNCTION = "Function"
    PROJECT = "Project"
    FEATURE_TEAM = "Feature Team"
    TYPE = "Type"
    REQ = "Requisition Number"
    CONSULTANT = "Consultant"
    CONTRACTOR = "Contractor"
    EXPAT_TYPE = "Expat"
    VENDOR_TYPE = "Vendor"
    INTERN_TYPE = "Intern"
    LOCATION = "Location"
    START_DATE = "Start Date"

    CROSS_FUNCTIONS = ["admin", "inf", "infrastructure"]
    CROSS_FUNCT_TEAM = "Cross"
    FLOORS = {}
    TEAM_MODEL = {}
    PRODUCT_SORT_ORDER = []
    FLOOR_SORT_ORDER = []

class PeopleDataKeysBellevue(PeopleDataKeys):
    def __init__(self):
        PeopleDataKeys.__init__(self)

    CROSS_FUNCTIONS = ["technology", "admin", "inf", "infrastructure", "cross functional"]

class PeopleDataKeysSantaClara(PeopleDataKeys):
    def __init__(self):
        PeopleDataKeys.__init__(self)

    LEVEL = "Title"
    TEAM_MODEL = {
    "UCP" : "1 Tracks @ (1 PO, 1 TA,  4 Dev, 1 QA, 2 Char, 2 Auto)",
    "HID" : "2 Tracks @ (1 PO, 5 Dev, 2 QA, 2 Auto, 1 UX)",
    "HVS" : "Q1:20; Q2:25; Q3:27; Q4:32 -- 1 Tracks @ (1 PO, 5 Dev, 1 QA, 1 Auto)",
    "Evidence Management" : "1 Tracks @ (1 PO, 4 Dev, 1 QA, 1 Auto)",
    "HCmD" : "1 Tracks @ (1 Head Coach, 2 PO, 2 Dev, 1 QA, 1 UX)",

    }


class PeopleDataKeysWaltham(PeopleDataKeys):
    def __init__(self):
        PeopleDataKeys.__init__(self)
    FUNCTION = "Function"
    NAME = "<NAME>"
    NICK_NAME = "Name"
    CROSS_FUNCTIONS = ["Technology", "DevOps", "Admin", "Sustaining" ]
    FLOORS = {
        "- Mobility": [
            "<NAME>",
            "<NAME>",
            "<NAME>",<commit_msg>update people data keys for new fields in content sheet<commit_after>#!/usr/bin/python
import os
import sys
import datetime
import dateutil.parser

from people_filter_criteria import ProductCriteria, FunctionalGroupCriteria, IsInternCriteria, IsExpatCriteria, \
    FeatureTeamCriteria, IsCrossFuncCriteria, ManagerCriteria, IsTBHCriteria, LocationCriteria, IsManagerCriteria, \
    IsProductManagerCriteria, ManagerEmptyCriteria

from spreadsheet_parser import SpreadsheetParser


__author__ = 'doreper'

NOT_SET = "!!NOT SET!!"


class PeopleDataKeys:
    def __init__(self):
        pass

    MANAGER = "Manager"
    NAME = "Name"
    NICK_NAME = NAME
    LEVEL = "Level"
    FUNCTION = "Function"
    PROJECT = "Project"
    FEATURE_TEAM = "Feature Team"
    TYPE = "Type"
    REQ = "Requisition Number"
    CONSULTANT = "Consultant"
    CONTRACTOR = "Contractor"
    EXPAT_TYPE = "Expat"
    VENDOR_TYPE = "Vendor"
    INTERN_TYPE = "Intern"
    LOCATION = "Location"
    START_DATE = "Start Date"

    CROSS_FUNCTIONS = ["admin", "inf", "infrastructure"]
    CROSS_FUNCT_TEAM = "Cross"
    FLOORS = {}
    TEAM_MODEL = {}
    PRODUCT_SORT_ORDER = []
    FLOOR_SORT_ORDER = []

class PeopleDataKeysBellevue(PeopleDataKeys):
    def __init__(self):
        PeopleDataKeys.__init__(self)

    CROSS_FUNCTIONS = ["technology", "admin", "inf", "infrastructure", "cross functional"]

class PeopleDataKeysSantaClara(PeopleDataKeys):
    def __init__(self):
        PeopleDataKeys.__init__(self)

    LEVEL = "Title"
    TEAM_MODEL = {
    "UCP" : "1 Tracks @ (1 PO, 1 TA,  4 Dev, 1 QA, 2 Char, 2 Auto)",
    "HID" : "2 Tracks @ (1 PO, 5 Dev, 2 QA, 2 Auto, 1 UX)",
    "HVS" : "Q1:20; Q2:25; Q3:27; Q4:32 -- 1 Tracks @ (1 PO, 5 Dev, 1 QA, 1 Auto)",
    "Evidence Management" : "1 Tracks @ (1 PO, 4 Dev, 1 QA, 1 Auto)",
    "HCmD" : "1 Tracks @ (1 Head Coach, 2 PO, 2 Dev, 1 QA, 1 UX)",

    }


class PeopleDataKeysSIBU(PeopleDataKeys):
    def __init__(self):
        PeopleDataKeys.__init__(self)
    NAME = "<NAME>"
    NICK_NAME = "Nickname"
    REQ = "Requisition"
    LEVEL = "Title"
    TEAM_MODEL = {
            "HVS" : "[Forecast: Q1:20; Q2:26; Q3:29; Q4:34] -- 1 Tracks @ (1 PO, 5 Dev, 1 QA, 1 Auto)",
            "HVS EM" : "2 Tracks @ (1 PO, 4 Dev, 1 QA, 1 Char, 1 Auto)",
            "Lumada - System" : "[Forecast: Q1:7; Q2:6; Q3:43; Q4:110]",
            "Lumada - Studio" : "[Forecast: Q1:7; Q2:10; Q3:43; Q4:110]",
            "City Data Exchange" : "[Forecast: Q1:6; Q2:19; Q3:6; Q4:6]",
            "Predictive Maintenance" : "[Forecast: Q1:5; Q2:17; Q3:22; Q4:27]",
            "Optimized Factory" : "[Forecast: Q1:1; Q2:6; Q3:13; Q4:15]",
        }

    PRODUCT_SORT_ORDER = ["hvs", "hvs em", "vmp", "hvp", "smart city technology", "technology", "tactical integration",
                          "tactical integrations",  "lumada - system", "sc iiot", "bel iiot", "lumada platform", "pdm", "predictive maintenance",
                          "lumada - studio", "lumada - microservices", "optimized factory", "opf", "city data exchange",
                          "cde", "denver", "lumada - ai", "lumada - analytics", "lumada - di", "lumada - hci", "hci", "lumada - machine intelligence", "lumada", "cross", "lumada cross", "global"]

class PeopleDataKeysWaltham(PeopleDataKeysSIBU):
    def __init__(self):
        PeopleDataKeys.__init__(self)
    FUNCTION = "Function"
    NAME = "<NAME>"
    NICK_NAME = "Name"
    CROSS_FUNCTIONS = ["Technology", "DevOps", "Admin", "Sustaining" ]
    FLOORS = {
        "- Mobility": [
            "<NAME>",
            "<NAME>",
            "<NAME>",
{'fraction_non_alphanumeric': 0.13835828600929273, 'fraction_numerical': 0.027189812424711753, 'mean_word_length': 3.0529986052998606, 'pattern_counts': {'":': 2, '<': 12, '<?xml version=': 0, '>': 12, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1955773', 'n_tokens_mistral': 2165, 'n_tokens_neox': 2017, 'n_words': 528}