class.php

<?php
    class Database {
    // properti
    private $dbHost="localhost";
    private $dbUser="root";
    private $dbPass="";
    private $dbName="44_digicom";

    // method koneksi mysql
    function connectMySQL() {
        mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
        mysql_select_db($this->dbName) or die ("Database Tidak Ditemukan di Server");
    }
    }
    class User {
    // Proses Login
    function cek_login($kode_com, $password) {
        $password = md5($password);
        $result = mysql_query("SELECT * FROM company WHERE kode_com='$kode_com' AND password='$password'");
        $user_data = mysql_fetch_array($result);
        $no_rows = mysql_num_rows($result);
        if ($no_rows == 1) {
            $_SESSION['login'] = TRUE;
            $_SESSION['kode_com'] = $user_data['kode_com'];
            return TRUE;
        }
        else {
          return FALSE;
    }
    }

    // Ambil Sesi
    function get_sesi() {
    return $_SESSION['login'];
    }

    // Logout
    function user_logout() {
    $_SESSION['login'] = FALSE;
    session_destroy();
    }
    }

    class Company {
    // Tampilkan data user yang login
    function tampilUserLogin() {
    $query = mysql_query("SELECT * FROM company WHERE kode_com='".$_SESSION['kode_com']."'");
    while($row=mysql_fetch_array($query))
    $data[]=$row;
    return $data;
    }
    }

    class Masterdoc {
    // Tampilkan data master dokumen
    function tampilMasterDoc() {
    $query = mysql_query("SELECT * FROM master_doc ");
    while($row=mysql_fetch_array($query))
    $data[]=$row;
    return $data;
    }

    // Menambah master doc
    function tambahMasterDoc($kode_doc,$nama_doc)
    {
    $query="INSERT INTO master_doc(kode_doc,nama_doc)
    VALUES('$kode_doc','$nama_doc')";
    $hasil= mysql_query($query);
    }

    //membaca data master
    function bacaMasterdoc ($field,$id_doc){
    $query=mysql_query("SELECT * FROM master_doc WHERE id_doc='$id_doc'");
    $data=mysql_fetch_array($query);
    if ($field == 'id_doc') return $data['id_doc'];
    else if ($field == 'kode_doc') return $data['kode_doc'];
    else if ($field == 'nama_doc') return $data['nama_doc'];
    }

    //update data master dokumen
    function updateMasterDoc ($id_doc,$kode_doc,$nama_doc){
    $query=mysql_query("UPDATE master_doc SET
    kode_doc='$kode_doc',nama_doc='$nama_doc' WHERE id_doc='$id_doc'");
    echo '<META HTTP-EQUIV="Refresh" Content="0; URL=?page=master_show">';

    }
    //method tampil combo Masterdoc
    function comboMasterDoc()
    {
    $query = mysql_query("SELECT * FROM master_doc");
    while($row=mysql_fetch_array($query))
    $data[]=$row;
    return $data;
    }
    }
    class Dokumen {
    // Tambah data dokumen
    function tambahDokumen($id_doc,$kode_com,$nomor,$date_star,$date_end,$date_post,$keterangan)
    {
    if($_POST){
    # Cek Kode dokumen di database
    $cek_id_doc=mysql_num_rows(mysql_query
    ("SELECT id_doc FROM dokumen WHERE id_doc='$_POST[id_doc]' AND kode_com='".$_SESSION['kode_com']."'"));
    # kode dokumen sudah ada
    if ($cek_id_doc > 0){
    echo "<script type='text/javascript'>window.alert('Dokumen  Sudah Pernah di Disimpan')</script>";
    }
    # Kalau nomor faktur belum ada silahkan di simpan
    else{
    $query="INSERT INTO dokumen(id_doc,kode_com,nomor,date_star,date_end,date_post,keterangan)
    VALUES('$id_doc','$kode_com','$nomor','$date_star','$date_end','$date_post','$keterangan')";
    $hasil= mysql_query($query);
    }
    }
    }

    //Tampilkan data dokumen berdasarkan sesion user
    function tampilDokumen() {
    $query = mysql_query("
    SELECT dokumen.id_dokumen, dokumen.id_doc, dokumen.kode_com, dokumen.nomor, dokumen.date_star, dokumen.date_end, dokumen.date_post, dokumen.keterangan,
    master_doc.id_doc, master_doc.kode_doc, master_doc.nama_doc
    FROM dokumen, master_doc
    WHERE dokumen.id_doc=master_doc.id_doc AND kode_com='".$_SESSION['kode_com']."'");
    while($row=mysql_fetch_array($query))
    $data[]=$row;
    return $data;
    }
    //Untuk menampilkan view data dokumen kepada semua user
    function viewDokumen() {
    $query = mysql_query("
    SELECT dokumen.id_dokumen, dokumen.id_doc, dokumen.kode_com, dokumen.nomor, dokumen.date_star, dokumen.date_end, dokumen.date_post, dokumen.keterangan,
    master_doc.id_doc, master_doc.kode_doc, master_doc.nama_doc,
    company.kode_com, company.nama_comp
    FROM dokumen, master_doc, company
    WHERE dokumen.id_doc=master_doc.id_doc AND dokumen.kode_com=company.kode_com AND company.kode_com='$_GET[kode_com]'");
    while($row=mysql_fetch_array($query))
    $data[]=$row;
    return $data;
    }
    //membaca data dokumen
    function bacaDokumen ($field,$id_dokumen){
    $query=mysql_query("
    SELECT dokumen.id_dokumen, dokumen.id_doc, dokumen.kode_com, dokumen.nomor, dokumen.date_star, dokumen.date_end, dokumen.date_post, dokumen.keterangan,
    master_doc.id_doc, master_doc.kode_doc, master_doc.nama_doc
    FROM dokumen, master_doc
    WHERE dokumen.id_doc=master_doc.id_doc AND id_dokumen='$id_dokumen'");
    $data=mysql_fetch_array($query);
    if ($field == 'id_dokumen') return $data['id_dokumen'];
    else if ($field == 'id_doc') return $data['id_doc'];
    else if ($field == 'nama_doc') return $data['nama_doc'];
    else if ($field == 'kode_com') return $data['kode_com'];
    else if ($field == 'nomor') return $data['nomor'];
    else if ($field == 'date_star') return $data['date_star'];
    else if ($field == 'date_end') return $data['date_end'];
    else if ($field == 'date_post') return $data['date_post'];
    else if ($field == 'keterangan') return $data['keterangan'];
    }
    //update Dokumen
    function updateDokumen ($id_dokumen,$id_doc,$kode_com,$nomor,$date_star,$date_end,$date_post,$keterangan){
    $query=mysql_query("UPDATE dokumen SET
    id_doc='$id_doc',
    kode_com='$kode_com',
    nomor='$nomor',
    date_star='$date_star',
    date_end='$date_end',
    date_post='$date_post',
    keterangan='$keterangan'
    WHERE id_dokumen='$id_dokumen'");
    echo '<META HTTP-EQUIV="Refresh" Content="0; URL=?page=doc_show">';
    }
    //Menghitung selisih hari tanggal dokumen
    function selisih($date_end){
    $sql="select datediff('".$date_end."',
    curdate())as diffdate";
    $result=mysql_query($sql);
    $row=mysql_fetch_array($result);
    return $row['diffdate'];
    }
    }
    //clas datafile
    class Datafile  {

    function tambahDatafile($id_dokumen,$nama_file,$gambar)
    {
    $query="INSERT INTO datafile(id_dokumen,nama_file,gambar)
    VALUES('$id_dokumen','$nama_file','$gambar')";
    move_uploaded_file($_FILES['gambar']['tmp_name'],"file_gambar/".$gambar);
    $hasil= mysql_query($query);
    }
    //menampilkan file
    function tampilDatafile() {
    $query = mysql_query("SELECT * FROM datafile WHERE id_dokumen='$_GET[id_dokumen]' ");
    while($row=mysql_fetch_array($query))
    $data[]=$row;
    return $data;
    }
    //Baca data file
    function bacaDatafile ($field,$kode_file){
    $query=mysql_query("SELECT * FROM datafile WHERE kode_file='$kode_file'");
    $data=mysql_fetch_array($query);
    if ($field == 'kode_file') return $data['kode_file'];
    else if ($field == 'id_dokumen') return $data['id_dokumen'];
    else if ($field == 'nama_file') return $data['nama_file'];
    else if ($field == 'gambar') return $data['gambar'];
    }
    }
?>