store CRM and LDAP entries in redis

[APKPM.git] / web_ui.pl

diff --git a/web_ui.pl b/web_ui.pl
index 0331d68..f449db5 100755 (executable)
--- a/web_ui.pl
+++ b/web_ui.pl
@@ -60,6 +60,18 @@ get '/g/:call/:args' => [ args => qr/.*/ ] => sub {
        _render_jsonp( $self, $ret );
 };
 
+get '/table/:table' => sub {
+       my $self = shift;
+       my $sql = "select * from " . $self->param('table');
+       if ( my $username = $self->param('username') ) {
+               $sql .= " where username = '$username' ";
+       }
+       $sql .= " limit " . ( $self->param('limit') || 1 );
+
+       my $ret = $gearman->req( 'SUBMIT_JOB', 'Store_sql', '', $sql );
+       _render_jsonp( $self, $ret );
+};
+
 get '/_g/status' => sub {
        my $self = shift;