TbrCalculation.php 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. <?php
  2. namespace App\Models;
  3. use Illuminate\Database\Eloquent\Factories\HasFactory;
  4. use Illuminate\Database\Eloquent\Model;
  5. use Illuminate\Database\Eloquent\Relations\BelongsTo;
  6. /**
  7. * @property int $id
  8. * @property int $unit_id
  9. * @property numeric $revenue_value
  10. * @property int $contract_month_reference
  11. * @property numeric $tbr_value
  12. * @property int $fnm_bracket_id
  13. * @property numeric $fnm_bracket_percentage
  14. * @property numeric $fnm_bracket_value
  15. * @property int $maintenance_bracket_id
  16. * @property numeric $maintenance_bracket_percentage
  17. * @property numeric $maintenance_bracket_value
  18. * @property int $royalties_bracket_id
  19. * @property numeric $royalties_bracket_percentage
  20. * @property numeric $royalties_bracket_value
  21. * @property numeric $fnm_effective_percentage
  22. * @property numeric $fnm_effective_value
  23. * @property numeric $royalties_effective_percentage
  24. * @property numeric $royalties_effective_value
  25. * @property numeric $maintenance_effective_percentage
  26. * @property numeric $maintenance_effective_value
  27. * @property numeric $bracket_subtotal
  28. * @property numeric $subtotal
  29. * @property numeric $final_value
  30. * @property int $user_id
  31. * @property string $royalties_applied_criteria
  32. * @property bool $receivable_generated
  33. * @property \Illuminate\Support\Carbon|null $created_at
  34. * @property \Illuminate\Support\Carbon|null $updated_at
  35. * @property-read \App\Models\FranchiseeFnmBracket $fnmBracket
  36. * @property-read \App\Models\FranchiseeMaintenanceBracket $maintenanceBracket
  37. * @property-read \App\Models\FranchiseeRoyaltiesBracket $royaltiesBracket
  38. * @property-read \App\Models\Unit $unit
  39. * @property-read \App\Models\User $user
  40. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation newModelQuery()
  41. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation newQuery()
  42. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation query()
  43. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereBracketSubtotal($value)
  44. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereContractMonthReference($value)
  45. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereCreatedAt($value)
  46. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereFinalValue($value)
  47. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereFnmBracketId($value)
  48. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereFnmBracketPercentage($value)
  49. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereFnmBracketValue($value)
  50. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereFnmEffectivePercentage($value)
  51. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereFnmEffectiveValue($value)
  52. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereId($value)
  53. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereMaintenanceBracketId($value)
  54. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereMaintenanceBracketPercentage($value)
  55. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereMaintenanceBracketValue($value)
  56. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereMaintenanceEffectivePercentage($value)
  57. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereMaintenanceEffectiveValue($value)
  58. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereReceivableGenerated($value)
  59. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRevenueValue($value)
  60. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRoyaltiesAppliedCriteria($value)
  61. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRoyaltiesBracketId($value)
  62. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRoyaltiesBracketPercentage($value)
  63. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRoyaltiesBracketValue($value)
  64. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRoyaltiesEffectivePercentage($value)
  65. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereRoyaltiesEffectiveValue($value)
  66. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereSubtotal($value)
  67. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereTbrValue($value)
  68. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereUnitId($value)
  69. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereUpdatedAt($value)
  70. * @method static \Illuminate\Database\Eloquent\Builder<static>|TbrCalculation whereUserId($value)
  71. * @mixin \Eloquent
  72. */
  73. class TbrCalculation extends Model
  74. {
  75. use HasFactory;
  76. protected $table = 'tbr_calculations';
  77. protected $guarded = ['id'];
  78. protected $casts = [
  79. 'revenue_value' => 'decimal:2',
  80. 'tbr_value' => 'decimal:2',
  81. 'fnm_bracket_percentage' => 'decimal:4',
  82. 'fnm_bracket_value' => 'decimal:2',
  83. 'maintenance_bracket_percentage' => 'decimal:4',
  84. 'maintenance_bracket_value' => 'decimal:2',
  85. 'royalties_bracket_percentage' => 'decimal:4',
  86. 'royalties_bracket_value' => 'decimal:2',
  87. 'fnm_effective_percentage' => 'decimal:4',
  88. 'fnm_effective_value' => 'decimal:2',
  89. 'royalties_effective_percentage' => 'decimal:4',
  90. 'royalties_effective_value' => 'decimal:2',
  91. 'maintenance_effective_percentage' => 'decimal:4',
  92. 'maintenance_effective_value' => 'decimal:2',
  93. 'bracket_subtotal' => 'decimal:2',
  94. 'subtotal' => 'decimal:2',
  95. 'final_value' => 'decimal:2',
  96. 'receivable_generated' => 'boolean',
  97. 'created_at' => 'datetime',
  98. 'updated_at' => 'datetime',
  99. ];
  100. public function unit(): BelongsTo
  101. {
  102. return $this->belongsTo(Unit::class, 'unit_id');
  103. }
  104. public function fnmBracket(): BelongsTo
  105. {
  106. return $this->belongsTo(FranchiseeFnmBracket::class, 'fnm_bracket_id');
  107. }
  108. public function maintenanceBracket(): BelongsTo
  109. {
  110. return $this->belongsTo(FranchiseeMaintenanceBracket::class, 'maintenance_bracket_id');
  111. }
  112. public function royaltiesBracket(): BelongsTo
  113. {
  114. return $this->belongsTo(FranchiseeRoyaltiesBracket::class, 'royalties_bracket_id');
  115. }
  116. public function user(): BelongsTo
  117. {
  118. return $this->belongsTo(User::class, 'user_id');
  119. }
  120. }