<?php
include "../../module/login/head.php";
include "../lib/option.php";
if(!class_exists("AppMain")) include_once '../../module/classes/class.AppMain.php';
if(!class_exists("Board")) include_once '../../module/classes/class.Board.php';
if(!class_exists("UtilCommon")) include_once '../../module/classes/class.UtilCommon.php';
if(!class_exists("DirectZip")) include_once '../../module/classes/cla_directzip.php';
if(!class_exists("Msg")) include_once '../../module/classes/class.Msg.php';
function mb_basename($path) { return end(explode('/',$path)); } 
function utf2euc($str) { return iconv("UTF-8","cp949//IGNORE", $str); }
function is_ie() {
    if(!isset($_SERVER['HTTP_USER_AGENT']))return false;
    if(strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false) return true; // IE8
    if(strpos($_SERVER['HTTP_USER_AGENT'], 'Windows NT 6.1') !== false) return true; // IE11
    return false;
}
$db = new DbCon();
$dbconn = $db->getConnection();
$appMain = new AppMain($dbconn, 'tb_qna');
    $util = new UtilCommon();
    // 트랙잭션.
    $success = true;
    $result = @mysql_query("SET AUTOCOMMIT=0", $dbconn);
    $result = @mysql_query("BEGIN", $dbconn);
    /* $q_phone_1 = (is_numeric($q_phone_1)) ? $q_phone_1 : "000";
    $q_phone_2 = (is_numeric($q_phone_2)) ? $q_phone_2 : "0000";
    $q_phone_3 = (is_numeric($q_phone_3)) ? $q_phone_3 : "0000"; */
    
    $q_phone = $q_phone_1 . "-" . $q_phone_2 . "-" . $q_phone_3;
    
    $info['board_type'] = 'Q_COMP';
    $info['acode']=$util->clear_xss($sigun);
    $info['q_phone']=$util->clear_xss($q_phone);
    $info['q_name']= $util->clear_xss($q_name);
    $info['q_comp_name']= $util->clear_xss($q_comp_name);
    $info['q_email'] = $util->clear_xss($q_email);
    $info['q_content']= $util->clear_xss($q_content);
    $info['insert_type']= $util->clear_xss($insert_type);
    $info['q_delete_yn']= 'N';
    $info['q_answer_yn']= 'N';
    $info['q_regist_date']= date('Y-m-d H:i:s');
    
    
    $result = $appMain->inserQna($info);
    $menu_type = '1';
    $sql="select * from tb_menu_mail where menu_type='".$menu_type."' ";
    $result=mysql_query($sql,$dbconn);
    $row=mysql_fetch_array($result);
    $send_mail=$row['send_mail'];
    $request_name=$info['q_name'];
    $request_phone=$info['q_phone'];
    $e_email = $info['q_email'];
    $subj =  $info['q_comp_name'];
    $cont = $info['q_content'];
    include "./send_mail.php";
    if($result) {
        echo json_encode(array('result' => 'true','msg'=> 'We received your inquiry. I will reply after confirmation.'));
    } else {
        $success = false;
        echo json_encode(array('result' => 'false','msg'=> 'Registration failed. Please refresh the page and try again.'));
    }
if(!$success) {
    $result = @mysql_query("ROLLBACK", $dbconn);
} else {
    $result = @mysql_query("COMMIT", $dbconn);
}

$db->close($dbconn);
unset($db);
?>