$arrClasses = array();
//The purpose of this page should only be to keep track of the residents who are currently in Netherhall.
$today = date('Y-m-d');
$r = mysql_query("SELECT residents.resident_id, NAME, surname " . "FROM residents LEFT JOIN bookings ON residents.resident_id = bookings.resident_id " . "WHERE bookings.status='accepted' AND bookings.done=0 AND bookings.arrival <= '{$today}' " . "GROUP BY residents.resident_id ORDER BY surname, NAME");
if (mysql_num_rows($r)) {
    ?>
	<table align="center" border="1" cellpadding="4" cellspacing="0">
	<?php 
    while ($arrInfo = mysql_fetch_assoc($r)) {
        $total_outstanding = 0;
        $r2 = mysql_query("SELECT * FROM residents LEFT JOIN bookings ON residents.resident_id = bookings.resident_id " . "WHERE bookings.status='accepted' AND residents.resident_id={$arrInfo[resident_id]} " . "ORDER BY NAME, surname, bookings.arrival");
        while ($arrData = mysql_fetch_assoc($r2)) {
            //ver_array("arrData",$arrData);
            $date_from = mostrar_fecha($arrData['arrival']);
            $date_to = mostrar_fecha($arrData['planned_departure']);
            $days = subtract_dates($date_from, $date_to);
            $total_rent = $days * ($arrData['weekly_rate'] / 7);
            $total_rent = round($total_rent, 2);
            $due = $total_rent + $arrData['laundry'] + $arrData['hc'] + $arrData['printing'] + $arrData['extra'];
            //$outstanding = $due - $arrData['deposit'] - $arrData['received'];
            $outstanding = $due - $arrData['received'];
            $outstanding = round($outstanding, 2);
            $name = "";
            if ($arrData[surname] != "") {
                $name = $arrData[surname] . ", ";
            }
            $name .= $arrData[name];
            if (mysql_num_rows($r2) < 2) {
                ?>
			<tr class="row1">
			<td><?php 
						?>
                   	</table>
                  	</div>
					</td>
                	</tr>
                	<?					
					$div_num++;
					}																
						
				$r=mysql_query("SELECT * FROM bookings WHERE resident_id=$resident_id AND status='finished' ORDER BY arrival DESC");
				while ($arrAccomodation=mysql_fetch_assoc($r)) {		
					$date_from       = mostrar_fecha($arrAccomodation['arrival']);
					$date_to_planned = mostrar_fecha($arrAccomodation['departure']);
					$date_to         = mostrar_fecha($arrAccomodation['actual_departure']);
		
					$days=subtract_dates($date_from, $date_to_planned);
		
					// Search the name of the room
					if ($arrAccomodation[room_id]) {
						$r2=mysql_query("SELECT * FROM rooms WHERE room_id={$arrAccomodation[room_id]}");
						$room = "";
						if (mysql_numrows($r2))
							$room=mysql_result($r2,0,"room");				
					}
					
					//ver_array("arrAccomodation",$arrAccomodation);					
					$total_rent = $days * ($arrAccomodation['weekly_rate']/7);
					$total_rent = round($total_rent,2);					
					$due = $total_rent + $arrAccomodation['laundry'] + $arrAccomodation['hc'] + $arrAccomodation['printing'] + $arrAccomodation['extra'];
					$invoice_number = "NO BILL";
					$outstanding = $arrAccomodation['received'] - $due;
Exemple #3
0
function otd_manage_panel()
{
    otd_controller();
    global $wpdb, $otd_tablename, $otd_tablename_users, $otd_location, $otd_message;
    // monta array para dropdown com os usuários
    $sql = "SELECT * FROM " . $otd_tablename_users;
    $results = $wpdb->get_results($sql);
    if ($results) {
        foreach ($results as $result) {
            $att[$result->ID] = $result->user_nicename;
        }
    }
    // monta array para dropdown com os usuários
    // monta array para dropdown com os idParent
    $sql = "SELECT * FROM " . $otd_tablename;
    $results = $wpdb->get_results($sql);
    if ($results) {
        foreach ($results as $result) {
            $idParent[$result->id] = $result->id;
        }
    }
    // monta array para dropdown com os idParent
    // monta array para dropdown com os sprintNumber
    $sql = "SELECT * FROM " . $otd_tablename;
    $results = $wpdb->get_results($sql);
    if ($results) {
        foreach ($results as $result) {
            $sprintNumber[$result->sprintNumber] = $result->sprintNumber;
        }
    }
    // monta array para dropdown com os sprintNumber
    // monta array para dropdown com os authors
    $sql = "SELECT * FROM " . $otd_tablename_users;
    $results = $wpdb->get_results($sql);
    if ($results) {
        foreach ($results as $result) {
            $author[$result->id] = $result->user_nicename;
        }
    }
    // monta array para dropdown com os authors
    $priority = array(0 => __('not set', 'otd'), 1 => __('important', 'otd'), 2 => __('normal', 'otd'), 3 => __('low', 'otd'));
    $tasktag = array(0 => __('not set', 'otd'), 1 => __('story', 'otd'), 2 => __('epic', 'otd'), 3 => __('theme', 'otd'), 4 => __('project', 'otd'), 5 => __('task', 'otd'));
    $status = array(0 => __('not set', 'otd'), 1 => __('notready', 'otd'), 2 => __('ready', 'otd'), 3 => __('running', 'otd'), 4 => __('done', 'otd'));
    ?>

<?php 
    if (!empty($otd_message)) {
        ?>
<div id="message" class="updated fade"><p><?php 
        echo $otd_message;
        ?>
</p></div>
<?php 
    }
    ?>

<?php 
    if ($_GET['otd_action'] == 'edittd') {
        $id = $_GET['id'];
        $todo = otd_get_todo($id);
        $selection_att = '';
        $selection_author = '';
        $selection_sprintNumber = '';
        foreach ($att as $id => $attendant) {
            $selected = $todo->att == $id ? 'selected="selected"' : '';
            $selection_att .= "  <option value=\"{$id}\" {$selected}>{$attendant}</option>\n";
        }
        foreach ($idParent as $idPar => $parent) {
            $selected = $todo->idParent == $idPar ? 'selected="selected"' : '';
            $selection_idParent .= "  <option value=\"{$idPar}\" {$selected}>{$parent}</option>\n";
        }
        foreach ($author as $idPo => $productOwner) {
            $selected = $todo->author == $idPo ? 'selected="selected"' : '';
            $selection_author .= "  <option value=\"{$idPo}\" {$selected}>{$productOwner}</option>\n";
        }
        foreach ($sprintNumber as $idSn => $sprint) {
            $selected = $todo->sprintNumber == $idSn ? 'selected="selected"' : '';
            $selection_sprintNumber .= "  <option value=\"{$idSn}\" {$selected}>{$sprint}</option>\n";
        }
        $selection_tasktag = '';
        for ($h = 0; $h < count($tasktag); $h++) {
            $selected = $todo->tasktag == $h ? 'selected="selected"' : '';
            $selection_tasktag .= "  <option value=\"{$h}\" {$selected}>{$tasktag[$h]}</option>\n";
        }
        $selection_status = '';
        for ($j = 0; $j < count($status); $j++) {
            $selected = $todo->status == $j ? 'selected="selected"' : '';
            $selection_status .= "  <option value=\"{$j}\" {$selected}>{$status[$j]}</option>\n";
        }
        $selection = '';
        for ($k = 0; $k < count($priority); $k++) {
            $selected = $todo->priority == $k ? 'selected="selected"' : '';
            $selection .= "  <option value=\"{$k}\" {$selected}>{$priority[$k]}</option>\n";
        }
        ?>



<div class="wrap">
 <h2><?php 
        _e('Edit Backlog Entry', 'otd');
        ?>
</h2>
 <form method="post">
    <table class="editform" width="100%" cellspacing="2" cellpadding="5">



    <tr>
      <th width="33%" scope="row"><?php 
        _e('Id Parent:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_idParent' class='postform'>
        <option value="0">0</option>
        <?php 
        echo $selection_idParent;
        ?>
        </select>
      </td>
    </tr>


    <tr>
      <th width="33%" scope="row"><?php 
        _e('Product Owner:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_author' class='postform'>
        <?php 
        echo $selection_author;
        ?>
        </select>
      </td>
    </tr>


    <tr>
      <th width="33%" scope="row"><?php 
        _e('Sprint Number:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_sprintNumber' class='postform'>
        <?php 
        echo $selection_sprintNumber;
        ?>
        </select>
      </td>
    </tr>

    <tr>
      <th scope="row"><?php 
        _e('Points:', 'otd');
        ?>
</th>
      <td colspan="5">
       <input name="otd_points" type="text" style="width:37%;" value="<?php 
        echo wp_specialchars($todo->points, 1);
        ?>
">
      </td>
    </tr>



    <tr>
      <th width="33%" scope="row"><?php 
        _e('Scrum Master:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_att' class='postform'>
        <?php 
        echo $selection_att;
        ?>
        </select>
      </td>
    </tr>

    <tr>
      <th width="33%" scope="row"><?php 
        _e('EntryTag:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_tasktag' class='postform'>
        <?php 
        echo $selection_tasktag;
        ?>
        </select>
      </td>
    </tr>

    <tr>
      <th width="33%" scope="row"><?php 
        _e('Status:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_status' class='postform'>
        <?php 
        echo $selection_status;
        ?>
        </select>
      </td>
    </tr>

    <tr>
      <th width="33%" scope="row"><?php 
        _e('Priority:', 'otd');
        ?>
</th>
      <td width="67%">
        <select name='otd_priority' class='postform'>
        <?php 
        echo $selection;
        ?>
        </select>
      <input type="hidden" name="id" value="<?php 
        echo $todo->id;
        ?>
" />
      </td>
    </tr>


    <tr>
      <th scope="row"><?php 
        _e('Description:', 'otd');
        ?>
</th>
      <td colspan="5">
       <textarea name="otd_todotext"
       rows="5" cols="50" style="width:97%;"><?php 
        echo wp_specialchars($todo->todotext, 1);
        ?>
</textarea>
      </td>
    </tr>

    <tr>
      <th scope="row"><?php 
        _e('Created At:', 'otd');
        ?>
</th>
      <td colspan="5">
       <input name="otd_created_at" type="text" style="width:37%;" value="<?php 
        echo wp_specialchars($todo->created_at, 1);
        ?>
">
      </td>
    </tr>

    <tr>
      <th scope="row"><?php 
        _e('Starts:', 'otd');
        ?>
</th>
      <td colspan="5">
       <input name="otd_starts_in" type="text" style="width:37%;" value="<?php 
        echo wp_specialchars($todo->starts_in, 1);
        ?>
">
      </td>
    </tr>

    <tr>
      <th scope="row"><?php 
        _e('End:', 'otd');
        ?>
</th>
      <td colspan="5">
       <input name="otd_ended_in" type="text" style="width:37%;" value="<?php 
        echo wp_specialchars($todo->ended_in, 1);
        ?>
">
      </td>
    </tr>

    </table>
    <p class="submit">
      <input type="hidden" name="otd_action" value="updatetd" />
      <input type="submit" name="submit" value="<?php 
        _e('Update Todo', 'otd');
        ?>
" />
    </p>
 </form>
 <p><a href="<?php 
        echo $otd_location;
        ?>
"><?php 
        _e('&laquo; Return to todo list', 'otd');
        ?>
</a></p>
</div>









<?php 
    } else {
        ?>

















<div class="wrap">
<h2><?php 
        _e('Stories on Sprint', 'otd');
        ?>
(<a href="#addtd"><?php 
        _e('add new', 'otd');
        ?>
</a>)</h2>
<table class="widefat" id="todo-list" width="100%" cellpadding="3" cellspacing="3">
  <thead>
  <tr>
     <th><?php 
        _e('Done it!', 'otd');
        ?>
</th>
     <th><?php 
        _e('Id', 'otd');
        ?>
</th>



     <th><?php 
        _e('Par.', 'otd');
        ?>
</th>




     <th><?php 
        _e('Scrum M.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Type', 'otd');
        ?>
</th>
     <th><?php 
        _e('Start', 'otd');
        ?>
</th>

     <th><?php 
        _e('Priority', 'otd');
        ?>
</th>
     <th><?php 
        _e('Desc.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Status', 'otd');
        ?>
</th>
     <th colspan="2"><?php 
        _e('Action', 'otd');
        ?>
</th>
  </tr>
  </thead>
  <tbody>


<?php 
        $sql = "SELECT id, idParent, author, att, tasktag, status, priority, todotext, created_at, starts_in FROM " . $otd_tablename . " WHERE status = 3 ORDER BY priority, todotext";
        $results = $wpdb->get_results($sql);
        global $current_user;
        get_currentuserinfo();
        if ($results) {
            foreach ($results as $result) {
                $user = get_userdata($result->author);
                $idParent_str = $result->idParent;
                $class = 'alternate' == $class ? '' : 'alternate';
                $priority_str = $priority[$result->priority];
                $att_str = get_userdata($result->att);
                $status_str = $status[$result->status];
                $tasktag_str = $tasktag[$result->tasktag];
                $edit = '<a href="' . $otd_location . '&otd_action=edittd&id=' . $result->id . '" class="edit">' . __('Edit', 'otd') . '</a>&nbsp;' . '<a href="' . $otd_location . '&otd_action=trashtd&id=' . $result->id . '" class="delete">' . __('Delete', 'otd') . '</a>&nbsp;' . '<a href="' . $otd_location . '&otd_action=take&id=' . $result->id . '&current_user_id=' . $current_user->id . '" class="edit">' . __('Take', 'otd') . '</a>';
                echo "<tr id=\"otd-{$result->id}\" class=\"{$class}\">\r\n       <td width=\"1%\" ><input type=\"checkbox\" id=\"td-{$result->id}\"\r\n       onclick=\"window.location='{$otd_location}&otd_action=comptd&status=4&id={$result->id}';\" /></td>\r\n\r\n\t   <td>#{$result->id}</td>\r\n\t   <td>#{$idParent_str}</td>\r\n       <td>{$att_str->user_nicename}</td>\r\n       <td>{$tasktag_str}</td>\r\n\t   <td>{$result->starts_in}</td>\r\n       <td>{$priority_str}</td>\r\n\t   <td>{$result->todotext}</td>\r\n       <td>{$status_str}</td>\r\n       <td>{$edit}</td>\r\n       </tr>";
            }
        } else {
            echo '<tr><td colspan="9">' . __('There is nothing to do..', 'otd') . '</td></tr>';
        }
        ?>
  </tbody>
</table>
</div>
























<div class="wrap">



<h2><?php 
        _e('Product Backlog', 'otd');
        ?>
(<a href="#addtd"><?php 
        _e('add new', 'otd');
        ?>
</a>) </h2>

<table class="widefat" id="todo-list" width="100%" cellpadding="3" cellspacing="3">
  <thead>
  <tr>
     <th><?php 
        _e('Sprint it!', 'otd');
        ?>
</th>
     <th><?php 
        _e('Id', 'otd');
        ?>
</th>


     <th><?php 
        _e('Par.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Sprint', 'otd');
        ?>
</th>
     <th><?php 
        _e('Pts.', 'otd');
        ?>
</th>

     <th><?php 
        _e('P.O', 'otd');
        ?>
</th>

     <th><?php 
        _e('Scrum M.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Type', 'otd');
        ?>
</th>
     <th><?php 
        _e('Created', 'otd');
        ?>
</th>

     <th><?php 
        _e('Prior.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Desc.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Status', 'otd');
        ?>
</th>
     <th><?php 
        _e('Action', 'otd');
        ?>
</th>
  </tr>
  </thead>
  <tbody>
<?php 
        global $current_user;
        get_currentuserinfo();
        $sql = "SELECT id, idParent, sprintNumber, points, author, att, tasktag, status, priority, todotext, created_at FROM " . $otd_tablename . " WHERE status <= 2  ORDER BY priority";
        $results = $wpdb->get_results($sql);
        if ($results) {
            foreach ($results as $result) {
                $user = get_userdata($result->author);
                $class = 'alternate' == $class ? '' : 'alternate';
                //$att_str = $att[ $result->att ];
                $idParent_str = $result->idParent;
                $sprintNumber_str = $result->sprintNumber;
                $points_str = $result->points;
                $author_str = get_userdata($result->author);
                $att_str = get_userdata($result->att);
                $tasktag_str = $tasktag[$result->tasktag];
                $prstr = $priority[$result->priority];
                $status_str = $status[$result->status];
                $edit = '<a href="' . $otd_location . '&otd_action=edittd&id=' . $result->id . '" class="edit">' . __('Edit', 'otd') . '</a>&nbsp;' . '<a href="' . $otd_location . '&otd_action=trashtd&id=' . $result->id . '" class="delete">' . __('Delete', 'otd') . '</a>&nbsp;' . '<a href="' . $otd_location . '&otd_action=take&id=' . $result->id . '&current_user_id=' . $current_user->id . '" class="edit">' . __('Take', 'otd') . '</a>';
                echo "<tr id=\"otd-{$result->id}\" class=\"{$class}\">\r\n       <td width=\"1%\" ><input type=\"checkbox\" id=\"td-{$result->id}\"\r\n       onclick=\"window.location='{$otd_location}&otd_action=incoming&status=3&id={$result->id}';\" /></td>\r\n\r\n\r\n\t   <td>#{$result->id}</td>\r\n\r\n\t   <td>#{$idParent_str}</td>\r\n\t   <td>#{$sprintNumber_str}</td>\r\n\t   <td>{$points_str}</td>\r\n\r\n       <td>{$author_str->user_nicename}</td>\r\n\r\n       <td>{$att_str->user_nicename}</td>\r\n       <td>{$tasktag_str}</td>\r\n\t   <td>{$result->created_at}</td>\r\n\r\n       <td>{$prstr}</td>\r\n\t   <td>{$result->todotext}</td>\r\n       <td>{$status_str}</td>\r\n       <td>{$edit}</td>\r\n       </tr>";
            }
        } else {
            echo '<tr><td colspan="9">' . __('There is nothing to do..', 'otd') . '</td></tr>';
        }
        ?>
  </tbody>
</table>
</div>





















<div class="wrap">
<h2><?php 
        _e('Completed Stories', 'otd');
        ?>
(<a href="<?php 
        echo $otd_location;
        ?>
&otd_action=purgetd"><?php 
        _e('purge', 'otd');
        ?>
</a>)</h2>
<table class="widefat" id="todo-list" width="100%" cellpadding="3" cellspacing="3">
    <thead>
    <tr>

     <th><?php 
        _e('Undone it!', 'otd');
        ?>
</th>

     <th><?php 
        _e('Id', 'otd');
        ?>
</th>
     <th><?php 
        _e('Srum M.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Type', 'otd');
        ?>
</th>
     <th><?php 
        _e('Solved in', 'otd');
        ?>
</th>

     <th><?php 
        _e('Priority', 'otd');
        ?>
</th>
     <th><?php 
        _e('Desc.', 'otd');
        ?>
</th>
     <th><?php 
        _e('Status', 'otd');
        ?>
</th>
     <th colspan="2"><?php 
        _e('Action', 'otd');
        ?>
</th>

    </tr>
    </thead>
    <tbody>



<?php 
        $sql = "SELECT id, author, att, tasktag, status, priority, todotext, starts_in, ended_in FROM " . $otd_tablename . " WHERE status = 4 ORDER BY ended_in";
        $results = $wpdb->get_results($sql);
        function subtract_dates($begin_date, $end_date)
        {
            return round((strtotime($end_date) - strtotime($begin_date)) / 86400);
        }
        if ($results) {
            foreach ($results as $result) {
                $user = get_userdata($result->author);
                $class = 'alternate' == $class ? '' : 'alternate';
                $att_str = get_userdata($result->att);
                $tasktag_str = $tasktag[$result->tasktag];
                $prstr = $priority[$result->priority];
                $status_str = $status[$result->status];
                $edit = '<a href="' . $otd_location . '&amp;otd_action=trashtd&amp;id=' . $result->id . '" class="delete">' . __('Delete', 'otd') . '</a>';
                $date_diff = subtract_dates($result->starts_in, $result->ended_in);
                $time_to_solve = $date_diff . " days";
                echo "<tr id=\"otd-{$result->id}\" class=\"{$class}\">\r\n       <td width=\"1%\"><input type=\"checkbox\" id=\"td-{$result->id}\" checked=\"checked\"\r\n       onclick=\"window.location = '{$otd_location}&status=3&otd_action=uncomptd&id={$result->id}';\" /></td>\r\n\r\n\r\n \t   <td>#{$result->id}</td>\r\n       <td>{$att_str->user_nicename}</td>\r\n       <td>{$tasktag_str}</td>\r\n\t   <td>{$time_to_solve}</td>\r\n\r\n       <td>{$prstr}</td>\r\n\t   <td>{$result->todotext}</td>\r\n       <td>{$status_str}</td>\r\n       <td>{$edit}</td>\r\n\r\n\r\n       </tr>";
            }
        } else {
            echo $sql . '<tr><td colspan="4">' . __('There are no completed tasks.', 'otd') . '</td></tr>';
        }
        ?>
   </tbody>
</table>
</div>

<div class="wrap">

    <h2><?php 
        _e('Add Backlog Entry', 'otd');
        ?>
</h2>
    <form name="addtd" id="addtd" method="post">

    	<p>
		<?php 
        _e('Parent ID:', 'otd');
        ?>
<br />
        <input type="text" name="otd_idParent" class='postform' value="0">
    	</p>

    	<p>
		<?php 
        _e('Sprint Number:', 'otd');
        ?>
<br />
        <input type="text" name="otd_sprintNumber" class='postform' value="0">
    	</p>

     	<p>
 		<?php 
        _e('Points:', 'otd');
        ?>
<br />
        <input type="text" name="otd_points" class='postform' value="0">
    	</p>


    	<p>
		<?php 
        _e('Attendant:', 'otd');
        ?>
<br />

		<!--// monta dropdown com os usuários-->
        <select name='otd_att' class='postform'>
        <option value='0'><?php 
        _e('select one', 'otd');
        ?>
</option>
		<?php 
        $sql = "SELECT * FROM " . $otd_tablename_users;
        $results = $wpdb->get_results($sql);
        if ($results) {
            foreach ($results as $result) {
                $usridstr = $result->ID;
                $usrfirstnamestr = $result->user_nicename;
                echo "<option value='{$usridstr}'>{$usrfirstnamestr}</option>";
            }
        }
        ?>
  		</select>
		<!--// monta dropdown com os usuários-->
        </p>

        <p>
		<?php 
        _e('Entry Type:', 'otd');
        ?>
<br />
        <select name='otd_tasktag' class='postform'>
        <option value='0'><?php 
        _e('select one', 'otd');
        ?>
</option>
        <option value='1'><?php 
        _e('story', 'otd');
        ?>
</option>
        <option value='2'><?php 
        _e('epic', 'otd');
        ?>
</option>
        <option value='3'><?php 
        _e('theme', 'otd');
        ?>
</option>
        <option value='4'><?php 
        _e('project', 'otd');
        ?>
</option>
        <option value='5'><?php 
        _e('task', 'otd');
        ?>
</option>
        </select>
        </p>

        <p>
		<?php 
        _e('Priority:', 'otd');
        ?>
<br />
        <select name='otd_priority' class='postform'>
        <option value='0'><?php 
        _e('select one', 'otd');
        ?>
</option>
        <option value='1'><?php 
        _e('important', 'otd');
        ?>
</option>
        <option value='2' selected="selected"><?php 
        _e('normal', 'otd');
        ?>
</option>
        <option value='3'><?php 
        _e('low', 'otd');
        ?>
</option>
        </select>
        </p>

        <p>
		<?php 
        _e('Status:', 'otd');
        ?>
<br />
        <select name='otd_status' class='postform'>
        <option value='0'><?php 
        _e('select one', 'otd');
        ?>
</option>
        <option value='1' selected="selected"><?php 
        _e('notready', 'otd');
        ?>
</option>
        <option value='2'><?php 
        _e('ready', 'otd');
        ?>
</option>
        <option value='3'><?php 
        _e('incoming', 'otd');
        ?>
</option>
        <option value='4'><?php 
        _e('done', 'otd');
        ?>
</option>
        </select>
        </p>


        <p>
		<?php 
        _e('Description:', 'otd');
        ?>
 <br />
        <textarea name="otd_description" rows="5" cols="50" style="width: 97%;"></textarea>
        </p>

        <p class="submit">

          <input type="hidden" name="otd_created_at" value="<?php 
        printf(__('%2$s'), $current_offset_name, date_i18n(__('Y-m-d G:i:s')));
        ?>
" />
          <input name="otd_starts_in" type="hidden" style="width:37%;" value="0000-00-00 00:00:00">
          <input name="otd_ended_in" type="hidden" style="width:37%;" value="0000-00-00 00:00:00">
          <input type="hidden" name="otd_action" value="addBacklog" />
          <input type="submit" name="submit" value="<?php 
        _e('Add Backlog &raquo;', 'otd');
        ?>
" />
        </p>
    </form>
</div>

<div class="wrap">
   <h2><?php 
        _e('Install', 'otd');
        ?>
</h2>
   <p><?php 
        printf(__('If you are running Wordpress 1.5 you will need to run %sthis script%s to install the required database table. Maeka. Go! Go! Go!', 'otd'), '<a href="' . $otd_location . '&amp;otd_action=setuptd">', '</a>');
        ?>
</p>
</div>

<?php 
    }
}