public function EditCommentProcess($param)
{
parent::query('UPDATE dy_comment
SET cm_message = :message,cm_ip = :ip, cm_update_time = :update_time, cm_type = "edited"
WHERE (cm_id = :comment_id AND cm_member_id = :member_id)');
parent::bind(':message', $param['message']);
parent::bind(':comment_id', $param['comment_id']);
parent::bind(':member_id', $param['member_id']);
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::execute();
}
public function SaveSearchLogProcess($param)
{
parent::query('INSERT INTO log_search(lo_people_id,lo_keyword,lo_ip,lo_result,lo_execute_time,lo_create_time,lo_type) VALUE(:people_id,:keyword,:ip,:result,:execute_time,:create_time,:type)');
parent::bind(':people_id', $param['people_id']);
parent::bind(':keyword', $param['keyword']);
parent::bind(':result', $param['result']);
parent::bind(':execute_time', $param['execute_time']);
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':type', $param['type']);
parent::execute();
return parent::lastInsertId();
}
public function CreateProcess($param)
{
parent::query('INSERT INTO base_image(im_page_id,im_people_id,im_caption,im_filename,im_format,im_create_time,im_update_time,im_ip,im_type,im_status) VALUE(:page_id,:people_id,:caption,:filename,:format,:create_time,:update_time,:ip,:type,:status)');
parent::bind(':page_id', $param['page_id']);
parent::bind(':people_id', $param['people_id']);
parent::bind(':caption', $param['caption']);
parent::bind(':filename', $param['filename']);
parent::bind(':format', $param['format']);
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':type', $param['type']);
parent::bind(':status', $param['status']);
parent::execute();
return parent::lastInsertId();
}
public function RegisterUserProcess($param)
{
parent::query('INSERT INTO dd_member(me_email,me_phone,me_name,me_fb_id,me_fb_name,me_password,me_create_time,me_update_time,me_ip,me_type,me_status) VALUE(:email,:phone,:name,:fb_id,:fb_name,:password,:create_time,:update_time,:ip,:type,:status)');
parent::bind(':email', $param['email']);
parent::bind(':phone', $param['phone']);
parent::bind(':name', $param['name']);
parent::bind(':fb_id', $param['fb_id']);
parent::bind(':fb_name', $param['fb_name']);
parent::bind(':password', $param['password']);
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':type', $param['type']);
parent::bind(':status', $param['status']);
parent::execute();
return parent::lastInsertId();
}
public function CreateTokenProcess($param)
{
parent::query('INSERT INTO base_token(tk_people_id,tk_token,tk_device,tk_model,tk_os,tk_browser,tk_user_agent,tk_ip,tk_create_time,tk_update_time,tk_expired) VALUE(:people_id,:token,:device,:model,:os,:browser,:user_agent,:ip,:create_time,:update_time,:expired)');
parent::bind(':people_id', $param['facebook_id']);
parent::bind(':token', $param['new_token']);
parent::bind(':device', $param['device']);
parent::bind(':model', $param['model']);
parent::bind(':os', $param['os']);
parent::bind(':browser', $param['browser']);
parent::bind(':user_agent', $param['user_agent']);
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':expired', $param['expired']);
parent::execute();
return parent::lastInsertId();
}
public function CreatePlaceProcess($param)
{
parent::query('INSERT INTO dy_place(pl_token,pl_member_id,pl_name,pl_description,pl_province_id,pl_city_id,pl_district_id,pl_register_time,pl_update_time,pl_visit_time,pl_ip)
VALUE(:token_id,:member_id,:name,:description,:province_id,:city_id,:district_id,:register_time,:update_time,:visit_time,:ip)');
parent::bind(':token_id', $param['token_id']);
parent::bind(':member_id', $param['member_id']);
parent::bind(':name', $param['name']);
parent::bind(':description', $param['description']);
parent::bind(':province_id', $param['province_id']);
parent::bind(':city_id', $param['city_id']);
parent::bind(':district_id', $param['district_id']);
parent::bind(':register_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':visit_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::execute();
return parent::lastInsertId();
}
public function CreateMemberProcess($param)
{
parent::query('INSERT INTO dy_member(me_id,me_email,me_name,me_fname,me_lname,me_link,me_verified,me_gender,me_register_time,me_update_time,me_visit_time,me_ip) VALUE(:id,:email,:name,:fname,:lname,:link,:verified,:gender,:register_time,:update_time,:visit_time,:ip)');
parent::bind(':id', $param['member_id']);
parent::bind(':email', $param['email']);
parent::bind(':name', $param['name']);
parent::bind(':fname', $param['fname']);
parent::bind(':lname', $param['lname']);
parent::bind(':link', $param['link']);
parent::bind(':verified', $param['verified']);
parent::bind(':gender', $param['gender']);
// Timer
parent::bind(':register_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':visit_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::execute();
return parent::lastInsertId();
}
public function CreatePhotoProcess($param)
{
parent::query('INSERT INTO dy_image(im_post_id,im_member_id,im_place_id,im_caption,im_link_thumbnail,im_link_square,im_link_mini,im_link_normal,im_link_large,im_format,im_create_time,im_update_time,im_ip,im_type) VALUE(:post_id,:member_id,:place_id,:caption,:link_thumbnail,:link_square,:link_mini,:link_normal,:link_large,:format,:create_time,:update_time,:ip,:type)');
parent::bind(':post_id', $param['post_id']);
parent::bind(':member_id', $param['member_id']);
parent::bind(':place_id', $param['place_id']);
parent::bind(':caption', $param['caption']);
parent::bind(':link_thumbnail', $param['link_thumbnail']);
parent::bind(':link_square', $param['link_square']);
parent::bind(':link_mini', $param['link_mini']);
parent::bind(':link_normal', $param['link_normal']);
parent::bind(':link_large', $param['link_large']);
parent::bind(':format', $param['format']);
// Timer
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':type', $param['type']);
parent::execute();
return parent::lastInsertId();
}
public function ActivityCreateProcess($param)
{
parent::query('INSERT INTO dy_activity(ac_member_id,ac_token,ac_place_id,ac_action,ac_to_place_id,ac_to_post_id,ac_to_member_id,ac_to_comment_id,ac_keyword,ac_to_image_id,ac_create_time,ac_update_time,ac_ip,ac_type,ac_status) VALUE(:member_id,:token,:place_id,:action,:to_place_id,:to_post_id,:to_member_id,:to_comment_id,:keyword,:to_image_id,:create_time,:update_time,:ip,:type,:status)');
parent::bind(':member_id', $param['member_id']);
parent::bind(':token', $param['token']);
parent::bind(':place_id', $param['place_id']);
parent::bind(':action', $param['action']);
parent::bind(':to_place_id', $param['to_place_id']);
parent::bind(':to_post_id', $param['to_post_id']);
parent::bind(':to_member_id', $param['to_member_id']);
parent::bind(':to_comment_id', $param['to_comment_id']);
parent::bind(':to_image_id', $param['to_image_id']);
parent::bind(':keyword', $param['keyword']);
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':type', $param['type']);
parent::bind(':status', $param['status']);
parent::execute();
return parent::lastInsertId();
}
public function SaveHistoryProcess($param)
{
parent::query('INSERT INTO dy_history(hi_member_id,hi_place_id,hi_create_time,hi_update_time,hi_ip) VALUE(:member_id,:place_id,:create_time,:update_time,:ip)');
parent::bind(':member_id', $param['member_id']);
parent::bind(':place_id', $param['place_id']);
// Timer
parent::bind(':create_time', date('Y-m-d H:i:s'));
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::execute();
return parent::lastInsertId();
}
public function EditRatingProcess($param)
{
parent::query('UPDATE dy_post SET po_rating = :rating, po_update_time = :update_time, po_ip = :ip
WHERE (po_id = :post_id AND po_member_id = :member_id AND po_place_id = :place_id AND po_type = "give_rating")');
parent::bind(':post_id', $param['post_id']);
parent::bind(':place_id', $param['place_id']);
parent::bind(':member_id', $param['member_id']);
parent::bind(':rating', $param['rating']);
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::bind(':ip', parent::GetIpAddress());
parent::execute();
return parent::lastInsertId();
}
public function CreateProductActivityProcess($param)
{
parent::query('INSERT INTO dd_product_activity(pdac_token,pdac_admin_id,pdac_product_id,pdac_action,pdac_value,pdac_description,pdac_ref_id,pdac_ip,pdac_time) VALUE(:token,:admin_id,:product_id,:action,:value,:description,:ref_id,:ip,:time)');
parent::bind(':token', $param['token']);
parent::bind(':admin_id', $param['admin_id']);
parent::bind(':product_id', $param['product_id']);
parent::bind(':action', $param['action']);
parent::bind(':value', $param['value']);
parent::bind(':description', $param['description']);
parent::bind(':ref_id', $param['ref_id']);
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':time', date('Y-m-d H:i:s'));
parent::execute();
return parent::lastInsertId();
}
public function UpdatePostProcess($param)
{
print_r($param);
parent::query('UPDATE dy_post SET po_title = :title,po_subtitle = :subtitle,po_text = :text,po_rating = :rating,po_ip = :ip,po_update_time = :update_time,po_type = "edited" WHERE po_id = :post_id AND po_member_id = :member_id');
parent::bind(':post_id', $param['post_id']);
parent::bind(':member_id', $param['member_id']);
parent::bind(':title', $param['title']);
parent::bind(':subtitle', $param['subtitle']);
parent::bind(':text', $param['text']);
parent::bind(':rating', $param['rating']);
parent::bind(':ip', parent::GetIpAddress());
parent::bind(':update_time', date('Y-m-d H:i:s'));
parent::execute();
}
