Server IP : 127.0.0.2 / Your IP : 18.217.119.115 Web Server : Apache/2.4.18 (Ubuntu) System : User : www-data ( ) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : disk_free_space,disk_total_space,diskfreespace,dl,exec,fpaththru,getmyuid,getmypid,highlight_file,ignore_user_abord,leak,listen,link,opcache_get_configuration,opcache_get_status,passthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,php_uname,phpinfo,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,_getppid,posix_getpwnam,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_times,posix_ttyname,posix_uname,pclose,popen,proc_open,proc_close,proc_get_status,proc_nice,proc_terminate,shell_exec,source,show_source,system,virtual MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/admin/ |
Upload File : |
<?php session_start(); $_SESSION['viewcart']=1; $ID = $_SESSION['InvoiceNo']; include_once('admin/include/db-config.php'); /*$NumRow=""; if(isset($_POST['edit_bttn'])) { $i=0; while ($i < count($_SESSION["pid"])) { $ProdID = (int)$_SESSION["pid"][$i]; if($ProdID > 0) { //echo "qty = ".$_SESSION["ProdQty"][$i]; $qtyid = "Qty".$i; $_SESSION["txtQTY"][$i] = $_POST[$qtyid]; } $i++; } }*/ ?> <HTML> <HEAD> <title>Joel Levitt, Maintenance Management Seminar</title> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <meta content="" name="description" /> <meta content="maintenance management, maintenance management training" name="keywords" /> <link href="css/style.css" type="text/css" rel="stylesheet"> </HEAD> <BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0> <!-- ImageReady Slices (maintrainer_slice2.jpg) --> <TABLE WIDTH="100%" BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center"> <?php include_once('include/include_header.php'); ?> <TR> <TD width="100%" align="center"> <form action="cart.php" method="post"> <table border="0" cellpadding="0" cellspacing="0" width="960" align="center" class="body_bg" style="min-height:700px; border-color:"> <tr><td style="height:9px;"></td></tr> <tr> <td style="width:9px;"></td> <td style="width:235px" class="content_bg" align="center" valign="top"> <table border="0" cellpadding="0" cellspacing="0"> <tr><td style="height:10px;"></td></tr> <tr> <td style="height:132px; width:217px;" valign="top"> <?php include_once('include_shopcategory.php'); ?> <!--<table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td align="left" height="40" width="10%" style="padding-left:10px; padding-right:10px;"><img src="images/bullet.gif" border="0"></td> <td class="left_nav" height="40" width="90%"><a href="shopCategory.php?categoryRefId=1">Books</a></td> </tr> <tr><td colspan="2"><img src="images/small_line.gif" border="0"></td></tr> <tr> <td align="left" height="40" width="10%" style="padding-left:10px; padding-right:10px;"><img src="images/bullet.gif" border="0"></td> <td class="left_nav" height="40"><a href="shopCategory.php?categoryRefId=3">Audio Training</a></td> </tr> <tr><td colspan="2"><img src="images/small_line.gif" border="0"></td></tr> <tr> <td align="left" height="40" width="10%" style="padding-left:10px; padding-right:10px;"><img src="images/bullet.gif" border="0"></td> <td class="left_nav" height="40"><a href="shopCategory.php?categoryRefId=6">Self Study Courses</a></td> </tr> <tr><td colspan="2"><img src="images/small_line.gif" border="0"></td></tr> <tr> <td align="left" height="40" width="10%" style="padding-left:10px; padding-right:10px;"><img src="images/bullet.gif" border="0"></td> <td class="left_nav" height="40"><a href="shop_computer_based_training.html" target="_blank">CBT (Computer Based Training)</a></td> </tr> <tr><td colspan="2"><img src="images/small_line.gif" border="0"></td></tr> <tr> <td align="left" height="40" width="10%" style="padding-left:10px; padding-right:10px;"><img src="images/bullet.gif" border="0"></td> <td class="left_nav" height="40"><a href="shopCategory.php?categoryRefId=8">Clearance to Shop</a></td> </tr> <tr><td colspan="2"><img src="images/small_line.gif" border="0"></td></tr> </table>--> </td> </tr> </table> </td> <td style="width:9px;"></td> <td style="width:696px;" class="content_bg" valign="top"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td class="main_head" align="left" style="padding:15px;">Shopping Cart Summary</td> </tr> </table> <p style="padding:15px;"><?php if($ID==""){?><font color="red">You have already completed your purchase.<!-- Make another purchase. For the earlier purchase details please check your inbox. --></font> <?php } else {?>Your request has been sent. Thank you for your interest in Springfield Resources and maintenancetraining.com.<?php }?></p> <!-- the below if loop is for checking is there any value in session(technical-problem: On Refresh Create Duplicate Invoice) --> <?php if($ID!=""){ $sql="select tb1.CouponCode,tb1.DiscountType,tb1.CouponAmount,tb1.OrderDate,tb2.Billing_FirstName,tb2.Billing_LastName,tb2.Billing_Address1,tb2.Billing_Address2,tb2.Billing_City,tb2.Billing_State,tb2.Billing_Country,tb2.Billing_Zip,tb2.Billing_EmailID,tb2.Shipping_FirstName,tb2.Shipping_LastName,tb2.Shipping_Address1,tb2.Shipping_Address2,tb2.Shipping_City,tb2.Shipping_State,tb2.Shipping_Country,tb2.Shipping_Zip,tb2.Shipping_EmailID from maintrainer_tbl_cart_master tb1 left join maintrainer_tbl_customer_information tb2 on tb2.CartMasterID= tb1.ID where tb1.ID=".$ID; $result=mysqli_query($conn,$sql); $row=mysqli_fetch_array($result); $DiscountType =$row['DiscountType']; $Discount =$row['CouponAmount']; ?> <TABLE WIDTH=800 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center" style="background-color: white; color: black; padding: 20px;"> <tr> <td colspan="2" class="title" align="center"><img src="admin/images/invoiceheader.gif" border="0" ></td> </tr> <tr> <td align="left"> <strong>Springfield Resources</strong> <br> 205 Ash Lane,Lafayette Hill PA, 19444-2101 <br>Phone: 610-397-1006 <br>Fax: 610-397-1007 <br>Toll Free: 800-242-5656 <br>Email: jdl@maintrainer.com <br>URL: http://www.maintenancetraining.com </td> </tr> <tr> <td colspan="2" class="title" align="center"><h2><b>Receipt</b></h2></td> </tr> <tr> <td width="50%" align="left" class="textnormal"> <strong>Date: <?php echo date('M-d-Y', strtotime($row['OrderDate'])) ?></strong> </td> <td width="50%" align="right" class="textnormal"> <strong>Inv No. <?php echo $ID?></strong> </td> <tr><td colspan="2" style="height:20px;"></td></tr> <tr> <td width="50%" align="left" class="textnormal"> <b>Billing Address</b> <br> <?php echo $row['Billing_FirstName'] ?> <?php echo $row['Billing_LastName'] ?> <br> <?php echo $row['Billing_Address1'] ?> <br> <?php if($row['Billing_Address2']!="") { echo $row['Billing_Address2']; echo "<br>"; } ?> <?php echo $row['Billing_City'] ?>, <?php echo $row['Billing_State'] ?> <br> <?php echo $row['Billing_Country'] ?> - <?php echo $row['Billing_Zip'] ?> <br> Email ID: <?php echo $row['Billing_EmailID']; ?> </td> <td width="50%" align="right" class="textnormal"> <b>Shipping Address</b> <br> <?php echo $row['Shipping_FirstName'] ?> <?php echo $row['Shipping_LastName'] ?> <br> <?php echo $row['Shipping_Address1'] ?> <br> <?php if($row['Shipping_Address2']!="") { echo $row['Shipping_Address2']; echo "<br>"; } ?> <?php echo $row['Shipping_City'] ?>, <?php echo $row['Shipping_State'] ?> <br> <?php echo $row['Shipping_Country'] ?> - <?php echo $row['Shipping_Zip'] ?> <br> Email ID: <?php echo $row['Shipping_EmailID']; ?> </td> </tr> </tr> <TR> <TD COLSPAN=2 WIDTH="100%" valign="top"> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0 height="100%" align="center"> <tr> <td height="100%" valign="top" class="prodtitle" align="center" style="padding-top:20px; padding-bottom:10px;"> <b>Cart Items</b> </td> </tr> <TR> <td width="100%" valign="top"> <table style="border-color: black;!important background-color: white; color: black;" border="1" cellpadding="10" cellspacing="0" align="left" width="100%"> <tr > <td ><b>Sl No</b></td> <td ><b>Product Category</b></td> <td ><b>Product Name</b></td> <td align="right"><b>Qty</b></td> <td align="right"><b>Price</b></td> </tr> <?php $i=1; $tot=0; //$sql1="select ProductCategory,ProductName,ProductQty,ProductPrice from diamondtipblades_tbl_cart_details where CartMasterID=".$ID; $sql1="SELECT tb1.ProductCategory,tb1.ProductName,tb1.ProductQty,tb1.DiscountPercentage,tb1.ProductPrice,tb1.product_key,tb2.DownloadURL,tb2.DownloadFlag FROM maintrainer_tbl_cart_details AS tb1 left outer join productnew AS tb2 ON tb1.Product_ID=tb2.ID WHERE tb1.CartMasterID=".$ID; $result1=mysqli_query($conn,$sql1); while($row1= mysqli_fetch_array($result1)) { ?> <tr> <td ><?php echo $i++ ?></td> <td><?php echo $row1['ProductCategory']?></td> <td ><?php echo $row1['ProductName']; echo "<br>"; if($row1['DiscountPercentage']!=0){echo "Volume Discount:".$row1['DiscountPercentage']."%Off";}else{}?> <?php if(($row1['DownloadFlag']==1) and ($row1['DownloadURL']!="")) { ?> <br> Download Link : <font color="#FFFFFF"> <a style="color: blue;" href="<?php echo $row1['DownloadURL'];?>"target="_blank"><?php echo $row1['DownloadURL'];?></a></font> <?php } if($row1['product_key'] !="") { ?> <br> Product Key : <?php echo $row1['product_key'];?> <?php } ?> </td> <td align="right"><?php echo $row1['ProductQty']?></td> <td align="right"><?php echo"$". $row1['ProductPrice']?></td> </tr> <?php $tot=$row1['ProductPrice']+$tot; } ?> <?php $sql2="select ShippingPrice,TotalProductPrice from maintrainer_tbl_cart_payment where CartMasterID=".$ID; $result2=mysqli_query($conn,$sql2); $row2=mysqli_fetch_array($result2) or die(mysqli_error()); $ShippingPrice=$row2['ShippingPrice']; $TotalProductPrice=$row2['TotalProductPrice']; if($DiscountType=="Amount") { $coupondics=$Discount; } else { $coupondics=($tot*$Discount)/100; } ?> <?php if(isset($DiscountType) && $row['CouponCode']!="") {?> <tr> <td colspan="4"><b>Coupon Discount<?php if($DiscountType!="Amount") echo "(".number_format($Discount,0)."%)";?></b><BR> Coupon code: <?php echo $row['CouponCode'];?> </td> <td colspan="1" align="right"><?php if($DiscountType=="Amount"){echo "<b>$".$Discount."</b>";} else {echo "<b>$". number_format($coupondics,2)."</b>";} ?></td> </tr> <?php } ?> <tr> <td colspan="4"><b>Shipping Charge</b></td> <td colspan="1" align="right"><?php echo"<b>$". number_format($ShippingPrice,2)."</b>" ?></td> </tr> <tr> <td colspan="4"><b>Total</b></td> <td colspan="1" align="right"><?php echo"<b>$". $TotalProductPrice."</b>" ?></td> </tr> </table> </td> </TR> </TABLE> </TD> </TR> <?php //$sql3="select CardName,CardNumber,CardType,CardCVVNumber,CardExpYear,CardExpMonth,PayType,PoNumber,PoDetails,CheckNumber,CheckDetails from maintrainer_tbl_cart_cerditcard_details where CartMasterId=".$ID; $sql3="SELECT tb1.CardName,tb1.CardNumber,tb1.CardType,tb1.CardCVVNumber,tb1.CardExpYear,tb1.CardExpMonth,tb1.PayType,tb1.PoNumber,tb1.PoDetails,tb1.CheckNumber,tb1.CheckDetails,tb2.TransactionID FROM maintrainer_tbl_cart_cerditcard_details AS tb1 LEFT OUTER JOIN maintrainer_tbl_cart_master AS tb2 ON tb1.CartMasterID=tb2.ID WHERE tb1.CartMasterID=".$ID; $result3=mysqli_query($conn,$sql3); $row3=mysqli_fetch_array($result3); if($row3['PayType']=="chk") { $paytype="Check"; } else if($row3['PayType']=="po") { $paytype="PO"; } else if($row3['PayType']=="paypal") { $paytype="Pay Pal"; } else { $paytype="Credit Card"; $CardNumber = convert($row3['CardNumber'],$key); } ?> <tr><td colspan="2" style="height:20px;"></td></tr> <tr> <td width="100%" align="left" class="textnormal" colspan="2"> <b>Payment Details</b> <br> Payment Type: <?php echo $paytype;?> <?php if($row3['PayType']=="chk"){?> <br> Check Number: <?php echo $row3['CheckNumber'];?> <br> Check Details: <?php echo nl2br($row3['CheckDetails']);?> <?php } else if($row3['PayType']=="po"){?> <br> Po Number: <?php echo $row3['PoNumber'];?> <br> Po Details: <?php echo nl2br($row3['PoDetails']);?> <?php }else if($row3['PayType']=="paypal"){?> <br> Transaction ID: <?php echo $row3['TransactionID'];?> <br> <?php } else {?> <br>Card Holder Name: <?php echo $row3['CardName'] ?> <br>Card No: <label id="cardno">XXXX XXXX XXXX <?php echo substr ($CardNumber, 12, 4) ?></label> <label id="show"><a href="javascript:show('<?php echo $CardNumber; ?>');">show</a></label> <br> Card Type: <?php echo $row3['CardType'] ?> <br> CVV No. <?php echo $row3['CardCVVNumber'] ?> <br> Card Expiry: <?php echo $row3['CardExpMonth'] ?> <?php echo $row3['CardExpYear'] ?> <?php } ?> </td> </tr> <Tr><td height="50"></td></Tr> </TABLE> <?php }?> <!-- <table border="0" cellpadding="0" cellspacing="1" bgcolor="#A8130D" width="666" align="center" class="normal_text"> <tr> <td class="cart_tbl_head">Sl No</td> <td class="cart_tbl_head"> Prtoduct</td> <td class="cart_tbl_head">Category</td> <td class="cart_tbl_head">Quantity</td> <td class="cart_tbl_head" align="right">Unit Price</td> <td class="cart_tbl_head" align="right">Total</td> <!--<td class="cart_tbl_head"></td>--> <!--</tr> <?php /*$bttn_enbl_flag = false; if(isset($_POST['NumRow'])) $NumRow =$_POST['NumRow']; $_SESSION['NumRow']=$NumRow; $count = 1; while($count < $NumRow) { $ProdID = "pid".$count; $ProdQty = "txtQTY".$count; $Catid="catid".$count; if (isset($_POST[$ProdID]) && (int)$_POST[$ProdQty]>0) { if (!isset($_SESSION["pid"])) { $_SESSION["pid"] = array(); $_SESSION["txtQTY"] = array(); $_SESSION["catid"] = array(); } $i=0; while ($i < count($_SESSION["pid"]) && ($_SESSION["pid"][$i] != $_POST[$ProdID] || $_SESSION["catid"][$i]!=$_POST[$Catid])) $i++; if ($i < count($_SESSION["pid"])) //edit current product's item quantity { $_SESSION["txtQTY"][$i] = $_POST[$ProdQty]; } else //no such product in the cart - add it { $_SESSION["pid"][] = $_POST[$ProdID]; $_SESSION["txtQTY"][] = $_POST[$ProdQty]; $_SESSION["catid"][] =$_POST[$Catid]; } } $count ++; } $i =0; $j=0; $tprice=0; $total=0; $allqty=0; while ($i < count ($_SESSION["pid"])) { $ProdID = (int)$_SESSION["pid"][$i]; $Catid = (int)$_SESSION["catid"][$i]; if($ProdID > 0) { $bttn_enbl_flag = true; $sql="select ProductName,SalesPrice from productnew where ID=".$ProdID; $result=mysqli_query($conn,$sql); $row=mysqli_fetch_array($result); $sql2="select CategoryID from product_categoires where CategoryID=".$Catid." and ProductID=".$ProdID; $result2=mysqli_query($conn,$sql2); $row2=mysqli_fetch_array($result2); $sql3="select CategoryName from categories_new where ID=".$row2['CategoryID']; $result3=mysqli_query($conn,$sql3); $row3=mysqli_fetch_array($result3); $CategoryName=$row3['CategoryName']; $j++; $sql1="select Discount from product_discount where QtyFrom<='".$_SESSION['txtQTY'][$i] ."' and ProductID=".$ProdID." order by QtyTo desc limit 1"; $result1=mysqli_query($conn,$sql1); $row1=mysqli_fetch_array($result1); $costprice=$_SESSION["txtQTY"][$i] * $row['SalesPrice']; // $price is used for calculate price based on quantity $deduction=$costprice*$row1['Discount']/100; $price=$costprice-$deduction; $DedutedUnitPrice = $row['SalesPrice'] * $row1['Discount']/100; $DiscountedUnitPrice =$row['SalesPrice'] - $DedutedUnitPrice; $total=$total + $price; $allqty=$_SESSION['txtQTY'][$i]+$allqty; //echo "TEST".$allqty; $ship_country = trim($_SESSION['shipcountry']); if($ship_country == "USA" || $ship_country == "United States" || $ship_country == "US" || $ship_country == "United States of America") { $sql4="select ID,CountryName from maintrainer_countrydetails where CountryName='USA' or CountryName='US' or CountryName='United States' or CountryName='United States of America' "; } else { $sql4="select ID,CountryName from maintrainer_countrydetails where CountryName='".$_SESSION['shipcountry']."'"; } $result4=mysqli_query($conn,$sql4); if($row4=mysqli_fetch_array($result4)) { $countryid = $row4['ID']; } else { $countryid = 2; } //$row4=mysqli_fetch_array($result4); $sql5="select ShippingPrice from maintrainer_shippingdetails where CountryID=".$countryid." and QtyFrom <= ".$allqty." order by QtyTo desc limit 1"; $result5=mysqli_query($conn,$sql5); if($row5=mysqli_fetch_array($result5)) { $ShippingPrice=$row5['ShippingPrice']; } else { $ShippingPrice=0; } $coupondics=0; if(isset($_SESSION['couponcode'])) { $sql5="select DiscountType,Discount from maintrainer_coupon where CouponCode= '".$_SESSION['couponcode']. "' and curdate() between DateFrom and DateTo and Status=1"; $result5=mysqli_query($conn,$sql5); $row5=mysqli_fetch_array($result5); $DiscountType =$row5['DiscountType']; $Discount =$row5['Discount']; if($DiscountType=="Amount") { $coupondics=$Discount; } else { $coupondics=($total*$Discount)/100; } } //$row5=mysqli_fetch_array($result5); //$ShippingPrice=$row5['ShippingPrice']; $grndtot=$total+$ShippingPrice-$coupondics; */ ?> <tr> <td class="cart_tbl_content"><?php //echo "$j"; ?></td> <td class="cart_tbl_content"><?php //echo $row['ProductName'];?><br><font class="normal_text" style="color:#666666;"><?php //if($row1['Discount']!=0){echo "Volume Discount:".$row1['Discount']."%Off";}else{} ?></font></td> <td class="cart_tbl_content"><?php //echo $CategoryName; ?></td> <td class="cart_tbl_content"><?php //echo $_SESSION["txtQTY"][$i]; ?></td> <!--<td class="cart_tbl_content"><input type="text" style="width:50px;" value="<?//php echo $_SESSION["txtQTY"][$i]; ?>" name="Qty<?//php echo $i; ?>" id="Qty<?//php echo $i; ?>" class="txtbox_small2"></td>--> <!--<td class="cart_tbl_content" align="right"><?php //echo "$".number_format($DiscountedUnitPrice,2); ?></td>--> <!-- <td class="cart_tbl_content" align="right"><?php //echo "$". number_format($price,2); ?></td>--> <!--<td class="cart_tbl_content" align="center"><a href="product-delete-action.php?ProdID=<?php //echo $ProdID;?>" onClick="return confirm('Are you sure you want to delete?')">Delete</a></td>--> <!--</tr> <?php //} //$i++; // } //echo "TEST".$allqty; ?> <tr> <td class="cart_tbl_content" colspan="5"><strong>SubTotal</strong></td> <td class="cart_tbl_content" align="right"><strong><?php //echo "$".number_format($total,2); ?></strong></td> <!-- <td class="cart_tbl_content"></td>--> <!--</tr> <?php //if(isset($_SESSION['couponcode'])){ ?> <tr> <td class="cart_tbl_content" colspan="5"><strong>Coupon Discount<?php //if($DiscountType!="Amount") echo "(".number_format($Discount,0)."%)";?></strong></td> <td class="cart_tbl_content" align="right"><strong><?php //if($DiscountType=="Amount"){echo "$".$Discount;} else {echo "$". number_format($coupondics,2);} ?></strong></td> <!-- <td class="cart_tbl_content"></td>--> <!--</tr> <?php //} ?> <tr> <td class="cart_tbl_content" colspan="5"><strong>ShippingCharge</strong></td> <td class="cart_tbl_content" align="right"><strong><?php //echo "$".number_format($ShippingPrice,2); ?></strong></td> <!-- <td class="cart_tbl_content"></td>--> <!--</tr> <tr> <td class="cart_tbl_content" colspan="5"><strong>Total</strong></td> <td class="cart_tbl_content" align="right"><strong><?php //echo "$".number_format($grndtot,2); ?></strong></td> <!--<td class="cart_tbl_content"></td>--> <!--</tr> </table>--> <!--<br> <br>--> <!-- <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr><td style="height:20px;"></td></tr> <tr> <td align="center"> <a href="shopCategory.php?categoryRefId=1" style="text-decoration:none;"><input type="button" onClick="Javascript:window.location = 'shopCategory.php?categoryRefId=1'" value="Continue Shopping" class="bttn"></a> <?php //if($bttn_enbl_flag == true) //{ ?> <input type="submit" name="edit_bttn" id="edit_bttn" value=" Update Cart" class="bttn"> <a href="checkout-acctinfo.php" style="text-decoration:none;"><input type="button" onClick="Javascript:window.location = 'checkout-acctinfo.php'" value="Secure Checkout" class="bttn"></a> <?php //} ?> <br><br> </td> </tr> </table>--> </td> <td style="width:9px;"></td> </tr> <tr><td style="height:9px;"></td></tr> </table> </form> </TD> </TR> <?php include_once('include/include_footer.php'); $customerid=$_SESSION['customerid']; session_destroy(); //ob_start(); ?> </TABLE> <!-- End ImageReady Slices --> </BODY> </HTML> <?php $_SESSION['customerid']=$customerid; ?>