public function save($id, ProductSaveRequest $request)
{
$product = $this->productRepository->getById($id);
if (!$product) {
$product = new AmazonProduct();
}
$product->fill($request->all());
Auth::user()->products()->save($product);
return $this->json->success('Product Saved Successfully ...');
}
public function process($fileContents)
{
//set_time_limit( 800 );
$fileLines = explode("\r\n", $fileContents);
$maxLineCount = count($fileLines);
$user = Auth::user();
for ($x = 0; $x < $maxLineCount; $x++) {
if ($x == 0) {
continue;
}
$lineArray = explode("\t", $fileLines[$x]);
$customerEmail = @$lineArray[10];
$customerName = @$lineArray[11];
$amazonOrderId = @$lineArray[0];
$recipientName = @$lineArray[24];
$amazonOrderItemId = @$lineArray[4];
$itemQuantity = @$lineArray[15];
$productSku = @$lineArray[13];
$productName = @$lineArray[14];
$productPrice = @$lineArray[17];
$shipAddress1 = @$lineArray[25];
$shipAddress2 = @$lineArray[26];
$shipAddress3 = @$lineArray[27];
$shipCity = @$lineArray[28];
$shipState = @$lineArray[29];
$shipPostalCode = @$lineArray[30];
$shipCountry = @$lineArray[31];
$carrier = @$lineArray[42];
$trackingNumber = @$lineArray[43];
$itemPromotionDiscount = @$lineArray[40];
$customer = Customer::where('email', '=', $customerEmail)->where('user_id', '=', $user->id)->first();
if (!$customer) {
$customer = new Customer();
$customer->fill(['email' => $customerEmail, 'name' => $customerName]);
$customer = $user->customers()->save($customer);
} else {
$customer->name = $customerName;
$customer->save();
}
$transaction = Transaction::where('amazon_order_id', '=', $amazonOrderId)->where('customer_id', '=', $customer->id)->first();
if (!$transaction) {
$transaction = new Transaction();
$transactionData = ['amazon_order_id' => $amazonOrderId, 'recipient_name' => $recipientName, 'ship_address_1' => $shipAddress1, 'ship_address_2' => $shipAddress2, 'ship_address_3' => $shipAddress3, 'ship_city' => $shipCity, 'ship_state' => $shipState, 'ship_postal_code' => $shipPostalCode, 'ship_postal_country' => $shipCountry, 'carrier' => $carrier, 'tracking_number' => $trackingNumber];
$transaction->fill($transactionData);
$transaction = $customer->transactions()->save($transaction);
} else {
$transaction->recipient_name = $recipientName;
$transaction->save();
}
$productSku = str_replace('-', '', $productSku);
// Products ...
$product = AmazonProduct::whereSku($productSku)->where('user_id', '=', $user->id)->first();
if (!$product) {
$product = new AmazonProduct();
$product->fill(['sku' => $productSku, 'name' => $productName, 'price' => $productPrice]);
$product = $user->products()->save($product);
} else {
$product->name = $productName;
$product->price = $productPrice;
$product->save();
}
if ($itemPromotionDiscount != 0) {
$payout = $itemQuantity * ($product->price - $itemPromotionDiscount);
} else {
$payout = $itemQuantity * $product->price;
}
$transactionItem = TransactionItem::whereAmazonOrderItemId($amazonOrderItemId)->where('transaction_id', '=', $transaction->id)->first();
if (!$transactionItem) {
$transactionItem = new TransactionItem();
$arrayData = ['amazon_product_id' => $product->id, 'amazon_order_item_id' => $amazonOrderItemId, 'quantity' => $itemQuantity, 'payout' => $payout];
$transactionItem->fill($arrayData);
$transaction->items()->save($transactionItem);
} else {
$transactionItem->amazon_product_id = $product->id;
$transactionItem->quantity = $itemQuantity;
$transactionItem->payout = $payout;
$transactionItem->save();
}
}
return $this->json->success('SUCCESS!!! Import data done ....');
}