Mydel-Ar Asturiano

About Spare Parts Inventory System

• Simple system developed using C#.
• Used by Equipment Team to manage inventory for spare parts and tools. Main functions includes as following :

1. Stock Management: Register new tools, top-up and withdraw stock quantity.
2. Storage location management: To keep track of the parts location.
3. Reporting: Report of each Part stock quantity details.
4. Audit trail: To record down who/when performed top up/ withdrawal.
5. Auto Email Alert for low quantity inventory Parts

Developed using the following:

• C# MVC Framework
• Oracle database
• HTML
• CSS
• Twitter Bootstrap
• Javascript
• Jquery
• Ajax

System Manual

Login:

• Input User ID, Password and select registered site. Then click login to continue.

After login, user will be seeing the below home page. Also user will be able to see which site they login under every page.

Transaction Menu: Top-up/Withdraw Stock

• User can perform transactions such as top up and withdrawal of stock under this menu.
• Once user click the “Top-up/Withdraw Stock” menu, they will be able to see the current stock details of all the parts under the site they logged in. They have an option to sort based on any of the column headers in the table. Just click on the desired table header to sort by ascending / descending order. Also users are able to search from the stock details table using any wildcard value.

• Search using any Part Name

• Top-up stock

This submenu is using for topping up current stock quantity.

User can select any part by clicking on the table row and click Top-up Stock button.

• Withdraw stock

Select any part and click withdraw Stock button

Reports Menu:

• Stock Transaction

User will be able to see audit trail for all the stock transactions under this menu.

• Stock Report

User will be able to download the current stock quantity.

• Part Summary Report

User will be able to download the summarize quantity per part.

Description: PG UST Redemption is a system to tag the coupon number in the system as used. This system is created to monitor the coupon.

Developed using the following:

• PHP
• MsSql
• Oracle 11G Database
• HTML
• CSS
• Javascript
• JQuery
• Ajax

Description: Download the text files of Perks Points and Aling Puring Points from FTP server per branch folder. Check the branch without updates. Branch with updates load to CRM outsourced program

Developed using the following:

• PHP
• MsSql
• HTML
• CSS
• Javascript
• JQuery
• Ajax

Description: Create csv text files for ARC-BI outsourced program. Also create text files for Puregold Website for the Perks Points and Aling Puring Points online inquiry.

Developed using the following:

• PHP
• MsSql
• HTML
• CSS
• Javascript
• JQuery
• Ajax