# -*- coding: utf-8 -*-
"""
    MoinMoin - TaskPlanner Action
    Version 0.9

    A task planner plugin for Moin.

    General information:
    * The task database file "task-db" is located in the wiki's data dir and is
      a plain text file.
    * The total number of tasks is currently restricted to 999.999 tasks. However
      a plain text database doesn't scale very well. So try to keep the database
      small and do remove task not needed anymore.
    * Note: Removing a task from the database does also mean: deleting the task's wiki
      homepage.
    * Note: You have to be superuser to be able to remove tasks. Normal users can mark
      a completed task with the label "remove me" so superuser get to know which tasks to
      remove.
 
    @copyright: 2007 by Oliver Siemoneit
    @license: GNU GPL, see COPYING for details.
    Adapted for version 1.9.1 by JV

"""

import os, time
from MoinMoin import config, wikiutil, user
from MoinMoin.Page import Page
from MoinMoin.util import timefuncs
from MoinMoin.mail.sendmail import sendmail


def _make_unique_task_id(request):
    """
        Make unique task id
        
        @param request: request object
        @return: 6-digit id (string)
    """
    from random import randint
    databaseFile = os.path.join(request.cfg.data_dir, "task-db")
    if os.path.isfile(databaseFile):
        existing_id = task_id = 0
        while task_id == existing_id:
            task_id = "%06d" % randint(1, 999999)
            for line in open(databaseFile).readlines():
                    tmp = line.split("\t")
                    existing_id = tmp[0]
                    if existing_id == task_id:
                        break
    else:
       task_id = "%06d" % randint(1, 999999)

    return task_id


def _make_local_timestamp(request):
    """
        Make a timestamp for creation/closing of task

        @param request: request object
        @return: timestamp (string)
    """
    now = time.time()
    user = request.user

    if user.valid and user.tz_offset:
        tz = user.tz_offset
        tz -= tz % 60
        minutes = tz / 60
        hours = minutes / 60
        minutes -= hours * 60
        now += tz

    return time.strftime("%Y.%m.%dT%H:%M:%S", timefuncs.tmtuple(now))


def do_mainform(request, actname, msg=None):
    """
        Build the main form

        @param request: request object
        @param actname: actname object 
        @param msg: message to display
        @return: html form (string)
    """
    _ = request.getText
    ticket = wikiutil.createTicket(request)
    querytext = _('TaskPlanner User Interface')
    button1 = _('Add Task')
    button2 = _('Edit Task')
    button3 = _('Remove Task')
    button4 = _('Close')

    formhtml1 = '''
<form method="post" action="">
<strong>%s <br></strong>''' % querytext
    
    if msg:
        formhtml2 = "<br> %s <br>" % msg
    else:
        formhtml2 = ""

    formhtml3 = '''
<br> 
<input type="hidden" name="action" value="%(actname)s">
<input type="hidden" name="ticket" value="%(ticket)s">
<input class="buttons" type="submit" name="button_add" value="%(button1)s">
<input class="buttons" type="submit" name="button_edit" value="%(button2)s"> '''  % {
    'actname'  : actname,
    'ticket'   : ticket,
    'button1'  : button1,
    'button2'  : button2, }

    if request.user.isSuperUser():
        formhtml4 = '''
<input class="buttons" type="submit" name="button_remove" value="%(button3)s">''' % {
    'button3'  : button3, }
    
    else:
        formhtml4 = ""

    formhtml5 = '''
<input class="buttons" type="submit" name="button_cancel" value="%(button4)s">
</form>''' % {
    'button4'  : button4, }
    
    formhtml = formhtml1 + formhtml2 + formhtml3 + formhtml4 + formhtml5
    return formhtml


def do_addform(request, actname, page, msg=None, assoc_page=None, assign=None):
    """
        Build the 'add task' form
        
        @param request: request object
        @param actname: actname object
        @param page: page object
        @param msg: message to display
        @param assoc_page: preset page association (by TaskTable macro)
        @param assign: preset assign (by TaskTable macro)
        @return: html form (string)
    """
    _ = request.getText
    ticket = wikiutil.createTicket(request)
    task_id = _make_unique_task_id(request)
    querytext = _('Add Task')
    button1 = _('Add')
    button2 = _('Cancel')
    label1 = _('Task ID')
    value1 = task_id 
    label2 = _('Created by')
    value2 = request.user.name
    label3 = _('Created on')
    value3 = _make_local_timestamp(request)
    label4 = _('Task name')
    value4 = ""
    label5 = _('Assigned to')
    if assign:
        value5 = assign.replace('%20', ' ')
    else:
        value5 = ""
    label6 = _('Time-frame')
    value6 = ""
    label7 = _('Priority')
    value7 = ""
    label8 = _('Status')
    value8 = _('to do')
    label9 = _('Task description')
    value9 = ""
    label10 = _('Task\'s wiki homepage')
    value10 = "ToDos/%s" % task_id
    label11 = _('Task associated with page')
    label12 = _('Notify assignee by email?')
    value12= "Yes"
    if assoc_page:
        value11 = assoc_page.replace('%20', ' ')
    else:
        value11 = page.page_name

    formhtml1 = '''
<form method="post" action="">
<div class="userpref">
<strong>%s <br></strong>''' % querytext
    
    if msg:
        formhtml2 = "%s" % msg
    else:
        formhtml2 = ""

    formhtml3 = '''
<br>
<input type="hidden" name="action" value="%(actname)s">
<input type="hidden" name="ticket" value="%(ticket)s">
<input type="hidden" name="closed_by" value="unknown">
<input type="hidden" name="closed_at" value="unknown">
<table border="0">
    <tr>
        <td class="label"><label>%(label1)s</label></td>
        <td class="content">
            <input type="text" name="task_id" value="%(value1)s" size="6" readonly="readonly">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label2)s</label></td>
        <td class="content">
            <input type="text" name="created_by" value="%(value2)s" size="36" readonly="readonly">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label3)s</label></td>
        <td class="content">
            <input type="text" name="created_at" value="%(value3)s" size="36" readonly="readonly">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label4)s</label></td>
        <td class="content">
            <input type="text" name="task_name" value="%(value4)s" size="36" maxlength="50">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label5)s</label></td>
        <td class="content">
            <input type="text" name="assigned_to" value="%(value5)s" size="36" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label6)s</label></td>
        <td class="content">
            <input type="text" name="time_frame" value="%(value6)s" size="36" maxlength="20">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label7)s</label></td>
        <td class="content">
             <select name="priority" size="1">
               <option selected value="">   </option>
               <option value="low">%(low)s</option>
               <option value="medium">%(medium)s</option>
               <option value="high">%(high)s</option>
               <option value="critical">%(critical)s</option>
             </select>
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label8)s</label></td>
        <td class="content">
             <select name="status" size="1">
               <option selected value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
             </select>
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label9)s</label></td>
        <td class="content">
            <input type="text" name="task_desc" value="%(value9)s" size="80" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label10)s</label></td>
        <td class="content">
            <input type="text" name="task_disc_page" value="%(value10)s" size="80" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label11)s</label></td>
        <td class="content">
            <input type="text" name="task_assoc" value="%(value11)s" size="80" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label12)s</label></td>
        <td class="content">
            <input type="checkbox" name="email_notification" value="%(value12)s">
        </td>
    </tr>
    <tr>
        <td> </td>
        <td>
        <input class="buttons" type="submit" name="button_add_a" value="%(button1)s">
        <input class="buttons" type="submit" name="button_back" value="%(button2)s">
        </td>
    </tr>
</table>
</div>
</form>''' % {
    'actname'    : actname,
    'ticket'     : ticket,
    'label1'     : label1,
    'value1'     : value1,
    'label2'     : label2,
    'value2'     : value2,
    'label3'     : label3,
    'value3'     : value3,
    'label4'     : label4,
    'value4'     : value4,
    'label5'     : label5,
    'value5'     : value5,
    'label6'     : label6,
    'value6'     : value6,
    'label7'     : label7,
    'low'        : _('low'),
    'medium'     : _('medium'),
    'high'       : _('high'),
    'critical'   : _('critical'),
    'label8'     : label8,
    'ToDo'       : _('to do'),
    'Pending'    : _('pending'),
    'InProgress' : _('in progress'),
    'label9'     : label9,
    'value9'     : value9,
    'label10'    : label10,
    'value10'    : value10,
    'label11'    : label11,
    'value11'    : value11,
    'label12'	 : label12,
    'value12'	 : value12, 
    'button1'    : button1,
    'button2'    : button2
}
    formhtml = formhtml1 + formhtml2 + formhtml3
    return formhtml


def _check_form_input(request):
    """
        Check for valid input in 'add task' and 'edit task' form

        @param request: request object
        @result: result (string)
    """
    _ = request.getText
    task_name = request.form.get('task_name', [""])
    task_name = task_name.strip(' ')
    if task_name == "":
        return (_('You have to specify a task name.'), "warning")

    assigned_to = request.form.get('assigned_to', [""])
    assigned_to = assigned_to.strip(' ')
    if assigned_to == "":
        return (_('You have to assign the task to someone.'), "warning")
    else:
        assignee_id=user.getUserId(request, assigned_to)
	if assignee_id==None:
	    return (_('You can only assign the task to a user.'), "warning")

    time_frame = request.form.get('time_frame', [""])
    time_frame = time_frame.strip(' ')
    if time_frame != "":
        from time import strptime
        try:
            time_struct = strptime(time_frame, "%d.%m.%y")
        except ValueError:
            try:
                time_struct = strptime(time_frame, "%d.%m.%y %H:%M")
            except ValueError:
                return (_('Valid time-frame formats are either dd.mm.yy or dd.mm.yy hh:mm.'),"warning")
    return ""


def _save_task(request):
    """
        Save task data to disc

        @param request: request object
        @return: result (string)
    """
    _ = request.getText
    task_id = request.form.get('task_id', [""])
    created_by = request.form.get('created_by', [""])
    created_at = request.form.get('created_at', [""])
    closed_by = request.form.get('closed_by', [""])
    closed_at = request.form.get('closed_at', [""])
    task_name = request.form.get('task_name', [""])
    task_name = wikiutil.escape(task_name, 1)
    task_name = wikiutil.clean_input(task_name)
    assigned_to = request.form.get('assigned_to', [""])
    assigned_to = wikiutil.escape(assigned_to, 1)
    assigned_to = wikiutil.clean_input(assigned_to)
    time_frame = request.form.get('time_frame', [""])
    priority = request.form.get('priority', [""])
    status = request.form.get('status', [""])
    task_desc = request.form.get('task_desc', [""])
    email_notification = request.form.get('email_notification',[""])
    if task_desc != "":
        task_desc = wikiutil.escape(task_desc, 1)
        task_desc = wikiutil.clean_input(task_desc)
    task_disc_page = request.form.get('task_disc_page', [""])
    if task_disc_page != "":
        task_disc_page = wikiutil.escape(task_disc_page, 1)
        task_disc_page = wikiutil.clean_input(task_disc_page)
    task_assoc = request.form.get('task_assoc', [""])
    if task_assoc != "":
        task_assoc = wikiutil.escape(task_assoc, 1)
        task_assoc = wikiutil.clean_input(task_assoc)
            
    try:
        databaseFile = os.path.join(request.cfg.data_dir, "task-db")
        db = open(databaseFile,"a")
        db.write("%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n" % (task_id,
                                                                           created_by,
                                                                           created_at,
                                                                           closed_by,
                                                                           closed_at,
                                                                           task_name,
                                                                           assigned_to,
                                                                           time_frame,
                                                                           priority,
                                                                           status,
                                                                           task_desc,
                                                                           task_disc_page,
                                                                           task_assoc))
        db.close()
    except IOError:
        return (_('Error while trying to save task data.'), "error")
    if email_notification=="Yes":
	#here must the notify by email function call appear
	#make the email body
	txtbody =u'''
Hi,
You have been assigned a new task.
The task details are: 
 Created by: %(1)s
 Created at: %(2)s
 Task_name: %(3)s
 Finish before: %(4)s
 Priority: %(5)s
 Status: %(6)s
 Task description: %(7)s
Have a good day!
	''' % {
		'1': created_by,
		'2': created_at,
		'3': task_name,
		'4': time_frame,
		'5': priority,
		'6': status,
		'7': task_desc,
	      }
	# get email address
	# first make a user
	assignee=user.User(request,id=user.getUserId(request, assigned_to))
	# then load the data from disk so that its email adress becomes available
	assignee.load_from_id()
	# then we can send
	sendok=sendmail(request, [assignee.email], u'New task: '+task_name, txtbody)[0]
	if sendok:
	    return (_('Task succesfully saved and assignee notified succesfully.'),"ok")
	else:
	    return (_('Task successfully saved but assignee could not be notified.'), "warning")
    return (_('Task successfully saved.'), "ok")  

def do_edit_search_form(request, actname, msg=None):
    """
        Build the 'search task for editing' form

        @param request: request object
        @param actname: actname object
        @param msg: message to display
        @return: html form (string)
    """
    _ = request.getText
    ticket = wikiutil.createTicket(request)
    querytext = _('Edit Task')
    button1 = _('Edit')
    button2 = _('Cancel')
    label1 = _('Task ID')
    value1 = ""

    formhtml1 = '''
<form method="post" action="">
<div class="userpref">
<strong>%s <br></strong>''' % querytext
    
    if msg:
        formhtml2 = "%s" % msg
    else:
        formhtml2 = ""

    formhtml3 = '''
<br>
<input type="hidden" name="action" value="%(actname)s">
<input type="hidden" name="ticket" value="%(ticket)s">
<table border="0">
    <tr>
        <td class="label"><label>%(label1)s</label></td>
        <td class="content">
            <input type="text" name="task_id" value="%(value1)s" size="6" maxlength="6">
        </td>
    </tr>
    <tr>
        <td> </td>
        <td>
        <input class="buttons" type="submit" name="button_search_id" value="%(button1)s">
        <input class="buttons" type="submit" name="button_back" value="%(button2)s">
        </td>
    </tr>
</table>
</div>
</form>''' % {
    'actname': actname,
    'ticket' : ticket,
    'label1' : label1,
    'value1' : value1,
    'button1': button1,
    'button2': button2
}
    formhtml = formhtml1 + formhtml2 + formhtml3
    return formhtml


def do_editform(request, actname, page, task, msg=None):
    """
        Build the 'edit task' form

        @param request: request object
        @param actname: actname object
        @param page: page object
        @param task: task to edit
        @param msg: message to display
        @return: html form (string)
    """
    _ = request.getText
    ticket = wikiutil.createTicket(request)
    querytext = _('Edit Task')
    button1 = _('Save')
    button2 = _('Cancel')
    label1 = _('Task ID')
    value1 = task[0] 
    label2 = _('Created by')
    value2 = task[1]
    label3 = _('Created on')
    value3 = task[2]
    label4 = _('Closed by')
    value4 = task[3]
    label5 = _('Closed at')
    value5 = task[4]
    label6 = _('Task name')
    value6 = task[5]
    label7 = _('Assigned to')
    value7 = task[6]
    label8 = _('Time-frame')
    value8 = task[7]
    label9 = _('Priority')
    value9 = task[8]
    label10 = _('Status')
    value10 = task[9]
    label11 = _('Task description')
    value11 = task[10]
    label12 = _('Task\'s wiki homepage')
    value12 = task[11]
    label13 = _('Task associated with page')
    value13 = task[12]
    label14 = _('Notify assignee?')
    value14 ="Yes"
    
    formhtml1 = '''
<form method="post" action="">
<div class="userpref">
<strong>%s <br></strong>''' % querytext

    if msg:
        formhtml2 = "%s" % msg
    else:
        formhtml2 = ""

    formhtml3 = '''
<br>
<input type="hidden" name="action" value="%(actname)s">
<input type="hidden" name="ticket" value="%(ticket)s">
<table border="0">
    <tr>
        <td class="label"><label>%(label1)s</label></td>
        <td class="content">
            <input type="text" name="task_id" value="%(value1)s" size="6" readonly="readonly">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label2)s</label></td>
        <td class="content">
            <input type="text" name="created_by" value="%(value2)s" size="36" readonly="readonly">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label3)s</label></td>
        <td class="content">
            <input type="text" name="created_at" value="%(value3)s" size="36" readonly="readonly">
        </td>
    </tr> ''' % {
        'actname': actname,
        'ticket' : ticket,
        'label1' : label1,
        'value1' : value1,
        'label2' : label2,
        'value2' : value2,
        'label3' : label3,
        'value3' : value3
}
    
    if value4 != "unknown":
        formhtml4 = '''
   <tr>
        <td class="label"><label>%(label4)s</label></td>
        <td class="content">
            <input type="text" name="closed_by" value="%(value4)s" size="36" readonly="readonly">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label5)s</label></td>
        <td class="content">
            <input type="text" name="closed_at" value="%(value5)s" size="36" readonly="readonly">
        </td>
    </tr> ''' % {
        'label4' : label4,
        'value4' : value4,
        'label5' : label5,
        'value5' : value5
}
    else:
        formhtml4 = '''
<input type="hidden" name="closed_by" value="%(value4)s">
<input type="hidden" name="closed_at" value="%(value5)s"> ''' % {
    'value4' : value4,
    'value5' : value5
}

    formhtml5 = '''
    <tr>
        <td class="label"><label>%(label6)s</label></td>
        <td class="content">
            <input type="text" name="task_name" value="%(value6)s" size="36" maxlength="50">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label7)s</label></td>
        <td class="content">
            <input type="text" name="assigned_to" value="%(value7)s" size="36" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label8)s</label></td>
        <td class="content">
            <input type="text" name="time_frame" value="%(value8)s" size="36" maxlength="20">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label9)s</label></td>
        <td class="content">
             <select name="priority" size="1"> ''' % {
                 'label6' : label6,
                 'value6' : value6,
                 'label7' : label7,
                 'value7' : value7,
                 'label8' : label8,
                 'value8' : value8,
                'label9'  : label9
}
    # ToDo: Make code more compact. Don't use if value9 = ..
    if value9 == "":
        formhtml6 = '''    
                   <option selected value="">   </option>
                   <option value="low">%(low)s</option>
                   <option value="medium">%(medium)s</option>
                   <option value="high">%(high)s</option>
                   <option value="critical">%(critical)s</option>
                 </select>''' % { 'low'      : _('low'),
                                  'medium'   : _('medium'),
                                  'high'     : _('high'),
                                  'critical' : _('critical') }

    if value9 == "low":
        formhtml6 = '''    
                   <option value="">   </option>
                   <option selected value="low">%(low)s</option>
                   <option value="medium">%(medium)s</option>
                   <option value="high">%(high)s</option>
                   <option value="critical">%(critical)s</option>
                 </select>''' % { 'low'      : _('low'),
                                  'medium'   : _('medium'),
                                  'high'     : _('high'),
                                  'critical' : _('critical') }

    if value9 == "medium":
        formhtml6 = '''    
                   <option value="">   </option>
                   <option value="low">%(low)s</option>
                   <option selected value="medium">%(medium)s</option>
                   <option value="high">%(high)s</option>
                   <option value="critical">%(critical)s</option>
                 </select>''' % { 'low'      : _('low'),
                                  'medium'   : _('medium'),
                                  'high'     : _('high'),
                                  'critical' : _('critical') }

    if value9 == "high":
        formhtml6 = '''    
                   <option value="">   </option>
                   <option value="low">%(low)s</option>
                   <option value="medium">%(medium)s</option>
                   <option selected value="high">%(high)s</option>
                   <option value="critical">%(critical)s</option>
                 </select>''' % { 'low'      : _('low'),
                                  'medium'   : _('medium'),
                                  'high'     : _('high'),
                                  'critical' : _('critical') }

    if value9 == "critical":
        formhtml6 = '''    
                   <option value="">   </option>
                   <option value="low">%(low)s</option>
                   <option value="medium">%(medium)s</option>
                   <option value="high">%(high)s</option>
                   <option selected value="critical">%(critical)s</option>
                 </select>''' % { 'low'      : _('low'),
                                  'medium'   : _('medium'),
                                  'high'     : _('high'),
                                  'critical' : _('critical') }

    formhtml7 = '''
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label10)s</label></td>
        <td class="content">
             <select name="status" size="1"> ''' % {
                 'label10' : label10 }

    # ToDo: Make code more compact. Don't use if value10 = ..
    if value10 == "to do":
        formhtml8 = '''
               <option selected value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
               <option value="done">%(Done)s</option>
               <option value="failed">%(Undone)s</option>
               <option value="closed">%(Closed)s</option>
               <option value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                     'InProgress' : _('in progress'),
                                                                     'Pending'    : _('pending'),
                                                                     'Done'       : _('done'),
                                                                     'Undone'     : _('failed'),
                                                                     'Closed'     : _('closed'),
                                                                     'RemoveMe'   : _('remove me') }

    if value10 == "in progress":
        formhtml8 = '''
               <option value="to do">%(ToDo)s</option>
               <option selected value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
               <option value="done">%(Done)s</option>
               <option value="failed">%(Undone)s</option>
               <option value="closed">%(Closed)s</option>
               <option value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                     'InProgress' : _('in progress'),
                                                                     'Pending'    : _('pending'),
                                                                     'Done'       : _('done'),
                                                                     'Undone'     : _('failed'),
                                                                     'Closed'     : _('closed'),
                                                                     'RemoveMe'   : _('remove me') }

    if value10 == "pending":
        formhtml8 = '''
               <option value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option selected value="pending">%(Pending)s</option>
               <option value="done">%(Done)s</option>
               <option value="failed">%(Undone)s</option>
               <option value="closed">%(Closed)s</option>
               <option value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                     'InProgress' : _('in progress'),
                                                                     'Pending'    : _('pending'),
                                                                     'Done'       : _('done'),
                                                                     'Undone'     : _('failed'),
                                                                     'Closed'     : _('closed'),
                                                                     'RemoveMe'   : _('remove me') }

    if value10 == "done":
        formhtml8 = '''
               <option value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
               <option selected value="done">%(Done)s</option>
               <option value="failed">%(Undone)s</option>
               <option value="closed">%(Closed)s</option>
               <option value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                     'InProgress' : _('in progress'),
                                                                     'Pending'    : _('pending'),
                                                                     'Done'       : _('done'),
                                                                     'Undone'     : _('failed'),
                                                                     'Closed'     : _('closed'),
                                                                     'RemoveMe'   : _('remove me') }

    if value10 == "failed":
        formhtml8 = '''
               <option value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
               <option value="done">%(Done)s</option>
               <option selected value="failed">%(Undone)s</option>
               <option value="closed">%(Closed)s</option>
               <option value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                     'InProgress' : _('in progress'),
                                                                     'Pending'    : _('pending'),
                                                                     'Done'       : _('done'),
                                                                     'Undone'     : _('failed'),
                                                                     'Closed'     : _('closed'),
                                                                     'RemoveMe'   : _('remove me') }

    if value10 == "closed":
        formhtml8 = '''
               <option value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
               <option value="done">%(Done)s</option>
               <option value="failed">%(Undone)s</option>
               <option selected value="closed">%(Closed)s</option>
               <option value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                     'InProgress' : _('in progress'),
                                                                     'Pending'    : _('pending'),
                                                                     'Done'       : _('done'),
                                                                     'Undone'     : _('failed'),
                                                                     'Closed'     : _('closed'),
                                                                     'RemoveMe'   : _('remove me') }

    if value10 == "remove me":
        formhtml8 = '''
               <option value="to do">%(ToDo)s</option>
               <option value="in progress">%(InProgress)s</option>
               <option value="pending">%(Pending)s</option>
               <option value="done">%(Done)s</option>
               <option value="failed">%(Undone)s</option>
               <option value="closed">%(Closed)s</option>
               <option selected value="remove me">%(RemoveMe)s</option>''' % { 'ToDo'       : _('to do'),
                                                                              'InProgress' : _('in progress'),
                                                                              'Pending'    : _('pending'),
                                                                              'Done'       : _('done'),
                                                                              'Undone'     : _('failed'),
                                                                              'Closed'     : _('closed'),
                                                                              'RemoveMe'   : _('remove me') }

    formhtml9 = '''
             </select>
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label11)s</label></td>
        <td class="content">
            <input type="text" name="task_desc" value="%(value11)s" size="80" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label12)s</label></td>
        <td class="content">
            <input type="text" name="task_disc_page" value="%(value12)s" size="80" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label13)s</label></td>
        <td class="content">
            <input type="text" name="task_assoc" value="%(value13)s" size="80" maxlength="100">
        </td>
    </tr>
    <tr>
        <td class="label"><label>%(label14)s</label></td>
        <td class="content">
            <input type="checkbox" name="email_notification" value="%(value14)s">
        </td>
    </tr>
    <tr>
        <td> </td>
        <td>
        <input class="buttons" type="submit" name="button_save_edit" value="%(button1)s">
        <input class="buttons" type="submit" name="button_back_search" value="%(button2)s">
        </td>
    </tr>
</table>
</div>
</form>''' % {
    'label11' : label11,
    'value11' : value11,
    'label12' : label12,
    'value12' : value12,
    'label13' : label13,
    'value13' : value13,
    'label14' : label14,
    'value14' : value14,
    'button1' : button1,
    'button2' : button2
}
    formhtml = formhtml1 + formhtml2 + formhtml3 + formhtml4 + formhtml5 + formhtml6 + formhtml7 + formhtml8 + formhtml9
    return formhtml


def _save_changed_task(request, page):
    """
        Save changed task data to disc

        @param request: request object
        @param page: page object
        @return: result (string)

    """
    _ = request.getText
    task_id = request.form.get('task_id', [""])
    created_by = request.form.get('created_by', [""])
    created_at = request.form.get('created_at', [""])
    closed_by = request.form.get('closed_by', [""])
    closed_at = request.form.get('closed_at', [""])
    task_name = request.form.get('task_name', [""])
    task_name = wikiutil.escape(task_name, 1)
    task_name = wikiutil.clean_input(task_name)
    assigned_to = request.form.get('assigned_to', [""])
    assigned_to = wikiutil.escape(assigned_to, 1)
    assigned_to = wikiutil.clean_input(assigned_to)
    time_frame = request.form.get('time_frame', [""])
    priority = request.form.get('priority', [""])
    status = request.form.get('status', [""])
    task_desc = request.form.get('task_desc', [""])
    email_notification = request.form.get('email_notification', [""])
    if task_desc != "":
        task_desc = wikiutil.escape(task_desc, 1)
        task_desc = wikiutil.clean_input(task_desc)
    task_disc_page = request.form.get('task_disc_page', [""])
    if task_disc_page != "":
        task_disc_page = wikiutil.escape(task_disc_page, 1)
        task_disc_page = wikiutil.clean_input(task_disc_page)
    task_assoc = request.form.get('task_assoc', [""])
    if task_assoc != "":
        task_assoc = wikiutil.escape(task_assoc, 1)
        task_assoc = wikiutil.clean_input(task_assoc)
        
    databaseFile = os.path.join(request.cfg.data_dir, "task-db")
    try:
        db = open(databaseFile,"r")
        taskdata = db.readlines()
        db.close()  
    except IOError:
        return (_('Error while trying to read task data.'), "error")

    new_taskdata = []    
    for line in taskdata:
        tmp = line.split("\t")
        if tmp[0] == task_id:
            # task closed
            if (status == "closed" or status == "remove me") and (tmp[9] != "closed" or tmp[9] != "remove me"):
                tmp[3] = request.user.name
                tmp[4] = _make_local_timestamp(request)
            # task reopend
            if status in ["to do", "in progress", "pending", "done", "failed"] and (tmp[9] == "closed" or tmp[9] == "remove me"):
                tmp[3] = "unknown"
                tmp[4] = "unknown"
            tmp[5] = task_name
            tmp[6] = assigned_to
            tmp[7] = time_frame
            tmp[8] = priority
            tmp[9] = status
            tmp[10] = task_desc
            tmp[11] = task_disc_page
            tmp[12] = task_assoc
            newline = "%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n" % (tmp[0],
                                                                                tmp[1],
                                                                                tmp[2],
                                                                                tmp[3],
                                                                                tmp[4],
                                                                                tmp[5],
                                                                                tmp[6],
                                                                                tmp[7],
                                                                                tmp[8],
                                                                                tmp[9],
                                                                                tmp[10],
                                                                                tmp[11],
                                                                                tmp[12])
            new_taskdata += newline
        else:
            new_taskdata += line
            
    try:
        db = open(databaseFile,"w")
        db.writelines(new_taskdata)
        db.close()    
    except IOError:
        return (_('Error while trying to save task data.'),"error")
    if email_notification=="Yes":
	#here must the notify by email function call appear
	#make the email body
	txtbody =u'''
Hi,
A task previously assigned to you has been modified.
The new task details are: 
 Created by: %(1)s
 Created at: %(2)s
 Task_name: %(3)s
 Finish before: %(4)s
 Priority: %(5)s
 Status: %(6)s
 Task description: %(7)s
Have a good day!
	''' % {
		'1': created_by,
		'2': created_at,
		'3': task_name,
		'4': time_frame,
		'5': priority,
		'6': status,
		'7': task_desc,
	      }
	# get email address
	# first make a user
	assignee=user.User(request,id=user.getUserId(request, assigned_to))
	# then load the data from disk so that its email adress becomes available
	assignee.load_from_id()
	# then we can send
	sendok=sendmail(request, [assignee.email], u'Modified task: '+task_name, txtbody)[0]
	if sendok:
	    return (_('Task succesfully saved and assignee notified succesfully.'),"ok")
	else:
	    return (_('Task successfully saved but assignee could not be notified.'), "warning")
   
    return (_('Task successfully saved.'),"ok")


def do_removeform(request, actname, msg=None):
    """
        Build the 'remove task' form

        @param request: request object
        @param actname: actname object
        @param msg: message to display
        @return: html form (string)
    """
    _ = request.getText
    ticket = wikiutil.createTicket(request)
    querytext = _('Remove Task')
    button1 = _('Remove')
    button2 = _('Cancel')
    label1 = _('Task ID')
    value1 = ""

    formhtml1 = '''
<form method="post" action="">
<div class="userpref">
<strong>%s <br></strong>''' % querytext
    
    if msg:
        formhtml2 = "%s" % msg
    else:
        formhtml2 = ""

    formhtml3 = '''
<br>
<input type="hidden" name="action" value="%(actname)s">
<input type="hidden" name="ticket" value="%(ticket)s">
<table border="0">
    <tr>
        <td class="label"><label>%(label1)s</label></td>
        <td class="content">
            <input type="text" name="task_id" value="%(value1)s" size="6" maxlength="6">
        </td>
    </tr>
    <tr>
        <td> </td>
        <td>
        <input class="buttons" type="submit" name="button_remove_id" value="%(button1)s">
        <input class="buttons" type="submit" name="button_back" value="%(button2)s">
        </td>
    </tr>
</table>
</div>
</form>''' % {
    'actname': actname,
    'ticket' : ticket,
    'label1' : label1,
    'value1' : value1,
    'button1': button1,
    'button2': button2
}
    formhtml = formhtml1 + formhtml2 + formhtml3
    return formhtml


def _remove_task(request, task_to_remove=None):
    """
        Remove task from database

        @param request: request object
        @param task_to_remove: id of task to remove
        @return: tuple result, message (bool, string)
    """
    _ = request.getText
    if task_to_remove == None:
        task_id = request.form['task_id']
    else:
        task_id = task_to_remove
    databaseFile = os.path.join(request.cfg.data_dir, "task-db")
    if os.path.isfile(databaseFile):
        try:
            db = open(databaseFile, "r")
            database = db.readlines()
            db.close()
        except:
            return (False, (_('Error while trying to remove task from database.'), "error"))
        found = False
        task_homepage = ""
        new_database = []
        for line in database:
            tmp = line.split("\t")
            if tmp[0] == task_id:
                found = True
                task_homepage = tmp[11]
            else:
                new_database += line

        if found == True:
            try:
                db = open(databaseFile, "w")
                db.writelines(new_database)
                db.close()
            except:
                return (False, (_('Error while trying to remove task from database.'), "error"))
            if Page(request, task_homepage).exists():
                if request.user.may.delete(task_homepage):
                    page = PageEditor(request, task_homepage, do_editor_backup=0)
                    success, msg = page.deletePage()
                    if success:
                        return (True, (_("Task and task's wiki homepage successfully removed."),"ok"))
                    else:
                        return (True, (_("Task successfully removed from database. Error while trying to delete task's wiki homepage."),"warning"))
                else:
                    return (True, (_("Task successfully removed from database. Error while trying to delete task's wiki homepage: You are not allowed to delete this page."),"warning"))
            return (True, (_('Task successfully removed.'),"ok"))
        else:
            return (False, (_('Task not found.'),"error"))
    else:
        return (False, (_('Database not found.'),"error"))
    

def execute(pagename, request):
    _ = request.getText
    actname = __name__.split('.')[-1]
    page = Page(request, pagename)
    
    # check whether user is logged in
    if request.user.valid == 0:
	request.theme.add_msg(_('Please log in first.'),'error')
        return page.send_page()
    
    # ckeck whether action is allowed
    if actname in request.cfg.actions_excluded:
	request.theme.add_msg(_('You are not allowed to perform this action.'),"warning")
        return page.send_page()

    # check whether page does really exist
    if not page.exists():
	request.theme.add_msg(_('This page is already deleted or was never created!'),"error")
        return page.send_page()

    #
    # 'add task' called from outside by the macro via "?action=TaskPlanner&add" (currently not used)
    #
    if request.form.has_key('action') and request.form.has_key('add'):
        # check whether this is a valid request (make outside
        # attacks harder by requiring two full HTTP transactions)
        if not request.form.has_key('ticket'):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()

        if not wikiutil.checkTicket(request, request.form['ticket']):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()
        
        if request.form.has_key('button_back'):
            return page.send_page()

        # check whether TaskTable macro has forwarded information on page and assign
        assoc_page = assign = None
        if request.form.has_key('page'):
            assoc_page = request.form.get('page', [None])
        if request.form.has_key('assign'):
            assign = request.form.get('assign', [None])

        if request.form.has_key('button_add_a'):
            result = _check_form_input(request)
            if result =="":
                result = _save_task(request)
		request.theme.add_msg(*result)
		return page.send_page()
            else:  
		request.theme.add_msg(_(do_addform(request, actname, page, msg=result[0], assoc_page=assoc_page, assign=assign)),result[1])
		return page.send_page()

	request.theme.add_msg(_(do_addform(request, actname, page, assoc_page=assoc_page, assign=assign)))
	return page.send_page()

    #
    # 'edit task' called from outside by the macro via "?action=TaskPlanner&edit=[task_id]"
    #
    elif request.form.has_key('action') and request.form.has_key('edit'):
        # check whether this is a valid request (make outside
        # attacks harder by requiring two full HTTP transactions)
        if not request.form.has_key('ticket'):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()

        if not wikiutil.checkTicket(request, request.form['ticket']):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()
        
        if request.form.has_key('button_back_search'):
            return page.send_page()

        task_id = request.form.get('edit', [""])
        databaseFile = os.path.join(request.cfg.data_dir, "task-db")
        if os.path.isfile(databaseFile):
            existing_id = 0
            found = False
            for line in open(databaseFile).readlines():
                tmp = line.split("\t")
                existing_id = tmp[0]
                if existing_id == task_id:
                    found = True
                    break
        else:
	    request.theme.add_msg(_('Database not found. '),"error")
	    return page.send_page()

        if request.form.has_key('button_save_edit'):
            result = _check_form_input(request)
            if result =="":
                result = _save_changed_task(request, page)
		request.theme.add_msg(*result)
		return page.send_page()
            else:
		request.theme.add_msg(do_editform(request, actname, page, tmp, msg=result[0]))
		return page.send_page()

        if found == True:
	    request.theme.add_msg(_(do_editform(request, actname, page, tmp)))
	    return page.send_page()

        else:
	    request.theme.add_msg(_('Task not found. '),"error")
	    return page.send_page()

    #
    # 'remove task' called from outside by the macro via "?action=TaskPlanner&remove=[task_id]"
    #
    elif request.form.has_key('action') and request.form.has_key('remove'):
        # check whether this is a valid request (make outside
        # attacks harder by requiring two full HTTP transactions)
        if not request.form.has_key('ticket'):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()

        if not wikiutil.checkTicket(request, request.form['ticket']):
	   request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	   return page.send_page()

        if not request.user.isSuperUser():
	    request.theme.add_msg(_('You have to be superuser to remove items from the task list database.'),"warning")
	    return page.send_page()
        
        task_id = request.form.get('remove', [""])
        success, msg = _remove_task(request, task_id)
        # return page.send_page(msg=msg)
	request.theme.add_msg(*msg)
	return page.send_page()

    #
    # Event handling for TaskPlanner user interface
    #
    elif request.form.has_key('action') and request.form.has_key('ticket'):
        # check whether ticket is valid (make outside attacks harder
        # by requiring two full HTTP transactions)
        if not request.form.has_key('ticket'):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()

        if not wikiutil.checkTicket(request, request.form['ticket']):
	    request.theme.add_msg(_('Please use the interactive user interface for adding, editing and removing tasks.'),"warning")
	    return page.send_page()
        #
        # 'add task' stuff
        #
        
        # check whether TaskTable macro has forwarded information on page and assign
        assoc_page = assign = None
        if request.form.has_key('page'):
            assoc_page = request.form.get('page', [None])
        if request.form.has_key('assign'):
            assign = request.form.get('assign', [None])

        # display menu for adding tasks
        if request.form.has_key('button_add'):
    	    request.theme.add_msg(do_addform(request, actname, page, assoc_page=assoc_page, assign=assign))
	    return page.send_page()

        # user pressed button 'add task'
        if request.form.has_key('button_add_a'):
            result = _check_form_input(request)
            if result != "":
		request.theme.add_msg(_(do_addform(request, actname, page, msg=result[0], assoc_page=assoc_page, assign=assign)),result[1])
		return page.send_page()
            else:
                result = _save_task(request)
		request.theme.add_msg(_(do_mainform(request, actname, msg=result[0])),result[1])
		return page.send_page()

        #
        # 'edit task' stuff
        #

        # display menu for searching task to edit
        if request.form.has_key('button_edit'):
	    request.theme.add_msg(_(do_edit_search_form(request, actname)))
	    return page.send_page()

        # user pressed button 'edit task' in the search task form
        if request.form.has_key('button_search_id'):
            task_id = request.form['task_id']
            databaseFile = os.path.join(request.cfg.data_dir, "task-db")
            if os.path.isfile(databaseFile):
                existing_id = 0
                found = False
                for line in open(databaseFile).readlines():
                    tmp = line.split("\t")
                    existing_id = tmp[0]
                    if existing_id == task_id:
                        found = True
                        break
            else:
		request.theme.add_msg(_('Database not found. '),"error")
		return page.send_page()

            if found == True:
		request.theme.add_msg(do_editform(request, actname, page, tmp))
		return page.send_page()
            else:
		request.theme.add_msg(_('Task not found. '),"warning")
		return page.send_page()

        # user pressed button 'save edited' task
        if request.form.has_key('button_save_edit'):
            result = _check_form_input(request)
            # if we have invalid input, reload task data and display edit form again
            if result != "":
                task_id = request.form['task_id']
                databaseFile = os.path.join(request.cfg.data_dir, "task-db")
                if os.path.isfile(databaseFile):
                    existing_id = 0
                    found = False
                    for line in open(databaseFile).readlines():
                        tmp = line.split("\t")
                        existing_id = tmp[0]
                        if existing_id == task_id:
                            found = True
                            break
                else:
		    request.theme.add_msg(_('Database not found. '),"error")
		    return page.send_page()
		request.theme.add_msg(do_editform(request, actname, page, tmp, msg=result[0]),result[1])
		return page.send_page()

            else:
                result = _save_changed_task(request, page)
		request.theme.add_msg(do_mainform(request, actname, msg=result[0]),result[1])
		return page.send_page()
            
        # user pressed button cancel editing task
        if request.form.has_key('button_back_search'):
	    request.theme.add_msg(do_mainform(request, actname))
	    return page.send_page()
            
        #
        # 'remove task' stuff
        #

        # display menu for removing tasks
        if request.form.has_key('button_remove'):
            if not request.user.isSuperUser():
		request.theme.add_msg(do_mainform(request, actname, msg=_('You have to be superuser to remove items from the task list database.')),"warning")
		return page.send_page()
	    request.theme.add_msg(do_removeform(request, actname))
	    return page.send_page()
	    
	    

        # user pressed button 'remove task'
        if request.form.has_key('button_remove_id'):
            if not request.user.isSuperUser():
		request.theme.add_msg(do_mainform(request, actname, msg= _('You have to be superuser to remove items from the task list database.')),"warning")
		return page.send_page()
            
            success, msg = _remove_task(request)
            if success:
		request.theme.add_msg(do_mainform(request, actname, msg=msg[0]),msg[1])
		return page.send_page()
            else:
		request.theme.add_msg(do_removeform(request, actname, msg=msg[0]),msg[1])
		return page.send_page()

        # user pressed button 'cancel' in the main form
        if request.form.has_key('button_cancel'):
            return page.send_page()                

    # either no button was pressed (i.e. just display TaskPlanner user interface after calling the action
    # or 'button_back' was pressed (then show main form again)
    # return page.send_page(msg=do_mainform(request, actname))
    request.theme.add_msg(do_mainform(request, actname))
    return page.send_page()