<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
include "../includes/functions.php";

$db = pg_connect ("host=10.240.240.50 port=5432 dbname=utm user=web_acco password=k23y7fal375");
if (!$db) die("Ошибка! Не удалось подключиться к базе данных");

    $sql = "
        WITH ctv_date(moon) AS (
            SELECT EXTRACT(DAY FROM (date_trunc('month', NOW()) + INTERVAL '1 month') - date_trunc('month', NOW()))::integer
        )
        SELECT
            ac.card_num, et.ename, ac.act_date, to_char(ac.duration, 'YY MM'),
            CASE WHEN act_date is NULL THEN false ELSE ac.act_date+ac.duration>=now() END,
            (ac.act_date+ac.duration)::date,
            (ac.act_date+ac.duration)::date-now()::date,
            ac.end_date::date,
            (unix_timestamp(end_date)-unix_timestamp(NOW()))/60/60/24 days,
            comment,
            ac.ch_flag,
            (SELECT to_char(NOW()::date + (d.moon * (ac.ras/ac.ras_podp)) * INTERVAL '1 day', 'YYYY-MM-DD') count_day FROM ctv_date d) count_day,
            ac.ras,
            ac.ras_podp
        FROM iptv.access_cards ac, iptv.operators o, iptv.encrypt_type et
        WHERE ac.op_id=o.id AND ac.enc_type=et.id AND
        CASE WHEN EXTRACT(DAY FROM (SELECT to_char(NOW()::date + (d.moon * (ac.ras/ac.ras_podp)) * INTERVAL '1 day', 'YYYY-MM-DD') count_day FROM ctv_date d)::date - NOW())::integer>14
            THEN true
            ELSE false
        END";
    $res = pg_query($db, $sql) or die_query("Не удалось получить список каналов", $sql);

    while (list($card_num) = pg_fetch_array($res)) {
        $email = "bochkarev-vl@mail.ru";
        $subject = "Vladlink";
        $text = "На карте с № $card_num заканчивается подписка.";
        $headers = "Return-Path: issa@vladlink.net\r\n".
            "From: issa@vladlink.net\r\n".
            "Content-type: text/html; charset=UTF-8\r\n".
            "X-Mailer: PHP/".phpversion();

        if (mail($email, $subject, $text, $headers)) {
            echo "Succes";
        } else {
            echo "Some error happen";
        }
    }


$email = "bochkarev-vl@mail.ru";
$subject = "Vladlink";
$text = "<b>На карте с № $card_num заканчивается подписка.</b>";
$headers = "Return-Path: issa@vladlink.net\r\n".
    "From: issa@vladlink.net\r\n".
    "Content-type: text/html; charset=UTF-8\r\n".
    "X-Mailer: PHP/".phpversion();

if (mail($email, $subject, $text, $headers)) {
    echo "Succes";
} else {
    echo "Some error happen";
}