29 lines
773 B
PHP
29 lines
773 B
PHP
<?
|
|
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;
|
|
}
|
|
} |