Merge branch 'new/enh/bug_5917' into kcmaster
[koha_gimpoz] / cataloguing / value_builder / unimarc_field_210c.pl
index ffbf644..8ecaeab 100755 (executable)
 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
 #
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA  02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 
+#use strict;
+#use warnings; FIXME - Bug 2505
 
 use C4::AuthoritiesMarc;
 use C4::Auth;
@@ -63,51 +65,12 @@ my $function_name= $field_number;
 #---- 200$a for isbn
 #---- 200$b for editor
 #---- 200$c (repeated) for collections
- my $sth 
-= $dbh->prepare("select auth_subfield_table.authid,subfieldvalue from auth_subfield_table 
-                        left join auth_header on auth_subfield_table.authid=auth_header.authid
-                        where authtypecode='EDITORS' and tag='200' and subfieldcode='a'");
- my $sth2
- = $dbh->prepare("select subfieldvalue from auth_subfield_table where tag='200' and subfieldcode='b' and authid=?");
-$sth->execute;
-my @editors;
-my $authoritysep = C4::Context->preference("authoritysep");
-while (my ($authid,$isbn) = $sth->fetchrow) {
-    $sth2->execute($authid);
-    my ($editor) = $sth2->fetchrow;
-    push(@editors,"$isbn $authoritysep $editor");
-}
+
+
 my $res  = "
 <script type=\"text/javascript\">
 function Focus$function_name(index) {
-var isbn_array = [ ";
-foreach my $editor (@editors) {
-    my @arr = split (/ $authoritysep /,$editor);
-    $res .='["'.$arr[0].'","'.$arr[1].'","'.$arr[2].'"],';
-}
-chop $res;
-$res .= "
-];
-    // search isbn subfield. it''s 010a
-    var isbn_found;
-    var nb_fields = document.f.field_value.length;
-    for (i=0 ; i< nb_fields; i++) {
-        if (document.f.tag[i].value == '010' && document.f.subfield[i].value == 'a') {
-            isbn_found=document.f.field_value[i].value;
-            break;
-        }
-    }
-    try{
-        isbn_found.getAttribute('value'); // throw an exception if doesn't (if no 010a)
-    }
-    catch(e){
-        return;
-    }
-    for (i=0;i<=isbn_array.length;i++) {
-        if (isbn_found.substr(0,isbn_array[i][0].length) == isbn_array[i][0]) {
-            document.f.field_value[index].value =isbn_array[i][1];
-        }
-    }
+
 }
 
 function Blur$function_name(subfield_managed) {
@@ -116,7 +79,7 @@ function Blur$function_name(subfield_managed) {
 
 function Clic$function_name(subfield_managed) {
     defaultvalue=escape(document.getElementById(\"$field_number\").value);
-    newin=window.open(\"../cataloguing/plugin_launcher.pl?plugin_name=unimarc_field_210c.pl&index=\"+subfield_managed,\"unimarc 225a\",'width=500,height=600,toolbar=false,scrollbars=yes');
+    newin=window.open(\"../cataloguing/plugin_launcher.pl?plugin_name=unimarc_field_210c.pl&index=\"+subfield_managed,\"unimarc_225a\",'width=500,height=600,toolbar=false,scrollbars=yes');
 }
 </script>
 ";
@@ -138,12 +101,12 @@ my ($input) = @_;
     my $category = $query->param('category');
     my $resultstring = $query->param('result');
     my $dbh = C4::Context->dbh;
-    
+
     my $startfrom=$query->param('startfrom');
     $startfrom=0 if(!defined $startfrom);
     my ($template, $loggedinuser, $cookie);
     my $resultsperpage;
-    
+
     my $authtypes = getauthtypes;
     my @authtypesloop;
     foreach my $thisauthtype (keys %$authtypes) {
@@ -163,35 +126,43 @@ my ($input) = @_;
         my @operator = $query->param('operator');
         my @value = $query->param('value');
         my $orderby   = $query->param('orderby');
-        
+
         $resultsperpage= $query->param('resultsperpage');
         $resultsperpage = 19 if(!defined $resultsperpage);
-    
+
         # builds tag and subfield arrays
         my @tags;
-    
+
         my ($results,$total) = SearchAuthorities( \@tags,\@and_or,
                                             \@excluding, \@operator, \@value,
                                             $startfrom*$resultsperpage, $resultsperpage,$authtypecode, $orderby);
-                                            
+
+       # Getting the $b if it exists
+       for (@$results) {
+           my $authority = GetAuthority($_->{authid});
+               if ($authority->field('200') and $authority->subfield('200','b')) {
+                   $_->{to_report} = $authority->subfield('200','b');
+           }
+       }
+
         ($template, $loggedinuser, $cookie)
             = get_template_and_user({template_name => "cataloguing/value_builder/unimarc_field_210c.tmpl",
                     query => $query,
                     type => 'intranet',
                     authnotrequired => 0,
-                    flagsrequired => {editcatalogue => 1},
+                    flagsrequired => {editcatalogue => '*'},
                     debug => 1,
                     });
-    
+
         # multi page display gestion
         my $displaynext=0;
         my $displayprev=$startfrom;
         if(($total - (($startfrom+1)*($resultsperpage))) > 0 ) {
             $displaynext = 1;
         }
-    
+
         my @numbers = ();
-    
+
         if ($total>$resultsperpage) {
             for (my $i=1; $i<$total/$resultsperpage+1; $i++) {
                 if ($i<16) {
@@ -203,17 +174,17 @@ my ($input) = @_;
                 }
             }
         }
-    
+
         my $from = $startfrom*$resultsperpage+1;
         my $to;
-    
+
         if($total < (($startfrom+1)*$resultsperpage)) {
             $to = $total;
         } else {
             $to = (($startfrom+1)*$resultsperpage);
         }
         my $link="../cataloguing/plugin_launcher.pl?plugin_name=unimarc_field_210c.pl&amp;authtypecode=EDITORS&and_or=$and_or&amp;marclist=$marclist&amp;operator=$operator&amp;orderby=$orderby&amp;excluding=$excluding&amp;".join("&amp;",map {"value=".$_} @value)."&amp;op=do_search&amp;type=intranet&amp;index=$index";
-        warn "$link ,".getnbpages($total, $resultsperpage);
+
         $template->param(result => $results) if $results;
         $template->param('index' => $query->param('index'));
         $template->param(startfrom=> $startfrom,
@@ -241,18 +212,18 @@ my ($input) = @_;
                     query => $query,
                     type => 'intranet',
                     authnotrequired => 0,
-                    flagsrequired => {editcatalogue => 1},
+                    flagsrequired => {editcatalogue => '*'},
                     debug => 1,
                     });
-    
+
         $template->param(index => $index,
                         resultstring => $resultstring
                         );
     }
-    
+
     $template->param(authtypesloop => \@authtypesloop);
     $template->param(category => $category);
-    
+
     # Print the page
     output_html_with_http_headers $query, $cookie, $template->output;
 }