Irwin

105

DAFTAR PUSTAKA

Dennis, Alan, Barbara Haley Wixom, dan David Tegarden. 2009. System Analysis Design UML Version 2.0. An Object Oriented Approach. Third edition. United States: John Wiley & Sons, Inc. A O’Brien, James dan George M. Marakas. 2011. Management Information Systems. Tenth Edition. New York: McGraw-Hill/Irwin. Sholiq dan Imam Robandi (pendamping), 2010. Analisis dan Perancangan Berorientasi Obyek. Cet.ke-1. Jakarta : CV. Muara Indah. Adelheid, Andrea dan Khairil Nst. 2012. Buku Pintar Menguasai PHP MySQL. Jakarta: Mediakita. Nugroho, Eddy Prasetyo. 2009. Rekayasa Perangkat Lunak. Bandung: Telkom Polytechnic. Sutaji, Deni. 2012. Sistem Inventory Mini Market dengan PHP & JQuery. Yogyakarta: Lokomedia. Sukardi, Dewa Ketut dan Desak P.E Nila Kusmawati. 2008. Proses Bimbingan dan Konseling Di Sekolah. Jakarta: PT Rineka Cipta. Hikmawati, Fenti. 2012. Bimbingan Konseling. Edisi Revisi. Cet.ke-3. Jakarta: RajaGrafindo Persada.

LAMPIRAN - Program Index.html <style> p.ex2 { font:bold 11px arial,sans-serif; } <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <script type="text/javascript" src="jquery-1.7.1.js"> <script type="text/javascript"> // semua script di sini function fnlog(){ if($("#User").val()=="" ||$("#Pass").val()==""){ alert("Anda harus masukan user dan password dengan benar"); exit(); }else{



database.php DBConnection=mysql_connect($this>dbhost,$this->dbuser,$this->dbpassword); mysql_select_db($this->dbname); //mysql_query("SET NAMES 'utf8'"); mysql_query("SET character_set_client=utf8"); mysql_query("SET character_set_connection=utf8"); mysql_query("SET character_set_results=utf8");

$this>RecordCount=mysql_num_rows($this->Dataset); $this>FieldCount=mysql_num_fields($this->Dataset); if($this->RecordCount>0){$this>Eof=false;} } else { $this->RecordCount=0; $this->FieldCount=0; $this->Eof=true; $this->Bof=true; $this->Row=0; $this->Field=0; } } function Next() { if($this->Row<$this->RecordCount-1){$this>Row++;$this->Eof=false;}else{$this->Eof=true;} if($this->RecordCount>0){$this>Bof=false;}else{$this->Bof=true;} } function Prior() { if($this->Row>0){$this->Row--;$this>Bof=false;}else{$this->Bof=true;} if($this->RecordCount>0){$this>Eof=false;}else{$this->Eof=true;} }

} function SetConnection($Connection) { $this->DBConnection=$Connection; } //Forexcute an UPDATE,DELETE or StoredProcedure function Execute() { if($this->SQL!='') { $this->RecordCount=0; $this->FieldCount=0; $this->Eof=true; $this->Bof=true; $this->Row=0; $this->Field=0; $this->Dataset=mysql_query($this>SQL)or die("SQL Error!"); } else { die("No SQL command!"); } } function Open() { if($this->SQL!='') { $this->RecordCount=0; $this->FieldCount=0; $this->Eof=true; $this->Bof=true; $this->Row=0; $this->Field=0; $this->Dataset=mysql_query($this>SQL)or die("SQL Error!");

function First() { $this->Row=0; $This->Bof=true; if($this->RecordCount>0){$this>Eof=false;}else{$this->Eof=true;} } function Last() { $this->Row=$this->RecordCount-1; $this->Eof=true; if($this->RecordCount>0){$this>Bof=false;}else{$this->Bof=true;} } function Fieldvalue($fieldindex) { $this->Field=$fieldindex; return mysql_result($this->Dataset,$this>Row,$this->Field); } function FieldvaluebyName($fieldname) { $this->Field=$fieldindex; return mysql_result($this->Dataset,$this>Row,$fieldname); } function free() { mysql_free_result($this->Dataset); } }

//=====MSSQL class TMSQuery { var $DBConnection,$Dataset,$SQL,$extra=''; var $FieldCount=0,$RecordCount=0,$Row=0,$Field=0; var $Eof=false,$Bof=false; var $CurrentRow=-1; /* var $dbhost="192.168.5.7"; var $dbuser="dbbasic"; var $dbpassword="jv123"; var $dbname="vhitem"; */ var $dbhost="localhost"; var $dbuser="root"; var $dbpassword=""; var $dbname="wis"; function TMSQuery() { $this->DBConnection=sqlsrv_connect($this>dbhost,array("UID"=>$this->dbuser,"PWD"=>$this>dbpassword,"Database"=>$this->dbname)); if (!$this->DBConnection) { echo "Can not connect to the Database Server!"; } //mssql_select_db($this->dbname); } function SetConnection($Connection) { $this->DBConnection=$Connection; } //Forexcute an UPDATE,DELETE or StoredProcedure function Execute() { //not sure if can run a execute sql if($this->SQL!='') { $this->RecordCount=0; $this->FieldCount=0; $this->Eof=true; $this->Bof=true; $this->Row=0; $this->Field=0; $this->Dataset=sqlsrv_prepare($this>DBConnection,$this->SQL) or die(sqlsrv_errors()); $this->Dataset=sqlsrv_execute($this>Dataset) or die (sqlsrv_errors()); } else { die("No SQL command!"); } } function Open() { if($this->SQL!='') { $this->RecordCount=0; $this->FieldCount=0; $this->Eof=true; $this->Bof=true; $this->Row=0; $this->Field=0; $this->Dataset=sqlsrv_query($this>DBConnection,$this->SQL, array(),array( "Scrollable" => SQLSRV_CURSOR_KEYSET )) or die("SQL Error!");

$this->RecordCount=sqlsrv_num_rows($this->Dataset); $this->FieldCount=sqlsrv_num_fields($this->Dataset); if($this->RecordCount>0){$this>Eof=false;} } else { $this->RecordCount=0; $this->FieldCount=0; $this->Eof=true; $this->Bof=true; $this->Row=0; $this->Field=0; } } function Next() { if($this->Row<$this->RecordCount-1){$this>Row++;$this->Eof=false;}else{$this->Eof=true;} if($this->RecordCount>0){$this>Bof=false;}else{$this->Bof=true;} } function Prior() { if($this->Row>0){$this->Row--;$this>Bof=false;}else{$this->Bof=true;} if($this->RecordCount>0){$this>Eof=false;}else{$this->Eof=true;} } function First() { $this->Row=0; $This->Bof=true; if($this->RecordCount>0){$this>Eof=false;}else{$this->Eof=true;} } function Last() { $this->Row=$this->RecordCount-1; $this->Eof=true; if($this->RecordCount>0){$this>Bof=false;}else{$this->Bof=true;} } function Fieldvalue($fieldindex) { $this->Field=$fieldindex; sqlsrv_fetch($this>Dataset,SQLSRV_SCROLL_ABSOLUTE,$this->Row); return sqlsrv_get_field($this->Dataset,$this>Field); } function FieldvaluebyName($fieldname) { die("SQL Server can not use FieldvaluebyName!"); } function free() { mssql_free_result($this->Dataset); } } ?>

Inputkerjakemas.php alert('Anda Harus Login !')"; exit(); } ?> <style> p.ex1 { font:bold 12px fantasy ; }

}); }

$(function() { fnLoad(); }); //saat click kode soal baru soal terdisplay function fnShowSoal(){ if ($('#mkdsoal').val()==""){exit();} $.get('./displaysoalkemas.php',{kodesoal:$('#mkdsoal').val (),kdkelas:$('#mkdkelas').val()}, function(data){ $('#grid').html(data); }); }

// <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <script type="text/javascript" src="jquery1.7.1.js"> <script src="./jquery.ui.datepicker.js"> -->

<script type="text/javascript"> function fnout(){ window.location.replace ("./menuutamasiswa.html"); } function fnLoad(){ //dapatkan data dari koneksidata.php dan simpan pada temporary data $.get('./displayuser.php', function(data){ var dataAll = data; alert (dataAll); if(dataAll=="userid tidak terdaftar sebagai siswa"){ window.location.replace ("./index.html"); } //untuk tampilkan data di isian. var str = dataAll.split('#'); //alert(str); $('#mnik').val(str[0]); $('#mkdkelas').val(str[1]); $('#mnama').val(str[2]);

function fnsave(){ alert($('#mnik').val());

// alert(maxIdx); var strHasil="" ; for (var i=0;i<(maxIdx);i++) //{alert($('select[name="jwb1"]:eq('+i+')').val() +$('select[name="jwb2"]:eq('+i+')').val()+$('select[name=" jwb3"]:eq('+i+')').val()+"
"); //} { strHasil = strHasil + $('#mnik').val() + "#" + $('#mkdkelas').val() + "#" + $('#mkdsoal').val() + "#" + $('input[name="aspek"]:eq('+i+')').val() + "#" + $('input[name="nom"]:eq('+i+')').val() + "#" + $('select[name="jwb1"]:eq('+i+')').val()+"##"; } //alert(strHasil);

$.get('./koneksiData.php',{type:"savekerjakemas",datasave :strHasil}, function(data){ alert(data); fnLoad(); $('#mkdsoal').val()===""; $('#mkdkelas').val()===""; fnShowSoal(); //fnbersihlayar(); }); } function fnbersihlayar(){ $.get('./displaysoalkemas.php',function(data){ $("#grid").html(data); }); } //inputTbl

$.get('./koneksiData.php',{type:"isicomkerjasoalkemas",strmk dkelas:$("#mkdkelas").val()}, function(data){ //alert (data); $('#mkdsoal').empty(data); $('#mkdsoal').append(data);

No Induk Siswa :

Nama Siswa :

Kode Kelas :

Kode Soal :

Koneksidata.php (type savekerjakemas) else if($type=="savekerjakemas"){ $datasave=$_GET['datasave']; $dataRow = explode("##", $datasave); // Untuk simpan ke Thasil for ($i=0;$i<= count($dataRow)-2;$i++){ $dataField = explode("#",$dataRow[$i]); $rs->SQL="insert into thasilkemas values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$dataField[3]."','".$dataField[4]."','".$dataField[5]."',now( )) ";

//echo "select jeis, count(*) jum from tuser where userid = '".$strUser."' and password = '".$strPass."'"; echo "insert into thasilkemas values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$dataField[3]."','".$dataField[4]."','".$dataField[5]."',now( )) "; $rs->Execute(); echo 'Sukses simpan'; if($dataField[3] == "EKONOMI"){ $toteko = $toteko + $dataField[5]; $totaleko = $totaleko + count($dataField[3]); $hasileko = (($toteko / ( 3 * $totaleko ) * 100 )); echo "total nilai eko : '".$toteko."' + '".$totaleko."' + '".$hasileko."'";} else { if($dataField[3] == "REKREASI"){

$hasilsek = (($totsek / (3 * $totalsek) * 100 )); echo "total nilai kes : '".$totsek."' + '".$hasilsek."'";} else { if($dataField[3] == "GURU"){ $totguru = $totguru + $dataField[5]; $totalguru = $totalguru + count($dataField[3]); $hasilguru = (($totguru / (3 * $totalguru) * 100 )); echo "total nilai kes : '".$totguru."' + '".$hasilguru."'";} else { if($dataField[3] == "BELAJAR"){ $totbel = $totbel + $dataField[5]; $totalbel = $totalbel + count($dataField[3]); $hasilbel = (($totbel / (3 * $totalbel) * 100 )); echo "total nilai kes : '".$totbel."' + '".$hasilbel."'";} else { if($dataField[3] == "MOTIVASI"){ $totmot = $totmot + $dataField[5]; $totalmot = $totalmot + count($dataField[3]); $hasilmot = (($totmot / (3 * $totalmot) * 100 )); echo "total nilai kes : '".$totmot."' + '".$hasilmot."'";} else { if($dataField[3] == "CINTA"){ $totcin = $totcin + $dataField[5]; $totalcin = $totalcin + count($dataField[3]); $hasilcin = (($totcin / (3 * $totalcin) * 100 )); echo "total nilai kes : '".$totcin."' + '".$hasilcin."'";} }}}}}}}}}}}} // Untuk tarik data ambil range formula $tampilrangekemas = new TQuery();

$totrek = $totrek + $dataField[5]; $totalrek = $totalrek + count($dataField[3]); $hasilrek = (($totrek / (3 * $totalrek) * 100 )); echo "total nilai rek : '".$totrek."' + '".$hasilrek."'";} else { if($dataField[3] == "KESEHATAN"){ $totkes = $totkes + $dataField[5]; $totalkes = $totalkes + count($dataField[3]); $hasilkes = (($totkes / (3 * $totalkes) * 100 )); echo "total nilai kes : '".$totkes."' + '".$hasilkes."'";} else { if($dataField[3] == "TEMAN"){ $tothub = $tothub + $dataField[5]; $totalhub = $totalhub + count($dataField[3]); $hasilhub = (($tothub / (3 * $totalhub) * 100 )); echo "total nilai kes : '".$tothub."' + '".$hasilhub."'";} else { if($dataField[3] == "KEYAKINAN"){ $totdiri = $totdiri + $dataField[5]; $totaldiri = $totaldiri + count($dataField[3]); $hasildiri = (($totdiri / (3 * $totaldiri) * 100)); echo "total nilai kes : '".$totdiri."' + '".$hasildiri."'";} else { if($dataField[3] == "KELUARGA"){ $totkel = $totkel + $dataField[5]; $totalkel = $totalkel + count($dataField[3]); $hasilkel = (($totkel / (3 * $totalkel) * 100 )); echo "total nilai kes : '".$totkel."' + '".$hasilkel."'";} else { if($dataField[3] == "MASADEPAN"){ $totmasa = $totmasa + $dataField[5]; $totalmasa = $totalmasa + count($dataField[3]); $hasilmasa = (($totmasa / (3 * $totalmasa) * 100 )); echo "total nilai kes : '".$totmasa."' + '".$hasilmasa."'";} else { if($dataField[3] == "SEKOLAH"){ $totsek = $totsek + $dataField[5]; $totalsek = $totalsek + count($dataField[3]); else{ if($hasilkes <= $tampilrangekemas->Fieldvalue(3)){ $mkesint="BeB";} } } if($hasilhub > $tampilrangekemas->Fieldvalue(2) and $hasilhub <= $tampilrangekemas->Fieldvalue(1) ){ $mhubint="SaB";} else{ if($hasilhub > $tampilrangekemas->Fieldvalue(3) and $hasilhub <= $tampilrangekemas->Fieldvalue(2) ){ $mhubint="SuB";} else{ if($hasilhub <= $tampilrangekemas->Fieldvalue(3)){ $mhubint="BeB";} } } if($hasildiri > $tampilrangekemas->Fieldvalue(2) and $hasildiri <= $tampilrangekemas->Fieldvalue(1) ){ $mdiriint="SaB";} else{ if($hasildiri > $tampilrangekemas->Fieldvalue(3) and $hasildiri <= $tampilrangekemas->Fieldvalue(2) ){ $mdiriint="SuB";} else{ if($hasildiri <= $tampilrangekemas->Fieldvalue(3)){ $mdiriint="BeB";} } } if($hasilkel > $tampilrangekemas->Fieldvalue(2) and $hasilkel <= $tampilrangekemas->Fieldvalue(1) ){ $mkelint="SaB";} else{

$tampilrangekemas->SQL="select * from `tformulakemas` where `kdsoal` = '".$dataField[2]."'"; $tampilrangekemas->Open();

if($hasileko > $tampilrangekemas->Fieldvalue(2) and $hasileko <= $tampilrangekemas->Fieldvalue(1)){ $mekoint="SaB";} else{ if($hasileko > $tampilrangekemas->Fieldvalue(3) and $hasileko <= $tampilrangekemas->Fieldvalue(2) ){ $mekoint="SuB";} else{ if($hasileko <= $tampilrangekemas->Fieldvalue(3)){ $mekoint="BeB";} } } if($hasilrek > $tampilrangekemas->Fieldvalue(2) and $hasilrek <= $tampilrangekemas->Fieldvalue(1) ){ $mrekint="SaB";} else{ if($hasilrek > $tampilrangekemas->Fieldvalue(3) and $hasilrek <= $tampilrangekemas->Fieldvalue(2) ){ $mrekint="SuB";} else{ if($hasilrek <= $tampilrangekemas->Fieldvalue(3)){ $mrekint="BeB";} } } if($hasilkes > $tampilrangekemas->Fieldvalue(2) and $hasilkes <= $tampilrangekemas->Fieldvalue(1) ){ $mkesint="SaB";} else{ if($hasilkes > $tampilrangekemas->Fieldvalue(3) and $hasilkes <= $tampilrangekemas->Fieldvalue(2) ){ $mkesint="SuB";}

$hasilguru <= $tampilrangekemas->Fieldvalue(2) ){ $mguruint="SuB";} else{ if($hasilguru <= $tampilrangekemas->Fieldvalue(3)){ $mguruint="BeB";} } } if($hasilbel > $tampilrangekemas->Fieldvalue(2) and $hasilbel <= $tampilrangekemas->Fieldvalue(1) ){ $mbelint="SaB";} else{ if($hasilbel > $tampilrangekemas->Fieldvalue(3) and $hasilbel <= $tampilrangekemas->Fieldvalue(2) ){ $mbelint="SuB";} else{ if($hasilbel <= $tampilrangekemas->Fieldvalue(3)){ $mbelint="BeB";} } } if($hasilmot > $tampilrangekemas->Fieldvalue(2) and $hasilmot <= $tampilrangekemas->Fieldvalue(1) ){ $mmotint="SaB";} else{ if($hasilmot > $tampilrangekemas->Fieldvalue(3) and $hasilmot <= $tampilrangekemas->Fieldvalue(2) ){ $mmotint="SuB";} else{ if($hasilmot <= $tampilrangekemas->Fieldvalue(3)){ $mmotint="BeB";} } } if($hasilcin > $tampilrangekemas->Fieldvalue(2) and $hasilcin <= $tampilrangekemas->Fieldvalue(1) ){

if($hasilkel > $tampilrangekemas->Fieldvalue(3) and $hasilkel <= $tampilrangekemas->Fieldvalue(2) ){ $mkelint="SuB";} else{ if($hasilkel <= $tampilrangekemas->Fieldvalue(3)){ $mkelint="BeB";} } } if($hasilmasa > $tampilrangekemas->Fieldvalue(2) and $hasilmasa <= $tampilrangekemas->Fieldvalue(1) ){ $mmasaint="SaB";} else{ if($hasilmasa > $tampilrangekemas->Fieldvalue(3) and $hasilmasa <= $tampilrangekemas->Fieldvalue(2) ){ $mmasaint="SuB";} else{ if($hasilmasa <= $tampilrangekemas->Fieldvalue(3)){ $mmasaint="BeB";} } } if($hasilsek > $tampilrangekemas->Fieldvalue(2) and $hasilsek <= $tampilrangekemas->Fieldvalue(1) ){ $msekint="SaB";} else{ if($hasilsek > $tampilrangekemas->Fieldvalue(3) and $hasilsek <= $tampilrangekemas->Fieldvalue(2) ){ $msekint="SuB";} else{ if($hasilsek <= $tampilrangekemas->Fieldvalue(3)){ $msekint="BeB";} } } if($hasilguru > $tampilrangekemas->Fieldvalue(2) and $hasilguru <= $tampilrangekemas->Fieldvalue(1) ){ $mguruint="SaB";} else{ if($hasilguru > $tampilrangekemas->Fieldvalue(3) and ".$mkelint."','".$totmasa."','".$hasilmasa."','".$mmasaint."', // '".$totsek."','".$hasilsek."','".$msekint."','".$totguru."','".$hasil guru."','".$mguruint."','".$totbel."','".$hasilbel."','".$mbelint."', // '".$totmot."','".$hasilmot."','".$mmotint."','".$totcin."','".$hasil cin."','".$mcinint."',now( ))"; }

Koneksidata.php (type savekerjapribadi) else if($type=="savekerjapribadi"){ //echo "save data siswa"; $datasave=$_GET['datasave']; $dataRow = explode("##", $datasave);

// Untuk simpan ke Thasil for ($i=0;$i<= count($dataRow)-2;$i++){ $dataField = explode("#",$dataRow[$i]); $rs->SQL="insert into thasilpribadi values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$dataField[3]."','".$dataField[4]."','".$dataField[5]."','".$data Field[6]."','".$dataField[7]."','".$dataField[8]."','".$dataField[9 ]."','".$dataField[10]."','".$dataField[11]."',now( )) ";

$totteoritis = $totteoritis + $dataField[6]; $totekonomis = $totekonomis + $dataField[7]; $totestetis = $totestetis + $dataField[8]; $totsosial = $totsosial + $dataField[9]; $totpolitik = $totpolitik + $dataField[10];

$mcinint="SaB";} else{ if($hasilcin > $tampilrangekemas->Fieldvalue(3) and $hasilcin <= $tampilrangekemas->Fieldvalue(2) ){ $mcinint="SuB";} else{ if($hasilcin <= $tampilrangekemas->Fieldvalue(3)){ $mcinint="BeB";} } } $rs->SQL="insert into trekapkemas values('".$dataField[0]."','".$dataField[1]."','".$dataField[2] ."','".$totkes."','".$hasilkes."','".$mkesint."', '".$toteko."','".$hasileko."','".$mekoint."','".$totrek."','".$ha silrek."','".$mrekint."','".$tothub."','".$hasilhub."','".$mhubi nt."', '".$totdiri."','".$hasildiri."','".$mdiriint."','".$totkel."','".$has ilkel."','".$mkelint."','".$totmasa."','".$hasilmasa."','".$mma saint."', '".$totsek."','".$hasilsek."','".$msekint."','".$totguru."','".$ha silguru."','".$mguruint."','".$totbel."','".$hasilbel."','".$mbel int."', '".$totmot."','".$hasilmot."','".$mmotint."','".$totcin."','".$ha silcin."','".$mcinint."',now( ))"; $rs->Execute(); echo 'sukses simpan'; //echo "insert into trekapkemas values('".$dataField[0]."','".$dataField[1]."','".$dataField[2] ."','".$totkes."','".$hasilkes."','".$mkesint."', // '".$toteko."','".$hasileko."','".$mekoint."','".$totrek."','".$ha silrek."','".$mrekint."','".$tothub."','".$hasilhub."','".$mhubi nt."', // '".$totdiri."','".$hasildiri."','".$mdiriint."','".$totkel."','".$has ilkel."','

} if($totekonomis > $tampilrangepribadi->Fieldvalue(2) and $totekonomis <= $tampilrangepribadi->Fieldvalue(1) ){ $mekonomisint="T";} else{ if($totekonomis > $tampilrangepribadi->Fieldvalue(3) and $totekonomis <= $tampilrangepribadi->Fieldvalue(2) ){ $mekonomisint="S";} else{ if($totekonomis <= $tampilrangepribadi>Fieldvalue(3)){ $mekonomisint="R";} } } if($totestetis > $tampilrangepribadi->Fieldvalue(2) and $totestetis <= $tampilrangepribadi->Fieldvalue(1) ) { $mestetisint="T";} else{ if($totestetis > $tampilrangepribadi->Fieldvalue(3) and

$totreligius = $totreligius + $dataField[11]; //echo "select jeis, count(*) jum from tuser where userid = '".$strUser."' and password = '".$strPass."'"; echo "insert into thasilpribadi values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$dataField[3]."','".$dataField[4]."','".$dataField[5]."','".$data Field[6]."','".$dataField[7]."','".$dataField[8]."','".$dataField[9 ]."','".$dataField[10]."','".$dataField[11]."',now( )) "; $rs->Execute(); echo 'Sukses simpan'; } // Untuk simpan ke Trekap echo "dapatkan total ('".$totteoritis."','".$totekonomis."','".$totestetis."','".$totsosial. "','".$totpolitik."','".$totreligius."')"; // Untuk tarik data ambil range formula $tampilrangepribadi = new TQuery(); $tampilrangepribadi->SQL="select * from tformulapribadi where kdsoal = '".$dataField[2]."'"; $tampilrangepribadi->Open(); echo "'".$tampilrangepribadi->Fieldvalue(2)."'"; if($totteoritis > $tampilrangepribadi->Fieldvalue(2) and $totteoritis <= $tampilrangepribadi->Fieldvalue(1)){ $mteoritisint="T";} else{ if($totteoritis > $tampilrangepribadi->Fieldvalue(3) and $totteoritis <= $tampilrangepribadi->Fieldvalue(2) ){ $mteoritisint="S";} else{ if($totteoritis <= $tampilrangepribadi->Fieldvalue(3)){ $mteoritisint="R";} } if($totreligius > $tampilrangepribadi->Fieldvalue(2) and $totreligius <= $tampilrangepribadi->Fieldvalue(1) ) { $mreligiusint="T";} else{ if($totreligius > $tampilrangepribadi->Fieldvalue(3) and $totreligius <= $tampilrangepribadi->Fieldvalue(2) ) { $mreligiusint="S";} else{ if($totreligius <= $tampilrangepribadi->Fieldvalue(3)){ $mreligiusint="R";} } }

echo "GET FORMULA PRIBADI RANGE('".$dataField[2]."','".$tampilrangepribadi>Fieldvalue(1)."','".$tampilrangepribadi>Fieldvalue(2)."','".$tampilrangepribadi>Fieldvalue(3)."','".$mteoritisint."')"; echo "insert into TREKAPPRIBADI values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$dataField[6]."','".$mteoritisint."','".$dataField[7]."','".$mek onomisint."', '".$dataField[8]."','".$mestetisint."','".$dataField[9]."','".$msos ialint."','".$dataField[10]."','".$mpolitikint."','".$dataField[11]. "','".$mreligiusint."',now( )) "; // $rs->SQL="insert into trekappribadi values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$dataField[6]."','".$mteoritisint."','".$dataField[7]."','".$mek onomisint."', //

$totestetis <= $tampilrangepribadi->Fieldvalue(2) ) { $mestetisint="S";} else{ if($totestetis <= $tampilrangepribadi->Fieldvalue(3)){ $mestetisint="R";} } } if($totsosial > $tampilrangepribadi->Fieldvalue(2) and $totsosial <= $tampilrangepribadi->Fieldvalue(1) ) { $msosialint="T";} else{ if($totsosial > $tampilrangepribadi->Fieldvalue(3) and $totsosial <= $tampilrangepribadi->Fieldvalue(2) ) { $msosialint="S";} else{ if($totsosial <= $tampilrangepribadi->Fieldvalue(3)){ $msosialint="R";} } } if($totpolitik > $tampilrangepribadi->Fieldvalue(2) and $totpolitik <= $tampilrangepribadi->Fieldvalue(1) ) { $mpolitikint="T";} else{ if($totpolitik > $tampilrangepribadi->Fieldvalue(3) and $totpolitik <= $tampilrangepribadi->Fieldvalue(2) ) { $mpolitikint="S";} else{ if($totpolitik <= $tampilrangepribadi->Fieldvalue(3)){ $mpolitikint="R";} } }

'".$dataField[8]."','".$mestetisint."','".$dataField[9]."','".$msos ialint."','".$dataField[10]."','".$mpolitikint."','".$dataField[11]. "','".$mreligiusint."',now( ))"; $rs->SQL="insert into trekappribadi values('".$dataField[0]."','".$dataField[1]."','".$dataField[2]."',' ".$totteoritis."','".$mteoritisint."','".$totekonomis."','".$mekon omisint."', '".$totestetis."','".$mestetisint."','".$totsosial."','".$msosialint."' ,'".$totpolitik."','".$mpolitikint."','".$totreligius."','".$mreligius int."',now( ))"; $rs->Execute(); echo 'Sukses simpan'; }

Laporanrekappribadiexcell.php SQL="select trekappribadi.* , tsiswa.nama from trekappribadi, tsiswa where trekappribadi.nik = tsiswa.nik and trekappribadi.kdkelas = '".$strkdkelas."'"; $rs->Open(); if($rs->RecordCount == 0){ echo "Tidak ada data"; exit;} header("Pragma: public"); header("Expires: 0"); header("Content-Type:application/vnd.ms-excel; charset=utf8"); header("Content-type:application/x-msexcel; charset=utf-8"); header("Cache-Control: must-revalidate, post-check=0, precheck=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header("Content-Disposition: attachment;filename=laporanrekappribadi.xls"); header("Content-Transfer-Encoding: binary "); echo '

NIK

Nama

Kelas

Teknis

Sta Tek

Sains

Sta Sains

Seni

Sta Seni

Sosial

Sta Sos

Bisnis

Sta Bisnis

Operasi

Sta Ops

';

while (!$rs->Eof){ echo '

'.$rs->Fieldvalue(0).'

'.$rs->Fieldvalue(16).'

'.$rs->Fieldvalue(1).'

'.$rs->Fieldvalue(3).'

'.$rs->Fieldvalue(4).'

'.$rs->Fieldvalue(5).'

'.$rs->Fieldvalue(6).'

'.$rs->Fieldvalue(7).'

'.$rs->Fieldvalue(8).'

'.$rs->Fieldvalue(9).'

'.$rs->Fieldvalue(10).'

'.$rs->Fieldvalue(11).'

'.$rs->Fieldvalue(12).'

'.$rs->Fieldvalue(13).'

'.$rs->Fieldvalue(14).'

'; $rs->Next();} ?>

LAMPIRAN - Contoh Instrumentasi Data diambil dari buku : Proses Bimbingan dan Konseling di Sekolah. Karangan : Drs. Dewa Ketut Sukardi, MBA, MM Desak P.E. Nila Kusmawati, S.Si, M.Si

DAFTAR RIWAYAT HIDUP

DATA PRIBADI Nama Lengkap Tempat dan tanggal lahir Jenis Kelamin Golongan Darah Status Alamat Telepon / Handphone Email Kewarganegaraan

: : : : : : : : :

B. Eddy Santoso Pangkalpinang, 16 Oktober 1969 Laki-laki AB Menikah Jln. Rasamala Permai II H2/6 Jakarta Barat 0811179976 [email protected] Indonesia

LATAR BELAKANG PENDIDIKAN Tahun 1993 D-3 STMIK Bina Nusantara - Jakarta. KEMAMPUAN General Audit Operasional Banking IT Audit – General Control, Security, BCP, EUC, Information Risk. RIWAYAT PEKERJAAN Tanggal 2001 – Until Now

Keterangan Manager Internal Audit.