public function order($oID)
{
$order = VividOrder::getByID($oID);
$this->set("order", $order);
$this->set('orderStatuses', OrderStatus::getList());
$this->requireAsset('javascript', 'vividStoreFunctions');
}
public function paypal_notify()
{
$crypt = Loader::helper('encryption');
$paypal = new \Concrete\Package\PaypalExpressVividStore\Src\VividStore\Payment\Methods\PaypalExpress\Helpers\PaypalExpressHelper();
if (Config::get('vividstore.paypalExpressMode') == 'test') {
$type = 'sandbox';
} else {
$type = 'live';
}
$conf = ['type' => $type];
$paypal->setConfig($conf);
if ($paypal->validateIPN()) {
if (Config::get('vividstore.paypalExpressTransactionType') == "Authorization") {
$status_message = strtolower($_REQUEST['auth_status']);
} else {
$status_message = strtolower($_REQUEST['payment_status']);
}
if ($status_message == 'completed') {
$status = OrderStatus::getByHandle('complete');
} elseif ($status_message == 'denied' || $status_message == 'reversed') {
$status = OrderStatus::getByHandle('complete');
}
$crypt = Loader::helper('encryption');
$invoice = $crypt->decrypt($_REQUEST['invoice']);
$oID = Invoice::getOrderID($invoice);
$order = Order::getById($oID);
if ($order) {
$order->updateStatus($status);
}
}
}
public function order($oID)
{
$order = VividOrder::getByID($oID);
$this->set("order", $order);
$this->set('orderStatuses', OrderStatus::getList());
$pkg = Package::getByHandle('vivid_store');
$packagePath = $pkg->getRelativePath();
$this->addFooterItem(Core::make('helper/html')->javascript($packagePath . '/js/vividStoreFunctions.js'));
}
public static function addOrderStatusesToDatabase(Package $package)
{
$table = OrderStatus::getTableName();
$db = Database::get();
$statuses = array(array('osHandle' => 'incomplete', 'osName' => t('Incomplete'), 'osInformSite' => 1, 'osInformCustomer' => 0, 'osIsStartingStatus' => 0), array('osHandle' => 'pending', 'osName' => t('Pending'), 'osInformSite' => 1, 'osInformCustomer' => 1, 'osIsStartingStatus' => 1), array('osHandle' => 'processing', 'osName' => t('Processing'), 'osInformSite' => 1, 'osInformCustomer' => 1, 'osIsStartingStatus' => 0), array('osHandle' => 'shipped', 'osName' => t('Shipped'), 'osInformSite' => 1, 'osInformCustomer' => 1, 'osIsStartingStatus' => 0), array('osHandle' => 'complete', 'osName' => t('Complete'), 'osInformSite' => 1, 'osInformCustomer' => 1, 'osIsStartingStatus' => 0));
foreach ($statuses as $status) {
$row = $db->GetRow("SELECT * FROM " . $table . " WHERE osHandle=?", array($status['osHandle']));
if (!isset($row['osHandle'])) {
OrderStatus::add($status['osHandle'], $status['osName'], $status['osInformSite'], $status['osInformCustomer'], $status['osIsStartingStatus']);
} else {
$orderStatus = OrderStatus::getByID($row['osID']);
$orderStatus->update($status, true);
}
}
}
private function saveOrderStatuses($data)
{
if (isset($data['osID'])) {
foreach ($data['osID'] as $key => $id) {
$orderStatus = OrderStatus::getByID($id);
$orderStatusSettings = array('osName' => isset($data['osName'][$key]) && $data['osName'][$key] != '' ? $data['osName'][$key] : $orderStatus->getReadableHandle(), 'osInformSite' => isset($data['osInformSite'][$key]) ? 1 : 0, 'osInformCustomer' => isset($data['osInformCustomer'][$key]) ? 1 : 0, 'osSortOrder' => $key);
$orderStatus->update($orderStatusSettings);
}
if (isset($data['osIsStartingStatus'])) {
OrderStatus::setNewStartingStatus(OrderStatus::getByID($data['osIsStartingStatus'])->getHandle());
} else {
$orderStatuses = OrderStatus::getAll();
OrderStatus::setNewStartingStatus($orderStatuses[0]->getHandle());
}
}
}
public function add($data, $pm, $status = null)
{
$taxBased = Config::get('vividstore.taxBased');
$taxlabel = Config::get('vividstore.taxName');
$this->set('taxlabel', $taxlabel);
$taxCalc = Config::get('vividstore.calculation');
$db = Database::get();
//get who ordered it
$customer = new Customer();
//what time is it?
$dt = Core::make('helper/date');
$now = $dt->getLocalDateTime();
//get the price details
$shipping = VividCart::getShippingTotal();
$shipping = Price::formatFloat($shipping);
$taxvalue = VividCart::getTaxTotal();
$taxName = Config::get('vividstore.taxName');
$total = VividCart::getTotal();
$total = Price::formatFloat($total);
$tax = 0;
$taxIncluded = 0;
if ($taxCalc == 'extract') {
$taxIncluded = $taxvalue;
} else {
$tax = $taxvalue;
}
$tax = Price::formatFloat($tax);
//get payment method
$pmID = $pm->getPaymentMethodID();
//add the order
$vals = array($customer->getUserID(), $now, $pmID, $shipping, $tax, $taxIncluded, $taxName, $total);
$db->Execute("INSERT INTO VividStoreOrders(cID,oDate,pmID,oShippingTotal,oTax,oTaxIncluded,oTaxName,oTotal) VALUES (?,?,?,?,?,?,?,?)", $vals);
$oID = $db->lastInsertId();
$order = Order::getByID($oID);
if ($status) {
$order->updateStatus($status);
} else {
$order->updateStatus(OrderStatus::getStartingStatus()->getHandle());
}
$order->setAttribute("email", $customer->getEmail());
$order->setAttribute("billing_first_name", $customer->getValue("billing_first_name"));
$order->setAttribute("billing_last_name", $customer->getValue("billing_last_name"));
$order->setAttribute("billing_address", $customer->getValueArray("billing_address"));
$order->setAttribute("billing_phone", $customer->getValue("billing_phone"));
$order->setAttribute("shipping_first_name", $customer->getValue("shipping_first_name"));
$order->setAttribute("shipping_last_name", $customer->getValue("shipping_last_name"));
$order->setAttribute("shipping_address", $customer->getValueArray("shipping_address"));
$customer->setLastOrderID($oID);
//add the order items
$cart = VividCart::getCart();
foreach ($cart as $cartItem) {
$taxvalue = VividCart::getTaxProduct($cartItem['product']['pID']);
$tax = 0;
$taxIncluded = 0;
if ($taxCalc == 'extract') {
$taxIncluded = $taxvalue;
} else {
$tax = $taxvalue;
}
$productTaxName = $taxName;
if ($taxvalue == 0) {
$productTaxName = '';
}
OrderItem::add($cartItem, $oID, $tax, $taxIncluded, $productTaxName);
$product = VividProduct::getByID($cartItem['product']['pID']);
if ($product && $product->hasUserGroups()) {
$usergroupstoadd = $product->getProductUserGroups();
foreach ($usergroupstoadd as $id) {
$g = Group::getByID($id);
if ($g) {
$customer->getUserInfo()->enterGroup($g);
}
}
}
}
if (!$customer->isGuest()) {
//add user to Store Customers group
$group = \Group::getByName('Store Customer');
if (is_object($group) || $group->getGroupID() < 1) {
$customer->getUserInfo()->enterGroup($group);
}
}
// create order event and dispatch
$event = new OrderEvent($order);
Events::dispatch('on_vividstore_order', $event);
//send out the alerts
$mh = new MailService();
$pkg = Package::getByHandle('vivid_store');
$fromEmail = Config::get('vividstore.emailalerts');
if (!$fromEmail) {
$fromEmail = "store@" . $_SERVER['SERVER_NAME'];
}
$alertEmails = explode(",", Config::get('vividstore.notificationemails'));
$alertEmails = array_map('trim', $alertEmails);
//receipt
$mh->from($fromEmail);
$mh->to($customer->getEmail());
$mh->addParameter("order", $order);
$mh->addParameter("taxbased", $taxBased);
$mh->addParameter("taxlabel", $taxlabel);
$mh->load("order_receipt", "vivid_store");
$mh->sendMail();
//order notification
$mh->from($fromEmail);
foreach ($alertEmails as $alertEmail) {
$mh->to($alertEmail);
}
$mh->addParameter("order", $order);
$mh->addParameter("taxbased", $taxBased);
$mh->addParameter("taxlabel", $taxlabel);
$mh->load("new_order_notification", "vivid_store");
$mh->sendMail();
VividCart::clear();
return $order;
}
private static function recordStatusChange(Order $order, $statusHandle)
{
$db = Database::get();
$newOrderStatus = OrderStatus::getByHandle($statusHandle);
$user = new user();
$statusHistorySql = "INSERT INTO " . self::$table . " SET oID=?, oshStatus=?, uID=?";
$statusHistoryValues = array($order->getOrderID(), $newOrderStatus->getHandle(), $user->uID);
$db->Execute($statusHistorySql, $statusHistoryValues);
$updateOrderSql = "UPDATE VividStoreOrders SET oStatus = ? WHERE oID = ?";
$updateOrderValues = array($newOrderStatus->getHandle(), $order->getOrderID());
$db->Execute($updateOrderSql, $updateOrderValues);
return $newOrderStatus->getHandle();
}
public function install()
{
$pkg = parent::install();
OrderStatus::add('canceled', 'Canceled');
PaymentMethod::add('paypal_express', 'Paypal Express', $pkg);
}
public function update($data = array(), $ignoreFilledColumns = false)
{
$orderStatusArray = array('osHandle' => $this->osHandle, 'osName' => $this->osName, 'osInformSite' => $this->osInformSite, 'osInformCustomer' => $this->osInformCustomer, 'osSortOrder' => $this->osSortOrder);
$startingStatusHandle = null;
if (isset($data['osIsStartingStatus'])) {
$startingStatusHandle = $this->osHandle;
}
$orderStatusUpdateColumns = $ignoreFilledColumns ? array_diff($orderStatusArray, $data) : array_merge($orderStatusArray, $data);
unset($orderStatusUpdateColumns['osID']);
if (count($orderStatusUpdateColumns) > 0) {
$columnPhrase = implode('=?, ', array_keys($orderStatusUpdateColumns)) . "=?";
$values = array_values($orderStatusUpdateColumns);
$values[] = $this->osID;
Database::get()->Execute("UPDATE " . self::getTableName() . " SET " . $columnPhrase . " WHERE osID=?", $values);
if ($startingStatusHandle) {
OrderStatus::setNewStartingStatus($startingStatusHandle);
}
return true;
}
return false;
}
public function add($data, $pm, $status = null)
{
$db = Database::get();
//get who ordered it
$customer = new Customer();
//what time is it?
$dt = Core::make('helper/date');
$now = $dt->getLocalDateTime();
//get the price details
$smID = \Session::get('smID');
if ($smID > 0) {
$sm = ShippingMethod::getByID($smID);
$shippingMethodTypeName = $sm->getShippingMethodType()->getShippingMethodTypeName();
$shippingMethodName = $sm->getName();
$smName = $shippingMethodTypeName . ": " . $shippingMethodName;
} else {
$smName = "No Shipping Method";
}
$shipping = VividCart::getShippingTotal();
$taxes = Tax::getTaxes();
$totals = VividCart::getTotals();
$total = $totals['total'];
$taxCalc = Config::get('vividstore.calculation');
$taxTotal = array();
$taxIncludedTotal = array();
$taxLabels = array();
foreach ($taxes as $tax) {
if ($taxCalc == 'extract') {
$taxIncludedTotal[] = $tax['taxamount'];
} else {
$taxTotal[] = $tax['taxamount'];
}
$taxLabels[] = $tax['name'];
}
$taxTotal = implode(',', $taxTotal);
$taxIncludedTotal = implode(',', $taxIncludedTotal);
$taxLabels = implode(',', $taxLabels);
//get payment method
$pmName = $pm->getPaymentMethodName();
//add the order
$vals = array($customer->getUserID(), $now, $pmName, $smName, $shipping, $taxTotal, $taxIncludedTotal, $taxLabels, $total);
$db->Execute("INSERT INTO VividStoreOrders(cID,oDate,pmName,smName,oShippingTotal,oTax,oTaxIncluded,oTaxName,oTotal) VALUES (?,?,?,?,?,?,?,?,?)", $vals);
$oID = $db->lastInsertId();
$order = Order::getByID($oID);
if ($status) {
$order->updateStatus($status);
} else {
$order->updateStatus(OrderStatus::getStartingStatus()->getHandle());
}
$email = $customer->getEmail();
$billing_first_name = $customer->getValue("billing_first_name");
$billing_last_name = $customer->getValue("billing_last_name");
$billing_address = $customer->getValueArray("billing_address");
$billing_phone = $customer->getValue("billing_phone");
$shipping_first_name = $customer->getValue("shipping_first_name");
$shipping_last_name = $customer->getValue("shipping_last_name");
$shipping_address = $customer->getValueArray("shipping_address");
$order->setAttribute("email", $email);
$order->setAttribute("billing_first_name", $billing_first_name);
$order->setAttribute("billing_last_name", $billing_last_name);
$order->setAttribute("billing_address", $billing_address);
$order->setAttribute("billing_phone", $billing_phone);
if ($smID) {
$order->setAttribute("shipping_first_name", $shipping_first_name);
$order->setAttribute("shipping_last_name", $shipping_last_name);
$order->setAttribute("shipping_address", $shipping_address);
}
$customer->setLastOrderID($oID);
//add the order items
$cart = VividCart::getCart();
foreach ($cart as $cartItem) {
$taxes = Tax::getTaxForProduct($cartItem);
$taxProductTotal = array();
$taxProductIncludedTotal = array();
$taxProductLabels = array();
foreach ($taxes as $tax) {
if ($taxCalc == 'extract') {
$taxProductIncludedTotal[] = $tax['taxamount'];
} else {
$taxProductTotal[] = $tax['taxamount'];
}
$taxProductLabels[] = $tax['name'];
}
$taxProductTotal = implode(',', $taxProductTotal);
$taxProductIncludedTotal = implode(',', $taxProductIncludedTotal);
$taxProductLabels = implode(',', $taxProductLabels);
OrderItem::add($cartItem, $oID, $taxProductTotal, $taxProductIncludedTotal, $taxProductLabels);
}
$discounts = VividCart::getDiscounts();
if ($discounts) {
foreach ($discounts as $discount) {
$order->addDiscount($discount, VividCart::getCode());
}
}
//if the payment method is not external, go ahead and complete the order.
if (!$pm->external) {
$order->completeOrder();
}
return $order;
}