TIM003.php
3.08 KB
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
<?php
//*****************************************************************************
//*
//* プログラム名：タイムカード印刷画面
//* プログラムID：TIM003.php
//* 機能 ：タイムカード 印刷画面
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("inc/input_chk.inc");
include('./include/smarty.conf');
include("inc/TIM001.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
//$sid 社員コード
//$y 選択年
//$m 選択月
//日数
$dayMax = date("t", mktime(0, 0, 0, $m, 1, $y));
$youbi=array("日","月","火","水","木","金","土");
$bgcol=array("#FDDFFD","#FFFFFF","#FFFFFF","#FFFFFF","#FFFFFF","#FFFFFF","#CCF8FB");
//データ取得
for($i=0;$i<$dayMax;$i++){
//データ検索
$strSQL="select * from tim_tbl where syain_cd = '".$sid."' and tim_year = '".$y."' and tim_month = '".sprintf('%02d', $m)."' and tim_day = '".sprintf('%02d', ($i+1))."'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecSet)>0){
//データあり
$objRecData = pg_fetch_object($objRecSet, 0);
$sH[$i]=$objRecData->start_h;
$sM[$i]=$objRecData->start_m;
$eH[$i]=$objRecData->end_h;
$eM[$i]=$objRecData->end_m;
$com[$i]=$objRecData->tim_bikou;
$day[$i] = $objRecData->tim_day;
}else{
//データなし INSERT
$strSQL = "insert into tim_tbl ";
$strSQL .= "(syain_cd, tim_year, tim_month, tim_day, start_h, start_m, end_h, end_m, tim_bikou, tim_yobi1, tim_yobi2, tim_yobi3) ";
$strSQL .= "values('".$sid."', '".$y."', '".sprintf('%02d', $m)."', '".sprintf('%02d', ($i + 1))."', '', '', '', '', '', '', '', '') ";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(INSERT)");
exit;
}
$sH[$i]="";
$sM[$i]="";
$eH[$i]="";
$eM[$i]="";
$com[$i]="";
$day[$i] = sprintf('%02d', ($i + 1));
}
$wday[$i] = $youbi[date("w", mktime(0, 0, 0, $m, $day[$i], $y))];
$wdayCol[$i] = $bgcol[date("w", mktime(0, 0, 0, $m, $day[$i], $y))];
//祝祭日
$strSQL = "select * from holiday_tbl where holiday_date = '".$y."/".sprintf('%02d', $m)."/".sprintf('%02d', ($i + 1))."'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecSet)>0){
$wdayCol[$i] = "#FDDFFD";
}
}
//社員名
$strSQL="select * from syain_tbl where syain_cd = '".$sid."'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objRecData = pg_fetch_object($objRecSet, 0);
$strName = $objRecData->name_kj_sei.$objRecData->name_kj_mei;
$strDate = $y."年".$m."月";
$strSQL="";
$objRec="null";
$o_smarty->assign('sH',$sH);
$o_smarty->assign('sM',$sM);
$o_smarty->assign('eH',$eH);
$o_smarty->assign('eM',$eM);
$o_smarty->assign('com',$com);
$o_smarty->assign('day',$day);
$o_smarty->assign('wday',$wday);
$o_smarty->assign('wdayCol',$wdayCol);
$o_smarty->assign('strName',$strName);
$o_smarty->assign('strDate',$strDate);
$o_smarty->display('TIM003.tpl');
?>