Concluído

Projects/Kpis Execute

We have many queries to execute daily and we want to automate this job. We want to register project and them to register kpis for each project.

With login/password, we want a list of all projects, them click in "Details" and see all Kpis for this project and click in "execute" it will show the result of this query from database.

The system needs to have one account/password for mysql only, we will give grants for the main user on our production environment.

Models Suggest:

CRUD Projects (id, name, description)

CRUD Kpis (id, name, description, query, created, updated, project_id)

You can change database model and column names if you need or if you want to do that.

One project has zero or many Kpis

More explanation

The user need to put login/pass (just one hard-coded login/pass at this moment), the system will show projects list (screen projects list), click on project, and the system will show kpis list per project (screen kpis list)

The user need to create project and after add kpis to this project.

I prefer it developed using Cake PHP, a framework that we already use in our company.

Example of Queries that we use

-- contas que nunca logaram (Você criou conta e nunca logou, posso te ajudar? Sabia que o lucera evoluiu?)

-- contas que já logaram 1x (Hey, você que já jogou o Lucera, sabia que ele evoluiu?)

-- contas que compraram algo no shopping (Vips, como podemos melhorar o lucera pra você? Sugestões
-- novos items no shopping?)
select a.id, a.name, a.email from accounts as a, shop_history as h where
h.session = a.name group by a.id


/*
Players
- Ativos
- Inativos
- Totais
- conv (totais - inativos)
- tempo medio de jogo
*/

/*
KPIS ANTIGOS
*/

Items seller
SELECT count(sh.id) as qtd, so.name FROM shop_history as sh, shop_offer as so
where sh.product = so.id
group by sh.product order by qtd desc;

boughts on shopping game
select count(sh.id) as compras, sum(so.points) as pontos, sh.player from shop_history as sh, shop_offer
as so
where
sh.product = so.id
group by sh.player
order by pontos desc

Accounts with more vip days
select name,premdays,email,premium_points, rlname, nickname from accounts
where premdays > 1
order by premdays desc


Players with more points
select name,premdays,email,premium_points, rlname, nickname from accounts
where premium_points > 1
order by premium_points desc

Last banishments
SELECT b.id, p.name, DATE(FROM_UNIXTIME(b.added)) as data FROM bans as b, players as p
where b.value = p.id
order by b.id desc

List of Top Levels
select name, group_id, level, vocation, maglevel from players order by level desc

Top Respect
SELECT count(r.id) as qtd, p.name FROM respects as r, players p
where r.to_pid = p.id
group by to_pid order by qtd desc

A Wireframe with navigation and some ideas
http://img201.imageshack.us/img201/9154/drknowwireframe.png

Habilidades: CakePHP, Codeigniter, PHP, Arquitetura de software, Yii

Veja mais: mysql database models, crud system, crud in php, database crud, architecture projects, php mysql login register crud, suggest name software, pass query, user account crud, project kpis, execute, php create crud, suggest software names, projects list, automate password change, name php projects, php database query screen, php mysql user crud, query login database, crud mysql php

Acerca do Empregador:
( 14 comentários ) Rio de Janeiro, Portugal

ID do Projeto: #4307186

Concedido a:

khush1984

Hi gustavocp, Expert cakephp pro. Please read more in PM. Thanks

$200 USD em 3 dias
(36 Comentários)
6.7

5 freelancers estão ofertando em média $315 para esse trabalho

shaz123

Hi ===YESS!! WE ARE EXPERT IN WEB DEVELOPING, HTML, XHTML, CSS, JAVASCRIPT, JQUERRY, PHP, SEO, ECOMMERCE, WORDPRESS, JOOMLA, AJAX, DRUPAL,MAGENT,O XML, ANDROID APP,IPAD APP,IPHONE APP. , WE LOVE TO DEVELOP AND DESIGN== Mais

$250 USD in 9 dias
(7 Comentários)
4.5
SoftDevelopINC

Hello, May I help you to do this project? Please check pm for more [login to view URL]

$400 USD in 10 dias
(13 Comentários)
4.3
on2it

Hi, KIWI Team here at on2itonline would love to work for you on this project, we do "full service" websites on a clear and fixed budget. We have lots of offer that others don't, like our lifetime FREE hosting on every Mais

$600 USD in 21 dias
(2 Comentários)
4.2
xdeveloper93

I can create this automation system in time specified with high quality. I have required skills and expertise in databases. Looking forward to work with you.

$150 USD in 12 dias
(0 Comentários)
0.0
suninfolabs

i am ready for pm

$125 USD in 15 dias
(0 Comentários)
0.0