get('username'); // like 'postdata'
}
function publish_action($xcrud)
{
if ($xcrud->get('primary'))
{
$db = Xcrud_db::get_instance();
$query = 'UPDATE base_fields SET `bool` = b\'1\' WHERE id = ' . (int)$xcrud->get('primary');
$db->query($query);
}
}
function unpublish_action($xcrud)
{
if ($xcrud->get('primary'))
{
$db = Xcrud_db::get_instance();
$query = 'UPDATE base_fields SET `bool` = b\'0\' WHERE id = ' . (int)$xcrud->get('primary');
$db->query($query);
}
}
function exception_example($postdata, $primary, $xcrud)
{
$xcrud->set_exception('ban_reason', 'Lol!', 'error');
$postdata->set('ban_reason', 'lalala');
}
function test_column_callback($value, $fieldname, $primary, $row, $xcrud)
{
return $value . ' - nice!';
}
function after_upload_example($field, $file_name, $file_path, $params, $xcrud)
{
$ext = trim(strtolower(strrchr($file_name, '.')), '.');
if ($ext != 'pdf' && $field == 'uploads.simple_upload')
{
unlink($file_path);
$xcrud->set_exception('simple_upload', 'This is not PDF', 'error');
}
}
function date_example($postdata, $primary, $xcrud)
{
$created = $postdata->get('datetime')->as_datetime();
$postdata->set('datetime', $created);
}
function movetop($xcrud)
{
if ($xcrud->get('primary') !== false)
{
$primary = (int)$xcrud->get('primary');
$db = Xcrud_db::get_instance();
$query = 'SELECT `officeCode` FROM `offices` ORDER BY `ordering`,`officeCode`';
$db->query($query);
$result = $db->result();
$count = count($result);
$sort = array();
foreach ($result as $key => $item)
{
if ($item['officeCode'] == $primary && $key != 0)
{
array_splice($result, $key - 1, 0, array($item));
unset($result[$key + 1]);
break;
}
}
foreach ($result as $key => $item)
{
$query = 'UPDATE `offices` SET `ordering` = ' . $key . ' WHERE officeCode = ' . $item['officeCode'];
$db->query($query);
}
}
}
function movebottom($xcrud)
{
if ($xcrud->get('primary') !== false)
{
$primary = (int)$xcrud->get('primary');
$db = Xcrud_db::get_instance();
$query = 'SELECT `officeCode` FROM `offices` ORDER BY `ordering`,`officeCode`';
$db->query($query);
$result = $db->result();
$count = count($result);
$sort = array();
foreach ($result as $key => $item)
{
if ($item['officeCode'] == $primary && $key != $count - 1)
{
unset($result[$key]);
array_splice($result, $key + 1, 0, array($item));
break;
}
}
foreach ($result as $key => $item)
{
$query = 'UPDATE `offices` SET `ordering` = ' . $key . ' WHERE officeCode = ' . $item['officeCode'];
$db->query($query);
}
}
}