ERROR - no rows returned

"; echo "

ERREUR - aucun livre ne correspond

"; exit; } } function pg_display ($col1,$col2="",$col3="",$col4="",$col5="",$col6="",$col7="") { global $conn,$result_set; $rows=pg_NumRows($result_set); print ""; for ($j=0; $j < $rows; $j++) { print ""; if ($col2 != "") { echo "";} if ($col3 != "") { echo "";} if ($col4 != "") { echo "";} if ($col5 != "") { echo "";} if ($col6 != "") { echo "";} if ($col7 != "") { echo "";} print ""; } print "

$col1	$col2	$col3	$col4	$col5	$col6	$col7
"; echo pg_result($result_set, $j, "$col1"); print "	".pg_result($result_set, $j, "$col2")."	".pg_result($result_set, $j, "$col3")."	".pg_result($result_set, $j, "$col4")."	".pg_result($result_set, $j, "$col5")."	".pg_result($result_set, $j, "$col6")."	".pg_result($result_set, $j, "$col7")."

"; } function pg_showfield ($field,$fieldname,$j,$extra="") { global $result_set; $field_content = pg_result($result_set, $j, "$field"); if ($field_content) { echo "$fieldname$field_content"; if ($extra) {echo " $extra" ;}; echo ""; }; } if ($module=='acquisition'){ print "

acquisition

Modifies realkey $realkey

"; $result_set = pg_Exec($conn,"update titles set title='$title', author='$author',synonyms='$synonyms',publisher='$publisher', responsibility='$responsibility',call_number='$call_number', date='$date',value='$value',new_copies='$new_copies', reading_level='$reading_level',title_loan_code='$title_loan_code', illustrator='$illustrator',translator='$translator', series='$series',series_number='$series_number',subject='$subject', uniform_title='$uniform_title',added_title='$added_title', collation='$collation',frequency='$frequency', last_updated='$last_updated',last_updated_by='$last_updated_by', status='$status' where realkey=$realkey"); $m1 = pg_ErrorMessage($conn); $m2 = pg_NumRows($result_set); } if (! $m1 && ! $m2) {echo "

Success!

$m1

$m2

Recherche: $all $title $author $subject

$rows items

Details

SQL: $sql

Inventaire

Help

Basic Instructions:

1. research : see advanced searching below for more, NOTE: pure numbers search barcodes and realkeys
2. overdues : just enter the grade
3. circulation: enter how many barcodes you want to process at a time per borrower
4. search: if you put a number, it will search for that barcode
5. search: if you put a number followed by an r, it searches that realkey

Advanced Searching:

the following is for very advanced searches ... if you dare :-)

  ";
  system("man regex");
}

if ($module=="returns") {
   echo "
Returns
             

          
           
returned barcode:
          
          
          
          

          
          
     ";
}

if ($module=="circ_return") {
   echo "
Circulation Returns
";
   $conn = pg_Connect("host=localhost user=vernier dbname=eduml");
   if (!$barcode) {echo "missing barcode";exit;   }
   $result_set=pg_Exec($conn,"select * from barcodes where barcode = $barcode");
   if (pg_NumRows($result_set)) {$realkey = pg_result($result_set,0,'realkey');}
   else { echo "There is no barcode $barcode in this library!"; exit;}
   $result_set=pg_Exec($conn,"select * from titles where realkey=$realkey");
   if (pg_NumRows($result_set)) {
        $title = pg_result($result_set,0,'title');
        $call_number = pg_result($result_set,0,'call_number');
   } 
   else { echo "There is no realkey $realkey in this library!"; exit;}
   $result_set = pg_Exec($conn,"select * from circulation where barcode = $barcode");
   if (pg_NumRows($result_set)) {
      pg_display("borrower","barcode","date_begin","date_due");
      $borrower = pg_result($result_set,0,'borrower');
      $date_due = pg_result($result_set,0,'date_due');
      $date_begin = pg_result($result_set,0,'date_begin');
      $result_set2 =pg_Exec($conn,"insert into history (barcode,borrower,date_due,date_begin,date_returned)
         values ($barcode,'$borrower','$date_due','$date_begin','now')");
      $result_set2 =pg_Exec($conn,"delete from circulation where 
              borrower = '$borrower' and barcode = $barcode");
      if (! $error=pg_ErrorMessage($conn)) {
	 echo "succesfully returned item $barcode:\n $call_number $title" ;
      } else {echo $error;};
   } else {
         echo "Problem: $call_number : $title";
         echo "(barcode $barcode) was not signed out 
          and yet you are trying to return it ...";};
   $result_set = pg_Exec($conn,"select * from circulation");
   echo "
".pg_NumRows($result_set)." items still on loan";   
#   echo "

#         

#         
";
   echo "
More Returns
               

            
            
returned barcode:
            
            
            
            

            
            
            ";
}

if ($module=="circulation") {
   echo "
Circulation
";
   $date_due=`cat /var/web/vn/.overdue`;
   #$date_due=`date --date "14 days"`;
   print "

         
date due:
          
borrower:
           
";
   if (! ereg("^([0-9]+)$",$all)) {$all=10;};
   for ($i=0;$i<$all;$i++) {      
        print "
barcode:";
   }
   print" 
          
          
          

          
          
          ";
}

if ($module=="circ_proc") {$i=0;
  echo "
Circulation Processing
";
  `echo $date_due >/var/web/vn/.overdue`;
  $conn = pg_Connect("host=localhost user=vernier dbname=eduml");
  if (!$borrower) {echo "missing borrower or barcode";exit;   }
  $result_set = pg_Exec($conn,"select * from people where login = '$borrower' 
                               OR local_id = '$borrower'");
  if (!pg_NumRows($result_set)==1) {echo "No such borrower: $borrower"; exit  ;}
  else { 
      $given = pg_result($result_set,0,"given"); 
      $family = pg_result($result_set,0,"family"); 
      $grade = pg_result($result_set,0,"grade"); 
      print "
 $given $family $grade 
";
  };
  while ($barcode[$i]) { # START OF BARCODE LOOP
   $result_set=pg_Exec($conn,"select * from barcodes where barcode = '$barcode[$i]'");
   if (pg_NumRows($result_set)) {$realkey = pg_result($result_set,0,'realkey');} 
   else { echo "
Barcode $barcode[$i] NOT in this library!"; break;}
   $result_set=pg_Exec($conn,"select * from titles where realkey=$realkey");
   if (pg_NumRows($result_set)) {
        $title = pg_result($result_set,0,'title');
        $call_number = pg_result($result_set,0,'call_number');
   } 
   else { echo "
Realkey $realkey NOT in this library!"; break;}
   $result_set = pg_Exec($conn,"select * from circulation where barcode = $barcode[$i]");
   if (pg_NumRows($result_set)) {
      echo "
Processing Renewal for $borrower with Barcode $barcode[$i] ";
      pg_display("borrower","barcode","date_begin","date_due");
      $borrower_old = pg_result($result_set,0,'borrower');#to allow others to renew
      $date_due_old = pg_result($result_set,0,'date_due');
      $date_begin_old = pg_result($result_set,0,'date_begin');
      $result_set2 =pg_Exec($conn,"insert into history (barcode,borrower,date_due,date_begin,date_returned)
	         values ($barcode[$i],'$borrower_old','$date_due_old','$date_begin_old','now')");
      $result_set2 =pg_Exec($conn,"delete from circulation where
                borrower = '$borrower' and barcode = $barcode[$i]");
      if (! $error=pg_ErrorMessage($conn)) {
	          echo "
renewing item $barcode[$i]:\n
" ;
       } else {echo $error;};
      }
   if (! $error=pg_ErrorMessage($conn)) {
      echo "
Barcode $barcode[$i] loaned 
$call_number $title
" ;
      $date_begin=`date`;
      #$date_due=`date --date "15 days"`;
      $result_set = pg_Exec($conn,"insert into circulation (barcode,borrower,date_begin,date_due)
                  values ($barcode[$i],'$borrower','$date_begin','$date_due')");
   }else {echo $error;}
  $i++;
  }
   $result_set = pg_Exec($conn,"
        select date_due,title,call_number,local_id,barcodes.barcode as barcode
        from circulation,people,barcodes,titles
        where (borrower='$borrower' OR local_id='$borrower') 
	and (borrower=login OR borrower=local_id)
        and barcodes.barcode = circulation.barcode
        and barcodes.realkey = titles.realkey
        order by date_due,call_number");
  if ($rows = pg_NumRows($result_set)) {
     echo "
$given now has $rows titles out:
";
     echo pg_display(date_due,barcode,call_number,title);
  }
  echo "

        
        
";
  echo "

        
        
";
}

if ($module=="acquisition") {
   echo "
New Books
";
}
if ($module=="reservation") {
   echo "
Reservations
";
}
if ($module=="overdues") {
   if ($all) {$cond=" and grade='$all' " ;} else {$cond ="";};
   echo "
Overdues $all
";
   $conn = pg_Connect("host=localhost user=vernier dbname=eduml");
   $result_set = pg_Exec($conn,"
          select grade,family||', '||given as name,login,date_due,title,call_number,barcodes.barcode as barcode
          from circulation,people,barcodes,titles  
          where date_due::abstime <= datetime('now'::abstime) $cond 
          and (borrower=login OR borrower=local_id) 
          and barcodes.barcode = circulation.barcode 
          and barcodes.realkey = titles.realkey
          order by grade,family");
   if ( $result_set) {
      echo "There are " . pg_NumRows($result_set) . " overdues";
      echo "
".pg_display(grade,name,date_due,barcode,call_number,title).
          "

          
          
";
   }
}
if ($module=="labels") {
   echo "
Labels
";
}
if ($module=="problems") {
   echo "
Barcodes
";
   print "
";
#   print "
Realkey: 
#          
Barcode: 
#          
#          
#          
";
   require("table.inc"); $t = new Table; $db = new DB_Sql;
   print "Titles that do not have barcodes:";
   $result_set=$db -> query ("SELECT realkey,call_number,title 
           FROM titles WHERE status is null and NOT EXISTS
           (SELECT realkey FROM barcodes WHERE realkey = titles.realkey) 
           order by call_number");
   print " ".$db -> nf() . " items";
   pg_display("realkey","call_number","title");
   $t -> show_result($db,"");
   print "Barcodes associated to unknown titles:";
   $result_set=$db -> query ("select realkey,copies,barcode FROM barcodes WHERE 
                   NOT EXISTS (SELECT realkey FROM titles 
		   WHERE realkey = barcodes.realkey) 
                   order by realkey");
   print " " . $db -> nf() . " items";
   pg_display("realkey","copies","barcode");
   print "

          
          
";
   
   
}
if ($module=="newbarcode") {
   echo "
New Barcode $barcode for $realkey
";
   $conn = pg_Connect("host=localhost user=vernier dbname=eduml");
   $result_set = pg_Exec($conn,"select * from barcodes where barcode = $barcode;");
   if (pg_NumRows($result_set)) {echo "
ERROR: barcode $barcode 
                   already associated to realkey: ".
                            pg_result($result_set,0,"realkey");exit;};
   $result_set = pg_Exec($conn,"select * from titles where realkey = $realkey;");
   if (!pg_NumRows($result_set)) {echo "
ERROR: realkey $realkey 
                            DOES NOT EXIST in titles database";exit;};
   $result_set = pg_Exec($conn,"select * from barcodes where realkey = $realkey;");
   $copies = pg_NumRows($result_set); $copies++;
   echo "
realkey $realkey now has $copies copie(s)";
   $result_set = pg_Exec($conn,"insert into barcodes (realkey, copies, barcode)
                  values ($realkey, $copies, $barcode);");
   echo pg_ErrorMessage($conn);

   

}

if ($module=="statistics") {
   echo "
Statistics
";
   require("table.inc"); $t = new Table; $db = new DB_Sql;
   print "Number of Titles on Loan per Borrower:";
   $db -> query ("select distinct borrower,count(*) from circulation
                   group by borrower order by borrower");
   $t -> show_result($db,"");
   echo   "

          
          
";
}


if ($module=="borrowers") {
   echo "
Borrowers
";
}
if ($module=="stopwords") {
   echo "
Stopwords
";
}
if ($module=="") {
echo "";
   echo "
Search
";
   print " 



Any Keyword

        ";
#
Titre......

#
Auteur.....

#
Subject....

#

#    print "
 
   print "
 
   research   
   returns
   overdues
   circulation
   statistics 
   problems
   help

   acquisition 




 

 




";

}
#quarantine
#passthru('psql -c "select * from missing_barcodes order by call_number;" -H -d eduml',$asdf);

page_close(); ?>