Overview

Document Control System

• PHP Version : 7.2 or should less than 7.3
• Codeigniter Version: 3.1.9
• Cloud : Azure Storage
• Azure Storage Explorer : Install

Dashboard

Description: Showing all product categories
Tb: categorycomponent

Header

Description:

1. Navigation menu
2. Add new project
3. Dashboard
4. Edit project *
5. Copy project*
6. Delete project*
7. Share project*

note:

1. * active on project detail page.
2. Copy project will create new project based on current project (will be redirected to Create New Page).
3. Share function never works from beginning.

Menu

note: * some features still have issues after migrating to azure storage

1. List of users Tb: usertable_doc
2. List of temporary users Tb: tempuser
3. List of project code/type Tb: productprefix
4. List of project categories Tb: categorycomponent
5. List of project attachments Tb: component-productprefix-usertable_doc-datasheet
6. Attachment download log Tb: downloadlog
7. List of project with status Tb: component-productprefix-usertable_doc
8. List of reference Tb: reference_type

Home

Description: Showing data based on the category that we choose from the dashboard

Query: component - productprefix - usertable_doc - referencerelation - reference_type - categoryrelation

Create-Update Project

Description:

1. We can turn off the validation for filename format on this page so that the filename can be anything but remember this validation format can prevent the user from uploading the same filename on different.
2. Before doing an upload the file will be checked whether:
a. the filename format was correct
b. the file is exist or not in our storage (if the file is exist file can be replaced or not)
c. and it will be stored on our database after upload to storage is success
3. File with Private will be stored in the Private Container and public files will be stored in the public container
4. File with privilege can be seen only by the user with that selected privilege
5. On edit mode changing private-public will move file from source to target container

Project Detail

note: * need to refactor the function that shows the relations
Description:

1. Showing the latest version for each project that comes on this tree
2. ASC shows as long as if there are child project
3. DESC shows as long as the current project is part of another child

Azure Php SDK

1. Microsoft Azure Storage Explorer Download
2. PHP Azure SDK Documentation
3. Blob samples and how to use it
4. Curl Request (PUT Blob) with Shared Access Key
5. Authorize request to Azure Storage