webadmin.php

/home/mjc1/public_html/manage/cs3_reqBoardEnd.php

<?   
include("./_common.php");
include("category/common.php");

@extract($_POST);

$uid = $_REQUEST['uid'];
$r_id = $_REQUEST['smoption'];

function mail_log_write($post, $mail){ // post, mail 로그
    Global $r_id;
    if($post!=''){
        ob_start();
        print_r($post);
        $res = ob_get_contents();
        ob_end_clean();
        //$res = iconv("euckr","utf-8",$res);
    }
    if($mail!=""){
        ob_start();
        print_r($mail);
        echo chr(10).chr(13);
        $res = ob_get_contents();
        ob_end_clean();
    }
    
    

    $datetime = date("[Y-m-d H:i:s]",time());
    $date_dir = date("Y-m-d",time());
    $month_dir = date("Y-m",time());
    $file_name = "M_{$r_id}-{$date_dir}";

    @mkdir($_SERVER['DOCUMENT_ROOT']."/sql_log/cs3_req_mail_log/{$month_dir}");
    @chmod($_SERVER['DOCUMENT_ROOT']."/sql_log/cs3_req_mail_log/{$month_dir}",0707);

    $fp = fopen($_SERVER['DOCUMENT_ROOT']."/sql_log/cs3_req_mail_log/{$month_dir}/{$file_name}",'a');
    fwrite($fp,$datetime.chr(10).$res);
    fclose($fp);

    @chmod($_SERVER['DOCUMENT_ROOT']."/sql_log/cs3_req_mail_log/{$month_dir}/{$file_name}",0707);

    if($handle = opendir($_SERVER['DOCUMENT_ROOT']."/sql_log/cs3_req_mail_log/")) {
        while(false !== ($entry = readdir($handle))) {
            if($entry == '.' || $entry == '..')
                continue;

            $path = $_SERVER['DOCUMENT_ROOT']."/sql_log/cs3_req_mail_log/".$entry;

            if(is_dir($path))
                $directory[] = $path;
        }
    }

    flush();

    $m6 = strtotime("-6 month $day"); // 6개월 이전껀 삭제
    $key_date = date("Y-m",$m6);

    foreach($directory as $dir){
        $v = explode("/",$dir);
        $vv = $v[count($v)-1];
        if($vv<$key_date){
            if($dir!=''){
                exec("rm -rf {$dir}");
            }
        }
    }
}

if ($exCode == "end_change"){ // 완료수정

    $admin_info = admin_member_info();
    if($admin_info['psn_auth']=='0' || substr($admin_info['psn_rwed'],2,1)=='0'){
        $text = iconv("utf-8","euckr","해당 수정권한이 없습니다.");
        echo "<script>alert('".$text."');window.history.go(-1);</script>"; exit;
    }

    $WhereQry   =  "UPDATE mBoard_cs3_req SET proResult = $codevalue WHERE uid = $uid";
    mysql_query($WhereQry);

    auth_access_log("EDIT");
/*
  } elseif ($exCode == "process_change") { // 처리내용 수정
        $WhereQry   =  "UPDATE event_review SET process = '$codevalue' , admin = '$admin' WHERE uid = $uid";
        mysql_query($WhereQry);
        //echo ($WhereQry);
*/
  } else if ($typ == "edit_save") { // 저장하기
    
    if($end_view == '1') { // 처리상황이 처리완료로 변경이 될 때

        mail_log_write($_POST, '');

        $sql = "set names utf8";
        $res = mysql_query($sql);

        $sql = "SELECT * FROM mBoard_cs3_req where uid = '{$uid}' ";
        $res = mysql_query($sql);
        $req_info = mysql_fetch_array($res);

        mail_log_write('', $sql.chr(10).chr(13));

        if($req_info['mail_send_ok']=='1'){
            mail_log_write('', iconv("utf-8","euckr","FAIL 이미 답변을 보낸 게시물입니다."));
            $text = iconv("utf-8","euckr","이미 답변메일을 보낸 게시물이기 때문에 메일발송은 하지 않습니다.");
            //echo "<script>alert('".$text."');</script>";
            //exit;
            $msg = $text;

        } else if($req_info['mail_reply_yn']=='Y' && $req_info['smemail']!='' && strpos($req_info['smemail'],"@")>0){
            $loginUrl = "http://mjsoft.co/manage/cs3_reqBoard_mail.php";

            $ch = curl_init(); 
            curl_setopt ($ch, CURLOPT_URL,$loginUrl); //접속할 URL 주소 
            curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, false); 
            curl_setopt ($ch, CURLOPT_HEADER, 0); 
            curl_setopt ($ch, CURLOPT_TIMEOUT, 30); 
            curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); 
            $result = curl_exec ($ch); 

            $req_info['smdetail'] = nl2br($req_info['smdetail']);
            $req_info['replycontent'] = nl2br($replycontent);

            $result = str_replace("#아이디#",$req_info['smoption'],$result);
            $result = str_replace("#질문날짜#",date("Y년 m월 d일",strtotime($req_info['reg_date'])),$result);
            $result = str_replace("#상호명#",$req_info['smname'],$result);
            $result = str_replace("#답변자#",$emp_sel,$result);
            $result = str_replace("#문의내용#",$req_info['smdetail'],$result);
            $result = str_replace("#답변내용#",$req_info['replycontent'],$result);

            include($_SERVER['DOCUMENT_ROOT']."/emillennium/lib/PHPMailer5/PHPMailerAutoload.php"); // phpmailer 5 모듈 그누보드 2.0 모듈하고 몇몇 명령어나 대소문자나 기타 틀림

            $smtp_use = "smtp.naver.com";
            $smtp_port = "465";
            $smtp_mail_id = "1000y3";

            //$smtp_mail_pw = "mjsoft8680!";
            $smtp_mail_pw = "mj15668680@@";

            $send_email = "1000y3@naver.com";
            $send_name = "엠제이소프트";
            $recv_email = $req_info['smemail'];
            $email_subject = "문의하신 내용에 대한 답변이 처리되었습니다.";

            $email_content = $result;

            $mail = new PHPMailer;
            $mail->IsSMTP();
            $mail->SMTPDebug = 0;
            $mail->Debugoutput = 'html';
            $mail->Host = $smtp_use;
            $mail->SMTPAuth = true;
            $mail->Port = $smtp_port;
            $mail->SMTPSecure = "ssl";        // SSL을 사용함
            $mail->Username = $smtp_mail_id;
            $mail->Password = $smtp_mail_pw;

            $mail->setFrom($send_email, $send_name);
            $mail->addAddress($recv_email);
            $mail->Subject = $email_subject;
            $mail->isHTML(true); 
            $mail->Body = "{$email_content}<br>";

            $mail_log[] = $mail_site;
            $mail_log[] = $r_id;
            $mail_log[] = $send_email;
            $mail_log[] = $send_name;
            $mail_log[] = $recv_email;
            $mail_log[] = $email_subject;
            $mail_log[] = $email_content;
            mail_log_write('', $mail_log);

            if (!$mail->send()) {
                //echo "FAIL";
                $text = iconv("utf-8","euckr","메일전송에 실패했습니다.");
                //echo "<script>alert('".$text."');</script>"; exit;*/
                $msg = $text;
            } else {
                //echo "OK";
                $mail->ErrorInfo = "OK";

                $sql = "update mBoard_cs3_req set mail_send_ok = '1' where uid = '{$uid}' ";
                mysql_query($sql);

                $text = iconv("utf-8","euckr","메일전송에 성공했습니다.");
                //echo "<script>alert('".$text."');</script>";
                $msg = $text;
            }
            mail_log_write('', $mail->ErrorInfo);

        } else {
            mail_log_write('', iconv("utf-8","euckr","FAIL 이메일 없거나 비수신인 사용자"));
            $text = iconv("utf-8","euckr","이메일 없거나 비수신인 사용자입니다.");
            //echo "<script>alert('".$text."');</script>"; exit;
            $msg = $text;
        }
    } else {
        $remarks = iconv("UTF-8", "EUC-KR", $remarks); // 처리내용 문자코드변환
        $replycontent = iconv("UTF-8", "EUC-KR", $replycontent); // 답변내용 문자코드변환
        $emp_sel = iconv("UTF-8", "EUC-KR", $emp_sel); // 처리자 문자코드변환
    }

    $sql = "UPDATE mBoard_cs3_req SET proResult = '$end_view', remarks = '$remarks', replycontent = '$replycontent', emp_sel = '$emp_sel' WHERE uid = '$uid'";
    mysql_query($sql);
    $mode_ok = "Y";
    auth_access_log("EDIT");
?>
<?php } ?>

<?php if ($typ == "edit_save") { 
    echo "<?php xml version='1.0' encoding='utf-8'?><output>";
    echo "<mode>".$mode."</mode>";
    echo "<mode_ok>".$mode_ok."</mode_ok>";
    echo "<msg>".$msg."</msg>";
    echo "</output>";    
} else {
    $text = iconv("utf-8","euckr","수정 완료 되었습니다.");
?>
    <script>
     //parent.Msg("수정 완료 되었습니다.");
     alert("<?php echo $text; ?>");
    </script>  
<? } ?>