public static function get_payitem_record($w = array(), $order = null, $p = array()) { global $kekezu; $record_obj = new Keke_witkey_payitem_record_class(); $record_arr = array(); $where = " 1 = 1 "; if (!empty($w)) { $w['item_code'] and $where .= " and item_code = '" . $w['item_code'] . "'"; $w['use_type'] and $where .= " and use_type = '" . $w['use_type'] . "' "; $w['uid'] and $where .= " and uid = '" . $w['uid'] . "' "; } $order and $where .= " order by {$order} " or $where .= " order by record_id desc "; if (!empty($p)) { $page_obj = $kekezu->_page_obj; intval($p['page']) and $page = intval($p['page']) or $page = '1'; intval($p['page_size']) and $page_size = intval($p['page_size']) or $page_size = "10"; $p['url'] and $url = $p['url'] or $url = $_SERVER['HTTP_REFERER']; $p['anchor'] and $anchor = $p['anchor']; $record_obj->setWhere($where); $count = intval($record_obj->count_keke_witkey_payitem_record()); $pages = $page_obj->getPages($count, $page_size, $page, $url, "#" . $anchor); $where .= $pages['where']; } $record_obj->setWhere($where); $record_list = $record_obj->query_keke_witkey_payitem_record(); $record_arr['page'] = $pages['page']; $record_arr['list'] = $record_list; return $record_arr; }
<?php defined('ADMIN_KEKE') or exit('Access Denied'); kekezu::admin_check_role(34); $add_service_type = keke_glob_class::get_value_add_type(); $payitem_record_obj = new Keke_witkey_payitem_record_class(); $url = "index.php?do={$do}&view={$view}&w[record_id]={$w['record_id']}&w[username]={$w['username']}&w[item_code]={$w['item_code']}&w[ord]={$w['ord']}&page={$page}&w[page_size]={$page_size}"; $where = ' 1 = 1 '; $w[record_id] and $where .= " and record_id = " . $w[record_id]; $w[username] and $where .= " and username like '%{$w['username']}%'"; $w[item_code] and $where .= " and item_code like '%{$w['item_code']}%'"; $order_where = " order by on_time desc "; is_array($w['ord']) and $order_where = ' order by ' . $w['ord'][0] . ' ' . $w['ord'][1]; $where = $where . $order_where; $all_buy_sql = "select sum(use_cash) as cash from " . TABLEPRE . "witkey_payitem_record "; $all_buy_pro = db_factory::query($all_buy_sql); $all_buy_pro = $all_buy_pro[0] ? $all_buy_pro[0] : 0; $page_obj = $kekezu->_page_obj; $page = intval($page); $page or $page = 1; $w[page_size] and $page_size = intval($w[page_size]) or $page_size = 10; $payitem_record_obj->setWhere($where); $count = $payitem_record_obj->count_keke_witkey_payitem_record(); $page_obj->setAjax(1); $page_obj->setAjaxDom("ajax_dom"); $pages = $page_obj->getPages($count, $page_size, $page, $url); $where .= $pages[where]; $payitem_record_obj->setWhere($where); $payitem_record_arr = $payitem_record_obj->query_keke_witkey_payitem_record(); require $template_obj->template(ADMIN_DIRECTORY . '/tpl/admin_payitem_' . $view);