var originalorders = Array();
var orders = Array();
var users = Array();
var transactions = Array();
var groups = Array();
var drivers = Array();
var locations = Array();
var packers = Array();
var grouplocation = Array();
var groupdriver = Array();
var grouppackers = Array();
var selectedOrders = Array();
var products = Array();
var calcgroup = Array();
var shortmonth = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
var deliveryStatusArray = Array();
deliveryStatusArray.push('Packing Pending');
 deliveryStatusArray.push('Packing In Progress');
 deliveryStatusArray.push('Packing Completed');
 deliveryStatusArray.push('Picked Up');
 deliveryStatusArray.push('Delivered');
 deliveryStatusArray.push('Cancelled');
 deliveryStatusArray.push('Returned');
 deliveryStatusArray.push('Other - see remarks');

var pageno = 0;
var pageno_transaction = 0;
var recordsperpage= 5;
var recordsperpage_transaction= 20;

var isStarted = false;
var role;
	var seller;
	var fullname ;

var latlng = "";
var unplanned = false;
var unlisted = false;

$( document ).ready(function() {

		$("#tblOrdersMobile").hide();
		$("#tblOrders").show();
		$("#divMobileNav").hide();	
		hideLogsDetails();
		var today = new Date();
		var date = today.getDate()+"-"+(shortmonth[today.getMonth()])+"-"+today.getFullYear().toString().substr(-2);
		$("#txtFetchDeliveryDate").val(date);
								
		selectAlLStatus();
		selectAllProducts();
		hideAll();
	
		  role = $("#hidRole").val();
		  seller = $("#hidSeller").val();
		  fullname = $("#hidFullName").val();
	
		if(role == "ADMIN"){
		//	$("#divGoogletoDB").show();	
		}
		
		if(role == "DRIVER"){
			deselectAlLStatus();
			selectDefaultDriverStatus();
			changeView();
 		}
		
		if(role == "PACKAER"){
		//	deselectAlLStatus();
		//	selectDefaultPackerStatus();
		}
	 	
		$("#divOrders").show();
		$("#selectionStats").hide();
		
			
 		
		$('#mainContainer').on('scroll', function() {
		
			var tol = 0; //Math.round($(this)[0].scrollHeight / 5);		
			

			if($(this).scrollTop() + $(this).innerHeight() + tol >= $(this)[0].scrollHeight) {
			
				if(!isStarted){	 
				console.log("BASE:"+pageno);
				if($("#tblOrders").is(":visible")){
					getOrders(false);
				}
				
				}
			}
		})
		
		
		$('#divTransactionContainer').on('scroll', function() {
		
			if($("#tblTransactions").is(":visible")){
				var tol = 0; //Math.round($(this)[0].scrollHeight / 5);		
				
	
				if($(this).scrollTop() + $(this).innerHeight() + tol >= $(this)[0].scrollHeight) {
					
					if(!isStarted){	
						getTransactions(false);
					}
				}
				
			}
		})
	 
	 var current_date = new Date();
	 
	$.getJSON('api.php?action=groups'+"&curtime="+current_date.getMilliseconds(), function(result) { 
		groups = result;
		
		$.getJSON('api.php?action=drivers'+"&curtime="+current_date.getMilliseconds(), function(result) { 
			drivers = result;
			
			$.getJSON('api.php?action=grouplocation&groupId=0'+"&curtime="+current_date.getMilliseconds(), function(result) { 
				grouplocation = result;
			
				$.getJSON('api.php?action=groupdriver'+"&curtime="+current_date.getMilliseconds(), function(result) { 
					groupdriver = result;
				
					$.getJSON('api.php?action=products'+"&curtime="+current_date.getMilliseconds(), function(result) { 
						products = result;
						
						$.getJSON('api.php?action=packers'+"&curtime="+current_date.getMilliseconds(), function(result) { 
							packers = result;

							$.getJSON('api.php?action=locations'+"&curtime="+current_date.getMilliseconds(), function(result) { 
								locations = result;
								
									$.getJSON('api.php?action=grouppacker'+"&curtime="+current_date.getMilliseconds(), function(result) { 
										grouppackers = result;
		
										$.getJSON('api.php?action=calcgroup'+"&curtime="+current_date.getMilliseconds(), function(result) { 
											calcgroup = result;
			
											$.getJSON('api.php?action=users'+"&curtime="+current_date.getMilliseconds(), function(result) { 
												users = result;
				
												readGroupLocation();	
												readGroupDriver();
												readGroupPacker();
												readTransactionMap();
												//getOrders()
												
												
												
												getOrders(false);
												if(role == "DRIVER"){
													changeView();
												}
										
											});
									
										});
								
									});
						
							});
							
							
						});
						
					 
					})
				})
			})
		})
	
	})

	clickhandled();
	
	$("#mainContainer").show();
	$("#containerConsolidated").hide();
	$("#containerBulkUpdate").hide();
	
	$("#frmUsers").submit(function(e){
        e.preventDefault();
		saveUser();
    });
	
	
	$('#selFilterGroup').change(function() {
		readGroupLocation();
	});
//gridView('mainContainer');

	
});

function selectAlLStatus(){
 $("input[id='statusfilter']").each(function(i){
          $(this).prop('checked', true);
		  
        });	
}

function selectAllProducts(){
 $("input[id='productfilter']").each(function(i){
          $(this).prop('checked', true);
		  
        });	
}


function selectDefaultDriverStatus(){

$("#selExpectedToggle").val("actualexpectedDeliverDate");

 $("input[id='statusfilter']").each(function(i){
         // console.log($(this).val());
		  if($(this).val() == "Packing Pending" || $(this).val() == "Packing In Progress" || $(this).val() == "Packing Completed" || $(this).val() == "Picked Up" || $(this).val() == "unassigned"){
			$(this).prop('checked', true);	  
			
		  }
		  
		  
		  
        });	
}

function selectDefaultPackerStatus(){
 $("input[id='statusfilter']").each(function(i){
         // console.log($(this).val());
		  if($(this).val() == "Packing Pending" || $(this).val() == "Packing In Progress" || $(this).val() == "unassigned"){
			$(this).prop('checked', true);	  
		  }
		  
		  
        });	
}

function deselectAlLStatus(){
 $("input[id='statusfilter']").each(function(i){
          $(this).prop('checked', false);
		  
        });	
}


function deselectAllProducts(){
 $("input[id='productfilter']").each(function(i){
          $(this).prop('checked', false);
		  
        });	
}

function selectAll(){
	$('#tblOrders > tbody  > tr').each(function(index, tr) { 
	   
	   if($(tr).find("td").eq(1).html() !== "<strong>Driver</strong>"){
		   if(jQuery.inArray($(tr).find("td").eq(6).html(), selectedOrders) !== -1){
				$( tr ).css( "background-color", "#FFFFFF" );
				
				selectedOrders.splice( $.inArray($(tr).find("td").eq(6).html(), selectedOrders), 1 );
			}else{
				$( tr ).css( "background-color", "#DCDCDC" );	
				selectedOrders.push($(tr).find("td").eq(6).html());
			
			}
			
			$("#selOrders").html(selectedOrders.toString());
			$("#selCount").html(selectedOrders.length);
			
			$("#spanGroup").html(getGroupDDL(selectedOrders.toString(), "", true));
			

			
			
			if(selectedOrders.length > 0){
				$("#selectionStats").show();	
			}else{
				$("#selectionStats").hide();	
				
			}
	   }
	   
	   		

	   
	   
	});	
}

function clickhandled(){
	 $("#tblOrders tr").unbind(); 
	 
	var pickedup;
		 $( "#tblOrders tr" ).on( "click", function( event ) {
	 			
				if(jQuery.inArray($(this).find("td").eq(6).html(), selectedOrders) !== -1){
					$( this ).css( "background-color", "#FFFFFF" );
					
					selectedOrders.splice( $.inArray($(this).find("td").eq(6).html(), selectedOrders), 1 );
				}else{
					$( this ).css( "background-color", "#DCDCDC" );	
					selectedOrders.push($(this).find("td").eq(6).html());
				
				}
	 			
				$("#selOrders").html(selectedOrders.toString());
				$("#selCount").html(selectedOrders.length);
				
				$("#spanGroup").html(getGroupDDL(selectedOrders.toString(), "", true));
				$("#spanDriver").html(getDriverDDL(selectedOrders.toString(), "", true));		 
				$("#spanPacker").html(getPackerDDL(selectedOrders.toString(), "", true));		 
	
				
				if(selectedOrders.length > 0){
					$("#selectionStats").show();	
				}else{
					$("#selectionStats").hide();	
					
				}
	
		});	
}

function getAnalysis(){
	
	var current_date = new Date()
	var searchparam = "";
	
	searchparam += "&tranfrom="+$("#txtTranFrom").val();	
	searchparam += "&tranto="+$("#txtTranTo").val();	
	searchparam += "&unplanned="+$("#rdUnplanned:checked"). val();	

	$("#tblTransactions").hide();
	$("#tblAnalysis").show();
	$("#tblAnalysis").find("tr:gt(0)").remove();
	$("#mainContainer").scrollTop(0);		
	
	$.getJSON("api.php?action=transactionanalysis&curtime="+current_date.getMilliseconds()+searchparam, function(result) 	{ 
		
		const formatter = new Intl.NumberFormat('en-US', {
		  style: 'currency',
		  currency: 'INR',
		  minimumFractionDigits: 2
		})
		
		
		
			var markup = "<tr><td>Total Sale </td><td></td><td></td><td>"+formatter.format(result["SALE"])+"</td><td></td></tr>";
			   markup += "<tr><td>Total Purchase </td><td></td><td></td><td>"+formatter.format(result["PURCHASE"])+"</td><td></td></tr>";
			   markup += "<tr><td>Orders </td><td></td><td></td><td>"+(result["ORDERS"])+"</td><td></td></tr>";
			   markup += "<tr><td>Total PSP </td><td></td><td></td><td>"+formatter.format(result["PSP"])+"</td><td></td></tr>";
			   markup += "<tr><td><b>Group Distribution </b></td><td></td><td></td><td></td><td></td></tr>";
			
			var arrCalc = result["CALCGROUP"];
			var arrKeys = Object.keys(arrCalc);
			console.log(arrKeys);
			for(var i=0;i<arrKeys.length;i++){
			    markup += "<tr><td><b>"+arrKeys[i]+"</b></td><td><b>"+formatter.format(arrCalc[arrKeys[i]]["EXPECTEDTOTALVAL"])+"</b></td><td><b>"+Number(((arrCalc[arrKeys[i]]["EXPECTEDTALPER"])).toFixed(2))+"%</b></td><td><b>"+formatter.format(arrCalc[arrKeys[i]]["ACTUALTOTALVAL"])+"</b></td><td><b>"+Number(((arrCalc[arrKeys[i]]["ACTUALTOTALPER"])).toFixed(2))+"%</b></td></tr>";			
				var arrSubKeys = Object.keys(arrCalc[arrKeys[i]]);
				
				for(var j=0;j<arrSubKeys.length;j++){
					if(arrSubKeys[j] != "ACTUALTOTALVAL" && arrSubKeys[j] != "ACTUALTOTALPER" && arrSubKeys[j] != "EXPECTEDTOTALVAL" && arrSubKeys[j] != "EXPECTEDTALPER"){
						if(arrCalc[arrKeys[i]][arrSubKeys[j]]["plannedPurchasePercent"] == null){
						arrCalc[arrKeys[i]][arrSubKeys[j]]["plannedPurchasePercent"] = 0;	
						}
						markup += "<tr><td>&nbsp;&nbsp;&nbsp;"+arrSubKeys[j]+"</td>";
						markup += "<td>&nbsp;&nbsp;&nbsp;"+formatter.format(arrCalc[arrKeys[i]][arrSubKeys[j]]["plannedPurchaseValue"])+"</td>";
						markup += "<td>&nbsp;&nbsp;&nbsp;"+(arrCalc[arrKeys[i]][arrSubKeys[j]]["plannedPurchasePercent"])+" %</td>";
						markup += "<td>&nbsp;&nbsp;&nbsp;"+formatter.format(arrCalc[arrKeys[i]][arrSubKeys[j]]["actualPurchaseValue"])+"</td>";
						markup += "<td>&nbsp;&nbsp;&nbsp;"+(arrCalc[arrKeys[i]][arrSubKeys[j]]["actualPurchasePercent"])+" %</td>";
						markup += "</tr>";	
						
					}
				}
			}
			
			$("#tblAnalysis tbody").append(markup);
		
		
	});

}

function getTransactions(clearTable){
	
	$("#tblTransactions").show();
	$("#tblAnalysis").hide();
	
	
	if(pageno_transaction < 1){
		pageno_transaction = 0;
	}
	
	
	
	if(clearTable){
		pageno_transaction=0;
	}
		

	var current_date = new Date()
	
	isStarted = true;
	
	var searchparam = "";
	
	searchparam += "&search="+$("#txtTranAny").val();	
	searchparam += "&tranfrom="+$("#txtTranFrom").val();	
	searchparam += "&tranto="+$("#txtTranTo").val();	
	searchparam += "&unplanned="+$("#rdUnplanned:checked").val();	
	searchparam += "&paymentstatus="+$("#selTranPaymentStatus").val();	
	
	if($("#hidRole").val() == "SUPERADMIN"){
		if($("#selTransactionUser").val() != "0"){
			searchparam += "&role=SELLER";	
			searchparam += "&userId="+$("#selTransactionUser").val();
			
			for(var i=0;i<users.length;i++){
				if(users[i]["userId"] == $("#selTransactionUser").val()){
					searchparam += "&seller="+users[i]["seller"];		
				}
			}
		}else{
			searchparam += "&role="+$("#hidRole").val();	
			searchparam += "&userId="+$("#hideLoggedUserId").val();	
			searchparam += "&seller="+$("#hidSeller").val();	
		}
	}else{
	
		searchparam += "&role="+$("#hidRole").val();	
		searchparam += "&userId="+$("#hideLoggedUserId").val();	
		searchparam += "&seller="+$("#hidSeller").val();	

		
	}
	
 	var xhr = $.getJSON("api.php?action=transactions&pageno="+pageno_transaction+"&recordsperpage="+recordsperpage_transaction+searchparam+"&curtime="+current_date.getMilliseconds(), function(result) 	{ 
		
	 	var totalRecords =  xhr.getResponseHeader('totalrecs');
		pageno_transaction=pageno_transaction+1;
	 	transactions = result;
		
		if(clearTable){
		   $("#tblTransactions").find("tr:gt(0)").remove();
			 $("#mainContainer").scrollTop(0);
		}
			$("#divtotalTransactions").html("Total transactions : "+totalRecords);
		
		var pno = pageno_transaction; 
		if(pageno_transaction > totalRecords){
			pno = totalRecords;
		}
		
		
		for(var i=0;i<transactions.length;i++){
			addTransactionRow(transactions[i]);	
		}
		
		
		
		isStarted = false;
	}); 
	
	getTransactionAnalyticsMiniVersion(searchparam);
}

function getTransactionAnalyticsMiniVersion(params){

	var current_date = new Date()
	$.getJSON("api.php?action=transactionanalysismini"+params+"&curtime="+current_date.getMilliseconds(), function(result) 	{ 
			
			const formatter = new Intl.NumberFormat('en-US', {
			  style: 'currency',
			  currency: 'INR',
			  minimumFractionDigits: 2
			})
			
			var resultmarkup = "";
			resultmarkup += "Total Deposit: <b>"+formatter.format(result["DEPOSIT"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Withdrawal: <b>"+formatter.format(result["WITHDRAWAL"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />Total Sale: <b>"+formatter.format(result["TOTALSALE"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Refund: <b>"+formatter.format(result["TOTALREFUND"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Overall Sale: <b>"+formatter.format(result["OVERALLSALE"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Commission Earned: <b>"+formatter.format(result["COMMISSION"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Commission Paid: <b>"+formatter.format(result["AMOUNTPAID"])+"</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Pending Commission: <b>"+formatter.format(result["AMOUNTBALANCE"])+"</b>&nbsp;&nbsp;<input type='button' value='Request for Balance Commission' style='background-color:green; color:white;' onclick='requestforcommission("+(result["AMOUNTBALANCE"])+")' />";
			
			$("#divMiniAnalytics").html(resultmarkup);
	});

}

function requestforcommission(amount){
	 
	var current_date = new Date()
	var params = "";
	params += "&fullname="+$("#hidFullName").val();
	params += "&amount="+amount;
	
	$.getJSON("api.php?action=sendpaymentrequest"+params+"&curtime="+current_date.getMilliseconds(), function(result) 	{ 
		alert("Request has been sent, we will update you once your payment is processed!");
	});
}

function updateOrderSnapOld(details, orderId, products){

	$('#divOrderSnapshot').html("<b>Order Details </b>:"+details+"&nbsp;&nbsp"+products+"&nbsp;&nbsp&nbsp;&nbsp&nbsp;&nbsp<a href='javascript:void(0)' onclick='showDiv(\"divOrders\");$(\"#txtFetchDeliveryDate\").val("+orderId+");unplanned=false;unlisted=false;searchgrid();'>View Details</a>");	
}

function updateOrderSnap(row){
	var productTotal = 0; 
	for(var i=0;i<row["products"].length;i++){
		productTotal += parseInt(row["products"][i]["qty"]) * parseInt(row["products"][i]["costPerItem"]);
	} 
		// SINCE ORDER TOTAL IS COMING NOW FROM ORDERS TABLE ITSELF, WE DON'T NEED ABOVE DYNAMIC CALCULATION BUT KEEPING IT FOR FUTURE REF.
//		productTotal = row["order"]["orderTotal"];
	


	console.log(row);
 	$('#divOrderSnapshot').html("<b>Order Details </b>:"+row["orderIdDetails"]+"&nbsp;&nbsp"+row["orderIdProd"]+"&nbsp; Order Total : <b>"+productTotal+"</b>&nbsp;Ref : <b>"+row["order"]["paymentRef"]+"</b>&nbsp&nbsp;&nbsp&nbsp;&nbsp<a href='javascript:void(0)' onclick='showDiv(\"divOrders\");$(\"#txtFetchDeliveryDate\").val("+row["orderId"]+");unplanned=false;unlisted=false;searchgrid();showAccountSnap("+row["orderId"]+")'>View Details</a>");	
}

function addTransactionRow(row){
  
  var role = $("#hidRole").val();
  
  	var orderIdMarkup = getTransOrderIdInputText(row["transactionId"], row["orderId"], "orderId");
console.log(row["orderId"]);

	if(role != "SUPERADMIN"){
		orderIdMarkup = row["orderId"];
	}

	if(row["orderId"] != "0"){
		
		
		var tmprow = row;
		delete tmprow["address"];
		delete tmprow["userlogs"];
		
		orderIdMarkup = orderIdMarkup + "<br /><a href='javascript:void(0)' onclick='updateOrderSnap("+JSON.stringify(tmprow)+")'>View</a>";
	}
	


 	if(row["userId"] == "0"){
		row["userId"] = row["autoUserId"];
		var objTmp = Object();
		objTmp.value = row["userId"];
		if(objTmp.value != "0"){
			updateTransaction('userId',objTmp,row["transactionId"] ,0)
		}
	}
	
	if(row["trangroupId"] == "0"){
		row["trangroupId"] = row["autoGroupId"];
		var objTmp = Object();
		objTmp.value = row["trangroupId"];
		if(objTmp.value != "0"){
			updateTransaction('trangroupId',objTmp,row["transactionId"] ,0)
		}
	}
	
	
	
	if(row["transubgroup"] == "0"){
		row["transubgroup"] = row["autoSubGroupId"];
		var objTmp = Object();
		objTmp.value = row["transubgroup"];
		if(objTmp.value != "0"){
			updateTransaction('transubgroup',objTmp,row["transactionId"] ,0)			
		}
	}
	
  	var userIdMarkup = getTranUserDDL(row["transactionId"], row["userId"]);
 	var groupIdMarkup = getCalcGroupDDL(row["transactionId"], row["trangroupId"], 0, row["transubgroup"]);
  	var subgroupIdMarkup = getCalcGroupDDL(row["transactionId"], row["transubgroup"], row["trangroupId"],row["transubgroup"]);

	if(role != "SUPERADMIN"){
		groupIdMarkup = (row["groupby"] == null)?"":row["groupby"];
		subgroupIdMarkup = (row["subgroupby"] == null)?"":row["subgroupby"];
		userIdMarkup = (row["allocatedUser"] == null)?"":row["allocatedUser"];
	}


	var closingBalMarkup = "";
	
	if(role == "SUPERADMIN"){
		closingBalMarkup = "<td>"+row["closingBal"]+"</td>";
	}

	// 				getCalcGroupDDL(calcgroup["transactionId"], calcgroup[i]["subgroupId"], calcgroup[i]["groupId"],calcgroup[i]["subgroupId"])	

	var markup = "<tr> \
		<td>"+row["trandate_formatted"]+"</td> \
		<td>"+row["narration"]+"</td> \
		<td>"+row["chqno"]+"</td> \
		<td>"+row["valueDate_formatted"]+"</td> \
		<td>"+row["withdrawalAmt"]+"</td> \
		<td>"+row["depositAmt"]+"</td> \
		"+closingBalMarkup+" \
		<td>"+row["paymentStatus"]+"</td> \
		<td>"+orderIdMarkup+"</td> \
		<td>"+groupIdMarkup+"</td> \
		<td id='tdSubGroup'>"+subgroupIdMarkup+"</td> \
		<td id='tdUserId'>"+userIdMarkup+"</td> \
		";
		
		 
	$("#tblTransactions tbody").append(markup);
 
 }

function getOrders(clearTable){
	
	if(pageno < 1){
		pageno = 0;
	}
	
	var role = $("#hidRole").val();
	var seller = $("#hidSeller").val();
	
	var statusfilter = "";
	var val = Array();
	 $("input[id='statusfilter']:checked").each(function(i){
          val[i] = $(this).val();
        });
		
	if(val.length > 0){
		val.push('Status');
		statusfilter = "&status="+(val.toString());	
		
	}
	
	var productfilter = "";
	var val2 = Array();
	 $("input[id='productfilter']:checked").each(function(i){
          val2[i] = $(this).val();
        });
		
	if(val2.length > 0){
		productfilter = "&products="+(val2.toString());	
		
	}
	
	
	if(clearTable){
			 pageno=0;
	}
	
	var driverFilter = "";
	if($('#selDriverFilter').length){
		if($("#selDriverFilter").val() != "0" && $("#selDriverFilter").val() != "undefined"){
			driverFilter = "&driverId="+$("#selDriverFilter").val();
		}
		
	}else{
	//driverFilter = "&driverId=0";	
	}
	
	var sortby = $("#sortBy").val();
	
//	alert(clearTable+":"+pageno);
	isStarted = true;	
	
	var current_date = new Date()
	
	var expectedDeliveryToggle = "&expectedDeliveryToggle="+$("#selExpectedToggle").val();
	
	
	var productcondition = "&productcondition="+$("#productcondition:checked").val();
	
	
 	var xhr = $.getJSON('api.php?action=orders&userId='+$("#hideLoggedUserId").val()+'&deliveryDate='+$("#txtFetchDeliveryDate").val()+"&role="+role+"&seller="+seller+"&pageno="+pageno+"&recordsperpage="+recordsperpage+statusfilter+productfilter+driverFilter+expectedDeliveryToggle+"&sortBy="+sortby+"&unplanned="+unplanned+"&unlisted="+unlisted+productcondition+"&curtime="+current_date.getMilliseconds(), function(result) { 
		
	 	var totalRecords =  xhr.getResponseHeader('totalrecs');
		pageno=pageno+1;
	 //	alert(pageno);
		orders = result;
		originalorders = result; 
		
		
		//$("#tblOrders").empty();
		//$("#tblOrders > tbody").html("");
		
		if(clearTable){
		   $("#tblOrders").find("tr:gt(0)").remove();
			 $("#mainContainer").scrollTop(0);
			// pageno=0;

		}
		
		//$("#divtotalOrders").html(orders.length);
		$("#divtotalOrders").html(totalRecords);
		
		var pno = pageno; 
		if(pageno > totalRecords){
			pno = totalRecords;
		}
		
			
		if(orders.length < 1){
			//alert("No more order exists");	
		}
 		else{
			$("#divtotalOrders2").html(pno+" of "+totalRecords+" # "+orders[0]["orderId"]);
			
		}
		for(var i=0;i<orders.length;i++){
//		for(var i=0;i<10;i++){
	
			if($("#tblOrders").is(":visible")){
				addOrderRow(orders[i]);	
			}else{
				 $("#tblOrdersMobile").find("tr:gt(0)").remove();
			 	$("#mainContainer").scrollTop(0);
				addOrderRowMobile(orders[i]);
			}
		}
		
		
		$("#spanGroup").html(getGroupDDL(selectedOrders.toString(), "",false));
	
	
		$('#tblOrders').filterTable({
			inputSelector: '#txtSearch',
			   filterExpression: 'filterTableFindAny'
		});

		isStarted = false;
		
	}); 
	
}

function addOrderRowMobile(row){
	
	var maplocation = "";
	if(row["latlan"] != ""){
		maplocation = "<a href='https://maps.google.com/maps?q="+row["latlan"]+"' target='_blank'>Package Location</a>";
	}
	
	 var nextButtonVal='';
	 var currentIndex = deliveryStatusArray.indexOf(row["deliveryStatus"]); 
 	 
	 var productstr = "";

	for(var i=0;i<row["products"].length;i++){
		var prod = row["products"][i];
		productstr += prod["shortTitle"]+"-"+prod["qty"]+" PC,&nbsp;&nbsp;";	
	}

		
		if(row["deliveryStatus"] == "-1" || row["deliveryStatus"] == null || row["deliveryStatus"] == "" || row["deliveryStatus"] == "null"){
			currentIndex = 1;
		}else{
			currentIndex = currentIndex+1;
		}
	
		//console.log(row["deliveryStatus"]+":"+currentIndex);
	
		
		var nextButtonVal =  deliveryStatusArray[currentIndex];
		
		if(nextButtonVal == "undefined"){
				nextButtonVal = deliveryStatusArray[0];
		}
 
	var nextDelButtonHTML = ""; 
	
	if(currentIndex < deliveryStatusArray.length){
		nextDelButtonHTML = "<input type='button' value='"+nextButtonVal+"' class='expbutton' style='font-size:28px' onclick=\"updateOrderAsDelivered('deliveryStatus','"+nextButtonVal+"',"+row["orderId"]+", this)\" />"; 
	
	}
	
	if(row["opRemark"] == null || row["opRemark"] == ""){
		row["opRemark"] = "";	
	}
	
	
	var packermarkup = "";
	if(role == "ADMIN" || role == "SUPERADMIN" || role == "DRIVER"){
		packermarkup = "<br /><hr /><a style='font-size:14pt; float:left;' href='tel:"+row["phone"]+"'>"+row["phone"]+" </a>&nbsp;&nbsp;&nbsp;&nbsp;<a style='font-size:14pt;float:right;' href='https://maps.google.com/maps?q="+row["address"]+"' target='_blank'>Customer Location</a>";
	}
	
	
	var sellermarkup = "";
	if(role == "ADMIN" || role == "SUPERADMIN" || role == "SELLER"){
		sellermarkup = "&nbsp;-&nbsp; "+row["paymentInfo"]+"\
			<br /> "+row["paymentDate"]+"\
			 	   "+row["paymentRef"];
	}
	
	
	var addressmarkup = "&nbsp;-&nbsp; "+row["address"]+"\
			<br /> "+row["location"]+"\
			 	   "+row["pincode"];
	if(role == "PACKER" ){
		addressmarkup = "&nbsp;-&nbsp; "+row["paymentInfo"]+"\
			<br /> "+row["paymentDate"]+"\
			 	   "+row["paymentRef"];
	}
	
	
	
	var markup = "<tr><td align='center' style='font-size:14pt;'>";


	markup += " \
			 "+row["customerName"]+"\
			"+addressmarkup+"\
			"+packermarkup+"\
			<br /><hr /> "+productstr+"\
			<br /><hr />Current Order Status \
			<br /> <b class='statuscss' style='font-size:28px;padding:5px;'>"+row["deliveryStatus"]+"</b> \
			<br /><hr /> Next Status \
			<br /><span class='delbuttoncontainer'>"+nextDelButtonHTML+"</span>\
			<br /><hr />"+getDeliveryStatusDDL(row["orderId"], row["deliveryStatus"], false)+"\
			<br /><hr /> "+getTextAreamobile(row["orderId"], row["opRemark"], "opRemark")+"\
			<br /><br /> "+sellermarkup+"\
			";	 


/*
	markup += "<tr> \
			<td align='center'>Current Status: <br/><b class='statuscss' style='font-size:28px;padding:5px;'>"+row["deliveryStatus"]+"</b>"+maplocation+"<hr/>Choose New Status :<span class='delbuttoncontainer'>"+nextDelButtonHTML+"</span> \
			<br /><br />"+getDeliveryStatusDDL(row["orderId"], row["deliveryStatus"], false) +"<br/><br/><input type='button' style='display:none;"+hideDelivered+"' value='Delivered Now' class='expbuttonlarge' onclick=\"updateOrderAsDelivered('deliveryStatus','Delivered',"+row["orderId"]+", this)\" /> \
			</td> \
			<td>"+row["customerName"]+"<br />"+row["email"]+"<br />"+row["phone"]+"<br />"+row["address"]+"<br />"+row["location"]+"<br/>"+row["pincode"]+" \
			<br /><a href='https://maps.google.com/maps?q="+row["address"]+"' target='_blank'>Customer Location</a></td> \
			<td>"+getGroupDDL(row["orderId"],selectedGroup,false)+"   \
			<br /><br /> "+getDriverDDL(row["orderId"],selectedDriver)+" \
			<br /><br /> "+getPackerDDL(row["orderId"],selectedPacker)+"</td> \
			<td>"+getInputText(row["orderId"], row["actualLocation"], "actualLocation")+" \
			<br /><br />"+getInputText(row["orderId"], row["actualDeliveryDate"], "actualDeliveryDate")+"</td>\
			<td><span>Pay Date.-</span>"+getInputText(row["orderId"], row["paymentDate"], "paymentDate")+" \
				<span>Pay Info-</span>"+getInputText(row["orderId"], row["paymentInfo"], "paymentInfo")+"\
				<span>Status -</span>"+getPaymentStatusDDL(row["orderId"], row["paymentStatus"], false)+"</td>\
			<td>"+getTextArea(row["orderId"], row["opRemark"], "opRemark")+"</td>\
			<td>"+row["orderId"]+"</td> \
			<td>"+row["timestamp"]+"<br /><br />"+row["expectedDeliverDate"]+"</td> \
			<td>"+sellermarkup+"</td> \
			<td>"+pincodemarkup+"</td> \
			<td>"+phonemarkup+"</td> \
			<td>"+addressmarkup+"</td> \
			<td>"+row["paymentRef"]+"</td> \
			<td>"+location+"</td> \
			<td>Expected Delivery - "+deliveryDate+"<br /><br />Planned Delivery"+actualdeliveryDate+"</td> \
			<td class='commentsA'>"+commentsMarkup+"</td> ";

*/



	markup = markup + "</td></tr>";
 
	$("#tblOrdersMobile tbody").append(markup);
	clickhandled();

}
function addOrderRow(row){
//	console.log(row);
	var selectedGroup = row["groupId"];
	
	if(row["groupId"] == "0" || row["groupId"] == null){

	//	console.log("Location:"+ row["locationId"]);

		for(var i=0;i<grouplocation.length;i++){
			
		//	console.log(grouplocation[i].locationId.toString() +":"+ row["locationId"]);
			if(grouplocation[i].locationId.toString() == row["locationId"]){
				selectedGroup = grouplocation[i].groupId.toString();
				updateOrder("groupId",selectedGroup,row["orderId"],false)
			 
			}
		}
	}
	
	
	var selectedDriver = row["driverId"];
	if(row["driverId"] == "0" || row["driverId"] == null){
		for(var i=0;i<groupdriver.length;i++){
			if(groupdriver[i].groupId.toString() == row["groupId"]){
				selectedDriver = groupdriver[i].driverId.toString();
				updateOrder("driverId",selectedDriver,row["orderId"],false)

			}
		}
	}
	
	
	var selectedPacker = row["packerId"];
	//console.log("ORDER:"+row["orderId"]+":"+row["packerId"]);
	if(row["packerId"] == "0" || row["packerId"] == null){
		for(var i=0;i<grouppackers.length;i++){
			if(grouppackers[i].groupId.toString() == row["groupId"]){
				selectedPacker = grouppackers[i].packerId.toString();
				//console.log("===UPDATING PACKER:"+row["orderId"]+":"+selectedPacker);
				updateOrder("packerId",selectedPacker,row["orderId"],false);
//				updateOrder("packerId",selectedPacker,row["orderId"],false)

			}
		}
	}
	
	var hideDelivered = "";
	 
	if(row["deliveryStatus"] == "Delivered Now"){
		hideDelivered = "hidden";
	}else{
		hideDelivered = "hidden";	
	}
	 
	 var nextButtonVal='';
	 var currentIndex = deliveryStatusArray.indexOf(row["deliveryStatus"]); 
 	 
		
		if(row["deliveryStatus"] == "-1" || row["deliveryStatus"] == null || row["deliveryStatus"] == "" || row["deliveryStatus"] == "null"){
			currentIndex = 1;
		}else{
			currentIndex = currentIndex+1;
		}
	
		//console.log(row["deliveryStatus"]+":"+currentIndex);
	
		
		var nextButtonVal =  deliveryStatusArray[currentIndex];
		
		if(nextButtonVal == "undefined"){
				nextButtonVal = deliveryStatusArray[0];
		}
 
	var nextDelButtonHTML = ""; 
	
	if(currentIndex < deliveryStatusArray.length){
		nextDelButtonHTML = "<input type='button' value='"+nextButtonVal+"' class='expbutton' onclick=\"updateOrderAsDelivered('deliveryStatus','"+nextButtonVal+"',"+row["orderId"]+", this)\" />"; 
	
	}
	
	var addressmarkup = "";
	var deliveryDate = "";
	var actualdeliveryDate = "";
	var location = "";
	var sellermarkup = "";
	var phonemarkup = "";
	var pincodemarkup = "";
	var refmarkup = "";
	
	
 	if(role.toLowerCase() != "admin" && role.toLowerCase() != "superadmin"){
		addressmarkup = row["address"];
		deliveryDate = row["expectedDeliverDate"];
		actualdeliveryDate = row["actualexpectedDeliverDate"];
		location = row["location"];
		sellermarkup = row["seller"];
		phonemarkup = row["phone"];
		pincodemarkup = row["pincode"];
		refmarkup = row["paymentRef"];
	}else{
		
//		addressmarkup = getTextArea(row["orderId"], row["address"], "address");
//		deliveryDate = getTextArea(row["orderId"], row["expectedDeliverDate"], "expectedDeliverDate");
//		actualdeliveryDate = getTextArea(row["orderId"], row["actualexpectedDeliverDate"], "actualexpectedDeliverDate");
		
		addressmarkup = getInputText(row["orderId"], row["address"], "address");
		deliveryDate = getInputText(row["orderId"], row["expectedDeliverDate"], "expectedDeliverDate");
		actualdeliveryDate = getInputText(row["orderId"], row["actualexpectedDeliverDate"], "actualexpectedDeliverDate");
		location = "Current Location: <b>"+row["location"]+"</b><br /><br />Change to : "+getLocationDDL(row["orderId"], row["locationId"]);
		
		sellermarkup = getInputText(row["orderId"], row["seller"], "seller");
		phonemarkup = getInputText(row["orderId"], row["phone"], "phone");
		pincodemarkup = getInputText(row["orderId"], row["pincode"], "pincode");
		refmarkup = getInputText(row["orderId"], row["paymentRef"], "paymentRef");
 	 
	}
	
	
	
	
	var maplocation = "";
	if(row["latlan"] != ""){
		maplocation = "<br/><a href='https://maps.google.com/maps?q="+row["latlan"]+"' target='_blank'>Package Location</a>";
	}
	if(row["deliveryStatus"] == null || row["deliveryStatus"] == ""){
		row["deliveryStatus"] = "Packing Pending";	
	}
	if(row["actualDeliveryDate"] == null || row["actualDeliveryDate"] == ""){
		row["actualDeliveryDate"] = "";	
	}
	if(row["paymentDate"] == null || row["paymentDate"] == ""){
		row["paymentDate"] = "";	
	}
	if(row["paymentInfo"] == null || row["paymentInfo"] == ""){
		row["paymentInfo"] = "";	
	}
	if(row["opRemark"] == null || row["opRemark"] == ""){
		row["opRemark"] = "";	
	}
	
	var commentsMarkup ="DEF";
	if(row["comments"] != ""){
		commentsMarkup = "<a href='javascript:void(0)' onclick='showLogDetails(\""+row["comments"]+"\")'>Logs</a>";	
	}else{
		commentsMarkup = "";	
		
	}
	
	
	var cartOrderMarkup ="";
	if(row["cartOrderId"] != "" && row["cartOrderId"] != null && row["cartOrderId"] !== "0"){
		cartOrderMarkup = "<br />Cart Order Id : "+row["cartOrderId"];
		
		if(row["cartUrl"] != "" && row["cartUrl"] != null){
			cartOrderMarkup += "<br/><a href='"+row["cartUrl"]+"' target='_blank'>"+row["cartUrl"]+"<a/>";		
		}
	}else{
		cartOrderMarkup = "";	
	}
	
	
	var accountMarkup ="";
//	if(row["trancount"] != "0"){
	if(1==1){		
		accountMarkup = " <br /><a href='javascript:void(0)' onclick='showAccountSnap("+row["orderId"]+")'>Accounts</a>";
	}else{
		accountMarkup = "";	
	}
	
	
	var productTotal = 0; 
	for(var i=0;i<row["products"].length;i++){
		productTotal += parseInt(row["products"][i]["qty"]) * parseInt(row["products"][i]["costPerItem"]);
	} 
	// SINCE ORDER TOTAL IS COMING NOW FROM ORDERS TABLE ITSELF, WE DON'T NEED ABOVE DYNAMIC CALCULATION BUT KEEPING IT FOR FUTURE REF.
	//	productTotal = row["orderTotal"];
	

	 
	var markup = "<tr> \
		<td align='center'>Current Status: <br/><b class='statuscss' style='font-size:28px;padding:5px;'>"+row["deliveryStatus"]+"</b>"+maplocation+"<hr/>Choose New Status :<span class='delbuttoncontainer'>"+nextDelButtonHTML+"</span> \
		<br /><br />"+getDeliveryStatusDDL(row["orderId"], row["deliveryStatus"], false) +"<br/><br/><input type='button' style='display:none;"+hideDelivered+"' value='Delivered Now' class='expbuttonlarge' onclick=\"updateOrderAsDelivered('deliveryStatus','Delivered',"+row["orderId"]+", this)\" /> \
		</td> \
		<td>"+row["customerName"]+"<br />"+row["email"]+"<br /><a href='javascript:void(0)' onclick='searchForMobile("+row["phone"]+")'>"+row["phone"]+"</a><br />"+row["address"]+"<br />"+row["location"]+"<br/>"+row["pincode"]+" \
		<br /><a href='https://maps.google.com/maps?q="+row["address"]+"' target='_blank'>Customer Location</a></td> \
		<td>"+getGroupDDL(row["orderId"],selectedGroup,false)+"   \
		<br /><br /> "+getDriverDDL(row["orderId"],selectedDriver)+" \
		<br /><br /> "+getPackerDDL(row["orderId"],selectedPacker)+"</td> \
		<td>"+getInputText(row["orderId"], row["actualLocation"], "actualLocation")+" \
		<br /><br />"+getInputText(row["orderId"], row["actualDeliveryDate"], "actualDeliveryDate")+"</td>\
		<td><span>Ref No- </span><b>"+row["paymentRef"]+"</b> \
		 	<br /><span>Pay Date.-</span>"+getInputText(row["orderId"], row["paymentDate"], "paymentDate")+" \
		    <span>Pay Info-</span>"+getInputText(row["orderId"], row["paymentInfo"], "paymentInfo")+"\
		    <span>Status -</span>"+getPaymentStatusDDL(row["orderId"], row["paymentStatus"], false)+"\
		    <span>Order Total - <b>"+productTotal+"</b></span></td>\
		<td>"+getTextArea(row["orderId"], row["opRemark"], "opRemark")+"</td>\
		<td>Form Order Id :"+row["orderId"]+accountMarkup+" \
		"+cartOrderMarkup+"</td> \
		<td>"+row["timestamp"]+"<br /><br />"+row["expectedDeliverDate"]+"</td> \
		<td>"+sellermarkup+"</td> \
		<td>"+pincodemarkup+"</td> \
		<td>"+phonemarkup+"</td> \
		<td>"+addressmarkup+"</td> \
		<td>"+row["paymentRef"]+"</td> \
		<td>"+location+"</td> \
		<td>Expected Delivery - "+deliveryDate+"<br /><br />Planned Delivery"+actualdeliveryDate+"</td> \
		<td class='commentsA'>"+commentsMarkup+"</td> ";
		
		
		
		for(var j = 0;j<products.length;j++){
			var qty = "0";
			if(role.toLowerCase() == "superadmin"){
				qty = getQtyInputText(row["orderId"], "0", products[j]["productId"]);	
			}else{
				qty = "0";
			}
			
			for(var i=0;i<row["products"].length;i++){
				var obj = row["products"][i];
//				if(obj["shortTitle"] == products[j]["shortTitle"] ){
				if(obj["productId"] == products[j]["productId"] ){
					if(role.toLowerCase() == "superadmin"){
						qty = getQtyInputText(row["orderId"], obj["qty"], products[j]["productId"]);	
					}else{
						qty = obj["qty"];

					}
				}
				 
			}
	
			markup = markup + "<td>"+qty+"</td> ";
			 
		}

	//	markup = markup + "<td class='logs' width='200px'>"+row["userlogs"]+"</td>";
	if(row["userlogs"] != ""){
		markup = markup + "<td class='logs1' width='200px'><a href='javascript:void(0)' onclick='showLogDetails(\""+row["userlogs"]+"\")'>Logs</a></td>";	
	}else{
		markup = markup + "<td class='logs1' width='200px'></td>";	
		
	}
	
		markup = markup + "</tr>";

//	$("#tblOrders").append(markup);	
	$("#tblOrders tbody").append(markup);
	clickhandled();
}

function showAccountSnap(orderId){
	
	var searchparam = "";
	
	searchparam += "&orderId="+orderId;	
	searchparam += "&tranfrom=";	
	searchparam += "&tranto=";	
		
var current_date = new Date()
				
	var xhr = $.getJSON("api.php?action=transactions&pageno=0&recordsperpage=100"+searchparam+"&curtime="+current_date.getMilliseconds(), function(result) 	{ 
		
	 	var totalRecords =  xhr.getResponseHeader('totalrecs');
		
		var snapshot = "";
		
		for(var i=0;i<result.length;i++){
			snapshot+=result[i]["trandate_formatted"]+"-";
			snapshot+=result[i]["narration"]+"-";
			snapshot+=result[i]["chqno"]+"-";
			snapshot+=result[i]["valueDate_formatted"]+"-";
			if(result[i]["withdrawalAmt"] != "0"){
				snapshot+="Withdrawal:"+result[i]["withdrawalAmt"]+"-";				
			}
			if(result[i]["despositAmt"] != "0"){
				snapshot+="Deposit:"+result[i]["depositAmt"];				
			}
			if(result[i]["userId"] != "0"){
				snapshot+=" by "+result[i]["tranby"];
			}
			if(result[i]["groupId"] != "0"){
				snapshot+=" in the group "+result[i]["groupby"];
			}
			if(result[i]["subgroupId"] != "0"){
				snapshot+=" -> "+result[i]["subgroupby"]+"-";
			}
			snapshot+="<br />";


		}

			snapshot+="<br /><a href='javascript:void(0)' onclick='$(\"#divAccountsSnap\").html(\"\")'>Hide</a>";
		
		$("#divAccountsSnap").html(snapshot);
		
	});
}


function searchForMobile(mobile){
$("#txtFetchDeliveryDate").val(mobile);unplanned=false;unlisted=false;searchgrid();	
}

function searchForTransaction(orderId){
	showDiv('divTransaction');
	setTimeout(function(){ 	
		$("#txtTranAny").val(orderId);pageno_transaction=0;getTransactions(true);
	}, 2000);
	 
		
}
function getInputText(orderId, text, type){
	var html = "<input type='text' value='"+text+"' data-original='"+text+"' alt='"+text+"' onblur=\"updateOrderExtended('"+type+"',this,"+orderId+")\" class='inputtxt1'/>";
	return html;
}
function getQtyInputText(orderId, text, productId){
	var html = "<input type='text' value='"+text+"'  data-original='"+text+"'  alt='"+text+"'  onblur=\"updateOrderQty('"+productId+"',this,"+orderId+")\" style='width:50px;font-size:20pt;' />";
	return html;
}
function getTransOrderIdInputText(transactionId, text){
	var html = "<input type='text' value='"+text+"' style='width:50px;font-size:12pt;' onblur=\"updateTransaction('orderId',this,"+transactionId+",'')\"/>";
	return html;
}

function getTextArea(orderId, text, type){
	var html = "<textarea   data-original='"+text+"'   col=20 onblur=\"updateOrderExtended('"+type+"',this,"+orderId+")\" class='txtbox' >"+text+"</textarea>";
	return html;
}
function getTextAreamobile(orderId, text, type){
	var html = "<textarea placeholder='Comments'   data-original='"+text+"'   col=20 onblur=\"updateOrderExtended('"+type+"',this,"+orderId+")\" class='txtbox2' >"+text+"</textarea>";
	return html;
}
function getTextAreaLogs(orderId, text, type){
	var html = "<textarea  data-original='"+text+"'   col=30 onblur=\"updateLogs('"+type+"',this,"+orderId+")\" class='txtbox' >"+text+"</textarea>";
	return html;
}
 

function getDriverDDL(orderId, selected){
	var html = "<select onchange=\"updateOrder('driverId',this.value,'"+orderId+"',false)\">";
			
		html += "<option value=0>Driver</option>";

		for(var i=0;i<drivers.length;i++){
			
			var sel = "";
			if(drivers[i]["driverId"] == selected){
				sel = "selected";	
			}
			html += "<option "+sel+" value="+drivers[i]["driverId"]+">"+drivers[i]["driverName"]+"</option>";
		}
	
	html += "</select>";	
	return html;
}

function getLocationDDL(orderId, selected){
	var html = "<select onchange=\"updateOrder('locationId',this.value,'"+orderId+"',false)\" style='width:130px;'>";
			
		html += "<option value=0>Location</option>";

		for(var i=0;i<locations.length;i++){
			
			var sel = "";
			if(locations[i]["locationId"] == selected){
				sel = "selected";	
			}
			html += "<option "+sel+" value="+locations[i]["locationId"]+">"+locations[i]["location"]+"</option>";
		}
	
	html += "</select>";	
	return html;
}


function getPackerDDL(orderId, selected){
	var html = "<select onchange=\"updateOrderExtended('packerId',this,'"+orderId+"')\">";
	 
		html += "<option value=0>Packer</option>";

		for(var i=0;i<packers.length;i++){
			
			var sel = "";
			if(packers[i]["userId"] == selected){
				sel = "selected";	
			}
			html += "<option "+sel+" value="+packers[i]["userId"]+">"+packers[i]["fullname"]+"</option>";
		}
	
	html += "</select>";	
	return html;
}


function getGroupDDL(orderId, selected, addDriver){
	 
	var html = "<select onchange=\"updateOrder('groupId',this.value,'"+orderId+"',"+addDriver+")\">";
		
		html += "<option value=0>Group</option>";
		
		for(var a=0;a<groups.length;a++){
			var sel = "";
					
			if(groups[a]["groupId"].toString() == (selected)){
				sel = "selected";	
			}
			html += "<option "+sel+"  value='"+groups[a]["groupId"]+"'>"+groups[a]["groupName"]+"</option>";
		}
	
	html += "</select>";
	
	 
	 
		
	return html;
}


function getDeliveryStatusDDL(orderId, selected, addDriver){
	 
	 
	var html = "<select  data-original='"+selected+"'  alt='"+selected+"' onchange=\"updateOrderExtended('deliveryStatus',this,"+orderId+")\" >";
		
		html += "<option>Status</option>";
		 
		
		for(var a=0;a<deliveryStatusArray.length;a++){
			var sel = "";
			//console.log(deliveryStatusArray[a].toString() +":"+ (selected)+":"+orderId);		
			if(deliveryStatusArray[a].toString() === selected){
				sel = "selected";	
			}
			html += "<option "+sel+"  value='"+deliveryStatusArray[a]+"'>"+deliveryStatusArray[a]+"</option>";
		}
	
	html += "</select>";
	
	 
	 
		
	return html;
}



function getPaymentStatusDDL(orderId, selected, addDriver){
	 
	var paymentStatusArray = Array();
	 paymentStatusArray.push('Pending Verification');
	 paymentStatusArray.push('Verified Paid');
	 paymentStatusArray.push('Cancelled');
	 paymentStatusArray.push('Pending');
	 paymentStatusArray.push('Other'); 
	 
	var html = "<select onchange=\"updateOrderExtended('paymentStatus',this,'"+orderId+"')\">";
		
		html += "<option>Payment Status</option>";
		 
		
		for(var a=0;a<paymentStatusArray.length;a++){
			var sel = "";
					
			if(paymentStatusArray[a].toString() === selected){
				sel = "selected";	
			}
			html += "<option "+sel+"  value='"+paymentStatusArray[a]+"'>"+paymentStatusArray[a]+"</option>";
		}
	
	html += "</select>";
	
	 
	 
		
	return html;
}

//getCalcGroupDDL(row["transactionId"], row["groupId"], 0, row["subgroupId"])
function getCalcGroupDDL(transactionId, selected, parentId, subgroupId){
	var html = "";

		if(parentId == 0){
			html += "<select style='width:100px;' onchange=\"updateTransaction('groupId',this,"+transactionId+","+subgroupId+")\">";
			html += "<option value=0>Group</option>";
		}else{
			html += "<select style='width:100px;' onchange=\"updateTransaction('subgroupId',this,"+transactionId+","+subgroupId+")\">";
			html += "<option value=0>Sub Group</option>";
		}

		for(var i=0;i<calcgroup.length;i++){
			
			var sel = "";
			if(calcgroup[i]["calcgroupId"] == selected){
				sel = "selected";
			}
			
			if(calcgroup[i]["parentId"] == parentId){
				html += "<option "+sel+" value="+calcgroup[i]["calcgroupId"]+">"+calcgroup[i]["calcgroup"]+"</option>";
			}
		}
	
	html += "</select>";	
	return html;
}


function getTranMapGroup(mapId, selected, parentId, subgroupId){
	var html = "";
 
		if(parentId == 0){
			html += "<select style='width:100px;' onchange=\"updateTransactionMap('groupId',this,"+mapId+","+subgroupId+")\">";
			html += "<option value=0>Group</option>";
		}else{
			html += "<select style='width:100px;' onchange=\"updateTransactionMap('subgroupId',this,"+mapId+","+subgroupId+")\">";
			html += "<option value=0>Sub Group</option>";
		}

		for(var i=0;i<calcgroup.length;i++){
			
			var sel = "";
			if(calcgroup[i]["calcgroupId"] == selected){
				sel = "selected";
			}
			
			if(calcgroup[i]["parentId"] == parentId){
				html += "<option "+sel+" value="+calcgroup[i]["calcgroupId"]+">"+calcgroup[i]["calcgroup"]+"</option>";
			}
		}
	
	html += "</select>";	
	return html;
}


function getTranUserDDL(transactionId, selected){
	var html = "";

	html += "<select style='width:100px;' onchange=\"updateTransaction('userId',this,"+transactionId+",0)\">";
	html += "<option value=0>Users</option>";

		for(var i=0;i<users.length;i++){
			
			var sel = "";
			if(users[i]["userId"] == selected){
				sel = "selected";
			}
			
			html += "<option "+sel+" value="+users[i]["userId"]+">"+users[i]["fullname"]+"</option>";
		}
	
	html += "</select>";	
	return html;
}


function getTranMapUserDDL(mapId, selected){
	var html = "";

	html += "<select style='width:250px;' onchange=\"updateTransactionMap('userId',this,"+mapId+",0)\">";
	html += "<option value=0>Users</option>";

		for(var i=0;i<users.length;i++){
			
			var sel = "";
			if(users[i]["userId"] == selected){
				sel = "selected";
			}
			
			html += "<option "+sel+" value="+users[i]["userId"]+">"+users[i]["fullname"]+"</option>";
		}
	
	html += "</select>";	
	return html;
}


function updateOrder(key,obj,orderId,addDriver){
	
		

	if(obj.value == 0){
		alert("Please select option");	
	}else{
		var current_date = new Date()
		var url = 'api.php?action=updateOrder&'+key+"="+obj+"&orderId="+orderId+"&curtime="+current_date.getMilliseconds();
		 
		 
		 if(addDriver){
				$("#spanDriver").html(getDriverDDL(selectedOrders.toString(), "", true));		 
		 } 
		 
		$.getJSON(url, function(result) { 
		
				 
			})
	
	}
	 
	
	
}

function updateTransaction(key,obj,transactionId, subgroupId){
	 		 
	var current_date = new Date()

	var url = 'api.php?action=updateTransaction&key='+key+"&val="+obj.value.replace(/#/g, "-")+"&transactionId="+transactionId+"&curtime="+current_date.getMilliseconds();
	 
	$.getJSON(url, function(result) { 
		if(key == "groupId"){
			var markup = getCalcGroupDDL(transactionId, subgroupId, obj.value, subgroupId);
			$(obj).closest("tr").find('#tdSubGroup').html(markup) ;
			
		
		}
	});
}


function updateOrderExtended(key,obj,orderId){
			 
			var original = obj.alt;
			if(original == null){
				original = $(obj).attr("data-original");	
			}
			
			 
	 		if(obj.value != "Status"){
				 var current_date = new Date()

				var url = 'api.php?action=updateOrderExtended&key='+key+"&val="+obj.value.replace(/#/g, "-")+"&orderId="+orderId+"&curtime="+current_date.getMilliseconds();
				 
				$.getJSON(url, function(result) { 
							//getOrders(true);
							console.log(">>> RE:"+original === obj.value);
							if(original !== obj.value){
								updateLogs(key+" changed to "+obj.value,orderId, $(obj).closest("td"));
							}
							
							
			
			
			
							var nextButtonVal='';
							var currentIndex = deliveryStatusArray.indexOf(obj.value); 
							if(obj.value == "-1" || obj.value == null || obj.value == "" || obj.value == "null"){
								currentIndex = 1;
							}else{
								currentIndex = currentIndex+1;
							}
							var nextButtonVal =  deliveryStatusArray[currentIndex];
							if(nextButtonVal == "undefined"){
									nextButtonVal = deliveryStatusArray[0];
							}
							var nextDelButtonHTML = ""; 
							var nextDelButtonHTML = ""; 
							
							if(currentIndex < deliveryStatusArray.length){
								nextDelButtonHTML = "<input type='button' value='"+nextButtonVal+"' class='expbutton' onclick=\"updateOrderAsDelivered('deliveryStatus','"+nextButtonVal+"',"+orderId+", this)\" />"; 
							}
			
							$(obj).closest("td").find('.statuscss').html(obj.value) //.css( "background-color", "red" );
							$(obj).closest("td").find('.delbuttoncontainer').html(nextDelButtonHTML) //.css( "background-color", "red" );
			
							if(key == "opRemark"){
								
								var months = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
								var d = new Date();
								var currentDate = d.getDate()+"-"+months[d.getMonth()]+"-"+d.getFullYear()+" "+d.getHours()+":"+d.getMinutes();
								var val = obj.value;
								val += "<br />"+fullname+" - "+currentDate+'<br /><br />';
								updateOrderComments("comments",val,orderId);
								$(obj).closest("tr").find('.comments').html(val+""+$(obj).closest("tr").find('.comments').html()) ;
			
							}
							
							updateLocation(orderId);
					})
			}
			
}


function updateOrderComments(key,obj,orderId){
			 var current_date = new Date()

	var url = 'api.php?action=updateComment&val='+obj+'&orderId='+orderId+"&curtime="+current_date.getMilliseconds();
	 
	$.getJSON(url, function(result) { 
				 
		})
}


function updateLogs(logs,orderId, child){
	
	
	
	var current_date = new Date()
	logs += " by <b>"+fullname+" - "+current_date.toLocaleString()+'</b><br /><br />';

	var url = 'api.php?action=updateLogs&val='+logs+'&orderId='+orderId+"&curtime="+current_date.getMilliseconds();
	 
	 
	 
	
		$(child).closest("tr").find('.logs').html(logs+""+$(child).closest("tr").find('.logs').html()) ;
	
		
	$.getJSON(url, function(result) { 
		
			
				 
		})
}


function updateOrderQty(productId,obj,orderId){
	
	 var td = $(obj).closest('td');	
	 var selectobj = td.find('select');
	
		var original = obj.alt;
		if(original == null){
			original = $(obj).attr("data-original");	
		}
	
	if(obj.value.trim() != "" &&  !isNaN(obj.value.trim())){
	var current_date = new Date()

		var url = 'api.php?action=updateOrderProduct&productId='+productId+"&val="+obj.value.trim()+"&orderId="+orderId+"&curtime="+current_date.getMilliseconds();
		 
		 if(original !== obj.value){
			 $(obj).attr("data-original",obj.val);
		 	updateLogs("Product "+productId+" : Qty changed to "+obj.value.trim(),orderId, $(obj).closest('td'))
		 }

		$.getJSON(url, function(result) { 
					//getOrders(true);
					//updateLocation(orderId);
			})	
	}
	
}


function updateOrderAsDelivered(key,status,orderId, button){
	//		 alert(status);
	 var td = $(button).closest('td');	
	 var selectobj = td.find('select');
	 
	var currentIndex = deliveryStatusArray.indexOf(selectobj.val()); 
		console.log(currentIndex);
		if(selectobj.val() == "-1"){
			currentIndex = 0;
		}else{
			currentIndex = currentIndex+1;
		}
	
	var nextButtonVal =  deliveryStatusArray[currentIndex];
	
	if(nextButtonVal == "undefined"){
			nextButtonVal = deliveryStatusArray[0];
	}		 
	
	status = nextButtonVal;
	
	var current_date = new Date()		 
	var url = 'api.php?action=updateOrderExtended&key='+key+"&val="+status+"&orderId="+orderId+"&curtime="+current_date.getMilliseconds();
	 
	$.getJSON(url, function(result) { 

			console.log("***");
			console.log($(button).closest('td'));
			updateLogs("deliveryStatus changed to "+status,orderId, $(button).closest('td'))

		    var td = $(button).closest('td');
			
			$(button).closest("td").find('.statuscss').html(status) //.css( "background-color", "red" );
			
			var currentIndex = deliveryStatusArray.indexOf(status); 
			if(status == "-1"){
				currentIndex = 0;
			}else{
				currentIndex = currentIndex+1;
			}
		
			var nextButtonVal =  deliveryStatusArray[currentIndex];
			
			$(button).attr('value', nextButtonVal); 
			
			td.find('select').val(status);
			//$(button).hide();
			updateLocation(orderId);
			 
		})
}


function showDiv(div){
		hideAll();
		$("#"+div).show();
//		if(div == "divTransaction" && role == "SUPERADMIN"){
		if(div == "divTransaction"){			
			$("#divTransactionContainer").show();
		}
		
		readGroupLocation();
		readGroupDriver();
		readGroupPacker();
		readUser();
		readGroup();
		readLocation();
		readTransactionMap();
		readProducts();
		readCalcGroup();		
		
		pageno_transaction = -1;
		getTransactions(true);
}

function hideAll(){
	$("#divGoogleToConsolidated").hide();
	$("#divConsolidatedToReport").hide();
	$("#divGoogletoDB").hide();
	$("#divGroupLocation").hide();
	$("#divGroupDriver").hide();
	$("#divGroupPacker").hide();
	$("#divUsers").hide();
	$("#divOrders").hide();
	$("#divGroups").hide();
	$("#divLocations").hide();
	$("#divTransaction").hide();
	$("#divTransactionMapping").hide();
	$("#divCalcGroup").hide();	
	$("#divTransactionContainer").hide();
	$("#divProducts").hide();
 	
}

function saveGroupLocation(){ 
	
	var current_date = new Date()

	var url = 'api.php?action=addgrouplocation&selLocation='+$("#selLocation1").val()+'&selGroup='+$("#selGroup1").val()+"&curtime="+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		 
		readGroupLocation();
	})
}



function readGroupLocation(){

	var current_date = new Date()
 
	$.getJSON('api.php?action=grouplocation'+"&curtime="+current_date.getMilliseconds()+"&groupId="+$("#selFilterGroup").val(), function(result) { 
	
		 
	
		   $("#tblGroupLocation").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
						<td>"+result[i]["location"]+"</td> \
						<td>"+result[i]["groupName"]+"</td> \
						<td><input type='text' style='width:100px;' value='"+result[i]["locationpriority"]+"' onblur='updateGroupLocationSequence(this,"+result[i]["id"]+")'  /></td> \
						<td><a href=\"javascript:void(0)\" onclick='if(confirm(\"are you sure?\")){deleteGroupLocation("+result[i]["id"]+")}'>Delete</a></td> ";
					markup = markup + "</tr>";
				}
			$("#tblGroupLocation").append(markup);	

	});
}

function updateGroupLocationSequence(obj,mapId){

	var current_date = new Date()
	
	$.getJSON('api.php?action=updategrouplocationpriority'+"&curtime="+current_date.getMilliseconds()+"&priority="+$(obj).val()+"&id="+mapId, function(result) { 

	});
}

function deleteGroupLocation(id){
var current_date = new Date()

 	$.getJSON('api.php?action=deletegrouplocation&id='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
	 readGroupLocation();	
	});
}













function saveTransactionMap(){ 
	
	if($("#txtStatementKeyword").val().trim() != ""){
	
		var current_date = new Date()
	
		var url = 'api.php?action=addTransactionMapping&userId='+$("#selTranUsers").val()+'&statementkeyword='+$("#txtStatementKeyword").val()+'&curtime='+current_date.getMilliseconds();
	
		$.getJSON(url, function(result) { 
			 
			readTransactionMap();
		})
		
	}else{
		alert("Please provide Keyword for mapping");	
	}
	
	
}



function readTransactionMap(){

	var current_date = new Date()
 
	$.getJSON('api.php?action=readTransactionMapping'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 
	
		   $("#tblTransactionMap").find("tr:gt(0)").remove();
			var markup = "";
			
			
		//	getTranMapGroup(mapId, selected, parentId, subgroupId)
			
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
						<td>"+getTranMapUserDDL(result[i]["id"],result[i]["userId"])+"</td> \
						<td>"+getTranMapGroup(result[i]["id"], result[i]["groupId"], "0", result[i]["subgroupId"])+"</td> \
						<td id='tdSubGroupMap'>"+getTranMapGroup(result[i]["id"], result[i]["subgroupId"], result[i]["groupId"], result[i]["subgroupId"])+"</td> \
						<td><input type='text' onblur='updateTransactionMap(\"statementkeyword\",this,"+result[i]['id']+",0)' value='"+result[i]["statementkeyword"]+"' /></td> \
						<td><a href=\"javascript:void(0)\" onclick='if(confirm(\"are you sure?\")){deleteTransactionMap("+result[i]["id"]+")}'>Delete</a></td> ";
					markup = markup + "</tr>";
				}
			$("#tblTransactionMap").append(markup);	

	});
}

function updateTransactionMap(key,obj,mapId, subgroupId){

	var current_date = new Date()
	
	$.getJSON('api.php?action=updateTransactionMapping'+"&curtime="+current_date.getMilliseconds()+"&val="+$(obj).val()+"&key="+key+"&id="+mapId, function(result) { 
		if(key == "groupId"){
			var markup = getTranMapGroup(mapId, subgroupId, obj.value, subgroupId);
			$(obj).closest("tr").find('#tdSubGroupMap').html(markup) ;
			
		
		}
	

	});
}

function deleteTransactionMap(id){
var current_date = new Date()

 	$.getJSON('api.php?action=deleteTransactionMapping&id='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
	 readTransactionMap();	
	});
}






function saveGroup(){ 
	
	var current_date = new Date()

	var url = 'api.php?action=addgroup&groupname='+$("#txtGroupName").val()+'&priority='+$("#txtGroupPriority").val()+"&curtime="+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		 
		readGroup();
	})
}



function readGroup(){

	var current_date = new Date()
 
	$.getJSON('api.php?action=groups'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 
	
		   $("#tblGroup").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
						<td><input type='text' style='width:500px;' value='"+result[i]["groupName"]+"' onblur='updateGroup(\"groupName\",this,"+result[i]["groupId"]+")'  /></td> \
						<td><input type='text' style='width:100px;' value='"+result[i]["priority"]+"' onblur='updateGroup(\"priority\",this,"+result[i]["groupId"]+")'  /></td> \
						<td><a href=\"javascript:void(0)\" onclick='if(confirm(\"are you sure?\")){deleteGroup("+result[i]["groupId"]+")}'>Delete</a></td> ";
					markup = markup + "</tr>";
				}
			$("#tblGroup").append(markup);	

	});
}

function updateGroup(key,obj,mapId){

	var current_date = new Date()
	
	$.getJSON('api.php?action=updategroup'+"&curtime="+current_date.getMilliseconds()+"&key="+key+"&val="+$(obj).val()+"&groupId="+mapId, function(result) { 

	});
}

function deleteGroup(id){
var current_date = new Date()

 	$.getJSON('api.php?action=deletegroup&groupId='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
	 readGroup();	
	});
}









function saveLocation(){ 
	
	var current_date = new Date()

	var url = 'api.php?action=addlocation&locationname='+$("#txtLocationName").val()+"&curtime="+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		 
		readLocation();
	})
}



function readLocation(){

	var current_date = new Date()
 
	$.getJSON('api.php?action=locations'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 
	
		   $("#tblLocation").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
						<td><input type='text' style='width:500px;' value='"+result[i]["location"]+"' onblur='updateLocationDB(\"location\",this,"+result[i]["locationId"]+")'  /></td> \
						<td><a href=\"javascript:void(0)\" onclick='if(confirm(\"are you sure?\")){deleteLocation("+result[i]["locationId"]+")}'>Delete</a></td> ";
					markup = markup + "</tr>";
				}
			$("#tblLocation").append(markup);	

	});
}


function updateLocationDB(key,obj,mapId){

	var current_date = new Date()
	
	$.getJSON('api.php?action=updatelocation'+"&curtime="+current_date.getMilliseconds()+"&key="+key+"&val="+$(obj).val()+"&locationId="+mapId, function(result) { 

	});
}

 

function deleteLocation(id){
var current_date = new Date()

 	$.getJSON('api.php?action=deletelocation&locationId='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
	 readLocation();	
	});
}




function saveProduct(){ 
	var validate = true;
	
	if($("#txtName").val().trim() == "" || $("#txtDetails").val().trim() == "" || $("#txtCellIndex").val().trim() == "" || $("#txtShortTitle").val().trim() == "" || $("#txtCost").val().trim() == ""){
		alert("Please provide complete details of Product");
		validate = false;
	}
	
	if(isNaN($("#txtCellIndex").val())){
		alert("Cell Index can not be Alphanumeric");
		validate = false;	
	}
	
	if(isNaN($("#txtCost").val())){
		alert("Product Cost can not be Alphanumeric");
		validate = false;	
	}
	
	
	if(validate){
		var current_date = new Date()
	
		var param = "";
		param += "&productName="+$("#txtName").val();
		param += "&productDetails="+$("#txtDetails").val();
		param += "&cellIndex="+$("#txtCellIndex").val();
		param += "&shortTitle="+$("#txtShortTitle").val();
		param += "&costPerItem="+$("#txtCost").val();
		param += "&carturl=fiveminutes.in/reports/";
		param += "&cartproductid=0";
	
		var url = 'api.php?action=addproduct'+param+'&curtime='+current_date.getMilliseconds();
	
		$.getJSON(url, function(result) { 
			 
			$("#txtName").val(""); 
			$("#txtDetails").val(""); 
			$("#txtCellIndex").val(""); 
			$("#txtShortTitle").val(""); 
			$("#txtCost").val(""); 
			readProducts();
		})
		
	}
}


function readCalcGroup(){

	var current_date = new Date()
 
	$.getJSON('api.php?action=calcgroup'+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
		 	var arrParent = Array();
			for(var i=0;i<result.length;i++){
				if(result[i]["parentId"] == "0"){
					arrParent.push(result[i]);	
				}
			}
			
		   $("#tblCalcgroup").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					
					if(result[i]["parentId"] == "0"){
						var checked = "";
						if(result[i]["isPSP"] == "1"){
							checked = "checked";
						}
					markup += "<tr style='background-color:#e1e1e1'> \
	<td><input type='radio' "+checked+" name='rdPSP' value='1' onchange='updateCalcGroup(\"isPSP\",this,"+result[i]["calcgroupId"]+")'/></td>\
	<td><input type='text' value='"+result[i]["calcgroup"]+"' onblur='updateCalcGroup(\"calcgroup\",this,"+result[i]["calcgroupId"]+")'/></td> \
	<td>"+getCalcParentDDL(arrParent, result[i]["calcgroupId"], result[i]["parentId"])+"</td> \
	<td><input type='text' value='"+result[i]["perValue"]+"' onblur='updateCalcGroup(\"perValue\",this,"+result[i]["calcgroupId"]+")'/></td> \
	<td><input type='text' value='"+result[i]["calcdescription"]+"' onblur='updateCalcGroup(\"calcdescription\",this,"+result[i]["calcgroupId"]+")'/></td> \
	<td><input type='text' value='"+result[i]["calcprofit"]+"' onblur='updateCalcGroup(\"calcprofit\",this,"+result[i]["calcgroupId"]+")'/></td> \
	";
					markup = markup + "</tr>";
					
					for(var j=0;j<result.length;j++){					

						if(result[j]["parentId"] == result[i]["calcgroupId"]){
						
					markup += "<tr> \
	<td></td><td>&nbsp;&nbsp;&nbsp;&nbsp;<input type='text' value='"+result[j]["calcgroup"]+"' onblur='updateCalcGroup(\"calcgroup\",this,"+result[j]["calcgroupId"]+")'/></td> \
	<td>&nbsp;&nbsp;&nbsp;&nbsp;"+getCalcParentDDL(arrParent, result[j]["calcgroupId"], result[j]["parentId"])+"</td> \
	<td>&nbsp;&nbsp;&nbsp;&nbsp;<input type='text' value='"+result[j]["perValue"]+"' onblur='updateCalcGroup(\"perValue\",this,"+result[j]["calcgroupId"]+")'/></td> \
		<td><input type='text' value='"+result[j]["calcdescription"]+"' onblur='updateCalcGroup(\"calcdescription\",this,"+result[j]["calcgroupId"]+")'/></td> \
	<td><input type='text' value='"+result[j]["calcprofit"]+"' onblur='updateCalcGroup(\"calcprofit\",this,"+result[j]["calcgroupId"]+")'/></td> \
	";
					markup = markup + "</tr>";
						}

						
					}
						
					}
					
					
				}
			$("#tblCalcgroup").append(markup);	

	});
}
 
function updateCalcGroup(key,obj,calcgroupId){

	if($(obj).val() != ""){

		var current_date = new Date()
		
		$.getJSON('api.php?action=updatecalcgroup'+"&curtime="+current_date.getMilliseconds()+"&key="+key+"&val="+$(obj).val()+"&calcgroupId="+calcgroupId, function(result) { 
			 
			readCalcGroup();
		});
		
	}
	else{
		alert("Field can not be empty");	
	}
} 

function saveCalcGroup(){ 
	
	if($("#txtCalcGroup").val().trim() != "" && $("#txtCalcPer").val().trim() != ""){
	
		var current_date = new Date()
	
		var url = 'api.php?action=addcalcgroup&calcgroup='+$("#txtCalcGroup").val()+'&calcdescription='+$("#txtCalcDesc").val()+'&parentId='+$("#selPrentCalc").val()+'&perValue='+$("#txtCalcPer").val()+'&curtime='+current_date.getMilliseconds();
	
		$.getJSON(url, function(result) { 
			 
			readCalcGroup();
		})
		
	}else{
		alert("Please provide complete group details");	
	}
	
	
}

function getCalcParentDDL(arrParent, calcGroupId, selected){
	 
	var html = "<select onchange=\"updateCalcGroup('parentId',this,'"+calcGroupId+"')\">";
		
		html += "<option value=0>Parent Group</option>";
		
		for(var a=0;a<arrParent.length;a++){
			var sel = "";
					
			if(arrParent[a]["calcgroupId"].toString() == (selected)){
				sel = "selected";	
			}
			html += "<option "+sel+"  value='"+arrParent[a]["calcgroupId"]+"'>"+arrParent[a]["calcgroup"]+"</option>";
		}
	html += "</select>";
	return html;
}
 


function readProducts(){

	var current_date = new Date()
 
	$.getJSON('api.php?action=allproducts'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 
	
		   $("#tblProducts").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
<td><textarea disabled rows='1' cols='40' onblur='updateProduct(\"productname\",this,"+result[i]["productId"]+")' >"+result[i]["productname"]+"</textarea></td> \
<td><textarea disabled rows='1' cols='20' onblur='updateProduct(\"variant\",this,"+result[i]["productId"]+")' >"+result[i]["variant"]+"</textarea></td> \
<td><textarea disabled rows='5' cols='50' onblur='updateProduct(\"productdetails\",this,"+result[i]["productId"]+")' >"+result[i]["productdetails"]+"</textarea></td> \
<td><input disabled type='text' value='"+result[i]["cellIndex"]+"' onblur='updateProduct(\"cellIndex\",this,"+result[i]["productId"]+")'/></td> \
<td><input disabled type='text' value='"+result[i]["shortTitle"]+"' onblur='updateProduct(\"shortTitle\",this,"+result[i]["productId"]+")'/></td> \
<td><input disabled type='text' value='"+result[i]["costPerItem"]+"' onblur='updateProduct(\"costPerItem\",this,"+result[i]["productId"]+")'/></td> \
<td align='center'><small>(yyyy-mm-dd)</small><br /><input disabled type='text' value='"+result[i]["dateFrom"]+"' onblur='updateProduct(\"dateFrom\",this,"+result[i]["productId"]+")'/><br /> \
To <br /> <input disabled type='text' value='"+result[i]["dateTo"]+"' onblur='updateProduct(\"dateTo\",this,"+result[i]["productId"]+")'/><br /> </td> \
<td><input disabled type='text' value='"+result[i]["carturl"]+"' onblur='updateProduct(\"carturl\",this,"+result[i]["productId"]+")'/></td> \
<td><input disabled type='text' value='"+result[i]["cartProductId"]+"' onblur='updateProduct(\"cartProductId\",this,"+result[i]["productId"]+")'/></td> \
";
					markup = markup + "</tr>";
				}
			$("#tblProducts").append(markup);	

	});
}
 
function updateProduct(key,obj,mapId){

	if($(obj).val() != ""){

		var current_date = new Date()
		
		$.getJSON('api.php?action=updateproduct'+"&curtime="+current_date.getMilliseconds()+"&key="+key+"&val="+$(obj).val()+"&productId="+mapId, function(result) { 
	readProducts();
		});
		
	}
	else{
		alert("Field can not be empty");	
	}
}



function saveGroupDriver(){ 
	
	var current_date = new Date()
	var url = 'api.php?action=adddrivergroup&selDriver='+$("#selDriver2").val()+'&selGroup='+$("#selGroup2").val()+"&curtime="+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		 
		readGroupDriver();
	})
}



function readGroupDriver(){

	 var current_date = new Date()
	$.getJSON('api.php?action=groupdriver'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 
	
		   $("#tblGroupDriver").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
						<td>"+result[i]["driverName"]+"</td> \
						<td>"+result[i]["groupName"]+"</td> \
						<td><a href=\"javascript:void(0)\" onclick='if(confirm(\"are you sure?\")){deleteGroupDriver("+result[i]["id"]+")}'>Delete</a></td> ";
					markup = markup + "</tr>";
				}
			$("#tblGroupDriver").append(markup);	

	});
}

function deleteGroupDriver(id){
	 var current_date = new Date()
 	$.getJSON('api.php?action=deletedrivergroup&id='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
		 readGroupDriver();	
	});
}



function saveGroupPacker(){ 
	var current_date = new Date()
	var url = 'api.php?action=addpackergroup&selPacker='+$("#selPacker3").val()+'&selGroup='+$("#selGroup3").val()+"&curtime="+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		 
		readGroupPacker();
	})
}

function readGroupPacker(){

	 var current_date = new Date()
	$.getJSON('api.php?action=grouppacker'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 
	
		   $("#tblGroupPacker").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					markup += "<tr> \
						<td>"+result[i]["fullname"]+"</td> \
						<td>"+result[i]["groupName"]+"</td> \
						<td><a href=\"javascript:void(0)\" onclick='if(confirm(\"are you sure?\")){deleteGroupPacker("+result[i]["id"]+")}'>Delete</a></td> ";
					markup = markup + "</tr>";
				}
			$("#tblGroupPacker").append(markup);	

	});
}

function deleteGroupPacker(id){
	var current_date = new Date()
 	$.getJSON('api.php?action=deletepackergroup&id='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
		 
		 readGroupPacker();	
	});
}



function editUser(str){
	 
	var obj = (str);
	 
	$("#txtFullName").val(obj["fullname"]);	
	$("#txtEmail").val(obj["emailId"]);	
	$("#password").val("");	
	$("#selRoles").val(obj["roleId"]);	
	$("#txtSeller").val(obj["seller"]);	
	$("#hidUserId").val(obj["userId"]);	
}

function updateUserSeller(){
	var current_date = new Date()
	
	var val = $("#divDetailsSeller").val().replace(/'/g, "\\'");
	
	var url = 'api.php?action=updateuserseller&userId='+currentSelectedUser+'&sellers='+val+'&curtime='+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		//currentSelectedUser = 0;
		//$("#divDetailsSeller").val("");
		readUser();
	});
}

function saveUser(){ 
	var current_date = new Date()
	var url = 'api.php?action=adduser&fullname='+$("#txtFullName").val()+'&email='+$("#txtEmail").val()+'&password='+$("#txtPassword").val()+'&role='+$("#selRoles").val()+'&userId='+$("#hidUserId").val()+'&seller='+$("#txtSeller").val()+'&curtime='+current_date.getMilliseconds();

	$.getJSON(url, function(result) { 
		
		$("#txtFullName").val("");	
		$("#txtEmail").val("");	
		$("#password").val("");	
		$("#selRoles").val("");	
		$("#txtSeller").val("");	
		$("#hidUserId").val("0");	 
		readUser();
		alert("User Stored");
	})
}

function createNewUser(){
	
		$("#txtFullName").val("");	
		$("#txtEmail").val("");	
		$("#password").val("");	
		$("#selRoles").val("");	
		$("#txtSeller").val("");	
		$("#hidUserId").val("0");	 	
}

function readUser(){

	 var current_date = new Date()
	$.getJSON('api.php?action=users'+"&curtime="+current_date.getMilliseconds(), function(result) { 
	
		 users = result;
	
		   $("#tblUsers").find("tr:gt(0)").remove();
			var markup = "";
				for(var i=0;i<result.length;i++){
					 
					var user = result[i];
					//console.log(result[i]);
/*					markup += "<tr> \
						<td>"+result[i]["fullname"]+"</td> \
						<td>"+result[i]["emailId"]+"</td> \
						<td>"+result[i]["rolename"]+"</td> \
						<td>"+result[i]["seller"]+"</td> \
						<td><a href=\"javascript:void(0)\" onclick='showSellerDetails("+JSON.stringify(user)+");'>Seller Mapping</a></td> \
						<td><a href=\"javascript:void(0)\" onclick='editUser("+JSON.stringify(user)+")'>Edit</a></td> \
						<td><a href=\"javascript:void(0)\" onclick='deleteUser("+result[i]["userId"]+")'>Delete</a></td> ";
						*/
					markup += "<tr> \
						<td>"+result[i]["fullname"]+"</td> \
						<td>"+result[i]["emailId"]+"</td> \
						<td>"+result[i]["rolename"]+"</td> \
						<td>"+result[i]["seller"]+"</td> \
						<td><a href=\"javascript:void(0)\" onclick='currentSelectedUser="+user["userId"]+";showSellerDetails();'>Seller Mapping</a></td> \
						<td><a href=\"javascript:void(0)\" onclick='editUser("+JSON.stringify(user)+")'>Edit</a></td> \
						<td><a href=\"javascript:void(0)\" onclick='deleteUser("+result[i]["userId"]+")'>Delete</a></td> ";	
					markup = markup + "</tr>";
				}
			$("#tblUsers").append(markup);	


	});
}

function deleteUser(id){
	if(confirm("This will remove this user permanently, are you sure?")){
		var current_date = new Date()
		$.getJSON('api.php?action=deleteuser&id='+id+"&curtime="+current_date.getMilliseconds(), function(result) { 
			 
			 readUser();	
		});	
	}
	
}





var latlngorderId = "";
function updateLocation(orderId) {
	latlng = "";
	latlngorderId = orderId;
  if (navigator.geolocation) {
    navigator.geolocation.getCurrentPosition(showPosition);
  } else { 
    x.innerHTML = "Geolocation is not supported by this browser.";
  }
}

function showPosition(position) {
	
var lt = position.coords.latitude+","+position.coords.longitude;
	
	var current_date = new Date()
  var url = 'api.php?action=updateOrderExtended&key=latlan&val='+lt+"&orderId="+latlngorderId+"&curtime="+current_date.getMilliseconds();
	 
	$.getJSON(url, function(result) { 
	 		latlngorderId = "0";
		})
}

function gridView(container){
	
	$("#mainContainer").hide();
	$("#containerConsolidated").hide();
	$("#containerBulkUpdate").hide();
	
	
	$("#"+container).show();
	
	
	searchgrid();
	
}

function searchgrid(){

	if($("#mainContainer").is(":visible")){
		getOrders(true);	
	}else{
		getConsolidatedGrid();
	}	
}

function getConsolidatedGrid(){
		var markup = "";
		
		var productfilter = "";
		var val2 = Array();
		 $("input[id='productfilter']:checked").each(function(i){
			  val2[i] = $(this).val();
			});
			
		if(val2.length > 0){
			productfilter = "&products="+(val2.toString());	
			
		}
		
		
	var statusfilter = "";
	var val = Array();
	 $("input[id='statusfilter']:checked").each(function(i){
          val[i] = $(this).val();
        });
		
	if(val.length > 0){
		val.push('Status');
		statusfilter = "&status="+(val.toString());	
		
	}
		
		
	var current_date = new Date()
	var productcondition = "&productcondition="+$("#productcondition:checked").val();
	var expectedDeliveryToggle = "&expectedDeliveryToggle="+$("#selExpectedToggle").val();
	
		var xhr = $.getJSON('api.php?action=consolidatedorder&deliveryDate='+$("#txtFetchDeliveryDate").val()+""+productfilter+"&unplanned="+unplanned+"&unlisted="+unlisted+productcondition+expectedDeliveryToggle+statusfilter+"&curtime="+current_date.getMilliseconds(), function(result) { 
		
	 	orders = result;
		
	    $("#tblConsolidated").find("tr:gt(0)").remove();
		$("#tblConsolidated").scrollTop(0);
			 
		for(var i=0;i<orders.length;i++){
			markup += "<tr> \
						<td align='center'>"+orders[i]["productName"]+" - "+orders[i]["total"]+"</td><td>"+orders[i]["grouping"]+"</td> \
						</tr>";
							
			
		}
		
		$("#tblConsolidated tbody").append(markup);	
		
	}); 
	
	
	
	
}

function printConsolidated(){
	$("#printConsolidated").hide();
 var tab = document.getElementById('tblConsolidated');
            var win = window.open('', '', 'height=700,width=700');
            win.document.write(tab.outerHTML);
            win.document.close();
            win.print();	
			$("#printConsolidated").show();
}
function ArrayUnique(a) {
    var temp = {};
    for (var i = 0; i < a.length; i++)
        temp[a[i]] = true;
    return Object.keys(temp);
}


function bulkUpdate(field){
	
	if(confirm('Are you sure to process bulk update on large number of Orders?')){
	
				var expectedDeliveryToggle = "&expectedDeliveryToggle="+$("#selExpectedToggle").val();
	
		
			var statusfilter = "";
			var val = Array();
			 $("input[id='statusfilter']:checked").each(function(i){
				  val[i] = $(this).val();
				});
				
			if(val.length > 0){
				statusfilter = "&status="+(val.toString());	
				
			}
			
			var productfilter = "";
			var val2 = Array();
			 $("input[id='productfilter']:checked").each(function(i){
				  val2[i] = $(this).val();
				});
				
			if(val2.length > 0){
				productfilter = "&products="+(val2.toString());	
				
			}
			
				
			var driverFilter = "";
			if($('#selDriverFilter').length){
				if($("#selDriverFilter").val() != "0" && $("#selDriverFilter").val() != "undefined"){
					driverFilter = "&driverId="+$("#selDriverFilter").val();
				}
				
			}else{
			//driverFilter = "&driverId=0";	
			}
			
			 
			var current_date = new Date();
			
			var newcol = "";
			if(field == "DeliveryDate"){
				newcol = 'newDeliveryDate='+$("#txtNewDeliveryDate").val().trim();
			}else if (field == "DeliveryStatus"){
				newcol = 'newDeliveryStatus='+$("#selBulkStatus").val().trim();
				
			}
			
			if(field == "DeliveryDate" && $("#txtNewDeliveryDate").val().trim()==""){
				alert("Please provide valid delivery date");
			}
			else{
				var productcondition = "&productcondition="+$("#productcondition:checked").val();
	
				var xhr = $.getJSON('api.php?action=bulkUpdate&'+newcol+"&deliveryDate="+$("#txtFetchDeliveryDate").val()+statusfilter+productfilter+driverFilter+"&curtime="+current_date.getMilliseconds()+"&unplanned="+unplanned+expectedDeliveryToggle+productcondition, function(result) { 
					alert("Orders are updated to new Delivery Date");
				});
					
			}
		
		
	}
	
	
		
	
	
	
		
}


function showLogDetails(logs){
//	alert(logs);
	$(".logsdiv").show();
	$("#divDetailLogs").html(logs);
}

var currentSelectedUser = 0;
function showSellerDetails(){
	console.log("CLICKED");
	//currentSelectedUser = user["userId"];
	
	var user = null;
	for(var i=0;i<users.length;i++){
		if(users[i]["userId"] == currentSelectedUser){
			user = users[i];
		}
	}
	
	$(".sellersDiv").show();
	console.log(user["sellerGroup"]);
	$("#divDetailsSeller").val(user["sellerGroup"]);
}
/*
function showSellerDetails(user){
	console.log("CLICKED");
	currentSelectedUser = user["userId"];
	$(".sellersDiv").show();
	console.log(user["sellerGroup"]);
	$("#divDetailsSeller").val(user["sellerGroup"]);
}
*/

function hideLogsDetails(){
	$(".logsdiv").hide();
	$("#divDetailLogs").html("");
	$(".sellersDiv").hide();
	$("#divDetailsSeller").val("");
	
	currentSelectedUser = 0;
	$("#divDetailsSeller").val("");
		
		
}


function changeView(){
	 
	if($("#tblOrders").is(":visible")){
		$("#tblOrdersMobile").show();
		$("#tblOrders").hide();
		$("#divMobileNav").show();	
		recordsperpage = 1;		
		$("#lnkView").html("Classic View");
		changeSeachView();
		pageno = 0;
		getOrders(false);
	}else{
		$("#tblOrdersMobile").hide();
		$("#tblOrders").show();
		$("#divMobileNav").hide();
		recordsperpage = 5;
		$("#lnkView").html("Mobile View");

	}
	
	 
}





function changeSeachView(){
	if($("#search1").is(":visible")){
		$("#selectionStats").hide();
		$("#search1").hide();
		$("#search2").hide();
		$("#selectionStats").hide();
		$("#headerbar").hide();

		$("#lnkSeachView").html("Show Search");
	}else{
		$("#selectionStats").show();
		$("#search1").show();
		$("#search2").show();
		$("#lnkSeachView").html("Hide Search");
		$("#headerbar").show();


	}
	
	 
}




function addSearchParam(){
	var searchMarkup = "";
	if($("#selSearchType").val() == "Range"){
		searchMarkup = $("#selAnding").val()+" <br />"+$("#selSearchField").val()+' between \
                <input type="text" id="txtFrom" name="txtTranFrom" style="width:100px" /> and  \
                <input type="text" id="txtTranTo" name="txtTranTo" style="width:100px" />';
	}
	
	var lm = "40px;";
	if($("#selAnding").val() == "OR"){
		lm = "40px;";	
	}
	
	$("#transactionSearch").append("<div style='margin:10px;margin-left:"+lm+"'>"+searchMarkup+"&nbsp;<a href='javascript:void(0)' onclick='$(this).parent().remove();'>X</a></div>");
}

function resyncTransaction(){
	$.getJSON('api.php?action=synctransactionorder', function(result) { 
			alert("Bank records Re-Synced.");
		});

	alert("Sync is started, this might take a while, please click OK and wait..");
}