/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aLeasingParkingLeads !== null) {
if ($this->aLeasingParkingLeads->isModified() || $this->aLeasingParkingLeads->isNew()) {
$affectedRows += $this->aLeasingParkingLeads->save($con);
}
$this->setLeasingParkingLeads($this->aLeasingParkingLeads);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
} else {
$this->doUpdate($con);
}
$affectedRows += 1;
$this->resetModified();
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
public function saveParkingLeadAction()
{
$request = $this->getRequest();
$directory = $request->server->get('DOCUMENT_ROOT') . '/secured/uploads/parking/';
$files = $request->files->get('documents');
$salutation = $request->request->get('salutation');
$fname = $request->request->get('fname');
$lname = $request->request->get('lname');
$gender = $request->request->get('gender');
$tmpbdate = $request->request->get('bdate');
$bdate = new \DateTime($tmpbdate);
$age = $request->request->get('age');
$email = $request->request->get('email');
$mobile = $request->request->get('mobile');
$property = $request->request->get('property');
$unit = $request->request->get('unit');
$slots = $request->request->get('slots');
$firstHeard = $request->request->get('firstHeard');
$terms = $request->request->get('terms');
$paymentType = $request->request->get('paymentType');
$date = new \DateTime('now');
$lead = new LeasingParkingLeads();
$lead->setSalutation($salutation);
$lead->setFname($fname);
$lead->setLname($lname);
$lead->setGender($gender);
$lead->setAge($age);
$lead->setBirthday($bdate->format('Y-m-d'));
$lead->setEmail($email);
$lead->setMobile($mobile);
$lead->setProperty($property);
$lead->setUnit($unit);
$lead->setSlots($slots);
$lead->setFirstHeard($firstHeard);
$lead->setPaymentTerms($terms);
$lead->setPaymentType($paymentType);
$lead->setDateAdded($date->format(C::DATETIMEFORMAT));
$lead->setStatus(C::PENDING);
$lead->save();
$code = 'PA' . U::generateCode(5, $lead->getId());
$lead->setApplicationNumber($code);
$lead->save();
foreach ($files as $file) {
$tmp = $file->getPathName();
$fileName = $lead->getId() . '_' . $lead->getLname() . '_' . $lead->getApplicationNumber() . '_' . $file->getClientOriginalName();
$target = $directory . $fileName;
if (move_uploaded_file($tmp, $target)) {
$doc = new LeasingDocument();
$doc->setDocument($fileName);
$doc->save();
$ld = new LeasingLeadDocument();
$ld->setLeadId($lead->getId());
$ld->setDocumentId($doc->getId());
$ld->setLeadTypeId(C::PARKING);
$ld->save();
} else {
echo -2;
exit;
}
}
$tl1 = new LeasingTimelineActivity();
$tl1->setLeadTypeId(C::PARKING);
$tl1->setLeadId($lead->getId());
$tl1->setUser('Lead');
$tl1->setActivity('Applied for Parking Space');
$tl1->setTimestamp($date->format(C::DATETIMEFORMAT));
$tl1->setStatus('Pending');
$tl1->setStatusId(C::PENDING);
$tl1->save();
$this->get('session')->set('thank-you', 1);
$client = new GlobeClient();
$msg = "Thank you, " . $lead->getFname() . " " . $lead->getLname() . "! Your application reference number (ARN) is " . $lead->getApplicationNumber() . ". We will update you once we've reviewed your application. You can check your status in this page, http://bit.ly/as12f. Log in with your Application Reference Number. This msg is FREE.";
$sms = $client->sms($this->globeShortCode);
$response = $sms->sendMessage($lead->getMobile(), $msg, $this->appId, $this->appSecret);
if ($response && !isset($response['error'])) {
$badge = new LeasingLeadBadges();
$badge->setBadgeId(11);
$badge->setLeadTypeId(C::PARKING);
$badge->setLeadId($lead->getId());
$badge->setStatus(1);
$badge->save();
$tl2 = new LeasingTimelineActivity();
$tl2->setLeadTypeId(C::PARKING);
$tl2->setLeadId($lead->getId());
$tl2->setUser('System');
$tl2->setActivity('Verified mobile number');
$tl2->setTimestamp($date->format(C::DATETIMEFORMAT));
$tl2->setStatus('Mobile Verified');
$tl2->setStatusId(C::MOBILE_VERIFIED);
$tl2->save();
}
$ve = VerifyEmail::verifyThisEmail($lead->getEmail());
if ($ve = 'valid') {
$badge = new LeasingLeadBadges();
$badge->setBadgeId(12);
$badge->setLeadTypeId(C::PARKING);
$badge->setLeadId($lead->getId());
$badge->setStatus(1);
$badge->save();
$tl3 = new LeasingTimelineActivity();
$tl3->setLeadTypeId(C::PARKING);
$tl3->setLeadId($lead->getId());
$tl3->setUser('System');
$tl3->setActivity('Verified email address');
$tl3->setTimestamp($date->format(C::DATETIMEFORMAT));
$tl3->setStatus('Email Verified');
$tl3->setStatusId(C::EMAIL_VERIFIED);
$tl3->save();
}
echo 1;
exit;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aLeasingParkingLeads !== null) {
if ($this->aLeasingParkingLeads->isModified() || $this->aLeasingParkingLeads->isNew()) {
$affectedRows += $this->aLeasingParkingLeads->save($con);
}
$this->setLeasingParkingLeads($this->aLeasingParkingLeads);
}
if ($this->aLeasingEventBookings !== null) {
if ($this->aLeasingEventBookings->isModified() || $this->aLeasingEventBookings->isNew()) {
$affectedRows += $this->aLeasingEventBookings->save($con);
}
$this->setLeasingEventBookings($this->aLeasingEventBookings);
}
if ($this->aLeasingBookings !== null) {
if ($this->aLeasingBookings->isModified() || $this->aLeasingBookings->isNew()) {
$affectedRows += $this->aLeasingBookings->save($con);
}
$this->setLeasingBookings($this->aLeasingBookings);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
} else {
$this->doUpdate($con);
}
$affectedRows += 1;
$this->resetModified();
}
if ($this->leasingPaymentValiditiesScheduledForDeletion !== null) {
if (!$this->leasingPaymentValiditiesScheduledForDeletion->isEmpty()) {
foreach ($this->leasingPaymentValiditiesScheduledForDeletion as $leasingPaymentValidity) {
// need to save related object because we set the relation to null
$leasingPaymentValidity->save($con);
}
$this->leasingPaymentValiditiesScheduledForDeletion = null;
}
}
if ($this->collLeasingPaymentValidities !== null) {
foreach ($this->collLeasingPaymentValidities as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
