|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/www/admin/ |
Upload File : |
<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<?
echo "";
if($sessionLevel !=15 && $sessionLevel !=25){
echo "<script>alert('admin page');document.location='/admin/login.php';</script>";
}
?>
<?
$title_text = "members";
// =============================================== Query
//$tableName = "notice";
if($goodsproduct){
$where .=" and A.goodsuid ='$goodsproduct' ";
}
if($orderstep){
$where .=" and A.orderstep='$orderstep' ";
}
//if($key_word){
$order_by = ' ORDER BY A.d_bank desc';
//}
$QUERY_PAGE = "
SELECT
A.*,
C.userid,
C.id as mbrid
FROM shop_order A ,user C WHERE A.mbruid = C.id $where $order_by";
$result= mysql_query($QUERY_PAGE,$db_con);
if(!$result) {
error("DB_ERROR");
exit;
}
$total = mysql_affected_rows();
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename = JYJ_GOODS_$goodsproduct.xls" );
header( "Content-Description: PHP4 Generated Data" );
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<TITLE>JYJ GOODS</TITLE>
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="content-script-type" content="text/javascript" />
<meta http-equiv="content-language" content="ja" />
<meta name="author" content="parksihoo JAPAN OFFICIAL FANCLUB" />
<meta name="copyright" content="Copyright EVAN JAPAN OFFICIAL FANCLUB.All Rights Reserved." />
<meta name="robots" content="INDEX,FOLLOW" />
<meta name="keywords" content="parksihoo" lang="ja" xml:lang="ja" />
<meta name="description" content="parksihoo" lang="ja" xml:lang="ja" />
</HEAD>
<BODY>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<tr>
<td>
<table width="100%" cellspacing="0" cellpadding="0" border=1 align='center' class="table_ro">
<tr>
<th scope="row" width="180">Order_No</th>
<th scope="row">ID</th>
<th scope="row">oName</th>
<th scope="row">oTEL</th>
<th scope="row">oEmail</th>
<th scope="row">oaddress</th>
<th scope="row">oZip_Code</th>
<th scope="row">rName</th>
<th scope="row">rTEL</th>
<th scope="row">rEmail</th>
<th scope="row">raddress</th>
<th scope="row">rZip_Code</th>
<th scope="row">Client_Name</th>
<th scope="row">Goods_Counter</th>
<th scope="row">Product</th>
<th scope="row">Amount</th>
<th scope="row">application_date</th>
</tr>
<?
if(!$total){
echo "<tr><td colspan='6' align=center height='50px'>登録された情報がございません</td></tr>";
}else{
for($i=0; $i<$total; $i++) {
$row = mysql_fetch_array($result);
$d_bankdate = substr($row[d_bank],0,4)."-".substr($row[d_bank],4,2)."-".substr($row[d_bank],6,2);
?>
<tr align="center">
<td align="center" height="30px"><?=$row[orderid]?></td>
<td>J_<?=$row[userid]?></td>
<td><?=$row[o_name]?></td>
<td><?=$row[o_tel]?></td>
<td><?=$row[o_email]?></td>
<td><?=$row[o_addr]?></td>
<td><?=$row[o_zip]?></td>
<td><?=$row[r_name]?></td>
<td><?=$row[r_tel]?></td>
<td><?=$row[r_email]?></td>
<td><?=$row[r_addr]?></td>
<td><?=$row[r_zip]?></td>
<td>JYJ MEMEBERSHIP STORE</td>
<td colspan = "3">
<table width="100%" border="1" cellpadding="1" cellspacing="1">
<?$reqry = "select * from shop_ordergoods where mbruid = '$row[mbrid]' and parent='$row[uid]'";
$resub= mysql_query($reqry,$db_con);
$goods_total = mysql_affected_rows();
while($rows=mysql_fetch_array($resub)){
?>
<tr>
<td><?=$goods_total?></td>
<td><?=$rows[goodsname]?></td>
<td><?=$rows[buynum]?></td>
</tr>
<?}?>
</table>
</td>
<td><?=$d_bankdate?></td>
</tr>
<?
$Num--;
}
}
?>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>