When to use eloquent upserts

You’ve probably come across a situation before where you needed to do some kind of mass update or sync with external data. A naive way you might approach this could be similar to below.

collect($csvContacts)->each(function (array $row) {
    $contact = Contact::updateOrCreate(
        ['email' => $row['email']],
        ['name' => $row['name'], 'address' => $row['address']]
    );
});

Under the hood, this will make 2 queries for each record. First, it will find the first row matching all of the key/value pairs in the first array. If a row already exists, it will update it, otherwise a new row is inserted.

With small imports this will work fine, but imagine you had 100,000 rows in your CSV. This would result in 200,000 queries, which is going to take forever.

Using Upserts

When using upserts a single query is made containing all the rows. This query includes on duplicate key update on MySQL and on conflict ... do update set on Postgres which instructs the database to update records if they already exist in the database.

It’s important to note that you must have either a primary or unique index on the column you are upserting so the database. If you forget to add the index you’ll get an error.

Obviously, making a single query is much more efficient and lets the database internally compute duplicate rows (which is very quick since you have an index on the column).

It’s also a good idea to chunk these queries into blocks, especially if your queries are inserting/updating lots of data. If you don’t do this, you may hit query size limits on some databases.

collect($csvContacts)
    ->map(function (array $row) {
        return Arr::only($row, ['email', 'name', 'address']);
    })
    ->chunk(1000)
    ->each(function (Collection $chunk) {
        Contact::upsert($chunk, 'email');
    });

Additional Reading

Documentation
Framework PR

If you are interested to integrate PayPal plus with Laravel 8, this tutorial will help you a lot. Today, I will guide you on how to integrate PayPal Plus with Laravel. Let’s get started.

Requirements

PayPal Account

You need to have a Paypal account in order to process.

Create Sandbox Accounts.

Navigate to Sandbox > Accounts then click on the blue color Create Account button.
On the popup box, set

• Account Type: Business
• Country: Brazil

Create Sandbox App

Navigate to Sandbox > My Apps & Credentials click on the blue color Create App button.
In the form,

• Set an app name. It can be anything you want.
• Choose newly created sandbox business email.

Get APP Credentials

Once you have done successfully, navigate to the newly created app. You should able to see Client ID and Client Secret for the app.

Generate Fake Credit Card

Navigate to Mock > Credit Card Generator and then create a credit card. It will give you a card number, expired date and CVV.

Laravel Integration

Let’s dig into laravel application now.

Step 1: Define Routes:

Go to web.php file and define a GET route /paypal.

Route::get('paypal', [PayPalController::class, 'index']);

Step 2: Create Controller:

Now let’s create a controller called PayPalController.

php artisan make:controller PayPalController

In the index() method, first, let’s send a request for creating the payment request as described in the documentation

    public function index()
    {
        $clientId = "PayPal Private Key";
        $secret = "PayPal Public Key";

        // Get Bearer Token
        $ch = curl_init();

        curl_setopt($ch, CURLOPT_URL, "https://api.sandbox.paypal.com/v1/oauth2/token");
        curl_setopt($ch, CURLOPT_HEADER, false);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_SSLVERSION , 6);
        curl_setopt($ch, CURLOPT_POST, true);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); 
        curl_setopt($ch, CURLOPT_USERPWD, $clientId.":".$secret);
        curl_setopt($ch, CURLOPT_POSTFIELDS, "grant_type=client_credentials");

        $token = json_decode(curl_exec($ch), true);
        $bearerToken = $token['access_token'];

        $total = 121;

        $postData = [
            'intent' => 'sale',
            'payer' => [
                'payment_method' => 'paypal',
            ],
                'transactions' => [
                    0 => [
                        'amount' => [
                            'currency' => 'BRL',
                            'total' => $total,
                            'details' => [
                                'shipping' => '0',
                                'subtotal' => $total,
                                'shipping_discount' => '0.00',
                                'insurance' => '0.00',
                                'handling_fee' => '0.00',
                                'tax' => '0.00',
                            ],
                        ],
                    'description' => 'This is the payment transaction description',
                    'payment_options' => [
                        'allowed_payment_method' => 'IMMEDIATE_PAY',
                    ],
                    'item_list' => [
                        'shipping_address' => [
                            'recipient_name' => 'PP Plus Recipient',
                            'line1' => 'Gregório Rolim de Oliveira, 42',
                            'line2' => 'JD Serrano II',
                            'city' => 'Votorantim',
                            'country_code' => 'BR',
                            'postal_code' => '18117-134',
                            'state' => 'São Paulo',
                            'phone' => '0800-761-0880',
                        ],
                        'items' => [
                            0 => [
                                'name' => 'handbag',
                                'description' => 'red diamond',
                                'quantity' => '1',
                                'price' => $total,
                                'tax' => '0',
                                'sku' => 'product34',
                                'currency' => 'BRL',
                            ],
                        ],
                    ],
                ],
            ],
            'redirect_urls' => [
                'return_url' => 'https://example.com/return',
                'cancel_url' => 'https://example.com/cancel',
            ],
        ];

        // Send request for Permission
        $ch = curl_init();

        curl_setopt($ch, CURLOPT_URL, 'https://api.sandbox.paypal.com/v1/payments/payment');
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($postData));

        $headers = array();
        $headers[] = 'Content-Type: application/json';
        $headers[] = 'Authorization: Bearer ' . $bearerToken;
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

        $result = curl_exec($ch);
        if (curl_errno($ch)) {
            echo 'Error:' . curl_error($ch);
        }

       $paymentData = json_decode($result, true);

       return view("paypal-plus")
            ->with('paymentData', $paymentData);
    }

Create a view page

Now, let’s create a view page called resources/views/paypal-plus.blade.php for rendering the paypal form.

    <script src="https://www.paypalobjects.com/webstatic/ppplusdcc/ppplusdcc.min.js" type="text/javascript">
    </script>

    <div id="ppplus"></div>

    <input type="hidden" id="paypal_approval_url" value="">
    <input type="hidden" id="paypal_payment_id" value="">

    <script type="application/javascript">
        var approvalUrl = document.getElementById('paypal_approval_url').value;
        var paymentId = document.getElementById('paypal_payment_id').value;

        var ppp = PAYPAL.apps.PPP({
            "approvalUrl": approvalUrl,
            "placeholder": "ppplus",
            "mode": "sandbox",
            "payerEmail": "[email protected]",
            "payerFirstName": "Thouhedul",
            "payerLastName": "Islam",
            "payerTaxId": "424.159.708-40",
            "country": "BR",
            "collectBillingAddress": false,
            onContinue: function (rememberedCards, payerId, token, term) {
                window.location = 'http://127.0.0.1:8000/paypal-approval?rememberedCards='
                    + rememberedCards 
                    + '&payerId=' + payerId
                    + '&token=' + token
                    + '&term=' + term
                    + '&paymentId=' + paymentId;
            },
        });
    </script>

    <button
        type="submit"
        id="continueButton"
        onclick="ppp.doContinue(); return false;"> Checkout
    </button>

Note here, I have set a redirect location once user submit the form. So, let’s define a new route for that.

Define route for redirect location

Route::get('paypal-approval', [PayPalController::class, 'post']);

Create Post Method

To process, let’s create a method called post().
$clientId = “PayPal Public ID”;
$secret = “PayPal Private ID”;

    public function post()
    {
        $payerId = request()->payerId;
        $rememberedCards = request()->rememberedCards;
        $token = request()->token;
        $paymentId = request()->paymentId;

        $clientId = "PayPal Private Key";
        $secret = "PayPal Public Key";

        // Get Bearer Token
        $btCh = curl_init();

        curl_setopt($btCh, CURLOPT_URL, "https://api.sandbox.paypal.com/v1/oauth2/token");
        curl_setopt($btCh, CURLOPT_HEADER, false);
        curl_setopt($btCh, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($btCh, CURLOPT_SSLVERSION , 6);
        curl_setopt($btCh, CURLOPT_POST, true);
        curl_setopt($btCh, CURLOPT_RETURNTRANSFER, true); 
        curl_setopt($btCh, CURLOPT_USERPWD, $clientId.":".$secret);
        curl_setopt($btCh, CURLOPT_POSTFIELDS, "grant_type=client_credentials");

        $token = json_decode(curl_exec($btCh), true);
        $bearerToken = $token['access_token'];

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, "https://api.sandbox.paypal.com/v1/payments/payment/$paymentId/execute");
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, "{\n  \"payer_id\": \"$payerId\"\n}");

        $headers = array();
        $headers[] = 'Content-Type: application/json';
        $headers[] = 'Authorization: Bearer ' . $bearerToken;
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

        $result = curl_exec($ch);

        if (curl_errno($ch)) {
            echo 'Error:' . curl_error($ch);
        }

        curl_close($ch);

        return $approvedData = json_decode($result, true);
    }

Testing

Now let’s test the fake card that we have generated earlier. Now, you have to put card number, expired date, CVV and put any name. Once done, submit the form.

If everything goes smoothly, you will get some data like this. Where you will get "state": "approved" and should have "id": "PAYID-L6HGX3A4MT388022P233113E".

BTW, if you need to show any thank you page, then you can do operation based on state and id on the condition.

{
    "id": "PAYID-L6HGX3A4MT388022P233113E",
    "intent": "sale",
    "state": "approved",
    "cart": "66099532VT8552054",
    "payer": {
        "payment_method": "paypal",
        "status": "UNVERIFIED",
        "payer_info": {
            "email": "[email protected]",
            "first_name": "John",
            "last_name": "Doe",
            "payer_id": "CC3S9AQAUZH62",
            "shipping_address": {
                "recipient_name": "PP Plus Recipient",
                "line1": "Gregório Rolim de Oliveira, 42",
                "line2": "JD Serrano II",
                "city": "Votorantim",
                "state": "São Paulo",
                "postal_code": "18117-134",
                "country_code": "BR",
                "normalization_status": "UNKNOWN"
                },
            "tax_id_type": "BR_CPF",
            "tax_id": "42415970840",
            "country_code": "BR"
            }
        },
        ...

Hope this post will be helpful for you.

The iPhone 12 and iPhone 12 Pro may be high performance, but that won’t stop the occasional need to force restart your mobile device. Here’s the steps you need to reboot your iPhone 12 if a graceful shutdown isn’t possible.

How to turn the iPhone 12 off then on again

How to force restart the iPhone 12 and iPhone 12 Pro

At long last, iPhone owners can finally customize their home screens with widgets. (Android users, feel free to skip—y’all have had this feature for years.) After you install iOS 14, you can deck out your iPhone with fresh icons, wallpaper, and widgets for a fully personalized look. Here’s how to get started.

First, you’ll need some new app icons. You can find some online by searching for iPhone icon packs, or by visiting a site like icons8.com. Save the icons to your camera roll.

Then head on over to the App Store and download Widgetsmith, which lets you change your iPhone’s fonts and colors, and Apple’s Shortcuts app (if you don’t already have it), which is where things start to get a little…. complicated.

You have to create shortcuts from your new app icons to the apps themselves. Within the Shortcuts app, hit the plus sign in the top right corner. Then tap Add Action and select Scripting. From there, choose the Open App command, then pick the app you want to open. Hit the three dots and select Add to Home Screen. From here, write the name of the app and hit the icon picture to the left. Select the Choose Photo option to open up your Camera Roll and select that icon you chose for this particular app in step one. Unfortunately, you have to repeat this process for every new app icon. To get rid of the old app icons, long-press your home screen to send them to the App Library.

Creating shortcuts from new icons to apps will slow down app loading times and also prevent you from viewing notification badges. And, as you can see from the video above, this process is time-consuming, to say the least. But if you want your iPhone to reflect your true spirit, it might be worth the hours it takes to fully trick out your home screen. Don’t say we didn’t warn you!

It’s usually a good idea to extract reusable bits of code into blade components. Let’s spend some time to extract a livewire text input component and use “whereStartsWith” to get our wire:model attribute even when it has a modifier.
View the source code for this episode on [GitHub](https://ift.tt/2TgXgjQ).

Apple University Vice President and Dean Joel Podolny has penned an article that takes a deep dive into how Apple is structured and how it’s unique among large businesses.

Readers of a certain age will have fond childhood memories of weekday afternoons spent in the company of the Warner siblings, Yakko, Wakko, and Dot, the central figures of the hugely popular, Emmy-award winning animated series, Animaniacs. Now a whole new generation can appreciate their comic genius with Hulu’s revival of the show, slated to debut next month.

The premise of the original Animaniacs was that Yakko, Wakko, and Dot were characters from the 1930s who were locked way in a water tower on the Warner Bros. lot until they escaped in the 1990s. Now they exist to wreak havoc and have fun. The format borrowed heavily from sketch comedy, with each episode typically featuring three short mini-episodes centered on different characters, connected by bridging segments. Other regular characters included two genetically altered lab mice, Pinky and the Brain, who are always trying to take over the world; Ralph the Security Guard; Slappy Squirrel and her nephew, Skippy; Chicken Boo; Flavio and Marita, aka the Hip Hippos; studio psychiatrist Dr. Otto Scratchansniff and Hello Nurse (also a common catchphrase); and a trio of pigeons known as The Goodfeathers.

As appealing to adults as to kids, the show was smart, funny, irreverent, and even educational, especially with its playful songs listing the nations of the world, for instance, or all the US states and their capitals—set to the tune of “Turkey in the Straw”—or all the presidents set to the “William Tell Overture.” (My personal favorite was “The Solar System Song,” complete with the obligatory joke about Uranus.) The writers were masters of parody, so much so that it became something of a badge of honor to be so featured. Honorees included A Hard Day’s Night, Seinfeld, Friends, Bambi, Power Rangers, Rugrats, and The Lion King, as well as the Gilbert and Sullivan comic operas Pirates of Penzance and H.M.S. Pinafore. And of course, the Goodfeathers segments invariably parodied characters from both The Godfather and Goodfellas.

When the original series began streaming on Netflix, it proved so popular that Steven Spielberg’s Amblin Television and Warner Bros. Animation began thinking about reviving Animaniacs. They ultimately inked a deal with Hulu, which included the rights for the original series, as well as Tiny Toon Adventures, Pinky and the Brain, and Pinky, Elmyra, and the Brain. (That means we can all revisit our favorites on Hulu.) Spielberg returned as executive producer and insisted on bringing back most of the original voice cast for the reboot. A first-look clip debuted earlier this month at the virtual New York Comic-Con (embedded below), parodying Jurassic Park (John Hammond—or rather, a cartoon Spielberg channeling Hammond—reanimates the Warner siblings).

Per the official summary:

They’re back! The Warner brothers, Yakko and Wakko, and the Warner sister Dot, have a great time wreaking havoc and mayhem in the lives of everyone they meet. After returning to their beloved home, the Warner Bros. water tower, the siblings waste no time in causing chaos and comic confusion as they run loose through the studio, turning the world into their personal playground. Joining Yakko, Wakko and Dot, fan-favorite characters Pinky and the Brain also return to continue their quest for world domination.

The trailer showcases the same irreverently goofy attitude of the original, with the Warners not above poking fun at themselves—in this case, denouncing reboots as being  ”symptomatic of a fundamental lack of originality in Hollywood.” But they gleefully change their tune when Hulu presents them with a big check for the Animaniacs reboot (“You sellouts!”).  Cue the classic Animaniacs theme song with cheeky new lyrics (“It’s time for Animaniacs/You should see our new contracts!”). After being off the air for so long, the Warner siblings have a lot of catching up to do, particularly when it comes to the latest technology. And Pinky and the Brain make a welcome appearance, with Pinky fretting over an online dating app.

All in all, it looks like a promising revival. The new Animaniacs debuts on Hulu on November 20, 2020.

Listing image by YouTube/Hulu