Integration of Trello and KeyCRM

Development of a Telegram Mini App (Bot + WebApp) for selling digital goods and in-game currencies (Python / aiogram) Project description: A Telegram bot with a full WebApp interface is required for the automated sale of digital goods (Telegram Stars, Telegram Premium, in-game currencies/donations for PUBG Mobile, Steam, etc.). The project is called Aspect App. The main focus is on speed, smooth UI/UX in a Web3/minimalist style, and complete automation of product delivery after payment. Technology stack: Backend: Python 3.10+, aiogram 3.x (FastAPI for Webhook/API is welcome). Database: PostgreSQL / Redis (for sessions and caching). Frontend (WebApp): React.js / Vue.js / Next.js (at the developer's discretion, speed and smoothness of animations are important). Integrations: Telegram WebApp API. Main functionality (MVP): 1. Client side (Telegram Mini App): Main screen: Product categories (Telegram Assets, In-game Donations). Banner grid for promotions. Product catalog: Product cards with volume selection (e.g., 50, 100, 500 Telegram Stars or UC). Fields for entering player data (Player ID for PUBG). Cart and Checkout: Quick purchase in 2 clicks. Payment module: Integration of payment methods (CryptoBot API / TON Connect / other fiat gateways by agreement). Personal account: Order history, status tracking, referral system (balance within the app). 2. Admin panel (built into WebApp or separate bot): Catalog management (adding/removing products, changing prices). Order monitoring and sales statistics. User database mailing system. 3. Automation logic (A plus): Readiness of the architecture for integration with supplier APIs (API for auto-purchasing Stars/UC). At the MVP stage, some products may be issued with codes from the database. What is required from the contractor: 1. Development of the database and backend architecture in Python. 2. Layout and integration of WebApp (design mockup to be discussed, clean Web3 style, Glassmorphism is important). 3. Setting up secure transactions and payment webhooks. 4. Deployment on the server (Docker, Ubuntu, SSL setup). Candidate requirements: Experience in commercial development of Telegram WebApps for at least 1 year. Portfolio with launched and working Mini Apps (please provide links in your response). Clean, documented code. Working conditions: Work only through the Secure Deal (Safe / Escrow) of the platform. Payment is staged (the project is divided into Sprint 1: Backend + DB, Sprint 2: Frontend WebApp, Sprint 3: Payment integration and testing). Budget: To be discussed with the successful candidate (please indicate your price range and timelines in your response)

Technical task for a Telegram bot / mini-platform 1. Project goal Create a Telegram bot and mini-platform for finding specialists and posting requests from users. The user can leave a request, the specialist can respond, the administrator controls publications, moderation, payment, and security. 2. User roles User: can register; confirm phone number and email; create a request; view specialists; receive responses. Specialist: can register; fill out a questionnaire; specify services, prices, city, experience; add photos of completed work; respond to requests. Administrator: can moderate requests; verify specialists; review complaints; manage advertising; control payments; block users. 3. Registration Mandatory: confirmation of phone number via Telegram or code; confirmation of email via link or code; without confirmation of phone and email, the request is not published. 4. Requests The user fills out: service category; task description; city/region; deadline; budget; photo (if necessary); contact details. Limitations: no more than three requests per day from one user. 5. Moderation All requests initially go for moderation. Automatically block or send for manual review: photos of category 18+; spam; offensive statements; suspicious links; duplicate requests; mass requests from one account. 6. Specialists Specialist questionnaire: name; city; services; experience; prices; portfolio; photo; description; link; reviews; verification status. Important: the platform is not responsible for the quality of the specialist's services. This must be stated in the user agreement. 7. Payment Monetization options: paid placement of the specialist's profile; paid boosting of the profile; paid access to requests; advertising after approval by the administrator; subscription for specialists. Integrate payment: Stripe / Przelewy24 / PayU / Fondy — as per the developer's capabilities. 8. Administrative panel It is necessary to create a convenient admin panel: list of users; list of specialists; requests under moderation; complaints; payments; statistics; blocking users; editing categories; managing advertising; manual approval or rejection of publications. 9. Security Mandatory: protection against spam; request limit; message limit; protection against mass registrations; action logging; database backup; file and photo verification; CAPTCHA or other spam protection mechanism; blocking by phone number, IP address, or Telegram ID. 10. Responsibility The user agreement must specify: the platform is not an employer; the platform is not responsible for the actions of specialists; the user independently makes decisions about cooperation; the administration has the right to delete a request or profile without explanation; advertising is published only after approval by the administrator; spam, fraud, 18+ content, and any manifestations of aggression are prohibited.

Need a DevOps / Linux administrator for deploying a Telegram bot on a VPS. Specifically, server setup and production deployment are required. Project stack: Node.js 20+, Telegraf, Express, Prisma, PostgreSQL, Redis, Docker, Docker Compose, Telegram Mini Apps, OCR. What needs to be done: 1. Prepare Ubuntu VPS. 2. Set up SSH access with keys. 3. Configure the firewall. 4. Install Docker and Docker Compose. 5. Set up PostgreSQL. 6. Set up Redis. 7. Configure Nginx. 8. Connect the domain and SSL Let’s Encrypt. 9. Configure production .env. 10. Run Prisma migrations. 11. Launch the Node.js application. 12. Set up Telegram webhook. 13. Check /health and /ready. 14. Set up PostgreSQL backup. 15. Leave instructions on how to update, restart, view logs, and restore backup. Important: - No need to rewrite the code. - The project needs to be deployed on a VPS. - A person with experience in Docker + Node.js + PostgreSQL + Redis + Nginx is required. - It is preferable to show 2–3 similar projects.

Project: YOKA ASSIST — intelligent diagnostic and training system for mining equipment Project Description It is required to develop the YOKA ASSIST intelligent system based on a Telegram bot using artificial intelligence. The main task of the project is to create a digital assistant for electricians, mechanics, operators, and engineering and technical personnel, which will assist in diagnosing faults, training employees, and storing a technical knowledge base. The first stage of the project is focused on mining equipment (EKG excavators, SBSh drilling rigs, and other equipment), but the architecture should be universal and easily scalable. Main Functionality Telegram Bot - Modern interface. - Menu with buttons. - User authorization. - Access rights separation (user, administrator, chief administrator). Artificial Intelligence Knowledge Base A knowledge storage system needs to be created. Support: - PDF; - Word; - Excel; - photographs; - diagrams; - videos; - instructions; - equipment passports; - technical documents. After information is added by the administrator, the AI should use it in responses without changing the program code. Equipment Diagnostics Search support: - by error code; - by protection name; - by cabinet; - by unit; - by equipment; - by symptoms. For each fault, it is desirable to provide: - description; - possible causes; - sequence of checks; - photographs; - diagrams; - video materials; - links to related documents. Dynamic Buttons Buttons should be generated automatically depending on the situation. For example: - Check cabinet. - View diagram. - View video. - Next stage of diagnostics. - Go back. Administrative Panel The chief administrator should be able to: - add equipment; - create new errors; - add documents; - upload photographs; - upload videos; - edit the knowledge base; - manage users; - assign administrators of individual departments. QR System Each cabinet, unit, or equipment can have its own QR code. After scanning, the user immediately enters the corresponding section of the Telegram bot. Repair Log A log of completed work needs to be implemented. Functions: - who performed the repair; - date and time; - equipment; - description of completed work; - materials used; - comments; - repair history. Analytics It is desirable to implement: - most common faults; - repair statistics; - time to resolve faults; - reports on equipment; - reports on employees. Scalability The architecture should allow for adding new types of equipment, new enterprises, new departments, and new knowledge bases without rewriting the project. Technologies Desirable: - Python; - Telegram Bot API; - PostgreSQL or SQLite (SQLite is allowed in the first stage); - integration with AI via API; - modular architecture; - possibility of further connecting a web panel. What is expected from the contractor - Development of a fully functional project. - Clean and understandable code. - Documented project structure. - Possibility of further development without complete redesign. - Assistance with initial deployment and setup of the project. The project is long-term. After successful completion of the first stage, further improvements and development of the system are possible.

I'm looking for an experienced Python developer who can conduct a full audit of the existing project, fix errors, and bring it to fully stable operation. If necessary, a complete redesign of the project architecture or writing a new implementation while preserving all necessary functionality is allowed. What I will provide The source code of the current bot. A video demonstrating how the bot should work. A complete technical specification with the logic of operation. Main task The goal is to restore the stable operation of the bot and ensure the execution of the full scenario without failures. If the current architecture cannot be effectively fixed, a complete redesign of the project is allowed. The main objective is not to preserve the existing code but to obtain a fully functional, stable, and maintainable product. What needs to be done 1. Conduct a project audit Before starting work, it is necessary to: study the existing code; identify the reasons why the bot stopped working; assess what can be fixed and what is more reasonable to rewrite. 2. Restore all functionality After the work is completed, the bot should correctly execute the entire scenario: registration of a new account; confirmation of login via code from email; authorization; execution of the scenario according to the technical specification; completion of work; transition to the next account. All stages must work automatically without manual intervention. 3. Fix existing errors It is necessary to eliminate any errors related to: authorization; receiving the confirmation code; unstable operation; freezing; unexpected program termination; errors after website updates; incorrect exception handling. 4. Make the project resilient The bot must: correctly handle errors; not enter infinite loops; automatically terminate unsuccessful scenarios; correctly continue operation after non-critical errors; maintain clear logs. 5. Control panel It is necessary to preserve or redesign the control panel. It should allow: to start and stop operation; to change necessary settings; to view the current status; to view the log of operations and errors. The interface should be clear and stable. 6. Code Code requirements: clear project structure; separation of logic into modules; possibility of further support. 7. Compatibility The project must run on a modern version of Python. The contractor must provide a complete list of dependencies and instructions for running. 8. Result verification Before handing over the project, the contractor must demonstrate a fully working scenario on video: project launch; completion of the full cycle; absence of errors; correct operation of all functions. What to provide after completion source code; all modified files; instructions for running; list of dependencies; video demonstration of operation; brief description of the changes made. Important The work is considered completed only after all functionality described in the technical specification and demonstration video works stably without critical errors. If during the audit it turns out that the current project cannot be effectively fixed, a complete redesign is allowed while preserving all necessary functionality. When responding, please indicate immediately: experience with Python; experience in browser automation (Playwright, Selenium, or similar tools); experience with REST API; cost of work; estimated completion time.