SAP - PHP Connection

We know SAP, the great enterprise resource planning in the world. But very expensive budget to create and implement this software. But based on real case in some company, we have limitation in SAP, such as :

1. SAP always charge based on user name license, whereas we know employee of company always grow and increase.
2. If SAP implement in company that have some branches, it can be spent more budget. Because communication cost must be spent every month.
3. Develop new business and new reports and others.

So we can analyst about cost :

1. user license, we can reduce in this case, user license only for key processing but entry data or reporting we can user the simple application. Approximately we can reduce between 50 - 60%.
2. Cost of communications data transfer, we must subscribe private connection (VSAT/Frame Relay/MPLS) and spent budget to create connection to communicate between head office and branch. We can user GRPS or internet monthly.
3. Consultant service is very expensive to develop new business process/reporting, We must analyst about current and future business process, so we can plan how many spent time and cost to develop it, and if we need from outsourcing, we can analyst about our requirement.
4. SAP complete package not always suitable with our requirement, We must understand about some feature and package, so we can choose the correct features.

Actually SAP have provided some component and library to create connection to other programming. Such as SAP dot NET (SAP NET Connector) , SAP and Java (SAP Java Connector).

But currently, Eduard Koucky created SAP Remote Function Call (SAPRFC) to call SAP function from PHP command.This library have been published in http://saprfc.sourceforge.net, you can develop SAP tools using PHP.

Installationon Windows :

- PHP running well on Apache or IIS.

- Install SAP GUI / SAP Client software (SAP GUI 6.20)
- Download API & class from http://saprfc.sourceforge.net . Extract with new directory saprfc, example : http://localhost/saprfc.

- Take file php_saprfc.dll as modul extension ( C:\\php\ext ) and add on php.ini (extension=php_saprfc.dll).

- Copy file librfc32.dll from CD installer SAP GUI to system C:\\Windows\system32.

- Restart Web Server and cek your phpinfo.

Installation on Linux

- Install Apache and PHP

- Install php_devel

- Install GNU Tools (autoconf, automake, flex, libtool, gcc, m4, make)

- Install compat-libgcc , compat-libstdc++……

- We need SAPSDK taken from CD SAP on directory Linux/Unix and found file RFC.SAR dan SAPCAR. SAPCAR is decompress file from RFC.SAR. To extract please type ./SAPCAR -xvf RFC.CAR.

- Take extract result to directory /usr/sap/rfcsdk or other alternatif on /usr/local/rfcsdk or /opt/rfcsdk based on your want to.

- Download saprfc-..tar.gz, and extract it

$ gunzip -c saprfc-$VERSION$.tar.gz | tax xf -
$ cd saprfc-$VERSION$
$ phpize
$ ./configure
$ make
$ make install

- Restart Apache and check phpinfo

(phpug.or.id)

SAP - NET Connection, Integrated Database

PT. Astra International Tbk, a large company in Indonesia, Until now, they have implemented SAP connection between head office and branch. Astra International have some brand of car, Daihatsu, Toyota, Isuzu, BMW and Peugeot. Each brand have a head office business operational. And all of brand is handled by Head Office PT AI.

After some year running with SAP, they seem have to create a product to decrease budget of license. Because grow of this company is very quickly. So they have idea to create a software as bridge to SAP, but no decrease business process in SAP.

In Astra International company have standard of programming technology. They make Microsoft Dot Net to create solution. Hire a vendor from India and be assisted by IT employee department.

The basic of this idea is SAP as a large data store. And NET application as a data entry program.

They use Decentralization application method. Each branch have web application as server application special for a branch. To data synchronize to head office, that is synch method. There are schedule to data synchronize branch to head office and head office to branch. This method is called semi-online.

This solution can be implemented in all of business, cheaper and safer.

SMS President Application using Nokia Component

Masih segar ingatanku kali ya tentang masuknya berita ini di korang Jawapos edisi desember tahun 2004 (tanggalnya lupa, soalnya di jawapos gak ada history berita). Tetapi nama saya tidak masuk, malah nama dosen dan kampus saya yang nampang di koran halaman 14 dalam kolom sambungan HeadLine.

Anda mungkin masih ingat, ketika presiden SBY membuka jalur SMS pribadi dengan HP beliau sendiri dan terjadi crash dan overload, bahan berita ini menjadikan koran - koran nasional waktu itu menempatkan di Headline beritanya. Kenapa dan apa yang bisa menjadikan solusi untuk masalah ini. Kita pada waktu itu muncul sebagai pelopor untuk memberikan bantuan berupa aplikasi SMS President. Waktu pengerjaan hanya semalam

Saya diteman rekan kerja di Laboratorium Perangkat Lunak yang bernama Hoirul, melakukan modifikasi pada aplikasi lama yang pernah kami buat sebelumnya. Sederhana memang kalau dipikir, tetapi kami menang dalam masalah timing untuk masuk koran. Ada yang butuh dan urgent, apalagi presiden yang butuh, semalaman de kita nggak tidur. Modifikasi interface cari gambar presiden SBY dan ditempelin di gambar index.

Secara garis besar aplikasi SMS Presiden, requirementnya adalah sebagai berikut :

• HP / GSM Modem pada waktu itu saya memakai HP 5510
• Koneksi kabel Serial
• Komponen SMS pakek Komponen miliknya Nokia, (saya lupa downloadnya dimana, kapan2 saya share lagi)
• Tools Developer nya pakek MS Visual Basic
• Database pakek MS Access.
• PHP untuk nampilin SMS dari pengirim

Cara kerjanya :

• Kita aktifkan SMS Gatewaynya (aplikasi yang kita buat)
• Jika ada SMS masuk, dicek formatnya, jika bener masuk database dan mengirimkan SMS replay terima kasih telah berpartisipasi
• Ada aplikasi web untuk nampilin hasil SMSnya

Pakek Gammu buat SMS Birthday Remainder

Aplikasi ini sebenarnya sudah umum, tapi masih belum banyak dipakai di dalam sebuah sistem, misalkan sebuah perusahaan. Memang aplikasi ini adalah sebuah customer retention dari sebuah service produsen atau employee care saja dari sebuah pimpinan perusahaan.

Saya pernah develop aplikasi ini untuk Perusahaan telekomunikasi terbesar di Indonesia cabang Surabaya. Sebenarnya ini pesenan dari dosen yang kebetulan kenal dengan Managernya. Tujuan SMS Birth day remainder ini untuk memberikan perhatian yang lebih kepada spesial customer. Spesial Customer karena orang - orang dalam kategori ini merupakan penyumbang terbesar pendapatan, karena pemakaian pulsa sehari saja bisa mencapai 2 juta. Sehingga orang tersebut akan merasa diperhatikan dan akan merasa cinta pada Operator ini.

Gambaran sistemnya adalah aplikasi yang bisa secara otomatis mengirimkan SMS Selamat Ulang Tahun kepada nomor HP seseorang ketika waktu sekarang tepat hari ulang tahunnya. Tidak cukup itu saja, data hari kelahiran istri, anak-anaknya juga dijadikan parameter. Sehingga ketika hari ini menunjukkan ulang tahun anak atau istrinya, sistem akan mengirimkan selamat ulang tahun via SMS.

Requirementnya adalah sebagai berikut :

• Data Pelanggan, data ini diberikan oleh client saya, berupa table flat, syarat mutlak ya ada data Nomor handphone, Nama Customer, tempat dan tanggal lahir.
• Data Istri, Nama Istri customer, tempat dan tanggal lahir
• Data Anak, Nama Anak customer, tempat dan tanggal lahir.
• GSM Modem, pada waktu itu saya memakai GSM Model milik Siemens.
• Koneksi kabel masih pakek Serial
• Komponen SMS yang saya pakai Gammu/CWave
• Database MS Access
• Tools developernya MS Visual Basic 6.0

Karena aplikasinya ada di surabaya dan sudah lama, mohon maaf tidak dapat kami share di sini. Kapan - kapan kalau sempat saya akan buatkan untuk anda semua.

DoktorWare - Clinic Management System 1.0

DoktorWare - Clinic Management System - HIPAA Compliant

Download !

ICD and CPT support
HL-7 Compatibility
Automatic Appointment Reminder
Online appointment and registration request
Complete patient history
PDR for Drugs and Diseases
Transcription support
PDA Integration
EDI Integration(ANSI ASC X12 835 and 837)
Batch Bill and Claim Generation
Backup facility for Database and EMR
Print/Fax/Email facility for all reports
Custom Report Generator
Audit trial
Advanced search options
Automatic BMI and BSA calculator
Patient can communicate with doctor through web

== Security ==
System wide security to address Privacy & Security compliance for HIPAA.
User password controlled and administrator controlled modular access

== Professional Solution ==
Save time of patients as well as emloyees.
Helps in effective use of hospital resources.
Increased patient care and satisfaction.
Leads towards paper-less workflow.
Instant and Accurate access to patient data/recors.

== Economic Solution ==
Coder Department can be eliminated through DoktorWare prescription facility.
Avoid clearinghouse expense by automated sending/receiving insurance claims.
Less manpower requirements in whole departments.
== Advantages ==
Complete interfacing of all clinic functions allowing for better coordinated patient care.
Perpetual tracking of patients, employees and medical records for more accurate information management.
Integration of transcription system leading to cost minimization.
Consolidation of activities leading to efficient time management.