• R/O
  • SSH
  • HTTPS

traclight: Commit


Commit MetaInfo

Revision117 (tree)
Zeit2010-12-10 23:42:20
Autorokamototk

Log Message

add hours changelog in ticket_change table.

Ändern Zusammenfassung

Diff

--- branches/tl3_0/plugins/svn/timingandestimationplugin/timingandestimationplugin/worktime_webui.py (revision 116)
+++ branches/tl3_0/plugins/svn/timingandestimationplugin/timingandestimationplugin/worktime_webui.py (revision 117)
@@ -127,6 +127,11 @@
127127 (ticket,time,author,field, oldvalue, newvalue)
128128 VALUES(%s, %s, '%s', '%s', '%s', '%s')""" % (ticket_id, change_time, req.authname, 'totalhours', totalhours, new_totalhours)
129129 cursor.execute(SQL)
130+ SQL="""INSERT INTO ticket_change
131+ (ticket,time,author,field, oldvalue, newvalue)
132+ VALUES(%s, %s, '%s', '%s', '%s', '%s')""" % (ticket_id, change_time, req.authname, 'hours', 0, float(props['hours']))
133+ cursor.execute(SQL)
134+
130135 db.commit()
131136 elif field=='remainedhours':
132137 cursor.execute("""SELECT te.value, tt.value FROM ticket t"""
--- branches/tl3_0/plugins/svn/timingandestimationplugin/timingandestimationplugin/templates/entryworktime.html (revision 116)
+++ branches/tl3_0/plugins/svn/timingandestimationplugin/timingandestimationplugin/templates/entryworktime.html (revision 117)
@@ -14,6 +14,31 @@
1414 $(document).ready(function() {
1515 $("div.description").find("h1,h2,h3,h4,h5,h6").addAnchor("Link to this section");
1616 });
17+function moveFocus(e){
18+ id = e.target.id;
19+ fname = id.substring(0,id.indexOf('_')+1);
20+ fid = parseInt(id.substring(id.indexOf('_')+1,id.length));
21+
22+ if(navigator.appName.charAt(0)=="N")
23+ kc=e.which;
24+ if(navigator.appName.charAt(0)=="M")
25+ kc=event.keyCode;
26+
27+ // up
28+ if(kc==38) {
29+ f = document.getElementById(fname+(fid-1));
30+ if (f==undefined) return ;
31+ f.focus();
32+ }
33+ // down
34+ if(kc==40) {
35+ f = document.getElementById(fname+(fid+1));
36+ if (f==undefined) return ;
37+ f.focus();
38+ }
39+}
40+document.onkeydown=moveFocus
41+
1742 </script>
1843 </head>
1944
@@ -24,7 +49,7 @@
2449 <h1>作業時間入力</h1>
2550 作業時間とタスクの残り時間を入力します。最低でも1日一回入力を行ってください。<br />
2651 一度入力を行った時間はこの画面からは次の日まで入力できません。追加で稼働時間を入力したい場合は、各チケットの画面から入力してください。
27-<form method="post" action="${req.href('worktime')}" >
52+<form method="post" action="${req.href('worktime')}" autocomplete="off" >
2853 <table border="0" cellspacing="0" cellpadding="0" class="listing tickets">
2954 <thead>
3055 <tr>
Show on old repository browser