dcsimg
www.webdeveloper.com
Results 1 to 7 of 7

Thread: Project Status

  1. #1
    Join Date
    Dec 2002
    Posts
    316

    Project Status

    Dear gurus,
    I need help with a project I am working on.
    I am tasked with designing and developing a task tracking project. It tracks all projects that are currently going.
    For instance, if a project is signed off and tasks have been assigned to various individuals, then there is a tracking mechanism that tells at what stage the project is on and if there is a bottleneck, where that bottlenect is coming from.
    Now the database has been designed and table structures have been laid out.
    What I would need help on is coming up with a code that tells what stage a project is currently on.
    This is going to be graphically represented.
    For instance, it will be laid out like this:

    circle --> circle --> circle -->
    The above represent real circles each representing a particular task.
    Now if the project is currently on circle2, then we need to come up with something like a color that indicates that the project is currently on circle2.
    Can someone please give me a head start on this, assuming that I have not confused you.
    thanks in advance

  2. #2
    Join Date
    Dec 2002
    Posts
    316
    sorry, I forgot to indicate that the tasks, you already know will be time-driven
    For instance, if a task is assigned, an individual may be required to complete for say, 3 days.
    If completed, a date is automatically assigned.
    This part, I think I can handle.
    If the task is not completed within the giving timeframe, an email is sent out to the individual reminding him/her that task is past due.
    I hope someone is done something similar.
    I very new to this, so please forgive me.

  3. #3
    Join Date
    Nov 2002
    Posts
    5

    Lightbulb

    Hi,
    You can't do this using ASP.
    Try out the following
    1. Use Java Script.
    2. Try Tables instead of Circles.
    3. Change the Cell Background color.

    may be this could help you...

    $ai.

  4. #4
    Join Date
    Nov 2002
    Posts
    411
    I may have completely misunderstood what you were asking, but as for the circles bit and indicating what stage you were on, then i'd do it (probably very inefficiently!) by having two jpgs, green.jpg and red.jpg which are coloured circles. then i'd have an if clause in the asp that if there was a date for completion for that stage in (ie the job has been completed since the date has been entered, or even if today's date is greater than the date specified) then it outputs the green.jpg line (<img src='green.jpg'>). If not, then it does the red one.

    As for the emailing out etc, i would concur with sai, but again i may be wrong. As far as I'm aware, you've got to look at what's actually happening in IIS - all it does is run asp pages when they're requested, so it's good at things like making a page say "good morning" or "good afternoon" dfepending on the time of day. If you wanted something to email you every time it changed from morning to afternoon though, that would require it to be running full time, not just when it was asked for it. You could probably get it to email something if a condition was met, but again it relies on someone accessing that page - it doesnt run away in the background waiting for time markers to pass to see if it should be doing something at that particular time.

    Hope that helps,

  5. #5
    Join Date
    Dec 2002
    Posts
    316
    John and Sai, thank you!
    John, I have come up with something similar to your status explanation.
    I have also come up with a code that will send an email when deadline is missed.
    I am, however, having problem with it.
    Can anyone of you take a look, please?
    here is the entire code:

    I have been working on this now for two days and can seem to take my thought process any higher than it is right now.
    I need your help!
    I am trying to implement a task program whereby if you are given a certain task with a timeline to complete the task, if the deadline is not met, an email is to be sent to you as a reminder that your task is past the deadline.
    Right now, I am not getting any errors but it is not doing anything.
    Please take a look and see if you can help!

    <%@ language=vbscript %>

    <!-- #include file="adovbs.inc" -->
    <%

    ' Define variables
    Dim objConn, objRS
    Dim dtmCutoffDate
    Dim strCutoffDate

    ' Make sure the date format cannot be confused
    dtmCutoffDate = DateAdd("d",+1,Date)
    strCutoffDate = Day(dtmCutoffDate) & " " & MonthName(Month(dtmCutoffDate)) & _
    " " & Year(dtmCutoffDate)

    ' Create and setup connection object
    Set objConn = CreateObject("ADODB.Connection")
    objConn.Open "DSN=&&##@@"

    ' Retrieve tasks that are to be printed for missing due date
    Set objRS = CreateObject("ADODB.RecordSet")
    objRS.Open "SELECT * FROM tblNewsItems WHERE dueDate < '" & _
    strCutoffDate & "';", objConn, adOpenKeyset, adLockOptimistic, adCmdText

    if (cStr(Request("dueDate")) > enddate) Then
    dim MailObj
    set MailObj = Server.CreateObject("CDONTS.NewMail")
    MailObj.From = Request.Form("name")
    MailObj.To = "someone@yahoo.com"
    MailObj.Subject = "Your Task Is Past The Due Date"
    MailObj.Body = "Email was sent by: " & Request.Form("name") & vbcrlf & vbcrlf&_
    "someone@yahoo.com:" & vbcrlf&_
    Request.Form("email")
    MailObj.Send()
    set MailObj = nothing
    End If
    %>
    <html>
    <body>
    <form name="form1" method="post" action="">
    <input type="text" name="name">
    <input type="text" name="email">
    <input type="submit" name="Submit" value="Submit">
    </form>
    </body>
    </html>

  6. #6
    Join Date
    Nov 2002
    Posts
    411
    my c skills aren't that great but i have a fair idea of what i'm doing, but wont that just do the email only if you run that page? I dont quite see how that solves your problem - that script will send an email if the item is overdue every time the page is run - so where is the page called from, and what's to stop the poor bugger who's overdue getting an email every two minutes as the page is re-run saying that the item is overdue?

    I'm quite interested to see how you're getting over this because it would be awfully useful for future use - sorry if i sound like the devil's advocate!

  7. #7
    Join Date
    Dec 2002
    Posts
    316
    you are precisely right!
    That code, after I modified it, would only run if I run it.
    What I have decided as a workaround, after pulling a few hair strands, is to write a stored procedure with T-SQL and then set up a job schedule that will execute t he stored proc ONLY if someone misses a deadline by a specified timeline.
    It is a great concept; my store procedure is already written and tested but the job scheduling is yet to be set up.
    I am confident that will do the trick.
    I had hoped to do it with asp but as you can see, i am not having any luck.

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
  •  
HTML5 Development Center



Recent Articles