<?php

/* Default database settings*/
$database_type = "sqlsrv";
$database_default = "medialog";
$database_hostname = "localhost";
$database_username = "sa";
$database_password = "password";
$database_port = "";

/* display ALL errors */
error_reporting(E_ALL);

header("Content-type: application/json; charset=utf-8");

/* Include configuration */
include("config.php");

if($database_type=="sqlsrv")
    $dsn = "$database_type:server=$database_hostname;database=$database_default";
else
    $dsn = "$database_type:host=$database_hostname;dbname=$database_default;charset=$database_charset";

$opt = array(
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);

try {
    $conn = new PDO($dsn, $database_username, $database_password, $opt);
}
catch(PDOException $e) {
    die($e->getMessage());
}

/* Set up and execute the query. */
$tsql = "SELECT
 FM_SERV.FM_SERV_ID,FM_SERV.CODE
 , FM_SERV.LABEL
 ,(SELECT TOP 1 FM_SERVPRICE.PRICE FROM FM_SERVPRICE FM_SERVPRICE
 WHERE FM_SERVPRICE.DATE_FROM  <= GETDATE()
 AND FM_SERVPRICE.FM_PRICETYPE_ID =1
 AND FM_SERVPRICE.FM_SERV_ID=FM_SERV.FM_SERV_ID
 ORDER BY FM_SERVPRICE.DATE_FROM DESC) price
FROM
 FM_SERV FM_SERV
WHERE
/* только услуги с действующими ценами */
FM_SERV.FM_SERV_ID in (
    SELECT FM_SERVPRICE.FM_SERV_ID
    FROM FM_SERVPRICE
    WHERE FM_SERVPRICE.DATE_FROM  <= GETDATE()
    )
AND FM_SERV.STATE in ('A')
";

$stmt = $conn->query($tsql);
$rows = $stmt->fetchAll();

$numRows = count($rows);
//echo "<p>$numRows Row" . ($numRows == 1 ? "" : "s") . " Returned </p>";

if($numRows>0)
{
    echo json_encode($rows);
}
else
{
    echo json_encode("No rows returned.", JSON_FORCE_OBJECT);
}

?>