if ($row['it_sc_type'] == 2) { $sendcost = get_item_sendcost($row['it_id'], $sum['price'], $sum['qty'], $row['od_id']); if ($sendcost == 0) { $ct_send_cost = '무료'; } } $save_it_id = $row['it_id']; $ct_send_cost = iconv_euckr($ct_send_cost); } echo '"' . $row['od_b_zip1'] . $row['od_b_zip2'] . '"' . ','; echo '"' . print_address($row['od_b_addr1'], $row['od_b_addr2'], $row['od_b_addr3'], $row['od_b_addr_jibeon']) . '"' . ','; echo '"' . $row['od_b_name'] . '"' . ','; //echo '"'.multibyte_digit((string)$row[od_b_tel]).'"'.','; //echo '"'.multibyte_digit((string)$row[od_b_hp]).'"'.','; echo '"' . conv_telno($row['od_b_tel']) . '"' . ','; echo '"' . conv_telno($row['od_b_hp']) . '"' . ','; echo '"' . preg_replace("/\"/", """, $row['it_name']) . '"' . ','; echo '"' . $row['ct_qty'] . '"' . ','; echo '"' . $row['ct_option'] . '"' . ','; echo '"' . $ct_send_cost . '"' . ','; echo '"\'' . $row['it_id'] . '\'"' . ','; echo '"\'' . $row['od_id'] . '\'"' . ','; echo '"' . $row['od_invoice'] . '"' . ','; //echo '"'.preg_replace("/\"/", """, preg_replace("/\n/", "", $row[od_memo])).'"'; echo '"' . preg_replace("/\"/", """, $row['od_memo']) . '"'; echo "\n"; } if ($i == 0) { echo '자료가 없습니다.' . PHP_EOL; } exit;
if ($sendcost == 0) { $ct_send_cost = '무료'; } } $save_it_id = $row['it_id']; $ct_send_cost = iconv_euckr($ct_send_cost); } $row = array_map('iconv_euckr', $row); // 150811 나진수 앞에 뛰어쓰기 공백 없앰 우편번호만 문자형태로 변형 액셀은 공백이 있으면 문자형태로 변형됨 $worksheet->write($i, 0, $row['od_id'] . ' '); $worksheet->write($i, 1, $row['od_b_name']); $worksheet->write($i, 2, $row['it_name']); $worksheet->write($i, 3, $row['ct_option']); $worksheet->write($i, 4, $row['ct_qty']); $worksheet->write($i, 5, $row['od_b_name']); $worksheet->write($i, 6, conv_telno($row['od_b_hp'])); $worksheet->write($i, 7, $row['od_b_zip1'] . $row['od_b_zip2'] . ' '); $worksheet->write($i, 8, print_address($row['od_b_addr1'], $row['od_b_addr2'], $row['od_b_addr3'], $row['od_b_addr_jibeon'])); $worksheet->write($i, 9, $row['od_delivery_company']); $worksheet->write($i, 10, $row['od_invoice']); $worksheet->write($i, 11, $row['od_memo']); } $workbook->close(); header("Content-Type: application/x-msexcel; name=\"orderlist-" . date("ymd", time()) . ".xls\""); header("Content-Disposition: inline; filename=\"orderlist-" . date("ymd", time()) . ".xls\""); $fh = fopen($fname, "rb"); fpassthru($fh); unlink($fname); exit; } function get_order($od_id)