Mesmerizing Moments | sarathdr.com

Trip to Scotland

Sarath D R — Tue, 15 Nov 2011 23:53:05 +0000

Falling yet beautiful

Last weekend had a nice trip to Scotland. We planned go by bus then later decided to go by train. It was amazing to see the scenic greenery which I thought I could find it only in my sweetest home land. The creativity of the world is endless and I wish I would be able to see as much as I can in my short life span . Even if it was very cold compared to London we enjoyed the whole trip and never missed to have a cold stream bath in -1 degree .

Spring left me floating

Sorrow and gladness are linked together

Macro

Hdr View

Snaps from Brighton

Sarath D R — Mon, 31 Oct 2011 23:36:22 +0000

It was a long term wish to visit Brighton since I landed London. It never happened in summer time even though planned several times with wife to go there. Last Sunday decided to go Brighton with one of my best friends without any plans. It was a nice trip rather than expected. Following are some snaps taken from Brighton beach.

Brighton Motorist

Seabird

Street light

Brighton motorist

Generate XML form two dimensional Array

Sarath D R — Fri, 07 Oct 2011 14:15:30 +0000

I have searched a lot for php code to generate xml from a two dimensional array. But all of them was not working perfectly. The following code generates xml file from a two dimensional array. This only works for the array with the following structure.

array(1) {
  ["share_friend_list"]=>;
  array(3) {
    ["your_name"]=>
    string(12) "Sarath"
    ["friends"]=>
    array(1) {
      ["friend"]=>
      array(3) {
        [0]=>
        array(2) {
          ["name"]=>
          string(6) "Ryan"
          ["msisdn"]=>
          string(9) "213412414"
        }
        [1]=>
        array(2) {
          ["name"]=>
          string(12) "Nash"
          ["msisdn"]=>
          string(9) "123423421"
        }
        [2]=>
        array(2) {
          ["name"]=>
          string(9) "Ashish"
          ["msisdn"]=>
          string(9) "123421342"
        }
      }
    }
    ["your_email"]=>
    string(19) "sarath.dr@gmail.com"

        $filePath = $this->xmlFilePath.$this->today.' - '.$type.'.xml';
        $this->doc->formatOutput = true;
 
        if( ! file_exists( $filePath ) )
        {
               $r = $this->doc->createElement( "data" );
               $this->doc->appendChild( $r );
        }
        else
        {
            @$this->doc->load( $filePath );
            $r  = $this->doc->getElementsByTagName('data')->item(0);
        }
 
        $this->extract( $info , $r  );
 
        try
        {
 
            $this->doc->saveXML();
            $this->doc->save( $filePath );
        }
        catch ( Exception $e )
        {
 
        }

 public function extract( $info , $b )
    {
 
        if( is_array( $info ) && is_array( $info[ key($info)]) )
        {
                $temp = $b;
 
                // New parent node
                if( is_integer(  key($info) )  )
                {
                     $this->extract( $info[ key($info)], $b );
                     if( count( array_slice(  $info , 1 ) ) &gt; 0  )
                     $b = $this->parentNode->appendChild( $this->doc->createElement( $this->parentName ));
                }
               else
                {   // Inner nodes 
                    $b = $b->appendChild(  $this->doc->createElement( key($info) ) ) ;
 
                    $this->parentNode = $temp;
                    $this->parentName = key($info); 
                    $this->extract( $info[ key($info)], $b );
                    $b = $temp;
 
                }
 
        }
        else
        {
            $temp = $this->doc->createElement( key($info) );
            $temp->appendChild( $this->doc->createTextNode( $info[ key($info)] ) );
 
            $b->appendChild( $temp );
 
        }
 
        $newArray = array_slice(  $info , 1 ) ;
 
        if( is_array( $newArray ) && count( $newArray ) > 0  )
        {
               $this->extract( $newArray, $b );
        }
        else
        {
            return;
        }
 
    }

Out put XML.

 
 version="1.0"?>
>
  >
    >Sarath>
    >
      >
        >Ryan>
        >213412414>
      >
      >
        >Nash>
        >123423421>
      >
      >
        >Ashish>
        >123421342>
      >
    >
    >sarath.dr@gmail.com>
  >
>

Symfony Doctrine pagination script

Sarath D R — Fri, 23 Sep 2011 13:00:29 +0000

Symfony paginator

We usually need database record pagination in symfony with filters. It is very simple and easy to implement in . The below code will be helpful for you to create pagination in Symfony.

Please add the following code in action.

$this->pager = new sfDoctrinePager('Myclass',10);
$this->pager->getQuery();
 
// If you have filers in the to apply in the db query add the following code 
$this->pager->getQuery()->from('Myclass a')->where('a.column_name LIKE ?' , '%'.$searchString.'%');
 
 $this->pager->setPage($this->getRequestParameter('page',1));
 $this->pager->init();
 
// Code to get the query string 
$this->queryString = $this->getContext()->getInstance()->getRouting()->getCurrentInternalUri();

It will be useful if you create a helper file to generate the navigation. Please add the following function to the helper file.

 
function pager_navigation($pager, $uri)
{
  $navigation = array();
 
  if ($pager->haveToPaginate())
  {
    $uri .= (preg_match('/\?/', $uri) ? '&' : '?').'page=';
 
    // First and previous page
    if ($pager->getPage() != 1)
    {
      $navigation[] = link_to('First', $uri.'1');
      $navigation[] = link_to('Previous', $uri.$pager->getPreviousPage());
    }
 
    // Pages one by one
    $links = array();
    foreach ($pager->getLinks() as $page)
    {
      $navigation[] = link_to_unless($page == $pager->getPage(), $page, $uri.$page);
    }
    // $navigation .= join('  ', $links);
 
    // Next and last page
    if ($pager->getPage() != $pager->getLastPage())
    {
      $navigation[] = link_to( 'Next', $uri.$pager->getNextPage());
      $navigation[] = link_to( 'Last', $uri.$pager->getLastPage());
    }
 
  }
 
  $returnHtml = "";
 
  foreach( $navigation  as $link )
  {
     $returnHtml .= "".$link."
";
  }
 
  $returnHtml .= "
";
  return $returnHtml;
 
}

You can call the above function from the template file. Also add the below code to display records.

     foreach ($pager->getResults() as $record ): ?>
 
     endforeach; ?>
 
// Show navigation 
  echo pager_navigation( $pager, url_for( 'module/action?'.html_entity_decode($queryString) , true ) ); ?>

if you are looking for a quick styling the navigation you can use the following css styling for the pagination navigator links.

 
 
 
#pagination li{
	border:0;
	margin:0;
	padding: 0px; 
	font-size:12px;
	list-style:none;
	margin-right:5px;
	float: left;
	text-indent: 0px;
}
#pagination a{
	border:solid 1px #9aafe5;
	padding: 5px;
	display: block;
	text-decoration: none;
}
 
#pagination span {
	display: block;
	padding: 5px;
	color: #ffffff;
	font-weight:bold;
	background:#2e6ab1;
}
 
#pagination .active {
 
	background:#2e6ab1;
	color:#FFFFFF;
	font-weight:bold;
	display:block;
	float:left;
	padding:4px 6px;
}

The scene which disappeared from Kerala

Sarath D R — Sun, 18 Sep 2011 19:50:43 +0000

Karnataka

This shot was taken from Mysore. Hope we can use this images to explain our kid, how the farming was done in ancient days. In kerala Most of our paddy fields are being replaced with concrete buildings. But we could see something remains in Kuttanadu and Palakkadu. I was very happy after the journey from Mysore, purchased fresh vegetables for Onam in half price and 10 kg of flowers around 1/4 price as compared to the price in Kerala.

New Camera – Macro experiments

Sarath D R — Thu, 28 Jul 2011 00:53:33 +0000

Shot from Central park London

After a long gap I have managed to buy a new camera Nikon D 90. Still not familiar with most of the functionality but experimenting with great excitement. I took some macro shots when I get some free time before going to register with GP. All shots are taken between 30 minutes time. Time is the main concern these days.

Get Symfony web root Url without Script name

Sarath D R — Fri, 22 Jul 2011 14:16:48 +0000

I had a requirement to access an image inside a folder in the web root folder in symfony. I came across a solution but I am not sure this is the only way to get the url to path. Please add a comment if you have any other solution.

For example, Let your path to the web folder be “project/trunk/web”. The following code will output ”project/trunk/web”

sfContext::getInstance()->getRequest()->getRelativeUrlRoot();

You will get the base url by

sfContext::getInstance()->getRequest()->getUriPrefix()

You can concatenate both string to get the result.

http:://localhost/project/trunk/web

Install Symfony Plugins manually

Sarath D R — Sun, 17 Jul 2011 00:58:02 +0000

There was some problem occurred to my PEAR installation in my laptop so I was unable to install symfony plugins. At last I solved the issue by manually installing the plugin. Following steps are involved in the manual installation of the symfony plugin. Consider installing symfony XLS reader Plugin.

Download the plugin from here
Unzip the files and copy the folder to plugins/ folder with folder name sfPhpExcelPlugin
Edit the configuration file config/ProjectConfiguration.class.phpsee below example
```
 $this->enablePlugins( array('sfDoctrinePlugin', 'sfPhpExcelPlugin') );
```
Finally run the following command
```
php symfony plugin:publish-assets
```

Symfony Doctrine – Useful commands

Sarath D R — Sat, 09 Jul 2011 00:01:35 +0000

I always forget the Symfony doctrine commands. This post will be useful for you remember them as well. I can also refer it . This is not the complete list, but I will add it eventually.

Creates Application:

 $ php symfony generate:app

Create Module:

 $ php symfony generate:module

Creates database for current model

 $ php symfony doctrine:build-db

Creates classes for current model

 $ php symfony doctrine:build-model

Creates schema.yml from current database

 $ php symfony doctrine:build-schema

Creates sql for the current model

 $ php symfony doctrine:build-sql

Inserts sql for the current model

 $ php symfony doctrine:insert-sql

Symfony project deploy dry run

 $ php symfony project:deploy  -t

Symfony deploy project

 $ php symfony project:deploy  -t --go

Generates language files

 $ php symfony i18n:extract --auto-save

Doctrine Query to find out rank of a column value

Sarath D R — Wed, 29 Dec 2010 19:13:20 +0000

Symfony doctrine query to find out rank of a column value

Following is an easy symfony doctrine query to find out rank of a particular column value in a table. Suppose if you need to find out the rank of a user with the reference to the column ‘marks’, use the following query.

‘Stats’ is the name of the table

$q = Doctrine_Query::create()
                           ->select('((SELECT COUNT(1) AS num FROM stats  WHERE stats.marks  > s.marks ) + 1)  AS rank')
                           ->from('Stats s')
                           ->where('s.user_id = ?', $user_id )
                           ->orderBy('rank');
 
             $result = $q->fetchOne();