Sales-Admitad-App

Marketing project for distributing coupons, promo codes, products from more than 200 different stores. Django application built into telegram Mini App, integrated with automatic parsing of large amounts of data from the site into a Postgres database. Divided into two bots with two Mini Apps (one bot for coupons and promo codes, the second for products), as well as a bot with automatic posting management in the telegram channel. Achievements: - Creating a Django application, using HTML, CSS, JavaScript - Optimizing complex queries to the Postgres database, using indexes, implementing full-text search - Connecting Telegram Mini-App - Connecting Yandex Metrica to track traffic on the site, maintaining statistics in Google Sheets - Creating a script for automatic parsing of data via API at a certain time interval - Implementing logic for automatic publication of coupons, promotional codes and products in a telegram channel - Creating a Telegram bot to manage automatic publication in a telegram channel (the ability to change the sending time, interval, enable / disable notifications, the ability to select and publish a specific product or promotional code, delete a store with all products and promotional codes from the database, etc.) - Creating a Telegram bot with a built-in Telegram Mini-App with a catalog of coupons and promotional codes for stores - Creating a Telegram bot with a built-in Telegram Mini-App with a catalog of store products - Uploading to the server and supporting a Django application using Nginx, Gunicorn, as well as telegram bots and scripts

Bot-admin

Bot-admin for Telegram chats on Aiogram Achievements: - Implementation of functions for deleting system chat messages - Implementation of functions for deleting messages with obscene words, advertising, links, as well as repeating identical messages from users - Building a system for sending warning messages by a bot - Creating a system for turning on/off a chat depending on the time of day - Implementation of functions for limiting the number of users added to the chat within an hour - Creation of an admin panel with the ability to manage the bot, edit messages sent by the bot, as well as adding a list of users who will be allowed to send advertising and the ability to manage many other settings

Easyocr-App

Console application for reading text from the screen using computer vision with the easyocr library Achievements: - Implementation of logic in which the application takes a screenshot of a certain area of ​​the screen at a time interval using the pyautogui library - Implementation of logic for further image processing, enlargement, quality improvement using the PIL library - Using the Easyocr computer vision library to identify text or numbers in an image - Maintaining statistics of the results obtained in excel using the openpyxl library - Adding the ability to view statistics to the application - Building the application into an executable file using the pyinstaller library - Adding the ability to view statistics via a telegram bot

Cafe-App

Django project for managing orders and dishes in a restaurant. It implements a RESTful API, as well as an interface through templates and views for managing orders, dishes and revenue data. Testing is also implemented. Detailed description at the link