borutar/shop-telegram-bot

Java shop chatbot for Telegram

shop-telegram-bot

Shop in telegram with admin panel

Technology stack

Java 8, Maven, Spring Boot, Spring MVC, Spring Data, Spring Security, Hibernate, Postgresql, Freemarker, HTML, Telegram Bots

Demo

• Admin panel: https://shop-telegram-demo-bot.herokuapp.com/admin, credentials (admin:admin)
• Telegram bot: https://t.me/shop_telegram_demo_bot (If the bot doesn't work, follow the admin panel link to start it)

Quick start guide

1. Create postgres database and change configuration in properties telegram-bot/src/main/resources/hibernate.cfg.xml and admin-panel/src/main/resources/application.properties
2. Import the database schema resources/db_schema.sql and database data resources/db_data.sql
3. Create a telegram bot and enable inline mode in settings
4. Set up the telegram bot username and token in properties telegram-bot/src/main/resources/application.properties
5. Run the telegram bot and admin panel, web UI is accessible on http://localhost:8080/admin, credentials (admin:admin)

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
• Do not use /root folder as main, instead you can use /home folder

How to deploy

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 8 apt-get install openjdk-8-jdk
• Install postgres apt-get install postgresql postgresql-contrib
• Install nginx apt-get install nginx
• Clone repository git clone https://github.com/ivan909020/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 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/db_schema.sql
• Import database data psql -d shop_telegram_bot < /your-directory/shop-telegram-bot/resources/db_data.sql
• Exit from postgres user exit

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

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