@php
	$Configured_Filters=json_decode($ConfiguredFilters);
	$Configured_DefaultFilters=json_decode($ConfiguredDefaultFilters);
	//$RelatedTo_Fields=json_decode($RelatedToFields);
	//$GetSavedRealatedList=$RelatedToFields;	// array();	// $RelatedToFields
	$DefualtFiltersValuesArray=array();

	echo "<pre>";
	foreach($Configured_DefaultFilters as $eachConfiguredDefault)
	{
	$insideArray=array('Conditions'=>$eachConfiguredDefault->Conditions,'SortOrder'=>$eachConfiguredDefault->SortOrder,'FromDate'=>$eachConfiguredDefault->FromDate,'ToDate'=>$eachConfiguredDefault->ToDate,'ShowDateReport'=>$eachConfiguredDefault->ShowDateReport);
		$DefualtFiltersValuesArray[$eachConfiguredDefault->FieldName]=$insideArray;
	}
	//print_r($Configured_Filters);
		//print_r($Configured_DefaultFilters);
		//print_r($DefualtFiltersValuesArray);
		//print_r($RelatedToFields);
		//print_r($GetRealtedModuleFieldList);
		//print_r($RelatedTo_Fields);
		//print_r($AssignedToList);
		//print_r($GetDropdownLists);
	echo "</pre>";
	$Declaringrray=array();
	foreach($Configured_DefaultFilters as $EachConfiguredField)
	{
		$FieldNameArray=$EachConfiguredField->FieldName;
		$GetCondition=$EachConfiguredField->Conditions;
		$ExplodeCondition=explode(',',$GetCondition);
		$eachConditionArray=array();
		foreach($ExplodeCondition as $EachCondition)
		{
			$EachCondition1 = ltrim($EachCondition, "'");
			$EachCondition2 = rtrim($EachCondition1, "'");
			$eachConditionArray[]=$EachCondition2;
		}
		$Declaringrray[$FieldNameArray]=$eachConditionArray;
	}
	$dropdown_array=array("2","3","5","6",15);
@endphp

<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">
					Choose & Add Conditions
				</div>
			</th>
		</tr>
	</thead>
	<tbody>
	@php
	$i=0;
	$GetDateColumns=array();
	@endphp
		@foreach ($Configured_Filters as $Key)
			@if(in_array($Key->DisplayType,$dropdown_array))
				<tr>
					<td>{{$Key->ColumnName}}</td>
					<td>
						@php
							$ThisModuleId=$Key->ModuleName;
							$EachColumnName=$Key->ColumnName;
							if($Key->DisplayType!='15')	
							{
								if($Key->DropDownNameId)
								{	
									$DropDownId=$Key->DropDownNameId;
									if($GetDropdownLists[$DropDownId])
									{
										$ChildDropDown=$GetDropdownLists[$DropDownId];
										@endphp
										<input type="hidden"  id="DropDown{{$Key->ColumnName}}" value="{{$ThisModuleId}}">
										<select id="{{$Key->ColumnName}}" name="Conditions{{$i}}" class="form-control workflowSelect  dd"  multiple>
										@foreach($ChildDropDown as $EachChildDropdownkey=>$EachChildDropdown)
										@if(array_key_exists($EachColumnName,$Declaringrray))
											@if(in_array($EachChildDropdownkey,$Declaringrray[$EachColumnName]))
												<option value="{{$EachChildDropdownkey}}" selected>{{$EachChildDropdown}}</option>
											@else
												<option value="{{$EachChildDropdownkey}}">{{$EachChildDropdown}}</option>
											@endif
										@else
											<option value="{{$EachChildDropdownkey}}">{{$EachChildDropdown}}</option>
										@endif
										@endforeach
										</select>
										@php
									}
								}
							}
							else
							{
								@endphp
									<input type="hidden"  id="DropDown{{$Key->ColumnName}}" value="{{$ThisModuleId}}">
									<select id="{{$Key->ColumnName}}" name="Conditions{{$i}}" class="form-control workflowSelect dd"  multiple>
										@foreach($AssignedToList as $EachUserkey=>$EachUserValue)
											<option value="{{$EachUserValue['RefId']}}">{{$EachUserValue['name']}}</option>
										@endforeach
									</select>
								@php
							}
						@endphp
					</td>
				</tr>
			@endif
			@php
			$i++;
			@endphp
		@endforeach
	</tbody>
</table>
<input type="button" class="form-control" value="Save" onclick="SavetheDDFilters()">
<hr>
	@php 
	$DateColumnsFilters=array();
	$ThisModuleName=array();
	foreach($Configured_Filters as $key)
	{
		if($key->DisplayType==4 || $key->DisplayType==14)
		{
			$ThisModuleId=$key->ModuleName;
			$DateColumnsFilters[$ThisModuleId]=$key->ColumnName;
			$ThisModuleName[$ThisModuleId]=$key->TableName;
		}
	}
	$k=0;
	$Style="none";
	$DisplayFromDate="";
	$DisplayToDate="";
	$CheckReport="";
	$DisplayModuleName="";
	@endphp
	@if($ReportType!=13)
		<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">
					Date Conditions
				</div>
			</th>
		</tr>
	</thead>
	<thead>
		<tr>
			<th>Date Filter</th>
			<th>Options</th>
			<th>Sort By</th>
			<th>show in Report</th>
		</tr>
	</thead>
	<tbody>
		@foreach($DateColumnsFilters as $EachDateColumnModuleId=>$EachDateColumn)
			@php
			$k++;
			$C1='';
			$C2='';
			$C3='';
			$C4='';
			$C5='';
			$C6='';
			$C7='';
			$C8='';
			$C9='';
			$C10='';
			$C11='';
			$C12='';
			$C13='';
			$C14='';
			$C15='';
			$C16='';
			$C17='';
			$C18='';
			$C19='';
			$C20='';
			$C21='';
			$C22='';
			$C23='';
			$C24='';
			$desc='';
			$asc='';
			$Format="0000-00-00 00:00:00";
			if(array_key_exists($EachDateColumn,$DefualtFiltersValuesArray))
			{
				$TempArray=$DefualtFiltersValuesArray[$EachDateColumn];
				$GetCondition=$TempArray['Conditions'];
				$SortOrder=$TempArray['SortOrder'];
				$FromDate=$TempArray['FromDate'];
				$ToDate=$TempArray['ToDate'];
				$ShowDateReport=$TempArray['ShowDateReport'];
			 	$Style="none";
				$DisplayFromDate="";
				$DisplayToDate="";
				$CheckReport="";
				if($FromDate!=$Format)
				{
					$DisplayFromDate=$FromDate;
				}
				if($ToDate!=$Format)
				{
					$DisplayToDate=$ToDate;
				}
				
				if($SortOrder=='DESC')
				{
					$desc='selected';
				}
				else{
					$asc='selected';
				}
				
				if($ShowDateReport==1)
				{
					$CheckReport="checked";
				}
				if($GetCondition!='')
				{
					if($GetCondition=='last_year')
					{
						 $C12="selected";
					}
					elseif($GetCondition=='this_year')
					{
						 $C13="selected";
					}
					elseif($GetCondition=='next_year')
					{
						 $C14="selected";
					}
					elseif($GetCondition=='today')
					{
						 $C20="selected";
					}
					elseif($GetCondition=='this_week')
					{
						 $C21="selected";
					}
					elseif($GetCondition=='MTD')
					{
						 $C22="selected";
					}
					elseif($GetCondition=='YTD')
					{
						 $C23="selected";
					}
					elseif($GetCondition=='YTD')
					{
						 $C24="selected";
					}
					elseif($GetCondition=='last_14_days')
					{
						 $C16="selected";
					}
					elseif($GetCondition=='last_7_days')
					{
						 $C5="selected";
					}
					elseif($GetCondition=='next_7_days')
					{
						 $C6="selected";
					}
					elseif($GetCondition=='next_14_days')
					{
						 $C17="selected";
					}
					elseif($GetCondition=='last_21_days')
					{
						 $C18="selected";
					}
					elseif($GetCondition=='next_21_days')
					{
						 $C19="selected";
					}
					elseif($GetCondition=='last_30_days')
					{
						 $C7="selected";
					}
					elseif($GetCondition=='next_30_days')
					{
						 $C8="selected";
					}
					elseif($GetCondition=='last_month')
					{
						 $C9="selected";
					}
					elseif($GetCondition=='this_month')
					{
						 $C10="selected";
					}
					elseif($GetCondition=='next_month')
					{
						 $C11="selected";
					}
					elseif($GetCondition=='between')
					{
						 $C15="selected";
						 $Style="block";
					}
				}
			}
			@endphp
			<tr>
				<td>{{$EachDateColumn}} </td>
				<td>
					<input type="hidden"  id="DateColumnName{{$k}}" value="{{$EachDateColumn}}">
					<input type="hidden"  id="EachDateColumnModuleId{{$k}}" value="{{$EachDateColumnModuleId}}">
					<select id="DateConditions{{$k}}" name="Conditions" class="form-control workflowSelect DateFilter" onchange="EnableIsbetween('{{$k}}',this.value)">
						<option value="" >All</option>
						<option value="today" {{$C20}}>Today</option>
						<option value="Yesterday" {{$C24}}>Yesterday</option>
						<option value="this_week" {{$C21}}>This Week</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="MTD" {{$C22}}>Month to date</option>
						<option value="YTD" {{$C23}}>Year to date</option>
						 <option value="between" {{$C15}}>Is Between</option> 
					</select>
					<div id="DisplayIsBetweenCondition{{$k}}" style="display:" >
					<input type="text" readonly="readonly" class="form-control  flatpickr flatpickr-input active kab" id="ISFromDate{{$k}}" value="{{$DisplayFromDate}}">
					<input type="text" readonly="readonly" class="form-control flatpickr flatpickr-input active kab" id="IdToDate{{$k}}" value="{{$DisplayToDate}}">
					</div>
				</td>
				<td>
					<select id="DateSortOrder{{$k}}" name="DateSortOrder" class="form-control workflowSelect" >
					<option value="DESC" {{$desc}}>Descending</option>
					<option value="ASC" {{$asc}}>Ascending</option>
				</select>
				</td>
				<td>
					<input type="checkbox" name="CheckboxshowReport{{$k}}"  id="CheckboxshowReport{{$k}}" value="1" {{$CheckReport}}>
				</td>
			</tr>
		@endforeach
	</tbody>
	</table>
	@elseif($ReportType==13)
		<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">
					Date Conditions for Seven Days Report
				</div>
			</th>
		</tr>
	</thead>
	<thead>
		<tr>
			<th>Date Filter</th>
			<th>Select the From Date</th>
			<th>Select Before or After 7 Days</th>
			<th>show in Report</th>
		</tr>
	</thead>
	<tbody>
		@foreach($DateColumnsFilters as $EachDateColumn)
			@php
			$k++;
			$today="";
			$Yesterday="";
			$SelectDate="";
			$Format="0000-00-00 00:00:00";
			
			if(array_key_exists($EachDateColumn,$DefualtFiltersValuesArray))
			{
				$TempArray=$DefualtFiltersValuesArray[$EachDateColumn];
				$GetCondition=$TempArray['Conditions'];
				$SortOrder=$TempArray['SortOrder'];
				$FromDate=$TempArray['FromDate'];
				$ToDate=$TempArray['ToDate'];
				$ShowDateReport=$TempArray['ShowDateReport'];
				$Style="none";
				if($GetCondition!='')
				{
					if($GetCondition=='today')
					{
						 $today="selected";
					}
					elseif($GetCondition=='Yesterday')
					{
						 $Yesterday="selected";
					}
					elseif($GetCondition=='SelectDate')
					{
						 $SelectDate="selected";
						  $Style="block";
					}
				}
			 	
				$DisplayFromDate="";
				$DisplayToDate="";
				$CheckReport="";
				if($FromDate!=$Format)
				{
					$DisplayFromDate=$FromDate;
				}
				if($ToDate!=$Format)
				{
					$DisplayToDate=$ToDate;
				}
				$bfr="";
				$After="";
				if($SortOrder=='bfr')
				{
					$bfr='selected';
				}
				else{
					$After='selected';
				}
			}
			@endphp
			<tr>
				<td>{{$EachDateColumn}}</td>
				<td>
					<input type="hidden"  id="DateColumnName{{$k}}" value="{{$EachDateColumn}}">
					<select id="DateConditions{{$k}}" name="Conditions" class="form-control workflowSelect DateFilter" onchange="EnableIsbetween('{{$k}}',this.value)">
						<option value="" >All</option>
						<option value="today" {{$today}}>Today</option>
						<option value="Yesterday" {{$Yesterday}}>Yesterday</option>
						 <option value="SelectDate"{{$SelectDate}} >SelectDate</option> 
					</select>
					<div id="DisplayIsBetweenCondition{{$k}}" style="display:" >
					<input type="text" readonly="readonly" class="form-control  flatpickr flatpickr-input active kab" id="ISFromDate{{$k}}" value="{{$DisplayFromDate}}">
					</div>
				</td>
				<td>
					<select id="DateSortOrder{{$k}}" name="DateSortOrder" class="form-control workflowSelect" >
						<option value="After" >After 7 Days</option>
						<option value="Bfr" >Before 7 Days</option>
					</select>
				</td>
				<td>
					<input type="checkbox" name="CheckboxshowReport{{$k}}"  id="CheckboxshowReport{{$k}}" value="1" {{$CheckReport}}>
				</td>
			</tr>
		@endforeach
	</tbody>
	</table>
	@endif
	<input type="button" class="form-control" value="Save" onclick="SavetheDateFilters({{$k}})">
<hr>
@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>