<?php $menutext .= "\n<CENTER>\n<TABLE><FORM ACTION=\"./\">\n<TR><TD><IMG SRC=\"{$toppath}/image/search.gif\" WIDTH=16 HEIGHT=16 BORDER=0 ALT=\"検索\" ALIGN=ABSMIDDLE><INPUT TYPE=TEXT NAME=\"kwd\" VALUE=\"{$kwd}\" SIZE=15 STYLE=\"width:98px\"><INPUT TYPE=SUBMIT VALUE=\"検索\" STYLE=\"width:36px\">\n</TD></TR></FORM></TABLE>\n<TABLE CELLPADDING=1 CELLSPACING=0 BORDER=0 WIDTH=160 BGCOLOR=#666666><TR><TD>\n<TABLE CELLPADDING=4 CELLSPACING=0 BORDER=0 WIDTH=158 BGCOLOR=#666666>\n<TR><TD BGCOLOR=#999999><A HREF=\"{$toppath}/workflow/\" STYLE=\"color:#FFFFFF\"><IMG SRC=\"{$toppath}/image/workflow.gif\" ALIGN=ABSMIDDLE ALT=\"ワークフロー\" BORDER=0><FONT COLOR=#FFFFFF> ワークフロー</TD></TR>\n<TR>\n<TD STYLE=\"line-height:16px;text-align:left\" BGCOLOR=#FFFFFF VALIGN=TOP>\n"; // 抽出テーブルの旧データ消去 pg_query($conn, "DELETE FROM t_workflow WHERE createstamp<'" . timestamp2datetime(time() - 86400 * 7) . "'"); // 抽出テーブルの消去 pg_query($conn, "DELETE FROM t_workflow WHERE session_id='{$sid}'"); // 抽出テーブルの作成 $sql_pre = "SELECT seqno,flow_ids,result_sign FROM workflow WHERE flow_ids ~* '(^|,)" . $login_id . "(,|\$)'"; $res_pre = pg_query($conn, $sql_pre); $cnt_pre = pg_num_rows($res_pre); if ($cnt_pre > 0) { for ($i = 0; $i < $cnt_pre; $i++) { $row_pre = pg_fetch_array($res_pre, $i); // 対象データが必要かどうかの判定処理 $flow_ids = $row_pre["flow_ids"]; $flow_arr = split(",", $flow_ids); $flow_cnt = sizeof($flow_arr); if ($flow_cnt > 0) { for ($c = 0; $c < $flow_cnt; $c++) { if ($flow_arr[$c] == $login_id) { $flow_no = $c + 1; break; } } } $status = "0"; //未分類とする if ($row_pre["result_sign"] == "") { // 承認が完了していないデータ $recognize_sign = get_first("workflow_ret", "recognize_sign", "refno=" . $row_pre["seqno"] . " AND seqno=" . $flow_no, "");
} } } } $todaystamp = mktime(0, 0, 0, date("m"), date("d"), date("Y")); if (is_numeric($y) && is_numeric($m) && is_numeric($d) && checkdate($m, $d, $y)) { $firststamp = mktime(0, 0, 0, $m, $d, $y); } else { $firststamp = date2timestamp(timestamp2datetime(time())); } $laststamp = $firststamp + 86400 * 7 - 1; $prevweekstamp = $firststamp - 86400 * 7; $nextweekstamp = $laststamp + 1; $prevdaystamp = $firststamp - 86400; $nextdaystamp = $firststamp + 86400; $ym = date("ym", timestamp2datetime($firststamp)); $prevmonthstamp = $firststamp - 86400 * 30; $nextmonthstamp = $firststamp + 86400 * 30; print "<TR HEIGHT=21 BGCOLOR={$indexmenu_backcolor}>"; print "<TD WIDTH=15% NOWRAP>"; print "<A HREF=\"./schedule/"; if (is_numeric($y) && is_numeric($m) && is_numeric($d) && checkdate($m, $d, $y)) { print "?y={$y}&m={$m}&d={$d}"; } print "\">予定表</A>"; print "</TD>"; print "<TD WIDTH=70% NOWRAP ALIGN=CENTER>"; print "<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=1><TR>"; print "<TD>"; print "<A HREF=\"./?y=" . date("Y", $prevweekstamp) . "&m=" . date("n", $prevweekstamp) . "&d=" . date("j", $prevweekstamp) . "\"><IMG SRC=\"../image/right2.gif\" BORDER=0 ALT=\"前週\"></A>"; print "<A HREF=\"./?y=" . date("Y", $prevdaystamp) . "&m=" . date("n", $prevdaystamp) . "&d=" . date("j", $prevdaystamp) . "\"><IMG SRC=\"../image/right1.gif\" BORDER=0 ALT=\"前日\"></A>";