/** * Webhook create product action. * * @return void * * @Route("/add", methods={"POST"}, name="import-product-add") */ public function addAction() { if (isset($_SERVER['HTTP_X_HARAVAN_HMAC_SHA256'])) { $myApp = AppModel::findFirstById(1); $hmac_header = $_SERVER['HTTP_X_HARAVAN_HMAC_SHA256']; $data = file_get_contents('php://input'); $verified = Utils::verify_webhook($data, $hmac_header, $myApp->sharedSecret); if ($verified) { $product = json_decode($data); $cleanData = strip_tags($product->body_html); $myStore = StoreModel::findFirst(['name = :storeName:', 'bind' => ['storeName' => $_SERVER['HTTP_HARAVAN_SHOP_DOMAIN']]]); // Create session information $this->session->get('oauth_token') != "" ? $this->session->get('oauth_token') : $this->session->set('oauth_token', $myStore->accessToken); $this->session->get('shop') != "" ? $this->session->get('shop') : $this->session->set('shop', $myStore->name); $this->session->get('sid') != "" ? $this->session->get('sid') : $this->session->set('sid', $myStore->id); // Get collection id from collect API $haravanCollection = EnHelper::getInstance('haravan', 'import')->getCollectsByProductId($product->id); // if category already mapped to five -> continue, else -> exit $myCategoryMap = CategoryMap::findFirst(['hid = :hid:', 'bind' => ['hid' => $haravanCollection[0]->collection_id]]); if (!$myCategoryMap) { exit; } $myProductQueue = ProductQueue::findFirst(['pid = :pid:', 'bind' => ['pid' => (int) $product->id]]); if ($myProductQueue == false) { $myProductQueue = new ProductQueue(); $myProductQueue->pid = (int) $product->id; $myProductQueue->pdata = json_encode($product, JSON_UNESCAPED_UNICODE); $myProductQueue->status = ProductQueue::STATUS_QUEUE; $myProductQueue->retryCount = 0; $myProductQueue->priority = 1; $myProductQueue->fcid = $myCategoryMap->fid; $myProductQueue->sid = $myStore->id; if ($myProductQueue->create()) { //Push to Beanstalk Queue $queue = $this->getDI()->get('queue'); $queue->choose('haraapp.import'); $addedToQueue = $queue->put([['storeId' => $myStore->id, 'haravanId' => $myCategoryMap->hid, 'haravanProductId' => $product->id], ['priority' => $myProductQueue->priority, 'delay' => 10, 'ttr' => 3600]]); if ($addedToQueue) { error_log($item->hid . ' - added to queue.'); $itemInQueue = $itemInQueue + 1; $itemList[] = $item->hid; } } else { foreach ($myProductQueue->getMessages() as $msg) { error_log($msg); } } } // insert table ADS $myAds = new AdsModel(); $myAds->assign(['uid' => $myStore->uid, 'udid' => "", 'rid' => $product->id, 'cid' => $myCategoryMap->fid, 'title' => $product->title, 'slug' => Utils::slug($product->title), 'description' => $cleanData, 'price' => $product->variants[0]->price, 'instock' => 1, 'cityid' => 0, 'districtid' => 0, 'status' => 1, 'isdeleted' => 0, 'seokeyword' => $product->tags, 'lastpostdate' => time()]); if ($myAds->create()) { $pass = true; // Insert table IMAGES if (isset($product->images)) { foreach ($product->images as $img) { $this->debug($img->src); $response = \Requests::get($img->src); if ($response->status_code == 200) { // Download image to local $filePart = explode('.', $img->filename); $namePart = $filePart[0]; $extPart = $filePart[1]; $path = rtrim($config->global->product->directory, '/\\') . '/' . date('Y') . '/' . date('m') . DIRECTORY_SEPARATOR; $fullPath = $config->global->staticFive . $path; $uploadOK = $filefive->put($path . $namePart . '.' . $extPart, (string) $response->body); // Resise image $myResize = new PhImage($fullPath . $namePart . '.' . $extPart); $orig_width = $myResize->getWidth(); $orig_height = $myResize->getHeight(); $height = $orig_height * 1200 / $orig_width; $mediumHeight = $orig_height * 600 / $orig_width; $smallHeight = $orig_height * 200 / $orig_width; $myResize->resize(1200, $height)->crop(1200, $height)->save($fullPath . $namePart . '.' . $extPart); $myResize->resize(600, $mediumHeight)->crop(600, $mediumHeight)->save($fullPath . $namePart . '-medium' . '.' . $extPart); $myResize->resize(200, $smallHeight)->crop(200, $smallHeight)->save($fullPath . $namePart . '-small' . '.' . $extPart); if ($uploadOK) { error_log("image upload ok"); // Save to db $myImage = new Images(); $myImage->assign(['aid' => $myAds->id, 'name' => $myAds->title, 'path' => $path . $namePart . '.' . $extPart, 'status' => Images::STATUS_ENABLE, 'orderNo' => $img->position]); if ($myImage->save()) { // Update first image to ads table if ($img->position == 1) { $myAds->image = $path . $namePart . '.' . $extPart; if ($myAds->update()) { error_log('Update first image to ads success'); } } } else { error_log("cannot save image!"); } } else { error_log("cannot download image!"); } } else { error_log("cannot get image url!"); } } } $imageName = strlen($myAds->image) > 0 ? $myAds->image : ""; // Save to product_map table $myProduct = new ProductMap(); $myProduct->assign(['sid' => $myStore->id, 'uid' => $myStore->uid, 'hid' => $data['haravanProductId'], 'aid' => $myAds->id, 'cid' => $myAds->cid, 'title' => $myAds->title, 'price' => $myAds->price, 'image' => $imageName, 'slug' => $myAds->slug, 'status' => $myAds->status]); if ($myProduct->create()) { error_log($myProduct->title . ' created success!'); } // Delete queued data. (Production) // $myProductQueue->delete(); } } } else { error_log('Request not from haravan'); } }
/** * Check category * * @return void */ public function categoryAction() { $myCategoryMap = CategoryMap::find(['status = :status:', 'bind' => ['status' => CategoryMap::STATUS_PENDING]]); if ($myCategoryMap) { foreach ($myCategoryMap as $item) { // Get all products from this category from haravan $myStore = Store::findFirstById($item->sid); $session = $this->getDI()->get('session'); $session->set('shop', $myStore->name); $session->set('oauth_token', $myStore->accessToken); $total = EnHelper::getInstance('haravan', 'import')->getTotalProductsByCollectionId((int) $item->hid); $totalPage = ceil($total / 50); // Using to count queued item. $itemInQueue = $item->totalItemQueue; $itemList = []; if ($totalPage >= 1) { for ($i = 1; $i <= $totalPage; $i++) { $myProducts = EnHelper::getInstance('haravan', 'import')->getProductsByCollectionId((int) $item->hid, $i); if ($myProducts) { foreach ($myProducts as $product) { $myProductQueue = ProductQueue::findFirst(['pid = :pid:', 'bind' => ['pid' => (int) $product->id]]); if ($myProductQueue == false) { $myProductQueue = new ProductQueue(); $myProductQueue->pid = (int) $product->id; $myProductQueue->pdata = json_encode($product, JSON_UNESCAPED_UNICODE); $myProductQueue->status = ProductQueue::STATUS_QUEUE; $myProductQueue->retryCount = 0; $myProductQueue->priority = 1; $myProductQueue->fcid = $item->fid; $myProductQueue->sid = $item->sid; if ($myProductQueue->create()) { //Push to Beanstalk Queue $queue = $this->getDI()->get('queue'); $queue->choose('haraapp.import'); $addedToQueue = $queue->put([['storeId' => $item->sid, 'haravanId' => $item->hid, 'haravanProductId' => $product->id], ['priority' => $myProductQueue->priority, 'delay' => 10, 'ttr' => 3600]]); if ($addedToQueue) { echo $item->hid . ' - added to queue.' . PHP_EOL; $itemInQueue = $itemInQueue + 1; $itemList[] = $item->hid; } } else { foreach ($myProductQueue->getMessages() as $msg) { print $msg . PHP_EOL; } } } } } } } //Save to category_map table total products of this category. $item->totalItem = (int) $total; $item->totalItemQueue = (int) $itemInQueue; $item->status = CategoryMap::STATUS_COMPLETED; if (count($itemList) > 0) { $item->data = json_encode($itemList); } $item->update(); // Insert current progress to product log table. $myProductLog = ProductLog::findFirst('status = ' . ProductLog::STATUS_CURRENT_PROCESSING . ' AND type = ' . ProductLog::TYPE_IMPORT . ' AND sid = ' . $myStore->id); $myProductLog->status = ProductLog::STATUS_COMPLETED; $myProductLog->update(); $myProductLog = new ProductLog(); $myProductLog->assign(['sid' => $item->sid, 'message' => 'Category Name ' . $item->fname . ' initialize Completed. Ready in Queue.', 'type' => ProductLog::TYPE_IMPORT, 'status' => ProductLog::STATUS_CURRENT_PROCESSING, 'class' => 'succcess']); $myProductLog->create(); } } else { print ConsoleUtil::success('No Category Pending found.') . PHP_EOL; exit(0); } }