Scribd
Upload
4 views6 pages

BKTTL

Uploaded by

rahulgangji2002
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views6 pages

BKTTL

Uploaded by

rahulgangji2002
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 6

$networkDatas = DB::select(DB::raw("WITH RECURSIVE network_hierarchy AS (

SELECT user_id, parent_user_id, wallet_point


FROM network
WHERE parent_user_id = $uid
UNION ALL
SELECT n.user_id, n.parent_user_id, n.wallet_point
FROM network n
INNER JOIN network_hierarchy nh ON n.parent_user_id = nh.user_id
)
SELECT nh.user_id, nh.parent_user_id, nh.wallet_point, u.name AS
user_name, u.email, u.created_date, u.refferal_code, p.name AS parent_name
FROM network_hierarchy AS nh
JOIN users AS u ON u.id = nh.user_id
LEFT JOIN users AS p ON p.id = nh.parent_user_id"));
echo "<pre>";
print_r($networkDatas);die();

"message": "SQLSTATE[42000]: Syntax error or access violation: 1055 Expression


#1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
'nh.parent_user_id' which is not functionally dependent on columns in GROUP BY
clause; this is incompatible with sql_mode=only_full_group_by (SQL: WITH RECURSIVE
network_hierarchy AS (\r\n SELECT user_id, parent_user_id, wallet_point\
r\n FROM network\r\n WHERE parent_user_id = 116\r\n
UNION ALL\r\n SELECT n.user_id, n.parent_user_id, n.wallet_point\r\n
FROM network n\r\n INNER JOIN network_hierarchy nh ON n.parent_user_id =
nh.user_id\r\n )\r\n SELECT nh.parent_user_id,
nh.wallet_point, COUNT(nh.user_id) AS user_count\r\n FROM
network_hierarchy AS nh\r\n GROUP BY nh.wallet_point\r\n
ORDER BY nh.wallet_point DESC)",

@extends('backend/layout')
@section('container')
@section('page_title','Dashboard')
@section('user_blist','active')
<meta name="csrf-token" content="{{ csrf_token() }}">
<section class="home-section">
<div class="container">
<div class="home-content">
<div class="card">
<div class="card-header"><b>Transfer Account</b></div>
<div class="card-body">
<div class="table-responsive">
<table class="datatable table table-hover
table-bordered" id="withdrawlist">
<thead>
<tr>
<th>User Name</th>
<th>Total Balance</th>
<th>Withdrawn</th>
<th>Balance</th>
<th>Current Request</th>
<th>Status</th>
<th>New Balance</th>
</tr>
</thead>
<tbody>
@foreach($blist as $transaction)
<tr class="border-top border-light">
<td><a style="color:black;"data-
toggle="modal" data-target="#userdetail" href="#" id="{{$transaction->parent_id}}"
class="userdetailsbt">
{{ $transaction->name }}</a></td>
<td>
<a style="color:black;"data-
toggle="modal" data-target="#ttlpnt" href="#" id="{{$transaction->parent_id}}"
class="ttlpoint">
{{$transaction->total_fixed_point}}
</a></td>
<td>
<a style="color:black;"data-
toggle="modal" data-target="#withdrawn" href="#" id="{{$transaction->parent_id}}"
class="withdrawnlist">
{{$transaction->withdrawsum}}
</a>
</td>
<td>{{$transaction->avi_balance}}</td>
<td>{{$transaction->amount}}</td>
<td>
@if($transaction->status == "")
<a style="color:black;"data-
toggle="modal" name="accept" data-target="#accstatusss" href="#"
id="{{$transaction->wid}}" uid="{{$transaction->parent_id}}" amt="{{$transaction-
>amount}}" trdate="{{$transaction->tr_date}}" class="btn btn-success btn-sm
acceptstatuss">
Accept
</a>
<a style="color:black;"data-
toggle="modal" name="reject" data-target="#rejstatusss" href="#"
rejtrdate="{{$transaction->tr_date}}" rejid="{{$transaction->wid}}"
rejuid="{{$transaction->parent_id}}" rejamt="{{$transaction->amount}}" class="btn
btn-danger btn-sm rejectstatuss">
Reject
</a>
@else
<h4>{{$transaction->status}}</h4>
@endif
</td>
<td>{{$transaction->total_bal}}</td>
</tr>
@endforeach
</tbody>

</table>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- user details -->
<div class="modal fade" id="userdetail" tabindex="-1" role="dialog" aria-
hidden="true" data-backdrop="static" data-keyboard="false" >
<div class="modal-dialog modal-lg" >
<div class="modal-content">
<div class="form-group row m-1 modal-header">
<div class="col-sm-10">
<h4 class="modal-title" style="text-align:left;font-
weight:bold">User Details</h4>
</div>
<div class="col-sm-2 text-right">
<button type="button" class="btn btn-secondary fa fa-close
text-right btn btn-danger" style="padding: 1px 3px;" data-dismiss="modal"></button>
</div>
</div>
<div id='user_row' class="modal-body">
<div class="row">

</div>
</div>
</div>
</div>
</div>
<!--witdraw list-->
<div class="modal fade" id="withdrawn" tabindex="-1" role="dialog" aria-
hidden="true" data-backdrop="static" data-keyboard="false" >
<div class="modal-dialog modal-lg" >
<div class="modal-content">
<div class="form-group row m-1 modal-header">
<div class="col-sm-10">
<h4 class="modal-title" style="text-align:left;font-
weight:bold">Withdraw Details</h4>
</div>
<div class="col-sm-2 text-right">
<button type="button" class="btn btn-secondary fa fa-close
text-right btn btn-danger" style="padding: 1px 3px;" data-dismiss="modal"></button>
</div>
</div>
<div id='withdraw_row' class="modal-body">
<div class="row">

</div>
</div>
</div>
</div>
</div>
<!--accept status-->
<div class="modal fade" id="accstatusss" tabindex="-1" role="dialog" aria-
hidden="true" data-backdrop="static" data-keyboard="false" >
<div class="modal-dialog modal-sm" >
<div class="modal-content">
<div class="form-group row m-1 modal-header">
<div class="col-sm-10">
<h4 class="modal-title" style="text-align:left;font-
weight:bold">Withdraw Details</h4>
</div>
<div class="col-sm-2 text-right">
<button type="button" class="btn btn-secondary fa fa-close
text-right btn btn-danger" style="padding: 1px 3px;" data-dismiss="modal"></button>
</div>
</div>
<div id='status_row' class="modal-body">
</div>
</div>
</div>
</div>
<!--reject status-->
<div class="modal fade" id="rejstatusss" tabindex="-1" role="dialog" aria-
hidden="true" data-backdrop="static" data-keyboard="false" >
<div class="modal-dialog modal-sm" >
<div class="modal-content">
<div class="form-group row m-1 modal-header">
<div class="col-sm-10">
<h4 class="modal-title" style="text-align:left;font-
weight:bold">Withdraw Details</h4>
</div>
<div class="col-sm-2 text-right">
<button type="button" class="btn btn-secondary fa fa-close
text-right btn btn-danger" style="padding: 1px 3px;" data-dismiss="modal"></button>
</div>
</div>
<div id='rejstatus_row' class="modal-body">

</div>
</div>
</div>
</div>

<!--total point-->
<div class="modal fade" id="ttlpnt" tabindex="-1" role="dialog" aria-hidden="true"
data-backdrop="static" data-keyboard="false" >
<div class="modal-dialog modal-lg" >
<div class="modal-content">
<div class="form-group row m-1 modal-header">
<div class="col-sm-10">
<h4 class="modal-title" style="text-align:left;font-
weight:bold">Total Point</h4>
</div>
<div class="col-sm-2 text-right">
<button type="button" class="btn btn-secondary fa fa-close
text-right btn btn-danger" style="padding: 1px 3px;" data-dismiss="modal"></button>
</div>
</div>
<div id='ttlpoint_row' class="modal-body">

</div>
</div>
</div>
</div>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<script type="text/javascript">
$(document).on('click', '.userdetailsbt', function() {
var id = $(this).attr("id");
$.get("{{ route('userdetailspop') }}", { id: id }, function(datas) {
$("#user_row").html(datas);
$("#userdetail").appendTo("body").modal('show');
});
});
</script>
<script type="text/javascript">
$(document).on('click', '.withdrawnlist', function() {
var id = $(this).attr("id");
$.get("{{ route('withdrawspop') }}", { id: id }, function(datas) {
$("#withdraw_row").html(datas);
$("#withdrawn").appendTo("body").modal('show');
});
});
</script>
<script type="text/javascript">
$(document).on('click', '.acceptstatuss', function() {
var id = $(this).attr("id");
var uid = $(this).attr("uid");
var amt = $(this).attr("amt");
var name = $(this).attr('name');
var date = $(this).attr('trdate');
$.get("{{ route('statuspops') }}", { id: id, uid: uid,amt:
amt,name:name,date:date }, function(datas) {
$("#status_row").html(datas);
$("#accstatusss").appendTo("body").modal('show');
});
});
</script>
<script type="text/javascript">
$(document).on('click', '.rejectstatuss', function() {
var id = $(this).attr("rejid");
var uid = $(this).attr("rejuid");
var amt = $(this).attr("rejamt");
var name = $(this).attr('name');
var date = $(this).attr('rejtrdate');
$.get("{{ route('statusrejpops') }}", { id: id, uid: uid,amt:
amt,name:name,date:date }, function(datas) {
$("#rejstatus_row").html(datas);
$("#rejstatusss").appendTo("body").modal('show');
});
});
</script>
<script type="text/javascript">
$(document).on('click', '.ttlpoint', function() {
var id = $(this).attr("id");
$.get("{{ route('ttlpoint') }}", { id: id}, function(datas) {
$("#ttlpoint_row").html(datas);
$("#ttlpnt").appendTo("body").modal('show');
});
});
</script>

@endsection

// $todayDate = Carbon::now()->format('Y-m-d');
// $banktr = new TransactionUser;
// $banktr->name = $request['name'];
// $banktr->bacccount = $request['bacccount'];
// $banktr->bankn = $request['bankn'];
// $banktr->accname = $request['accname'];
// $banktr->cbacccount = $request['cbacccount'];
// $banktr->ifsc = $request['ifsc'];
// $banktr->amount = $request['amount'];
// $banktr->total_bal = $request['tbalance'];
// $banktr->avi_balance = $request['tbalance'];
// $banktr->upi = $request['upi'];
// $banktr->parent_id = $patient_id;
// $banktr->tr_date = $todayDate;
// $banktr->withdrawsum =$request['wdamt'];
// $banktr->save();
// return response()->json([
// 'status'=>200,
// 'msg' => "Transaction successfully",
// ]);

You might also like