gambitph / dotc-lto-plate-tracker Goto Github PK

Need to create a shortcode that displays a text input with a search button that initializes an ajax search.

Search results should be displayed inside the search results shortcode within the same page.

They are removing the conduction number from the input. Please remove the column for it, and expect the CSV coming in to have 1 less column

Create a database to store all the data on plugin activation. Database columns:

• received_date - Date
• engine_number - Varchar 50 (index)
• conduction_sticker - Varchar 50 (index)
• unit - Varchar 50

Add an admin page for uploading CSV files similar to Peryahan.

• The data should be inserted in the database (custom table in #2) if it doesn't exist yet.
• Do not allow duplicate entries.
• Do not include lines that do not match the format (in the sample below, the first line shouldn't be included in the database, but sometimes the CSV file may not have this same line 1)

Sample data:

Invoice Date,C.S. No.,Engine No.,Car Model
4/7/2015,EE-8759,D4HBEH125459,Kia Sorento
4/7/2015,EF-1111,G3LAEP192701,Kia Picanto
4/7/2015,EE-8271,G3LAEP095471,Kia Picanto
4/7/2015,EE-5930,D4FDEH530296,Kia Carens
4/7/2015,EE-8770,D4HBEH125847,Kia Sorento
4/7/2015,EF-0172,G4FAES805288,Kia Rio
4/7/2015,EE-8377,D4HBEH124220,Kia Sorento
4/7/2015,EF-1150,G3LAEP193170,Kia Picanto
4/7/2015,EF-0204,G4FAES805509,Kia Rio
4/7/2015,EE-9153,J2703812,Kia K2700
4/7/2015,EE-9766,G4NAEH812097,Kia Sportage
4/7/2015,EF-1151,G3LAEP193168,Kia Picanto
4/7/2015,EF-1084,G3LAEP187369,Kia Picanto
4/7/2015,EF-1148,G3LAEP193154,Kia Picanto
4/7/2015,EE-5238,J3E000260,Kia Carnival
4/7/2015,EF-1149,G3LAEP193166,Kia Picanto
4/7/2015,EF-1191,G3LAEP193118,Kia Picanto
4/7/2015,EE-5977,D4HAEH205746,Kia Sportage