public function getAllRegisteredUser($row)
{
$sqlGetAllRes = "SELECT CUS_ID,CUS_USERNAME,CUS_PASSWORD,CUS_EMAIL,CUS_FIRST_NAME,CUS_LAST_NAME,CUS_GENDER,CUS_CONTACT_ADDRESS,CUS_RECEIPT_ADDRESS,CUS_PHONE_NUMBER,CUS_FACEBOOK_ADDRESS,CREATED_DATE_TIME FROM RICH_CUSTOMER ORDER BY CREATED_DATE_TIME DESC LIMIT " . $row;
$result = mysql_query($sqlGetAllRes);
$listUser = new ArrayList();
while ($row = mysql_fetch_array($result)) {
$userObj = new CustomerVO();
$userObj->setCusID($row['CUS_ID']);
$userObj->setCusUsername($row['CUS_USERNAME']);
$userObj->setCusPassword($row['CUS_PASSWORD']);
$userObj->setCusEmail($row['CUS_EMAIL']);
$userObj->setCusFirstName($row['CUS_FIRST_NAME']);
$userObj->setCusLastName($row['CUS_LAST_NAME']);
$userObj->setCusGender($row['CUS_GENDER']);
$userObj->setCusContactAddr($row['CUS_CONTACT_ADDRESS']);
$userObj->setCusReceiptAddr($row['CUS_RECEIPT_ADDRESS']);
$userObj->setPhoneNumber($row['CUS_PHONE_NUMBER']);
$userObj->setCusFacebookAddr($row['CUS_FACEBOOK_ADDRESS']);
$userObj->setCusCreatedDateTime($row['CREATED_DATE_TIME']);
$listUser->Add($userObj);
}
return $listUser;
}
