Untitled

//Frontend
import React, { useState } from "react";
import Papa from 'papaparse';
import { stt_award_csv } from "../services/Apis";
import Table, { StatusPill } from "./Table2";
import { useNavigate } from "react-router-dom";
import Sidebar from "../components/Sidebar";
import { useLocation } from "react-router-dom";
import Sidebar2 from "../components/staffSide";
import Sidebar3 from "../components/AdminSidebar";


function StAwardCsv(){
  const navigate = useNavigate();
  const { state } = useLocation();
  const utype = state.utype;
  const fname=state.fname;
  const email = state.email;
  var file;

    const handleSubmit = async (event) => {
  
    
      file = event.target.files[0];
  
      //await st_award_csv(fileData);
    }
  
    const handleClick=()=>{
      if(!file){
        alert("No file selected!");
      }
      Papa.parse(file, {
        delimiter: ',',
        skipEmptyLines: true,
  
        columns: ['Student_name','award_name', 'date', 'shared_with', 'award_link','additional_info'],
        header: true, complete: function (results) {
          let data=results.data;
  
          console.log("Finished:", data);
   for(const entry of data){
    if(utype==='0')
   { entry.status="pending..";
   entry.faculty_name=fname;
   entry.student_name=email;
   console.log(entry.student_name)
  }
   else if(utype==='4' || utype==='1' || utype==='2')
   { entry.status="verified";}
   
   }
   
          stt_award_csv(data);
          alert("sucessfully uploaded!");
          if(utype==='0')
        {  navigate('/Profile/Awards');}
        else if(utype==='4' ){
          navigate('/Admin/AdminStudent');
        }
        else if(utype==='1'){
          navigate('/StaffHome/StaffStudent');
        }
          window.location.reload();
  
        }
      });
    }
  
    const [data, setUserData] = useState([]);



    const columns = React.useMemo(
      () => [
  
        {
          Header: "Award/Achievement Name",
          accessor: "award_name",
        },
        {
          Header: "Date",
          accessor: "date",
        },
        {
          Header: "Shared With",
          accessor: "shared_with",
        },
        {
          Header: "Attached Link For Reference",
          accessor: "award_link",
        },
        {
          Header: "Additional Informatio  (If Any) ",
          accessor: "additional_info",
        },
      
      ],
      []
    );
  
  
  
  
    //  console.log(data);
  if(utype==='0'){
  
    return (
      <>
  
        <div className=" absolute right-0  w-3/4 bg-gray-100 text-gray-900">
          <Sidebar/>
          <main className="absolute max-w-4xl mx-auto px-4 sm:px-6 lg:px-8 pt-4">
            <div className="">
  
  
              <h1 className="text-xl font-semibold">SELECT A FILE OF GIVEN FORMAT FOR STUDENT DATA</h1> <br />
  
  <div class="flex flex-row ...">
              <input  class="block w-full text-sm text-gray-500 file:mr-4 file:py-2 file:px-2 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100 "
                type="file"
                accept=".csv,.xlsx,.xls"
                onChange={handleSubmit}
              /> <br />
  
  <button class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-1 px-3 rounded-full " onClick={handleClick}>submit</button>
  
  </div>
  
  
            </div>
  
            <Table columns={columns} data={data} />
            
  
  
          </main>
        </div>
       
      </>
  
    );  }
    else if(utype==='1')
{
  return (
    <>

      <div className=" absolute right-0  w-3/4 bg-gray-100 text-gray-900">
        <Sidebar2/>
        <main className="absolute max-w-4xl mx-auto px-4 sm:px-6 lg:px-8 pt-4">
          <div className="">


            <h1 className="text-xl font-semibold">SELECT A FILE OF GIVEN FORMAT FOR STUDENT DATA</h1> <br />

<div class="flex flex-row ...">
            <input  class="block w-full text-sm text-gray-500 file:mr-4 file:py-2 file:px-2 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100 "
              type="file"
              accept=".csv,.xlsx,.xls"
              onChange={handleSubmit}
            /> <br />

<button class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-1 px-3 rounded-full " onClick={handleClick}>submit</button>

</div>


          </div>

          <Table columns={columns} data={data} />
          


        </main>
      </div>
     
    </>

  ); 
}
else if(utype==='4'){
  
  return (
    <>

      <div className=" absolute right-0  w-3/4 bg-gray-100 text-gray-900">
        <Sidebar3/>
        <main className="absolute max-w-4xl mx-auto px-4 sm:px-6 lg:px-8 pt-4">
          <div className="">


            <h1 className="text-xl font-semibold">SELECT A FILE OF GIVEN FORMAT FOR STUDENT DATA</h1> <br />

<div class="flex flex-row ...">
            <input  class="block w-full text-sm text-gray-500 file:mr-4 file:py-2 file:px-2 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100 "
              type="file"
              accept=".csv,.xlsx,.xls"
              onChange={handleSubmit}
            /> <br />

<button class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-1 px-3 rounded-full " onClick={handleClick}>submit</button>

</div>


          </div>

          <Table columns={columns} data={data} />
          


        </main>
      </div>
     
    </>

  );  }

}
export default StAwardCsv;


//API
export const stt_award_csv = async(data)=>{
    return await commonrequest("POST",`${BACKEND_URL}/user/st_award_csv`,data)
}

//Backend
exports.insert_csv = async (req, res) => {

    const data = req.body;

    for (const entry of data) {
        try {
            // console.log(entry);
            const existingEntry = await stAwardDetail.findOne(entry);
            //console.log(existingEntry);
            if (existingEntry === null) {
                await stAwardDetail.create(entry)
            }


        } catch (error) {
            console.error(error);
            res.status(500).json({ message: 'An error occurred while checking data' });
            return;
        }
    }

}