function handlers()
{
return array(
- '%grp/events' => $this->make_hook('events', AUTH_MDP),
- '%grp/events/sub' => $this->make_hook('sub', AUTH_MDP),
- '%grp/events/csv' => $this->make_hook('csv', AUTH_MDP, 'user', NO_HTTPS),
- '%grp/events/ical' => $this->make_hook('ical', AUTH_MDP, 'user', NO_HTTPS),
- '%grp/events/edit' => $this->make_hook('edit', AUTH_MDP, 'groupadmin'),
- '%grp/events/admin' => $this->make_hook('admin', AUTH_MDP, 'groupmember'),
+ '%grp/events' => $this->make_hook('events', AUTH_PASSWD, 'groups'),
+ '%grp/events/sub' => $this->make_hook('sub', AUTH_PASSWD, 'groups'),
+ '%grp/events/csv' => $this->make_hook('csv', AUTH_PASSWD, 'groups', NO_HTTPS),
+ '%grp/events/ical' => $this->make_hook('ical', AUTH_PASSWD, 'groups', NO_HTTPS),
+ '%grp/events/edit' => $this->make_hook('edit', AUTH_PASSWD, 'groupadmin'),
+ '%grp/events/admin' => $this->make_hook('admin', AUTH_PASSWD, 'groupmember'),
);
}
$e['topay'] += $m['nb'] * $m['montant'];
}
- $query = XDB::query(
- "SELECT amount
+ $montant = XDB::fetchOneCell(
+ "SELECT SUM(amount) as sum_amount
FROM payment_transactions AS t
WHERE ref = {?} AND uid = {?}", $e['paiement_id'], S::v('uid'));
- $montants = $query->fetchColumn();
-
- foreach ($montants as $m) {
- $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
- $e['paid'] += trim($p);
- }
+ $e['paid'] += $montant;
make_event_date($e);
return PL_NOT_FOUND;
}
- pl_cached_content_headers('text/x-csv', 1);
+ pl_cached_content_headers('text/x-csv', 'iso-8859-1', 1);
$page->changeTpl('xnetevents/csv.tpl', NO_SKIN);
$admin = may_update();
-
$tri = (Env::v('order') == 'alpha' ? UserFilter::sortByPromo() : UserFilter::sortByName());
+ $all = !Env::v('item_id', false);
- $page->assign('participants',
- get_event_participants($evt, $item_id, $tri));
+ $participants = get_event_participants($evt, $item_id, $tri);
+ $title = 'Nom;Prénom;Promotion';
+ if ($all) {
+ foreach ($evt['moments'] as $moment) {
+ $title .= ';' . $moment['titre'];
+ }
+ }
+ if ($admin && $evt['money']) {
+ $title .= ';À payer;';
+ if ($evt['paiement_id']) {
+ $title .= 'Télépaiement;Liquide/Chèque;';
+ }
+ $title .= 'Payé';
+ } else {
+ $title .= ';Nombre';
+ }
+ echo utf8_decode($title) . "\n";
+
+ if ($participants) {
+ foreach ($participants as $participant) {
+ $user = $participant['user'];
+ $line = $user->lastName() . ';' . $user->firstName() . ';' . $user->promo();
+ if ($all) {
+ foreach ($evt['moments'] as $moment) {
+ $line .= ';' . $participant[$moment['item_id']];
+ }
+ }
+ if ($admin && $evt['money']) {
+ $line .= ';' . $participant['montant'] . ';';
+ if ($evt['paiement_id']) {
+ $line .= $participant['telepayment'] . ';' . $participant['adminpaid'] . ';';
+ }
+ $line .= $participant['paid'];
+ } else {
+ $line .= ';' . $participant['nb'];
+ }
- $page->assign('admin', $admin);
- $page->assign('moments', $evt['moments']);
- $page->assign('money', $evt['money']);
- $page->assign('telepayment', $evt['paiement_id']);
- $page->assign('tout', !Env::v('item_id', false));
+ echo utf8_decode($line) . "\n";
+ }
+ }
+ exit();
}
function handler_ical($page, $eid = null)
Post::v('intitule')." - ".$globals->asso('nom'),
Post::v('site'), $money_defaut,
Post::v('confirmation'), 0, 999,
- $globals->asso('id'), $eid, Post::b('donation'));
+ $globals->asso('id'), $eid, Post::v('payment_public') == 'yes');
if ($p->accept()) {
$p->submit();
} else {
- $page->assign('paiement_message', Post::v('confirmation'));
- $page->assign('paiement_site', Post::v('site'));
+ $page->assign('payment_message', Post::v('confirmation'));
+ $page->assign('payment_site', Post::v('site'));
+ $page->assign('payment_public', Post::v('payment_public') == 'yes');
+ $page->assign('error', true);
$error = true;
}
}
}
// get a list of all the payment for this asso
- $res = XDB::iterator("SELECT id, text
- FROM payments
- WHERE asso_id = {?}", $globals->asso('id'));
+ $res = XDB::iterator("SELECT id, text
+ FROM payments
+ WHERE asso_id = {?} AND NOT FIND_IN_SET('old', flags)",
+ $globals->asso('id'));
$paiements = array();
while ($a = $res->next()) $paiements[$a['id']] = $a['text']; {
$page->assign('paiements', $paiements);
$res = XDB::query("SELECT stamp
FROM requests
WHERE type = 'paiements' AND data LIKE {?}",
- PayReq::same_event($eid, $globals->asso('id')));
+ PayReq::same_event($eid, $globals->asso('id')));
$stamp = $res->fetchOneCell();
if ($stamp) {
$evt['paiement_id'] = -2;
$amount = strtr(Env::v('montant'), ',', '.');
XDB::execute("UPDATE group_event_participants
SET paid = paid + {?}
- WHERE uid = {?} AND eid = {?} AND item_id = 1",
+ WHERE uid = {?} AND eid = {?} AND nb > 0
+ ORDER BY item_id ASC
+ LIMIT 1",
$amount, $member->uid, $evt['eid']);
subscribe_lists_event($member->uid, $evt['short_name'], 1, $amount);
}
// change the number of personns coming with a participant
if (Env::v('adm') == 'nbs' && $member) {
- $res = XDB::query("SELECT paid
+ $res = XDB::query("SELECT SUM(paid)
FROM group_event_participants
WHERE uid = {?} AND eid = {?}",
$member->uid, $evt['eid']);
GROUP BY uid',
$member->uid, $evt['eid']);
$u = $res->fetchOneAssoc();
- if ($u['cnt'] == 1 && $paid == 0 && Post::v('cancel')) {
+ if ($paid == 0 && Post::v('cancel')) {
XDB::execute("DELETE FROM group_event_participants
WHERE uid = {?} AND eid = {?}",
$member->uid, $evt['eid']);
GROUP BY p.uid', $evt['eid']);
$ofs = Env::i('offset');
- $tot = (is_null($evt['nb_tot']) ? $evt['nb'] : $evt['nb_tot']);
- $nbp = ceil($tot / NB_PER_PAGE);
+ $nbp = ceil($evt['user_count'] / NB_PER_PAGE);
if ($nbp > 1) {
$links = array();
if ($ofs) {
projects / platal.git / blobdiff