Re: 請提供DebConf住宿資料 (Please provide start date / end date of every dorm room)

2018-08-13 Thread Stefano Rivera 
Hi ChangZhuo (2018.08.14_03:55:36_+0200)
> * NCTU accounting office needs the start date / end date of every
>   dormitory rooms to write off NCTU budget for dormitory.

I sent you the result of this query:

SELECT room,
  min(date) as first_arrival,
  DATE(max(date) + INTERVAL '1 day') AS last_departure
FROM register_accomm
LEFT JOIN register_accomm_nights
  ON register_accomm.id = register_accomm_nights.accomm_id
LEFT JOIN register_accommnight
  ON register_accomm_nights.accommnight_id = register_accommnight.id
LEFT JOIN front_desk_checkin
  ON register_accomm.attendee_id = front_desk_checkin.attendee_id
WHERE room != ''
  AND front_desk_checkin.id IS NOT NULL
GROUP BY room
ORDER BY room;

SR

-- 
Stefano Rivera
  http://tumbleweed.org.za/
  +1 415 683 3272

Bootstrapping DC19 accounting

2018-08-13 Thread Louis-Philippe Véronneau 
Hi!

I've done a bunch of work to bootstrap the DC19 accounting. I tried to
bring it back closer to what was done for dc15-dc17 but incorporate good
ideas from dc18.

I am not a ledger-cli wizard nor a professional accountant, so if you
have time and opinions on how the DebConf accounting should be done,
please have a look:

https://salsa.debian.org/debconf-team/public/data/dc19/tree/master/budget

-- 
  ,''`.
 : :'  : Louis-Philippe Véronneau
 `. `'`  po...@debian.org / veronneau.org
   `-



signature.asc
Description: OpenPGP digital signature

Re: 請提供DebConf住宿資料 (Please provide start date / end date of every dorm room)

2018-08-13 Thread 陳昌倬 
On Mon, Aug 13, 2018 at 04:16:40PM +0800, 鄧雅芸  wrote:
> 昌倬您好：
> 
>  
> 
> 在核銷宿舍費時，主計室要求補上每間房號的住宿日期，
> 
> 因您之前提供的僅有名單(如附件)，再麻煩您補上每間房住宿的期間，謝謝。

Hi team,

* NCTU accounting office needs the start date / end date of every
  dormitory rooms to write off NCTU budget for dormitory.


-- 
ChangZhuo Chen (陳昌倬) czchen@{czchen,debconf,debian}.org
http://czchen.info/
Key fingerprint = BA04 346D C2E1 FE63 C790  8793 CC65 B0CD EC27 5D5B


signature.asc
Description: PGP signature