コード例 #1
0
        ///<summary>Should only be called from the PhoneTrackingServer which will be invoking this every ~5 minutes.</summary>
        public static void DeleteAllButMostRecent()
        {
            if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
            {
                Meth.GetVoid(MethodBase.GetCurrentMethod());
                return;
            }
            //Do a two step process for simplicity.  Get the most recent triagemetric row from the table and delete all rows that come after it.
            TriageMetric triageMetric = GetMostRecent();

            if (triageMetric == null || triageMetric.DateTStamp == null || triageMetric.DateTStamp.Year < 1880)
            {
                return;                //Nothing to do.
            }
            //Delete all rows in the table that are older than the most recent triagemetric.
            string command = "DELETE FROM triagemetric WHERE DateTStamp < " + POut.DateT(triageMetric.DateTStamp);

            Db.NonQ(command);
        }
コード例 #2
0
        ///<summary>Get triage metrics to be displayed in phone panels. Will never return null even if there are no triagemetrics in the db.</summary>
        public static TriageMetric GetTriageMetrics()
        {
            if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
            {
                return(Meth.GetObject <TriageMetric>(MethodBase.GetCurrentMethod()));
            }
            TriageMetric triageMetric = TriageMetrics.GetMostRecent();

            //If there is not a row in the table simply pass back 0's and the current time so the stats shown are all 0's.
            if (triageMetric == null)
            {
                triageMetric.CountBlueTasks  = 0;
                triageMetric.CountWhiteTasks = 0;
                triageMetric.CountRedTasks   = 0;
                triageMetric.DateTimeOldestTriageTaskOrTaskNote = DateTime.MinValue;
                triageMetric.DateTimeOldestUrgentTaskOrTaskNote = DateTime.MinValue;
            }
            return(triageMetric);
        }
コード例 #3
0
        ///<summary>Should only be called from the PhoneTrackingServer which will be invoking this every ~1.6 seconds.
        ///Inserts a new entry into the triage metric table that all workstations will start to select from in order to fill local metrics.</summary>
        public static void InsertTriageMetric()
        {
            if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
            {
                Meth.GetVoid(MethodBase.GetCurrentMethod());
                return;
            }
            //The following query was being run by every workstation in the office every 1.6 seconds which was causing slowness issues.
            //The query might need to be improved but for now we are just removing it from the workstations and having the PTS be the only entity running it.
            string    command = @"SELECT 
				COALESCE(SUM(CASE WHEN PriorityDefNum=502 THEN 1 END),0) AS CountBlueTasks,-- triage blue
				COALESCE(SUM(CASE WHEN PriorityDefNum=503 THEN 1 END),0) AS CountWhiteTasks,-- triage white
				COALESCE(SUM(CASE WHEN PriorityDefNum=501 THEN 1 END),0) AS CountRedTasks,-- triage red
				-- time of oldest triage task or the oldest tasknote if one exists
				COALESCE(MIN(CASE WHEN PriorityDefNum=502 THEN (SELECT GREATEST(IFNULL(task.DateTimeEntry,'0001-01-01'), 
					IFNULL((SELECT MAX(DateTimeNote) 
						FROM tasknote WHERE tasknote.tasknum=task.tasknum),'0001-01-01'))) END),'0001-01-01') AS TimeOfOldestBlueTaskNote,
				-- time of oldest urgent task or the oldest tasknote if one exists
				COALESCE(MIN(CASE WHEN PriorityDefNum=501 THEN (SELECT GREATEST(IFNULL(task.DateTimeEntry,'0001-01-01'), 
					IFNULL((SELECT MAX(DateTimeNote) 
						FROM tasknote WHERE tasknote.tasknum=task.tasknum),'0001-01-01'))) END),'0001-01-01') AS TimeOfOldestRedTaskNote
				FROM task 
				WHERE TaskListNum=1697  -- Triage task list
				AND TaskStatus!=2  -- Not done (new or viewed)"                ;
            DataTable table   = Db.GetTable(command);

            if (table == null || table.Rows == null || table.Rows.Count < 1)
            {
                return;
            }
            TriageMetric triageMetric = new TriageMetric()
            {
                CountBlueTasks  = PIn.Int(table.Rows[0]["CountBlueTasks"].ToString()),
                CountWhiteTasks = PIn.Int(table.Rows[0]["CountWhiteTasks"].ToString()),
                CountRedTasks   = PIn.Int(table.Rows[0]["CountRedTasks"].ToString()),
                DateTimeOldestTriageTaskOrTaskNote = PIn.DateT(table.Rows[0]["TimeOfOldestBlueTaskNote"].ToString()),
                DateTimeOldestUrgentTaskOrTaskNote = PIn.DateT(table.Rows[0]["TimeOfOldestRedTaskNote"].ToString()),
            };

            Crud.TriageMetricCrud.Insert(triageMetric);
        }