function executeActividadesPorDocente()
{
$this->id_docente = $this->getRequestParameter('id');
$this->docente = DocentePeer::RetrieveByPK($this->id_docente);
if (!$this->docente) {
$this->forward404();
}
$c = new Criteria();
$c->Add(RelAnioActividadDocentePeer::FK_DOCENTE_ID, $this->docente->getId());
$this->actividades = RelAnioActividadDocentePeer::doSelect($c);
}
/**
* Will investigate a single entry
*/
public function execute()
{
$partial = $this->getP("partial");
$this->widget = null;
$this->forceSystemAuthentication();
// myDbHelper::$use_alternative_con = null;
myDbHelper::$use_alternative_con = myDbHelper::DB_HELPER_CONN_PROPEL2;
// dont' filter out anything
entryPeer::setUseCriteriaFilter(false);
$partner_id = $this->getP("partner_id");
$this->entries = $this->widget_id = null;
$this->count = 0;
$this->page = $this->getP("page", 0);
$this->page_size = $this->getP("page_size", 25);
$this->ready_only = $this->getP("ready_only", 0);
$this->gte_int_id = $this->getP("gte_int_id", null);
$this->widget_id = $this->getP("widget_id");
$this->ui_conf_id = $this->getP("ui_conf_id");
$this->is_playlist = $this->getP("is_playlist");
$this->playlist_id = $this->getP("playlist_id");
$offset = $this->page * $this->page_size;
if ($partner_id !== null) {
$c = new Criteria();
if ($partner_id != "ALL") {
// is is a special backdoor word for viewing all partners
$c->add(entryPeer::PARTNER_ID, $partner_id);
}
if ($this->ready_only) {
$c->add(entryPeer::STATUS, 2);
}
if ($entry_ids = $this->getP("entry_ids")) {
$entry_id_arr = explode(",", $entry_ids);
$c->Add(entryPeer::ID, $entry_id_arr, Criteria::IN);
}
$search_text = $this->getP("filter__like_search_text");
if ($search_text) {
$c->add(entryPeer::SEARCH_TEXT, "%{$search_text}%", Criteria::LIKE);
}
if ($this->gte_int_id) {
$c->add(entryPeer::INT_ID, $this->gte_int_id, Criteria::GREATER_EQUAL);
}
if ($this->getP("filter__in_type_all")) {
} else {
$media_type_arr = array($this->getP("filter__in_type_1"), $this->getP("filter__in_type_2"), $this->getP("filter__in_type_5"), $this->getP("filter__in_type_6"));
$c->add(entryPeer::MEDIA_TYPE, $media_type_arr, Criteria::IN);
}
if ($this->getP("filter__in_status_all")) {
} else {
$status_arr = array($this->getP("filter__in_type_0"), $this->getP("filter__in_type_1"), $this->getP("filter__in_type_2"), $this->getP("filter__in_type_3"), $this->getP("filter__in_type_6"));
if ($this->getP("filter__in_status_err")) {
$status_arr[] = -1;
$status_arr[] = -2;
}
$c->add(entryPeer::STATUS, $status_arr, Criteria::IN);
}
if ($this->getP("filter__gte_created_at")) {
$c->addAnd(entryPeer::CREATED_AT, $this->getP("filter__gte_created_at"), Criteria::GREATER_EQUAL);
}
if ($this->getP("filter__lte_created_at")) {
$to_date = $this->getP("filter__lte_created_at");
$timeStamp = strtotime($to_date);
$timeStamp += 24 * 60 * 60;
// inc one day
$to_date_str = date("Y-m-d", $timeStamp);
$c->addAnd(entryPeer::CREATED_AT, $to_date_str, Criteria::LESS_EQUAL);
}
$this->count = entryPeer::doCount($c);
$c->addAscendingOrderByColumn(entryPeer::INT_ID);
$c->setLimit($this->page_size);
$c->setOffset($offset);
$this->entries = entryPeer::doSelect($c);
if (!$partial) {
// no need for widget if displaying partial page
$d = new Criteria();
$d->add(widgetPeer::PARTNER_ID, $partner_id);
if ($this->widget_id) {
$d->add(widgetPeer::ID, $this->widget_id);
} else {
$d->add(widgetPeer::SOURCE_WIDGET_ID, "");
}
$this->widget = widgetPeer::doSelectOne($d);
if (!$this->widget) {
$d = new Criteria();
$d->add(widgetPeer::PARTNER_ID, $partner_id);
$d->addAscendingOrderByColumn(widgetPeer::CREATED_AT);
$this->widget = widgetPeer::doSelectOne($d);
}
}
}
if ($this->entries == null) {
$this->entries = array();
}
$this->partner_id = $partner_id;
if ($partial) {
return "PartialSuccess";
}
}
define('SF_DEBUG', true);
require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php';
sfContext::getInstance();
print "Fetching data... \n";
$c = new Criteria();
$c->setOffset(959);
$c->setLimit(31);
$politici = OppSenatoriPeer::doSelect($c);
$count = 1;
foreach ($politici as $politico) {
echo "id openpolis: " . $politico->getOpId() . "\n";
$c1 = new Criteria();
$c1->Add(OppParlamentariVotazioniPeer::ID_PARLAMENTARE, $politico->getId(), Criteria::EQUAL);
$votazioni_politico = OppParlamentariVotazioniPeer::doSelect($c1);
foreach ($votazioni_politico as $votazione_politico) {
$c2 = new Criteria();
$c2->Add(OppVotazioneHasPoliticoPeer::POLITICO_ID, $politico->getOpId());
$c2->Add(OppVotazioneHasPoliticoPeer::VOTAZIONE_ID, $votazione_politico->getIdVotazione());
$controllo = OppVotazioneHasPoliticoPeer::doSelect($c2);
if ($controllo == null) {
echo "politico: " . $count . " - votazione: " . $votazione_politico->getIdVotazione() . "\n";
$parlamentare_has_votazione = new OppVotazioneHasPolitico();
$parlamentare_has_votazione->setPoliticoId($politico->getOpId());
$parlamentare_has_votazione->setVotazioneId($votazione_politico->getIdVotazione());
$parlamentare_has_votazione->setVoto($votazione_politico->getVotazione());
$parlamentare_has_votazione->save();
}
}
$count++;
}
print "done.\n";
public function getVotiCount()
{
$c = new Criteria();
$c->addJoin(OppPoliticoPeer::ID, OppCaricaPeer::POLITICO_ID, Criteria::INNER_JOIN);
$c->addJoin(OppCaricaPeer::ID, OppVotazioneHasCaricaPeer::CARICA_ID, Criteria::INNER_JOIN);
$c->Add(OppPoliticoPeer::ID, $this->getId());
return OppVotazioneHasCaricaPeer::doCount($c);
}
