Créer un compte ou loggez-vous pour pouvoir ajouter, commenter et noter les snippets.

Navigation

Tags relatifs

my Symfony Plugins

Plugins demos


My bookmarks

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 : "date custom" Snippets taggés : "date custom"

[Propel] Dans un criteria custom faire fi des secondes et minutes pour la comparaison de dates - 159 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] Comparaison de dates avec un custom criteria - 129 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);
 
par COil le 2008-09-28, taggé : criteria  custom  date  propel 
Debug toolbar