231 lines
7.7 KiB
PHP
231 lines
7.7 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, $url, $database, $admin;
|
|
?><h2>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
|
|
$query=$database->database_query("SELECT * FROM bateworldcom_zips.suggestions WHERE id='".$database->database_real_escape_string($_GET["id"])."'");
|
|
$row=$database->database_fetch_array($query);
|
|
|
|
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);
|
|
|
|
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/suggestion.php?id=".$_GET["id"]."
|
|
Category: ".$row1["title"]."
|
|
Title: ".$row["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/suggestion.php?id=".$_GET["id"]);
|
|
}*/
|
|
|
|
|
|
}
|
|
|
|
if($_GET["id"]!="")
|
|
{
|
|
|
|
|
|
|
|
|
|
?>
|
|
<div class="col-sm-2">
|
|
ID: </div><div class="col-sm-6"><?php
|
|
|
|
echo $row["id"];?>
|
|
|
|
|
|
</div><div class="clearfix"></div>
|
|
|
|
<div class="col-sm-2">
|
|
Category: </div><div class="col-sm-6"><?php
|
|
$query1=$database->database_query("SELECT * FROM bateworldcom_zips.suggestion_categories WHERE id='".$row["category"]."' ORDER BY title DESC");
|
|
$row1=$database->database_fetch_array($query1);
|
|
echo $row1["title"];?>
|
|
|
|
|
|
</div><div class="clearfix"></div><div class="col-sm-2">
|
|
Suggestion: </div><div class="col-sm-6"><?php echo $row["suggestion"];?></div><div class="clearfix"></div><div class="col-sm-2">
|
|
More Info: </div><div class="col-sm-6"><?php echo $row["moreinfo"];?></div><div class="clearfix"></div><div class="col-sm-2">
|
|
Status: </div><div class="col-sm-6"><?php if($row["status"]==0){?>Suggestion<?php }?><?php if($row["status"]==1){?>Approved<?php }?><?php if($row["status"]==2){?>In Progress<?php }?><?php if($row["status"]==3){?>Rejected<?php }?><?php if($row["status"]==4){?>Completed<?php }?></div><div class="clearfix"></div>
|
|
|
|
<div class="col-sm-2">
|
|
User: </div><div class="col-sm-6"><?php if($row["admin"]==1){
|
|
|
|
$query2=$database->database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row["admincreator"]."'");
|
|
$row2=$database->database_fetch_array($query2);
|
|
echo $row2["admin_username"];
|
|
|
|
|
|
}else{
|
|
$query2=$database->database_query("SELECT * FROM `se_users` WHERE user_id='".$row["user"]."'");
|
|
$row2=$database->database_fetch_array($query2);
|
|
|
|
?><a href="/profile.php?user=<?php echo $row2["user_username"];?>"><?php echo $row2["user_username"];?></a><?php
|
|
|
|
}?>
|
|
</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))
|
|
{
|
|
$query2=$database->database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row1["adminid"]."'");
|
|
$row2=$database->database_fetch_array($query2);
|
|
|
|
?>
|
|
|
|
<?php echo $row2["admin_username"];?>
|
|
|
|
|
|
<?php
|
|
}?></div>
|
|
|
|
<div class="clearfix"></div>
|
|
|
|
<div class="col-sm-2">
|
|
Urgency: </div><div class="col-sm-6">
|
|
<?php echo $row["urgency"]; ?>
|
|
</div>
|
|
|
|
<div class="clearfix"></div>
|
|
|
|
<div class="col-sm-2"> Steps:
|
|
</div><div class="col-sm-6">
|
|
<div class="steps">
|
|
<?php
|
|
$x=1;
|
|
$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))
|
|
{
|
|
?><?php echo $x." ".$row1["text"];?><br />
|
|
<br />
|
|
<?php $x++;
|
|
}
|
|
|
|
?>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="clearfix"></div>
|
|
|
|
<div class="col-sm-2">
|
|
Waiting on: </div><div class="col-sm-6"><?php
|
|
unset($members);
|
|
|
|
$query2=$database->database_query("SELECT * FROM `se_admins` WHERE admin_id='".$row["waitingon"]."'");
|
|
$row2=$database->database_fetch_array($query2);
|
|
|
|
?>
|
|
|
|
<?php echo $row2["admin_username"];?>
|
|
|
|
|
|
<?php
|
|
|
|
?>
|
|
</div>
|
|
|
|
<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="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>
|
|
|
|
|
|
<?php
|
|
}
|
|
|
|
}
|
|
|
|
|
|
include "admin_footer.php";
|
|
?>
|