www.gusucode.com > ShopEx481 & PHPWind 整合版码程序 > bbs/admin/orderlist.php

    <?php
!function_exists('adminmsg') && exit('Forbidden');
$basename="$admin_file?adminjob=orderlist";

if(!$action){
	InitGP(array('state','page'));
	if($state == 1){
		$sqladd = "WHERE state=0 OR state=1";
	} elseif($state == 2){
		$sqladd = "WHERE state=2";
	} else {
		$sqladd = '';
	}

	include_once(R_P.'require/forum.php');
	(!is_numeric($page) || $page < 1) && $page = 1;
	$limit = "LIMIT ".($page-1)*$db_perpage.",$db_perpage";
	$rt    = $db->get_one("SELECT COUNT(*) AS sum FROM pw_clientorder $sqladd");
	$pages = numofpage($rt['sum'],$page,ceil($rt['sum']/$db_perpage),"$basename&state=$state&");

	$orderdb = array();
	$query = $db->query("SELECT c.*,m.username FROM pw_clientorder c LEFT JOIN pw_members m USING(uid) $sqladd ORDER BY date DESC $limit");
	while($rt=$db->fetch_array($query)){
		$rt['date'] = get_date($rt['date']);
		$orderdb[]  = $rt;
	}
	include PrintEot('orderlist');exit;
} elseif($action == 'pay'){
	InitGP(array('id','step','payemail'));
	$rt=$db->get_one("SELECT c.*,m.username FROM pw_clientorder c LEFT JOIN pw_members m USING(uid) WHERE id='$id' AND state=0");
	!$rt && adminmsg('undefined_action');
	if(!$step){
		$rt['date'] = get_date($rt['date']);
		include PrintEot('orderlist');exit;
	}else{
		if(!$payemail){
			$basename="javascript:history.go(-1);";
			adminmsg('no_payemail');
		}
		!$db_rmbrate && $db_rmbrate=10;
		$currency = $rt['number'] * $db_rmbrate;
		$number   = $rt['number'];
		$db->update("UPDATE pw_memberdata SET currency=currency+'$currency' WHERE uid='$rt[uid]'");
		$db->update("UPDATE pw_clientorder SET payemail='$payemail',state=2 WHERE id='$id'");
		
		$log=array(
			'nums'		=>	0,
			'money'		=>	0,
			'uid'		=>	$rt['uid'],
			'username'	=>	Char_cv($rt['username']),
			'ip'		=>	$onlineip,
			'time'		=>	$timestamp,
			'number'	=>	$number,
			'currency'	=>	$currency,
		);
		include_once('template/wind/lang_toollog.php');
		$log['type']    = $lang['olpay'];
		$log['descrip'] = Char_cv($lang['olpay_descrip']);

		$db->update("INSERT INTO pw_toollog(type,filename,nums,money,descrip,uid,touid,username,ip,time) VALUES('$log[type]','$log[filename]','".(int)$log['nums']."','".(int)$log['money']."','$log[descrip]','$log[uid]','$log[touid]','$log[username]','$log[ip]','$log[time]')");

		require_once(R_P.'require/msg.php');
		$message=array(
			$rt['username'],
			'',
			'olpay_title',
			$timestamp,
			'olpay_content_2',
			'',
			'SYSTEM'
		);
		writenewmsg($message,1);
		adminmsg('operate_success');
	}
} elseif($_POST['action'] == 'del'){
	InitGP(array('selid'),'P');
	if(!$selid = checkselid($selid)){
		$basename="javascript:history.go(-1);";
		adminmsg('operate_error');
	}
	$db->update("DELETE FROM pw_clientorder WHERE id IN($selid)");
	adminmsg('operate_success');
}
?>