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);
public static function createPayitemRecord($item, $num, $type, $objId)
{
if (TOOL === TRUE) {
if ($type == 'task') {
$objInfo = db_factory::get_one(sprintf("select * from %switkey_task where task_id='%d'", TABLEPRE, $objId));
} else {
$objInfo = db_factory::get_one(sprintf("select * from %switkey_service where service_id='%d'", TABLEPRE, $objId));
}
$uid = $objInfo['uid'];
$username = $objInfo['username'];
$arrPayitemLists = self::getPayitemList($type);
$data = array(':item_name' => $arrPayitemLists[$item]['item_name']);
keke_finance_class::init_mem('payitem', $data);
$cash = $num * $arrPayitemLists[$item]['item_cash'];
if ($cash) {
$intFinaId = keke_finance_class::cash_out($uid, $cash, 'payitem', $cash, $type, $objId);
} else {
$intFinaId = 1;
}
if ($intFinaId) {
$objRecord = new Keke_witkey_payitem_record_class();
$objRecord->setItem_code($item);
$objRecord->setUid($uid);
$objRecord->setUsername($username);
$objRecord->setUse_cash($cash);
$objRecord->setUse_num(intval($num));
$objRecord->setObj_type($type);
$objRecord->setObj_id($objId);
$objRecord->setOn_time(time());
if ($item == 'tasktop' || $item == 'goodstop') {
$arrRecordInfo = self::getPayitemRecord($type, $objId, $item);
if ($arrRecordInfo) {
$objRecord->setWhere("record_id=" . intval($arrRecordInfo['record_id']));
if (time() < $arrRecordInfo['end_time']) {
$objRecord->setEnd_time($arrRecordInfo['end_time'] + 24 * 3600 * $num);
} else {
$objRecord->setEnd_time(time() + 24 * 3600 * $num);
}
$objRecord->edit_keke_witkey_payitem_record();
} else {
$objRecord->setEnd_time(time() + 24 * 3600 * $num);
$objRecord->create_keke_witkey_payitem_record();
}
} else {
$res = $objRecord->create_keke_witkey_payitem_record();
}
self::updateObjStatus($item, $type, $objId);
}
}
}
