Exemplo n.º 1
0
 public function stockDec()
 {
     if (IS_POST || IS_AJAX) {
         //计算收益
         $gain = calcGain();
         //更新库存
         updateStock();
         //增加日志
         updateStockLog();
         if (IS_AJAX) {
         }
     } else {
         $this->display();
     }
 }
Exemplo n.º 2
0
             $db->rollback();
             echo json_encode(-1);
             return;
         }
     }
     $db->commit();
     echo json_encode(1);
 } else {
     if ($decoded->function == 'updatePedido') {
         updatePedido($decoded->pedido);
     } else {
         if ($decoded->function == 'updatePedidoDetalle') {
             updatePedidoDetalle($decoded->pedido_detalle);
         } else {
             if ($decoded->function == 'updateStock') {
                 updateStock($decoded->stock);
             } else {
                 if ($decoded->function == 'removePedido') {
                     removePedido($decoded->pedido_id);
                 } else {
                     if ($decoded->function == 'removePedidoDetalle') {
                         removePedidoDetalle($decoded->pedido_detalle_id);
                     } else {
                         if ($decoded->function == 'removeStock') {
                             removeStock($decoded->stock_id);
                         } else {
                             if ($decoded->function == 'trasladar') {
                                 trasladar($decoded->origen_id, $decoded->destino_id, $decoded->producto_id, $decoded->cantidad);
                             }
                         }
                     }
Exemplo n.º 3
0
<?php

// Build items array
$items = [];
foreach ($cart->getItems() as $i => $item) {
    $items[] = ['uri' => $item->uri, 'variant' => $item->variant, 'quantity' => $item->quantity];
}
// Update stock
updateStock($items);
// Notify staff
$notifications = page('shop')->notifications()->toStructure();
if ($notifications->count()) {
    foreach ($notifications as $n) {
        // Reset
        $send = false;
        // Check if the products match
        $uids = explode(',', $n->products());
        if ($uids[0] === '') {
            $send = true;
        } else {
            foreach ($uids as $uid) {
                foreach ($items as $item) {
                    if (strpos($item['uri'], trim($uid))) {
                        $send = true;
                    }
                }
            }
        }
        // Send the email
        if ($send) {
            $body = 'Someone made a purchase from ' . server::get('server_name') . "\n\n";
Exemplo n.º 4
0
        printf("no results!");
    }
    mysqli_free_result($result);
    return $array;
}
$con = mysqli_connect("dbhost.cs.man.ac.uk", "mbbx9mg3", "Fincherz+2013") or die("Error " . mysqli_error($link));
mysqli_select_db($con, "mbbx9mg3");
$validNewAmount = false;
if (isset($_POST["submit_button"])) {
    $itemSelected = $_POST['item'];
    $newAmount = $_POST['newAmount'];
    $message = "";
    $validNewAmount = is_numeric($newAmount) && $newAmount >= 0;
    if ($validNewAmount) {
        $id = getItemID($itemSelected, $con);
        updateStock($id, $newAmount, $con);
        $message = "Stock updated successfully!";
    } else {
        $message = "Please check your input again!\n  is int: " . is_int($newAmount) . ", >= 0 : " . ($newAmount >= 0) . "";
    }
}
// isInserted
$array = selectItems($con);
mysqli_close($con);
?>
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php

// This page is the endpoint of PayPal's IPN callback.
// Only the PayPal server accesses this page, so no need to include redirects
if ($_POST['txn_id'] != '') {
    snippet('payment.success.paypal.ipn');
    // Validate the PayPal transaction against the pending order
    $txn = page('shop/orders/' . $_POST['custom']);
    if ($txn->subtotal()->value == $_POST['mc_gross'] - $_POST['mc_shipping'] - $_POST['tax'] and $txn->shipping()->value == $_POST['mc_shipping'] and $txn->tax()->value == $_POST['tax'] and $txn->txn_currency() == $_POST['mc_currency']) {
        try {
            // Update transaction record
            $txn->update(['paypal-txn-id' => $_POST['txn_id'], 'status' => strtolower($_POST['payment_status']), 'payer-id' => $_POST['payer_id'], 'payer-name' => $_POST['first_name'] . " " . $_POST['last_name'], 'payer-email' => $_POST['payer_email'], 'payer-address' => $_POST['address_street'] . "\n" . $_POST['address_city'] . ", " . $_POST['address_state'] . " " . $_POST['address_zip'] . "\n" . $_POST['address_country']]);
            // Update product stock
            updateStock(unserialize(urldecode($txn->encoded_items())));
        } catch (Exception $e) {
            return false;
        }
    }
} else {
    // Data didn't come back properly from PayPal
    return false;
}
Exemplo n.º 6
0
<?php

/**
 * Order callback snippet
 * This snippet is called from each gateway's callback script. It updates stock and notifies staff of the new order.
 *
 * Expected pass-through variables:
 * $txn           page object
 * $status        string
 * $payer_name    string
 * $payer_email   string
 * $payer_address string
 */
// Update stock
updateStock($txn);
// Notify staff
$notifications = page('shop')->notifications()->toStructure();
if ($notifications->count()) {
    foreach ($notifications as $n) {
        // Reset
        $send = false;
        // Check if the products match
        $uids = explode(',', $n->products());
        if ($uids[0] === '') {
            $send = true;
        } else {
            foreach ($uids as $uid) {
                foreach ($txn->products()->toStructure() as $item) {
                    if (strpos($item->uri(), trim($uid))) {
                        $send = true;
                    }
Exemplo n.º 7
0
 if ($total === $totalinst && $change === $changeinst) {
     // calculation validation
     $conn = new mysqli($GLOBALS['servername'], $GLOBALS['dbuser'], $GLOBALS['dbpass'], $GLOBALS['dbname']);
     if ($conn->connect_error) {
         die('Error establishing connection to the database server! Error: ' . $conn->connect_error);
     }
     $date = date('Y/m/d H:i:s');
     $query = "INSERT INTO `eb_total_penjualan`\r\n\t\t\t(`totalharga`, `bayar`, `kembali`, `tanggal`) \r\n\t\t\tVALUES (" . (string) $total . "," . (string) $paymentinst . "," . $change . ",\r\n\t\t\t\t\t'" . $date . "')";
     $res = $conn->query($query);
     if ($res === true) {
         $id = $conn->insert_id;
         $summary = true;
         for ($i = 0; $i < count($barangs); $i++) {
             $query2 = "INSERT INTO `eb_penjualan`\r\n\t\t\t\t\t\t\t(`idbarang`, `iduser`, `idpenjualan`, `jumlah`, \r\n\t\t\t\t\t\t\t`currenthargabeli`, `currenthargajual`, `tanggal`) \r\n\t\t\t\t\t\t\tVALUES (" . $barangs[$i]->id . "," . $userid . "," . $id . "," . $barangs[$i]->jumlah . ",\r\n\t\t\t\t\t\t\t" . $barangs[$i]->hargabeli . "," . $barangs[$i]->hargajual . ",'" . $date . "')";
             $res2 = $conn->query($query2);
             if ($res2 === false || updateStock($barangs[$i]->id, $barangs[$i]->jumlah * -1) === false) {
                 $summary = false;
             }
         }
         if ($summary === true) {
             $class = new stdClass();
             $class->status = 0;
             $class->desc = 'Berhasil memasukkan seluruh penjualan!';
             echo json_encode($class);
             return;
         } else {
             $class = new stdClass();
             $class->status = 1;
             $class->desc = 'Terjadi kesalahan dalam memasukkan item penjualan!';
             echo json_encode($class);
             return;