public function cart()
{
$this->getResponse()->addHeader("Cache-Control", "no-store, no-cache, must-revalidate");
$this->getResponse()->addHeader("Expires", date("r"));
if (waRequest::method() == 'post') {
$data = wa()->getStorage()->get('shop/checkout', array());
if ($coupon_code = waRequest::post('coupon_code')) {
$data['coupon_code'] = $coupon_code;
} elseif (isset($data['coupon_code'])) {
unset($data['coupon_code']);
}
if (($use = waRequest::post('use_affiliate')) !== null) {
if ($use) {
$data['use_affiliate'] = 1;
} elseif (isset($data['use_affiliate'])) {
unset($data['use_affiliate']);
}
}
if ($coupon_code || $use) {
wa()->getStorage()->set('shop/checkout', $data);
wa()->getStorage()->remove('shop/cart');
}
}
$cart_model = new shopCartItemsModel();
$cart = new shopCart();
$code = $cart->getCode();
$errors = array();
if (waRequest::post('checkout')) {
$saved_quantity = $cart_model->select('id,quantity')->where("type='product' AND code = s:code", array('code' => $code))->fetchAll('id');
$quantity = waRequest::post('quantity');
foreach ($quantity as $id => $q) {
if ($q != $saved_quantity[$id]) {
$cart->setQuantity($id, $q);
}
}
$not_available_items = $cart_model->getNotAvailableProducts($code, !wa()->getSetting('ignore_stock_count'));
foreach ($not_available_items as $row) {
if ($row['sku_name']) {
$row['name'] .= ' (' . $row['sku_name'] . ')';
}
if ($row['available']) {
$errors[$row['id']] = sprintf(_w('Only %d pcs of %s are available, and you already have all of them in your shopping cart.'), $row['count'], $row['name']);
} else {
$errors[$row['id']] = _w('Oops! %s is not available for purchase at the moment. Please remove this product from your shopping cart to proceed.');
}
}
if (!$errors) {
$this->redirect(wa()->getRouteUrl('/frontend/checkout'));
}
}
$items = $cart_model->where('code= ?', $code)->order('parent_id')->fetchAll('id');
$product_ids = $sku_ids = $service_ids = $type_ids = array();
foreach ($items as $item) {
$product_ids[] = $item['product_id'];
$sku_ids[] = $item['sku_id'];
}
$product_ids = array_unique($product_ids);
$sku_ids = array_unique($sku_ids);
$product_model = new shopProductModel();
if (waRequest::param('url_type') == 2) {
$products = $product_model->getWithCategoryUrl($product_ids);
} else {
$products = $product_model->getById($product_ids);
}
$sku_model = new shopProductSkusModel();
$skus = $sku_model->getByField('id', $sku_ids, 'id');
$image_model = new shopProductImagesModel();
$delete_items = array();
foreach ($items as $item_id => &$item) {
if (!isset($skus[$item['sku_id']])) {
unset($items[$item_id]);
$delete_items[] = $item_id;
continue;
}
if ($item['type'] == 'product') {
$item['product'] = $products[$item['product_id']];
$sku = $skus[$item['sku_id']];
if ($sku['image_id'] && $sku['image_id'] != $item['product']['image_id']) {
$img = $image_model->getById($sku['image_id']);
if ($img) {
$item['product']['image_id'] = $sku['image_id'];
$item['product']['ext'] = $img['ext'];
}
}
$item['sku_name'] = $sku['name'];
$item['sku_code'] = $sku['sku'];
$item['price'] = $sku['price'];
$item['compare_price'] = $sku['compare_price'];
$item['currency'] = $item['product']['currency'];
$type_ids[] = $item['product']['type_id'];
if (isset($errors[$item_id])) {
$item['error'] = $errors[$item_id];
if (strpos($item['error'], '%s') !== false) {
$item['error'] = sprintf($item['error'], $item['product']['name'] . ($item['sku_name'] ? ' (' . $item['sku_name'] . ')' : ''));
}
}
}
}
unset($item);
if ($delete_items) {
$cart_model->deleteByField(array('code' => $code, 'id' => $delete_items));
}
$type_ids = array_unique($type_ids);
// get available services for all types of products
$type_services_model = new shopTypeServicesModel();
$rows = $type_services_model->getByField('type_id', $type_ids, true);
$type_services = array();
foreach ($rows as $row) {
$service_ids[] = $row['service_id'];
$type_services[$row['type_id']][$row['service_id']] = true;
}
// get services for all products
$product_services_model = new shopProductServicesModel();
$rows = $product_services_model->getByProducts($product_ids);
$product_services = $sku_services = array();
foreach ($rows as $row) {
if ($row['sku_id'] && !in_array($row['sku_id'], $sku_ids)) {
continue;
}
$service_ids[] = $row['service_id'];
if (!$row['sku_id']) {
$product_services[$row['product_id']][$row['service_id']]['variants'][$row['service_variant_id']] = $row;
}
if ($row['sku_id']) {
$sku_services[$row['sku_id']][$row['service_id']]['variants'][$row['service_variant_id']] = $row;
}
}
$service_ids = array_unique($service_ids);
$service_model = new shopServiceModel();
$variant_model = new shopServiceVariantsModel();
$services = $service_model->getByField('id', $service_ids, 'id');
foreach ($services as &$s) {
unset($s['id']);
}
unset($s);
$rows = $variant_model->getByField('service_id', $service_ids, true);
foreach ($rows as $row) {
$services[$row['service_id']]['variants'][$row['id']] = $row;
unset($services[$row['service_id']]['variants'][$row['id']]['id']);
}
foreach ($items as $item_id => $item) {
if ($item['type'] == 'product') {
$p = $item['product'];
$item_services = array();
// services from type settings
if (isset($type_services[$p['type_id']])) {
foreach ($type_services[$p['type_id']] as $service_id => &$s) {
$item_services[$service_id] = $services[$service_id];
}
}
// services from product settings
if (isset($product_services[$item['product_id']])) {
foreach ($product_services[$item['product_id']] as $service_id => $s) {
if (!isset($s['status']) || $s['status']) {
if (!isset($item_services[$service_id])) {
$item_services[$service_id] = $services[$service_id];
}
// update variants
foreach ($s['variants'] as $variant_id => $v) {
if ($v['status']) {
if ($v['price'] !== null) {
$item_services[$service_id]['variants'][$variant_id]['price'] = $v['price'];
}
} else {
unset($item_services[$service_id]['variants'][$variant_id]);
}
}
} elseif (isset($item_services[$service_id])) {
// remove disabled service
unset($item_services[$service_id]);
}
}
}
// services from sku settings
if (isset($sku_services[$item['sku_id']])) {
foreach ($sku_services[$item['sku_id']] as $service_id => $s) {
if (!isset($s['status']) || $s['status']) {
// update variants
foreach ($s['variants'] as $variant_id => $v) {
if ($v['status']) {
if ($v['price'] !== null) {
$item_services[$service_id]['variants'][$variant_id]['price'] = $v['price'];
}
} else {
unset($item_services[$service_id]['variants'][$variant_id]);
}
}
} elseif (isset($item_services[$service_id])) {
// remove disabled service
unset($item_services[$service_id]);
}
}
}
foreach ($item_services as $s_id => &$s) {
if (!$s['variants']) {
unset($item_services[$s_id]);
continue;
}
if ($s['currency'] == '%') {
foreach ($s['variants'] as $v_id => $v) {
$s['variants'][$v_id]['price'] = $v['price'] * $item['price'] / 100;
}
$s['currency'] = $item['currency'];
}
if (count($s['variants']) == 1) {
$v = reset($s['variants']);
$s['price'] = $v['price'];
unset($s['variants']);
}
}
unset($s);
uasort($item_services, array('shopServiceModel', 'sortServices'));
$items[$item_id]['services'] = $item_services;
} else {
$items[$item['parent_id']]['services'][$item['service_id']]['id'] = $item['id'];
if (isset($item['service_variant_id'])) {
$items[$item['parent_id']]['services'][$item['service_id']]['variant_id'] = $item['service_variant_id'];
}
unset($items[$item_id]);
}
}
foreach ($items as $item_id => $item) {
$price = shop_currency($item['price'] * $item['quantity'], $item['currency'], null, false);
if (isset($item['services'])) {
foreach ($item['services'] as $s) {
if (!empty($s['id'])) {
if (isset($s['variants'])) {
$price += shop_currency($s['variants'][$s['variant_id']]['price'] * $item['quantity'], $s['currency'], null, false);
} else {
$price += shop_currency($s['price'] * $item['quantity'], $s['currency'], null, false);
}
}
}
}
$items[$item_id]['full_price'] = $price;
}
$total = $cart->total(false);
$order = array('total' => $total, 'items' => $items);
$order['discount'] = $discount = shopDiscounts::calculate($order);
$order['total'] = $total = $total - $order['discount'];
$data = wa()->getStorage()->get('shop/checkout');
$this->view->assign('cart', array('items' => $items, 'total' => $total, 'count' => $cart->count()));
$this->view->assign('coupon_code', isset($data['coupon_code']) ? $data['coupon_code'] : '');
if (shopAffiliate::isEnabled()) {
$affiliate_bonus = 0;
if ($this->getUser()->isAuth()) {
$customer_model = new shopCustomerModel();
$customer = $customer_model->getById($this->getUser()->getId());
$affiliate_bonus = $customer ? round($customer['affiliate_bonus'], 2) : 0;
}
$this->view->assign('affiliate_bonus', $affiliate_bonus);
$use = !empty($data['use_affiliate']);
$this->view->assign('use_affiliate', $use);
if ($use) {
$discount -= shop_currency(shopAffiliate::convertBonus($order['params']['affiliate_bonus']), $this->getConfig()->getCurrency(true), null, false);
$this->view->assign('used_affiliate_bonus', $order['params']['affiliate_bonus']);
}
$order['currency'] = $this->getConfig()->getCurrency(false);
$add_affiliate_bonus = shopAffiliate::calculateBonus($order);
$this->view->assign('add_affiliate_bonus', round($add_affiliate_bonus, 2));
}
$this->view->assign('discount', $discount);
/**
* @event frontend_cart
* @return array[string]string $return[%plugin_id%] html output
*/
$this->view->assign('frontend_cart', wa()->event('frontend_cart'));
$checkout_flow = new shopCheckoutFlowModel();
$checkout_flow->add(array('code' => $code, 'step' => 0, 'description' => null));
}
public function getByCode($code, $full_info = false, $hierarchy = true)
{
if (!$code) {
return array();
}
$sql = "SELECT * FROM " . $this->table . " WHERE code = s:0 ORDER BY parent_id";
$items = $this->query($sql, $code)->fetchAll('id');
if ($full_info) {
$product_ids = $sku_ids = $service_ids = $variant_ids = array();
foreach ($items as $item) {
$product_ids[] = $item['product_id'];
$sku_ids[] = $item['sku_id'];
if ($item['type'] == 'service') {
$service_ids[] = $item['service_id'];
if ($item['service_variant_id']) {
$variant_ids[] = $item['service_variant_id'];
}
}
}
$product_model = new shopProductModel();
$products = $product_model->getByField('id', $product_ids, 'id');
$sku_model = new shopProductSkusModel();
$skus = $sku_model->getByField('id', $sku_ids, 'id');
$service_model = new shopServiceModel();
$services = $service_model->getByField('id', $service_ids, 'id');
$service_variants_model = new shopServiceVariantsModel();
$variants = $service_variants_model->getByField('id', $variant_ids, 'id');
$product_services_model = new shopProductServicesModel();
$rows = $product_services_model->getByProducts($product_ids);
$product_services = $sku_services = array();
foreach ($rows as $row) {
if ($row['sku_id'] && !in_array($row['sku_id'], $sku_ids)) {
continue;
}
$service_ids[] = $row['service_id'];
if (!$row['sku_id']) {
$product_services[$row['product_id']][$row['service_variant_id']] = $row;
}
if ($row['sku_id']) {
$sku_services[$row['sku_id']][$row['service_variant_id']] = $row;
}
}
foreach ($items as $item_key => &$item) {
if ($item['type'] == 'product' && isset($products[$item['product_id']])) {
$item['product'] = $products[$item['product_id']];
if (!isset($skus[$item['sku_id']])) {
unset($items[$item_key]);
continue;
}
$sku = $skus[$item['sku_id']];
$item['sku_code'] = $sku['sku'];
$item['purchase_price'] = $sku['purchase_price'];
$item['sku_name'] = $sku['name'];
$item['currency'] = $item['product']['currency'];
$item['price'] = $sku['price'];
$item['name'] = $item['product']['name'];
if ($item['sku_name']) {
$item['name'] .= ' (' . $item['sku_name'] . ')';
}
} elseif ($item['type'] == 'service' && isset($services[$item['service_id']])) {
$item['name'] = $item['service_name'] = $services[$item['service_id']]['name'];
$item['currency'] = $services[$item['service_id']]['currency'];
$item['service'] = $services[$item['service_id']];
$item['variant_name'] = $variants[$item['service_variant_id']]['name'];
if ($item['variant_name']) {
$item['name'] .= ' (' . $item['variant_name'] . ')';
}
$item['price'] = $variants[$item['service_variant_id']]['price'];
if (isset($product_services[$item['product_id']][$item['service_variant_id']])) {
if ($product_services[$item['product_id']][$item['service_variant_id']]['price'] !== null) {
$item['price'] = $product_services[$item['product_id']][$item['service_variant_id']]['price'];
}
}
if (isset($sku_services[$item['sku_id']][$item['service_variant_id']])) {
if ($sku_services[$item['sku_id']][$item['service_variant_id']]['price'] !== null) {
$item['price'] = $sku_services[$item['sku_id']][$item['service_variant_id']]['price'];
}
}
if ($item['currency'] == '%') {
$p = $items[$item['parent_id']];
$item['price'] = $item['price'] * $p['price'] / 100;
$item['currency'] = $p['currency'];
}
}
}
unset($item);
}
// sort
foreach ($items as $item_id => $item) {
if ($item['parent_id']) {
$items[$item['parent_id']]['services'][] = $item;
unset($items[$item_id]);
}
}
if (!$hierarchy) {
$result = array();
foreach ($items as $item_id => $item) {
if (isset($item['services'])) {
$i = $item;
unset($i['services']);
$result[$item_id] = $i;
foreach ($item['services'] as $s) {
$result[$s['id']] = $s;
}
} else {
$result[$item_id] = $item;
}
}
$items = $result;
}
return $items;
}
/**
* @param $service_ids
* @return array
*/
private function getServices($service_ids)
{
$service_model = new shopServiceModel();
$variant_model = new shopServiceVariantsModel();
$services = $service_model->getByField('id', $service_ids, 'id');
foreach ($services as &$s) {
unset($s['id']);
}
unset($s);
$rows = $variant_model->getByField('service_id', $service_ids, true);
foreach ($rows as $row) {
$services[$row['service_id']]['variants'][$row['id']] = $row;
unset($services[$row['service_id']]['variants'][$row['id']]['id']);
}
return $services;
}