1XDfE2KN

1-- из задачи 24576
2SET @WorkStatusId = (SELECT `statuses_id` FROM `statuses` WHERE `statuses_name_latin` = 'Work');
3SET @ArchiveStatusId = (SELECT `statuses_id` FROM `statuses` WHERE `statuses_name_latin` = 'Archive');
4
5SET @entityId = (SELECT `entities_id` FROM `entities` WHERE `entities_name` = 'products_attributes_groups');
6SET @entityTypeId = (SELECT `entities_types_id` FROM `entities_types` WHERE `entities_id` = @entityId AND `entities_types_name` = 'default');
7
8INSERT INTO `entities_statuses` (`entities_id`, `statuses_id`, `statuses_types_id`, `entities_statuses_class`) VALUES
9  (@entityId, @WorkStatusId, 0, ''),
10  (@entityId, @ArchiveStatusId, 0, '');
11
12INSERT INTO `status_maps` (`status_maps_name`, `entities_id`, `entities_types_id`) VALUES ('Группа товаров', @entityId, @entityTypeId);
13SET @statusMapId = LAST_INSERT_ID();
14
15INSERT INTO `status_maps_links` (`status_maps_id`, `status_from_id`, `status_to_id`) VALUES
16  (@statusMapId, @WorkStatusId, @ArchiveStatusId),
17  (@statusMapId, @ArchiveStatusId, @WorkStatusId);
18
19DROP TABLE IF EXISTS `products_attributes_legacy`;
20CREATE TABLE `products_attributes_legacy` (
21  `products_attributes_id`        INT UNSIGNED NOT NULL COMMENT 'Идентификатор товара',
22  `products_attributes_parent_id` INT UNSIGNED NOT NULL COMMENT 'Какому товару принадлежит',
23  INDEX `products_attributes_parent_id` (`products_attributes_parent_id`),
24  PRIMARY KEY (`products_attributes_id`)
25)
26  COMMENT ='Таблица-связка одинаковых товаров в разрезе НоменклатураПоставщика + Бренд + Поставщик + ЦветТорг12 + Размеры'
27  COLLATE = 'utf8_general_ci'
28  ENGINE = InnoDB;
29
30DROP TABLE IF EXISTS `products_attributes_groups`;
31CREATE TABLE `products_attributes_groups` (
32  `products_attributes_groups_id`        INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Идентификатор группы товаров',
33  `products_attributes_article_supplier` VARCHAR(255) NOT NULL COMMENT 'НоменклатураПоставщика',
34  `brandswelove_id`                      INT UNSIGNED NOT NULL COMMENT 'Бренд',
35  `suppliers_id`                         INT UNSIGNED NOT NULL COMMENT 'Поставщик',
36  `products_attributes_options_color_id` INT UNSIGNED NOT NULL COMMENT 'ЦветТорг12',
37  `entities_types_id`                    INT UNSIGNED NOT NULL DEFAULT 215 COMMENT 'Тип',
38  `products_attributes_groups_status`    INT UNSIGNED NOT NULL DEFAULT 11 COMMENT 'Статус',
39  PRIMARY KEY (`products_attributes_groups_id`),
40  UNIQUE INDEX `unique_key` (`products_attributes_article_supplier`, `brandswelove_id`, `suppliers_id`, `products_attributes_options_color_id`)
41)
42  COMMENT ='Сущность, представляющая одинаковые товары в разрезе НоменклатураПоставщика + Бренд + Поставщик + ЦветТорг12'
43  COLLATE = 'utf8_general_ci'
44  ENGINE = InnoDB;
45
46DROP TABLE IF EXISTS `products_attributes_groups_status_history`;
47CREATE TABLE `products_attributes_groups_status_history` (
48  `products_attributes_groups_status_history_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
49  `object_id`                                    INT UNSIGNED NOT NULL,
50  `customers_id`                                 INT UNSIGNED NOT NULL,
51  `status_id`                                    INT UNSIGNED NOT NULL,
52  `date_added`                                   TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
53  `parent_id`                                    INT UNSIGNED NOT NULL DEFAULT 0,
54  PRIMARY KEY (`products_attributes_groups_status_history_id`),
55  INDEX `object_id` (`object_id`),
56	INDEX `status_id` (`status_id`),
57	INDEX `date_added` (`date_added`)
58)
59  COLLATE = 'utf8_general_ci'
60  ENGINE = InnoDB;
61
62DROP TABLE IF EXISTS `products_attributes_groups_comment_history`;
63CREATE TABLE `products_attributes_groups_comment_history` (
64  `products_attributes_groups_comment_history_id` INT UNSIGNED        NOT NULL AUTO_INCREMENT,
65  `products_attributes_groups_status_history_id`  INT UNSIGNED        NOT NULL,
66  `object_id`                                     INT UNSIGNED        NOT NULL,
67  `customers_id`                                  INT UNSIGNED        NOT NULL,
68  `status_id`                                     INT UNSIGNED        NOT NULL,
69  `sub_status_id`                                 INT UNSIGNED        NULL     DEFAULT NULL,
70  `date_added`                                    TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP,
71  `comment`                                       TEXT                NULL,
72  `is_important`                                  TINYINT(4) UNSIGNED NOT NULL DEFAULT '2' COMMENT '1 - true, 2 - false',
73  `flag`                                          TINYINT(4) UNSIGNED NOT NULL DEFAULT '1',
74  PRIMARY KEY (`products_attributes_groups_comment_history_id`),
75  INDEX `object_id` (`object_id`),
76	INDEX `status_id` (`status_id`),
77	INDEX `date_added` (`date_added`),
78	INDEX `products_attributes_groups_status_history_id` (`products_attributes_groups_status_history_id`)
79)
80  COLLATE = 'utf8_general_ci'
81  ENGINE = InnoDB;
82
83DROP TABLE IF EXISTS `products_attributes_to_products_attributes_groups`;
84CREATE TABLE `products_attributes_to_products_attributes_groups` (
85  `products_attributes_id`        INT UNSIGNED NOT NULL COMMENT 'Товар',
86  `products_attributes_groups_id` INT UNSIGNED NOT NULL COMMENT 'Группа товаров',
87  INDEX `products_attributes_groups_id` (`products_attributes_groups_id`),
88  PRIMARY KEY (`products_attributes_id`)
89)
90  COMMENT ='Таблица-связка одинаковых товаров в разрезе НоменклатураПоставщика + Бренд + Поставщик + ЦветТорг12'
91  COLLATE = 'utf8_general_ci'
92  ENGINE = InnoDB;
93-- из задачи 24576
94
95
96
97
98-- Условия архивации товара (из задач 24725, 25471)
99CREATE TABLE IF NOT EXISTS `archiving_conditions` (
100  `archiving_conditions_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Идентификатор',
101  `date_added` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата добавления',
102  `customers_id` int(11) unsigned NOT NULL COMMENT 'Идентификатор пользователя добавившего',
103  `date_update` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Дата обновления',
104  `update_customers_id` int(11) unsigned DEFAULT NULL COMMENT 'Идентификатор пользователя обновившего',
105  `count_last_start_item` int(11) unsigned NOT NULL COMMENT 'Количество последних стартов товара в акциях',
106  `count_purchased_item_start` int(11) unsigned NOT NULL COMMENT 'Количество купленных товаров по формированию заказа поставщику от',
107  `count_purchased_item_end` int(11) unsigned NOT NULL COMMENT 'Количество купленных товаров по формированию заказа поставщику до',
108  `repeat_limit_days` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Ограничение на повтор или Архив(0)',
109  PRIMARY KEY (`archiving_conditions_id`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Условия архивации товара';
111
112-- insert rules
113INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'archiving-conditions');
114SET @rule1 = LAST_INSERT_ID();
115INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'remove-archiving-conditions');
116SET @rule2 = LAST_INSERT_ID();
117INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'get-form-archiving-conditions-edit');
118SET @rule3 = LAST_INSERT_ID();
119INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'save-archiving-conditions-edit');
120SET @rule4 = LAST_INSERT_ID();
121
122INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`) VALUES (114, @rule1),(114, @rule2),(114, @rule3),(114, @rule4);
123
124-- предзаполнение
125INSERT INTO `archiving_conditions` (`customers_id`, `update_customers_id`, `count_last_start_item`, `count_purchased_item_start`, `count_purchased_item_end`, `repeat_limit_days`)
126VALUES
127  (1, 1, 1, 0, 9999, 30),
128  (1, 1, 2, 0, 9999, 30),
129  (1, 1, 3, 0, 0, 60),
130  (1, 1, 3, 1, 9999, 30),
131  (1, 1, 4, 0, 0, 0),
132  (1, 1, 4, 1, 1, 45),
133  (1, 1, 4, 2, 9999, 30);
134-- Условия архивации товара (из задач 24725, 25471)
135
136
137CREATE TABLE `products_attributes_total` (
138  `products_attributes_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID из таблицы products_attributes',
139  `products_attributes_sales_count` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Кол-во проданных товаров, в т.ч. удаленные, отмененные и возвращенные',
140  PRIMARY KEY (`products_attributes_id`)
141)
142  COMMENT='Суммарные данные по product_attribute'
143  ENGINE=InnoDB
144;
145
146ALTER TABLE `categories_extra`
147	ADD COLUMN `is_primary_filling_report_sent` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Отправлен ли отчет поставщику при первичной заливке акции' AFTER `is_income_confirmed`;
148
149SET @inactiveArchiveProductStatusId = 10;
150INSERT INTO `products_attributes_status` (`products_attributes_status_id`, `products_attributes_status_name`) VALUES (@inactiveArchiveProductStatusId, 'Неактивно (архивация)');