croissant | Lightweight yet useful library for Bukkit/Spigot/Paper | Plugin library

by OverMighty Java Version: 1.0.2 License: MIT

kandi X-RAY | croissant Summary

croissant is a Java library typically used in Plugin, Minecraft applications. croissant has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can download it from GitHub, Maven.

Croissant is a lightweight Java library that provides a command framework and a GUI framework for Bukkit/Spigot/Paper plugins.

Support

Quality

Security

License

Reuse

kandi-support Support

croissant has a low active ecosystem.
It has 11 star(s) with 0 fork(s). There are 2 watchers for this library.
It had no major release in the last 12 months.
croissant has no issues reported. There are no pull requests.
It has a neutral sentiment in the developer community.
The latest version of croissant is 1.0.2

croissant Support

Best in #Plugin

Average in #Plugin

croissant Support

Best in #Plugin

Average in #Plugin

quality kandi Quality

croissant has no bugs reported.

croissant Quality

Best in #Plugin

Average in #Plugin

croissant Quality

Best in #Plugin

Average in #Plugin

security Security

croissant has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

croissant Security

Best in #Plugin

Average in #Plugin

croissant Security

Best in #Plugin

Average in #Plugin

license License

croissant is licensed under the MIT License. This license is Permissive.
Permissive licenses have the least restrictions, and you can use them in most projects.

croissant License

Best in #Plugin

Average in #Plugin

croissant License

Best in #Plugin

Average in #Plugin

build Reuse

croissant releases are not available. You will need to build from source code and install.
Deployable package is available in Maven.
Build file is available. You can build the component from source.
Installation instructions, examples and code snippets are available.

croissant Reuse

Best in #Plugin

Average in #Plugin

croissant Reuse

Best in #Plugin

Average in #Plugin

Top functions reviewed by kandi - BETA

kandi has reviewed croissant and discovered the below as its top functions. This is intended to give you an instant insight into croissant implemented functionality, and help decide if they suit your requirements.

Sets a navigation button

Make a navigation item
Sets a button on the inventory
Creates a handler that allows to open a navigation menu event

Handle a tab completion event

Gets the argument type
Tab complete argument
Handle tab - complete sub - command argument

Adds an entry to the stack

Removes the item flags from the stack

Adds the given item flags to the stack

Adds a warning to the stack

Registers a Croissant command

Removes the item stack at the specified slot

Sets the button in the first empty slot in the GUI

Sets the display name of the stack

Sets the amount of items in the stack

Adds a sub - command

Set the durability of items

Sets the lore of the Item

Removes an element from the stack

Handle an inventory dragging event

Detect executor method

Expose the command map

Handle an inventory click event

Detect required arguments

Get all kandi verified functions for this library.

croissant Key Features

Command framework No need to declare commands in your plugin's plugin.yml file Automated argument parsing and tab-completion Arguments are inferred from method parameters Arguments can be either required or optional, and optional arguments can have default values Built-in argument types + ability to create your own argument types Subcommands

GUI framework Create interactive GUIs from fake chest inventories Supports both single-page GUIs and multi-page GUIs with navigation buttons (referred to as "scrollable GUIs")

croissant Examples and Code Snippets

Community Discussions

Trending Discussions on croissant

css positioning problem with hover pseudo class
Posting array of objects to REST API with ReactJS
Google Sheet - Sort data by single value, with sums and divisions based on multiple criteria
Combine to one group with the same id or attribute SQL Group_concat doesn't help:(
can you help me how to breakdown the denomination of my change? I've been searching everywhere how to do it but I still don't get it
How to reload Array Data in React
Is there a way to group any number of cells into a table?
Javascript regex for words between characters
using custom data types in haskell
Two column CSS flexbox not responding to 800px media query

Trending Discussions on croissant

QUESTION

css positioning problem with hover pseudo class

Asked 2021-Jun-15 at 01:41

I'm trying to design a simple page for practicing with just html and css. I used a hover pseudo class for the croissant image. It works but when I hover the mouse over the croissant the coffee cup image will move to right a little(almost 50 or 100 pixels) and when I hover off of the croissant the coffee cup will back in its position before. meanwhile I'm new in web design and just start learning few days. here's my code:

body {
  margin: 0px;
  background-image: url('https://c8.alamy.com/comp/2BT68F1/vector-black-chalkboard-style-hand-drawn-bakery-horizontal-border-pattern-suitable-for-bread-packaging-cafe-menu-design-and-wallpaper-2BT68F1.jpg');
  background-size: cover;
}

#img1 {
  background-repeat: no-repeat;
  width: 100%;
  height: 40%;
}

#instagram1 {
  width: 20px;
  height: 20px;
  float: left;
}

#instagram2 {
  width: 20px;
  height: 20px;
  position: relative;
  right: 168px;
  top: 5px;
}

#bakery {
  color: black;
  float: left;
  position: relative;
  bottom: 15px;
  left: 5px;
}

#cafe {
  color: black;
  float: left;
  position: relative;
  right: 75px;
  bottom: 10px;
}

div {
  width: 200px;
  height: 60px;
  float: right;
  position: relative;
  top: 550px;
  background-color: #b3d9ff;
}

#croissant {
  width: 200px;
  height: 100px;
  position: relative;
  left: 1100px;
  top: 250px;
}

#espresso {
  position: relative;
  top: 280px;
  right: 150px;
  width: 200px;
  height: 150px;
}

#croissant:hover {
  width: 250px;
  height: 150px;
}

<img id="croissant" src="https://freepngimg.com/thumb/croissant/29021-7-croissant-transparent-background.png">

<img id="espresso" src="https://services.garmin.com/appsLibraryBusinessServices_v0/rest/apps/eae8653c-e809-4e35-ac17-d9866ba92b26/icon/e684d982-4aa3-48fb-8e2e-08d53e5096b6">

<div>
  <img id="instagram1" src="https://upload.wikimedia.org/wikipedia/commons/thumb/e/e7/Instagram_logo_2016.svg/768px-Instagram_logo_2016.svg.png">

  <p id="bakery"> @red.bakery </p>
  </br>
  </br>
  <img id="instagram2" src="https://upload.wikimedia.org/wikipedia/commons/thumb/e/e7/Instagram_logo_2016.svg/768px-Instagram_logo_2016.svg.png">

  <p id="cafe"> @red.cafe </p>
</div>

ANSWER

Answered 2021-Jun-15 at 01:41

In details:

relative
...
if you do give it some other positioning attribute, say, top: 10px;, it will shift its position 10 pixels down from where it would normally be.
...
absolute
...
use the positioning attributes top, left, bottom, and right to set the location. Remember that these values will be relative to the next parent element with relative (or absolute) positioning. If there is no such parent, it will default all the way back up to the element itself meaning it will be placed relative to the page itself
...

Muhammad Zaib has the answer, and there is a demo:

body {
  margin: 0px;
  background-image: url('https://c8.alamy.com/comp/2BT68F1/vector-black-chalkboard-style-hand-drawn-bakery-horizontal-border-pattern-suitable-for-bread-packaging-cafe-menu-design-and-wallpaper-2BT68F1.jpg');
  background-size: cover;
}

#img1 {
  background-repeat: no-repeat;
  width: 100%;
  height: 40%;
}

#instagram1 {
  width: 20px;
  height: 20px;
  float: left;
}

#instagram2 {
  width: 20px;
  height: 20px;
  position: relative;
  right: 168px;
  top: 5px;
}

#bakery {
  color: black;
  float: left;
  position: relative;
  bottom: 15px;
  left: 5px;
}

#cafe {
  color: black;
  float: left;
  position: relative;
  right: 75px;
  bottom: 10px;
}

div {
  width: 200px;
  height: 60px;
  float: right;
  position: relative;
  top: 550px;
  background-color: #b3d9ff;
}

#croissant-wrapper {
  width: 200px;
  height: 100px;
  position: relative;
  left: 1100px;
  top: 250px;
}

#croissant {
  width: 200px;
  height: 100px;
  position: absolute;
}

#croissant:hover {
  width: 250px;
  height: 150px;
}

#espresso {
  position: relative;
  top: 280px;
  width: 200px;
  height: 150px;
}

<span id="croissant-wrapper">
    <img id="croissant" src="https://freepngimg.com/thumb/croissant/29021-7-croissant-transparent-background.png">
</span>

<img id="espresso" src="https://services.garmin.com/appsLibraryBusinessServices_v0/rest/apps/eae8653c-e809-4e35-ac17-d9866ba92b26/icon/e684d982-4aa3-48fb-8e2e-08d53e5096b6">

<div>
  <img id="instagram1" src="https://upload.wikimedia.org/wikipedia/commons/thumb/e/e7/Instagram_logo_2016.svg/768px-Instagram_logo_2016.svg.png">

  <p id="bakery"> @red.bakery </p>
  <br/>
  <br/>
  <img id="instagram2" src="https://upload.wikimedia.org/wikipedia/commons/thumb/e/e7/Instagram_logo_2016.svg/768px-Instagram_logo_2016.svg.png">

  <p id="cafe"> @red.cafe </p>
</div>

Source https://stackoverflow.com/questions/67970263

QUESTION

Posting array of objects to REST API with ReactJS

Asked 2021-May-28 at 07:30

I am working on a project in which I need to post a new Course to my API. I tested this with POSTMAN and API works just fine, however when I try to post data using react fetch data is corrupted. While sending single strings like dishName: "pizza" works just fine and is shown in database I cannot manage to send an array of objects. I tried to do it in many ways like:

 [
            {
                "quantity": 1,
                "unit": "",
                "description": "egg"
            },
            {
                "quantity": 0.5,
                "unit": "cup",
                "description": "mozzarella shredded"
            }
]

or:

                {
                "quantity": 1,
                "unit": "",
                "description": "egg"
            },
            {
                "quantity": 0.5,
                "unit": "cup",
                "description": "mozzarella shredded"
            }

and many, many more combinations but I failed.

Here is my React class which is responsible for sending data to API:

import React, { useState } from "react";
import { useHistory } from "react-router-dom";

export default function Login() {
  const [dishName, setdishName] = useState("");
  const [category, setcategory] = useState("");
  const [author, setauthor] = useState("");
  const [ingredients, setingredients] = useState([]);
  const [cookingTime, setcookingTime] = useState("");
  const [sourceUrl, setsourceUrl] = useState("");
  const [imageUrl, setimageUrl] = useState("");
  const [isPublished, setisPublished] = useState("true");
  const [price, setprice] = useState("");
  const [tags, settags] = useState([]);
  const history = useHistory();

  async function login() {
    let item = {
      dishName,
      category,
      author,
      ingredients,
      cookingTime,
      sourceUrl,
      imageUrl,
      isPublished,
      price,
      tags,
    };

    await fetch("http://localhost:1234/api/courses", {
      method: "POST",
      body: JSON.stringify(item),
      headers: {
        "Content-Type": "application/json",
        Accept: "application/json",
      },
    });

    history.push("/addCourse");
    //   window.location.reload();
  }

  return (
    <div className="col-sm-6" style={{ textAlign: "center" }}>
      <h1 className="bigBar">Create new recipe</h1>
      <input
        type="text"
        onChange={e => setdishName(e.target.value)}
        className="form-control"
        placeholder="dishName"
      />
      <br />

      <input
        type="text"
        onChange={e => setcategory(e.target.value)}
        className="form-control"
        placeholder="cathegory"
      />
      <br />

      <input
        type="text"
        onChange={e => setauthor(e.target.value)}
        className="form-control"
        placeholder="author"
      />
      <br />

      <input
        type="text"
        onChange={e => setingredients(e.target.value)}
        className="form-control"
        placeholder='{"quantity": int, "unit": "", "description": ""}'
      />
      <br />

      <input
        type="text"
        onChange={e => setcookingTime(e.target.value)}
        className="form-control"
        placeholder="cooking time"
      />
      <br />

      <input
        type="text"
        onChange={e => setsourceUrl(e.target.value)}
        className="form-control"
        placeholder="source url"
      />
      <br />

      <input
        type="text"
        onChange={e => setimageUrl(e.target.value)}
        className="form-control"
        placeholder="image url"
      />
      <br />

      <input
        type="text"
        onChange={e => setisPublished(e.target.value)}
        className="form-control"
        placeholder="publish status (dafault: true)"
      />
      <br />

      <input
        type="text"
        onChange={e => setprice(e.target.value)}
        className="form-control"
        placeholder="price"
      />
      <br />

      <input
        type="text"
        onChange={e => settags(e.target.value)}
        className="form-control"
        placeholder="tags"
      />
      <br />

      <button onClick={login} className="btn btn-primary">
        Sign up
      </button>
    </div>
  );
}

When I send data I get no error. There is simply an array of Ingredients which is empty when I click ot unfold its elements in MongoDB or in the case of Tags it doesn't even appear in MongoDB.

Could you please tell me how can I fix this or if it is me who is doing something wrong? I searched a lot for an answer but after 2 hours I found nothing useful.

EDIT: I am adding my REST API post method for new Courses:

router.post("/", async (req, res) => {
  const { error } = validateCourse(req.body);

  if (error)
    //   400 Bad request
    return res.status(400).send(error.details[0].message);

  let course = new Course(
    _.pick(req.body, [
      `dishName`,
      `category`,
      `author`,
      `ingredients`,
      `cookingTime`,
      `sourceUrl`,
      `imageUrl`,
      `isPublished`,
      `price`,
      //  `tags`,
    ])
  );

And schema for new Courses:

const mongoose = require(`mongoose`);
const Joi = require(`joi`);

function validateCourse(body) {
  const schema = Joi.object({
    dishName: Joi.string().min(3).required(),
    category: Joi.string().min(3).required(),
    author: Joi.string().min(3).required(),
    ingredients: Joi.required(),
    cookingTime: Joi.number().min(0).required(),
    sourceUrl: Joi.string().required(),
    imageUrl: Joi.string().required(),
    isPublished: Joi.boolean().required(),
    price: Joi.number().min(0).required(),
    tags: Joi.required(),
    date: Joi.allow(),
  });
  return schema.validate(body);
}

const Course = mongoose.model(
  `Course`,
  new mongoose.Schema({
    dishName: { type: String, required: true, minLength: 3, maxLength: 255 },
    category: {
      type: String,
      required: true,
      lowercase: true,
      trim: true,
      dishType: [
        "carrot",
        "broccoli",
        "asparagus",
        "cauliflower",
        "corn",
        "cucumber",
        "green pepper",
        "lettuce",
        "mushrooms",
        "onion",
        "potato",
        "pumpkin",
        "red pepper",
        "tomato",
        "beetroot",
        "brussel sprouts",
        "peas",
        "zucchini",
        "radish",
        "sweet potato",
        "artichoke",
        "leek",
        "cabbage",
        "celery",
        "chili",
        "garlic",
        "basil",
        "coriander",
        "parsley",
        "dill",
        "rosemary",
        "oregano",
        "cinnamon",
        "saffron",
        "green bean",
        "bean",
        "chickpea",
        "lentil",
        "apple",
        "apricot",
        "avocado",
        "banana",
        "blackberry",
        "blackcurrant",
        "blueberry",
        "boysenberry",
        "cherry",
        "coconut",
        "fig",
        "grape",
        "grapefruit",
        "kiwifruit",
        "lemon",
        "lime",
        "lychee",
        "mandarin",
        "mango",
        "melon",
        "nectarine",
        "orange",
        "papaya",
        "passion fruit",
        "peach",
        "pear",
        "pineapple",
        "plum",
        "pomegranate",
        "quince",
        "raspberry",
        "strawberry",
        "watermelon",
        "salad",
        "pizza",
        "pasta",
        "popcorn",
        "lobster",
        "steak",
        "bbq",
        "pudding",
        "hamburger",
        "pie",
        "cake",
        "sausage",
        "Tacos",
        "Kebab",
        "poutine",
        "seafood",
        "chips",
        "fries",
        "masala",
        "paella",
        "som tam",
        "chicken",
        "toast",
        "marzipan",
        "tofu",
        "Ketchup",
        "hummus",
        "chili",
        "maple syrup",
        "parma ham",
        "fajitas",
        "champ",
        "lasagna",
        "poke",
        "chocolate",
        "croissant",
        "arepas",
        "bunny chow",
        "pierogi",
        "donuts",
        "rendang",
        "sushi",
        "ice cream",
        "duck",
        "curry",
        "beef",
        "goat",
        "lamb",
        "turkey",
        "pork",
        "fish",
        "crab",
        "bacon",
        "ham",
        "pepperoni",
        "salami",
        "ribs",
        "other",
      ],
    },
    author: String,
    ingredients: [
      {
        quantity: Number,
        unit: String,
        description: String,
      },
    ],
    cookingTime: { type: Number, required: true },
    sourceUrl: String,
    imageUrl: String,
    date: { type: Date, default: Date.now },
    isPublished: { type: Boolean, default: true },
    price: {
      type: Number,
      required: function () {
        return this.isPublished;
      },
    },
    tags: {
      type: Array,
      validate: {
        validator: function (v) {
          return v && v.length > 0;
        },
        message: `A course should have at least one tag.`,
      },
    },
  })
);

exports.Course = Course;
exports.validateCourse = validateCourse;

ANSWER

Answered 2021-May-27 at 21:44

You are setting the ingredients state as a string, so you are basically 'stringify' a string which will result in JSON SyntaxError. If you want to send an array that way you must specify the array bracket [ and ] in order to make it a valid array.

To solve it just change:


      <input
        type="text"
        onChange={e => setingredients(e.target.value)}
        className="form-control"
        placeholder='{"quantity": int, "unit": "", "description": ""}'
      />

You need to change it to:


      <input
        type="text"
        //parse the string input
        onChange={e => setingredients(JSON.parse(e.target.value))}
        className="form-control"
        //notice the array bracket '[' and ']'
        placeholder='[{"quantity": int, "unit": "", "description": ""}, {"quantity": int, "unit": "", "description": ""}]'
      />

Source https://stackoverflow.com/questions/67730171

QUESTION

Google Sheet - Sort data by single value, with sums and divisions based on multiple criteria

Asked 2021-May-05 at 14:04

I launched a week ago into my biggest google sheet formula and I am reaching the limits of what I can do. I usually always find the answers to my questions by searching a little, but not this time.

I have exported a list of projects since the start of the company in 2017, there are more than 9000 lines.

Inside there are lots of columns, but the ones that interest us are:

start date
organization
state (draft, quotation or order)
draft or quotation amount
order amount
status (dead, lost, canceled, provisional, open, reserved, active, completed)

data screenshot

In another sheet I wanted to show some columns based on some criteria but based on unique values from customers.

With as column:

A / client
B / income (sum of the order amount column if the status is different from lost, dead or canceled)
C / number of contracts (number of orders if the status is different from lost, dead or canceled)
D / number of draft and quotation (so if the state is equal to Draft or Quotation and the status is different from lost, dead or canceled)
E / number of lost (when the status is equal to lost, dead or canceled)
F / average amount per contract (B divided by C)
G / conversion rate (C divided by C + D + E)

In addition to that, I have dedicated cells to choose dates, so that users of this table can sort by month and / or year (see screenshot).

customer view screenshot

I started by using the UNIQUE function in column A to output the customer list. I then made SUMPRODUCT in the other columns according to my criteria. But 6 columns x 600 rows of SUMPRODUCT, googlesheet takes 5 min to give me a result every time I change my dates ... So I looked around a bit and discovered the UNIQUE, FILTER and SUMIF mix.

To help me with that, I created columns at the end of my 1st table (see 1st screenshot) which will help me with my SUMIFS (SOMME.SI in French), there will only need to be the addition of each of the rows, with as criterion the UNIQUE of the 1st column and the dates. If I did that, it's because I couldn't do SUMPRODUCTs in ArrayFormula.

By trying a little I came up with a huge formula.

=sort(
{unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),
    
ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!W2:W)),

ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!X2:X)),

ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!Y2:Y)),

ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!Z2:Z)),

SIERREUR(ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!W2:W))/
ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!X2:X)),""),

SIERREUR(ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!X2:X))/
(ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!X2:X))+
ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!Y2:Y))+
ArrayFormula(SOMME.SI('DATA OPPORTUNITY'!E2:E,unique(filter('DATA OPPORTUNITY'!E2:E,'DATA OPPORTUNITY'!B2:B>=B1,'DATA OPPORTUNITY'!B2:B<=B2)),'DATA OPPORTUNITY'!Z2:Z))),"")}

,A4,SI(B4="croissant",VRAI,FAUX))

It's really scary when you see that but it works. On the other hand, with the size of the formula, I told myself that I was probably doing it really badly and that there must be a much simpler solution.

To talk about the formula, it allows me to display each column correctly, with the right values and it takes 1 seconds to make the change with my dates.

I wanted to use a filtered view to do ascending sorting of the columns, but the filtered view doesn't work with this kind of formula. So I was able to use SORT which allows me thanks to the IF (SI in French) inside to choose which column to sort and in which direction.

My last problem, as you can see in the customer view screenshot, I see customers who are at 0. These are customers who have had no orders with us, just lost, dead or canceled projects. I cannot exclude them from my calculation, because I also need to know the number of lost projects with other clients. I just need at the end, after the calculation, not to show the customers who made $ 0 with us in income.

What do you think of the giant formula, does it sound optimal to you? And for customers with $ 0, how can I hide them?

Thank you very much for the time spent reading this long text and for the answers you can give me! :)

ANSWER

Answered 2021-May-05 at 14:04

Thanks to Aresvik's comment which directed me to the right solution, I was able to solve all of my problems with this formula :

=QUERY(
   QUERY(
      'DATA OPPORTUNITY'!A2:Z,"select E, sum(W), max(W), sum(X), sum(Z), sum(W)/sum(X), 
      sum(X)/(sum(X)+sum(Y)+sum(Z)) 
      where" &SI(F2<>""," E='"&F2&"' and "," ")& "B >= date '"&TEXTE(B1,"yyyy-mm-dd")&"' 
      and B <= date '"&TEXTE(B2,"yyyy-mm-dd")&"'
      group by E label E'', sum(W)'', max(W)'', sum(X)'', sum(Z)'', sum(W)/sum(X)'', 
      sum(X)/(sum(X)+sum(Y)+sum(Z))''"
   )
   , "select * where Col2 <> 0 and Col2 is not null Order By 
   Col"&SIERREUR(EQUIV(D1,5:5,0),1)&SI(D2="A to Z"," asc"," desc")
)

The query in the query allows me to take into account the lost contracts in my calculation in the 1st query, but with the 2nd not to display the customers who have not reported income during the targeted period. Compared to the initial project I added max (W) which allows me to know the highest project with a client. I also added references to cells to know by which column we want to sort, and if it is increasing or decreasing. And finally, in the "where" a criterion which appears only if the cell is filled, allowing to display only one customer.

Source https://stackoverflow.com/questions/67339288

QUESTION

Combine to one group with the same id or attribute SQL Group_concat doesn't help:(

Asked 2021-Mar-21 at 14:49

I need to group row's in one row if they have same id or same attribute. So i suppose i need to use INNER JOIN and GROUP_CONCAT, but i don't know how. Problem is that if two users do not have a common attribute, but fall into the same group with the same third user, all three must be combined into one group. Also i don't have group_id column in table.

group_id, user_id, group_attributes
1, 1, "red, green, yellow, grey, purple, coffeemaker"
1, 2, "red, green, yellow, grey, purple, coffeemaker"
1, 3, "red, green, yellow, grey, purple, coffeemaker"
1, 4, "red, green, yellow, grey, purple, coffeemaker"
1, 5, "red, green, yellow, grey, purple, coffeemaker"
2, 6, "coffee, milk, croissant"
2, 7, "coffee, milk, croissant"
2, 8, "coffee, milk, croissant"

Raw data to reduce your answer time.

CREATE TABLE task (
    user_id INT(10) NOT NULL,
    attribute VARCHAR(50) NULL DEFAULT NULL);
INSERT INTO task (user_id, attribute)
VALUES
(1, 'red'),
(1, 'green'),
(2, 'green'),
(2, 'yellow'),
(3, 'grey'),
(3, 'coffeemaker'),
(4, 'grey'),
(4, 'purple'),
(5, 'purple'),
(5, 'red'),
(6, 'black'),
(7, 'black'),
(7, 'milk'),
(8, 'milk'),
(8, 'croissant');

ANSWER

Answered 2021-Mar-21 at 14:49

This is a graph-walking problem, so a simple JOIN is not sufficient. One approach is to get all attributes associates with a given attribute. The following recursive CTE does this:

with recursive aa as (
      select distinct t1.attribute as at1, t2.attribute as at2
      from task t1 join
           task t2
           on t1.user_id = t2.user_id
     ),
     cte as (
      select at1, at2, at1 as found, 1 as lev
      from aa
      union all
      select cte.at1, aa.at2, concat_ws(',', found, aa.at2), lev + 1
      from cte join
           aa
           on cte.at2 = aa.at1
      where find_in_set(aa.at2, found) = 0 
     )
select distinct at1, at2
from cte;

You can then use the same recursive CTE to combine the values into a string:

with recursive aa as (
      select distinct t1.attribute as at1, t2.attribute as at2
      from task t1 join
           task t2
           on t1.user_id = t2.user_id
     ),
     cte as (
      select at1, at2, at1 as found, 1 as lev
      from aa
      union all
      select cte.at1, aa.at2, concat_ws(',', found, aa.at2), lev + 1
      from cte join
           aa
           on cte.at2 = aa.at1
      where find_in_set(aa.at2, found) = 0 
     )
select dense_rank() over (order by pairs.all_attributes) as group_id, t.user_id, pairs.all_attributes
from (select at1, group_concat(at2) as all_attributes
      from cte
      group by at1
     ) pairs join
     (select user_id, min(attribute) as min_attribute
      from task
      group by user_id
     ) t
     on t.min_attribute = pairs.at1;

I see nothing wrong with this code. But db<>fiddle is insisting on creating a hex string for pairs. However, I think this will work on your database. Here is the fiddle.

Source https://stackoverflow.com/questions/66733543

QUESTION

can you help me how to breakdown the denomination of my change? I've been searching everywhere how to do it but I still don't get it

Asked 2021-Mar-15 at 10:06

import java.util.Scanner;
class OrderingSystemAlternative {
static Scanner scanner = new Scanner(System.in);

static String [] Bread = {"Cheese Bread","Bagel","Ham and Cheese Bread","Vegetable Sandwich","Choco 
Bread Pudding",
                          "French Toast","Garlic Toast","Tuna Bread","Pizza Bread","Croissant"};
static String [] Cake = {"Blueberry", "Cheesecake", "Dark Chocolate", "Chocolate Fudge", "Creme 
Brulee", "Mocha",
                         "Ube", "Red Velvet", "Chiffon", "Mango Mania"};
static String [] Coffee = {"Americano", "Latte", "Machiatto", "Espresso", "Black Coffee", "Mocha", 
"Cappuccino",
                           "Double Espresso", "Hot Chocolate", "Caramel Machiatto"};
static String [] Donut = {"Plain", "Glazed", "Chocolate Frosted", "Rainbow Sprinkles", "Alcapone", 
"Oreology",
                          "Butternut", "Jelly Filling", "Bavarian", "Cookies & Cream"};
static String [] Tea = {"Cheesecake Oreo", "Chestnut Cream", "Cream Cheese Cocoa", "Cranberry", 
"Black Pearl", "Mango Yakult",
                        "Caramel Machiatto", "Matcha", "Taro", "Oolong Tea"}; 
static double [] breadPrice = {20.00, 13.00, 25.00, 32.00, 45.00, 27.00, 20.00, 25.00, 55.00, 10.00};
static double [] cakePrice = {500.00, 350.00, 200.00, 230.00, 550.00, 200.00, 150.00, 430.00, 150.00, 
550.00};
static double [] coffeePrice = {65.00, 80.00, 90.00, 63.00, 75.00, 70.00, 85.00, 70.00, 65.00, 
100.00};
static double [] donutPrice = {35.00, 40.00, 40.00, 40.00, 80.00, 70.00, 85.00, 80.00, 50.00, 
100.00};
static double [] teaPrice = {160.00, 155.00, 155.00, 140.00, 130.00, 140.00, 195.00, 165.00, 130.00, 
155.00};

static double subTotal = 0;
static double grandTotal = 0;

public static void main(String[] args) {
    showMenu();
    order();
}

private static void showMenu() {
    System.out.println("\t\t\t\t+===================================+");
    System.out.println("\t\t\t\t                Cafe MENU            ");
    System.out.println("\n"); 
    System.out.println("\t\t\t\t             A. Bread & Toast        ");
    System.out.println("\t\t\t\t  1. Cheese Bread          Php. 20.00");
    System.out.println("\t\t\t\t  2. Bagel                 Php. 13.00");
    System.out.println("\t\t\t\t  3. Ham and Cheese Bread  Php. 25.00");
    System.out.println("\t\t\t\t  4. Vegetable Sandwich    Php. 32.00");
    System.out.println("\t\t\t\t  5. Choco Bread Pudding   Php. 45.00");
    System.out.println("\t\t\t\t  6. French Toast          Php. 27.00");
    System.out.println("\t\t\t\t  7. Garlic Toast          Php. 20.00");
    System.out.println("\t\t\t\t  8. Tuna Bread            Php. 25.00");
    System.out.println("\t\t\t\t  9. Pizza Bread           Php. 55.00");
    System.out.println("\t\t\t\t  10. Croissant            Php. 10.00");
    System.out.println(""); 
    System.out.println("\t\t\t\t                B. Cakes             ");
    System.out.println("\t\t\t\t  1. Blueberry            Php. 500.00");
    System.out.println("\t\t\t\t  2. Cheesecake           Php. 350.00");
    System.out.println("\t\t\t\t  3. Dark Chocolate       Php. 200.00");
    System.out.println("\t\t\t\t  4. Chocolate Fudge      Php. 230.00");
    System.out.println("\t\t\t\t  5. Creme Brulee         Php. 550.00");
    System.out.println("\t\t\t\t  6. Mocha                Php. 200.00");
    System.out.println("\t\t\t\t  7. Ube                  Php. 150.00");
    System.out.println("\t\t\t\t  8. Red Velvet           Php. 430.00");
    System.out.println("\t\t\t\t  9. Chiffon              Php. 150.00");
    System.out.println("\t\t\t\t  10. Mango Mania         Php. 550.00");
    System.out.println(""); 
    System.out.println("\t\t\t\t               C. Donuts             ");
    System.out.println("\t\t\t\t  1. Plain                 Php. 35.00");
    System.out.println("\t\t\t\t  2. Glazed                Php. 40.00");
    System.out.println("\t\t\t\t  3. Chocolate Frosted     Php. 40.00");
    System.out.println("\t\t\t\t  4. Rainbow Sprinkles     Php. 40.00");
    System.out.println("\t\t\t\t  5. Alcapone              Php. 80.00");
    System.out.println("\t\t\t\t  6. Oreology              Php. 70.00");
    System.out.println("\t\t\t\t  7. Butternut             Php. 85.00");
    System.out.println("\t\t\t\t  8. Jelly Filling         Php. 80.00");
    System.out.println("\t\t\t\t  9. Bavarian              Php. 50.00");
    System.out.println("\t\t\t\t  10. Cookies & Cream     Php. 100.00");
    System.out.println(""); 
    System.out.println("\t\t\t\t                D. Coffee            ");
    System.out.println("\t\t\t\t  1. Americano             Php. 65.00");
    System.out.println("\t\t\t\t  2. Latte                 Php. 80.00");
    System.out.println("\t\t\t\t  3. Machiatto             Php. 90.00");
    System.out.println("\t\t\t\t  4. Espresso              Php. 63.00");
    System.out.println("\t\t\t\t  5. Black Coffee          Php. 75.00");
    System.out.println("\t\t\t\t  6. Mocha                 Php. 70.00");
    System.out.println("\t\t\t\t  7. Cappuccino            Php. 85.00");
    System.out.println("\t\t\t\t  8. Double Espresso       Php. 70.00");
    System.out.println("\t\t\t\t  9. Hot Chocolate         Php. 65.00");
    System.out.println("\t\t\t\t  10. Caramel Machiatto   Php. 100.00");
    System.out.println("");        
    System.out.println("\t\t\t\t                  E. Tea             ");
    System.out.println("\t\t\t\t  1. Cheesecake Oreo      Php. 160.00");
    System.out.println("\t\t\t\t  2. Chestnut Cream       Php. 155.00");
    System.out.println("\t\t\t\t  3. Cream Cheese Cocoa   Php. 155.00");
    System.out.println("\t\t\t\t  4. Cranberry            Php. 140.00");
    System.out.println("\t\t\t\t  5. Black Pearl          Php. 130.00");
    System.out.println("\t\t\t\t  6. Mango Yakult         Php. 140.00");
    System.out.println("\t\t\t\t  7. Caramel Machiatto    Php. 195.00");
    System.out.println("\t\t\t\t  8. Matcha               Php. 165.00");
    System.out.println("\t\t\t\t  9. Taro                 Php. 130.00");
    System.out.println("\t\t\t\t  10. Oolong Tea          Php. 155.00");
    System.out.println(""); 
    System.out.println("\t\t\t\t                0. Cancel            ");
    System.out.println("\t\t\t\t+===================================+");
    System.out.println("\n");
}

private static void order() {
    System.out.println("Enter \"A\" for Bread & Toast , \"B\" for Cakes , \"C\" for Donuts, \"D\" for 
 Coffee, \"E\" for Tea and \"0\" to Cancel");
    System.out.print("Choose your Taste: ");
    String picked = scanner.next();
    
    switch (picked.toLowerCase()) { 
        case "a":
            breadAndToast();
            break;
        case "b":
            cakes();
            break;
        case "c":
            donuts();
            break;
        case "d":
            coffee();
            break;
        case "e":
            tea();
            break;
        case "0":
            System.exit(0);
            break;
        default:
            System.out.println("Choose From A to E only or Enter 0 to Cancel!");
            order();
    }
}

private static void breadAndToast() {
    System.out.println("You chose Bread & Toast");
    System.out.print("What's Your Choice? ");
    
    int choice = 0;
    try {
        String choiceStr = scanner.next();
        choice = Integer.parseInt(choiceStr);
        
        if (choice < 1 || choice - 1 > Bread.length) {
            System.out.println("Error: You have to choose a number from 1 to " + Bread.length);
            breadAndToast();
        }
    } catch (NumberFormatException e) {
        System.out.println("Invalid input! Please Enter a Number.");
        breadAndToast();
    } finally {
        int fChoice = choice - 1;

        System.out.println("Your Choice is " + Bread[fChoice] + " and the Price is " + 
  breadPrice[fChoice]);
        System.out.print("How many do you want? ");
        int quantity = scanner.nextInt();

        subTotal = subTotal + (quantity * breadPrice[fChoice]);

        System.out.println("Total is: " + subTotal);

        orderAgain(1);
    }
}

private static void cakes() {
    System.out.println("You chose Cakes");
    System.out.print("What's Your Choice? ");

    int choice = 0;
    try {
        String choiceStr = scanner.next();
        choice = Integer.parseInt(choiceStr);
        
        if (choice < 1 || choice - 1 > Cake.length) {
            System.out.println("Error: You have to choose a number from 1 to " + Cake.length);
            cakes();
        }
    } catch (NumberFormatException e) {
        System.out.println("Invalid input! Please Enter a Number.");
        cakes();
    } finally {
        int fChoice = choice - 1;

        System.out.println("Your Choice is " + Cake[fChoice] + " and the Price is " + 
  cakePrice[fChoice]);
        System.out.print("How many do you want? ");
        int quantity = scanner.nextInt();

        subTotal = subTotal + (quantity * cakePrice[fChoice]);

        System.out.println("Total is: " + subTotal);

        orderAgain(2);
    }
    
}

private static void donuts() {
    System.out.println("You chose Donuts");
    System.out.print("What's Your Choice? ");
    
    int choice = 0;
    try {
        String choiceStr = scanner.next();
        choice = Integer.parseInt(choiceStr);
        
        if (choice < 1 || choice - 1 > Donut.length) {
            System.out.println("Error: You have to choose a number from 1 to " + Donut.length);
            donuts();
        }
    } catch (NumberFormatException e) {
        System.out.println("Invalid input! Please Enter a Number.");
        donuts();
    } finally {
        int fChoice = choice - 1;

        System.out.println("Your Choice is " + Donut[fChoice] + " and the Price is " + 
  donutPrice[fChoice]);
        System.out.print("How many do you want? ");
        int quantity = scanner.nextInt();

        subTotal = subTotal + (quantity * donutPrice[fChoice]);

        System.out.println("Total is: " + subTotal);

        orderAgain(3);
    }
    
}
private static void coffee() {
    System.out.println("You chose Coffee");
    System.out.print("What's Your Choice? ");
    
    int choice = 0;
    try {
        String choiceStr = scanner.next();
        choice = Integer.parseInt(choiceStr);
        
        if (choice < 1 || choice - 1 > Coffee.length) {
            System.out.println("Error: You have to choose a number from 1 to " + Coffee.length);
            coffee();
        }
    } catch (NumberFormatException e) {
        System.out.println("Invalid input! Please Enter a Number.");
        coffee();
    } finally {
        int fChoice = choice - 1;

        System.out.println("Your Choice is " + Coffee[fChoice] + " and the Price is " + 
 coffeePrice[fChoice]);
        System.out.print("How many do you want? ");
        int quantity = scanner.nextInt();

        subTotal = subTotal + (quantity * coffeePrice[fChoice]);

        System.out.println("Total is: " + subTotal);

        orderAgain(4);
    }
    
}

private static void tea() {
    System.out.println("You chose Tea");
    System.out.print("What's Your Choice? ");
    
    int choice = 0;
    try {
        String choiceStr = scanner.next();
        choice = Integer.parseInt(choiceStr);
        
        if (choice < 1 || choice - 1 > Tea.length) {
            System.out.println("Error: You have to choose a number from 1 to " + Tea.length);
            tea();
        }
    } catch (NumberFormatException e) {
        System.out.println("Invalid input! Please Enter a Number.");
        tea();
    } finally {
        int fChoice = choice - 1;

        System.out.println("Your Choice is " + Tea[fChoice] + " and the Price is " + 
 teaPrice[fChoice]);
        System.out.print("How many do you want? ");
        int quantity = scanner.nextInt();

        subTotal = subTotal + (quantity * teaPrice[fChoice]);

        System.out.println("Total is: " + subTotal);

        orderAgain(5);
    }
    
}

private static void orderAgain(int num) {
    System.out.println("Anything Else? ");
    System.out.print("Press Y for Yes, N for No and M for Menu: ");
    String again = scanner.next();
    
    switch (again.toLowerCase()) {
        case "y":
            if (num == 1) {
                breadAndToast();
            } else if (num == 2) {
                cakes();
            } else if (num == 3) {
                donuts();
            } else if (num == 4) {
                coffee();
            } else if (num == 5) {
                tea();
            }
            break; 
        case "n":
            System.out.print("Enter Payment: ");
            double pay = scanner.nextDouble();
            if (pay < subTotal) {
                System.out.println("Not Enough Payment");
            } else {
                System.out.println("Total price is " + subTotal);
                grandTotal = pay - subTotal;
                System.out.println("\n");                    
                System.out.println("The change is " + grandTotal);

This is the part where it gets confusing. I cannot determine how to solve for the breakdown of my change.

                int thousand = (int)grandTotal/1000;//This is where I get confused
                int remainderThou = thousand % 1000;
                int fiveHun = (int)grandTotal/500;
                int remainderFive = fiveHun % 500;
                int twoHun = (int)grandTotal/200;
                int remainderTwo = twoHun % 200;
                int oneHun = (int)grandTotal/100;
                int remainderOne = oneHun % 100;
                int fifty = (int)grandTotal/50;
                int remainderFif = fifty % 50;
                int twenty = (int)grandTotal/20;
                int remainderTwen = twenty % 20;
                int ten = (int)grandTotal/10;
                int remainderTen = ten % 10;
                int five = (int)grandTotal/5;
                int remainderFives = five % 5;
                int one = (int)grandTotal/1;
                int remainderOnes = one % 1;
               System.out.println("Number of Php 1000.00: "+remainderThou);//sorry for the messiness
               System.out.println("Number of Php 500.00: "+remainderFive);
               System.out.println("Number of Php 200.00: "+remainderTwo);
               System.out.println("Number of Php 100.00: "+remainderOne);
               System.out.println("Number of Php 50.00: "+remainderFif);
               System.out.println("Number of Php 20.00: "+remainderTwen);
               System.out.println("Number of Php 10.00: "+remainderTen);
               System.out.println("Number of Php 5.00: "+remainderFives);
               System.out.println("Number of Php 1.00: "+remainderOnes);
            }
            break;
        case "m":
            order();
            break;
        default:
            System.out.println("Invalid Choose Again!");
            orderAgain(num);
    }
}
}

ANSWER

Answered 2021-Mar-15 at 10:06

To calculate the amount of smaller bills/coins you need to take only the remainder of the previous operation:

int thousand = (int)grandTotal/1000;
int remainderThou = grandTotal % 1000; // instead of thousand
int fiveHun = (int)remainderThou/500; // instead of grandTotal
int remainderFive = remainderThou % 500;  // instead of fiveHun
int twoHun = (int)remainderFive/200; // instead of grandTotal
int remainderTwo = remainderFive % 200; // instead of twoHun
......

And you should print the number of the bills/coins, not the remaining amount:

System.out.println("Number of Php 1000.00: "+thousand);
System.out.println("Number of Php 500.00: "+fiveHun);
System.out.println("Number of Php 200.00: "+twoHun);
......

P.S. Right now you have an extreme case of code duplication. You should think of better methods to perform repeating/similar operations.

Source https://stackoverflow.com/questions/66635514

QUESTION

How to reload Array Data in React

Asked 2021-Jan-23 at 20:29

im new on react, coming from Angular. i would like to know how to reload Array List in React. i want to filter the contain of getVilles like in the script, in the reload from place it display the right value i expected, but in the JSX it doesnt reload. How to do it correctly please.

Here is my Array : Concert.js

export const Concert = [
    {
            id: 1,
            imgSource: "...",
            artistName: "Artist Name",
            tourName: "Tour Name",
            date: "Date and hour",
            place: "Aix-en-provence",
            categorie : "Rock",
            tarifs:{
                to : "de",
                at : "a"
            }  
    },
    {
        id: 2,
        imgSource: "...",
        artistName: "Artist Name 2",
        tourName: "Tour Name",
        date: "Date and hour",
        place: "Aix-en-provence",
        categorie : "Elektro",
        tarifs:{
            to : "de",
            at : "a"
        }  
    },
    {
        id: 3,
        imgSource: "...",
        artistName: "Artist Name 2",
        tourName: "Tour Name",
        date: "Date and hour",
        place: "Dunkerque",
        categorie : "Elektro",
        tarifs:{
            to : "de",
            at : "a"
        }  
    },
    {
        id: 4,
        imgSource: "...",
        artistName: "Artist Name 2",
        tourName: "Tour Name",
        date: "Date and hour",
        place: "Cannes",
        categorie : "Elektro",
        tarifs:{
            to : "de",
            at : "a"
        }  
    },
    {
        id: 5,
        imgSource: "...",
        artistName: "Artist Name 2",
        tourName: "Tour Name",
        date: "Date and hour",
        place: "Cannes",
        categorie : "Elektro",
        tarifs:{
            to : "de",
            at : "a"
        }  
    },
    {
        id: 6,
        imgSource: "...",
        artistName: "Artist Name 6",
        tourName: "Tour Name",
        date: "Date and hour",
        place: "Cannes",
        categorie : "Elektro",
        tarifs:{
            to : "de",
            at : "a"
        }  
    },
    
];

Here is the card component which display each data : concert.component.ts

import { Link} from 'react-router-dom';


function ConcertComponent(props) {
    //console.log("Ville filter = ", props.ville);
    return <div className="card" style={{ width: '18rem' }}>
                    {/* <img src="..." className="card-img-top" alt="..."/> */}
                    <div className="card-body">
                        <h5 className="card-title">{ props.concertData.artistName }</h5>
                        <p className="card-text">{ props.concertData.categorie } </p>
                        <p className="card-text">{ props.concertData.place } </p>
                    
                        <Link to="#" className="btn btn-primary">Reserver</Link>
                    </div>
                </div>
}
export default ConcertComponent;

And here is The Page which contain all data with filter : ProgrammationView.js

export const getVilles = ["Aix-en-provence","Bourges","Cannes", "Dunkerque", "Echirolles"];
export const getCat = ["Pop", "Rock", "Elektro","Rap / Hip-Hop", "Soul / Funk", "Classique", "Dub / Reggae", "World"];
export const sortBy = ["Dates Croissante", "Dates décroissante", "A-Z", "Z-A"];

let getConcert = Concert;

const reloadFromPlace = (ville) =>
{   
        getConcert = Concert.filter(concert => concert.place === ville);
        console.log("Ville change", getConcert);

}

const ProgrammationView = () => {

        return (
            <div className="App container">
                <h1> Programmation </h1>
                <div className="filter row">
                    <div className="col-md-12">
                        <div className="place row justify-content-md-left">
                            <div className="col-md-1 title">
                                <h5>Lieu</h5> 
                            </div>
                            <div className="col-md-8 btn-group" role="group">
                                <button type="button" className="btn btn-light">Tous</button>
                                {
                                    getVilles.map(ville => // !!!! Normally here it should display the filter values of getVilles, but it doesnt. Why ??
                                        <button type="button" key={ville} onClick={()=> {reloadFromPlace(ville)}} className="btn btn-light">{ville}</button>
                                    )
                                }
                            </div>
                        </div>
                    </div>
                   
                </div>
                <div className="concert">
                    <div className="row listData justify-content-md-center">
                    {
                        getConcert.map(item => 
                            <React.Fragment key={item.id}>
                                <ConcertComponent concertData={item} key={item.id}></ConcertComponent>
                            </React.Fragment>
                            )
                    }
                    </div>
                    
                </div>
            </div>
        );
}
export default ProgrammationView;

ANSWER

Answered 2021-Jan-23 at 20:29

To re-render the component on changes, you need a local state. You can also use the useEffect Hook, if the concerts are coming from the props. https://reactjs.org/docs/hooks-effect.html

Here is an example of the local state (useState) Hook: Consider your Button onClick Handler:

button type="button" key={ville} onClick={()=> {reloadFromPlace(ville)}} className="btn btn-light">{ville}</button>

// And your read Method should do following:
const reloadFromPlace = (ville) =>
{   
        getConcert = Concert.filter(concert => concert.place === ville);
        setConcert(getConcert); // This changes the local state, which will trigger re-render
        console.log("Ville change", concert);

}

It correctly calls the reloadFromPlace function. But to tell your component, that something changed, the component has a local state, which doesn't change automatically.

Use the useState Method to keep a local state parameter:

const [concert, setConcert] = React.useState(Concert.slice(0, Concert.length); //add the Concert Array as a local state parameter

Then, change your JSX to use the local state parameter concert:

<div className="concert">
  <div className="row listData justify-content-md-center">
    { concert.map(item =>
    <React.Fragment key={item.id}>
      <ConcertComponent concertData={item} key={item.id}></ConcertComponent>
    </React.Fragment>
    ) }
  </div>
</div>

The final function definition could looks like this:

export const getVilles = ["Aix-en-provence", "Bourges", "Cannes", "Dunkerque", "Echirolles"];
export const getCat = ["Pop", "Rock", "Elektro", "Rap / Hip-Hop", "Soul / Funk", "Classique", "Dub / Reggae", "World"];
export const sortBy = ["Dates Croissante", "Dates décroissante", "A-Z", "Z-A"];

let getConcert = Concert;

const ProgrammationView = () => {
    const [concert, setConcert] = React.useState(Concert.slice(0, Concert.length); //add the Concert Array as a local state parameter

    const reloadFromPlace = (ville) => {
        getConcert = Concert.filter(concert => concert.place === ville);
        setConcert(getConcert); // This changes the local state, which will trigger re-render
        console.log("Ville change", getConcert);
    }

    return (
        <div className="App container">
            <h1> Programmation </h1>
            <div className="filter row">
                <div className="col-md-12">
                    <div className="place row justify-content-md-left">
                        <div className="col-md-1 title">
                            <h5>Lieu</h5>
                        </div>
                        <div className="col-md-8 btn-group" role="group">
                            <button type="button" className="btn btn-light">Tous</button>
                            {
                                getVilles.map(ville => // !!!! Normally here it should display the filter values of getVilles, but it doesnt. Why ??
                                    <button type="button" key={ville} onClick={() => { reloadFromPlace(ville) }} className="btn btn-light">{ville}</button>
                                )
                            }
                        </div>
                    </div>
                </div>

            </div>
            <div className="concert">
                <div className="row listData justify-content-md-center">
                    {
                        concert.map(item =>
                            <React.Fragment key={item.id}>
                                <ConcertComponent concertData={item} key={item.id}></ConcertComponent>
                            </React.Fragment>
                        )
                    }
                </div>

            </div>
        </div>
    );
}
export default ProgrammationView;

Source https://stackoverflow.com/questions/65863859

QUESTION

Javascript regex for words between characters

Asked 2021-Jan-16 at 01:13

As the title states, I tried making regex for %George%<Croissant>|2|10.3$

The point is it has to match only the name between the both % and the product between both <> and then the numbers between |

However, if the name doesn't start with capital letters followed by only lowercase letters, it is invalid hence not matched. The regex I made is:

/%(?<name>[A-Z][a-z]*)%<(?<product>[A-Za-z]*)>\|(?<quantity>(\d+))\|(?<price>(\d+\.\d*\$))/g

This is a match %George%<Croissant>|2|10.3$ (has proper name between the % which has a capital letter start start and followed to the end by lowercase letters), product (the product is between the < and >), a number between both | and final number (which is the final number and has to have $ in order to be valid)
This does NOT match %InvalidName%<Croissant>|2|10.3$ (because the name is invalid)
This does NOT match %Peter%<Gum>1.3$ (missing number from both |, it has to have 2 numbers.

Tested at regex101 and it matches only %George%<Croissant>|2|10.3$ .

ANSWER

Answered 2021-Jan-15 at 21:00

To match both patterns, you can match optional word characters \w*\| before the pipe at group quantity, and match optional word chars without digits y>(\d+)) before group price.

To match both prices, you have to make the decimal part optional, because the pattern that you tried expects at least 1 or more digits and a dot using \d+\.\d*

You can also omit the extra capture group in quantity as the digits are already in a named capture group.

%(?<name>[A-Z][a-z]*)%<(?<product>[A-Za-z]*)>\w*\|(?<quantity>\d+)\|[^\W\d]*(?<price>(\d+(?:\.\d+)?\$))

Explanation

%(?<name>[A-Z][a-z]*)% Group name between %, match at least an uppercase char A-Z and optional lowercase chars a-z
<(?<product>[A-Za-z]*)> Group product Match optional chars A-Za-z
\w*\| Match optional word characters, then match |
(?<quantity>(\d+))
\|[^\W\d]* Match optional word characters without the digits (to not overmatch the digits)
(?<price>(\d+(?:\.\d+)?\$)) Group price, with an optional decimal part