function insertMember($data)
{
$mbr = new Member();
$mbrQ = new MemberQuery();
$mbr->setFirstName($data[0]);
$mbr->setLastName($data[1]);
$mbr->setGender($data[2]);
$mbr->setSchoolId($data[3]);
$mbr->setStandard($data[4]);
$mbr->setGrade($data[5]);
$mbr->setRollNo($data[6]);
$mbr->setParentName($data[7]);
$mbr->setParentOccupation($data[8]);
$mbr->setMotherTongue($data[9]);
$barcode = $mbrQ->assignRollNumber($mbr);
$mbr->setBarcodeNmbr($barcode);
$mbr->setClassification(3);
return $mbrQ->insert($mbr);
}
static function _createFakeMemberFromEmail($email)
{
$member = new Member();
$member->setFirstName('Customer');
$member->setEmail($email);
return $member;
}
function _mkObj($array)
{
$mbr = new Member();
$mbr->setMbrid($array["mbrid"]);
$mbr->setBarcodeNmbr($array["barcode_nmbr"]);
$mbr->setLastChangeDt($array["last_change_dt"]);
$mbr->setLastChangeUserid($array["last_change_userid"]);
if (isset($array["username"])) {
$mbr->setLastChangeUsername($array["username"]);
}
$mbr->setLastName($array["last_name"]);
$mbr->setFirstName($array["first_name"]);
$mbr->setAddress($array["address"]);
$mbr->setHomePhone($array["home_phone"]);
$mbr->setWorkPhone($array["work_phone"]);
$mbr->setCel($array["cel"]);
$mbr->setEmail($array["email"]);
$mbr->setFoto($array["foto"]);
//jalg foto member
$mbr->setPassUser($array["pass_user"]);
$mbr->setBornDt($array["born_dt"]);
$mbr->setOther($array["other"]);
$mbr->setClassification($array["classification"]);
$mbr->setStatus($array["is_active"]);
$mbr->setLastActDate($array["last_activity_dt"]);
$mbr->_custom = $this->getCustomFields($array['mbrid']);
return $mbr;
}
if (count($_POST) == 0) {
header("Location: ../user/index.php");
exit;
}
#****************************************************************************
#* Validate data
#****************************************************************************
$mbrid = $_POST["mbrid"];
$mbr = new Member();
$mbr->setMbrid($_POST["mbrid"]);
$mbr->setBarcodeNmbr($_POST["barcodeNmbr"]);
$_POST["barcodeNmbr"] = $mbr->getBarcodeNmbr();
$mbr->setLastChangeUserid($_SESSION["userid"]);
$mbr->setLastName($_POST["lastName"]);
$_POST["lastName"] = $mbr->getLastName();
$mbr->setFirstName($_POST["firstName"]);
$_POST["firstName"] = $mbr->getFirstName();
$mbr->setAddress($_POST["address"]);
$_POST["address"] = $mbr->getAddress();
$mbr->setHomePhone($_POST["homePhone"]);
$_POST["homePhone"] = $mbr->getHomePhone();
$mbr->setWorkPhone($_POST["workPhone"]);
$_POST["workPhone"] = $mbr->getWorkPhone();
$mbr->setCel($_POST["cel"]);
$_POST["cel"] = $mbr->getCel();
$mbr->setEmail($_POST["email"]);
$_POST["email"] = $mbr->getEmail();
$mbr->setFoto($_POST["foto"]);
$_POST["foto"] = $mbr->getFoto();
$mbr->setPassUser($_POST["passUser"]);
$_POST["passUser"] = $mbr->getPassUser();
public static function createFromSignup($data, $refererMember, Invitation $invitation = null, PropelPDO $con)
{
// This functions expects this parameter to be valid!
// E.g. the result from self::validateSignupForm()
$now = time();
if (!$con->beginTransaction()) {
throw new Exception('Could not begin transaction');
}
try {
$member = new Member();
$member->setFirstName($data['firstName'])->setLastName($data['lastName'])->setEmail($data['email'])->setTitle($data['title'])->setCity($data['city'])->setCountry($data['country'])->setAge($data['age'])->setBankRecipient($data['bank_recipient'])->setIban($data['iban'])->setBic($data['bic'])->setPassword($data['password'])->setSignupDate($now);
if ($invitation) {
$member->setType($invitation->getType());
if ($invitation->getFreeSignup()) {
$member->setPaidDate($now);
}
$invitation->setAcceptedDate($now);
}
$member->setRefererMember($refererMember, $con);
$member->save($con);
if ($invitation) {
$invitation->setAcceptedMemberId($member->getId());
$invitation->save($con);
}
if (!$con->commit()) {
throw new Exception('Could not commit transaction');
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
return $member;
}
function _mkObj($array)
{
$mbr = new Member();
$mbr->setMbrid($array["mbrid"]);
$mbr->setBarcodeNmbr($array["barcode_nmbr"]);
$mbr->setLastChangeDt($array["last_change_dt"]);
$mbr->setLastChangeUserid($array["last_change_userid"]);
if (isset($array["username"])) {
$mbr->setLastChangeUsername($array["username"]);
}
$mbr->setLastName($array["last_name"]);
$mbr->setFirstName($array["first_name"]);
$mbr->setAddress($array["address"]);
$mbr->setHomePhone($array["home_phone"]);
$mbr->setWorkPhone($array["work_phone"]);
$mbr->setEmail($array["email"]);
$mbr->setClassification($array["classification"]);
$mbr->_custom = $this->getCustomFields($array['mbrid']);
return $mbr;
}
function _mkObj($array)
{
$mbr = new Member();
$mbr->setMbrid($array["mbrid"]);
$mbr->setBarcodeNmbr($array["barcode_nmbr"]);
$mbr->setLastChangeDt($array["last_change_dt"]);
$mbr->setLastChangeUserid($array["last_change_userid"]);
if (isset($array["username"])) {
$mbr->setLastChangeUsername($array["username"]);
}
$mbr->setGender($array["gender"]);
$mbr->setSchoolId($array["schoolid"]);
$mbr->setParentName($array["parent_name"]);
$mbr->setParentOccupation($array["parent_occupation"]);
$mbr->setMotherTongue($array["mother_tongue"]);
$mbr->setStandard($array["standard"]);
$mbr->setSchoolTeacher($array["school_teacher"]);
$mbr->setGrade($array["grade"]);
$mbr->setLastName($array["last_name"]);
$mbr->setFirstName($array["first_name"]);
$mbr->setAddress($array["address"]);
$mbr->setHomePhone($array["home_phone"]);
$mbr->setWorkPhone($array["work_phone"]);
$mbr->setEmail($array["email"]);
$mbr->setClassification($array["classification"]);
$mbr->_custom = $this->getCustomFields($array['mbrid']);
return $mbr;
}
if (count($row) > 0) {
$rows[] = $row;
}
$row_count++;
}
fclose($handle);
// Save to the database
foreach ($rows as $row) {
$member = new Member();
$member->setMbrid($row['mbrid']);
$member->setBarcodeNmbr($row['barcode_nmbr']);
$member->setCreateDt($row['create_dt']);
$member->setLastChangeDt($row['last_change_dt']);
$member->setLastChangeUserid($row['last_change_userid']);
$member->setLastName($row['last_name']);
$member->setFirstName($row['first_name']);
$member->setAddress($row['address']);
$member->setHomePhone($row['home_phone']);
$member->setWorkPhone($row['work_phone']);
$member->setCel($row['cel']);
$member->setEmail($row['email']);
$member->setFoto($row['foto']);
$member->setPassUser($row['pass_user']);
$member->setBornDt($row['born_dt']);
$member->setOther($row['other']);
$member->setClassification($row['classification']);
$member->setStatus($row['is_active']);
$member->setLastActDate($row['last_activity_dt']);
$mbrQ = new MemberQuery();
$mbrQ->connect();
$dupBarcode = $mbrQ->DupBarcode($row['barcode_nmbr']);
public function createFromSignup($data, $referrerMember, \Invitation $invitation = null, \PropelPDO $con)
{
// This functions expects this parameter to be valid!
// E.g. the result from $this->validateSignupForm()
$now = time();
if (!$con->beginTransaction()) {
throw new \Exception('Could not begin transaction');
}
try {
$member = new \Member();
$member->setFirstName($data['firstName'])->setLastName($data['lastName'])->setEmail($data['email'])->setTitle($data['title'])->setCity($data['city'])->setZipCode($data['zip_code'])->setCountry('India')->setAge($data['age'])->setBankRecipient($data['bank_recipient'])->setIban($data['iban'])->setBic($data['bic'])->setPassword($data['password'])->setSignupDate($now)->setBonusIds('{}')->setPaidDate(null)->setIsExtended(1);
$member->setHash(\Member::calcHash($member));
$wasFreeInvitation = false;
if ($invitation) {
$invitationType = $invitation->getType();
$member->setType($invitationType);
// Special case if e.g. director invites another director.
// The referrer of the referrer will be the referrer.
// This is necessary because the same type can not be on same line vertical
// but horizontal. E.g. Director can have more marketing leader under him
// but only Directors next to him (NOT under him)
if ($invitationType > \Member::TYPE_MEMBER && $referrerMember->getType() == $invitationType) {
$referrerMember = $referrerMember->getReferrerMember();
}
$invitation->setAcceptedDate($now);
if ($invitation->getFreeSignup()) {
$member->setFreeInvitation(1);
$wasFreeInvitation = true;
}
// Deprecated code
// if ( $invitation->getType() === \Member::TYPE_SUB_PROMOTER ) {
// $member->setSubPromoterReferral($invitation->getMeta()['promoter_id']);
// }
}
$member->setReferrerMember($referrerMember, $con);
$member->save($con);
$member->setNum($member->getId() + 1000000);
if ($invitation) {
$invitation->setAcceptedMemberId($member->getId());
$invitation->save($con);
if ($wasFreeInvitation) {
$member->onReceivedMemberFee(\Transaction::$BASE_CURRENCY, $now, true, $con);
}
}
if ($wasFreeInvitation) {
\Tbmt\MailHelper::sendFreeSignupConfirm($member);
\Tbmt\MailHelper::sendNewFreeRecruitmentCongrats($referrerMember, $member);
} else {
\Tbmt\MailHelper::sendSignupConfirm($member);
\Tbmt\MailHelper::sendNewRecruitmentCongrats($referrerMember, $member);
}
$member->save($con);
if (!$con->commit()) {
throw new \Exception('Could not commit transaction');
}
} catch (\Exception $e) {
$con->rollBack();
throw $e;
}
return $member;
}
