/**
* 生成订单
* @param array $data 购买数据
* @return array $ret 结果状态
*/
public function buy($data)
{
//--开始事务
$model = new Model();
$model->startTrans();
//--判断用户是否有足够余额
$goods = D('goods')->getById($data['id']);
date_default_timezone_set("Asia/Shanghai");
$amount = $data['number'] * $goods['univalent'];
$user = D('user')->getById(session('user')['id']);
if ($user['balance'] < $amount) {
return array('ret' => false, 'msg' => '余额不足');
}
//--修改用户余额
$newBalance = $user['balance'] - $amount;
if (!D('user')->where(['id' => $user['id']])->save(['balance' => $newBalance])) {
$model->rollback();
}
//--创建订单
$order->user_id = session('user')['id'];
$order->goods_id = $goods['id'];
$order->shop_id = D('Goods')->getById($goods['id'])['shop_id'];
$order->goods_name = $goods['name'];
$order->univalent = $goods['univalent'];
$order->number = $data['number'];
$order->amount = $data['number'] * $goods['univalent'];
$order->remark = $data['remark'];
if ($this->create($order)) {
if (!($orderId = $this->add())) {
$model->rollback();
return array('ret' => false, 'msg' => $this->getError());
}
} else {
return array('ret' => false, 'msg' => $this->getError());
}
//--创建资金变动
$fundChange['user_id'] = $user['id'];
$fundChange['associate_id'] = $orderId;
$fundChange['time'] = time();
$fundChange['type'] = '订单扣款';
$fundChange['amount'] = $amount;
$fundChange['before_change'] = $user['balance'];
$fundChange['after_change'] = $user['balance'] - $amount;
if (D('FundChange')->create($fundChange)) {
if (!D('FundChange')->add()) {
$model->rollback();
return array('ret' => false, 'msg' => D('FundChange')->getError());
}
} else {
return array('ret' => false, 'msg' => D('FundChange')->getError());
}
$model->commit();
return array('ret' => true, 'msg' => '购买成功');
}
/**
* 注册
* @param array $data 注册数据
*/
public function regist($data)
{
// 将用户信息添加到User表中
$tranDb = new Model();
$tranDb->startTrans();
$username = $data['username'];
$result = $tranDb->table('world_user')->where("username = '******'")->find();
if ($result == null) {
$user_info = array('username' => $username, 'password' => $data['password'], 'session' => md5(time() . $username), 'modify_time' => time(), 'last_time' => time());
$uid = $tranDb->table('world_user')->data($user_info)->add();
$tranDb->commit();
return 1;
// 注册用户成功
} else {
return -1;
// 用户名已存在
}
}
/**
* 注册
* @param array $data 注册数据
*/
public function regist($data)
{
// 将用户信息添加到User表中
$tranDb = new Model();
$tranDb->startTrans();
$username = $data['username'];
$result = $tranDb->table('west_user')->where("username = '******'")->find();
if ($result == null) {
$user_info = array('username' => $username, 'password' => $data['password'], 'group' => 'user', 'status' => 0, 'modify_time' => time());
$uid = $tranDb->table('west_user')->data($user_info)->add();
if ($uid) {
// 判断公司是否存在
$company_name = $data['company_name'];
$result = $tranDb->table('west_company')->where("name = '{$company_name}'")->find();
if ($result == null) {
$company_info = array('uid' => $user_id, 'name' => $data['company_name'], 'mail' => $data['company_mail'], 'tel' => $data['company_tel'], 'modify_time' => time());
$result = $tranDb->table('west_company')->data($company_info)->add();
if ($result) {
$tranDb->commit();
return 1;
// 注册用户成功
} else {
$tranDb->rollback();
return -4;
// 添加公司信息失败
}
} else {
$tranDb->rollback();
return -3;
// 公司名称已存在
}
} else {
$tranDb->rollback();
return -2;
// 添加用户信息失败
}
} else {
return -1;
// 用户名已存在
}
}
/**
* 生成订单
* @param $order
* @param $goods
* @return array
*/
public function create($order, $goods)
{
$db = new Model();
$db->startTrans();
$order_id = $db->table($this->_table)->add($order);
$status = false;
if ($order_id) {
foreach ($goods as $g) {
$g['order_id'] = $order_id;
$flag = $db->table($this->_table_order_goods)->add($g);
}
if ($flag) {
$db->commit();
$status = true;
}
}
if (!$status) {
$db->rollback();
}
return $order_id;
}
public function commit()
{
parent::commit();
$this->query('SET FOREIGN_KEY_CHECKS = 1');
}
/**
* 提交事务
* @access public
* @return boolean
*/
public function end($success = true, $tag = 'default')
{
if ($success) {
if (self::$_startedTrans != $tag) {
return;
}
self::$_startedTrans = null;
return parent::commit();
} else {
self::$_startedTrans = null;
return parent::rollback();
}
}
public function calculateRice($rice_id)
{
$tranDb = new Think\Model();
$tranDb->startTrans();
//启动事务，保证数据的一致性
$ricedata = $this->where("rice_id='{$rice_id}'")->find();
$calculatedData = $this->calculateIndicator($ricedata);
$rid = $this->where("rice_id='{$rice_id}'")->save($calculatedData);
$wave = new InfoWaveModel();
$wid = $wave->addWave($calculatedData);
if ($rid !== false && $wid) {
$tranDb->commit();
return true;
} else {
$this->error = "计算失败！";
$tranDb->rollback();
return false;
}
}
/**
*修改用户
*/
public function EditSave()
{
//获取参数
$id = I('id', 0, 'int');
$username = I('username');
$password = I('password');
$email = I('email');
$mobile = I('mobile');
$roleid = I('role_id');
//是否修改
if ($id == 0) {
$result['result'] = false;
$result['msg'] = '该用户不存在';
$this->ajaxReturn($result);
}
//开启事务
$model = new Model();
$model->startTrans();
$flage === false;
//申明修改用户对象
$data['UserName'] = $username;
if (!empty($password)) {
$data['PassWord'] = md5($password);
}
$data['Email'] = $email;
$data['Mobile'] = $mobile;
//更新
$flage = $model->table('sys_user')->where('id=%d', $id)->save($data);
if ($flage === false) {
//事务回滚
$model->rollback();
$result['result'] = false;
$result['msg'] = '修改用户资料失败！';
$this->ajaxReturn($result);
} else {
$flage = $model->table('sys_role_user')->where('user_id=%d', $id)->delete();
if ($flage === false) {
//事务回滚
$model->rollback();
$result['result'] = false;
$result['msg'] = '修改用户资料失败！';
$this->ajaxReturn($result);
}
//角色处理
foreach ($roleid as $key => $value) {
# code...
$data2['role_id'] = $value;
$data2['user_id'] = $id;
$flage = $model->table('sys_role_user')->add($data2);
if ($flage === false) {
//事务回滚
$model->rollback();
$result['result'] = false;
$result['msg'] = '修改用户资料失败！';
$this->ajaxReturn($result);
}
}
if ($flage) {
//事务提交
$model->commit();
$result['result'] = true;
$result['msg'] = '修改用户资料成功！';
$this->ajaxReturn($result);
}
}
}
