Python MOSES.getGSEOFor方法代码示例

# 需要导入模块: import MOSES [as 别名]
# 或者: from MOSES import getGSEOFor [as 别名]
 def fetchWriterSummary(self, retry=None):
     if retry is not None:
         print "Retrying to fetch the data. (trial#%d)" %retry
     self.processingStep.emit("Getting article count for %s for %s." % (self.writer_name, self.end_date))
     article_count = MOSES.getArticleCount(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting average article count for %s between %s and %s." % (self.writer_name, self.start_date, self.end_date))
     a_article_count = MOSES.getArticleCountBetween(self.user_id, self.password, self.start_date, self.end_date, self.writer_id)
     self.processingStep.emit("Getting weekly article count for %s for %s." % (self.writer_name, self.end_date))
     w_article_count = MOSES.getArticleCountForWeek(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting monthly article count for %s for %s." % (self.writer_name, self.end_date))
     m_article_count = MOSES.getArticleCountForMonth(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly article count for %s for %s." % (self.writer_name, self.end_date))
     q_article_count = MOSES.getArticleCountForQuarter(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly article count for %s for %s." % (self.writer_name, self.end_date))
     hy_article_count = MOSES.getArticleCountForHalfYear(self.user_id, self.password, self.end_date, self.writer_id)
     
     self.processingStep.emit("Getting efficiency for %s for %s." % (self.writer_name, self.end_date))
     efficiency = MOSES.getEfficiencyFor(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting average efficiency for %s between %s and %s." % (self.writer_name, self.start_date, self.end_date))
     a_efficiency = MOSES.getEfficiencyForDateRange(self.user_id, self.password, self.start_date, self.end_date, self.writer_id)
     self.processingStep.emit("Getting weekly efficiency for %s for %s." % (self.writer_name, self.end_date))
     w_efficiency = MOSES.getEfficiencyForWeek(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting monthly efficiency for %s for %s." % (self.writer_name, self.end_date))
     m_efficiency = MOSES.getEfficiencyForMonth(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly efficiency for %s for %s." % (self.writer_name, self.end_date))
     q_efficiency = MOSES.getEfficiencyForQuarter(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting half-yearly efficiency for %s for %s." % (self.writer_name, self.end_date))
     hy_efficiency = MOSES.getEfficiencyForHalfYear(self.user_id, self.password, self.end_date, self.writer_id)
     
     self.processingStep.emit("Getting audit count for %s for %s." % (self.writer_name, self.end_date))
     audit_count = MOSES.getAuditCount(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting average audit count for %s between %s and %s." % (self.writer_name, self.start_date, self.end_date))
     a_audit_count = MOSES.getAuditCountBetween(self.user_id, self.password, self.start_date, self.end_date, self.writer_id)
     self.processingStep.emit("Getting weekly audit count for %s for %s." % (self.writer_name, self.end_date))
     w_audit_count = MOSES.getAuditCountForWeek(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting monthly audit count for %s for %s." % (self.writer_name, self.end_date))
     m_audit_count = MOSES.getAuditCountForMonth(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly audit count for %s for %s." % (self.writer_name, self.end_date))
     q_audit_count = MOSES.getAuditCountForQuarter(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly audit count for %s for %s." % (self.writer_name, self.end_date))
     hy_audit_count = MOSES.getAuditCountForHalfYear(self.user_id, self.password, self.end_date, self.writer_id)
     
     self.processingStep.emit("Getting CFM for %s for %s." % (self.writer_name, self.end_date))
     cfm = MOSES.getCFMFor(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting average CFM for %s between %s and %s." % (self.writer_name, self.start_date, self.end_date))
     a_cfm = MOSES.getCFMBetweenDates(self.user_id, self.password, self.start_date, self.end_date, self.writer_id)
     self.processingStep.emit("Getting weekly CFM for %s for %s." % (self.writer_name, self.end_date))
     w_cfm = MOSES.getCFMForWeek(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting monthly CFM for %s for %s." % (self.writer_name, self.end_date))
     m_cfm = MOSES.getCFMForMonth(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly CFM for %s for %s." % (self.writer_name, self.end_date))
     q_cfm = MOSES.getCFMForQuarter(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly CFM for %s for %s." % (self.writer_name, self.end_date))
     hy_cfm = MOSES.getCFMForHalfYear(self.user_id, self.password, self.end_date, self.writer_id)
     
     self.processingStep.emit("Getting GSEO for %s for %s." % (self.writer_name, self.end_date))
     gseo = MOSES.getGSEOFor(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting GSEO for %s between %s and %s." % (self.writer_name, self.start_date, self.end_date))
     a_gseo = MOSES.getGSEOBetweenDates(self.user_id, self.password, self.start_date, self.end_date, self.writer_id)
     self.processingStep.emit("Getting weekly GSEO for %s for %s." % (self.writer_name, self.end_date))
     w_gseo = MOSES.getGSEOForWeek(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting average GSEO for %s between %s and %s." % (self.writer_name, self.start_date, self.end_date))
     m_gseo = MOSES.getGSEOForMonth(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting quarterly GSEO for %s for %s." % (self.writer_name, self.end_date))
     q_gseo = MOSES.getGSEOForQuarter(self.user_id, self.password, self.end_date, self.writer_id)
     self.processingStep.emit("Getting half-yearly GSEO for %s for %s." % (self.writer_name, self.end_date))
     hy_gseo = MOSES.getGSEOForHalfYear(self.user_id, self.password, self.end_date, self.writer_id)
     
     self.processingStep.emit("Getting Team Leader Name for %s for %s." % (self.writer_name, self.end_date))
     writer_tl = MOSES.getReportingManager(self.user_id, self.password, query_user=self.writer_id, query_date=self.end_date)["Reporting Manager Name"]
     self.processingStep.emit("Getting Stack Rank Indices for %s for %s." % (self.writer_name, self.end_date))
     stack_rank_index = self.getStackRankIndex(efficiency, cfm, gseo)
     a_stack_rank_index = self.getStackRankIndex(a_efficiency, a_cfm, a_gseo)
     w_stack_rank_index = self.getStackRankIndex(w_efficiency, w_cfm, w_gseo)
     m_stack_rank_index = self.getStackRankIndex(m_efficiency, m_cfm, m_gseo)
     q_stack_rank_index = self.getStackRankIndex(q_efficiency, q_cfm, q_gseo)
     hy_stack_rank_index = self.getStackRankIndex(hy_efficiency, hy_cfm, hy_gseo)
     self.processingStep.emit("Building final writer stats data for %s for %s." % (self.writer_name, self.end_date))
     
     writer_summary = {
         "Report Date": self.end_date,
         "Writer ID": self.writer_id,
         "Writer Name": self.writer_name,
         "Writer Email ID": self.writer_email,
         "Reporting Manager": writer_tl,
         "Article Count": article_count,
         "Weekly Article Count": w_article_count,
         "Monthly Article Count": m_article_count,
         "Quarterly Article Count": q_article_count,
         "Half-Yearly Article Count": hy_article_count,
         "Average Article Count": a_article_count,
         "Efficiency": efficiency,
         "Weekly Efficiency": w_efficiency,
         "Monthly Efficiency": m_efficiency,
         "Quarterly Efficiency": q_efficiency,
         "Half-Yearly Efficiency": hy_efficiency,
         "Average Efficiency": a_efficiency,
         "Audit Count": audit_count,
         "Weekly Audit Count": w_audit_count,
         "Monthly Audit Count": m_audit_count,
#.........这里部分代码省略.........

# 需要导入模块: import MOSES [as 别名]
# 或者: from MOSES import getGSEOFor [as 别名]
def getEfficiencyData(query_date=None):
    #Set the date.
    if query_date is None:
        query_date = datetime.date.today()
    
    user_id, password = MOSES.getbbc()

    #Get a list of dictionaries pertaining to writers' data.
    writers_data_list = MOSES.getWritersList(user_id, password, query_date)

    #get a sorted list of writers' employee IDs.
    writers_ids = [writer["Employee ID"] for writer in writers_data_list]
    writers_ids.sort()

    writer_count = len(writers_ids)

    #For each writer, get the efficiency, work status, cfm and gseo.
    writer_data_frame = pd.DataFrame(columns=["Employee ID","Employee Name","Status","Efficiency","CFM","GSEO","Efficiency Color","CFM Color", "GSEO Color"]                                    )

    #create a pandas dataframe with the following columns:
    #writerid, writer_name, work_status, efficiency, cfm, gseo, stack_rank_index

    red = "#FF3325"
    green = "#43AD38"
    blue = "#027CD5"
    bright_blue = "#027CD5"
    grey = "0.75"
    writer_counter = 0
    for writer in writers_data_list:
        writer_id = writer["Employee ID"]
        writer_name = "%s" %writer["Name"][:writer["Name"].find(" ")]
        status, relaxation, approval = MOSES.checkWorkStatus(user_id, password, query_date, writer_id)
        if status == "Working":
            efficiency = MOSES.getEfficiencyFor(user_id, password, query_date, writer_id)
        else:
            efficiency = 100.00
        cfm = MOSES.getCFMFor(user_id, password, query_date, writer_id)
        gseo = MOSES.getGSEOFor(user_id, password, query_date, writer_id)
        if status == "Working":
            efficiency *= 100.000
            efficiency = np.around(efficiency,3)
            if efficiency < 100.000:
                efficiency_color = red
            elif 100.000 <= efficiency < 105.000:
                efficiency_color = green
            elif 105.000 <= efficiency < 110.000:
                efficiency_color = blue
            else:
                efficiency_color = bright_blue
        else:
            efficiency_color = grey
        #print efficiency, efficiency_color
        if cfm < 95.000:
            cfm_color = red
        elif 95.000 <= cfm < 97.000:
            cfm_color = green
        elif 97.000 <= cfm < 99.000:
            cfm_color = blue
        else:
            cfm_color = bright_blue
        if gseo < 95.000:
            gseo_color = red
        elif 95.000 <= gseo < 97.000:
            gseo_color = green
        elif 97.000 <= gseo < 99.000:
            gseo_color = blue
        else:
            gseo_color = bright_blue
        writer_array = [writer_id, writer_name, status, efficiency, 
                    cfm, gseo, efficiency_color, cfm_color, gseo_color]
        #print writer_array
        writer_data_frame.loc[writer_counter] = writer_array
        writer_counter+=1
    writer_data_frame.sort(["Efficiency","CFM","GSEO"], ascending = [0,0,0], inplace = True)
    return writer_data_frame