public function execute() { $this->forceSystemAuthentication(); $partner_id = $this->getRequestParameter('partner_id', -1); if ($partner_id >= 0) { myPartnerUtils::applyPartnerFilters($partner_id); } $this->partner_id = $partner_id; $order = $this->getRequestParameter('sort', kshow::KSHOW_SORT_MOST_VIEWED); $page = $this->getRequestParameter('page', 1); //$this->producer_id = $this->getRequestParameter('producer_id', 0 ); //$this->kaltura_part_of_flag = $this->getRequestParameter('partof', 0 ); $pager = kshowPeer::getOrderedPager($order, 10, $page); $kshow_list = $pager->getResults(); dashboardUtils::updateKshowsRoughcutCount($kshow_list); $kshowsData = array(); foreach ($kshow_list as $kshow) { $kshowsData[] = $this->createKShowData($kshow, $order); } // 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->kshowsData = $kshowsData; // allow the action buttons to show only for shows the user produced, and only for authenticated users, on their own pages $this->allowactions = true; // !$this->kaltura_part_of_flag && $this->getUser()->isAuthenticated() && $this->getUser()->getAttribute('id') == $this->producer_id; }
public function execute() { $this->forceSystemAuthentication(); $partner_id = $this->getRequestParameter('partner_id', -1); if ($partner_id >= 0) { myPartnerUtils::applyPartnerFilters($partner_id); } $this->partner_id = $partner_id; $order = $this->getRequestParameter('sort', kuser::KUSER_SORT_MOST_VIEWED); $page = $this->getRequestParameter('page', 1); $pager = kuserPeer::getAllUsersOrderedPager($order, 10, $page); $kuser_list = $pager->getResults(); dashboardUtils::updateKusersRoughcutCount($kuser_list); $kusersData = array(); foreach ($kuser_list as $kuser) { $kusersData[] = $this->createkuserData($kuser, $order); } // 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->kusersData = $kusersData; // allow the action buttons to show only for entires the user on their own pages $this->allowactions = true; }
public static function partnerOptions($current_value) { $options[-1] = "All"; $c = new Criteria(); $partners = PartnerPeer::doSelect($c); foreach ($partners as $partner) { $options[$partner->getId()] = $partner->getPartnerName(); } return dashboardUtils::options($current_value, $options); }
/** * Gives a system applicative snapsot */ public function execute() { myDbHelper::$use_alternative_con = myDbHelper::DB_HELPER_CONN_PROPEL3; $this->forceSystemAuthentication(); $partner_id = $this->getRequestParameter('partner_id', -1); if ($partner_id >= 0) { myPartnerUtils::applyPartnerFilters($partner_id); } $this->partner_id = $partner_id; $limit = $this->getRequestParameter('limit', '30'); if ($limit > 300) { $limit = 300; } $bands_only = $this->getRequestParameter("bands", false) != null; $modified_only = $this->getRequestParameter("modified", false) != null; $this->bands_only = $bands_only; $this->modified_only = $modified_only; $this->kshows_with_new_entries = $modified_only ? dashboardUtils::getUpdatedKshows() : null; $yesterday = mktime(0, 0, 0, date("m"), date("d") - 1, date("Y")); $lastweek = mktime(0, 0, 0, date("m"), date("d") - 7, date("Y")); $query_esterday = date('Y-m-d', $yesterday); $query_lastweek = date('Y-m-d', $lastweek); $modified_band_ids = $modified_only ? array_keys($this->kshows_with_new_entries) : null; if ($modified_only) { // TODO - this chunk was copied from the code bellow with minor changes - generalize ! $c = new Criteria(); // $c->add ( kshowPeer::ID , $modified_band_ids , Criteria::IN ); // search only the given IDs $this->bandsOnly($bands_only, $modified_band_ids, $c, kshowPeer::PARTNER_ID); $this->kshow_count = kshowPeer::doCount($c); $criterion = $c->getNewCriterion(kshowPeer::CREATED_AT, $query_esterday, Criteria::GREATER_EQUAL); $c->add($criterion); $this->kshow_count1 = kshowPeer::doCount($c); $criterion = $c->getNewCriterion(kshowPeer::CREATED_AT, $query_lastweek, Criteria::GREATER_EQUAL); $c->add($criterion); $this->kshow_count7 = kshowPeer::doCount($c); $c->setLimit($limit); //$c->hints = array(kshowPeer::TABLE_NAME => "created_at_index"); $c->addDescendingOrderByColumn(kshowPeer::CREATED_AT); $c->remove(kshowPeer::CREATED_AT); $c->addJoin(kshowPeer::PRODUCER_ID, kuserPeer::ID, Criteria::LEFT_JOIN); $this->kshows = kshowPeer::doSelectJoinkuser($c); $this->bands_only = $bands_only; $this->entry_count = 0; $this->entry_count1 = 0; $this->entry_count7 = 0; $this->entries = array(); $this->kuser_count = 0; $this->kuser_count1 = 0; $this->kuser_count7 = 0; $this->kusers = array(); dashboardUtils::updateKshowsRoughcutCount($this->kshows); return sfView::SUCCESS; } $c = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $c, kshowPeer::PARTNER_ID); $this->kshow_count = kshowPeer::doCount($c); $d = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $d, kshowPeer::PARTNER_ID); $criterion = $c->getNewCriterion(kshowPeer::CREATED_AT, $query_esterday, Criteria::GREATER_EQUAL); $d->add($criterion); $this->kshow_count1 = kshowPeer::doCount($d); $e = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $e, kshowPeer::PARTNER_ID); $criterion = $c->getNewCriterion(kshowPeer::CREATED_AT, $query_lastweek, Criteria::GREATER_EQUAL); $e->add($criterion); $this->kshow_count7 = kshowPeer::doCount($e); //$this->kshow_count = kshowPeer::doCount( $c ); $c->setLimit($limit); //$c->hints = array(kshowPeer::TABLE_NAME => "created_at_index"); $c->addDescendingOrderByColumn(kshowPeer::CREATED_AT); $c->addJoin(kshowPeer::PRODUCER_ID, kuserPeer::ID, Criteria::LEFT_JOIN); $this->kshows = kshowPeer::doSelectJoinkuser($c); $c = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $c, entryPeer::PARTNER_ID); $this->entry_count = entryPeer::doCount($c); $d = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $d, entryPeer::PARTNER_ID); $criterion = $c->getNewCriterion(entryPeer::CREATED_AT, $query_esterday, Criteria::GREATER_EQUAL); $d->add($criterion); $this->entry_count1 = entryPeer::doCount($d); $e = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $e, entryPeer::PARTNER_ID); $criterion = $c->getNewCriterion(entryPeer::CREATED_AT, $query_lastweek, Criteria::GREATER_EQUAL); $e->add($criterion); $this->entry_count7 = entryPeer::doCount($e); $c->setLimit($limit); //$c->hints = array(entryPeer::TABLE_NAME => "created_at_index"); $c->addDescendingOrderByColumn(entryPeer::CREATED_AT); $c->add(entryPeer::TYPE, entryType::MEDIA_CLIP); // we don't want entries that // $c->addJoin(entryPeer::KUSER_ID, kuserPeer::ID, Criteria::INNER_JOIN); // $c->addJoin(entryPeer::KSHOW_ID, kshowPeer::ID, Criteria::INNER_JOIN); $this->entries = entryPeer::doSelectJoinAll($c); $c = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $c, kuserPeer::PARTNER_ID); $d = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $d, kuserPeer::PARTNER_ID); $criterion = $c->getNewCriterion(kuserPeer::CREATED_AT, $query_esterday, Criteria::GREATER_EQUAL); $d->add($criterion); $this->kuser_count1 = kuserPeer::doCount($d); $e = new Criteria(); $this->bandsOnly($bands_only, $modified_band_ids, $e, kuserPeer::PARTNER_ID); $criterion = $c->getNewCriterion(kuserPeer::CREATED_AT, $query_lastweek, Criteria::GREATER_EQUAL); $e->add($criterion); $this->kuser_count7 = kuserPeer::doCount($e); $this->kuser_count = kuserPeer::doCount($c); $c->setLimit($limit); $c->addDescendingOrderByColumn(kuserPeer::CREATED_AT); $this->kusers = kuserPeer::doSelect($c); dashboardUtils::updateKusersRoughcutCount($this->kusers); dashboardUtils::updateKshowsRoughcutCount($this->kshows); return sfView::SUCCESS; }
function firstPage($text, $pagerHtml, $producer_id, $actionTD, $kaltura_part_of_flag, $screenname, $partner_id) { $KSHOW_SORT_MOST_VIEWED = kshow::KSHOW_SORT_MOST_VIEWED; $KSHOW_SORT_MOST_RECENT = kshow::KSHOW_SORT_MOST_RECENT; $KSHOW_SORT_MOST_ENTRIES = kshow::KSHOW_SORT_MOST_ENTRIES; $KSHOW_SORT_NAME = kshow::KSHOW_SORT_NAME; $KSHOW_SORT_RANK = kshow::KSHOW_SORT_RANK; $KSHOW_SORT_MOST_COMMENTS = kshow::KSHOW_SORT_MOST_COMMENTS; $KSHOW_SORT_MOST_UPDATED = kshow::KSHOW_SORT_MOST_UPDATED; $KSHOW_SORT_MOST_CONTRIBUTORS = kshow::KSHOW_SORT_MOST_CONTRIBUTORS; $options = dashboardUtils::partnerOptions($partner_id); echo <<<EOT <script type="text/javascript"> var producer_id = 0; var kaltura_part_of_flag = 0; jQuery(document).ready(function(){ mediaSortOrder = {$KSHOW_SORT_MOST_VIEWED}; var defaultMediaPageSize = 10; mediaPager = new ObjectPager('media', defaultMediaPageSize, requestMedia); updatePagerAndRebind ( "media_pager" , null , requestMediaPage ); }); // end document ready </script> \t<div class="mykaltura_viewAll"> \t\t<div class="content"> \t\t\t<div class="top"> \t\t\t\t<div class="clearfix" style="margin:10px 0;"> \t\t\t\t\t<ul class="pager" id="media_pager" style="float:right; margin:0;"> \t\t\t\t\t\t{$pagerHtml} \t\t\t\t\t</ul> \t\t\t\t\t<select onchange="partnerSelect(this)" id="partner_id" style="float:left;"> \t\t\t\t\t\t{$options} \t\t\t\t\t</select> \t\t\t\t</div> \t\t\t</div><!-- end top--> \t\t\t<div class="middle clearfix">\t \t\t\t\t\t<table cellspacing="0" cellpadding="0"> \t\t\t\t\t\t<thead> \t\t\t\t\t\t\t<tr> \t\t\t\t\t\t\t\t<td class="resource"></td> \t\t\t\t\t\t\t\t<td class="info" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_NAME})'><span>Kaltura Name</span></td> \t\t\t\t\t\t\t\t<td class="date" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_MOST_RECENT})'><span>Created</span></td> \t\t\t\t\t\t\t\t<td class="date" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_MOST_UPDATED})'><span>Updated</span></td> \t\t\t\t\t\t\t\t<td class="date" style="width: 25px">RC</td> \t\t\t\t\t\t\t\t<td class="entries" style="width: 40px" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_MOST_ENTRIES})'><span>Entries</span></td> \t\t\t\t\t\t\t\t<td class="date" style="width: 50px" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_MOST_CONTRIBUTORS})'><span>C'tors</span></td> \t\t\t\t\t\t\t\t<td class="date" style="width: 60px" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_MOST_COMMENTS})'><span>Comments</span></td> \t\t\t\t\t\t\t\t<td class="views color2" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_MOST_VIEWED})'><span>Views</span></td> \t\t\t\t\t\t\t\t<td class="rating" style="width: 60px" onclick='changeMediaSortOrder(this, {$KSHOW_SORT_RANK})'><span>Rating</span></td> \t\t\t\t\t\t\t\t{$actionTD} \t\t\t\t\t\t\t</tr> \t\t\t\t\t\t</thead> \t\t\t\t\t\t<tbody id="media_content"> \t\t\t\t\t\t\t{$text} \t\t\t\t\t\t</tbody> \t\t\t\t\t</table> \t\t\t\t \t\t\t</div><!-- end middle--> \t\t</div><!-- end content--> \t\t<div class="bgB"></div> \t</div><!-- end media--> EOT; }
$entries_data[$entry_id] = array("plays" => $plays, "views" => $views); } //old code from doSelectRs //while($rs->next()) //{ // $entry_id = $rs->getInt(1); // $plays= $rs->getInt(2); // $views = $rs->getInt(3); // $entries_data[$entry_id] = array("plays" => $plays, "views" => $views); //} foreach ($widget_log_list as $widget_log) { $media_content .= addRow($widget_log, @$kshows_data[$widget_log->getKshowId()], @$entries_data[$widget_log->getEntryId()], $i % 2 == 0); ++$i; } if ($firstTime) { $options = dashboardUtils::partnerOptions($partner_id); ?> <script type="text/javascript"> jQuery(document).ready(function(){ mediaSortOrder = "views"; var defaultMediaPageSize = 100; mediaPager = new ObjectPager('media', defaultMediaPageSize, requestMediaWidget ); updatePagerAndRebind ( "media_pager" , null , requestMediaPageWidget ); updatePagerAndRebind ( "media_pagerB" , null , requestMediaPageWidget ); jQuery("#referer") .keydown(function(e){ if (e.keyCode == 13){ requestMediaWidget(mediaPager, 1);
function firstPage($text, $pagerHtml, $user_id, $partner_id) { $KUSER_SORT_MOST_VIEWED = kuser::KUSER_SORT_MOST_VIEWED; $KUSER_SORT_MOST_RECENT = kuser::KUSER_SORT_MOST_RECENT; $KUSER_SORT_NAME = kuser::KUSER_SORT_NAME; $KUSER_SORT_AGE = kuser::KUSER_SORT_AGE; $KUSER_SORT_COUNTRY = kuser::KUSER_SORT_COUNTRY; $KUSER_SORT_CITY = kuser::KUSER_SORT_CITY; $KUSER_SORT_GENDER = kuser::KUSER_SORT_GENDER; $KUSER_SORT_MOST_FANS = kuser::KUSER_SORT_MOST_FANS; $KUSER_SORT_MOST_ENTRIES = kuser::KUSER_SORT_MOST_ENTRIES; $KUSER_SORT_PRODUCED_KSHOWS = kuser::KUSER_SORT_PRODUCED_KSHOWS; $options = dashboardUtils::partnerOptions($partner_id); echo <<<EOT <script type="text/javascript"> jQuery(document).ready(function(){ \tmediaSortOrder = {$KUSER_SORT_MOST_VIEWED}; \tvar defaultMediaPageSize = 10; \tmediaPager = new ObjectPager('media', defaultMediaPageSize, requestMediaPeople ); \tupdatePagerAndRebind ( "media_pager" , null , requestMediaPagePeople ); \tupdatePagerAndRebind ( "media_pagerB" , null , requestMediaPagePeople ); }); // end document ready </script> \t<div class="mykaltura_viewAll mykaltura_media"> \t\t<div class="content"> \t\t\t<div class="top"> \t\t\t\t<div class="clearfix" style="margin:10px 0;"> \t\t\t\t\t<ul class="pager" id="media_pager" style="float:right; margin:0;"> \t\t\t\t\t\t{$pagerHtml} \t\t\t\t\t</ul> \t\t\t\t\t<select onchange="partnerSelect(this)" id="partner_id" style="float:left;"> \t\t\t\t\t\t{$options} \t\t\t\t\t</select> \t\t\t\t</div> \t\t\t</div><!-- end top--> \t\t\t<div class="middle">\t \t\t\t\t\t<table cellspacing="0" cellpadding="0"> \t\t\t\t\t\t<thead> \t\t\t\t\t\t\t<tr> \t\t\t\t\t\t\t\t<td class="resource"></td> \t\t\t\t\t\t\t\t<td class="info" onclick='changeMediaSortOrder(this, {$KUSER_SORT_NAME})'><span>Screen Name</span></td> \t\t\t\t\t\t\t\t<td class="type" onclick='changeMediaSortOrder(this, {$KUSER_SORT_COUNTRY})'><span>Country</span></td> \t\t\t\t\t\t\t\t<td class="rating" onclick='changeMediaSortOrder(this, {$KUSER_SORT_GENDER})'><span>Gender</span></td> \t\t\t\t\t\t\t\t<td class="date" onclick='changeMediaSortOrder(this, {$KUSER_SORT_MOST_RECENT})'><span>Created</span></td> \t\t\t\t\t\t\t\t<td class="views color2" onclick='changeMediaSortOrder(this, {$KUSER_SORT_MOST_VIEWED})'><span>Views</span></td> \t\t\t\t\t\t\t\t<td class="views" onclick='changeMediaSortOrder(this, {$KUSER_SORT_MOST_FANS})'><span>Fans</span></td> \t\t\t\t\t\t\t\t<td class="views" onclick='changeMediaSortOrder(this, {$KUSER_SORT_PRODUCED_KSHOWS})'><span>Shows</span></td> \t\t\t\t\t\t\t\t<td class="date" style="width: 25px; cursor:default;">RC</td> \t\t\t\t\t\t\t\t<td class="views" onclick='changeMediaSortOrder(this, {$KUSER_SORT_MOST_ENTRIES})'><span>Entries</span></td> \t\t\t\t\t\t\t\t<td class="action" >Action</td> \t\t\t\t\t\t\t</tr> \t\t\t\t\t\t</thead> \t\t\t\t\t\t<tbody id="media_content"> \t\t\t\t\t\t\t{$text} \t\t\t\t\t\t</tbody> \t\t\t\t\t</table> \t\t\t</div><!-- end middle--> \t\t\t<div class="clearfix"> \t\t\t\t<ul class="pager" id="media_pagerB"> \t\t\t\t\t{$pagerHtml} \t\t\t\t</ul> \t\t\t</div> \t\t</div><!-- end content--> \t\t<div class="bgB"></div> \t</div><!-- end media--> EOT; }
public static function partnerOptions($current_value) { $options[-1] = "All"; $c = new Criteria(); $partners = PartnerPeer::doSelect($c); foreach ($partners as $partner) { $options[$partner->getId()] = $partner->getPartnerName(); } return dashboardUtils::options($current_value, $options); //array (-1 => "All" , 0 => "Kaltura" , 100 => "FB" , 5 => "MS Bands" , 10 => "BuddyLube|Mudvayne") ); }