관리-도구
편집 파일: bookingsList.php
<? session_start(); $dbhost = 'internal-db.s3783.gridserver.com'; $dbusername = 'aaronmeyer'; $dbuserpassword = 'CQDZZDsu'; $default_dbname = 'db3783_ticketingSystem'; $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword); $dbid = mysql_select_db($default_dbname); $sql = "select * from bookingmaster where 1=1 and "; $cond=""; if (($_GET['paystatus']!='All') && ($_GET['paystatus']!='')) $cond = $cond . " paystatus='" . $_GET['paystatus'] . "' and "; if (($_GET['eventid']!='All') && ($_GET['eventid']!='')) $cond = $cond . " eventid='" . $_GET['eventid'] . "' and "; if (($_GET['customerid']!='All') && ($_GET['customerid']!='')) $cond = $cond . " customerid='" . $_GET['customerid'] . "' and "; if ($_GET['transactionid']!='') $cond = $cond . " transactionid='" . $_GET['transactionid'] . "' and "; if ($_GET['paytxnid']!='') $cond = $cond . " paytxnid='" . $_GET['paytxnid'] . "' and "; $cond = $cond . "1=1"; if ($_GET['sortorder'] != '') $sql = $sql . $cond . " order by " . $_GET['sortorder']; else $sql = $sql . $cond . " order by date"; $res = mysql_query($sql); ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <style type="text/css"> <!-- .Header { font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 14px; } .TblHeading {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; } .datarow {font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif;} --> </style> <script language="Javascript"> function refreshList() { var qrystr; qrystr = "bookingsList.php?1=1"; qrystr = qrystr + "&paystatus=" + document.getElementById('paystatus').value; qrystr = qrystr + "&eventid=" + document.getElementById('frm_evt').value; qrystr = qrystr + "&customerid=" + document.getElementById('frm_cust').value; qrystr = qrystr + "&transactionid=" + document.getElementById('transactionid').value; qrystr = qrystr + "&paytxnid=" + document.getElementById('paytxnid').value; qrystr = qrystr + "&sortorder=" + document.getElementById('sortorder').value; self.location = qrystr; } </script> </head> <body> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000"> <tr> <td><table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8" class="Header"><strong>Online Ticket Booking System -> Booking List </strong></td> </tr> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8" class="Header"> <table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td colspan="2" class="TblHeading">Report Search Criteria >> </td> </tr> <tr> <td width="30%" bgcolor="#FCFCFC" class="TblHeading">Payment Status </td> <td width="70%" bgcolor="#FFFFFF"> <select name="paystatus" id="paystatus"> <option value="All" selected>All</option> <option value="Success">Success</option> <option value="Failure">Failed</option> </select> </td> </tr> <tr> <td bgcolor="#FCFCFC" class="TblHeading">Event</td> <td bgcolor="#FFFFFF"><select name="frm_evt" id="frm_evt"> <option value="All">All Events</option> <? $esql = "select * from eventmaster order by id"; $eres = mysql_query($esql); while ($erow = mysql_fetch_row($eres)) {?> <option value="<? echo $erow[0]; ?>"><? echo $erow[1] . " " . $erow[2]; ?></option> <? } ?> </select></td> </tr> <tr> <td bgcolor="#FCFCFC" class="TblHeading">Customer Email Address </td> <td bgcolor="#FFFFFF"><select name="frm_cust" id="frm_cust"> <option value="All">All Customers</option> <option value="0">Site Administrator</option> <? $esql = "select * from personaldetails order by emailaddress"; $eres = mysql_query($esql); while ($erow = mysql_fetch_row($eres)) {?> <option value="<? echo $erow[0]; ?>"><? echo $erow[3]; ?></option> <? } ?> </select></td> </tr> <tr> <td bgcolor="#FCFCFC" class="TblHeading">Booking Reference Number </td> <td bgcolor="#FFFFFF"><label> <input type="text" name="transactionid" id="transactionid"> </label></td> </tr> <tr> <td bgcolor="#FCFCFC" class="TblHeading">PayPal Transaction Number </td> <td bgcolor="#FFFFFF"><input type="text" name="paytxnid" id="paytxnid"></td> </tr> <tr> <td bgcolor="#FCFCFC" class="TblHeading">Sort Order </td> <td bgcolor="#FFFFFF"><select name="sortorder" id="sortorder"> <option value="date" selected>Transaction Date</option> <option value="customerid">Customer Id</option> <option value="paytotal">Amount</option> <option value="eventid">Event Id</option> </select></td> </tr> <tr> <td colspan="2" align="center" bgcolor="#FCFCFC" class="TblHeading"><label> <input type="button" name="Submit" value="Search Booking Records" onclick="refreshList()"> </label></td> </tr> </table> </td> </tr> <tr> <td bgcolor="#F8F8F8" class="TblHeading">Transaction Id</td> <td bgcolor="#F8F8F8" class="TblHeading">Transaction Date/Time</td> <td bgcolor="#F8F8F8" class="TblHeading">Event Date</td> <td bgcolor="#F8F8F8" class="TblHeading">Customer Name</td> <td bgcolor="#F8F8F8" class="TblHeading">PayPal Transaction Id</td> <td bgcolor="#F8F8F8" class="TblHeading">Amount</td> <td bgcolor="#F8F8F8" class="TblHeading">Status</td> </tr> <? while ($row = mysql_fetch_row($res)) {?> <tr> <td bgcolor="#FFFFFF" class="datarow"> <a href="transactionDetails.php?txnId=<? echo $row[0]; ?>"><? echo $row[1]; ?></a></td> <td bgcolor="#FFFFFF" class="datarow"> <? echo $row[6] . " " . $row[7]; ?></td> <td bgcolor="#FFFFFF" class="datarow"> <? $midd = "select * from eventmaster where id='".$row[11]."'"; $mmres = mysql_query($midd); $mrr = mysql_fetch_row($mmres); echo $mrr[1] . " " . $mrr[2]; ?> </td> <td bgcolor="#FFFFFF" class="datarow"> <? if ($row[5] != 0) { $midd = "select firstname,emailaddress from personaldetails where id='".$row[5]."'"; $mmres = mysql_query($midd); $mrr = mysql_fetch_row($mmres); echo $mrr[0]; } else { echo 'Site Administrator'; } ?> </td> <td bgcolor="#FFFFFF" class="datarow"> <? echo $row[2]; ?></td> <td bgcolor="#FFFFFF" class="datarow" align="right"> $<? echo $row[10]; ?>.00</td> <td bgcolor="#FFFFFF" class="datarow"> <? echo $row[8]; ?></td> </tr> <? } ?> </table></td> </tr> </table> </body> </html>