#!/bin/bash

thumbnailsconf=${1:-${0##*/}.conf}
test -r "$thumbnailsconf" || exit 1

function set_imgsize () {
    imgsize[${#imgsize[@]}]=$1
    imgsize[${#imgsize[@]}]=$2
    imgsize[${#imgsize[@]}]=$3
}

#set_imgsize 'custom' 1656 1242
set_imgsize 'xxlarge' 1224 918
set_imgsize 'xlarge' 1008 756
set_imgsize 'large' 792 594
set_imgsize 'medium' 576 432
set_imgsize 'small' 432 324
set_imgsize 'xsmall' 240 240
set_imgsize '2small' 144 144
set_imgsize 'thumb' 120 120

eval $(readconf --conf "$thumbnailsconf" -s mysql -s galeries -s path --case-sensitive --array=galerie)

for ((g=0; g<${#galerie[@]}; g++)); do
    sqlcmd="select concat('file=', path, ';rotation=', rotation * 90) from piwigo_images \
               where id in ( \
                  select image_id from piwigo_image_category \
                      where category_id in ( \
                          select id from piwigo_categories where name = '${galerie[$g]}' \
                      ) \
               )"

    for image in $(mysql -N -u $dbuser -p${dbpasswd} $dbname <<< $sqlcmd); do
        eval "$image"
        format=""
        fnNoExt="${file%.*}"
        fnExt="${file##*.}"
        fnPath="${file%/*}"
        mkdir -p $destDir/$fnPath
        cmd="nice -n20 convert $site/$file -write mpr:image +delete "
        for ((i=0; i<${#imgsize[@]}; i+=3)); do
            if ! test -e ${destDir}/${fnNoExt}-${imgsize[i]:0:2}.$fnExt; then
                format+="${imgsize[i]} "
                cmd+="mpr:image -filter Lanczos -strip -quality 95 -interlace line -sampling-factor 4:2:2 "
                if test $rotation -ne 0; then
                    cmd+="-rotate -$rotation -orient top-left "
                fi
                cmd+="-resize ${imgsize[i+1]}x${imgsize[i+2]} -write ${destDir}/${fnNoExt}-${imgsize[i]:0:2}.$fnExt +delete "
            fi
        done
        cmd=$(sed 's/\s*+delete\s*$//' <<< $cmd)
        if test -n "$format"; then
            echo "$site/$file : $format"
            eval "$(echo -e $cmd)"
            echo done
            sleep 30
        fi
    done
done