public function getAllByAssetTypeCode($assetTypeCode)
    {
        /* aliases and tables */
        $asType = 'at';
        $asAcc = 'acc';
        /* SELECT FROM prxgt_acc_type_asset */
        $query = $this->conn->select();
        $tbl = $this->resource->getTableName(TypeAsset::ENTITY_NAME);
        $cols = [];
        $query->from([$asType => $tbl], $cols);
        /* LEFT JOIN prxgt_acc_account */
        $tbl = $this->resource->getTableName(Entity::ENTITY_NAME);
        $on = $asAcc . '.' . Entity::A_ASSET_TYPE_ID . '=' . $asType . '.' . TypeAsset::A_ID;
        $cols = [
            Entity::A_ID,
            Entity::A_ASSET_TYPE_ID,
            Entity::A_BALANCE,
            Entity::A_CUST_ID
        ];
        $query->joinLeft([$asAcc => $tbl], $on, $cols);
        /* WHERE */
        $where = $asType . '.' . TypeAsset::A_CODE . '=:' . self::BIND_CODE;
        $query->where($where);
        /* bind vars and fetch results */
        $bind = [self::BIND_CODE => $assetTypeCode];
        $rs = $this->conn->fetchAll($query, $bind);
        $result = [];
        foreach ($rs as $one) {
            $item = new Entity($one);
            $result[$item->getId()] = $item;
        }
        return $result;
    }
public function getAllByAssetTypeCode($assetTypeCode)
    {
        /* aliases and tables */
        $asType = 'at';
        $asAcc = 'acc';
        /* SELECT FROM prxgt_acc_type_asset */
        $query = $this->conn->select();
        $tbl = $this->resource->getTableName(TypeAsset::ENTITY_NAME);
        $cols = [];
        $query->from([$asType => $tbl], $cols);
        /* LEFT JOIN prxgt_acc_account */
        $tbl = $this->resource->getTableName(Entity::ENTITY_NAME);
        $on = $asAcc . '.' . Entity::A_ASSET_TYPE_ID . '=' . $asType . '.' . TypeAsset::A_ID;
        $cols = [
            Entity::A_ID,
            Entity::A_ASSET_TYPE_ID,
            Entity::A_BALANCE,
            Entity::A_CUST_ID
        ];
        $query->joinLeft([$asAcc => $tbl], $on, $cols);
        /* WHERE */
        $where = $asType . '.' . TypeAsset::A_CODE . '=:' . self::BIND_CODE;
        $query->where($where);
        /* bind vars and fetch results */
        $bind = [self::BIND_CODE => $assetTypeCode];
        $rs = $this->conn->fetchAll($query, $bind);
        $result = [];
        foreach ($rs as $one) {
            $item = new Entity($one);
            $result[$item->getId()] = $item;
        }
        return $result;
    }
public function getAllByAssetTypeCode ( $ assetTypeCode ) { /* aliases and tables */ $ asType = 'at' ; $ asAcc = 'acc' ; /* SELECT FROM prxgt_acc_type_asset */ $ query = $ this -> conn -> select ( ) ; $ tbl = $ this -> resource -> getTableName ( TypeAsset :: ENTITY_NAME ) ; $ cols = [ ] ; $ query -> from ( [ $ asType => $ tbl ] , $ cols ) ; /* LEFT JOIN prxgt_acc_account */ $ tbl = $ this -> resource -> getTableName ( Entity :: ENTITY_NAME ) ; $ on = $ asAcc . '.' . Entity :: A_ASSET_TYPE_ID . '=' . $ asType . '.' . TypeAsset :: A_ID ; $ cols = [ Entity :: A_ID , Entity :: A_ASSET_TYPE_ID , Entity :: A_BALANCE , Entity :: A_CUST_ID ] ; $ query -> joinLeft ( [ $ asAcc => $ tbl ] , $ on , $ cols ) ; /* WHERE */ $ where = $ asType . '.' . TypeAsset :: A_CODE . '=:' . self :: BIND_CODE ; $ query -> where ( $ where ) ; /* bind vars and fetch results */ $ bind = [ self :: BIND_CODE => $ assetTypeCode ] ; $ rs = $ this -> conn -> fetchAll ( $ query , $ bind ) ; $ result = [ ] ; foreach ( $ rs as $ one ) { $ item = new Entity ( $ one ) ; $ result [ $ item -> getId ( ) ] = $ item ; } return $ result ; }
Get all accounts by asset type code.

@param string $assetTypeCode
@return \Praxigento\Accounting\Repo\Data\Account[]|null

SELECT
paa.*
FROM prxgt_acc_type_asset pata
LEFT JOIN prxgt_acc_account paa
ON pata.id = paa.asset_type_id
WHERE pata.code = "PV";
Get all accounts by asset type code .