public function getItemCount($userId)
{
$cartId = ShoppingCarts::where('user_id', $userId)->first();
if (!$cartId) {
return 0;
}
return ShoppingCartItems::where('shopping_cart_id', $cartId->id)->count();
}
public function getShoppingCart($entity, $createIfMissing = false)
{
$cart = ShoppingCarts::first(array('conditions' => array('user_id' => $entity->_id, 'status' => 'open')));
if (!isset($cart) and $createIfMissing) {
$cart = ShoppingCarts::create();
$cart->user_id = $entity->_id;
$cart->status = 'open';
$cart->save();
}
return $cart;
}
public function run()
{
$expiredItems = CartItems::all(array('conditions' => array('status' => array('$in' => array('open', 'authorized')))));
foreach ($expiredItems as $item) {
$reg = $item->getReference();
$league = $reg->getLeague();
if (!$league->registrationOpen()) {
$item->status = CartItems::STATUS_EXPR;
$item->save();
###TODO: Cancel payment with paypal
foreach ($item->carts as $c) {
$cart = ShoppingCarts::find("{$c}");
$cart->status = 'expired';
$cart->save();
}
} else {
echo "Skipping {$item->_id} for {$league->name}\n";
}
}
}
public function ipn()
{
if ($this->request->data) {
$paypal_txn_id = $this->request->data['txn_id'];
$payment = Payments::first(array('conditions' => array(array('txn_id' => $paypal_txn_id))));
if (!isset($payment)) {
Logger::debug('New transaction #' . $paypal_txn_id);
# Put the payment in the DB
$payment = Payments::create($this->request->data);
if ($payment->invoice) {
# Map invoices to cart_ids, right now this is direct
$payment->shopping_cart_id = $payment->invoice;
}
$payment->save();
} else {
Logger::debug('Transaction play-back (txn #' . $paypal_txn_id . ')');
}
Logger::debug('$payment->_id = ' . $payment->_id);
$cart = ShoppingCarts::find($payment->invoice);
Logger::debug('$cart->_id = ' . $cart->_id);
$items = $cart->getItems();
if (strtolower($payment->payment_status) == 'pending' and strtolower($payment->pending_reason) == 'authorization') {
$captureAmount = 0;
$remainder = 0;
Logger::debug('authorization transaction');
foreach ($items as $ci) {
Logger::debug('.....cart_item ' . $ci->_id);
$refObj = $ci->getReference();
if ($ci->isValid()) {
Logger::debug('..........valid purchase -- auto-capture');
$ci->save(array('status' => CartItems::STATUS_CAPT));
// Pass payment status down to referenced object
$conditions = array('_id' => $refObj->_id);
$query = array('$set' => array('payment_status' => CartItems::STATUS_CAPT, 'payment_timestamps.pending' => $payment->payment_date), '$push' => array('payments' => $payment->_id));
Registrations::update($query, $conditions);
$captureAmount += $ci->price;
} else {
Logger::debug('..........not valid, hold as pending');
$ci->save(array('status' => CartItems::STATUS_AUTH));
// Pass payment status down to referenced object
$conditions = array('_id' => $refObj->_id);
$query = array('$set' => array('payment_status' => CartItems::STATUS_AUTH, 'payment_timestamps.pending' => $payment->payment_date), '$push' => array('payments' => $payment->_id));
Registrations::update($query, $conditions);
$remainder += $ci->price;
}
$cart->save(array('is_authorized' => true));
}
if ($captureAmount > 0) {
Logger::debug('Capturing $' . $captureAmount);
$result = Paypal::doCapture($payment->auth_id, $captureAmount, $payment->mc_currency, $remainder == 0);
Logger::debug(print_r($result, true));
// Log NVP transaction result to the payment
$query = array('$push' => array('nvp' => $result));
$conditions = array('_id' => $payment->_id);
Payments::update($query, $conditions);
Logger::debug('Captured!');
}
} else {
if (strtolower($payment->payment_status) == 'completed') {
$unpaid_items = 0;
foreach ($items as $ci) {
Logger::debug('.....cart_item ' . $ci->_id);
$refObj = $ci->getReference();
if ($ci->status == CartItems::STATUS_CAPT) {
Logger::debug('..........PAID!');
$ci->save(array('status' => CartItems::STATUS_PAID));
// Pass payment status down to referenced object
// TODO: this stuff should really be handled by the registration object
$conditions = array('_id' => $refObj->_id);
$query = array('$set' => array('paid' => true, 'payment_status' => CartItems::STATUS_PAID, 'status' => 'active', 'payment_timestamps.completed' => $payment->payment_date), '$push' => array('payments' => $payment->_id));
Registrations::update($query, $conditions);
} else {
if ($ci->status != CartItems::STATUS_PAID) {
$unpaid_items++;
}
}
}
if ($unpaid_items == 0) {
$cart->save(array('status' => 'closed'));
}
} else {
if (strtolower($payment->payment_status) == 'refunded') {
foreach ($items as $ci) {
Logger::debug('.....cart_item ' . $ci->_id);
$refObj = $ci->getReference();
$conditions = array('_id' => $refObj->_id);
$query = array('$set' => array('paid' => false, 'payment_status' => CartItems::STATUS_RFND, 'payment_timestamps.refunded' => $payment->payment_date), '$push' => array('payments' => $payment->_id));
Registrations::update($query, $conditions);
Logger::debug('..........refunded.');
}
}
}
}
}
return $this->render(array('layout' => false));
}
public function itemCount(Request $request)
{
$userId = $request->session()->get('user_id');
$shoppingCart = new ShoppingCarts();
return $shoppingCart->getItemCount($userId);
}
public function updateSales(Request $request, $approved)
{
$userId = $request->session()->get('user_id');
$roles = $request->session()->get('userRoles');
$user = Users::find($userId);
$shoppingCart = ShoppingCarts::where('user_id', $userId)->first();
$items = $this->processApprovedItems($shoppingCart);
$payPrice = $request->session()->get('transactionPayPrice');
$salesTransaction = new SalesTransactions();
$salesTransaction->date = $approved['date'];
$salesTransaction->purchased_by = $userId;
$salesTransaction->total_items = $request->session()->get('transactionTotalPrice');
$shipping = $request->session()->get('transactionTotalWeightShipping') + $request->session()->get('transactionTotalShipping');
$salesTransaction->total_shipping = $shipping;
$salesTransaction->total_order = $request->session()->get('transactionGrandTotal');
$salesTransaction->payment_method = 1;
$salesTransaction->pay_bonus_on_amt = $request->session()->get('payPrice');
$salesTransaction->credit_card_id = $approved['credit_card'];
$salesTransaction->payment_type = $approved['pay_method'];
$salesTransaction->transaction_approval_code = $approved['approval_code'];
$salesTransaction->transaction_approval_date = $approved['date'];
$salesTransaction->first_id = $user->sponsor_id;
$salesTransaction->second_id = $user->second_id;
$salesTransaction->third_id = $user->third_id;
$salesTransaction->fourth_id = $user->fourth_id;
$salesTransaction->fifth_id = $user->fifth_id;
$salesTransaction->shipping_id = $request->session()->get('shippingId');
$salesTransaction->save();
$this->updateSalesDetails($salesTransaction, $items, $roles);
$this->updateBonuses($salesTransaction, $user, $roles);
$items = $this->processPaidItems($shoppingCart);
return 1000000 + $salesTransaction->id;
}
