mpoint.inc
1.92 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
<?PHP
// ポイントを加算減算する
//
// 戻り値 成功=True 失敗=False
function func_point_decrement($angou,$value,$flg){
$res = "True";
//$hostname="localhost";
$hostname="172.31.16.254";
$database="post_kanri";
//if( !$pg_con2=pg_connect("host=$hostname dbname=$database user=pgsqladmin password=pgsqladmin") ) {
if( !$pg_con2=pg_connect("host=$hostname port=5434 dbname=$database user=pgsqladmin password=pgsqladmin") ) {
print "Error : connect to ${hostname}<br>";
exit;
}
//表示名称を取得
$strSQL = "SELECT mst_kanri.user_id,point_tbl.use_point,point_tbl.max_point,use_date " .
"FROM mst_kanri,point_tbl " .
"WHERE mst_kanri.user_id=point_tbl.user_id and mst_kanri.angou = '".$angou."'";
$objRecSet = pg_exec($pg_con2,$strSQL);
if($objRecSet==false){
$res = "False";
}
if(pg_numrows($objRecSet)!=0){
$objRecData = pg_fetch_object($objRecSet, 0);
$user_id = $objRecData->user_id;
$Point = $objRecData->use_point;
$MaxPoint = $objRecData->max_point;
$use_date = substr($objRecData->use_date,0,6);
if($use_date!=date("Ym")){
$MaxPoint = 0;
}
}else{
$Point = 0;
$MaxPoint = 0;
}
if($MaxPoint<1000){
if($flg==0){
$Point = (integer)$Point - (integer)$value;
$MaxPoint = (integer)$MaxPoint + (integer)$value;
}else{
$Point = (integer)$Point + (integer)$value;
$MaxPoint = (integer)$MaxPoint - (integer)$value;
}
}
if($MaxPoint<1000){
$strSQL = "Update point_tbl Set use_point=".$Point." ,max_point = ".$MaxPoint." ,use_date='".date("Ymd")."' where user_id='".$user_id."'";
}else{
if($MaxPoint==1000){
$strSQL = "Update point_tbl Set use_date='".date("Ymd")."' where user_id='".$user_id."'";
}else{
$strSQL = "Update point_tbl Set use_point=".($Point+($MaxPoint-1000))." ,max_point = 1000 ,use_date='".date("Ymd")."' where user_id='".$user_id."'";
}
}
$objRecSet = pg_exec($pg_con2,$strSQL);
if($objRecSet==false){
$res = "False";
}
return $res;
}
?>