PHP Date::create_from_string方法代码示例

 public function action_core()
 {
     //日付
     //        $work=strtotime("2015/12/10 10:12:13");
     //日付返還（a fuel/core/config/date.php
     $work = Date::create_from_string("2011-12-10 10:23:13", "mysql");
     $data['aaa'] = $work->format("%Y/%m/%d");
     $this->template->title = 'Coreいろいろ';
     $this->template->content = View::forge('test/core', $data);
 }

 /**
  * Processes customer statistics.
  *
  * @return void
  */
 public static function customer()
 {
     if (!($task = \Service_Statistic_Task::begin('customer'))) {
         return false;
     }
     $data = array();
     $date_ranges = \Service_Statistic_Task::date_ranges('customer');
     foreach ($date_ranges as $range) {
         $begin = \Date::create_from_string($range['begin'], 'mysql');
         $end = \Date::create_from_string($range['end'], 'mysql');
         $date = $begin->format('mysql_date');
         $data[$date] = array();
         $created = \Service_Customer_Statistic::created($begin, $end);
         foreach ($created as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'created', 'value' => $result['total']);
         }
         $deleted = \Service_Customer_Statistic::deleted($begin, $end);
         foreach ($deleted as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'deleted', 'value' => $result['total']);
         }
         $subscribed = \Service_Customer_Statistic::subscribed($begin, $end);
         foreach ($subscribed as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'subscribed', 'value' => $result['total']);
         }
         $unsubscribed = \Service_Customer_Statistic::unsubscribed($begin, $end);
         foreach ($unsubscribed as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'unsubscribed', 'value' => $result['total']);
         }
         $total = \Service_Customer_Statistic::total($end);
         foreach ($total as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'total', 'value' => $result['total']);
         }
         $total_active = \Service_Customer_Statistic::total_active($end);
         foreach ($total_active as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'total_active', 'value' => $result['total']);
         }
         $total_subscribed = \Service_Customer_Statistic::total_subscribed($end);
         foreach ($total_subscribed as $result) {
             $data[$date][] = array('seller_id' => $result['seller_id'], 'name' => 'total_subscribed', 'value' => $result['total']);
         }
     }
     // Save the queried results as statistics.
     foreach ($data as $date => $results) {
         $date = \Date::create_from_string($date, 'mysql_date');
         foreach ($results as $result) {
             $seller = \Service_Seller::find_one($result['seller_id']);
             if (!\Service_Statistic::create($seller, 'customer', $date, $result['name'], $result['value'])) {
                 \Service_Statistic_Task::end($task, 'failed', "Error creating customer.{$result['name']} statistic for seller {$seller->name}.");
                 return;
             }
         }
     }
     \Service_Statistic_Task::end($task);
     \Cli::write('Customer Statistical Calculations Complete', 'green');
 }

 private static function check_won_at_time()
 {
     $interval = \Config::get('my.task.lot_update_interval');
     if (self::$LAST_CHECK_TIME < strtotime("-{$interval} minute")) {
         $auc_ids = [];
         $select = \DB::select('auc_id')->from('auctions')->order_by('id', 'desc')->limit(\Config::get('my.task.last_won_limit'))->execute()->as_array();
         $user_id = \DB::select('id')->from('users')->where('username', \Config::get('my.main_bidder'))->execute()->as_array();
         foreach ($select as $value) {
             $auc_ids[] = $value['auc_id'];
         }
         $val = \Model_Auction::validate();
         try {
             $browser = new \Browser();
             foreach ($browser->won(self::$PAGE_TO_UPDATE) as $auc_id) {
                 if (!in_array($auc_id, $auc_ids)) {
                     try {
                         $auc_xml = $browser->getXmlObject($auc_id);
                         $auc_values = [];
                         $auc_values['auc_id'] = (string) $auc_xml->Result->AuctionID;
                         $auc_values['title'] = (string) $auc_xml->Result->Title;
                         $auc_values['price'] = (int) $auc_xml->Result->Price;
                         $auc_values['won_date'] = \Date::create_from_string((string) $auc_xml->Result->EndTime, 'yahoo_date')->format('mysql');
                         $auc_values['user_id'] = $user_id[0]['id'];
                         $vendor_name = (string) $auc_xml->Result->Seller->Id;
                         $vendor_id = \DB::select('id')->from('vendors')->where('name', '=', $vendor_name)->execute()->as_array();
                         if (!empty($vendor_id)) {
                             $auc_values['vendor_id'] = $vendor_id[0]['id'];
                         } else {
                             if (\Model_Vendor::forge()->set(['name' => $vendor_name, 'by_now' => 0])->save()) {
                                 $vendor_id = \DB::select('id')->from('vendors')->where('name', '=', $vendor_name)->execute()->as_array();
                                 $auc_values['vendor_id'] = $vendor_id[0]['id'];
                             }
                         }
                         if ($val->run($auc_values)) {
                             \Model_Auction::forge()->set($auc_values)->save();
                         } else {
                             foreach ($val->error() as $value) {
                                 \Log::error('Validation error in task Minutely on method check_won_at_time : ' . $value);
                             }
                         }
                     } catch (\BrowserException $e) {
                         \Log::error("ID: " . $auc_id . " Error: " . $e->getMessage());
                     }
                 }
             }
         } catch (\BrowserLoginException $e) {
             \Log::error("Login error: " . $e->getMessage());
         } catch (\ParserException $e) {
             \Log::error("Parser error: " . $e->getMessage());
         }
         \Cache::set('yahoo.won_last_check', time());
     }
 }

 public function action_buscar()
 {
     \Config::load('phpthumb');
     $photos_path = str_replace("\\", "/", Config::get('photos_path'));
     $document_root = str_replace("\\", "/", Config::get('document_root'));
     $termino = Input::post('p');
     $fotos = Search::buscar($photos_path . '/*', $termino);
     $data['fotos'] = null;
     if ($fotos) {
         $files = "";
         foreach ($fotos as $file) {
             list($img_width, $img_height, $img_type, $img_attr) = getimagesize($document_root . "/" . $file);
             $files .= "<li  class='thumbnail'>" . "<a href='" . Myhtml::img_watermark($file) . "' rel='gallery' title='{$file}'>" . "<img class='detalle' data-original-title='" . $file . "' " . "data-content='Dimensiones: {$img_width} por {$img_height} pixels' src='" . Config::get('phpthumbroot') . "phpThumb.php?src=" . $document_root . $file . "&w=" . Config::get('thumb_size') . "&h=" . Config::get('thumb_size') . "&zc=1' />" . "</a>" . "</li>";
         }
         $data['fotos'] = html_entity_decode($files, ENT_QUOTES);
     }
     //Incio articulos
     $fi = date("Y-m-d") . ' 01:00:00';
     $ff = date("Y-m-d") . ' 23:59:00';
     $fecha_inicio = Date::create_from_string($fi, "mysql");
     $fecha_fin = Date::create_from_string($ff, "mysql");
     $articulos = Model_Articulo::find('all', array('related' => array('fotos', 'seccion'), 'where' => array(array('periodista_id', '=', $this->user_id), array('fecha_publicacion', '>=', $fecha_inicio->get_timestamp())), 'order_by' => array('fecha_publicacion' => 'asc')));
     $select_articulos = array();
     if ($articulos) {
         foreach ($articulos as $articulo) {
             $select_articulos[$articulo->id] = $articulo->nombre;
         }
     } else {
         $select_articulos = array('none' => 'No existen articulos creados');
     }
     $data['select_articulos'] = $select_articulos;
     // Fin articulos
     // Inicio Dimensiones
     $dimensiones = Model_Dimension::find('all');
     $select_dimensiones = array();
     if ($dimensiones) {
         foreach ($dimensiones as $dimension) {
             $select_dimensiones[$dimension->id] = $dimension->descipcion;
         }
     } else {
         $select_dimensiones = array('none' => 'No existen dimensiones creadas');
     }
     $data['select_dimensiones'] = $select_dimensiones;
     $data['periodista_id'] = $this->user_id;
     $view = View::forge(Session::get('template'));
     $view->set_global('user_id', 1);
     $view->set_global('data', $data);
     $view->set_global('title', 'Resultado de B&uacute;squeda');
     $view->set_global('content', 'Resultado de BB&uacute;squeda');
     $view->content = View::forge('buscar/buscar', $data);
     return $view;
 }

 /**
  * Return the formatted date.
  *
  * @param string $date        The date to format.
  * @param string $default     The default string to return.
  * @param string $to_format   The date format to convert to.
  * @param string $from_format The date format to convert from.
  *
  * @return string|null
  */
 public static function date($date, $default = null, $to_format = 'us', $from_format = 'mysql')
 {
     if ($from_format == 'mysql' && $date == '0000-00-00 00:00:00') {
         return $default;
     }
     if (empty($date)) {
         return $default;
     }
     if (!$date instanceof Date) {
         $date = Date::create_from_string($date, $from_format);
     }
     return '<abbr title="' . $date->format('us_full') . '">' . $date->format($to_format) . '</abbr>';
 }

 public function action_seccion($seccion_id = null)
 {
     is_null($seccion_id) and Response::redirect('diagramador');
     $fi = date("Y-m-d") . ' 01:00:00';
     $ff = date("Y-m-d") . ' 23:59:00';
     $fecha_inicio = Date::create_from_string($fi, "mysql");
     $fecha_fin = Date::create_from_string($ff, "mysql");
     $articulos = Model_Articulo::find('all', array('related' => array('fotos', 'seccion'), 'where' => array(array('seccion_id', '=', $seccion_id), array('fecha_publicacion', 'between', array($fecha_inicio->get_timestamp(), $fecha_fin->get_timestamp())))));
     $data['articulos'] = null;
     if ($articulos) {
         $data['articulos'] = $articulos;
     }
     $this->template->title = 'Diagramador » Index';
     $this->template->content = View::forge('diagramador/seccion', $data);
 }

 public function action_revisar($user_id = null)
 {
     is_null($user_id) and Response::redirect('editor');
     $fi = date("Y-m-d") . ' 01:00:00';
     $ff = date("Y-m-d") . ' 23:59:00';
     $fecha_inicio = Date::create_from_string($fi, "mysql");
     $fecha_fin = Date::create_from_string($ff, "mysql");
     $data['articulos'] = Model_Articulo::find('all', array('related' => array('fotos', 'seccion'), 'where' => array(array('periodista_id', '=', $user_id), array('fecha_publicacion', '>=', $fecha_inicio->get_timestamp())), 'order_by' => array('fecha_publicacion' => 'asc')));
     $usuario = Model_User::find($this->user_id);
     $profile_fields = $this->get_profile_fields($usuario) ? $this->get_profile_fields($usuario) : null;
     $periodista = Model_User::find($user_id);
     $data['periodista'] = $periodista;
     $view = View::forge('template_editor');
     $view->set_global('user_id', $this->user_id);
     $view->set_global('acceso_web', $profile_fields['acceso_web']);
     $view->set_global('data', $data);
     $view->set_global('title', 'Articulos del periodista: ' . $periodista->username);
     $view->content = View::forge('editor/revisar', $data);
     return $view;
 }

 public function action_getarticulos($pid = null)
 {
     $this->template = '';
     if ($pid != null) {
         $fecha_inicio = Date::create_from_string(date("m/d/Y") . " 01:00");
         $fecha_fin = Date::create_from_string(date("m/d/Y") . " 24:00");
         $articulos = Model_Articulo::find('all', array('where' => array(array('periodista_id', '=', '1'), array('fecha_publicacion', '>', $fecha_inicio->get_timestamp()))));
         $select = array();
         if ($articulos) {
             foreach ($articulos as $articulo) {
                 $select[$articulo->id] = $articulo->nombre;
             }
             if (count($select) < 1) {
                 $select = array('none' => 'Aun no tiene articulos creados');
             }
         } else {
             $select = array('none' => 'Aun no tiene articulos creados');
         }
         echo Form::select('articulo_id', 'none', $select);
     }
 }

 /**
  * Takes a DB timestamp and converts it into a Date object
  *
  * @param   string  value
  * @param   array  any options to be passed
  *
  * @return  \Fuel\Core\Date
  */
 public static function type_time_decode($var, array $settings)
 {
     if ($settings['data_type'] == 'time_mysql') {
         // deal with a 'nulled' date, which according to MySQL is a valid enough to store?
         if ($var == '0000-00-00 00:00:00') {
             if (array_key_exists('null', $settings) and $settings['null'] === false) {
                 throw new InvalidContentType('Value ' . $var . ' is not a valid date and can not be converted to a Date object.');
             }
             return null;
         }
         return \Date::create_from_string($var, 'mysql');
     }
     return \Date::forge($var);
 }

 public function action_archivo()
 {
     $ff = date("Y-m-d") . ' 01:00:00';
     $ff = strtotime('-1 day', strtotime($ff));
     $ff = date('Y-m-d', $ff) . ' 01:00:00';
     $fi = strtotime('-6 day', strtotime($ff));
     $fi = date('Y-m-d', $fi) . ' 01:00:00';
     $fecha_fin = Date::create_from_string($ff, "mysql");
     $fecha_inicio = Date::create_from_string($fi, "mysql");
     $data['articulos'] = Model_Articulo::find('all', array('related' => array('fotos', 'seccion'), 'where' => array(array('periodista_id', '=', $this->user_id), array('fecha_publicacion', 'between', array($fecha_inicio->get_timestamp(), $fecha_fin->get_timestamp()))), 'order_by' => array('fecha_publicacion' => 'asc')));
     $select_secciones = array();
     $secciones = Model_Seccion::find('all');
     if ($secciones) {
         foreach ($secciones as $seccion) {
             $select_secciones[$seccion->id] = $seccion->descripcion;
         }
     } else {
         $select_secciones = array('none' => 'No existen secciones creadas');
     }
     $data['select_secciones'] = $select_secciones;
     $usuario = Model_User::find($this->user_id);
     if ($usuario->group == 50) {
         $view = View::forge('template_editor');
     } else {
         $view = View::forge('template');
     }
     $view->set_global('user_id', $this->user_id);
     $view->set_global('data', $data);
     $view->set_global('select_secciones', $select_secciones);
     $view->set_global('title', 'Historial de Artículos');
     $view->set_global('menu_archivo', 1);
     $view->content = View::forge('articulo/archivo', $data);
     return $view;
 }

 /**
  * Takes a DB timestamp and converts it into a Date object
  *
  * @param   string  $var
  * @param   array   $settings
  * @return  \Fuel\Core\Date
  */
 public static function type_time_decode($var, array $settings)
 {
     if ($settings['data_type'] == 'time_mysql') {
         return \Date::create_from_string($var, 'mysql');
     }
     return \Date::forge($var);
 }

 public function post_refresh()
 {
     $result = 0;
     $val_error = [];
     $auc_ids = [];
     $page = (int) \Input::post('pages');
     $select = \DB::select('auc_id')->from('auctions')->order_by('id', 'desc')->limit(Config::get('my.task.last_won_limit'))->execute()->as_array();
     $user_id = \DB::select('id')->from('users')->where('username', Config::get('my.main_bidder'))->execute()->as_array();
     foreach ($select as $value) {
         $auc_ids[] = $value['auc_id'];
     }
     $val = Model_Auction::validate();
     try {
         $browser = new Browser();
         foreach ($browser->won($page) as $auc_id) {
             if (!in_array($auc_id, $auc_ids)) {
                 try {
                     $auc_xml = $browser->getXmlObject($auc_id);
                     $auc_values = [];
                     $auc_values['auc_id'] = (string) $auc_xml->Result->AuctionID;
                     $auc_values['title'] = (string) $auc_xml->Result->Title;
                     $auc_values['price'] = (int) $auc_xml->Result->Price;
                     $auc_values['won_date'] = Date::create_from_string((string) $auc_xml->Result->EndTime, 'yahoo_date')->format('mysql');
                     $auc_values['user_id'] = $user_id[0]['id'];
                     $vendor_name = (string) $auc_xml->Result->Seller->Id;
                     $vendor_id = \DB::select('id')->from('vendors')->where('name', '=', $vendor_name)->execute()->as_array();
                     if (!empty($vendor_id)) {
                         $auc_values['vendor_id'] = $vendor_id[0]['id'];
                     } else {
                         if (Model_Vendor::forge()->set(['name' => $vendor_name, 'by_now' => 0])->save()) {
                             $vendor_id = \DB::select('id')->from('vendors')->where('name', '=', $vendor_name)->execute()->as_array();
                             $auc_values['vendor_id'] = $vendor_id[0]['id'];
                         }
                     }
                     if ($val->run($auc_values)) {
                         Model_Auction::forge()->set($auc_values)->save();
                         $result++;
                     } else {
                         foreach ($val->error() as $value) {
                             Log::error('Validation error in controller/admin/api.php: ' . $value);
                         }
                         $val_error[] = "Could not save auction " . $auc_values['auc_id'];
                     }
                 } catch (BrowserException $e) {
                     $val_error[] = "ID: " . $auc_id . " Error: " . $e->getMessage();
                 }
             }
         }
     } catch (BrowserLoginException $e) {
         $val_error[] = "Login error: " . $e->getMessage();
     } catch (ParserException $e) {
         $val_error[] = "Parser error: " . $e->getMessage();
     }
     $this->response(['result' => $result, 'error' => implode('<br>', (array) $val_error)]);
 }

            ?>
</div>
		<div class="aucid"><?php 
            echo $auction->auc_id;
            ?>
</div>
		<div class="title"><?php 
            echo $auction->title;
            ?>
</div>
		<div class="price"><?php 
            echo $auction->price;
            ?>
</div>
		<div class="date"><?php 
            echo Date::create_from_string($auction->won_date, 'mysql')->format('display_date');
            ?>
</div>
		<div class="action">
			<i class="fa fa-comment<?php 
            echo $auction->memo ? '' : ' hidden';
            ?>
" aria-hidden="true"></i>
			<?php 
            if (Auth::member(\Config::get('my.groups.superadmin'))) {
                ?>
			<i class="fa fa-pencil-square-o auc-edit-button" aria-hidden="true"></i>
			<i class="fa fa-times-circle-o auc-delete-button" aria-hidden="true"></i>
			<?php 
            }
            ?>

 public function action_edit($id = null)
 {
     $where = ['id' => $id];
     if (Model_User::is_current_user('teacher')) {
         $where['subject.user_id'] = Auth::get('id');
     }
     if (Input::post('is_institutional') == 1) {
         $_POST['subject_id'] = Config::get('no_subject');
     }
     $activity = Model_Activity::find('first', ['where' => $where, 'related' => ['subject']]);
     if (empty($activity)) {
         Session::set_flash('error', 'Activity does not exist.');
         Response::redirect('site/activities');
     }
     $activity->date = Date::forge($activity->date)->format('mysql', true);
     $activity->end_date = Date::forge($activity->end_date)->format('mysql', true);
     $val = Model_Activity::validate('edit', Input::post('is_wholeday'));
     if (Input::post('end_date')) {
         $_POST['end_date'] = Input::post('end_date') . ':00';
     }
     if (Input::post('date')) {
         if (Input::post('is_wholeday')) {
             $_POST['end_date'] = substr(Input::post('date'), 0, 11) . '23:59:59';
             $_POST['date'] = substr(Input::post('date'), 0, 11) . '00:00';
         }
         $_POST['date'] = Date::create_from_string(Input::post('date') . ':00', "mysql")->get_timestamp();
     }
     if (Input::post('end_date')) {
         $_POST['end_date'] = Date::create_from_string(Input::post('end_date'), "mysql")->get_timestamp();
     }
     if ($val->run()) {
         $activity->type = Input::post('type');
         $activity->date = Input::post('date');
         $activity->end_date = Input::post('end_date');
         $activity->activity_content = Input::post('activity_content');
         $activity->subject_id = Input::post('subject_id');
         $activity->is_institutional = Input::post('is_institutional');
         if ($activity->save()) {
             Session::set_flash('success', e('Updated activity #' . $id));
             Response::redirect('site/activities');
         } else {
             Session::set_flash('error', e('Could not update activity #' . $id));
         }
     } else {
         if (Input::method() == 'POST') {
             $activity->type = $val->validated('type');
             $activity->date = $val->validated('date');
             $activity->end_date = $val->validated('end_date');
             $activity->activity_content = $val->validated('activity_content');
             $activity->subject_id = $val->validated('subject_id');
             $activity->is_institutional = $val->validated('is_institutional');
             Session::set_flash('error', $val->error());
         }
         $this->template->set_global('activity', $activity, false);
     }
     if (Input::post('date')) {
         $_POST['date'] = Date::forge(Input::post('date'))->format('mysql', true);
     }
     if (Input::post('end_date')) {
         $_POST['end_date'] = Date::forge(Input::post('end_date'))->format('mysql', true);
     }
     $this->template->title = "Activities";
     $this->template->content = View::forge('site/activities/edit');
 }

	    xhr.send(null);
	}
</script>
    <?php 
foreach ($event_model as $event) {
    ?>
    <h3><?php 
    echo Html::anchor("event/view/" . $event->id, $event->title);
    ?>
</h3>
    <p><?php 
    echo __('ACTION_INDEX_LOCATION') . ($event->location ? $event->location->title : __('NOT_SET'));
    ?>
</p>
    <p><?php 
    echo __('ACTION_INDEX_START') . Date::create_from_string($event->start, "mysql")->format("%d.%m.%Y, %H:%M");
    ?>
    
    <div class="agenda" data-event-id="<?php 
    echo $event->id;
    ?>
">
	   <?php 
    echo __('LINK_SHOW_AGENDA');
    ?>
    </div>
    <!--ul>
	<?php 
    foreach ($event->agendas as $agenda) {
        ?>
	    <li><?php