mlebkowski

SELECT
  zero.name, 
  (min(lng - offset - if(lng-offset>180, 360, 0)) + 360) % 360 + offset as min,
  max(lng - offset - if(lng-offset>=180, 360, 0)) + offset as max
FROM
   (SELECT 
      min(lng) as offset, 
      name FROM places group by name
   ) as zero
LEFT JOIN places ON (places.name = zero.name)

mlebkowski

<?php

interface Discount
{
  /**
   * @return int
   */
  function getDiscountValue(Order $order);
}

mlebkowski

<?php
  
  
  $data = [
    ["calendar_id" => 1, "doctor_id" => 1, "date" => "2013-01-01"],
    ["calendar_id" => 1, "doctor_id" => 2, "date" => "2013-01-03"],
    ["calendar_id" => 1, "doctor_id" => 1, "date" => "2013-01-03"],
    
    ["calendar_id" => 2, "doctor_id" => 4, "date" => "2013-01-01"],
    ["calendar_id" => 2, "doctor_id" => 4, "date" => "2013-01-01"],

mlebkowski

#!/usr/local/bin/node

var irc = require('irc');
var http = require('http');

var opts = {
    userName: 'docplanner',
    realName: 'Doctor Planner',
    autoRejoin: false,
    channels: ['#docplanner'],        

mlebkowski

root@bob /h/mlebkowski# docker run -t -d base bash -c 'trap date SIGTERM SIGKILL SIGSTOP; while true; do sleep 1; done'
57a333488199
root@bob /h/mlebkowski# docker logs 57a333488199
root@bob /h/mlebkowski# docker stop 57a333488199
57a333488199
root@bob /h/mlebkowski# docker logs 57a333488199
Fri Dec  6 13:09:40 UTC 2013

mlebkowski

web: node index.js

mlebkowski

<?php
function updateSphinxRTIndex($isDelete = false)
{
	$indexer = Xplod::getInstance()->getContainer()->get('search.listener.realtime_indexer');
	
	$propelModel = $this->toPropelModel();
	if ($this->isNew())
	{
		$indexer->queueInsert($propelModel);
	}

mlebkowski

<?php

class SeasonalityFactor
{
	const FORMAT = 'M';
	/**
	 * @var array
	 */
	private $modifiers = array ();

mlebkowski

INSERT INTO `reach` (`id`, `day`, `value`)
VALUES
	(1, 1, 0.0743),
	(2, 2, 0.1244),
	(3, 3, 0.1682),
	(4, 4, 0.2060),
	(5, 5, 0.2407),
	(6, 6, 0.2780),
	(7, 7, 0.3153),
	(8, 8, 0.3496),

mlebkowski

DROP TABLE IF EXISTS `address_service_copy`;

DROP TABLE IF EXISTS `address_service_temp2`;

ALTER TABLE `crm_gratis_commercial` CHANGE `trader_id` `trader_id` INTEGER(10) NOT NULL;

ALTER TABLE `disease_section` ADD CONSTRAINT `disease_section_FK_1`
    FOREIGN KEY (`disease_id`)
    REFERENCES `disease` (`id`);