<?
namespace admin\factory;

class CaseStudy
{
  static public function case_study_details( $case_study_id )
  {
    global $mdb;

    $case_study = $mdb -> get('pp_case_study', '*', ['id' => (int)$case_study_id]);

    $rows = $mdb -> select( 'pp_case_study_values', [ 'param', 'value' ], [ 'case_study_id' => $case_study_id ] );
    if ( count( $rows ) ) foreach ( $rows as $row )
      $case_study[$row['param']] = $row['value'];

    return $case_study;
  }

  static public function case_study_save( $case_study_id, $status, $case_study_big, $date_add, $date_modify, $values )
  {
    global $mdb;

    if ( $case_study_id )
    {
      // update
      $mdb -> update( 'pp_case_study', [
        'status' => $status == 'on' ? 1 : 0,
        'case_study_big' => $case_study_big == 'on' ? 1 : 0,
        'date_add' => date( 'Y-m-d H:i:s' ),
        'date_modify' => date( 'Y-m-d H:i:s' )
      ],[
        'id' => (int)$case_study_id
      ] );

      // uproszczone zapisywanie
      foreach ( $values as $key => $val )
      {
        if ( $key == 'id' || $key == 'status' || $key == 'case_study_big' || $key == 'date_add' || $key == 'date_modify' )
          continue;

        if ( $mdb -> count( 'pp_case_study_values', [ 'AND' => [ 'case_study_id' => $case_study_id, 'param' => $key ] ] ) )
        {
          if ( $key == 'gwiazdki-w-reklamach-zdjecie-pozycja' )
          echo $val;
          $mdb -> update( 'pp_case_study_values', [
            'value' => $val != '' ? $val : null
          ], [
            'AND' => [ 'case_study_id' => $case_study_id, 'param' => $key ]
          ] );
        }
        else
        {
          $mdb -> insert( 'pp_case_study_values', [
            'param' => $key,
            'value' => $val != '' ? $val : null,
            'case_study_id' => $case_study_id
          ] );
        }
      }

      return $case_study_id;
    }
    else
    {
      $mdb -> insert('pp_case_study',[
        'status' => $status == 'on' ? 1 : 0,
        'case_study_big' => $case_study_big == 'on' ? 1 : 0,
        'date_add' => date( 'Y-m-d H:i:s' ),
        'date_modify' => date( 'Y-m-d H:i:s' )
      ]);

      $case_study_id = $mdb -> id();

      foreach ( $values as $key => $val )
      {
        if ( $key == 'id' || $key == 'status' || $key == 'case_study_big' || $key == 'date_add' || $key == 'date_modify' )
          continue;

        $mdb -> insert( 'pp_case_study_values', [
          'param' => $key,
          'value' => $val != '' ? $val : null,
          'case_study_id' => $case_study_id
        ] );
      }

      return $case_study_id;
    }
  }
}