values.php ➔ value_modify_multilined() - Code Metrics - etraxis/etraxis-obsolete - Measure and Improve Code Quality continuously with Scrutinizer

values.php ➔ value_modify_multilined() B
last analyzed 2017-10-02 00:17 UTC

↳ Parent: Project
Complexity

Conditions	6
Paths	3
Size

Total Lines	40
Code Lines	25
Duplication

Lines	40
Ratio	100 %
Importance

Changes
Metric	Value
cc	6
eloc	25
nc	3
nop	4
dl	40
loc	40
rs	8.439
c	0
b	0
f	0
<?php

//------------------------------------------------------------------------------
//
//  eTraxis - Records tracking web-based system
//  Copyright (C) 2005-2011  Artem Rodygin
//
//  This program is free software: you can redistribute it and/or modify
//  it under the terms of the GNU General Public License as published by
//  the Free Software Foundation, either version 3 of the License, or
//  (at your option) any later version.
//
//  This program is distributed in the hope that it will be useful,
//  but WITHOUT ANY WARRANTY; without even the implied warranty of
//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//  GNU General Public License for more details.
//
//  You should have received a copy of the GNU General Public License
//  along with this program.  If not, see <http://www.gnu.org/licenses/>.
//
//------------------------------------------------------------------------------

/**
 * Values
 *
 * This module provides API to work with values of custom fields.
 * See also {@link https://github.com/etraxis/etraxis-obsolete/wiki/tbl_field_values tbl_field_values} database table.
 *
 * @package DBO
 * @subpackage Values
 */

/**#@+
 * Dependency.
 */
require_once('../engine/engine.php');
require_once('../dbo/fields.php');
/**#@-*/

//------------------------------------------------------------------------------
//  Functions.
//------------------------------------------------------------------------------

/**
 * Finds in database and returns a custom field value by its ID.
 *
 * @param int $field_type Field type.
 * @param int $value_id Value ID.
 * @return mixed Custom field value if it's found in database, NULL otherwise.
 */
function value_find ($field_type, $value_id)
{
    debug_write_log(DEBUG_TRACE, '[value_find]');
    debug_write_log(DEBUG_DUMP,  '[value_find] $field_type = ' . $field_type);
    debug_write_log(DEBUG_DUMP,  '[value_find] $value_id   = ' . $value_id);

    $value = NULL;

    if (!is_null($value_id))
    {
        switch ($field_type)
        {
            case FIELD_TYPE_NUMBER:
            case FIELD_TYPE_LIST:
            case FIELD_TYPE_RECORD:

                $value = $value_id;
                break;

            case FIELD_TYPE_FLOAT:


                $rs = dal_query('values/ffndid.sql', $value_id);

                if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                {
                    debug_write_log(DEBUG_ERROR, '[value_find] Float value cannot be found.');
                }
                else
                {
                    $value = $rs->fetch('float_value');
                }

                break;

            case NULL:                  // NULL is used for subject
            case FIELD_TYPE_STRING:


                $rs = dal_query('values/sfndid.sql', $value_id);

                if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                {
                    debug_write_log(DEBUG_ERROR, '[value_find] String value cannot be found.');
                }
                else
                {
                    $value = $rs->fetch('string_value');
                }

                break;

            case FIELD_TYPE_MULTILINED:


                $rs = dal_query('values/tfndid.sql', $value_id);

                if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                {
                    debug_write_log(DEBUG_ERROR, '[value_find] Value cannot be found.');
                }
                else
                {
                    $value = $rs->fetch('text_value');
                }

                break;

            case FIELD_TYPE_CHECKBOX:

                $value = (bool) $value_id;
                break;

            case FIELD_TYPE_DATE:

                $value = get_date($value_id);
                break;

            case FIELD_TYPE_DURATION:

                $value = time2ustr($value_id);
                break;

            default:

                debug_write_log(DEBUG_WARNING, '[value_find] Unknown field type = ' . $field_type);
        }
    }

    return $value;
}

/**
 * Finds in database and returns a text value of list item, which is specified by its integer value.
 *
 * @param int $field_id Field ID.
 * @param int $int_value Value ID.
 * @return string Text value of list item, if it's found in database, NULL otherwise.
 */
function value_find_listvalue ($field_id, $int_value)
{
    debug_write_log(DEBUG_TRACE, '[value_find_listvalue]');
    debug_write_log(DEBUG_DUMP,  '[value_find_listvalue] $field_id  = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_find_listvalue] $int_value = ' . $int_value);

    $res = NULL;

    if (!is_null($int_value))
    {
        $rs = dal_query('values/lvfndk1.sql', $field_id, $int_value);

        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_ERROR, '[value_find_listvalue] Value cannot be found.');
        }
        else
        {
            $res = $rs->fetch('str_value');
        }
    }

    return $res;
}

/**
 * Creates in database an integer value for specified field per specified event.
 *
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param int $field_type Field type.
 * @param int $value Integer value to be stored in database (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_create_number ($event_id, $field_id, $field_type = FIELD_TYPE_NUMBER, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_create_number]');
    debug_write_log(DEBUG_DUMP,  '[value_create_number] $event_id   = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_number] $field_id   = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_number] $field_type = ' . $field_type);
    debug_write_log(DEBUG_DUMP,  '[value_create_number] $value      = ' . $value);

    dal_query('values/create.sql',
              $event_id,
              $field_id,
              $field_type,
              is_null($value) ? NULL : $value);

    return NO_ERROR;
}

/**
 * Modifies in database current integer value of specified field for specified record per specified event.
 *
 * @param int $record_id Record ID.
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param int $value New integer value (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_modify_number ($record_id, $event_id, $field_id, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_modify_number]');
    debug_write_log(DEBUG_DUMP,  '[value_modify_number] $record_id = ' . $record_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_number] $event_id  = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_number] $field_id  = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_number] $value     = ' . $value);

    $rs = dal_query('values/fndk.sql', $record_id, $field_id);

    if ($rs->rows != 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
    {
        $value_id = $rs->fetch('value_id');

        // If current value and new one are different - register changes.
        if ($value_id != $value)
        {
            debug_write_log(DEBUG_NOTICE, '[value_modify_number] Register changes.');

            dal_query('changes/create.sql',
                      $event_id,
                      $field_id,
                      is_null($value_id) ? NULL : $value_id,
                      is_null($value)    ? NULL : $value);
        }
    }

    $rs = dal_query('values/efndid.sql',
                    $record_id,
                    $field_id);

    dal_query('values/modify.sql',
              $rs->fetch('event_id'),
              $field_id,
              is_null($value) ? NULL : $value);

    return NO_ERROR;
}

/**
 * Finds in database specified float value and returns its ID.
 * If specified value doesn't exist in database, creates it there and returns its ID.
 *
 * @param string $value Float value.
 * @return int ID of float value, NULL on error.
 */
function value_find_float ($value)
{
    debug_write_log(DEBUG_TRACE, '[value_find_float]');
    debug_write_log(DEBUG_DUMP,  '[value_find_float] $value = ' . $value);

    $id = NULL;

    if (!is_null($value))
    {
        $rs = dal_query('values/ffndk.sql', $value);

        // Value doesn't exist - must be created.
        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_NOTICE, '[value_find_float] Register float value.');

            dal_query('values/fcreate.sql', $value);
            $rs = dal_query('values/ffndk.sql', $value);
        }

        // Value should exist by this moment.
        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_ERROR, '[value_find_float] Value cannot be found.');
        }
        else
        {
            $id = $rs->fetch('value_id');
        }
    }

    return $id;
}

/**
 * Creates in database a float value for specified field per specified event.
 *
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param int $field_type Field type.
 * @param string $value Float value to be stored in database (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_create_float ($event_id, $field_id, $field_type = FIELD_TYPE_FLOAT, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_create_float]');
    debug_write_log(DEBUG_DUMP,  '[value_create_float] $event_id   = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_float] $field_id   = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_float] $field_type = ' . $field_type);
    debug_write_log(DEBUG_DUMP,  '[value_create_float] $value      = ' . $value);

    $id = value_find_float($value);

    dal_query('values/create.sql',
              $event_id,
              $field_id,
              $field_type,
              is_null($id) ? NULL : $id);

    return NO_ERROR;
}

/**
 * Modifies in database current float value of specified field for specified record per specified event.
 *
 * @param int $record_id Record ID.
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param string $value New float value (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_modify_float ($record_id, $event_id, $field_id, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_modify_float]');
    debug_write_log(DEBUG_DUMP,  '[value_modify_float] $record_id = ' . $record_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_float] $event_id  = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_float] $field_id  = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_float] $value     = ' . $value);

    $id = value_find_float($value);

    $rs = dal_query('values/fndk.sql', $record_id, $field_id);

    if ($rs->rows != 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
    {
        $value_id = $rs->fetch('value_id');

        // If current value and new one are different - register changes.
        if ($value_id != $id)
        {
            debug_write_log(DEBUG_NOTICE, '[value_modify_float] Register changes.');

            dal_query('changes/create.sql',
                      $event_id,
                      $field_id,
                      is_null($value_id) ? NULL : $value_id,
                      is_null($id)       ? NULL : $id);
        }
    }

    $rs = dal_query('values/efndid.sql',
                    $record_id,
                    $field_id);

    dal_query('values/modify.sql',
              $rs->fetch('event_id'),
              $field_id,
              is_null($id) ? NULL : $id);

    return NO_ERROR;
}

/**
 * Finds in database specified single string value and returns its ID.
 * If specified value doesn't exist in database, creates it there and returns its ID.
 *
 * @param string $value String value.
 * @return int ID of string value, NULL on error.
 */
function value_find_string ($value)
{
    debug_write_log(DEBUG_TRACE, '[value_find_string]');
    debug_write_log(DEBUG_DUMP,  '[value_find_string] $value = ' . $value);

    $id = NULL;

    if (!is_null($value))
    {
        $rs = dal_query('values/sfndk.sql', md5($value));

        // Value doesn't exist - must be created.
        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_NOTICE, '[value_find_string] Register string value.');

            dal_query('values/screate.sql', md5($value), $value);
            $rs = dal_query('values/sfndk.sql', md5($value));
        }

        // Value should exist by this moment.
        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_ERROR, '[value_find_string] Value cannot be found.');
        }
        else
        {
            $id = $rs->fetch('value_id');
        }
    }

    return $id;
}

/**
 * Creates in database a single string value for specified field per specified event.
 *
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param int $field_type Field type.
 * @param string $value String value to be stored in database (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_create_string ($event_id, $field_id, $field_type = FIELD_TYPE_STRING, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_create_string]');
    debug_write_log(DEBUG_DUMP,  '[value_create_string] $event_id   = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_string] $field_id   = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_string] $field_type = ' . $field_type);
    debug_write_log(DEBUG_DUMP,  '[value_create_string] $value      = ' . $value);

    $id = value_find_string($value);

    dal_query('values/create.sql',
              $event_id,
              $field_id,
              $field_type,
              is_null($id) ? NULL : $id);

    return NO_ERROR;
}

/**
 * Modifies in database current single string value of specified field for specified record per specified event.
 *
 * @param int $record_id Record ID.
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param string $value New string value (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_modify_string ($record_id, $event_id, $field_id, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_modify_string]');
    debug_write_log(DEBUG_DUMP,  '[value_modify_string] $record_id = ' . $record_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_string] $event_id  = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_string] $field_id  = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_string] $value     = ' . $value);

    $id = value_find_string($value);

    $rs = dal_query('values/fndk.sql', $record_id, $field_id);

    if ($rs->rows != 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
    {
        $value_id = $rs->fetch('value_id');

        // If current value and new one are different - register changes.
        if ($value_id != $id)
        {
            debug_write_log(DEBUG_NOTICE, '[value_modify_string] Register changes.');

            dal_query('changes/create.sql',
                      $event_id,
                      $field_id,
                      is_null($value_id) ? NULL : $value_id,
                      is_null($id)       ? NULL : $id);
        }
    }

    $rs = dal_query('values/efndid.sql',
                    $record_id,
                    $field_id);

    dal_query('values/modify.sql',
              $rs->fetch('event_id'),
              $field_id,
              is_null($id) ? NULL : $id);

    return NO_ERROR;
}

/**
 * Finds in database specified multilined text value and returns its ID.
 * If specified value doesn't exist in database, creates it there and returns its ID.
 *
 * @param string $value Text value.
 * @return int ID of text value, NULL on error.
 */
function value_find_multilined ($value)
{
    debug_write_log(DEBUG_TRACE, '[value_find_multilined]');
    debug_write_log(DEBUG_DUMP,  '[value_find_multilined] $value = ' . $value);

    $id = NULL;

    if (!is_null($value))
    {
        $token = md5($value);

        $rs = dal_query('values/tfndk.sql', "'{$token}'");

        // Value doesn't exist - must be created.
        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_NOTICE, '[value_find_multilined] Register text value.');

            // Oracle BLOB needs specific processing.
            if (DATABASE_DRIVER == DRIVER_ORACLE9)
            {
                $handle = CDatabase::connect()->link->handle;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
                $sql = file_get_contents(LOCALROOT . '/sql/values/oracle/tcreate.sql');

                $stid = ociparse($handle, $sql);
                $clob = ocinewdescriptor($handle, OCI_D_LOB);

                ocibindbyname($stid, ":value_token", $token);
                ocibindbyname($stid, ":text_value",  $clob, -1, OCI_B_CLOB);

                ociexecute($stid, OCI_DEFAULT);
                $clob->save($value);
                ocicommit($handle);
            }
            else
            {
                dal_query('values/tcreate.sql', "'{$token}'", $value);
            }

            $rs = dal_query('values/tfndk.sql', "'{$token}'");
        }

        // Value should exist by this moment.
        if ($rs->rows == 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        {
            debug_write_log(DEBUG_ERROR, '[value_find_multilined] Value cannot be found.');
        }
        else
        {
            $id = $rs->fetch('value_id');
        }
    }

    return $id;
}

/**
 * Creates in database a multilined text value for specified field per specified event.
 *
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param int $field_type Field type.
 * @param string $value Text value to be stored in database (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_create_multilined ($event_id, $field_id, $field_type = FIELD_TYPE_MULTILINED, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_create_multilined]');
    debug_write_log(DEBUG_DUMP,  '[value_create_multilined] $event_id   = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_multilined] $field_id   = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_create_multilined] $field_type = ' . $field_type);
    debug_write_log(DEBUG_DUMP,  '[value_create_multilined] $value      = ' . $value);

    $id = value_find_multilined($value);

    dal_query('values/create.sql',
              $event_id,
              $field_id,
              $field_type,
              is_null($id) ? NULL : $id);

    return NO_ERROR;
}

/**
 * Modifies in database current multilined text value of specified field for specified record per specified event.
 *
 * @param int $record_id Record ID.
 * @param int $event_id Event ID.
 * @param int $field_id Field ID.
 * @param string $value New text value (could be NULL).
 * @return int Always {@link NO_ERROR}.
 */
function value_modify_multilined ($record_id, $event_id, $field_id, $value = NULL)

{
    debug_write_log(DEBUG_TRACE, '[value_modify_multilined]');
    debug_write_log(DEBUG_DUMP,  '[value_modify_multilined] $record_id = ' . $record_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_multilined] $event_id  = ' . $event_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_multilined] $field_id  = ' . $field_id);
    debug_write_log(DEBUG_DUMP,  '[value_modify_multilined] $value     = ' . $value);

    $id = value_find_multilined($value);

    $rs = dal_query('values/fndk.sql', $record_id, $field_id);

    if ($rs->rows != 0)
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
    {
        $value_id = $rs->fetch('value_id');

        // If current value and new one are different - register changes.
        if ($value_id != $id)
        {
            debug_write_log(DEBUG_NOTICE, '[value_modify_multilined] Register changes.');

            dal_query('changes/create.sql',
                      $event_id,
                      $field_id,
                      is_null($value_id) ? NULL : $value_id,
                      is_null($id)       ? NULL : $id);
        }
    }

    $rs = dal_query('values/efndid.sql',
                    $record_id,
                    $field_id);

    dal_query('values/modify.sql',
              $rs->fetch('event_id'),
              $field_id,
              is_null($id) ? NULL : $id);

    return NO_ERROR;
}

?>


etraxis / etraxis-obsolete

values.php ➔ value_modify_multilined() B last analyzed 2017-10-02 00:17 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

values.php ➔ value_modify_multilined() B
last analyzed 2017-10-02 00:17 UTC
