#!/usr/bin/bash
#
# MPMV
#
# Microphoto Image Mover and Renamer
#
# Takes TIF images submitted by a petrologist
# to the configured drop-box and renames them,
# and places them for consumption on the
# IODP-USIO web site.
#
# To rename files, this script depends on the
# association madehis script depends on the TS/Microphoto application
# for data entry and handling accomplished using the
# java Thin Section & Microphoto application. The camera files
# dropped are renamed according to the name
# generated and stored in the database by the
# closeup application.
#
# Run this script from the pubsweb
# crontab every 30 minutes
# Must invoke bash shell so as to pick up predefined
# environment variables, e.g.:
#
#   17,47 * * * * /usr/bin/bash --login /image2/microphoto/mpmv 1>> /image2/microphoto/mpmv.log 2>> /image2/microphoto/mpmv.log
#
# mpmv.conf
#
# Configuration file specifying:
#  - database login to use for data lookup
#  - drop location for incoming images to be processed
#  - web server location to which JPG images are published
#    the %leg% field is required and is replaced by the current leg
#
# e.g.
# :: mpmv.conf ::
# DBLOGIN=guest/guest@ship
# DROPBOX=/image2/microphoto
# WEBPATH=/image/%leg%_ER/VOLUME/CORES/microphoto
#
# The entries may appear in any order.
#
#
# Dependencies
#
# Script is dependent on these facilities being
# available on the search path:
#
#  bash, chmod, cp, grep, ls, perl, sed, sqlplus, tr
#
# No file is renamed unless it can be uniquely associated
# with a database record via a unique combination of leg and
# image number.
#
# This script is designed for the shipboard environment.
# Only one leg is operated on at a time based on the value
# of the defaults.leg field.
#
# Script is dependent on these environment variables
# currently assumed to have been set in the login profile:
#
#   MAGICK_HOME=/usr/local/ImageMagick
#   ORACLE_BASE=/usr/local/oracle/u01/app/oracle
#   ORACLE_HOME=$ORACLE_BASE/product/8.1.7
#   ORACLE_SID=SHIP
#   TNS_ADMIN=$ORACLE_HOME/network/admin
#   LD_LIBRARY_PATH=/usr/local/lib:$MAGICK_HOME/lib
#   PATH=.:/usr/bin:/usr/local/bin:$ORACLE_HOME/bin:/usr/ccs/bin:/usr/ucb:/usr/xpg4/bin:$MAGICK_HOME/bin
#

echo MICROPHOTO IMAGE MOVE AND PROCESSING
date

# Test for the presence of our configuration file

if [ ! -f ${0}.conf ]; then
  echo Expected the configuration file ${0}.conf
  echo with content similar to these lines:
  echo ' '
  echo    DBLOGIN=guest/guest@ship
  echo    DROPBOX=/image2/microphoto
  echo    WEBPATH=/image/%leg%_ER/VOLUME/CORES/microphoto
  echo ' '
  echo Configuration file must reside in the same
  echo location as this script and have the same name.
  exit 1
fi


# mpmv.conf: read the configuration file

# Define database login to use
DBLOGIN=`grep DBLOGIN ${0}.conf | sed -e 's/^.*=//'`

# Incoming TIFs go here
DROPBOX=`grep DROPBOX ${0}.conf | sed -e 's/^.*=//'`


# Get the current leg from the database
LEG=`sqlplus -s ${DBLOGIN}<<EOF
set head off
set feedback off
select leg||'' from defaults
where rownum=1;
EOF
`
# Work-around sqlplus: eliminate spaces in the variable
LEG=`echo ${LEG}|sed -e 's/\ *//g'`


# Error checking
if [ -z "${LEG}" ]; then
  echo LEG could not be determined.
  echo Is the database up?
  echo Is the defaults.leg field defined?
  echo Is ${DBLOGIN} a valid login?
  exit 1
fi


# After renaming, TIF files are moved here.
# Note dependency on retrieving leg first
WEBPATH=`grep WEBPATH ${0}.conf | sed -e 's/^.*=//' -e 's/%leg%/'"${LEG}"'/'`


# Error checking cont'd
# If any of these variables is empty
# stop processing

if [ -z "${DROPBOX}" ]; then
  echo No image DROPBOX location defined.
  echo Please specify in ${0}.conf on a line by itself.
  echo   e.g.:  DROPBOX=/image2/microphoto
  exit 1
fi

if [ ! -d ${DROPBOX} ]; then
  echo ${DROPBOX} dropbox does not exist. Please create it.
  exit 1
fi

if [ -z "${WEBPATH}" ]; then
 echo No WEBPATH, web deployment location, defined.
 echo Please specify in ${0}.conf on a line by itself.
 echo Provide for a leg substitution parameter \(%leg%\).
 echo   e.g.:  WEBPATH=/image/%leg%_IR/VOLUME/CORES/microphoto
 exit 1
fi


if [ ! -d ${WEBPATH} ]; then
  echo ${WEBPATH} WEBPATH does not exist. Please create it.
  exit 1
fi


# Provide some script feedback
echo Web drop point: ${WEBPATH}.
echo Finding files to process in ${DROPBOX}.


# Set current working directory to DROPBOX
cd ${DROPBOX}

# Obtain a list of files to work on.
# Generates error message if none found
FILELIST=`ls *.[Tt][Ii][Ff]`

# Are there any files to process?
if [ ! ${#FILELIST} == 0 ]; then

  echo Filing original images...

  # Rename each image per the microphoto_images URI
  for x in ${FILELIST}; do

    # skip completely in the case of an empty list
    if [ ${#x} == 0 ]; then continue; fi

    # file is named as micro_photo_id.TIF; strip extension
    IMAGENUMBER=`echo ${x} | sed -e 's/^.*_//' -e 's/.[Tt][Ii][Ff]//'`

    URL=`sqlplus -s ${DBLOGIN}<<EOF
       set head off
       set feedback off
       select url
       from microphoto
       where micro_image_id=${IMAGENUMBER};
       EOF
       `
      # get just the filename portion no leading path or extension
      URLFILE=`echo ${URL} | sed -e 's,^.*/,,' -e 's/\..*$//'`

      # skip file rename on empty element
      if [ ${#URLFILE} == 0 ]; then continue; fi
      # rename the file
      echo Moving ${x} to ${WEBPATH}/${URLFILE}.tif
      mv ${x} ${WEBPATH}/${URLFILE}.tif

      # make file visible to all web clients
      chmod 644 ${WEBPATH}/${URLFILE}.tif

  done
fi

# closing script; provide timestamp to quantify run time
date
echo ----- processing pass completed