Sistem Manajemen dan Penggajian

" Sistem Manajemen dan Penggajian "

Bab I

Pendahuluan

1.1 Latar Belakang

Sejalan dengan meningkatnya perkembangan ekonomi dalam segala bidang, maka sudah sewajarnya jika perusahaan dan instansi baik milik pemerintah maupun swasta mengalami peningkatan disetiap sector. Dengan adanya peningkatan tersebut perusahaan membutuhkan tenaga kerja yang disebut dengan karyawan, yang ditugaskan perusahaan untuk melaksanakan kegiatan operasional pada perusahaan tersebut. Keuntungan yang diperoleh perusahaan apabila menerapkan tekhnologi informasi secara keseluruhan dalam hal pengolahan data gaji karyawan akan menciptakan efisiensi kerja, dan semua kesalahan dalam pemberian informasi dan laporan akan dapat diminimalkan / dikurangi. Pada pengelolaan penggajian sangat membutuhkan adanya sebuah sistem yang mampu menyatukan seluruh komponen pendukung dari penggajian karyawan. Permasalahan ini sangat tidak efisien apabila dalam proses pengolahannya masih menggunakan proses komputerisasi secara sederhana. Program berbasis database diperlukan karena data-data pendukung penggajian karyawan mempunyai hubungan satu sama lain dan untuk mencegah adanya redudansi data atau duplikasi data. Kendala yang biasanya terjadi adalah permasalahan pada data penggajian karyawan yang tidak rapi sehingga dapat mengakibatkan data-data penggajian karyawan hilang, yang mengakibatkan pencarian data sangat lambat karena data semakin hari semakin banyak dan ketidakmampuan sumber daya manusia juga tempat penyimpanan data pada bagian keuangan dalam mengolah data-data penggajian karyawan secara baik. Setelah mengetahui permasalahan yang ada pada bagian keuangan mengenai penggajian karyawan, maka perlu adanya pembaruan pada sistem pengolahan data gaji karyawan yang dibangun dengan menggunakan software dan database yang tangguh dalam merealisasi program ini. Maka dari itu penulis tertarik untuk melakukan penelitian dengan judul “Sistem Manajemen dan Penggajian”.

1.2 Perumusan Masalah

Berdasarkan latar belakang masalah tersebut di atas, maka penulis merumuskan masalah yaitu : Bagaimana memanajemen keuangan dan penggajian karyawan suatu perusahaan?

1.3 Maksud dan Tujuan

1.3.1 Maksud

Maksud dari penulisan laporan kerja praktek ini yaitu untuk memanajemen keuangan dan penggajian karyawan pada suatu perusahaan. Dimana sistem tersebut digunakan untuk membantu dalam penyelesaian masalah keuangan serta diharapkan dapat meringankan pendataan saat penggajian dan lembur sehingga prosesnya dapat dilakukan secara cepat, tepat dan akurat.

1.3.2 Tujuan

Tujuan pembuatan laporan kerja praktek ini adalah untuk memanajemen keuangan pada penggajian karyawan pada suatu perusahaan agar memudahkan proses pendataannya secara cepat,tepat, dan akurat

1.4 Batasan Masalah

Batasan masalah yang digunakan dalam sebuah pembahasan bertujuan agar dalam pembahasannya lebih terarah dan sesuai dengan tujuan yang akan dicapai. Adapun batasan masalah dalam laporan kerja praktek ini adalah :

1. Pembuatan sistem penggajian ini hanya sebatas untuk mendata gaji karyawan serta mengefektifkan sistem keuangan gaji dan lembur

2. Memudahkan agar karyawan dapat dengan jelas mengetahui berapa jumlah hasil lemburnya

3. Perancangan sistem ini meliputi penggajian, penghitungan lembur, dan rincian gaji yang di dapat.

1.5 Metode Penelitian

Penelitian sebagai bahan laporan kerja praktek ini dilakukan dengan menggunakan penelitian deskriptif yaitu metode penelitian yang bertujuan menggambarkan secara sistematis dan akurat mengenai data-data yang ada dengan cara mengumpulkan dan mengklasifikasikan data yang diperoleh kemudian dianalisis dengan teori yang dipelajari.

Metode penelitian yang dilakukan adalah sebagai berikut :

1. Metode Penelitian Deskriptif

Dalam metode penelitian deskriptif ini penulis melakukan penelitian secara langsung kepada pihak yang terkait. Adapun teknik pengumpulan data yang dilakukan meliputi a. Observasi

Pengumpulan data dilakukan dengan melakukan observasi partisipasi, yaitu peneliti terlibat langsung di dalam objek yang diteliti.

b. Studi Literatur

Pengumpulan data yang bersumber pada literatur, buku serta tulisan- tulisan yang terkait dengan objek penelitian.

2. Metode Pengembangan Perangkat Lunak

Metode pengembangan perangkat lunak yang digunakan dalam pengembangan sistem ini sesuai dengan model proses waterfall. Model waterfall merupakan model klasik sederhana dengan aliran sistem yang linier. Output dari setiap tahap merupakan input bagi tahap berikutnya. Adapun langkah-langkah penelitian berdasarkan model tersebut adalah :

a a. Analisis (Analysis)

Menganalisa data yang telah dikumpulkan untuk dijadikan bahan acuan yang akan digunakan dalam pengembangan sistem.

b b. Perancangan (Design)

Merancang simulasi sistem sebagai gambaran dari pengembangan sistem.

c c. Implementasi (Implementation)

Mengimplementasikan simulasi sistem tersebut untuk menghasilkan kesimpulan.

d d. Pengujian (Test)

Menguji simulasi apakah telah memenuhi tujuan yang ingin dicapai.

Bab II

Pembahasan

2.1 Sekilas tentang PHP MyAdmin

PHP adalah bahasa pemrograman script server-side yang didesain untuk pengembangan web. Selain itu, PHP juga bisa digunakan sebagai bahasa pemrograman umum. PHP disebut bahasa pemrograman server side karena PHP diproses pada komputer server. Hal ini berbeda dibandingkan dengan bahasa pemrograman client-side seperti JavaScript yang diproses pada web browser (client).

Saat ini PHP adalah singkatan dari PHP: Hypertext Preprocessor, sebuah kepanjangan rekursif, yakni permainan kata dimana kepanjangannya terdiri dari singkatan itu sendiri: PHP: Hypertext Preprocessor. PHP dapat digunakan dengan gratis (free) dan bersifat Open Source. PHP dirilis dalam lisensi PHP License, sedikit berbeda dengan lisensi GNU General Public License (GPL) yang biasa digunakan untuk proyek Open Source.

Fungsi PHP Dalam Pemrograman Web

Untuk membuat halaman web, sebenarnya PHP bukanlah bahasa pemrograman yang wajib digunakan. Kita bisa saja membuat website hanya menggunakan HTML saja. Web yang dihasilkan dengan HTML (dan CSS) ini dikenal dengan website statis, dimana konten dan halaman web bersifat tetap.

Sebagai perbandingan, website dinamis yang bisa dibuat menggunakan PHP adalah situs web yang bisa menyesuaikan tampilan konten tergantung situasi. Website dinamis juga bisa menyimpan data ke dalam database, membuat halaman yang berubah-ubah sesuai input dari user, memproses form, dll.

2.2 Tampilan Sistem Manajemen dan Penggajian

Tampilan Awal

Saat pertama masuk

Tampilan untuk Pegawai

Tampilan Rincian Gaji

Tampilan Pendapatan

Menambahkan data pegawai

Mengupdate rincian gaji

Mengubah Uang Lembur

Mengubah Gaji

Tampilan Logout

Bab III

Kesimpulan

Kesimpulannya adalah dapat mengurangi tingkat kesalahan pemahaman informasi penggajian, memudahkan dalam pembuatan informasi yang dibutuhkan diantaranya laporan pegawai, laporan penggajian dan slip gaji secara cepat,tepat, dan akurat.

Saran

Agar kedepannya peningkatan sumber daya manusia yang dapat mengelola data dengan komputer, untuk hal ini maka diperlukan pelatihan khusus pada karyawan yang diserahi tugas mengolah data, para pengelola sistem informasi harus selalu menjaga kesinambungan akan prosedur kerjanya dan peningkatan keamanan baik dari segi script program maupun server penyimpanan data.

Source Code

Add_deductions

<?php

require("db.php");

@$id = $_POST['deduction_id'];

@$philhealth = $_POST['philhealth'];

@$bir = $_POST['bir'];

@$gsis = $_POST['gsis'];

@$love = $_POST['pag_ibig'];

@$loans = $_POST['loans'];

$sql = mysql_query("UPDATE deductions SET bir='$bir', gsis='$gsis', pag_ibig='$love', loans='$loans', philhealth='$philhealth' WHERE deduction_id='1'");

if($sql)

{

alert('Deductions successfully updated...');

window.location.href='home_deductions.php';

</script>

<?php

}

else {

echo "Not Successfull!";

}

Add_employee

<?php

$conn = mysql_connect('localhost', 'root', '');

if (!$conn)

{

die("Database Connection Failed" . mysql_error());

}

$select_db = mysql_select_db('payroll');

if (!$select_db)

{

die("Database Selection Failed" . mysql_error());

}

if(isset($_POST['submit'])!="")

{

$fname = $_POST['fname'];

$lname = $_POST['lname'];

$gender = $_POST['gender'];

$type = $_POST['emp_type'];

$division = $_POST['division'];

$sql = mysql_query("INSERT into employee(fname, lname, gender, emp_type, division)VALUES('$lname','$fname','$gender', '$type', '$division')");

if($sql)

{

alert('Employee had been successfully added.');

window.location.href='home_employee.php?page=emp_list';

</script>

<?php

}

else

{

alert('Invalid.');

window.location.href='index.php';

</script>

<?php

}

Add_overtime

<?php

require("db.php");

@$id = $_POST['ot_id'];

@$overtime = $_POST['rate'];

$sql = mysql_query("UPDATE overtime SET rate='$overtime' WHERE ot_id='1'");

if($sql)

{

alert('Overtime rate per hour successfully changed...');

window.location.href='home_salary.php';

</script>

<?php

}

else {

echo "Not Successfull!";

}

auth

<?php

session_start();

if(!isset($_SESSION["username"]))

{

header("Location: login.php");

exit();

}

<?php

$connection = mysql_connect('localhost', 'root', '');

if (!$connection)

{

die("Database Connection Failed" . mysql_error());

}

$select_db = mysql_select_db('payroll');

if (!$select_db)

{

die("Database Selection Failed" . mysql_error());

}

delete

<?php

require('db.php');

$id=$_GET['emp_id'];

$query = "DELETE FROM employee WHERE emp_id=$id";

$result = mysql_query($query) or die ( mysql_error());

header("Location: home_employee.php");

fpdf

<?php

/*******************************************************************************

* FPDF *

* *

* Version: 1.81 *

* Date: 2015-12-20 *

* Author: Olivier PLATHEY *

*******************************************************************************/

define('FPDF_VERSION','1.81');

class FPDF

{

protected $page; // current page number

protected $n; // current object number

protected $offsets; // array of object offsets

protected $buffer; // buffer holding in-memory PDF

protected $pages; // array containing pages

protected $state; // current document state

protected $compress; // compression flag

protected $k; // scale factor (number of points in user unit)

protected $DefOrientation; // default orientation

protected $CurOrientation; // current orientation

protected $StdPageSizes; // standard page sizes

protected $DefPageSize; // default page size

protected $CurPageSize; // current page size

protected $CurRotation; // current page rotation

protected $PageInfo; // page-related data

protected $wPt, $hPt; // dimensions of current page in points

protected $w, $h; // dimensions of current page in user unit

protected $lMargin; // left margin

protected $tMargin; // top margin

protected $rMargin; // right margin

protected $bMargin; // page break margin

protected $cMargin; // cell margin

protected $x, $y; // current position in user unit

protected $lasth; // height of last printed cell

protected $LineWidth; // line width in user unit

protected $fontpath; // path containing fonts

protected $CoreFonts; // array of core font names

protected $fonts; // array of used fonts

protected $FontFiles; // array of font files

protected $encodings; // array of encodings

protected $cmaps; // array of ToUnicode CMaps

protected $FontFamily; // current font family

protected $FontStyle; // current font style

protected $underline; // underlining flag

protected $CurrentFont; // current font info

protected $FontSizePt; // current font size in points

protected $FontSize; // current font size in user unit

protected $DrawColor; // commands for drawing color

protected $FillColor; // commands for filling color

protected $TextColor; // commands for text color

protected $ColorFlag; // indicates whether fill and text colors are different

protected $WithAlpha; // indicates whether alpha channel is used

protected $ws; // word spacing

protected $images; // array of used images

protected $PageLinks; // array of links in pages

protected $links; // array of internal links

protected $AutoPageBreak; // automatic page breaking

protected $PageBreakTrigger; // threshold used to trigger page breaks

protected $InHeader; // flag set when processing header

protected $InFooter; // flag set when processing footer

protected $AliasNbPages; // alias for total number of pages

protected $ZoomMode; // zoom display mode

protected $LayoutMode; // layout display mode

protected $metadata; // document properties

protected $PDFVersion; // PDF version number

/*******************************************************************************

* Public methods *

*******************************************************************************/

function __construct($orientation='P', $unit='mm', $size='A4')

{

// Some checks

$this->_dochecks();

// Initialization of properties

$this->state = 0;

$this->page = 0;

$this->n = 2;

$this->buffer = '';

$this->pages = array();

$this->PageInfo = array();

$this->fonts = array();

$this->FontFiles = array();

$this->encodings = array();

$this->cmaps = array();

$this->images = array();

$this->links = array();

$this->InHeader = false;

$this->InFooter = false;

$this->lasth = 0;

$this->FontFamily = '';

$this->FontStyle = '';

$this->FontSizePt = 12;

$this->underline = false;

$this->DrawColor = '0 G';

$this->FillColor = '0 g';

$this->TextColor = '0 g';

$this->ColorFlag = false;

$this->WithAlpha = false;

$this->ws = 0;

// Font path

if(defined('FPDF_FONTPATH'))

{

$this->fontpath = FPDF_FONTPATH;

if(substr($this->fontpath,-1)!='/' && substr($this->fontpath,-1)!='\\')

$this->fontpath .= '/';

}

elseif(is_dir(dirname(__FILE__).'/font'))

$this->fontpath = dirname(__FILE__).'/font/';

else

$this->fontpath = '';

// Core fonts

$this->CoreFonts = array('courier', 'helvetica', 'times', 'symbol', 'zapfdingbats');

// Scale factor

if($unit=='pt')

$this->k = 1;

elseif($unit=='mm')

$this->k = 72/25.4;

elseif($unit=='cm')

$this->k = 72/2.54;

elseif($unit=='in')

$this->k = 72;

else

$this->Error('Incorrect unit: '.$unit);

// Page sizes

$this->StdPageSizes = array('a3'=>array(841.89,1190.55), 'a4'=>array(595.28,841.89), 'a5'=>array(420.94,595.28),

'letter'=>array(612,792), 'legal'=>array(612,1008));

$size = $this->_getpagesize($size);

$this->DefPageSize = $size;

$this->CurPageSize = $size;

// Page orientation

$orientation = strtolower($orientation);

if($orientation=='p' || $orientation=='portrait')

{

$this->DefOrientation = 'P';

$this->w = $size[0];

$this->h = $size[1];

}

elseif($orientation=='l' || $orientation=='landscape')

{

$this->DefOrientation = 'L';

$this->w = $size[1];

$this->h = $size[0];

}

else

$this->Error('Incorrect orientation: '.$orientation);

$this->CurOrientation = $this->DefOrientation;

$this->wPt = $this->w*$this->k;

$this->hPt = $this->h*$this->k;

// Page rotation

$this->CurRotation = 0;

// Page margins (1 cm)

$margin = 28.35/$this->k;

$this->SetMargins($margin,$margin);

// Interior cell margin (1 mm)

$this->cMargin = $margin/10;

// Line width (0.2 mm)

$this->LineWidth = .567/$this->k;

// Automatic page break

$this->SetAutoPageBreak(true,2*$margin);

// Default display mode

$this->SetDisplayMode('default');

// Enable compression

$this->SetCompression(true);

// Set default PDF version number

$this->PDFVersion = '1.3';

}

function SetMargins($left, $top, $right=null)

{

// Set left, top and right margins

$this->lMargin = $left;

$this->tMargin = $top;

if($right===null)

$right = $left;

$this->rMargin = $right;

}

function SetLeftMargin($margin)

{

// Set left margin

$this->lMargin = $margin;

if($this->page>0 && $this->x<$margin)

$this->x = $margin;

}

function SetTopMargin($margin)

{

// Set top margin

$this->tMargin = $margin;

}

function SetRightMargin($margin)

{

// Set right margin

$this->rMargin = $margin;

}

function SetAutoPageBreak($auto, $margin=0)

{

// Set auto page break mode and triggering margin

$this->AutoPageBreak = $auto;

$this->bMargin = $margin;

$this->PageBreakTrigger = $this->h-$margin;

}

function SetDisplayMode($zoom, $layout='default')

{

// Set display mode in viewer

if($zoom=='fullpage' || $zoom=='fullwidth' || $zoom=='real' || $zoom=='default' || !is_string($zoom))

$this->ZoomMode = $zoom;

else

$this->Error('Incorrect zoom display mode: '.$zoom);

if($layout=='single' || $layout=='continuous' || $layout=='two' || $layout=='default')

$this->LayoutMode = $layout;

else

$this->Error('Incorrect layout display mode: '.$layout);

}

function SetCompression($compress)

{

// Set page compression

if(function_exists('gzcompress'))

$this->compress = $compress;

else

$this->compress = false;

}

function SetTitle($title, $isUTF8=false)

{

// Title of document

$this->metadata['Title'] = $isUTF8 ? $title : utf8_encode($title);

}

function SetAuthor($author, $isUTF8=false)

{

// Author of document

$this->metadata['Author'] = $isUTF8 ? $author : utf8_encode($author);

}

function SetSubject($subject, $isUTF8=false)

{

// Subject of document

$this->metadata['Subject'] = $isUTF8 ? $subject : utf8_encode($subject);

}

function SetKeywords($keywords, $isUTF8=false)

{

// Keywords of document

$this->metadata['Keywords'] = $isUTF8 ? $keywords : utf8_encode($keywords);

}

function SetCreator($creator, $isUTF8=false)

{

// Creator of document

$this->metadata['Creator'] = $isUTF8 ? $creator : utf8_encode($creator);

}

function AliasNbPages($alias='{nb}')

{

// Define an alias for total number of pages

$this->AliasNbPages = $alias;

}

function Error($msg)

{

// Fatal error

throw new Exception('FPDF error: '.$msg);

}

function Close()

{

// Terminate document

if($this->state==3)

return;

if($this->page==0)

$this->AddPage();

// Page footer

$this->InFooter = true;

$this->Footer();

$this->InFooter = false;

// Close page

$this->_endpage();

// Close document

$this->_enddoc();

}

function AddPage($orientation='', $size='', $rotation=0)

{

// Start a new page

if($this->state==3)

$this->Error('The document is closed');

$family = $this->FontFamily;

$style = $this->FontStyle.($this->underline ? 'U' : '');

$fontsize = $this->FontSizePt;

$lw = $this->LineWidth;

$dc = $this->DrawColor;

$fc = $this->FillColor;

$tc = $this->TextColor;

$cf = $this->ColorFlag;

if($this->page>0)

{

// Page footer

$this->InFooter = true;

$this->Footer();

$this->InFooter = false;

// Close page

$this->_endpage();

}

// Start new page

$this->_beginpage($orientation,$size,$rotation);

// Set line cap style to square

$this->_out('2 J');

// Set line width

$this->LineWidth = $lw;

$this->_out(sprintf('%.2F w',$lw*$this->k));

// Set font

if($family)

$this->SetFont($family,$style,$fontsize);

// Set colors

$this->DrawColor = $dc;

if($dc!='0 G')

$this->_out($dc);

$this->FillColor = $fc;

if($fc!='0 g')

$this->_out($fc);

$this->TextColor = $tc;

$this->ColorFlag = $cf;

// Page header

$this->InHeader = true;

$this->Header();

$this->InHeader = false;

// Restore line width

if($this->LineWidth!=$lw)

{

$this->LineWidth = $lw;

$this->_out(sprintf('%.2F w',$lw*$this->k));

}

// Restore font

if($family)

$this->SetFont($family,$style,$fontsize);

// Restore colors

if($this->DrawColor!=$dc)

{

$this->DrawColor = $dc;

$this->_out($dc);

}

if($this->FillColor!=$fc)

{

$this->FillColor = $fc;

$this->_out($fc);

}

$this->TextColor = $tc;

$this->ColorFlag = $cf;

}

function Header()

{

// To be implemented in your own inherited class

}

function Footer()

{

// To be implemented in your own inherited class

}

function PageNo()

{

// Get current page number

return $this->page;

}

function SetDrawColor($r, $g=null, $b=null)

{

// Set color for all stroking operations

if(($r==0 && $g==0 && $b==0) || $g===null)

$this->DrawColor = sprintf('%.3F G',$r/255);

else

$this->DrawColor = sprintf('%.3F %.3F %.3F RG',$r/255,$g/255,$b/255);

if($this->page>0)

$this->_out($this->DrawColor);

}

function SetFillColor($r, $g=null, $b=null)

{

// Set color for all filling operations

if(($r==0 && $g==0 && $b==0) || $g===null)

$this->FillColor = sprintf('%.3F g',$r/255);

else

$this->FillColor = sprintf('%.3F %.3F %.3F rg',$r/255,$g/255,$b/255);

$this->ColorFlag = ($this->FillColor!=$this->TextColor);

if($this->page>0)

$this->_out($this->FillColor);

}

function SetTextColor($r, $g=null, $b=null)

{

// Set color for text

if(($r==0 && $g==0 && $b==0) || $g===null)

$this->TextColor = sprintf('%.3F g',$r/255);

else

$this->TextColor = sprintf('%.3F %.3F %.3F rg',$r/255,$g/255,$b/255);

$this->ColorFlag = ($this->FillColor!=$this->TextColor);

}

function GetStringWidth($s)

{

// Get width of a string in the current font

$s = (string)$s;

$cw = &$this->CurrentFont['cw'];

$w = 0;

$l = strlen($s);

for($i=0;$i<$l;$i++)

$w += $cw[$s[$i]];

return $w*$this->FontSize/1000;

}

function SetLineWidth($width)

{

// Set line width

$this->LineWidth = $width;

if($this->page>0)

$this->_out(sprintf('%.2F w',$width*$this->k));

}

function Line($x1, $y1, $x2, $y2)

{

// Draw a line

$this->_out(sprintf('%.2F %.2F m %.2F %.2F l S',$x1*$this->k,($this->h-$y1)*$this->k,$x2*$this->k,($this->h-$y2)*$this->k));

}

function Rect($x, $y, $w, $h, $style='')

{

// Draw a rectangle

if($style=='F')

$op = 'f';

elseif($style=='FD' || $style=='DF')

$op = 'B';

else

$op = 'S';

$this->_out(sprintf('%.2F %.2F %.2F %.2F re %s',$x*$this->k,($this->h-$y)*$this->k,$w*$this->k,-$h*$this->k,$op));

}

function AddFont($family, $style='', $file='')

{

// Add a TrueType, OpenType or Type1 font

$family = strtolower($family);

if($file=='')

$file = str_replace(' ','',$family).strtolower($style).'.php';

$style = strtoupper($style);

if($style=='IB')

$style = 'BI';

$fontkey = $family.$style;

if(isset($this->fonts[$fontkey]))

return;

$info = $this->_loadfont($file);

$info['i'] = count($this->fonts)+1;

if(!empty($info['file']))

{

// Embedded font

if($info['type']=='TrueType')

$this->FontFiles[$info['file']] = array('length1'=>$info['originalsize']);

else

$this->FontFiles[$info['file']] = array('length1'=>$info['size1'], 'length2'=>$info['size2']);

}

$this->fonts[$fontkey] = $info;

}

function SetFont($family, $style='', $size=0)

{

// Select a font; size given in points

if($family=='')

$family = $this->FontFamily;

else

$family = strtolower($family);

$style = strtoupper($style);

if(strpos($style,'U')!==false)

{

$this->underline = true;

$style = str_replace('U','',$style);

}

else

$this->underline = false;

if($style=='IB')

$style = 'BI';

if($size==0)

$size = $this->FontSizePt;

// Test if font is already selected

if($this->FontFamily==$family && $this->FontStyle==$style && $this->FontSizePt==$size)

return;

// Test if font is already loaded

$fontkey = $family.$style;

if(!isset($this->fonts[$fontkey]))

{

// Test if one of the core fonts

if($family=='arial')

$family = 'helvetica';

if(in_array($family,$this->CoreFonts))

{

if($family=='symbol' || $family=='zapfdingbats')

$style = '';

$fontkey = $family.$style;

if(!isset($this->fonts[$fontkey]))

$this->AddFont($family,$style);

}

else

$this->Error('Undefined font: '.$family.' '.$style);

}

// Select it

$this->FontFamily = $family;

$this->FontStyle = $style;

$this->FontSizePt = $size;

$this->FontSize = $size/$this->k;

$this->CurrentFont = &$this->fonts[$fontkey];

if($this->page>0)

$this->_out(sprintf('BT /F%d %.2F Tf ET',$this->CurrentFont['i'],$this->FontSizePt));

}

function SetFontSize($size)

{

// Set font size in points

if($this->FontSizePt==$size)

return;

$this->FontSizePt = $size;

$this->FontSize = $size/$this->k;

if($this->page>0)

$this->_out(sprintf('BT /F%d %.2F Tf ET',$this->CurrentFont['i'],$this->FontSizePt));

}

function AddLink()

{

// Create a new internal link

$n = count($this->links)+1;

$this->links[$n] = array(0, 0);

return $n;

}

function SetLink($link, $y=0, $page=-1)

{

// Set destination of internal link

if($y==-1)

$y = $this->y;

if($page==-1)

$page = $this->page;

$this->links[$link] = array($page, $y);

}

function Link($x, $y, $w, $h, $link)

{

// Put a link on the page

$this->PageLinks[$this->page][] = array($x*$this->k, $this->hPt-$y*$this->k, $w*$this->k, $h*$this->k, $link);

}

function Text($x, $y, $txt)

{

// Output a string

if(!isset($this->CurrentFont))

$this->Error('No font has been set');

$s = sprintf('BT %.2F %.2F Td (%s) Tj ET',$x*$this->k,($this->h-$y)*$this->k,$this->_escape($txt));

if($this->underline && $txt!='')

$s .= ' '.$this->_dounderline($x,$y,$txt);

if($this->ColorFlag)

$s = 'q '.$this->TextColor.' '.$s.' Q';

$this->_out($s);

}

function AcceptPageBreak()

{

// Accept automatic page break or not

return $this->AutoPageBreak;

}

function Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=false, $link='')

{

// Output a cell

$k = $this->k;

if($this->y+$h>$this->PageBreakTrigger && !$this->InHeader && !$this->InFooter && $this->AcceptPageBreak())

{

// Automatic page break

$x = $this->x;

$ws = $this->ws;

if($ws>0)

{

$this->ws = 0;

$this->_out('0 Tw');

}

$this->AddPage($this->CurOrientation,$this->CurPageSize,$this->CurRotation);

$this->x = $x;

if($ws>0)

{

$this->ws = $ws;

$this->_out(sprintf('%.3F Tw',$ws*$k));

}

if($w==0)

$w = $this->w-$this->rMargin-$this->x;

$s = '';

if($fill || $border==1)

{

if($fill)

$op = ($border==1) ? 'B' : 'f';

else

$op = 'S';

$s = sprintf('%.2F %.2F %.2F %.2F re %s ',$this->x*$k,($this->h-$this->y)*$k,$w*$k,-$h*$k,$op);

}

if(is_string($border))

{

$x = $this->x;

$y = $this->y;

if(strpos($border,'L')!==false)

$s .= sprintf('%.2F %.2F m %.2F %.2F l S ',$x*$k,($this->h-$y)*$k,$x*$k,($this->h-($y+$h))*$k);

if(strpos($border,'T')!==false)

$s .= sprintf('%.2F %.2F m %.2F %.2F l S ',$x*$k,($this->h-$y)*$k,($x+$w)*$k,($this->h-$y)*$k);

if(strpos($border,'R')!==false)

$s .= sprintf('%.2F %.2F m %.2F %.2F l S ',($x+$w)*$k,($this->h-$y)*$k,($x+$w)*$k,($this->h-($y+$h))*$k);

if(strpos($border,'B')!==false)

$s .= sprintf('%.2F %.2F m %.2F %.2F l S ',$x*$k,($this->h-($y+$h))*$k,($x+$w)*$k,($this->h-($y+$h))*$k);

}

if($txt!=='')

{

if(!isset($this->CurrentFont))

$this->Error('No font has been set');

if($align=='R')

$dx = $w-$this->cMargin-$this->GetStringWidth($txt);

elseif($align=='C')

$dx = ($w-$this->GetStringWidth($txt))/2;

else

$dx = $this->cMargin;

if($this->ColorFlag)

$s .= 'q '.$this->TextColor.' ';

$s .= sprintf('BT %.2F %.2F Td (%s) Tj ET',($this->x+$dx)*$k,($this->h-($this->y+.5*$h+.3*$this->FontSize))*$k,$this->_escape($txt));

if($this->underline)

$s .= ' '.$this->_dounderline($this->x+$dx,$this->y+.5*$h+.3*$this->FontSize,$txt);

if($this->ColorFlag)

$s .= ' Q';

if($link)

$this->Link($this->x+$dx,$this->y+.5*$h-.5*$this->FontSize,$this->GetStringWidth($txt),$this->FontSize,$link);

}

if($s)

$this->_out($s);

$this->lasth = $h;

if($ln>0)

{

// Go to next line

$this->y += $h;

if($ln==1)

$this->x = $this->lMargin;

}

else

$this->x += $w;

}

function MultiCell($w, $h, $txt, $border=0, $align='J', $fill=false)

{

// Output text with automatic or explicit line breaks

if(!isset($this->CurrentFont))

$this->Error('No font has been set');

$cw = &$this->CurrentFont['cw'];

if($w==0)

$w = $this->w-$this->rMargin-$this->x;

$wmax = ($w-2*$this->cMargin)*1000/$this->FontSize;

$s = str_replace("\r",'',$txt);

$nb = strlen($s);

if($nb>0 && $s[$nb-1]=="\n")

$nb--;

$b = 0;

if($border)

{

if($border==1)

{

$border = 'LTRB';

$b = 'LRT';

$b2 = 'LR';

}

else

{

$b2 = '';

if(strpos($border,'L')!==false)

$b2 .= 'L';

if(strpos($border,'R')!==false)

$b2 .= 'R';

$b = (strpos($border,'T')!==false) ? $b2.'T' : $b2;

}

$sep = -1;

$i = 0;

$j = 0;

$l = 0;

$ns = 0;

$nl = 1;

while($i<$nb)

{

// Get next character

$c = $s[$i];

if($c=="\n")

{

// Explicit line break

if($this->ws>0)

{

$this->ws = 0;

$this->_out('0 Tw');

}

$this->Cell($w,$h,substr($s,$j,$i-$j),$b,2,$align,$fill);

$i++;

$sep = -1;

$j = $i;

$l = 0;

$ns = 0;

$nl++;

if($border && $nl==2)

$b = $b2;

continue;

}

if($c==' ')

{

$sep = $i;

$ls = $l;

$ns++;

}

$l += $cw[$c];

if($l>$wmax)

{

// Automatic line break

if($sep==-1)

{

if($i==$j)

$i++;

if($this->ws>0)

{

$this->ws = 0;

$this->_out('0 Tw');

}

$this->Cell($w,$h,substr($s,$j,$i-$j),$b,2,$align,$fill);

}

else

{

if($align=='J')

{

$this->ws = ($ns>1) ? ($wmax-$ls)/1000*$this->FontSize/($ns-1) : 0;

$this->_out(sprintf('%.3F Tw',$this->ws*$this->k));

}

$this->Cell($w,$h,substr($s,$j,$sep-$j),$b,2,$align,$fill);

$i = $sep+1;

}

$sep = -1;

$j = $i;

$l = 0;

$ns = 0;

$nl++;

if($border && $nl==2)

$b = $b2;

}

else

$i++;

}

// Last chunk

if($this->ws>0)

{

$this->ws = 0;

$this->_out('0 Tw');

}

if($border && strpos($border,'B')!==false)

$b .= 'B';

$this->Cell($w,$h,substr($s,$j,$i-$j),$b,2,$align,$fill);

$this->x = $this->lMargin;

}

function Write($h, $txt, $link='')

{

// Output text in flowing mode

if(!isset($this->CurrentFont))

$this->Error('No font has been set');

$cw = &$this->CurrentFont['cw'];

$w = $this->w-$this->rMargin-$this->x;

$wmax = ($w-2*$this->cMargin)*1000/$this->FontSize;

$s = str_replace("\r",'',$txt);

$nb = strlen($s);

$sep = -1;

$i = 0;

$j = 0;

$l = 0;

$nl = 1;

while($i<$nb)

{

// Get next character

$c = $s[$i];

if($c=="\n")

{

// Explicit line break

$this->Cell($w,$h,substr($s,$j,$i-$j),0,2,'',false,$link);

$i++;

$sep = -1;

$j = $i;

$l = 0;

if($nl==1)

{

$this->x = $this->lMargin;

$w = $this->w-$this->rMargin-$this->x;

$wmax = ($w-2*$this->cMargin)*1000/$this->FontSize;

}

$nl++;

continue;

}

if($c==' ')

$sep = $i;

$l += $cw[$c];

if($l>$wmax)

{

// Automatic line break

if($sep==-1)

{

if($this->x>$this->lMargin)

{

// Move to next line

$this->x = $this->lMargin;

$this->y += $h;

$w = $this->w-$this->rMargin-$this->x;

$wmax = ($w-2*$this->cMargin)*1000/$this->FontSize;

$i++;

$nl++;

continue;

}

if($i==$j)

$i++;

$this->Cell($w,$h,substr($s,$j,$i-$j),0,2,'',false,$link);

}

else

{

$this->Cell($w,$h,substr($s,$j,$sep-$j),0,2,'',false,$link);

$i = $sep+1;

}

$sep = -1;

$j = $i;

$l = 0;

if($nl==1)

{

$this->x = $this->lMargin;

$w = $this->w-$this->rMargin-$this->x;

$wmax = ($w-2*$this->cMargin)*1000/$this->FontSize;

}

$nl++;

}

else

$i++;

}

// Last chunk

if($i!=$j)

$this->Cell($l/1000*$this->FontSize,$h,substr($s,$j),0,0,'',false,$link);

}

function Ln($h=null)

{

// Line feed; default value is the last cell height

$this->x = $this->lMargin;

if($h===null)

$this->y += $this->lasth;

else

$this->y += $h;

}

function Image($file, $x=null, $y=null, $w=0, $h=0, $type='', $link='')

{

// Put an image on the page

if($file=='')

$this->Error('Image file name is empty');

if(!isset($this->images[$file]))

{

// First use of this image, get info

if($type=='')

{

$pos = strrpos($file,'.');

if(!$pos)

$this->Error('Image file has no extension and no type was specified: '.$file);

$type = substr($file,$pos+1);

}

$type = strtolower($type);

if($type=='jpeg')

$type = 'jpg';

$mtd = '_parse'.$type;

if(!method_exists($this,$mtd))

$this->Error('Unsupported image type: '.$type);

$info = $this->$mtd($file);

$info['i'] = count($this->images)+1;

$this->images[$file] = $info;

}

else

$info = $this->images[$file];

// Automatic width and height calculation if needed

if($w==0 && $h==0)

{

// Put image at 96 dpi

$w = -96;

$h = -96;

}

if($w<0)

$w = -$info['w']*72/$w/$this->k;

if($h<0)

$h = -$info['h']*72/$h/$this->k;

if($w==0)

$w = $h*$info['w']/$info['h'];

if($h==0)

$h = $w*$info['h']/$info['w'];

// Flowing mode

if($y===null)

{

if($this->y+$h>$this->PageBreakTrigger && !$this->InHeader && !$this->InFooter && $this->AcceptPageBreak())

{

// Automatic page break

$x2 = $this->x;

$this->AddPage($this->CurOrientation,$this->CurPageSize,$this->CurRotation);

$this->x = $x2;

}

$y = $this->y;

$this->y += $h;

}

if($x===null)

$x = $this->x;

$this->_out(sprintf('q %.2F 0 0 %.2F %.2F %.2F cm /I%d Do Q',$w*$this->k,$h*$this->k,$x*$this->k,($this->h-($y+$h))*$this->k,$info['i']));

if($link)

$this->Link($x,$y,$w,$h,$link);

}

function GetPageWidth()

{

// Get current page width

return $this->w;

}

function GetPageHeight()

{

// Get current page height

return $this->h;

}

function GetX()

{

// Get x position

return $this->x;

}

function SetX($x)

{

// Set x position

if($x>=0)

$this->x = $x;

else

$this->x = $this->w+$x;

}

function GetY()

{

// Get y position

return $this->y;

}

function SetY($y, $resetX=true)

{

// Set y position and optionally reset x

if($y>=0)

$this->y = $y;

else

$this->y = $this->h+$y;

if($resetX)

$this->x = $this->lMargin;

}

function SetXY($x, $y)

{

// Set x and y positions

$this->SetX($x);

$this->SetY($y,false);

}

function Output($dest='', $name='', $isUTF8=false)

{

// Output PDF to some destination

$this->Close();

if(strlen($name)==1 && strlen($dest)!=1)

{

// Fix parameter order

$tmp = $dest;

$dest = $name;

$name = $tmp;

}

if($dest=='')

$dest = 'I';

if($name=='')

$name = 'doc.pdf';

switch(strtoupper($dest))

{

case 'I':

// Send to standard output

$this->_checkoutput();

if(PHP_SAPI!='cli')

{

// We send to a browser

header('Content-Type: application/pdf');

header('Content-Disposition: inline; '.$this->_httpencode('filename',$name,$isUTF8));

header('Cache-Control: private, max-age=0, must-revalidate');

header('Pragma: public');

}

echo $this->buffer;

break;

case 'D':

// Download file

$this->_checkoutput();

header('Content-Type: application/x-download');

header('Content-Disposition: attachment; '.$this->_httpencode('filename',$name,$isUTF8));

header('Cache-Control: private, max-age=0, must-revalidate');

header('Pragma: public');

echo $this->buffer;

break;

case 'F':

// Save to local file

if(!file_put_contents($name,$this->buffer))

$this->Error('Unable to create output file: '.$name);

break;

case 'S':

// Return as a string

return $this->buffer;

default:

$this->Error('Incorrect output destination: '.$dest);

}

return '';

}

/*******************************************************************************

* Protected methods *

*******************************************************************************/

protected function _dochecks()

{

// Check mbstring overloading

if(ini_get('mbstring.func_overload') & 2)

$this->Error('mbstring overloading must be disabled');

// Ensure runtime magic quotes are disabled

if(get_magic_quotes_runtime())

@set_magic_quotes_runtime(0);

}

protected function _checkoutput()

{

if(PHP_SAPI!='cli')

{

if(headers_sent($file,$line))

$this->Error("Some data has already been output, can't send PDF file (output started at $file:$line)");

}

if(ob_get_length())

{

// The output buffer is not empty

if(preg_match('/^(\xEF\xBB\xBF)?\s*$/',ob_get_contents()))

{

// It contains only a UTF-8 BOM and/or whitespace, let's clean it

ob_clean();

}

else

$this->Error("Some data has already been output, can't send PDF file");

}

protected function _getpagesize($size)

{

if(is_string($size))

{

$size = strtolower($size);

if(!isset($this->StdPageSizes[$size]))

$this->Error('Unknown page size: '.$size);

$a = $this->StdPageSizes[$size];

return array($a[0]/$this->k, $a[1]/$this->k);

}

else

{

if($size[0]>$size[1])

return array($size[1], $size[0]);

else

return $size;

}

protected function _beginpage($orientation, $size, $rotation)

{

$this->page++;

$this->pages[$this->page] = '';

$this->state = 2;

$this->x = $this->lMargin;

$this->y = $this->tMargin;

$this->FontFamily = '';

// Check page size and orientation

if($orientation=='')

$orientation = $this->DefOrientation;

else

$orientation = strtoupper($orientation[0]);

if($size=='')

$size = $this->DefPageSize;

else

$size = $this->_getpagesize($size);

if($orientation!=$this->CurOrientation || $size[0]!=$this->CurPageSize[0] || $size[1]!=$this->CurPageSize[1])

{

// New size or orientation

if($orientation=='P')

{

$this->w = $size[0];

$this->h = $size[1];

}

else

{

$this->w = $size[1];

$this->h = $size[0];

}

$this->wPt = $this->w*$this->k;

$this->hPt = $this->h*$this->k;

$this->PageBreakTrigger = $this->h-$this->bMargin;

$this->CurOrientation = $orientation;

$this->CurPageSize = $size;

}

if($orientation!=$this->DefOrientation || $size[0]!=$this->DefPageSize[0] || $size[1]!=$this->DefPageSize[1])

$this->PageInfo[$this->page]['size'] = array($this->wPt, $this->hPt);

if($rotation!=0)

{

if($rotation%90!=0)

$this->Error('Incorrect rotation value: '.$rotation);

$this->CurRotation = $rotation;

$this->PageInfo[$this->page]['rotation'] = $rotation;

}

protected function _endpage()

{

$this->state = 1;

}

protected function _loadfont($font)

{

// Load a font definition file from the font directory

if(strpos($font,'/')!==false || strpos($font,"\\")!==false)

$this->Error('Incorrect font definition file name: '.$font);

include($this->fontpath.$font);

if(!isset($name))

$this->Error('Could not include font definition file');

if(isset($enc))

$enc = strtolower($enc);

if(!isset($subsetted))

$subsetted = false;

return get_defined_vars();

}

protected function _isascii($s)

{

// Test if string is ASCII

$nb = strlen($s);

for($i=0;$i<$nb;$i++)

{

if(ord($s[$i])>127)

return false;

}

return true;

}

protected function _httpencode($param, $value, $isUTF8)

{

// Encode HTTP header field parameter

if($this->_isascii($value))

return $param.'="'.$value.'"';

if(!$isUTF8)

$value = utf8_encode($value);

if(strpos($_SERVER['HTTP_USER_AGENT'],'MSIE')!==false)

return $param.'="'.rawurlencode($value).'"';

else

return $param."*=UTF-8''".rawurlencode($value);

}

protected function _UTF8toUTF16($s)

{

// Convert UTF-8 to UTF-16BE with BOM

$res = "\xFE\xFF";

$nb = strlen($s);

$i = 0;

while($i<$nb)

{

$c1 = ord($s[$i++]);

if($c1>=224)

{

// 3-byte character

$c2 = ord($s[$i++]);

$c3 = ord($s[$i++]);

$res .= chr((($c1 & 0x0F)<<4) + (($c2 & 0x3C)>>2));

$res .= chr((($c2 & 0x03)<<6) + ($c3 & 0x3F));

}

elseif($c1>=192)

{

// 2-byte character

$c2 = ord($s[$i++]);

$res .= chr(($c1 & 0x1C)>>2);

$res .= chr((($c1 & 0x03)<<6) + ($c2 & 0x3F));

}

else

{

// Single-byte character

$res .= "\0".chr($c1);

}

return $res;

}

protected function _escape($s)

{

// Escape special characters

if(strpos($s,'(')!==false || strpos($s,')')!==false || strpos($s,'\\')!==false || strpos($s,"\r")!==false)

return str_replace(array('\\','(',')',"\r"), array('\\\\','\$','\$','\\r'), $s);

else

return $s;

}

protected function _textstring($s)

{

// Format a text string

if(!$this->_isascii($s))

$s = $this->_UTF8toUTF16($s);

return '('.$this->_escape($s).')';

}

protected function _dounderline($x, $y, $txt)

{

// Underline text

$up = $this->CurrentFont['up'];

$ut = $this->CurrentFont['ut'];

$w = $this->GetStringWidth($txt)+$this->ws*substr_count($txt,' ');

return sprintf('%.2F %.2F %.2F %.2F re f',$x*$this->k,($this->h-($y-$up/1000*$this->FontSize))*$this->k,$w*$this->k,-$ut/1000*$this->FontSizePt);

}

protected function _parsejpg($file)

{

// Extract info from a JPEG file

$a = getimagesize($file);

if(!$a)

$this->Error('Missing or incorrect image file: '.$file);

if($a[2]!=2)

$this->Error('Not a JPEG file: '.$file);

if(!isset($a['channels']) || $a['channels']==3)

$colspace = 'DeviceRGB';

elseif($a['channels']==4)

$colspace = 'DeviceCMYK';

else

$colspace = 'DeviceGray';

$bpc = isset($a['bits']) ? $a['bits'] : 8;

$data = file_get_contents($file);

return array('w'=>$a[0], 'h'=>$a[1], 'cs'=>$colspace, 'bpc'=>$bpc, 'f'=>'DCTDecode', 'data'=>$data);

}

protected function _parsepng($file)

{

// Extract info from a PNG file

$f = fopen($file,'rb');

if(!$f)

$this->Error('Can\'t open image file: '.$file);

$info = $this->_parsepngstream($f,$file);

fclose($f);

return $info;

}

protected function _parsepngstream($f, $file)

{

// Check signature

if($this->_readstream($f,8)!=chr(137).'PNG'.chr(13).chr(10).chr(26).chr(10))

$this->Error('Not a PNG file: '.$file);

// Read header chunk

$this->_readstream($f,4);

if($this->_readstream($f,4)!='IHDR')

$this->Error('Incorrect PNG file: '.$file);

$w = $this->_readint($f);

$h = $this->_readint($f);

$bpc = ord($this->_readstream($f,1));

if($bpc>8)

$this->Error('16-bit depth not supported: '.$file);

$ct = ord($this->_readstream($f,1));

if($ct==0 || $ct==4)

$colspace = 'DeviceGray';

elseif($ct==2 || $ct==6)

$colspace = 'DeviceRGB';

elseif($ct==3)

$colspace = 'Indexed';

else

$this->Error('Unknown color type: '.$file);

if(ord($this->_readstream($f,1))!=0)

$this->Error('Unknown compression method: '.$file);

if(ord($this->_readstream($f,1))!=0)

$this->Error('Unknown filter method: '.$file);

if(ord($this->_readstream($f,1))!=0)

$this->Error('Interlacing not supported: '.$file);

$this->_readstream($f,4);

$dp = '/Predictor 15 /Colors '.($colspace=='DeviceRGB' ? 3 : 1).' /BitsPerComponent '.$bpc.' /Columns '.$w;

// Scan chunks looking for palette, transparency and image data

$pal = '';

$trns = '';

$data = '';

{

$n = $this->_readint($f);

$type = $this->_readstream($f,4);

if($type=='PLTE')

{

// Read palette

$pal = $this->_readstream($f,$n);

$this->_readstream($f,4);

}

elseif($type=='tRNS')

{

// Read transparency info

$t = $this->_readstream($f,$n);

if($ct==0)

$trns = array(ord(substr($t,1,1)));

elseif($ct==2)

$trns = array(ord(substr($t,1,1)), ord(substr($t,3,1)), ord(substr($t,5,1)));

else

{

$pos = strpos($t,chr(0));

if($pos!==false)

$trns = array($pos);

}

$this->_readstream($f,4);

}

elseif($type=='IDAT')

{

// Read image data block

$data .= $this->_readstream($f,$n);

$this->_readstream($f,4);

}

elseif($type=='IEND')

break;

else

$this->_readstream($f,$n+4);

}

while($n);

if($colspace=='Indexed' && empty($pal))

$this->Error('Missing palette in '.$file);

$info = array('w'=>$w, 'h'=>$h, 'cs'=>$colspace, 'bpc'=>$bpc, 'f'=>'FlateDecode', 'dp'=>$dp, 'pal'=>$pal, 'trns'=>$trns);

if($ct>=4)

{

// Extract alpha channel

if(!function_exists('gzuncompress'))

$this->Error('Zlib not available, can\'t handle alpha channel: '.$file);

$data = gzuncompress($data);

$color = '';

$alpha = '';

if($ct==4)

{

// Gray image

$len = 2*$w;

for($i=0;$i<$h;$i++)

{

$pos = (1+$len)*$i;

$color .= $data[$pos];

$alpha .= $data[$pos];

$line = substr($data,$pos+1,$len);

$color .= preg_replace('/(.)./s','$1',$line);

$alpha .= preg_replace('/.(.)/s','$1',$line);

}

else

{

// RGB image

$len = 4*$w;

for($i=0;$i<$h;$i++)

{

$pos = (1+$len)*$i;

$color .= $data[$pos];

$alpha .= $data[$pos];

$line = substr($data,$pos+1,$len);

$color .= preg_replace('/(.{3})./s','$1',$line);

$alpha .= preg_replace('/.{3}(.)/s','$1',$line);

}

unset($data);

$data = gzcompress($color);

$info['smask'] = gzcompress($alpha);

$this->WithAlpha = true;

if($this->PDFVersion<'1.4')

$this->PDFVersion = '1.4';

}

$info['data'] = $data;

return $info;

}

protected function _readstream($f, $n)

{

// Read n bytes from stream

$res = '';

while($n>0 && !feof($f))

{

$s = fread($f,$n);

if($s===false)

$this->Error('Error while reading stream');

$n -= strlen($s);

$res .= $s;

}

if($n>0)

$this->Error('Unexpected end of stream');

return $res;

}

protected function _readint($f)

{

// Read a 4-byte integer from stream

$a = unpack('Ni',$this->_readstream($f,4));

return $a['i'];

}

protected function _parsegif($file)

{

// Extract info from a GIF file (via PNG conversion)

if(!function_exists('imagepng'))

$this->Error('GD extension is required for GIF support');

if(!function_exists('imagecreatefromgif'))

$this->Error('GD has no GIF read support');

$im = imagecreatefromgif($file);

if(!$im)

$this->Error('Missing or incorrect image file: '.$file);

imageinterlace($im,0);

ob_start();

imagepng($im);

$data = ob_get_clean();

imagedestroy($im);

$f = fopen('php://temp','rb+');

if(!$f)

$this->Error('Unable to create memory stream');

fwrite($f,$data);

rewind($f);

$info = $this->_parsepngstream($f,$file);

fclose($f);

return $info;

}

protected function _out($s)

{

// Add a line to the document

if($this->state==2)

$this->pages[$this->page] .= $s."\n";

elseif($this->state==1)

$this->_put($s);

elseif($this->state==0)

$this->Error('No page has been added yet');

elseif($this->state==3)

$this->Error('The document is closed');

}

protected function _put($s)

{

$this->buffer .= $s."\n";

}

protected function _getoffset()

{

return strlen($this->buffer);

}

protected function _newobj($n=null)

{

// Begin a new object

if($n===null)

$n = ++$this->n;

$this->offsets[$n] = $this->_getoffset();

$this->_put($n.' 0 obj');

}

protected function _putstream($data)

{

$this->_put('stream');

$this->_put($data);

$this->_put('endstream');

}

protected function _putstreamobject($data)

{

if($this->compress)

{

$entries = '/Filter /FlateDecode ';

$data = gzcompress($data);

}

else

$entries = '';

$entries .= '/Length '.strlen($data);

$this->_newobj();

$this->_put('<<'.$entries.'>>');

$this->_putstream($data);

$this->_put('endobj');

}

protected function _putpage($n)

{

$this->_newobj();

$this->_put('<</Type /Page');

$this->_put('/Parent 1 0 R');

if(isset($this->PageInfo[$n]['size']))

$this->_put(sprintf('/MediaBox [0 0 %.2F %.2F]',$this->PageInfo[$n]['size'][0],$this->PageInfo[$n]['size'][1]));

if(isset($this->PageInfo[$n]['rotation']))

$this->_put('/Rotate '.$this->PageInfo[$n]['rotation']);

$this->_put('/Resources 2 0 R');

if(isset($this->PageLinks[$n]))

{

// Links

$annots = '/Annots [';

foreach($this->PageLinks[$n] as $pl)

{

$rect = sprintf('%.2F %.2F %.2F %.2F',$pl[0],$pl[1],$pl[0]+$pl[2],$pl[1]-$pl[3]);

$annots .= '<</Type /Annot /Subtype /Link /Rect ['.$rect.'] /Border [0 0 0] ';

if(is_string($pl[4]))

$annots .= '/A <</S /URI /URI '.$this->_textstring($pl[4]).'>>>>';

else

{

$l = $this->links[$pl[4]];

if(isset($this->PageInfo[$l[0]]['size']))

$h = $this->PageInfo[$l[0]]['size'][1];

else

$h = ($this->DefOrientation=='P') ? $this->DefPageSize[1]*$this->k : $this->DefPageSize[0]*$this->k;

$annots .= sprintf('/Dest [%d 0 R /XYZ 0 %.2F null]>>',$this->PageInfo[$l[0]]['n'],$h-$l[1]*$this->k);

}

$this->_put($annots.']');

}

if($this->WithAlpha)

$this->_put('/Group <</Type /Group /S /Transparency /CS /DeviceRGB>>');

$this->_put('/Contents '.($this->n+1).' 0 R>>');

$this->_put('endobj');

// Page content

if(!empty($this->AliasNbPages))

$this->pages[$n] = str_replace($this->AliasNbPages,$this->page,$this->pages[$n]);

$this->_putstreamobject($this->pages[$n]);

}

protected function _putpages()

{

$nb = $this->page;

for($n=1;$n<=$nb;$n++)

$this->PageInfo[$n]['n'] = $this->n+1+2*($n-1);

for($n=1;$n<=$nb;$n++)

$this->_putpage($n);

// Pages root

$this->_newobj(1);

$this->_put('<</Type /Pages');

$kids = '/Kids [';

for($n=1;$n<=$nb;$n++)

$kids .= $this->PageInfo[$n]['n'].' 0 R ';

$this->_put($kids.']');

$this->_put('/Count '.$nb);

if($this->DefOrientation=='P')

{

$w = $this->DefPageSize[0];

$h = $this->DefPageSize[1];

}

else

{

$w = $this->DefPageSize[1];

$h = $this->DefPageSize[0];

}

$this->_put(sprintf('/MediaBox [0 0 %.2F %.2F]',$w*$this->k,$h*$this->k));

$this->_put('>>');

$this->_put('endobj');

}

protected function _putfonts()

{

foreach($this->FontFiles as $file=>$info)

{

// Font file embedding

$this->_newobj();

$this->FontFiles[$file]['n'] = $this->n;

$font = file_get_contents($this->fontpath.$file,true);

if(!$font)

$this->Error('Font file not found: '.$file);

$compressed = (substr($file,-2)=='.z');

if(!$compressed && isset($info['length2']))

$font = substr($font,6,$info['length1']).substr($font,6+$info['length1']+6,$info['length2']);

$this->_put('<</Length '.strlen($font));

if($compressed)

$this->_put('/Filter /FlateDecode');

$this->_put('/Length1 '.$info['length1']);

if(isset($info['length2']))

$this->_put('/Length2 '.$info['length2'].' /Length3 0');

$this->_put('>>');

$this->_putstream($font);

$this->_put('endobj');

}

foreach($this->fonts as $k=>$font)

{

// Encoding

if(isset($font['diff']))

{

if(!isset($this->encodings[$font['enc']]))

{

$this->_newobj();

$this->_put('<</Type /Encoding /BaseEncoding /WinAnsiEncoding /Differences ['.$font['diff'].']>>');

$this->_put('endobj');

$this->encodings[$font['enc']] = $this->n;

}

// ToUnicode CMap

if(isset($font['uv']))

{

if(isset($font['enc']))

$cmapkey = $font['enc'];

else

$cmapkey = $font['name'];

if(!isset($this->cmaps[$cmapkey]))

{

$cmap = $this->_tounicodecmap($font['uv']);

$this->_putstreamobject($cmap);

$this->cmaps[$cmapkey] = $this->n;

}

// Font object

$this->fonts[$k]['n'] = $this->n+1;

$type = $font['type'];

$name = $font['name'];

if($font['subsetted'])

$name = 'AAAAAA+'.$name;

if($type=='Core')

{

// Core font

$this->_newobj();

$this->_put('<</Type /Font');

$this->_put('/BaseFont /'.$name);

$this->_put('/Subtype /Type1');

if($name!='Symbol' && $name!='ZapfDingbats')

$this->_put('/Encoding /WinAnsiEncoding');

if(isset($font['uv']))

$this->_put('/ToUnicode '.$this->cmaps[$cmapkey].' 0 R');

$this->_put('>>');

$this->_put('endobj');

}

elseif($type=='Type1' || $type=='TrueType')

{

// Additional Type1 or TrueType/OpenType font

$this->_newobj();

$this->_put('<</Type /Font');

$this->_put('/BaseFont /'.$name);

$this->_put('/Subtype /'.$type);

$this->_put('/FirstChar 32 /LastChar 255');

$this->_put('/Widths '.($this->n+1).' 0 R');

$this->_put('/FontDescriptor '.($this->n+2).' 0 R');

if(isset($font['diff']))

$this->_put('/Encoding '.$this->encodings[$font['enc']].' 0 R');

else

$this->_put('/Encoding /WinAnsiEncoding');

if(isset($font['uv']))

$this->_put('/ToUnicode '.$this->cmaps[$cmapkey].' 0 R');

$this->_put('>>');

$this->_put('endobj');

// Widths

$this->_newobj();

$cw = &$font['cw'];

$s = '[';

for($i=32;$i<=255;$i++)

$s .= $cw[chr($i)].' ';

$this->_put($s.']');

$this->_put('endobj');

// Descriptor

$this->_newobj();

$s = '<</Type /FontDescriptor /FontName /'.$name;

foreach($font['desc'] as $k=>$v)

$s .= ' /'.$k.' '.$v;

if(!empty($font['file']))

$s .= ' /FontFile'.($type=='Type1' ? '' : '2').' '.$this->FontFiles[$font['file']]['n'].' 0 R';

$this->_put($s.'>>');

$this->_put('endobj');

}

else

{

// Allow for additional types

$mtd = '_put'.strtolower($type);

if(!method_exists($this,$mtd))

$this->Error('Unsupported font type: '.$type);

$this->$mtd($font);

}

protected function _tounicodecmap($uv)

{

$ranges = '';

$nbr = 0;

$chars = '';

$nbc = 0;

foreach($uv as $c=>$v)

{

if(is_array($v))

{

$ranges .= sprintf("<%02X> <%02X> <%04X>\n",$c,$c+$v[1]-1,$v[0]);

$nbr++;

}

else

{

$chars .= sprintf("<%02X> <%04X>\n",$c,$v);

$nbc++;

}

$s = "/CIDInit /ProcSet findresource begin\n";

$s .= "12 dict begin\n";

$s .= "begincmap\n";

$s .= "/CIDSystemInfo\n";

$s .= "<</Registry (Adobe)\n";

$s .= "/Ordering (UCS)\n";

$s .= "/Supplement 0\n";

$s .= ">> def\n";

$s .= "/CMapName /Adobe-Identity-UCS def\n";

$s .= "/CMapType 2 def\n";

$s .= "1 begincodespacerange\n";

$s .= "<00> <FF>\n";

$s .= "endcodespacerange\n";

if($nbr>0)

{

$s .= "$nbr beginbfrange\n";

$s .= $ranges;

$s .= "endbfrange\n";

}

if($nbc>0)

{

$s .= "$nbc beginbfchar\n";

$s .= $chars;

$s .= "endbfchar\n";

}

$s .= "endcmap\n";

$s .= "CMapName currentdict /CMap defineresource pop\n";

$s .= "end\n";

$s .= "end";

return $s;

}

protected function _putimages()

{

foreach(array_keys($this->images) as $file)

{

$this->_putimage($this->images[$file]);

unset($this->images[$file]['data']);

unset($this->images[$file]['smask']);

}

protected function _putimage(&$info)

{

$this->_newobj();

$info['n'] = $this->n;

$this->_put('<</Type /XObject');

$this->_put('/Subtype /Image');

$this->_put('/Width '.$info['w']);

$this->_put('/Height '.$info['h']);

if($info['cs']=='Indexed')

$this->_put('/ColorSpace [/Indexed /DeviceRGB '.(strlen($info['pal'])/3-1).' '.($this->n+1).' 0 R]');

else

{

$this->_put('/ColorSpace /'.$info['cs']);

if($info['cs']=='DeviceCMYK')

$this->_put('/Decode [1 0 1 0 1 0 1 0]');

}

$this->_put('/BitsPerComponent '.$info['bpc']);

if(isset($info['f']))

$this->_put('/Filter /'.$info['f']);

if(isset($info['dp']))

$this->_put('/DecodeParms <<'.$info['dp'].'>>');

if(isset($info['trns']) && is_array($info['trns']))

{

$trns = '';

for($i=0;$i<count($info['trns']);$i++)

$trns .= $info['trns'][$i].' '.$info['trns'][$i].' ';

$this->_put('/Mask ['.$trns.']');

}

if(isset($info['smask']))

$this->_put('/SMask '.($this->n+1).' 0 R');

$this->_put('/Length '.strlen($info['data']).'>>');

$this->_putstream($info['data']);

$this->_put('endobj');

// Soft mask

if(isset($info['smask']))

{

$dp = '/Predictor 15 /Colors 1 /BitsPerComponent 8 /Columns '.$info['w'];

$smask = array('w'=>$info['w'], 'h'=>$info['h'], 'cs'=>'DeviceGray', 'bpc'=>8, 'f'=>$info['f'], 'dp'=>$dp, 'data'=>$info['smask']);

$this->_putimage($smask);

}

// Palette

if($info['cs']=='Indexed')

$this->_putstreamobject($info['pal']);

}

protected function _putxobjectdict()

{

foreach($this->images as $image)

$this->_put('/I'.$image['i'].' '.$image['n'].' 0 R');

}

protected function _putresourcedict()

{

$this->_put('/ProcSet [/PDF /Text /ImageB /ImageC /ImageI]');

$this->_put('/Font <<');

foreach($this->fonts as $font)

$this->_put('/F'.$font['i'].' '.$font['n'].' 0 R');

$this->_put('>>');

$this->_put('/XObject <<');

$this->_putxobjectdict();

$this->_put('>>');

}

protected function _putresources()

{

$this->_putfonts();

$this->_putimages();

// Resource dictionary

$this->_newobj(2);

$this->_put('<<');

$this->_putresourcedict();

$this->_put('>>');

$this->_put('endobj');

}

protected function _putinfo()

{

$this->metadata['Producer'] = 'FPDF '.FPDF_VERSION;

$this->metadata['CreationDate'] = 'D:'.@date('YmdHis');

foreach($this->metadata as $key=>$value)

$this->_put('/'.$key.' '.$this->_textstring($value));

}

protected function _putcatalog()

{

$n = $this->PageInfo[1]['n'];

$this->_put('/Type /Catalog');

$this->_put('/Pages 1 0 R');

if($this->ZoomMode=='fullpage')

$this->_put('/OpenAction ['.$n.' 0 R /Fit]');

elseif($this->ZoomMode=='fullwidth')

$this->_put('/OpenAction ['.$n.' 0 R /FitH null]');

elseif($this->ZoomMode=='real')

$this->_put('/OpenAction ['.$n.' 0 R /XYZ null null 1]');

elseif(!is_string($this->ZoomMode))

$this->_put('/OpenAction ['.$n.' 0 R /XYZ null null '.sprintf('%.2F',$this->ZoomMode/100).']');

if($this->LayoutMode=='single')

$this->_put('/PageLayout /SinglePage');

elseif($this->LayoutMode=='continuous')

$this->_put('/PageLayout /OneColumn');

elseif($this->LayoutMode=='two')

$this->_put('/PageLayout /TwoColumnLeft');

}

protected function _putheader()

{

$this->_put('%PDF-'.$this->PDFVersion);

}

protected function _puttrailer()

{

$this->_put('/Size '.($this->n+1));

$this->_put('/Root '.$this->n.' 0 R');

$this->_put('/Info '.($this->n-1).' 0 R');

}

protected function _enddoc()

{

$this->_putheader();

$this->_putpages();

$this->_putresources();

// Info

$this->_newobj();

$this->_put('<<');

$this->_putinfo();

$this->_put('>>');

$this->_put('endobj');

// Catalog

$this->_newobj();

$this->_put('<<');

$this->_putcatalog();

$this->_put('>>');

$this->_put('endobj');

// Cross-ref

$offset = $this->_getoffset();

$this->_put('xref');

$this->_put('0 '.($this->n+1));

$this->_put('0000000000 65535 f ');

for($i=1;$i<=$this->n;$i++)

$this->_put(sprintf('%010d 00000 n ',$this->offsets[$i]));

// Trailer

$this->_put('trailer');

$this->_put('<<');

$this->_puttrailer();

$this->_put('>>');

$this->_put('startxref');

$this->_put($offset);

$this->_put('%%EOF');

$this->state = 3;

}

home_deductions
<?php
include("auth.php"); //include auth.php file on all secure pages
include("add_employee.php");
?>

<?php

$conn = mysql_connect('localhost', 'root', '');
if (!$conn)
{
die("Database Connection Failed" . mysql_error());
}

$select_db = mysql_select_db('payroll');
if (!$select_db)
{
die("Database Selection Failed" . mysql_error());
}

$query = mysql_query("SELECT * from deductions");
while($row=mysql_fetch_array($query))
{
$id = $row['deduction_id'];
$philhealth = $row['philhealth'];
$bir = $row['bir'];
$gsis = $row['gsis'];
$love = $row['pag_ibig'];
$loans = $row['loans'];

$total = $philhealth + $bir + $gsis + $love + $loans;
}
?>

<!DOCTYPE html>
<html lang="en">
<head>


<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Bootstrap, a sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.">
<meta name="keywords" content="HTML, CSS, JS, JavaScript, framework, bootstrap, front-end, frontend, web development">
<meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link href="assets/css/justified-nav.css" rel="stylesheet">

<link href="assets/css/bootstrap.min.css" rel="stylesheet">


<link href="assets/css/search.css" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/css/dataTables.min.css">

</head>
<body>

<div class="container">
<div class="masthead">
<h3>
<b><a href="index.php">Sitem Manajemen dan Penggajian</a></b>
<a data-toggle="modal" href="#colins" class="pull-right"><b>Admin</b></a>
</h3>
<nav>
<ul class="nav nav-justified">
<li>
<a href="home_employee.php">Pegawai</a>
</li>
<li class="active">
<a data-toggle="modal" href="#deductions">Rincian Gaji</a>
</li>
<li>
<a href="home_salary.php">Pendapatan</a>
</li>
</ul>
</nav>
</div><br><br>

<form class="form-horizontal" action="#" name="form">
<div class="form-group">
<label class="col-sm-5 control-label">Asuransi Kesehatan :</label>
<div class="col-sm-4">
<?php echo $philhealth; ?>.00
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Tunjangan makan dan minum :</label>
<div class="col-sm-4">
<?php echo $bir; ?>.00
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Tunjangan Anak :</label>
<div class="col-sm-4">
<?php echo $gsis; ?>.00
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Tunjangan Transportasi :</label>
<div class="col-sm-4">
<?php echo $love; ?>.00
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Gaji Pokok :</label>
<div class="col-sm-4">
<?php echo $loans; ?>.00
</div>
</div><br><br>
<div class="form-group">
<label class="col-sm-5 control-label">Total Rincian :</label>
<div class="col-sm-4">
<?php echo $total; ?>.00
</div>
</div>

<div class="form-group">
<label class="col-sm-5 control-label"><button type="button" data-toggle="modal" data-target="#deductions" class="btn btn-danger">Update</button></label>
</div>
</form>


<div class="modal fade" id="deductions" role="dialog">
<div class="modal-dialog">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center"><b>Rincian Gaji</b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">

<form class="form-horizontal" action="add_deductions.php" name="form" method="post">
<div class="form-group">
<label class="col-sm-4 control-label">Asuransi Kesehatan</label>
<div class="col-sm-8">
<input type="text" name="philhealth" class="form-control" required="required" value="<?php echo $philhealth; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Tunjangan Makan dan Minum</label>


</body><div class="col-sm-8">
<input type="text" name="bir" class="form-control" value="<?php echo $bir; ?>" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Tunjangan Anak</label>
<div class="col-sm-8">
<input type="text" name="gsis" class="form-control" value="<?php echo $gsis; ?>" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Tunjangan Transfortasi</label>
<div class="col-sm-8">
<input type="text" name="pag_ibig" class="form-control" value="<?php echo $love; ?>" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Gaji Pokok</label>
<div class="col-sm-8">
<input type="text" name="loans" class="form-control" value="<?php echo $loans; ?>" required="required">
</div>
</div>

<div class="form-group">
<label class="col-sm-4 control-label"></label>
<div class="col-sm-8">
<input type="submit" name="submit" class="btn btn-success" value="Submit">
</div>
</div>
</form>

</div>
</div>
</div>
</div>


<div class="modal fade" id="colins" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">You are logged in as <b><?php echo $_SESSION['username']; ?></b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
<a href="logout.php" class="btn btn-block btn-danger">Logout</a>
</div>
</div>
</div>
</div>
</div>

</div>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/search.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="assets/js/dataTables.min.js"></script>


<script>
{
$(document).ready(function()
{
$('#myTable').DataTable();
});
}
</script>


<script>
$(document).ready(function()
{
$("#myBtn").click(function()
{
$("#myModal").modal();
});
});
</script>

</html>

home_employee
<?php
include("auth.php"); //include auth.php file on all secure pages
include("add_employee.php");

$sql = mysql_query("SELECT * from deductions WHERE deduction_id='1'");
while($row = mysql_fetch_array($sql))
{
$phil = $row['philhealth'];
$bir = $row['bir'];
$gsis = $row['gsis'];
$love = $row['pag_ibig'];
$loans = $row['loans'];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>


<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Bootstrap, a sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.">
<meta name="keywords" content="HTML, CSS, JS, JavaScript, framework, bootstrap, front-end, frontend, web development">
<meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link href="assets/css/justified-nav.css" rel="stylesheet">

<link href="assets/css/bootstrap.min.css" rel="stylesheet">


<link href="assets/css/search.css" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/css/dataTables.min.css">

</head>
<body>

<div class="container">
<div class="masthead">
<h3>
<b><a href="index.php">Sistem Manajemen dan Penggajian</a></b>
<a data-toggle="modal" href="#colins" class="pull-right"><b>Admin</b></a>
</h3>
<nav>
<ul class="nav nav-justified">
<li class="active">
<a href="">Pegawai</a>
</li>
<li>
<a href="home_deductions.php">Rincian Gaji</a>
</li>
<li>
<a href="home_salary.php">Pendapatan</a>
</li>
</ul>
</nav>
</div>

<br>
<div class="well bs-component">
<form class="form-horizontal">
<fieldset>
<button type="button" data-toggle="modal" data-target="#addEmployee" class="btn btn-default">TAMBAH</button>
<a href="laporan_pdf.php" class="btn btn-success">Export Ke Excel</a>
<p align="center"><big><b>Daftar Pegawai</b></big></p>
<div class="table-responsive">
<form method="post" action="" >
<table class="table table-striped table-hover table-condensed" id="myTable">

<thead>
<tr class="" style="background:#4169E1">
<th><p align="center">Nama</p></th>
<th><p align="center">Jenis Kelamin</p></th>
<th><p align="center">Tipe Pegawai</p></th>
<th><p align="center">Departmen</p></th>
<th><p align="center">Opsi</p></th>
</tr>
</thead>
<tbody>
<?php

$conn = mysql_connect('localhost', 'root', '');
if (!$conn)
{
die("Database Connection Failed" . mysql_error());
}

$select_db = mysql_select_db('payroll');
if (!$select_db)
{
die("Database Selection Failed" . mysql_error());
}

$query=mysql_query("select * from employee ORDER BY emp_id asc")or die(mysql_error());
while($row=mysql_fetch_array($query))

{
$id =$row['emp_id'];
$lname =$row['lname'];
$fname =$row['fname'];
$type =$row['emp_type'];
$deduction =$row['deduction'];
$overtime =$row['overtime'];
$bonus =$row['bonus'];
?>

<tr>

<td align="center"><a href="view_employee.php?emp_id=<?php echo $row["emp_id"]; ?>" title="Update"><?php echo $row['lname'] ?>, <?php echo $row['fname'] ?></a></td>
<td align="center"><a href="view_employee.php?emp_id=<?php echo $row["emp_id"]; ?>" title="Update"><?php echo $row['gender'] ?></a></td>
<td align="center"><a href="view_employee.php?emp_id=<?php echo $row["emp_id"]; ?>" title="Update"><?php echo $row['emp_type'] ?></a></td>
<td align="center"><a href="view_employee.php?emp_id=<?php echo $row["emp_id"]; ?>" title="Update"><?php echo $row['division'] ?></a></td>
<td align="center">
<a class="btn btn-warning" href="view_account.php?emp_id=<?php echo $row["emp_id"]; ?>">Edit</a>
<a class="btn btn-danger" href="delete.php?emp_id=<?php echo $row["emp_id"]; ?>">Hapus</a>
</td>
</tr>
<?php } ?>
</tbody>


</table>
</form>
</div>
</fieldset>
</form>
</div>


<div class="modal fade" id="addEmployee" role="dialog">
<div class="modal-dialog">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center"><b>Add Employee</b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">

<form class="form-horizontal" action="#" name="form" method="post">
<div class="form-group">
<label class="col-sm-4 control-label">Nama Depan</label>
<div class="col-sm-8">
<input type="text" name="lname" class="form-control" placeholder="Lastname" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Nama Belakang</label>
<div class="col-sm-8">
<input type="text" name="fname" class="form-control" placeholder="Firstname" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Jenis Kelamin</label>
<div class="col-sm-8">
<select name="gender" class="form-control" placeholder="Gender" required>
<option value="">Jenis Kelamin</option>
<option value="Male">Laki-Laki</option>
<option value="Female">Perempuan</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Tipe Pegawai</label>
<div class="col-sm-8">
<select name="emp_type" class="form-control" placeholder="Employee Type" required>
<option value="">Tipe Pegawai</option>
<option value="Job Order">Job Order</option>
<option value="Regular">Regular</option>
<option value="Casual">Casual</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Division</label>
<div class="col-sm-8">
<select name="division" class="form-control" placeholder="Division" required>
<option value="">Division</option>
<option value="Admin">Admin</option>
<option value="Human Resource">Human Resource</option>
<option value="Accounting">Accounting</option>
<option value="Engineering">Engineering</option>
<option value="MIS">MIS</option>
<option value="Supply">Supply</option>
<option value="Maintenance">Maintenance</option>
<option value="Control">Control</option>
</select>
</div>
</div>

<div class="form-group">
<label class="col-sm-4 control-label"></label>
<div class="col-sm-8">
<input type="submit" name="submit" class="btn btn-success" value="Submit">
<input type="reset" name="" class="btn btn-danger" value="Clear Fields">
</div>
</div>
</form>

</div>
</div>
</div>
</div>


<div class="modal fade" id="colins" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">You are logged in as <b><?php echo $_SESSION['username']; ?></b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
<a href="logout.php" class="btn btn-block btn-danger">Logout</a>
</div>
</div>
</div>
</div>
</div>

</div>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/search.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="assets/js/dataTables.min.js"></script>


<script>
{
$(document).ready(function()
{
$('#myTable').DataTable();
});
}
</script>


<script>
$(document).ready(function()
{
$("#myBtn").click(function()
{
$("#myModal").modal();
});
});
</script>

</body>

</html>

home_salary
<?php
include("auth.php"); //include auth.php file on all secure pages
include("db.php")
?>

<?php
$query = mysql_query("SELECT * from overtime");
while($row=mysql_fetch_array($query))
{
@$rate = $row['rate'];
}

$query = mysql_query("SELECT * from salary");
while($row=mysql_fetch_array($query))
{
@$salary = $row['salary_rate'];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>


<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Bootstrap, a sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.">
<meta name="keywords" content="HTML, CSS, JS, JavaScript, framework, bootstrap, front-end, frontend, web development">
<meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link href="assets/css/justified-nav.css" rel="stylesheet">

<link href="assets/css/bootstrap.min.css" rel="stylesheet">


<link href="assets/css/search.css" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/css/dataTables.min.css">

</head>
<body>

<div class="container">
<div class="masthead">
<h3>
<b><a href="index.php">Sistem Manajemen dan Penggajian</a></b>
<a data-toggle="modal" href="#colins" class="pull-right"><b>Admin</b></a>
</h3>
<nav>
<ul class="nav nav-justified">
<li>
<a href="home_employee.php">Pegawai</a>
</li>
<li>
<a href="home_deductions.php">Rincian Gaji</a>
</li>
<li class="active">
<a href="">Pendapatan</a>
</li>
</ul>
</nav>
</div>

<br>
<div class="well bs-component">
<form class="form-horizontal">
<fieldset>
<button type="button" data-toggle="modal" data-target="#overtime" class="btn btn-danger">Edit Lemburan</button>
<button type="button" data-toggle="modal" data-target="#salary" class="btn btn-warning">Edit Nilai Gaji</button>
<p class="pull-right">Waktu Lemburan /Hari: <big><b><?php echo $rate; ?>.00</b></big></p><br>
<p class="pull-right">Nilai Gaji: <big><b><?php echo $salary; ?>.00</b></big></p>
<p align="center"><big><b>Account</b></big></p>
<div class="table-responsive">
<form method="post" action="" >
<table class="table table-striped table-hover table-condensed" id="myTable">

<thead>
<tr class="" style="background:#4169E1">

</style>
<th><p align="center">Nama</p></th>
<th><p align="center">Rincian</p></th>
<th><p align="center">Waktu Lembur</p></th>
<th><p align="center">Bonus</p></th>
<th><p align="center">Total</p></th>
</tr>
</thead>
<tbody>
<?php
$query = mysql_query("SELECT * from overtime");
while($row=mysql_fetch_array($query))
{
$rate = $row['rate'];
}

$query = mysql_query("SELECT * from salary");
while($row=mysql_fetch_array($query))
{
$salary_rate = $row['salary_rate'];
}

$query = mysql_query("SELECT * from employee");
while($row=mysql_fetch_array($query))
{
$lname = $row['lname'];
$fname = $row['fname'];
$deduction = $row['deduction'];
$overtime = $row['overtime'];
$bonus = $row['bonus'];

$over = $row['overtime'] * $rate;
$bonus = $row['bonus'];
$deduction = $row['deduction'];
$income = $over + $bonus + $salary_rate;
$netpay = $income - $deduction;
?>
<tr>
<td align="center"><?php echo $lname?>, <?php echo $fname?></td>
<td align="center"><big><b><?php echo $deduction?></b></big>.00</td>
<td align="center"><big><b><?php echo $overtime?></b></big> hrs</td>
<td align="center"><big><b><?php echo $bonus?></b></big>.00</td>
<td align="center"><big><b><?php echo $netpay?></b></big>.00</td>
</tr>
<?php } ?>
</tbody>


</table>
</form>
</div>
</fieldset>
</form>
</div>


<div class="modal fade" id="overtime" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">masukan nilai <big><b>lemburan</b></big> per jam.</h3>
</div>
<div class="modal-body" style="padding:40px 50px;">

<form class="form-horizontal" action="update_overtime.php" name="form" method="post">
<div class="form-group">
<input type="text" name="rate" class="form-control" value="<?php echo $rate; ?>" required="required">
</div>

<div class="form-group">
<input type="submit" name="submit" class="btn btn-success" value="Submit">
</div>
</form>

</div>
</div>
</div>
</div>


<div class="modal fade" id="salary" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">Masukan jumlah <big><b>Gaji</b></big> nilai.</h3>
</div>
<div class="modal-body" style="padding:40px 50px;">

<form class="form-horizontal" action="update_salary.php" name="form" method="post">
<div class="form-group">
<input type="text" name="salary_rate" class="form-control" value="<?php echo $salary; ?>" required="required">
</div>

<div class="form-group">
<input type="submit" name="submit" class="btn btn-success" value="Submit">
</div>
</form>

</div>
</div>
</div>
</div>


<div class="modal fade" id="colins" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">You are logged in as <b><?php echo $_SESSION['username']; ?></b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
<a href="logout.php" class="btn btn-block btn-danger">Logout</a>
</div>
</div>
</div>
</div>
</div>

</div>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/search.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="assets/js/dataTables.min.js"></script>


<script>
{
$(document).ready(function()
{
$('#myTable').DataTable();
});
}
</script>


<script>
$(document).ready(function()
{
$("#myBtn").click(function()
{
$("#myModal").modal();
});
});
</script>

</body>

</html>

index
<?php
include("auth.php"); //include auth.php file on all secure pages
include("add_employee.php");
?>

<?php

$conn = mysql_connect('localhost', 'root', '');
if (!$conn)
{
die("Database Connection Failed" . mysql_error());
}

$select_db = mysql_select_db('payroll');
if (!$select_db)
{
die("Database Selection Failed" . mysql_error());
}

$query = mysql_query("SELECT * from deductions");
while($row=mysql_fetch_array($query))
{
$id = $row['deduction_id'];
$philhealth = $row['philhealth'];
$bir = $row['bir'];
$gsis = $row['gsis'];
$love = $row['pag_ibig'];
$loans = $row['loans'];

$total = $philhealth + $bir + $gsis + $love + $loans;
}
?>

<!DOCTYPE html>
<html lang="en">
<head>


<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Bootstrap, a sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.">
<meta name="keywords" content="HTML, CSS, JS, JavaScript, framework, bootstrap, front-end, frontend, web development">
<meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link href="assets/css/justified-nav.css" rel="stylesheet">

<link href="assets/css/bootstrap.min.css" rel="stylesheet">


<link href="assets/css/search.css" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/css/dataTables.min.css">

</head>
<body>

<div class="container">
<div class="masthead">
<h3>
<b>Sistem Manajemen dan Penggajian</b>
<a data-toggle="modal" href="#colins" class="pull-right"><span class="glyphicon glyphicon-export"></span><b><?php echo $_SESSION['username']; ?></b></a>
</h3>
<nav>
<ul class="nav nav-justified">
<li><a href="home_employee.php">Pegawai</a></li>
<li><a href="home_deductions.php">Deduksi</a></li>
<li><a href="home_salary.php">Pendapatan</a></li>
</ul>
</nav>
</div><br>


<div class="jumbotron" style="background:#87CEFA;">
<h1>Selamat Datang !!</h1>
<p class="lead">Di Sistem manajemen dan Penggajian perusahaan kami</p>
</div>


<footer class="footer">
<p align="center">© All Rights Reserved 2017</p>
<p align="center">Copyright by <a target="_blank" href="#" data-show-count="true">STMIK Sumedang</a></p>
<p align="center">About the <a target="_blank" href="#">Developer</a></p>
</footer>


<div class="modal fade" id="instructor" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center"><b>Instructor</b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
</div>
</div>
</div>
</div>
</div>


<div class="modal fade" id="colins" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">You are logged in as <b><?php echo $_SESSION['username']; ?></b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
<a href="logout.php" class="btn btn-block btn-danger">Logout</a>
</div>
</div>
</div>
</div>
</div>

</div>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/search.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="assets/js/dataTables.min.js"></script>


<script>
{
$(document).ready(function()
{
$('#myTable').DataTable();
});
}
</script>


<script>
$(document).ready(function()
{
$("#myBtn").click(function()
{
$("#myModal").modal();
});
});
</script>

</body>

</html>

laporan_pdf
<?php
mysql_connect("localhost","root","");
mysql_select_db("payroll");
header("Content-Type: application/force-download");
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sat, 26 Jul 2010 05:00:00 GMT");
header("content-disposition: attachment;filename=laporan_data_Pegawai".date('dmY').".xls");

echo '<table align="center" border="1">
<tbody>
<tr>
<td style="background: #EEE; font-weight: bold;">No.</td>
<td style="background: #EEE; font-weight: bold;">Nama</td>
<td style="background: #EEE; font-weight: bold;">Nama Depan</td>
<td style="background: #EEE; font-weight: bold;">Jenis Kelamin</td>
<td style="background: #EEE; font-weight: bold;">Tipe Pegawai</td>
<td style="background: #EEE; font-weight: bold;">Departmen/td>

</tr>
</tbody>
';

$query=mysql_query("SELECT * from employee");
echo'';
$no = 1;
while($data=mysql_fetch_array($query)){
echo '
';
echo '<table align="center" border="1">
<tbody>
<tr>
<td>' . $no.'.</td>
<td>' . $data['lname'] . '</td>
<td>' . $data['fname'] . '</td>
<td>' . $data['gender'] . '</td>
<td>' . $data['division'] . '</td>
<td>' . $data['emp_type'] . '</td>
</tr>
</tbody></table>
';
$no++;
}

?>

login
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link rel="stylesheet" href="assets/css/login.css">

</head>

<body class="hold-transition login-page">
<?php
require('db.php');
session_start();
// If form submitted, insert values into the database.
if (isset($_POST['username']))
{
$username = $_POST['username'];
$password = $_POST['password'];

$username = stripslashes($username);
$username = mysql_real_escape_string($username);

$password = stripslashes($password);
$password = mysql_real_escape_string($password);

//Checking is user existing in the database or not
$query = "SELECT * FROM `user` WHERE username='$username' and password='$password'";
$result = mysql_query($query) or die(mysql_error());
$rows = mysql_num_rows($result);

if($rows==1)
{
$_SESSION['username'] = $username;
header("Location: index.php");
}
else
{
?>
<script>
alert('Invalid Keyword, please try again.');
window.location.href='login.php';
</script>
<?php
}
}
else
{
?>

<br><br><br><br><br><br><br><br>
<div class="container">
<section id="content">
<form action="" method="post">
<h1>Login Form</h1>
<div>
<input name=username type="text" placeholder="Enter Username" required>

</div>
<div>
<input name=password type="password" placeholder="Enter Password" required>

</div>
<div>
<input type="submit" value="Log in" />


</div>
</form>
</section>
</div>

<?php } ?>

</body>

</html>

logout
<?php
session_start();
session_destroy();
header("location: login.php");

?>

update_account
<?php

include("db.php");
include("auth.php");

$id = $_POST['id'];
$deduction = $_POST['deduction'];
$overtime = $_POST['overtime'];
$bonus = $_POST['bonus'];

$sql = mysql_query("UPDATE employee SET deduction='$deduction', overtime='$overtime', bonus='$bonus' WHERE emp_id='$id'");

if ($sql)
{
?>
<script>
alert('Account successfully updated.');
window.location.href='home_employee.php';
</script>
<?php
}
else
{
echo "Invalid";
}

?>
update_employee
<?php

include("db.php");
include("auth.php");

$id = $_POST['id'];
$lname = $_POST['lname'];
$fname = $_POST['fname'];
$gender = $_POST['gender'];
$division = $_POST['division'];
$emp_type = $_POST['emp_type'];

$sql = mysql_query("UPDATE employee SET emp_type='$emp_type', lname='$lname', fname='$fname', gender='$gender', division='$division' WHERE emp_id='$id'");

if ($sql)
{
?>
<script>
alert('Employee successfully updated.');
window.location.href='home_employee.php';
</script>
<?php
}
else
{
?>
<script>
alert('Invalid action.');
window.location.href='home_employee.php';
</script>
<?php
}

?>

update_overtime
<?php

require("db.php");

@$id =$_POST['ot_id'];
@$rate =$_POST['rate'];

$sql = mysql_query("UPDATE overtime SET rate='$rate' WHERE ot_id='1'");

if($sql)
{
?>
<script>
alert(' rate successfully changed...');
window.location.href='home_salary.php';
</script>
<?php
}
else {
echo "Not Succsesfull!";
}
?>

update_salary
<?php

require("db.php");

@$id = $_POST['salary_id'];
@$salary = $_POST['salary_rate'];

$sql = mysql_query("UPDATE salary SET salary_rate='$salary' WHERE salary_id='1'");

if($sql)
{
?>
<script>
alert('Salary rate successfully changed...');
window.location.href='home_salary.php';
</script>
<?php
}
else {
echo "Not Successfull!";
}

?>

view_account
<?php
include("db.php"); //include auth.php file on all secure pages
include("auth.php");

$sql = mysql_query("SELECT * from deductions WHERE deduction_id='1'");
while($row = mysql_fetch_array($sql))
{
$phil = $row['philhealth'];
$bir = $row['bir'];
$gsis = $row['gsis'];
$love = $row['pag_ibig'];
$loans = $row['loans'];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>


<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Bootstrap, a sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.">
<meta name="keywords" content="HTML, CSS, JS, JavaScript, framework, bootstrap, front-end, frontend, web development">
<meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link href="assets/css/justified-nav.css" rel="stylesheet">

<link href="assets/css/bootstrap.min.css" rel="stylesheet">


<link href="assets/css/search.css" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/css/dataTables.min.css">

</head>
<body>

<div class="container">
<div class="masthead">
<h3>
<b><a href="index.php">Sistem Manajemen dan Penggajian</a></b>
<a data-toggle="modal" href="#colins" class="pull-right"><b>Admin</b></a>
</h3>
<nav>
<ul class="nav nav-justified">
<li class="active">
<a href="">Pegawai</a>
</li>
<li>
<a href="home_deductions.php">Rincian Gaji</a>
</li>
<li>
<a href="home_salary.php">Pendapatan</a>
</li>
</ul>
</nav>
</div><br><br>

<?php
$id=$_REQUEST['emp_id'];
$query = "SELECT * from employee where emp_id='".$id."'";
$result = mysql_query($query) or die ( mysql_error());

$query = mysql_query("SELECT * from overtime");
while($row=mysql_fetch_array($query))
{
$rate = $row['rate'];
}

$query = mysql_query("SELECT * from salary");
while($row=mysql_fetch_array($query))
{
$salary = $row['salary_rate'];
}

while ($row = mysql_fetch_assoc($result))
{
$overtime = $row['overtime'] * $rate;
$bonus = $row['bonus'];
$deduction = $row['deduction'];
$income = $overtime + $bonus + $salary;
$netpay = $income - $deduction;
?>

<form class="form-horizontal" action="update_account.php" method="post" name="form">
<input type="hidden" name="new" value="1" />
<input name="id" type="hidden" value="<?php echo $row['emp_id'];?>" />
<div class="form-group">
<label class="col-sm-5 control-label"></label>
<div class="col-sm-4">
<h2><?php echo $row['lname']; ?>, <?php echo $row['fname']; ?></h2>
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Rincian Gaji :</label>
<div class="col-sm-4">
<select name="deduction" class="form-control" required>
<option value=""><?php echo $row['deduction'];?></option>
<option value="<?php echo $phil; ?>">Asuransi Kesehatan</option>
<option value="<?php echo $bir; ?>">Tunjangan Makan dan Minum</option>
<option value="<?php echo $gsis; ?>">Tunjangan Anak</option>
<option value="<?php echo $love; ?>">tunjangan Transfortasi</option>
<option value="<?php echo $loans; ?>">Gaji pokok</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">lemburan :</label>
<div class="col-sm-4">
<input type="text" name="overtime" class="form-control" value="<?php echo $row['overtime'];?>" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Bonus :</label>
<div class="col-sm-4">
<input type="text" name="bonus" class="form-control" value="<?php echo $row['bonus'];?>" required="required">
</div>
</div><br><br>

<div class="form-group">
<label class="col-sm-5 control-label">Total :</label>
<div class="col-sm-4">
<?php echo $netpay;?>.00
</div>
</div><br><br>
<div class="form-group">
<label class="col-sm-5 control-label"></label>
<div class="col-sm-4">
<input type="submit" name="submit" value="Update" class="btn btn-danger">
<a href="home_employee.php" class="btn btn-primary">Cancel</a>
</div>
</div>
</form>
<?php
}
?>


<div class="modal fade" id="colins" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">You are logged in as <b><?php echo $_SESSION['username']; ?></b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
<a href="logout.php" class="btn btn-block btn-danger">Logout</a>
</div>
</div>
</div>
</div>
</div>

</div>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/search.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="assets/js/dataTables.min.js"></script>


<script>
{
$(document).ready(function()
{
$('#myTable').DataTable();
});
}
</script>


<script>
$(document).ready(function()
{
$("#myBtn").click(function()
{
$("#myModal").modal();
});
});
</script>

</body>

</html>

view_employee
<?php
include("db.php"); //include auth.php file on all secure pages
include("auth.php");

$sql = mysql_query("SELECT * from deductions WHERE deduction_id='1'");
while($row = mysql_fetch_array($sql))
{
$phil = $row['philhealth'];
$bir = $row['bir'];
$gsis = $row['gsis'];
$love = $row['pag_ibig'];
$loans = $row['loans'];
}
?>

<!DOCTYPE html>
<html lang="en">
<head>


<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Bootstrap, a sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.">
<meta name="keywords" content="HTML, CSS, JS, JavaScript, framework, bootstrap, front-end, frontend, web development">
<meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">

<title></title>

<script>

</script>

<link href="assets/must.png" rel="shortcut icon">
<link href="assets/css/justified-nav.css" rel="stylesheet">

<link href="assets/css/bootstrap.min.css" rel="stylesheet">


<link href="assets/css/search.css" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/css/dataTables.min.css">

</head>
<body>

<div class="container">
<div class="masthead">
<h3>
<b><a href="index.php">Sistem Manajemen dan Penggajian</a></b>
<a data-toggle="modal" href="#colins" class="pull-right"><b>Admin</b></a>
</h3>
<nav>
<ul class="nav nav-justified">
<li class="active">
<a href="">Pegawai</a>
</li>
<li>
<a href="home_deductions.php">Rinciaan Gaji</a>
</li>
<li>
<a href="home_salary.php">Pendapatan</a>
</li>
</ul>
</nav>
</div><br><br>

<?php
$id=$_REQUEST['emp_id'];
$query = "SELECT * from employee where emp_id='".$id."'";
$result = mysql_query($query) or die ( mysql_error());

while ($row = mysql_fetch_assoc($result))
{

?>

<form class="form-horizontal" action="update_employee.php" method="post" name="form">
<input type="hidden" name="new" value="1" />
<input name="id" type="hidden" value="<?php echo $row['emp_id'];?>" />
<div class="form-group">
<label class="col-sm-5 control-label"></label>
<div class="col-sm-4">
<h2><?php echo $row['lname']; ?>, <?php echo $row['fname']; ?></h2>
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">NamaDepan :</label>
<div class="col-sm-4">
<input type="text" name="lname" class="form-control" value="<?php echo $row['lname'];?>" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">NamaBelakang :</label>
<div class="col-sm-4">
<input type="text" name="fname" class="form-control" value="<?php echo $row['fname'];?>" required="required">
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Jenis Kelamin :</label>
<div class="col-sm-4">
<select name="gender" class="form-control" required>
<option value="<?php echo $row['gender'];?>"><?php echo $row['gender'];?></option>
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label"> Type Pegawai :</label>
<div class="col-sm-4">
<select name="emp_type" class="form-control" required>
<option value="<?php echo $row['emp_type'];?>"><?php echo $row['emp_type'];?></option>
<option value="Job Order">Job Order</option>
<option value="Regular">Regular</option>
<option value="Casual">Casual</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-5 control-label">Department :</label>
<div class="col-sm-4">
<select name="division" class="form-control" placeholder="Division" required>
<option value="<?php echo $row['division'];?>"><?php echo $row['division'];?></option>
<option value="Admin">Admin</option>
<option value="Human Resource">Human Resource</option>
<option value="Accounting">Accounting</option>
<option value="Engineering">Engineering</option>
<option value="MIS">MIS</option>
<option value="Supply">Supply</option>
<option value="Maintenance">Maintenance</option>
<option value="Control">Control</option>
</select>
</div>
</div><br><br>

<div class="form-group">
<label class="col-sm-5 control-label"></label>
<div class="col-sm-4">
<input type="submit" name="submit" value="Update" class="btn btn-danger">
<a href="home_employee.php" class="btn btn-primary">Cancel</a>
</div>
</div>
</form>
<?php
}
?>


<div class="modal fade" id="colins" role="dialog">
<div class="modal-dialog modal-sm">


<div class="modal-content">
<div class="modal-header" style="padding:20px 50px;">
<button type="button" class="close" data-dismiss="modal" title="Close">×</button>
<h3 align="center">You are logged in as <b><?php echo $_SESSION['username']; ?></b></h3>
</div>
<div class="modal-body" style="padding:40px 50px;">
<div align="center">
<a href="logout.php" class="btn btn-block btn-danger">Logout</a>
</div>
</div>
</div>
</div>
</div>

</div>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/search.js"></script>
<script type="text/javascript" charset="utf-8" language="javascript" src="assets/js/dataTables.min.js"></script>


<script>
{
$(document).ready(function()
{
$('#myTable').DataTable();
});
}
</script>


<script>
$(document).ready(function()
{
$("#myBtn").click(function()
{
$("#myModal").modal();
});
});
</script>

</body>

</html>

- Faisal M. Gupron
- Ifan Firmansyah
- Yuli Krismawati

Sistem Manajemen dan Penggajian

0 Komentar untuk "Sistem Manajemen dan Penggajian"

Arsip Blog