The Telegram Bot

Technical Assignment1. General Task A new corporate website needs to be created on WordPress for the domain sovbau.com and hosted on a new hosting instead of the current custom-built site. Domain: sovbau.com Current Site: custom-built site hosted on VPS/virtual server New Platform: WordPress New Hosting: regular hosting Main Language of the Site: German Additional Language: English Type of Site: corporate website of an electrical installation company, not an online store The site is currently hosted on a VPS/virtual server. A new site needs to be created on WordPress on new hosting, and after the development is completed, the domain sovbau.com should be switched from the current VPS to the new hosting. The old custom code does not need to be transferred. The current site should be used as: — a visual reference; — a source of important photos and materials; — a source of general information about the company. After the work is completed, the site owner should be able to independently edit texts, photos, services, projects, contact details, pages, gallery, and main blocks of the site through the WordPress admin panel.2. Corporate Email and DNS The corporate email will be hosted on a separate email hosting. There is no need to set up email on the site hosting. When connecting the new hosting, only DNS records related to the site can be changed, for example: — A record; — CNAME. It is not allowed to change or disrupt the operation of email DNS records: — MX; — SPF; — DKIM; — DMARC. Switching the site to new hosting should not disrupt the operation of corporate email.3. Main Scope of Work It is necessary to: Install and configure WordPress on the new hosting. Create a new corporate website on WordPress for the domain sovbau.com. During the development, host the new site at a technical address, subdomain, or temporary environment so that the current site continues to operate until the project is completed. After completion and verification of the new site, switch the domain sovbau.com from the current VPS/virtual server to the new hosting. Preserve and transfer important photos and materials from the old site. Organize the transferred photos and materials into a separate gallery. Make the German version of the site the main one. Create an additional English version of the site. Set up convenient switching between the German and English versions. Update contact details: use corporate addresses on the domain sovbau.com instead of Gmail. Create a modern corporate design for the electrical installation company. Ensure responsive display of the site on computers, tablets, and phones. Set up a contact form on the "Contact" page. Set up a separate request submission form via the button Anfrage senden. Configure the sending of messages and requests to the specified corporate email. Set up an SSL certificate so that the site opens correctly via HTTPS. Set up basic SEO based on the provided texts: — correct structure of H1 and H2 headings; — title and meta description for main pages; — human-readable URLs; — sitemap.xml; — robots.txt; — correct alt texts for images. Optimize the loading speed of the site. Set up protection for forms against spam. Set up the ability for independent editing through WordPress: — texts; — photos; — services; — projects and references; — contact details; — pages; — gallery; — blocks on the main page; — information on the "For Partners" page; — information on the "Career" page. After the work is completed, transfer all access and briefly explain how to independently edit the site.4. Design Requirements The new site should visually resemble the current site sovbau.com in overall style: — modern corporate appearance; — technical style; — dark or contrasting technical accents; — large informational blocks; — strict and clear structure; — professional presentation of services and completed projects. The old site does not need to be copied one-to-one. The design and structure of the current site can be reworked and improved. The new site should be similar in overall visual direction but look more modern, neat, and user-friendly. The freelancer can suggest improvements: — page structures; — block placements; — main menu; — mobile version; — gallery; — contact form; — request form; — visual presentation of services; — buttons and calls to action. Significant changes to the structure and design must be agreed upon in advance.5. Site Structure The main menu should include the following sections: Home About the Company Services Projects / References Gallery For Partners Career Contact There should also be a separate noticeable button in the top menu: Anfrage senden6. Dropdown Menu "Services" The "Services" item should have a dropdown menu. When hovering over or clicking on the "Services" item, seven main directions should open: — General electrical installation and equipment connection; — Power and low-voltage systems; — Fire systems / BMA, SAA, ELA, E30/E90; — Network and IT cabling systems / Cat.7; — MSR / Building automation / KNX; — Security and communication systems; — Electrical connection of technical equipment. On the "Services" page, separate blocks or cards should be created for these same seven directions. The cards should contain: — service name; — description; — image. Buttons or links to separate pages for each service are not needed. All cards, images, and texts should be editable through WordPress. Texts for the site will be provided separately.7. Content of the "Services" Page1. General Electrical Installation and Equipment Connection General electrical installation work at sites, installation and connection of fixtures, LED systems, motion sensors, lighting control systems, sockets, cabinets, devices, and technical equipment.2. Power and Low-Voltage Systems Installation and connection of power cables, distribution lines, as well as cables for communication, alarm, control, and data transmission systems.3. Fire Systems / BMA, SAA, ELA, E30/E90 Installation of cables, assembly and connection of fire alarm components, electrical components of sprinkler systems, voice alarm and evacuation systems, emergency and evacuation lighting systems, as well as fire-resistant cable lines E30/E90.4. Network and IT Cabling Systems / Cat.7 Installation and connection of network cables, installation of patch panels, network sockets, servers, and IT infrastructure equipment.5. MSR / Building Automation / KNX Installation of cables, assembly and connection of measurement, control, and regulation systems, KNX/Smart Building, automation, ventilation, air conditioning, valves, sensors, and actuators.6. Security and Communication Systems Installation of cables, assembly and connection of video surveillance systems, access control, security alarms, intercom, communication, and negotiation systems.7. Electrical Connection of Technical Equipment Connection of pumps, drives, sensors, control cabinets, and other technical equipment.8. Main Page The main page should include the following blocks: First screen with the main heading, company description, and button Anfrage senden. Brief block "About the Company". Block with main services. Block "Company Advantages". Block with types of objects the company works on. Map of the company's operational regions. Block "Projects / References". Block with photos of completed works. Block "Formats of Cooperation". Block "Career". Contact block. Additional call to submit an application. All main blocks of the main page should be editable through WordPress.9. Transitions from Main Page Blocks9.1. Block "About the Company" The block should contain brief information about the company. When clicking the button Mehr über uns, "More details" or a similar button, the user should be directed to the "About the Company" page.9.2. Block with Main Services The main page should briefly showcase the main areas of the company's activities. The block should contain a button to transition to the general "Services" page. Separate pages for each service are not required.9.3. Block "Company Advantages" The block should show the main advantages of the company, for example: — qualified electrical installation teams; — experience working on large projects; — own transport and tools; — German or English-speaking responsible employee in the team; — work according to project documentation and LV; — adherence to deadlines; — ability to increase the number of workers depending on the project volume. At the bottom of the block, a button Mehr über uns or "More about the company" should be placed. When clicked, the user should be directed to the "About the Company" page. The block does not necessarily need to be fully clickable.9.4. Block with Types of Objects The main page should show the main types of objects the company works on, for example: — industrial facilities; — hospitals and medical institutions; — office and administrative buildings; — residential complexes; — commercial properties; — technical and server rooms; — new buildings; — reconstructed objects. A separate page for this block is not required.9.5. Map of Operational Regions The main page should include a map of the company's operational regions. It is preferable to use a map of Germany and Europe with visual highlighting of the countries or regions where the company performs or is ready to perform projects. Next to the map, a brief text about the geography of the company's work should be provided. The map should: — match the overall style of the site; — display correctly on computers, tablets, and phones; — not significantly slow down the site's loading; — be editable or replaceable through WordPress. Below the map, a button Projekt anfragen or Anfrage senden leading to the application page can be placed. A separate interactive map with the office address can be placed on the "Contact" page if necessary.9.6. Block "Projects / References" The main page should showcase several projects or references. The block may contain: — photos; — project name; — location; — brief indication of completed works. When clicking on a project, image, or button Alle Projekte ansehen, the user should be directed to the "Projects / References" page.

I want a bot for Telegram. Loading dialogues. With the help of AI, checking for potential lies. A website with advanced features. Registration, API, statistics, etc.

It is necessary to migrate the Opencart online store from PHP 7.4 to PHP 8.x. Currently, the core version is 3.0.3.8. We read that most likely the core will also need to be migrated to version 4.0 and there shouldn't be many difficulties... The functionality is mostly custom, and there are also Simple, OCFilter, Nova Poshta. We are waiting for recommendations and an approximate price. Ideally, someone who has already done similar work.

It is necessary to perform the update, transfer, and configuration of Laravel projects to a new server, ensuring stable operation, security, protection against exploits, and correct functioning of all services after migration. 1. Main tasks Prepare the new server for operation. Transfer project files, databases, configurations, and cron jobs. Update server software. Configure a secure environment for Laravel. Check compatibility of PHP, Laravel, Composer packages, and dependencies. Ensure protection against known exploits, malicious requests, and unauthorized access. Set up SSL certificates. Check the functionality of the websites after the transfer. 2. Transfer of Laravel projects For each project, it is necessary to: Transfer project files. Transfer the database. Transfer the .env configuration. Set directory access permissions: storage bootstrap/cache Check functionality: homepage; admin panel; authorization; forms; API; file uploads; email sending; cron jobs; queue workers.3. Security and protection It is necessary to implement basic and application-level protection: close root access via SSH; configure SSH access only via keys; change the default SSH port if necessary; configure the firewall; allow only necessary ports; install Fail2Ban; hide service versions of Nginx/Apache/PHP; restrict access to .env, .git, backup files, log files; set correct file permissions; check projects for malicious files; check Composer packages for known vulnerabilities; update dependencies if it does not break functionality; configure protection against SQL injection, XSS, CSRF, and path traversal; check the correctness of Laravel APP_ENV and APP_DEBUG; set APP_DEBUG=false in production; configure rate limiting for critical endpoints; check access to storage/uploads; configure protection against PHP execution in upload directories; check access rights to admin panels. 4. SSL and domains It is necessary to: Install SSL certificates. Configure automatic SSL renewal. Enable redirect from HTTP to HTTPS. Check the correct operation of websites via HTTPS. 5. Backup It is necessary to configure backup: project files; databases; .env files; uploaded media; cron configurations; Nginx/Apache configurations. Backup should be performed automatically on a schedule. It is preferable to store copies separately from the main server. 6. Post-transfer verification After migration, it is necessary to check: absence of 500/403/404 errors; absence of critical errors in Laravel logs. 9. Result of execution After the work is completed, there should be: Laravel projects successfully transferred to the new server; websites are functioning stably; SSL is configured; the server is protected with basic security settings; access to critical files is restricted; backup is configured; cron and queues are operational; the old server can be turned off after final verification.

Development of Two Specialized Websites for Selling Spare PartsGeneral Information It is necessary to develop two specialized websites: Spare parts for ATVs, UTVs, SSVs, and other similar equipment. Spare parts for special equipment. Existing company website: https://kiaparts.com.ua/ The new projects should not be copies of the existing website. A modern solution should be proposed with an emphasis on SEO, speed of operation, convenience for clients and managers, as well as the possibility of further development and scaling.Main Goal of the Project To create not just an online store, but a platform for selling spare parts that will: be well indexed by Google; attract organic traffic; be easy for managers to fill; support large product catalogs; be easily scalable in the future. For me, it is more important to achieve the correct architecture and foundation of the project than to have a large number of features in the first version.Project Architecture Two separate websites are needed for clients. At the same time, it is desirable that they be built on a single platform: one administrative panel; shared functionality; one or related databases; separate domains; separate content; the possibility of different designs and layouts for each project. That is, essentially two separate websites for the client, but one management system for the company. The advantage will be a modular architecture that will allow launching new projects on the same platform in the future.SEO (one of the main priorities) The main task of the website is not only to sell products but also to gain maximum organic traffic from Google. For each spare part, a separate product page with its own URL must be created. An example of an existing product page is attached, demonstrating the general principle of filling in SEO information. For each product, it should be possible to add: part number; OEM number; cross numbers; analogs; brand; name; alternative names; characteristics; photos; description; PDF files; list of applications; list of equipment models. The main goal: For one spare part to be able to receive traffic from dozens of different search queries: OEM number; cross number; analog; name; brand; equipment model.Important Regarding Data Structure I do not want managers to manually write large texts for each page. It is desirable to implement a structured data system: Product → OEM number → Cross numbers → Analogs → Applications → Equipment models → SEO page That is, the manager fills in the information once, and the system uses it for: SEO; search; interlinking; filters; analogs.Catalog and Search It is necessary to implement search: by number; by part number; by OEM number; by cross number; by name; by brand. Desirable: auto-suggestions; fast search; search for analogs; fast operation even with a large catalog.Import and Update of Products Mandatory: Excel import; CSV import; data export; bulk price updates; bulk stock updates; bulk description updates; bulk photo updates; bulk SEO data updates.Inventory Management It is necessary to implement: multiple warehouses; availability display; product reservation; stock synchronization. In the future, the ability to synchronize with the old main website and other company projects will be necessary.Security It is necessary to provide for: administrative panel protection; two-factor authentication; access rights segregation; user action log; protection against common attacks; API and integration protection.Backup It is necessary to implement: automatic database dumps; automatic file backups; photo backups; document backups; automatic saving of copies to the cloud (Google Drive, AWS, Backblaze, or similar services); the ability for quick recovery after a failure or hacking.Further Development In the first stage, the implementation of the functionality listed below is not mandatory. However, the architecture should allow for its further implementation without the need to create a new website. In the future, the following may be implemented: AI search in the catalog; AI generation of product descriptions; AI generation of SEO content; automatic search for analogs; integration with CRM; integration with suppliers via API; automation of manager work; sales analytics; B2B client cabinets; marketing tools. Therefore, it is important that the architecture is ready for further development.Examples of Websites Like in structure, logic, and convenience: Chrysler.com.ua Secoparts.net Comtac.parts RockAuto.com There is no need to copy the design of these websites. They are provided as examples of a convenient catalog structure, search, and information presentation.Platform The use of OpenCart, WordPress/WooCommerce, or other platforms is allowed. Main requirements: good SEO architecture; fast operation; scalability; availability of API; possibility of further development. Please justify the choice of platform and explain the prospects for project development on it.Budget Estimated budget for the first stage: 3,000 – 7,000 USD for the entire project (two websites on a single platform). The budget can be reviewed after discussing the architecture and implementation stages. I am ready to consider phased implementation, but it is preferable to implement part of it more urgently for launch. It is more important to achieve the correct architecture and quality foundation for further development than to have the maximum number of features in the first version.What I Expect from the Contractor proposal for architecture; platform recommendation; examples of similar works; estimated budget; estimated timelines; vision for further project development. Experience in creating catalogs of auto parts, stores with searches by OEM numbers and cross numbers, as well as projects with large product catalogs will be a big plus. Also, please add a brief description of how you see the SEO architecture of the project and how organic growth of the catalog will be ensured. Photos are attached for a simple example of a page for organic search.