Skip to content

Instantly share code, notes, and snippets.

View oojacoboo's full-sized avatar

Jacob Thomason oojacoboo

10 followers · 3 following
View GitHub Profile
@oojacoboo
oojacoboo / gist:3037942
Created July 3, 2012 05:48
SELECT t.`id`, t.`reference_id`, t.`tenant_id`, t.`amount`,
(
SELECT SUM(t.`amount`)
FROM `transaction` t
) AS total
FROM `transaction` t
WHERE total > 0
GROUP BY t.`reference_id`;
@oojacoboo
oojacoboo / gist:3343826
Created August 13, 2012 20:18
/**
* The model behavior for the bathroom fan
*/
class Fan extends Courtesy {
//it is ok to leave it off if it's all fresh
protected $position = false;
/**
* If the can was used, fan should be on
@oojacoboo
oojacoboo / gist:3631211
Created September 5, 2012 05:47
SET @settingName = "feeMID", @companyId = 1;
SELECT COALESCE(company_setting.value, default_setting.value) AS value
FROM default_setting
LEFT JOIN company_setting
ON company_setting.default_setting_id
WHERE default_setting.name = @settingName
AND company_setting.company_id = @companyId
@oojacoboo
oojacoboo / SqliteSetup.php
Created September 26, 2012 04:31
public function truncateTables($connection = null) {
if(!$connection)
$connection = $this->con;
$tables = $this->getTables();
foreach($tables as $table) {
//truncate data from this table
$sql = "DELETE FROM [" . $table . "]";
@oojacoboo
oojacoboo / SqliteSetup.php
Created September 26, 2012 04:32
public function truncateTables($connection = null) {
if(!$connection)
$connection = $this->con;
$tables = $this->getTables();
foreach($tables as $table) {
//truncate data from this table
$sql = "DELETE FROM [" . $table . "]";
@oojacoboo
oojacoboo / actions.class.php
Created October 10, 2012 03:24
array_walk closure :P
/**
* Outputs a CSV file for download
* @param sfRequest $request
* @return string (.csv file)
*/
public function executeExportcsv(sfRequest $request) {
$companies = $this->getCompaniesData($request);
$outstream = fopen("php://output", "w");
@oojacoboo
oojacoboo / Globals.php
Created October 11, 2012 01:24
/**
* Ensures that the value passed is in datetime format
* @param null $dateOrTime
* @param string $format
* @return null|string
*/
function ensureDateTime($dateOrTime = null, $format = "c") {
if(!$dateOrTime)
return null;
@oojacoboo
oojacoboo / Globals.php
Created October 13, 2012 00:23
/**
* Ensures that the value passed is in datetime format
* @param null $dateOrTime
* @param string $format
* @param string $fallback
* @return null|string
*/
function ensureDateTime($dateOrTime = null, $format = "c", $fallback = null) {
if(!$dateOrTime && !$fallback)
return null;
@oojacoboo
oojacoboo / Globals.php
Created October 13, 2012 04:10
Make those dates work!
/**
* Checks a date/time string to verify it's a valid date/time
* Supports both Y-m-d and Y-m-d H:i:s
* @param $dateTime
* @return bool
*/
function isValidDateTime($dateTime) {
if(preg_match("/^(\d{4})-(\d{2})-(\d{2})( ([01][0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9]))?$/", $dateTime, $matches)) {
if(checkdate($matches[2], $matches[3], $matches[1])) {
return true;
@oojacoboo
oojacoboo / Globals.php
Created October 13, 2012 04:14
Ensure those dates and times are working for you!
/**
* Checks a date/time string to verify it's a valid date/time
* Supports both Y-m-d and Y-m-d H:i:s
* @param $dateOrTime
* @return bool
*/
function isValidDateTime($dateOrTime) {
if(preg_match("/^(\d{4})-(\d{2})-(\d{2})( ([01][0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9]))?$/", $dateOrTime, $matches)) {
if(checkdate($matches[2], $matches[3], $matches[1])) {
return true;