function executeSqlFile(&$installQ, $filename, $tablePrfx = "") { $fp = fopen($filename, "r"); # show error if file could not be opened if ($fp == false) { echo "Error reading file " . H($filename) . ".<br>\n"; return false; } else { $sqlStmt = ""; while (!feof($fp)) { $char = fgetc($fp); if ($char == ";") { //replace table prefix $sql = str_replace("%prfx%", $tablePrfx, $sqlStmt); echo "lara"; echo "process sql [" . $sqlStmt . "]<br>"; //test $result = $installQ->exec($sql); if ($installQ->errorOccurred()) { $installQ->close(); displayErrorPage($installQ); fclose($fp); return false; } $sqlStmt = ""; } else { $sqlStmt = $sqlStmt . $char; } } fclose($fp); return true; } }
function getTagDesc($tag, $subfldCd, &$tagDesc, &$subfldDesc, &$ind1Desc, &$ind2Desc) { $tagDesc = ""; $subfldDesc = ""; $ind1Desc = ""; $ind2Desc = ""; if ($tag != "") { $marcTagDmQ = new UsmarcTagDmQuery(); $marcTagDmQ->connect(); if ($marcTagDmQ->errorOccurred()) { $marcTagDmQ->close(); displayErrorPage($marcTagDmQ); } $marcTag = $marcTagDmQ->doQuery($tag); if ($marcTagDmQ->errorOccurred()) { $marcTagDmQ->close(); displayErrorPage($marcTagDmQ); } $marcTagDmQ->close(); if ($marcTag) { $tagDesc = $marcTag->getDescription(); $ind1Desc = $marcTag->getInd1Description(); $ind2Desc = $marcTag->getInd2Description(); # reading for subfield description $marcSubfldDmQ = new UsmarcSubfieldDmQuery(); $marcSubfldDmQ->connect(); if ($marcSubfldDmQ->errorOccurred()) { $marcSubfldDmQ->close(); displayErrorPage($marcSubfldDmQ); } $marcSubfld = $marcSubfldDmQ->doQuery($tag, $subfldCd); if ($marcSubfldDmQ->errorOccurred()) { $marcSubfldDmQ->close(); displayErrorPage($marcSubfldDmQ); } $marcSubfldDmQ->close(); if (!$marcSubfld) { $subfldDesc = ""; } else { $subfldDesc = $marcSubfld->getDescription(); } } } return true; }
function getCutter($aName) { ##### implementation of Cutter - Sanborn 3-digit table //echo "cutter input string: " . $aName . "<br />"; ## remove spaces from text before comparrison to table entries $aName = str_replace(" ", "", $aName); ## what follows, while simpler only works with mySQL ver 4.1 and later // $ctrQ = new ctrQuery(); // $ctrQ->connect(); // if ($ctrQ->errorOccurred()) { // $ctrQ->close(); // displayErrorPage($ctrQ); // } // // $ctrQ->execSelect($aName); // $result = $ctrQ->fetchfield('theNmbr'); // $ctrQ->close(); // return substr($aName,0,1) . $result; ## this more complex process works all the time. $ctrQ = new ctrQuery(); $ctrQ->connect(); if ($ctrQ->errorOccurred()) { $ctrQ->close(); displayErrorPage($ctrQ); } $rslt1 = $ctrQ->getNmbrPt1($aName); $ctrQ->close(); $ctrQ = new ctrQuery(); $ctrQ->connect(); if ($ctrQ->errorOccurred()) { $ctrQ->close(); displayErrorPage($ctrQ); } $rslt2 = $ctrQ->getNmbrPt2($rslt1); $ctrQ->close(); return substr($aName, 0, 1) . $rslt2; }
$set = $setQ->fetchRow(); $setQ->close(); /**************************************************************************** * Reading theme settings **************************************************************************** */ $themeQ = new ThemeQuery(); $themeQ->connect(); if ($themeQ->errorOccurred()) { $themeQ->close(); displayErrorPage($themeQ); } $themeQ->execSelect($set->getThemeid()); if ($themeQ->errorOccurred()) { $themeQ->close(); displayErrorPage($themeQ); } $theme = $themeQ->fetchTheme(); $themeQ->close(); /**************************************************************************** * general settings constants **************************************************************************** */ define("OBIB_LIBRARY_NAME", $set->getLibraryName()); define("OBIB_LIBRARY_HOURS", $set->getLibraryHours()); define("OBIB_LIBRARY_PHONE", $set->getLibraryPhone()); define("OBIB_LIBRARY_URL", $set->getLibraryUrl()); define("OBIB_OPAC_URL", $set->getOpacUrl()); define("OBIB_SESSION_TIMEOUT", $set->getSessionTimeout()); define("OBIB_ITEMS_PER_PAGE", $set->getItemsPerPage()); define("OBIB_DB_VERSION", $set->getVersion());
function getOpts() { global $postVars; global $useYAZ, $useSRU; global $noise_words; unset($_SESSION["postVars"]); unset($_SESSION["pageErrors"]); $optQ = new LookupOptsQuery(); $optQ->connect(); if ($optQ->errorOccurred()) { $optQ->close(); displayErrorPage($optQ); } $optQ->execSelect(); if ($optQ->errorOccurred()) { $optQ->close(); displayErrorPage($optQ); } $opt = $optQ->fetchRow(); $postVars["protocol"] = $opt->getProtocol(); $postVars["maxHits"] = $opt->getMaxHits(); $postVars["keepDashes"] = $opt->getKeepDashes(); $postVars["callNmbrType"] = $opt->getCallNmbrtype(); $postVars["autoDewey"] = $opt->getAutoDewey(); $postVars["defaultDewey"] = $opt->getDefaultDewey(); $postVars["autoCutter"] = $opt->getAutoCutter(); $postVars["cutterType"] = $opt->getCutterType(); $postVars["cutterWord"] = $opt->getCutterWord(); $postVars["autoCollect"] = $opt->getAutoCollect(); $postVars["fictionName"] = $opt->getFictionName(); $postVars["fictionCode"] = $opt->getFictioncode(); $postVars["fictionLoC"] = $opt->getFictionLoC(); $postVars["fictionDew"] = $opt->getFictionDew(); ## not yet in database or user opts screens, but should be!!!! $postVars["timeout"] = 60; $postVars["noiseWords"] = 'a an and for of the this those'; //print_r($postVars); $optQ->close(); }
?> </th> </tr> <?php #**************************************************************************** #* Search database for BiblioHold data #**************************************************************************** $holdQ = new BiblioHoldQuery(); $holdQ->connect(); if ($holdQ->errorOccurred()) { $holdQ->close(); displayErrorPage($holdQ); } if (!$holdQ->queryByMbrid($mbrid)) { $holdQ->close(); displayErrorPage($holdQ); } if ($holdQ->getRowCount() == 0) { ?> <tr> <td class="primary" align="center" colspan="8"> <?php echo $loc->getText("mbrViewNoHolds"); ?> </td> </tr> <?php } else { while ($hold = $holdQ->fetchRow()) { ?> <tr>
function getHosts($mode) { global $postVars; $hostQ = new LookupHostQuery(); $hostQ->connect(); if ($hostQ->errorOccurred()) { $hostQ->close(); displayErrorPage($hostQ); } if ($mode == 'all') { $hostQ->execSelectAll(); } else { $hostQ->execSelect(); } if ($hostQ->errorOccurred()) { $hostQ->close(); displayErrorPage($hostQ); } $n = 0; $hosts = array(); while ($row = $hostQ->fetchRow()) { $hosts[$n]['id'] = $row->getId(); $hosts[$n]['seq'] = $row->getSeq(); $hosts[$n]['active'] = $row->getActive(); $hosts[$n]['host'] = $row->getHost(); $hosts[$n]['name'] = $row->getName(); $hosts[$n]['db'] = $row->getDb(); $hosts[$n]['user'] = $row->getUser(); $hosts[$n]['pw'] = $row->getPw(); $hosts[$n]['context'] = $row->getCntxt(); $hosts[$n]['schema'] = $row->getSchma(); $n++; } $postVars['hosts'] = $hosts; $postVars['numHosts'] = $n; $hostQ->close(); }
} if (!isset($_SESSION["token"]) or $_SESSION["token"] == "") { header("Location: ../shared/loginform.php"); exit; } #**************************************************************************** #* Checking session table to see if session_id has timed out #**************************************************************************** $sessQ = new SessionQuery(); $sessQ->connect(); if ($sessQ->errorOccurred()) { displayErrorPage($sessQ); } if (!$sessQ->validToken($_SESSION["userid"], $_SESSION["token"])) { if ($sessQ->errorOccurred()) { displayErrorPage($sessQ); } $sessQ->close(); header("Location: ../shared/loginform.php?RET=" . U($returnPage)); exit; } $sessQ->close(); #**************************************************************************** #* Checking authorization for this tab #* The session authorization flags were set at login in login.php #**************************************************************************** if ($tab == "circulation") { if (!$_SESSION["hasCircAuth"]) { header("Location: ../circ/noauth.php"); exit; } elseif (isset($restrictToMbrAuth) and !$_SESSION["hasCircMbrAuth"]) {
function __invoke($smarty) { displayErrorPage($smarty, $this); }
$_SESSION["pageErrors"] = $pageErrors; header("Location: ../user/user_pwd_reset_form.php"); exit; } #************************************************************************** #* Update staff member #************************************************************************** $memberQ = new MemberQuery(); $memberQ->connect(); if ($memberQ->errorOccurred()) { $memberQ->close(); displayErrorPage($memberQ); } if (!$memberQ->resetPassUser($member)) { $memberQ->close(); displayErrorPage($memberQ); } $memberQ->close(); #************************************************************************** #* Destroy form values and errors #************************************************************************** unset($_SESSION["postVars"]); unset($_SESSION["pageErrors"]); #************************************************************************** #* Show success page #************************************************************************** require_once "../opac/header_opac.php"; echo $loc->getText("adminStaff_pass_user_reset_Passwordreset"); ?> <br><br> <a href="../user/user_view.php"><?php
displayErrorPage($errorMessage, $longErrorMessage); } // Hauptinhalt ermitteln if (isset($_GET[SITE_PARAM])) { // Bestimmen des include-Files anhand des GET-Parameters SITE_PARAM $param = $_GET[SITE_PARAM]; $paramFile = getParamFile($param); // Prüfung, ob der Site-Parameter zulässig ist if ($paramFile !== false) { $includeFile = $paramFile; } } else { $includeFile = 'map.php'; } } } // Einbinden + Prüfen ob Einbinden erfolgreich if ((include $includeFile) === false) { $errorMessage = 'Öffnen der Include-Datei fehlgeschlagen'; $longErrorMessage = 'Datei Include-Datei ' . $includeFile . ' konnte nicht nicht gefunden werden (' . __FILE__ . ').'; displayErrorPage($errorMessage, $longErrorMessage); } // Prüfen ob Request über Ajax läuft und template umschalten if (isset($_GET['ajax'])) { $template->setTemplate('ajax_index.html'); if ($user == null) { $template->viewMacro = 'ajaxNotLoggedIn'; } else { $template->viewMacro = 'ajaxStandard'; } }
function autoInactive() { $setQ = new SettingsQuery(); $setQ->connect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } $setQ->execSelect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } $set = $setQ->fetchRow(); $inactiveMemberAfterDays = 0 + $set->getInactiveMemberAfterDays(); if ($inactiveMemberAfterDays > 0) { $sql = $this->mkSQL("UPDATE member SET is_active = 'N' WHERE last_activity_dt <= DATE_SUB(NOW(), INTERVAL %N DAY) ", $inactiveMemberAfterDays); $this->exec($sql); } }
function insertCopy() { global $copyQ, $copy; if (!$copyQ->insert($copy)) { $copyQ->close(); if ($copyQ->getDbErrno() == "") { $pageErrors["barcodeNmbr"] = $copyQ->getError(); $_SESSION["postVars"] = $_POST; $_SESSION["pageErrors"] = $pageErrors; header("Location: ../catalog/biblio_copy_new_form.php?bibid=" . U($bibid)); exit; } else { displayErrorPage($copyQ); } } }
<?php /*+********************************************************************************** * The contents of this file are subject to the vtiger CRM Public License Version 1.0 * ("License"); You may not use this file except in compliance with the License * The Original Code is: vtiger CRM Open Source * The Initial Developer of the Original Code is vtiger. * Portions created by vtiger are Copyright (C) vtiger. * All Rights Reserved. ************************************************************************************/ function displayErrorPage($request) { ?> <h1>Workflow engine error</h1> <?php echo "It appears that you have entered an invalid value."; ?> <?php } displayErrorPage($_REQUEST);
Fatal::internalError('no fieldid set'); } $fieldid = $_GET["fieldid"]; #**************************************************************************** #* Reading database for subfield values #**************************************************************************** $fieldQ = new BiblioFieldQuery(); $fieldQ->connect(); if ($fieldQ->errorOccurred()) { $fieldQ->close(); displayErrorPage($fieldQ); } $field = $fieldQ->doQuery($bibid, $fieldid); if ($fieldQ->errorOccurred()) { $fieldQ->close(); displayErrorPage($fieldQ); } $fieldQ->close(); $postVars["bibid"] = $bibid; $postVars["fieldid"] = $bibid; $postVars["tag"] = $field->getTag(); $postVars["ind1Cd"] = $field->getInd1Cd(); $postVars["ind2Cd"] = $field->getInd2Cd(); $postVars["subfieldCd"] = $field->getSubfieldCd(); $postVars["fieldData"] = $field->getFieldData(); $selectedTag = $field->getTag(); $selectedSubfld = $field->getSubfieldCd(); } else { $postVars = $_SESSION['postVars']; if (isset($_SESSION['pageErrors'])) { $pageErrors = $_SESSION['pageErrors'];
/** * Save PHPExcel to file * * @param string $pFileName * @throws Exception */ public function save($pFilename = null, $title = '') { // garbage collect $this->_phpExcel->garbageCollect(); $saveArrayReturnType = PHPExcel_Calculation::getArrayReturnType(); PHPExcel_Calculation::setArrayReturnType(PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE); // Open file $fileHandle = fopen($pFilename, 'w'); if ($fileHandle === false) { throw new Exception("Could not open file {$pFilename} for writing."); } // Set PDF $this->_isPdf = true; // Build CSS $this->buildCSS(true); // Generate HTML $html = ''; //$html .= $this->generateHTMLHeader(false); if (!empty($title)) { $html .= '<h1 align="center">' . $title . '</h1>'; } $html .= $this->generateSheetData(); //$html .= $this->generateHTMLFooter(); // Default PDF paper size $paperSize = 'LETTER'; // Letter (8.5 in. by 11 in.) // Check for paper size and page orientation if (is_null($this->getSheetIndex())) { $orientation = $this->_phpExcel->getSheet(0)->getPageSetup()->getOrientation() == PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE ? 'L' : 'P'; $printPaperSize = $this->_phpExcel->getSheet(0)->getPageSetup()->getPaperSize(); } else { $orientation = $this->_phpExcel->getSheet($this->getSheetIndex())->getPageSetup()->getOrientation() == PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE ? 'L' : 'P'; $printPaperSize = $this->_phpExcel->getSheet($this->getSheetIndex())->getPageSetup()->getPaperSize(); } // Override Page Orientation if (!is_null($this->_orientation)) { $orientation = $this->_orientation == PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE ? 'L' : 'P'; } // Override Paper Size if (!is_null($this->_paperSize)) { $printPaperSize = $this->_paperSize; } if (isset(self::$_paperSizes[$printPaperSize])) { $paperSize = self::$_paperSizes[$printPaperSize]; } // Create PDF $pdf = new TCPDF($orientation, 'pt', $paperSize); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $pdf->AddPage(); // Set the appropriate font require_once "../classes/Settings.php"; require_once "../classes/SettingsQuery.php"; $setQ = new SettingsQuery(); $setQ->connect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } $setQ->execSelect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } $set = $setQ->fetchRow(); $pdf->setFont($set->getFontNormal(), '', $set->getFontSize()); //$pdf->SetFont($this->_font); $pdf->writeHTML($html); // Document info $pdf->SetTitle($this->_phpExcel->getProperties()->getTitle()); $pdf->SetAuthor($this->_phpExcel->getProperties()->getCreator()); $pdf->SetSubject($this->_phpExcel->getProperties()->getSubject()); $pdf->SetKeywords($this->_phpExcel->getProperties()->getKeywords()); $pdf->SetCreator($this->_phpExcel->getProperties()->getCreator()); // Write to file fwrite($fileHandle, $pdf->output($pFilename, 'S')); // Close file fclose($fileHandle); PHPExcel_Calculation::setArrayReturnType($saveArrayReturnType); }
<?php /** * Bottomfile für Index * macht abschliessende Arbeiten wie die Ausgabe des Templates, * Daten zurückschreiben, Session abschliessen und Loggen */ // Template ausgeben und mögliche Fehler behandeln $template->scriptContent = $javascriptContent; try { echo $template->execute(); } catch (Exception $e) { $errorMessage = 'Das Template generierte einen Fehler.'; displayErrorPage($errorMessage, (string) $e); } ob_flush(); // Template senden // Benutzerdaten speichern if (World_Base::$USER != null) { World_Base::$USER->saveData(); World_Base::$USER->unloadModule('all'); World_Base::$SESSION->set('userData', serialize(World_Base::$USER)); } // Sessiondaten speichern World_Base::$SESSION->saveData(); // Fehler loggen Error::logErrors(World_Base::$LOG, true);
# $biblioQ = new BiblioQuery(); $biblioSearchQ->setItemsPerPage(OBIB_ITEMS_PER_PAGE); $biblioSearchQ->connect(); if ($biblioSearchQ->errorOccurred()) { $biblioSearchQ->close(); displayErrorPage($biblioSearchQ); } # checking to see if we are in the opac search or logged in if ($tab == "opac") { $opacFlg = true; } else { $opacFlg = false; } if (!$biblioSearchQ->search2($sType, $materialCd, $collectionCd, $words, $currentPageNmbr, $sortBy, $opacFlg)) { $biblioSearchQ->close(); displayErrorPage($biblioSearchQ); } #**************************************************************************** #* Search database for more details #**************************************************************************** #$biblioQ = new BiblioQuery(); #$biblioQ->connect(); #if ($biblioQ->errorOccurred()) { # $biblioQ->close(); # displayErrorPage($biblioQ); #} #if (!$biblio = $biblioQ->doQuery($bibid)) { # $biblioQ->close(); # displayErrorPage($biblioQ); #} #$biblioFlds = $biblio->getBiblioFields();
$biblioQ = new BiblioSearchQuery(); $biblioQ->setItemsPerPage(OBIB_ITEMS_PER_PAGE); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } # checking to see if we are in the opac search or logged in if ($tab == "opac") { $opacFlg = true; } else { $opacFlg = false; } if (!$biblioQ->search($sType, $words, $currentPageNmbr, $sortBy, $collecs, $materials, $opacFlg)) { $biblioQ->close(); displayErrorPage($biblioQ); } # Redirect to biblio_view if only one result if ($biblioQ->getRowCount() == 1) { $biblio = $biblioQ->fetchRow(); header('Location: ../shared/biblio_view.php?bibid=' . U($biblio->getBibid()) . '&tab=' . U($tab)); exit; } #************************************************************************** #* Show search results #************************************************************************** if ($tab == "opac") { require_once "../shared/header_opac.php"; } else { require_once "../shared/header.php"; }
echo '<th>' . $loc->getText("MarcUploadData") . '</th>'; echo '</tr>'; foreach ($biblio->getBiblioFields() as $field) { echo '<tr><td>' . H($field->getTag()) . '</td>'; echo '<td>' . H($field->getSubfieldCd()) . '</td>'; echo '<td>' . H($field->getFieldData()) . '</td></tr>'; } echo '</table>'; } echo '<hr /><h3>' . $loc->getText("MarcUploadRawData") . '</h3>'; echo '<pre>'; readfile($_FILES["usmarc_data"]["tmp_name"]); echo '</pre>'; } else { $bq = new BiblioQuery(); $bq->connect(); if ($bq->errorOccurred()) { $bq->close(); displayErrorPage($bq); } foreach ($biblios as $biblio) { if (!$bq->insert($biblio)) { $bq->close(); displayErrorPage($bq); } } $bq->close(); echo $loc->getText("MarcUploadRecordsUploaded"); echo ": " . H(count($biblios)); } include "../shared/footer.php";
$tab = "circulation"; $nav = "view"; $returnNav = "../circ/mbr_view.php?mbrid=" . U($mbrid); } $restrictInDemo = TRUE; require_once "../shared/logincheck.php"; require_once "../classes/BiblioHoldQuery.php"; require_once "../functions/errorFuncs.php"; require_once "../classes/Localize.php"; $loc = new Localize(OBIB_LOCALE, "shared"); #************************************************************************** #* Delete hold #************************************************************************** // we need to also insert into status history table $holdQ = new BiblioHoldQuery(); $holdQ->connect(); if ($holdQ->errorOccurred()) { $holdQ->close(); displayErrorPage($holdQ); } $rc = $holdQ->delete($bibid, $copyid, $holdid); if (!$rc) { $holdQ->close(); displayErrorPage($copyQ); } $holdQ->close(); #************************************************************************** #* Go back to member view #************************************************************************** $msg = $loc->getText("holdDelSuccess"); header("Location: " . $returnNav . "&msg=" . U($msg));
$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(); displayErrorPage($histQ); } #************************************************************************** #* Show biblio checkout history #************************************************************************** require_once "../shared/header.php"; ?> <h1><?php echo $loc->getText("mbrHistoryHead1"); ?> </h1> <table class="primary"> <tr> <th valign="top" nowrap="yes" align="left"> <?php
$_SESSION["pageErrors"] = $pageErrors; header("Location: ../admin/staff_pwd_reset_form.php"); exit; } #************************************************************************** #* Update staff member #************************************************************************** $staffQ = new StaffQuery(); $staffQ->connect(); if ($staffQ->errorOccurred()) { $staffQ->close(); displayErrorPage($staffQ); } if (!$staffQ->resetPwd($staff)) { $staffQ->close(); displayErrorPage($staffQ); } $staffQ->close(); #************************************************************************** #* Destroy form values and errors #************************************************************************** unset($_SESSION["postVars"]); unset($_SESSION["pageErrors"]); #************************************************************************** #* Show success page #************************************************************************** require_once "../shared/header.php"; echo $loc->getText("adminStaff_pwd_reset_Passwordreset"); ?> <br><br> <a href="../admin/staff_list.php"><?php
$trans = new MemberAccountTransaction(); $trans->setMbrid($saveMbrid); $trans->setCreateUserid($_SESSION["userid"]); $trans->setTransactionTypeCd("+c"); $trans->setAmount($fee); $trans->setDescription($loc->getText("shelvingCartTrans", array("barcode" => $barcode))); $transQ = new MemberAccountQuery(); $transQ->connect(); if ($transQ->errorOccurred()) { $transQ->close(); displayErrorPage($transQ); } $trans = $transQ->insert($trans); if ($transQ->errorOccurred()) { $transQ->close(); displayErrorPage($transQ); } // Set fee message if (OBIB_LOCALE == 'th') { $balText = number_format($fee, 2) . ' บาท'; } else { $balText = moneyFormat($fee, 2); } $_SESSION['feeMsg'] = "<font class=\"error\">" . $loc->getText("mbrViewBalMsg2", array("fee" => $balText)) . " <a href=\"../circ/mbr_account.php?mbrid=" . $saveMbrid . "&reset=Y\">" . $loc->getText('mbrAccountLink') . "</a></font><br><br>"; $transQ->close(); } // Update activity $mbrQ = new MemberQuery(); $mbrQ->connect(); $mbrQ->updateActivity($saveMbrid); $mbrQ->close();
function insertBiblio($biblio) { require_once "../classes/BiblioQuery.php"; $biblioQ = new BiblioQuery(); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } $bibid = $biblioQ->insert($biblio); if (!$bibid) { $biblioQ->close(); displayErrorPage($biblioQ); } $biblioQ->close(); return $bibid; }
function updateBiblio($biblio) { require_once "../classes/BiblioQuery.php"; $biblioQ = new BiblioQuery(); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } if (!$biblioQ->update($biblio)) { $biblioQ->close(); displayErrorPage($biblioQ); } $biblioQ->close(); }
header("Location: ../shared/suspended.php"); exit; } #************************************************************************** #* Insert new session row with random token #************************************************************************** $sessionQ = new SessionQuery(); $sessionQ->connect(); if ($sessionQ->errorOccurred()) { $sessionQ->close(); displayErrorPage($sessionQ); } $token = $sessionQ->getToken($staff->getUserid()); if ($token == false) { $sessionQ->close(); displayErrorPage($sessionQ); } $sessionQ->close(); #************************************************************************** #* Destroy form values and errors and reset signon variables #************************************************************************** unset($_SESSION["postVars"]); unset($_SESSION["pageErrors"]); $_SESSION["username"] = $staff->getUsername(); $_SESSION["userid"] = $staff->getUserid(); $_SESSION["token"] = $token; $_SESSION["loginAttempts"] = 0; $_SESSION["hasAdminAuth"] = $staff->hasAdminAuth(); $_SESSION["hasCircAuth"] = $staff->hasCircAuth(); $_SESSION["hasCircMbrAuth"] = $staff->hasCircMbrAuth(); $_SESSION["hasCatalogAuth"] = $staff->hasCatalogAuth();
if ($marcTagDmQ->errorOccurred()) { $marcTagDmQ->close(); displayErrorPage($marcTagDmQ); } $marcTags = $marcTagDmQ->fetchRows(); $marcTagDmQ->close(); $marcSubfldDmQ = new UsmarcSubfieldDmQuery(); $marcSubfldDmQ->connect(); if ($marcSubfldDmQ->errorOccurred()) { $marcSubfldDmQ->close(); displayErrorPage($marcSubfldDmQ); } $marcSubfldDmQ->execSelect(); if ($marcSubfldDmQ->errorOccurred()) { $marcSubfldDmQ->close(); displayErrorPage($marcSubfldDmQ); } $marcSubflds = $marcSubfldDmQ->fetchRows(); $marcSubfldDmQ->close(); ?> <h1><?php echo $loc->getText('CSVloadHeader'); ?> </h1> <?php echo $loc->getText('CSVUpdateContinue'); ?> </br> </br>
$_POST["aws"] = $set->getAWSAccountId(); if (!$set->validateData()) { //$pageErrors["sessionTimeout"] = $set->getSessionTimeoutError(); //$pageErrors["itemsPerPage"] = $set->getItemsPerPageError(); //$pageErrors["purgeHistoryAfterMonths"] = $set->getPurgeHistoryAfterMonthsError(); $_SESSION["postVars"] = $_POST; $_SESSION["pageErrors"] = $pageErrors; header("Location: ../admin/lookup_edit_form.php"); exit; } #************************************************************************** #* Update domain table row #************************************************************************** $setQ = new LookupQuery(); $setQ->connect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } if (!$setQ->update($set)) { $setQ->close(); displayErrorPage($setQ); } $setQ->close(); #************************************************************************** #* Destroy form values and errors #************************************************************************** unset($_SESSION["postVars"]); unset($_SESSION["pageErrors"]); header("Location: ../admin/lookup_edit_form.php?reset=Y&updated=Y"); exit;
function output($html, $title = 'document', $pFilename = 'doc.pdf') { require_once '../classes/PHPExcel/Shared/PDF/tcpdf.php'; require_once "../classes/Settings.php"; require_once "../classes/SettingsQuery.php"; // Create PDF $pdf = new TCPDF('P', 'pt', 'A4'); $pdf->SetMargins(56.7, 56.7); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $pdf->setTitle($title); $pdf->AddPage(); // Set the appropriate font $setQ = new SettingsQuery(); $setQ->connect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } $setQ->execSelect(); if ($setQ->errorOccurred()) { $setQ->close(); displayErrorPage($setQ); } $set = $setQ->fetchRow(); $pdf->setFont($set->getFontNormal()); $pdf->writeHTML($html); $pdf->SetTitle($title); return $pdf->output($pFilename, 'S'); }