crocodic-studio / crudbooster

src/helpers/Module.php

Spacing +49 added lines, -49 removed lines

@@ -26,16 +26,16 @@ 
         try {
             $routeArray = request()->route()->getAction();
             $this->controller = class_basename($routeArray['controller']);
-            $this->controller = strtok($this->controller,"@");
+            $this->controller = strtok($this->controller, "@");
 
             $className = "\\".$routeArray["namespace"]."\\".$this->controller;
-            if(class_exists($className)) {
-                $this->module = cb()->find("cb_modules",["controller"=>$this->controller]);
-                if($this->module) {
+            if (class_exists($className)) {
+                $this->module = cb()->find("cb_modules", ["controller"=>$this->controller]);
+                if ($this->module) {
                     $this->controller_class = new $className();
-                    $this->menu = cb()->find("cb_menus",["cb_modules_id"=>$this->module->id]);
-                    $this->menu = (!$this->menu)?cb()->find("cb_menus",["type"=>"path","path"=>request()->segment(2)]):$this->menu;
-                    if($this->menu) {
+                    $this->menu = cb()->find("cb_menus", ["cb_modules_id"=>$this->module->id]);
+                    $this->menu = (!$this->menu) ?cb()->find("cb_menus", ["type"=>"path", "path"=>request()->segment(2)]) : $this->menu;
+                    if ($this->menu) {
                         $this->privilege = DB::table("cb_role_privileges")
                             ->where("cb_menus_id", $this->menu->id)
                             ->where("cb_roles_id", cb()->session()->roleId())
@@ -57,9 +57,9 @@ 
     }
 
     public function getData($key) {
-        if($this->controller_class) {
+        if ($this->controller_class) {
             $value = $this->controller_class->getData($key);
-            if(isset($value)) {
+            if (isset($value)) {
                 return $value;
             }
         }
@@ -70,128 +70,128 @@ 
      * @return CBController
      */
     public function getController() {
-        return ($this->controller_class)?$this->controller_class:null;
+        return ($this->controller_class) ? $this->controller_class : null;
     }
 
     public function getPageTitle()
     {
-        return ($this->controller_class)?$this->controller_class->getData("page_title")?:cb()->getAppName():null;
+        return ($this->controller_class) ? $this->controller_class->getData("page_title") ?: cb()->getAppName() : null;
     }
 
     public function getTable()
     {
-        return ($this->controller_class)?$this->controller_class->getData("table"):null;
+        return ($this->controller_class) ? $this->controller_class->getData("table") : null;
     }
 
     public function getPageIcon()
     {
-        return ($this->controller_class)?$this->controller_class->getData('page_icon')?:"fa fa-bars":null;
+        return ($this->controller_class) ? $this->controller_class->getData('page_icon') ?: "fa fa-bars" : null;
     }
 
     public function canBrowse() {
-        if($this->privilege) {
-            if($this->privilege->can_browse) return true;
+        if ($this->privilege) {
+            if ($this->privilege->can_browse) return true;
             else return false;
-        }else{
+        } else {
             return true;
         }
     }
 
     public function canCreate() {
-        if($this->privilege) {
-            if($this->privilege->can_create) return true;
+        if ($this->privilege) {
+            if ($this->privilege->can_create) return true;
             else return false;
-        }else{
+        } else {
             return true;
         }
     }
 
     public function canRead() {
-        if($this->privilege) {
-            if($this->privilege->can_read) return true;
+        if ($this->privilege) {
+            if ($this->privilege->can_read) return true;
             else return false;
-        }else{
+        } else {
             return true;
         }
     }
 
     public function canUpdate() {
-        if($this->privilege) {
-            if($this->privilege->can_update) return true;
+        if ($this->privilege) {
+            if ($this->privilege->can_update) return true;
             else return false;
-        }else{
+        } else {
             return true;
         }
     }
 
     public function canDelete() {
-        if($this->privilege) {
-            if($this->privilege->can_delete) return true;
+        if ($this->privilege) {
+            if ($this->privilege->can_delete) return true;
             else return false;
-        }else{
+        } else {
             return true;
         }
     }
 
     public function addURL()
     {
-        if($this->controller_class && method_exists($this->controller_class, 'getAdd')) {
+        if ($this->controller_class && method_exists($this->controller_class, 'getAdd')) {
             return action($this->controller.'@getAdd');
-        }else{
+        } else {
             return null;
         }
     }
 
     public function addSaveURL()
     {
-        if($this->controller_class && method_exists($this->controller_class, 'postAddSave')) {
+        if ($this->controller_class && method_exists($this->controller_class, 'postAddSave')) {
             return action($this->controller.'@postAddSave');
-        }else{
+        } else {
             return null;
         }
     }
 
     public function editURL($id = null)
     {
-        if($this->controller_class && method_exists($this->controller_class, 'getEdit')) {
-            return action($this->controller.'@getEdit',['id'=>$id]);
-        }else{
+        if ($this->controller_class && method_exists($this->controller_class, 'getEdit')) {
+            return action($this->controller.'@getEdit', ['id'=>$id]);
+        } else {
             return null;
         }
     }
 
     public function editSaveURL($id = null)
     {
-        if(method_exists($this->controller_class, 'postEditSave')) {
-            return action($this->controller.'@postEditSave',['id'=>$id]);
-        }else{
+        if (method_exists($this->controller_class, 'postEditSave')) {
+            return action($this->controller.'@postEditSave', ['id'=>$id]);
+        } else {
             return null;
         }
     }
 
-    public function detailURL($id=null)
+    public function detailURL($id = null)
     {
-        if($this->controller_class && method_exists($this->controller_class, 'getDetail')) {
-            return action($this->controller.'@getDetail',['id'=>$id]);
-        }else{
+        if ($this->controller_class && method_exists($this->controller_class, 'getDetail')) {
+            return action($this->controller.'@getDetail', ['id'=>$id]);
+        } else {
             return null;
         }
     }
 
-    public function deleteURL($id=null)
+    public function deleteURL($id = null)
     {
-        if($this->controller_class && method_exists($this->controller_class, 'getDelete')) {
-            return action($this->controller.'@getDelete',['id'=>$id]);
-        }else{
+        if ($this->controller_class && method_exists($this->controller_class, 'getDelete')) {
+            return action($this->controller.'@getDelete', ['id'=>$id]);
+        } else {
             return null;
         }
     }
 
     public function url($path = null)
     {
-        if($this->controller_class && method_exists($this->controller_class, 'getIndex')) {
-            return trim(action($this->controller.'@getIndex').'/'.$path,'/');
-        }else{
+        if ($this->controller_class && method_exists($this->controller_class, 'getIndex')) {
+            return trim(action($this->controller.'@getIndex').'/'.$path, '/');
+        } else {
             return null;
         }
     }

src/controllers/DeveloperRolesController.php

Spacing +26 added lines, -26 removed lines

@@ -25,12 +25,12 @@ 
     public function getIndex() {
         $data = [];
         $data['result'] = DB::table("cb_roles")->get();
-        return view($this->view.".index",$data);
+        return view($this->view.".index", $data);
     }
 
     public function getAdd() {
         $data = [];
-        $data['menus'] = DB::table("cb_menus")->orderBy("name","asc")->get();
+        $data['menus'] = DB::table("cb_menus")->orderBy("name", "asc")->get();
         return view($this->view.".add", $data);
     }
 
@@ -49,17 +49,17 @@ 
                 $privilege = [];
                 $privilege["cb_roles_id"] = $roles_id;
                 $privilege["cb_menus_id"] = $menus_id;
-                $privilege["can_browse"]  = @$access['can_browse']?:0;
-                $privilege["can_create"] = @$access['can_create']?:0;
-                $privilege["can_read"] = @$access['can_read']?:0;
-                $privilege["can_update"] = @$access['can_update']?:0;
-                $privilege["can_delete"] = @$access['can_delete']?:0;
+                $privilege["can_browse"]  = @$access['can_browse'] ?: 0;
+                $privilege["can_create"] = @$access['can_create'] ?: 0;
+                $privilege["can_read"] = @$access['can_read'] ?: 0;
+                $privilege["can_update"] = @$access['can_update'] ?: 0;
+                $privilege["can_delete"] = @$access['can_delete'] ?: 0;
                 DB::table("cb_role_privileges")->insert($privilege);
             }
 
             DB::commit();
 
-            return cb()->redirect(route("DeveloperRolesControllerGetIndex"),"The role has been saved!","success");
+            return cb()->redirect(route("DeveloperRolesControllerGetIndex"), "The role has been saved!", "success");
 
         } catch (CBValidationException $e) {
             return cb()->redirectBack($e->getMessage());
@@ -74,21 +74,21 @@ 
         $data['row'] = cb()->find("cb_roles", $id);
 
         $menus = DB::table("cb_menus")
-        ->leftjoin("cb_role_privileges",function($join) use ($id) {
-            $join->on("cb_role_privileges.cb_menus_id","=","cb_menus.id")->where("cb_role_privileges.cb_roles_id", $id);
+        ->leftjoin("cb_role_privileges", function($join) use ($id) {
+            $join->on("cb_role_privileges.cb_menus_id", "=", "cb_menus.id")->where("cb_role_privileges.cb_roles_id", $id);
         })
-        ->orderBy("cb_menus.name","asc")
-        ->select("cb_menus.*","can_browse","can_create","can_read","can_update","can_delete")
+        ->orderBy("cb_menus.name", "asc")
+        ->select("cb_menus.*", "can_browse", "can_create", "can_read", "can_update", "can_delete")
         ->get();
         $data['menus'] = $menus;
 
-        return view($this->view.".edit",$data);
+        return view($this->view.".edit", $data);
     }
 
     private function existsPrivilege($cb_roles_id, $cb_menus_id) {
-        if($row = cb()->find("cb_role_privileges",['cb_roles_id'=>$cb_roles_id,'cb_menus_id'=>$cb_menus_id])) {
+        if ($row = cb()->find("cb_role_privileges", ['cb_roles_id'=>$cb_roles_id, 'cb_menus_id'=>$cb_menus_id])) {
             return $row->id;
-        }else{
+        } else {
             return null;
         }
     }
@@ -97,26 +97,26 @@ 
         try {
             cb()->validation(['name', 'menus']);
 
-            cb()->updateCompact("cb_roles",$id,['name']);
+            cb()->updateCompact("cb_roles", $id, ['name']);
 
             foreach (request("menus") as $menus_id) {
                 @$access = request("access")[$menus_id];
                 $privilege = [];
                 $privilege["cb_roles_id"] = $id;
                 $privilege["cb_menus_id"] = $menus_id;
-                $privilege["can_browse"]  = @$access['can_browse']?:0;
-                $privilege["can_create"] = @$access['can_create']?:0;
-                $privilege["can_read"] = @$access['can_read']?:0;
-                $privilege["can_update"] = @$access['can_update']?:0;
-                $privilege["can_delete"] = @$access['can_delete']?:0;
-                if($privilege_id = $this->existsPrivilege($id, $menus_id)) {
+                $privilege["can_browse"]  = @$access['can_browse'] ?: 0;
+                $privilege["can_create"] = @$access['can_create'] ?: 0;
+                $privilege["can_read"] = @$access['can_read'] ?: 0;
+                $privilege["can_update"] = @$access['can_update'] ?: 0;
+                $privilege["can_delete"] = @$access['can_delete'] ?: 0;
+                if ($privilege_id = $this->existsPrivilege($id, $menus_id)) {
                     DB::table("cb_role_privileges")->where("id", $privilege_id)->update($privilege);
-                }else{
+                } else {
                     DB::table("cb_role_privileges")->insert($privilege);
                 }
             }
 
-            return cb()->redirect(route("DeveloperRolesControllerGetIndex"),"The role has been saved!","success");
+            return cb()->redirect(route("DeveloperRolesControllerGetIndex"), "The role has been saved!", "success");
 
         } catch (CBValidationException $e) {
 
@@ -126,9 +126,9 @@ 
 
     public function getDelete($id) {
         DB::table("cb_roles")->where("id", $id)->delete();
-        DB::table("cb_role_privileges")->where("cb_roles_id",$id)->delete();
+        DB::table("cb_role_privileges")->where("cb_roles_id", $id)->delete();
 
-        return cb()->redirect(route("DeveloperRolesControllerGetIndex"), "The role has been deleted!","success");
+        return cb()->redirect(route("DeveloperRolesControllerGetIndex"), "The role has been deleted!", "success");
     }
 
 }
\ No newline at end of file

src/controllers/scaffolding/traits/ColumnsRegister.php

Spacing +38 added lines, -38 removed lines

@@ -59,8 +59,8 @@ 
         $data = new TextModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("text");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -75,8 +75,8 @@ 
         $data = new CheckboxModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("checkbox");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -91,8 +91,8 @@ 
         $data = new PasswordModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("password");
         $data->setShowDetail(false);
         $data->setShowIndex(false);
@@ -109,8 +109,8 @@ 
         $data = new ImageModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("image");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -125,8 +125,8 @@ 
         $data = new TextAreaModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("text_area");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -141,7 +141,7 @@ 
         $data = new SelectTableModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
+        $data->setName($this->name($label, $name));
         $data->setField($this->name($label, $name));
         $data->setType("select_table");
 
@@ -149,8 +149,8 @@ 
 
         $selectTable = new SelectTable($this->index);
 
-        if($selectConfig) {
-            $selectTable->optionsFromTable($selectConfig['table'],$selectConfig['value_option'],$selectConfig['display_option'],@$selectConfig['sql_condition']);
+        if ($selectConfig) {
+            $selectTable->optionsFromTable($selectConfig['table'], $selectConfig['value_option'], $selectConfig['display_option'], @$selectConfig['sql_condition']);
         }
 
         return $selectTable;
@@ -163,7 +163,7 @@ 
         $data = new SelectOptionModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
+        $data->setName($this->name($label, $name));
         $data->setField($this->name($label, $name));
         $data->setType("select_option");
 
@@ -171,7 +171,7 @@ 
 
         $selectOption = new SelectOption($this->index);
 
-        if($options) {
+        if ($options) {
             $selectOption->options($options);
         }
 
@@ -191,15 +191,15 @@ 
         $data = new SelectQueryModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
+        $data->setName($this->name($label, $name));
         $data->setField($this->name($label, $name));
         $data->setType("select_query");
 
         columnSingleton()->setColumn($this->index, $data);
 
-        $selectQuery =new SelectQuery($this->index);
+        $selectQuery = new SelectQuery($this->index);
 
-        if($query) {
+        if ($query) {
             $selectQuery->optionsFromQuery($query);
         }
 
@@ -214,8 +214,8 @@ 
         $data = new CustomModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("custom");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -230,8 +230,8 @@ 
         $data = new DateModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("date");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -246,8 +246,8 @@ 
         $data = new DatetimeModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("datetime");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -262,8 +262,8 @@ 
         $data = new EmailModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("email");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -278,8 +278,8 @@ 
         $data = new FileModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("file");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -295,8 +295,8 @@ 
         $data = new HiddenModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("hidden");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -311,8 +311,8 @@ 
         $data = new NumberModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("number");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -327,8 +327,8 @@ 
         $data = new MoneyModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("money");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -343,8 +343,8 @@ 
         $data = new RadioModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("radio");
 
         columnSingleton()->setColumn($this->index, $data);
@@ -359,8 +359,8 @@ 
         $data = new WysiwygModel();
         $data = $this->setDefaultModelValue($data);
         $data->setLabel($label);
-        $data->setName($this->name($label,$name));
-        $data->setField($field_to_save?:$this->name($label, $name));
+        $data->setName($this->name($label, $name));
+        $data->setField($field_to_save ?: $this->name($label, $name));
         $data->setType("wysiwyg");
 
         columnSingleton()->setColumn($this->index, $data);

src/types/select_option/SelectOption.php

Spacing +3 added lines, -3 removed lines

@@ -21,10 +21,10 @@
     public function options($data_options) {
         $data = columnSingleton()->getColumn($this->index);
 
-        foreach($data_options as $key=>$option) {
-            if(is_int($key)) {
+        foreach ($data_options as $key=>$option) {
+            if (is_int($key)) {
                 $data_options[$option] = $option;
-            }else{
+            } else {
                 $data_options[$key] = $option;
             }
         }

src/types/select_option/component.blade.php

Spacing +1 added lines, -1 removed lines

@@ -7,7 +7,7 @@
             name="{{ $column->getName() }}" id="{{ $column->getName() }}">
         <option value="">** Select a {{ $column->getLabel() }}</option>
         <?php
-            $columnValue = old($column->getName())?:($column->getDefaultValue())?:$column->getValue();
+            $columnValue = old($column->getName()) ?: ($column->getDefaultValue()) ?: $column->getValue();
         ?>
         @foreach($column->getOptions() as $key=>$value)
             <option {{ $columnValue==$key?'selected':'' }} value="{{ $key }}">{{ $value }}</option>

src/types/select_option/Hook.php

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
     {
         $option = $column->getOptions();
         $key = $row->{ $column->getField() };
-        return @$option[ $key ];
+        return @$option[$key];
     }
 
     public function detailRender($row, $column)

src/types/select_table/Route.php

Spacing +2 added lines, -2 removed lines

@@ -1,5 +1,5 @@
 <?php
 
-cb()->routeGroupBackend(function () {
-    cb()->routePost("select-table-lookup",'\crocodicstudio\crudbooster\types\select_table\SelectTableController@postLookup');
+cb()->routeGroupBackend(function() {
+    cb()->routePost("select-table-lookup", '\crocodicstudio\crudbooster\types\select_table\SelectTableController@postLookup');
 });
\ No newline at end of file

src/types/select_table/component.blade.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
         <option value="">** Select a {{ $column->getLabel() }}</option>
         @if(!$column->getForeignKey())
             <?php
-                $columnValue = old($column->getName())?:($column->getDefaultValue())?:$column->getValue();
+                $columnValue = old($column->getName()) ?: ($column->getDefaultValue()) ?: $column->getValue();
             ?>
             @foreach($column->getOptions() as $key=>$value)
                 <option {{ $columnValue==$key?'selected':'' }} value="{{ $key }}">{{ $value }}</option>

src/types/select_table/SelectTable.php

Spacing +4 added lines, -4 removed lines

@@ -41,13 +41,13 @@ 
      */
     public function optionsFromTable($table, $value_option, $display_option, $SQLCondition = null) {
 
-        if(strpos($table,"App\Models")!==false) {
+        if (strpos($table, "App\Models") !== false) {
             $table = new $table();
             $table = $table::$tableName;
         }
 
         $data = DB::table($table);
-        if($SQLCondition && is_callable($SQLCondition)) {
+        if ($SQLCondition && is_callable($SQLCondition)) {
             $data = call_user_func($SQLCondition, $data);
         }elseif ($SQLCondition && is_string($SQLCondition)) {
             $data->whereRaw($SQLCondition);
@@ -55,11 +55,11 @@ 
         $data = $data->get();
         $options = [];
         foreach ($data as $d) {
-            $options[ $d->$value_option ] = $d->$display_option;
+            $options[$d->$value_option] = $d->$display_option;
         }
         $data = columnSingleton()->getColumn($this->index);
         /** @var $data SelectTableModel */
-        $data->setOptionsFromTable(["table"=>$table,"key_field"=>$value_option,"display_field"=>$display_option,"sql_condition"=>$SQLCondition]);
+        $data->setOptionsFromTable(["table"=>$table, "key_field"=>$value_option, "display_field"=>$display_option, "sql_condition"=>$SQLCondition]);
         columnSingleton()->setColumn($this->index, $data);
 
         $this->options($options);