📄 weekcollect.php
字号:
<?php
include_once './public/config.inc.php';
$weekday = date ('w');
$wfile = './data/weekcollectflag.php';
echo '' . $weekday . ' != ' . $cfg_collectday . ' - i = ' . $nowis . '<br>';
if ($weekday == $cfg_collectday)
{
if (file_exists ('' . $wfile))
{
include_once '' . $wfile;
if ($flag_weekdate == $date)
{
$flag_weekcollect = 0;
}
else
{
$flag_weekcollect = 1;
}
}
else
{
$flag_weekcollect = 1;
}
if ($flag_weekcollect == 1)
{
$filestr = '<? ' . ('' . '$') . ('' . 'flag_weekdate="' . $date . '"; ?>');
$fp = fopen ('' . $wfile, 'w');
flock ($fp, 3);
$f = fwrite ($fp, $filestr);
fclose ($fp);
if ($f)
{
echo '' . $enddate . ' 结转成功!';
}
else
{
echo '' . $enddate . ' 结转失败!';
}
$enddate = date ('Y-m-d', time () - 172800);
include_once './public/db_conn.php';
$sqlf = 'select pay_date from payed where pay_type=1 order by pay_date desc';
$rsf = mysql_query ($sqlf);
$numf = mysql_num_rows ($rsf);
$rowf = mysql_fetch_array ($rsf);
$lastdate = strtotime ($rowf['pay_date']);
if (($numf < 1 OR empty ($rowf['pay_date'])))
{
$startdate = '0000-00-00';
}
else
{
$startdate = date ('Y-m-d', $lastdate + 86400);
if ($rowf['pay_date'] == $enddate)
{
echo '' . $enddate . ' 已结转!';
$filestr = '<? ' . ('' . '$') . ('' . 'flag_weekdate="' . $date . '"; ?>');
$fp = fopen ('' . $wfile, 'w');
flock ($fp, 3);
$f = fwrite ($fp, $filestr);
fclose ($fp);
exit ();
}
}
$sql = '' . 'select web_user, sum( web_money ) as tot_money from daydata where date>=\'' . $startdate . '\' and date<=\'' . $enddate . '\' group by web_user ORDER BY web_user';
$rs = mysql_query ($sql);
while ($row = mysql_fetch_array ($rs))
{
$sqlw = '' . 'select username from webmember where up_user=\'' . $row['web_user'] . '\'';
$rsw = mysql_query ($sqlw);
$str_downuser = ' 0 ';
while ($roww = mysql_fetch_array ($rsw))
{
$str_downuser .= '' . ' or web_user=\'' . $roww['username'] . '\' ';
}
$sqldown = '' . 'select sum( web_money ) as tot_money from daydata where date>=\'' . $startdate . '\' and date<=\'' . $enddate . '\' and ( ' . $str_downuser . ' )';
$rsdown = mysql_query ($sqldown);
$rowdown = mysql_fetch_array ($rsdown);
$downmoney = $rowdown['tot_money'] * $cfg_recommend;
$insert = '' . 'insert into `payed`(`username`,`pay_type`,`ought_money`,`down_money`,`pay_date`,`admin_stat`) values(\'' . $row['web_user'] . '\',\'1\',\'' . $row['tot_money'] . '\',\'' . $downmoney . '\',\'' . $enddate . '\',\'1\')';
$rsin = mysql_query ($insert);
echo '' . $row['web_user'] . ' = ' . $rsin . '<br>';
}
}
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -