427 lines
18 KiB
PHP
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";
|
|
?>
|