/shop-telegram-bot

Java shop chatbot for Telegram

Primary LanguageJavaGNU General Public License v3.0GPL-3.0

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
  1. 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

  1. 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
  1. 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
  1. 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

  1. 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