shop-telegram-bot

Shop in telegram with admin panel

Technology stack

Java 17, Maven, Spring 3 (Boot, MVC, Data, Security), Hibernate, Postgresql, Freemarker, HTML, Telegram Bots

Notes before deploy

• Telegram bot sends images as a link, if they are uploaded from the localhost, the bot will not be able to send them
• Telegram bot does not support raw ip address for sending images, you should use domain instead

How to deploy with docker

mvn -f shop-telegram-bot/admin-panel/ package
mvn -f shop-telegram-bot/telegram-bot/ package

docker build -t shop-admin-panel shop-telegram-bot/admin-panel/
docker build -t shop-telegram-bot shop-telegram-bot/telegram-bot/

docker-compose -f shop-telegram-bot/docker-compose.yml up -d

How to deploy manually

1. Install software

• Update and upgrade sudo apt-get update && sudo apt-get upgrade
• Install git apt-get install git
• Install maven apt-get install maven
• Install jdk 17 apt-get install openjdk-17-jdk
• Install postgres apt-get install postgresql postgresql-contrib
• Install nginx apt-get install nginx
• Clone repository git clone https://github.com/ivan-zaitsev/shop-telegram-bot.git
• Package admin panel mvn -f shop-telegram-bot/admin-panel/ package
• Package telegram bot mvn -f shop-telegram-bot/telegram-bot/ package

2. Set environment variables

Add database environment variables.

• DATABASE_URL (jdbc:postgresql://localhost:5432/shop_telegram_bot)
• DATABASE_USERNAME (postgres)
• DATABASE_PASSWORD (postgres)

Or you can manually change configuration in properties telegram-bot/src/main/resources/hibernate.cfg.xml and admin-panel/src/main/resources/application.properties

3. Create telegram bot

• Create a telegram bot here and enable inline mode in settings
• Add telegram bot username and token to properties telegram-bot/src/main/resources/application.properties
• To receive notifications about new orders you need specify your chat id in properties

4. Set up database

Replace your-directory with directory where the cloned repository is located

• Login postgres user sudo -i -u postgres
• Connect postgres database psql
• Change password \password
• Create database create database shop_telegram_bot;
• Exit from postgres database \q
• Import database schema psql -d shop_telegram_bot < /your-directory/shop-telegram-bot/resources/1_db_schema.sql
• Import database data psql -d shop_telegram_bot < /your-directory/shop-telegram-bot/resources/2_db_data.sql
• Exit from postgres user exit

5. Set up admin panel

Create systemd unit

Replace your-directory with directory where the cloned repository is located

nano /etc/systemd/system/shop-admin-panel.service

[Unit]
Description=shop-admin-panel
After=syslog.target

[Service]
WorkingDirectory=/your-directory/shop-telegram-bot/
ExecStart=/usr/bin/java -jar /your-directory/shop-telegram-bot/admin-panel/target/admin-panel-1.0.0.jar
StandardOutput=journal
StandardError=journal
SyslogIdentifier=shop-admin-panel
SuccessExitStatus=143
Type=simple
Restart=always

[Install]
WantedBy=multi-user.target reboot.target default.target poweroff.target

systemctl daemon-reload

systemctl enable shop-admin-panel.service

systemctl start shop-admin-panel.service

Nginx configuration

Replace your-domain.com with your domain (domain is needed for correct sending of product photos)

nano /etc/nginx/conf.d/your-domain.com.conf

server {

    listen 80;

    server_name your-domain.com;


    index index.html;

    include conf.d/shop-admin-panel.include;

}

nano /etc/nginx/conf.d/shop-admin-panel.include

location /admin {

    proxy_pass http://127.0.0.1:8080;
    proxy_set_header Host $host;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    client_max_body_size 1024m;

}

systemctl restart nginx

Web UI is accessible on http://localhost:8080/admin, default credentials - admin:admin

6. Set up telegram bot

Create systemd unit

Replace your-directory with directory where the cloned repository is located

nano /etc/systemd/system/shop-telegram-bot.service

[Unit]
Description=shop-telegram-bot
After=syslog.target

[Service]
WorkingDirectory=/your-directory/shop-telegram-bot/
ExecStart=/usr/bin/java -jar /your-directory/shop-telegram-bot/telegram-bot/target/telegram-bot-1.0.0-jar-with-dependencies.jar
StandardOutput=journal
StandardError=journal
SyslogIdentifier=shop-telegram-bot
SuccessExitStatus=143
Type=simple
Restart=always

[Install]
WantedBy=multi-user.target reboot.target default.target poweroff.target

systemctl daemon-reload

systemctl enable shop-telegram-bot.service

systemctl start shop-telegram-bot.service

Screenshots

Chatbot

Admin panel