HEX
Server: Apache/2.2.15 (CentOS)
System: Linux ip-10-0-2-146.eu-west-1.compute.internal 2.6.32-754.35.1.el6.centos.plus.x86_64 #1 SMP Sat Nov 7 11:33:42 UTC 2020 x86_64
User: root (0)
PHP: 5.6.40
Disabled: NONE
$ pwd: /www/exchange0old/exchange/custom_reports/
Upload Files
File: /www/exchange0old/exchange/custom_reports/4_reserves_sql_fixes.sql
#5933
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=8209 LIMIT 1;


#6065
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=8206 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=8207 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=8208 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=8210 LIMIT 1;

#5389
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13527 LIMIT 1;

#5698
UPDATE `invoice_master` SET `manual_transaction_id`=0 WHERE `invoice_id`=5698 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13529 LIMIT 1;

#5598
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13528 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=0 WHERE `invoice_id`=5598 LIMIT 1;

#5241
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13718 LIMIT 1;

#3330
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13713 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=0 WHERE `invoice_id`=3330 LIMIT 1;


#5307
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13719 LIMIT 1;
UPDATE `manual_transactions` SET `reconcile_ref`=0, `reconcile_status`=0 WHERE `manual_transaction_id`=3640 LIMIT 1;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
(
SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
FROM manual_transactions 
WHERE manual_transaction_id = 5250
);
DELETE FROM `manual_transactions` WHERE `manual_transaction_id`=5250 LIMIT 1;


#6601
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=4990 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=0 WHERE `invoice_id`=6601 LIMIT 1;

#6492
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=4921 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=0 WHERE `invoice_id`=6492 LIMIT 1;

#6329
UPDATE `invoice_master` SET `manual_transaction_id`=0 WHERE `invoice_id`=6329 LIMIT 1;
UPDATE `manual_transactions` SET `reconcile_ref`=0 WHERE `manual_transaction_id`=3001 LIMIT 1;
UPDATE `manual_transactions` SET `reconcile_status`=0 WHERE `manual_transaction_id`=3001 LIMIT 1;
UPDATE `manual_transactions` SET `reconcile_status`=0 WHERE `manual_transaction_id`=2516 LIMIT 1;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
(
SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
FROM manual_transactions 
WHERE manual_transaction_id = 3784
);
DELETE FROM `manual_transactions` WHERE `manual_transaction_id`=3784 LIMIT 1;


#6459
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13822 LIMIT 1;

#4450
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13806 LIMIT 1;

#4555
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13807 LIMIT 1;

#6313
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13821 LIMIT 1;

#4189
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13804 LIMIT 1;

#6188
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13820 LIMIT 1;

#4720
UPDATE `invoice_master` SET `manual_transaction_id`=3026 WHERE `invoice_id`=4720 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13808 LIMIT 1;

#4301
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=13805 LIMIT 1;

#5932
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=4578 LIMIT 1;

#756
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=462 LIMIT 1;

#734
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=441 LIMIT 1;

#8437
UPDATE `invoice_reserve` SET `manual_transaction_id`=3856 WHERE `invoice_reserve_id`=8247 LIMIT 1;

#8436
UPDATE `invoice_reserve` SET `manual_transaction_id`=3856 WHERE `invoice_reserve_id`=8246 LIMIT 1;

#8348
UPDATE `invoice_reserve` SET `manual_transaction_id`=5591 WHERE `invoice_reserve_id`=14602 LIMIT 1;

#5723
UPDATE `invoice_reserve` SET `manual_transaction_id`=5470 WHERE `invoice_reserve_id`=14462 LIMIT 1;

#5891
UPDATE `invoice_reserve` SET `manual_transaction_id`=5470 WHERE `invoice_reserve_id`=14463 LIMIT 1;

#8633
UPDATE `invoice_reserve` SET `manual_transaction_id`=5591 WHERE `invoice_reserve_id`=14604 LIMIT 1;


#3177
UPDATE `manual_transactions` SET `reference_to`='3132,3305' WHERE `manual_transaction_id`=5575 LIMIT 1;
UPDATE `manual_transactions` SET `reference_to`='3132,3305,3569,3681,3799,3978,4145' WHERE `manual_transaction_id`=7924 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=4746 WHERE `invoice_id`=3177 LIMIT 1;

#8448
UPDATE `invoice_reserve` SET `manual_transaction_id`=5591 WHERE `invoice_reserve_id`=14603 LIMIT 1;

#3290
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15300 LIMIT 1;

#4132
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15306 LIMIT 1;

##3404,3123,4255,7030,3673,7181,4805,4394,3983,2510,4529,6772,3557,3169,3815
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15313 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15312 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15311 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15310 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15309 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15308 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15307 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15305 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15304 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15303 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15302 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15301 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15299 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15298 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=15297 LIMIT 1;


#7723
UPDATE `invoice_master` SET `manual_transaction_id`=10343 WHERE `invoice_id`=7723 LIMIT 1;

#7959
UPDATE `invoice_master` SET `manual_transaction_id`=10343 WHERE `invoice_id`=7959 LIMIT 1;


##7731,7733,7729,7730,7732
UPDATE `invoice_reserve` SET `manual_transaction_id`=3857 WHERE `invoice_reserve_id`=5494 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=3857 WHERE `invoice_reserve_id`=5495 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=3857 WHERE `invoice_reserve_id`=5496 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=3857 WHERE `invoice_reserve_id`=5497 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=3857 WHERE `invoice_reserve_id`=5498 LIMIT 1;


##7544,7548,7545,7549,7546,7550,7547,7551
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14572 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14573 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14574 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14575 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14576 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14577 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14578 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5579 WHERE `invoice_reserve_id`=14579 LIMIT 1;


##7227,7228,7229,7230,7232
UPDATE `invoice_reserve` SET `manual_transaction_id`=5590 WHERE `invoice_reserve_id`=14594 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5590 WHERE `invoice_reserve_id`=14596 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5590 WHERE `invoice_reserve_id`=14597 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5590 WHERE `invoice_reserve_id`=14599 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5590 WHERE `invoice_reserve_id`=14601 LIMIT 1;

#7224
UPDATE `invoice_reserve` SET `manual_transaction_id`=5586 WHERE `invoice_reserve_id`=14588 LIMIT 1;


#7231,7234,7236,7237,7519,7526,7518,7525,7524,7523
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5306 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5308 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5309 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5420 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5423 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5424 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5425 LIMIT 1;
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5426 LIMIT 1;

#7521
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5421 LIMIT 1;

#7253
UPDATE `invoice_reserve` SET `manual_transaction_id`=3901 WHERE `invoice_reserve_id`=5325 LIMIT 1;

#7522
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=5422 LIMIT 1;


##7240,7241,7238,7242,7239,7243,7244,7245,7246
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14652 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14654 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14657 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14656 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14659 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14660 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14661 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14662 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5625 WHERE `invoice_reserve_id`=14663 LIMIT 1;

##8844,8845,8846
UPDATE `invoice_reserve` SET `manual_transaction_id`=5773 WHERE `invoice_reserve_id`=14768 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5773 WHERE `invoice_reserve_id`=14767 LIMIT 1;
UPDATE `invoice_reserve` SET `manual_transaction_id`=5773 WHERE `invoice_reserve_id`=14766 LIMIT 1;

UPDATE `manual_transactions` SET `reference_to`='7234,7236,7237,7519,7520,7521,7523,7524,7525,7526,7518,7528,7529,7530' WHERE `manual_transaction_id`=5576 LIMIT 1;

#7528
UPDATE `invoice_reserve` SET `manual_transaction_id`=3786 WHERE `invoice_reserve_id`=8199 LIMIT 1;

#7527
UPDATE `invoice_reserve` SET `manual_transaction_id`=3786 WHERE `invoice_reserve_id`=8198 LIMIT 1;

#7529
UPDATE `invoice_reserve` SET `manual_transaction_id`=3786 WHERE `invoice_reserve_id`=8200 LIMIT 1;

#7235
UPDATE `invoice_reserve` SET `manual_transaction_id`=5588 WHERE `invoice_reserve_id`=14589 LIMIT 1;

#7552
UPDATE `invoice_reserve` SET `manual_transaction_id`=5581 WHERE `invoice_reserve_id`=14581 LIMIT 1;

#8302
UPDATE `invoice_reserve` SET `manual_transaction_id`=5580 WHERE `invoice_reserve_id`=14580 LIMIT 1;


#7507
DELETE FROM `invoice_reserve` WHERE `invoice_reserve_id`=12231 LIMIT 1;
UPDATE `manual_transactions` SET `reference_to`='735,746,764,797,805,811,825,910,939,977,1012,1057,1113,1145,1288,1347,1400,1464,1518,1583,1678,1732,1895,2121,2123,2222,2288,2473,2601,2716,2840,2855,2957,3039,3820,3200,3447,3604,3721,3923,4032,4206,4314,4454,4527,4732,4844,4929,5050,5143,5217,5333,5544,5652,5810,5922,6068,6212,6325,6404,6487,6596,6635,6638,6708,7078' 
WHERE `manual_transaction_id`=3488 
LIMIT 1;

INSERT INTO manual_transactions (manual_transaction_id,amount,transaction_type,originator_id,debtors,status,interface,transaction_date,created_at)
VALUES(null,414.14,92,43,65,1,1,"2014-10-07",NOW());
SET @trans_id = LAST_INSERT_ID();
INSERT INTO statements (manual_transaction_id,originator_id)
SELECT manual_transaction_id,originator_id
FROM manual_transactions
WHERE manual_transaction_id=@trans_id;
UPDATE manual_transactions SET amount=amount-414.14 WHERE manual_transaction_id=3488;
@ Telegram