src/Biz/Card/Dao/Impl/CardDaoImpl.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php

namespace Biz\Card\Dao\Impl;

use Biz\Card\Dao\CardDao;
use Codeages\Biz\Framework\Dao\GeneralDaoImpl;

class CardDaoImpl extends GeneralDaoImpl implements CardDao
{
    protected $table = 'card';

    public function getByCardId($cardId)
    {
        return $this->getByFields(array(
            'cardId' => $cardId,
        ));
    }

    public function getByUserId($userId)
    {
        return $this->getByFields(array(
            'userId' => $userId,
        ));
    }

    public function updateByCardIdAndCardType($cardId, $cardType, $fields)
    {
        $this->db()->update($this->table, $fields, array('cardId' => $cardId, 'cardType' => $cardType));

        return $this->getByCardIdAndCardType($cardId, $cardType);
    }

    public function getByCardIdAndCardType($cardId, $cardType)
    {
        return $this->getByFields(array(
            'cardId' => $cardId,
            'cardType' => $cardType,
        ));
    }

    public function findByUserIdAndCardType($userId, $cardType)
    {
        $sql = "SELECT * FROM {$this->table} WHERE userId = ? AND cardType = ?";

        return $this->db()->fetchAll($sql, array($userId, $cardType)) ?: array();
    }

    public function findByUserIdAndCardTypeAndStatus($userId, $cardType, $status)
    {
        $sql = "SELECT * FROM {$this->table} WHERE userId = ? AND cardType =? AND status = ?";

        return $this->db()->fetchAll($sql, array($userId, $cardType, $status)) ?: array();
    }

    public function findByCardIds(array $cardIds)
    {
        return $this->findInField('cardId', $cardIds);
    }

    public function declares()