public function test_set_time()
{
$a = new \DateTime();
$a->setTime(1, 1);
$b = new ActiveRecord\DateTime();
$b->setTime(1, 1);
$this->assert_datetime_equals($a, $b);
}
/**
* setups db using activerecord
*/
public static function PRE_init_db()
{
# init activerecord configs
\ActiveRecord\Config::initialize(function ($cfg) {
# fetching db related configurations
$dbcfg = \zinux\kernel\application\config::GetConfig("idisqus.db");
# setting connection string
$cfg->set_connections(array(\application\dbBootstrap::MODE_TORATAN => "{$dbcfg["type"]}://{$dbcfg["username"]}:{$dbcfg["password"]}@{$dbcfg["host"]}/{$dbcfg["name"]}?charset=utf8"));
# enable the connection string as to \application\dbBootstrap::MODE_TORATAN
$cfg->set_default_connection(\application\dbBootstrap::MODE_TORATAN);
});
# set default datetime format
\ActiveRecord\DateTime::$DEFAULT_FORMAT = "iso8601";
# testing db connection
\ActiveRecord\Connection::instance();
# if we reach here we are all OK
}
public function testFindByDatetime()
{
$now = new DateTime();
$arnow = new ActiveRecord\DateTime();
$arnow->setTimestamp($now->getTimestamp());
Author::find(1)->updateAttribute('created_at', $now);
$this->assertNotNull(Author::findByCreatedAt($now));
$this->assertNotNull(Author::findByCreatedAt($arnow));
}
public function test_find_by_datetime()
{
$now = new DateTime();
$arnow = new ActiveRecord\DateTime();
$arnow->setTimestamp($now->getTimestamp());
Author::find(1)->update_attribute('created_at', $now);
$this->assert_not_null(Author::find_by_created_at($now));
$this->assert_not_null(Author::find_by_created_at($arnow));
}
<?php
require "connect_func.php";
$limiteDias = new ActiveRecord\DateTime(date('Y-m-d H:i:s', strtotime('-7 days')));
$hoje = new ActiveRecord\DateTime(date('Y-m-d H:i:s'));
$saida = array();
$lista = array();
$erros = array();
// erros
$erros['id'] = 'Erro de acesso. Id não forneceido';
$erros['vazio'] = 'No momento não há pedidos de orçamento ativos para sua empresa em nossos sistemas.';
if (isset($_POST['id'])) {
// $listaPedidos = orcaenviado::find_all_by_parceiros_id($_POST['id'], array('order' => 'data_mudanca desc'));
$listaPedidos = orcaenviado::find_all_by_parceiros_id($_POST['id'], array('order' => 'orcamentos_id desc'));
if (count($listaPedidos) > 0) {
foreach ($listaPedidos as $p) {
// verifica os pedidos dentro do limite de dias estabelecido
$diasPassados = $limiteDias->diff($p->data_mudanca);
if ($diasPassados->invert == 0) {
$pedido = array();
$cidadeO = cidade::find_by_id($p->orcamento->cidade_origem);
$cidadeD = cidade::find_by_id($p->orcamento->cidade_destino);
$estadoO = estado::find_by_id($p->orcamento->uf_origem);
$estadoD = estado::find_by_id($p->orcamento->uf_destino);
$pedido['id'] = $p->orcamentos_id;
$pedido['pedido'] = $p->orcamento->pedido;
$pedido['data'] = $p->orcamento->data_registro;
$pedido['origem'] = $cidadeO->cidade . '/' . $estadoO->uf;
$pedido['destino'] = $cidadeD->cidade . '/' . $estadoD->uf;
$pedido['data_muda'] = $p->data_mudanca;
$pedido['visivel'] = -1;
<?php
header('Content-Type: text/html; charset=utf-8');
define('PATH_LIBS', $_SERVER['DOCUMENT_ROOT'] . '/../libs/');
define('SERVER_DIR', $_SERVER['DOCUMENT_ROOT'] . '/../');
require PATH_LIBS . 'flight/Flight.php';
error_reporting(E_ERROR);
require PATH_LIBS . 'phpactiverecord/ActiveRecord.php';
ActiveRecord\Config::initialize(function ($cfg) {
$cfg->set_model_directory($_SERVER['DOCUMENT_ROOT'] . '/../app/Models');
$cfg->set_connections(array('development' => 'mysql://*****:*****@localhost/vzapertiru_quest?charset=utf8'));
});
ActiveRecord\Connection::$datetime_format = 'Y-m-d';
ActiveRecord\Connection::$date_format = 'Y.m.d';
ActiveRecord\Serialization::$DATETIME_FORMAT = 'Y-m-d';
ActiveRecord\DateTime::$DEFAULT_FORMAT = 'Y-m-d';
Flight::set('flight.views.path', SERVER_DIR . 'view/template/');
require $_SERVER['DOCUMENT_ROOT'] . '/../config/classes.php';
Auth::getInstance()->init();
require SERVER_DIR . 'config/routes.php';
Flight::start();
public function test_find_by_datetime()
{
if (getenv('TRAVIS')) {
$this->markTestSkipped('The Travis CI environment seems to screw this up for unknonwn reasons; ' . 'see Github #298 (https://github.com/kla/php-activerecord/issues/298)');
}
$now = new DateTime();
$arnow = new ActiveRecord\DateTime();
$arnow->setTimestamp($now->getTimestamp());
Author::find(1)->update_attribute('created_at', $now);
$this->assert_not_null(Author::find_by_created_at($now));
$this->assert_not_null(Author::find_by_created_at($arnow));
}
<?php
/**active record setup
* exemplo sqlite
* 'sqlite' => 'sqlite://my_database.db',
*
*/
$cfg = ActiveRecord\Config::instance();
$cfg->set_model_directory('models');
$cfg->set_connections(array('development' => 'mysql://root:@localhost/development_db', 'test' => 'mysql://*****:*****@localhost/test_database_name', 'production' => 'mysql://*****:*****@localhost/production_database_name'));
//Não muito necesaria
ActiveRecord\DateTime::$DEFAULT_FORMAT = 'd-m-Y';
#d-m-Y short
ActiveRecord\DateTime::$FORMATS['awesome_format'] = 'H:i:s m/d/Y';
<?php
include '../../inc/init.inc';
if ($id && Activity::exists($id)) {
$activity = Activity::find($id);
} else {
$res->load('activities', array('error' => "4xx"));
}
$diff1 = $activity->start->diff($activity->end);
$now = new ActiveRecord\DateTime();
$diff2 = $now->diff($activity->end);
$is_end = $activity->end->getTimestamp() - $now->getTimestamp() > 0 ? false : true;
if ($diff2->days == 0 || $diff1->days == 0) {
$res->diff = $is_end ? 100 : 99;
} else {
$res->diff = round(($diff1->days - $diff2->days) / $diff1->days * 100, 0, PHP_ROUND_HALF_DOWN);
}
$res->is_end = $is_end;
switch ($activity->status) {
case 2:
$res->status_bar = "success";
$res->is_end = true;
$res->diff = 100;
break;
case 1:
$res->status_bar = "-striped progress-info";
break;
default:
$res->status_bar = "info";
break;
}
