ADA University Senior Design Project Defence Vlog | Diplom Müdafiəsi

本站收录: 2026-05-17

[00:00:01][music] [music] [music] [music] [music] [music] [music] [music] >> Yes guys, this is the people behind the smart car.

[00:04:23]>> [laughter] [music] [laughter] [music] >> Hello. I'm recording our session.

[00:04:47][music] Will it be problem for you?

[00:04:50]Uh recording? Yes. Ah, thank you.

[00:05:10]I think we can start. Yes.

[00:05:14]Uh good morning, everyone. I'm Leyla, and together with my teammates Ramiz, Muzahim, and Lala, we are presenting uh Smart Cargo, intelligent last mile delivery platform specifically designed for Baku, Azerbaijan. Before moving Before moving on to our next slide, you could scan the QR code and get more information about our uh platform and ourselves. So, why Smart Cargo? So, the problem that motivated us is based on the research that uh we conducted a survey, and 68% of people, customers, reported that they suffer from late deliveries. And accordingly, 71% of customers say that they almost get never notification about those delayed packages. 54% of customers miss their deliveries because they are not home and they don't know when the courier will arrive. On the other side, 60% of couriers say that because of the poor routing, they waste their time and fuel on the road.

[00:06:15]We have one answer to all of that problem. Three portals, one platform.

[00:06:19]So, in Smart Cargo, we have admin portal, courier web application, and customer tracking website. Here on admin portals, the dispatchers can manage all the packages and they can assign and track them based on the vehicles and couriers as well. On courier web application, they see the necessary information they need, like their earning information as well as the packages' delivery address, contact information. And customer tracking is a website where the customers do do not need to create an account or download any apps, where they can easily track their deliveries.

[00:06:51]Let's move on to goals that motivated us to build this app for. First goal is the real-time tracking where the couriers are tracked based on their live status.

[00:07:01]Second goal is the traffic-aware routing, which was done with the help of OpenStreetMap, and the routing was done as in the system where the couriers go off path, they will be rerouted and moved according to the new routing.

[00:07:16]Third goal was the unified three portal system where every stakeholder which are engaged in this delivery chain only get the necessary information, minimal information that they need. And the fourth goal is the secure role-based access where we used Auth0 with JWT across all the portals so that all of them only can access their own portals.

[00:07:36]And now my teammate Ramiz will start explaining how we built this application.

[00:07:41]>> Thank you everyone. I'm Ramiz Taghiyev, and now I'll talk about Spark and how Spark application is structured. I will mainly focus on the system architecture.

[00:07:50]Currently, we have three main web portals, admin, courier, and customer.

[00:07:55]They're all built using React JS in order to allow a a responsive user design using components.

[00:08:04]In addition, we use OpenStreetMap in so that we can pull the data or not data in order to use it in our web application.

[00:08:15]Our front end is connected to the back end using REST API endpoints. And each endpoint is a Each endpoint goes through the Auth0 JWT token authentication middleware.

[00:08:33]What that means is that it allows the users the couriers to not have access to the to the admin functionalities. And API sends request to the database and uh pulls the data down.

[00:08:58]This design allows the scalability to our application and uh adding a new layer or an endpoint does not modify any other layers. So, here's our SQL relational database.

[00:09:15]At the core is the packages table, which has a which has package status, GPS coordinates, and the customer information.

[00:09:29]And each package goes through the system.

[00:09:33]Its state is recorded to the package history table. It is a used so that when the time of all time time stamp auditing flow of all deliveries.

[00:09:49]The couriers also have their its own respective table and each courier is assigned to the vehicle.

[00:09:58]While vehicles have their own warehouse which they belong to. And finally have messages table which allow communication between admin and courier.

[00:10:11]And notification in order to allow the in app in app system alerts whenever there is a package delay or delivery cancellation. This MySQL database uses a uses foreign key constraints so that there will be no orphan records or data integrity. Now I give the floor to Zakhim.

[00:10:42]Thank you Ramiz.

[00:10:44]I'm Zakhim and I will talk about the backend logic and optimization path. Optimization.

[00:10:52]First of all I would like to start from our admin panel. Admin panel has dashboard where you can see our performance of all couriers.

[00:11:01]Also top couriers because they rated.

[00:11:04]Each of them has own rating. Also admin can create and modify packages, couriers, warehouses and vehicles.

[00:11:13]Also we have another type of user master admin.

[00:11:18]He can do everything as usual admin but in addition he can create our admins or block them.

[00:11:29]Next Uh, I would like to speak about our courier site. It's the main part of our program. Here we can courier can see the packages which are assigned only to him.

[00:11:42]Uh, and by clicking on the navigation he he can see the map where already optimized.

[00:11:53]I will talk about optimization on the next slide.

[00:11:56]It's updated when courier moves. So, every time we can see the real location and the optimal path by red line. Also, we can navigate and complete our delivery directly from the map. So, after delivery it will move to next point.

[00:12:21]Our program work in six stages or steps.

[00:12:25]It It starts from admins adding the packages to system. At this moment the tracking pin sends to our customers for tracking their order.

[00:12:37]Next stage is opening navigation map by user courier.

[00:12:42]At this moment it sends a request to our backend server which first optimize find the optimized visit sequence. I using distance matrix and to obtain algorithm for determine the optimal visit sequence.

[00:12:57]Next stage is uh calculating optimal path between each two points. And the next stage where backend server response as JSON file which is sequence of coordinates which is showing on the map.

[00:13:14]Why we use OSM and our own optimization optimization algorithm?

[00:13:18]Because optimization is free. We don't send OSM is free. We don't send Uh, per uh, request cost. Uh, also we have control on our algorithm so we can can optimize it, uh, do it better in the future. Uh, now I'm going to say I will keep on talking.

[00:13:40]>> And now I want to talk about the what the customer actually experiences. We also have the customer tracking page and actually when it start when the admin adds the package to the system and the assigned the package to the courier, the system automatically creates the link and it will be sent to the customer via SMS. And when customer click on the SMS, as you can see from the screen, this system opens and five step animated timeline shows on the system and the customer easily track where is package.

[00:14:15]And beside that, in here we have the courier information, detailed information about the packages and etc. But the feature customer but the feature the customers loves the most is that they can select their own delivery time. The that means that they no need to wait for the courier all day. They can select the exact time and take their deliveries at that time. Uh, also they can also put the delivery instruction to the courier. And uh, I want to show you a short video about our results. As my teammates mentioned, as a result we have the three fully worked portals and seven database tables and they all all of them are live and connected and we also have the 16 API endpoints which are secured. And as you can see from the video, we have the we have the a lot of paths. For example, if we have the 10 paths, there will be over the 3 million path options. But when we add the customer preferences, delivery instructions, traffic and etc., the problem is increasing. The manual is solving is not possible. So, there is the smart cargo comes in and solve it with the technology with the high technology with the fastest, cleanest, and the most cost-effective solution for the all businesses in the world.

[00:15:37]And I want to mention that this is the team behind the smart cargo. Maybe it start as a senior design project for all of us, but actually we worked on it as a real product. And at the we want to say thank you for our supervisor John Birds. And thank you all for your attention. If you have any questions, we are ready to take your questions. And you can also scan the our system right now maybe at the beginning.

[00:16:05]Thank you so much.

[00:16:07]>> [applause] >> And you have the codes of admin and courier part at the top of the This is our commercial website. You can see uh What is it?

[00:16:20]>> information about Yes, our uh uh smart cargo platform.

[00:16:25]Uh but for the login page, you can logged in our uh our admin and courier side.

[00:16:34]Okay, I know you guys are all good students. Uh but I have few questions. I have few questions. And the second slide when you had like 68% 72 uh the data from where? Can you like >> Uh yes yes, we have data from uh The total review of the >> We have the We take a survey with the Google Forms. Uh we send it to the people across the Baku because it's firstly designed for the Baku, but we are ready to take scale. Oh, because I I I think I missed the spot or you didn't mention. I just >> Uh I said survey. Ah, so okay. Okay. And for the couriers, we just approach the couriers and ask, "Can you please ask answer our questions?"

[00:17:13]Because like we are in By the way, you should have titles for the table tables and also figures.

[00:17:22]And page numbers, it will be easier to navigate.

[00:17:24]>> Yeah, yeah. For example, for I'm sure like any like even I I see you you guys have figures at the end and then since but you need to refer that for example figure 3.1. I I think this is not the right structure. So, check with John Marlon just to have the right structure.

[00:17:43]Thank you so much.

[00:17:45]And for the login, you said we cannot use we should use already existing customer, right?

[00:17:59]And also side note, you said you're notifying the customer via SMS?

[00:18:03]>> Yes, but this happens when the package add to the system, it will send the notification to the With the SMS for the phone number with the courier. No, no. With the courier, no.

[00:18:15]With the customer. No, the courier I mean like as I said Boxel, some cell companies.

[00:18:19]Are you saying notification alert? Yes.

[00:18:21]When the admin adds the package to the system, the notification will sent to the customer. Via SMS or notification?

[00:18:29]Yes. SMS. So, the question is how you're sending? You're using some phone number, some courier like as I said Boxel. Like you tested that aspect? No, actually we have it's our future feature.

[00:18:38]>> It's a future feature, but as a recommendation, I suggest you use alerting I as an email or mobile phone cuz SMS is pricey. Yes, yes, but like email like maybe most of the people may have not the email. Therefore, Cannot Can they register to your system without an email? Uh like if the customer, yes. He can register without an email? The customer no need to register. Actually, it's our big feature like no need to download the application to create account because right now the customers uh want to take the more steps. So, uh we thought that we should take the easier steps. I missed the first slide, that's why maybe I'm a little bit uh not in this So, your platform, your solution is like you're helping out to other delivery services to speed up without customer knowing, right?

[00:19:29]>> services only, all the businesses we can speed up their uh delivery part. This can be logistic, this can be like food system, etc. market. And we are optimizing their routes because uh we calculate that and with the only the 10 pass, there will be over the uh 3 million pass options and like n factorial. So, uh we uh created the optimization as my example.

[00:19:54]Like when the courier is here uh actually when a courier is on on uh uh send the package I understand that. No, no, no. I understand. I want to understand the business use case. So, as I understand, it's a solution not just for the customer, but for any providers who wants to deliver the package, but he has poor logistic for the delivery, is not enough staff, or he doesn't trust another delivery company, so you provide this logistics for them and the customer actually will not know. It will only know when the courier arrived at his doorstep, opens the door, it's your employee. Actually, uh when our package and you uh delivered to our warehouses, uh automatically uh it's adding to our system and at this moment the customer will know that It's you will be delivering it.

[00:20:37]And this is our biggest feature like the customer customer can track their uh package. Like where is my package and tell select the when which time they want to take their package.

[00:20:47]So So, no need to wait the package all day. How I can act as a customer? So, this is the admin, right? This is the user. Right now, customer uh you cannot act as a customer.

[00:20:57]>> write uh smartcargo.solutions/track and it will open the Track page. Okay.

[00:21:02]Because we we have to add the package to the system, then Do you have some package already existing or not?

[00:21:09]>> Yes, we have the database.

[00:21:13]Okay, I'm there. Okay, I see the default one. As if I input it. Okay.

[00:21:19]It's cool. We have a poor logistics in our country. We got deliveries. It's all busy. And we have a lot of traffic and we add our database that school information like the public traffic hours, holiday days, weather APIs and etc. So, with that that we created most optimal path for the couriers.

[00:21:41]Like it creates the efficiency of the companies. Also make the happy customers.

[00:21:48]Do you have another question?

[00:21:50]I have just one question. From the technical side.

[00:21:54]Which database have you used? MySQL.

[00:21:56]Why?

[00:21:58]I mean, it's just a question. Why specifically this database? It's uh price. It's uh cheaper than other. Okay. And uh it's kind of good integration with Go.

[00:22:10]Because our server run on Go. Okay.

[00:22:14]Yeah, that's a good answer. If you're going to say we are comfortable to use that, I'm not going to accept this. Good luck.

[00:22:19]>> yes. And yes, we are we have the experience with the MySQL. Yes, and our Yeah, good one. That's the most reliable DB to use. And the architecture, where you have set it up?

[00:22:31]The cloud?

[00:22:32]Google Cloud. Yes, John Burns provided Provided Ah, yeah, yeah. Okay, good. No questions. No more. Good.

[00:22:41]Thank you so much.

[00:22:42]>> Thank you.

[00:22:42]All right.

[00:22:43]>> [applause] >> I'm sorry.

[00:23:00]Sure.

[00:23:03]We are here. Hello. Um, they can take up on this end.

[00:23:25]Are the people the opposite of you? I don't know what you're doing.

[00:23:34]They they they'll show to their children in the future for the same thing.

[00:23:38]>> [laughter] >> Technology.

[00:23:53]Rami.

[00:23:58]I don't know what you're saying. I don't know what you're saying. I don't know what you're saying.

[00:24:18]Hello. [laughter] Hello.

[00:24:31]>> [laughter] [laughter] >> Mhm. Some people are like It's too much to do.

[00:25:06]Follow her to my reporting reporting is a methodology You're not putting I didn't follow you.

[00:25:18]I don't know what I'm talking about.

[00:25:21]I must have Have a lot of me.

[00:25:25]All done. Let's start it.

[00:25:27]So they put an ID Some taxi driver How to talk to you?

[00:25:34]I don't know that stuff. I don't know that stuff. I don't know that stuff. I don't know that stuff. I don't know that >> I don't know that stuff.

[00:25:39]I don't know that stuff.

[00:25:40]I don't know I don't know I don't know I don't know I don't know I don't know I don't I don't I don't I don't know that stuff.

[00:25:57]I don't know that stuff.

[00:25:59]I don't know that stuff.

[00:26:02]I don't know >> [screaming] >> I don't I don't know I don't know that stuff.

[00:26:12]I don't know that stuff.

[00:26:22]I don't know that stuff.

[00:26:30]I don't know that stuff.

[00:26:35]I don't know that stuff. I don't know that stuff. I don't know I don't know that stuff. I don't know that stuff. I don't know that stuff. I don't know that stuff. I don't know that stuff.

[00:26:47]I don't know that I don't know that stuff.

[00:26:53]I don't know I know.

[00:26:55]What are you You have to Cinderella That already I'll tell you I'll tell you I'll tell I'll tell you I'll tell you something.

[00:27:26]But I don't know if I don't You tell I'm eager to learn more.

[00:27:38]I am eager to grow professionally in this team. And learn continuously.

[00:27:44]>> [laughter] >> I don't know if I don't I don't know if I don't I don't I don't >> [laughter] >> I don't I don't I don't I don't I don't know if I can I don't >> [laughter] >> I don't I don't I don't I don't I don't I don't I don't I don't I don't I don't >> [laughter] >> I don't I don't I don't I don't I don't I don't I don't >> [laughter] >> I don't know if I can I don't I don't know if I can I don't I don't I don't I don't know if I'm going to get it.

[00:28:58]I'LL TURN IT OFF.

[00:29:01]>> [applause] >> I GOT IT. I GOT IT.

[00:29:05]THINGS I DIDN'T I CAN SURVIVE THIS.

[00:29:08]What are the I don't want to bug them.

[00:29:11]>> [laughter] >> That's all good. I got it.

[00:29:13]I'll have to go.

[00:29:16]I got it. I got it.

[00:29:18]I got it. I got it. I got it.

[00:29:21]I got it.

[00:29:22]I got it.

[00:29:25]I got I got it.

[00:29:28]>> [crying] >> I got it.

[00:29:32]I got it. I got it. I got it.

[00:29:34]I got it.

[00:29:37]I got it.

[00:29:38]I got it.

[00:29:39]I got it. I got it. I got it.

[00:29:42]I got it.

[00:29:44]I got it.

[00:29:45]I got it.

[00:29:46]I got it.

[00:29:47]I got it. I got it. I got it. I got it.

[00:29:49]I got it.

[00:29:50]I got it.

[00:29:52]I got it.

[00:29:53]I got it.

[00:29:54]I got I got it.

[00:29:57]I got it.

[00:29:59]I got it.

[00:30:00]I got it.

[00:30:01]I got it.

[00:30:03]I got it. I got it.

[00:30:05]I got it.

[00:30:05]I got it.

[00:30:07]I got it. I got it.

[00:30:09]I got it. I got it.

[00:30:11]I got it.

[00:30:13]I got it. I got it.

[00:30:16]I got it.

[00:30:17]I got it.

[00:30:19]I got it. I got it.

[00:30:21]I got it. I got it.

[00:30:24]I got it.

[00:30:25]I got it. I got it.

[00:30:28]I got it.

[00:30:31]I got it.

[00:30:32]I got it.

[00:30:34]I got it. I got it.

[00:30:37]I got I got it. I got it.

[00:30:40]I got it.

[00:30:42]I got it.

[00:30:43]I got it. viable product design project fully worked So, product data responsibility my manager Keep pushing.

[00:31:28]Come and get it.

[00:31:30]Come and get it.

[00:31:33]Pay me 100% actually be perfect water coffee chocolate Also, I love you.

[00:31:47]I love you too. reward system home cafe I like you.

[00:31:54]chocolate on the top Kimbra Kimbra is getting I took a picture of the manager while you were there.

[00:32:08]>> [laughter] >> The flash alarm.

[00:32:12]This whole hazard We got a new product charger in the on product.

[00:32:16]>> [laughter] >> In the on product charger again.

[00:32:21]Get in the product Just because I love you.

[00:32:25]Put the croissant in the oven.

[00:32:27]This is the view.

[00:32:29]My daughter says in the deadline on There is no good stuff I see them.

[00:32:35]Um, this one This semester by channel guru in the kitchen instruction that I want to make it South Channel of MMA on the moon other catch me if you are there final time >> [laughter] >> I'm a death also okay.

[00:33:45]work life balance >> [music] >> I'm not feeling hahaha >> [music] [music] [music] >> Oil control papers.

[00:35:01]>> [music and singing] >> Wow.

[00:35:11]>> [music] [singing] [music] [music] [music] [music] [music]