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();
}
