$service = db_factory::query($sql . $s_sql . $f_sql . ' group by model_id', 1, 3600);
$payitem = db_factory::get_one($sql . sprintf(' from %switkey_finance where fina_type="out"
and fina_action="payitem" ', TABLEPRE) . $f_sql, 1, 3600);
break;
case 'profit':
$sql = sprintf(' select sum(site_profit) c from %switkey_finance where site_profit>0 ', TABLEPRE);
$task = db_factory::get_count($sql . ' and obj_type="task" ' . $f_sql, 0, 'c', 3600);
$service = db_factory::get_count($sql . ' and obj_type="service" ' . $f_sql, 0, 'c', 3600);
$payitem = db_factory::get_count($sql . ' and obj_type="payitem" ' . $f_sql, 0, 'c', 3600);
$auth = db_factory::get_count($sql . ' and INSTR(obj_type,"_auth")>0 ' . $f_sql, 0, 'c', 3600);
$withdraw = db_factory::get_count(sprintf(' select sum(fee) c from %switkey_withdraw
where withdraw_status=2 ', TABLEPRE) . $w_sql, 0, 'c', 3600);
$p_all = floatval($task + $service + $payitem + $auth + $withdraw);
break;
case 'withdraw':
$list = db_factory::query(sprintf(' select sum(withdraw_cash) cash,sum(fee) fee,
count(withdraw_id) count,pay_type from %switkey_withdraw where 1 = 1 ', TABLEPRE) . $w_sql . ' group by pay_type', 1, 3600);
$list && ($list = kekezu::get_arr_by_key($list, 'pay_type'));
$bank_arr = keke_glob_class::get_bank();
$pay_online = kekezu::get_payment_config('', 'online');
break;
case 'charge':
$sql = ' select sum(fina_cash) cash,sum(fina_credit) credit,count(fina_id) count ';
$r_sql = sprintf(' ,obj_type from %switkey_finance
where INSTR(obj_type,"_charge")>0 and fina_type = "in"', TABLEPRE);
$charge = db_factory::query($sql . $r_sql . $f_sql . ' group by obj_type ', 1, 3600);
$charge = kekezu::get_arr_by_key($charge, 'obj_type');
$fina_type = keke_glob_class::get_fina_charge_type();
break;
}
require keke_tpl_class::template(ADMIN_DIRECTORY . '/tpl/admin_finance_revenue');
