UserRepo Class Reference

Public Member Functions
	__construct ($dbh, $logger, String $creditUnion)
	Read ($username)
	Create ($data)
	Update ($identifiers, $data)
	Delete ($keys)

Public Attributes
const	TABLE_NAME = '%suser'

Protected Member Functions
	TableName ($creditUnion)

Private Member Functions
	BuildSetColumns ($data, $meta)
	BuildInsertColumns ($data, $meta)
	ColumnByType ($value, $type)

Private Attributes
	$dbh
	$creditUnion
	$logger

Detailed Description

Definition at line 2 of file UserRepo.php.

Constructor & Destructor Documentation

__construct()

UserRepo::__construct	(		$dbh,
			$logger,
		String	$creditUnion
	)

Parameters

resource	$dbh	Database handle
object	$logger	Logger to log
String	$creditUnion

Definition at line 17 of file UserRepo.php.

                                                                    {
        $this->dbh = $dbh;
        $this->logger = $logger;
        $this->creditUnion = $creditUnion;
    }

Member Function Documentation

BuildInsertColumns()

UserRepo::BuildInsertColumns (   $data,   $meta  )

private

Simple helper to collect the column & value strings for inserts

Parameters

array	$data	Array of columns and values
array	$meta	Meta information about the table structure

Returns

array

Definition at line 168 of file UserRepo.php.

                                                      {
        $columns = [];
        $values = [];
        $place = [];
        $count = 1;
        foreach ($data as $column => $value) {
            if (!array_key_exists($column, $meta)) {
                $this->logger->debug("Tried to insert invalid column: $column, into table " . static::TABLE_NAME);
                continue;
            }
            $type = $meta[$column]['type'];
            $columns[] = $column;
            $place[] = "\$$count";
            $values[] = $this->ColumnByType($value, $type);
            $count++;
        }
        return [
            implode(',', $columns),
            implode(',', $place),
            $values,
        ];
    }

BuildSetColumns()

UserRepo::BuildSetColumns (   $data,   $meta  )

private

Simple helper to collect the set values for update

Parameters

array	$data	Array of columns and values
array	$meta	Meta information about the table structure

Returns

array

Definition at line 148 of file UserRepo.php.

                                                   {
        $result = 'SET ';
        $values = [];
        $index = 1;
        foreach ($data as $column => $value) {
            $type = $meta[$column]['type'];
            $result .= "$column = \$$index,\n";
            $index++;
            $values[] = $this->ColumnByType($value, $type);
        }
        return [rtrim($result, ",\n"), $values];
    }

ColumnByType()

UserRepo::ColumnByType (   $value,   $type  )

private

Simple helper to create a database value based on type

Parameters

string	$value	Column value
string	$type	Column type

Returns

string

Definition at line 198 of file UserRepo.php.

                                                 {
        switch (true) {
            case strpos($type, 'int') !== false:
                return intval($value);
                break;
            case strpos($type, 'double') !== false:
            case 'numeric' === $type:
                return floatval($value);
                break;
            case strpos($type, 'char') !== false:
            case 'text' === $type:
                return $value;
                break;
            case strpos($type, 'timestamp') !== false:
            case 'date' === $type:
                return $value;
                break;
            case strpos($type, 'bool') !== false:
                return $value ? 'true' : 'false';
                break;
            default:
                return $value;
        }
    }

Create()

UserRepo::Create

(

$data

)

Create

Parameters

array

$data

Array of data to be inserted [ 'column_name' => 'my new value', ] An empty array or no valid columns will return a False

Returns

bool

Exceptions

Exception

Definition at line 82 of file UserRepo.php.

                                  {
    }

Delete()

UserRepo::Delete

(

$keys

)

Delete feature gate

Parameters

array

$keys

Identifiers

Returns

bool|int

Exceptions

Exception

Definition at line 138 of file UserRepo.php.

                                  {
    }

Read()

UserRepo::Read

(

$username

)

Return user.

Parameters

string

$username

User to retrieve

Returns

array|bool

Definition at line 33 of file UserRepo.php.

                                    {
      $sql = "SELECT  user_id,
                  TRIM(user_name) AS user_name,
                  TRIM(passwd) AS passwd,
                  forcechange AS fchange,
                  COALESCE(forceremain, 0) AS fremain,
                  failedremain,
                  pwchange AS pchange,
                  LOWER(TRIM(email)) AS email,
                  TRIM(confidence) As confidence,
                  group_id AS cuuser_group_id,
                  TRIM(lastlogin) AS llog,
                  TRIM(failedlogin) AS flog,
                  COALESCE(msg_tx, 0) AS msg_tx,
                  userflags,
                  COALESCE(challenge_quest_id, 0) AS savecqid,
                  mfaquest,
                  TRIM(primary_account) As primary_account
              FROM    %s
              WHERE   LOWER(user_name) = '" . strtolower(prep_save($username)) ."'";

        $sql = sprintf($sql, $this->TableName($this->creditUnion));

        $query = db_query($sql, $this->dbh);

        if (!$query) {
          $error = db_last_error();
          $this->logger->error('Could not read table ' . $this->TableName($this->creditUnion) . ". Error: $error");
          return false;
        }
        $rows = db_fetch_all($query);
        if (!$rows) {
          return [];
        }
        return $rows[0];
    }

Update()

UserRepo::Update	(		$identifiers,
			$data
	)

Update

Parameters

array	$identifiers	User identifiers
array	$data	Array of data to be updated [ 'column_name' => 'my new value', ] An empty array or no valid columns will return a False

Returns

bool

Exceptions

Exception

Definition at line 96 of file UserRepo.php.

                                                {
        if (empty($identifiers)) {
            throw new Exception(static::class . ': Did not pass an identifier to update');
        }
        if (empty($data)) {
            throw new Exception(static::class . ': Did not pass any valid columns to update in table ' . $this->TableName($this->creditUnion));
        }
        $meta = db_meta_data($this->dbh, $this->TableName($this->creditUnion));
        list($set, $values) = $this->BuildSetColumns($data, $meta);
        if (empty($set)) {
            throw new Exception(static::class . ': Did not pass any valid columns to update in table ' . $this->TableName($this->creditUnion) );
        }
        $key = '';
        $index = count($values) + 1;
        foreach ($identifiers as $value) {
            $key .= "\$$index,";
            $index++;
        }
        $key = rtrim($key, ',');
        $sql = <<< SQL
UPDATE %s
$set
WHERE user_name IN ($key);
SQL;
        $sql = sprintf($sql, $this->TableName($this->creditUnion) );
        $query = db_query_params($sql, array_merge($values, $identifiers), $this->dbh);
        if (!$query) {
            $error = db_last_error();
            $this->logger->error('Failed updating identifier [' . implode(',', $identifiers) . ": $error");
            return false;
        }
        return true;
    }

Member Data Documentation

TABLE_NAME

const UserRepo::TABLE_NAME = '%suser'

CuUser Repository

Definition at line 7 of file UserRepo.php.

---

The documentation for this class was generated from the following file:

• app/web/banking/library/UserRepo.php