Member Information
<% for(var i=0; i < customers_profile.length; i++) { %> <% if(customers_profile[i].status !="active" ){%> <%= customers_profile[i].status %> <% }else{%> <%= customers_profile[i].status %> <% }%> Registered On : <% var rawDate=new Date(customers_profile[i].member_date); var formattedDate=rawDate.toLocaleDateString(); %> <%= formattedDate %>Transaction from this user
<%= allTransaction[i].date %>
<%= allTransaction[i].type %>
<% if(allTransaction[i].status=="approved" ){ %> <%= allTransaction[i].status %> <% } else if (allTransaction[i].status=="pending" ){ %> <%= allTransaction[i].status %> <% } else{ %> <%= allTransaction[i].status %> <% } %>
Amount = RM <%= allTransaction[i].amount %>
Game : <%= allTransaction[i].products %>
<%= allTransaction[i].date %>
From <%= allTransaction[i].products_from %> to <%= allTransaction[i].products_to %>
<% if(allTransaction[i].status=="approved" ){ %> <%= allTransaction[i].status %> <% } else if (allTransaction[i].status=="pending" ){ %> <%= allTransaction[i].status %> <% } else{ %> <%= allTransaction[i].status %> <% } %>
Amount = RM <%= allTransaction[i].amount %>
<%= allTransaction[i].date %>
Cash Bonus
<% if(allTransaction[i].status=="Approved" ){ %> <%= allTransaction[i].status %> <% } else if (allTransaction[i].status=="pending" ){ %> <%= allTransaction[i].status %> <% } else{ %> <%= allTransaction[i].status %> <% } %>
Amount = RM <%= allTransaction[i].amount %>
Game : <%= allTransaction[i].product %>
<%= allTransaction[i].date %>
<% if(allTransaction[i].type=="deposit" ){ %> <%= allTransaction[i].type %> <% } else{ %> <%= allTransaction[i].type %> <% } %>
<% if(allTransaction[i].status=="approved" ){ %> <%= allTransaction[i].status %> <% } else if (allTransaction[i].status=="pending" ){ %> <%= allTransaction[i].status %> <% } else{ %> <%= allTransaction[i].status %> <% } %>
Amount = RM <%= allTransaction[i].amount %>
Game : <%= allTransaction[i].products %>
Total : <%= (allTransaction[i].amount + allTransaction[i].bonus_amount).toFixed(2) %>
Bonus Used: <%= allTransaction[i].cashbonus %>
<% if(allTransaction[i].cashbonus !="No Bonus" ){ %>TurnOver = <%= ((allTransaction[i].amount + allTransaction[i].bonus_amount) * allTransaction[i].multiply).toFixed(2) %>
<% }else{ %>TurnOver = <%= ((allTransaction[i].amount + allTransaction[i].bonus_amount) * allTransaction[i].multiply).toFixed(2) %>
<% } %>Transaction Record Of MS<%= customers_profile[0].username %>
Total Deposit: | <% if (TotalTrans[0].type !='deposit' ){ %>No deposit yet! | <% } else{%><%= TotalTrans[0].Total_trans.toFixed(2) %> | <% }%>
---|---|---|
Total Withdrawal: | <% if (TotalTrans[1].type !='withdrawal' ){ %>No withdrawal yet! | <% } else{%><%= TotalTrans[1].Total_trans.toFixed(2) %> | <% }%>
Total Different: | <%= (TotalTrans[0].Total_trans - TotalTrans[1].Total_trans).toFixed(2) %> |
ID | Ref | Date & Time | Member | Product | Bank | Amount | Bonus Amount | TurnOver | Promo | Status |
---|---|---|---|---|---|---|---|---|---|---|
<%= trans_record[i].trans_id %> |
<%= "DP" + moment(trans_record[i].date).format('YMMDD') + trans_record[i].trans_id %> | <%= trans_record[i].date %> | MS<%= trans_record[i].customer %> | <%= trans_record[i].products %> | <%= trans_record[i].bank %> | <%= trans_record[i].amount %> | <%= trans_record[i].bonus_amount %> | <% if( trans_record[i].bonus_amount !="0" ){ %> <%= ((trans_record[i].amount + trans_record[i].bonus_amount) * trans_record[i].multiply).toFixed(2) %> <% }else { %> No Claim <% } %> | <%= trans_record[i].cashbonus %> |
<% if( trans_record[i].status=='approved' ){ %>
<%= trans_record[i].status %>
<% } else{ %>
<%= trans_record[i].status %>
<% } %>
|
ID | Ref | Date & Time | Customer | Amount | Product | Bank | Status |
---|---|---|---|---|---|---|---|
<%= withdrawTrans[j].trans_id %> |
<%= "WD" + moment(withdrawTrans[j].date).format('YMMDD') + withdrawTrans[j].trans_id %> | <%= withdrawTrans[j].date %> | MS<%= withdrawTrans[j].customer %> | <%= withdrawTrans[j].amount %> | <%= withdrawTrans[j].products %> | <%= withdrawTrans[j].bank %> |
<% if(withdrawTrans[j].status=='approved' ){ %>
<%= withdrawTrans[j].status %>
<% } else{ %>
<%= withdrawTrans[j].status %>
<% } %>
|
Credit Transfer Record
|
|
From Date : | To Date : |
ID | Ref | Date & Time | Customer | Amount | From Product | To Product | User In Charge | Status |
---|---|---|---|---|---|---|---|---|
<%= creditTrans[i].id %> |
<%= "CT" + moment(creditTrans[i].date).format('YMMDD') + creditTrans[i].id %> | <%= creditTrans[i].date %> | MS<%= creditTrans[i].customer %> | <%= creditTrans[i].amount %> | <%= creditTrans[i].products_from %> | <%= creditTrans[i].products_to %> | <%= creditTrans[i].manager %> |
<% if(creditTrans[i].status=='approved' ){ %>
<%= creditTrans[i].status %>
<% } else{ %>
<%= creditTrans[i].status %>
<% } %>
|
Cash Bonus Record
|
||
From Date : | To Date : |
No | Ref | Date & Time | Member | Product | Amount | Remark | Status |
---|---|---|---|---|---|---|---|
<%= cashBonusTrans[i].id %> |
<%= cashBonusTrans[i].cb_ref %> | <%= cashBonusTrans[i].cb_date %> | MS <%= cashBonusTrans[i].customer %> | <%= cashBonusTrans[i].product %> | <%= cashBonusTrans[i].amount.toFixed(2) %> | <%= cashBonusTrans[i].remark %> |
<% if(cashBonusTrans[i].status=='Approved' ){ %>
<%= cashBonusTrans[i].status %>
<% } else{ %>
<%= cashBonusTrans[i].status %>
<% } %>
|