public function tambahBarang(Request $request)
{
$barang = new Barang();
$barang->kodeBarang = $request->input('kodeBarang');
$barang->nama = $request->input('nama');
$barang->stok = $request->input('stok');
$barang->harga = $request->input('harga');
$barang->save();
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['penerima' => 'required']);
$all = $request->all();
// dd($all);
$pengadaanFill = $this->pengadaanBarang->getFillable();
$pengadaan = $this->pengadaanBarang->Create($request->only($pengadaanFill));
// dd($all);
try {
foreach ($all['barpeng'] as $barpeng) {
if (!is_numeric($barpeng['kuantitas'])) {
return redirect()->back()->withErrors(['Kuantitas harus berupa angka']);
} else {
$addedItem = Barang::find($barpeng['barang_id']);
$addedItem['pengadaan'] += $barpeng['kuantitas'];
$addedItem->save();
// dd($addedItem);
Barang::find($barpeng['barang_id'])->update($addedItem->toArray());
$barang_id = array_pull($barpeng, 'barang_id');
$pengadaan->barangs()->attach($barang_id, $barpeng);
}
}
return redirect('pengadaan/index');
} catch (Exception $e) {
return redirect()->back()->withErrors($e);
}
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$barang = Barang::all()->toArray();
$gudang = Gudang::all()->toArray();
$barang_json = json_encode($barang);
return view('pembelian.ro.create', compact('barang', 'gudang', 'barang_json'));
}
public function diterima($id)
{
$pesanan = PengajuanBarang::find($id);
$pesanan->status = 'Diterima';
$pesanan->save();
Barang::firstOrCreate(['nama' => $pesanan['nama']]);
return redirect('pengajuan/index');
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('barangs', function (Blueprint $table) {
$table->increments('id');
$table->string('nama');
$table->integer('kuantitas');
$table->integer('pemakaian')->default(0);
$table->integer('pengadaan')->default(0);
$table->string('keterangan');
$table->boolean('used')->default(0);
$table->timestamps();
});
Barang::create(['nama' => 'Amplop Putih No. 104', 'keterangan' => 'pack', 'kuantitas' => '0', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Amplop Putih No. 90', 'keterangan' => 'pack', 'kuantitas' => '4', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Binder Clips No. 107', 'keterangan' => 'pack', 'kuantitas' => '36', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Binder Clips No. 155', 'keterangan' => 'pack', 'kuantitas' => '22', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Binder Clips No. 200', 'keterangan' => 'pack', 'kuantitas' => '21', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Binder Clips No. 260', 'keterangan' => 'pack', 'kuantitas' => '28', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Buku Ekspedisi', 'keterangan' => 'bh', 'kuantitas' => '20', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Buku Folio Bergaris', 'keterangan' => 'bh', 'kuantitas' => '17', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Buku Folio Bergaris 200', 'keterangan' => 'bh', 'kuantitas' => '2', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Buku Kwarto Bergaris ', 'keterangan' => 'bh', 'kuantitas' => '20', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Cellulose Tape Panfix', 'keterangan' => 'bh', 'kuantitas' => '12', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Cover Plastik', 'keterangan' => 'bh', 'kuantitas' => '1', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Cutter', 'keterangan' => 'bh', 'kuantitas' => '0', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Dispenser Tape', 'keterangan' => 'bh', 'kuantitas' => '5', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Isi Cutter L-500', 'keterangan' => 'bh', 'kuantitas' => '10', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Isi Stapler No. 10', 'keterangan' => 'pack', 'kuantitas' => '77', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Isi Stapler No. 3', 'keterangan' => 'pack', 'kuantitas' => '97', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas A4', 'keterangan' => 'rim', 'kuantitas' => '35', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas A4 Hijau', 'keterangan' => 'rim', 'kuantitas' => '28', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas A4 Kuning', 'keterangan' => 'rim', 'kuantitas' => '8', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas A4 Merah', 'keterangan' => 'rim', 'kuantitas' => '14', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas Concorde Hijau', 'keterangan' => 'pack', 'kuantitas' => '12', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas Concorde Kuning', 'keterangan' => 'pack', 'kuantitas' => '0', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas Faximile', 'keterangan' => 'rol', 'kuantitas' => '25', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas Folio 80 g', 'keterangan' => 'rim', 'kuantitas' => '3', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas Rol Mesin Hitung Panjang (65 x 68)', 'keterangan' => 'bh', 'kuantitas' => '18', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Kertas Rol Mesin Hitung Pendek', 'keterangan' => 'bh', 'kuantitas' => '8', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Lem O Glue', 'keterangan' => 'tube', 'kuantitas' => '24', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Ordner', 'keterangan' => 'bh', 'kuantitas' => '0', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Paper Clips Besar No. 5', 'keterangan' => 'pack', 'kuantitas' => '33', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Paper Clips Kecil No. 3', 'keterangan' => 'pack', 'kuantitas' => '21', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Perpurator/ Plong', 'keterangan' => 'bh', 'kuantitas' => '1', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Post It', 'keterangan' => 'pack', 'kuantitas' => '3', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Snelhecter Folio', 'keterangan' => 'bh', 'kuantitas' => '45', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Snowman', 'keterangan' => 'bh', 'kuantitas' => '38', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Stabilo', 'keterangan' => 'bh', 'kuantitas' => '27', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Stapler No. 10', 'keterangan' => 'bh', 'kuantitas' => '12', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Stapler No. 3', 'keterangan' => 'bh', 'kuantitas' => '9', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Stapler Remover', 'keterangan' => 'bh', 'kuantitas' => '10', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Stopmap', 'keterangan' => 'bh', 'kuantitas' => '161', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Tinta Stamp', 'keterangan' => 'tube', 'kuantitas' => '4', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
Barang::create(['nama' => 'Tipe-X', 'keterangan' => 'set', 'kuantitas' => '27', 'created_at' => new DateTime(), 'updated_at' => new DateTime()]);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$validator = Validator::make($request->all(), Barang::$rules, Barang::$pesan);
if ($validator->fails()) {
return response()->Json(array('errors' => $validator->errors()->toArray()));
} else {
Barang::create($request->all());
$barang = Barang::where('jumlahBarang', '<', 20)->get()->toArray();
event(new BarangRegistrationEvent($barang));
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$barang = Barang::find($id);
$barang->delete();
return redirect()->action('BarangController@index');
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$barang = Barang::all()->toArray();
return view('batch.create', compact('barang'));
}
public function barang()
{
$data = Barang::all();
return view('guest/guest_barang', compact('data'));
}
public function diterima($id)
{
// dd($id);
$list = $this->barangPesanan->all()->where('pesanan_barang_id', intval($id));
$length = sizeof($list);
$checklist = 0;
// dd($list, $length);
foreach ($list as $data) {
$check = Barang::find($data['barang_id']);
// dd($check['kuantitas']+$check['pengadaan']-$check['pemakaian'],$list,$data['kuantitas']);
if ($check['kuantitas'] + $check['pengadaan'] - $check['pemakaian'] >= $data['kuantitas']) {
$checklist++;
}
}
// dd($checklist, $length);
if ($checklist == $length) {
foreach ($list as $data) {
$check = Barang::find($data['barang_id']);
// $check['kuantitas'] -= $data['kuantitas'];
$check['pemakaian'] += $data['kuantitas'];
$check->save();
}
$pesanan = PesananBarang::find($id);
$pesanan->status = 'Diterima';
$pesanan->save();
return redirect('pesanan/index');
} else {
$pesanan = PesananBarang::find($id);
$pesanan->status = 'Harap Menunggu';
$pesanan->save();
return redirect('pesanan/index')->withErrors(['Terdapat barang yang belum tersedia, lakukan Pengadaan Barang!']);
}
}
public function destroy($id)
{
$barang = Barang::find($id);
$barang->delete();
}
public function getKodeBarang(Request $request)
{
$id = $request->input('idBarang');
$barang = Barang::where('idBarang', '=', $id)->get();
return $barang;
}
public function apiBarang()
{
$barang = Barang::all();
return $barang;
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$data = Barang::all();
return view('aktivitas.pesanan.create', compact('data'));
}
public function index()
{
$data = Barang::all();
return view('laporanpesanan.index', compact('data'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$data = Saldo::find($id);
$gudang = Gudang::all()->toArray();
$barang = Barang::all()->toArray();
$batch = Batch::all()->toArray();
return view('saldo.edit', compact('data', 'barang', 'gudang', 'batch'));
}
public function apiBarang(Request $request)
{
$kode = $request->input('kode');
$barang = Barang::where('kodeBarang', '=', $kode)->get();
return response()->json($barang);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$barang = Barang::find($id);
if ($barang->used == 0) {
$barang->delete();
return redirect()->action('BarangController@index');
} else {
return redirect()->back()->withErrors(['Barang sudah digunakan, tidak dapat dihapus!']);
}
}
/**
* Get an excel table export.
*
* @return Response
*/
public function export()
{
$barang = new Barang();
$barangs = $barang->get($barang->getFillable());
$barangs = $barangs->toArray();
if ($barangs == []) {
return view('barang.export');
}
return ExcelHelper::export($barangs, 'barangs');
}
/**
* Get the query object to be processed by dataTables.
*
* @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection
*/
public function query()
{
$query = Barang::select('*');
return $this->applyScopes($query);
}
