WNzSd9wM

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)
56  COLLATE = 'utf8_general_ci'
57  ENGINE = InnoDB;
58
59DROP TABLE IF EXISTS `products_attributes_groups_comment_history`;
60CREATE TABLE `products_attributes_groups_comment_history` (
61  `products_attributes_groups_comment_history_id` INT UNSIGNED        NOT NULL AUTO_INCREMENT,
62  `products_attributes_groups_status_history_id`  INT UNSIGNED        NOT NULL,
63  `object_id`                                     INT UNSIGNED        NOT NULL,
64  `customers_id`                                  INT UNSIGNED        NOT NULL,
65  `status_id`                                     INT UNSIGNED        NOT NULL,
66  `sub_status_id`                                 INT UNSIGNED        NULL     DEFAULT NULL,
67  `date_added`                                    TIMESTAMP           NOT NULL DEFAULT CURRENT_TIMESTAMP,
68  `comment`                                       TEXT                NULL,
69  `is_important`                                  TINYINT(4) UNSIGNED NOT NULL DEFAULT '2' COMMENT '1 - true, 2 - false',
70  `flag`                                          TINYINT(4) UNSIGNED NOT NULL DEFAULT '1',
71  PRIMARY KEY (`products_attributes_groups_comment_history_id`)
72)
73  COLLATE = 'utf8_general_ci'
74  ENGINE = InnoDB;
75
76DROP TABLE IF EXISTS `products_attributes_to_products_attributes_groups`;
77CREATE TABLE `products_attributes_to_products_attributes_groups` (
78  `products_attributes_id`        INT UNSIGNED NOT NULL COMMENT 'Товар',
79  `products_attributes_groups_id` INT UNSIGNED NOT NULL COMMENT 'Группа товаров',
80  INDEX `products_attributes_groups_id` (`products_attributes_groups_id`),
81  PRIMARY KEY (`products_attributes_id`)
82)
83  COMMENT ='Таблица-связка одинаковых товаров в разрезе НоменклатураПоставщика + Бренд + Поставщик + ЦветТорг12'
84  COLLATE = 'utf8_general_ci'
85  ENGINE = InnoDB;
86-- из задачи 24576
87
88
89
90
91-- Условия архивации товара (из задач 24725, 25471)
92CREATE TABLE IF NOT EXISTS `archiving_conditions` (
93  `archiving_conditions_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Идентификатор',
94  `date_added` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата добавления',
95  `customers_id` int(11) unsigned NOT NULL COMMENT 'Идентификатор пользователя добавившего',
96  `date_update` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Дата обновления',
97  `update_customers_id` int(11) unsigned DEFAULT NULL COMMENT 'Идентификатор пользователя обновившего',
98  `count_last_start_item` int(11) unsigned NOT NULL COMMENT 'Количество последних стартов товара в акциях',
99  `count_purchased_item_start` int(11) unsigned NOT NULL COMMENT 'Количество купленных товаров по формированию заказа поставщику от',
100  `count_purchased_item_end` int(11) unsigned NOT NULL COMMENT 'Количество купленных товаров по формированию заказа поставщику до',
101  `repeat_limit_days` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Ограничение на повтор или Архив(0)',
102  PRIMARY KEY (`archiving_conditions_id`)
103) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Условия архивации товара';
104
105-- insert rules
106INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'archiving-conditions');
107SET @rule1 = LAST_INSERT_ID();
108INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'remove-archivingConditions');
109SET @rule2 = LAST_INSERT_ID();
110INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'get-form-archivingconditions-edit');
111SET @rule3 = LAST_INSERT_ID();
112INSERT INTO `acl_rules` (`acl_rules_id`, `module`, `controller`, `action`) VALUES (NULL, 'call', 'categories-planning-settings', 'save-archiving-conditions-edit');
113SET @rule4 = LAST_INSERT_ID();
114
115INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`) VALUES (114, @rule1),(114, @rule2),(114, @rule3),(114, @rule4);
116
117# предзаполнение
118INSERT INTO `archiving_conditions` (`customers_id`, `update_customers_id`, `count_last_start_item`, `count_purchased_item_start`, `count_purchased_item_end`, `repeat_limit_days`)
119VALUES
120  (1, 1, 1, 0, 9999, 30),
121  (1, 1, 2, 0, 9999, 30),
122  (1, 1, 3, 0, 0, 60),
123  (1, 1, 3, 1, 9999, 30),
124  (1, 1, 4, 0, 0, 0),
125  (1, 1, 4, 1, 1, 45),
126  (1, 1, 4, 2, 9999, 30);
127-- Условия архивации товара (из задач 24725, 25471)
128
129
130CREATE TABLE `products_attributes_total` (
131  `products_attributes_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID из таблицы products_attributes',
132  `products_attributes_sales_count` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Кол-во проданных товаров, в т.ч. удаленные, отмененные и возвращенные',
133  PRIMARY KEY (`products_attributes_id`)
134)
135  COMMENT='Суммарные данные по product_attribute'
136  ENGINE=InnoDB
137;
138
139ALTER TABLE `categories_extra`
140	ADD COLUMN `is_primary_filling_report_sent` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Отправлен ли отчет поставщику при первичной заливке акции' AFTER `is_income_confirmed`;