Skip to content

Instantly share code, notes, and snippets.

View markbalt's full-sized avatar

Mark Baltrusaitis markbalt

View GitHub Profile
@markbalt
markbalt / gist:720f21ad02b67b4f6ff7
Created June 2, 2015 19:05
Customer MySQL Cursor
DROP PROCEDURE IF EXISTS curupdate;
delimiter //
CREATE PROCEDURE curupdate()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a INT;
DECLARE b CHAR(16);
DECLARE cur1 CURSOR FOR SELECT id,vantive_id FROM customer;
@markbalt
markbalt / gist:ddb4a48b4e685e7f2a1b
Created June 2, 2015 19:03
Visitor MySQL Trigger
DROP TRIGGER IF EXISTS `visitor_insert_t`;
DELIMITER ;;
CREATE TRIGGER `visitor_insert_t` AFTER INSERT ON `visitor` FOR EACH ROW BEGIN
IF NEW.arrival_date IS NOT NULL THEN
INSERT INTO `visit`(
`visitor_id`,
`location_id`,
@markbalt
markbalt / gist:6356805efbe1121a9129
Created June 1, 2015 15:29
Print Apache request headers
<pre><?php
print_r(apache_request_headers());
@markbalt
markbalt / gist:ad9d320c49b371c123aa
Created June 1, 2015 15:28
Log IP Keys (Symfony)
<?php
$ip_keys = array('HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR');
foreach ($ip_keys as $key) {
foreach (explode(',', $_SERVER[$key]) as $ip) {
$ip = trim($ip);
sfContext::getInstance()->getLogger()->err(sprintf('%s %s', $key, $ip));
}
}
@markbalt
markbalt / Simple Propel OR
Last active August 29, 2015 14:04
Propel OR
<?php
$crit0 = $c->getNewCriterion(TicketRelatedPeer::A_ID, $id);
$crit1 = $c->getNewCriterion(TicketRelatedPeer::B_ID, $id);
$crit0->addOr($crit1);
$c->add($crit0);
@markbalt
markbalt / ModalandrenderJS
Created June 19, 2014 13:30
Render Modal form with widget field that requires renderJS
<?php
protected function executeModalFormAjax(sfWebRequest $request)
{
eval(sprintf
(
'$form = new %sForm();',
$request->getParameter('form')
));
return (string) $form.' <script>'.$form['user_id']->renderJS().'</script>';
}
@markbalt
markbalt / Add parameter(s) to a form request
Created June 18, 2014 19:10
Add parameter(s) to a Symfony form request
$request->setParameter('widget_user', array_merge(
$request->getParameter('widget_user'),
array(
'row' => $request->getParameter('row'),
'col' => $request->getParameter('col')
)
));
<li><a href="#"><span class="glyphicon glyphicon-bell"></span> <span class="badge"><?php echo number_format($sf_user->getGuardUser()->countUnreadEvents()); ?></span></a></li>
@markbalt
markbalt / QuoteoverrideTemplateIndexSidebar
Last active August 29, 2015 14:01
Applies additional presets before returning the kuWidgetSidebar object.
<?php
/**
* Applies additional presets before returning the kuWidgetSidebar object.
*
* @return kuWidgetSidebar
*/
protected function overrideTemplateIndexSidebar()
{
$sidebar = parent::overrideTemplateIndexSidebar();
@markbalt
markbalt / Issues in Milestone
Created February 26, 2013 15:23
Generates summary of open tickets in a milestone using Github API/cURL
<?php
date_default_timezone_set('America/New_York');
error_reporting(E_ALL);
ini_set("display_errors", "1");
$username = '';
$password = '';
$request = array(
"state" => "open",