import React from 'react';
import { graphql } from 'gatsby';
import Helmet from 'react-helmet';
import _ from 'lodash';
import { navigate } from "@reach/router"

const RandomShop = ({ data }) => {
  const { edges } = data.allMysqlMainView;
  const combinedEdges = edges;
  /*
  const rowRankViewEdges = data.allMysqlRankView.edges;
  //Creating a new dataset with original nodes and required columns from DataView
  edges.map((edge) => {
    const inputInstaID = edge.node.UserName;
    var resultRankView = _.filter(rowRankViewEdges, ({ node }) => node.UserName == inputInstaID)
    if (resultRankView.length > 0) {
      combinedEdges.push(edge);
    }
  })
  */

  //console.log("Total Shops with Rank View = ",combinedEdges.length,combinedEdges);
  const randomnumber = Math.round(Math.random() * combinedEdges.length);
  //console.log("Generated Random Number = "+randomnumber);
  const edge = combinedEdges[randomnumber-1] ? combinedEdges[randomnumber-1] : combinedEdges[0];
  //console.log(edge)
  const randomshopurl = "/shops/"+edge.node.emprezzoID+"/";
  //console.log("Random URL = "+randomshopurl);
  navigate(randomshopurl);

  return (
    <Helmet title={'Random Shop'} />
  );

};

export default RandomShop;

export const query = graphql`
  query {
    allMysqlMainView {
      edges {
        node {
          AlexaURL
          UserName
          emprezzoID
        }
      }
    }
  }
`;