public function reordermanual()
{
$object = new Crud_Models_Object();
$object->load($_POST['object_id']);
$field = new Crud_Models_Field();
$field->load($_POST['field_id']);
$row = new Libraries_Db_Mysql_Model($object->table_name);
$row->load($_POST['row_id']);
$where = array();
$order = array();
$replacement_row = new Libraries_Db_Mysql_Model($object->table_name);
$replacement_row->load(intval($_POST['value']), $field->field_name);
if ($replacement_row->isEmpty()) {
$sql = "SELECT MIN({$field->field_name}) as min, MAX({$field->field_name}) as max\r\n\t\t\t\t\tFROM {$object->table_name}\r\n\t\t\t\t\tWHERE is_deleted = 0";
$min_max = Libraries_Db_Factory::getDb()->fetchRow($sql, array(), Libraries_Db_Adapter::FETCH_TYPE_CLASS);
if ($_POST['value'] < $min_max->min) {
$replacement_row = $replacement_row->load($min_max->min, $field->field_name);
$_POST['value'] = $min_max->min;
}
if ($_POST['value'] > $min_max->max) {
$replacement_row = $replacement_row->load($min_max->max, $field->field_name);
$_POST['value'] = $min_max->max;
}
/*
$response = array();
$response['error'] = 'Can\'t find this object';
echo json_encode($response);
return;
*/
}
$replacement_row->{$field->field_name} = $row->{$field->field_name};
$replacement_row->save();
$row->{$field->field_name} = $_POST['value'];
$row->save();
$response = array();
$response['success'] = 1;
echo json_encode($response);
return;
}
<?php
$table_name = $control_properties->table_name;
$conditional_field_id = $control_properties->conditional_field_id;
if (!empty($table_name)) {
$sys_object = new Crud_Models_Object();
$sys_object->load($table_name, 'table_name');
$sys_object->loadFieldsForObject();
} else {
$sys_field = new Crud_Models_Field();
$sys_field->load($conditional_field_id);
$sys_field->loadControl();
$sys_object = new Crud_Models_Object();
$sys_object->load($row->{$sys_field->field_name});
$sys_object->loadFieldsForObject();
}
$text_value = '';
if ($value) {
$row = new Libraries_Db_Mysql_Model($sys_object->table_name);
$row->load($value);
if (!$row->isEmpty()) {
foreach ($sys_object->sys_field_list as $sys_field) {
if ($sys_field->is_identification == 1 && array_key_exists($sys_field->field_name, $row->data)) {
$text_value .= $row->{$sys_field->field_name} . ', ';
}
}
}
}
echo trim($text_value, ', ');
