月度归档： 2018年2月

jp change bankredemption campaign

leokim / / MYSQL, 数据库
1
2
3
4
5
6
7
8
9
10
11
12
13
14
select * from voucher where prefix='JP10' and voucher_no between 67870 and 67872;
 
select * from voucher_campaign where campaign_code like '%Keppel%';
 
select * from voucher_campaign_issue where voucher_id in (363962,363963,363964);
 
select * from voucher_action where voucher_id in (363962,363963,363964) and action_id = 30;
 
 
select * from voucher_campaign_issue_request where request_id = 61549;
 
select * from voucher_request_approve where request_id = 61549;
 
select * from voucher_receipt_numbers where voucher_ids like '%363962%';

=========================================================================================================

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 51161 and 51162
 
 
select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 50115 and 50124
 
 
select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 48000 and 48009
 
 
select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 47941 and 47942
 
 
select* from voucher_campaign
#189
 
select * from voucher_campaign_issue where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034)
#update voucher_campaign_issue set campaign_id = 189 where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034)
 
select * from voucher_request_approve where request_id in (58643,58653,58740,58885)
#update voucher_request_approve set request_remarks = REPLACE (request_remarks, 'Campaign: UOB Redemption', 'Campaign: NS50 Recognition Package') where request_id in (58643,58653,58740,58885)
 
select * from voucher_campaign_issue_request where request_id in (58643,58653,58740,58885)
#update voucher_campaign_issue_request set campaign_id = 189 where request_id in (58643,58653,58740,58885)
 
select * from voucher_action where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) and action_id = 30
#update voucher_action set remarks=REPLACE (remarks, 'Campaign: UOB Redemption', 'Campaign: NS50 Recognition Package') where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) and action_id = 30