/** * Calculates pending order qty to count against available * inventory by searching for Requested or Awaiting Processing orders * Because we have our cart table and our documents table, we have to get both numbers */ public function CalculateReservedInventory() { //Pending orders not yet converted to Invoice $intReservedA = $this->getDbConnection()->createCommand("SELECT SUM(qty) FROM " . CartItem::model()->tableName() . " AS a\n\t\t\t\t\tLEFT JOIN " . Cart::model()->tableName() . " AS b ON a.cart_id=b.id\n\t\t\t\t\tLEFT JOIN " . Document::model()->tableName() . " AS c ON b.document_id=c.id\n\t\t\t\t\tWHERE\n\t\t\t\t\ta.product_id=" . $this->id . " AND b.cart_type=" . CartType::order . "\n\t\t\t\t\tAND (b.status='" . OrderStatus::Requested . "' OR b.status='" . OrderStatus::AwaitingProcessing . "'\n\t\t\t\t\t\tOR b.status='" . OrderStatus::Downloaded . "')\n\t\t\t\t\tAND (c.status IS NULL OR c.status='" . OrderStatus::Requested . "');")->queryScalar(); if (empty($intReservedA)) { $intReservedA = 0; } //Unattached orders (made independently in Lightspeed) $intReservedB = $this->getDbConnection()->createCommand("SELECT SUM(qty) from " . DocumentItem::model()->tableName() . " AS a\n\t\t\t\t\tLEFT JOIN " . Document::model()->tableName() . " AS b ON a.document_id=b.id\n\t\t\t\t\tWHERE\n\t\t\t\t\ta.product_id=" . $this->id . " AND b.order_type=" . CartType::order . "\n\t\t\t\t\tAND cart_id IS NULL AND left(order_str,3)='WO-' AND (b.status='" . OrderStatus::Requested . "');")->queryScalar(); if (empty($intReservedB)) { $intReservedB = 0; } return $intReservedA + $intReservedB; }
/** * Document Flush * * @param string $passkey * @return string */ public function document_flush($passkey) { if (!$this->check_passkey($passkey)) { return self::FAIL_AUTH; } if (_xls_get_conf('DEBUG_RESET', 0) == 1) { Yii::log('Skipped document flush operation due to DEBUG mode', CLogger::LEVEL_WARNING, 'application.' . __CLASS__ . "." . __FUNCTION__); return self::OK; } try { SroRepair::model()->deleteAll(); SroItem::model()->deleteAll(); Sro::model()->deleteAll(); Cart::model()->updateAll(array('document_id' => null)); //We need to make Document items for anything not Invoiced manual to roll back $objCarts = Document::model()->findAll("order_type = :type AND (status=:status1 OR status=:status2 OR status=:status3)", array(':type' => CartType::order, ':status1' => OrderStatus::Requested, ':status2' => OrderStatus::Processed, ':status3' => OrderStatus::PartiallyReceived)); foreach ($objCarts as $objCart) { foreach ($objCart->documentItems as $item) { $item->qty = 0; $item->save(); $item->product->SetAvailableInventory(); $item->delete(); } $objCart->delete(); } //Then delete everytihing else DocumentItem::model()->deleteAll(); Document::model()->deleteAll(); Yii::app()->db->createCommand("alter table " . Document::model()->tableName() . " auto_increment=1;")->execute(); Yii::app()->db->createCommand("alter table " . DocumentItem::model()->tableName() . " auto_increment=1;")->execute(); Yii::app()->db->createCommand("alter table " . Sro::model()->tableName() . " auto_increment=1;")->execute(); Yii::app()->db->createCommand("alter table " . SroItem::model()->tableName() . " auto_increment=1;")->execute(); Yii::app()->db->createCommand("alter table " . SroRepair::model()->tableName() . " auto_increment=1;")->execute(); //We shouldn't have anything in the cart table that's not an original order, so remove the following if they exist //ToDo: this shouldn't be in production because we will have removed Quote lines from _cart during install $objCarts = Cart::model()->findAllByAttributes(array('cart_type' => CartType::quote)); foreach ($objCarts as $objCart) { foreach ($objCart->cartItems as $item) { $item->delete(); } $objCart->delete(); } //ToDo: this shouldn't be in production because we will have removed SRO lines from _cart during install $objCarts = Cart::model()->findAllByAttributes(array('cart_type' => CartType::sro)); foreach ($objCarts as $objCart) { foreach ($objCart->cartItems as $item) { $item->delete(); } $objCart->delete(); } //ToDo: this shouldn't be in production because we will have removed O- from _cart during install //Delete anything here that's just a pure Order from LS from our Cart Table $objCarts = Cart::model()->findAll("cart_type = :type and id_str LIKE 'O-%'", array(':type' => CartType::order)); foreach ($objCarts as $objCart) { foreach ($objCart->cartItems as $item) { $item->delete(); } $objCart->delete(); } //Delete any Web Orders that have been reuploaded from Lightspeed already $objCarts = Cart::model()->findAll("cart_type = :type AND status<>:status1 AND status<>:status2 AND status<>:status3", array(':type' => CartType::order, ':status1' => OrderStatus::AwaitingPayment, ':status2' => OrderStatus::AwaitingProcessing, ':status3' => OrderStatus::Downloaded)); foreach ($objCarts as $objCart) { foreach ($objCart->cartItems as $item) { $item->delete(); } $objCart->delete(); } //Delete any carts older than our timeout that don't have a customer ID attached (since those can always be restored) Cart::GarbageCollect(); } catch (Exception $e) { Yii::log('SOAP ERROR : In flushing document tables ' . $e, 'error', 'application.' . __CLASS__ . "." . __FUNCTION__); return self::UNKNOWN_ERROR; } return self::OK; }