PROJECT REPORT

ON

Catloga
The smart solution for
Catalogue creation and sharing

Developed By:
196340316053 Trivedi Khushali R. | 196340316004 Baraiya Adarsh P.

Guided By:
Mr. S.P. J adeja

Submitted To:
Information Technology Department
L E College (Polytechnic), Morbi.

Affiliated To :

Gujarat Technological University.

CERTIFICATE

i
 ACKNOWLEDGEMENT

We would like to express our sincere gratitude to our Head of Department (Prof.
N.A. Fatak) for giving his almost attention and guidance for our project, and
thankful to our guide(Mr. S P Jadeja) for their continuous help in our project.

We are also thankful to all the faculties of our department and our colleagues of
information technology department who helped us in the project and also
provided useful information.

-Trivedi Khushali R. (196340316053)

- Baraiya Adarsh P. (196340316004)

i
 INDEX

No. Title Page

1. Project Title. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

2. Project definition. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

3. Abstract. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

4. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

5. Software Process Model. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

6. Requirement analysis. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

7. Software requirement. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

8. Data dictionary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

9. DFD Diagrams. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

10. Use case Diagrams. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20

11. ER Diagram. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

12. Screenshots. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

13. Conclusion & future Enhancement. . . . . . . . . . . . . . . . . . . . . . . . . 28

 Project Title

Catloga
The smart solution for catalogue creation and sharing
(HTML, CSS, JavaScript, WordPress Php, MySQL)
 PROJECT DEFINITION

Project title: - Catloga

Project definition: - Smart solution for catalogue creation and sharing

Branch: - Diploma I.T.

Semester: - 6th
Member - Khushali Trivedi R, Baraiya Adarsh P.
Enrolment no: - 196340316053, 196340316004
Technology used: - HTML, CSS, JavaScript, WordPress, Php,MySQL
Guide: - S P Jadeja.
 ABSTRACT
“Catloga” is web portal for Ceramic Industry, This System offers a tool which
is completely easy to generate Catalogue and Client can easily share it with their
customers.

This Project consists of three modules: -

1. Admin: -

- Admin can Manage Client’s data, Add & Remove Catalogues, Manage Database.

2. Company: -
- User can edit Catalogue template, Preview Catalogue, share it as a link or PDF

3. User: -
- User Can Edit Master & Custom Catalogue, Download Catalogue, etc.
 INTRODUCTION

Our project definition based on Smart solution for Catalogue creation and sharing of ceramic
industry, there is a web interface.

In this system, there are three modules: -

1. Admin module.
2. Company module.
3. User module.

Admin has following functionality: -

 Login
 Manage Companies
 Maintenance of the website
 Add & Remove Master catalogues
 Manage Tile Designs
 Manage Category
 See Company activities
 Profile Management
 Logout




Company has following functionality: -

 Login
 Manage Custom catalogues
 Get user data
 See user activities
 Forgot password
 Profile Management
 Logout

Company has following functionality: -

 Edit catalogues
 Download Catalogues
SOFTWARE PROCESS MODEL

Prototype Model:
The basic idea in Prototype model is that instead of freezing the requirements
before a design or coding can proceed, a throwaway prototype is built to
understand the requirements.
This prototype is developed based on the currently known requirements.
Prototype model is a Software Process Model. By using this prototype, the client
can get an “actual feel” of the system, since the interactions with prototype can
enable the client to better understand the requirements of the desired system.

Prototyping is an attractive idea for complicated and large systems for which
there is no manual process or existing system to help determining the
requirements.

The prototype is usually not complete systems and many of the details are not
built in the prototype. The goal is to provide a system with overall functionality.
HARDWARE & SOFTWARE REQUIREMENT

 Our Web Works On Every Platform That Support Internet Browser ex. Android,
IOS, Windows, MacOs , Ubantu

 Web App Does not Need Much Hardware Requirement Because All Process
Goes on Our Server
DATA FLOW DIAGRAMS

 A data flow diagram (DFD) is a graphical representation of the "flow" of data through an
information system.

Symbols
Data flow diagram context(level-0)
Data flow diagram Admin(level-1)
Data flow diagram Company(level-1)
Data flow diagram User(level-1)
Use Case Diagram Admin
Use Case Diagram Company
Use Case Diagram User
 Data Dictionary
admin_login

Field Name Data Type Size Constraint Description

n_admin_login_id Int (Auto 11 Primary ID of Admin

Increment) Key
v_admin_name Varchar 20 Not Null Name of Admin

v_admin_username Varchar 70 Not Null Username of Admin

v_admin_password Varchar 50 Not Null Password of Admin

d_date_created date Not Null Creation date of

Admin

Data Dictionary
catalogue_design

Field Name Data Type Size Constraint Description

n_design_id Int (Auto 11 Primary ID of Design

Increment) Key
v_catalogue_design_name Varchar 20 Not Null Name of Design

v_catalogue_design_url longtext Not Null Design Url

v_company_name Varchar 50 Not Null Company Name

v_company_tile_size Varchar 30 Not Null Tile Size

v_tile_finish Varchar 30 Not Null Tile Finish

d_date_created date Not Null Creation date of

Design
 Data Dictionary
catalogue_info

Field Name Data Type Size Constraint Description

n_catalogue_id Int (Auto 11 Primary ID of Design
Increment) Key
n_company_id Int 11 Foreign ID of Company
Key
v_catalogue_name Varchar 50 Not Null Catalogue Name
v_background_image_url longtext Not Null Background Image
Url
v_background_com_image_url longtext Not Null Compressed
Background Image
Url
v_cover_image_url Varchar 255 Not Null Cover Image Url
v_company_name Varchar 30 Not Null Company Name
v_catalogue_tile_size Varchar 10 Not Null Tile Size
v_catalogue_tile_finish Varchar 10 Not Null Tile Finish
v_page_url Varchar 255 Not Null Webpage Url
f_catalogue_status Int 1 Not Null Catalogue Status
d_date_created date Not Null Creation date of
Catalogue
 Data Dictionary
Company

Field Name Data Type Size Constraint Description

n_company_id Int (Auto 11 Primary ID of Company

Increment) Key
v_logo_image_url Varchar 255 Not Null Company Logo

v_company_thumbnail longtext Not Null Company

Thumbnail
v_company_name Varchar 20 Not Null Company Name

v_company_email Varchar 50 Not Null Company Email

v_company_phone_number Varchar 10 Not Null Company Phone

Number
v_company_website_name Varchar 100 Not Null Company Website
Name
v_company_tile_size text Not Null Tile Size

v_tile_finish text Not Null Tile Finish

v_admin_web_url Varchar 255 Not Null Admin Panel Url

d_date_created date Not Null Creation date of

Company
 Data Dictionary
c_admin_data

Field Name Data Type Size Constraint Description

n_admin_id Int (Auto 11 Primary ID of Admin

Increment) Key
v_company_name Varchar 30 Not Null Name of Company

v_admin_username Varchar 70 Not Null Username of Company

Admin
v_admin_password Varchar 255 Not Null Password of Company
Admin
v_admin_web_url Varchar 255 Not Null Admin Panel Url

n_verification_code Int 11 Not Null OTP for Forgot

Password
d_date_created date Not Null Creation date of Admin
Data
 Data Dictionary
c_catalogue_info

Field Name Data Type Size Constraint Description

n_catalogue_id Int (Auto 11 Primary ID of Design

Increment) Key
n_company_id Int 11 Foreign ID of Company
Key
v_catalogue_name Varchar 50 Not Null Custom Catalogue
Name
v_background_image_url longtext Not Null Background Image
Url
v_background_com_image_url longtext Not Null Compressed
Background Image
Url
v_cover_image_url Varchar 255 Not Null Cover Image Url

v_company_name Varchar 30 Not Null Company Name

v_catalogue_tile_size Varchar 10 Not Null Tile Size

v_catalogue_tile_finish Varchar 10 Not Null Tile Finish

v_page_url Varchar 255 Not Null Webpage Url

f_catalogue_status Int 1 Not Null Catalogue Status

d_date_created date Not Null Creation date of

Custom Catalogue
 Data Dictionary
c_design_data

Field Name Data Type Size Constraint Description

n_image_id Int (Auto 11 Primary ID of Design

Increment) Key Image
v_company_name Varchar 50 Not Null Name of
Company
v_catalogue_design_name Varchar 20 Not Null Design Name

v_image_url longtext Not Null Design Url

v_image_name Varchar 100 Not Null Image Name

v_tile_size Varchar 30 Not Null Tile Size

v_tile_finish Varchar 30 Not Null Tile Finish

Data Dictionary
tile_size

Field Name Data Type Size Constraint Description

n_size_id Int (Auto Increment) 11 Primary ID of Tile Size

Key
v_tile_size Varchar 20 Not Null Tile Size

Data Dictionary
tile_finish

Field Name Data Type Size Constraint Description

n_finish_id Int (Auto Increment) 11 Primary Key ID of Tile Finish

v_tile_finish Varchar 20 Not Null Tile Finish

 Data Dictionary
user_uploaded_data

Field Name Data Type Size Constraint Description

n_user_id Int (Auto 11 Primary ID of Tile Finish

Increment) Key
v_original_company_name Varchar 20 Not Null Original
Company Name
v_catalogue_name Varchar 50 Not Null Catalogue Name

v_image_url Varchar 255 Not Null Logo Image Url

v_company_name Varchar 20 Not Null Company Name

v_user_uploaded_website Varchar 255 Not Null User Website

Name
v_user_uploaded_email Varchar 50 Not Null User Email

v_user_uploaded_phone_number Varchar 20 Not Null User Phone

Number
f_status Int 1 Not Null notification
status
d_date_created DateTime Not Null Current
timestamp for
user upload

ER Diagram

https://pasteboard.co/zH7Gx5gS0i6x.png
Admin > Login
Admin>Dashboard

Admin>Create Company

Admin>Add Design
Admin>Add Master Catalogue
Admin>Category

Admin>Profile
Admin>Total Master Catalogues

Company>Login
Company>Dashboard
Company>Create Custom Catalogues

Company>Create Custom Catalogues

Company>Analytics

Company>Account Profile
Company>Account Security

Catalogue Page
Test Case Admin Side
ID Functionality Steps Expected Result Actual Result Status
Name (Pass or
Fail)
1 Login 1.Go to Redirect Admin to the Redirect Admin to the PASS
“https://catloga.com/admin/” Dashboard Dashboard
URL.
2. Fill the login Details –
Username & Password and
submit

2 Manage 1. Click on “Profile” tab Register Account, Update Register Account, PASS
Accounts from sidebar. and Delete Account Update and Delete
2. To add Fill the form and Details. Account Details.
Submit button.
3. To Update/Delete click on
the button from table to
Manage Account.

3 Manage 1. Click on “Category” tab Add/Delete Category Add/Delete Category PASS

Category from sidebar.
2. Can Add/Delete Tile Size,
Tile Finish & Tile Series

4 Manage 1. Click on “Template” tab Add/Edit/Delete Templates Add/Edit/Delete PASS

Templates from sidebar. Templates
2. Can Add/Edit/Delete
Templates

5 Add Master 1. Click on “Add Catalogue” Creates a Master Catalogue Creates a Master PASS
Catalogues tab from sidebar. for a specific Company Catalogue for a specific
2.Fill the form and click on Company
“Add Catalogue” button.

6 Manage 1. Click on “Total View/Edit/Draft/Delete View/Edit/Draft/Delete PASS

Master Catalogues” tab from Master Catalogues Master Catalogues
Catalogues sidebar.
2. Can
View/Edit/Draft/Delete
Master Catalogues

7 Register 1. Click on “Add Company” Register a Company and Register a Company PASS
Company tab from sidebar. generates an Admin Panel and generates an
2. Fill the form and click on for that company Admin Panel for that
“Add Company” Button. company

8 Manage 1. Click on “Dashboard” tab View – Admin View – Admin PASS

Company from sidebar. Panel/Designs and Panel/Designs and
2. Can View – Admin Edit/Delete Company Edit/Delete Company
Panel/Designs and
Edit/Delete Company
Testcase Company Side
ID Functionality Steps Expected Result Actual Result Status
Name (Pass
or
Fail)
1 Login 1.Go to Redirect Company to the Redirect Company to the PASS
“https://catloga.com/company/” Dashboard Dashboard
URL.
2. Fill the login Details –
Username & Password and
submit

2 Manage 1. Go to “Account->Profile” Edit Company Details & Edit Company Details & PASS
Profile from navbar. Change LOGO Change LOGO
2. Can Edit Company
Information & LOGO.

3 Manage 1. Go to “Account->Security” Change Password for Change Password for PASS

Security from navbar. Admin Panel Admin Panel
2. Click on “Change” and fill
new Password to change
Password for Admin Panel.

4 Manage 1. Go to “Dashboard” from Share Catalogue Link to Share Catalogue Link to PASS
Master navbar. WhatsApp /Copy Link WhatsApp /Copy Link
Catalogues 2. Can Share Catalogue Link to and Draft/Publish and Draft/Publish
WhatsApp/Copy Link and Catalogue Catalogue
Draft/Publish Catalogue

5 Create 1. Click on “Create Catalogue” Creates Custom Creates Custom PASS

Custom button. Catalogue for specific Catalogue for specific
Catalogue 2. Select Designs and fill form Company Company
and submit button.

6 Manage 1. Go to “Custom Catalogues” Edit/Delete/Draft/Publish Edit/Delete/Draft/Publish PASS

Custom from navbar. Custom Catalogues Custom Catalogues
Catalogues 2. Can Edit/Delete/Draft/Publish
Custom Catalogues

7 Monthly 1. Go to “Analytics” from Generates .csv file of Generates .csv file of PASS
Report of navbar. Monthly report Monthly report
Analytics 2. Click on “Get Monthly
Report”.
3. Click on “Download” Button.
Testcase User Side
ID Functionality Steps Expected Result Actual Result Status
Name (Pass
or
Fail)
1 Download 1. Click on “Download Generates Default Generates Default PASS
Catalogue Catalogue”. Catalogue in PDF format Catalogue in PDF format
2 Edit 1. Click on “Edit Catalogue”. Generates Catalogue with Generates Catalogue with PASS
Catalogue 2. Fill the form details and click filled Information and filled Information and
on “Generate Catalogue”. LOGO LOGO
CONCLUSION & FUTURE ENHANCEMENT

Conclusion :-

 The Proposed System Plays an Important Role in Share Catalogue Without Taking
Space On Device.

Future Enhancement: -

 We Are Thinking To Create Whole Ecosystem Related Catalogue Design, Create Link.