public function newversion($prop_id)
{
// $obj=DB::transaction(function($connection) {
$var = INPUT::all();
$user = Auth::user()->user();
/*$mod=new Proposal;
$mod=$mod::find($prop_id);
$mod->field=$var['fieldName'];
$mod->title>$var['title_g'];
$mod->team_members=$var['teamMembers'];
$mod->research_place=$var['researchPlace'];
$mod->end_date_of_proposal=$var['duration'];
$mod->proposed_amount=$var['grantNeeded'];
$mod->description=$var['propDescription'];
$mod->userid=$user['id'];
$mod->save();*/
$ver = \App\proposal_version::where('proposal_id', '=', $prop_id)->first();
$ver_num = $ver->version_number;
$ver_num += 1;
$a = \App\Proposal::find($prop_id);
$filename = $user['id'] . '_' . $a->title . '_' . $ver_num . '.';
$filename .= $var['grantProposal']->getClientOriginalExtension();
$var['grantProposal']->move(storage_path('uploads/grant_proposals'), $filename);
$obj = new \App\proposal_version();
$obj::create(['version_number' => $ver_num, 'version_path' => $filename, 'proposal_id' => $prop_id]);
$ver->destroy($ver->id);
// });
return $this->allgrants();
}
public function compose($view)
{
$proposals = Proposal::all();
$proposals_count = $proposals->count();
$approvals_count = Approval::all()->count();
$users_count = User::all()->count();
$not_responded_count = round($proposals->where('approved_by', null)->where('disapproved_by', null)->where('response', null)->count() / $proposals->count() * 100, 2);
$view->with(compact('proposals_count'))->with(compact('approvals_count'))->with(compact('users_count'))->with(compact('not_responded_count'));
}
public function testClickProposal()
{
$proposal = Proposal::paginate(20)->shuffle()->first();
$url_proposal = '/proposals/' . $proposal->id;
//dd($proposal->id, $url_proposal);
$this->visit('/proposals')->click($proposal->name);
// ->see($proposal->name)
// ->see($proposal->central_idea)
// ->see($proposal->problem);
// ->seePageIs($url_proposal);
}
/**
* Update the specified resource in storage.
*
* @param int $id
*
* @return Response
*/
public function update_proposal_like($id, LikeFormRequest $formRequest)
{
$proposal = Proposal::findOrFail($id);
$input = $formRequest->except('_token');
$input['user_id'] = Auth::user()->id;
$input['open'] = true;
$input['pub_date'] = Carbon::now();
$input['limit_date'] = Carbon::now();
// update Proposal
$proposal->fill($input)->save();
return Redirect::route('proposals')->with('proposal_crud_msg', 'Like Registrado com Sucesso');
}
public function makechanges($id)
{
$var = INPUT::all();
$obj = new \App\proposal_comment();
$obj1 = new \App\proposal_version();
$mod = \App\Proposal::join('proposal_versions', 'proposals.id', '=', 'proposal_versions.proposal_id')->where('proposals.id', '=', $id)->orderby('proposal_versions.id', 'DESC')->select('proposal_versions.id')->first();
$obj->comments = $var['comments'];
$obj->type = 1;
$obj->proposal_version_id = $mod->id;
$obj->save();
$obj1 = $obj1::find($mod->id);
$obj1->research_status = $var['status'];
$obj1->save();
/*return $mod->id;
if($var['status'])
{
if($var['status']==0)
{
$obj1->research_status=0;
//$obj1->save();
}
if($var['status']==1)
{
$obj1->research_status=1;
// $obj1->save();
}
/* if($var['status']==2)
{
$obj1->research_status=2;
$obj1->save();
}*/
/*if($var['status']==3)
{
$obj1->research_status=3;
$obj1->save();
}*/
// $obj1->save();
return $this->allgrants();
//return $var['status'];
}
public function testProposalPaginates()
{
factory(App\Proposal::class, 50)->create();
$proposals = App\Proposal::paginate(20);
$this->assertEquals(20, $proposals->count());
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Proposal::where('in_committee', false)->update(['in_committee' => null]);
}
/**
* Remove the specified resource from storage.
*
* @param Project $project
* @param Module $module
* @param Page $page
* @param Image $image
* @param Proposal $proposal
* @return \Illuminate\Http\Response
* @throws \Exception
*/
public function destroy(Project $project, Module $module, Page $page, Image $image, Proposal $proposal)
{
$proposal->delete();
return redirect()->back();
}
/**
* Store the specified proposal in storage.
*
* @param int $id
*
* @return Response
*/
public function storeProposal(ProposalFormRequest $formRequest)
{
$input = $formRequest->except('_token');
$input['user_id'] = Auth::user()->id;
$input['open'] = true;
$input['pub_date'] = Carbon::now();
$input['limit_date'] = Carbon::now();
//dd($input);
$proposal = Proposal::create($input);
//event(new ProposalWasCreated($proposal));
//Event::fire(new ProposalWasCreated($proposal));
return redirect()->route('admin.proposal.show', ['proposal' => $proposal])->with('admin_proposal_crud_msg', 'Ideia Legislativa Incluída com Sucesso');
}
public function getProposalsRespondedCountAttribute()
{
return Proposal::where('responder_id', $this->id)->count();
}
/**
* Get proposal by ID.
*
* @param int $proposalId
*
* @return Collection
*/
public function byId($proposalId)
{
return Proposal::find($proposalId);
}
/**
* @return mixed
*/
public function filterProposals($q, $s)
{
if (empty($q)) {
$q = 'open';
}
// Users cannot see what's not approved
$query = Proposal::whereNotNull('approved_by');
if ($q == 'open') {
$query->where(['open' => true, 'in_committee' => false]);
}
if ($q == 'committee') {
$query->where(['open' => true, 'in_committee' => true, 'approved_by_committee' => null, 'disapproved_by_committee' => null]);
}
if ($q == 'expired') {
$query->whereNotNull('time_limit_by')->where(['open' => false, 'time_limit' => true]);
}
if ($q == 'disapproved') {
$query->whereNotNull('disapproved_by_committee')->where('open', false);
}
if ($q == 'approved') {
$query->whereNotNull('approved_by_committee')->where('open', true);
}
$this->buildSearch($query, $s);
$query->orderBy('created_at', 'desc');
return $query;
}
| Model Factories
|--------------------------------------------------------------------------
|
| Here you may define all of your model factories. Model factories give
| you a convenient way to create models for testing and seeding your
| database. Just tell the factory how a default model should look.
|
*/
use App\Proposal;
use App\State;
use App\User;
use Illuminate\Support\Facades\Request;
$factory->define(App\User::class, function (Faker\Generator $faker) {
return ['name' => $faker->name, 'email' => $faker->email, 'password' => Hash::make('123456'), 'remember_token' => str_random(10), 'role_id' => $faker->randomElement([1, 2, 99]), 'uf' => State::all()->shuffle()->first()->uf, 'cpf' => $faker->cpf, 'uuid' => $faker->uuid];
});
$factory->defineAs(App\User::class, 'admin', function (Faker\Generator $faker) use($factory) {
$user = $factory->raw(App\User::class);
//Admin 0
return array_merge($user, ['role_id' => 0]);
});
$factory->define(App\Proposal::class, function (Faker\Generator $faker) {
$random = $faker->boolean($chanceOfGettingTrue = 20);
return ['name' => $faker->sentence($nbWords = 6, $variableNbWords = true), 'user_id' => User::all()->shuffle()->first()->id, 'open' => true, 'idea_central' => $faker->text($maxNbChars = 100), 'problem' => $faker->paragraph($nbSentences = 3, $variableNbSentences = true), 'idea_exposition' => $faker->realText($maxNbChars = 200, $indexSize = 2), 'response' => $response = $faker->randomElement($array = [null, $faker->realText($maxNbChars = 100, $indexSize = 2), $faker->text($maxNbChars = 50)]), 'responder_id' => !$response ? null : User::all()->where('role_id', 1)->shuffle()->first()->id, 'disapproved_at' => !$response ? null : \Carbon\Carbon::now(), 'disapproved_by' => !$response ? null : User::all()->where('role_id', 1)->shuffle()->first()->id, 'approved_at' => $response ? null : ($random ? null : \Carbon\Carbon::now()), 'approved_by' => $response ? null : ($random ? null : User::all()->where('role_id', 1)->shuffle()->first()->id), 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now(), 'pub_date' => \Carbon\Carbon::now(), 'limit_date' => \Carbon\Carbon::now()->addMonth(config('global.timeLimitMonth'))];
});
$factory->define(App\Like::class, function (Faker\Generator $faker) {
$user_id = User::all()->shuffle()->first()->id;
return ['user_id' => $user_id, 'proposal_id' => Proposal::all()->shuffle()->first()->id, 'uuid' => User::where('id', $user_id)->first()->uuid, 'like' => $faker->boolean($chanceOfGettingTrue = 70), 'ip_address' => Request::ip()];
});
$factory->define(App\ProposalFollow::class, function (Faker\Generator $faker) {
return ['user_id' => User::all()->shuffle()->first()->id, 'proposal_id' => Proposal::all()->shuffle()->first()->id];
});
