· 8 years ago · Jun 22, 2018, 12:40 PM
1set @refundsPaymentsOrdersEntityId = 96;
2set @refundsEntityId = 97;
3set @returnReceiptEntityTypeId = 231;
4set @returnAdvanceEntityTypeId = 232;
5set @addedStatusId = 1;
6set @newStatusId = 219;
7set @canceledStatusId = 220;
8set @toAccountsDepartmentStatusId = 221;
9set @sendingBankStatusId = 222;
10set @sendingBankErrorStatusId = 223;
11set @sendingBankDoneStatusId = 224;
12set @returnedByBankStatusId = 225;
13
14INSERT IGNORE INTO `entities_statuses` (`entities_id`, `statuses_id`) VALUES
15 (@refundsPaymentsOrdersEntityId, @addedStatusId),
16 (@refundsPaymentsOrdersEntityId, @newStatusId),
17 (@refundsPaymentsOrdersEntityId, @canceledStatusId),
18 (@refundsPaymentsOrdersEntityId, @toAccountsDepartmentStatusId),
19 (@refundsPaymentsOrdersEntityId, @sendingBankStatusId),
20 (@refundsPaymentsOrdersEntityId, @sendingBankErrorStatusId),
21 (@refundsPaymentsOrdersEntityId, @sendingBankDoneStatusId),
22 (@refundsPaymentsOrdersEntityId, @returnedByBankStatusId)
23;
24
25INSERT IGNORE INTO `status_maps` (`status_maps_name`, `entities_id`, `entities_types_id`) VALUES ('Платежное поручение на возврат прихода', @refundsPaymentsOrdersEntityId, @returnReceiptEntityTypeId);
26set @statusMapReturnReceipt = last_insert_id();
27
28INSERT IGNORE INTO `status_maps` (`status_maps_name`, `entities_id`, `entities_types_id`) VALUES ('Платежное поручение на возврат аванÑа', @refundsPaymentsOrdersEntityId, @returnAdvanceEntityTypeId);
29set @statusMapReturnAdvance = last_insert_id();
30
31INSERT IGNORE INTO `status_maps_links` (`status_maps_id`, `status_from_id`, `status_to_id`) VALUES
32 (@statusMapReturnReceipt, @addedStatusId, @newStatusId),
33 (@statusMapReturnReceipt, @newStatusId, @toAccountsDepartmentStatusId),
34 (@statusMapReturnReceipt, @newStatusId, @canceledStatusId),
35 (@statusMapReturnReceipt, @canceledStatusId, @newStatusId),
36 (@statusMapReturnReceipt, @toAccountsDepartmentStatusId, @canceledStatusId),
37 (@statusMapReturnReceipt, @toAccountsDepartmentStatusId, @sendingBankStatusId),
38 (@statusMapReturnReceipt, @sendingBankStatusId, @sendingBankErrorStatusId),
39 (@statusMapReturnReceipt, @sendingBankStatusId, @sendingBankDoneStatusId),
40 (@statusMapReturnReceipt, @sendingBankDoneStatusId, @returnedByBankStatusId),
41 (@statusMapReturnAdvance, @addedStatusId, @newStatusId),
42 (@statusMapReturnAdvance, @newStatusId, @toAccountsDepartmentStatusId),
43 (@statusMapReturnAdvance, @newStatusId, @canceledStatusId),
44 (@statusMapReturnAdvance, @toAccountsDepartmentStatusId, @canceledStatusId),
45 (@statusMapReturnAdvance, @toAccountsDepartmentStatusId, @sendingBankStatusId),
46 (@statusMapReturnAdvance, @sendingBankStatusId, @sendingBankErrorStatusId),
47 (@statusMapReturnAdvance, @sendingBankStatusId, @sendingBankDoneStatusId),
48 (@statusMapReturnAdvance, @sendingBankDoneStatusId, @returnedByBankStatusId)
49;
50
51DROP TABLE IF EXISTS `refunds_payments_orders`;
52CREATE TABLE `refunds_payments_orders` (
53 `refunds_payments_orders_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID платежного поручениÑ',
54 `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'СвÑзь Ñ Ñ€Ð¾Ð´Ð¸Ñ‚ÐµÐ»ÑŒÑким платежным поручением',
55 `entities_types_id` INT(10) UNSIGNED NOT NULL DEFAULT '230' COMMENT 'Тип платежного поручениÑ',
56 `payment_order_number_1c` VARCHAR(255) NOT NULL DEFAULT '',
57 `payment_order_date_1c` TIMESTAMP NULL DEFAULT NULL,
58 `customers_id_added` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Сотрудник, акцептовавший возврат или добавивший поручение',
59 `customers_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Пользователь, которому возвращаем ÑредÑтва',
60 `refunds_payments_orders_data_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'СвÑзь Ñо Ñправочником платежной информации пользователÑ',
61 `refunds_payments_orders_status` INT(10) UNSIGNED NOT NULL DEFAULT 1,
62 `refunds_payments_orders_comment` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Комментарий о назначении платежа',
63 `refunds_payments_orders_sum` DECIMAL(12,5) NOT NULL DEFAULT '0.00000' COMMENT 'Сумма платежного поручениÑ',
64 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
65 `date_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
66 PRIMARY KEY (`refunds_payments_orders_id`),
67 INDEX `parent_id` (`parent_id`),
68 INDEX `entities_types_id` (`entities_types_id`),
69 INDEX `payment_order_number_1c` (`payment_order_number_1c`),
70 INDEX `customers_id_added` (`customers_id_added`),
71 INDEX `customers_id` (`customers_id`),
72 INDEX `refunds_payments_orders_data_id` (`refunds_payments_orders_data_id`),
73 INDEX `refunds_payments_orders_status` (`refunds_payments_orders_status`),
74 INDEX `date_added` (`date_added`),
75 INDEX `date_updated` (`date_updated`)
76)
77 COMMENT='Платежные поручениÑ'
78 COLLATE='utf8_general_ci'
79 ENGINE=InnoDB
80;
81
82DROP TABLE IF EXISTS `refunds_payments_orders_status_history`;
83CREATE TABLE `refunds_payments_orders_status_history` (
84 `refunds_payments_orders_status_history_id` INT(11) NOT NULL AUTO_INCREMENT,
85 `object_id` INT(11) NOT NULL DEFAULT '0',
86 `customers_id` INT(11) NOT NULL DEFAULT '0',
87 `status_id` INT(11) NOT NULL DEFAULT '0',
88 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
89 `parent_id` INT(11) NOT NULL DEFAULT '0',
90 PRIMARY KEY (`refunds_payments_orders_status_history_id`),
91 INDEX `object_id` (`object_id`),
92 INDEX `status_id` (`status_id`),
93 INDEX `date_added` (`date_added`)
94)
95 COLLATE='utf8_general_ci'
96 ENGINE=InnoDB
97;
98
99DROP TABLE IF EXISTS `refunds_payments_orders_comment_history`;
100CREATE TABLE `refunds_payments_orders_comment_history` (
101 `refunds_payments_orders_comment_history_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
102 `refunds_payments_orders_status_history_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
103 `object_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
104 `customers_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
105 `status_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
106 `sub_status_id` INT(10) UNSIGNED NULL DEFAULT NULL,
107 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
108 `comment` TEXT NULL,
109 `is_important` TINYINT(4) NOT NULL DEFAULT '2' COMMENT '1 - true, 2 - false',
110 `flag` TINYINT(4) NOT NULL DEFAULT '1',
111 PRIMARY KEY (`refunds_payments_orders_comment_history_id`),
112 INDEX `refunds_payments_orders_status_history_id` (`refunds_payments_orders_status_history_id`),
113 INDEX `object_id` (`object_id`),
114 INDEX `status_id` (`status_id`),
115 INDEX `sub_status_id` (`sub_status_id`),
116 INDEX `date_added` (`date_added`)
117)
118 COLLATE='utf8_general_ci'
119 ENGINE=InnoDB
120;
121
122
123DROP TABLE IF EXISTS `refunds_payments_orders_data`;
124CREATE TABLE `refunds_payments_orders_data` (
125 `refunds_payments_orders_data_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID набора платежной информации',
126 `customers_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Id пользователÑ, которому возвращаем ÑредÑтва',
127 `refunds_payments_orders_data_customer_lastname` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Ð¤Ð°Ð¼Ð¸Ð»Ð¸Ñ Ð¿Ð¾Ð»ÑƒÑ‡Ð°Ñ‚ÐµÐ»Ñ Ð¿Ð»Ð°Ñ‚ÐµÐ¶Ð°',
128 `refunds_payments_orders_data_customer_firstname` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Ð˜Ð¼Ñ Ð¿Ð¾Ð»ÑƒÑ‡Ð°Ñ‚ÐµÐ»Ñ Ð¿Ð»Ð°Ñ‚ÐµÐ¶Ð°',
129 `refunds_payments_orders_data_customer_surname` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'ОтчеÑтво Ð¿Ð¾Ð»ÑƒÑ‡Ð°Ñ‚ÐµÐ»Ñ Ð¿Ð»Ð°Ñ‚ÐµÐ¶Ð°',
130 `refunds_payments_orders_data_bik` VARCHAR(9) NOT NULL DEFAULT '' COMMENT 'БИК',
131 `refunds_payments_orders_data_bank_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Ðаименование банка',
132 `refunds_payments_orders_data_bank_city` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'ÐаÑеленный пункт (город)',
133 `refunds_payments_orders_data_bank_cor_account` VARCHAR(64) NOT NULL DEFAULT '' COMMENT 'КорреÑпондентÑкий Ñчет',
134 `refunds_payments_orders_data_customer_account` VARCHAR(30) NOT NULL DEFAULT '' COMMENT 'Ðомер Ñчета пользователÑ',
135 `refunds_payments_orders_data_customer_card_number` VARCHAR(25) NOT NULL DEFAULT '' COMMENT 'Ðомер карты пользователÑ',
136 `is_active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Признак, что по данной информации платеж уÑпешно проходил',
137 PRIMARY KEY (`refunds_payments_orders_data_id`),
138 INDEX `customers_id` (`customers_id`)
139)
140 COMMENT='Справочник платежной информации пользователей'
141 COLLATE='utf8_general_ci'
142 ENGINE=InnoDB
143;
144
145DROP TABLE IF EXISTS `refunds_payments_orders_to_objects`;
146CREATE TABLE `refunds_payments_orders_to_objects` (
147 `refunds_payments_orders_to_objects_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
148 `refunds_payments_orders_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
149 `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
150 `entities_id` INT(11) UNSIGNED NOT NULL DEFAULT '97',
151 `customers_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
152 `date_added` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
153 PRIMARY KEY (`refunds_payments_orders_to_objects_id`),
154 INDEX `refunds_payments_orders_id` (`refunds_payments_orders_id`),
155 INDEX `object_id_entities_id` (`object_id`, `entities_id`),
156 INDEX `refunds_payments_orders_id_entities_id` (`refunds_payments_orders_id`, `entities_id`),
157 INDEX `customers_id` (`customers_id`)
158)
159 COLLATE='utf8_general_ci'
160 ENGINE=InnoDB
161;
162
163/* права и ÑÑылки*/
164INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'index');
165set @refundsPaymentsOrdersRuleId = last_insert_id();
166INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, @refundsPaymentsOrdersRuleId, 'ALLOW');
167INSERT INTO `admin_menu` (`pid`, `name`, `url`) VALUES (174, 'Платежные поручениÑ', '/call/refunds-payments-orders');
168
169INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'find-bank-by-bik');
170INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, last_insert_id(), 'ALLOW');
171
172INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'cancel');
173INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, last_insert_id(), 'ALLOW');
174
175INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'get-purpose-of-payment');
176INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, last_insert_id(), 'ALLOW');
177
178INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'get-refunds-payments-orders-data');
179INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, last_insert_id(), 'ALLOW');
180
181INSERT IGNORE INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, 1384, 'ALLOW');
182
183INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'save-refunds-payments-orders');
184INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, last_insert_id(), 'ALLOW');
185
186INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'refunds-payments-orders', 'get-customer-by-id');
187INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (86, last_insert_id(), 'ALLOW');