public function getPokaz()
{
if (Session::has('nls')) {
$nls = Session::get('nls');
$user_info = Geng::with('npu')->where('nls', '=', $nls);
$poks = Pokaz::where('nls', '=', $nls)->limit(6)->get();
$pokk = DB::select('SELECT nls,status,kontr_pk,d_pok,n_pok,data_k FROM ((SELECT nls,status,kontr_pk,d_pok,n_pok,created_at as data_k FROM site_pokaz WHERE nls=? and kontr_pk NOT IN (SELECT kontr_pk FROM pokaz_k WHERE nls=?)) UNION (SELECT nls,status,kontr_pk,d_pok,n_pok,data_k FROM pokaz_k a where nls=? ORDER BY data_k DESC LIMIT 7)) as t2 ORDER BY t2.data_k', [$nls, $nls, $nls]);
if ($user_info->count()) {
$user_info = $user_info->first();
$tarif = Marsh::find($user_info->npu->tip);
Session::put('tar', $tarif->tar);
return View::make('pokaz.input_pok', compact('user_info', 'poks', 'tarif', 'pokk'));
} else {
return Redirect('/input/')->withInput()->withAlert(Lang::get('book.nls'));
}
} else {
return Redirect('/input/');
}
}
public function postOborot(Request $request)
{
$npu = $request->input('npu');
$dat_n = $request->input('dat_n');
$dat_k = $request->input('dat_k');
Session::put('dat_n', $dat_n);
Session::put('dat_k', $dat_k);
$meters = DB::connection('meters')->table('p_invent')->join('aparatos_inst', 'aparatos_inst.id_p_invent', '=', 'p_invent.id')->join('aparatos', 'aparatos.id', '=', 'aparatos_inst.id_aparato')->join('abonados', 'abonados.id_p_invent', '=', 'p_invent.id')->join('a_tipos', 'a_tipos.id', '=', 'aparatos.id_a_tipos')->where('id_device', $npu)->whereNull('aparatos_inst.fecha_quit')->orWhere('aparatos_inst.fecha_quit', '')->selectRaw('id_device,apartamento,c_individual,id_rmodulo,brife_name,c_div,ini_Wh_t0,aparatos_inst.fecha_inst,fases,f_fabricacion')->first();
$results = Geng::join('schet', 'g_eng.nls', '=', 'schet.nls')->join('mar_sh', 'mar_sh.tip', '=', 'schet.tip')->select('g_eng.nls', 'fio', 'data_of', 'propis', 'ul', 'nd', 'nkor', 'nkw', 'nkw1', 'chas', 'kom', 'telefon', 'telefons', 'telefonr', 'dat_vv', 'n_chet', 'dat_ust', 'god_v', 'plomba', 'nazw', 'pr_f', 'dat_gp', 'g_eng.tar', 'ktp', 'uch', 'inn', 'ntehusl', 'dtehusl')->where('g_eng.nls', $meters->c_individual)->first();
if (session()->has('dat_n') || session()->has('dat_k')) {
$dat_n = session('dat_n');
$dat_k = session('dat_k');
$oborots = DB::connection('meters')->table('indicaciones_rm')->where('id_rmodulo', $meters->id_rmodulo)->where('fecha', '>=', date("Y-m-d", strtotime($dat_n)))->where('fecha', '<=', date("Y-m-d", strtotime($dat_k)))->selectRaw('EXTRACT(YEAR FROM fecha) AS god, EXTRACT(MONTH FROM fecha) AS mes,DATE_FORMAT(fecha,"%d.%m.%Y") as fecha, impulsos')->get()->toArray();
} else {
$oborots = DB::connection('meters')->table('indicaciones_rm')->where('id_rmodulo', $meters->id_rmodulo)->selectRaw('EXTRACT(YEAR FROM fecha) AS god, EXTRACT(MONTH FROM fecha) AS mes,DATE_FORMAT(fecha,"%d.%m.%Y") as fecha, impulsos')->get()->toArray();
}
Session::put('npu', $npu);
$kontr_pk = false;
return View::make('admin.meters.oborot', compact('results', 'oborots', 'meters', 'kontr_pk'));
}
public function Adres(Request $request)
{
$street = $request->input('street');
if (Input::has("nd")) {
$dom = $request->input('nd');
} else {
$dom = $request->input('house');
}
$korp = $request->input('nkor');
$results = Geng::where('ul', '=', $street)->where('nd', '=', $dom)->where('nkor', '=', $korp)->get();
if ($results->isEmpty()) {
Session::flash('msg', 'Не найдено');
return redirect('/admin/card');
}
if ($results->count() == 1) {
$results = Geng::join('schet', 'g_eng.nls', '=', 'schet.nls')->join('mar_sh', 'mar_sh.tip', '=', 'schet.tip')->select('g_eng.nls', 'fio', 'data_of', 'propis', 'ul', 'nd', 'nkor', 'nkw', 'nkw1', 'chas', 'kom', 'telefon', 'telefons', 'telefonr', 'dat_vv', 'n_chet', 'dat_ust', 'god_v', 'plomba', 'nazw', 'pr_f', 'dat_gp', 'g_eng.tar', 'ktp', 'uch', 'inn', 'ntehusl', 'dtehusl')->where('ul', '=', $street)->where('nd', '=', $dom)->where('nkor', '=', $korp)->first();
$oborots = Oborot::selectRaw('god,mes,kol_lim,n_pok,DATE_FORMAT(data_n,"%d.%m.%y") as data_n,k_pok,DATE_FORMAT(data_k,"%d.%m.%y") as data_k,potr,summa,prim,prim,n_pok_n,k_pok_n,n_pok_n2,k_pok_n2,tar')->where('nls', $results->nls)->where('DAT_k', '>=', date("Y-m-d", strtotime("-6 month")))->Orderby('dat_k')->get();
return View::make('admin.agreement', compact('results', 'oborots'));
}
return View::make('admin.list', compact('results'));
}
