<?php
session_start();
/*
Plugin Name: manoj_create_menu
Plugin URI: http://mcamady.blogspot.com/#
Description: created by Manoj Agarwal.
Author: Manu Agarwal
*/
add_action('admin_menu', 'manoj_create_menu');
function manoj_create_menu() {
//create new top-level menu
add_menu_page('Payment History', 'Payment History', 'administrator', __FILE__, 'baw_settings_page',plugins_url('/images/icon.png', __FILE__));
//call register settings function
add_action( 'admin_init', 'register_mysettings' );
}
function register_mysettings() {
//register our settings
register_setting( 'manoj-settings-group', 'new_option_name' );
register_setting( 'manoj-settings-group', 'some_other_option' );
register_setting( 'manoj-settings-group', 'option_etc' );
}
function username($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_name'];
}
function usermail($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_email'];
}
function baw_settings_page() {
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js">
</script>
<script src="jquery.tablePagination.0.5.js">
</script>
<script type="text/javascript">
$(document).ready(function() {
$('table').tablePagination({});
});
</script>
<style>
td {
border: 1px solid black;
}
#testTable {
width : 350px;
margin-left: auto;
margin-right: auto;
}
#tablePagination {
background-color: #DCDCDC;
font-size: 0.8em;
padding: 0px 5px;
height: 20px
}
#tablePagination_paginater {
margin-left: auto;
margin-right: auto;
}
#tablePagination img {
padding: 0px 2px;
}
#tablePagination_perPage {
float: left;
}
#tablePagination_paginater {
float: right;
}
</style>
<script>
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","deletetag.php?q="+str,true);
xmlhttp.send();
}
</script>
<div class="wrap">
<br/><br/><br/>
<h2>Payment History</h2>
<p> </p>
<script>
function showHint(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","gethint.php?q="+str,true);
xmlhttp.send();
}
</script>
<p><strong>Enter the txn reference no.</strong></td><td><input type="text" name="search" onkeyup="showHint(this.value)" /></p>
<br/><br/>
<span id="txtHint">
<?php $result = mysql_query("SELECT * FROM payments ");
echo "<table width='100%' border='1' cellspacing='0' cellpadding='2' id='menuTable'>";
echo "<thead>
<tr>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Ref.</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Amount</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Date</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Name</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Email</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Status</th>
</tr></thead>";
// loop through results of database query, displaying them in the table
while($row=mysql_fetch_array($result))
{
// echo out the contents of each row into a table
echo "<tr>";
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['txnid'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">$'.$row['payment_amount']. '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">'.$row['createdtime'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' .username($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . usermail($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['payment_status'] . '</td>';
echo "</tr>";
// close table>
}
echo "</table>";
}
?>
</span>
</div>
session_start();
/*
Plugin Name: manoj_create_menu
Plugin URI: http://mcamady.blogspot.com/#
Description: created by Manoj Agarwal.
Author: Manu Agarwal
*/
add_action('admin_menu', 'manoj_create_menu');
function manoj_create_menu() {
//create new top-level menu
add_menu_page('Payment History', 'Payment History', 'administrator', __FILE__, 'baw_settings_page',plugins_url('/images/icon.png', __FILE__));
//call register settings function
add_action( 'admin_init', 'register_mysettings' );
}
function register_mysettings() {
//register our settings
register_setting( 'manoj-settings-group', 'new_option_name' );
register_setting( 'manoj-settings-group', 'some_other_option' );
register_setting( 'manoj-settings-group', 'option_etc' );
}
function username($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_name'];
}
function usermail($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_email'];
}
function baw_settings_page() {
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js">
</script>
<script src="jquery.tablePagination.0.5.js">
</script>
<script type="text/javascript">
$(document).ready(function() {
$('table').tablePagination({});
});
</script>
<style>
td {
border: 1px solid black;
}
#testTable {
width : 350px;
margin-left: auto;
margin-right: auto;
}
#tablePagination {
background-color: #DCDCDC;
font-size: 0.8em;
padding: 0px 5px;
height: 20px
}
#tablePagination_paginater {
margin-left: auto;
margin-right: auto;
}
#tablePagination img {
padding: 0px 2px;
}
#tablePagination_perPage {
float: left;
}
#tablePagination_paginater {
float: right;
}
</style>
<script>
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","deletetag.php?q="+str,true);
xmlhttp.send();
}
</script>
<div class="wrap">
<br/><br/><br/>
<h2>Payment History</h2>
<p> </p>
<script>
function showHint(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","gethint.php?q="+str,true);
xmlhttp.send();
}
</script>
<p><strong>Enter the txn reference no.</strong></td><td><input type="text" name="search" onkeyup="showHint(this.value)" /></p>
<br/><br/>
<span id="txtHint">
<?php $result = mysql_query("SELECT * FROM payments ");
echo "<table width='100%' border='1' cellspacing='0' cellpadding='2' id='menuTable'>";
echo "<thead>
<tr>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Ref.</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Amount</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Date</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Name</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Email</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Status</th>
</tr></thead>";
// loop through results of database query, displaying them in the table
while($row=mysql_fetch_array($result))
{
// echo out the contents of each row into a table
echo "<tr>";
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['txnid'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">$'.$row['payment_amount']. '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">'.$row['createdtime'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' .username($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . usermail($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['payment_status'] . '</td>';
echo "</tr>";
// close table>
}
echo "</table>";
}
?>
</span>
</div>




