cards_manage.php
2.1 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
/**
* 点卡管理
*
* @version $Id: cards_manage.php 1 14:31 2010年7月12日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__)."/config.php");
require_once(DEDEINC.'/datalistcp.class.php');
$dopost=empty($dopost)? "" : $dopost;
if($dopost=="delete"){
$ids = explode('`',$aids);
$dquery = "";
foreach($ids as $id){
if($dquery=="") $dquery .= "aid='$id' ";
else $dquery .= " OR aid='$id' ";
}
if($dquery!="") $dquery = " WHERE ".$dquery;
$dsql->ExecuteNoneQuery("DELETE FROM #@__moneycard_record $dquery");
ShowMsg("成功删除指定的记录！","cards_manage.php");
exit();
}else{
$addsql = '';
if(isset($isexp)) $addsql = " WHERE isexp='$isexp' ";
$sql = "SELECT * FROM #@__moneycard_record $addsql ORDER BY aid DESC";
$dlist = new DataListCP();
$dlist->pageSize = 25; //设定每页显示记录数（默认25条）
if(isset($isexp)) $dlist->SetParameter("isexp",$isexp);
$dlist->dsql->SetQuery("SELECT * FROM #@__moneycard_type ");
$dlist->dsql->Execute('ts');
while($rw = $dlist->dsql->GetArray('ts'))
{
$TypeNames[$rw['tid']] = $rw['pname'];
}
$tplfile = DEDEADMIN."/templets/cards_manmage.htm";
//这两句的顺序不能更换
$dlist->SetTemplate($tplfile); //载入模板
$dlist->SetSource($sql); //设定查询SQL
$dlist->Display(); //显示
}
function GetMemberID($mid)
{
global $dsql;
if($mid==0) return '0';
$row = $dsql->GetOne("SELECT userid FROM #@__member WHERE mid='$mid' ");
if(is_array($row)) return "<a href='member_view.php?mid={$mid}'>".$row['userid']."</a>";
else return '0';
}
function GetUseDate($time=0)
{
if(!empty($time)) return GetDateMk($time);
else return '未使用';
}
function GetSta($sta)
{
if($sta==1) return '已售出';
else if($sta==-1) return '已使用';
else return '未使用';
}