89 lines
2.5 KiB
PHP
89 lines
2.5 KiB
PHP
<?
|
|
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;
|
|
}
|
|
}
|
|
} |