function support_pm_day_load in Support Ticketing System 7

Same name and namespace in other branches

1. 6 support_pm/support_pm.module \support_pm_day_load()

2 calls to support_pm_day_load()

support_pm_admin_reports in support_pm/support_pm.admin.inc

support_pm_plan_overview_weekly in support_pm/support_pm.module

File

support_pm/support_pm.module, line 977

Support Project Management. @author Jeremy Andrews <jeremy@tag1consulting.com> @package Support

Code

function support_pm_day_load($date = NULL, $user = NULL, $client = NULL) {
  if (is_null($date)) {

    // default to this week
    $date = _support_pm_first_day();
  }
  $query = db_select('support_plan')
    ->fields('support_plan', array(
    'clid',
    'uid',
    'day',
    'hours',
    'comment',
  ))
    ->condition('day', $date)
    ->condition('hours', 0, '>');
  if (is_object($user) && isset($user->uid)) {
    $query
      ->condition('uid', $user->uid);
  }
  if (is_object($client) && isset($client->clid)) {
    $query
      ->condition('clid', $client->clid);
  }
  $day = array();
  $result = $query
    ->execute();
  foreach ($result as $row) {
    $day[$row->uid][$row->clid] = $row;
  }
  return $day;
}