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();
}
