"use client";
import * as React from "react";
import Grid from "@mui/material/Grid";
import { useState, useEffect, useMemo } from "react";
import Paper from "@mui/material/Paper";
import { TFunction } from "i18next";
import { useTranslation } from "react-i18next";
import { Card, CardHeader } from "@mui/material";
import CustomSearchForm from "../CustomSearchForm/CustomSearchForm";
import CustomDatagrid from "../CustomDatagrid/CustomDatagrid";
import ReactApexChart from "react-apexcharts";
import { ApexOptions } from "apexcharts";
import { GridColDef, GridRowSelectionModel } from "@mui/x-data-grid";
import ReportProblemIcon from "@mui/icons-material/ReportProblem";
import dynamic from "next/dynamic";
import "../../app/global.css";
import { AnyARecord, AnyCnameRecord } from "dns";
import SearchBox, { Criterion } from "../SearchBox";
import ProgressByTeamSearch from "@/components/ProgressByTeamSearch";
import { Suspense } from "react";
import { useSearchParams } from 'next/navigation';
import { fetchAllTeamProjects} from "@/app/api/teamprojects/actions";
// const ReactApexChart = dynamic(() => import('react-apexcharts'), { ssr: false });

const ProgressByTeam: React.FC = () => {
  const searchParams = useSearchParams();
  const teamLeadId = searchParams.get('teamLeadId');
  const [activeTab, setActiveTab] = useState("financialSummary");
  const [SearchCriteria, setSearchCriteria] = React.useState({});
  const { t } = useTranslation("dashboard");

  const [teamCode, setTeamCode] = useState("");
  const [teamName, setTeamName] = useState("");
  const [projectArray, setProjectArray]: any[] = useState([]);
  const [percentageArray, setPercentageArray]: any[] = useState([]);
  const [colorArray, setColorArray]: any[] = useState([]);
  const [selectionModel, setSelectionModel]: any[] = React.useState([]);
  const [pieChartColor, setPieChartColor]: any[] = React.useState([]);
  const [totalSpentPercentage, setTotalSpentPercentage]: any = React.useState();
  const [projectBudgetManhour, setProjectBudgetManhour]: any =
    React.useState("-");
  const [actualManhourSpent, setActualManhourSpent]: any = React.useState("-");
  const [remainedManhour, setRemainedManhour]: any = React.useState("-");
  const [lastUpdate, setLastUpdate]: any = React.useState("-");
  const [dropdownDemo, setDropdownDemo] = useState("");
  const [dateDemo, setDateDemo] = useState(null);
  const [checkboxDemo, setCheckboxDemo] = useState(false);
  const [receiptFromDate, setReceiptFromDate] = useState(null);
  const [receiptToDate, setReceiptToDate] = useState(null);
  const [selectedRows, setSelectedRows] = useState([]);
  const [chartProjectName, setChartProjectName]:any[] = useState([]);
  const [chartManhourConsumptionPercentage, setChartManhourConsumptionPercentage]:any[] = useState([]);
  const color = ["#f57f90", "#94f7d6", "#87c5f5", "#ab95f5", "#fcd68b",
  "#f58a9b", "#8ef4d1", "#92caf9", "#a798f9", "#fad287",
  "#f595a6", "#88f1cc", "#9dcff5", "#a39bf5", "#f8de83",
  "#f5a0b1", "#82eec7", "#a8d4f1", "#9f9ef1", "#f6ea7f",
  "#f5abb4", "#7cebca", "#b3d9ed", "#9ba1ed", "#f4f67b",
  "#f5b6b7", "#76e8cd", "#bed6e9", "#97a4e9", "#f2fa77",
  "#f5c1ba", "#70e5d0", "#c9d3e5", "#93a7e5", "#f0fe73",
  "#f5ccbd", "#6ae2d3", "#d4d0e1", "#8faae1", "#eefe6f",
  "#f5d7c0", "#64dfd6", "#dfc5dd", "#8badd5", "#ecfe6b",
  "#f5e2c3", "#5edcd9", "#eabada", "#87b0c9", "#eafc67",
  "#f5edc6", "#58d9dc", "#f5afd6", "#83b3bd", "#e8fc63",
  "#f5f8c9", "#52d6df", "#ffacd2", "#7fb6b1", "#e6fc5f",
  "#f5ffcc", "#4cd3e2", "#ffa9ce", "#7bb9a5", "#e4fc5b",
  "#f2ffcf", "#46d0e5", "#ffa6ca", "#77bc99", "#e2fc57",
  "#efffd2", "#40cde8", "#ffa3c6", "#73bf8d", "#e0fc53",
  "#ecffd5", "#3acaeb", "#ffa0c2", "#6fc281", "#defb4f",
  "#e9ffd8", "#34c7ee", "#ff9dbe", "#6bc575", "#dcfb4b",
  "#e6ffdb", "#2ec4f1", "#ff9aba", "#67c869", "#dafb47",
  "#e3ffde", "#28c1f4", "#ff97b6", "#63cb5d", "#d8fb43",
  "#e0ffe1", "#22bef7", "#ff94b2", "#5fce51", "#d6fb3f",
  "#ddfee4", "#1cbbfa", "#ff91ae", "#5bd145", "#d4fb3b",
  "#dafee7", "#16b8fd", "#ff8eaa", "#57d439", "#d2fb37",
  "#d7feea", "#10b5ff", "#ff8ba6", "#53d72d", "#d0fb33",
  "#d4feed", "#0ab2ff", "#ff88a2", "#4fda21", "#cefb2f",
  "#d1fef0", "#04afff", "#ff859e", "#4bdd15", "#ccfb2b"];
  const [teamProjectResult, setTeamProjectResult]:any[] = useState([]);

  const fetchData = async () => {
    if (teamLeadId) {
      try {
        const clickResult = await fetchAllTeamProjects(
        Number(teamLeadId))
        console.log(clickResult)
        setTeamProjectResult(clickResult);
      } catch (error) {
        console.error('Error fetching team projects:', error);
      }
    }
  }

  useEffect(() => {
    const projectName = []
    const manhourConsumptionPercentage = []
   for (let i = 0; i < teamProjectResult.length; i++){
    teamProjectResult[i].color = color[i]
    projectName.push(teamProjectResult[i].projectName)
    manhourConsumptionPercentage.push(teamProjectResult[i].manhourConsumptionPercentage)
   }
   setChartProjectName(projectName)
   setChartManhourConsumptionPercentage(manhourConsumptionPercentage)
  }, [teamProjectResult]);

  useEffect(() => {
    fetchData()
   }, [teamLeadId]);

  const rows = [
    {
      id: 1,
      teamCode: "TEAM-001",
      teamName: "Team A",
      noOfProjects: "5",
    },
    {
      id: 2,
      teamCode: "TEAM-001",
      teamName: "Team B",
      noOfProjects: "5",
    },
    {
      id: 3,
      teamCode: "TEAM-001",
      teamName: "Team C",
      noOfProjects: "3",
    },
    {
      id: 4,
      teamCode: "TEAM-001",
      teamName: "Team D",
      noOfProjects: "1",
    },
  ];
  //['#f57f90', '#94f7d6', '#87c5f5', '#ab95f5', '#fcd68b']
  const rows2 = [
    {
      id: 1,
      project: "Consultancy Project 123",
      team: "XXX",
      teamLeader: "XXX",
      currentStage: "Contract Documentation",
      budgetedManhour: "200.00",
      spentManhour: "120.00",
      remainedManhour: "80.00",
      comingPaymentMilestone: "31/03/2024",
      alert: false,
      color: "#f57f90",
    },
    {
      id: 2,
      project: "Consultancy Project 456",
      team: "XXX",
      teamLeader: "XXX",
      currentStage: "Report Preparation",
      budgetedManhour: "400.00",
      spentManhour: "200.00",
      remainedManhour: "200.00",
      comingPaymentMilestone: "20/02/2024",
      alert: false,
      color: "#94f7d6",
    },
    {
      id: 3,
      project: "Construction Project A",
      team: "YYY",
      teamLeader: "YYY",
      currentStage: "Construction",
      budgetedManhour: "187.50",
      spentManhour: "200.00",
      remainedManhour: "12.50",
      comingPaymentMilestone: "13/12/2023",
      alert: true,
      color: "#87c5f5",
    },
    {
      id: 4,
      project: "Construction Project B",
      team: "XXX",
      teamLeader: "XXX",
      currentStage: "Post Construction",
      budgetedManhour: "100.00",
      spentManhour: "40.00",
      remainedManhour: "60.00",
      comingPaymentMilestone: "05/01/2024",
      alert: false,
      color: "#ab95f5",
    },
    {
      id: 5,
      project: "Construction Project C",
      team: "YYY",
      teamLeader: "YYY",
      currentStage: "Construction",
      budgetedManhour: "300.00",
      spentManhour: "150.00",
      remainedManhour: "150.00",
      comingPaymentMilestone: "31/03/2024",
      alert: false,
      color: "#fcd68b",
    },
  ];

  const columns = [
    {
      id: "clientCode",
      field: "clientCode",
      headerName: "Client Code",
      flex: 1,
    },
    {
      id: "clientName",
      field: "clientName",
      headerName: "Client Name",
      flex: 1,
    },
    {
      id: "clientSubsidiaryCode",
      field: "clientSubsidiaryCode",
      headerName: "Client Subsidiary Code",
      flex: 1,
    },
    {
      id: "noOfProjects",
      field: "noOfProjects",
      headerName: "No. of Projects",
      flex: 1,
    },
  ];

  const columns2 = [
    {
      id: "color",
      field: "color",
      headerName: "",
      renderCell: (params: any) => {
        return (
          <span
            className="dot"
            style={{
              height: "15px",
              width: "15px",
              borderRadius: "50%",
              backgroundColor: `${params.row.color}`,
              display: "inline-block",
            }}
          ></span>
        );
      },
      flex: 0.1,
    },
    {
      id: "projectName",
      field: "projectName",
      headerName: "Project",
      minWidth:300
    },
    {
      id: "team",
      field: "team",
      headerName: "Team",
      minWidth:50
    },
    {
      id: "teamLead",
      field: "teamLead",
      headerName: "Team Leader",
      minWidth: 70
    },
    {
      id: "expectedStage",
      field: "expectedStage",
      headerName: "Expected Stage",
      minWidth: 300
    },
    {
      id: "budgetedManhour",
      field: "budgetedManhour",
      headerName: "Budgeted Manhour",
      minWidth: 70
    },
    {
      id: "spentManhour",
      field: "spentManhour",
      headerName: "Spent Manhour",
      renderCell: (params: any) => {
        if (params.row.budgetedManhour - params.row.spentManhour <= 0) {
          return (
            <span className="text-red-300">{params.row.spentManhour}</span>
          );
        } else {
          return <span>{params.row.spentManhour}</span>;
        }
      },
      minWidth: 70
    },
    {
      id: "remainedManhour",
      field: "remainedManhour",
      headerName: "Remained Manhour",
      renderCell: (params: any) => {
        if (params.row.budgetedManhour - params.row.spentManhour <= 0) {
          return (
            <span className="text-red-300">({params.row.remainedManhour})</span>
          );
        } else {
          return <span>{params.row.remainedManhour}</span>;
        }
      },
      minWidth: 70
    },
    {
      id: "comingPaymentMilestone",
      field: "comingPaymentMilestone",
      headerName: "Coming Payment Milestone",
      minWidth: 100
    },
    {
      id: "alert",
      field: "alert",
      headerName: "Alert",
      renderCell: (params: any) => {
        if (params.row.alert === true) {
          return (
            <span className="text-red-300 text-center">
              <ReportProblemIcon />
            </span>
          );
        } else {
          return <span></span>;
        }
      },
      flex: 0.1,
    },
  ];

  const InputFields = [
    {
      id: "teamCode",
      label: "Team Code",
      type: "text",
      value: teamCode,
      setValue: setTeamCode,
    },
    {
      id: "teamName",
      label: "Team Name",
      type: "text",
      value: teamName,
      setValue: setTeamName,
    },
    
    // { id: 'dropdownDemo', label: "dropdownDemo", type: 'dropdown', options: [{id:"1", label:"1"}], value: dropdownDemo, setValue: setDropdownDemo },
    // { id: 'dateDemo', label:'dateDemo', type: 'date', value: dateDemo, setValue: setDateDemo },
    // { id: 'checkboxDemo', label:'checkboxDemo', type: 'checkbox', value: checkboxDemo, setValue: setCheckboxDemo },
    // { id: ['receiptFromDate','receiptToDate'], label: ["收貨日期","收貨日期"], value: [receiptFromDate ? receiptFromDate : null, receiptToDate ? receiptToDate : null],
    //     setValue: [setReceiptFromDate, setReceiptToDate],type: 'dateRange' },
  ];

  const stageDeadline = [
    "31/03/2024",
    "20/02/2024",
    "01/12/2023",
    "05/01/2024",
    "31/03/2023",
  ];

  const series2: ApexAxisChartSeries | ApexNonAxisChartSeries = [
    {
      data: [17.1, 28.6, 5.7, 48.6],
    },
  ];

  const series: ApexAxisChartSeries | ApexNonAxisChartSeries = [
    {
      name: "Project Resource Consumption Percentage",
      data: [80, 55, 40, 65, 70],
    },
  ];

  const options2: ApexOptions = {
    chart: {
      type: "donut",
    },
    colors: colorArray,
    plotOptions: {
      pie: {
        donut: {
          labels: {
            show: true,
            name: {
              show: true,
            },
            value: {
              show: true,
              fontWeight: 500,
              fontSize: "30px",
              color: "#3e98c7",
            },
            total: {
              show: true,
              showAlways: true,
              label: "Spent",
              fontFamily: "sans-serif",
              formatter: function (val) {
                return totalSpentPercentage + "%";
              },
            },
          },
        },
      },
    },
    labels: projectArray,
    legend: {
      show: false,
    },
    responsive: [
      {
        breakpoint: 480,
        options: {
          chart: {
            width: 200,
          },
          legend: {
            position: "bottom",
            show: false,
          },
        },
      },
    ],
  };

  const options: ApexOptions = {
    chart: {
      type: "bar",
      height: 350,
    },
    series: [{
      name: "Project Resource Consumption Percentage",
      data: chartManhourConsumptionPercentage,
    },],
    colors: ["#f57f90", "#94f7d6", "#87c5f5", "#ab95f5", "#fcd68b",
    "#f58a9b", "#8ef4d1", "#92caf9", "#a798f9", "#fad287",
    "#f595a6", "#88f1cc", "#9dcff5", "#a39bf5", "#f8de83",
    "#f5a0b1", "#82eec7", "#a8d4f1", "#9f9ef1", "#f6ea7f",
    "#f5abb4", "#7cebca", "#b3d9ed", "#9ba1ed", "#f4f67b",
    "#f5b6b7", "#76e8cd", "#bed6e9", "#97a4e9", "#f2fa77",
    "#f5c1ba", "#70e5d0", "#c9d3e5", "#93a7e5", "#f0fe73",
    "#f5ccbd", "#6ae2d3", "#d4d0e1", "#8faae1", "#eefe6f",
    "#f5d7c0", "#64dfd6", "#dfc5dd", "#8badd5", "#ecfe6b",
    "#f5e2c3", "#5edcd9", "#eabada", "#87b0c9", "#eafc67",
    "#f5edc6", "#58d9dc", "#f5afd6", "#83b3bd", "#e8fc63",
    "#f5f8c9", "#52d6df", "#ffacd2", "#7fb6b1", "#e6fc5f",
    "#f5ffcc", "#4cd3e2", "#ffa9ce", "#7bb9a5", "#e4fc5b",
    "#f2ffcf", "#46d0e5", "#ffa6ca", "#77bc99", "#e2fc57",
    "#efffd2", "#40cde8", "#ffa3c6", "#73bf8d", "#e0fc53",
    "#ecffd5", "#3acaeb", "#ffa0c2", "#6fc281", "#defb4f",
    "#e9ffd8", "#34c7ee", "#ff9dbe", "#6bc575", "#dcfb4b",
    "#e6ffdb", "#2ec4f1", "#ff9aba", "#67c869", "#dafb47",
    "#e3ffde", "#28c1f4", "#ff97b6", "#63cb5d", "#d8fb43",
    "#e0ffe1", "#22bef7", "#ff94b2", "#5fce51", "#d6fb3f",
    "#ddfee4", "#1cbbfa", "#ff91ae", "#5bd145", "#d4fb3b",
    "#dafee7", "#16b8fd", "#ff8eaa", "#57d439", "#d2fb37",
    "#d7feea", "#10b5ff", "#ff8ba6", "#53d72d", "#d0fb33",
    "#d4feed", "#0ab2ff", "#ff88a2", "#4fda21", "#cefb2f",
    "#d1fef0", "#04afff", "#ff859e", "#4bdd15", "#ccfb2b"],
    plotOptions: {
      bar: {
        horizontal: true,
        distributed: true,
      },
    },
    dataLabels: {
      enabled: false,
    },
    xaxis: {
      categories: chartProjectName,
    },
    yaxis: {
      title: {
        text: "Projects",
      },
      labels: {
        maxWidth: 200,
        style: {
          cssClass: "apexcharts-yaxis-label",
        },
      },
    },
    title: {
      text: "Project Resource Consumption Percentage",
      align: "center",
    },
    grid: {
      borderColor: "#f1f1f1",
    },
    annotations: {},
  };

  const handleSelectionChange = (newSelectionModel: GridRowSelectionModel) => {
    const selectedRowsData = teamProjectResult.filter((row:any) =>
      newSelectionModel.includes(row.id),
    );
    console.log(selectedRowsData);
    const projectArray = [];
    const pieChartColorArray = [];
    let totalSpent = 0;
    let totalBudgetManhour = 0;
    const percentageArray = [];
    for (let i = 0; i <= selectedRowsData.length; i++) {
      if (i === selectedRowsData.length && i > 0) {
        projectArray.push("Remained");
      } else if (selectedRowsData.length > 0) {
        projectArray.push(selectedRowsData[i].projectName);
        totalBudgetManhour += Number(selectedRowsData[i].budgetedManhour);
        totalSpent += Number(selectedRowsData[i].spentManhour);
        pieChartColorArray.push(selectedRowsData[i].color);
      }
    }
    for (let i = 0; i <= selectedRowsData.length; i++) {
      if (i === selectedRowsData.length && i > 0) {
        const remainedManhour = totalBudgetManhour - totalSpent;
        percentageArray.push(
          Number(((remainedManhour / totalBudgetManhour) * 100).toFixed(1)),
        );
      } else if (selectedRowsData.length > 0) {
        const percentage = (
          (Number(selectedRowsData[i].spentManhour) / totalBudgetManhour) *
          100
        ).toFixed(1);
        percentageArray.push(Number(percentage));
      }
    }
    setProjectBudgetManhour(totalBudgetManhour.toFixed(2));
    setActualManhourSpent(totalSpent.toFixed(2));
    setRemainedManhour((totalBudgetManhour - totalSpent).toFixed(2));
    setLastUpdate(new Date().toLocaleDateString("en-GB"));
    setSelectionModel(newSelectionModel);
    console.log(projectArray);
    setProjectArray(projectArray);
    setPercentageArray(percentageArray);
    console.log(percentageArray);
    setTotalSpentPercentage(
      ((totalSpent / totalBudgetManhour) * 100).toFixed(1),
    );
    if (projectArray.length > 0 && projectArray.includes("Remained")) {
      const nonLastRecordColors = pieChartColorArray;
      setColorArray([
        ...nonLastRecordColors.slice(0, projectArray.length - 1),
        "#a3a3a3",
      ]);
    } else {
      setColorArray(pieChartColorArray);
    }
  };

  const applySearch = (data: any) => {
    console.log(data);
    setSearchCriteria(data);
  };
  return (
    <Grid item sm>
      {/* <CustomSearchForm applySearch={applySearch} fields={InputFields}/> */}
      {/* <CustomDatagrid rows={rows} columns={columns} columnWidth={200} dataGridHeight={300}/> */}
      <div style={{ display: "inline-block", width: "70%" }}>
        <Grid item xs={12} md={12} lg={12}>
          <Card>
            <CardHeader className="text-slate-500" title="Project Resource Consumption" />
            <div style={{ display: "inline-block", width: "99%" }}>
              <ReactApexChart
                options={options}
                series={options.series}
                type="bar"
                height={350}
              />
            </div>
            {/* <div style={{display:"inline-block",width:"20%",verticalAlign:"top",textAlign:"center"}}>
                    <p><strong><u>Stage Deadline</u></strong></p>
                    {stageDeadline.map((date, index) => {
                      const marginTop = index === 0 ? 25 : 20;
                      return (
                        <p style={{marginTop:marginTop}} key={index}>{date}</p>
                      );
                    })}
                  </div> */}
            <CardHeader
              className="text-slate-500"
              title="Resource Consumption and Coming Milestone"
            />
            <div
              style={{ display: "inline-block", width: "99%", marginLeft: 10 }}
            >
              <CustomDatagrid
                rows={teamProjectResult}
                columns={columns2}
                columnWidth={200}
                dataGridHeight={300}
                checkboxSelection={true}
                onRowSelectionModelChange={handleSelectionChange}
                selectionModel={selectionModel}
              />
            </div>
          </Card>
        </Grid>
      </div>
      <div
        style={{
          display: "inline-block",
          width: "30%",
          verticalAlign: "top",
          marginLeft: 0,
        }}
      >
        <Grid item xs={12} md={12} lg={12}>
          <Card style={{ marginLeft: 15, marginRight: 20 }}>
            <CardHeader
              className="text-slate-500"
              title="Overall Progress per Project"
            />
            {percentageArray.length === 0 && (
              <div
                className="mt-10 mb-10 ml-5 mr-5 text-lg font-medium text-center"
                style={{ color: "#898d8d" }}
              >
                Please select the project you want to check.
              </div>
            )}
            {percentageArray.length > 0 && (
              <ReactApexChart
                options={options2}
                series={percentageArray}
                type="donut"
              />
            )}
          </Card>
        </Grid>
        <Grid item xs={12} md={12} lg={12}>
          <Card style={{ marginLeft: 15, marginRight: 20, marginTop: 20 }}>
            <div>
              <div
                className="mt-5 text-lg font-medium"
                style={{ color: "#898d8d" }}
              >
                <span style={{ marginLeft: "5%" }}>Project Budget Manhour</span>
              </div>
              <div
                className="mt-2 text-2xl font-extrabold"
                style={{ color: "#6b87cf" }}
              >
                <span style={{ marginLeft: "5%" }}>{projectBudgetManhour}</span>
              </div>
            </div>
            <hr />
            <div>
              <div
                className="mt-2 text-lg font-medium"
                style={{ color: "#898d8d" }}
              >
                <span style={{ marginLeft: "5%" }}>Actual Manhour Spent</span>
              </div>
              <div
                className="mt-2 text-2xl font-extrabold"
                style={{ color: "#6b87cf" }}
              >
                <span style={{ marginLeft: "5%" }}>{actualManhourSpent}</span>
              </div>
            </div>
            <hr />
            <div>
              <div
                className="mt-2 text-lg font-medium"
                style={{ color: "#898d8d" }}
              >
                <span style={{ marginLeft: "5%" }}>Remained Manhour</span>
              </div>
              <div
                className="mt-2 text-2xl font-extrabold"
                style={{ color: "#6b87cf" }}
              >
                <span style={{ marginLeft: "5%" }}>{remainedManhour}</span>
              </div>
            </div>
            <hr />
            <div>
              <div
                className="mt-2 text-lg font-medium"
                style={{ color: "#898d8d" }}
              >
                <span style={{ marginLeft: "5%" }}>Last Update</span>
              </div>
              <div
                className="mt-2 mb-5 text-2xl font-extrabold"
                style={{ color: "#6b87cf" }}
              >
                <span style={{ marginLeft: "5%" }}>{lastUpdate}</span>
              </div>
            </div>
          </Card>
        </Grid>
      </div>
    </Grid>
  );
};

export default ProgressByTeam;
