Files
Testing/bwadmin/add_suggestion.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

427 lines
18 KiB
PHP

<?php
$page = "admin_general1";
include "admin_header.php";
if(isset($_GET['task'])) { $task = $_GET['task']; } elseif(isset($_POST['task'])) { $task = $_POST['task']; } else { $task = "main"; }
if(isset($_GET['p'])) { $p = (int) $_GET['p']; } elseif(isset($_POST['p'])) { $p = (int) $_POST['p']; } else { $p = 1; }
if(isset($_GET['forum_id'])) { $forum_id = (int) $_GET['forum_id']; } elseif(isset($_POST['forum_id'])) { $forum_id = (int) $_POST['forum_id']; } else { $forum_id = 23; }
function general()
{ global $user, $admin, $url, $database;
?>
<style>.col-sm-2, .col-sm-6{margin-bottom:15px;}
</style>
<h2>Add Suggestion</h2>
<br />
<br />
<br />
<br />
<script>
loadCSS('/templates/styles_forum.css');
loadCSSbegin('/include/bootstrap/css/bootstrap.css');
loadjsfile('/include/bootstrap/js/bootstrap.js');
</script>
<?php
if($_GET["id"]!="")
{
if(isset($_POST["id"]))
{
$query=$database->database_query("UPDATE bateworldcom_zips.suggestions SET suggestion='".$database->database_real_escape_string($_POST["suggestion"])."', category='".$database->database_real_escape_string($_POST["category"])."', moreinfo='".$database->database_real_escape_string(nl2br($_POST["moreinfo"]))."', status='".$database->database_real_escape_string($_POST["status"])."', urgency='".$database->database_real_escape_string($_POST["urgency"])."', assignedto='".$database->database_real_escape_string($_POST["assignedto"])."', waitingon='".$database->database_real_escape_string($_POST["waitingon"])."' WHERE id='".$database->database_real_escape_string($_POST["id"])."'");
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'");
while($row1=$database->database_fetch_array($query1))
{$steps[]=$row1["text"];}
if($steps!==$_POST["step"]){
$database->database_query("DELETE FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'") or die($database->database_error());
foreach($_POST["step"] as $step)
{
$query=$database->database_query("INSERT INTO bateworldcom_zips.suggestion_steps SET projectid='".$database->database_real_escape_string($_POST["id"])."', text='".$database->database_real_escape_string($step)."'");
}
}
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'");
while($row1=$database->database_fetch_array($query1))
{$members[]=$row1["adminid"];}
if($members!==$_POST["assignedto"]){
$database->database_query("DELETE FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_POST["id"])."'");
foreach($_POST["assignedto"] as $assignedto)
{
$query=$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$database->database_real_escape_string($_POST["id"])."', adminid='".$database->database_real_escape_string($assignedto)."'") or die($database->database_error());
}
}
$query6=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_POST["id"])."'");
$row6=$database->database_fetch_array($query6);
$query7=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row6["category"]."' ORDER BY title DESC");
$row7=$database->database_fetch_array($query7);
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
while($row1=$database->database_fetch_array($query1))
{
$query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='".$database->database_real_escape_string($row1["adminid"])."'");
while($row2=$database->database_fetch_array($query2))
{
mail($row2["admin_email"], "Project ".$_POST["id"]." has been updated", "Project ".$_POST["id"]." has been updated.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$_POST["id"]."
Category: ".$row7["title"]."
Title: ".$row6["suggestion"]);
}
}
echo "Suggestion Updated";
}
if($_POST["comment"]!="")
{
$database->database_query("INSERT INTO bateworldcom_zips.suggestion_admin_comments SET time='".time()."', comment='".$database->database_real_escape_string(nl2br($_POST["comment"]))."', user='".$database->database_real_escape_string($admin->admin_info["admin_id"])."', suggestionid='".$database->database_real_escape_string($_GET["id"])."'") or die($database->database_error());
$query4=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
while($row4=$database->database_fetch_array($query4))
{
$query3=$database->database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$database->database_real_escape_string($row4["adminid"])."'");
$row3=$database->database_fetch_array($query3);
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row["category"]."' ORDER BY title DESC");
$row1=$database->database_fetch_array($query1);
$query6=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_POST["id"])."'");
$row6=$database->database_fetch_array($query6);
$query7=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row6["category"]."' ORDER BY title DESC");
$row7=$database->database_fetch_array($query7);
mail($row3["admin_email"], "New admin comment to a suggestion", "A new comment has been posted to a suggestion you are assigned to.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$_GET["id"]."
Category: ".$row7["title"]."
Title: ".$row6["suggestion"]);
}
/*if($row["assignedto"]!=$row["admincreator"]){
$query3=$database->database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$database->database_real_escape_string($row["assignedto"])."'");
$row3=$database->database_fetch_array($query3);
mail($row3["admin_email"], "New admin comment to a suggestion", "A new comment has been posted to a suggestion you have created.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$_GET["id"]);
}*/
}
$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_GET["id"])."'");
while($row=$database->database_fetch_array($query))
{
?>
<form method="post" action="add_suggestion.php?id=<?php echo $_GET["id"];?>">
<div class="col-sm-2">
Category: </div><div class="col-sm-6"><select name="category"><option></option><?php
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories ORDER BY title DESC");
while($row1=$database->database_fetch_array($query1))
{
?>
<option value="<?php echo $row1["id"];?>" <?php if($row1["id"]==$row["category"]){?>selected="selected"<?php }?>><?php echo $row1["title"];?></option>
<?php
}?></select></div><div class="clearfix"></div><div class="col-sm-2">
Suggestion: </div><div class="col-sm-6"><input type="text" name="suggestion" value="<?php echo $row["suggestion"];?>" /></div><div class="clearfix"></div><div class="col-sm-2">
More Info: </div><div class="col-sm-6"><textarea name="moreinfo" style="width:300px; height:200px;"><?php echo $row["moreinfo"];?></textarea></div><div class="clearfix"></div><div class="col-sm-2">
Status: </div><div class="col-sm-6"><input type="radio" name="status" value="0" <?php if($row["status"]==0){?>checked="checked"<?php }?> /> Suggestion<br />
<input type="radio" name="status" value="5" <?php if($row["status"]==5){?>checked="checked"<?php }?> /> In Review<br />
<input type="radio" name="status" value="1" <?php if($row["status"]==1){?>checked="checked"<?php }?> /> Approved<br />
<input type="radio" name="status" value="2" <?php if($row["status"]==2){?>checked="checked"<?php }?> /> In Progress<br />
<input type="radio" name="status" value="3" <?php if($row["status"]==3){?>checked="checked"<?php }?> /> Rejected<br />
<input type="radio" name="status" value="4" <?php if($row["status"]==4){?>checked="checked"<?php }?> /> Completed</div><div class="clearfix"></div>
<div class="col-sm-2">
Involves: </div><div class="col-sm-6"><?php
unset($members);
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($_GET["id"])."'");
while($row1=$database->database_fetch_array($query1))
{$members[]=$row1["adminid"];}
$query1=$database->database_query("SELECT * FROM `se_admins`");
while($row1=$database->database_fetch_array($query1))
{
?>
<div><input type="checkbox" value="<?php echo $row1["admin_id"];?>" <?php if(in_array($row1["admin_id"], $members)){?>checked="checked"<?php }?> name="assignedto[]"><?php echo $row1["admin_username"];?></option></div>
<?php
}?></div>
<div class="clearfix"></div>
<div class="col-sm-2">
Urgency: </div><div class="col-sm-6">
<select name="urgency">
<option value="1" <?php if($row["urgency"]==1){?>selected="selected"<?php }?>>1 - Not very</option>
<option value="2" <?php if($row["urgency"]==2){?>selected="selected"<?php }?>>2</option>
<option value="3" <?php if($row["urgency"]==3){?>selected="selected"<?php }?>>3</option>
<option value="4" <?php if($row["urgency"]==4){?>selected="selected"<?php }?>>4</option>
<option value="5" <?php if($row["urgency"]==5){?>selected="selected"<?php }?>>5 - Urgent</option>
</select></div>
<div class="clearfix"></div>
<div class="col-sm-2"> Steps:
</div><div class="col-sm-6">
<div class="steps">
<?php
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_steps WHERE projectid='".$database->database_real_escape_string($_GET["id"])."' ORDER BY id ASC") or die($database->database_error());
while($row1=$database->database_fetch_array($query1))
{
?><textarea name="step[]" style="width:300px; height:200px;"><?php echo $row1["text"];?></textarea><br />
<br />
<?php
}
?>
</div>
<a href="javascript:void(0);" class="addstep">Add Step</a>
</div>
<div class="clearfix"></div>
<div class="col-sm-2">
Waiting on: </div><div class="col-sm-6"><?php
unset($members);
?>
<select name="waitingon"><option></option>
<?php
$query1=$database->database_query("SELECT * FROM `se_admins`");
while($row1=$database->database_fetch_array($query1))
{
?>
<div><option value="<?php echo $row1["admin_id"];?>" <?php if($row1["admin_id"]==$row["waitingon"]){?>selected="selected"<?php }?>><?php echo $row1["admin_username"];?></option></div>
<?php
}?></select></div>
<div class="clearfix"></div>
<div class="col-sm-6">
<input type="hidden" value="<?php echo $row["id"];?>" name="id" />
<input type="submit" value="Submit" />
</div>
</form>
<div class="clearfix"></div>
<div class="col-sm-12">
<br />
<br />
<div class="col-sm-12">
<ul class="nav nav-tabs">
<li><a href="/suggestion.php?id=<?php echo $_GET["id"];?>" class="jquerycss">Comments</a></li>
<li class="active"><a data-toggle="tab" href="#menu1" class="jquerycss">Admin Comments</a></li>
</ul>
<div class="tab-content">
<div id="menu1" class="tab-pane fade tabpadding active in">
<div class="col-sm-8"><strong>Comment</strong></div>
<div class="col-sm-2"><strong>User</strong></div>
<div class="col-sm-2"><strong>Time</strong></div>
<div class="clearfix"></div>
<?php
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_admin_comments WHERE suggestionid='".$database->database_real_escape_string($_GET["id"])."' ORDER BY id ASC");
while($row1=$database->database_fetch_array($query1))
{?>
<div class="col-sm-8"><?php echo $row1["comment"];?><br />
<br />
</div>
<div class="col-sm-2"><?php
$query2=$database->database_query("SELECT * FROM bateworldcom.se_admins WHERE admin_id='".$row1["user"]."'");
$row2=$database->database_fetch_array($query2);
echo $row2["admin_username"];
?></div>
<div class="col-sm-2"><?php echo date("F j, Y g:i A",$row1["time"]);?></div>
<div class="clearfix"></div>
<hr />
<?php }?>
<form action="add_suggestion.php?id=<?php echo $_GET["id"];?>" method="post">
Submit comment:<br />
<textarea name="comment" style="width:350px; height:200px;"></textarea><br />
<input type="submit" value="Submit Comment" />
</form>
</div>
</div>
</div>
</div>
<?php
}
}
else{
if(isset($_POST["category"]))
{
$query=$database->database_query("INSERT INTO bateworldcom_zips.suggestions SET date='".time()."', suggestion='".$database->database_real_escape_string($_POST["suggestion"])."', admin='1', category='".$database->database_real_escape_string($_POST["category"])."', moreinfo='".$database->database_real_escape_string(nl2br($_POST["moreinfo"]))."', status='".$database->database_real_escape_string($_POST["status"])."', urgency='".$database->database_real_escape_string($_POST["urgency"])."', admincreator='".$admin->admin_info["admin_id"]."'");
$projectid=$database->database_insert_id();
foreach($_POST["step"] as $step)
{
$query=$database->database_query("INSERT INTO bateworldcom_zips.suggestion_steps SET projectid='".$projectid."', text='".$database->database_real_escape_string($step)."'");
}
foreach($_POST["assignedto"] as $assignedto)
{
$query=$database->database_query("INSERT INTO bateworldcom_zips.suggestions_members SET projectid='".$projectid."', adminid='".$database->database_real_escape_string($assignedto)."'") or die($database->database_error());
}
$query6=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($projectid)."'");
$row6=$database->database_fetch_array($query6);
$query7=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row6["category"]."' ORDER BY title DESC");
$row7=$database->database_fetch_array($query7);
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions_members WHERE projectid='".$database->database_real_escape_string($projectid)."'");
while($row1=$database->database_fetch_array($query1))
{
$query2=$database->database_query("SELECT * FROM se_admins WHERE admin_id='".$database->database_real_escape_string($row1["adminid"])."'");
while($row2=$database->database_fetch_array($query2))
{
mail($row2["admin_email"], "Project ".$_POST["id"]." has been added", "Project ".$_POST["id"]." has been updated.
https://bateworld.com/bwadmin/add_suggestion.php?id=".$_POST["id"]."
Category: ".$row7["title"]."
Title: ".$row6["suggestion"]);
}
}
echo "Suggestion added";
}
?>
<form method="post" action="add_suggestion.php?id=<?php echo $_GET["id"];?>">
<div class="col-sm-2">
Category: </div><div class="col-sm-6"><select name="category"><option></option><?php
$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories ORDER BY title DESC");
while($row=$database->database_fetch_array($query))
{
?>
<option value="<?php echo $row["id"];?>"><?php echo $row["title"];?></option>
<?php
}?></select></div><div class="clearfix"></div><div class="col-sm-2">
Suggestion: </div><div class="col-sm-6"><input type="text" name="suggestion" value="<?php echo $row["suggestion"];?>" /></div><div class="clearfix"></div><div class="col-sm-2">
More Info: </div><div class="col-sm-6"><textarea name="moreinfo" style="width:300px; height:200px;"><?php echo $row["moreinfo"];?></textarea></div><div class="clearfix"></div><div class="col-sm-2">
Status: </div><div class="col-sm-6"><input type="radio" name="status" value="0" /> Suggestion<br />
<input type="radio" name="status" value="5" <?php if($row["status"]==5){?>checked="checked"<?php }?> /> In Review<br />
<input type="radio" name="status" value="1" <?php if($row["status"]==1){?>checked="checked"<?php }?> /> Approved<br />
<input type="radio" name="status" value="2" /> In Progress<br />
<input type="radio" name="status" value="3" /> Rejected<br />
<input type="radio" name="status" value="4" /> Completed</div><div class="clearfix"></div>
<div class="col-sm-2">
Involves: </div><div class="col-sm-6"><?php
$query1=$database->database_query("SELECT * FROM `se_admins`");
while($row1=$database->database_fetch_array($query1))
{
?>
<div><input type="checkbox" value="<?php echo $row1["admin_id"];?>" <?php if($row["assignedto"]==$row1["admin_id"]||$row1["admin_id"]==$admin->admin_info["admin_id"]){?>checked="checked"<?php }?> name="assignedto[]"><?php echo $row1["admin_username"];?></option></div>
<?php
}?></div>
<div class="clearfix"></div>
<div class="col-sm-2">
Urgency: </div><div class="col-sm-6">
<select name="urgency">
<option value="1">1 - Not very</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5 - Urgent</option>
</select></div>
<div class="clearfix"></div>
<div class="col-sm-2"> Steps:
</div><div class="col-sm-6">
<div class="steps"></div>
<a href="javascript:void(0);" class="addstep">Add Step</a>
</div>
<div class="clearfix"></div>
<div class="col-sm-6">
<input type="submit" value="Submit" />
</div>
</form>
<?php
}?>
<script>
jQuery(".addstep").click(function(){
jQuery(".steps").append('<textarea name="step[]" style="width:300px; height:200px;"></textarea><br/><br />');
});
</script>
<?php
}
include "admin_footer.php";
?>