FogBugz » TimeIntervalCommentsPlugin http://fogbugz.stackexchange.com/questions/3316
Clone URL:  
Pushed to one repository · View In Graph Contained in version_0-2-0-0, version_0-2-0-1, and tip

it works minus actually saving intervals our dot case FC2036704

Changeset 9fa408c4fe1c…

Parent 2441e8b27b94…

by Adam Wishneusky

Changes to 3 files · Browse files at 9fa408c4fe1c Showing diff from parent 2441e8b27b94 Diff from another changeset...

Change 1 of 1 Show Entire File TimeIntervalExample/​Properties/​AssemblyInfo.cs Stacked
 
39
40
41
42
43
 
 
 
39
40
41
 
 
42
43
@@ -39,5 +39,5 @@
 // You can specify all the values or you can default the Build and Revision Numbers  // by using the '*' as shown below:  // [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("0.1.2.1")] -[assembly: AssemblyFileVersion("0.1.2.1")] +[assembly: AssemblyVersion("0.1.4.1")] +[assembly: AssemblyFileVersion("0.1.4.1")]
Change 1 of 4 Show Changes Only TimeIntervalExample/​TimeIntervalExample.cs Stacked
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
43
44
45
46
 
47
48
49
50
51
52
53
54
55
56
57
58
 
 
 
59
60
61
62
63
64
65
66
67
 
 
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
 
 
 
 
 
 
 
 
 
 
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
 
152
153
 
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
42
43
44
45
 
46
47
48
49
50
51
52
53
54
55
 
 
 
56
57
58
59
60
61
62
 
 
 
 
 
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
 
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
 
157
158
 
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
 using System;  using System.Collections.Generic;  using System.Text;  using System.Web;    using FogCreek.FogBugz;  using FogCreek.FogBugz.Plugins;  using FogCreek.FogBugz.Plugins.Api;  using FogCreek.FogBugz.Database.Entity;  using FogCreek.FogBugz.Plugins.Entity;  using FogCreek.FogBugz.Plugins.Interfaces;  using FogCreek.FogBugz.UI.Dialog;    namespace TimeIntervalExample  {   public class TimeIntervalExample : Plugin, IPluginTimeIntervalJoin,   IPluginJS, IPluginDatabase, IPluginRawPageDisplay   {   public TimeIntervalExample(CPluginApi api) : base(api) { }     protected const string sPluginId = "Adam+TimeIntervalExample@fogcreek.com";   private const string CommentsTable = "TimeIntervalComment";   private const string IntervalColumn = "ixInterval";   private const string CommentColumn = "sComment";   public const int CommentColumnMaxLength = 255;   private const int PluginSchemaVer = 1;     #region IPluginTimeIntervalJoin Members     public string[] TimeIntervalJoinTables()   {   return new string[] { "TimeIntervalComment" };   }     #endregion     #region IPluginJS Members     public CJSInfo JSInfo()   {   string fullAjaxPostUrl = api.Url.PluginRawPageUrl() + - String.Format("&{0}sComment=' + sComment + '&{0}action=postTimeIntervalComment&{0}actionToken={1}", + String.Format("&{0}sComment=' + sComment + '&{0}action=postTimeIntervalComment&{0}actionToken={1}&{0}ixInterval=' + ixInterval",   api.PluginPrefix,   api.Security.GetActionToken("postTimeIntervalComment"));   string fullAjaxGetUrl = api.Url.PluginRawPageUrl() + - String.Format("&{0}action=getTimeIntervalComment&{0}actionToken={1}&{0}ixInterval=", + String.Format("&{0}action=getTimeIntervalComment&{0}actionToken={1}&{0}ixInterval=' + ixInterval",   api.PluginPrefix,   api.Security.GetActionToken("postTimeIntervalComment"));     CJSInfo jsInfo = new CJSInfo();   jsInfo.rgsStaticFiles = new string[] { "js/TimeIntervalExample.js" };   jsInfo.sInlineJS = @"  function postTimeIntervalComment()  {   var sComment = $('form#TimeIntervalExamplePluginForm input[name=comment]').val(); - var ixInterval = $('form#TimeIntervalExamplePluginForm input[name=]').val(); - var url = '" + fullAjaxPostUrl + @"'; - jQuery.get(url, myCallback); + var ixInterval = $('form#TimeIntervalExamplePluginForm input[name=ixInterval]').val(); + var url = '" + fullAjaxPostUrl + @"; + jQuery.get(url, function(data) { postCallback(data); });  }    function getTimeIntervalComment(ixInterval)  { - var url = '" + fullAjaxGetUrl + @"' + ixInterval; - jQuery.get(url, function() { - $('form#TimeIntervalExamplePluginForm input[name=comment]').val(data); -alert(data); -}); + var url = '" + fullAjaxGetUrl + @"; + jQuery.get(url, function(data) { getCallback(data); });  }";   return jsInfo;   }     #endregion     #region IPluginDatabase Members     public CTable[] DatabaseSchema()   {   var timeIntervalComments = api.Database.NewTable(api.Database.PluginTableName(CommentsTable));   timeIntervalComments.sDesc = "Assigns Comments to TimeIntervals";   timeIntervalComments.AddAutoIncrementPrimaryKey("ixTimeIntervalComment");   timeIntervalComments.AddIntColumn(IntervalColumn, true, 0);   timeIntervalComments.AddVarcharColumn(CommentColumn, CommentColumnMaxLength, false);     return new[] { timeIntervalComments };   }     public int DatabaseSchemaVersion()   {   return PluginSchemaVer;   }     public void DatabaseUpgradeAfter(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade)   {   if (ixVersionTo == 1)   {   // No action required. Don't create any data in the tables   }   }     public void DatabaseUpgradeBefore(int ixVersionFrom, int ixVersionTo, CDatabaseUpgradeApi apiUpgrade)   {   if (ixVersionTo == 1)   {   // No action required. Don't create any data in the tables   }   }     #endregion     #region IPluginRawPageDisplay Members     public string RawPageDisplay()   {   if (api.Request[api.AddPluginPrefix("action")] != null &&   Convert.ToString(api.Request[api.AddPluginPrefix("action")]) == "postTimeIntervalComment")   {   // make sure the request includes a valid action token   if ((api.Request[api.AddPluginPrefix("actionToken")] == null) ||   !api.Security.ValidateActionToken(api.Request[api.AddPluginPrefix("actionToken")],   "postTimeIntervalComment"))   {   return "failure: action token invalid";   }   else   { - return PostComment(); + int ixInterval = -1; + string sComment = ""; + if (api.Request[api.AddPluginPrefix("ixInterval")] != null && + Int32.TryParse(Convert.ToString(api.Request[api.AddPluginPrefix("ixInterval")]), out ixInterval)) + { + if (api.Request[api.AddPluginPrefix("sComment")] != null) + sComment = api.Request[api.AddPluginPrefix("sComment")].ToString(); + return PostComment(ixInterval, sComment); + } + else return "failure: invalid ixInterval";   }     }     else if (api.Request[api.AddPluginPrefix("action")] != null &&   Convert.ToString(api.Request[api.AddPluginPrefix("action")]) == "getTimeIntervalComment")   {   int ixInterval = -1;   if (api.Request[api.AddPluginPrefix("ixInterval")] != null &&   Int32.TryParse(Convert.ToString(api.Request[api.AddPluginPrefix("ixInterval")]), out ixInterval))   return GetComment(ixInterval);   else   return "failure: ixInterval invalid";   }   else return "failure: command not recognized";   }     public PermissionLevel RawPageVisibility()   {   return PermissionLevel.Normal;   }     #endregion   - private string PostComment() + private string PostComment(int ixInterval, string sComment)   { - return "success"; + return "you posted '" + sComment + "' for interval #" + ixInterval;   }     private string GetComment(int ixInterval)   {   string sComment = "none";     CTimeIntervalQuery query = api.TimeInterval.NewTimeIntervalQuery();   query.AddWhere("TimeInterval.ixInterval = @ixInterval");   query.SetParamInt("@ixInterval", ixInterval);     CTimeInterval[] rgTimeIntervals = query.List();   if (rgTimeIntervals.Length > 0)   {   object oComment = rgTimeIntervals[0].GetPluginField(sPluginId, "sComment");   if (oComment != null)   sComment = oComment.ToString();   }   return sComment;   }   }  }
Change 1 of 1 Show Entire File TimeIntervalExample/​static/​js/​TimeIntervalExample.js Stacked
 
72
73
74
75
 
76
77
 
 
 
 
 
 
 
 
 
 
 
 
 
78
 
 
72
73
74
 
75
76
 
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 
@@ -72,7 +72,19 @@
  return result;  };   -function myCallback(sHTML, status) +function getCallback(data)  { - alert(sHTML); + if (!data || data.substring(0,7) == 'failure') + { + alert('error'); + } + else + { + $('form#TimeIntervalExamplePluginForm input[name=comment]').val(data); + } +} + +function postCallback(data) +{ + alert(data);  } \ No newline at end of file