Vous pouvez commenter/noter en utilisant le compte anonymous (mot de passe: anonymous)
You can comment/rate using the anonymous account (password: anonymous).

Snippets taggés : "custom"

par date par popularité » Tout développer / Réduire au titre «

[Propel] Dans un criteria custom faire fi des secondes et minutes pour la comparaison de dates - 133 view(s)

2ere maniere full mysql (donc plus safe)

$criterion->addAnd($c->getNewCriterion(ShopOrderPeer::CREATED_AT, 'DATE('. ShopOrderPeer::CREATED_AT. ')  <= \''. goDate::getMySqlDateFromTs($this->filters['created_at']['to']). '\'', Criteria::CUSTOM)); 
$criterion->addAnd($c->getNewCriterion(ShopOrderPeer::CREATED_AT, 'DATE('. ShopOrderPeer::CREATED_AT. ')  <= DATE(FROM_UNIXTIME('. $this->filters['created_at']['to']. '))', Criteria::CUSTOM));

par COil le 2008-09-29, taggé : criteria criterion custom date mysql propel timestamp

(1 commentaire)

[Propel] Recherche like sur un champs de type integer - 110 view(s)

$c->add(self::EAN13, self::EAN13 .' LIKE \'%'. $ean. '%\'', Criteria::CUSTOM);

par COil le 2008-09-29, taggé : criteria custom integer propel

(1 commentaire)

[Propel] Faire une fonction custom de join - 143 view(s)

public static function doSelectJoinUserAndStateAndCountry(Criteria $c, $con = null) {
$c = clone $c;
 
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
 
MemberPeer::addSelectColumns($c);
$startcol2 = (MemberPeer::NUM_COLUMNS - MemberPeer::NUM_LAZY_LOAD_COLUMNS) + 1;
 
UserPeer::addSelectColumns($c);
$startcol3 = $startcol2 + UserPeer::NUM_COLUMNS ;
 
CountryPeer::addSelectColumns($c);
$startcol4 = $startcol3 + CountryPeer::NUM_COLUMNS ;
 
StatePeer::addSelectColumns($c);
CountryPeer::addSelectColumns($c);
 
 
$c->addJoin(MemberPeer::USER_ID, UserPeer::ID);
$c->addJoin(MemberPeer::STATE_ID, StatePeer::ID);
$c->addJoin(MemberPeer::COUNTRY_ID, CountryPeer::ID);
 
 
$rs = BasePeer::doSelect($c, $con);
$results = array();
 
while($rs->next())
{
$omClass = MemberPeer::getOMClass();
 
$cls = Propel::import($omClass);
$obj1 = new $cls();
$obj1->hydrate($rs);
 
$omClass = UserPeer::getOMClass();
 
$cls = Propel::import($omClass);
$obj2 = new $cls();
$obj2->hydrate($rs, $startcol2);
 
$omClass = StatePeer::getOMClass();
 
$cls = Propel::import($omClass);
$obj3 = new $cls();
$obj3->hydrate($rs, $startcol3);
 
$omClass = CountryPeer::getOMClass();
 
$cls = Propel::import($omClass);
$obj4 = new $cls();
$obj4->hydrate($rs, $startcol4);
 
$obj1->setUser($obj2);
$obj1->setState($obj3);
$obj1->setState($obj4);
$results[] = $obj1;
}
 
return $results;
}

par COil le 2008-09-29, taggé : custom hydrate import join mysql propel

(1 commentaire)

[Propel] Comparaison de dates avec un custom criteria - 109 view(s)

// Recuperation de la liste des commandes
switch ($type_batch) {
    case TYPE_BATCH_7H:
        $start_time = mktime(10, 0, 0, date("m")  , date("d")-1, date("Y"));
        $end_time = mktime(7, 0, 0, date("m")  , date("d"), date("Y"));
    break;
 
    case TYPE_BATCH_10H:
        $start_time = mktime(7, 0, 0, date("m")  , date("d"), date("Y"));
        $end_time = mktime(10, 0, 0, date("m")  , date("d"), date("Y"));
    break;
}
 
 
$c = new Criteria();
$c->add(ExcommandesPeer::ISVALIDE, 1);
$c->add(ExcommandesPeer::DATECOMMANDE, ExcommandesPeer::DATECOMMANDE. '> \''. myDate::getMySqlDateTimeFromTs($start_time). '\'', Criteria::CUSTOM);
$c->addAnd(ExcommandesPeer::DATECOMMANDE, ExcommandesPeer::DATECOMMANDE. '< \''. myDate::getMySqlDateTimeFromTs($end_time). '\'', Criteria::CUSTOM);        
$details_commandes = ExdetailscommandesPeer::doSelectJoinExcommandes($c);