Adding custom data to Django's admin dashboard

Question

I'm having a bit of trouble with Django again.

I have a simple e-commerce website project that I'm working on for my graduation. It sells books. I've got basic functionalities down, such as adding categories and products, client sign-ups and logins, a session-based shopping cart, a checkout page fully connected to a payment API, and an orders model to keep track of data.

My professor has asked me now to to add relevant reports in the Admin panel, talked to me a while about what would be relevant to see and all. So, I've got in mind what I'm hoping to make.

I want to have two containers in the main dashboard page, which would display some quick analytics (like, how many books the store has sold in the past seven days, how much money from sales the site has made in the past month), as well as links in the sidebar: I want each relevant app within my project to have their own reports section in the Admin panel, maybe led to from a link underneath their models. I've separated the storefront, accounts, orders, shopping cart, and checkout, for instance, in different apps

The problem is I can't really figure out how to actually... do that...

I've fiddled with the layout and templates on the admin; I've figured out how to add custom links to the admin page, and change its design elements, for instance. But I'm not sure how to link the data I want to the dashboard. It feels like the answer is right in front of me and I can't reach it...

I guess my question is, how can I add my reports to the Django admin page per app, and how can I add these containers that I want in the dashboard?

I've guessed that I have to start out by building a view for each report. So I am currently reading the Django docs on the Admin page again, as well as looking at questions similar to mine.

But any information y'all can share that could ease up this process and save me some time would be very much appreciated. Thanks so much!

PS: If it helps, I am overriding the admin templates by having all the .html pages copied on my project's templates folder - it's how I got it to display the store's header in the admin dashboard.

Answer 1

You need to convert the date to mm/dd/yyyy format from dd/mm/yyyy so that JS can understand it properly

orders.map(order => {
  const parts= order.date.split("/")
  return new Date(`${parts[1]}/${parts[0]}/${parts[2]}`).getTime()
})

Answer 2

You cannot count on the default date parser to parse your DD/MM/YYYY format correctly. Parsing date strings through the constructor in this way is highly discouraged because it is implementation-dependent. Different browsers/runtimes will parse dates differently.

Instead, manually parse the date yourself and then construct the date object:

orders.map(order => {
  const [d, m, y] = order.date.split('/');
  return +new Date(+y, m-1, +d);
})

Answer 3

Friendly reminder: do you have a sorting functionality yet? .map is just an iteration through your array.

More about map: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/map

Add a sort function based on your date(properly parsed) property and return a new array would help.

Answer 4

The dates are in the wrong format:

// from: "21/08/2020"
let format = obj.date.split('/').reverse().join('-')
//   to: "2020-08-21"

In order to be sortable, dates must be in ms since Jan 1, 1970. Assign the new value to a new key:

obj.pDate = Date.parse(format);

Sort by the new key/value:

let results = orders.sort((a, b) => a.pDate = b.pDate)

Then remove all of the new key/values:

results.map(order => delete order.pDate)

const data = [{
    "order_id": 1,
    "customer": "Karita Klimochkin",
    "country": "Sweden",
    "address": "8978 Westridge Park",
    "product_title": "Yellow-bellied marmot",
    "product_description": "Bread - Flat Bread",
    "date": "21/08/2020",
    "status": "Delivered"
  },
  {
    "order_id": 2,
    "customer": "Ferne Roman",
    "country": "China",
    "address": "1370 Ridge Oak Pass",
    "product_title": "Two-toed sloth",
    "product_description": "Asparagus - White, Fresh",
    "date": "24/07/2020",
    "status": "Completed"
  }, {
    "order_id": 3,
    "customer": "zer00ne",
    "country": "US",
    "address": "123 Main St",
    "product_title": "Jackalope",
    "product_description": "Chili Cheese Fries",
    "date": "12/05/2020",
    "status": "Delivered"
  },
];

const sortOrders = orders => {
  let result = orders.sort((a, b) => {
    a.pDate = Date.parse(a.date.split('/').reverse().join('-'));
    b.pDate = Date.parse(b.date.split('/').reverse().join('-'));
     return a.pDate - b.pDate;
  })
  result.map(order => delete order.pDate);
  return result;
};

console.log(sortOrders(data));