Python MOSES.getAuditCountForMonth方法代码示例

# 需要导入模块: import MOSES [as 别名]
# 或者: from MOSES import getAuditCountForMonth [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 getAuditCountForMonth [as 别名]
    def fetchWriterSummary(self, writer_name):
        """
        This method checks the mode.
        """
        keys_list = getReportTypes()
        writer_id = str(list(self.writers_data_frame[self.writers_data_frame["Name"] == writer_name]["Employee ID"])[0])
        writer_email = str(list(self.writers_data_frame[self.writers_data_frame["Name"] == writer_name]["Email ID"])[0])

        writer_summary = dict((key,"-") for key in keys_list)
        writer_summary["Report Date"] = self.start_date
        writer_summary["Writer ID"] = writer_id
        writer_summary["Writer Name"] = writer_name
        writer_summary["Writer Email ID"] = writer_email

        writer_summary["Reporting Manager"] = MOSES.getReportingManager(self.user_id, self.password, query_user=writer_id, query_date=self.end_date)
        
        if "Daily Article Count" in self.mode:
            writer_summary["Daily Article Count"] = MOSES.getArticleCount(self.user_id, self.password, self.start_date, writer_id)
        if ("Daily Efficiency" in self.mode) or ("Daily Stack Rank Index" in self.mode) or ("Daily Efficiency KRA"):
            writer_summary["Daily Efficiency"] = MOSES.getEfficiencyFor(self.user_id, self.password, self.start_date, writer_id, self.category_tree)
            if (type(writer_summary["Daily Efficiency"]) != str) and (not math.isnan(writer_summary["Daily Efficiency"])):
                try:
                    writer_summary["Daily Efficiency KRA"] = self.getEffKRA(writer_summary["Daily Efficiency"])
                except:
                    print writer_summary["Daily Efficiency"]
        if ("Daily Audit Count" in self.mode) or ("Daily CFM" in self.mode) or ("Daily GSEO" in self.mode) or ("Daily Stack Rank Index" in self.mode) or ("Daily CFM KRA") or ("Daily GSEO KRA"):
            writer_summary["Daily Audit Count"] = MOSES.getAuditCount(self.user_id, self.password, self.start_date, writer_id)
            if writer_summary["Daily Audit Count"] > 0:
                if ("Daily CFM" in self.mode) or ("Daily Stack Rank Index" in self.mode) or ("Daily CFM KRA") or ("Daily GSEO" in self.mode) or ("Daily Stack Rank Index" in self.mode) or ("Daily GSEO KRA"):
                    writer_summary["Daily CFM"], writer_summary["Daily GSEO"], fatals = MOSES.getCFMGSEOFor(self.user_id, self.password, self.start_date, writer_id)
                    if type(writer_summary["Daily CFM"]) != str:
                        writer_summary["Daily CFM KRA"] = self.getQKRA(writer_summary["Daily CFM"])
                    if type(writer_summary["Daily GSEO"])!= str:
                        writer_summary["Daily GSEO KRA"] = self.getQKRA(writer_summary["Daily GSEO"])

                if "Daily Stack Rank Index" in self.mode:
                    writer_summary["Daily Stack Rank Index"] = self.getStackRankIndex(writer_summary["Daily Efficiency"], writer_summary["Daily CFM"], writer_summary["Daily GSEO"])        


        if "Average Article Count" in self.mode:
            writer_summary["Average Article Count"] = MOSES.getArticleCountBetween(self.user_id, self.password, self.start_date, self.end_date, writer_id)
        if ("Average Efficiency" in self.mode) or ("Average Stack Rank Index" in self.mode) or ("Average Efficiency KRA" in self.mode):
            writer_summary["Average Efficiency"] = MOSES.getEfficiencyForDateRange(self.user_id, self.password, self.start_date, self.end_date, writer_id, self.category_tree)
            if (type(writer_summary["Average Efficiency"]) != str) and (not math.isnan(writer_summary["Average Efficiency"])):
                try:
                    writer_summary["Average Efficiency KRA"] = self.getEffKRA(writer_summary["Average Efficiency"])
                except:
                    print writer_summary["Average Efficiency"]
        if ("Average Audit Count" in self.mode) or ("Average CFM" in self.mode) or ("Average GSEO" in self.mode) or ("Average Stack Rank Index" in self.mode) or ("Average CFM KRA" in self.mode) or ("Average GSEO KRA" in self.mode):
            writer_summary["Average Audit Count"] = MOSES.getAuditCountBetween(self.user_id, self.password, self.start_date, self.end_date, writer_id)
            if writer_summary["Average Audit Count"] > 0:
                if ("Average CFM" in self.mode) or ("Average Stack Rank Index" in self.mode) or ("Average CFM KRA" in self.mode) or ("Average GSEO" in self.mode) or ("Average Stack Rank Index" in self.mode)  or ("Average GSEO KRA" in self.mode):
                    writer_summary["Average CFM"], writer_summary["Average GSEO"], fatals = MOSES.getCFMGSEOBetweenDates(self.user_id, self.password, self.start_date, self.end_date, writer_id)
                    if type(writer_summary["Average CFM"])!= str:
                        writer_summary["Average CFM KRA"] = MOSES.getQKRA(writer_summary["Average CFM"])
                    if type(writer_summary["Average GSEO"])!= str:
                        writer_summary["Average GSEO KRA"] = MOSES.getQKRA(writer_summary["Average GSEO"])
                if ("Average Stack Rank Index" in self.mode):
                    writer_summary["Average Stack Rank Index"] = self.getStackRankIndex(writer_summary["Average Efficiency"], writer_summary["Average CFM"], writer_summary["Average GSEO"])
        
        if "Weekly Article Count" in self.mode:
            writer_summary["Weekly Article Count"] = MOSES.getArticleCountForWeek(self.user_id, self.password, self.start_date, writer_id)
        if ("Weekly Efficiency" in self.mode) or ("Weekly Stack Rank Index" in self.mode) or ("Weekly Efficiency KRA" in self.mode):
            writer_summary["Weekly Efficiency"] = MOSES.getEfficiencyForWeek(self.user_id, self.password, self.start_date, writer_id, self.category_tree)
            if (type(writer_summary["Weekly Efficiency"]) != str) and (not math.isnan(writer_summary["Weekly Efficiency"])):
                try:
                    writer_summary["Weekly Efficiency KRA"] = self.getEffKRA(writer_summary["Weekly Efficiency"])
                except:
                    print writer_summary["Weekly Efficiency"]
        if ("Weekly Audit Count" in self.mode) or ("Weekly CFM" in self.mode) or ("Weekly GSEO" in self.mode) or ("Weekly Stack Rank Index" in self.mode) or ("Weekly CFM KRA" in self.mode) or ("Weekly GSEO KRA" in self.mode):
            writer_summary["Weekly Audit Count"] = MOSES.getAuditCountForWeek(self.user_id, self.password, self.start_date, writer_id)
            if writer_summary["Weekly Audit Count"] > 0:
                if ("Weekly CFM" in self.mode) or ("Weekly Stack Rank Index" in self.mode) or ("Weekly CFM KRA" in self.mode) or ("Weekly GSEO" in self.mode) or ("Weekly Stack Rank Index" in self.mode) or ("Weekly GSEO KRA" in self.mode):
                    writer_summary["Weekly CFM"], writer_summary["Weekly GSEO"], fatals = MOSES.getCFMGSEOForWeek(self.user_id, self.password, self.start_date, writer_id)
                    if type(writer_summary["Weekly CFM"])!= str:
                        writer_summary["Weekly CFM KRA"] = self.getQKRA(writer_summary["Weekly CFM"])
                    if type(writer_summary["Weekly GSEO"])!= str:
                        writer_summary["Weekly GSEO KRA"] = self.getQKRA(writer_summary["Weekly GSEO"])
                if ("Weekly Stack Rank Index" in self.mode):
                    writer_summary["Weekly Stack Rank Index"] = self.getStackRankIndex(writer_summary["Weekly Efficiency"], writer_summary["Weekly CFM"], writer_summary["Weekly GSEO"])

        if "Monthly Article Count" in self.mode:
            writer_summary["Monthly Article Count"] = MOSES.getArticleCountForMonth(self.user_id, self.password, self.start_date, writer_id)
        if ("Monthly Efficiency" in self.mode) or ("Monthly Stack Rank Index" in self.mode) or ("Monthly Efficiency KRA" in self.mode):
            writer_summary["Monthly Efficiency"] = MOSES.getEfficiencyForMonth(self.user_id, self.password, self.start_date, writer_id, self.category_tree)
            if (type(writer_summary["Monthly Efficiency"]) != str) and (not math.isnan(writer_summary["Monthly Efficiency"])):
                try:
                    writer_summary["Monthly Efficiency KRA"] = self.getEffKRA(writer_summary["Monthly Efficiency"])
                except:
                    print writer_summary["Monthly Efficiency"]
        if ("Monthly Audit Count" in self.mode) or ("Monthly CFM" in self.mode) or ("Monthly GSEO" in self.mode) or ("Monthly Stack Rank Index" in self.mode) or ("Monthly CFM KRA" in self.mode) or ("Monthly GSEO KRA" in self.mode):
            writer_summary["Monthly Audit Count"] = MOSES.getAuditCountForMonth(self.user_id, self.password, self.start_date, writer_id)
            if writer_summary["Monthly Audit Count"] > 0:
                if ("Monthly CFM" in self.mode) or ("Monthly Stack Rank Index" in self.mode) or ("Monthly CFM KRA" in self.mode) or ("Monthly GSEO" in self.mode) or ("Monthly Stack Rank Index" in self.mode) or ("Monthly CFM KRA" in self.mode):
                    writer_summary["Monthly CFM"], writer_summary["Monthly GSEO"], fatals = MOSES.getCFMGSEOForMonth(self.user_id, self.password, self.start_date, writer_id)
                    if type(writer_summary["Monthly CFM"])!= str:
                        writer_summary["Monthly CFM KRA"] = self.getQKRA(writer_summary["Monthly CFM"])
                    if type(writer_summary["Monthly GSEO"])!= str:
                        writer_summary["Monthly GSEO KRA"] = self.getQKRA(writer_summary["Monthly GSEO"])

#.........这里部分代码省略.........