Skip to content

Instantly share code, notes, and snippets.

View JustLikeIcarus's full-sized avatar

Kenny JustLikeIcarus

View GitHub Profile
@JustLikeIcarus
JustLikeIcarus / DistanceBetween.sql
Created July 18, 2013 03:13
T-SQL Distance between two coordinates.
create FUNCTION [dbo].[DistanceBetween] (@Lat1 as real,
@Long1 as real, @Lat2 as real, @Long2 as real)
RETURNS Decimal
AS
BEGIN
DECLARE @dLat1InRad as float(53);
SET @dLat1InRad = @Lat1 * (PI()/180.0);
DECLARE @dLong1InRad as float(53);
SET @dLong1InRad = @Long1 * (PI()/180.0);
@JustLikeIcarus
JustLikeIcarus / DateTimeExtensions.cs
Created April 5, 2013 15:29
Extends System.DateTime to provide various utility functions.
namespace System
{
public static class DateTimeExtensions
{
/// <summary>
/// Returns the Week Number of the supplied date object
/// </summary>
/// <param name="value"></param>
/// <returns>int</returns>
public static int WeekNumber(this System.DateTime value)
@JustLikeIcarus
JustLikeIcarus / HtmlHelpersIfExtension.cs
Last active December 15, 2015 20:40
Extend MVC Html Helpers to return if an evaluation returns true. Example: @Html.ActionLink("Test Link", "SomeAction", "SomeController").If(Roles.GetRolesForUser().Contains("Admin"))
namespace System.Web.Mvc
{
public static class HelperExtensions
{
public static MvcHtmlString If(this MvcHtmlString value, bool evaluation)
{
return evaluation ? value : MvcHtmlString.Empty;
}
}
}
@JustLikeIcarus
JustLikeIcarus / PhoneFormat.cs
Created August 21, 2012 14:07
Phone Format Function
/// <summary>
/// Formats Phone Numbers to standard formats for display
/// </summary>
/// <param name="pn">Phone Number to format</param>
/// <returns></returns>
public static string FormatPhoneNumber(string pn)
{
if (String.IsNullOrEmpty(pn))
return pn;
<?php
function action_register()
{
#If user already signed-in
if(Auth::instance()->logged_in()!= 0){
#redirect to the user account
Request::instance()->redirect('account/profile');
}
#Load the view
<?php defined('SYSPATH') or die('No direct script access.');
class UsersRolesConstraints extends Doctrine_Migration_Base
{
public function up()
{
// Types
<?php defined('SYSPATH') or die('No direct script access.');
class TicketsCommentsStatusesLabels extends Doctrine_Migration_Base
{
public function up()
{
$this->createTable('tickets', array(
'id' => array(
'type' => 'integer',
<?php
/*
CREATE TABLE tickets (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_id INT NUT NULL,
project_id INT NOT NULL,
status_id INT NOT NULL,
created INT NOT NULL,
last_update INT NOT NULL
#issues{overflow:hidden;}
#issues .menu{float:left;width:10em;}
#issues .menu .create{margin-bottom:15px;}
#issues .menu .create a{display:block;}
#issues .menu .create img{width:8.921em;height:2.099em;}
#issues .menu ul{list-style-type:none;}
#issues .menu ul li{display:block;border:1px solid #e0e0e0;border-right:0;margin-top:-0.1em;}
#issues .menu ul li a{display:block;padding:.25em .5em;}
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>jQuery UI Example Page</title>
<link type="text/css" href="css/jquery-ui-1.8rc3.custom.css" rel="stylesheet" />
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.custom.js"></script>
<script type="text/javascript">