Multi-select (type = array) and fieldsets

Comments

• admin

  May 2012 edited 1:19PM

  Unfortunately, the jquery widget used to render that doesn't support optgroups.
• pierlo

  May 2012 edited 1:19PM

  thanks for clarifying!
• markomostar

  January 2021 edited January 2021

  Hi both, I am having problem storing multi field into database. I am getting error: Message: Array to string conversion

  `

          $options = array('a' => 'option A', 'b' => 'option B', 'c' => 'option C');          
          $fields['odobreni_proizvodjaci'] = array('label' => 'Available options:', 'type' => 'multi', 'mode' => 'multi', 'options' => $options);
  

  `

  I would like to save it as JSON if possible. And how can I than Edit this field afterwards if needed?

  Thanks!
• markomostar

  January 2021

  Update: I have managed to save data as JSON by using this below in on_before_save

          if (!empty($values['odobreni_proizvodjaci'])) 
      {
          $priprema = $values['odobreni_proizvodjaci'];
          $pretvori = json_encode($priprema);
  
          $values['odobreni_proizvodjaci'] = $pretvori;
      }
  

  Now just have to reverse the process on editing, populate multi field back. If you can help with that Thanks
• admin

  January 2021

  I think what you want is the serialized_fields on your model:
  https://docs.getfuelcms.com/libraries/my_model

  This is a property on the model that you can specify one or more fields in your model (in an array) that get serialized and deserialized upon retrieval. The default serialization method is JSON.
• markomostar

  January 2021 edited January 2021

  That actually sound good. What I am doing is fetching data with query form one of the tables and populating multi list. I am basically extending Fuel_users_model with few more fields.

  Function inside Fuel_users_model.php:

      public function vratiDobavljace($limit = NULL, $offset = NULL, $col = 'NazivProizvodjaca', $order = 'asc', $just_count = FALSE)
      {
          $CI =& get_instance();
          $this->db->select('NazivProizvodjaca, Proizvodjac');
          $this->db->where('Proizvodjac !=', 0); // gdje je proizvođač različit od nule
          $this->db->group_by("NazivProizvodjaca");
          $this->db->order_by('NazivProizvodjaca ASC');
          $this->db->from('proizvodjaci');
          //$query = $this->db->get();
          $data = parent::list_items($limit, $offset, $col, $order, $just_count);
  
          $mojArray = array( 000 => "------- Odaberite dobavljača -------" );
  
          //$arr = array(35=>"Novi Travnik", 37=>"Sarajevo", 43=>"Mostar");
          foreach ($data as $row)
          {    
              $mojArray += [ $row["Proizvodjac"] => $row["Proizvodjac"]." - ".$row["NazivProizvodjaca"] ];
          }
  
  
          return $mojArray;
      }
  

  Than inside public function form_fields I am using this below:

    $opcije = $this->vratiDobavljace();
    $fields['odaberi_dobavljaca'] = array('label' => 'Brzi odabir dobavljača', 'type' => 'select2', 'size' => 80, 'order' => 9, 'options' => $opcije);
  

  And inside on_before_save($values) function I use this below to prepare data:

       if (!empty($values['odobreni_proizvodjaci'])) 
      {
          $priprema = $values['odobreni_proizvodjaci'];
          $pretvori = json_encode($priprema, JSON_FORCE_OBJECT);
  
          $values['odobreni_proizvodjaci'] = $pretvori;
      }
       return $values;
  

  This saves data into DB and that is fine. Last thing to figure out is how to (on user edit) retrive saved multi field data and display it in the right pane where selected items are.

  I don't really know how to use serialized_fields.
• markomostar

  January 2021

  Thanks, serialized_fields sorted things. It's super easy to use it. Thanks a lot