#21 Stocktake functionality / Inventory control

open
nobody
None
5
2005-03-16
2005-03-16
Peter Leschev
No

The ability to determine if books are missing / have the
correct status.

Probably will not make 0.5.x, more like 0.6.x

Discussion

  • Peter Leschev
    Peter Leschev
    2005-03-16

    new files

     
    Attachments
  • Peter Leschev
    Peter Leschev
    2005-03-16

    diff file

     
    Attachments
  • Marcus Bautze
    Marcus Bautze
    2005-04-04

    Logged In: YES
    user_id=1209841

    Can you explain, what's your modification does? I looked in the source
    and have no idea what's the idea behind this mod!

     
  • Peter Leschev
    Peter Leschev
    2005-04-04

    Logged In: YES
    user_id=752383

    Here's a more in depth description:
    Gives the ability for librarians to check whether what they have
    on the shelves is what is reflected in openbiblio (e.g. Have any
    books been stolen?). When a stocktake is started, a snapshot of
    all biblio_copies is taken, then the librarians go through and
    barcode scan every book on the shelf (and also recording the
    actual status of the book). Once done, the librarians will get a list
    of books which haven't been accounted for and books which
    have an unexpected status (e.g. openbiblio has a status of
    'lost', but the librarian found the book as 'checked in' - this is
    reported as you go as well) and which books that have been
    scanned in, weren't actually in the system.

     
  • Peter Leschev
    Peter Leschev
    2005-04-04

    Logged In: YES
    user_id=752383

    On a side note, I installed this functionality on a box with MySQL
    4.1.10 (I was using 3.x during dev), it seems it behaves slightly
    differently with the last_insert_id() functionality. You'll need this
    change in StocktakeQuery.php - Will be fixed in 0.6.0

    $sql = $this->mkSQL("select last_insert_id()");
    if (!$this->_query($sql, $this->_loc->getText
    ("stocktakeQueryErrCreating"))) {
    return false;
    }
    $array = $this->_conn->fetchRow(OBIB_NUM);
    $lastId = $array[0];

    $sql = $this->mkSQL("insert into stocktake_item "
    . "(stocktake_id, bibid, copyid, barcode_nmbr,
    expected_status_cd) "
    . "select %N, biblio_copy.bibid,
    biblio_copy.copyid, "
    . "biblio_copy.barcode_nmbr,
    biblio_copy.status_cd from biblio_copy", $lastId);

     
  • Marcus Bautze
    Marcus Bautze
    2005-04-14

    Logged In: YES
    user_id=1209841

    Thanks for explainig this functionality :-)

     
  • Jack Eapen
    Jack Eapen
    2005-04-20

    Logged In: YES
    user_id=782764

    i use mysql 3.23.48. getting a blank screen when calling
    /catalog/stocktake_new.php
    how to call the functionality? and which lines r to be changed
    as mentioned in the previous post?

    Jack

     
  • Peter Leschev
    Peter Leschev
    2005-04-21

    Logged In: YES
    user_id=752383

    > i use mysql 3.23.48. getting a blank screen when calling
    /catalog/stocktake_new.php

    Do you get anything when you go to 'View Source'?

    > which lines r to be changed as mentioned in the previous post?
    No need to change code as per my previous comment, as you're
    using MySql 3.x and not 4.x

    Cheers,
    Peter

     
  • Jack Eapen
    Jack Eapen
    2005-04-22

    Logged In: YES
    user_id=782764

    Hi
    here's the source of the page:
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
    Transitional//EN">
    <HTML><HEAD>
    <META http-equiv=Content-Type content="text/html;
    charset=iso-8859-1"></HEAD>
    <BODY></BODY></HTML>

    my php is 4.3.10

    Jack

     
  • Jack Eapen
    Jack Eapen
    2005-05-20

    Logged In: YES
    user_id=782764

    Hi,
    there is a reference to the file "../shared/common.php" in the
    files included in this patch. But such a file is not in the zip
    archives provided here or it's not in the original OpenBiblio.
    can you provide that file ,plz?

     
  • Sunil Jacob
    Sunil Jacob
    2009-10-12

    what is the use of stocktake_diff.txt file?

     
  • Sunil Jacob
    Sunil Jacob
    2009-10-12

    I also encounter the below error when going to stocktake_list.php "Fatal error: Class 'Iter' not found in C:\wamp\www\openbiblio\classes\Query.php on line 320". Please help me on this?