zhkt/protected/model/videouser.php

<?php

Doo::loadCore('db/DooModel');
/**
 * Created by PhpStorm.
 * User: ellisran
 * Date: 2016/9/22
 * Time: 16:20
 */
class Videouser extends DooModel {
    public $id;
    public $userid;
    public $videoid;
    public $wyvideoid;
    public $seetime;
    public $file_time;
    public $last_time;
    public $issuccess;

    public $_table = 'kt_video_user';
    public $_primarykey = 'id';
    public $_fields = array('id', 'userid', 'videoid', 'wyvideoid', 'seetime', 'file_time', 'last_time', 'issuccess');

    public function __construct() {
        parent::setupModel(__CLASS__);
    }

    public function getvideoMsg($uid,$videoid){
        return $this->getOne(array('where' => 'userid=? and videoid=?', 'param' => array($uid,$videoid), 'asArray' => TRUE));
    }

    public function gettimebywyvideo($uid,$wyid){

        //不知道doophp为啥无法查询到数据库信息，故采用原生写法
//        $result = $this->getOne(array('select' => 'seetime', 'where' => 'userid="'.$uid.'" and wyvideoid="'.$wyid.'"', 'asArray' => TRUE));

        $sql = 'select seetime,file_time from ' . $this->_table . ' where userid="'.$uid.'" and wyvideoid="'.$wyid.'"';
        $query = Doo::db ()->query ( $sql );
        $result = $query->fetch ();

        if(!empty($result) && $result['seetime'] != $result['file_time']){
            return $result['seetime'];
        }else
            return 0;
    }
}