Styjun

Impossible darts scores

Find the C-factor of a vote

Are all instances of trolls turning to stone ultimately references back to Tolkien?

Find the diameter of a word graph

Change boolean value in QGIS by CASE WHEN

Swapping rooks in a 4x4 board

Can Ogre clerics use Purify Food and Drink on humanoid characters?

Links to webpages in books

Employer wants to use my work email account after I quit

Should developer taking test phones home or put in office?

Grep pipe support and how to filter grep results

How was Hillel permitted to go to the skylight to hear the shiur

Hot coffee brewing solutions for deep woods camping

Can someone suggest a path to study Mordell-Weil theorem for someone studying on their own?

A STL-like vector implementation in C++

How long would it take to cross the Channel in 1890's?

How would modern naval warfare have to have developed differently for battleships to still be relevant in the 21st century?

Why do all the teams that I have worked with always finish a sprint without completion of all the stories?

What's currently blocking the construction of the wall between Mexico and the US?

Is it illegal to withhold someone's passport and green card in California?

Find the probability that the 8th woman to appear is in 17th position.

Can White Castle?

Applicability of Lagrange Multipliers in the analysis of large-scale MILPs?

Did Karl Marx ever use any example that involved cotton and dollars to illustrate the way capital and surplus value were generated?

Digital Freight Marketplace

Random string generation with upper case letters and digitsDjango based marketplace, creating a transaction historyDoes “d” in regex mean a digit?Simple Digit Recognition OCR in OpenCV-PythonDjango re-usable Marketplace appDjango DecimalField generating “quantize result has too many digits for current context” error on saveUploading images in Django fails in production on digital oceanPython Django 2.0 DecimalField “Ensure that there are no more than 3 digits before the decimal point”Allocation algorithm using PythonHow to match two databases in python django

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

1

I am trying to create a model in which manufacturers can post a shipment which needs to be transported and transporter can post that his truck is going from point A to point B. If the Origin, Destination, and load(to be transported and truck capacity) matches then both of them are notified a match.

I have tried researching on automatic matching but the closest I come to is the Hungarian Algorithm that solves the assignment problem, but I am not so sure if it's the right direction or not.

In the model, I have already created input forms for both sections i.e. manufacturers and transporters and the data is saved in a Database. I am thinking of applying a trigger function which rechecks for the best match every time when a new entry comes in Database

Here is the Data from both input forms:

Manufacturer

M_ID From To M_Type T_Type T_Length T_Weight #Trucks Loading_Time
1025 A B Boxes Open 12-Tyre 22 3 27-March-2019 6:00PM
1029 C D Cylinders Trailer HIGH 23 2 28-March-2019 6:00PM
1989 G H Scrap Open 14-Tyre 25 5 26-March-2019 9:00PM

Transporter

T_ID From To T_Type T_Length T_Weight #Trucks Price
6569 A B Open 12-Tyre 22 5 1500
8658 G H Open 14-Tyre 25 10 1200
4595 A B Open 12-Tyre 22 3 1000
1252 A B Trailer Low 28 5 1800

We can see that Transporter 4595 is the best match for Manufacturer 1025 and Transporter 6569 is the second best. I want to match both of them and also show the manufacturer that he has another option too.

python django django-models transport

share|improve this question

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges

add a comment | 

1

1

I am trying to create a model in which manufacturers can post a shipment which needs to be transported and transporter can post that his truck is going from point A to point B. If the Origin, Destination, and load(to be transported and truck capacity) matches then both of them are notified a match.

I have tried researching on automatic matching but the closest I come to is the Hungarian Algorithm that solves the assignment problem, but I am not so sure if it's the right direction or not.

In the model, I have already created input forms for both sections i.e. manufacturers and transporters and the data is saved in a Database. I am thinking of applying a trigger function which rechecks for the best match every time when a new entry comes in Database

Here is the Data from both input forms:

Manufacturer

M_ID From To M_Type T_Type T_Length T_Weight #Trucks Loading_Time
1025 A B Boxes Open 12-Tyre 22 3 27-March-2019 6:00PM
1029 C D Cylinders Trailer HIGH 23 2 28-March-2019 6:00PM
1989 G H Scrap Open 14-Tyre 25 5 26-March-2019 9:00PM

Transporter

T_ID From To T_Type T_Length T_Weight #Trucks Price
6569 A B Open 12-Tyre 22 5 1500
8658 G H Open 14-Tyre 25 10 1200
4595 A B Open 12-Tyre 22 3 1000
1252 A B Trailer Low 28 5 1800

We can see that Transporter 4595 is the best match for Manufacturer 1025 and Transporter 6569 is the second best. I want to match both of them and also show the manufacturer that he has another option too.

python django django-models transport

share|improve this question

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges

add a comment | 

I am trying to create a model in which manufacturers can post a shipment which needs to be transported and transporter can post that his truck is going from point A to point B. If the Origin, Destination, and load(to be transported and truck capacity) matches then both of them are notified a match.

I have tried researching on automatic matching but the closest I come to is the Hungarian Algorithm that solves the assignment problem, but I am not so sure if it's the right direction or not.

In the model, I have already created input forms for both sections i.e. manufacturers and transporters and the data is saved in a Database. I am thinking of applying a trigger function which rechecks for the best match every time when a new entry comes in Database

Here is the Data from both input forms:

Manufacturer

M_ID From To M_Type T_Type T_Length T_Weight #Trucks Loading_Time
1025 A B Boxes Open 12-Tyre 22 3 27-March-2019 6:00PM
1029 C D Cylinders Trailer HIGH 23 2 28-March-2019 6:00PM
1989 G H Scrap Open 14-Tyre 25 5 26-March-2019 9:00PM

Transporter

T_ID From To T_Type T_Length T_Weight #Trucks Price
6569 A B Open 12-Tyre 22 5 1500
8658 G H Open 14-Tyre 25 10 1200
4595 A B Open 12-Tyre 22 3 1000
1252 A B Trailer Low 28 5 1800

We can see that Transporter 4595 is the best match for Manufacturer 1025 and Transporter 6569 is the second best. I want to match both of them and also show the manufacturer that he has another option too.

python django django-models transport

share|improve this question

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges

M_ID From To M_Type T_Type T_Length T_Weight #Trucks Loading_Time
1025 A B Boxes Open 12-Tyre 22 3 27-March-2019 6:00PM
1029 C D Cylinders Trailer HIGH 23 2 28-March-2019 6:00PM
1989 G H Scrap Open 14-Tyre 25 5 26-March-2019 9:00PM

T_ID From To T_Type T_Length T_Weight #Trucks Price
6569 A B Open 12-Tyre 22 5 1500
8658 G H Open 14-Tyre 25 10 1200
4595 A B Open 12-Tyre 22 3 1000
1252 A B Trailer Low 28 5 1800

share|improve this question

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges

share|improve this question

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges

asked Mar 25 at 8:59

Yantra LogisticsYantra Logistics

9655 bronze badges