<?php

/*

* The landing page that lists all the problem

*/

require_once('functions.php');

if(!loggedin())

header("Location: login.php");

else

include('header.php');

connectdb();

?>

<div class="container">

<?php

if(isset($_GET['share']))

echo("<div class=\"alert alert-info\">\nYour Ride was succesfully added! You can edit it from your profile\n</div>");

else if(isset($_GET['nerror']))

echo("<div class=\"alert alert-error\">\nPlease enter all the details asked before you can continue!\n</div>");

?>

<?php

include('menu.php');

?>

<div class="row-fluid" id="main-content">

<div class="span1"></div>

<div class="span10">

<?php

require_once('functions.php');

connectdb();

$userId = getUserid();

//$userId ="1";

$query = 'SELECT * from notifications WHERE receiver="'.$userId.'" ORDER BY timestamp DESC;';

$result = mysql_query($query) or die("error!!!") ;

?>

<table class="table table-hover">

<thead><tr>

<th>Time</th>

<th>Car Pool Details</th>

<th>Notification Type</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

while($row = mysql_fetch_array($result)){

$type = $row["type"];

echo '<tr>';

echo '<td>'.$row["timestamp"].'</td>';

if($type=="1"){

// Request from sender to apporve his car pool request

$query = 'SELECT * from offers WHERE id="'.$row["cid"].'";';

$result1 = mysql_query($query) or die("error!!");

$carPoolRow = mysql_fetch_array($result1);

echo '<td>'. $carPoolRow["from"] . '=>'. $carPoolRow["to"] . '</td>';

echo '<td>Approve Request</td>';

$status = $row["status"];

$cid = $row["cid"];

$slno = $row["slno"];

$sender=$row["sender"];

if($status=="Approved"){

echo '<td><button class="btn" disabled >Approved</button><td>';

}

else if($status=="Declined"){

echo '<td><button class="btn" disabled >Declined</button></td>';

}

else{

$funcAgrsApp = '"ApproveRequest('.$slno.',1)"';

$funcAgrsDec = '"ApproveRequest('.$slno.',0)"';

echo '<td><button class="btn" onclick='.$funcAgrsApp.'>Approve</button>

<button onclick='.$funcAgrsDec. 'class="btn" >Decline</button></td>';

}

echo '<td></td>';

}

else if($type=="2"){

$query = 'SELECT * from offers WHERE id="'.$row["cid"].'";';

$result1 = mysql_query($query) or die("error!!");

$carPoolRow = mysql_fetch_array($result1);

$slno = $row["slno"];

echo '<td>'. $carPoolRow["from"] . '=>'. $carPoolRow["to"] . '</td>';

$status = $row["status"];

echo '<td>Feedback</td>';

if($status != ""){

echo '<td>'.$status.'/5<td>';

}

else{

?>

<td>

<div class="btn-group">

<button id ="fartDropDown" class="btn dropdown-toggle" data-toggle="dropdown">Rating <span class="caret"></span></button>

<ul class="dropdown-menu">

<li><a href="#">1</a></li>

<li><a href="#">2</a></li>

<li><a href="#">3</a></li>

<li><a href="#">4</a></li>

<li><a href="#">5</a></li>

</ul>

</div><!-- /btn-group -->

<?php

$funcAgrsRate = '"RateRequest('.$slno.')"';

echo '<button class="btn" onclick='.$funcAgrsRate.'>Submit</button> ';

echo '</td>';

}

echo '</tr>';

}

else if($type=="3"){

$query = 'SELECT * from offers WHERE id="'.$row["cid"].'";';

$result1 = mysql_query($query) or die("error!!");

$carPoolRow = mysql_fetch_array($result1);

$status = $row["status"];

$cid = $row["cid"];

$slno = $row["slno"];

$sender=$row["sender"];

echo '<td>'. $carPoolRow["from"] . '=>'. $carPoolRow["to"] . '</td>';

echo '<td>Request Status</td>';

if($status=="Approved"){

echo '<td>Approved, Enjoy the Ride</td>';

}

else if($status=="Declined"){

echo '<td>Declined, :-(</td>';

}

else{

echo 'alert("Some crap piece of shit")';

}

}

else if($type=="4"){

$query = 'SELECT * from offers WHERE id="'.$row["cid"].'";';

$result1 = mysql_query($query) or die("error!!");

$carPoolRow = mysql_fetch_array($result1);

$status = $row["status"];

$cid = $row["cid"];

$slno = $row["slno"];

$sender=$row["sender"];

echo '<td>'. $carPoolRow["from"] . '=>'. $carPoolRow["to"] . '</td>';

echo '<td>Request Status</td>';

echo '<td>Still pending with the rider, Please Come again later</td>';

}

}

?>

</tbody>

</table>

</div>

<div class="span1"></div>

</div>

</div>

<div id="push"></div>

</div> <!-- /wrap -->

<div id="footer">

<div class="container">

<p class="muted credit">Built with love by <a href="about.php">@sushant @ashish @nilesh.</a></p>

</div>

</div>

<!-- javascript files

================================================== -->

<!-- Placed at the end of the document so the pages load faster -->

<script src="http://code.jquery.com/jquery-latest.js"></script>

<script src="js/bootstrap.min.js"></script>

<script>

$(".dropdown-menu li a").click(function(){

var selText = $(this).text();

$('#fartDropDown').html(selText);

});

function RateRequest(slno){

$rating = $('#fartDropDown').html();

$.post("updateDBNotifications.php", { type: "2", serialNo: slno, rating: $rating })

.done(function(data) {

//alert("Data Loaded: " + data);

location.reload();

}); // alert($rating);

}

function ApproveRequest(slno,stat){

if(stat=="0"){

$.post("updateDBNotifications.php", { type: "1", serialNo: slno, stat: "Declined" })

.done(function(data) {

//alert("Data Loaded: " + data);

location.reload();

});

}

else if(stat=="1"){

$.post("updateDBNotifications.php", { type: "1", serialNo: slno, stat: "Approved" })

.done(function(data) {

//alert("Data Loaded: " + data);

location.reload();

});

}

else{

alert("Random error , stat doesnot match");

}

}

$('.dropdown-toggle').dropdown();

</script>

</body></html>

</body>

</html>