PHP SYSTEM\SQL SYS_SAIMOD_TODO_STATS_COUNT_TODO_USER Examples

Example #1

File: todo_stats_user.php Project: webcraftmedia/system

 public static function stats()
 {
     $res = array();
     $res[0] = \SYSTEM\SQL\SYS_SAIMOD_TODO_STATS_COUNT_TODO_USER::Q1();
     $res[2] = \SYSTEM\SQL\SYS_SAIMOD_TODO_STATS_COUNT_DOTO_USER::Q1();
     $count = floatval($res[2]['count']);
     $all = floatval($res[0]['count'] + $res[2]['count']);
     return $all == 0 ? new \SYSTEM\SAI\todo_stats_data('User ToDos', 1, 1) : new \SYSTEM\SAI\todo_stats_data('User ToDos', $count, $all);
 }

Example #2

File: todo_stats_assign.php Project: webcraftmedia/system

 public static function stats()
 {
     $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_STATS_COUNT_TODO_NOT_ASSIGNED::Q1()['count'];
     $all = \SYSTEM\SQL\SYS_SAIMOD_TODO_STATS_COUNT_TODO_USER::Q1()['count'];
     return new \SYSTEM\SAI\todo_stats_data('Assigned ToDos', $all - $count, $all);
 }