首页 新闻 搜索 专区 学院

如何把运行周期调每小时一结算

0
悬赏园豆:30 [待解决问题]

<?php
require_once 'header.php';

require_once '../include/pager.php';

switch($clause)
{
case "addinfo":
menu();
addinfo();
break;
case "saveinfo":
saveinfo();
break;
case "editinfo":
menu();
editinfo();
break;
case "saveeditinfo":
saveeditinfo();
break;
case "unlockinfo":
unlockinfo();
break;
case "lockinfo":
lockinfo();
break;
case "unvipinfo":
unvipinfo();
break;
case "vipinfo":
vipinfo();
break;
case "delinfo":
delinfo();
break;
default:
menu();
main();
break;
}

function saveeditinfo()
{
global $db,$id;
global $h_title,$h_pic,$h_point2Day,$h_money,$h_minMemberLevel,$h_info,$h_addTime;
global $h_life,$h_dayBuyMaxNum,$h_allMaxNum;

$h_money = intval($h_money);

if($h_title == ''){HintAndBack("标题不能为空!",1);}
if($h_pic == ''){HintAndBack("图片不能为空!",1);}
if($h_minMemberLevel == ''){HintAndBack("购买等级不能为空,请填写1-4的数字!",1);}
if($h_money <= 0){HintAndBack("售价不能为0!",1);}

$query = "update `h_farm_shop` SET 
          h_title = '$h_title',
          h_pic = '$h_pic',
          h_point2Day = '$h_point2Day',
          h_life = '$h_life',
          h_dayBuyMaxNum = '$h_dayBuyMaxNum',
          h_allMaxNum = '$h_allMaxNum',
          h_money = '$h_money',
          h_minMemberLevel = '$h_minMemberLevel',
          h_addTime = '$h_addTime'
          where id = $id";

$db->query($query);

okinfo('?','修改成功!');

}

function editinfo()
{
global $db,$id,$LoginEdUserName;

$rs = $db->get_one("SELECT * FROM `h_farm_shop` where id = $id");
if(!$rs)
{
    hintAndBack('未找到该产品!',1);
}
else
{

?>
<form action="?clause=saveeditinfo&id=<?php echo $id; ?>" method="post" name="editinfo">
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF" class="tableborder">
<tr>
<td height="25" colspan="2" align="center" class="tdtitle">修改理财产品</td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td width="20%" align="center">标题</td>
<td><input name="h_title" type="text" class="inputclass2" maxlength="250" value="<?php echo $rs['h_title']; ?>" />
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom">
<td align="center">展示图:</td>
<td align="left"><input type="text" maxlength="250" class="inputclass2" id="h_pic" name="h_pic" value="<?php echo $rs['h_pic']; ?>"> <font color="#ff0000">
</font>
[<a onclick="AdminUpLoadFile('h_pic');" style="cursor:pointer;"><font color="#ff0000">上传图片</font></a>]
</td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">每天产生收益</td>
<td><input name="h_point2Day" type="text" class="inputclass1" maxlength="25" value="<?php echo $rs['h_point2Day']; ?>" /> 元
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">运行周期</td>
<td><input name="h_life" type="text" class="inputclass1" maxlength="25" value="<?php echo $rs['h_life']; ?>" /> 天
<font color="#ff0000">
</font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">售价</td>
<td><input name="h_money" type="text" class="inputclass1" maxlength="25" value="<?php echo $rs['h_money']; ?>" /> 元
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">会员等级至少达VIP</td>
<td><input name="h_minMemberLevel" type="text" class="inputclass1" maxlength="25" value="<?php echo $rs['h_minMemberLevel']; ?>" />才能购买
<font color="#ff0000">
这里只填写1-4数字,不要带VIP</font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">每天限购</td>
<td><input name="h_dayBuyMaxNum" type="text" class="inputclass1" maxlength="25" value="<?php echo $rs['h_dayBuyMaxNum']; ?>" /> 个
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">每人最多拥有</td>
<td><input name="h_allMaxNum" type="text" class="inputclass1" maxlength="25" value="<?php echo $rs['h_allMaxNum']; ?>" /> 个
<font color="#ff0000">
</font></td>
</tr>

<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">添加时间</td>
<td><input name="h_addTime" type="text" class="inputclass2" maxlength="25" value="<?php echo $rs['h_addTime']; ?>" />
<font color="#ff0000">*</font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center" colspan="2"><input type="submit" name="Submit" value=" 确定修改 " class="bttn">  <input name="button" type="button" value=" 返回 " class="bttn" onClick="javascript:history.go(-1);"></td>
</tr>
</table>
</form>
<?php
}
}

function saveinfo()
{
global $db,$id;
global $h_title,$h_pic,$h_point2Day,$h_money,$h_minMemberLevel,$h_info,$h_addTime;
global $h_life,$h_dayBuyMaxNum,$h_allMaxNum;

$h_money = intval($h_money);

if($h_title == ''){HintAndBack("标题不能为空!",1);}
if($h_pic == ''){HintAndBack("图片不能为空!",1);}
if($h_minMemberLevel == ''){HintAndBack("购买等级不能为空,请填写1-4的数字!",1);}
if($h_money <= 0){HintAndBack("售价不能为0!",1);}

$query = "insert into `h_farm_shop` SET 
          h_title = '$h_title',
          h_pic = '$h_pic',
          h_point2Day = '$h_point2Day',
          h_life = '$h_life',
          h_dayBuyMaxNum = '$h_dayBuyMaxNum',
          h_allMaxNum = '$h_allMaxNum',
          h_money = '$h_money',
          h_minMemberLevel = '$h_minMemberLevel',
          h_addTime = '$h_addTime'";

$db->query($query);

okinfo('?','添加成功!');

}

function addinfo()
{
?>
<form action="?clause=saveinfo" method="post" name="addinfo">
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF" class="tableborder">
<tr>
<td height="25" colspan="2" align="center" class="tdtitle">添加理财产品</td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td width="20%" align="center">标题</td>
<td><input name="h_title" type="text" class="inputclass2" maxlength="250" value="" />
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom">
<td align="center">展示图:</td>
<td align="left"><input type="text" maxlength="250" class="inputclass2" id="h_pic" name="h_pic"> <font color="#ff0000">
</font>
[<a onclick="AdminUpLoadFile('h_pic');" style="cursor:pointer;"><font color="#ff0000">上传图片</font></a>]
</td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">每天产生收益</td>
<td><input name="h_point2Day" type="text" class="inputclass1" maxlength="25" value="" /> 元
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">运行周期</td>
<td><input name="h_life" type="text" class="inputclass1" maxlength="25" value="" /> 天
<font color="#ff0000">
</font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">售价</td>
<td><input name="h_money" type="text" class="inputclass1" maxlength="25" value="" /> 元
<font color="#ff0000"></font></td>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">会员等级至少达VIP</td>
<td><input name="h_minMemberLevel" type="text" class="inputclass1" maxlength="25" value="" />才能购买
<font color="#ff0000">
这里只填写1-4数字,不要带VIP</font></td>
</tr>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">每天限购</td>
<td><input name="h_dayBuyMaxNum" type="text" class="inputclass1" maxlength="25" value="" /> 个
<font color="#ff0000"></font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">每人最多拥有</td>
<td><input name="h_allMaxNum" type="text" class="inputclass1" maxlength="25" value="" /> 个
<font color="#ff0000">
</font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center">添加时间</td>
<td><input name="h_addTime" type="text" class="inputclass2" maxlength="25" value="<?php echo date('Y-m-d H:i:s');?>" />
<font color="#ff0000">*</font></td>
</tr>
<tr class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td align="center" colspan="2"><input type="submit" name="Submit" value=" 确定添加 " class="bttn">  <input name="button" type="button" value=" 返回 " class="bttn" onClick="javascript:history.go(-1);"></td>
</tr>
</table>
</form>
<?php
}

function main()
{
global $db,$LoginEdUserName;

global $stype,$keyword;
$where = "";
if(strlen($keyword) > 0){
    $where .= " and (h_title like '%{$keyword}%')";
}
if(strlen($stype) > 0 && $stype >= 0){
    $where .= " and h_minMemberLevel = '{$stype}'";
}

global $page;
$list_num = 15;
$total_count = $db->counter("`h_farm_shop`", "1 = 1 {$where}", 'id');$page = (int)$page;$rowset = new Pager($total_count,$list_num,$page);$from_record = $rowset->_offset();$page_list = $rowset->link('?page=');
$query = "select * from (select * from `h_farm_shop` where 1 = 1 {$where} order by h_minMemberLevel asc,h_addTime desc,id desc LIMIT $from_record, $list_num) a";
$result = $db->query($query);
//$query = "Select * from `h_farm_shop` order by h_addTime desc";
//$result = $db->query($query);
$rs_list = array();
while($list = $db->fetch_array($result))
{
    $rs_list[]=$list;
}

?>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF" class="tableborder">
<tr>
<td height="25" colspan="11" align="center" class="tdtitle">收益设置</td>
</tr>
<tr align="center">
<td height="23" width="20%" class="tdtitle-title">图片</td>
<td class="tdtitle-title">属性</td>
<td class="tdtitle-title">相关操作</td>
</tr>
<?php
foreach ($rs_list as $key=>$val)
{
?>
<tr align="center" class="tdbottom" onMouseOver="javascript:this.className='tdbottomover';" onMouseOut="javascript:this.className='tdbottom';">
<td height="25"><?php echo '<img src="' , $val['h_pic'] , '" height="100">'; ?></td>
<td align="left"><?php echo $val['h_title']; ?><br />
每天产生收益:<?php echo $val['h_point2Day']; ?>元<br />
运行周期:<?php echo $val['h_life']; ?>天<br />
售价:<?php echo $val['h_money']; ?>元<br />
会员等级至少达:VIP<?php echo $val['h_minMemberLevel']; ?>才能购买<br/>
每天限购:<?php echo $val['h_dayBuyMaxNum']; ?>个<br />
每人最多拥有:<?php echo $val['h_allMaxNum']; ?>个<br /></td>
<td><a href="?clause=editinfo&id=<?php echo $val[id]; ?>">修改</a> |
<a style="cursor:pointer;" onClick="javascript:hintandturn('确定要删除吗?数据将不可恢复!','?clause=delinfo&id=<?php echo $val['id']; ?>',true);">删除</a></td>
</tr>
<?php
}
?>
</table>
<?php
if(count($rs_list) > 0) echo "<div style='text-align:center;'>$page_list</div>";
}

function menu()
{
global $stype,$keyword;
if(strlen($stype) <= 0){
$stype = -1;
}
?>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF" class="tableborder">
<tr>
<td height="25" class="tdtitle" align="center">相关操作</td>
</tr>
<tr>
<td height="23" class="tdbottom" align="center"><a href="?clause=addinfo">添加理财产品</a> | <a href="?">理财产品管理</a></td>
</tr>
<tr>
</table>
<br />
<?php
}

function unvipinfo()
{
global $db,$id;

$query = "update `h_farm_shop` set h_isVIP = 1 where id = $id";
$db->query($query);

turnToPage('?');

}

function vipinfo()
{
global $db,$id;

$query = "update `h_farm_shop` set h_isVIP = 0 where id = $id";
$db->query($query);

turnToPage('?');

}

function unlockinfo()
{
global $db,$id;

$query = "update `h_farm_shop` set h_isPass = 1 where id = $id";
$db->query($query);

turnToPage('?');

}

function lockinfo()
{
global $db,$id;

$query = "update `h_farm_shop` set h_isPass = 0 where id = $id";
$db->query($query);

turnToPage('?');

}

function delinfo()
{
global $db,$id;

$query = "delete from `h_farm_shop` where id = $id";
$db->query($query);

turnToPage('?');

}

footer();
?>

小白的苦的主页 小白的苦 | 初学一级 | 园豆:131
提问于:2020-03-20 05:07
< >
分享
所有回答(2)
0

这样代码太多,可以用语言描述一下

飘逸_winxin | 园豆:221 (菜鸟二级) | 2020-03-20 09:23
0

我不太懂PHP 不过这个代码的运行周期是放到数据库里的 手动改成小时就可以吧 也没看到涉及到关于这些参数的计算代码

shallZone | 园豆:195 (初学一级) | 2020-03-20 10:43
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册