Укр
Укр
Eng

Результати пілотного проекту системи обліку медичних товарів e-Stock

Про підсумки пілоту системи управління запасами лікарських засобів та медичних виробів eStock⬇️

 

▪️ Систему намагались впровадити щонайменше останні 5 років. Приємно, що наша команда таки втілює ці прагнення в життя. Дякую Edem Adamanov, Alona Zhuzha, усій команді проекту та Медичні закупівлі України, а також залученим медичним інформаційним системам та партнерам!  

 

▪️ Завдяки розробці перших двох модулів з січня 169 закладів охорони здоров’я мали змогу подати потребу за напрямами «Доросла онкологія» та «Ендопротези і набори для трансплантації». Мова про 123 позиції. У середньому збір заявок, їх верифікація та розрахунок кількості до закупівлі тривали півтора місяці.  

 

▪️ Серед переваг користувачі відзначили зручність інтерфейсу та легкість у роботі, а також оперативну реакцію ІТ-команди Медичні закупівлі України на технічні питання під час збору потреб. 

 

▪️ Робота над розробкою наступних модулів триває. По завершенню в системі eStock будуть зібрані та оновлюватимуться в реальному часі всі дані про потребу, доставку, наявність препаратів у лікарнях, їх використання, утилізацію, тощо.

 

Детальніше за посиланням:

Урядовий портал

🛠 System Debug

⏱️ Backend Time: 0.049 s
⚙️ PHP Core: 0.0458 s (93%)
🗄️ MySQL: 0.0032 s (7%)
🌐 Downloaded Assets: замер...
Сбор данных об ассетах...
📊 Waterfall Timeline:
Расчет таймингов сети...
🧠 Memory Profile: 1.17 MB (Peak: 17.1 MB)
📦 OS Allocated: 18 MB
🛑 Server Limit: 1536M

🧭 Environment Constants

ROOT: /home/avh/nauo.in.ua/www
WAY_TO_ROOT: ../../../
DOMAIN: nauo.in.ua
LANG: ua

🗺️ Routing

Controller: EventsController
Action: actionEvent

Parameters:
0: 15_rezultati-pilotnogo-proektu-sistemi-obliku-medichnih-tovariv-e-stock

⚙️ Internal Params

INT_CONTROLLER: EventsController
INT_ACTION: actionEvent

INT_PARAM_0: 15_rezultati-pilotnogo-proektu-sistemi-obliku-medichnih-tovariv-e-stock

🌐 External Params

EXT_COUNT: 3

EXTERNAL_PARAM_0: ua
EXTERNAL_PARAM_1: kalendar-podiy
EXTERNAL_PARAM_2: 15_rezultati-pilotnogo-proektu-sistemi-obliku-medichnih-tovariv-e-stock

🍪 Cookies (Site only)

No site cookies active.

🗄 Database (165 queries)

Total Time: 0.0032 sec.

[0.0003s] SELECT `config_id`, `config_value` FROM `system_config`
[0.0001s] [PREPARE] SELECT `events_id` FROM `site_events` WHERE `events_id` = :id AND `events_nameua` = :name AND `events_yes` = '1' LIMIT 1
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pageid
[0.0001s] [PREPARE] SELECT * FROM `site_events` WHERE `events_id` = :id
[0.0001s] [PREPARE] SELECT `languages_order` FROM `system_languages` WHERE `languages_name` = :lang
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `system_pagesstandalone` WHERE `pagesstandalone_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `site_menu0` WHERE `menu0_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `site_events` WHERE `events_id` = :id
[0.0001s] SELECT * FROM `system_languages` WHERE `languages_yes`='1' ORDER BY `languages_order` ASC
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `site_menu0` WHERE `menu0_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `site_events` WHERE `events_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `site_menu0` WHERE `menu0_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `system_pages` WHERE `pages_id` = :pid
[0.0001s] [PREPARE] SELECT * FROM `site_events` WHERE `events_id` = :id
[0.0002s] SELECT * FROM `site_headers`
[0.0001s] [PREPARE] SELECT `tables_id` FROM `cmssite_tables` WHERE `tables_name` = 'site_info' LIMIT 1
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_info'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '72'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '72'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '72'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '72'
[0.0002s] SELECT * FROM `site_info`
[0.0001s] [PREPARE] SELECT * FROM `site_galleries` WHERE `galleries_table` = :tid AND `galleries_parent` = :pid ORDER BY `galleries_id` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_galleries` WHERE `galleries_table` = :tid AND `galleries_parent` = :pid ORDER BY `galleries_id` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_galleries` WHERE `galleries_table` = :tid AND `galleries_parent` = :pid ORDER BY `galleries_id` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_galleries` WHERE `galleries_table` = :tid AND `galleries_parent` = :pid ORDER BY `galleries_id` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_galleries` WHERE `galleries_table` = :tid AND `galleries_parent` = :pid ORDER BY `galleries_id` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_galleries` WHERE `galleries_table` = :tid AND `galleries_parent` = :pid ORDER BY `galleries_id` ASC
[0.0002s] SELECT * FROM `system_messages`
[0.0002s] SELECT `menu_id` FROM `system_menu` ORDER BY `menu_id` ASC
[0.0002s] SELECT * FROM `system_menu` WHERE `menu_id` = '1' AND `menu_yes` = '1'
[0.0001s] SELECT * FROM `system_menu` WHERE `menu_parenttable`='1' LIMIT 1
[0.0002s] SELECT * FROM `site_menu0` WHERE `menu0_yes`='1' ORDER BY CAST(`menu0_order` AS UNSIGNED) ASC
[0.0003s] SELECT * FROM `site_forms`
[0.0001s] SELECT `forms_id` FROM `site_forms`
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] SELECT * FROM `system_languages` WHERE `languages_yes`='1' ORDER BY `languages_order` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0001s] [PREPARE] SELECT * FROM `site_forms` WHERE `forms_id` = :id
[0.0004s] SELECT * FROM `site_contacts` WHERE `contacts_yes` = '1' ORDER BY `contacts_id` ASC
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0.0001s] SELECT * FROM `site_contacts` WHERE `contacts_yes` = '1' ORDER BY `contacts_id` ASC
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_contacts'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '60'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '60'
[0.0002s] SELECT * FROM `site_contactsblocks` WHERE `contactsblocks_yes` = '1' ORDER BY `contactsblocks_order` ASC
[0.0002s] SELECT * FROM `site_links` WHERE `links_yes` = '1' ORDER BY `links_order` ASC
[0.0001s] [PREPARE] SELECT * FROM `cmssite_tables` WHERE `tables_name` = 'site_mainimages'
[0s] [PREPARE] SELECT * FROM `cmssite_images` WHERE `images_table` = '63'
[0s] [PREPARE] SELECT * FROM `cmssite_video` WHERE `video_table` = '63'
[0s] [PREPARE] SELECT * FROM `cmssite_files` WHERE `files_table` = '63'
[0s] [PREPARE] SELECT * FROM `cmssite_galleries` WHERE `galleries_table` = '63'
[0.0002s] SELECT * FROM `site_mainimages` WHERE `mainimages_yes` = '1' ORDER BY `mainimages_order` ASC
[0.0001s] [PREPARE] SELECT * FROM `site_events` WHERE `events_id` = :id LIMIT 1

📥 Input Inspector

No incoming data (GET, POST, SESSION are empty).

📄 Included Files (56)

📁 /index.php
📁 /components/Autoload.php
📁 /components/App.php
📁 /components/Db.php
📁 /config/db_params.php
📁 /components/Functions.php
📁 /components/functions/date_types.php
📁 /components/functions/filter_data.php
📁 /components/functions/get_model_file.php
📁 /components/functions/get_model_image_different.php
📁 /components/functions/get_model_image_single.php
📁 /components/functions/get_model_images_gallery.php
📁 /components/functions/get_model_images_multiple.php
📁 /components/functions/get_model_video.php
📁 /components/functions/limit_letters.php
📁 /components/functions/limit_words.php
📁 /components/functions/make_transliterated_url.php
📁 /components/functions/make_transliterated.php
📁 /components/functions/manage_parents_arr.php
📁 /components/functions/marked_search.php
📁 /components/functions/phone_number.php
📁 /components/functions/removedir.php
📁 /components/functions/rmrec.php
📁 /components/functions/system_title_create_lang.php
📁 /components/functions/ucfirst.php
📁 /components/functions/upper_decode.php
📁 /components/functions/youtube_embed.php
📁 /components/Router.php
📁 /config/routes.php
📁 /controllers/site/EventsController.php
📁 /models/site/Page.php
📁 /controllers/commons.php
📁 /models/site/Headers.php
📁 /models/site/Info.php
📁 /models/site/System.php
📁 /models/site/Menu.php
📁 /models/site/Form.php
📁 /models/site/User.php
📁 /models/site/Contacts.php
📁 /models/site/Links.php
📁 /models/site/Mainimages.php
📁 /models/site/Events.php
📁 /views/site_pages/events/event.php
📁 /views/head.php
📁 /template/js/visits.php
📁 /views/header.php
📁 /views/menu/contactstop.php
📁 /views/menu/menutop/menutop.php
📁 /views/menu/menutop/menutop_buttons.php
📁 /views/menu/menutop/menutop_buttonslist.php
📁 /views/menu/menufull/menufull.php
📁 /views/menu/menufull/menufull_buttonslist.php
📁 /views/menu/flags/flags_words_dropdown.php
📁 /views/parts/breadcrumbs.php
📁 /views/footer.php
📁 /components/ShowSiteData.php