function getProductData($goutte, $url, $db)
{
$crawler = $goutte->request('GET', $url);
$status_code = $goutte->getResponse()->getStatus();
$data = array();
if ($status_code == 200) {
$attribs = array();
$domSelector = '//*[@class="productInfoName"]';
$attribs['title'] = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->text();
});
$domSelector = '//*[@id="zoom1-big"]';
$attribs['mainImage'] = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->attr('href');
});
$domSelector = '//*[@id="Zoom1"]';
$attribs['images'] = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->attr('href');
});
$packValueReg = '//*[@class="Quantity_box_pack"]';
$attribs['packValue'] = $data = $crawler->filterXPath($packValueReg)->each(function ($node) {
return $node->attr('value');
});
$domSelector = '//*[@class="main_table"]/tr/td[2]';
$data = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->html();
});
foreach ($data as $key => $value) {
/*Style Number*/
$styleReg = '.*?<td.*?>Style.*?<td.*?><span.*?>(.*?)</span>.*?</td>.*?';
preg_match('|' . $styleReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['style'] = $match[1];
}
// Get price
$priceReg = '.*?<td.*?>Price.*?<td.*?>(.*?)</td>.*?';
preg_match('|' . $priceReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['price'] = $match[1];
}
// Get stock
$stockReg = '.*?<td.*?>Stock.*?<td.*?>(.*?)</td>.*?';
preg_match('|' . $stockReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['stock'] = $match[1];
}
/*Fabric Reg*/
$fabricReg = '.*?class="productInfo".*?<p>(.*?)</p>.*?';
preg_match('|' . $fabricReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['fab'] = $match[1];
}
/*Pack Reg*/
$packReg = '.*?Pack Only.*?class="productInfoTitle" bgcolor="#EEEEEE".*?>(.*?)<input type="text".*?</td>';
preg_match('|' . $packReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['pack'] = $match[1];
}
$colorReg = '.*?</script>.*?productInfoContents">(.*?)</td>.*?';
preg_match_all('|' . $colorReg . '|smi', $value, $match, PREG_PATTERN_ORDER);
if (isset($match[1])) {
$attribs['colors'] = $match[1];
}
$stockReg = '.*?</script>.*?productInfoContents">.*?productInfoContents">.*?productInfoContents">(.*?)</td>.*?';
preg_match_all('|' . $stockReg . '|smi', $value, $match, PREG_PATTERN_ORDER);
if (isset($match[1])) {
$attribs['temp_stock'] = $match[1];
}
$attribs['stock'] = array();
foreach ($attribs['temp_stock'] as $key => $value) {
$color = trim($attribs['colors'][$key]);
$attribs['stock'][$color] = trim($value) == 'Sold Out' ? 0 : 100;
}
unset($attribs['temp_stock']);
}
$category = getCategoryFromUrlOrTitle($url, $attribs['title']);
/*Insert Product*/
$db->query("INSERT INTO products_data(url,url_hash,source,data,category,subcategory,status) \n\t\t\t \t\t\tVALUES(:url,:url_hash,:source,:data,:category,:subcategory,:status)\n\t\t\t \t\t\tON DUPLICATE KEY UPDATE updated_on = NOW();", array("url" => $url, "url_hash" => hash('ripemd160', $url), "source" => "numberonewholesales", "data" => json_encode($attribs), "category" => $category, "subcategory" => '', "status" => 1));
$db->query("UPDATE products_data SET status=1 WHERE url_hash='" . hash('ripemd160', $url) . "'");
}
}
function getProductData($goutte, $url, $db)
{
$crawler = $goutte->request('GET', $url);
$status_code = $goutte->getResponse()->getStatus();
$data = array();
if ($status_code == 200) {
$attribs = array();
$domSelector = '//*[@class="productInfoName"]';
$attribs['title'] = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->text();
});
$domSelector = '//*[@id="zoom1-big"]';
$attribs['mainImage'] = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->attr('href');
});
$domSelector = '//*[@id="Zoom1"]';
$attribs['images'] = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->attr('href');
});
$packValueReg = '//*[@class="Quantity_box_pack"]';
$attribs['packValue'] = $data = $crawler->filterXPath($packValueReg)->each(function ($node) {
return $node->attr('value');
});
$domSelector = '//*[@class="main_table"]/tr/td[2]';
$data = $data = $crawler->filterXPath($domSelector)->each(function ($node) {
return $node->html();
});
foreach ($data as $key => $value) {
/*Style Number*/
$styleReg = '.*?<td.*?>Style.*?<td.*?><span.*?>(.*?)</span>.*?</td>.*?';
preg_match('|' . $styleReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['style'] = $match[1];
}
// Get price
$priceReg = '.*?<td.*?>Price.*?<td.*?>(.*?)</td>.*?';
preg_match('|' . $priceReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['price'] = $match[1];
}
// Get stock
$stockReg = '.*?<td.*?>Stock.*?<td.*?>(.*?)</td>.*?';
preg_match('|' . $stockReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['stock'] = $match[1];
}
/*Fabric Reg*/
$fabricReg = '.*?class="productInfo".*?<p>(.*?)</p>.*?';
preg_match('|' . $fabricReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['fab'] = $match[1];
}
/*Pack Reg*/
$packReg = '.*?Pack Only.*?class="productInfoTitle" bgcolor="#EEEEEE".*?>(.*?)<input type="text".*?</td>';
preg_match('|' . $packReg . '|smi', $value, $match);
if (isset($match[1])) {
$attribs['pack'] = $match[1];
}
$colorReg = '.*?</script>.*?productInfoContents">(.*?)</td>.*?';
preg_match_all('|' . $colorReg . '|smi', $value, $match, PREG_PATTERN_ORDER);
if (isset($match[1])) {
$attribs['colors'] = $match[1];
}
$stockReg = '.*?</script>.*?productInfoContents">.*?productInfoContents">.*?productInfoContents">(.*?)</td>.*?';
preg_match_all('|' . $stockReg . '|smi', $value, $match, PREG_PATTERN_ORDER);
if (isset($match[1])) {
$attribs['temp_stock'] = $match[1];
}
$attribs['stock'] = array();
foreach ($attribs['temp_stock'] as $key => $value) {
$color = trim($attribs['colors'][$key]);
$attribs['stock'][$color] = trim($value) == 'Sold Out' ? 0 : 100;
}
unset($attribs['temp_stock']);
}
$category = getCategoryFromUrlOrTitle($url, $attribs['title']);
print_r($attribs);
/*Insert Product*/
}
}
