月度归档： 2018年4月

313 issue report

leokim / / Icolumn
1
2
3
4
5
6
7
SELECT b.voucher_value, CONCAT(b.prefix, b.voucher_no) AS voucher_no, c.channel_description, b.issue_time, b.expiry_time, d.status_description
FROM voucher_action a, voucher b, voucher_lkup_channel c, voucher_lkup_status d
WHERE action_time BETWEEN '2016-01-01 00:00:00' AND '2017-01-01 00:00:00' 
AND action_id = 6 
AND a.voucher_id = b.voucher_id 
AND b.transfer_channel = c.channel_id 
AND b.status_id = d.status_id

docker-compose php7.1_nginx_env_docker

leokim / / 技术

version: "2"

services:

  php-fpm:

      image: f286df33cd2d

      volumes:

        – /data/www/:/var/www/html/

      privileged: true

  nginx:

      image: e548f1a579cf

      volumes:

        – /data/log:/var/log/nginx

        – /data/config/nginx:/etc/nginx

        – /data/www:/usr/share/nginx/html

      ports:

        – 80:80

      privileged: true

  mysql:

      image: 9546ca122d3a

      volumes:

        – /data/www/mysql/my.cnf:/etc/mysql/my.cnf

        – /data/www/mysql/data:/var/lib/mysql

      environment:

        MYSQL_ROOT_PASSWORD: "superhero"

      ports:

        – 3306:3306

      privileged: true

  redis:

      image: 4760dc956b2d

      ports:

        – 6379:6379

      command: –requirepass "superhero"

      privileged: true

docker-composer.yml php5.6_env

leokim / / 技术
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
version: "2"
 
services:
  apache-php:
      image: 2e233ad9329b
      volumes:
        - /data/www:/var/www/html
        - /data/config/apache:/etc/apache2/sites-enabled
        - /data/log/apache:/var/log/apache2
      environment:
        ALLOW_OVERRIDE: "true"
      ports:
        - 80:80
      privileged: true
  mysql:
     # image: 9546ca122d3a
      image: 0da48351c371
      volumes:
        - /data/www/mysql/my.cnf:/etc/mysql/my.cnf
        - /data/www/mysql/mysql5.5_new/data:/usr/local/mysql/data
       # - /data/www/mysql/mysql5.5/data:/mysql/data
      environment:
        MYSQL_ROOT_PASSWORD: "superhero"
      ports:
        - 3306:3306
      privileged: true