<?
require_once('../prepare.php');

function support_reg( $p )
{
    $this->db = u4user_open();
    $user_prof = get_UserDetail_uid($this->db,$p['uid']);
    u4user_close($this->db);
            
    if(empty($user_prof['email'])){
        switch($p['carrier']){
            case "i":
                $arg = "&uid=NULLGWDOCOMO";
                break;
            default:
                $arg = "";
                break;
        }
        header("Location: ".KTY_BASE_URL."/mail/mail_send.php?contents=support".$arg);
        exit;
    }

    //--- 新規 or 再問合せで処理分岐
    $this->db_support = sp4inq_open();

    // 2005.05.23 Wataru Add
    $p['subject'] = mb_convert_kana($p['subject'],"KV");
    $p['body'] = mb_convert_kana($p['body'],"KV");
    
    if('0' == $p['type']){
        //- 登録データ配列作成
        $add_data = array(
                        'customer_id' => $user_prof['email'],
                        'genre_id' => $p['genre_id'],
                        'title' => $p['subject'],
                        'content' => $p['body'],
                        'sub_status' => $p['p_no'],
                        'ip_address' => $_SERVER['HTTP_X_FORWARDED_FOR'],
                        'browser' => $_SERVER['HTTP_USER_AGENT']
                    );

        //- 問い合わせインサート
        $inq_id = sp4inq_reg($this->db_support,$add_data);

	    if(!is_numeric($inq_id)){
		    bsc_error('送信に失敗しました。再度問合せを行ってください。',$p,'guide/support_top.php');
		    exit;	
	    }

        $genre_id = $p['genre_id'];
        
    }elseif('1' == $p['type']){
        //- 登録データ配列作成
        $add_data = array(
                        'customer_id' => $p['email'],
                        'content' => $p['body'],
                        'inquiry_id' => $p['inq_id']
                    );
        $inq_id = sp4inq_reg_reply($this->db_support,$add_data);

        //- ND/生産者宛メール本文用に全関連メール本文を取得
        $inq_all = sp4inq_history($this->db_support,$p['inq_id']);
        $genre_id = $inq_all[0]['genre_id'];
        $inq_id = $p['inq_id'];

    }

    //- サポートジャンル取得
    $genre_arr = sp4inq_genre_list($this->db_support);
    foreach($genre_arr as $key => $val){
        if($genre_id == $val['id']){
            $genre_name = $val['name'];
        }
    }

    
    sp4inq_close($this->db_support);
    
    //- ND向けメール作成・発射
    $msg = "";

    if(empty($p['p_no'])){
        //-- サイトへの問合せの場合
        if('0' == $p['type']){
        //- 新規問い合わせメール
            $address_to = constant('MAILADDR_ND_SUPPORT');
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
        
            $subject = "【カツ代の家庭料理】サイト新規お問合せ";
            $msg = "\n";
            $msg.= "以下、カツ代の家庭料理へ新規お問合せがありました。\n";
            $msg.= "\n";
            $msg.= sprintf("お問合せ番号　　：%s\n",$inq_id);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            $msg.= sprintf("お問合せタイトル：%s\n",$p['subject']);
            $msg.= sprintf("お問合せ内容　　：%s\n",$p['body']);

            $nd_mail['to'] = $address_to;
            $nd_mail['from'] = $address_from;
            $nd_mail['subject'] = $subject;
            //$nd_mail['message'] = mb_convert_kana($msg,"KV");
            $nd_mail['message'] = $msg;

		if($_SERVER['SERVER_NAME'] == "m.katsuyo.net"){

            bsc_send_mail_pear($nd_mail);
		}
    
        }elseif('1' == $p['type']){
        //- 再問い合わせメール
            $address_to = constant('MAILADDR_ND_SUPPORT');
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
    
            $subject = "【カツ代の家庭料理】サイト再お問合せ";
            $msg = "\n";
            $msg.= "以下、カツ代の家庭料理へ再お問合せがありました。\n";
            $msg.= "\n";
            $msg.= sprintf("お問合せ番号　　：%s\n",$inq_id);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);

            $res_no = 1;
            for($s=0;$s<count($inq_all);$s++){
                if($s == '0'){
                    $msg.= sprintf("お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('0' == $inq_all[$s]['type']){
                    $msg.= sprintf("再お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('1' == $inq_all[$s]['type']){
                    //- 再問合せURL部分を切り落とす
                    $content = $inq_all[$s]['content'];
                    $trush_pos = strpos($content,"http://m.bishoku.com/support/");
                    if($trush_pos){
                        $content = substr($content,0,$trush_pos);
                    }
                    $msg.= sprintf("回答%d　　：%s\n",$res_no,$content);
                    $res_no++;
                }
                $msg.= "";
            }

            $nd_mail['to'] = $address_to;
            $nd_mail['from'] = $address_from;
            $nd_mail['subject'] = $subject;
            //$nd_mail['message'] = mb_convert_kana($msg,"KV");
            $nd_mail['message'] = $msg;

		if($_SERVER['SERVER_NAME'] == "m.katsuyo.net"){

            bsc_send_mail_pear($nd_mail);
		}

        }

/*
    }elseif(!empty($p['p_no']) && empty($p['mode'])){

    //-- 商品問合せの場合
        $date_str = date("Y/m/d H:i");
        $this->db = cs4_open();
        $item_detail = get_item_detail($this->db,$p['p_no'],1);
        $pdc_detail = get_producer_detail($this->db,$item_detail['pdc_no']);
        cs4_close($this->db);
        
        if('0' == $p['type']){
        //- 新規問い合わせメール
            //- ND宛
            $address_to = constant('MAILADDR_ND_SUPPORT');
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
    
            $subject = "【カツ代の家庭料理i-mode】商品に関するお問合せ";
            $msg = "以下の商品情報に関してユーザ様よりお問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ日時　　：%s\n",$date_str);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            $msg.= "\n";
            $msg.= sprintf("お問合せ商品　　：%s\n",$item_detail['p_nm']);
            $msg.= sprintf("お問合せ生産者　：%s\n",$pdc_detail['pdc_nm']);
            $msg.= sprintf("お問合せタイトル：%s\n",$p['subject']);
            $msg.= sprintf("お問合せ内容　　：%s\n",$p['body']);

            $nd_mail['to'] = $address_to;
            $nd_mail['from'] = $address_from;
            $nd_mail['subject'] = $subject;
            //$nd_mail['message'] = mb_convert_kana($msg,"KV");
            $nd_mail['message'] = $msg;

            bsc_send_mail_pear($nd_mail);
            
            //- 生産者宛
            $address_to = $pdc_detail['pdc_eml'];
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
    
            // インターファックス対応
            $now_time = intval(date("H"));
            if(($pdc_detail['pdc_contact'] == 2) and ($now_time < 8) and ($now_time >= 22)){
                $subject = "【カツ代の家庭料理】商品に関するお問合せ /d 9:00";
            }else{
                $subject = "【カツ代の家庭料理】商品に関するお問合せ";
            }

            $msg = "\n";
            $msg = "以下の商品情報に関してサイト利用者様よりお問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ日時　　：%s\n",$date_str);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            $msg.= "\n";
            $msg.= sprintf("お問合せ商品　　：%s\n",$item_detail['p_nm']);
            $msg.= sprintf("お問合せ生産者　：%s\n",$pdc_detail['pdc_nm']);
            $msg.= sprintf("お問合せタイトル：%s\n",$p['subject']);
            $msg.= sprintf("お問合せ内容　　：%s\n",$p['body']);


            $pdc_mail['to'] = $address_to;
            $pdc_mail['from'] = $address_from;
            $pdc_mail['subject'] = $subject;
            //$pdc_mail['message'] = mb_convert_kana($msg,"KV");
            $pdc_mail['message'] = $msg;

            bsc_send_mail_pear($pdc_mail);

        }elseif(('1' == $p['type']) || (!array_key_exists('type',$p))){
        //- 再問い合わせメール(ND)
            //- ND宛
            $address_to = constant('MAILADDR_ND_SUPPORT');
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
    
            $subject = "【カツ代の家庭料理i-mode】商品に関する再お問合せ";
            $msg = "\n";
            $msg = "以下の商品情報に関してユーザ様より再お問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ番号　　：%s\n",$inq_id);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            
            $res_no = 1;
            for($s=0;$s<count($inq_all);$s++){
                if($s == '0'){
                    $msg.= sprintf("お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('0' == $inq_all[$s]['type']){
                    $msg.= sprintf("再お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('1' == $inq_all[$s]['type']){
                    //- 再問合せURL部分を切り落とす
                    $content = $inq_all[$s]['content'];
                    $trush_pos = strpos($content,"http://m.bishoku.com/support/");
                    if($trush_pos){
                        $content = substr($content,0,$trush_pos);
                    }
                    $msg.= sprintf("回答%d　　：%s\n",$res_no,$content);
                    $res_no++;
                }
                $msg.= "";
            }

            $nd_mail['to'] = $address_to;
            $nd_mail['from'] = $address_from;
            $nd_mail['subject'] = $subject;
            //$nd_mail['message'] = mb_convert_kana($msg,"KV");
            $nd_mail['message'] = $msg;

            bsc_send_mail_pear($nd_mail);
            
            //- 生産者宛
            $address_to = $pdc_detail['pdc_eml'];
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);


            // インターファックス対応
            $now_time = intval(date("H"));
            if(($pdc_detail['pdc_contact'] == 2) and ($now_time < 8) and ($now_time >= 22)){
                $subject = "【カツ代の家庭料理】商品に関する再お問合せ /d 9:00";
            }else{
                $subject = "【カツ代の家庭料理】商品に関する再お問合せ";
            }

            $msg = "\n";
            $msg = "以下の商品情報に関してユーザ様より再お問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ番号　　：%s\n",$inq_id);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            
            $res_no = 1;
            for($s=0;$s<count($inq_all);$s++){
                if($s == '0'){
                    $msg.= sprintf("お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('0' == $inq_all[$s]['type']){
                    $msg.= sprintf("再お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('1' == $inq_all[$s]['type']){
                    //- 再問合せURL部分を切り落とす
                    $content = $inq_all[$s]['content'];
                    $trush_pos = strpos($content,"http://m.bishoku.com/support/");
                    if($trush_pos){
                        $content = substr($content,0,$trush_pos);
                    }
                    $msg.= sprintf("回答%d　　：%s\n",$res_no,$content);
                    $res_no++;
                }
                $msg.= "";
            }

            $pdc_mail['to'] = $address_to;
            $pdc_mail['from'] = $address_from;
            $pdc_mail['subject'] = $subject;
            //$pdc_mail['message'] = mb_convert_kana($msg,"KV");
            $pdc_mail['message'] = $msg;

            bsc_send_mail_pear($pdc_mail);
        }
    }elseif(!empty($p['p_no']) && !empty($p['mode'])){

    //-- 購入商品問合せ
        $date_str = date("Y/m/d H:i");
        $this->db = cs4_open();
        $item_detail = get_item_detail($this->db,$p['p_no'],1);
        $pdc_detail = get_producer_detail($this->db,$item_detail['pdc_no']);
        cs4_close($this->db);
        
        if('0' == $p['type']){
        //- 新規問い合わせメール
            //- ND宛
            $address_to = constant('MAILADDR_ND_SUPPORT');
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
    
            $subject = "【カツ代の家庭料理i-mode】購入商品に関するお問合せ";
            $msg = "以下の商品情報に関して購入者様よりお問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ日時　　：%s\n",$date_str);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            $msg.= "\n";
            $msg.= sprintf("お問合せ商品　　：%s\n",$item_detail['p_nm']);
            $msg.= sprintf("お問合せ生産者　：%s\n",$pdc_detail['pdc_nm']);
            $msg.= sprintf("お問合せタイトル：%s\n",$p['subject']);
            $msg.= sprintf("お問合せ内容　　：%s\n",$p['body']);

            $nd_mail['to'] = $address_to;
            $nd_mail['from'] = $address_from;
            $nd_mail['subject'] = $subject;
            //$nd_mail['message'] = mb_convert_kana($msg,"KV");
            $nd_mail['message'] = $msg;

            bsc_send_mail_pear($nd_mail);
            
            //- 生産者宛
            $address_to = $pdc_detail['pdc_eml'];
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);


            // インターファックス対応
            $now_time = intval(date("H"));
            if(($pdc_detail['pdc_contact'] == "2") and ($now_time < 8) and ($now_time >= 22)){
                $subject = "【カツ代の家庭料理】購入商品に関するお問合せ /d 9:00";
            }else{
                $subject = "【カツ代の家庭料理】購入商品に関するお問合せ";
            }
    
            $msg = "以下の商品情報に関して購入者様よりお問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ日時　　：%s\n",$date_str);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            $msg.= "\n";
            $msg.= sprintf("お問合せ商品　　：%s\n",$item_detail['p_nm']);
            $msg.= sprintf("お問合せ生産者　：%s\n",$pdc_detail['pdc_nm']);
            $msg.= sprintf("お問合せタイトル：%s\n",$p['subject']);
            $msg.= sprintf("お問合せ内容　　：%s\n",$p['body']);

            $pdc_mail['to'] = $address_to;
            $pdc_mail['from'] = $address_from;
            $pdc_mail['subject'] = $subject;
            //$pdc_mail['message'] = mb_convert_kana($msg,"KV");
            $pdc_mail['message'] = $msg;

            bsc_send_mail_pear($pdc_mail);

        }elseif('1' == $p['type']){
        //- 再問い合わせメール
            //- ND宛
            $address_to = constant('MAILADDR_ND_SUPPORT');
            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);
    
            $subject = "【カツ代の家庭料理i-mode】購入商品に関する再お問合せ";
            $msg = "\n";
            $msg = "以下の商品情報に関して購入者様より再お問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ番号　　：%s\n",$inq_id);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            
            $res_no = 1;
            for($s=0;$s<count($inq_all);$s++){
                if($s == '0'){
                    $msg.= sprintf("お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('0' == $inq_all[$s]['type']){
                    $msg.= sprintf("再お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('1' == $inq_all[$s]['type']){
                    //- 再問合せURL部分を切り落とす
                    $content = $inq_all[$s]['content'];
                    $trush_pos = strpos($content,"http://m.bishoku.com/support/");
                    if($trush_pos){
                        $content = substr($content,0,$trush_pos);
                    }
                    $msg.= sprintf("回答%d　　：%s\n",$res_no,$content);
                    $res_no++;
                }
                $msg.= "";
            }

            $nd_mail['to'] = $address_to;
            $nd_mail['from'] = $address_from;
            $nd_mail['subject'] = $subject;
            //$nd_mail['message'] = mb_convert_kana($msg,"KV");
            $nd_mail['message'] = $msg;

            bsc_send_mail_pear($nd_mail);
            
            //- 生産者宛
            $address_to = $pdc_detail['pdc_eml'];

            $address_from = constant('MAILADDR_ND_SUPPORT');
            $add_header = "";
            $add_header .= sprintf("From: %s\n",$address_from);
            $add_header .= sprintf("Reply-To: %s\n",$address_from);
            $add_header .= sprintf("Return-Path: <%s>\n",$address_from);

            // インターファックス対応
            $now_time = intval(date("H"));
            if(($pdc_detail['pdc_contact'] == 2) and ($now_time < 8) and ($now_time >= 22)){
                $subject = "【カツ代の家庭料理】購入商品に関する再お問合せ /d 9:00";
            }else{
                $subject = "【カツ代の家庭料理】購入商品に関する再お問合せ";
            }
    
            $msg = "\n";
            $msg = "以下の商品情報に関して購入者様より再お問合せがありました。";
            $msg.= "\n";
            $msg.= sprintf("お問合せ番号　　：%s\n",$inq_id);
            $msg.= sprintf("お問合せユーザ　：%s\n",$p['uid']);
            
            $res_no = 1;
            for($s=0;$s<count($inq_all);$s++){
                if($s == '0'){
                    $msg.= sprintf("お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('0' == $inq_all[$s]['type']){
                    $msg.= sprintf("再お問合せ内容　　：%s\n",$inq_all[$s]['content']);
                }elseif('1' == $inq_all[$s]['type']){
                    //- 再問合せURL部分を切り落とす
                    $content = $inq_all[$s]['content'];
                    $trush_pos = strpos($content,"http://m.bishoku.com/support/");
                    if($trush_pos){
                        $content = substr($content,0,$trush_pos);
                    }
                    $msg.= sprintf("回答%d　　：%s\n",$res_no,$content);
                    $res_no++;
                }
                $msg.= "";
            }

            $pdc_mail['to'] = $address_to;
            $pdc_mail['from'] = $address_from;
            $pdc_mail['subject'] = $subject;
            //$pdc_mail['message'] = mb_convert_kana($msg,"KV");
            $pdc_mail['message'] = $msg;

            bsc_send_mail_pear($pdc_mail);

        }
*/
    }
    
	$template =& loadTemplate( $p );

	$template->show();
	

}

support_reg( $p );

?>