Notes

@{
ViewBag.Title = "SMX Services Consulting - Commissions Table for Salaried Employee";
Layout = "~/Views/Shared/_Layout.cshtml";
}
@model SMXServicesConsulting.DataModel.Models.HourlyCommissionCompanyGroupMasterModel;
<style>
.company-footer td {
background-color: lightgrey;
font-weight: bold;
}
</style>
<div class="p-3 payroll">
<div class="top-head d-flex align-items-center justify-content-between">
<div class="col-lg-2 px-2" style="margin-left: -10px">
<h2><strong>Commission Table</strong></h2>
</div>
<div class="col-lg-10 p-0">
<div class="buttons text-end">
<label for="HoursCommissionManagerName">Select manager to generate PDF:</label>
@Html.DropDownListFor(model => model.ManagerList, new SelectList(Model.ManagerList?.Items, "Value", "Text"), "--- Please Choose ---", new { @id = "ManagerCommissionsBtnSubmit", @class = "m-2 rounded-2 p-2", @style="background-color:#080248; color:white;"})
<button class="m-2 rounded-2 p-2" id="openExcelForManagerCommissions" style="background-color:#080248; color:white;">Export to Excel</button>
</div>
</div>
</div>
<div class="card-section ">
<div class="">
<form asp-controller="" asp-action="" id="form">
<div class="col-md-12">
<div class="row ">
<h5>FOR MONTHLY:</h5>
<div class="col-lg-2">
<label for="">Start Date</label><span style="color:red">*</span><br>
<input type="date" class="form-control twice-week date" id="HoursStartDateForCommission" name="HoursStartDateForCommission" placeholder="mm-dd-yyyy">
<span id="HoursStartDateForCommissionError" class="Error"></span>
</div>
<div class="col-lg-2">
<label for="employeeId">End Date</label><span style="color:red">*</span><br>
<input type="date" class="form-control twice-week date" id="HoursEndDateForCommission" name="HoursEndDateForCommission" placeholder="mm-dd-yyyy">
<span id="HoursEndDateForCommissionError" class="Error"></span>
</div>
<div class="col-lg-3">
<div>
<label for="HoursCommissionCompanyName">Company Name</label><span style="color:red">*</span>
</div>
<div>
@Html.DropDownListFor(model => model.CompanyList, new SelectList(Model.CompanyList?.Items, "Value", "Text"), new { @id = "HoursCommissionCompanyName", @class = "form-select twice-week date", @required = "true" })
<span id="HoursCommissionCompanyNameError" class="Error"></span>
</div>
</div>
<div class="col-lg-3">
<button type="button" id="ManagersCommissionBtnSubmit" class="btn btn-primary border-0 " style="background-color:#080248; margin-top: 25px;">Submit</button>
</div>
</div>
</div>
</form>
</div>
</div>
<div class="spinner" style="display:none">
<div class="center-div">
<div class="inner-div">
<div class="loader"></div>
</div>
</div>
</div>
<div class="costosTable-outer mx-0 mt-3 clsDivCommissionListForManagers">
<div class="table-responsive">
<table id="getEmployeetbl" class="table table-striped position-relative" style="width:100%">
<thead>
<tr>
<th>Customer</th>
<th>ITEM</th>
<th>Form</th>
<th>Variable Hours</th>
<th>Quantity</th>
<th>Price</th>
<th>Amount</th>
<th>Service Date</th>
<th>Cost/Total</th>
<th>Margen</th>
<th>Coef. 5%</th>
@if (Model.ManagerLists != null)
{
@foreach (var manager in Model.ManagerLists)
{
<th>@manager.Name</th>
}
}
</tr>
</thead>
<tbody>
@if (Model.HourlyCommissionCompanyGroupModelList != null)
{
@foreach (var companyGroup in Model.HourlyCommissionCompanyGroupModelList)
{
@if (companyGroup.HourlyCommissionModel != null)
{
@foreach (var item in companyGroup.HourlyCommissionModel)
{
<tr>
<td>@item.Customer</td>
<td>@item.ITEM</td>
<td>@item.Form</td>
<td>@item.VariableHours</td>
<td>@item.QuantityTotalHours</td>
<td style="text-align:center">@item.PriceBillRate</td>
<td>@item.Amount</td>
<td>@item.ServiceDate</td>
<td>@item.CostTotal</td>
<td>@item.Margen</td>
<td>@item.Coeff5Percent</td>
@if (Model.ManagerLists != null)
{
@foreach (var manager in Model.ManagerLists)
{
<td>

</td>
}
}
</tr>
}
<tr class="company-footer" data-company="@companyGroup.Customer">
<td>@companyGroup.Customer</td>
<td>@companyGroup.EmployeeCount</td>
<td></td>
<td>@companyGroup.TotalVariableHours</td>
<td>@companyGroup.TotalQuantityHours</td>
<td>@companyGroup.TotalPriceBillRate.ToString("C")</td>
<td>@companyGroup.TotalAmount.ToString("C")</td>
<td></td>
<td>@companyGroup.TotalCostTotal.ToString("C")</td>
<td>@companyGroup.TotalMargen.ToString("C")</td>
<td>@companyGroup.TotalCoeff5Percent.ToString("C")</td>
@if (Model.ManagerLists != null)
{
@foreach (var manager in Model.ManagerLists)
{
<td>

</td>
}
}
</tr>
}
}
}
</tbody>
</table>
</div>
</div>
</div>
<div class="modal openExcelPopupCommissionForManagers" role="dialog" tabindex="-1" aria-labelledby="gridSystemModalLabel" data-bs-backdrop="static" data-bs-keyboard="false" style="padding-top: 180px;">
</div>
<div class="modal openPopupCommissionForManagers" role="dialog" tabindex="-1" aria-labelledby="gridSystemModalLabel" data-bs-backdrop="static" data-bs-keyboard="false" style="padding-top: 60px;">
</div>
<script src="~/js/site.js"></script>
<script src="~/lib/jquery/dist/jquery.js"></script>
<script src="~/lib/jquery/dist/jquery.min.js"></script>
<script src="~/cdnjs/jquery-3-7-0.js"></script>
<script src="~/cdnjs/jquery-datatables.js"></script>
<script src="~/cdnjs/datatables-bootstrap5.js"></script>
<script src="~/cdnjs/datatables-fixedcolumns.js"></script>
<script src="~/js/hourlycommission.js"></script>
<script>
$('#getEmployeetbl').DataTable({
fixedColumns: {
left: 2
},
paging: true,
"pageLength": 50,
"order": [],
searching: true,
"bSort": false,
responsive: true

});
</script>