LOKATANI ID
Assignment Web Development Internship
Assigment Start Date: 30 March 2024
Assigment Deadline: 3 April 2024
Assignment
1. Create pages on website with basic CRUD features (detailed on “Study Case”
bellow).
2. Please create website using one of preferred framework (Laravel or Codeigniter)
3. For database, you may use one of these MySQL or PostgreSQL
4. You may not using CRUD package (e.g. Backpack, Laravel Jetstream, etc)
5. You may use any javascript/css framework (such as Bootstrap, Tailwind, Datatables,
JQuery, etc)
Study Case
1. Create database and a table with this scheme.
ID smallint Primary Key,
Autoincrement
name varchar Not Null
email varchar Not Null, Unique
phone varchar Nullable
address text Nullable
created_at datetime Not Null
updated_at datetime Nullable
deleted_at datetime Nullable
2. Create “list” page of data from database above. List including table list, pagination,
search (sorting and order is optional but it will be plus point if you add it).
3. Create “form create” page for storing new data to database above. Form will
contains input field:
a. name (text input), validation: required, alphabet only
b. email (email input), validation: required, unique, alpha-numeric, email format
c. phone (text input), validation: alpha-numeric
d. address (multi-line input), validation: alpha-numeric
for created_at and updated_at will be added automatically when data is stored
based on current datetime.
4. Create “form edit” page for updating existing data from and to database above.
Form will contains input field:
a. name (text input), validation: required, alphabet only
b. phone (text input), validation: alpha-numeric
c. address (multi-line input), validation: alpha-numeric
for updated_at will be updated automatically when data is stored based on current
datetime.
5. Create “detail” page for updating existing data from and to database above. Page
will contains these data: ID, name, email, phone, address, created_at (with format
d F Y H:i:s), updated_at (with format d F Y H:i:s)
6. Create “delete” feature for deleting existing data from and to database above.
Please using soft delete when deleting data. Delete action can be triggered from
list page or detail page. When clicked, there will be popup confirmation for deleting
data. When deleting just update deleted_at on database.
How to submit assignment.
1. Please commit your task to your GIT repository. Please make it public so we can
clone your code to our local device.
2. Add instruction of how we setup your website on our local device. Step by step how
to install packages and requirement (such as database type you use etc). Write it
and documented it on [Link]
3. Dont forget to add your migration file (using migration on framework or sql dump as
file on your repository), make sure you are including of how we migrate data on step
2.
4. Please email us to hi@[Link] with subject “Assigment Web - [YOUR NAME]”,
include your GIT repository URL on body email.
