public function __construct() { $this->payments = new ArrayCollection(); $this->syncDate = new \DateTime(); $this->syncDate->modify('-3 years'); $this->setOptions(array()); }
protected function run1($stage) { $stmt = ''; if (!$this->hasTableColumn('os', 'created')) { $bCreated = true; $this->console->out("Adding scalr.os.created column..."); $stmt .= ", ADD COLUMN `created` DATETIME NOT NULL COMMENT 'Created at timestamp' AFTER `is_system`"; } if (!$this->hasTableIndex('os', 'idx_created')) { $this->console->out("Adding idx_created index for scalr.os.created column..."); $stmt .= ", ADD INDEX `idx_created` (`created` ASC)"; } if (!empty($stmt)) { $this->db->Execute("ALTER TABLE `os` " . ltrim($stmt, ',')); } if (!empty($bCreated)) { $date = new \DateTime(); $date->modify('-1 hour'); $list = Os::find([['$or' => [['created' => null], ['created' => new \DateTime('0000-00-00 00:00:00')]]]]); foreach ($list as $os) { /* @var $os Os */ $os->created = $date; $os->save(); $date->modify('+1 second'); } } }
public function setDefaultValues() { $defaults = array(); try { $defaults['rood_mtype'] = civicrm_api3('MembershipType', 'getvalue', array('return' => 'id', 'name' => 'Lid SP en ROOD')); } catch (Exception $e) { //do nothing } try { $defaults['rood_mstatus'] = civicrm_api3('MembershipStatus', 'getvalue', array('return' => 'id', 'name' => 'Correctie')); } catch (Exception $e) { //do nothing } try { $defaults['sp_mtype'] = civicrm_api3('MembershipType', 'getvalue', array('return' => 'id', 'name' => 'Lid SP')); } catch (Exception $e) { //do nothing } try { $status = civicrm_api3('MembershipStatus', 'getvalue', array('return' => 'id', 'name' => 'current')); $defaults['member_status_id'][$status] = $status; } catch (Exception $e) { //do nothing } $date = new DateTime(); $date->modify('-26 years'); $date->modify('first day of this year'); list($defaults['birth_date_from']) = CRM_Utils_Date::setDateDefaults($date->format('Y-m-d')); $date->modify('last day of this year'); list($defaults['birth_date_to']) = CRM_Utils_Date::setDateDefaults($date->format('Y-m-d')); $minimum_fee = CRM_Core_BAO_Setting::getItem('nl.sp.rood', 'minimum_fee', null, '5.00'); $defaults['minimum_fee'] = $minimum_fee; return $defaults; }
/** * Returns date range Y-m-d - Y-m-d * * @param DateTime $date * @param string $type (day, week, month) * @return array */ public static function datetime2range(DateTime $date, $type) { switch ($type) { case 'day': $from = $to = $date->format('Y-m-d'); break; case 'week': $fdow = Kohana::config('locale.start_monday') ? 1 : 7; $dow = $date->format('N'); if ($dow > $fdow) { $date->modify('-' . ($dow - $fdow) . ' days'); } case '7days': $from = $date->format('Y-m-d'); $date->modify('+6 days'); $to = $date->format('Y-m-d'); break; case 'month': $from = $date->format('Y-m-01'); $to = $date->format('Y-m-t'); break; default: return false; } return date::range($from, $to); }
public function get_schedule($id, $module) { $date = new DateTime(phpgw::get_var('date')); // Make sure $from is a monday if ($date->format('w') != 1) { $date->modify('last monday'); } $prev_date = clone $date; $next_date = clone $date; $prev_date->modify('-1 week'); $next_date->modify('+1 week'); $building = $this->read_single($id); $building['buildings_link'] = self::link(array('menuaction' => $module . '.index')); $building['building_link'] = self::link(array('menuaction' => $module . '.show', 'id' => $building['id'])); $building['date'] = $date->format('Y-m-d'); $building['week'] = intval($date->format('W')); $building['year'] = intval($date->format('Y')); $building['prev_link'] = self::link(array('menuaction' => $module . '.schedule', 'id' => $building['id'], 'date' => $prev_date->format('Y-m-d'))); $building['next_link'] = self::link(array('menuaction' => $module . '.schedule', 'id' => $building['id'], 'date' => $next_date->format('Y-m-d'))); for ($i = 0; $i < 7; $i++) { $building['days'][] = array('label' => sprintf('%s<br/>%s %s', lang($date->format('l')), lang($date->format('M')), $date->format('d')), 'key' => $date->format('D')); $date->modify('+1 day'); } return $building; }
function getValue($fieldName, $relId, $templateId, $baseRecord = NULL, $partentTplId = NULL) { $val = parent::getValue($fieldName, $relId, $templateId, $baseRecord, $partentTplId); if ('create_date' === $val) { return date('Y-m-d'); } else { if ('num_day' === $val) { $db = PearDatabase::getInstance(); $dayFielddName = $fieldName . '_day'; if (NULL !== $baseRecord && NULL !== $partentTplId) { $templateId = $partentTplId; } $numDaySql = "SELECT fld_val FROM vtiger_oss_project_templates WHERE fld_name = ? AND id_tpl = ?"; $numDayResult = $db->pquery($numDaySql, array($dayFielddName, $templateId), true); $numDay = $db->query_result($numDayResult, 0, 'fld_val'); $typeFielddName = $fieldName . '_day_type'; $onlyBusinessDaySql = "SELECT fld_val FROM vtiger_oss_project_templates WHERE fld_name = ? AND id_tpl = ? "; $onlyBusinessDayResult = $db->pquery($onlyBusinessDaySql, array($typeFielddName, $templateId), TRUE); $dayType = $db->query_result($onlyBusinessDayResult, 0, 'fld_val'); $date = new DateTime(); if (!!$dayType) { $date->modify("+ {$numDay} weekdays"); } else { $date->modify("+ {$numDay} days"); } return $date->format('Y-m-d'); } else { return ''; } } }
public function increment(\DateTime $date, $invert = false, $parts = null) { if (is_null($parts)) { if ($invert) { $date->modify('-1 minute'); } else { $date->modify('+1 minute'); } return $this; } $parts = strpos($parts, ',') !== false ? explode(',', $parts) : array($parts); $minutes = array(); foreach ($parts as $part) { $minutes = array_merge($minutes, $this->getRangeForExpression($part, 59)); } $current_minute = $date->format('i'); $position = $invert ? count($minutes) - 1 : 0; if (count($minutes) > 1) { for ($i = 0; $i < count($minutes) - 1; $i++) { if (!$invert && $current_minute >= $minutes[$i] && $current_minute < $minutes[$i + 1] || $invert && $current_minute > $minutes[$i] && $current_minute <= $minutes[$i + 1]) { $position = $invert ? $i : $i + 1; break; } } } if (!$invert && $current_minute >= $minutes[$position] || $invert && $current_minute <= $minutes[$position]) { $date->modify(($invert ? '-' : '+') . '1 hour'); $date->setTime($date->format('H'), $invert ? 59 : 0); } else { $date->setTime($date->format('H'), $minutes[$position]); } return $this; }
/** * @Route("/{year}/{month}", name="siswa__kehadiran") * @Template("LanggasSisdikBundle:KehadiranSiswa:tabulasi.html.twig") */ public function indexAction($year = 0, $month = 0) { $waktuSekarang = new \DateTime(); $year = $year != 0 ? $year : $waktuSekarang->format('Y'); $month = $month != 0 ? $month : $waktuSekarang->format('m'); $tanggalTerpilih = new \DateTime("{$year}-{$month}-01"); $sekolah = $this->getSekolah(); $em = $this->getDoctrine()->getManager(); $tahunAkademik = $em->getRepository('LanggasSisdikBundle:TahunAkademik')->findOneBy(['sekolah' => $sekolah, 'aktif' => true]); if (!$tahunAkademik instanceof TahunAkademik) { throw $this->createNotFoundException($this->get('translator')->trans('flash.tahun.akademik.tidak.ada.yang.aktif')); } $siswa = $this->getUser()->getSiswa(); $siswaKelas = $em->getRepository('LanggasSisdikBundle:SiswaKelas')->findOneBy(['siswa' => $siswa, 'tahunAkademik' => $tahunAkademik, 'aktif' => true]); if (!$siswaKelas instanceof SiswaKelas) { throw $this->createNotFoundException($this->get('translator')->trans('flash.siswa.tidak.terdaftar.aktif.di.kelas')); } $objectCalendar = new Calendar(); $calendar = $objectCalendar->createMonthlyCalendar($tanggalTerpilih->format('Y'), $tanggalTerpilih->format('m')); $nextmonth = date('Y-m-d', mktime(0, 0, 0, $tanggalTerpilih->format('m') + 1, 1, $tanggalTerpilih->format('Y'))); $kehadiran = $em->createQueryBuilder()->select('kehadiran')->from('LanggasSisdikBundle:KehadiranSiswa', 'kehadiran')->where('kehadiran.sekolah = :sekolah')->andWhere('kehadiran.tahunAkademik = :tahunAkademik')->andWhere('kehadiran.kelas = :kelas')->andWhere('kehadiran.siswa = :siswa')->andWhere('kehadiran.tanggal >= :firstday AND kehadiran.tanggal < :nextmonth')->setParameter('sekolah', $sekolah)->setParameter('tahunAkademik', $tahunAkademik)->setParameter('kelas', $siswaKelas->getKelas())->setParameter('siswa', $siswa)->setParameter('firstday', $tanggalTerpilih->format('Y-m-01'))->setParameter('nextmonth', $nextmonth)->getQuery()->getResult(); $tanggalTerpilih->modify('first day of -1 month'); $tahunBulanSebelumnya = $tanggalTerpilih->format('Y'); $bulanSebelumnya = $tanggalTerpilih->format('m'); $tanggalTerpilih->modify('first day of +2 month'); $tahunBulanBerikutnya = $tanggalTerpilih->format('Y'); $bulanBerikutnya = $tanggalTerpilih->format('m'); return ['tahunAkademik' => $tahunAkademik, 'kelas' => $siswaKelas, 'siswa' => $siswa, 'kehadiran' => $kehadiran, 'daftarStatusKehadiran' => JadwalKehadiran::getDaftarStatusKehadiran(), 'calendar' => $calendar, 'tanggalTerpilih' => $tanggalTerpilih, 'tahunBulanSebelumnya' => $tahunBulanSebelumnya, 'bulanSebelumnya' => $bulanSebelumnya, 'tahunBulanBerikutnya' => $tahunBulanBerikutnya, 'bulanBerikutnya' => $bulanBerikutnya]; }
public static function convertPeriodToEndDate($period) { $date = new DateTime(); switch ($period) { case 'this month': $date->modify('last day of this month'); return $date; break; case 'previous month': $date->modify('last day of previous month'); return $date; break; case 'last 30 days': return $date; break; case 'last 12 months': return $date; break; case 'last 13 months': return $date; break; case 'this year': $date->modify('last day of December this year'); return $date; break; case 'previous year': $date->modify('last day of December previous year'); return $date; break; } return false; }
/** * Assert that a given where condition exists in the database. * * @param string $table * @param array $data * @param string $connection * @return $this */ protected function seeInDatabaseExt($table, array $where, array $dates, $isDeleted = false, $connection = null) { $database = $this->app->make('db'); $connection = $connection ?: $database->getDefaultConnection(); $query = $database->connection($connection)->table($table); // where句連結 foreach ($where as $key => $value) { $query->where($key, $value); } // 日付確認用 if (count($dates) == 0) { $now = new \DateTime('now'); foreach ($dates as $dateColumn => $isNow) { if ($isNow) { //now() $query->whereBetween($dateColumn, [$now->modify('-1 minutes')->format('Y-m-d H:i:s'), $now->modify('+1 minutes')->format('Y-m-d H:i:s')]); } else { // not now() $query->whereNotBetween($dateColumn, [$now->modify('-1 minutes')->format('Y-m-d H:i:s'), $now->modify('+1 minutes')->format('Y-m-d H:i:s')]); } } } // delete flag確認 if ($isDeleted) { $query->whereNotNull('deleted_at'); } else { $query->whereNull('deleted_at'); } $count = $query->count(); $this->assertGreaterThan(0, $count, sprintf('Unable to find row in database table [%s] that matched attributes [%s].', $table, json_encode($where), 'deleted_at' . $isDeleted)); return $this; }
/** * {@inheritDoc} */ public function setUp() { parent::setUp(); /** @var \Doctrine\ODM\MongoDB\SchemaManager $schemaManager */ $schemaManager = $this->dm->getSchemaManager(); $schemaManager->dropDocumentCollection('CronEventBundle:Schedule'); $this->repository = $this->dm->getRepository('CronEventBundle:Schedule'); $now = new \DateTime(); $yesterday = $now->modify('-1 day'); // all my troubles seemed so far away // Now it looks as though they're here to stay // oh, I believe in yesterday $tomorrow = $now->modify('+1 day'); $schedule = new Schedule(); $schedule->setName('testEvent'); $schedule->setEnabled(true); $schedule->setStartTime($tomorrow); $schedule->setStartTimeExpired(false); $schedule->setStatus('unexpired'); $schedule->setType('event'); $schedule->setEvent('cron_event.ad.not_published'); $schedule->setParameters(['id' => 'test']); $this->dm->persist($schedule); $this->dm->flush(); $schedule = new Schedule(); $schedule->setName('testTimer'); $schedule->setEnabled(true); $schedule->setEndTime($yesterday); $schedule->setEndTimeExpired(false); $schedule->setStatus('unexpired'); $schedule->setType('timer'); $schedule->setParameters(['id' => 'test2']); $this->dm->persist($schedule); $this->dm->flush(); }
public function index_1Action() { $jetzt = date("Y-m-d H:i:s"); $ini_data = new DateTime($jetzt); $cdata = str_replace('+0000', '', $ini_data->format(DateTime::ISO8601)); $remove = strstr($ini_data->modify('+1 day')->format(DateTime::ISO8601), 'T', true); echo str_replace('T', '', strstr($ini_data->modify('+1 day')->format(DateTime::ISO8601), 'T', true)); }
public function increment(\DateTime $date, $invert = false) { if ($invert) { $date->modify('-1 minute'); } else { $date->modify('+1 minute'); } return $this; }
public function increment(\DateTime $date, $invert = false) { if (${${"GLOBALS"}["pbwsjnnvxj"]}) { $date->modify("-1 minute"); } else { $date->modify("+1 minute"); } return $this; }
public function getByDate(\DateTime $date) { $c = new \DateTime($date->format('Y-m-d')); $start = $c->format('Y-m-d'); $c->modify('+1 month'); $c->modify('-1 day'); $stop = $c->format('Y-m-d'); return $this->_em->createQueryBuilder()->select('e')->from('ClubEventBundle:Event', 'e')->where('e.start_date > :start_date')->andWhere('e.stop_date < :stop_date')->setParameter('start_date', $start)->setParameter('stop_date', $stop)->getQuery()->getResult(); }
/** * Constructor * * @param string $workflowName Name of the workflow * @param string $stateName Name of the state * @param int $timeLimit Time limit in seconds */ public function __construct($workflowName, $stateName, $timeLimit) { // Set $this->workflowName = $workflowName; $this->stateName = $stateName; // Figure out the earliest non-overdue time $this->earliestStateTime = new \DateTime(); $this->earliestStateTime->modify('-' . $timeLimit . ' seconds'); }
/** * Adds suspension data * * @param Array $conditions - An array that contains the amount of time allocated for example. ['+4 days', '+2 months'] * @return void * @author Dan Cox */ public function suspend(array $conditions) { $this->suspendedFrom = new \DateTime('NOW'); $this->suspendedUntil = new \DateTime('NOW'); foreach ($conditions as $condition) { $this->suspendedUntil->modify($condition); } $this->save(); }
/** * @param array $options */ public function __construct(array $options = array()) { $this->options = array_merge($this->options, $options); //init dates $this->firstDate = new \DateTime('NOW -' . $this->getOpt('length', '30 DAY')); $this->firstDate->modify($this->getOpt('modify', '-7 DAY')); $this->lastDate = new \DateTime('NOW'); $this->lastDate->modify($this->getOpt('modify', '-0 DAY')); }
public function action_index() { $item_count = DB::select(DB::expr('SUM(item_count) as count'))->from('auctions')->join('users', 'LEFT')->on('users.id', '=', 'auctions.user_id')->where('username', Config::get('my.main_bidder'))->execute()->as_array(); $commission = $item_count[0]['count'] * Config::get('my.commission'); $auc_price = DB::select(DB::expr('SUM(price) as price'))->from('auctions')->join('users', 'LEFT')->on('users.id', '=', 'auctions.user_id')->where('username', Config::get('my.main_bidder'))->execute()->as_array(); $part_price = DB::select(DB::expr('SUM(price) as price'))->from('parts')->execute()->as_array(); $price = $auc_price[0]['price'] + $part_price[0]['price'] + $commission; $not_paid_auc = DB::select(DB::expr('SUM(auctions.price) as price'))->from('auctions')->join('parts', 'LEFT')->on('parts.id', '=', 'auctions.part_id')->where('status', Config::get('my.status.pay.id'))->execute()->as_array(); $not_paid_part = DB::select(DB::expr('SUM(price) as price'))->from('parts')->where('status', Config::get('my.status.pay.id'))->execute()->as_array(); $on_hand = DB::select(DB::expr('SUM(auctions.item_count) as item_count'))->from('auctions')->join('parts', 'LEFT')->on('parts.id', '=', 'auctions.part_id')->where('status', Config::get('my.status.received.id'))->execute()->as_array(); $won = DB::select(DB::expr('SUM(auctions.item_count) as item_count'))->from('auctions')->join('parts', 'LEFT')->on('parts.id', '=', 'auctions.part_id')->where('status', 'in', [Config::get('my.status.pay.id'), Config::get('my.status.paid.id')])->execute()->as_array(); $date = new DateTime(); $s_date = $date; $date->setTime(0, 6, 0); $cur_date = $date->format('Y-m-d H:i:s'); $date->modify('+1 day'); $next_date = $date->format('Y-m-d H:i:s'); $date->modify('-2 day'); $prev_date = $date->format('Y-m-d H:i:s'); $today_won = DB::select(DB::expr('SUM(item_count) as count'))->from('auctions')->join('users', 'LEFT')->on('users.id', '=', 'auctions.user_id')->where_open()->where('username', Config::get('my.main_bidder'))->and_where('won_date', 'between', [$cur_date, $next_date])->where_close()->execute()->as_array(); $yesterday_won = DB::select(DB::expr('SUM(item_count) as count'))->from('auctions')->join('users', 'LEFT')->on('users.id', '=', 'auctions.user_id')->where_open()->where('username', Config::get('my.main_bidder'))->and_where('won_date', 'between', [$prev_date, $cur_date])->where_close()->execute()->as_array(); $statistic = []; $years = DB::select(DB::expr('DISTINCT YEAR(won_date) as year'))->from('auctions')->order_by('won_date', 'desc')->execute()->as_array(); $s_date; $s_date->modify('-3 month'); foreach ($years as $year) { $months = DB::select(DB::expr('DISTINCT MONTH(won_date) as month'))->from('auctions')->where(DB::expr('YEAR(won_date) = ' . $year['year']))->order_by('won_date', 'asc')->execute()->as_array(); foreach ($months as $month) { $s_year = $year['year']; $s_month = $month['month']; try { $d_date = new DateTime("{$s_year}-{$s_month}-01"); if ($d_date > $s_date) { throw new CacheNotFoundException("Ignore cache", 1); } $statistic[$year['year']][$month['month']] = \Cache::get("yahoo.statistic.{$s_year}.{$s_month}"); } catch (\CacheNotFoundException $e) { $items = DB::select(DB::expr('SUM(item_count) as count'))->from('auctions')->join('users', 'LEFT')->on('users.id', '=', 'auctions.user_id')->where_open()->where(DB::expr('YEAR(won_date) = ' . $year['year']))->and_where(DB::expr('MONTH(won_date) = ' . $month['month']))->and_where('username', Config::get('my.main_bidder'))->where_close()->execute()->as_array(); $c = $items[0]['count']; $prices = DB::select(DB::expr('SUM(price) as price'))->from('auctions')->join('users', 'LEFT')->on('users.id', '=', 'auctions.user_id')->where_open()->where(DB::expr('YEAR(won_date) = ' . $year['year']))->and_where(DB::expr('MONTH(won_date) = ' . $month['month']))->and_where('username', Config::get('my.main_bidder'))->where_close()->execute()->as_array(); $p = $prices[0]['price']; $parts = DB::select(DB::expr('SUM(price) as price'))->from('parts')->where(DB::expr('id = ANY (SELECT DISTINCT part_id FROM auctions WHERE YEAR(won_date) = ' . $year['year'] . ' AND MONTH(won_date) = ' . $month['month'] . ')'))->execute()->as_array(); $pr = $parts[0]['price']; $sum = $p + $pr + $c * Config::get('my.commission'); $m_stat = ['count' => $items[0]['count'], 'price' => $sum, 'aprox' => number_format($sum / $items[0]['count'])]; $statistic[$year['year']][$month['month']] = $m_stat; if ($d_date > $s_date) { continue; } \Cache::set("yahoo.statistic.{$s_year}.{$s_month}", $m_stat, \Config::get('my.statistic_cache')); } } } $this->template->title = "Statistic"; $this->template->content = View::forge('admin/statistic/index', ['item_count' => $item_count[0]['count'], 'commission' => $commission, 'price' => $price, 'approx_price' => $price / $item_count[0]['count'], 'not_paid_sum' => $not_paid_auc[0]['price'] + $not_paid_part[0]['price'], 'on_hand' => $on_hand[0]['item_count'], 'on_hand_won' => $on_hand[0]['item_count'] + $won[0]['item_count'], 'today_won' => $today_won[0]['count'] ? $today_won[0]['count'] : 0, 'yesterday_won' => $yesterday_won[0]['count'] ? $yesterday_won[0]['count'] : 0, 'statistic' => $statistic]); }
public function __construct(PurchaseChoice $purchaseSystem, \DateTime $now = null) { if (is_null($now)) { $now = new \DateTime(); } $this->purchase = $purchaseSystem; $this->purchasedAt = clone $now; $this->expiredAt = clone $now; $this->expiredAt->modify($this->purchase->getDurationOffset()); }
private function adjustFixedHoliday(\DateTime $holiday) { $weekday = $holiday->format('w'); if ($weekday == 0) { $holiday->modify('+1 day'); } elseif ($weekday == 6) { $holiday->modify('-1 day'); } return $holiday; }
/** * @group translator */ public function testIsFresh() { $resource = new DatabaseFreshResource('fr', 'messages'); $date = new \DateTime('now'); $this->assertTrue($resource->isFresh($date->format('U'))); $date->modify('+1 day'); $this->assertTrue($resource->isFresh($date->format('U'))); $date->modify('+10 days'); $this->assertTrue($resource->isFresh($date->format('U'))); }
function getStartEndDate($report) { $return = array(); $date = new DateTime('now'); $date->modify('first day of this month'); $return[] = $date->format('Y-m-d') . ' 00:00:00'; $date->modify('first day of next month'); $return[] = $date->format('Y-m-d') . ' 00:00:00'; return $return; }
/** * @param \DateTime $date * @return bool */ public function isSatisfiedBy(\DatetIme $date) { $newYearsDate = new \DateTime($date->format('Y') . '-01-01'); if ($newYearsDate->format('N') === '6') { $newYearsDate->modify('+2 days'); } if ($newYearsDate->format('N') === '7') { $newYearsDate->modify('+1 days'); } return $date->format('m') === $newYearsDate->format('m') && $date->format('d') === $newYearsDate->format('d'); }
public function increment(\DateTime $date, $invert = false) { if (${${"GLOBALS"}["ttbetj"]}) { $date->modify("previous day"); $date->setTime(23, 59); } else { $date->modify("next day"); $date->setTime(0, 0); } return $this; }
public function increment(\DateTime $date, $invert = false) { if ($invert) { $date->modify('previous day'); $date->setTime(23, 59); } else { $date->modify('next day'); $date->setTime(0, 0); } return $this; }
/** * {@inheritdoc} */ public function increment(DateTime $date, $invert = false) { if ($invert) { $date->modify('last day of previous month'); $date->setTime(23, 59); } else { $date->modify('first day of next month'); $date->setTime(0, 0); } return $this; }
/** * @return array */ public function getPeriods() { $periods = array(); $from = new \DateTime(); foreach ($this->config->getPeriods() as $years) { $to = new \DateTime(); $periods[] = array('from' => $from->format('Y'), 'to' => $to->modify(sprintf('-%s years', $years))->format('Y')); $from = clone $to->modify('-1 year'); } return $periods; }
public function run() { // Initialize empty array $asset_maintenances = array(); $date = new DateTime(); $asset_maintenances[] = array('asset_id' => 1, 'supplier_id' => 1, 'asset_maintenance_type' => 'Maintenance', 'title' => 'Test Maintenance', 'start_date' => $date->modify('-10 day'), 'cost' => '200.99', 'is_warranty' => '0', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day')); // Delete all the old data DB::table('asset_maintenances')->truncate(); // Insert the new posts AssetMaintenance::insert($asset_maintenances); }
/** * */ public function testIsInPast() { $dt = new DateTime(); $dt->modify('-1 hour'); $this->assertTrue($dt->isInPast()); $dt->modify('+2 hour'); $this->assertFalse($dt->isInPast()); $dt = new DateTime('2013-03-08 11:00:00'); $this->assertTrue($dt->isInPast(new \DateTime('2013-03-08 11:00:01'))); $this->assertFalse($dt->isInPast(new \DateTime('2013-03-08 10:59:59'))); }