T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG, \r
(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,\r
(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort\r
-FROM TBL_TASKS T,TBL_SETTING S LEFT outer join MST_CATEGORY C on C.CATEGID=T.CATEGID\r
+FROM TBL_TASKS T,TBL_SETTING S LEFT outer join tbl_category C on C.CATEGID=T.CATEGID\r
ORDER BY DATESORT,ENDTIMESORT,T.DODATE,T.TIMEAREA,STARTNULLSORT,STARTTIMESORT,T.SORTID</value>\r
<comment>全タスクを表示します。</comment>\r
</data>\r
<data name="getCategoryFromCategName" xml:space="preserve">\r
- <value>SELECT CategID,BGColor,FRColor FROM MST_CATEGORY WHERE Category = ?</value>\r
+ <value>SELECT CategID,BGColor,FRColor FROM tbl_category WHERE Category = ?</value>\r
<comment>カテゴリ名からIDを逆引きします。</comment>\r
</data>\r
<data name="getCommand" xml:space="preserve">\r
T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG, \r
(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,\r
(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort\r
-FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) = DATE(?) \r
+FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) = DATE(?) \r
ORDER BY DATESORT,ENDTIMESORT,T.DODATE,T.TIMEAREA,STARTNULLSORT,STARTTIMESORT,T.SORTID</value>\r
<comment>指定された日付のタスクを取得します。</comment>\r
</data>\r
T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG, \r
(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,\r
(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort\r
-FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID WHERE T.ENDTIME IS NULL\r
+FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE T.ENDTIME IS NULL\r
ORDER BY DATESORT,ENDTIMESORT,T.DODATE,T.TIMEAREA,STARTNULLSORT,STARTTIMESORT,T.SORTID</value>\r
<comment>残り全タスクを表示します。</comment>\r
</data>\r
T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,\r
(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,\r
(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort\r
-FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) = DATE(S.TODAY)\r
+FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) = DATE(S.TODAY)\r
ORDER BY DATESORT,ENDTIMESORT,T.DODATE,T.TIMEAREA,STARTNULLSORT,STARTTIMESORT,T.SORTID</value>\r
<comment>今日のタスクを取得します。</comment>\r
</data>\r
<comment>今日の日付を取ってきます</comment>\r
</data>\r
<data name="getALLCategory" xml:space="preserve">\r
- <value>SELECT CategID,Category,BGColor,FRColor FROM MST_CATEGORY ORDER BY CategID</value>\r
+ <value>SELECT CategID,Category,BGColor,FRColor FROM tbl_category ORDER BY CategID</value>\r
<comment>全カテゴリを抽出します。</comment>\r
</data>\r
<data name="getOneTask" xml:space="preserve">\r
- <value>SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,T.CATEGID,C.CATEGORY,T.CONTENTS,T.FORCASTMIN,T.STARTTIME,T.ENDTIME,T.REPEATFLG FROM TBL_TASKS T LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID where T.SORTID = ?</value>\r
+ <value>SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,T.CATEGID,C.CATEGORY,T.CONTENTS,T.FORCASTMIN,T.STARTTIME,T.ENDTIME,T.REPEATFLG FROM TBL_TASKS T LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID where T.SORTID = ?</value>\r
<comment>IDを元にタスクを抽出します。</comment>\r
</data>\r
<data name="updateTask" xml:space="preserve">\r
<comment>日付を変更します。</comment>\r
</data>\r
<data name="getCategoryFromCategId" xml:space="preserve">\r
- <value>SELECT CategID,Category,BGColor,FRColor FROM MST_CATEGORY WHERE CategID = ?</value>\r
+ <value>SELECT CategID,Category,BGColor,FRColor FROM tbl_category WHERE CategID = ?</value>\r
<comment>カテゴリIDからカテゴリを検索します。</comment>\r
</data>\r
<data name="startTask" xml:space="preserve">\r
<comment>次タスクの開始時間を求めるため、当日最後に終了したタスクの終了時間を抽出します。</comment>\r
</data>\r
<data name="clearCategory" xml:space="preserve">\r
- <value>delete from mst_category</value>\r
+ <value>delete from tbl_category</value>\r
<comment>カテゴリをクリアします。</comment>\r
</data>\r
<data name="insertCategory" xml:space="preserve">\r
- <value>INSERT into MST_CATEGORY (CATEGID,CATEGORY,FRCOLOR,BGCOLOR) values(?,?,?,?)</value>\r
+ <value>INSERT into tbl_category (CATEGID,CATEGORY,FRCOLOR,BGCOLOR) values(?,?,?,?)</value>\r
<comment>カテゴリを追加します。</comment>\r
</data>\r
<data name="delayTask" xml:space="preserve">\r
<comment>リンクを削除します。</comment>\r
</data>\r
<data name="clearTimeArea" xml:space="preserve">\r
- <value>delete from mst_timearea</value>\r
+ <value>delete from tbl_timearea</value>\r
<comment>時間帯をクリアします。</comment>\r
</data>\r
<data name="insertTimeArea" xml:space="preserve">\r
- <value>INSERT INTO MST_TIMEAREA (TIMEAREA,START,END) values(?,?,?)</value>\r
+ <value>INSERT INTO tbl_timearea (TIMEAREA,START,END) values(?,?,?)</value>\r
<comment>時間帯を追加します。</comment>\r
</data>\r
<data name="getHelp" xml:space="preserve">\r
T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,\r
(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,\r
(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort\r
-FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID \r
+FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID \r
WHERE DATE(T.DODATE) = DATE(S.TODAY) AND T.ENDTIME IS NULL AND T.STARTTIME IS NOT NULL \r
ORDER BY DATESORT,ENDTIMESORT,T.DODATE,T.TIMEAREA,STARTNULLSORT,STARTTIMESORT,T.SORTID</value>\r
<comment>実施中(StartしていてEndしていない)のタスクを抽出します。</comment>\r
<comment>リンク一覧を出力します。</comment>\r
</data>\r
<data name="getAllTimeArea" xml:space="preserve">\r
- <value>SELECT TIMEAREA,START,END FROM MST_TIMEAREA</value>\r
+ <value>SELECT TIMEAREA,START,END FROM tbl_timearea</value>\r
<comment>タイムエリアを取得します。</comment>\r
</data>\r
<data name="getLogMode" xml:space="preserve">\r
<value>UPDATE TBL_TASKS SET SORTID = SORTID * -1 WHERE DATE(DODATE) < (SELECT TODAY FROM TBL_SETTING) AND ENDTIME IS NOT NULL</value>\r
<comment>ソート番号全体を調整します。既に終了した過去分タスクはマイナス扱いとします。(こうすることで、新規発番されるタスクは過去分のソートIDの影響を受けなくなります。マイナス扱いなら最大値にはならないですからね。)</comment>\r
</data>\r
+ <data name="searchTasks" xml:space="preserve">\r
+ <value>SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,C.CATEGORY,T.CONTENTS,\r
+T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG, \r
+(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,\r
+(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort\r
+FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE T.CONTENTS LIKE ? OR C.Category LIKE ?\r
+ORDER BY DATESORT,ENDTIMESORT,T.DODATE,T.TIMEAREA,STARTNULLSORT,STARTTIMESORT,T.SORTID</value>\r
+ <comment>与えられたキーワードをコンテンツに持つタスクを検索します。</comment>\r
+ </data>\r
</root>
\ No newline at end of file
OSDN Git Service
