public function postProcess()
{
global $currentIndex, $cookie, $smarty;
$product_ids = Tools::getValue('product_ids');
$group_id = 0;
if ($product_ids) {
$group_id = Tools::getValue('group_id');
$ids = explode(",", $product_ids);
//update previous curated products
$sql = "SELECT group_concat(id_product) FROM vb_product_groups WHERE id_group_type = 1 AND id_group = 1";
$res = Db::getInstance()->ExecuteS($sql);
$productIds = array();
foreach ($res as $row) {
$productIds[] = $row['id_product'];
}
SolrSearch::updateProducts($productIds);
Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute("\r\n\t\t delete from vb_product_groups where id_group_type = 1 and id_group = " . $group_id);
Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute("\r\n\t\t \t\tdelete from ps_category_product where id_category = " . CAT_CURATED);
foreach ($ids as $product_id) {
if (!$product_id) {
continue;
}
Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute("\n\t\t insert into vb_product_groups (id_group_type, id_group, id_product)\n\t\t values (1, " . $group_id . ", " . $product_id . ")\n\t\t ");
Db::getInstance(_PS_USE_SQL_SLAVE_)->Execute("\r\n\t\t \t\tinsert into ps_category_product (id_category, id_product, position)\r\n\t\t \t\tvalues (" . CAT_CURATED . ", " . $product_id . ", 1)\r\n\t\t \t\t");
SolrSearch::updateProduct($product_id);
}
}
//home products
$product_ids = $this->assign_products('curated_products', 'curated_product_ids', 1);
$smarty->assign('productToken', Tools::getAdminToken('AdminCatalog' . (int) Tab::getIdFromClassName('AdminCatalog') . (int) $cookie->id_employee));
}
$specificPrice->update();
} else {
SpecificPrice::deleteByProductId($id_product);
}
} else {
if (round($mrp) > round($newPrice)) {
$specificPrice = new SpecificPrice();
$specificPrice->id_product = $id_product;
$specificPrice->reduction_type = "amount";
$specificPrice->reduction = $mrp - $newPrice;
$specificPrice->from_quantity = 1;
$specificPrice->from = date('Y-m-d H:i:s');
$specificPrice->update();
}
}
SolrSearch::updateProduct($id_product);
$count++;
}
fclose($f);
echo 'Total ' . $count . ' products updated. Thanks for your attention.';
} else {
// error
}
} else {
echo "There was an error uploading the file, please try again!";
}
}
if (Tools::getValue('getAddresses')) {
header("Content-type: text/csv");
header("Cache-Control: no-store, no-cache");
header('Content-Disposition: attachment; filename="addresses-list.csv"');
public function addStockMvt($quantity, $id_reason, $id_product_attribute = NULL, $id_order = NULL, $id_employee = NULL)
{
$stockMvt = new StockMvt();
$stockMvt->id_product = (int) $this->id;
$stockMvt->id_product_attribute = (int) $id_product_attribute;
$stockMvt->id_order = (int) $id_order;
$stockMvt->id_employee = (int) $id_employee;
$stockMvt->quantity = (int) $quantity;
$stockMvt->id_stock_mvt_reason = (int) $id_reason;
$result = $stockMvt->add();
$last_quantity = $this->quantity;
// Increase or decrease current product quantity value
if ($id_reason == 1) {
$this->quantity += abs($quantity);
} else {
if ($id_reason == 2) {
$this->quantity -= abs($quantity);
}
}
Hook::updateQuantity($this, null);
//reindex the updated product
if ($this->quantity < 1 || $last_quantity < 1 && $this->quantity > 0) {
SolrSearch::updateProduct($this->id);
}
return $result;
}
/**
* Manage page processing
*
* @global string $currentIndex Current URL in order to keep current Tab
*/
public function postProcess()
{
global $currentIndex, $cookie;
if (!isset($this->table)) {
return false;
}
// set token
$token = Tools::getValue('token') ? Tools::getValue('token') : $this->token;
// Sub included tab postProcessing
$this->includeSubTab('postProcess', array('status', 'submitAdd1', 'submitDel', 'delete', 'submitFilter', 'submitReset'));
/* Delete object image */
if (isset($_GET['deleteImage'])) {
if (Validate::isLoadedObject($object = $this->loadObject())) {
if ($object->deleteImage()) {
Tools::redirectAdmin($currentIndex . '&add' . $this->table . '&' . $this->identifier . '=' . Tools::getValue($this->identifier) . '&conf=7&token=' . $token);
}
}
$this->_errors[] = Tools::displayError('An error occurred during image deletion (cannot load object).');
} elseif (isset($_GET['delete' . $this->table])) {
if ($this->tabAccess['delete'] === '1') {
if (Validate::isLoadedObject($object = $this->loadObject()) and isset($this->fieldImageSettings)) {
// check if request at least one object with noZeroObject
if (isset($object->noZeroObject) and sizeof(call_user_func(array($this->className, $object->noZeroObject))) <= 1) {
$this->_errors[] = Tools::displayError('You need at least one object.') . ' <b>' . $this->table . '</b><br />' . Tools::displayError('You cannot delete all of the items.');
} else {
if ($this->deleted) {
$object->deleteImage();
$object->deleted = 1;
if ($object->update()) {
Tools::redirectAdmin($currentIndex . '&conf=1&token=' . $token);
}
} elseif ($object->delete()) {
Tools::redirectAdmin($currentIndex . '&conf=1&token=' . $token);
}
$this->_errors[] = Tools::displayError('An error occurred during deletion.');
}
} else {
$this->_errors[] = Tools::displayError('An error occurred while deleting object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif ((isset($_GET['status' . $this->table]) or isset($_GET['status'])) and Tools::getValue($this->identifier)) {
if ($this->tabAccess['edit'] === '1') {
if (Validate::isLoadedObject($object = $this->loadObject())) {
if ($object->toggleStatus()) {
if ($this->table == 'product') {
SolrSearch::updateProduct($object->id);
}
Tools::redirectAdmin($currentIndex . '&conf=5' . (($id_category = (int) Tools::getValue('id_category') and Tools::getValue('id_product')) ? '&id_category=' . $id_category : '') . '&token=' . $token);
} else {
$this->_errors[] = Tools::displayError('An error occurred while updating status.');
}
} else {
$this->_errors[] = Tools::displayError('An error occurred while updating status for object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
} elseif (isset($_GET['position'])) {
if ($this->tabAccess['edit'] !== '1') {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
} elseif (!Validate::isLoadedObject($object = $this->loadObject())) {
$this->_errors[] = Tools::displayError('An error occurred while updating status for object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
} elseif (!$object->updatePosition((int) Tools::getValue('way'), (int) Tools::getValue('position'))) {
$this->_errors[] = Tools::displayError('Failed to update the position.');
} else {
Tools::redirectAdmin($currentIndex . '&' . $this->table . 'Orderby=position&' . $this->table . 'Orderway=asc&conf=5' . (($id_category = (int) Tools::getValue($this->identifier)) ? '&' . $this->identifier . '=' . $id_category : '') . '&token=' . $token);
}
Tools::redirectAdmin($currentIndex . '&' . $this->table . 'Orderby=position&' . $this->table . 'Orderway=asc&conf=5' . (($id_category = (int) Tools::getValue('id_category') and Tools::getValue('id_product')) ? '&id_category=' . $id_category : '') . '&token=' . $token);
} elseif (Tools::getValue('submitDel' . $this->table)) {
if ($this->tabAccess['delete'] === '1') {
if (isset($_POST[$this->table . 'Box'])) {
$object = new $this->className();
if (isset($object->noZeroObject) and (sizeof(call_user_func(array($this->className, $object->noZeroObject))) <= 1 or sizeof($_POST[$this->table . 'Box']) == sizeof(call_user_func(array($this->className, $object->noZeroObject))))) {
$this->_errors[] = Tools::displayError('You need at least one object.') . ' <b>' . $this->table . '</b><br />' . Tools::displayError('You cannot delete all of the items.');
} else {
$result = true;
if ($this->deleted) {
foreach (Tools::getValue($this->table . 'Box') as $id) {
$toDelete = new $this->className($id);
$toDelete->deleted = 1;
$result = $result and $toDelete->update();
}
} else {
$result = $object->deleteSelection(Tools::getValue($this->table . 'Box'));
}
if ($result) {
Tools::redirectAdmin($currentIndex . '&conf=2&token=' . $token);
}
$this->_errors[] = Tools::displayError('An error occurred while deleting selection.');
}
} else {
$this->_errors[] = Tools::displayError('You must select at least one element to delete.');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif (Tools::getValue('submitAdd' . $this->table)) {
/* Checking fields validity */
$this->validateRules();
if (!sizeof($this->_errors)) {
$id = (int) Tools::getValue($this->identifier);
/* Object update */
if (isset($id) and !empty($id)) {
if ($this->tabAccess['edit'] === '1' or $this->table == 'employee' and $cookie->id_employee == Tools::getValue('id_employee') and Tools::isSubmit('updateemployee')) {
$object = new $this->className($id);
if (Validate::isLoadedObject($object)) {
/* Specific to objects which must not be deleted */
if ($this->deleted and $this->beforeDelete($object)) {
// Create new one with old objet values
$objectNew = new $this->className($object->id);
$objectNew->id = NULL;
$objectNew->date_add = '';
$objectNew->date_upd = '';
// Update old object to deleted
$object->deleted = 1;
$object->update();
// Update new object with post values
$this->copyFromPost($objectNew, $this->table);
$result = $objectNew->add();
if (Validate::isLoadedObject($objectNew)) {
$this->afterDelete($objectNew, $object->id);
}
} else {
$this->copyFromPost($object, $this->table);
$result = $object->update();
$this->afterUpdate($object);
}
if (!$result) {
$this->_errors[] = Tools::displayError('An error occurred while updating object.') . ' <b>' . $this->table . '</b> (' . Db::getInstance()->getMsgError() . ')';
} elseif ($this->postImage($object->id) and !sizeof($this->_errors)) {
$parent_id = (int) Tools::getValue('id_parent', 1);
// Specific back redirect
if ($back = Tools::getValue('back')) {
Tools::redirectAdmin(urldecode($back) . '&conf=4');
}
// Specific scene feature
if (Tools::getValue('stay_here') == 'on' || Tools::getValue('stay_here') == 'true' || Tools::getValue('stay_here') == '1') {
Tools::redirectAdmin($currentIndex . '&' . $this->identifier . '=' . $object->id . '&conf=4&updatescene&token=' . $token);
}
// Save and stay on same form
if (Tools::isSubmit('submitAdd' . $this->table . 'AndStay')) {
Tools::redirectAdmin($currentIndex . '&' . $this->identifier . '=' . $object->id . '&conf=4&update' . $this->table . '&token=' . $token);
}
// Save and back to parent
if (Tools::isSubmit('submitAdd' . $this->table . 'AndBackToParent')) {
Tools::redirectAdmin($currentIndex . '&' . $this->identifier . '=' . $parent_id . '&conf=4&token=' . $token);
}
// Default behavior (save and back)
Tools::redirectAdmin($currentIndex . ($parent_id ? '&' . $this->identifier . '=' . $object->id : '') . '&conf=4&token=' . $token);
}
} else {
$this->_errors[] = Tools::displayError('An error occurred while updating object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
} else {
if ($this->tabAccess['add'] === '1') {
$object = new $this->className();
$this->copyFromPost($object, $this->table);
if (!$object->add()) {
$this->_errors[] = Tools::displayError('An error occurred while creating object.') . ' <b>' . $this->table . ' (' . mysql_error() . ')</b>';
} elseif ($_POST[$this->identifier] = $object->id and $this->postImage($object->id) and !sizeof($this->_errors) and $this->_redirect) {
$parent_id = (int) Tools::getValue('id_parent', 1);
$this->afterAdd($object);
// Save and stay on same form
if (Tools::isSubmit('submitAdd' . $this->table . 'AndStay')) {
Tools::redirectAdmin($currentIndex . '&' . $this->identifier . '=' . $object->id . '&conf=3&update' . $this->table . '&token=' . $token);
}
// Save and back to parent
if (Tools::isSubmit('submitAdd' . $this->table . 'AndBackToParent')) {
Tools::redirectAdmin($currentIndex . '&' . $this->identifier . '=' . $parent_id . '&conf=3&token=' . $token);
}
// Default behavior (save and back)
Tools::redirectAdmin($currentIndex . ($parent_id ? '&' . $this->identifier . '=' . $object->id : '') . '&conf=3&token=' . $token);
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
}
}
$this->_errors = array_unique($this->_errors);
} elseif (isset($_POST['submitReset' . $this->table])) {
$filters = $cookie->getFamily($this->table . 'Filter_');
foreach ($filters as $cookieKey => $filter) {
if (strncmp($cookieKey, $this->table . 'Filter_', 7 + Tools::strlen($this->table)) == 0) {
$key = substr($cookieKey, 7 + Tools::strlen($this->table));
/* Table alias could be specified using a ! eg. alias!field */
$tmpTab = explode('!', $key);
$key = count($tmpTab) > 1 ? $tmpTab[1] : $tmpTab[0];
if (array_key_exists($key, $this->fieldsDisplay)) {
unset($cookie->{$cookieKey});
}
}
}
if (isset($cookie->{'submitFilter' . $this->table})) {
unset($cookie->{'submitFilter' . $this->table});
}
if (isset($cookie->{$this->table . 'Orderby'})) {
unset($cookie->{$this->table . 'Orderby'});
}
if (isset($cookie->{$this->table . 'Orderway'})) {
unset($cookie->{$this->table . 'Orderway'});
}
unset($_POST);
} elseif (Tools::getValue('submitOptions' . $this->table)) {
$this->updateOptions($token);
} elseif (Tools::isSubmit('submitFilter' . $this->table) or $cookie->{'submitFilter' . $this->table} !== false) {
$_POST = array_merge($cookie->getFamily($this->table . 'Filter_'), isset($_POST) ? $_POST : array());
foreach ($_POST as $key => $value) {
/* Extracting filters from $_POST on key filter_ */
if ($value != NULL and !strncmp($key, $this->table . 'Filter_', 7 + Tools::strlen($this->table))) {
$key = Tools::substr($key, 7 + Tools::strlen($this->table));
/* Table alias could be specified using a ! eg. alias!field */
$tmpTab = explode('!', $key);
$filter = count($tmpTab) > 1 ? $tmpTab[1] : $tmpTab[0];
if ($field = $this->filterToField($key, $filter)) {
$type = array_key_exists('filter_type', $field) ? $field['filter_type'] : (array_key_exists('type', $field) ? $field['type'] : false);
if (($type == 'date' or $type == 'datetime') and is_string($value)) {
$value = unserialize($value);
}
$key = isset($tmpTab[1]) ? $tmpTab[0] . '.`' . $tmpTab[1] . '`' : '`' . $tmpTab[0] . '`';
if (array_key_exists('tmpTableFilter', $field)) {
$sqlFilter =& $this->_tmpTableFilter;
} elseif (array_key_exists('havingFilter', $field)) {
$sqlFilter =& $this->_filterHaving;
} else {
$sqlFilter =& $this->_filter;
}
/* Only for date filtering (from, to) */
if (is_array($value)) {
if (isset($value[0]) and !empty($value[0])) {
if (!Validate::isDate($value[0])) {
$this->_errors[] = Tools::displayError('\'from:\' date format is invalid (YYYY-MM-DD)');
} else {
$sqlFilter .= ' AND ' . pSQL($key) . ' >= \'' . pSQL(Tools::dateFrom($value[0])) . '\'';
}
}
if (isset($value[1]) and !empty($value[1])) {
if (!Validate::isDate($value[1])) {
$this->_errors[] = Tools::displayError('\'to:\' date format is invalid (YYYY-MM-DD)');
} else {
$sqlFilter .= ' AND ' . pSQL($key) . ' <= \'' . pSQL(Tools::dateTo($value[1])) . '\'';
}
}
} else {
$sqlFilter .= ' AND ';
if ($type == 'int' or $type == 'bool') {
$sqlFilter .= (($key == $this->identifier or $key == '`' . $this->identifier . '`' or $key == '`active`') ? 'a.' : '') . pSQL($key) . ' = ' . (int) $value . ' ';
} elseif ($type == 'decimal') {
$sqlFilter .= (($key == $this->identifier or $key == '`' . $this->identifier . '`') ? 'a.' : '') . pSQL($key) . ' = ' . (double) $value . ' ';
} elseif ($type == 'select') {
$sqlFilter .= (($key == $this->identifier or $key == '`' . $this->identifier . '`') ? 'a.' : '') . pSQL($key) . ' = \'' . pSQL($value) . '\' ';
} else {
$sqlFilter .= (($key == $this->identifier or $key == '`' . $this->identifier . '`') ? 'a.' : '') . pSQL($key) . ' LIKE \'%' . pSQL($value) . '%\' ';
}
}
}
}
}
} elseif (Tools::isSubmit('submitFields') and $this->requiredDatabase and $this->tabAccess['add'] === '1' and $this->tabAccess['delete'] === '1') {
if (!is_array($fields = Tools::getValue('fieldsBox'))) {
$fields = array();
}
$object = new $this->className();
if (!$object->addFieldsRequiredDatabase($fields)) {
$this->_errors[] = Tools::displayError('Error in updating required fields');
} else {
Tools::redirectAdmin($currentIndex . '&conf=4&token=' . $token);
}
}
}
/**
* postProcess handle every checks before saving products information
*
* @param mixed $token
* @return void
*/
public function postProcess($token = NULL)
{
global $cookie, $currentIndex;
/* Add a new product */
if (Tools::isSubmit('submitAddproduct') or Tools::isSubmit('submitAddproductAndStay') or Tools::isSubmit('submitAddProductAndPreview')) {
if (Tools::getValue('id_product') and $this->tabAccess['edit'] === '1' or $this->tabAccess['add'] === '1' and !Tools::isSubmit('id_product')) {
$this->submitAddproduct($token);
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
}
/* Delete a product in the download folder */
if (Tools::getValue('deleteVirtualProduct')) {
if ($this->tabAccess['delete'] === '1') {
$this->deleteVirtualProduct();
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif (Tools::isSubmit('submitAddAttachments')) {
if ($this->tabAccess['add'] === '1') {
$languages = Language::getLanguages(false);
$is_attachment_name_valid = false;
foreach ($languages as $language) {
$attachment_name_lang = Tools::getValue('attachment_name_' . (int) $language['id_lang']);
if (strlen($attachment_name_lang) > 0) {
$is_attachment_name_valid = true;
}
if (!Validate::isGenericName(Tools::getValue('attachment_name_' . (int) $language['id_lang']))) {
$this->_errors[] = Tools::displayError('Invalid Name');
} elseif (Tools::strlen(Tools::getValue('attachment_name_' . (int) $language['id_lang'])) > 32) {
$this->_errors[] = Tools::displayError('Name is too long');
}
if (!Validate::isCleanHtml(Tools::getValue('attachment_description_' . (int) $language['id_lang']))) {
$this->_errors[] = Tools::displayError('Invalid description');
}
}
if (!$is_attachment_name_valid) {
$this->_errors[] = Tools::displayError('Attachment Name Required');
}
if (empty($this->_errors)) {
if (isset($_FILES['attachment_file']) and is_uploaded_file($_FILES['attachment_file']['tmp_name'])) {
if ($_FILES['attachment_file']['size'] > Configuration::get('PS_ATTACHMENT_MAXIMUM_SIZE') * 1024 * 1024) {
$this->_errors[] = $this->l('File too large, maximum size allowed:') . ' ' . Configuration::get('PS_ATTACHMENT_MAXIMUM_SIZE') * 1024 . ' ' . $this->l('kb') . '. ' . $this->l('File size you\'re trying to upload is:') . number_format($_FILES['attachment_file']['size'] / 1024, 2, '.', '') . $this->l('kb');
} else {
do {
$uniqid = sha1(microtime());
} while (file_exists(_PS_DOWNLOAD_DIR_ . $uniqid));
if (!copy($_FILES['attachment_file']['tmp_name'], _PS_DOWNLOAD_DIR_ . $uniqid)) {
$this->_errors[] = $this->l('File copy failed');
}
@unlink($_FILES['attachment_file']['tmp_name']);
}
} else {
if ((int) $_FILES['attachment_file']['error'] === 1) {
$max_upload = (int) ini_get('upload_max_filesize');
$max_post = (int) ini_get('post_max_size');
$upload_mb = min($max_upload, $max_post);
$this->_errors[] = $this->l('the File') . ' <b>' . $_FILES['attachment_file']['name'] . '</b> ' . $this->l('exceeds the size allowed by the server, this limit is set to') . ' <b>' . $upload_mb . $this->l('Mb') . '</b>';
}
}
if (empty($this->_errors) && isset($uniqid)) {
$attachment = new Attachment();
foreach ($languages as $language) {
if (isset($_POST['attachment_name_' . (int) $language['id_lang']])) {
$attachment->name[(int) $language['id_lang']] = pSQL($_POST['attachment_name_' . (int) $language['id_lang']]);
}
if (isset($_POST['attachment_description_' . (int) $language['id_lang']])) {
$attachment->description[(int) $language['id_lang']] = pSQL($_POST['attachment_description_' . (int) $language['id_lang']]);
}
}
$attachment->file = $uniqid;
$attachment->mime = $_FILES['attachment_file']['type'];
$attachment->file_name = pSQL($_FILES['attachment_file']['name']);
if (empty($attachment->mime) or Tools::strlen($attachment->mime) > 64) {
$this->_errors[] = Tools::displayError('Invalid file extension');
}
if (!Validate::isGenericName($attachment->file_name)) {
$this->_errors[] = Tools::displayError('Invalid file name');
}
if (Tools::strlen($attachment->file_name) > 128) {
$this->_errors[] = Tools::displayError('File name too long');
}
if (!sizeof($this->_errors)) {
$attachment->add();
Tools::redirectAdmin($currentIndex . '&id_product=' . (int) Tools::getValue($this->identifier) . '&id_category=' . (int) Tools::getValue('id_category') . '&addproduct&conf=4&tabs=6&token=' . ($token ? $token : $this->token));
} else {
$this->_errors[] = Tools::displayError('Invalid file');
}
}
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
} elseif (Tools::isSubmit('submitAttachments')) {
if ($this->tabAccess['edit'] === '1') {
if ($id = (int) Tools::getValue($this->identifier)) {
if (Attachment::attachToProduct($id, $_POST['attachments'])) {
Tools::redirectAdmin($currentIndex . '&id_product=' . (int) $id . (isset($_POST['id_category']) ? '&id_category=' . (int) $_POST['id_category'] : '') . '&conf=4&add' . $this->table . '&tabs=6&token=' . ($token ? $token : $this->token));
}
}
}
} elseif (isset($_GET['duplicate' . $this->table])) {
if ($this->tabAccess['add'] === '1') {
if (Validate::isLoadedObject($product = new Product((int) Tools::getValue('id_product')))) {
$id_product_old = $product->id;
unset($product->id);
unset($product->id_product);
$product->indexed = 0;
$product->active = 0;
if ($product->add() and Category::duplicateProductCategories($id_product_old, $product->id) and ($combinationImages = Product::duplicateAttributes($id_product_old, $product->id)) !== false and Product::duplicateAccessories($id_product_old, $product->id) and Product::duplicateFeatures($id_product_old, $product->id) and Product::duplicateSpecificPrices($id_product_old, $product->id) and Pack::duplicate($id_product_old, $product->id) and Product::duplicateCustomizationFields($id_product_old, $product->id) and Product::duplicateTags($id_product_old, $product->id) and Product::duplicateDownload($id_product_old, $product->id)) {
if ($product->hasAttributes()) {
Product::updateDefaultAttribute($product->id);
}
if (!Tools::getValue('noimage') and !Image::duplicateProductImages($id_product_old, $product->id, $combinationImages)) {
$this->_errors[] = Tools::displayError('An error occurred while copying images.');
} else {
Hook::addProduct($product);
Search::indexation(false);
Tools::redirectAdmin($currentIndex . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&conf=19&token=' . ($token ? $token : $this->token));
}
} else {
$this->_errors[] = Tools::displayError('An error occurred while creating object.');
}
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
} elseif (isset($_GET['status']) and Tools::getValue($this->identifier)) {
if ($this->tabAccess['edit'] === '1') {
if (Validate::isLoadedObject($object = $this->loadObject())) {
SolrSearch::updateProduct($object->id);
if ($object->toggleStatus()) {
Tools::redirectAdmin($currentIndex . '&conf=5' . (($id_category = !empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1' and Tools::getValue('id_product')) ? '&id_category=' . $id_category : '') . '&token=' . $token);
} else {
$this->_errors[] = Tools::displayError('An error occurred while updating status.');
}
} else {
$this->_errors[] = Tools::displayError('An error occurred while updating status for object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
} elseif (isset($_GET['delete' . $this->table])) {
if ($this->tabAccess['delete'] === '1') {
if (Validate::isLoadedObject($object = $this->loadObject()) and isset($this->fieldImageSettings)) {
// check if request at least one object with noZeroObject
if (isset($object->noZeroObject) and sizeof($taxes = call_user_func(array($this->className, $object->noZeroObject))) <= 1) {
$this->_errors[] = Tools::displayError('You need at least one object.') . ' <b>' . $this->table . '</b><br />' . Tools::displayError('You cannot delete all of the items.');
} else {
$id_category = Tools::getValue('id_category');
$category_url = empty($id_category) ? '' : '&id_category=' . $id_category;
if ($this->deleted) {
$object->deleteImages();
$object->deleted = 1;
if ($object->update()) {
SolrSearch::updateProduct($object->id);
Tools::redirectAdmin($currentIndex . '&conf=1&token=' . ($token ? $token : $this->token) . $category_url);
}
} elseif ($object->delete()) {
SolrSearch::updateProduct($object->id);
Tools::redirectAdmin($currentIndex . '&conf=1&token=' . ($token ? $token : $this->token) . $category_url);
}
$this->_errors[] = Tools::displayError('An error occurred during deletion.');
}
} else {
$this->_errors[] = Tools::displayError('An error occurred while deleting object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif (Tools::getValue('submitDel' . $this->table)) {
if ($this->tabAccess['delete'] === '1') {
if (isset($_POST[$this->table . 'Box'])) {
$object = new $this->className();
if (isset($object->noZeroObject) and (sizeof(call_user_func(array($this->className, $object->noZeroObject))) <= 1 or sizeof($_POST[$this->table . 'Box']) == sizeof(call_user_func(array($this->className, $object->noZeroObject))))) {
$this->_errors[] = Tools::displayError('You need at least one object.') . ' <b>' . $this->table . '</b><br />' . Tools::displayError('You cannot delete all of the items.');
} else {
$result = true;
if ($this->deleted) {
$idsToUpdate = array();
foreach (Tools::getValue($this->table . 'Box') as $id) {
$toDelete = new $this->className($id);
$toDelete->deleted = 1;
$result = $result and $toDelete->update();
$idsToUpdate[] = $id;
}
SolrSearch::updateProducts($idsToUpdate);
} else {
$result = $object->deleteSelection(Tools::getValue($this->table . 'Box'));
SolrSearch::updateProducts(Tools::getValue($this->table . 'Box'));
}
if ($result) {
$id_category = Tools::getValue('id_category');
$category_url = empty($id_category) ? '' : '&id_category=' . $id_category;
Tools::redirectAdmin($currentIndex . '&conf=2&token=' . $token . $category_url);
}
$this->_errors[] = Tools::displayError('An error occurred while deleting selection.');
}
} else {
$this->_errors[] = Tools::displayError('You must select at least one element to delete.');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif ($id_image = (int) Tools::getValue('id_image') and Validate::isUnsignedId($id_image) and Validate::isLoadedObject($image = new Image($id_image))) {
if ($this->tabAccess['edit'] === '1') {
/* Delete product image */
if (isset($_GET['deleteImage'])) {
$image->delete();
if (!Image::getCover($image->id_product)) {
$first_img = Db::getInstance()->getRow('
SELECT `id_image` FROM `' . _DB_PREFIX_ . 'image`
WHERE `id_product` = ' . (int) $image->id_product);
Db::getInstance()->Execute('
UPDATE `' . _DB_PREFIX_ . 'image`
SET `cover` = 1
WHERE `id_image` = ' . (int) $first_img['id_image']);
}
@unlink(_PS_TMP_IMG_DIR_ . '/product_' . $image->id_product . '.jpg');
@unlink(_PS_TMP_IMG_DIR_ . '/product_mini_' . $image->id_product . '.jpg');
Tools::redirectAdmin($currentIndex . '&id_product=' . $image->id_product . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&add' . $this->table . '&tabs=1' . '&token=' . ($token ? $token : $this->token));
} elseif (isset($_GET['editImage'])) {
if ($image->cover) {
$_POST['cover'] = 1;
}
$languages = Language::getLanguages(false);
foreach ($languages as $language) {
if (isset($image->legend[$language['id_lang']])) {
$_POST['legend_' . $language['id_lang']] = $image->legend[$language['id_lang']];
}
}
$_POST['id_image'] = $image->id;
$this->displayForm();
} elseif (isset($_GET['coverImage'])) {
Image::deleteCover($image->id_product);
$image->cover = 1;
if (!$image->update()) {
$this->_errors[] = Tools::displayError('Cannot change the product cover');
} else {
$productId = (int) Tools::getValue('id_product');
@unlink(_PS_TMP_IMG_DIR_ . '/product_' . $productId . '.jpg');
@unlink(_PS_TMP_IMG_DIR_ . '/product_mini_' . $productId . '.jpg');
Tools::redirectAdmin($currentIndex . '&id_product=' . $image->id_product . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&addproduct&tabs=1' . '&token=' . ($token ? $token : $this->token));
}
} elseif (isset($_GET['imgPosition']) and isset($_GET['imgDirection'])) {
$image->positionImage((int) Tools::getValue('imgPosition'), (int) Tools::getValue('imgDirection'));
Tools::redirectAdmin($currentIndex . '&id_product=' . $image->id_product . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&add' . $this->table . '&tabs=1&token=' . ($token ? $token : $this->token));
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
} elseif (Tools::isSubmit('submitProductAttribute')) {
if (Validate::isLoadedObject($product = new Product((int) Tools::getValue('id_product')))) {
if (!isset($_POST['attribute_price']) or $_POST['attribute_price'] == NULL) {
$this->_errors[] = Tools::displayError('Attribute price required.');
}
if (!isset($_POST['attribute_combinaison_list']) or !sizeof($_POST['attribute_combinaison_list'])) {
$this->_errors[] = Tools::displayError('You must add at least one attribute.');
}
if (!sizeof($this->_errors)) {
if (!isset($_POST['attribute_wholesale_price'])) {
$_POST['attribute_wholesale_price'] = 0;
}
if (!isset($_POST['attribute_price_impact'])) {
$_POST['attribute_price_impact'] = 0;
}
if (!isset($_POST['attribute_weight_impact'])) {
$_POST['attribute_weight_impact'] = 0;
}
if (!isset($_POST['attribute_ecotax'])) {
$_POST['attribute_ecotax'] = 0;
}
if (Tools::getValue('attribute_default')) {
$product->deleteDefaultAttributes();
}
// Change existing one
if ($id_product_attribute = (int) Tools::getValue('id_product_attribute')) {
if ($this->tabAccess['edit'] === '1') {
if ($product->productAttributeExists($_POST['attribute_combinaison_list'], $id_product_attribute)) {
$this->_errors[] = Tools::displayError('This attribute already exists.');
} else {
$product->updateProductAttribute($id_product_attribute, Tools::getValue('attribute_wholesale_price'), Tools::getValue('attribute_price') * Tools::getValue('attribute_price_impact'), Tools::getValue('attribute_weight') * Tools::getValue('attribute_weight_impact'), Tools::getValue('attribute_unity') * Tools::getValue('attribute_unit_impact'), Tools::getValue('attribute_ecotax'), false, Tools::getValue('id_image_attr'), Tools::getValue('attribute_reference'), Tools::getValue('attribute_supplier_reference'), Tools::getValue('attribute_ean13'), Tools::getValue('attribute_default'), Tools::getValue('attribute_location'), Tools::getValue('attribute_upc'), Tools::getValue('minimal_quantity'));
if ($id_reason = (int) Tools::getValue('id_mvt_reason') and (int) Tools::getValue('attribute_mvt_quantity') > 0 and $id_reason > 0) {
$reason = new StockMvtReason((int) $id_reason);
$qty = Tools::getValue('attribute_mvt_quantity') * $reason->sign;
if (!$product->addStockMvt($qty, $id_reason, (int) $id_product_attribute, NULL, $cookie->id_employee)) {
$this->_errors[] = Tools::displayError('An error occurred while updating qty.');
}
}
Hook::updateProductAttribute((int) $id_product_attribute);
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
} else {
if ($this->tabAccess['add'] === '1') {
if ($product->productAttributeExists($_POST['attribute_combinaison_list'])) {
$this->_errors[] = Tools::displayError('This combination already exists.');
} else {
$id_product_attribute = $product->addCombinationEntity(Tools::getValue('attribute_wholesale_price'), Tools::getValue('attribute_price') * Tools::getValue('attribute_price_impact'), Tools::getValue('attribute_weight') * Tools::getValue('attribute_weight_impact'), Tools::getValue('attribute_unity') * Tools::getValue('attribute_unit_impact'), Tools::getValue('attribute_ecotax'), Tools::getValue('attribute_quantity'), Tools::getValue('id_image_attr'), Tools::getValue('attribute_reference'), Tools::getValue('attribute_supplier_reference'), Tools::getValue('attribute_ean13'), Tools::getValue('attribute_default'), Tools::getValue('attribute_location'), Tools::getValue('attribute_upc'));
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to') . '<hr>' . Tools::displayError('Edit here.');
}
}
if (!sizeof($this->_errors)) {
$product->addAttributeCombinaison($id_product_attribute, Tools::getValue('attribute_combinaison_list'));
$product->checkDefaultAttributes();
}
if (!sizeof($this->_errors)) {
if (!$product->cache_default_attribute) {
Product::updateDefaultAttribute($product->id);
}
Tools::redirectAdmin($currentIndex . '&id_product=' . $product->id . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&add' . $this->table . '&tabs=3&token=' . ($token ? $token : $this->token));
}
}
}
} elseif (Tools::isSubmit('deleteProductAttribute')) {
if ($this->tabAccess['delete'] === '1') {
if ($id_product = (int) Tools::getValue('id_product') and Validate::isUnsignedId($id_product) and Validate::isLoadedObject($product = new Product($id_product))) {
$product->deleteAttributeCombinaison((int) Tools::getValue('id_product_attribute'));
$product->checkDefaultAttributes();
$product->updateQuantityProductWithAttributeQuantity();
if (!$product->hasAttributes()) {
$product->cache_default_attribute = 0;
$product->update();
} else {
Product::updateDefaultAttribute($id_product);
}
Tools::redirectAdmin($currentIndex . '&add' . $this->table . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&tabs=3&id_product=' . $product->id . '&token=' . ($token ? $token : $this->token));
} else {
$this->_errors[] = Tools::displayError('Cannot delete attribute');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif (Tools::isSubmit('deleteAllProductAttributes')) {
if ($this->tabAccess['delete'] === '1') {
if ($id_product = (int) Tools::getValue('id_product') and Validate::isUnsignedId($id_product) and Validate::isLoadedObject($product = new Product($id_product))) {
$product->deleteProductAttributes();
$product->updateQuantityProductWithAttributeQuantity();
if ($product->cache_default_attribute) {
$product->cache_default_attribute = 0;
$product->update();
}
Tools::redirectAdmin($currentIndex . '&add' . $this->table . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&tabs=3&id_product=' . $product->id . '&token=' . ($token ? $token : $this->token));
} else {
$this->_errors[] = Tools::displayError('Cannot delete attributes');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif (Tools::isSubmit('defaultProductAttribute')) {
if (Validate::isLoadedObject($product = new Product((int) Tools::getValue('id_product')))) {
$product->deleteDefaultAttributes();
$product->setDefaultAttribute((int) Tools::getValue('id_product_attribute'));
Tools::redirectAdmin($currentIndex . '&add' . $this->table . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&tabs=3&id_product=' . $product->id . '&token=' . ($token ? $token : $this->token));
} else {
$this->_errors[] = Tools::displayError('Cannot make default attribute');
}
} elseif (Tools::isSubmit('submitProductFeature')) {
if ($this->tabAccess['edit'] === '1') {
if (Validate::isLoadedObject($product = new Product((int) Tools::getValue('id_product')))) {
// delete all objects
$product->deleteFeatures();
// add new objects
$languages = Language::getLanguages(false);
foreach ($_POST as $key => $val) {
if (preg_match('/^feature_([0-9]+)_value/i', $key, $match)) {
if ($val) {
$product->addFeaturesToDB($match[1], $val);
} else {
if ($default_value = $this->checkFeatures($languages, $match[1])) {
$id_value = $product->addFeaturesToDB($match[1], 0, 1, (int) $language['id_lang']);
foreach ($languages as $language) {
if ($cust = Tools::getValue('custom_' . $match[1] . '_' . (int) $language['id_lang'])) {
$product->addFeaturesCustomToDB($id_value, (int) $language['id_lang'], $cust);
} else {
$product->addFeaturesCustomToDB($id_value, (int) $language['id_lang'], $default_value);
}
}
}
}
}
}
if (!sizeof($this->_errors)) {
Tools::redirectAdmin($currentIndex . '&id_product=' . (int) $product->id . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&add' . $this->table . '&tabs=4&conf=4&token=' . ($token ? $token : $this->token));
}
} else {
$this->_errors[] = Tools::displayError('Product must be created before adding features.');
}
}
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
} elseif (Tools::isSubmit('submitPricesModification')) {
$_POST['tabs'] = 5;
if ($this->tabAccess['edit'] === '1') {
$id_specific_prices = Tools::getValue('spm_id_specific_price');
$id_shops = Tools::getValue('spm_id_shop');
$id_currencies = Tools::getValue('spm_id_currency');
$id_countries = Tools::getValue('spm_id_country');
$id_groups = Tools::getValue('spm_id_group');
$prices = Tools::getValue('spm_price');
$from_quantities = Tools::getValue('spm_from_quantity');
$reductions = Tools::getValue('spm_reduction');
$reduction_types = Tools::getValue('spm_reduction_type');
$froms = Tools::getValue('spm_from');
$tos = Tools::getValue('spm_to');
foreach ($id_specific_prices as $key => $id_specific_price) {
if ($this->_validateSpecificPrice($id_shops[$key], $id_currencies[$key], $id_countries[$key], $id_groups[$key], $prices[$key], $from_quantities[$key], $reductions[$key], $reduction_types[$key], $froms[$key], $tos[$key])) {
$specificPrice = new SpecificPrice((int) $id_specific_price);
$specificPrice->id_shop = (int) $id_shops[$key];
$specificPrice->id_currency = (int) $id_currencies[$key];
$specificPrice->id_country = (int) $id_countries[$key];
$specificPrice->id_group = (int) $id_groups[$key];
$specificPrice->price = (double) $prices[$key];
$specificPrice->from_quantity = (int) $from_quantities[$key];
$specificPrice->reduction = (double) ($reduction_types[$key] == 'percentage' ? $reductions[$key] / 100 : $reductions[$key]);
$specificPrice->reduction_type = !$reductions[$key] ? 'amount' : $reduction_types[$key];
$specificPrice->from = !$froms[$key] ? '0000-00-00 00:00:00' : $froms[$key];
$specificPrice->to = !$tos[$key] ? '0000-00-00 00:00:00' : $tos[$key];
if (!$specificPrice->update()) {
$this->_errors = Tools::displayError('An error occurred while updating the specific price.');
}
}
}
if (!sizeof($this->_errors)) {
Tools::redirectAdmin($currentIndex . '&id_product=' . (int) Tools::getValue('id_product') . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&update' . $this->table . '&tabs=2&token=' . ($token ? $token : $this->token));
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
} elseif (Tools::isSubmit('submitPriceAddition')) {
if ($this->tabAccess['add'] === '1') {
$id_product = (int) Tools::getValue('id_product');
$id_shop = Tools::getValue('sp_id_shop');
$id_currency = Tools::getValue('sp_id_currency');
$id_country = Tools::getValue('sp_id_country');
$id_group = Tools::getValue('sp_id_group');
$price = Tools::getValue('sp_price');
$from_quantity = Tools::getValue('sp_from_quantity');
$reduction = (double) Tools::getValue('sp_reduction');
$reduction_type = !$reduction ? 'amount' : Tools::getValue('sp_reduction_type');
$from = Tools::getValue('sp_from');
$to = Tools::getValue('sp_to');
if ($this->_validateSpecificPrice($id_shop, $id_currency, $id_country, $id_group, $price, $from_quantity, $reduction, $reduction_type, $from, $to)) {
$specificPrice = new SpecificPrice();
$specificPrice->id_product = $id_product;
$specificPrice->id_shop = (int) $id_shop;
$specificPrice->id_currency = (int) $id_currency;
$specificPrice->id_country = (int) $id_country;
$specificPrice->id_group = (int) $id_group;
$specificPrice->price = (double) $price;
$specificPrice->from_quantity = (int) $from_quantity;
$specificPrice->reduction = (double) ($reduction_type == 'percentage' ? $reduction / 100 : $reduction);
$specificPrice->reduction_type = $reduction_type;
$specificPrice->from = !$from ? '0000-00-00 00:00:00' : $from;
$specificPrice->to = !$to ? '0000-00-00 00:00:00' : $to;
if (!$specificPrice->add()) {
$this->_errors = Tools::displayError('An error occurred while updating the specific price.');
} else {
Tools::redirectAdmin($currentIndex . '&id_product=' . $id_product . '&add' . $this->table . '&tabs=2&conf=3&token=' . ($token ? $token : $this->token));
}
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to add here.');
}
} elseif (Tools::isSubmit('deleteSpecificPrice')) {
if ($this->tabAccess['delete'] === '1') {
if (!($obj = $this->loadObject())) {
return;
}
if (!($id_specific_price = Tools::getValue('id_specific_price')) or !Validate::isUnsignedId($id_specific_price)) {
$this->_errors[] = Tools::displayError('Invalid specific price ID');
} else {
$specificPrice = new SpecificPrice((int) $id_specific_price);
if (!$specificPrice->delete()) {
$this->_errors[] = Tools::displayError('An error occurred while deleting the specific price');
} else {
Tools::redirectAdmin($currentIndex . '&id_product=' . $obj->id . '&add' . $this->table . '&tabs=2&conf=1&token=' . ($token ? $token : $this->token));
}
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to delete here.');
}
} elseif (Tools::isSubmit('submitSpecificPricePriorities')) {
if (!($obj = $this->loadObject())) {
return;
}
if (!($priorities = Tools::getValue('specificPricePriority'))) {
$this->_errors[] = Tools::displayError('Please specify priorities');
} elseif (Tools::isSubmit('specificPricePriorityToAll')) {
if (!SpecificPrice::setPriorities($priorities)) {
$this->_errors[] = Tools::displayError('An error occurred while updating priorities.');
} else {
Tools::redirectAdmin($currentIndex . '&id_product=' . $obj->id . '&add' . $this->table . '&tabs=2&conf=4&token=' . ($token ? $token : $this->token));
}
} elseif (!SpecificPrice::setSpecificPriority((int) $obj->id, $priorities)) {
$this->_errors[] = Tools::displayError('An error occurred while setting priorities.');
} else {
Tools::redirectAdmin($currentIndex . '&id_product=' . $obj->id . '&add' . $this->table . '&tabs=2&conf=4&token=' . ($token ? $token : $this->token));
}
} elseif (Tools::isSubmit('submitCustomizationConfiguration')) {
if ($this->tabAccess['edit'] === '1') {
if (Validate::isLoadedObject($product = new Product((int) Tools::getValue('id_product')))) {
if (!$product->createLabels((int) $_POST['uploadable_files'] - (int) $product->uploadable_files, (int) $_POST['text_fields'] - (int) $product->text_fields)) {
$this->_errors[] = Tools::displayError('An error occurred while creating customization fields.');
}
if (!sizeof($this->_errors) and !$product->updateLabels()) {
$this->_errors[] = Tools::displayError('An error occurred while updating customization.');
}
$product->uploadable_files = (int) $_POST['uploadable_files'];
$product->text_fields = (int) $_POST['text_fields'];
$product->customizable = ((int) $_POST['uploadable_files'] > 0 or (int) $_POST['text_fields'] > 0) ? 1 : 0;
if (!sizeof($this->_errors) and !$product->update()) {
$this->_errors[] = Tools::displayError('An error occurred while updating customization configuration.');
}
if (!sizeof($this->_errors)) {
Tools::redirectAdmin($currentIndex . '&id_product=' . $product->id . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&add' . $this->table . '&tabs=5&token=' . ($token ? $token : $this->token));
}
} else {
$this->_errors[] = Tools::displayError('Product must be created before adding customization possibilities.');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
} elseif (Tools::isSubmit('submitProductCustomization')) {
if ($this->tabAccess['edit'] === '1') {
if (Validate::isLoadedObject($product = new Product((int) Tools::getValue('id_product')))) {
foreach ($_POST as $field => $value) {
if (strncmp($field, 'label_', 6) == 0 and !Validate::isLabel($value)) {
$this->_errors[] = Tools::displayError('Label fields are invalid');
}
}
if (!sizeof($this->_errors) and !$product->updateLabels()) {
$this->_errors[] = Tools::displayError('An error occurred while updating customization.');
}
if (!sizeof($this->_errors)) {
Tools::redirectAdmin($currentIndex . '&id_product=' . $product->id . '&id_category=' . (!empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') . '&add' . $this->table . '&tabs=5&token=' . ($token ? $token : $this->token));
}
} else {
$this->_errors[] = Tools::displayError('Product must be created before adding customization possibilities.');
}
} else {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
}
} elseif (isset($_GET['position'])) {
if ($this->tabAccess['edit'] !== '1') {
$this->_errors[] = Tools::displayError('You do not have permission to edit here.');
} elseif (!Validate::isLoadedObject($object = $this->loadObject())) {
$this->_errors[] = Tools::displayError('An error occurred while updating status for object.') . ' <b>' . $this->table . '</b> ' . Tools::displayError('(cannot load object)');
}
if (!$object->updatePosition((int) Tools::getValue('way'), (int) Tools::getValue('position'))) {
$this->_errors[] = Tools::displayError('Failed to update the position.');
} else {
Tools::redirectAdmin($currentIndex . '&' . $this->table . 'Orderby=position&' . $this->table . 'Orderway=asc&conf=5' . (($id_category = !empty($_REQUEST['id_category']) ? $_REQUEST['id_category'] : '1') ? '&id_category=' . $id_category : '') . '&token=' . Tools::getAdminTokenLite('AdminCatalog'));
}
} else {
parent::postProcess(true);
}
}
public static function updateQuantityCron()
{
$link = new Link();
global $link;
$db = Db::getInstance(_PS_USE_SQL_SLAVE_);
// update data from sudarshan_details table to ps_product
$sql = "update ps_product p inner join sudarshan_details s on (s.id_product = p.id_product and p.reference like 'BLR002%') set p.supplier_reference = CASE WHEN concat(s.design_no,'::',s.item_code) = '::' THEN '' WHEN concat(s.design_no,'::',s.item_code) != '' THEN concat(s.design_no,'::',s.item_code) END, p.active = s.enabled";
$db->ExecuteS($sql);
$sql = "select id_supplier from ps_supplier where code = 'BLR002'";
$res = $db->getRow($sql);
$id_supplier = $res['id_supplier'];
self::echomsg(null, "Start Sudarshan Stock Sync - UpdateQuantity", true);
// Sudarshan Vendor Code is in the format design_no::item_code
$sql = "select id_product, reference, supplier_reference from ps_product where id_supplier = {$id_supplier} and supplier_reference like '%::%' and active = 1";
$res = $db->ExecuteS($sql);
/*$res = array(
array('id_product' => 111, 'supplier_reference' => '675::CRB', 'reference' => 'BLR0021001'),
array('id_product' => 112, 'supplier_reference' => 'BLR020020::CRB', 'reference' => 'BLR0020020'),
array('id_product' => 113, 'supplier_reference' => 'BLR020021::CRB', 'reference' => 'BLR0020021'),
array('id_product' => 114, 'supplier_reference' => 'BLR020022::CRB', 'reference' => 'BLR0020022'),
array('id_product' => 115, 'supplier_reference' => 'BLR020023::CRB', 'reference' => 'BLR0020023'),
);*/
foreach ($res as $product) {
self::echomsg(null, "--------------------------------------------------", true);
$id_product = $product['id_product'];
$supplier_reference = $product['supplier_reference'];
$reference = $product['reference'];
if (empty($supplier_reference)) {
self::echomsg($product, "No Vendor Code", true);
continue;
}
$sup_details = explode("::", $supplier_reference);
if (count($sup_details) !== 2) {
self::echomsg($product, "Invalid Vendor Code {$supplier_reference}", true);
continue;
}
self::echomsg($product, "Waiting for response");
$design_no = $sup_details[0];
$item_code = $sup_details[1];
$qres = self::getQuantityByItemcode($id_product, $design_no, $item_code);
if ($qres === false) {
$sql = "update sudarshan_details set valid = 0 where id_product = {$id_product}";
$db->ExecuteS($sql);
self::echomsg($product, "Failed to get quantity - Updating quantity to 5 and shipping sla to 15 days", true);
$quantity = 5;
$shipping_sla = 15;
} else {
$sql = "update sudarshan_details set valid = 1 where id_product = {$id_product}";
$db->ExecuteS($sql);
$quantity = (int) $qres->GetQuantityResult;
if ($quantity === 0) {
$quantity = 5;
$shipping_sla = 15;
} else {
$shipping_sla = 3;
}
self::echomsg($product, "Vendor Quantity {$quantity}");
}
$dbproduct = new Product($id_product);
$old_quantity = (int) $dbproduct->quantity;
//$sql = "select quantity from ps_product where id_product = {$id_product}";
//$res = $db->ExecuteS($sql);
//$old_quantity = (int)$res[0]["quantity"];
if ($quantity === $old_quantity && (int) $dbproduct->shipping_sla === $shipping_sla) {
self::echomsg($product, "Quantity {$quantity} already upto date", true);
continue;
}
//update DB and Solr
$dbproduct->quantity = $quantity;
$dbproduct->update();
//$sql = "update ps_product set quantity=$quantity where id_product = $id_product";
//$db->ExecuteS($sql);
self::addFeature($id_product, 'shipping_estimate', "Ready to be shipped in {$shipping_sla} days");
SolrSearch::updateProduct($id_product);
//Search::indexation();
//Log the update
$sql = "insert into stock_sync_data(id_product,old_quantity,new_quantity,id_employee,status) values({$id_product},{$old_quantity},{$quantity},-9999,1)";
$db->ExecuteS($sql);
self::echomsg($product, "Updated Product Quantity to {$quantity}", true);
}
self::echomsg(null, "--------------------------------------------------", true);
self::echomsg(null, "End Sudarshan Stock Sync - UpdateQuantity", true);
self::send_log_mail('Update Quantity');
}
/**
* Validate an order in database
* Function called from a payment module
*
* @param integer $id_cart Value
* @param integer $id_order_state Value
* @param float $amountPaid Amount really paid by customer (in the default currency)
* @param string $paymentMethod Payment method (eg. 'Credit card')
* @param string $message Message to attach to order
*/
public function validateOrder($id_cart, $id_order_state, $amountPaid, $paymentMethod = 'Unknown', $message = NULL, $extraVars = array(), $currency_special = NULL, $dont_touch_amount = false, $secure_key = false)
{
global $cart, $link, $cookie;
$id_payment_state = _PS_PS_NOT_PAID_;
$cart = new Cart((int) $id_cart);
// Does order already exists ?
if (Validate::isLoadedObject($cart) and $cart->OrderExists() == false) {
if ($secure_key !== false and $secure_key != $cart->secure_key) {
die(Tools::displayError());
}
// Copying data from cart
$order = new Order();
$order->id_carrier = (int) $cart->id_carrier;
$order->id_customer = (int) $cart->id_customer;
$order->id_address_invoice = (int) $cart->id_address_invoice;
$order->id_address_delivery = (int) $cart->id_address_delivery;
$vat_address = new Address((int) $order->id_address_delivery);
$order->id_currency = $currency_special ? (int) $currency_special : (int) $cart->id_currency;
$order->id_lang = (int) $cart->id_lang;
$order->id_cart = (int) $cart->id;
$customer = new Customer((int) $order->id_customer);
$order->secure_key = $secure_key ? pSQL($secure_key) : pSQL($customer->secure_key);
$order->payment = $paymentMethod;
if (isset($this->name)) {
$order->module = $this->name;
}
$order->recyclable = $cart->recyclable;
$order->gift = (int) $cart->gift;
$order->gift_message = $cart->gift_message;
$currency = new Currency($order->id_currency);
$order->conversion_rate = $currency->conversion_rate;
$amountPaid = !$dont_touch_amount ? Tools::ps_round((double) $amountPaid, 2) : $amountPaid;
$order->total_paid_real = $amountPaid;
$order->total_products = (double) $cart->getOrderTotal(false, Cart::ONLY_PRODUCTS);
$order->total_products_wt = (double) $cart->getOrderTotal(true, Cart::ONLY_PRODUCTS);
$order->total_customization = $cart->getCartCustomizationCost();
$order->total_donation = round($cookie->donation_amount);
unset($cookie->donation_amount);
if (strpos($order->payment, 'COD') === false) {
$order->total_discounts = (double) abs($cart->getOrderTotal(true, Cart::ONLY_DISCOUNTS, true));
$order->total_paid = (double) Tools::ps_round((double) $cart->getOrderTotal(true, Cart::BOTH, true));
} else {
$order->total_discounts = (double) abs($cart->getOrderTotal(true, Cart::ONLY_DISCOUNTS, false));
$order->total_paid = (double) Tools::ps_round((double) $cart->getOrderTotal(true, Cart::BOTH, false));
$order->total_cod = COD_CHARGE;
}
$order->total_shipping = (double) $cart->getOrderShippingCost();
$order->carrier_tax_rate = (double) Tax::getCarrierTaxRate($cart->id_carrier, (int) $cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
$order->total_wrapping = (double) abs($cart->getOrderTotal(true, Cart::ONLY_WRAPPING));
$order->invoice_date = '0000-00-00 00:00:00';
$order->delivery_date = '0000-00-00 00:00:00';
$shippingdate = $cart->getExpectedShippingDate();
$order->expected_shipping_date = pSQL($shippingdate->format('Y-m-d H:i:s'));
$order->actual_expected_shipping_date = pSQL($shippingdate->format('Y-m-d H:i:s'));
// Amount paid by customer is not the right one -> Status = payment error
// We don't use the following condition to avoid the float precision issues : http://www.php.net/manual/en/language.types.float.php
// if ($order->total_paid != $order->total_paid_real)
// We use number_format in order to compare two string
if (number_format(round($order->total_paid)) != number_format(round($order->total_paid_real))) {
$id_order_state = _PS_OS_ERROR_;
$id_payment_state = _PS_PS_NOT_PAID_;
} else {
if (strpos($order->payment, 'COD') === false) {
$id_payment_state = _PS_PS_PAID_;
}
}
//update payment status
// Creating order
if ($cart->OrderExists() == false) {
$cart_value = $cart->getOrderTotal();
if ($cart_value >= 1000) {
//if(!$cart->containsProduct(FREE_GIFT_ID, NULL, NULL))
//$cart->updateQty(1, FREE_GIFT_ID, NULL, false, 'up', TRUE);
}
$result = $order->add();
} else {
$errorMessage = Tools::displayError('An order has already been placed using this cart.');
Logger::addLog($errorMessage, 4, '0000001', 'Cart', intval($order->id_cart));
die($errorMessage);
}
// Next !
if ($result and isset($order->id)) {
if (!$secure_key) {
$message .= $this->l('Warning : the secure key is empty, check your payment account before validation');
}
// Optional message to attach to this order
if (isset($message) and !empty($message)) {
$msg = new Message();
$message = strip_tags($message, '<br>');
if (Validate::isCleanHtml($message)) {
$msg->message = $message;
$msg->id_order = intval($order->id);
$msg->private = 1;
$msg->add();
}
}
// Insert products from cart into order_detail table
$products = $cart->getProducts();
$productsList = '';
$db = Db::getInstance();
$query = 'INSERT INTO `' . _DB_PREFIX_ . 'order_detail`
(`id_order`, `product_id`, `product_attribute_id`, `product_name`, `product_quantity`, `product_quantity_in_stock`, `product_price`, `reduction_percent`, `reduction_amount`, `group_reduction`, `product_quantity_discount`, `product_ean13`, `product_upc`, `product_reference`, `product_supplier_reference`, `product_weight`, `tax_name`, `tax_rate`, `ecotax`, `ecotax_tax_rate`, `discount_quantity_applied`, `download_deadline`, `download_hash`, `customization`)
VALUES ';
$customizedDatas = Product::getAllCustomizedDatas((int) $order->id_cart);
Product::addCustomizationPrice($products, $customizedDatas);
$outOfStock = false;
foreach ($products as $key => $product) {
$productQuantity = (int) Product::getQuantity((int) $product['id_product'], $product['id_product_attribute'] ? (int) $product['id_product_attribute'] : NULL);
$quantityInStock = $productQuantity - (int) $product['cart_quantity'] < 0 ? $productQuantity : (int) $product['cart_quantity'];
if ($id_order_state != _PS_OS_CANCELED_ and $id_order_state != _PS_OS_ERROR_) {
if (Product::updateQuantity($product, (int) $order->id)) {
$product['stock_quantity'] -= $product['cart_quantity'];
}
if ($product['stock_quantity'] < 0 && Configuration::get('PS_STOCK_MANAGEMENT')) {
$outOfStock = true;
}
if ($product['stock_quantity'] < 1) {
SolrSearch::updateProduct((int) $product['id_product']);
}
Product::updateDefaultAttribute($product['id_product']);
}
$price = Product::getPriceStatic((int) $product['id_product'], false, $product['id_product_attribute'] ? (int) $product['id_product_attribute'] : NULL, 6, NULL, false, true, $product['cart_quantity'], false, (int) $order->id_customer, (int) $order->id_cart, (int) $order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
$price_wt = Product::getPriceStatic((int) $product['id_product'], true, $product['id_product_attribute'] ? (int) $product['id_product_attribute'] : NULL, 2, NULL, false, true, $product['cart_quantity'], false, (int) $order->id_customer, (int) $order->id_cart, (int) $order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
// Add some informations for virtual products
$deadline = '0000-00-00 00:00:00';
$download_hash = NULL;
if ($id_product_download = ProductDownload::getIdFromIdProduct((int) $product['id_product'])) {
$productDownload = new ProductDownload((int) $id_product_download);
$deadline = $productDownload->getDeadLine();
$download_hash = $productDownload->getHash();
}
// Exclude VAT
if (Tax::excludeTaxeOption()) {
$product['tax'] = 0;
$product['rate'] = 0;
$tax_rate = 0;
} else {
$tax_rate = Tax::getProductTaxRate((int) $product['id_product'], $cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
}
$ecotaxTaxRate = 0;
if (!empty($product['ecotax'])) {
$ecotaxTaxRate = Tax::getProductEcotaxRate($order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
}
$quantityDiscount = SpecificPrice::getQuantityDiscount((int) $product['id_product'], Shop::getCurrentShop(), (int) $cart->id_currency, (int) $vat_address->id_country, (int) $customer->id_default_group, (int) $product['cart_quantity']);
$unitPrice = Product::getPriceStatic((int) $product['id_product'], true, $product['id_product_attribute'] ? intval($product['id_product_attribute']) : NULL, 2, NULL, false, true, 1, false, (int) $order->id_customer, NULL, (int) $order->{Configuration::get('PS_TAX_ADDRESS_TYPE')});
$quantityDiscountValue = $quantityDiscount ? (Product::getTaxCalculationMethod((int) $order->id_customer) == PS_TAX_EXC ? Tools::ps_round($unitPrice, 2) : $unitPrice) - $quantityDiscount['price'] * (1 + $tax_rate / 100) : 0.0;
$specificPrice = 0;
$query .= '(' . (int) $order->id . ',
' . (int) $product['id_product'] . ',
' . (isset($product['id_product_attribute']) ? (int) $product['id_product_attribute'] : 'NULL') . ',
\'' . pSQL($product['name'] . ((isset($product['attributes']) and $product['attributes'] != NULL) ? ' - ' . $product['attributes'] : '')) . '\',
' . (int) $product['cart_quantity'] . ',
' . $quantityInStock . ',
' . (double) Product::getPriceStatic((int) $product['id_product'], false, $product['id_product_attribute'] ? (int) $product['id_product_attribute'] : NULL, Product::getTaxCalculationMethod((int) $order->id_customer) == PS_TAX_EXC ? 2 : 6, NULL, false, false, $product['cart_quantity'], false, (int) $order->id_customer, (int) $order->id_cart, (int) $order->{Configuration::get('PS_TAX_ADDRESS_TYPE')}, $specificPrice, FALSE) . ',
' . (double) (($specificPrice and $specificPrice['reduction_type'] == 'percentage') ? $specificPrice['reduction'] * 100 : 0.0) . ',
' . (double) (($specificPrice and $specificPrice['reduction_type'] == 'amount') ? !$specificPrice['id_currency'] ? Tools::convertPrice($specificPrice['reduction'], $order->id_currency) : $specificPrice['reduction'] : 0.0) . ',
' . (double) Group::getReduction((int) $order->id_customer) . ',
' . $quantityDiscountValue . ',
' . (empty($product['ean13']) ? 'NULL' : '\'' . pSQL($product['ean13']) . '\'') . ',
' . (empty($product['upc']) ? 'NULL' : '\'' . pSQL($product['upc']) . '\'') . ',
' . (empty($product['reference']) ? 'NULL' : '\'' . pSQL($product['reference']) . '\'') . ',
' . (empty($product['supplier_reference']) ? 'NULL' : '\'' . pSQL($product['supplier_reference']) . '\'') . ',
' . (double) ($product['id_product_attribute'] ? $product['weight_attribute'] : $product['weight']) . ',
\'' . (empty($tax_rate) ? '' : pSQL($product['tax'])) . '\',
' . (double) $tax_rate . ',
' . (double) Tools::convertPrice(floatval($product['ecotax']), intval($order->id_currency)) . ',
' . (double) $ecotaxTaxRate . ',
' . (($specificPrice and $specificPrice['from_quantity'] > 1) ? 1 : 0) . ',
\'' . pSQL($deadline) . '\',
\'' . pSQL($download_hash) . '\', ' . $cart->getProductCustomizationCost($product['id_product']) . '),';
$customizationQuantity = 0;
if (isset($customizedDatas[$product['id_product']][$product['id_product_attribute']])) {
$customizationText = '';
foreach ($customizedDatas[$product['id_product']][$product['id_product_attribute']] as $customization) {
if (isset($customization['datas'][_CUSTOMIZE_TEXTFIELD_])) {
foreach ($customization['datas'][_CUSTOMIZE_TEXTFIELD_] as $text) {
if ($text['index'] == 8) {
$customizationText .= 'Saree with unstitched blouse and fall/pico work.' . '<br />';
} else {
if ($text['index'] == 1) {
$customizationText .= 'Pre-stitched saree with unstitched blouse and fall/pico work.' . '<br />';
} else {
if ($text['index'] == 2) {
$customizationText .= 'Stitched to measure blouse.' . '<br />';
} else {
if ($text['index'] == 3) {
$customizationText .= 'Stitched to measure in-skirt.' . '<br />';
} else {
if ($text['index'] == 4) {
$customizationText .= 'Stitched to measure kurta.' . '<br />';
} else {
if ($text['index'] == 5) {
$customizationText .= 'Stitched to measure salwar.' . '<br />';
}
}
}
}
}
}
}
}
if (isset($customization['datas'][_CUSTOMIZE_FILE_])) {
$customizationText .= sizeof($customization['datas'][_CUSTOMIZE_FILE_]) . ' ' . Tools::displayError('image(s)') . '<br />';
}
$customizationText .= '---<br />';
}
$customizationText = rtrim($customizationText, '---<br />');
$customizationQuantity = (int) $product['customizationQuantityTotal'];
$productsList .= '<tr style="background-color: ' . ($key % 2 ? '#DDE2E6' : '#EBECEE') . ';">
<td style="padding: 0.6em 0.4em;">' . $product['reference'] . '</td>
<td style="padding: 0.6em 0.4em;"><strong>' . $product['name'] . (isset($product['attributes_small']) ? ' ' . $product['attributes_small'] : '') . ' - ' . $this->l('Customized') . (!empty($customizationText) ? ' - ' . $customizationText : '') . '</strong></td>
<td style="padding: 0.6em 0.4em; text-align: right;">' . Tools::displayPrice(round(Product::getTaxCalculationMethod() == PS_TAX_EXC ? $price : $price_wt), $currency, false) . '</td>
<td style="padding: 0.6em 0.4em; text-align: center;">' . $customizationQuantity . '</td>
<td style="padding: 0.6em 0.4em; text-align: right;">' . Tools::displayPrice($customizationQuantity * round(Product::getTaxCalculationMethod() == PS_TAX_EXC ? $price : $price_wt), $currency, false) . '</td>
</tr>';
}
if (!$customizationQuantity or (int) $product['cart_quantity'] > $customizationQuantity) {
$productsList .= '<tr style="background-color: ' . ($key % 2 ? '#DDE2E6' : '#EBECEE') . ';">
<td style="padding: 0.6em 0.4em;">' . $product['reference'] . '</td>
<td style="padding: 0.6em 0.4em;"><strong>' . $product['name'] . (isset($product['attributes_small']) ? ' ' . $product['attributes_small'] : '') . '</strong></td>
<td style="padding: 0.6em 0.4em; text-align: right;">' . Tools::displayPrice(round(Product::getTaxCalculationMethod() == PS_TAX_EXC ? $price : $price_wt), $currency, false) . '</td>
<td style="padding: 0.6em 0.4em; text-align: center;">' . ((int) $product['cart_quantity'] - $customizationQuantity) . '</td>
<td style="padding: 0.6em 0.4em; text-align: right;">' . Tools::displayPrice(((int) $product['cart_quantity'] - $customizationQuantity) * round(Product::getTaxCalculationMethod() == PS_TAX_EXC ? $price : $price_wt), $currency, false) . '</td>
</tr>';
}
//if giftcard, create voucher and send the mails now.
$categories = Product::getProductCategories($product['id_product']);
if (in_array(CAT_GIFTCARD, $categories)) {
$friendsName = '';
$friendsEmail = '';
$giftMessage = '';
foreach ($customizedDatas[$product['id_product']][$product['id_product_attribute']] as $customization) {
if (isset($customization['datas'][_CUSTOMIZE_TEXTFIELD_])) {
foreach ($customization['datas'][_CUSTOMIZE_TEXTFIELD_] as $text) {
if ($text['index'] == 21) {
$friendsName = $text['value'];
} else {
if ($text['index'] == 22) {
$friendsEmail = $text['value'];
} else {
if ($text['index'] == 23) {
$giftMessage = $text['value'];
} else {
if ($text['index'] == 25) {
$couponCode = $text['value'];
}
}
}
}
}
}
}
//$couponCode = "GC" . Tools::rand_string(8);
// create discount
$languages = Language::getLanguages($order);
$voucher = new Discount();
$voucher->id_discount_type = 2;
foreach ($languages as $language) {
$voucher->description[$language['id_lang']] = $product['name'];
}
$voucher->value = (double) $unitPrice;
$voucher->name = $couponCode;
$voucher->id_currency = 2;
//USD
$voucher->quantity = 1;
$voucher->quantity_per_user = 1;
$voucher->cumulable = 1;
$voucher->cumulable_reduction = 1;
$voucher->minimal = 0;
$voucher->active = 1;
$voucher->cart_display = 0;
$now = time();
$voucher->date_from = date('Y-m-d H:i:s', $now);
$voucher->date_to = date('Y-m-d H:i:s', $now + 3600 * 24 * 365);
/* 365 days */
$voucher->add();
$productObj = new Product($product['id_product'], true, 1);
$idImage = $productObj->getCoverWs();
if ($idImage) {
$idImage = $productObj->id . '-' . $idImage;
} else {
$idImage = Language::getIsoById(1) . '-default';
}
$params = array();
$params['{voucher_code}'] = $voucher->name;
$params['{freinds_name}'] = $friendsName;
$params['{gift_message}'] = $giftMessage;
$params['{product_name}'] = $product['name'];
$params['{voucher_value}'] = $voucher->value;
$params['{image_url}'] = _PS_BASE_URL_ . _PS_IMG_ . 'banners/' . $productObj->location;
$params['{sender_name}'] = $customer->firstname . ' ' . $customer->lastname;
$subject = $friendsName . ', You Have Received A $' . $voucher->value . ' IndusDiva Gift Card';
@Mail::Send(1, 'gift_card', $subject, $params, $friendsEmail, $friendsName, '*****@*****.**', 'Indusdiva.com', NULL, NULL, _PS_MAIL_DIR_, true);
@Mail::Send(1, 'gift_card', $subject, $params, $customer->email, $customer->firstname . ' ' . $customer->lastname, '*****@*****.**', 'Indusdiva.com', NULL, NULL, _PS_MAIL_DIR_, true);
}
}
// end foreach ($products)
$query = rtrim($query, ',');
$result = $db->Execute($query);
// Insert discounts from cart into order_discount table
$discounts = $cart->getDiscounts();
$discountsList = '';
$total_discount_value = 0;
$shrunk = false;
foreach ($discounts as $discount) {
$objDiscount = new Discount((int) $discount['id_discount'], $order->id_lang);
$value = $objDiscount->getValue(sizeof($discounts), $cart->getOrderTotal(true, Cart::ONLY_PRODUCTS), $order->total_shipping, $cart->id);
if ($objDiscount->id_discount_type == 2 || $objDiscount->id_discount_type == 4 and in_array($objDiscount->behavior_not_exhausted, array(1, 2))) {
$shrunk = true;
}
if ($shrunk and $total_discount_value + $value > $order->total_products + $order->total_shipping + $order->total_wrapping) {
$amount_to_add = $order->total_products + $order->total_shipping + $order->total_wrapping - $total_discount_value;
if ($objDiscount->id_discount_type == 2 || $objDiscount->id_discount_type == 4 and $objDiscount->behavior_not_exhausted == 2) {
$voucher = new Discount();
foreach ($objDiscount as $key => $discountValue) {
$voucher->{$key} = $discountValue;
}
$voucher->name = 'VSRK' . (int) $order->id_customer . 'O' . (int) $order->id;
$voucher->value = (double) $value - $amount_to_add;
$voucher->add();
$params['{voucher_amount}'] = Tools::displayPrice($voucher->value, $currency, false);
$params['{voucher_num}'] = $voucher->name;
@Mail::Send((int) $order->id_lang, 'voucher', Mail::l('New voucher regarding your order #') . $order->id, $params, $customer->email, $customer->firstname . ' ' . $customer->lastname);
}
} else {
$amount_to_add = $value;
}
$order->addDiscount($objDiscount->id, $objDiscount->name, $amount_to_add);
$total_discount_value += $amount_to_add;
if ($id_order_state != _PS_OS_ERROR_ and $id_order_state != _PS_OS_CANCELED_) {
$objDiscount->quantity = $objDiscount->quantity - 1;
}
$objDiscount->update();
$discountsList .= '<tr style="background-color:#EBECEE;">
<td colspan="4" style="padding: 0.6em 0.4em; text-align: right;">' . $this->l('Voucher code:') . ' ' . $objDiscount->name . '</td>
<td style="padding: 0.6em 0.4em; text-align: right;">' . ($value != 0.0 ? '-' : '') . Tools::displayPrice($value, $currency, false) . '</td>
</tr>';
}
// Specify order id for message
$oldMessage = Message::getMessageByCartId((int) $cart->id);
if ($oldMessage) {
$message = new Message((int) $oldMessage['id_message']);
$message->id_order = (int) $order->id;
$message->update();
}
// Hook new order
$orderStatus = new OrderState((int) $id_order_state, (int) $order->id_lang);
if (Validate::isLoadedObject($orderStatus)) {
Hook::newOrder($cart, $order, $customer, $currency, $orderStatus);
foreach ($cart->getProducts() as $product) {
if ($orderStatus->logable) {
ProductSale::addProductSale((int) $product['id_product'], (int) $product['cart_quantity']);
}
}
}
if (isset($outOfStock) and $outOfStock) {
$history = new OrderHistory();
$history->id_order = (int) $order->id;
$history->changeIdOrderState(_PS_OS_OUTOFSTOCK_, (int) $order->id);
$history->addWithemail();
}
// Set order state in order history ONLY even if the "out of stock" status has not been yet reached
// So you migth have two order states
$new_history = new OrderHistory();
$new_history->id_order = (int) $order->id;
$new_history->changeIdOrderState((int) $id_order_state, (int) $order->id);
$new_history->addWithemail(true, $extraVars);
//Payment status
$paymentHistory = new OrderPaymentHistory();
$paymentHistory->id_order = (int) $order->id;
$paymentHistory->changeIdOrderPaymentState($id_payment_state, (int) $order->id);
$paymentHistory->addState();
// Order is reloaded because the status just changed
$order = new Order($order->id);
//Update tracking code for quantium
if ($order->id_carrier == QUANTIUM) {
if (strpos($order->payment, 'COD') === false) {
$order->shipping_number = 'VBN' . $order->id;
} else {
$order->shipping_number = 'VBC' . $order->id;
}
$order->update();
} else {
if ($order->id_carrier == SABEXPRESS) {
$db = Db::getInstance();
$db->Execute('LOCK TABLES vb_awb_pool WRITE');
$res = $db->getRow("select min(id) as 'id', awb from vb_awb_pool where id_carrier = " . SABEXPRESS . " and assigned = 0");
$awb = $res['awb'];
$id = $res['id'];
$db->Execute("update vb_awb_pool set assigned = 1 where id = " . $id);
$db->Execute('UNLOCK TABLES');
$order->shipping_number = $awb;
$order->update();
} else {
if ($order->id_carrier == AFL) {
$db = Db::getInstance();
$db->Execute('LOCK TABLES vb_awb_pool WRITE');
$res = $db->getRow("select min(id) as 'id' , awb from vb_awb_pool where id_carrier = " . AFL . " and assigned = 0");
$awb = $res['awb'];
$id = $res['id'];
$db->Execute("update vb_awb_pool set assigned = 1 where id = " . $id);
$db->Execute('UNLOCK TABLES');
$order->shipping_number = $awb;
$order->update();
}
}
}
// Send an e-mail to customer
if ($id_order_state != _PS_OS_ERROR_ and $id_order_state != _PS_OS_CANCELED_ and $customer->id and $id_order_state != _PS_OS_OP_PAYEMENT_FAILED) {
//deduct reward points
$points_redeemed = $cart->getPoints();
if ($points_redeemed) {
VBRewards::removeRewardPoints($order->id_customer, EVENT_POINTS_REDEEMED, 0, $cart->getPoints(), 'Coins redeemed - Order no ' . $order->id, $order->id, $order->date_add);
}
/*
if(strpos($order->payment, 'COD') === false && $order->total_paid_real > 0)
{
VBRewards::addRewardPoints($order->id_customer, ONLINE_ORDER, 0, 100, 'Online payment bonus - Order no ' . $order->id, $order->id, $order->date_add);
}
*/
$invoice = new Address((int) $order->id_address_invoice);
$delivery = new Address((int) $order->id_address_delivery);
$carrier = new Carrier((int) $order->id_carrier, $order->id_lang);
$delivery_state = $delivery->id_state ? new State((int) $delivery->id_state) : false;
$invoice_state = $invoice->id_state ? new State((int) $invoice->id_state) : false;
$shippingdate = new DateTime($order->expected_shipping_date);
$data = array('{firstname}' => $customer->firstname, '{shipping_date}' => $shippingdate->format("F j, Y"), '{lastname}' => $customer->lastname, '{email}' => $customer->email, '{delivery_block_txt}' => $this->_getFormatedAddress($delivery, "\n"), '{invoice_block_txt}' => $this->_getFormatedAddress($invoice, "\n"), '{delivery_block_html}' => $this->_getFormatedAddress($delivery, "<br />", array('firstname' => '<span style="color:#DB3484; font-weight:bold;">%s</span>', 'lastname' => '<span style="color:#DB3484; font-weight:bold;">%s</span>')), '{invoice_block_html}' => $this->_getFormatedAddress($invoice, "<br />", array('firstname' => '<span style="color:#DB3484; font-weight:bold;">%s</span>', 'lastname' => '<span style="color:#DB3484; font-weight:bold;">%s</span>')), '{delivery_company}' => $delivery->company, '{delivery_firstname}' => $delivery->firstname, '{delivery_lastname}' => $delivery->lastname, '{delivery_address1}' => $delivery->address1, '{delivery_address2}' => $delivery->address2, '{delivery_city}' => $delivery->city, '{delivery_postal_code}' => $delivery->postcode, '{delivery_country}' => $delivery->country, '{delivery_state}' => $delivery->id_state ? $delivery_state->name : '', '{delivery_phone}' => $delivery->phone ? $delivery->phone : $delivery->phone_mobile, '{delivery_other}' => $delivery->other, '{invoice_company}' => $invoice->company, '{invoice_vat_number}' => $invoice->vat_number, '{invoice_firstname}' => $invoice->firstname, '{invoice_lastname}' => $invoice->lastname, '{invoice_address2}' => $invoice->address2, '{invoice_address1}' => $invoice->address1, '{invoice_city}' => $invoice->city, '{invoice_postal_code}' => $invoice->postcode, '{invoice_country}' => $invoice->country, '{invoice_state}' => $invoice->id_state ? $invoice_state->name : '', '{invoice_phone}' => $invoice->phone ? $invoice->phone : $invoice->phone_mobile, '{invoice_other}' => $invoice->other, '{order_name}' => sprintf("#%06d", (int) $order->id), '{date}' => date("F j, Y, g:i a"), '{carrier}' => $carrier->name, '{payment}' => Tools::substr($order->payment, 0, 32), '{products}' => $productsList, '{discounts}' => $discountsList, '{total_paid}' => Tools::displayPrice($order->total_paid, $currency, false), '{total_products}' => Tools::displayPrice($order->total_paid - $order->total_shipping - $order->total_cod - $order->total_wrapping + $order->total_discounts, $currency, false), '{total_discounts}' => Tools::displayPrice($order->total_discounts, $currency, false), '{total_shipping}' => Tools::displayPrice($order->total_shipping, $currency, false), '{total_cod}' => Tools::displayPrice($order->total_cod, $currency, false), '{total_wrapping}' => Tools::displayPrice($order->total_wrapping, $currency, false));
if (is_array($extraVars)) {
$data = array_merge($data, $extraVars);
}
// Join PDF invoice
if ((int) Configuration::get('PS_INVOICE') and Validate::isLoadedObject($orderStatus) and $orderStatus->invoice and $order->invoice_number) {
$fileAttachment['content'] = PDF::invoice($order, 'S');
$fileAttachment['name'] = $fileAttachment['name'] = 'IndusDiva Order #' . sprintf('%06d', (int) $order->id) . '.pdf';
$fileAttachment['mime'] = 'application/pdf';
} else {
$fileAttachment = NULL;
}
if (Validate::isEmail($customer->email)) {
if ($id_order_state == _PS_OS_BANKWIRE_) {
Mail::Send((int) $order->id_lang, 'order_conf_bankwire', Mail::l('Your order #' . $order->id . ' with IndusDiva.com is confirmed'), $data, $customer->email, $customer->firstname . ' ' . $customer->lastname, NULL, NULL, $fileAttachment);
} else {
$data['payment'] = 'Online Payment';
Mail::Send((int) $order->id_lang, 'order_conf', Mail::l('Your order #' . $order->id . ' with IndusDiva.com is confirmed'), $data, $customer->email, $customer->firstname . ' ' . $customer->lastname, NULL, NULL, $fileAttachment);
}
}
//Send SMS
//$smsText = 'Dear customer, your order #'.$order->id.' at IndusDiva.com is confirmed and will be delivered to you within 3-5 business days. www.indusdiva.com';
//Tools::sendSMS($delivery->phone_mobile, $smsText);
}
$this->currentOrder = (int) $order->id;
return true;
} else {
$errorMessage = Tools::displayError('Order creation failed');
Logger::addLog($errorMessage, 4, '0000002', 'Cart', intval($order->id_cart));
die($errorMessage);
}
} else {
$errorMessage = Tools::displayError('Cart can\'t be loaded or an order has already been placed using this cart');
Logger::addLog($errorMessage, 4, '0000001', 'Cart', intval($cart->id));
die($errorMessage);
}
}
