コード例 #1
0
 public function get_data_detail_item($id)
 {
     $transaction = Transaction::where('transactions.id', '=', $id)->join('customers', 'transactions.customer_id', '=', 'customers.id')->join('users', 'transactions.user_id', '=', 'users.id')->select('transactions.*', 'customers.name', 'customers.address', 'customers.phone', 'customers.membership', 'users.name as username')->firstOrFail();
     $list_item = TransactionItem::where('transaction_items.transaction_id', '=', $id)->join('items', 'transaction_items.item_id', '=', 'items.id')->select('transaction_items.*', 'transaction_items.id as trans_item_id', 'items.name as item_name')->get();
     $data = array('transaction' => $transaction, 'item_transaction' => $list_item);
     return $data;
 }
コード例 #2
0
 public function store_item(Request $request)
 {
     $date_amount = $this->saved_date_format($request->input('date_amount'));
     $param_ac_id = $request->input('asset_categories_id');
     $valid_asset = AssetCategory::where('asset_categories.id', $param_ac_id)->join('asset_types', 'asset_types.id', '=', 'asset_categories.asset_type_id')->select('asset_categories.id as ac_id', 'asset_types.code as at_code', 'asset_categories.code as ac_code')->first();
     $kode_kategori = $valid_asset->ac_code;
     $kode_pengelompokan = $request->input('trans_gol_id');
     $tahun = Carbon::now()->toDateTimeString();
     $format = Carbon::parse($tahun)->format('y');
     $no_urut = TransactionItem::where('asset_categories_id', $param_ac_id)->get()->count();
     $before_urut = '000';
     if ($no_urut > 9) {
         $before_urut = '000';
     } elseif ($no_urut > 99) {
         $before_urut = '00';
     } elseif ($no_urut > 999) {
         $before_urut = '0';
     }
     $new_index = $kode_kategori . $kode_pengelompokan . $format . $before_urut . $no_urut + 1;
     $request->merge(array('date_amount' => $date_amount, 'index' => $new_index));
     $transaction_item = $request->input();
     $save_trans = TransactionItem::create($transaction_item);
     if ($request->file('url_photo') != '') {
         $imageName = $save_trans->id . '-barang.' . $request->file('url_photo')->getClientOriginalExtension();
         $request->file('url_photo')->move(base_path() . '/public/images/transaksi/barang/', $imageName);
     }
     Session::flash('flash_message', 'Data asset berhasil ditambahkan');
     return redirect()->back();
 }