Laravel по-русски

$ envoy run VotesDeploy
lardeployer@NNN.NN.NN.NN's password: 
[lardeployer@NNN.NN.NN.NN]: Cloning into '20190314070955'...
[lardeployer@NNN.NN.NN.NN]: git clone git@bitbucket.org: Permission denied (publickey).
[lardeployer@NNN.NN.NN.NN]: fatal: Could not read from remote repository.
[lardeployer@NNN.NN.NN.NN]: Please make sure you have the correct access rights
...

su -l  lardeployer
git clone git@bitbucket.org:myaccount/votes.git

@setup
    $server_login_user= 'lardeployer';
       ...

@endsetup

@servers(['production' => $server_login_user.'@NNN.NN.NN.NN'])

<?php

namespace App\Providers;

use Auth;
use Validator;
use Illuminate\Support\Facades\Blade;

use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    use funcsTrait;

    public function boot()
    {

        if ($this->app->environment('local')) {

            \Event::listen( // Logs of sql statements
                [
                    TransactionBeginning::class,
                ],
                function ($event) {
                ...
                });


            \Event::listen(
                [
                    TransactionCommitted::class,
                ],
                function ($event) {
                ...
                });

                ...

        } // if ($this->app->environment('local')) {


		// Validation methods
        Validator::extend('check_vote_item_unique_by_name', function ($attribute, $value, $parameters, $validator) {
            $vote_id         = $parameters[0] ?? null;
            $vote_item_id    = $parameters[1] ?? null;
            $vote_item_count = VoteItem::getSimilarVoteItemByName($value, (int)$vote_id, (int)$vote_item_id, true);

            return $vote_item_count == 0;
        });

    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
		// Here I added Elastic log
        $this->app->bind(Elastic::class, function ($app) {
            return new Elastic(
                ClientBuilder::create()
                             ->setLogger(ClientBuilder::defaultLogger(storage_path('logs/elastic.log')))
                             ->build()
            );
        });

    }
}

- Installation request for mews/captcha 2.2.1 -> satisfiable by mews/captcha[2.2.1].
    - mews/captcha 2.2.1 requires ext-gd * -> the requested PHP extension gd is missing from your system.

# PATHS
DB_PATH_HOST=./databases
APP_PATH_HOST=./votes
APP_PTH_CONTAINER=/var/www/html/

version: '3'

services:

    webapp:
        build:
        # need context and dockerfile as we do not use default Dockerfile
            context: ./web
            dockerfile: Dockerfile.yml
        
        environment:
            - APACHE_RUN_USER=www-data
        volumes:
            - ${APP_PATH_HOST}:${APP_PTH_CONTAINER}
        ports:
            - 8080:80
        working_dir: ${APP_PTH_CONTAINER}

    db:
        image: mysql:5.6.41

        restart: always
        environment: 
            MYSQL_ROOT_PASSWORD: 1
        volumes:
            - ${DB_PATH_HOST}:/var/lib/mysql

    adminer:
        image: adminer
        restart: always
        ports:
            - 8081:8080
            
    composer:
        image: composer:1.6
        volumes:
            - ${APP_PATH_HOST}:${APP_PTH_CONTAINER}
        working_dir: ${APP_PTH_CONTAINER}
        command: composer install        

FROM php:7.2-apache

RUN apt-get update -y && apt-get install -y sendmail libpng-dev

RUN docker-php-ext-install \
    pdo_mysql \
    gd \
    && a2enmod \
    rewrite

docker-compose up -d :

...
Digest: sha256:6ad9c9a01a2c7fe4818f3042e7922aefa5aa63d0c71fbf4d1a1a7e3938d3be03
Status: Downloaded newer image for composer:1.6
Creating votes_docker_webapp_1   ... done
Creating votes_docker_adminer_1  ... done
Creating votes_docker_db_1       ... done
Creating votes_docker_composer_1 ... done
serge@serge:/mnt/_work_sdb8/wwwroot/lar/DockerApps/votes_docker$ docker images
REPOSITORY            TAG                 IMAGE ID            CREATED             SIZE
votes_docker_webapp   latest              f7bafdcd588d        31 minutes ago      416MB
mysql                 5.6.41              085b9b6ec8a9        2 days ago          256MB
php                   7.2-apache          cf1a377ba77f        3 days ago          377MB
adminer               latest              e6a50ea92943        3 days ago          81.6MB
composer              1.6                 eea351f3627d        3 days ago          155MB
mysql                 5.7.22              6bb891430fb6        2 months ago        372MB
php                   fpm-alpine          601d5b3a95d4        3 months ago        80.6MB
php                   apache              d9faf33e6e40        3 months ago        377MB
mysql                 latest              8d99edb9fd40        3 months ago        445MB
php                   7-fpm               854ffd8dc9d8        4 months ago        367MB
php                   7.2                 e86d9bb526ef        4 months ago        367MB
ukfx/php              apache-stretch      5958cb7c2316        4 months ago        648MB
nginx                 alpine              bc7fdec94612        4 months ago        18MB
hello-world           latest              e38bc07ac18e        6 months ago        1.85kB
composer/composer     latest              5afb0951f2a4        2 years ago         636MB


$ docker logs --tail=20  votes_docker_composer_1
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - Installation request for mews/captcha 2.2.1 -> satisfiable by mews/captcha[2.2.1].
    - mews/captcha 2.2.1 requires ext-gd * -> the requested PHP extension gd is missing from your system.

  To enable extensions, verify that they are enabled in your .ini files:
    - 
    - /usr/local/etc/php/conf.d/date_timezone.ini
    - /usr/local/etc/php/conf.d/docker-php-ext-sodium.ini
    - /usr/local/etc/php/conf.d/docker-php-ext-zip.ini
    - /usr/local/etc/php/conf.d/memory-limit.ini
  You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.
serge@serge:/mnt/_work_sdb8/wwwroot/lar/DockerApps/votes_docker$ docker logs --tail=20  votes_docker_adminer_1
PHP 7.2.11 Development Server started at Fri Oct 19 05:30:53 2018
[Fri Oct 19 05:40:21 2018] ::ffff:196.52.43.103:50904 [200]: /
serge@serge:/mnt/_work_sdb8/wwwroot/lar/DockerApps/votes_docker$ docker logs --tail=20  votes_docker_webapp_1
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
[Fri Oct 19 05:30:52.245548 2018] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.25 (Debian) PHP/7.2.11 configured -- resuming normal operations
[Fri Oct 19 05:30:52.245606 2018] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
serge@serge:/mnt/_work_sdb8/wwwroot/lar/DockerApps/votes_docker$ docker logs --tail=20  votes_docker_db_1
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_CMP'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'INNODB_TRX'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'BLACKHOLE'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'ARCHIVE'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'MRG_MYISAM'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'MyISAM'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'MEMORY'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'CSV'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'sha256_password'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'mysql_old_password'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'mysql_native_password'
2018-10-19 06:03:32 1 [Note] Shutting down plugin 'binlog'
2018-10-19 06:03:32 1 [Note] mysqld: Shutdown complete

{
    "name": "laravel/laravel",
    "description": "The Laravel Framework.",
    "keywords": ["framework", "laravel"],
    "license": "MIT",
    "type": "project",
    "require": {
        "php": "^7.1.3",
        "aloha/twilio": "^4.0",
        "cviebrock/eloquent-sluggable": "^4.5",
        "davejamesmiller/laravel-breadcrumbs": "5.x",
        "doctrine/dbal": "^2.8",
        "fideloper/proxy": "^4.0",
        "intervention/image": "^2.4",
        "itsgoingd/clockwork": "^3.0",
        "jrean/laravel-user-verification": "^7.0",
        "laravel/framework": "5.7.*",
        "laravel/tinker": "^1.0",
        "laravelcollective/html": "^5.4.0",
        "mews/captcha": "^2.2",
        "proengsoft/laravel-jsvalidation": ">2.2.0",
        "rap2hpoutre/laravel-log-viewer": "^0.19.1",
        "snowfire/beautymail": "dev-master",
        "spatie/laravel-tags": "^2.1",
        "themsaid/laravel-mail-preview": "^2.0",
        "wboyz/laravel-enum": "^0.2.1",
        "yajra/laravel-datatables-oracle": "^8.7"
    },
    "require-dev": {
        "barryvdh/laravel-debugbar": "^3.1",
        "beyondcode/laravel-dump-server": "^1.2",
        "filp/whoops": "^2.0",
        "fzaninotto/faker": "^1.4",
        "mockery/mockery": "^1.0",
        "nunomaduro/collision": "^2.0",
        "phpunit/phpunit": "^7.0"
    },
    "autoload": {
        "classmap": [
            "database/seeds",
            "database/factories"
        ],
        "psr-4": {
            "App\\": "app/"
        }
    },
    "autoload-dev": {
        "psr-4": {
            "Tests\\": "tests/"
        }
    },
    "extra": {
        "laravel": {
            "dont-discover": [
            ]
        }
    },
    "scripts": {
        "post-root-package-install": [
            "@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
        ],
        "post-create-project-cmd": [
            "@php artisan key:generate"
        ],
        "post-autoload-dump": [
            "Illuminate\\Foundation\\ComposerScripts::postAutoloadDump",
            "@php artisan package:discover"
        ],


        "post-update-cmd": [
            "php artisan vendor:publish --provider=\"Proengsoft\\JsValidation\\JsValidationServiceProvider\" --tag=public --force"
        ]

    },
    "config": {
        "preferred-install": "dist",
        "sort-packages": true,
        "optimize-autoloader": true
    },
    "minimum-stability": "dev",
    "prefer-stable": true
}

Schema::create('users', function (Blueprint $table) {
    $table->increments('id');
    $table->string('username',100)->unique();
    $table->string('email', 100)->unique();
    $table->string('password');

CREATE TABLE "users" ("id" integer not null primary key autoincrement, "username" varchar not null, "email" varchar not null, "password" varchar not null, 
...

$ docker --version
Docker version 17.12.1-ce, build 7390fc6 

$ sudo docker-compose up -d
[sudo] password for serge: 
Starting ukfxpages ... error

ERROR: for ukfxpages  Cannot start service landing_pages_er: driver failed programming external connectivity on endpoint ukfxpages (3317cadd42cb0d46291280e9b848c1f9dc3dd22b0dce5bbb458e68b0c8f61cb7): Error starting userland proxy: listen tcp 0.0.0.0:80: bind: address already in use

ERROR: for landing_pages_er  Cannot start service landing_pages_er: driver failed programming external connectivity on endpoint ukfxpages (3317cadd42cb0d46291280e9b848c1f9dc3dd22b0dce5bbb458e68b0c8f61cb7): Error starting userland proxy: listen tcp 0.0.0.0:80: bind: address already in use
ERROR: Encountered errors while bringing up the project.

    public function get_article_size_settings_dt_listing($article_id, $brooklyn_ean= ‘’, $supplier_ean= ‘’) {
        $sizeContent= Datatables::of(ArticleSizeSetting::getByArticleId($article_id)->getByBrooklynEanSupplierEan($brooklyn_ean, $supplier_ean)->get())->make(true);
        return $sizeContent;
    }

    public function scopeGetByArticleIdSizeId($query, $article_id, $size_id)
    {
        return $query->where('article_id', $article_id)->where('size_id', $size_id);
    }

    public function scopeGetByBrooklynEanSupplierEan($query, $brooklyn_ean, $supplier_ean)
    {
        return $query->where('brooklyn_ean', $brooklyn_ean)->where('supplier_ean', $supplier_ean);
    }

   SELECT * 
    FROM `article_size_settings` 
    WHERE `article_id` = '2'     AND `brooklyn_ean` is null     AND `supplier_ean` is null 
Time 1.01 : 
   SELECT * 
    FROM `users` 
    WHERE `users`.`id` = '1' limit 1