ChapterOrder.php 998 B

1234567891011121314151617181920212223242526272829303132333435363738
  1. <?php
  2. namespace App\Modules\Subscribe\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. class ChapterOrder extends Model
  5. {
  6. protected $connection = 'chapter_order_mysql';
  7. protected $fillable = [
  8. 'distribution_channel_id','bid','cid', 'chapter_name','book_name','uid','u','fee','book_name','send_order_id','charge_balance','reward_balance'
  9. ];
  10. function setCurrentTable($uid)
  11. {
  12. $this->setTable('chapter_orders'.$uid%512);
  13. }
  14. //判断是否订购
  15. function checkIsOrdered($uid,$bid,$cid)
  16. {
  17. return self::where('uid',$uid)
  18. ->where('bid',$bid)
  19. ->where('cid',$cid)
  20. ->count();
  21. }
  22. function getByUid($uid,$page_size){
  23. return self::where('uid',$uid)->orderBy('created_at','desc')->paginate($page_size);
  24. }
  25. public function getChapterOrderLists($uid,$page_size){
  26. return $this->where('uid',$uid)->orderBy('created_at','desc')->paginate($page_size);
  27. }
  28. }