package com.itsv.gankao.database;

import java.lang.String;
import java.sql.*;
import java.util.*;

import com.itsv.gankao.common.*;
import com.itsv.gankao.tree.*;
import com.jenkov.tags.tree.itf.*;
import com.jenkov.tags.tree.impl.*;
import javax.servlet.http.*;
import java.io.*;
import org.jfree.data.*;
import org.jfree.chart.*;
//import org.jfree.data.general.*;
import org.jfree.chart.plot.*;
import org.jfree.chart.urls.*;
import org.jfree.chart.labels.*;
import org.jfree.data.TimeSeriesTableModel;
import org.jfree.data.time.*;
import org.jfree.chart.axis.*;
import org.jfree.chart.renderer.*;


public class TestSystemJspBean extends JspBean{

//  private static Connection conn = null;

  public static void creatITree(TreeNodeVsl rootNodeVsl, ITree tree) throws SQLException, Exception{

    //datebase initial
    TestSystemJspBean jspBean = new TestSystemJspBean();
    jspBean.initDataBase();
    Connection conn = jspBean.conn_;

    ITreeNode nTreeHead = new TreeNode("treeHeadId"   , "測(cè)評(píng)期次管理"   , "treehead");
    rootNodeVsl.setSelfNode(nTreeHead);

    GuideLineRec[] guideLineRec = GuideLineRec.loadDisplayData(conn);
     for (int i=0; i<guideLineRec.length; i++){//firstChild
          String firstID = guideLineRec[i].getID();
          String firstName = guideLineRec[i].getName();
//          ITreeNode firstChildNode  = new TreeNode("ID" + firstID, firstName , "Type" + firstID);
          ITreeNode firstChildNode  = new TreeNode(firstID, firstName , "Type" + firstID);
          TreeNodeVsl firstChildVsl = new TreeNodeVsl(firstID);
          firstChildVsl.setSelfNode(firstChildNode);

          PerioDicalRec[] perioDicalRec = PerioDicalRec.loadByGuideLineId(conn, firstID);
          for (int j=0; j<perioDicalRec.length; j++){//secondChild
               String secondID = perioDicalRec[j].getID();
               String secondName = perioDicalRec[j].getName();
//               ITreeNode secondChildeNode  = new TreeNode("ID" + secondID, secondName, "Type" + secondID);
               ITreeNode secondChildeNode  = new TreeNode(secondID, secondName, "Type" + secondID);
               TreeNodeVsl secondChildVsl = new TreeNodeVsl(secondID);
               secondChildVsl.setSelfNode(secondChildeNode);

               DepartmentRec[] departmentRec = DepartmentRec.loadByPeriodId(conn, secondID);
               for (int k=0; k<departmentRec.length; k++){//thirdChild
                    String thirdID = departmentRec[k].getID();
                    String thirdName = departmentRec[k].getName();
//                    ITreeNode thirdChildeNode  = new TreeNode("ID" + thirdID, thirdName, "Type" + thirdID);
                    ITreeNode thirdChildeNode  = new TreeNode(thirdID, thirdName, "Type" + thirdID);
                    //ITreeNode thirdChildeNode  = new TreeNode("", thirdName, "Type" + thirdID);
                    TreeNodeVsl thirdChildVsl = new TreeNodeVsl(thirdID);
                    thirdChildVsl.setSelfNode(thirdChildeNode);

                    PersonRec[] personRec = PersonRec.loadByDepartId(conn, secondID, thirdID);
                    for(int p=0; p<personRec.length; p++) {//fourthChild
                      String fourthID = personRec[p].getID();
                      String fourthName = personRec[p].getName();
//                      ITreeNode fourthChildeNode  = new TreeNode("ID" + fourthID + "&periodID=" + secondID, fourthName, "Type" + fourthID);
                      ITreeNode fourthChildeNode  = new TreeNode(fourthID + "&flg=1&periodID=" + secondID, fourthName, "Type" + fourthID);

                      TreeNodeVsl fourthChildVsl = new TreeNodeVsl(fourthID);
                      fourthChildVsl.setSelfNode(fourthChildeNode);

                      thirdChildVsl.addChildVsl(fourthChildVsl);
                    }

                    secondChildVsl.addChildVsl(thirdChildVsl);
               }

               firstChildVsl.addChildVsl(secondChildVsl);
          }

          rootNodeVsl.addChildVsl(firstChildVsl);
     }
     jspBean.displayTree(rootNodeVsl, tree);
     jspBean.closeConn();
  }

  public void  displayTree(TreeNodeVsl rootNodeVsl, ITree tree) throws Exception{

      TreeNodeVsl[] firtstChildVsl = rootNodeVsl.getChildVsl();
      ITreeNode rootTreeNode = rootNodeVsl.getSelfNode();

      for (int i=0; i<firtstChildVsl.length; i++){
           ITreeNode firstChildNode = firtstChildVsl[i].getSelfNode();

           TreeNodeVsl[] secondChildVsl = firtstChildVsl[i].getChildVsl();
           for (int j=0; j<secondChildVsl.length; j++){
                ITreeNode secondChildNode = secondChildVsl[j].getSelfNode();

                TreeNodeVsl[] thirdChildVsl = secondChildVsl[j].getChildVsl();
                for (int k=0; k<thirdChildVsl.length; k++){
                     ITreeNode thirdChildNode = thirdChildVsl[k].getSelfNode();

                     TreeNodeVsl[] fourthChildVsl = thirdChildVsl[k].getChildVsl();
                     for (int p=0; p<fourthChildVsl.length; p++){
                          ITreeNode fourthChildNode = fourthChildVsl[p].getSelfNode();

                          thirdChildNode.addChild(fourthChildNode);
                     }

                     secondChildNode.addChild(thirdChildNode);
                }

                firstChildNode.addChild(secondChildNode);
           }

           rootTreeNode.addChild(firstChildNode);
      }

      tree.setRoot(rootTreeNode);
      tree.expand(rootTreeNode.getId());
  }



      public static void creatPictures(HttpServletRequest request) throws SQLException, Exception{

        TestSystemJspBean jspBean = new TestSystemJspBean();
        jspBean.initDataBase();
        Connection conn = jspBean.conn_;

        ChartRenderingInfo info = new ChartRenderingInfo();
        WebSiteSrc WebSiteSrc = new WebSiteSrc();

        //String imagePath = "D:\\TestSystemProject\\TestSystem\\defaultroot\\pictures\\";
        String imagePath = WebSiteSrc.sImagePath;


        String personID = request.getParameter("selected");
        String periodID = request.getParameter("periodID");
        String flg = request.getParameter("flg");
        //Data of Pie picture
        ScoreTotleRec[] scoreTotleRec = ScoreTotleRec.loadByPersonId(conn, periodID, personID);

        if(flg != null){
          if (flg.equals("1")) {
            ScoreWholeRec[] scoreWholeRec = ScoreWholeRec.loadByPersonId(conn, periodID, personID);
            creatPiePicture(request, scoreTotleRec, scoreWholeRec, imagePath);

          }
          else if (flg.equals("2")) {
            ScoreItemsRec[] scoreItemsRec = ScoreItemsRec.loadByPersonId(conn, periodID, personID);
            creatColPicture(request, scoreTotleRec, scoreItemsRec, imagePath);

          }
          else if (flg.equals("3")) {
            ScoreItemsRec[] scoreItemsRec = ScoreItemsRec.loadByPersonId(conn, periodID, personID);
            creatLinePicture(request, scoreTotleRec, scoreItemsRec, imagePath);

          }
        }
  }


  public static void creatPiePicture(HttpServletRequest request,
                                     ScoreTotleRec[] scoreTotleRec,
                                     ScoreWholeRec[] scoreWholeRec,
                                     String imagePath)
      throws Exception{

        HttpSession session = request.getSession(true);
        FileOutputStream fos_jpg = null;
        //FileOutputStream fos_cri = null;
        ChartRenderingInfo info = new ChartRenderingInfo();

        String sName = null;
        String sScore = null;

        for (int i=0; i<scoreTotleRec.length; i++){

             sName = scoreTotleRec[i].getTName();
             sScore = scoreTotleRec[i].getScore();
        }

        DefaultPieDataset data = getDataSet(scoreWholeRec);
        JFreeChart chart = ChartFactory.createPie3DChart(sName + " 總分：" + sScore, // 圖表標(biāo)題
                                                         data, // 數(shù)據(jù)集
                                                         true, // 是否顯示圖例(對(duì)于簡(jiǎn)單的柱狀圖必須是false)
                                                         false, // 是否生成工具
                                                         false // 是否生成URL鏈接
                                                         );
        try{

                String personID = request.getParameter("selected");
                String filename= "pie_fruit" + personID + ".jpg";
                fos_jpg = new FileOutputStream(imagePath + filename);
                session.setAttribute("filename", filename);
                ChartUtilities.writeChartAsJPEG(
                        fos_jpg,
                        100,
                        chart,
                        600,
                        500,
                        info);

        }finally{