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; }
$email = (string) filter_input(INPUT_GET, 'email'); $fName = (string) filter_input(INPUT_GET, 'fName'); $lName = (string) filter_input(INPUT_GET, 'lName'); $gender = (string) filter_input(INPUT_GET, 'gender'); $address = (string) filter_input(INPUT_GET, 'address'); $phone = (string) filter_input(INPUT_GET, 'phone'); $facebookAdr = (string) filter_input(INPUT_GET, 'facebookAdr'); $customerVO = new CustomerVO(); $customerVO->setCusID(md5(date("h:i:sa"))); $customerVO->setCusUsername($username); $customerVO->setCusPassword(md5($password)); $customerVO->setCusEmail($email); $customerVO->setCusFirstName($fName); $customerVO->setCusLastName($lName); $customerVO->setCusGender($gender); $customerVO->setCusContactAddr($address); $customerVO->setPhoneNumber($phone); $customerVO->setCusFacebookAddr($facebookAdr); $customerVO->setForceChange("false"); if ($customerService->duplicationUsername($username) && $customerService->duplicationEmail($email)) { echo "Your username and email have been used"; } else { if ($customerService->duplicationUsername($username)) { echo "This username have been used"; } else { if ($customerService->duplicationEmail($email)) { echo "This email have been used"; } else { $saveResult = $customerService->saveCustomer($customerVO); if ($saveResult == 200) { if ($iniConfiguration['email.sending.to.customer'] == true) {
$lName = $tmpName[1]; $cusID = md5(date("h:i:sa") . "-" . $rowGetMore['TMP_EMAIL']); $email = $rowGetMore['TMP_EMAIL']; $phone = $rowGetMore['TMP_PHONE_NUMBER']; //promote unknown user to member $cusDaoImpl = new CustomerDaoImpl(); $customerService = new CustomerService($cusDaoImpl); $customerVO = new CustomerVO(); $customerVO->setCusID($cusID); $customerVO->setCusUsername($email); $customerVO->setCusPassword(md5($iniConfiguration['guest.password.default'])); $customerVO->setCusEmail($email); $customerVO->setCusFirstName($fName); $customerVO->setCusLastName($lName); $customerVO->setCusGender(""); $customerVO->setCusContactAddr($rowGetMore['CONTACT_ADDR']); $customerVO->setCusReceiptAddr($rowGetMore['RECEIPT_ADDR']); $customerVO->setPhoneNumber($phone); $customerVO->setCusFacebookAddr(""); $customerVO->setForceChange("true"); $saveUserResult = $customerService->saveCustomer($customerVO); if ($saveUserResult == 200) { //Sending register email if ($iniConfiguration['email.sending.to.customer'] == true) { $resetUrl = $iniConfiguration['web.application.prefix'] . "view/forceChangePassword?cusID=" . $cusID; $emailContent = new EmailContent(); $emailBody = $emailContent->getCustomerEmailRegister($resetUrl, $email, $iniConfiguration['guest.password.default'], $iniConfiguration['web.application.prefix']); $sendingEmail = new SendingEmail($iniConfiguration['email.host'], $iniConfiguration['email.username'], $iniConfiguration['email.password'], $email, $iniConfiguration['email.subject.customer.register.prefix'], $emailBody, $iniConfiguration['email.username'], $iniConfiguration['email.name']); $sendingEmail->sendingEmail(); } $resultFromCheckCust = $custEnrollService->checkCustAlreadyEnrollByEnrollID($courseID, $cusID);