/**
* Gets object from database
* @param integer $groupId
* @return object $Group
*/
function Get($groupId)
{
$Database = new DatabaseConnection();
$this->pog_query = "select * from `group` where `groupid`='" . intval($groupId) . "' LIMIT 1";
$Database->Query($this->pog_query);
$this->groupId = $Database->Result(0, "groupid");
$this->name = $Database->Unescape($Database->Result(0, "name"));
$this->desc = $Database->Unescape($Database->Result(0, "desc"));
return $this;
}
/**
* Gets object from database
* @param integer $supplierId
* @return object $Supplier
*/
function Get($supplierId)
{
$Database = new DatabaseConnection();
$this->pog_query = "select * from `supplier` where `supplierid`='" . intval($supplierId) . "' LIMIT 1";
$Database->Query($this->pog_query);
$this->supplierId = $Database->Result(0, "supplierid");
$this->company = $Database->Unescape($Database->Result(0, "company"));
$this->address1 = $Database->Unescape($Database->Result(0, "address1"));
$this->address2 = $Database->Unescape($Database->Result(0, "address2"));
$this->city = $Database->Unescape($Database->Result(0, "city"));
$this->phone = $Database->Unescape($Database->Result(0, "phone"));
$this->contactname = $Database->Unescape($Database->Result(0, "contactname"));
$this->contactno = $Database->Unescape($Database->Result(0, "contactno"));
$this->deleted = $Database->Unescape($Database->Result(0, "deleted"));
return $this;
}
/**
* Gets object from database
* @param integer $userId
* @return object $User
*/
function Get($userId)
{
$Database = new DatabaseConnection();
$this->pog_query = "select * from `user` where `userid`='" . intval($userId) . "' LIMIT 1";
$Database->Query($this->pog_query);
$this->userId = $Database->Result(0, "userid");
$this->username = $Database->Unescape($Database->Result(0, "username"));
$this->password = $Database->Unescape($Database->Result(0, "password"));
$this->firstname = $Database->Unescape($Database->Result(0, "firstname"));
$this->lastname = $Database->Unescape($Database->Result(0, "lastname"));
$this->question = $Database->Unescape($Database->Result(0, "question"));
$this->answer = $Database->Unescape($Database->Result(0, "answer"));
$this->groupId = $Database->Result(0, "groupid");
$this->lastlogin = $Database->Unescape($Database->Result(0, "lastlogin"));
$this->disabled = $Database->Unescape($Database->Result(0, "disabled"));
return $this;
}
/**
* Gets object from database
* @param integer $customerId
* @return object $Customer
*/
function Get($customerId)
{
$Database = new DatabaseConnection();
$this->pog_query = "select * from `customer` where `customerid`='" . intval($customerId) . "' LIMIT 1";
$Database->Query($this->pog_query);
$this->customerId = $Database->Result(0, "customerid");
$this->company = $Database->Unescape($Database->Result(0, "company"));
$this->firstname = $Database->Unescape($Database->Result(0, "firstname"));
$this->lastname = $Database->Unescape($Database->Result(0, "lastname"));
$this->address1 = $Database->Unescape($Database->Result(0, "address1"));
$this->address2 = $Database->Unescape($Database->Result(0, "address2"));
$this->city = $Database->Unescape($Database->Result(0, "city"));
$this->mobile = $Database->Unescape($Database->Result(0, "mobile"));
$this->landline = $Database->Unescape($Database->Result(0, "landline"));
$this->email = $Database->Unescape($Database->Result(0, "email"));
$this->limit = $Database->Unescape($Database->Result(0, "limit"));
$this->available = $Database->Unescape($Database->Result(0, "available"));
$this->deleted = $Database->Unescape($Database->Result(0, "deleted"));
return $this;
}
