284 lines
9.7 KiB
PHP
284 lines
9.7 KiB
PHP
<?php
|
|
|
|
namespace App;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class C2cDeal extends Model
|
|
{
|
|
protected $table = 'c2c_deal';
|
|
public $timestamps = false;
|
|
protected $appends = [
|
|
'deal_money',
|
|
'currency_name',
|
|
'type',
|
|
'account_number',
|
|
'phone',
|
|
'seller_name',
|
|
'price',
|
|
'hes_account',
|
|
'hes_realname',
|
|
'way_name',
|
|
'format_create_time',
|
|
'is_seller',
|
|
'user_cash_info',
|
|
'seller_phone',
|
|
'user_realname',
|
|
'format_update_time',
|
|
'sell_cash_info',
|
|
];
|
|
public function getSellCashInfoAttribute(){
|
|
return UserCashInfo::where('user_id',$this->attributes['seller_id'])->first();
|
|
}
|
|
public function getUserCashInfoAttribute()
|
|
{
|
|
$user = $this->user()->getResults();
|
|
if (!$user) {
|
|
return [];
|
|
}
|
|
$cashinfo = $user->cashinfo;
|
|
if (!$cashinfo) {
|
|
return [];
|
|
}
|
|
return $cashinfo;
|
|
}
|
|
|
|
public function user()
|
|
{
|
|
return $this->belongsTo('App\Users', 'user_id', 'id');
|
|
}
|
|
public function seller()
|
|
{
|
|
return $this->belongsTo('App\Users', 'seller_id', 'id');
|
|
}
|
|
|
|
public function legalDealSend()
|
|
{
|
|
return $this->hasOne('App\C2cDealSend', 'id', 'legal_deal_send_id');
|
|
}
|
|
|
|
public function getCreateTimeAttribute()
|
|
{
|
|
return date('H:i m/d', $this->attributes['create_time']);
|
|
}
|
|
public function getFormatCreateTimeAttribute()
|
|
{
|
|
return date('Y-m-d H:i:s', $this->attributes['create_time']);
|
|
}
|
|
|
|
public function getFormatUpdateTimeAttribute()
|
|
{
|
|
$time=isset($this->attributes['update_time'])?$this->attributes['update_time']:0;
|
|
return $time?date('Y-m-d H:i:s',$time):'';
|
|
|
|
}
|
|
|
|
public function getDealMoneyAttribute()
|
|
{
|
|
$legal = C2cDealSend::find($this->attributes['legal_deal_send_id']);
|
|
if (!empty($legal)) {
|
|
return bcmul($this->attributes['number'], $legal->price, 6);
|
|
}
|
|
return 0;
|
|
}
|
|
|
|
|
|
public function getCurrencyNameAttribute()
|
|
{
|
|
$legal = C2cDealSend::find($this->attributes['legal_deal_send_id']);
|
|
if (!empty($legal)) {
|
|
return $legal->currency_name;
|
|
}
|
|
return '';
|
|
}
|
|
|
|
public function getSellerPhoneAttribute(){
|
|
$seller = Users::find($this->attributes['seller_id']);
|
|
if (empty($seller)) return null;
|
|
// $user = Users::find($seller->user_id);
|
|
if (!empty($seller)){
|
|
return $seller->phone;
|
|
}else{
|
|
return null;
|
|
}
|
|
}
|
|
|
|
public function getTypeAttribute()
|
|
{
|
|
return $this->hasOne('App\C2cDealSend', 'id', 'legal_deal_send_id')->value('type');
|
|
}
|
|
|
|
public function getAccountNumberAttribute()
|
|
{
|
|
return $this->hasOne('App\Users', 'id', 'user_id')->value('account_number');
|
|
}
|
|
|
|
public function getPhoneAttribute()
|
|
{
|
|
return $this->hasOne('App\Users', 'id', 'user_id')->value('account_number');
|
|
}
|
|
|
|
public function getSellerNameAttribute()
|
|
{
|
|
//return $this->hasOne('App\Seller', 'id', 'seller_id')->value('name');
|
|
return $this->hasOne('App\Users', 'id', 'seller_id')->value('account_number');
|
|
}
|
|
|
|
public function getPriceAttribute()
|
|
{
|
|
return $this->hasOne('App\C2cDealSend', 'id', 'legal_deal_send_id')->value('price');
|
|
}
|
|
|
|
public function getHesAccountAttribute()
|
|
{
|
|
$legal_send = C2cDealSend::find($this->attributes['legal_deal_send_id']);
|
|
if (!empty($legal_send)) {
|
|
$seller = Users::find($legal_send->seller_id)->cashinfo;
|
|
if (!empty($seller)) {
|
|
|
|
if ($legal_send->way == 'bank') {
|
|
return $seller->bank_account;
|
|
} elseif ($legal_send->way == 'we_chat') {
|
|
return $seller->wechat_account;
|
|
} elseif ($legal_send->way == 'ali_pay') {
|
|
return $seller->ali_account;
|
|
}
|
|
}
|
|
}
|
|
return '';
|
|
}
|
|
|
|
public function getHesRealnameAttribute()
|
|
{
|
|
|
|
$seller_id=$this->attributes['seller_id'];
|
|
|
|
$real = UserReal::where('user_id', $seller_id)->where('review_status', 2)->first();
|
|
if (!empty($real)) {
|
|
return $real->name;
|
|
}
|
|
|
|
return '';
|
|
}
|
|
|
|
public function getUserRealnameAttribute()
|
|
{
|
|
$user_real = UserReal::where('user_id', $this->attributes['user_id'])->first();
|
|
if (empty($user_real)) {
|
|
return '';
|
|
}
|
|
return $user_real->name;
|
|
}
|
|
|
|
public function getWayNameAttribute()
|
|
{
|
|
return C2cDealSend::find($this->attributes['legal_deal_send_id'])->way_name;
|
|
}
|
|
|
|
// 是否卖方
|
|
public function getIsSellerAttribute()
|
|
{
|
|
$user_id = Users::getUserId();
|
|
$legal_send = C2cDealSend::find($this->attributes['legal_deal_send_id']);
|
|
$seller = Seller::find($this->attributes['seller_id']);
|
|
if ($legal_send == null || $seller == null) {
|
|
return 0;
|
|
}
|
|
if (($this->attributes['user_id'] == $user_id) && ($legal_send->type == 'buy')) {
|
|
return 1;
|
|
} elseif (($legal_send->type == 'sell') && ($user_id == $seller->user_id)) {
|
|
return 1;
|
|
} else {
|
|
return 0;
|
|
}
|
|
}
|
|
|
|
public static function cancelLegalDealById($legal_deal_id,$type = AccountLog::C2C_DEAL_AUTO_CANCEL){
|
|
// DB::beginTransaction();
|
|
try{
|
|
$legal_deal = C2cDeal::find($legal_deal_id);
|
|
$legal_deal_send = C2cDealSend::lockForUpdate()->find($legal_deal->legal_deal_send_id);
|
|
$users_wallet = UsersWallet::where('user_id', $legal_deal->user_id)->lockForUpdate()->where('currency', $legal_deal_send->currency_id)->first();
|
|
if ($legal_deal_send->type == 'buy') { //求购
|
|
// do something
|
|
// if ($users_wallet->legal_balance < $number){
|
|
// DB::rollback();
|
|
// return $this->error('您的法币余额不足');
|
|
// }
|
|
// $legal_deal_send->surplus_number += $legal_deal->number;//
|
|
// $legal_deal_send->surplus_number = bc_add($legal_deal_send->surplus_number,$legal_deal->number,5);//
|
|
// if ($legal_deal_send->surplus_number > 0) {
|
|
// $legal_deal_send->is_done = 0;
|
|
// }
|
|
$legal_deal_send->is_done = 0;
|
|
$data_wallet1 = [
|
|
'balance_type' => 2,
|
|
'wallet_id' => $users_wallet->id,
|
|
'lock_type' => 0,
|
|
'create_time' => time(),
|
|
'before' => $users_wallet->legal_balance,
|
|
'change' => $legal_deal->number,
|
|
'after' => bc_add($users_wallet->legal_balance, $legal_deal->number, 5),
|
|
];
|
|
$data_wallet2 = [
|
|
'balance_type' => 2,
|
|
'wallet_id' => $users_wallet->id,
|
|
'lock_type' => 1,
|
|
'create_time' => time(),
|
|
'before' => $users_wallet->lock_legal_balance,
|
|
'change' => -$legal_deal->number,
|
|
'after' => bc_sub($users_wallet->lock_legal_balance, $legal_deal->number, 5),
|
|
];
|
|
// $users_wallet->legal_balance += $legal_deal->number;
|
|
$users_wallet->legal_balance = bc_add($users_wallet->legal_balance,$legal_deal->number,5);
|
|
// $users_wallet->lock_legal_balance -= $legal_deal->number;
|
|
$users_wallet->lock_legal_balance = bc_sub($users_wallet->lock_legal_balance,$legal_deal->number,5);
|
|
$users_wallet->save();
|
|
$legal_deal_send->save();
|
|
|
|
AccountLog::insertLog(
|
|
[
|
|
'user_id' => $legal_deal->user_id,
|
|
'value' => $legal_deal->number,
|
|
'info' => '取消出售给商家法币,余额增加',
|
|
'type' => $type,
|
|
'currency' => $legal_deal_send->currency_id
|
|
],
|
|
$data_wallet1
|
|
);
|
|
AccountLog::insertLog(
|
|
[
|
|
'user_id' => $legal_deal->user_id,
|
|
'value' => -$legal_deal->number,
|
|
'info' => '取消出售给商家法币,锁定余额减少',
|
|
'type' => $type,
|
|
'currency' => $legal_deal_send->currency_id
|
|
],
|
|
$data_wallet2
|
|
);
|
|
} elseif ($legal_deal_send->type == 'sell') { //出售
|
|
// $legal_deal_send->surplus_number += $legal_deal->number;
|
|
// $legal_deal_send->surplus_number = bc_add($legal_deal_send->surplus_number,$legal_deal->number,5);
|
|
// if ($legal_deal_send->surplus_number > 0) {
|
|
// $legal_deal_send->is_done = 0;
|
|
// }
|
|
$legal_deal_send->is_done = 0;
|
|
$legal_deal_send->save();
|
|
}
|
|
$legal_deal->is_sure = 2;
|
|
$legal_deal->save();
|
|
$legal_deal->update_time = time();
|
|
// DB::commit();
|
|
return true;
|
|
|
|
}catch (\Exception $exception){
|
|
throw new \Exception($exception->getMessage());
|
|
return false;
|
|
}
|
|
|
|
}
|
|
|
|
|
|
}
|