Consultants.php 803 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. namespace App\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. class Consultants extends Model
  5. {
  6. protected $table = 'consultant';
  7. public static function getList(int $page = 1, int $limit = 10) {
  8. $offset = ($page - 1) * $limit;
  9. $query = Consultants::query()->offset($offset)->limit($limit)->get();
  10. if ($query){
  11. return $query->toArray();
  12. }else{
  13. return [];
  14. }
  15. }
  16. public static function insertData(array $data)
  17. {
  18. return Consultants::query()->insert($data);
  19. }
  20. public static function checkConsultants(int $id)
  21. {
  22. $query = Consultants::query()->where('user_id', $id)->first();
  23. if ($query){
  24. return $query->toArray();
  25. }else{
  26. return [];
  27. }
  28. }
  29. }