lib_global_setting.php
:
fromlib_global_setting.php
php.ini
(in Linux, /etc/php.ini).htaccess
(in the folder install oe)…/lib/barcode_terminal.js
, line 174-185, content:lib_global_funcs.php
lib_global_funcs.php
by adding autofocus
after id=\"db_name\"
. Around line ~1180Print Dymo Label
button (chemical_storage.label
(in /oe/forms/dymo/). You can open and edit ".label" files by using Dymo software: https://www.dymo.com/en-US/online-support/dymo-user-guideschemical_storage1.label
, chemical_storage2.label
, etc.edit.js
(in /oe/lib/)window2
in the example above)
- moveby
specificationslib_edit.php
(in /oe/)style=\"display:none\"
)storage
storage_id
of the new and old locations by choosing Table storage
in Database “xyz”.storage_name
and the corresponding storage_id
person_id
by going into [Database]/personperson_id
by going into [Database]/personperson_id
of user with username=juliaLIKE 'FH-2206%'
: show the storage_id
of the storage location with name starting with FH-2206LIKE '%FH-2206%'
would mean find anything with storage name containing FH-2206LIKE 'FH-2206%'
would mean find anything with storage name ending with FH-2206GROUP BY storage_name
: is added so that duplicates are only shown oncechemical_storage_disabled IS NULL AND chemical_storage_barcode != ""
)test
is the name of the database in this examplechemical_storage_id
as well as autogenerated barcode)Settings/Autogenerate barcode
and click the corresponding button to autogenerate storage and/or user barcodes.Settings/Autogenerate barcode
and click the corresponding button to autogenerate storage and/or user barcodes.storage_barcode
field. storage_barcode
field is a binary so cast() was used. Note, this whole function inside cast() is to convert storage_id
field to EAN8 barcode. See here for more info on how to make EAN8 barcode: http://www.barcodeisland.com/ean8.phtmllib_output.php
inside open enventory folder. In this example, the open enventory folder is named “oe”. The specific location of your folder might change. Change the path accordingly.temp_storage
is the name of the database, storage and barcode are the 2 headlines of the 2 columns):temp_storage
table (in this example test
is the name of the database; “ignore 1 lines” because the csv file head 1 line headline):