Web ERP

web-sin11.JPG

 

Berikut Contoh Script PHP untuk modul SYNERGY menu utama General Ledjer, Aplikasi Web ERP baru saya kembangkan sampai pengisian master-master Table mySql, meliputi GL,COE,INV,UTILITAS belum ada waktu untuk mengembangkan ke arah Bisnis Proses seperti Pembuatan Purchase Order, Costomer Order Entry, dst…. namun GL sudah dikembangkan sampai Entry Journal Genral dan Petty Cash, siapa berminat untuk mengembangkan lebih sempurna lagi, menjadi Web ERP yang terintegrasi?…..

 

web-sin-gl.JPG.web-sin-gl-coa.JPG

 

 

 

<?php session_start();

 

include (“../settings.php”);

include (“../language/$cfg_language”);

include (“../classes/db_functions.php”);

include (“../classes/security_functions.php”);

include (“../classes/display.php”);

 

$lang=new language();

$dbf=new db_functions($cfg_server,$cfg_username,$cfg_password,$cfg_database,$cfg_tableprefix,$cfg_theme,$lang);

$sec=new security_functions($dbf,’Public’,$lang);

if(!$sec->isLoggedIn())

{

header (“location: ../login.php”);

exit();

}

 

$tablename = $cfg_tableprefix.’users’;

$authGL = $dbf->idToField($tablename,’GL’,$_SESSION[‘session_user_id’]);

$authAR = $dbf->idToField($tablename,’AR’,$_SESSION[‘session_user_id’]);

$authCOE = $dbf->idToField($tablename,’COE’,$_SESSION[‘session_user_id’]);

$authINV = $dbf->idToField($tablename,’INV’,$_SESSION[‘session_user_id’]);

$authAP = $dbf->idToField($tablename,’AP’,$_SESSION[‘session_user_id’]);

$authUTIL = $dbf->idToField($tablename,’UTILITY’,$_SESSION[‘session_user_id’]);

$authTYPE = $dbf->idToField($tablename,’type’,$_SESSION[‘session_user_id’]);

$per1 = $dbf->cekperiod(‘1’);

$per2 = $dbf->cekperiod(‘2’);

$dbf->closeDBlink();

?>

 

<html>

<style type=”text/css”>

<!–

.style1 {font-size: 14px;font-family: Sylfaen, Sydnie;color: #FF0000;}

.style2 {font-size: 12px}

.style3 {color: #006699;font-weight: bold;}

.style4 {font-size: 12px; font-weight: bold; }

.style5 {font-size: 16px; color:#0000CC; text-shadow:Maroon; }

.style6 {font-size:12px; color:#FF0000;}

–>

</style>

<header>

 

<SCRIPT LANGUAGE=”Javascript”>

<!—

// TAMBAHAN FUNGSI : MULYONO RAFIANTO

// ————————————-

// PENGGUNAAN : <a href=”http://www.telkom.net/index.php&#8221; onmouseover=”MM_swapImage(‘Image1′,”,’images/main_putih_menu_up_01.gif’,1)” onmouseout=”MM_swapImgRestore()”>

// : <img src=”infolayanan_telkomnetpremium_jt.php_files/main_putih_menu_01.gif” alt=”” name=”Image1″ id=”Image1″ border=”0″ height=”28″ width=”105″></a>

// : dalam …. onmouseover=”MM_swapImage(‘Image1’, …. dst image2,image3….

 

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a[i].indexOf(“#”)!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}

}

 

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;

}

 

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf(“?”))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

 

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

 

function fwLoadMenus_gl() {

if (window.fw_menu_0) return;

 

window.fw_menu_01F = new Menu(“F.Default Table”,180,20,”Verdana, Arial, Helvetica, sans-serif”,10,”#ffffff”,”#ffffff”,”#006699″,”#000033″);

fw_menu_01F.addMenuItem(“A.Cost”,”location=’gl_mstxcost.php'”);

fw_menu_01F.addMenuItem(“B.Teritory”,”location=’gl_mstxregion.php'”);

fw_menu_01F.addMenuItem(“C.Taxes Planing”);

 

window.fw_menu_01 = new Menu(“A.Maintenace”,180,20,”Verdana, Arial, Helvetica, sans-serif”,10,”#ffffff”,”#ffffff”,”#006699″,”#000033″);

fw_menu_01.addMenuItem(“A.Default & Table”,”location=’gl_mstdefault.php'”);

fw_menu_01.addMenuItem(“B.Chart of Account”,”location=’gl_mstcoa.php'”);

fw_menu_01.addMenuItem(“C.GL Periode Definition”,”location=’gl_mstperiod.php'”);

fw_menu_01.addMenuItem(“D.Type Journal File”,”location=’gl_mstjournal.php'”);

fw_menu_01.addMenuItem(“E.Departemen Cost”,”location=’gl_mstdepcost.php?up='”);

fw_menu_01.addMenuItem(fw_menu_01F);

fw_menu_01.hideOnMouseOut=true;

fw_menu_01.childMenuIcon=”../images/arrowsx.gif”;

 

window.fw_menu_02 = new Menu(“B.Journal Processing”,180,20,”Verdana, Arial, Helvetica, sans-serif”,10,”#ffffff”,”#ffffff”,”#006699″,”#000033″);

fw_menu_02.addMenuItem(“A.Journal Entry”,”location=’gl_protrans.php'”);

fw_menu_02.addMenuItem(“B.Journal Petty Cash”,”location=’gl_pcvtrans.php'”);

fw_menu_02.addMenuItem(“C.Journal Aproved”,”location=’gl_japproved.php'”);

fw_menu_02.addMenuItem(“D.Closing Period”);

fw_menu_02.addMenuItem(“E.GL Formulir”);

fw_menu_02.hideOnMouseOut=true;

 

 

window.fw_menu_0D = new Menu(“D.Reporting”,180,20,”Verdana, Arial, Helvetica, sans-serif”,10,”#ffffff”,”#ffffff”,”#006699″,”#000033″);

fw_menu_0D.addMenuItem(“A.Trail Ballance Post”);

fw_menu_0D.addMenuItem(“B.General Ledjer Post”);

fw_menu_0D.addMenuItem(“C.Profit and Lose Post”);

fw_menu_0D.addMenuItem(“D.Ballance Sheet Post”);

fw_menu_0D.addMenuItem(“E.Income Statment Period”);

fw_menu_0D.addMenuItem(“F.Cash Flow Post”);

 

// label,mw,mh,font ,fs, fclr , fhclr , bg , bgh

window.fw_menu_0 = new Menu(“root”,180,17,”Verdana, Arial, Helvetica, sans-serif”,10,”#ffffff”,”#ffffff”,”#006699″,”#000033″);

fw_menu_0.addMenuItem(fw_menu_01);

fw_menu_0.addMenuItem(fw_menu_02);

fw_menu_0.addMenuItem(“C.Periode & Processing”);

fw_menu_0.addMenuItem(fw_menu_0D);

fw_menu_0.addMenuItem(“E.Status”);

fw_menu_0.addMenuItem(“F.Aset”);

fw_menu_0.hideOnMouseOut=true;

fw_menu_0.childMenuIcon=”../images/arrowsx.gif”;

 

fw_menu_0.writeMenus();

} // fwLoadMenus()

 

//–>

</SCRIPT>

</header>

<body>

<?php include(“../fw_menu.php”); ?>

<script language=”JavaScript1.2″>fwLoadMenus_gl();</script>

<p class=”style3″><?php echo $lang->cfgl_utama; ?></p>

<a href=”#” onMouseOut=”FW_startTimeout();MM_swapImgRestore()”

onMouseOver=”MM_swapImage(‘image_util_backup’,”,’../images/clickme.gif’,1);

window.FW_showMenu(window.fw_menu_0,65,50)” >

<img name=”image_util_backup” src=”../images/menubar_syn02.GIF” width=”62″ height=”17″ border=”0″></a>

<?php echo ‘<table width=”100%” height=”451″ border=”0″ cellpadding=”0″ cellspacing=”0″>’ ?>

<tr>

<?php echo ‘<td width=”50%” height=”220″><p><strong><img src=”../images/items.gif” width=”26″ height=”33″><span class=”style1″>’ ?><?php echo $lang->cfgl_judul; echo ‘</span></strong></p>

<p align=”justify” class=”style2″>’ ?><?php echo $lang->cfgl_pesan; echo ‘</p>

<p align=”justify” class=”style2″> </p>

<p align=”justify” class=”style2″> </p></td>’; ?>

<td width=”45%” height=”50″><?php

echo ‘<iframe width=”100%” height=”200″ scrolling=”yes” frameborder=”0″ src=”gl_maindisp.php”>

</iframe>’; ?>

</td>

</tr>

<tr>

<td><p class=”style5″>Activity Status</p>

<table width=”384″ border=”0″ cellpadding=”0″ cellspacing=”0″>

<tr>

<td width=”252″><span class=”style2″><?php echo $lang->cfgutil_aktifgl; ?></span></td>

<td width=”116″><?php if ($authGL==’Y’) {echo $lang->cfgutil_aktif;} else {echo $lang->cfgutil_nonaktif;} ?></td>

</tr>

<tr>

<td><span class=”style2″><?php echo $lang->cfgutil_aktifar; ?></span></td>

<td><?php if ($authAR==’Y’) {echo $lang->cfgutil_aktif;} else {echo $lang->cfgutil_nonaktif;} ?></td>

</tr>

<tr>

<td><span class=”style2″><?php echo $lang->cfgutil_aktifcoe; ?></span></td>

<td><?php if ($authCOE==’Y’) {echo $lang->cfgutil_aktif;} else {echo $lang->cfgutil_nonaktif;} ?></td>

</tr>

<tr>

<td><span class=”style2″><?php echo $lang->cfgutil_aktifinv; ?></span></td>

<td><?php if ($authINV==’Y’) {echo $lang->cfgutil_aktif;} else {echo $lang->cfgutil_nonaktif;} ?></td>

</tr>

<tr>

<td><span class=”style2″><?php echo $lang->cfgutil_aktifar; ?></span></td>

<td><?php if ($authAP==’Y’) {echo $lang->cfgutil_aktif;} else {echo $lang->cfgutil_nonaktif;} ?></td>

</tr>

<tr>

<td><span class=”style2″><?php echo $lang->cfgutil_aktifutil; ?></span></td>

<td><?php if ($authUTIL==’Y’) {echo $lang->cfgutil_aktif;} else {echo $lang->cfgutil_nonaktif;} ?></td>

</tr>

</table>

<p><span class=”style5″>User Acces Category</span> : <?php echo $authTYPE ; ?></p>

<p><span class=”style6″>Period Active : <?php echo $per1; echo ‘ to ‘; echo $per2; ?></span></p>

<td width=”45%” height=”50″>

<iframe width=”100%” height=”200″ scrolling=”yes” frameborder=”0″ src=”gl_maindispx.php”>

</iframe>

</td>

</tr>

<tr>

</body>

</html>

This entry was posted in Programming. Bookmark the permalink.

4 Responses to Web ERP

  1. Hendra says:

    salam kenal mas..saya boleh ikutan untuk ngembangkan ERP yang sedang dikembangkan kebetulan saya pernah implement yang WEB-ERP.

  2. Mulyono says:

    kenal kembali…

    Sangat boleh, saat ini saya sedang fokus di oracle deplover membagun ERP Program under web.
    karna pake PHP terlalu scripting, debug nya agak susah.

    Salam
    Mulyono

  3. Nur says:

    salam kenal mas, mas punya program hotel yang berbasis web nggak…? saya ingin mengembangkannya. Thanks

  4. prap says:

    SALAM KENAL MAS….
    SAYA PUNYA APLIKASI DARI ORACLE FORM DAN REPORT DEVELOPER 6I…
    NIATNYA MAU SAYA CONVERT KE WEB BASE,DAN NEMU FILE PDF DARI MASNYA..
    SETELAH SAYA BACA,AGAK BINGUNG JUGA SIH…
    BINGUNGNYA CARA LOAD FILE FMX,DAN REF KE BROWSER,… SAMA SETTING APACHENYA…
    TOLONG PANDUANNYA…
    THANKS,SAYA PKEK ORACLE 11G ,DAN DEVELOPNYA ORACLE 6I,..
    EMAIL :prapsiska@gmail.com
    pleace help

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s