ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / netxzero.com / carbon-credit / app / Http / Controllers

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Project;
use App\Models\ProjectImage;

class CronController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
         /* START OF PROJECT UPDATION CODE IN OUR DB */

$curl = curl_init();

curl_setopt_array($curl, [
          CURLOPT_URL => "https://api-prod-no-cert.cloverly.com/2021-10/projects",
          CURLOPT_RETURNTRANSFER => true,
          CURLOPT_ENCODING => "",
          CURLOPT_MAXREDIRS => 10,
          CURLOPT_TIMEOUT => 30,
          CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
          CURLOPT_CUSTOMREQUEST => "GET",
          CURLOPT_HTTPHEADER => [
            "Authorization: ".env('CLOVERLY_API_KEY'),
            // "Content-Type: application/json"
          ],
        ]);

$response = curl_exec($curl);

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

$decodedProjects = json_decode($response, true);
        $cloverlyProjects = collect($decodedProjects);
        
        //$projects = Project::all();
        //dd($projects, $cloverlyProjects);

foreach($cloverlyProjects as $data) {
              
            $project = Project::where('project_id', $data['id'])->first();
            //dd($project);

if (!empty($project)) {

$project->available_carbon_in_kg = $data['available_carbon_in_kg'];
                $project->cost_per_kg_carbon_in_usd_cents = $data['cost_per_kg_carbon_in_usd_cents'];
                $project->kwh_of_electricity_per_unit = $data['kwh_of_electricity_per_unit'];
                $project->save();
            }
            else {

$project = new Project();
                $project->fill($data);
                $project->project_id= $data['id'];

if (isset($data['location'])) {
                      $project->location_lat = $data['location']['x'];
                      $project->location_lon = $data['location']['y'];
                }

if (isset($data['project_ratings'])) {
                    foreach ($data['project_ratings'] as $rating) {
                      $project->rating = $rating['rating'];
                      $project->rating_title = $rating['rating_title'];
                    }
                }

$project->save();

if(isset($data['image_list'])) {
                    foreach ($data['image_list'] as $image) {
                      $projectImage = new ProjectImage();
                      $projectImage->fill($image);
                      $projectImage->project()->associate($project);
                      $projectImage->save();
                    }
                }
            }

// $project = Project::updateOrCreate(
            //     ['project_id' == $data['id']],
            //     ['available_carbon_in_kg' => $data['available_carbon_in_kg'], 'cost_per_kg_carbon_in_usd_cents' => $data['cost_per_kg_carbon_in_usd_cents']]
            // );

}
        return 0;

/* END OF PROJECT UPDATION CODE IN OUR DB */
      
    }

}

[-] CartController.php [edit]
[+] ..
[-] Controller.php [edit]
[+] Admin
[+] Auth
[-] SiteController.php [edit]
[-] HomeController.php [edit]
[-] CronController.php [edit]