public function GetQuote()
{
// The following array will be returned to the calling function.
// It will contain at one ISC_SHIPPING_QUOTE object
$pi_quote = array();
// Workout the cost by multiplying peritemcost * numproducts
$num_items = 0;
foreach ($this->_products as $item) {
$num_items += $item->getquantity();
}
$price = $this->GetValue("peritemcost");
if (!$price) {
$price = 0;
}
$total = $num_items * $price;
// Create a quote object
$Error = false;
$this->_shippingcost = CFloat($total);
$pi_quote = new ISC_SHIPPING_QUOTE($this->GetId(), $this->getDisplayName(), $this->_shippingcost);
return $pi_quote;
}
/**
* Return the discount product/category grid
*
* Method will return either the products or categories HTML grid
*
* @access public
* @return string The email accounts HTML grid
*/
public function ManageGroupDiscountGrid($data=null)
{
if (!is_array($data)) {
$data = $_POST;
}
if (!is_array($data)) {
$data = array();
}
if (!isset($data['items']) || !is_array($data['items'])) {
$data['items'] = array();
}
if (!isset($data['type']) || !is_string($data['type'])) {
$data['type'] = '';
}
if (!isset($data['total']) || !isc_is_int($data['total'])) {
$data['total'] = 0;
}
$items = $data['items'];
$type = isc_strtolower($data['type']);
$total = $data['total'];
if (isset($_GET['page']) && $_GET['page'] > 1) {
$page = $_GET['page'];
} else {
$page = 1;
}
/**
* Special global for naving ot a page when displaying an error
*/
if (isc_strtolower($type) == 'product' && isset($GLOBALS['pageNavToProduct'])) {
$page = $GLOBALS['pageNavToProduct'];
} else if (isc_strtolower($type) == 'category' && isset($GLOBALS['pageNavToCategory'])) {
$page = $GLOBALS['pageNavToCategory'];
}
if ($page == 1) {
$start = 1;
} else {
$start = ($page * ISC_GROUPDISCOUNT_ITEMS_PER_PAGE) - (ISC_GROUPDISCOUNT_ITEMS_PER_PAGE - 1);
}
$start = $start-1;
$numPages = ceil($total / ISC_GROUPDISCOUNT_ITEMS_PER_PAGE);
if ($total > ISC_GROUPDISCOUNT_ITEMS_PER_PAGE) {
$GLOBALS['Nav'] = sprintf('(%s %d of %d) ', GetLang('Page'), $page, $numPages);
$GLOBALS['Nav'] .= BuildPagination($total, ISC_GROUPDISCOUNT_ITEMS_PER_PAGE, $page, 'index.php?ToDo=viewCustomerGroupDiscounts&type=' . urlencode($type), 'getGroupDiscountDataBlock');
} else {
$GLOBALS['Nav'] = '';
}
$html = '';
foreach ($items as $item) {
$GLOBALS['DiscountMethodPercent'] = '';
$GLOBALS['DiscountMethodPrice'] = '';
$GLOBALS['DiscountMethodFixed'] = '';
if ($type == 'product') {
$GLOBALS['ProductId'] = (int)$item['discountid'];
$GLOBALS['CatOrProdId'] = (int)$item['catorprodid'];
if (isId($item['discountid'])) {
$result = $GLOBALS['ISC_CLASS_DB']->Query("SELECT prodname FROM [|PREFIX|]products WHERE productid=" . (int)$item['catorprodid']);
$prodname = $GLOBALS['ISC_CLASS_DB']->FetchOne($result, 'prodname');
}
if (!isId($item['discountid']) || $prodname == '') {
$item['catorprodid'] = '';
$GLOBALS['SelectedItemName'] = GetLang('NoneSelected');
} else {
$GLOBALS['SelectedItemName'] = isc_html_escape($prodname);
}
} else {
$GLOBALS['CategoryId'] = (int)$item['discountid'];
$GLOBALS['CategoryOptions'] = $GLOBALS["ISC_CLASS_ADMIN_CATEGORY"]->GetCategoryOptions(array($item['catorprodid']), "<option %s value='%d'>%s</option>", "selected=\"selected\"", "", false);
$GLOBALS['DiscountCatTypeCat'] = '';
$GLOBALS['DiscountCatTypeCatAndSub'] = '';
if (isc_strtolower($item['appliesto']) == 'category_and_subcats') {
$GLOBALS['DiscountCatTypeCatAndSub'] = 'selected';
} else {
$GLOBALS['DiscountCatTypeCat'] = 'selected';
}
}
if ($item['discountmethod'] == 'percent') {
$GLOBALS['AmountPrefix'] = '';
$GLOBALS['AmountPostfix'] = '%';
$GLOBALS['DiscountMethodPercent'] = 'selected';
} else {
if ($item['discountmethod'] == 'fixed') {
$GLOBALS['DiscountMethodFixed'] = 'selected';
} else {
$GLOBALS['DiscountMethodPrice'] = 'selected';
}
if (GetConfig('CurrencyLocation') == 'right') {
$GLOBALS['AmountPrefix'] = '';
$GLOBALS['AmountPostfix'] = GetConfig('CurrencyToken');
} else {
$GLOBALS['AmountPrefix'] = GetConfig('CurrencyToken');
$GLOBALS['AmountPostfix'] = '';
}
}
if ((int)$item['discountpercent'] == $item['discountpercent']) {
$GLOBALS['DiscountAmount'] = (int)$item['discountpercent'];
} else {
$GLOBALS['DiscountAmount'] = CFloat($item['discountpercent']);
}
$html .= $this->template->render('Snippets/CustomerGroup'.ucfirst(isc_strtolower($type)).'Row.html');
}
if ($numPages <= 1) {
$GLOBALS['HidePagingNav'] = 'none';
} else {
$GLOBALS['HidePagingNav'] = '';
}
$GLOBALS['Type'] = isc_html_escape($type);
$GLOBALS['CustomerGroupDiscountGrid'] = $html;
return $this->template->render('customers.groups.discount.grid.tpl');
}
/**
* EditCustomerGroup
* Load up a customer group's details for editing. Why am I working on this at 11:10pm on a Saturday night?! - Mitch
*
* @return Void
*/
private function EditCustomerGroup($MsgDesc = "", $MsgStatus = "")
{
if (isset($_GET['groupId']) && is_numeric($_GET['groupId'])) {
$groupId = (int) $_GET['groupId'];
$query = sprintf("SELECT customergroupid, groupname, discount, discountmethod, categoryaccesstype, isdefault\n\t\t\t\t\t\t\t\t FROM [|PREFIX|]customer_groups\n\t\t\t\t\t\t\t\t WHERE customergroupid='%d'", $groupId);
$result = $GLOBALS["ISC_CLASS_DB"]->Query($query);
if ($row = $GLOBALS["ISC_CLASS_DB"]->Fetch($result)) {
if ($MsgDesc != "") {
$GLOBALS['Message'] = MessageBox($MsgDesc, $MsgStatus);
}
if (count($_POST) > 0) {
// Something went wrong, get the details from the form
$GLOBALS['GroupName'] = isc_html_escape($_POST['groupname']);
$GLOBALS['Discount'] = isc_html_escape($_POST['discount']);
$GLOBALS['StoreDiscountMethod'] = $_POST['storeDiscountMethod'];
if (isset($_POST['isdefault'])) {
$GLOBALS['IsDefault'] = "CHECKED='CHECKED'";
}
} else {
// Load the customer group's details from the database
$GLOBALS['GroupId'] = (int) $row['customergroupid'];
$GLOBALS['GroupName'] = isc_html_escape($row['groupname']);
if ($row['discount'] == (int) $row['discount']) {
$GLOBALS['Discount'] = (int) $row['discount'];
$GLOBALS['StoreDiscountMethod'] = $row['discountmethod'];
} else {
$GLOBALS['Discount'] = CFloat($row['discount']);
$GLOBALS['StoreDiscountMethod'] = 'price';
}
if ($row['isdefault'] == "1") {
$GLOBALS['IsDefault'] = "CHECKED='CHECKED'";
}
}
$access_cats = array();
if (isset($_POST['accesscategories']) || $row['categoryaccesstype'] == "all") {
$GLOBALS['AccessAllCategories'] = "CHECKED='CHECKED'";
$GLOBALS['HideAccessCategories'] = "none";
$GLOBALS['HideAccessCatLinks'] = "none";
} else {
if (isset($_POST['accesscategorieslist'])) {
$access_cats = $_POST['accesscategorieslist'];
} else {
//$access_cats = explode(",", $row['accesscategories']);
$query = "SELECT * FROM [|PREFIX|]customer_group_categories WHERE customergroupid = '" . $groupId . "'";
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
while ($category = $GLOBALS['ISC_CLASS_DB']->Fetch($result)) {
$access_cats[] = $category['categoryid'];
}
}
}
foreach ($access_cats as $k => $v) {
if (!is_numeric($v)) {
unset($access_cats[$k]);
}
}
// Reuse them for the categories which the group has access to and make them all selected by default
$GLOBALS['AccessCategoryOptions'] = $GLOBALS["ISC_CLASS_ADMIN_CATEGORY"]->GetCategoryOptions($access_cats, "<option %s value='%d'>%s</option>", 'selected="selected"', "", false);
$GLOBALS['FormAction'] = "editCustomerGroup2";
$GLOBALS['Title'] = GetLang("EditACustomerGroup");
// Build the categories dropdown HTML
$GLOBALS['CategoryOptions'] = $GLOBALS["ISC_CLASS_ADMIN_CATEGORY"]->GetCategoryOptions(array(), "<option %s value='%d'>%s</option>", "selected=\"selected\"", "", false);
// Setup the JavaScript for existing discounts (if any)
$GLOBALS['ExistingCategoryDiscounts'] = "";
$query = sprintf("SELECT discountpercent, catorprodid, appliesto, discounttype, discountmethod, p.prodname\n\t\t\t\t\t\t\t\t\t FROM [|PREFIX|]customer_group_discounts\n\t\t\t\t\t\t\t\t\t LEFT JOIN [|PREFIX|]products p\n\t\t\t\t\t\t\t\t\t ON p.productid=catorprodid\n\t\t\t\t\t\t\t\t\t WHERE customergroupid='%d'\n\t\t\t\t\t\t\t\t\t ORDER BY discounttype ASC, groupdiscountid ASC", $groupId);
$result = $GLOBALS["ISC_CLASS_DB"]->Query($query);
while ($row = $GLOBALS["ISC_CLASS_DB"]->Fetch($result)) {
// Is the discount an integrate or decimal?
if ((int) $row['discountpercent'] == $row['discountpercent']) {
// It's an integer
$discount = (int) $row['discountpercent'];
} else {
// It's a decimal such as 7.50
$discount = CFloat($row['discountpercent']);
}
if ($row['discounttype'] == "CATEGORY") {
// It's a category discount
$GLOBALS['ExistingCategoryDiscounts'] .= sprintf("AddCatRule(%d, '%s', '%s', '%s');\n", $row['catorprodid'], $discount, $row['appliesto'], $row['discountmethod']);
} else {
// It's a product discount
$GLOBALS['ExistingCategoryDiscounts'] .= sprintf("AddProdRule(%d, '%s', '%s', '%s');\n", $row['catorprodid'], str_replace("'", "\\'", $row['prodname']), $discount, $row['discountmethod']);
}
}
$GLOBALS["ISC_CLASS_TEMPLATE"]->SetTemplate("customers.group.form");
$GLOBALS["ISC_CLASS_TEMPLATE"]->ParseTemplate();
} else {
$this->ManageCustomerGroups();
}
} else {
$this->ManageCustomerGroups();
}
}
public function CopyProductStep1($MsgDesc = "", $MsgStatus = "", $PreservePost = false, $OriginalProductID = 0)
{
if ($MsgDesc != "") {
$GLOBALS['Message'] = MessageBox($MsgDesc, $MsgStatus);
}
// Show the form to edit a product
if (isset($_REQUEST['productId']) && isId($_REQUEST['productId'])) {
$OriginalProductID = $_REQUEST['productId'];
}
$prodId = $OriginalProductID;
$z = 0;
$arrData = array();
$arrImages = array();
$arrCustomFields = array();
if (GetConfig('CurrencyLocation') == 'right') {
$GLOBALS['CurrencyTokenLeft'] = '';
$GLOBALS['CurrencyTokenRight'] = GetConfig('CurrencyToken');
} else {
$GLOBALS['CurrencyTokenLeft'] = GetConfig('CurrencyToken');
$GLOBALS['CurrencyTokenRight'] = '';
}
$GLOBALS['ServerFiles'] = $this->_GetImportFilesOptions();
$GLOBALS['ISC_CLASS_ADMIN_CATEGORY'] = GetClass('ISC_ADMIN_CATEGORY');
// Make sure the product exists
if (ProductExists($prodId)) {
if ($PreservePost == true) {
$this->_GetProductData(0, $arrData);
$this->_GetCustomFieldData(0, $arrCustomFields);
$GLOBALS['ProductFields'] = $this->_GetProductFieldsLayout(0, true);
// Restore the hash
$GLOBALS['ProductHash'] = $arrData['prodhash'];
} else {
$this->_GetProductData($prodId, $arrData);
$this->_GetCustomFieldData($prodId, $arrCustomFields);
$GLOBALS['ProductFields'] = $this->_GetProductFieldsLayout($prodId, true);
// Generate the hash
$GLOBALS['ProductHash'] = md5(time() . uniqid(rand(), true));
// We'll need to duplicate (copy) the thumbnail, images and download files here
$this->_CopyProductImages($prodId, 0, $GLOBALS['ProductHash']);
$this->_CopyDownloads($prodId, 0, $GLOBALS['ProductHash']);
$arrData['prodname'] = GetLang('CopyOf') . $arrData['prodname'];
}
// Does this user have permission to edit this product?
if ($GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId() && $arrData['prodvendorid'] != $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId()) {
FlashMessage(GetLang('Unauthorized'), MSG_ERROR, 'index.php?ToDo=viewProducts');
}
$arrImages = $this->_GetImageData(0, $GLOBALS['ProductHash']);
if (isset($_POST['currentTab'])) {
$GLOBALS['CurrentTab'] = (int) $_POST['currentTab'];
} else {
$GLOBALS['CurrentTab'] = 0;
}
$GLOBALS['FormAction'] = 'copyProduct2';
$GLOBALS['Title'] = GetLang('CopyProductTitle');
$GLOBALS['Intro'] = GetLang('CopyProductIntro');
$GLOBALS["ProdType_" . $arrData['prodtype']] = 'checked="checked"';
$GLOBALS['ProdType'] = $arrData['prodtype'] - 1;
$GLOBALS['ProdCode'] = isc_html_escape($arrData['prodcode']);
$GLOBALS['ProdName'] = isc_html_escape($arrData['prodname']);
$GLOBALS['OriginalProductId'] = $OriginalProductID;
$visibleCategories = array();
if ($GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId()) {
$vendorData = $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendor();
if ($vendorData['vendoraccesscats']) {
$visibleCategories = explode(',', $vendorData['vendoraccesscats']);
}
}
// $GLOBALS['CategoryOptions'] = $GLOBALS['ISC_CLASS_ADMIN_CATEGORY']->GetCategoryOptions($arrData['prodcats'], "<option %s value='%d'>%s</option>", "selected='selected'", "", false, '', $visibleCategories);
$GLOBALS['CategoryOptions'] = $GLOBALS['ISC_CLASS_ADMIN_CATEGORY']->GetCategoryOptionsProduct($arrData['prodcats'], "<option %s value='%d' id='category_old%d'>%s</option>", "selected='selected'", "", false, '', $visibleCategories);
$GLOBALS['RelatedCategoryOptions'] = $GLOBALS['ISC_CLASS_ADMIN_CATEGORY']->GetCategoryOptions(0, "<option %s value='%d'>%s</option>", "selected='selected'", "- ", false);
//blessen
$wysiwygOptions = array('id' => 'wysiwyg', 'width' => '60%', 'height' => '350px', 'value' => $arrData['proddesc']);
$wysiwygOptions1 = array('id' => 'wysiwyg1', 'width' => '60%', 'height' => '350px', 'value' => $arrData['prodmfg']);
$wysiwygOptions2 = array('id' => 'wysiwyg2', 'width' => '60%', 'height' => '350px', 'value' => $arrData['prodwarranty']);
$GLOBALS['WYSIWYG'] = GetClass('ISC_ADMIN_EDITOR')->GetWysiwygEditor($wysiwygOptions);
$GLOBALS['WYSIWYG1'] = GetClass('ISC_ADMIN_EDITOR')->GetWysiwygEditor1($wysiwygOptions1);
$GLOBALS['WYSIWYG2'] = GetClass('ISC_ADMIN_EDITOR')->GetWysiwygEditor1($wysiwygOptions2);
$GLOBALS['ProdSearchKeywords'] = isc_html_escape($arrData['prodsearchkeywords']);
$GLOBALS['ProdAvailability'] = isc_html_escape($arrData['prodavailability']);
$GLOBALS['ProdPrice'] = number_format($arrData['prodprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
if (CFloat($arrData['prodcostprice']) > 0) {
$GLOBALS['ProdCostPrice'] = number_format($arrData['prodcostprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodretailprice']) > 0) {
$GLOBALS['ProdRetailPrice'] = number_format($arrData['prodretailprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodsaleprice']) > 0) {
$GLOBALS['ProdSalePrice'] = number_format($arrData['prodsaleprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
$GLOBALS['ProdSortOrder'] = $arrData['prodsortorder'];
if ($arrData['prodvisible'] == 1) {
$GLOBALS['ProdVisible'] = "checked";
}
if ($arrData['prodfeatured'] == 1) {
$GLOBALS['ProdFeatured'] = "checked";
}
if ($GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId()) {
$GLOBALS['HideStoreFeatured'] = 'display: none';
} else {
if (!gzte11(ISC_HUGEPRINT) || !$arrData['prodvendorid']) {
$GLOBALS['HideVendorFeatured'] = 'display: none';
}
}
if ($arrData['prodvendorfeatured'] == 1) {
$GLOBALS['ProdVendorFeatured'] = 'checked="checked"';
}
if ($arrData['prodistaxable'] == 1) {
$GLOBALS['ProdIsTaxable'] = 'checked';
}
if ($arrData['prodallowpurchases'] == 1) {
$GLOBALS['ProdAllowPurchases'] = 'checked="checked"';
} else {
if ($arrData['prodhideprice'] == 1) {
$GLOBALS['ProdHidePrice'] = 'checked="checked"';
}
$GLOBALS['ProdCallForPricingLabel'] = isc_html_escape($arrData['prodcallforpricinglabel']);
}
$GLOBALS['MoreImages'] = "MoreImages();";
for ($i = 1; $i <= $arrImages['numImages']; $i++) {
$image = sprintf("../%s/%s", GetConfig('ImageDirectory'), $arrImages["image" . $i]);
if ($i == 1) {
$GLOBALS["ImageMessage" . $i] = sprintf(GetLang('EditImageDesc'), $image, $arrImages["image" . $i]);
} else {
$GLOBALS["ImageMessage" . $i] = sprintf(GetLang('EditImageDesc2'), $arrImages["id" . $i], $arrImages["id" . $i], $arrImages["id" . $i], $image, $arrImages["image" . $i], $arrImages["id" . $i]);
}
}
if (isset($arrImages['thumb'])) {
$thumb = sprintf("../%s/%s", GetConfig('ImageDirectory'), $arrImages['thumb']);
$GLOBALS['ThumbMessage'] = sprintf(GetLang('EditImageDesc'), $thumb, $arrImages['thumb']);
}
//blessen
//$GLOBALS['ProdWarranty'] = $arrData['prodwarranty'];
//$GLOBALS['prod_instruction'] = $arrData['prod_instruction'];
//$GLOBALS['prod_article'] = $arrData['prod_article'];
$GLOBALS['ProdWeight'] = number_format($arrData['prodweight'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
if (CFloat($arrData['prodwidth']) > 0) {
$GLOBALS['ProdWidth'] = number_format($arrData['prodwidth'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodheight']) > 0) {
$GLOBALS['ProdHeight'] = number_format($arrData['prodheight'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['proddepth']) > 0) {
$GLOBALS['ProdDepth'] = number_format($arrData['proddepth'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodfixedshippingcost']) > 0) {
$GLOBALS['ProdFixedShippingCost'] = number_format($arrData['prodfixedshippingcost'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if ($arrData['prodfreeshipping'] == 1) {
$GLOBALS['FreeShipping'] = 'checked="checked"';
}
if ($arrData['prodrelatedproducts'] == -1) {
$GLOBALS['IsProdRelatedAuto'] = 'checked="checked"';
} else {
if (isset($arrData['prodrelated'])) {
$GLOBALS['RelatedProductOptions'] = "";
foreach ($arrData['prodrelated'] as $r) {
$GLOBALS['RelatedProductOptions'] .= sprintf("<option value='%d'>%s</option>", (int) $r[0], isc_html_escape($r[1]));
}
}
}
$GLOBALS['ProdTags'] = $arrData['prodtags'];
$GLOBALS['CurrentStockLevel'] = $arrData['prodcurrentinv'];
$GLOBALS['LowStockLevel'] = $arrData['prodlowinv'];
$GLOBALS["InvTrack_" . $arrData['prodinvtrack']] = 'checked="checked"';
$GLOBALS['WrappingOptions'] = $this->BuildGiftWrappingSelect(explode(',', $arrData['prodwrapoptions']));
$GLOBALS['HideGiftWrappingOptions'] = 'display: none';
if ($arrData['prodwrapoptions'] == 0) {
$GLOBALS['WrappingOptionsDefaultChecked'] = 'checked="checked"';
} else {
if ($arrData['prodwrapoptions'] == -1) {
$GLOBALS['WrappingOptionsNoneChecked'] = 'checked="checked"';
} else {
$GLOBALS['HideGiftWrappingOptions'] = '';
$GLOBALS['WrappingOptionsCustomChecked'] = 'checked="checked"';
}
}
if ($arrData['prodinvtrack'] == 1) {
$GLOBALS['OptionButtons'] = "ToggleProductInventoryOptions(true);";
} else {
$GLOBALS['OptionButtons'] = "ToggleProductInventoryOptions(false);";
}
if ($arrData['prodoptionsrequired'] == 1) {
$GLOBALS['OptionsRequired'] = 'checked="checked"';
}
if ($arrData['prodtype'] == 1) {
$GLOBALS['HideProductInventoryOptions'] = "none";
}
$GLOBALS['EnterOptionPrice'] = sprintf(GetLang('EnterOptionPrice'), GetConfig('CurrencyToken'), GetConfig('CurrencyToken'));
$GLOBALS['EnterOptionWeight'] = sprintf(GetLang('EnterOptionWeight'), GetConfig('WeightMeasurement'));
$GLOBALS['HideCustomFieldLink'] = "none";
if (GetConfig('PricesIncludeTax')) {
$GLOBALS['PriceMsg'] = GetLang('IncTax');
} else {
$GLOBALS['PriceMsg'] = GetLang('ExTax');
}
$GLOBALS['CustomFields'] = '';
$GLOBALS['CustomFieldKey'] = 0;
if (!empty($arrCustomFields)) {
foreach ($arrCustomFields as $f) {
$GLOBALS['CustomFieldName'] = isc_html_escape($f['name']);
$GLOBALS['CustomFieldValue'] = isc_html_escape($f['value']);
$GLOBALS['CustomFieldLabel'] = $this->GetFieldLabel($GLOBALS['CustomFieldKey'] + 1, GetLang('CustomField'));
if (!$GLOBALS['CustomFieldKey']) {
$GLOBALS['HideCustomFieldDelete'] = 'none';
} else {
$GLOBALS['HideCustomFieldDelete'] = '';
}
$GLOBALS['CustomFields'] .= $GLOBALS['ISC_CLASS_TEMPLATE']->GetSnippet('CustomFields');
$GLOBALS['CustomFieldKey']++;
}
}
// Add one more custom field
$GLOBALS['CustomFieldName'] = '';
$GLOBALS['CustomFieldValue'] = '';
$GLOBALS['CustomFieldLabel'] = $this->GetFieldLabel($GLOBALS['CustomFieldKey'] + 1, GetLang('CustomField'));
if (!$GLOBALS['CustomFieldKey']) {
$GLOBALS['HideCustomFieldDelete'] = 'none';
} else {
$GLOBALS['HideCustomFieldDelete'] = '';
}
$GLOBALS['CustomFields'] .= $GLOBALS['ISC_CLASS_TEMPLATE']->GetSnippet('CustomFields');
if ($this->HasGD()) {
$GLOBALS['ShowGDThumb'] = "";
$GLOBALS['ShowNoGDThumb'] = "none";
} else {
$GLOBALS['ShowGDThumb'] = "none";
$GLOBALS['ShowNoGDThumb'] = "";
}
// Get a list of any downloads associated with this product
$GLOBALS['DownloadsGrid'] = $this->GetDownloadsGrid(0, $GLOBALS['ProductHash']);
$GLOBALS['ISC_LANG']['MaxUploadSize'] = sprintf(GetLang('MaxUploadSize'), GetMaxUploadSize());
if ($GLOBALS['DownloadsGrid'] == '') {
$GLOBALS['DisplayDownloaadGrid'] = "none";
}
// Get the brands as select options
$GLOBALS['ISC_CLASS_ADMIN_BRANDS'] = GetClass('ISC_ADMIN_BRANDS');
$GLOBALS['BrandNameOptions'] = $GLOBALS['ISC_CLASS_ADMIN_BRANDS']->GetBrandsAsOptions($arrData['prodbrandid']);
$GLOBALS['SaveAndAddAnother'] = GetLang('SaveAndAddAnother');
// Get a list of all layout files
$layoutFile = 'product.html';
if ($arrData['prodlayoutfile'] != '') {
$layoutFile = $arrData['prodlayoutfile'];
}
$GLOBALS['LayoutFiles'] = GetCustomLayoutFilesAsOptions("product.html", $layoutFile);
$GLOBALS['ProdPageTitle'] = isc_html_escape($arrData['prodpagetitle']);
$GLOBALS['ProdMetaKeywords'] = isc_html_escape($arrData['prodmetakeywords']);
$GLOBALS['ProdMetaDesc'] = isc_html_escape($arrData['prodmetadesc']);
$GLOBALS['SaveAndAddAnother'] = GetLang('SaveAndAddAnother');
if (!gzte11(ISC_MEDIUMPRINT)) {
$GLOBALS['HideInventoryOptions'] = "none";
} else {
$GLOBALS['HideInventoryOptions'] = '';
}
// Does this product have a variation assigned to it?
$GLOBALS['ProductVariationExisting'] = $arrData['prodvariationid'];
if ($arrData['prodvariationid'] > 0) {
$GLOBALS['IsYesVariation'] = 'checked="checked"';
} else {
$GLOBALS['IsNoVariation'] = 'checked="checked"';
$GLOBALS['HideVariationList'] = "none";
$GLOBALS['HideVariationCombinationList'] = "none";
}
// If there are no variations then disable the option to choose one
$numVariations = 0;
$GLOBALS['VariationOptions'] = $this->GetVariationsAsOptions($numVariations, $arrData['prodvariationid']);
if ($numVariations == 0) {
$GLOBALS['VariationDisabled'] = "DISABLED";
$GLOBALS['VariationColor'] = "#CACACA";
$GLOBALS['IsNoVariation'] = 'checked="checked"';
$GLOBALS['IsYesVariation'] = "";
$GLOBALS['HideVariationCombinationList'] = "none";
} else {
// Load the variation combinations
if ($arrData['prodinvtrack'] == 2) {
$show_inv_fields = true;
} else {
$show_inv_fields = false;
}
/**
* We'll need to duplicate the variation combinations here if we are NOT preserving the post
*/
if (!$PreservePost) {
$this->_CopyVariationData($arrData['productid'], 0, $GLOBALS['ProductHash']);
}
$GLOBALS['VariationCombinationList'] = $this->_LoadVariationCombinationsTable($arrData['prodvariationid'], $show_inv_fields, 0, $GLOBALS['ProductHash']);
}
if (!gzte11(ISC_HUGEPRINT)) {
$GLOBALS['HideVendorOption'] = 'display: none';
} else {
$vendorData = $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendor();
if (isset($vendorData['vendorid'])) {
$GLOBALS['HideVendorSelect'] = 'display: none';
$GLOBALS['CurrentVendor'] = isc_html_escape($vendorData['vendorname']);
} else {
$GLOBALS['HideVendorLabel'] = 'display: none';
$GLOBALS['VendorList'] = $this->BuildVendorSelect($arrData['prodvendorid']);
}
}
// Display the discount rules
if ($PreservePost == true) {
$GLOBALS['DiscountRules'] = $this->GetDiscountRules($prodId);
} else {
$GLOBALS['DiscountRules'] = $this->GetDiscountRules(0);
}
// Hide if we are not enabled
if (!GetConfig('BulkDiscountEnabled')) {
$GLOBALS['HideDiscountRulesWarningBox'] = '';
$GLOBALS['DiscountRulesWarningText'] = GetLang('DiscountRulesNotEnabledWarning');
$GLOBALS['DiscountRulesWithWarning'] = 'none';
// Also hide it if this product has variations
} else {
if (isset($arrData['prodvariationid']) && isId($arrData['prodvariationid'])) {
$GLOBALS['HideDiscountRulesWarningBox'] = '';
$GLOBALS['DiscountRulesWarningText'] = GetLang('DiscountRulesVariationWarning');
$GLOBALS['DiscountRulesWithWarning'] = 'none';
} else {
$GLOBALS['HideDiscountRulesWarningBox'] = 'none';
$GLOBALS['DiscountRulesWithWarning'] = '';
}
}
$GLOBALS['DiscountRulesEnabled'] = (int) GetConfig('BulkDiscountEnabled');
$GLOBALS['EventDateFieldName'] = $arrData['prodeventdatefieldname'];
if ($GLOBALS['EventDateFieldName'] == null) {
$GLOBALS['EventDateFieldName'] = GetLang('EventDateDefault');
}
if ($arrData['prodeventdaterequired'] == 1) {
$GLOBALS['EventDateRequired'] = 'checked="checked"';
$from_stamp = $arrData['prodeventdatelimitedstartdate'];
$to_stamp = $arrData['prodeventdatelimitedenddate'];
} else {
$from_stamp = isc_gmmktime(0, 0, 0, isc_date("m"), isc_date("d"), isc_date("Y"));
$to_stamp = isc_gmmktime(0, 0, 0, isc_date("m") + 1, isc_date("d"), isc_date("Y"));
}
if ($arrData['prodeventdatelimited'] == 1) {
$GLOBALS['LimitDates'] = 'checked="checked"';
}
$GLOBALS['LimitDateOption1'] = '';
$GLOBALS['LimitDateOption2'] = '';
$GLOBALS['LimitDateOption3'] = '';
switch ($arrData['prodeventdatelimitedtype']) {
case 1:
$GLOBALS['LimitDateOption1'] = 'selected="selected"';
break;
case 2:
$GLOBALS['LimitDateOption2'] = 'selected="selected"';
break;
case 3:
$GLOBALS['LimitDateOption3'] = 'selected="selected"';
break;
}
// Set the global variables for the select boxes
$from_day = isc_date("d", $from_stamp);
$from_month = isc_date("m", $from_stamp);
$from_year = isc_date("Y", $from_stamp);
$to_day = isc_date("d", $to_stamp);
$to_month = isc_date("m", $to_stamp);
$to_year = isc_date("Y", $to_stamp);
$GLOBALS['OverviewFromDays'] = $this->_GetDayOptions($from_day);
$GLOBALS['OverviewFromMonths'] = $this->_GetMonthOptions($from_month);
$GLOBALS['OverviewFromYears'] = $this->_GetYearOptions($from_year);
$GLOBALS['OverviewToDays'] = $this->_GetDayOptions($to_day);
$GLOBALS['OverviewToMonths'] = $this->_GetMonthOptions($to_month);
$GLOBALS['OverviewToYears'] = $this->_GetYearOptions($to_year);
if (!$GLOBALS['ISC_CLASS_ADMIN_AUTH']->HasPermission(AUTH_Create_Category)) {
$GLOBALS['HideCategoryCreation'] = 'display: none';
}
$GLOBALS['SaveAndAddAnother'] = GetLang('SaveAndAddAnother');
$GLOBALS["ISC_CLASS_TEMPLATE"]->SetTemplate("product.form");
$GLOBALS["ISC_CLASS_TEMPLATE"]->ParseTemplate();
} else {
// The product doesn't exist
if ($GLOBALS["ISC_CLASS_ADMIN_AUTH"]->HasPermission(AUTH_Manage_Products)) {
$this->ManageProducts(GetLang('ProductDoesntExist'), MSG_ERROR);
} else {
$GLOBALS['ISC_CLASS_ADMIN_ENGINE']->DoHomePage(GetLang('Unauthorized'), MSG_ERROR);
}
}
}
function CPrice($Val)
{
$val = CFloat($Val);
$val = number_format($val, GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), GetConfig('ThousandsToken'));
return $val;
}
/**
* Update the store credit for a customer
*
* @return void
**/
private function UpdateStoreCredit()
{
if (!isset($_REQUEST['customerId'])) {
exit;
}
$query = sprintf("SELECT customerid, custstorecredit FROM [|PREFIX|]customers WHERE customerid='%d'", $GLOBALS['ISC_CLASS_DB']->Quote($_REQUEST['customerId']));
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
$customer = $GLOBALS['ISC_CLASS_DB']->Fetch($result);
if ($customer['customerid'] == 0) {
exit;
}
$updatedCustomer = array("custstorecredit" => DefaultPriceFormat($_REQUEST['credit']));
$GLOBALS['ISC_CLASS_DB']->UpdateQuery("customers", $updatedCustomer, "customerid='" . $GLOBALS['ISC_CLASS_DB']->Quote($customer['customerid']) . "'");
// Log the credit change
$creditChange = CFloat($_REQUEST['credit'] - $customer['custstorecredit']);
if ($creditChange != 0) {
$creditLog = array("customerid" => (int) $customer['customerid'], "creditamount" => $creditChange, "credittype" => "adjustment", "creditdate" => time(), "creditrefid" => 0, "credituserid" => $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetUserId(), "creditreason" => "");
$GLOBALS['ISC_CLASS_DB']->InsertQuery("customer_credits", $creditLog);
}
echo 1;
exit;
}
private function _GetCouponData($CouponId = 0, &$RefArray)
{
if ($CouponId == 0) {
$RefArray['couponid'] = 0;
$RefArray['coupontype'] = $_POST['coupontype'];
$RefArray['couponamount'] = (int) $_POST['couponamount'];
$RefArray['couponminpurchase'] = CFloat($_POST['couponminpurchase']);
$RefArray['couponmaxuses'] = (int) $_POST['couponmaxuses'];
if ($_POST['couponexpires'] != "") {
$RefArray['couponexpires'] = ConvertDateToTime($_POST['couponexpires']);
} else {
$RefArray['couponexpires'] = 0;
}
if (isset($_POST['couponenabled'])) {
$RefArray['couponenabled'] = 1;
} else {
$RefArray['couponenabled'] = 0;
}
if (isset($_POST['couponcode']) && $_POST['couponcode'] != "") {
$RefArray['couponcode'] = $_POST['couponcode'];
} else {
$RefArray['couponcode'] = GenerateCouponCode();
}
} else {
// Get the data for this coupon code from the database
$query = sprintf("select * from [|PREFIX|]coupons where couponid='%s'", $GLOBALS['ISC_CLASS_DB']->Quote($CouponId));
$result = $GLOBALS["ISC_CLASS_DB"]->Query($query);
if ($row = $GLOBALS["ISC_CLASS_DB"]->Fetch($result)) {
$RefArray = $row;
}
}
}
public function CopyProductStep1($MsgDesc = "", $MsgStatus = "", $PreservePost=false, $OriginalProductID=0)
{
if ($MsgDesc != "") {
$GLOBALS['Message'] = MessageBox($MsgDesc, $MsgStatus);
}
// Show the form to edit a product
if (isset($_REQUEST['productId']) && isId($_REQUEST['productId'])) {
$OriginalProductID = $_REQUEST['productId'];
}
$prodId = $OriginalProductID;
$z = 0;
$arrData = array();
$arrCustomFields = array();
if (GetConfig('CurrencyLocation') == 'right') {
$GLOBALS['CurrencyTokenLeft'] = '';
$GLOBALS['CurrencyTokenRight'] = GetConfig('CurrencyToken');
} else {
$GLOBALS['CurrencyTokenLeft'] = GetConfig('CurrencyToken');
$GLOBALS['CurrencyTokenRight'] = '';
}
$GLOBALS['ServerFiles'] = $this->_GetImportFilesOptions();
$GLOBALS['ISC_CLASS_ADMIN_CATEGORY'] = GetClass('ISC_ADMIN_CATEGORY');
// Make sure the product exists
if (ProductExists($prodId)) {
if($PreservePost == true) {
$this->_GetProductData(0, $arrData);
$this->_GetCustomFieldData(0, $arrCustomFields);
$GLOBALS['ProductFields'] = $this->_GetProductFieldsLayout(0, true);
// Restore the hash
$GLOBALS['ProductHash'] = $arrData['prodhash'];
} else {
$this->_GetProductData($prodId, $arrData);
$this->_GetCustomFieldData($prodId, $arrCustomFields);
$GLOBALS['ProductFields'] = $this->_GetProductFieldsLayout($prodId, true);
// Generate the hash
$GLOBALS['ProductHash'] = md5(time().uniqid(rand(), true));
// We'll need to duplicate (copy) the thumbnail, images and download files here
$this->_CopyDownloads($prodId, 0, $GLOBALS['ProductHash']);
$productImages = ISC_PRODUCT_IMAGE::copyImagesToProductHash($prodId, $GLOBALS['ProductHash']);
$this->setupProductImageGlobals($productImages);
$arrData['prodname'] = GetLang('CopyOf') . $arrData['prodname'];
}
$this->template->assign('product', $arrData);
// Does this user have permission to edit this product?
if($GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId() && $arrData['prodvendorid'] != $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId()) {
FlashMessage(GetLang('Unauthorized'), MSG_ERROR, 'index.php?ToDo=viewProducts');
}
if(isset($_POST['currentTab'])) {
$GLOBALS['CurrentTab'] = (int)$_POST['currentTab'];
}
else {
$GLOBALS['CurrentTab'] = 0;
}
$GLOBALS['FormAction'] = 'copyProduct2';
$GLOBALS['Title'] = GetLang('CopyProductTitle');
$GLOBALS['Intro'] = GetLang('CopyProductIntro');
$GLOBALS["ProdType_" . $arrData['prodtype']] = 'checked="checked"';
$GLOBALS['ProdType'] = $arrData['prodtype'] - 1;
$GLOBALS['ProdCode'] = isc_html_escape($arrData['prodcode']);
$GLOBALS['ProdName'] = isc_html_escape($arrData['prodname']);
$GLOBALS['OriginalProductId'] = $OriginalProductID;
$visibleCategories = array();
if($GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId()) {
$vendorData = $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendor();
if($vendorData['vendoraccesscats']) {
$visibleCategories = explode(',', $vendorData['vendoraccesscats']);
}
}
$GLOBALS['CategoryOptions'] = $GLOBALS['ISC_CLASS_ADMIN_CATEGORY']->GetCategoryOptions($arrData['prodcats'], "<option %s value='%d'>%s</option>", "selected='selected'", "", false, '', $visibleCategories);
$GLOBALS['RelatedCategoryOptions'] = $GLOBALS['ISC_CLASS_ADMIN_CATEGORY']->GetCategoryOptions(0, "<option %s value='%d'>%s</option>", "selected='selected'", "- ", false);
$wysiwygOptions = array(
'id' => 'wysiwyg',
'width' => '100%',
'height' => '500px',
'value' => $arrData['proddesc']
);
$GLOBALS['WYSIWYG'] = GetClass('ISC_ADMIN_EDITOR')->GetWysiwygEditor($wysiwygOptions);
$GLOBALS['ProdSearchKeywords'] = isc_html_escape($arrData['prodsearchkeywords']);
$GLOBALS['ProdAvailability'] = isc_html_escape($arrData['prodavailability']);
$GLOBALS['ProdPrice'] = number_format($arrData['prodprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
if (CFloat($arrData['prodcostprice']) > 0) {
$GLOBALS['ProdCostPrice'] = number_format($arrData['prodcostprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodretailprice']) > 0) {
$GLOBALS['ProdRetailPrice'] = number_format($arrData['prodretailprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodsaleprice']) > 0) {
$GLOBALS['ProdSalePrice'] = number_format($arrData['prodsaleprice'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
$GLOBALS['ProdSortOrder'] = $arrData['prodsortorder'];
if ($arrData['prodvisible'] == 1) {
$GLOBALS['ProdVisible'] = "checked";
}
if ($arrData['prodfeatured'] == 1) {
$GLOBALS['ProdFeatured'] = "checked";
}
if($GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendorId()) {
$GLOBALS['HideStoreFeatured'] = 'display: none';
}
else if(!gzte11(ISC_HUGEPRINT) || !$arrData['prodvendorid']) {
$GLOBALS['HideVendorFeatured'] = 'display: none';
}
if($arrData['prodvendorfeatured'] == 1) {
$GLOBALS['ProdVendorFeatured'] = 'checked="checked"';
}
if($arrData['prodallowpurchases'] == 1) {
$GLOBALS['ProdAllowPurchases'] = 'checked="checked"';
}
else {
if($arrData['prodhideprice'] == 1) {
$GLOBALS['ProdHidePrice'] = 'checked="checked"';
}
$GLOBALS['ProdCallForPricingLabel'] = isc_html_escape($arrData['prodcallforpricinglabel']);
}
$GLOBALS['ProdWarranty'] = $arrData['prodwarranty'];
$GLOBALS['ProdWeight'] = number_format($arrData['prodweight'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
if (CFloat($arrData['prodwidth']) > 0) {
$GLOBALS['ProdWidth'] = number_format($arrData['prodwidth'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodheight']) > 0) {
$GLOBALS['ProdHeight'] = number_format($arrData['prodheight'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['proddepth']) > 0) {
$GLOBALS['ProdDepth'] = number_format($arrData['proddepth'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if (CFloat($arrData['prodfixedshippingcost']) > 0) {
$GLOBALS['ProdFixedShippingCost'] = number_format($arrData['prodfixedshippingcost'], GetConfig('DecimalPlaces'), GetConfig('DecimalToken'), "");
}
if ($arrData['prodfreeshipping'] == 1) {
$GLOBALS['FreeShipping'] = 'checked="checked"';
}
if($arrData['prodrelatedproducts'] == -1) {
$GLOBALS['IsProdRelatedAuto'] = 'checked="checked"';
}
else if(isset($arrData['prodrelated'])) {
$GLOBALS['RelatedProductOptions'] = "";
foreach ($arrData['prodrelated'] as $r) {
$GLOBALS['RelatedProductOptions'] .= sprintf("<option value='%d'>%s</option>", (int) $r[0], isc_html_escape($r[1]));
}
}
$GLOBALS['ProdTags'] = $arrData['prodtags'];
$GLOBALS['CurrentStockLevel'] = $arrData['prodcurrentinv'];
$GLOBALS['LowStockLevel'] = $arrData['prodlowinv'];
$GLOBALS["InvTrack_" . $arrData['prodinvtrack']] = 'checked="checked"';
$GLOBALS['WrappingOptions'] = $this->BuildGiftWrappingSelect(explode(',', $arrData['prodwrapoptions']));
$GLOBALS['HideGiftWrappingOptions'] = 'display: none';
if($arrData['prodwrapoptions'] == 0) {
$GLOBALS['WrappingOptionsDefaultChecked'] = 'checked="checked"';
}
else if($arrData['prodwrapoptions'] == -1) {
$GLOBALS['WrappingOptionsNoneChecked'] = 'checked="checked"';
}
else {
$GLOBALS['HideGiftWrappingOptions'] = '';
$GLOBALS['WrappingOptionsCustomChecked'] = 'checked="checked"';
}
if ($arrData['prodinvtrack'] == 1) {
$GLOBALS['OptionButtons'] = "ToggleProductInventoryOptions(true);";
} else {
$GLOBALS['OptionButtons'] = "ToggleProductInventoryOptions(false);";
}
if ($arrData['prodoptionsrequired'] == 1) {
$GLOBALS['OptionsRequired'] = 'checked="checked"';
}
if ($arrData['prodtype'] == 1) {
$GLOBALS['HideProductInventoryOptions'] = "none";
}
$GLOBALS['EnterOptionPrice'] = sprintf(GetLang('EnterOptionPrice'), GetConfig('CurrencyToken'), GetConfig('CurrencyToken'));
$GLOBALS['EnterOptionWeight'] = sprintf(GetLang('EnterOptionWeight'), GetConfig('WeightMeasurement'));
$GLOBALS['HideCustomFieldLink'] = "none";
if(getConfig('taxEnteredWithPrices') == TAX_PRICES_ENTERED_INCLUSIVE) {
$this->template->assign('enterPricesWithTax', true);
}
$GLOBALS['CustomFields'] = '';
$GLOBALS['CustomFieldKey'] = 0;
if (!empty($arrCustomFields)) {
foreach ($arrCustomFields as $f) {
$GLOBALS['CustomFieldName'] = isc_html_escape($f['name']);
$GLOBALS['CustomFieldValue'] = isc_html_escape($f['value']);
$GLOBALS['CustomFieldLabel'] = $this->GetFieldLabel(($GLOBALS['CustomFieldKey']+1), GetLang('CustomField'));
if (!$GLOBALS['CustomFieldKey']) {
$GLOBALS['HideCustomFieldDelete'] = 'none';
} else {
$GLOBALS['HideCustomFieldDelete'] = '';
}
$GLOBALS['CustomFields'] .= $this->template->render('Snippets/CustomFields.html');
$GLOBALS['CustomFieldKey']++;
}
}
// Add one more custom field
$GLOBALS['CustomFieldName'] = '';
$GLOBALS['CustomFieldValue'] = '';
$GLOBALS['CustomFieldLabel'] = $this->GetFieldLabel(($GLOBALS['CustomFieldKey']+1), GetLang('CustomField'));
if (!$GLOBALS['CustomFieldKey']) {
$GLOBALS['HideCustomFieldDelete'] = 'none';
} else {
$GLOBALS['HideCustomFieldDelete'] = '';
}
$GLOBALS['CustomFields'] .= $this->template->render('Snippets/CustomFields.html');
// Get a list of any downloads associated with this product
$GLOBALS['DownloadsGrid'] = $this->GetDownloadsGrid(0, $GLOBALS['ProductHash']);
$GLOBALS['ISC_LANG']['MaxUploadSize'] = sprintf(GetLang('MaxUploadSize'), GetMaxUploadSize());
if($GLOBALS['DownloadsGrid'] == '') {
$GLOBALS['DisplayDownloaadGrid'] = "none";
}
// Get the brands as select options
$GLOBALS['ISC_CLASS_ADMIN_BRANDS'] = GetClass('ISC_ADMIN_BRANDS');
$GLOBALS['BrandNameOptions'] = $GLOBALS['ISC_CLASS_ADMIN_BRANDS']->GetBrandsAsOptions($arrData['prodbrandid']);
$GLOBALS['SaveAndAddAnother'] = GetLang('SaveAndAddAnother');
// Get a list of all layout files
$layoutFile = 'product.html';
if($arrData['prodlayoutfile'] != '') {
$layoutFile = $arrData['prodlayoutfile'];
}
$GLOBALS['LayoutFiles'] = GetCustomLayoutFilesAsOptions("product.html", $layoutFile);
$GLOBALS['ProdPageTitle'] = isc_html_escape($arrData['prodpagetitle']);
$GLOBALS['ProdMetaKeywords'] = isc_html_escape($arrData['prodmetakeywords']);
$GLOBALS['ProdMetaDesc'] = isc_html_escape($arrData['prodmetadesc']);
$GLOBALS['SaveAndAddAnother'] = GetLang('SaveAndAddAnother');
if(!gzte11(ISC_MEDIUMPRINT)) {
$GLOBALS['HideInventoryOptions'] = "none";
}
else {
$GLOBALS['HideInventoryOptions'] = '';
}
// Does this product have a variation assigned to it?
$GLOBALS['ProductVariationExisting'] = $arrData['prodvariationid'];
if($arrData['prodvariationid'] > 0) {
$GLOBALS['IsYesVariation'] = 'checked="checked"';
}
else {
$GLOBALS['IsNoVariation'] = 'checked="checked"';
$GLOBALS['HideVariationList'] = "none";
$GLOBALS['HideVariationCombinationList'] = "none";
}
// Get the list of tax classes and assign them
$this->template->assign('taxClasses', array(
0 => getLang('DefaultTaxClass')
) + getClass('ISC_TAX')->getTaxClasses());
// If there are no variations then disable the option to choose one
$numVariations = 0;
$GLOBALS['VariationOptions'] = $this->GetVariationsAsOptions($numVariations, $arrData['prodvariationid']);
if($numVariations == 0) {
$GLOBALS['VariationDisabled'] = "DISABLED";
$GLOBALS['VariationColor'] = "#CACACA";
$GLOBALS['IsNoVariation'] = 'checked="checked"';
$GLOBALS['IsYesVariation'] = "";
$GLOBALS['HideVariationCombinationList'] = "none";
}
else {
// Load the variation combinations
if($arrData['prodinvtrack'] == 2) {
$show_inv_fields = true;
}
else {
$show_inv_fields = false;
}
/**
* We'll need to duplicate the variation combinations here if we are NOT preserving the post
*/
if (!$PreservePost) {
$this->_CopyVariationData($arrData['productid'], 0, $GLOBALS['ProductHash']);
}
$GLOBALS['VariationCombinationList'] = $this->_LoadVariationCombinationsTable($arrData['prodvariationid'], $show_inv_fields, 0, $GLOBALS['ProductHash']);
}
if(!gzte11(ISC_HUGEPRINT)) {
$GLOBALS['HideVendorOption'] = 'display: none';
}
else {
$vendorData = $GLOBALS['ISC_CLASS_ADMIN_AUTH']->GetVendor();
if(isset($vendorData['vendorid'])) {
$GLOBALS['HideVendorSelect'] = 'display: none';
$GLOBALS['CurrentVendor'] = isc_html_escape($vendorData['vendorname']);
}
else {
$GLOBALS['HideVendorLabel'] = 'display: none';
$GLOBALS['VendorList'] = $this->BuildVendorSelect($arrData['prodvendorid']);
}
}
// Display the discount rules
if ($PreservePost == true) {
$GLOBALS['DiscountRules'] = $this->GetDiscountRules(0);
} else {
$GLOBALS['DiscountRules'] = $this->GetDiscountRules($prodId);
}
// Hide if we are not enabled
if (!GetConfig('BulkDiscountEnabled')) {
$GLOBALS['HideDiscountRulesWarningBox'] = '';
$GLOBALS['DiscountRulesWarningText'] = GetLang('DiscountRulesNotEnabledWarning');
$GLOBALS['DiscountRulesWithWarning'] = 'none';
// Also hide it if this product has variations
} else if (isset($arrData['prodvariationid']) && isId($arrData['prodvariationid'])) {
$GLOBALS['HideDiscountRulesWarningBox'] = '';
$GLOBALS['DiscountRulesWarningText'] = GetLang('DiscountRulesVariationWarning');
$GLOBALS['DiscountRulesWithWarning'] = 'none';
} else {
$GLOBALS['HideDiscountRulesWarningBox'] = 'none';
$GLOBALS['DiscountRulesWithWarning'] = '';
}
$GLOBALS['DiscountRulesEnabled'] = (int)GetConfig('BulkDiscountEnabled');
$GLOBALS['EventDateFieldName'] = $arrData['prodeventdatefieldname'];
if ($GLOBALS['EventDateFieldName'] == null) {
$GLOBALS['EventDateFieldName'] = GetLang('EventDateDefault');
}
if ($arrData['prodeventdaterequired'] == 1) {
$GLOBALS['EventDateRequired'] = 'checked="checked"';
$from_stamp = $arrData['prodeventdatelimitedstartdate'];
$to_stamp = $arrData['prodeventdatelimitedenddate'];
} else {
$from_stamp = isc_gmmktime(0, 0, 0, isc_date("m"), isc_date("d"), isc_date("Y"));
$to_stamp = isc_gmmktime(0, 0, 0, isc_date("m")+1, isc_date("d"), isc_date("Y"));
}
if ($arrData['prodeventdatelimited'] == 1) {
$GLOBALS['LimitDates'] = 'checked="checked"';
}
$GLOBALS['LimitDateOption1'] = '';
$GLOBALS['LimitDateOption2'] = '';
$GLOBALS['LimitDateOption3'] = '';
switch ($arrData['prodeventdatelimitedtype']) {
case 1 :
$GLOBALS['LimitDateOption1'] = 'selected="selected"';
break;
case 2 :
$GLOBALS['LimitDateOption2'] = 'selected="selected"';
break;
case 3 :
$GLOBALS['LimitDateOption3'] = 'selected="selected"';
break;
}
// Set the global variables for the select boxes
$from_day = isc_date("d", $from_stamp);
$from_month = isc_date("m", $from_stamp);
$from_year = isc_date("Y", $from_stamp);
$to_day = isc_date("d", $to_stamp);
$to_month = isc_date("m", $to_stamp);
$to_year = isc_date("Y", $to_stamp);
$GLOBALS['OverviewFromDays'] = $this->_GetDayOptions($from_day);
$GLOBALS['OverviewFromMonths'] = $this->_GetMonthOptions($from_month);
$GLOBALS['OverviewFromYears'] = $this->_GetYearOptions($from_year);
$GLOBALS['OverviewToDays'] = $this->_GetDayOptions($to_day);
$GLOBALS['OverviewToMonths'] = $this->_GetMonthOptions($to_month);
$GLOBALS['OverviewToYears'] = $this->_GetYearOptions($to_year);
if(!$GLOBALS['ISC_CLASS_ADMIN_AUTH']->HasPermission(AUTH_Create_Category)) {
$GLOBALS['HideCategoryCreation'] = 'display: none';
}
//Google website optimizer
$GLOBALS['HideOptimizerConfigForm'] = 'display:none;';
$GLOBALS['CheckEnableOptimizer'] = '';
$GLOBALS['SkipConfirmMsg'] = 'false';
$GLOBALS['GoogleWebsiteOptimizerIntro'] = GetLang('ProdGoogleWebsiteOptimizerIntro');
$enabledOptimizers = GetConfig('OptimizerMethods');
if(!empty($enabledOptimizers)) {
foreach ($enabledOptimizers as $id => $date) {
GetModuleById('optimizer', $optimizerModule, $id);
if ($optimizerModule->_testPage == 'products' || $optimizerModule->_testPage == 'all') {
$GLOBALS['SkipConfirmMsg'] = 'false';
break;
}
}
}
if($arrData['product_enable_optimizer'] == '1') {
$GLOBALS['HideOptimizerConfigForm'] = '';
$GLOBALS['CheckEnableOptimizer'] = 'Checked';
}
$this->template->assign('prodminqty', $arrData['prodminqty']);
$this->template->assign('prodmaxqty', $arrData['prodmaxqty']);
$optimizer = getClass('ISC_ADMIN_OPTIMIZER');
$GLOBALS['OptimizerConfigForm'] = $optimizer->showPerItemConfigForm('product', $arrData['productid'],prodLink($arrData['prodname']));
if ($arrData['prodpreorder'] && $arrData['prodreleasedateremove'] && time() >= $arrData['prodreleasedate']) {
// pre-order release date has passed and remove is ticked, remove it now for the copy form at least - saving it will commit it to the db
$arrData['prodpreorder'] = 0;
$arrData['prodreleasedate'] = 0;
$arrData['prodreleasedateremove'] = 0;
}
// note: prodpreorder is a database column does not map directly to a form field, it'll be set to 1 if _prodorderable is 'pre', along with prodallowpurchases to 1
// note: _prodorderable is a form field that does not map to a database column
if (!$arrData['prodallowpurchases']) {
$this->template->assign('_prodorderable', 'no');
} else if ($arrData['prodpreorder']) {
$this->template->assign('_prodorderable', 'pre');
} else {
$this->template->assign('_prodorderable', 'yes');
}
$this->template->assign('prodreleasedateremove', $arrData['prodreleasedateremove']);
if (isset($arrData['prodpreordermessage']) && $arrData['prodpreordermessage']) {
$this->template->assign('prodpreordermessage', $arrData['prodpreordermessage']);
} else {
$this->template->assign('prodpreordermessage', GetConfig('DefaultPreOrderMessage'));
}
if ($arrData['prodreleasedate']) {
$this->template->assign('prodreleasedate', isc_date('d/m/Y', $arrData['prodreleasedate']));
}
$GLOBALS['ProdCondition' . $arrData['prodcondition'] . 'Selected'] = 'selected="selected"';
if ($arrData['prodshowcondition']) {
$GLOBALS['ProdShowCondition'] = 'checked="checked"';
}
// Open Graph Settings
$this->template->assign('openGraphTypes', ISC_OPENGRAPH::getObjectTypes(true));
$this->template->assign('openGraphSelectedType', $arrData['opengraph_type']);
$this->template->assign('openGraphUseProductName', (bool)$arrData['opengraph_use_product_name']);
$this->template->assign('openGraphTitle', $arrData['opengraph_title']);
$this->template->assign('openGraphUseMetaDescription', (bool)$arrData['opengraph_use_meta_description']);
$this->template->assign('openGraphDescription', $arrData['opengraph_description']);
$this->template->assign('openGraphUseImage', (bool)$arrData['opengraph_use_image']);
// UPC
$this->template->assign('ProdUPC', $arrData['upc']);
// Google Checkout
$this->template->assign('ProdDisableGoogleCheckout', $arrData['disable_google_checkout']);
$GLOBALS['SaveAndAddAnother'] = GetLang('SaveAndAddAnother');
$this->setupProductLanguageString();
$this->template->display('product.form.tpl');
} else {
// The product doesn't exist
if ($GLOBALS["ISC_CLASS_ADMIN_AUTH"]->HasPermission(AUTH_Manage_Products)) {
$this->ManageProducts(GetLang('ProductDoesntExist'), MSG_ERROR);
} else {
$GLOBALS['ISC_CLASS_ADMIN_ENGINE']->DoHomePage(GetLang('Unauthorized'), MSG_ERROR);
}
}
}
protected function _GetCouponData($CouponId = 0, &$RefArray = array())
{
if ($CouponId == 0) {
$RefArray['couponid'] = (int)$_POST['couponId'];
$RefArray['couponname'] = $_POST['couponname'];
$RefArray['coupontype'] = $_POST['coupontype'];
$RefArray['couponamount'] = (int)$_POST['couponamount'];
$RefArray['couponminpurchase'] = CFloat($_POST['couponminpurchase']);
$RefArray['couponmaxuses'] = (int)$_POST['couponmaxuses'];
$RefArray['couponmaxusespercus'] = 0;
if (isset($_POST['couponmaxusespercus'])) {
$RefArray['couponmaxusespercus'] = (int)$_POST['couponmaxusespercus'];
}
if ($_POST['couponexpires'] != "") {
$RefArray['couponexpires'] = ConvertDateToTime($_POST['couponexpires']);
} else {
$RefArray['couponexpires'] = 0;
}
if (isset($_POST['couponenabled'])) {
$RefArray['couponenabled'] = 1;
} else {
$RefArray['couponenabled'] = 0;
}
if (isset($_POST['couponcode']) && $_POST['couponcode'] != "") {
$RefArray['couponcode'] = $_POST['couponcode'];
} else {
$RefArray['couponcode'] = GenerateCouponCode();
}
$RefArray['couponappliesto'] = $_POST['usedfor'];
if ($_POST['usedfor'] == "categories") {
$RefArray['couponappliestovalues'] = $_POST['catids'];
}
else {
$RefArray['couponappliestovalues'] = $_POST['prodids'];
}
// Restore data of shipping location restriction.
$RefArray['location_restricted'] = 0;
$RefArray['restrictedLocations'] = array();
$RefArray['restrictedLocationType'] = '';
if (!empty ($_POST['YesLimitByLocation']) && !empty ($_POST['LocationType'])) {
$RefArray['location_restricted'] = 1;
if (!empty ($_POST['LocationType'])) {
$RefArray['restrictedLocationType'] = $_POST['LocationType'];
if ($RefArray['restrictedLocationType'] == 'country'
&& !empty ($_POST['LocationTypeCountries'])
&& is_array($_POST['LocationTypeCountries'])) {
$countryList = GetCountryListAsIdValuePairs();
foreach ($_POST['LocationTypeCountries'] as $countryId) {
if(empty ($countryList[$countryId])) {
continue;
}
$RefArray['restrictedLocations'][] = array(
'coupon_id' => (int)$_POST['couponId'],
'selected_type' => $RefArray['restrictedLocationType'],
'value_id' => (int)$countryId,
'value' => $countryList[$countryId],
'country_id' => 0,
);
}
}
else if($RefArray['restrictedLocationType'] == 'state' && !empty ($_POST['LocationTypeStatesSelect'])) {
$countryList = GetCountryListAsIdValuePairs();
$stateList = array();
foreach($_POST['LocationTypeStatesSelect'] as $stateRecord) {
$state = explode('-', $stateRecord, 2);
if(!isset($stateList[$state[0]])) {
// Load the states in this country as we haven't done that before
$stateList[$state[0]] = array();
$query = "SELECT * FROM [|PREFIX|]country_states WHERE statecountry='".(int)$state[0]."'";
$result = $GLOBALS['ISC_CLASS_DB']->Query($query);
while($stateResult = $GLOBALS['ISC_CLASS_DB']->Fetch($result)) {
$stateList[$stateResult['statecountry']][$stateResult['stateid']] = $stateResult['statename'];
}
}
// Start storing what we received
if(isset($stateList[$state[0]][$state[1]])) {
$stateName = $stateList[$state[0]][$state[1]];
}
else {
$stateName = '';
}
$RefArray['restrictedLocations'][] = array(
'coupon_id' => (int)$_POST['couponId'],
'selected_type' => $RefArray['restrictedLocationType'],
'value' => $stateName,
'value_id' => (int)$state[1],
'country_id' => (int)$state[0],
);
}
}
else if($RefArray['restrictedLocationType'] == 'zip' && !empty ($_POST['LocationTypeZipPostCodes'])) {
$zipCodes = explode("\n", $_POST['LocationTypeZipPostCodes']);
foreach($zipCodes as $zipCode) {
$zipCode = trim($zipCode);
if(!$zipCode) {
continue;
}
$RefArray['restrictedLocations'][] = array(
'coupon_id' => (int)$_POST['couponId'],
'selected_type' => $RefArray['restrictedLocationType'],
'value' => $zipCode,
'value_id' => '0',
'country_id' => (int)$_POST['LocationTypeZipCountry'],
);
}
}
}
}
// Restore data of shipping method restriction.
$RefArray['shipping_method_restricted'] = 0;
$RefArray['restrictedShippingMethods'] = array();
if (!empty ($_POST['YesLimitByShipping'])) {
$RefArray['shipping_method_restricted'] = 1;
if (!empty ($_POST['LocationTypeShipping'])) {
foreach ($_POST['LocationTypeShipping'] as $shipper) {
$RefArray['restrictedShippingMethods'][] = $shipper;
}
}
}
} else {
// Get the data for this coupon code from the database
$query = sprintf("select * from [|PREFIX|]coupons where couponid='%s'", $GLOBALS['ISC_CLASS_DB']->Quote($CouponId));
$result = $GLOBALS["ISC_CLASS_DB"]->Query($query);
if ($row = $GLOBALS["ISC_CLASS_DB"]->Fetch($result)) {
$row['couponappliestovalues'] = "";
$RefArray = $row;
// get the prods/cats this applies to
$query = "SELECT * FROM [|PREFIX|]coupon_values WHERE couponid = '" . $GLOBALS['ISC_CLASS_DB']->Quote($CouponId) . "'";
$result = $GLOBALS["ISC_CLASS_DB"]->Query($query);
while ($valuerow = $GLOBALS['ISC_CLASS_DB']->Fetch($result)) {
$RefArray['couponappliestovalues'][] = $valuerow['valueid'];
}
// Get the restricted shipping location of the coupon
$RefArray['restrictedLocations'] = array();
$RefArray['restrictedLocationType'] = '';
$query = "
SELECT *
FROM [|PREFIX|]coupon_locations cl
WHERE cl.coupon_id = ".$GLOBALS['ISC_CLASS_DB']->Quote((int)$CouponId)."
ORDER BY cl.id
";
$locationResult = $this->db->query($query);
if ($locationResult) {
while($locationRow = $this->db->fetch($locationResult)) {
$RefArray['restrictedLocationType'] = $locationRow['selected_type'];
$RefArray['restrictedLocations'][] = $locationRow;
}
}
// Get the restricted shipping methods of the coupon
$RefArray['restrictedShippingMethods'] = array();
$query = "
SELECT *
FROM [|PREFIX|]coupon_shipping_methods
WHERE coupon_id = '" . $GLOBALS['ISC_CLASS_DB']->Quote($CouponId) . "'";
$shippingMethodResult = $GLOBALS["ISC_CLASS_DB"]->Query($query);
while ($shippingMethodsRow = $GLOBALS['ISC_CLASS_DB']->Fetch($shippingMethodResult)) {
$RefArray['restrictedShippingMethods'][] = $shippingMethodsRow['module_id'];
}
}
}
}
