Beispiel #1
0
(jaelesiaDEPPsales, tekDEPPsales, antwonDEPPsales, jacksonDEPPsales,
 totalDEPPsales) = 0, 0, 0, 0, 0

supervisorIDs = {
    "aervin": 2062007,
    "jnickerson": 2062001,
    "tlevon": 2062007,
    "jacksonn": 2062047,
    "jabram": 2062017,
    "iqr_acollins": 2062072,
    "jmoore": 206223,
    "mayala": 2062002
}

DEPPFileName = homeFolder + 'report.csv'
DEPP_sales_all = get_DEPP_sales(DEPPFileName)

DUPs_removed = []
for DEPP in DEPP_sales_all:
    if DEPP not in DUPs_removed:
        DUPs_removed.append(DEPP)

DEPP_sales_all = DUPs_removed

DEPP_sales = []

for sale in DEPP_sales_all:
    DEPP_sales.append(sale[0])

for id in DEPP_sales:
    if (type(id) == str):
# ------------------------------------------------------------------------------
# ------------------------------------------------------------------------------
# Gather up the DEPP sales from the Products report
# ------------------------------------------------------------------------------
# ------------------------------------------------------------------------------
DEPPFileName = homeFolder + 'report.csv'
# DEPPFile = open(DEPPFileName)
with open(DEPPFileName) as DEPPFile:
    DEPPReader = csv.reader(DEPPFile)
    DEPPData = list(DEPPReader)
    DEPPData = DEPPData[1:]
    print("We made it..************************")

DEPPfilePath = homeFolder + 'report.csv'

DEPP_sales_all = get_DEPP_sales(DEPPfilePath)

# remove any duplicates - there's gotta be a better way to do this!

DUPs_removed = []
for DEPP in DEPP_sales_all:
    if DEPP not in DUPs_removed:
        DUPs_removed.append(DEPP)

DEPP_sales_all = DUPs_removed

DEPP_sales = []

for sale in DEPP_sales_all:
    DEPP_sales.append(sale[0])
Beispiel #3
0
# ------------------------------------------------------------------------------
# Gather up the DEPP sales from the Products report
# ------------------------------------------------------------------------------
# ------------------------------------------------------------------------------
DEPPFileName = homeFolder + 'report.csv'
# DEPPFile = open(DEPPFileName)
with open(DEPPFileName) as DEPPFile:
    DEPPReader = csv.reader(DEPPFile)
    DEPPData = list(DEPPReader)
    DEPPData = DEPPData[1:]
    # print("We made it..************************")

DEPPfilePath = homeFolder + 'report.csv'
missingDEPPfilePath = homeFolder + 'editsOctober.csv'

DEPP_sales = get_DEPP_sales(DEPPfilePath)

missing_DEPPs = get_missing_DEPPs(missingDEPPfilePath)

DEPP_sales_all = [*DEPP_sales, *missing_DEPPs]

print(
    "*************************************************************************"
)
print(
    "*************************************************************************"
)
print(
    "*************************************************************************"
)
# remove any duplicates - there's gotta be a better way to do this!