$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');