Выполнить задания в SQL

A modern website is needed that will look good on both computers and phones. Requirements: attractive design; adaptation for all devices; user-friendly structure; form for collecting applications; fast website loading. I will provide texts, photos, and logo. In your proposal, please indicate the cost, completion time, and examples of your work.

There is a ready web tool for the sewing industry — the interface is made, part of the logic is there, but real integrations are not connected. It needs to be brought to a working state. Demo: https://prognoz.rich2222shop.site/Goal The system must accurately show how many and what positions (size/color) need to be cut, see the total remaining (stock + in cutting + returns), and reduce re-sewing by accounting for the statistics of refusals.Tasks Integration with LP CRM — connect via API (key/subdomain fields are already available), pull in stock, orders, returns. Bypass CORS through a proxy on Render.com. Cutting calculation logic — finalize the formula Plan − Stock CRM − In cutting + Returns to work with real data, calculate based on the size×color matrix. Accounting for refusals in the forecast — the % of refusals by size/color should reduce the cutting plan for that position, not just be displayed. Unified total stock — consolidate stock + in cutting + returns into one table. Workshops and cutting history — distribution by workshops, acceptance of returns, history of transfers. Bug fixes — some buttons are currently placeholders, they need to be brought to a working appearance.Stack HTML/JS single-page, localStorage, integration with LP CRM API, proxy on Render.com.Requirements Experience integrating CRM via REST API (plus — experience with retailCRM/LP CRM) Experience with proxy/CORS Understanding of warehouse/manufacturing logic Willingness to improve existing code without rewriting from scratchWork format Communication in writing (chat/messenger) → phased delivery (CRM → calculation logic → stock/workshops → polishing) → demo at each stage. It is important to understand the essence of the task, not just to formally execute the terms of reference — it is welcomed if you propose your own solutions or improvements where you see that it can be made more convenient or reliable.Budget / Timeline Budget: 6000 UAH (negotiable depending on the scope and phased delivery)

Hello, there is a website that needs optimization for page loading speed, where the page loads not in 1 second, but in 3 seconds. I need help with optimizing this issue. The site is WordPress WooCommerce. Here is a report and I need an assessment of the work and time for completion: https://pagespeed.web.dev/analysis/https-yuniko-us/u7tmi2y4b8?form_factor=desktop

We are looking for a specialist to create a website/landing page for selling window products: curtains, blinds, and pleated shades. We need not just a business card website, but a practical tool for sales, collecting applications, and further scaling. We are looking for a specialist who has already created similar website models: with product parameter selection, price calculation, applications/orders, and customer consultation. It is also important that the specialist understands working with a foreign audience, as the website is planned for sales not only in Ukraine but also in the European/Polish market. Main logic of the website: The client enters the website and has the opportunity to: Select a product. Select a color/option. Specify width and height. See the estimated or exact cost. Leave an application or place an order. In the future — pay online. It is also important to provide a consultation button if the client is unsure about measurements or product selection. For example: “Need help with measurements?” / “Get a consultation.” It is important for us that the client can not only call but also write to us and receive help online. Additional product: We also want to add pleated shades as an additional product or a cheaper alternative to the main curtains. This means the website should allow showing the client a simpler and more affordable option if the main product is too expensive for them. B2B direction: In the future, we want to have a B2B block or a separate page for wholesale clients: curtain salons, craftsmen, partners, manufacturers, wholesale buyers. There should be brief information about wholesale cooperation, the possibility to leave an application, and possibly an estimated pricing logic depending on quantity. What is needed from the specialist: Advise on how to best implement the website: CMS, builder, custom development, or another option. Propose an optimal website structure. Explain whether it is feasible to create a price calculator based on width and height. Advise on how to better organize applications/consultation/payment. Assess what can be done in the first stage and what is better to leave for later. Name estimated timelines and costs. It is important for us to launch the website in stages: first, create a minimal working version that can already collect applications or sales, and then gradually add more complex functionality. Work format: Initially, we want to conduct a short Zoom/Google Meet to show the product, explain the logic, and understand if you can help with the implementation. Before the meeting, we can send an approximate technical task and examples so that you understand in advance what product and what website logic we are talking about. This is not a final technical task, but a preliminary vision of the task that we want to discuss with the specialist.

A web application needs to be developed for automating order confirmation and offering additional products to customers via Viber. Orders are received in the CRM SalesDrive. General workflow: 1. The manager selects one or more orders from SalesDrive in the web application, chooses a scenario and one or more promotional flyers, and then initiates automatic processing. 2. A transactional message with order details: products, amount, payment method, city, delivery service, and branch/address is sent to the customer via Viber Business Messages. The customer chooses: — “Yes, continue”; — “Contact the manager”. 3. After confirmation, one or more selected promotional flyers with additional products are automatically sent to the customer. 4. The customer writes in free text form, in one or several messages, which products and in what quantity they want to add. After completing their selection, the customer presses the button “I have selected everything”. 5. The AI analyzes all customer messages and matches the selected items only with the products contained in the flyers sent to the customer. For each flyer, a structured list of products and their IDs/articles is stored in the system in advance. 6. The system generates a recognized list of products and quantities and sends it to the customer for confirmation. The customer chooses: — “Yes, correct”; — “Need to change”; — “Contact the manager”. 7. After confirmation, the selected additional products are automatically added to the existing order in SalesDrive. The amount and status of the order are changed. 8. After the order confirmation is completed, the customer is sent information about shipping times. Example: “The order will be shipped within 2 business days. If you need the fastest shipping, click the button below. We will take this into account when processing the order.” Buttons: — “All good”; — “Need fast shipping”. If the customer selects “Need fast shipping”, a corresponding mark or comment should be saved in the SalesDrive order. The automatic scenario continues at this point. 9. The customer is automatically sent an informational message about the need to inspect the package upon receipt. Example: “Please inspect the product at the delivery service branch upon receipt. If you find any mechanical damage, do not pick up the package and contact us. This will help us quickly resolve the situation.” Buttons and customer responses at this stage are not required. 10. The last message sent to the customer automatically includes the company's contact details. Example: “If you have any questions regarding the order, you can contact us: Phone: … Viber: … Telegram: …” Contact details and message text should be editable by the application administrator. 11. Non-standard cases are forwarded to the manager. For example: — the customer requests to change the order; — the customer chooses to contact the manager; — the AI could not unambiguously recognize the products or quantities; — the customer did not confirm the recognized list; — the customer sent an unsupported attachment; — a technical error occurred. After forwarding the order to the manager, the automatic scenario stops. Integrations: — SalesDrive API; — TurboSMS HTTP API / webhook, Viber Business Messages; — AI model API for recognizing free text from the customer. It is also necessary to implement: — a web panel for the manager; — receiving and displaying SalesDrive orders; — selecting one or more orders; — selecting a scenario; — selecting one or more flyers; — managing flyers and their associated products; — storing the state of the Viber dialogue; — dialogue history; — changing order statuses; — stopping the automatic scenario; — basic statistics. Incoming images, files, and voice messages from the customer do not need to be recognized. The AI works only with text. TurboSMS has confirmed the possibility of automatic message sending via HTTP API, receiving responses via webhook, and continuing the scenario within the Viber chat session. A detailed technical specification has been prepared and will be provided to the potential executor. In the response, please indicate: 1. The estimated cost of developing the MVP. 2. The estimated development time. 3. Whether there is experience with CRM/API/webhook integrations. 4. Whether there is experience integrating AI/LLM API for processing user text. 5. Examples of similar projects, if available.