<?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>";
