#21 Stocktake functionality / Inventory control

open
nobody
None
5
2005-03-16
2005-03-16
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

     
  • 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?

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks