<?php

include_once "dbConfig.php";
class crud extends dbConfig{

    public function insert_pegawai(){

        $nip    = htmlspecialchars($_POST['nip']);
        $nama   = htmlspecialchars($_POST['nmPeg']);
        $gol    = htmlspecialchars($_POST['golPEg']);
        $gender = htmlspecialchars($_POST['jkPeg']);

        $cekNip = $this->db->prepare("SELECT * FROM ssh_pegawai WHERE peg_nip = ?");
        $cekNip->execute(array($nip));
        if($cekNip->rowCount() > 0){
            echo json_encode(array("pesan"=>'NIP Invalid'));
        }else{
            $sql = "INSERT INTO ssh_pegawai SET peg_nip = ?, peg_nama = ?, peg_gol = ?, peg_gender = ?";
            $stmt = $this->db->prepare($sql);
            $stmt->bindParam(1, $nip);
            $stmt->bindParam(2, $nama);
            $stmt->bindParam(3, $gol);
            $stmt->bindParam(4, $gender);
            $stmt->execute();
            /*ambil AUTO INCREMENT terakhir dari tabel ssh_pegawai*/
            $query = "SELECT LAST_INSERT_ID()";
            $stmt1 = $this->db->prepare($query);
            $stmt1->execute();
            while($r = $stmt1->fetch(PDO::FETCH_LAZY)){
                $ID = $r[0];
            }
            /*simpan ke tabel ssh_login*/
            $statusLog = htmlspecialchars($_POST['status']);
            $pass_u    = htmlspecialchars($_POST['logPass']);
            $query_login = "INSERT INTO ssh_login SET login_peg = ?, login_user = ?, login_status = ?, login_pass = ?";
            $stmt2 = $this->db->prepare($query_login);
            $stmt2->bindParam(1, $ID);
            $stmt2->bindParam(2, $nip);
            $stmt2->bindParam(3, $statusLog);
            $stmt2->bindParam(4, password_hash($pass_u, PASSWORD_DEFAULT));
            $stmt2->execute();
            echo json_encode(array("pesan"=>'Sukses'));
        } /*End If*/

    }

} //end class