mayswind / ezbookkeeping Goto Github PK
View Code? Open in Web Editor NEWA lightweight personal bookkeeping app hosted by yourself.
Home Page: http://ezbookkeeping.mayswind.net
License: MIT License
A lightweight personal bookkeeping app hosted by yourself.
Home Page: http://ezbookkeeping.mayswind.net
License: MIT License
support input in currency conversion, so that we can quickly see the calculated value
docker部署之后,数据库文件在哪里,如果我更新镜像并重启容器,数据是否会丢失?
thanks for creating this, i think it should be listed on awesome self hosted list
非常nice的自托管记账系统!希望能支持类似房租、宽带费、物业费之类的周期账单支持,在设置的周期之间自动追加交易条目。
In case I'm using postgres database, when I open the statistics
tab it shows up blank. But if I use sqlite statistics tab works fine.
postgres | 2023-04-22 07:23:28.562 UTC [33] ERROR: column "transaction.uid" must appear in the GROUP BY clause or be used in an aggregate function at character 8
postgres | 2023-04-22 07:23:28.562 UTC [33] STATEMENT: SELECT uid, category_id, account_id, SUM(amount) as amount FROM "transaction" WHERE (uid=$1 AND deleted=$2 AND (type=$3 OR type=$4) AND transaction_time>=$5 AND transaction_time<=$6) GROUP BY category_id, account_id
ezbookkeeping | 2023-04-22 13:23:28 [REQUEST] 200 0 3612385602822995968 192.168.0.199 GET /api/v1/transactions/statistics.json?start_time=1680285600&end_time=1682877599 11ms, r=ed7d581c-5e28-5d1b-0000-0034c0a800c7
Ezbookkeeping docker image: mayswind/ezbookkeeping:SNAPSHOT-20230421
Postgres image: postgres:14.1-alpine
version: "2"
services:
ezbookkeeping:
image: mayswind/ezbookkeeping:SNAPSHOT-20230421
container_name: ezbookkeeping
hostname: "ezbookkeeping"
ports:
- "80:8080"
networks:
- db
depends_on:
- "db"
environment:
- "EBK_SERVER_DOMAIN=ezbookkeeping.local"
- "EBK_SERVER_ENABLE_GZIP=true"
- "EBK_DATABASE_TYPE=postgres"
- "EBK_DATABASE_HOST=db:5432"
- "EBK_DATABASE_NAME=ezbookkeeping"
- "EBK_DATABASE_USER=ezbookkeeping"
- "EBK_DATABASE_PASSWD=ezbookkeeping"
- "EBK_LOG_MODE=console file"
- "EBK_SECURITY_SECRET_KEY=my_security_code"
volumes:
- "/etc/localtime:/etc/localtime:ro"
- "/var/log/ezbookkeeping:/var/log/ezbookkeeping"
db:
image: postgres:14.1-alpine
container_name: postgres
restart: always
environment:
- POSTGRES_USER=ezbookkeeping
- POSTGRES_PASSWORD=ezbookkeeping
ports:
- '5432:5432'
networks:
- db
volumes:
- db:/var/lib/postgresql/data
networks:
db:
volumes:
db:
driver: local
检测到 mayswind/ezbookkeeping 一共引入了73个开源组件,存在8个漏洞
漏洞标题:jwt-go 安全漏洞
漏洞编号:CVE-2020-26160
漏洞描述:jwt-go是个人开发者的一个Go语言的JWT实现。
jwt-go 4.0.0-preview1之前版本存在安全漏洞。攻击者可利用该漏洞在使用[]string{} for m[\"aud\"](规范允许)的情况下绕过预期的访问限制。
影响范围:(∞, 4.0.0-preview1)
最小修复版本:4.0.0-preview1
缺陷组件引入路径:github.com/mayswind/ezbookkeeping@->github.com/dgrijalva/[email protected]+incompatible
另外还有8个漏洞,详细报告:https://mofeisec.com/jr?p=n2b792
Feature request: Data import tool for when migrating from other simple systems.
Import:
Accounts
Categories
Tags
Transactions
edit: specified my request.
在使用过程中,我有时会给不同类别的支出打上相同的签,比如:
类别 | 物品 | 标签 |
---|---|---|
电器 | 冰箱 | 厨房 |
餐具 | 碗 | 厨房 |
食材 | 牛肉 | 厨房 |
我想统计一下某年,或某个季度,我为厨房
购买了哪些物品,总共支出了多少。
我看ini文件里有个certfile 和cert-keyfile,需要只需要配置这个路径就行了吗
比如我映射的宿主机目录是/ezbookkeeping/conf,我把证书文件放这个目录下,那么ini里面的对应路径是否是这样?
/ezbookkeeping/conf/cert.crt
/ezbookkeeping/conf/cert-key.key
谢谢。
Hi! I'm pretty much satisfied with this project, and I'm using it on a daily basis without any issue so far. However, it would be cool if I was able to change some basic CSS, like the color used to show positive and negative values.
For example, I'm accustomed to use green for incomes, while I keep the red for anything that's a spending. Right now it's the other way around, and I didn't find any way to change it except re-compile the entire program after editing the assets.
Seems like not able to edit or delete transactions
docker-compose.yml
version: "2"
services:
ezbookkeeping:
image: mayswind/ezbookkeeping
container_name: ezbookkeeping
hostname: "ezbookkeeping"
ports:
- "5701:8080"
environment:
- "EBK_SERVER_DOMAIN=mydomain"
- "EBK_SERVER_ENABLE_GZIP=true"
- "EBK_DATABASE_TYPE=mysql"
- "EBK_DATABASE_HOST=localhost:3306"
- "EBK_DATABASE_NAME=ezbookkeeping"
- "EBK_DATABASE_USER=ezbookkeeping"
- "EBK_DATABASE_PASSWD=password"
- "EBK_LOG_MODE=file"
- "EBK_SECURITY_SECRET_KEY=xxxxxxxxx"
volumes:
- "/etc/localtime:/etc/localtime:ro"
- "/var/log/ezbookkeeping:/var/log/ezbookkeeping" # 请确保 UID:GID 是 1000:1000
The error log:
2022-10-13 14:37:32 [ERROR] [server.startWebServer] update database table structure failed, because dial tcp 127.0.0.1:3306: connect: connection refused
2022/10/13 14:37:32 Failed to run ezBookkeeping with [/ezbookkeeping/ezbookkeeping server run]: dial tcp 127.0.0.1:3306: connect: connection refused
Trying to run docker image on Raspberry Pi 2 Model B (which has 32-bit CPU). It fails on registration attempt with following stack trace:
ezbookkeeping | 2023-04-20 14:10:49 [ERROR] System Error! because unaligned 64-bit atomic operation, r=b2e63496-63b4-89fe-0000-0004c0a800c7
ezbookkeeping | runtime/internal/atomic/unaligned.go:8 (0x1151b)
ezbookkeeping | runtime/internal/atomic/atomic_arm.s:258 (0x118a7)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/uuid/internal_generator.go:74 (0x6d86d7)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/uuid/internal_generator.go:53 (0x6d8583)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/uuid/uuid_container.go:32 (0x70b68f)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/services/base.go:46 (0x70b674)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/services/users.go:137 (0x70b668)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/api/users.go:65 (0x739e0b)
ezbookkeeping | github.com/mayswind/ezbookkeeping/cmd/webserver.go:265 (0x7469fb)
ezbookkeeping | github.com/gin-gonic/[email protected]/context.go:174 (0x73e383)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/middlewares/request_log.go:16 (0x73e360)
ezbookkeeping | github.com/mayswind/ezbookkeeping/cmd/webserver.go:258 (0x74690b)
ezbookkeeping | github.com/gin-gonic/[email protected]/context.go:174 (0x73e247)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/middlewares/request_id.go:26 (0x73e21c)
ezbookkeeping | github.com/mayswind/ezbookkeeping/cmd/webserver.go:258 (0x74690b)
ezbookkeeping | github.com/gin-gonic/[email protected]/context.go:174 (0x7117c3)
ezbookkeeping | github.com/gin-contrib/[email protected]/handler.go:60 (0x71179c)
ezbookkeeping | github.com/gin-gonic/[email protected]/context.go:174 (0x73d8b7)
ezbookkeeping | github.com/mayswind/ezbookkeeping/pkg/middlewares/recovery.go:33 (0x73d890)
ezbookkeeping | github.com/mayswind/ezbookkeeping/cmd/webserver.go:258 (0x74690b)
ezbookkeeping | github.com/gin-gonic/[email protected]/context.go:174 (0x6ae8af)
ezbookkeeping | github.com/gin-gonic/[email protected]/gin.go:620 (0x6ae5bc)
ezbookkeeping | github.com/gin-gonic/[email protected]/gin.go:576 (0x6ae17f)
ezbookkeeping | net/http/server.go:2936 (0x4a36f7)
ezbookkeeping | net/http/server.go:1995 (0x49ee7f)
ezbookkeeping | runtime/asm_arm.s:831 (0x80c37)
2023-09-18 01:04:43 [INFO] [server.startWebServer] static root path is /ezbookkeeping/public
2023/09/18 01:04:43 Failed to run ezBookkeeping with [/ezbookkeeping/ezbookkeeping server run]: Cannot add a NOT NULL column with default value NULL
2023-09-18 01:04:43 [ERROR] [server.startWebServer] update database table structure failed, because Cannot add a NOT NULL column with default value NULL
2023-09-18 01:05:10 [INFO] [initializer.initializeSystem] will load configuration from default config path /ezbookkeeping/conf/ezbookkeeping.ini
Since it supports multiple currencies, but not able to select currency when adding transactions
在交易列表中,按日期
过滤,如果选择最近7天
或最近30天
,那么当天记录不会显示。请问这个是设计如此还是bug导致?
Thank you bringing up an excellent, easy to use and beautiful sofeware. Appreicate that the dockerized app makes life much easier. Playing it in a few hours, I would suggest below in my wish-list:
I notice the routes are start from /mobile
, how to enable desktop view?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.