I had a problem. I have been using BitWise status indicators for sometime now, in fact after reading
Mark Story's article they have been a staple of development ever since. In my latest work there was a need to turn on or off an item from a menu. I came across this
Nice Trick to toggle Model, which seemed to be perfect but because it is on
or off it wasn't quite what I was looking for.
So I made this. If you'd like to use it, throw it into the AppModel. If you'd like to help make it better, leave a comment and let me know what to do...
[php]function toggleField($field, $data = null, $bitwise = true) {
$field = $this->escapeField($field);
if(empty($data['conditions'])){$data['conditions'] = null;};
if(is_array($data['conditions'])){
//ARRAY :: The user has passed a few conditions so we set that up for an insert.
foreach($data['conditions'] as $object => $property){
$data['conditions'][$this->escapeField($object)] = $property;
unset($data['conditions'][$object]);
}
$query_where = $data['conditions'];
} elseif(!empty($data['conditions']['id'])){
$query_where = array($this->escapeField() => $data['conditions']['id']);
} else {
//DEFAULT :: Where there is no conditions passed, we assume that it is updating the status with the current 'id'.
$data['conditions']['id'] = $this->id;
$query_where = array($this->escapeField() => $data['conditions']['id']);
}
if($bitwise){
$query_string = 'CASE';
$query_string .= ' WHEN '. $field .' & '. $data['switching']['On'] .' THEN ('. $field .' &~ '. $data['switching']['On'] .') | '. $data['switching']['Off'];
$query_string .= ' WHEN '. $field .' & '. $data['switching']['Off'] .' THEN ('. $field .' &~ '. $data['switching']['Off'] .') | '. $data['switching']['On'];
$query_string .= ' WHEN '. $field .' & 0 THEN '. $field .' | '. $data['switching']['On'];
$query_string .= ' ELSE 0';
$query_string .= ' END';
$query_conditions = array($field => $query_string);
} else {
$query = array($field => 'NOT ' . $field);
}
return $this->updateAll($query_conditions, $query_where);
}[/php]
Then to call it I have two ways. Firstly the easy way, where I do not need to specify fields:
[php]function live_not_live($id = null){
if(!empty($id)){
$toggle_field = $this->Category->toggleField('status', array(
'switching' => array('On' => Category::LIVE, 'Off' => Category::NOT_LIVE)
)
);
if($toggle_field){
$this->redirect($this->referer());
};
}
}[/php]
No fields are specified, so it just alters the row with the $id variable.
The next one runs based on some conditions specified to the call. In other words there are two fields that need to be set to change the status.
[php]function lock_unlock_domain($id = null){
if(!empty($id)){
$current_setting = $this->CategoryGroup->findByOurId($id, array('recursive' => -1));
$toggle_field = $this->CategoryGroup->toggleField('status', array(
'conditions' => array('our_id' => $current_setting['CategoryGroup']['our_id'], 'whm_id' => $current_setting['CategoryGroup']['whm_id']),
'switching' => array('On' => Category::LIVE, 'Off' => Category::NOT_LIVE)
)
);
if($toggle_field){
$this->redirect($this->referer());
};
}
}[/php]
And thats it. Status changed in keeping with the Fat Models, Skinny Controllers theory. I am happy with how