/** * 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); }