• R/O
  • HTTP
  • SSH
  • HTTPS

コミット

タグ
未設定

よく使われているワード(クリックで追加)

javac++androidlinuxc#windowsobjective-ccocoa誰得qtpythonphprubygameguibathyscaphec計画中(planning stage)翻訳omegatframeworktwitterdomtestvb.netdirectxゲームエンジンbtronarduinopreviewer

カレンダ機能を追加する


コミットメタ情報

リビジョン725221d0cfe6b09d393e2039e861cdcff2f3e675 (tree)
日時2017-06-10 17:03:39
作者stingll <jostingll@gmai...>
コミッターstingll

ログメッセージ

テーブルHTMLで表示し24時間の表示も可能とするための変更

変更サマリ

差分

--- a/PHP/Mantis.txt
+++ b/PHP/Mantis.txt
@@ -42,6 +42,25 @@
4242 require_once( $t_core_path.'filter_api.php' );
4343 require_once( $t_core_path.'last_visited_api.php' );
4444
45+2.filter_get_bug_rows()の解析(1050Lineの関数)
46+ DB Table List
47+ 'mantis_bug_table'
48+ 'mantis_bug_text_table'
49+ 'mantis_bugnote_table'
50+ 'mantis_custom_field_string_table'
51+ 'mantis_bugnote_text_table'
52+ 'mantis_project_table'
53+ 'mantis_bug_monitor_table'
54+ 'limit_reporters'
55+ 'mantis_bug_relationship_table'
56+ 'report_bug_threshold'
57+
58+ 1)ログイン user_id を取得
59+ 2)プロジェクトID を取得
60+ 3)t_custom_filter を取得 と有効性のチェック
61+ 各ユーザか全体でのバグフィルタ情報を取得する。
62+ 4)nfilter_ensure_valid_filter
63+
4564 html_page_top2()
4665 html_api.php で定義。 print_menu() で、タグ「メイン」「マイビュー」〜を表示する機能。
4766 print_recently_visited();で表示か?
--- a/PHP/cnstplando.php
+++ b/PHP/cnstplando.php
@@ -14,6 +14,8 @@ print "<body>\n";
1414
1515 // 今年の西暦をデフォルトとして表示するために事前設定
1616 $nen = date("Y");
17+$gen = date("m");
18+
1719 ?>
1820
1921 <form method="POST" action="cnstplando.php">
@@ -118,10 +120,11 @@ echo '<br />';
118120 echo '<table class="width100" border="1" cellspacing="1">';
119121 echo '<tr class="row-category">';
120122 echo ' <th>日(曜)</th>';
123+echo ' <th>和祭日</th>';
121124 echo ' <th>お客様工事要望</th>';
125+echo ' <th>時間</th>';
122126 echo ' <th>SC-RP工事計画日</th>';
123127 echo ' <th>SC-RP工事実行日</th>';
124-echo ' <th width="20%">備考</th>';
125128 echo '</tr>';
126129
127130
@@ -208,98 +211,103 @@ for ($gatsu = 1; $gatsu <= 12; $gatsu++) { //月に1を
208211 $syuubun = (int)(23.09000 + 0.2421904 * $y2 - (int)($y2/4 + $y2/100 + $y2/400));
209212
210213 if (($nen == date("Y")) && ($gatsu == date("n")) && ($hi == date("d"))) { //今日なら
211- print "<td align='center' bgcolor='#8fbc8f'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#8fbc8f'>本日</td>\n"; //背景を darkseagreen に
214+ print "<td align='center' bgcolor='#8fbc8f' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#8fbc8f' rowspan='25'>本日</td>\n"; //背景を darkseagreen に
212215 } elseif (($gatsu == 1) && ($hi == 1)) { //元日(1月1日なら)
213- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>元旦</td>\n"; //背景を pink に
216+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>元旦</td>\n"; //背景を pink に
214217 } elseif (($gatsu == 1) && ($hi == 2)) { //元日の振替休日(1月2日が月曜なら)
215- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . '(' . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>三箇日</td>\n"; //背景を pink に
218+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . '(' . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>三箇日</td>\n"; //背景を pink に
216219 } elseif (($gatsu == 1) && ($hi == 3)) { //1月3日まで三箇日として休み設定
217- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . '(' . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>三箇日</td>\n"; //背景を pink に
220+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . '(' . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>三箇日</td>\n"; //背景を pink に
218221 } elseif (($gatsu == 1) && ($monday == 2) && ($you == 1)) { //成人の日(1月の第2月曜なら)
219- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>成人</td>\n"; //背景を pink に
222+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>成人</td>\n"; //背景を pink に
220223 } elseif (($gatsu == 2) && ($hi == 11)) { //建国記念の日(2月11日なら)
221- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>建国</td>\n"; //背景を pink に
224+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>建国</td>\n"; //背景を pink に
222225 } elseif (($gatsu == 2) && ($hi == 12) && ($you == 1)) { //建国記念の日の振替休日(2月12日が月曜なら)
223- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>建国振替<td></td>\n"; //背景を pink に
226+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>建国振替<td rowspan='25'></td>\n"; //背景を pink に
224227 } elseif (($nen > 1999 ) && ($gatsu == 3) && ($hi == $syunbun)) { //春分の日(計算式による)
225- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>春分</td><td></td>\n"; //背景を pink に
228+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>春分</td><td rowspan='25'></td>\n"; //背景を pink に
226229 } elseif (($nen > 1999 ) && ($gatsu == 3) && ($hi == ($syunbun + 1)) && ($you == 1)) { //春分の日の振替休日
227- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>春分振替<td></td>\n"; //背景を pink に
230+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>春分振替<td rowspan='25'></td>\n"; //背景を pink に
228231 } elseif (($nen < 2007) && ($gatsu == 4) && ($hi == 29)) { //2006年みどりの日(4月29日なら)
229- print "<td align='center' bgcolor='#ffc0cb'>>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>緑日</td>\n"; //背景を pink に
232+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>緑日</td>\n"; //背景を pink に
230233 } elseif (($nen < 2007) && ($gatsu == 4) && ($hi == 30) && ($you == 1)) { //みどりの日の振替休日(4月30日が月曜なら)
231- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>\n"; //背景を pink に
234+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>\n"; //背景を pink に
232235 } elseif (($nen > 2006) && ($gatsu == 4) && ($hi == 29)) { //昭和の日(4月29日なら)
233- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>昭和</td>\n"; //背景を pink に
236+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>昭和</td>\n"; //背景を pink に
234237 } elseif (($nen > 2006) && ($gatsu == 4) && ($hi == 30) && ($you == 1)) { //昭和の日の振替休日(4月30日が月曜なら)
235- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>昭和振替<td></td>\n"; //背景を pink に
238+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>昭和振替<td rowspan='25'></td>\n"; //背景を pink に
236239 } elseif (($gatsu == 5) && ($hi == 3)) { //憲法記念日(5月3日なら)
237240 if (($nen > 2006) && ($you == 0)) { //憲法記念日が日曜なら
238241 $kokuminf = on; //振替休日有りの印を付ける
239242 }
240- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>憲法</td>\n"; //背景を pink に
243+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>憲法</td>\n"; //背景を pink に
241244 } elseif ((($nen < 2007) && ($gatsu == 5) && ($hi == 4) && ($you == 2)) or (($nen < 2007) && ($gatsu == 5) && ($hi == 4) && ($you == 3)) or (($nen < 2007) && ($gatsu == 5) && ($hi == 4) && ($you == 4)) or (($nen < 2007) && ($gatsu == 5) && ($hi == 4) && ($you == 5)) or (($nen < 2007) && ($gatsu == 5) && ($hi == 4) && ($you == 6))) {
242- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>憲法振替</td>\n"; //背景を pink に
245+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>憲法振替</td>\n"; //背景を pink に
243246 } elseif (($nen > 2006) && ($gatsu == 5) && ($hi == 4)) { //2007年以降みどりの日(5月4日なら)
244247 if (($nen > 2006) && ($kokuminf != on) && ($you == 0)) { //みどりの日が日曜なら
245248 $kokuminf = on; //振替休日有りの印を付ける
246249 }
247- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>緑日</td>\n"; //背景を pink に
250+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>緑日</td>\n"; //背景を pink に
248251 } elseif (($gatsu == 5) && ($hi == 5)) { //こどもの日(5月5日なら)
249252 if (($nen > 2006) && ($kokuminf != on) && ($you == 0)) { //こどもの日が日曜なら
250253 $kokuminf = on; //振替休日有りの印を付ける
251254 }
252- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>子供</td>\n"; //背景を pink に
255+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>子供</td>\n"; //背景を pink に
253256 } elseif (($nen < 2007) && ($gatsu == 5) && ($hi == 6) && ($you == 1)) { //こどもの日の振替休日(5月6日が月曜なら)
254- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>子供振替</td>\n";//背景を pink に
257+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>子供振替</td>\n";//背景を pink に
255258 } elseif (($nen > 2006) && ($kokuminf == on) && ($gatsu == 5) && ($hi == 6)) { //3連祝日のどれかが日曜なら振替休日
256- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>国民振替</td>\n";//背景を pink に
259+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>国民振替</td>\n";//背景を pink に
257260 } elseif (($gatsu == 7) && ($monday == 3) && ($you == 1)) { //海の日(7月の第3月曜なら)
258- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>海日</td>\n"; //背景を pink に
261+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>海日</td>\n"; //背景を pink に
259262 } elseif (($nen > 2015) && ($gatsu == 8) && ($hi == 11)) { //2016年以降、山の日(8月11日)なら
260- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>山日</td>\n"; //背景を pink に
263+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>山日</td>\n"; //背景を pink に
261264 } elseif (($nen > 2015) && ($gatsu == 8) && ($hi == 12) && ($you == 1)) { //山の日の振替休日(8月12日が月曜なら)
262- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>振替<td></td>\n"; //背景を pink に
265+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>振替<td rowspan='25'></td>\n"; //背景を pink に
263266 } elseif (($gatsu == 9) && ($monday == 3) && ($you == 1)) { //敬老の日(9月の第3月曜なら)
264267 $keiro = $hi; //敬老の日の日付(国民の祝日の有無確認のため)
265268 if (($syuubun - $keiro) == 2) { //敬老の日の2日後が秋分の日なら
266269 $kokumin = $syuubun - 1;
267270 }
268- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>敬老</td>\n"; //背景を pink に
271+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>敬老</td>\n"; //背景を pink に
269272 } elseif (($kokumin) && (($gatsu == 9) && ($hi == $kokumin))) { //9月の国民の休日が有りなら
270- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>敬老振替<td></td>\n"; //背景を pink に
273+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>敬老振替<td rowspan='25'></td>\n"; //背景を pink に
271274 } elseif (($nen > 1999 ) && ($gatsu == 9) && ($hi == $syuubun)) { //秋分の日(計算式による)
272- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>秋分</td>\n"; //背景を pink に
275+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>秋分</td>\n"; //背景を pink に
273276 } elseif (($nen > 1999 ) && ($gatsu == 9) && ($hi == ($syuubun + 1)) && ($you == 1)) { //秋分の日の振替休日
274- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>秋分振替<td></td>\n"; //背景を pink に
277+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>秋分振替<td rowspan='25'></td>\n"; //背景を pink に
275278 } elseif (($gatsu == 10) && ($monday == 2) && ($you == 1)) { //体育の日(10月の第2月曜なら)
276- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>体育</td>\n"; //背景を pink に
279+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>体育</td>\n"; //背景を pink に
277280 } elseif (($gatsu == 11) && ($hi == 3)) { //文化の日(11月3日なら)
278- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>文化</td>\n"; //背景を pink に
281+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>文化</td>\n"; //背景を pink に
279282 } elseif (($gatsu == 11) && ($hi == 4) && ($you == 1)) { //文化の日の振替休日(11月4日が月曜なら)
280- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>文化振替<td></td>\n"; //背景を pink に
283+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>文化振替<td rowspan='25'></td>\n"; //背景を pink に
281284 } elseif (($gatsu == 11) && ($hi == 23)) { //勤労感謝の日(11月23日なら)
282- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>勤労</td>\n"; //背景を pink に
285+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>勤労</td>\n"; //背景を pink に
283286 } elseif (($gatsu == 11) && ($hi == 24) && ($you == 1)) { //勤労感謝の日の振替休日(11月24日が月曜なら)
284- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>\n"; //背景を pink に
287+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>\n"; //背景を pink に
285288 } elseif (($gatsu == 12) && ($hi == 23)) { //天皇誕生日(12月23日なら)
286- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'>天皇</td>\n"; //背景を pink に
289+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'>天皇</td>\n"; //背景を pink に
287290 } elseif (($gatsu == 12) && ($hi == 24) && ($you == 1)) { //天皇誕生日の振替休日(12月24日が月曜なら)
288- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td>\n"; //背景を pink に
291+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td>\n"; //背景を pink に
289292 } elseif ($you == 0) { //日曜日なら
290- print "<td align='center' bgcolor='#ffc0cb'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb'></td>\n"; //背景を pink に
293+ print "<td align='center' bgcolor='#ffc0cb' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#ffc0cb' rowspan='25'></td>\n"; //背景を pink に
291294 } elseif ($you == 6) { //土曜日なら
292- print "<td align='center' bgcolor='#b0c4de'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#b0c4de'></td>\n"; //背景を lightsteelblue に
295+ print "<td align='center' bgcolor='#b0c4de' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td bgcolor='#b0c4de' rowspan='25'></td>\n"; //背景を lightsteelblue に
293296 } else {
294- print "<td align='center'>" . $hi . "(" . $youbi[$you] . ")</td><td></td>\n"; //平日表示
297+ print "<td align='center' rowspan='25'>" . $hi . "(" . $youbi[$you] . ")</td><td rowspan='25'></td>\n"; //平日表示
295298 }
299+ // stingll adding
300+ for ($j = 0; $j <= 23; $j++) {
301+// print "<tr><td>" . printf("%'.02d\n",$j) . ":00" . "</td><td>" . "ここにIDが入る予定" . "</td></tr>\n"; //24時間の表示
302+ print "<tr><td>" . $j . ":00" . "</td><td>" . "ここにIDが入る予定" . "</td></tr>\n"; //24時間の表示
303+ }
304+
296305 $hi++;
297306 if (checkdate($gatsu, $hi, $nen) == false) { //+1した日付がありえない日付だったら
298307 break; //繰り返し処理を抜ける
299308 }
300309 print "</tr>\n<tr>\n"; //行変えする
301310 }
302-
303311 $hi = $hi -1; //行き過ぎた日を1日戻す
304312 $you = date("w", mktime(0, 0, 0, $gatsu, $hi, $nen)); //曜日を配列に
305313