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, ', ');