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);
