PageRenderTime 55ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/source/admincp/admincp_card.php

https://github.com/kuaileshike/upload
PHP | 619 lines | 561 code | 52 blank | 6 comment | 143 complexity | 0ce681af9f6eda526df632eba16c23b3 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3. /**
    4. 

  4.  *      [Discuz!] (C)2001-2099 Comsenz Inc.
    5. 

  5.  *      This is NOT a freeware, use is subject to license terms
    6. 

  6.  *
    7. 

  7.  *      $Id: admincp_card.php 29335 2012-04-05 02:08:34Z cnteacher $
    8. 

  8.  */
    9. 

  9. 

  10. if(!defined('IN_DISCUZ') || !defined('IN_ADMINCP')) {
    11. 

  11. 	exit('Access Denied');
    12. 

  12. }
    13. 

  13. if($operation != 'export') {
    14. 

  14. 	cpheader();
    15. 

  15. }
    16. 

  16. 

  17. $operation = $_GET['operation'] ? $_GET['operation'] : 'set' ;
    18. 

  18. $card_setting = $_G['setting']['card'];
    19. 

  19. 

  20. if($operation == 'set') {
    21. 

  21. 	$nav = 'config';
    22. 

  22. 	$submenu['set'] = 1;
    23. 

  23. } elseif ($operation == 'manage') {
    24. 

  24. 	$nav = 'admin';
    25. 

  25. 	$submenu['manage'] = 1;
    26. 

  26. } elseif ($operation == 'type') {
    27. 

  27. 	$nav = 'nav_card_type';
    28. 

  28. 	$submenu['type'] = 1;
    29. 

  29. } elseif ($operation == 'make') {
    30. 

  30. 	$nav = 'nav_card_make';
    31. 

  31. 	$submenu['make'] = 1;
    32. 

  32. } elseif ($operation == 'log') {
    33. 

  33. 	$nav = 'nav_card_log';
    34. 

  34. } else {
    35. 

  35. 	$nav = '';
    36. 

  36. }
    37. 

  37. if($nav != '') {
    38. 

  38. 	if(!submitcheck('cardsubmit', 1) || $operation == 'manage' || $operation == 'type') {
    39. 

  39. 		shownav('extended', 'nav_card', $nav);
    40. 

  40. 		showsubmenu('nav_card', array(
    41. 

  41. 			array('config', 'card', $submenu['set']),
    42. 

  42. 			array('admin', 'card&operation=manage', $submenu['manage']),
    43. 

  43. 			array('nav_card_type', 'card&operation=type', $submenu['type']),
    44. 

  44. 			array('nav_card_make', 'card&operation=make', $submenu['make']),
    45. 

  45. 			array(array('menu' => 'nav_card_log', 'submenu' => array(
    46. 

  46. 				array('nav_card_log_add', 'card&operation=log&do=add', $_GET['do'] == 'add'),
    47. 

  47. 				array('nav_card_log_del', 'card&operation=log&do=del', $_GET['do'] == 'del'),
    48. 

  48. 				array('nav_card_log_cron', 'card&operation=log&do=cron', $_GET['do'] == 'cron')
    49. 

  49. 			)), in_array($_GET['do'], array('add', 'del', 'cron')))
    50. 

  50. 		));
    51. 

  51. 	}
    52. 

  52. }
    53. 

  53. if($operation == 'set') {
    54. 

  54. 	if(!submitcheck('cardsubmit')) {
    55. 

  55. 		showformheader('card&operation=set&');
    56. 

  56. 		showtableheader();
    57. 

  57. 		showsetting('card_config_open', 'card_config_open', ($card_setting['open'] ? $card_setting['open'] : 0), 'radio');
    58. 

  58. 		showsubmit('cardsubmit');
    59. 

  59. 		showtablefooter();
    60. 

  60. 		showformfooter();
    61. 

  61. 	} else {
    62. 

  62. 		C::t('common_setting')->update('card', array('open' => $_POST['card_config_open']));
    63. 

  63. 		updatecache('setting');
    64. 

  64. 		cpmsg('card_config_succeed', 'action=card&operation=set', 'succeed');
    65. 

  65. 	}
    66. 

  66. } elseif($operation == 'manage'){
    67. 

  67. 	if(submitcheck('cardsubmit')) {
    68. 

  68. 		if(is_array($_POST['delete'])) {
    69. 

  69. 			$delnum = C::t('common_card')->delete($_POST['delete']);
    70. 

  70. 			$card_info = serialize(array('num' => ($delnum ? $delnum : 0)));
    71. 

  71. 			$cardlog = array(
    72. 

  72. 				'uid' => $_G['uid'],
    73. 

  73. 				'cardrule' => '',
    74. 

  74. 				'info' => $card_info,
    75. 

  75. 				'dateline' => $_G['timestamp'],
    76. 

  76. 				'operation' => 3,
    77. 

  77. 				'username' => $_G['member']['username']
    78. 

  78. 			);
    79. 

  79. 			C::t('common_card_log')->insert($cardlog);
    80. 

  80. 		}
    81. 

  81. 	}
    82. 

  82. 	$sqladd = cardsql();
    83. 

  83. 	foreach($_GET AS $key => $val) {
    84. 

  84. 		if(strpos($key, 'srch_') !== false && $val) {
    85. 

  85. 			if(in_array($key, array('srch_username'))){
    86. 

  86. 				$val = rawurlencode($val);
    87. 

  87. 			}
    88. 

  88. 			$export_url[] = $key.'='.$val;
    89. 

  89. 		}
    90. 

  90. 	}
    91. 

  91. 

  92. 	$perpage = max(20, empty($_GET['perpage']) ? 20 : intval($_GET['perpage']));
    93. 

  93. 	echo '<script type="text/javascript" src="static/js/calendar.js"></script>';
    94. 

  94. 

  95. 	showtips('card_manage_tips');
    96. 

  96. 	$card_type_option = '';
    97. 

  97. 	foreach(C::t('common_card_type')->range(0, 0, 'ASC') as $result) {
    98. 

  98. 		$card_type[$result['id']] = $result;
    99. 

  99. 		$card_type_option .= "<option value=\"{$result['id']}\" ".($_GET['srch_card_type'] == $result['id'] ? 'selected' : '').">{$result['typename']}</option>";
    100. 

  100. 	}
    101. 

  101. 	showformheader('card', '', 'cdform', 'get');
    102. 

  102. 	showtableheader();
    103. 

  103. 	showtablerow('', array('width="80"', 'width="100"', 'width=100', 'width="260"'),
    104. 

  104. 		array(
    105. 

  105. 			cplang('card_number'), '<input type="text" name="srch_id" class="txt" value="'.$_GET['srch_id'].'" />',
    106. 

  106. 			cplang('card_log_price').cplang('between'), '<input type="text" name="srch_price_min" class="txt" value="'.($_GET['srch_price_min'] ? $_GET['srch_price_min'] : '').'" />- &nbsp;<input type="text" name="srch_price_max" class="txt" value="'.($_GET['srch_price_max'] ? $_GET['srch_price_max'] :'' ).'" />',
    107. 

  107. 		)
    108. 

  108. 	);
    109. 

  109. 

  110. 	echo "<input type='hidden' name='action' value='card'><input type='hidden' name='operation' value='manage'>";
    111. 

  111. 	$extcredits_option = "<option value=''>".cplang('nolimit')."</option>";
    112. 

  112. 	foreach($_G['setting']['extcredits'] AS $key => $val) {
    113. 

  113. 		$extcredits_option .= "<option value='$key' ".($_GET['srch_extcredits'] == $key ? 'selected' : '').">{$val['title']}</option>";
    114. 

  114. 	}
    115. 

  115. 	foreach(array('1' => cplang('card_manage_status_1'), '2' => cplang('card_manage_status_2'), '9' => cplang('card_manage_status_9')) AS $key => $val) {
    116. 

  116. 		$status_option .= "<option value='{$key}' ".($_GET['srch_card_status'] == $key ? "selected" : '').">{$val}</option>";
    117. 

  117. 	}
    118. 

  118. 	showtablerow('', array(),
    119. 

  119. 		array(
    120. 

  120. 			cplang('card_extcreditsval'), '<input type="text" name="srch_extcreditsval" class="txt" style="width:42px;" value="'.$_GET['srch_extcreditsval'].'" /><select name="srch_extcredits">'.$extcredits_option.'</select>',
    121. 

  121. 			cplang('card_status'), "<select name='srch_card_status'><option value=''>".cplang('nolimit')."</option>".$status_option."</select>",
    122. 

  122. 		)
    123. 

  123. 	);
    124. 

  124. 	showtablerow('', array(),
    125. 

  125. 		array(
    126. 

  126. 			cplang('card_log_used_user'), '<input type="text" name="srch_username" class="txt" value="'.$_GET['srch_username'].'" />',
    127. 

  127. 			cplang('card_used_dateline'), '<input type="text" name="srch_useddateline_start" class="txt" value="'.$_GET['srch_useddateline_start'].'" onclick="showcalendar(event, this);" />- &nbsp;<input type="text" name="srch_useddateline_end" class="txt" value="'.$_GET['srch_useddateline_end'].'" onclick="showcalendar(event, this)" />',
    128. 

  128. 		)
    129. 

  129. 	);
    130. 

  130. 

  131. 	$perpage_selected[$perpage] = "selected=selected";
    132. 

  132. 	showtablerow('', array(),
    133. 

  133. 		array(
    134. 

  134. 			cplang('card_type'), '<select name="srch_card_type"><option value="">'.cplang('nolimit').'</option><option value="0" '.($_GET['srch_card_type'] != '' && $_GET['srch_card_type'] == 0 ? 'selected' : '').'>'.cplang('card_type_default').'</option>'.$card_type_option.'</select>',
    135. 

  135. 			cplang('card_search_perpage'), '<select name="perpage" class="ps" onchange="this.form.submit();" ><option value="20" '.$perpage_selected[20].'>'.cplang('perpage_20').'</option><option value="50" '.$perpage_selected[50].'>'.cplang('perpage_50').'</option><option value="100" '.$perpage_selected[100].'>'.cplang('perpage_100').'</option></select>',
    136. 

  136. 		)
    137. 

  137. 	);
    138. 

  138. 

  139. 	showtablerow('', array('width="40"', 'width="100"', 'width=50', 'width="260"'),
    140. 

  140. 		array(
    141. 

  141. 			'<input type="submit" name="srchbtn" class="btn" value="'.$lang['search'].'" />',''
    142. 

  142. 		)
    143. 

  143. 	);
    144. 

  144. 	showtablefooter();
    145. 

  145. 	showformfooter();
    146. 

  146. 

  147. 	showformheader('card&operation=manage&');
    148. 

  148. 	showtableheader('card_manage_title');
    149. 

  149. 	showsubtitle(array('', cplang('card_number'), cplang('card_log_price'), cplang('card_extcreditsval'), cplang('card_type'), cplang('card_status'), cplang('card_log_used_user'), cplang('card_used_dateline'), cplang('card_make_cleardateline')/*, cplang('card_maketype')*/, cplang('card_maketime'), cplang('card_log_maker')));
    150. 

  150. 

  151. 

  152. 	$start_limit = ($page - 1) * $perpage;
    153. 

  153. 	$export_url[] = 'start='.$start_limit;
    154. 

  154. 	foreach ($_GET AS $key => $val) {
    155. 

  155. 		if(strpos($key, 'srch_') !== FALSE) {
    156. 

  156. 			$url_add .= '&'.$key.'='.$val;
    157. 

  157. 		}
    158. 

  158. 	}
    159. 

  159. 	$url = ADMINSCRIPT.'?action=card&operation=manage&page='.$page.'&perpage='.$perpage.$url_add;
    160. 

  160. 	$count = $sqladd ? C::t('common_card')->count_by_where($sqladd) : C::t('common_card')->count();
    161. 

  161. 	if($count) {
    162. 

  162. 		$multipage = multi($count, $perpage, $page, $url, 0, 3);
    163. 

  163. 		foreach(C::t('common_card')->fetch_all_by_where($sqladd, $start_limit, $perpage) as $result) {
    164. 

  164. 			$userlist[$result['makeruid']] = $result['makeruid'];
    165. 

  165. 			$userlist[$result['uid']] = $result['uid'];
    166. 

  166. 			$cardlist[] = $result;
    167. 

  167. 		}
    168. 

  168. 		if($userlist) {
    169. 

  169. 			$members = C::t('common_member')->fetch_all($userlist);
    170. 

  170. 			unset($userlist);
    171. 

  171. 		}
    172. 

  172. 

  173. 		foreach($cardlist AS $key => $val) {
    174. 

  174. 			showtablerow('', array('class="smallefont"', '', '', '', '', '', '', '', '', '', '', ''), array(
    175. 

  175. 				'<input class="checkbox" type="checkbox" name="delete[]" value="'.$val[id].'">',
    176. 

  176. 				$val['id'],
    177. 

  177. 				$val['price'].cplang('card_make_price_unit'),
    178. 

  178. 				$val['extcreditsval'].$_G['setting']['extcredits'][$val['extcreditskey']]['title'],
    179. 

  179. 				$card_type[$val['typeid']]['typename'] ? $card_type[$val['typeid']]['typename'] : cplang('card_type_default'),
    180. 

  180. 				cplang("card_manage_status_".$val['status']),
    181. 

  181. 				$val['uid'] ? "<a href='home.php?mod=space&uid={$val[uid]}' target='_blank'>".$members[$val['uid']]['username'] : ' -- ',
    182. 

  182. 				$val['useddateline'] ? dgmdate($val['useddateline']) : ' -- ',
    183. 

  183. 				$val['cleardateline'] ? dgmdate($val['cleardateline'], 'Y-m-d') : cplang('card_make_cleardateline_none'),
    184. 

  184. 				dgmdate($val['dateline'], 'u'),
    185. 

  185. 				"<a href='home.php?mod=space&uid={$val['makeruid']}' target='_blank'>".$members[$val['makeruid']]['username']."</a>"
    186. 

  186. 			));
    187. 

  187. 		}
    188. 

  188. 		echo '<input type="hidden" name="perpage" value="'.$perpage.'">';
    189. 

  189. 		showsubmit('cardsubmit', 'submit', 'del', '<a href="'.ADMINSCRIPT.'?action=card&operation=export&'.implode('&', $export_url).'" title="'.$lang['card_export_title'].'">'.$lang['card_export'].'</a>', $multipage, false);
    190. 

  190. 	}
    191. 

  191. 

  192. 	showtablefooter();
    193. 

  193. 	showformfooter();
    194. 

  194. 

  195. } elseif($operation == 'type') {
    196. 

  196. 	if(submitcheck('cardsubmit')) {
    197. 

  197. 		if(is_array($_POST['delete'])) {
    198. 

  198. 			C::t('common_card_type')->delete($_POST['delete']);
    199. 

  199. 			C::t('common_card')->update_by_typeid($_POST['delete'], array('typeid'=>1));
    200. 

  200. 		}
    201. 

  201. 		if(is_array($_POST['newtype'])) {
    202. 

  202. 			$_POST['newtype'] = dhtmlspecialchars(daddslashes($_POST['newtype']));
    203. 

  203. 			foreach($_POST['newtype'] AS $key => $val) {
    204. 

  204. 				if(trim($val)) {
    205. 

  205. 					C::t('common_card_type')->insert(array('typename' => trim($val)));
    206. 

  206. 				}
    207. 

  207. 			}
    208. 

  208. 		}
    209. 

  209. 	}
    210. 

  210. 	showtips('card_type_tips');
    211. 

  211. 	showformheader('card&operation=type&');
    212. 

  212. 	showtableheader();
    213. 

  213. 	showtablerow('class="header"', array('', ''), array(
    214. 

  214. 		cplang('delete'),
    215. 

  215. 		cplang('card_type'),
    216. 

  216. 	));
    217. 

  217. 

  218. 	showtablerow('', '', array(
    219. 

  219. 		'<input class="checkbox" type="checkbox" value ="" disabled="disabled" >',
    220. 

  220. 		cplang('card_type_default'),
    221. 

  221. 	));
    222. 

  222. 	foreach(C::t('common_card_type')->range(0, 0, 'ASC') as $result) {
    223. 

  223. 		showtablerow('', '', array(
    224. 

  224. 		'<input class="checkbox" type="checkbox" name ="delete[]" value ="'.$result['id'].'" >',
    225. 

  225. 		$result['typename'],
    226. 

  226. 		));
    227. 

  227. 	}
    228. 

  228. 	echo <<<EOT
    229. 

  229. <script type="text/JavaScript">
    230. 

  230. 	var rowtypedata = [
    231. 

  231. 		[[1,''], [1,'<input type="text" class="txt" size="30" name="newtype[]">']],
    232. 

  232. 	];
    233. 

  233. 	</script>
    234. 

  234. EOT;
    235. 

  235. 	echo '<tr><td></td><td colspan="2"><div><a href="###" onclick="addrow(this, 0)" class="addtr">'.$lang['add_new'].'</a></div></td></tr>';
    236. 

  236. 	showsubmit('cardsubmit', 'submit', 'select_all');
    237. 

  237. 	showtablefooter();
    238. 

  238. 	showformfooter();
    239. 

  239. } elseif($operation == 'make') {
    240. 

  240. 	if(!submitcheck('cardsubmit', 1)) {
    241. 

  241. 		if($card_log = C::t('common_card_log')->fetch_by_operation(1)) {
    242. 

  242. 			$card_log['rule'] = dunserialize($card_log['cardrule']);
    243. 

  243. 		}
    244. 

  244. 		$card_type[] = array(0, cplang('card_type_default'));
    245. 

  245. 		foreach(C::t('common_card_type')->range(0, 0, 'ASC') as $result) {
    246. 

  246. 			$card_type[] = array($result['id'], $result['typename']);
    247. 

  247. 		}
    248. 

  248. 

  249. 		echo '<script type="text/javascript" src="static/js/calendar.js"></script>';
    250. 

  250. 		showformheader('card&operation=make&');
    251. 

  251. 		showtips('card_make_tips');
    252. 

  252. 		showtableheader();
    253. 

  253. 

  254. 		showsetting('card_make_rule', '', '', '<input type="text" name="rule" class="txt" value="'.($card_log['rule']['rule'] ? $card_log['rule']['rule'] : '').'" onkeyup="javascript:checkcardrule(this);"><br /><span id="cardrule_view" class="tips2" style="display:none;"></span>');
    255. 

  255. echo <<<EOT
    256. 

  256. 	<script type="text/javascript" charset="gbk">
    257. 

  257. 		function checkcardrule(obj) {
    258. 

  258. 			var chrLength = obj.value.length;
    259. 

  259. 			$('cardrule_view').style.display = "";
    260. 

  260. 			$('cardrule_view').innerHTML = "{$lang['card_number']}<strong>"+chrLength+"</strong>{$lang['card_number_unit']}";
    261. 

  261. 		}
    262. 

  262. 	</script>
    263. 

  263. EOT;
    264. 

  264. 

  265. 		showsetting('card_type', array('typeid', $card_type), $card_log['rule']['typeid'], 'select');
    266. 

  266. 		showsetting('card_make_num', 'num', ($card_log['rule']['num'] ? $card_log['rule']['num'] : 1), 'text');
    267. 

  267. 		$extcredits_option = '';
    268. 

  268. 		foreach($_G['setting']['extcredits'] AS $key => $val) {
    269. 

  269. 			$extcredits_option .= "<option value='$key'".($card_log['rule']['extcreditskey'] == $key ? 'selected' : '').">{$val['title']}</option>";
    270. 

  270. 		}
    271. 

  271. 		showsetting('card_make_extcredits', '', '', '<select name="extcreditskey" style="width:80px;">'.$extcredits_option.'</select><input type="text" name="extcreditsval" value="'.($card_log['rule']['extcreditsval'] ? $card_log['rule']['extcreditsval'] : 1).'" class="txt" style="width:50px;">');
    272. 

  272. 		showsetting('card_make_price', 'price', ($card_log['rule']['price'] ? $card_log['rule']['price'] : 0), 'text');
    273. 

  273. 

  274. 		showsetting('card_make_cleardateline', 'cleardateline', date("Y-m-d", $_G['timestamp']+31536000), 'calendar', '', 0, '');
    275. 

  275. 

  276. 		showsetting('card_make_description', 'description', $card_log['description'] , 'text');
    277. 

  277. 		showsubmit('cardsubmit');
    278. 

  278. 		showtablefooter();
    279. 

  279. 		showformfooter();
    280. 

  280. 	} else {
    281. 

  281. 		$_GET['rule'] = rawurldecode(trim($_GET['rule']));
    282. 

  282. 		$_GET['num'] = intval($_GET['num']);
    283. 

  283. 		list($y, $m, $d) = explode("-", $_GET['cleardateline']);
    284. 

  284. 		$_GET['step'] = $_GET['step'] ? $_GET['step'] : 1;
    285. 

  285. 		$cleardateline = $_GET['cleardateline'] && $y && $m ? mktime(23, 59, 59, $m, $d, $y) : 0 ;
    286. 

  286. 		if($cleardateline < TIMESTAMP) {
    287. 

  287. 			cpmsg('card_make_cleardateline_early', '', 'error');
    288. 

  288. 		}
    289. 

  289. 		if(!$_GET['rule']) {
    290. 

  290. 			cpmsg('card_make_rule_empty', '', 'error');
    291. 

  291. 		}
    292. 

  292. 		if($_GET['num'] < 1) {
    293. 

  293. 			cpmsg('card_make_num_error', '', 'error');
    294. 

  294. 		}
    295. 

  295. 		include libfile("class/card");
    296. 

  296. 		$card = new card();
    297. 

  297. 		$checkrule = $card->checkrule($_GET['rule'], 1);
    298. 

  298. 

  299. 		if($checkrule === -2) {
    300. 

  300. 			cpmsg('card_make_rule_error', '', 'error');
    301. 

  301. 		}
    302. 

  302. 

  303. 		if($_GET['step'] == 1) {
    304. 

  304. 			$card_rule = serialize(array('rule' => $_GET['rule'], 'price' => $_GET['price'], 'extcreditskey' => $_GET['extcreditskey'], 'extcreditsval' => $_GET['extcreditsval'], 'num' => $_GET['num'], 'cleardateline' => $cleardateline, 'typeid' => $_GET['typeid']));
    305. 

  305. 			$cardlog = array(
    306. 

  306. 				'uid' => $_G['uid'],
    307. 

  307. 				'username' => $_G['member']['username'],
    308. 

  308. 				'cardrule' => $card_rule,
    309. 

  309. 				'dateline' => $_G['timestamp'],
    310. 

  310. 				'description' => $_GET['description'],
    311. 

  311. 				'operation' => 1,
    312. 

  312. 

  313. 			);
    314. 

  314. 			$logid = C::t('common_card_log')->insert($cardlog, true);
    315. 

  315. 		}
    316. 

  316. 		$onepage_make = 500;
    317. 

  317. 		$_GET['logid'] = $logid ? $logid : $_GET['logid'];
    318. 

  318. 		if($_GET['num'] > $onepage_make) {
    319. 

  319. 			$step_num = ceil($_GET['num']/$onepage_make);
    320. 

  320. 			if($step_num > 1) {
    321. 

  321. 				if($_GET['step'] == $step_num) {
    322. 

  322. 					if($_GET['num'] % $onepage_make == 0) {
    323. 

  323. 						$makenum = $onepage_make;
    324. 

  324. 					} else {
    325. 

  325. 						$makenum = $_GET['num'] % $onepage_make;
    326. 

  326. 					}
    327. 

  327. 				} else {
    328. 

  328. 					$makenum = $onepage_make;
    329. 

  329. 					$nextstep = $_GET['step'] + 1;
    330. 

  330. 				}
    331. 

  331. 			}
    332. 

  332. 		} else {
    333. 

  333. 			$makenum = $_GET['num'];
    334. 

  334. 		}
    335. 

  335. 

  336. 		$cardval = array(
    337. 

  337. 			'typeid' => $_GET['typeid'],
    338. 

  338. 			'price' => $_GET['price'],
    339. 

  339. 			'extcreditskey' => $_GET['extcreditskey'],
    340. 

  340. 			'extcreditsval' => $_GET['extcreditsval'],
    341. 

  341. 			'cleardateline' => $cleardateline
    342. 

  342. 		);
    343. 

  343. 		$card->make($_GET['rule'], $makenum, $cardval);
    344. 

  344. 		$_GET['succeed_num'] += $card->succeed;
    345. 

  345. 		$_GET['fail_num'] += $card->fail;
    346. 

  346. 		if($nextstep) {
    347. 

  347. 			$_GET['rule'] = rawurlencode($_GET['rule']);
    348. 

  348. 			$nextlink = "action=card&operation=make&rule={$_GET['rule']}&num={$_GET['num']}&price={$_GET['price']}&extcreditskey={$_GET['extcreditskey']}&extcreditsval={$_GET['extcreditsval']}&cleardateline={$_GET['cleardateline']}&step={$nextstep}&succeed_num={$_GET['succeed_num']}&fail_num={$_GET['fail_num']}&typeid={$_GET['typeid']}&logid={$_GET['logid']}&cardsubmit=yes";
    349. 

  349. 			cpmsg('card_make_step', $nextlink, 'loading', array('step' => $nextstep - 1, 'step_num' => $step_num, 'succeed_num' => $card->succeed, 'fail_num' => $card->fail));
    350. 

  350. 		} else {
    351. 

  351. 			$card_info = serialize(array('num' => $_GET['num'], 'succeed_num' => $_GET['succeed_num'], 'fail_num' => $_GET['fail_num']));
    352. 

  352. 			C::t('common_card_log')->update($_GET['logid'], array('info'=>$card_info));
    353. 

  353. 			if(ceil($_GET['num']*0.6) > $_GET['succeed_num']) {
    354. 

  354. 				cpmsg('card_make_rate_succeed', 'action=card&operation=make', 'succeed', array('succeed_num' => $_GET['succeed_num'], 'fail_num' => $_GET['fail_num']));
    355. 

  355. 			}
    356. 

  356. 			cpmsg('card_make_succeed', 'action=card&operation=manage', 'succeed', array('succeed_num' => $_GET['succeed_num'], 'fail_num' => $_GET['fail_num']));
    357. 

  357. 		}
    358. 

  358. 

  359. 	}
    360. 

  360. } elseif($operation == 'log'){
    361. 

  361. 	showformheader('card&operation=log&');
    362. 

  362. 	showtableheader();
    363. 

  363. 

  364. 	$perpage = max(20, empty($_GET['perpage']) ? 20 : intval($_GET['perpage']));
    365. 

  365. 	$start_limit = ($page - 1) * $perpage;
    366. 

  366. 

  367. 	$do = in_array($_GET['do'], array('add', 'task', 'del', 'cron')) ? $_GET['do'] : 'add';
    368. 

  368. 	$operation = 0;
    369. 

  369. 	switch($do) {
    370. 

  370. 		case 'add':
    371. 

  371. 			$operation = 1;
    372. 

  372. 			break;
    373. 

  373. 		case 'task':
    374. 

  374. 			$operation = 2;
    375. 

  375. 			break;
    376. 

  376. 		case 'del':
    377. 

  377. 			$operation = 3;
    378. 

  378. 			break;
    379. 

  379. 		case 'cron':
    380. 

  380. 			$operation = 9;
    381. 

  381. 			break;
    382. 

  382. 	}
    383. 

  383. 

  384. 	if($do == 'add' || $do == 'task') {
    385. 

  385. 		$showtabletitle = array(
    386. 

  386. 			cplang('time'),
    387. 

  387. 			cplang('card_log_operation'),
    388. 

  388. 			cplang('card_log_user'),
    389. 

  389. 			cplang('card_log_rule'),
    390. 

  390. 			cplang('card_log_add_info'),
    391. 

  391. 			cplang('card_log_description')
    392. 

  392. 		);
    393. 

  393. 	} elseif($do == 'del') {
    394. 

  394. 		$showtabletitle = array(
    395. 

  395. 			cplang('time'),
    396. 

  396. 			cplang('card_log_operation'),
    397. 

  397. 			cplang('card_log_user'),
    398. 

  398. 			cplang('card_log_del_info')
    399. 

  399. 		);
    400. 

  400. 

  401. 	} elseif($do == 'cron') {
    402. 

  402. 		$showtabletitle = array(
    403. 

  403. 			cplang('time'),
    404. 

  404. 			cplang('card_log_operation'),
    405. 

  405. 			cplang('card_log_cron_info')
    406. 

  406. 		);
    407. 

  407. 	}
    408. 

  408. 

  409. 	showtablerow('class="header"', array('class="td21"','class="td23"','class="td23"','class="td21"','class="td23"'), $showtabletitle);
    410. 

  410. 

  411. 	$count = C::t('common_card_log')->count_by_operation($operation);
    412. 

  412. 	if($count) {
    413. 

  413. 		$url = ADMINSCRIPT."?action=card&operation=log&do=".$do."&page=".$page.'&perpage='.$perpage;
    414. 

  414. 		$multipage = multi($count, $perpage, $page, $url, 0, 3);
    415. 

  415. 

  416. 		foreach(C::t('common_card_log')->fetch_all_by_operation($operation, $start_limit, $perpage) as $result) {
    417. 

  417. 			$result['info_arr'] = dunserialize($result['info']);
    418. 

  418. 			if($result['operation'] == 1 || $result['operation'] == 2) {
    419. 

  419. 				$result['cardrule_arr'] = dunserialize($result['cardrule']);
    420. 

  420. 				$showrule = array(
    421. 

  421. 					$result['cardrule_arr']['rule'],
    422. 

  422. 					cplang('card_log_price').' : '.$result['cardrule_arr']['price'].cplang('card_make_price_unit'),
    423. 

  423. 					cplang('card_log_make_num').' : '.$result['cardrule_arr']['num'],
    424. 

  424. 					cplang('card_extcreditsval').' : '.$result['cardrule_arr']['extcreditsval'].$_G['setting']['extcredits'][$result['cardrule_arr']['extcreditskey']]['title'],
    425. 

  425. 					cplang('card_make_cleardateline').' : '.($result['cardrule_arr']['cleardateline'] ? dgmdate($result['cardrule_arr']['cleardateline'], 'Y-m-d H:i') : cplang('card_make_cleardateline_none')),
    426. 

  426. 				);
    427. 

  427. 

  428. 				$showinfo = array(
    429. 

  429. 					cplang('succeed_num').' : '.$result['info_arr']['succeed_num'],
    430. 

  430. 					cplang('fail_num').' : '.$result['info_arr']['fail_num']
    431. 

  431. 				);
    432. 

  432. 				$showtablerow = array(
    433. 

  433. 					dgmdate($result['dateline']),
    434. 

  434. 					$result['operation'] == 1 ? cplang('card_log_operation_add') : cplang('card_log_operation_task'),
    435. 

  435. 					$result['username'],
    436. 

  436. 					implode("<br />", $showrule),
    437. 

  437. 					implode("<br />", $showinfo),
    438. 

  438. 					$result['description']
    439. 

  439. 				);
    440. 

  440. 			} elseif ($result['operation'] == 3 || $result['operation'] == 9) {
    441. 

  441. 				$showinfo =array(
    442. 

  442. 					cplang('card_log_num').$result['info_arr']['num'],
    443. 

  443. 				);
    444. 

  444. 				$showtablerow = $result['operation'] == 3 ? array(
    445. 

  445. 					dgmdate($result['dateline']),
    446. 

  446. 					cplang('card_log_operation_del'),
    447. 

  447. 					$result['username'],
    448. 

  448. 					implode("<br />", $showinfo),
    449. 

  449. 				) : array(
    450. 

  450. 					dgmdate($result['dateline']),
    451. 

  451. 					cplang('card_log_operation_cron'),
    452. 

  452. 					implode("<br />", $showinfo),
    453. 

  453. 				);
    454. 

  454. 			}
    455. 

  455. 			showtablerow('', array('class="smallefont"'), $showtablerow);
    456. 

  456. 		}
    457. 

  457. 	} else {
    458. 

  458. 

  459. 	}
    460. 

  460. 	showsubmit('', '', '', '', $multipage);
    461. 

  461. 	showtablefooter();
    462. 

  462. 	showformfooter();
    463. 

  463. } elseif ($operation == 'export'){
    464. 

  464. 

  465. 	$sqladd = cardsql();
    466. 

  466. 	$_GET['start'] = intval($_GET['start']);
    467. 

  467. 	$count = $sqladd ? C::t('common_card')->count_by_where($sqladd) : C::t('common_card')->count();
    468. 

  468. 	if($count) {
    469. 

  469. 		$cardtype = C::t('common_card_type')->range();
    470. 

  470. 		$count = min(10000, $count);
    471. 

  471. 		foreach(C::t('common_card')->fetch_all_by_where($sqladd, $_GET['start'], $count) as $result) {
    472. 

  472. 			$userlist[$result['uid']] = $result['uid'];
    473. 

  473. 			$userlist[$result['makeruid']] = $result['makeruid'];
    474. 

  474. 			$result['extcreditsval'] = $result['extcreditsval'].$_G['setting']['extcredits'][$result['extcreditskey']]['title'];
    475. 

  475. 			unset($result['extcreditskey']);
    476. 

  476. 			unset($result['maketype']);
    477. 

  477. 			$cardlist[] = $result;
    478. 

  478. 		}
    479. 

  479. 		if($userlist) {
    480. 

  480. 			$members = C::t('common_member')->fetch_all($userlist);
    481. 

  481. 			unset($userlist);
    482. 

  482. 		}
    483. 

  483. 

  484. 		foreach($cardlist AS $key => $val) {
    485. 

  485. 			foreach($val as $skey => $sval) {
    486. 

  486. 				$sval = preg_replace('/\s+/', ' ', $sval);
    487. 

  487. 				if($skey == 'id' && !$title['id']) { $title['id'] = cplang('card_number'); }
    488. 

  488. 				if($skey == 'typeid') {
    489. 

  489. 					if(!$title['typeid']) {
    490. 

  490. 						$title['typeid'] = cplang("card_type");
    491. 

  491. 					}
    492. 

  492. 					$sval = $sval != 0 ? $cardtype[$sval]['typename'] : cplang('card_type_default');
    493. 

  493. 				}
    494. 

  494. 				if(in_array($skey, array('uid', 'makeruid'))) {
    495. 

  495. 					if($skey == 'makeruid' && !$title['makeruid']) {
    496. 

  496. 						$title['makeruid'] = cplang("card_log_maker");
    497. 

  497. 					}
    498. 

  498. 					if($skey == 'uid' && !$title['uid']) {
    499. 

  499. 						$title['uid'] = cplang("card_log_used_user");
    500. 

  500. 					}
    501. 

  501. 

  502. 					$sval = $members[$sval]['username'];
    503. 

  503. 				}
    504. 

  504. 				if($skey == 'price') {
    505. 

  505. 					if(!$title['price']) {
    506. 

  506. 						$title['price'] = cplang('card_log_price');
    507. 

  507. 					}
    508. 

  508. 					$sval = $sval.cplang("card_make_price_unit");
    509. 

  509. 				}
    510. 

  510. 				if($skey == 'extcreditsval') {
    511. 

  511. 					if(!$title['extcreditsval']) {
    512. 

  512. 						$title['extcreditsval'] = cplang('card_extcreditsval');
    513. 

  513. 					}
    514. 

  514. 				}
    515. 

  515. 				if($skey == 'status') {
    516. 

  516. 					if(!$title['status']) {
    517. 

  517. 						$title['status'] = cplang('card_status');
    518. 

  518. 					}
    519. 

  519. 					$sval = cplang("card_manage_status_".$sval);
    520. 

  520. 				}
    521. 

  521. 				if(in_array($skey, array('dateline', 'cleardateline', 'useddateline'))) {
    522. 

  522. 					if($skey == 'dateline' && !$title['dateline']) {
    523. 

  523. 						$title['dateline'] = cplang('card_maketime');
    524. 

  524. 					}
    525. 

  525. 					if($skey == 'cleardateline' && !$title['cleardateline']) {
    526. 

  526. 						$title['cleardateline'] = cplang('card_make_cleardateline');
    527. 

  527. 					}
    528. 

  528. 					if($skey == 'useddateline' && !$title['useddateline']) {
    529. 

  529. 						$title['useddateline'] = cplang('card_used_dateline');
    530. 

  530. 					}
    531. 

  531. 

  532. 					$sval = $sval ? date("Y-m-d", $sval) : '';
    533. 

  533. 				}
    534. 

  534. 				$detail .= strlen($sval) > 11 && is_numeric($sval) ? '['.$sval.'],' : $sval.',';
    535. 

  535. 			}
    536. 

  536. 			$detail = $detail."\n";
    537. 

  537. 		}
    538. 

  538. 

  539. 	}
    540. 

  540. 	$detail = implode(',', $title)."\n".$detail;
    541. 

  541. 	$filename = 'card_'.date('Ymd', TIMESTAMP).'.csv';
    542. 

  542. 

  543. 	ob_end_clean();
    544. 

  544. 	header('Content-Encoding: none');
    545. 

  545. 	header('Content-Type: application/octet-stream');
    546. 

  546. 	header('Content-Disposition: attachment; filename='.$filename);
    547. 

  547. 	header('Pragma: no-cache');
    548. 

  548. 	header('Expires: 0');
    549. 

  549. 	if($_G['charset'] != 'gbk') {
    550. 

  550. 		$detail = diconv($detail, $_G['charset'], 'GBK');
    551. 

  551. 	}
    552. 

  552. 	echo $detail;
    553. 

  553. 	exit();
    554. 

  554. } else {
    555. 

  555. 	cpmsg('action_noaccess', '', 'error');
    556. 

  556. }
    557. 

  557. 

  558. 

  559. function cardsql() {
    560. 

  560. 

  561. 

  562. 	$_GET = daddslashes($_GET);
    563. 

  563. 

  564. 	$_GET['srch_id'] = trim($_GET['srch_id']);
    565. 

  565. 

  566. 	$_GET['srch_price_max'] = intval($_GET['srch_price_max']);
    567. 

  567. 	$_GET['srch_price_min'] = intval($_GET['srch_price_min']);
    568. 

  568. 

  569. 	$_GET['srch_useddateline'] = trim($_GET['srch_useddateline']);
    570. 

  570. 	$_GET['srch_username'] = trim($_GET['srch_username']);
    571. 

  571. 	$_GET['srch_extcredits'] = trim($_GET['srch_extcredits']);
    572. 

  572. 	$_GET['srch_extcreditsval'] = intval($_GET['srch_extcreditsval']) > 0 ? intval($_GET['srch_extcreditsval']) : '' ;
    573. 

  573. 	$_GET['srch_username'] = trim($_GET['srch_username']);
    574. 

  574. 

  575. 	$_GET['srch_useddateline_start'] = trim($_GET['srch_useddateline_start']);
    576. 

  576. 	$_GET['srch_useddateline_end'] = trim($_GET['srch_useddateline_end']);
    577. 

  577. 

  578. 	$sqladd = '';
    579. 

  579. 	if($_GET['srch_id']) {
    580. 

  580. 		$sqladd .= " AND id LIKE '%{$_GET['srch_id']}%' ";
    581. 

  581. 	}
    582. 

  582. 	if($_GET['srch_card_type'] != '') {
    583. 

  583. 		$sqladd .= " AND typeid = '{$_GET['srch_card_type']}'";
    584. 

  584. 	}
    585. 

  585. 	if($_GET['srch_price_min'] && !$_GET['srch_price_max']) {
    586. 

  586. 		$sqladd .= " AND price = '{$_GET['srch_price_min']}'";
    587. 

  587. 	} elseif($_GET['srch_price_max'] && !$_GET['srch_price_min']) {
    588. 

  588. 		$sqladd .= " AND price = '{$_GET['srch_price_max']}'";
    589. 

  589. 	} elseif($_GET['srch_price_min'] && $_GET['srch_price_max']) {
    590. 

  590. 		$sqladd .= " AND price between '{$_GET['srch_price_min']}' AND '{$_GET['srch_price_max']}'";
    591. 

  591. 	}
    592. 

  592. 

  593. 	if($_GET['srch_extcredits']) {
    594. 

  594. 		$sqladd .= " AND extcreditskey = '{$_GET['srch_extcredits']}'";
    595. 

  595. 	}
    596. 

  596. 	if($_GET['srch_extcreditsval']) {
    597. 

  597. 		$sqladd .= " AND extcreditsval = '{$_GET['srch_extcreditsval']}'";
    598. 

  598. 	}
    599. 

  599. 

  600. 	if($_GET['srch_username']) {
    601. 

  601. 		$uid = ($uid = C::t('common_member')->fetch_uid_by_username($_GET['srch_username'])) ? $uid : C::t('common_member_archive')->fetch_uid_by_username($_GET['srch_username']);
    602. 

  602. 		$sqladd .= " AND uid = '{$uid}'";
    603. 

  603. 	}
    604. 

  604. 	if($_GET['srch_card_status']) {
    605. 

  605. 		$sqladd .= " AND status = '{$_GET['srch_card_status']}'";
    606. 

  606. 	}
    607. 

  607. 	if($_GET['srch_useddateline_start'] || $_GET['srch_useddateline_end']) {
    608. 

  608. 		if($_GET['srch_useddateline_start']) {
    609. 

  609. 			list($y, $m, $d) = explode("-", $_GET['srch_useddateline_start']);
    610. 

  610. 			$sqladd .= " AND useddateline >= '".mktime('0', '0', '0', $m, $d, $y)."' ";
    611. 

  611. 		}
    612. 

  612. 		if($_GET['srch_useddateline_end']) {
    613. 

  613. 			list($y, $m, $d) = explode("-", $_GET['srch_useddateline_end']);
    614. 

  614. 			$sqladd .= " AND useddateline <= '".mktime('23', '59', '59', $m, $d, $y)."' AND useddateline <> 0 ";
    615. 

  615. 		}
    616. 

  616. 	}
    617. 

  617. 	return $sqladd ? ' 1 '.$sqladd : '';
    618. 

  618. }
    619. 

  619. ?>
    620.