function add_item_to_promotion() { connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME); $itemNumbers = $_POST['itemNumbers']; $promoCode = $_REQUEST['promoCode']; //echo "Item number = $itemNumber \nPromoCode = $promoCode"; //Calculate sale price $promoType = getPromoType($promoCode); $amountOff = getAmountOff($promoCode); $message = ""; if (empty($itemNumbers)) { $message .= "Error: No Items Selected."; } else { $count = count($itemNumbers); $message .= "{$count} Items selected to be added to Promotion.<br />"; foreach ($itemNumbers as $itemNumber) { if (!itemExistsAlreadyInPromotion($itemNumber, $promoCode)) { $item_retail_price = getItemRetailPrice($itemNumber); //echo "retail price : $item_retail_price \n promotype: $promoType \n amount off: $amountOff"; $salePrice = getSalePrice($item_retail_price, $promoType, $amountOff); $insertStmt = "INSERT INTO PromotionItem (PromoCode, ItemNumber, SalePrice) values ( '{$promoCode}','{$itemNumber}', '{$salePrice}')"; $result = mysql_query($insertStmt); if (!$result) { $message .= "Error adding Item to Promotion. <br />Promo Code: {$promoCode}<br />Item Number:\n {$itemNumber}<br />Sale Price: {$salePrice}<br /><br />" . mysql_error() . "<br />"; } else { $message .= "Item added to Promotion successfully.<br />Promo Code: {$promoCode}<br />Item Number:\n {$itemNumber}<br />Sale Price: {$salePrice}<br /><br />"; } } else { $message .= "Item (Item Number: {$itemNumber}) already exists in Promotion (Promo Code: {$promoCode}).<br /><br />"; } } } ui_show_promotion_item_insert_result($message); }
$imgStr = ''; $sizeArray = array(); $packArray = array(); $category = $value['category']; if ($category == 'active-wear') { $category = 'activewear'; } $subcategory = $value['subcategory']; $tempData = json_decode($value['data'], TRUE); /*Get Category String*/ $category = getCategory($value['category'], $value['subcategory'], $tempData['title'][0]); $subCategory = getSubCategory($value['category'], $value['subcategory'], $tempData['title'][0]); $categoryStr = getCategoryString($category, $subCategory); /*Get dimension*/ $dimension = getDimensions($category, $subcategory); $csvData[$count]['category'] = $category; $csvData[$count]['subCategory'] = $subCategory; $csvData[$count]['category_str'] = $categoryStr; $csvData[$count]['price'] = getSalePrice(str_replace('$', '', trim($tempData['price']))); $csvData[$count]['weight'] = $dimension['weight']; $csvData[$count]['auctioninc_product_length'] = $dimension['length']; $csvData[$count]['auctioninc_product_width'] = $dimension['width']; $csvData[$count]['auctioninc_product_height'] = $dimension['height']; $csvData[$count++]['prod_url'] = $value['url']; } // Writing Header fputcsv($fp, array_keys($csvData[0])); foreach ($csvData as $data) { fputcsv($fp, $data); } fclose($fp);
$csvData[$count]['auctioninc_calc_method'] = 'C'; $csvData[$count]['attribute_set'] = 'Default'; $csvData[$count]['configurable_attributes'] = 'leggingscolor'; /*Setting size*/ $csvData[$count]['leggingspacksize'] = implode(",", array_keys($packArray)); $csvData[$count]['leggingspackqty'] = implode(",", $packArray); $csvData[$count]['prod_url'] = $value['url']; $csvData[$count++]['leggingscolor'] = $color['color']; } /*Config Prodcut Price*/ $totalQty = 0; foreach ($packArray as $q) { $totalQty += $q; } // Config Price $configPrice = getSalePrice($tempData['price']) * $totalQty; $configLength = $dimension['length']; $configWidth = $dimension['width']; $configHeight = $dimension['height']; $configWeight = $dimension['weight']; /*Create configurable Product*/ $csvData[$count]['sku'] = 'WL#' . $value['id']; $csvData[$count]['bin_location'] = ''; $csvData[$count]['type'] = 'configurable'; $csvData[$count]['store'] = 'default'; $csvData[$count]['name'] = $tempData['title']; $csvData[$count]['description'] = $tempData['title']; $csvData[$count]['short_description'] = $tempData['title']; $csvData[$count]['price'] = $configPrice; $csvData[$count]['qty'] = $qty; $csvData[$count]['weight'] = $configWeight;
<?php function getSalePrice($costPrice) { return (ceil($costPrice * 2) - 1) / 2 + 2.25; } $priceList = array('2.14', '3.14', '.9', '.75', '0.1'); foreach ($priceList as $price) { echo $price . '----------------' . getSalePrice($price) . "\r\n"; }
$imgStr = ''; $sizeArray = array(); $packArray = array(); $category = $value['category']; if ($category == 'active-wear') { $category = 'activewear'; } $subcategory = $value['subcategory']; $tempData = json_decode($value['data'], TRUE); /*Get Category String*/ $category = getCategory($value['category'], $value['subcategory'], $tempData['title']); $subCategory = getSubCategory($value['category'], $value['subcategory'], $tempData['title']); $categoryStr = getCategoryString($category, $subCategory); /*Get dimension*/ $dimension = getDimensions($category, $subcategory); $csvData[$count]['category'] = $category; $csvData[$count]['subCategory'] = $subCategory; $csvData[$count]['category_str'] = $categoryStr; $csvData[$count]['price'] = getSalePrice($tempData['price']); $csvData[$count]['weight'] = $dimension['weight']; $csvData[$count]['auctioninc_product_length'] = $dimension['length']; $csvData[$count]['auctioninc_product_width'] = $dimension['width']; $csvData[$count]['auctioninc_product_height'] = $dimension['height']; $csvData[$count++]['prod_url'] = $value['url']; } // Writing Header fputcsv($fp, array_keys($csvData[0])); foreach ($csvData as $data) { fputcsv($fp, $data); } fclose($fp);
$packSizeArray = array(); $tempData = json_decode($value['data'], TRUE); foreach ($tempData['images'] as $img) { $imgMain = str_replace(array(",", '\'', '"'), "", $img); $imgStr .= $value['id'] . '_wl_' . basename($imgMain) . ";"; // download_remote_file_with_curl(trim('http://numberonewholesales.com/'.$imgMain), $value['id']); } // $categoryStr = getCategory($value['category'],''); /*Get Category String*/ $categoryStr = getCategoryString($value['category'], $value['subcategory'], $tempData['title'][0]); $temp = explode('/', $categoryStr); $category = $temp[0]; $subCategory = isset($temp[1]) ? $temp[1] : ''; /*Get dimension*/ $dimension = getDimensions($category, $subCategory); $price = getSalePrice(str_replace('$', '', trim($tempData['price']))); $pack = isset($tempData['pack']) ? $tempData['pack'] : ''; $removableChars = array(" ", "_", ":", ";"); $pack = str_replace('<br>', '', $pack); $tpack = strtolower(trim(str_replace($removableChars, "-", $pack))); $qtyExist = false; if (strpos($tpack, 'onesize') !== false || strpos($tpack, 'one-size') !== false) { $packSizeArray = array(0 => 'onesize'); $packQtyArray = $tempData['packValue']; } else { if ($pack == 'One Size') { $packSizeArray = array(0 => 'onesize'); $packQtyArray = $tempData['packValue']; } else { /*Pack details*/ $packData = explode('-', $pack);