package cc.glsn.v15.housefund;

import java.awt.GridBagConstraints;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.TreeMap;

import javax.swing.JButton;
import javax.swing.JPanel;
import javax.swing.JScrollPane;

import cc.glsn.v15.SQLConnection;


public class AllTrans extends JPanel implements Face
{

    private static final long serialVersionUID = 8528343055781775751L;

    Client Clint;
    
    public AllTrans(Client c)
    {
        super(new java.awt.GridBagLayout());
        Clint=c;
        
    }
    
    public synchronized void updateData() throws SQLException
    {
        // TODO Auto-generated method stub
        
        this.removeAll();
        JPanel S=new JPanel(new java.awt.GridBagLayout());
        JScrollPane Scr=new JScrollPane(S);
        {
            java.awt.GridBagConstraints c=new java.awt.GridBagConstraints();
            c.gridheight=1;
            c.gridwidth=1;
            c.weightx=100.0;
            c.weighty=100.0;
            c.fill=GridBagConstraints.BOTH;
            c.insets=new java.awt.Insets(1,1,1,1);
            c.anchor=GridBagConstraints.WEST;
            this.add(Scr,c);
        }
        SimpleDateFormat sdf=Globals.getDateFormat();
        DecimalFormat mf=Globals.getMoneyFormat();
        DecimalFormat pf=Globals.getPercentFormat();
        
        Globals.addItem("ID",S,0);
        Globals.addItem("Date",S,0);
        Globals.addItem("Desc",S,0);
        Globals.addItem("Catagory",S,0);
        Globals.addItem("Note",S,0);
        Globals.addItem("Status",S,0);
        Globals.addItem("Hidden",S,0);
        Globals.addItem("Total",S,0);
        
        for(String n : Globals.getAllUsers())
        {
            Globals.addItem(n,S,0);
            
        }
        JButton EditButton=new JButton("New");
        EditButton.addActionListener(new EditPress(-1));
        Globals.addComponent(EditButton,S,Globals.FlagEndRow);

        
        
        SQLConnection C=Globals.getSQL();
        
        ResultSet R=C.doSingleQuery("select * from transaction order by date desc,id desc");
        while(R.next())
        {
            
            Globals.addItem(R.getInt("id"),S,0);
            Globals.addItem(sdf.format(R.getDate("date")),S,0);
            Globals.addItem(R.getString("title"),S,0);
            Globals.addItem(R.getString("catagory"),S,0);
            Globals.addItem(R.getString("note"),S,0);
            Globals.addItem(R.getInt("status"),S,0);
            Globals.addItem(R.getInt("totalhidden"),S,0);
            double Total=R.getDouble("amount");
            int F=0; if (Total<0.0) F=Globals.FlagRed;
            Globals.addItem(mf.format(Total),S,Globals.FlagRight+F);
            
            TreeMap<String,Double> Paid=new TreeMap<String,Double>();
            for(String n : Globals.getAllUsers())
            {
                Paid.put(n,0.0);
            }
            
            
            
            ResultSet R2=C.doSingleQuery("select * from distro where transid=" + R.getInt("id"));
            while(R2.next())
            {
                String n=R2.getString("person");
                double p=R2.getDouble("value");
                Paid.put(n,p);
            }
            
            for(String n : Globals.getAllUsers())
            {
                double p=Paid.get(n);
                F=0; if (p<0.0) F=Globals.FlagRed;
                String str=mf.format(p);
                if (Total!=0.0)
                {
                    double per=p/Total;
                    str+="/";
                    str+=pf.format(per);
                }
                if (p==0.0) str="";
                Globals.addItem(str,S,F);
            }
            //Globals.addItem("Edit",S,Globals.FlagEndRow);
            
            {
                EditButton=new JButton("Edit");
                EditButton.addActionListener(new EditPress(R.getInt("id")));
                Globals.addComponent(EditButton,S,Globals.FlagEndRow);
                
                
                
            }
            
            
        }
        
        
        
    }
    
    class EditPress implements ActionListener
    {
        int TransID;
        public EditPress(int transid)
        {
            TransID=transid;
        }
        public void actionPerformed(ActionEvent evt)
        {
            
            Clint.newEdit(TransID);

        }

    }    

}