$query='DELETE FROM trades WHERE trade_ref="'.$_GET['sellid'].'"'; $db->rq($query); $uDetails=$db->getRow('users','user_account_num="'.$row['user_account_num'].'"','user_firstname, user_lastname, user_account_num'); global $tradesSellStatuses; addLog('Back-end','Option Trades',''.$uDetails['user_firstname'].' '.$uDetails['user_lastname'].' ('.$uDetails['user_account_num'].')',''.$_SESSION['admin']['name'].' ('.$_SESSION['admin']['refnum'].')','Sell deleted '.($row['trade_ref']+0).' ('.$tradesSellStatuses[$row['trade_status']].')'); $db->close(); header('Location: trades.php'); exit(); } break; case 'pdf': $db = new DBConnection(); $tradeModel = new App\Model\Trades($db); $trade = $tradeModel->getTradeByRef($_GET['ref']); $tradeOptions = $tradeModel->getOptions(); $trade['trade_option'] = $tradeOptions[$trade['trade_option']]; $trade = $tradeModel->formatPriceValues($trade); $mpdf = new mPDF(null, 'A4', null, null, 8, 8, 40, 20, 8, 8); $pdf = new App\Utility\Pdf($db); $mpdf->SetHTMLHeader($pdf->getHeader()); $mpdf->SetHTMLFooter($pdf->getFooter()); $mpdf->WriteHTML($pdf->getBody('options_trade', $trade));
//get variables $vars = Array(); switch($local_template['name']){ case 'Account summary': $userModel = new App\Model\User(new DBConnection()); $vars = $userModel->getTemplateFields(); break; case 'Stock trade': $tradeModel = new App\Model\StockTrades(new DBConnection()); $vars = $tradeModel->getTemplateFields(); break; case 'Options trade': $tradeModel = new App\Model\Trades(new DBConnection()); $vars = $tradeModel->getTemplateFields(); break; case 'Transfer (deposit)': case 'Transfer (withdraw)': $transferModel = new App\Model\Transfer(new DBConnection()); $vars = $transferModel->getTemplateFields(); break; default: break; } $view = new App\View\View('pdf_templates/edit'); $view->template = $local_template;
//$db->rq($query); $query='DELETE FROM users WHERE user_uid="'.$_GET['uid'].'"'; $db->rq($query); addLog('Back-end','Accounts',''.$uDetails['user_firstname'].' '.$uDetails['user_lastname'].' ('.$uDetails['user_account_num'].')',''.$_SESSION['admin']['name'].' ('.$_SESSION['admin']['refnum'].')','User deleted'); $db->close(); header('Location: users.php'); exit(); } break; case 'pdf': $db = new DBConnection(); $userModel = new App\Model\User($db); $tradesModel = new App\Model\Trades($db); $transfersModel = new App\Model\Transfer($db); $user = $userModel->getUserByUid($_GET['uid']); $trades = $tradesModel->getUserTrades($user['user_account_num']); $transfers = $transfersModel->getUserTransfers($user['user_account_num']); $view = new App\View\View('user/account_statement'); $user['account_statement'] = $view->render(array( 'trades' => $trades, 'tradesBuyOptions' => $tradesModel->getOptions(), 'buyStatuses' => $tradesModel->getStatuses('buy'), 'sellStatuses' => $tradesModel->getStatuses('sell'), 'transfers' => $transfers, 'transfersOptions' => $transfersModel->getTypes(), 'depositOptions' => $transfersModel->getStatuses()