orderprintresult.php 에서 엑셀로 다운할 때 가격이 노출되게하고 싶습니다.

$row['price'] 가 아니고 $sum['price'] 로 해야합니다

    소스 orderprintresult.php 중...156번라인? 쪽 보시면...

    빨간색 부분을 수정하시면 될거예요...

    ​​$worksheet->write($i, 13, $row['price']);​​ 은 뿌려주고자 하는 가격변수를 넣어주면 됩니다.

    include_once(G5_LIB_PATH.'/Excel/php_writeexcel/class.writeexcel_workbook.inc.php');
    include_once(G5_LIB_PATH.'/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php');

    $fname = tempnam(G5_DATA_PATH, "tmp-orderlist.xls");
    $workbook = new writeexcel_workbook($fname);
    $worksheet = $workbook->addworksheet();

    // Put Excel data
    $data = array('우편번호', '주소', '이름', '전화1', '전화2', '상품명', '수량', '선택사항', '배송비', '상품코드', '주문번호', '운송장번호', '전하실말씀', '가격');
    $data = array_map('iconv_euckr', $data);

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

    $save_it_id = '';
    for($i=1; $row=sql_fetch_array($result); $i++)
    {
        if($save_it_id != $row['it_id']) {
            // 합계금액 계산
            $sql = " select SUM(IF(io_type = 1, (io_price * ct_qty), ((ct_price + io_price) * ct_qty))) as price,
                            SUM(ct_qty) as qty
                        from {$g5['g5_shop_cart_table']}
                        where it_id = '{$row['it_id']}'
                          and od_id = '{$row['od_id']}' ";
            $sum = sql_fetch($sql);

            switch($row['ct_send_cost'])
            {
                case 1:
                    $ct_send_cost = '착불';
                    break;
                case 2:
                    $ct_send_cost = '무료';
                    break;
                default:
                    $ct_send_cost = '선불';
                    break;
            }

            // 조건부무료
            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);
        }

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

        $worksheet->write($i, 0, ' '.$row['od_b_zip1'].$row['od_b_zip2']);
        $worksheet->write($i, 1, print_address($row['od_b_addr1'], $row['od_b_addr2'], $row['od_b_addr3'], $row['od_b_addr_jibeon']));
        $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, $row['it_name']);
        $worksheet->write($i, 6, $row['ct_qty']);
        $worksheet->write($i, 7, $row['ct_option']);
        $worksheet->write($i, 8, $ct_send_cost);
        $worksheet->write($i, 9, ' '.$row['it_id']);
        $worksheet->write($i, 10, ' '.$row['od_id']);
        $worksheet->write($i, 11, $row['od_invoice']);
        $worksheet->write($i, 12, $row['od_memo']);

        ​$worksheet->write($i, 13, $row['price']);​
    }