编辑文件 - Setor.php

✏️ 正在编辑: Setor.php

路径: /srv/systems_dir/yuppiecred-lidernegocios/application/models/DbTable/Setor.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php

class Model_DbTable_Setor extends Core_DbTable
{

protected $_primary = 'id';
    protected $_name = 'tb_setores';
    protected $_dependentsTable = array(
        'Model_DbTable_Setor',
    );
    protected $_referenceMap = array(
        'Setor' => array(
            'columns' => array( 'setor_pai' ),
            'refTableClass' => 'Model_DbTable_Setor',
            'refColumns' => array( 'id' )
        )
    );

public function fetchAllParents($order = null)
    {
        $order = $order != null ? $order : "nome ASC";

$parents = $this->fetchAll("(setor_pai = 0 OR setor_pai IS NULL)", $order);

if(is_object($parents)){
            $parents = $parents->toArray();
            
            foreach ($parents as $key => $setor) {
                $setor['children'] = $this->fetchAllChildren($setor['id']);
                $parents[$key] = $setor;
            }
        }

return $parents;
    }

public function fetchAllChildren($parentId)
    {
        $children = array();

$dados = $this->fetchAll("setor_pai = " . $parentId)->toArray();

foreach ($dados as $setor) {
            $setor['children'] = $this->fetchAllChildren($setor['id']);
            array_push($children, $setor);
        }

return $children;
    }

}

← 返回文件管理器