Kuncian Laravel

 Helpers->helper.php

<?php

//$username=Session::get('key');

//https://laravel.com/docs/8.x/queries#aggregates

//https://blog.quickadminpanel.com/5-ways-to-use-raw-database-queries-in-laravel

/*

Selamat Datang {{ Auth::user()->level }} : {{ Auth::user()->name }}

@if (session('status'))

<div class="alert alert-succes s" role="alert">

{{ session('status') }}

</div>

@endif

@extends('layouts.app')

@section('content')

*/

function getOngkir($kode){ 

$rp=20000;

if($kode=="Luar Jabodetabek"){$rp=30000;}

return $rp;

}

function getKategori($kode){ 

$hasil=\App\Kategori::find($kode)->value('nama_kategori');//BEST

return $hasil;

}

function getNominalJual($kode){ 

$results = DB::table('penjualan')->select('id_pelanggan','total','wilayah')->where('id_penjualan','=', $kode)->first();

$pelanggan=getPelanggan2($results->id_pelanggan);

$total=RP($results->total);

$wilayah=$results->wilayah;

return "$pelanggan $wilayah ->".$total;

}

function getListJual($kode){ 

$sql= "SELECT `jdetail`.`id_barang`,`jdetail`.`jumlah`,`jdetail`.`subtotal`,`penjualan`.`ongkir` FROM `penjualan`,`jdetail` WHERE `penjualan`.`id_penjualan`=`jdetail`.`id_penjualan` and `penjualan`.`id_penjualan`= '$kode'";

    $results = DB::select($sql);

$gab="";

$total=0;

$ongkir=0;

foreach($results as $i){

$id_barang= $i->id_barang;

$jumlah= $i->jumlah;

$ongkir= $i->ongkir;

$subtotal= $i->subtotal;

$nb=getNamaBarang($id_barang);

$gab.="$nb ($jumlah),";

$total+=$subtotal;

}

$gab.="Total:".RP($total).",Ongkir:".RP($ongkir);

return $gab;

}

function getTotal($kode){ 

$sql= "SELECT `jdetail`.`subtotal`  FROM `penjualan`,`jdetail` WHERE `penjualan`.`id_penjualan`=`jdetail`.`id_penjualan` and `penjualan`.`id_penjualan`= '$kode'";

    $results = DB::select($sql);

$total=0;

foreach($results as $i){

$subtotal= $i->subtotal;

$total+=$subtotal;

}

return $total;

}

function getListMasuk($kode){ 

$sql= "SELECT `mdetail`.`id_barang`,`mdetail`.`jumlah`,`mdetail`.`subtotal` FROM `pemasukan`,`mdetail` WHERE `pemasukan`.`id_pemasukan`=`mdetail`.`id_pemasukan` and `pemasukan`.`id_pemasukan`= '$kode'";

    $results = DB::select($sql);

$gab="";

$total=0;

foreach($results as $i){

$id_barang= $i->id_barang;

$jumlah= $i->jumlah;

$subtotal= $i->subtotal;

$nb=getNamaBarang($id_barang);

$gab.="$nb ($jumlah),";

$total+=$subtotal;

}

$gab.="Total:".RP($total);

return $gab;

}

function getPelanggan($kode){ 

//$hasil=\App\Pelanggan::find($kode)->value('nama_pelanggan');//BEST

$results = DB::select('select `nama_pelanggan` from `pelanggan` where `id_pelanggan` = ?', [$kode]);

$hasil=$results[0]->nama_pelanggan;

return $hasil;

}

function getPelanggan2($kode){ 

$results = DB::select('select `nama_pelanggan` from `pelanggan` where `id_pelanggan` = ?', [$kode]);

$hasil=$results[0]->nama_pelanggan;

return $hasil;

}

function getNamaBarang($kode){ 

// $pesan = Pesan::orderBy('id_pesan', 'desc')->get();

//$mdetail = Mdetail::all()->where('id_pemasukan',$id); //One to Many

//ModelName::find(id)->value('column_name');

$hasil=\App\Barang::find($kode)->value('nama_barang');//BEST

//$results = DB::select('select `nama_barang`,`stok` from `barang` where `id_barang` = ?', [$kode]);

//$hasil=$results[0]->nama_barang;

//$sql= "SELECT `nama_barang` FROM `barang` WHERE `id_barang`= '".$kode."'";

    //$results = DB::select($sql);

//$hasil=$results[0]->nama_barang;

//$results = DB::table('barang')->select('nama_barang','stok')->where('id_barang', '=', $kode)->orderBy('id_barang','asc')->get();//ARRAY

//$hasil=$results[0]->nama_barang;

//foreach($results as $i){echo $i->user_id;}

//$results = DB::table('barang')->select('nama_barang')->where('id_barang','=', $kode)->first();

//$hasil=$results->nama_barang;

//$results = DB::table('barang')->select('nama_barang')->where('id_barang', $kode)->first();//first=return no array

//$hasil=$results->nama_barang;

//$hasil=DB::table('barang')->where('id_barang', $kode)->value('nama_barang');//L5

//$hasil=DB::table('barang')->where('id_barang', $kode)->pluck('nama_barang');//L4

//$hasil = DB::table('barang')->where('id_barang', $kode)->select('nama_barang')->pluck('nama_barang')->first();

//$hasil=DB::table('barang')->where('id_barang', $kode)->orderBy('id_barang', 'desc')->value('nama_barang');

//$hasil =\App\Barang::where('id_barang', $kode)->first()->nama_barang;

//$hasil = \App\Barang::where('id_barang',$kode)->value('nama_barang');

return $hasil;

}

//exe

//DB::statement('UPDATE users SET role_id = 1 WHERE role_id IS NULL AND YEAR(created_at) > 2020');

//DB::statement('DROP TABLE users');

//DB::statement('ALTER TABLE projects AUTO_INCREMENT=123');

//LIBRARY SQL //RAW

//\App\User::whereIn('mobile',['971700000', '965000000'])->select('id')->pluck('id')->all();

/*

$users = DB::table('users')

    ->selectRaw('count(*) as user_count, status')

    ->where('status', '<>', 1)

    ->groupBy('status')

    ->get();

$products = DB::table('products')

    ->leftjoin('category','category.product_id','=','products.id')

    ->selectRaw('COUNT(*) as nbr', 'products.*')

    ->groupBy('products.id')

    ->get();

$salaries = DB::table('salaries')

    ->selectRaw('companies.name as company_name, avg(salary) as avg_salary, count(*) as people_count')

    ->join('companies', 'salaries.company_id', '=', 'companies.id')

    ->groupBy('companies.id')

    ->orderByDesc('avg_salary')

    ->get();

$results = User::selectRaw('YEAR(birth_date) as year, COUNT(id) as amount')

    ->groupByRaw('YEAR(birth_date)')

    ->havingRaw('YEAR(birth_date) > 2000')

    ->orderByRaw('YEAR(birth_date)')

    ->get();

$products = Product::select('id', 'name')

    ->selectRaw('price - discount_price AS discount')

    ->get();

$users = DB::table('users')

    ->select('name', 'surname')  

    ->selectRaw("(CASE WHEN (gender = 1) THEN 'M' ELSE 'F' END) as gender_text")

    ->get();

*/

/*

https://laravel.com/docs/8.x/requests

use Illuminate\Http\Request;

public function store(Request $request){

$name = $request->input('name');

$uri = $request->path();

$url = $request->url();

$urlWithQueryString = $request->fullUrl();

$request->fullUrlWithQuery(['type' => 'phone']);

$method = $request->method();

if ($request->isMethod('post')) {}

$value = $request->header('X-Header-Name');

$value = $request->header('X-Header-Name', 'default');

if ($request->hasHeader('X-Header-Name')) {}

$token = $request->bearerToken();

$ipAddress = $request->ip();

$contentTypes = $request->getAcceptableContentTypes();

if ($request->accepts(['text/html', 'application/json'])) {}

$preferred = $request->prefers(['text/html', 'application/json']);

if ($request->expectsJson()) {}

$input = $request->all();

$input = $request->collect();

$request->collect('users')->each(function ($user) {});

$name = $request->input('name');

$name = $request->input('name', 'Sally');

$name = $request->input('products.0.name');

$names = $request->input('products.*.name');

$input = $request->input();

$name = $request->query('name');

$name = $request->query('name', 'Helen');

$query = $request->query();

$name = $request->input('user.name');

$archived = $request->boolean('archived');

$name = $request->name;

$input = $request->only(['username', 'password']);

$input = $request->only('username', 'password');

$input = $request->except(['credit_card']);

$input = $request->except('credit_card');

if ($request->has('name')) {}

if ($request->has(['name', 'email'])) {}

$request->whenHas('name', function ($input) {});

if ($request->hasAny(['name', 'email'])) {}

if ($request->filled('name')) {}

$request->whenFilled('name', function ($input) {});

if ($request->missing('name')) {}

$request->flash();

$request->flashOnly(['username', 'email']);

$request->flashExcept('password');

return redirect('form')->withInput();

return redirect()->route('user.create')->withInput();

return redirect('form')->withInput(

$request->except('password')

);

$username = $request->old('username');

<input type="text" name="username" value="{{ old('username') }}">

$value = $request->cookie('name');

$file = $request->file('photo');

$file = $request->photo;

if ($request->hasFile('photo')) {}

if ($request->file('photo')->isValid()) {}

$path = $request->photo->path();

$extension = $request->photo->extension();

$path = $request->photo->store('images');

$path = $request->photo->store('images', 's3');

$path = $request->photo->storeAs('images', 'filename.jpg');

$path = $request->photo->storeAs('images', 'filename.jpg', 's3');

https://laravel.com/docs/8.x/requests

}//public

*/

function RP($angka){ 

    $hasil =  number_format($angka,0, ',' , '.'); 

    return $hasil.";"; 

}

function terbilang($i){

  $huruf = array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas");

  

  if ($i < 12) return " " . $huruf[$i];

  elseif ($i < 20) return terbilang($i - 10) . " Belas";

  elseif ($i < 100) return terbilang($i / 10) . " Puluh" . terbilang($i % 10);

  elseif ($i < 200) return " Seratus" . terbilang($i - 100);

  elseif ($i < 1000) return terbilang($i / 100) . " Ratus" . terbilang($i % 100);

  elseif ($i < 2000) return " Seribu" . terbilang($i - 1000);

  elseif ($i < 1000000) return terbilang($i / 1000) . " Ribu" . terbilang($i % 1000);

  elseif ($i < 1000000000) return terbilang($i / 1000000) . " Juta" . terbilang($i % 1000000);    

}

?>

<?php function RP2($rupiah){return number_format($rupiah,"2",",",".");}?>

<?php

function WKT($sekarang){

if($sekarang=="0000-00-00"){$sekarang=date("Y-m-d");}

$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]";

}

?>

Penjualan Controller

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Session;

use Illuminate\Http\Request;

use Illuminate\Support\Str;

use App\Penjualan;

use App\Pelanggan;

use DB;

use Auth;

use File;

class PenjualanController extends Controller

{

    public function __construct(){

        $this->middleware('auth');

    }

    public function index(){

        $no = 0;

        $penjualan = Penjualan::orderBy('id_penjualan', 'desc')->get();

        return view('admin.penjualan.index', compact('penjualan', 'no')); 

}

    public function _index(){

$id_pelanggan=Auth::user()->rkey ;

        $no = 0;

       // $penjualan = Penjualan::orderBy('id_penjualan', 'desc')->get();

$penjualan = DB::select("select * from `pelanggan`,`penjualan` where `penjualan`.`id_pelanggan`='$id_pelanggan' and `penjualan`.`id_pelanggan`=`pelanggan`.`id_pelanggan` order by `penjualan`.`id_penjualan` desc");

return view('admin.penjualan._index', compact('penjualan', 'no')); 

}

    public function create(){

if(Auth::user()->level=="Pelanggan"){

return view('admin.penjualan._create');

}

else{

$pelanggan = Pelanggan::all();  

return view('admin.penjualan.create', compact('pelanggan'));

}

}

    public function store(Request $request){

        $this->validate($request,[

            'id_pelanggan'=>'required'

        ]);

        $penjualan = New Penjualan;

$wilayah=$request->wilayah;

        $penjualan->tanggal = date("Y-m-d");//$request->tanggal;

$penjualan->jam =  date("H:i:s");//$request->jam;

$penjualan->id_pelanggan = $request->id_pelanggan;

$penjualan->alamat_pengiriman = $request->alamat_pengiriman;

$penjualan->tagihan =0;// $request->tagihan;

$ongkir=getOngkir($wilayah);

$penjualan->ongkir =$ongkir;// $request->ongkir;

$penjualan->total = $ongkir;//$request->total;

$penjualan->status = $request->status;

$penjualan->keterangan = $request->keterangan;

$penjualan->wilayah = $wilayah;

        $penjualan->save();

        return redirect('/penjualan')->with('pesan', 'Data Penjualan berhasil disimpan');

    }

  public function _storeOrder(Request $request){

 

if(session()->has('IDORDER')){

$id_penjualan= Session::get('IDORDER');

$jdetail = New Jdetail;

$id_barang=$request->id_barang;

$jumlah = $request->jumlah;  

$barang = Barang::find($id_barang);

$harga=$barang->harga;

$nama_barang=$barang->nama_barang;

$jdetail->id_penjualan = $id_penjualan;

$jdetail->id_barang = $id_barang;

$jdetail->jumlah =$jumlah;

$jdetail->harga = $harga;

$jdetail->subtotal =$jumlah * $harga;

$jdetail->catatan = $request->catatan;

$jdetail->save(); 

$barang->stok = $barang->stok-$jumlah;

        $barang->update();

$penjualan = Penjualan::find($id_penjualan); 

$total=getTotal($id_penjualan);

$penjualan->tagihan =$total;

$penjualan->total =$penjualan->ongkir+$total;

$penjualan->update();

        return redirect('/jdetail/'.$id_penjualan)->with('pesan', "Data $nama_barang berhasil disimpan");

}

else{

        $penjualan = New Penjualan;

$wilayah=$request->wilayah;

        $penjualan->tanggal = date("Y-m-d");//$request->tanggal;

$penjualan->jam =  date("H:i:s");//$request->jam;

$penjualan->id_pelanggan = $id_pelanggan=Auth::user()->rkey ;

$penjualan->alamat_pengiriman = $request->alamat_pengiriman;

$penjualan->tagihan =0;

$ongkir=getOngkir($wilayah);

$penjualan->ongkir =$ongkir;// $request->ongkir;

$penjualan->total = $ongkir;//$request->total;

$penjualan->status = "Order";

$penjualan->keterangan = "-";

$penjualan->wilayah = $wilayah;

        $penjualan->save();

$ARR = Penjualan::all()->last();

$value=$ARR->id_penjualan;

session(['IDORDER' => $value]);

$id_penjualan=$value;

        //return redirect('/_penjualan')->with('pesan', 'Data Penjualan berhasil disimpan');

$jdetail = New Jdetail;

$id_barang=$request->id_barang;

$jumlah = $request->jumlah;  

$barang = Barang::find($id_barang);

$harga=$barang->harga;

$nama_barang=$barang->nama_barang;

$jdetail->id_penjualan = $id_penjualan;

$jdetail->id_barang = $id_barang;

$jdetail->jumlah =$jumlah;

$jdetail->harga = $harga;

$jdetail->subtotal =$jumlah * $harga;

$jdetail->catatan = $request->catatan;

$jdetail->save(); 

$barang->stok = $barang->stok-$jumlah;

        $barang->update();

$penjualan = Penjualan::find($id_penjualan); 

$total=getTotal($id_penjualan);

$penjualan->tagihan =$total;

$penjualan->total =$penjualan->ongkir+$total;

$penjualan->update();

        return redirect('/jdetail/'.$id_penjualan)->with('pesan', "Data $nama_barang berhasil disimpan");

 

}//else

    }

public function _store(Request $request){

        $penjualan = New Penjualan;

$wilayah=$request->wilayah;

        $penjualan->tanggal = date("Y-m-d");//$request->tanggal;

$penjualan->jam =  date("H:i:s");//$request->jam;

$penjualan->id_pelanggan = $id_pelanggan=Auth::user()->rkey ;

$penjualan->alamat_pengiriman = $request->alamat_pengiriman;

$penjualan->tagihan =0;

$ongkir=getOngkir($wilayah);

$penjualan->ongkir =$ongkir;// $request->ongkir;

$penjualan->total = $ongkir;//$request->total;

$penjualan->status = "Order";

$penjualan->keterangan = "-";

$penjualan->wilayah = $wilayah;

        $penjualan->save();

        return redirect('/_penjualan')->with('pesan', 'Data Penjualan berhasil disimpan');

    }

    public function edit($id_penjualan){

        $DaftarPelanggan = Pelanggan::all();

        $penjualan = Penjualan::find($id_penjualan);

        return view('admin.penjualan.edit', compact('penjualan','DaftarPelanggan'));

    }

public function _edit($id_penjualan){

        $DaftarPelanggan = Pelanggan::all();

        $penjualan = Penjualan::find($id_penjualan);

        return view('admin.penjualan._edit', compact('penjualan','DaftarPelanggan'));

    }

    public function update(Request $request, $id){

        $penjualan = Penjualan::find($id);

$penjualan->id_pelanggan = $request->id_pelanggan;

$penjualan->alamat_pengiriman = $request->alamat_pengiriman;

$wilayah=$request->wilayah;

$ongkir=getOngkir($wilayah);

$penjualan->ongkir =$ongkir;

$penjualan->total = $penjualan->tagihan+$ongkir;

$penjualan->wilayah = $wilayah;

$penjualan->status = $request->status;

    $penjualan->keterangan = $request->keterangan;

       

        $penjualan->update();

        return redirect('/penjualan')->with('pesan','Data Penjualan berhasil di update');

    }

public function _update(Request $request, $id){

        $penjualan = Penjualan::find($id); 

$penjualan->alamat_pengiriman = $request->alamat_pengiriman;

$wilayah=$request->wilayah;

$ongkir=getOngkir($wilayah);

$penjualan->ongkir =$ongkir;

$penjualan->total = $penjualan->tagihan+$ongkir;

$penjualan->wilayah = $wilayah; 

    $penjualan->keterangan = $request->keterangan;

       

        $penjualan->update();

        return redirect('/_penjualan')->with('pesan','Data Penjualan berhasil di update');

    }

    public function destroy($id){

        $penjualan = Penjualan::find($id);

        $penjualan->delete();

$ada=0;

$jdetail = \App\Jdetail::all()->where('id_penjualan',$id);

foreach($jdetail as $i){

$pk= $i->idj;

$Detail = \App\Jdetail::find($pk);

$id_barang= $i->id_barang;

$jumlahYgLama= $i->jumlah;

$barang = \App\Barang::find($id_barang);

$barang->stok = $barang->stok+$jumlahYgLama;

$barang->update();

$ada++;

$Detail->delete();

}

        return redirect('/penjualan')->with('pesan', "Data Penjualan berikut $ada Transaksi Detailnya Berhasil di Hapus");

    }

}

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

Jdetail Controller

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Session;

use Illuminate\Http\Request;

use Illuminate\Support\Str;

use App\Jdetail;

use App\Penjualan;

use App\Barang;

use File;

use DB ;

use Auth;

class JdetailController extends Controller

{

    public function __construct(){

        $this->middleware('auth');//auth

    }

//ModelName::findOrFail($id, ['firstName', 'lastName']); 

//ModelName::find($id, ['name', 'surname']);

//Table::select ('name', 'surname')->where ('id', 1)->get ().

//Eloquent: Get specific columns (not all the row). Pluck returns an array.

//Model::where('id', 1)->pluck('name', 'surname');

// If you only want to get the result value:

//Model::where('id', 1)->value('name');

/*

Model::where('id', 1)

     ->pluck('name', 'surname')

     ->all();

*/

//ModelName::all('column1', 'column2', 'column3');

//ModelName::find($id, ['name', 'surname']);  

    public function index($id){

        //$jdetail = Jdetail::all();

//$qry = 'SELECT * FROM `jdetail`,`barang` WHERE `jdetail`.`id_barang`=`barang`.`id_barang`  and `jdetail`.`id_penjualan` = "'.$id.'"';

        //$jdetail = DB::select($qry);

//Table('table')->select('name','surname')->where('id',1)->get();

//YourModelName::all('id', 'name')->where('id',1)->first()->column_name;

//$jdetail = Jdetail::all()->where('id_penjualan',$id);//->column_name;//find($id)->id_penjualan;

//$subtotal= Jdetail::all()->where('id_penjualan',$id)->sum('subtotal');//max,min,sum,avg,count

//return view('admin.jdetail.index', compact('jdetail','subtotal', 'no','penjualan'));   

$no = 0;

$total=0;

$penjualan = Penjualan::find($id);

$jdetail = Jdetail::all()->where('id_penjualan',$id);

        return view('admin.jdetail.index', compact('jdetail','total', 'no','penjualan'));    

    }

   public function _storeOrder(Request $request){

 

if(session()->has('IDORDER')){

$id_penjualan= Session::get('IDORDER');

$jdetail = New Jdetail;

$id_barang=$request->id_barang;

$jumlah = $request->jumlah;  

$barang = Barang::find($id_barang);

$harga=$barang->harga;

$nama_barang=$barang->nama_barang;

$jdetail->id_penjualan = $id_penjualan;

$jdetail->id_barang = $id_barang;

$jdetail->jumlah =$jumlah;

$jdetail->harga = $harga;

$jdetail->subtotal =$jumlah * $harga;

$jdetail->catatan = $request->catatan;

$jdetail->save(); 

$barang->stok = $barang->stok-$jumlah;

        $barang->update();

$penjualan = Penjualan::find($id_penjualan); 

$total=getTotal($id_penjualan);

$penjualan->tagihan =$total;

$penjualan->total =$penjualan->ongkir+$total;

$penjualan->update();

        return redirect('/jdetail/'.$id_penjualan)->with('pesan', "Data $nama_barang berhasil disimpan");

}

else{

        $penjualan = New Penjualan;

$wilayah="Jabodetabek";

        $penjualan->tanggal = date("Y-m-d");//$request->tanggal;

$penjualan->jam =  date("H:i:s");//$request->jam;

$penjualan->id_pelanggan = $id_pelanggan=Auth::user()->rkey ;

$penjualan->alamat_pengiriman = "";

$penjualan->tagihan =0;

$ongkir=getOngkir($wilayah);

$penjualan->ongkir =$ongkir;// $request->ongkir;

$penjualan->total = $ongkir;//$request->total;

$penjualan->status = "Order";

$penjualan->keterangan = "-";

$penjualan->wilayah = $wilayah;

        $penjualan->save();

$ARR = Penjualan::all()->last();

$value=$ARR->id_penjualan;

session(['IDORDER' => $value]);

$id_penjualan=$value;

        //return redirect('/_penjualan')->with('pesan', 'Data Penjualan berhasil disimpan');

$jdetail = New Jdetail;

$id_barang=$request->id_barang;

$jumlah = $request->jumlah;  

$barang = Barang::find($id_barang);

$harga=$barang->harga;

$nama_barang=$barang->nama_barang;

$jdetail->id_penjualan = $id_penjualan;

$jdetail->id_barang = $id_barang;

$jdetail->jumlah =$jumlah;

$jdetail->harga = $harga;

$jdetail->subtotal =$jumlah * $harga;

$jdetail->catatan = $request->catatan;

$jdetail->save(); 

$barang->stok = $barang->stok-$jumlah;

        $barang->update();

$penjualan = Penjualan::find($id_penjualan); 

$total=getTotal($id_penjualan);

$penjualan->tagihan =$total;

$penjualan->total =$penjualan->ongkir+$total;

$penjualan->update();

        return redirect('/jdetail/'.$id_penjualan)->with('pesan', "Data $nama_barang berhasil disimpan");

 

}//else

    }

 

    public function create($id){

$barang = Barang::all();

        $penjualan = Penjualan::find($id); 

        return view('admin.jdetail.create', compact('penjualan','barang'));

    }

    public function store(Request $request){

        $jdetail = New Jdetail;

$id_penjualan=$request->id_penjualan;

$id_penjualan=$id_penjualan;

$id_barang=$request->id_barang;

$jumlah = $request->jumlah; //Input::get('jumlah', false);

$barang = Barang::find($id_barang);

$harga=$barang->harga;

$nama_barang=$barang->nama_barang;

$jdetail->id_penjualan = $id_penjualan;

$jdetail->id_barang = $id_barang;

$jdetail->jumlah =$jumlah;

$jdetail->harga = $harga;

$jdetail->subtotal =$jumlah * $harga;

$jdetail->catatan = $request->catatan;

$jdetail->save();

$barang->stok = $barang->stok-$jumlah;

        $barang->update();

$penjualan = Penjualan::find($id_penjualan); 

$total=getTotal($id_penjualan);

$penjualan->tagihan =$total;

$penjualan->total =$penjualan->ongkir+$total;

$penjualan->update();

        return redirect('/jdetail/'.$id_penjualan)->with('pesan', "Data $nama_barang berhasil disimpan");

    }

    public function edit($id,$kode){

        $penjualan = Penjualan::find($id); 

        $jdetail = Jdetail::find($kode);

$barang = Barang::all();

        return view('admin.jdetail.edit', compact('jdetail','penjualan','barang'));

    }

    public function update(Request $request,$id,$kode){//Request $request,

$id_penjualan=$id;

$id_barang=$request->id_barang;

$jumlah = $request->jumlah;//3 8

$barang = Barang::find($id_barang);

$harga=$barang->harga;

$nama_barang=$barang->nama_barang;

$jdetail = Jdetail::find($kode);

$jumlahYgLama =$jdetail->jumlah;//8 3

$selisih=$jumlahYgLama-$jumlah;//8-3=5

$barang->stok = $barang->stok+$selisih;

$barang->update();

            $jdetail->id_penjualan = $id_penjualan;

$jdetail->id_barang = $id_barang;

$jdetail->jumlah = $jumlah;

$jdetail->harga = $harga;

$jdetail->subtotal =$jumlah * $harga;

$jdetail->catatan = $request->catatan;

        $jdetail->update();

$penjualan = Penjualan::find($id_penjualan); 

$total=getTotal($id_penjualan);

$penjualan->tagihan =$total;

$penjualan->total =$penjualan->ongkir+$total;

$penjualan->update();

        return redirect('/jdetail/'.$id_penjualan)->with('pesan',"Data $nama_barang Penjualan  berhasil di update");

    }

    public function destroy($id,$kode){

        $jdetail = Jdetail::find($kode);//findOrFail

$id_barang=$jdetail->id_barang;

$jumlahYgLama =$jdetail->jumlah;

        $jdetail->delete();

$barang = Barang::find($id_barang);

$barang->stok = $barang->stok+$jumlahYgLama;

        $barang->update();

        return redirect('/jdetail/'.$id)->with('pesan', 'Data Transaksi Berhasil di Hapus');

    }

}

.htaccess Pewaktuan

 

.htaccess

RewriteEngine on

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^(.*)$ index.php?path=$1 [NC,L,QSA]

index.php

<html>

<head>

<script type="text/javascript">

function Ajax(){

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', 'timer.php' + '?' + new Date().getTime(), true);

$http.send(null);

}

}

</script>

<script type="text/javascript">setTimeout(function() {Ajax();}, 1000);</script>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

</head>

<body>

<?php

$url = (isset($_SERVER['HTTPS']) ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

$ar=explode("/",$url);

$jd=count($ar);

$nama= $ar[$jd-1];

$nama=str_replace("+"," ",$nama);

$nama=str_replace("-"," ",$nama);

$nama=str_replace("%20"," ",$nama);

echo "<h1>Yth, $nama</h1>";

?>

</body>

</html>

timer.php

<?php

date_default_timezone_set("Asia/Jakarta");

$tglacara="2025-12-25";

$jamacara="00:00:00";

$tglnow=date("Y-m-d");

$jamnow=date("H:m:s");

$acara = new DateTime($tglacara." ".$jamacara);

$sekarang = new DateTime();

$tanggal=WKT($tglnow);

echo  "<b>MEETING :".WKT($tglacara)."</b><br>";

echo  "<b>TODAY :$tanggal $jamnow Wib</b>";

$diff  = date_diff( $acara,$sekarang );

echo"<hr>";

echo $diff->y . " tahun<br>";

echo $diff->m . " bulan<br>";

echo $diff->d . " hari<br>";

echo $diff->h . " jam<br>";

echo $diff->i . " menit<br>";

echo $diff->s . " detik<br>";

?>

<?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;

}

?>

Laravel View Code DB

 <?php

/*

$ARR= DB::table('barang')->get();

foreach($ARR as $key => $value){

echo $value->nama_barang."<hr>";

}

*/

//$hasil=\App\Barang::find(3)->value('nama_barang');

//echo $hasil;

//$count = DB::table('barang')->count();

//echo $count;

?>

Laravel Hack Code

 

buat helper.php pada folder Helpers

Pada composer tanbahkan pada bagian autoload

    "autoload": {

        "psr-4": {

            "App\\": "app/"

        },

        "classmap": [

            "database/seeds",

            "database/factories"

        ],

"files":  [ 

"app/Helpers/helper.php"

]

    },

jalankan perintah pada terminal

composer update -vvv 

atau

composer dump-autoload

<?php

//$username=Session::get('key');

//https://laravel.com/docs/8.x/queries#aggregates

//https://blog.quickadminpanel.com/5-ways-to-use-raw-database-queries-in-laravel/

function getListMasuk($kode){ 

$sql= "SELECT `mdetail`.`id_barang`,`mdetail`.`jumlah`,`mdetail`.`subtotal` FROM `pemasukan`,`mdetail` WHERE `pemasukan`.`id_pemasukan`=`mdetail`.`id_pemasukan` and `pemasukan`.`id_pemasukan`= '$kode'";

    $results = DB::select($sql);

$gab="";

$total=0;

foreach($results as $i){

$id_barang= $i->id_barang;

$jumlah= $i->jumlah;

$subtotal= $i->subtotal;

$nb=getNamaBarang($id_barang);

$gab.="$nb ($jumlah),";

$total+=$subtotal;

}

$gab.="Total:".RP($total);

return $gab;

}

function getNamaBarang($kode){ 

//ModelName::find(id)->value('column_name');

$hasil=\App\Barang::find($kode)->value('nama_barang');//BEST

//$results = DB::select('select `nama_barang` from `barang` where `id_barang` = ?', [$kode]);

//$hasil=$results[0]->nama_barang;

//$sql= "SELECT `nama_barang` FROM `barang` WHERE `id_barang`= '".$kode."'";

    //$results = DB::select($sql);

//$hasil=$results[0]->nama_barang;

//$results = DB::table('barang')->select('nama_barang')->where('id_barang', '=', $kode)->orderBy('id_barang','asc')->get();//ARRAY

//$hasil=$results[0]->nama_barang;

//foreach($results as $i){echo $i->user_id;}

//$results = DB::table('barang')->select('nama_barang')->where('id_barang','=', $kode)->first();

//$hasil=$results->nama_barang;

//$results = DB::table('barang')->select('nama_barang')->where('id_barang', $kode)->first();//first=return no array

//$hasil=$results->nama_barang;

//$hasil=DB::table('barang')->where('id_barang', $kode)->value('nama_barang');//L5

//$hasil=DB::table('barang')->where('id_barang', $kode)->pluck('nama_barang');//L4

//$hasil = DB::table('barang')->where('id_barang', $kode)->select('nama_barang')->pluck('nama_barang')->first();

//$hasil=DB::table('barang')->where('id_barang', $kode)->orderBy('id_barang', 'desc')->value('nama_barang');

//$hasil =\App\Barang::where('id_barang', $kode)->first()->nama_barang;

//$hasil = \App\Barang::where('id_barang',$kode)->value('nama_barang');

return $hasil;

}

//exe

//DB::statement('UPDATE users SET role_id = 1 WHERE role_id IS NULL AND YEAR(created_at) > 2020');

//DB::statement('DROP TABLE users');

//DB::statement('ALTER TABLE projects AUTO_INCREMENT=123');

//LIBRARY SQL //RAW

//\App\User::whereIn('mobile',['971700000', '965000000'])->select('id')->pluck('id')->all();

/*

$users = DB::table('users')

    ->selectRaw('count(*) as user_count, status')

    ->where('status', '<>', 1)

    ->groupBy('status')

    ->get();

$products = DB::table('products')

    ->leftjoin('category','category.product_id','=','products.id')

    ->selectRaw('COUNT(*) as nbr', 'products.*')

    ->groupBy('products.id')

    ->get();

$salaries = DB::table('salaries')

    ->selectRaw('companies.name as company_name, avg(salary) as avg_salary, count(*) as people_count')

    ->join('companies', 'salaries.company_id', '=', 'companies.id')

    ->groupBy('companies.id')

    ->orderByDesc('avg_salary')

    ->get();

$results = User::selectRaw('YEAR(birth_date) as year, COUNT(id) as amount')

    ->groupByRaw('YEAR(birth_date)')

    ->havingRaw('YEAR(birth_date) > 2000')

    ->orderByRaw('YEAR(birth_date)')

    ->get();

$products = Product::select('id', 'name')

    ->selectRaw('price - discount_price AS discount')

    ->get();

$users = DB::table('users')

    ->select('name', 'surname')  

    ->selectRaw("(CASE WHEN (gender = 1) THEN 'M' ELSE 'F' END) as gender_text")

    ->get();

 

https://laravel.com/docs/8.x/requests

use Illuminate\Http\Request;

public function store(Request $request){

$name = $request->input('name');

$uri = $request->path();

$url = $request->url();

$urlWithQueryString = $request->fullUrl();

$request->fullUrlWithQuery(['type' => 'phone']);

$method = $request->method();

if ($request->isMethod('post')) {}

$value = $request->header('X-Header-Name');

$value = $request->header('X-Header-Name', 'default');

if ($request->hasHeader('X-Header-Name')) {}

$token = $request->bearerToken();

$ipAddress = $request->ip();

$contentTypes = $request->getAcceptableContentTypes();

if ($request->accepts(['text/html', 'application/json'])) {}

$preferred = $request->prefers(['text/html', 'application/json']);

if ($request->expectsJson()) {}

$input = $request->all();

$input = $request->collect();

$request->collect('users')->each(function ($user) {});

$name = $request->input('name');

$name = $request->input('name', 'Sally');

$name = $request->input('products.0.name');

$names = $request->input('products.*.name');

$input = $request->input();

$name = $request->query('name');

$name = $request->query('name', 'Helen');

$query = $request->query();

$name = $request->input('user.name');

$archived = $request->boolean('archived');

$name = $request->name;

$input = $request->only(['username', 'password']);

$input = $request->only('username', 'password');

$input = $request->except(['credit_card']);

$input = $request->except('credit_card');

if ($request->has('name')) {}

if ($request->has(['name', 'email'])) {}

$request->whenHas('name', function ($input) {});

if ($request->hasAny(['name', 'email'])) {}

if ($request->filled('name')) {}

$request->whenFilled('name', function ($input) {});

if ($request->missing('name')) {}

$request->flash();

$request->flashOnly(['username', 'email']);

$request->flashExcept('password');

return redirect('form')->withInput();

return redirect()->route('user.create')->withInput();

return redirect('form')->withInput(

$request->except('password')

);

$username = $request->old('username');

<input type="text" name="username" value="{{ old('username') }}">

$value = $request->cookie('name');

$file = $request->file('photo');

$file = $request->photo;

if ($request->hasFile('photo')) {}

if ($request->file('photo')->isValid()) {}

$path = $request->photo->path();

$extension = $request->photo->extension();

$path = $request->photo->store('images');

$path = $request->photo->store('images', 's3');

$path = $request->photo->storeAs('images', 'filename.jpg');

$path = $request->photo->storeAs('images', 'filename.jpg', 's3');

https://laravel.com/docs/8.x/requests

}//public

*/

function RP($angka){ 

    $hasil =  number_format($angka,0, ',' , '.'); 

    return $hasil.";"; 

}

function terbilang($i){

  $huruf = array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas");

  

  if ($i < 12) return " " . $huruf[$i];

  elseif ($i < 20) return terbilang($i - 10) . " Belas";

  elseif ($i < 100) return terbilang($i / 10) . " Puluh" . terbilang($i % 10);

  elseif ($i < 200) return " Seratus" . terbilang($i - 100);

  elseif ($i < 1000) return terbilang($i / 100) . " Ratus" . terbilang($i % 100);

  elseif ($i < 2000) return " Seribu" . terbilang($i - 1000);

  elseif ($i < 1000000) return terbilang($i / 1000) . " Ribu" . terbilang($i % 1000);

  elseif ($i < 1000000000) return terbilang($i / 1000000) . " Juta" . terbilang($i % 1000000);    

}

?>

<?php function RP2($rupiah){return number_format($rupiah,"2",",",".");}?>

<?php

function WKT($sekarang){

if($sekarang=="0000-00-00"){$sekarang=date("Y-m-d");}

$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]";

}

?>

CodeigNeter SQL Inject

URI SEGMENT
 ucfirst($this->uri->segment(1));

 ucfirst($this->uri->segment(2));

LIBRARY

public function __construct(){
        parent::__construct();
        $this->load->model("admin_model");

$this->load->model("periode_model");

$this->load->library('session');

                $this->load->library('form_validation');

    }

    public function index() { 

        $this->load->view("login1/index1");//halaman_login 

    } 

public function Kembali() { 

     redirect(base_url()); 

    } 

function getGuru($db,$kode){
$out=$kode;
if(strlen($kode)>0){
$field="nama_guru";
$sql="Select `$field` from `tb_guru` where `nip`='$kode'";    
$query = $db->query($sql);
$arr= $query->row();//result_array
$out= $arr->$field;
}
return $out;
}

 SeTTING SESSION

 public function proses_login() { 

        $user = $this->input->post("username");
        $pass = $this->input->post("password"); 

$loginSiswa = $this->siswa_model->cek_login($user, $pass);
if (!empty($loginSiswa)) { 

$NISN=$loginSiswa["nisn"];

$ar = $this->periode_model->getAktif();
                        $id_periode=$ar->id_periode;
                        $nama_periode=$ar->nama_periode; 

$sql1="select * from `tb_peserta`,`tb_kelas` where `tb_peserta`.`id_periode`='$id_periode' and `tb_peserta`.`nisn`='$NISN' and  `tb_peserta`.`id_kelas`=`tb_kelas`.`id_kelas` ";

$ARRAY=$this->periode_model->getSQL($sql1);
                                        $id_kelas=($ARRAY["id_kelas"]) +0; 

$this->session->set_userdata('nisn',$NISN);
$this->session->set_userdata('id_periode',$id_periode)$this->session->set_userdata('nama_periode',$nama_periode);

$this->session->set_userdata('level',$level);
                        $this->session->set_userdata('kelas',$kelas);
                        $this->session->set_userdata('id_kelas',$id_kelas);
                        $this->session->set_userdata('nama_kelas',$nama_kelas);

            $this->session->set_userdata($ar1); 

            redirect(base_url("index.php/admin")); 

        } 

else { 

            $this->session->set_flashdata("gagal", "Username atau Password Salah!"); 

            redirect(base_url()); 

} 

Menangkap Session

$_level=$this->session->userdata("level");
$_nip=$this->session->userdata("nip");

$_id_periode=$this->session->userdata("id_periode");
$_nama_periode=$this->session->userdata("nama_periode");
$_id_kelas=$this->session->userdata("id_kelas");
$_nama_kelas=$this->session->userdata("nama_kelas"); 

$nama=getGuru($this->db,$_nip);

if($_level=="Administrator"){$this->load->view("admin/_partials/sidebaradmin.php") ;}

else if($_level=="Wali Kelas"){$this->load->view("admin/_partials/sidebarwali.php") ; }

else if($_level=="Kepala Sekolah"){$this->load->view("admin/_partials/sidebarkepsek.php"); }

else if($_level=="Guru"){$this->load->view("admin/_partials/sidebarguru.php") ;}

else if($_level=="Siswa"){$this->load->view("admin/_partials/sidebarsiswa.php") ;}

/////////////
MODEL:

public function getSQL($sql)  {

return $this->db->query($sql)->row_array();

    }

public function getSQLALL($sql)  {

return $this->db->query($sql)->result();

    }

Mmebuat Array UNIQUE

 

function getUNIX($arRS){

$ar=array();

for($i=1;$i<count($arRS);$i++){//dari 1 krn 0 u jumlah ada

$ar[$i-1]=$arRS[$i];

}

$unique = array();

foreach($ar as $v){

  isset($k[$v]) || ($k[$v]=1) && $unique[] = $v;

  }

$gab="";   

for($i=0;$i<count($unique);$i++){

$gab.=$unique[$i].",";

}

$gab=substr($gab,0,strlen($gab)-1);

return $gab;

}

PHP Cek Usia

 

function cekUsia($tgl){

$awal  = date_create($tgl);

$akhir = date_create(); 

$diff  = date_diff( $awal, $akhir );

return $diff->y;

}

Read Write SM

 <?php

$token = "1893725977:AAHyteFgCs_A73IyjSBIIXpsADIGANTENG";

$data = [

    'text' => 'halo apa kabar .... here',

    'chat_id' => '1308416385'

];

//file_get_contents("https://api.telegram.org/bot$token/sendMessage?" . http_build_query($data) );

$URI="https://api.telegram.org/bot1893725977:AAHyteFgCs_A73IyjSBIIADIGANTENG/getUpdates?offset=0";

//$ar=file_get_contents($URI );

//var_dump($ar);

//call api

$json = file_get_contents($URI);

//var_dump($json);

$json = json_decode($json,true);

//var_dump($json);

//$lat = $json->message[0]->message_id;

//$lng = $json->message[0]->from->first_name;

//echo "Latitude: " . $lat . ", Longitude: " . $lng;

cetak( $json["ok"]);

cetak( $json["result"][0]["update_id"]);

cetak( $json["result"][0]["message"]["message_id"]);

cetak( $json["result"][0]["message"]["from"]["id"]);

cetak( $json["result"][0]["message"]["from"]["first_name"]);

cetak( $json["result"][0]["message"]["from"]["last_name"]);

cetak( $json["result"][0]["message"]["from"]["language_code"]);

cetak( $json["result"][0]["message"]["chat"]["id"]);

cetak( $json["result"][0]["message"]["chat"]["first_name"]);

cetak( $json["result"][0]["message"]["chat"]["last_name"]);

cetak( $json["result"][0]["message"]["chat"]["type"]);

cetak( $json["result"][0]["message"]["date"]);

cetak( $json["result"][0]["message"]["text"]);

function cetak($v){

    echo"$v<hr>";

}

/*

string(331) "{"ok":true,"result":[{"update_id":42342343423, "message":{"message_id":8,"from":{"id":4324234234234,"is_bot":false,

    "first_name":"adi","last_name":"adiarray",

    "language_code":"en"},

    "chat":{"id":2342343,

        "first_name":"adi","last_name":"adiarray","type":"private"},"date":1624708793,

        "text":"Piye kabare ...masih enak zaman ku to?"}}]}

*/

?>

Import Tanggal Dari Excell

 function fromExcelToLinux($excel_time) {
    return ($excel_time-25569)*86400;
}

                $TGL_EXCEL = fromExcelToLinux($mulai_kerja); 
		$mulai_kerja= date("Y-m-d",$TGL_EXCEL);
		$TGL_EXCEL = fromExcelToLinux($tgl_lahir); 
		$tgl_lahir= date("Y-m-d",$TGL_EXCEL);