Savane PHP Frontend Developer Reference: mod

00028 {
00029         /*
00030                 The goal here is to show any existing bug filters for this user/group combo.
00031                 In addition, we are going to show an empty row where a new filter can be created
00032         */
00033         $sql="SELECT * FROM bug_filter WHERE user_id='".user_getid()."' AND group_id='$group_id'";
00034         $result=db_query($sql);
00035 
00036         echo '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="2">';
00037 
00038         if ($result && db_numrows($result) > 0) {
00039                 for ($i=0; $i<db_numrows($result); $i++) {
00040                         /*
00041                                 iterate and show the existing filters
00042                         */
00043                         ?>
00044                         <FORM ACTION="<?php echo $PHP_SELF; ?>" METHOD="POST">
00045                         <INPUT TYPE="HIDDEN" NAME="func" VALUE="postmodfilters">
00046                         <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="<?php echo $group_id; ?>">
00047                         <INPUT TYPE="HIDDEN" NAME="subfunc" VALUE="mod">
00048                         <INPUT TYPE="HIDDEN" NAME="filter_id" VALUE="<?php
00049                                 echo db_result($result,$i,"filter_id");
00050                         ?>">
00051                         <TR class="<?php echo utils_get_alt_row_color($i); ?>">
00052                                 <TD>
00053                                         <span class="smaller"><INPUT TYPE="SUBMIT" NAME="delete_filter" VALUE="Delete"><BR>
00054                                         <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Modify/Activate">
00055                                         </span>
00056                                 </TD>
00057                                 <TD NOWRAP><span class="smaller">SELECT * FROM bug WHERE<BR>bug.group_id='<?php echo $group_id; ?>' AND (</span></TD>
00058                                 <TD NOWRAP><span class="smaller"><INPUT TYPE="TEXT" SIZE="60" MAXLENGTH="250" NAME="sql_clause" VALUE="<?php
00059                                                 echo stripslashes(db_result($result,$i,"sql_clause"));
00060                                         ?>"></span></TD>
00061                                 <TD NOWRAP><span class="smaller">) LIMIT 0,50</span></TD>
00062                         </TR></FORM>
00063                         <?php
00064 
00065                 }
00066         }
00067 
00068         /*
00069                 empty form for new filter
00070         */
00071 
00072         ?>
00073         <FORM ACTION="<?php echo $PHP_SELF; ?>" METHOD="POST">
00074         <INPUT TYPE="HIDDEN" NAME="func" VALUE="postmodfilters">
00075         <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="<?php echo $group_id; ?>">
00076         <INPUT TYPE="HIDDEN" NAME="subfunc" VALUE="add">
00077         <TR class="<?php echo utils_get_alt_row_color($i); ?>">
00078                 <TD><span class="smaller"><INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Add"></span></TD>
00079                 <TD NOWRAP><span class="smaller">SELECT * FROM bug WHERE<BR>bug.group_id='<?php echo $group_id; ?>' AND (</span></TD>
00080                 <TD NOWRAP><span class="smaller"><INPUT TYPE="TEXT" SIZE="60" MAXLENGTH="250" NAME="sql_clause" VALUE="bug.status_id IN (1,2,3) OR bug.severity > 0 OR bug.bug_group_id IN (1,2,3,4) OR bug.resolution_id IN (1,2,3) OR bug.assigned_to IN (1,2,3,4,5,6) OR bug.category_id IN (1,2,3)"></span></TD>
00081                 <TD NOWRAP><span class="smaller">) LIMIT 0,50</span></TD>
00082         </TR></FORM>
00083         </TABLE>
00084         <P>
00085         <FORM ACTION="<?php echo $PHP_SELF; ?>" METHOD="POST">
00086         <INPUT TYPE="HIDDEN" NAME="func" VALUE="postmodfilters">
00087         <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="<?php echo $group_id; ?>">
00088         <INPUT TYPE="HIDDEN" NAME="subfunc" VALUE="turn_off">
00089         <INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Deactivate Filters">
00090         </FORM>
00091 <?php
00092 
00093 }


Functions
	show_filters ($group_id)
Variables
	exit
	$sql = "SELECT user.user_id,user.user_name FROM user,user_group WHERE user.user_id=user_group.user_id AND user_group.bug_flags IN (1,2) AND user_group.group_id='$group_id'"
	$result = db_query($sql)
	$result2 = db_query($sql)
	$result3 = db_query($sql)
	$result4 = db_query($sql)
	$result5 = db_query($sql)

mod_filters.php File Reference

Functions

Variables

Function Documentation

Variable Documentation