$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');
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');