function display_trial_balance() { global $table_style, $path_to_root; start_table($table_style); $tableheader = "<tr>\n <td rowspan=2 class='tableheader'>" . tr("Account") . "</td>\n <td rowspan=2 class='tableheader'>" . tr("Account Name") . "</td>\n\t\t<td colspan=2 class='tableheader'>" . tr("Brought Forward") . "</td>\n\t\t<td colspan=2 class='tableheader'>" . tr("This Period") . "</td>\n\t\t<td colspan=2 class='tableheader'>" . tr("Balance") . "</td>\n\t\t</tr><tr>\n\t\t<td class='tableheader'>" . tr("Debit") . "</td>\n <td class='tableheader'>" . tr("Credit") . "</td>\n\t\t<td class='tableheader'>" . tr("Debit") . "</td>\n\t\t<td class='tableheader'>" . tr("Credit") . "</td>\n <td class='tableheader'>" . tr("Debit") . "</td>\n <td class='tableheader'>" . tr("Credit") . "</td>\n </tr>"; echo $tableheader; $k = 0; $accounts = get_gl_accounts(); while ($account = db_fetch($accounts)) { if (is_account_balancesheet($account["account_code"])) { $begin = null; } else { $begin = begin_fiscalyear(); if ($_POST['TransFromDate'] < $begin) { $begin = $_POST['TransFromDate']; } $begin = add_days($begin, -1); } $prev_balance = get_balance($account["account_code"], $begin, $_POST['TransFromDate'], false, false); $curr_balance = get_balance($account["account_code"], $_POST['TransFromDate'], $_POST['TransToDate']); if (check_value("NoZero") && !$prev_balance && !$curr_balance) { continue; } alt_table_row_color($k); $url = "<a href='{$path_to_root}/gl/inquiry/gl_account_inquiry.php?" . SID . "TransFromDate=" . $_POST["TransFromDate"] . "&TransToDate=" . $_POST["TransToDate"] . "&account=" . $account["account_code"] . "'>" . $account["account_code"] . "</a>"; label_cell($url); label_cell($account["account_name"]); display_debit_or_credit_cells($prev_balance); display_debit_or_credit_cells($curr_balance); display_debit_or_credit_cells($prev_balance + $curr_balance); end_row(); } end_table(1); }
function create_cost($arg1, $arg2, $arg3) { require_once __DIR__ . "/../../moneyio.php"; require_once __DIR__ . "/../../query.php"; $prepare = db_connect(); $query = $prepare->prepare(new_cost); $query->bind_param('ssi', $arg1, $arg2, $arg3); $query->execute(); $value = get_balance($arg3, $arg3, $arg3); new_balance($value, $arg3); return $query; $prepare->close(); }
$slt_trade_order_a = "SELECT * FROM trade_order WHERE active = 'yes' AND finished = 'no' AND type = 'sell' AND ROUND(price * 100000000) = ROUND({$price} * 100000000) AND currency = '{$currency}' AND user = '******'user_id']}'"; $rlt_trade_order_a = mysql_query($slt_trade_order_a); if (mysql_num_rows($rlt_trade_order_a) == 0) { $ins_trade_order_a = "INSERT INTO trade_order (type, user, currency, price, amount, completed, active, finished, filing_time, change_time, finishing_time) " . "VALUES ('sell', '{$_SESSION['user_id']}', '{$currency}', '{$price}', '{$slc_amount}', '0', 'yes', 'no', NOW(), NOW(), '0000-00-00 00:00:00')"; mysql_query($ins_trade_order_a); $tid = mysql_insert_id(); add_transaction($_SESSION["user_id"], "out", "intern", $slc_amount, "SLC", "trade_placement", $tid); } else { $row_trade_order_a = mysql_fetch_assoc($rlt_trade_order_a); $udt_trade_order_a = "UPDATE trade_order SET amount = amount + {$slc_amount}, change_time = NOW() WHERE id = {$row_trade_order_a['id']}"; mysql_query($udt_trade_order_a); add_transaction($_SESSION["user_id"], "out", "intern", $slc_amount, "SLC", "trade_increase", $row_trade_order_a["id"]); } } } elseif ($_POST["type"] == "buy") { if ($cur_amount * 1.004 > get_balance($_SESSION["user_id"], $currency)) { $errors[] = "You don't have that much."; } if (count($errors) == 0) { $slt_trade_order_a = "SELECT * FROM trade_order WHERE active = 'yes' AND finished = 'no' AND type = 'buy' AND ROUND(price * 100000000) = ROUND({$price} * 100000000) AND currency = '{$currency}' AND user = '******'user_id']}'"; $rlt_trade_order_a = mysql_query($slt_trade_order_a); if (mysql_num_rows($rlt_trade_order_a) == 0) { $ins_trade_order_a = "INSERT INTO trade_order (type, user, currency, price, amount, completed, active, finished, filing_time, change_time, finishing_time) " . "VALUES ('buy', '{$_SESSION['user_id']}', '{$currency}', '{$price}', '{$slc_amount}', '0', 'yes', 'no', NOW(), NOW(), '0000-00-00 00:00:00')"; mysql_query($ins_trade_order_a); $tid = mysql_insert_id(); add_transaction($_SESSION["user_id"], "out", "intern", $cur_amount * 1.004, $currency, "trade_placement", $tid, $cur_amount * 0.004); } else { $row_trade_order_a = mysql_fetch_assoc($rlt_trade_order_a); $udt_trade_order_a = "UPDATE trade_order SET amount = amount + {$slc_amount}, change_time = NOW() WHERE id = {$row_trade_order_a['id']}"; mysql_query($udt_trade_order_a); add_transaction($_SESSION["user_id"], "out", "intern", $cur_amount * 1.004, $currency, "trade_increase", $row_trade_order_a["id"], $cur_amount * 0.004);
json_success($transactions); } json_error("Please provide an address, an array of addresses or an id."); } if (isset($_GET["id"])) { // 4.2.4 Withdraw to withdrawal address by ID $id = $_GET["id"]; if (!is_numeric($id)) { json_error("Invalid id."); } $amount = $_GET["am"]; if (!is_numeric($amount) || $amount < 0.0001) { json_error("Invalid amount."); } $amount = round($amount * 10000) / 10000; if (withdrawal_with_fee($amount, 0, $user_id) > get_balance($user_id, "SLC")) { json_error("You don't have that much."); } //mysql_query("LOCK TABLES transfer_withdrawal_address WRITE, transfer_withdrawal, transaction WRITE, transaction WRITE"); $slt_transfer_withdrawal_address_a = "SELECT * FROM transfer_withdrawal_address WHERE id = '{$id}'"; $rlt_transfer_withdrawal_address_a = mysql_query($slt_transfer_withdrawal_address_a); $row_transfer_withdrawal_address_a = mysql_fetch_assoc($rlt_transfer_withdrawal_address_a); if ($row_transfer_withdrawal_address_a["user"] != $user_id) { json_error("Invalid id."); } // START $type = $row_transfer_withdrawal_address_a["type"]; $address = $row_transfer_withdrawal_address_a["address"]; // NO TRANSACTION, NO WITHDRAWAL UNTIL HERE if ($type == "extern") { $itxid = add_transaction($user_id, "out", "extern", withdrawal_with_fee($amount, 1, $user_id), "SLC", "transfer_withdrawal", 0, withdrawal_with_fee($amount, 0, $user_id) - $amount);
?> </span></h2> <?php if ($_SESSION["li"] != 1) { echo lang_temp("?c=sign_up{$___l}", $_LANG[$l]["e_log_in"]); } ?> <table style="width: 100%; border-collapse: collapse;"> <?php if ($_SESSION["li"] == 1) { get_connection(); $slc_balance = get_balance($_SESSION["user_id"], "SLC"); $cur_balance = get_balance($_SESSION["user_id"], $currency); $slt_trade_order_buy = "SELECT MAX(price) as price FROM trade_order WHERE currency = '{$currency}' AND type = 'buy' AND active = 'yes' AND finished = 'no'"; $rlt_trade_order_buy = mysql_query($slt_trade_order_buy); $row_trade_order_buy = mysql_fetch_assoc($rlt_trade_order_buy); $slt_trade_order_sell = "SELECT MIN(price) as price FROM trade_order WHERE currency = '{$currency}' AND type = 'sell' AND active = 'yes' AND finished = 'no'"; $rlt_trade_order_sell = mysql_query($slt_trade_order_sell); $row_trade_order_sell = mysql_fetch_assoc($rlt_trade_order_sell); ?> <tr> <td style="vertical-align: top;"> <h3><a href="#" onclick="if (document.getElementById('buy_window').style.display == 'none') { document.getElementById('buy_window').style.display = 'block'; this.style.color = 'inherit'; selected = 'buy'; } else { document.getElementById('buy_window').style.display = 'none'; this.style.color = ''; selected = 'sell'; }"><?php echo lang_temp("Solidcoins", $_LANG[$l]["e_header_buy"]); ?> </a></h3>
<tbody> <?php $sr =1; foreach($jobs as $job) { ?> <tr> <td><?php echo $sr;?></td> <td><?php echo $job['job_id'];?></td> <td><?php echo $job['companyname'] ? $job['companyname'] : $job['name'] ;?></td> <td><?php echo $job['jobname'];?></td> <td><?php echo $job['mobile'];?></td> <td><?php echo $job['total'];?></td> <td><?php echo $job['advance'];?></td> <td> <?php //echo $job['jpaid'] ? "<span class='paid'>Paid</span>" :$job['due'];?> <?php $user_bal = get_balance($job['customer_id']) ; if($user_bal > 0 ) { $due_amt = $job['due'] - $job['discount']; echo $due_amt?$due_amt:"<span style='color:green;font-weight:bold;'>Paid</span>"; } else { echo "-"; } ?> </td> <td width="60px;"><?php echo date('d-m-y',strtotime($job['created']));?> </td> <td width="50px;"><?php echo date('h:i A',strtotime($job['created']));?> </td> <td><?php echo $job['jstatus'];?></td> <td><?php echo $job['receipt'];?></td> <td><?php echo $job['bill_number'];?></td>
function display_type($type, $typename, &$dec, &$rep, $from, $to, $zero, $balances, $dimension, $dimension2) { global $pdeb, $pcre, $cdeb, $ccre, $tdeb, $tcre, $pbal, $cbal, $tbal, $clear_trial_balance_opening; $printtitle = 0; //Flag for printing type name //Get Accounts directly under this group/type $accounts = get_gl_accounts(null, null, $type); $begin = get_fiscalyear_begin_for_date($from); if (date1_greater_date2($begin, $from)) { $begin = $from; } $begin = add_days($begin, -1); while ($account = db_fetch($accounts)) { //Print Type Title if it has atleast one non-zero account if (!$printtitle) { $rep->row -= 4; $rep->TextCol(0, 8, _("Group") . " - " . $type . " - " . $typename); $printtitle = 1; $rep->row -= 4; $rep->Line($rep->row); $rep->NewLine(); } // FA doesn't really clear the closed year, therefore the brought forward balance includes all the transactions from the past, even though the balance is null. // If we want to remove the balanced part for the past years, this option removes the common part from from the prev and tot figures. if (@$clear_trial_balance_opening) { $open = get_balance($account["account_code"], $dimension, $dimension2, $begin, $begin, false, true); $offset = min($open['debit'], $open['credit']); } else { $offset = 0; } $prev = get_balance($account["account_code"], $dimension, $dimension2, $begin, $from, false, false); $curr = get_balance($account["account_code"], $dimension, $dimension2, $from, $to, true, true); $tot = get_balance($account["account_code"], $dimension, $dimension2, $begin, $to, false, true); if ($zero == 0 && !$prev['balance'] && !$curr['balance'] && !$tot['balance']) { continue; } $rep->TextCol(0, 1, $account['account_code']); $rep->TextCol(1, 2, $account['account_name']); if ($balances != 0) { if ($prev['balance'] >= 0.0) { $rep->AmountCol(2, 3, $prev['balance'], $dec); } else { $rep->AmountCol(3, 4, abs($prev['balance']), $dec); } if ($curr['balance'] >= 0.0) { $rep->AmountCol(4, 5, $curr['balance'], $dec); } else { $rep->AmountCol(5, 6, abs($curr['balance']), $dec); } if ($tot['balance'] >= 0.0) { $rep->AmountCol(6, 7, $tot['balance'], $dec); } else { $rep->AmountCol(7, 8, abs($tot['balance']), $dec); } } else { $rep->AmountCol(2, 3, $prev['debit'] - $offset, $dec); $rep->AmountCol(3, 4, $prev['credit'] - $offset, $dec); $rep->AmountCol(4, 5, $curr['debit'], $dec); $rep->AmountCol(5, 6, $curr['credit'], $dec); $rep->AmountCol(6, 7, $tot['debit'] - $offset, $dec); $rep->AmountCol(7, 8, $tot['credit'] - $offset, $dec); $pdeb += $prev['debit'] - $offset; $pcre += $prev['credit'] - $offset; $cdeb += $curr['debit']; $ccre += $curr['credit']; $tdeb += $tot['debit'] - $offset; $tcre += $tot['credit'] - $offset; } $pbal += $prev['balance']; $cbal += $curr['balance']; $tbal += $tot['balance']; $rep->NewLine(); if ($rep->row < $rep->bottomMargin + $rep->lineHeight) { $rep->Line($rep->row - 2); $rep->NewPage(); } } //Get Account groups/types under this group/type $result = get_account_types(false, false, $type); while ($accounttype = db_fetch($result)) { //Print Type Title if has sub types and not previously printed if (!$printtitle) { $rep->row -= 4; $rep->TextCol(0, 8, _("Group") . " - " . $type . " - " . $typename); $printtitle = 1; $rep->row -= 4; $rep->Line($rep->row); $rep->NewLine(); } display_type($accounttype["id"], $accounttype["name"] . ' (' . $typename . ')', $dec, $rep, $from, $to, $zero, $balances, $dimension, $dimension2); } }
* * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, * MA 02110-1301, USA. * * */ require_once __DIR__ . "/../../../../session.php"; require_once __DIR__ . "/../../../../moneyio.php"; require_once __DIR__ . "/../../../../mio-wallet/show/wallet_func.php"; require_once __DIR__ . "/../../../../mio-lang/list.php"; open_session(); $user_id = $_SESSION["mio-username_id"]; $wallet_id = $_POST["wallet_id"]; $balance = get_balance($wallet_id); if (isset($_SESSION) && !empty($_SESSION)) { ?> <h1>Balances</h1> <table class="table"> <tr> <th>ID</th> <th>Balance</th> <th>Fecha</th> <tr> <?php for ($x = 0; $x < count($balance); $x++) { echo "<tr>"; echo "<td>" . $balance[$x]->balance_id . "</td>"; echo "<td>" . $balance[$x]->balance . "<span> €</span></td>";
//$first, $first_stamp, $mid, $mid_stamp, $last, $last_stamp -> for the dates //$total_days //going to establish the amount of days b/w first pay day and mid pay day for proration purposes $first_half_days = date_diff($mid_stamp, $first_stamp); //$monthly_estimate is the monthly estimate of all (paid & unpaid) income less (paid & unpaid) expenses //calculates approx. disposable income based on the estimates... ?> <div class= "wrapper"> <div class = "exp_title"> <h3>Disposable Income</h3> </div> <div class = "summary"> <p><strong>Summary</strong></p> <?php //previous month will calculate the balance at the end of the previous budget month. $prev_month = get_balance($first_stamp, FALSE); //initial amt is calculating the fixed income less the fixed expenses (NOT including those that are //span more than one month) $initial_amt = monthly_estimate($total_days, $thismonth); //multi will calculate the amount that needs to be set aside for mutli-month expenses $multi = estimate_multi_month($thismonth); //intial will figure the previous months balance plus the initital budget surplus (income less expenses) $initial = $prev_month + $initial_amt - $multi; ?> <p>Beginning Amount this month: <?php echo my_money_format($initial); ?> <br/> <?php $this_month_bf_mid = get_this_month_total($first_stamp, $mid_stamp); $this_month = get_this_month_total($first_stamp, $last_stamp);
function display_type($type, $typename, &$dec, &$rep, $from, $to, $zero, $balances, $dimension, $dimension2) { global $pdeb, $pcre, $cdeb, $ccre, $tdeb, $tcre, $pbal, $cbal, $tbal; $printtitle = 0; //Flag for printing type name //Get Accounts directly under this group/type $accounts = get_gl_accounts(null, null, $type); $begin = get_fiscalyear_begin_for_date($from); if (date1_greater_date2($begin, $from)) { $begin = $from; } $begin = add_days($begin, -1); while ($account = db_fetch($accounts)) { //Print Type Title if it has atleast one non-zero account if (!$printtitle) { $rep->row -= 4; $rep->TextCol(0, 8, _("Group") . " - " . $type . " - " . $typename); $printtitle = 1; $rep->row -= 4; $rep->Line($rep->row); $rep->NewLine(); } $prev = get_balance($account["account_code"], $dimension, $dimension2, $begin, $from, false, false); $curr = get_balance($account["account_code"], $dimension, $dimension2, $from, $to, true, true); $tot = get_balance($account["account_code"], $dimension, $dimension2, $begin, $to, false, true); if ($zero == 0 && !$prev['balance'] && !$curr['balance'] && !$tot['balance']) { continue; } $rep->TextCol(0, 1, $account['account_code']); $rep->TextCol(1, 2, $account['account_name']); if ($balances != 0) { if ($prev['balance'] >= 0.0) { $rep->AmountCol(2, 3, $prev['balance'], $dec); } else { $rep->AmountCol(3, 4, abs($prev['balance']), $dec); } if ($curr['balance'] >= 0.0) { $rep->AmountCol(4, 5, $curr['balance'], $dec); } else { $rep->AmountCol(5, 6, abs($curr['balance']), $dec); } if ($tot['balance'] >= 0.0) { $rep->AmountCol(6, 7, $tot['balance'], $dec); } else { $rep->AmountCol(7, 8, abs($tot['balance']), $dec); } } else { $rep->AmountCol(2, 3, $prev['debit'], $dec); $rep->AmountCol(3, 4, $prev['credit'], $dec); $rep->AmountCol(4, 5, $curr['debit'], $dec); $rep->AmountCol(5, 6, $curr['credit'], $dec); $rep->AmountCol(6, 7, $tot['debit'], $dec); $rep->AmountCol(7, 8, $tot['credit'], $dec); $pdeb += $prev['debit']; $pcre += $prev['credit']; $cdeb += $curr['debit']; $ccre += $curr['credit']; $tdeb += $tot['debit']; $tcre += $tot['credit']; } $pbal += $prev['balance']; $cbal += $curr['balance']; $tbal += $tot['balance']; $rep->NewLine(); if ($rep->row < $rep->bottomMargin + $rep->lineHeight) { $rep->Line($rep->row - 2); $rep->NewPage(); } } //Get Account groups/types under this group/type $result = get_account_types(false, false, $type); while ($accounttype = db_fetch($result)) { //Print Type Title if has sub types and not previously printed if (!$printtitle) { $rep->row -= 4; $rep->TextCol(0, 8, _("Group") . " - " . $type . " - " . $typename); $printtitle = 1; $rep->row -= 4; $rep->Line($rep->row); $rep->NewLine(); } display_type($accounttype["id"], $accounttype["name"] . ' (' . $typename . ')', $dec, $rep, $from, $to, $zero, $balances, $dimension, $dimension2); } }
// if me, check to see if the dest account is a valid account if (!($stmt = $mysqli->prepare("SELECT accountNum FROM accounts where accountNum = ?"))) { echo "acct check Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error; } // bind new account num param if (!$stmt->bind_param("i", $dst_account_num)) { echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error; } if (!$stmt->execute()) { echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error; } // bind the results of the query to each field // if $dst_routing_num === $my_routing_num $stmt->bind_result($dst_acct); // if the account number is invalid in the local database, die $result = $stmt->store_result(); if ($stmt->num_rows() !== 1) { echo "Unable to validate account number."; die; } // subtract the amount from the current balance, and set the new account balance $new_src_bal = get_balance(get_accountNum($_SESSION['username'])) - $amount; update_balance(get_accountNum($_SESSION['username']), $new_src_bal); // add new amount to dest balance $new_dst_bal = get_balance($dst_account_num) + $amount; update_balance($dst_account_num, $new_dst_bal); // write transaction log to the DB log_transaction("12345", get_accountNum($_SESSION['username']), $dst_routing_num, 3988282199, $amount); echo "Done processing transaction."; // if different bank, ask fed if account num is valid }
function update_ingress($arg1, $arg2, $arg3, $arg4, $arg5) { require_once __DIR__ . "/../../moneyio.php"; require_once __DIR__ . "/../../query.php"; $prepare = db_connect(); $query = $prepare->prepare(update_ingress); $query->bind_param('sssii', $arg1, $arg2, $arg3, $arg4, $arg5); $query->execute(); $value = get_balance($arg4, $arg4, $arg4); new_balance($value, $arg4); //$arg4 = wallet_id return $query; $prepare->close(); }
function route_post_order() { $member = authOpenAPIMember(); if ($member === FALSE) { status(HTTP_FORBIDDEN); exit; } $uid = $member['id']; $title = str_replace("\t", ' ', trim($_POST['title'])); $description = str_replace("\t", ' ', trim($_POST['description'])); $price = parseMoney($_POST['price']); if (!$title || strlen($title) > 140 || !$description || strlen($description) > 2000 || $price === FALSE) { return json_error('BAD_ORDER'); } // Pre-validate balance $balance = get_balance("USR", $uid, null); if (!$balance) { return json_error('NO_BALANCE'); } list($bal, $cur, $lock) = explode(':', $balance); if ($bal < $price) { return json_error('INSUFFICIENT_FUNDS'); } // Start and lock 'order' transaction $temp = start_order_transaction($uid, $price); if ($temp === FALSE) { return json_error('START_TRANS'); } // Create 'order' text $local_id = post_order($uid, $title, $description, $price); if ($local_id === FALSE) { // Cancel transaction delete_temp_transaction($temp); return json_error('POST_ORDER'); } // Commit order transaction $res = commit_transaction($temp); if (explode(':', $res)[0] != 1) { // Cancel transaction delete_temp_transaction($temp); return json_error('COMMIT_TRANS'); } // Render user's html global $i; global $page; $i = get_order($local_id); $page = array('member' => $member); ob_start(); include 'templates/_order.php'; $html = ob_get_clean(); $response = array('order' => $i, 'html' => $html, 'balance' => formatBalance('USR', $uid)); // Send to user's queue enqueue($response, $uid); // Render common html $page['member']['id'] = 0; ob_start(); include 'templates/_order.php'; $html = ob_get_clean(); // Send to common queue enqueue(array('order' => $i, 'html' => $html), ''); send_header('Content-Type: application/json; charset=utf-8'); echo json_encode($response); }
function delete_ingress($arg1, $arg2) { require_once __DIR__ . "/../../moneyio.php"; require_once __DIR__ . "/../../query.php"; $prepare = db_connect(); $query = $prepare->prepare(delete_ingress); $query->bind_param('ii', $arg1, $arg2); $query->execute(); //$get_wallet_id = get_ingress($arg2); $value = get_balance($arg2, $arg2, $arg2); // Solved issue, It taken $arg1 as ingress_id so, does not perform balance // Does not need because, It parse wallet_id auto via $_GET new_balance($value, $arg2); //$arg2 = wallet_id return $query; $prepare->close(); }
</div> <label for="dogeamount">Withdraw to: <span class="fineprint">(<?php echo $loggedInUser->dogeaddress; ?> )</span></label> <form action=' <?php echo $_SERVER['PHP_SELF']; ?> ' method="post"> <input type="text" name="withdrawdogeamount" placeholder="amount" id="dogeamount"> <input type="submit" name="submit" class="btn small" value="Withdraw Doge"> </form> </div> <div class="grid_5 push_1 box grid_box"> <div class="balance">BTC Balance: <?php echo get_balance($loggedInUser->user_id, "BTC"); ?> </div> <label for="btcamount">Withdraw to: <span class="fineprint">(<?php echo $loggedInUser->btcaddress; ?> )</span></label> <form action=' <?php echo $_SERVER['PHP_SELF']; ?> ' method="post"> <input type="text" name="withdrawbtcamount" placeholder="amount" id="btcamount"> <input type="submit" name="submit" class="btn small" value="Withdraw BTC"> </form> </div> <div class="grid_10 push_1 box grid_box">
function start_order_transaction($mid, $amount) { // Ensure 'order' account if (get_balance("ORD", $mid, null) == 'NO_ACCOUNT') { if (!create_account("ORD", $mid, null, $mid, ip2long(getRealIpAddr()), null, null, '')) { return FALSE; } } $date = time(); $temp = mt_rand() + 1; $res = create_temp_transaction($temp, array(k_transaction_party("ORD", $mid, 1, $amount, $temp, $date, null), k_transaction_party("USR", $mid, 1, -$amount, $temp, $date, null)), ip2long(getRealIpAddr()), $date, ''); if ($res < 1) { return FALSE; } $res = lock_transaction($temp); return $res == "2" ? $temp : FALSE; }
if (!in_array($currency, $currencies)) { $errors[] = "No such currency."; } if (!is_numeric($amount) || $currency == "SLC" && $amount < 0.0001 || $currency != "SLC" && $amount < 1.0E-8) { $errors[] = "Wrong amount."; } if (count($errors) == 0) { if ($currency == "SLC") { $amount = round($amount * 10000) / 10000; } else { $amount = round($amount * 100000000) / 100000000; } if (!get_lock("global")) { die("Too many queries. Please try again later."); } if ($amount > get_balance($_SESSION["user_id"], $currency)) { $errors[] = "You don't have that much."; } $slt_user_a = "SELECT * FROM user WHERE email = '{$recipient}'"; $rlt_user_a = mysql_query($slt_user_a); if (!($row_user_a = mysql_fetch_assoc($rlt_user_a))) { $errors[] = "A user with that email address does not exist."; } if (count($errors) == 0) { add_transaction($_SESSION["user_id"], "out", "intern", $amount, $currency, "internal_transfer"); add_transaction($row_user_a["id"], "in", "intern", $amount, $currency, "internal_transfer"); if ($currency == "SLC") { echo nice_format($amount, false, 0, 4) . " Solidcoins were transferred to " . htmlentities($_POST["recipient"]) . "."; } elseif ($currency == "BTC") { echo nice_format($amount, false, 0, 8) . " Bitcoins were transferred to " . htmlentities($_POST["recipient"]) . "."; } elseif ($currency == "NMC") {
function claimUser_func($method_name, $params, $app_data) { $req = $params[0]; $agentid = $req['agentId']; $sessionid = $req['secureSessionId']; $regionid = $req['regionId']; $secret = $req['secret']; # # Validate region secret # $db = new DB(); $sql = "select UUID from " . C_REGIONS_TBL . " " . "where UUID='" . $db->escape($regionid) . "' and " . "regionSecret='" . $db->escape($secret) . "'"; $db->query($sql); list($region_id) = $db->next_record(); if ($region_id) { # We have a region, check agent session $sql = "select UUID from " . C_AGENTS_TBL . " " . "where UUID='" . $db->escape($agentid) . "' and " . "secureSessionID='" . $db->escape($sessionid) . "' and " . "agentOnline=1"; $db->query($sql); list($user_id) = $db->next_record(); if ($user_id) { $sql = "update " . C_AGENTS_TBL . " set " . "currentRegion='" . $db->escape($regionid) . "' " . "where UUID='" . $db->escape($agentid) . "'"; $db->query($sql); $db->next_record(); $response_xml = xmlrpc_encode(array('success' => True, 'agentId' => $agentid, 'funds' => (int) get_balance($agentid), 'currencySecret' => " ")); } else { $response_xml = xmlrpc_encode(array('success' => False, 'errorMessage' => "Unable to authenticate avatar. Money operations may be unavailable", 'errorURI' => " ")); } } else { $response_xml = xmlrpc_encode(array('success' => False, 'errorMessage' => "This region is not authorized to manage your money. Money operations may be unavailable", 'errorURI' => " ")); } header("Content-type: text/xml"); print $response_xml; return ""; }
function auto_withdraw($currency) { global $mysqli, $db_table_prefix, $errors; $query = "Select userid, {$currency}_last_balance, {$currency}address, currency from uc_users INNER JOIN user_receive_address ON uc_users.id = user_receive_address.userid where auto{$currency} = 1"; $stmtwithdraw = $mysqli->prepare($query); $stmtwithdraw->execute(); $stmtwithdraw->bind_result($userid, $balance, $address, $fiatcurrency); $count = 0; if ($currency == 'doge') { $min = 100; $reserve = 50; } else { if ($currency == 'btc') { $min = 0.005; $reserve = 0.001; } } while ($stmtwithdraw->fetch()) { $withdraws[$count]['userid'] = $userid; $withdraws[$count]['balance'] = $balance; $withdraws[$count]['address'] = $address; $withdraws[$count]['fiatcurrency'] = $fiatcurrency; $count++; } $stmtwithdraw->close(); foreach ($withdraws as $w) { echo "\r\n==="; if ($realbalance = get_balance($w['userid'], $currency)) { if ($realbalance > $min) { echo "{balance for " . $w['userid'] . " is" . $realbalance . "}"; withdraw($w['userid'], $currency, $realbalance - $reserve, $w['address'], $w['fiatcurrency']); echo "withdraw"; } } } echo "done"; }
public function ajax_account_statstics() { if ($this->input->post()) { $this->load->model('account_model'); $this->load->model('job_model'); $user_id = $this->input->post('customer_id'); $customer_details = $this->job_model->get_customer_details($user_id); $c_balance = get_balance($user_id); $month = $this->input->post('month'); $year = $this->input->post('year'); $jmonth = $month . "-" . $year; $all = false; if ($month == "all") { $all = true; } $customer_name = $customer_details->companyname ? $customer_details->companyname : $customer_details->name; $data = $this->account_model->account_statstics($user_id, $jmonth, $all); $print = '<table border="2" width="100%"> <tr> <td colspan="10" align="center"> <h2>' . $customer_name . ' (Total Due - ' . $c_balance . ' ) </h2> </td> </tr> <tr> <td style="border:1px solid">Date</td> <td style="border:1px solid">Time</td> <td style="border:1px solid">Job No.</td> <td style="border:1px solid">Job Name</td> <td style="border:1px solid">Debit</td> <td style="border:1px solid">Credit</td> <td style="border:1px solid">Balance</td> <td style="border:1px solid">Reference</td> <td style="border:1px solid">Credit Note</td> <td style="border:1px solid">Received By</td> <td style="border:1px solid">Details</td> </tr>'; $total_debit = $total_credit = 0; foreach ($data as $result) { if ($result['t_type'] == CREDIT and $result['amount'] == 0) { continue; } if ($result['t_type'] == DEBIT) { $total_debit = $total_debit + $result['amount']; $balance = $balance - $result['amount']; } else { $total_credit = $total_credit + $result['amount']; $balance = $balance + $result['amount']; } $print .= '<tr> <td style="border:1px solid">' . date('d-m-y', strtotime($result['created'])) . '</td> <td style="border:1px solid">' . date('H:i A', strtotime($result['created'])) . '</td> <td style="border:1px solid">'; if ($result['job_id']) { $print .= $result['job_id']; } else { $print .= "-"; } //echo $print; $print .= '</td><td style="border:1px solid">' . $result['jobname'] . '</td> <td align="right" style="border:1px solid">'; $show = "-"; if ($result['t_type'] == DEBIT) { $show = $result['amount']; } $print .= $show; $print .= '</td><td align="right" style="border:1px solid">'; $show = "-"; if ($result['t_type'] != DEBIT) { $show = $result['amount']; } $print .= $show; $print .= '</td><td align="right" style="border:1px solid">' . $balance . ' </td><td style="border:1px solid">'; if (!empty($result['j_receipt'])) { $print .= "Receipt : " . $result['j_receipt']; } if (!empty($result['j_bill_number'])) { $print .= "Bill : " . $result['j_bill_number']; } if (!empty($result['cheque_number'])) { $print .= "Cheque Number : " . $result['cheque_number']; } $print .= '</td><td style="border:1px solid">'; if (!empty($result['receipt'])) { $print .= "Receipt : " . $result['receipt']; } if (!empty($result['bill_number'])) { $print .= "Bill No. : " . $result['bill_number']; } $print .= '</td><td style="border:1px solid">'; $print .= $result['receivedby']; $print .= '-' . $result['amountby']; $print .= '</td><td style="border:1px solid">' . $result['notes'] . ' </td></tr>'; } $monthly_balance = $total_credit - $total_debit; $print .= "<tr><td style='border:1px solid' colspan='4' align='right'>Total Debit</td><td style='border:1px solid' align='right'><h3>" . $total_debit . "</h3></td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td></tr>"; $print .= "<tr><td style='border:1px solid' colspan='4' align='right'>Total Credit</td><td style='border:1px solid'>-</td><td style='border:1px solid' align='right'><h3>" . $total_credit . "</h3></td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td></tr>"; $print .= "<tr><td style='border:1px solid' colspan='4' align='right'>Monthly Balance</td><td style='border:1px solid'>-</td><td style='border:1px solid'>-</td><td style='border:1px solid' align='right'><h3>" . $monthly_balance . "</h3></td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td><td style='border:1px solid'> </td></tr>"; $print .= "</table>"; $pdf = create_pdf($print, 'A4'); echo $pdf; } }
function print_user_panel($page) { echo "<h1>Welcome " . $_SESSION['name'] . "! Your last login was " . get_last_login($_SESSION['username']) . "</h1>\n <h2>Welcome to the User Panel</h2>\n Account Number: " . htmlspecialchars(get_accountNum($_SESSION['username'])) . "<br>\n Balance: " . htmlspecialchars(get_balance(get_accountNum($_SESSION['username']))) . "\n <br>\n <ul>\n <li><a href=\"/user/panel.php?page=transfer_money\">Transfer Money</a></li>\n <li><a href=\"/user/panel.php?page=transaction_history\">Transaction History</a></li>\n <li><a href=\"/user/panel.php?page=schedule_transfer\">Schedule Transfer</a></li>\n <li><a href=\"/user/panel.php?page=check_transfer_schedule\">Check Transfer Schedule</a></li>\n <li><a href=\"/user/panel.php?page=change_pin\">Change PIN</a></li>\n </ul>"; get_content($page); }
function display_trial_balance($type, $typename) { global $path_to_root, $clear_trial_balance_opening; global $k, $pdeb, $pcre, $cdeb, $ccre, $tdeb, $tcre, $pbal, $cbal, $tbal; $printtitle = 0; //Flag for printing type name $k = 0; //$accounts = get_gl_accounts(); //Get Accounts directly under this group/type $accounts = get_gl_accounts(null, null, $type); $begin = get_fiscalyear_begin_for_date($_POST['TransFromDate']); //$begin = begin_fiscalyear(); if (date1_greater_date2($begin, $_POST['TransFromDate'])) { $begin = $_POST['TransFromDate']; } $begin = add_days($begin, -1); while ($account = db_fetch($accounts)) { //Print Type Title if it has atleast one non-zero account if (!$printtitle) { start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Group") . " - " . $type . " - " . $typename, "colspan=8"); end_row(); $printtitle = 1; } // FA doesn't really clear the closed year, therefore the brought forward balance includes all the transactions from the past, even though the balance is null. // If we want to remove the balanced part for the past years, this option removes the common part from from the prev and tot figures. if (@$clear_trial_balance_opening) { $open = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $begin, $begin, false, true); $offset = min($open['debit'], $open['credit']); } else { $offset = 0; } $prev = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $begin, $_POST['TransFromDate'], false, false); $curr = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $_POST['TransFromDate'], $_POST['TransToDate'], true, true); $tot = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $begin, $_POST['TransToDate'], false, true); if (check_value("NoZero") && !$prev['balance'] && !$curr['balance'] && !$tot['balance']) { continue; } alt_table_row_color($k); $url = "<a href='{$path_to_root}/gl/inquiry/gl_account_inquiry.php?TransFromDate=" . $_POST["TransFromDate"] . "&TransToDate=" . $_POST["TransToDate"] . "&account=" . $account["account_code"] . "&Dimension=" . $_POST["Dimension"] . "&Dimension2=" . $_POST["Dimension2"] . "'>" . $account["account_code"] . "</a>"; label_cell($url); label_cell($account["account_name"]); if (check_value('Balance')) { display_debit_or_credit_cells($prev['balance']); display_debit_or_credit_cells($curr['balance']); display_debit_or_credit_cells($tot['balance']); } else { amount_cell($prev['debit'] - $offset); amount_cell($prev['credit'] - $offset); amount_cell($curr['debit']); amount_cell($curr['credit']); amount_cell($tot['debit'] - $offset); amount_cell($tot['credit'] - $offset); $pdeb += $prev['debit']; $pcre += $prev['credit']; $cdeb += $curr['debit']; $ccre += $curr['credit']; $tdeb += $tot['debit']; $tcre += $tot['credit']; } $pbal += $prev['balance']; $cbal += $curr['balance']; $tbal += $tot['balance']; end_row(); } //Get Account groups/types under this group/type $result = get_account_types(false, false, $type); while ($accounttype = db_fetch($result)) { //Print Type Title if has sub types and not previously printed if (!$printtitle) { start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Group") . " - " . $type . " - " . $typename, "colspan=8"); end_row(); $printtitle = 1; } display_trial_balance($accounttype["id"], $accounttype["name"] . ' (' . $typename . ')'); } }
<?php } } elseif ($_GET["step"] == 2) { $address = mysql_real_escape_string($_POST["address"], $db); $amount = floor(mysql_real_escape_string($_POST["amount"], $db) * 10000) / 10000; $errors = array(); if (!is_numeric($amount) || $amount < 0.5 && $amount != "0.5") { $errors[] = "Please enter a valid amount above 0.5."; } if (!check_slc_address($address)) { $errors[] = "Please enter a valid address."; } if (!get_lock("global")) { die("Too many queries. Please try again later."); } $balance = get_balance($_SESSION["user_id"], "SLC"); if (count($errors) == 0) { $result = withdraw_slc($address); if ($result["type"] == "extern") { $amountwithfee = floor(($amount + $staticfee) * 10000) / 10000; } else { $amountwithfee = floor($amount * 10000) / 10000; } if ($amountwithfee > floor($balance * 10000) / 10000) { $errors[] = "You don't have that much."; } } $server_balance = $solidcoin->sc_getbalance("main") / 10000; if (count($errors) == 0 && $server_balance < $amountwithfee * 1.05 + 1) { $errors[] = "There's currently not enough Solidcoins on the Solidcoin24 servers to fulfill your withdrawal request. Don't worry, a Solidcoin24 admin has been informed and will resolve this for you. You will get an email as soon as the Solidcoins are available. Sorry for the inconvenience, but remember that a big part of the amounts are stored in a seperate wallets for your own security."; send_mail("Emergency! Solidcoin balance exhausted ({$server_balance} left)!", "A user with the email address " . $_SESSION["user_email"] . " legitimately tried to withdraw {$amount} Solidcoins. There are still {$server_balance} Solidcoins on the server. The request was denied. Please resolve this and make sure to inform the user.", "*****@*****.**");
$result = json_decode($body, true); } else { // Get error msg $http_message = curl_error($curl); $result = json_decode($body, true); } curl_close($curl); return $result; } ////////////////////////////////////////////////////////////////////////////////////// if (TESTING_MODE == true) { $card_number = "111111111111111"; // Enter the test card number here $retailer_id = '7'; // Retailer ID will be provided by CardQuiry for all supported retailers. $pin = "20723803"; // Enter test card pin number here } else { $card_number = "6080326049539584"; // Enter the test card number here $retailer_id = '7'; // Retailer ID will be provided by CardQuiry for all supported retailers. $pin = "3643"; // Enter test card pin number here } $version = '2'; $result = get_balance($retailer_id, $card_number, trim($pin), $version); print_r($result); // echo "REQUEST ID " . $result["requestId"] . "\n"; // $delayedResult = get_delayed_balance($result["requestId"]); // print_r($delayedResult);
echo $_LANG[$l]["g_deposit"]; ?> </a> | <a href="?c=balance/withdraw_slc<?php echo $___l; ?> " <?php if ($content == "balance/withdraw_slc") { echo " class=\"active\""; } ?> ><?php echo $_LANG[$l]["g_withdraw"]; ?> </a></li> <li style="font-size: 0.9em"><?php echo nice_format(get_balance($_SESSION["user_id"], "BTC"), false, 0, 8); ?> <?php echo $_LANG[$l]["g_bitcoins"]; ?> <br /><a href="?c=balance/deposit_btc<?php echo $___l; ?> " <?php if ($content == "balance/deposit_btc") { echo " class=\"active\""; } ?> ><?php echo $_LANG[$l]["g_deposit"]; ?>
</tr> <tr> <td align="right"> Total : </td> <td align="right"><?php if(!empty($job_data->total)) { echo $job_data->total; }?></td> </tr> <tr> <td align="right"> Advance : </td> <td align="right"><?php if(!empty($job_data->advance)) { echo $job_data->advance; }?></td> </tr> <?php $show_due = $job_data->due - $job_data->discount; $u_balance = get_balance($job_data->user_id); //if(1==2 && $job_data->jpaid == 1 && $show_due > 0 && $u_balance > 0 ){ if($show_due > 0 && $u_balance < 1 ){ ?> <tr> <td colspan="5" align="right"> Due : </td> <td align="right"> <?php echo $show_due; ?></td> </tr> <?php } else { echo "2"; ?> <tr>
function sql_upd_client($is_query=1) { // update record // *********************************************************** $this->add_field('login_upd', TIME, 'int'); $this->add_field('contact_upd', TIME, 'int'); $this->add_field('account_upd', TIME, 'int'); $this->add_field('account_balance', get_balance($this->client_id)); $this->add_field('account_hpsp', get_hpsp($this->client_id)); $this->add_field('account_lcsp', get_lcsp($this->client_id)); $this->add_field('account_trades', get_nof_rec('trades', 'trade_account='.$this->client_id.' AND trade_status>0')); $this->add_field('account_lastfnd', get_first_value('fund_valdate', 'funds', 'fund_account='.$this->client_id, 'DESC')); $this->add_field('account_lasttrd', get_first_value('trade_valdate', 'trades', 'trade_account='.$this->client_id, 'DESC')); $this->add_field('account_options', get_total_options($this->client_id)); $this->add_field('bank_upd', TIME, 'int'); // account_status if (($this->account_trades>1)&&($this->account_status>1)){ $this->add_field('account_status', 9); }elseif (($this->account_trades==1)&&($this->account_status>1)){ $this->add_field('account_status', 3); }elseif ($this->account_status>1){ $this->add_field('account_status', 2); }elseif (($this->account_logged<(TIME-DAYS_TILL_EXPIRY))&&($this->account_status>1)){ $this->add_field('account_status', 1); } $sql_login='******'; foreach ($this->field_value as $key=>$val){ if ('login'==substr($key, 0, 5)){ $val=set_insql($val, $this->field_type[$key]); $sql_login.=$key.'='.$val.', '; } } $sql_login=substr($sql_login, 0, -2); $sql_login.=' WHERE login_id='.$this->login_id; $sql_contact='UPDATE contacts SET '; foreach ($this->field_value as $key=>$val){ if ('contact'==substr($key, 0, 7)){ $val=set_insql($val, $this->field_type[$key]); $sql_contact.=$key.'='.$val.', '; } } $sql_contact=substr($sql_contact, 0, -2); $sql_contact.=' WHERE contact_id='.$this->contact_id; $sql_account='UPDATE accounts SET '; foreach ($this->field_value as $key=>$val){ if ('account'==substr($key, 0, 7)){ $val=set_insql($val, $this->field_type[$key]); $sql_account.=$key.'='.$val.', '; } } $sql_account=substr($sql_account, 0, -2); $sql_account.=' WHERE account_id='.$this->account_id; $sql_bank='UPDATE banks SET '; foreach ($this->field_value as $key=>$val){ if ('bank'==substr($key, 0, 4)){ $val=set_insql($val, $this->field_type[$key]); $sql_bank.=$key.'='.$val.', '; } } $sql_bank=substr($sql_bank, 0, -2); $sql_bank.=' WHERE bank_id='.$this->bank_id; if ($is_query){ // process query mysql_query($sql_login); mysql_query($sql_contact); mysql_query($sql_account); mysql_query($sql_bank); }else{ echo $sql_login.'<br/>'.$sql_contact.'<br/>'.$sql_account.'<br/>'.$sql_bank; } }
function display_trial_balance($type, $typename) { global $path_to_root; global $k, $pdeb, $pcre, $cdeb, $ccre, $tdeb, $tcre, $pbal, $cbal, $tbal; $printtitle = 0; //Flag for printing type name $k = 0; //$accounts = get_gl_accounts(); //Get Accounts directly under this group/type $accounts = get_gl_accounts(null, null, $type); $begin = get_fiscalyear_begin_for_date($_POST['TransFromDate']); //$begin = begin_fiscalyear(); if (date1_greater_date2($begin, $_POST['TransFromDate'])) { $begin = $_POST['TransFromDate']; } $begin = add_days($begin, -1); while ($account = db_fetch($accounts)) { //Print Type Title if it has atleast one non-zero account if ($type == 3502) { continue; } if (!$printtitle) { start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Group") . " - " . $type . " - " . $typename, "colspan=8"); end_row(); $printtitle = 1; } $prev = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $begin, $_POST['TransFromDate'], false, false); $curr = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $_POST['TransFromDate'], $_POST['TransToDate'], true, true); $tot = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $begin, $_POST['TransToDate'], false, true); if (check_value("NoZero") && !$prev['balance'] && !$curr['balance'] && !$tot['balance']) { continue; } alt_table_row_color($k); $url = "<a href='{$path_to_root}/gl/inquiry/gl_account_inquiry.php?TransFromDate=" . $_POST["TransFromDate"] . "&TransToDate=" . $_POST["TransToDate"] . "&account=" . $account["account_code"] . "&Dimension=" . $_POST["Dimension"] . "&Dimension2=" . $_POST["Dimension2"] . "'>" . $account["account_code"] . "</a>"; label_cell($url); label_cell($account["account_name"]); if (check_value('Balance')) { display_debit_or_credit_cells($prev['balance']); display_debit_or_credit_cells($curr['balance']); display_debit_or_credit_cells($tot['balance']); } else { amount_cell($prev['debit']); amount_cell($prev['credit']); amount_cell($curr['debit']); amount_cell($curr['credit']); amount_cell($tot['debit']); amount_cell($tot['credit']); $pdeb += $prev['debit']; $pcre += $prev['credit']; $cdeb += $curr['debit']; $ccre += $curr['credit']; $tdeb += $tot['debit']; $tcre += $tot['credit']; } $pbal += $prev['balance']; $cbal += $curr['balance']; $tbal += $tot['balance']; end_row(); } //Get Account groups/types under this group/type $result = get_account_types(false, false, $type); while ($accounttype = db_fetch($result)) { //Print Type Title if has sub types and not previously printed if (!$printtitle) { start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Group") . " - " . $type . " - " . $typename, "colspan=8"); end_row(); $printtitle = 1; } display_trial_balance($accounttype["id"], $accounttype["name"] . ' (' . $typename . ')'); } }
<?php $t = 30; $x = $today - 60 * 60 * 24 * $t; //this will get the most recent transactions $recent = recent_trans($x); $a = recent_trans($x); //this will get the balance from the previous transactions $balance = get_balance($x); //this will produced the earliest date... $pull_date = mysql_fetch_array($a); $earliest_date = date("n/j", strtotime($pull_date['date'])); //this will get the entire check book balance $book_bal = get_balance($x, 1); ?> <!DOCTYPE HTML> <html> <header> <title>Family Budget</title> <link rel="stylesheet" type="text/css" href= "budget.css"> </header> <body> <h1 style="text-align: center;">Family Budget</h1> <?php if ($_GET['error'] == 1) { echo "<p><strong>Could not find the item you were trying to edit!</strong></p>"; } if ($_GET['del'] == 1) { echo "<p><strong>One record was deleted.</strong></p>"; }
function delete_cost($arg1, $arg2) { require_once __DIR__ . "/../../moneyio.php"; require_once __DIR__ . "/../../query.php"; $prepare = db_connect(); $query = $prepare->prepare(delete_cost); $query->bind_param('ii', $arg1, $arg2); $query->execute(); //$get_wallet_id = get_cost($arg1); Does not needed //because wallet_id is request by $_GET at disable.php page $value = get_balance($arg2, $arg2, $arg2); new_balance($value, $arg2); //$arg2 = wallet_id return $query; $prepare->close(); }