[embodiment]
As shown in Figure 1, be the Organization Chart of the interactive Cargo Tracking System of the present invention.This system architecture comprises aninternal network 10, one first database server 1, one first database 2, one second database server 3, onesecond database 4, a plurality of seller'scomputing machine 5, the seller'sweb page server 6 that is positioned at sell side, and is positioned at aninternet 7, shipping company'sweb page server 8, a plurality of buyer's computing machine 9 of enterprise outside.This shipping company'sweb page server 8 is positioned at shipping company's end, and the goods of supporting sell side to hold to the buyer transports relevant information to be provided.These a plurality of buyer's computing machines 9 are positioned at buyer's end, import cargo information for the buyer, and carry out following the trail of on the line goods.This seller'sweb page server 6 connects first database server 1, second database server 3 and a plurality of seller'scomputing machine 5 byinternal network 10, and connects shipping company'sweb page server 8 and a plurality of buyer's computing machine 9 by internet 7.This first database server 1 connects one first database 2.This second database server 3 connects one second database 4.Seller'sweb page server 6 can be by visit and access first database 2 andsecond database 4, the related data processing capacity that provides a plurality of seller'scomputing machines 5 and 9 shipment of buyer's computing machine to follow the trail of.In addition, this also addressable shipping company of seller'sweb page server 6web page server 8 is followed the trail of the webpage function by the shipping that shipping company'sweb page server 8 is provided, and convenient a plurality of seller'scomputing machines 5 and buyer's computing machine 9 carry out shipping tracking in transit.
As shown in Figure 2, be the functional module associated diagram of the interactive Cargo Tracking System of the present invention.First database server 1 comprises first database module 11, included a plurality of first data 21 in its addressable and access first database 2.These a plurality of first data 21 records are non-to be gone out/the on-the-spot related data of receiving, and its content comprises purchase order number, Description of Goods, quantity of goods, shipping quantity, follow the trail of number, estimated time of arrival, the number of receiving, place of receipt.Wherein, purchase order number, Description of Goods, quantity of goods, place of receipt are provided by the buyer of buying.Following the trail of number is provided by shipping company, as the voucher of logining shipping company's webpage.The number of receiving is provided when receiving by this buyer; This number of receiving is that the goods that transports according to different batches produces different codings, and this coding rule is admitted mutually that by the seller and the buyer it can be used as the voucher that affirmation is received.Then all the other contents are provided by the seller.This purchase order number also as with the related foundation of second data 41.
Second database server 3 comprises second database module 31, included a plurality of second data 41 in its addressable and access second database 4.These a plurality of second data 41 write down out/receive on-the-spot related data, and its content comprises shipment day, actual shipping Qty., actual receipts quantity, pallet number, unloading stack plate quantity, the pallet quantity of receiving, pallet state, pallet record modification day and purchase order number.Wherein, shipment day, actual shipping Qty., pallet number, unloading stack plate quantity are provided by the seller's shipment scene, and actual receipts quantity, the pallet quantity of receiving are provided when receiving by the buyer.Pallet state, pallet record modification day can be provided by the seller's the shipment scene or the buyer.Wherein, this purchase order number as with the related foundation of first data 21.The pallet recording mechanism is followed the trail of interface module 61 by shipment and is produced automatically.Revise the Japanese record seller or the buyer at last and change date of this pallet record 512 at last.The pallet state then comprises in the shipping and has received two states.
Seller'sweb page server 6 comprises shipment tracking interface module 61, a shipment tracing module 62, a shipment history display module 63, a shipment mistake display module 64 and a database link block 65.Interface module 61 is followed the trail of in shipment can provide seller'scomputing machine 5 and 9 one shipment of buyer's computing machine to follow the trail of interface 51.This shipment is followed the trail of interface 51 and is built in the technical of webpage basis, it provides the function choosing-item of shipment tracking, shipment history display and the demonstration of shipment mistake to the seller user and the buyer, and corresponds to above-mentioned shipment tracing module 62, shipment history display module 63 and shipment mistake display module 64.In addition, shipment is followed the trail of interface 51 function of searching also is provided, and it can be imported information such as purchase order number and search and show the shipment record.This shipment tracing module 62 can show the shipment record of not receiving, and be presented at shipment follow the trail of on the interface 51 with carry out tracking in transit, pallet is inspected, and provides the buyer definite function of receiving.This shipment record is made up of the content that described first data 21 and second data 41 are comprised.Shipment history display module 63 can be followed the trail of the shipment record that demonstration has been received on the interface 51 in shipment.Shipment mistake display module 64 can be followed the trail of on the interface 51 in shipment and show that vicious shipment record, its mistake comprise and exceed the time limit not to, the discrepancy of quantity etc. of receiving.This shipment tracing module 62, shipment history display module 63 and shipment mistake display module 64 connect first database 2 andsecond database 4 by database link block 65, with access first data 21 and second data 41.Interface module 61 is followed the trail of in this shipment also can connect the shipping Web page module 81 that shipping company'sweb page server 8 is comprised byinternet 7, so that the buyer and seller user follow the trail of the position in transit of goods.
As shown in Figure 3, follow the trail of shown data field position content graph and the shipment tracing module content graph in interface for the shipment of the interactive Cargo Tracking System of the present invention.
The function choosing-item that interface 51 provides shipment tracking, shipment history display and shipment mistake to show is followed the trail of in shipment, and can show that corresponding shipment record 511 is on seller'scomputing machine 5 or buyer's computing machine 9.This corresponding shipment record 511 is denoted as the shipment record of not receiving, the shipment record of having received, vicious shipment record because of its field data is different.Field data in this shipment record 511 is made up of the content of first data 21 and second data 41, and its field comprises shipment recording mechanism (NO1.), purchase order number (PO NO.), Description of Goods (MATERIAL), quantity of goods (QTY), shipment day (SHIP DATE), shipping quantity (SHIP QTY), actual shipping Qty. (ASQ), actual receipts quantity (ARQ), follows the trail of number (TRACK NO.), estimated time of arrival (ETA DATE), the number of receiving (RECEIVE NO.) and place of receipt (SHIP TO).Wherein, the shipment recording mechanism is followed the trail of interface module 61 by shipment and is produced automatically, and can come association to obtain Description of Goods, quantity of goods, place of receipt, tracking number and the number of receiving of first data 21 and shipment day, actual shipping Qty. and the actual receipts quantity of second data 41 by purchase order number.
At shipment tracking function option, the subfunction option that interface 51 also provides tracking in transit, pallet to show and receive and confirm is followed the trail of in shipment.Therefore, shipment tracing module 62 comprises that a tracking secondary module 621 in transit, a pallet show that secondary module 622 and is received and confirm that secondary module 623 is with to should the subfunction option.Finish tracking subfunction in transit by clicking tracking number (TRACK NO.) field of shipment record 511, it will be connected to shipping company's webpage that shipping company provides by tracking secondary module 621 in transit.This shipping company is the company of the acceptance of goods, it can follow the trail of carrier (as lorry, aircraft, the ship etc.) position of this goods of carrying by science and technology (as satellite positioning tech or wireless communication technique), and its positional information is shown on shipping company's webpage, so that the seller or the buyer number carry out tracking in transit by following the trail of.
Finish pallet and inspect subfunction by clicking shipping quantity (SHIP QTY) field, interface 51 is followed the trail of in shipment will show that secondary module 622 produces one or more pallet records 512 in order to inspecting by pallet.Field data in this pallet record 512 is provided by second data 41, and it comprises pallet recording mechanism (NO2.), pallet number (PACK NO.), unloading stack plate quantity (PACKQTY), the pallet quantity of receiving (RECEIVE QTY), pallet state (STATUS), revises day (a LAST EDIT DATE) at last.
The buyer user of buyer's computing machine 9 finishes the affirmation subfunction of receiving by clicking shipment recording mechanism (NO1.) field.Interface 51 is followed the trail of in shipment will confirm that secondary module 623 produces one and receives and confirm that record 513 imports related data in order to buyer user by receiving.The field of this record 513 comprises purchase order number (PO NO.), Description of Goods (MATERIAL), quantity of goods (QTY), shipment day (SHIP DATE), shipping quantity (SHIP QTY), follows the trail of number (TRACK NO.), the number of receiving (RECEIVE NO.).The wherein number of receiving (RECEIVE NO.) field initial value is blank; After treating that the buyer confirms to receive, buyer user can import the number of receiving thereon, and this number of receiving will be recorded in second data 41 ofsecond database 4.
As shown in Figure 4, be the shipment record sort logic determines process flow diagram of the interactive Cargo Tracking System of the present invention.This sorted logic is judged the shipment record that comprises 62 judgements of shipment tracing module and do not receive, the shipment record that 63 judgements of shipment history display module have been received, the classification process that shipment mistake display module 64 is judged vicious shipment record.Its flow process comprises that the user passes through seller'scomputing machine 5 or interface 51 is followed the trail of in the 9 operation shipment of buyer's computing machine, also comprises:
(a) read in first data 21 (step S10) of first database 2;
(b) read in second data 41 (step S11) of second database 4.Can obtain the required information of shipment record 511 by step S10 and step S11;
(c) whether the number of the receiving field of judging this shipment record 511 is empty (step S12).If empty, represent that this number of receiving is zero, then meets step S16 down; If this number of receiving is non-vanishing, then meet step S13 down;
(d), judge by the shipment tracing module whether system time has exceeded the estimates and arrive at the date (step S13) according to the estimated time of arrival field of this shipment record 511.This system time is provided by seller'sweb page server 6, it comprise the date, the time, minute, second, be the interior time of operating system that is set in seller's web page server 6.If yes, expression has exceeded the estimates and has arrived at the date and also do not receive, and meets step S14 down.If, do not meet step S15 down;
(e) this shipment record 511 is denoted as vicious shipment record (step S14), and is shown on the shipment tracking interface 51.(c), (d), (e) judge flow process for first of shipment mistake display module 64;
(f) this shipment record 511 is denoted as the shipment record (step S15) of not receiving, and is shown on the shipment tracking interface 51.(c), (d), (f) are the judgement flow process of shipment tracing module 62;
Whether (g) the relatively actual shipping Qty. field of shipment record 511 and the quantity in the actual receipts amount field identical (step S16) if yes, meet step S17 down; If, do not meet step S18 down;
(h) this shipment record 511 is denoted as the shipment record (step S17) of having received, and is shown in shipment and follows the trail of on the interface 51, (c), (g), (h) be the judgement flow process of shipment history display module 63;
(i) this shipment record 511 is denoted as vicious shipment record (step S18), and is shown in shipment and follows the trail of on the interface 51, (c), (g), (i) judge flow process for second of shipment mistake display module 64;
Fig. 5 is the process flow diagram of the interactive cargo tracking method of the present invention.This flow process comprises:
The buyer sends a purchase order and gives the seller (step P10).
The seller decomposes purchase order and becomes basic document (step P11).This basic document comprises purchase order number, Description of Goods, quantity of goods, place of receipt.
The seller is recorded in basic document in first data 21 (step P12).Except that this, the seller also according to the relevant information of prearranging shipment comprise shipping quantity, follow the trail of number, estimated time of arrival is recorded in first data 21.
Shipment same day, the seller's shipment scene is recorded in a shipment information in second data 41 (step P13).Shipment information comprises shipment day, actual shipping Qty., pallet number, unloading stack plate quantity, pallet state and pallet record modification day.
Seller's shipment (step P14).
In goods in transit in, the seller or the buyer can follow the trail of the tracking function in transit that interface 51 provides by shipment, are connected to shipping company's webpage and come tracking progress (step P15).
The buyer receive in the scene of receiving (step P16).
The buyer follows the trail of interface 51 at the scene of receiving by shipment and receives data logging in first data 21 and second data 41 (step P17) with one.This data of receiving comprises the number of receiving, actual receipts quantity, the pallet quantity of receiving, pallet state, pallet record modification day.
The seller sends gathering invoice (step P18) according to the data of receiving with facsimile recorder, electronic data interchange or alternate manner.
The buyer is according to gathering invoicing payment (step P19).