openssl genrsa -out private.key 2048 && openssl rsa -in private.key -outform PEM -pubout -out public.pem


php bin/console make:entity --regenerate

php bin/console make:migration

php bin/console doctrine:migrations:migrate

IP serveur: 83.166.154.165
docker image name: mattrayner/lamp:latest-1604-php7

crontab -e
sudo service crond restart

ref=@Model(type=App\Entity\Entite::class)


----
sudo docker build -t=mattrayner/lamp:latest -f ./1604/Dockerfile-php7 .
sudo docker run -p "80:80" mattrayner/lamp:latest-1604
sudo docker run -p "8075:80" digiadmin/lamp:latest-1604
 docker run -i -t 8075:80 mattrayner/lamp:latest
 docker run -i -t mattrayner/lamp /bin/bash
docker run -d --restart=always -p 8080:80 mattrayner/lamp:latest
docker run -d mattrayner/lamp:latest bin/bash

CONTAINER_ID: ce5d5f0c7547
IMAGE_NAME:  mattrayner/lamp:latest-1604-php7
Run docker command on container
docker exec CONTAINER_ID  mysql -uroot -e "create database DATABASE_NAME"
mysql pwd: 25xpnUFyUTjb
mysql -uadmin -pncbVuhAa38SY -hlocalhost -P3306

 mysql -uadmin -pLxvMsG1LJTQt -h<host> -P<port>
guH8fZdH7eFx
------
digiadmin mysql pwd: Zpe4ndEdTp06 8075
digi auth mysql pwd: MKIsjyuIu6PI 8080
digi auth mysql pwd: vwkGcjgkh2UL 8070

Phpmyadmin: admin/25xpnUFyUTjb
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('digicash2019');

git config --global user.name "Sellé"
git config --global user.email "selle403@gmail.com"

git clone git@gitlab.com:selle/digicash_admin_service.git
cd digicash_admin_service
touch README.md
git add README.md
git commit -m "add README"
git push -u origin master
---------------------
cd existing_folder
git init
git remote add origin https://gitlab.com/selle/digicash_admin_service.git
git remote add origin https://gitlab.com/selle/digicash_auth_service.git
git remote add origin https://gitlab.com/selle/digi_angular_docker.git
git add .
git commit -m "Initial commit"
git push -u origin master
----------
cd existing_repo
git remote rename origin old-origin
git remote add origin git@gitlab.com:selle/digicash_admin_service.git
git push -u origin --all
git push -u origin --tags

------
git remote rm origin

sudo docker build -t=digi_admin/lamp:latest -f ./1604/Dockerfile-php7 .

cd admin_service_front
pull source
npm install 
sudo docker build -t admin_service_front .
sudo docker run -p 8090:80 admin_service_front

Ouvrir ton navigateur pour tester http://83.166.154.165:8090

Meilleur bureau
nb trx, volume, volume commission

Agent
meilleur Agent
meileur service
meileur operateur

service/bbureau
service/region
operateur/bureau
operateur/region 


---------
SELECT count(DISTINCT ID), SUM(montant) FROM transaction WHERE operation LIKE 'debit' AND (appro = 1) AND point_de_vente_id = 1 AND (annulation IS NULL or annulation = 0)


SELECT count(DISTINCT t.ID), SUM(t.montant) FROM transaction t, caisse c WHERE t.caisse_id = c.id AND operation LIKE 'credit' AND (t.appro = 1) AND c.point_de_vente_id = 1 AND (t.annulation IS NULL or t.annulation = 0)