SQL Queries in Python

Κλειστό Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

My website is a big data analytics tool, scanning over 100 Million lines of data for every query.

Now I want you to refine my search by adding further SQL commands.

The search is written in Python and based on Elastic Search.

The website is built on Symfony.

THE JOB IN DETAIL:

1. add premade navigation bar and link content

at page bottom, fixed, z-index above all website content link content of search bar

2. add pagination

10 search results per page. Enough pages to show all results. “<” and “>” jump two pages.

3. revise search process

Country Selection

If a country is selected, only show search results of shipments which list that country in

the column “Country”. If USA is selected, show all search results.

words from multiple columns

When searching for multiple words, like for example: “the north face” + “tent”, show all search results that have all words in the columns “Consignee Name”, “Shipper Name” and “Product Desc”. Allow the words to be found in different columns. In the example above “the north face” could be found in “Consignee Name”, and “tent” in “Product Desc”.

4. revise website

delete previous search field. Scale down the height of the top navigation’s background to just underlay the links.

Elasticsearch Python SQL Symfony PHP

Ταυτότητα Εργασίας: #17343408

Σχετικά με την εργασία

3 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

3 freelancers κάνουν προσφορές κατά μέσο όρο $57 για αυτή τη δουλειά

DarkKnight2206

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

$50 AUD σε 2 μέρες
(23 Αξιολογήσεις)
5.1
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . Relevant Skills and Experience 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle ( Περισσότερα

$61 AUD σε 10 μέρες
(0 Αξιολογήσεις)
0.0