global_priv WARNING Selalu

 Jika muncul pesan kesalahan:

Warning in .\libraries\classes\Dbal\DbiMysqli.php#209  mysqli::query(): (HY000/1034): Index for table 'global_priv' is corrupt; try to repair it bagaimana solusinya?

Solusi:

pada DATABASE MYSQL->GLOBAL_PRIV lakukan OPERASI-REPAIR

 

Mencari Tanggal Terakhir Suatu Bulan

 

$a_date = "$tahun-$bulan-01";
$lastdate= date('t',strtotime($a_date));//Y-m-t

<?php
require_once"koneksivar.php";

$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
if ($conn->connect_error) {
  trigger_error('Database connection failed: '  . $conn->connect_error, E_USER_ERROR);
}

function cekWeek($hari){
$kategori="Weekday";
if($hari=="Sabtu"||$hari=="Minggu"){
$kategori="Weekend";
}
return $kategori;
}
function getHari($tanggal){
$dayOfWeek = date("l", strtotime($tanggal));
$hari="Minggu";
if($dayOfWeek=="Sunday"){$hari="Minggu";}
elseif($dayOfWeek=="Monday"){$hari="Senin";}
elseif($dayOfWeek=="Tuesday"){$hari="Selasa";}
elseif($dayOfWeek=="Wednesday"){$hari="Rabu";}
elseif($dayOfWeek=="Thursday"){$hari="Kamis";}
elseif($dayOfWeek=="Friday"){$hari="Jumat";}
elseif($dayOfWeek=="Saturday"){$hari="Sabtu";}
return $hari;//."/$dayOfWeek"
}
?>
<script src="ypathcss/sweetalert/sweetalert3.all.min.js"></script>
<link rel="stylesheet" href="ypathcss/sweetalert/sweetalert2.min.css">

<?php function RP($rupiah){return number_format($rupiah,"2",",",".");}?>
<?php
function WKT($sekarang){
$tanggal = substr($sekarang,8,2)+0;
$bulan = substr($sekarang,5,2);
$tahun = substr($sekarang,0,4);

$judul_bln=array(1=> "Januari", "Februari", "Maret", "April", "Mei","Juni", "Juli", "Agustus", "September","Oktober", "November", "Desember");
$wk=$tanggal." ".$judul_bln[(int)$bulan]." ".$tahun;
return $wk;
}
?>
<?php
function WKTP($sekarang){
$tanggal = substr($sekarang,8,2)+0;
$bulan = substr($sekarang,5,2);
$tahun = substr($sekarang,2,2);

$judul_bln=array(1=> "Jan", "Feb", "Mar", "Apr", "Mei","Jun", "Jul", "Agu", "Sep","Okt", "Nov", "Des");
$wk=$tanggal." ".$judul_bln[(int)$bulan]."'".$tahun;
return $wk;
}
?>
<?php
function BAL($tanggal){
$arr=explode(" ",$tanggal);
if($arr[1]=="Januari"||$arr[1]=="January"){$bul="01";}
else if($arr[1]=="Februari"||$arr[1]=="February"){$bul="02";}
else if($arr[1]=="Maret"||$arr[1]=="March"){$bul="03";}
else if($arr[1]=="April"){$bul="04";}
else if($arr[1]=="Mei"||$arr[1]=="May"){$bul="05";}
else if($arr[1]=="Juni"||$arr[1]=="June"){$bul="06";}
else if($arr[1]=="Juli"||$arr[1]=="July"){$bul="07";}
else if($arr[1]=="Agustus"||$arr[1]=="August"){$bul="08";}
else if($arr[1]=="September"){$bul="09";}
else if($arr[1]=="Oktober"||$arr[1]=="October"){$bul="10";}
else if($arr[1]=="November"){$bul="11";}
else if($arr[1]=="Nopember"){$bul="11";}
else if($arr[1]=="Desember"||$arr[1]=="December"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>


<?php
function BALP($tanggal){
$arr=split(" ",$tanggal);
if($arr[1]=="Jan"){$bul="01";}
else if($arr[1]=="Feb"){$bul="02";}
else if($arr[1]=="Mar"){$bul="03";}
else if($arr[1]=="Apr"){$bul="04";}
else if($arr[1]=="Mei"){$bul="05";}
else if($arr[1]=="Jun"){$bul="06";}
else if($arr[1]=="Jul"){$bul="07";}
else if($arr[1]=="Agu"){$bul="08";}
else if($arr[1]=="Sep"){$bul="09";}
else if($arr[1]=="Okt"){$bul="10";}
else if($arr[1]=="Nov"){$bul="11";}
else if($arr[1]=="Nop"){$bul="11";}
else if($arr[1]=="Des"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>


<?php
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
  $rs = $conn->query($sql);
  if($rs){
    $conn->commit();
    $last_inserted_id = $conn->insert_id;
  $affected_rows = $conn->affected_rows;
   $s=true;
  }
} 
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
   $conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}
function cekR($v1,$v2){
$v=rand($v1,$v2);
$x=$v;
if($v<10){$x="0".$v;}
return $x;
}
function getJum($conn,$sql){
  $rs=$conn->query($sql);
  $jum= $rs->num_rows;
$rs->free();
return $jum;
}

function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
//  echo $row['nama_kelas'] . '*<br>';
//}
$rs->free();
return $arr;
}

function getAdmin($conn,$kode){
$field="nama_admin";
$sql="SELECT `$field` FROM `tb_admin` where `id_admin`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
    return $row[$field];
}
function getKaryawan($conn,$kode){
$field="nama_karyawan";
$sql="SELECT `$field` FROM `tb_karyawan` where `id_karyawan`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assaoc();
$rs->free();
    return $row[$field];
}
function getRekanan($conn,$kode){
$field="nama_rekanan";
$sql="SELECT `$field` FROM `tb_rekanan` where `id_rekanan`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
    return $row[$field];
}
function getMesin($conn,$kode){
$field="nama_rekanan";
$sql="SELECT `$field` FROM `tb_rekanan` where `id_mesin`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
    return $row[$field];
}
?>
============================
Implementasi:
$d=getField($conn,$sql);
$id_absensi=$d["id_absensi"];
$tanggal_masuk=WKT($d["tanggal_masuk"]);
$jam_masuk=$d["jam_masuk"];
$jam_pulang=$d["jam_pulang"];
$status=$d["status"];
$keterangan=$d["keterangan"]; 
$hari=$d["hari"]; 
$kategori=$d["kategori"]; 
$lamakerja=$d["lamakerja"]; 
$lembur=$d["lembur"]; 
$kalibrasi=$d["kalibrasi"]; 
$catatan=$d["catatan"]; 
$notes="Working Hour";
$ar1=explode(":",$jam_masuk);
$j1=$ar1[0]+0;if($j1==0){$j1=24;}
$m1=$ar1[1];
$selj=$jammasuknormal-$j1;
$menj=60-$m1;
$early="$selj:$menj";
if($selj<0){//terlambat
$late=abs($selj).":$menj";
$early="";
} 
else{
$late="";
}
$ar2=explode(":",$jam_pulang);
$j2=$ar2[0]+0;if($j2==0){$j2=24;}
$m2=$ar2[1];
$selj=$j2-$j1;
$selm=abs($m2-$m1);if($selm<10){$selm="0".$selm;}
$effect="$selj:$selm";
}

=================

if($simpan === TRUE) {
echo"<script>berhasil('absensi','Sukses Simpan');</script>";}
else{echo"<script>gagal('absensi','Gagal Simpan');</script>";

}

Atau dari ref:
https://stackoverflow.com/questions/1686724/how-to-find-the-last-day-of-the-month-from-date

COUNT DOWN WAKTU

 Bersumber dari mari:

https://blog.rosihanari.net/membuat-countdown-menuju-tanggal-dan-waktu-tertentu-dengan-ajax/

date.php

<?php

//mengatur time zone untuk WIB.
date_default_timezone_set("Asia/Jakarta");
 
// mencari mktime untuk tanggal 1 Januari 2023 00:00:00 WIB
//$selisih1 =  mktime(0, 0, 0, 1, 1, 2011);
//$selisih1 =  mktime(0, 0, 0, 1, TGL, 2011);
 $selisih1 =  mktime(0, 0, 0, 8, 30, 2023);

// mencari mktime untuk current time
$selisih2 = mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y"));
 
// mencari selisih detik antara kedua waktu
$delta = $selisih1 - $selisih2;
 
// proses mencari jumlah hari
$a = floor($delta / 86400);
 
// proses mencari jumlah jam
$sisa = $delta % 86400;
$b  = floor($sisa / 3600);
 
// proses mencari jumlah menit
$sisa = $sisa % 3600;
$c = floor($sisa / 60);
 
// proses mencari jumlah detik
$sisa = $sisa % 60;
$d = floor($sisa / 1);
 
echo "Waktu saat ini: ".date("d-m-Y H:i:s")."<br>";
echo "Masih: ".$a." hari ".$b." jam ".$c." menit ".$d." detik lagi, 
menuju tahun baru 25 Agustus 2023";
 
?>

LALU PADA Index.php

<script type="text/javascript">
   
  function ajax() {
     if (window.XMLHttpRequest)
     {
       // untuk IE7+, Firefox, Chrome, Opera, Safari
       xmlhttp=new XMLHttpRequest();
     }
     else
     {
       // untuk IE6, IE5
       xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
     }
   
     xmlhttp.onreadystatechange=function()
     {
        if (xmlhttp.readyState==4 && xmlhttp.status==200)
        {
          // hasil pembacaan script date.php akan ditampilkan di komponen id="hasil"
          document.getElementById("ReloadThis").innerHTML = xmlhttp.responseText;
        }
     }
   
     // menjalankan script date.php secara asynchronous
     xmlhttp.open("GET","date.php", true);
     xmlhttp.send();
 
     // refresh time 1 detik (1000 ms)
     setTimeout("ajax()", 1000);
  }  
  </script>
  
</head>
<body onload="ajax()">

ATAU

<script type="text/javascript">
function Ajaxs(){
var $http,$self = arguments.callee;

if (window.XMLHttpRequest) {$http = new XMLHttpRequest();} 
else if (window.ActiveXObject) {
try {$http = new ActiveXObject('Msxml2.XMLHTTP');} 
catch(e) {$http = new ActiveXObject('Microsoft.XMLHTTP');}
}

if ($http) {
$http.onreadystatechange = function(){
if (/4|^complete$/.test($http.readyState)) {
document.getElementById('ReloadThis').innerHTML = $http.responseText;
setTimeout(function(){$self();}, 1000);
}
};
$http.open('GET', 'time.php' + '?' + new Date().getTime(), true);
$http.send(null);
}
}
</script>
<script type="text/javascript">setTimeout(function() {Ajaxs();}, 1000);</script>

1. 
   

CEK Tanggal EXPIRE

 

data bisa dari
20-Aug-2023
2023-08-20

<?php

$tgl=BAL($_POST["tanggal_selesai"]);
$startdate = $tgl;
$expire = strtotime($startdate. ' + 1 days');//1 hari kemudian Penanda exire

$today = strtotime("today midnight");

if($today >= $expire){

    echo "SUDAH HABIS MASA WAKTUNYA....";

} else {

    echo "LANJUTKAN>>>>Msh ada Waktu...";

}

?>

CODE LAIN:

if(!isset($_SESSION["cid"])){

die("<script>location.href='login.php';</script>");

}

<?php

$kode_tx="PND-9642";

$ada=cekKode($kode_tx,"PND");

echo $ada;

function cekKode($kode_tx,$init){

$cek=strstr($kode_tx,$init);

$ada=strlen($cek)+0;

return $ada;

}

?>

https://www.codeleaks.io/initialize-an-array-in-php/

 <?php 

    $apples = array("Fuji", "McIntosh", "Red Delicious", "Gala", "Jonagold");

        

    foreach( $apples as $apple ) {

      echo "$apple is a type of apple <br/> <br/>";

    }

  ?>   

  

  <?php 

    $apples = ["Fuji", "McTntosh"]; 

    //This is how you can add values after initializing it.

    $apples[] = "Red Delicious";

    $apples[] = "Gala";

    $apples[] = "Jonagold";

        

    foreach( $apples as $apple ) {

      echo "$apple is a type of apple <br/> <br/>";

    }

 ?>   

  

   <?php 

    $CurrentVersions = [

      "php" => "7.4.5",

      "python" => "3.7",

      "java" => "14",

      "C#" => "8.0",

    ];

  ?>  

  

  <?php 

    $CurrentVersions["php"] = "7.4.5";

    $CurrentVersions["python"] = "3.7";

    $CurrentVersions["java"] = "14";

    $CurrentVersions["C#"] = "8.0";

  ?>  

   <?php 

    $CurrentVersions = [

      "php" => "7.4.5",

      "python" => "3.7",

      "java" => "14",

      "C#" => "8.0",

    ];

    echo $CurrentVersions["php"];

    foreach ($CurrentVersions as $lang => $version) {

      echo "<br/> <br/> latest Version of $lang is $version";

    }

  ?>  

 <?php

  $books = [

    "THIS EXPLAINS EVERYTHING" => [

      "author" => "John Brokman",

      "Release date" => "January 22,2013",

      "Price" => "$11.99"

    ],

    "YOU ARE STARDUST" => [

      "author" => "Elin kelsey",

      "Release date" => "September 12,2012",

      "Price" => "$13.29"

    ],

    "THINKING IN NUMBERS" => [

      "author" => "Daniel Tammet",

      "Release date" => "2012",

      "Price" => "$10.29"

    ]

  ];

  echo "You are Stardust is written by " . $books["YOU ARE STARDUST"]["author"];

  echo "<br/> Thinking in number was released on " .$books["THINKING IN NUMBERS"]["Release date"];

    ?>   

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

LINK Belajar

CEH 11 Exam Objectives : https://youtu.be/A_Oq_226-0E

Dimana tempat kursus Microsoft dan Windows Server : https://youtu.be/hnasbAmWtic

Dimana tempat kursus MikroTik : https://youtu.be/6tRlScTw0k8

Dimana tempat kursus DBA Database Administrator : https://youtu.be/DF6Vb8sgbck

Cara Menjadi Network Engineer : https://youtu.be/z6Ftup9ngT8

7 Resep Sukses Anti Gagal : https://youtu.be/BpCzIEcCsEo

Project Management Certification : https://youtu.be/gnBuq5jEY2c

Sales TI : https://youtu.be/HHVBBN95QFc

Cara Menjadi DBA : https://youtu.be/vvtwIMYuu0k

Pro dan kontra bukan IT : https://youtu.be/zzdge77oKT8

CHFI : https://youtu.be/6jSaKLscWwE@ @87

Guru TI : https://youtu.be/7omxhNrFwTc

Gaji Seorang DBA : https://youtu.be/KN6TMhHvxjg

Kursus Teknologi Informasi dimana : https://youtu.be/z5OgBOEg88w

CEH Practical : https://youtu.be/nETqOkhJiXg

CEH versi 11 Certification : https://youtu.be/6GhOvub3Anw

IT Certification 2021 : https://youtu.be/L18N1DnIDwY

7 Tips Percaya Diri : https://youtu.be/SCbT1QgY3e0

IT Security Certification 2021 : https://youtu.be/UF0x0nQ5RFc

Sertifikasi Microsoft Office : https://youtu.be/xYB0LPVCtw8

Ada Apa di Nanang Sadikin Official : https://youtu.be/2h7jSdRs9xA

7 Softskill Sukses : https://youtu.be/tqB0k8BB3go

Microsoft Certified Educator : https://youtu.be/6QRl5aY5hrw

International Certification for DBA : https://youtu.be/8wYWvgjWlO8

7 Tips Sukses DBA : https://youtu.be/czcDHZmRsTU

Comptia Cyber Security Analyst+ : https://youtu.be/T70DDz_5oYM

Juniper JNCIP Security : https://youtu.be/LtgChnxbahQ

Sertifikasi Veritas : https://youtu.be/ffOQMZN0d1E

Negosiasi gaji : https://youtu.be/DScCce4xCng

Sertifikasi JNCIS Security : https://youtu.be/C45zHX_0MKI

Sertifikasi ITIL Foundation : https://youtu.be/4Cklmk9h-OY

Mengenal Profesi System Administrator : https://youtu.be/e0qFTxsvKLM

Sertifikasi jncia security : https://youtu.be/X9Tw0oKhxkw

Full Stack dan DBA : https://youtu.be/-e9jOFmcRuA

Sertifikasi CND Certified Network Defender EC-Council : https://youtu.be/Kgeuyts1LRA

Wirausaha Sukses di Bidang Apapun : https://youtu.be/xAbcoF8PfSU

Naik Gaji Tiga Kali Lipat Dalam Waktu Dua Tahun atau Kurang (Dalam Waktu Singkat) : https://youtu.be/dRlxB_P-yI4

10.000 Jam Terbang Bukan Hanya Pilot : https://youtu.be/zChIl9_ZRD4

Buku Nanang Sadikin : https://youtu.be/yjQSHlf1rok

CV yang menjual itu bagaimana? : https://youtu.be/nEpw_glgUy4

Sertifikasi CCNP Security New Certification 2020 : https://youtu.be/NwTGE8kAICU

Berapa Sih Gaji Orang IT di Indonesia? : https://youtu.be/Jfa5Xy0kpKM7

Sertifikasi CCNP Collaboration New Certification 2020 : https://youtu.be/ONb6PomYFdw

7 Skill IT yang Dibutuhkan di Era Revolusi Industri 4.0 : https://youtu.be/tcijFlgy2-Y

Sertifikasi VMware VCP6-DCV 2020 : https://youtu.be/K09H3k3lGqI

Sertifikasi CCNP Enterprise 350-401 New Certification 2020 : https://youtu.be/llMdiP0ck6I

Sertifikasi CCNA 200-301 New Certification 2020 : https://youtu.be/gjXbFovZkTE

2020 Hot IT Certification : https://youtu.be/PucIvBUu4-k

Sertifikasi CompTIA Cloud Essentials : https://youtu.be/PHr5HI1U4N0

Sertifikasi CompTIA Cloud+ : https://youtu.be/T5qgYYnQpnA

Sertifikasi CompTIA IT Fundamentals+ : https://youtu.be/qGg6bbhN5Yc

Sertifikasi CompTIA Network+ ID : https://youtu.be/Jw26KgpPcuA

Sertifikasi CompTIA Security+ - EN : https://youtu.be/iki1XBsx2kY

Sertifikasi CompTIA Security+ - ID : https://youtu.be/twyEnnE_710

Sertifikasi Microsoft Power Platform Fundamentals : https://youtu.be/l8iWCKBZshY

Sertifikasi Microsoft Dynamics 365 Fundamentals : https://youtu.be/GtnecZcFrDo

Sertifikasi Microsoft 365 Fundamentals : https://youtu.be/Ps82pM-KIfI

Sertifikasi Microsoft Azure Fundamentals : https://youtu.be/7nBvQpRUqAY

Sertifikasi Cisco DevNet : https://youtu.be/XdioQtnVI50

Sertifikasi Fortinet : https://youtu.be/xn14oQAp36g

Sertifikasi Juniper : https://youtu.be/u5ATY4Eoix8

Premiere Tips - Tips Lulus Ujian Sertifikasi Internasional : https://youtu.be/jume6wjNeMQ

Sertifikasi VMWare : https://youtu.be/ht8ngrPs_tw

Sertifikasi Linux LPI : https://youtu.be/JrE85JniznI

Sertifikasi ISC : https://youtu.be/AC3cFZBMUCQ

Sertifikasi MikroTik : https://youtu.be/MwezHiiXZaA

Sertifikasi Oracle : https://youtu.be/O_VDPd2RDpo

Sertifikasi RedHat : https://youtu.be/hSvl9YYEMM4

Sertifikasi BNSP : https://youtu.be/zEC2kRZQloE

Sertifikasi Internasional Microsoft : https://youtu.be/2JYmMAsUhWI

Sertifikasi Internasional Cisco : https://youtu.be/zIgl290cr8o

Sertifikasi Internasional CompTIA : https://youtu.be/VQ94Bje26Dg

Mengenal Profesi Data Scientist : https://youtu.be/5aDyfv6cGIk

Mengenal Profesi IT Director : https://youtu.be/ymUs78iMWxY

Mengenal Profesi IT Lecturer : https://youtu.be/LDyVmT8TiPY

Mengenal Profesi CAD Engineer : https://youtu.be/ennWOkRgWv4

Mengenal Profesi Animator : https://youtu.be/eveiCqirXhc

Mengenal Profesi ERP Consultant : https://youtu.be/rxUDGCp9ANc

Mengenal Profesi Graphic Designer : https://youtu.be/-lxC1e4YAgU

Mengenal Profesi IT Manager : https://youtu.be/ThyzI4kYrUo

Mengenal MSI : https://youtu.be/aktaEa4ay3I

Mengenal Profesi IT Writer : https://youtu.be/MC

Mengenal Profesi System Analyst : https://youtu.be/Z-5EClgXX74

Mengenal Profesi Project Manager : https://youtu.be/rzMjgIyC1pc

Mengenal Profesi DBA : https://youtu.be/5RHOrBAv1UU

Mengenal Profesi Programmer : https://youtu.be/Im2IoLKFoEM

Mengenal Profesi Security Engineer : https://youtu.be/aFUruBuz_jU

Lagi Viral Gaji 8 Juta Ditolak : https://youtu.be/2XvSsJqXo_s

Mengenal Profesi Systems Engineer : https://youtu.be/Lk-JUbTsjQw

Mengenal Profesi Network Engineer : https://youtu.be/M_kkYdeVuVQ

Mengenal Profesi Technical Support : https://youtu.be/r6o2DmQvV5Y

Berbagai Jenis Profesi TI Bagian 3 : https://youtu.be/RRT6vW_3XFc

Berbagai Jenis Profesi TI Bagian 2 : https://youtu.be/cKYCwvOtlAI

Berbagai Jenis Profesi TI Bagian 1 : https://youtu.be/wxT4dWgPREM

Kiat Sukses S2 S3 : https://youtu.be/NFandO3oAUE

Kiat Sukses di Dunia TI : https://youtu.be/uLGp9bllU-M

SOLUSI MYSQL XAMPP GAGAL START

 https://stackoverflow.com/questions/18022809/how-to-solve-error-mysql-shutdown-unexpectedly

1. Stop MySQL.
2. Go to the C:/xampp/mysql directory and copy the data folder and keep it somewhere else (probably in another drive) as a backup.
3. Go to your original data folder (C:/xampp/mysql) and sort the files by 'Type.'
4. Select the files that have the type INFO File and delete them (screenshot below).
5. Start MySQL. It should work now.

JIKA SBB

Pada CLI JALANKAN

C:\xampp\mysql\bin>mysql_upgrade.exe

Sehingga Normal lagi:

jika tabelnya pada kosong....
Kembalikan file ibdata1 ke aslinya

Laravel Kisi-Kisi

 SESSION:
<?php
use Illuminate\Http\Request;
use DB;
use Session;

if (session()->has('id_order')) {
            $id_order =     Session::get('id_order');
}
 $id_pengguna = Session::get('id_pengguna');
 
 
  protected function LoginPengguna(Request $request){
        $username    = $request->username;
        $password = $request->password;

        $data = Pengguna::where('username', $username)->first();

        if (count((array) $data) > 0) {

            if ($password == $data->password) {
                Session::put('id_pengguna',   $data->id_pengguna);
                Session::put('nama_pengguna', $data->nama_pengguna);
                Session::put('level',         $data->level);
                Session::put('telepon',       $data->telepon);
                Session::put('email',         $data->email);
                Session::put('username',      $data->username);
                Session::put('passsword',     $data->passsword);
                Session::put('status',        $data->status);
                Session::put('login',      TRUE);

                if ($data->status == "Aktif") {
                    return redirect('dashboard_pengguna')->with('success', 'Berhasil Login');
                }
            } else {
                return redirect('login')->with('success', 'Gagal ! Password salah.');
            }
        } else {
            return redirect('login')->with('success', 'Gagal ! Email belum terdaftar.');
        }
    }
//=============================== 
public function profil(){
$id_customer = Session::get('id_customer');
$customer = DB::table('tb_customer')->where('id_customer', '=', $id_customer)->first();
return view('customer.profil')->with('customer', $customer);
}
?>
{{ $customer->alamat }}

 <form method="post" action="{{ route('customer.updateprofil') }}" enctype="multipart/form-data">
@csrf
<table>
</table>
 </form>
WEB
Route::post('updateprofil', 'App\Http\Controllers\DashboardController@updateProfil')->name('customer.updateprofil');

   public function updateProfil(Request $request) {
        $result = DB::table('tb_customer')
            ->where('id_customer', $request->id_customer)
            ->update(
                [
                    'nama_customer' => $request->nama_customer,
                    'alamat'       => $request->alamat,
                    'telepon'      => $request->telepon,
                    'email'        => $request->email,
                    'username'     => $request->username,
                    'password'     => $request->password
                ]
            );
        return redirect()->route('customer.profil')->with('pesan', "Update data berhasil");
    }
                             
=======================================
<select class="form-control selectpicker" data-live-search="true" name="id_produk">
@foreach ($produks as $getDT)
<option value="{{ $getDT->id_produk }}" @if($getDT->id_produk==$orderdetail->id_produk)
selected
@endif
>{{ $getDT->nama_produk}} |{{ RP($getDT->harga)}}</option>
@endforeach
</select>

=======================================
VIEW order.php:
<a href="orderdetail/{{ $order->id_order }}">DETAIL</a>
<a href="konfirmasi/{{ $konfirmasi->id_konfirmasi }}">DETKONF</a>
<a href="pengiriman/{{ $pengiriman->id_pengiriman }}">DETPENG</a>
WEB.php:
Route::get('orderdetail/{id}', 'App\Http\Controllers\
OrderdetailController@getDetail');

<?php
 public function getDetail($id)  { 
$sql0 = "SELECT * FROM tb_order where `id_order`='" . $id . "'"; 
     $order = DB::select($sql0); 
        
$sql1 = "SELECT * FROM tb_produk,tb_orderdetail WHERE
               tb_produk.id_produk=tb_orderdetail.id_produk AND 
               tb_orderdetail.`id_order`='" . $id . "'"; 
     $orderdetail = DB::select($sql1); 

     $sql2 = "SELECT * FROM tb_produk where `status`='Tersedia'"; 
     $produk = DB::select($sql2); 
 
  $sql3 = "SELECT * FROM tb_konfirmasi where `id_konfirmasi`='" . $id_konfirmasi . "'"; 
     $konfirmasi = DB::select($sql0); 
 
   $sql4 = "SELECT * FROM tb_pengiriman where `id_pengiriman`='" . $id_pengiriman . "'"; 
     $pengiriman = DB::select($sql0); 
        
        return view('admin.orderdetail.index', 
['orders' => $order, 
'orderdetails' => $orderdetail, 
'produks' => $produk
]);
    }
 
?>
VIEW DETAIL.php

<tbody>
@forelse ($orderdetails as $orderdetail)
<tr>
<td class="text-center">{{$loop->iteration}}</td>
<td><img src="{{ url('ypathfile/'.$orderdetail->gambar)}}" width="100px" height="70px"></td>
<td>{{$orderdetail->nama_produk}}</td>
<td>{{$orderdetail->jumlah}}</td>
<td>{{ RP($orderdetail->subtotal) }}</td>
<td>{{$orderdetail->catatan}}</td>
<td class="text-center">
<div>
<a href="#edit{{ $orderdetail->id }}" data-toggle="modal"><i class="fa fa-edit text-warning"></i></a>

<a href=" #del{{ $orderdetail->id }}" data-toggle="modal"><i class="fa fa-trash text-danger"></i></a>

<a href=" #del{{ $konfirmasi->id_konfirmasi }}" data-toggle="modal"><i class="fa fa-trash text-danger"></i></a>
@include('admin.orderdetail.modal')
</div>

</td>
</tr>
@empty
<td colspan=" 8" class="text-center">Tidak ada data...
</td>
@endforelse
</tbody>

===============================================
@forelse ($konfirmasis as $getDT)
Id_Konfirmasi :{{ ($getDT->id_konfirmasi)}} |{{ $getDT->id_konfirmasi}}<br>
Id_Order :{{ $getDT->id_order}}, pesan {{ $getDT->pesan}}<br>
@empty 
 
@endforelse

==============================================
SAAT LINK KONFIRMASI DI KLIK
<a class="nav-link" href="/konfirmasis">KONFIRMASI</a>

WEB
Route::resource('konfirmasis', 'App\Http\Controllers\KonfirmasiController');

conrotoller KonfirmasiController
    public function index() { 
        $sql = "select * from tb_konfirmasi,tb_order where tb_konfirmasi.id_order=tb_order.id_order";
        $konfirmasis = DB::select($sql); 
        
        $sql = "select * from tb_order";
        $orders = DB::select($sql); 
        
        return view('admin.konfirmasi.index', ['konfirmasis' => $konfirmasis, 'orders' => $orders]);
    }


@empty
<td colspan=" 8" class="text-center">Tidak ada data...
</td>
@endforelse
</tbody>

===============================================
VIEW1
<a class="nav-link" href="/pengirimans">PENGIRIMAN</a>

WEB
Route::resource('pengirimans', 'App\Http\Controllers\PengirimanController');

CONTROLER: PengirimanController.php
<?php
    public function index()  {
        $sql = "select * from tb_pengiriman";
        $pengirimans = DB::select($sql);
   
        $sql = "select * from tb_order";
        $orders = DB::select($sql); 
        
        $sql = "select * from tb_kurir";
        $kurirs = DB::select($sql); 
        
        return view('admin.pengiriman.index', ['pengirimans' => $pengirimans, 'orders' => $orders, 'kurirs' => $kurirs]);
    }
?>
VIEW2
<tbody>
@forelse ($pengirimans as $pengiriman)
<tr>
<td class="text-center">{{$loop->iteration}}</td>
<td>{{getKurir($pengiriman->id_kurir) }} |IDK-0{{$pengiriman->id_kurir}}</td>
<td>{{ WKTP($pengiriman->tanggal) }} - {{$pengiriman->jam}} WIB</td>
<td>{{$pengiriman->pesan}}</td>
<td>{{$pengiriman->status}}</td>
<td>{{$pengiriman->keterangan}}</td>
<td class="text-center">
<div>
<a href="#edit{{ $pengiriman->id_pengiriman }}" data-toggle="modal"><i class="fa fa-edit text-warning" title="edit"></i></a>

<a href="#del{{ $pengiriman->id_pengiriman }}" data-toggle="modal"><i class="fa fa-trash text-danger" title="hapus"></i></a>
@include('admin.pengiriman.modal')
</div>

</td>
</tr>
@empty
<td colspan="8" class="text-center">Tidak ada data...</td>
@endforelse
</tbody>


<select class="form-control selectpicker" data-live-search="true" name="id_kurir">
@foreach ($kurirs as $kurir)
<option value="{{ $kurir->id_kurir }}">{{ $kurir->nama_kurir}} |{{ $kurir->id_kurir}}</option>
@endforeach
</select>

<?php
function getKurir($kode)
{
    $sql = "SELECT `nama_kurir` FROM `tb_kurir` WHERE `id_kurir`= '" .$kode . "'";
    $results = DB::select($sql);
    $hasil = $results[0]->nama_kurir;
    return $hasil;
}

ATAU

@forelse ($orders as $getDT)
Nama :{{ getCustomer($getDT->id_customer)}} |{{ $getDT->id_customer}}<br>
Alamat :{{ $getDT->alamat}}, telp {{ $getDT->telepon}}<br>
@empty 
 
@endforelse

?>
==============================================
SAAT LINK KONFIRMASI DI KLIK
<a class="nav-link" href="/konfirmasis">KONFIRMASI</a>

WEB
Route::resource('konfirmasis', 'App\Http\Controllers\KonfirmasiController');

conrotoller KonfirmasiController.php
<?php
    public function index() { 
        $sql = "select * from tb_konfirmasi,tb_order where tb_konfirmasi.id_order=tb_order.id_order";
        $konfirmasis = DB::select($sql); 
        
        $sql = "select * from tb_order";
        $orders = DB::select($sql); 
        
        return view('admin.konfirmasi.index', ['konfirmasis' => $konfirmasis, 'orders' => $orders]);
    }

?>

==========================
<form action="{{ route('pengirimans.store') }}" method="POST">


</for>

LANGSUNG KE CONTROLLER TANPA KE WEB
<?php
  public function store(Request $request) {
        $request->validate([
            'pesan'          => 'required' 
        ]);

        $pengiriman = new Pengiriman();
        $pengiriman->tanggal       = date("Y-m-d");
        $pengiriman->jam           = date("H:i:s");
        $pengiriman->id_order      = $request->id_order;
        $pengiriman->id_kurir      = $request->id_kurir;
        $pengiriman->pesan         = $request->pesan;
        $pengiriman->status        = $request->status;
        $pengiriman->keterangan    = $request->keterangan;
        $pengiriman->save();

        return redirect()->route('pengirimans.index')->with('pesan', 'Simpan Data Pengiriman Berhasil.');
    }
?>

======================================
VIEW1
<a href="#edit{{ $pengiriman->id_pengiriman }}" data-toggle="modal">
<i class="fa fa-edit text-warning" title="edit"></i></a>



VIEW2
<form action="{{ route('konfirmasis.update',['konfirmasi' => $konfirmasi->konfirmasi]) }}" method="POST" enctype="multipart/form-data">

======================================

DELETE
 @forelse ($orders as $order)
<a href="#del{{ $order->id_order }}" data-toggle="modal">DEL</a>
.....
 @empty
 @endforelse
 
 MODAL:
 
<form action="{{ route('orders.destroy', $order->id_order) }}" method="POST">
@method('DELETE')
@csrf
<button type="submit" class="btn btn-danger ml-3">Delete</button>
</form>
LANGSUNG KE CONTROLLER
public function destroy($id){
DB::table('tb_order')->where('id_order', '=', $id)->delete(); 
return redirect()->route('orders.index')->with('pesan', "Hapus data berhasil");
}
======================
ONE TO MANY
<a href="orderdetail/{{ $order->id_order }}">DETAIL</a><br>

================
 $id_pengguna = Session::get('id_pengguna');
 $pengguna = DB::table('tb_pengguna')->where('id_pengguna', '=', $id_pengguna)->first();

 
 








                             





 
 
 

•