SQL: Mysql
Отчёт по платежам(готовый)
Код: Выделить всё
SELECT account_id, payment_incurrency, payment_absolute,FROM_UNIXTIME(actual_date), method, who_receive, comments_for_user, comments_for_admins FROM payment_transactions WHERE actual_date>=UNIX_TIMESTAMP('2008-04-24 00:00:00') AND actual_date<=UNIX_TIMESTAMP('2008-04-24 17:30:00') ORDER BY actual_date DESC
Код: Выделить всё
select account_id, tariff_id , is_deleted from account_tariff_link where tariff_id=$tariff AND is_deleted=0
Код: Выделить всё
SELECT discount_transactions_iptraffic_all.account_id, SUM(bytes), inet_ntoa(ip_groups.ip & 0xFFFFFFFF) AS ip FROM discount_transactions_iptraffic_all INNER JOIN account_tariff_link INNER JOIN users INNER JOIN ip_groups WHERE discount_transactions_iptraffic_all.discount_date>=UNIX_TIMESTAMP('2008-09-02 00:00:00') AND discount_transactions_iptraffic_all.discount_date<=UNIX_TIMESTAMP('2008-09-02 23:59:59') AND discount_transactions_iptraffic_all.account_id=account_tariff_link.account_id AND discount_transactions_iptraffic_all.t_class='10' AND account_tariff_link.is_deleted='0' AND account_tariff_link.tariff_id='12' AND users.id=account_tariff_link.account_id AND ip_groups.uname=users.login AND ip_groups.is_deleted=0 GROUP BY t_class,account_tariff_link.account_id,slink_id order by account_tariff_link.account_id;
Код: Выделить всё
select inet_ntoa(ip_groups.ip & 0xFFFFFFFF) AS ip,uname FROM ip_groups where uname="goblin";
Выборка IP Л.С и Логина с группировкой по IP
Код: Выделить всё
select inet_ntoa(ip_groups.ip & 0xFFFFFFFF) AS ip,users.id,ip_groups.uname FROM users INNER JOIN service_links ON users.id=service_links.user_id INNER JOIN ip_groups ON users.login=ip_groups.uname WHERE ip_groups.is_deleted=0 AND users.is_deleted=0 AND service_links.is_deleted=0;