/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
protected function create(array $data)
{
$user = User::create(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password'])]);
$month = new Month();
$month->userID = $user->id;
$month->cash = 0.0;
$month->income = 0.0;
$month->profit = 0.0;
$month->name = date('M');
$month->year = date('Y');
$month->save();
return $user;
}
function getAttendance($member = '')
{
$input = Input::all();
if ($member == null or $member == '') {
$memberId = Session::get('memberId');
} else {
$memberId = $member;
}
if (array_key_exists('date', $input)) {
$year = date("Y", strtotime($input['date']));
$startDate = $year . '-01-01';
$endDate = $startDate . '12-31';
} else {
$year = date("Y");
$startDate = $year . '-01-01';
$endDate = $year . '-12-31';
}
$month = array_key_exists('month', $input) ? $input['month'] : date('F');
$month = Month::ForMonth($month)->first();
if (!empty($month)) {
$attendance = $month->attendances()->DateBetween($startDate, $endDate)->ForMember($memberId)->get();
$attendances = $this->AverageMonthAttendance($attendance, $month, $year);
return $attendances;
} else {
return Redirect::to('/auth/dashboard')->withFlashMessage('No Attendnce for the month');
}
}
function make($data)
{
$month = Month::ForMonth('January')->first();
$config['month_id'] = $month->id;
$config['member_id'] = Session::get('memberId');
$config['date'] = $data['date'];
if (array_key_exists('check_in', $data)) {
$config['check_in'] = $data['check_in'];
$attendance = Attendance::ForUniqueCheck($config['member_id'], $config['date'])->first();
if (empty($attendance)) {
Attendance::create($config);
} else {
throw new Exception('You Already have check In for the day');
}
}
if (array_key_exists('check_out', $data)) {
$config['check_out'] = $data['check_out'];
// foreach($data as $key => $value)
// {
// $this->is_empty($value);
// }
// $this->is_valid($this->checkInFlag);
$attendance = Attendance::ForUniqueCheck($config['member_id'], $config['date'])->first();
if (empty($attendance)) {
throw new Exception('You Havent check in yet');
}
if ($attendance->check_out === '00:00:00') {
$attendance->update($data);
} else {
throw new Exception('You Already have check out for the day');
}
}
}
public function index(\App\Gameweek $gameweek = null, \App\Month $month = null)
{
$user = null;
$users = \App\User::ranked()->orderBy('rank')->get();
$lastFixture = \App\Fixture::over()->orderBy('kickoff', 'desc')->first();
$activeTabs = ['active', '', ''];
if (!$month or !$month->hasStarted()) {
$month = $lastFixture->gameweek->month;
} else {
$activeTabs = ['', 'active', ''];
}
if (!$gameweek or !$gameweek->hasCompletedFixture()) {
$gameweek = $lastFixture->gameweek;
} else {
$activeTabs = ['', '', 'active'];
}
if (\Auth::check()) {
$user = \Auth::user();
}
$months = \App\Month::orderBy('id', 'desc')->get()->filter(function ($month) {
return $month->hasStarted();
});
$gameweeks = \App\Gameweek::orderBy('id', 'desc')->get()->filter(function ($gw) {
return $gw->hasCompletedFixture();
});
$gameweekUsers = $gameweek->predictors()->orderBy('gameweek_user.rank', 'asc')->get();
$monthUsers = $month->users()->orderBy('month_user.rank', 'asc')->get();
$nameOfPage = 'standings';
return view('pages.standings', compact('gameweeks', 'months', 'users', 'gameweekUsers', 'monthUsers', 'month', 'gameweek', 'user', 'activeTabs', 'nameOfPage'));
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
$faults = Attendfault::where('attended', '=', 'No')->get();
$months = Month::all();
$states = State::all();
View::share(['counts' => $faults, 'states' => $states, 'months' => $months]);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
//This creates a new Entry in the Month table and carries over the data from last month.
$months = DB::select('select * from month where name = :month and year = :year', ['month' => date("M"), 'year' => date("Y")]);
if ($months) {
} else {
$months = DB::select('select * from month');
foreach ($months as $month) {
$new = new Month();
$new->userID = $month->userID;
$new->cash = $month->cash;
$new->year = date("Y");
$new->name = date("M");
$new->save();
}
}
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
* @return void
*/
public function boot(Router $router)
{
parent::boot($router);
$router->bind('username', function ($username) {
return \App\User::where('username', $username)->firstOrFail();
});
$router->bind('gwid', function ($gwid) {
return \App\Gameweek::where('id', $gwid)->firstOrFail();
});
$router->bind('monthid', function ($monthid) {
return \App\Month::where('id', $monthid)->firstOrFail();
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('month')->delete();
Month::create(['title' => 'Январь']);
Month::create(['title' => 'Февраль']);
Month::create(['title' => 'Март']);
Month::create(['title' => 'Апрель']);
Month::create(['title' => 'Май']);
Month::create(['title' => 'Июнь']);
Month::create(['title' => 'Июль']);
Month::create(['title' => 'Август']);
Month::create(['title' => 'Сентябрь']);
Month::create(['title' => 'Октябрь']);
Month::create(['title' => 'Ноябрь']);
Month::create(['title' => 'Декабрь']);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$months = Month::lists('name', 'id')->toArray();
$runningGameweeks = Gameweek::incomplete()->get()->filter(function ($gw) {
return $gw->started();
});
$runningGameweeks->each(function ($gw, $key) {
$gw->overFixtureCnt = $gw->fixtures()->over()->get()->count();
$gw->pendingFixtureCnt = $gw->fixtures()->get()->filter(function ($fxt) {
return $fxt->isClosed() and !$fxt->isOver();
})->count();
});
$upcomingGameweeks = Gameweek::incomplete()->get()->filter(function ($gw) {
return !$gw->started();
});
$completeGameweeks = Gameweek::complete()->get();
return view('admin.gameweek.index', compact('months', 'runningGameweeks', 'upcomingGameweeks', 'completeGameweeks'));
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
//add check for row in month table with correct month
//make it if not there.
$user = Auth::user();
$month = Input::get('month');
$year = Input::get('year');
$banks = DB::select('select * from accounts where userID = :id and accountType = "b"', ['id' => $user->id]);
$cc = DB::select('select * from accounts where userID = :id and accountType = "c"', ['id' => $user->id]);
$credits = DB::select('select * from income where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$accounts = DB::select('select * from accounts where userID = :id', ['id' => $user->id]);
$debits = DB::select('select * from transactions where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$transfers = DB::select('select * from transfers where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$payments = DB::select('select * from payments where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
if ($credits || $debits) {
$accountNames = [];
foreach ($accounts as $account) {
$accountNames = $accountNames + [$account->id => $account->name];
}
$monthData = Month::where('userID', $user->id)->where('name', $month)->where('year', $year)->first();
$income = $monthData->income;
$profit = $monthData->profit;
//prepare spending amounts for types for the pie chart.
$types = DB::select('select * from types where userID = :id order by name ASC', ['id' => $user->id]);
$spending = [];
$typeNames = [];
foreach ($types as $type) {
$typeNames = $typeNames + [$type->id => $type->name];
$tmp = DB::select('select * from transactions where userID = :id and month = :month and typeID = :typeID and year = :year', ['id' => $user->id, 'month' => $month, 'typeID' => $type->id, 'year' => $year]);
$sum = 0;
foreach ($tmp as $i) {
$sum = $sum + $i->amount;
}
if ($sum != 0) {
array_push($spending, ["sum" => $sum, "name" => $type->name]);
}
}
arsort($spending);
return view('view-past')->with('month', $month)->with('year', $year)->with('income', $income)->with('profit', $profit)->with('spending', $spending)->with('accountNames', $accountNames)->with('typeNames', $typeNames)->with('transactions', $debits)->with('incomeData', $credits)->with('payments', $payments)->with('transfers', $transfers);
} else {
return view('view-past-no-data');
}
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
//add check for row in month table with correct month
//make it if not there.
$user = Auth::user();
$month = date("M");
$year = date('Y');
$banks = DB::select('select * from accounts where userID = :id and accountType = "b"', ['id' => $user->id]);
$cc = DB::select('select * from accounts where userID = :id and accountType = "c"', ['id' => $user->id]);
$credits = DB::select('select * from income where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$accounts = DB::select('select * from accounts where userID = :id', ['id' => $user->id]);
$debits = DB::select('select * from transactions where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$transfers = DB::select('select * from transfers where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$payments = DB::select('select * from payments where userID = :id and month = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => $year]);
$accountNames = [];
foreach ($accounts as $account) {
$accountNames = $accountNames + [$account->id => $account->name];
}
$income = 0;
$spent = 0;
//sum up for months profit
foreach ($credits as $credit) {
$income += $credit->amount;
}
foreach ($debits as $debit) {
if ($debit->accountID == 0 && $debit->month == date("M")) {
$spent = $spent + $debit->amount;
} else {
//check to make sure teh cc id is not a bank if so this is a transfer and doesn't get counted
$account2 = Account::find($debit->accountID);
if ($account2->accountType == 'b' && $debit->month == date("M")) {
//this is a payment on a cc
$spent = $spent + $debit->amount;
}
}
}
foreach ($payments as $payment) {
if ($payment->month == date("M")) {
$spent = $spent + $payment->amount;
}
}
$profit = $income - $spent;
$monthData = Month::where('userID', $user->id)->where('name', date("M"))->where('year', date("Y"))->first();
$monthData->income = $income;
$monthData->profit = $profit;
$monthData->save();
//prepare spending amounts for types for the pie chart.
$types = DB::select('select * from types where userID = :id order by name ASC', ['id' => $user->id]);
$spending = [];
$typeNames = [];
foreach ($types as $type) {
$typeNames = $typeNames + [$type->id => $type->name];
$tmp = DB::select('select * from transactions where userID = :id and month = :month and typeID = :typeID and year = :year', ['id' => $user->id, 'month' => $month, 'typeID' => $type->id, 'year' => $year]);
$sum = 0;
foreach ($tmp as $i) {
$sum = $sum + $i->amount;
}
if ($sum != 0) {
array_push($spending, ["sum" => $sum, "name" => $type->name]);
}
}
arsort($spending);
$cash = DB::select('select cash from month where userID = :id and name = :month and year = :year', ['id' => $user->id, 'month' => $month, 'year' => date("Y")]);
return view('home')->with('banks', $banks)->with('cc', $cc)->with('income', $income)->with('profit', $profit)->with('spending', $spending)->with('cash', $cash)->with('accountNames', $accountNames)->with('typeNames', $typeNames)->with('transactions', $debits)->with('incomeData', $credits)->with('payments', $payments)->with('transfers', $transfers);
}
public function edit_announcement($id)
{
$fields = Field::orderBy('name')->lists('name', 'id');
$terms = Term::lists('name', 'id');
$municipalities = Municipality::lists('name', 'id');
$regions = Region::lists('name', 'id');
$type = array(0 => 'ვატარებ', 1 => 'ვეძებ');
$quarter = Quarter::all()->lists('name', 'id');
$months = Month::all()->lists('name', 'id');
$select = DB::select(' SELECT trainings.id, field_training.field_id, term_training.term_id, municipality_training.municipality_id, month_training.month_id
FROM trainings
JOIN field_training ON trainings.id = field_training.training_id
JOIN term_training ON trainings.id = term_training.training_id
JOIN municipality_training ON trainings.id = municipality_training.training_id
JOIN month_training ON trainings.id = month_training.training_id
where trainings.id = ' . $id . '
group by trainings.id
');
$select = $select[0];
$training_filtered = new \stdClass();
$training_instance = Training::find($select->id);
$training_field = Field::find($select->field_id);
$training_municipality = Municipality::find($select->municipality_id);
$training_months = DB::select('SELECT months.name FROM month_training JOIN months ON months.id = month_training.month_id WHERE training_id = ' . $training_instance->id);
$training_terms = DB::select('SELECT terms.name FROM term_training JOIN terms ON terms.id = term_training.term_id WHERE training_id = ' . $training_instance->id);
foreach ($training_months as $month) {
$training_months_array[] = $month->name;
}
foreach ($training_terms as $term) {
$training_terms_array[] = $term->name;
}
$training_filtered->id = $training_instance->id;
$training_filtered->header = $training_instance->name;
$training_filtered->description = $training_instance->description;
$training_filtered->file = $training_instance->file;
$training_filtered->link = $training_instance->link;
$training_filtered->field['name'] = $training_field->name;
$training_filtered->field['id'] = $training_field->id;
$training_filtered->months = $training_months_array;
$training_filtered->terms = $training_terms_array;
$training_filtered->municipality['name'] = $training_municipality->name;
$training_filtered->municipality['id'] = $training_municipality->id;
$training_filtered->region = $training_municipality->region_id;
$training_filtered->isAdmin = Auth::check();
return view('edit.edit_announcement', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipalities' => $municipalities, 'quarter' => $quarter, 'month' => $months, 'type' => $type, 'training' => $training_filtered]);
}
public function add_announcement()
{
if (!Auth::user() || Auth::user()->role != 1) {
return redirect('/');
}
$fields = Field::orderBy('name')->lists('name', 'id');
$terms = Term::lists('name', 'id');
$municipalities = Municipality::all();
$municipality_regions = array();
foreach ($municipalities as $m) {
$municipality_regions[] = array('municipality' => $m, 'region' => $m->region);
}
$regions = Region::lists('name', 'id');
$type = array(0 => 'ვატარებ', 1 => 'ვეძებ');
$quarter = Quarter::all()->lists('name', 'id');
$month = Month::all()->lists('name', 'id');
return view('add_forms.add_announcement', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipality_regions' => $municipality_regions, 'quarter' => $quarter, 'month' => $month, 'type' => $type]);
}
public function render_form_data()
{
$fields = Field::orderBy('name')->lists('name', 'id');
$terms = Term::lists('name', 'id');
$municipalities = Municipality::all();
$municipality_regions = array();
foreach ($municipalities as $m) {
$municipality_regions[] = array('municipality' => $m, 'region' => $m->region);
}
$regions = Region::lists('name', 'id');
$type = array(0 => 'ვატარებ', 1 => 'ვეძებ');
$quarter = Quarter::all()->lists('name', 'id');
$month = Month::all()->lists('name', 'id');
return view('search_forms.search', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipality_regions' => $municipality_regions, 'quarter' => $quarter, 'month' => $month, 'type' => $type]);
}
public function postIndex()
{
$user = Auth::user();
$id = Input::get('payment');
/*
*There is an invisible field called form that tells what form was submitted
*
*/
if (Input::get('form') == 'trans') {
$monthNum = substr(Input::get('date'), 0, 2);
$month = date('M', mktime(0, 0, 0, $monthNum, 10));
$year = substr(Input::get('date'), -4);
$transaction = new Transaction();
$transaction->userID = $user->id;
$transaction->date = Input::get('date');
$transaction->amount = Input::get('amount');
$transaction->typeID = Input::get('type');
$transaction->note = Input::get('note');
$transaction->year = $year;
$transaction->month = $month;
if ($id == 'cash') {
$month = Month::where('userID', $user->id)->where('name', $month)->where('year', date("Y"))->first();
$month->cash -= Input::get('amount');
$month->save();
$transaction->accountID = 0;
} else {
$transaction->accountID = $id;
$account = Account::find($id);
//add for credit subtract for bank
if ($account->accountType == 'c') {
$account->balance += Input::get('amount');
} else {
$account->balance -= Input::get('amount');
}
$account->save();
}
$transaction->save();
return redirect('options')->with('message', 'Transaction added successfully.');
} else {
if (Input::get('form') == 'type') {
$type = new Type();
$type->userID = $user->id;
$type->name = Input::get('name');
$type->save();
return redirect('options')->with('message', 'Category added successfully.');
} else {
if (Input::get('form') == 'payment') {
$monthNum = substr(Input::get('date'), 0, 2);
$month = date('M', mktime(0, 0, 0, $monthNum, 10));
$year = substr(Input::get('date'), -4);
$amount = Input::get('amount');
$bankID = Input::get('bank');
$ccID = Input::get('payment');
$note = Input::get('note');
$date = Input::get('date');
if ($ccID == 'cash') {
$month2 = Month::where('userID', $user->id)->where('name', $month)->first();
$month2->cash = $month2->cash + $amount;
$month2->save();
if ($bankID == 'cash') {
$month2 = Month::where('userID', $user->id)->where('name', $month)->first();
$month2->cash = $month2->cash - $amount;
$month2->save();
} else {
$bank = Account::find($bankID);
$bank->balance = $bank->balance - $amount;
$bank->save();
}
$transfer = new Transfer();
$transfer->userID = $user->id;
$transfer->creditAccountID = $bankID;
$transfer->debitAccountID = 0;
$transfer->amount = $amount;
$transfer->note = $note;
$transfer->date = $date;
$transfer->year = $year;
$transfer->month = $month;
$transfer->save();
} else {
$cc = Account::find($ccID);
if ($bankID == 'cash') {
$month2 = Month::where('userID', $user->id)->where('name', $month)->first();
$month2->cash = $month2->cash - $amount;
$month2->save();
} else {
$bank = Account::find($bankID);
$bank->balance = $bank->balance - $amount;
$bank->save();
}
if ($cc->accountType == 'b') {
//transfer
$cc->balance = $cc->balance + $amount;
$transfer = new Transfer();
$transfer->userID = $user->id;
$transfer->creditAccountID = $bankID;
$transfer->debitAccountID = $ccID;
$transfer->amount = $amount;
$transfer->note = $note;
$transfer->date = $date;
$transfer->year = $year;
$transfer->month = $month;
$transfer->save();
} else {
//payment
$cc->balance = $cc->balance - $amount;
$payment = new Payment();
$payment->userID = $user->id;
$payment->creditAccountID = $bankID;
$payment->debitAccountID = $ccID;
$payment->amount = $amount;
$payment->note = $note;
$payment->date = $date;
$payment->year = $year;
$payment->month = $month;
$payment->save();
}
$cc->save();
}
return redirect('options')->with('message', 'Payment saved successfully.');
} else {
if (Input::get('form') == 'cc') {
$cc = new Account();
$cc->userID = $user->id;
$cc->name = Input::get('name');
$cc->balance = Input::get('balance');
$cc->creditLimit = Input::get('limit');
$cc->statementDay = Input::get('date');
$cc->accountType = 'c';
$cc->save();
return redirect('options')->with('message', 'Credit Card added successfully.');
} else {
if (Input::get('form') == 'bank') {
$bank = new Account();
$bank->userID = $user->id;
$bank->name = Input::get('name');
$bank->balance = Input::get('balance');
$bank->accountType = 'b';
$bank->save();
return redirect('options')->with('message', 'Bank Account added successfully.');
} else {
if (Input::get('form') == 'income') {
$date = Input::get('date');
$monthNum = substr($date, 0, 2);
$month = date('M', mktime(0, 0, 0, $monthNum, 10));
$amount = Input::get('amount');
$bankID = Input::get('bank');
$year = substr(Input::get('date'), -4);
$income = new Income();
$income->userID = $user->id;
$income->month = $month;
$income->amount = $amount;
$income->note = Input::get('note');
$income->date = $date;
$income->year = $year;
if ($bankID == "cash") {
$income->accountID = 0;
$month = Month::where('userID', $user->id)->where('name', $month)->first();
$month->cash = $month->cash + $amount;
$month->save();
} else {
$income->accountID = $bankID;
$bank = Account::find($bankID);
$bank->balance = $bank->balance + $amount;
$bank->save();
}
$income->save();
return redirect('options')->with('message', 'Income added successfully.');
}
}
}
}
}
}
}
public function incomeDelete($id)
{
$user = Auth::user();
$date = Input::get('date');
$amount = Input::get('amount');
$bankID = Input::get('bank');
$note = Input::get('note');
$income = Income::where('id', $id)->where('userID', $user->id)->first();
if ($income->accountID == 0) {
$month = Month::where('userID', $user->id)->where('name', date('M'))->first();
$month->cash = $month->cash - $income->amount;
$month->save();
} else {
$origBank = Account::find($income->accountID);
//add original transaction value to bank account
$origBank->balance = $origBank->balance - $income->amount;
$origBank->save();
}
$income->forceDelete();
return redirect('home')->with('message', 'Income deleted successfully.');
}
