Add few minor functions to existing site -- 4

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado Pagado a la entrega

Hello,

Site: [url removed, login to view]

Queries are like:

$games = ORM::for_table('games')

->table_alias('g')

->select('g.*')

->select('[url removed, login to view]', 'league_name')

->select('[url removed, login to view]', 'home_team_name')

->select('[url removed, login to view]', 'away_team_name')

->left_outer_join('leagues', 'g.league_id = [url removed, login to view]', 'l')

->left_outer_join('teams', 'g.home_team_id = [url removed, login to view]', 'ht')

->left_outer_join('teams', 'g.away_team_id = [url removed, login to view]', 'at')

->where('id', $id)

->find_array();

What need to be done,

1. Index to: Featured games mixed from both DBs - tennis and soccer and ordered by GMT.

Now is: Query Soccer -> Display, Query Tennis -> Display

To be: Query Tennis + Query Soccer -> Merge results and Sort by start_time -> Display sorted

2. Index to: Have a simple .php which is checking: Is there X games/per sport featured games on Index? If not auto-change Featured from 0 to 1 to fill up to X games, on games where Best Odds are from diff bookies /there is written function for this/. E.g. check if there are enough games marked as Featured, if not - mark some

So by this always to have featured games on Index

Include word "spesse" into bidding, otherwise your bid will be ignored.

3. Compare and match names: In DB players are with their full names:

Like: Aleksandra Wozniak

But same bookie could write it, Aleksandra Wozniak, A Wozniak, Al Wozniak, Wozniak, A. Wozniak or Al. Wozniak

E.g. Just code for matching names. Code for create/update game is existing.

4. Adding a timestamp to Odds table - on time of creation or updating and then on Showing games on Index or other places - if timestamp if <X minutes - add text "Outdated Odd" and then Odd

e.g. Add additional field in DB and implement it in 3 code files for inserting and showing.

PHP

Nº del proyecto: #11800641

Sobre el proyecto

4 propuestas Proyecto remoto Activo hace 7 años

4 freelancers están ofertando un promedio de $64 por este trabajo

hyadesfreelancer

PHP,PDO, Core-php, CakePHP, CodeIgniter, Laravel, Yii, Mysql, HTML, HTML5, CSS, JavaScript, Angular js, jquery, AJax, Joomla, E-Commerce Wordpress, Woo-commerce, Open-cart And BUG FIXING etc. When we work for clie Más

$30 USD en 0 días
(7 comentarios)
2.7
Amitjn55

Hi there, An experienced team of Designers & CorePHP, Magento, Wordpress (Woocommerce) Developers here to assist you. Please feel free to contact us anytime to discuss your project. We look forward to working w Más

$25 USD en 2 días
(4 comentarios)
2.2