«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
14
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);
«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
15
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.
«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
16
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.
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
М. 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
М. 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).
«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
17
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/vo
l2019/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.
