|
|
| Строка 1: |
Строка 1: |
| − | == Ссылки на дистрибы ==
| |
| − | https://www.standart-n.ru/files/source.html
| |
| | | | |
| − | == Инструкция по настройке автоматизации торговли Стандарт ==
| |
| − | [[Файл:Инструкция по настройке автоматизации торговли Стандарт 18-07-2022.zip]]
| |
| − |
| |
| − | == Скрипт для чистки клона клиентов ==
| |
| − | Должен выполнять без ошибок кроме таблиц LLT$DOCS и LLT$DOC_DETAIL
| |
| − | <pre>
| |
| − | -- 02.02.2022 Добавлена чистка Интернет заказов Мегаптека.ру
| |
| − | delete from MA$PROT;
| |
| − | SET GENERATOR GEN_MA$PROT_ID TO 0;
| |
| − | delete from I_ORDER_TASKS;
| |
| − | SET GENERATOR gen_i_order_tasks_id TO 0;
| |
| − | delete from I_ORDERS;
| |
| − | SET GENERATOR gen_i_orders_id TO 0;
| |
| − | delete from I_ORDER_DETAIL;
| |
| − | SET GENERATOR gen_i_order_detail_id TO 0;
| |
| − |
| |
| − | --11.08.2019 Добавлена чистка для АУ (Слава сказал обязательно)
| |
| − | delete from LLT$DOCS;
| |
| − | delete from LLT$DOC_DETAIL;
| |
| − | delete from ORDER_DATA;
| |
| − | delete from I_ORDERS;
| |
| − | delete from I_ORDER_DETAIL;
| |
| − |
| |
| − | --05/02/2021 AVO -->
| |
| − | delete from MARK_DETAIL;
| |
| − | SET GENERATOR GEN_MARK_DETAIL_ID TO 0;
| |
| − | ALTER TRIGGER MARK_DETAIL_TREB_AD_DISTR INACTIVE;
| |
| − | delete from MARK_DETAIL_TREB;
| |
| − | delete from MARK_REQUESTS;
| |
| − | SET GENERATOR GEN_MARK_REQUESTS_ID TO 0;
| |
| − |
| |
| − | delete from OUT$INKASS;
| |
| − | SET GENERATOR GEN_OUT$INKASS_ID TO 0;
| |
| − | delete from ANALYTIC_ANALIZ_TT;
| |
| − | SET GENERATOR GEN_ANALYTIC_ANALIZ_TT TO 0;
| |
| − | delete from REGISTRVZAIM;
| |
| − | SET GENERATOR GEN_REGISTRVZAIM_ID TO 0;
| |
| − | delete from REQUEST_HOZ;
| |
| − | SET GENERATOR GEN_REQUEST_HOZ_ID TO 0;
| |
| − | delete from DOC_HW;
| |
| − | SET GENERATOR GEN_DOC_HW_ID TO 0;
| |
| − | -- <--
| |
| − |
| |
| − | --Добавлено в чистку 09/01/2020 AVO -->
| |
| − | delete from SVODDATA;
| |
| − | delete from DOCS_PRIHOD_CONTROL;
| |
| − | delete from LABFAS;
| |
| − | SET GENERATOR gen_labfas_id TO 0;
| |
| − | delete from parts_history;
| |
| − | SET GENERATOR gen_parts_history_id TO 0;
| |
| − | delete from OUT$TRADERS;
| |
| − | SET GENERATOR gen_OUT$TRADERS_id TO 0;
| |
| − | delete from QUANT_FAS;
| |
| − | SET GENERATOR gen_QUANT_FAS_id TO 0;
| |
| − | -- <--
| |
| − |
| |
| − |
| |
| − | --19.06.2019 Добавлена чистка проблемной таблицы
| |
| − | delete from doc_pays;
| |
| − | SET GENERATOR GEN_DOC_PAYS_ID TO 0;
| |
| − | --end 19.06.2019
| |
| − |
| |
| − | delete from PRICES;
| |
| − | SET GENERATOR gen_prices_id TO 0;
| |
| − | --Отключаем режим все партии
| |
| − | ALTER TRIGGER AGENTS_WP_AIU0 INACTIVE;
| |
| − | ALTER TRIGGER PARTS_WP_AIU0 INACTIVE;
| |
| − | ALTER TRIGGER WARES_WP_AIU0 INACTIVE;
| |
| − |
| |
| − | delete from ANALYTIC_DOC_DETAIL_1;
| |
| − | SET GENERATOR gen_analytic_doc_detail_1_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_DOC_DETAIL_2;
| |
| − | SET GENERATOR gen_analytic_doc_detail_2_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_DOC_DETAIL_4;
| |
| − | SET GENERATOR gen_analytic_doc_detail_4_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_DOC_DETAIL_8;
| |
| − | SET GENERATOR gen_analytic_doc_detail_8_id TO 0;
| |
| − |
| |
| − | -- AVO 09/01/2020 -->
| |
| − | delete from ANALYTIC_ANALIZ_TT;
| |
| − | SET GENERATOR GEN_ANALYTIC_ANALIZ_TT TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_DOC_DETAIL_MALOHOD;
| |
| − |
| |
| − | delete from ANALYTIC_FALSIFICAT;
| |
| − | SET GENERATOR gen_ANALYTIC_FALSIFICAT_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_GNVLS;
| |
| − | SET GENERATOR gen_ANALYTIC_GNVLS_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_MIN_ASSORT;
| |
| − | SET GENERATOR gen_ANALYTIC_MIN_ASSORT_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_PRICE;
| |
| − | SET GENERATOR gen_ANALYTIC_PRICE_id TO 0;
| |
| − | --09/01/2020 <--
| |
| − |
| |
| − | delete from ANALYTIC_MIN_ENDT;
| |
| − | SET GENERATOR gen_analytic_enddt_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_DOCS;
| |
| − | SET GENERATOR gen_analytic_docs_id TO 0;
| |
| − |
| |
| − | delete from CASH_DOCS;
| |
| − | SET GENERATOR gen_cash_docs_id TO 0;
| |
| − | ALTER SEQUENCE GEN_CASH_DOCS_PACKET RESTART WITH 0;
| |
| − |
| |
| − | delete from CASH_DOC_DETAIL;
| |
| − | SET GENERATOR GEN_CASH_DOCS_DETAIL_ID TO 0;
| |
| − |
| |
| − | delete from ACTIVEUSERS;
| |
| − |
| |
| − | delete from WAREBASE;
| |
| − |
| |
| − | delete from DOCS_LOG;
| |
| − | SET GENERATOR GEN_DOCS_LOG_ID TO 0;
| |
| − |
| |
| − | delete from DSC_LOG;
| |
| − | SET GENERATOR gen_dsclog_id TO 0;
| |
| − |
| |
| − | delete from DOC_DETAIL_ACTIVE_MMBSH;
| |
| − |
| |
| − | delete from GROUP_DETAIL where GROUPTABLE='PARTS';
| |
| − |
| |
| − | delete from DOC_DETAIL_VIRTUAL;
| |
| − | delete from DOC_DETAIL_TRADERS;
| |
| − |
| |
| − | delete from LABFAS;
| |
| − | SET GENERATOR gen_labfas_id TO 0;
| |
| − |
| |
| − | delete from DOC_DETAIL_LOG;
| |
| − | SET GENERATOR gen_doc_detail_log_id TO 0;
| |
| − |
| |
| − | ALTER TRIGGER DOC_DETAIL_AD0 INACTIVE;
| |
| − | delete from DOC_DETAIL;
| |
| − | SET GENERATOR gen_doc_detail_id TO 0;
| |
| − | ALTER TRIGGER DOC_DETAIL_AD0 ACTIVE;
| |
| − |
| |
| − | delete from DOC_DETAIL_ACTIVE;
| |
| − | SET GENERATOR gen_doc_detail_active_id TO 0;
| |
| − |
| |
| − | delete from DOC_DETAIL_ACTIVE_LOG;
| |
| − | SET GENERATOR GEN_DOC_DETAIL_ACTIVE_LOG_ID TO 0;
| |
| − |
| |
| − | delete from DOC_DETAIL_DELETED;
| |
| − | SET GENERATOR gen_DOC_DETAIL_DELETED_id TO 0;
| |
| − |
| |
| − | delete from DOC_DETAIL_ACTIVE_NAMEID;
| |
| − |
| |
| − | update PARTS set doc_id=0, session_id=0, contract_id=0;
| |
| − |
| |
| − | delete from PARTS_LOG;
| |
| − | SET GENERATOR GEN_PARTS_LOG_ID TO 0;
| |
| − |
| |
| − |
| |
| − | delete from SHIFT_DETAIL_KKM;
| |
| − | SET GENERATOR GEN_SHIFT_DETAIL_KKM_ID TO 0;
| |
| − |
| |
| − | delete from DOC_DETAIL_ACTIVE_CANCELED;
| |
| − | delete from DOCS_CANCELED;
| |
| − |
| |
| − |
| |
| − | delete from DOCS where id<>0;
| |
| − | SET GENERATOR gen_docs_id TO 0;
| |
| − | ALTER SEQUENCE GEN_DOCS_PACKET RESTART WITH 0;
| |
| − | update docs set packet=0, COMMITSESSION_ID = 0, audit_id=0;
| |
| − |
| |
| − | delete from DOCS_CANCELED where id>0;
| |
| − |
| |
| − | delete from warebasefolders;
| |
| − |
| |
| − | delete from CONTRACTS where id>0;
| |
| − | SET GENERATOR gen_CONTRACTS_id TO 0;
| |
| − |
| |
| − | update SP$PRIVILEGES set SP$GRANTORSESSION_ID = 0;
| |
| − |
| |
| − | delete from SESSIONS where id>0;
| |
| − | SET GENERATOR gen_sessions_id TO 0;
| |
| − |
| |
| − | delete from WORKSTATIONS where id>0;
| |
| − | SET GENERATOR gen_workstations_id TO 0;
| |
| − |
| |
| − | delete from ZAKAZ_TMS;
| |
| − | SET GENERATOR GEN_ZAKAZ_TMS_ID TO 0;
| |
| − |
| |
| − | delete from W$INV_DETAIL;
| |
| − | SET GENERATOR gen_w$inv_detail_id TO 0;
| |
| − |
| |
| − | delete from W$INV;
| |
| − | SET GENERATOR gen_inv_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_DOC_DETAIL_MALOHOD;
| |
| − | SET GENERATOR gen_analytic_doc_detail8_id TO 0;
| |
| − |
| |
| − | delete from ANALYTIC_MIN_ENDT;
| |
| − | SET GENERATOR gen_analytic_enddt_id TO 0;
| |
| − |
| |
| − | delete from HUMAN_ACTION_LOGS;
| |
| − |
| |
| − | delete from INV_BARCODES;
| |
| − | SET GENERATOR GEN_INV_BARCODES_ID TO 0;
| |
| − |
| |
| − | delete from OUT$MONITORING;
| |
| − | SET GENERATOR GEN_OUT$MONITORING_ID TO 0;
| |
| − |
| |
| − | delete from OUT$MONITORING_LS;
| |
| − |
| |
| − | --Добавлено в чистку 09/01/2020 AVO -->
| |
| − | delete from SVODDATA;
| |
| − | delete from DOCS_PRIHOD_CONTROL;
| |
| − | delete from LABFAS;
| |
| − | SET GENERATOR gen_labfas_id TO 0;
| |
| − | delete from parts_history;
| |
| − | SET GENERATOR gen_parts_history_id TO 0;
| |
| − | delete from OUT$TRADERS;
| |
| − | SET GENERATOR gen_OUT$TRADERS_id TO 0;
| |
| − | delete from QUANT_FAS;
| |
| − | SET GENERATOR gen_QUANT_FAS_id TO 0;
| |
| − | -- <--
| |
| − |
| |
| − | ALTER TRIGGER WARES_TREB_AD_DISTR INACTIVE;
| |
| − | delete from WARES_TREB;
| |
| − | SET GENERATOR GEN_WARES_TREB_ID TO 0;
| |
| − | ALTER TRIGGER WARES_TREB_AD_DISTR ACTIVE;
| |
| − |
| |
| − | delete from WARES_WORK;
| |
| − |
| |
| − | update vals set packet=0 where id='0';
| |
| − | update wares set packet=0 where id='0';
| |
| − | update parts set packet=0 where id='0';
| |
| − | update docs set packet=0 where id='0';
| |
| − |
| |
| − | delete from Z$SYNC_DELETED;
| |
| − |
| |
| − | Delete from Z$SERVICE;
| |
| − | SET GENERATOR gen_z$service_id TO 0;
| |
| − |
| |
| − | --Delete from WAREBASE_DISTR;
| |
| − |
| |
| − | delete from RECEPTS;
| |
| − | SET GENERATOR GEN_RECEPTS_ID TO 0;
| |
| − |
| |
| − | delete from ATTRIBUTE_DETAIL;
| |
| − | SET GENERATOR GEN_ATTRIBUTE_DETAIL_ID TO 0;
| |
| − |
| |
| − | --Добавлено в чистку 20180213 AVO
| |
| − | ALTER TRIGGER DOCS_TREB_AD_DISTR INACTIVE;
| |
| − | delete from DOCS_TREB;
| |
| − | SET GENERATOR GEN_DOCS_TREB_ID TO 0;
| |
| − | ALTER TRIGGER DOCS_TREB_AD_DISTR ACTIVE;
| |
| − |
| |
| − | ALTER TRIGGER DOC_DETAIL_ACTIVE_TREB_AD_DISTR INACTIVE;
| |
| − | delete from DOC_DETAIL_ACTIVE_TREB;
| |
| − | SET GENERATOR GEN_DOC_DETAIL_ACTIVE_TREB_ID TO 0;
| |
| − | ALTER TRIGGER DOC_DETAIL_ACTIVE_TREB_AD_DISTR ACTIVE;
| |
| − |
| |
| − | delete from DOC_DETAIL_ACTIVE_CANCELED;
| |
| − | delete from DOC_DETAIL_VIRTUAL;
| |
| − | delete from WAREBASE_G;
| |
| − | --20180213 <--
| |
| − |
| |
| − | -->20150604
| |
| − | commit work;
| |
| − | update PARAMS set d$uuid=UUID_TO_CHAR(GEN_UUID());
| |
| − | commit work;
| |
| − | update PARTS set d$uuid=UUID_TO_CHAR(GEN_UUID());
| |
| − | commit work;
| |
| − | update SESSIONS set d$uuid=UUID_TO_CHAR(GEN_UUID());
| |
| − | commit work;
| |
| − | update USERS set d$uuid=UUID_TO_CHAR(GEN_UUID());
| |
| − | commit work;
| |
| − | update DOCS set d$uuid=UUID_TO_CHAR(GEN_UUID());
| |
| − | commit work;
| |
| − | update DOCS_CANCELED set d$uuid=UUID_TO_CHAR(GEN_UUID());
| |
| − | commit work;
| |
| − |
| |
| − | update params set param_value='' where param_id='EGAIS_FSRARID';
| |
| − | update params set param_value='0' where param_id='EGAIS_AUTO_MOVE';
| |
| − | update params set param_value='1' where param_id='EGAIS_WAYBILL_VER';
| |
| − | update params set param_value='0' where param_id='EGAIS_FORMBMODE';
| |
| − | update params set param_value='' where param_id='EGAIS_HOST';
| |
| − | /*AVO 09/01/2020*/
| |
| − | update params set param_value='2' where param_id='EGAIS_ALCCODE_CHECK';
| |
| − | commit work;
| |
| − |
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Стационар ') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Лаборатории') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Диагностические службы') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'ЭСФ Казахстан') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'ЕГАИС оптовики') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Дневной стационар(ДС)') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Круглосуточный стационар(КС)') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Поликлиника') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − | UPDATE GROUPS SET
| |
| − | STATUS = -1
| |
| − | WHERE (CAPTION = 'Пациент') AND
| |
| − | (GROUPTABLE = 'AGENTS ');
| |
| − |
| |
| − | COMMIT WORK;
| |
| − |
| |
| − | /* А.О. 01032018 Для не фармы убрать
| |
| − | UPDATE PARAMS SET ID = -130 WHERE PARAM_ID = 'ORG_ADDRESS_DETAIL';
| |
| − | COMMIT WORK;
| |
| − |
| |
| − | UPDATE PARAMS SET STATUS = 1 WHERE PARAM_ID = 'KAZ_ESF';
| |
| − | UPDATE PARAMS SET STATUS = 1 WHERE PARAM_ID = 'EGAIS';
| |
| − | UPDATE PARAMS SET STATUS = 1 WHERE PARAM_ID = 'ORG_ADDRESS_DETAIL';
| |
| − | UPDATE PARAMS SET STATUS = 1 WHERE PARAM_ID = 'INIT_SCALES';
| |
| − |
| |
| − | COMMIT WORK;
| |
| − | */
| |
| − |
| |
| − | --очистка egais_detail чтоб не пересекались в клонах doc_id
| |
| − | delete from egais_detail;
| |
| − | commit work;
| |
| − |
| |
| − | --Чистка G$DISTRIBUTE
| |
| − | alter index G$DISTRIBUTE_IDX1 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX2 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX3 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX4 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX5 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX6 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX7 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX8 inactive;
| |
| − | alter index G$DISTRIBUTE_IDX9 inactive;
| |
| − | commit work;
| |
| − |
| |
| − | delete from g$distribute d where coalesce(d.serverpacket,0)<(select max(g.serverpacket) from g$distribute g);
| |
| − | commit work;
| |
| − |
| |
| − | alter index G$DISTRIBUTE_IDX1 active;
| |
| − | alter index G$DISTRIBUTE_IDX2 active;
| |
| − | alter index G$DISTRIBUTE_IDX3 active;
| |
| − | alter index G$DISTRIBUTE_IDX4 active;
| |
| − | alter index G$DISTRIBUTE_IDX5 active;
| |
| − | alter index G$DISTRIBUTE_IDX6 active;
| |
| − | alter index G$DISTRIBUTE_IDX7 active;
| |
| − | alter index G$DISTRIBUTE_IDX8 active;
| |
| − | alter index G$DISTRIBUTE_IDX9 active;
| |
| − |
| |
| − | commit work;
| |
| − |
| |
| − | update agents set id=id where agents.deletedt is null; -->23042019 Иначе появляются дублирующие контрагенты и не обновляется
| |
| − | update users set id=id;
| |
| − | update docs set id=id;
| |
| − | update sessions set id=id;
| |
| − |
| |
| − | commit work;
| |
| − |
| |
| − | -->20180213
| |
| − | -- Чистка режима все партии
| |
| − | delete from WAREBASEPARTS;
| |
| − | commit work;
| |
| − |
| |
| − | --Включаем режим все партии
| |
| − | ALTER TRIGGER AGENTS_WP_AIU0 ACTIVE;
| |
| − | ALTER TRIGGER PARTS_WP_AIU0 ACTIVE;
| |
| − | ALTER TRIGGER WARES_WP_AIU0 ACTIVE;
| |
| − |
| |
| − | --Добавлено в чистку 09/01/2020 AVO -->
| |
| − | delete from g$distribute g where g.tablename=Upper('DOCS') and
| |
| − | not exists(select id from DOCS d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('DOC_DETAIL') and
| |
| − | not exists(select id from DOC_DETAIL d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('PARAMS') and
| |
| − | not exists(select id from PARAMS d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('PARTS') and
| |
| − | not exists(select id from PARTS d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('SESSIONS') and
| |
| − | not exists(select id from SESSIONS d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('USERS') and
| |
| − | not exists(select id from USERS d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('DOCS_CANCELED') and
| |
| − | not exists(select id from DOCS_CANCELED d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('VALS') and
| |
| − | not exists(select id from VALS d where d.d$uuid = g.uuid);
| |
| − | delete from g$distribute g where g.tablename=Upper('WARES') and
| |
| − | not exists(select id from WARES d where d.d$uuid = g.uuid);
| |
| − |
| |
| − | commit work;
| |
| − | -- 09/01/2020 <--
| |
| − |
| |
| − | --Сборка режима все партии
| |
| − | execute procedure updpr_warebaseparts(null,null,null,null);
| |
| − | commit work;
| |
| − | --20180213 <--
| |
| − |
| |
| − | </pre>
| |
