<?php

/**
 * SoftwareToolModel class file
 *
 * PHP Version 7.2
 *
 * @category Model
 * @package  Ez
 * @author   Imenso Software <admin@imensosoftware.com>
 * @license  http://imensosoftware/license.php GNU Public License
 * @link     http://imensosoftware.com/recipes
 */

namespace App\Models;
  
use Illuminate\Database\Eloquent\Model;
  
/**
 * SoftwareToolModel class
 *
 * The class manage Software Tool related queries
 *
 * @category SoftwareToolModel
 * @package  Ez
 * @author   Imenso Software <admin@imensosoftware.com>
 * @license  http://imensosoftware/license.php GNU Public License
 * @link     http://imensosoftware.com/recipes
 */

class SoftwareTool extends Model
{
    public $table = "software_tools";
    public $fillable = ['software_id','tool'];
    public $timestamps = false;

    /**
     * GetSoftwareTools function gets the software tools from storage
     * and return software tools
     *
     * @param  void
     * @return \App\Models\SoftwareTool
     */
    public static function getSoftwareTools()
    {
        $softwareTools = SoftwareTool::
        select("software_tools.*", 'softwares.software')
            ->leftJoin('softwares', 'softwares.id', '=', 'software_tools.software_id')
            ->get();
        return $softwareTools;
    }
}