@php
$page_name = 'Company Calculation';
@endphp
@php
    $currentDateTime = new DateTime();
    $nineThirty = new DateTime('9:30');

    // If the current time is less than 9:30 AM, subtract one day
    if ($currentDateTime < $nineThirty) {
        $dateToShow = $currentDateTime->modify('-1 day')->format('Y-m-d');
    } else {
        $dateToShow = $currentDateTime->format('Y-m-d');
    }
@endphp
@include('partial.header')
<div class="container-fluid">
	@include('partial.navigation')
	<div class="main-container">
		<!-- Content wrapper start -->
		<div class="content-wrapper p-0">

			<div class="table-container">
				<table class="table" style="margin-bottom: 0px !important;">
					<tbody>
						<tr>
							<td style="width:25px;">
								<a onclick="window.history.back()" href="#" data-toggle="dropdown" aria-haspopup="true">
									<i style="font-size:24px;" class="icon-keyboard_backspace"></i>
								</a>
							</td>
							<td style="width:250px;">
								<h5 class="table-title">Company Calculation</h5>
							</td>
							<td style="width:180px;" id="ShiftCombo"></td>
							<td style="width:150px;" id="ShiftDatePanel"><b class="form-control form-control-sm"></b></td>
							<td style="width: 100px;" class="text-right"><b>AMT LESS</b></td>
							<td style="width: 120px;">
								<input id="MainJantriAmount" class="form-control form-control-sm" type="text" placeholder="AMT">
							</td>
							<td style="width: 80px;" class="text-right"><b>% LESS</b></td>
							<td style="width: 100px;">
								<input id="MainJantriPercentage" class="form-control form-control-sm" maxlength="2" type="text" placeholder="%">
							</td>
							<td style="width: 60px; display:none;" class="text-right"><b>UP</b></td>
							<td style="width: 100px; display:none;">
								<input id="MainJantriMultiplyUp" class="form-control form-control-sm" maxlength="3" type="text" placeholder="">
							</td>

							<td style="width:150px;">
								<button class="btn btn-success btn-block" onclick="getMainJantri()">Search <span id="ajax_loader"></span></button>
							</td>
							<td></td>

						</tr>
					</tbody>
				</table>
				<!--****************** Vertical Scroll table start ************************-->
				<div class="table-container pt-2">

					<ul class="nav nav-tabs" id="myTab" role="tablist">
						<li class="nav-item">
							<a class="nav-link active" id="main-tab" data-toggle="tab" href="#main" role="tab" aria-controls="home" aria-selected="true">Main</a>
						</li>
						<li class="nav-item">
							<a class="nav-link" id="fanter-tab" data-toggle="tab" href="#fanter" role="tab" aria-controls="home" aria-selected="true">Fanter Calc</a>
						</li>
					</ul>
					<div class="tab-content p-1" id="myTabContent">

						<div class="tab-pane fade active show" id="main" role="tabpanel" aria-labelledby="main-tab">

							<table style="width:99.9%;" class="table">
								<tbody>
									<tr>
										<td class="p-0" style="width:90%;">
											<div class="table-responsive table2excel CustomFixedTbl" style="min-height:75vh; max-height:75vh; ">
												<table style="width:99.9%;" class="table table-bordered">
													<thead>
														<tr style="border-top:1px solid #DDD;">
															<th>MAIN JANTRI - EDIT MODE &nbsp; &nbsp; <span style="cursor: pointer;" onclick="load_MainJantri_EditMode()" class="badge badge-warning float-right">Re-Load</span> </th>
															<th>MAIN JANTRI - PROFIT &amp; LOSS</th>
														</tr>
													</thead>
													<tbody>
														<tr>
															<td class="p-1">
																<div class="table-responsive MainJantri_EditMode">
																	
																</div>
															</td>
															<td class="p-1" style="width:50%;">
																<div class="table-responsive MainJantri_PLMode">
																	
																</div>
															</td>
														</tr>
													</tbody>
													<thead>
														<tr style="border-top:1px solid #DDD;">
															<th>MAIN JANTRI - DEFAULT</th>
															<th>MAIN JANTRI - DIFFRANCE</th>
														</tr>
													</thead>
													<tbody>
														<tr>
															<td class="p-1" style="width:50%;">
																<div class="table-responsive MainJantri">
																	
																</div>
															</td>
															<td class="p-1">
																<div class="table-responsive MainJantri_DiffranceMode">
																	
																</div>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>

									</tr>
								</tbody>
							</table>


						</div>
						<div class="tab-pane fade" id="fanter" role="tabpanel" aria-labelledby="fanter-tab">
							<div class="table-container">
								<div class="table-responsive JantriView table2excel">
									
								</div>
							</div>
						</div>


					</div>


				</div>


			</div>
			<!-- Content wrapper end -->


		</div>
	</div>
</div>
@include('partial.footer')
<script>
	var BaseUrl = "/";
	var nav = "rpt_comp_calculation";
	var LoginRoleId = "2";

	var IsLive = "Declare";

	var Shift_ArrayList = [];
	var SelectedShift = [];

	var UtarMaster = [];
	var UtarFanter = [];
	var JantriMaster = [];
	var JantriFanter = [];
	var JantriMaster_EditMode = [];
	var JantriMaster_ProfitLoss = [];
	var JantriMaster_PLMode = [];
	var JantriMaster_DiffranceMode = [];


	var DaraRate = 0.0;
	var DaraCommission = 0.0;
	var AkharRate = 0.0;
	var AkharCommission = 0.0;
	var Tax = 0.0;


	$(document).ready(function() {
		setTimeout(function () {
			CustomJantriControl("jv", "JantriView", "readonly");
		}, 10);

		//BlockSpace('#OrganizationUserName');
		setTimeout(function() {
			Comp_CustomJantriControl("mj", "MainJantri", "readonly");
			Comp_CustomJantriControl("mj_em", "MainJantri_EditMode", "");

			Comp_CustomJantriControl("mj_pl", "MainJantri_PLMode", "readonly");
			Comp_CustomJantriControl("mj_diff", "MainJantri_DiffranceMode", "readonly");
			getShifts();
            $("#ShiftDatePanel").html(CustomDatePicker("ShiftDate", "{{$dateToShow}}"));
			MainJantri_ProfitLoss_tbl();
		}, 10);
	});

	function CustomMasterTotal() {
		Comp_MasterTotal("mj_em", "MainJantri_EditMode");
		getMainJantri_ArrayList();
	}

	function getShifts() {
        var JsonData = { 'SearchShift': "" };
        JsonData['nav'] = nav;
        JsonData['nav'] = nav;
        JsonData['Method'] = "ajax_shift_transaction";
        AjaxCall("/getShifts", JsonData, function (response) {
            if (response.status == true) {
                Shift_ArrayList = [];
                var Row = '<select id="Shifts" name="Shifts" onchange="loadDate(this.value)" class="form-control form-control-sm">';
                Row += '<option value="0"> -- CHOOSE -- </option>';
                $.each(response.data, function (index, obj) {
                    Shift_ArrayList[this.id] = obj;
                    Row += '<option value="' + this.id + '">' + this.shift_name + '</option>';
                });
                Row += '</select>';
                $('#ShiftCombo').html(Row);
                //$('#ShiftDate').html('<b  class="form-control form-control-sm">'+Shift_ArrayList[(response.data[0].ShiftId)].ShiftDate+'</b>');
                $('#Shifts').focus();

                //console.clear();
            } else if (response.status == true) {
                Notify("Message", response.message, "danger");
            }
        });
    }

    function loadDate(_Val) {
        SelectedShift = {};
        SelectedShift = Shift_ArrayList[_Val];

        DaraRate = parseFloat(SelectedShift.DaraRate);
        DaraCommission = parseFloat(SelectedShift.DaraComm);
        AkharRate = parseFloat(SelectedShift.AkharRate);
        AkharCommission = parseFloat(SelectedShift.AkharComm);
        Tax = parseFloat(SelectedShift.Tax);

		console.log("SelectedShift", SelectedShift);
		console.log("DaraRate", DaraRate);
		console.log("DaraCommission", DaraCommission);
		console.log("DaraRaAkharRatete", AkharRate);
		console.log("AkharCommission", AkharCommission);
		console.log("Tax", Tax);

        var ShiftDate = "{{$dateToShow}}";
        if (IsLive == "Live") {
            $('#ShiftDatePanel').html('<b  class="form-control form-control-sm">' + setDateProject(ShiftDate) + '</b>');
        } else {
            $("#ShiftDatePanel").html(CustomDatePicker("ShiftDate", ShiftDate));
        }
    }

	// function getShiftsLedgerConfig() {
	// 	var JsonData = {
	// 		'ShiftId': SelectedShift.ShiftId
	// 	};
	// 	JsonData['nav'] = nav;
	// 	JsonData['Method'] = "ajax_shift_company_config";
	// 	AjaxCall("/ajax_index", JsonData, function(response) {
	// 		if (response.status == true) {
				
	// 		} else if (response.status == false) {
	// 			Notify("Message ", response.message, "danger");
	// 		}
	// 	});
	// }
	function Jantri() {

		var ShiftDate = getCustomDatePicker("ShiftDate", 'D');

		if (SelectedShift.open_date == ShiftDate) {
			IsLive = "Live";
		} else {
			IsLive = "No";
		}

		var JsonData = {
			'ShiftDate': ShiftDate,
			'ShiftId': SelectedShift.id,
			'IsLive': IsLive,
		};
		if (JsonData.ShiftDate == "1970-01-01") {
			Notify("Invalid ", "Please enter a valid ShiftDate!", "danger");
			$('#Day_ShiftDate').focus().select();
			return false;
		}
		if (JsonData.ShiftDate == "" || JsonData.ShiftId == "") {
			Notify("Invalid ", "Please enter all valid fields!", "danger");
			return false;
		}
		JsonData['nav'] = nav;
		JsonData['Method'] = (IsLive == "Live" ? "ajax_jantri_live" : "ajax_jantri_declare");
		AjaxCall("/live_prediction_data", JsonData, function (response) {
			Custom_ClearJantri("jv", "JantriView");
			if (response.status == true) {
				
				UtarFanter = [];
				JantriFanter = [];

				$.each(response.data, function (index, obj) {
					UtarFanter.unshift({
						Number: this.Num,
						Amount: this.Profit,
					});
				});
				FillJantriFanter(UtarFanter);
				Custom_Bind_Jantri(JantriFanter, "jv");

			} else if (response.status == false) {
				Notify("Error ", response.message, "danger");
			}
		});
	}
	function getMainJantri() {
		Jantri();
		if (IsActionAllow(Page_Add) == false) {
			return false;
		}
		var ShiftDate = getCustomDatePicker("ShiftDate", 'D');
		if (SelectedShift.open_date == ShiftDate) {
			IsLive = "Live";
		} else {
			IsLive = "Declare";
		}
		var JsonData = {
			'ShiftId': SelectedShift.id,
			'ShiftDate': ShiftDate,
			'Amount': $('#MainJantriAmount').val(),
			'Percentage': $('#MainJantriPercentage').val(),
			'MultiplyUp': $('#MainJantriMultiplyUp').val(),
			"IsLive": IsLive,
		}

		if (JsonData.IsLive == "" || JsonData.ShiftId == "" || JsonData.ShiftDate == "") {
			Notify("Invalid ", "Please enter all valid fields!", "danger");
			return false;
		}

		JsonData['nav'] = nav;
		JsonData['Method'] = "ajax_main_jantri";
		AjaxLoaderMulti('ajax_loader', 'show');
		AjaxCallSync("/get_main_jantri", JsonData, function(response) {
			AjaxLoaderMulti('ajax_loader', 'hide');
			Comp_Custom_ClearJantri("mj", "MainJantri");

			if (response.status == true) {
				UtarMaster = [];
				JantriMaster = [];
				$.each(response.data, function(index, obj) {
					UtarMaster.unshift({
						Number: (this.Number.length == 2 ? Math.round(this.Number) : this.Number),
						Amount: this.NEW_BAL,
					});
				});
				JantriMaster = Comp_FillJantri(UtarMaster);
				setTimeout(function() {
					Comp_Custom_Bind_Jantri(JantriMaster, "mj");
					Comp_MasterTotal("mj", "MainJantri");
					load_MainJantri_EditMode();
				}, 200);
			} else if (response.status == false) {
				Notify("Message", response.message, "danger");
			}
		});
	}



	function load_MainJantri_EditMode() {

		Comp_Custom_ClearJantri("mj_em", "MainJantri_EditMode");
		Comp_Custom_ClearJantri("mj_diff", "MainJantri_DiffranceMode");
		
		JantriMaster_EditMode = Comp_FillJantri(UtarMaster);
		setTimeout(function() {
			Comp_Custom_Bind_Jantri(JantriMaster_EditMode, "mj_em");
			Comp_MasterTotal("mj_em", "MainJantri_EditMode");
			getMainJantri_ArrayList();
		}, 200);

		$('#mj_em_col1').focus().select();
	}

	function getMainJantri_ArrayList() {
		console.log("JantriMaster_EditMode", JantriMaster_EditMode)
		JantriMaster_EditMode = [];
		JantriMaster_EditMode = Comp_CustomJantri_ArrayList("mj_em", "MainJantri_EditMode");
		console.log("JantriMaster_EditMode", JantriMaster_EditMode)
		setCache("mj", JantriMaster_EditMode);
		setTimeout(function() {
			MainJantri_ProfitLoss_tbl();
		}, 200);

		JantriMaster_DiffranceMode = [];
		// $.each(JantriMaster_EditMode, function(edit_index, edit_obj) {
		// 	$.each(JantriMaster, function(main_index, main_obj) {
		// 		if (edit_obj.Number == main_obj.Number) {
		// 			JantriMaster_DiffranceMode.push({
		// 				Number: edit_obj.Number,
		// 				Amount: (Math.round(edit_obj.Amount) - Math.round(main_obj.Amount)),
		// 			});
		// 			return;
		// 		}
		// 	});
		// });
		// Loop through JantriMaster_EditMode to calculate differences
		$.each(JantriMaster_EditMode, function(edit_index, edit_obj) {
			let main_obj = JantriMaster.find(main_obj => main_obj.Number === edit_obj.Number);
			let mainAmount = main_obj ? Math.round(main_obj.Amount) : 0;
			JantriMaster_DiffranceMode.push({
				Number: edit_obj.Number,
				Amount: Math.round(edit_obj.Amount) - mainAmount,
			});
		});

		// Check for numbers in JantriMaster that are missing in JantriMaster_EditMode
		$.each(JantriMaster, function(main_index, main_obj) {
			let edit_obj = JantriMaster_EditMode.find(edit_obj => edit_obj.Number === main_obj.Number);
			if (!edit_obj) {
				JantriMaster_DiffranceMode.push({
					Number: main_obj.Number,
					Amount: -Math.round(main_obj.Amount),
				});
			}
		});

		setTimeout(function() {
			Comp_Custom_Bind_Jantri(JantriMaster_DiffranceMode, "mj_diff");
			Comp_MasterTotal("mj_diff", "MainJantri_DiffranceMode");
		}, 200);
	}


	function getAkharSale(daraNumber) {
		var A_Akhar = daraNumber;
		var B_Akhar = daraNumber;
		if (daraNumber.length == 2) {
			var _NumberSplit = SplitNumber(daraNumber);
			A_Akhar = _NumberSplit[0];
			B_Akhar = _NumberSplit[1];
		} else if (daraNumber == 100) {
			A_Akhar = 0;
			B_Akhar = 0;
		}
		var A_Akhar_Number = A_Akhar + '' + A_Akhar + '' + A_Akhar + '' + A_Akhar;
		var B_Akhar_Number = B_Akhar + '' + B_Akhar + '' + B_Akhar;

		var Amount = 0.0;
		$.each(JantriMaster_EditMode, function(index, obj) {
			if (this.Number == A_Akhar_Number) {
				Amount += this.Amount;
			}
			if (this.Number == B_Akhar_Number) {
				Amount += this.Amount;
			}
		});
		return Amount;
	}

	function MainJantri_ProfitLoss_tbl() {
		JantriMaster_PLMode = [];
		$('.MainJantri_ProfitLoss_Panel').html("");
		var table = '<table class="Comp_CustomJantriTable">';
		table += '<thead>';
		for (var i = 1; i <= 10; i++) {
			table += '<tr>';
			for (var k = 0; k <= 9; k++) {
				var Ids = (parseInt(i + '' + k) - 9);
				var number = Ids;
				var amount = 0;
				var ValueObj = getProfitLossArrayListObject(Ids);
				if (ValueObj.hasOwnProperty("Amount")) {
					amount = ValueObj.Amount;
				}
				var daraSale = amount;
				var akharSale = getAkharSale(Ids + "");

				var totalDaraSale = Math.round($('#MainJantri_EditModeJantriDaraTotal').text());
				var totalAkharSale = Math.round($('#MainJantri_EditModeJantriBaharTotal').text()) + Math.round($('#MainJantri_EditModeJantriAndarTotal').text());
				var totalSale = totalDaraSale + totalAkharSale;
				var commissionDara = (DaraCommission / 100) * totalDaraSale;
				var commissionAkhar = (AkharCommission / 100) * totalAkharSale;
				var commission = commissionDara + commissionAkhar;
				var commissionAfter = totalSale - commission;
				var tax = (Tax / 100) * totalDaraSale;
				var taxAfter = totalDaraSale + tax;
				var discount = tax - commission;

				var rateProfitLoss = (DaraRate * daraSale) + (AkharRate * akharSale);
				var companyPaid = totalSale + (discount);
				var finalProfitLoss = (companyPaid - rateProfitLoss) / 2;
				var Obj = {
					Number: number,
					Amount: amount,
					TotalSale: totalSale,
					TotalDaraSale: totalDaraSale,
					TotalAkharSale: totalAkharSale,
					DaraOpen: daraSale,
					AkharOpen: akharSale,
					Commission: Math.round(commission),
					CommissionAfter: commissionAfter,
					Tax: Math.round(tax),
					TaxAfter: taxAfter,
					Discount: Math.round(discount),
					CompanyPaid: Math.round(companyPaid),
					RateProfitLoss: Math.round(rateProfitLoss),
					FinalProfitLoss: Math.round(finalProfitLoss),
				};
				JantriMaster_PLMode.push({
					Number: number,
					Amount: Math.round(finalProfitLoss),
				});
				//console.log(Obj);

				table += '<th style="padding:2px !important; background:#000;">';

				table += '<table class="Comp_ProfitLossTable float-left" style="width:195px; color:#000; background:#fff;">';
				table += '<tr>';
				table += '<td style="Background:#f03; color:#fff; font-size:14px; font-weight:bold;">SALE</td>';
				table += '<td style="Background:#FFFF00; color:#f03; font-size:18px; font-weight:bold; padding:0px !important;"  colspan="2">' + Ids + '</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td>UP</td>';
				table += '<td>' + Obj.Tax + '</td>';
				table += '<td>' + Obj.CompanyPaid + '</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td>DOWN</td>';
				table += '<td>' + Obj.Commission + '</td>';
				table += '<td>CREDIT</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td>DISC</td>';
				table += '<td>' + Obj.Discount + '</td>';
				table += '<td>' + Obj.RateProfitLoss + '</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td style="background:#7030A0; color:#fff; font-size:12px; font-weight:bold;">DAHI</td>';
				table += '<td style="background:#7030A0; color:#fff; font-size:12px; font-weight:bold;">AKH</td>';
				table += '<td style="font-size:12px; font-weight:bold;" rowspan="2">' + Obj.TotalSale + '</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td style="font-size:12px; font-weight:bold;">' + Obj.TotalDaraSale + '</td>';
				table += '<td style="font-size:12px; font-weight:bold;">' + Obj.TotalAkharSale + '</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td style="background:#8E0000; color:#fff; font-size:12px; font-weight:bold;">O-DAHI</td>';
				table += '<td style="background:#8E0000; color:#fff; font-size:12px; font-weight:bold;">O-AKH</td>';
				table += '<td style="' + (Obj.FinalProfitLoss > 0 ? "background:#009900;" : "background:#f03;") + ' color:#fff; font-size:12px; font-weight:bold;" rowspan="2">' + Obj.FinalProfitLoss + '</td>';
				table += '</tr>';
				table += '<tr>';
				table += '<td style="font-size:12px; font-weight:bold;">' + Obj.DaraOpen + '</td>';
				table += '<td style="font-size:12px; font-weight:bold;">' + Obj.AkharOpen + '</td>';
				table += '</tr>';
				table += '</table>';

				table += '</th>';
			}
			table += '</tr>';
		}
		table += '</thead>';

		table += '</table>';
		$('.MainJantri_ProfitLoss_Panel').html(table);

		setTimeout(function() {
			Comp_Custom_Bind_Jantri(JantriMaster_PLMode, "mj_pl");
			//Comp_MasterTotal("mj_pl", "MainJantri_PLMode");
			$.each(JantriMaster_PLMode, function(index, obj) {
				if (Math.round(this.Amount) < 0) {
					$('#mj_pl_col' + this.Number).css("color", "#f03");
				} else {
					$('#mj_pl_col' + this.Number).css("color", "#006f63");
				}
			});
		}, 200);

	}

	function getProfitLossArrayListObject(number) {
		var Obj = {};
		$.each(JantriMaster_EditMode, function(index, obj) {
			if (this.Number == number) {
				Obj = this;
				return false;
			}
		});
		return Obj;
	}

	$(function() {
		$("body").keydown(function(e) {
			var keyCode = e.keyCode || e.which;
			if (keyCode == 113) // F2 - Save Transaction
			{
				e.preventDefault();
				AddBtn();
			}
			if (keyCode == 116) // F5 - Random
			{
				e.preventDefault();
			}
		});
	});


	$(function() {
		var focusedRow = null;
		$('#scrollVerticalFixHeaderFooter').on('keydown', function(ev) {
			console.log(ev.keyCode);
			if (focusedRow == null) {
				focusedRow = $('tr:nth-child(1)', '#scrollVerticalFixHeaderFooter');
			} else if (ev.keyCode === 38) {
				focusedRow.toggleClass('focused');
				focusedRow = focusedRow.prev('tr');
			} else if (ev.keyCode === 40) {
				focusedRow.toggleClass('focused');
				focusedRow = focusedRow.next('tr');
			}
			focusedRow.toggleClass('focused');
		});
		$('#scrollVerticalFixHeaderFooter').focus();
	});


	ko.bindingHandlers.nextFieldOnEnter = {
		init: function(element, valueAccessor, allBindingsAccessor) {
			$(element).on('keydown', 'input, select', function(e) {
				var self = $(this),
					form = $(element),
					focusable, next;
				//LastFocusedControl_Id = $(":focus").attr("id");
				if (e.keyCode == 13) {
					focusable = form.find('input,select,button,textarea').filter(':visible');
					var nextIndex = focusable.index(this) == focusable.length - 1 ? 0 : focusable.index(this) + 1;
					next = focusable.eq(nextIndex);


					next.focus().select();
					return false;
				}
			});
		}
	};
	ko.applyBindings({});
</script>