#!/bin/bash

thumbnailsconf=${1:-${0##*/}.conf}

test -r "$thumbnailsconf" || exit 1

shift

declare -A imgsize width height

imgsize[xxlarge]="1656 1242"

imgsize[xlarge]=" 1224  918"

imgsize[large]="  1008  756"

imgsize[medium]=" 792   594"

imgsize[small]="  576   432"

imgsize[xsmall]=" 432   324"

imgsize[2small]=" 240   180"

if test $# -gt 0; then

    filter=$(echo $@ | sed 's/ /|/g')

    for size in ${!imgsize[@]}; do

        if ! [[ $size =~ ^(${filter})$ ]]; then

            unset imgsize[$size]

        else

            geometry=(${imgsize[$size]})

            width[$size]=${geometry[0]}

            height[$size]=${geometry[1]}

        fi

    done

fi

for size in ${!imgsize[@]}; do

    geometry=(${imgsize[$size]})

    width[$size]=${geometry[0]}

    height[$size]=${geometry[1]}

done

if which readconf > /dev/null; then

    eval $(readconf --conf "$thumbnailsconf" --section=mysql --section=path --case-sensitive)

else

    echo readconf needed !

    echo PATH = $PATH

    echo get readconf at https://seb.lautre.net/git/seb/scripts/raw/master/readconf

    exit 1

fi

if ! which convert > /dev/null; then

    echo please install ImageMagick

    exit 1

fi

sqlcmd="select path from ${dbprefix}images

           where id in (

              select distinct image_id from ${dbprefix}image_category

                  where category_id in (

                      select id from ${dbprefix}categories where dir is ${IMPORT:+not} NULL

                  )

           )"

IFS=$'\n'

for file in $(mysql -N -u $dbuser -p${dbpasswd} $dbname <<< $sqlcmd); do

    format=""

    fnNoExt="${file%.*}"

    fnExt="${file##*.}"

    fnPath="${file%/*}"

    test $fnExt = 'mp4' && continue

    cmd="sudo -u www-data convert \"$site/$file\" -write mpr:image +delete "

    count=0

    for size in ${!imgsize[@]}; do

        if ! test -e "${destDir}/${fnNoExt}-${size:0:2}.$fnExt" -a -z "$FORCE"; then

            format+="$size "

            cmd+="mpr:image -filter Lanczos -auto-orient -strip -quality 95 -interlace line -sampling-factor 4:2:2 "

            cmd+="-resize ${width[$size]}x${height[$size]} -write \"${destDir}/${fnNoExt}-${size:0:2}.$fnExt\" +delete "

            let count++

        fi

    done

    if test -n "$format"; then

        echo "$site/$file : $format"

        if test -n "$LIST"; then

            continue

        fi

        echo -n "please wait... "

        cmd=$(sed -r 's/^(.+) -write (.*) \+delete $/\1 \2/' <<< $cmd)

        eval $(echo -e nice -20 $cmd)

        for size in ${!imgsize[@]}; do

            test -s "${destDir}/${fnNoExt}-${size:0:2}.$fnExt" || echo "missing extension ${size:0:2}.$fnExt"

        done

        echo "done, sleeping..."

        sleep $(( 2 + $count ))

    fi

done