CuAdminRepo Class Reference

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

Public Attributes
const	TABLE_NAME = 'cuadmin'

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 CuAdminRepo.php.

Constructor & Destructor Documentation

__construct()

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

Parameters

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

Definition at line 17 of file CuAdminRepo.php.

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

Member Function Documentation

BuildInsertColumns()

CuAdminRepo::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 158 of file CuAdminRepo.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()

CuAdminRepo::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 138 of file CuAdminRepo.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()

CuAdminRepo::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 188 of file CuAdminRepo.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()

CuAdminRepo::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 72 of file CuAdminRepo.php.

                                  {
    }

Delete()

CuAdminRepo::Delete

(

$keys

)

Delete feature gate

Parameters

array

$keys

Identifiers

Returns

bool|int

Exceptions

Exception

Definition at line 128 of file CuAdminRepo.php.

                                  {
    }

Read()

CuAdminRepo::Read

(

$creditUnion

)

Return cuadmin.

Returns

array|bool

Definition at line 32 of file CuAdminRepo.php.

                                       {

      $query = "SELECT COALESCE(flagset, 0) as flagset,
        COALESCE(flagset2, 0) as flagset2,
        COALESCE(flagset3, 0) as flagset3,
        livewait,
        TRIM(lastupdate) as lastupdate,
        min_chlng_qst,
        pname,
        COALESCE(histdays, 0) as fhdays,
        COALESCE(gracelimit, 0) as grace,
        trmemomaxlen,
        TRIM(cu) as cu
        FROM %s
        WHERE LOWER(cu) = '". strtolower(prep_save($creditUnion)) ."'";

      $query = sprintf($query, static::TABLE_NAME);
      $sth = db_query($query, $this->dbh);
      $rows = db_fetch_all($sth);

      if (!$rows) {
        throw new Exception('CuAdmin: Problem getting credit union settings!');;
      }
      // $admininfo = $rows[0];
      // $this->admininfo = $admininfo;
      return $rows[0];
    }

Update()

CuAdminRepo::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 86 of file CuAdminRepo.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 cu 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 CuAdminRepo::TABLE_NAME = 'cuadmin'

CuAdmin Repository

Definition at line 7 of file CuAdminRepo.php.

---

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

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