public function executeUpdate(sfWebRequest $request) { $this->forward404Unless($request->isMethod('post') || $request->isMethod('put')); $this->forward404Unless($course = CoursePeer::retrieveByPk($request->getParameter('id')), sprintf('Object course does not exist (%s).', $request->getParameter('id'))); $values = array('edit' => 'true'); $this->form = new CourseForm($course, $values); $c = new Criteria(); $c->add(CourseDetailPeer::COURSE_ID, $request->getParameter('id')); $courseDetail = CourseDetailPeer::doSelectOne($c); if ($courseDetail !== null) { $this->form2 = new CourseDetailForm($courseDetail); } else { $this->form2 = new CourseDetailForm(new CourseDetail()); } $c2 = new Criteria(); $c2->add(CourseDetailPeer::COURSE_ID, $request->getParameter('id')); $courseDisAssoc = CourseDisciplineAssociationPeer::doSelectOne($c2); if ($courseDisAssoc !== null) { $this->form3 = new CourseDisciplineAssociationForm($courseDisAssoc); } else { $this->form3 = new CourseDisciplineAssociationForm(new CourseDisciplineAssociation()); } $this->submitForm($request, $this->form, $this->form2, $this->form3); //at this point the save has failed $c = new Criteria(); //$c->addSelectColumn(CoursePeer::ID); $this->course_list = $this->getCourselist($c); $this->setTemplate('index'); }
public function executeList() { $c = new Criteria(); $c->add(DosagePeer::STATUS, Constant::RECORD_STATUS_DELETED, Criteria::NOT_EQUAL); $c->addAscendingOrderByColumn(DosagePeer::TITLE); $this->dosages = DosagePeer::doSelect($c); }
public function execute(&$value, &$error) { $id = $this->getContext()->getRequest()->getParameter('id'); $name = $value; $c = new Criteria(); $c->add(UserPeer::USERNAME, $name); $user = UserPeer::doSelectOne($c); $condition = true; if ($user) { if ($id && $id == $user->getId()) { $condition = true; } else { $error = 'User ' . $user->getUsername() . ' already Exist.'; $condition = false; } } $roles = RolePeer::doSelect(new Criteria()); $found = false; foreach ($roles as $role) { if ($this->getContext()->getRequest()->getParameter($role->getName(), 0) == 1) { $found = true; } } if (!$found) { $error = 'Please select atleast one role'; $condition = false; } return $condition; }
public function build($runData) { $site = $runData->getTemp("site"); $runData->contextAdd("site", $site); // select templates $templatesCategory = DB_CategoryPeer::instance()->selectByName("template", $site->getSiteId()); if ($templatesCategory == null) { $runData->contextAdd("noTemplates", true); return; } $c = new Criteria(); $c->add("category_id", $templatesCategory->getCategoryId()); $c->addOrderAscending("title"); $templates = DB_PagePeer::instance()->select($c); $runData->contextAdd("templates", $templates); // get all categories for the site $c = new Criteria(); $c->add("site_id", $site->getSiteId()); $c->addOrderAscending("replace(name, '_', '00000000')"); $categories = DB_CategoryPeer::instance()->select($c); $runData->contextAdd("categories", $categories); // also prepare categories to put into javascript... $cats2 = array(); foreach ($categories as $category) { $cats2[] = $category->getFieldValuesArray(); } $runData->ajaxResponseAdd("categories", $cats2); }
public function configure() { // Sort $activitySortCriteria = new Criteria(); $activitySortCriteria->addAscendingOrderByColumn(ActivityPeer::NAME); $userSortCriteria = new Criteria(); $userSortCriteria->addAscendingOrderByColumn(UserPeer::FAMILY_NAME); // Remove some fields //unset($this['usergroup_has_chief_list']); // Labels $activityItem = ConfigurationHelper::getParameter('Rename', 'activity_label'); if (is_null($activityItem) || empty($activityItem)) { $activityItem = 'Activities'; } $this->widgetSchema->setLabel('usergroup_has_chief_list', 'Leader(s)'); $this->widgetSchema->setLabel('usergroup_has_user_list', 'Member(s)'); $this->widgetSchema->setLabel('usergroup_has_activity_list', $activityItem); // Validators $this->validatorSchema['name'] = new sfXSSValidatorString(array('max_length' => 64)); // Options $this->widgetSchema['usergroup_has_chief_list']->setOption('expanded', true); $this->widgetSchema['usergroup_has_chief_list']->setOption('criteria', $userSortCriteria); $this->validatorSchema['usergroup_has_chief_list']->setOption('required', true); $this->widgetSchema['usergroup_has_user_list']->setOption('expanded', true); $this->widgetSchema['usergroup_has_user_list']->setOption('criteria', $userSortCriteria); $this->widgetSchema['usergroup_has_activity_list']->setOption('expanded', true); $this->widgetSchema['usergroup_has_activity_list']->setOption('criteria', $activitySortCriteria); $this->validatorSchema['usergroup_has_activity_list']->setOption('required', true); }
public function saveAuthorArticleList($con = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } if (!isset($this->widgetSchema['author_article_list'])) { // somebody has unset this widget return; } if (null === $con) { $con = $this->getConnection(); } $c = new Criteria(); $c->add(AuthorArticlePeer::AUTHOR_ID, $this->object->getPrimaryKey()); AuthorArticlePeer::doDelete($c, $con); $values = $this->getValue('author_article_list'); if (is_array($values)) { foreach ($values as $value) { $obj = new AuthorArticle(); $obj->setAuthorId($this->object->getPrimaryKey()); $obj->setArticleId($value); $obj->save(); } } }
public function executeRun() { $this->error = false; if (!$this->applicant) { $this->error = true; $this->messageError = 'Applicant Not Found'; return false; } $ta = $this->applicant; $this->ta_detail = $ta->getTestApplicantDetail(); if (!$this->ta_detail) { $this->error = true; $this->messageError = 'Applicant Detail Not Found'; return false; } $cw = new Criteria(); $cw->add(DepartmentDetailPeer::DEPARTMENT_ID, $ta->getDepartment1()); $this->department_detail = DepartmentDetailPeer::doSelectOne($cw); if (!$this->department_detail) { $this->error = true; $this->messageError = 'Department not found'; return false; } $c = new Criteria(); $c->add(PaymentJournalPeer::PAYER, $ta->getId()); $c->add(PaymentJournalPeer::PAYER_TYPE, PaymentJournal::PAYER_TYPE_APPLICANT); $payments = PaymentJournalPeer::doSelect($c); if (!$payments) { $this->error = true; $this->messageError = 'Payments not fond'; return false; } $this->payments = $payments; }
public static function getAsistencia($evaluacion, $aspirante) { $criteria = new Criteria(); $criteria->add(AsistenciasPeer::EVALUACIONES_ID, $evaluacion, Criteria::EQUAL); $criteria->add(AsistenciasPeer::ASPIRANTES_ID, $aspirante, Criteria::EQUAL); return self::doSelectOne($criteria); }
public function saveUsuarioRolList($con = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } if (!isset($this->widgetSchema['usuario_rol_list'])) { // somebody has unset this widget return; } if (is_null($con)) { $con = $this->getConnection(); } $c = new Criteria(); $c->add(UsuarioRolPeer::FK_ROL_ID, $this->object->getPrimaryKey()); UsuarioRolPeer::doDelete($c, $con); $values = $this->getValue('usuario_rol_list'); if (is_array($values)) { foreach ($values as $value) { $obj = new UsuarioRol(); $obj->setFkRolId($this->object->getPrimaryKey()); $obj->setFkUsuarioId($value); $obj->save(); } } }
public static function getAllCommentsForResource($resource, $con = null) { $c = new Criteria(); $c->add(sfEmendCommentPeer::URL, $resource); $c->add(sfEmendCommentPeer::IS_PUBLIC, 1); return sfEmendCommentPeer::doSelect($c, $con); }
public function saveProductHasColorList($con = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } if (!isset($this->widgetSchema['product_has_color_list'])) { // somebody has unset this widget return; } if (null === $con) { $con = $this->getConnection(); } $c = new Criteria(); $c->add(ProductHasColorPeer::COLOR_ID, $this->object->getPrimaryKey()); ProductHasColorPeer::doDelete($c, $con); $values = $this->getValue('product_has_color_list'); if (is_array($values)) { foreach ($values as $value) { $obj = new ProductHasColor(); $obj->setColorId($this->object->getPrimaryKey()); $obj->setProductId($value); $obj->save(); } } }
public function doSaveMedia($v) { if ($v == null) { $image = $this->getImagePath(); if ($this->isNew) { $content = file_get_contents(sfConfig::get('sf_root_dir') . '/public_html' . $image); $size = getimagesize(sfConfig::get('sf_root_dir') . '/public_html' . $image); } else { return $this->getObject()->getImagesId(); } } else { $content = file_get_contents($v->getTempName()); $size = getimagesize($v->getTempName()); } $hash = md5($content); $criteria = new Criteria(); $criteria->add(ImagesPeer::CONTENT_HASH, $hash); $obj = ImagesPeer::doSelectOne($criteria); try { if (empty($obj)) { $obj = new Images(); $obj->setNameDownloadedFile($v->getOriginalName())->setNameFileForPage($v->getOriginalName())->setTypeImg($v->getType())->setHeight($size[2])->setWidth($size[1])->setContentHash($hash . '.jpg')->setContent(base64_encode($content))->setCreatedAt(date("Y-m-d H:i"))->setUpdatedAt(date("Y-m-d H:i"))->save(); } } catch (Exception $e) { echo "stdfdfdfdfrt"; die; } $criteria = new Criteria(); $criteria->add(ImagesPeer::CONTENT_HASH, $obj->getContentHash()); $obj = ImagesPeer::doSelectOne($criteria); return $obj->getId(); }
public function saveJobeetCategoryAffiliateList($con = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } if (!isset($this->widgetSchema['jobeet_category_affiliate_list'])) { // somebody has unset this widget return; } if (null === $con) { $con = $this->getConnection(); } $c = new Criteria(); $c->add(JobeetCategoryAffiliatePeer::CATEGORY_ID, $this->object->getPrimaryKey()); JobeetCategoryAffiliatePeer::doDelete($c, $con); $values = $this->getValue('jobeet_category_affiliate_list'); if (is_array($values)) { foreach ($values as $value) { $obj = new JobeetCategoryAffiliate(); $obj->setCategoryId($this->object->getPrimaryKey()); $obj->setAffiliateId($value); $obj->save(); } } }
public static function getallByClassRoom($classroom_id) { $c = new Criteria(); $c->addJoin(ClassroomResourcesPeer::RESOURCE_ID, self::ID); $c->add(ClassroomResourcesPeer::CLASSROOM_ID, $classroom_id); return self::doSelect($c); }
/** * Get repository by URI * @param string $url the url of the repository to find * @return QubitQuery collection of OAI-PMH Repositories */ public static function getByURI($URI) { $criteria = new Criteria(); $criteria->add(QubitOaiRepository::URI, $URI, Criteria::LIKE); $criteria->addAscendingOrderByColumn(QubitOaiRepository::NAME); return self::get($criteria); }
public function testStaticDoSoftDelete() { $t1 = new Table4(); $t1->save(); $t2 = new Table4(); $t2->save(); $t3 = new Table4(); $t3->save(); // softDelete with a criteria $c = new Criteria(); $c->add(Table4Peer::ID, $t1->getId()); Table4Peer::doSoftDelete($c); Table4Peer::disableSoftDelete(); $this->assertEquals(3, Table4Peer::doCount(new Criteria()), 'doSoftDelete() keeps deleted record in the database'); Table4Peer::enableSoftDelete(); $this->assertEquals(2, Table4Peer::doCount(new Criteria()), 'doSoftDelete() marks deleted record as deleted'); // softDelete with a value Table4Peer::doSoftDelete(array($t2->getId())); Table4Peer::disableSoftDelete(); $this->assertEquals(3, Table4Peer::doCount(new Criteria()), 'doSoftDelete() keeps deleted record in the database'); Table4Peer::enableSoftDelete(); $this->assertEquals(1, Table4Peer::doCount(new Criteria()), 'doSoftDelete() marks deleted record as deleted'); // softDelete with an object Table4Peer::doSoftDelete($t3); Table4Peer::disableSoftDelete(); $this->assertEquals(3, Table4Peer::doCount(new Criteria()), 'doSoftDelete() keeps deleted record in the database'); Table4Peer::enableSoftDelete(); $this->assertEquals(0, Table4Peer::doCount(new Criteria()), 'doSoftDelete() marks deleted record as deleted'); }
public function executeDelete() { $userId = sfContext::getInstance()->getUser()->getAttribute('subscriber_id', null, 'subscriber'); $this->bikeid = $this->getRequestParameter('bikeid'); if ($this->getRequest()->getMethod() == sfRequest::POST) { //delete user_stat and equipment $c = new Criteria(); $c->add(UserStatsPeer::USER_ID, $userId); $c->add(UserStatsPeer::BIKE_ID, $this->bikeid); $s = UserStatsPeer::doSelectJoinAll($c); foreach ($s as $stat) { foreach ($stat->getUserStatEquips() as $equip) { $equip->delete(); } $stat->delete(); } //move equipment to shelf $c = new Criteria(); $c->add(UserEquipementPeer::USER_ID, $userId); $c->add(UserEquipementPeer::BIKE_ID, $this->bikeid); $equip = UserEquipementPeer::doSelect($c); foreach ($equip as $e) { $e->setBikeId(null); $e->save(); } //now delete bike $user_bikes = UserBikesPeer::retrieveByPk($this->bikeid); $user_bikes->delete(); return $this->redirect('userbike/index'); } }
public static function cleanup($days) { $criteria = new Criteria(); $criteria->add(self::IS_ACTIVATED, false); $criteria->add(self::CREATED_AT, time() - 86400 * $days, Criteria::LESS_THAN); return self::doDelete($criteria); }
/** * Get objects by kuser and user role IDs * @param int $kuserId * @param int $userRoleId * @return array Array of selected KuserToUserRole Objects */ public static function getByKuserAndUserRoleIds($kuserId, $userRoleId) { $c = new Criteria(); $c->addAnd(self::KUSER_ID, $kuserId, Criteria::EQUAL); $c->addAnd(self::USER_ROLE_ID, $userRoleId, Criteria::EQUAL); return self::doSelect($c); }
public function updateAction() { $criteria = new Criteria("person"); $person = PersonData::getById($_POST["id"]); $criteria->update(array("no" => "\"{$_POST['no']}\"", "name" => "\"{$_POST['name']}\"", "lastname" => "\"{$_POST['lastname']}\"", "job" => "\"{$_POST['job']}\"", "phone1" => "\"{$_POST['phone1']}\"", "phone2" => "\"{$_POST['phone2']}\"", "address1" => "\"{$_POST['address1']}\"", "address2" => "\"{$_POST['address2']}\"", "email1" => "\"{$_POST['email1']}\"", "email2" => "\"{$_POST['email2']}\"", "team_id" => "\"{$_POST['team_id']}\"", "category_id" => "\"{$_POST['category_id']}\""), "id=" . $_POST["id"]); Core::redir("./?r=index/people"); }
/** * Retrieve the server object of the current data center * * @param string $server server name * @param PropelPDO $con the connection to use * @return SphinxLogServer */ public static function retrieveByLocalServer($server, PropelPDO $con = null) { $criteria = new Criteria(); $criteria->add(SphinxLogServerPeer::SERVER, $server); $criteria->add(SphinxLogServerPeer::DC, kDataCenterMgr::getCurrentDcId()); return SphinxLogServerPeer::doSelectOne($criteria, $con); }
/** * Executes index action * * @param sfRequest $request A request object */ public function executeIndex(sfWebRequest $request) { $selector = $request->getParameter('select'); $selector = $selector == "" ? 'execution' : $selector; $user = $this->getUser()->getAttribute('s_current_user', null); if ($user != null) { $this->selector = $selector; $criterio = new Criteria(); $criterio->add(TreeScPeer::USER_ID, $user->getId()); $criterio->add(TreeScPeer::FLAG, 1); $list_tree = TreeScPeer::doSelect($criterio); $this->list = $list_tree; $criteria = new Criteria(); $criteria->add(TreeScPeer::USER_ID, $user->getId()); $criteria->add(TreeScPeer::PRODUCCION, '%production%', Criteria::LIKE); $criteria->add(TreeScPeer::FLAG, 1); $user_tree = TreeScPeer::doSelect($criteria); $this->lista_tree_user = $user_tree; $criteria->clear(); // indicadores a los cuales este usuario esta com responsables $criteria->add(IndicatorsScPeer::RESPONSABLE_ID, $user->getId()); $criteria->add(IndicatorsScPeer::FLAG, '%habilitado%', Criteria::LIKE); $criteria->add(TreeScPeer::FLAG, 1); $criteria->add(TreeScPeer::PRODUCCION, '%production%', Criteria::LIKE); $criteria->addJoin(TreeScPeer::ID, IndicatorsScPeer::TREE_ID); $criteria->addGroupByColumn(IndicatorsScPeer::TREE_ID); $user_indicators = IndicatorsScPeer::doSelect($criteria); $criteria->clear(); $this->lista_indicators_user = $user_indicators; return sfView::SUCCESS; } else { return sfView::ERROR; } }
public static function retrieveByUuid($value) { $c = new Criteria(); $c->add(self::UUID, $value); $c->setIgnoreCase(true); return self::doSelectOne($c); }
protected function loadItems() { $c = new Criteria(); $c->add("returnBond", "", "!="); $c->add('status', 'validated'); $this->items = $this->site->findAll($c, "siteId, url, returnBond"); }
public function saveSubcategoriesHasFitxersList($con = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } if (!isset($this->widgetSchema['subcategories_has_fitxers_list'])) { // somebody has unset this widget return; } if (is_null($con)) { $con = $this->getConnection(); } $c = new Criteria(); $c->add(SubcategoriesHasFitxersPeer::FITXERS_FITXERSID, $this->object->getPrimaryKey()); SubcategoriesHasFitxersPeer::doDelete($c, $con); $values = $this->getValue('subcategories_has_fitxers_list'); if (is_array($values)) { foreach ($values as $value) { $obj = new SubcategoriesHasFitxers(); $obj->setFitxersFitxersid($this->object->getPrimaryKey()); $obj->setSubcategoriesIdsubcategories($value); $obj->save(); } } }
public static function getReportCount() { $c = new Criteria(); $c->add(self::REPORTS, 0, Criteria::GREATER_THAN); $c = self::addPermanentTagToCriteria($c); return self::doCount($c); }
public function execute() { $this->forceSystemAuthentication(); myDbHelper::$use_alternative_con = null; $partnerId = $this->getRequestParameter("partnerId", null); $uiConfId = $this->getRequestParameter("uiConfId", null); $page = $this->getRequestParameter("page", 1); if ($partnerId !== null && $partnerId !== "") { $pageSize = 50; $c = new Criteria(); $c->add(widgetPeer::PARTNER_ID, $partnerId); if ($uiConfId) { $c->add(widgetPeer::UI_CONF_ID, $uiConfId); } $c->addDescendingOrderByColumn(widgetPeer::CREATED_AT); $total = widgetPeer::doCount($c); $lastPage = ceil($total / $pageSize); $c->setOffset(($page - 1) * $pageSize); $c->setLimit($pageSize); $widgets = widgetPeer::doSelect($c); } else { $total = 0; $lastPage = 0; $widgets = array(); } $this->uiConfId = $uiConfId; $this->page = $page; $this->lastPage = $lastPage; $this->widgets = $widgets; $this->partner = PartnerPeer::retrieveByPK($partnerId); $this->partnerId = $partnerId; }
public function loadListFromTable($listName) { $tableName = $listName; // table must have columns: key, text and sort_index // the row with option_id = null indicates the "please select" value $peerName = $peerName = "DB_" . capitalizeFirstLetter(underscoreToLowerCase($tableName)) . "Peer"; $peer = new $peerName(); $c = new Criteria(); $c->add("key", null); $pleaseSelectOption = $peer->selectOne($c); $c = new Criteria(); $c->add("key", null, "!="); $c->addOrderAscending("sort_index"); $c->addOrderAscending("text"); $options = $peer->select($c); if ($pleaseSelectOption != null) { $this->pleaseSelectValues["{$listName}"] = $pleaseSelectOption->getText(); } else { // try SELECT_PLEASE_SELECT from the messages... $text = MessageResolver::instance()->message("SELECT_PLEASE_SELECT"); if ($text != null) { $this->pleaseSelectValues["{$listName}"] = $text; } } $out = array(); foreach ($options as $option) { $optionKey = $option->getKey(); $out["{$optionKey}"] = $option->getText(); } $this->storage["{$listName}"] = $out; }
public static function create($isoLang = 'pt_BR') { $xmlDoc = new DOMDocument('1.0', 'utf-8'); $xmlDoc->formatOutput = true; $culture = $xmlDoc->createElement($isoLang); $culture = $xmlDoc->appendChild($culture); $criteria = new Criteria(); $criteria->add(TagI18n::TABLE . '.' . TagI18n::ISOLANG, $isoLang); $objTagI18n = new TagI18nPeer(); $arrayObjTagI18n = $objTagI18n->doSelect($criteria); if (!is_object($arrayObjTagI18n) && count($arrayObjTagI18n == 0)) { $log = new Log(); $log->setLog(__FILE__, 'There are no tags with that language ' . $isoLang, true); throw new Exception('There are no tags with that language ' . $isoLang); } foreach ($arrayObjTagI18n as $objTagI18nPeer) { $item = $xmlDoc->createElement('item'); $item->setAttribute('idTagI18n', $objTagI18nPeer->getIdTagI18n()); $item = $culture->appendChild($item); $title = $xmlDoc->createElement('tag', utf8_encode($objTagI18nPeer->getTag())); $title = $item->appendChild($title); $link = $xmlDoc->createElement('i18n', utf8_encode($objTagI18nPeer->getTranslate())); $link = $item->appendChild($link); } //header("Content-type:application/xml; charset=utf-8"); $file = PATH . PATH_I18N . $isoLang . '.xml'; try { file_put_contents($file, $xmlDoc->saveXML()); } catch (Exception $e) { $log = new Log(); $log->setLog(__FILE__, 'Unable to write the XML file I18n ' . $e->getMessage(), true); } return true; }
public function executeVerify() { $this->redirectIf($this->getUser()->isAuthenticated(), 'ucp/index'); $file = $this->getRequestParameter('file'); $c = new Criteria(); $c->add(BlogPeer::FILE, $file); $blog = BlogPeer::doSelectOne($c); if ($blog && !$blog->getVerified()) { $blog_url = $blog->getUrl(); if ($blog_url[strlen($blog_url) - 1] != '/') { $blog_url .= '/'; } $url = $blog_url . $file . '.html'; $test1 = @fopen($url, 'r') !== false; $test2 = false; if (!$test1) { $contents = file_get_contents($blog_url); $test2 = preg_match('/<meta name="verify-phppl" content="' . $file . '" \\/>/im', $contents); } if ($test1 || $test2) { $blog->setVerified(true); $blog->save(); $this->setFlash('verified', true); $this->redirect('ucp/index'); } else { $this->url = $url; $this->file = $file; return sfView::ERROR; } } else { $this->redirect('@homepage'); } }