Skip to content

Instantly share code, notes, and snippets.

@vexus2
vexus2 / user.php
Last active December 10, 2015 02:58
[PHP]ユーザテーブルの登録日ごとの件数を取得
/**
* 日にち毎の会員登録ユーザ数を取得する
*/
public function getRegisterCountDayByDay ( $limit = 30 ) {
$params = array(
'fields' => array(
'count(1) as count',
"DATE_FORMAT(created_at,'%Y-%m-%d') as regist_date"
),
'conditions' => array( 'created_at > (now() - interval ' . $limit . ' day)' ),
@vexus2
vexus2 / bootstrap.php
Created December 25, 2012 06:17
PHP error_log拡張メソッド 呼び出しファイルやメソッド名を出力
/**
* 標準のerror_logメソッドを拡張し、呼び出し箇所の行数等を追加表示させる
*
* @param $message
* @param null $message_type
* @param null $destination
* @param null $extra_headers
*/
function e_log ($id, $message, $level = LEVEL_ERR , $message_type = null, $destination = null, $extra_headers = null ) {
error_log('---------------------------');
@vexus2
vexus2 / util.js
Created October 24, 2012 03:45
[Javascript]ブラウザの縦幅、横幅をそれぞれ取得する
function getScreenSize() {
var obj = new Object();
if (!isSafari && !isOpera) {
obj.x = document.documentElement.clientWidth || document.body.clientWidth || document.body.scrollWidth;
obj.y = document.documentElement.clientHeight || document.body.clientHeight || document.body.scrollHeight;
} else {
obj.x = window.innerWidth;
obj.y = window.innerHeight;
}
obj.mx = parseInt((obj.x)/2);
@vexus2
vexus2 / util.js
Created October 24, 2012 03:44
[Javascript]スマフォで表示した際にアドレスバーを非表示にする
function hideAddressBar () {
setTimeout(function(){
window.scrollTo(0,1);
}, 1);
}
@vexus2
vexus2 / index.html
Created October 14, 2012 11:42
[HTML]TwitterBootstrap NavigationBarTemplate
<div class="navbar navbar-inverse">
<div class="navbar-inner">
<a href="" class="brand">Logo</a>
<ul class="nav">
<li><a href="" class="active">Home</a></li>
<li><a href="">Help</a></li>
</ul>
<form class="navbar-search pull-left">
<input type="text" class="search-query" placeholder="検索">
</form>
@vexus2
vexus2 / build.xml
Created October 11, 2012 01:27
[xml]Jenkins用のbuild.xml phpcpd/phpmd/phpunit/phpdoc使用
<?xml version="1.0" encoding="utf-8" ?>
<project name="auoneLibrary" basedir="." default="all">
<property name="outputDir" value="."/>
<target name="phpcpd">
<phpcpd minTokens="10">
<fileset dir="./application/">
<include name="**/*.php"/>
<exclude name="library/lwopenid/**/*.php"/>
</fileset>
@vexus2
vexus2 / prepare.php
Created October 11, 2012 01:37
[PHP]ZendFramework用prepare設定 Zend日付バグの対応含む
<?php
if (defined('E_DEPRECATED')) {
error_reporting(E_ALL & ~E_DEPRECATED & ~E_WARNING);
} else {
error_reporting(E_ALL);
}
defined('APPLICATION_CONFIG')
|| define('APPLICATION_CONFIG', 'application.ini');
@vexus2
vexus2 / common_formatter.php
Created October 11, 2012 01:34
[PHP]ISO8601形式日付などのフォーマットを行う汎用クラス
<?php
/**
* フォーマット変換ユーティリティクラス
*/
class CommonFormatter
{
/**
* 日付のフォーマット配列
*/
private static $DATE_FORMAT_ARRAY = array(
@vexus2
vexus2 / nico_video_fetcher.rb
Created October 10, 2012 02:28
[Ruby]ニコニコ動画検索APIを実行し動画情報を取り出す
#!/usr/bin/env ruby
# -*- coding: utf-8 -*-
if RUBY_VERSION < '1.9'
require 'rubygems'
end
require File.expand_path('../../config/boot', __FILE__)
require 'json'
require 'mechanize'
require 'cgi'
@vexus2
vexus2 / login_step.php
Created October 5, 2012 02:43
[PHP]UserAgent切り替え for Behat
<?php
/**
* @var $world FeatureContext
*/
$steps->Given( '/^"([^"]*)" でアクセスしている$/', function ( $world, $table ) {
switch ( $table ) {
case "フィーチャフォン":
$user_agent = "KDDI-CA39 UP.Browser/6.2.0.13.1.5 (GUI) MMP/2.0";
break;
case "スマートフォン":