<?
namespace front\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_list()
  {
    global $mdb;

    $results = $mdb -> query('SELECT id FROM pp_case_study WHERE status = 1 ORDER BY date_add DESC') -> fetchAll();
    foreach ( $results as $row )
      $case_studies[] = self::case_study_details( $row['id'] );

    return $case_studies;
  }
}