258 lines
16 KiB
Plaintext
258 lines
16 KiB
Plaintext
@model IEnumerable<GODATA.Models.Report.ConsolidatedReportModel>
|
|
@if (Model != null && Model.Count() > 0)
|
|
{
|
|
<div class="DInv_Tbl_Wrapper CloseTicketWrapper">
|
|
<style>
|
|
tr[aria-selected="true"] td>a>span { color: #fff;}
|
|
</style>
|
|
@(Html.Kendo().Grid<GODATA.Models.Report.ConsolidatedReportModel>(Model)
|
|
.Name("ConsolidatedGrid")
|
|
|
|
.Columns(columns =>
|
|
{
|
|
columns.Bound(column => column.ticket_id).Title("Ticket Id").Hidden();
|
|
columns.Bound(column => column.ticketid_alias).Title("Ticket Id");
|
|
columns.Bound(column => column.call_assigned_to).Title("Assigned To");
|
|
columns.Bound(column => column.created_by).Title("Created By");
|
|
columns.Bound(column => column.creation_time).Title("Creation Time").Filterable(false);
|
|
columns.Command(command => command.Custom("TimeSlot").Text("")).Title("Time Slot").HtmlAttributes(new { @class = "removeLink"});
|
|
columns.Bound(column => column.customer_name).Title("Customer Name");
|
|
columns.Bound(column => column.customer_contact_no).Title("Customer Contact No.");
|
|
columns.Bound(column => column.organization).Title("Organization");
|
|
columns.Bound(column => column.state).Title("State");
|
|
columns.Bound(column => column.city).Title("City");
|
|
columns.Bound(column => column.language_name).Title("Language");
|
|
columns.Bound(column => column.owner_name).Title("Vehicle Owner Name");
|
|
columns.Bound(column => column.owner_contact_number).Title("Vehicle Owner Contact No.");
|
|
columns.Bound(column => column.customer_vehicle_regn_no).Title("Vehicle Reg No.");
|
|
columns.Bound(column => column.chassis_number).Title("Chassis Number");
|
|
columns.Bound(column => column.vehicle_name).Title("Vehicle Model");
|
|
columns.Bound(column => column.product_variant_name).Title("Product variant");
|
|
columns.Bound(column => column.vehicle_type).Title("Vehicle Type");
|
|
//columns.Bound(column => column.chassis_number).Title("Vehicle Chassis No.");
|
|
columns.Bound(column => column.vehicle_instalation_date).Title("Vehicle Installation Date").Filterable(false);
|
|
columns.Bound(column => column.breakdown_location).Title("Vehicle Breakdown Location");
|
|
columns.Bound(column => column.landmark).Title("Landmark");
|
|
columns.Bound(column => column.warranty).Title("Warranty");
|
|
columns.Bound(column => column.how_did_you_come_to_know_of_eos).Title("Source of Toll Free No.");
|
|
columns.Bound(column => column.type_of_load_carried).Title("Type of Load Carrying");
|
|
columns.Bound(column => column.nature_of_problem).Title("Nature of Problem");
|
|
columns.Bound(column => column.estimated_cost_string).Title("Estimated Cost");
|
|
columns.Bound(column => column.estimated_time_string).Title("Estimated Time(In Min)");
|
|
columns.Bound(column => column.dealer_code).Title("Dealer SCode");
|
|
columns.Bound(column => column.dealer_name).Title("Dealer Name");
|
|
columns.Bound(column => column.wm_name).Title("WM Name");
|
|
columns.Bound(column => column.dealer_contact_no).Title("Dealer Contact No.");
|
|
columns.Bound(column => column.eos_team_member_and_van).Title("EOS VAN Registration Number");
|
|
columns.Bound(column => column.open_call_hrs).Title("Call Open (HH:MM:SS)");
|
|
|
|
columns.Bound(column => column.time_stamps_status_2).Title("Ticket Accepted").Filterable(false);
|
|
columns.Bound(column => column.time_stamps_status_3).Title("Van Reached").Filterable(false);
|
|
columns.Bound(column => column.time_stamps_status_4).Title("Call Preclosed").Filterable(false);
|
|
columns.Bound(column => column.time_stamps_status_5).Title("Call Closure").Filterable(false);
|
|
|
|
columns.Bound(column => column.escalation_level_van_not_move_1).Title("Escalation - Van Not Moving");
|
|
//columns.Command(command => command.Custom("Escalation").Text("")).Title("Escalation - Van Not Moving").HtmlAttributes(new { @class = "removeLink" });
|
|
|
|
columns.Bound(column => column.escalation_level_ticket_closer_1).Title("Escalation - Ticket Closure");
|
|
//columns.Command(command => command.Custom("EscalationTicketClose").Text("")).Title("Escalation - Ticket Closure").HtmlAttributes(new { @class = "removeLink" });
|
|
|
|
columns.Bound(column => column.call_closure_status).Title("Call Closed < 24 Hrs");
|
|
columns.Bound(column => column.KmCovered).Title("KM Covered Breakdown's Vehicle");
|
|
columns.Bound(column => column.feedback_taken).Title("Feedback");
|
|
columns.Bound(column => column.feedback_ease_of_getting_call).Title("Feedback Score - Ease of Getting Call Centre");
|
|
columns.Bound(column => column.feedback_response_of_call_center).Title("Feedback Score - Response of Call Centre");
|
|
columns.Bound(column => column.feedback_timely_updation_by_dealer).Title("Feedback Score - Timely Updation by Dealer");
|
|
columns.Bound(column => column.feedback_total_repair_time).Title("Feedback Score - Total Repair Time");
|
|
columns.Bound(column => column.feedback_eos_charges).Title("Feedback Score - EOS Charges");
|
|
columns.Bound(column => column.feedback_over_all_experience).Title("Feedback Score - Over All Experience");
|
|
columns.Bound(column => column.closure_remarks).Title("Closure Remarks");
|
|
columns.Bound(column => column.response_string).Title("Response(In min)");
|
|
columns.Bound(column => column.feedback_count).Title("Feedback Count");
|
|
columns.Bound(column => column.call_status).Title("Feedback Call Status");
|
|
columns.Bound(column => column.suggestion).Title("Feedback Suggestions").Encoded(false);
|
|
columns.Bound(column => column.complaints).Title("Feedback Complaints").Encoded(false);
|
|
columns.Bound(column => column.feedback_agent).Title("Feedback Agent");
|
|
columns.Bound(column => column.other_remarks).Title("Reason for Ticket assigned to Dealer");
|
|
columns.Bound(column => column.DealerTicketOtherRemark).Title("Other Reason for Ticket assigned to Dealer");
|
|
columns.Bound(column => column.estimated_distance).Title("Estimated Distance (In KM)");
|
|
columns.Bound(column => column.van_covered_distance).Title("EOS Van Actual Distance Traveled (In KM)");
|
|
columns.Bound(column => column.trip_start_time).Title("EOS Van Trip Start Time");
|
|
columns.Bound(column => column.trip_end_time).Title("EOS Van Trip End Time");
|
|
//columns.Bound(column => column._call_closed_within_24_hours).Title("Call closed within 24 hours");
|
|
columns.Bound(column => column._eicher_promise).Title("Eicher Promise");
|
|
columns.Bound(column => column.opportunity_loss).Title("Opportunity Loss");
|
|
columns.Bound(column => column.opportunity_loss_remark).Title("Opportunity Loss Reason");
|
|
columns.Bound(column => column.opportunity_lost_remarks).Title("Opportunity Loss Remark");
|
|
columns.Bound(column => column.remark_ticket_not_closed_24_hours).Title("Delayed Reason");
|
|
columns.Bound(column => column.remark_ticket_not_closed_24_hours_remarks).Title("Delayed Remark");
|
|
columns.Bound(column => column.reopen_count).Title("Reopen Count");
|
|
|
|
columns.Bound(column => column.OdometerReading).Title("Odometer Reading");
|
|
//to show last reassignment time
|
|
columns.Bound(column => column.last_Updated_Time).Title("Reassignment Date and Time").Filterable(false);
|
|
|
|
//added on 23-12-2020 start
|
|
//columns.Bound(column => column.van_reached_punch_time).Title("Van Reached Punch Time");
|
|
|
|
//added on 23-12-2020 end
|
|
|
|
//to show Customer feedback(Cr on hold for production movement)
|
|
//columns.Bound(column => column.are_you_satisfied).Title("Overall Customer Satisfied").Filterable(false);
|
|
//columns.Bound(column => column.not_satisfied_option).Title("Reason for dissatisfaction").Filterable(false);
|
|
//columns.Bound(column => column.not_satisfied_reason).Title("Feedback Comments").Filterable(false);
|
|
columns.Bound(column => column.response_time_reassignment).Title("Response time(Reassignment)").Filterable(false);
|
|
//added on
|
|
columns.Bound(column => column.vehicle_warranty).Title("Vehicle Warranty").Filterable(false); ;
|
|
columns.Bound(column => column.vehicle_amc).Title("Vehicle Amc").Filterable(false); ;
|
|
columns.Bound(column => column.vehicle_emission_norms).Title("Vehicle Emission Norms").Filterable(false); ;
|
|
columns.Bound(column => column.vehicle_sales_date).Title("Vehicle Sales Date").Filterable(false); ;
|
|
|
|
|
|
//added on 25-11-2020 start
|
|
columns.Bound(column => column.ticket_closed_reason).Title("Ticket closed reason");
|
|
//added on 25-11-2020 end
|
|
columns.Bound(column => column.escalation_level_van_not_move_6).Title("Location Assigment Time ");
|
|
columns.Bound(column => column.escalation_level_van_not_move_2 ).Title("Is location change");
|
|
columns.Bound(column => column.escalation_level_van_not_move_3).Title("Dealer change reason");
|
|
columns.Bound(column => column.escalation_level_van_not_move_4).Title("Dealer change reason other remark");
|
|
columns.Bound(column => column.escalation_level_van_not_move_5).Title("Vehicle status");
|
|
|
|
//columns.Bound(column => column.estimated_distance).Title("Estimated Distance");
|
|
//columns.Bound(column => column.van_covered_distance).Title("EOS Van Actual Distance Travelled (In KM)");
|
|
//columns.Bound(column => column.trip_start_time).Title("EOS Van Trip Start Time");
|
|
//columns.Bound(column => column.trip_end_time).Title("EOS Van Trip End Time");
|
|
|
|
|
|
columns.Bound(column => column.time_slot).Hidden();
|
|
columns.Bound(column => column.total_inbound_calls).Hidden();
|
|
columns.Bound(column => column.total_outbound_calls).Hidden();
|
|
columns.Bound(column => column.region).Title("Region").Hidden();
|
|
columns.Bound(column => column.load_carried).Title("Load Carried").Hidden();
|
|
columns.Bound(column => column.default_sla_time).Hidden();
|
|
columns.Bound(column => column.time_stamps_status_1).Title("Van Start").Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_2).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_3).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_4).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_5).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_6).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_7).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_8).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_9).Hidden();
|
|
columns.Bound(column => column.escalation_level_van_not_move_10).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_2).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_3).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_4).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_5).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_6).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_7).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_8).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_9).Hidden();
|
|
columns.Bound(column => column.escalation_level_ticket_closer_10).Hidden();
|
|
columns.Bound(column => column.feedback_parameter_wise_score).Hidden();
|
|
columns.Bound(column => column.month_name).Title("Month").Hidden();
|
|
|
|
//columns.Command(command => command.Custom("feedback").Text("")).Title("Closure within 24 Hrs<br/> and Feedback").HtmlAttributes(new { @class = "removeLink" });
|
|
//columns.Command(command => command.Custom("feedbackDetails").Text("")).Title("Feedback").HtmlAttributes(new { @class = "removeLink" }).Hidden();
|
|
//columns.Command(command => command.Custom("reason24Hrs").Text("")).Title("Closure after 24 Hrs").HtmlAttributes(new { @class = "removeLink" }).Hidden();
|
|
})
|
|
.Pageable()
|
|
.Selectable()
|
|
.Scrollable()
|
|
//.Navigatable()
|
|
// .Sortable()
|
|
.EnableCustomBinding(true)
|
|
// .Groupable()
|
|
.Filterable()
|
|
|
|
.Resizable(resize => resize.Columns(true))
|
|
.Events(events => events.DataBound("onRowBound").ColumnResize("onColumnResize"))
|
|
.DataSource(dataSource => dataSource
|
|
.Ajax()
|
|
.Batch(true)
|
|
|
|
.PageSize((int)ViewBag.pageSize)
|
|
.Read(read => read.Action("ConsolidatedReport_Pager", "Report", new { userId = ViewBag.userId, startDate = ViewBag.startDate, endDate = ViewBag.endDate, total = ViewBag.total, organization = ViewBag.organization, vehicleTagging = ViewBag.vehicleTagging }))
|
|
.Total((int)ViewBag.total)
|
|
//.ServerOperation(false)
|
|
//.Events(events => events.Error("error_handler"))
|
|
)
|
|
//.Events(events => events.DataBound("setPagerAndGroupBarWidth"))
|
|
)
|
|
</div>
|
|
}
|
|
else
|
|
{
|
|
<div id="divmessage" class="no_data">
|
|
<span>
|
|
<p class="fs16">@*No Data Available !!!*@
|
|
@System.Configuration.ConfigurationManager.AppSettings["no_data_available"].ToString()
|
|
</p>
|
|
</span>
|
|
</div>
|
|
}
|
|
<script>
|
|
function dataBound(e) {
|
|
|
|
}
|
|
</script>
|
|
<style>
|
|
.slaMet {
|
|
box-shadow: 4px 0px 0px green inset;
|
|
}
|
|
|
|
.slaNotMet {
|
|
box-shadow: 4px 0px 0px red inset;
|
|
}
|
|
|
|
.removeLink a {
|
|
cursor: default;
|
|
color: black;
|
|
}
|
|
|
|
#ConsolidatedGrid table th {
|
|
width: 120px;
|
|
}
|
|
|
|
#ConsolidatedGrid table td {
|
|
width: 121px;
|
|
}
|
|
|
|
.k-grid td:nth-child(52), .k-grid td:nth-child(51) {
|
|
text-align: left !important; width: 400px !important;
|
|
}
|
|
|
|
.k-grid th:nth-child(51), .k-grid th:nth-child(52) {
|
|
text-align: left !important; width: 400px !important;
|
|
}
|
|
|
|
.k-loading, .k-loading-image {
|
|
position: fixed; /* Sit on top of the page content */
|
|
width: 100%; /* Full width (cover the whole page) */
|
|
height: 100%; /* Full height (cover the whole page) */
|
|
top: 0;
|
|
left: 0;
|
|
right: 0;
|
|
bottom: 0;
|
|
background-color: rgba(204, 204, 204, 0.5); /* Black background with opacity */
|
|
z-index: 2; /* Specify a stack order in case you're using a different order for other elements */
|
|
cursor: pointer; /* Add a pointer on hover */
|
|
}
|
|
|
|
.k-loading-image {
|
|
background-image: none;
|
|
}
|
|
.highlighted-row {
|
|
background-color: #FF0000;
|
|
}
|
|
|
|
|
|
/*#Consolidated table th:nth-child(50), #Consolidated table th:nth-child(49) {
|
|
width: 700px !important;
|
|
}
|
|
|
|
#Consolidated table td:nth-child(50), #Consolidated table th:nth-child(49) {
|
|
width: 700px !important;
|
|
}*/
|
|
</style>
|