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)
