#!/usr/local/bin/ruby
require 'rubygems'
require 'dbi'
require 'cgi'
require 'GINA'

begin

	cgi=CGI.new("html3")

	web_conf =  GINA::load_config("l5_tracker/web_front.yml")
	conf = GINA::load_config("l5_tracker/database.yml")
	dbh = DBI.connect(conf['production']['dbi_connector']  , conf['production']['username'], conf['production']['password'])

	name = "vis_" + (Time.now.to_i % 100000).to_s


	out = []
	start_tm = Time.gm(Time.now().year, Time.now().month, Time.now().day, 0,0,0,0)

	sql = "select distinct " +
                " EXTRACT(EPOCH FROM date_trunc('day', time )) as time " +
           " from " +
                " l5_frames " +
           " where " +
                " time >= '#{Time.now.getgm()}' and time <=  '#{Time.now.getgm()+16*24*60*60}'" 

	sth = dbh.prepare(sql)
	sth.execute

	out << "<script type=\"text/javascript\" src=\"prototype-1.4.0.js\" > </script>"
	out << "<script type=\"text/javascript\" src=\"jays_javamadness.js\" > </script> "

	out << "<DIV ID=\"navbox\">"

	out << "<UL>"

	while row=sth.fetch_hash do
                out << "<LI>"
                out <<  sprintf("<A HREF=\"javascript:lll('%s?%s=%s', '#{name}')\" > %s </A>", 
                        web_conf['web']['viewer_url'],
                        web_conf['web']['date_arg'],
                        row['time'].to_s,
                        Time.at( row['time'] + Time.now().gmt_offset).getgm.strftime("%b %d,%Y" )  )
                out << "</LI>"
	end

        out << "</UL>"
        out << "</DIV>"
        out << "<DIV id=\"WORKING_FRAME\" >"
	out << " <CENTER> "
	out << "<img src=\"\" id=\"#{name}\" style=\"visibility: hidden;\" > "
        out << " </CENTER> "

        out << "<img src=\"\" id=\"hid_image\" style=\"visibility: hidden;\" onLoad=\"lll_on_load('#{name}');\" > "
        out << "</DIV>"

	cgi.out {
              cgi.head { cgi.title{ web_conf['web']['title'] } + 
			"<link href=\"/css/navbox.css\" type=\"text/css\" rel=\"stylesheet\" media=\"screen\" />" } +
                        cgi.body {
				out.join("\n")
                       }
                 }

	exit(1)

catch   StandardError => e
        cgi= CGI.new("html3");
                cgi.out {
                        cgi.head { cgi.title{"Sadness.. Something not good has happened.."} }  +
                                cgi.html {
                                        "Something bad has happened.. Perhaps it is this:<pre> #{e.to_s}</pre> " +
                                        " or <pre> #{e.backtrace}</pre>"
                                        }
                        }
        exit(-1);

end