biInterface/test.py at master · buildervortex/biInterface · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
from database.db import Database
from repository.biDashboardRepository import BiDashboardRepository
from repository.featureRepository import FeatureRepository

db: Database = Database()
db.connect()

repository = BiDashboardRepository(db=db)
functionRepo = FeatureRepository(db)

print(repository.getLoanFinishedUnfinishedCount("2024-04-05"))

print(repository.getGasIncomes())
# print(repository.getLoanFinishedUnfinishedCount("2024-04-05"))
# print(repository.getGasIncome())

# print(repository.getEmptySellingIncomeProfit())

# print(repository.getEachManagerTransactionCount())

print(repository.getVehicleTransactionCounts())

print(repository.getUnFinishedLoanBalanceCountAll())

print(repository.getRegAndUnregCustomerCounts())

print(repository.getCylinderCountFromUserToGiveUs())

print(repository.getSystemUsersHandledTransactionCount())

print(repository.getCylinderTypeBySellCount())
# print(repository.getSellingIncomeProfit())

# functionRepo.registerDeliveringCustomer(
#     "lahiru", "dilhara", "199034567496V", "447859", None)

print(repository.getActiveLoanAcount())