public function getTransactions(PaginationParameters $paginationParameters)
{
$queryBuilder = $this->createQueryBuilder('BankTransaction');
$queryBuilder->where('BankTransaction.user = :user')->setParameter('user', $paginationParameters->getFilter('user'));
$queryBuilder->andWhere('BankTransaction.type = :type')->setParameter('type', $paginationParameters->getFilter('type'));
$queryBuilder->addOrderBy('BankTransaction.paymentDate', 'DESC');
$paginationParameters->setFilters(array());
return $this->getPaginatedResult($queryBuilder, $paginationParameters);
}
public function getBankAutocompleteInvoices(PaginationParameters $paginationParameters)
{
$queryBuilder = $this->createQueryBuilder('Invoice');
$queryBuilder->where('Invoice.status = :status')->setParameter('status', Document\Invoice::STATUS_CONFIRMED);
$queryBuilder->andWhere('Invoice.paymentStatus = :paymentStatus')->setParameter('paymentStatus', Document\Invoice::PAYMENT_STATUS_UNPAID);
if ($paginationParameters->getFilter('autocomplete') != null) {
$queryBuilder->andWhere('Invoice.documentNumber LIKE :autocomplete OR Invoice.prefix LIKE :autocomplete OR Invoice.referenceNumber LIKE :autocomplete')->setParameter('autocomplete', '%' . $paginationParameters->getFilter('autocomplete') . '%');
}
$paginationParameters->setFilters(array());
return $this->getPaginatedResult($queryBuilder, $paginationParameters);
}
public function getCompanies(PaginationParameters $paginationParameters)
{
$queryBuilder = $this->createQueryBuilder('Company');
if ($paginationParameters->getFilter('name') != null) {
$queryBuilder->where('Company.name LIKE :name')->setParameter('name', '%' . $paginationParameters->getFilter('name') . '%');
}
if ($paginationParameters->getFilter('regNo') != null) {
$queryBuilder->where('Company.regNo LIKE :regNo')->setParameter('regNo', '%' . $paginationParameters->getFilter('regNo') . '%');
}
if ($paginationParameters->getFilter('taxNo') != null) {
$queryBuilder->where('Company.kmkrNo LIKE :taxNo')->setParameter('taxNo', '%' . $paginationParameters->getFilter('taxNo') . '%');
}
$paginationParameters->setFilters(array());
return $this->getPaginatedResult($queryBuilder, $paginationParameters);
}
public function getSuppliers(User $user, PaginationParameters $paginationParameters = null)
{
$queryBuilder = $this->createQueryBuilder('Supplier');
$queryBuilder->where('Supplier.user = :user')->setParameter('user', $user);
if (!$paginationParameters) {
return $queryBuilder->getQuery()->getResult();
}
if ($paginationParameters->getFilter('name') != null) {
$queryBuilder->andWhere('Supplier.name LIKE :name')->setParameter('name', '%' . $paginationParameters->getFilter('name') . '%');
}
if ($paginationParameters->getFilter('regNo') != null) {
$queryBuilder->andWhere('Supplier.regNo LIKE :regNo')->setParameter('regNo', '%' . $paginationParameters->getFilter('regNo') . '%');
}
if ($paginationParameters->getFilter('taxNo') != null) {
$queryBuilder->andWhere('Supplier.kmkrNo LIKE :taxNo')->setParameter('taxNo', '%' . $paginationParameters->getFilter('taxNo') . '%');
}
$paginationParameters->setFilters(array());
return $this->getPaginatedResult($queryBuilder, $paginationParameters);
}
public function getPurchaseInvoices(User $user, PaginationParameters $paginationParameters = null)
{
$queryBuilder = $this->createQueryBuilder('PurchaseInvoice');
$queryBuilder->where('PurchaseInvoice.user = :user')->setParameter('user', $user);
$queryBuilder->leftJoin('PurchaseInvoice.supplier', 'Supplier');
if ($paginationParameters->getFilter('status') != null) {
$queryBuilder->andWhere('PurchaseInvoice.status = :status')->setParameter('status', $paginationParameters->getFilter('status'));
}
if ($paginationParameters->getFilter('date') != null) {
$queryBuilder->andWhere('PurchaseInvoice.documentDate = :date')->setParameter('date', $paginationParameters->getFilter('date'));
}
if ($paginationParameters->getFilter('fromDate') != null) {
$queryBuilder->andWhere('PurchaseInvoice.documentDate >= :fromDate')->setParameter('fromDate', $paginationParameters->getFilter('fromDate'));
}
if ($paginationParameters->getFilter('toDate') != null) {
$queryBuilder->andWhere('PurchaseInvoice.documentDate <= :toDate')->setParameter('toDate', $paginationParameters->getFilter('toDate'));
}
if ($paginationParameters->getFilter('confirmed') != null) {
$queryBuilder->andWhere('PurchaseInvoice.confirmed = :confirmed')->setParameter('confirmed', $paginationParameters->getFilter('confirmed'));
}
if ($paginationParameters->getFilter('unpaid') != null && $paginationParameters->getFilter('unpaid') == true) {
$queryBuilder->andWhere('PurchaseInvoice.paymentStatus != :statusPaid')->setParameter('statusPaid', Document::PAYMENT_STATUS_PAID);
}
if ($paginationParameters->getFilter('supplier') != null) {
$queryBuilder->andWhere('Supplier.name LIKE :supplier')->setParameter('supplier', '%' . $paginationParameters->getFilter('supplier') . '%');
}
if ($paginationParameters->getFilter('purchaseInvoiceText') != null) {
$queryBuilder->andWhere('PurchaseInvoice.supplierDocumentNumber LIKE :purchaseInvoiceText OR Supplier.name LIKE :purchaseInvoiceText')->setParameter('purchaseInvoiceText', '%' . $paginationParameters->getFilter('purchaseInvoiceText') . '%');
}
if ($paginationParameters->getFilter('amount') != null) {
$queryBuilder->andWhere('PurchaseInvoice.amount = :amount')->setParameter('amount', $paginationParameters->getFilter('amount'));
}
if ($paginationParameters->getFilter('paymentStatus') != null) {
$queryBuilder->andWhere('PurchaseInvoice.paymentStatus = :paymentStatus')->setParameter('paymentStatus', $paginationParameters->getFilter('paymentStatus'));
}
$paginationParameters->setFilters(array());
return $this->getPaginatedResult($queryBuilder, $paginationParameters);
}
