| 1 | package Daje::Workflow::GeneratePerl::Generate::View; | ||
| 2 | use Mojo::Base 'Daje::Workflow::GeneratePerl::Base::Common' ,-base, -signatures; | ||
| 3 | |||
| 4 | use String::CamelCase qw(camelize); | ||
| 5 | |||
| 6 | our $VERSION = '0.01'; | ||
| 7 | |||
| 8 | has 'select' ; | ||
| 9 | has 'primary_keys' ; | ||
| 10 | has 'foreign_keys'; | ||
| 11 | has 'primary_keys_arr' ; | ||
| 12 | has 'foreign_keys_arr'; | ||
| 13 | has 'methods'; | ||
| 14 | |||
| 15 | sub generate($self) { | ||
| 16 | |||
| 17 | my $tpl = $self->templates->get_data_section('view_list_class'); | ||
| 18 | my $table_name = $self->json->{view}->{table_name}; | ||
| 19 | my $name_space = $self->context->{context}->{perl}->{view_name_space}; | ||
| 20 | my $base_name_space = $self->context->{context}->{perl}->{base_name_space}; | ||
| 21 | my $class_name = camelize($table_name); | ||
| 22 | my $base_class_name = "Base"; | ||
| 23 | |||
| 24 | my $date = localtime(); | ||
| 25 | $self->_get_fields(); | ||
| 26 | $self->_methods(); | ||
| 27 | my $methods = $self->methods(); | ||
| 28 | |||
| 29 | my $fields = $self->_has_methods($self->json->{view}->{table_name}); | ||
| 30 | |||
| 31 | $tpl =~ s/<<date>>/$date/ig; | ||
| 32 | $tpl =~ s/<<fields>>/$fields/ig; | ||
| 33 | $tpl =~ s/<<name_space>>/$name_space/ig; | ||
| 34 | $tpl =~ s/<<classname>>/$class_name/ig; | ||
| 35 | $tpl =~ s/<<base_name_space>>/$base_name_space/ig; | ||
| 36 | $tpl =~ s/<<base_class_name>>/$base_class_name/ig; | ||
| 37 | |||
| 38 | $tpl =~ s/<<methods>>/$methods/ig; | ||
| 39 | |||
| 40 | return $tpl; | ||
| 41 | |||
| 42 | } | ||
| 43 | |||
| 44 | sub _has_methods($self, $view) { | ||
| 45 | my $tpl = $self->templates->get_data_section('view_fields_method'); | ||
| 46 | |||
| 47 | |||
| 48 | $self->_keys(); | ||
| 49 | |||
| 50 | my $pkey = $self->primary_keys(); | ||
| 51 | my $fkey = $self->foreign_keys(); | ||
| 52 | my $select = $self->select(); | ||
| 53 | |||
| 54 | $pkey = " " unless $pkey; | ||
| 55 | $fkey = " " unless $fkey; | ||
| 56 | |||
| 57 | $tpl =~ s/<<select_fields>>/$select/ig; | ||
| 58 | $tpl =~s/<<primary_keys>>/$pkey/ig; | ||
| 59 | $tpl =~s/<<foreign_keys>>/$fkey/ig; | ||
| 60 | $tpl =~s/<<view_name>>/$view/ig; | ||
| 61 | |||
| 62 | return $tpl; | ||
| 63 | } | ||
| 64 | |||
| 65 | sub _methods($self) { | ||
| 66 | my $tpl = $self->templates->get_data_section('load_from_fkey'); | ||
| 67 | my $sql = ""; | ||
| 68 | if($self->primary_keys_arr and scalar @{$self->primary_keys_arr} > 0) { | ||
| 69 | my $length = @{$self->primary_keys_arr}; | ||
| 70 | for (my $i = 0; $i < $length; $i++) { | ||
| 71 | my $template = $tpl; | ||
| 72 | my $key = @{$self->primary_keys_arr}[$i]; | ||
| 73 | $template =~ s/<<foreign_key>>/$key/ig; | ||
| 74 | $sql .= $template | ||
| 75 | } | ||
| 76 | } | ||
| 77 | |||
| 78 | if($self->foreign_keys_arr and scalar @{$self->foreign_keys_arr} > 0) { | ||
| 79 | my $length = @{$self->foreign_keys_arr}; | ||
| 80 | for (my $i = 0; $i < $length; $i++) { | ||
| 81 | my $template = $tpl; | ||
| 82 | my $key = @{$self->foreign_keys_arr}[$i]; | ||
| 83 | $template =~ s/<<foreign_key>>/$key/ig; | ||
| 84 | $sql .= $template | ||
| 85 | } | ||
| 86 | } | ||
| 87 | $self->methods($sql); | ||
| 88 | } | ||
| 89 | |||
| 90 | sub _keys($self) { | ||
| 91 | |||
| 92 | my $tpl = $self->templates->get_data_section('view_fields_method'); | ||
| 93 | my $p_keys = ""; | ||
| 94 | my $length = 0; | ||
| 95 | if($self->primary_keys_arr and scalar @{$self->primary_keys_arr} > 0) { | ||
| 96 | $length = scalar @{$self->primary_keys_arr}; | ||
| 97 | for (my $i = 0; $i < $length; $i++) { | ||
| 98 | if (length($p_keys)) { | ||
| 99 | $p_keys .= ',' . @{$self->primary_keys_arr}[$i]; | ||
| 100 | } | ||
| 101 | else { | ||
| 102 | $p_keys = @{$self->primary_keys_arr}[$i]; | ||
| 103 | } | ||
| 104 | } | ||
| 105 | $self->primary_keys($p_keys); | ||
| 106 | } | ||
| 107 | |||
| 108 | $p_keys = ""; | ||
| 109 | if($self->foreign_keys_arr and scalar @{$self->foreign_keys_arr} > 0) { | ||
| 110 | $length = scalar @{$self->foreign_keys_arr}; | ||
| 111 | for (my $i = 0; $i < $length; $i++) { | ||
| 112 | if (length($p_keys)) { | ||
| 113 | $p_keys .= ',' . @{$self->foreign_keys_arr}[$i]; | ||
| 114 | } | ||
| 115 | else { | ||
| 116 | $p_keys = @{$self->foreign_keys_arr}[$i]; | ||
| 117 | } | ||
| 118 | } | ||
| 119 | $self->foreign_keys($p_keys); | ||
| 120 | } | ||
| 121 | } | ||
| 122 | |||
| 123 | sub _get_fields($self) { | ||
| 124 | my $column_names = $self->json->{view}->{column_names}; | ||
| 125 | my $length = scalar @{$column_names}; | ||
| 126 | my @keys; | ||
| 127 | my @pkeys; | ||
| 128 | for (my $i = 0; $i < $length; $i++) { | ||
| 129 | if (index(@{$column_names}[$i]->{column_name},'_pkey') > -1){ | ||
| 130 | push(@pkeys, @{$column_names}[$i]->{column_name}); | ||
| 131 | } | ||
| 132 | if (index(@{$column_names}[$i]->{column_name},'_fkey') > -1){ | ||
| 133 | push (@keys, @{$column_names}[$i]->{column_name}); | ||
| 134 | } | ||
| 135 | if (defined($self->select) and length($self->select) > 0) { | ||
| 136 | my $select = $self->select(); | ||
| 137 | $self->select($select .= ", '" . @{$column_names}[$i]->{column_name} . "'"); | ||
| 138 | } else { | ||
| 139 | $self->select("'" . @{$column_names}[$i]->{column_name} . "'"); | ||
| 140 | } | ||
| 141 | } | ||
| 142 | $self->foreign_keys_arr(\@keys) if @keys and scalar(@keys) > 0; | ||
| 143 | $self->primary_keys_arr(\@pkeys) if @pkeys and scalar(@pkeys) > 0; | ||
| 144 | } | ||
| 145 | 1; | ||
| 146 | |||
| 147 | #################### pod generated by Pod::Autopod - keep this line to make pod updates possible #################### | ||
| 148 | |||
| 149 | =head1 NAME | ||
| 150 | |||
| 151 | Daje::Workflow::GeneratePerl::Generate::View | ||
| 152 | |||
| 153 | |||
| 154 | =head1 REQUIRES | ||
| 155 | |||
| 156 | L<String::CamelCase> | ||
| 157 | |||
| 158 | L<Mojo::Base> | ||
| 159 | |||
| 160 | |||
| 161 | =head1 METHODS | ||
| 162 | |||
| 163 | =head2 generate($self) | ||
| 164 | |||
| 165 | generate($self)(); | ||
| 166 | |||
| 167 | |||
| 168 | =cut | ||
| 169 |