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