public function run() { $items = \Workshop::get_all()->fetch(); for ($i = count($items); $i < 8; $i++) { $items[] = new \Workshop(array("name" => "Připravujeme", "desc" => 'Workshop ' . ($i + 1))); } $this->partial('pages/workshops', array("items" => $items)); }
public function run() { $ws = \Workshop::get_all()->where(array('visible' => true))->fetch(); foreach ($ws as $w) { $w->ass_total = $w->assignees->count(); $w->ass_all = $w->assignees->fetch(); } $this->partial('stats/workshops', array("workshops" => $ws)); }
public function run() { $account_pay = \Workshop\Check::get_all()->reset_cols()->add_cols(array('SUM(amount) as `total`'))->where(array("is_paid" => false))->assoc_with(null)->fetch_one(); $account_sum = \Workshop\Payment::get_all()->reset_cols()->add_cols(array('SUM(amount) as `total`'))->assoc_with(null)->fetch_one(); $stats = array("total" => \Workshop\SignUp::get_all()->count(), "unpaid" => \Workshop\SignUp::get_all()->where(array('paid' => false, 'solved' => false))->count(), "paid" => \Workshop\SignUp::get_all()->where(array('paid' => true))->count(), "waiting" => \Workshop\SignUp::get_all()->where(array('paid' => true, 'solved' => false, 'canceled' => false))->count(), "solved" => \Workshop\SignUp::get_all()->where(array('solved' => true, 'canceled' => false))->count(), "meals" => \Workshop\SignUp::get_all()->where(array('solved' => true, 'lunch' => true, 'canceled' => false))->count(), "hotel" => \Workshop\SignUp::get_all()->where(array('solved' => true, 'hotel' => true, 'canceled' => false))->count(), "expected_cnt" => \Workshop\Check::get_all()->where(array("is_paid" => false))->count(), "expected_sum" => $account_pay['total'], "received_cnt" => \Workshop\Payment::get_all()->count(), "received_sum" => $account_sum['total']); $ws = \Workshop::get_all()->fetch(); foreach ($ws as $w) { $w->sig_total = $w->signups->count(); $w->ass_total = $w->assignees->count(); } $this->partial('stats/signups', array("stats" => $stats, "workshops" => $ws)); }
public function cmd_workshops() { \System\Init::full(); $ws = \Workshop::get_all()->fetch(); $dump = array(); foreach ($ws as $workshop) { $signups = $workshop->assignees->where(array("solved" => true))->fetch(); array_push($dump, $workshop->name, "------\n"); foreach ($signups as $signup) { array_push($dump, $signup->toName() . ': ' . $signup->email . ' ' . $signup->phone); } array_push($dump, "\n"); } echo implode("\n", $dump); }
public function get_form() { $opts = array(); $f = $this->response->form(); $ws = \Workshop::get_all(); foreach ($ws as $w) { $opts[$w->id] = $w->name; } $f->input(array('name' => 'name_first', 'type' => 'text', 'required' => true)); $f->input(array('name' => 'name_last', 'type' => 'text', 'required' => true)); $f->input(array('name' => 'team', 'type' => 'text', 'required' => false)); $f->input(array('name' => 'email', 'type' => 'email', 'required' => true)); $f->input(array('name' => 'phone', 'type' => 'text', 'required' => true)); $f->input(array('name' => 'birthday', 'type' => 'text', 'required' => true)); $f->input(array('name' => 'lunch', 'type' => 'checkbox', 'required' => false)); $f->input(array('name' => 'hotel', 'type' => 'checkbox', 'required' => false)); $f->input(array('name' => 'workshop_0', 'type' => 'select', 'options' => $opts, 'required' => true)); $f->input(array('name' => 'workshop_1', 'type' => 'select', 'options' => $opts)); $f->input(array('name' => 'workshop_2', 'type' => 'select', 'options' => $opts)); $f->input(array('name' => 'rules', 'type' => 'checkbox', 'required' => true)); $f->input(array('name' => 'newsletter', 'type' => 'checkbox', 'required' => false)); return $f; }