<?php

//Configuracoes de banco

$dbname = "bmtelecom";
$dbaddress = "127.0.0.1";
$dbport = "5432";
$dbuser = "postgres";
$dbpass = "cp65482jf";

//Configuracoes de registros

$periodStart='2017-06-02 00:00:00';
$periodFinish='2017-07-12 00:00:00';
$sip='6009';
$group_alias='Suporte';

//Execucao do codigo
$con_string = "host=".$dbaddress. " port=".$dbport . " dbname=".$dbname ." user=". $dbuser. " password=".$dbpass;
$bdcon = pg_connect($con_string) or die('Nao foi possivel conectar');;

$result = pg_query($bdcon, "UPDATE validate_calls
SET permission_group_id = (SELECT id from permission_groups
WHERE alias = '".$group_alias."')
WHERE calldate >= '".$periodStart."'
AND calldate <= '".$periodFinish."'
AND (src ='".$sip."' OR dst='".$sip."')") ;
echo "Valores atualizados.";
pg_close($bdcon);
?>