X-Git-Url: http://git.shiar.net/sheet.git/blobdiff_plain/24d7164ce1fd20686e5091d6446b3408a1c71c73..cf8d01da2735d21735d562e73009546d64125d4a:/writer.plp diff --git a/writer.plp b/writer.plp index 11754e8..99a9736 100644 --- a/writer.plp +++ b/writer.plp @@ -6,27 +6,48 @@ Html({ nocache => 1, raw => <<'EOT', - + EOT }); @@ -108,14 +106,24 @@ my $db = eval { } or Abort('Database error', 501, $@); my @wordcols = ( - form => 'Translation', - wptitle => 'Wikipedia', - ref => 'Reference', - cat => 'Category', lang => 'Language', - source => 'Image URL', + cat => 'Category', + ref => undef, # included with cat + grade => undef, # " + prio => 'Level', + cover => undef, # included with prio + form => 'Title', + alt => 'Synonyms', + wptitle => 'Wikipedia', + source => 'Image', thumb => 'Convert options', ); +my @prioenum = qw( essential basic common distinctive rare invisible ); +my %langflag = ( + nld => "\N{REGIONAL INDICATOR SYMBOL LETTER N}\N{REGIONAL INDICATOR SYMBOL LETTER L}", + eng => "\N{REGIONAL INDICATOR SYMBOL LETTER G}\N{REGIONAL INDICATOR SYMBOL LETTER B}", + epo => '★', +); my ($find) = map {{id => $_}} $fields{id} || $Request || (); my $row; @@ -125,9 +133,9 @@ if ($find) { } if (exists $get{copy}) { - $row = {%{$row}{ qw(lang cat) }}; + $row = {%{$row}{ qw(prio lang cat) }}; } -elsif ($ENV{REQUEST_METHOD} eq 'POST') { +elsif ($ENV{REQUEST_METHOD} eq 'POST') {{ my $replace = $row; $row = {%post{ pairkeys @wordcols }}; $_ = length ? $_ : undef for values %{$row}; @@ -137,79 +145,148 @@ elsif ($ENV{REQUEST_METHOD} eq 'POST') { my $query = $find ? $db->update(word => $row, $find, \%res) : $db->insert(word => $row, \%res); $row = $query->hash; - } or Alert("Entry could not be saved", $@); + } or do { + Alert("Entry could not be saved", $@); + next; + }; my $imgpath = "data/word/org/$row->{id}.jpg"; - if (($row->{source} // '') ne ($replace->{source} // '')) { + my $reimage = eval { + ($row->{source} // '') ne ($replace->{source} // '') or return; # copy changed remote url to local file unlink $imgpath if -e $imgpath; - if (my $download = $row->{source}) { - require LWP::UserAgent; - my $ua = LWP::UserAgent->new; - $ua->agent('/'); - my $status = $ua->mirror($download, $imgpath); - $status->is_success or Alert([ - "Source image not found", - "Download from $download failed: ".$status->status_line, - ]); - } - } - elsif ($row->{thumb} ~~ $replace->{thumb}) { - # image and conversion unaltered - $imgpath = undef; - } + my $download = $row->{source} or return 1; + require LWP::UserAgent; + my $ua = LWP::UserAgent->new; + $ua->agent('/'); + my $status = $ua->mirror($download, $imgpath); + $status->is_success + or die "Download from $download failed: ".$status->status_line."\n"; + }; + !$@ or Alert(["Source image not found", $@]); + + $reimage ||= $row->{thumb} ~~ $replace->{thumb}; # different convert + $reimage ||= $row->{cover} ~~ $replace->{cover}; # resize + $reimage++ if $fields{rethumb}; # force refresh my $thumbpath = "data/word/eng/$row->{form}.jpg"; - if ($imgpath) { + if ($reimage) { if (-e $imgpath) { + my $xyres = $row->{cover} ? '600x400' : '300x200'; my @cmds = @{ $row->{thumb} // [] }; @cmds = ( 'convert', -delete => '1--1', -background => 'white', -gravity => @cmds ? 'northwest' : 'center', @cmds, - -resize => '300x200^', -extent => '300x200', + -resize => "$xyres^", -extent => $xyres, '-strip', -quality => '60%', -interlace => 'plane', $imgpath => $thumbpath ); - my $status = system @cmds; - $status == 0 or Alert([ + eval { + require IPC::Run; + my $output; + IPC::Run::run(\@cmds, '<' => \undef, '>&' => \$output) + or die $output || + ($? & 127 ? "signal $?" : "error code ".($? >> 8))."\n"; + } or Alert([ "Thumbnail image not generated", - "Failed to convert source image, error code ".($status >> 8), - ], "@cmds"); + "Failed to convert source image.", + ], "@cmds\n$@"); } else { unlink $thumbpath; } } -} +}} else { + $row->{prio} //= 1; $row->{$_} = $get{$_} for keys %get; } my $title = $row->{id} ? "entry #$row->{id}" : 'new entry'; + +package Shiar_Sheet::FormRow { + sub input { + my ($row, $col, $type, $label) = @_; + my $val = $row->{$col} // ''; + $val = '{'.join(',', map {s/,/\\,/gr} @{$val}).'}' if ref $val eq 'ARRAY'; + if (ref $type eq 'ARRAY') { + return ( + sprintf('', + ); + } + elsif ($type eq 'checkbox') { + return sprintf( + join('', + '', + ), $col, $type, !!$val && ' checked', $label + ); + } + else { + my $html = ''; + $html .= qq( $_="$type->{$_}") for sort keys %{$type // {}}; + return ( + $label ? sprintf('', $col, $label) : (), + sprintf('', + $col, PLP::Functions::EscapeHTML($val), $html + ), + ); + } + } +} +bless $row, 'Shiar_Sheet::FormRow'; :>

Words <:= $title :>

+
+
-
+
    <: +for my $colinfo (pairs @wordcols) { + my ($col, $title) = @{$colinfo}; + defined $title or next; + printf '
  • ', $col, $title; + printf ''; + if ($col eq 'prio') { + print $row->input($col => \@prioenum); + print $row->input(cover => 'checkbox', 'Highlighted'); + print $row->input(grade => {type => 'number'}, 'Order'); + } + else { + print $row->input($col); + -e and printf '%s', $col, $_, $row->{form} + for $col eq 'thumb' ? "data/word/eng/$row->{form}.jpg" : (); + print $row->input(ref => {}, 'Reference') if $col eq 'cat'; + } + print ''; + -e and printf('', + $col, $_, $row->{form} + ) for $col eq 'source' ? "data/word/org/$row->{id}.jpg" : (); + say '

  • '; +} -for my $col (pairs @wordcols) { - my $val = $row->{$col->key} // ''; - $val = '{'.join(',', map {s/,/\\,/gr} @{$val}).'}' if ref $val eq 'ARRAY'; - printf '
    ' - . '
    ', - $col->key, $col->value, Entity($val); - -e and printf ' %s', $_, $row->{form} for - $col->key eq 'source' ? "data/word/org/$row->{id}.jpg" : - $col->key eq 'thumb' ? "data/word/eng/$row->{form}.jpg" : - (); - say '
    '; +if ($row->{id}) { + my $children = $db->select(word => '*', {ref => $row->{id}}, 'lang, id'); + printf '
    • ', 'Translations'; + while (my $row = $children->hash) { + printf '
    • %s
    • ', + "trans-$row->{lang}", $langflag{$row->{lang}}, + "/writer/$row->{id}", Entity($row->{form}); + } + say '
  • '; } :> -
+

@@ -217,9 +294,9 @@ for my $col (pairs @wordcols) {

<: -$row->{id} or exit; +if ($row->{id}) { :> -
+ +<: +} +:> +