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 ListPostProcess($param)
{
$q['select'] = 'SELECT po_id post_id,tk_token post_token,tk_device post_deivce,tk_model post_model,po_place_id place_id,pl_name place_name,me_id poster_id,me_name poster_name,me_fname poster_fname,me_type poster_type,me_status poster_status,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_id image_id,im_format image_format,im_link_thumbnail image_thumbnail,im_link_square image_square,im_link_mini image_mini,im_link_normal image_normal,im_link_large image_large,ac_id thanks_id, cy_title place_city ';
$q['from'] = 'FROM dy_post LEFT JOIN dy_image ON po_id = im_post_id LEFT JOIN dy_member ON po_member_id = me_id LEFT JOIN dy_token ON po_token = tk_token LEFT JOIN dy_place ON po_place_id = pl_id LEFT JOIN dy_activity ON ac_action = "thanks_post" AND ac_member_id = :member_id AND ac_to_post_id = po_id LEFT JOIN dy_location_city ON pl_city_id = cy_id ';
if (!empty($param['place_id'])) {
$q['where'] = 'WHERE (po_place_id = :place_id) AND (po_status = "active") ';
} else {
if (!empty($param['poster_id'])) {
$q['where'] = 'WHERE (po_member_id = :poster_id) AND (po_status = "active") ';
} else {
$q['where'] = 'WHERE (po_status = "active") ';
}
}
$q['order'] = 'ORDER BY po_update_time DESC ';
$q['limit'] = 'LIMIT ' . $param['start'] . ',' . $param['total'];
$queryProcess = $q['select'] . $q['from'] . $q['where'] . $q['order'] . $q['limit'];
parent::query($queryProcess);
if (!empty($param['place_id'])) {
parent::bind(':place_id', $param['place_id']);
} else {
if (!empty($param['poster_id'])) {
parent::bind(':poster_id', $param['poster_id']);
}
}
parent::bind(':member_id', $param['member_id']);
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
$dataset[$k]['post_text'] = htmlspecialchars($var['post_text']);
$dataset[$k]['post_create_time_facebook_format'] = parent::date_facebookformat($var['post_create_time']);
$dataset[$k]['post_update_time_facebook_format'] = parent::date_facebookformat($var['post_update_time']);
$dataset[$k]['post_create_time_thai_format'] = parent::date_thaiformat($var['post_create_time']);
$dataset[$k]['post_update_time_thai_format'] = parent::date_thaiformat($var['post_update_time']);
}
return $dataset;
}
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 HistoryProductProcess($param)
{
parent::query('SELECT pdac_id,admin.me_id admin_id,admin.me_name admin_name,pdac_action,pdac_value,od_id,customer.me_id customer_id,customer.me_name customer_name,od_status FROM dd_product_activity LEFT JOIN dd_order_detail ON pdac_ref_id = odt_id LEFT JOIN dd_order ON odt_order_id = od_id LEFT JOIN dd_member AS customer ON od_member_id = customer.me_id LEFT JOIN dd_member AS admin ON pdac_admin_id = admin.me_id WHERE pdac_product_id = :product_id AND (pdac_action = "import" OR pdac_action = "export" OR pdac_action = "SoldOut") ORDER BY pdac_time ASC');
parent::bind(':product_id', $param['product_id']);
parent::execute();
$dataset = parent::resultset();
foreach ($dataset as $k => $var) {
$dataset[$k]['create_time_thai_format'] = parent::date_thaiformat($var['pdac_time']);
}
return $dataset;
}
