rul2

    public function search(Request $request)
    {
        $rule_name=$request->get('rule_name');
        $updated=$request->get('updated');
        $created=$request->get('created');
        $sid=$request->get('sid');
        $version=$request->get('version');

      $filters = [
            'rule_name' => $request->get('rule_name'),
            'updated' => $request->get('updated'),
            'created' => $request->get('created'),
            'sid'    => $request->get('sid'),
            'version'    => $request->get('version'),
        ];






        // $order=DB::select(DB::raw("SELECT * from rules ORDER BY updated  ASC"));

         $rules= Rules::where(function ($query) use ($filters) {
            if ($filters['rule_name']) {
                $query->where('rule_name', '=', $filters['rule_name']);
            }
            if ($filters['updated']) {


                $query->orderBy('updated', 'DESC');


            }
             if ($filters['sid']) {
                $query->where('sid', '=', $filters['sid']);
            }
            if ($filters['version']) {
                $query->where('version', '=', $filters['version']);
            }
            });

            $rule_q=Rules::$rules; //kiv

            if(!empty($filters['updated'] && $filters['updated']=="tooldest")) {

                $rule_q->orderBy('updated','DESC');




            }

            $rules=$rule_q->get();

             return view('rules.index',['rules'=>$rules]);

           }