echo "<a href=\"javascript:changePage(" . H(addslashes($i)) . ",'" . H(addslashes($sort)) . "')\">" . H($i) . "</a> "; } } elseif ($i == $maxPg) { echo "... "; } } if ($currPage < $pageCount) { echo "<a href=\"javascript:changePage(" . ($currPage + 1) . ",'" . $sort . "')\">" . $loc->getText("biblioSearchNext") . "»</a> "; } } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $collectionDm = $dmQ->getAssoc("collection_dm"); $materialTypeDm = $dmQ->getAssoc("material_type_dm"); $materialImageFiles = $dmQ->getAssoc("material_type_dm", "image_file"); $biblioStatusDm = $dmQ->getAssoc("biblio_status_dm"); $dmQ->close(); #**************************************************************************** #* Retrieving post vars and scrubbing the data #**************************************************************************** if (isset($_POST["page"])) { $currentPageNmbr = $_POST["page"]; } else { $currentPageNmbr = 1; } $searchType = $_POST["searchType"]; $sortBy = $_POST["sortBy"]; if ($sortBy == "default") {
#* Checking for get vars. Go back to form if none found. #**************************************************************************** if (count($_GET) == 0) { header("Location: ../circ/index.php"); exit; } #**************************************************************************** #* Retrieving get var #**************************************************************************** $mbrid = $_GET["mbrid"]; #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $mbrClassifyDm = $dmQ->getAssoc("mbr_classify_dm"); $biblioStatusDm = $dmQ->getAssoc("biblio_status_dm"); $materialTypeDm = $dmQ->getAssoc("material_type_dm"); $materialImageFiles = $dmQ->getAssoc("material_type_dm", "image_file"); $dmQ->close(); #**************************************************************************** #* Search database for member history #**************************************************************************** $histQ = new BiblioStatusHistQuery(); $histQ->connect(); if ($histQ->errorOccurred()) { $histQ->close(); displayErrorPage($histQ); } if (!$histQ->queryByMbrid($mbrid)) { $histQ->close();
<?php /* This file is part of a copyrighted work; it is distributed with NO WARRANTY. * See the file COPYRIGHT.html for more details. */ require_once "../functions/inputFuncs.php"; require_once '../classes/DmQuery.php'; require_once '../classes/SchoolQuery.php'; require_once '../classes/School.php'; $dmQ = new DmQuery(); $dmQ->connect(); $mbrClassifyDm = $dmQ->getAssoc('mbr_classify_dm'); $customFields = $dmQ->getAssoc('member_fields_dm'); $dmQ->close(); $gender = array(OBIB_GENDER_MALE => "Male", OBIB_GENDER_FEMALE => "Female"); $standardlevel = array(1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5, 6 => 6, 7 => 7, 8 => 8, 9 => 9, 10 => 10); $standardGrade = array('' => 'none', 'A' => 'A', 'B' => 'B', 'C' => 'C', 'D' => 'D', 'E' => 'E', 'F' => 'F', 'G' => 'G', 'H' => 'H', 'I' => 'I', 'J' => 'J', 'K' => 'K', 'L' => 'L', 'M' => 'M', 'N' => 'N', 'O' => 'O', 'P' => 'P', 'Q' => 'Q', 'R' => 'R', 'S' => 'S', 'T' => 'T', 'U' => 'U', 'V' => 'V', 'W' => 'W', 'X' => 'X', 'Y' => 'Y', 'Z' => 'Z'); $scQ = new SchoolQuery(); $scQ->connect(); $schoolList = $scQ->getSchoolList(); $scQ->close(); $fields = array("mbrFldsClassify" => inputField('select', 'classification', $mbr->getClassification(), NULL, $mbrClassifyDm), "mbrFldsLastName" => inputField('text', "lastName", $mbr->getLastName()), "mbrFldsFirstName" => inputField('text', "firstName", $mbr->getFirstName()), "mbrFldsGender" => inputField('select', "gender", $mbr->getGender(), Null, $gender), "mbrFldsSchool" => inputField('select', "school", $mbr->getSchoolId(), Null, $schoolList), "mbrFldsStandard" => inputField('select', "standard", $mbr->getStandard(), Null, $standardlevel), "mbrFldsStandardGrade" => inputField('select', "grade", $mbr->getGrade(), Null, $standardGrade), "mbrFldsSchoolTeacher" => inputField('text', "schoolTeacher", $mbr->getSchoolTeacher()), "mbrFldsParentName" => inputField('text', "parentname", $mbr->getParentName()), "mbrFldsParentOccupation" => inputField('text', "parentoccupation", $mbr->getParentOccupation()), "mbrFldsMotherTongue" => inputField('text', "mothertongue", $mbr->getMotherTongue()), "mbrFldsEmail" => inputField('text', "email", $mbr->getEmail()), "Mailing Address:" => inputField('textarea', "address", $mbr->getAddress()), "mbrFldsHomePhone" => inputField('text', "homePhone", $mbr->getHomePhone()), "mbrFldsWorkPhone" => inputField('text', "workPhone", $mbr->getWorkPhone())); foreach ($customFields as $name => $title) { $fields[$title . ':'] = inputField('text', 'custom_' . $name, $mbr->getCustom($name)); } ?> <table class="primary"> <tr> <th colspan="2" valign="top" nowrap="yes" align="left"> <?php
$loc = new Localize(OBIB_LOCALE, $tab); #**************************************************************************** #* Retrieving get var #**************************************************************************** $mbrid = $_GET["mbrid"]; if (isset($_GET["msg"])) { $msg = "<font class=\"error\">" . H($_GET["msg"]) . "</font><br><br>"; } else { $msg = ""; } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $mbrClassifyDm = $dmQ->getAssoc("mbr_classify_dm"); $materialTypeDm = $dmQ->getAssoc("material_type_dm"); $materialImageFiles = $dmQ->getAssoc("material_type_dm", "image_file"); $dmQ->close(); #**************************************************************************** #* Search database for member #**************************************************************************** $mbrQ = new MemberQuery(); $mbrQ->connect(); $mbr = $mbrQ->get($mbrid); $mbrQ->close(); #************************************************************************** #* Show member checkouts #************************************************************************** ?> <html>
} #**************************************************************************** #* Validate data #**************************************************************************** $bibid = $_POST["bibid"]; $copy = new BiblioCopy(); $copy->setBibid($bibid); $copy->setCopyDesc($_POST["copyDesc"]); $_POST["copyDesc"] = $copy->getCopyDesc(); $copy->setBarcodeNmbr($_POST["barcodeNmbr"]); $_POST["barcodeNmbr"] = $copy->getBarcodeNmbr(); $copy->setLocationid($_POST["location"]); $_POST["location"] = $copy->getCopyDesc(); $dmQ = new DmQuery(); $dmQ->connect(); $customFields = $dmQ->getAssoc('biblio_copy_fields_dm'); $dmQ->close(); foreach ($customFields as $name => $title) { if (isset($_REQUEST['custom_' . $name])) { $copy->setCustom($name, $_REQUEST['custom_' . $name]); } } $validBarco = $_POST["validBarco"]; $validData = $copy->validateData($validBarco); if (!$validData) { $pageErrors["barcodeNmbr"] = $copy->getBarcodeNmbrError(); $_SESSION["postVars"] = $_POST; $_SESSION["pageErrors"] = $pageErrors; header("Location: ../catalog/biblio_copy_new_form.php?bibid=" . U($bibid)); exit; }
} #**************************************************************************** #* Retrieving get var #**************************************************************************** $mbrid = $_GET["mbrid"]; if (isset($_GET["msg"])) { $msg = "<font class=\"error\">" . H($_GET["msg"]) . "</font><br><br>"; } else { $msg = ""; } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $mbrClassifyDm = $dmQ->getAssoc("mbr_classify_dm"); $mbrMaxFines = $dmQ->getAssoc("mbr_classify_dm", "max_fines"); $biblioStatusDm = $dmQ->getAssoc("biblio_status_dm"); $materialTypeDm = $dmQ->getAssoc("material_type_dm"); $materialImageFiles = $dmQ->getAssoc("material_type_dm", "image_file"); $memberFieldsDm = $dmQ->getAssoc("member_fields_dm"); $dmQ->close(); #**************************************************************************** #* Search database for member #**************************************************************************** $mbrQ = new MemberQuery(); $mbrQ->connect(); $mbr = $mbrQ->get($mbrid); $mbrQ->close(); #**************************************************************************** #* Check for outstanding balance due
require_once "../classes/UsmarcSubfieldDmQuery.php"; require_once "../functions/marcFuncs.php"; require_once "../classes/BiblioFieldQuery.php"; require_once "../classes/BiblioQuery.php"; // $loc = new Localize(OBIB_LOCALE,"shared"); if (isset($_GET["msg"])) { $msg = "<font class=\"error\">" . H($_GET["msg"]) . "</font><br><br>"; } else { $msg = ""; } #**************************************************************************** #* Loading a few domain tables into associative arrays marc #**************************************************************************** $LdmQ = new DmQuery(); $LdmQ->connect(); $collectionDm = $LdmQ->getAssoc("collection_dm"); $LmaterialTypeDm = $LdmQ->getAssoc("material_type_dm"); $LbiblioStatusDm = $LdmQ->getAssoc("biblio_status_dm"); $LdmQ->close(); $LmarcTagDmQ = new UsmarcTagDmQuery(); $LmarcTagDmQ->connect(); if ($LmarcTagDmQ->errorOccurred()) { $LmarcTagDmQ->close(); displayErrorPage($LmarcTagDmQ); } $LmarcTagDmQ->execSelect(); if ($LmarcTagDmQ->errorOccurred()) { $LmarcTagDmQ->close(); displayErrorPage($marcTagDmQ); } $LmarcTags = $LmarcTagDmQ->fetchRows();
echo "<a href=\"javascript:changePage(" . ($currPage + 1) . ")\">" . $loc->getText("mbrsearchnext") . "»</a> "; } } #**************************************************************************** #* Checking for post vars. Go back to form if none found. #**************************************************************************** if (count($_POST) == 0) { header("Location: ../circ/index.php"); exit; } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $mbrClassifyDm = $dmQ->getAssoc("mbr_classify_dm"); $dmQ->close(); #**************************************************************************** #* Retrieving post vars and scrubbing the data #**************************************************************************** if (isset($_POST["page"])) { $currentPageNmbr = $_POST["page"]; } else { $currentPageNmbr = 1; } $searchType = $_POST["searchType"]; $searchText = trim($_POST["searchText"]); # remove redundant whitespace $searchText = eregi_replace("[[:space:]]+", " ", $searchText); if ($searchType == "barcodeNmbr") { $sType = OBIB_SEARCH_BARCODE;
} #**************************************************************************** #* Retrieving get var #**************************************************************************** $mbrid = $_GET["mbrid"]; if (isset($_GET["msg"])) { $msg = "<font class=\"error\">" . H($_GET["msg"]) . "</font><br><br>"; } else { $msg = ""; } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $mbrClassifyDm = $dmQ->getAssoc("transaction_type_dm"); $dmQ->close(); #**************************************************************************** #* Show transaction input form #**************************************************************************** require_once "../shared/header.php"; ?> <?php echo $msg; ?> <form name="accttransform" method="POST" action="../circ/mbr_transaction.php"> <table class="primary"> <tr> <th colspan="2" valign="top" nowrap="yes" align="left">
require_once "../classes/Localize.php"; $loc = new Localize(OBIB_LOCALE, $tab); #**************************************************************************** #* Get Status Message #**************************************************************************** if (isset($_GET["msg"])) { $msg = "<font class=\"error\">" . H($_GET["msg"]) . "</font><br><br>"; } else { $msg = ""; } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $biblioStatusDm = $dmQ->getAssoc("biblio_status_dm"); $dmQ->close(); #**************************************************************************** #* Retrieving get var #**************************************************************************** $bibid = $_GET["bibid"]; #**************************************************************************** #* Show page #**************************************************************************** require_once "../shared/header.php"; ?> <h1><?php echo $loc->getText("biblioHoldListHead"); ?> </h1> <?php
$loc = new Localize(OBIB_LOCALE, "shared"); #**************************************************************************** #* Retrieving get var #**************************************************************************** $bibid = $_GET["bibid"]; if (isset($_GET["msg"])) { $msg = "<font class=\"error\">" . H($_GET["msg"]) . "</font><br><br>"; } else { $msg = ""; } #**************************************************************************** #* Loading a few domain tables into associative arrays #**************************************************************************** $dmQ = new DmQuery(); $dmQ->connect(); $collectionDm = $dmQ->getAssoc("collection_dm"); $materialTypeDm = $dmQ->getAssoc("material_type_dm"); $biblioStatusDm = $dmQ->getAssoc("biblio_status_dm"); $customFields = $dmQ->getAssoc('biblio_copy_fields_dm'); // JALG from ALX 11-07-2015 $dmQ->close(); $marcTagDmQ = new UsmarcTagDmQuery(); $marcTagDmQ->connect(); if ($marcTagDmQ->errorOccurred()) { $marcTagDmQ->close(); displayErrorPage($marcTagDmQ); } $marcTagDmQ->execSelect(); if ($marcTagDmQ->errorOccurred()) { $marcTagDmQ->close(); displayErrorPage($marcTagDmQ);
$_POST["cel"] = $mbr->getCel(); $mbr->setEmail($_POST["email"]); $_POST["email"] = $mbr->getEmail(); $mbr->setFoto($_POST["foto"]); $_POST["foto"] = $mbr->getFoto(); $mbr->setPassUser($_POST["passUser"]); $_POST["passUser"] = $mbr->getPassUser(); $mbr->setBornDt($_POST["bornDt"]); $_POST["bornDt"] = $mbr->getBornDt(); $mbr->setOther($_POST["other"]); $_POST["other"] = $mbr->getOther(); $mbr->setClassification($_POST["classification"]); $mbr->setStatus($_POST["status"]); $dmQ = new DmQuery(); $dmQ->connect(); $customFields = $dmQ->getAssoc('member_fields_dm'); $dmQ->close(); foreach ($customFields as $name => $title) { if (isset($_REQUEST['custom_' . $name])) { $mbr->setCustom($name, $_REQUEST['custom_' . $name]); } } $validData = $mbr->validateDataUser(); if (!$validData) { $pageErrors["barcodeNmbr"] = $mbr->getBarcodeNmbrError(); $pageErrors["lastName"] = $mbr->getLastNameError(); $pageErrors["firstName"] = $mbr->getFirstNameError(); $pageErrors["status"] = $mbr->getStatusError(); $_SESSION["postVars"] = $_POST; $_SESSION["pageErrors"] = $pageErrors; header("Location: ../user/user_edit_form.php");
$biblio = new BiblioQuery(); $biblio->delete($bib_id); $count++; } } echo '<div id="message"><font class="error">'; if ($count == 1) { echo $count . ' ' . $locsh->getText("sharedRecordIsDeleted"); } elseif ($count > 1) { echo $count . ' ' . $locsh->getText("sharedRecordsAreDeleted"); } echo '</font></div>'; } $dmQ = new DmQuery(); $dmQ->connect(); $collectionDm = $dmQ->getAssoc("collection_dm"); $materialTypeDm = $dmQ->getAssoc("material_type_dm"); $dmQ->close(); /* print_r($dmQ); */ $biblioQ = new BiblioSearchQuery(); $biblioQ->setItemsPerPage(500); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } $sType = 'title'; $words = ''; $currentPageNmbr = isset($_POST["page"]) ? $_POST["page"] : 1;
function run_batch($lines, $date) { $rowcount = 0; $b = array(); while (count($lines)) { $columns = str_getcsv(array_shift($lines), ",", "\""); /* Column 0 is for the serial number */ if ($columns[0] == 'S No') { continue; } $rowcount++; if (strlen(trim($columns[0])) == 0) { //add title to an array $b[$rowcount] = "Record " . $rowcount . " Barcode/Serial No not entered."; continue; } /*column 1 is for the title*/ if (strlen(trim($columns[1])) == 0) { $b[$rowcount] = "Record " . $rowcount . " Title not entered."; continue; } else { $columns[1] = str_replace("'", "\\'", $columns[1]); } /*column 2 is for the author*/ $columns[2] = str_replace("'", "\\'", $columns[2]); $import = new ImportQuery(); $dmQ = new DmQuery(); $collectionDesc = $dmQ->getAssoc("collection_dm", "description"); $materials = $dmQ->getAssoc("material_type_dm", "description"); $statuses = $dmQ->getAssoc("biblio_status_dm", "description"); /*column 3 is for the circulation status(in- active,ina- inactive,lst-damaged)*/ $status_found = false; foreach ($statuses as $code => $status) { if (strcmp($columns[3], $status) == 0) { $columns[3] = $code; $status_found = true; } } if (strlen(trim($columns[3])) == 0 || status_found == false) { $columns[3] = "in"; } /*column 4 is for Category , column 5 is for Type*/ foreach ($collectionDesc as $code => $collection) { if (strcmp($columns[4] . " " . $columns[5], $collection) == 0) { $columns[4] = $code; } } if (strlen(trim($columns[4])) == 0) { $columns[4] = '1'; } /*column 6 is for Medium(book,video/dvd,magazine)*/ foreach ($materials as $code => $collection) { if (strcmp($columns[6], $collection) == 0) { $columns[6] = $code; } } if (strlen(trim($columns[6])) == 0) { $columns[6] = '2'; } /*column 7 is for comments*/ if (strlen(trim($columns[7])) == 0) { $columns[7] = ' '; } /*column 8 is for location id*/ if (strlen(trim($columns[8]) == 0) || !is_numeric($columns[8])) { $columns[8] = null; } $bibid = $import->alreadyInDB($columns[1]); if ($bibid == 0) { $lastinsertid = $import->insertBiblio($columns); if ($lastinsertid == 0) { //add title to an array $b[$rowcount] = "Record " . $rowcount . " Unknown error."; continue; } $import->insertBiblioCopy($columns, $lastinsertid); } else { $import->insertBiblioCopy($columns, $bibid); } } return $b; }