PENGEMBANGAN SISTEM INFORMASI PEMASARAN PADA INTERNATIONAL SPORTS CLUB OF INDONESIA

1 PENGEMBANGAN SISTEM INFORMASI PEMASARAN PADA INTERNATIONAL SPORTS CLUB OF INDONESIA Oleh : REDIKA WINTANA PROGRAM STUDI SISTEM INFORMASI FAKUTLAS SA...
Author:  Budi Kurnia
209 downloads 277 Views 6MB Size
Report
DOWNLOAD PDF

Recommend Documents



{ print"<script>alert('Password Masih Kosong !'); javascript:history.go(-

Config.php 1);";


exit;

$host = "localhost"; $user = "root";

}else{

$pass = "";

include "config.php";

$databasename = "isci";

$query=mysql_query("select * from

$connection = mysql_connect($host, $user,

user

where

username='$username'

$pass) or die("Kesalahan Koneksi ...!!");

password='$password'");

and

mysql_select_db($databasename, $connection)

mysql_close($connection);

or die("Databasenya Error");

$hasil=mysql_fetch_array($query);

?>

if($hasil['username']==$username && $hasil['password']==$password){ session_start();

Cek Login.php

$euser=$hasil['username'];


$epass=$hasil['password'];

$username=$_POST['username']; $password=$_POST['password'];

$_SESSION['username']=$euser;

$username=mysql_escape_string($username); $password=mysql_escape_string($password);

$_SESSION['password']=$epass;

if(($username=='' && $password=='')) {

lxix

"September", header("location:Module.php?system

"Oktober", "Nopember",

=home");

"Desember");

}else{

var linkcount=0; print"<script>alert('Kombinasi Username dan Password Salah !');

function addlink(month, day, href) { var entry = new Array(3); entry[0] = month;

javascript:history.go(-1);"; exit; }

entry[1] = day; entry[2] = href; this[linkcount++] = entry;

}

}

?>

Array.prototype.addlink = addlink; linkdays = new Array(); monthdays = new Array(12);

Kalender.php

monthdays[0]=31;



monthdays[1]=28;


monthdays[2]=31;

$special=array(6,17,21);

monthdays[3]=30;

$tes ="1,2,3";

monthdays[4]=31;

$totSpecial=count($special);

monthdays[5]=30;

?>

monthdays[6]=31;

<SCRIPT LANGUAGE="JavaScript">

monthdays[7]=31; monthdays[8]=30;

specialDate = new Array();

monthdays[9]=31;

specialDate[0]=20;

monthdays[10]=30; monthdays[11]=31;



else{

document.write(count); }

Function.php
if (count==thisdate) {

include "config.php"; function sertifikat($a) {

document.write("");}

$query=mysql_query("select * from ketentuan_nilai where ketentuan like

if (b==0){

document.write("
");}

'%$a%'");

$hasil=mysql_fetch_array($query);

if (b==5){

$a=$hasil['value']; return $a;

document.write("
");}

} function posisi($a)

}

{

else {

$query=mysql_query("select

document.write(" "); }

* from ketentuan_nilai where ketentuan like '%$a%'");

if (linktrue) $hasil=mysql_fetch_array($query);

lxxii

}

$a=$hasil['value']; else

return $a;

{

}

$b="P9"; }

function pengalaman($a)

$query=mysql_query("select

{ if($a<=30 && $a>=25)

* from ketentuan_nilai where ketentuan like '%$b%'");

{ $b="P1";

$hasil=mysql_fetch_array($query);

}

$a=$hasil['value'];

else if($a<=24 && $a>=20)

return $a;

{ $b="P2";

}

} else if($a<=19 && $a>=15)

function usia_shipping($a) {

{ $b="P3";

if($a<=25 && $a>=20) {

}

$b="US1";

else if($a<=14 && $a>=10) }

{ $b="P4";

else if($a<=30 && $a>=26) {

}

$b="US2";

else if($a<=9 && $a>=7) }

{ $b="P5";

else if($a<=35 && $a>=31) {

}

$b="US3";

else if($a<=6 && $a>=5) }

{ $b="P6";

else if($a<=40 && $a>=36) {

}

$b="US4";

else if($a<=4 && $a>=3) }

{ $b="P7";

else if($a<=45 && $a>=41) {

}

$b="US5";

else if($a<=2 && $a>=1) }

{ $b="P8";

else if($a<=50 && $a>=46)

lxxiii

if($b==4)

{

{

$b="US6";

$c="I1";

} }

else if($a<=55 && $a>=51)

else if($b==3.9)

{

{

$b="US7";

$c="I2";

} }

else if($a<=60 && $a>=56)

else if($b==3.8)

{

{

$b="US8";

$c="I3";

} }

else if($a<=65 && $a>=60)

else if($b<=3.7 && $b>=3.5)

{

{

$b="US9";

$c="I4";

} }

$query=mysql_query("select * from ketentuan_nilai where ketentuan like

else if($b<=3.4 && $b>=3.2) {

'%$b%'");

$c="I5"; }

$hasil=mysql_fetch_array($query); $a=$hasil['value'];

else if($b<=3.1 && $b>=3.0) {

return $a;

$c="I6";

} }

else if($b<=2.9 && $b>=2.8)

//Logistik

{

function pendidikan($b)

$c="I7";

{ }

$query=mysql_query("select * from ketentuan_nilai where ketentuan like

else if($b==2.7) {

'%$b%'");

$c="I8"; }

$hasil=mysql_fetch_array($query); $b=$hasil['value']; return $b;

else { $c="I9";

} function ipk($b)

}

{

lxxiv

$b="UL7";

$query=mysql_query("select }

* from ketentuan_nilai where ketentuan like

else if($a<=43 && $a>=41)

'%$c%'");

{ $b="UL8";

$hasil=mysql_fetch_array($query); }

$a=$hasil['value'];

else if($a<=45 && $a>=45)

return $a;

{

}

$b="UL9"; }

function usia_logistik($a)

$query=mysql_query("select

{ if($a<=22 && $a>=20)

* from ketentuan_nilai where ketentuan like '%$b%'");

{ $b="UL1";

$hasil=mysql_fetch_array($query);

}

$a=$hasil['value'];

else if($a<=25 && $a>=23)

return $a;

{ }

$b="UL2"; ?>

} else if($a<=28 && $a>=26) { $b="UL3"; }

Keluar.php
else if($a<=31 && $a>=29) {

session_start(); $euser=$_SESSION['username'];

$b="UL4"; }

$epass=$_SESSION['password']; if(!empty($euser) && !empty($epass))

else if($a<=34 && $a>=32)

{

{

if ($_REQUEST['exit'] == $b="UL5";

"ok")

}

{

else if($a<=37 && $a>=35) {

session_destroy(); $b="UL6";

}

header("location:../index.html");

else if($a<=40 && $a>=38) {

} else

lxxv

baru
{

type="password"

name="newPass2" /> print"<script>alert('Gagal Logout !'); "; exit;

type="submit"

name="submit"

value="Submit">
type="reset"

name="reset" value="Cancel">

}



} else

{ print"<script>alert('Gagal Logout 2!'); javascript:history.go(1);";

Menu.Js // JavaScript Document

exit;

stm_bm(["menu0b0f",900,"","blank.gif",0,"",""

}

,1,0,250,0,1000,1,0,0,"","",0,0,1,2,"hand","han

?>

d","",1,25],this); stm_bp("p0",[0,4,0,0,0,0,0,1,100,"",-2,"",2,50,0,0,"#999999","#FFFFF7","",3,1,1,"#666

UpdatePass.php
666"]); />

Update

Password Manager Pemasaran



stm_ai("p0i0",[0,"HOME","","",-1,1,0,"Module.php?system=home","_self","",""," ","",0,0,0,"","",0,0,0,1,1,"#003366",0,"#003366


",0,"","bg01.gif",3,3,0,0,"#CCCCCC","#CCCC

method="post"

CC","#FFFFFF","#FFFFFF","bold

8pt

action="Module.php?system=update3">

Verdana","bold

8pt



Verdana",0,1,"","","","",0,0,0],80,20); stm_ai("p0i1",[6,1,"#CCCCCC","",-1,-1,0]);



stm_aix("p0i4","p0i0",[0,"LAPORAN PRODUK","","",-1,1,0,"Module.php?system=laporanperbulan","_s elf","","","","",0,0,0,"","arrow_r.gif",1,1,0,1,1,"



#003366",0,"#003366",0,"","bg01.gif",3,3,0,0," #CCCCCC","#CCCCCC","#FFFFFF","#FFFF FF","bold

8pt

Verdana","bold

8pt

Verdana",0,0],150,20);




align="center"

valign="middle"
bgcolor="#FFFFFF">:
width="152"

echo "
";

bgcolor="#FFFFFF">

$id_produk = $_GET['id'];



$query =


bgcolor="#00CCFF"

align="center"

valign="middle"

from

produk

where

id_produk='$id_produk'"; $s_me = mysql_query($query);

class="tgh1"><strong>produk
"delete

}

bgcolor="#FFFFFF">: $query = "select * from produk order by

Masukkan lama
password type="password"

name="oldPass" />
Masukkan baru
password type="password"

name="newPass1" />
Masukkan kembali password

stm_bpx("p1","p0",[1,4,0,0,0,0,0,0]);

lxxvi

stm_aix("p1i0","p0i1",[]);

}

stm_aix("p1i2","p0i1",[]);

var url="dataPegawaiAct.php";

stm_ep();

url=url+"?q="+str;

stm_aix("p0i5","p0i1",[]);

url=url+"&sid="+Math.random();

stm_aix("p0i2","p0i0",[0,"LAPORAN

xmlHttp.onreadystatechange=stateChanged4;

PROMOSI","","",-1,-

xmlHttp.open("GET",url,true);

1,0,"Module.php?system=viewpromosi"],140,2

xmlHttp.send(null);

0);

}

stm_aix("p0i3","p0i1",[]); stm_aix("p0i2","p0i0",[0,"BAURAN

function stateChanged4()

INTEGRASI","","",-1,-

{

1,0,"Module.php?system=bauran","_self","","",

if

"","",0,0,0,"","",0,0,0,1,1,"#003366",0,"#00336

xmlHttp.readyState=="complete")

6",0,"","bg01.gif",3,3,0,0,"#FFFFF7","#00000

{

(xmlHttp.readyState==4

||

0"],140,20); stm_aix("p0i3","p0i1",[]);

document.getElementById("txtHint4").innerH

stm_aix("p0i2","p0i0",[0,"UPDATE

TML=xmlHttp.responseText;

PASSWORD","","",-1,-

}

1,0,"Module.php?system=updatepas"],140,20);

}

stm_aix("p0i3","p0i1",[]); function GetXmlHttpObject() //stm_aix("p0i11","p0i1",[]);

{

//stm_aix("p0i12","p0i8",[0,"LOGOUT","","",-

var xmlHttp=null;

1,-1,0,"keluar.php?exit=ok"],80,20);

try

stm_ep();

{

stm_em();

// Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest();

var xmlHttp;

} catch (e)

function showUser4(str)

{

{

//Internet Explorer

xmlHttp=GetXmlHttpObject();

try

if (xmlHttp==null)

{

{

xmlHttp=new

alert ("Browser does not support HTTP

ActiveXObject("Msxml2.XMLHTTP");

Request");

}

return;

catch (e)

lxxvii

{

$query = "update produk set ";

xmlHttp=new

$query.= "id_produk='$id_produk',";

ActiveXObject("Microsoft.XMLHTTP");

$query.= "produk='$produk'"; $query.= "where id_produk='$id_produk'";

} } return xmlHttp;

$s_me = mysql_query($query);

}

if($s_me){ $message

=

class='pesan_sukses'>Input

"

produk

berhasil diinput
";

MasterProduk.php

}

<style type="text/css">

dimasukkan
"; }



} //2
DATA

MASTER

PRODUK

}//post edit

PADA ISCI


$id_produk= $_GET['id'];

include "config.php";

$query = "select * from produk where id_produk='$id_produk'";

if(strval($_GET['page'])=="edit"){

$s_me_v = mysql_query($query); $v_k = mysql_fetch_object($s_me_v);

if($_POST['edit']){

?>

$id_produk = $_POST['id_produk']; $produk = $_POST['produk'];


method="post"

action="Module.php?system=masterproduk&p if(!empty($id_produk)&&!empty($produk)){

age=edit&id=">

lxxviii



value="Batal" />

align="center">




width="245"



bgcolor="#00CCFF"

class="tgh1"><strong>id



produk

} }

include_once("config.php");

?> include_once("./includes/chart/Include



s/FusionCharts.php");

inser

$state=$_GET['state'];

t data baru


switch($state){

case "overall":

lxxx

value=\"$rowb[id_bulan]\">$rowb[bulan]
"
border=\"0\"

style=\"border-collapse: width=\"70%\"

ion>";

collapse;\" }

cellpadding=\"1\"

cellspacing=\"1\"> echo "


&state=result\" method=\"post\">



Pilih

<select

: name=\"tahun\">

<select

";

name=\"id_bulan\">

for($i=2009;$i<=2020;$i++){
value=\"0\">Semua

Bulan"; echo

"
value=\"$i\">$i"; $sqlb="SELECT * FROM bulan"; }

$queryb=mysql_query($sqlb);

echo "

while($rowb=mysql_fetch_array($que ryb)){

echo

"

lxxxi

type=\"submit\"

name=\"cek\" :

value=\"Lihat\">





<select

name=\"id_produk\">


";

value=\"0\">Semua

Produk";

$sqlp="SELECT * FROM produk";

echo "

$queryp=mysql_query($sqlp); ";

while($rowp=mysql_fetch_array($que

break; ryp)){

case "spesific": echo echo

"
border=\"0\"

style=\"border-collapse: width=\"70%\"

collapse;\"

"
value=\"$rowp[id_produk]\">$rowp[produk]";

cellpadding=\"1\" }

cellspacing=\"1\">

echo "





Pilih

lxxxii

if(isset($_POST['cek'])){

<select name=\"tahun\">

$id_produk=$_POST['id_produk']; "; $tahun=$_POST['tahun'];

if($id_produk==0){

for($i=2009;$i<=2020;$i++){

$a=""; echo

"";

SUM(L.jumlah_member) AS jum, P.produk }

FROM laporan L, produk P

WHERE

echo "

P.id_produk=L.id_produk AND

L.tahun='$tahun'



GROUP BY(L.id_produk)";
name=\"cek\" $query=mysql_query($sql);

value=\"Lihat\">





$a="


break;

formatNumberScale='0' showBorder='1'>";

case "result_spesific":

lxxxiii

while($row=mysql_fetch_array($quer y)){ $sqlc="SELECT $a.="<set label='".$row[produk]."' value='".$row[jum]."'

L.jumlah_member

AS jum, P.produk, B.bulan FROM laporan L, produk P, bulan B

/>"; WHERE }

P.id_produk='$id_produk' AND

$a.="

"; P.id_produk=L.id_produk AND echo renderChartHTML("./includes/chart/FusionCha rts/Column3D.swf",

B.id_bulan=L.id_bulan AND

"",$a,"Laporan

Pemasaran",800,500,false,false);

L.tahun='$tahun'

echo

ORDER

BY

B.id_bulan";

"
";

}else{ $queryc=mysql_query($sqlc);

echo

$sqlb="SELECT * FROM produk "
";

WHERE

id_produk='$id_produk'";

$a="

$queryb=mysql_query($sqlb);


caption='Hasil

$rowb[produk]

xAxisName='Bulan' $rowb=mysql_fetch_array($queryb);

Member'

Tahun

Summary $tahun'

yAxisName='Jumlah showValues='0'

formatNumberScale='0' showBorder='1'>";

lxxxiv

$id_bulan=$_POST['id_bulan'];

while($rowc=mysql_fetch_array($que ryc)){

$tahun=$_POST['tahun'];

$a.="<set

if($id_bulan==0){

label='".$rowc[bulan]."'

value='".$rowc[jum]."' />"; echo "
"; } $a="";

$sql="SELECT

$a.="

SUM(L.jumlah_member) AS jum, P.produk FROM laporan L, produk P "; WHERE

echo P.id_produk=L.id_produk AND

renderChartHTML("./includes/chart/Charts/Col umn3D.swf", "",$a,"Jumlah Member Pertahun

L.tahun='$tahun'

$tahun",800,500,false,false);

GROUP BY(L.id_produk)";

echo "

"; $query=mysql_query($sql); } $a=" }else{echo "Isi pilihan diatas untuk
melihat hasil";} caption='Hasil break;

$tahun'

Summary

Member

xAxisName='Nama

Tahun Produk'

yAxisName='Jumlah Member ' showValues='0' formatNumberScale='0' showBorder='1'>"; case 'result':

if(isset($_POST['cek'])){

lxxxv

while($row=mysql_fetch_array($quer y)){ $sqlc="SELECT $a.="<set label='".$row[produk]."' value='".$row[jum]."'

SUM(L.jumlah_member) AS jum, P.produk FROM laporan L, produk P

/>"; WHERE }

L.id_bulan='$id_bulan' AND

$a.="

"; P.id_produk=L.id_produk AND echo renderChartHTML("./includes/chart/FusionCha rts/Column3D.swf",

L.tahun='$tahun'

"",$a,"Laporan

GROUP

BY(L.id_produk)";

Pemasaran",800,500,false,false);

echo $queryc=mysql_query($sqlc);

"

";

echo

}else{ "
";

$sqlb="SELECT

*

FROM

bulan $a="

WHERE


id_bulan='$id_bulan'";

caption='Hasil

Summary

Member Bulan $rowb[bulan] Tahun $tahun' xAxisName='Produk' $queryb=mysql_query($sqlb);

Member

'

yAxisName='Jumlah showValues='0'

formatNumberScale='0' showBorder='1'>";

$rowb=mysql_fetch_array($queryb); while($rowc=mysql_fetch_array($que ryc)){

lxxxvi

?> $a.="<set

label='".$rowc[produk]."'



value='".$rowc[jum]."' />";

}



$a.="

";

echo renderChartHTML("./includes/chart/Charts/Col umn3D.swf", "",$a,"Jumlah Member Pertahun $tahun",800,500,false,false);

echo "
";

}

}else{echo "Isi pilihan diatas untuk melihat hasil";}

break;

default:

echo "<strong>Silakan klik link diatas untuk melihat detil laporan produk";

break; }

lxxxvii