public function executeRemovePhoto(sfWebRequest $request) { $c = new Criteria(); $c->add(MissionPhotoPeer::ID, $request->getParameter('id')); $photos = MissionPhotoPeer::doSelect($c); $ad_photo = $photos[0]->getPhotoFilename(); $img_dir = sfConfig::get('sf_upload_dir') . '/mission_photo/display/'; $img_thmb = sfConfig::get('sf_upload_dir') . '/mission_photo/thumbnails/'; //unlink function return bool so you can use it as conditon if (@unlink($img_dir . $ad_photo) && @unlink($img_thmb . $ad_photo)) { $c->add(MissionPhotoPeer::PHOTO_FILENAME, ''); MissionPhotoPeer::doUpdate($c); } $this->redirect("mission_photo/show?id=" . $request->getParameter('id')); }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @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(MissionPhotoPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(MissionPhotoPeer::DATABASE_NAME); $criteria->add(MissionPhotoPeer::ID, $pks, Criteria::IN); $objs = MissionPhotoPeer::doSelect($criteria, $con); } return $objs; }
<?php use_helper('Form'); $date_widget = $sf_data->getRaw('date_widget'); use_javascripts_for_form($date_widget); use_stylesheets_for_form($date_widget); $c = new Criteria(); $c->add(MissionPhotoPeer::ID, $mission_photo->getId()); $pht = MissionPhotoPeer::doSelect($c); ?> <style type="text/css"> .mission-photo-table{ width:100%; border-collapse:collapse; margin:5px 0 0; } .mission-photo-table td{ margin:0; padding:0; border:1px solid #bcbcbe; height:20px; } .mission-photo-table thead td{ background:#cfe1fc; border-color:#a6bee0; color:#153f7a; font-weight:bold; text-align:center; } .mission-photo-table tbody td{ padding:5px 15px;
/** * Gets an array of MissionPhoto objects which contain a foreign key that references this object. * * If this collection has already been initialized with an identical Criteria, it returns the collection. * Otherwise if this Mission has previously been saved, it will retrieve * related MissionPhotos from storage. If this Mission is new, it will return * an empty collection or the current collection, the criteria is ignored on a new object. * * @param PropelPDO $con * @param Criteria $criteria * @return array MissionPhoto[] * @throws PropelException */ public function getMissionPhotos($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(MissionPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collMissionPhotos === null) { if ($this->isNew()) { $this->collMissionPhotos = array(); } else { $criteria->add(MissionPhotoPeer::MISSION_ID, $this->id); MissionPhotoPeer::addSelectColumns($criteria); $this->collMissionPhotos = MissionPhotoPeer::doSelect($criteria, $con); } } else { // criteria has no effect for a new object if (!$this->isNew()) { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(MissionPhotoPeer::MISSION_ID, $this->id); MissionPhotoPeer::addSelectColumns($criteria); if (!isset($this->lastMissionPhotoCriteria) || !$this->lastMissionPhotoCriteria->equals($criteria)) { $this->collMissionPhotos = MissionPhotoPeer::doSelect($criteria, $con); } } } $this->lastMissionPhotoCriteria = $criteria; return $this->collMissionPhotos; }