mirror of
https://github.com/lkddi/nexusphp.git
synced 2026-04-03 14:10:57 +08:00
67 lines
2.9 KiB
PHP
67 lines
2.9 KiB
PHP
<?php
|
|
class Attendance
|
|
{
|
|
protected $userid;
|
|
protected $curdate;
|
|
public function __construct($userid){
|
|
$this->userid = $userid;
|
|
$this->curdate = date('Y-m-d');
|
|
$this->cachename = sprintf('attendance_%u_%s', $this->userid, $this->curdate);
|
|
}
|
|
|
|
public function check($flush = false)
|
|
{
|
|
global $Cache;
|
|
if($flush || ($row = $Cache->get_value($this->cachename)) === false){
|
|
$res = sql_query(sprintf('SELECT * FROM `attendance` WHERE `uid` = %u AND DATE(`added`) = %s', $this->userid, sqlesc($this->curdate.' 00:00:00'))) or sqlerr(__FILE__,__LINE__);
|
|
$row = mysql_num_rows($res) ? mysql_fetch_assoc($res) : array();
|
|
$Cache->cache_value($this->cachename, $row, 600);
|
|
}
|
|
return empty($row) ? false : $row;
|
|
}
|
|
|
|
public function attend($initial = 10, $step = 5, $maximum = 2000, $continous = array())
|
|
{
|
|
do_log(json_encode(func_get_args()));
|
|
if($this->check(true)) return false;
|
|
$res = sql_query(sprintf('SELECT id, DATEDIFF(%s, `added`) AS diff, `days`, `total_days` FROM `attendance` WHERE `uid` = %u ORDER BY `id` DESC LIMIT 1', sqlesc($this->curdate), $this->userid)) or sqlerr(__FILE__,__LINE__);
|
|
$doUpdate = mysql_num_rows($res);
|
|
if ($doUpdate) {
|
|
$row = mysql_fetch_row($res);
|
|
do_log("uid: {$this->userid}, row: " . json_encode($row));
|
|
} else {
|
|
$row = [0, 0, 0, 0];
|
|
}
|
|
list($id, $datediff, $days, $totalDays) = $row;
|
|
$points = min($initial + $step * $days, $maximum);
|
|
$cdays = $datediff == 1 ? ++$days : 1;
|
|
if($cdays > 1){
|
|
krsort($continous);
|
|
foreach($continous as $sday => $svalue){
|
|
if($cdays >= $sday){
|
|
$points += $svalue;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
// sql_query(sprintf('INSERT INTO `attendance` (`uid`,`added`,`points`,`days`) VALUES (%u, %s, %u, %u)', $this->userid, sqlesc(date('Y-m-d H:i:s')), $points, $cdays)) or sqlerr(__FILE__, __LINE__);
|
|
if ($doUpdate) {
|
|
$sql = sprintf(
|
|
'UPDATE `attendance` set added = %s, points = %s, days = %s, total_days= %s where id = %s limit 1',
|
|
sqlesc(date('Y-m-d H:i:s')), $points, $cdays, $totalDays + 1, $id
|
|
);
|
|
} else {
|
|
$sql = sprintf(
|
|
'INSERT INTO `attendance` (`uid`, `added`, `points`, `days`, `total_days`) VALUES (%u, %s, %u, %u, %u)',
|
|
$this->userid, sqlesc(date('Y-m-d H:i:s')), $points, $cdays, $totalDays + 1
|
|
);
|
|
}
|
|
do_log(sprintf('uid: %s, date: %s, doUpdate: %s, sql: %s', $this->userid, $this->curdate, $doUpdate, $sql), 'notice');
|
|
sql_query($sql) or sqlerr(__FILE__, __LINE__);
|
|
KPS('+', $points, $this->userid);
|
|
global $Cache;
|
|
$Cache->delete_value($this->cachename);
|
|
return array(++$totalDays, $cdays, $points);
|
|
}
|
|
}
|