<?php
/**
 * Created by PhpStorm.
 * User: Alex Savenko
 * Date: 12.01.2017
 * Time: 12:59
 */

namespace models;


class basket extends \db
{
    public function addData($data)
    {

        $query_basket =  $this->get(
            '
                INSERT INTO
                    public.basket
                        (
                          user_id,
                          letter,
                          last_mod
                        )
                        VALUES
                        (
                          :user_id,
                          :letter,
                          CURRENT_TIMESTAMP
                        )
                        RETURNING id
            ',
            [
                'user_id'       => $data['user_id'],
                'letter'        => $data['letter']
            ],
            -1
        );

        foreach ($data['items'] as $item) {
            $query_basket_items = $this->get(
                '
                INSERT INTO
                    public.basket_items
                        (
                          user_id,
                          item_id,
                          count
                        )
                        VALUES
                        (
                          :user_id,
                          :item_id,
                          :count
                        )
                        RETURNING id
            ',
                [
                    'user_id'   => $data['user_id'],
                    'item_id'   => $item['item_id'],
                    'count'     => $item['count']
                ],
                -1
            );
        }


        return
            $query_basket.
            PHP_EOL.
            $query_basket_items;

    }
}