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