postgresql
7.1
insert into ec_problems_log
(problem_id, problem_date, problem_details, gift_certificate_id)
values
(ec_problem_id_sequence.nextval, current_timestamp, 'Customer pushed reload on gift-certificate-finalize-order.tcl but gift_certificate_state wasn't authorized or failed',:gift_certificate_id)
insert into ec_problems_log
(problem_id, problem_date, problem_details, gift_certificate_id)
values
(ec_problem_id_sequence.nextval, current_timestamp, 'gift-certificate-finalize-order.tcl could not authorize a gift certificate as no payment gateway was selected.' ,:gift_certificate_id)
insert into ec_problems_log
(problem_id, problem_date, problem_details, gift_certificate_id)
values
(ec_problem_id_sequence.nextval, current_timestamp, 'gift-certificate-finalize-order.tcl could not authorize a gift certificate as payment gateway $payment_gateway is unbound.',:gift_certificate_id)
insert into ec_gift_certificates
(gift_certificate_id, gift_certificate_state, amount, issue_date, purchased_by, expires, claim_check,
certificate_message, certificate_to, certificate_from, recipient_email, last_modified, last_modifying_user, modified_ip_address)
values
(:gift_certificate_id, 'confirmed', :amount, current_timestamp, :user_id, current_timestamp + '$gc_months months'::interval,:claim_check,
:certificate_message, :certificate_to, :certificate_from, :recipient_email, current_timestamp, :user_id, :peeraddr)
insert into ec_financial_transactions
(transaction_id, gift_certificate_id, creditcard_id, transaction_amount, transaction_type, inserted_date)
values
(:transaction_id, :gift_certificate_id, :creditcard_id, :amount, 'charge', current_timestamp)
update ec_financial_transactions
set authorized_date=current_timestamp, to_be_captured_p='t', transaction_id = :pgw_transaction_id
where transaction_id=:transaction_id
update ec_gift_certificates
set authorized_date=current_timestamp, gift_certificate_state='authorized'
where gift_certificate_id=:gift_certificate_id
insert into ec_problems_log
(problem_id, problem_date, problem_details, gift_certificate_id)
values
(ec_problem_id_sequence.nextval, sysdate,
'Gift-certificate-finalize-order.tcl called payment gateway :payment_gateway for authorizion, which returned: :response_code.', :gift_certificate_id)
select extract(day from (current_timestamp-issue_date))*86400 +
extract(hour from (current_timestamp-issue_date))*3600 +
extract(min from (current_timestamp-issue_date))*60 +
extract(sec from (current_timestamp-issue_date)) as n_seconds
from ec_gift_certificates
where gift_certificate_id = :gift_certificate_id