public function GetOrderProcess($param)
{
parent::query('SELECT od_id,od_member_id,me_name,me_phone,me_email,me_status,od_total,od_amount,od_payments,od_create_time,od_update_time,od_paying_time,od_confirm_time,od_expire_time,od_shipping_time,od_complete_time,od_shipping_type,od_ems,od_address,od_type,od_status
FROM dd_order
LEFT JOIN dd_member ON od_member_id = me_id
WHERE od_id = :order_id');
parent::bind(':order_id', $param['order_id']);
parent::execute();
$dataset = parent::single();
$dataset['order_create_time_facebook_format'] = parent::date_facebookformat($dataset['od_create_time']);
$dataset['order_update_time_facebook_format'] = parent::date_facebookformat($dataset['od_update_time']);
$dataset['order_paying_time_facebook_format'] = parent::date_facebookformat($dataset['od_paying_time']);
$dataset['order_expire_time_facebook_format'] = parent::date_facebookformat($dataset['od_expire_time']);
$dataset['order_confirm_time_facebook_format'] = parent::date_facebookformat($dataset['od_confirm_time']);
$dataset['order_shipping_time_facebook_format'] = parent::date_facebookformat($dataset['od_shipping_time']);
$dataset['order_complete_time_facebook_format'] = parent::date_facebookformat($dataset['od_complete_time']);
$dataset['order_create_time_thai_format'] = parent::date_thaiformat($dataset['od_create_time']);
$dataset['order_update_time_thai_format'] = parent::date_thaiformat($dataset['od_update_time']);
$dataset['order_paying_time_thai_format'] = parent::date_thaiformat($dataset['od_paying_time']);
$dataset['order_expire_time_thai_format'] = parent::date_thaiformat($dataset['od_expire_time']);
$dataset['order_confirm_time_thai_format'] = parent::date_thaiformat($dataset['od_confirm_time']);
$dataset['order_shipping_time_thai_format'] = parent::date_thaiformat($dataset['od_shipping_time']);
$dataset['order_complete_time_thai_format'] = parent::date_thaiformat($dataset['od_complete_time']);
$dataset['order_expire_time_datediff'] = parent::dateDifference($dataset['od_expire_time']);
$dataset['me_phone'] = parent::PhoneFormat($dataset['me_phone']);
return $dataset;
}
public function GetUserProcess($param)
{
parent::query('SELECT * FROM dd_member WHERE me_id = :member_id');
parent::bind(':member_id', $param['member_id']);
parent::execute();
$dataset = parent::single();
$dataset['user_create_time_facebook_format'] = parent::date_facebookformat($dataset['me_create_time']);
$dataset['user_create_time_thai_format'] = parent::date_thaiformat($dataset['me_create_time']);
return $dataset;
}
public function ListKeywordProcess($param)
{
parent::query('SELECT * FROM dy_keyword WHERE kw_total > 0 ORDER BY kw_total DESC LIMIT 100');
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
$dataset[$k]['kw_create_time_facebook_format'] = parent::date_facebookformat($var['kw_create_time']);
$dataset[$k]['kw_update_time_facebook_format'] = parent::date_facebookformat($var['kw_update_time']);
}
return $dataset;
}
public function ListNotificationProcess($param)
{
parent::query('SELECT ac_id activity_id,me_id activity_owner_id,me_fname activity_owner_fname,me_name activity_owner_name,ac_action activity_action,ac_create_time activity_create_time,ac_to_comment_id activity_comment_id,cm_message activity_comment_message,po_id activity_post_id,po_text activity_post_text,ac_status activity_status
FROM dy_activity
LEFT JOIN dy_post ON ac_to_post_id = po_id
LEFT JOIN dy_member ON ac_member_id = me_id
LEFT JOIN dy_comment ON ac_to_comment_id = cm_id
WHERE (ac_action = "new_comment" OR ac_action = "thanks_post") AND (po_member_id = :member_id) AND (ac_member_id != :member_id)
ORDER BY ac_create_time DESC');
parent::bind(':member_id', $param['member_id']);
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
// $dataset[$k]['comment_message'] = htmlspecialchars($var['comment_message']);
$dataset[$k]['activity_create_time_facebook_format'] = parent::date_facebookformat($var['activity_create_time']);
$dataset[$k]['activity_update_time_facebook_format'] = parent::date_facebookformat($var['activity_update_time']);
}
return $dataset;
}
public function LiveMemberProcess($param)
{
if ($param['time_now'] == 0) {
$param['time_now'] = date('Y-m-d H:i:s');
}
// List Member has visit time within 15 minutes.
$diff_time = strtotime($param['time_now']) - 300;
$date = date('Y-m-d H:i:s', $diff_time);
parent::query('SELECT me_id member_id,me_name member_name,me_register_time member_register_time,me_update_time member_update_time,me_visit_time member_visit_time,me_type member_type
FROM dy_member
WHERE (me_id LIKE :search OR me_name LIKE :search OR me_email LIKE :search)
ORDER BY me_visit_time DESC
LIMIT 0,100');
parent::bind(':search', '%' . $param['search'] . '%');
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
// Online checking
if ($var['member_visit_time'] > $date) {
$dataset[$k]['member_online'] = 'online';
} else {
$dataset[$k]['member_online'] = 'offline';
}
// New member checking
if (time() - strtotime($var['member_register_time']) < 86400) {
$dataset[$k]['member_types'] = 'new';
} else {
$dataset[$k]['member_types'] = 'old';
}
$dataset[$k]['member_register_time'] = parent::date_facebookformat($var['member_register_time']);
$dataset[$k]['member_update_time'] = parent::date_facebookformat($var['member_update_time']);
$dataset[$k]['member_visit_time'] = parent::date_facebookformat($var['member_visit_time']);
}
return $dataset;
}
function GetGiveRatingProcess($param)
{
parent::query('SELECT po_id,po_rating,po_create_time,po_update_time FROM dy_post
WHERE (po_member_id = :member_id AND po_place_id = :place_id AND po_type = "give_rating")');
parent::bind(':member_id', $param['member_id']);
parent::bind(':place_id', $param['place_id']);
parent::execute();
$data = parent::single();
$data['po_update_time_facebook_format'] = parent::date_facebookformat($data['po_update_time']);
return $data;
}
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;
}
public function LiveCommentProcess($param)
{
parent::query('SELECT cm_id comment_id,me_id comment_poster_id,me_fname comment_poster_name,cm_message comment_message,po_id comment_post_id,po_text comment_post_text,im_link_thumbnail comment_thumbnail,cm_create_time comment_create_time,cm_update_time comment_update_time,cm_status comment_status
FROM dy_comment
LEFT JOIN dy_member ON cm_member_id = me_id
LEFT JOIN dy_post ON cm_post_id = po_id LEFT JOIN dy_image ON po_id = im_post_id
WHERE (cm_id LIKE :search OR cm_message LIKE :search OR me_name LIKE :search OR po_text LIKE :search) AND cm_status != "archive"
ORDER BY cm_create_time DESC LIMIT 50');
parent::bind(':search', '%' . $param['search'] . '%');
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
$dataset[$k]['comment_message'] = htmlspecialchars($var['comment_message']);
$dataset[$k]['comment_create_time'] = parent::date_facebookformat($var['comment_create_time']);
$dataset[$k]['comment_update_time'] = parent::date_facebookformat($var['comment_update_time']);
}
return $dataset;
}
public function LivePostProcess($param)
{
parent::query('SELECT po_id post_id,po_place_id place_id,pl_name place_name,me_id poster_id,me_fname poster_name,po_title post_title,po_text post_text,po_rating post_rating,po_total_comment post_total_comment,po_create_time post_create_time,po_update_time post_update_time,po_ip post_ip,po_type post_type,po_status post_status,im_link_thumbnail image_thumbnail
FROM dy_post
LEFT JOIN dy_image ON im_post_id = po_id
LEFT JOIN dy_member ON po_member_id = me_id
LEFT JOIN dy_place ON po_place_id = pl_id
WHERE (po_id LIKE :search OR po_text LIKE :search OR pl_name LIKE :search OR me_name LIKE :search) AND (po_status != "archive")
ORDER BY po_create_time DESC LIMIT 50');
parent::bind(':search', '%' . $param['search'] . '%');
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
//$dataset[$k]['comment_message'] = htmlspecialchars($var['comment_message']);
$dataset[$k]['post_create_time'] = parent::date_facebookformat($var['post_create_time']);
$dataset[$k]['post_update_time'] = parent::date_facebookformat($var['post_update_time']);
}
return $dataset;
}
