1 package FS::part_export::phone_sqlopensips;
3 use vars qw(@ISA @EXPORT_OK %info %options);
6 use FS::Record qw( dbh qsearch qsearchs );
12 @ISA = qw(FS::part_export);
14 tie %options, 'Tie::IxHash',
15 'datasrc' => { label=>'DBI data source ' },
16 'username' => { label=>'Database username' },
17 'password' => { label=>'Database password' },
18 'xmlrpc_url' => { label=>'XMLRPC URL' },
23 'desc' => 'Export DIDs to OpenSIPs dr_rules table',
24 'options' => \%options,
25 'notes' => 'Export DIDs to OpenSIPs dr_rules table',
28 sub rebless { shift; }
31 my($self, $svc_x) = (shift, shift);
33 my $conf = new FS::Conf;
34 my $agentnum = $svc_x->cust_svc->cust_pkg->cust_main->agentnum || 0;
35 my $gwlist = $conf->config('opensips_gwlist',$agentnum)
36 || $svc_x->phone_name;
37 my $description = $conf->config('opensips_description',$agentnum)
39 my $route = $conf->config('opensips_route',$agentnum) || $svc_x->route;
41 my $dbh = $self->opensips_connect;
42 my $sth = $dbh->prepare("insert into dr_rules ".
43 "( groupid, prefix, timerec, routeid, gwlist, description ) ".
44 " values ( ?, ?, ?, ?, ?, ? )") or die $dbh->errstr;
45 $sth->execute('0',$svc_x->phonenum,'',$route,$gwlist,
46 $description) or die $sth->errstr;
48 $self->dr_reload; # XXX: if this fails, do we delete what we just inserted?
51 sub opensips_connect {
53 DBI->connect($self->option('datasrc'),$self->option('username'),
54 $self->option('password')) or die $DBI::errstr;
58 # disabled the below for now as we went with a agent-virtualized config for the params
62 my( $self, $new, $old ) = (shift, shift, shift);
66 if($old->route ne $new->route){
67 push @update, 'routeid = ?';
68 push @paramvalues, $new->route;
71 if($old->phone_name ne $new->phone_name) {
72 push @update, 'description = ?';
73 push @paramvalues, $new->phone_name;
76 if($old->gwlist ne $new->gwlist) {
77 push @update, 'gwlist = ?';
78 push @paramvalues, $new->gwlist;
82 my $update_str = join(' and ',@update);
83 my $dbh = $self->opensips_connect;
84 my $sth = $dbh->prepare("update dr_rules set $update_str " .
85 " where prefix = ? ") or die $dbh->errstr;
86 push @paramvalues, $old->phonenum;
87 $sth->execute(@paramvalues) or die $sth->errstr;
89 return $self->dr_reload;
95 my( $self, $svc_phone ) = (shift, shift);
99 sub _export_unsuspend {
100 my( $self, $svc_phone ) = (shift, shift);
105 my( $self, $svc_x ) = (shift, shift);
106 my $dbh = $self->opensips_connect;
107 my $sth = $dbh->prepare("delete from dr_rules where prefix = ?")
109 $sth->execute($svc_x->phonenum) or die $sth->errstr;
111 $self->dr_reload; # XXX: if this fails, do we re-insert what we just deleted?
116 my $reqxml = "<?xml version=\"1.0\"?>
118 <methodName>dr_reload</methodName>
120 my $ua = LWP::UserAgent->new;
121 my $resp = $ua->post( $self->option('xmlrpc_url'),
122 Content_Type => 'text/xml',
123 Content => $reqxml );
124 return "invalid HTTP response from OpenSIPS: " . $resp->status_line
125 unless $resp->is_success;