<?php

namespace YHMSupport\SqlMap\Advise;

class Advise {

    const INSERT_ADVISE = 'insert into advise(uid,content,create_time,client_version,client_type,os_version,parent_id,user_type) values(:uid,:content,UNIX_TIMESTAMP(),:client_version,:client_type,:os_version,:parent_id,:user_type)';
     const SELECT_ADVISE_LIST = 'select * from  advise where #where# order by id desc limit :offset,:num';
    const SELECT_ADVISE_COUNT = 'select count(1) from  advise where #where#';
     const SELECT_ADVISE_INFOS = 'select * from  advise where id=:id ';
     const SELECT_ADVISE_REPLY_LIST = 'select * from  advise where parent_id=:pid ';
     const UPDATE_ADVISE_STATUS="update advise set status=:status where id=:id";
}