Adding new filter to module in admin panel?

Comments

• ryoyin

  February 2015 edited 6:15PM

  ok I found that I can do it in this way:
  $config['modules']['Locations'] = array(
  'filters' => array(
  'parent_id' => array(
  'default' => 1,
  'label' => 'Parent',
  'type' => 'select',
  'options' => array(
  1 => 'United Kingdom',
  2 => 'United State'
  )
  )
  ),
  );
  
  And I got these problems:
  1. options - can I retrieve the list in the db?
  2. where is the doc about this filter?
• admin

  February 2015 edited 6:15PM

  1. You can specify a model in your configuration like so:
  http://docs.getfuelcms.com/general/forms#select
  2. There isn't a great section in the documentation yet about filtering but this area in the tutorial talks some about it:
  http://docs.getfuelcms.com/modules/tutorial
• ryoyin

  February 2015 edited 6:15PM

  thanks for your information
  
  I am facing a new problem now. Just now I fail to create new record to database using fuelcms. All custom code have been commeted, only the basic code left now and I still cannot create record probably.
  
  Table and code shown as below:
  CREATE TABLE `zy_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `location_iso3` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_country_id` int(11) DEFAULT NULL,
  `location_state_id` int(11) DEFAULT NULL,
  `location_province_id` int(11) DEFAULT NULL,
  `location_city_id` int(11) DEFAULT NULL,
  `location_parentid` int(11) DEFAULT NULL,
  `location_type` int(11) DEFAULT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `route_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `createDate` datetime DEFAULT NULL,
  `lastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `routeName_UNIQUE` (`route_name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  <?php if (!defined('BASEPATH')) exit('No direct script access allowed');
  
  require_once(FUEL_PATH.'models/base_module_model.php');
  
  class Locations_model extends Base_module_model {
  
  // public $foreign_keys = array('location_type' => 'location_types_model',
  // 'currency_id' => 'currencies_model');
  
  function __construct()
  {
  parent::__construct('zy_locations');
  }
  
  }
  
  
  class Location_model extends Base_module_record {
  
  }
  
  I have really no idea whats happening....
• ryoyin

  February 2015 edited 6:15PM

  aiya, it actually saved my form data. It replace the exisiting record instead of inserting a new one. I am wonder why it run update instead of insert. Just a very simple action....
• admin

  February 2015 edited 6:15PM

  I'm curious why you have a unique key for ID when the primary key is already unique. Also, is the route_name you are saving different between the records (if left empty then it probably isn't)? FUEL's save command's default behavior is to try an insert with INSERT IGNORE but if if it runs into a key collision it does ON DUPLICATE KEY UPDATE. To avoid unique key issues there is $unique_fields property you can set on your model. The value should be an array listing any unique fields. If there is a compound key (multiple fields), you can use an array inside that array.
• ryoyin

  February 2015 edited 6:15PM

  woot yeat!
  it work again, thanks for the advice