Symbiote\QueuedJobs\QJUtils

Complexity

Total Complexity

15

Size/Duplication

Total Lines	87
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
B	dbQuote()	0	33	7
B	recursiveQuote()	0	24	7
A	ajaxResponse()	0	7	1

<?php

namespace Symbiote\QueuedJobs;

use SilverStripe\Core\Convert;
use SilverStripe\ORM\DB;

/**
 * A set of utility functions used by the queued jobs module
 *
 * @license http://silverstripe.org/bsd-license
 * @author Marcus Nyeholt <marcus@symbiote.com.au>
 */
class QJUtils
{
    /**
     * Quote up a filter of the form
     *
     * array ("ParentID =" => 1)
     *
     * @param array $filter
     * @param string $join
     * @return string
     */
    public function dbQuote($filter = array(), $join = " AND ")
    {
        $quoteChar = defined(DB::class . '::USE_ANSI_SQL') && DB::USE_ANSI_SQL  ? '"' : '';

        $string = '';
        $sep = '';

        foreach ($filter as $field => $value) {
            // first break the field up into its two components
            $operator = '';
            if (is_string($field)) {
                list($field, $operator) = explode(' ', trim($field));
            }

            $value = $this->recursiveQuote($value);

            if (strpos($field, '.')) {
                list($tb, $fl) = explode('.', $field);
                $string .= $sep . $quoteChar . $tb . $quoteChar . '.' . $quoteChar . $fl . $quoteChar
                    . " $operator " . $value;
            } else {
                if (is_numeric($field)) {
                    $string .= $sep . $value;
                } else {
                    $string .= $sep . $quoteChar . $field . $quoteChar . " $operator " . $value;
                }
            }

            $sep = $join;
        }

        return $string;
    }

    /**
     * @param mixed $val
     * @return string
     */
    protected function recursiveQuote($val)
    {
        if (is_array($val)) {
            $return = array();
            foreach ($val as $v) {
                $return[] = $this->recursiveQuote($v);
            }

            return '(' . implode(',', $return) . ')';
        }
        if (is_null($val)) {
            $val = 'NULL';
        } elseif (is_int($val)) {
            $val = (int) $val;
        } elseif (is_double($val)) {
            $val = (double) $val;
        } elseif (is_float($val)) {
            $val = (float) $val;
        } else {
            $val = "'" . Convert::raw2sql($val) . "'";
        }

        return $val;
    }

    /**
     * @param string $message
     * @param string $status
     * @return string
     */
    public function ajaxResponse($message, $status)
    {
        return json_encode(array(
            'message' => $message,
            'status' => $status,
        ));
    }
}