Formulation of customer’s orders on the online platform based on supply and demand Текст научной статьи по специальности «Строительство и архитектура»

т

tdshkent davlat «Актуальные вопросы развития инновационно-

rBAKISPOnTUNIVERSITETI 1 г „г Г1 ....

Ташкентский гесул; ровен™ информационных ТвХНОЛОГИИ НЭ транспорте» АВРИИТТ-2022

транспортный университет -г г -i г г

1-Республиканская научно-техническая конференция (Ташкент, 21-22 ноября 2022 года)

|Scîence

£Агв«уА ii*1« «1ч/ срасе

FORMULATION OF CUSTOMER'S ORDERS ON THE ONLINE PLATFORM BASED ON SUPPLY AND DEMAND

Shukirillaeva Mexriban,

Master student Tashkent State Transport University, Tashkent, Uzbekistan

Tokhirov Ezozbek

Associated professor, Tashkent State Transport University, Tashkent, Uzbekistan

etokhirov@yahoo.com DOI: https://doi.org/10.47689/978-9943-7818-0-1-v2-pp14-17

Abstract: This article envisages the creation and maintenance of an internet platform that accepts software orders based on supply and demand. The main goal of the theme is to guarantee the maximum ideality of the client's work.

Keywords: Software, customer-wholesaler, database.

Introduction

Currently, attention to the IT sector is growing in our country. Especially after the coronavirus quarantine, it increased significantly [1]. The number of people who are interested in programming and those who start learning it is increasing [2]. The number of educational centers providing education in various areas of IT is increasing [3]. The number of specialists in the IT market has also increased accordingly [4].

IT companies pay special attention to the fact that the specialist has a lot of experience and has worked on real projects when looking for employees [6]. It is natural that a programmer who has just graduated from the course does not have these skills, and they will have a hard time getting a job [7]. This platform is designed to solve this problem [8, 9]. The employer posts an ad on the platform and freelancers can apply for the job [10]. If the work is of good quality, it will be accepted and this work will be added to the freelancer's portfolio [11]. In this way, our platform helps young programmers to build a good portfolio [12].

Main Body

Creating an infological model of the database

The first step in creating this project is to create an info model. The goal of information modeling is to provide natural methods for people to describe and collect information that can be formed in the database being created. Therefore, an effort is made to build an infological model of data in accordance with natural language.

Creating an info model:

1. BOARDS (boards_id, title, description, img_url, admin_telegram, budget, is_completed, applicants, acceptance_data, finish_data, freelancer_id, project_link, materials_link, createdAt, updatedAt);

2. MESSAGES (message_id, name, phone_number, message, createdAt, updatedAt);

3. SKILLS (skill_id, createdAt, updatedAt);

4. SPONSORS (sponsor_id, logo, createdAt, updatedAt);

т

«Актуальные вопросы развития инновационно-

TÙSHKÉNT DAl/LAT

TRANSPORT UHIVERÈITETI „ »nr-ini дтт

ташкенгсиий/мдамтмниый информационных технологии на транспорте» АВРИИТТ-2022

гранспортный униаерсиг* " ~ ~ г г

1-Республиканская научно-техническая конференция

(Ташкент, 21-22 ноября 2022 года)

5. STATISTICS (statistics_id, in_search, projects_count, completed, hiring, createdAt, updatedAt);

6. USERS (user_id, first_name, last_name, email, password, avatar, phone_number, is_verified, telegram_username, web_site, git, bio, skills, type, role, createdAt, updatedAt);

7. ADMINS (admin_id, createdAt, updatedAt, user_id);

8. EDUCATIONS (education_id, edu_name, edu_fac, start_year, start_month, finish_year, finish_month, description, createdAt, updatedAt, user_id);

9. EXPERIENCES (experience_id, company_name, position, start_year, start_month, finish_year, finish_month, is_present, description, createdAt, updated At, user_id);

10. LANGUAGES (language_id, degree, language, createdAt, updatedAt, user_id);

11. PORTFOLIOS (portfolio_id, photo, project_name, project_link, createdAt, updatedAt, user_id);

Figure 1. Schema of tables in PostgreSQL Application of web platform database in practice

Below we will look at the database we created, that is, the use of all tables on the web platform.

т

tdshkent davlat «Актуальные вопросы развития инновационно-

rBAKISPOnTUNIVERSITETI 1 г „г Г1 ....

ташкентский гесул; рственчый информационных технологии на транспорте» АВРИИТТ-2022

транспортный университет -г г -т г г

1-Республиканская научно-техническая конференция (Ташкент, 21-22 ноября 2022 года)

|Scîence

¿АгвмуА ii*i« «14/ срасе

Figure 2. Announcements. (Boards)

The list of all announcements placed in the admin panel, that is, the data of the "Boards" table, is given in Figure 2.

Faol e'lonlar

E'lon sarlavhasi E'lon byudjeti E'lon qabul sanasi E'lon topshirish sanasl

Figure 3. Admin ad placement window.

As shown in Figure 3, the advertisement window in the admin panel contains the data of the "Boards" table, that is, the project name (name), project budget (budget), project description text (description), project T3 and additional files. link (materials_link), an image representing the project (img_url), the last date of acceptance and the last dates of project submission (acceptance_data, finish_data) and finally the telegram link to contact the admin (admin_telegram) is entered by the admin.

REFERENCES:

1. Aliev R., Tokhirov E., Aliev M. The mathematical model of the sensor for monitoring the state of the track section with current receivers// International Journal of Recent Technology and Engineering (IJRTE). ISSN: 2277-3878, Volume-8, Issue-5, January 2020. DOI: https://doi:10.35940/ijrte. E5936.018520 (Scopus; IF=0.158).

2. Aliev R., Tokhirov E., Aliev M. Analysis, development of a model and an algorithm in the concept of the growth of tone jointless rail circuits. Transportation Research Procedia Volume 63, 2022, Pages 178-186. (Scopus; IF=0.158).

т

IScience

гоанкенг ммьи «Актуальные вопросы развития инновационно-

ТЙЛНЁРОКТ иМ|^ЕИЁ|ТЕТ| 1 Г „Г Г1 „.,„

ташкентский гмУларстмниый информационных технологии на транспорте» АВРИИТТ-2022

транспортный унйаерсиг* " ~ ~ г г -

1-Республиканская научно-техническая конференция "•'->

(Ташкент, 21-22 ноября 2022 года)

3. Aliev R., Tokhirov E., Aliev М. Mathematical Model and Algorithm for Determining the Optimal Parameters of Sensors Control the Approach of a Train to a Crossing in Normal and Control Modes. AIP Conference Proceedings Том 243216 June 2022. International Conference on Problems and Perspectives of Modern Science, ICPPMS 2021 Tashkent 10 June 2021-11 June 202.1(Scopus; IF=0.158).

4. М.М. Алиев, Р.М. Алиев, Э.Т. Тохиров, Т.Р. Нурмухамедов. Четырехполюсные рельсовые коэффициенты бесколлекторной гусеничной цепи при наличии одного из концов гусеничной цепи изолирующего соединения// Ташкентский Государственный Технический Университет (1-чорагида). Химическая технология. контроль и управление. 2019, №4-5 (88-89) https://uzjournals.edu.uz/ijctcm/vol2019/iss4/6 (05.00.00; №12).

5. Р.М. Алиев, Э.Т. Тохиров. Определение оптимальных длин бесстыковых рельсовых цепей на переездах и перегонах // Тошкент ахборот технологиялари университети (1-чорагида). Научно-технический и информационно-аналитический журнал ТУИТ 2019, №4 (52), (05.00.00; №31).

6. Aliev R., Tokhirov E., Aliev М. Parameters of coefficients of the rail four-pole of the jointless rail circuit according to locomotive receiver // Tashkent State Technical University (1-choragida). Volume 2019 Issue 2. https://uzjournals.edu.uz/ btstu/vol2019/iss2/6, (05.00.00; №12).

7. Aliev R., Tokhirov E., Aliev М., Tashmetov K. Research the Length of the Braking Distance for Speed and High Speed Trains on Railway Sections// International Journal of Advanced Trends in Computer Science and Engineering. Volume 9, No.5, September - October 2020, DOI: https://doi.org/ 10.30534/ijatcse/2020/126952020 (Scopus; IF=9.84).

8. Aliev R., Tokhirov E., Aliev М. Methodology for Determining the Optimal Values of Resistance at the Ends of the Jointless Track Circuit with Considering Twofold Shunting// International Journal of Emerging Trends in Engineering Research, Volume 8. No. 9, September 2020. DOI: https://doi.org/10.30534/ijeter /2020/25892020 (Scopus; IF=6.99).

9. Tokhirov E. Security Improvement Techniques at Railway Crossings of Uzbekistan // Интеллектуальный технологии на транспорте №1, 2020, ISSN 2413-2527. Петербургский государственный университет путей сообщения Императора Александра 1. http://itt-pgups.ru/issue/viewIssue/194/86 (05.00.00; №110).

10. Aliev R., Tokhirov E., Aliev М. Model Microprocessor Device of Four-Wire Scheme of the Direction Change. German International Journal of Modern Science. №11 2021.vol. 1. 30-32. DOI:10.24412/2701-8369-2021-11-1-30-32 (40 ResearchGate).

11. Aliev R., Tokhirov E. Analysis and scientific methodological recommendations for reducing the delay on railway crossings. Interactive science. - 2021. - № 5 (60). DOI 10.21661/r-554252 (40 ResearchGate).

12. Tokhirov E., Aliev R., Aliev М. Devices to improve safety at level crossings // Технические науки: проблемы и решения: сб. ст. по материалам XLI Международной научно-практической конференции «Технические науки: проблемы и решения». - № 10(38). - М., Изд. «Интернаука», Москва-2020.