/**
* get Account balance
*
* @param Account $account
* @param DateTime $stop
* @param DateTime $start
*
* @return float $amount
*/
public function getBalance(Account $account, DateTime $stop = null, DateTime $start = null)
{
$qb = $this->createQueryBuilder('a');
$qb->select('SUM(a.amount)');
$qb->where('a.account = :accountId');
$qb->setParameter('accountId', $account->getId());
$qb->leftJoin('ElcwebAccountingBundle:Transaction', 't', 'WITH', 'a.transaction = t.id');
if ($stop) {
$qb->andWhere($qb->expr()->lte('t.date', ':endDate'));
$qb->setParameter('endDate', $stop->format('Y-m-d'));
}
if ($start) {
$qb->andWhere($qb->expr()->gte('t.date', ':startDate'));
$qb->setParameter('startDate', $start->format('Y-m-d'));
}
return $qb->getQuery()->getSingleScalarResult() + 0;
// +0 is to convert string to number.
}
public function create($name, $slug, $tags = array(), $parent = null)
{
$repo = $this->em->getRepository('ElcwebAccountingBundle:Account');
$parentAccount = $repo->findOneBySlug($parent);
if (!$parentAccount) {
// todo: throw error
}
// todo: validate if not existent
$account = $repo->findOneBySlug($slug);
if (!$account) {
$account = new Account();
$account->setParent($parentAccount);
$account->setName($name);
$account->setSlug($slug);
$account->setType($parentAccount->getType());
foreach ($tags as $tag) {
$tag = $this->tm->loadOrCreateTag($tag);
$this->tm->addTag($tag, $account);
}
$this->em->persist($account);
$this->em->flush();
$this->tm->saveTagging($account);
}
}
/**
* {@inheritDoc}
*
* Ref : http://en.wikipedia.org/wiki/Chart_of_accounts#Types_of_accounts
*/
public function load(ObjectManager $manager)
{
/** @var $accountTypeDebit AccountType */
$accountTypeDebit = $this->getReference('typeDebit');
// load the stored reference
/** @var $accountTypeCredit AccountType */
$accountTypeCredit = $this->getReference('typeCredit');
$root = new Account();
$root->setName('Root');
$root->setSlug('root');
$root->setType($accountTypeDebit);
$manager->persist($root);
// Assets / Actif
$assets = new Account();
$assets->setName('Assets');
$assets->setParent($root);
$assets->setType($accountTypeDebit);
$manager->persist($assets);
$this->addReference('account_assets', $assets);
// Assets : Cash
$cash = new Account();
$cash->setName('Cash');
$cash->setParent($assets);
$cash->setType($accountTypeDebit);
$manager->persist($cash);
$this->addReference('account_cash', $cash);
// Assets : Accounts Receivable
$receivable = new Account();
$receivable->setName('Accounts Receivable');
$receivable->setParent($assets);
$receivable->setType($accountTypeDebit);
$manager->persist($receivable);
$this->addReference('account_receivable', $receivable);
// liability / Passif
$liability = new Account();
$liability->setName('Liability');
$liability->setParent($root);
$liability->setType($accountTypeCredit);
$manager->persist($liability);
$this->addReference('account_liability', $liability);
// liability : Accounts Payable
$payable = new Account();
$payable->setName('Accounts Payable');
$payable->setParent($liability);
$payable->setType($accountTypeCredit);
$manager->persist($payable);
$this->addReference('account_payable', $payable);
// Equity / Avoir
$equity = new Account();
$equity->setName('Equity');
$equity->setParent($root);
$equity->setType($accountTypeCredit);
$manager->persist($equity);
$this->addReference('account_equity', $equity);
// Revenue / Produits
$revenue = new Account();
$revenue->setName('Revenue');
$revenue->setParent($root);
$revenue->setType($accountTypeCredit);
$manager->persist($revenue);
$this->addReference('account_revenue', $revenue);
// Expense / Charges
$expense = new Account();
$expense->setName('Expense');
$expense->setParent($root);
$expense->setType($accountTypeDebit);
$manager->persist($expense);
$this->addReference('account_expense', $expense);
$manager->flush();
}
