<?php
namespace App\Http\Controllers;

require base_path('vendor/autoload.php');
use GraphAware\Neo4j\Client\ClientBuilder;

class Neo4jController extends Controller
{

    private $client;

    public function index()
    {
        $client =  ClientBuilder::create()
            //->addConnection('default', 'http://neo4j:jm@123@59.110.24.172:7474')
            ->addConnection('bolt', 'bolt://neo4j:jm@123@59.110.24.172:7687')
            ->build();
        return $client;
    }

    public function test()
    {
        $client = $this->index();
        $query = 'MATCH (n:codes)
RETURN n.address as addr, n.name as name , n, collect(id(n)) as ids
LIMIT 5';
        $test = $client->run($query);
        foreach ($test->getRecords() as $record)
        {
            $array[]['name'] = $record->value('name');
            foreach ($array as $key => $value) {
                $array[$key]['name'] = $value['name'];
                $array[$key]['addr'] = $record->value('addr');
            }
        }
        return json_encode(['result' => $array]);
    }

}