목록으로

영카트 무통장입금 자동취소 왜 작동을 안 할까요? 채택완료

하호헤하

프로필 보기 이 회원 글보기 이 회원의 댓글보기

9개월 전 조회 2,845

답변 2

무통장 입금 신청을 했는데 24시간 내로 입금을 안 할 시 자동으로 주문 취소가 되도록 하려고 합니다.

테스트로 10초 안에 입금 안 될 경우 취소되게 했습니다.

aws lightsail bitnami를 쓰고 있고 다음 코드와 크론을 사용했습니다.

Copy

<?php

include_once('../common.php');

 

$sql = "SELECT * FROM g5_shop_order

        WHERE od_status = '주문'

        AND od_settle_case = '무통장'

        AND od_time < NOW() - INTERVAL 10 SECOND";

 

$result = sql_query($sql);

 

sql_query("START TRANSACTION");

 

try {

    while ($row = sql_fetch_array($result)) {

        $update_order = "UPDATE g5_shop_order

                         SET od_status = '취소'

                         WHERE od_id = '{$row['od_id']}'";

        if (!sql_query($update_order)) {

            throw new Exception('주문 테이블 업데이트 실패');

        }

 

        $update_cart = "UPDATE g5_shop_cart

                        SET ct_status = '취소'

                        WHERE od_id = '{$row['od_id']}'";

        if (!sql_query($update_cart)) {

            throw new Exception('카트 테이블 업데이트 실패');

        }

    }

 

    sql_query("COMMIT");

 

} catch (Exception $e) {

    sql_query("ROLLBACK");

    echo $e->getMessage();

}

Copy

* * * * * /opt/bitnami/php/bin/php /opt/bitnami/apache2/htdocs/cron/auto_cancel_order.php >> /opt/bitnami/apache2/logs/auto_cancel.log 2>&1

그런데 아래 오류 메세지가 뜨네요 ㅜㅜ

Copy

PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
 line 50
PHP Warning:  Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
 line 511
PHP Warning:  Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
 line 50
PHP Warning:  Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
 line 511
PHP Warning:  Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
 line 50
PHP Warning:  Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
 line 511
PHP Warning:  Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_PORT" in /opt/bitnami/apache/htdocs/common.php on
 line 47
PHP Warning:  Undefined array key "SERVER_NAME" in /opt/bitnami/apache/htdocs/common.php on
 line 50
PHP Warning:  Undefined array key "REQUEST_URI" in /opt/bitnami/apache/htdocs/common.php on
 line 511
PHP Warning:  Undefined array key "REMOTE_ADDR" in /opt/bitnami/apache/htdocs/bbs/visit_ins
ert.inc.php on line 5

어떻게 해결을 해야할까요?ㅜㅜ

#그누보드5 #영카트5