주문출력을 할때 희망배송날짜도 출력하고 싶은데 어찌하면 되나요?
주문번호가 주문날짜인것은 알겠습니다. 주문날짜말고 희망배송날짜를 출력하기를 원합니다.
주문번호가 주문날짜인것은 알겠습니다. 주문날짜말고 희망배송날짜를 출력하기를 원합니다.
댓글 2개
adm/shop_admin/orderprintresult.php 를
// MS엑셀 XLS 데이터로 다운로드 받음
if ($csv == 'xls')
{
$fr_date = date_conv($fr_date);
$to_date = date_conv($to_date);
$sql = " SELECT od_name, od_tel, od_hp, od_zip1, od_zip2, od_addr1, od_addr2, od_b_zip1, od_b_zip2, od_b_addr1, od_b_addr2, od_b_name, od_b_tel, od_b_hp, it_name, ct_qty, b.it_id, a.od_id, od_memo, od_invoice, od_hope_date
FROM $g4[yc4_order_table] a, $g4[yc4_cart_table] b, $g4[yc4_item_table] c
where a.on_uid = b.on_uid
and b.it_id = c.it_id ";
if ($case == 1) // 출력기간
$sql .= " and a.od_time between '$fr_date 00:00:00' and '$to_date 23:59:59' ";
else // 주문번호구간
$sql .= " and a.od_id between '$fr_od_id' and '$to_od_id' ";
if ($ct_status)
$sql .= " and b.ct_status = '$ct_status' ";
$sql .=" order by od_time asc ";
$result = sql_query($sql);
$cnt = @mysql_num_rows($result);
if (!$cnt)
alert("출력할 내역이 없습니다.");
header("Content-charset=$g4[charset]");
header('Content-Type: application/vnd.ms-excel');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename="' . date("ymd", time()) . '.xls"');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
echo "<html>";
echo "<head>";
echo "<title>xls</title>";
echo "<style>.txt {mso-number-format:'\\@';}</style>";
echo "</head>";
echo "<body>";
echo "<table border='1'>";
echo "<tr>";
echo "<td>주문자우편번호</td>";
echo "<td>주문자주소</td>";
echo "<td>주문자이름</td>";
echo "<td>주문자전화1</td>";
echo "<td>주문자전화2</td>";
echo "<td>받는사람우편번호</td>";
echo "<td>받는사람주소</td>";
echo "<td>받는사람이름</td>";
echo "<td>전화1</td>";
echo "<td>전화2</td>";
echo "<td>상품명</td>";
echo "<td>수량</td>";
echo "<td>상품코드</td>";
echo "<td>주문번호</td>";
echo "<td>운송장번호</td>";
echo "<td>희망배송일</td>";
echo "<td>전하실말씀</td>";
echo "</tr>";
for ($i=0; $row=mysql_fetch_array($result); $i++)
{
$it_name = stripslashes($row[it_name]) . "<br />";
$it_name .= print_item_options($row[it_id], $row[it_opt1], $row[it_opt2], $row[it_opt3], $row[it_opt4], $row[it_opt5], $row[it_opt6]);
echo "<tr>";
echo "<td>" . $row[od_zip1] . '-' . $row[od_zip2] . "</td>";
echo "<td>" . $row[od_addr1] . '-' . $row[od_addr2] . "</td>";
echo "<td>" . $row[od_name] . "</td>";
echo "<td class='txt'>" . $row[od_tel] . "</td>";
echo "<td class='txt'>" . $row[od_hp] . "</td>";
echo "<td>" . $row[od_b_zip1] . '-' . $row[od_b_zip2] . "</td>";
echo "<td>" . $row[od_b_addr1] . ' ' . $row[od_b_addr2] . "</td>";
echo "<td>" . $row[od_b_name] . "</td>";
echo "<td class='txt'>" . $row[od_b_tel] . "</td>";
echo "<td class='txt'>" . $row[od_b_hp] . "</td>";
echo "<td>" . $it_name . "</td>";
echo "<td>" . $row[ct_qty] . "</td>";
echo "<td class='txt'>" . $row[it_id] . "</td>";
echo "<td class='txt'>'" . urlencode($row[od_id]) . "'</td>";
echo "<td class='txt'>" . $row[od_invoice] . "</td>";
echo "<td>" . $row[od_hope_date] . "</td>";
echo "<td>" . $row[od_memo] . "</td>";
echo "</tr>";
}
if ($i == 0)
echo "<tr><td colspan='11'>자료가 없습니다.</td></tr>";
echo "</table>";
echo "</body>";
echo "</html>";
exit;
}
이렇게 수정해 보았습니다.
// MS엑셀 XLS 데이터로 다운로드 받음
if ($csv == 'xls')
{
$fr_date = date_conv($fr_date);
$to_date = date_conv($to_date);
$sql = " SELECT od_name, od_tel, od_hp, od_zip1, od_zip2, od_addr1, od_addr2, od_b_zip1, od_b_zip2, od_b_addr1, od_b_addr2, od_b_name, od_b_tel, od_b_hp, it_name, ct_qty, b.it_id, a.od_id, od_memo, od_invoice, od_hope_date
FROM $g4[yc4_order_table] a, $g4[yc4_cart_table] b, $g4[yc4_item_table] c
where a.on_uid = b.on_uid
and b.it_id = c.it_id ";
if ($case == 1) // 출력기간
$sql .= " and a.od_time between '$fr_date 00:00:00' and '$to_date 23:59:59' ";
else // 주문번호구간
$sql .= " and a.od_id between '$fr_od_id' and '$to_od_id' ";
if ($ct_status)
$sql .= " and b.ct_status = '$ct_status' ";
$sql .=" order by od_time asc ";
$result = sql_query($sql);
$cnt = @mysql_num_rows($result);
if (!$cnt)
alert("출력할 내역이 없습니다.");
header("Content-charset=$g4[charset]");
header('Content-Type: application/vnd.ms-excel');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename="' . date("ymd", time()) . '.xls"');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
echo "<html>";
echo "<head>";
echo "<title>xls</title>";
echo "<style>.txt {mso-number-format:'\\@';}</style>";
echo "</head>";
echo "<body>";
echo "<table border='1'>";
echo "<tr>";
echo "<td>주문자우편번호</td>";
echo "<td>주문자주소</td>";
echo "<td>주문자이름</td>";
echo "<td>주문자전화1</td>";
echo "<td>주문자전화2</td>";
echo "<td>받는사람우편번호</td>";
echo "<td>받는사람주소</td>";
echo "<td>받는사람이름</td>";
echo "<td>전화1</td>";
echo "<td>전화2</td>";
echo "<td>상품명</td>";
echo "<td>수량</td>";
echo "<td>상품코드</td>";
echo "<td>주문번호</td>";
echo "<td>운송장번호</td>";
echo "<td>희망배송일</td>";
echo "<td>전하실말씀</td>";
echo "</tr>";
for ($i=0; $row=mysql_fetch_array($result); $i++)
{
$it_name = stripslashes($row[it_name]) . "<br />";
$it_name .= print_item_options($row[it_id], $row[it_opt1], $row[it_opt2], $row[it_opt3], $row[it_opt4], $row[it_opt5], $row[it_opt6]);
echo "<tr>";
echo "<td>" . $row[od_zip1] . '-' . $row[od_zip2] . "</td>";
echo "<td>" . $row[od_addr1] . '-' . $row[od_addr2] . "</td>";
echo "<td>" . $row[od_name] . "</td>";
echo "<td class='txt'>" . $row[od_tel] . "</td>";
echo "<td class='txt'>" . $row[od_hp] . "</td>";
echo "<td>" . $row[od_b_zip1] . '-' . $row[od_b_zip2] . "</td>";
echo "<td>" . $row[od_b_addr1] . ' ' . $row[od_b_addr2] . "</td>";
echo "<td>" . $row[od_b_name] . "</td>";
echo "<td class='txt'>" . $row[od_b_tel] . "</td>";
echo "<td class='txt'>" . $row[od_b_hp] . "</td>";
echo "<td>" . $it_name . "</td>";
echo "<td>" . $row[ct_qty] . "</td>";
echo "<td class='txt'>" . $row[it_id] . "</td>";
echo "<td class='txt'>'" . urlencode($row[od_id]) . "'</td>";
echo "<td class='txt'>" . $row[od_invoice] . "</td>";
echo "<td>" . $row[od_hope_date] . "</td>";
echo "<td>" . $row[od_memo] . "</td>";
echo "</tr>";
}
if ($i == 0)
echo "<tr><td colspan='11'>자료가 없습니다.</td></tr>";
echo "</table>";
echo "</body>";
echo "</html>";
exit;
}
이렇게 수정해 보았습니다.
게시글 목록
| 번호 | 제목 |
|---|---|
| 56073 | |
| 56067 | |
| 56065 | |
| 56060 | |
| 56058 | |
| 56055 | |
| 56051 | |
| 56048 | |
| 56044 | |
| 56043 | |
| 56042 | |
| 56039 | |
| 56035 | |
| 56032 | |
| 56030 | |
| 56028 | |
| 56025 | |
| 56018 | |
| 56012 | |
| 56010 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기