public function __construct()
{
$data = \App\konsumen::all();
foreach ($data as $k) {
$konsumen[$k->idkonsumen] = $k->nama == '' || $k->nama == '-' ? $k->cp : $k->nama;
}
return \View::share('konsumen', $konsumen);
}
public function konsumenEdit($id)
{
$konsumen = konsumen::find($id);
if (Request::method() == 'POST') {
$v = Validator::make(Request::all(), ['nama' => 'required', 'alamat' => 'required', 'telp' => 'required|numeric', 'email' => 'email']);
if ($v->fails()) {
$s = '';
return redirect()->back()->withErrors($v->errors())->with('konsumen', $s);
}
$konsumen->nama = Request::get('nama');
$konsumen->alamat = Request::get('alamat');
$konsumen->kota = Request::get('kota');
$konsumen->notelp = Request::get('telp');
$konsumen->cp = Request::get('contact');
$konsumen->email = Request::get('email');
$konsumen->tgldaftar = date('Y-m-d H:i:s');
$konsumen->save();
return Redirect::to('/konsumen');
}
return view('pages.konsumen-edit')->with('konsumen', $konsumen);
}
public function getKonsumen($id)
{
return konsumen::find($id)->toJson();
}
public function getTagihanCabang()
{
$arr = [];
$cab = Request::get('cabang');
$tagihanPengirim = piutang::select('piutang.*')->join('resi', function ($join) {
$join->on('resi.noresi', '=', 'piutang.noresi');
$join->on('resi.idkonsumen', '=', 'piutang.idkons');
})->join('rute', function ($join) {
$join->on('rute.sjt', '=', 'resi.idberangkat');
$join->on('rute.id', '=', 'resi.idrute');
})->where('resi.tagihan', 'Pengirim')->where('rute.kotamuat', $cab)->get();
$tagihanPenerima = piutang::select('piutang.*')->join('resi', function ($join) {
$join->on('resi.noresi', '=', 'piutang.noresi');
$join->on('resi.idpenerima', '=', 'piutang.idkons');
})->join('rute', function ($join) {
$join->on('rute.sjt', '=', 'resi.idberangkat');
$join->on('rute.id', '=', 'resi.idrute');
})->where('resi.tagihan', 'Penerima')->where('rute.kotabongkar', $cab)->get();
$tagihan = $tagihanPenerima->merge($tagihanPengirim);
return view('admin.report.penagihan')->with('kon', 0)->with('tagihan', $tagihan)->with('cab', $cab);
/*
$tagihan = resi::select('resi.*','piutang.status')
->rightJoin('rute AS rt',function($join){
$join->on('rt.sjt','=','resi.idberangkat');
$join->on('rt.id','=','resi.idrute');
})
->leftJoin('piutang','piutang.noresi','=','resi.noresi')
//->rightJoin('berangkat AS b','b.idberangkat','=','resi.idberangkat')
->where('resi.sisa','>',0)
->where('rt.status','>',1)->get();
return view('admin.report.penagihan')->with('kon',0)->with('tagihan',$tagihan)->with('cab',$cab);
//dd($tagihan);
if($cab){
$cabang = \App\cabang::where('idcabang','=',$cab)->first();
if($cabang)
{
$title = 'Tagihan '.$cabang->nama;
$tagihan->where('rt.kotamuat',$cab)->where('resi.tagihan','Pengirim');
$tagihan->orWhere('rt.kotabongkar',$cab)->where('resi.tagihan','Penerima');
foreach ($tagihan->get() as $d) {
if($d->tagihan=='Penerima'){
$arr[$d->idpenerima]['konsumen']=$d->penerima->nama;
$arr[$d->idpenerima]['jmlresi']=isset($arr[$d->idpenerima]['jmlresi'])?$arr[$d->idpenerima]['jmlresi']+1:1;
$arr[$d->idpenerima]['totalbiaya']=isset($arr[$d->idpenerima]['totalbiaya']) ? $arr[$d->idpenerima]['totalbiaya']+$d->totalbiaya : $d->totalbiaya;
$arr[$d->idpenerima]['dp']=isset($arr[$d->idpenerima]['dp']) ? $arr[$d->idpenerima]['dp']+$d->dp : $d->dp;
$arr[$d->idpenerima]['sisa']=isset($arr[$d->idpenerima]['sisa']) ? $arr[$d->idpenerima]['sisa']+$d->sisa : $d->sisa;
$arr[$d->idpenerima]['resi']=isset($arr[$d->idpenerima]['resi']) ? array_merge($arr[$d->idpenerima]['resi'],[$d]) : [$d];
}
if($d->tagihan=='Pengirim'){
$arr[$d->idkonsumen]['konsumen']=$d->pengirim->nama;
$arr[$d->idkonsumen]['jmlresi']=isset($arr[$d->idkonsumen]['jmlresi'])?$arr[$d->idkonsumen]['jmlresi']+1:1;
$arr[$d->idkonsumen]['totalbiaya']=isset($arr[$d->idkonsumen]['totalbiaya']) ? $arr[$d->idkonsumen]['totalbiaya']+$d->totalbiaya : $d->totalbiaya;
$arr[$d->idkonsumen]['dp']=isset($arr[$d->idkonsumen]['dp']) ? $arr[$d->idkonsumen]['dp']+$d->dp : $d->dp;
$arr[$d->idkonsumen]['sisa']=isset($arr[$d->idkonsumen]['sisa']) ? $arr[$d->idkonsumen]['sisa']+$d->sisa : $d->sisa;
$arr[$d->idkonsumen]['resi']=isset($arr[$d->idkonsumen]['resi']) ? array_merge($arr[$d->idkonsumen]['resi'],[$d]) : [$d];
}
}
$list = Collection::make($arr);
return view('admin.report.penagihan')->with('cab',$cab)->with('tagihans',$tagihan)->with('list',$list)->with('title',$title);
}
}
*/
if ($kon) {
$tagihan->where('idkonsumen', '=', $kon)->orWhere('idpenerima', '=', $kon);
$konsumen = \App\konsumen::find($kon);
return view('admin.report.penagihan-detail')->with('resi', $tagihan->get())->with('k', $konsumen);
}
return $this->getIndex();
}
public function profilEdit()
{
$user = \Auth::user();
$konsumen = \App\konsumen::where('iduser', '=', $user->id)->first();
$rules = ['nmperusahaan' => 'max:30', 'alamat' => 'required|min:3|max:100', 'kota' => 'required', 'email' => 'required', 'kpassword' => 'same:password'];
$messages = ['nmperusahaan.max' => 'Pengisian Nama Perusahaan maksimal 30 karakter', 'alamat.required' => 'Alamat Perusahaan harus diisi', 'alamat.min' => 'Alamat Perusahaan belum benar', 'alamat.max' => 'Alamat Perusahaan maksimal 100 karakter', 'kota' => 'Field Kota belum terisi', 'email.required' => 'Email harus diisi', 'kpassword.same' => 'Password konfimasi tidak sama'];
$validator = Validator::make(Request::all(), $rules, $messages);
if ($validator->fails()) {
return view('world.dashboard.profil')->with('user', $user)->with('konsumen', $konsumen)->withErrors($validator->errors());
}
$cekprofil = false;
$firstname = Request::get('contactfirst');
//contact first name
$lastname = Request::get('contactlast');
//contact last name
$space = $firstname && $lastname ? ' ' : '';
$contactperson = $firstname || $lastname ? $firstname . $space . $lastname : '';
$nmperusahaan = Request::get('nmperusahaan');
$alamat = Request::get('alamat');
$kota = Request::get('kota');
$notelp = Request::get('telp');
$email = Request::get('email');
$password = Request::get('password');
$kpassword = Request::get('kpassword');
//update data user
$user->name = $user->name;
//required. nama user
$user->email = $user->email;
//required. email user
$user->level = $user->level;
//required. level user
$user->password = Hash::make($password ? $password : $user->password);
//required. if empty use old password
$user->photo = 'dist/img/avatar.png';
$user->first_name = $firstname ? $firstname : '-';
$user->last_name = $lastname ? $lastname : '-';
$user->save();
//update data konsumen
$getuser = User::where('email', '=', $email)->get();
foreach ($getuser as $key => $value) {
$id = $value->id;
}
$konsumen->nama = $nmperusahaan ? $nmperusahaan : '-';
$konsumen->alamat = $alamat;
//required. alamat perusahaan
$konsumen->kota = $kota;
$konsumen->notelp = $notelp ? $notelp : '-';
$konsumen->email = $email;
$konsumen->cp = $contactperson;
$konsumen->tgldaftar = date('Y-m-d');
$konsumen->iduser = $id;
$konsumen->save();
return $this->index();
}
