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_pair()
{
\System\Init::full();
$token = \System\Settings::get('bank', 'token');
$from = \System\Settings::get('bank', 'from');
$to = date('Y-m-d');
$url = str_replace('{token}', $token, self::URL_TRANSACTIONS);
$url = str_replace('{from}', $from, $url);
$url = str_replace('{to}', $to, $url);
$res = \Helper\Offcom\Request::get($url);
if (!$res->ok()) {
if ($res->status == 409) {
\Helper\Cli::out('Please wait 30 seconds and try again.');
exit(4);
} else {
\Helper\Cli::out('Unknown error during transaction scrape.');
exit(5);
}
}
$feed = \System\Json::decode($res->content);
\Workshop\Payment::pair_with_feed($feed);
}
