File DTransactionsModel.php has 460 lines of code (exceeds 250 allowed). Consider refactoring.

Open

<?php
/*******************************************************************************

    Copyright 2013 Whole Foods Co-op

Function normalize has a Cognitive Complexity of 39 (exceeds 5 allowed). Consider refactoring.

Open

    public function normalize($db_name, $mode=BasicModel::NORMALIZE_MODE_CHECK, $doCreate=false)
    {
        $config = FannieConfig::factory();
        $FANNIE_TRANS_DB = $config->get('TRANS_DB');
        $FANNIE_ARCHIVE_DB = $config->get('ARCHIVE_DB');

• Read up
  Read up

Method doc has 144 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function doc()
    {
        return '
Use:
This is IT CORE\'s transaction log. A rather important table.

Method normalize has 127 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function normalize($db_name, $mode=BasicModel::NORMALIZE_MODE_CHECK, $doCreate=false)
    {
        $config = FannieConfig::factory();
        $FANNIE_TRANS_DB = $config->get('TRANS_DB');
        $FANNIE_ARCHIVE_DB = $config->get('ARCHIVE_DB');

Function normalizeLog has a Cognitive Complexity of 18 (exceeds 5 allowed). Consider refactoring.

Open

    public function normalizeLog($view_name, $table_name, $mode=BasicModel::NORMALIZE_MODE_CHECK)
    {
        printf("%s view: %s",
            ($mode==BasicModel::NORMALIZE_MODE_CHECK)?"Would recreate":"Recreating", 
            "$view_name (of table $table_name)\n"

• Read up
  Read up

Method normalizeLog has 53 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function normalizeLog($view_name, $table_name, $mode=BasicModel::NORMALIZE_MODE_CHECK)
    {
        printf("%s view: %s",
            ($mode==BasicModel::NORMALIZE_MODE_CHECK)?"Would recreate":"Recreating", 
            "$view_name (of table $table_name)\n"

Method selectStruct has 48 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    static private function selectStruct($dlog, $start, $end=false)
    {
        $config = FannieConfig::factory();
        $sep = ($config->get('SERVER_DBMS') == 'MSSQL') ? '.dbo.' : '.';
        $FANNIE_TRANS_DB = $config->get('TRANS_DB');

Function selectStruct has a Cognitive Complexity of 13 (exceeds 5 allowed). Consider refactoring.

Open

    static private function selectStruct($dlog, $start, $end=false)
    {
        $config = FannieConfig::factory();
        $sep = ($config->get('SERVER_DBMS') == 'MSSQL') ? '.dbo.' : '.';
        $FANNIE_TRANS_DB = $config->get('TRANS_DB');

• Read up
  Read up

Avoid too many return statements within this method.

Open

        return $union;

Avoid too many return statements within this method.

Open

            return ($dlog) ? $FANNIE_ARCHIVE_DB.$sep.'dlogBig' : $FANNIE_ARCHIVE_DB.$sep.'bigArchive';

Avoid too many return statements within this method.

Open

                return ($dlog) ? $FANNIE_ARCHIVE_DB.$sep.'dlog'.$yyyymm : $FANNIE_ARCHIVE_DB.$sep.'transArchive'.$yyyymm;

Avoid too many return statements within this method.

Open

            return ($dlog) ? $FANNIE_TRANS_DB.$sep.'dlog_90_view' : $FANNIE_TRANS_DB.$sep.'transarchive';