parcel-track | Parcel Tracker Packagist for Local Malaysia Parcel Courier | REST library
kandi X-RAY | parcel-track Summary
kandi X-RAY | parcel-track Summary
Simple Parcel Tracker for Local Parcel Courier. Basically it just crawl the courier website or existing API. Need time to time to monitor web/api changes before failure happen. BTW, Currently available (Successfully Scraped). Tested in PHP 7.1 Only.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Start the crawl
- Get the process .
- Get the courier
- Create footer array
- Builds the response .
- Remove all null values .
- Fetch data from source
- Get the header
- Set Tracking Number
- Set the base url .
parcel-track Key Features
parcel-track Examples and Code Snippets
Community Discussions
Trending Discussions on parcel-track
QUESTION
Long time lurker, first post.
The company I work for has a parcel-tracking software that we sell to our customers. It uses SQL-database to store the data. And to create reports for the parcels devliery times and other stuff, like exceptions, costs, signatures, we use crystal reports.
One of our customers would like a SLA report, where they want to track the time between a certain location to the time where is has been delivered.
The formula must contain:
- Package Status, in this case it's LOCSCAN
- Package Location, it's X-ray
- And the time that is has been scanned to that location.
I have all the data in the SQL-database, but I cant figure out the formula for this.
EDIT:
A brief description of the workflow:
- The parcel arrives at the site. They scan it in to the system, thus gets an received date/time, location:Goods and status: RECEIVED.
- After that they put the parcel trough a x-ray scanner, so it doesnt contain any illegal stuff. Scans the parcel with the new status: LOCSCAN, location:X-ray and a new date/time.
- After that, they deliver the parcel, to the receiver, and gets status: DELIVERED with a new date/time.
- All the date/time fields are seperated from eachother, stored in individual columns, dependent on the status of the parcel.
Im using Crystal Reports, where im trying to create the formula.
...ANSWER
Answered 2018-Sep-07 at 15:06Use the datediff function:
datediff('d', {startingdate}, {endingdate})
First a formula for RECEIVED to LOCSCAN and then LOCSCAN to DELIVERED if I'm understanding correctly.
The 'd' stands for days, you can replace with 'h' for hours or 's' for seconds. The fields between {} are the ones from database.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install parcel-track
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page