protected function createAdvancedSearchCriteria($arr) { $c = new Criteria(); if (strlen($arr['jobStatus'])) { $c->add(JobPeer::STATUS_ID, $arr["jobStatus"]); } if (!is_null($arr["dueDateStart"])) { $c->add(JobPeer::DUE_DATE, $arr["dueDateStart"], Criteria::GREATER_EQUAL); } if (!is_null($arr["dueDateEnd"])) { $c->addAnd(JobPeer::DUE_DATE, $arr["dueDateEnd"], Criteria::LESS_EQUAL); } if (!is_null($arr["shootDateStart"])) { $c->add(JobPeer::DATE, $arr["shootDateStart"], Criteria::GREATER_EQUAL); } if (!is_null($arr["shootDateEnd"])) { $c->addAnd(JobPeer::DATE, $arr["shootDateEnd"], Criteria::LESS_EQUAL); } if (strlen($arr["clientId"])) { $jobIds = JobClientPeer::getJobsByClientId($arr["clientId"]); $c->add(JobPeer::ID, $jobIds, Criteria::IN); } if (strlen($arr["photographerId"])) { $jobIds = JobPhotographerPeer::getJobsByPhotographerId($arr["photographerId"]); $c->addAnd(JobPeer::ID, $jobIds, Criteria::IN); } if ($arr["sortDirection"] == 1) { $c->addDescendingOrderByColumn($arr["sortOn"]); } else { $c->addAscendingOrderByColumn($arr["sortOn"]); } return $c; }
public function myBatchPartnerUsage($partnerId = null) { self::initDb(); $partners_exists = true; $start_pos = 0; $bulk_size = 500; while ($partners_exists) { $c = new Criteria(); if (!is_null($partnerId)) { $c->addAnd(PartnerPeer::ID, $partnerId); } $c->addAnd(PartnerPeer::PARTNER_PACKAGE, 1); // get only free partners $c->addAnd(PartnerPeer::MONITOR_USAGE, 1); $c->addAnd(PartnerPeer::STATUS, Partner::PARTNER_STATUS_DELETED, CRITERIA::NOT_EQUAL); $c->setOffset($start_pos); $c->setLimit($bulk_size); $partners = PartnerPeer::doSelect($c); if (!$partners) { KalturaLog::debug("No more partners. offset: {$start_pos} , limit: {$bulk_size} ."); $partners_exists = false; } else { KalturaLog::debug("Looping " . ($start_pos + $bulk_size - 1) . " partners, offset: {$start_pos} ."); foreach ($partners as $partner) { myPartnerUtils::doPartnerUsage($partner, true); } } unset($partners); PartnerPeer::clearInstancePool(); $start_pos += $bulk_size; } }
/** * Add new Syndication Feed * * @action add * @param KalturaBaseSyndicationFeed $syndicationFeed * @return KalturaBaseSyndicationFeed */ public function addAction(KalturaBaseSyndicationFeed $syndicationFeed) { $syndicationFeed->validatePlaylistId(); if ($syndicationFeed instanceof KalturaGenericXsltSyndicationFeed) { $syndicationFeed->validateXslt(); $syndicationFeedDB = new genericSyndicationFeed(); $syndicationFeedDB->setVersion(1); } else { $syndicationFeedDB = new syndicationFeed(); } $syndicationFeed->partnerId = $this->getPartnerId(); $syndicationFeed->status = KalturaSyndicationFeedStatus::ACTIVE; $syndicationFeed->toObject($syndicationFeedDB); $syndicationFeedDB->save(); if ($syndicationFeed->addToDefaultConversionProfile) { $partner = PartnerPeer::retrieveByPK($this->getPartnerId()); $c = new Criteria(); $c->addAnd(flavorParamsConversionProfilePeer::CONVERSION_PROFILE_ID, $partner->getDefaultConversionProfileId()); $c->addAnd(flavorParamsConversionProfilePeer::FLAVOR_PARAMS_ID, $syndicationFeed->flavorParamId); $is_exist = flavorParamsConversionProfilePeer::doCount($c); if (!$is_exist || $is_exist === 0) { $fpc = new flavorParamsConversionProfile(); $fpc->setConversionProfileId($partner->getDefaultConversionProfileId()); $fpc->setFlavorParamsId($syndicationFeed->flavorParamId); $fpc->save(); } } if ($syndicationFeed instanceof KalturaGenericXsltSyndicationFeed) { $key = $syndicationFeedDB->getSyncKey(genericSyndicationFeed::FILE_SYNC_SYNDICATION_FEED_XSLT); kFileSyncUtils::file_put_contents($key, $syndicationFeed->xslt); } $syndicationFeed->fromObject($syndicationFeedDB); return $syndicationFeed; }
/** * Will return the first virus scan profile of the entry's partner, that defines an entry filter suitable for the given entry. * @param int $entryId * @return VirusScanProfile the suitable profile object, or null if none found */ public static function getSuitableProfile($entryId) { $entry = entryPeer::retrieveByPK($entryId); if (!$entry) { KalturaLog::err('Cannot find entry with id [' . $entryId . ']'); return null; } if ($entry->getSource() == entry::ENTRY_MEDIA_SOURCE_WEBCAM) { return null; } $cProfile = new Criteria(); $cProfile->addAnd(VirusScanProfilePeer::PARTNER_ID, $entry->getPartnerId()); $cProfile->addAnd(VirusScanProfilePeer::STATUS, VirusScanProfileStatus::ENABLED, Criteria::EQUAL); $profiles = VirusScanProfilePeer::doSelect($cProfile); if (!$profiles) { KalturaLog::debug('No virus scan profiles found for partner [' . $entry->getPartnerId() . ']'); return null; } foreach ($profiles as $profile) { $virusEntryFilter = $profile->getEntryFilterObject(); if ($virusEntryFilter->matches($entry)) { KalturaLog::debug('Returning profile with id [' . $profile->getId() . ']'); return $profile; } } return null; }
public static function retrieveByProviderAndPartnerID($provider, $partnerId) { $c = new Criteria(); $c->addAnd(DrmProfilePeer::PROVIDER, $provider, Criteria::EQUAL); $c->addAnd(DrmProfilePeer::PARTNER_ID, $partnerId, Criteria::EQUAL); return DrmProfilePeer::doSelectOne($c); }
public function myBatchPartnerUsage() { self::initDb(); $partners_exists = true; $start_pos = 0; $bulk_size = 500; while ($partners_exists) { $c = new Criteria(); // get only free partners $c->addAnd(PartnerPeer::PARTNER_PACKAGE, 1); $c->addAnd(PartnerPeer::MONITOR_USAGE, 1); $c->setOffset($start_pos); $c->setLimit($bulk_size); $partners = PartnerPeer::doSelect($c); if (!$partners) { TRACE("No more partners. offset: {$start_pos} , limit: {$bulk_size} ."); $partners_exists = false; } else { TRACE("Looping " . ($start_pos + $bulk_size - 1) . " partners, offset: {$start_pos} ."); foreach ($partners as $partner) { myPartnerUtils::doPartnerUsage($partner, true); } } unset($partners); $start_pos += $bulk_size; } }
public function execute() { die; $this->forceSystemAuthentication(); $order = $this->getRequestParameter('sort', 'id'); $page = $this->getRequestParameter('page', 1); $referer = $this->getRequestParameter('referer', ""); $c = new Criteria(); if ($referer) { $c->add(WidgetLogPeer::REFERER, "%{$referer}%", Criteria::LIKE); } $c->addAnd(WidgetLogPeer::REFERER, "%diff=%", Criteria::NOT_LIKE); $c->addAnd(WidgetLogPeer::REFERER, "%kaltura:%", Criteria::NOT_LIKE); $partner_id = $this->getRequestParameter('partner_id', -1); if ($partner_id >= 0) { $c->add(WidgetLogPeer::PARTNER_ID, $partner_id); //fixme: replace with myPartnerUtils::applyPartnerFilters( $partner_id ); } $this->partner_id = $partner_id; $pager = WidgetLogPeer::getWidgetOrderedPager($order, 100, $page, $c); $widget_log_list = $pager->getResults(); // following variables will be used by the view $this->firstTime = $this->getRequestParameter('first', 1) == 1; $this->order = $order; $this->page = $page; $this->lastPage = $pager->getLastPage(); $this->numResults = $pager->getNbResults(); $this->widget_log_list = $widget_log_list; $this->referer = $referer; // allow the action buttons to show only for entires the user on their own pages $this->allowactions = true; }
public function executeImpl($partner_id, $subp_id, $puser_id, $partner_prefix, $puser_kuser) { $limit = $this->getP("page_size", 20); $limit = min($limit, 100); $page = $this->getP("page", 1); $offset = ($page - 1) * $limit; $c = new Criteria(); $c->addAnd(BatchJobPeer::PARTNER_ID, $partner_id); $c->addAnd(BatchJobPeer::JOB_TYPE, BatchJobType::BULKUPLOAD); $c->addDescendingOrderByColumn(BatchJobPeer::ID); $count = BatchJobPeer::doCount($c); $c->setLimit($limit); $c->setOffset($offset); $jobs = BatchJobPeer::doSelect($c); $obj = array(); foreach ($jobs as $job) { $jobData = $job->getData(); if (!$jobData instanceof kBulkUploadJobData) { continue; } $bulkResults = BulkUploadResultPeer::retrieveWithEntryByBulkUploadId($job->getId()); $obj[] = array("uploadedBy" => $jobData->getUploadedBy(), "uploadedOn" => $job->getCreatedAt(null), "numOfEntries" => count($bulkResults), "status" => $job->getStatus(), "error" => $job->getStatus() == BatchJob::BATCHJOB_STATUS_FAILED ? $job->getMessage() : '', "logFileUrl" => requestUtils::getCdnHost() . "/index.php/extwidget/bulkuploadfile/id/{$job->getId()}/pid/{$job->getPartnerId()}/type/log", "csvFileUrl" => requestUtils::getCdnHost() . "/index.php/extwidget/bulkuploadfile/id/{$job->getId()}/pid/{$job->getPartnerId()}/type/csv"); } $this->addMsg("count", $count); $this->addMsg("page_size", $limit); $this->addMsg("page", $page); $this->addMsg("bulk_uploads", $obj); }
/** * 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); }
/** * @param BaseObject $object * @return bool true if should continue to the next consumer */ public function objectAdded(BaseObject $object) { if (!$object instanceof FileSync || $object->getStatus() != FileSync::FILE_SYNC_STATUS_PENDING || $object->getFileType() != FileSync::FILE_SYNC_FILE_TYPE_FILE || $object->getDc() == kDataCenterMgr::getCurrentDcId()) { return true; } $c = new Criteria(); $c->addAnd(FileSyncPeer::OBJECT_ID, $object->getObjectId()); $c->addAnd(FileSyncPeer::VERSION, $object->getVersion()); $c->addAnd(FileSyncPeer::OBJECT_TYPE, $object->getObjectType()); $c->addAnd(FileSyncPeer::OBJECT_SUB_TYPE, $object->getObjectSubType()); $c->addAnd(FileSyncPeer::ORIGINAL, '1'); $original_filesync = FileSyncPeer::doSelectOne($c); if (!$original_filesync) { KalturaLog::err('Original filesync not found for object_id[' . $object->getObjectId() . '] version[' . $object->getVersion() . '] type[' . $object->getObjectType() . '] subtype[' . $object->getObjectSubType() . ']'); return true; } $sourceFileUrl = $original_filesync->getExternalUrl(); if (!$sourceFileUrl) { KalturaLog::err('External URL not found for filesync id [' . $object->getId() . ']'); return true; } $job = kMultiCentersManager::addFileSyncImportJob($this->getEntryId($object), $object->getPartnerId(), $object->getId(), $sourceFileUrl); $job->setDc($object->getDc()); $job->save(); return true; }
public static function doSelectOutOfPeriod($activeOnly = true, $time = null) { if (is_null($time)) { $time = time(); } $now_hour = date('H:i:s', $time); $c = new Criteria(); $critA = $c->getNewCriterion(self::START, self::START . ' < ' . self::STOP, Criteria::CUSTOM); $critB = $c->getNewCriterion(self::START, self::START . ' > ' . self::STOP, Criteria::CUSTOM); $critStartA = $c->getNewCriterion(self::START, $now_hour, Criteria::GREATER_EQUAL); $critStopA = $c->getNewCriterion(self::STOP, $now_hour, Criteria::LESS_THAN); $critStartB = $c->getNewCriterion(self::START, $now_hour, Criteria::GREATER_EQUAL); $critStopB = $c->getNewCriterion(self::STOP, $now_hour, Criteria::LESS_THAN); $critStopA->addOr($critStartA); $critStopB->addAnd($critStartB); $critA->addAnd($critStopA); $critB->addAnd($critStopB); $critA->addOr($critB); if ($activeOnly) { $c->addAnd(self::STATUS, true, Criteria::EQUAL); } $c->addAnd($critA); $c->addAnd(self::START, self::START . ' <> ' . self::STOP, Criteria::CUSTOM); return self::doSelect($c); }
public static function retrieveByDropFolderIdAndStatus($dropFolderId, $status) { $c = new Criteria(); $c->addAnd(DropFolderFilePeer::DROP_FOLDER_ID, $dropFolderId, Criteria::EQUAL); $c->addAnd(DropFolderFilePeer::STATUS, $status, Criteria::EQUAL); $dropFolderFiles = DropFolderFilePeer::doSelect($c); return $dropFolderFiles; }
public static function retrieveByEntryIdPartnerIdAndStatuses($entryId, $partnerId, $statuses) { $c = new Criteria(); $c->addAnd(DropFolderFilePeer::ENTRY_ID, $entryId, Criteria::EQUAL); $c->addAnd(DropFolderFilePeer::PARTNER_ID, $partnerId, Criteria::EQUAL); $c->addAnd(DropFolderFilePeer::STATUS, $statuses, Criteria::IN); $dropFolderFiles = DropFolderFilePeer::doSelect($c); return $dropFolderFiles; }
public function execute() { $jobId = $this->getRequestParameter("id"); $partnerId = $this->getRequestParameter("pid"); $type = $this->getRequestParameter("type"); $c = new Criteria(); $c->addAnd(BatchJobPeer::ID, $jobId); $c->addAnd(BatchJobPeer::PARTNER_ID, $partnerId); $c->addAnd(BatchJobPeer::JOB_TYPE, BatchJobType::BULKUPLOAD); $batchJob = BatchJobPeer::doSelectOne($c); if (!$batchJob) { die("File not found"); } header("Content-Type: text/plain; charset=UTF-8"); if ($type == "log") { $bulkUploadResults = BulkUploadResultPeer::retrieveByBulkUploadId($jobId); if (!count($bulkUploadResults)) { $syncKey = $batchJob->getSyncKey(BatchJob::FILE_SYNC_BATCHJOB_SUB_TYPE_BULKUPLOADLOG); if (kFileSyncUtils::file_exists($syncKey, true)) { $content = kFileSyncUtils::file_get_contents($syncKey, true); echo $content; die; } die("Log file is not ready"); } $STDOUT = fopen('php://output', 'w'); $data = $batchJob->getData(); foreach ($bulkUploadResults as $bulkUploadResult) { $values = array($bulkUploadResult->getTitle(), $bulkUploadResult->getDescription(), $bulkUploadResult->getTags(), $bulkUploadResult->getUrl(), $bulkUploadResult->getContentType()); if ($data instanceof kBulkUploadJobData && $data->getCsvVersion() > kBulkUploadJobData::BULK_UPLOAD_CSV_VERSION_V1) { $values[] = $bulkUploadResult->getConversionProfileId(); $values[] = $bulkUploadResult->getAccessControlProfileId(); $values[] = $bulkUploadResult->getCategory(); $values[] = $bulkUploadResult->getScheduleStartDate('Y-m-d\\TH:i:s'); $values[] = $bulkUploadResult->getScheduleEndDate('Y-m-d\\TH:i:s'); $values[] = $bulkUploadResult->getThumbnailUrl(); $values[] = $bulkUploadResult->getPartnerData(); } $values[] = $bulkUploadResult->getEntryId(); $values[] = $bulkUploadResult->getEntryStatus(); $values[] = $bulkUploadResult->getErrorDescription(); fputcsv($STDOUT, $values); } fclose($STDOUT); } else { $syncKey = $batchJob->getSyncKey(BatchJob::FILE_SYNC_BATCHJOB_SUB_TYPE_BULKUPLOADCSV); if (kFileSyncUtils::file_exists($syncKey, true)) { $content = kFileSyncUtils::file_get_contents($syncKey, true); echo $content; die; } else { die("File not found"); } } die; // no template needed }
public static function retrieveByPartnerIdAndSystemName($partnerId, $systemName, $type) { $c = new Criteria(); $c->addAnd(conversionProfile2Peer::PARTNER_ID, $partnerId); $c->addAnd(conversionProfile2Peer::SYSTEM_NAME, $systemName); $c->addAnd(conversionProfile2Peer::STATUS, ConversionProfileStatus::ENABLED); $c->addAnd(conversionProfile2Peer::TYPE, $type); return conversionProfile2Peer::doSelectOne($c); }
protected static function getOriginalFileSync($fileSync) { $c = new Criteria(); $c->addAnd(FileSyncPeer::OBJECT_ID, $fileSync->getObjectId()); $c->addAnd(FileSyncPeer::OBJECT_TYPE, $fileSync->getObjectType()); $c->addAnd(FileSyncPeer::VERSION, $fileSync->getVersion()); $c->addAnd(FileSyncPeer::OBJECT_SUB_TYPE, $fileSync->getObjectSubType()); $c->addAnd(FileSyncPeer::DC, $fileSync->getOriginalDc()); return FileSyncPeer::doSelectOne($c); }
/** * Will return a UserRole object with the given $roleName and given $partnerId (or partner 0) * @param string $roleName * @param int $partnerId * @return UserRole */ public static function getByNameAndPartnerId($roleName, $partnerId) { $c = new Criteria(); $c->addAnd(UserRolePeer::PARTNER_ID, array($partnerId, PartnerPeer::GLOBAL_PARTNER), Criteria::IN); $c->addAnd(UserRolePeer::NAME, $roleName, Criteria::EQUAL); UserRolePeer::setUseCriteriaFilter(false); $userRole = UserRolePeer::doSelectOne($c); UserRolePeer::setUseCriteriaFilter(true); return $userRole; }
/** * * @param FileSyncKey $key * @param Criteria $c * @return Criteria */ public static function getCriteriaForFileSyncKey(FileSyncKey $key, Criteria $c = null) { if ($c == null) { $c = new Criteria(); } $c->addAnd(self::OBJECT_ID, $key->object_id); $c->addAnd(self::OBJECT_TYPE, $key->object_type); $c->addAnd(self::OBJECT_SUB_TYPE, $key->object_sub_type); $c->addAnd(self::VERSION, $key->version); return $c; }
public static function getExamsForYearAndCourseId($courseId, $year, PropelPDO $propelConnection) { $c = new Criteria(); $crit1 = $c->getNewCriterion(ExamPeer::COURSE_ID, $courseId); $crit2 = $c->getNewCriterion(ExamPeer::YEAR, $year); $c->addAnd($crit1); $c->addAnd($crit2); $c->addAscendingOrderByColumn(ExamPeer::TYPE); $c->addAscendingOrderByColumn(ExamPeer::DESCR); return ExamPeer::doSelect($c, $propelConnection); }
public static function markAsModeratedByKUserId($partnerId, $kuserId) { $c = new Criteria(); $c->addAnd(moderationFlagPeer::PARTNER_ID, $partnerId); $c->addAnd(moderationFlagPeer::OBJECT_TYPE, moderationObjectType::ENTRY); $c->addAnd(moderationFlagPeer::FLAGGED_KUSER_ID, $kuserId); $c->addAnd(moderationFlagPeer::STATUS, moderationFlagStatus::PENDING); $update = new Criteria(); $update->add(moderationFlagPeer::STATUS, moderationFlagStatus::MODERATED); self::doUpdateAll($c, $update); }
public static function doSelectByEntryIdAndPuserId($entryId, $partnerId, $puserId) { $kuser = self::getKuserFromPuserAndPartner($puserId, $partnerId); if (!$kuser) { return null; } $c = new Criteria(); $c->addAnd(kvotePeer::KUSER_ID, $kuser->getId(), Criteria::EQUAL); $c->addAnd(kvotePeer::ENTRY_ID, $entryId, Criteria::EQUAL); return self::doSelectOne($c); }
public function modifyCriteria(Criteria $c) { // entryPeer::setUseCriteriaFilter( false ); // $c->addJoin( entryPeer::KSHOW_ID , kshowPeer::ID , Criteria::LEFT_JOIN); // $c->addJoin( entryPeer::KUSER_ID , kuserPeer::ID , Criteria::LEFT_JOIN); if ($this->kuser_id) { $c->addAnd(entryPeer::KUSER_ID, $this->kuser_id); } if ($this->media_type) { $c->addAnd(entryPeer::MEDIA_TYPE, $this->media_type); } }
private static function retrieveByPartnerAndPrifileTypeImpl($fallback_mode, $partner_id, $profile_type, $display_disabled = false) { $c = new Criteria(); $c->addAnd(self::PROFILE_TYPE, $profile_type); $c->addAnd(self::PARTNER_ID, $partner_id); if (!$display_disabled) { $c->addAnd(self::ENABLED, 1); } $c->addAscendingOrderByColumn(self::PROFILE_TYPE_INDEX); $conversion_params_list = self::doSelect($c); return array($conversion_params_list, array("mode" => $fallback_mode, "partner_id" => $partner_id, "profile_type" => $profile_type)); }
public static function retrieveTicketFor($object) { $c = new Criteria(); $c->addAnd(self::FIELD_TABLE, self::getTable($object)); $c->addAnd(self::TABLE_PRIMARY_KEY, serialize($object->getPrimaryKey())); $c->addAnd(self::CREATED_AT, date('Y-m-d H:i:s'), Criteria::LESS_THAN); $c->addAnd(self::EXPIRES_AT, date('Y-m-d H:i:s'), Criteria::GREATER_THAN); $ret = self::doSelectOne($c); if (is_null($ret)) { $ret = self::createTicketFor($object); } return $ret; }
public static function getChangeLogOfObject($class, $pk = null, $from_date = null, $to_date = null) { $c = new Criteria(); $c->add(ncChangeLogEntryPeer::CLASS_NAME, $class); if (!is_null($pk)) { $c->add(ncChangeLogEntryPeer::OBJECT_PK, $pk); } $criterion1 = $c->getNewCriterion(ncChangeLogEntryPeer::CREATED_AT, $from_date, Criteria::GREATER_EQUAL); $criterion2 = $c->getNewCriterion(ncChangeLogEntryPeer::CREATED_AT, $to_date, Criteria::LESS_EQUAL); $c->addAnd($criterion1); $c->addAnd($criterion2); return self::convertToAdapter(ncChangeLogEntryPeer::doSelect($c)); }
public static function authenticate($card_number, $pincode) { $c = new Criteria(); $c->add(CardPeer::CARD_NUMBER, $card_number, Criteria::EQUAL); $c->addAnd(CardPeer::PIN_CODE, $pincode, Criteria::EQUAL); $c->addAnd(CardPeer::IS_ACTIVE, true, Criteria::EQUAL); $c->addAnd(CardPeer::OWNER, null, Criteria::ISNOTNULL); $card = CardPeer::doSelectOne($c); if (!$card || !$card->isOwned()) { return null; } return $card; }
/** * Fetches a list of Course objects * * @param int $disciplintId The EnumItem id of discipline * @param int $year Year of study * @return A list of course objects */ public static function findCoursesByDisciplineIdAndYear($disciplineId, $year, PropelPDO $propelConnection = null) { $c = new Criteria(); $c->addJoin(CoursePeer::ID, CourseDisciplineAssociationPeer::COURSE_ID); $crit1 = $c->getNewCriterion(CourseDisciplineAssociationPeer::DISCIPLINE_ID, $disciplineId); $c->addAnd($crit1); if ($year > 0) { $crit2 = $c->getNewCriterion(CourseDisciplineAssociationPeer::YEAR_OF_STUDY, $year); $c->addAnd($crit2); } $c->setDistinct(); $c->addAscendingOrderByColumn(CoursePeer::ID); return CoursePeer::doselect($c, $propelConnection); }
function getAdminUsers($lastUser, $userLimitEachLoop) { kuserPeer::clearInstancePool(); UserRolePeer::clearInstancePool(); $c = new Criteria(); $c->addAnd(kuserPeer::ID, $lastUser, Criteria::GREATER_THAN); $c->addAnd(kuserPeer::IS_ADMIN, true, Criteria::EQUAL); $c->addAscendingOrderByColumn(kuserPeer::ID); $c->setLimit($userLimitEachLoop); kuserPeer::setUseCriteriaFilter(false); $users = kuserPeer::doSelect($c); kuserPeer::setUseCriteriaFilter(true); return $users; }
public static function doSelectStmt(Criteria $criteria, PropelPDO $con = null) { $id_empresa = sfContext::getInstance()->getUser()->getAttribute('idempresa', null); $todas_empresas = sfContext::getInstance()->getUser()->getAttribute('todas_empresas', null); $estamosEmpresa = sfContext::getInstance()->getModuleName() == "empresas"; if ($id_empresa != null && !$estamosEmpresa && !$todas_empresas) { $criteria->addAnd(EmpresaPeer::ID_EMPRESA, $id_empresa, Criteria::EQUAL); } $c1 = $criteria->getNewCriterion(EmpresaPeer::BORRADO, null, Criteria::ISNULL); $c2 = $criteria->getNewCriterion(EmpresaPeer::BORRADO, false, Criteria::EQUAL); $c1->addOr($c2); $criteria->addAnd($c1); return parent::doSelectStmt($criteria, $con); }
public static function incrementActivity($partner_id, $activity, $sub_activity, $amount = 1, $day = null, $field = null) { if (!$day) { $day = date("Y-m-d"); } $field_name = $field ? PartnerActivityPeer::AMOUNT . $field : PartnerActivityPeer::AMOUNT; /* $query = "INSERT INTO ".PartnerActivityPeer::TABLE_NAME." (". PartnerActivityPeer::PARTNER_ID.",". PartnerActivityPeer::ACTIVITY_DATE.",". PartnerActivityPeer::ACTIVITY.",". PartnerActivityPeer::SUB_ACTIVITY.",". $field_name.") VALUES ". "($partner_id,'$day',$activity,$sub_activity,$amount) ON DUPLICATE KEY UPDATE ". "$field_name=$field_name+$amount"; $connection = Propel::getConnection(); $statement = $connection->prepareStatement($query); $resultset = $statement->executeQuery(); */ $connection = Propel::getConnection(); $crit = new Criteria(); $crit->addAnd(PartnerActivityPeer::PARTNER_ID, $partner_id); $crit->addAnd(PartnerActivityPeer::ACTIVITY_DATE, $day); $crit->addAnd(PartnerActivityPeer::ACTIVITY, $activity); $crit->addAnd(PartnerActivityPeer::SUB_ACTIVITY, $sub_activity); $crit->addSelectColumn(PartnerActivityPeer::ID); $resultset = PartnerActivityPeer::doSelectOne($crit, $connection); /* $query = "SELECT ID FROM ".PartnerActivityPeer::TABLE_NAME." WHERE ". PartnerActivityPeer::PARTNER_ID."=$partner_id AND ". PartnerActivityPeer::ACTIVITY_DATE."='$day' AND ". PartnerActivityPeer::ACTIVITY."=$activity AND ". PartnerActivityPeer::SUB_ACTIVITY."=$sub_activity"; $statement = $connection->prepare($query); $resultset = $statement->execute(); */ // if the key exists do an update command if ($resultset) { $id = $resultset->getInt('ID'); $updateCommand = "UPDATE " . PartnerActivityPeer::TABLE_NAME . " SET {$field_name}={$field_name}+{$amount} WHERE " . PartnerActivityPeer::ID . "={$id}"; } else { $updateCommand = "INSERT INTO " . PartnerActivityPeer::TABLE_NAME . " (" . PartnerActivityPeer::PARTNER_ID . "," . PartnerActivityPeer::ACTIVITY_DATE . "," . PartnerActivityPeer::ACTIVITY . "," . PartnerActivityPeer::SUB_ACTIVITY . "," . $field_name . ") VALUES " . "({$partner_id},'{$day}',{$activity},{$sub_activity},{$amount})"; } $statement = $connection->prepare($updateCommand); $resultset = $statement->execute(); }