@php
	$Configured_Filters=json_decode($ConfiguredFilters);
	$Configured_DefaultFilters=json_decode($ConfiguredDefaultFilters);
	//$RelatedTo_Fields=json_decode($RelatedToFields);
	//$GetSavedRealatedList=$RelatedToFields;	// array();	// $RelatedToFields
	
	//echo "<pre>";
		//print_r($ConfiguredFilters);
		//print_r($Configured_DefaultFilters);
		//print_r($RelatedToFields);
		//echo "<br>***<br>";
		//print_r($RelatedTo_Fields);
	//echo "</pre>";

	//die();
	$Conditions='';

	$C1='';
	$C2='';
	$C3='';
	$C4='';
	$C5='';
	$C6='';
	$C7='';
	$C8='';
	$C9='';
	$C10='';
	$C11='';
	$C12='';
	$C13='';
	$C14='';
	$C15='';
	$C16='';
	$C17='';
	$C18='';
	$C19='';

	$FieldName='';
	$Date_FieldName='';
	$SortOrder='';
	$Conditions='';

	$Existing_Filters=array();
	$Existing_Filters1=array();
	$New_Filters=array();
	if(!empty($Configured_DefaultFilters))
	{
		//$FieldName=$Configured_DefaultFilters[0]->FieldName;
		//$SortOrder=$Configured_DefaultFilters[0]->SortOrder;
		//$Conditions=$Configured_DefaultFilters[0]->Conditions;
		//$Date_FieldName=$Configured_DefaultFilters[0]->FieldName;

		foreach($Configured_DefaultFilters as $keys)
		{
			if($keys->DisplayType==4 || $keys->DisplayType==14)
			{
				$FieldName=$keys->FieldName;
				$SortOrder=$keys->SortOrder;
				$Conditions=$keys->Conditions;
				$FromDate=$keys->FromDate;
				$ToDate=$keys->ToDate;

					// added on 10th Jan '21
				$Date_FieldName=$keys->FieldName;
			}
			elseif($keys->DisplayType==23 || $keys->DisplayType==25 || $keys->DisplayType==8)
			{
				//added by kabali 2021-11-24
				$Existing_Filters1[]=array("FieldName"=>$keys->FieldName,"SortOrder"=>$keys->SortOrder,"Conditions"=>$keys->Conditions);
			}
			else
			{
					// for DropDowns on 23rd Sept '21
				$Existing_Filters[]=array("FieldName"=>$keys->FieldName,"SortOrder"=>$keys->SortOrder,"Conditions"=>$keys->Conditions);

				//$Existing_Filters['FieldName'][]=$keys->FieldName;
				//$Existing_Filters['SortOrder'][]=$keys->SortOrder;
				//$Existing_Filters['Conditions'][]=$keys->Conditions;
			}
		}
	}
	function multiKeyExists(array $arr, $key) {
	        
	    	// is in base array?
	    if (array_key_exists($key, $arr)) {
	        $results[] = $arr;
	        return $results;
	    }

	    // check arrays contained in this array
	    foreach ($arr as $element) {
	        if (is_array($element)) {
	            if (multiKeyExists($element, $key)) {
	                //return true;
			        $results[] = $element;
			        return $results;
	            }
	        }
	        
	    }

	    return false;
	}

	if($SortOrder=="ASC")
	{
		$asc='selected';
		$desc='';
	}
	else
	{
		$asc='';
		$desc='selected';
	}

	if($Conditions=="=")
		$C1="selected";

	if($Conditions=="not_equal")
		$C2="selected";

	if($Conditions=="greater_than")
		$C3="selected";

	if($Conditions=="less_than")
		$C4="selected";

	if($Conditions=="last_7_days")
		$C5="selected";

	if($Conditions=="next_7_days")
		$C6="selected";

	if($Conditions=="last_30_days")
		$C7="selected";

	if($Conditions=="next_30_days")
		$C8="selected";

	if($Conditions=="last_month")
		$C9="selected";

	if($Conditions=="this_month")
		$C10="selected";

	if($Conditions=="next_month")
		$C11="selected";

	if($Conditions=="last_year")
		$C12="selected";

	if($Conditions=="this_year")
		$C13="selected";

	if($Conditions=="next_year")
		$C14="selected";

	if($Conditions=="between")
		$C15="selected";

	if($Conditions=="last_14_days")
		$C16="selected";

	if($Conditions=="next_14_days")
		$C17="selected";

	if($Conditions=="last_21_days")
		$C18="selected";

	if($Conditions=="next_21_days")
		$C19="selected";

	$selected='';
	$selectedFieldName='';
		// updated on 10th Jan '22
	//$New_Filters=array();
	$FreeTxt_Filters=array();
	$RelateTo_Filters=array();	// Not Required

	foreach($Configured_Filters as $key)
	{
		if($key->DisplayType==4 || $key->DisplayType==14)
		{
			$New_Filters[]=$key->ColumnName;
		}

		if($key->DisplayType==23 || $key->DisplayType==25 || $key->DisplayType==8)
		{
			$RelateTo_Filters[]=$key->ColumnName;
		}
	}

	$dropdown_array=array("2","3","5","6");
	$Relate=array("8","23","25");


	//print_r($New_Filters);
	//die();
@endphp


@if(!empty($GetRealtedModuleFieldList))
	@foreach($GetRealtedModuleFieldList as $key=>$value)
<table class="table style-2 table-hover no-footer" id="table2">
	<thead>
		<tr>
			<th colspan="5">
				<div class="col-xs-12 col-sm-12 col-md-12 text-center">
					Related Fields for {{$key}}  
				</div>
			</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>{{$key}}</td>
			<td>
			<select class="form-control" id="RelatedModuleIds_{{$key}}" name="RelatedModuleIds_{{$key}}" >
			<option value="">Fields</option>
			@foreach($GetRealtedModuleFieldList[$key] as $data)
				@php
					$tmp_data=array("DemographyConfigId"=>$data->DemographyConfigId,"ColumnName"=>$data->ColumnName,"DisplayType"=>$data->DisplayType,"TableName"=>$data->TableName,"ModuleId"=>$data->ModuleId);
					$tmp_json=json_encode($tmp_data);
				@endphp
				<option id="RelatedModuleDemogrpaphy" value="{{$tmp_json}}">{{$data->LabelValue}}</option>
			@endforeach
			</select>
			</td>
			<td>
				<input type="button" class="btn btn-primary" value="Add Field" name="AddRelateField" id="AddRelateField" onclick="saveRelateToFields('{{$key}}')"> 
			</td>
		</tr>
		@if($GetSavedRealatedList!="")
			@foreach($GetSavedRealatedList[$key] as $data)
			<tr>
			@php
			$DispayType=$data->DisplayType;
			$ReportFieldConfigId=$data->ReportFieldConfigId;
			if($DispayType==1)
			 {
				 $Display="textBox";
			 }
			 elseif($DispayType==2)
			 {
				  $Display="DropDown";
			 } 
			 elseif($DispayType==3)
			 {
				  $Display="MultiSelect";
			 } 
			 elseif($DispayType==4)
			 {
				  $Display="Date";
			 } 
			 elseif($DispayType==5)
			 {
				  $Display="Radio";
			 }
			 elseif($DispayType==6)
			 {
				  $Display="CheckBox";
			 } 
			 elseif($DispayType==7)
			 {
				  $Display="TextArea";
			 } 
			 elseif($DispayType==8)
			 {
				  $Display="Relate";
			 } 
			 elseif($DispayType==9)
			 {
				  $Display="Photo";
			 } 
			 elseif($DispayType==10)
			 {
				  $Display="TextEditor";
			 } 
			 elseif($DispayType==11)
			 {
				  $Display="Phone";
			 } 
			 elseif($DispayType==12)
			 {
				  $Display="E-Mail";
			 } 
			 elseif($DispayType==13)
			 {
				  $Display="Float";
			 } 
			 elseif($DispayType==14)
			 {
				  $Display="DateTime";
			 } 
			 elseif($DispayType==15)
			 {
				  $Display="AssignedTo";
			 } 
			 elseif($DispayType==16)
			 {
				  $Display="Document";
			 } 
			 elseif($DispayType==17)
			 {
				  $Display="Numbers";
			 } 
			 elseif($DispayType==18)
			 {
				  $Display="ZipCode";
			 } 
			 elseif($DispayType==19)
			 {
				  $Display="Characters";
			 }
			 elseif($DispayType==20)
			 {
				  $Display="CloudAgent_Click2Call";
			 }
			 elseif($DispayType==21)
			 {
				  $Display="CloudAgent_Click2Call_Masked";
			 }
			 elseif($DispayType==22)
			 {
				  $Display="Masked";
			 }
			 elseif($DispayType==23)
			 {
				  $Display="Dependent_RelateTo";
			 }
			 elseif($DispayType==24)
			 {
				  $Display="Address";
			 }
			 elseif($DispayType==25)
			 {
				  $Display="SelfRelate";
			 }
			 @endphp
			<td></td>
			<td title="{{$Display}} {{$data->ColumnName}}">{{$data->LabelValue}}</td>
			<td nowrap>
				<!-- <input type="checkbox" class="form-control" checked onclick="remove_related_to('{{$ReportFieldConfigId}}')" name="ReportFieldConfigId"> -->

				<label class="switch s-icons s-outline  s-outline-primary">
					<input type="checkbox" class="new-control-input child-chk select-customers-info" id="ReportFieldConfigId_{{$ReportFieldConfigId}}" onclick="remove_related_to('{{$ReportFieldConfigId}}')" checked >
					<span class="slider round"></span><span style="visibility:hidden">{{$data->LabelValue}}</span>
				</label>
			</td>

			</tr>
			@endforeach
		@endif
	</tbody>
</table>
	@endforeach
@endif

<table class="table style-2 table-hover no-footer" id="tbl">
	<thead>
		<!-- <tr>
			<th colspan="5">
				<div class="col-xs-12 col-sm-12 col-md-12 text-center">
					<input type="button" class="btn btn-primary" onclick="addRow();" value="Add a New Condition?" name="AddCondition" id="AddCondition" />
				</div>
			</th>
		</tr> GetfieldListMod(1,1,) onchange="GetfieldListMod(fieldid,val,DemographyConfigId)" onchange="getDropDownsData()"-->
		<tr>
			<th colspan="5">
				<div class="col-xs-12 col-sm-12 col-md-12 text-center">
					Choose & Add Conditions
				</div>
			</th>
		</tr>
	</thead>
		<tr class="tr_clone" id="row_1" name="row_1">
			<td title="Choose the pre-defined field">
				<select id="FieldName_1" name="FieldName_1" class="form-control FieldNameCls workflowSelect">
				<option selected="selected">-- Choose Dropdown Options --</option>
				@foreach ($Configured_Filters as $Key)
					@if(in_array($Key->DisplayType,$dropdown_array))
						@if($Key->ColumnName==$FieldName)
							@php
							$selected='selected';
							@endphp
							@else
							@php
							$selected='';// onclick="getDropDownsData('{{$Key->DisplayType}}',this.value,'{{$Key->DemographyConfigId}}')"
							@endphp
						@endif	
						<option value="{{$Key->DropDownNameId}}" title="{{$Key->LabelValue}} {{$Key->ColumnName}} {{$Key->DisplayType}}" {{$selected}} class="selectedFieldName" >{{$Key->ColumnName}}</option>
					@endif
				@endforeach
				</select>
			</td>
			<td>
				<div id="getDropDownsDiv_1" name="getDropDownsDiv_1"></div>
			</td>
			<td>
				<input type="button" class="btn btn-primary addButton"  value="Add Condition" name="ReplicateCondition_1"  id="ReplicateCondition_1" />
			</td>
			<td> <!-- onclick="DeleteMe(this.id)"  -->
				<input type="button" class="btn btn-danger remove_me"  value="Remove" name="Remove_1"  id="Remove_1"/>
			</td>
		</tr>
</table>

@if(!empty($Existing_Filters))
<table class="table style-2 table-hover no-footer" id="table2">
	<thead>
		<tr>
			<th>DropDowns</th>
			<th>Options</th>
		</tr>
	</thead>
		@php
		$i=0;
		@endphp
		@foreach($Existing_Filters as $key => $keyz)
			<tr>
				<td title="Choose the dropdown field for default filter">
					<select id="FieldName{{$i}}" name="FieldName{{$i}}" class="form-control" >
						<option value="{{$keyz['FieldName']}}" title="{{$keyz['FieldName']}} " {{$selected}}>{{$keyz['FieldName']}}</option>
					</select>
				</td>
				<td>
					@php
					$GetArray=array();
					$selectedFieldName=$keyz['FieldName'];
					$selectedCondition=$keyz['Conditions'];
					$EcplodeofCondition=explode(',',$keyz['Conditions']);
					foreach($EcplodeofCondition as $eachCondition)
					{
						$GetQuationSeparte=explode("'",$eachCondition);
						$GetArray[]=$GetQuationSeparte[1];		
						$FinalVariable=$GetQuationSeparte[1];
						}
					$results = multiKeyExists($GetDropdownLists, $FinalVariable);

					if(!empty($results))
					{
					$i++;
					@endphp
					<select id="Conditions{{$i}}" name="Conditions{{$i}}" class="form-control workflowSelect" onchange="UpdateConfiguredFilters('{{$selectedFieldName}}','DESC','2',this.value)" multiple>
						    @foreach($results as $keys=>$kEyZ)
							    @foreach($kEyZ as $key=>$DropDownConditions)
								    @php
								    if(in_array($key,$GetArray))
								    	echo "<option value='$key' selected>$DropDownConditions</option>";
								    else
								    	echo "<option value='$key' title='$FinalVariable'>$DropDownConditions</option>";
								    @endphp
							    @endforeach
						    @endforeach
					</select>

					@php
					}	// on 15th Nov '21
					@endphp
				</td>
				<td title="Click here to remove this condition">
					<input type="button" class="btn btn-danger" value="Remove" name="Remove{{$i}}" id="Remove{{$i}}" onclick="delete_me('{{$selectedCondition}}','{{$i}}')">
				</td>
			</tr>
		@endforeach
</table>
@endif

@if(!empty($New_Filters))
<table class="table style-2 table-hover no-footer" id="table2">
	<thead>
		<tr>
			<th>Date Filter</th>
			<th>Options</th>
			<th>Sort By</th>
			<th></th>
		</tr>
	</thead>
		<tr>
			<td title="Choose the default field for ordering {{$Date_FieldName}}">
				@php
				$selected='';
				$selectedFieldName='';
				@endphp

				<select id="FieldName" name="FieldName" class="form-control workflowSelect" onchange="saveDefaultFilter('4')">
				@foreach($New_Filters as $ColumnName)
					@if($ColumnName==$Date_FieldName)
						@php
						$selected='selected';
						$selectedFieldName=$Date_FieldName;
						@endphp
						@else
						@php
						$selected='';
						//$selectedFieldName='';
						@endphp
					@endif	
					<option value="{{$ColumnName}}" title="{{$ColumnName}} " {{$selected}}>{{$ColumnName}}</option>
				@endforeach
				</select>
			</td>
			<td>	
				<select id="Conditions" name="Conditions" class="form-control workflowSelect" onchange="saveDefaultFilter('4')">
					<!-- <option value="=" {{$C1}}>Equals</option>
					<option value="not_equal" {{$C2}}>Not On</option>
					<option value="greater_than" {{$C3}}>After</option>
					<option value="less_than" {{$C4}}>Before</option> -->
					<option value="last_14_days" {{$C16}}>Last 14 Days</option>
					<option value="last_7_days" {{$C5}}>Last 7 Days</option>
					<option value="next_7_days" {{$C6}}>Next 7 Days</option>
					<option value="next_14_days" {{$C17}}>Next 14 Days</option>
					<option value="last_21_days" {{$C18}}>Last 21 Days</option>
					<option value="next_21_days" {{$C19}}>Next 21 Days</option>
					<option value="last_30_days" {{$C7}}>Last 30 Days</option>
					<option value="next_30_days" {{$C8}}>Next 30 Days</option>
					<option value="last_month" {{$C9}}>Last Month</option>
					<option value="this_month" {{$C10}}>This Month</option>
					<option value="next_month" {{$C11}}>Next Month</option>
					<option value="last_year" {{$C12}}>Last Year</option>
					<option value="this_year" {{$C13}}>This Year</option>
					<option value="next_year" {{$C14}}>Next Year</option>
					 <option value="between" {{$C15}}>Is Between</option> 
				</select>
				@if($C15)
				<div id="DisplayIsBetweenCondition" >
				<input type="text" readonly="readonly" class="form-control  flatpickr flatpickr-input active kab" id="ISFromDate" value="{{$FromDate}}">
				<input type="text" readonly="readonly" class="form-control flatpickr flatpickr-input active kab" id="IdToDate" value="{{$ToDate}}"><br>
				<input type="button" class="btn btn-primary" value="Set IsBetween Date" name="Update Default Filter" id="DefaultFilter" onclick="saveDefaultFilterwithIsBetween('4')"> 
				</div>
				@endif
			</td>
			<td title="Sort by either ascending order or descending order">
				<select id="SortOrder" name="SortOrder" class="form-control workflowSelect" onchange="saveDefaultFilter('4')">
					<option value="DESC" {{$desc}}>Descending</option>
					<option value="ASC" {{$asc}}>Ascending</option>
				</select>
			</td>
			<td title="Click here to update the default condition" nowrap>
				<input type="button" class="btn btn-primary" value="Set as Default" name="Update Default Filter" id="DefaultFilter" onclick="saveDefaultFilter('4')"> 
				<input type="button" class="btn btn-danger" value="Remove" name="RemoveDate" id="RemoveDate" onclick="delete_me('{{$selectedFieldName}}','')">
			</td>
		</tr>
</table>
@endif

@if(!empty($Existing_Filters1))
<table class="table style-2 table-hover no-footer" id="tbl">
	<tr>
	<th>Relate To</th>
	<th>Options</th>
	</tr>
	
	@foreach ($Configured_Filters as $Key)
		@if(in_array($Key->DisplayType,$Relate))
			@php
			$FieldName=$Key->ColumnName;
			@endphp
			<tr>
				<td>{{$Key->ColumnName}}--</td>
				<td>
					@if($Key->DisplayType=='25')
						<select name='{{$Key->ColumnName}}' id='{{$Key->ColumnName}}' class='form-control' onchange="UpdateConfiguredFilters('{{$FieldName}}','','25',this.value)">
						<option value='' >---Select{{$Key->ColumnName}}---</option>
						@foreach($selfRelatedList as $selfRelated)
						<option value="{{$selfRelated['key']}}" > {{$selfRelated['value']}} </option>
						@endforeach
						</select>
					@endif
					
				</td>
			</tr>
				
		@endif
	@endforeach
</table>
@endif

@php
$siteurl=$_SERVER['HTTP_HOST'];
//$url=explode(".",$siteurl);	// crm.bpm360.net
@endphp
<script src="https://{{$siteurl}}/cloud/public/cork/HTML/ltr/demo2/plugins/flatpickr/flatpickr.js"></script>
<script src="https://{{$siteurl}}/cloud/public/cork/HTML/ltr/demo2/plugins/flatpickr/custom-flatpickr.js"></script>
<script type="text/javascript" src="https://{{$siteurl}}/cloud/public/cork/HTML/ltr/demo6/plugins/editors/quill/quill.js"></script>
<script type="text/javascript" src="https://{{$siteurl}}/cloud/public/cork/HTML/ltr/demo6/plugins/editors/quill/custom-quill.js"></script>

<script type="text/javascript">

	$('.kab').each(function(){
		flatpickr($(this), {
			enableTime: true,
			dateFormat: "Y-m-d H:i",
			allowInput: true,
			minuteIncrement:1
		});
		
	});
	
	$("#tbl").on('click', 'input.addButton', function() {
        var $tr = $(this).closest('tr');
        var allTrs = $tr.closest('table').find('tr');
        var lastTr = allTrs[allTrs.length-1];
        var $clone = $(lastTr).clone();
        $clone.find('td').each(function(){
            var el = $(this).find(':first-child');
            var id = el.attr('id') || null;
            if(id) {
                var i = id.substr(id.length-1);
                var prefix = id.substr(0, (id.length-1));
                el.attr('id', prefix+(+i+1));
                el.attr('name', prefix+(+i+1));

    			console.log("For "+i+" id: "+id+" prefix -  "+prefix+" el -  "+JSON.stringify(el));    
            }
        });
        $clone.find('input:text').val('');
        $tr.closest('table').append($clone);
    });

    $("#tbl").on('change', '.FieldNameCls', function(){
        var ConfigIdValue = $(this).val();
        var FieldName = $(this).find('option:selected').text();

        $(this).closest('tr').find('input:text').val(ConfigIdValue);
        var elmId = $(this).attr("id");
		var loopcount=elmId.replace(/[^0-9]/g,'');


		var display_loop="#getDropDownsDiv_"+loopcount;

		var ReportId = document.getElementById('ReportId').value;
		var PrimaryModuleId = document.getElementById('PrimaryModuleId').value;
		var ReportType = document.getElementById('ReportType').value;
		var DisplayType=2;

		console.log("ConfigIdValue: "+ConfigIdValue+ " FieldName: "+FieldName+ " e: "+elmId+ " no: "+loopcount+ "\ndisplay_loop: "+display_loop);

		$.ajaxSetup({
			// headers: {
			// 	'X-CSRF-TOKEN': jQuery('meta[name="csrf-token"]').attr('content')
			// }
		});
		var formData = {
			fieldid: DisplayType,
			ModuleId: PrimaryModuleId,
			DropDownNameId: ConfigIdValue,
			loopcount: loopcount,
			source: "Report",	// Existing
			FieldName: FieldName,	// Existing
		};

		$.ajax({
			url: "{{url('ShowReportsDropDownsOptions')}}",
			type: 'POST',
			data: formData,
	        beforeSend:function() {
	            $(display_loop).html("<div class='loader dual-loader mx-auto'></div>");
	        },
			success: function (result) {
				$(display_loop).html(result);
			},
			error: function (data) {
				console.log(data);
			}
		});

    });
    

	// $('#selectedFields').on('click', '.selectedFieldName', function (event) {
	//    var DemographyConfigId = $(this).find('.row_id1').text();
	//    console.log("Selected DemographyConfigId: "+DemographyConfigId);
	// });

	function DeleteMe(id)
	{
		var no=id.replace(/[^0-9]/g,'');
		console.log("Trying to delete: "+id+" [ "+no);
	    // $("#row" + no).remove();
	}

	$("#tbl").on("click", ".remove_me", function() {
		console.log("delete: ");
	   $(this).closest("tr").remove();
	});
</script>