Пример #1
0
function output_compilation_titles_and_authors($record, $output_type = "detail", $show_pages = TRUE, $search_words = array())
{
    global $db;
    $author_list = array();
    $main_author_records = lookup_author($record->ID, FALSE, TRUE);
    //$hide_main_author_ID = (count($main_author_records) == 1 ? $main_author_records[0]->ID : 0);
    $hide_main_author_ID = $main_author_records[0]->ID;
    if (count($author_records = lookup_author($record->ID, TRUE, TRUE))) {
        $last_section_title = "";
        $last_section_start = -1;
        $last_author_type = 0;
        $hold_section_start = -1;
        $output_title = FALSE;
        $delayed_author_html = "";
        foreach ($author_records as $author_record) {
            $this_section_title = $author_record->section_title;
            $this_section_start = $author_record->section_start;
            $this_by_text = $author_record->by_text;
            if ($hold_section_start == -1) {
                $last_section_title = $this_section_title;
                $hold_section_title = $this_section_title;
                $hold_section_start = $this_section_start;
            }
            // end if
            $this_author_type = $author_record->type;
            if ($output_title) {
                $output_pages = $last_section_start - $hold_section_start;
                ?>
				<div class="<?php 
                echo $output_type;
                ?>
_compilation_title"><?php 
                echo highlight_search_query($output_title_text, $search_words);
                if ($show_pages && $author_record->section_start > 0) {
                    ?>
 <span class="<?php 
                    echo $output_type;
                    ?>
_compilation_pages">(<?php 
                    echo $output_pages == 0 ? "1" : $output_pages;
                    ?>
 page<?php 
                    echo $output_pages > 1 ? "s" : "";
                    ?>
)</span><?php 
                }
                // end if
                ?>
</div>
				<?php 
                if ($delayed_author_html != "") {
                    echo $delayed_author_html;
                    $delayed_author_html = "";
                }
                // end if
                $output_title = FALSE;
                $hold_section_start = $last_section_start;
            }
            // end if
            if ($this_section_title != $last_section_title) {
                if (count($author_list) > 0) {
                    $delayed_author_html .= '<div class="' . $output_type . '_compilation_author">' . $last_by_text . ' ' . implode("; ", $author_list) . '</div>';
                }
                // end if
                $author_list = array();
                if ($author_record->ID != $hide_main_author_ID) {
                    $author_list[] = '<a href="' . $db->url_root . '/search.php/author/' . $author_record->ID . '">' . highlight_search_query(build_author_name($author_record), $search_words) . '</a>';
                }
                // end if
                $output_title_text = $last_section_title;
                $output_title = TRUE;
            } else {
                if ($this_author_type != $last_author_type && $last_author_type != 0) {
                    if (count($author_list) > 0) {
                        $delayed_author_html .= '<div class="' . $output_type . '_compilation_author">' . $last_by_text . ' ' . implode("; ", $author_list) . '</div>';
                    }
                    // end if
                    $author_list = array();
                }
                // end if
                if ($author_record->ID != $hide_main_author_ID) {
                    $author_list[] = '<a href="' . $db->url_root . '/search.php/author/' . $author_record->ID . '">' . highlight_search_query(build_author_name($author_record), $search_words) . '</a>';
                }
                // end if
            }
            // end if
            $last_section_start = $this_section_start;
            $last_section_title = $this_section_title;
            $last_by_text = $this_by_text;
            $last_author_type = $this_author_type;
        }
        // end foreach
        if ($output_title) {
            $output_pages = $last_section_start - $hold_section_start;
            ?>
			<div class="<?php 
            echo $output_type;
            ?>
_compilation_title"><?php 
            echo highlight_search_query($output_title_text, $search_words);
            if ($show_pages && $author_record->section_start > 0) {
                ?>
 <span class="<?php 
                echo $output_type;
                ?>
_compilation_pages">(<?php 
                echo $output_pages == 0 ? "1" : $output_pages;
                ?>
 page<?php 
                echo $output_pages > 1 ? "s" : "";
                ?>
)</span><?php 
            }
            // end if
            ?>
</div>
			<?php 
            if ($delayed_author_html != "") {
                echo $delayed_author_html;
                $delayed_author_html = "";
            }
            // end if
            $output_title = FALSE;
            $hold_section_start = $last_section_start;
        }
        // end if
        $output_pages = $record->length - $last_section_start + 1;
        ?>
		<div class="<?php 
        echo $output_type;
        ?>
_compilation_title"><?php 
        echo highlight_search_query($this_section_title, $search_words);
        if ($show_pages && $author_record->section_start > 0) {
            ?>
 <span class="<?php 
            echo $output_type;
            ?>
_compilation_pages">(<?php 
            echo $output_pages == 0 ? "1" : $output_pages;
            ?>
 page<?php 
            echo $output_pages > 1 ? "s" : "";
            ?>
)</span><?php 
        }
        // end if
        ?>
</div>
		<?php 
        if (count($author_list) > 0) {
            if ($delayed_author_html != "") {
                echo $delayed_author_html;
            }
            // end if
            ?>
			<div class="<?php 
            echo $output_type;
            ?>
_compilation_author"><?php 
            echo $author_record->by_text;
            ?>
 <?php 
            echo implode("; ", $author_list);
            ?>
</div>
			<?php 
        }
        // end if
    }
    // end if
}
Пример #2
0
<?php

include_once dirname(__FILE__) . "/first.php";
$item_ID = $query[0];
$item_barcode = $query[1];
if (strlen(trim($item_barcode)) != $db->barcode_length || substr(trim($item_barcode), 0, 1) != $db->barcode_item_prefix) {
    exit_error("Invalid Barcode: " . $item_barcode, "The barcode you entered is not valid.");
}
// end if
$barcode_sql = "\n\tSELECT\n\t\t*\n\tFROM\n\t\t`" . $db->table_library_item . "`\n\tWHERE\n\t\t`barcode`='" . mysql_escape_string(trim($item_barcode)) . "'\n\t\tAND `ID`!='" . $item_ID . "'\n";
$barcode_result = mysql_query($barcode_sql, $mysql->link);
if (mysql_num_rows($barcode_result) > 0) {
    exit_error("Duplicate Barcode: " . $item_barcode, "The barcode you entered is already in use.");
}
// end if
$sql = "\n\tSELECT\n\t\t*\n\tFROM\n\t\t`" . $db->table_library_item . "`\n\tWHERE\n\t\t`ID`='" . $item_ID . "'\n";
$result = mysql_query($sql, $mysql->link);
$record = mysql_fetch_object($result);
if ($record->{$db->field_category_ID} == 16 || $record->{$db->field_category_ID} == 7 || $record->call_number == "E" || substr($record->call_number, 0, 2) == "E,") {
    $authors = lookup_author($record->ID);
    $new_call_number = "E," . strtoupper(substr($authors[0]->last_name, 0, 3));
} else {
    $new_call_number = $record->call_number;
}
// end if
$sql = "\n\tUPDATE\n\t\t`" . $db->table_library_item . "`\n\tSET\n\t\t`barcode`='" . mysql_escape_string($item_barcode) . "',\n\t\t`call_number`='" . $new_call_number . "'\n\tWHERE\n\t\t`ID`='" . $item_ID . "'\n";
//exit($sql);
mysql_query($sql, $mysql->link);
header("location:" . $db->url_root . "/item_details.php/barcode/" . $item_barcode);
exit;
Пример #3
0
// end if
?>
</div>
						<?php 
if ($record->parallel_title != "") {
    ?>
								<div class="detail_parallel_title"><?php 
    echo $record->parallel_title;
    ?>
</div>
								<?php 
}
// end if
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// NON-COMPILATION AUTHORS
if (count($author_records = lookup_author($record->ID, FALSE, TRUE))) {
    $author_list = array();
    $last_author_type = 0;
    foreach ($author_records as $author_record) {
        $this_by_text = $author_record->by_text;
        $this_author_type = $author_record->type;
        if ($this_author_type != $last_author_type && $last_author_type != 0) {
            ?>
										<div class="detail_authors"><?php 
            echo $last_by_text;
            ?>
 <?php 
            echo implode("; ", $author_list);
            ?>
</div>
										<?php