Guest User

Untitled

a guest
Jan 19th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. INSTANCE="nazev_instance_kohy"
  4. SIGLA="sigla_knihovny"
  5. USERNAME="vypdilia"
  6. PASSWORD="heslo"
  7.  
  8. YEAR=$(date "+%Y")
  9. QUARTAL=$(echo "(`date +%m` - 1)/3" | bc)
  10. if [ "$QUARTAL" == "0" ] ; then
  11. QUARTAL="4"
  12. YEAR=$(echo "$YEAR - 1" | bc)
  13. fi
  14.  
  15. MY_DIR="`dirname \"$0\"`"
  16. CURR_DIR=${PWD}
  17. cd "$MY_DIR"
  18.  
  19. TMPFILE=issues.txt
  20. FILENAME=$SIGLA\_$YEAR\_$QUARTAL.xml
  21.  
  22. case "$QUARTAL" in
  23. "1" )
  24. DATEFROM="$YEAR-01-01"
  25. DATETO="$YEAR-03-31" ;;
  26. "2" )
  27. DATEFROM="$YEAR-04-01"
  28. DATETO="$YEAR-06-30" ;;
  29. "3" )
  30. DATEFROM="$YEAR-07-01"
  31. DATETO="$YEAR-09-30" ;;
  32. "4" )
  33. DATEFROM="$YEAR-10-01"
  34. DATETO="$YEAR-12-31" ;;
  35. esac
  36.  
  37. header='<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>'
  38. root='<VFPData>';
  39. footer='</VFPData>';
  40.  
  41. echo "SELECT SUBSTRING_INDEX(REPLACE(b.isbn, '-', ''),' ',1) as isxn, COUNT(*) AS sum_pocet FROM statistics s JOIN items t ON s.itemnumber = t.itemnumber JOIN biblioitems b on t.biblionumber = b.biblionumber WHERE t.itype = 'KN' AND s.type IN ('renew', 'issue') AND datetime BETWEEN '$DATEFROM 00:00:00' AND '$DATETO 23:59:59' GROUP BY isxn HAVING isxn REGEXP '[0-9]+' ORDER BY sum_pocet DESC" | koha-mysql $INSTANCE | tee "$TMPFILE"
  42.  
  43. echo $header > $FILENAME
  44. echo $root >> $FILENAME
  45. while read line; do
  46. isbn=$(echo $line | sed 's/\([0-9X]*\)\s\([0-9]*\)/\1/')
  47. suma=$(echo $line | sed 's/\([0-9X]*\)\s\([0-9]*\)/\2/')
  48. echo "<issues isxn=\"$isbn\" sum_pocet=\"$suma\" />" >> $FILENAME
  49. done <$TMPFILE
  50. echo $footer >> $FILENAME
  51.  
  52. HOST=ftp.nkp.cz
  53.  
  54. cd /root/Dilia
  55.  
  56. ftp -inv $HOST <<EOF
  57.  
  58. user $USERNAME $PASSWORD
  59.  
  60. binary
  61.  
  62. passive
  63.  
  64. put ${FILENAME}
  65.  
  66. bye
  67. EOF
  68.  
  69. cd "$CURR_DIR"
Add Comment
Please, Sign In to add comment