System Requirements

1. phpMyAdmin version: 5.2.2
2. PHP version: 7.2
3. MySQL version: 5.7.26
4. PHPRunner version: 10.4
5. Hard Disk Space: 20 MB

 

Database Structure

TABLE	COLUMN
purchase_requisition
uggroups
ugmembers
ugrights
users

---

 

Live URL

https://prs.sweetco.com.my

---

 

v. 1.0 2026-04-22 Modification Completed

Replace “Rich Text Box” for “Item Description” field with “Text Box with multiple rows”

BEFORE	AFTER

---

 

Rename “vendor” column to “vendor_details” and replace “Rich Text Box” for “Vendor Details” field with “Text Box with multiple rows”

BEFORE	AFTER

---

 

Rename columns and labels

• rename “vendor_url” column to “vendor_link”
• rename “Vendor Link” label to “Vendo’s Link”
• rename “Vendor Email” label to “Vendor’s Email”
• rename “Item Purpose” label to “Item is Used For”

BEFORE	AFTER
	vendor_url vendor_email item_purpose

---

 

Add “Show/hide fields”

BEFORE	AFTER

---

 

Add users to Purchase Requisition System

BEFORE	AFTER

---

 

v. 1.0 2025-02-19 Modification Completed

Move “Supplier” field after “Unit Price” in edit page

BEFORE	AFTER

---

 

Modify the columns of “purchase_requisition” table

BEFORE

AFTER

Table Structure purchase_requisition_id – int issued_date – date company_name – varchar (100) requested_by – varchar (50) item_description – longtext item_photo – mediumtext quantity_requested – int quantity_in_stock – int unit_price – double(9,2) supplier – longtext item_purpose – varchar (255) expected_arrival_date – date delivery_order_photo – mediumtext received_item_photo – mediumtext received_item_date – date issued_by – varchar(255) approved_by – varchar(255)

Table Structure purchase_requisition_id – int issued_date – date company_name – varchar (100) requested_by – varchar (50) item_description – longtext item_photo – mediumtext quantity_requested – int unit_price – double(9,2) quantity_in_stock – int vendor – longtext vendor_email – varchar(255) vendor_url – varchar(255) item_purpose – varchar (255) expected_arrival_date – date received_item_date – date received_item_photo – mediumtext delivery_order_photo – mediumtext issued_by – varchar(255) approved_by – varchar(255) vendor_email vendor_url

---

 

Rearrange the sequence of grid as per the sequence of columns in “purchase_requisition” table

BEFORE	AFTER

---

 

Rearrange the sequence of labels and text box in edit view as per the sequence of columns in “purchase_requisition” table

BEFORE	AFTER

---

 

Rearrange the sequence of rows in the form to follow the sequence of columns in “purchase_requisition” table

BEFORE	AFTER

---

 

v. 1.0 2025-01-15 Modification Completed

Revise the form

• remove the “Supplier” at top right of table and move it to the table by adding a row after “Unit Price”.
• rename the label as “Name and Contact Details of Supplier”, set the format of text (data entry) box to “Basic Rich Text Editor” so that user can enter name, address, contact number, link in allow multiple lines.

BEFORE	AFTER

---

 

v. 1.0 2025-01-02 Kaizen Completed

Create “sweetcoc_prs” database and assign “sweetcoc_phpMyBackupPro2024” and “sweetcoc_phprunner” users to the database

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to cPanel -> “Databases” -> “Manage My Databases”.
   
2. Under “Create New Database”, create “sweetcoc_prs”.
   
3. Under “Add User To Database”, add “sweetcoc_phpMyBackupPro2024” and “sweetcoc_phprunner” to “sweetcoc_prs” database.
   

---

 

Create “purchase_requisition” table in “sweetcoc_prs” database

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to cPanel -> “Databases” -> “phpMyAdmin.
   
2. Create “purchase_requisition” table.
   
3. Add below columns:-
   

   Name	Type
   purchase_requisition_id	int(11)
   company_name	varchar(100)
   requested_by	varchar(50)
   item_description	longtext
   item_photo	mediumtext
   quantity_requested	int(11)
   quantity_in_stock	int(11)
   unit_price	double(9,2)
   supplier_name	varchar(255)
   item_purpose	varchar(255)
   expected_arrival_date	date
   delivery_order_photo	mediumtext
   received_item_photo	mediumtext
   received_item_date	date
   issued_by	varchar(255)
   approved_by	varchar(255)

---

 

Create “prs.sweetco.com.my” domain

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to cPanel -> “Domains” -> “Domains”.
   
2. Add “prs.sweetco.com.my”.
   

---

 

Set PHP version of “Purchase Requisition System” to “PHP 7.2”

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to cPanel -> “Software” -> “MultiPHP Manager”.
   
2. Check “prs.sweetco.com.my” and change the PHP Version to “PHP 7.2 (ea-php72)”.
   

---

 

Create “Purchase Requisition System” project in PRPRunner

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to PHPRunner and create a new project PRS.
2. Set the database for PRS.
   

---

 

Re-arrange the “view” page of PRS

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to “Designer” tab and click “view” tab.
   
2. Re-arrange all fields like below:
   
   

---

 

Add “Send Email” function

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to “Misc” tab and click “Email Settings…”
   
2. Set as below:
   
3. Go to “Designer” tab, click on “list” page, click on “Insert…” dropdown and click “Custom Button”.
   
4. Click “New Button…”
   
5. Name the new button as “Send_Email”. In “Client Before tab, place below code:

   var pdfParams = {},
     selectedRecords = pageObj.getSelectedRecords();
    
   if( selectedRecords.length == 0 )
     return false;
    
   params.recordCount = selectedRecords.length;
   params.filenames = [];
    
   var createOnePdf = function( idx ) {
     ajax.addPDF( 'pdf'+idx, pdfParams[idx], function() {
       delete pdfParams[idx];
       if( Object.keys( pdfParams ).length == 0 ) {
           showDialog();
        }
     });
   }
    
   var showDialog = function() {
    ctrl.dialog( {
     title: 'Email ' + params.recordCount + ' PDF files',
     fields: [
        {
           name: 'Email',
           value: 'factory@sweetco.com.my'
        },
        {
           name: 'Subject',
           value: 'Purchase Requisition No.: '
        },
        {
           name: 'Body',
           value: 'This email is generated by Runner-created application',
           type: 'textarea'
        },
        ]
     });
   }
    
   selectedRecords.forEach( function( ajaxRow, idx ) {
     pdfParams[ idx ] = {
        pageType: 'view',
        keys: ajaxRow.getKeys()
     };
     params.filenames.push( 'Purchase_Requisition#'+ajaxRow.getKeys()+'.pdf' )
     createOnePdf( idx );
    
   });
    
   return false;

   

6. In “Server” tab, place below code:

   $attachments = array();
   for( $i=0; $i< $params["recordCount"]; ++$i ) {
     $attachments[] = array(
       "path" => $button->saveTempFile( $params["pdf" . $i] ),
       "name" => $params["filenames"][$i]
     );
   }
   $mail = array();
   $mail["to"] = $params["Email"];
   $mail["subject"] = $params["Subject"];
   $mail["body"] = $params["Body"];
   $mail["attachments"] = $attachments;
    
   $ret = runner_mail( $mail );
    
   if( $ret["mailed"] )
   {
     $result["success"] = true;
   }
   else
   {
     $result["message"] = $ret["message"];
       $result["success"] = false;
   }

   

7. In “Client After” tab, paste below code:

   if( result.success ) {
       alert("Your email has been sent!");
   } else {
       alert("Error sending " + result.message);
   }

   

8. Place the “Send Email” button at the same row as “Add new” button.
   

---

 

Add “Print” and “Save PDF” functions

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to “Designer” tab, select “view” tab, click on “Insert…” dropdown and click “Custom Buttom”.
   
2. Click “New button…”.
   
3. For:-
   • “Print” button
     • “Client Before” tab

       window.print();
        // Uncomment the following line to prevent execution of "Server" and "Client After" events.
       return false;

       

   • “Save PDF” button
     • “Server” tab

       $record = $button->getCurrentRecord();
       $result["ID"] = $record["purchase_requisition_id"];

       

     • “Client After” tab

       var params = {
           table: 'purchase_requisition',
           page: 'view',
           pageType: 'view',
           keys: [result["ID"]],
           scale: 120
       }
       
       Runner.PDF.download(params, 'Purchase Requisition no. ' + result["ID"] + '.pdf');

       

4. Re-arrange “Print” and “Save PDF” buttons at the bottom.
   

---

Edit “Item Photo”, “Delivery Order Photo” and “Received Item Photo” to allow multiple image upload

BEFORE	AFTER
	Item Photo Delivery Order Photo Received Item Photo

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to “Designer” tab
2. Set as below:-
   • item_photo
     
   • delivery_order_photo
     
   • received_item_photo
     

---

 

Add database security to PRS

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to “Security” tab, select “Database” and create a new table for “users”.
   
2. Add a new user.
   
3. Set user group permission.
   
4. Add “Big-Boss” to <Admin> group.
   
5. Encrypt password.
   
6. Set JWT secret key: “YaaBF0qi8Wy7X9Wns2Ci”.
   

---

 

Change the title of the project to “Purchase Requisition System v.1.0”

BEFORE	AFTER

MODIFICATION in PHPRunner or cPanel or PHPMyAdmin

1. Go to “Editor” tab, double-click on “PRS” logo.
   
2. Rename it to “Purchase Requisition System v.1.0”.
   

---

 

v. 1.0 2025-01-02 Beta Testing Completed

TEST OBJECTIVE: Can PRS add another user?

TESTING METHODOLGY	TEST RESULT
Log in to PRS using:- Username = Big-Boss Password = 2024$BF#Taufiq Go to “Admin Area”. Click on “Add/Edit users” -> “Add new”. Add:- Username = Sweetco-Public Password = #2023Sweetco

---

 

TEST OBJECTIVE: Can “Item Photo”, “Delivery Order Photo” and “Received Item Photo” fields upload multiple images?

TESTING METHODOLGY	TEST RESULT
Add new record in Purchase Requisition. Go to “Item Photo”, “Delivery Order Photo” and “Received Item Photo” fields and upload more than 1 image to these fields.	Item Photo Delivery Order Photo Received Item Photo

---

 

TEST OBJECTIVE: Can “Send Email” function email the selected record to any email?

TESTING METHODOLGY	TEST RESULT
Select any record in Purchase Requisition. Click “Send Email” button. Send to “t1@mobitek.my”