public function GetProcess($param)
{
parent::query('SELECT pa_id,pa_name,pa_description,pa_address,pa_guide,pa_phone,pa_latitude,pa_longitude,pa_score,pa_view,pa_read,pa_success,pa_create_time,pa_update_time,pa_visit_time,pa_read,pa_score,pa_type,pa_status,amphur_id,amphur_name,province_id,province_name,pe_id,pe_fb_id,pe_fname,pe_lname,pe_type,im_id,im_filename,im_format
FROM base_page
LEFT JOIN th_amphur ON pa_city_id = amphur_id
LEFT JOIN th_province ON pa_province_id = province_id
LEFT JOIN base_people ON pa_people_id = pe_fb_id
LEFT JOIN base_image ON pa_id = im_page_id AND im_type = "cover" AND im_status = "active"
WHERE pa_id = :page_id');
parent::bind(':page_id', $param['page_id']);
parent::execute();
$dataset = parent::single();
$dataset['url_friendly'] = parent::url_friendly_process($dataset['pa_name']);
$dataset['create_time_facebook_format'] = parent::date_facebookformat($dataset['pa_create_time']);
$dataset['update_time_facebook_format'] = parent::date_facebookformat($dataset['pa_update_time']);
$dataset['visit_time_facebook_format'] = parent::date_facebookformat($dataset['pa_visit_time']);
$dataset['create_time_thai_format'] = parent::date_thaiformat($dataset['pa_create_time']);
$dataset['update_time_thai_format'] = parent::date_thaiformat($dataset['pa_update_time']);
$dataset['visit_time_thai_format'] = parent::date_thaiformat($dataset['pa_visit_time']);
return $dataset;
}
public function ListPlaceMyHistoryProcess($param)
{
parent::query('SELECT pl_id place_id,ca_id place_category_id,ca_title place_category_name,pl_name place_name,pl_description place_description,pl_story place_story,pl_keyword place_keyword,pl_address place_address,pl_address_real place_address_real,pl_open place_open,pl_rating place_rating,pl_latitude place_latitude,pl_longitude place_longitude,pl_phone place_phone,pl_website place_website,pl_facebook place_facebook,pl_twitter place_twitter,pl_instagram place_instagram,pl_line place_line,pl_point place_point,pl_people place_people,pl_view place_view,pl_read place_read,pl_register_time place_register_time,pl_update_time place_update_time,pl_visit_time place_visit_time,pl_wifi place_wifi,pl_carpark place_carpark,pl_credit_card place_credit_card,pl_delivery place_delivery,pl_pet place_pet,pl_type place_type,pl_status place_status,pv_id province_id,pv_title province_name,cy_id city_id,cy_title city_name,ds_id district_id,ds_title district_name,me_id owner_id,me_name owner_name
FROM dy_activity
LEFT JOIN dy_place ON ac_to_place_id = pl_id
LEFT JOIN dy_category ON pl_category_id = ca_id
LEFT JOIN dy_member ON pl_member_id = me_id
LEFT JOIN dy_location_province ON pl_province_id = pv_id
LEFT JOIN dy_location_city ON pl_city_id = cy_id
LEFT JOIN dy_location_district ON pl_district_id = ds_id
WHERE ac_action = "view_place" AND ac_member_id = :member_id
GROUP BY ac_to_place_id
ORDER BY ac_create_time DESC
LIMIT ' . $param['start'] . ',' . $param['total']);
parent::bind(':member_id', $param['member_id']);
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
$dataset[$k]['place_url'] = parent::url_friendly_process($var['place_name']);
$dataset[$k]['place_register_time_facebook_format'] = parent::date_facebookformat($var['place_register_time']);
$dataset[$k]['place_update_time_facebook_format'] = parent::date_facebookformat($var['place_update_time']);
$dataset[$k]['place_register_time_thai_format'] = parent::date_thaiformat($var['place_register_time']);
$dataset[$k]['place_update_time_thai_format'] = parent::date_thaiformat($var['place_update_time']);
}
return $dataset;
}
