| 1 | package ExpenseTracker::Controllers::Base; | ||
| 2 | { | ||
| 3 | $ExpenseTracker::Controllers::Base::VERSION = '0.008'; | ||
| 4 | } | ||
| 5 | { | ||
| 6 | $ExpenseTracker::Controllers::Base::VERSION = '0.008'; | ||
| 7 | } | ||
| 8 | |||
| 9 | use strict; | ||
| 10 | use warnings; | ||
| 11 | |||
| 12 | use Mojo::Base 'Mojolicious::Controller'; | ||
| 13 | use Mojo::JSON; | ||
| 14 | use Mojo::Util; | ||
| 15 | use DateTime; | ||
| 16 | |||
| 17 | use DBIx::Class::ResultClass::HashRefInflator; | ||
| 18 | use Lingua::EN::Inflect qw/PL/; | ||
| 19 | |||
| 20 | |||
| 21 | sub new{ | ||
| 22 | my $self = shift; | ||
| 23 | |||
| 24 | my $obj = $self->SUPER::new(@_); | ||
| 25 | |||
| 26 | $obj->_after_init(); | ||
| 27 | |||
| 28 | return $obj; | ||
| 29 | } | ||
| 30 | |||
| 31 | sub create{ | ||
| 32 | my $self = shift; | ||
| 33 | |||
| 34 | $self->_before_create( @_ ); | ||
| 35 | |||
| 36 | my $result = $self->app->model | ||
| 37 | ->resultset( $self->{resource} ) | ||
| 38 | ->create( $self->{_payload} ); | ||
| 39 | |||
| 40 | return $self->render_json( $result->{_column_data} ); | ||
| 41 | } | ||
| 42 | |||
| 43 | sub update{ | ||
| 44 | my $self = shift; | ||
| 45 | |||
| 46 | my $result_rs = $self->app->model | ||
| 47 | ->resultset( $self->{resource} ) | ||
| 48 | ->search_rs( | ||
| 49 | { id => $self->param('id') }, | ||
| 50 | ); | ||
| 51 | |||
| 52 | return $self->render_not_found if ( scalar( ( $result_rs->all ) ) == 0 ); | ||
| 53 | |||
| 54 | $result_rs->update_all( $self->{_payload} ); | ||
| 55 | |||
| 56 | $result_rs->result_class('DBIx::Class::ResultClass::HashRefInflator'); | ||
| 57 | my @result = $result_rs->all(); | ||
| 58 | return $self->render_json( @result ); | ||
| 59 | } | ||
| 60 | |||
| 61 | sub list{ | ||
| 62 | my $self = shift; | ||
| 63 | |||
| 64 | my $result = $self->app->model | ||
| 65 | ->resultset( $self->{resource} ) | ||
| 66 | ->search_rs; | ||
| 67 | |||
| 68 | $result->result_class('DBIx::Class::ResultClass::HashRefInflator'); | ||
| 69 | |||
| 70 | #TODO: paging for the records | ||
| 71 | return $self->render_json( [ $result->all() ] ); | ||
| 72 | } | ||
| 73 | |||
| 74 | |||
| 75 | sub show{ | ||
| 76 | my $self = shift; | ||
| 77 | |||
| 78 | my $result = $self->app->model | ||
| 79 | ->resultset( $self->{resource} ) | ||
| 80 | ->search_rs( | ||
| 81 | { id => $self->param('id') }, | ||
| 82 | { result_class => 'DBIx::Class::ResultClass::HashRefInflator' }, | ||
| 83 | ) | ||
| 84 | ->first; | ||
| 85 | |||
| 86 | return $self->render_not_found if ( ref $result eq 'HASHREF' ); | ||
| 87 | return $self->render_json( $result ); | ||
| 88 | } | ||
| 89 | |||
| 90 | sub remove{ | ||
| 91 | my $self = shift; | ||
| 92 | |||
| 93 | my $result_rs = $self->app->model | ||
| 94 | ->resultset( $self->{resource} ) | ||
| 95 | ->search_rs( | ||
| 96 | { id => $self->param('id') }, | ||
| 97 | ); | ||
| 98 | |||
| 99 | |||
| 100 | return $self->render_not_found if ( scalar( ( $result_rs->all ) ) == 0 ); | ||
| 101 | |||
| 102 | $result_rs->delete_all; | ||
| 103 | |||
| 104 | my $resource_name = Mojo::Util::decamelize( ( split '::', $self->{resource} )[-1] ); | ||
| 105 | return $self->redirect_to( $self->url_for( 'list_'.PL( $resource_name ) ) ) ; | ||
| 106 | } | ||
| 107 | |||
| 108 | sub _after_init{ | ||
| 109 | my $self = shift; | ||
| 110 | |||
| 111 | $self->{_payload} ||= ( $self->req->json or '' ); | ||
| 112 | |||
| 113 | } | ||
| 114 | |||
| 115 | sub _before_create{ | ||
| 116 | my $self = shift; | ||
| 117 | |||
| 118 | my $now = DateTime->now ; | ||
| 119 | |||
| 120 | $self->{_payload}->{created_at} = ''.$now if ( 'created_at' ~~ [ $self->app->model->resultset( $self->{resource} )->result_source->columns ] ); | ||
| 121 | $self->{_payload}->{updated_at} = ''.$now if ( 'updated_at' ~~ [ $self->app->model->resultset( $self->{resource} )->result_source->columns ] ); | ||
| 122 | } | ||
| 123 | |||
| 124 | sub _before_update{ | ||
| 125 | my $self = shift; | ||
| 126 | |||
| 127 | my $now = DateTime->now ; | ||
| 128 | |||
| 129 | $self->{_payload}->{updated_at} = ''.$now if ( 'updated_at' ~~ [ $self->app->model->resultset( $self->{resource} )->result_source->columns ] ); | ||
| 130 | } | ||
| 131 | |||
| 132 | 1; | ||
| 133 | |||
| 134 | __END__ |