Alex Savenko / semena

  <?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;
  

      }
  }