public static function FromUserName($userName) { $o = NULL; $sql = "select UserID , UserName, UserPassWord, FullName, Email, DateOfBirth, Gender, UserCreated, UserLastModified, LastLogon ,UserPermission from users where UserName = '******'"; $resultSet = DataProvider::Load($sql); if ($row = $resultSet->fetch_assoc()) { $UserID = $row["UserID"]; $UserName = $row["UserName"]; $Password = $row["UserPassWord"]; $FullName = $row["FullName"]; $Email = $row["Email"]; $DateOfBirth = new DateTime($row["DateOfBirth"]); $Gender = $row["Gender"]; $UserCreated = new DateTime($row["UserCreated"]); $UserLastModified = new DateTime($row["UserLastModified"]); $LastLogon = new DateTime($row["LastLogon"]); $Permission = $row["UserPermission"]; $o = new User($UserID, $UserName, $Password, $Email, $FullName, $Gender, $DateOfBirth, $UserCreated, $UserLastModified, $LastLogon, $Permission); } return $o; }
public static function getValueMaxColName($MaxColName) { $sql = "select MAX(" . $MaxColName . ") AS Max " . "from products "; $resultSet = DataProvider::Load($sql); $row = $resultSet->fetch_assoc(); $max = $row['Max']; return $max; }
public static function getOrderDetail($iOrderDetailID) { $o = null; $sql = "select OrderDetailID, OrderID, p.ProID as ProID, ProName , od.Quantity, od.Price, Amount from orderdetails od, products p" . " where od.ProID = p.ProID and OrderDetailID = " . $iOrderDetailID; $resultSet = DataProvider::Load($sql); if ($row = $resultSet->fetch_assoc()) { $id = $row["OrderDetailID"]; $oOrder = new Order($row["OrderID"]); $oProduct = new Product($row["ProID"], $row["ProName"]); $quantity = $row["Quantity"]; $price = $row["Price"]; $amount = $row["Amount"]; $o = new OrderDetail($id, $oProduct, $oOrder, $price, $quantity, $amount); } return $o; }
public static function getStatus($iStatusID) { $o = null; $sql = "select StatusID, StatusName, StatusColor " . "from statuses where StatusID = " . $iStatusID; $resultSet = DataProvider::Load($sql); if ($row = $resultSet->fetch_assoc()) { $iStatusID = $row["StatusID"]; $strStatusName = $row["StatusName"]; $strStatusColor = $row["StatusColor"]; $o = new Status($iStatusID, $strStatusName, $strStatusColor); } return $o; }
function Load() { $dataProvider = new DataProvider($this->SessionFile); $dataProvider->Load(); $this->IP = $dataProvider->Result["s_ip"]; $this->SystemInfo = $dataProvider->Result["s_system"]; $this->Language = $dataProvider->Result["s_language"]; $this->Resolution = $dataProvider->Result["s_resolution"]; $this->Host = $dataProvider->Result["s_host"]; if (isset($dataProvider->Result["s_geotz"])) { $this->GeoTimezoneOffset = $dataProvider->Result["s_geotz"]; } if (isset($dataProvider->Result["s_geolong"])) { $this->GeoLongitude = $dataProvider->Result["s_geolong"]; } if (isset($dataProvider->Result["s_geolat"])) { $this->GeoLatitude = $dataProvider->Result["s_geolat"]; } if (isset($dataProvider->Result["s_geocity"])) { $this->GeoCity = $dataProvider->Result["s_geocity"]; } if (isset($dataProvider->Result["s_geocountry"])) { $this->GeoCountryISO2 = $dataProvider->Result["s_geocountry"]; } if (isset($dataProvider->Result["s_georegion"])) { $this->GeoRegion = $dataProvider->Result["s_georegion"]; } if (isset($dataProvider->Result["s_visits"])) { $this->Visits = $dataProvider->Result["s_visits"]; } if (isset($dataProvider->Result["s_georid"])) { $this->GeoResultId = $dataProvider->Result["s_georid"]; } if (isset($dataProvider->Result["s_geoisp"])) { $this->GeoISP = $dataProvider->Result["s_geoisp"]; } }
public static function getDevice($iDeviceID) { $o = null; $sql = "select DeviceID, DeviceName , Discontinued " . "from devices where DeviceID = " . $iDeviceID; $resultSet = DataProvider::Load($sql); if ($row = $resultSet->fetch_assoc()) { $iDeviceID = $row["DeviceID"]; $strDeviceName = $row["DeviceName"]; $status = $row["Discontinued"]; $o = new Device($iDeviceID, $strDeviceName, $status); } return $o; }
public static function getCat($iCatProID) { $o = null; $sql = "select CatProID, CatName, c.DeviceID as DeviceID, d.DeviceName as DeviceName , c.Discontinued as Discontinued , c.BraID as BraID , b.BraName as BraName " . "from categories as c , devices as d , brands as b where b.BraID = c.BraID and d.DeviceID = c.DeviceID and CatProID = " . $iCatProID; $resultSet = DataProvider::Load($sql); if ($row = $resultSet->fetch_assoc()) { $iCatProID = $row["CatProID"]; $strCatName = $row["CatName"]; $iBraID = $row["BraID"]; $strBraName = $row["BraName"]; $oBrand = new Brand($iBraID, $strBraName); $iDeviceID = $row["DeviceID"]; $strDeviceName = $row["DeviceName"]; $oDevice = new Device($iDeviceID, $strDeviceName); $status = $row["Discontinued"]; $o = new Category($iCatProID, $strCatName, $oBrand, $oDevice, $status); } return $o; }
public static function getBrand($iBraID) { $sql = "select BraID, BraName, LogoURL , Discontinued " . "from brands where BraID = " . $iBraID; $resultSet = DataProvider::Load($sql); $o = null; if ($row = $resultSet->fetch_assoc()) { $iBraID = $row["BraID"]; $strBraName = $row["BraName"]; $strLogoURL = $row["LogoURL"]; $status = $row["Discontinued"]; $o = new Brand($iBraID, $strBraName, $strLogoURL, $status); } return $o; }
function Load($_chatfile) { if (isnull($_chatfile)) { $dataProvider = new DataProvider($this->TargetFileExternal); } else { $dataProvider = new DataProvider($_chatfile); } $dataProvider->Load(); $this->Id = $dataProvider->Result["s_id"]; $this->InternalUser = new Operator($dataProvider->Result["s_internal_sessid"], $dataProvider->Result["s_internal_userid"]); $this->ExternalUser = new ExternalChat($dataProvider->Result["s_external_userid"], $dataProvider->Result["s_external_browserid"]); $this->InternalUser->Fullname = $dataProvider->Result["s_internal_fullname"]; $this->SetDirectories(); }