SELECT cac . * FROM `company_account_catalog` cac LEFT JOIN company_balance ON cac.id = company_balance.accountCatalogId WHERE cac.companyId =8 AND company_balance.id IS…
$children = CompanyAccountCatalog::find() ->where(“companyId=$companyId”) ->andWhere($parentId > 0 ?”parentId=$parentId” :”parentId<=0 OR parentId is null”) ->orderBy(new Expression(“apAccountId asc, (apAccountId IS NOT NULL…
SELECT company_account_catalog . * FROM `company_account_catalog` LEFT JOIN company_balance ON company_account_catalog.id = company_balance.accountCatalogId WHERE company_balance.id IS NULL AND company_account_catalog.companyId =8…
Executam un sql fara return : $rez = Yii::$app->getDb()->createCommand($sql)->execute(); Executam un sql cu return : $rez = Yii::$app->getDb()->createCommand($sql)->queryAll() ; …
http://www.yiiframework.com/forum/index.php/topic/53332-unable-to-locate-message-source-for-category/
1. retrieve the (invoice) operations $operations = cfoBi::getOperations() return: Array ( [1] => Goods aquisition [2] => Service aquisition [3]…
Tot ceea ce tine de reguli pentru conturi , balanta , note contabile trebuie sa fie dinamice, si editabile din…
The application must support localization, both for the user interface and for the content. The user interface localization must be…
The business logic core functions are those functions that implement the business logic processes from the lowest abstract level up…
The primary stock functions are located directly on the MySQL server as stored functions/procedures. The reason to do this is…