PHP cot_generate_paytags Exemples

Exemple #1

Fichier : payments.balance.php Projet : cotemplate/cot-freelance

            $payinfo['pay_adate'] = $sys['now'];
            $payinfo['pay_status'] = 'done';
            $payinfo['pay_desc'] = sprintf($L['payments_balance_transfer_desc'], $usr['name'], $recipient['user_name'], $comment);
            $db->insert($db_payments, $payinfo);
            $pid = $db->lastInsertId();
            // Отправка уведомления админу о переводе между пользователями
            $subject = $L['payments_balance_transfer_admin_subject'];
            $body = sprintf($L['payments_balance_transfer_admin_body'], $usr['name'], $recipient['user_name'], $summ, $taxsumm, $sendersumm, $recipientsumm, $cfg['payments']['valuta'], cot_date('d.m.Y в H:i', $sys['now']), $comment);
            cot_mail($cfg['adminemail'], $subject, $body);
            // Отправка уведомления админу о переводе между пользователями
            $subject = $L['payments_balance_transfer_recipient_subject'];
            $body = sprintf($L['payments_balance_transfer_recipient_body'], $usr['name'], $recipient['user_name'], $summ, $taxsumm, $sendersumm, $recipientsumm, $cfg['payments']['valuta'], cot_date('d.m.Y в H:i', $sys['now']), $comment);
            cot_mail($recipient['user_email'], $subject, $body);
            cot_redirect(cot_url('payments', 'm=balance&n=history', '', true));
        }
        cot_redirect(cot_url('payments', 'm=balance&n=transfer', '', true));
    }
    cot_display_messages($t, 'MAIN.TRANSFERFORM');
    $t->assign(array('TRANSFER_FORM_ACTION_URL' => cot_url('payments', 'm=balance&n=transfer&a=add'), 'TRANSFER_FORM_SUMM' => cot_inputbox('text', 'summ', $summ), 'TRANSFER_FORM_TAX' => $taxsumm, 'TRANSFER_FORM_TOTAL' => !empty($sendersumm) ? $sendersumm : 0, 'TRANSFER_FORM_COMMENT' => $comment, 'TRANSFER_FORM_USERNAME' => $username));
    $t->parse('MAIN.TRANSFERFORM');
}
if ($n == 'history') {
    $pays = $db->query("SELECT * FROM {$db_payments} \n\t\tWHERE pay_userid=" . $usr['id'] . " AND pay_status='done' AND pay_summ>0\n\t\tORDER BY pay_pdate DESC")->fetchAll();
    foreach ($pays as $pay) {
        $t->assign(cot_generate_paytags($pay, 'HIST_ROW_'));
        $t->parse('MAIN.HISTORY.HIST_ROW');
    }
    $t->parse('MAIN.HISTORY');
}
$t->parse('MAIN');
$module_body = $t->text('MAIN');

Exemple #2

Fichier : payments.admin.php Projet : ASDAFF/cot-freelance

 if (!empty($sq)) {
     $where['search'] = "(u.user_name LIKE '%" . $db->prep($sq) . "%' OR u.user_email LIKE '%" . $db->prep($sq) . "%')";
 }
 if (isset($id)) {
     $where['userid'] = 'pay_userid=' . $id;
     $urr = $db->query("SELECT * FROM {$db_users} WHERE user_id=" . (int) $id)->fetch();
     $t->assign(cot_generate_usertags($urr, 'USER_'));
 }
 $where = array_filter($where);
 $where = $where ? 'WHERE ' . implode(' AND ', $where) : '';
 $pays = $db->query("SELECT * FROM {$db_payments} AS p\n\t\tLEFT JOIN {$db_users} AS u ON u.user_id=p.pay_userid\n\t\t{$where} \n\t\tORDER BY pay_pdate DESC, pay_id DESC LIMIT {$d}, " . $cfg['maxrowsperpage'])->fetchAll();
 $totalitems = $db->query("SELECT COUNT(*) FROM {$db_payments} AS p\n\t\tLEFT JOIN {$db_users} AS u ON u.user_id=p.pay_userid \n\t\t{$where}")->fetchColumn();
 $pagenav = cot_pagenav('admin', 'm=payments&id=' . $id . '&sq=' . $sq, $d, $totalitems, $cfg['maxrowsperpage']);
 $t->assign(array('PAGENAV_PAGES' => $pagenav['main'], 'PAGENAV_PREV' => $pagenav['prev'], 'PAGENAV_NEXT' => $pagenav['next']));
 foreach ($pays as $pay) {
     $t->assign(cot_generate_paytags($pay, 'PAY_ROW_'));
     if ($pay['pay_userid'] > 0) {
         $t->assign(cot_generate_usertags($pay, 'PAY_ROW_USER_'));
     } else {
         $t->assign(array('PAY_ROW_USER_ID' => 0, 'PAY_ROW_USER_NICKNAME' => $L['Guest']));
     }
     $t->parse('MAIN.PAYMENTS.PAY_ROW');
 }
 if (!empty($id)) {
     $where_string = 'AND pay_userid=' . $id;
 }
 $inbalance = $db->query("SELECT SUM(pay_summ) as summ FROM {$db_payments} AS p\n\t\tWHERE pay_area='balance' AND pay_summ>0 {$where_string} AND pay_status='done'")->fetchColumn();
 $outbalance = $db->query("SELECT SUM(pay_summ) as summ FROM {$db_payments} AS p\n\t\tWHERE pay_area='balance' AND pay_summ<0 {$where_string} AND pay_status='done'")->fetchColumn();
 $credit = $db->query("SELECT SUM(pay_summ) as summ FROM {$db_payments} AS p\n\t\tWHERE pay_area!='balance' {$where_string} AND pay_status='done'")->fetchColumn();
 $t->assign(array('INBALANCE' => number_format($inbalance, 2, '.', ' '), 'OUTBALANCE' => number_format(abs($outbalance), 2, '.', ' '), 'BALANCE' => number_format($inbalance - abs($outbalance), 2, '.', ' '), 'CREDIT' => number_format($credit, 2, '.', ' ')));
 $t->parse('MAIN.PAYMENTS');