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 user_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_items']

                  ],
                  -1
              );
          }

          return 'User #'.print_r($query_basket).' updated';

      }
  }