<?php

namespace YHMOrders\SqlMap\Complain;

class Complain {

    const SELECT_LIST_BY_ORDER_CODE = 'select * from order_complain where order_code = :order_code order by create_time asc ';
    const INSERT_COMPLAIN = 'insert into order_complain(order_code,uid,user_type,content,image_path,create_time,parent_id) values(:order_code,:uid,:user_type,:content,:image_path,UNIX_TIMESTAMP(),:pid)';
    const SELECT_COMPLAIN_LIST="select * from order_complain where #where# limit :offset,:num";
    const SELECT_COMPLAIN_COUNT="select count(1) from order_complain where #where# ";
    const SELECT_COMPLAIN_INFO= 'select * from order_complain where id=:id ';
    const SELECT_COMPLAIN_PARENT_LIST= 'select * from order_complain where parent_id=:id ';
    const UPDATE_COMPLAIN_STATUS="update order_complain set status=:status where id=:id ";
}