public function createPaymentConfirmation()
{
$req = $this->app->request();
$sql = 'INSERT INTO payment_confirmations(order_id, bank_name, bank_account, bank_account_name, transfer_date, status, transfer_nominal, total_payment)
VALUES(:order_id, :bank_name, :bank_account, :bank_account_name, :transfer_date, :status, :transfer_nominal, :total_payment)';
$this->payment_confirmations = parent::connect()->prepare($sql);
$data = array('order_id' => $req->post('orderID'), 'bank_name' => $req->post('bankName'), 'bank_account' => $req->post('bankAccount'), 'bank_account_name' => $req->post('bankAccountName'), 'transfer_date' => $req->post('transferDate'), 'status' => 'Unverified', 'transfer_nominal' => $req->post('transferNominal'), 'total_payment' => Order::showTotal());
try {
$this->payment_confirmations->execute($data);
} catch (PDOException $e) {
die($e->getMessage());
}
}
