@php
if($coloms){
   $str = "";
   $str .= "<option>Please Select</option>";
   foreach($coloms as $key => $val){
      $text = explode(".",$val);
      $str .= '<option value="'.$key.'" data-type="'.$key.'">'.ucfirst(str_replace("_"," ",$text[1])).'</option>';
   }
}
@endphp
   <div class="card mb-2" id="querybuilder{{$table_id}}" style="display:none;">   
      <div class="card-body" >
      <h6 class="card-title">Apply filters</h6><hr> 
      <div class="dynamic_div" >
      @php
      $expstr = "";
      if(isset($expressions)){
         foreach($expressions as $key => $expression){
            if(isset($expression['colom'])){
               if(strpos($expression['colom'],'.')!==false)
                  $colom = explode(".",$expression['colom'])[1];
               else
                  $colom = $expression['colom'];
               $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']."'";
               }
            }
           // echo '<pre>';print_r($expression);
         }
      }
      echo  '<span id="mask">'.$expstr.'</span>';
      @endphp
      <span id="mask{{$table_id}}"></span>
      <span id="fields" style="display:none">{{@$str}}</span>
      <form action="/expression-builder/create" id="myform" 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($coloms)}}">   
      <input name="_token" type="hidden" value="{{ csrf_token() }}"/>                 
     
       @php
       if($expressions){
           foreach($expressions as $key => $expression){
               @endphp
                    <input type="hidden" id="expression_count" value="{{count($expressions)}}">
                    <div class="row py-3 row{{$key}} expression{{$table_id}}" id ="row{{$key}}" count="{{$key}}">
                        <div class="col-md-2">
                           
                              <select class="form-select form-select-sm colom value-required " op_for="table" id="colom{{$key}}" count={{$key}}  name="colom{{$key}}">
                               @foreach($coloms as $colkey => $colom)
                                 @php 
                                   $text = explode(".",$colom);
                                   $coltext = ucfirst(str_replace("_"," ",$text[1])) 
                                 @endphp

                                 @if($colom==$expression['colom'])
                                 {{$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
                                 
                                 <!-- <option value="{{$expression['colom']}}">{{$expression['colom']}}</option> -->
                                 @endforeach
                              </select>
                           
                        </div>
                        <div class="col-md-2">
						
                           
                              <select class="form-select form-select-sm operator value-required " count={{$key}} ref="between{{$key}}" id="operator{{$key}}" name="operator{{$key}}">
                                 @php 
                                    {{ ExpressionBuilderHelper::get_operator_fortable("varchar",$expression['operator']); }}                                 
                                 @endphp
                              </select>
                           
                        </div>
                        <div class="col-md-2">
                           
                              @php $data_type="varchar" @endphp
                              @if($data_type=="datetime" || $data_type == "int" || $data_type == "big_int") 
                                 <select id="value{{$key}}" value="{{$expression['value']}}" count={{$key}}  name="value{{$key}}" class="form-select form-select-sm rounded-{{$key}} value-required " placeholder="Enter Value" required/>
                                    @php 
                                       ExpressionBuilderHelper::date_values($expression['value']);                                 
                                    @endphp
                                 </select>
                              @else
                                  <input type="text"  id="value{{$key}}" value="{{$expression['value']}}" count={{$key}}  name="value{{$key}}" class="form-control form-control-sm rounded-{{$key}} value-required" placeholder="Enter Value" required />
                              @endif
                           
                        </div>
                        @if(@$expression['operator']=="BETWEEN")
                           <div class="col-md-2 between{{$key}}" style="display:block" >
                        @else
                           <div class="col-md-2 between{{$key}}" style="display:none" >
                        @endif
                              <input type="text"  id="betvalue{{$key}}" name="betvalue{{$key}}" count={{$key}}  class="form-control form-control-sm rounded-{{$key}} value-required" value="{{@$expression['between_value']}}" placeholder="Enter Value">
                        </div>

                        <div class="col-md-3 gap-4 d-flex border-{{$key}}">
                              <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'])
                                 <div class="col-md-2 "><span class="badge rounded-pill bg-primary or" op_for="table"  table_id="{{$table_id}}" row={{$key}} role="button">OR</span></div>
                              @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>
                        @if(@$expression['second_colom'])
                        <div class="row py-3 row{{$key}}" count="{{$key}}">
                           or
                           <div class="col-md-2">
                           <select class="form-select form-select-sm colom" op_for="table" count="{{$key}} value-required" id="secolom{{$key}}" name="secolom{{$key}}">
                              @foreach($coloms 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
                                
                                <!-- <option value="{{$expression['colom']}}">{{$expression['colom']}}</option> -->
                                @endforeach 
                             </select>
                           </div>
                           <div class="col-md-2">
                              
                                 <select class="form-select form-select-sm operator value-required " count="{{$key}}" ref="sebetween{{$key}}" id="seoperator{{$key}}" name="seoperator{{$key}}">
                                 @php 
                                    {{ ExpressionBuilderHelper::get_operator_fortable($data_type,$expression['second_operator']); }}                                 
                                 @endphp
                                 </select>
                              
                           </div>
                           <div class="col-md-2">
                           @if($data_type=="datetime" || $data_type == "int" || $data_type == "big_int") 
                                 <select id="sevalue{{$key}}" count="{{$key}}" name="sevalue{{$key}}" class="form-select form-select-sm rounded-{{$key}} value-required " value="{{@$expression['value']}}" placeholder="Enter Value" />
                                    @php 
                                       ExpressionBuilderHelper::date_values($expression['second_value']);                                 
                                    @endphp
                                 </select>
                              @else
                                 <input type="text" id="sevalue{{$key}}" count="{{$key}}" name="sevalue{{$key}}" class="form-control form-control-sm rounded-{{$key}} value-required" value="{{@$expression['second_value']}}" placeholder="Enter Value">
                              @endif
                           </div>
                           @if(@$expression['second_operator']=="BETWEEN")
                              <div class="col-md-2 between{{$key}}" style="display:block" >
                           @else
                              <div class="col-md-2 between{{$key}}" style="display:none" >
                           @endif
                              <input type="text" count="{{$key}}" id="sebetvalue{{$key}}" name="sebetvalue{{$key}}" value="{{@$expression['second_between_value']}}"  class="form-control form-control-sm rounded-{{$key}}" placeholder="Enter Value"></div>
                           
                           <div class="col-md-1"><button type="button" class="btn border-grey  rounded-1 w-1{{$key}}{{$key}}y del" row="{{$key}}">X</button></div>
                        </div>
                        @endif
                   

               @php
                     }
                    // echo '<pre>';print_r($expressions);
       } else {
        @endphp
           <div class="row mb-2 row00 expression{{$table_id}}" id ="row0" count="0" >
               <div class="col-md-2">
                   <select class="form-select form-select-sm colom value-required" op_for="table" id="colom0" count=0  name="colom0">
                       <option value="">Please Select Column</option>
                       @foreach($coloms as $key => $val)
                           @php $text = explode(".",$val); @endphp
                           <option value={{$key}}>{{ucfirst(str_replace("_"," ",$text[1]))}}</option>
                       @endforeach
                   </select>
              </div>
              <div class="col-md-2">
                   <select class="operator form-select form-control-sm  value-required " count=0 ref="between0" id="operator0" name="operator0">
                   <option value="">Choose operator</option>
                   </select>
              </div>
              <div class="col-md-2">
                      <input type="text" id="value0" count=0  name="value0" class="form-control form-control-sm value-required" placeholder="Enter Value" />
              </div>
              <div class="col-md-2 between0" style="display:none" >
                      <input type="text"  id="betvalue0" name="betvalue0" count=0  class="form-control rounded-0" placeholder="Enter Value">
              </div>
              <div class="col-md-3 d-inline-flex">
                  <div class="col-md-2 ">
                       <span class="badge rounded-pill bg-primary and" op_for="table" table_id = "{{$table_id}}" id="and0" row=0 role="button">AND</span>
                  </div>
                  <div class="col-md-1">
                       <span class="badge rounded-pill bg-primary or"  op_for="table" table_id = "{{$table_id}}"  id="or0"  row=0 role="button">OR</span>
                  </div>
              </div>
       </div>
      @php } @endphp
</form>
</div>
    <div class="row">
        <div class="col-md-4">
            <button type="button" table-id = "{{$table_id}}" id="btnsave" class="btn btn-sm btn-primary btnsave">Apply</button>  
            <button type="button" table-id = "{{$table_id}}" id="clear" class="btn btn-sm btn-primary">Clear</button>  
        </div>
    </div>

</div>
</div>