w
cd sites
ls
cd bot.sgt.com.ua/
ls
composer require openspout/openspout:^4.0 --no-interaction 2>&1
which composer
exit
php -v
ls
cd bot.sgt.com.ua/
composer require openspout/openspout:^4.0 --no-interaction 2>&1
/usr/bin/php81/bin/php /opt/composer.phar require openspout/openspout:^4.0
exit
ls
cd bot.sgt.com.ua/
composer require openspout/openspout:^4.0 --no-interaction 2>&1
exit
echo $PATH
cd bot.sgt.com.ua/
composer -v
exit
cd /usr/local
ls
cd ..
ls
cd bin
ls
cd ..
ls
php composer-setup.php --filename=composer.phar
cd opt
cd /home
ls
cd ..
ls
cd ~
ls
cd ..
ls
ls -la
cd /usr/bin
cd ..
echo $PATH
cd /home/lzgqnjwu
ls
cd sites
ls
cd bot.sgt.com.ua/
ls
php composer.phar require openspout/openspout:^4.0 --no-interaction 2>&1
nano composer.json
php composer.phar require openspout/openspout:^4.0 --no-interaction 2>&1
cat composer.json
nano composer.json
php composer.phar remove box/spout --no-interaction 2>/dev/null || true
php composer.phar require openspout/openspout:^4.0 "maennchen/zipstream-php:^2.4" "phpoffice/phpspreadsheet:^1.29" -W --no-interaction
cat composer.json
ls -la packages/trntv-sitemaped/composer.json
php composer.phar update trntv/sitemaped -W --no-interaction
php composer.phar update trntv/sitemaped -W --no-interaction --ignore-platform-reqs
nano composer.json
php composer.phar update trntv/sitemaped -W --no-interaction --ignore-platform-reqs
php composer.phar require openspout/openspout:^4.0 -W --no-interaction
php composer.phar require openspout/openspout:^4.0 "maennchen/zipstream-php:^2.4" -W --no-interaction
nano frontend/modules/user/controllers/BotController.php 
exit
crontab -l
cd
ls -la /usr/local/bin/php
php -v
which php
crontab -e
crontab -l
/usr/bin/php /home/lzgqnjwu/sites/bot.sgt.com.ua/console/yii worker/checkersended
/usr/bin/php -m
/usr/bin/php -v
/usr/bin/php81/bin/php -v
crontab -e
crontab -l
/usr/bin/php81/bin/php /home/lzgqnjwu/sites/bot.sgt.com.ua/console/yii worker/checkersended
cd bot.sgt.com.ua/
cd common/config
mkdir google
ls -la
cd google
nano service-account.json
cd ..
cd google
ls -la
cd ..
cd google-sheet/
ls -la
nano frontend/modules/user/controllers/BotController.php 
cd ..
nano frontend/modules/user/controllers/BotController.php 
nano frontend/services/TelegramService.php 
nano frontend/helpers/GoogleSheetHelper.php 
car frontend/runtime/logs/app.log
cat frontend/runtime/logs/app.log
nano frontend/helpers/GoogleSheetHelper.php 
nano frontend/services/TelegramService.php 
cat frontend/runtime/logs/app.log
> frontend/runtime/logs/app.log
cat frontend/runtime/logs/app.log
clear
cat frontend/runtime/logs/app.log
cd frontend/runtime
ls
cd logs
ls
cd ..
cd web
ls
cat tg_log.txt
> tg_log.txt
ls
cat tg_log.txt
cd ..
nano helpers/GoogleSheetHelper.php 
curl -sS -m 10 -o /dev/null -w "%{http_code}\n" "https://sheets.googleapis.com/"
cd web
cat tg_log.txt
cd ..
cd common/config/google
cat service-account.json 
pip install google-auth google-auth-httplib2 google-api-python-client
eixt
exit
cd bot.sgt.com.ua/
root@server3230:/var# sudo -u lzgqnjwu test -r common/config/google/service-account.json && echo OK || echo FALSE
sudo -u lzgqnjwu test -r common/config/google/service-account.json && echo OK
exit
cd bot.sgt.com.ua/
php composer.phar update aki/yii2-bot-telegram --no-interaction 2>&1
git status
git remote -v
git branch -M prod
git add .
git push origin prod --force
git push server prod --force
exit
cd bot.sgt.com.ua/
cd ~/.ssh
ls
cd /home/lzgqnjwu/sites/bot.
cd /home/lzgqnjwu/sites/bot.sgt.com.ua/
ssh-keygen -t ed25519 -C "server3230@bot.sgt.com.ua"
git remote set-url server https://nekithh@bitbucket.org/devin-it/smart-gt.git
git push server prod --force
git remote set-url server https://nekithh7@bitbucket.org/devin-it/smart-gt.git
git push server prod --force
cd bot.sgt.com.ua/
nano common/migrations/db/m250331_100000_broadcast_queue_tables.php
php yii migrate
php console/yii migrate
mysql -u root
cat .env
mysql -u lzgqnjwu_bot -p -d lzgqnjwu_bot
mysql -u lzgqnjwu_bot -p
php console/yii migrate
nano frontend/helpers/GoogleSheetHelper.php 
nano frontend/services/TelegramService.php 
nano frontend/helpers/GoogleSheetHelper.php 
git push server prod --force
nano frontend/services/TelegramService.php 
nano common/helpers/ChatDisplayHelper.php
nano frontend/modules/user/views/botcontactbooks/viewactions.php 
rm -rf .git
ls -la
git init
git remote add origin https://github.com/nekithh/smart-gt.git
git branch -M main
git add .
git commit -m "Initial commit"
git config --global user.email "nekithh7@gmail.com"
git config --global user.name "nekithh"
git commit -m "Initial commit"
git push origin main
git pull origin main
php composer.phar update
composer i
php composer.phar install
clear
systemctl
exit
cd bot.sgt.com.ua/
nano .env
exit
cd bot.sgt.com.ua/
php console/yii queue/listen --verbose
exit
cd bot.sgt.com.ua/
php console/yii migrate
cat .env
exit
cd bot.
git pull origin main
cd bot.sgt.com.ua/
git pull origin main
exit
cd bot.
cd bot.sgt.com.ua/
git remote set-url origin git@bitbucket.org:devin-it/smart-gt.git
git branch -M main
git branch -M prod
git checkout prod
git remote set-url origin https://github.com/nekithh/smart-gt.git
git checkout main
git pull origin main
git branch -M main
git fetch origin
git checkout origin/main
git pull origin main
git branch -M main
git switch -C main origin/main# Переключитися 
git switch -C main origin/main
git pull origin main
git remote set-url origin git@bitbucket.org:devin-it/smart-gt.git
git checkout prod
git remote set-url origin https://github.com/nekithh/smart-gt.git
git remote -v
git checkout main
git pull origin main
ls
exit
cd bot.sgt.com.ua/
git remote -v
git pull origin main
nano composer.lock
git restore .
git pull origin main
composer update
php composer.phar update
composer install
php composer.phar update cweagans/composer-patches
cat composer.json
git restore .
git push origin main
git pull origin main
php composer.phar update yii2-starter-kit/yii2-file-kit
composer require openspout/openspout:^3
php composer.phar require openspout/openspout:^3
php composer.phar require symfony/finder:^6
php composer.phar update --with-all-dependencies
grep -n "writeStream" vendor/yii2-starter-kit/yii2-file-kit/src/Storage.php
git diff vendor/yii2-starter-kit/yii2-file-kit/src/Storage.php > patches/yii2-file-kit-flysystem3-array-config.patch
composer install
php composer.phar install
cat composer.json
git checkout vendor/yii2-starter-kit/yii2-file-kit/src/Storage.php
nano vendor/yii2-starter-kit/yii2-file-kit/src/Storage.php
nano common/behaviors/FileStorageLogBehavior.php
git pull origin main
cat composer.json
php composer.phar show league/flysystem
git pull origin main
exit