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