/** * Proccess a file and store the files elements in a DobaProduts object * @static method * @return * @param $file string : full path to file on server * @param $type string : "tab" or "csv" */ function processFile($file, $type) { $delm = ''; $DobaProds = new DobaProducts(); $headers; $fp = fopen($file, 'r'); $delm = $type == 'csv' ? ',' : "\t"; if (!feof($fp)) { $data = fgets($fp); $tHeaders = explode($delm, $data); foreach ($tHeaders as $item) { $headers[] = DobaProductFile::pruneQuotes(strtoupper(trim($item))); } } while (!feof($fp)) { $values = DobaProductFile::parseLine(fgets($fp), $delm); /* Fields to fill in on the osCommerce add product page * Products Status: In Stock, Out of Stock . Passing the current available in the object, needs to be processed before being added to database * Date Available / * Products Manufacturer / * Products Name (English, Spanish, Ducth) / * Tax Class: none, taxable goods . Default to Taxable, will need setting in the osCommerce config files * Products Price (Net) . Will use the MSRP for now. * Products Description (English, Spanish, Ducth) / * Products Quantity . Will just use the amount in the file till a better solution is found * Products Model / = Product SKU * Products Image . Will need more processing while the object in being added to the database * Products URL (English, Spanish, Ducth) / Leaveing blank * Products Weight / */ $tempDPD = new DobaProductData(); $temp = array_keys($headers, 'PRODUCT_ID'); $tempDPD->product_id($values[$temp[0]]); $temp = array_keys($headers, 'ITEM_ID'); $tempDPD->item_id($values[$temp[0]]); $temp = array_keys($headers, 'TITLE'); $tempDPD->title(DobaProductFile::pruneQuotes($values[$temp[0]])); $temp = array_keys($headers, 'DESCRIPTION'); $descr = DobaProductFile::pruneQuotes($values[$temp[0]]); $temp = array_keys($headers, 'DETAILS'); $details = DobaProductFile::pruneQuotes($values[$temp[0]]); if (!empty($descr) && !empty($details)) { $descr .= '<br><br>' . $details; } else { $descr .= $details; } $tempDPD->description($descr); $temp = array_keys($headers, 'QTY_AVAIL'); $supplied_qty = $values[$temp[0]]; $temp = array_keys($headers, 'IMAGE_URL'); $tempDPD->image_url(DobaProductFile::pruneQuotes($values[$temp[0]])); $temp = array_keys($headers, 'WEIGHT'); $tempDPD->ship_weight($values[$temp[0]]); $temp = array_keys($headers, 'SKU'); $tempDPD->product_sku(DobaProductFile::pruneQuotes($values[$temp[0]])); $temp = array_keys($headers, 'PRICE'); $wholesale = $values[$temp[0]]; $temp = array_keys($headers, 'MAP'); $map = $values[$temp[0]]; $temp = array_keys($headers, 'MSRP'); $msrp = $values[$temp[0]]; /* * This set of if statements checks if the specified pricing manipulation fields exist * in the file. If they do, the column header name and the value of the field are sent * as parameters to DobaInteraction::setPrice(). The supplied wholesale cost, the map price * and the msrp are also sent as parameters and used in setPrice() to ensure the correct * price is calculated. */ if (in_array('OSC_WHOLESALE_MARKUP_PERCENT', $headers)) { $temp = array_keys($headers, 'OSC_WHOLESALE_MARKUP_PERCENT'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_WHOLESALE_PERCENT, $values[$temp[0]], $wholesale, $map, $msrp)); } else { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_NONE, $wholesale, $wholesale, $map, $msrp)); } } elseif (in_array('OSC_WHOLESALE_MARKUP_DOLLAR', $headers)) { $temp = array_keys($headers, 'OSC_WHOLESALE_MARKUP_DOLLAR'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_WHOLESALE_DOLLAR, $values[$temp[0]], $wholesale, $map, $msrp)); } else { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_NONE, $wholesale, $wholesale, $map, $msrp)); } } elseif (in_array('OSC_MARKUP_EXACT', $headers)) { $temp = array_keys($headers, 'OSC_MARKUP_EXACT'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_EXACT, $values[$temp[0]], $wholesale, $map, $msrp)); } else { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_NONE, $wholesale, $wholesale, $map, $msrp)); } } elseif (in_array('OSC_MSRP_MARKUP_PERCENT', $headers)) { $temp = array_keys($headers, 'OSC_MSRP_MARKUP_PERCENT'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_MSRP_PERCENT, $values[$temp[0]], $wholesale, $map, $msrp)); } else { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_NONE, $wholesale, $wholesale, $map, $msrp)); } } elseif (in_array('OSC_MSRP_MARKUP_DOLLAR', $headers)) { $temp = array_keys($headers, 'OSC_MSRP_MARKUP_DOLLAR'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_MSRP_DOLLAR, $values[$temp[0]], $wholesale, $map, $msrp)); } else { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_NONE, $wholesale, $wholesale, $map, $msrp)); } } else { $tempDPD->price(DobaInteraction::setPrice(PRICE_FMT_NONE, $wholesale, $wholesale, $map, $msrp)); } /* * This set of if statements checks if the specified quantity manipulation fields exist * in the file. If they do, the column header name and the value of the field are sent * as parameters to DobaInteraction::setQuantity(). The supplied quantity is also * sent as a parameter and used in setQuantity() to ensure the correct quantity is calculated. */ if (in_array('OSC_QUANTITY_AUTOADJUST', $headers)) { $temp = array_keys($headers, 'OSC_QUANTITY_AUTOADJUST'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->quantity(DobaInteraction::setQuantity(QTY_FMT_AUTOADJUST, $values[$temp[0]], $supplied_qty)); } else { $tempDPD->quantity(DobaInteraction::setQuantity(QTY_FMT_NONE, $supplied_qty, $supplied_qty)); } } elseif (in_array('OSC_QUANTITY_EXACT', $headers)) { $temp = array_keys($headers, 'OSC_QUANTITY_EXACT'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->quantity(DobaInteraction::setQuantity(QTY_FMT_EXACT, $values[$temp[0]], $supplied_qty)); } else { $tempDPD->quantity(DobaInteraction::setQuantity(QTY_FMT_NONE, $supplied_qty, $supplied_qty)); } } else { $tempDPD->quantity(DobaInteraction::setQuantity(QTY_FMT_NONE, $supplied_qty, $supplied_qty)); } /* * if the OSC_CATEGORY field exists, the category name is loaded into the DobaProductsData * object so that it can be processed. */ if (in_array('OSC_CATEGORY', $headers)) { $tempCategory = array_keys($headers, 'OSC_CATEGORY'); if (isset($values[$tempCategory[0]]) && !empty($values[$tempCategory[0]])) { $tempDPD->category_name(DobaProductFile::pruneQuotes($values[$tempCategory[0]])); } } $temp = array_keys($headers, 'BRAND'); $tempDPD->brand(DobaProductFile::pruneQuotes($values[$temp[0]])); /* * if the OSC_BRAND field exists, the brand name is loaded into the DobaProductsData * object so that it can be processed. */ if (in_array('OSC_BRAND', $headers)) { $tempBrand = array_keys($headers, 'OSC_BRAND'); if (isset($values[$tempBrand[0]]) && !empty($values[$tempBrand[0]])) { $tempDPD->brand(DobaProductFile::pruneQuotes($values[$tempBrand[0]])); } } /* * if the OSC_PRODUCT_LINK field exists, the brand name is loaded into the DobaProductsData * object so that it can be processed. */ if (in_array('OSC_PRODUCT_LINK', $headers)) { $temp = array_keys($headers, 'OSC_PRODUCT_LINK'); if (isset($values[$temp[0]]) && !empty($values[$temp[0]])) { $tempDPD->product_url(DobaProductFile::pruneQuotes($values[$temp[0]])); } } $DobaProds->addProduct($tempDPD); } fclose($fp); return $DobaProds; }
<?php ini_set('include_path', ini_get('include_path') . ':' . $_SERVER['DOCUMENT_ROOT'] . '/admin/includes/'); include_once 'doba/DobaProductData.php'; include_once 'doba/DobaProducts.php'; $tempData = array('product_id' => 1234, 'title' => 'the title of the product', 'product_sku' => 'the sku of the product', 'upc' => 'the upc of the product', 'brand' => 'the brand name of the product', 'description' => 'a description of the product', 'ship_width' => 12, 'ship_height' => 12, 'ship_weight' => 12, 'ship_cost' => 12, 'image_url' => 'www.photodumby.foo', 'thumb_url' => 'www.photodumby2.foo', 'image_height' => 12, 'image_width' => 2, 'last_update' => '2008-01-02 11:54:02', 'items' => array()); $dpd = new DobaProductData(); echo "<ul>"; echo "<li>\"" . $dpd->product_id($tempData['product_id']) . "\" should be \"" . $tempData['product_id'] . "\"</li>"; echo "<li>\"" . $dpd->title($tempData['title']) . "\" should be \"" . $tempData['title'] . "\"</li>"; echo "<li>\"" . $dpd->product_sku($tempData['product_sku']) . "\" should be \"" . $tempData['product_sku'] . "\"</li>"; echo "<li>\"" . $dpd->upc($tempData['upc']) . "\" should be \"" . $tempData['upc'] . "\"</li>"; echo "<li>\"" . $dpd->brand($tempData['brand']) . "\" should be \"" . $tempData['brand'] . "\"</li>"; echo "<li>\"" . $dpd->description($tempData['description']) . "\" should be \"" . $tempData['description'] . "\"</li>"; echo "</ul>"; echo "<p>Done</p>"; $dpdAry = new DobaProducts(); echo "<p>" . ($dpdAry->productExists($tempData['product_id']) ? 'Product added' : 'Product not added') . "</p>"; $dpdAry->addProduct($dpd); echo "<p>" . ($dpdAry->productExists($tempData['product_id']) ? 'Product added' : 'Product not added') . "</p>";