function support_pm_project_load in Support Ticketing System 7

Same name and namespace in other branches

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

Load project from database.

1 call to support_pm_project_load()

support_pm_invoice_ui_form_submit in support_pm/support_pm.module

Add url filter when projects are selected.

File

support_pm/support_pm.module, line 1068

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

Code

function support_pm_project_load($projid) {
  static $projects = array();
  if (!isset($projects[$projid])) {
    $projects[$projid] = db_query('SELECT * FROM {support_project} WHERE projid = :project', array(
      ':project' => $projid,
    ))
      ->fetchObject();
    if (empty($projects[$projid])) {
      return FALSE;
    }
    $projects[$projid]->clids = array();
    $result = db_query('SELECT clid FROM {support_project_client} WHERE projid = :project', array(
      ':project' => $projid,
    ));
    foreach ($result as $client) {
      $projects[$projid]->clids[] = $client->clid;
    }
    drupal_alter('support_pm_project_load', $projects[$projid]);
  }
  return $projects[$projid];
}