add_filter('gnucommerce_get_order_query_fields', 'custom_gnucommerce_add_order_fields');
 
function custom_gnucommerce_add_order_fields($fields){
 
    $fields[] = 'od_receipt_price';     //결제한금액
    $fields[] = 'od_cart_price';     //총 상품 금액
    $fields[] = 'od_send_cost';     //배송비
    $fields[] = 'od_send_cost2';     //추가 배송비
    $fields[] = 'od_shop_memo';         //상점메모
 
    return $fields;
}
 
add_action('gnucommerce_export_orderdata', 'custom_gnucommerce_export_xml', 10, 3);
 
function custom_gnucommerce_export_xml($params, $csv, $gc_order){
    global $wpdb;
 
    if( !class_exists('gnucommerce') ){  //그누커머스 플러그인이 있으면
        return;
    }
 
    if ($csv == 'xls'){     //엑셀인경우
        
        extract($params);
 
        if( !gc_get_upload_path() ) {
            gc_alert(__('데이터 쓰기 권한이 없습니다.', GC_NAME));
        }
        $fr_date = gc_date_conv($fr_date);
        $to_date = gc_date_conv($to_date);
 
        $get_order = $gc_order->get_order_query($fr_date, $to_date, $fr_od_id, $to_od_id, $ct_status, $case);
        extract($get_order);
 
        if (!$cnt)
            gc_alert(__('출력할 내역이 없습니다.', GC_NAME));
 
        /*================================================================================
        php_writeexcel http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/
        =================================================================================*/
 
        include_once(GC_DIR_PATH.'lib/Excel/php_writeexcel/class.writeexcel_workbook.inc.php');
        include_once(GC_DIR_PATH.'lib/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php');
 
        $fname = tempnam(gc_get_upload_path().'/tmp/', "tmp-orderlist.xls");
 
        $workbook = new writeexcel_workbook($fname);
        $worksheet = $workbook->addworksheet();
 
        // Put Excel data
        $data = array('우편번호', '주소', '이름', '전화1', '전화2', '상품명', '수량', '선택사항', '배송비', '상품코드', '주문번호', '운송장번호', '전하실말씀', '주문합계', '상점메모');
        $data = array_map('gc_iconv_euckr', $data);
 
        $col = 0;
        foreach($data as $cell) {
            $worksheet->write(0, $col++, $cell);
        }
 
        $save_it_id = '';
        $i = 1;
        foreach($results as $row)
        {
            if( empty($row) ) continue;
 
            if($save_it_id != $row['it_id']) {
                // 합계금액 계산
 
                $sql = $wpdb->prepare(" select SUM(IF(io_type = 1, (io_price * ct_qty), ((ct_price + io_price) * ct_qty))) as price,
                                SUM(ct_qty) as qty
                            from {$gc['shop_cart_table']}
                            where it_id = %.0f
                              and od_id = %.0f ", $row['it_id'], $row['od_id']);
                
                $sum = $wpdb->get_row($sql, ARRAY_A);
 
                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 = gc_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 = gc_iconv_euckr($ct_send_cost);
            }
 
            $row = array_map('gc_iconv_euckr', $row);
            
            $worksheet->write($i, 0, ' '.$row['od_b_zip']);
            $worksheet->write($i, 1, gc_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['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']);        //주문합계(선불배송비포함)
            $worksheet->write($i, 14, $row['od_shop_memo']);            //상점메모
 
            $i++;
        }   //end foreach
 
        $workbook->close();
 
        header("Content-Type: application/x-msexcel; name=\"orderlist-".date("ymd", GC_SERVER_TIME).".xls\"");
        header("Content-Disposition: inline; filename=\"orderlist-".date("ymd", GC_SERVER_TIME).".xls\"");
        $fh=fopen($fname, "rb");
        fpassthru($fh);
        @unlink($fname);
 
        exit;
    }
 
}