ERP | ERP Inventory and Sales System

There's a table on my ERP database that has data about certain events. It has the start date, end date and a column shows if the event is a continuation of a previous one (sequential_id references unique_id). Here's an example:

unique_id start_date end_date sequential_id 001 2021-01-01 2021-01-15 002 2021-02-01 2021-02-16 001 003 2021-03-01 2021-03-17 002 004 2021-03-10 2021-03-11 005 2021-03-19

In the example above, rows 001, 002 and 003 are all part of the same event, and 004/005 are unique events, with no sequences. How can I group the data in a way that the output is like this:

origin_id start_date end_date 001 2021-01-01 2021-03-17 004 2021-03-10 2021-03-11 005 2021-03-19

I've tried using group by, but due to sequential_id being auto incremental, it didn't work.

Thanks in advance.

...

Good morning mega-minds! I have a project that I'm creating in ASP.Net Core with Razor Pages that will track development projects that our IT department has made to our Epicor ERP system. I have one Index page that lists Table Names and another that lists data related to a selected name from the first Index page. What I would like to do is have the page title of the second Index page be the selected name from the first Index page. See images below to show what I'm trying to accomplish...

UD Tables

UD Table Data

Here's the code for the 1st Index page...

...

I have a project that I'm creating in ASP.Net Core with Razor Pages. This will track development projects that our IT department has made to our Epicor ERP system. So far, I have links at the top of the main page that opens the corresponding Index pages. These pages pull in data from our SQL Server tables. Two of these pages only have a single column with a list of element names, and I would like to be able to click on any of these names and pass the selected name to another Index page that will show only items for that name. For example, this is a list of UD Tables we've used in our ERP system (see image below)...

I would like for a user to be able to click on any name in this list, let's say the 1st name "UD02", and pass that name to the second Index page (see image below)...

I know you can pass asp-route-id to Details, Edit, and Delete pages, but not sure how to pass a name value to the For Each loop of an Index style page. I have tried passing the name in a similar way...

...

I am running an online store that gets all of it's stock info from an external ERP system. I have a few products that are on backorder, and I want to show the next available date on the product page.

I have access to the ERP system database and all incoming shipment delivery dates, deliveries for a single product would look like this:

product incoming_date incoming ABC123 20210607 34 ABC123 20210621 17 ABC123 20210705 34 ABC123 20210715 17

I also know that for this spesific product I have 59 units on backorder from customers (number is available in the same database, I have control over this and therefore it's just stored as the variable @Backorder (integer) in the following query). I currently have 0 in stock. This means that the first and second shipment is already sold, and the next available date would be 2021-07-05 (third row).

I've been fiddling with this the last couple of hours, but I am unable to find a good solution.

The closest I have come is this:

...

I am trying to move my button on bottom (some pixel above bottom).so it always be in bottom whether it contend is less or large. I tried using flex-box also not able to do that.Container have min-height : 500px

here is my code https://jsbin.com/joyalosate/edit?html,css,output

Expected output :: Explore products move bottom with some pixel above bottom .

...

I Implemented a small ERP system for our kitchen. The system is used to track our groceries, so it contains the goods (referred as food) with its name and UPC code. Over the time the names and upcs started to overlap and creating a data problem. In a first attempt we started to add the manufacturer into the name of the food leafing us with data which looks like this.

Id Foodname 1 Acidophilus;Joghurt 2 Aibler;Rapsöl 3 Allos;Choco Confiserie 4 Alnatura; Dinkel Butterkeks 5 Alnatura; Salatkerne Mix

The names are German, sorry for that. The first part of the name is the manufacturer and the second part is the name of the food. I now introduced a new table called 'Manufacturer' which holds an Id and a Name. The table for the foods was extended by the ManufacturerId field. I want to have the following tables

Manufacturer Id Name 1 Acidophilus 2 Aibler 3 Allos 4 Alnatura 5 Alnatura Food Id Foodname ManufacturerId 1 Joghurt 1 2 Rapsöl 2 3 Choco Confiserie 3 4 Dinkel Butterkeks 4 5 Salatkerne Mix 5

I tried warping my head around a SQL statement which will solve this for me but I couldn't find any solution.

Requiremnts

• Not all entries in the food table already have a manufactuerer assigened. So the query has to filter for item which contain the a ';' in the name. Like

...

What I am trying to do is build a graph in NetworkX, in which every node is a train station. To build the nodes I did:

...

I have a json which is invalid. But still I have to parse by parsing or whatsoever means. Here is the json:

...

I've tried multiple things to get this to run. The intent is to draw circles that users can click. I cannot get anything to paint onto the JPanel. I originally was extending the JFrame but realized I needed to extend JPanel. I'm using IntelliJ GUI Designer for the layout. I would greatly appreciate any help.

...