PHP uiConfPeer::doSelect方法代码示例

 public function execute()
 {
     $this->forceSystemAuthentication();
     myDbHelper::$use_alternative_con = null;
     $partnerId = $this->getRequestParameter("partnerId", null);
     if ($partnerId !== null) {
         $partnerId = (int) $partnerId;
     }
     $c = new Criteria();
     $c->add(uiConfPeer::PARTNER_ID, $partnerId);
     $c->addDescendingOrderByColumn(uiConfPeer::CREATED_AT);
     $this->uiconfs = uiConfPeer::doSelect($c);
     $partner = PartnerPeer::retrieveByPK($partnerId);
     $this->partner = $partner;
     $this->partnerId = $partnerId;
 }

 public function executeImpl($partner_id, $subp_id, $puser_id, $partner_prefix, $puser_kuser)
 {
     $this->applyPartnerFilterForClass('uiConf', $partner_id);
     $detailed = $this->getP("detailed", false);
     $detailed_fields = $this->getP("detailed_fields");
     $limit = $this->getP("page_size", 10);
     $limit = $this->maxPageSize($limit);
     $page = $this->getP("page", 1);
     $offset = ($page - 1) * $limit;
     $c = new Criteria();
     // filter
     $filter = new uiConfFilter();
     $fields_set = $filter->fillObjectFromRequest($this->getInputParams(), "filter_", null);
     $this->setExtraFilters($filter);
     $filter->attachToCriteria($c);
     $count = uiConfPeer::doCount($c);
     if ($count > 0) {
         $offset = ($page - 1) * $limit;
         $c->setLimit($limit);
         if ($offset > 0) {
             $c->setOffset($offset);
         }
         $list = uiConfPeer::doSelect($c);
         $level = $detailed ? objectWrapperBase::DETAIL_LEVEL_DETAILED : objectWrapperBase::DETAIL_LEVEL_REGULAR;
     } else {
         // no need to query the data - there is none !
         $list = array();
         $level = objectWrapperBase::DETAIL_LEVEL_REGULAR;
     }
     $this->addMsg("count", $count);
     $this->addMsg("page_size", $limit);
     $this->addMsg("page", $page);
     foreach ($list as $listed_uiConf) {
         if (!$listed_uiConf->isValid()) {
             $this->addError(APIErrors::INTERNAL_SERVERL_ERROR, "uiConf object [{$listed_uiConf->getId()}] is not valid");
             return;
         }
     }
     if ($detailed_fields) {
         $extra_fields = explode(",", $detailed_fields);
         $wrapper = objectWrapperBase::getWrapperClass($list, $level, objectWrapperBase::DETAIL_VELOCITY_DEFAULT, 0, $extra_fields);
     } else {
         $wrapper = objectWrapperBase::getWrapperClass($list, $level);
     }
     $this->addMsg($this->getObjectPrefix(), $wrapper);
 }

 /**
  * Retrieve a list of available UIConfs  with no partner limitation
  * 
  * @action list
  * @param KalturaUiConfFilter $filter
  * @param KalturaFilterPager $pager
  * @return KalturaUiConfAdminListResponse
  */
 function listAction(KalturaUiConfFilter $filter = null, KalturaFilterPager $pager = null)
 {
     myDbHelper::$use_alternative_con = myDbHelper::DB_HELPER_CONN_PROPEL2;
     if (!$filter) {
         $filter = new KalturaUiConfFilter();
     }
     $uiConfFilter = new uiConfFilter();
     $filter->toObject($uiConfFilter);
     $c = new Criteria();
     $uiConfFilter->attachToCriteria($c);
     $count = uiConfPeer::doCount($c);
     if ($pager) {
         $pager->attachToCriteria($c);
     }
     $list = uiConfPeer::doSelect($c);
     $newList = KalturaUiConfAdminArray::fromUiConfAdminArray($list);
     $response = new KalturaUiConfAdminListResponse();
     $response->objects = $newList;
     $response->totalCount = $count;
     return $response;
 }

 <?php 
ini_set("memory_limit", "256M");
require_once __DIR__ . '/bootstrap.php';
if (!$argc) {
    die('pleas provide partner id as input' . PHP_EOL . 'to run script: ' . basename(__FILE__) . ' X' . PHP_EOL . 'whereas X is partner id' . PHP_EOL);
}
$partnerId = $argv[0];
$dbConf = kConf::getDB();
DbManager::setConfig($dbConf);
DbManager::initialize();
$c = new Criteria();
$c->add(uiConfPeer::SWF_URL, "%kcw%", Criteria::LIKE);
$c->add(uiConfPeer::OBJ_TYPE, uiConf::UI_CONF_TYPE_CW, Criteria::EQUAL);
$c->add(uiConfPeer::PARTNER_ID, $partnerId, Criteria::EQUAL);
$kcwUiconfs = uiConfPeer::doSelect($c);
if (!count($kcwUiconfs)) {
    exit;
}
$fileName = "/manual_uiconfs_paths.log";
$flog = fopen($fileName, 'a+');
//Run a loop for each uiConf to get its filesync key, thus acquiring its confile
foreach ($kcwUiconfs as $kcwUiconf) {
    /* @var $kcwUiconf uiConf */
    $kcwUiconfFilesyncKey = $kcwUiconf->getSyncKey(uiConf::FILE_SYNC_UICONF_SUB_TYPE_DATA);
    $kcwConfile = kFileSyncUtils::file_get_contents($kcwUiconfFilesyncKey, false, false);
    if (!$kcwConfile) {
        continue;
    }
    $kcwConfileXML = new SimpleXMLElement($kcwConfile);
    $path = '//provider[@id="kaltura" or @name="kaltura"]';
    $nodesToRemove = $kcwConfileXML->xpath($path);

 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(uiConfPeer::DATABASE_NAME);
         $criteria->add(uiConfPeer::ID, $pks, Criteria::IN);
         $objs = uiConfPeer::doSelect($criteria, $con);
     }
     return $objs;
 }

 public static function copyUiConfsByType(Partner $fromPartner, Partner $toPartner, $uiConfType)
 {
     KalturaLog::log("Copying uiconfs from partner [" . $fromPartner->getId() . "] to partner [" . $toPartner->getId() . "] with type [" . $uiConfType . "]");
     uiConfPeer::setUseCriteriaFilter(false);
     $c = new Criteria();
     $c->addAnd(uiConfPeer::PARTNER_ID, $fromPartner->getId());
     $c->addAnd(uiConfPeer::OBJ_TYPE, $uiConfType);
     $c->addAnd(uiConfPeer::STATUS, uiConf::UI_CONF_STATUS_READY);
     $uiConfs = uiConfPeer::doSelect($c);
     uiConfPeer::setUseCriteriaFilter(true);
     foreach ($uiConfs as $uiConf) {
         // create a new uiConf, set its partner Id (so that upcoming file_sync will have the new partner's id)
         // and clone fileds from current uiConf
         $newUiConf = new uiConf();
         $newUiConf->setPartnerId($toPartner->getId());
         $newUiConf = $uiConf->cloneToNew($newUiConf);
         $newUiConf->save();
         KalturaLog::log("UIConf [" . $newUiConf->getId() . "] was created");
     }
 }

 private function getUiconfList($tag = 'player')
 {
     $template_partner_id = isset($this->templatePartnerId) ? $this->templatePartnerId : 0;
     $c = new Criteria();
     $crit_partner = $c->getNewCriterion(uiConfPeer::PARTNER_ID, $this->partner_id);
     $crit_default = $c->getNewCriterion(uiConfPeer::DISPLAY_IN_SEARCH, mySearchUtils::DISPLAY_IN_SEARCH_KALTURA_NETWORK, Criteria::GREATER_EQUAL);
     $crit_default_partner_id = $c->getNewCriterion(uiConfPeer::PARTNER_ID, $template_partner_id);
     $crit_default_swf_url = $c->getNewCriterion(uiConfPeer::SWF_URL, '%/kdp3/%kdp3.swf', Criteria::LIKE);
     $crit_default->addAnd($crit_default_partner_id);
     $crit_default->addAnd($crit_default_swf_url);
     $crit_partner->addOr($crit_default);
     $c->add($crit_partner);
     $c->addAnd(uiConfPeer::OBJ_TYPE, array(uiConf::UI_CONF_TYPE_WIDGET, uiConf::UI_CONF_TYPE_KDP3), Criteria::IN);
     $c->addAnd(uiConfPeer::STATUS, uiConf::UI_CONF_STATUS_READY);
     $c->addAnd(uiConfPeer::TAGS, '%' . $tag . '%', Criteria::LIKE);
     $c->addAnd(uiConfPeer::TAGS, '%jw' . $tag . '%', Criteria::NOT_LIKE);
     $c->addAnd(uiConfPeer::ID, array(48120, 48121, 48130, 48131, 48132, 48133, 48134, 48135), Criteria::NOT_IN);
     $order_by = "(" . uiConfPeer::PARTNER_ID . "=" . intval($this->partner_id) . ")";
     $c->addAscendingOrderByColumn($order_by);
     $c->addDescendingOrderByColumn(uiConfPeer::CREATED_AT);
     $confs = uiConfPeer::doSelect($c);
     return $confs;
 }

 /**
  * 
  * Gets all the kmc ui confs
  * @param string $module_tag
  * @param string $module_version
  * @param int $template_partner_id
  */
 public static function getAllKMCUiconfs($module_tag, $module_version, $template_partner_id)
 {
     $c = new Criteria();
     $c->addAnd(uiConfPeer::PARTNER_ID, $template_partner_id);
     //		$c->addAnd(uiConfPeer::TAGS, "%".$module_tag."\_".$module_version."%", Criteria::LIKE); // no need to check for the kmc version
     $c->addAnd(uiConfPeer::TAGS, "%autodeploy%", Criteria::LIKE);
     return uiConfPeer::doSelect($c);
 }

 public static function getSilverLightPlayerUiConfs($tag)
 {
     $confs = array();
     // implement query to get uiconfs from DB
     $c = new Criteria();
     $c->addAnd(uiConfPeer::DISPLAY_IN_SEARCH, mySearchUtils::DISPLAY_IN_SEARCH_KALTURA_NETWORK, Criteria::GREATER_EQUAL);
     $c->addAnd(uiConfPeer::STATUS, uiConf::UI_CONF_STATUS_READY);
     $c->addAnd(uiConfPeer::OBJ_TYPE, uiConf::UI_CONF_TYPE_SLP);
     $c->addAnd(uiConfPeer::TAGS, $tag, Criteria::LIKE);
     $c->addAscendingOrderByColumn(uiConfPeer::ID);
     $slPlayers = uiConfPeer::doSelect($c);
     $conf_players = array();
     foreach ($slPlayers as $conf) {
         $minRuntimeVersion = '';
         $custom_data = unserialize($conf->getCustomData());
         if ($custom_data) {
             $minRuntimeVersion = $custom_data['minRuntimeVersion'];
         }
         $conf_players[] = array('id' => $conf->getId(), 'name' => $conf->getName(), 'width' => $conf->getWidth() ? $conf->getWidth() : 470, 'height' => $conf->getHeight() ? $conf->getHeight() : 600, 'minRuntimeVersion' => $minRuntimeVersion, 'swfUrlVersion' => self::getSlpUrlVersion($conf));
     }
     return $conf_players;
 }