CREATE TRIGGER trgr_insert_dialpeer_config_tb
  AFTER INSERT
  ON tb_dialpeer_db_cfg
  FOR EACH ROW
  EXECUTE PROCEDURE update_dialpeer_config_tb();


-- Function: update_dialpeer_config_tb()

-- DROP FUNCTION update_dialpeer_config_tb();

CREATE OR REPLACE FUNCTION update_dialpeer_config_tb()
  RETURNS "trigger" AS
$BODY$DECLARE ---NOT USED
--generate NEW.id_dp DP cfg_curs_pr
cfg_curs_pr CURSOR FOR select par.parametr_name,cfg.parametr, cfg.id_ss from tb_dialpeer_db_cfg cfg,tb_parametr_cfg par
where cfg.id_parametr  =  par.id and cfg.id_dp=NEW.id_dp and cfg.id_ss = NEW.id_ss order by par.id;
dp_cfg text;
par_parametr_name varchar;
par_parametr_value varchar;
group_name varchar;
cfg_id integer; active_p integer;
dialpeername varchar( 200 );act varchar;
cnt integer; cnt_par integer;
def_ss_id integer;ss_id integer;id integer;
dp_r RECORD;
BEGIN
delete from tb_test_val;
--select dialpeer_name,active into dialpeername,active_p from dialpeer where id = NEW.id_dp;
SELECT INTO dp_r * FROM dialpeer WHERE id = NEW.id_dp;
--dialpeername := (select dialpeer_name::varchar from dialpeer where id = NEW.id_dp);
--active_p := (select active::integer from dialpeer where id = NEW.id_dp);
--'test_dp';
insert into tb_test_val (text_f) values (NEW.id_dp::text);
insert into tb_test_val (text_f) values (dp_r.dialpeer_name);
insert into tb_test_val (text_f) values (dp_r.active);
--if (active_p>0) then act = null; else act = '#_'; end if;
--gw_cfg = lower('[db_'||replace(gw_descr, ' ', '_')||'_'||NEW.id_gateway||']\n'); 
dp_cfg := lower('[db_'||replace(dialpeername::text, ' ', '_')::text||'_'||NEW.id_dp||']\n')::text;--act||
--dp_cfg = 'test\n';
insert into tb_test_val (val) values (dp_cfg); 
insert into tb_test_val (val) values (dialpeername);
  OPEN cfg_curs_pr;
    LOOP
      FETCH cfg_curs_pr INTO par_parametr_name,par_parametr_value,ss_id;IF NOT FOUND THEN EXIT; END IF;    
      dp_cfg = dp_cfg || par_parametr_name || par_parametr_value||'\n';--||act
     insert into tb_test_val (text_f) values (par_parametr_name); 
     insert into tb_test_val (text_f) values (dp_cfg);
     insert into tb_test_val (text_f) values (par_parametr_value);
    END LOOP;
  CLOSE cfg_curs_pr;
--insert into tb_test_val (text_f) values (dp_cfg);
cnt_par =  0 ;
select count(*) into cnt_par from tb_dialpeer_db_cfg where id_dp = NEW.id_dp and id_ss = NEW.id_ss;
if(cnt_par> 0 ) then update tb_sw_dp_cfg set config=dp_cfg where id_dp = NEW.id_dp and id_sw=NEW.id_ss;END IF;
RETURN NEW;
END;$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION update_dialpeer_config_tb() OWNER TO alex;

select dialpeer_name,active into dialpeername,active_p from dialpeer where id =  108441 ;--NEW.id_dp;

select dialpeer_name,active into dialpeername,active_p from dialpeer where id =  108441 ;--NEW.id_dp;
RAISE NOTICE 'select dialpeer_name%' , dialpeername;

select 'wwwqqq',active into dialpeername,active_p from dialpeer where id =  108441 ;--NEW.id_dp;
RAISE NOTICE 'select dialpeer_name%' , dialpeername;

dialpeername :=( select id from dialpeer where id =  108441 );--NEW.id_dp;
RAISE NOTICE 'select id =%' , dialpeername;
dialpeername :=( select count(*) from dialpeer where id =  108441 );
RAISE NOTICE 'select count =%' , dialpeername;

dialpeername :=( select dialpeer.dialpeer_name from dialpeer where dialpeer.id =  108441 );--NEW.id_dp;voipswitch.public.
RAISE NOTICE 'select id =%' , dialpeername;
dialpeername :=( select count(*) from dialpeer where dialpeer.id =  108441 );--voipswitch.public.
RAISE NOTICE 'select count =%' , dialpeername;