示例#1
0
 protected function column_value(\ebi\Dao $dao, $name, $value)
 {
     if ($value === null) {
         return null;
     }
     try {
         switch ($dao->prop_anon($name, 'type')) {
             case 'timestamp':
                 if (!ctype_digit($value)) {
                     $value = strtotime($value);
                 }
                 // UTCとして扱う
                 return date('Y-m-d H:i:s', $value - $this->timezone_offset);
             case 'date':
                 if (!ctype_digit($value)) {
                     $value = strtotime($value);
                 }
                 return date('Y-m-d', $value);
             case 'boolean':
                 return (int) $value;
         }
     } catch (\Exception $e) {
     }
     return $value;
 }
示例#2
0
文件: Flow.php 项目: tokushima/ebi
 /**
  * アプリケーションを実行する
  * @param mixed{} $map
  */
 public static function app($map = [])
 {
     if (empty($map)) {
         $map = ['patterns' => ['' => ['action' => 'ebi.Dt', 'mode' => 'local']]];
     } else {
         if (is_string($map)) {
             $map = ['patterns' => ['' => ['action' => $map]]];
         } else {
             if (is_array($map) && !isset($map['patterns'])) {
                 $map = ['patterns' => $map];
             }
         }
     }
     if (!isset($map['patterns']) || !is_array($map['patterns'])) {
         throw new \ebi\exception\InvalidArgumentException('patterns not found');
     }
     $entry_file = null;
     foreach (debug_backtrace(false) as $d) {
         if ($d['file'] !== __FILE__) {
             $entry_file = basename($d['file']);
             break;
         }
     }
     /**
      * @param string $val アプリケーションURL、末尾が * = 実行エントリ, ** = エントリファイル名(*.php)
      */
     $app_url = \ebi\Conf::get('app_url');
     if (is_array($app_url)) {
         if (isset($app_url[$entry_file])) {
             $app_url = $app_url[$entry_file];
         } else {
             if (isset($app_url['*'])) {
                 $app_url = $app_url['*'];
             } else {
                 $app_url = null;
             }
         }
     }
     self::$app_url = $app_url;
     /**
      * @param string $val メディアファイルのベースURL
      * http://localhost:8000/resources/media
      */
     self::$media_url = \ebi\Conf::get('media_url');
     if (empty(self::$app_url)) {
         $host = \ebi\Request::host();
         self::$app_url = (empty($host) ? 'http://localhost:8000/' : $host . '/') . $entry_file;
     } else {
         if (substr(self::$app_url, -1) == '*') {
             self::$app_url = substr(self::$app_url, 0, -1);
             self::$app_url = substr(self::$app_url, -1) == '*' ? substr(self::$app_url, 0, -1) . $entry_file : self::$app_url . substr($entry_file, 0, -4);
         }
     }
     self::$app_url = \ebi\Util::path_slash(str_replace('https://', 'http://', self::$app_url), null, true);
     if (empty(self::$media_url)) {
         $media_path = preg_replace('/\\/[^\\/]+\\.php[\\/]$/', '/', self::$app_url);
         self::$media_url = $media_path . 'resources/media/';
     }
     self::$media_url = \ebi\Util::path_slash(self::$media_url, null, true);
     /**
      * @param string $val テンプレートファイルのディレクトリ
      */
     self::$template_path = \ebi\Util::path_slash(\ebi\Conf::get('template_path', \ebi\Conf::resource_path('templates')), null, true);
     $automap_idx = 1;
     $selfmap = ['patterns' => self::expand_patterns('', $map['patterns'], [], $automap_idx)];
     unset($map['patterns']);
     $selfmap = array_merge($selfmap, $map);
     self::$workgroup = array_key_exists('workgroup', $selfmap) ? $selfmap['workgroup'] : basename($entry_file, '.php');
     /**
      * @param boolean $val HTTPSを有効にするか,falseの場合、mapのsecureフラグもすべてfalseとなる
      */
     $conf_secure = \ebi\Conf::get('secure');
     $map_secure = array_key_exists('secure', $selfmap) && $selfmap['secure'] === true;
     $is_secure_pattern_func = function ($pattern) use($conf_secure, $map_secure) {
         if ($conf_secure === false) {
             return false;
         }
         if (array_key_exists('secure', $pattern)) {
             return $pattern['secure'] === true;
         }
         return $map_secure == true;
     };
     $https = str_replace('http://', 'https://', self::$app_url);
     $url_format_func = function ($url, $pattern) use($https, $is_secure_pattern_func) {
         $num = 0;
         $format = \ebi\Util::path_absolute($is_secure_pattern_func($pattern) ? $https : self::$app_url, empty($url) ? '' : substr(preg_replace_callback("/([^\\\\])(\\(.*?[^\\\\]\\))/", function ($n) {
             return $n[1] . '%s';
         }, ' ' . $url, -1, $num), 1));
         return [str_replace(['\\\\', '\\.', '_ESC_'], ['_ESC_', '.', '\\'], $format), $num];
     };
     foreach ($selfmap['patterns'] as $k => $v) {
         list($selfmap['patterns'][$k]['format'], $selfmap['patterns'][$k]['num']) = $url_format_func($k, $v);
     }
     krsort($selfmap['patterns']);
     if (self::$is_get_map) {
         self::$is_get_map = false;
         self::$map = $selfmap;
         return;
     }
     $pathinfo = preg_replace("/(.*?)\\?.*/", "\\1", isset($_SERVER['PATH_INFO']) ? $_SERVER['PATH_INFO'] : '');
     if (preg_match('/^\\/' . preg_quote(self::$package_media_url, '/') . '\\/(\\d+)\\/(.+)$/', $pathinfo, $m)) {
         foreach ($selfmap['patterns'] as $p) {
             if (isset($p['@']) && isset($p['idx']) && (int) $p['idx'] === (int) $m[1] && is_file($file = $p['@'] . '/resources/media/' . $m[2])) {
                 \ebi\HttpFile::attach($file);
             }
         }
         \ebi\HttpHeader::send_status(404);
         return self::terminate();
     }
     foreach ($selfmap['patterns'] as $k => $pattern) {
         if (preg_match('/^' . (empty($k) ? '' : '\\/') . str_replace(['\\/', '/', '@#S'], ['@#S', '\\/', '\\/'], $k) . '[\\/]{0,1}$/', $pathinfo, $param_arr)) {
             if ($is_secure_pattern_func($pattern)) {
                 if (substr(\ebi\Request::current_url(), 0, 5) === 'http:' && (!isset($_SERVER['HTTP_X_FORWARDED_HOST']) || isset($_SERVER['HTTP_X_FORWARDED_PORT']) && $_SERVER['HTTP_X_FORWARDED_PORT'] != 443 || isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] != 'https')) {
                     header('Location: ' . preg_replace('/^.+(:\\/\\/.+)$/', 'https\\1', \ebi\Request::current_url()));
                     exit;
                 }
                 self::$media_url = str_replace('http://', 'https://', self::$media_url);
             }
             self::$template = new \ebi\Template();
             try {
                 $funcs = $class = $method = $template = $ins = null;
                 $exception = null;
                 $has_flow_plugin = false;
                 $result_vars = $plugins = [];
                 $accept_debug = \ebi\Conf::get('accept_debug', false) && strpos(strtolower((new \ebi\Env())->get('HTTP_ACCEPT')), 'application/debug') !== false;
                 array_shift($param_arr);
                 if (array_key_exists('action', $pattern)) {
                     if (is_string($pattern['action'])) {
                         list($class, $method) = explode('::', $pattern['action']);
                     } else {
                         if (is_callable($pattern['action'])) {
                             $funcs = $pattern['action'];
                         } else {
                             throw new \ebi\exception\InvalidArgumentException($pattern['name'] . ' action invalid');
                         }
                     }
                 }
                 foreach ($selfmap['patterns'] as $m) {
                     self::$url_pattern[$m['name']][$m['num']] = $m['format'];
                     if (array_key_exists('@', $pattern) && array_key_exists('@', $m) && $pattern['idx'] == $m['idx']) {
                         list(, $mm) = explode('::', $m['action']);
                         self::$selected_class_pattern[$mm][$m['num']] = ['format' => $m['format'], 'name' => $m['name']];
                     }
                 }
                 if (array_key_exists('vars', $selfmap) && is_array($selfmap['vars'])) {
                     $result_vars = $selfmap['vars'];
                 }
                 if (array_key_exists('vars', $pattern) && is_array($pattern['vars'])) {
                     $result_vars = array_merge($result_vars, $pattern['vars']);
                 }
                 if (array_key_exists('redirect', $pattern)) {
                     self::map_redirect($pattern['redirect'], $result_vars, $pattern);
                 }
                 foreach (array_merge(array_key_exists('plugins', $selfmap) ? is_array($selfmap['plugins']) ? $selfmap['plugins'] : [$selfmap['plugins']] : [], array_key_exists('plugins', $pattern) ? is_array($pattern['plugins']) ? $pattern['plugins'] : [$pattern['plugins']] : []) as $m) {
                     $o = \ebi\Util::strtoinstance($m);
                     self::set_class_plugin($o);
                     $plugins[] = $o;
                 }
                 if (!isset($funcs) && isset($class)) {
                     $ins = \ebi\Util::strtoinstance($class);
                     $traits = \ebi\Util::get_class_traits(get_class($ins));
                     if ($has_flow_plugin = in_array('ebi\\FlowPlugin', $traits)) {
                         foreach ($ins->get_flow_plugins() as $m) {
                             $o = \ebi\Util::strtoinstance($m);
                             $plugins[] = $o;
                             self::set_class_plugin($o);
                         }
                         $ins->set_pattern($pattern);
                     }
                     if (in_array('ebi\\Plugin', $traits)) {
                         foreach ($plugins as $o) {
                             $ins->set_object_plugin($o);
                         }
                     }
                     $funcs = [$ins, $method];
                 }
                 foreach ($plugins as $o) {
                     self::$template->set_object_plugin($o);
                 }
                 if (self::has_class_plugin('before_flow_action')) {
                     /**
                      * 前処理
                      */
                     self::call_class_plugin_funcs('before_flow_action');
                 }
                 if ($has_flow_plugin) {
                     $ins->before();
                     $before_redirect = $ins->get_before_redirect();
                     if (isset($before_redirect)) {
                         self::map_redirect($before_redirect, $result_vars, $pattern);
                     }
                 }
                 if (isset($funcs)) {
                     try {
                         $action_result_vars = call_user_func_array($funcs, $param_arr);
                         if (is_array($action_result_vars)) {
                             $result_vars = array_merge($result_vars, $action_result_vars);
                         }
                     } catch (\Exception $exception) {
                     }
                 }
                 if ($has_flow_plugin) {
                     $ins->after();
                     $template_block = $ins->get_template_block();
                     if (!empty($template_block)) {
                         self::$template->put_block(\ebi\Util::path_absolute(self::$template_path, $ins->get_template_block()));
                     }
                     $template = $ins->get_template();
                     if (!empty($template)) {
                         $pattern['template'] = $template;
                     }
                     $result_vars = array_merge($result_vars, $ins->get_after_vars());
                     $after_redirect = $ins->get_after_redirect();
                     if (isset($after_redirect) && !array_key_exists('after', $pattern) && !array_key_exists('cond_after', $pattern)) {
                         $pattern['after'] = $after_redirect;
                     }
                 }
                 if (self::has_class_plugin('after_flow_action')) {
                     /**
                      * 後処理
                      */
                     self::call_class_plugin_funcs('after_flow_action');
                 }
                 if (isset($exception)) {
                     throw $exception;
                 }
                 \ebi\Exceptions::throw_over();
                 if (!$accept_debug) {
                     if (isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD'] == 'POST') {
                         if (array_key_exists('post_cond_after', $pattern) && is_array($pattern['post_cond_after'])) {
                             foreach ($pattern['post_cond_after'] as $cak => $cav) {
                                 if (isset($result_vars[$cak])) {
                                     self::map_redirect($cav, $result_vars, $pattern);
                                 }
                             }
                         }
                         if (array_key_exists('post_after', $pattern)) {
                             self::map_redirect($pattern['post_after'], $result_vars, $pattern);
                         }
                     }
                     if (array_key_exists('cond_after', $pattern) && is_array($pattern['cond_after'])) {
                         foreach ($pattern['cond_after'] as $cak => $cav) {
                             if (isset($result_vars[$cak])) {
                                 self::map_redirect($cav, $result_vars, $pattern);
                             }
                         }
                     }
                     if (array_key_exists('after', $pattern)) {
                         self::map_redirect($pattern['after'], $result_vars, $pattern);
                     }
                     if (array_key_exists('template', $pattern)) {
                         if (array_key_exists('template_super', $pattern)) {
                             self::$template->template_super(\ebi\Util::path_absolute(self::$template_path, $pattern['template_super']));
                         }
                         return self::template($result_vars, $pattern, $ins, \ebi\Util::path_absolute(self::$template_path, $pattern['template']));
                     } else {
                         if (isset($template)) {
                             return self::template($result_vars, $pattern, $ins, \ebi\Util::path_absolute(self::$template_path, $template));
                         } else {
                             if (array_key_exists('@', $pattern) && is_file($t = \ebi\Util::path_absolute(self::$template_path, $pattern['name']) . '.html')) {
                                 return self::template($result_vars, $pattern, $ins, $t);
                             } else {
                                 if (array_key_exists('@', $pattern) && is_file($t = $pattern['@'] . '/resources/templates/' . preg_replace('/^.+::/', '', $pattern['action'] . '.html'))) {
                                     $app_url = $is_secure_pattern_func($pattern) ? str_replace('http://', 'https://', self::$app_url) : self::$app_url;
                                     return self::template($result_vars, $pattern, $ins, $t, $app_url . self::$package_media_url . '/' . $pattern['idx']);
                                 } else {
                                     if (array_key_exists('find_template', $selfmap) && $selfmap['find_template'] === true && is_file($t = \ebi\Util::path_absolute(self::$template_path, $pattern['name'] . '.html'))) {
                                         return self::template($result_vars, $pattern, $ins, $t);
                                     } else {
                                         if (self::has_class_plugin('flow_output')) {
                                             /**
                                              * 結果を出力する
                                              * @param mixed{} $result_vars actionで返却された変数
                                              */
                                             self::call_class_plugin_funcs('flow_output', $result_vars);
                                             return self::terminate();
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
                 \ebi\HttpHeader::send('Content-Type', 'application/json');
                 print \ebi\Json::encode(['result' => \ebi\Util::to_primitive($result_vars)]);
                 return self::terminate();
             } catch (\Exception $e) {
                 \ebi\FlowInvalid::set($e);
                 \ebi\Dao::rollback_all();
                 /**
                  * @param string[] $val ログに記録しない例外クラス名
                  */
                 if (!in_array(get_class($e), \ebi\Conf::gets('ignore_exceptions'))) {
                     \ebi\Log::warning($e);
                 }
                 if (isset($pattern['error_status'])) {
                     \ebi\HttpHeader::send_status($pattern['error_status']);
                 } else {
                     if (isset($selfmap['error_status'])) {
                         \ebi\HttpHeader::send_status($selfmap['error_status']);
                     }
                 }
                 if (isset($pattern['vars']) && !empty($pattern['vars']) && is_array($pattern['vars'])) {
                     $result_vars = array_merge($result_vars, $pattern['vars']);
                 }
                 if (!$accept_debug) {
                     if (isset($pattern['@']) && is_file($t = $pattern['@'] . '/resources/templates/error.html')) {
                         $app_url = $is_secure_pattern_func($pattern) ? str_replace('http://', 'https://', self::$app_url) : self::$app_url;
                         return self::template($result_vars, $pattern, $ins, $t, $app_url . self::$package_media_url . '/' . $pattern['idx']);
                     } else {
                         if (array_key_exists('error_redirect', $pattern)) {
                             return self::map_redirect($pattern['error_redirect'], [], $pattern);
                         } else {
                             if (array_key_exists('error_template', $pattern)) {
                                 return self::template($result_vars, $pattern, $ins, \ebi\Util::path_absolute(self::$template_path, $pattern['error_template']));
                             } else {
                                 if (array_key_exists('error_redirect', $selfmap)) {
                                     return self::map_redirect($selfmap['error_redirect'], [], $pattern);
                                 } else {
                                     if (array_key_exists('error_template', $selfmap)) {
                                         return self::template($result_vars, $pattern, $ins, \ebi\Util::path_absolute(self::$template_path, $selfmap['error_template']));
                                     } else {
                                         if (self::has_class_plugin('flow_exception')) {
                                             /**
                                              * 例外発生時の処理・出力
                                              * @param \Exception $e 発生した例外
                                              */
                                             self::call_class_plugin_funcs('flow_exception', $e);
                                             return self::terminate();
                                         } else {
                                             if (self::has_class_plugin('flow_output')) {
                                                 self::call_class_plugin_funcs('flow_output', ['error' => ['message' => $e->getMessage()]]);
                                                 return self::terminate();
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
                 /**
                  *  @param boolean $val Error Json出力時にException traceも出力するフラグ
                  */
                 $trace = \ebi\Conf::get('exception_trace', false);
                 $message = [];
                 foreach (\ebi\FlowInvalid::get() as $g => $e) {
                     $em = ['message' => $e->getMessage(), 'type' => basename(str_replace("\\", '/', get_class($e)))];
                     if ($trace) {
                         $em['trace'] = $e->getTraceAsString();
                     }
                     if (!empty($g)) {
                         $em['group'] = $g;
                     }
                     $message[] = $em;
                 }
                 \ebi\HttpHeader::send('Content-Type', 'application/json');
                 print json_encode(['error' => $message]);
                 return self::terminate();
             }
         }
     }
     if (array_key_exists('nomatch_redirect', $selfmap) && strpos($selfmap['nomatch_redirect'], '://') === false) {
         foreach ($selfmap['patterns'] as $m) {
             if ($selfmap['nomatch_redirect'] == $m['name']) {
                 self::$url_pattern[$m['name']][$m['num']] = $m['format'];
                 break;
             }
         }
         self::map_redirect($selfmap['nomatch_redirect'], [], []);
     }
     \ebi\HttpHeader::send_status(404);
     return self::terminate();
 }
示例#3
0
<?php

\test\db\DateTime::create_table();
\test\db\DateTime::find_delete();
$time = time();
$obj = new \test\db\DateTime();
$obj->ts(date('Y/m/d H:i:s', $time));
$obj->date(date('Y/m/d H:i:s', $time));
$obj->idate(date('Y/m/d H:i:s', $time));
$obj->save();
foreach (\test\db\DateTime::find() as $o) {
    eq(date('c', $time), $o->fm_ts());
    eq(date('Y-m-d', $time), $o->fm_date());
    eq(date('Ymd', $time), $o->idate());
}
$db = \ebi\Dao::connection(\test\db\DateTime::class);
$db->query('select ts,date,idate from date_time');
foreach ($db as $data) {
    $t = new \DateTime(date('Y/m/d H:i:s', $time));
    $t->setTimezone(new \DateTimeZone('UTC'));
    if (\ebi\Conf::appmode() == 'mamp') {
        eq(date('Y-m-d H:i:s', $time), $data['ts']);
        // mysqlの接続設定でtimezoneをJSTで取得している
    } else {
        eq($t->format('Y-m-d H:i:s'), $data['ts']);
    }
    eq(date('Y-m-d', $time), $data['date']);
    eq(date('Ymd', $time), $data['idate']);
}
示例#4
0
 public function exists_table_sql(\ebi\Dao $dao)
 {
     $dbc = \ebi\Dao::connection(get_class($dao));
     return sprintf('select count(*) from information_schema.tables where table_name=\'%s\' and table_schema=\'%s\'', $dao->table(), $dbc->name());
 }
示例#5
0
 public function drop_table_sql(\ebi\Dao $dao)
 {
     $quote = function ($name) {
         return '`' . $name . '`';
     };
     $sql = 'drop table ' . $quote($dao->table());
     return $sql;
 }
示例#6
0
 public function create_sql(\ebi\Dao $dao)
 {
     $insert = $vars = [];
     $autoid = null;
     foreach ($dao->columns(true) as $column) {
         if (!$column->auto()) {
             $insert[] = $this->quotation($column->column());
             $vars[] = $this->column_value($dao, $column->name(), $dao->{$column->name()}());
         }
     }
     return new \ebi\Daq('insert into ' . $this->quotation($column->table()) . ' (' . implode(',', $insert) . ') values (' . implode(',', array_fill(0, sizeof($insert), '?')) . ');', $vars);
 }