Esempio n. 1
0
 public function retrieveApplicationAction()
 {
     $request = $this->getRequest();
     $leadType = $request->request->get('leadType');
     $refNum = $request->request->get('refNum');
     $details = array();
     if ($leadType && $refNum) {
         switch ($leadType) {
             case 1:
                 $parkingApp = LeasingParkingLeadsPeer::getRecords($refNum);
                 if (!empty($parkingApp)) {
                     $status = LeasingStatusPeer::retrieveByPK($parkingApp->getStatus());
                     $leadDocs = LeasingLeadDocumentPeer::getLeadDocumentByLeadId($leadType, $parkingApp->getId());
                     $docs = array();
                     $payment = LeasingParkingPaymentDetailsPeer::getDetailsByParkingLeadId($parkingApp->getId());
                     foreach ($leadDocs as $ld) {
                         $docs[$ld->getId()] = $ld->getLeasingDocument()->getDocument();
                     }
                     $details = array('parkingAppId' => $parkingApp->getId(), 'refNum' => $parkingApp->getApplicationNumber(), 'name' => $parkingApp->getFname() . ' ' . $parkingApp->getLname(), 'mobile' => $parkingApp->getMobile(), 'email' => $parkingApp->getEmail(), 'reqStatus' => $status->getStatus(), 'property' => $parkingApp->getProperty(), 'unit' => $parkingApp->getUnit(), 'slots' => $parkingApp->getSlots(), 'paymentTerms' => $parkingApp->getPaymentTerms(), 'docs' => $docs, 'payment' => $payment, 'paymentType' => $parkingApp->getPaymentType());
                     return $this->render('LeasingPaymentBundle::parkingPayment.html.twig', array('details' => $details));
                 } else {
                     echo -1;
                     exit;
                 }
                 break;
             case 2:
                 $eventApp = LeasingEventBookingsPeer::getRecords($refNum);
                 if (!empty($eventApp)) {
                     $status = LeasingStatusPeer::retrieveByPK($eventApp->getStatus());
                     $leadDocs = LeasingLeadDocumentPeer::getLeadDocumentByLeadId($leadType, $eventApp->getId());
                     $docs = array();
                     $payment = LeasingEventPaymentDetailsPeer::getEventPaymentDetailsByEventBookingId($eventApp->getId());
                     foreach ($leadDocs as $ld) {
                         $docs[$ld->getId()] = $ld->getLeasingDocument()->getDocument();
                     }
                     $details = array('eventAppId' => $eventApp->getId(), 'refNum' => $eventApp->getApplicationNumber(), 'name' => $eventApp->getLeasingEventLeads()->getFname() . ' ' . $eventApp->getLeasingEventLeads()->getLname(), 'mobile' => $eventApp->getLeasingEventLeads()->getMobile(), 'email' => $eventApp->getLeasingEventLeads()->getEmail(), 'reqStatus' => $status->getStatus(), 'eventPlace' => $eventApp->getLeasingEventPlace()->getName(), 'eventDate' => $eventApp->getEventDate(), 'eventTime' => $eventApp->getEventStartTime() . ' - ' . $eventApp->getEventEndTime(), 'docs' => $docs, 'payment' => $payment);
                     return $this->render('LeasingPaymentBundle::eventPayment.html.twig', array('details' => $details));
                 } else {
                     echo -1;
                     exit;
                 }
                 break;
             default:
                 break;
         }
         echo -2;
         exit;
     } else {
         throw new AccessDeniedHttpException();
     }
 }
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @return LeasingEventPaymentDetails[]
  * @throws PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(LeasingEventPaymentDetailsPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(LeasingEventPaymentDetailsPeer::DATABASE_NAME);
         $criteria->add(LeasingEventPaymentDetailsPeer::ID, $pks, Criteria::IN);
         $objs = LeasingEventPaymentDetailsPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
 /**
  * Find object by primary key using raw SQL to go fast.
  * Bypass doSelect() and the object formatter by using generated code.
  *
  * @param     mixed $key Primary key to use for the query
  * @param     PropelPDO $con A connection object
  *
  * @return                 LeasingEventPaymentDetails A model object, or null if the key is not found
  * @throws PropelException
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT `id`, `event_bookings_id`, `rental_cost`, `reservation_fee`, `security_deposit`, `payable`, `balance`, `status` FROM `event_payment_details` WHERE `id` = :p0';
     try {
         $stmt = $con->prepare($sql);
         $stmt->bindValue(':p0', $key, PDO::PARAM_INT);
         $stmt->execute();
     } catch (Exception $e) {
         Propel::log($e->getMessage(), Propel::LOG_ERR);
         throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new LeasingEventPaymentDetails();
         $obj->hydrate($row);
         LeasingEventPaymentDetailsPeer::addInstanceToPool($obj, (string) $key);
     }
     $stmt->closeCursor();
     return $obj;
 }
 /**
  * Populates the object using an array.
  *
  * This is particularly useful when populating an object from one of the
  * request arrays (e.g. $_POST).  This method goes through the column
  * names, checking to see whether a matching key exists in populated
  * array. If so the setByName() method is called for that column.
  *
  * You can specify the key type of the array by additionally passing one
  * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
  * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
  * The default key type is the column's BasePeer::TYPE_PHPNAME
  *
  * @param array  $arr     An array to populate the object from.
  * @param string $keyType The type of keys the array uses.
  * @return void
  */
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = LeasingEventPaymentDetailsPeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setId($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setEventBookingsId($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setRentalCost($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setReservationFee($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setSecurityDeposit($arr[$keys[4]]);
     }
     if (array_key_exists($keys[5], $arr)) {
         $this->setPayable($arr[$keys[5]]);
     }
     if (array_key_exists($keys[6], $arr)) {
         $this->setBalance($arr[$keys[6]]);
     }
     if (array_key_exists($keys[7], $arr)) {
         $this->setStatus($arr[$keys[7]]);
     }
 }