bin/docker/images/Data/import_log_operations.sql from hipay/hipay-wallet-cashout-mirakl-integration

bin/docker/images/Data/import_log_operations.sql
Summary

Maintainability

Test Coverage

Issues
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '1', '1', '230207', '2017-12-08 10:58:32', '16', '16', '1', NULL, NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( NULL, '1', '230195', '2017-12-08 10:59:33', '12.41', '12.41', '3', '5', NULL, '409.21');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '2', '2', '230196', '2017-12-08 10:59:07', '27', '27', '-9', NULL, 'The vendor is not found in the storage', '5266.60');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( NULL, '2', '230196', '2017-12-08 10:59:41', '5', '5', '3', '5', NULL, '409.21');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '3', '3', '230197', '2017-12-08 10:59:42', '6', '6', '2', '2', NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '4', '4', '230198', '2017-12-08 10:59:43', '7', '7', '-10', NULL, 'Insufficient funds', '0');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( NULL, '4', '230199', '2017-12-08 10:59:44', '8', '8', '3', '6', NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '6', '6', '230200', '2017-12-08 10:59:45', '9', '9', '3', '-7', 'Error message', '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '7', '7', '230201', '2017-12-08 10:59:46', '10', '10', '3', '-8', 'Canceled', '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '8', '8', '230202', '2017-12-08 10:59:47', '11', '11', '1', '-11', 'Insufficient funds', '0');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( NULL, '8', '230203', '2017-12-08 10:59:48', '12', '12', '1', NULL, NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '10', '10', '230204', '2017-12-08 10:59:49', '13', '13', '1', NULL, NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '11', '11', '230205', '2017-12-08 10:59:50', '14', '14', '1', NULL, NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( NULL, '11', '230206', '2017-12-08 10:59:51', '15', '15', '1', NULL, NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '13', '13', '230195', '2017-12-08 10:59:52', '93.59', '93.59', '-9', NULL, 'The vendor is not found in the storage', '33233.19');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '14', '14', '230195', '2017-12-08 10:59:52', '93.59', '93.59', '-5', '-6', 'TEST', '33233.19');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '15', '15', '240207', '2017-12-08 10:59:54', '16', '16', '4', NULL, NULL, '255');
INSERT INTO `app`.`log_operations` (`miraklId`, `hipayId`, `paymentVoucher`, `dateCreated`, `amount`, `originAmount`, `statusTransferts`, `statusWithDrawal`, `message`, `balance`) VALUES ( '16', '16', '230215', '2017-12-08 11:00:00', '16', '16', '1', -12, 'This vendor (Mirakl id : 146) payments are blocked. Operation type withdraw will not be treated', '255');