dashboardUtils PHPのコード例

コード例 #1

0

ファイルを表示

ファイル: viewShowsAction.class.php プロジェクト: EfncoPlugins/Media-Management-based-on-Kaltura

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

コード例 #2

0

ファイルを表示

ファイル: viewUsersAction.class.php プロジェクト: richhl/kalturaCE

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

コード例 #3

0

ファイルを表示

ファイル: dashboardUtils.class.php プロジェクト: DBezemer/server

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

コード例 #4

0

ファイルを表示

ファイル: viewDashboardAction.class.php プロジェクト: richhl/kalturaCE

 /**
  * 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;
 }

コード例 #5

0

ファイルを表示

ファイル: viewShowsSuccess.php プロジェクト: richhl/kalturaCE

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

コード例 #6

0

ファイルを表示

ファイル: viewWidgetsSuccess.php プロジェクト: EfncoPlugins/Media-Management-based-on-Kaltura

    $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);

コード例 #7

0

ファイルを表示

ファイル: viewUsersSuccess.php プロジェクト: richhl/kalturaCE

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

コード例 #8

0

ファイルを表示

ファイル: dashboardUtils.class.php プロジェクト: EfncoPlugins/Media-Management-based-on-Kaltura

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

PHP dashboardUtilsの例