getErrorMessage(),'tracker'); } $query_name = trim(getStringFromRequest('query_name')); $query_type = getStringFromRequest('query_type',0); $_status = getStringFromRequest('_status'); $_submitted_by = getStringFromRequest('_submitted_by'); $_assigned_to = getStringFromRequest('_assigned_to'); $_last_modified_by = getStringFromRequest('_last_modified_by'); $_sort_col = getStringFromRequest('_sort_col'); $_sort_ord = getStringFromRequest('_sort_ord'); $extra_fields = getStringFromRequest('extra_fields'); $_moddaterange = getStringFromRequest('_moddaterange'); $_opendaterange = getStringFromRequest('_opendaterange'); $_closedaterange = getStringFromRequest('_closedaterange'); $_summary = getStringFromRequest('_summary'); $_description = getStringFromRequest('_description'); $_followups = getStringFromRequest('_followups'); $query_options = array_keys(getArrayFromRequest('query_options')); if (!$aq->create($query_name,$_status,$_assigned_to,$_moddaterange,$_sort_col,$_sort_ord,$extra_fields,$_opendaterange,$_closedaterange, $_summary,$_description,$_followups,$query_type, $query_options, $_submitted_by, $_last_modified_by)) { form_release_key(getStringFromRequest('form_key')); exit_error($aq->getErrorMessage(),'tracker'); } else { $feedback .= _('Query Successfully Created'); } $aq->makeDefault(); $query_id=$aq->getID(); session_redirect('/tracker/?atid='.$atid.'&group_id='.$group_id.'&func=browse'); // /* // Make the displayed query the default // } elseif ($query_action == 2) { $aq = new ArtifactQuery($ath,$query_id); if (!$aq || !is_object($aq)) { exit_error('Error',$aq->getErrorMessage()); } if (!$aq->makeDefault()) { $feedback .= $aq->getErrorMessage(); } else { $feedback .= 'Query Made Default'; } */ // // Update the name and or fields of the displayed saved query // } elseif ($query_action == 3) { if (!form_key_is_valid(getStringFromRequest('form_key'))) { exit_form_double_submit('tracker'); } $aq = new ArtifactQuery($ath,$query_id); if (!$aq || !is_object($aq)) { exit_error($aq->getErrorMessage(),'tracker'); } $query_name = getStringFromRequest('query_name'); $query_type = getStringFromRequest('query_type',0); $_status = getStringFromRequest('_status'); $_submitted_by = getStringFromRequest('_submitted_by'); $_assigned_to = getStringFromRequest('_assigned_to'); $_last_modified_by = getStringFromRequest('_last_modified_by'); $_sort_col = getStringFromRequest('_sort_col'); $_sort_ord = getStringFromRequest('_sort_ord'); $_moddaterange = getStringFromRequest('_moddaterange'); $_opendaterange = getStringFromRequest('_opendaterange'); $_closedaterange = getStringFromRequest('_closedaterange'); $_summary = getStringFromRequest('_summary'); $_description = getStringFromRequest('_description'); $_followups = getStringFromRequest('_followups'); $extra_fields = getStringFromRequest('extra_fields'); $query_options = array_keys(getArrayFromRequest('query_options')); if (!$aq->update($query_name,$_status,$_assigned_to,$_moddaterange,$_sort_col,$_sort_ord,$extra_fields,$_opendaterange,$_closedaterange, $_summary,$_description,$_followups,$query_type, $query_options, $_submitted_by,$_last_modified_by)) { exit_error($aq->getErrorMessage(),'tracker'); } else { $feedback .= _('Query Updated'); } $aq->makeDefault(); $query_id=$aq->getID(); session_redirect('/tracker/?atid='.$atid.'&group_id='.$group_id.'&func=browse'); // // Just load the query // } elseif ($query_action == 4) { $aq = new ArtifactQuery($ath,$query_id); if (!$aq || !is_object($aq)) { exit_error($aq->getErrorMessage(),'tracker'); } $aq->makeDefault(); // // Delete the query // } elseif ($query_action == 5) { if (!form_key_is_valid(getStringFromRequest('form_key'))) { exit_form_double_submit('tracker'); } $aq = new ArtifactQuery($ath,$query_id); if (!$aq || !is_object($aq)) { exit_error($aq->getErrorMessage(),'tracker'); } if (!$aq->delete()) { $error_msg .= $aq->getErrorMessage(); } else { $feedback .= _('Query Deleted'); } session_redirect('/tracker/?atid='.$atid.'&group_id='.$group_id.'&func=browse'); } else { exit_error(_('Missing Build Query Action'),'tracker'); } } else { $user=session_get_user(); $query_id=$user->getPreference('art_query'.$ath->getID()); $aq = new ArtifactQuery($ath,$query_id); if (!$aq || !is_object($aq)) { exit_error($aq->getErrorMessage(),'tracker'); } $aq->makeDefault(); } // // setup the query // $_submitted_by=$aq->getSubmitter(); $_assigned_to=$aq->getAssignee(); $_last_modified_by=$aq->getLastModifier(); $_status=$aq->getStatus(); $extra_fields=$aq->getExtraFields(); $_sort_col=$aq->getSortCol(); $_sort_ord=$aq->getSortOrd(); $_moddaterange=$aq->getModDateRange(); $_opendaterange=$aq->getOpenDateRange(); $_closedaterange=$aq->getCloseDateRange(); $_summary=$aq->getSummary(); $_description=$aq->getDescription(); $_followups=$aq->getFollowups(); $query_type=$aq->getQueryType(); // // creating a submitter box $submitter_box = $ath->submitterBox('_submitted_by[]',$_submitted_by,true,'none','-1',false,true); // creating a custom technician box which includes "any" and "unassigned" $tech_box = $ath->technicianBox('_assigned_to[]',$_assigned_to,true,'none','-1',false,true); // creating a last modifier box $last_modifier_box = $ath->lastModifierBox('_last_modified_by[]',$_last_modified_by,true,'none','-1',false,true); // // custom order by arrays to build a pop-up box // $order_name_arr=array(); $order_name_arr[]=_('Id'); $order_name_arr[]=_('Priority'); $order_name_arr[]=_('Summary'); $order_name_arr[]=_('Open Date'); $order_name_arr[]=_('Last Modified Date'); $order_name_arr[]=_('Close Date'); $order_name_arr[]=_('Submitter'); $order_name_arr[]=_('Assignee'); $order_name_arr[]=_('Last Modifier'); $order_arr=array(); $order_arr[]='artifact_id'; $order_arr[]='priority'; $order_arr[]='summary'; $order_arr[]='open_date'; $order_arr[]='last_modified_date'; $order_arr[]='close_date'; $order_arr[]='submitted_by'; $order_arr[]='assigned_to'; $order_arr[]='last_modified_by'; // // custom sort arrays to build pop-up box // $sort_name_arr=array(); $sort_name_arr[]=_('Ascending'); $sort_name_arr[]=_('Descending'); $sort_arr=array(); $sort_arr[]='ASC'; $sort_arr[]='DESC'; // // custom changed arrays to build pop-up box // $changed_name_arr=array(); $changed_name_arr[]=_('Any changes'); $changed_name_arr[]=_('Last 24 h'); $changed_name_arr[]=_('Last 7 days'); $changed_name_arr[]=_('Last 2 weeks'); $changed_name_arr[]=_('Last month'); $changed_arr=array(); $changed_arr[]= 0; $changed_arr[]= 3600 * 24; // 24 hour $changed_arr[]= 3600 * 24 * 7; // 1 week $changed_arr[]= 3600 * 24 * 14;// 2 week $changed_arr[]= 3600 * 24 * 30;// 1 month // // get queries for this user // $res = db_query_params('SELECT artifact_query_id,query_name FROM artifact_query WHERE user_id=$1 AND group_artifact_id=$2', array(user_getid(), $ath->getID())); // Show the new pop-up boxes to select assigned to, status, etc // $ath->header(array('atid'=>$ath->getID(), 'title' =>_('Build Query'), 'modal' => 1)); echo '
' . ' | |
'.
' '._('Summary')._(': ').' '.$tips.' '._('Detailed description')._(': ').' '.$tips.' '._('Comments')._(': ').' '.$tips.' |
|
'._('Order by')._(': ').' '. html_build_select_box_from_arrays($order_arr,$order_name_arr,'_sort_col',$_sort_col,false) .' |
'.html_build_select_box_from_arrays($sort_arr,$sort_name_arr,'_sort_ord',$_sort_ord,false) .' |
'.
' '._('Options')._(':').' |