/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$voteoptions = Voteoption::all();
$votes = Vote::all();
$members = Votemember::all();
$groups = Votegroup::all();
$score = [];
foreach ($votes as $vote) {
foreach ($voteoptions as $voteoption) {
if ($vote['voteoption_hash'] == $voteoption['hash']) {
$score[] = $voteoption['votemember_id'];
}
}
}
$score = array_count_values($score);
foreach ($score as $key => $vote) {
foreach ($members as $member) {
if ($member['id'] == $key) {
$member['votes'] = $vote;
}
foreach ($groups as $group) {
if ($group['id'] == $member['votegroup_id']) {
$member['group'] = $group['name'];
}
}
}
foreach ($members as $member) {
if (!isset($member['votes'])) {
$member['votes'] = 0;
}
}
}
Storage::disk('local')->put('votes.json', json_encode($members));
$groups = $members;
$groupscore = [];
foreach ($groups as $group) {
if (isset($groupscore[$group['group']])) {
$groupscore[$group['group']]['votes'] = $groupscore[$group['group']]['votes'] + $group['votes'];
} else {
$rand = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'];
$color = '#' . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)];
$groupscore[$group['group']] = ['votes' => $group['votes'], 'color' => $color];
}
}
$totalvotes = Vote::count();
foreach ($groupscore as $key => $group) {
$groupscore[$key]['cut'] = $groupscore[$key]['votes'] / $totalvotes * 100;
}
Storage::disk('local')->put('groupvotes.json', json_encode($groupscore));
$this->info("All votes are counted and saved in votes.json");
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$this->info("Generating new hashes");
$members = Votemember::all();
if (!($versionnumber = Voteoption::orderBy('created_at', 'desc')->first()->versionnumber + 1)) {
$versionnumber = 0;
}
foreach ($members as $member) {
$voteopt = new Voteoption();
$voteopt->hash = Hash::make(date('Yis') . str_random(20) . date('siY'));
$voteopt->form_hash = Hash::make(date('Yis') . str_random(20) . date('siY'));
$voteopt->votemember_id = $member->id;
$voteopt->versionnumber = $versionnumber;
$voteopt->save();
}
$this->info("Done!");
}
public function run()
{
$votemembers = [['votegroup_id' => '1', 'name' => 'Sybrand van Haersma Buma'], ['votegroup_id' => '1', 'name' => 'Mona Keijzer'], ['votegroup_id' => '1', 'name' => 'Sander de Rouwe'], ['votegroup_id' => '2', 'name' => 'Geert Wilders'], ['votegroup_id' => '2', 'name' => 'Fleur Agema'], ['votegroup_id' => '2', 'name' => 'Martin Bosma'], ['votegroup_id' => '3', 'name' => 'Henk Knol'], ['votegroup_id' => '4', 'name' => 'Diederik Samsom'], ['votegroup_id' => '4', 'name' => 'Jetta Klijnsma'], ['votegroup_id' => '4', 'name' => 'Ronald Plasterk'], ['votegroup_id' => '5', 'name' => 'Mark Rutte'], ['votegroup_id' => '5', 'name' => 'Edith Schippers'], ['votegroup_id' => '5', 'name' => 'Stef Blok'], ['votegroup_id' => '6', 'name' => 'Emile Roemer'], ['votegroup_id' => '6', 'name' => 'Renske Leijten'], ['votegroup_id' => '6', 'name' => 'Ronald van Raak'], ['votegroup_id' => '7', 'name' => 'Jolande Sap'], ['votegroup_id' => '7', 'name' => 'Bram van Ojik'], ['votegroup_id' => '7', 'name' => 'Liesbeth van Tongeren'], ['votegroup_id' => '8', 'name' => 'Alexander Pechtold'], ['votegroup_id' => '8', 'name' => 'Stientje van Veldhoven'], ['votegroup_id' => '8', 'name' => 'Wouter Koolmees'], ['votegroup_id' => '9', 'name' => 'Arie Slob'], ['votegroup_id' => '9', 'name' => 'Joël Voordewind'], ['votegroup_id' => '9', 'name' => 'Carola Schouten'], ['votegroup_id' => '10', 'name' => 'Marianne Thieme'], ['votegroup_id' => '10', 'name' => 'Esther Ouwehand'], ['votegroup_id' => '10', 'name' => 'Frank Wassenberg'], ['votegroup_id' => '11', 'name' => 'Kees van der Staaij'], ['votegroup_id' => '11', 'name' => 'Elbert Dijkgraaf'], ['votegroup_id' => '11', 'name' => 'Henk ten Hoeve'], ['votegroup_id' => '12', 'name' => 'Jabik van der Bij'], ['votegroup_id' => '12', 'name' => 'Roelof Bisschop']];
Votemember::insert($votemembers);
}
