payrecord.php 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. <?php
  2. //decode by http://dezend.qiling.org QQ 2859470
  3. define('CURSCRIPT', 'payrecord');
  4. require_once dirname(__FILE__) . '/global.php';
  5. require_once MYMPS_INC . '/db.class.php';
  6. require_once MYMPS_DATA . '/moneytype.inc.php';
  7. $part = $part ? $part : 'list';
  8. (!defined('IN_ADMIN') || !defined('IN_MYMPS')) && exit('Access Denied');
  9. if (!submit_check(CURSCRIPT . '_submit')) {
  10. chk_admin_purview('purview_会员支付记录');
  11. $here = '管理支付记录';
  12. $where = ' WHERE 1';
  13. $rstarttime = $starttime ? strtotime($starttime) : 0;
  14. $rendtime = $endtime ? strtotime($endtime) : 0;
  15. $status = $status ? intval($status) : 1;
  16. $where .= $rstarttime ? ' AND posttime >= \'' . $rstarttime . '\'' : '';
  17. $where .= $rendtime ? ' AND posttime <= \'' . $rendtime . '\'' : '';
  18. if ($keywords != '') {
  19. switch ($action) {
  20. case 1:
  21. $where .= ' AND orderid LIKE \'%' . $keywords . '%\'';
  22. break;
  23. case 2:
  24. $where .= ' AND userid LIKE \'%' . $keywords . '%\'';
  25. break;
  26. case 3:
  27. $where .= ' AND payip LIKE \'%' . $keywords . '%\'';
  28. break;
  29. case 4:
  30. $where .= ' AND paybz LIKE \'%' . $keywords . '%\'';
  31. break;
  32. }
  33. }
  34. if ($status == 2) {
  35. $where .= ' AND ifadd = 1 AND (paybz = \'支付完成\' OR paybz = \'支付成功\')';
  36. } else {
  37. if ($status == 3) {
  38. $where .= ' AND ifadd = 0 AND paybz = \'等待支付\'';
  39. }
  40. }
  41. $sql = 'SELECT * FROM `' . $db_mymps . 'payrecord` ' . $where . ' ORDER BY posttime DESC';
  42. $rows_num = mymps_count('payrecord', $where);
  43. $param = setParam(array('starttime', 'endtime', 'keywords', 'action', 'status'));
  44. $list = page1($sql);
  45. $starttime = $starttime ? date('Y-m-d', $starttime) : '';
  46. $endtime = $endtime ? date('Y-m-d', $endtime) : '';
  47. include mymps_tpl(CURSCRIPT);
  48. } else {
  49. if (is_array($delids)) {
  50. $i = 1;
  51. foreach ($delids as $kids => $vids) {
  52. mymps_delete(CURSCRIPT, 'WHERE id = ' . $vids);
  53. }
  54. }
  55. write_msg('会员充值记录更新成功!', $url, 'MympsRecord');
  56. }
  57. is_object($db) && $db->Close();
  58. $mymps_global = $db = $db_mymps = $part = NULL;