#!/bin/bash

#Datos conexion sftp
USERSFTP=pictet56487
KEYFILE=/home/pictet56487/sftp/.ssh/id_rsa
HOSTSFTP=sftp.cobasam.com
LOCAL_DIR=/home/pictet56487/sftp/ta_reports

OUTPUT_DIR=/var/www/intranet/html/programas/fichas/uploads/vl_lux

FILEMASK=Historical_NAV_*$(date '+%Y%m')*.csv

cd $LOCAL_DIR

#Cadena de conexion y descarga de ficheros
sftp -i ${KEYFILE} ${USERSFTP}@${HOSTSFTP}:${REMOTE_DIR} << CMD
get -P /${FILEMASK}
bye
Cierre de la conexion remota
CMD


#Subir a bbdd
find $LOCAL_DIR/Historical_NAV_* -type f -mtime -7 -exec cp {} $OUTPUT_DIR \;

/usr/bin/php /var/www/intranet/html/programas/fichas/subidadatosnav.php