public static function initialize($id, $idS)
{
$OO = AppBlogsBlogsPeer::retrieveByPK($id);
if (!$OO instanceof AppBlogsBlogs) {
$OO = new AppBlogsBlogs();
$OO->setName('Nom per defecte');
$OO->setDate(date('Y-m-d', time()));
$OO->setSiteId($idS);
$OO->setActiu(true);
}
return new AppBlogsBlogsForm($OO, array('IDS' => $idS));
}
/**
* Selects a collection of AppBlogsPages objects pre-filled with all related objects.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of AppBlogsPages objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAll(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$criteria = clone $criteria;
// Set the correct dbName if it has not been overridden
if ($criteria->getDbName() == Propel::getDefaultDB()) {
$criteria->setDbName(self::DATABASE_NAME);
}
AppBlogsPagesPeer::addSelectColumns($criteria);
$startcol2 = AppBlogsPagesPeer::NUM_COLUMNS - AppBlogsPagesPeer::NUM_LAZY_LOAD_COLUMNS;
AppBlogsBlogsPeer::addSelectColumns($criteria);
$startcol3 = $startcol2 + (AppBlogsBlogsPeer::NUM_COLUMNS - AppBlogsBlogsPeer::NUM_LAZY_LOAD_COLUMNS);
$criteria->addJoin(AppBlogsPagesPeer::BLOG_ID, AppBlogsBlogsPeer::ID, $join_behavior);
// symfony_behaviors behavior
foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
call_user_func($sf_hook, 'BaseAppBlogsPagesPeer', $criteria, $con);
}
$stmt = BasePeer::doSelect($criteria, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = AppBlogsPagesPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = AppBlogsPagesPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://propel.phpdb.org/trac/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$cls = AppBlogsPagesPeer::getOMClass(false);
$obj1 = new $cls();
$obj1->hydrate($row);
AppBlogsPagesPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined AppBlogsBlogs rows
$key2 = AppBlogsBlogsPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = AppBlogsBlogsPeer::getInstanceFromPool($key2);
if (!$obj2) {
$cls = AppBlogsBlogsPeer::getOMClass(false);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
AppBlogsBlogsPeer::addInstanceToPool($obj2, $key2);
}
// if obj2 loaded
// Add the $obj1 (AppBlogsPages) to the collection in $obj2 (AppBlogsBlogs)
$obj2->addAppBlogsPages($obj1);
}
// if joined row not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
/**
* Get the associated AppBlogsBlogs object
*
* @param PropelPDO Optional Connection object.
* @return AppBlogsBlogs The associated AppBlogsBlogs object.
* @throws PropelException
*/
public function getAppBlogsBlogs(PropelPDO $con = null)
{
if ($this->aAppBlogsBlogs === null && $this->blog_id !== null) {
$this->aAppBlogsBlogs = AppBlogsBlogsPeer::retrieveByPk($this->blog_id);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aAppBlogsBlogs->addAppBlogsPagess($this);
*/
}
return $this->aAppBlogsBlogs;
}
/**
* 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(AppBlogsBlogsPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(AppBlogsBlogsPeer::DATABASE_NAME);
$criteria->add(AppBlogsBlogsPeer::ID, $pks, Criteria::IN);
$objs = AppBlogsBlogsPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeGBlogs(sfWebRequest $request)
{
$this->setLayout('gestio');
$this->IDS = $this->getUser()->getSessionPar('idS');
//Add,Edit,Delete Multimedia
//Add,Edit,Delete Page
//Add,Edit,Delete Entry
//Principal view -> Blogs
//You Select a blog -> Choice Menus - Pages
//Edit Page - Menu
$this->APP_BLOG = $request->getParameter('APP_BLOG', -1);
$this->APP_PAGE = $request->getParameter('APP_PAGE', -1);
$this->APP_ENTRY = $request->getParameter('APP_ENTRY', -1);
$this->APP_MENU = $request->getParameter('APP_MENU', -1);
$this->APP_MULTIMEDIA = $request->getParameter('APP_MULTIMEDIA', -1);
$this->APP_FORM = $request->getParameter('APP_FORM', 1);
$this->APP_FORM_ENTRY = $request->getParameter('APP_FORM_ENTRY', 0);
$this->accio = $request->getParameter('accio', 'VB');
// $this->APP_BLOG = $this->getUser()->ParReqSesForm($request,'APP_BLOG',-1);
// $this->APP_PAGE = $this->getUser()->ParReqSesForm($request,'APP_PAGE',-1);
// $this->APP_ENTRY = $this->getUser()->ParReqSesForm($request,'APP_ENTRY',-1);
// $this->APP_MENU = $this->getUser()->ParReqSesForm($request,'APP_MENU',-1);
// $this->APP_MULTIMEDIA = $this->getUser()->ParReqSesForm($request,'APP_MULTIMEDIA',-1);
// $this->APP_FORM = $this->getUser()->ParReqSesForm($request,'APP_FORM',1);
// $this->APP_FORM_ENTRY = $this->getUser()->ParReqSesForm($request,'APP_FORM_ENTRY',0);
$accio = $request->getParameter('accio', 'GP');
$this->MODE = 'CERCA';
if ($request->isMethod('POST')) {
if ($request->hasParameter('B_NEW_MENU')) {
$accio = 'NEW_MENU';
} elseif ($request->hasParameter('B_EDIT_MENU')) {
$accio = 'EDIT_MENU';
} elseif ($request->hasParameter('B_DELETE_MENU')) {
$accio = 'DELETE_MENU';
} elseif ($request->hasParameter('B_SAVE_MENU')) {
$accio = 'SAVE_MENU';
} elseif ($request->hasParameter('B_NEW_PAGE')) {
$accio = 'NEW_PAGE';
} elseif ($request->hasParameter('B_EDIT_PAGE')) {
$accio = 'EDIT_PAGE';
} elseif ($request->hasParameter('B_DELETE_PAGE')) {
$accio = 'DELETE_PAGE';
} elseif ($request->hasParameter('B_SAVE_PAGE')) {
$accio = 'SAVE_PAGE';
} elseif ($request->hasParameter('B_NEW_ENTRY')) {
$accio = 'NEW_ENTRY';
} elseif ($request->hasParameter('B_EDIT_ENTRY')) {
$accio = 'EDIT_ENTRY';
} elseif ($request->hasParameter('B_DELETE_ENTRY')) {
$accio = 'DELETE_ENTRY';
} elseif ($request->hasParameter('B_SAVE_ENTRY')) {
$accio = 'SAVE_ENTRY';
} elseif ($request->hasParameter('B_NEW_BLOG')) {
$accio = 'NEW_BLOG';
} elseif ($request->hasParameter('B_EDIT_BLOG')) {
$accio = 'EDIT_BLOG';
} elseif ($request->hasParameter('B_DELETE_BLOG')) {
$accio = 'DELETE_BLOG';
} elseif ($request->hasParameter('B_SAVE_BLOG')) {
$accio = 'SAVE_BLOG';
} elseif ($request->hasParameter('B_VIEW_CONTENT')) {
$accio = 'VIEW_CONTENT';
} elseif ($request->hasParameter('B_VIEW_STADISTICS')) {
$accio = 'VIEW_STADISTICS';
} elseif ($request->hasParameter('B_VIEW_FORM')) {
$accio = 'VIEW_FORM';
}
}
switch ($accio) {
case 'NEW_MENU':
$this->FORM_MENU = AppBlogsMenuPeer::initialize(0, $this->APP_BLOG, $this->IDS);
break;
case 'EDIT_MENU':
$this->FORM_MENU = AppBlogsMenuPeer::initialize($this->APP_MENU, $this->APP_BLOG, $this->IDS);
break;
case 'DELETE_MENU':
$this->FORM_MENU = AppBlogsMenuPeer::initialize($this->APP_MENU, $this->APP_BLOG, $this->IDS);
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_MENU->getObject());
$this->FORM_MENU->getObject()->setInactiu();
$this->redirect('gestio/gBlogs?accio=VIEW_CONTENT');
break;
case 'SAVE_MENU':
$RP = $request->getParameter('app_blogs_menu');
$this->APP_MENU = $RP['id'];
$this->APP_BLOG = $RP['blog_id'];
$this->FORM_MENU = AppBlogsMenuPeer::initialize($this->APP_MENU, $this->APP_BLOG, $this->IDS);
$this->FORM_MENU->bind($RP);
if ($this->FORM_MENU->isValid()) {
try {
$this->FORM_MENU->save();
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_MENU->getObject());
$this->APP_MENU = $this->FORM_MENU->getObject()->getId();
unset($this->APP_MENU);
$this->reloadBlog();
} catch (Exception $e) {
echo $e->getMessage();
}
}
break;
case 'NEW_PAGE':
$this->FORM_PAGE = AppBlogsPagesPeer::initialize(0, $this->APP_BLOG, $this->IDS);
break;
case 'EDIT_PAGE':
$this->FORM_PAGE = AppBlogsPagesPeer::initialize($this->APP_PAGE, $this->APP_BLOG, $this->IDS);
break;
case 'DELETE_PAGE':
try {
$RP = $request->getParameter('app_blogs_pages');
$this->APP_PAGE = $RP['id'];
$this->APP_BLOG = $RP['blog_id'];
$this->FORM_PAGE = AppBlogsPagesPeer::initialize($this->APP_PAGE, $this->APP_BLOG, $this->IDS);
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_PAGE->getObject());
$this->FORM_PAGE->getObject()->setInactiu();
unset($this->FORM_PAGE);
$this->reloadBlog();
} catch (Exception $e) {
echo $e->getMessage();
}
break;
case 'SAVE_PAGE':
$RP = $request->getParameter('app_blogs_pages');
$this->APP_PAGE = $RP['id'];
$this->APP_BLOG = $RP['blog_id'];
$this->FORM_PAGE = AppBlogsPagesPeer::initialize($this->APP_PAGE, $this->APP_BLOG, $this->IDS);
$this->FORM_PAGE->bind($RP);
if ($this->FORM_PAGE->isValid()) {
try {
$this->FORM_PAGE->save();
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_PAGE->getObject());
$this->APP_PAGE = $this->FORM_PAGE->getObject()->getId();
//Ara assignem també aquesta pàgina al menú que tenim seleccionat. Si no n'hi ha cap, no fem res.
if ($this->APP_MENU > 0) {
$FM = AppBlogsMenuPeer::initialize($this->APP_MENU, $this->APP_BLOG, $this->IDS);
$FM->getObject()->setPageId($this->APP_PAGE)->save();
}
unset($this->FORM_PAGE);
$this->reloadBlog();
} catch (Exception $e) {
echo $e->getMessage();
}
}
break;
case 'NEW_ENTRY':
$this->FORM_ENTRY = AppBlogsEntriesPeer::initialize($this->APP_ENTRY, 'CA', $this->APP_PAGE, $this->APP_BLOG, $this->IDS);
$this->GALLERY = array();
break;
case 'EDIT_ENTRY':
$this->FORM_ENTRY = AppBlogsEntriesPeer::initialize($this->APP_ENTRY, 'CA', $this->APP_PAGE, $this->APP_BLOG, $this->IDS);
$this->GALLERY = AppBlogsEntriesPeer::getFiles($this->APP_ENTRY, 'CA');
break;
case 'DELETE_ENTRY':
$RS = $request->getParameter('app_blogs_entries');
$this->APP_ENTRY = $RS['id'];
$this->APP_PAGE = $RS['page_id'];
$this->FORM_ENTRY = AppBlogsEntriesPeer::initialize($this->APP_ENTRY, 'CA', $this->APP_PAGE, $this->APP_BLOG, $this->IDS);
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_ENTRY->getObject());
$this->FORM_ENTRY->getObject()->setInactiu();
$this->reloadBlog();
break;
case 'SAVE_ENTRY':
$RS = $request->getParameter('app_blogs_entries');
$this->APP_ENTRY = $RS['id'];
$this->APP_PAGE = $RS['page_id'];
$this->FORM_ENTRY = AppBlogsEntriesPeer::initialize($this->APP_ENTRY, 'CA', $this->APP_PAGE, $this->APP_BLOG, $this->IDS);
$this->FORM_ENTRY->bind($RS);
if ($this->FORM_ENTRY->isValid()) {
try {
$this->FORM_ENTRY->save();
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_ENTRY->getObject());
$this->APP_ENTRY = $this->FORM_ENTRY->getObject()->getId();
$this->GUARDA_IMATGES($request->getFiles('arxiu'), $request->getParameter('desc'), $this->APP_ENTRY);
unset($this->FORM_ENTRY);
$this->reloadBlog();
} catch (Exception $e) {
echo $e->getMessage();
}
}
$this->GALLERY = AppBlogsEntriesPeer::getFiles($this->APP_ENTRY, 'CA');
break;
case 'NEW_BLOG':
$this->FORM_BLOG = AppBlogsBlogsPeer::initialize(0, $this->IDS);
break;
case 'EDIT_BLOG':
$this->FORM_BLOG = AppBlogsBlogsPeer::initialize($this->APP_BLOG, $this->IDS);
break;
case 'DELETE_BLOG':
$RS = $request->getParameter('app_blogs_blogs');
$this->APP_BLOG = $RS['id'];
$this->FORM_BLOG = AppBlogsBlogsPeer::initialize($this->APP_BLOG, $this->IDS);
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_BLOG->getObject());
$this->FORM_BLOG->getObject()->setInactiu();
unset($this->FORM_BLOG);
break;
case 'DELETE_IMAGE':
AppBlogsMultimediaPeer::initialize($this->APP_MULTIMEDIA, $this->IDS)->getObject()->setInactiu();
$this->getUser()->addLogAction($accio, 'gBlogs', $this->APP_MULTIMEDIA);
break;
case 'SAVE_BLOG':
$RS = $request->getParameter('app_blogs_blogs');
$this->APP_BLOG = $RS['id'];
$this->FORM_BLOG = AppBlogsBlogsPeer::initialize($this->APP_BLOG, $this->IDS);
$this->FORM_BLOG->bind($RS);
if ($this->FORM_BLOG->isValid()) {
try {
$this->FORM_BLOG->save();
$this->getUser()->addLogAction($accio, 'gBlogs', $this->FORM_BLOG->getObject());
$this->APP_BLOG = $this->FORM_BLOG->getObject()->getId();
unset($this->FORM_BLOG);
$this->reloadBlog();
} catch (Exception $e) {
echo $e->getMessage();
}
}
break;
case 'VIEW_CONTENT':
$this->reloadBlog($this->APP_BLOG);
break;
case 'AJAX_PAGE':
$APP_PAGE = $request->getParameter('APP_PAGE');
$APP_ENTRY = $request->getParameter('APP_ENTRY');
$HTML = AppBlogsEntriesPeer::getOptionsEntries($APP_PAGE, $APP_ENTRY, $this->IDS);
return $this->renderText($HTML);
break;
case 'AJAX_MENU':
$APP_BLOG = $request->getParameter('APP_BLOG');
$APP_MENU = $request->getParameter('APP_MENU') > 0 ? $request->getParameter('APP_MENU') : 0;
$APP_PAGE = $request->getParameter('APP_PAGE') > 0 ? $request->getParameter('APP_PAGE') : 0;
$HTML = AppBlogsPagesPeer::getOptionsPages($APP_BLOG, $APP_MENU, $APP_PAGE, $this->IDS);
return $this->renderText($HTML);
break;
case 'AJAX_ESTAT_FORM':
$APP_FORM_ENTRY = $request->getParameter('APP_FORM_ENTRY');
$ESTAT = $request->getParameter('ESTAT');
$OO = AppBlogsFormsEntriesPeer::initialize($APP_FORM_ENTRY, $this->IDS)->getObject();
$OO->setEstat($ESTAT);
$OO->save();
return $this->renderText('Canvi fet correctament');
break;
case 'AJAX_SAVE_OBJECCIONS':
$APP_FORM_ENTRY = $request->getParameter('APP_FORM_ENTRY');
$OO = AppBlogsFormsEntriesPeer::initialize($APP_FORM_ENTRY, $this->IDS);
$OO->setObjeccions($request->getParameter('OBJECCIONS'));
$OO->save();
return $this->renderText('Canvi fet correctament');
break;
case 'VB':
$this->APP_BLOG = -1;
$this->APP_PAGE = -1;
$this->APP_ENTRY = -1;
$this->APP_MENU = -1;
$this->APP_MULTIMEDIA = -1;
$this->APP_FORM = -1;
$this->getUser()->addLogAction('inside', 'gBlogs');
break;
case 'VIEW_STADISTICS':
//Veure estructura d'arbre
$this->PAGES_WITHOUT_CONTENT = AppBlogsPagesPeer::getPagesWithoutContent($this->APP_BLOG, $this->IDS);
$this->MENUS_WITHOUT_PAGES = AppBlogsMenuPeer::getMenusWithoutPages($this->APP_BLOG, $this->IDS);
$this->TREE = AppBlogsMenuPeer::getOptionsMenus($this->APP_BLOG, null, false, $this->IDS);
break;
case 'VIEW_FORM':
$datai = mktime(0, 0, 0, date('m', time()) - 2, date('d', time()), date('Y', time()));
$this->VIEW_FORM_ENTRIES = AppBlogsFormsEntriesPeer::getEntries($this->APP_FORM, date('Y-m-d', $datai), $this->IDS);
$this->VIEW_FIELDS = AppBlogsFormsEntriesPeer::getFields($this->APP_FORM, $this->IDS);
break;
}
$this->BLOGS_ARRAY = AppBlogsBlogsPeer::getOptionsBlogs($this->APP_BLOG, $this->IDS);
}
/**
* 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 phpname (e.g. 'AuthorId')
*
* @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 = AppBlogsBlogsPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setName($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setDate($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setSiteId($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setActiu($arr[$keys[4]]);
}
}