samsoncms / api

     * @param self $return Variable to return found database record

     * @return bool|null|self  Field instance or null if 3rd parameter not passed

     */

    public static function byNameOrID(QueryInterface $query, $nameOrID, self & $return = null)

    {

        // Create id or URL condition

        $idOrUrl = new Condition('OR');

        $idOrUrl->add('FieldID', $nameOrID)->add('Name', $nameOrID);

        // Perform query

        $return = $query->entity(get_called_class())->where($idOrUrl)->first();

        // If only one argument is passed - return null, otherwise bool

        return func_num_args() > 1 ? $return == null : $return;

    }

    /**

     * If this field has defined key=>value set.

     * @param string $locale Locale identifier

     * @return bool|null|self[]  Field instance or null if 3rd parameter not passed

     */

    public static function byMaterialID(

        QueryInterface $query,

        $materialID,

        &$return = null,

        $locale = DEFAULT_LOCALE

    ) {

        $return = $query->entity(get_called_class())

            ->where('MaterialID', $materialID)

            ->where('FieldID', $fieldID)

            ->where('locale', $locale)

            ->exec();

        // If only one argument is passed - return null, otherwise bool

        return func_num_args() > 1 ? $return == null : $return;

    }

    /**

     * Find additional field value database record by its material and field identifiers.

     * @param string $locale Locale identifier

     * @return bool|null|self[]  Field instance or null if 3rd parameter not passed

     */

    public static function byFieldIDAndMaterialID(

        QueryInterface $query,

        $materialID,

        $fieldID,

        &$return = null,

        $locale = DEFAULT_LOCALE

    ) {

        $return = $query->entity(get_called_class())

            ->where('MaterialID', $materialID)

            ->where('FieldID', $fieldID)

            ->where('locale', $locale)

            ->exec();

        // If only one argument is passed - return null, otherwise bool

        return func_num_args() > 1 ? $return == null : $return;

    }

}