/**
* 改变状态
*/
function do_active($id)
{
//权限验证
role::check('user_charge');
if (!$id) {
remind::set(Kohana::lang('o_global.bad_request'), 'user/user_charge');
}
$db = Database::instance();
$data = array_shift($db->query('SELECT * FROM user_charge_order WHERE id=' . $id)->result_array(false));
if ($data['id'] <= 0 || $data['status'] > 0) {
remind::set(Kohana::lang('o_global.bad_request'), 'user/user_charge');
}
$logodata = array();
$logodata['manager_id'] = $this->manager_id;
$logodata['ip'] = tool::get_str_ip();
$logodata['user_log_type'] = 27;
$logodata['method'] = __CLASS__ . '::' . __METHOD__ . '()';
$logodata['memo'] = "充值订单号:" . $data['order_num'] . ", 购买拍点数:" . $data['price'] . ", 充值金额:" . $data['money'];
$sql = "UPDATE user_charge_order SET status=1 WHERE id='" . $id . "' ";
if ($db->query($sql)) {
//充值用户Money
$sql_reward = "UPDATE users \r\n SET user_money = user_money+" . $data['price'] . "\r\n WHERE id='" . $data['user_id'] . "'\r\n ";
$db->query($sql_reward);
//操作log
ulog::add($logodata);
remind::set(Kohana::lang('o_global.update_success'), 'user/user_charge', 'success');
} else {
//操作log
ulog::add($logodata, 1);
remind::set(Kohana::lang('o_global.update_error'), 'user/user_charge', 'error');
}
}
function index()
{
//判断用户是否是已经登录状态
$data = role::get_manager();
if ($data['id'] > 0) {
$data['success'] = 'true';
$data['msg'] = 1;
} else {
$data['success'] = 'false';
$data['msg'] = 1;
}
$username = $this->input->post('username');
$password = $this->input->post('password');
$secode = $this->input->post('secode');
$remember = $this->input->post('remember');
$data['success'] = 'false';
//验证登录
$manager = role::log_in($username, $password);
if (isset($manager['username'])) {
//判断普通账号的状态、权限
if (!role::is_root($manager['username'])) {
if ($manager['active'] != 1) {
ulog::login($manager['id'], 1);
$data['msg'] = Kohana::lang('o_global.account_was_locked');
}
$actions = role::manager_actions($manager['id'], TRUE);
if (count($actions) < 1) {
ulog::login($manager['id'], 2);
$data['msg'] = Kohana::lang('o_global.account_permission_enough');
}
}
//是否记录用户名
if ($remember == 1) {
cookie::set('opococ_username', $username);
} else {
cookie::delete('opococ_username');
}
//清除记录登录错误记录
//Session::instance()->delete('login_error_count');
//记入SESSION
role::set_manager_session($manager);
//记录日志
ulog::login($manager['id']);
$data['success'] = 'true';
$data['msg'] = 1;
/*if(empty($request_url))
{
remind::set(Kohana::lang('o_global.login_success'), '/index', 'success');
}
else
{
$request_url = url::base() . urldecode($request_url);
remind::set(Kohana::lang('o_global.login_success'), $request_url, 'success');
}*/
}
die(json_encode($data));
}
public function update_order_status($status)
{
$request_data = $this->input->post();
if (empty($_POST)) {
remind::set(Kohana::lang('o_global.bad_request'), '/order/order/index/' . $request_data['backurl']);
}
if (empty($request_data['order_ids'])) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/order/index/' . $request_data['backurl']);
}
if (Order_basic_Model::show_status($status) == FALSE) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/order/index/' . $request_data['backurl']);
}
$status_name = Order_basic_Model::show_status($status);
$order_ids = $request_data['order_ids'];
$logs_data = array();
$logs_data['manager_id'] = $this->manager_id;
$logs_data['user_log_type'] = 28;
$logs_data['ip'] = Input::instance()->ip_address();
for ($i = 0; $i < count($order_ids); $i++) {
$order_info = $this->order_basic_obj->get_order_by_id($order_ids[$i]);
if ($order_info && $order_info['status'] != $status) {
$order_id = $order_info['id'];
$u_ob_r = $this->order_basic_obj->update_status_by_order_id($order_id, $status);
if ($u_ob_r == TRUE) {
$order_details = $this->order_detail_obj->get_orders_by_orderid($order_id);
if ($order_details) {
for ($j = 0; $j < count($order_details); $j++) {
$u_od_r = $this->order_detail_obj->update_status_by_id($order_details[$j]['id'], $status);
if ($u_od_r == TRUE) {
$logs_data['memo'] = "订单操作成功！状态：" . $status_name . "，订单号：" . $order_id . '(子订单:' . $order_details[$j]['id'] . ')';
ulog::instance()->add($logs_data);
} else {
$logs_data['memo'] = "订单操作失败！状态：" . $status_name . "，订单号：" . $order_id . '(子订单:' . $order_details[$j]['id'] . ')';
ulog::instance()->add($logs_data);
}
}
} else {
$logs_data['memo'] = "子订单不存在:" . $order_id;
ulog::instance()->add($logs_data);
}
} else {
$logs_data['memo'] = "订单操作失败！状态：" . $status_name . "，订单号：" . $order_id;
ulog::instance()->add($logs_data);
}
} else {
$logs_data['memo'] = "订单ID不存在或已取消:" . $order_id;
ulog::instance()->add($logs_data);
}
}
remind::set('操作完成，详见日志', '/order/order/index/' . $request_data['backurl'], 'success');
}
/**
* change password
*/
public function change_password()
{
if ($_POST) {
$password = $this->input->post('password');
$password1 = $this->input->post('password1');
$password2 = $this->input->post('password2');
$data = role::get_manager();
//判断SESSION中的数据是否存在
if ($data['id'] > 0) {
if (strlen($password1) < 6) {
remind::set(Kohana::lang('o_manage.password_length_error'), 'manage/manager/change_password');
}
if ($password1 != $password2) {
remind::set(Kohana::lang('o_manage.two_pwd_not_valid'), 'manage/manager/change_password');
} else {
$manager = Mymanager::instance($data['id'])->get();
if ($manager['password'] == md5($password)) {
$update_data = array();
$update_data['password'] = md5($password1);
$manager = Mymanager::instance($data['id'])->update($update_data);
$is_remember = isset($manager['is_remember']) ? $manager['is_remember'] : 0;
//验证是否记住状态
$manager['is_remember'] = $is_remember;
role::set_manager_session($manager);
//记录用户修改密码日志
ulog::change_password($this->manager_id, 1);
remind::set(Kohana::lang('o_global.update_success'), 'manage/manager/change_password', 'success');
} else {
//记录用户修改密码日志
ulog::change_password($this->manager_id);
remind::set(Kohana::lang('o_manage.pwd_is_incorrect'), 'manage/manager/change_password');
}
}
} else {
remind::set(Kohana::lang('o_global.login_first'), 'login');
}
}
$this->template->content = new View("manage/manager_change_password");
}
/**
* 虚拟充值
* @param unknown_type $id
*/
function recharge_virtual_money($id)
{
//权限检查 得到所有可管理站点ID列表
role::check('user_recharge');
if ($_POST) {
//标签过滤
tool::filter_strip_tags($_POST);
$userobj = user::get_instance();
$usermoney = $userobj->get_user_virtual_money($id);
if ($_POST['money'] > 0) {
$money_type_name = '竞波币';
//记录日志
$data_log = array();
$data_log['order_num'] = date('YmdHis') . rand(0, 99999);
$data_log['user_id'] = $id;
$data_log['log_type'] = 6;
//参照config acccount_type 设置
$data_log['is_in'] = 0;
$data_log['price'] = $_POST['money'];
$data_log['user_money'] = $usermoney;
$data_log['memo'] = $_POST['memo'];
account_virtual_log::get_instance()->add($data_log);
//$um = user_money::get_instance()->update_money($data_log['is_in'], $data_log['user_id'], $data_log['price'], $data_log['log_type'], $data_log['order_num'], $money_type, $data_log['memo']);
//添加日志
$logs_data = array();
$logs_data['manager_id'] = $this->manager_id;
$logs_data['user_log_type'] = 29;
$logs_data['ip'] = tool::get_long_ip();
$logs_data['memo'] = "成功为用户{$id}充值{$money_type_name}{$_POST['money']}";
ulog::instance()->add($logs_data);
remind::set($money_type_name . '充值成功', request::referrer(), 'success');
}
}
$this->template->content = new View("user/user_recharge_virtual");
$this->template->content->data = Myuser::instance($id)->get();
}
public function set_bonus($id, $page = 1)
{
/* 权限检查 订单列表 */
role::check('order_list');
if (empty($id)) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/ticketnum/');
}
$ticketobj = ticket::get_instance();
$result = $ticketobj->get($id);
if (empty($result)) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/ticketnum/');
}
//提交操作
if (!empty($_POST)) {
tool::filter_strip_tags($_POST);
$bonus = $_POST['money'];
$num = $_POST['num'];
$password = $_POST['password'];
$flag = $ticketobj->update_bonus($id, $bonus, $num, $password, $this->manager_id);
$addchar = '成功';
if (!$flag) {
$addchar = '失败';
}
//添加日志
$logs_data = array();
$logs_data['manager_id'] = $this->manager_id;
$logs_data['user_log_type'] = 28;
$logs_data['ip'] = tool::get_long_ip();
$logs_data['memo'] = "为id:{$result['id']}的彩票录入奖金:{$bonus}{$addchar}";
ulog::instance()->add($logs_data);
if ($flag) {
remind::set("成功为id:{$result['id']}的彩票录入奖金:{$bonus}", '/order/ticketnum/index/hasticket/?page=' . $page, 'success');
} else {
remind::set("为id:{$result['id']}的彩票录入奖金:{$bonus}失败", '/order/ticketnum/?page=' . $page, 'error');
}
}
if ($result['status'] != 1 && !($result['status'] == 2 && $result['bonus'] == -9999)) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/ticketnum/');
}
//获取更多信息
$result['plan'] = plan::get_instance()->get_plan_by_tid($result['plan_id'], $result['ticket_type']);
$result['user'] = user::get_instance()->get($result['plan']['user_id']);
$result['manager'] = '';
if (!empty($result['manager_id'])) {
$manager = Mymanager::instance($result['manager_id'])->get();
$result['manager'] = $manager['username'];
}
$this->template->content = new View("order/order_set_bonus", $result);
}
public function exportinfo()
{
/* 权限检查 订单列表 */
role::check('user_draw_money_review');
if (empty($_POST)) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/user_draw_money/index/hascharge');
}
$request_data = $this->input->post();
if (empty($request_data['order_ids'])) {
remind::set(Kohana::lang('o_global.bad_request'), 'order/user_draw_money/index/hascharge');
}
$user_draw_moeny = User_draw_moneyService::get_instance();
$query_struct = array();
$query_struct['where']['id'] = $request_data['order_ids'];
$results = $user_draw_moeny->query_assoc($query_struct);
$expexcel = array();
$m = 0;
$expexcel[$m] = array('日期', '总金额', '总笔数', '支付宝帐号', '', '', '', '', '', '');
$all_money = 0;
$all_count = 0;
$infos = array();
foreach ($results as $key => $value) {
$row = array();
$row[] = ' ' . $value['id'];
$row[] = $value['truename'];
$row[] = ' ' . $value['account'];
$row[] = $value['bank_name'];
$row[] = $value['province'];
$row[] = $value['city'];
$row[] = $value['bank_found'];
$row[] = $value['money'];
$row[] = ' 2';
$row[] = $value['memo'];
//str_replace("\n", ";", $value['memo']);
$all_money = $all_money + $value['money'];
$infos[] = $row;
$all_count++;
}
$alipay_config = Kohana::config('site_config.site.alipay_account');
$m++;
$expexcel[$m][] = date('Y-m-d');
$expexcel[$m][] = ' ' . $all_money;
$expexcel[$m][] = ' ' . $all_count;
$expexcel[$m][] = $alipay_config;
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$expexcel[$m][] = '';
$m++;
$expexcel[$m] = array('商户流水号', '收款银行户名', '收款银行帐号', '收款开户银行', '收款银行所在省份', '收款银行所在市', '收款支行名称', '金额', '对公对私标志', '备注');
$expexcel = array_merge($expexcel, $infos);
myexcel::get_instance()->get_excel_from_rows($expexcel, '会员提现财务导出');
//添加日志
$logs_data = array();
$logs_data['manager_id'] = $this->manager_id;
$logs_data['user_log_type'] = 30;
$logs_data['ip'] = tool::get_long_ip();
$logs_data['memo'] = "成功导出选定款项款项,id:" . implode(',', $request_data['order_ids']);
ulog::instance()->add($logs_data);
exit;
}
/**
* log in
*/
function index()
{
$this->logout(FALSE);
/* 原请求页面 */
$request_url = $this->input->get('request_url');
//用户名和密码输入错误三次后就需要输入验证码
$login_error_count = Session::instance()->get('login_error_count');
if (!$login_error_count) {
$login_error_count = 1;
Session::instance()->set('login_error_count', $login_error_count);
}
//判断用户是否是已经登录状态
$data = role::get_manager();
//D($data);
if ($data['id'] > 0) {
remind::set(Kohana::lang('o_global.current_status_login'), '/', 'success');
}
//验证码KEY
secoder::$seKey = 'opococ.secoder';
//错误信息
$message = remind::get_message();
if (empty($message)) {
$error_display = "none";
$error = "";
} else {
$error_display = "";
$error = $message;
}
//登录
if ($_POST) {
$username = $this->input->post('username');
$password = $this->input->post('password');
$secode = $this->input->post('secode');
$remember = $this->input->post('remember');
//验证验证码
if ($login_error_count > 3 && !secoder::check($secode)) {
remind::set(Kohana::lang('o_global.code_input_error'), 'login');
}
//验证登录
$manager = role::log_in($username, $password);
if (isset($manager['username'])) {
//判断普通账号的状态、权限
if (!role::is_root($manager['username'])) {
if ($manager['active'] != 1) {
ulog::login($manager['id'], 1);
remind::set(Kohana::lang('o_global.account_was_locked'), 'login');
}
$actions = role::manager_actions($manager['id'], TRUE);
if (count($actions) < 1) {
ulog::login($manager['id'], 2);
remind::set(Kohana::lang('o_global.account_permission_enough'), 'login');
}
}
/* 是否记录用户名 */
if ($remember == 1) {
cookie::set('opococ_username', $username);
} else {
cookie::delete('opococ_username');
}
//清除记录登录错误记录
Session::instance()->delete('login_error_count');
//记入SESSION
role::set_manager_session($manager);
//记录日志
ulog::login($manager['id']);
if (empty($request_url)) {
remind::set(Kohana::lang('o_global.login_success'), '/index', 'success');
} else {
$request_url = url::base() . urldecode($request_url);
remind::set(Kohana::lang('o_global.login_success'), $request_url, 'success');
}
} else {
ulog::login();
$login_error_count++;
Session::instance()->set('login_error_count', $login_error_count);
remind::set(Kohana::lang('o_global.user_and_password_error'), 'login');
}
}
/* 浏览器记录的用户名 */
$username = cookie::get('opococ_username');
$this->template = new View('login');
$this->template->login_error_count = $login_error_count;
$this->template->error = $error;
$this->template->error_display = $error_display;
$this->template->username = $username;
$this->template->render(TRUE);
}
/**
* 修改用户信息
*/
function edit($id)
{
//权限检查 得到所有可管理站点ID列表
role::check('user_edit');
if ($_POST) {
//标签过滤
tool::filter_strip_tags($_POST);
if (Myuser::instance($id)->set_money($_POST['invite_user_id'], $_POST['reward_money'])) {
$arr['guest_user_id'] = intval($_POST['user_id']);
$arr['user_id'] = intval($_POST['invite_user_id']);
$arr['reward_money'] = intval($_POST['reward_money']);
$arr['memo'] = '邀请用户奖励';
$arr['reward_type'] = 'invite';
$arr['time_stamp'] = date("Y-m-d H:i:s", time());
User_inviteService::get_instance()->insert($arr);
$logodata = array();
$logodata['manager_id'] = $this->manager_id;
$logodata['ip'] = tool::get_str_ip();
$logodata['user_log_type'] = 28;
$logodata['method'] = __CLASS__ . '::' . __METHOD__ . '()';
$logodata['memo'] = "邀请奖励审核通过, 奖励:" . $_POST['reward_money'];
ulog::add($logodata);
remind::set(Kohana::lang('o_global.update_success'), request::referrer(), 'success');
} else {
remind::set(Kohana::lang('o_global.update_error'), request::referrer(), 'error');
}
}
$this->template->content = new View("user/user_invite_edit");
$id = intval($id);
$data = Myuser::instance($id)->get();
$data['invite'] = Myuser::instance($data['invite_user_id'])->get();
$sql = " SELECT COUNT(id) AS id FROM user_reward WHERE guest_user_id = " . $data['id'] . " AND user_id = " . $data['invite']['id'] . " AND reward_type = 'invite' ";
$data['reward'] = User_inviteService::get_instance()->get_one($sql);
$data['reward'] = $data['reward']['id'];
$this->template->content->data = $data;
}
public function chk($id)
{
if (empty($id)) {
return false;
}
$where = array();
$where['id'] = $id;
$rpt = ORM::factory('ag_settle_month', $id);
if ($rpt->loaded) {
if ($rpt->flag != 2) {
return 1;
} else {
if ($rpt->agent_type == 2) {
return 2;
}
}
$userid = $rpt->user_id;
$logtypexx = 9;
$rpt->flag = 3;
$rpt->date_add = date('Y-m-d H:i:s', time());
$rpt->save();
$userobj = user::get_instance();
$usermoney = $userobj->get_user_money($userid);
$money_type = 'BONUS_MONEY';
$money_type_set = Kohana::config('money_type');
if (array_key_exists($money_type, $money_type_set)) {
$money_type_name = $money_type_set[$money_type];
//记录日志
$data_log = array();
$data_log['order_num'] = 0;
$data_log['user_id'] = $userid;
$data_log['log_type'] = $logtypexx;
//参照config acccount_type 设置
$data_log['is_in'] = 0;
$data_log['price'] = $rpt->bonus;
$data_log['user_money'] = $usermoney;
$data_log['memo'] = '月结返利';
if ($rpt->bonus < 0) {
$data_log['price'] = $rpt->bonus * -1;
$data_log['is_in'] = 1;
if ($rpt->taxflag == 90) {
$data_log['memo'] = '月结扣税';
} else {
$data_log['memo'] = '其他';
}
}
$user_money = user_money::get_instance();
$um = $user_money->update_money($data_log['is_in'], $data_log['user_id'], $data_log['price'], $data_log['log_type'], $data_log['order_num'], $money_type, $data_log['memo']);
if (!$um) {
$rpt->flag = 91;
$rpt->date_add = date('Y-m-d H:i:s', time());
$rpt->save();
return 4;
} else {
//添加日志
$logs_data = array();
$logs_data['manager_id'] = 0;
// $this->manager_id;
$logs_data['user_log_type'] = 29;
$logs_data['ip'] = tool::get_long_ip();
$logs_data['memo'] = "成功为代理商{$id}返利{$money_type_name}{$rpt->bonus}";
ulog::instance()->add($logs_data);
// remind::set($money_type_name.'返利成功',request::referrer(),'success');
$rpt->flag = 4;
$rpt->date_add = date('Y-m-d H:i:s', time());
$rpt->save();
}
}
} else {
return 3;
}
}
