public function postOperasionalCabang() { $search = Request::get('cab'); if ($search == 0) { return $this->getIndex(); } $cabang = \App\cabang::find($search); $this->title = $this->title . ' - ' . $cabang->nama; $operasional = byoperasional::where('idcab', $search)->get(); return view('admin.report.operasional')->withInput(Request::all())->with('list', $operasional)->with('title', $this->title); }
/** * Bootstrap any application services. * * @return void */ public function boot() { date_default_timezone_set('Asia/Jakarta'); $abouts = array(); $news = array(); $memo = array(); Config::set('registered', false); $articles = \App\article::select('article.*', 'users.first_name', 'users.last_name')->leftJoin('users', 'article.user', '=', 'users.id')->get(); foreach ($articles as $article) { switch ($article->type) { case 'about': $abouts[] = $article; break; case 'news': $news[] = $article; break; case 'memo': $memo[] = $article; break; } } $kota = \App\kota::all(); foreach ($kota as $v) { $dkota[$v->idkota] = $v->nmkota; } $satuan = \App\satuan::all(); foreach ($satuan as $v) { $dsatuan[$v->idsatuan] = $v->namasatuan; } $cabang = \App\cabang::all(); foreach ($cabang as $v) { $dcabang[$v->idcabang] = $v->nama; } $dcabang = \App\Helpers::assoc_merge([0 => '--Daftar Cabang--'], $dcabang); //Hitung total quote yang baru $quotes = \App\quote::where('status', '=', '0'); $quotesData['all'] = $quotes->limit(3)->get(); $quotesData['count'] = $quotes->count(); //Hitung total SJT yang belum tiba $sjt = \App\berangkat::where('status', '<', '3'); $sjtData['all'] = $sjt->limit(3)->get(); $sjtData['count'] = $sjt->count(); //Hitung total tagihan yang belum terbayar $totNotification = $quotes->count() + $sjt->count(); $notification = ['all' => $totNotification, 'quote' => $quotesData, 'sjt' => $sjtData]; $data = array('abouts' => $abouts, 'news' => $news, 'memo' => $memo, 'kota' => $dkota, 'satuan' => $dsatuan, 'cabang' => $dcabang, 'nquotes' => $quotes, 'notification' => $notification); return View::share($data); }
public function penagihan() { $title = 'Laporan Tagihan Pengiriman'; $arrdata = Request::all(); $tagihan = \App\resi::select('resi.status', 'resi.noresi', 'resi.tglresi', 'resi.tagihan', 'resi.totalbiaya', 'resi.dp', 'resi.sisa', 'k.nama AS ppengirim', 'k.cp AS cppengirim', 't.nama AS ppenerima', 't.cp AS cppenerima'); $tagihan->leftJoin('konsumen AS k', 'k.idkonsumen', '=', 'resi.idkonsumen'); $tagihan->leftJoin('konsumen AS t', 't.idkonsumen', '=', 'resi.idpenerima'); $cab = 0; /* if($arrdata){ $title .= "<div class='form-inline'>"; $subtitle = []; if(Request::get('cabang')){ $tagihan->leftJoin('cabang','cabang.idcabang','=','resi.idcab'); $tagihan->where('resi.idcab','=',Request::get('cabang')); $cab = \App\cabang::where( 'idcabang','=',Request::get('cabang'))->first(); $subtitle[] = \App\Helpers::awsomeFilterLabel('Cabang',$cab->nama); } if(Request::get('tanggal')){ $tgl = explode("-",trim(Request::get('tanggal'))); $tgawal = $tgl[0]; $tgakhir = $tgl[1]; $tagihan->where('tglresi','>=',$tgawal); $tagihan->where('tglresi','<=',$tgakhir); $subtitle[] = \App\Helpers::awsomeFilterLabel('Tanggal',date_format(date_create($tgawal),'d M Y').' - '.date_format(date_create($tgakhir),'d M Y')); } if(Request::get('tagihan')){ $tagihan->where('tagihan','=',Request::get('tagihan')); $subtitle[] = \App\Helpers::awsomeFilterLabel('Ditagihkan ke',Request::get('tagihan')); } $count = count($subtitle); $i=0; do{ $title .= $subtitle[$i]; $i++; if($i<$count){$title .= ' ';} }while($i<$count); $title .= '</div>'; }*/ $tagihan->where('crbyr', 'Non Tunai'); $dtcabang = \App\cabang::all(); foreach ($dtcabang as $c) { $cabang[$c->idcabang] = $c->nama; } //dd($tagihan->get()); return view('laporan.penagihan')->with('title', $title)->with('tagihans', $tagihan->get())->with('cabang', $cabang); }
/** * Run the UserTableSeeder. * * @return void */ public function run() { //User::truncate(); User::create(['first_name' => 'yosef brahmantyo', 'last_name' => 'adi k', 'name' => 'bram', 'email' => '*****@*****.**', 'level' => 'SUPER', 'password' => Hash::make('123456'), 'photo' => 'dist/img/bram.jpg']); User::create(['first_name' => 'nico', 'last_name' => 'sitepu', 'name' => 'nico', 'email' => '*****@*****.**', 'level' => 'SUPER', 'password' => Hash::make('123456'), 'photo' => 'dist/img/nico.jpg']); User::create(['first_name' => 'Mr', 'last_name' => 'Owner', 'name' => 'owner', 'email' => '*****@*****.**', 'level' => 'MANAGER', 'password' => Hash::make('123456'), 'photo' => 'dist/img/avatar5.png']); User::create(['first_name' => 'staf', 'last_name' => '1', 'name' => 'staf1', 'email' => '*****@*****.**', 'level' => 'STAFF', 'password' => Hash::make('123456'), 'photo' => 'dist/img/avatar04.png']); ///////// cabang::create(['nama' => 'Cabang Bandung Pusat', 'alamat' => 'Jl.Suka Menak No.147', 'telp' => '022-123421']); /* ///for demo only //cabang cabang::create([ 'nama'=>'Cabang Pekan Baru', 'alamat'=>'Jl.Tetap Jaya No.212', 'telp'=>'' ]); cabang::create([ 'nama'=>'Cabang Medan', 'alamat'=>'Jl.Ngumban Surbakti', 'telp'=>'414214' ]); //armada armada::create([ 'nopolisi'=>'BK 212007 CD', 'jeniskendaraan'=>'Mitshubishi Fuso', 'tahun'=>'2000' ]); //jabatan jabatan::create([ 'nmjabatan'=>'Manager' ]); jabatan::create([ 'nmjabatan'=>'Administrasi' ]); jabatan::create([ 'nmjabatan'=>'Driver' ]); jabatan::create([ 'nmjabatan'=>'Kenek' ]); jabatan::create([ 'nmjabatan'=>'Gudang' ]); jabatan::create([ 'nmjabatan'=>'Programmer' ]); jabatan::create([ 'nmjabatan'=>'Teknisi' ]); //konsumen konsumen::create([ 'nama'=>'Ari Lasso Sitepu', 'alamat'=>'dfjsdnfasd', 'notelp'=>'12346', 'email'=>'sdfa@sdj', 'contactperson'=>'asas', 'tgldaftar'=>'2015-06-18' 'syn'=>'1' ]); konsumen::create([ 'nama'=>'Nico Stepanus Sitepu', 'alamat'=>'Jl.Anis No.01', 'notelp'=>'082115190115', 'email'=>'*****@*****.**', 'contactperson'=>'Athan Doe', 'tgldaftar'=>'2015-06-18' 'syn'=>'1' ]); konsumen::create([ 'nama'=>'Angelus Aron Rallo Sitepu', 'alamat'=>'Jl.Anis Oge', 'notelp'=>'081322967684', 'email'=>'*****@*****.**', 'contactperson'=>'Rallo', 'tgldaftar'=>'2015-06-18' 'syn'=>'1' ]); //pegawai pegawai::create([ 'nama'=>'Paijo', 'alamat'=>'Klaten', 'idjabatan'=>'3', 'tglrekrut'=>'2015-06-01', 'gajipokok'=>'300000.00', ]); pegawai::create([ 'nama'=>'Bejo', 'alamat'=>'Yogyakarta', 'idjabatan'=>'3', 'tglrekrut'=>'2015-06-02', 'gajipokok'=>'100000.00', ]); pegawai::create([ 'nama'=>'Enda', 'alamat'=>'Bandung ', 'idjabatan'=>'1', 'tglrekrut'=>'2015-06-23', 'gajipokok'=>'150000.00', ]); pegawai::create([ 'nama'=>'Nico Doe', 'alamat'=>'Sukanalu', 'idjabatan'=>'6', 'tglrekrut'=>'2005-01-01', 'gajipokok'=>'20000000.00', ]); // demo only */ }
public function getCabang() { $cabang = \App\cabang::all(); return $cabang; }
public function cabangEdit($id) { $cabang = cabang::find($id); if (Request::method() == 'POST') { $v = Validator::make(Request::all(), ['nama' => 'required', 'alamat' => 'required', 'telp' => 'max:15']); if ($v->fails()) { return redirect()->back()->withInput()->withErrors($v->errors()); } $cabang->nama = Request::get('nama'); $cabang->alamat = Request::get('alamat'); $cabang->telp = Request::get('telp'); $cabang->save(); return Redirect::to('/cabang'); } return view('pages.cabang-edit')->with('cabang', $cabang); }