'견적채택',
'deposit_paid' => '입금확인',
'interim_pending' => '중도금입금예정',
'interim_paid' => '중도금입금완료',
'final_pending' => '잔금입금예정',
'final_paid' => '시공완료'
];
$new_estimate_status = $estimate_status_map[$payment_status] ?? '견적채택';
sql_query("UPDATE estimate SET
status = '{$new_estimate_status}',
extra_2 = '{$payment_status}',
extra_4 = '{$payment_memo}',
updated_at = NOW()
WHERE wr_id = '{$wr_id}'");
// 게시판 상태도 업데이트
sql_query("UPDATE g5_write_order SET wr_1 = '{$new_estimate_status}' WHERE wr_id = '{$wr_id}'");
alert('결제 상태가 업데이트되었습니다.', './payment_manager.php');
}
// 결제 대기 중인 견적 목록 조회
$sql = "SELECT e.*, w.wr_subject, w.wr_name, w.wr_datetime,
(SELECT mb_name FROM g5_member WHERE mb_id = e.extra_4) as selected_dealer_name
FROM estimate e
JOIN g5_write_order w ON e.wr_id = w.wr_id
WHERE e.status IN ('견적채택', '입금확인', '중도금입금예정', '중도금입금완료', '잔금입금예정')
AND e.is_deleted = 0
ORDER BY
CASE e.status
WHEN '견적채택' THEN 1
WHEN '중도금입금예정' THEN 2
WHEN '잔금입금예정' THEN 3
ELSE 4
END,
e.updated_at DESC";
$result = sql_query($sql);
$g5['title'] = '결제 관리';
include_once(G5_ADMIN_PATH . '/admin.head.php');
?>