www.gusucode.com > Destoon B2B仿淘宝电子商务网站 UTF8 v6.0源码程序 > destoon/api/ajax/select.inc.php

    <?php
defined('IN_DESTOON') or exit('Access Denied');
login();
if($job == 'item') {
	$mid > 3 or dheader('DT_PATH');	
	$from = isset($from) ? trim($from) : 'item';
	isset($username) or $username = '';
	$condition = $mid == 4 ? 'groupid>5' : 'status=3';
	if($keyword) $condition .= " AND keyword LIKE '%$keyword%'";
	if($from == 'relate' && $mid == 16) {
		check_name($username) or exit;
		$condition .= " AND username='$username'";
	} else {
		if($_groupid == 1) {
			if($from == 'member') $condition .= " AND username='$_username'";
		} else {
			$condition .= " AND username='$_username'";
		}
	}
	if($itemid) $condition .= $mid == 4 ? " AND userid=$itemid" : " AND itemid=$itemid";
	$order = $mid == 4 ? 'userid DESC' : 'addtime DESC';
	$table = get_table($mid);
	$r = $db->get_one("SELECT COUNT(*) AS num FROM {$table} WHERE $condition");
	$items = $r['num'];
	$pages = pages($items, $page, $pagesize);
	$lists = array();
	$result = $db->query("SELECT * FROM {$table} WHERE $condition ORDER BY $order LIMIT $offset,$pagesize");
	while($r = $db->fetch_array($result)) {
		if($mid == 4) {
			$r['itemid'] = $r['userid'];
			$r['alt'] = $r['title'] = $r['company'];
			$r['adddate'] = $r['editdate'] = timetodate(0, 5);
			$r['level'] = 0;
			$r['style'] = '';
		} else {
			$r['adddate'] = timetodate($r['addtime'], 5);
			$r['editdate'] = timetodate($r['edittime'], 5);
			$r['alt'] = $r['title'];
			$r['title'] = set_style($r['title'], $r['style']);
			if(strpos($r['linkurl'], '://') === false) $r['linkurl'] = $MODULE[$mid]['linkurl'].$r['linkurl'];
		}
		$lists[] = $r;
	}
	$head_title = '选择信息';
} else {
	isset($from) or $from = '';
	if($DT['uploadlog']) {
		$table = $DT_PRE.'upload_'.($_userid%10);
		$condition = "username='$_username' AND width>90";
		$condition .= $from == 'album' ? " AND (upfrom='album' OR upfrom='photo')" : " AND upfrom<>'thumb'";
		$r = $db->get_one("SELECT COUNT(*) AS num FROM {$table} WHERE {$condition}");
		$items = $r['num'];
		$pages = pages($items, $page, $pagesize);
		$lists = array();
		$result = $db->query("SELECT * FROM {$table} WHERE {$condition} ORDER BY pid DESC LIMIT $offset,$pagesize");
		while($r = $db->fetch_array($result)) {
			$r['introduce'] = timetodate($r['addtime'], 6).'&#10;'.$r['width'].'px * '.$r['height'].'px&#10;';
			$r['ext'] = file_ext($r['fileurl']);
			$r['thumb'] = $r['fileurl'];
			$r['middle'] = str_replace('.thumb.'.$r['ext'], '.middle.'.$r['ext'], $r['thumb']);
			$r['large'] = str_replace('.thumb.'.$r['ext'], '', $r['thumb']);
			$lists[] = $r;
		}
	} else {
		foreach($MODULE as $M) {
			if($M['module'] == 'photo') {
				$mid = $M['moduleid'];
				break;
			}
		}
		$mid or message('系统未开启图库功能');
		$from = isset($from) ? trim($from) : '';
		$fid = isset($fid) ? trim($fid) : '';
		if($itemid) {
			$item = $db->get_one("SELECT username,title FROM {$DT_PRE}photo_{$mid} WHERE itemid=$itemid");
			if(!$item || ($item['username'] != $_username && $_groupid > 1)) dheader(DT_PATH);
			$r = $db->get_one("SELECT COUNT(*) AS num FROM {$DT_PRE}photo_item_{$mid} WHERE item=$itemid");
			$items = $r['num'];
			$pages = pages($items, $page, $pagesize);
			$lists = array();
			$result = $db->query("SELECT * FROM {$DT_PRE}photo_item_{$mid} WHERE item=$itemid ORDER BY listorder ASC,itemid ASC LIMIT $offset,$pagesize");
			while($r = $db->fetch_array($result)) {
				$r['ext'] = file_ext($r['thumb']);
				$r['middle'] = str_replace('.thumb.'.$r['ext'], '.middle.'.$r['ext'], $r['thumb']);
				$r['large'] = str_replace('.thumb.'.$r['ext'], '', $r['thumb']);
				$lists[] = $r;
			}
		} else {
			$condition = "status=3 AND items>0 AND username='$_username'";
			if($keyword) $condition .= " AND keyword LIKE '%$keyword%'";
			$r = $db->get_one("SELECT COUNT(*) AS num FROM {$DT_PRE}photo_{$mid} WHERE $condition");
			$items = $r['num'];
			$pages = pages($items, $page, $pagesize);
			$lists = array();
			$result = $db->query("SELECT * FROM {$DT_PRE}photo_{$mid} WHERE $condition ORDER BY addtime LIMIT $offset,$pagesize");
			while($r = $db->fetch_array($result)) {
				$lists[] = $r;
			}
		}
	}
	$head_title = '选择图片';
}
include template('select', 'member');
?>