<?php

namespace app\api\model;

use think\Model;


class UserTicket extends Model
{
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    protected $deleteTime = false;


    public function getPasttimeAttr($value)
    {
        return date('Y-m-d H:i',$value);
    }

    public function selectPageData($where,$page,$limit,$lang,$price = 0){

        if ($lang == 'ch') $field = 'ut.id user_ticket_id,ut.pasttime,t.price,ut.fill_price,t.ch_name name';
        else $field = 'ut.id user_ticket_id,ut.pasttime,t.price,ut.fill_price,t.en_name name';

        $total =$this
            ->alias('ut')
            ->where($where)
            ->whereOr(function ($query) use ($where,$price){
                $query->where('user_id', $where['user_id'])->where('status', $where['status'])->where('ut.fill_price', '<=', $price);
            })
            ->count();

        $list =  $this->alias('ut')
            ->join('fa_ticket t','ut.ticket_id=t.id')
            ->where($where)
            ->whereOr(function ($query) use ($where,$price){
                $query->where('user_id', $where['user_id'])->where('status', $where['status'])->where('ut.fill_price', '<=', $price);
            })
            ->field($field)
            ->page($page,$limit)
            ->select();
        return ['total' => $total, 'list' => $list];
    }
}