@php
$results_obj = json_decode($results);


$loggedinUser=Auth::user()->RefId;
if($loggedinUser==1)
{
	echo "<pre>";
		//print_r($results_obj);
		//print_r($headers);
		//print_r($GetDropdownLists);
		//print_r($ListBoxNamesIDs);

		//print_r($EmailColumnValues);
	echo "</pre>";
}
if($mode=='Auto')
{
	$field_name=$header[0];
	$sort_order="DESC";
}

$total_counts=count($header);
$RowIds=array();
foreach($results_obj as $name => $values) {
$row_count=0;
foreach ($values as $k => $v) {
if($row_count==$total_counts)
{
	$RowIds[]=$v;
}
$row_count++;
}
}
// added on 28th April '21
$userdetails = Auth::user();
$LoggedUser = $userdetails->name;
$DateFormat = $userdetails->DateFormat;
$TimeZone = $userdetails->TimeZone;
$TimeFormat = $userdetails->TimeFormat;
$GmtOffSet = $userdetails->GmtOffSet;

$total_count=count($header);
$temp_count=$page_num;
$columns = array();
$loopcount=0;


// added on 20th Oct '21
$RoleAccess_c="1264d300-9915-11eb-948a-56b1773fd56f";   // None 8eca7f5f-9914-11eb-948a-56b1773fd56f
$RoleAccess_l="1264d300-9915-11eb-948a-56b1773fd56f";   // All
$RoleAccess_e="1264d300-9915-11eb-948a-56b1773fd56f";   // All
$RoleAccess_d="1264d300-9915-11eb-948a-56b1773fd56f";   // All
$RoleAccess_r="1264d300-9915-11eb-948a-56b1773fd56f";   // All
$RoleAccess_m="1264d300-9915-11eb-948a-56b1773fd56f";   // All

if(!empty($ModulesAccess))
{
	//print_r($ModulesAccess);
	foreach($ModulesAccess['Actions'] as $ActionName)
	{
		if($ActionName['ActionName']=="Create")
		$RoleAccess_c=$ActionName['RoleAccess'];

		if($ActionName['ActionName']=="List")
		$RoleAccess_l=$ActionName['RoleAccess'];

		if($ActionName['ActionName']=="Edit")
		$RoleAccess_e=$ActionName['RoleAccess'];

		if($ActionName['ActionName']=="Delete")
		$RoleAccess_r=$ActionName['RoleAccess'];

		if($ActionName['ActionName']=="Detail")
		$RoleAccess_d=$ActionName['RoleAccess'];

		if($ActionName['ActionName']=="Mass Update")
		$RoleAccess_m=$ActionName['RoleAccess'];
	}
}
//print_r($headers);
@endphp
<div>  <!-- class="col-xl-12 col-lg-12 col-sm-12 layout-spacing" -->
	<div class="table-responsive mb-4 mt-4" style="overflow-x:auto;">
		<input type="hidden" name="ModuleId" id="ModuleId" value="{{$ModuleId}}" >
		<input type="hidden" name="page_num" id="page_num" value="{{$page_num}}" >
		<input type="hidden" name="total_records" id="total_records" value="{{$total_records}}" >
		<input type="hidden" name="field_name" id="field_name" value="{{$field_name}}" >
		<input type="hidden" name="limit" id="limit" value="{{$limit}}" >
		<input type="hidden" name="sort_order" id="sort_order" value="{{$sort_order}}" >
		<input type="hidden" name="mode" id="mode" value="{{$mode}}" >
		<input type="hidden" name="order_by" id="order_by" value="" >
		<input type="hidden" name="sort_by" id="sort_by" value="" >
		@php
		// added on 26th Aug '21
		if(!empty($results_obj))
		{
			@endphp

			<table id="multi-column-ordering" class="table table-hover dataTable" style="width:100%">
				@php
				echo "<tbody>";
					foreach($results_obj as $name => $values) {

					//print_r($values);
					$modulesIdValues=end($values);
					echo "<tr>";
						@endphp
						@php
						$loopcount++;
						//echo "<td>$name</td>";

						$row_count=0;
						foreach ($values as $k => $v) {
						$columns[$k] = $k;
						if($row_count==$total_count)
						{
							if($mode!=="RelatedSearch")
							{
								$pass_array=array("ModuleId"=>$ModuleId,"RowId"=>"$v");
								@endphp
								@if($RoleAccess_m!="8eca7f5f-9914-11eb-948a-56b1773fd56f")
								<td>
									<div class="n-chk">
										<label class="new-control new-checkbox new-checkbox-rounded new-checkbox-text checkbox-outline-dark">
											<input type="checkbox" id="massUpdate{{$loopcount}}"  value="{{$modulesIdValues}}" class="new-control-input massupdateCheck"onchange="getSelectedCount('{{$modulesIdValues}}','{{$loopcount}}')">
											<span class="new-control-indicator"></span><span class="new-chk-content" style="display: none"></span>
										</label>
									</div>
								</td>
								@endif
								@php
							}
							
						}
						else
						{
							$display_value=$v;
							foreach($headers as $field_list)
							{
								//print_r($field_list);

								$field_name=$field_list['FieldName'];
								$DropDownNameId=$field_list['DropDownNameId'];
								if($field_name==$k)
								{
									$ReferenceField=$field_list['ReferenceField'];
									$display_name=$field_list['DisplayName'];
									$display_type=$field_list['DisplayType'];

									if( ($display_type==2 && !empty($ListBoxNamesIDs)) && $DropDownNameId!='')
									{
										//$display_value=$GetDropdownLists[$v];
										$ListBoxNamesIDVal=$DropDownNameId;
										//$ListBoxNamesIDVal=$ListBoxNamesIDs[$field_name];


										$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];

										//$display_value=$listBoxVal[$v];

										foreach($listBoxVal as $listBoxKey=>$listBoxValue)
										{
											if($listBoxKey==$v)
											$display_value=$listBoxValue;
											//    else
											//        $display_value="";
										}
									}

									if( ($display_type==5 && !empty($ListBoxNamesIDs)) && $DropDownNameId!='')
									{
										//$display_value=$GetDropdownLists[$v];
										$ListBoxNamesIDVal=$DropDownNameId;
										//$ListBoxNamesIDVal=$ListBoxNamesIDs[$field_name];
										$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];

										//$display_value=$listBoxVal[$v];

										foreach($listBoxVal as $listBoxKey=>$listBoxValue)
										{
											if($listBoxKey==$v)
											$display_value=$listBoxValue;
											//    else
											//        $display_value="";
										}
									}

									if($display_type==3 && !empty($ListBoxNamesIDs) && $DropDownNameId!='')
									{
										$display_value="";
										if($v!="")
										{
											$ListBoxNamesIDVal=$DropDownNameId;
											//$ListBoxNamesIDVal=$ListBoxNamesIDs[$field_name];
											$listBoxVal=$GetDropdownLists[$ListBoxNamesIDVal];
											$listArray=explode(",",$v);
											foreach($listArray as $listVal)
											{
												if(!array_key_exists($listVal,$listBoxVal))
												{
													$display_value=$listVal;
												}
												else
												{
													$display_value.="<li>".$listBoxVal[$listVal]."</li>";
												}

											}

										}
									}

									if($display_type==4 && $DateFormat!="" && $v!="")
									{
										
										if($v=="0000-00-00 00:00:00" || $v==0000-00-00)
										{
											// added on 16th Sept '21
											$display_value="";
										}
										else
										{
											// added on 28th April '21
											$display_value = date("$DateFormat", strtotime($v));
										}
									}

									if($display_type==14 && $DateFormat!="" && $v!="")
									{
										// added on 29th April '21
										//$display_value = date("$DateFormat $TimeFormat", strtotime($v));

										if($v=="0000-00-00 00:00:00")
										{
											// added on 16th Sept '21
											$display_value="";
										}
										else
										{
											$datetime = new DateTime($v);
											$datetime->format("$DateFormat $TimeFormat");
											$la_time = new DateTimeZone($TimeZone);
											//$datetime->setTimezone($la_time);
											$display_value = $datetime->format("$DateFormat $TimeFormat");
										}
									}

									$NewRowId=$v;
									$newFieldName=$field_name;
									if($display_type==8 && $v!="" && !empty($RelateModules) && array_key_exists($v,$RelateModules))
									{
										// for RelateTo
										$display_value=$RelateModules[$v];
										$newFieldName=$field_name;

										$NewRowId=$v;
									}

									if($display_type==25 && !empty($selfRelatedList))
									{
										// for SelefRelateTo
										foreach($selfRelatedList as $SelfRelate)
										{
											if($SelfRelate["key"]==$v)
											{
												$display_value=$SelfRelate["value"];
											}
										}  
									}


									if($display_type==23 && $v!="" && !empty($RelateModules) && array_key_exists($v,$RelateModules))
									{
										// for Dependent_RelateTo
										$display_value=$RelateModules[$v];
									}

									if($display_type==15 && $display_value!="")
									{
										// for AssignedTo
										$display_value=$AssignedToList[$v]['name'];
									}
									if(($display_type==9||$display_type==16) && $display_value!="")
									{
										// for AssignedTo
										//$display_value=$display_value;
										$display_value1="<span id='$display_value'></span>";
										@endphp
										<script>getfilename('{{$display_value}}')</script>
										@php
										$display_value=$display_value1;
									}

									

									if($display_type==21)
									{
										// for Click2Call_Masking
										$display_name.=" is masked";
										//$display_value="XXXX-XXX-XXX";
										$display_value="<span class='text-danger'>xxxx-xxx-xxx</span>";
									}

									if($display_type==22)
									{
										// for Masked, on 24th Aug '21
										$display_name.=" is masked";
										$display_value="<span class='text-warning'>|*_*|</span>";
									}

									if($display_type==12)
									{
										$display_value=$display_value;

										if(!empty($EmailColumnValues))
										{
											if(array_key_exists($display_value,$EmailColumnValues))
											{
												//$display_value=implode(",",$EmailColumnValues[$display_value]);
												$Emails='';
												foreach($EmailColumnValues[$display_value] as $email)
												{
													$Emails.="<li>".$email."</li>";
												}

												$display_value=$Emails;
											}
										}
									}
								}
							}

							if($display_type==8)
							{
								@endphp
								<td>
									<a onclick="popUp('{{$ModuleId}}','{{$NewRowId}}','{{$display_type}}','{{$newFieldName}}','{{$display_value}}')" class='text-info' data-toggle='modal' data-target='#exampleModal'>{{$display_value}}</a>
								</td>
								@php
							}
							else
							{
								echo "<td title='$display_name'>
									$display_value
								</td>";
							}
							
						}

						$row_count++;
						$temp_count++;
					}
				echo "</tr>";
			}
			$row_count=0;
		echo "</tbody>";

		echo "<thead>";
			echo "<tr>";

				foreach ($columns as $column) {

				//$column=$fieldList['FieldName'];
				//$DisplayName=$fieldList['DisplayName'];

				if($row_count==$total_count)
				{
					if($mode!=="RelatedSearch")
					{
						echo "<th colspan='3' class='text-center' nowrap>Action</th>";

						if($RoleAccess_m!="8eca7f5f-9914-11eb-948a-56b1773fd56f")
						{
							echo "<th nowrap>".
								'<select class="form-control" id="MassUpdateSelect"style="margin-bottom: 0px !important;width: 145px !important;" onchange="selectMassUpdate(this.value)">
									<option id="mass0"value="">Mass Update</option>
									<option id="thisPageRecord" value="1">This Page</option>
									<option id="allRecord" value="2">Select All</option>
								</select>'
							."</th>";
						}
					}
				}
				else
				{
					$sorting_css='';
					$title='ascending';

					if($column==$field_name && $sort_order=="DESC")
					{
						$sorting_css='sorting_asc';
						$title='descending';
					}
					else
					{
						$sorting_css='sorting_desc';
						//$title='ascending';
					}
					// newly added on 22nd April '21
					$DisplayName=$column;
					foreach($headers as $fieldList)
					{
						$FieldName=$fieldList['FieldName'];

						if($FieldName==$column)
						{
							$DisplayName=$fieldList['DisplayName'];
							$DisplayType=$fieldList['DisplayType'];
						}
					}
					@endphp
					<th class="sort_me {{$sorting_css}}" title='Click here to sort by {{$column}}' id='{{$column}}' nowrap><p class='column' style='display: none'>{{$column}}</p>{{$DisplayName}}</th>
					@php
				}
				$row_count++;
			}
		echo "</tr>";
	echo "</thead>";

	$row_count=0;
	echo "<tfoot>";
		echo "<tr>";
			$massupdatecol=1;
			if($massupdatecol==1)
			{
				$massupdatecol="0";
			}
			foreach ($columns as $column) {
			if($row_count==$total_count)
			{
				if($mode!=="RelatedSearch")
				{
					echo "<th colspan='3' class='text-center' nowrap>Action</th>";
				}
			}
			else
			{
				// newly added on 22nd April '21
				$DisplayName=$column;
				foreach($headers as $fieldList)
				{
					$FieldName=$fieldList['FieldName'];

					if($FieldName==$column)
					{
						$DisplayName=$fieldList['DisplayName'];
						$DisplayType=$fieldList['DisplayType'];
					}
				}
				@endphp
				<th title='Click here to sort {{$column}} in descending order' class="sort_me {{$sorting_css}}"  nowrap><a onclick="ViewData('{{$ModuleId}}','{{$page_num}}','{{$limit}}','{{$column}}','DESC','{{$mode}}')">{{$DisplayName}}</a></th>
				@php
			}
			$row_count++;
		}
	echo "</tr>";
echo "</tfoot>";
@endphp
</table>
@php
}   // end of results_obj validation, added on 26th Aug '21
@endphp
</div>

<div class="row">
	<div class="col-md-4">
		<button type="button" id="massUpdate-btn"class="btn btn-primary" loopval="{{$loopcount}}" onclick="massUpdate('{{$loopcount}}')" style="display: none;">Merge</button>
	</div>
</div>

@if(empty($columns))
<table id="multi-column-ordering" class="table table-hover dataTable" style="width:100%">
	<tr>
		@php
		foreach($headers as $fieldList)
		{
			echo "<th>".$DisplayName=$fieldList['DisplayName']."</th>";
		}
		@endphp
	</tr>
</table>
<div class="alert alert-arrow-right alert-icon-right alert-light-primary mb-4" role="alert">
	<button type="button" class="close" data-dismiss="alert" aria-label="Close"><svg xmlns="http://www.w3.org/2000/svg" data-dismiss="alert" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-x close"><line x1="18" y1="6" x2="6" y2="18"></line><line x1="6" y1="6" x2="18" y2="18"></line></svg></button>
	<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-alert-circle"><circle cx="12" cy="12" r="10"></circle><line x1="12" y1="8" x2="12" y2="12"></line><line x1="12" y1="16" x2="12" y2="16"></line></svg>
	<strong>Not Available!</strong>
</div>
@endif

<div class="col-sm-12 col-md-12 text-right">
	<div class="text-primary" role="status" aria-live="polite" title="{{$total_records}}"><span class=" total_records">Displaying {{$total_records}} records</span></div>
</div>

<div class="paginating-container pagination-solid">
	<ul class="pagination">
		@php
		$total_pages = ceil($total_records/$limit);
		$start_loop = $page_num;
		$difference = $total_pages - $page_num;

		$active_class='';

		@endphp

		@if($total_records > $limit)
		@if($difference <= 5)
		@php
		$start_loop = $total_pages - 5; 
		@endphp
		@endif
		@php
		$end_loop = $start_loop + 4;
		@endphp

		@if($page_num > 1)
		@php
		$first=$page_num-1;
		@endphp
		<li class="prev"><a onclick="ViewData('{{$ModuleId}}','{{$first}}','{{$limit}}','{{$field_name}}','{{$sort_order}}','{{$mode}}')">Prev</a></li>
		@endif

		@for($i=$start_loop; $i<=$end_loop; $i++)
		@if($i>0)
		@php
		if($page_num==$i)
		$active_class='active';
		else
		$active_class='';
		@endphp
		<li class='{{$active_class}}'><a onclick="ViewData('{{$ModuleId}}','{{$i}}','{{$limit}}','{{$field_name}}','{{$sort_order}}','{{$mode}}')">{{$i}}</a></li>
		@endif
		@endfor
		@if($page_num <= $end_loop)
		@php
		$last=$page_num+1;
		@endphp
		<li class="next"><a  onclick="ViewData('{{$ModuleId}}','{{$last}}','{{$limit}}','{{$field_name}}','{{$sort_order}}','{{$mode}}')">Next</a></li>
		@endif
		@endif
	</ul>
</div>
</div>

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
	<div class="modal-dialog modal-xl" role="document">
		<div class="modal-content">
			<div class="modal-header">
				<h5 class="modal-title" id="exampleModalLabel">BPM360</h5>
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
					<svg aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-x"><line x1="18" y1="6" x2="6" y2="18"></line><line x1="6" y1="6" x2="18" y2="18"></line></svg>
				</button>
			</div>
			<div class="modal-body" id="response_div">
				<p class="modal-text"></p>
			</div>
			<div class="modal-footer">
				<button class="btn" data-dismiss="modal"><i class="flaticon-cancel-12"></i> Discard</button>
				<!-- <button type="button" class="btn btn-primary">Save</button> -->
			</div>
		</div>
	</div>
</div>
<script type="text/javascript">
	$(document).ready(function() {
		$(".sort_me").on({
			click: function(){
				$(this).toggleClass("sorting_asc sorting_desc");

				var fieldname=$(this).find('.column').text();
				var ModuleId = $('#ModuleId').val();
				var page_num = $('#page_num').val();
				var limit = $('#limit').val();
            // var field_name = $('#field_name').val();
            var sort_order = $('#sort_order').val();
            var original_mode = $('#mode').val();
            var sort_by='';


            if(sort_order=="DESC")
            {
            	sort_by="ASC";
            	sorting_css='sorting_asc';
            	removeClass='sorting_desc';
            }
            else
            {
            	sort_by="DESC";
            	sorting_css='sorting_desc';
            	removeClass='sorting_asc';
            }

            $("#sort_order").val(sort_by);
            $("#sort_by").val(sort_by);
            $("#field_name").val(fieldname);

            //var mode='Sort';
            //$("#mode").val("Sort");   // commented on 24th April '21
            if(original_mode=='Auto')
            	original_mode="Sort";
            
            $("#mode").val(original_mode);   // updated on 24th April '21

            console.log( "sort_me... "+fieldname+" original_mode... "+original_mode+" | ID "+ModuleId+" No "+page_num+" Tot: "+limit+" Field: "+field_name+" Order "+sort_order+" sort_by "+sort_by); // +" asc "+asc+" desc "+desc
            ViewData(ModuleId,page_num,limit,fieldname,sort_by,original_mode);
        }  
    });
	});

	function open_me(obj){
		var ModuleId=obj.ModuleId;
		var RowId=obj.RowId;
		var url="../ShowDetailView/"+ModuleId+"/"+RowId;
		var href="{{'"+url+"'}}";
		console.log("Opening "+url);
		window.location.href = url;
	}

	$('.total_records').on('mouseover', function(){
		var field_name = $('#field_name').val();
		var sort_order = $('#sort_order').val();

		if(sort_order=="DESC")
		{
			sort_order="descending";
		}
		else
		{
			sort_order="ascending";
		}

		var tool_tip="Sorting "+field_name+" in "+sort_order+" order";
		$(this).attr('title', tool_tip);
		$(this).tooltip({
			placement: 'top',
			trigger: 'hover',
			html: true,
			container: 'body',
		}).tooltip('show');
	});

</script>