+ Post New Thread
Page 3 of 20 FirstFirst 123456713 ... LastLast
Results 31 to 45 of 286
How do you do....it? Thread, Toner inventory Database in Technical; nice work webman, started getting this working today (had to go round the whole school making sure I have all ...
  1. #31
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    nice work webman, started getting this working today (had to go round the whole school making sure I have all the printers on my list in the same locations and also noteing down what cartridges they use)

    I have had a few errors on this through
    When Clicking Printers Notice------

    {doc_root}\ICTInk\printers.php(73): include('C:\inetpub\wwwr...')
    {doc_root}\ICTInk\views\printers\index.php(78)
    Undefined variable: nostock

    Managed to get rid of this error by delete the line where that code is, but is that line needed for something? When Clicking Reports

    Notice------{doc_root}\ICTInk\reports.php(75): include('C:\inetpub\wwwr...')
    {doc_root}\ICTInk\views\reports\index.php(2)
    Undefined variable: printer

    If I delete this line like before, this doesnt work, I just makes my IIS server say it cant find the resourse

    Any ideas on this, thanks!


    Also if you could, is it possible for you to include, when you add a consumable, can make it so you can enter the price of that perticular ink. And also include it in the reports.

    This would be extremlly handy because ink is costing a lot and we been told to charge it to the department that is getting the new ink, instead of coming out our ict budget.

    That way we can print the reports every so often and hand it in to the finince office and make it so the ink is charged to what ever deparment has used it and make whatever the ink cost us oringally goes back into our ict budget.

    Or if you dont want to include this in it, could you show us how we could add it just in ours?


    Many Thanks!
    Last edited by pritchardavid; 20th September 2010 at 06:53 PM.

  2. #32

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318
    p-dave: Thanks for reporting those. It's only a notice, which can be suppressed by un-commenting and setting error_reporting to 0 in config.php. But I'm currently working on updating the code so that won't be necessary.

    I'll also look at adding price info for toners - the reason I didn't implement this from the start is that we've usually found toner prices fluctuate, so it would be only useful as a rough guide. There's also the consideration of: does it log the price at the time of installation, for historical/logging reasons, or always look up the "current" cost when viewing the report?

  3. Thanks to webman from:

    jamiess (20th September 2010)

  4. #33
    jamiess's Avatar
    Join Date
    Oct 2009
    Location
    Balsall Common
    Posts
    72
    Thank Post
    10
    Thanked 20 Times in 17 Posts
    Rep Power
    14

    Nice Work Webman, it truly is awesome piece of work. Should help to make my life a lot easier.

  5. #34
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    No worrys webman

    Yer I would say that it keeps the old prices on the report in case for example one of the inks we just ordered, the price has changed and we havent charged the department for the inks they have already used, and once we have changed the price it changes that in the report thats not what we want to happen

    So if possible, if you gonna add this, we need it to keep the price of the ink, when we clicked install ink for whatever the printer

  6. #35

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318
    jamiess: Thanks

    p-dave: The files at GitHub have been updated now to fix those errors, so you can just grab a new copy of the zip file and copy over the files. I agree on your comment about the prices - I believe that to be the best way to do it.

  7. #36

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,037
    Thank Post
    209
    Thanked 425 Times in 306 Posts
    Rep Power
    143
    Quote Originally Posted by webman View Post
    p-dave: Thanks for reporting those. It's only a notice, which can be suppressed by un-commenting and setting error_reporting to 0 in config.php. But I'm currently working on updating the code so that won't be necessary.

    I'll also look at adding price info for toners - the reason I didn't implement this from the start is that we've usually found toner prices fluctuate, so it would be only useful as a rough guide. There's also the consideration of: does it log the price at the time of installation, for historical/logging reasons, or always look up the "current" cost when viewing the report?
    You could get really in depth with this (I haven't actually downloaded your code and tried it yet by the way) and write into it the facility to construct a toner order within it, which can be allocated an order number within the program and saved. Then a 'booking in' section for when the order arrives which you could input the cost for each cartridge ordered and confirm the quantities. That can then be saved to the database and tied to that order number so the system will then be aware of the cost of every cartridge you have in stock.

    Whenever you change a toner you can be prompted for the order number the toner cartridge came from, and it can automatically produce a charge sheet with the exact cost on which can be handed to the finance department to move the money around. Of course it does complicate the code quite a bit, and relies on you writing the order number on the end of the boxes when they arrive.

    Just an idea.

    Mike.

  8. #37

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318
    That would be technically possible. One for the future, once I've got Classroombookings 2 released, maybe...

  9. #38
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    No, dont think my idea would would actually. Even with the reports showing the prices at the time of the install. For example if I had to set a new price for an ink, that we are checking in, and we still have ink in stock for that particular ink. The older in in stock that we have already, will then have the newer incorrect price (as im gussing for the older ink we have instock already, we would need to charge them the older correct price)


    Sothinking about it

    The best way of doing this would be problery be:

    When you checkin new ink you can enter how much each ink cost. Oversially the system will use the same price for the same item if you have more the same one.

    Each ink could have a id (you dont see it, only the database)

    for example if I had an ink called 15 that was listed for a printer, then it would have a number after, and the end number keep going up after that.

    ie 15_1

    I'll then say (not sure how databases work) your need a date in one section, of when you put the ink into the system and the price of the ink into another section

    Then everytime you install a ink it will use the oldest id number avabilable, that way the price for that particular ink will be correct.

    Then i'll gusse once that id is used it will get moved to a reports database?


    Only a gusse what you could do, if you understand, not sure I made that clear or even if that way would work

  10. #39

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318
    Yeah, it needs some thought

  11. #40
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    yep sure does, ok think i'll try your classroom bookings tomorrow too, thats problery just has good has this!

    Wish you would make a eticket support site and also an asset/invertory site too, that would be everything complete that im trying to setup at the momment

    xd nah only kidding far to much work

    Just cant seem to find a good opensourse one (Think im gonna have to have a talk with the boss tomorrow, ask him, if we can can pay for one)

    Edit


    Ok knew I forgot to ask how to we secure the website to stop everyone going on it expect us admins?
    Last edited by pritchardavid; 20th September 2010 at 09:15 PM.

  12. #41
    dgsmith's Avatar
    Join Date
    Nov 2007
    Location
    Merseyside, England
    Posts
    1,078
    Thank Post
    118
    Thanked 87 Times in 76 Posts
    Rep Power
    35
    I'd agree about toner costs being included - I always try and log how much a toner/ink costs at the time of purchase so I can track price changes and therefore see if alternate cheaper options need to be considered. As we tend to use mostly compatible toners anyway, the prices of these stay reasonably stable thus changes in pricing isn't too much of a concern.

    I would like some grouping ability though for the toners and inks. I have got very used to my "printed sheet" layout where I group the toners and inks into categories for ease of finding them as opposed to one big list on this system. Whilst I'll play with this system and see how it feels, I would probably only shift across to actually using it once I can get it as close to my "printed sheet" version as possible. Still, not to undermine a great piece of free software you have contributed here though!
    Last edited by dgsmith; 21st September 2010 at 11:21 AM. Reason: spelling and grammar..

  13. #42

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318
    p-dave: Security - you need to configure this at the web server. For Apache, look in to htaccess/htpasswd; or for IIS you can configure something using the Authentication tab on the properties of the directory (I think).

    dgsmith: I'd be interested to see what your printed sheet looks like to find out how you group them together. I think if that was to be implemented, I'd have it so you could define your own groups - give it a name and choose which consumables are part of it. The dashboard list would then be displayed using those groups.

  14. #43
    dgsmith's Avatar
    Join Date
    Nov 2007
    Location
    Merseyside, England
    Posts
    1,078
    Thank Post
    118
    Thanked 87 Times in 76 Posts
    Rep Power
    35
    That's the best approach webman - dashboard listing with definable groups and consumable membership. The list I have is quite literally some tables separating "HP Inks, HP Toners, Brother Drums, Brother Toners, Konica Minolta toners" etc, so split by brand then sub-split by type. Of course, any approach you take would allow for any grouping options, such as maybe by printer type, location, colour/mono etc.

    This may be a bit overkill, but even automatic toner identifying may be something of benefit. For example, it's taking a while to go through all the colour laser printers and add each toner model in separately (if you're unfortunate enough like us to have no actual consistant type of printer). Being able to make it automatically work out the colour toner models from the black entry would make life easier. For example, most HP colour laser toners use the same format where the black is 0, cyan 1, yellow 2 and magenta 3, so for the HP 2600n, Q6000A would be entered for black then the system would work out the rest, which are Q6001A, Q6002A and Q6003A respectively by incrementing the 2nd to last character. Of course, this should be optional as there are printers where this consistancy isn't applicable.

    I'm sure there are other things i'd think of too, though I only mention these as I am keen to use your system and any approach which makes it easier for an end-user should always be put high up the priority list imo

  15. #44

    Join Date
    May 2009
    Location
    Whyalla, South Australia
    Posts
    16
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    11
    I hope i can get a bit of advice. I apologise in advance, because i'm not a regular MYSQL and PHP user, so it's probably something really obvious.

    The Inventory database all seems to work fine in itself, but i'm getting the massive slew of information when i navigate to it. There are a couple of warnings at the bottom. I have created the session folder, and i believe it has correct permissions (it writes session files in there, so looks ok)

    Here's the code:

    Code:
    Context
    -------
    
    $_SERVER: Array
    (
        [_FCGI_X_PIPE_] => \\.\pipe\IISFCGI-7b443fb8-a24b-466c-944f-83e584009e86
        [PHP_FCGI_MAX_REQUESTS] => 10000
        [PHPRC] => C:\PHP\
        [ALLUSERSPROFILE] => C:\Documents and Settings\All Users
        [APP_POOL_ID] => DefaultAppPool
        [ClusterLog] => C:\WINDOWS\Cluster\cluster.log
        [CommonProgramFiles] => C:\Program Files\Common Files
        [COMPUTERNAME] => SAM-WEB
        [ComSpec] => C:\WINDOWS\system32\cmd.exe
        [FP_NO_HOST_CHECK] => NO
        [NUMBER_OF_PROCESSORS] => 2
        [OS] => Windows_NT
        [Path] => C:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Symantec\pcAnywhere\;c:\netopacs;c:\amlib
        [PATHEXT] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
        [PROCESSOR_ARCHITECTURE] => x86
        [PROCESSOR_IDENTIFIER] => x86 Family 15 Model 6 Stepping 4, GenuineIntel
        [PROCESSOR_LEVEL] => 15
        [PROCESSOR_REVISION] => 0604
        [ProgramFiles] => C:\Program Files
        [SystemDrive] => C:
        [SystemRoot] => C:\WINDOWS
        [TEMP] => C:\WINDOWS\TEMP
        [TMP] => C:\WINDOWS\TEMP
        [USERPROFILE] => C:\Documents and Settings\Default User
        [windir] => C:\WINDOWS
        [__COMPAT_LAYER] => EnableNXShowUI 
        [FCGI_ROLE] => RESPONDER
        [APPL_MD_PATH] => /LM/W3SVC/1/Root/Senior/content/staff/it/printmaster
        [APPL_PHYSICAL_PATH] => E:\SAM_INTRA\www_root\Senior\content\staff\it\printmaster\
        [AUTH_TYPE] => {empty_string}
        [AUTH_PASSWORD] => {empty_string}
        [AUTH_USER] => {empty_string}
        [CERT_COOKIE] => {empty_string}
        [CERT_FLAGS] => {empty_string}
        [CERT_ISSUER] => {empty_string}
        [CERT_SERIALNUMBER] => {empty_string}
        [CERT_SUBJECT] => {empty_string}
        [CONTENT_LENGTH] => 0
        [CONTENT_TYPE] => {empty_string}
        [GATEWAY_INTERFACE] => CGI/1.1
        [HTTPS] => off
        [HTTPS_KEYSIZE] => {empty_string}
        [HTTPS_SECRETKEYSIZE] => {empty_string}
        [HTTPS_SERVER_ISSUER] => {empty_string}
        [HTTPS_SERVER_SUBJECT] => {empty_string}
        [INSTANCE_ID] => 1
        [INSTANCE_META_PATH] => /LM/W3SVC/1
        [LOCAL_ADDR] => 10.189.18.12
        [LOGON_USER] => {empty_string}
        [PATH_TRANSLATED] => E:\SAM_INTRA\www_root\Senior\content\staff\it\printmaster\index.php
        [QUERY_STRING] => {empty_string}
        [REMOTE_ADDR] => 10.189.114.142
        [REMOTE_HOST] => 10.189.114.142
        [REQUEST_METHOD] => GET
        [SCRIPT_NAME] => /Senior/content/staff/it/printmaster/index.php
        [SERVER_NAME] => 10.189.18.12
        [SERVER_PORT] => 80
        [SERVER_PORT_SECURE] => 0
        [SERVER_PROTOCOL] => HTTP/1.1
        [SERVER_SOFTWARE] => Microsoft-IIS/6.0
        [REMOTE_USER] => {empty_string}
        [REMOTE_PORT] => 53918
        [URL] => /Senior/content/staff/it/printmaster/index.php
        [REQUEST_URI] => /Senior/content/staff/it/printmaster/
        [DOCUMENT_ROOT] => E:\SAM_INTRA\www_root
        [SCRIPT_FILENAME] => E:\SAM_INTRA\www_root\Senior\content\staff\it\printmaster\index.php
        [HTTP_CONNECTION] => Keep-Alive
        [HTTP_ACCEPT] => image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
        [HTTP_ACCEPT_ENCODING] => gzip, deflate
        [HTTP_ACCEPT_LANGUAGE] => en-AU
        [HTTP_COOKIE] => ASPSESSIONIDCABCSCAD=BDAFCAKAOLBAAIBOPJJJAJPE; ASPSESSIONIDCCDBTDBC=GPLHFPLAKJKLBLGPFHJPFHOO; ASPSESSIONIDCCDCSCBC=DOALICMACBLLPEANMCNAJEPB; ASPSESSIONIDCABDTDAC=JHLLNEDBAFFEDOJKABDBAODI; ASPSESSIONIDAAADTCBD=NDKNNLFBCENANAPGPBJAFEKD; ASPSESSIONIDCCCBTCBD=ILEJLJGBGFCOLCGJLFEBKMAE; ASPSESSIONIDCCADTCAD=IMHHMPNBJIPPHIHKBAJDJCDF; ASPSESSIONIDAADADBAB=DOFNLLOBBKDBIGJMMABCEBMB
        [HTTP_HOST] => 10.189.18.12
        [HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3)
        [ORIG_PATH_INFO] => /Senior/content/staff/it/printmaster/index.php
        [PHP_SELF] => /Senior/content/staff/it/printmaster/index.php
        [REQUEST_TIME] => 1285815144
    )
    
    $_POST: Array
    (
    )
    
    $_GET: Array
    (
    )
    
    $_FILES: Array
    (
    )
    
    $_SESSION: {null}
    
    $_COOKIE: Array
    (
        [ASPSESSIONIDCABCSCAD] => BDAFCAKAOLBAAIBOPJJJAJPE
        [ASPSESSIONIDCCDBTDBC] => GPLHFPLAKJKLBLGPFHJPFHOO
        [ASPSESSIONIDCCDCSCBC] => DOALICMACBLLPEANMCNAJEPB
        [ASPSESSIONIDCABDTDAC] => JHLLNEDBAFFEDOJKABDBAODI
        [ASPSESSIONIDAAADTCBD] => NDKNNLFBCENANAPGPBJAFEKD
        [ASPSESSIONIDCCCBTCBD] => ILEJLJGBGFCOLCGJLFEBKMAE
        [ASPSESSIONIDCCADTCAD] => IMHHMPNBJIPPHIHKBAJDJCDF
        [ASPSESSIONIDAADADBAB] => DOFNLLOBBKDBIGJMMABCEBMB
    )
    Warning
    -------
    {doc_root}\Senior\content\staff\it\printmaster\index.php(22): include_once('E:\SAM_INTRA\ww...')
    {doc_root}\Senior\content\staff\it\printmaster\inc\init.php(16): fSession::setLength('1 hour')
    {doc_root}\Senior\content\staff\it\printmaster\inc\flourish\fSession.php(409): strtotime('1 hour')
    [internal function]
    strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for '9.5/no DST' instead
    Warning
    -------
    {doc_root}\Senior\content\staff\it\printmaster\index.php(22): include_once('E:\SAM_INTRA\ww...')
    {doc_root}\Senior\content\staff\it\printmaster\inc\init.php(17): fSession::open()
    {doc_root}\Senior\content\staff\it\printmaster\inc\flourish\fSession.php(306): session_start()
    [internal function]
    session_start(): Cannot send session cookie - headers already sent by (output started at E:\SAM_INTRA\www_root\Senior\content\staff\it\printmaster\inc\flourish\fCore.php:740)
    Warning
    -------
    {doc_root}\Senior\content\staff\it\printmaster\index.php(22): include_once('E:\SAM_INTRA\ww...')
    {doc_root}\Senior\content\staff\it\printmaster\inc\init.php(17): fSession::open()
    {doc_root}\Senior\content\staff\it\printmaster\inc\flourish\fSession.php(306): session_start()
    [internal function]
    session_start(): Cannot send session cache limiter - headers already sent (output started at E:\SAM_INTRA\www_root\Senior\content\staff\it\printmaster\inc\flourish\fCore.php:740)
    Thanks in anticipation. From what i can play with, it looks fantastic!!

  16. #45

    Join Date
    May 2009
    Location
    Whyalla, South Australia
    Posts
    16
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    11
    Sorry to double post, but i also noticed that the developer is looking at ways to make the Toner warning customisable. That's a great idea for the obvious reasons. I was thinking that as an alternative to making them manually customisable, perhaps they could reference the number of printers in the database. That way if you have Eight printers of one type, if the toner stock falls below 8 you get a yellow warning, and if it gets to 1 or 2you get red.

    Just an idea. Great work on it thus far anyway!

SHARE:
+ Post New Thread
Page 3 of 20 FirstFirst 123456713 ... LastLast

Similar Threads

  1. OCS Inventory
    By Geoff in forum Downloads
    Replies: 5
    Last Post: 3rd June 2011, 08:40 AM
  2. Inventory
    By school in forum Scripts
    Replies: 2
    Last Post: 3rd June 2010, 02:18 PM
  3. Inventory
    By mmoseley in forum Network and Classroom Management
    Replies: 15
    Last Post: 20th June 2007, 12:31 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. inventory system
    By bjg5858 in forum General Chat
    Replies: 2
    Last Post: 11th July 2006, 09:10 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •