如何把运行周期调每小时一结算
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();
?>
所有回答(2)
0
这样代码太多，可以用语言描述一下
0
我不太懂PHP 不过这个代码的运行周期是放到数据库里的 手动改成小时就可以吧 也没看到涉及到关于这些参数的计算代码
