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);
}
