#!/usr/bin/python

from flask import Flask, request, g
from time import time

app = Flask(__name__, static_url_path='/static')
app.debug = True

@app.before_request
def before_request():
  g.t = time()

@app.after_request
def after_request(response):
  rt = "{:10.4f}".format(time() - g.t)
  print "Runtime %s" % rt
  import os
#  with open("/tmp/output.txt", "w") as text_file:
#    text_file.write("Path: %s\n" % os.getcwd())
#    text_file.write("Path: %s\n" % os.path.realpath(__file__))
#    text_file.write("Path: %s\n" % os.path.join(os.path.dirname(os.path.realpath(__file__)), 'shipping.xslt'))
  response.headers["X-Runtime"] = rt
  return response

@app.route("/spp/<int:mode>/<int:list_id>/<path:ids>")
def spp_availability(mode=0, list_id=0, ids=0):
  from os import system
  from subprocess import call, check_output
  from flask import send_from_directory, make_response, abort
 
  if mode not in [0, 1]:
    abort(400)

  shell = """mysql -u F5VksfQsYW -h 192.168.10.10 -pmWaq9FiGC6\
  --default-character-set=utf8\
  --skip-column-names\
  --raw\
  --execute="CALL spp_spare_parts(%d, '%s', %d)"\
  NESA > /tmp/spp_spare_parts.output
  """ % (list_id, ",".join(str(ids).split("/")), mode)
  system(shell)

  response = send_from_directory('/tmp', filename="spp_spare_parts.output")

  response.headers['Content-Type'] = 'application/xml' if mode==0 else 'application/json'
  return response

@app.route("/pdf/<int:top>/<int:right>/<int:bottom>/<int:left>/<int:orientation>/")
def pdf(top, right, bottom, left, orientation):
  from subprocess import call, check_output
  from shlex import split
  from flask import make_response
  from base64 import b64decode

  url = "https://192.168.200.6/support/spare_parts.jsp"
  title = "Axiomes"
  orientation = 'Landscape' if orientation==0 else 'Portrait'
 
  shell = '/usr/local/bin/./wkhtmltopdf.sh -q --title %s -T %d -L %d -R %d -B %d -O %s -s A4 --print-media-type %s -'
  shell = shell % (title, top, left, right, bottom, orientation, url)
  print shell

  pdf = check_output(split(shell))
  response = make_response(pdf)
  response.headers['Content-Type'] = 'application/pdf'
  response.headers['Content-Disposition'] = 'inline; filename=%s.pdf' % 'spare_parts'
  return response

@app.route("/pdf/addresses/<int:all>")
def addresses(all):
  from subprocess import call, check_output
  from shlex import split
  from flask import make_response
  from os import path

  if request.args.get("all"):
    all = 1 if request.args.get("all")=="true" else 0

  xslt = path.join(path.dirname(path.realpath(__file__)), 'shipping.xslt')

  shell = 'curl -o /tmp/invoices.xml http://192.168.200.6/support/invoices_xml.jsp?all=' + ('true' if all==1 else 'false')
  check_output(split(shell))

  shell = 'xsltproc -o /tmp/addresses.html %s /tmp/invoices.xml' % xslt
  check_output(split(shell))

#  shell = '/usr/local/bin/./wkhtmltopdf.sh -q --title Axiomes -L 0 -R 0 -T 0 -B 0 --print-media-type --page-width 100mm --page-height 35mm /tmp/addresses.html -'
  shell = '/usr/local/bin/./wkhtmltopdf.sh -q --title Axiomes -L 0 -R 0 -T 0 -B 0 --print-media-type --page-width 148mm --page-height 102mm /tmp/addresses.html -'
  print shell

  pdf = check_output(split(shell))
  response = make_response(pdf)
  response.headers['Content-Type'] = 'application/pdf'
  response.headers['Content-Disposition'] = 'inline; filename=%s.pdf' % 'addresses'
  return response

@app.route("/pdf/invoices/<int:all>")
def invoices(all):
  from subprocess import call, check_output
  from shlex import split
  from flask import make_response
  from os import path

  if request.args.get("all"):
    all = 1 if request.args.get("all")=="true" else 0

  xslt = path.join(path.dirname(path.realpath(__file__)), 'invoice.xslt')

  shell = 'curl -o /tmp/invoices.xml http://192.168.200.6/support/invoices_xml.jsp?all=' + ('true' if all==1 else 'false')
  check_output(split(shell))

  shell = 'xsltproc -o /tmp/invoices.html %s /tmp/invoices.xml' % xslt
  check_output(split(shell))

  shell = '/usr/local/bin/./wkhtmltopdf.sh -q --title Axiomes -L 0 -R 0 -T 0 -B 0 --print-media-type -s A4 /tmp/invoices.html -'
  print shell

  pdf = check_output(split(shell))
  response = make_response(pdf)
  response.headers['Content-Type'] = 'application/pdf'
  response.headers['Content-Disposition'] = 'inline; filename=%s.pdf' % 'invoices'
  return response

@app.route("/pdf/invoice/<int:reference>/")
@app.route("/pdf/invoice/<int:reference>/<int:hide_slip>/")
def invoice(reference, hide_slip=0):
  from subprocess import call, check_output
  from shlex import split
  from flask import make_response
  from os import path, system

  xslt = path.join(path.dirname(path.realpath(__file__)), 'invoice.xslt')

  shell = """mysql -u F5VksfQsYW -h 192.168.10.10 -pmWaq9FiGC6\
  --default-character-set=utf8\
  --skip-column-names\
  --raw\
  --execute="CALL ord_generate_xml_invoice('%s', %s)"\
  NESA > /tmp/invoice_%d.xml
  """ % (reference, 'TRUE' if hide_slip==1 else 'FALSE', reference)
  system(shell)


  shell = 'xsltproc -o /tmp/invoice_%d.html %s /tmp/invoice_%d.xml' % (reference, xslt, reference)
  check_output(split(shell))

  shell = '/usr/local/bin/./wkhtmltopdf.sh -q --title Axiomes -L 0 -R 0 -T 0 -B 0 --print-media-type -s A4 /tmp/invoice_%d.html -' % reference
  print shell

  pdf = check_output(split(shell))

  shell = 'rm /tmp/invoice_%d.html /tmp/invoice_%d.xml' % (reference, reference)
  system(shell)

  response = make_response(pdf)
  response.headers['Content-Type'] = 'application/pdf'
  response.headers['Content-Disposition'] = 'inline; filename=%s_%d.pdf' % ('Invoice', reference)
  return response


if __name__ == "__main__":
  app.run(host='0.0.0.0', port=7000, debug=True)