| | |
| | | SELECT
|
| | | *,
|
| | | (select available_balance+frozen_balance from member_wallet_coin where wallet_code='USDT' and member_id = m.id) usdtBalance,
|
| | | (select available_balance+frozen_balance from member_wallet_coin where wallet_code='ROC' and member_id = m.id) rocBalance
|
| | | (select available_balance+frozen_balance from member_wallet_coin where wallet_code='SER' and member_id = m.id) rocBalance
|
| | | FROM
|
| | | member m
|
| | | LEFT JOIN member_authentication a ON m.id = a.member_id
|
| | |
| | | </div>
|
| | | </div>
|
| | | <div class="layui-form-item">
|
| | | <label class="layui-form-label febs-form-item-require">充币ROC:</label>
|
| | | <label class="layui-form-label febs-form-item-require">充币SER:</label>
|
| | | <div class="layui-input-block">
|
| | | <input type="text" name="chargeCoinRoc" minlength="4" maxlength="10" data-th-id="${member.chargeCoinRoc}"
|
| | | lay-verify="range|chargeCoinRoc" autocomplete="off" class="layui-input" readonly>
|