SET @charge_no = '15466294';
SET @tid = '20705103';
SET @requestDesc = '관리자취소';
SET @adminId = 'billAdmin';
update tb_change
set stat_cd = 2, upd_date = now()
where charge_no = @charge_no;
SELECT charge_no, svc_inst_no, @cashAttrNo:=cash_attr_no, @requestDesc, @chargeToolNo:=charge_tool_no, @cashAmt:=cash_amt, @realPrice:=real_price, @adminId, 4, NOW()
FROM tb_charge
WHERE charge_no = @charge_no;
SELECT @charge_no, @tid, @requestDesc, @chargeToolNo, @cashAmt, @realPrice, @adminId, '4', NOW();
/*
insert into tb_charge_cancel(charge_no, svc_inst_no, request_desc, charge_tool_no, cancel_cash, cancel_real_price, admin_id, stat_cd, cancel_date)
values (@charge_no, @tid, @requestDesc, @chargeToolNo, @cashAmt, @realPrice, @adminId, '4', now());
*/
SELECT cash, in_cash
FROM tb_cash
WHERE svc_inst_no = @tid AND cash_attr_no = @cashAttrNo;
SELECT @resultCash:=(cash-@cashAmt), @resultInCash:=(in_cash - @cashAmt)
FROM tb_cash
WHERE svc_inst_no = @tid AND cash_attr_no = @cashAttrNo;
UPDATE tb_cash
SET cash = '', in_cash = ''
WHERE svc_inst_no = '' AND cash_attr_no = '';