Re: Gantt style chart
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58546
interpreted = N
texte = Man, you must love your work! Is this a billing app? Are you renting offices? If what you're after is a Gantt chart, there are certainly more graceful approaches than what you seem to be doing. I think your approach has locked locked up everyone on this list and would explain why you haven't gotten many responses. Try asking for some suggestions for your general problem and that might get you going the right direction. On Jun 22, 2004, at 12:14 AM, WebDna @ Inkblot Media wrote: > Hi All, > > I am attempting to build a Gantt style chart for a client. > > System: Linux, Web 4.5 > > We have start and end times for the meetings. The downside is that the > client needed to allow for meetings that overlap. For example meeting 1 > could be "9-11" and meeting 2 could be "10-12". That being said here is > where I have gotten to. > > Displaying 7am - 6pm in 30 minute blocks. > Storing the times as military numbers (9am = 900, 1pm=1300) > Manually built variables for indexing: > [!] --------------------------- > 7:00 > --------------------------- [/!] > > [text]700=1[/text] > [text]705=1[/text] > [text]710=1[/text] > [text]715=1[/text] > [text]720=1[/text] > [text]725=1[/text] > [text]730=2[/text] > [text]735=2[/text] > [text]740=2[/text] > [text]745=2[/text] > [text]750=2[/text] > [text]755=2[/text] > > This variable system lets me know if the meeting is 7-7:25 I fill cell > one. > If the meeting is 7:30-8 to fill cell two. > > I then do a search on the schedule.db where the when variable is a > date that > is passed in on the link. The P_ID is populated via a outer search > that sets > the persons ID. > > [search > db=schedules.db&eqS_DATEdatarq=[when]&S_DATEtype=date&eqP_IDdatarq=[id] > &P_ID > type=number&asS_TIMEsort=1&S_TIMEtype=num] > > [founditems] > [math show=f]count=[index][/math] > [math show=f]start[index]=[s_time][/math] > [math show=f]end[index]=[e_time][/math] > [/founditems] > > In the founditems I build a counter and an array (sort of) that holds > all > the start-end times for the person searching for. The idea behind this > was > to allow me to loop through the array and compare the times. > > [loop start=1&end=[count]] > [math show=f]nextindex=[index]+1[/math] > [If > (([interpret][end[index]][/interpret]=[interpret][start[nextindex]][/ > interpr > et]) | > ([interpret][end[index]][/interpret]>[interpret][start[nextindex]][/ > interpre > t]))] > [Then] > > [text]start[nextindex]=[interpret][start[index]][/interpret][/text] > [If > (([interpret][end[nextindex]][/interpret]<[interpret][end[index]][/ > interpret > ]))] > [Then] > > [text]end[nextindex]=[interpret][end[index]][/interpret][/text] > [/Then] > [/If] > [/Then] > [/If] > [/loop] > > This is the part I am stuck on. This actually will take the first and > second > meeting and compare them. If they over lap it should merge the data > into the > second meeting holder inside the array. It seems to work, but I still > have > the original meeting inside the array. > > If I am going about this all wrong please let me know. Any assistance > with > this is greatly appreciated. > > Sincerely, > RonnyMc > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Man, you must love your work! Is this a billing app? Are you renting offices? If what you're after is a Gantt chart, there are certainly more graceful approaches than what you seem to be doing. I think your approach has locked locked up everyone on this list and would explain why you haven't gotten many responses. Try asking for some suggestions for your general problem and that might get you going the right direction. On Jun 22, 2004, at 12:14 AM, WebDna @ Inkblot Media wrote: > Hi All, > > I am attempting to build a Gantt style chart for a client. > > System: Linux, Web 4.5 > > We have start and end times for the meetings. The downside is that the > client needed to allow for meetings that overlap. For example meeting 1 > could be "9-11" and meeting 2 could be "10-12". That being said here is > where I have gotten to. > > Displaying 7am - 6pm in 30 minute blocks. > Storing the times as military numbers (9am = 900, 1pm=1300) > Manually built variables for indexing: > [!] --------------------------- > 7:00 > --------------------------- [/!] > > [text]700=1[/text] > [text]705=1[/text] > [text]710=1[/text] > [text]715=1[/text] > [text]720=1[/text] > [text]725=1[/text] > [text]730=2[/text] > [text]735=2[/text] > [text]740=2[/text] > [text]745=2[/text] > [text]750=2[/text] > [text]755=2[/text] > > This variable system lets me know if the meeting is 7-7:25 I fill cell > one. > If the meeting is 7:30-8 to fill cell two. > > I then do a search on the schedule.db where the when variable is a > date that > is passed in on the link. The P_ID is populated via a outer search > that sets > the persons ID. > > [search > db=schedules.db&eqS_DATEdatarq=[when]&S_DATEtype=date&eqP_IDdatarq=[id] > &P_ID > type=number&asS_TIMEsort=1&S_TIMEtype=num] > > [founditems] > [math show=f]count=[index][/math] > [math show=f]start[index]=[s_time][/math] > [math show=f]end[index]=[e_time][/math] > [/founditems] > > In the founditems I build a counter and an array (sort of) that holds > all > the start-end times for the person searching for. The idea behind this > was > to allow me to loop through the array and compare the times. > > [loop start=1&end=[count]] > [math show=f]nextindex=[index]+1[/math] > [If > (([interpret][end[index]][/interpret]=[interpret][start[nextindex]][/ > interpr > et]) | > ([interpret][end[index]][/interpret]>[interpret][start[nextindex]][/ > interpre > t]))] > [Then] > > [text]start[nextindex]=[interpret][start[index]][/interpret][/text] > [If > (([interpret][end[nextindex]][/interpret]<[interpret][end[index]][/ > interpret > ]))] > [Then] > > [text]end[nextindex]=[interpret][end[index]][/interpret][/text] > [/Then] > [/If] > [/Then] > [/If] > [/loop] > > This is the part I am stuck on. This actually will take the first and > second > meeting and compare them. If they over lap it should merge the data > into the > second meeting holder inside the array. It seems to work, but I still > have > the original meeting inside the array. > > If I am going about this all wrong please let me know. Any assistance > with > this is greatly appreciated. > > Sincerely, > RonnyMc > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Patrick McCormick
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
PCS Emailer's role ? (1997)
[MATH] and Dates (1998)
default value from Lookup (was Grant, please help me) (1997)
international time (1997)
The future of WebCatalog is coming with 4.0... (2000)
Re:Realtime Transaction Processing (1999)
Redirect (2003)
Random Images (2000)
A question on sub-categories (1997)
showif comparison begins w/ and contains (1997)
CAPTCHA (2006)
WebDNA Developer Resource Center (2002)
RE: OK, here goes... (1997)
[OT] ISP Windows program (2005)
Math Context (1998)
Hiccup ***** (1998)
Major bug report on rootbeer (1997)
AquaZone (2006)
A question on sub-categories (1997)