File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/app/Models/SLA.php
Back
<?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; use Illuminate\Support\Facades\DB; class SLA extends Model { use HasFactory; protected $fillable = ['content']; protected $table = ['service_level_agreement']; public function getSLAQuery(){ return "SELECT %s FROM `service_level_agreement` WHERE 1 AND `status` = 1 %s %s %s %s "; } public function getSLA($array_data){ $fields = " * "; $query = sprintf( $this->getSLAQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); return DB::select($query); } public function getSLACount($array_data){ $fields = " COUNT(1) as Count "; $query = sprintf( $this->getSLAQuery(), $fields, '', $array_data['where'], '', '' ); return DB::select($query); } public function getSLAFilteredCount($array_data){ $fields = " COUNT(1) as FilteredCount "; $query = sprintf( $this->getSLAQuery(), $fields, $array_data['search'], $array_data['where'], '', '' ); return DB::select($query); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings