PHP DmQuery::getAssoc方法代码示例

                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") . "&raquo;</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") . "&raquo;</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;
}