jQuery Grid Plugin - jqGrid - Topic: Is jqgrid the wrong choice for my project? http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project Simple:Press Version 5.7.5.3 palobo on Is jqgrid the wrong choice for my project? http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3355 Help http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3355 OK. I see your dilema then.

Let's get creative then. A simple input filed before diplaying the grid. User starts typing in project number. Jquery autocomplete fetches possible matches from database. Onblur of the input feild and gird is created with the data pertaining to the specific project. This would maybe allow you to instead of relying on the users to update the time spent, just add aditional time and let server sum it all up.

Just an idea 😉

Cheers,
P.

]]> Sat, 29 Nov 2008 13:58:20 +0200 vinofilus on Is jqgrid the wrong choice for my project? http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3354 Help http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3354 Thanks. The grid/subgrid or master/detail option is very intriguing, and one that I hadn't explored at all. In this case, the reason the user enters a project number as text (rather than selecting from a list) is because there are hundreds of projects in the database, and we're trying to keep the form as simple and compact as possible (plus they'd like it to look somewhat like the old MS Jet database one we're replacing). So when they enter a project number, it's is looked up in the database and an english name is shown to the user, and then the rest of the line knows which project ID to assign the work times to when writing to the database. It seems convoluted to me, but I'm struggling with finding the simpler solution that must be out there. So far I can see the subgrid as simplifying this, but I'll keep pondering throughout the day.

Thanks again. Your suggestions get me thinking in different directions, which is exactly what I need!

]]> Sat, 29 Nov 2008 12:01:24 +0200 palobo on Is jqgrid the wrong choice for my project? http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3352 Help http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3352 Hi,

Just a quick thought, but wouldn't maybe a grd/subgrid or master/detail layout be more suited for such a task.

Elaborationg a bit more on this idea. In the main/master grid you could have the various projects and then use the subgrid/detail forf the time input.

Cheers,

P.

]]> Sat, 29 Nov 2008 11:23:04 +0200 vinofilus on Is jqgrid the wrong choice for my project? http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3351 Help http://www.trirand.com/blog/?page_id=393/help/is-jqgrid-the-wrong-choice-for-my-project#p3351 I have just started using jqgrid on a different project and am loving it.
But I am wondering if I am doing it the hard way with this project.

(I've redesigned the database twice already, but I have a hunch it's still wrong, and that may be my real problem.)

The user is supposed to be able to fill out a timesheet, something like the one pictured below, with dates along the top and project numbers along the side:

Form GridImage Enlarger

The 3 columns within each date column are for recording regular time worked or two kinds of overtime. When a new week starts they will see a blank grid and begin entering the project on which they are working, and what kind of hours on what days they worked. Throughout the week they will return to it and add or edit their work hours.

The database has fields: id, lineid, projectid, workdate, regulartime, overtime, bankedtime, employeeid (plus some others).

As you can see, a unique line of data in my database doesn't coincide with a line of data on the form. For example, the 3 green cells would be from one db entry, which holds the date, project id and times worked.

I can imagine writing the looping php/mysql code to extract the data manually into the xml necessary for jqgrid to build this form very nicely, but it seems like my php code is doing all the work, and when it comes to editing a cell or a line, I'll be writing all the code and loops and not really using the power and elegance of jqgrid.

Am I missing something obvious?
Am I barking up the wrong tree?
Is there an elegant way to do this?
(By the way, my bosses don't seem to think that the layout of the input form should be changed.)

Thanks for any help, criticism, suggestions or ideas you all have!

]]> Fri, 28 Nov 2008 19:20:52 +0200