コード例 #1
0
 /**
  *	setup - sets up limits and sorts before you call getTasks().
  *
  *	@param	int	The offset - number of rows to skip.
  *	@param	string	The column to sort on.
  *	@param	string	The way to order - ASC or DESC.
  *	@param	int	The max number of rows to return.
  *	@param	string	Whether to set these prefs into the user_prefs table - use "custom".
  *	@param	int	Include this param if you want to limit to a certain assignee.
  *	@param	int	Include this param if you want to limit to a particular status.
  *	@param	array	Array of extra fields & elements to limit the query to.
  */
 function setup($offset, $order_col, $sort, $max_rows, $set, $_assigned_to, $_status, $_extra_fields = array())
 {
     //echo "<br />offset: $offset| order: $order|max_rows: $max_rows|_assigned_to: $_assigned_to|_status: $_status";
     if (!$offset || $offset < 0) {
         $this->offset = 0;
     } else {
         $this->offset = $offset;
     }
     if (session_loggedin()) {
         $u =& session_get_user();
     }
     if (!is_array($_extra_fields)) {
         $_extra_fields = array();
     }
     if (!$set) {
         /*
         	if no set is passed in, see if a preference was set
         	if no preference or not logged in, use open set
         */
         if (session_loggedin()) {
             $default_query = $u->getPreference('art_query' . $this->ArtifactType->getID());
             $this->defaultquery = $default_query;
             if ($default_query) {
                 $aq = new ArtifactQuery($this->ArtifactType, $default_query);
                 $_extra_fields = $aq->getExtraFields();
                 $order_col = $aq->getSortCol();
                 $sort = $aq->getSortOrd();
                 $_assigned_to = $aq->getAssignee();
                 $_status = $aq->getStatus();
                 $this->moddaterange = $aq->getModDateRange();
                 $this->opendaterange = $aq->getOpenDateRange();
                 $this->closedaterange = $aq->getCloseDateRange();
             } else {
                 $custom_pref = $u->getPreference('art_cust' . $this->ArtifactType->getID());
                 if ($custom_pref) {
                     //$_assigned_to.'|'.$_status.'|'.$_order_col.'|'.$_sort_ord.'|'.$_changed.'|'.serialize($_extra_fields);
                     $pref_arr = explode('|', $custom_pref);
                     $_assigned_to = $pref_arr[0];
                     $_status = $pref_arr[1];
                     $order_col = $pref_arr[2];
                     $sort = $pref_arr[3];
                     $_changed = $pref_arr[4];
                     if ($this->ArtifactType->usesCustomStatuses()) {
                         $_extra_fields = unserialize($pref_arr[5]);
                     } else {
                         $_status = $pref_arr[1];
                     }
                     $set = 'custom';
                 } else {
                     //default to open
                     $_assigned_to = 0;
                     $_status = 1;
                     $_changed = 0;
                 }
             }
         } else {
             //default to open
             $_assigned_to = 0;
             $_status = 1;
             $_changed = 0;
         }
     }
     //
     //  validate the column names and sort order passed in from user
     //  before saving it to prefs
     //
     if ($order_col == 'artifact_id' || $order_col == 'summary' || $order_col == 'open_date' || $order_col == 'close_date' || $order_col == 'assigned_to' || $order_col == 'submitted_by' || $order_col == 'priority') {
         $_order_col = $order_col;
         if ($sort == 'ASC' || $sort == 'DESC') {
             $_sort_ord = $sort;
         } else {
             $_sort_ord = 'ASC';
         }
     } else {
         $_order_col = 'artifact_id';
         $_sort_ord = 'ASC';
     }
     if ($set == 'custom') {
         if (session_loggedin()) {
             /*
             	if this custom set is different than the stored one, reset preference
             */
             if (is_array($_assigned_to)) {
                 $_assigned_to = '';
             }
             $aux_extra_fields = array();
             if (is_array($_extra_fields)) {
                 //print_r($_extra_fields);
                 $keys = array_keys($_extra_fields);
                 foreach ($keys as $key) {
                     if ($_extra_fields[$key] != 'Array') {
                         $aux_extra_fields[$key] = $_extra_fields[$key];
                     }
                 }
             }
             $extra_pref = '';
             if (count($aux_extra_fields) > 0) {
                 $extra_pref = '|' . serialize($aux_extra_fields);
             }
             $pref_ = $_assigned_to . '|' . $_status . '|' . $_order_col . '|' . $_sort_ord . '|' . $_changed . $extra_pref;
             if ($pref_ != $u->getPreference('art_cust' . $this->ArtifactType->getID())) {
                 $u->setPreference('art_cust' . $this->ArtifactType->getID(), $pref_);
             }
             $default_query = $u->getPreference('art_query' . $this->ArtifactType->getID());
             if ($default_query) {
                 $u->deletePreference('art_query' . $this->ArtifactType->getID());
             }
         }
         $_changed = 0;
     }
     $this->sort = $_sort_ord;
     $this->order_col = $_order_col;
     $this->status = $_status;
     if ($_assigned_to != 'Array') {
         $this->assigned_to = $_assigned_to;
     }
     $this->extra_fields = $_extra_fields;
     $this->setChangedFrom($_changed);
     // if $max_rows == 0 it means we want all the rows
     if (is_null($max_rows) || $max_rows < 0) {
         $max_rows = 50;
     }
     if (isset($default_query)) {
         $this->max_rows = 0;
     } else {
         $this->max_rows = $max_rows;
     }
 }