| Index
» Projects
» phpMyEdit
» Forum
» Listing records under Week numbers |
 |
Raegann
Joined: 04 Jun 2011
Posts: 1
Posted: 2011-06-04 22:59
Back to top
Reply with quote
|
Hi all,
at first I would like to thank for this wonderful tool which saved me a lot of work. I just started using it yesterday.
Here is my project which I'm currently working on.
http://software.microware.cz/editor/dnt_zakazky.php
As you can see it's pretty simple, just a list of orders with some basic information. It's sorted by date which was the order placed to the system. On bottom there are some orders printed with green color, those are finished orders.
I just need one thing and that is to divide this one form into many other. Under the heading in format "Week XY Year ABCD", there will be a form with orders from the given Week and Year.
How can I make it in phpmyedit easily? Is it possible to make many independent DB queries in one phpmyedit script and how? Also, would it be possible to achieve directly through the main php file or would it be necessary to edit the phpMyEdit.class.php?
Also, I didn't find a fast solution but how can I just write a single value from another table (containing about 3 columns) and paste it for editing under the main form? There will be a table with about 3 columns (Week, Year, Capacity). Under each Week Year, there will be the form and under the form there will be these values:
Capacity
Sum of completed orders (computed value)
Sum of all orders (computed value)
Problem is, I don't know how to display the value Capacity from the second table and how to display the two variables which are used for computing the sums with SQL query (probably using "SELECT COUNT(column_name) FROM table_name WHERE"?).
Thanks a lot for any answer and sorry for my newbie questions and probably mediocre English also. :)
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2011-06-05 11:21
Back to top
Reply with quote
|
First, create a filter that works for year and week, for example purposes.
http://opensource.platon.sk/projects/doc.php/phpMyEdit/html/configuration.filters.html
When you have a filter which works, devise a method to display links in the footer to pass a number of weekly filters, and evaluate the passed variables to create the appropriate filters.
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2011-06-05 11:26
Back to top
Reply with quote
|
First, create a filter that works for year and week, for example purposes.
http://opensource.platon.sk/projects/doc.php/phpMyEdit/html/configuration.filters.html
When you have a filter which works, devise a method to display links in the footer to pass a number of weekly filters, and evaluate the passed variables to create the appropriate filters.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
