/**
* Checks whether the passed date is available for
* booking.
*
* @static true
* @param string $date
* @access public
* @since 1.0.0
*/
public static function isDateBlocked($productVendorLocationID, $date)
{
//query to check if current date is available
$queryResult = SELF::where(DB::raw('DATE(block_date)'), '=', $date)->where('product_vendor_location_id', $productVendorLocationID)->get();
if ($queryResult && count($queryResult) > 0) {
return TRUE;
}
return FALSE;
}
public static function GetByUserID($userid)
{
return SELF::where('usrid', '=', $userid);
}
public static function GetByidgrp($id_grp)
{
return SELF::where('id_grp', '=', $id_grp);
}
public static function GetByIDitem($id_item)
{
return SELF::where('id_item', '=', $id_item);
}
public static function GetByRoleID($id)
{
return SELF::where('rid', '=', $id);
}
public static function getPermissionByName($name)
{
//print_r(SELF::where('name', '=', $name)->get());
//print_r(DB::getQueryLog());
return SELF::where('name', '=', $name);
}
public static function GetByGallID($id_gallery)
{
return SELF::where('id_gallery', '=', $id_gallery);
}
public static function GetByCatID($catid)
{
return SELF::where('catid', '=', $catid);
}
public static function GetBycode($code)
{
return SELF::where('code', '=', $code);
}
public static function GetByArtID($id_artikel)
{
return SELF::where('id_artikel', '=', $id_artikel);
}
