Knowledge Management System (KMS)

SOURCE also available here: http://store.usbong.ph/source/KMS/

DEMO version: http://store.usbong.ph/report/viewWebAddressList

EXAMPLE#1 STEPS:

1. Click "Search Patient" link
   
2. Enter Patient: "bergstein, aki"
   

EXAMPLE#2 STEPS:

1. Click "Search Medicine" link
   
2. Enter Item: "ace"

I. Screenshots

0) Example Work Output Videos

1) Information Desk

Example Web Address: http://192.168.1.110:80/usbong_kms/index.php/report/viewReportPatientQueue

2) Cashier/Accounting

Example Web Address: http://192.168.1.110:80/usbong_kms/index.php/report/viewWebAddressList

a) Search

b) Report

II. Add-on Software Requirements

LibreOffice Suite

https://www.libreoffice.org/; last accessed: 20240105

Java Runtime Environment (JRE)/Java Development Kit (JDK)

https://wiki.documentfoundation.org/Faq/General/InstallJava; last accessed: 20240105

A. NON-XAMPP, Linux Machine

1. Auto-install Web Server in Linux Machine

2. Download ZIP folder via CODE button on https://github.com/usbong/KMS
   --> use: GIT Commands for slow/zero access to Web Browser

3. Extract ZIP folder; Output: "KMS-master"
   

4. sudo chmod 777 /var/www/html
   

5. Copy "KMS-master/usbong_kms" folder; Paste to /var/www/html/
   

6. Enter the following website address in Computer Web Browser:
   http://localhost/phpmyadmin/
   

( ! ) Login Error? Solution to Problem#3) "MySQL Error: : 'Access denied for user 'root'@'localhost'"

7. Left Panel -> New -> Create database; with database name: usbong_kms
   
8. Top Panel -> Import -> Browse button
   --> Example input database file: KMS-master/DB/SQLCommands/usbong_kmsCreateDBTableStructureV20211219T0602.sql
   
9. Enter the following website address in Computer Web Browser
   localhost/usbong_kms/index.php/report/viewWebAddressList
   

Addtional Notes: Computer Server's Internet Protocol (IP) Address

Example: 192.168.1.110

1. Update: "C:\xampp\htdocs\usbong_kms\application\views\viewWebAddressList.php"
   --> Search and Replace keyphrase: default "192.168.11.62" with "localhost"
   --> 1.1): Set "localhost" to be the Computer Server's network IP Address
   Example: http://192.168.1.110/usbong_kms/index.php/report/viewWebAddressList
   

2. Update: "C:\xampp\htdocs\usbong_kms\application\config\config.php"
   Set base_url to be the Computer Server's network IP address
   

$config['base_url'] = 'http://localhost:80/usbong_kms/';

$config['base_url'] = 'http://192.168.1.110:80/usbong_kms/';

DONE!

( ! ) Database Error when accessing http://192.168.1.110/usbong_kms/index.php/report/viewReportPatientQueueAccounting? Solution to Problem#1) Report Patient Queue List Output: "... incompatible with sql_mode=only_full_group_by"

B. XAMPP

https://www.apachefriends.org/index.html

Technologies: Apache Web Server, MySQL, PHP, phpMyAdmin

B.1 Installation Notes (Windows)

1. Download and open (as Administrator) to install XAMPP file from https://www.apachefriends.org/download.html;
   --> Example: XAMPP for Windows 8.2.4
   

2. Download ZIP folder via CODE button on https://github.com/usbong/KMS
   --> use: GIT Commands for slow/zero access to Web Browser

3. Extract ZIP folder; Output: "KMS-master"
   --> use: Linux machine to extract and open the download ZIP folder

4. Copy "KMS-master" folder; Paste to /Documents/Usbong/
   

5. Copy "KMS-master/usbong_kms" folder to "C:\xampp\htdocs\usbong_kms"
   

6. skip this step; not necessary for Windows machines

7. Enter the following website address in Computer Web Browser:
   http://localhost/phpmyadmin/
   

8. Left Panel -> New -> Create database; with database name: usbong_kms
   

9. Top Panel -> Import -> Browse button
   --> Example input database file: KMS-master/DB/SQLCommands/usbong_kmsCreateDBTableStructureV20211219T0602.sql
   

10. Enter the following website address in Computer Web Browser
    localhost/usbong_kms/index.php/report/viewWebAddressList
    

Addtional Notes: Computer Server's Internet Protocol (IP) Address

Example: 192.168.1.110

1. Update: "C:\xampp\htdocs\usbong_kms\application\views\viewWebAddressList.php"
   --> Search and Replace keyphrase: default "192.168.11.62" with "localhost"
   --> 1.1): Set "localhost" to be the Computer Server's network IP Address
   Example: http://192.168.1.110/usbong_kms/index.php/report/viewWebAddressList
   

2. Update: "C:\xampp\htdocs\usbong_kms\application\config\config.php"
   Set base_url to be the Computer Server's network IP address
   

$config['base_url'] = 'http://localhost:80/usbong_kms/';

$config['base_url'] = 'http://192.168.1.110:80/usbong_kms/';

DONE!

B.2 Installation Notes (LINUX)

1. Download and open (as Administrator/SuperUser) to install XAMPP file from https://www.apachefriends.org/download.html;
   --> Example: XAMPP for Linux 7.4.27
   
2. Download ZIP folder via CODE button on https://github.com/usbong/KMS
   --> use: GIT Commands for slow/zero access to Web Browser
3. Extract ZIP folder; Output: "KMS-master"
   
4. Copy "KMS-master" folder; Paste to /opt/lampp/htdocs/
   
5. Rename "KMS-master" folder to "usbong_kms"
   
6. Enter the following COMMANDs in Terminal Window:
   sudo chmod 755 /opt/lampp/phpmyadmin/config.inc.php
   sudo /opt/lampp/xampp start
   
7. Enter the following website address in Computer Web Browser:
   http://localhost/phpmyadmin/
   
8. Left Panel -> New -> Create database; with database name: usbong_kms
   
9. Top Panel -> Import -> Browse button
   --> Example input database file: KMS-master/DB/SQLCommands/usbong_kmsCreateDBTableStructureV20211219T0602.sql
   
10. Enter the following website address in Computer Web Browser
    localhost/usbong_kms/index.php/report/viewWebAddressList
    

Addtional Notes: Computer Server's Internet Protocol (IP) Address

Example: 192.168.1.110

1. Update: "/opt/lampp/htdocs/usbong_kms/application/views/viewWebAddressList.php"
   --> Search and Replace keyphrase: default "192.168.11.62" with "localhost"
   --> 1.1): Set "localhost" to be the Computer Server's network IP Address
   Example: http://192.168.1.110/usbong_kms/index.php/report/viewWebAddressList
   

2. Update: "/opt/lampp/htdocs/usbong_kms/application/config/config.php"
   Set base_url to be the Computer Server's network IP address
   

$config['base_url'] = 'http://localhost:80/usbong_kms/';

$config['base_url'] = 'http://192.168.1.110:80/usbong_kms/';

DONE!

Reference: https://stackoverflow.com/questions/7577490/phpmyadmin-wrong-permissions-on-configuration-file-should-not-be-world-writabl;
last accessed: 20220314
answer by: Y. Joy Ch. Singha, 20180521T0816
edited by: bad_coder, 20210724T1636

B.3 Installation Notes (macOS)

1. Download and open (as Administrator/SuperUser) to install XAMPP file from https://www.apachefriends.org/download.html;
   --> Example: XAMPP for OS X 8.2.4
   

.dmg file; System Preferences... -> Security & Privacy -> General

Click the lock

Allow apps downloaded from: App Store and identified developers

directory location: /Applications/XAMPP/xamppfiles/htdocs

How to start application: https://www.apachefriends.org/faq_osx.html

TODO: -update: this

SELECT FILES to START auto-generation of REPORTS

1. kasangkapan/viewAllReportsForTheDayUnified.bat

2. Workbooks/moscReportForTheDayLibreOfficeCalc.ods

3. server/getSalesReportsForTheDay.php

4. DB/"add-on software"/software/autoUpdateFormatInputMySQLDBFile.java

5. "Miscellaneous Commands"/autoUpdateTotalQuantitySoldPerItemDatabase.bat

remember to update getTransactionsListFromFile() in Browse_Model

6. Models/Browse_Models.php; function getTransactionsListFromFile()

7. kasangkapan/autoScreenCaptureReports.bat

8. kasangkapan/autoScreenCaptureSummaryReportForTheDay.bat

9. kasangkapan/autoScreenCaptureSummaryReportForTheNoonDay.bat

TO-DO: -update: this; file locations

REMINDERS in auto-updating DB

Create shortcuts (WINDOWS) or put copies of these ("trusted") executable files (LINUX) on the DESKTOP

1. From Windows to Windows Server

2. From Windows to Linux Server

3. From Linux to Linux Server

Reminder

update IP address of target KMS server to access

Example

source="[email protected]:/home/unit_member/Documents/halimbawa/DB/"

Files to update based on Server Browser (MS Edge? Firefox)

1. https://github.com/usbong/KMS/blob/master/usbong_kms/kasangkapan/viewAllReportsForTheDayUnified.bat

2. https://github.com/usbong/KMS/blob/master/Miscellaneous%20Commands/autoUpdateTotalQuantitySoldPerItemDatabase.bat

TASK SCHEDULERS

Windows 11

--

Program/script: C:\Windows\System32\cmd.exe

Add arguments (optional): /c C:\xampp\htdocs\usbong_kms\kasangkapan\autoScreenCaptureReportUpdateTotalQuantitySoldPerItem.bat

Start in (optional): C:\xampp\htdocs\usbong_kms\kasangkapan\

Reference

https://stackoverflow.com/questions/26420003/batch-file-runs-manually-but-not-in-task-scheduler; last accessed: 20240513

Open Source Software License

Copyright 2019~2024 SYSON, MICHAEL B.

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

@company: USBONG
@author: SYSON, MICHAEL B.
@website address: http://www.usbong.ph

III. Add-on Software Tools

1) Chat

LAN Messenger: Instant Messenging Client (Official Website)
Action: Download (Windows)
Action: Download (Linux, also use lmc-1.2.35-win32.exe)

Notes

1. LAN = Local Area Network
   

2. For Linux Operating Systems (OS), e.g. LUBUNTU, we recommend using the software tool: "wine"
   2.1) Installation Steps:
   2.1.1) sudo apt-get install wine
   2.1.2) wine lmc-1.2.35-win32.exe
   --> You may verify using another version of the executable file.
   DONE!
   

3. Auto-start LAN Messenger
   --> verified: with LUBUNTU 20.04LTS Operating System (OS)
   --> 3.1) Click: Preferences -> LXQt Settings -> Session Settings
   --> 3.2) Click: "Autostart" icon in left panel
   --> 3.3) Click: "Add" Button
   --> Name: "LAN MESSENGER"
   --> Command: wine "/home/unit_member/.wine/drive_c/Program Files (x86)/LAN Messenger/lmc.exe"
   --> Additional Notes:
   --> Update correct location of "lmc.exe"
   --> No need to put check mark in checkbox of "Wait for system tray"
   --> 3.4) Click: "OK"
   --> 3.5) Click: "Close"
   --> DONE!
   

4. Error: "A port address conflict has been detected. LAN Messenger will close now"
   --> verified: with Windows7 Machine
   --> Solution: in CMD Prompt Window, enter this COMMAND in the lmc.exe directory:
   --> lmc.exe /noconfig
   --> DONE!
   --> Reference: https://unix.stackexchange.com/questions/405926/a-port-address-conflict-has-been-detected-lan-messenger-will-close-now; last accessed: 20220208

2) Auto-screen Capture Photograph Image

PhantomJS Tool (Official Website)

WINDOWS

2.1) Extract download file to "phantomjs-2.1.1-windows"

2.2) Copy "phantomjs-2.1.1-windows\phantomjs-2.1.1-windows\bin\phantomjs.exe" to "C:\xampp\htdocs\usbong_kms\kasangkapan"

IV. System Integration @Partner Clinic and Peripheral Units

To eliminate excess steps and inefficient time usage, the Marikina Orthopedic Specialty Clinic (MOSC) requested Usbong's services to automate routine, monotonous tasks and share with unit members know-how on computers.

https://www.usbong.ph/excel/


Example Tablet Personal Computer (PC)
Software+Hardware with MED Item Box Technique