Untitled
unknown
plain_text
2 years ago
9.0 kB
5
Indexable
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<link
rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css"
/>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<style>
.sidenav {
background-color: #f1f1f1;
height: 100%;
}
/* Set black background color, white text and some padding */
footer {
background-color: #555;
color: white;
padding: 15px;
}
/* On small screens, set height to 'auto' for sidenav and grid */
@media screen and (max-width: 767px) {
.sidenav {
height: auto;
padding: 15px;
}
.row.content {
height: auto;
}
}
p {
margin: 0 0 1px;
}
.adv {
width: 177px;
margin-top: 11%;
}
.border_none {
border: none !important;
font-weight: 600;
}
.text_r {
text-align: right;
}
hr.new3 {
border-top: 1px dotted black;
margin-top: 4px;
margin-bottom: 13px;
}
@media screen and (max-width: 767px) {
.adv {
text-align: center;
width: 177px;
margin-top: 11%;
position: initial;
}
}
@media (min-width: 1200px) {
.container {
width: 1013px;
}
}
.invoice-box {
max-width: 1200px;
padding:0px 10px 20px 10px;
}
tr th{
padding: 5px !important;
}
tr td{
padding: 5px !important;
}
.bold{
font-weight: bold;
}
</style>
</head>
<body>
<div class="invoice-box" style="position: relative;">
<img src="https://i.ibb.co/rQSn8Hs/watermark.png" alt="" style="width: 30%;position: absolute;opacity: 0.15;left:50%; transform:translateX(-50%);">
<div class="row">
<div class="col-sm-3">
<img
src="https://i.ibb.co/kyYX5BQ/black-logo-transparent.png"
class="adv"
/>
</div>
<div class="col-sm-6 text-center">
<h4 style="font-weight: 600">GAINN FINTECH PVT.LTD</h4>
<p>
915, The Summit Business Bay, Behind Guru Nanak Petrol Pump, Andheri (East) , Mumbai - 400069
</p>
<p>Tel No.: 22-61206160 Email: compliance@gainn.co.in</p>
<p>Compliance Officer: Rajesh Kumar</p>
<p><b><%= report_name %> (F&O) from <%= from_date %> to <%= to_date %></5></b></p>
</div>
<div class="col-sm-3"></div>
</div>
<hr class="new3" />
<div class="row">
<div class="col-sm-12">
<!--<p style="font-weight: 600">Schedule [Client Accounts]</p>-->
<p style="font-weight: 600">
Account: <%= clientDetails.ClientName %>
</p>
<p>
<% let Address=`${clientDetails.PerAddress1}`+" "+`${clientDetails.PerAddress2}`+" "+`${clientDetails.PerAddress3}`+" "+`${clientDetails.PerState}`+" "+`${clientDetails.PerPincode}`; %>
<span style="font-weight: 600"> Address: </span><%= Address %>
</p>
</div>
</div>
<%
function dateFormatter(dateString){
const year = dateString.substr(0, 4);
const month = dateString.substr(4, 2);
const day = dateString.substr(6, 2);
const months = [
'January', 'February', 'March', 'April', 'May', 'June', 'July',
'August', 'September', 'October', 'November', 'December'
];
const monthName = months[parseInt(month, 10) - 1];
return `${day}-${monthName}-${year}`;
}
%>
<div class="row" style="margin-top: 20px">
<div class="col-sm-12">
<div class="table-responsive">
<table class="table table-bordered">
<thead style="font-size: 10px;">
<tr>
<th>ScripName</th>
<th width = "100px">Date</th>
<th class="text_r">Bought</th>
<th class="text_r">Sold</th>
<th class="text_r">NetRate</th>
<th class="text_r">Mkt.Rate</th>
<th class="text_r">NetValue</th>
<th class="text_r">Brokerage</th>
<th class="text_r" width = "100px">Brokerage Amt</th>
<th>OrderID</th>
<th>TradeID</th>
<th>TradeTime</th>
<th class="text_r" width = "100px">Brkg %</th>
</tr>
</thead>
<tbody style="font-size: 10px;">
<%
let tradeData=data[0];
let data1=Object.keys(tradeData);
for(let i=0;i<data1.length;i++){%>
<tr>
<td colspan="13"><%= dateFormatter(data1[i]) %></td>
<%
let trade2=tradeData[data1[i]];
console.log(trade2[0])
for(let j=0;j<trade2.length;j++){
let net_rate = 0;
if (trade2[j].SellQty == 0.0) {
net_rate = trade2[j].BuyRate;
} else {
net_rate = trade2[j].SellRate;
}
let brokerage_qty = 0;
if (trade2[j].Sell == 0.0) {
net_rate = trade2[j].BuyRate;
brokerage_qty = trade2[j].buy;
} else {
net_rate = trade2[j].SellRate;
brokerage_qty = trade2[j].Sell;
}
let brokerage = 0;
if (net_rate > trade2[j].td_marketrate) {
brokerage = net_rate - trade2[j].td_marketrate;
} else {
brokerage = trade2[j].td_marketrate - net_rate;
}
let brokerage_per = 0;
brokerage_per = (brokerage / net_rate) * 100;
let brokerage_amt = brokerage * brokerage_qty;
%>
<tr>
<td><%= trade2[j].scripname %></td>
<td><%= dateFormatter(trade2[j].trdDate) %></td>
<td class="text_r"><%= trade2[j].buy %></td>
<td class="text_r"><%= trade2[j].Sell %></td>
<td class="text_r"><%= net_rate %></td>
<td class="text_r"><%= trade2[j].td_marketrate %></td>
<td class="text_r"><%= trade2[j].NetAmount %></td>
<td class="text_r"><%= brokerage %></td>
<td class="text_r"><%= brokerage_amt %></td>
<td><%= trade2[j].orderid %></td>
<td><%= trade2[j].tradeid %></td>
<td><%= trade2[j].trdtime %></td>
<td class="text_r"><%= brokerage_per %></td>
</tr>
<% } %>
</tr>
<%}%>
</tbody>
</table>
</div>
</div>
</div>
<%
const currentDate = new Date();
const options = { year: 'numeric', month: 'numeric', day: 'numeric', hour: 'numeric', minute: 'numeric', second: 'numeric', hour12: true, timeZone: 'Asia/Kolkata' };
const formattedDateTime = currentDate.toLocaleString('en-US', options);
%>
<div style="padding-top: 1.5rem;padding-bottom: 1.5rem;display: flex;align-items: right;justify-content: right;">
<h3 style="font-size:9px;margin: 0;">Report Generated On <%= formattedDateTime %></h3>
</div>
<div style="padding-top: 1rem;padding-bottom: 1.5rem;display: flex;align-items: center;justify-content: center;">
<h3 style="font-size:9px;margin: 0;">---------------------------- END OF REPORT ----------------------------</h3>
</div>
</div>
</body>
</html>
Editor is loading...