/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
// get user id
// connect to farmbook and get default database
$database = Auth::user()->getDatabase();
//change database dynamically to user set database
$street = new Street();
$street->changeConnection($database);
$streets = Street::on($database)->orderBy('strStreetName', 'ASC')->lists('strStreetName', 'id');
$complexes = Complex::on($database)->orderBy('strComplexName', 'ASC')->lists('strComplexName', 'id');
// $owners = Owner::on($database )->orderBy('NAME','DESC')->lists('NAME', 'id');
$owners = Property::on($database)->orderBy('strOwners', 'DESC')->groupBy('strOwners')->lists('strOwners', 'id');
$properties = Property::on($database)->orderBy('strKey', 'ASC')->lists('strkey', 'id');
$erfs = Note::on($database)->orderBy('numErf', 'ASC')->lists('numErf', 'id');
return view('search', compact('streets', 'complexes', 'owners', 'properties', 'erfs'));
}
public function edit($id)
{
try {
// set database
$database = Auth::user()->getDatabase();
//change database
$property = new Property();
$property->changeConnection($database);
$properties = Property::on($database)->where('id', $id)->paginate(1);
$properties->load('owner', 'note');
// get all streets
$streets = Street::on($database)->orderBy('strStreetName', 'ASC')->lists('strStreetName', 'strStreetName');
// pass searched string
$search = $id;
$count = 1;
} catch (exception $e) {
dd($e->getMessage());
}
return view('property', compact('properties', 'count', 'search', 'streets'));
}
public function rolledit($id)
{
try {
// set database
$database = Auth::user()->getDatabase();
//change database
$property = new Property();
$property->changeConnection($database);
// search on street name
$query = Property::on($database)->where('strOwners', $id)->orderby('strOwners', 'ASC')->get();
$properties = Property::on($database)->where('strOwners', $id)->orderby('strOwners', 'ASC')->simplePaginate(1);
// get relationship data
$properties->load('owner', 'note');
// get total records as simplepagination does not do this
$count = $query->count();
$search = $id;
$streets = Street::on($database)->orderBy('strStreetName', 'ASC')->lists('strStreetName', 'strStreetName');
} catch (exception $e) {
dd($e->getMessage());
}
return view('property', compact('properties', 'count', 'search', 'streets'));
}
public function index(Request $request)
{
// set database
$database = Auth::user()->getDatabase();
//change database for Street
$street = new Street();
$street->changeConnection($database);
//change database for Street
$property = new Property();
$property->changeConnection($database);
// get inputs
$Input = $request->input('input');
$Select = $request->input('selected');
//dd( $streetInput,$streetSelect);
// check if input or select
// if input ignore select
if (strlen($Input) > 0) {
// search
$search = $Input;
$properties = Property::on($database)->like('strStreetName', $search)->orderby('strStreetName', 'ASC')->orderby('numStreetNo', 'ASC')->get();
} else {
// search
$street = Street::on($database)->where('id', $Select)->first();
$search = $street->strStreetName;
$properties = Property::on($database)->where('strStreetName', $search)->orderby('strStreetName', 'ASC')->orderby('numStreetNo', 'ASC')->get();
}
Session::put('search', $Select);
Session::put('controllerroute', '/street');
// view properties
// return with error if no result
if ($properties->count()) {
return view('streets', compact('properties', 'search'));
} else {
Session::flash('flash_message', '' . "No properties matching search criteria.");
Session::flash('flash_type', 'alert-danger');
return Redirect::back();
}
}
public function add(Request $request)
{
// set database
$database = Auth::user()->getDatabase();
//change database
$property = new Property();
$property->changeConnection($database);
// input street name
$newstreet = $request->input('street');
//dd($newstreet,$request);
// check if street exists
$query = Street::on($database)->where('strStreetName', $newstreet)->first();
//dd(strlen($newstreet));
if (is_null($query) && strlen($newstreet) > 0) {
try {
Session::flash('flash_message', '' . "Ok to add as not found");
Session::flash('flash_type', 'alert-success');
} catch (exception $e) {
Session::flash('flash_message', '' . $e->getMessage());
Session::flash('flash_type', 'alert-danger');
}
} else {
Session::flash('flash_message', '' . "Street already exists.");
Session::flash('flash_type', 'alert-danger');
}
return Redirect::back();
}
/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
// set database
$database = Auth::user()->getDatabase();
//change database
$property = new Property();
$property->changeConnection($database);
$query1 = Property::on($database)->select([DB::raw('cast(dtmRegDate as date) as dd'), DB::raw('count(dtmRegDate) as sales'), DB::raw('max(strAmount) as high'), DB::raw('avg(strAmount) as avg')])->groupBy(DB::raw('Year(dd)'))->get();
$min = $query1->min('dd');
$max = $query1->max('dd');
$dateStart = Carbon::createFromFormat('Y-m-d', $min);
$dateEnd = Carbon::createFromFormat('Y-m-d', $max);
$diffInYears = $dateStart->diffInYears($dateEnd, false);
$Amin = Property::on($database)->min('strAmount');
$Amax = Property::on($database)->max('strAmount');
$sum = Property::on($database)->sum('strAmount');
$avg = Property::on($database)->where('strAmount', '>', 0)->avg('strAmount');
// dd($min,$max,$Amin,$Amax,$sum,$avg,$dateStart,$dateEnd,$diffInYears);
$stocksTable = Lava::DataTable();
// Lava::DataTable() if using Laravel
$stocksTable->addStringColumn('Date')->addNumberColumn('Registered');
// ->addNumberColumn('Bond');
// Random Data For Example
foreach ($query1 as &$q) {
// echo substr($q->dd,0,4).' - '. $q->sales;
// echo "<br>";
$mdate = intval(substr($q->dd, 0, 4));
if ($mdate > 2004) {
// dd($q->dd);
$stocksTable->addRow([$mdate, $q->sales]);
}
}
// chart - price
//-------------------------------------------------------------------
$priceTable = Lava::DataTable();
// Lava::DataTable() if using Laravel
$priceTable->addStringColumn('Date')->addNumberColumn('Avg Price');
foreach ($query1 as $key => $q) {
// echo substr($q->dd,0,4).' - '. $q->sales;
// echo "<br>";
$mdate = intval(substr($q->dd, 0, 4));
if ($mdate > 2004) {
$priceTable->addRow([$mdate, intval($q->avg)]);
}
}
$c1 = Street::on($database)->count('id');
$c2 = Complex::on($database)->count('id');
$c3 = Property::on($database)->select('id')->groupBy('strKey')->get()->count();
$c4 = Property::on($database)->count('id');
$votes = Lava::DataTable();
$votes->addStringColumn('Food Poll')->addNumberColumn('Count')->addRow(['Streets', $c1])->addRow(['Complexes', $c2])->addRow(['Properties', $c3])->addRow(['Owners', $c4]);
// chart -age
//-------------------------------------------------------------------
$queryAge = Property::on($database)->select('strKey', 'strSellers', 'dtmRegDate')->distinct('strIdentity')->OrderBy('dtmRegDate')->GroupBy('dtmRegDate')->get();
$queryAge = $queryAge->toArray();
// dd($queryAge);
$ageTable = Lava::DataTable();
// Lava::DataTable() if using Laravel
$ageTable->addStringColumn('Date')->addNumberColumn('Avg Age');
$agedate = array();
for ($x = 0; $x <= sizeof($queryAge) - 1; $x++) {
$seller = substr($queryAge[$x]['strSellers'], -13);
if (is_numeric($seller) && strlen(ltrim(rtrim($seller))) == 13) {
$born = substr($seller, 0, 2);
$age = 116 - $born;
$mdate = intval(substr($queryAge[$x]['dtmRegDate'], 0, 4));
// echo $queryAge[$x]['strKey'] . " - " . $mdate . " - " . $seller . ' - ' . $age . " <br>";
$agegate = array_push($agedate, ['date' => $mdate, 'age' => $age]);
}
}
$collection = collect($agedate);
$coll = $collection->groupBy('date');
//dd($coll);
$ageTable->addRow([$mdate, $age]);
// dd($queryAge, $queryAge->count(), $seller);
$agechart = Lava::LineChart('Ages', $ageTable, ['title' => "Sellers Age ", 'colors' => ['Cyan']]);
$chart = Lava::LineChart('Registrations', $stocksTable, ['title' => "Properties registered ", 'colors' => ['blue']]);
$chart2 = Lava::LineChart('Prices', $priceTable, ['title' => "Average price ", 'colors' => ['green', 'red'], 'vAxis' => ['format' => 'R###,###,###,###']]);
$chart3 = Lava::BarChart('Votes', $votes, ['title' => "Totals ", 'colors' => ['DeepSkyBlue']]);
//$chart3 = Lava::BarChart('Votes', $votes);
return view('dashboard');
}