林瑞怡 Jui-Yi, Lin

大型機具檢查管制系統 (Company Project)

A system to manage machine entering status in construction plant including web interface and app interface. Website with two interface for 2 kinds of users(總公司人員、工務所人員) to login.

• JSON Web Token(JWT) authentication
• Nginx for reverse proxy
• Python uwsgi web server
• Python Django REST framework for backend
• Store all data in PostgreSQL

Feature

• Account, machine, machine enter application, and machine device check  management

• Different permissions user

• Support advancedsearch data by fields

• Data can be exported to Excel file

          (admin interface)

          (user interface)

出入管制系統 (Company Project)

A system including a web interface and an app interface for the construction industry to know workers' punch in information such as what time and which jobsite they came in or out. Web interface will change by different user(administrator & user). Workers use Face recognition or QR code scanner on app to punch in. 

• Websocket(Python channels, Daphne, Redis) for backend to pass punch in data from app to the web immediately
• JSON Web Token(JWT) authentication
• Nginx for reverse proxy
• Python uwsgi web server
• Python Socket and Python thread to communicate with Face recognition program(C language)
• Use Python Pandas and django_excel to export and pass excel data to web
• Python Django REST framework for backend
• Run application on Google Cloud Platform 
• Store all data in PostgreSQL
• RESTful API design pattern

  https://www.inforecord.me/(closed)
  https://github.com/juiyilin/order-form

消費者資訊紀錄系統 (Side Project)

A website for exhibitors to record visitors' information such as items what they are interested in or what they buy during the exhibition. Data can be presented by Google Charts and exported as an excel file.

• Upload company logo to AWS S3 
• Securely deliver logo by AWS CloudFront  
• SSL certificate for HTTPS
• Nginx for reverse proxy
• Draw charts using Google Charts 
• Use Python Pandas to export data to excel file
• Python Flask framework for back-end
• Run application on AWS EC2 
• Store all data in MySQL
• Use connection pool to manage connection
• RESTful API design pattern
• Use AJAX to call API
• HTML, CSS for RWD

  http://35.72.79.89:3000/ (closed)
  https://github.com/juiyilin/taipei-day-trip-website

台北一日遊 (Side Project)

An E-commerce for one day trip in Taipei.

• Python Flask framework for back-end
• Run application on AWS EC2 
• Store user data and attractions in MySQL
• Use connection pool to manage connection
• TapPay SDK for payment flow
• RESTful API design pattern
• Use AJAX to call API
• HTML, CSS for RWD
• Slide effect attraction image
• Infinite scroll for loading attraction data in index
• Popup login window