Toner inventory Database

[webman]

Do you have Javascript enabled in your web browser?

[eclass]

Thanks for the quick replys, I tested this in 3 different computers and I'm still getting the same message/page do you think its a permission issue?

[eclass]

Ok I fixed it, it was a permission issue in the Printmaster/web/_boxy java folder.

[eclass]

Anyone encounter this error message when deleting a consumable?

 

see attached picture:

[webman]

eclass: Sorry about that. It occurs because you have previously installed that consumable in a printer, and the database won't let you remove it with the current setup.

 

To resolve this, run this query on the database from phpMyAdmin (or similar) and then try to delete the consumable again.

 

ALTER TABLE `events` DROP FOREIGN KEY `events_ibfk_4`;
ALTER TABLE `events` ADD FOREIGN KEY (`consumable_id`) REFERENCES `printmaster`.`consumables`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

 

(This also presumes your database is called 'printmaster')

 

Hope that helps.

[eclass]

Thanks, ill give it a try

[ccoronado]

Hi

First off I would like to say that I have found your software a fantastic piece of work, it has filled a massive gap in what we needed, especially that it is very user freindly. I have actually translated it to spanish so it can also be used in south america.

I would like to ask for your help, I am very very green in the PHP arena, what I need is to be able to filter search the printer using a text box in quickadd.php, the reason for this is that we have over 50 printers and we would like to filter the printer using its name (id) so to quicken the process of installing the toner. This way also we can use a bar code scanner. I will be adding some extra features to the software soon, and I promise I will upload them to the forum. I would greatly apreciate you help as I have not been able to figure out how to filter the list in quickadd.php .

Thanks

 

Chris

Edited August 26, 2011 by ccoronado

[webman]

ccoronado: Thanks for your comments, much appreciated

 

Having a search/filter for printers on the front page would definitely be a good idea, and is something I can look at adding soon.

 

Thanks for your offer of contributing some extra features too - that's something the whole community can benefit from.

[ccoronado]

Hi again

 

Thanks for replying, sorry about not being online at the time that you answered, but it´s also the time diference that dosn´t help much.

Well I have been looking at your code and I still cannot identify where the listing of printers is generated from, so I can stick in a variable to filter out the printers. What I am going to do is that when a user needs a toner, they will go to a page where they will input the printer number that they want toner for, this will print out a petition form which needs to be signed by thier supervisor. The form itself will have a barcode that will be scanned by the person who distributes the toners, which in turn will filter out the printer that needs the new toner. The page where the user will go to will be linked to the database so it can check if there is any toner or ink left for that printer, if there isn´t any, it will inform the user, this way they will not have to come to the IT department to ask for inks. I know it sounds a bit tidious but compared to how they work now, it´s a hug step forward.

 

So if you can kind of point me in the right direction for the filtering I´ll give it a go, and agin thanks for all your help.

[webman]

Hi. It sounds like you have a clear idea of what you want there, that's great

 

OK. The actual code that shows the list of printers is L28 in quickadd.php. The list of printers comes from the $printers variable. This is defined at line 64 in index.php - it just gets a list of all the printers (function in Printer model file - but you shouldn't need to change this).

 

But really, you probably don't need to change any of that as it is. As the printers are just an HTML list, you can use a bit of javascript to filter that list based on a search field (in a similar way to the table on the Printers page itself).

 

I had a very quick look for a jQuery list filter, and found this tutorial - that might be a good place to start?

[ccoronado]

Sorry about not writting back for such a long time, Im also in charge of a few asterisk servers and over 100 extensions and we had a problem with one group having echo issues.

I thankyou for you info, I will look into the query you have provided and I will now be back on track with the software (until some new problem arises ). I apreciate all the help you are giving me and I will be back with my progress soon.

 

thanks..

[jmfahnbulleh]

Hi Webman!! First of all, thanks for a great inventory database!! My firm has about 200 printers (in one location) and when you first open PrintMaster they list all the way down the page. When you install a consumable on the first page (without scrolling past the first page) the pop-up button container shows up in the second column as it should. BUT, say you scroll down to the last printer and install a consumable, then the button containers show up off the page all the way at the top of the page. With so many printers, this becomes tedious having to scroll all the way back up.

 

I was wondering if there's a way to make the buttons show in a pop-up dialog box or something instead of not being bound to the very top of column?? Or like when you add a consumable the Dialog box pops up in the middle of the screen regardless of where you are on the list of printers (230 in my case.)

Ive been looking at the Jquery website for help and Im sure it's there, but its so overwhelming at times and there are so many calls from one page to the page in PrintMaster!

 

Id appreaciate your help or anyone's help if someone is still looking at this forum for ideas, etc.

 

Thanks and have a great day!!!

JMF

[webman]

Hi JMF, thanks for your comments about PrintMaster - I'm glad you find it useful

 

Wow, yes, I can see how that is a bit of a problem for you, and a bit of a bad UI for that amount of printers. It'd certainly be possible to have the buttons appear in a modal dialog with some small tweaks, but that's not a quick "five-minute fix" or something I can do into in one forum post. Another solution that might be acceptable, would be to make the printer list a fixed height and scrollable. The code you have should already have an example of this.

 

Line 27 of /views/home/quickadd.php

 

You will notice this line:

 

 

Remove the HTML comments so that the line looks like this:

 

 

If you want it bigger, just increase the 300 value to something more suitable.

 

Hope that's somewhat helpful to you.

 

I have lots of ideas for PrintMaster, based on great feedback from the EduGeek community (so thanks for that!) - I'm disappointed that I just don't have enough free time to bring them to life in a decent amount of time.

[jmfahnbulleh]

Hey there!!!! Thanks for your quick response!!! Using the commented code works great!! I was wondering what those were there for, but never thought that it was related to the size of the table. I've been pulling my hair out trying to figure out how the buttons got made, then how they got to the buttoncontainer and why? Then last week Jquery was updated to 1.82 and I had this marvelous idea of using the newly introduced position utility where I could put the buttons right at the mouse pointer or thereabouts and that drove me crazy too, lol!!

 

Well, Im am now going to move onto some other refinements on this like page counts, adding consumables from the printer listing page, and other things we can use to make our task easier here.

 

thanks again and I'll be in touch again soon....

Janii

[webman]

The javscript to handle the showing of consumables on printer clicking is located in the same file quickadd.php, but at line 57.

 

You could probably set the position of the #buttoncontainer DIV with javascript if you wanted to, after the buttons had been added.

[RabbieBurns]

Hi webman, still using this great bit of software.. Liking a lot of the suggestions made as well so its a shame you don't have time to implement them..

 

would perhaps starting a PayPal donation scheme help you find the time..

 

anyway, Im trying to run a report of how many toners I have added to the system however it seems to only show how a report of individual dishing out of toners..

 

Is there something simple i can do (either through mysql on the command line or adding to the php code) that will give me a dump the toners added in a definable period please?

[webman]

Hey - glad you're still finding it useful

 

It's a nice idea, but I don't think donations would help with finding the time, unfortunately!

 

Currently, the system doesn't record information about when toners are added to stock - as you say, just for installing them in printers. So it would not be possible to create a query for the information you're wanting.

[RabbieBurns]

No worries ill just trawl through my order book

[jmansoor]

Hey everyone! I would like to say thank you to webman and everyone else that took that time to work on this project. I'm really happy that I came across it. I read this thread a few times already and unless i'm blind (its possible!) I didn't see an answer to this particular problem.

Uncaught fProgrammerException ----------------------------- {doc_root}/printer/manufacturers.php(39): include('/hermes/bosweb2...') {doc_root}/printer/views/manufacturers/index.php(30): Manufacturer->countModels() {doc_root}/printer/views/manufacturers/index.php(30): fActiveRecord->__call('countModels', Array) {doc_root}/printer/inc/flourish/fActiveRecord.php(923): fORMRelated::countRecords('Manufacturer', Array, Array, 'Model') {doc_root}/printer/inc/flourish/fORMRelated.php(290): fORMSchema::getRouteName(Object(fSchema), 'manufacturers', 'models', NULL, '*-to-many') {doc_root}/printer/inc/flourish/fORMSchema.php(179) The table manufacturers is not in a *-to-many relationship with the table models

 

I'm going to read everything again for fun! If anyone can help it will be greatly appreciated!\

 

Thanks

[webman]

jmansoor, thanks for checking out PrintMaster - hopefully it will be useful for you as well!

 

The problem described, I think, is that the code is not getting the correct results from auto-detecting the database layout.

 

Are the tables using the InnoDB engine, and are foreign keys configured properly? Did you run the whole printmaster.sql file, including the ALTER TABLE statements at the end?

[jmansoor]

Thanks for the quick response! I checked with my hosting provider and unfortunately they do not offer the innodb option in mysql. looks like I will have to install this on my VM!

 

Thanks again

[webman]

Hi again.

 

Ah, that is quite a shame Unfortunately the code and DB libraries used require InnoDB for it to auto-detect the relationships between the various items; so there isn't a straight-forward way around this.

 

Good luck on the VM

[cscheck]

Others: Re: costs. At the moment, I'm not looking at developing the costs feature due to higher priorities (private work, Classroombookings). I agree it would be a good feature to have, and probably one day I'll do it; just not right now

 

Wasn't sure if you had considered picking this project back up and adding the cost feature or not. This is really an important function is replacing out spreadsheets with a more efficient application.

 

Thanks so much for all you have done on this project already. The app is wonderful.

 

 

Also, if anyone else has implemented a cost tracking feature and would be willing to share it, I would be greatly appreciative of that person!!!

 

 

Thanks again webman and all contributors.

[martinho]

Hi all, first post....

 

This does look awsome, however I can't get it to work or figure out why. The error I get is the following Fatal error: Class 'fCore' not found in C:\Program Files\EasyPHP-12.1\www\my portable files\inc\config.php on line 15

I think it has to do with Easy PHP setup and not printmaster...

 

Thanks in Advanced

[eclass]

I love this software and hope its still being updated / enhanced any news?