|
엑셀파일로 다운받으려고 하는데요.
"구매종류 금액 결제종류 입금자명 결제상태 배송날짜 처리상태 배송지주소 e-mail 주문상품 주문자전화번호 주문자핸드폰 수령인전화번호 수령인핸드폰" 까지 다 엑셀에 출력되어야 하는데
구매종류 금액 결제종류 입금자명 결제상태 배송날짜 처리상태 까지만 출력이 되고 뒤에는 표시가 되질 않아요
sql에서 잘못된거 같은데 어떻게 해야 할지를 모르겠습니다.
도와주세요
(order_view.php 이 페이지의 sql이 필요 하시면 제일 마지막에 표기해 놓겠습니다.)
<?
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=".$filename.$yy1.$mm1.$dd1."_order_xls.xls");
header( "Content-Description: PHP4 Generated Data" );
include "../include/db.php"; ?>
<?
if($yy1 == "") {
$yy1 = substr($uv_today, 0, 4);
$mm1 = substr($uv_today, 5, 2);
$dd1 = substr($uv_today, 8, 2);
$yy2 = $yy1;
$mm2 = $mm1;
$dd2 = $dd1;
}
$ymd1 = "$yy1-$mm1-$dd1";
$ymd2 = "$yy2-$mm2-$dd2";
?>
<html>
<head>
<title>:: ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<style type="text/css">
<!--
td {font-size:12px; font-family:굴림; text-decoration:none; color:#4B4B4B}
.t {font-size:13px; font-family:arial; text-decoration:none; color:#000066}
.t1 {font-size:12px; font-family:굴림; text-decoration:none; color:red}
.h1 {font-size:12px; font-family:굴림; text-decoration:none; color:#000099}
.d1 {font-size:13px; font-family:굴림; line-height:1.5; padding-left:10; padding-top:10; padding-right:10; padding-bottom:10; text-decoration:none; color:#3D3D3D}
a:visited { color: #737373; font-family:굴림; font-size:12px; font-style:normal; text-decoration:none; }
a:active { color: #737373; font-family:굴림; font-size:12px; font-style:normal; text-decoration:none; }
a:link { color: #737373; font-family:굴림; font-size:12px; font-style:normal; text-decoration:none; }
a:hover { color: #313131; font-family:굴림; font-size:12px; font-style:normal; text-decoration:underline; }
-->
</style>
<script>
<!--
-->
</script>
</head>
<body bgcolor="FEFBF2" text="#000000" leftmargin="20" topmargin="10" marginwidth="0" marginheight="0">
<? if(!$page) $page = 1;
if(!$opt) $opt = "1";
if(!$wrd) $wrd = "";
$num_per_page = 15;
$page_per_block = 10;
########## 전체게시물의 총 개수를 각각 구한다. ##########
$sql = "Select count(*) From order_master Where order_date >= '$ymd1' And order_date <= '$ymd2' ";
if($wrd != "") {
if($opt == "1") $where .= " And b_name Like '%" . $wrd . "%' ";
else if($opt == "2") $where .= " And m_id Like '$" . $wrd . "%' ";
else if($opt == "3") $where .= " And r_name Like '%" . $wrd . "%' ";
else if($opt == "4") $where .= " And ord_no Like '%" . $wrd . "%' ";
else if($opt == "5") $where .= " And b_tel Like '%" . $wrd . "%' ";
else if($opt == "6") $where .= " And b_cell Like '%" . $wrd . "%' ";
}
if($s_pst != "") $where .= " And proc_st = '$s_pst' ";
if($s_rst != "") $where .= " And remit_st = '$s_rst' ";
if($s_res_kind != "") $where .= " And res_kind = '$s_res_kind' ";
$sql .= $where;
$rs = mysql_query($sql);
if(!$rs) exit;
$total_record = mysql_result($rs, 0, 0);
########## 현재의 페이지에서 출력할 게시물의 범위를 결정한다. ##########
if(!$total_record) {
$first = 1;
$last = 0;
} else {
$first = $num_per_page * ($page - 1);
$last = $num_per_page * $page;
$IsNext = $total_record - $last;
if($IsNext > 0) $last -= 1;
else $last = $total_record - 1;
}
$total_page = ceil($total_record / $num_per_page);
?>
<table border=0 cellpadding=0 cellspacing=1 bgcolor=056B96>
<tr align="center" bgcolor=BCCED5 height=24>
<td width="60">주문번호</td>
<td width="39">구매일자</td>
<td width="53">구매자명</td>
<td width="42">구매종류</td>
<td width="35">금액</td>
<td width="42">결제종류</td>
<td width="57">입금자명</td>
<td width="60">결제상태</td>
<td width="60">배송날짜</td>
<td width="58">처리상태</td>
<td width="45">배송지주소</td>
<td width="65">e-mail</td>
<td width="63">주문상품</td>
<td width="82">주문자전화번호</td>
<td width="82">주문자핸드폰</td>
<td width="82">수령인전화번호</td>
<td width="91">수령인핸드폰</td>
</tr>
<? if(!$total_record) { ?>
<tr align="center">
<td bgcolor="#FFFFFF" colspan=10 height=40>자료가 없습니다..</td>
<tr>
<? } else {
$sql = "Select ord_no, order_date, b_name, res_kind, sign_amt, sign_kind, remit_st, proc_st, confirm_yn, rec_name, bank_name, besong_date ";
$sql .= " From order_master Where order_date >= '$ymd1' And order_date <= '$ymd2' ";
$sql .= $where . " Order by ord_no Desc ";
$rs = mysql_query($sql);
$article_num = $total_record - $num_per_page * ($page - 1);
for($i = 0; $i < $total_record; $i++) {
$ord_no = mysql_result($rs,$i,0);
$order_date = mysql_result($rs,$i,1);
$b_name = mysql_result($rs,$i,2);
$res_kind = mysql_result($rs,$i,3);
$sign_amt = mysql_result($rs,$i,4);
$sign_kind = mysql_result($rs,$i,5);
$remit_st = mysql_result($rs,$i,6);
$proc_st = mysql_result($rs,$i,7);
$confirm_yn = mysql_result($rs,$i,8);
$rec_name = mysql_result($rs,$i,9);
$bank_name = mysql_result($rs,$i,10);
$besong_date = mysql_result($rs,$i,11);
if($besong_date == '0')
$besong_date = "배송전";
if($remit_st == "1") $remit_st = "미결제";
else if($remit_st == "2") $remit_st = "미수금";
else if($remit_st == "3") $remit_st = "<font color=red>무통장결제완료</font>";
else if($remit_st == "4") $remit_st = "<font color=red>신용카드결제완료</font>";
else if($remit_st == "5") $remit_st = "일부결제";
else if($remit_st == "6") $remit_st = "일부환불";
else if($remit_st == "7") $remit_st = "전액환불";
else if($remit_st == "8") $remit_st = "<font color=#000080>주문취소</font>";
if($proc_st == "01") $proc_st = "주문접수";
else if($proc_st == "02") $proc_st = "녹화대기";
else if($proc_st == "03") $proc_st = "<font color=#0000FF>녹화중</font>";
else if($proc_st == "04") $proc_st = "녹화완료";
else if($proc_st == "05") $proc_st = "녹화취소";
else if($proc_st == "06") $proc_st = "상품준비중";
else if($proc_st == "07") $proc_st = "배송대기";
else if($proc_st == "08") $proc_st = "<font color=red>배송중</font>";
else if($proc_st == "09") $proc_st = "<font color=#008000>배송완료</font>";
else if($proc_st == "10") $proc_st = "배송취소";
if($res_kind == "01") $res_kind = "비회원-개인";
else if($res_kind == "02") $res_kind = "비회원-기관";
else if($res_kind == "11") $res_kind = "회원-개인";
else if($res_kind == "12") $res_kind = "회원-기관";
if($sign_kind == "C"){
$sign_kind = "신용카드";
}else if($sign_kind == "B"){
$sign_kind = "무통장";
$bank_name = substr($bank_name, 0,4);
$sign_kind = "무통장($bank_name)";
}else{
$sign_kind = "기관구매";
}
$url = "order_view.php?ord_no=$ord_no&page=$page&s_pst=$s_pst&s_rst=$s_rst&s_res_kind=$s_res_kind&opt=$opt&wrd=$wrd&yy1=$yy1&mm1=$mm1&dd1=$dd1&yy2=$yy2&mm2=$mm2&dd2=$dd2";
?>
<tr height=26 valign=middle bgcolor=ffffff>
<td align=center><a href="<?=$url?>">
<?=$ord_no?>
</a></td>
<td align=left> <a href="<?=$url?>">
<?=$order_date?>
</a></td>
<td align=left> <a href="<?=$url?>">
<?=$b_name?>
</a></td>
<td align=center><a href="<?=$url?>">
<?=$res_kind?>
</a></td>
<td align=right> <a href="<?=$url?>">
<?=FCurrency($sign_amt)?>
</a> </td>
<td align=center> <a href="mailto:<?=$email?>">
<?=$sign_kind?>
</a></td>
<td align=center>
<?=$rec_name?>
</td>
<td align=center><a href="<?=$url?>">
<?=$remit_st?>
</a></td>
<td align=center><a href="<?=$url?>">
<?=$besong_date?>
</a></td>
<td align=center><a href="<?=$url?>">
<?=$proc_st?>
</a></td>
<td align=center> <table border=0 cellpadding=3 cellspacing=0>
<input type="text" name="b_addr1" value="<?=$b_addr1?>" size=40 style="border:1 solid #8B8B8B">
<input type="text" name="b_addr2" value="<?=$b_addr2?>" size=30 style="border:1 solid #8B8B8B">
<tr>
<td>
<!--<?=$b_addr1?>-->
</td>
</tr>
<tr>
<td>
<!--<?=$b_addr2?>-->
</td>
</tr>
</table>
<!-- <input type="text" name="b_addr1" value="<?=$b_addr1?>" size=30 style="border:1 solid #8B8B8B">
<input type="text" name="b_addr2" value="<?=$b_addr2?>" size=20 style="border:1 solid #8B8B8B">//-->
</td>
<td align=center>
<?=$b_email?>
</td>
<td align=center> <a href="<?=$url?>">
<?=$goods_name?>
:
<?=$sub_title2?>
:
<?=$show_date?>
:
<?=$running_time?>
</a> </td>
<td align=center> <a href="<?=$url?>">
<?=$b_tel[0]?>
<?=$b_tel[1]?>
<?=$b_tel[2]?>
</a> </td>
<td align=center> <a href="<?=$url?>">
<?=$b_cell[0]?>
<?=$b_cell[1]?>
<?=$b_cell[2]?>
</a> </td>
<td align=center> <a href="<?=$url?>">
<?=$r_tel[0]?>
<?=$r_tel[1]?>
<?=$r_tel[2]?>
</a> </td>
<td align=center> <a href="<?=$url?>">
<?=$r_cell[0]?>
<?=$r_cell[1]?>
<?=$r_cell[2]?>
</a> </td>
</tr>
<? $article_num--;
}
$total_block = ceil($total_page / $page_per_block);
$block = ceil($page / $page_per_block);
$first_page = ($block - 1) * $page_per_block;
$last_page = $block * $page_per_block;
if($total_block <= $block) $last_page = $total_page;
}
?>
</table>
</body>
</html>
----------------------------------------------------------------------------------------
order_view.php mysql
<? $sql = "Select order_date, order_time, b_name, b_tel, b_cell, b_zip_code, b_addr1, b_addr2, r_name, ";
$sql .= " r_tel, r_cell, r_zip_code, r_addr1, r_addr2, msg, sign_kind, bank_name, rec_name, rec_date, ";
$sql .= " sign_amt, proc_st, remit_st, proc_name, proc_data, rtn_msg, m_id, sr_name, docu, saup_no, ";
$sql .= " b_email, b_org_name, r_org_name, res_kind, remit_amt,saup_tae,saup_jong,t_id From order_master Where ord_no = $ord_no";
$rs = mysql_query($sql);
$row = mysql_fetch_row($rs);
$order_date = $row[0];
$order_time = $row[1];
$b_name = $row[2];
$b_tel = explode("-", $row[3]);
$b_cell = explode("-", $row[4]);
$b_zip_code = explode("-", $row[5]);
$b_addr1 = $row[6];
$b_addr2 = $row[7];
$r_name = $row[8];
$r_tel = explode("-", $row[9]);
$r_cell = explode("-", $row[10]);
$r_zip_code = explode("-", $row[11]);
$r_addr1 = $row[12];
$r_addr2 = $row[13];
$msg = $row[14];
$sign_kind = $row[15];
$bank_name = $row[16];
$rec_name = $row[17];
$rec_date = $row[18];
$sign_amt = $row[19];
$proc_st = $row[20];
$remit_st = $row[21];
$proc_name = $row[22];
$proc_data = $row[23];
$rtn_msg = $row[24];
$m_id = $row[25];
$sr_name = $row[26];
$docu = $row[27];
$saup_no = explode("-", $row[28]);
$b_email = $row[29];
$b_org_name = $row[30];
$r_org_name = $row[31];
$res_kind = $row[32];
$remit_amt = $row[33];
$saup_tae = $row[34];
$saup_jong = $row[35];
$t_id = $row[36];
$url = "member_write.php?job=M&m_kind=$m_kind&opt=$opt&wrd=$wrd&m_id=$m_id&yy1=$yy1&mm1=$mm1&dd1=$dd1&yy2=$yy2&mm2=$mm2&dd2=$dd2";
?>
주문상품에 대한 sql
<? $sql = "Select O.goods_name, O.price, O.qty, O.amt, G.sub_title1, G.show_date, G.running_time,O.gcode,O.seq ";
$sql .= "From order_detail O inner join k_goods G on O.gcode = G.gcode Where ord_no = $ord_no Order by seq ASC";
$rs = mysql_query($sql);
$rows = 0;
$bgcolor = "f8f8f8";
$tot = 0;
while($row = mysql_fetch_row($rs)) {
$goods_name = $row[0];
$price = $row[1];
$qty = $row[2];
$amt = $row[3];
$sub_title2 = $row[4];
$show_date = $row[5];
$running_time = $row[6];
$gcode = $row[7];
$seq = $row[8];
if ($show_date == "--") $show_date = "";
?> |
