orderprintresult.php 수정시 질문입니다. ftp 수정하였습니다. 죄송합니다.

orderprintresult.php의 출력중에서 몇가지 추가할 것이 있어서 추가하였는데요

아래의 사진과 같이 보내는사람의 이름이 안나옵니다.

잠시만 살펴주시길 바랍니다.

 

//header('Content-Type: text/x-csv');
    header("Content-charset=$g4[charset]");
    header('Content-Type: doesn/matter');
    header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    header('Content-Disposition: attachment; filename="' . date("ymd", time()) . '.csv"');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    //echo "우편번호,주소,이름,전화1,전화2,상품명,수량,비고,전하실말씀\n";
    if ("utf-8" == strtolower($g4[charset])) {
        echo "\xEF\xBB\xBF"; // UTF-8 + BOM
    }
    echo "우편번호,주소,이름,전화1,전화2,상품명,수량,상품코드,주문번호,운송장번호,전하실말씀,보내는사람,주소,전화번호,헨드폰\n";
    for ($i=0; $row=mysql_fetch_array($result); $i++)
    {
        echo '"' . $row[od_b_zip1] . '-' . $row[od_b_zip2] . '"' . ',';
        echo '"' . $row[od_b_addr1] . ' ' . $row[od_b_addr2] . '"' . ',';
        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[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 '"' . $row[od_name] . '"' . ',';
  echo '"' . $row[od_addr1] . '"' . $row[od_addr2] . '""' . ',';
  echo '"' . $row[od_tel] . '"' . ',';
  echo '"' . $row[od_hp] . '"' . ',';
  echo "\n";
    }
    if ($i == 0)
        echo "자료가 없습니다.\n";

    exit;
}

 

// Put Excel data
    $data = array('우편번호', '주소', '이름', '전화1', '전화2', '상품명', '수량', '상품코드', '주문번호', '운송장번호', '전하실말씀','보내는사람','주소','전화번호','헨드폰');
    $data = array_map('iconv_euckr', $data);

    $col = 0;
    foreach($data as $cell) {
        $worksheet->write(0, $col++, $cell);
    }

    $i=0;
    while ($row=mysql_fetch_array($result))
    {
        $sql2 = " select "._MISU_QUERY_." from $g4[yc4_order_table] a, $g4[yc4_cart_table] b where a.on_uid = b.on_uid and a.od_id = '$row[od_id]' ";
        $row2 = sql_fetch($sql2);
        if ($row2[misu]) continue;

        $row = array_map('iconv_euckr', $row);

        $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]);

        if ($csv == "xls2") {
            $it_name = str_replace(array("&nbsp;", "\\n"), "", $it_name);
            $it_name = strip_tags($it_name);
        }

        $i++;

        $worksheet->write($i, 0, $row['od_b_zip1'].'-'.$row['od_b_zip2']);
        $worksheet->write($i, 1, $row['od_b_addr1'].' '.$row['od_b_addr2']);
        $worksheet->write($i, 2, $row['od_b_name']);
        $worksheet->write($i, 3, $row['od_b_tel']);
        $worksheet->write($i, 4, $row['od_b_hp']);
        $worksheet->write($i, 5, $it_name);
        $worksheet->write($i, 6, $row['ct_qty']);
        $worksheet->write($i, 7, $row['it_id']);
        $worksheet->write($i, 8, $row['od_id']);
        $worksheet->write($i, 9, $row['od_invoice']);
        $worksheet->write($i, 10, $row['od_memo']);
  $worksheet->write($i, 11, $row['od_name']);
  $worksheet->write($i, 12, $row['od_addr1'].' '.$row['od_addr2']);
  $worksheet->write($i, 13, $row['od_tel']);
  $worksheet->write($i, 14, $row['od_hp']);
    }