@php
    $keys = array_keys($translation_set);
    if($relational_column){
       $str = "";
       $str .= "<option value>Please Select</option>";
       foreach($relational_column as $key => $value){
          if (in_array($value, $keys))
                $new_value = $translation_set[$value];
             else
                $new_value = $value;
          $str .= '<option value="'.$key.'" data-type="'.$key.'">'.$new_value.'</option>';
       }
    }
    $segments = request()->segments();
    $current_menu  = implode('/',$segments);
@endphp
   <div class="card mb-2" id="querybuilder{{$table_id}}" @php echo (isset($report_view) || (Request::query('view-page'))) ? 'style="display:block"':'style="display:none"'; @endphp>   
      <div class="card-body" >
        <h6 class="card-title">Apply filters</h6><hr> 
            <div class="dynamic_div{{$table_id}}" >
                @php
                    $expstr = "";
                    if(isset($expressions)){
                        if(isset($expressions[0]['parent1'])){
                            $multiple_array = TableBuilderHelper::generateMultileWhereArray($expressions);
                            $multi_array = $multiple_array['multipleor'];
                            foreach($multi_array as $subArray){
                                $expstr .= "<span class='badge me-2 px-2 font_color fw-light filters-labels'>(";
                                foreach($subArray as $key => $expression){
                                    if(is_array($expression['value']))
                                        $expression['value'] = implode(",",$expression['value']);
                                    if(strpos($expression['colname'],'.')!==false)
                                        $colom = explode(".",$expression['colname'])[1];
                                    else
                                        $colom = $expression['colname'];
                                    if($key>0)
                                    $expstr .= " or ";
                                    if(isset($expression['sevalue']))
                                    $expstr .= $colom.' '.$expression['operator']." '".$expression['value']."' and '".$expression['sevalue']."'" ;
                                    else
                                    $expstr .= $colom.' '.$expression['operator']." '".$expression['value']."'";
                                }
                                $expstr .= ") </span>";
                            }
                         }else if(is_array($expressions)) {
                            foreach($expressions as $key => $expression){
                                if(isset($expression['colom'])){
                                    if(strpos($expression['colom'],'.')!==false)
                                        $colom = explode(".",$expression['colom'])[1];
                                    else
                                        $colom = $expression['colom'];
                                    $expression['value'] = explode(" or ",$expression['value'])[0];
                                    $expstr .= $colom.' '.$expression['operator']." '".$expression['value']."'";
                                    if(isset($expression['second_colom'])){
                                        if(strpos($expression['second_colom'],'.')!==false)
                                            $colom = explode(".",$expression['second_colom'])[1];
                                        else
                                            $colom = $expression['second_colom'];
                                        $expstr .=' or '. $colom.' '.$expression['second_operator']." '".$expression['second_value']."'";
                                    }
                                }
                            }
                        }
                    }
                @endphp
                <div id="mask{{$table_id}}" class="mb-2">{!! $expstr !!}</div>
                <span id="fields" style="display:none">{{@$str}}</span>
                <span class="fw-bold pb-1 d-flex">WHERE</span>
                <form action="/expression-builder/create" id="myform{{$table_id}}" name="form"  method="POST">
                    <input type="hidden" name = "hidden_input" value="{{@$input}}">
                    <input type ="hidden" id="{{$table_id}}" name="expression">
                    <input type ="hidden" id="temp_option">
                    <input type ="hidden" id="elem" value="{{$table_id}}" name="element">   
                    <input type ="hidden" id="colom_array" value="{{json_encode($relational_column)}}">  
                    <input type ="hidden" id="colom_array{{$table_id}}" value="{{json_encode($relational_column)}}">   
                    <input name="_token" type="hidden" value="{{ csrf_token() }}"/>                 
                    <div class="row">
                        <div class="col-md-8 query_conditions_{{$table_id}}">
                            @php
                            if($expressions){      
                                if(isset($expressions[0]['parent1'])){
                                    $count = count($multi_array);
                                    echo '<input type="hidden" id="expression_count" value="'.$count.'">';
                                    foreach($multi_array as $key => $array){ 
                                        foreach($array as $k => $expression){
                                            $or_click = count($array)-1-$k; 
                                            @endphp
                                            @if($k>0)
                                                <div class="row mb-2 sub-row" count="{{$key}}" id="row_delete_parent_{{$key}}{{$table_id}}">
                                            @else
                                                @if($key>0)
                                                    <div class="row" ><div class="col-md-12 text-left"><span class="fw-bold pb-1 d-flex">AND</span></div></div>
                                                @endif
                                                <div class="expression{{$table_id}}"><div class="row mb-2 row{{$key}} " id ="row{{$key}}{{$table_id}}" count="{{$key}}">
                                            @endif
                                                <div class="col-md-3">
                                                    <select class="form-select  colom selectop value-required{{$table_id}} " op_for="table" id="colom{{$key}}{{$table_id}}" count={{$key}}  name="colom{{$key}}">
                                                        <option value="">Please Select</option>
                                                        @foreach($relational_column as $colkey => $colom)
                                                            @php 
                                                                $text = explode(".",$colom);
                                                                $coltext = ucfirst(str_replace("_"," ",$text[1])) 
                                                            @endphp
                                                            @if($colom==@$expression['colname'])
                                                                <option value="{{$colkey}}" data-type="{{@$colom->data_type}}" selected>{{$coltext}} {{@$colom->character_maximum_length}}</option>
                                                            @else
                                                                <option value="{{$colom}}" data-type="{{@$colom->data_type}}">{{$coltext}} {{@$colom->character_maximum_length}}</option>
                                                            @endif
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">                    
                                                    <select class="form-select  operator value-required{{$table_id}} " count={{$key}} ref="between{{$key}}" id="operator{{$key}}{{$table_id}}" name="operator{{$key}}">
                                                        @php 
                                                            {{ ExpressionBuilderHelper::get_operator_fortable("varchar",$expression['operator']); }}                                 
                                                        @endphp
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    @php 
                                                        $data_type="varchar";
                                                        if(is_array($expression['value']))
                                                            $expression['value'] = implode(",",$expression['value']);                                                     
                                                    @endphp
                                                    <input type="text"  id="value{{$key}}{{$table_id}}" value="{{@str_replace('%','',$expression['value'])}}" count={{$key}}  name="value{{$key}}" class="form-control   value-required{{$table_id}} value" placeholder="Enter Value"/>
                                                </div>
                                                @if(isset($expression['sevalue']))
                                                    @php 
                                                        $data_type="varchar";
                                                        if(is_array($expression['sevalue']))
                                                            $expression['sevalue'] = implode(",",$expression['sevalue']);                                                     
                                                    @endphp
                                                    <div class="col-md-3">
                                                        <input type="text" count="{{$key}}" id="sebetvalue{{$key}}{{$table_id}}" name="sebetvalue{{$key}}" value="{{@str_replace('%','',$expression['sevalue'])}}"  class="form-control   sevalue" placeholder="Enter Value">
                                                    </div>         
                                                @endif

                                                @if($k>0)
                                                    @php $del_class = "sub-del-table"; @endphp
                                                        <div class="col-md-2">
                                                            <div class="d-flex align-items-center">
                                                                <button type="button" p_for="table" table_id = "{{$table_id}}"  id="or0"  row="{{$k}}" role="button" class="me-3 btn-sm bg-transparent text-dark filter_buttons btn btn-sm btn-primary @if($or_click!=0) border-0 @endif @if($or_click==0) second_or @endif ">@if($or_click==0) + @endif OR</button>
                                                                @if($k>0)    
                                                                    <span class="badge rounded-circle  {{$del_class}}" row="{{$k}}" role="button"  id="row_delete_{{$key}}{{$table_id}}">X</span>
                                                                @endif
                                                        </div>
                                                    </div>
                                                @else
                                                    @php $del_class = "del"; @endphp
                                                    <div class="col-md-2">
                                                        <div class="d-flex align-items-center">
                                                            <!--   <div class="col-md-2 ">
                                                            <button type="button" op_for="table" table_id = "{{$table_id}}" id="and0" row="{{$key}}" role="button" class="btn-sm    bg-transparent text-dark filter_buttons btn btn-sm btn-primary and">AND</button>
                                                            </div> -->
                                                            <button type="button" op_for="table" table_id = "{{$table_id}}"  id="or0"  row="{{$key}}" role="button" class="me-3 btn-sm bg-transparent text-dark filter_buttons btn btn-sm btn-primary @if($or_click!=0) border-0 @endif @if($or_click==0) or @endif ">@if($or_click==0) + @endif OR</button>

                                                            @if(($k>0) || ($or_click==0))
                                                                <span class="badge rounded-circle {{$del_class}}" row="{{$key}}" role="button"  id="row_delete_{{$key}}{{$table_id}}">X</span>
                                                             @endif
                                                        </div>                                                  
                                                    </div>
                                                @endif   
                                                @if($k>0)                  
                                                    </div>  
                                                @else
                                                    </div>  
                                                @endif

                                                @if($or_click==0)
                                                    </div>
                                                @endif
                                            @php   
                                        }
                                    }
                                }else if(is_array($expressions)){
                                    foreach($expressions as $key => $expression){
                                        @endphp
                                        <input type="hidden" id="expression_count" value="{{count($expressions)}}">
                                        <div class="expression{{$table_id}}">
                                            <div class="row mb-2 row{{$key}}" id ="row{{$key}}{{$table_id}}" count="{{$key}}">
                                                <div class="col-md-3">
                                                    <select class="form-select  colom selectop value-required{{$table_id}} " op_for="table" id="colom{{$key}}{{$table_id}}" count={{$key}}  name="colom{{$key}}">
                                                        @foreach($relational_column as $colkey => $colom)
                                                        @php 
                                                        $text = explode(".",$colom);
                                                        $coltext = ucfirst(str_replace("_"," ",$text[1])) 
                                                        @endphp

                                                        @if($colom==@$expression['colom'])
                                                        <option value="{{$colkey}}" data-type="{{@$colom->data_type}}" selected>{{$coltext}} {{@$colom->character_maximum_length}}</option>
                                                        @else
                                                        <option value="{{$colom}}" data-type="{{@$colom->data_type}}">{{$coltext}} {{@$colom->character_maximum_length}}</option>
                                                        @endif
                                                        @endforeach
                                                    </select>
                                                </div>

                                                <div class="col-md-3">
                                                    <select class="form-select  operator value-required{{$table_id}} " count={{$key}} ref="between{{$key}}" id="operator{{$key}}{{$table_id}}" name="operator{{$key}}">
                                                        @php 
                                                            {{ ExpressionBuilderHelper::get_operator_fortable("varchar",@$expression['operator']); }}                                 
                                                        @endphp
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    @php $data_type="varchar" @endphp
                                                    <input type="text"  id="value{{$key}}{{$table_id}}" value="{{@$expression['value']}}" count={{$key}}  name="value{{$key}}" class="form-control   value-required{{$table_id}} value" placeholder="Enter Value" required />
                                                </div>
                                                @if(@$expression['operator']=="BETWEEN")
                                                <div class="col-md-3 between{{$key}}" style="display:block" >
                                                @else
                                                <div class="col-md-3 between{{$key}}" style="display:none" >
                                                @endif
                                                    <input type="text"  id="sevalue{{$key}}{{$table_id}}" name="sevalue{{$key}}" count={{$key}}  class="form-control   value-required{{$table_id}} sevalue" value="{{@$expression['between_value']}}" placeholder="Enter Value">
                                                </div>

                                                <div class="col-md-2">
                                                    <div class="d-flex align-items-center">
                                                        <!--  <div class="col-md-2 "><span class="badge rounded-pill bg-primary and" op_for="table"  table_id="{{$table_id}}" row={{$key}} role="button">AND</span></div> -->
                                                        @if(@$expression['second_operator']) 
                                                        @endphp                                  
                                                        <button type="button" op_for="table"  table_id="{{$table_id}}" row={{$key}} role="button" class="btn-sm bg-transparent text-dark filter_buttons btn btn-sm btn-primary @if($or_click!=0) border-0 @endif @if($or_click==0) or @endif ">@if($or_click==0) + @endif OR</button> 
                                                        @endif
                                                        <!-- <div class="col-md-1">
                                                        <button type="button" class="btn border-grey  rounded-1 w-100y del" row=0>X</button>
                                                        </div> -->
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        @if(@$expression['second_colom'])
                                            <div class="row mb-2 row{{$key}}" count="{{$key}}"  id="row_delete_parent_{{$key}}{{$table_id}}">
                                                <div class="col-md-3">
                                                    <select class="form-select  colom" op_for="table" count="{{$key}} value-required{{$table_id}}" id="secolom{{$key}}{{$table_id}}" name="secolom{{$key}}">
                                                        @foreach($relational_column as $colom)
                                                            @php 
                                                            $text = explode(".",$colom);
                                                            $coltext = ucfirst(str_replace("_"," ",$text[1])) 
                                                            @endphp

                                                            @if($colom==$expression['second_colom'])
                                                            <option value="{{$colom}}" data-type="{{@$colom->data_type}}" selected>{{$coltext}} {{@$colom->character_maximum_length}}</option>
                                                            @else
                                                            <option value="{{$colom}}" data-type="{{@$colom->data_type}}">{{$coltext}} {{@$colom->character_maximum_length}}</option>
                                                            @endif
                                                        @endforeach 
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <select class="form-select  operator value-required{{$table_id}} " count="{{$key}}" ref="sebetween{{$key}}" id="seoperator{{$key}}{{$table_id}}" name="seoperator{{$key}}">
                                                    @php 
                                                    {{ ExpressionBuilderHelper::get_operator_fortable($data_type,$expression['second_operator']); }}                                 
                                                    @endphp
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <input type="text" id="sevalue{{$key}}{{$table_id}}" count="{{$key}}" name="sevalue{{$key}}{{$table_id}}" class="form-control   value-required{{$table_id}} value" value="{{@$expression['second_value']}}" placeholder="Enter Value">
                                                </div>
                                                @if(@$expression['second_operator']=="BETWEEN")
                                                <div class="col-md-3 between{{$key}}" style="display:block" >
                                                @else
                                                <div class="col-md-3 between{{$key}}" style="display:none" >
                                                @endif
                                                    <input type="text" count="{{$key}}" id="sebetvalue{{$key}}{{$table_id}}" name="sebetvalue{{$key}}" value="{{@$expression['second_between_value']}}"  class="form-control  " placeholder="Enter Value">
                                                </div>

                                                <div class="col-md-2">
                                                    <div class="d-flex align-items-center">
                                                        @if($k>0)
                                                            <button type="button" class="badge rounded-circle del" row="{{$key}}"  id="row_delete_{{$key}}{{$table_id}}">X</button>
                                                         @endif
                                                    </div>
                                                </div>
                                            </div>
                                        @endif
                                    @php
                                    }
                                } // Old Expression Logic
                            }else{ // New expression
                                @endphp
                                <div class="expression{{$table_id}}">
                                    <div class="row mb-2 row00 " id ="row0{{$table_id}}" count="0" >
                                        <div class="col-md-3">
                                            <select class="form-select  colom selectop value-required{{$table_id}}" op_for="table" id="colom0{{$table_id}}" count=0  name="colom0">
                                                <option value="">Please Select Column</option>
                                                    @foreach($relational_column as $key => $value)
                                                    @if (in_array($value, $keys))
                                                    @php $new_value = $translation_set[$value];@endphp
                                                    @else
                                                    @php $new_value = $value;@endphp
                                                    @endif
                                                <option value={{$key}}>{{$new_value}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-3">
                                            <select class="operator form-select  value-required{{$table_id}}" count=0 ref="between0{{$table_id}}" id="operator0{{$table_id}}" name="operator0">
                                            <option value="">Choose operator</option>
                                            </select>
                                        </div>
                                        <div class="col-md-3">
                                            <input type="text" id="value0{{$table_id}}" count=0  name="value0" class="form-control  value-required{{$table_id}} value" placeholder="Enter Value" />
                                        </div>
                                        <div class="col-md-3 between0{{$table_id}} between" style="display:none" >
                                            <input type="text"  id="betvalue0{{$table_id}}" name="sevalue0" count=0  class="form-control sevalue" placeholder="Enter Value">
                                        </div>
                                         <div class="col-md-2">
                                            <div class="d-flex align-items-center">
                                                <!-- <div class="col-md-2 ">
                                                <button type="button" op_for="table" table_id = "{{$table_id}}" id="and0" row=0 role="button" class="btn-sm    bg-transparent text-dark filter_buttons btn btn-sm btn-primary and">AND</button>  
                                                </div> -->
                                                <button type="button" op_for="table" table_id = "{{$table_id}}"  id="or0"  row=0 role="button" class="btn-sm    bg-transparent text-dark filter_buttons btn btn-sm btn-primary or">+OR</button> 
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            @php } @endphp
                        </div>
                    </div>
                </form>
                <div class="row mb-2">
                    <div class="col-md-12 float-start">
                        <button type="button" op_for="table" table_id = "{{$table_id}}" id="and0" row=0 role="button" class="btn-sm    btn btn-sm btn-primary bg-transparent text-dark filter_buttons and">+AND</button>  
                    </div>
                </div>
                <div class="row mb-2" @php echo isset($report_view) ? 'style="display:none"':''; @endphp>
                    <div class="col-md-4">
                        <button type="button" table-id = "{{$table_id}}" id="btnsave" class="btn-sm background_color btn btn-sm btn-primary btnsave">Show Results</button>  

                        <button type="button" class="btn-sm  background_color btn btn-sm btn-primary"  name="Save View" role="button"  aria-label="Save View"  data-table_id = {{$table_id}} data-permission_id = {{$permission_id}} data-bs-toggle="modal" data-bs-target="#saveFilterSettings{{$table_id}}">Save</button>

                        <button type="button" table-id = "{{$table_id}}" id="clear" class="btn-sm background_color btn btn-sm btn-primary clear">Clear</button>  
                    </div>
                </div>
            </div>
        </div> 
    </div>