按时间搜索

it2022-05-05  197

            $seller_cash_num=I('get.seller_cash_num/s');//交易编号

            $start_time=I('get.start_time/s');

            $end_time=I('get.end_time/s');

            $status=I('get.status/d');

            //if(!empty($seller_id)&&$seller_id!=' '){

            $where='is_del=0 and seller_id='.$seller_id;

            if(!empty($seller_cash_num)){

                $where.=' and seller_cash_num like \'%'.$seller_cash_num.'%\'';

            }

            if(!empty($start_time)){

                $where.=' and unix_timestamp(start_time)>='.strtotime($start_time);

            }

            if(!empty($end_time)){

                $where.=' and unix_timestamp(end_time)<='.strtotime($end_time);

            }

            if(!empty($status)){

                $where.=' and status='.$status;

            }


最新回复(0)