| notranskeluar | kodebarang | jumlahbeli | tothargakeluar | Which "jumlahstok" is an information how many "namabarang" are there.Īnd then I have a table which I want to insert new data | kodebarang | namabarang | hargapenjualan | hargapembelian | jumlahstok | In Laravel 8, I want to make a validation for input integer value which is greater than or equal to integer value from another column in different table, and then validation fails because of execeeds the integer value from another column.īarang table +-+-+-+-+-+ 'jumlahbarang_konsumen' => 'required|numeric|min:1|max:Barang,namabarang,'.$value2.',Barang,jumlahstok', 'namabarang_konsumen' => 'required|exists:Barang,namabarang', $value3 = $request-> jumlahbarang_konsumen $value2 = $request-> namabarang_konsumen (jumlahstok column - jumlahbeli column)Īnd then I have an function which i want to validate like this : public function store_notakeluar(Request $request) So when a new data from NotaKeluar inserts, then jumlahstok column from Barang table is reduced because of inserting jumlahbeli column and kodebarang column from NotaKeluar table.
'jumlahbarang_konsumen.max' => 'Jumlah barang yang dibeli melebihi jumlah stok!',ĭB::select('call spNotaKeluar(?,?,?)',) 'jumlahbarang_konsumen.min' => 'Jumlah barang minimal 1!', Return redirect('home/daftar_transaksikeluar/detil_notakeluar/'.$value1)->with('tambah', 'Nota telah berhasil ditambahkan') īut the problem is, if I input namabarang_konsumen (which is converted to the kodebarang from NotaKeluar table) and jumlahbarang_konsumen (to the jumlahbeli column from NotaKeluar table) which is greater than or equal to jumlahstok column from Barang table (where converted namabarang_konsumen input to the kodebarang from NotaKeluar is kodebarang from Barang), the failed validation didn't occur and instead of this, it inserted to NotaKeluar table and change jumlahstok column from Barang table to 0. (I program this into 0 which = jumlahstok column from Barang table, it inserted. I've tried to find it on many tutorials, but it didn't 2.com› Program Stock Barang Phpmyadmin ▄ ▄ But I want to make the failed validation occurs that jumlahbarang_konsumen exceeds the jumlahstok column from Barang table (where namabarang from Barang table is namabarang_konsumen input) so it not inserted into NotaMasuk table. Modal sedikit anda hanya membuat website toko online Tidak perlu modal besar karena bisa stok barang sesuai dengan permintaan Mudah berpromosi karena url anda dapat di promosikan baik itu berupa aplikasi android, sms atau lainnya Dapat berpromosi dengan media sosial seperti facebook. Stock Management System With PHP, MYSQLI, BOOTSTRAP, JQUERY AJAX This project Stock Management System is developed with PHP, MYSQLI, BOOTSTRAP, and AJAX JQUERY as a web application.
CONTOH APLIKASI STOK BARANG DENGAN PHP DOWNLOAD
Download source code: roUZet Official Website: TyU1QB For Stock Managment System Tutorial: playlist?list=PLaSPP6wN3sqv24mTYXidt4OVmedypBcjH Like, share and subscribe for more tutorials and PHP projects.
0 kommentar(er)
