<?php

    /** @popup * */
    $tpLayout = 1;

    /** COLETA OS DADOS DO POST * */
    $fieldspost = filter_input_array(INPUT_POST, FILTER_SANITIZE_SPECIAL_CHARS);

    try {
        $param = GetParam();

        if (isset($fieldspost['bt_gravar'])) {
            SetParam($fieldspost);
        }
    } catch (Exception $ex) {
        flash($ex->getMessage(), 'red');
    }

    $smarty->assign("flash", flash());
    $smarty->assign("param", $param);
    GetTemplate($smarty, 'cadastros/cliente/clienteSMTP.tpl');

    function GetParam() {
        global $dbcon;
        $query = "SELECT * FROM pbx_campanha_parametros";
        $result = pg_query($dbcon, $query);
        return pg_fetch_assoc($result);
    }

    function SetParam($param) {
        global $dbcon;

        if (!$param['id_param']) {
            $query = "INSERT INTO pbx_campanha_parametros (host_param, user_param, password_param, port_param, secure_param, charset_param, auth_param, from_param) "
                    . "VALUES(%s, %s, %s, %s, %s, %s, %s, %s) RETURNING id_param;";
        } else {
            $query = "UPDATE pbx_campanha_parametros SET "
                    . "host_param = %s,"
                    . "user_param = %s,"
                    . "password_param = %s,"
                    . "port_param = %s,"
                    . "secure_param = %s,"
                    . "charset_param = %s,"
                    . "auth_param = %s,"
                    . "from_param = %s, "
                    . "update_reg = '" . date('Y-m-d H:i:s') . "' WHERE id_param = {$param['id_param']}";
        }

        $query = sprintf($query,
                QuotedStr($param['host_param']), 
                QuotedStr($param['user_param']),
                QuotedStr($param['password_param']), 
                QuotedStr($param['port_param']),
                QuotedStr(($param['secure_param'] ? $param['secure_param'] : 'TLS')), 
                QuotedStr(($param['charset_param'] ? $param['charset_param'] : 'UTF8')),
                QuotedStr(($param['auth_param'] ? $param['auth_param'] : 0)), 
                QuotedStr($param['from_param']));

        $result = pg_query($dbcon, $query);

        if (!$result) {
            throw new Exception("Não foi possível " . ($param['id_param'] ? "atualizar" : "criar") . " o registro! Erro: " . pg_last_error());
        }
        flash("O registro foi " . ($param['id_param'] ? "atualizado" : "criado") . " com sucesso!", 'green');
    }

    function flash($message = null, $color = 'green') {
        if ($message) {
            $_SESSION['SSMSGFlash'] = $message;
            $_SESSION['SSMSGFlashColor'] = $color;
        } else {
            $message = $_SESSION['SSMSGFlash'];
            $color = $_SESSION['SSMSGFlashColor'];
            unset($_SESSION['SSMSGFlash'], $_SESSION['SSMSGFlashColor']);
        }
        return array($message, $color);
    }